{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Data Entry Sheet","Marking Sheet","Application Form","Test Details","CSV Export"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":304,"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":"Instructions","index":0,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["COMPUTER/EXCEL SET UP REQUIREMENTS"]
[]
["1.","The forms must be saved on to a computer to work successfully.  The macros won't work on a form which is opened from OneDrive or from an attachment to an email."]
[]
["2.","The computer must have Excel 2010 (or later) installed.  The macros will not work in Libre Office."]
[]
["3.","Macros must be enabled on the computer.  Open Excel then go to:"]
[null,"(a)","File | Options | Trust Centre | Turst Centre Settings"]
[null,"(b)","Select Macro Settings"]
[null,"(c)","Select \"Enable VBA macros (not recommended, potentially dangerous code can run).\""]
[]
["4.","Trusted Locations must include the drive on which the forms have been saved."]
[null,"(a)","While still on the Trust Centre Settings page, go to:"]
[null,null,"(i)","Trusted Locations"]
[null,null,"(ii)","If the drive on which the forms have been saved is not listed, click \"Add New Location\" and add the drive name to Trusted Locations."]
[]
["5.","If there is still a message towards the top of the screen saying:"]
[null,"\"SECURITY RISK:  Microsoft has blocked macros from running because the source of this file is untrusted\":"]
[null,"(a)","Close the file WITHOUT SAVING IT;"]
[null,"(b)","Right click the file name;"]
[null,"(c)","Select Properties;"]
[null,"(d)","At the bottom of the General Tab, tick \"Unblock\" in the Security field;"]
[null,"(e)","Click OK"]
[null,"(f)","Then re-open the document."]

{"sheet":"Data Entry Sheet","index":1,"n_rows":90,"n_cols":53,"rows_kept":90,"cut":false,"hidden":false,"merged":[[64,25,64,27],[74,25,74,27],[66,25,66,27],[69,25,69,27],[65,25,65,27],[70,25,70,27],[71,25,71,27],[72,25,72,27],[67,25,67,27],[68,25,68,27],[73,25,73,27],[7,14,9,14],[56,22,56,23],[57,22,57,23],[58,22,58,23],[59,22,59,23],[60,22,60,23],[61,22,61,23],[62,22,62,23],[63,22,63,23],[54,22,54,23],[55,22,55,23],[13,18,13,19],[12,18,12,19],[7,17,9,17],[47,20,47,22],[49,20,49,22],[44,20,44,22],[7,22,8,23],[9,22,9,23],[14,15,14,16],[54,19,54,21],[55,19,55,21],[59,19,59,21],[60,19,60,21],[17,29,17,30],[17,31,17,32],[17,34,17,35],[16,34,16,35],[13,32,13,33],[10,28,10,29],[11,28,11,29],[12,28,12,29],[13,22,13,23],[13,24,13,25],[13,26,13,27],[10,32,10,33],[11,32,11,33],[10,34,10,35],[11,34,11,35],[13,34,13,35],[12,34,12,35],[12,30,12,31],[12,32,12,33],[11,30,11,31],[12,24,12,25],[12,26,12,27],[13,28,13,29],[13,30,13,31],[39,38,39,39],[36,29,38,30],[34,43,34,45],[38,22,38,24],[34,26,34,28],[36,34,38,35],[32,26,32,28],[2,22,2,23],[6,22,6,23],[18,41,18,42],[17,41,17,42],[15,40,15,42],[16,38,16,39],[17,38,17,39],[8,30,8,31],[7,32,9,33],[8,26,8,27],[9,26,9,27],[9,30,9,31],[10,26,10,27],[10,30,10,31],[16,36,16,37],[7,26,7,27],[11,26,11,27],[41,47,41,49],[38,26,38,28],[37,26,37,28],[53,14,53,16],[53,20,53,22],[41,20,41,22],[41,14,41,16],[41,26,41,28],[45,14,45,16],[46,14,46,16],[52,14,52,16],[52,20,52,22],[50,20,50,22],[47,14,47,16],[48,14,48,16],[49,14,49,16],[50,14,50,16],[51,14,51,16],[42,14,42,16],[48,20,48,22],[45,20,45,22],[46,20,46,22],[41,43,41,45],[39,36,39,37],[40,47,40,49],[35,47,35,49],[36,47,36,49],[25,55,26,55],[27,47,27,49],[27,43,27,45],[25,46,26,46],[25,47,26,49],[24,54,26,54],[38,43,38,45],[36,43,36,45],[40,43,40,45],[35,43,35,45],[39,43,39,45],[49,6,49,11],[46,6,46,11],[28,2,28,6],[55,7,55,11],[29,2,29,6],[47,6,47,11],[44,6,44,11],[45,6,45,11],[47,1,47,5],[48,1,48,5],[49,1,49,5],[35,2,35,6],[35,7,35,11],[36,2,36,6],[53,1,53,5],[54,7,54,11],[52,1,52,5],[50,1,50,5],[51,1,51,5],[46,1,46,5],[30,7,30,11],[31,2,31,6],[31,7,31,11],[32,2,32,6],[24,9,24,11],[28,7,28,11],[29,7,29,11],[30,2,30,6],[1,1,1,11],[2,1,2,11],[11,1,11,11],[9,1,9,11],[10,1,10,11],[12,1,12,11],[17,8,17,9],[8,1,8,11],[15,3,15,6],[14,3,14,6],[16,0,16,11],[17,2,17,3],[17,5,17,6],[6,1,6,11],[3,1,5,11],[7,1,7,11],[35,26,35,28],[33,26,33,28],[36,40,36,41],[33,40,33,41],[19,8,20,9],[19,10,20,10],[18,0,18,1],[19,0,19,1],[36,7,36,11],[33,2,33,6],[33,7,33,11],[34,2,34,6],[34,7,34,11],[18,8,18,9],[27,7,27,11],[27,2,27,6],[20,0,20,1],[18,3,18,5],[19,2,19,4],[22,7,22,11],[23,7,23,8],[26,9,26,11],[23,9,23,11],[26,2,26,7],[32,7,32,11],[34,40,34,41],[31,40,31,41],[39,22,39,24],[39,26,39,28],[40,26,40,28],[17,49,17,51],[16,29,16,31],[30,43,30,45],[37,43,37,45],[32,43,32,45],[33,43,33,45],[31,43,31,45],[29,47,29,49],[30,47,30,49],[31,47,31,49],[32,47,32,49],[33,47,33,49],[37,47,37,49],[28,47,28,49],[28,43,28,45],[29,43,29,45],[34,47,34,49],[17,36,17,37],[25,40,26,41],[25,42,26,42],[27,40,27,41],[25,43,26,45],[54,28,63,28],[63,25,63,27],[61,19,61,21],[62,19,62,21],[63,19,63,21],[29,40,29,41],[30,40,30,41],[32,40,32,41],[40,40,40,41],[39,34,39,35],[36,38,38,39],[43,20,43,22],[41,40,41,41],[39,40,39,41],[38,40,38,41],[37,40,37,41],[28,40,28,41],[35,40,35,41],[36,36,38,37],[36,26,36,28],[7,36,7,42],[10,36,11,42],[12,20,12,21],[12,22,12,23],[7,20,9,21],[10,20,10,21],[11,20,11,21],[9,18,9,19],[11,18,11,19],[7,34,9,35],[7,28,9,29],[7,30,7,31],[10,22,10,23],[11,22,11,23],[7,24,9,25],[10,24,10,25],[11,24,11,25],[60,1,60,11],[37,0,37,11],[50,6,50,11],[51,6,51,11],[42,20,42,22],[41,1,41,5],[41,6,41,11],[42,6,42,11],[40,1,40,11],[38,1,38,11],[51,20,51,22],[43,14,43,16],[44,14,44,16],[40,22,40,24],[59,1,59,11],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[43,6,43,11],[56,7,56,11],[52,6,52,11],[53,6,53,11],[48,6,48,11],[13,15,13,16],[10,18,10,19],[7,18,8,19],[64,19,64,21],[66,19,66,21],[82,19,82,21],[83,19,83,21],[84,19,84,21],[85,19,85,21],[12,15,12,16],[7,15,9,16],[10,15,10,16],[11,15,11,16],[13,20,13,21],[67,19,67,21],[86,19,86,21],[87,19,87,21],[89,18,90,18],[89,19,90,21],[70,19,70,21],[71,19,71,21],[72,19,72,21],[73,19,73,21],[74,19,74,21],[75,19,75,21],[77,19,77,21],[78,19,78,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide"]
[null,"SKATE AUSTRALIA PROFICIENCY TEST"]
[null,"DATA ENTRY SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Test Date =",null,{"$f":"Previous_Test_Date","v":"."}]
[null,"SA PROFICIENCY TEST FORM NS - 2025-01 NEW STRUCTURE - FIGURES AND LOOPS\n(requires Microsoft Excel 2010 or later installed on the computer)"]
[]
[]
[null,"Cells with a blue background have a drop down list for selection of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Date = ",null,{"$f":"Test_Date","v":"00:00:00"}]
["NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,"First Figures test - no previous attempt at this test","First Loops test - no previous attempt at this test",null,"If Last Test Type is Old Figures & C","If Last Test was Old Figures & NYC",null,"If Last Test was Old Loops & C",null,"If Last Test was Old Loops & NYC",null,"If Last Test was New Figures & C",null,"Last Test New Figs & NYC",null,"If Last Test was New Loops & C",null,"Last Test New Loops & NYC",null,"Skate Ups Figures\n\nIf Last Test was New Figures & Previous Test was C",null,"Skate Ups Loops\n\nIf Last Test was New Loops & Previous Test was C",null,"Test Held"]
["SA NO:",null,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(Previous_Test_Number=\"\",\"\",IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,null,null,null,"Figures A","Figures B","All Figures","Loops A","Loops B","All Loops","All"]
["CLUB:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"Old Figures\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"Old Loops\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,null,"Test Held is",null,null,null,"Test Held is",null,null,null,null,null,{"$f":"IF(Test_Held_First_Test_Figs<>\"\",Test_Held_First_Test_Figs,IF(Test_Held_Last_Test_Old_Figs_C<>\"\",Test_Held_Last_Test_Old_Figs_C,IF(Test_Held_Last_Test_Old_Figs_NYC<>\"\",Test_Held_Last_Test_Old_Figs_NYC,\"\")))","v":""},{"$f":"IF(Test_Held_Last_Test_New_Figs_C<>\"\",Test_Held_Last_Test_New_Figs_C,IF(Test_Held_Last_Test_New_Figs_NYC<>\"\",Test_Held_Last_Test_New_Figs_NYC,IF(Test_Held_Skate_Ups_Figures_C<>\"\",Test_Held_Skate_Ups_Figures_C,\"\")))","v":""},{"$f":"IF(Test_Held_Figures_A<>\"\",Test_Held_Figures_A,IF(Test_Held_Figures_B<>\"\",Test_Held_Figures_B,\"\"))","v":""},{"$f":"IF(Test_Held_First_Test_Loops<>\"\",Test_Held_First_Test_Loops,IF(Test_Held_Last_Test_Old_Loops_C<>\"\",Test_Held_Last_Test_Old_Loops_C,IF(Test_Held_Last_Test_Old_Loops_NYC<>\"\",Test_Held_Last_Test_Old_Loops_NYC,\"\")))","v":""},{"$f":"IF(Test_Held_Last_Test_New_Loops_C<>\"\",Test_Held_Last_Test_New_Loops_C,IF(Test_Held_Last_Test_New_Loops_NYC<>\"\",Test_Held_Last_Test_New_Loops_NYC,IF(Test_Held_Skate_Ups_Loops_C<>\"\",Test_Held_Skate_Ups_Loops_C,\"\")))","v":""},{"$f":"IF(Test_Held_Loops_A<>\"\",Test_Held_Loops_A,IF(Test_Held_Loops_B<>\"\",Test_Held_Loops_B,\"\"))","v":""},{"$f":"IF(Test_Held_Figures<>\"\",Test_Held_Figures,IF(Test_Held_Loops<>\"\",Test_Held_Loops,\"\"))","v":""}]
["TEST CENTRE:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Held is","Test Held is",null,"Test Held is","Test Held is",null,"Test Held is",null,"Test Held is",null,"Test Held is",null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"NYC\"),IF(ISNA(VLOOKUP(Test_Done_Last_Test_New_Figs_NYC,New_Figs_Level_Held_NYC_List,2,FALSE)),\"\",(VLOOKUP(Test_Done_Last_Test_New_Figs_NYC,New_Figs_Level_Held_NYC_List,2,FALSE))))","v":false},null,"Test Held is",null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"NYC\"),IF(ISNA(VLOOKUP(Test_Done_Last_Test_New_Loops_NYC,New_Loops_Level_Held_NYC_List,2,FALSE)),\"\",(VLOOKUP(Test_Done_Last_Test_New_Loops_NYC,New_Loops_Level_Held_NYC_List,2,FALSE))))","v":false},null,"Test Held is",null,"Test Held is",null,"Next Test to be done"]
["TEST DATE:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_Figures=\"\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"None\",IF(AND(Test_Date_Y_N=\"NO\",Test_Number_Figures=\"F01\",Previous_Test_Type=\"N/A\",Previous_Test_Number=\"N/A\",Previous_Test_Result=\"N/A\"),\"None\",\"\")))","v":""},{"$f":"IF(Test_Number_Loops=\"\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"None\",IF(AND(Test_Date_Y_N=\"NO\",Test_Number_Loops=\"FL1\",Previous_Test_Type=\"N/A\",Previous_Test_Number=\"N/A\",Previous_Test_Result=\"N/A\"),\"None\",\"\")))","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"Old Figures\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Test_Done_Last_Test_Old_Figs_NYC=1),\"None\",IF(Test_Done_Last_Test_Old_Figs_NYC<>\"\",+Test_Done_Last_Test_Old_Figs_NYC-1,\"\"))","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"Old Loops\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Test_Done_Last_Test_Old_Loops_NYC=1),\"None\",IF(Test_Done_Last_Test_Old_Loops_NYC<>\"\",+Test_Done_Last_Test_Old_Loops_NYC-1,\"\"))","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(AND(Test_Held_New_Figs_NYC_LOOKUP<>\"F01\",Test_Held_New_Figs_NYC_LOOKUP<>\"F02\",Test_Held_New_Figs_NYC_LOOKUP<>\"F03\",Test_Held_New_Figs_NYC_LOOKUP<>\"F04\",Test_Held_New_Figs_NYC_LOOKUP<>\"F05\",Test_Held_New_Figs_NYC_LOOKUP<>\"F06\",Test_Held_New_Figs_NYC_LOOKUP<>\"F07\",Test_Held_New_Figs_NYC_LOOKUP<>\"F08\",Test_Held_New_Figs_NYC_LOOKUP<>\"F09\",Test_Held_New_Figs_NYC_LOOKUP<>\"F10\",Test_Held_New_Figs_NYC_LOOKUP<>\"F11\",Test_Held_New_Figs_NYC_LOOKUP<>\"F12\"),\"\",Test_Held_New_Figs_NYC_LOOKUP)","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(AND(Test_Held_New_Loops_NYC_LOOKUP<>\"FL1\",Test_Held_New_Loops_NYC_LOOKUP<>\"FL2\",Test_Held_New_Loops_NYC_LOOKUP<>\"FL3\",Test_Held_New_Loops_NYC_LOOKUP<>\"FL4\",Test_Held_New_Loops_NYC_LOOKUP<>\"FL5\",Test_Held_New_Loops_NYC_LOOKUP<>\"FL6\"),\"\",Test_Held_New_Loops_NYC_LOOKUP)","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Previous_Test_Date_1=Test_Date_1,Test_Date_Y_N=\"YES\",Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"Skate Up\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Previous_Test_Date_1=Test_Date_1,Test_Date_Y_N=\"YES\",Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"Skate Up\"),Previous_Test_Number,\"\"))","v":""}]
["PARTNER:  (Hide)\n(Dance/Free Dance/Pairs only)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Test to be done","Next Test to be done",null,"Next Test to be done","Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Next Test to be done",null,"Figures A","Figures B","All Figures","Loops A","Loops B","All Loops","All"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Held_First_Test_Figs=\"None\",Figs_First_Test,\"\")","v":""},{"$f":"IF(Test_Held_First_Test_Loops=\"None\",Loops_First_Test,\"\")","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Test_Old_Figs_C,Transition_Old_to_New_Figs_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_Old_Figs_C,Transition_Old_to_New_Figs_List,2,FALSE)))","v":""},{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Test_Old_Figs_NYC,Transition_Old_to_New_Figs_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_Old_Figs_NYC,Transition_Old_to_New_Figs_List,2,FALSE)))","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Test_Old_Loops_C,Transition_Old_to_New_Figs_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_Old_Loops_C,Transition_Old_to_New_Loops_List,2,FALSE)))","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Test_Old_Loops_NYC,Transition_Old_to_New_Loops_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_Old_Loops_NYC,Transition_Old_to_New_Loops_List,2,FALSE)))","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"C\"),IF(ISNA(VLOOKUP(Test_Held_Last_Test_New_Figs_C,New_Figs_Next_Figure_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_New_Figs_C,New_Figs_Next_Figure_C_List,2,FALSE))),\"\")","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Test_New_Figs_NYC,New_Figs_Next_Test_NYC,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_New_Figs_NYC,New_Figs_Next_Test_NYC,2,FALSE)))","v":""},null,{"$f":"IF(AND(Test_Held_Last_Test_New_Loops_C=\"FL4\",Loop_4_held_in_Old_Structure=\"Yes\"),\"FL6\",IF(AND(Test_currently_held=\"FL4\",Loop_4_held_in_Old_Structure=\"No\"),\"FL5\",IF(AND(Previous_Test_Type=\"New Loops\",Previous_Test_Date_1<>Test_Date,Previous_Test_Result=\"C\"),IF(ISNA(VLOOKUP(Test_Held_Last_Test_New_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_New_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE))),\"\")))","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"NYC\"),+Previous_Test_Number,\"\")","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1=Test_Date_1,Previous_Test_Type=\"New Figures\",Previous_Test_Result=\"Skate Up\"),IF(ISNA(VLOOKUP(Test_Held_Skate_Ups_Figures_C,New_Figs_Next_Figure_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Skate_Ups_Figures_C,New_Figs_Next_Figure_C_List,2,FALSE))),\"\")","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1=Test_Date_1,Previous_Test_Type=\"New Loops\",Previous_Test_Result=\"Skate Up\"),IF(ISNA(VLOOKUP(Test_Held_Skate_Ups_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Skate_Ups_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE))),\"\")","v":""},null,{"$f":"IF(Figs_No_Previous_Test<>\"\",Figs_No_Previous_Test,IF(Figs_Old_C<>\"\",Figs_Old_C,IF(Figs_Old_NYC<>\"\",Figs_Old_NYC,\"\")))","v":""},{"$f":"IF(Figs_New_C<>\"\",Figs_New_C,IF(Figs_New_NYC<>\"\",Figs_New_NYC,IF(Figs_Skate_Up<>\"\",Figs_Skate_Up,\"\")))","v":""},{"$f":"IF(Figs_Next_To_Be_Done_A<>\"\",Figs_Next_To_Be_Done_A,IF(Figs_Next_To_Be_Done_B<>\"\",Figs_Next_To_Be_Done_B,\"\"))","v":""},{"$f":"IF(Loops_No_Previous_Test<>\"\",Loops_No_Previous_Test,IF(Loops_Old_C<>\"\",Loops_Old_C,IF(Loops_Old_NYC<>\"\",Loops_Old_NYC,\"\")))","v":""},{"$f":"IF(Loops_New_C<>\"\",Loops_New_C,IF(Loops_New_NYC<>\"\",Loops_New_NYC,IF(Loops_Skate_Up<>\"\",Loops_Skate_Up,\"\")))","v":""},{"$f":"IF(Loops_Next_To_Be_Done_A<>\"\",Loops_Next_To_Be_Done_A,IF(Loops_Next_To_Be_Done_B<>\"\",Loops_Next_To_Be_Done_B,\"\"))","v":""},{"$f":"IF(Figs_Next_To_Be_Done<>\"\",Figs_Next_To_Be_Done,IF(Loops_Next_To_Be_Done<>\"\",Loops_Next_To_Be_Done,\"\"))","v":""}]
["TEST DISCIPLINE",{"$f":"Name_Figures","v":"Figures"},{"$f":"Name_Loops","v":"Loops"},{"$f":"IF(AND(Previous_Test_Type=\"Old Figures\",Transition_Test_Numbers_1=\"Yes\"),IF(ISNA(VLOOKUP((Test_Held_Figures),Transition_Old_to_New_Figs_List,3,FALSE)),\"\",(VLOOKUP((Test_Held_Figures),Transition_Old_to_New_Figs_List,3,FALSE))),\"\")","v":""},null,null,null,null,null,null,null,null,null,"Transition",{"$f":"Previous_Test_Type","v":"N/A"},{"$f":"IF(Test_Number_Figures<>\"\",Test_Discipline_Figures,IF(Test_Number_Loops<>\"\",Test_Discipline_Loops,0))","v":0},null,{"$f":"IF(AND(Previous_Test_Structure=\"Old\",Test_Discipline=\"Figures\"),\"Old Figures\",IF(AND(Previous_Test_Structure=\"New\",Test_Discipline=\"Figures\"),\"New Figures\",IF(AND(Previous_Test_Structure=\"Old\",Test_Discipline=\"Loops\"),\"Old Loops\",IF(AND(Previous_Test_Structure=\"New\",Test_Discipline=\"Loops\"),\"New Loops\",IF(AND(Test_Discipline=\"Figures\",Previous_Test_Structure=\"N/A\"),\"N/A\",IF(AND(Test_Discipline=\"Loops\",Previous_Test_Structure=\"N/A\"),\"N/A\",\"N/A\"))))))","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Previous_Test_Type=\"New Loops\",Previous_Test_Date_1<>Test_Date,Previous_Test_Result=\"C\"),IF(ISNA(VLOOKUP(Test_Held_Last_Test_New_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Test_New_Loops_C,New_Loops_Next_Figure_C_List,2,FALSE))),\"\")","v":""},{"$f":"IF(AND(Test_Held_Last_Test_New_Loops_C=\"FL4\",Loop_4_held_in_Old_Structure=\"Yes\"),\"FL6\",IF(AND(Test_currently_held=\"FL4\",Loop_4_held_in_Old_Structure=\"No\"),\"FL5\",\"\"))","v":""}]
["TEST NO:",null,null,{"$f":"IF(Warnings=\"No warnings\",\"\",Warnings)","v":""},null,null,null,"Fee Paid:",null,null,"Award:",{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$R,15,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$R,15,FALSE)))","v":""},null,{"$f":"IF(Previous_Test_Type<>\"Old Figures\",\"No\",IF(Test_Held_Figures=\"15\",\"No\",IF(Warnings=\"No warnings\",IF(OR(Test_Held_Figures=1,Test_Held_Figures=5,Test_Held_Figures=6,Test_Held_Figures=8,Test_Held_Figures=9,Test_Held_Figures=10,Test_Held_Figures=11,Test_Held_Figures=12),\"Yes1\",IF(OR(Test_Held_Figures=7,Test_Held_Figures=13),\"Yes2\",\"No\")),\"\")))","v":"No"},null,{"$f":"IF(Test_Number_Figures<>\"\",Test_Number_Figures,IF(Test_Number_Loops<>\"\",Test_Number_Loops,\"\"))","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,"Check that the test in this form is the correct test to be done next"]
["If a Test in this discipline HAS NOT BEEN DONE previously - enter N/A into each of the 4 fields  below.\n\nIf a Test in this discipline HAS BEEN DONE previously - regardless of whether the result was C or NYC - enter the date of the previous Test and use the drop down arrows to enter data into each of the other 3 fields below.\n\nIf this is a SKATE UP - the Date of Previous Test must be the same date as the Test Date.\n\n\"Old\" - Test Structure which has been in use for many years.\n\"New\" - Test Structure which commenced in 2024.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Transition_Test_Numbers=\"Yes1\",Transition_Test_Numbers=\"Yes2\"),\"Yes\",\"No\")","v":"No"},{"$f":"Test_Held_Figures","v":""},"Couples Dance","Solo Dance","Figures","Loops","Free Skating","Couples Free Dance","Solo Free Dance","Free Skating Pairs","In-Line Free Skating","Precision",null,"Figures","Loops",null,"Transition Old to New",null,null,null,null,"NEW FIGURES\nPrevious Test was C\nNext Figure to be done",null,"NEW FIGURES\nPrevious Test was NYC\nWhich Test is held",null,"NEW FIGURES\nPrevious Test was NYC\nNext Figure to be done",null,{"$f":"IF(OR(Previous_Test_Date=\".\",Previous_Test_Date=\"\",Previous_Test_Date=\"N/A\",Previous_Test_Date=\"n/a\",Previous_Test_Date=\"N/a\",Previous_Test_Date=\"n/A\",Previous_Test_Date=\"na\",Previous_Test_Date=\"NA\"),\"NO\",\"YES\")","v":"NO"}]
["Date of previous Test in this discipline\n(whether C or NYC)",".","Was the previous Test in this discipline done in the Old or the New Test Structure\n(whether C or NYC)?",null,null,"Test Number of the last Test done in this discipline\n(whether C or NYC)?",null,null,"What was the Result of the last test done in this discipline?\n(whether C or NYC)",null,null,null,null,"Figure Draw","N/A",1,1,"F01","FL1",1,1,1,1,1,1,null,1,1,null,"         FIGURES\n  Test Held     Next to do",null,"Transition",null,null,"  Test Held     Next to do",null,"  Test NYC     Test Held",null,"  Test Held         Next Test",null,"Figures - no previous test","Loops - no previous test",null,"Old Figures","New Figures","Old Loops","New Loops","Skate Ups - Figures","Skate Ups - Loops","        Note re No Previous Test, Wrong Test Number OR Skate Ups\n\n\n                    No Previous                                              Wrong Test No                                          Skate Ups",null,null,"Warning Notes"]
["Prior to printing sheets, when the foot draw has been done, enter the starting foot for the first applicable Figure.",null,null,{"$f":"IF(Test_currently_held=\"\",\"\",IF(Test_currently_held=\"FL4\",\"Does the Skater hold Loop No 4 Test in the Old Structure?\",\"\"))","v":""},null,null,null,null,"Test currently held is:",null,{"$f":"IF(Test_Held=\"\",\"\",Test_Held)","v":""},null,null,{"$f":"IF(OR(Test_Number_Figures=\"F04\",Test_Number_Figures=\"F06\",Test_Number_Figures=\"F07\",Test_Number_Figures=\"F08\",Test_Number_Figures=\"F09\",Test_Number_Figures=\"F10\",Test_Number_Figures=\"F11\",Test_Number_Figures=\"F12\"),\"Yes\",\"No\")","v":"No"},null,2,2,"F02","FL2",2,2,2,2,2,2,null,2,2,null,"None","F01",null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_Figures=\"\",\"\",IF(AND(Test_Discipline=\"Figures\",Test_Number_Figures=\"F01\",Test_Date_Y_N=\"NO\"),\"First Figure Test\",\"\"))","v":""},{"$f":"IF(Test_Number_Loops=\"\",\"\",IF(AND(Test_Discipline=\"Loops\",Test_Number_Loops=\"FL1\",Test_Date_Y_N=\"NO\"),\"First Loop Test\",\"\"))","v":""},null,{"$f":"IF(Test_Number_Figures=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(Previous_Test_Type<>\"Old Figures\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_Figures,\"\",\"This is not the next Test to be done.  Please refer to the Transition Table.\"))))))","v":""},{"$f":"IF(Test_Number_Figures=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(Previous_Test_Type<>\"New Figures\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_Figures,\"\",\"This is not the next Test to be done.  Please refer to the Transition Table.\"))))))","v":""},{"$f":"IF(Test_Number_Loops=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Previous_Test_Type<>\"Old Loops\",\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_Loops,\"\",\"This is not the next Test to be done.  Please refer to the Transition Table.\"))))))","v":""},{"$f":"IF(Test_Number_Loops=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(Test_to_be_done_now=\"\",\"\",IF(Previous_Test_Type<>\"New Loops\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_Loops,\"\",\"This is not the next Test to be done.  Please refer to the Transition Table.\")))))))","v":""},{"$f":"IF(AND(Previous_Test_Type=\"New Figures\",Test_Number_Figures<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now<>Test_Number_Figures),\"This is not the next Test to be done.  Please refer to the Transition Table.\",IF(AND(Previous_Test_Type=\"New Figures\",Test_Number_Figures<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now=Test_Number_Figures),\"This is a Skate Up\",\"\"))","v":""},{"$f":"IF(AND(Previous_Test_Type=\"New Loops\",Test_Number_Loops<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now<>Test_Number_Loops),\"This is not the next Test to be done.  Please refer to the Transition Table.\",IF(AND(Previous_Test_Type=\"New Loops\",Test_Number_Loops<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now=Test_Number_Loops),\"This is a Skate Up.  Please check the result of the previous Test before proceeding.\",\"\"))","v":""},{"$f":"IF(Figs_First_Test_to_be_done<>\"\",Figs_First_Test_to_be_done,IF(Loops_First_Test_to_be_done<>\"\",Loops_First_Test_to_be_done,\"\"))","v":""},{"$f":"IF(Figs_Old_Wrong_Test<>\"\",Figs_Old_Wrong_Test,IF(Figs_New_Wrong_Test<>\"\",Figs_New_Wrong_Test,IF(Loops_Old_Wrong_Test<>\"\",Loops_Old_Wrong_Test,IF(Loops_New_Wrong_Test<>\"\",Loops_New_Wrong_Test,\"\"))))","v":""},{"$f":"IF(Skate_Ups_Figs<>\"\",Skate_Ups_Figs,IF(Skate_Ups_Loops<>\"\",Skate_Ups_Loops,\"\"))","v":""},{"$f":"IF(Warning_No_Previous_Test<>\"\",\"\",IF(Warning_Other<>\"\",Warning_Other,IF(Warning_Skate_Ups<>\"\",Warning_Skate_Ups,\"No warnings\")))","v":"No warnings"}]
[null,null,{"$f":"IF(Test_Number=\"\",\"\",IF(Foot_Draw_Required=\"Yes\",\"\",IF(Foot_Draw_Required=\"No\",\"\",\"\")))","v":""},null,null,null,null,null,"The next Test for this Skater is:",null,{"$f":"IF(Next_Test_To_Be_Done<>\"\",Next_Test_To_Be_Done,\"\")","v":""},null,null,"a","Old",3,3,"F03","FL3",3,3,3,3,3,3,null,3,3,null,1,"F01","Figure No 1 already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"None","F01","F01","None","None","F01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"b","New",4,4,"F04","FL4",4,null,null,4,null,null,null,4,4,null,2,"F02",null,null,null,"F01","F02","F02","F01","F01","F02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New",5,5,"F05","FL5",5,null,null,5,null,null,null,5,5,null,3,"F03",null,null,null,"F02","F03","F03","F02","F02","F03"]
["Minimum Mark per Figure:",{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$R,12,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$R,12,FALSE)))","v":""},"(Hide)",null,null,null,null,"Freeskating Singles/Pairs/Freedance/Precision only:",null,null,null,null,null,null,"C",6,6,"F06","FL6",6,null,null,6,null,null,null,6,null,null,4,"F04",null,null,null,"F03","F04","F04","F03","F03","F04"]
["Minimum Total Mark:",{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$R,13,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$R,13,FALSE)))","v":""},"(Hide)",null,null,null,null,"Maximum time:",null,{"$f":"IF(ISNA(VLOOKUP($O$28,'Test Details'!$D:$R,14,FALSE)),\"\",(VLOOKUP($O$28,'Test Details'!$D:$R,14,FALSE)))","v":""},null,null,null,null,"NYC",7,7,"F07",null,7,null,null,null,null,null,null,7,null,null,5,"F04","Figures Nos 9a and 9b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F04","F05","F05","F04","F04","F05"]
[null,null,"(Hide)",null,null,null,null,null,null,null,null,null,null,null,null,8,8,"F08",null,8,null,null,null,null,null,null,8,null,null,6,"F05","Figure No 11 already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F05","F06","F06","F05","F05","F06"]
[null,null,"(Hide)",null,null,null,null,null,null,null,null,null,null,null,"Skate Up",9,9,"F09",null,null,null,null,null,null,null,null,9,null,null,7,"F05","Figures Nos 10 and 11 already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F06","F07","F07","F06","F06","F07"]
[null,"Fig No.","Description",null,null,null,null,null,null,null,null,null,null,null,null,10,10,"F10",null,null,null,null,null,null,null,null,10,null,null,8,"F06","Figures Nos 28a and 28b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F07","F08","F08","F07","F07","F08"]
["1.",{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,2,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,2,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,8,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,8,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,10,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,10,FALSE))))))","v":""},{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,3,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,3,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,9,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,9,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,11,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,11,FALSE))))))","v":""},null,null,null,null,{"$f":"IF(Previous_Test_Type=\"N/A\",\"\",IF(Warnings=\"This is not the next Test to be done.  Please refer to the Transition Table.\",\"\",IF(Transition_Test_Numbers=\"Yes1\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,5,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,5,FALSE))),IF(Transition_Test_Numbers=\"Yes2\",IF(ISNA(VLOOKUP($O28,'Test Details'!$D:$R,7,FALSE)),\"\",(VLOOKUP($O28,'Test Details'!$D:$R,7,FALSE))),IF(Transition_Test_Numbers=\"No\",\"\")))))","v":""},null,null,null,null,null,{"$f":"IF($P$15>0,MATCH($P$16,$B$16:$C$16),MATCH($R$16,$B$16:$C$16))","v":{"$error":"#N/A"}},{"$f":"OFFSET($A$15,0,N28)&OFFSET($A$16,0,N28)&A28","v":{"$error":"#N/A"}},11,11,"F11",null,null,null,null,null,null,null,null,11,null,null,9,"F07","Figures Nos 22a and 22b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F08","F09","F09","F08","F08","F09"]
["2.",{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,2,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,2,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,8,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,8,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,10,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,10,FALSE))))))","v":""},{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,3,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,3,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,9,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,9,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,11,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,11,FALSE))))))","v":""},null,null,null,null,{"$f":"IF(Previous_Test_Type=\"N/A\",\"\",IF(Warnings=\"This is not the next Test to be done.  Please refer to the Transition Table.\",\"\",IF(Transition_Test_Numbers=\"Yes1\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,5,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,5,FALSE))),IF(Transition_Test_Numbers=\"Yes2\",IF(ISNA(VLOOKUP($O29,'Test Details'!$D:$R,7,FALSE)),\"\",(VLOOKUP($O29,'Test Details'!$D:$R,7,FALSE))),IF(Transition_Test_Numbers=\"No\",\"\")))))","v":""},null,null,null,null,null,{"$error":"#N/A"},{"$f":"OFFSET($A$15,0,N29)&OFFSET($A$16,0,N29)&A29","v":{"$error":"#N/A"}},12,12,"F12",null,null,null,null,null,null,null,null,12,null,null,10,"F07","Figures Nos 22a and 22b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F09","F10","F10","F09","F09","F10"]
["3.",{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,2,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,2,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,8,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,8,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,10,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,10,FALSE))))))","v":""},{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,3,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,3,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,9,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,9,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,11,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,11,FALSE))))))","v":""},null,null,null,null,{"$f":"IF(Previous_Test_Type=\"N/A\",\"\",IF(Warnings=\"This is not the next Test to be done.  Please refer to the Transition Table.\",\"\",IF(Transition_Test_Numbers=\"Yes1\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,5,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,5,FALSE))),IF(Transition_Test_Numbers=\"Yes2\",IF(ISNA(VLOOKUP($O30,'Test Details'!$D:$R,7,FALSE)),\"\",(VLOOKUP($O30,'Test Details'!$D:$R,7,FALSE))),IF(Transition_Test_Numbers=\"No\",\"\")))))","v":""},null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,13,null,null,null,null,null,null,null,null,null,13,null,null,11,"F08","Figures Nos 4, 23a and 23b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F10","F11","F11","F10","F10","F11"]
["4.",{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,2,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,2,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,8,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,8,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,10,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,10,FALSE))))))","v":""},{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,3,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,3,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,9,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,9,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,11,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,11,FALSE))))))","v":""},null,null,null,null,{"$f":"IF(Previous_Test_Type=\"N/A\",\"\",IF(Warnings=\"This is not the next Test to be done.  Please refer to the Transition Table.\",\"\",IF(Transition_Test_Numbers=\"Yes1\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,5,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,5,FALSE))),IF(Transition_Test_Numbers=\"Yes2\",IF(ISNA(VLOOKUP($O31,'Test Details'!$D:$R,7,FALSE)),\"\",(VLOOKUP($O31,'Test Details'!$D:$R,7,FALSE))),IF(Transition_Test_Numbers=\"No\",\"\")))))","v":""},null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,14,{"$f":"Figure_Description_1&IF(Figure_Not_Necessary_1=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )&T(Figure_Not_Necessary_1)","v":""},{"$f":"IF(Figure_Not_Necessary_1=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )","v":""},{"$f":"IF(Figure_Not_Necessary_1=\"Already assessed as Competent - Skater can choose not to re-do\",+Minimum_Mark_per_Element,\"\")","v":""},null,null,null,null,null,null,14,null,null,12,"F09","Figures Nos 20a and 20b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F11","F12","F12","F11","F11","F12"]
["5.",{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,2,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,2,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,8,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,8,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,10,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,10,FALSE))))))","v":""},{"$f":"IF(OR(Foot_Drawn=\"\",Foot_Drawn=\"N/A\",Foot_Drawn=\"This is not required - please ignore\"),IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,3,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,3,FALSE))),IF(Foot_Drawn=\"a\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,9,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,9,FALSE))),IF(Foot_Drawn=\"b\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,11,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,11,FALSE))))))","v":""},null,null,null,null,{"$f":"IF(Previous_Test_Type=\"N/A\",\"\",IF(Warnings=\"This is not the next Test to be done.  Please refer to the Transition Table.\",\"\",IF(Transition_Test_Numbers=\"Yes1\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,5,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,5,FALSE))),IF(Transition_Test_Numbers=\"Yes2\",IF(ISNA(VLOOKUP($O32,'Test Details'!$D:$R,7,FALSE)),\"\",(VLOOKUP($O32,'Test Details'!$D:$R,7,FALSE))),IF(Transition_Test_Numbers=\"No\",\"\")))))","v":""},null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,15,{"$f":"Figure_Description_2&IF(Figure_Not_Necessary_2=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )&T(Figure_Not_Necessary_2)","v":""},{"$f":"IF(Figure_Not_Necessary_2=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )","v":""},{"$f":"IF(Figure_Not_Necessary_2=\"Already assessed as Competent - Skater can choose not to re-do\",+Minimum_Mark_per_Element,\"\")","v":""},null,null,null,null,null,null,15,null,null,13,"F09","Figures Nos 20a, 20b, 33a and 33b already assessed as Competent - Skater can choose not to re-do.","Already assessed as Competent - Skater can choose not to re-do",null,"F12","N/A",null,null,"F12","N/A"]
["6.",null,"Hide",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"BS",{"$f":"Figure_Description_3&IF(Figure_Not_Necessary_3=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )&T(Figure_Not_Necessary_3)","v":""},{"$f":"IF(Figure_Not_Necessary_3=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )","v":""},{"$f":"IF(Figure_Not_Necessary_3=\"Already assessed as Competent - Skater can choose not to re-do\",+Minimum_Mark_per_Element,\"\")","v":""},null,null,null,null,null,null,null,null,null,14,"F10"]
["7.",null,"Hide",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"SS",{"$f":"Figure_Description_4&IF(Figure_Not_Necessary_4=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )&T(Figure_Not_Necessary_4)","v":""},{"$f":"IF(Figure_Not_Necessary_4=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )","v":""},{"$f":"IF(Figure_Not_Necessary_4=\"Already assessed as Competent - Skater can choose not to re-do\",+Minimum_Mark_per_Element,\"\")","v":""},null,null,null,null,null,null,null,null,null,15,"N/A"]
["8.",null,"Hide",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,"GS",{"$f":"Figure_Description_5&IF(Figure_Not_Necessary_5=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )&T(Figure_Not_Necessary_5)","v":""},{"$f":"IF(Figure_Not_Necessary_5=\"Already assessed as Competent - Skater can choose not to re-do\",\" - \",\"\" )","v":""},{"$f":"IF(Figure_Not_Necessary_5=\"Already assessed as Competent - Skater can choose not to re-do\",+Minimum_Mark_per_Element,\"\")","v":""}]
["9.",null,"Hide",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["10.",null,"Hide",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,null,"Transition Old to New      LOOPS\n  Test Held     Next to do",null,null,null,null,"NEW LOOPS\nPrevious Test was C\nNext Figure to be done",null,"NEW LOOPS\nPrevious Test was NYC\nWhich Test is held",null,"NEW LOOPS\nPrevious Test was NYC\nWhich Test is held"]
[{"$f":"IF(Warnings=\"No warnings\",\"\",Warnings)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Name of Person completing the Application:",null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","FL1",null,null,null,"  Test Held     Next to do",null,"  Test NYC     Test Held",null,"  Test NYC     Test Held"]
["CONTENT LIST :  \n\n\nHIDE","SOLO FREE DANCE, COUPLES FREE DANCE, FREE SKATING, 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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"FL2",null,null,null,"FL1","FL2","FL1","None","None","FL1"]
["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."},null,null,null,2,"FL3",null,null,null,"FL2","FL3","FL2","FL1","FL1","FL2"]
["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,{"$error":"#N/A"},null,null,null,{"$f":"OFFSET($A$16,0,$N43)","v":{"$error":"#N/A"}},{"$f":"$A43","v":"1."},null,null,null,3,"FL4",null,null,null,"FL3","FL4","FL3","FL2","FL2","FL3"]
["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."},null,null,null,4,"FL4",null,null,null,"FL4","FL5","FL4","FL3","FL3","FL4"]
["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.",null,null,null,5,"N/A",null,null,null,"FL5","FL6","FL5","FL4","FL4","FL5"]
["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.",null,null,null,null,null,null,null,null,"FL6","N/A","FL6","FL5","FL5","FL6"]
["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.",null,null,null,null,null,null,null,null,null,null,null,null,"FL6","N/A"]
["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"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O53,'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"},"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"},{"$error":"#N/A"},null,null,"=IF(ISNA(VLOOKUP($O54,'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"},"12."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRONZE TESTS",null,null,"Calculate Result",null,"RESULTS","Judge 1","Judge 2","Judge 3","Although 2 Judges may be OK, take into account marks for J3 as well"]
[null,null,null,null,null,null,null,"Where do you want to save this Test Centre?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Award=\"1st Bronze Bar\",Award=\"2nd Bronze Bar\",Award=\"3rd Bronze Bar\",Award=\"Bronze Medal\"),\"Bronze\",\"\")","v":""},null,null,"Number of Figures in Test",null,"1st Figure",{"$f":"IF(Value_J1_Element_1=\"\",\"\",IF(Figure_1st_Applic_Form=\"\",0,IF(AND(Value_J1_Element_1>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J2_Element_1=\"\",\"\",IF(Figure_1st_Applic_Form=\"\",0,IF(AND(Value_J2_Element_1>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J3_Element_1=\"\",\"\",IF(Figure_1st_Applic_Form=\"\",0,IF(AND(Value_J3_Element_1>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""}]
[null,null,null,null,null,null,null,"C:\\Temp",null,null,null,null,null,null,null,null,null,null,null,"Judge 1","Judge 2","Judge 3",{"$f":"IF(Figure_1st=\"\",\"\",1)","v":""},null,"2nd Figure",{"$f":"IF(Value_J1_Element_2=\"\",\"\",IF(Figure_2nd_Applic_Form=\"\",0,IF(AND(Value_J1_Element_2>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J2_Element_2=\"\",\"\",IF(Figure_2nd_Applic_Form=\"\",0,IF(AND(Value_J2_Element_2>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J3_Element_2=\"\",\"\",IF(Figure_2nd_Applic_Form=\"\",0,IF(AND(Value_J3_Element_2>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Which Judges on Panel",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(OR(Result_J1=\"C\",Result_J1=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(OR(Result_J2=\"C\",Result_J2=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(OR(Result_J3=\"C\",Result_J3=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Figure_2nd=\"\",\"\",1)","v":""},null,"3rd Figure",{"$f":"IF(Value_J1_Element_3=\"\",\"\",IF(Figure_3rd_Applic_Form=\"\",0,IF(AND(Value_J1_Element_3>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J2_Element_3=\"\",\"\",IF(Figure_3rd_Applic_Form=\"\",0,IF(AND(Value_J2_Element_3>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J3_Element_3=\"\",\"\",IF(Figure_3rd_Applic_Form=\"\",0,IF(AND(Value_J3_Element_3>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment per Judge",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Result_J1=\"\",\"\",Result_J1))","v":""},{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Result_J2=\"\",\"\",Result_J2))","v":""},{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Result_J3=\"\",\"\",Result_J3))","v":""},{"$f":"IF(Figure_3rd=\"\",\"\",1)","v":""},null,"4th Figure",{"$f":"IF(Value_J1_Element_4=\"\",\"\",IF(Figure_4th_Applic_Form=\"\",0,IF(AND(Value_J1_Element_4>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J2_Element_4=\"\",\"\",IF(Figure_4th_Applic_Form=\"\",0,IF(AND(Value_J2_Element_4>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J3_Element_4=\"\",\"\",IF(Figure_4th_Applic_Form=\"\",0,IF(AND(Value_J3_Element_4>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""}]
["FileName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Cs",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",COUNTIF(T59:V59,\"C\"))","v":""},null,null,{"$f":"IF(Figure_4th=\"\",\"\",1)","v":""},null,"5th Figure",{"$f":"IF(Value_J1_Element_5=\"\",\"\",IF(Figure_5th_Applic_Form=\"\",0,IF(AND(Value_J1_Element_5>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J2_Element_5=\"\",\"\",IF(Figure_5th_Applic_Form=\"\",0,IF(AND(Value_J2_Element_5>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""},{"$f":"IF(Value_J3_Element_5=\"\",\"\",IF(Figure_5th_Applic_Form=\"\",0,IF(AND(Value_J3_Element_5>=Minimum_Mark_per_Element),\"C\",\"NYC\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Judges on Panel",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",COUNTIF(T58:V58,\"Yes\"))","v":""},null,null,{"$f":"IF(Figure_5th=\"\",\"\",1)","v":""},null,"No. Results",{"$f":"COUNT(Number_of_Results_J1)","v":0},{"$f":"COUNT(Number_of_Results_J2)","v":0},{"$f":"COUNT(Number_of_Results_J3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Result - 3 Judges",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Number_of_Judges_on_Panel_Bronze<>3,\"\",IF(OR(Number_of_Cs_Bronze=3,Number_of_Cs_Bronze=2),\"Competent\",IF(OR(Number_of_Cs_Bronze>=1,Number_of_Cs_Bronze>=0),\"Not Yet Competent\"))))","v":""},null,null,{"$f":"SUM(W57:W61)","v":0},null,"Number of \"C\"",{"$f":"COUNTIF(Result_Each_Figure_J1,\"C\")","v":0},{"$f":"COUNTIF(Result_Each_Figure_J2,\"C\")","v":0},{"$f":"COUNTIF(Result_Each_Figure_J3,\"C\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Result - 2 Judges",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Number_of_Judges_on_Panel_Bronze<>2,\"\",IF(Number_of_Cs_Bronze=2,\"Competent\",IF(Number_of_Cs_Bronze=1,\"Video Review Required\",IF(Number_of_Cs_Bronze=0,\"Not Yet Competent\")))))","v":""},null,null,"Award",null,"Result",{"$f":"IF(Number_of_Figures_in_the_Test=0,\"\",IF(Number_of_Results_Entered_J1<>Number_of_Figures_in_the_Test,\"\",IF(Number_C_J1=Number_of_Figures_in_the_Test,\"C\",\"NYC\")))","v":""},{"$f":"IF(Number_of_Figures_in_the_Test=0,\"\",IF(Number_of_Results_Entered_J2<>Number_of_Figures_in_the_Test,\"\",IF(Number_C_J2=Number_of_Figures_in_the_Test,\"C\",\"NYC\")))","v":""},{"$f":"IF(Number_of_Figures_in_the_Test=0,\"\",IF(Number_of_Results_Entered_J3<>Number_of_Figures_in_the_Test,\"\",IF(Number_C_J3=Number_of_Figures_in_the_Test,\"C\",\"NYC\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Result - 1 Judge",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",IF(Number_of_Judges_on_Panel_Bronze<>1,\"\",\"Video Review Required\"))","v":""},null,null,{"$f":"IF(OR(Award=\"1st Silver Bar\",Award=\"2nd Silver Bar\",Award=\"3rd Silver Bar\",Award=\"Silver Medal\",Award=\"1st Gold Bar\",Award=\"2nd Gold Bar\",Award=\"3rd Gold Bar\",Award=\"Gold Medal\"),\"2 Judges OK\",\"Must Have 3 Judges\")","v":"Must Have 3 Judges"},null,"No. Judges on Panel",{"$f":"IF(AND(Number_of_Results_Entered_J1>0,Number_of_Results_Entered_J2>0,Number_of_Results_Entered_J3>0),3,IF(AND(Number_of_Results_Entered_J1>0,Number_of_Results_Entered_J2>0,Number_of_Results_Entered_J3=0),2,\"Did Not Skate\"))","v":"Did Not Skate"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Result",{"$f":"IF(Result_Bronze_3_Judges<>\"\",Result_Bronze_3_Judges,IF(Result_Bronze_2_Judges<>\"\",Result_Bronze_2_Judges,IF(Result_Bronze_1_Judge<>\"\",Result_Bronze_1_Judge,\"\")))","v":""},null,null,null,null,"No. Judges \"C\"",{"$f":"COUNTIF(Result_All_Judges,\"C\")","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,"Result - 0 Judges",{"$f":"IF(Number_Judges_on_Panel=0,\"Did Not Skate\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SILVER TESTS",null,null,null,null,"Result - 2 Judges & 1 C",{"$f":"IF(Number_Judges_on_Panel=2,IF(Number_of_Judges_C=1,\"Video Review Required\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Award=\"1st Silver Bar\",Award=\"2nd Silver  Bar\",Award=\"3rd Silver  Bar\",Award=\"Gold Silver\"),\"Silver\",\"\")","v":""},null,null,null,null,"Result - 2 Judges & 2 Cs",{"$f":"IF(Number_Judges_on_Panel=2,IF(Number_of_Judges_C=2,\"Competent\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Which Judges on Panel",{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(OR(Result_J1=\"C\",Result_J1=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(OR(Result_J2=\"C\",Result_J2=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(OR(Result_J3=\"C\",Result_J3=\"NYC\"),\"Yes\",\"No\"))","v":""},null,null,"Result 2 Judges",{"$f":"IF(Result_2_Judges_0_Cs<>\"\",Result_2_Judges_0_Cs,IF(Result_2_Judges_1_C<>\"\",Result_2_Judges_1_C,IF(Result_2_Judges_2_Cs<>\"\",Result_2_Judges_2_Cs,\"\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment per Judge",{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Result_J1=\"\",\"\",Result_J1))","v":""},{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Result_J2=\"\",\"\",Result_J2))","v":""},{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Result_J3=\"\",\"\",Result_J3))","v":""},null,null,"Result - 3 Judges & 0 Cs",{"$f":"IF(Number_Judges_on_Panel=3,IF(Number_of_Judges_C=0,\"Not Yet Competent\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Cs",{"$f":"IF(Award_Silver<>\"Silver\",\"\",COUNTIF(T70:V70,\"C\"))","v":""},null,null,null,null,"Result - 3 Judges & 1 C",{"$f":"IF(Number_Judges_on_Panel=3,IF(Number_of_Judges_C=1,\"Not Yet Competent\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Judges on Panel",{"$f":"IF(Award_Silver<>\"Silver\",\"\",COUNTIF(T69:V69,\"Yes\"))","v":""},null,null,null,null,"Result - 3 Judges & 2 Cs",{"$f":"IF(Number_Judges_on_Panel=3,IF(Number_of_Judges_C=2,\"Competent\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver Result - 3 Judges",{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Number_of_Judges_on_Panel_Silver<>3,\"\",IF(OR(Number_of_Cs_Silver=3,Number_of_Cs_Silver=2),\"Competent\",IF(OR(Number_of_Cs_Silver>=1,Number_of_Cs_Silver>=0),\"Not Yet Competent\"))))","v":""},null,null,null,null,"Result - 3 Judges & 3 Cs",{"$f":"IF(Number_Judges_on_Panel=3,IF(Number_of_Judges_C=3,\"Competent\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver Result - 2 Judges",{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Number_of_Judges_on_Panel_Silver<>2,\"\",IF(Number_of_Cs_Silver=2,\"Competent\",IF(Number_of_Cs_Silver=1,\"Video Review Required\",IF(Number_of_Cs_Silver=0,\"Not Yet Competent\")))))","v":""},null,null,null,null,"Result 3 Judges",{"$f":"IF(Result_3_Judges_0_Cs<>\"\",Result_3_Judges_0_Cs,IF(Result_3_Judges_1_C<>\"\",Result_3_Judges_1_C,IF(Result_3_Judges_2_Cs<>\"\",Result_3_Judges_2_Cs,IF(Result_3_Judges_3_Cs<>\"\",Result_3_Judges_3_Cs,\"\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver Result - 1 Judge",{"$f":"IF(Award_Silver<>\"Silver\",\"\",IF(Number_of_Judges_on_Panel_Silver<>1,\"\",\"Did Not Skate\"))","v":""},null,null,null,null,"Overall Result",{"$f":"IF(Result_3_Judges=\"\",\"Did Not Skate\",IF(Result_0_Judges<>\"\",Result_0_Judges,IF(Result_2_Judges<>\"\",Result_2_Judges,IF(Result_3_Judges<>\"\",Result_3_Judges,\"\"))))","v":"Did Not Skate"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver Result",{"$f":"IF(Result_Silver_3_Judges<>\"\",Result_Silver_3_Judges,IF(Result_Silver_2_Judges<>\"\",Result_Silver_2_Judges,IF(Result_Silver_1_Judge<>\"\",Result_Silver_1_Judge,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GOLD TESTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Award=\"1st Gold Bar\",Award=\"2nd Gold Bar\",Award=\"3rd Gold Bar\",Award=\"Gold Medal\"),\"Gold\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Judge 1","Judge 2","Judge 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Which Judges on Panel",{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(OR(Result_J1=\"C\",Result_J1=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(OR(Result_J2=\"C\",Result_J2=\"NYC\"),\"Yes\",\"No\"))","v":""},{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(OR(Result_J3=\"C\",Result_J3=\"NYC\"),\"Yes\",\"No\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment per Judge",{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Result_J1=\"\",\"\",Result_J1))","v":""},{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Result_J2=\"\",\"\",Result_J2))","v":""},{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Result_J3=\"\",\"\",Result_J3))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Cs",{"$f":"IF(Award_Gold<>\"Gold\",\"\",COUNTIF(T82:V82,\"C\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Judges on Panel",{"$f":"IF(Award_Gold<>\"Gold\",\"\",COUNTIF(T81:V81,\"Yes\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold Result - 3 Judges",{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Number_of_Judges_on_Panel_Gold<>3,\"\",IF(OR(Number_of_Cs_Gold=3,Number_of_Cs_Gold=2),\"Competent\",IF(OR(Number_of_Cs_Gold>=1,Number_of_Cs_Gold>=0),\"Not Yet Competent\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold Result - 2 Judges",{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Number_of_Judges_on_Panel_Gold<>2,\"\",IF(Number_of_Cs_Gold=2,\"Competent\",IF(Number_of_Cs_Gold=1,\"Video Review Required\",IF(Number_of_Cs_Gold=0,\"Not Yet Competent\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold Result - 1 Judge",{"$f":"IF(Award_Gold<>\"Gold\",\"\",IF(Number_of_Judges_on_Panel_Gold<>1,\"\",\"Did Not Skate\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gold Result",{"$f":"IF(Result_Gold_3_Judges<>\"\",Result_Gold_3_Judges,IF(Result_Gold_2_Judges<>\"\",Result_Gold_2_Judges,IF(Result_Gold_1_Judge<>\"\",Result_Gold_1_Judge,\"\")))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Result",{"$f":"IF(Result_Bronze<>\"\",Result_Bronze,IF(Result_Silver<>\"\",Result_Silver,IF(Result_Gold<>\"\",Result_Gold,\"\")))","v":""}]

{"sheet":"Marking Sheet","index":2,"n_rows":177,"n_cols":13,"rows_kept":177,"cut":false,"hidden":false,"merged":[[151,0,151,10],[174,0,175,7],[174,8,174,10],[175,8,175,10],[91,2,91,6],[102,0,103,1],[93,0,93,1],[93,2,93,6],[49,2,49,6],[90,0,90,1],[100,0,101,1],[100,2,101,5],[100,6,101,8],[100,9,101,10],[102,2,103,5],[102,6,103,8],[102,9,103,10],[104,9,105,10],[106,0,107,1],[106,2,107,5],[106,6,107,8],[106,9,107,10],[108,0,108,10],[155,0,155,10],[172,0,173,7],[47,2,47,6],[9,0,9,1],[9,2,9,3],[50,2,50,6],[44,0,44,10],[48,0,48,1],[50,0,50,1],[59,0,60,1],[65,0,65,10],[48,2,48,6],[48,7,48,8],[57,9,58,10],[59,2,60,5],[59,6,60,8],[59,9,60,10],[61,0,62,1],[61,2,62,5],[61,6,62,8],[61,9,62,10],[63,0,64,1],[63,2,64,5],[63,6,64,8],[63,9,64,10],[30,0,30,1],[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],[8,2,8,6],[6,2,6,6],[6,0,6,1],[6,7,6,8],[7,0,7,1],[7,2,7,6],[12,9,13,10],[14,9,15,10],[16,9,17,10],[18,9,19,10],[20,9,21,10],[12,0,13,1],[14,0,15,1],[18,0,19,1],[20,0,21,1],[170,8,170,10],[171,8,171,10],[170,0,171,7],[16,0,17,1],[26,0,26,10],[23,0,23,3],[24,0,24,3],[23,4,24,10],[22,0,22,10],[36,0,36,1],[36,2,36,8],[37,0,37,1],[37,2,37,8],[38,0,38,1],[38,2,38,8],[39,0,39,1],[39,2,39,8],[40,0,40,1],[40,2,40,8],[47,0,47,1],[49,0,49,1],[27,0,27,10],[104,0,105,1],[104,2,105,5],[104,6,105,8],[122,0,122,1],[122,2,122,8],[123,0,123,1],[123,2,123,8],[124,0,124,1],[124,2,124,8],[94,0,94,1],[94,2,94,6],[95,0,95,1],[95,2,95,3],[95,8,95,10],[97,9,97,10],[98,0,99,1],[98,2,99,5],[98,6,99,8],[98,9,99,10],[109,0,109,3],[109,4,110,10],[110,0,110,3],[112,0,112,10],[113,0,113,10],[114,0,115,8],[114,9,114,10],[80,0,80,1],[80,2,80,8],[90,2,90,6],[87,0,87,10],[91,7,91,8],[92,0,92,1],[91,9,91,10],[92,7,92,8],[92,9,92,10],[81,0,81,1],[81,2,81,8],[82,0,82,1],[82,2,82,8],[83,0,83,1],[83,2,83,8],[84,0,84,1],[84,2,84,8],[88,0,88,10],[33,0,33,1],[33,2,33,8],[34,0,34,1],[34,2,34,8],[35,0,35,1],[35,2,35,8],[92,2,92,6],[91,0,91,1],[57,0,58,1],[57,2,58,5],[57,6,58,8],[74,0,74,1],[74,2,74,8],[75,0,75,1],[75,2,75,8],[76,0,76,1],[76,2,76,8],[77,0,77,1],[77,2,77,8],[78,0,78,1],[78,2,78,8],[79,0,79,1],[79,2,79,8],[41,0,41,1],[41,2,41,8],[9,8,9,10],[45,0,45,10],[48,9,48,10],[5,9,5,10],[6,9,6,10],[28,9,28,10],[28,0,29,8],[31,0,31,1],[30,2,30,8],[31,2,31,8],[32,0,32,1],[32,2,32,8],[12,6,13,8],[14,6,15,8],[16,6,17,8],[18,6,19,8],[20,6,21,8],[12,2,13,5],[14,2,15,5],[16,2,17,5],[18,2,19,5],[20,2,21,5],[11,9,11,10],[49,7,49,8],[49,9,49,10],[51,0,51,1],[51,2,51,6],[52,0,52,1],[52,2,52,3],[52,8,52,10],[54,9,54,10],[55,0,56,1],[55,2,56,5],[55,6,56,8],[55,9,56,10],[66,0,66,3],[66,4,67,10],[67,0,67,3],[69,0,69,10],[70,0,70,10],[71,0,72,8],[71,9,71,10],[73,0,73,1],[73,2,73,8],[116,0,116,1],[116,2,116,8],[117,0,117,1],[117,2,117,8],[118,0,118,1],[118,2,118,8],[119,0,119,1],[119,2,119,8],[120,0,120,1],[120,2,120,8],[121,0,121,1],[121,2,121,8],[125,0,125,1],[125,2,125,8],[126,0,126,1],[126,2,126,8],[127,0,127,1],[127,2,127,8],[130,0,130,10],[149,9,150,10],[131,0,131,10],[133,0,133,1],[133,2,133,6],[145,6,146,8],[145,9,146,10],[147,0,148,1],[147,2,148,5],[147,6,148,8],[147,9,148,10],[134,0,134,1],[134,2,134,6],[134,7,134,8],[134,9,134,10],[135,0,135,1],[135,2,135,6],[135,7,135,8],[135,9,135,10],[136,0,136,1],[136,2,136,6],[152,0,152,3],[152,4,153,10],[153,0,153,3],[156,0,157,8],[156,9,156,10],[137,0,137,1],[137,2,137,6],[138,0,138,1],[138,2,138,3],[138,8,138,10],[140,9,140,10],[141,0,142,1],[141,2,142,5],[141,6,142,8],[141,9,142,10],[143,0,144,1],[143,2,144,5],[143,6,144,8],[143,9,144,10],[145,0,146,1],[145,2,146,5],[149,0,150,1],[149,2,150,5],[149,6,150,8],[158,0,158,1],[158,2,158,8],[159,0,159,1],[159,2,159,8],[160,0,160,1],[160,2,160,8],[161,0,161,1],[161,2,161,8],[162,0,162,1],[162,2,162,8],[168,0,168,1],[168,2,168,8],[169,0,169,1],[169,2,169,8],[163,0,163,1],[163,2,163,8],[164,0,164,1],[164,2,164,8],[165,0,165,1],[165,2,165,8],[166,0,166,1],[166,2,166,8],[167,0,167,1],[167,2,167,8]]}
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},null,{"$f":"Club","v":0},null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},null,{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},null,{"$f":"Test_Centre","v":0},null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
["PARTNER",null,{"$f":"Partner","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
["TEST:",null,{"$f":"Test_Discipline","v":0},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},null,null,"Judge Number 1"]
[]
[{"$f":"IF(Previous_Test_Date=\"\",\"\",IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\"))","v":""},null,null,null,null,null,null,null,null,"Marks"]
[{"$f":"+Figure_1st","v":""},null,{"$f":"Figure_Description_1","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_1","v":""},null,null,{"$f":"IF(G13=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_2nd","v":""},null,{"$f":"Figure_Description_2","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_2","v":""},null,null,{"$f":"IF(G15=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_3rd","v":""},null,{"$f":"Figure_Description_3","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_3","v":""},null,null,{"$f":"IF(G17=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_4th","v":""},null,{"$f":"Figure_Description_4","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_4","v":""},null,null,{"$f":"IF(G19=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_5th","v":""},null,{"$f":"Figure_Description_5","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_5","v":""},null,null,{"$f":"IF(G21=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
["THE OVERALL ASSESSMENT WILL BE CALCULATED BY THE SOFTWARE\nAND DISPLAYED ON THE APPLICATION FORM"]
["Judge - Print Name & Sign"]
[{"$f":"Name_Judge_1","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
[]
["JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"]
[]
["COMMENTS",null,null,null,null,null,null,null,null,"ATTEMPTS"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},null,{"$f":"Club","v":0},null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},null,{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},null,{"$f":"Test_Centre","v":0},null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
["PARTNER",null,{"$f":"Partner","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[{"$f":"Label_Test","v":"TEST:"},null,{"$f":"Test_Discipline","v":0},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},null,null,"Judge Number 2"]
[]
[{"$f":"IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"Label_Marks","v":"Marks"}]
[{"$f":"+Figure_1st","v":""},null,{"$f":"Figure_Description_1","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_1","v":""},null,null,{"$f":"IF(G56=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_2nd","v":""},null,{"$f":"Figure_Description_2","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_2","v":""},null,null,{"$f":"IF(G58=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_3rd","v":""},null,{"$f":"Figure_Description_3","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_3","v":""},null,null,{"$f":"IF(G60=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_4th","v":""},null,{"$f":"Figure_Description_4","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_4","v":""},null,null,{"$f":"IF(G62=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_5th","v":""},null,{"$f":"Figure_Description_5","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_5","v":""},null,null,{"$f":"IF(G64=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"Overall_Result_Calculation_Note","v":"THE OVERALL ASSESSMENT WILL BE CALCULATED BY THE SOFTWARE\nAND DISPLAYED ON THE APPLICATION FORM"}]
["Judge - Print Name & Sign"]
[{"$f":"Name_Judge_2","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Judge_2=\"\",\"\",Name_Judge_2)","v":""}]
[]
[{"$f":"Label_Feedback","v":"JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"}]
[]
["COMMENTS",null,null,null,null,null,null,null,null,"ATTEMPTS"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Original_Form_to_be_sent_to_CAOC_Chair_Note","v":"Original to be sent to CAOC Chair"}]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},null,{"$f":"Club","v":0},null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},null,{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},null,{"$f":"Test_Centre","v":0},null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
["PARTNER",null,{"$f":"Partner","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[{"$f":"Label_Test","v":"TEST:"},null,{"$f":"Test_Discipline","v":0},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},null,null,"Judge Number 3"]
[]
[{"$f":"IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\")","v":""}]
[{"$f":"+Figure_1st","v":""},null,{"$f":"Figure_Description_1","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_1","v":""},null,null,{"$f":"IF(G99=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_2nd","v":""},null,{"$f":"Figure_Description_2","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_2","v":""},null,null,{"$f":"IF(G101=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_3rd","v":""},null,{"$f":"Figure_Description_3","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_3","v":""},null,null,{"$f":"IF(G103=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_4th","v":""},null,{"$f":"Figure_Description_4","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_4","v":""},null,null,{"$f":"IF(G105=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_5th","v":""},null,{"$f":"Figure_Description_5","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_5","v":""},null,null,{"$f":"IF(G107=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"Overall_Result_Calculation_Note","v":"THE OVERALL ASSESSMENT WILL BE CALCULATED BY THE SOFTWARE\nAND DISPLAYED ON THE APPLICATION FORM"}]
["Judge - Print Name & Sign"]
[{"$f":"Name_Judge_3","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Judge_3=\"\",\"\",Name_Judge_3)","v":""}]
[]
[{"$f":"Label_Feedback","v":"JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"}]
[]
["COMMENTS",null,null,null,null,null,null,null,null,"ATTEMPTS"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Original_Form_to_be_sent_to_CAOC_Chair_Note","v":"Original to be sent to CAOC Chair"}]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},null,{"$f":"Club","v":0},null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},null,{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},null,{"$f":"Test_Centre","v":0},null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
["PARTNER",null,{"$f":"Partner","v":0}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
[{"$f":"Label_Test","v":"TEST:"},null,{"$f":"Test_Discipline","v":0},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},null,null,"Referee"]
[]
[{"$f":"IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\")","v":""},null,null,null,null,null,null,null,null,"Comments"]
[{"$f":"+Figure_1st","v":""},null,{"$f":"Figure_Description_1","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_1","v":""},null,null,{"$f":"IF(G142=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_2nd","v":""},null,{"$f":"Figure_Description_2","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_2","v":""},null,null,{"$f":"IF(G144=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_3rd","v":""},null,{"$f":"Figure_Description_3","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_3","v":""},null,null,{"$f":"IF(G146=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_4th","v":""},null,{"$f":"Figure_Description_4","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_4","v":""},null,null,{"$f":"IF(G148=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"+Figure_5th","v":""},null,{"$f":"Figure_Description_5","v":""},null,null,null,{"$f":"+Figure_Not_Necessary_5","v":""},null,null,{"$f":"IF(G150=\"Already assessed as Competent - Skater can choose not to re-do\",\"N/A\",\"\")","v":""}]
[]
[{"$f":"Overall_Result_Calculation_Note","v":"THE OVERALL ASSESSMENT WILL BE CALCULATED BY THE SOFTWARE\nAND DISPLAYED ON THE APPLICATION FORM"}]
["Referee - Print Name & Sign"]
[{"$f":"Name_Referee","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Referee=\"\",\"\",Name_Referee)","v":""}]
[]
[]
["COMMENTS",null,null,null,null,null,null,null,null,"ATTEMPTS"]
[null,null,null,null,null,null,null,null,null,1,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For Solo Free Dance, Couples Free Dance, Free Skating, 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"]
[{"$f":"Original_Form_to_be_sent_to_CAOC_Chair_Note","v":"Original to be sent to CAOC Chair"}]

{"sheet":"Application Form","index":3,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[20,7,21,7],[13,0,13,1],[6,8,6,9],[12,1,12,4],[6,1,6,4],[10,1,10,4],[11,1,11,4],[18,0,19,0],[18,1,19,6],[20,0,21,0],[20,1,21,6],[20,8,21,8],[18,7,19,7],[18,8,19,8],[24,0,25,0],[24,1,25,6],[24,9,25,9],[14,2,14,4],[14,0,14,1],[14,7,14,9],[14,5,14,6],[16,7,16,9],[16,0,17,6],[20,9,21,9],[22,0,23,0],[22,1,23,6],[22,7,23,7],[22,8,23,8],[22,9,23,9],[18,9,19,9],[26,9,27,9],[24,7,25,7],[24,8,25,8],[43,7,44,9],[1,0,1,9],[2,0,2,9],[7,8,7,9],[7,6,7,7],[7,1,7,4],[8,8,8,9],[13,7,13,9],[8,6,8,7],[8,1,8,4],[9,1,9,4],[13,5,13,6],[13,2,13,4],[26,1,27,6],[42,0,42,4],[42,5,42,6],[43,0,44,2],[26,8,27,8],[26,0,27,0],[26,7,27,7],[18,15,18,19],[20,15,20,19],[22,15,22,19],[24,15,24,19],[26,15,26,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide","Hide","Hide","Hide","Hide"]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["APPLICATION FORM"]
[]
[]
[]
[{"$f":"Label_Name","v":"NAME:"},{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},{"$f":"Club","v":0},null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},null,{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},{"$f":"Test_Centre","v":0},null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"+'Data Entry Sheet'!B12","v":"00:00:00"}]
[]
["TEST",{"$f":"Test_Discipline","v":0}]
[{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""}]
[null,{"$f":"Award","v":""}]
["Date of previous test in this discipline\n(whether C or NYC)",null,{"$f":"Previous_Test_Date","v":"."},null,null,"Fee $ ",null,{"$f":"Fee_Paid","v":0}]
["Signed ",null,{"$f":"Name_of_Person_Authorising","v":0}]
[]
[{"$f":"\"Each Figure must receive at least the minimum mark of \" & Minimum_Mark_per_Element & \" to receive an assessment of C from a Judge.  The overall result will be Competent when an assessment of C is given by at least 2 of the Judges.\"","v":"Each Figure must receive at least the minimum mark of  to receive an assessment of C from a Judge.  The overall result will be Competent when an assessment of C is given by at least 2 of the Judges."},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":"Figure_1st","v":""},{"$f":"Figure_1st_and_No_Need_to_re_do_Note","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_1=\"\",\"\",Figure_1st_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_1=\"\",\"\",Figure_1st_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_1=\"\",\"\",Figure_1st_Enter_Min_Mark)","v":""},null,null,2,null,null,{"$f":"IF(Figure_Not_Necessary_1<>\"\",Figure_Not_Necessary_1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"Figure_2nd","v":""},{"$f":"Figure_2nd_and_No_Need_to_re_do_Note","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_2=\"\",\"\",Figure_2nd_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_2=\"\",\"\",Figure_2nd_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_2=\"\",\"\",Figure_2nd_Enter_Min_Mark)","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_2<>\"\",Figure_Not_Necessary_2,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Referee"]
[{"$f":"Figure_3rd","v":""},{"$f":"Figure_3rd_and_No_Need_to_re_do_Note","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_3=\"\",\"\",Figure_3rd_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_3=\"\",\"\",Figure_3rd_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_3=\"\",\"\",Figure_3rd_Enter_Min_Mark)","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_3<>\"\",Figure_Not_Necessary_3,\"\")","v":""}]
[]
[{"$f":"Figure_4th","v":""},{"$f":"Figure_4th_and_No_Need_to_re_do_Note","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_4=\"\",\"\",Figure_4th_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_4=\"\",\"\",Figure_4th_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_4=\"\",\"\",Figure_4th_Enter_Min_Mark)","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_4<>\"\",Figure_Not_Necessary_4,\"\")","v":""}]
[]
[{"$f":"Figure_5th","v":""},{"$f":"Figure_5th_and_No_Need_to_re_do_Note","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_5=\"\",\"\",Figure_5th_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_5=\"\",\"\",Figure_5th_Enter_Min_Mark)","v":""},{"$f":"IF(Figure_Not_Necessary_5=\"\",\"\",Figure_5th_Enter_Min_Mark)","v":""},null,null,null,null,null,{"$f":"IF(Figure_Not_Necessary_5<>\"\",Figure_Not_Necessary_5,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["JUDGES' ASSESSMENTS",null,null,null,null,"C = Competent\nNYC = Not Yet Competent",null,{"$f":"Result_J1_Calculated","v":""},{"$f":"Result_J2_Calculated","v":""},{"$f":"Result_J3_Calculated","v":""}]
["Referee's Signature",null,null,null,null,null,null,{"$f":"Overall_Result_Calculated","v":""}]

{"sheet":"Test Details","index":4,"n_rows":601,"n_cols":18,"rows_kept":601,"cut":false,"hidden":true,"merged":[[158,0,158,1]]}
["Test #",null,"Item #","Full Item - D:R - 1","Fig #  D:R - 2","Item Description - Normal  D:R - 3","Fig #  D:R - 4","Transition 1  D:R - 5","Fig #  D:R - 6","Transition 2  D:R - 7","Fig #  D:R - 8","Figures - Foot Draw - a Foot  D:R - 9","Fig #  D:R - 10","Figures - Foot Draw - b Foot  D:R - 11","Minimum Mark  D:R - 12","Passing Grade  D:R - 13","Maximum Time  D:R - 14","Award  D:R - 15"]
["Couples Dance"]
["Test #",null,"Item #","Full Item","Fig #","Item Description - Normal","Fig #",{"$f":"+H1","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J1","v":"Transition 2  D:R - 7"},null,{"$f":"+L1","v":"Figures - Foot Draw - a Foot  D:R - 9"},null,{"$f":"+N1","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$2&A4","v":"Couples Dance1"},"1.",{"$f":"B4&C4","v":"Couples Dance11."},null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",5,11,null,"1st Bronze Bar"]
[1,{"$f":"$A$2&A5","v":"Couples Dance1"},{"$f":"IF(B5=B4,TEXT(VALUE(C4)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B5&C5","v":"Couples Dance12."},null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango"]
[2,{"$f":"$A$2&A6","v":"Couples Dance2"},{"$f":"IF(B6=B5,TEXT(VALUE(C5)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B6&C6","v":"Couples Dance21."},null,"Society Blues - 88 Blues",null,"Society Blues - 88 Blues",null,"Society Blues - 88 Blues",null,"Society Blues - 88 Blues",null,"Society Blues - 88 Blues",5,12,null,"2nd Bronze Bar"]
[2,"Couples Dance2","2.","Couples Dance22.",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March"]
[3,"Couples Dance3","1.","Couples Dance31.",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",5,18,null,"3rd Bronze Bar"]
[3,"Couples Dance3","2.","Couples Dance32.",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz"]
[3,"Couples Dance3","3.","Couples Dance33.",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues"]
[4,"Couples Dance4","1.","Couples Dance41.",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",5,19.5,null,"Bronze Medal"]
[4,"Couples Dance4","2.","Couples Dance42.",null,"Southland Swing - 92 Blues or Foxtrot",null,"Southland Swing - 92 Blues or Foxtrot",null,"Southland Swing - 92 Blues or Foxtrot",null,"Southland Swing - 92 Blues or Foxtrot",null,"Southland Swing - 92 Blues or Foxtrot"]
[4,"Couples Dance4","3.","Couples Dance43.",null,"120 Waltz - 120 Waltz",null,"120 Waltz - 120 Waltz",null,"120 Waltz - 120 Waltz",null,"120 Waltz - 120 Waltz",null,"120 Waltz - 120 Waltz"]
[5,"Couples Dance5","1.","Couples Dance51.",null,"Collegiate - 92 Foxtrot",null,"Collegiate - 92 Foxtrot",null,"Collegiate - 92 Foxtrot",null,"Collegiate - 92 Foxtrot",null,"Collegiate - 92 Foxtrot",5,21,null,"1st Silver Bar"]
[5,"Couples Dance5","2.","Couples Dance52.",null,"Chase Waltz - 120 Waltz",null,"Chase Waltz - 120 Waltz",null,"Chase Waltz - 120 Waltz",null,"Chase Waltz - 120 Waltz",null,"Chase Waltz - 120 Waltz"]
[5,"Couples Dance5","3.","Couples Dance53.",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango"]
[6,"Couples Dance6","1.","Couples Dance61.",null,"Highland Schottische - 100 Schottische",null,"Highland Schottische - 100 Schottische",null,"Highland Schottische - 100 Schottische",null,"Highland Schottische - 100 Schottische",null,"Highland Schottische - 100 Schottische",5,21,null,"2nd Silver Bar"]
[6,"Couples Dance6","2.","Couples Dance62.",null,"Border Blues - 92 Blues",null,"Border Blues - 92 Blues",null,"Border Blues - 92 Blues",null,"Border Blues - 92 Blues",null,"Border Blues - 92 Blues"]
[6,"Couples Dance6","3.","Couples Dance63.",null,"Coronation Waltz - 120 Waltz",null,"Coronation Waltz - 120 Waltz",null,"Coronation Waltz - 120 Waltz",null,"Coronation Waltz - 120 Waltz",null,"Coronation Waltz - 120 Waltz"]
[7,"Couples Dance7","1.","Couples Dance71.",null,"Metropolitan Tango - 100 Tango",null,"Metropolitan Tango - 100 Tango",null,"Metropolitan Tango - 100 Tango",null,"Metropolitan Tango - 100 Tango",null,"Metropolitan Tango - 100 Tango",5,28,null,"3rd Silver Bar"]
[7,"Couples Dance7","2.","Couples Dance72.",null,"Imperial Waltz - 120 Waltz",null,"Imperial Waltz - 120 Waltz",null,"Imperial Waltz - 120 Waltz",null,"Imperial Waltz - 120 Waltz",null,"Imperial Waltz - 120 Waltz"]
[7,"Couples Dance7","3.","Couples Dance73.",null,"Adams Polka  -100 Polka",null,"Adams Polka  -100 Polka",null,"Adams Polka  -100 Polka",null,"Adams Polka  -100 Polka",null,"Adams Polka  -100 Polka"]
[7,"Couples Dance7","4.","Couples Dance74.",null,"Fascination Foxtrot - 92 Foxtrot",null,"Fascination Foxtrot - 92 Foxtrot",null,"Fascination Foxtrot - 92 Foxtrot",null,"Fascination Foxtrot - 92 Foxtrot",null,"Fascination Foxtrot - 92 Foxtrot"]
[8,"Couples Dance8","1.","Couples Dance81.",null,"Fourteen Step - 108 March",null,"Fourteen Step - 108 March",null,"Fourteen Step - 108 March",null,"Fourteen Step - 108 March",null,"Fourteen Step - 108 March",5,28,null,"Silver Medal"]
[8,"Couples Dance8","2.","Couples Dance82.",null,"Princeton Polka - 100 Polka",null,"Princeton Polka - 100 Polka",null,"Princeton Polka - 100 Polka",null,"Princeton Polka - 100 Polka",null,"Princeton Polka - 100 Polka"]
[8,"Couples Dance8","3.","Couples Dance83.",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot"]
[8,"Couples Dance8","4.","Couples Dance84.",null,"Marine Waltz - 108 Waltz",null,"Marine Waltz - 108 Waltz",null,"Marine Waltz - 108 Waltz",null,"Marine Waltz - 108 Waltz",null,"Marine Waltz - 108 Waltz"]
[9,"Couples Dance9","1.","Couples Dance91.",null,"Colonial Foxtrot - 100 Foxtrot",null,"Colonial Foxtrot - 100 Foxtrot",null,"Colonial Foxtrot - 100 Foxtrot",null,"Colonial Foxtrot - 100 Foxtrot",null,"Colonial Foxtrot - 100 Foxtrot",5,30,null,"1st Gold Bar"]
[9,"Couples Dance9","2.","Couples Dance92.",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz"]
[9,"Couples Dance9","3.","Couples Dance93.",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues"]
[9,"Couples Dance9","4.","Couples Dance94.",null,"International Waltz - 168 Waltz",null,"International Waltz - 168 Waltz",null,"International Waltz - 168 Waltz",null,"International Waltz - 168 Waltz",null,"International Waltz - 168 Waltz"]
[10,"Couples Dance10","1.","Couples Dance101.",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",5,30,null,"2nd Gold Bar"]
[10,"Couples Dance10","2.","Couples Dance102.",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot"]
[10,"Couples Dance10","3.","Couples Dance103.",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz"]
[10,"Couples Dance10","4.","Couples Dance104.",null,"Carroll Swing - 100 Boogie",null,"Carroll Swing - 100 Boogie",null,"Carroll Swing - 100 Boogie",null,"Carroll Swing - 100 Boogie",null,"Carroll Swing - 100 Boogie"]
[11,"Couples Dance11","1.","Couples Dance111.",null,"Pacifica Foxtrot - 100 Foxtrot",null,"Pacifica Foxtrot - 100 Foxtrot",null,"Pacifica Foxtrot - 100 Foxtrot",null,"Pacifica Foxtrot - 100 Foxtrot",null,"Pacifica Foxtrot - 100 Foxtrot",5,30,null,"3rd Gold Bar"]
[11,"Couples Dance11","2.","Couples Dance112.",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango"]
[11,"Couples Dance11","3.","Couples Dance113.",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March"]
[11,"Couples Dance11","4.","Couples Dance114.",null,"Starlight Waltz - 148 Waltz",null,"Starlight Waltz - 148 Waltz",null,"Starlight Waltz - 148 Waltz",null,"Starlight Waltz - 148 Waltz",null,"Starlight Waltz - 148 Waltz"]
[12,"Couples Dance12","1.","Couples Dance121.",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",5,45,null,"Gold Medal"]
[12,"Couples Dance12","2.","Couples Dance122.",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot"]
[12,"Couples Dance12","3.","Couples Dance123.",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble"]
[12,"Couples Dance12","4.","Couples Dance124.",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz"]
[12,"Couples Dance12","5.","Couples Dance125.",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango"]
[12,"Couples Dance12","6.","Couples Dance126.",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep"]
[]
["Solo Dance"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time"]
[1,{"$f":"$A$47&A49","v":"Solo Dance1"},"1.",{"$f":"B49&C49","v":"Solo Dance11."},null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",null,"Glide Waltz - 120 Waltz",5,11,null,"1st Bronze Bar"]
[1,{"$f":"$A$47&A50","v":"Solo Dance1"},{"$f":"IF(B50=B49,TEXT(VALUE(C49)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Dance12.",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango",null,"Masters Tango - 100 Tango"]
[2,"Solo Dance2","1.","Solo Dance21.",null,"Olympic Foxtrot - 104 Foxtrot",null,"Olympic Foxtrot - 104 Foxtrot",null,"Olympic Foxtrot - 104 Foxtrot",null,"Olympic Foxtrot - 104 Foxtrot",null,"Olympic Foxtrot - 104 Foxtrot",5,12,null,"2nd Bronze Bar"]
[2,"Solo Dance2","2.","Solo Dance22.",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March",null,"Skaters March - 100 March"]
[3,"Solo Dance3","1.","Solo Dance31.",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",null,"Canasta Tango - 100 Tango",5,12,null,"3rd Bronze Bar"]
[3,"Solo Dance3","2.","Solo Dance32.",null,"La Vista Cha Cha - 108 Cha Cha",null,"La Vista Cha Cha - 108 Cha Cha",null,"La Vista Cha Cha - 108 Cha Cha",null,"La Vista Cha Cha - 108 Cha Cha",null,"La Vista Cha Cha - 108 Cha Cha"]
[4,"Solo Dance4","1.","Solo Dance41.",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",null,"Rhythm Blues - 92 Blues",5,12,null,"4th Bronze Bar"]
[4,"Solo Dance4","2.","Solo Dance42.",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz",null,"Dutch Waltz - 138 Waltz"]
[5,"Solo Dance5","1.","Solo Dance51.",null,"Swing Foxtrot - 104 Foxtrot",null,"Swing Foxtrot - 104 Foxtrot",null,"Swing Foxtrot - 104 Foxtrot",null,"Swing Foxtrot - 104 Foxtrot",null,"Swing Foxtrot - 104 Foxtrot",5,19.5,null,"Bronze Medal"]
[5,"Solo Dance5","2.","Solo Dance52.",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka",null,"Denver Shuffle - 100 Polka"]
[5,"Solo Dance5","3.","Solo Dance53.",null,"Monterey Tango - 100 Tango",null,"Monterey Tango - 100 Tango",null,"Monterey Tango - 100 Tango",null,"Monterey Tango - 100 Tango",null,"Monterey Tango - 100 Tango"]
["BS","Solo DanceBS","1.","Solo DanceBS1.",null,null,null,null,null,null,null,null,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",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",null,"Siesta Tango - 100 Tango",5,14,null,"1st Silver Bar"]
[6,"Solo Dance6","2.","Solo Dance62.",null,"Marylee Foxtrot -  92 Foxtrot",null,"Marylee Foxtrot -  92 Foxtrot",null,"Marylee Foxtrot -  92 Foxtrot",null,"Marylee Foxtrot -  92 Foxtrot",null,"Marylee Foxtrot -  92 Foxtrot"]
[7,"Solo Dance7","1.","Solo Dance71.",null,"Spring Blues - 92 Blues",null,"Spring Blues - 92 Blues",null,"Spring Blues - 92 Blues",null,"Spring Blues - 92 Blues",null,"Spring Blues - 92 Blues",5,14,null,"2nd Silver Bar"]
[7,"Solo Dance7","2.","Solo Dance72.",null,"The Cha Cha - 100 Cha Cha",null,"The Cha Cha - 100 Cha Cha",null,"The Cha Cha - 100 Cha Cha",null,"The Cha Cha - 100 Cha Cha",null,"The Cha Cha - 100 Cha Cha"]
[8,"Solo Dance8","1.","Solo Dance81.",null,"Kleiner Waltz - 138 Waltz",null,"Kleiner Waltz - 138 Waltz",null,"Kleiner Waltz - 138 Waltz",null,"Kleiner Waltz - 138 Waltz",null,"Kleiner Waltz - 138 Waltz",5,14,null,"3rd Silver Bar"]
[8,"Solo Dance8","2.","Solo Dance82.",null,"Casino March - 100 March",null,"Casino March - 100 March",null,"Casino March - 100 March",null,"Casino March - 100 March",null,"Casino March - 100 March"]
[9,"Solo Dance9","1.","Solo Dance91.",null,"Tudor Waltz - 144 Waltz",null,"Tudor Waltz - 144 Waltz",null,"Tudor Waltz - 144 Waltz",null,"Tudor Waltz - 144 Waltz",null,"Tudor Waltz - 144 Waltz",5,14,null,"4th Silver Bar"]
[9,"Solo Dance9","2.","Solo Dance92.",null,"Federation Foxtrot - 96 Foxtrot",null,"Federation Foxtrot - 96 Foxtrot",null,"Federation Foxtrot - 96 Foxtrot",null,"Federation Foxtrot - 96 Foxtrot",null,"Federation Foxtrot - 96 Foxtrot"]
[10,"Solo Dance10","1.","Solo Dance101.",null,"Association Waltz - 132 Waltz",null,"Association Waltz - 132 Waltz",null,"Association Waltz - 132 Waltz",null,"Association Waltz - 132 Waltz",null,"Association Waltz - 132 Waltz",5,21,null,"Silver Medal"]
[10,"Solo Dance10","2.","Solo Dance102.",null,"Kent Tango - 100 Tango",null,"Kent Tango - 100 Tango",null,"Kent Tango - 100 Tango",null,"Kent Tango - 100 Tango",null,"Kent Tango - 100 Tango"]
[10,"Solo Dance10","3.","Solo Dance103.",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot",null,"Keats Foxtrot - 96 Foxtrot"]
["SS","Solo DanceSS",{"$f":"IF(B74=B73,TEXT(VALUE(C73)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B74&C74","v":"Solo DanceSS1."},null,null,null,null,null,null,null,null,null,null,5,30,null,"Silver Star"]
["SS","Solo DanceSS",{"$f":"IF(B75=B74,TEXT(VALUE(C74)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B75&C75","v":"Solo DanceSS2."}]
["SS","Solo DanceSS",{"$f":"IF(B76=B75,TEXT(VALUE(C75)+1,\"#\")&\".\",\"1.\")","v":"3."},{"$f":"B76&C76","v":"Solo DanceSS3."}]
["SS","Solo DanceSS",{"$f":"IF(B77=B76,TEXT(VALUE(C76)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B77&C77","v":"Solo DanceSS4."}]
[11,"Solo Dance11",{"$f":"IF(B78=B77,TEXT(VALUE(C77)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B78&C78","v":"Solo Dance111."},null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",null,"Dench Blues - 88 Blues",5,22.5,null,"1st Gold Bar"]
[11,"Solo Dance11","2.","Solo Dance112.",null,"Imperial Tango - 104 Tango",null,"Imperial Tango - 104 Tango",null,"Imperial Tango - 104 Tango",null,"Imperial Tango - 104 Tango",null,"Imperial Tango - 104 Tango"]
[11,"Solo Dance11","3.","Solo Dance113.",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz",null,"European Waltz - 120 Waltz"]
[12,"Solo Dance12","1.","Solo Dance121.",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March",null,"Kilian - 108 March",5,22.5,null,"2nd Gold Bar"]
[12,"Solo Dance12","2.","Solo Dance122.",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango",null,"Harris Tango - 100 Tango"]
[12,"Solo Dance12","3.","Solo Dance123.",null,"Terenzi Waltz - 168 Waltz",null,"Terenzi Waltz - 168 Waltz",null,"Terenzi Waltz - 168 Waltz",null,"Terenzi Waltz - 168 Waltz",null,"Terenzi Waltz - 168 Waltz"]
[13,"Solo Dance13","1.","Solo Dance131.",null,"14 Step Plus - 108 March",null,"14 Step Plus - 108 March",null,"14 Step Plus - 108 March",null,"14 Step Plus - 108 March",null,"14 Step Plus - 108 March",5,22.5,null,"3rd Gold Bar"]
[13,"Solo Dance13","2.","Solo Dance132.",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz",null,"Flirtation Waltz - 120 Waltz"]
[13,"Solo Dance13","3.","Solo Dance133.",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot",null,"Rocker Foxtrot - 104 Foxtrot"]
[14,"Solo Dance14","1.","Solo Dance141.",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",null,"Italian Foxtrot - 96 Foxtrot",5,30,null,"4th Gold Bar"]
[14,"Solo Dance14","2.","Solo Dance142.",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz",null,"Westminster Waltz - 138 Waltz"]
[14,"Solo Dance14","3.","Solo Dance143.",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango",null,"Iceland Tango - 100 Tango"]
[14,"Solo Dance14","4.","Solo Dance144.",null,"Starlight Waltz - 168 Waltz",null,"Starlight Waltz - 168 Waltz",null,"Starlight Waltz - 168 Waltz",null,"Starlight Waltz - 168 Waltz",null,"Starlight Waltz - 168 Waltz"]
[15,"Solo Dance15","1.","Solo Dance151.",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",null,"Argentine Tango - 96 Tango",5,37.5,null,"Gold Medal"]
[15,"Solo Dance15","2.","Solo Dance152.",null,"Tango Delancha - 104 Tango",null,"Tango Delancha - 104 Tango",null,"Tango Delancha - 104 Tango",null,"Tango Delancha - 104 Tango",null,"Tango Delancha - 104 Tango"]
[15,"Solo Dance15","3.","Solo Dance153.",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep",null,"Quickstep - 112 Quickstep"]
[15,"Solo Dance15","4.","Solo Dance154.",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz",null,"Viennese Waltz - 138 Waltz"]
[15,"Solo Dance15","5.","Solo Dance155.",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble",null,"Paso Doble - 112 Paso Doble"]
["GS","Solo DanceGS","1.",{"$f":"B96&C96","v":"Solo DanceGS1."},null,null,null,null,null,null,null,null,null,null,5,40,null,"Gold Star"]
["GS","Solo DanceGS","2.",{"$f":"B97&C97","v":"Solo DanceGS2."}]
["GS","Solo DanceGS","3.",{"$f":"B98&C98","v":"Solo DanceGS3."}]
["GS","Solo DanceGS","4.",{"$f":"B99&C99","v":"Solo DanceGS4."}]
["GS","Solo DanceGS","5.",{"$f":"B100&C100","v":"Solo DanceGS5."}]
[null,null,null,{"$f":"B101&\" \"&C101","v":" "}]
["Figures"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
["F01",{"$f":"$A$102&A104","v":"FiguresF01"},"1.",{"$f":"B104&C104","v":"FiguresF011."},1,"RFO - LFO Eight",1,"Already assessed as Competent - Skater can choose not to re-do",1,{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},1,"RFO - LFO Eight",1,"RFO - LFO Eight",4,{"$f":"O104*2","v":8},null,"1st Bronze Bar"]
["F01",{"$f":"$A$102&A105","v":"FiguresF01"},{"$f":"IF(B105=B104,TEXT(VALUE(C104)+1,\"#\")&\".\",\"1.\")","v":"2."},"FiguresF012.",2,"RFI - LFI Eight",2,null,2,null,2,"RFI - LFI Eight",2,"RFI - LFI Eight"]
["F02","FiguresF02","1.","FiguresF021.","5a","RFOI - LFIO Change Eight","5a",null,"5a",null,"5a","RFOI - LFIO Change Eight","5a","RFOI - LFIO Change Eight",4,{"$f":"O106*2","v":8},null,"2nd Bronze Bar"]
["F02","FiguresF02","2.","FiguresF022.","5b","LFOI - RFIO Change Eight","5b",null,"5b",null,"5b","LFOI - RFIO Change Eight","5b","LFOI - RFIO Change Eight"]
["F03","FiguresF03","1.","FiguresF031.","3","RBO - LBO Eight","3",null,"3",null,"3","RBO - LBO Eight","3","RBO - LBO Eight",4,{"$f":"O108*2","v":8},null,"3rd Bronze Bar"]
["F03","FiguresF03","2.","FiguresF032.","7","RFO - LFO Three","7",null,"7",null,"7","RFO - LFO Three","7","RFO - LFO Three"]
["F04","FiguresF04","1.","FiguresF041.","8a/b","FO - BI Three","8a/b",null,"8a/b",null,"8a","RFO - LBI Three","8b","LFO - RBI Three",4,{"$f":"O110*2","v":8},null,"Bronze Medal"]
["F04","FiguresF04","2.","FiguresF042.","9a/b","FI - BO Three","9a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"9a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"9b","LFI - RBO Three","9a","RFI - LBO Three"]
["F05","FiguresF05","1.","FiguresF051.","10","RFO - LFO Double Three","10",null,"10",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"10","RFO - LFO Double Three","10","RFO - LFO Double Three",4.5,{"$f":"O112*3","v":13.5},null,"1st Silver Bar"]
["F05","FiguresF05","2.","FiguresF052.","11","RFI - LFI Double Three","11",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"11",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"11","RFI - LFI Double Three","11","RFI - LFI Double Three"]
["F05",{"$f":"$A$102&A114","v":"FiguresF05"},{"$f":"IF(B114=B113,TEXT(VALUE(C113)+1,\"#\")&\".\",\"1.\")","v":"3."},{"$f":"B114&C114","v":"FiguresF053."},12,"RBO - LBO Double Three",12,null,12,null,12,"RBO - LBO Double Three",12,"RBO - LBO Double Three"]
["F06","FiguresF06",{"$f":"IF(B115=B113,TEXT(VALUE(C113)+1,\"#\")&\".\",\"1.\")","v":"1."},"FiguresF061.","13","RBI - LBI Double Three","13",null,"13",null,"13","RBI - LBI Double Three","13","RBI - LBI Double Three",4.5,{"$f":"O115*3","v":13.5},null,"2nd Silver Bar"]
["F06","FiguresF06","2.","FiguresF062.","19a/b","FI - BO Bracket","19a/b",null,"19a/b",null,"19a","RFI - LBO Bracket","19b","LFI - RBO Bracket"]
["F06","FiguresF06","3.","FiguresF063.","28a/b","FOI - FIO Change Dbl Three","28a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"28a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"28b","LFOI - RFIO Change Dbl Three","28a","RFOI - LFIO Change Dbl Three"]
["F07","FiguresF07","1.","FiguresF071.","22a/b","FO – BO Counter","22a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"22a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"22a","RFO – LBO Counter","22b","LFO – RBO Counter",4.5,{"$f":"O118*3","v":13.5},null,"3rd Silver Bar"]
["F07","FiguresF07","2.","FiguresF072.","18a/b","FO – BI Bracket","18a/b",null,"18a/b",null,"18b","LFO – RBI Bracket","18a","RFO – LBI Bracket"]
["F07","FiguresF07","3.","FiguresF073.","21a/b","FI - BI Rocker","21a/b",null,"21a/b",null,"21a","RFI - LBI Rocker","21b","LFI - RBI Rocker"]
["F08","FiguresF08","1.","FiguresF081.",4,"RBI – LBI Eight",4,{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},4,{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},4,"RBI – LBI Eight",4,"RBI – LBI Eight",4.5,{"$f":"O121*4","v":18},null,"Silver Medal"]
["F08","FiguresF08","2.","FiguresF082.","32a/b","FOI – BOI Change Bracket","32a/b",null,"32a/b",null,"32a","RFOI – LBOI Change Bracket","32b","LFOI – RBOI Change Bracket"]
["F08","FiguresF08","3.","FiguresF083.","23a/b","FI - BI Counter","23a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"23a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"23b","LFI - RBI Counter","23a","RFI - LBI Counter"]
["F08","FiguresF08","4.","FiguresF084.","29a/b","BOI – BIO Change Dbl Three","29a/b",null,"29a/b",null,"29a","RBOI – LBIO Change Dbl Three","29b","LBOI – RBIO Change Dbl Three"]
["F09","FiguresF09","1.",{"$f":"B125&C125","v":"FiguresF091."},"20a/b","FO – BO Rocker","20a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"20a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"20a","RFO – LBO Rocker","20b","LFO – RBO Rocker",5,{"$f":"O125*4","v":20},null,"1st Gold Bar"]
["F09","FiguresF09",{"$f":"IF(B126=B125,TEXT(VALUE(C125)+1,\"#\")&\".\",\"1.\")","v":"2."},"FiguresF092.","33a/b","FIO – BIO Change Bracket","33a/b",null,"33a/b",{"$f":"+$H$104","v":"Already assessed as Competent - Skater can choose not to re-do"},"33b","LFIO – RBIO Change Bracket","33a","RFIO – LBIO Change Bracket"]
["F09","FiguresF09","3.","FiguresF093.","36a/b","FO – FI Para Dbl Three","36a/b",null,"36a/b",null,"36a","RFO – LFI Para Dbl Three","36b","LFO – RFI Para Dbl Three"]
["F09","FiguresF09","4.","FiguresF094.","40a/b","FO – FI Para Bracket","40a/b",null,"40a/b",null,"40b","LFO – RFI Para Bracket","40a","RFO – LFI Para Bracket"]
["F10","FiguresF10","1.","FiguresF101.","37a/b","BO - BI Para Dbl Three","37a/b",null,"37a/b",null,"37a","RBO - LBI Para Dbl Three","37b","LBO - RBI Para Dbl Three",5,{"$f":"O129*4","v":20},null,"2nd Gold Bar"]
["F10","FiguresF10","2.","FiguresF102.","41a/b","BO - BI Para Bracket","41a/b",null,"41a/b",null,"41b","LBO - RBI Para Bracket","41a","RBO - LBI Para Bracket"]
["F10","FiguresF10","3.","FiguresF103.","44a/b","FI Rocker / Inside Dbl Three","44a/b",null,"44a/b",null,"44a","RFI Rocker / Inside Dbl Three","44b","LFI Rocker / Inside Dbl Three"]
["F10","FiguresF10","4.","FiguresF104.","42a/b","FO Counter / Bracket and Inside Counter","42a/b",null,"42a/b",null,"42b","LFO Counter / Bracket and Inside Counter","42a","RFO Counter / Bracket and Inside Counter"]
["F11","FiguresF11","1.","FiguresF111.","43a/b","FO Rocker / Outside Dbl Three","43a/b",null,"43a/b",null,"43a","RFO Rocker / Outside Dbl Three","43b","LFO Rocker / Outside Dbl Three",5,{"$f":"O133*5","v":25},null,"3rd Gold Bar"]
["F11","FiguresF11","2.","FiguresF112.","45a/b","BO Counter / Bracket and Inside Counter","45a/b",null,"45a/b",null,"45b","LBO Counter / Bracket and Inside Counter","45a","RBO Counter / Bracket and Inside Counter"]
["F11","FiguresF11","3.","FiguresF113.","46a/b","FO Dbl Three / Outside Rocker and Back Dbl Three Para","46a/b",null,"46a/b",null,"46a","RFO Dbl Three / Outside Rocker and Back Dbl Three Para","46b","LFO Dbl Three / Outside Rocker and Back Dbl Three Para"]
["F11","FiguresF11","4.","FiguresF114.","51a/b","FO Bracket / Inside Rocker and Back Bracket Para","51a/b",null,"51a/b",null,"51b","LFO Bracket / Inside Rocker and Back Bracket Para","51a","RFO Bracket / Inside Rocker and Back Bracket Para"]
["F11","FiguresF11","5.","FiguresF115.","50a/b","Forward Dbl Three / Outside Counter and Back Dbl Three Para","50a/b",null,"50a/b",null,"50a","R Fwd Dbl Three / Outside Counter and Back Dbl Three Para","50b","L Fwd Dbl Three / Outside Counter and Back Dbl Three Para"]
["F12","FiguresF12","1.","FiguresF121.","47a/b","FO Bracket / Inside Counter and Back Bracket Para","47a/b",null,"47a/b",null,"47a","RFO Bracket / Inside Counter and Back Bracket Para","47b","LFO Bracket / Inside Counter and Back Bracket Para",5,{"$f":"O138*5","v":25},null,"Gold Medal"]
["F12","FiguresF12","2.","FiguresF122.","49a/b","BO Bracket / Inside Counter and Forward Bracket Para","49a/b",null,"49a/b",null,"49b","LBO Bracket / Inside Counter and Forward Bracket Para","49a","RBO Bracket / Inside Counter and Forward Bracket Para"]
["F12","FiguresF12","3.","FiguresF123.","48a/b","Back Dbl Three / Outside Rocker and Forward Dbl Three Para","48a/b",null,"48a/b",null,"48a","R Back Dbl Three / Outside Rocker and Forward Dbl Three Para","48b","L Back Dbl Three / Outside Rocker and Forward Dbl Three Para"]
["F12","FiguresF12","4.","FiguresF124.","52a/b","BO Dbl Three / Outside Counter and Forward Dbl Three Para","52a/b",null,"52a/b",null,"52b","LBO Dbl Three / Outside Counter and Forward Dbl Three Para","52a","RBO Dbl Three / Outside Counter and Forward Dbl Three Para"]
["F12","FiguresF12","5.","FiguresF125.","53a/b","BO Bracket / Inside Rocker and Forward Bracket Para","53a/b",null,"53a/b",null,"53a","RBO Bracket / Inside Rocker and Forward Bracket Para","53b","LBO Bracket / Inside Rocker and Forward Bracket Para"]
[]
["Loops"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
["FL1",{"$f":"$A$144&A146","v":"LoopsFL1"},"1.",{"$f":"B146&C146","v":"LoopsFL11."},14,"RFO – LFO Loop",14,"RFO – LFO Loop",14,"RFO – LFO Loop",14,"RFO – LFO Loop",14,"RFO – LFO Loop",4,8,null,"Bronze Bar"]
["FL1",{"$f":"$A$144&A147","v":"LoopsFL1"},{"$f":"IF(B147=B146,TEXT(VALUE(C146)+1,\"#\")&\".\",\"1.\")","v":"2."},"LoopsFL12.",15,"RFI - LFI Loop",15,"RFI - LFI Loop",15,"RFI - LFI Loop",15,"RFI - LFI Loop",15,"RFI - LFI Loop"]
["FL2","LoopsFL2","1.","LoopsFL21.","30a","RFOI – LFIO Change Loop","30a","RFOI – LFIO Change Loop","30a","RFOI – LFIO Change Loop","30a","RFOI – LFIO Change Loop","30a","RFOI – LFIO Change Loop",4,8,null,"Bronze Medal"]
["FL2","LoopsFL2","2.","LoopsFL22.","30b","LFOI – RFIO Change Loop","30b","LFOI – RFIO Change Loop","30b","LFOI – RFIO Change Loop","30b","LFOI – RFIO Change Loop","30b","LFOI – RFIO Change Loop"]
["FL3","LoopsFL3","1.","LoopsFL31.",16,"RBO – LBO Loop",16,"RBO – LBO Loop",16,"RBO – LBO Loop",16,"RBO – LBO Loop",16,"RBO – LBO Loop",4.5,9,null,"Silver Bar"]
["FL3","LoopsFL3","2.","LoopsFL32.",17,"RBI - LBI Loop",17,"RBI - LBI Loop",17,"RBI - LBI Loop",17,"RBI - LBI Loop",17,"RBI - LBI Loop"]
["FL4","LoopsFL4","1.","LoopsFL41.","38a","RFOI – LFIO Para Loop","38a","RFOI – LFIO Para Loop","38a","RFOI – LFIO Para Loop","38a","RFOI – LFIO Para Loop","38a","RFOI – LFIO Para Loop",4.5,9,null,"Silver Medal"]
["FL4","LoopsFL4","2.","LoopsFL42.","38b","LFOI – RFIO Para Loop","38b","LFOI – RFIO Para Loop","38b","LFOI – RFIO Para Loop","38b","LFOI – RFIO Para Loop","38b","LFOI – RFIO Para Loop"]
["FL5","LoopsFL5","1.","LoopsFL51.","31a","RBOI – LBIO Change Loop","31a","RBOI – LBIO Change Loop","31a","RBOI – LBIO Change Loop","31a","RBOI – LBIO Change Loop","31a","RBOI – LBIO Change Loop",5,10,null,"Gold Bar"]
["FL5","LoopsFL5","2.","LoopsFL52.","31b","LBOI – RBIO Change Loop","31b","LBOI – RBIO Change Loop","31b","LBOI – RBIO Change Loop","31b","LBOI – RBIO Change Loop","31b","LBOI – RBIO Change Loop"]
["FL6","LoopsFL6","1.","LoopsFL61.","39a","RBOI - LBIO Para Loop","39a","RBOI - LBIO Para Loop","39a","RBOI - LBIO Para Loop","39a","RBOI - LBIO Para Loop","39a","RBOI - LBIO Para Loop",5,10,null,"Gold Medal"]
["FL6","LoopsFL6","2.","LoopsFL62.","39b","LBOI - RBIO Para Loop","39b","LBOI - RBIO Para Loop","39b","LBOI - RBIO Para Loop","39b","LBOI - RBIO Para Loop","39b","LBOI - RBIO Para Loop"]
[]
["Figures Validation Old to New Structure"]
["Old","New"]
[1,"F01"]
[2,"F02"]
[3,"F03"]
[4,"F04"]
[5,"F04"]
[6,"F05"]
[7,"F05"]
[8,"F06"]
[9,"F07"]
[10,"F07"]
[11,"F08"]
[12,"F09"]
[13,"F09"]
[14,"F10"]
[15,"N/A"]
[]
["Free Skating"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$177&A179","v":"Free Skating1"},"1.",{"$f":"B179&C179","v":"Free Skating11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,11,"Up to 2 minutes (+ 5 seconds)","Bronze Bar"]
[1,{"$f":"$A$177&A180","v":"Free Skating1"},{"$f":"IF(B180=B179,TEXT(VALUE(C179)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"Free Skating2","1.","Free Skating21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,12,"Up to 2 mins 30 secs (+ 5 seconds)","Bronze Bar"]
[2,"Free Skating2","2.","Free Skating22.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"Free Skating3","1.","Free Skating31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,13,"Up to 2 mins 30 secs (+ 5 seconds)","Bronze Medal"]
[3,"Free Skating3","2.","Free Skating32.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[4,"Free Skating4","1.","Free Skating41.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Bar"]
[4,"Free Skating4","2.","Free Skating42.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[5,"Free Skating5","1.","Free Skating51.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Bar"]
[5,"Free Skating5","2.","Free Skating52.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[6,"Free Skating6","1.","Free Skating61.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+ 10 seconds)","Silver Medal"]
[6,"Free Skating6",{"$f":"IF(B190=B189,TEXT(VALUE(C189)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B190&C190","v":"Free Skating62."},null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[7,"Free Skating7",{"$f":"IF(B191=B190,TEXT(VALUE(C190)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B191&C191","v":"Free Skating71."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"Up to 4 mins (+10 seconds)","Gold Medal"]
[7,"Free Skating7",{"$f":"IF(B192=B191,TEXT(VALUE(C191)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B192&C192","v":"Free Skating72."},null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[8,"Free Skating8",{"$f":"IF(B193=B192,TEXT(VALUE(C192)+1,\"#\")&\".\",\"1.\")","v":"1."},{"$f":"B193&C193","v":"Free Skating81."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"Up to 4 mins (+10 seconds)","Gold Challenge"]
[8,"Free Skating8",{"$f":"IF(B194=B193,TEXT(VALUE(C193)+1,\"#\")&\".\",\"1.\")","v":"2."},{"$f":"B194&C194","v":"Free Skating82."},null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["Free Skating Requirements"]
["Test #",null,"Item #","Full Item",null,{"$f":"+F$3","v":"Item Description - Normal"},null,{"$f":"+H$3","v":"Transition 1  D:R - 5"},null,{"$f":"+J$3","v":"Transition 2  D:R - 7"},null,{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},null,{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},null,null,null,"Award"]
[1,{"$f":"$A$196&A198","v":"Free Skating Requirements1"},"A.",{"$f":"B198&C198","v":"Free Skating Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 1",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 1",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 1",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 1",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.",null,"Forward spiral, min ½ length of the floor, 1 edge.",null,"Forward spiral, min ½ length of the floor, 1 edge.",null,"Forward spiral, min ½ length of the floor, 1 edge.",null,"Forward spiral, min ½ length of the floor, 1 edge."]
[1,"Free Skating Requirements1",{"$f":"IF(B200=B199,TEXT(VALUE(C199)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements12.",null,"Diagonal Primary Footwork, min ½ length of the floor",null,"Diagonal Primary Footwork, min ½ length of the floor",null,"Diagonal Primary Footwork, min ½ length of the floor",null,"Diagonal Primary Footwork, min ½ length of the floor",null,"Diagonal Primary Footwork, min ½ length of the floor"]
[1,"Free Skating Requirements1","3.","Free Skating Requirements13.",null,"IB Upright Spin",null,"IB Upright Spin",null,"IB Upright Spin",null,"IB Upright Spin",null,"IB Upright Spin"]
[1,"Free Skating Requirements1","4.","Free Skating Requirements14.",null,"IF Upright Spin",null,"IF Upright Spin",null,"IF Upright Spin",null,"IF Upright Spin",null,"IF Upright Spin"]
[1,"Free Skating Requirements1","5.","Free Skating Requirements15.",null,"Heel and Toe Spin",null,"Heel and Toe Spin",null,"Heel and Toe Spin",null,"Heel and Toe Spin",null,"Heel and Toe Spin"]
[1,"Free Skating Requirements1","6.","Free Skating Requirements16.",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump"]
[1,"Free Skating Requirements1","7.","Free Skating Requirements17.",null,"Toe Loop",null,"Toe Loop",null,"Toe Loop",null,"Toe Loop",null,"Toe Loop"]
[1,"Free Skating Requirements1","8.","Free Skating Requirements18.",null,"Bunny Hop",null,"Bunny Hop",null,"Bunny Hop",null,"Bunny Hop",null,"Bunny Hop"]
[1,"Free Skating Requirements1","9.","Free Skating Requirements19.",null,"Salchow",null,"Salchow",null,"Salchow",null,"Salchow",null,"Salchow"]
[1,"Free Skating Requirements1","10.","Free Skating Requirements110.",null,"Jump combo - choose 2 jumps from listed jumps.  Jump names must be entered.",null,"Jump combo - choose 2 jumps from listed jumps.  Jump names must be entered.",null,"Jump combo - choose 2 jumps from listed jumps.  Jump names must be entered.",null,"Jump combo - choose 2 jumps from listed jumps.  Jump names must be entered.",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 2",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 2",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 2",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",null,"Diagonal Secondary Footwork, min ¾ length of the floor",null,"Diagonal Secondary Footwork, min ¾ length of the floor",null,"Diagonal Secondary Footwork, min ¾ length of the floor",null,"Diagonal Secondary Footwork, min ¾ length of the floor"]
[2,"Free Skating Requirements2",{"$f":"IF(B213=B212,TEXT(VALUE(C212)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements22.",null,"OF Upright Spin",null,"OF Upright Spin",null,"OF Upright Spin",null,"OF Upright Spin",null,"OF Upright Spin"]
[2,"Free Skating Requirements2","3.","Free Skating Requirements23.",null,"OB Upright Spin",null,"OB Upright Spin",null,"OB Upright Spin",null,"OB Upright Spin",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.",null,"Choose 1 Spin:  Upright Change or Upright Combo spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Upright Change or Upright Combo spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Upright Change or Upright Combo spin.  Edges (but not foot) must be entered.",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",null,"Loop (OB) Jump",null,"Loop (OB) Jump",null,"Loop (OB) Jump",null,"Loop (OB) Jump"]
[2,"Free Skating Requirements2","6.","Free Skating Requirements26.",null,"Flip",null,"Flip",null,"Flip",null,"Flip",null,"Flip"]
[2,"Free Skating Requirements2","7.","Free Skating Requirements27.",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",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.",null,"  Waltz Jump, Toe Loop, Salchow, Loop, Flip.  Jump names must be entered.",null,"  Waltz Jump, Toe Loop, Salchow, Loop, Flip.  Jump names must be entered.",null,"  Waltz Jump, Toe Loop, Salchow, Loop, Flip.  Jump names must be entered.",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)",null,"Fwd serp spiral, 1 change of edge, 1 foot (½ length of floor)",null,"Fwd serp spiral, 1 change of edge, 1 foot (½ length of floor)",null,"Fwd serp spiral, 1 change of edge, 1 foot (½ length of floor)",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 3",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 3",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 3",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",null,"Diagonal Advanced Footwork, min ¾ length of the floor",null,"Diagonal Advanced Footwork, min ¾ length of the floor",null,"Diagonal Advanced Footwork, min ¾ length of the floor",null,"Diagonal Advanced Footwork, min ¾ length of the floor"]
[3,"Free Skating Requirements3",{"$f":"IF(B226=B225,TEXT(VALUE(C225)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements32.",null,"Upright change spin.  Edges (but not foot) must be entered.",null,"Upright change spin.  Edges (but not foot) must be entered.",null,"Upright change spin.  Edges (but not foot) must be entered.",null,"Upright change spin.  Edges (but not foot) must be entered.",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.",null,"Upright combo spin.  Edges (but not foot) must be entered.",null,"Upright combo spin.  Edges (but not foot) must be entered.",null,"Upright combo spin.  Edges (but not foot) must be entered.",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",null,"Choose 1 Spin - IB Sit  or   OF Sit  or  OB Camel",null,"Choose 1 Spin - IB Sit  or   OF Sit  or  OB Camel",null,"Choose 1 Spin - IB Sit  or   OF Sit  or  OB Camel",null,"Choose 1 Spin - IB Sit  or   OF Sit  or  OB Camel"]
[3,"Free Skating Requirements3","5.","Free Skating Requirements35.",null,"Flip",null,"Flip",null,"Flip",null,"Flip",null,"Flip"]
[3,{"$f":"$A$196&A230","v":"Free Skating Requirements3"},"6.",{"$f":"B230&C230","v":"Free Skating Requirements36."},null,"Thoren",null,"Thoren",null,"Thoren",null,"Thoren",null,"Thoren"]
[3,"Free Skating Requirements3","7.","Free Skating Requirements37.",null,"Lutz",null,"Lutz",null,"Lutz",null,"Lutz",null,"Lutz"]
[3,"Free Skating Requirements3","8.","Free Skating Requirements38.",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",null,"Jump combo - choose 3 jumps from:",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.",null,"  Toe Loop, Salchow, Loop (OB), Lutz.  Jump names must be entered.",null,"  Toe Loop, Salchow, Loop (OB), Lutz.  Jump names must be entered.",null,"  Toe Loop, Salchow, Loop (OB), Lutz.  Jump names must be entered.",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",null,"Backward spiral, ½ length of the floor",null,"Backward spiral, ½ length of the floor",null,"Backward spiral, ½ length of the floor",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 4",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 4",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 4",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 4"]
[4,"Free Skating Requirements4","1.","Free Skating Requirements41.",null,"Advanced Serpentine Footwork",null,"Advanced Serpentine Footwork",null,"Advanced Serpentine Footwork",null,"Advanced Serpentine Footwork",null,"Advanced Serpentine Footwork"]
[4,"Free Skating Requirements4",{"$f":"IF(B239=B238,TEXT(VALUE(C238)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements42.",null,"Choose 1 Sit Spin - IB Sit  or  OF Sit  or  OB Sit",null,"Choose 1 Sit Spin - IB Sit  or  OF Sit  or  OB Sit",null,"Choose 1 Sit Spin - IB Sit  or  OF Sit  or  OB Sit",null,"Choose 1 Sit Spin - IB Sit  or  OF Sit  or  OB Sit",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",null,"Choose 1 Camel - OB Camel  or  OF Camel",null,"Choose 1 Camel - OB Camel  or  OF Camel",null,"Choose 1 Camel - OB Camel  or  OF Camel",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",null,"Choose 1 Spin:  Sit-change-Sit  or  Sit combo  or",null,"Choose 1 Spin:  Sit-change-Sit  or  Sit combo  or",null,"Choose 1 Spin:  Sit-change-Sit  or  Sit combo  or",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.",null,"  Camel-Sit combo  or  Camel-change-Camel.  Edges (but not foot) must be entered.",null,"  Camel-Sit combo  or  Camel-change-Camel.  Edges (but not foot) must be entered.",null,"  Camel-Sit combo  or  Camel-change-Camel.  Edges (but not foot) must be entered.",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",null,"Axel",null,"Axel",null,"Axel",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.",null,"Choose 1 Jump - Double Salchow  or  Double Toe Loop.  Jump name must be entered.",null,"Choose 1 Jump - Double Salchow  or  Double Toe Loop.  Jump name must be entered.",null,"Choose 1 Jump - Double Salchow  or  Double Toe Loop.  Jump name must be entered.",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.",null,"Jump combo of 3 jumps - Axel + 2 Jumps of at least 1 revolution  Jump names must be entered.",null,"Jump combo of 3 jumps - Axel + 2 Jumps of at least 1 revolution  Jump names must be entered.",null,"Jump combo of 3 jumps - Axel + 2 Jumps of at least 1 revolution  Jump names must be entered.",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",null,"Backward serp spiral, 1 change of edge on 1 foot",null,"Backward serp spiral, 1 change of edge on 1 foot",null,"Backward serp spiral, 1 change of edge on 1 foot",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 5",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 5",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 5",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 5"]
[5,"Free Skating Requirements5","1.","Free Skating Requirements51.",null,"Circular Advanced Footwork",null,"Circular Advanced Footwork",null,"Circular Advanced Footwork",null,"Circular Advanced Footwork",null,"Circular Advanced Footwork"]
[5,"Free Skating Requirements5",{"$f":"IF(B252=B251,TEXT(VALUE(C251)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements52.",null,"Camel combination",null,"Camel combination",null,"Camel combination",null,"Camel combination",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",null,"Choose 1 Spin:  Sit combo  or  Sit-jump-Sit  or  Sit-jump-change-Sit  or",null,"Choose 1 Spin:  Sit combo  or  Sit-jump-Sit  or  Sit-jump-change-Sit  or",null,"Choose 1 Spin:  Sit combo  or  Sit-jump-Sit  or  Sit-jump-change-Sit  or",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",null,"                          OF Camel-OB Sit  or  OB Camel-OB Sit  or",null,"                          OF Camel-OB Sit  or  OB Camel-OB Sit  or",null,"                          OF Camel-OB Sit  or  OB Camel-OB Sit  or",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.",null,"                          OF Camel-IB Sit  or  Sit-change-Sit.  Edges (but not foot) must be entered.",null,"                          OF Camel-IB Sit  or  Sit-change-Sit.  Edges (but not foot) must be entered.",null,"                          OF Camel-IB Sit  or  Sit-change-Sit.  Edges (but not foot) must be entered.",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",null,"Double Toe Loop",null,"Double Toe Loop",null,"Double Toe Loop",null,"Double Toe Loop"]
[5,"Free Skating Requirements5","7.","Free Skating Requirements57.",null,"Double Salchow",null,"Double Salchow",null,"Double Salchow",null,"Double Salchow",null,"Double Salchow"]
[5,"Free Skating Requirements5","8.","Free Skating Requirements58.",null,"Double Flip",null,"Double Flip",null,"Double Flip",null,"Double Flip",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.",null,"Combo jump - 3-5 jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",null,"Combo jump - 3-5 jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",null,"Combo jump - 3-5 jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",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",null,"Spiral, 1 change of foot, ¾ length of the floor",null,"Spiral, 1 change of foot, ¾ length of the floor",null,"Spiral, 1 change of foot, ¾ length of the floor",null,"Spiral, 1 change of foot, ¾ length of the floor"]
[5,"Free Skating Requirements5","11.","Free Skating Requirements511."]
[5,{"$f":"$A$196&A262","v":"Free Skating Requirements5"},"12.",{"$f":"B262&C262","v":"Free Skating Requirements512."}]
[6,"Free Skating Requirements6","A.","Free Skating Requirements6A.",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 6"]
[6,"Free Skating Requirements6","1.","Free Skating Requirements61.",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork"]
[6,"Free Skating Requirements6",{"$f":"IF(B265=B264,TEXT(VALUE(C264)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements62.",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin"]
[6,"Free Skating Requirements6","3.","Free Skating Requirements63.",null,"Any Camel-change-Camel",null,"Any Camel-change-Camel",null,"Any Camel-change-Camel",null,"Any Camel-change-Camel",null,"Any Camel-change-Camel"]
[6,"Free Skating Requirements6","4.","Free Skating Requirements64.",null,"Any Camel combo.  Edges (but not foot) must be entered.",null,"Any Camel combo.  Edges (but not foot) must be entered.",null,"Any Camel combo.  Edges (but not foot) must be entered.",null,"Any Camel combo.  Edges (but not foot) must be entered.",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)*",null,"Choose 1 Spin: Sit-jump-Sit (OF Camel optional)* or Sit-jump-change-Sit  (OF Camel optional)*",null,"Choose 1 Spin: Sit-jump-Sit (OF Camel optional)* or Sit-jump-change-Sit  (OF Camel optional)*",null,"Choose 1 Spin: Sit-jump-Sit (OF Camel optional)* or Sit-jump-change-Sit  (OF Camel optional)*",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",null,"             or  Camel-Sit-change-Sit  or  OB Camel-OB Sit",null,"             or  Camel-Sit-change-Sit  or  OB Camel-OB Sit",null,"             or  Camel-Sit-change-Sit  or  OB Camel-OB Sit",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.",null,"             or  IB Camel-IB Sit (OF edge optional).  Edges (but not foot) must be entered.",null,"             or  IB Camel-IB Sit (OF edge optional).  Edges (but not foot) must be entered.",null,"             or  IB Camel-IB Sit (OF edge optional).  Edges (but not foot) must be entered.",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",null,"             *  It's usual to use a Camel to enter these Spins to develop enough speed",null,"             *  It's usual to use a Camel to enter these Spins to develop enough speed",null,"             *  It's usual to use a Camel to enter these Spins to develop enough speed",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",null,"Double Flip",null,"Double Flip",null,"Double Flip",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.",null,"Choose 1 Jump:  Double Lutz  or  Double Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Double Lutz  or  Double Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Double Lutz  or  Double Loop.  Jump name must be entered.",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.",null,"Combo Jump - 3-5 Jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",null,"Combo Jump - 3-5 Jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",null,"Combo Jump - 3-5 Jumps, must include at least 1 dbl rev Jump.  Jump names must be entered.",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 7",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 7",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 7",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 7"]
[7,"Free Skating Requirements7","1.","Free Skating Requirements71.",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork",null,"2 sequences of Advanced Footwork"]
[7,"Free Skating Requirements7",{"$f":"IF(B278=B277,TEXT(VALUE(C277)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements72.",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin",null,"1 Class A Spin"]
[7,"Free Skating Requirements7","3.","Free Skating Requirements73.",null,"Camel combo with a Sit Spin.  ",null,"Camel combo with a Sit Spin.  ",null,"Camel combo with a Sit Spin.  ",null,"Camel combo with a Sit Spin.  ",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.",null,"1 combo spin including 1 A class spin.  Edges (but not foot) must be entered.",null,"1 combo spin including 1 A class spin.  Edges (but not foot) must be entered.",null,"1 combo spin including 1 A class spin.  Edges (but not foot) must be entered.",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.",null,"Double Loop combo.  Jump names must be entered.",null,"Double Loop combo.  Jump names must be entered.",null,"Double Loop combo.  Jump names must be entered.",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.",null,"A Jump combo containing any 2 double rev Jumps.  Jump names must be entered.",null,"A Jump combo containing any 2 double rev Jumps.  Jump names must be entered.",null,"A Jump combo containing any 2 double rev Jumps.  Jump names must be entered.",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.",null,"Combo Jump - 3-5 Jumps includong 2 double Jumps.  Jump names must be entered.",null,"Combo Jump - 3-5 Jumps includong 2 double Jumps.  Jump names must be entered.",null,"Combo Jump - 3-5 Jumps includong 2 double Jumps.  Jump names must be entered.",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",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 8",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 8",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 8",null,"REQUIREMENTS LIST - NO SET ORDER - F/S No 8"]
[8,"Free Skating Requirements8","1.","Free Skating Requirements81.",null,"2 A Class Spins",null,"2 A Class Spins",null,"2 A Class Spins",null,"2 A Class Spins",null,"2 A Class Spins"]
[8,"Free Skating Requirements8",{"$f":"IF(B291=B290,TEXT(VALUE(C290)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Requirements82.",null,"Layover Camel (any edge)",null,"Layover Camel (any edge)",null,"Layover Camel (any edge)",null,"Layover Camel (any edge)",null,"Layover Camel (any edge)"]
[8,"Free Skating Requirements8","3.","Free Skating Requirements83.",null,"Inverted Camel (any edge)",null,"Inverted Camel (any edge)",null,"Inverted Camel (any edge)",null,"Inverted Camel (any edge)",null,"Inverted Camel (any edge)"]
[8,"Free Skating Requirements8","4.","Free Skating Requirements84.",null,"Broken Ankle (Forward or Backward)",null,"Broken Ankle (Forward or Backward)",null,"Broken Ankle (Forward or Backward)",null,"Broken Ankle (Forward or Backward)",null,"Broken Ankle (Forward or Backward)"]
[8,{"$f":"$A$196&A294","v":"Free Skating Requirements8"},"5.",{"$f":"B294&C294","v":"Free Skating Requirements85."},null,"Heel Camel (Forward or Backward)",null,"Heel Camel (Forward or Backward)",null,"Heel Camel (Forward or Backward)",null,"Heel Camel (Forward or Backward)",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.",null,"Combo spin including an A Class Spin and a Sit Spin.  Edges (but not foot) must be entered.",null,"Combo spin including an A Class Spin and a Sit Spin.  Edges (but not foot) must be entered.",null,"Combo spin including an A Class Spin and a Sit Spin.  Edges (but not foot) must be entered.",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",null,"Double Axel",null,"Double Axel",null,"Double Axel",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.",null,"Jump combo - Double Flip plus any other double rev Jump.  Jump names must be entered.",null,"Jump combo - Double Flip plus any other double rev Jump.  Jump names must be entered.",null,"Jump combo - Double Flip plus any other double rev Jump.  Jump names must be entered.",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.",null,"Jump combo - Dbl Lutz and Dbl Loop + any other dbl rev Jump.  Jump names must be entered.",null,"Jump combo - Dbl Lutz and Dbl Loop + any other dbl rev Jump.  Jump names must be entered.",null,"Jump combo - Dbl Lutz and Dbl Loop + any other dbl rev Jump.  Jump names must be entered.",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.",null,"A choice of any Triple Jump.  Jump name must be entered.",null,"A choice of any Triple Jump.  Jump name must be entered.",null,"A choice of any Triple Jump.  Jump name must be entered.",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)",null,"(Thoren or Loop may be used as  extra jump to connect the jump seq)",null,"(Thoren or Loop may be used as  extra jump to connect the jump seq)",null,"(Thoren or Loop may be used as  extra jump to connect the jump seq)",null,"(Thoren or Loop may be used as  extra jump to connect the jump seq)"]
[]
["Couples Free Dance"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$303&A305","v":"Couples Free Dance1"},"1.",{"$f":"B305&C305","v":"Couples Free Dance11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,13,"Up to 3 mins 40 secs","Bronze Medal"]
[1,"Couples Free Dance1",{"$f":"IF(B306=B305,TEXT(VALUE(C305)+1,\"#\")&\".\",\"1.\")","v":"2."},"Couples Free Dance12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"Couples Free Dance2",{"$f":"IF(B307=B306,TEXT(VALUE(C306)+1,\"#\")&\".\",\"1.\")","v":"1."},"Couples Free Dance21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"Up to 3 mins 40 secs","Silver Medal"]
[2,"Couples Free Dance2",{"$f":"IF(B308=B307,TEXT(VALUE(C307)+1,\"#\")&\".\",\"1.\")","v":"2."},"Couples Free Dance22.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"Couples Free Dance3",{"$f":"IF(B309=B308,TEXT(VALUE(C308)+1,\"#\")&\".\",\"1.\")","v":"1."},"Couples Free Dance31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"Up to 3 mins 40 secs","Gold Medal"]
[3,"Couples Free Dance3",{"$f":"IF(B310=B309,TEXT(VALUE(C309)+1,\"#\")&\".\",\"1.\")","v":"2."},"Couples Free Dance32.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["Couples Free Dance Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$312&A314","v":"Couples Free Dance Requirements1"},"A.",{"$f":"B314&C314","v":"Couples Free Dance Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 1"]
[1,{"$f":"$A$312&A315","v":"Couples Free Dance Requirements1"},"1.","Couples Free Dance Requirements11.",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[1,"Couples Free Dance Requirements1",{"$f":"IF(B316=B315,TEXT(VALUE(C315)+1,\"#\")&\".\",\"1.\")","v":"2."},"Couples Free Dance Requirements12.",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence"]
[1,{"$f":"$A$312&A317","v":"Couples Free Dance Requirements1"},"3.",{"$f":"B317&C317","v":"Couples Free Dance Requirements13."}]
[1,{"$f":"$A$312&A318","v":"Couples Free Dance Requirements1"},"4.",{"$f":"B318&C318","v":"Couples Free Dance Requirements14."},null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[1,"Couples Free Dance Requirements1","5.","Couples Free Dance Requirements15.",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[1,{"$f":"$A$312&A320","v":"Couples Free Dance Requirements1"},"6.",{"$f":"B320&C320","v":"Couples Free Dance Requirements16."}]
[1,{"$f":"$A$312&A321","v":"Couples Free Dance Requirements1"},"7.",{"$f":"B321&C321","v":"Couples Free Dance Requirements17."},null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift"]
[1,"Couples Free Dance Requirements1","8.","Couples Free Dance Requirements18."]
[1,"Couples Free Dance Requirements1","9.","Couples Free Dance Requirements19."]
[1,"Couples Free Dance Requirements1","10.","Couples Free Dance Requirements110."]
[1,"Couples Free Dance Requirements1","11.","Couples Free Dance Requirements111."]
[1,{"$f":"$A$312&A326","v":"Couples Free Dance Requirements1"},"12.",{"$f":"B326&C326","v":"Couples Free Dance Requirements112."}]
[2,"Couples Free Dance Requirements2","A.","Couples Free Dance Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 2"]
[2,"Couples Free Dance Requirements2","1.","Couples Free Dance Requirements21.",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[2,"Couples Free Dance Requirements2",{"$f":"IF(B329=B328,TEXT(VALUE(C328)+1,\"#\")&\".\",\"1.\")","v":"2."},"Couples Free Dance Requirements22.",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence"]
[2,{"$f":"$A$312&A330","v":"Couples Free Dance Requirements2"},{"$f":"IF(B330=B329,TEXT(VALUE(C329)+1,\"#\")&\".\",\"1.\")","v":"3."},{"$f":"B330&C330","v":"Couples Free Dance Requirements23."}]
[2,{"$f":"$A$312&A331","v":"Couples Free Dance Requirements2"},{"$f":"IF(B331=B330,TEXT(VALUE(C330)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B331&C331","v":"Couples Free Dance Requirements24."},null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[2,"Couples Free Dance Requirements2","5.","Couples Free Dance Requirements25.",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[2,"Couples Free Dance Requirements2","6.","Couples Free Dance Requirements26."]
[2,"Couples Free Dance Requirements2","7.","Couples Free Dance Requirements27.",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift"]
[2,{"$f":"$A$312&A335","v":"Couples Free Dance Requirements2"},{"$f":"IF(B335=B334,TEXT(VALUE(C334)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B335&C335","v":"Couples Free Dance Requirements28."}]
[2,"Couples Free Dance Requirements2","9.","Couples Free Dance Requirements29.",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift"]
[2,"Couples Free Dance Requirements2","10.","Couples Free Dance Requirements210."]
[2,"Couples Free Dance Requirements2","11.","Couples Free Dance Requirements211."]
[2,{"$f":"$A$312&A339","v":"Couples Free Dance Requirements2"},{"$f":"IF(B339=B338,TEXT(VALUE(C338)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B339&C339","v":"Couples Free Dance Requirements212."}]
[3,"Couples Free Dance Requirements3","A.","Couples Free Dance Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Couples F/D No 3"]
[3,"Couples Free Dance Requirements3","1.","Couples Free Dance Requirements31.",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence",null,"EITHER:  1 Dance HOLD Circular step sequence"]
[3,"Couples Free Dance Requirements3","2.","Couples Free Dance Requirements32.",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence",null,"OR:          1 Dance HOLD Linear step sequence"]
[3,"Couples Free Dance Requirements3","3.","Couples Free Dance Requirements33."]
[3,"Couples Free Dance Requirements3","4.","Couples Free Dance Requirements34.",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence",null,"EITHER:  1 Dance NO HOLD Circular step sequence"]
[3,"Couples Free Dance Requirements3","5.","Couples Free Dance Requirements35.",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence",null,"OR:          1 Dance NO HOLD Linear step sequence"]
[3,{"$f":"$A$312&A346","v":"Couples Free Dance Requirements3"},{"$f":"IF(B346=B345,TEXT(VALUE(C345)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B346&C346","v":"Couples Free Dance Requirements36."}]
[3,{"$f":"$A$312&A347","v":"Couples Free Dance Requirements3"},{"$f":"IF(B347=B346,TEXT(VALUE(C346)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B347&C347","v":"Couples Free Dance Requirements37."},null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift",null,"1 Stationary Lift"]
[3,{"$f":"$A$312&A348","v":"Couples Free Dance Requirements3"},{"$f":"IF(B348=B347,TEXT(VALUE(C347)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B348&C348","v":"Couples Free Dance Requirements38."},null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift",null,"1 Rotational or Combined Lift"]
[3,{"$f":"$A$312&A349","v":"Couples Free Dance Requirements3"},{"$f":"IF(B349=B348,TEXT(VALUE(C348)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B349&C349","v":"Couples Free Dance Requirements39."},null,"1 Other Lift of any choice",null,"1 Other Lift of any choice",null,"1 Other Lift of any choice",null,"1 Other Lift of any choice",null,"1 Other Lift of any choice"]
[3,{"$f":"$A$312&A350","v":"Couples Free Dance Requirements3"},{"$f":"IF(B350=B349,TEXT(VALUE(C349)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B350&C350","v":"Couples Free Dance Requirements310."}]
[3,{"$f":"$A$312&A351","v":"Couples Free Dance Requirements3"},{"$f":"IF(B351=B350,TEXT(VALUE(C350)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B351&C351","v":"Couples Free Dance Requirements311."}]
[3,{"$f":"$A$312&A352","v":"Couples Free Dance Requirements3"},{"$f":"IF(B352=B351,TEXT(VALUE(C351)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B352&C352","v":"Couples Free Dance Requirements312."}]
[]
["Solo Free Dance"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$354&A356","v":"Solo Free Dance1"},"1.",{"$f":"B356&C356","v":"Solo Free Dance11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,13,"2 mins to 2 mins 30 secs","Bronze Medal"]
[1,"Solo Free Dance1",{"$f":"IF(B357=B356,TEXT(VALUE(C356)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Free Dance12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"Solo Free Dance2",{"$f":"IF(B358=B357,TEXT(VALUE(C357)+1,\"#\")&\".\",\"1.\")","v":"1."},"Solo Free Dance21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"2 mins 30 secs","Silver Medal"]
[2,"Solo Free Dance2",{"$f":"IF(B359=B358,TEXT(VALUE(C358)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Free Dance22.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"Solo Free Dance3",{"$f":"IF(B360=B359,TEXT(VALUE(C359)+1,\"#\")&\".\",\"1.\")","v":"1."},"Solo Free Dance31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"2 mins 30 secs","Gold Medal"]
[3,"Solo Free Dance3",{"$f":"IF(B361=B360,TEXT(VALUE(C360)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Free Dance32.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["Solo Free Dance Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$363&A365","v":"Solo Free Dance Requirements1"},"A.",{"$f":"B365&C365","v":"Solo Free Dance Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 1"]
[1,"Solo Free Dance Requirements1","1.","Solo Free Dance Requirements11.",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND",null,"EITHER:  1 straight step sequence, either long axis or diagonal, from stationary position AND"]
[1,"Solo Free Dance Requirements1",{"$f":"IF(B367=B366,TEXT(VALUE(C366)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Free Dance Requirements12.",null,"                 1 circular step sequence (circular or serpentine)",null,"                 1 circular step sequence (circular or serpentine)",null,"                 1 circular step sequence (circular or serpentine)",null,"                 1 circular step sequence (circular or serpentine)",null,"                 1 circular step sequence (circular or serpentine)"]
[1,"Solo Free Dance Requirements1","3.",{"$f":"B368&C368","v":"Solo Free Dance Requirements13."}]
[1,"Solo Free Dance Requirements1","4.","Solo Free Dance Requirements14.",null,"OR:          1 straight step sequence long axis   AND",null,"OR:          1 straight step sequence long axis   AND",null,"OR:          1 straight step sequence long axis   AND",null,"OR:          1 straight step sequence long axis   AND",null,"OR:          1 straight step sequence long axis   AND"]
[1,"Solo Free Dance Requirements1","5.","Solo Free Dance Requirements15.",null,"                1 straight step sequence diagonal",null,"                1 straight step sequence diagonal",null,"                1 straight step sequence diagonal",null,"                1 straight step sequence diagonal",null,"                1 straight step sequence diagonal"]
[1,"Solo Free Dance Requirements1","6.","Solo Free Dance Requirements16.",null,"                (One of the step seqs must start from a stationary position)",null,"                (One of the step seqs must start from a stationary position)",null,"                (One of the step seqs must start from a stationary position)",null,"                (One of the step seqs must start from a stationary position)",null,"                (One of the step seqs must start from a stationary position)"]
[1,"Solo Free Dance Requirements1","7.","Solo Free Dance Requirements17."]
[1,"Solo Free Dance Requirements1","8.","Solo Free Dance Requirements18.",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution"]
[1,"Solo Free Dance Requirements1","9.",{"$f":"B374&C374","v":"Solo Free Dance Requirements19."}]
[1,"Solo Free Dance Requirements1","10.","Solo Free Dance Requirements110.",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions"]
[1,"Solo Free Dance Requirements1","11.",{"$f":"B376&C376","v":"Solo Free Dance Requirements111."}]
[1,"Solo Free Dance Requirements1",{"$f":"IF(B377=B376,TEXT(VALUE(C376)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B377&C377","v":"Solo Free Dance Requirements112."}]
[2,"Solo Free Dance Requirements2","A.","Solo Free Dance Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 2"]
[2,"Solo Free Dance Requirements2","1.","Solo Free Dance Requirements21.",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position"]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B380=B379,TEXT(VALUE(C379)+1,\"#\")&\".\",\"1.\")","v":"2."},"Solo Free Dance Requirements22."]
[2,"Solo Free Dance Requirements2","3.","Solo Free Dance Requirements23.",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)"]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B382=B381,TEXT(VALUE(C381)+1,\"#\")&\".\",\"1.\")","v":"4."},"Solo Free Dance Requirements24."]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B383=B382,TEXT(VALUE(C382)+1,\"#\")&\".\",\"1.\")","v":"5."},{"$f":"B383&C383","v":"Solo Free Dance Requirements25."},null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution"]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B384=B383,TEXT(VALUE(C383)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B384&C384","v":"Solo Free Dance Requirements26."}]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B385=B384,TEXT(VALUE(C384)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B385&C385","v":"Solo Free Dance Requirements27."},null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions"]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B386=B385,TEXT(VALUE(C385)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B386&C386","v":"Solo Free Dance Requirements28."}]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B387=B386,TEXT(VALUE(C386)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B387&C387","v":"Solo Free Dance Requirements29."}]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B388=B387,TEXT(VALUE(C387)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B388&C388","v":"Solo Free Dance Requirements210."}]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B389=B388,TEXT(VALUE(C388)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B389&C389","v":"Solo Free Dance Requirements211."}]
[2,"Solo Free Dance Requirements2",{"$f":"IF(B390=B389,TEXT(VALUE(C389)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B390&C390","v":"Solo Free Dance Requirements212."}]
[3,"Solo Free Dance Requirements3","A.","Solo Free Dance Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Solo F/D No 3"]
[3,"Solo Free Dance Requirements3","1.","Solo Free Dance Requirements31.",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position",null,"1 straight step sequence, either long axis or diagonal, from stationary position"]
[3,"Solo Free Dance Requirements3","2.","Solo Free Dance Requirements32."]
[3,"Solo Free Dance Requirements3","3.","Solo Free Dance Requirements33.",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)",null,"1 circular step sequence (circular or serpentine)"]
[3,"Solo Free Dance Requirements3","4.","Solo Free Dance Requirements34."]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B396=B395,TEXT(VALUE(C395)+1,\"#\")&\".\",\"1.\")","v":"5."},{"$f":"B396&C396","v":"Solo Free Dance Requirements35."},null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution",null,"Min 1, Max 3 Jumps of 1 revolution"]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B397=B396,TEXT(VALUE(C396)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B397&C397","v":"Solo Free Dance Requirements36."}]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B398=B397,TEXT(VALUE(C397)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B398&C398","v":"Solo Free Dance Requirements37."},null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions",null,"Min 1, Max 2 Spins of 3 revolutions"]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B399=B398,TEXT(VALUE(C398)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B399&C399","v":"Solo Free Dance Requirements38."}]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B400=B399,TEXT(VALUE(C399)+1,\"#\")&\".\",\"1.\")","v":"9."},{"$f":"B400&C400","v":"Solo Free Dance Requirements39."}]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B401=B400,TEXT(VALUE(C400)+1,\"#\")&\".\",\"1.\")","v":"10."},{"$f":"B401&C401","v":"Solo Free Dance Requirements310."}]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B402=B401,TEXT(VALUE(C401)+1,\"#\")&\".\",\"1.\")","v":"11."},{"$f":"B402&C402","v":"Solo Free Dance Requirements311."}]
[3,"Solo Free Dance Requirements3",{"$f":"IF(B403=B402,TEXT(VALUE(C402)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B403&C403","v":"Solo Free Dance Requirements312."}]
[]
["Free Skating Pairs"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$405&A407","v":"Free Skating Pairs1"},"1.",{"$f":"B407&C407","v":"Free Skating Pairs11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,13,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[1,"Free Skating Pairs1",{"$f":"IF(B408=B407,TEXT(VALUE(C407)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"Free Skating Pairs2",{"$f":"IF(B409=B408,TEXT(VALUE(C408)+1,\"#\")&\".\",\"1.\")","v":"1."},"Free Skating Pairs21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"Up to 3 mins 30 secs (+/- 10 seconds)","Silver Medal"]
[2,"Free Skating Pairs2",{"$f":"IF(B410=B409,TEXT(VALUE(C409)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs22.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"Free Skating Pairs3",{"$f":"IF(B411=B410,TEXT(VALUE(C410)+1,\"#\")&\".\",\"1.\")","v":"1."},"Free Skating Pairs31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"Up to 4 mins 30 secs (+/- 10 seconds)","Gold Medal"]
[3,"Free Skating Pairs3",{"$f":"IF(B412=B411,TEXT(VALUE(C411)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs32.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["Free Skating Pairs Requirements"]
["Test #",null,"Item #","Full Item",null,"Item Description",null,"Item Description",null,"Item Description",null,"Item Description",null,"Item Description",null,null,null,"Award"]
[1,{"$f":"$A$414&A416","v":"Free Skating Pairs Requirements1"},"A.",{"$f":"B416&C416","v":"Free Skating Pairs Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",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",null,"3 Pairs Lifts from selection list",null,"3 Pairs Lifts from selection list",null,"3 Pairs Lifts from selection list",null,"3 Pairs Lifts from selection list"]
[1,"Free Skating Pairs Requirements1",{"$f":"IF(B418=B417,TEXT(VALUE(C417)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements12.",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins"]
[1,"Free Skating Pairs Requirements1","3.","Free Skating Pairs Requirements13.",null,"1 Singles Shadow Jump of 1 revolution",null,"1 Singles Shadow Jump of 1 revolution",null,"1 Singles Shadow Jump of 1 revolution",null,"1 Singles Shadow Jump of 1 revolution",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",null,"1 Singles Shadow Spin - no combination",null,"1 Singles Shadow Spin - no combination",null,"1 Singles Shadow Spin - no combination",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",null,"Primary Straighaway Footwork, min ¾ of length of the floor",null,"Primary Straighaway Footwork, min ¾ of length of the floor",null,"Primary Straighaway Footwork, min ¾ of length of the floor",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.",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.",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.",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.",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",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 2",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",null,"2 Pairs Lifts from selection list",null,"2 Pairs Lifts from selection list",null,"2 Pairs Lifts from selection list",null,"2 Pairs Lifts from selection list"]
[2,"Free Skating Pairs Requirements2",{"$f":"IF(B431=B430,TEXT(VALUE(C430)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements22.",null,"1 Throw or Twist Lift",null,"1 Throw or Twist Lift",null,"1 Throw or Twist Lift",null,"1 Throw or Twist Lift",null,"1 Throw or Twist Lift"]
[2,"Free Skating Pairs Requirements2","3.","Free Skating Pairs Requirements23.",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins"]
[2,"Free Skating Pairs Requirements2","4.","Free Skating Pairs Requirements24.",null,"1 Singles Shadow Jump",null,"1 Singles Shadow Jump",null,"1 Singles Shadow Jump",null,"1 Singles Shadow Jump",null,"1 Singles Shadow Jump"]
[2,"Free Skating Pairs Requirements2","5.","Free Skating Pairs Requirements25.",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",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",null,"Secondary Footwork, circular pattern, min ¾ of the full width of the floor",null,"Secondary Footwork, circular pattern, min ¾ of the full width of the floor",null,"Secondary Footwork, circular pattern, min ¾ of the full width of the floor",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.",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.",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.",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.",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",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 3",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)",null,"3 Pairs Lifts (one of which must be a combination Lift)",null,"3 Pairs Lifts (one of which must be a combination Lift)",null,"3 Pairs Lifts (one of which must be a combination Lift)",null,"3 Pairs Lifts (one of which must be a combination Lift)"]
[3,"Free Skating Pairs Requirements3",{"$f":"IF(B444=B443,TEXT(VALUE(C443)+1,\"#\")&\".\",\"1.\")","v":"2."},"Free Skating Pairs Requirements32.",null,"1 Throw Lift",null,"1 Throw Lift",null,"1 Throw Lift",null,"1 Throw Lift",null,"1 Throw Lift"]
[3,"Free Skating Pairs Requirements3","3.","Free Skating Pairs Requirements33.",null,"1 Twist Lift",null,"1 Twist Lift",null,"1 Twist Lift",null,"1 Twist Lift",null,"1 Twist Lift"]
[3,"Free Skating Pairs Requirements3","4.","Free Skating Pairs Requirements34.",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins",null,"2 Pairs Contact Spins"]
[3,"Free Skating Pairs Requirements3","5.","Free Skating Pairs Requirements35.",null,"Death Spiral",null,"Death Spiral",null,"Death Spiral",null,"Death Spiral",null,"Death Spiral"]
[3,"Free Skating Pairs Requirements3","6.","Free Skating Pairs Requirements36.",null,"1 Singles Shadow Jump (must be 2 revolutions)",null,"1 Singles Shadow Jump (must be 2 revolutions)",null,"1 Singles Shadow Jump (must be 2 revolutions)",null,"1 Singles Shadow Jump (must be 2 revolutions)",null,"1 Singles Shadow Jump (must be 2 revolutions)"]
[3,"Free Skating Pairs Requirements3","7.","Free Skating Pairs Requirements37.",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",null,"1 Singles Shadow Spin",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)",null,"Advanced Serp Footwork (with at least 2 bold curves, min ½ width of the floor)",null,"Advanced Serp Footwork (with at least 2 bold curves, min ½ width of the floor)",null,"Advanced Serp Footwork (with at least 2 bold curves, min ½ width of the floor)",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",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",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",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",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 #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$456&A458","v":"In-Line Free Skating1"},"1.",{"$f":"B458&C458","v":"In-Line Free Skating11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,11,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Bar"]
[1,{"$f":"$A$456&A459","v":"In-Line Free Skating1"},{"$f":"IF(B459=B458,TEXT(VALUE(C458)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"In-Line Free Skating2","1.","In-Line Free Skating21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",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",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"In-Line Free Skating3","1.","In-Line Free Skating31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",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",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[4,"In-Line Free Skating4","1.","In-Line Free Skating41.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",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",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[5,"In-Line Free Skating5","1.","In-Line Free Skating51.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",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",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[6,"In-Line Free Skating6","1.","In-Line Free Skating61.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",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",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["In-Line Free Skating Requirements"]
["Test #",null,"Item #","Full Item",null,"Item Description",null,"Item Description",null,"Item Description",null,"Item Description",null,"Item Description",null,null,null,"Award"]
[1,{"$f":"$A$471&A473","v":"In-Line Free Skating Requirements1"},"A.",{"$f":"B473&C473","v":"In-Line Free Skating Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,null,null,"Bronze Bar"]
[1,{"$f":"$A$471&A474","v":"In-Line Free Skating Requirements1"},"1.","In-Line Free Skating Requirements11.",null,"Straightaway Primary Forward Footwork, min ½ length of floor",null,"Straightaway Primary Forward Footwork, min ½ length of floor",null,"Straightaway Primary Forward Footwork, min ½ length of floor",null,"Straightaway Primary Forward Footwork, min ½ length of floor",null,"Straightaway Primary Forward Footwork, min ½ length of floor"]
[1,"In-Line Free Skating Requirements1",{"$f":"IF(B475=B474,TEXT(VALUE(C474)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements12.",null,"Diagonal Primary Forward Footwork, min ½ length of floor",null,"Diagonal Primary Forward Footwork, min ½ length of floor",null,"Diagonal Primary Forward Footwork, min ½ length of floor",null,"Diagonal Primary Forward Footwork, min ½ length of floor",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)",null,"IB Upright Spin (min 2 revs with wheels, not stopper)",null,"IB Upright Spin (min 2 revs with wheels, not stopper)",null,"IB Upright Spin (min 2 revs with wheels, not stopper)",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",null,"Heel and Toe Spin",null,"Heel and Toe Spin",null,"Heel and Toe Spin",null,"Heel and Toe Spin"]
[1,"In-Line Free Skating Requirements1","5.","In-Line Free Skating Requirements15.",null,"Two Heel Spin",null,"Two Heel Spin",null,"Two Heel Spin",null,"Two Heel Spin",null,"Two Heel Spin"]
[1,"In-Line Free Skating Requirements1","6.","In-Line Free Skating Requirements16.",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump",null,"Waltz Jump"]
[1,"In-Line Free Skating Requirements1","7.","In-Line Free Skating Requirements17.",null,"Toe Loop",null,"Toe Loop",null,"Toe Loop",null,"Toe Loop",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.",null,"Choose 1 Jump:  Bunny Hop  or  ½ Salchow  or  ½ Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Bunny Hop  or  ½ Salchow  or  ½ Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Bunny Hop  or  ½ Salchow  or  ½ Loop.  Jump name must be entered.",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: ",null,"Jump combo of 2 jumps - choose from: ",null,"Jump combo of 2 jumps - choose from: ",null,"Jump combo of 2 jumps - choose from: ",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.",null,".  Waltz Jump, Toe Loop, Bunny Hop, ½ Toe Loop, Mazurka.  Jump names must be entered.",null,".  Waltz Jump, Toe Loop, Bunny Hop, ½ Toe Loop, Mazurka.  Jump names must be entered.",null,".  Waltz Jump, Toe Loop, Bunny Hop, ½ Toe Loop, Mazurka.  Jump names must be entered.",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$471&A485","v":"In-Line Free Skating Requirements1"},{"$f":"IF(B485=B484,TEXT(VALUE(C484)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B485&C485","v":"In-Line Free Skating Requirements112."}]
[2,{"$f":"$A$471&A486","v":"In-Line Free Skating Requirements2"},"A.","In-Line Free Skating Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2",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",null,"Straightaway Primary Backward Footwork, min ¾ length of floor",null,"Straightaway Primary Backward Footwork, min ¾ length of floor",null,"Straightaway Primary Backward Footwork, min ¾ length of floor",null,"Straightaway Primary Backward Footwork, min ¾ length of floor"]
[2,"In-Line Free Skating Requirements2",{"$f":"IF(B488=B487,TEXT(VALUE(C487)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements22.",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",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)",null,"IB Upright Spin (min 3 revs with wheels, not stopper)",null,"IB Upright Spin (min 3 revs with wheels, not stopper)",null,"IB Upright Spin (min 3 revs with wheels, not stopper)",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)",null,"Choose 1 Spin:  OB Upright  or  OF Upright (min 3 revs with wheels, not stopper)",null,"Choose 1 Spin:  OB Upright  or  OF Upright (min 3 revs with wheels, not stopper)",null,"Choose 1 Spin:  OB Upright  or  OF Upright (min 3 revs with wheels, not stopper)",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",null,"Salchow",null,"Salchow",null,"Salchow",null,"Salchow"]
[2,"In-Line Free Skating Requirements2","6.","In-Line Free Skating Requirements26.",null,"Flip",null,"Flip",null,"Flip",null,"Flip",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",null,"Choose 1 Jump:  Thoren  or  ½ Lutz  or  Loop (OB)  or  Pat Lowe.  Jump name",null,"Choose 1 Jump:  Thoren  or  ½ Lutz  or  Loop (OB)  or  Pat Lowe.  Jump name",null,"Choose 1 Jump:  Thoren  or  ½ Lutz  or  Loop (OB)  or  Pat Lowe.  Jump name",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.",null,"  must be entered.",null,"  must be entered.",null,"  must be entered.",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):",null,"Jump combo of 2 Jumps from the following (no repeated Jumps):",null,"Jump combo of 2 Jumps from the following (no repeated Jumps):",null,"Jump combo of 2 Jumps from the following (no repeated Jumps):",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.",null,".  Flip, Thoren, Salchow, Toe Loop, Waltz Jump.  Jump names must be entered.",null,".  Flip, Thoren, Salchow, Toe Loop, Waltz Jump.  Jump names must be entered.",null,".  Flip, Thoren, Salchow, Toe Loop, Waltz Jump.  Jump names must be entered.",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$471&A498","v":"In-Line Free Skating Requirements2"},{"$f":"IF(B498=B497,TEXT(VALUE(C497)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B498&C498","v":"In-Line Free Skating Requirements212."}]
[3,{"$f":"$A$471&A499","v":"In-Line Free Skating Requirements3"},"A.","In-Line Free Skating Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3",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)",null,"Semi Circular Primary Footwork (width of the floor)",null,"Semi Circular Primary Footwork (width of the floor)",null,"Semi Circular Primary Footwork (width of the floor)",null,"Semi Circular Primary Footwork (width of the floor)"]
[3,"In-Line Free Skating Requirements3",{"$f":"IF(B501=B500,TEXT(VALUE(C500)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements32.",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",null,"Diagonal Secondary Footwork, min ¾ length of floor",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",null,"Change or Combo Upright Spin (min 3 revs with wheels, not stopper).  Edges",null,"Change or Combo Upright Spin (min 3 revs with wheels, not stopper).  Edges",null,"Change or Combo Upright Spin (min 3 revs with wheels, not stopper).  Edges",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.",null,"  (but not foot) must be entered.",null,"  (but not foot) must be entered.",null,"  (but not foot) must be entered.",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",null,"Choose 1 Spin:  OB Camel  or  IB Sit",null,"Choose 1 Spin:  OB Camel  or  IB Sit",null,"Choose 1 Spin:  OB Camel  or  IB Sit",null,"Choose 1 Spin:  OB Camel  or  IB Sit"]
[3,"In-Line Free Skating Requirements3","6.","In-Line Free Skating Requirements36.",null,"Axel",null,"Axel",null,"Axel",null,"Axel",null,"Axel"]
[3,"In-Line Free Skating Requirements3","7.","In-Line Free Skating Requirements37.",null,"1½ or Double Toe Loop ",null,"1½ or Double Toe Loop ",null,"1½ or Double Toe Loop ",null,"1½ or Double Toe Loop ",null,"1½ or Double Toe Loop "]
[3,"In-Line Free Skating Requirements3","8.",{"$f":"B507&C507","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",null,"Choose 1 Jump:  1½ or Dbl Salchow  or  Lutz  or  1½ or Dbl Flip  or  College  or  Boeckl",null,"Choose 1 Jump:  1½ or Dbl Salchow  or  Lutz  or  1½ or Dbl Flip  or  College  or  Boeckl",null,"Choose 1 Jump:  1½ or Dbl Salchow  or  Lutz  or  1½ or Dbl Flip  or  College  or  Boeckl",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):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",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. *",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *"]
[3,{"$f":"$A$471&A510","v":"In-Line Free Skating Requirements3"},"11.",{"$f":"B510&C510","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.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[4,{"$f":"$A$471&A512","v":"In-Line Free Skating Requirements4"},"A.","In-Line Free Skating Requirements4A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4",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)",null,"Circular Secondary Footwork (width of the floor)",null,"Circular Secondary Footwork (width of the floor)",null,"Circular Secondary Footwork (width of the floor)",null,"Circular Secondary Footwork (width of the floor)"]
[4,"In-Line Free Skating Requirements4",{"$f":"IF(B514=B513,TEXT(VALUE(C513)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements42.",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",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.",null,"Change or Combo Sit Spin.  Edges (but not foot) must be entered.",null,"Change or Combo Sit Spin.  Edges (but not foot) must be entered.",null,"Change or Combo Sit Spin.  Edges (but not foot) must be entered.",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",null,"Choose 1 Spin:  IB Camel  or  OF Camel",null,"Choose 1 Spin:  IB Camel  or  OF Camel",null,"Choose 1 Spin:  IB Camel  or  OF Camel",null,"Choose 1 Spin:  IB Camel  or  OF Camel"]
[4,"In-Line Free Skating Requirements4","5.","In-Line Free Skating Requirements45.",null,"Axel",null,"Axel",null,"Axel",null,"Axel",null,"Axel"]
[4,"In-Line Free Skating Requirements4","6.","In-Line Free Skating Requirements46.",null,"Double Salchow",null,"Double Salchow",null,"Double Salchow",null,"Double Salchow",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",null,"Choose 1 Jump:  Double Toe Loop  or  Lutz  or  Walley  or  Double Flip",null,"Choose 1 Jump:  Double Toe Loop  or  Lutz  or  Walley  or  Double Flip",null,"Choose 1 Jump:  Double Toe Loop  or  Lutz  or  Walley  or  Double Flip",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):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",null,"Jump combo of 3 jumps from the following (no repeated Jumps):",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. *",null,". Axel, Double Salchow, Double Toe Loop, Double Flip.  Jump names must be entered. *",null,". Axel, Double Salchow, Double Toe Loop, Double Flip.  Jump names must be entered. *",null,". Axel, Double Salchow, Double Toe Loop, Double Flip.  Jump names must be entered. *",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$471&A524","v":"In-Line Free Skating Requirements4"},{"$f":"IF(B524=B523,TEXT(VALUE(C523)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B524&C524","v":"In-Line Free Skating Requirements412."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[5,{"$f":"$A$471&A525","v":"In-Line Free Skating Requirements5"},"A.","In-Line Free Skating Requirements5A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5",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)",null,"Serpentine Secondary Footwork (width of the floor)",null,"Serpentine Secondary Footwork (width of the floor)",null,"Serpentine Secondary Footwork (width of the floor)",null,"Serpentine Secondary Footwork (width of the floor)"]
[5,"In-Line Free Skating Requirements5",{"$f":"IF(B527=B526,TEXT(VALUE(C526)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements52.",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",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.",null,"Change or Combo Camel to Sit Spin.  Edges (but not foot) must be entered.",null,"Change or Combo Camel to Sit Spin.  Edges (but not foot) must be entered.",null,"Change or Combo Camel to Sit Spin.  Edges (but not foot) must be entered.",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",null,"Choose 1 Spin:  Jump Camel Spin  or  Camel change or combo Spin.  Edges",null,"Choose 1 Spin:  Jump Camel Spin  or  Camel change or combo Spin.  Edges",null,"Choose 1 Spin:  Jump Camel Spin  or  Camel change or combo Spin.  Edges",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.",null,"  (but not foot) must be entered.",null,"  (but not foot) must be entered.",null,"  (but not foot) must be entered.",null,"  (but not foot) must be entered."]
[5,"In-Line Free Skating Requirements5","6.","In-Line Free Skating Requirements56.",null,"Double Flip",null,"Double Flip",null,"Double Flip",null,"Double Flip",null,"Double Flip"]
[5,"In-Line Free Skating Requirements5","7.","In-Line Free Skating Requirements57.",null,"Double Loop",null,"Double Loop",null,"Double Loop",null,"Double Loop",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.",null,"Choose 1 Jump:  Dbl Axel  or  Dbl Lutz  or  Triple Toe Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Dbl Axel  or  Dbl Lutz  or  Triple Toe Loop.  Jump name must be entered.",null,"Choose 1 Jump:  Dbl Axel  or  Dbl Lutz  or  Triple Toe Loop.  Jump name must be entered.",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):",null,"Jump combo of 5 jumps from the following (no repeated Jumps):",null,"Jump combo of 5 jumps from the following (no repeated Jumps):",null,"Jump combo of 5 jumps from the following (no repeated Jumps):",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 ",null,"  Axel, Double Salchow, Double Toe Loop, Double Flip, Double Loop.  Jump ",null,"  Axel, Double Salchow, Double Toe Loop, Double Flip, Double Loop.  Jump ",null,"  Axel, Double Salchow, Double Toe Loop, Double Flip, Double Loop.  Jump ",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. *",null,"  names must be entered. *",null,"  names must be entered. *",null,"  names must be entered. *",null,"  names must be entered. *"]
[5,{"$f":"$A$471&A537","v":"In-Line Free Skating Requirements5"},{"$f":"IF(B537=B536,TEXT(VALUE(C536)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B537&C537","v":"In-Line Free Skating Requirements512."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[6,{"$f":"$A$471&A538","v":"In-Line Free Skating Requirements6"},"A.","In-Line Free Skating Requirements6A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6",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)",null,"Serpentine Advanced Footwork (width of the floor)",null,"Serpentine Advanced Footwork (width of the floor)",null,"Serpentine Advanced Footwork (width of the floor)",null,"Serpentine Advanced Footwork (width of the floor)"]
[6,"In-Line Free Skating Requirements6",{"$f":"IF(B540=B539,TEXT(VALUE(C539)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating Requirements62.",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",null,"Diagonal Advanced Footwork, min ¾ length of floor",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.  ",null,"Change or Combo Camel Spin.  ",null,"Change or Combo Camel Spin.  ",null,"Change or Combo Camel Spin.  ",null,"Change or Combo Camel Spin.  "]
[6,"In-Line Free Skating Requirements6","4.",{"$f":"B542&C542","v":"In-Line Free Skating Requirements64."},null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered.",null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered."]
[6,{"$f":"$A$471&A543","v":"In-Line Free Skating Requirements6"},"5.","In-Line Free Skating Requirements65.",null,"Double Axel",null,"Double Axel",null,"Double Axel",null,"Double Axel",null,"Double Axel"]
[6,"In-Line Free Skating Requirements6","6.","In-Line Free Skating Requirements66.",null,"Triple Toe Loop",null,"Triple Toe Loop",null,"Triple Toe Loop",null,"Triple Toe Loop",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.",null,"Choose 1 Jump:  Dbl Loop  or  Dbl Lutz  or  Triple Salchow.  Jump name must be entered.",null,"Choose 1 Jump:  Dbl Loop  or  Dbl Lutz  or  Triple Salchow.  Jump name must be entered.",null,"Choose 1 Jump:  Dbl Loop  or  Dbl Lutz  or  Triple Salchow.  Jump name must be entered.",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):",null,"Jump combo of 3 Jumps from the following (no repeated Jumps):",null,"Jump combo of 3 Jumps from the following (no repeated Jumps):",null,"Jump combo of 3 Jumps from the following (no repeated Jumps):",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",null,"  Double Axel, Triple Salchow, Triple Toe Loop, Double Flip, Double Loop.  Jump names",null,"  Double Axel, Triple Salchow, Triple Toe Loop, Double Flip, Double Loop.  Jump names",null,"  Double Axel, Triple Salchow, Triple Toe Loop, Double Flip, Double Loop.  Jump names",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. *",null,"  must be entered. *",null,"  must be entered. *",null,"  must be entered. *",null,"  must be entered. *"]
[6,"In-Line Free Skating Requirements6","11.","In-Line Free Skating Requirements611."]
[6,{"$f":"$A$471&A550","v":"In-Line Free Skating Requirements6"},{"$f":"IF(B550=B549,TEXT(VALUE(C549)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B550&C550","v":"In-Line Free Skating Requirements612."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[]
["Precision"]
["Test #",null,"Item #","Full Item","Fig #",{"$f":"+F$3","v":"Item Description - Normal"},"Fig #",{"$f":"+H$3","v":"Transition 1  D:R - 5"},"Fig #",{"$f":"+J$3","v":"Transition 2  D:R - 7"},"Fig #",{"$f":"+L$3","v":"Figures - Foot Draw - a Foot  D:R - 9"},"Fig #",{"$f":"+N$3","v":"Figures - Foot Draw - b Foot  D:R - 11"},"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$552&A554","v":"Precision1"},"1.",{"$f":"B554&C554","v":"Precision11."},null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,13,"2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[1,"Precision1",{"$f":"IF(B555=B554,TEXT(VALUE(C554)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision12.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[2,"Precision2",{"$f":"IF(B556=B555,TEXT(VALUE(C555)+1,\"#\")&\".\",\"1.\")","v":"1."},"Precision21.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,14,"3 mins (+/- 10 seconds)","Silver Medal"]
[2,"Precision2",{"$f":"IF(B557=B556,TEXT(VALUE(C556)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision22.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[3,"Precision3",{"$f":"IF(B558=B557,TEXT(VALUE(C557)+1,\"#\")&\".\",\"1.\")","v":"1."},"Precision31.",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",null,"Technical Merit",5,15,"4 mins (+/- 10 seconds)","Gold Medal"]
[3,"Precision3",{"$f":"IF(B559=B558,TEXT(VALUE(C558)+1,\"#\")&\".\",\"1.\")","v":"2."},"Precision32.",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression",null,"Artistic Impression"]
[]
["Precision Requirements"]
["Test #",null,"Item #","Full Item"]
[1,{"$f":"$A$561&A563","v":"Precision Requirements1"},"A.",{"$f":"B563&C563","v":"Precision Requirements1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 1"]
[1,{"$f":"$A$561&A564","v":"Precision Requirements1"},"1.","Precision Requirements11.",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold",null,"Circle - min 2 revs, 1 direction only, Primary Footwork, any hand hold"]
[1,"Precision Requirements1",{"$f":"IF(B565=B564,TEXT(VALUE(C564)+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",null,"Line - along short axis and down long axis, the length of the floor",null,"Line - along short axis and down long axis, the length of the floor",null,"Line - along short axis and down long axis, the length of the floor",null,"Line - along short axis and down long axis, the length of the floor"]
[1,"Precision Requirements1",{"$f":"IF(B567=B566,TEXT(VALUE(C566)+1,\"#\")&\".\",\"1.\")","v":"4."},"Precision Requirements14."]
[1,"Precision Requirements1","5.",{"$f":"B568&C568","v":"Precision Requirements15."},null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold",null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold",null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold",null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold",null,"Block - min 4 lines, max 6, 1 direction only, Primary Footwork, any handhold"]
[1,{"$f":"$A$561&A569","v":"Precision Requirements1"},"6.",{"$f":"B569&C569","v":"Precision Requirements16."},null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold",null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold",null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold",null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold",null,"Wheel - 4 spoke, 1 direction only, min 2 revs, Primary F/work, any handhold"]
[1,{"$f":"$A$561&A570","v":"Precision Requirements1"},"7.",{"$f":"B570&C570","v":"Precision Requirements17."}]
[1,{"$f":"$A$561&A571","v":"Precision Requirements1"},"8.",{"$f":"B571&C571","v":"Precision Requirements18."},null,"Intersecting - each skater must pass through the intersecting point once only, any handhold",null,"Intersecting - each skater must pass through the intersecting point once only, any handhold",null,"Intersecting - each skater must pass through the intersecting point once only, any handhold",null,"Intersecting - each skater must pass through the intersecting point once only, any handhold",null,"Intersecting - each skater must pass through the intersecting point once only, any handhold"]
[1,{"$f":"$A$561&A572","v":"Precision Requirements1"},"9.",{"$f":"B572&C572","v":"Precision Requirements19."}]
[1,"Precision Requirements1","10.","Precision Requirements110."]
[1,"Precision Requirements1","11.","Precision Requirements111."]
[1,{"$f":"$A$561&A575","v":"Precision Requirements1"},"12.",{"$f":"B575&C575","v":"Precision Requirements112."},null,"No additional elements",null,"No additional elements",null,"No additional elements",null,"No additional elements",null,"No additional elements"]
[2,"Precision Requirements2","A.","Precision Requirements2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 2",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 2",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",null,"Circle - min 2 revs, either direction or combo of both, Secondary Footwork, any handhold",null,"Circle - min 2 revs, either direction or combo of both, Secondary Footwork, any handhold",null,"Circle - min 2 revs, either direction or combo of both, Secondary Footwork, any handhold",null,"Circle - min 2 revs, either direction or combo of both, Secondary Footwork, any handhold"]
[2,"Precision Requirements2",{"$f":"IF(B578=B577,TEXT(VALUE(C577)+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",null,"Line - along short axis and down long axis, the length of the floor, forwards and backwards",null,"Line - along short axis and down long axis, the length of the floor, forwards and backwards",null,"Line - along short axis and down long axis, the length of the floor, forwards and backwards",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",null,"Block - min 4 lines, max 6, 2 axis required, Secondary F/work, any handhold",null,"Block - min 4 lines, max 6, 2 axis required, Secondary F/work, any handhold",null,"Block - min 4 lines, max 6, 2 axis required, Secondary F/work, any handhold",null,"Block - min 4 lines, max 6, 2 axis required, Secondary F/work, any handhold"]
[2,{"$f":"$A$561&A582","v":"Precision Requirements2"},{"$f":"IF(B582=B581,TEXT(VALUE(C581)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B582&C582","v":"Precision Requirements26."}]
[2,{"$f":"$A$561&A583","v":"Precision Requirements2"},{"$f":"IF(B583=B582,TEXT(VALUE(C582)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B583&C583","v":"Precision Requirements27."},null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold",null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold",null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold",null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold",null,"Wheel - 4 spoke moving wheel, min 4 revs, any handhold"]
[2,{"$f":"$A$561&A584","v":"Precision Requirements2"},{"$f":"IF(B584=B583,TEXT(VALUE(C583)+1,\"#\")&\".\",\"1.\")","v":"8."},{"$f":"B584&C584","v":"Precision Requirements28."}]
[2,"Precision Requirements2","9.","Precision Requirements29.",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point ",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point ",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point ",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point ",null,"Intersecting - splice or pass through, each skater must pass through the intersecting point "]
[2,{"$f":"$A$561&A586","v":"Precision Requirements2"},"10.",{"$f":"B586&C586","v":"Precision Requirements210."},null,"once only, any handhold",null,"once only, any handhold",null,"once only, any handhold",null,"once only, any handhold",null,"once only, any handhold"]
[2,"Precision Requirements2",{"$f":"IF(B587=B586,TEXT(VALUE(C586)+1,\"#\")&\".\",\"1.\")","v":"11."},"Precision Requirements211."]
[2,{"$f":"$A$561&A588","v":"Precision Requirements2"},"12.",{"$f":"B588&C588","v":"Precision Requirements212."},null,"No additional elements",null,"No additional elements",null,"No additional elements",null,"No additional elements",null,"No additional elements"]
[3,"Precision Requirements3","A.","Precision Requirements3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3",null,"REQUIREMENTS LIST - NO SET ORDER - Precision No 3"]
[3,"Precision Requirements3","1.","Precision Requirements31.",null,"Circle",null,"Circle",null,"Circle",null,"Circle",null,"Circle"]
[3,"Precision Requirements3","2.","Precision Requirements32."]
[3,"Precision Requirements3","3.","Precision Requirements33.",null,"Line",null,"Line",null,"Line",null,"Line",null,"Line"]
[3,"Precision Requirements3",{"$f":"IF(B593=B592,TEXT(VALUE(C592)+1,\"#\")&\".\",\"1.\")","v":"4."},{"$f":"B593&C593","v":"Precision Requirements34."}]
[3,"Precision Requirements3","5.","Precision Requirements35.",null,"Block",null,"Block",null,"Block",null,"Block",null,"Block"]
[3,{"$f":"$A$561&A595","v":"Precision Requirements3"},{"$f":"IF(B595=B594,TEXT(VALUE(C594)+1,\"#\")&\".\",\"1.\")","v":"6."},{"$f":"B595&C595","v":"Precision Requirements36."}]
[3,{"$f":"$A$561&A596","v":"Precision Requirements3"},{"$f":"IF(B596=B595,TEXT(VALUE(C595)+1,\"#\")&\".\",\"1.\")","v":"7."},{"$f":"B596&C596","v":"Precision Requirements37."},null,"Wheel",null,"Wheel",null,"Wheel",null,"Wheel",null,"Wheel"]
[3,"Precision Requirements3","8.","Precision Requirements38."]
[3,"Precision Requirements3","9.","Precision Requirements39.",null,"Intersecting Manoeuvre",null,"Intersecting Manoeuvre",null,"Intersecting Manoeuvre",null,"Intersecting Manoeuvre",null,"Intersecting Manoeuvre"]
[3,"Precision Requirements3","10.","Precision Requirements310."]
[3,"Precision Requirements3","11.","Precision Requirements311."]
[3,{"$f":"$A$561&A601","v":"Precision Requirements3"},{"$f":"IF(B601=B600,TEXT(VALUE(C600)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B601&C601","v":"Precision Requirements312."},null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed.",null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed.",null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed.",null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed.",null,"Additional elements may be added in the Gold Medal Test provided that all set elements have been completed."]

{"sheet":"CSV Export","index":5,"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":"."},{"$f":"'Application Form'!B11","v":0},{"$f":"'Application Form'!B12","v":""},{"$f":"HLOOKUP(TRIM(H2),K6:U8,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!I16","v":0},{"$f":"'Data Entry Sheet'!B21","v":0},{"$f":"'Data Entry Sheet'!B23","v":""},{"$f":"'Data Entry Sheet'!B24","v":""},{"$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":0},{"$f":"'Data Entry Sheet'!C33","v":"Hide"},{"$f":"'Data Entry Sheet'!B34","v":0},{"$f":"'Data Entry Sheet'!C34","v":"Hide"},{"$f":"'Data Entry Sheet'!B35","v":0},{"$f":"'Data Entry Sheet'!C35","v":"Hide"},{"$f":"'Application Form'!H19","v":""},{"$f":"'Application Form'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Application Form'!J19","v":""},{"$f":"'Application Form'!H20","v":0},{"$f":"'Application Form'!I19","v":""},{"$f":"'Application Form'!J20","v":0},{"$f":"'Application Form'!H21","v":""},{"$f":"'Application Form'!I21","v":""},{"$f":"'Application Form'!J21","v":""},{"$f":"'Application Form'!H22","v":0},{"$f":"'Application Form'!I22","v":0},{"$f":"'Application Form'!J22","v":0},{"$f":"'Application Form'!H23","v":""},{"$f":"'Application Form'!I23","v":""},{"$f":"'Application Form'!J23","v":""},{"$f":"'Application Form'!H24","v":0},{"$f":"'Application Form'!I24","v":0},{"$f":"'Application Form'!J24","v":0},{"$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'!H43","v":""},{"$f":"'Application Form'!I43","v":""},{"$f":"'Application Form'!J43","v":""},{"$f":"'Application Form'!H44","v":""},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":"Figures"},{"$f":"'Data Entry Sheet'!C15","v":"Loops"},{"$f":"'Data Entry Sheet'!D15","v":""},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!F16","v":0},{"$f":"'Data Entry Sheet'!H15","v":0},{"$f":"'Data Entry Sheet'!I15","v":0},{"$f":"'Data Entry Sheet'!J15","v":0},{"$f":"'Data Entry Sheet'!K15","v":0},{"$f":"'Data Entry Sheet'!L15","v":0},{"$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":{"$error":"#REF!"}},{"$error":"#REF!"},"FD","SFD","FP","IL",{"$f":"IF(T6=$H$2,IF(LEN($I$2)=1,T7&\"0\"&$I$2,T7&$I$2),\"\")","v":"P"},{"$f":"IF(U6=$H$2,U7,\"\")","v":"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'!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!"}}]