{"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":4,"macros":1,"external_links":1,"defined_names":475,"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":146,"n_cols":54,"rows_kept":146,"cut":false,"hidden":false,"merged":[[58,0,58,2],[52,0,52,2],[55,3,55,5],[52,18,53,18],[51,0,51,5],[44,21,45,22],[54,3,54,5],[52,3,52,5],[55,0,55,2],[53,3,53,5],[55,7,55,12],[56,7,56,12],[44,2,44,5],[45,2,45,5],[49,2,49,5],[44,7,44,11],[45,7,45,11],[46,7,46,11],[53,15,66,16],[30,2,30,5],[27,0,27,4],[27,5,27,12],[29,0,29,4],[28,0,28,4],[28,9,28,12],[25,0,25,12],[31,2,31,5],[35,2,35,5],[31,7,31,10],[31,11,31,12],[33,2,33,5],[34,2,34,5],[32,7,32,11],[38,2,38,5],[39,2,39,5],[47,7,47,11],[48,7,48,11],[49,7,49,11],[41,2,41,5],[40,2,40,5],[42,7,42,11],[43,7,43,11],[42,2,42,5],[39,7,39,11],[40,7,40,11],[56,36,56,37],[56,38,56,39],[60,27,61,27],[62,27,63,27],[60,29,61,29],[62,29,63,29],[60,31,61,31],[62,31,63,31],[56,27,56,28],[56,34,56,35],[71,29,71,30],[71,31,71,32],[68,29,68,30],[56,31,56,32],[55,23,55,25],[75,29,75,30],[75,31,75,32],[56,29,56,30],[59,23,59,25],[74,27,74,28],[74,29,74,30],[74,31,74,32],[71,27,71,28],[75,27,75,28],[65,23,65,25],[41,27,42,28],[39,27,40,28],[38,23,39,23],[38,24,39,24],[38,25,39,25],[41,23,41,25],[55,27,55,32],[60,23,60,25],[63,23,63,25],[45,23,45,25],[42,21,43,22],[42,23,43,23],[42,24,43,24],[41,7,41,11],[38,7,38,11],[40,21,41,22],[33,23,33,25],[38,17,40,17],[34,21,36,21],[38,21,39,22],[34,23,34,25],[35,23,36,23],[35,24,36,24],[35,25,36,25],[30,22,36,22],[32,23,32,25],[30,7,30,12],[16,21,16,22],[7,18,8,18],[8,25,9,25],[8,26,9,26],[8,27,9,27],[11,25,12,27],[7,25,7,27],[14,16,14,17],[13,19,13,20],[13,21,13,22],[12,16,12,17],[7,16,9,17],[10,16,10,17],[11,16,11,17],[13,16,13,17],[12,23,12,24],[22,8,22,12],[29,5,29,8],[33,7,33,11],[34,7,34,11],[35,7,35,11],[32,2,32,5],[36,2,36,5],[17,36,17,38],[26,23,26,25],[17,2,17,3],[32,27,33,28],[31,27,31,28],[34,27,35,28],[36,29,38,29],[36,30,38,30],[36,7,36,11],[37,7,37,11],[17,5,17,6],[18,5,18,6],[17,8,17,9],[18,8,18,9],[26,2,26,11],[28,5,28,8],[37,2,37,5],[25,44,25,46],[25,48,25,50],[30,41,30,42],[27,41,27,42],[26,41,26,42],[25,41,25,42],[30,44,30,46],[27,27,27,29],[28,41,28,42],[28,48,28,50],[26,44,26,46],[28,44,28,46],[27,44,27,46],[30,48,30,50],[26,27,26,29],[30,27,30,28],[1,1,1,12],[2,1,2,12],[11,1,11,12],[9,1,9,12],[10,1,10,12],[12,1,12,12],[8,1,8,12],[14,3,14,7],[16,0,16,12],[3,1,5,12],[6,1,6,12],[15,3,15,6],[7,1,7,12],[2,19,2,20],[6,19,6,20],[15,32,15,34],[7,23,9,24],[8,21,8,22],[9,21,9,22],[10,21,10,22],[7,21,7,22],[11,21,11,22],[7,19,9,20],[10,19,10,20],[11,19,11,20],[14,25,15,26],[14,27,15,28],[14,29,15,30],[13,23,13,24],[12,19,12,20],[12,21,12,22],[10,23,10,24],[11,23,11,24],[7,15,9,15],[52,15,52,16],[47,2,47,5],[48,2,48,5],[52,17,54,17],[42,25,44,25],[46,25,48,25],[51,21,52,22],[53,0,54,2],[49,23,49,24],[46,2,46,5],[43,2,43,5],[46,23,47,23],[46,24,47,24],[50,23,51,23],[50,24,51,24],[50,7,50,11],[50,2,50,5],[54,23,54,25],[46,21,46,22],[26,0,26,1],[20,8,20,9],[19,2,19,4],[20,10,20,12],[141,22,142,22],[141,23,142,25],[68,15,76,16],[60,0,60,2],[61,0,61,2],[62,0,62,2],[56,3,56,5],[57,3,57,5],[56,0,57,2],[66,17,68,17],[67,15,67,16],[64,1,64,11],[65,1,65,11],[58,3,58,5],[66,7,67,11],[88,23,89,25],[59,0,59,2],[85,23,85,25],[82,23,82,25],[83,23,83,25],[84,23,84,25],[76,23,76,25],[64,23,64,25],[75,23,75,25],[143,22,143,25],[144,23,144,25],[145,23,145,25],[62,23,62,25],[61,23,61,25],[66,23,66,25],[70,23,70,25],[71,23,71,25],[72,23,72,25],[73,23,73,25],[74,23,74,25],[129,23,129,25],[133,23,133,25],[134,23,134,25],[135,23,135,25],[136,22,136,25],[137,23,137,25],[138,23,138,25],[139,23,139,25],[140,23,140,25],[86,23,86,25],[88,22,89,22],[77,23,77,25],[81,23,81,25]]}
[null,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,"Previous Test Date =",null,{"$f":"Previous_Test_Date","v":"."}]
[null,"SA PROFICIENCY TEST FORM NS - 2025-01 NEW STRUCTURE - FREE SKATING\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,{"$f":"Test_Date_Y_N","v":"NO"},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,null,"First Free Skating test - no previous attempt at this test","If Last Test Type is Old Free Skating & C",null,"If Last Test was Old Free Skating & NYC","If Last Test was New Free Skating & C",null,"Last Test New Free Skating & NYC",null,"Skate Ups Free Skating\n\nIf Last Test was New Free Skating & Skate Up",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,{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Free Skating\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,null,"Free Skating A","Free Skating B","All Free Skating"]
["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 Free Skating\",Previous_Test_Result=\"NYC\"),Previous_Test_Number,\"\"))","v":""},null,null,"Test Held is"]
["TEST CENTRE:",null,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,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Free Skating\",Previous_Test_Result=\"NYC\"),IF(ISNA(VLOOKUP(Test_Done_Last_New_Free_Skating_NYC,New_FS_Level_Held_NYC_List,2,FALSE)),\"\",(VLOOKUP(Test_Done_Last_New_Free_Skating_NYC,New_FS_Level_Held_NYC_List,2,FALSE))),\"\")","v":""},null,"Previous Test Done Today",null,{"$f":"IF(Test_Held_First_Test_Free_Skating<>\"\",Test_Held_First_Test_Free_Skating,IF(Test_Held_Last_Old_Free_Skating_C<>\"\",Test_Held_Last_Old_Free_Skating_C,IF(Test_Held_Last_Old_Free_Skating_NYC<>\"\",Test_Held_Last_Old_Free_Skating_NYC,\"\")))","v":""},{"$f":"IF(Test_Held_Last_New_Free_Skating_C<>\"\",Test_Held_Last_New_Free_Skating_C,IF(Test_Held_Last_New_Free_Skating_NYC<>\"\",Test_Held_Last_New_Free_Skating_NYC,IF(Test_Held_S_Ups_Free_Skating_C<>\"\",Test_Held_S_Ups_Free_Skating_C,\"\")))","v":""},{"$f":"IF(Test_Held_Free_Skating_A<>\"\",Test_Held_Free_Skating_A,IF(Test_Held_Free_Skating_B<>\"\",Test_Held_Free_Skating_B,\"\"))","v":""}]
["TEST DATE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"None\",IF(AND(Test_Date_Y_N=\"NO\",Test_Number_FS=\"FS01\",Previous_Test_Type=\"N/A\",Previous_Test_Number=\"N/A\",Previous_Test_Result=\"N/A\"),\"None\",\"\")))","v":""},{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"Old Free Skating\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Test_Done_Last_Old_Free_Skating_NYC=1),\"None\",IF(Test_Done_Last_Old_Free_Skating_NYC<>\"\",+Test_Done_Last_Old_Free_Skating_NYC-1,\"\"))","v":""},{"$f":"IF(Previous_Test_Number=\"\",\"\",IF(AND(Test_Date_Y_N=\"YES\",Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Free Skating\",Previous_Test_Result=\"C\"),Previous_Test_Number,\"\"))","v":""},null,{"$f":"IF(AND(Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS01\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS02\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS03\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS04\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS05\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS06\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS07\",Test_Held_New_Free_Skating_NYC_LOOKUP<>\"FS08\"),\"\",Test_Held_New_Free_Skating_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 Free Skating\",Previous_Test_Result=\"Skate Up\"),Previous_Test_Number,\"\"))","v":""},null,"Next Test to be done"]
["PARTNER:\n(Couples Dance only)",null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Held_First_Test_Free_Skating=\"None\",Free_Skating_First_Test,\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Old_Free_Skating_C,Transition_Old_to_New_Free_Skating_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Old_Free_Skating_C,Transition_Old_to_New_Free_Skating_List,2,FALSE)))","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_Old_Free_Skating_NYC,Transition_Old_to_New_Free_Skating_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_Old_Free_Skating_NYC,Transition_Old_to_New_Free_Skating_List,2,FALSE)))","v":""},{"$f":"IF(AND(Previous_Test_Date_1<>Test_Date,Previous_Test_Type=\"New Free Skating\",Previous_Test_Result=\"C\"),IF(ISNA(VLOOKUP(Test_Held_Last_New_Free_Skating_C,New_FS_Next_FS_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_New_Free_Skating_C,New_FS_Next_FS_C_List,2,FALSE))),\"\")","v":""},null,{"$f":"IF(ISNA(VLOOKUP(Test_Held_Last_New_Free_Skating_NYC,New_FS_Next_NYC,2,FALSE)),\"\",(VLOOKUP(Test_Held_Last_New_Free_Skating_NYC,New_FS_Next_NYC,2,FALSE)))","v":""},null,{"$f":"IF(AND(Previous_Test_Date_1=Test_Date_1,Previous_Test_Type=\"New Free Skating\",Previous_Test_Result=\"Skate Up\"),IF(ISNA(VLOOKUP(Test_Held_S_Ups_Free_Skating_C,New_FS_Next_FS_C_List,2,FALSE)),\"\",(VLOOKUP(Test_Held_S_Ups_Free_Skating_C,New_FS_Next_FS_C_List,2,FALSE))),\"\")","v":""},null,{"$f":"IF(Free_Skating_No_Previous_Test<>\"\",Free_Skating_No_Previous_Test,IF(Free_Skating_Old_C<>\"\",Free_Skating_Old_C,IF(Free_Skating_Old_NYC<>\"\",Free_Skating_Old_NYC,\"\")))","v":""},{"$f":"IF(Free_Skating_New_C<>\"\",Free_Skating_New_C,IF(Free_Skating_New_NYC<>\"\",Free_Skating_New_NYC,IF(Free_Skating_Skate_Up<>\"\",Free_Skating_Skate_Up,\"\")))","v":""},{"$f":"IF(Free_Skating_Next_To_Be_Done_A<>\"\",Free_Skating_Next_To_Be_Done_A,IF(Free_Skating_Next_To_Be_Done_B<>\"\",Free_Skating_Next_To_Be_Done_B,\"\"))","v":""}]
["TEST DISCIPLINE","Free Skating",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Previous_Test_Type","v":""},{"$f":"IF(Test_Number_FS=\"\",\"\",IF(Test_Number_FS<>\"\",Test_Discipline_Free_Skating,))","v":""},null,{"$f":"IF(Previous_Test_Structure=\"\",\"\",IF(AND(Previous_Test_Structure=\"Old\",Test_Discipline=\"Free Skating\"),\"Old Free Skating\",IF(AND(Previous_Test_Structure=\"New\",Test_Discipline=\"Free Skating\"),\"New Free Skating\",IF(AND(Test_Discipline=\"Free Skating\",Previous_Test_Structure=\"N/A\"),\"N/A\"))))","v":""},null,null,null,null,null,null,"NEW FREE SKATING\nPrevious Test was C\nNext Free Skating to be done",null,"NEW  FREE SKATING\nPrevious Test was NYC\nLevel Held",null,"NEW FREE SKATING\nPrevious Test was NYC\nNext Free Skating to be done"]
["TEST NO:",null,"",{"$f":"IF(Warnings=\"No warnings\",\"\",Warnings)","v":""},null,null,null,"Fee Paid:",null,null,null,"Award:",{"$f":"IF(ISNA(VLOOKUP($P$32,'Test Details'!$D:$Z,22,FALSE)),\"\",(VLOOKUP($P$32,'Test Details'!$D:$Z,22,FALSE)))","v":""},null,null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",IF(Test_Number_FS<>\"\",Test_Number_FS))","v":""},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,null,null,{"$f":"Test_Held","v":""},null,null,"Free Skating New","Free Skating Old",null,"                                         Transition Old to New\n\n                                              FREE SKATING\n\n          Test Held                                       Next To Do",null,null,null,"Test Held","Next to do","  Test  NYC","Test Held","Test Held","Next Test",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"},{"$f":"Previous_Test_Type","v":""}]
["Date of previous Test in this discipline\n(whether C or NYC)",".","Was the previous Test in this discipline done in the Old Test Structure or the New Test Structure\n(whether C or NYC)?",null,"","What is the 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,null,null,"N/A",null,null,"FS01",1,null,"None","FS01",null,null,"None","FS01","FS01","None","None","FS01",null,"Free Skating - no previous test","Old Free Skating","New Free Skating","Skate Ups - Free Skating","        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"]
[null,null,null,null,null,"Test currently held is:",null,{"$f":"IF(Test_Held=\"\",\"\",Test_Held)","v":""},"The next Test this Skater is eligible to do is:",null,{"$f":"IF(Next_Test_To_Be_Done<>\"\",Next_Test_To_Be_Done,\"\")","v":""},null,null,null,null,null,null,null,"FS02",2,null,1,"FS02",null,null,"FS01","FS02","FS02","FS01","FS01","FS02",null,{"$f":"IF(Test_Number_FS=\"\",\"\",IF(AND(Test_Discipline=\"Free Skating\",Test_Number_FS=\"FS01\",Test_Date_Y_N=\"NO\"),\"First Free Skating Test\",\"\"))","v":""},{"$f":"IF(Test_Number_FS=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(Previous_Test_Type<>\"Old Free Skating\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_FS,\"\",\"The Test applied for is not the next Test to be done.  Please refer to the Transition Tables.\"))))))","v":""},{"$f":"IF(Test_Number_FS=\"\",\"\",IF(Previous_Test_Result=\"\",\"\",IF(Previous_Test_Type<>\"New Free Skating\",\"\",IF(OR(Previous_Test_Number=\"\",Previous_Test_Number=\"N/A\"),\"\",IF(Test_Date=Previous_Test_Date,\"\",IF(Test_to_be_done_now=Test_Number_FS,\"\",\"The Test applied for is not the next Test to be done.  Please refer to the Transition Tables.\"))))))","v":""},{"$f":"IF(AND(AH17=Previous_Test_Type=\"New Free Skating\",Test_Number_FS<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now<>Test_Number_FS),\"The Test applied for is not the next Test to be done.  Please refer to the Transition Tables.\",IF(AND(Previous_Test_Type=\"New Free Skating\",Test_Number_FS<>\"\",Previous_Test_Date=Test_Date,Previous_Test_Result=\"Skate Up\",Test_to_be_done_now=Test_Number_FS),\"This is a Skate Up\",\"\"))","v":""},{"$f":"IF(Free_Skating_First_Test_to_be_done<>\"\",Free_Skating_First_Test_to_be_done,\"\")","v":""},{"$f":"IF(Free_Skating_Old_Wrong_Test<>\"\",Free_Skating_Old_Wrong_Test,IF(Free_Skating_New_Wrong_Test<>\"\",Free_Skating_New_Wrong_Test,\"\"))","v":""},{"$f":"IF(Skate_Ups_Free_Skating<>\"\",Skate_Ups_Free_Skating,\"\")","v":""},{"$f":"IF(Warning_No_Previous_Test<>\"\",\"\",IF(Warning_Other<>\"\",Warning_Other,IF(Warning_Skate_Ups<>\"\",Warning_Skate_Ups,\"No warnings\")))","v":"No warnings"}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Old",null,null,"FS03",3,null,2,"FS03",null,null,"FS02","FS03","FS03","FS02","FS02","FS03"]
[null,null,null,null,null,null,null,null,"Time:",null,{"$f":"IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,21,FALSE)),\"\",(VLOOKUP($P$31,'Test Details'!$D:$Z,21,FALSE)))","v":""},null,null,null,null,"New",null,null,"FS04",4,null,3,"FS04",null,null,"FS03","FS04","FS04","FS03","FS03","FS04"]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New",null,null,"FS05",5,null,4,"FS05",null,null,"FS04","FS05","FS05","FS04","FS04","FS05"]
["Minimum Mark:",{"$f":"IF(ISNA(VLOOKUP($P$32,'Test Details'!$D:$Z,19,FALSE)),\"\",(VLOOKUP($P$32,'Test Details'!$D:$Z,19,FALSE)))","v":""},null,"Hide",null,null,null,null,null,null,null,null,null,null,null,"C",null,null,"FS06",6,null,5,"FS06",null,null,"FS05","FS06","FS06","FS05","FS05","FS06"]
["Minimum Total Mark:",{"$f":"IF(ISNA(VLOOKUP($P$32,'Test Details'!$D:$Z,20,FALSE)),\"\",(VLOOKUP($P$32,'Test Details'!$D:$Z,20,FALSE)))","v":""},null,"Hide",null,null,null,null,null,null,null,null,null,null,null,"NYC",null,null,"FS07",7,null,6,"FS07",null,null,"FS06","FS07","FS07","FS06","FS06","FS07"]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skate Up",null,null,"FS08",8,null,7,"FS08",null,null,"FS07","FS08","FS08","FS07","FS07","FS08"]
[{"$f":"IF(Warnings=\"No warnings\",\"\",Warnings)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,8,"N/A",null,null,"FS08","N/A",null,null,"FS08","N/A"]
["Name of Person completing the Application:",null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[" CONTENT LIST\n 1.  Select the Code from the drop down list in the CODE column\n 2.  Combo Jumps and Spins - see below\n 3.  Enter the elements in order of skating in the ELEMENTS column\n 4.  The REQUIREMENTS LIST shows the elements required for this Test",null,null,null,null,"♦ After entering all Elements, any warnings at the end of the Elements List must be resolved\n   before clicking SAVE SKATER FILE.\n♦ The REFEREE'S MARKING SHEET must be signed by the Skater regardless of age, and if a\n     Skater is under 18 years of age, it must also be signed by the Coach or Parent/Guardian,\n     before submitting it to the Test Supervisor.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codes entered = elements entered","Total number of jumps","Total number of combo jumps","Total number of solo spins","Total number of combo spins","No. of choreo seq"]
[" COMBO JUMPS",null,null,null,null," COMBO SPINS",null,null,null,"EXAMPLE (Tests 1, 2 and 3 do not have \"NJ\")",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Test_Number_FS","v":0},"No. jumps in combos","Jump Nos. missing","No of spin elements",null,"No. of footwork seq"]
[{"$f":"IF(Test_Number_FS=\"\",\"This will display when the Test Number is selected\",IF(OR($P31=\"Free SkatingFS01A.\",$P31=\"Free SkatingFS02A.\",$P31=\"Free SkatingFS03A.\"),Combo_Jumps_Tests_1_to_3,IF(OR($P31=\"Free SkatingFS04A.\",$P31=\"Free SkatingFS05A.\",$P31=\"Free SkatingFS06A.\",$P31=\"Free SkatingFS07A.\",$P31=\"Free SkatingFS08A.\"),Combo_Jumps_Tests_4_to_8,\"\")))","v":"This will display when the Test Number is selected"},null,null,null,null,"♦  In the CODE column, select\n    \"CSp\".\n♦  In the ELEMENTS column, enter the RollArt code for each \n     of the positions in the combo into the SAME row, separated\n     by commas, eg FOS, BIU (forward outside sit, back\n     inside  upright) - edges and description only, NOT foot.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total number of elements","Total number of codes entered","Number of Jumps\nWomen\nTests 5 - 8","Number of Jumps\nMen\nTests 5 - 8","Number of Jumps\nTests 1 - 4",null,null,{"$f":"Test_Number_FS","v":0},"Number of Solo Spins\nAll except Test 3","Number of Spin Elements\nTest 3","Number of Combo Spins"]
["CODE","COMBO JUMP NUMBERS","ELEMENTS",null,null,null,"START TIME IF F/W",{"$f":"IF(ISNA(VLOOKUP($P31,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P31,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,null,null,{"$f":"IF($Q$15>0,MATCH($Q$16,$B$16:$C$16),MATCH($S$16,$B$16:$C$16))","v":2},{"$f":"OFFSET($A$15,0,O31)&OFFSET($A$16,0,O31)&S31","v":""},null,"F/S Codes List",{"$f":"IF(Test_Number_FS=\"\",\"\",\"A.\")","v":""},{"$f":"OFFSET($A$16,0,$O31)","v":""},null,"Blank cells",null,"Jumps Required","Jumps Required","Jumps Required"," ",{"$f":"IF(Test_Number_FS=\"FS03\",\"N/A\",IF(Solo_Spins_Number_Entered>Solo_Spins_Number_Required,Solo_Spins_Number_Entered&\" Solo Spin/s entered. Max. allowed \"&Solo_Spins_Number_Required,IF(Solo_Spins_Number_Entered<Solo_Spins_Number_Required,Solo_Spins_Number_Entered&\" Solo Spin/s entered.  1 is required.\",\"N/A\")))","v":"N/A"},null," Required"," Required"," Required"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P32,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P32,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,null,{"$f":"IF($Q$15>0,MATCH($Q$16,$B$16:$C$16),MATCH($S$16,$B$16:$C$16))","v":2},{"$f":"OFFSET($A$15,0,O32)&OFFSET($A$16,0,O32)&S32","v":""},null,"CoJ(1)",{"$f":"IF(Test_Number_FS=\"\",\"\",\"1.\")","v":""},{"$f":"OFFSET($A$16,0,$O32)","v":""},null,{"$f":"COUNTBLANK(Elements_Entered_List)","v":20},null,null,null,{"$f":"IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,6,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,6,FALSE)))","v":0},null,{"$f":"IF(Test_Number_FS<>\"FS03\",\"N/A\",IF(Spin_Elements_Number_Entered>Spin_Elements_Number_Required,Spin_Elements_Number_Entered&\" spin element/s entered. Max. allowed is \"&Spin_Elements_Number_Required,IF(Spin_Elements_Number_Entered<Spin_Elements_Number_Required,Spin_Elements_Number_Entered&\" spin element/s entered.  2 are required.\",\"N/A\")))","v":"N/A"},null,{"$f":"IF(Test_Number_FS=\"FS03\",0,IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,12,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,12,FALSE))))","v":0},{"$f":"IF(Test_Number_FS<>\"FS03\",0,IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,14,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,14,FALSE))))","v":0},{"$f":"IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,13,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,13,FALSE)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P33,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P33,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P33,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P33,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,"CoJ(2)",{"$f":"IF(Test_Number_FS=\"\",\"\",\"2.\")","v":""},"",null,"Total cells",null,"Jumps Required (excl connection Jumps if appropriate)",null,null,null,{"$f":"IF(Test_Number_FS=\"FS03\",\"N/A\",IF(Combo_Spins_Number_Entered>Combo_Spins_Number_Required,Combo_Spins_Number_Entered&\" Combo Spin/s entered. Max. allowed \"&Combo_Spins_Number_Required,IF(Combo_Spins_Number_Entered<Combo_Spins_Number_Required,Combo_Spins_Number_Entered&\" Combo Spin/s entered. \"&Combo_Spins_Number_Required&\" are required.\",\"N/A\")))","v":"N/A"},null," Entered"," Entered"," Entered"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P34,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P34,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P34,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P34,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,"SJu",{"$f":"IF(Test_Number_FS=\"\",\"\",\"3.\")","v":""},"",null,20,null,{"$f":"Jumps_Required","v":0},null,null,null,null,null,{"$f":"IF(COUNTIF(Codes_Entered_List,\"SSp*\")=\"\",0,COUNTIF(Codes_Entered_List,\"SSp*\"))","v":0},{"$f":"IF(Test_Number_FS=\"FS03\",Solo_Spins_Number_Entered+Combo_Spins_Number_Entered,0)","v":0},{"$f":"IF(COUNTIF(Codes_Entered_List,\"CSp*\")=\"\",0,COUNTIF(Codes_Entered_List,\"CSp*\"))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P35,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P35,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P35,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P35,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,"CSp",{"$f":"IF(Test_Number_FS=\"\",\"\",\"4.\")","v":""},"",null,"Therefore number of requirements entered is",null,"Jumps Entered (excl connection Jumps if appropriate)",null,null,null,{"$f":"IF(Test_Number_FS<>\"FS03\",\"N/A\",IF(Combo_Spins_Number_Entered>Combo_Spins_Number_Allowed_Test_3,Combo_Spins_Number_Entered&\" Combo Spins entered. Max. allowed \"&Combo_Spins_Number_Required,IF(Combo_Spins_Number_Entered<Combo_Spins_Number_Required,Combo_Spins_Number_Entered&\" Combo Spins entered. \"&Combo_Spins_Number_Required&\" required.\",\"N/A\")))","v":"N/A"},null,null,null,"Combo Spins Allowed Test 3"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P36,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P36,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P36,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P36,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,"SSp",{"$f":"IF(Test_Number_FS=\"\",\"\",\"5.\")","v":""},"",null,null,null,"Jump 1, 2, 3, 4 and 5\nin Combos but not NJ","All Sju","Total Jumps excl NJ",null,null,null,null,null,{"$f":"IF(Test_Number_FS<>\"FS03\",0,IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,14,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,14,FALSE))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P37,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P37,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P37,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P37,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,"FoSq",{"$f":"IF(Test_Number_FS=\"\",\"\",\"6.\")","v":""},"",null,null,null,null,null,null,null,null,null,"Footwork","Choreo"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P38,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P38,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P38,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P38,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,{"$f":"IF(OR(Test_Number_FS=\"FS06\",Test_Number_FS=\"FS07\",Test_Number_FS=\"FS08\"),\"ChSt\",\".\")","v":"."},{"$f":"IF(Test_Number_FS=\"\",\"\",\"7.\")","v":""},"",null,{"$f":"V34-V32","v":0},{"$f":"COUNTA(Codes_Entered_List)","v":0},{"$f":"IF(COUNTIF(Jumps_Entered_List,\"Jump*\")=\"\",0,COUNTIF(Jumps_Entered_List,\"Jump*\"))","v":0},{"$f":"IF(COUNTIF(Codes_Entered_List,\"SJu\")=\"\",0,COUNTIF(Codes_Entered_List,\"SJu\"))","v":0},{"$f":"Jumps_Entered_with_Jump_Number+Jumps_Entered_SJu","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P39,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P39,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P39,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P39,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"8.\")","v":""},"",null,{"$f":"IF(Total_Requirements_Entered>Total_Codes_Entered,\"An element has been entered with no code. Please check the Code List.\",IF(Total_Requirements_Entered<Total_Codes_Entered,\"A code has been entered without an element. Please check the Elements List.\",\"N/A\"))","v":"N/A"},null,"No. Jumps Entered Combo 1\nincl NJ","No. Jumps Entered Combo 2\nincl NJ","How many combos?"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P40,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P40,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P40,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P40,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"9.\")","v":""},"",null,null,null,null,null,null,null,{"$f":"IF(Footwork_Entered>Footwork_Required,Footwork_Entered&\" Footwork sequences entered. Max. allowed is \"&Footwork_Required,IF(Footwork_Entered<Footwork_Required,\"Footwork sequence not entered.  1 is required.\",\"N/A\"))","v":"N/A"},null," Required"," Required"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P41,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P41,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P41,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P41,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"10.\")","v":""},"",null,{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\",Test_Number_FS=\"FS03\"),IF(Jumps_Required_for_this_Test>Jumps_Entered,Jumps_Entered&\" jumps entered. \"&Jumps_Required_for_this_Test&\" jumps are required.\",IF(Jumps_Required_for_this_Test<Jumps_Entered,Jumps_Entered&\" jumps entered. Max. allowed is \"&Jumps_Required_for_this_Test&\".\",\"N/A\")),IF(Jumps_Required_for_this_Test>Jumps_Entered,Jumps_Entered&\" jumps entered. \"&Jumps_Required_for_this_Test&\" required, excl. connecting jumps.\",IF(Jumps_Required_for_this_Test<Jumps_Entered,Jumps_Entered&\" jumps entered.  Max. is \"&Jumps_Required_for_this_Test&\", excl. connecting jumps.\",\"N/A\")))","v":"N/A"},null,{"$f":"IF(COUNTIF(Codes_Entered_List,\"CoJ(1)\")=\"\",0,COUNTIF(Codes_Entered_List,\"CoJ(1)\"))","v":0},{"$f":"IF(COUNTIF(Codes_Entered_List,\"CoJ(2)\")=\"\",0,COUNTIF(Codes_Entered_List,\"CoJ(2)\"))","v":0},{"$f":"IF(AND(Number_Jumps_Entered_Combo_1=0,Number_Jumps_Entered_Combo_2=0),0,IF(AND(Number_Jumps_Entered_Combo_1=0,Number_Jumps_Entered_Combo_2>0),1,IF(AND(Number_Jumps_Entered_Combo_1>0,Number_Jumps_Entered_Combo_2=0),1,IF(AND(Number_Jumps_Entered_Combo_1>0,Number_Jumps_Entered_Combo_2>0),2,0))))","v":0},null,null,null,{"$f":"IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,15,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,15,FALSE)))","v":0},{"$f":"IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,16,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,16,FALSE)))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P42,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P42,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P42,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P42,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"11.\")","v":""},"",null,null,null,"Tests No 1 & 3 to 8",null,null,null,{"$f":"IF(Choreo_Entered>Choreo_Required,Choreo_Entered&\" Choreo sequences entered. Max. allowed is \"&Choreo_Required,IF(Choreo_Entered<Choreo_Required,\"Choreo sequence not entered.  1 is required.\",\"N/A\"))","v":"N/A"},null," Entered"," Entered"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P43,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P43,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P43,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P43,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"12.\")","v":""},"",null,{"$f":"IF(Total_Codes_Entered=0,\"N/A\",IF(Number_of_Jump_Combos=2,\"N/A\",IF(Number_of_Jump_Combos<2,Number_of_Jump_Combos&\" jump combo entered.  2 combos are required.\",IF(Number_of_Jump_Combos>2,Number_of_Jump_Combos&\" jump combos entered.  The maximum is 2 for this test.\",\"N/A\"))))","v":"N/A"},null,"No. allowed Combo 1","No. allowed Combo 2",{"$f":"IF(Test_Number_FS<>\"FS02\",IF(Number_of_Jump_Combos=2,IF(OR(Number_Jumps_Entered_Combo_1<2,Number_Jumps_Entered_Combo_2<2),\"Combos must have a minimum of 2 jumps\",IF(Test_Number_FS<>\"FS02\",IF(OR(Number_Jumps_Entered_Combo_1>Number_Jumps_Allowed_in_Combo_1,Number_Jumps_Entered_Combo_2>Number_Jumps_Allowed_in_Combo_2),Number_Jumps_Entered_Combo_1&\" jumps entered in Combo 1 and \"&Number_Jumps_Entered_Combo_2&\" jumps entered in Combo 2. Max. is \"&Number_Jumps_Allowed_in_Combo_1&\" in each combo including connecting jumps.\",\"N/A\"))),\"N/A\"),\"N/A\")","v":"N/A"},null,null,null,{"$f":"IF(COUNTIF(Codes_Entered_List,\"FoSq*\")=\"\",0,COUNTIF(Codes_Entered_List,\"FoSq*\"))","v":0},{"$f":"IF(COUNTIF(Codes_Entered_List,\"ChSt*\")=\"\",0,COUNTIF(Codes_Entered_List,\"ChSt*\"))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P44,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P44,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P44,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P44,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"13.\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P45,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P45,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P45,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P45,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"14.\")","v":""},"",null,{"$f":"IF(Test_Number_FS<>\"FS02\",Jumps_in_Combos_incorrect_number_Tests_1_and_3_to_8,IF(Test_Number_FS=\"FS02\",Jumps_in_Combos_incorrect_number_Test_2,\"N/A\"))","v":"N/A"},null,{"$f":"IF(Test_Number_FS<>\"FS02\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,10,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,10,FALSE))),0)","v":0},{"$f":"IF(Test_Number_FS<>\"FS02\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,11,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,11,FALSE))),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P46,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P46,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P46,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P46,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"15.\")","v":""},"",null,null,null,"Test No 2 - combos can be 1 x 4 max. and 1 x 3 max."]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P47,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P47,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P47,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P47,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"16.\")","v":""},"",null,"Footwork with no Start Time Warnings",null,"No. allowed Combo 1\nincl NJ (1 x 4, 1 x 3)","No. allowed Combo 2\nincl NJ (1 x 4, 1 x 3)",{"$f":"IF(Test_Number_FS=\"FS02\",IF(Number_of_Jump_Combos=2,IF(OR(Number_Jumps_Entered_Combo_1<2,Number_Jumps_Entered_Combo_2<2),\"Both jump combos must have at least 2 jumps\",IF(Number_Jumps_Entered_Combo_1+Number_Jumps_Entered_Combo_2>Number_Jumps_Allowed_in_Combo_1_Test_2+Number_Jumps_Allowed_in_Combo_2_Test_2,\"Too many jumps in combo. Max. is \"&Number_Jumps_Allowed_in_Combo_1_Test_2&\" in 1 combo and \"&Number_Jumps_Allowed_in_Combo_2_Test_2&\" in the other including connecting jumps\",\"N/A\")),\"N/A\"),\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P48,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P48,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P48,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P48,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"17.\")","v":""},"",null,{"$f":"IF(AND(A32=\"FoSQ\",G32=\"\"),\"Start Time for Footwork required\",IF(AND(A33=\"FoSQ\",G33=\"\"),\"Start Time for Footwork required\",IF(AND(A34=\"FoSQ\",G34=\"\"),\"Start Time for Footwork required\",IF(AND(A35=\"FoSQ\",G35=\"\"),\"Start Time for Footwork required\",IF(AND(A36=\"FoSQ\",G36=\"\"),\"Start Time for Footwork required\",IF(AND(A37=\"FoSQ\",G37=\"\"),\"Start Time for Footwork required\",IF(AND(A38=\"FoSQ\",G38=\"\"),\"Start Time for Footwork required\",\"\")))))))","v":""},{"$f":"IF(AND(A39=\"FoSQ\",G39=\"\"),\"Start Time for Footwork required\",IF(AND(A40=\"FoSQ\",G40=\"\"),\"Start Time for Footwork required\",IF(AND(A41=\"FoSQ\",G41=\"\"),\"Start Time for Footwork required\",IF(AND(A42=\"FoSQ\",G42=\"\"),\"Start Time for Footwork required\",IF(AND(A43=\"FoSQ\",G43=\"\"),\"Start Time for Footwork required\",IF(AND(A44=\"FoSQ\",G44=\"\"),\"Start Time for Footwork required\",IF(AND(A45=\"FoSQ\",G45=\"\"),\"Start Time for Footwork required\",\"\")))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P49,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P49,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P49,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P49,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"18.\")","v":""},"",null,{"$f":"IF(AND(A46=\"FoSQ\",G46=\"\"),\"Start Time for Footwork required\",IF(AND(A47=\"FoSQ\",G47=\"\"),\"Start Time for Footwork required\",IF(AND(A48=\"FoSQ\",G48=\"\"),\"Start Time for Footwork required\",IF(AND(A49=\"FoSQ\",G49=\"\"),\"Start Time for Footwork required\",IF(AND(A50=\"FoSQ\",G50=\"\"),\"Start Time for Footwork required\",IF(AND(A51=\"FoSQ\",G51=\"\"),\"Start Time for Footwork required\",\"\"))))))","v":""},{"$f":"IF(OR(Footwork_No_Start_Time_Warning_1=\"Start Time for Footwork Required\",Footwork_No_Start_Time_Warning_2=\"Start Time for Footwork Required\",Footwork_No_Start_Time_Warning_3=\"Start Time for Footwork Required\"),\"Start Time for Footwork is required\",\"N/A\")","v":"N/A"},{"$f":"IF(Test_Number_FS=\"FS02\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,10,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,10,FALSE))),0)","v":0},{"$f":"IF(Test_Number_FS=\"FS02\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,11,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,11,FALSE))),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P50,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P50,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P50,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P50,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"19.\")","v":""},"",null,null,null,"Combo entered but with no Jump Number"]
[null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P51,'Test Details'!$D:$Z,3,FALSE)),\"\",(VLOOKUP($P51,'Test Details'!$D:$Z,3,FALSE)))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP($P51,'Test Details'!$D:$Z,4,FALSE)),\"\",(VLOOKUP($P51,'Test Details'!$D:$Z,4,FALSE)))","v":""},null,2,"",null,null,{"$f":"IF(Test_Number_FS=\"\",\"\",\"20.\")","v":""},"",null,null,null,"Total Jumps incl NJ in Jumps List","Number CoJ(1) & CoJ(2)"]
["After entering all Elements, any warnings listed below must be resolved before proceeding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Number_Jumps_Entered_Total_Incl_NJ>Number_Jumps_Entered_Both_Combos,Number_Jumps_Entered_Total_Incl_NJ&\" Combo Jump Numbers entered.  Only \"&Number_Jumps_Entered_Both_Combos&\" Combo Codes entered. They must be equal.\",IF(Number_Jumps_Entered_Total_Incl_NJ<Number_Jumps_Entered_Both_Combos,Number_Jumps_Entered_Total_Incl_NJ&\" Combo Jump Numbers entered. \"&Number_Jumps_Entered_Both_Combos&\" Combo Jump Codes entered.  They must be equal.\",\"N/A\"))","v":"N/A"}]
[{"$f":"IF(Codes_must_be_entered_for_all_elements_warning<>\"N/A\",+Codes_must_be_entered_for_all_elements_warning,\"\")","v":""},null,null,{"$f":"IF(Combo_Spins_Number_Incorrect_Warning_Not_Test_3<>\"N/A\",+Combo_Spins_Number_Incorrect_Warning_Not_Test_3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Tests 1 to 3",null,"Jump Numbers for Combo 1","Jump List depending on the Test being done",null,null,null,null,{"$f":"COUNTA(Jumps_Entered_List)","v":0},{"$f":"Number_Jumps_Entered_Combo_1+Number_Jumps_Entered_Combo_2","v":0}]
[{"$f":"IF(Combo_Jump_Number_Codes_Warning=\"N/A\",\"\",Combo_Jump_Number_Codes_Warning)","v":""},null,null,{"$f":"IF(Combo_Spins_Number_Incorrect_Warning_Test_3<>\"N/A\",+Combo_Spins_Number_Incorrect_Warning_Test_3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null," ♦  In the CODE column, select \"CoJ(1)\" for each jump in the first combo and\n     \"CoJ(2)\" for each jump in the second combo - enter each Code into a SEPARATE row.\n ♦  In the COMBO JUMP NUMBERS column:\n     ♦  Select the jump number (in numerical order) for each jump in the combo.\n     ♦  If not a COMBO JUMP, leave blank.\n ♦  In the ELEMENTS column, enter the RollArt code for each jump in the combo\n     into a SEPARATE row, eg 1T or 1A."]
[null,null,null,{"$f":"IF(Spin_Elements_Number_Incorrect_Warning<>\"N/A\",+Spin_Elements_Number_Incorrect_Warning,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRONZE TESTS"]
[{"$f":"IF(Combo_Jumps_incorrect_number_entered_Warning<>\"N/A\",+Combo_Jumps_incorrect_number_entered_Warning,\"\")","v":""},null,null,{"$f":"IF(Solo_Spins_Number_Incorrect_Warning<>\"N/A\",+Solo_Spins_Number_Incorrect_Warning,\"\")","v":""},null,null,null,"Where do you want to save this Test Centre?",null,null,null,null,null,null,null,null,null,"Jump 1 (C1)",null,"Components","QoEs",null,null,{"$f":"IF(OR(Award=\"1st Bronze Bar\",Award=\"2nd Bronze Bar\",Award=\"Bronze Medal\"),\"Bronze\",\"\")","v":""},null,null,null,"CALCULATE RESULTS"]
[{"$f":"IF(Jumps_in_Combos_incorrect_number_Warning<>\"N/A\",+Jumps_in_Combos_incorrect_number_Warning,\"\")","v":""},null,null,{"$f":"IF(Footwork_number_incorrect_Warning<>\"N/A\",+Footwork_number_incorrect_Warning,\"\")","v":""},null,null,null,"C:\\Temp",null,null,null,null,null,null,null,null,null,"Jump 2 (C1)",null,0.25,-3,null,null,"Judge 1","Judge 2","Judge 3",null,"JUDGE 1",null,"JUDGE 2",null,"JUDGE 3",null,null,"JUDGE 1",null,"JUDGE 2",null,"JUDGE 3"]
[null,null,null,{"$f":"IF(Choreo_number_incorrect_Warning<>\"N/A\",+Choreo_number_incorrect_Warning,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_FS=\"FS01\",\".\",\"Jump 3 (C1)\")","v":"Jump 3 (C1)"},null,{"$f":"T57+0.25","v":0.5},-2,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":""},null,"Count Number of -2","Count Number of -3","Count Number of -2","Count Number of -3","Count Number of -2","Count Number of -3",null,"Jumps","Spins","Jumps","Spins","Jumps","Spins"]
[{"$f":"IF(Jumps_incorrect_number_Warning<>\"N/A\",+Jumps_incorrect_number_Warning,\"\")","v":""},null,null,{"$f":"IF(Footwork_No_Start_Time_Warning=\"N/A\",\"\",Footwork_No_Start_Time_Warning)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_FS=\"FS01\",\".\",\"Jump 4 (C1)\")","v":"Jump 4 (C1)"},null,0.75,-1,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":""},null,{"$f":"COUNTIF(Technical_Marks_J1,-2)","v":0},{"$f":"COUNTIF(Technical_Marks_J1,-3)","v":0},{"$f":"COUNTIF(Technical_Marks_J2,-2)","v":0},{"$f":"COUNTIF(Technical_Marks_J2,-3)","v":0},{"$f":"COUNTIF(Technical_Marks_J3,-2)","v":0},{"$f":"COUNTIF(Technical_Marks_J3,-3)","v":0},null,{"$f":"IF(OR('Application Form'!$A16=\"CoJ(1)\",'Application Form'!$A16=\"CoJ(2)\",'Application Form'!$A16=\"SJu\"),Value_J1_Element_1,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A16=\"CSp\",'Application Form'!$A16=\"SSp\"),Value_J1_Element_1,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A16=\"CoJ(1)\",'Application Form'!$A16=\"CoJ(2)\",'Application Form'!$A16=\"SJu\"),Value_J2_Element_1,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A16=\"CSp\",'Application Form'!$A16=\"SSp\"),Value_J2_Element_1,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A16=\"CoJ(1)\",'Application Form'!$A16=\"CoJ(2)\",'Application Form'!$A16=\"SJu\"),Value_J3_Element_1,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A16=\"CSp\",'Application Form'!$A16=\"SSp\"),Value_J3_Element_1,\"\")","v":""}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\"),\".\",\"Jump 5 (C1)\")","v":"Jump 5 (C1)"},null,1,0,null,"Number of Cs",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",COUNTIF(X59:Z59,\"C\"))","v":""},null,null,null,"Total -2 and -3",{"$f":"J1_Total_Negative_2+J1_Total_Negative_3","v":0},"Total -2 and -3",{"$f":"J2_Total_Negative_2+J2_Total_Negative_3","v":0},"Total -2 and -3",{"$f":"J3_Total_Negative_2+J3_Total_Negative_3","v":0},null,{"$f":"IF(OR('Application Form'!$A17=\"CoJ(1)\",'Application Form'!$A17=\"CoJ(2)\",'Application Form'!$A17=\"SJu\"),Value_J1_Element_2,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A17=\"CSp\",'Application Form'!$A17=\"SSp\"),Value_J1_Element_2,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A17=\"CoJ(1)\",'Application Form'!$A17=\"CoJ(2)\",'Application Form'!$A17=\"SJu\"),Value_J2_Element_2,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A17=\"CSp\",'Application Form'!$A17=\"SSp\"),Value_J2_Element_2,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A17=\"CoJ(1)\",'Application Form'!$A17=\"CoJ(2)\",'Application Form'!$A17=\"SJu\"),Value_J3_Element_2,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A17=\"CSp\",'Application Form'!$A17=\"SSp\"),Value_J3_Element_2,\"\")","v":""}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\",Test_Number_FS=\"FS03\"),\".\",\"NJ (C1)\")","v":"NJ (C1)"},null,1.25,1,null,"Number of Judges on Panel",{"$f":"IF(Award_Bronze<>\"Bronze\",\"\",COUNTIF(X58:Z58,\"Yes\"))","v":""},null,null,null,"Count Number of Jumps with -3","Count Jumps -3","Count Number of Jumps with -3","Count Jumps -3","Count Number of Jumps with -3","Count Jumps -3",null,{"$f":"IF(OR('Application Form'!$A18=\"CoJ(1)\",'Application Form'!$A18=\"CoJ(2)\",'Application Form'!$A18=\"SJu\"),Value_J1_Element_3,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A18=\"CSp\",'Application Form'!$A18=\"SSp\"),Value_J1_Element_3,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A18=\"CoJ(1)\",'Application Form'!$A18=\"CoJ(2)\",'Application Form'!$A18=\"SJu\"),Value_J2_Element_3,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A18=\"CSp\",'Application Form'!$A18=\"SSp\"),Value_J2_Element_3,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A18=\"CoJ(1)\",'Application Form'!$A18=\"CoJ(2)\",'Application Form'!$A18=\"SJu\"),Value_J3_Element_3,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A18=\"CSp\",'Application Form'!$A18=\"SSp\"),Value_J3_Element_3,\"\")","v":""}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,2,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,null,null,{"$f":"COUNTIF(Judge_1_Jumps_Tech_Marks,-3)","v":0},null,{"$f":"COUNTIF(Judge_2_Jumps_Tech_Marks,-3)","v":0},null,{"$f":"COUNTIF(Judge_3_Jumps_Tech_Marks,-3)","v":0},null,{"$f":"IF(OR('Application Form'!$A19=\"CoJ(1)\",'Application Form'!$A19=\"CoJ(2)\",'Application Form'!$A19=\"SJu\"),Value_J1_Element_4,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A19=\"CSp\",'Application Form'!$A19=\"SSp\"),Value_J1_Element_4,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A19=\"CoJ(1)\",'Application Form'!$A19=\"CoJ(2)\",'Application Form'!$A19=\"SJu\"),Value_J2_Element_4,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A19=\"CSp\",'Application Form'!$A19=\"SSp\"),Value_J2_Element_4,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A19=\"CoJ(1)\",'Application Form'!$A19=\"CoJ(2)\",'Application Form'!$A19=\"SJu\"),Value_J3_Element_4,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A19=\"CSp\",'Application Form'!$A19=\"SSp\"),Value_J3_Element_4,\"\")","v":""}]
["Hide",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.75,3,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,null,"Count Number of Spins with -3","Count Spins -3","Count Number of Spins with -3","Count Spins -3","Count Number of Spins with -3","Count CoJ(2) & -3",null,{"$f":"IF(OR('Application Form'!$A20=\"CoJ(1)\",'Application Form'!$A20=\"CoJ(2)\",'Application Form'!$A20=\"SJu\"),Value_J1_Element_5,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A20=\"CSp\",'Application Form'!$A20=\"SSp\"),Value_J1_Element_5,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A20=\"CoJ(1)\",'Application Form'!$A20=\"CoJ(2)\",'Application Form'!$A20=\"SJu\"),Value_J2_Element_5,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A20=\"CSp\",'Application Form'!$A20=\"SSp\"),Value_J2_Element_5,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A20=\"CoJ(1)\",'Application Form'!$A20=\"CoJ(2)\",'Application Form'!$A20=\"SJu\"),Value_J3_Element_5,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A20=\"CSp\",'Application Form'!$A20=\"SSp\"),Value_J3_Element_5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,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,null,null,{"$f":"COUNTIF(Judge_1_Spins_Tech_Marks,-3)","v":0},null,{"$f":"COUNTIF(Judge_2_Spins_Tech_Marks,-3)","v":0},null,{"$f":"COUNTIF(Judge_3_Spins_Tech_Marks,-3)","v":0},null,{"$f":"IF(OR('Application Form'!$A21=\"CoJ(1)\",'Application Form'!$A21=\"CoJ(2)\",'Application Form'!$A21=\"SJu\"),Value_J1_Element_6,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A21=\"CSp\",'Application Form'!$A21=\"SSp\"),Value_J1_Element_6,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A21=\"CoJ(1)\",'Application Form'!$A21=\"CoJ(2)\",'Application Form'!$A21=\"SJu\"),Value_J2_Element_6,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A21=\"CSp\",'Application Form'!$A21=\"SSp\"),Value_J2_Element_6,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A21=\"CoJ(1)\",'Application Form'!$A21=\"CoJ(2)\",'Application Form'!$A21=\"SJu\"),Value_J3_Element_6,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A21=\"CSp\",'Application Form'!$A21=\"SSp\"),Value_J3_Element_6,\"\")","v":""}]
["FileName",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25,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,{"$f":"IF(AND(J1_Total_Negative_3_Jumps=0,J1_Total_Negative_3_Spins=0,J1_Total_Negative_2_and_3=0),\"\",IF(OR(J1_Total_Negative_3_Jumps>=2,J1_Total_Negative_3_Spins>=2,J1_Total_Negative_2_and_3>=3),\"NYC\",\"C\"))","v":""},"Count Number of Marks",{"$f":"COUNT(Technical_Marks_J1)","v":0},"Count Number of Marks",{"$f":"COUNT(Technical_Marks_J2)","v":0},"Count Number of Marks",{"$f":"COUNT(Technical_Marks_J3)","v":0},null,{"$f":"IF(OR('Application Form'!$A22=\"CoJ(1)\",'Application Form'!$A22=\"CoJ(2)\",'Application Form'!$A22=\"SJu\"),Value_J1_Element_7,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A22=\"CSp\",'Application Form'!$A22=\"SSp\"),Value_J1_Element_7,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A22=\"CoJ(1)\",'Application Form'!$A22=\"CoJ(2)\",'Application Form'!$A22=\"SJu\"),Value_J2_Element_7,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A22=\"CSp\",'Application Form'!$A22=\"SSp\"),Value_J2_Element_7,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A22=\"CoJ(1)\",'Application Form'!$A22=\"CoJ(2)\",'Application Form'!$A22=\"SJu\"),Value_J3_Element_7,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A22=\"CSp\",'Application Form'!$A22=\"SSp\"),Value_J3_Element_7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,null,null,null,"SILVER TESTS",null,null,null,"TECHNICAL RESULT J1",{"$f":"IF(AND(Value_J1_Element_1=\"\",Value_J1_Element_2=\"\",Value_J1_Element_3=\"\",Value_J1_Element_4=\"\",Value_J1_Element_5=\"\",Value_J1_Element_6=\"\",Value_J1_Element_7=\"\",Value_J1_Element_8=\"\",Value_J1_Element_9=\"\",Value_J1_Element_10=\"\",Value_J1_Element_11=\"\",Value_J1_Element_12=\"\",Value_J1_Element_13=\"\",Value_J1_Element_14=\"\",Value_J1_Element_15=\"\",Value_J1_Element_16=\"\",Value_J1_Element_17=\"\",Value_J1_Element_18=\"\",Value_J1_Element_19=\"\",Value_J1_Element_20=\"\"),\"\",IF(OR(J1_Total_Negative_3_Jumps>=2,J1_Total_Negative_3_Spins>=2,J1_Total_Negative_2_and_3>=3),\"NYC\",\"C\"))","v":""},"TECHNICAL RESULT J2",{"$f":"IF(AND(Value_J2_Element_1=\"\",Value_J2_Element_2=\"\",Value_J2_Element_3=\"\",Value_J2_Element_4=\"\",Value_J2_Element_5=\"\",Value_J2_Element_6=\"\",Value_J2_Element_7=\"\",Value_J2_Element_8=\"\",Value_J2_Element_9=\"\",Value_J2_Element_10=\"\",Value_J2_Element_11=\"\",Value_J2_Element_12=\"\",Value_J2_Element_13=\"\",Value_J2_Element_14=\"\",Value_J2_Element_15=\"\",Value_J2_Element_16=\"\",Value_J2_Element_17=\"\",Value_J2_Element_18=\"\",Value_J2_Element_19=\"\",Value_J2_Element_20=\"\"),\"\",IF(OR(J2_Total_Negative_3_Jumps>=2,J2_Total_Negative_3_Spins>=2,J2_Total_Negative_2_and_3>=3),\"NYC\",\"C\"))","v":""},"TECHNICAL RESULT J3",{"$f":"IF(AND(Value_J3_Element_1=\"\",Value_J3_Element_2=\"\",Value_J3_Element_3=\"\",Value_J3_Element_4=\"\",Value_J3_Element_5=\"\",Value_J3_Element_6=\"\",Value_J3_Element_7=\"\",Value_J3_Element_8=\"\",Value_J3_Element_9=\"\",Value_J3_Element_10=\"\",Value_J3_Element_11=\"\",Value_J3_Element_12=\"\",Value_J3_Element_13=\"\",Value_J3_Element_14=\"\",Value_J3_Element_15=\"\",Value_J3_Element_16=\"\",Value_J3_Element_17=\"\",Value_J3_Element_18=\"\",Value_J3_Element_19=\"\",Value_J3_Element_20=\"\"),\"\",IF(OR(J3_Total_Negative_3_Jumps>=2,J3_Total_Negative_3_Spins>=2,J3_Total_Negative_2_and_3>=3),\"NYC\",\"C\"))","v":""},null,{"$f":"IF(OR('Application Form'!$A23=\"CoJ(1)\",'Application Form'!$A23=\"CoJ(2)\",'Application Form'!$A23=\"SJu\"),Value_J1_Element_8,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A23=\"CSp\",'Application Form'!$A23=\"SSp\"),Value_J1_Element_8,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A23=\"CoJ(1)\",'Application Form'!$A23=\"CoJ(2)\",'Application Form'!$A23=\"SJu\"),Value_J2_Element_8,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A23=\"CSp\",'Application Form'!$A23=\"SSp\"),Value_J2_Element_8,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A23=\"CoJ(1)\",'Application Form'!$A23=\"CoJ(2)\",'Application Form'!$A23=\"SJu\"),Value_J3_Element_8,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A23=\"CSp\",'Application Form'!$A23=\"SSp\"),Value_J3_Element_8,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump Numbers for Combo 2",null,2.75,null,null,null,{"$f":"IF(OR(Award=\"1st Silver Bar\",Award=\"2nd Silver Bar\",Award=\"Silver Medal\"),\"Silver\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Application Form'!$A24=\"CoJ(1)\",'Application Form'!$A24=\"CoJ(2)\",'Application Form'!$A24=\"SJu\"),Value_J1_Element_9,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A24=\"CSp\",'Application Form'!$A24=\"SSp\"),Value_J1_Element_9,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A24=\"CoJ(1)\",'Application Form'!$A24=\"CoJ(2)\",'Application Form'!$A24=\"SJu\"),Value_J2_Element_9,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A24=\"CSp\",'Application Form'!$A24=\"SSp\"),Value_J2_Element_9,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A24=\"CoJ(1)\",'Application Form'!$A24=\"CoJ(2)\",'Application Form'!$A24=\"SJu\"),Value_J3_Element_9,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A24=\"CSp\",'Application Form'!$A24=\"SSp\"),Value_J3_Element_9,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tests 4 to 8",null,null,null,3,null,null,null,"Judge 1","Judge 2","Judge 3",null,null,null,null,null,null,null,null,{"$f":"IF(OR('Application Form'!$A25=\"CoJ(1)\",'Application Form'!$A25=\"CoJ(2)\",'Application Form'!$A25=\"SJu\"),Value_J1_Element_10,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A25=\"CSp\",'Application Form'!$A25=\"SSp\"),Value_J1_Element_10,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A25=\"CoJ(1)\",'Application Form'!$A25=\"CoJ(2)\",'Application Form'!$A25=\"SJu\"),Value_J2_Element_10,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A25=\"CSp\",'Application Form'!$A25=\"SSp\"),Value_J2_Element_10,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A25=\"CoJ(1)\",'Application Form'!$A25=\"CoJ(2)\",'Application Form'!$A25=\"SJu\"),Value_J3_Element_10,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A25=\"CSp\",'Application Form'!$A25=\"SSp\"),Value_J3_Element_10,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ♦  In the CODE column, select \"CoJ(1)\" for each jump in the first combo and\n     \"CoJ(2)\" for each jump in the second combo - enter each Code into a SEPARATE row.\n ♦  In the COMBO JUMP NUMBERS column:\n     ♦  Select the jump number (in numerical order) for each jump in the combo\n         or \"NJ (C1) / NJ (C2)\" for the connecting jumps.\n     ♦  If not a COMBO JUMP, leave blank.\n ♦  In the ELEMENTS column, enter the RollArt code for each jump in the combo\n     into a SEPARATE row, eg 1T or 1A.",null,null,null,3.25,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,null,"COMPONENTS",null,null,null,null,{"$f":"IF(OR('Application Form'!$A26=\"CoJ(1)\",'Application Form'!$A26=\"CoJ(2)\",'Application Form'!$A26=\"SJu\"),Value_J1_Element_11,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A26=\"CSp\",'Application Form'!$A26=\"SSp\"),Value_J1_Element_11,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A26=\"CoJ(1)\",'Application Form'!$A26=\"CoJ(2)\",'Application Form'!$A26=\"SJu\"),Value_J2_Element_11,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A26=\"CSp\",'Application Form'!$A26=\"SSp\"),Value_J2_Element_11,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A26=\"CoJ(1)\",'Application Form'!$A26=\"CoJ(2)\",'Application Form'!$A26=\"SJu\"),Value_J3_Element_11,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A26=\"CSp\",'Application Form'!$A26=\"SSp\"),Value_J3_Element_11,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump 1 (C2)",null,3.5,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,null,"Minimum Total",{"$f":"IF(VLOOKUP($P$31,'Test Details'!$D:$Z,17,FALSE)=\"\",\"0\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,17,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,17,FALSE))))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(OR('Application Form'!$A27=\"CoJ(1)\",'Application Form'!$A27=\"CoJ(2)\",'Application Form'!$A27=\"SJu\"),Value_J1_Element_12,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A27=\"CSp\",'Application Form'!$A27=\"SSp\"),Value_J1_Element_12,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A27=\"CoJ(1)\",'Application Form'!$A27=\"CoJ(2)\",'Application Form'!$A27=\"SJu\"),Value_J2_Element_12,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A27=\"CSp\",'Application Form'!$A27=\"SSp\"),Value_J2_Element_12,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A27=\"CoJ(1)\",'Application Form'!$A27=\"CoJ(2)\",'Application Form'!$A27=\"SJu\"),Value_J3_Element_12,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A27=\"CSp\",'Application Form'!$A27=\"SSp\"),Value_J3_Element_12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump 2 (C2)",null,3.75,null,null,"Number of Cs",{"$f":"IF(Award_Silver<>\"Silver\",\"\",COUNTIF(X70:Z70,\"C\"))","v":""},null,null,null,null,null,"Minimum Individual",{"$f":"IF(VLOOKUP($P$31,'Test Details'!$D:$Z,18,FALSE)=\"\",\"0\",IF(ISNA(VLOOKUP($P$31,'Test Details'!$D:$Z,18,FALSE)),0,(VLOOKUP($P$31,'Test Details'!$D:$Z,18,FALSE))))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(OR('Application Form'!$A28=\"CoJ(1)\",'Application Form'!$A28=\"CoJ(2)\",'Application Form'!$A28=\"SJu\"),Value_J1_Element_13,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A28=\"CSp\",'Application Form'!$A28=\"SSp\"),Value_J1_Element_13,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A28=\"CoJ(1)\",'Application Form'!$A28=\"CoJ(2)\",'Application Form'!$A28=\"SJu\"),Value_J2_Element_13,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A28=\"CSp\",'Application Form'!$A28=\"SSp\"),Value_J2_Element_13,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A28=\"CoJ(1)\",'Application Form'!$A28=\"CoJ(2)\",'Application Form'!$A28=\"SJu\"),Value_J3_Element_13,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A28=\"CSp\",'Application Form'!$A28=\"SSp\"),Value_J3_Element_13,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_FS=\"FS01\",\".\",\"Jump 3 (C2)\")","v":"Jump 3 (C2)"},null,4,null,null,"Number of Judges on Panel",{"$f":"IF(Award_Silver<>\"Silver\",\"\",COUNTIF(X69:Z69,\"Yes\"))","v":""},null,null,null,"JUDGE 1",null,"JUDGE 2",null,"JUDGE 3",null,null,{"$f":"IF(OR('Application Form'!$A29=\"CoJ(1)\",'Application Form'!$A29=\"CoJ(2)\",'Application Form'!$A29=\"SJu\"),Value_J1_Element_14,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A29=\"CSp\",'Application Form'!$A29=\"SSp\"),Value_J1_Element_14,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A29=\"CoJ(1)\",'Application Form'!$A29=\"CoJ(2)\",'Application Form'!$A29=\"SJu\"),Value_J2_Element_14,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A29=\"CSp\",'Application Form'!$A29=\"SSp\"),Value_J2_Element_14,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A29=\"CoJ(1)\",'Application Form'!$A29=\"CoJ(2)\",'Application Form'!$A29=\"SJu\"),Value_J3_Element_14,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A29=\"CSp\",'Application Form'!$A29=\"SSp\"),Value_J3_Element_14,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Test_Number_FS=\"FS01\",\".\",\"Jump 4 (C2)\")","v":"Jump 4 (C2)"},null,{"$f":"T72+0.25","v":4.25},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,"Total","Lowest Individual","Total","Lowest Individual","Total","Lowest Individual",null,{"$f":"IF(OR('Application Form'!$A30=\"CoJ(1)\",'Application Form'!$A30=\"CoJ(2)\",'Application Form'!$A30=\"SJu\"),Value_J1_Element_15,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A30=\"CSp\",'Application Form'!$A30=\"SSp\"),Value_J1_Element_15,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A30=\"CoJ(1)\",'Application Form'!$A30=\"CoJ(2)\",'Application Form'!$A30=\"SJu\"),Value_J2_Element_15,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A30=\"CSp\",'Application Form'!$A30=\"SSp\"),Value_J2_Element_15,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A30=\"CoJ(1)\",'Application Form'!$A30=\"CoJ(2)\",'Application Form'!$A30=\"SJu\"),Value_J3_Element_15,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A30=\"CSp\",'Application Form'!$A30=\"SSp\"),Value_J3_Element_15,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\"),\".\",\"Jump 5 (C2)\")","v":"Jump 5 (C2)"},null,4.5,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,{"$f":"Total_Components_Assessed_J1","v":0},{"$f":"MIN(Components_J1)","v":0},{"$f":"Total_Components_Assessed_J2","v":0},{"$f":"MIN(Components_J2)","v":0},{"$f":"Total_Components_Assessed_J3","v":0},{"$f":"MIN(Components_J3)","v":0},null,{"$f":"IF(OR('Application Form'!$A31=\"CoJ(1)\",'Application Form'!$A31=\"CoJ(2)\",'Application Form'!$A31=\"SJu\"),Value_J1_Element_16,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A31=\"CSp\",'Application Form'!$A31=\"SSp\"),Value_J1_Element_16,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A31=\"CoJ(1)\",'Application Form'!$A31=\"CoJ(2)\",'Application Form'!$A31=\"SJu\"),Value_J2_Element_16,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A31=\"CSp\",'Application Form'!$A31=\"SSp\"),Value_J2_Element_16,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A31=\"CoJ(1)\",'Application Form'!$A31=\"CoJ(2)\",'Application Form'!$A31=\"SJu\"),Value_J3_Element_16,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A31=\"CSp\",'Application Form'!$A31=\"SSp\"),Value_J3_Element_16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\",Test_Number_FS=\"FS03\"),\".\",\"NJ (C2)\")","v":"NJ (C2)"},null,4.75,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,{"$f":"COUNT(Components_J1)","v":0},null,{"$f":"COUNT(Components_J2)","v":0},null,{"$f":"COUNT(Components_J3)","v":0},null,null,{"$f":"IF(OR('Application Form'!$A32=\"CoJ(1)\",'Application Form'!$A32=\"CoJ(2)\",'Application Form'!$A32=\"SJu\"),Value_J1_Element_17,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A32=\"CSp\",'Application Form'!$A32=\"SSp\"),Value_J1_Element_17,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A32=\"CoJ(1)\",'Application Form'!$A32=\"CoJ(2)\",'Application Form'!$A32=\"SJu\"),Value_J2_Element_17,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A32=\"CSp\",'Application Form'!$A32=\"SSp\"),Value_J2_Element_17,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A32=\"CoJ(1)\",'Application Form'!$A32=\"CoJ(2)\",'Application Form'!$A32=\"SJu\"),Value_J3_Element_17,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A32=\"CSp\",'Application Form'!$A32=\"SSp\"),Value_J3_Element_17,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,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,{"$f":"IF(Number_Component_Marks_J1>0,IF(AND(Total_Components_J1=0,Lowest_Component_J1=0),\"\",IF(AND(Total_Components_J1>=Minimum_Total_Components_Required,Lowest_Component_J1>=Minimum_Individual_Component_Required),\"C\",\"NYC\")),\"\")","v":""},null,{"$f":"IF(Number_Component_Marks_J2>0,IF(AND(Total_Components_J2=0,Lowest_Component_J2=0),\"\",IF(AND(Total_Components_J2>=Minimum_Total_Components_Required,Lowest_Component_J2>=Minimum_Individual_Component_Required),\"C\",\"NYC\")),\"\")","v":""},null,{"$f":"IF(Number_Component_Marks_J3>0,IF(AND(Total_Components_J3=0,Lowest_Component_J3=0),\"\",IF(AND(Total_Components_J3>=Minimum_Total_Components_Required,Lowest_Component_J3>=Minimum_Individual_Component_Required),\"C\",\"NYC\")),\"\")","v":""},null,null,{"$f":"IF(OR('Application Form'!$A33=\"CoJ(1)\",'Application Form'!$A33=\"CoJ(2)\",'Application Form'!$A33=\"SJu\"),Value_J1_Element_18,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A33=\"CSp\",'Application Form'!$A33=\"SSp\"),Value_J1_Element_18,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A33=\"CoJ(1)\",'Application Form'!$A33=\"CoJ(2)\",'Application Form'!$A33=\"SJu\"),Value_J2_Element_18,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A33=\"CSp\",'Application Form'!$A33=\"SSp\"),Value_J2_Element_18,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A33=\"CoJ(1)\",'Application Form'!$A33=\"CoJ(2)\",'Application Form'!$A33=\"SJu\"),Value_J3_Element_18,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A33=\"CSp\",'Application Form'!$A33=\"SSp\"),Value_J3_Element_18,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.25,null,null,null,"GOLD TESTS",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Application Form'!$A34=\"CoJ(1)\",'Application Form'!$A34=\"CoJ(2)\",'Application Form'!$A34=\"SJu\"),Value_J1_Element_19,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A34=\"CSp\",'Application Form'!$A34=\"SSp\"),Value_J1_Element_19,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A34=\"CoJ(1)\",'Application Form'!$A34=\"CoJ(2)\",'Application Form'!$A34=\"SJu\"),Value_J2_Element_19,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A34=\"CSp\",'Application Form'!$A34=\"SSp\"),Value_J2_Element_19,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A34=\"CoJ(1)\",'Application Form'!$A34=\"CoJ(2)\",'Application Form'!$A34=\"SJu\"),Value_J3_Element_19,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A34=\"CSp\",'Application Form'!$A34=\"SSp\"),Value_J3_Element_19,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5,null,null,null,{"$f":"IF(OR(Award=\"Gold Bar\",Award=\"Gold Medal\"),\"Gold\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR('Application Form'!$A35=\"CoJ(1)\",'Application Form'!$A35=\"CoJ(2)\",'Application Form'!$A35=\"SJu\"),Value_J1_Element_20,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A35=\"CSp\",'Application Form'!$A35=\"SSp\"),Value_J1_Element_20,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A35=\"CoJ(1)\",'Application Form'!$A35=\"CoJ(2)\",'Application Form'!$A35=\"SJu\"),Value_J2_Element_20,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A35=\"CSp\",'Application Form'!$A35=\"SSp\"),Value_J2_Element_20,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A35=\"CoJ(1)\",'Application Form'!$A35=\"CoJ(2)\",'Application Form'!$A35=\"SJu\"),Value_J3_Element_20,\"\")","v":""},{"$f":"IF(OR('Application Form'!$A35=\"CSp\",'Application Form'!$A35=\"SSp\"),Value_J3_Element_20,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.75,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,null,6,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,null,6.25,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,null,6.5,null,null,"Number of Cs",{"$f":"IF(Award_Gold<>\"Gold\",\"\",COUNTIF(X81:Z81,\"C\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.75,null,null,"Number of Judges on Panel",{"$f":"IF(Award_Gold<>\"Gold\",\"\",COUNTIF(X80:Z80,\"Yes\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,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,null,7.25,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,null,7.5,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,null,7.75,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,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.25,null,null,"Overall Result",{"$f":"IF(Result_Bronze<>\"\",Result_Bronze,IF(Result_Silver<>\"\",Result_Silver,IF(Result_Gold<>\"\",Result_Gold,\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Award","v":""}]
[null,null,null,null,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,null,null,null,null,"Which Judges on Panel",{"$f":"IF(OR(Result_J1=\"C\",Result_J1=\"NYC\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(Result_J2=\"C\",Result_J2=\"NYC\"),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(Result_J3=\"C\",Result_J3=\"NYC\"),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessment per Judge",{"$f":"IF(Result_J1=\"\",\"\",Result_J1)","v":""},{"$f":"IF(Result_J2=\"\",\"\",Result_J2)","v":""},{"$f":"IF(Result_J3=\"\",\"\",Result_J3)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Judges on Panel",{"$f":"COUNTIF(X132:Z132,\"Yes\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is One Judge Allowed",{"$f":"IF(OR(Award_Bronze=\"1st Bronze Bar\",Award_Bronze=\"2nd Bronze Bar\",Award_Bronze=\"3rd Bronze Bar\",Award_Bronze=\"4th Bronze Bar\",Award_Bronze=\"Bronze Medal\"),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Are Two Judges Allowed",{"$f":"IF(OR(Test_Number_FS=\"FS01\",Test_Number_FS=\"FS02\",Test_Number_FS=\"FS03\"),\"No\",\"Yes\")","v":"Yes"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If 1 Judge allowed - Result",{"$f":"IF(AND(Number_of_Judges_on_Panel_Bronze=1,Number_of_Cs_Bronze=\"Yes\"),IF(COUNTIF(Assessment_only_2_Judges,\"C\")=2,\"Competent\",IF(COUNTIF(Assessment_only_2_Judges,\"C\")=1,\"Video Review Required\",\"Not Yet Competent\")),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If 2 Judges allowed - Result",{"$f":"IF(AND(Number_of_Judges_on_Panel_Bronze=2,Two_Judges_Allowed=\"Yes\"),IF(COUNTIF(Assessment_only_2_Judges,\"C\")=2,\"Competent\",IF(COUNTIF(Assessment_only_2_Judges,\"C\")=1,\"Video Review Required\",\"Not Yet Competent\")),\"\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If 3 Judges - Result",{"$f":"IF(Number_of_Judges_on_Panel_Bronze=3,IF(COUNTIF(Assessment_3_Judges,\"C\")=3,\"Competent\",IF(COUNTIF(Assessment_3_Judges,\"C\")=2,\"Competent\",\"Not Yet Competent\")),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If 0 Judges on Panel",{"$f":"IF(Number_of_Judges_on_Panel_Bronze=0,\"Did Not Skate\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Result",{"$f":"IF(Result_if_only_2_Judges<>\"\",Result_if_only_2_Judges,IF(Result_if_3_Judges<>\"\",Result_if_3_Judges,IF(Result_if_0_Judges<>\"\",Result_if_0_Judges,\"\")))","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The macro will not allow the Application Form to be printed if either of these applies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If 1 Judge on Panel",{"$f":"IF(Number_of_Judges_on_Panel_Bronze=1,\"Require more Judges\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If only 2 Judges and Bronze Test",{"$f":"IF(AND(Number_of_Judges_on_Panel_Bronze=2,Two_Judges_Allowed=\"No\"),\"Three Judges are required for Bronze Tests\",\"\")","v":{"$error":"#NAME?"}}]

{"sheet":"Marking Sheet","index":2,"n_rows":224,"n_cols":17,"rows_kept":224,"cut":false,"hidden":false,"merged":[[221,8,221,14],[222,6,222,7],[222,8,222,14],[166,0,166,14],[206,4,207,14],[207,0,207,3],[201,8,201,14],[189,11,189,14],[221,0,221,5],[222,0,222,5],[209,6,209,7],[211,6,211,7],[212,6,212,7],[214,6,214,7],[218,6,218,7],[219,6,219,7],[220,6,220,7],[221,6,221,7],[218,0,218,5],[219,0,219,5],[220,0,220,5],[195,3,195,7],[196,0,196,14],[197,0,197,3],[16,3,16,9],[119,10,120,10],[92,0,92,14],[87,6,87,9],[31,0,31,14],[86,0,86,14],[87,0,87,2],[87,3,87,5],[47,0,47,14],[48,0,48,14],[49,0,49,14],[32,0,32,2],[32,3,32,5],[33,0,33,2],[33,3,33,5],[33,6,33,9],[33,11,33,14],[45,0,45,14],[42,0,42,14],[24,13,24,14],[26,13,26,14],[23,3,23,9],[59,0,59,1],[32,6,32,9],[190,3,190,7],[192,3,192,7],[193,3,193,7],[8,0,8,14],[9,13,10,14],[11,3,11,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[21,3,21,9],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,9],[9,11,9,12],[17,3,17,9],[12,3,12,9],[9,10,10,10],[13,3,13,9],[189,3,189,7],[190,11,190,14],[91,0,91,3],[14,3,14,9],[12,13,12,14],[199,0,200,7],[200,8,200,14],[191,11,191,14],[192,11,192,14],[193,11,193,14],[194,11,194,14],[209,0,209,5],[209,8,209,14],[202,8,202,14],[203,0,204,7],[203,8,203,14],[204,8,204,14],[208,0,208,14],[205,0,205,14],[206,0,206,3],[201,0,202,7],[191,3,191,7],[195,11,195,14],[194,3,194,7],[197,4,198,14],[198,0,198,3],[219,8,219,14],[220,8,220,14],[210,0,210,5],[210,6,210,7],[211,0,211,5],[212,0,212,5],[213,0,213,5],[210,8,210,14],[211,8,211,14],[212,8,212,14],[213,8,213,14],[213,6,213,7],[214,0,214,5],[215,0,215,5],[216,0,216,5],[215,6,215,7],[216,6,216,7],[217,6,217,7],[214,8,214,14],[215,8,215,14],[217,0,217,5],[216,8,216,14],[217,8,217,14],[218,8,218,14],[185,3,185,7],[186,3,186,7],[187,3,187,7],[188,3,188,7],[70,13,70,14],[71,3,71,9],[152,0,152,14],[153,0,153,14],[71,13,71,14],[72,3,72,9],[72,13,72,14],[82,13,82,14],[73,13,73,14],[74,3,74,9],[74,13,74,14],[75,3,75,9],[75,13,75,14],[76,3,76,9],[76,13,76,14],[77,3,77,9],[77,13,77,14],[73,3,73,9],[111,0,111,14],[90,0,90,3],[185,11,185,14],[186,11,186,14],[187,11,187,14],[188,11,188,14],[90,4,91,14],[167,0,167,14],[169,0,169,1],[169,2,169,5],[169,11,169,12],[169,13,169,14],[98,0,98,14],[99,0,99,14],[105,0,105,14],[112,0,112,14],[114,0,114,1],[114,2,114,5],[114,11,114,12],[114,13,114,14],[108,0,108,14],[115,0,115,1],[106,0,106,14],[107,0,107,14],[96,0,96,14],[116,0,116,1],[1,0,1,14],[2,0,2,14],[4,0,4,1],[4,11,4,12],[6,0,6,1],[6,2,6,6],[5,0,5,1],[5,11,5,12],[7,12,7,14],[4,13,4,14],[5,13,5,14],[4,2,4,5],[5,2,5,5],[7,1,7,2],[7,5,7,6],[7,7,7,9],[11,13,11,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[15,3,15,9],[62,1,62,2],[62,5,62,6],[62,7,62,9],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[27,3,27,9],[28,3,28,9],[29,3,29,9],[26,3,26,9],[30,3,30,9],[21,13,21,14],[27,13,27,14],[22,3,22,9],[22,13,22,14],[23,13,23,14],[25,13,25,14],[32,11,32,14],[59,2,59,5],[59,11,59,12],[59,13,59,14],[24,3,24,9],[25,3,25,9],[56,0,56,14],[57,0,57,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[37,0,37,14],[36,0,36,3],[35,4,36,14],[34,0,34,14],[35,0,35,3],[38,0,39,14],[40,0,40,14],[41,0,41,14],[46,0,46,14],[50,0,50,14],[51,0,51,14],[43,0,43,14],[44,0,44,14],[52,0,52,14],[60,11,60,12],[60,13,60,14],[89,0,89,14],[66,3,66,9],[66,13,66,14],[67,3,67,9],[67,13,67,14],[64,0,65,0],[64,1,65,1],[64,2,65,2],[64,3,65,9],[64,11,64,12],[64,13,65,14],[68,3,68,9],[68,13,68,14],[69,3,69,9],[69,13,69,14],[70,3,70,9],[87,11,87,14],[62,12,62,14],[63,0,63,14],[64,10,65,10],[61,0,61,1],[61,2,61,6],[118,0,118,14],[119,0,120,0],[119,1,120,1],[119,2,120,2],[119,3,120,9],[119,11,119,12],[119,13,120,14],[117,7,117,9],[117,5,117,6],[101,0,101,14],[102,0,102,14],[103,0,103,14],[104,0,104,14],[117,1,117,2],[115,2,115,5],[115,11,115,12],[115,13,115,14],[100,0,100,14],[116,2,116,6],[117,12,117,14],[121,3,121,9],[121,13,121,14],[122,3,122,9],[122,13,122,14],[123,3,123,9],[123,13,123,14],[124,3,124,9],[124,13,124,14],[125,3,125,9],[125,13,125,14],[126,3,126,9],[126,13,126,14],[127,3,127,9],[127,13,127,14],[128,3,128,9],[128,13,128,14],[129,3,129,9],[129,13,129,14],[130,3,130,9],[130,13,130,14],[131,3,131,9],[131,13,131,14],[132,3,132,9],[132,13,132,14],[133,3,133,9],[133,13,133,14],[134,3,134,9],[134,13,134,14],[135,3,135,9],[135,13,135,14],[136,3,136,9],[136,13,136,14],[137,3,137,9],[137,13,137,14],[138,3,138,9],[138,13,138,14],[139,3,139,9],[139,13,139,14],[140,3,140,9],[140,13,140,14],[141,0,141,14],[142,0,142,2],[142,3,142,5],[142,6,142,9],[142,11,142,14],[143,0,143,2],[143,3,143,5],[143,6,143,9],[143,11,143,14],[144,0,144,14],[145,0,145,3],[145,4,146,14],[146,0,146,3],[147,0,147,14],[163,0,163,14],[158,0,158,14],[159,0,159,14],[160,0,160,14],[161,0,161,14],[162,0,162,14],[155,0,155,14],[156,0,156,14],[157,0,157,14],[151,0,151,14],[154,0,154,14],[150,0,150,14],[148,0,149,14],[170,0,170,1],[170,2,170,5],[170,11,170,12],[170,13,170,14],[171,0,171,1],[171,2,171,6],[172,12,172,14],[173,0,173,14],[174,0,175,0],[174,1,175,1],[174,2,175,2],[174,3,175,7],[174,11,175,14],[172,1,172,2],[172,5,172,6],[172,7,172,9],[174,9,174,10],[174,8,175,8],[176,3,176,7],[177,3,177,7],[178,3,178,7],[179,3,179,7],[180,3,180,7],[182,11,182,14],[183,11,183,14],[184,11,184,14],[176,11,176,14],[177,11,177,14],[178,11,178,14],[179,11,179,14],[180,11,180,14],[181,11,181,14],[181,3,181,7],[182,3,182,7],[183,3,183,7],[184,3,184,7],[53,0,53,14],[97,0,97,14],[83,3,83,9],[83,13,83,14],[84,3,84,9],[84,13,84,14],[85,3,85,9],[85,13,85,14],[78,3,78,9],[78,13,78,14],[79,3,79,9],[79,13,79,14],[80,3,80,9],[80,13,80,14],[81,3,81,9],[81,13,81,14],[82,3,82,9],[88,0,88,2],[88,3,88,5],[88,6,88,9],[88,11,88,14],[93,0,94,14],[60,0,60,1],[60,2,60,5]]}
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0},null,null,null,null,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,null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
["TEST",{"$f":"Test_Discipline","v":""},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},{"$f":"Label_Routine_Time","v":"Time:"},null,{"$f":"Routine_Time","v":""},null,null,null,null,"Judge 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":""}]
["Item No","Code","Combo Jump Number","Jumps in combinations have background shading",null,null,null,null,null,null,"Start Time\nF/W","Attempts",null,"Marks"]
[null,null,null,null,null,null,null,null,null,null,null,1,2]
[1,{"$f":"+Code_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+Requirements_Selected_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},null,null,{"$f":"+COJ_1","v":0},{"$f":"Footwork_Time_01","v":0}]
[{"$f":"A12+1","v":2},{"$f":"+Code_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+Requirements_Selected_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},null,null,{"$f":"+COJ_2","v":0},{"$f":"Footwork_Time_02","v":0}]
[{"$f":"A13+1","v":3},{"$f":"+Code_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+Requirements_Selected_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},null,null,{"$f":"+COJ_3","v":0},{"$f":"Footwork_Time_03","v":0}]
[4,{"$f":"+Code_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+Requirements_Selected_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},null,null,{"$f":"+COJ_4","v":0},{"$f":"Footwork_Time_04","v":0}]
[5,{"$f":"+Code_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+Requirements_Selected_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},null,null,{"$f":"+COJ_5","v":0},{"$f":"Footwork_Time_05","v":0}]
[6,{"$f":"+Code_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+Requirements_Selected_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},null,null,{"$f":"+COJ_6","v":0},{"$f":"Footwork_Time_06","v":0}]
[7,{"$f":"+Code_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+Requirements_Selected_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},null,null,{"$f":"+COJ_7","v":0},{"$f":"Footwork_Time_07","v":0}]
[8,{"$f":"+Code_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+Requirements_Selected_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},null,null,{"$f":"+COJ_8","v":0},{"$f":"Footwork_Time_08","v":0}]
[9,{"$f":"+Code_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+Requirements_Selected_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},null,null,{"$f":"+COJ_9","v":0},{"$f":"Footwork_Time_09","v":0}]
[10,{"$f":"+Code_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+Requirements_Selected_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},null,null,{"$f":"+COJ_10","v":0},{"$f":"Footwork_Time_10","v":0}]
[11,{"$f":"+Code_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+Requirements_Selected_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},null,null,{"$f":"+COJ_11","v":0},{"$f":"Footwork_Time_11","v":0}]
[12,{"$f":"+Code_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+Requirements_Selected_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},null,null,{"$f":"+COJ_12","v":0},{"$f":"Footwork_Time_12","v":0}]
[13,{"$f":"+Code_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+Requirements_Selected_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},null,null,{"$f":"+COJ_13","v":0},{"$f":"Footwork_Time_13","v":0}]
[14,{"$f":"+Code_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+Requirements_Selected_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},null,null,{"$f":"+COJ_14","v":0},{"$f":"Footwork_Time_14","v":0}]
[15,{"$f":"+Code_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+Requirements_Selected_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},null,null,{"$f":"+COJ_15","v":0},{"$f":"Footwork_Time_15","v":0}]
[16,{"$f":"+Code_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+Requirements_Selected_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},null,null,{"$f":"+COJ_16","v":0},{"$f":"Footwork_Time_16","v":0}]
[17,{"$f":"+Code_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+Requirements_Selected_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},null,null,{"$f":"+COJ_17","v":0},{"$f":"Footwork_Time_17","v":0}]
[18,{"$f":"+Code_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+Requirements_Selected_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},null,null,{"$f":"+COJ_18","v":0},{"$f":"Footwork_Time_18","v":0}]
[19,{"$f":"+Code_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+Requirements_Selected_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},null,null,{"$f":"+COJ_19","v":0},{"$f":"Footwork_Time_19","v":0}]
[20,{"$f":"+Code_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+Requirements_Selected_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},null,null,{"$f":"+COJ_20","v":0},{"$f":"Footwork_Time_20","v":0}]
["COMPONENTS"]
["SKATING SKILLS",null,null,"TRANSITIONS",null,null,"PERFORMANCE",null,null,null,null,"CHOREOGRAPHY"]
[]
["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,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
["JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"]
["COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0},null,null,null,null,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,null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
["TEST",{"$f":"Test_Discipline","v":""},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},{"$f":"Label_Routine_Time","v":"Time:"},null,{"$f":"Routine_Time","v":""},null,null,null,null,"Judge 2"]
[{"$f":"IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\")","v":""}]
["Item No","Code","Combo Jump Number","Jumps in combinations have background shading",null,null,null,null,null,null,"Start Time\nF/W","Attempts",null,"Marks"]
[null,null,null,null,null,null,null,null,null,null,null,1,2]
[1,{"$f":"+Code_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+Requirements_Selected_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},null,null,{"$f":"+COJ_1","v":0},{"$f":"Footwork_Time_01","v":0}]
[{"$f":"A67+1","v":2},{"$f":"+Code_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+Requirements_Selected_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},null,null,{"$f":"+COJ_2","v":0},{"$f":"Footwork_Time_02","v":0}]
[{"$f":"A68+1","v":3},{"$f":"+Code_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+Requirements_Selected_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},null,null,{"$f":"+COJ_3","v":0},{"$f":"Footwork_Time_03","v":0}]
[4,{"$f":"+Code_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+Requirements_Selected_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},null,null,{"$f":"+COJ_4","v":0},{"$f":"Footwork_Time_04","v":0}]
[5,{"$f":"+Code_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+Requirements_Selected_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},null,null,{"$f":"+COJ_5","v":0},{"$f":"Footwork_Time_05","v":0}]
[6,{"$f":"+Code_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+Requirements_Selected_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},null,null,{"$f":"+COJ_6","v":0},{"$f":"Footwork_Time_06","v":0}]
[7,{"$f":"+Code_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+Requirements_Selected_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},null,null,{"$f":"+COJ_7","v":0},{"$f":"Footwork_Time_07","v":0}]
[8,{"$f":"+Code_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+Requirements_Selected_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},null,null,{"$f":"+COJ_8","v":0},{"$f":"Footwork_Time_08","v":0}]
[9,{"$f":"+Code_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+Requirements_Selected_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},null,null,{"$f":"+COJ_9","v":0},{"$f":"Footwork_Time_09","v":0}]
[10,{"$f":"+Code_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+Requirements_Selected_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},null,null,{"$f":"+COJ_10","v":0},{"$f":"Footwork_Time_10","v":0}]
[11,{"$f":"+Code_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+Requirements_Selected_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},null,null,{"$f":"+COJ_11","v":0},{"$f":"Footwork_Time_11","v":0}]
[12,{"$f":"+Code_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+Requirements_Selected_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},null,null,{"$f":"+COJ_12","v":0},{"$f":"Footwork_Time_12","v":0}]
[13,{"$f":"+Code_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+Requirements_Selected_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},null,null,{"$f":"+COJ_13","v":0},{"$f":"Footwork_Time_13","v":0}]
[14,{"$f":"+Code_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+Requirements_Selected_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},null,null,{"$f":"+COJ_14","v":0},{"$f":"Footwork_Time_14","v":0}]
[15,{"$f":"+Code_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+Requirements_Selected_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},null,null,{"$f":"+COJ_15","v":0},{"$f":"Footwork_Time_15","v":0}]
[16,{"$f":"+Code_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+Requirements_Selected_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},null,null,{"$f":"+COJ_16","v":0},{"$f":"Footwork_Time_16","v":0}]
[17,{"$f":"+Code_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+Requirements_Selected_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},null,null,{"$f":"+COJ_17","v":0},{"$f":"Footwork_Time_17","v":0}]
[18,{"$f":"+Code_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+Requirements_Selected_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},null,null,{"$f":"+COJ_18","v":0},{"$f":"Footwork_Time_18","v":0}]
[19,{"$f":"+Code_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+Requirements_Selected_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},null,null,{"$f":"+COJ_19","v":0},{"$f":"Footwork_Time_19","v":0}]
[20,{"$f":"+Code_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+Requirements_Selected_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},null,null,{"$f":"+COJ_20","v":0},{"$f":"Footwork_Time_20","v":0}]
["COMPONENTS"]
["SKATING SKILLS",null,null,"TRANSITIONS",null,null,"PERFORMANCE",null,null,null,null,"CHOREOGRAPHY"]
[]
["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,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
["JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"]
["COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0},null,null,null,null,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,null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
["TEST",{"$f":"Test_Discipline","v":""},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},{"$f":"Label_Routine_Time","v":"Time:"},null,{"$f":"Routine_Time","v":""},null,null,null,null,"Judge 3"]
[{"$f":"IF(Previous_Test_Date=Test_Date,\"This is a Skate Up.  Check the result of the previous Test before proceeding.\",\"\")","v":""}]
["Item No","Code","Combo Jump Number","Jumps in combinations have background shading",null,null,null,null,null,null,"Start Time\nF/W","Attempts",null,"Marks"]
[null,null,null,null,null,null,null,null,null,null,null,1,2]
[1,{"$f":"+Code_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+Requirements_Selected_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},null,null,{"$f":"+COJ_1","v":0},{"$f":"Footwork_Time_01","v":0}]
[{"$f":"A122+1","v":2},{"$f":"+Code_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+Requirements_Selected_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},null,null,{"$f":"+COJ_2","v":0},{"$f":"Footwork_Time_02","v":0}]
[{"$f":"A123+1","v":3},{"$f":"+Code_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+Requirements_Selected_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},null,null,{"$f":"+COJ_3","v":0},{"$f":"Footwork_Time_03","v":0}]
[4,{"$f":"+Code_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+Requirements_Selected_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},null,null,{"$f":"+COJ_4","v":0},{"$f":"Footwork_Time_04","v":0}]
[5,{"$f":"+Code_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+Requirements_Selected_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},null,null,{"$f":"+COJ_5","v":0},{"$f":"Footwork_Time_05","v":0}]
[6,{"$f":"+Code_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+Requirements_Selected_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},null,null,{"$f":"+COJ_6","v":0},{"$f":"Footwork_Time_06","v":0}]
[7,{"$f":"+Code_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+Requirements_Selected_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},null,null,{"$f":"+COJ_7","v":0},{"$f":"Footwork_Time_07","v":0}]
[8,{"$f":"+Code_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+Requirements_Selected_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},null,null,{"$f":"+COJ_8","v":0},{"$f":"Footwork_Time_08","v":0}]
[9,{"$f":"+Code_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+Requirements_Selected_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},null,null,{"$f":"+COJ_9","v":0},{"$f":"Footwork_Time_09","v":0}]
[10,{"$f":"+Code_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+Requirements_Selected_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},null,null,{"$f":"+COJ_10","v":0},{"$f":"Footwork_Time_10","v":0}]
[11,{"$f":"+Code_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+Requirements_Selected_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},null,null,{"$f":"+COJ_11","v":0},{"$f":"Footwork_Time_11","v":0}]
[12,{"$f":"+Code_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+Requirements_Selected_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},null,null,{"$f":"+COJ_12","v":0},{"$f":"Footwork_Time_12","v":0}]
[13,{"$f":"+Code_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+Requirements_Selected_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},null,null,{"$f":"+COJ_13","v":0},{"$f":"Footwork_Time_13","v":0}]
[14,{"$f":"+Code_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+Requirements_Selected_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},null,null,{"$f":"+COJ_14","v":0},{"$f":"Footwork_Time_14","v":0}]
[15,{"$f":"+Code_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+Requirements_Selected_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},null,null,{"$f":"+COJ_15","v":0},{"$f":"Footwork_Time_15","v":0}]
[16,{"$f":"+Code_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+Requirements_Selected_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},null,null,{"$f":"+COJ_16","v":0},{"$f":"Footwork_Time_16","v":0}]
[17,{"$f":"+Code_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+Requirements_Selected_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},null,null,{"$f":"+COJ_17","v":0},{"$f":"Footwork_Time_17","v":0}]
[18,{"$f":"+Code_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+Requirements_Selected_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},null,null,{"$f":"+COJ_18","v":0},{"$f":"Footwork_Time_18","v":0}]
[19,{"$f":"+Code_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+Requirements_Selected_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},null,null,{"$f":"+COJ_19","v":0},{"$f":"Footwork_Time_19","v":0}]
[20,{"$f":"+Code_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+Requirements_Selected_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},null,null,{"$f":"+COJ_20","v":0},{"$f":"Footwork_Time_20","v":0}]
["COMPONENTS"]
["SKATING SKILLS",null,null,"TRANSITIONS",null,null,"PERFORMANCE",null,null,null,null,"CHOREOGRAPHY"]
[]
["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,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
["JUDGES - PLEASE ADD COMMENTS TO ASSIST COACHES AND SKATERS"]
["COMMENTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Original to be sent to CAOC Chair"]
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["MARKING SHEET"]
[]
[{"$f":"Label_Name","v":"NAME:"},null,{"$f":"Skater_Name","v":0},null,null,null,null,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,null,null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},null,{"$f":"Test_Date","v":"00:00:00"}]
[null,null,"(for Dance/Freedance/Freeskating Pairs only)"]
["TEST",{"$f":"Test_Discipline","v":""},null,{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},{"$f":"Label_Routine_Time","v":"Time:"},null,{"$f":"Routine_Time","v":""},null,null,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":""}]
["Item No","Code","Combo Jump Number","Jumps in combinations have background shading",null,null,null,null,"Start Time\nF/W","Attempts",null,"Comments"]
[null,null,null,null,null,null,null,null,null,1,"2"]
[1,{"$f":"+Code_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+Requirements_Selected_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"+COJ_1","v":0},{"$f":"Footwork_Time_01","v":0}]
[{"$f":"A177+1","v":2},{"$f":"+Code_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+Requirements_Selected_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"+COJ_2","v":0},{"$f":"Footwork_Time_02","v":0}]
[{"$f":"A178+1","v":3},{"$f":"+Code_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+Requirements_Selected_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"+COJ_3","v":0},{"$f":"Footwork_Time_03","v":0}]
[4,{"$f":"+Code_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+Requirements_Selected_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"+COJ_4","v":0},{"$f":"Footwork_Time_04","v":0}]
[5,{"$f":"+Code_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+Requirements_Selected_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"+COJ_5","v":0},{"$f":"Footwork_Time_05","v":0}]
[6,{"$f":"+Code_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+Requirements_Selected_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"+COJ_6","v":0},{"$f":"Footwork_Time_06","v":0}]
[7,{"$f":"+Code_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+Requirements_Selected_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"+COJ_7","v":0},{"$f":"Footwork_Time_07","v":0}]
[8,{"$f":"+Code_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+Requirements_Selected_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"+COJ_8","v":0},{"$f":"Footwork_Time_08","v":0}]
[9,{"$f":"+Code_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+Requirements_Selected_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"+COJ_9","v":0},{"$f":"Footwork_Time_09","v":0}]
[10,{"$f":"+Code_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+Requirements_Selected_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"+COJ_10","v":0},{"$f":"Footwork_Time_10","v":0}]
[11,{"$f":"+Code_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+Requirements_Selected_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"+COJ_11","v":0},{"$f":"Footwork_Time_11","v":0}]
[12,{"$f":"+Code_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+Requirements_Selected_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"+COJ_12","v":0},{"$f":"Footwork_Time_12","v":0}]
[13,{"$f":"+Code_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+Requirements_Selected_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"+COJ_13","v":0},{"$f":"Footwork_Time_13","v":0}]
[14,{"$f":"+Code_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+Requirements_Selected_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"+COJ_14","v":0},{"$f":"Footwork_Time_14","v":0}]
[15,{"$f":"+Code_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+Requirements_Selected_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"+COJ_15","v":0},{"$f":"Footwork_Time_15","v":0}]
[16,{"$f":"+Code_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+Requirements_Selected_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"+COJ_16","v":0},{"$f":"Footwork_Time_16","v":0}]
[17,{"$f":"+Code_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+Requirements_Selected_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"+COJ_17","v":0},{"$f":"Footwork_Time_17","v":0}]
[18,{"$f":"+Code_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+Requirements_Selected_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"+COJ_18","v":0},{"$f":"Footwork_Time_18","v":0}]
[19,{"$f":"+Code_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+Requirements_Selected_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"+COJ_19","v":0},{"$f":"Footwork_Time_19","v":0}]
[20,{"$f":"+Code_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+Requirements_Selected_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"+COJ_20","v":0},{"$f":"Footwork_Time_20","v":0}]
["REFEREE TO SIGN ON COMPLETION OF THE TEST"]
["Judge - Print Name & Sign"]
[{"$f":"Name_Referee","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
["This form MUST BE SIGNED BY THE SKATER regardless of age,\nand 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?"]
[]
["Before submitting this form to the Test Supervisor, for skaters under 18 years of age,\nit MUST ALSO BE SIGNED BY THE COACH, PARENT or GUARDIAN"]
[null,null,null,null,null,null,null,null,"Coach, Parent or Guardian Signature"]
["CONTENTS CHECKED BY REFEREE"]
["Referee - Print Name & Sign"]
[{"$f":"Name_Referee","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Name_Judge_1=\"\",\"\",Name_Judge_1)","v":""}]
[{"$f":"Requirements_Heading","v":""}]
[{"$f":"Requirements_1","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_1","v":""},null,{"$f":"Requirements_13","v":""}]
[{"$f":"Requirements_2","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_2","v":""},null,{"$f":"Requirements_14","v":""}]
[{"$f":"Requirements_3","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_3","v":""},null,{"$f":"Requirements_15","v":""}]
[{"$f":"Requirements_4","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_4","v":""},null,{"$f":"Requirements_16","v":""}]
[{"$f":"Requirements_5","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_5","v":""},null,{"$f":"Requirements_17","v":""}]
[{"$f":"Requirements_6","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_6","v":""},null,{"$f":"Requirements_18","v":""}]
[{"$f":"Requirements_7","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_7","v":""},null,{"$f":"Requirements_19","v":""}]
[{"$f":"Requirements_8","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_8","v":""}]
[{"$f":"Requirements_9","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_9","v":""}]
[{"$f":"Requirements_10","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_10","v":""}]
[{"$f":"Requirements_11","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_11","v":""}]
[{"$f":"Requirements_12","v":""},null,null,null,null,null,{"$f":"Mandatory_Requirements_12","v":""}]
[]
[]
["Original to be sent to CAOC Chair"]

{"sheet":"Application Form","index":3,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[16,1,16,6],[36,3,36,6],[35,3,35,6],[17,1,17,6],[18,1,18,6],[24,1,24,6],[25,1,25,6],[35,0,35,2],[32,1,32,6],[33,1,33,6],[34,1,34,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[16,13,16,14],[17,13,18,14],[19,13,20,14],[21,13,22,14],[24,13,24,14],[43,7,44,9],[41,3,41,6],[38,13,38,17],[36,0,41,2],[42,0,42,6],[43,0,44,2],[43,3,44,6],[31,13,31,17],[33,13,33,17],[17,12,18,12],[25,13,26,14],[36,13,36,17],[19,12,20,12],[21,12,22,12],[25,12,26,12],[1,0,1,9],[2,0,2,9],[6,8,6,9],[13,7,13,9],[10,8,10,9],[13,0,14,0],[13,1,14,6],[7,8,7,9],[10,5,10,7],[11,5,12,7],[11,8,12,9],[8,5,9,5],[6,1,6,3],[7,1,7,3],[8,1,8,3],[10,1,10,3],[8,6,9,6],[8,7,9,7],[8,8,9,9],[40,3,40,6],[39,3,39,6],[15,1,15,6],[19,1,19,6],[20,1,20,6],[12,1,12,3],[21,1,21,6],[22,1,22,6],[23,1,23,6],[11,1,11,3],[37,3,37,6],[38,3,38,6],[26,1,26,6]]}
[]
["SKATE AUSTRALIA PROFICIENCY TEST"]
["APPLICATION FORM"]
[]
[]
["(HIDE)"]
[{"$f":"Label_Name","v":"NAME:"},{"$f":"Skater_Name","v":0}]
[{"$f":"Label_Club","v":"CLUB:"},{"$f":"Club","v":0},null,null,null,null,null,{"$f":"Label_SA_No","v":"SA NO:"},{"$f":"SA_Number","v":0}]
[{"$f":"Label_Test_Centre","v":"TEST CENTRE:"},{"$f":"Test_Centre","v":0},null,null,null,{"$f":"Label_Test_Date","v":"TEST DATE:"},{"$f":"Test_Date","v":"00:00:00"},"FEE:",{"$f":"Fee_Paid","v":0}]
[]
["TEST:",{"$f":"Test_Discipline","v":""},null,null,null,"DATE OF PREVIOUS TEST:",null,null,{"$f":"Previous_Test_Date","v":"."}]
[{"$f":"Label_Test_No","v":"TEST NO:"},{"$f":"Test_Number","v":""},null,null,null,"SIGNED:",null,null,{"$f":"Name_of_Person_Authorising","v":0}]
["AWARD:",{"$f":"Award","v":""}]
["Code","Element",null,null,null,null,null,"Judges' Assessments"]
[]
[{"$f":"Code_1","v":0},{"$f":"Requirements_Selected_1","v":0},{"$f":"Code_1","v":0},{"$f":"Code_1","v":0},{"$f":"Code_1","v":0},{"$f":"Code_1","v":0},{"$f":"Code_1","v":0}]
[{"$f":"Code_2","v":0},{"$f":"Requirements_Selected_2","v":0},{"$f":"Code_2","v":0},{"$f":"Code_2","v":0},{"$f":"Code_2","v":0},{"$f":"Code_2","v":0},{"$f":"Code_2","v":0},null,null,null,null,null,null,"Judges"]
[{"$f":"Code_3","v":0},{"$f":"Requirements_Selected_3","v":0},{"$f":"Code_3","v":0},{"$f":"Code_3","v":0},{"$f":"Code_3","v":0},{"$f":"Code_3","v":0},{"$f":"Code_3","v":0},null,null,null,null,null,1]
[{"$f":"Code_4","v":0},{"$f":"Requirements_Selected_4","v":0},{"$f":"Code_4","v":0},{"$f":"Code_4","v":0},{"$f":"Code_4","v":0},{"$f":"Code_4","v":0},{"$f":"Code_4","v":0}]
[{"$f":"Code_5","v":0},{"$f":"Requirements_Selected_5","v":0},{"$f":"Code_5","v":0},{"$f":"Code_5","v":0},{"$f":"Code_5","v":0},{"$f":"Code_5","v":0},{"$f":"Code_5","v":0},null,null,null,null,null,2]
[{"$f":"Code_6","v":0},{"$f":"Requirements_Selected_6","v":0},{"$f":"Code_6","v":0},{"$f":"Code_6","v":0},{"$f":"Code_6","v":0},{"$f":"Code_6","v":0},{"$f":"Code_6","v":0}]
[{"$f":"Code_7","v":0},{"$f":"Requirements_Selected_7","v":0},{"$f":"Code_7","v":0},{"$f":"Code_7","v":0},{"$f":"Code_7","v":0},{"$f":"Code_7","v":0},{"$f":"Code_7","v":0},null,null,null,null,null,3]
[{"$f":"Code_8","v":0},{"$f":"Requirements_Selected_8","v":0},{"$f":"Code_8","v":0},{"$f":"Code_8","v":0},{"$f":"Code_8","v":0},{"$f":"Code_8","v":0},{"$f":"Code_8","v":0}]
[{"$f":"Code_9","v":0},{"$f":"Requirements_Selected_9","v":0},{"$f":"Code_9","v":0},{"$f":"Code_9","v":0},{"$f":"Code_9","v":0},{"$f":"Code_9","v":0},{"$f":"Code_9","v":0}]
[{"$f":"Code_10","v":0},{"$f":"Requirements_Selected_10","v":0},{"$f":"Code_10","v":0},{"$f":"Code_10","v":0},{"$f":"Code_10","v":0},{"$f":"Code_10","v":0},{"$f":"Code_10","v":0},null,null,null,null,null,null,"Referee"]
[{"$f":"Code_11","v":0},{"$f":"Requirements_Selected_11","v":0},{"$f":"Code_11","v":0},{"$f":"Code_11","v":0},{"$f":"Code_11","v":0},{"$f":"Code_11","v":0},{"$f":"Code_11","v":0}]
[{"$f":"Code_12","v":0},{"$f":"Requirements_Selected_12","v":0},{"$f":"Code_12","v":0},{"$f":"Code_12","v":0},{"$f":"Code_12","v":0},{"$f":"Code_12","v":0},{"$f":"Code_12","v":0}]
[{"$f":"Code_13","v":0},{"$f":"Requirements_Selected_13","v":0},{"$f":"Code_13","v":0},{"$f":"Code_13","v":0},{"$f":"Code_13","v":0},{"$f":"Code_13","v":0},{"$f":"Code_13","v":0}]
[{"$f":"Code_14","v":0},{"$f":"Requirements_Selected_14","v":0},{"$f":"Code_14","v":0},{"$f":"Code_14","v":0},{"$f":"Code_14","v":0},{"$f":"Code_14","v":0},{"$f":"Code_14","v":0}]
[{"$f":"Code_15","v":0},{"$f":"Requirements_Selected_15","v":0},{"$f":"Code_15","v":0},{"$f":"Code_15","v":0},{"$f":"Code_15","v":0},{"$f":"Code_15","v":0},{"$f":"Code_15","v":0}]
[{"$f":"Code_16","v":0},{"$f":"Requirements_Selected_16","v":0},{"$f":"Code_16","v":0},{"$f":"Code_16","v":0},{"$f":"Code_16","v":0},{"$f":"Code_16","v":0},{"$f":"Code_16","v":0}]
[{"$f":"Code_17","v":0},{"$f":"Requirements_Selected_17","v":0},{"$f":"Code_17","v":0},{"$f":"Code_17","v":0},{"$f":"Code_17","v":0},{"$f":"Code_17","v":0},{"$f":"Code_17","v":0}]
[{"$f":"Code_18","v":0},{"$f":"Requirements_Selected_18","v":0},{"$f":"Code_18","v":0},{"$f":"Code_18","v":0},{"$f":"Code_18","v":0},{"$f":"Code_18","v":0},{"$f":"Code_18","v":0}]
[{"$f":"Code_19","v":0},{"$f":"Requirements_Selected_19","v":0},{"$f":"Code_19","v":0},{"$f":"Code_19","v":0},{"$f":"Code_19","v":0},{"$f":"Code_19","v":0},{"$f":"Code_19","v":0}]
[{"$f":"Code_20","v":0},{"$f":"Requirements_Selected_20","v":0},{"$f":"Code_20","v":0},{"$f":"Code_20","v":0},{"$f":"Code_20","v":0},{"$f":"Code_20","v":0},{"$f":"Code_20","v":0}]
["C = Competent\nNYC = Not Yet Competent",null,null,"TECHNICAL ASSESSMENT",null,null,null,{"$f":"Technical_Assessment_J1","v":""},{"$f":"Technical_Assessment_J2","v":""},{"$f":"Technical_Assessment_J3","v":""}]
["COMPONENTS",null,null,"Skating Skills"]
[null,null,null,"Transitions"]
[null,null,null,"Performance"]
[null,null,null,"Choreography"]
[null,null,null,"TOTAL COMPONENTS",null,null,null,{"$f":"SUM(H37:H40)","v":0},{"$f":"SUM(I37:I40)","v":0},{"$f":"SUM(J37:J40)","v":0}]
[null,null,null,"COMPONENT ASSESSMENT",null,null,null,{"$f":"Components_Assessment_J1","v":""},{"$f":"Components_Assessment_J2","v":""},{"$f":"Components_Assessment_J3","v":""}]
["JUDGES' OVERALL ASSESSMENTS",null,null,null,null,null,null,{"$f":"IF(OR(Technical_Result_J1=\"\",Components_Result_J1=\"\"),\"\",IF(AND(Technical_Result_J1=\"C\",Components_Result_J1=\"C\"),\"C\",\"NYC\"))","v":""},{"$f":"IF(OR(Technical_Result_J2=\"\",Components_Result_J2=\"\"),\"\",IF(AND(Technical_Result_J2=\"C\",Components_Result_J2=\"C\"),\"C\",\"NYC\"))","v":""},{"$f":"IF(OR(Technical_Result_J3=\"\",Components_Result_J3=\"\"),\"\",IF(AND(Technical_Result_J3=\"C\",Components_Result_J3=\"C\"),\"C\",\"NYC\"))","v":""}]
["Referee's Signature",null,null,null,null,null,null,{"$f":"+Overall_Result_Calculated","v":""}]

{"sheet":"Test Details","index":4,"n_rows":328,"n_cols":26,"rows_kept":328,"cut":false,"hidden":true,"merged":[]}
["Test #",null,"Item #","Full Item - D:U - 1","D:W - 2","Item Description  D:W - 3","D:W - 4","D:W - 5","D:W - 6","D:W - 7","D:W - 8","D:W - 9","D:W - 10","D:W - 11","D:W - 12","D:W - 13","D:W - 14","D:W - 15","D:W - 16","D:W - 17","D:W - 18","Minimum Mark  D:W - 19","Passing Grade  D:W - 20","Routine Time  D:W - 21","Award  D:W - 22","Award  D:W - 23"]
["Free Skating",null,null,null,null,null,null,null,"Total No. Jumps Required\n(Test 4 up exclude connecting jumps)","No. Jumps Required for WOMEN\n(Test 4 up excl connecting jumps)","No. Jumps Required for MEN\n(Test 4 up excl connecting jumps)","No. Combo Jumps Required","No. Jumps allowed Combo 1","No. Jumps allowed Combo 2","No. Solo Spins Required","No. Combo Spins Required","No. Spin elements required","Footwork sequence required","Choreo sequence required","Minimum Components","Minimum Individual Component"]
["FS01",{"$f":"$A$2&A3","v":"Free SkatingFS01"},"1.",{"$f":"B3&C3","v":"Free SkatingFS011."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,11,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","1st Bronze Bar","Bronze"]
["FS02",{"$f":"$A$2&A4","v":"Free SkatingFS02"},"1.","Free SkatingFS021.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,12,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","2nd Bronze Bar","Bronze"]
["FS03","Free SkatingFS03","1.","Free SkatingFS031.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,13,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","Bronze Medal","Bronze"]
["FS04","Free SkatingFS04","1.","Free SkatingFS041.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","1st Silver Bar","Silver"]
["FS05","Free SkatingFS05","1.","Free SkatingFS051.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","2nd Silver Bar","Silver"]
["FS06","Free SkatingFS06","1.","Free SkatingFS061.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","Silver Medal","Silver"]
["FS07","Free SkatingFS07","1.",{"$f":"B9&C9","v":"Free SkatingFS071."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,15,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","Gold Bar","Gold"]
["FS08","Free SkatingFS08","1.",{"$f":"B10&C10","v":"Free SkatingFS081."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,15,"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)","Gold Medal","Gold"]
[]
["Free Skating Requirements"]
["Test #",null,"Item #","Full Item",null,{"$f":"+F$1","v":"Item Description  D:W - 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Award"]
[1,{"$f":"$A$12&A14","v":"Free Skating Requirements1"},"A.",{"$f":"+B$3&C14","v":"Free SkatingFS01A."},{"$f":"$B14&$C14","v":"Free Skating Requirements1A."}," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 1",null,null,8,null,null,2,2,2,1,1,null,1,null,2,0,null,null,{"$f":"+Routine_Time_FS01","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"1st Bronze Bar"]
[1,"Free Skating Requirements1","1.","Free SkatingFS011.","Free Skating Requirements11."]
[1,"Free Skating Requirements1","2.","Free SkatingFS012.","Free Skating Requirements12."," JUMPS"]
[1,"Free Skating Requirements1","3.","Free SkatingFS013.","Free Skating Requirements13."," ♦  Total 8 jumps of 1 rotation (incl jumps in combos). Waltz Jump allowed."]
[1,"Free Skating Requirements1","4.","Free SkatingFS014.","Free Skating Requirements14."," ♦  2 jump combinations (max. 2 jumps each)."]
[1,"Free Skating Requirements1","5.","Free SkatingFS015.","Free Skating Requirements15."," ♦  Each Jump cannot be presented more than 3 times."]
[1,"Free Skating Requirements1","6.","Free SkatingFS016.","Free Skating Requirements16."]
[1,"Free Skating Requirements1","7.","Free SkatingFS017.","Free Skating Requirements17."," SPINS"]
[1,"Free Skating Requirements1","8.","Free SkatingFS018.","Free Skating Requirements18."," ♦  1 Solo Spin."]
[1,"Free Skating Requirements1","9.","Free SkatingFS019.","Free Skating Requirements19."," ♦  1 Combo Spin (max. 2 positions)."]
[1,"Free Skating Requirements1","10.","Free SkatingFS0110.","Free Skating Requirements110."," ♦  ONLY upright positions are allowed."]
[1,"Free Skating Requirements1","11.","Free SkatingFS0111.","Free Skating Requirements111."," ♦  The upright used in the Solo Spin may be repeated."]
[1,"Free Skating Requirements1","12.","Free SkatingFS0112.","Free Skating Requirements112."," ♦  The other must be different."]
[1,{"$f":"$A$12&A27","v":"Free Skating Requirements1"},"13.","Free SkatingFS0113.","Free Skating Requirements113."]
[1,"Free Skating Requirements1","14.","Free SkatingFS0114.","Free Skating Requirements114."," FOOTWORK"]
[1,"Free Skating Requirements1","15.","Free SkatingFS0115.","Free Skating Requirements115."," ♦  1 footwork seq, max Level 1, max 30 secs."]
[1,"Free Skating Requirements1","16.","Free SkatingFS0116.","Free Skating Requirements116.","    ♦  7 step option - turns counted: Inside 3 Turn,"]
[1,"Free Skating Requirements1","17.","Free SkatingFS0117.","Free Skating Requirements117.","       Outside 3 Turn, Cross in Front, Open Mohawk,"]
[1,"Free Skating Requirements1","18.","Free SkatingFS0118.","Free Skating Requirements118.","       Travel, Closed Mohawk (forward to back),"]
[1,"Free Skating Requirements1","19.","Free SkatingFS0119.","Free Skating Requirements119.","       Choctaw (forward to back)"]
[1,"Free Skating Requirements1","20.","Free SkatingFS0120.","Free Skating Requirements120.","    ♦  No features reqd - each type can be used twice."]
[2,"Free Skating Requirements2","A.",{"$f":"+B$4&C35","v":"Free SkatingFS02A."},"Free Skating Requirements2A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 2",null,null,12,null,null,2,4,3,1,1,null,1,null,4,0.5,null,null,{"$f":"+Routine_Time_FS02","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"2nd Bronze Bar"]
[2,"Free Skating Requirements2","1.",{"$f":"+B$4&C36","v":"Free SkatingFS021."},"Free Skating Requirements21."]
[2,"Free Skating Requirements2","2.","Free SkatingFS022.","Free Skating Requirements22."," JUMPS"]
[2,"Free Skating Requirements2","3.","Free SkatingFS023.","Free Skating Requirements23."," ♦  Total 12 jumps of 1 rotation (incl jumps in combos). Waltz Jump allowed."]
[2,"Free Skating Requirements2","4.","Free SkatingFS024.","Free Skating Requirements24."," ♦  2 jump combinations - 1 max. 4 jumps, 1 max. 3 jumps."]
[2,"Free Skating Requirements2","5.","Free SkatingFS025.","Free Skating Requirements25."," ♦  Each Jump cannot be presented more than 3 times."]
[2,"Free Skating Requirements2","6.","Free SkatingFS026.","Free Skating Requirements26."]
[2,"Free Skating Requirements2","7.","Free SkatingFS027.","Free Skating Requirements27."," SPINS"]
[2,"Free Skating Requirements2","8.","Free SkatingFS028.","Free Skating Requirements28."," ♦ 1 Solo Spin."]
[2,"Free Skating Requirements2","9.","Free SkatingFS029.","Free Skating Requirements29."," ♦ 1 Combo Spin (maximum 4 positions)."]
[2,"Free Skating Requirements2","10.","Free SkatingFS0210.","Free Skating Requirements210."," ♦ ONLY upright and sit positions are allowed."]
[2,"Free Skating Requirements2","11.","Free SkatingFS0211.","Free Skating Requirements211."]
[2,"Free Skating Requirements2","12.","Free SkatingFS0212.","Free Skating Requirements212."]
[2,{"$f":"$A$12&A48","v":"Free Skating Requirements2"},"13.","Free SkatingFS0213.","Free Skating Requirements213."]
[2,"Free Skating Requirements2","14.","Free SkatingFS0214.","Free Skating Requirements214."," FOOTWORK"]
[2,"Free Skating Requirements2","15.","Free SkatingFS0215.","Free Skating Requirements215."," ♦  1 footwork seq, max Level 1, max 30 secs."]
[2,"Free Skating Requirements2","16.","Free SkatingFS0216.","Free Skating Requirements216.","    ♦  5 step option - turns counted: Inside 3 Turn,"]
[2,"Free Skating Requirements2","17.","Free SkatingFS0217.","Free Skating Requirements217.","        Outside 3 Turn, Cross in Front,"]
[2,"Free Skating Requirements2","18.","Free SkatingFS0218.","Free Skating Requirements218.","        Open Mohawk (forward to back), Travel (one"]
[2,"Free Skating Requirements2","19.","Free SkatingFS0219.","Free Skating Requirements219.","       clockwise and one anti-clockwise allowed)."]
[2,"Free Skating Requirements2","20.","Free SkatingFS0220.","Free Skating Requirements220.","    ♦  No features required."]
[3,"Free Skating Requirements3","A.",{"$f":"+B$5&C56","v":"Free SkatingFS03A."},"Free Skating Requirements3A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 3",null,null,12,null,null,2,5,5,null,1,2,1,null,5,0.75,null,null,{"$f":"+Routine_Time_FS03","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"Bronze Medal"]
[3,"Free Skating Requirements3","1.",{"$f":"+B$5&C57","v":"Free SkatingFS031."},"Free Skating Requirements31."]
[3,"Free Skating Requirements3","2.","Free SkatingFS032.","Free Skating Requirements32."," JUMPS"]
[3,"Free Skating Requirements3","3.","Free SkatingFS033.","Free Skating Requirements33."," ♦ Total 12 jumps of 1 rotation (incl jumps in combos).  Axel,","Axel attempt"]
[3,"Free Skating Requirements3","4.","Free SkatingFS034.","Free Skating Requirements34.","     Double Toe Loop and Double Salchow are allowed.","is mandatory"]
[3,"Free Skating Requirements3","5.","Free SkatingFS035.","Free Skating Requirements35."," ♦ 2 jump combinations (up to 5 jumps each)."]
[3,{"$f":"$A$12&A62","v":"Free Skating Requirements3"},"6.","Free SkatingFS036.","Free Skating Requirements36."," ♦  Axel, single and doubles no more than twice."]
[3,"Free Skating Requirements3","7.","Free SkatingFS037.","Free Skating Requirements37."]
[3,"Free Skating Requirements3","8.","Free SkatingFS038.","Free Skating Requirements38."," SPINS"]
[3,"Free Skating Requirements3","9.","Free SkatingFS039.","Free Skating Requirements39."," ♦ 2 Spin Elements:"]
[3,"Free Skating Requirements3","10.","Free SkatingFS0310.","Free Skating Requirements310.","    ♦  1 must be a Combo and must include a sit spin (max 4 positions)."]
[3,"Free Skating Requirements3","11.","Free SkatingFS0311.","Free Skating Requirements311."," ♦ ONLY upright and sit positions are allowed."]
[3,"Free Skating Requirements3","12.","Free SkatingFS0312.","Free Skating Requirements312."," ♦ Each type of spin must be different."]
[3,{"$f":"$A$12&A69","v":"Free Skating Requirements3"},"13.","Free SkatingFS0313.","Free Skating Requirements313."]
[3,"Free Skating Requirements3","14.","Free SkatingFS0314.","Free Skating Requirements314."," FOOTWORK"]
[3,"Free Skating Requirements3","15.","Free SkatingFS0315.","Free Skating Requirements315."," ♦ 1 footwork sequence, max. Level 2."]
[3,"Free Skating Requirements3","16.","Free SkatingFS0316.","Free Skating Requirements316."," ♦ Max. 30 seconds."]
[3,"Free Skating Requirements3","17.","Free SkatingFS0317.","Free Skating Requirements317."]
[3,"Free Skating Requirements3","18.","Free SkatingFS0318.","Free Skating Requirements318."]
[3,"Free Skating Requirements3","19.","Free SkatingFS0319.","Free Skating Requirements319."]
[3,"Free Skating Requirements3","20.","Free SkatingFS0320.","Free Skating Requirements320."]
[4,"Free Skating Requirements4","A.",{"$f":"+B$6&C77","v":"Free SkatingFS04A."},"Free Skating Requirements4A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 4",null,null,10,null,null,2,5,5,1,2,null,1,null,6,1,null,null,{"$f":"+Routine_Time_FS04","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"1st Silver Bar"]
[4,"Free Skating Requirements4","1.",{"$f":"+B$6&C78","v":"Free SkatingFS041."},"Free Skating Requirements41."]
[4,"Free Skating Requirements4","2.","Free SkatingFS042.","Free Skating Requirements42."," JUMPS"]
[4,"Free Skating Requirements4","3.","Free SkatingFS043.","Free Skating Requirements43."," ♦ Total 10 jumps (incl jumps in combos other","Axel and at least"]
[4,"Free Skating Requirements4","4.","Free SkatingFS044.","Free Skating Requirements44.","     than 1 rotation connecting jumps in the combos).","1 double are"]
[4,"Free Skating Requirements4","5.","Free SkatingFS045.","Free Skating Requirements45."," ♦  2 jump combinations (up to 5 jumps each).","mandatory"]
[4,"Free Skating Requirements4","6.","Free SkatingFS046.","Free Skating Requirements46."," ♦  Each jump no more than twice. If twice, 1 must be in combo."]
[4,"Free Skating Requirements4","7.","Free SkatingFS047.","Free Skating Requirements47."]
[4,"Free Skating Requirements4","8.","Free SkatingFS048.","Free Skating Requirements48."," SPINS"]
[4,"Free Skating Requirements4","9.","Free SkatingFS049.","Free Skating Requirements49."," ♦ 1 Solo Spin.","2 different Camel"]
[4,"Free Skating Requirements4","10.","Free SkatingFS0410.","Free Skating Requirements410."," ♦  2 Combo Spins:","spins are mandatory"]
[4,"Free Skating Requirements4","11.","Free SkatingFS0411.","Free Skating Requirements411.","     ♦  1 must include a sit spin;"]
[4,"Free Skating Requirements4","12.","Free SkatingFS0412.","Free Skating Requirements412.","     ♦  1 combo max 4 positions, the other max 3 positions."]
[4,{"$f":"$A$12&A90","v":"Free Skating Requirements4"},"13.","Free SkatingFS0413.","Free Skating Requirements413."," ♦  The same kind of spin max twice and all spins must be different."]
[4,"Free Skating Requirements4","14.","Free SkatingFS0414.","Free Skating Requirements414."]
[4,"Free Skating Requirements4","15.","Free SkatingFS0415.","Free Skating Requirements415."," FOOTWORK"]
[4,"Free Skating Requirements4","16.","Free SkatingFS0416.","Free Skating Requirements416."," ♦  1 footwork sequence, min Level 1, max.Level 3."]
[4,"Free Skating Requirements4","17.","Free SkatingFS0417.","Free Skating Requirements417."," ♦  Max.30 secs."]
[4,"Free Skating Requirements4","18.","Free SkatingFS0418.","Free Skating Requirements418."]
[4,"Free Skating Requirements4","19.","Free SkatingFS0419.","Free Skating Requirements419."]
[4,"Free Skating Requirements4","20.","Free SkatingFS0420.","Free Skating Requirements420."]
[5,"Free Skating Requirements5","A.",{"$f":"+B$7&C98","v":"Free SkatingFS05A."},"Free Skating Requirements5A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 5",null,null,8,null,null,2,5,5,1,2,null,1,null,8,1.5,null,null,{"$f":"+Routine_Time_FS05","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"2nd Silver Bar"]
[5,"Free Skating Requirements5","1.",{"$f":"+B$7&C99","v":"Free SkatingFS051."},"Free Skating Requirements51."]
[5,"Free Skating Requirements5","2.","Free SkatingFS052.","Free Skating Requirements52."," JUMPS"]
[5,"Free Skating Requirements5","3.","Free SkatingFS053.","Free Skating Requirements53."," ♦  Total 8 jumps (incl jumps in combos other","Axel and at least 2"]
[5,"Free Skating Requirements5","4.","Free SkatingFS054.","Free Skating Requirements54.","      than 1 rotation connecting jumps in the combos).","different doubles are"]
[5,"Free Skating Requirements5","5.","Free SkatingFS055.","Free Skating Requirements55."," ♦  2 jump combinations (up to 5 jumps each).","mandatory"]
[5,"Free Skating Requirements5","6.","Free SkatingFS056.","Free Skating Requirements56."," ♦  Each jump no more than twice. If twice, 1 must be in combo."]
[5,"Free Skating Requirements5","7.","Free SkatingFS057.","Free Skating Requirements57."]
[5,"Free Skating Requirements5","8.","Free SkatingFS058.","Free Skating Requirements58.","SPINS"," ♦  At least 2 different"]
[5,"Free Skating Requirements5","9.","Free SkatingFS059.","Free Skating Requirements59."," ♦  1 Solo Spin.","     camels mandatory"]
[5,"Free Skating Requirements5","10.","Free SkatingFS0510.","Free Skating Requirements510."," ♦  2 Combo Spins - max. 4 positions:"," ♦  At least 1 difficult"]
[5,"Free Skating Requirements5","11.","Free SkatingFS0511.","Free Skating Requirements511.","     ♦  1 must include a sit spin.","     position or"]
[5,{"$f":"$A$12&A110","v":"Free Skating Requirements5"},"12.","Free SkatingFS0512.","Free Skating Requirements512."," ♦  The same kind of spin max twice and all must be different.","     variation must be"]
[5,{"$f":"$A$12&A111","v":"Free Skating Requirements5"},"13.","Free SkatingFS0513.","Free Skating Requirements513.",null,"     attempted"]
[5,"Free Skating Requirements5","14.","Free SkatingFS0514.",{"$f":"$B112&$C112","v":"Free Skating Requirements514."}," FOOTWORK"]
[5,"Free Skating Requirements5","15.","Free SkatingFS0515.","Free Skating Requirements515."," ♦  1 footwork sequence, min Level 2, max. Level 3."]
[5,"Free Skating Requirements5","16.","Free SkatingFS0516.","Free Skating Requirements516."," ♦  Max. 30 seconds"]
[5,"Free Skating Requirements5","17.","Free SkatingFS0517.","Free Skating Requirements517."]
[5,"Free Skating Requirements5","18.","Free SkatingFS0518.","Free Skating Requirements518."]
[5,"Free Skating Requirements5","19.","Free SkatingFS0519.","Free Skating Requirements519."]
[5,"Free Skating Requirements5","20.","Free SkatingFS0520.","Free Skating Requirements520."]
[6,"Free Skating Requirements6","A.",{"$f":"+B$8&C119","v":"Free SkatingFS06A."},{"$f":"$B119&$C119","v":"Free Skating Requirements6A."}," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 6",null,null,8,null,null,2,5,5,1,2,null,1,null,10,2,null,null,{"$f":"+Routine_Time_FS06","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"Silver Medal"]
[6,"Free Skating Requirements6","1.",{"$f":"+B$8&C120","v":"Free SkatingFS061."},"Free Skating Requirements61."]
[6,"Free Skating Requirements6","2.","Free SkatingFS062.","Free Skating Requirements62."," JUMPS"]
[6,"Free Skating Requirements6","3.","Free SkatingFS063.","Free Skating Requirements63."," ♦  Total 8 jumps (incl jumps in combos other","Axel and at least 3"]
[6,"Free Skating Requirements6","4.","Free SkatingFS064.","Free Skating Requirements64.","      than 1 rotation connecting jumps in the combos).","different doubles"]
[6,"Free Skating Requirements6","5.","Free SkatingFS065.","Free Skating Requirements65."," ♦  2 jump combinations (up to 5 jumps each).","are mandatory"]
[6,"Free Skating Requirements6","6.","Free SkatingFS066.","Free Skating Requirements66."," ♦  Each jump no more than twice. If twice, 1 must be in combo."]
[6,"Free Skating Requirements6","7.","Free SkatingFS067.","Free Skating Requirements67."]
[6,"Free Skating Requirements6","8.","Free SkatingFS068.","Free Skating Requirements68."," SPINS"," ♦  At least 3 different"]
[6,"Free Skating Requirements6","9.","Free SkatingFS069.","Free Skating Requirements69."," ♦  1 Solo Spin.","     camels mandatory"]
[6,"Free Skating Requirements6","10.","Free SkatingFS0610.","Free Skating Requirements610."," ♦  2 Combo Spins - max. 4 positions:"," ♦  At least 1 difficult"]
[6,"Free Skating Requirements6","11.","Free SkatingFS0611.","Free Skating Requirements611.","     ♦  1 must include a sit spin.","     position or"]
[6,"Free Skating Requirements6","12.","Free SkatingFS0612.","Free Skating Requirements612."," ♦  The same kind of spin max twice and all must be different.","     variation must be"]
[6,{"$f":"$A$12&A132","v":"Free Skating Requirements6"},"13.","Free SkatingFS0613.","Free Skating Requirements613.",null,"     attempted"]
[6,"Free Skating Requirements6","14.","Free SkatingFS0614.","Free Skating Requirements614."," FOOTWORK"]
[6,"Free Skating Requirements6","15.","Free SkatingFS0615.","Free Skating Requirements615."," ♦  1 footwork sequence, min Level 2, max. Level 4."]
[6,"Free Skating Requirements6","16.","Free SkatingFS0616.","Free Skating Requirements616."," ♦  Max. 40 seconds."]
[6,"Free Skating Requirements6","17.","Free SkatingFS0617.","Free Skating Requirements617."]
[6,"Free Skating Requirements6","18.","Free SkatingFS0618.","Free Skating Requirements618."]
[6,"Free Skating Requirements6","19.","Free SkatingFS0619.","Free Skating Requirements619."]
[6,"Free Skating Requirements6","20.","Free SkatingFS0620.","Free Skating Requirements620."]
[7,"Free Skating Requirements7","A.",{"$f":"+B$9&C140","v":"Free SkatingFS07A."},"Free Skating Requirements7A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 7",null,null,8,null,null,2,5,5,1,2,null,1,null,12,2.5,null,null,{"$f":"+Routine_Time_FS07","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"Gold Bar"]
[7,"Free Skating Requirements7","1.",{"$f":"+B$9&C141","v":"Free SkatingFS071."},"Free Skating Requirements71."]
[7,"Free Skating Requirements7","2.","Free SkatingFS072.","Free Skating Requirements72."," JUMPS","Axel (single or"]
[7,"Free Skating Requirements7","3.","Free SkatingFS073.","Free Skating Requirements73."," ♦  Total 8 jumps (incl jumps in combos other","double) and at"]
[7,"Free Skating Requirements7","4.","Free SkatingFS074.","Free Skating Requirements74.","      than 1 rotation connecting jumps in the combos).","least 4 different"]
[7,"Free Skating Requirements7","5.","Free SkatingFS075.","Free Skating Requirements75."," ♦  2 jump combinations (up to 5 jumps each).","doubles are"]
[7,"Free Skating Requirements7","6.","Free SkatingFS076.","Free Skating Requirements76."," ♦  Each jump no more than twice. If twice, 1 must be in combo.","mandatory"]
[7,"Free Skating Requirements7","7.","Free SkatingFS077.","Free Skating Requirements77."]
[7,"Free Skating Requirements7","8.","Free SkatingFS078.","Free Skating Requirements78."," SPINS","At least 1 Heel or Invert"]
[7,"Free Skating Requirements7","9.","Free SkatingFS079.","Free Skating Requirements79."," ♦  1 Solo Spin.","must be attempted."]
[7,"Free Skating Requirements7","10.","Free SkatingFS0710.","Free Skating Requirements710."," ♦  2 Combo Spins - max. 4 positions:","At least 2 difficult"]
[7,"Free Skating Requirements7","11.","Free SkatingFS0711.","Free Skating Requirements711.","     ♦  1 must include a sit spin.","posns or varns"]
[7,"Free Skating Requirements7","12.","Free SkatingFS0712.","Free Skating Requirements712."," ♦ The same kind of spin max twice and all must be different.","must be attempted"]
[7,{"$f":"$A$12&A153","v":"Free Skating Requirements7"},"13.","Free SkatingFS0713.","Free Skating Requirements713.",null,"and at least 1 cfmd"]
[7,"Free Skating Requirements7","14.","Free SkatingFS0714.","Free Skating Requirements714."," FOOTWORK"]
[7,"Free Skating Requirements7","15.","Free SkatingFS0715.","Free Skating Requirements715."," ♦  1 footwork sequence, min Level 3, max. Level 4."]
[7,"Free Skating Requirements7","16.","Free SkatingFS0716.","Free Skating Requirements716."," ♦  Max. 40 seconds."]
[7,"Free Skating Requirements7","17.","Free SkatingFS0717.","Free Skating Requirements717."]
[7,"Free Skating Requirements7","18.","Free SkatingFS0718.","Free Skating Requirements718."]
[7,"Free Skating Requirements7","19.","Free SkatingFS0719.","Free Skating Requirements719."]
[7,"Free Skating Requirements7","20.","Free SkatingFS0720.","Free Skating Requirements720."]
[8,"Free Skating Requirements8","A.",{"$f":"+B$10&C161","v":"Free SkatingFS08A."},"Free Skating Requirements8A."," REQUIREMENTS LIST - NO SET ORDER - FREE SKATING No 8",null,null,8,null,null,2,5,5,1,2,null,1,null,14,3,null,null,{"$f":"+Routine_Time_FS08","v":"2 mins 30 secs (-10 secs) to 4 mins (+10 secs)"},"Gold Medal"]
[8,"Free Skating Requirements8","1.",{"$f":"+B$10&C162","v":"Free SkatingFS081."},"Free Skating Requirements81."]
[8,"Free Skating Requirements8","2.","Free SkatingFS082.","Free Skating Requirements82."," JUMPS"]
[8,"Free Skating Requirements8","3.","Free SkatingFS083.","Free Skating Requirements83."," ♦  Total 8 jumps (incl jumps in combos other","Double Axel and at"]
[8,"Free Skating Requirements8","4.","Free SkatingFS084.","Free Skating Requirements84.","      than 1 rotation connecting jumps in the combos).","least 2 different"]
[8,{"$f":"$A$12&A166","v":"Free Skating Requirements8"},"5.","Free SkatingFS085.","Free Skating Requirements85."," ♦  2 jump combinations (up to 5 jumps each).","triple jumps are"]
[8,"Free Skating Requirements8","6.","Free SkatingFS086.","Free Skating Requirements86."," ♦  Each jump no more than twice. If twice, 1 must be in combo.","mandatory"]
[8,"Free Skating Requirements8","7.","Free SkatingFS087.","Free Skating Requirements87."]
[8,"Free Skating Requirements8","8.","Free SkatingFS088.","Free Skating Requirements88."," SPINS","At least 1 Heel or Invert"]
[8,"Free Skating Requirements8","9.","Free SkatingFS089.","Free Skating Requirements89."," ♦  1 Solo Spin.","must be attempted."]
[8,"Free Skating Requirements8","10.","Free SkatingFS0810.","Free Skating Requirements810."," ♦  2 Combo Spins - max. 4 positions:","At least 3 difficult"]
[8,"Free Skating Requirements8","11.","Free SkatingFS0811.","Free Skating Requirements811.","     ♦  1 must include a sit spin.","posns or varns"]
[8,"Free Skating Requirements8","12.","Free SkatingFS0812.","Free Skating Requirements812."," ♦  The same kind of spin max twice and all must be different","must be attempted"]
[8,{"$f":"$A$12&A174","v":"Free Skating Requirements8"},"13.","Free SkatingFS0813.","Free Skating Requirements813.",null,"and at least 2 cfmd"]
[8,"Free Skating Requirements8","14.","Free SkatingFS0814.","Free Skating Requirements814."," FOOTWORK"]
[8,"Free Skating Requirements8","15.","Free SkatingFS0815.","Free Skating Requirements815."," ♦  1 footwork sequence, min Level 3, max. Level 4."]
[8,"Free Skating Requirements8","16.","Free SkatingFS0816.",{"$f":"$B177&$C177","v":"Free Skating Requirements816."}," ♦  Max. 40 seconds."]
[8,"Free Skating Requirements8","17.","Free SkatingFS0817.","Free Skating Requirements817."]
[8,"Free Skating Requirements8","18.","Free SkatingFS0818.","Free Skating Requirements818."]
[8,"Free Skating Requirements8","19.","Free SkatingFS0819.","Free Skating Requirements819."]
[8,"Free Skating Requirements8","20.","Free SkatingFS0820.","Free Skating Requirements820."]
[]
[]
["Test #",null,"Item #","Full Item","Fig #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$183&A185","v":"1"},"1.",{"$f":"B185&C185","v":"11."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,13,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[1,"1",{"$f":"IF(B186=B185,TEXT(VALUE(C185)+1,\"#\")&\".\",\"1.\")","v":"2."},"12."]
[2,"2",{"$f":"IF(B187=B186,TEXT(VALUE(C186)+1,\"#\")&\".\",\"1.\")","v":"1."},"21.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"Up to 3 mins 30 secs (+/- 10 seconds)","Silver Medal"]
[2,"2",{"$f":"IF(B188=B187,TEXT(VALUE(C187)+1,\"#\")&\".\",\"1.\")","v":"2."},"22."]
[3,"3",{"$f":"IF(B189=B188,TEXT(VALUE(C188)+1,\"#\")&\".\",\"1.\")","v":"1."},"31.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,15,"Up to 4 mins 30 secs (+/- 10 seconds)","Gold Medal"]
[3,"3",{"$f":"IF(B190=B189,TEXT(VALUE(C189)+1,\"#\")&\".\",\"1.\")","v":"2."},"32."]
[]
[]
["Test #",null,"Item #","Full Item",null,"Item Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Award"]
[1,{"$f":"$A$192&A194","v":"1"},"A.",{"$f":"B194&C194","v":"1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Bar"]
[1,"1","1.","11.",null,"3 Pairs Lifts from selection list"]
[1,"1",{"$f":"IF(B196=B195,TEXT(VALUE(C195)+1,\"#\")&\".\",\"1.\")","v":"2."},"12.",null,"2 Pairs Contact Spins"]
[1,"1","3.","13.",null,"1 Singles Shadow Jump of 1 revolution"]
[1,"1","4.","14.",null,"1 Singles Shadow Spin - no combination"]
[1,"1","5.","15.",null,"Primary Straighaway Footwork, min ¾ of length of the floor"]
[1,"1","6.","16."]
[1,"1","7.","17."]
[1,"1","8.","18."]
[1,"1","9.","19."]
[1,"1","10.","110."]
[1,"1","11.","111."]
[1,"1","12.","112.",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,"2","A.","2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 2"]
[2,"2","1.","21.",null,"2 Pairs Lifts from selection list"]
[2,"2",{"$f":"IF(B209=B208,TEXT(VALUE(C208)+1,\"#\")&\".\",\"1.\")","v":"2."},"22.",null,"1 Throw or Twist Lift"]
[2,"2","3.","23.",null,"2 Pairs Contact Spins"]
[2,"2","4.","24.",null,"1 Singles Shadow Jump"]
[2,"2","5.","25.",null,"1 Singles Shadow Spin"]
[2,"2","6.","26.",null,"Secondary Footwork, circular pattern, min ¾ of the full width of the floor"]
[2,"2","7.","27."]
[2,"2","8.","28."]
[2,"2","9.","29."]
[2,"2","10.","210."]
[2,"2","11.","211."]
[2,"2","12.","212.",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,"3","A.","3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Pairs No 3"]
[3,"3","1.","31.",null,"3 Pairs Lifts (one of which must be a combination Lift)"]
[3,"3",{"$f":"IF(B222=B221,TEXT(VALUE(C221)+1,\"#\")&\".\",\"1.\")","v":"2."},"32.",null,"1 Throw Lift"]
[3,"3","3.","33.",null,"1 Twist Lift"]
[3,"3","4.","34.",null,"2 Pairs Contact Spins"]
[3,"3","5.","35.",null,"Death Spiral"]
[3,"3","6.","36.",null,"1 Singles Shadow Jump (must be 2 revolutions)"]
[3,"3","7.","37.",null,"1 Singles Shadow Spin"]
[3,"3","8.","38.",null,"Advanced Serp Footwork (with at least 2 bold curves, min ½ width of the floor)"]
[3,"3","9.","39."]
[3,"3","10.","310."]
[3,"3","11.","311."]
[3,"3","12.","312.",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 #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Mark","Passing Grade","Maximum Time","Award"]
[1,{"$f":"$A$234&A236","v":"In-Line Free Skating1"},"1.",{"$f":"B236&C236","v":"In-Line Free Skating11."},null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,11,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Bar"]
[1,{"$f":"$A$234&A237","v":"In-Line Free Skating1"},{"$f":"IF(B237=B236,TEXT(VALUE(C236)+1,\"#\")&\".\",\"1.\")","v":"2."},"In-Line Free Skating12.",null,"Artistic Impression"]
[2,"In-Line Free Skating2","1.","In-Line Free Skating21.",null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,13,"Up to 2 mins 30 secs (+/- 5 seconds)","Bronze Medal"]
[2,"In-Line Free Skating2","2.","In-Line Free Skating22.",null,"Artistic Impression"]
[3,"In-Line Free Skating3","1.","In-Line Free Skating31.",null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"Up to 3 mins (+/- 10 seconds)","Silver Bar"]
[3,"In-Line Free Skating3","2.","In-Line Free Skating32.",null,"Artistic Impression"]
[4,"In-Line Free Skating4","1.","In-Line Free Skating41.",null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,14,"Up to 3 mins 30 secs (+/- 10 seconds)","Silver Medal"]
[4,"In-Line Free Skating4","2.","In-Line Free Skating42.",null,"Artistic Impression"]
[5,"In-Line Free Skating5","1.","In-Line Free Skating51.",null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,15,"Up to 3 mins 30 secs (+/- 10 seconds)","Gold Bar"]
[5,"In-Line Free Skating5","2.","In-Line Free Skating52.",null,"Artistic Impression"]
[6,"In-Line Free Skating6","1.","In-Line Free Skating61.",null,"Technical Merit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[]
[]
["Test #",null,"Item #","Full Item",null,"Item Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Award"]
[1,{"$f":"$A$249&A251","v":"1"},"A.",{"$f":"B251&C251","v":"1A."},null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bronze Bar"]
[1,{"$f":"$A$249&A252","v":"1"},"1.","11.",null,"Straightaway Primary Forward Footwork, min ½ length of floor"]
[1,"1",{"$f":"IF(B253=B252,TEXT(VALUE(C252)+1,\"#\")&\".\",\"1.\")","v":"2."},"12.",null,"Diagonal Primary Forward Footwork, min ½ length of floor"]
[1,"1","3.","13.",null,"IB Upright Spin (min 2 revs with wheels, not stopper)"]
[1,"1","4.","14.",null,"Heel and Toe Spin"]
[1,"1","5.","15.",null,"Two Heel Spin"]
[1,"1","6.","16.",null,"Waltz Jump"]
[1,"1","7.","17.",null,"Toe Loop"]
[1,"1","8.","18.",null,"Choose 1 Jump:  Bunny Hop  or  ½ Salchow  or  ½ Loop.  Jump name must be entered."]
[1,"1","9.","19.",null,"Jump combo of 2 jumps - choose from: "]
[1,"1","10.","110.",null,".  Waltz Jump, Toe Loop, Bunny Hop, ½ Toe Loop, Mazurka.  Jump names must be entered."]
[1,"1","11.","111."]
[1,{"$f":"$A$249&A263","v":"1"},{"$f":"IF(B263=B262,TEXT(VALUE(C262)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B263&C263","v":"112."}]
[2,{"$f":"$A$249&A264","v":"2"},"A.","2A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 2"]
[2,"2","1.","21.",null,"Straightaway Primary Backward Footwork, min ¾ length of floor"]
[2,"2",{"$f":"IF(B266=B265,TEXT(VALUE(C265)+1,\"#\")&\".\",\"1.\")","v":"2."},"22.",null,"Diagonal Secondary Footwork, min ¾ length of floor"]
[2,"2","3.","23.",null,"IB Upright Spin (min 3 revs with wheels, not stopper)"]
[2,"2","4.","24.",null,"Choose 1 Spin:  OB Upright  or  OF Upright (min 3 revs with wheels, not stopper)"]
[2,"2","5.","25.",null,"Salchow"]
[2,"2","6.","26.",null,"Flip"]
[2,"2","7.","27.",null,"Choose 1 Jump:  Thoren  or  ½ Lutz  or  Loop (OB)  or  Pat Lowe.  Jump name"]
[2,"2","8.","28.",null,"  must be entered."]
[2,"2","9.","29.",null,"Jump combo of 2 Jumps from the following (no repeated Jumps):"]
[2,"2","10.","210.",null,".  Flip, Thoren, Salchow, Toe Loop, Waltz Jump.  Jump names must be entered."]
[2,"2","11.","211."]
[2,{"$f":"$A$249&A276","v":"2"},{"$f":"IF(B276=B275,TEXT(VALUE(C275)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B276&C276","v":"212."}]
[3,{"$f":"$A$249&A277","v":"3"},"A.","3A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 3"]
[3,"3","1.","31.",null,"Semi Circular Primary Footwork (width of the floor)"]
[3,"3",{"$f":"IF(B279=B278,TEXT(VALUE(C278)+1,\"#\")&\".\",\"1.\")","v":"2."},"32.",null,"Diagonal Secondary Footwork, min ¾ length of floor"]
[3,"3","3.","33.",null,"Change or Combo Upright Spin (min 3 revs with wheels, not stopper).  Edges"]
[3,"3","4.","34.",null,"  (but not foot) must be entered."]
[3,"3","5.","35.",null,"Choose 1 Spin:  OB Camel  or  IB Sit"]
[3,"3","6.","36.",null,"Axel"]
[3,"3","7.","37.",null,"1½ or Double Toe Loop "]
[3,"3","8.",{"$f":"B285&C285","v":"38."},null,"Choose 1 Jump:  1½ or Dbl Salchow  or  Lutz  or  1½ or Dbl Flip  or  College  or  Boeckl"]
[3,"3","9.","39.",null,"Jump combo of 3 jumps from the following (no repeated Jumps):"]
[3,"3","10.","310.",null,". Axel, 1½ or Double Flip, 1½ or Dbl Salchow, Dbl Toe Loop.  Jump names must be entered. *"]
[3,{"$f":"$A$249&A288","v":"3"},"11.",{"$f":"B288&C288","v":"311."}]
[3,"3","12.","312.",null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[4,{"$f":"$A$249&A290","v":"4"},"A.","4A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 4"]
[4,"4","1.","41.",null,"Circular Secondary Footwork (width of the floor)"]
[4,"4",{"$f":"IF(B292=B291,TEXT(VALUE(C291)+1,\"#\")&\".\",\"1.\")","v":"2."},"42.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[4,"4","3.","43.",null,"Change or Combo Sit Spin.  Edges (but not foot) must be entered."]
[4,"4","4.","44.",null,"Choose 1 Spin:  IB Camel  or  OF Camel"]
[4,"4","5.","45.",null,"Axel"]
[4,"4","6.","46.",null,"Double Salchow"]
[4,"4","7.","47.",null,"Choose 1 Jump:  Double Toe Loop  or  Lutz  or  Walley  or  Double Flip"]
[4,"4","8.","48.",null,"Jump combo of 3 jumps from the following (no repeated Jumps):"]
[4,"4","9.","49.",null,". Axel, Double Salchow, Double Toe Loop, Double Flip.  Jump names must be entered. *"]
[4,"4","10.","410."]
[4,"4","11.","411."]
[4,{"$f":"$A$249&A302","v":"4"},{"$f":"IF(B302=B301,TEXT(VALUE(C301)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B302&C302","v":"412."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[5,{"$f":"$A$249&A303","v":"5"},"A.","5A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 5"]
[5,"5","1.","51.",null,"Serpentine Secondary Footwork (width of the floor)"]
[5,"5",{"$f":"IF(B305=B304,TEXT(VALUE(C304)+1,\"#\")&\".\",\"1.\")","v":"2."},"52.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[5,"5","3.","53.",null,"Change or Combo Camel to Sit Spin.  Edges (but not foot) must be entered."]
[5,"5","4.","54.",null,"Choose 1 Spin:  Jump Camel Spin  or  Camel change or combo Spin.  Edges"]
[5,"5","5.","55.",null,"  (but not foot) must be entered."]
[5,"5","6.","56.",null,"Double Flip"]
[5,"5","7.","57.",null,"Double Loop"]
[5,"5","8.","58.",null,"Choose 1 Jump:  Dbl Axel  or  Dbl Lutz  or  Triple Toe Loop.  Jump name must be entered."]
[5,"5","9.","59.",null,"Jump combo of 5 jumps from the following (no repeated Jumps):"]
[5,"5","10.","510.",null,"  Axel, Double Salchow, Double Toe Loop, Double Flip, Double Loop.  Jump "]
[5,"5","11.","511.",null,"  names must be entered. *"]
[5,{"$f":"$A$249&A315","v":"5"},{"$f":"IF(B315=B314,TEXT(VALUE(C314)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B315&C315","v":"512."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]
[6,{"$f":"$A$249&A316","v":"6"},"A.","6A.",null,"REQUIREMENTS LIST - NO SET ORDER - Inline No 6"]
[6,"6","1.","61.",null,"Serpentine Advanced Footwork (width of the floor)"]
[6,"6",{"$f":"IF(B318=B317,TEXT(VALUE(C317)+1,\"#\")&\".\",\"1.\")","v":"2."},"62.",null,"Diagonal Advanced Footwork, min ¾ length of floor"]
[6,"6","3.","63.",null,"Change or Combo Camel Spin.  "]
[6,"6","4.",{"$f":"B320&C320","v":"64."},null,"Choose 1 Spin:  Jump Camel Spin  or  Heel Camel Spin.  Edges (but not foot) must be entered."]
[6,{"$f":"$A$249&A321","v":"6"},"5.","65.",null,"Double Axel"]
[6,"6","6.","66.",null,"Triple Toe Loop"]
[6,"6","7.","67.",null,"Choose 1 Jump:  Dbl Loop  or  Dbl Lutz  or  Triple Salchow.  Jump name must be entered."]
[6,"6","8.","68.",null,"Jump combo of 3 Jumps from the following (no repeated Jumps):"]
[6,"6","9.","69.",null,"  Double Axel, Triple Salchow, Triple Toe Loop, Double Flip, Double Loop.  Jump names"]
[6,"6","10.","610.",null,"  must be entered. *"]
[6,"6","11.","611."]
[6,{"$f":"$A$249&A328","v":"6"},{"$f":"IF(B328=B327,TEXT(VALUE(C327)+1,\"#\")&\".\",\"1.\")","v":"12."},{"$f":"B328&C328","v":"612."},null,"*  Choose between a Thoren or Loop (OB) as joining jumps.  Jump names must be entered."]

{"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":""},{"$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'!B20","v":0},{"$f":"'Data Entry Sheet'!B23","v":""},{"$f":"'Data Entry Sheet'!B24","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!#REF!),\"\",'Data Entry Sheet'!#REF!)","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Application Form'!H16","v":0},{"$f":"'Application Form'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Application Form'!J16","v":0},{"$f":"'Application Form'!H17","v":0},{"$f":"'Application Form'!I16","v":0},{"$f":"'Application Form'!J17","v":0},{"$f":"'Application Form'!H18","v":0},{"$f":"'Application Form'!I18","v":0},{"$f":"'Application Form'!J18","v":0},{"$f":"'Application Form'!H19","v":0},{"$f":"'Application Form'!I19","v":0},{"$f":"'Application Form'!J19","v":0},{"$f":"'Application Form'!H20","v":0},{"$f":"'Application Form'!I20","v":0},{"$f":"'Application Form'!J20","v":0},{"$f":"'Application Form'!H31","v":0},{"$f":"'Application Form'!I31","v":0},{"$f":"'Application Form'!J31","v":0},{"$f":"'Application Form'!H32","v":0},{"$f":"'Application Form'!I32","v":0},{"$f":"'Application Form'!J32","v":0},{"$f":"'Application Form'!H34","v":0},{"$f":"'Application Form'!I34","v":0},{"$f":"'Application Form'!J34","v":0},{"$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'!B32),\"\",'Data Entry Sheet'!B32)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B33),\"\",'Data Entry Sheet'!B33)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B34),\"\",'Data Entry Sheet'!B34)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B35),\"\",'Data Entry Sheet'!B35)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B36),\"\",'Data Entry Sheet'!B36)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B37),\"\",'Data Entry Sheet'!B37)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B38),\"\",'Data Entry Sheet'!B38)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B39),\"\",'Data Entry Sheet'!B39)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B40),\"\",'Data Entry Sheet'!B40)","v":""},{"$f":"IF(ISBLANK('Data Entry Sheet'!B41),\"\",'Data Entry Sheet'!B41)","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'!N20),\"\",'Application Form'!N20)","v":""},{"$f":"IF(ISBLANK('Application Form'!N22),\"\",'Application Form'!N22)","v":""},{"$f":"IF(ISBLANK('Application Form'!N26),\"\",'Application Form'!N26)","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'!B33),\"\",'Data Entry Sheet'!B33)","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'!B34),\"\",'Data Entry Sheet'!B34)","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'!B35),\"\",'Data Entry Sheet'!B35)","v":""}]
[null,null,null,null,null,null,null,null,"Convert discipline and test to test type  ","Discipline",{"$f":"'Data Entry Sheet'!B15","v":"Free Skating"},{"$f":"'Data Entry Sheet'!C15","v":0},{"$f":"'Data Entry Sheet'!D15","v":0},{"$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'!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},{"$f":"'Data Entry Sheet'!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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'!B36),\"\",'Data Entry Sheet'!B36)","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'!B37),\"\",'Data Entry Sheet'!B37)","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!"},"","","","",{"$f":"IF(T6=$H$2,IF(LEN($I$2)=1,T7&\"0\"&$I$2,T7&$I$2),\"\")","v":""},{"$f":"IF(U6=$H$2,U7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Data Entry Sheet'!B38),\"\",'Data Entry Sheet'!B38)","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'!B39),\"\",'Data Entry Sheet'!B39)","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'!B40),\"\",'Data Entry Sheet'!B40)","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'!B41),\"\",'Data Entry Sheet'!B41)","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!"}}]