{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry Sheet","Marking Sheet","Application Form","Test Details","CSV Export"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Entry Sheet","index":0,"n_rows":60,"n_cols":26,"rows_kept":60,"cut":false,"hidden":false,"merged":[[48,6,48,11],[49,6,49,11],[50,6,50,11],[51,6,51,11],[42,20,42,22],[41,1,41,5],[30,26,30,28],[31,26,31,28],[28,9,28,11],[29,2,29,8],[29,9,29,11],[32,2,32,8],[28,2,28,8],[30,2,30,8],[30,9,30,11],[37,2,37,8],[37,9,37,11],[37,26,37,28],[41,6,41,11],[42,6,42,11],[40,1,40,11],[38,1,38,11],[51,20,51,22],[43,14,43,16],[60,1,60,9],[59,1,59,11],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[53,1,53,5],[54,7,54,11],[52,1,52,5],[55,7,55,11],[56,7,56,11],[52,6,52,11],[53,6,53,11],[43,6,43,11],[44,6,44,11],[45,6,45,11],[46,6,46,11],[47,6,47,11],[36,9,36,11],[33,2,33,8],[31,2,31,8],[31,9,31,11],[34,2,34,8],[34,9,34,11],[35,2,35,8],[33,9,33,11],[32,9,32,11],[35,9,35,11],[36,2,36,8],[7,1,7,11],[1,1,1,11],[2,1,2,11],[25,0,25,11],[11,1,11,11],[9,1,9,11],[19,0,19,3],[10,1,10,11],[12,1,12,11],[17,6,17,7],[4,1,4,11],[14,17,14,18],[17,8,17,9],[15,17,15,18],[20,1,20,3],[26,2,26,8],[29,30,29,32],[8,1,8,11],[14,15,14,16],[15,15,15,16],[14,19,14,21],[15,19,15,21],[26,9,26,11],[27,2,27,8],[27,9,27,11],[27,26,27,28],[28,26,28,28],[29,26,29,28],[25,29,26,29],[25,30,26,32],[25,38,26,40],[25,41,26,41],[27,38,27,40],[25,42,26,44],[41,30,41,32],[39,34,39,36],[32,38,32,40],[39,22,39,24],[39,26,39,28],[39,30,39,32],[41,26,41,28],[34,30,34,32],[41,38,41,40],[40,22,40,24],[40,26,40,28],[40,30,40,32],[38,30,38,32],[32,26,32,28],[36,26,36,28],[35,26,35,28],[35,30,35,32],[33,26,33,28],[34,38,34,40],[32,30,32,32],[30,46,30,48],[31,46,31,48],[32,46,32,48],[33,46,33,48],[25,54,26,54],[27,46,27,48],[27,42,27,44],[25,45,26,45],[25,46,26,48],[24,53,26,53],[33,30,33,32],[39,38,39,40],[38,34,38,36],[38,38,38,40],[35,34,35,36],[36,34,36,36],[41,34,41,36],[40,34,40,36],[28,46,28,48],[28,42,28,44],[29,42,29,44],[31,38,31,40],[28,38,28,40],[31,34,31,36],[32,34,32,36],[33,34,33,36],[30,42,30,44],[33,38,33,40],[29,38,29,40],[30,38,30,40],[32,42,32,44],[33,42,33,44],[31,42,31,44],[29,46,29,48],[25,33,26,33],[25,34,26,36],[29,34,29,36],[31,30,31,32],[30,30,30,32],[30,34,30,36],[25,37,26,37],[28,34,28,36],[27,34,27,36],[27,30,27,32],[28,30,28,32],[53,14,53,16],[53,20,53,22],[34,46,34,48],[36,30,36,32],[40,38,40,40],[39,42,39,44],[34,42,34,44],[36,42,36,44],[40,42,40,44],[35,42,35,44],[40,46,40,48],[35,46,35,48],[36,46,36,48],[35,38,35,40],[36,38,36,40],[41,42,41,44],[41,46,41,48],[38,42,38,44],[34,34,34,36],[42,14,42,16],[34,26,34,28],[52,14,52,16],[52,20,52,22],[50,20,50,22],[44,14,44,16],[45,14,45,16],[46,14,46,16],[47,14,47,16],[48,14,48,16],[49,14,49,16],[50,14,50,16],[51,14,51,16],[43,20,43,22],[44,20,44,22],[45,20,45,22],[46,20,46,22],[47,20,47,22],[48,20,48,22],[49,20,49,22],[37,30,37,32],[37,34,37,36],[37,38,37,40],[37,42,37,44],[37,46,37,48],[41,20,41,22],[41,14,41,16],[38,22,38,24],[38,26,38,28],[39,17,39,19],[38,17,38,19]]}
[]
[null,"SKATE AUSTRALIA PROFICIENCY TEST"]
[null,"DATA ENTRY SHEET"]
[]
[null,"SA PROFICIENCY TEST FORM VERSION 2025-01\n(requires Microsoft Excel 2010 or later installed on the computer)"]
[]
[]
["NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M"]
["SA NO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
["CLUB:"]
["TEST CENTRE:"]
["TEST DATE:"]
["PARTNER:\n(Dance/Freedance/ Freeskating Pairs only)"]
[]
["TEST DISCIPLINE","Dance Pairs","Solo Dance","Figures","Figure Loop","Free Skating","Freedance Pairs","Solo Freedance","Free Skating Pairs","In-Line Free Skating","Precision","Proficiency Certificate",null,null,null,{"$f":"IF(B$16<>\"\",+B$15,IF(C$16<>\"\",+C$15,IF(D$16<>\"\",+D$15,IF(E$16<>\"\",+E$15,IF(F$16<>\"\",+F$15,0)))))","v":0},null,{"$f":"IF(G$16<>\"\",+G$15,IF(H$16<>\"\", +H$15,IF(I$16<>\"\",+I$15,IF(J$16<>\"\",+J$15,IF(K$16<>\"\",+K$15,IF(L$16<>\"\",L$15,0))))))","v":0},null,{"$f":"IF(P$15<>0,+P$15,+R15)","v":0}]
["TEST No.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($C$16)","v":""},{"$f":"IF(B$16<>\"\",+B$16,IF(C$16<>\"\",+C$16,IF(D$16<>\"\",+D$16,IF(E$16<>\"\",+E$16,IF(F$16<>\"\",+F$16,0)))))","v":0},null,{"$f":"IF(G$16<>\"\",+G$16,IF(H$16<>\"\",+H$16,IF(I$16<>\"\",+I$16,IF(J$16<>\"\",+J$16,IF(K$16<>\"\",+K$16,IF(L$16<>\"\",+L$16,0))))))","v":0},null,{"$f":"IF(P$16<>0,+P$16,+R16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dance Pairs","Solo Dance","Figures","Figure Loop","Free Skating","Freedance Pairs","Solo Freedance","Free Skating Pairs","In-Line Free Skating","Precision","Proficiency Certificate"]
["Date of previous test in this discipline (whether passed or failed)",null,null,"Fee Paid:",null,null,"Award:",null,{"$f":"IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$J,7,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$J,7,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP($O18,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O18,'Test Details'!$D:$F,2,FALSE)))","v":""},null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,2,2,2,2,2,2,2,2]
["Freeskating Singles/Pairs/Freedance/Precision only:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3]
["Maximum time:",{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$J,6,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$J,6,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$H,4,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$H,4,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$H,4,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$H,4,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,null,4,4,4,4,4,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,null,null,5]
["Minimum mark:","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,6,null,6,null,null,6]
["Passing grade:","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,7,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,8,null,8]
["Dances, Figures, Loops, Technical Merit & Artistic Impression",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,9]
[null,null,"Name of Dance and Rhythm  OR  T.M./A.I.",null,null,null,null,null,null,"Enter Solo Star Dances Here",null,null,null,null,null,10,10,10]
["1.",{"$f":"IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J28),IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$F,3,FALSE))),J28)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$15>0,MATCH($P$16,$B$16:$L$16),MATCH($R$16,$B$16:$L$16))","v":{"$error":"#N/A"}},{"$f":"OFFSET($A$15,0,N28)&OFFSET($A$16,0,N28)&A28","v":{"$error":"#N/A"}},11,11,11]
["2.",{"$f":"IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J29),IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$F,3,FALSE))),J29)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P$15>0,MATCH($P$16,$B$16:$L$16),MATCH($R$16,$B$16:$L$16))","v":{"$error":"#N/A"}},{"$f":"OFFSET($A$15,0,N29)&OFFSET($A$16,0,N29)&A29","v":{"$error":"#N/A"}},12,12,12]
["3.",{"$f":"IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J30),IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$F,3,FALSE))),J30)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,13,13]
["4.",{"$f":"IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J31),IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$F,3,FALSE))),J31)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,14,14]
["5.",{"$f":"IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J32),IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$F,3,FALSE))),J32)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,15,15]
["6.",{"$f":"IF(ISNA(VLOOKUP($O33,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O33,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J33),IF(ISNA(VLOOKUP($O33,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O33,'Test Details'!$D:$F,3,FALSE))),J33)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"BS"]
["7.",{"$f":"IF(ISNA(VLOOKUP($O34,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O34,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J34),IF(ISNA(VLOOKUP($O34,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O34,'Test Details'!$D:$F,3,FALSE))),J34)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"SS"]
["8.",{"$f":"IF(ISNA(VLOOKUP($O35,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O35,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J35),IF(ISNA(VLOOKUP($O35,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O35,'Test Details'!$D:$F,3,FALSE))),J35)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"GS"]
["9.",{"$f":"IF(ISNA(VLOOKUP($O36,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O36,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J36),IF(ISNA(VLOOKUP($O36,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O36,'Test Details'!$D:$F,3,FALSE))),J36)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["10.",{"$f":"IF(ISNA(VLOOKUP($O37,'Test Details'!$D:$F,2,FALSE)),\"\",(VLOOKUP($O37,'Test Details'!$D:$F,2,FALSE)))","v":""},{"$f":"IF(ISBLANK(J37),IF(ISNA(VLOOKUP($O37,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O37,'Test Details'!$D:$F,3,FALSE))),J37)","v":""},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"OFFSET($A$15,0,N38)&OFFSET($A$16,0,N38)&A38","v":{"$error":"#N/A"}}]
["Name of Authorised Person submitting application:"]
[]
["CONTENT LIST :  ","SOLO FREE DANCE, COUPLES FREE DANCE, PAIRS, INLINE FREE SKATING and PRECISION\nChoose elements from the REQUIREMENTS LIST\nEnter your elements in order of skating in REQUIREMENTS SELECTED\n\nThe Referee's Marking Sheet must be signed by the Skater/s regardless of age, and if a Skater is under 18 years of age, also signed by the Coach or Parent/Guardian, before submitting it to the Test Supervisor"]
["A.","REQUIREMENTS SELECTED",null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O42,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O42,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF($P$15>0,MATCH($P$16,$B$16:$L$16),MATCH($R$16,$B$16:$L$16))","v":{"$error":"#N/A"}},{"$f":"IF(U42=\"\",\"\",U42&Y42&Z42)","v":{"$error":"#N/A"}},null,null,"=IF(ISNA(VLOOKUP($O42,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O42,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$f":"IF(OR(N42=5,N42=6, N42=7,N42=8,N42=9,N42=10),OFFSET($A$15,0,N42)&\" Requirements\",\"\")","v":{"$error":"#N/A"}},null,null,null,{"$f":"OFFSET($A$16,0,$N42)","v":{"$error":"#N/A"}},{"$f":"$A42","v":"A."}]
["1.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O43,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O43,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(U43=\"\",\"\",U43&Y43&Z43)","v":{"$error":"#N/A"}},null,null,"=IF(ISNA(VLOOKUP($O43,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O43,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$f":"IF(OR(N43=5,N43=6, N43=7,N43=8,N43=9,N43=10),OFFSET($A$15,0,N43)&\" Requirements\",\"\")","v":{"$error":"#N/A"}},null,null,null,{"$f":"OFFSET($A$16,0,$N43)","v":{"$error":"#N/A"}},{"$f":"$A43","v":"1."}]
["2.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O44,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O44,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O44,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O44,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$f":"$A44","v":"2."}]
["3.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O45,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O45,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O45,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O45,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"3."]
["4.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O46,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O46,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O46,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O46,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"4."]
["5.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O47,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O47,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O47,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O47,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"5."]
["6.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O48,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O48,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O48,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O48,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"6."]
["7.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O49,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O49,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O49,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O49,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"7."]
["8.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O50,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O50,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O50,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O50,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"8."]
["9.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O51,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O51,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O51,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O51,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"9."]
["10.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},"10."]
["11.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O53,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O53,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(U53=\"\",\"\",U53&Y53&Z53)","v":{"$error":"#N/A"}},null,null,"=IF(ISNA(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$f":"IF(OR(N53=5,N53=6, N53=7,N53=8,N53=9,N53=10),OFFSET($A$15,0,N53)&\" Requirements\",\"\")","v":{"$error":"#N/A"}},null,null,null,{"$error":"#N/A"},"11."]
["12.",null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($O54,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O54,'Test Details'!$D:$F,3,FALSE)))","v":""},null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(U54=\"\",\"\",U54&Y54&Z54)","v":{"$error":"#N/A"}},null,null,"=IF(ISNA(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)),\"\",(VLOOKUP($O52,'Test Details'!$D:$F,3,FALSE)))",null,null,{"$f":"IF(OR(N54=5,N54=6, N54=7,N54=8,N54=9,N54=10),OFFSET($A$15,0,N54)&\" Requirements\",\"\")","v":{"$error":"#N/A"}},null,null,null,{"$error":"#N/A"},"12."]
[]
[null,null,null,null,null,null,null,"Where do you want to save this Test Centre?"]
[null,null,null,null,null,null,null,"C:\\Temp"]
[]
[]
["FileName"]

{"sheet":"Marking Sheet","index":1,"n_rows":178,"n_cols":11,"rows_kept":178,"cut":false,"hidden":false,"merged":[[94,0,94,1],[94,2,94,6],[133,2,133,6],[119,8,119,10],[146,9,146,10],[136,0,136,1],[136,2,136,6],[148,9,148,10],[139,5,139,8],[144,6,144,8],[121,8,121,10],[130,0,130,10],[122,1,122,5],[126,6,127,10],[126,0,127,5],[133,0,133,1],[143,9,143,10],[143,2,144,3],[143,6,143,8],[122,8,122,10],[134,7,134,8],[134,2,134,6],[134,0,134,1],[95,8,95,9],[173,0,174,7],[171,8,171,10],[145,9,145,10],[144,9,144,10],[149,2,150,3],[150,5,150,8],[100,0,101,1],[166,1,166,5],[165,1,165,5],[158,8,158,10],[161,8,161,10],[159,1,159,5],[160,8,160,10],[113,8,114,10],[113,6,113,7],[123,8,123,10],[118,8,118,10],[124,1,124,5],[119,1,119,5],[124,8,124,10],[117,8,117,10],[113,0,114,5],[145,6,145,8],[111,0,111,10],[166,8,166,10],[150,9,150,10],[147,6,147,8],[155,0,155,10],[163,8,163,10],[159,8,159,10],[160,1,160,5],[156,6,156,7],[149,9,149,10],[161,1,161,5],[156,8,157,10],[146,0,147,1],[146,2,147,3],[148,6,148,8],[149,0,150,1],[158,1,158,5],[151,0,152,3],[146,6,146,8],[149,6,149,8],[147,9,147,10],[154,0,154,10],[34,8,34,10],[33,1,33,5],[10,2,11,3],[12,2,12,3],[45,0,45,10],[49,0,49,1],[49,2,49,6],[29,8,29,10],[31,1,31,5],[32,1,32,5],[49,7,49,8],[40,0,41,5],[40,6,41,10],[47,0,47,1],[35,8,35,10],[36,8,36,10],[38,8,38,10],[44,0,44,10],[34,1,34,5],[30,8,30,10],[35,1,35,5],[36,1,36,5],[23,5,23,7],[37,1,37,5],[33,8,33,10],[30,1,30,5],[31,8,31,10],[6,2,6,6],[6,0,6,1],[6,7,6,8],[13,6,13,9],[7,0,7,1],[7,2,7,6],[12,6,12,9],[12,0,12,1],[15,6,15,9],[14,6,14,9],[14,2,15,3],[27,6,27,7],[16,6,16,9],[17,2,18,3],[17,6,17,9],[19,6,19,9],[26,0,26,10],[29,1,29,5],[14,0,15,1],[32,8,32,10],[18,6,18,9],[1,0,1,10],[2,0,2,10],[4,0,4,1],[5,0,5,1],[4,2,4,6],[5,7,5,8],[5,2,5,6],[8,0,8,1],[10,0,11,1],[8,2,8,6],[9,0,9,3],[11,6,11,9],[10,5,10,9],[9,8,9,9],[20,6,20,9],[27,0,28,5],[27,8,28,10],[22,0,23,3],[21,5,21,9],[20,0,21,1],[17,0,18,1],[20,2,21,3],[25,0,25,10],[22,5,22,7],[22,8,23,10],[37,8,37,10],[80,1,80,5],[75,1,75,5],[75,8,75,10],[74,1,74,5],[74,8,74,10],[78,1,78,5],[76,8,76,10],[77,1,77,5],[73,1,73,5],[60,6,60,9],[61,6,61,9],[57,0,58,1],[57,6,57,9],[57,2,58,3],[63,0,64,1],[79,8,79,10],[72,1,72,5],[72,8,72,10],[77,8,77,10],[78,8,78,10],[79,1,79,5],[50,2,50,6],[47,2,47,6],[38,1,38,5],[52,0,52,3],[51,2,51,6],[70,6,70,7],[64,5,64,9],[65,0,66,3],[62,6,62,9],[63,6,63,9],[53,2,54,3],[55,0,55,1],[55,6,55,9],[58,6,58,9],[53,5,53,9],[69,0,69,10],[56,6,56,9],[55,2,55,3],[68,0,68,10],[66,5,66,7],[39,1,39,5],[39,8,39,10],[51,0,51,1],[48,2,48,6],[54,6,54,9],[48,7,48,8],[70,0,71,5],[48,0,48,1],[50,0,50,1],[82,1,82,5],[82,8,82,10],[59,6,59,9],[53,0,54,1],[70,8,71,10],[63,2,64,3],[60,0,61,1],[60,2,61,3],[65,5,65,7],[65,8,66,10],[73,8,73,10],[81,1,81,5],[81,8,81,10],[80,8,80,10],[76,1,76,5],[52,8,52,9],[175,0,176,7],[175,8,175,10],[176,8,176,10],[106,0,107,1],[106,6,106,9],[121,1,121,5],[123,1,123,5],[120,1,120,5],[120,8,120,10],[139,9,139,10],[139,0,140,1],[140,9,140,10],[139,2,140,3],[142,9,142,10],[131,0,131,10],[117,1,117,5],[115,8,115,10],[135,2,135,6],[135,7,135,8],[141,6,141,8],[118,1,118,5],[116,8,116,10],[116,1,116,5],[115,1,115,5],[172,8,172,10],[103,0,104,1],[171,0,172,7],[104,6,104,9],[87,0,87,10],[91,2,91,6],[103,6,103,9],[100,6,100,9],[90,0,90,1],[90,2,90,6],[108,5,108,7],[108,8,109,10],[151,5,151,7],[151,8,152,10],[152,5,152,7],[169,0,170,4],[169,5,169,7],[170,5,170,7],[169,8,170,10],[98,2,98,3],[98,0,98,1],[88,0,88,10],[92,7,92,8],[93,0,93,1],[83,6,84,10],[83,0,84,5],[141,9,141,10],[105,6,105,9],[97,6,97,9],[96,0,97,1],[95,0,95,3],[112,0,112,10],[108,0,109,3],[103,2,104,3],[102,6,102,9],[101,6,101,9],[96,5,96,9],[100,2,101,3],[99,6,99,9],[98,6,98,9],[107,5,107,9],[106,2,107,3],[109,5,109,7],[125,1,125,5],[125,8,125,10],[137,0,137,1],[138,0,138,3],[141,0,141,1],[138,9,138,10],[91,7,91,8],[91,0,91,1],[96,2,97,3],[168,1,168,5],[168,8,168,10],[93,2,93,6],[92,0,92,1],[92,2,92,6],[143,0,144,1],[135,0,135,1],[137,2,137,6],[141,2,141,3],[142,6,142,8],[140,6,140,8],[167,8,167,10],[162,1,162,5],[162,8,162,10],[165,8,165,10],[163,1,163,5],[164,1,164,5],[164,8,164,10],[167,1,167,5],[156,0,157,5]]}
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
["NAME:",null,{"$f":"'Data Entry Sheet'!B8","v":0}]
["CLUB:",null,{"$f":"'Data Entry Sheet'!B10","v":0},null,null,null,null,"SA No",null,null,{"$f":"'Data Entry Sheet'!B9","v":0}]
["TEST CENTRE",null,{"$f":"+'Data Entry Sheet'!B$11","v":0},null,null,null,null,"TEST DATE",null,null,{"$f":"+'Data Entry Sheet'!B$12","v":"00:00:00"}]
["PARTNER",null,{"$f":"+'Data Entry Sheet'!B$13","v":0}]
[null,null,"(for Dance/Free Dance/Freeskating Pairs only)"]
[null,null,null,null,null,null,null,null,"Judge Number",null,1]
["TEST",null,{"$f":"+'Data Entry Sheet'!T15","v":0},null,null,"Dances, T.M.& A.I.",null,null,null,null,"C/NYC"]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B$28","v":""},{"$f":"+'Data Entry Sheet'!C$28","v":""}]
["TEST No.",null,{"$f":"+'Data Entry Sheet'!T$16","v":0},null,null,{"$f":"+'Data Entry Sheet'!B$29","v":""},{"$f":"+'Data Entry Sheet'!C$29","v":""}]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B$30","v":""},{"$f":"+'Data Entry Sheet'!C$30","v":""}]
["Min Mark",null,{"$f":"+'Data Entry Sheet'!B$23","v":"N/A"},null,null,{"$f":"+'Data Entry Sheet'!B$31","v":""},{"$f":"+'Data Entry Sheet'!C$31","v":""}]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B32","v":""},{"$f":"+'Data Entry Sheet'!C$32","v":""}]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B33","v":""},{"$f":"+'Data Entry Sheet'!C$33","v":""}]
["Passing Grade",null,{"$f":"+'Data Entry Sheet'!B$24","v":"N/A"},null,null,{"$f":"+'Data Entry Sheet'!B34","v":""},{"$f":"+'Data Entry Sheet'!C$34","v":""}]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B35","v":""},{"$f":"+'Data Entry Sheet'!C$35","v":""}]
[null,null,null,null,null,{"$f":"+'Data Entry Sheet'!B36","v":""},{"$f":"+'Data Entry Sheet'!C$36","v":""}]
["Max Time",null,{"$f":"+'Data Entry Sheet'!B$21","v":""},null,null,{"$f":"+'Data Entry Sheet'!B37","v":""},{"$f":"+'Data Entry Sheet'!C$37","v":""}]
[null,null,null,null,null,"0VERALL ASSESSMENT - MUST BE COMPLETED BY THE JUDGE"]
["(Pairs/Free Dance/Precision)",null,null,null,null,"Judge - Print Name & Sign"]
[null,null,null,null,null,{"$f":"'Application Form'!N18","v":0}]
[]
["JUDGES - PLEASE NOTE THAT COMMENTS ARE MANDATORY FOR EACH REQUIREMENT TO SUPPORT THE C/NYC ASSESSMENT OF EACH REQUIREMENT"]
["CONTENT LIST"]
["REQUIREMENTS SELECTED",null,null,null,null,null,"ATTEMPTS",null,"COMMENTS"]
[null,null,null,null,null,null,1,2]
[{"$f":"IF(B30>0,+'Data Entry Sheet'!A43,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$43","v":0}]
[{"$f":"IF(B31>0,+'Data Entry Sheet'!A44,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$44","v":0}]
[{"$f":"IF(B32>0,+'Data Entry Sheet'!A45,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$45","v":0}]
[{"$f":"IF(B33>0,+'Data Entry Sheet'!A46,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$46","v":0}]
[{"$f":"IF(B34>0,+'Data Entry Sheet'!A47,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$47","v":0}]
[{"$f":"IF(B35>0,+'Data Entry Sheet'!A48,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$48","v":0}]
[{"$f":"IF(B36>0,+'Data Entry Sheet'!A49,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$49","v":0}]
[{"$f":"IF(B37>0,+'Data Entry Sheet'!A50,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$50","v":0}]
[{"$f":"IF(B38>0,+'Data Entry Sheet'!A51,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$51","v":0}]
[{"$f":"IF(B39>0,+'Data Entry Sheet'!A52,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$52","v":0}]
[{"$f":"IF(B40>0,+'Data Entry Sheet'!A53,\"\")","v":""},{"$f":"+'Data Entry Sheet'!B$53","v":0}]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
["NAME:",null,{"$f":"+C5","v":0}]
["CLUB:",null,{"$f":"+C6","v":0},null,null,null,null,"SA No",null,null,{"$f":"+K6","v":0}]
["TEST CENTRE",null,{"$f":"+C7","v":0},null,null,null,null,"TEST DATE",null,null,{"$f":"+K7","v":"00:00:00"}]
["PARTNER",null,{"$f":"+C8","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[null,null,null,null,null,null,null,null,"Judge Number",null,2]
["TEST",null,{"$f":"+C11","v":0},null,null,"Dances, T.M.& A.I.",null,null,null,null,"C/NYC"]
[null,null,null,null,null,{"$f":"+F12","v":""},""]
["TEST No.",null,{"$f":"+C13","v":0},null,null,"",""]
[null,null,null,null,null,"",""]
["Min Mark",null,{"$f":"+C15","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Passing Grade",null,{"$f":"+C18","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Max Time",null,{"$f":"+C21","v":""},null,null,"",""]
[null,null,null,null,null,"0VERALL ASSESSMENT - MUST BE COMPLETED BY THE JUDGE"]
["(Pairs/Free Dance/Precision)",null,null,null,null,"Judge - Print Name & Sign"]
[null,null,null,null,null,{"$f":"'Application Form'!N19","v":0}]
[]
["JUDGES - PLEASE NOTE THAT COMMENTS ARE MANDATORY FOR EACH REQUIREMENT TO SUPPORT THE C/NYC ASSESSMENT OF EACH REQUIREMENT"]
["CONTENT LIST"]
["REQUIREMENTS SELECTED",null,null,null,null,null,"ATTEMPTS",null,"COMMENTS"]
[null,null,null,null,null,null,1,2]
[{"$f":"+A30","v":""},0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
["NAME:",null,{"$f":"+C48","v":0}]
["CLUB:",null,{"$f":"+C49","v":0},null,null,null,null,"SA No",null,null,{"$f":"+K49","v":0}]
["TEST CENTRE",null,{"$f":"+C50","v":0},null,null,null,null,"TEST DATE",null,null,{"$f":"+K50","v":"00:00:00"}]
["PARTNER",null,{"$f":"+C51","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[null,null,null,null,null,null,null,null,"Judge Number",null,3]
["TEST",null,{"$f":"+C54","v":0},null,null,"Dances, T.M.& A.I.",null,null,null,null,"C/NYC"]
[null,null,null,null,null,{"$f":"+F55","v":""},""]
["TEST No.",null,{"$f":"+C56","v":0},null,null,"",""]
[null,null,null,null,null,"",""]
["Min Mark",null,{"$f":"+C58","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Passing Grade",null,{"$f":"+C61","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Max Time",null,{"$f":"+C64","v":""},null,null,"",""]
[null,null,null,null,null,"0VERALL ASSESSMENT - MUST BE COMPLETED BY THE JUDGE"]
["(Pairs/Free Dance/Precision)",null,null,null,null,"Judge - Print Name & Sign"]
[null,null,null,null,null,{"$f":"'Application Form'!N20","v":0}]
[]
["JUDGES - PLEASE NOTE THAT COMMENTS ARE MANDATORY FOR EACH REQUIREMENT TO SUPPORT THE C/NYC ASSESSMENT OF EACH REQUIREMENT"]
["CONTENT LIST"]
["REQUIREMENTS SELECTED",null,null,null,null,null,"ATTEMPTS",null,"COMMENTS"]
[null,null,null,null,null,null,1,2]
[{"$f":"+A73","v":""},0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
["NAME:",null,{"$f":"+C91","v":0}]
["CLUB:",null,{"$f":"+C92","v":0},null,null,null,null,"SA No",null,null,{"$f":"+K92","v":0}]
["TEST CENTRE",null,{"$f":"+C93","v":0},null,null,null,null,"TEST DATE",null,null,{"$f":"+K93","v":"00:00:00"}]
["PARTNER",null,{"$f":"+C94","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[null,null,null,null,null,null,null,null,null,"Referee"]
["TEST",null,{"$f":"+C97","v":0},null,null,"Dances, T.M.& A.I.",null,null,null,"Comments"]
[null,null,null,null,null,{"$f":"+F98","v":""},""]
["TEST No.",null,{"$f":"+C99","v":0},null,null,"",""]
[null,null,null,null,null,"",""]
["Min Mark",null,{"$f":"+C101","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Passing Grade",null,{"$f":"+C104","v":"N/A"},null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
["Max Time",null,{"$f":"+C107","v":""},null,null,"",""]
[]
["(Pairs/Free Dance/Precision)",null,null,null,null,"Referee - Print Name & Sign"]
[null,null,null,null,null,{"$f":"'Application Form'!N23","v":0}]
[]
[]
["CONTENT LIST"]
["REQUIREMENTS SELECTED",null,null,null,null,null,"ATTEMPTS",null,"COMMENTS"]
[null,null,null,null,null,null,1,2]
[{"$f":"+A116","v":""},0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["CONTENTS CHECKED BY REFEREE:",null,null,null,null,"Referee - Print Name & Sign"]
[null,null,null,null,null,{"$f":"'Application Form'!N23","v":0}]
["For Solo Free Dance, Couples Free Dance, Pairs, Inline Free Skating and Precision - this form MUST BE SIGNED BY THE SKATER regardless of age and submitted to the Test Supervisor"]
[null,null,null,null,null,null,null,null,"Skater's Signature"]
["Is this skater 18 years of age or older?"]
[]
["This form MUST BE SIGNED BY THE COACH, PARENT or GUARDIAN for skaters under 18 years of age BEFORE submitting to the Test Supervisor."]
[null,null,null,null,null,null,null,null,"Coach, Parent or Guardian Signature"]
["Original to be sent to CAOC Chair"]

{"sheet":"Application Form","index":2,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[37,8,37,11],[38,0,38,3],[38,4,38,7],[38,8,38,11],[39,0,39,3],[48,8,48,11],[49,0,49,3],[49,4,49,7],[49,8,49,11],[45,8,45,11],[46,0,46,3],[46,4,46,7],[46,8,46,11],[47,0,47,3],[47,4,47,7],[47,8,47,11],[42,8,42,11],[43,0,43,3],[43,4,43,7],[43,8,43,11],[44,0,44,3],[44,4,44,7],[44,8,44,11],[39,8,39,11],[33,8,33,11],[14,7,14,9],[14,5,14,6],[34,0,34,3],[50,0,50,3],[51,0,51,3],[34,4,34,7],[50,4,50,7],[51,4,51,7],[39,4,39,7],[42,0,42,3],[42,4,42,7],[45,0,45,3],[45,4,45,7],[48,0,48,3],[48,4,48,7],[50,8,50,11],[51,8,51,11],[35,0,35,3],[35,4,35,7],[35,8,35,11],[36,0,36,3],[36,4,36,7],[36,8,36,11],[1,0,1,9],[2,0,2,9],[7,8,7,9],[7,6,7,7],[7,1,7,4],[6,1,6,6],[8,8,8,9],[13,7,13,9],[8,6,8,7],[8,1,8,4],[9,1,9,4],[10,2,10,4],[11,2,11,4],[13,5,13,6],[13,2,13,4],[13,0,13,1],[12,2,12,4],[10,0,10,1],[11,0,11,1],[14,2,14,4],[26,1,26,6],[22,1,22,6],[15,1,15,2],[15,3,15,5],[14,0,14,1],[30,0,30,6],[33,4,33,7],[41,4,41,7],[37,0,37,3],[37,4,37,7],[15,6,15,9],[40,0,40,3],[40,4,40,7],[40,8,40,11],[41,0,41,3],[41,8,41,11],[34,8,34,11],[28,0,28,6],[33,0,33,3],[16,7,16,9],[16,0,17,6],[32,0,32,6],[18,1,18,6],[24,1,24,6],[30,7,30,9],[29,7,29,8],[20,1,20,6],[21,1,21,6],[19,1,19,6],[27,1,27,6],[29,0,29,6],[23,1,23,6],[25,1,25,6]]}
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["APPLICATION FORM"]
[]
[]
[]
["NAME:",{"$f":"'Data Entry Sheet'!B8","v":0}]
["CLUB:",{"$f":"+'Data Entry Sheet'!B10","v":0},null,null,null,null,"SA No",null,{"$f":"'Data Entry Sheet'!B9","v":0}]
["TEST CENTRE",{"$f":"+'Data Entry Sheet'!B11","v":0},null,null,null,null,"TEST DATE",null,{"$f":"+'Data Entry Sheet'!B12","v":"00:00:00"}]
[]
["TEST",null,{"$f":"+'Data Entry Sheet'!T15","v":0}]
["TEST No.",null,{"$f":"+'Data Entry Sheet'!T$16","v":0}]
[null,null,{"$f":"\"(\"&'Data Entry Sheet'!$I$18&\")\"","v":"()"}]
[{"$f":"'Data Entry Sheet'!A18","v":"Date of previous test in this discipline (whether passed or failed)"},null,{"$f":"+'Data Entry Sheet'!B18","v":"00:00:00"},null,null,"Fees Received $ ",null,{"$f":"'Data Entry Sheet'!E18","v":0}]
["Signed ",null,{"$f":"+'Data Entry Sheet'!B39","v":0},null,null,"Received By "]
[null,null,null,null,null,null,"Note: C = Competent\n       NYC = Not Yet Competent"]
["Dances, Technical Merit & Artistic Impression",null,null,null,null,null,null,"Judges Assessments",null,null,null,null,null,"Judges"]
[null,null,null,null,null,null,null,1,2,3,null,null,1]
[{"$f":"+'Data Entry Sheet'!B28","v":""},{"$f":"+'Data Entry Sheet'!C28","v":""},null,null,null,null,null,"",null,null,null,null,2]
[{"$f":"+'Data Entry Sheet'!B29","v":""},{"$f":"+'Data Entry Sheet'!C29","v":""},null,null,null,null,null,"",null,null,null,null,3]
[{"$f":"+'Data Entry Sheet'!B30","v":""},{"$f":"+'Data Entry Sheet'!C30","v":""}]
[{"$f":"+'Data Entry Sheet'!B31","v":""},{"$f":"+'Data Entry Sheet'!C31","v":""},null,null,null,null,null,null,null,null,null,null,null,"Referee"]
[{"$f":"+'Data Entry Sheet'!B32","v":""},{"$f":"+'Data Entry Sheet'!C32","v":""}]
[{"$f":"+'Data Entry Sheet'!B33","v":""},{"$f":"+'Data Entry Sheet'!C33","v":""},null,null,null,null,null,"","",""]
[{"$f":"+'Data Entry Sheet'!B34","v":""},{"$f":"+'Data Entry Sheet'!C34","v":""},null,null,null,null,null,"","",""]
[{"$f":"+'Data Entry Sheet'!B35","v":""},{"$f":"+'Data Entry Sheet'!C35","v":""}]
[{"$f":"+'Data Entry Sheet'!B36","v":""},{"$f":"+'Data Entry Sheet'!C36","v":""},null,null,null,null,null,"","",""]
[{"$f":"+'Data Entry Sheet'!B37","v":""},{"$f":"+'Data Entry Sheet'!C37","v":""},null,null,null,null,null,"","",""]
["OVERALL ASSESSMENTS",null,null,null,null,null,null,"",""]
["Referee's Signature",null,null,null,null,null,null,"Passing Grade",null,{"$f":"+'Data Entry Sheet'!B24","v":"N/A"}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(H32=FALSE,H33=FALSE),\"Did Not Skate\",(IF(H32=FALSE,\"Not Yet Competent\",\"Competent\")))","v":"Did Not Skate"}]
[null,null,null,null,null,null,null,false]
["Judges' Assessment Comments.  Must be ALL actual comments from Judges' sheets.",null,null,null,null,null,null,false]
[{"$f":"N18","v":0},null,null,null,{"$f":"N19","v":0},null,null,null,{"$f":"N20","v":0}]

{"sheet":"Test Details","index":3,"n_rows":618,"n_cols":10,"rows_kept":618,"cut":false,"hidden":true,"merged":[]}
["Dance Pairs"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$1&A3","v":"Dance Pairs1"},"1.",{"$f":"B3&C3","v":"Dance Pairs11."},null,"Glide Waltz - 120 Waltz",5,11,null,"Bronze Bar"]
[1,{"$f":"$A$1&A4","v":"Dance Pairs1"},{"$f":"IF(B4=B3,TEXT(VALUE(C3)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B4&C4","v":"Dance Pairs12."},null,"Masters Tango - 100 Tango"]
[2,{"$f":"$A$1&A5","v":"Dance Pairs2"},{"$f":"IF(B5=B4,TEXT(VALUE(C4)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B5&C5","v":"Dance Pairs21."},null,"Society Blues - 88 Blues",5,12,null,"Bronze Bar"]
[2,"Dance Pairs2","2.","Dance Pairs22.",null,"Skaters March - 100 March"]
[3,"Dance Pairs3","1.","Dance Pairs31.",null,"Canasta Tango - 100 Tango",5,18,null,"Bronze Bar"]
[3,"Dance Pairs3","2.","Dance Pairs32.",null,"Dutch Waltz - 138 Waltz"]
[3,"Dance Pairs3","3.","Dance Pairs33.",null,"Rhythm Blues - 92 Blues"]
[4,"Dance Pairs4","1.","Dance Pairs41.",null,"Denver Shuffle - 100 Polka",5,19.5,null,"Bronze Medal"]
[4,"Dance Pairs4","2.","Dance Pairs42.",null,"Southland Swing - 92 Blues or Foxtrot"]
[4,"Dance Pairs4","3.","Dance Pairs43.",null,"120 Waltz - 120 Waltz"]
[5,"Dance Pairs5","1.","Dance Pairs51.",null,"Collegiate - 92 Foxtrot",5,21,null,"Silver Bar"]
[5,"Dance Pairs5","2.","Dance Pairs52.",null,"Chase Waltz - 120 Waltz"]
[5,"Dance Pairs5","3.","Dance Pairs53.",null,"Siesta Tango - 100 Tango"]
[6,"Dance Pairs6","1.","Dance Pairs61.",null,"Highland Schottische - 100 Schottische",5,21,null,"Silver Bar"]
[6,"Dance Pairs6","2.","Dance Pairs62.",null,"Border Blues - 92 Blues"]
[6,"Dance Pairs6","3.","Dance Pairs63.",null,"Coronation Waltz - 120 Waltz"]
[7,"Dance Pairs7","1.","Dance Pairs71.",null,"Metropolitan Tango - 100 Tango",5,28,null,"Silver Bar"]
[7,"Dance Pairs7","2.","Dance Pairs72.",null,"Imperial Waltz - 120 Waltz"]
[7,"Dance Pairs7","3.","Dance Pairs73.",null,"Adams Polka  -100 Polka"]
[7,"Dance Pairs7","4.","Dance Pairs74.",null,"Fascination Foxtrot - 92 Foxtrot"]
[8,"Dance Pairs8","1.","Dance Pairs81.",null,"Fourteen Step - 108 March",5,28,null,"Silver Medal"]
[8,"Dance Pairs8","2.","Dance Pairs82.",null,"Princeton Polka - 100 Polka"]
[8,"Dance Pairs8","3.","Dance Pairs83.",null,"Keats Foxtrot - 96 Foxtrot"]
[8,"Dance Pairs8","4.","Dance Pairs84.",null,"Marine Waltz - 108 Waltz"]
[9,"Dance Pairs9","1.","Dance Pairs91.",null,"Colonial Foxtrot - 100 Foxtrot",5,30,null,"Gold Bar"]
[9,"Dance Pairs9","2.","Dance Pairs92.",null,"Flirtation Waltz - 120 Waltz"]
[9,"Dance Pairs9","3.","Dance Pairs93.",null,"Dench Blues - 88 Blues"]
[9,"Dance Pairs9","4.","Dance Pairs94.",null,"International Waltz - 168 Waltz"]
[10,"Dance Pairs10","1.","Dance Pairs101.",null,"Harris Tango - 100 Tango",5,30,null,"Gold Bar"]
[10,"Dance Pairs10","2.","Dance Pairs102.",null,"Rocker Foxtrot - 104 Foxtrot"]
[10,"Dance Pairs10","3.","Dance Pairs103.",null,"European Waltz - 120 Waltz"]
[10,"Dance Pairs10","4.","Dance Pairs104.",null,"Carroll Swing - 100 Boogie"]
[11,"Dance Pairs11","1.","Dance Pairs111.",null,"Pacifica Foxtrot - 100 Foxtrot",5,30,null,"Gold Bar"]
[11,"Dance Pairs11","2.","Dance Pairs112.",null,"Iceland Tango - 100 Tango"]
[11,"Dance Pairs11","3.","Dance Pairs113.",null,"Kilian - 108 March"]
[11,"Dance Pairs11","4.","Dance Pairs114.",null,"Starlight Waltz - 148 Waltz"]
[12,"Dance Pairs12","1.","Dance Pairs121.",null,"Viennese Waltz - 138 Waltz",5,45,null,"Gold Medal"]
[12,"Dance Pairs12","2.","Dance Pairs122.",null,"Italian Foxtrot - 96 Foxtrot"]
[12,"Dance Pairs12","3.","Dance Pairs123.",null,"Paso Doble - 112 Paso Doble"]
[12,"Dance Pairs12","4.","Dance Pairs124.",null,"Westminster Waltz - 138 Waltz"]
[12,"Dance Pairs12","5.","Dance Pairs125.",null,"Argentine Tango - 96 Tango"]
[12,"Dance Pairs12","6.","Dance Pairs126.",null,"Quickstep - 112 Quickstep"]
[]
["Solo Dance"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time"]
[1,{"$f":"$A$46&A48","v":"Solo Dance1"},"1.",{"$f":"B48&C48","v":"Solo Dance11."},null,"Glide Waltz - 120 Waltz",5,11,null,"Bronze Bar"]
[1,{"$f":"$A$46&A49","v":"Solo Dance1"},{"$f":"IF(B49=B48,TEXT(VALUE(C48)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Dance12.",null,"Masters Tango - 100 Tango"]
[2,"Solo Dance2","1.","Solo Dance21.",null,"Olympic Foxtrot - 104 Foxtrot",5,12,null,"Bronze Bar"]
[2,"Solo Dance2","2.","Solo Dance22.",null,"Skaters March - 100 March"]
[3,"Solo Dance3","1.","Solo Dance31.",null,"Canasta Tango - 100 Tango",5,12,null,"Bronze Bar"]
[3,"Solo Dance3","2.","Solo Dance32.",null,"La Vista Cha Cha - 108 Cha Cha"]
[4,"Solo Dance4","1.","Solo Dance41.",null,"Rhythm Blues - 92 Blues",5,12,null,"Bronze Bar"]
[4,"Solo Dance4","2.","Solo Dance42.",null,"Dutch Waltz - 138 Waltz"]
[5,"Solo Dance5","1.","Solo Dance51.",null,"Swing Foxtrot - 104 Foxtrot",5,19.5,null,"Bronze Medal"]
[5,"Solo Dance5","2.","Solo Dance52.",null,"Denver Shuffle - 100 Polka"]
[5,"Solo Dance5","3.","Solo Dance53.",null,"Monterey Tango - 100 Tango"]
["BS","Solo DanceBS","1.","Solo DanceBS1.",null,null,5,21,null,"Bronze Star"]
["BS","Solo DanceBS","2.","Solo DanceBS2."]
["BS","Solo DanceBS","3.","Solo DanceBS3."]
[6,"Solo Dance6","1.","Solo Dance61.",null,"Siesta Tango - 100 Tango",5,14,null,"Silver Bar"]
[6,"Solo Dance6","2.","Solo Dance62.",null,"Marylee Foxtrot -  92 Foxtrot"]
[7,"Solo Dance7","1.","Solo Dance71.",null,"Spring Blues - 92 Blues",5,14,null,"Silver Bar"]
[7,"Solo Dance7","2.","Solo Dance72.",null,"The Cha Cha - 100 Cha Cha"]
[8,"Solo Dance8","1.","Solo Dance81.",null,"Kleiner Waltz - 138 Waltz",5,14,null,"Silver Bar"]
[8,"Solo Dance8","2.","Solo Dance82.",null,"Casino March - 100 March"]
[9,"Solo Dance9","1.","Solo Dance91.",null,"Tudor Waltz - 144 Waltz",5,14,null,"Silver Bar"]
[9,"Solo Dance9","2.","Solo Dance92.",null,"Federation Foxtrot - 96 Foxtrot"]
[10,"Solo Dance10","1.","Solo Dance101.",null,"Association Waltz - 132 Waltz",5,21,null,"Silver Medal"]
[10,"Solo Dance10","2.","Solo Dance102.",null,"Kent Tango - 100 Tango"]
[10,"Solo Dance10","3.","Solo Dance103.",null,"Keats Foxtrot - 96 Foxtrot"]
["SS","Solo DanceSS",{"$f":"IF(B73=B72,TEXT(VALUE(C72)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B73&C73","v":"Solo DanceSS1."},null,null,5,30,null,"Silver Star"]
["SS","Solo DanceSS",{"$f":"IF(B74=B73,TEXT(VALUE(C73)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B74&C74","v":"Solo DanceSS2."}]
["SS","Solo DanceSS",{"$f":"IF(B75=B74,TEXT(VALUE(C74)+1,\"#\")&\".\",\"1.\")","v":"3."},{"$f":"B75&C75","v":"Solo DanceSS3."}]
["SS","Solo DanceSS",{"$f":"IF(B76=B75,TEXT(VALUE(C75)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B76&C76","v":"Solo DanceSS4."}]
[11,"Solo Dance11",{"$f":"IF(B77=B76,TEXT(VALUE(C76)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B77&C77","v":"Solo Dance111."},null,"Dench Blues - 88 Blues",5,22.5,null,"Gold Bar"]
[11,"Solo Dance11","2.","Solo Dance112.",null,"Imperial Tango - 104 Tango"]
[11,"Solo Dance11","3.","Solo Dance113.",null,"European Waltz - 120 Waltz"]
[12,"Solo Dance12","1.","Solo Dance121.",null,"Kilian - 108 March",5,22.5,null,"Gold Bar"]
[12,"Solo Dance12","2.","Solo Dance122.",null,"Harris Tango - 100 Tango"]
[12,"Solo Dance12","3.","Solo Dance123.",null,"Terenzi Waltz - 168 Waltz"]
[13,"Solo Dance13","1.","Solo Dance131.",null,"14 Step Plus - 108 March",5,22.5,null,"Gold Bar"]
[13,"Solo Dance13","2.","Solo Dance132.",null,"Flirtation Waltz - 120 Waltz"]
[13,"Solo Dance13","3.","Solo Dance133.",null,"Rocker Foxtrot - 104 Foxtrot"]
[14,"Solo Dance14","1.","Solo Dance141.",null,"Italian Foxtrot - 96 Foxtrot",5,30,null,"Gold Bar"]
[14,"Solo Dance14","2.","Solo Dance142.",null,"Westminster Waltz - 138 Waltz"]
[14,"Solo Dance14","3.","Solo Dance143.",null,"Iceland Tango - 100 Tango"]
[14,"Solo Dance14","4.","Solo Dance144.",null,"Starlight Waltz - 168 Waltz"]
[15,"Solo Dance15","1.","Solo Dance151.",null,"Argentine Tango - 96 Tango",5,37.5,null,"Gold Medal"]
[15,"Solo Dance15","2.","Solo Dance152.",null,"Tango Delancha - 104 Tango"]
[15,"Solo Dance15","3.","Solo Dance153.",null,"Quickstep - 112 Quickstep"]
[15,"Solo Dance15","4.","Solo Dance154.",null,"Viennese Waltz - 138 Waltz"]
[15,"Solo Dance15","5.","Solo Dance155.",null,"Paso Doble - 112 Paso Doble"]
["GS","Solo DanceGS","1.",{"$f":"B95&C95","v":"Solo DanceGS1."},null,null,5,40,null,"Gold Star"]
["GS","Solo DanceGS","2.",{"$f":"B96&C96","v":"Solo DanceGS2."}]
["GS","Solo DanceGS","3.",{"$f":"B97&C97","v":"Solo DanceGS3."}]
["GS","Solo DanceGS","4.",{"$f":"B98&C98","v":"Solo DanceGS4."}]
["GS","Solo DanceGS","5.",{"$f":"B99&C99","v":"Solo DanceGS5."}]
[null,null,null,{"$f":"B100&\" \"&C100","v":" "}]
["Figures"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$101&A103","v":"Figures1"},"1.",{"$f":"B103&C103","v":"Figures11."},1,"RFO - LFO Eight",5,11,null,"Bronze Bar"]
[1,{"$f":"$A$101&A104","v":"Figures1"},{"$f":"IF(B104=B103,TEXT(VALUE(C103)+1,\"#\")&\".\",\"1.\")","v":"2."},"Figures12.","1d","LFOI - RFOI Half Change Eight"]
[2,"Figures2","1.","Figures21.",2,"RFI - LFI Eight",5,12,null,"Bronze Bar"]
[2,"Figures2","2.","Figures22.","2d","LFIO - RFIO Half Change Eight"]
[3,"Figures3","1.","Figures31.","5a","RFOI - LFIO Change Eight",5,12,null,"Bronze Bar"]
[3,"Figures3","2.","Figures32.","5b","LFOI - RFIO Change Eight"]
[4,"Figures4","1.","Figures41.","3","RBO - LBO Eight",5,12,null,"Bronze Bar"]
[4,"Figures4","2.","Figures42.","7","RFO - LFO Three"]
[5,"Figures5","1.","Figures51.","9a","RFI - LBO Three",5,13,null,"Bronze Medal"]
[5,"Figures5","2.","Figures52.","9b","LFI - RBO Three"]
[6,"Figures6","1.","Figures61.","8a","RFO - LBI Three",5,21,null,"Silver Bar"]
[6,"Figures6","2.","Figures62.","8b","LFO - RBI Three"]
[6,"Figures6","3.","Figures63.","11","RFI - LFI Double Three"]
[7,"Figures7","1.","Figures71.","10","RFO - LFO Double Three",5,21,null,"Silver Bar"]
[7,"Figures7","2.","Figures72.","26a","RFOI - LBOI Change Three"]
[7,"Figures7","3.","Figures73.","26b","LFOI - RBOI Change Three"]
[8,"Figures8","1.","Figures81.",12,"RBO - LBO Double Three",5,35,null,"Silver Bar"]
[8,"Figures8","2.","Figures82.","24a","RFOI - LFIO One Foot Eight"]
[8,"Figures8","3.","Figures83.","24b","LFOI - RFIO One Foot Eight"]
[8,"Figures8","4.","Figures84.","28a","RFOI - LFIO Change Dbl Three"]
[8,"Figures8","5.","Figures85.","28b","LFOI - RFIO Change Dbl Three"]
[9,"Figures9",{"$f":"IF(B124=B123,TEXT(VALUE(C123)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B124&C124","v":"Figures91."},"19a","RFI - LBO Bracket",5,42,null,"Silver Bar"]
[9,"Figures9","2.","Figures92.","19b","LFI - RBO Bracket"]
[9,"Figures9","3.","Figures93.","22a","RFO – LBO Counter"]
[9,"Figures9","4.","Figures94.","22b","LFO – RBO Counter"]
[9,"Figures9","5.","Figures95.","27a","RFIO – LBIO Change Three"]
[9,"Figures9","6.","Figures96.","27b","LFIO – RBIO Change Three"]
[10,"Figures10","1.","Figures101.",4,"RBI – LBI Eight",5,49,null,"Silver Medal"]
[10,"Figures10","2.","Figures102.","6a","RBOI – LBIO Change Eight"]
[10,"Figures10","3.","Figures103.","6b","LBOI – RBIO Change Eight"]
[10,"Figures10","4.","Figures104.","20a","RFO – LBO Rocker"]
[10,"Figures10","5.","Figures105.","20b","LFO – RBO Rocker"]
[10,"Figures10","6.","Figures106.","23a","RFI - LBI Counter"]
[10,"Figures10","7.","Figures107.","23b","LFI - RBI Counter"]
[11,"Figures11","1.","Figures111.","13","RBI - LBI Double Three",5,52.5,null,"Gold Bar"]
[11,"Figures11","2.","Figures112.","14","RFO – LFO Loop"]
[11,"Figures11","3.","Figures113.","15","RFI - LFI Loop"]
[11,"Figures11","4.","Figures114.","18a","RFO – LBI Bracket"]
[11,"Figures11","5.","Figures115.","18b","LFO – RBI Bracket"]
[11,"Figures11","6.","Figures116.","21a","RFI - LBI Rocker"]
[11,"Figures11","7.","Figures117.","21b","LFI - RBI Rocker"]
[12,"Figures12","1.","Figures121.","16","RBO – LBO Loop",5,52.5,null,"Gold Bar"]
[12,"Figures12","2.","Figures122.","29a","RBOI – LBIO Change Dbl Three"]
[12,"Figures12","3.","Figures123.","29b","LBOI – RBIO Change Dbl Three"]
[12,"Figures12","4.","Figures124.","30a","RFOI – LFIO Change Loop"]
[12,"Figures12","5.","Figures125.","30b","LFOI – RFIO Change Loop"]
[12,"Figures12","6.","Figures126.","32a","RFOI – LBOI Change Bracket"]
[12,"Figures12","7.","Figures127.","32b","LFOI – RBOI Change Bracket"]
[13,"Figures13","1.","Figures131.","17","RBI - LBI Loop",5,52.5,null,"Gold Bar"]
[13,"Figures13","2.","Figures132.","31a","RBOI – LBIO Change Loop"]
[13,"Figures13","3.","Figures133.","31b","LBOI – RBIO Change Loop"]
[13,"Figures13","4.","Figures134.","33a","RFIO – LBIO Change Bracket"]
[13,"Figures13","5.","Figures135.","33b","LFIO – RBIO Change Bracket"]
[13,"Figures13","6.","Figures136.","34a","RFO – LFI Paragraph Three"]
[13,"Figures13","7.","Figures137.","34b","LFO – RFI Paragraph Three"]
[14,"Figures14","1.","Figures141.","35a","RBO – LBI Paragraph Three",5,60,null,"Gold Bar"]
[14,"Figures14","2.","Figures142.","35b","LBO – RBI Paragraph Three"]
[14,"Figures14","3.","Figures143.","36a","RFO – LFI Paragraph Dbl Three"]
[14,"Figures14","4.","Figures144.","36b","LFO – RFI Paragraph Dbl Three "]
[14,"Figures14","5.","Figures145.","38a","RFOI – LFIO Paragraph Loop"]
[14,"Figures14","6.","Figures146.","38b","LFOI – RFIO Paragraph Loop"]
[14,"Figures14","7.","Figures147.","40a","RFO – LFI Paragraph Bracket"]
[14,"Figures14","8.","Figures148.","40b","LFO – RFI Paragraph Bracket"]
[15,"Figures15","1.","Figures151.","25a","RBOI - LBIO One Foot Eight",5,60,null,"Gold Medal"]
[15,"Figures15","2.","Figures152.","25b","LBOI - RBIO One Foot Eight"]
[15,"Figures15","3.","Figures153.","37a","RBO - LBI Paragraph Dbl Three"]
[15,"Figures15","4.","Figures154.","37b","LBO - RBI Paragraph Dbl Three"]
[15,"Figures15","5.","Figures155.","39a","RBOI - LBIO Paragraph Loop"]
[15,"Figures15","6.","Figures156.","39b","LBOI - RBIO Paragraph Loop"]
[15,"Figures15","7.","Figures157.","41a","RBO - LBI Paragraph Bracket"]
[15,"Figures15","8.","Figures158.","41b","LBO - RBI Paragraph Bracket"]
[]
["Figure Loop"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$175&A177","v":"Figure Loop1"},"1.",{"$f":"B177&C177","v":"Figure Loop11."},14,"RFO – LFO Loop",5,13,null,"Bronze Bar"]
[1,{"$f":"$A$175&A178","v":"Figure Loop1"},{"$f":"IF(B178=B177,TEXT(VALUE(C177)+1,\"#\")&\".\",\"1.\")","v":"2."},"Figure Loop12.",15,"RFI - LFI Loop"]
[2,"Figure Loop2","1.","Figure Loop21.","30a","RFOI – LFIO Change Loop",5,14,null,"Silver Bar"]
[2,"Figure Loop2","2.","Figure Loop22.","30b","LFOI – RFIO Change Loop"]
[3,"Figure Loop3","1.","Figure Loop31.",16,"RBO – LBO Loop",5,14,null,"Silver Bar"]
[3,"Figure Loop3","2.","Figure Loop32.",17,"RBI - LBI Loop"]
[4,"Figure Loop4","1.","Figure Loop41.","31a","RBOI – LBIO Change Loop",5,15,null,"Gold Bar"]
[4,"Figure Loop4","2.","Figure Loop42.","31b","LBOI – RBIO Change Loop"]
[5,"Figure Loop5","1.","Figure Loop51.","38a","RFOI – LFIO Paragraph Loop",5,30,null,"Gold Bar"]
[5,"Figure Loop5","2.","Figure Loop52.","38b","LFOI – RFIO Paragraph Loop"]
[5,"Figure Loop5","3.","Figure Loop53.","39a","RBOI - LBIO Paragraph Loop"]
[5,"Figure Loop5","4.","Figure Loop54.","39b","LBOI - RBIO Paragraph Loop"]
[]
["Free Skating"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$190&A192","v":"Free Skating1"},"1.",{"$f":"B192&C192","v":"Free Skating11."},null,"Technical Merit",5,11,"Up to 2 minutes (+ 5 seconds)","Bronze Bar"]
[1,{"$f":"$A$190&A193","v":"Free Skating1"},{"$f":"IF(B193=B192,TEXT(VALUE(C192)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating12.",null,"Artistic Impression"]
[2,"Free Skating2","1.","Free Skating21.",null,"Technical Merit",5,12,"Up to 2 mins 30 secs (+ 5 seconds)","Bronze Bar"]
[2,"Free Skating2","2.","Free Skating22.",null,"Artistic Impression"]
[3,"Free Skating3","1.","Free Skating31.",null,"Technical Merit",5,13,"Up to 2 mins 30 secs (+ 5 seconds)","Bronze Medal"]
[3,"Free Skating3","2.","Free Skating32.",null,"Artistic Impression"]
[4,"Free Skating4","1.","Free Skating41.",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Bar"]
[4,"Free Skating4","2.","Free Skating42.",null,"Artistic Impression"]
[5,"Free Skating5","1.","Free Skating51.",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Bar"]
[5,"Free Skating5","2.","Free Skating52.",null,"Artistic Impression"]
[6,"Free Skating6","1.","Free Skating61.",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Medal"]
[6,"Free Skating6",{"$f":"IF(B203=B202,TEXT(VALUE(C202)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B203&C203","v":"Free Skating62."},null,"Artistic Impression"]
[7,"Free Skating7",{"$f":"IF(B204=B203,TEXT(VALUE(C203)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B204&C204","v":"Free Skating71."},null,"Technical Merit",5,15,"Up to 4 mins (+10 seconds)","Gold Medal"]
[7,"Free Skating7",{"$f":"IF(B205=B204,TEXT(VALUE(C204)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B205&C205","v":"Free Skating72."},null,"Artistic Impression"]
[8,"Free Skating8",{"$f":"IF(B206=B205,TEXT(VALUE(C205)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B206&C206","v":"Free Skating81."},null,"Technical Merit",5,15,"Up to 4 mins (+10 seconds)","Gold Challenge"]
[8,"Free Skating8",{"$f":"IF(B207=B206,TEXT(VALUE(C206)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B207&C207","v":"Free Skating82."},null,"Artistic Impression"]
[]
["Free Skating Requirements"]
["Test #",null,"Item #","Full Item",null,"Item Description",null,null,null,"Award"]
[1,{"$f":"$A$209&A211","v":"Free Skating Requirements1"},"A.",{"$f":"B211&C211","v":"Free Skating Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 1",null,null,null,"Bronze Bar"]
[1,"Free Skating Requirements1","1.","Free Skating Requirements11.",null,"Forward spiral, min ½ length of the floor, 1 edge."]
[1,"Free Skating Requirements1",{"$f":"IF(B213=B212,TEXT(VALUE(C212)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements12.",null,"Diagonal Primary Footwork, min ½ length of the floor"]
[1,"Free Skating Requirements1","3.","Free Skating Requirements13.",null,"IB Upright Spin"]
[1,"Free Skating Requirements1","4.","Free Skating Requirements14.",null,"IF Upright Spin"]
[1,"Free Skating Requirements1","5.","Free Skating Requirements15.",null,"Heel and Toe Spin"]
[1,"Free Skating Requirements1","6.","Free Skating Requirements16.",null,"Waltz Jump"]
[1,"Free Skating Requirements1","7.","Free Skating Requirements17.",null,"Toe Loop"]
[1,"Free Skating Requirements1","8.","Free Skating Requirements18.",null,"Bunny Hop"]
[1,"Free Skating Requirements1","9.","Free Skating Requirements19.",null,"Salchow"]
[1,"Free Skating Requirements1","10.","Free Skating Requirements110.",null,"Jump combo - choose 2 jumps from listed jumps.  Jump names must be entered."]
[1,"Free Skating Requirements1","11.","Free Skating Requirements111."]
[1,"Free Skating Requirements1","12.","Free Skating Requirements112."]
[2,"Free Skating Requirements2","A.","Free Skating Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 2"]
[2,"Free Skating Requirements2","1.","Free Skating Requirements21.",null,"Diagonal Secondary Footwork, min ¾ length of the floor"]
[2,"Free Skating Requirements2",{"$f":"IF(B226=B225,TEXT(VALUE(C225)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements22.",null,"OF Upright Spin"]
[2,"Free Skating Requirements2","3.","Free Skating Requirements23.",null,"OB Upright Spin"]
[2,"Free Skating Requirements2","4.","Free Skating Requirements24.",null,"Choose 1 Spin:  Upright Change or Upright Combo spin.  Edges (but not foot) must be entered."]
[2,"Free Skating Requirements2","5.","Free Skating Requirements25.",null,"Loop (OB) Jump"]
[2,"Free Skating Requirements2","6.","Free Skating Requirements26.",null,"Flip"]
[2,"Free Skating Requirements2","7.","Free Skating Requirements27.",null,"Jump combo - choose 3 jumps from:"]
[2,"Free Skating Requirements2","8.","Free Skating Requirements28.",null,"  Waltz Jump, Toe Loop, Salchow, Loop, Flip.  Jump names must be entered."]
[2,"Free Skating Requirements2","9.","Free Skating Requirements29.",null,"Fwd serp spiral, 1 change of edge, 1 foot (½ length of floor)"]
[2,"Free Skating Requirements2","10.","Free Skating Requirements210."]
[2,"Free Skating Requirements2","11.","Free Skating Requirements211."]
[2,"Free Skating Requirements2","12.","Free Skating Requirements212."]
[3,"Free Skating Requirements3","A.","Free Skating Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 3"]
[3,"Free Skating Requirements3","1.","Free Skating Requirements31.",null,"Diagonal Advanced Footwork, min ¾ length of the floor"]
[3,"Free Skating Requirements3",{"$f":"IF(B239=B238,TEXT(VALUE(C238)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements32.",null,"Upright change spin.  Edges (but not foot) must be entered."]
[3,"Free Skating Requirements3","3.","Free Skating Requirements33.",null,"Upright combo spin.  Edges (but not foot) must be entered."]
[3,"Free Skating Requirements3","4.","Free Skating Requirements34.",null,"Choose 1 Spin - IB Sit  or   OF Sit  or  OB Camel"]
[3,"Free Skating Requirements3","5.","Free Skating Requirements35.",null,"Flip"]
[3,{"$f":"$A$209&A243","v":"Free Skating Requirements3"},"6.",{"$f":"B243&C243","v":"Free Skating Requirements36."},null,"Thoren"]
[3,"Free Skating Requirements3","7.","Free Skating Requirements37.",null,"Lutz"]
[3,"Free Skating Requirements3","8.","Free Skating Requirements38.",null,"Jump combo - choose 3 jumps from:"]
[3,"Free Skating Requirements3","9.","Free Skating Requirements39.",null,"  Toe Loop, Salchow, Loop (OB), Lutz.  Jump names must be entered."]
[3,"Free Skating Requirements3","10.","Free Skating Requirements310.",null,"Backward spiral, ½ length of the floor"]
[3,"Free Skating Requirements3","11.","Free Skating Requirements311."]
[3,"Free Skating Requirements3","12.","Free Skating Requirements312."]
[4,"Free Skating Requirements4","A.","Free Skating Requirements4A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 4"]
[4,"Free Skating Requirements4","1.","Free Skating Requirements41.",null,"Advanced Serpentine Footwork"]
[4,"Free Skating Requirements4",{"$f":"IF(B252=B251,TEXT(VALUE(C251)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements42.",null,"Choose 1 Sit Spin - IB Sit  or  OF Sit  or  OB Sit"]
[4,"Free Skating Requirements4","3.","Free Skating Requirements43.",null,"Choose 1 Camel - OB Camel  or  OF Camel"]
[4,"Free Skating Requirements4","4.","Free Skating Requirements44.",null,"Choose 1 Spin:  Sit-change-Sit  or  Sit combo  or"]
[4,"Free Skating Requirements4","5.","Free Skating Requirements45.",null,"  Camel-Sit combo  or  Camel-change-Camel.  Edges (but not foot) must be entered."]
[4,"Free Skating Requirements4","6.","Free Skating Requirements46.",null,"Axel"]
[4,"Free Skating Requirements4","7.","Free Skating Requirements47.",null,"Choose 1 Jump - Double Salchow  or  Double Toe Loop.  Jump name must be entered."]
[4,"Free Skating Requirements4","8.","Free Skating Requirements48.",null,"Jump combo of 3 jumps - Axel + 2 Jumps of at least 1 revolution  Jump names must be entered."]
[4,"Free Skating Requirements4","9.","Free Skating Requirements49.",null,"Backward serp spiral, 1 change of edge on 1 foot"]
[4,"Free Skating Requirements4","10.","Free Skating Requirements410."]
[4,"Free Skating Requirements4","11.","Free Skating Requirements411."]
[4,"Free Skating Requirements4","12.","Free Skating Requirements412."]
[5,"Free Skating Requirements5","A.","Free Skating Requirements5A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 5"]
[5,"Free Skating Requirements5","1.","Free Skating Requirements51.",null,"Circular Advanced Footwork"]
[5,"Free Skating Requirements5",{"$f":"IF(B265=B264,TEXT(VALUE(C264)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements52.",null,"Camel combination"]
[5,"Free Skating Requirements5","3.","Free Skating Requirements53.",null,"Choose 1 Spin:  Sit combo  or  Sit-jump-Sit  or  Sit-jump-change-Sit  or"]
[5,"Free Skating Requirements5","4.","Free Skating Requirements54.",null,"                          OF Camel-OB Sit  or  OB Camel-OB Sit  or"]
[5,"Free Skating Requirements5","5.","Free Skating Requirements55.",null,"                          OF Camel-IB Sit  or  Sit-change-Sit.  Edges (but not foot) must be entered."]
[5,"Free Skating Requirements5","6.","Free Skating Requirements56.",null,"Double Toe Loop"]
[5,"Free Skating Requirements5","7.","Free Skating Requirements57.",null,"Double Salchow"]
[5,"Free Skating Requirements5","8.","Free Skating Requirements58.",null,"Double Flip"]
[5,"Free Skating Requirements5","9.","Free Skating Requirements59.",null,"Combo jump - 3-5 jumps, must include at least 1 dbl rev Jump.  Jump names must be entered."]
[5,"Free Skating Requirements5","10.","Free Skating Requirements510.",null,"Spiral, 1 change of foot, ¾ length of the floor"]
[5,"Free Skating Requirements5","11.","Free Skating Requirements511."]
[5,{"$f":"$A$209&A275","v":"Free Skating Requirements5"},"12.",{"$f":"B275&C275","v":"Free Skating Requirements512."}]
[6,"Free Skating Requirements6","A.","Free Skating Requirements6A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6"]
[6,"Free Skating Requirements6","1.","Free Skating Requirements61.",null,"2 sequences of Advanced Footwork"]
[6,"Free Skating Requirements6",{"$f":"IF(B278=B277,TEXT(VALUE(C277)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements62.",null,"1 Class A Spin"]
[6,"Free Skating Requirements6","3.","Free Skating Requirements63.",null,"Any Camel-change-Camel"]
[6,"Free Skating Requirements6","4.","Free Skating Requirements64.",null,"Any Camel combo.  Edges (but not foot) must be entered."]
[6,"Free Skating Requirements6","5.","Free Skating Requirements65.",null,"Choose 1 Spin: Sit-jump-Sit (OF Camel optional)* or Sit-jump-change-Sit  (OF Camel optional)*"]
[6,"Free Skating Requirements6","6.","Free Skating Requirements66.",null,"             or  Camel-Sit-change-Sit  or  OB Camel-OB Sit"]
[6,"Free Skating Requirements6","7.","Free Skating Requirements67.",null,"             or  IB Camel-IB Sit (OF edge optional).  Edges (but not foot) must be entered."]
[6,"Free Skating Requirements6","8.","Free Skating Requirements68.",null,"             *  It's usual to use a Camel to enter these Spins to develop enough speed"]
[6,"Free Skating Requirements6","9.","Free Skating Requirements69.",null,"Double Flip"]
[6,"Free Skating Requirements6","10.","Free Skating Requirements610.",null,"Choose 1 Jump:  Double Lutz  or  Double Loop.  Jump name must be entered."]
[6,"Free Skating Requirements6","11.","Free Skating Requirements611.",null,"Combo Jump - 3-5 Jumps, must include at least 1 dbl rev Jump.  Jump names must be entered."]
[6,"Free Skating Requirements6","12.","Free Skating Requirements612."]
[7,"Free Skating Requirements7","A.","Free Skating Requirements7A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 7"]
[7,"Free Skating Requirements7","1.","Free Skating Requirements71.",null,"2 sequences of Advanced Footwork"]
[7,"Free Skating Requirements7",{"$f":"IF(B291=B290,TEXT(VALUE(C290)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements72.",null,"1 Class A Spin"]
[7,"Free Skating Requirements7","3.","Free Skating Requirements73.",null,"Camel combo with a Sit Spin.  "]
[7,"Free Skating Requirements7","4.","Free Skating Requirements74.",null,"1 combo spin including 1 A class spin.  Edges (but not foot) must be entered."]
[7,"Free Skating Requirements7","5.","Free Skating Requirements75.",null,"Double Loop combo.  Jump names must be entered."]
[7,"Free Skating Requirements7","6.","Free Skating Requirements76.",null,"A Jump combo containing any 2 double rev Jumps.  Jump names must be entered."]
[7,"Free Skating Requirements7","7.","Free Skating Requirements77.",null,"Combo Jump - 3-5 Jumps includong 2 double Jumps.  Jump names must be entered."]
[7,"Free Skating Requirements7","8.","Free Skating Requirements78."]
[7,"Free Skating Requirements7","9.","Free Skating Requirements79."]
[7,"Free Skating Requirements7","10.","Free Skating Requirements710."]
[7,"Free Skating Requirements7","11.","Free Skating Requirements711."]
[7,"Free Skating Requirements7","12.","Free Skating Requirements712."]
[8,"Free Skating Requirements8","A.","Free Skating Requirements8A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 8"]
[8,"Free Skating Requirements8","1.","Free Skating Requirements81.",null,"2 A Class Spins"]
[8,"Free Skating Requirements8",{"$f":"IF(B304=B303,TEXT(VALUE(C303)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements82.",null,"Layover Camel (any edge)"]
[8,"Free Skating Requirements8","3.","Free Skating Requirements83.",null,"Inverted Camel (any edge)"]
[8,"Free Skating Requirements8","4.","Free Skating Requirements84.",null,"Broken Ankle (Forward or Backward)"]
[8,{"$f":"$A$209&A307","v":"Free Skating Requirements8"},"5.",{"$f":"B307&C307","v":"Free Skating Requirements85."},null,"Heel Camel (Forward or Backward)"]
[8,"Free Skating Requirements8","6.","Free Skating Requirements86.",null,"Combo spin including an A Class Spin and a Sit Spin.  Edges (but not foot) must be entered."]
[8,"Free Skating Requirements8","7.","Free Skating Requirements87.",null,"Double Axel"]
[8,"Free Skating Requirements8","8.","Free Skating Requirements88.",null,"Jump combo - Double Flip plus any other double rev Jump.  Jump names must be entered."]
[8,"Free Skating Requirements8","9.","Free Skating Requirements89.",null,"Jump combo - Dbl Lutz and Dbl Loop + any other dbl rev Jump.  Jump names must be entered."]
[8,"Free Skating Requirements8","10.","Free Skating Requirements810.",null,"A choice of any Triple Jump.  Jump name must be entered."]
[8,"Free Skating Requirements8","11.","Free Skating Requirements811."]
[8,"Free Skating Requirements8","12.","Free Skating Requirements812.",null,"(Thoren or Loop may be used as  extra jump to connect the jump seq)"]
[]
["Freedance Pairs"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$316&A318","v":"Freedance Pairs1"},"1.",{"$f":"B318&C318","v":"Freedance Pairs11."},null,"Technical Merit",5,13,"Up to 3 mins 40 secs","Bronze Medal"]
[1,"Freedance Pairs1",{"$f":"IF(B319=B318,TEXT(VALUE(C318)+1,\"#\")&\".\",\"1.\")","v":"2."},"Freedance Pairs12.",null,"Artistic Impression"]
[2,"Freedance Pairs2",{"$f":"IF(B320=B319,TEXT(VALUE(C319)+1,\"#\")&\".\",\"1.\")","v":"1."},"Freedance Pairs21.",null,"Technical Merit",5,14,"Up to 3 mins 40 secs","Silver Medal"]
[2,"Freedance Pairs2",{"$f":"IF(B321=B320,TEXT(VALUE(C320)+1,\"#\")&\".\",\"1.\")","v":"2."},"Freedance Pairs22.",null,"Artistic Impression"]
[3,"Freedance Pairs3",{"$f":"IF(B322=B321,TEXT(VALUE(C321)+1,\"#\")&\".\",\"1.\")","v":"1."},"Freedance Pairs31.",null,"Technical Merit",5,15,"Up to 3 mins 40 secs","Gold Medal"]
[3,"Freedance Pairs3",{"$f":"IF(B323=B322,TEXT(VALUE(C322)+1,\"#\")&\".\",\"1.\")","v":"2."},"Freedance Pairs32.",null,"Artistic Impression"]
[]
["Freedance Pairs Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$325&A327","v":"Freedance Pairs Requirements1"},"A.",{"$f":"B327&C327","v":"Freedance Pairs Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - F/D No 1"]
[1,{"$f":"$A$325&A328","v":"Freedance Pairs Requirements1"},"1.","Freedance Pairs Requirements11.",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[1,"Freedance Pairs Requirements1",{"$f":"IF(B329=B328,TEXT(VALUE(C328)+1,\"#\")&\".\",\"1.\")","v":"2."},"Freedance Pairs Requirements12.",null,"OR:          1 Dance HOLD Linear step sequence"]
[1,{"$f":"$A$325&A330","v":"Freedance Pairs Requirements1"},"3.",{"$f":"B330&C330","v":"Freedance Pairs Requirements13."}]
[1,{"$f":"$A$325&A331","v":"Freedance Pairs Requirements1"},"4.",{"$f":"B331&C331","v":"Freedance Pairs Requirements14."},null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[1,"Freedance Pairs Requirements1","5.","Freedance Pairs Requirements15.",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[1,{"$f":"$A$325&A333","v":"Freedance Pairs Requirements1"},"6.",{"$f":"B333&C333","v":"Freedance Pairs Requirements16."}]
[1,{"$f":"$A$325&A334","v":"Freedance Pairs Requirements1"},"7.",{"$f":"B334&C334","v":"Freedance Pairs Requirements17."},null,"1 Stationary Lift"]
[1,"Freedance Pairs Requirements1","8.","Freedance Pairs Requirements18."]
[1,"Freedance Pairs Requirements1","9.","Freedance Pairs Requirements19."]
[1,"Freedance Pairs Requirements1","10.","Freedance Pairs Requirements110."]
[1,"Freedance Pairs Requirements1","11.","Freedance Pairs Requirements111."]
[1,{"$f":"$A$325&A339","v":"Freedance Pairs Requirements1"},"12.",{"$f":"B339&C339","v":"Freedance Pairs Requirements112."}]
[2,"Freedance Pairs Requirements2","A.","Freedance Pairs Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/D No 2"]
[2,"Freedance Pairs Requirements2","1.","Freedance Pairs Requirements21.",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[2,"Freedance Pairs Requirements2",{"$f":"IF(B342=B341,TEXT(VALUE(C341)+1,\"#\")&\".\",\"1.\")","v":"2."},"Freedance Pairs Requirements22.",null,"OR:          1 Dance HOLD Linear step sequence"]
[2,{"$f":"$A$325&A343","v":"Freedance Pairs Requirements2"},{"$f":"IF(B343=B342,TEXT(VALUE(C342)+1,\"#\")&\".\",\"1.\")","v":"3."},{"$f":"B343&C343","v":"Freedance Pairs Requirements23."}]
[2,{"$f":"$A$325&A344","v":"Freedance Pairs Requirements2"},{"$f":"IF(B344=B343,TEXT(VALUE(C343)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B344&C344","v":"Freedance Pairs Requirements24."},null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[2,"Freedance Pairs Requirements2","5.","Freedance Pairs Requirements25.",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[2,"Freedance Pairs Requirements2","6.","Freedance Pairs Requirements26."]
[2,"Freedance Pairs Requirements2","7.","Freedance Pairs Requirements27.",null,"1 Stationary Lift"]
[2,{"$f":"$A$325&A348","v":"Freedance Pairs Requirements2"},{"$f":"IF(B348=B347,TEXT(VALUE(C347)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B348&C348","v":"Freedance Pairs Requirements28."}]
[2,"Freedance Pairs Requirements2","9.","Freedance Pairs Requirements29.",null,"1 Rotational or Combined Lift"]
[2,"Freedance Pairs Requirements2","10.","Freedance Pairs Requirements210."]
[2,"Freedance Pairs Requirements2","11.","Freedance Pairs Requirements211."]
[2,{"$f":"$A$325&A352","v":"Freedance Pairs Requirements2"},{"$f":"IF(B352=B351,TEXT(VALUE(C351)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B352&C352","v":"Freedance Pairs Requirements212."}]
[3,"Freedance Pairs Requirements3","A.","Freedance Pairs Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/D No 3"]
[3,"Freedance Pairs Requirements3","1.","Freedance Pairs Requirements31.",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[3,"Freedance Pairs Requirements3","2.","Freedance Pairs Requirements32.",null,"OR:          1 Dance HOLD Linear step sequence"]
[3,"Freedance Pairs Requirements3","3.","Freedance Pairs Requirements33."]
[3,"Freedance Pairs Requirements3","4.","Freedance Pairs Requirements34.",null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[3,"Freedance Pairs Requirements3","5.","Freedance Pairs Requirements35.",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[3,{"$f":"$A$325&A359","v":"Freedance Pairs Requirements3"},{"$f":"IF(B359=B358,TEXT(VALUE(C358)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B359&C359","v":"Freedance Pairs Requirements36."}]
[3,{"$f":"$A$325&A360","v":"Freedance Pairs Requirements3"},{"$f":"IF(B360=B359,TEXT(VALUE(C359)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B360&C360","v":"Freedance Pairs Requirements37."},null,"1 Stationary Lift"]
[3,{"$f":"$A$325&A361","v":"Freedance Pairs Requirements3"},{"$f":"IF(B361=B360,TEXT(VALUE(C360)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B361&C361","v":"Freedance Pairs Requirements38."},null,"1 Rotational or Combined Lift"]
[3,{"$f":"$A$325&A362","v":"Freedance Pairs Requirements3"},{"$f":"IF(B362=B361,TEXT(VALUE(C361)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B362&C362","v":"Freedance Pairs Requirements39."},null,"1 Other Lift of any choice"]
[3,{"$f":"$A$325&A363","v":"Freedance Pairs Requirements3"},{"$f":"IF(B363=B362,TEXT(VALUE(C362)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B363&C363","v":"Freedance Pairs Requirements310."}]
[3,{"$f":"$A$325&A364","v":"Freedance Pairs Requirements3"},{"$f":"IF(B364=B363,TEXT(VALUE(C363)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B364&C364","v":"Freedance Pairs Requirements311."}]
[3,{"$f":"$A$325&A365","v":"Freedance Pairs Requirements3"},{"$f":"IF(B365=B364,TEXT(VALUE(C364)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B365&C365","v":"Freedance Pairs Requirements312."}]
[]
["Free Skating Pairs"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$367&A369","v":"Free Skating Pairs1"},"1.",{"$f":"B369&C369","v":"Free Skating Pairs11."},null,"Technical Merit",5,13,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[1,"Free Skating Pairs1",{"$f":"IF(B370=B369,TEXT(VALUE(C369)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs12.",null,"Artistic Impression"]
[2,"Free Skating Pairs2",{"$f":"IF(B371=B370,TEXT(VALUE(C370)+1,\"#\")&\".\",\"1.\")","v":"1."},"Free Skating Pairs21.",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+/- 10 seconds)","Silver Medal"]
[2,"Free Skating Pairs2",{"$f":"IF(B372=B371,TEXT(VALUE(C371)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs22.",null,"Artistic Impression"]
[3,"Free Skating Pairs3",{"$f":"IF(B373=B372,TEXT(VALUE(C372)+1,\"#\")&\".\",\"1.\")","v":"1."},"Free Skating Pairs31.",null,"Technical Merit",5,15,"Up to 4 mins 30 secs (+/- 10 seconds)","Gold Medal"]
[3,"Free Skating Pairs3",{"$f":"IF(B374=B373,TEXT(VALUE(C373)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs32.",null,"Artistic Impression"]
[]
["Free Skating Pairs Requirements"]
["Test #",null,"Item #","Full Item",null,"Item Description",null,null,null,"Award"]
[1,{"$f":"$A$376&A378","v":"Free Skating Pairs Requirements1"},"A.",{"$f":"B378&C378","v":"Free Skating Pairs Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",null,null,null,"Bronze Bar"]
[1,"Free Skating Pairs Requirements1","1.","Free Skating Pairs Requirements11.",null,"3 Pairs Lifts from selection list"]
[1,"Free Skating Pairs Requirements1",{"$f":"IF(B380=B379,TEXT(VALUE(C379)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements12.",null,"2 Pairs Contact Spins"]
[1,"Free Skating Pairs Requirements1","3.","Free Skating Pairs Requirements13.",null,"1 Singles Shadow Jump of 1 revolution"]
[1,"Free Skating Pairs Requirements1","4.","Free Skating Pairs Requirements14.",null,"1 Singles Shadow Spin - no combination"]
[1,"Free Skating Pairs Requirements1","5.","Free Skating Pairs Requirements15.",null,"Primary Straighaway Footwork, min ¾ of length of the floor"]
[1,"Free Skating Pairs Requirements1","6.","Free Skating Pairs Requirements16."]
[1,"Free Skating Pairs Requirements1","7.","Free Skating Pairs Requirements17."]
[1,"Free Skating Pairs Requirements1","8.","Free Skating Pairs Requirements18."]
[1,"Free Skating Pairs Requirements1","9.","Free Skating Pairs Requirements19."]
[1,"Free Skating Pairs Requirements1","10.","Free Skating Pairs Requirements110."]
[1,"Free Skating Pairs Requirements1","11.","Free Skating Pairs Requirements111."]
[1,"Free Skating Pairs Requirements1","12.","Free Skating Pairs Requirements112.",null,"PAIRS SPINS:  IB Face to Face Upright,  OB Side by Side Upright,\n                         IB Upright-change OB Upright,  OB hand in hand Camel\nSPINS:             IF Upright,   IB Upright,   OF Upright, Two Foot\nPAIRS LIFTS:  Passover Axel,   1 only Flip/Toe Loop/Loop Lift,   Bucket or Pull Through,\n                        One arm Passover Axel,   Around the back Lift\nJUMPS:           Salchow,   Toe Loop,   Thoren, Loop\nFOOTWORK GUIDE (CONTACT AND SHADOW):\n                        Edges, swings, chasses, cross rolls, cross in front, cross behind. \n                        Primary Footwork can be done forwards or backwards.  There should\n                        be NO CHANGE OF DIRECTION within a sequence of Primary Footwork."]
[2,"Free Skating Pairs Requirements2","A.","Free Skating Pairs Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 2"]
[2,"Free Skating Pairs Requirements2","1.","Free Skating Pairs Requirements21.",null,"2 Pairs Lifts from selection list"]
[2,"Free Skating Pairs Requirements2",{"$f":"IF(B393=B392,TEXT(VALUE(C392)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements22.",null,"1 Throw or Twist Lift"]
[2,"Free Skating Pairs Requirements2","3.","Free Skating Pairs Requirements23.",null,"2 Pairs Contact Spins"]
[2,"Free Skating Pairs Requirements2","4.","Free Skating Pairs Requirements24.",null,"1 Singles Shadow Jump"]
[2,"Free Skating Pairs Requirements2","5.","Free Skating Pairs Requirements25.",null,"1 Singles Shadow Spin"]
[2,"Free Skating Pairs Requirements2","6.","Free Skating Pairs Requirements26.",null,"Secondary Footwork, circular pattern, min ¾ of the full width of the floor"]
[2,"Free Skating Pairs Requirements2","7.","Free Skating Pairs Requirements27."]
[2,"Free Skating Pairs Requirements2","8.","Free Skating Pairs Requirements28."]
[2,"Free Skating Pairs Requirements2","9.","Free Skating Pairs Requirements29."]
[2,"Free Skating Pairs Requirements2","10.","Free Skating Pairs Requirements210."]
[2,"Free Skating Pairs Requirements2","11.","Free Skating Pairs Requirements211."]
[2,"Free Skating Pairs Requirements2","12.","Free Skating Pairs Requirements212.",null,"PAIRS SPINS:        IB Face to Face Sit,   Pull Camel (man in Sit position on OB edge, \n                               lady either OB or IB Camel),   OB Pull Camel,   Tango Camel \n                               (Face to Face Camel),   IB Sit / change OB Sit,   Death Spiral (OB only)\nPAIRS LIFTS:         Kick over Flip with Twist,   Dbl Lutz or Dbl Flip Twist,\n                               Axel or Dbl Loop Throw Jump,   Airplane,   Press,   Cartwheel,   \n                               Kennedy Flip or Lutz\nSINGLES SPINS:   OB Upright,   IB Sit,   OB Sit,   OF Camel,   OB Camel\nSINGLES JUMPS:  Axel,   Double Toe Loop,   Double Toe Walley,\n                               Double Salchow,   Double Flip,   Double Loop\nFOOTWORK GUIDE (CONTACT AND SHADOW):\n                              Two foot turns, eg Mohawks,   Choctaws."]
[3,"Free Skating Pairs Requirements3","A.","Free Skating Pairs Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 3"]
[3,"Free Skating Pairs Requirements3","1.","Free Skating Pairs Requirements31.",null,"3 Pairs Lifts (one of which must be a combination Lift)"]
[3,"Free Skating Pairs Requirements3",{"$f":"IF(B406=B405,TEXT(VALUE(C405)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements32.",null,"1 Throw Lift"]
[3,"Free Skating Pairs Requirements3","3.","Free Skating Pairs Requirements33.",null,"1 Twist Lift"]
[3,"Free Skating Pairs Requirements3","4.","Free Skating Pairs Requirements34.",null,"2 Pairs Contact Spins"]
[3,"Free Skating Pairs Requirements3","5.","Free Skating Pairs Requirements35.",null,"Death Spiral"]
[3,"Free Skating Pairs Requirements3","6.","Free Skating Pairs Requirements36.",null,"1 Singles Shadow Jump (must be 2 revolutions)"]
[3,"Free Skating Pairs Requirements3","7.","Free Skating Pairs Requirements37.",null,"1 Singles Shadow Spin"]
[3,"Free Skating Pairs Requirements3","8.","Free Skating Pairs Requirements38.",null,"Advanced Serp Footwork (with at least 2 bold curves, min ½ width of the floor)"]
[3,"Free Skating Pairs Requirements3","9.","Free Skating Pairs Requirements39."]
[3,"Free Skating Pairs Requirements3","10.","Free Skating Pairs Requirements310."]
[3,"Free Skating Pairs Requirements3","11.","Free Skating Pairs Requirements311."]
[3,"Free Skating Pairs Requirements3","12.","Free Skating Pairs Requirements312.",null,"PAIRS SPINS:         Face to Face sit combo,   3 posn Pull Camel (without losing \n                                contact),   Layover Camel,   OB Sit-change-Layover,   \n                                Impossible Camel,   Impossible Sit,   Death Spiral\nPAIRS LIFTS:          Militano,   Kennedy,   One-handed Cartwheel,   Pancake,   \n                                One-handed Press, Throw (Axel, Dbl Toe Loop, Dbl Loop, Dbl Salchow),\n                                Dbl Lutz or Double Flip Twist Lift,   Any combo of overhead Lifts\nSINGLES SPINS:    OB Camel,   OF Camel,   IB Camel-Sit combo, IB Sit-change-OB Sit\nSINGLES JUMPS:  Dbl Toe Loop,   Dbl Flip,   Dbl Salchow,   Dbl Loop and/or Thoren\nFOOTWORK GUIDE (CONTACT AND SHADOW):\n                               One foot turns,   Rockers,   Brackets,   Counters,   Threes and Loops,\n                               both clockwise and counter clockwise"]
[]
["In-Line Free Skating"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$418&A420","v":"In-Line Free Skating1"},"1.",{"$f":"B420&C420","v":"In-Line Free Skating11."},null,"Technical Merit",5,11,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Bar"]
[1,{"$f":"$A$418&A421","v":"In-Line Free Skating1"},{"$f":"IF(B421=B420,TEXT(VALUE(C420)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating12.",null,"Artistic Impression"]
[2,"In-Line Free Skating2","1.","In-Line Free Skating21.",null,"Technical Merit",5,13,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[2,"In-Line Free Skating2","2.","In-Line Free Skating22.",null,"Artistic Impression"]
[3,"In-Line Free Skating3","1.","In-Line Free Skating31.",null,"Technical Merit",5,14,"Up to 3 mins (+/- 10 seconds)","Silver Bar"]
[3,"In-Line Free Skating3","2.","In-Line Free Skating32.",null,"Artistic Impression"]
[4,"In-Line Free Skating4","1.","In-Line Free Skating41.",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+/- 10 seconds)","Silver Medal"]
[4,"In-Line Free Skating4","2.","In-Line Free Skating42.",null,"Artistic Impression"]
[5,"In-Line Free Skating5","1.","In-Line Free Skating51.",null,"Technical Merit",5,15,"Up to 3 mins 30 secs (+/- 10 seconds)","Gold Bar"]
[5,"In-Line Free Skating5","2.","In-Line Free Skating52.",null,"Artistic Impression"]
[6,"In-Line Free Skating6","1.","In-Line Free Skating61.",null,"Technical Merit",5,15,"Up to 3 mins 30 secs (+/- 10 seconds)","Gold Medal"]
[6,"In-Line Free Skating6","2.","In-Line Free Skating62.",null,"Artistic Impression"]
[]
["In-Line Free Skating Requirements"]
["Test #",null,"Item #","Full Item",null,"Item Description",null,null,null,"Award"]
[1,{"$f":"$A$433&A435","v":"In-Line Free Skating Requirements1"},"A.",{"$f":"B435&C435","v":"In-Line Free Skating Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,null,null,"Bronze Bar"]
[1,{"$f":"$A$433&A436","v":"In-Line Free Skating Requirements1"},"1.","In-Line Free Skating Requirements11.",null,"Straightaway Primary Forward Footwork, min ½ length of floor"]
[1,"In-Line Free Skating Requirements1",{"$f":"IF(B437=B436,TEXT(VALUE(C436)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements12.",null,"Diagonal Primary Forward Footwork, min ½ length of floor"]
[1,"In-Line Free Skating Requirements1","3.","In-Line Free Skating Requirements13.",null,"IB Upright Spin (min 2 revs with wheels, not stopper)"]
[1,"In-Line Free Skating Requirements1","4.","In-Line Free Skating Requirements14.",null,"Heel and Toe Spin"]
[1,"In-Line Free Skating Requirements1","5.","In-Line Free Skating Requirements15.",null,"Two Heel Spin"]
[1,"In-Line Free Skating Requirements1","6.","In-Line Free Skating Requirements16.",null,"Waltz Jump"]
[1,"In-Line Free Skating Requirements1","7.","In-Line Free Skating Requirements17.",null,"Toe Loop"]
[1,"In-Line Free Skating Requirements1","8.","In-Line Free Skating Requirements18.",null,"Choose 1 Jump:  Bunny Hop  or  ½ Salchow  or  ½ Loop.  Jump name must be entered."]
[1,"In-Line Free Skating Requirements1","9.","In-Line Free Skating Requirements19.",null,"Jump combo of 2 jumps - choose from: "]
[1,"In-Line Free Skating Requirements1","10.","In-Line Free Skating Requirements110.",null,".  Waltz Jump, Toe Loop, Bunny Hop, ½ Toe Loop, Mazurka.  Jump names must be entered."]
[1,"In-Line Free Skating Requirements1","11.","In-Line Free Skating Requirements111."]
[1,{"$f":"$A$433&A447","v":"In-Line Free Skating Requirements1"},{"$f":"IF(B447=B446,TEXT(VALUE(C446)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B447&C447","v":"In-Line Free Skating Requirements112."}]
[2,{"$f":"$A$433&A448","v":"In-Line Free Skating Requirements2"},"A.","In-Line Free Skating Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2"]
[2,"In-Line Free Skating Requirements2","1.","In-Line Free Skating Requirements21.",null,"Straightaway Primary Backward Footwork, min ¾ length of floor"]
[2,"In-Line Free Skating Requirements2",{"$f":"IF(B450=B449,TEXT(VALUE(C449)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements22.",null,"Diagonal Secondary Footwork, min ¾ length of floor"]
[2,"In-Line Free Skating Requirements2","3.","In-Line Free Skating Requirements23.",null,"IB Upright Spin (min 3 revs with wheels, not stopper)"]
[2,"In-Line Free Skating Requirements2","4.","In-Line Free Skating Requirements24.",null,"Choose 1 Spin:  OB Upright  or  OF Upright (min 3 revs with wheels, not stopper)"]
[2,"In-Line Free Skating Requirements2","5.","In-Line Free Skating Requirements25.",null,"Salchow"]
[2,"In-Line Free Skating Requirements2","6.","In-Line Free Skating Requirements26.",null,"Flip"]
[2,"In-Line Free Skating Requirements2","7.","In-Line Free Skating Requirements27.",null,"Choose 1 Jump:  Thoren  or  ½ Lutz  or  Loop (OB)  or  Pat Lowe.  Jump name"]
[2,"In-Line Free Skating Requirements2","8.","In-Line Free Skating Requirements28.",null,"  must be entered."]
[2,"In-Line Free Skating Requirements2","9.","In-Line Free Skating Requirements29.",null,"Jump combo of 2 Jumps from the following (no repeated Jumps):"]
[2,"In-Line Free Skating Requirements2","10.","In-Line Free Skating Requirements210.",null,".  Flip, Thoren, Salchow, Toe Loop, Waltz Jump.  Jump names must be entered."]
[2,"In-Line Free Skating Requirements2","11.","In-Line Free Skating Requirements211."]
[2,{"$f":"$A$433&A460","v":"In-Line Free Skating Requirements2"},{"$f":"IF(B460=B459,TEXT(VALUE(C459)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B460&C460","v":"In-Line Free Skating Requirements212."}]
[3,{"$f":"$A$433&A461","v":"In-Line Free Skating Requirements3"},"A.","In-Line Free Skating Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3"]
[3,"In-Line Free Skating Requirements3","1.","In-Line Free Skating Requirements31.",null,"Semi Circular Primary Footwork (width of the floor)"]
[3,"In-Line Free Skating Requirements3",{"$f":"IF(B463=B462,TEXT(VALUE(C462)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements32.",null,"Diagonal Secondary Footwork, min ¾ length of floor"]
[3,"In-Line Free Skating Requirements3","3.","In-Line Free Skating Requirements33.",null,"Change or Combo Upright Spin (min 3 revs with wheels, not stopper).  Edges"]
[3,"In-Line Free Skating Requirements3","4.","In-Line Free Skating Requirements34.",null,"  (but not foot) must be entered."]
[3,"In-Line Free Skating Requirements3","5.","In-Line Free Skating Requirements35.",null,"Choose 1 Spin:  OB Camel  or  IB Sit"]
[3,"In-Line Free Skating Requirements3","6.","In-Line Free Skating Requirements36.",null,"Axel"]
[3,"In-Line Free Skating Requirements3","7.","In-Line Free Skating Requirements37.",null,"1½ or Double Toe Loop "]
[3,"In-Line Free Skating Requirements3","8.",{"$f":"B469&C469","v":"In-Line Free Skating Requirements38."},null,"Choose 1 Jump:  1½ or Dbl Salchow  or  Lutz  or  1½ or Dbl Flip  or  College  or  Boeckl"]
[3,"In-Line Free Skating Requirements3","9.","In-Line Free Skating Requirements39.",null,"Jump combo of 3 jumps from the following (no repeated Jumps):"]
[3,"In-Line Free Skating Requirements3","10.","In-Line Free Skating Requirements310.",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *"]
[3,{"$f":"$A$433&A472","v":"In-Line Free Skating Requirements3"},"11.",{"$f":"B472&C472","v":"In-Line Free Skating Requirements311."}]
[3,"In-Line Free Skating Requirements3","12.","In-Line Free Skating Requirements312.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[4,{"$f":"$A$433&A474","v":"In-Line Free Skating Requirements4"},"A.","In-Line Free Skating Requirements4A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4"]
[4,"In-Line Free Skating Requirements4","1.","In-Line Free Skating Requirements41.",null,"Circular Secondary Footwork (width of the floor)"]
[4,"In-Line Free Skating Requirements4",{"$f":"IF(B476=B475,TEXT(VALUE(C475)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements42.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[4,"In-Line Free Skating Requirements4","3.","In-Line Free Skating Requirements43.",null,"Change or Combo Sit Spin.  Edges (but not foot) must be entered."]
[4,"In-Line Free Skating Requirements4","4.","In-Line Free Skating Requirements44.",null,"Choose 1 Spin:  IB Camel  or  OF Camel"]
[4,"In-Line Free Skating Requirements4","5.","In-Line Free Skating Requirements45.",null,"Axel"]
[4,"In-Line Free Skating Requirements4","6.","In-Line Free Skating Requirements46.",null,"Double Salchow"]
[4,"In-Line Free Skating Requirements4","7.","In-Line Free Skating Requirements47.",null,"Choose 1 Jump:  Double Toe Loop  or  Lutz  or  Walley  or  Double Flip"]
[4,"In-Line Free Skating Requirements4","8.","In-Line Free Skating Requirements48.",null,"Jump combo of 3 jumps from the following (no repeated Jumps):"]
[4,"In-Line Free Skating Requirements4","9.","In-Line Free Skating Requirements49.",null,". Axel, Double Salchow, Double Toe Loop, Double Flip.  Jump names must be entered. *"]
[4,"In-Line Free Skating Requirements4","10.","In-Line Free Skating Requirements410."]
[4,"In-Line Free Skating Requirements4","11.","In-Line Free Skating Requirements411."]
[4,{"$f":"$A$433&A486","v":"In-Line Free Skating Requirements4"},{"$f":"IF(B486=B485,TEXT(VALUE(C485)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B486&C486","v":"In-Line Free Skating Requirements412."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[5,{"$f":"$A$433&A487","v":"In-Line Free Skating Requirements5"},"A.","In-Line Free Skating Requirements5A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5"]
[5,"In-Line Free Skating Requirements5","1.","In-Line Free Skating Requirements51.",null,"Serpentine Secondary Footwork (width of the floor)"]
[5,"In-Line Free Skating Requirements5",{"$f":"IF(B489=B488,TEXT(VALUE(C488)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements52.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[5,"In-Line Free Skating Requirements5","3.","In-Line Free Skating Requirements53.",null,"Change or Combo Camel to Sit Spin.  Edges (but not foot) must be entered."]
[5,"In-Line Free Skating Requirements5","4.","In-Line Free Skating Requirements54.",null,"Choose 1 Spin:  Jump Camel Spin  or  Camel change or combo Spin.  Edges"]
[5,"In-Line Free Skating Requirements5","5.","In-Line Free Skating Requirements55.",null,"  (but not foot) must be entered."]
[5,"In-Line Free Skating Requirements5","6.","In-Line Free Skating Requirements56.",null,"Double Flip"]
[5,"In-Line Free Skating Requirements5","7.","In-Line Free Skating Requirements57.",null,"Double Loop"]
[5,"In-Line Free Skating Requirements5","8.","In-Line Free Skating Requirements58.",null,"Choose 1 Jump:  Dbl Axel  or  Dbl Lutz  or  Triple Toe Loop.  Jump name must be entered."]
[5,"In-Line Free Skating Requirements5","9.","In-Line Free Skating Requirements59.",null,"Jump combo of 5 jumps from the following (no repeated Jumps):"]
[5,"In-Line Free Skating Requirements5","10.","In-Line Free Skating Requirements510.",null,"  Axel, Double Salchow, Double Toe Loop, Double Flip, Double Loop.  Jump "]
[5,"In-Line Free Skating Requirements5","11.","In-Line Free Skating Requirements511.",null,"  names must be entered. *"]
[5,{"$f":"$A$433&A499","v":"In-Line Free Skating Requirements5"},{"$f":"IF(B499=B498,TEXT(VALUE(C498)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B499&C499","v":"In-Line Free Skating Requirements512."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[6,{"$f":"$A$433&A500","v":"In-Line Free Skating Requirements6"},"A.","In-Line Free Skating Requirements6A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6"]
[6,"In-Line Free Skating Requirements6","1.","In-Line Free Skating Requirements61.",null,"Serpentine Advanced Footwork (width of the floor)"]
[6,"In-Line Free Skating Requirements6",{"$f":"IF(B502=B501,TEXT(VALUE(C501)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements62.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[6,"In-Line Free Skating Requirements6","3.","In-Line Free Skating Requirements63.",null,"Change or Combo Camel Spin.  "]
[6,"In-Line Free Skating Requirements6","4.",{"$f":"B504&C504","v":"In-Line Free Skating Requirements64."},null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered."]
[6,{"$f":"$A$433&A505","v":"In-Line Free Skating Requirements6"},"5.","In-Line Free Skating Requirements65.",null,"Double Axel"]
[6,"In-Line Free Skating Requirements6","6.","In-Line Free Skating Requirements66.",null,"Triple Toe Loop"]
[6,"In-Line Free Skating Requirements6","7.","In-Line Free Skating Requirements67.",null,"Choose 1 Jump:  Dbl Loop  or  Dbl Lutz  or  Triple Salchow.  Jump name must be entered."]
[6,"In-Line Free Skating Requirements6","8.","In-Line Free Skating Requirements68.",null,"Jump combo of 3 Jumps from the following (no repeated Jumps):"]
[6,"In-Line Free Skating Requirements6","9.","In-Line Free Skating Requirements69.",null,"  Double Axel, Triple Salchow, Triple Toe Loop, Double Flip, Double Loop.  Jump names"]
[6,"In-Line Free Skating Requirements6","10.","In-Line Free Skating Requirements610.",null,"  must be entered. *"]
[6,"In-Line Free Skating Requirements6","11.","In-Line Free Skating Requirements611."]
[6,{"$f":"$A$433&A512","v":"In-Line Free Skating Requirements6"},{"$f":"IF(B512=B511,TEXT(VALUE(C511)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B512&C512","v":"In-Line Free Skating Requirements612."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[]
["Precision"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$514&A516","v":"Precision1"},"1.",{"$f":"B516&C516","v":"Precision11."},null,"Technical Merit",5,13,"2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[1,"Precision1",{"$f":"IF(B517=B516,TEXT(VALUE(C516)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision12.",null,"Artistic Impression"]
[2,"Precision2",{"$f":"IF(B518=B517,TEXT(VALUE(C517)+1,\"#\")&\".\",\"1.\")","v":"1."},"Precision21.",null,"Technical Merit",5,14,"3 mins (+/- 10 seconds)","Silver Medal"]
[2,"Precision2",{"$f":"IF(B519=B518,TEXT(VALUE(C518)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision22.",null,"Artistic Impression"]
[3,"Precision3",{"$f":"IF(B520=B519,TEXT(VALUE(C519)+1,\"#\")&\".\",\"1.\")","v":"1."},"Precision31.",null,"Technical Merit",5,15,"4 mins (+/- 10 seconds)","Gold Medal"]
[3,"Precision3",{"$f":"IF(B521=B520,TEXT(VALUE(C520)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision32.",null,"Artistic Impression"]
[]
["Proficiency Certificate"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$523&A525","v":"Proficiency Certificate1"},{"$f":"IF(B525=B524,TEXT(VALUE(C524)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B525&C525","v":"Proficiency Certificate11."},null,"Pass/Fail",null,5,null,"Certificate"]
[]
["Solo Freedance"]
["Test #",null,"Item #","Full Item","Fig #","Item Description","Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$527&A529","v":"Solo Freedance1"},"1.",{"$f":"B529&C529","v":"Solo Freedance11."},null,"Technical Merit",5,13,"2 mins to 2 mins 30 secs","Bronze Medal"]
[1,"Solo Freedance1",{"$f":"IF(B530=B529,TEXT(VALUE(C529)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Freedance12.",null,"Artistic Impression"]
[2,"Solo Freedance2",{"$f":"IF(B531=B530,TEXT(VALUE(C530)+1,\"#\")&\".\",\"1.\")","v":"1."},"Solo Freedance21.",null,"Technical Merit",5,14,"2 mins 30 secs","Silver Medal"]
[2,"Solo Freedance2",{"$f":"IF(B532=B531,TEXT(VALUE(C531)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Freedance22.",null,"Artistic Impression"]
[3,"Solo Freedance3",{"$f":"IF(B533=B532,TEXT(VALUE(C532)+1,\"#\")&\".\",\"1.\")","v":"1."},"Solo Freedance31.",null,"Technical Merit",5,15,"2 mins 30 secs","Gold Medal"]
[3,"Solo Freedance3",{"$f":"IF(B534=B533,TEXT(VALUE(C533)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Freedance32.",null,"Artistic Impression"]
[]
["Solo Freedance Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$536&A538","v":"Solo Freedance Requirements1"},"A.",{"$f":"B538&C538","v":"Solo Freedance Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1"]
[1,{"$f":"$A$536&A539","v":"Solo Freedance Requirements1"},"1.","Solo Freedance Requirements11.",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND"]
[1,"Solo Freedance Requirements1",{"$f":"IF(B540=B539,TEXT(VALUE(C539)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Freedance Requirements12.",null,"                 1 circular step sequence (circular or serpentine)"]
[1,{"$f":"$A$536&A541","v":"Solo Freedance Requirements1"},"3.",{"$f":"B541&C541","v":"Solo Freedance Requirements13."}]
[1,"Solo Freedance Requirements1","4.","Solo Freedance Requirements14.",null,"OR:          1 straight step sequence long axis   AND"]
[1,"Solo Freedance Requirements1","5.","Solo Freedance Requirements15.",null,"                1 straight step sequence diagonal"]
[1,"Solo Freedance Requirements1","6.","Solo Freedance Requirements16.",null,"                (One of the step seqs must start from a stationary position)"]
[1,"Solo Freedance Requirements1","7.","Solo Freedance Requirements17."]
[1,"Solo Freedance Requirements1","8.","Solo Freedance Requirements18.",null,"Min 1, Max 3 Jumps of 1 revolution"]
[1,{"$f":"$A$536&A547","v":"Solo Freedance Requirements1"},"9.",{"$f":"B547&C547","v":"Solo Freedance Requirements19."}]
[1,"Solo Freedance Requirements1","10.","Solo Freedance Requirements110.",null,"Min 1, Max 2 Spins of 3 revolutions"]
[1,{"$f":"$A$536&A549","v":"Solo Freedance Requirements1"},"11.",{"$f":"B549&C549","v":"Solo Freedance Requirements111."}]
[1,{"$f":"$A$536&A550","v":"Solo Freedance Requirements1"},{"$f":"IF(B550=B549,TEXT(VALUE(C549)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B550&C550","v":"Solo Freedance Requirements112."}]
[2,"Solo Freedance Requirements2","A.","Solo Freedance Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2"]
[2,"Solo Freedance Requirements2","1.","Solo Freedance Requirements21.",null,"1 straight step sequence, either long axis or diagonal, from stationary position"]
[2,"Solo Freedance Requirements2",{"$f":"IF(B553=B552,TEXT(VALUE(C552)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Freedance Requirements22."]
[2,"Solo Freedance Requirements2","3.","Solo Freedance Requirements23.",null,"1 circular step sequence (circular or serpentine)"]
[2,"Solo Freedance Requirements2",{"$f":"IF(B555=B554,TEXT(VALUE(C554)+1,\"#\")&\".\",\"1.\")","v":"4."},"Solo Freedance Requirements24."]
[2,{"$f":"$A$536&A556","v":"Solo Freedance Requirements2"},{"$f":"IF(B556=B555,TEXT(VALUE(C555)+1,\"#\")&\".\",\"1.\")","v":"5."},{"$f":"B556&C556","v":"Solo Freedance Requirements25."},null,"Min 1, Max 3 Jumps of 1 revolution"]
[2,{"$f":"$A$536&A557","v":"Solo Freedance Requirements2"},{"$f":"IF(B557=B556,TEXT(VALUE(C556)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B557&C557","v":"Solo Freedance Requirements26."}]
[2,{"$f":"$A$536&A558","v":"Solo Freedance Requirements2"},{"$f":"IF(B558=B557,TEXT(VALUE(C557)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B558&C558","v":"Solo Freedance Requirements27."},null,"Min 1, Max 2 Spins of 3 revolutions"]
[2,{"$f":"$A$536&A559","v":"Solo Freedance Requirements2"},{"$f":"IF(B559=B558,TEXT(VALUE(C558)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B559&C559","v":"Solo Freedance Requirements28."}]
[2,{"$f":"$A$536&A560","v":"Solo Freedance Requirements2"},{"$f":"IF(B560=B559,TEXT(VALUE(C559)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B560&C560","v":"Solo Freedance Requirements29."}]
[2,{"$f":"$A$536&A561","v":"Solo Freedance Requirements2"},{"$f":"IF(B561=B560,TEXT(VALUE(C560)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B561&C561","v":"Solo Freedance Requirements210."}]
[2,{"$f":"$A$536&A562","v":"Solo Freedance Requirements2"},{"$f":"IF(B562=B561,TEXT(VALUE(C561)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B562&C562","v":"Solo Freedance Requirements211."}]
[2,{"$f":"$A$536&A563","v":"Solo Freedance Requirements2"},{"$f":"IF(B563=B562,TEXT(VALUE(C562)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B563&C563","v":"Solo Freedance Requirements212."}]
[3,"Solo Freedance Requirements3","A.","Solo Freedance Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3"]
[3,"Solo Freedance Requirements3","1.","Solo Freedance Requirements31.",null,"1 straight step sequence, either long axis or diagonal, from stationary position"]
[3,"Solo Freedance Requirements3","2.","Solo Freedance Requirements32."]
[3,"Solo Freedance Requirements3","3.","Solo Freedance Requirements33.",null,"1 circular step sequence (circular or serpentine)"]
[3,"Solo Freedance Requirements3","4.","Solo Freedance Requirements34."]
[3,{"$f":"$A$536&A569","v":"Solo Freedance Requirements3"},{"$f":"IF(B569=B568,TEXT(VALUE(C568)+1,\"#\")&\".\",\"1.\")","v":"5."},{"$f":"B569&C569","v":"Solo Freedance Requirements35."},null,"Min 1, Max 3 Jumps of 1 revolution"]
[3,{"$f":"$A$536&A570","v":"Solo Freedance Requirements3"},{"$f":"IF(B570=B569,TEXT(VALUE(C569)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B570&C570","v":"Solo Freedance Requirements36."}]
[3,{"$f":"$A$536&A571","v":"Solo Freedance Requirements3"},{"$f":"IF(B571=B570,TEXT(VALUE(C570)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B571&C571","v":"Solo Freedance Requirements37."},null,"Min 1, Max 2 Spins of 3 revolutions"]
[3,{"$f":"$A$536&A572","v":"Solo Freedance Requirements3"},{"$f":"IF(B572=B571,TEXT(VALUE(C571)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B572&C572","v":"Solo Freedance Requirements38."}]
[3,{"$f":"$A$536&A573","v":"Solo Freedance Requirements3"},{"$f":"IF(B573=B572,TEXT(VALUE(C572)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B573&C573","v":"Solo Freedance Requirements39."}]
[3,{"$f":"$A$536&A574","v":"Solo Freedance Requirements3"},{"$f":"IF(B574=B573,TEXT(VALUE(C573)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B574&C574","v":"Solo Freedance Requirements310."}]
[3,{"$f":"$A$536&A575","v":"Solo Freedance Requirements3"},{"$f":"IF(B575=B574,TEXT(VALUE(C574)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B575&C575","v":"Solo Freedance Requirements311."}]
[3,{"$f":"$A$536&A576","v":"Solo Freedance Requirements3"},{"$f":"IF(B576=B575,TEXT(VALUE(C575)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B576&C576","v":"Solo Freedance Requirements312."}]
[]
["Precision Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$578&A580","v":"Precision Requirements1"},"A.",{"$f":"B580&C580","v":"Precision Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1"]
[1,{"$f":"$A$578&A581","v":"Precision Requirements1"},"1.","Precision Requirements11.",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold"]
[1,"Precision Requirements1",{"$f":"IF(B582=B581,TEXT(VALUE(C581)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision Requirements12."]
[1,"Precision Requirements1","3.","Precision Requirements13.",null,"Line - along short axis and down long axis, the length of the floor"]
[1,"Precision Requirements1",{"$f":"IF(B584=B583,TEXT(VALUE(C583)+1,\"#\")&\".\",\"1.\")","v":"4."},"Precision Requirements14."]
[1,"Precision Requirements1","5.",{"$f":"B585&C585","v":"Precision Requirements15."},null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold"]
[1,{"$f":"$A$578&A586","v":"Precision Requirements1"},"6.",{"$f":"B586&C586","v":"Precision Requirements16."},null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold"]
[1,{"$f":"$A$578&A587","v":"Precision Requirements1"},"7.",{"$f":"B587&C587","v":"Precision Requirements17."}]
[1,{"$f":"$A$578&A588","v":"Precision Requirements1"},"8.",{"$f":"B588&C588","v":"Precision Requirements18."},null,"Intersecting - each skater must pass through the intersecting point once only, any handhold"]
[1,{"$f":"$A$578&A589","v":"Precision Requirements1"},"9.",{"$f":"B589&C589","v":"Precision Requirements19."}]
[1,"Precision Requirements1","10.","Precision Requirements110."]
[1,"Precision Requirements1","11.","Precision Requirements111."]
[1,{"$f":"$A$578&A592","v":"Precision Requirements1"},"12.",{"$f":"B592&C592","v":"Precision Requirements112."},null,"No additional elements"]
[2,"Precision Requirements2","A.","Precision Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 2"]
[2,"Precision Requirements2","1.","Precision Requirements21.",null,"Circle - min 2 revs, either direction or combo of both, Secondary Footwork, any handhold"]
[2,"Precision Requirements2",{"$f":"IF(B595=B594,TEXT(VALUE(C594)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision Requirements22."]
[2,"Precision Requirements2","3.","Precision Requirements23.",null,"Line - along short axis and down long axis, the length of the floor, forwards and backwards"]
[2,"Precision Requirements2","4.","Precision Requirements24."]
[2,"Precision Requirements2","5.","Precision Requirements25.",null,"Block - min 4 lines, max 6, 2 axis required, Secondary F/work, any handhold"]
[2,{"$f":"$A$578&A599","v":"Precision Requirements2"},{"$f":"IF(B599=B598,TEXT(VALUE(C598)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B599&C599","v":"Precision Requirements26."}]
[2,{"$f":"$A$578&A600","v":"Precision Requirements2"},{"$f":"IF(B600=B599,TEXT(VALUE(C599)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B600&C600","v":"Precision Requirements27."},null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold"]
[2,{"$f":"$A$578&A601","v":"Precision Requirements2"},{"$f":"IF(B601=B600,TEXT(VALUE(C600)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B601&C601","v":"Precision Requirements28."}]
[2,"Precision Requirements2","9.","Precision Requirements29.",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point "]
[2,{"$f":"$A$578&A603","v":"Precision Requirements2"},"10.",{"$f":"B603&C603","v":"Precision Requirements210."},null,"once only, any handhold"]
[2,"Precision Requirements2",{"$f":"IF(B604=B603,TEXT(VALUE(C603)+1,\"#\")&\".\",\"1.\")","v":"11."},"Precision Requirements211."]
[2,{"$f":"$A$578&A605","v":"Precision Requirements2"},"12.",{"$f":"B605&C605","v":"Precision Requirements212."},null,"No additional elements"]
[3,"Precision Requirements3","A.","Precision Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3"]
[3,"Precision Requirements3","1.","Precision Requirements31.",null,"Circle"]
[3,"Precision Requirements3","2.","Precision Requirements32."]
[3,"Precision Requirements3","3.","Precision Requirements33.",null,"Line"]
[3,"Precision Requirements3",{"$f":"IF(B610=B609,TEXT(VALUE(C609)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B610&C610","v":"Precision Requirements34."}]
[3,"Precision Requirements3","5.","Precision Requirements35.",null,"Block"]
[3,{"$f":"$A$578&A612","v":"Precision Requirements3"},{"$f":"IF(B612=B611,TEXT(VALUE(C611)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B612&C612","v":"Precision Requirements36."}]
[3,{"$f":"$A$578&A613","v":"Precision Requirements3"},{"$f":"IF(B613=B612,TEXT(VALUE(C612)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B613&C613","v":"Precision Requirements37."},null,"Wheel"]
[3,"Precision Requirements3","8.","Precision Requirements38."]
[3,"Precision Requirements3","9.","Precision Requirements39.",null,"Intersecting Manoeuvre"]
[3,"Precision Requirements3","10.","Precision Requirements310."]
[3,"Precision Requirements3","11.","Precision Requirements311."]
[3,{"$f":"$A$578&A618","v":"Precision Requirements3"},{"$f":"IF(B618=B617,TEXT(VALUE(C617)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B618&C618","v":"Precision Requirements312."},null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed."]

{"sheet":"CSV Export","index":4,"n_rows":12,"n_cols":76,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Name","Member #","Club","Venue","Test Date ","Partner","Date of Previous Test","Discipline","Test","Test Type","Award","Fee","Max Time","Min Mark","Passing Grade","Fig Num1","Item Desc1","Fig Num2","Item Desc2","Fig Num3","Item Desc3","Fig Num4","Item Desc4","Fig Num5","Item Desc5","Fig Num6","Item Desc6","Fig Num7","Item Desc7","Fig Num8","Item Desc8","Mark11","Mark21","Mark31","Mark12","Mark22","Mark32","Mark13","Mark23","Mark33","Mark14","Mark24","Mark34","Mark15","Mark25","Mark35","Mark16","Mark26","Mark36","Mark17","Mark27","Mark37","Mark18","Mark28","Mark38","Total1","Total2","Total3","Result","Comments","Content1","Content2","Content3","Content4","Content5","Content6","Content7","Content8","Content9","Content10","Content11","Judge1","Judge2","Judge3","Referee","Gender"]
[{"$f":"IF(ISBLANK('Data Entry Sheet'!B8),\"\",'Data Entry Sheet'!B8)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B9),\"\",'Data Entry Sheet'!B9)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B10),\"\",'Data Entry Sheet'!B10)","v":""},{"$f":"'Data Entry Sheet'!B11","v":0},{"$f":"'Data Entry Sheet'!B12","v":"00:00:00"},{"$f":"IF(ISBLANK('Data Entry Sheet'!B13),\"\",'Data Entry Sheet'!B13)","v":""},{"$f":"'Data Entry Sheet'!B18","v":"00:00:00"},{"$f":"'Application Form'!C11","v":0},{"$f":"'Application Form'!C12","v":0},{"$f":"HLOOKUP(TRIM(H2),K6:U8,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Data Entry Sheet'!I18","v":""},{"$f":"'Data Entry Sheet'!E18","v":0},{"$f":"'Data Entry Sheet'!B21","v":""},{"$f":"'Data Entry Sheet'!B23","v":"N/A"},{"$f":"'Data Entry Sheet'!B24","v":"N/A"},{"$f":"IF(ISBLANK('Data Entry Sheet'!B28),\"\",'Data Entry Sheet'!B28)","v":""},{"$f":"'Data Entry Sheet'!C28","v":""},{"$f":"'Data Entry Sheet'!B29","v":""},{"$f":"'Data Entry Sheet'!C29","v":""},{"$f":"'Data Entry Sheet'!B30","v":""},{"$f":"'Data Entry Sheet'!C30","v":""},{"$f":"'Data Entry Sheet'!B31","v":""},{"$f":"'Data Entry Sheet'!C31","v":""},{"$f":"'Data Entry Sheet'!B32","v":""},{"$f":"'Data Entry Sheet'!C32","v":""},{"$f":"'Data Entry Sheet'!B33","v":""},{"$f":"'Data Entry Sheet'!C33","v":""},{"$f":"'Data Entry Sheet'!B34","v":""},{"$f":"'Data Entry Sheet'!C34","v":""},{"$f":"'Data Entry Sheet'!B35","v":""},{"$f":"'Data Entry Sheet'!C35","v":""},{"$f":"'Application Form'!H19","v":""},{"$f":"'Application Form'!I19","v":0},{"$f":"'Application Form'!J19","v":0},{"$f":"'Application Form'!H20","v":""},{"$f":"'Application Form'!I20","v":0},{"$f":"'Application Form'!J20","v":0},{"$f":"'Application Form'!H21","v":0},{"$f":"'Application Form'!I21","v":0},{"$f":"'Application Form'!J21","v":0},{"$f":"'Application Form'!H22","v":0},{"$f":"'Application Form'!I22","v":0},{"$f":"'Application Form'!J22","v":0},{"$f":"'Application Form'!H23","v":0},{"$f":"'Application Form'!I23","v":0},{"$f":"'Application Form'!J23","v":0},{"$f":"'Application Form'!H24","v":""},{"$f":"'Application Form'!I24","v":""},{"$f":"'Application Form'!J24","v":""},{"$f":"'Application Form'!H25","v":""},{"$f":"'Application Form'!I25","v":""},{"$f":"'Application Form'!J25","v":""},{"$f":"'Application Form'!H27","v":""},{"$f":"'Application Form'!I27","v":""},{"$f":"'Application Form'!J27","v":""},{"$f":"'Application Form'!H29","v":""},{"$f":"'Application Form'!I29","v":""},{"$f":"'Application Form'!J29","v":0},{"$f":"'Application Form'!H31","v":"Did Not Skate"},null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B43),\"\",'Data Entry Sheet'!B43)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B44),\"\",'Data Entry Sheet'!B44)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B45),\"\",'Data Entry Sheet'!B45)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B46),\"\",'Data Entry Sheet'!B46)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B47),\"\",'Data Entry Sheet'!B47)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B48),\"\",'Data Entry Sheet'!B48)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B49),\"\",'Data Entry Sheet'!B49)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B50),\"\",'Data Entry Sheet'!B50)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B51),\"\",'Data Entry Sheet'!B51)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B52),\"\",'Data Entry Sheet'!B52)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!#REF!),\"\",'Data Entry Sheet'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK('Application Form'!N18),\"\",'Application Form'!N18)","v":""},{"$f":"IF(ISBLANK('Application Form'!N19),\"\",'Application Form'!N19)","v":""},{"$f":"IF(ISBLANK('Application Form'!N20),\"\",'Application Form'!N20)","v":""},{"$f":"IF(ISBLANK('Application Form'!N23),\"\",'Application Form'!N23)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!L8),\"\",'Data Entry Sheet'!L8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B44),\"\",'Data Entry Sheet'!B44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B45),\"\",'Data Entry Sheet'!B45)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B46),\"\",'Data Entry Sheet'!B46)","v":""}]
[null,null,null,null,null,null,null,null,"Convert discipline and test to test type  ","Discipline",{"$f":"'Data Entry Sheet'!B15","v":"Dance Pairs"},{"$f":"'Data Entry Sheet'!C15","v":"Solo Dance"},{"$f":"'Data Entry Sheet'!D15","v":"Figures"},{"$f":"'Data Entry Sheet'!E15","v":"Figure Loop"},{"$f":"'Data Entry Sheet'!F15","v":"Free Skating"},{"$f":"'Data Entry Sheet'!G15","v":"Freedance Pairs"},{"$f":"'Data Entry Sheet'!H15","v":"Solo Freedance"},{"$f":"'Data Entry Sheet'!I15","v":"Free Skating Pairs"},{"$f":"'Data Entry Sheet'!J15","v":"In-Line Free Skating"},{"$f":"'Data Entry Sheet'!K15","v":"Precision"},{"$f":"'Data Entry Sheet'!L15","v":"Proficiency Certificate"},{"$f":"'Data Entry Sheet'!M15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B47),\"\",'Data Entry Sheet'!B47)","v":""}]
[null,null,null,null,null,null,null,null,null,"Prefix","D",{"$f":"IF(OR($I$2=\"BS\", $I$2=\"SS\",$I$2=\"GS\"),\"SS\",\"S\")","v":"S"},"F","FL","FS","FD","SFD","FP","IL","P","PT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B48),\"\",'Data Entry Sheet'!B48)","v":""}]
[null,null,null,null,null,null,null,null,null,"Test Type Code",{"$f":"IF(K6=$H$2,IF(LEN($I$2)=1,K7&\"0\"&$I$2,K7&$I$2),\"\")","v":""},{"$f":"IF($L$6=$H$2,IF(LEN($I$2)=1,$L$7&\"0\"&$I$2,IF($I$2=\"BS\",\"SS1\",IF($I$2=\"SS\",\"SS2\",IF($I$2=\"GS\",\"SS3\", $L$7&$I$2)))),\"\")","v":""},{"$f":"IF(M6=$H$2,IF(LEN($I$2)=1,M7&\"0\"&$I$2,M7&$I$2),\"\")","v":""},{"$f":"IF(N6=$H$2,N7&$I$2,\"\")","v":""},"","","","","",{"$f":"IF(T6=$H$2,IF(LEN($I$2)=1,T7&\"0\"&$I$2,T7&$I$2),\"\")","v":""},{"$f":"IF(U6=$H$2,U7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B49),\"\",'Data Entry Sheet'!B49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B50),\"\",'Data Entry Sheet'!B50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"BS","SS1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B51),\"\",'Data Entry Sheet'!B51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"SS","SS2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B52),\"\",'Data Entry Sheet'!B52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"GS","SS3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!#REF!),\"\",'Data Entry Sheet'!#REF!)","v":{"$error":"#REF!"}}]