{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Instructions for Use","Meet Information Sheet","Macro Instructions","L1 Scores","L1 Final","L2 Scores","L2 Final","L3 Scores","L3 Final","L4 Scores","L4 Final","L5 Scores","L5 Final","L6 Scores","L6 Final","L7 Scores","L7 Final","L8 Scores","L8 Final","ALL SCORES L1 to L6","ALL SCORES L7 and up","L9 Scores","L9 Final","L10 Scores","L10 Final"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":14,"comments":2,"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 for Use","index":0,"n_rows":108,"n_cols":3,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["Why use this spreadsheet?",null,"Updated April 2016"]
[]
[null,"As of the beginning of the 2016 season (January 2016) the rules for the Power TeamGym Rules & Policies 2016-2019 require all results to be submitted within this excel spreadsheet format.  This spreadsheet contains macros and cells with formulas that perform calculations – both intended to save time and to be accurate."]
[]
[null,"It is very important that you make sure when you open this document that you click “Enable Macros”.  If you did not, please close the document and reopen it enabling the macros.  Save a copy as an excel spreadsheet right away with a unique name.  We suggest you keep the name and add an indentifyer such as the day and month or year or name of the Meet at the beginning.  Eg. PTG Meet Scoresheet Jan 16 Flipfest"]
[]
[null,"Make sure you save the document as an excel spreadsheet and not a .pdf file."]
[]
[null,"At the conclusion of the meet, you must email a copy of the spreadsheet to the Chairperson for the PTG Technical Committee, Mr. Don Spencer:"]
["","gficoach@msn.com"]
[null,"and please send a courtesy copy to Tracy Nordheim"]
["","teamgymtracy@gmail.com"]
[null,"to load the scores onto the USA Gymnastics website."]
[]
["How to use this spreadsheet"]
[]
["FIRST","Complete the unique details about your meet on the Meet Information Sheet (bright yellow tab.) "]
[]
[null,"The information requested in bright yellow MUST be filled in otherwise the Results pages will not show the meet information properly."]
[null,"If you do not know all of the information in lighter yellow, please ask the Meet Director or leave it blank until you have time to complete it."]
[]
[null,"Each Level has its own data entry for scores spreadsheet (these tabs are white) and results or Final spreadsheet (these tabs are bright green).  "]
[]
[null,"All of your results data entry needs to be on the sheets with WHITE tabs.  "]
[]
[null,"IMPORTANT – Do NOT delete any columns or rows in the spreadsheets.  Leave them blank if you do not have any data to enter."]
[]
[null,"While you are setting up, even before the meet begins, you can begin by typing the Club Names (Column A), Team Names (Column B), and the Number of Athletes per squad (Column C) into the correct data entry spreadsheets with the white tabbed Score/Results spreadsheets.  These are simply named “L1 Scores”, “L2 Scores” and so on.]   You should put then in an order that makes sense for the meet, such as who appears first (on Floor or Jump) just to make it easy.  Make sure each team goes in the correct Division – the All Girls/Mostly Girl teams in the Open Female Division, the All Boys/Mostly Boys teams in the Open Male Division and so on.  The are colored coded the same on each of the spreadsheets:"]
["Division"]
["OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
["HUGS","HUGS (Hope Unites Gymnastics with Special Needs): Squads composed solely of HUGS athletes, male or female regardless of ratio. (Only L1 and L2)"]
["UNI","UNIFIED: Squads that have any combination of HUGS and “Unified Partners” (athletes without disabilities or special needs). (Only L1 and L2)"]
[]
["SAVE","SAVE the spreadsheet regularly.  As the meet progresses, you may type in all of the results in live time or have a data entry assistant type them in for you from the paper scoresheets."]
[]
[null,"Each Lx Scores sheet is similar – although not identical because each level has unique requirements in the number of passes required or allowed on Jump apparatus.  There are many cells containing formulae and calculations where you should be careful not to type.  As a guideline, please do not NOT type in the yellow, grey or aqua areas of the data spreadsheets."]
[]
[null,"L1 Final"]
[null,null,"Do not type in the green tabbed spreadsheets"]
[null,"PLEASE, DO NOT TYPE ANY INFORMATION on the Green Tabbed FINAL spreadsheets.  The results will automatically appear"]
[null,"within those worksheets as the meet progresses and the macro will"]
[null,"sort the results without any additional typing necessary."]
[]
[]
[]
[null,"Special notes for Judges"]
[null,"Since your individual bonuses and deductions are included in your scores, do not add additional bonus in the spreadsheet columns except the HEAD JUDGE deductions which are input in the penultimate column (right before the Final Score)"]
[]
["SIGN !","Do not leave the meet prior to signing each score sheet printed out (or equivalent total sheet.)"]
[]
[]
[null,"Tabulating and Printing Score Sheets"]
[]
[null,"Once the athletes have competed, the scores are entered and the Session/Meet is complete, you will ask the spreadsheet to tabulate the scores for each level that has competed and then print out the results to announce.  The Judges are required to sign each sheet at the meet."]
[]
[null,"L1 Final"]
[null,"To tabulate scores and determine Medal Colors (for Levels 1 and 2) and the team placements, go to the Green Colored Tab for the Level you would like to tabulate.  Click on the grey colored “Button” that says “Click here to Tabulate”."]
[]
[]
[]
[]
[]
[]
[null,"A Macro imbedded in the sheet will sort the results with the highest scoring team appearing first along with determined Medal Colors for each team at Levels 1 and 2, and placements for all other levels by division."]
[]
[null,"CHECK FOR TIED SCORES, you must decide manually which team has the highest score on a single event as the winner to award that day’s placement prize, although both teams will be recognized as tying for placement, per the rules."]
[]
[]
[null,"Select PRINT (Ctrl P) to print each sheet out."]
[null,"Have the Judges verify the scores (with signature) against their own paper sheets for the meet director to announce the results."]
[]
[]
["Technical Notes"]
[null,"All spreadsheets assume a two judge panel will be used for each event.  In the rare event that there is only one judge merely duplicate the Judge 1 scores into the Judge 2 columns for a correct tabulation.  You can use the Copy and Paste-Special shortcut features:"]
[null,"~Select and highlight all of the cells you wish to copy"]
[null,"~Go to Edit, Copy to save the data"]
[null,"~Then highlight the cells you wish to paste the data into"]
[null,"~Select Edit, Paste Special, Values then hit enter"]
[]
["HELP!","If for some reason the macro sort does not work as intended during your meet, don’t panic, just switch to the “old school” paper way of doing things."]
["IT ISN'T WORKING","Print out the score sheets anyway (the green tabbed sheets should be formatted to print out only one to three pages at maximum. Manually write over the placements and award the correct awards to the teams.  Have the judges sign the overwritten sheets and make a photocopy to keep for themselves.  "]
[]
[null,"PLEASE Send an email note along with the entire results spreadsheet to Mr. Don Spencer:"]
[null,"gficoach@msn.com"]
[null,"and please send a courtesy copy to Tracy Nordheim"]
[null,"teamgymtracy@gmail.com"]
[null,"alerting us to a malfunction within the required spreadsheets."]
[]
[]
["4 JUDGE","IF a Four Judge Panel is used for each event for Levels 1 through 8, discard the Highest and Lowest OVERALL scores and input the two middle scores into the spreadsheet."]
["PANELS","NOTE: For Levels 9 and 10 ONLY, a Four Judge Panel is used for each event.  Discard the Highest and Lowest scores FOR EACH EVENT and input the two middle scores in the spreadsheet."]
[]
[null,"The three events at Level 9 are:  Tumbling; Trampet; and Group Floor.  Each one will have an individual score sheet.  Determine High, High Middle, Low Middle and Low.  "]
[]
[null,"After determining that the scores are within range for that event, discard High and Low.  Input the two middle scores. Values depend upon the difficulty (EG. Scores can be up to 19.0 on a pass)"]
[]
["Troubleshooting"]
[]
[null,"If for some reason the macro sort does not work as intended during your meet, don’t panic, just switch to the “old school” paper way of doing things."]
[]
[null,"Print out the score sheets anyway with the teams in the order that shows up.  (The green tabbed sheets should be formatted to print out only one to three pages at maximum and you can even reduce the number of pages when you select Print.  Uncheck the All Pages box and select only the pages you wish to print.)"]
[]
[null,"On the print-out, manually write over the placements and award the correct awards to the teams.  Have the judges sign the overwritten paper sheets and make a photocopy to keep for themselves.  "]
[]
[null,"Click on this link if you need to reference the rules document:"]
[null,"https://usagym.org/PDFs/Group/ptg/rules/PTG_rules_2016_2019.pdf "]

{"sheet":"Meet Information Sheet","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1]]}
["Meet Information Sheet",null,"Please complete first!"]
["Please enter the information in all yellow highlighted areas.           (You may leave blanks when there are fewer judges.)",null,"For example:"]
["Event Name: ",null," Seaside Invitational"]
["Event location:",null,"Sparta Fieldhouse"]
["Event Host:",null,"Gymnastics 1, 2, 3"]
["Event date: ",null,"2015-03-15"]
["Meet Director: ",null,"Dean Capelotti"]
["Contact # or email",null,"dcap@fallbrook.com"]
["Sanction # ",null,234156]
["Head Judge and/or Meet Referee",null,"Don Spencer"]
["Jump Judge 1: ",null,"Lori Laznovsky"]
["Jump Judge 2: ",null,"George Hery"]
["Jump Judge 3: ",null,"Bob Raymond"]
["Jump Judge 4: ",null,"Emily Martinez"]
["Floor Judge 1: ",null,"Cindy Plummer"]
["Floor Judge 2: ",null,"Carole Hickey"]
["Floor Judge 3: ",null,"Tracy Nordheim"]
["Floor Judge 4: "]
["Data Entry person:"]
[]
["Any additional contact name/cell phone# if we have a question about the meet?"]

{"sheet":"Macro Instructions","index":2,"n_rows":84,"n_cols":3,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null," Instructions for Sorting the Final Pages Per Level"]
[]
[null,"Each Level's Final Page has a built in Macro Button to sort the Final Results Tabulation Sheet. The button looks like the one here :"]
[null,"For reference, each macro is simply named \"Macro 1\" or \"Macro 2\" with the digit referring the the level.  "]
[]
[null,"Macro Names:"]
[null,"Macro 1 (in the L1 Final sheet)","Sorts the results in the \"L1 Scores\" spreadsheet"]
[null,"Macro 2 (in the L2 Final sheet)","Sorts the results in the \"L2 Scores\" spreadsheet"]
[null,"Macro 3 (in the L3 Final sheet)","Sorts the results in the \"L3 Scores\" spreadsheet"]
[null,"Macro 4 (in the L4 Final sheet)","Sorts the results in the \"L4 Scores\" spreadsheet"]
[null,"Macro 5 (in the L5 Final sheet)","Sorts the results in the \"L5 Scores\" spreadsheet"]
[null,"and so forth"]
[]
[]
[null,"IF the Macro button built in to the sheet does not work then use the instructions below:"]
[null,"Excel 2003:"]
[null,"1. Click Tools > Macros > Macro from the menus to bring up the Macro dialogue box."]
[null,"2. Select the macro for the level you would like to score/sort from the list of those available."]
[null,"3. Click the Run button."]
[null,"4. Repeat for each level in your meet."]
[]
[null,"Excel 2007:"]
[null,"If the Developer tab is not available, do the following to display it:"]
[]
[null,"a. Click the Microsoft Office Button"]
[null,", and then click Excel Options."]
[]
[null,"b. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK."]
[]
[null,"To set the security level temporarily to enable all macros, do the following:"]
[]
[null,"a. On the Developer tab, in the Code group, click Macro Security."]
[]
[null,"b. In the Macro Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK."]
[]
[null,"c. Note   To help prevent potentially dangerous code from running, we recommend that you return to any one of the settings that disable all macros after you finish working with macros. or more information about how to change the settings, see Change macro security settings in Excel."]
[]
[null,"Open the workbook that contains the macro."]
[]
[null,"On the Developer tab, in the Code group, click Macros."]
[]
[null,"In the Macro name box, click the macro that you want to run."]
[]
[null,"Do one of the following:"]
[]
[null,"a. To run a macro in an Excel workbook, click Run."]
[]
[]
[null,"Excel 2010/2011/2013"]
[null,"Before you run macros"]
[]
[null,"You may first need to change a few settings in Excel before you can run macros:"]
[]
[null,"1. If the Developer tab is not available, do the following to display it:"]
[null,"a. Click the File tab, click Options, and then click the Customize Ribbon category."]
[]
[null,"b. In the Main Tabs list, select the Developer check box, and then click OK."]
[]
[null,"2. To set the security level temporarily to enable all macros, do the following:"]
[]
[]
[]
[null,"a. On the Developer tab, in the Code group, click Macro Security."]
[]
[]
[]
[null,"b. In the Macro Settings category, under Macro Settings, click Enable all macros (not recommended; potentially dangerous code can run), and then click OK."]
[]
[null,"Note    To help prevent potentially dangerous code from running, we recommend that you return to any one of the settings that disable all macros after you finish working with macros."]
[]
[null,"Run the macro"]
[]
[null,"1. Open the workbook that contains the macro."]
[]
[null,"2. On the Developer tab, in the Code group, click Macros."]
[]
[null,"3. In the Macro name box, click the macro that you want to run."]
[]
[]
[null,"4. Do one of the following:"]
[]
[]
[]
[null,"a. To run a macro in an Excel workbook, click Run."]

{"sheet":"L1 Scores","index":3,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,5,13,7],[13,8,13,10],[13,11,13,12],[2,27,3,27],[2,28,3,28],[4,27,5,27],[4,28,5,28],[6,27,7,27],[6,28,7,28],[8,27,9,27],[8,28,9,28]]}
["Power TeamGym Scoresheet for Level 1",null,null,null,null,null,null,null,1]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},null,"Please do",null,"Division",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team Score Range","Category"]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},null,"NOT",null,"OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18 - 20","GOLD"]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,"type",null,"OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 - 17.99","SILVER"]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0},null," here.",null,"MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"below 16","BRONZE"]
[null,null,null,"Use",null,"HUGS","HUGS (Hope Unites Gymnastics with Special Needs): Squads composed solely of HUGS athletes, male or female regardless of ratio."]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},null,"Meet",null,"UNI","UNIFIED: Squads that have any combination of HUGS and “Unified Partners” (athletes without disabilities or special needs)."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},null,"Information"]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},null,"Sheet!",null,null,"Important Note: \"Group\" the squads below in their correct division."]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},null,"",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1 ",null,null,"Judge 2",null,null,"Sub Totals",null,"Neu","JUMP",null,null,null,"Bon","Neu","FX",null,"sub-","Head Judge",null,"MEDAL"]
["Club","Team Name","Sqd","Division",null,"TU","VT","MT","TU","VT","MT","Avg J1","Avg J2","-","Score",null,"J-1","J-2","+","-","Score",null,"final","Deductions","FINAL","COLOR"]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F16:H16),0)","v":0},{"$f":"IFERROR(AVERAGE(I16:K16),0)","v":0},null,{"$f":"IF(M16=0,L16-N16,((L16+M16)/2)-N16)","v":0},null,null,null,null,null,{"$f":"IF(R16=0,Q16+S16-T16,((Q16+R16)/2)+S16-T16)","v":0},null,{"$f":"U16+O16","v":0},null,{"$f":"(O16+U16)-X16","v":0},{"$f":"IF(Y16>18,\"GOLD\",IF(Y16>16,\"SILVER\",IF(Y16>0,\"BRONZE\",\"\")))","v":""}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(Y17>18,\"GOLD\",IF(Y17>16,\"SILVER\",IF(Y17>0,\"BRONZE\",\"\")))","v":""}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F22:H22),0)","v":0},{"$f":"IFERROR(AVERAGE(I22:K22),0)","v":0},null,{"$f":"IF(M22=0,L22-N22,((L22+M22)/2)-N22)","v":0},null,null,null,null,null,{"$f":"IF(R22=0,Q22+S22-T22,((Q22+R22)/2)+S22-T22)","v":0},null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,{"$f":"U23+O23","v":0},null,{"$f":"(O23+U23)-X23","v":0},""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F28:H28),0)","v":0},{"$f":"IFERROR(AVERAGE(I28:K28),0)","v":0},null,{"$f":"IF(M28=0,L28-N28,((L28+M28)/2)-N28)","v":0},null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F29:H29),0)","v":0},{"$f":"IFERROR(AVERAGE(I29:K29),0)","v":0},null,{"$f":"IF(M29=0,L29-N29,((L29+M29)/2)-N29)","v":0},null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(F30:H30),0)","v":0},{"$f":"IFERROR(AVERAGE(I30:K30),0)","v":0},null,{"$f":"IF(M30=0,L30-N30,((L30+M30)/2)-N30)","v":0},null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,{"$f":"U35+O35","v":0},null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]

{"sheet":"L1 Final","index":4,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 1",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L1 Scores\""]
[null,"Qualifying score for Nationals is 15 or >"]
[null,"OPEN FEMALE"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color",null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L1 Scores'!A16","v":0},{"$f":"'L1 Scores'!B16","v":0},{"$f":"'L1 Scores'!O16","v":0},{"$f":"'L1 Scores'!U16","v":0},{"$f":"'L1 Scores'!Y16","v":0},{"$f":"IF(F7>18,\"GOLD\",IF(F7>16,\"SILVER\",IF(F7>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A17","v":0},{"$f":"'L1 Scores'!B17","v":0},{"$f":"'L1 Scores'!O17","v":0},{"$f":"'L1 Scores'!U17","v":0},{"$f":"'L1 Scores'!Y17","v":0},""]
[null,{"$f":"'L1 Scores'!A19","v":0},{"$f":"'L1 Scores'!B19","v":0},{"$f":"'L1 Scores'!O19","v":0},{"$f":"'L1 Scores'!U19","v":0},{"$f":"'L1 Scores'!Y19","v":0},""]
[null,{"$f":"'L1 Scores'!A20","v":0},{"$f":"'L1 Scores'!B20","v":0},{"$f":"'L1 Scores'!O20","v":0},{"$f":"'L1 Scores'!U20","v":0},{"$f":"'L1 Scores'!Y20","v":0},""]
[null,{"$f":"'L1 Scores'!A21","v":0},{"$f":"'L1 Scores'!B21","v":0},{"$f":"'L1 Scores'!O21","v":0},{"$f":"'L1 Scores'!U21","v":0},{"$f":"'L1 Scores'!Y21","v":0},""]
[null,{"$f":"'L1 Scores'!A18","v":0},{"$f":"'L1 Scores'!B18","v":0},{"$f":"'L1 Scores'!O18","v":0},{"$f":"'L1 Scores'!U18","v":0},{"$f":"'L1 Scores'!Y18","v":0},""]
[null,{"$f":"'L1 Scores'!A22","v":0},{"$f":"'L1 Scores'!B22","v":0},{"$f":"'L1 Scores'!O22","v":0},{"$f":"'L1 Scores'!U22","v":0},{"$f":"'L1 Scores'!Y22","v":0},""]
[null,{"$f":"'L1 Scores'!A23","v":0},{"$f":"'L1 Scores'!B23","v":0},{"$f":"'L1 Scores'!O23","v":0},{"$f":"'L1 Scores'!U23","v":0},{"$f":"'L1 Scores'!Y23","v":0},""]
[null,{"$f":"'L1 Scores'!A24","v":0},{"$f":"'L1 Scores'!B24","v":0},{"$f":"'L1 Scores'!O24","v":0},{"$f":"'L1 Scores'!U24","v":0},{"$f":"'L1 Scores'!Y24","v":0},""]
[null,{"$f":"'L1 Scores'!A25","v":0},{"$f":"'L1 Scores'!B25","v":0},{"$f":"'L1 Scores'!O25","v":0},{"$f":"'L1 Scores'!U25","v":0},{"$f":"'L1 Scores'!Y25","v":0},""]
[null,{"$f":"'L1 Scores'!A26","v":0},{"$f":"'L1 Scores'!B26","v":0},{"$f":"'L1 Scores'!O26","v":0},{"$f":"'L1 Scores'!U26","v":0},{"$f":"'L1 Scores'!Y26","v":0},""]
[null,{"$f":"'L1 Scores'!A27","v":0},{"$f":"'L1 Scores'!B27","v":0},{"$f":"'L1 Scores'!O27","v":0},{"$f":"'L1 Scores'!U27","v":0},{"$f":"'L1 Scores'!Y27","v":0},""]
[]
[null,"OPEN MALE"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[null,{"$f":"'L1 Scores'!A29","v":0},{"$f":"'L1 Scores'!B29","v":0},{"$f":"'L1 Scores'!O29","v":0},{"$f":"'L1 Scores'!U29","v":0},{"$f":"'L1 Scores'!Y29","v":0},{"$f":"IF(F23>18,\"GOLD\",IF(F23>16,\"SILVER\",IF(F23>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A30","v":0},{"$f":"'L1 Scores'!B30","v":0},{"$f":"'L1 Scores'!O30","v":0},{"$f":"'L1 Scores'!U30","v":0},{"$f":"'L1 Scores'!Y30","v":0},{"$f":"IF(F24>18,\"GOLD\",IF(F24>16,\"SILVER\",IF(F24>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A28","v":0},{"$f":"'L1 Scores'!B28","v":0},{"$f":"'L1 Scores'!O28","v":0},{"$f":"'L1 Scores'!U28","v":0},{"$f":"'L1 Scores'!Y28","v":0},{"$f":"IF(F25>18,\"GOLD\",IF(F25>16,\"SILVER\",IF(F25>0,\"BRONZE\",\"\")))","v":""}]
[]
[null,"MIXED"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[null,{"$f":"'L1 Scores'!A33","v":0},{"$f":"'L1 Scores'!B33","v":0},{"$f":"'L1 Scores'!O33","v":0},{"$f":"'L1 Scores'!U33","v":0},{"$f":"'L1 Scores'!Y33","v":0},{"$f":"IF(F30>18,\"GOLD\",IF(F30>16,\"SILVER\",IF(F30>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A32","v":0},{"$f":"'L1 Scores'!B32","v":0},{"$f":"'L1 Scores'!O32","v":0},{"$f":"'L1 Scores'!U32","v":0},{"$f":"'L1 Scores'!Y32","v":0},{"$f":"IF(F31>18,\"GOLD\",IF(F31>16,\"SILVER\",IF(F31>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A31","v":0},{"$f":"'L1 Scores'!B31","v":0},{"$f":"'L1 Scores'!O31","v":0},{"$f":"'L1 Scores'!U31","v":0},{"$f":"'L1 Scores'!Y31","v":0},{"$f":"IF(F32>18,\"GOLD\",IF(F32>16,\"SILVER\",IF(F32>0,\"BRONZE\",\"\")))","v":""}]
[]
[null,"HUGS (Hope Unites Gymnastics with Special Needs)"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[null,{"$f":"'L1 Scores'!A34","v":0},{"$f":"'L1 Scores'!B34","v":0},{"$f":"'L1 Scores'!O34","v":0},{"$f":"'L1 Scores'!U34","v":0},{"$f":"'L1 Scores'!Y34","v":0},{"$f":"IF(F37>18,\"GOLD\",IF(F37>16,\"SILVER\",IF(F37>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A36","v":0},{"$f":"'L1 Scores'!B36","v":0},{"$f":"'L1 Scores'!O36","v":0},{"$f":"'L1 Scores'!U36","v":0},{"$f":"'L1 Scores'!Y36","v":0},{"$f":"IF(F38>18,\"GOLD\",IF(F38>16,\"SILVER\",IF(F38>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A35","v":0},{"$f":"'L1 Scores'!B35","v":0},{"$f":"'L1 Scores'!O35","v":0},{"$f":"'L1 Scores'!U35","v":0},{"$f":"'L1 Scores'!Y35","v":0},{"$f":"IF(F39>18,\"GOLD\",IF(F39>16,\"SILVER\",IF(F39>0,\"BRONZE\",\"\")))","v":""}]
[]
[null,"UNIFIED"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[null,{"$f":"'L1 Scores'!A37","v":0},{"$f":"'L1 Scores'!B37","v":0},{"$f":"'L1 Scores'!O37","v":0},{"$f":"'L1 Scores'!U37","v":0},{"$f":"'L1 Scores'!Y37","v":0},{"$f":"IF(F44>18,\"GOLD\",IF(F44>16,\"SILVER\",IF(F44>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A39","v":0},{"$f":"'L1 Scores'!B39","v":0},{"$f":"'L1 Scores'!O39","v":0},{"$f":"'L1 Scores'!U39","v":0},{"$f":"'L1 Scores'!Y39","v":0},{"$f":"IF(F45>18,\"GOLD\",IF(F45>16,\"SILVER\",IF(F45>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L1 Scores'!A38","v":0},{"$f":"'L1 Scores'!B38","v":0},{"$f":"'L1 Scores'!O38","v":0},{"$f":"'L1 Scores'!U38","v":0},{"$f":"'L1 Scores'!Y38","v":0},{"$f":"IF(F46>18,\"GOLD\",IF(F46>16,\"SILVER\",IF(F46>0,\"BRONZE\",\"\")))","v":""}]
[]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L2 Scores","index":5,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,5,13,8],[13,9,13,12],[13,13,13,14]]}
["Power TeamGym Scoresheet for Level 2",null,null,null,null,null,null,null,2]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team Score Range",null,"Category"]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18 - 20",null,"GOLD"]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 - 17.99",null,"SILVER"]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"below 16",null,"BRONZE"]
[null,null,"Use","HUGS","HUGS (Hope Unites Gymnastics with Special Needs): Squads composed solely of HUGS athletes, male or female regardless of ratio."]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet","UNI","UNIFIED: Squads that have any combination of HUGS and “Unified Partners” (athletes without disabilities or special needs)."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information"]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!",null,"Important Note: \"Group\" the squads below in their correct division."]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1",null,null,null,"Judge 2",null,null,null,"Sub Totals",null,"Neu","JUMP",null,null,null,"Bon","Neu","FX",null,"sub-","Head Judge",null,"MEDAL"]
["Club","Team Name","Sqd","Division",null,"TU Pass 1","TU Pass 2","VT","MT","TU Pass 1","TU Pass 2","VT","MT","Avg J1","Avg J2","-","Score",".","J-1","J-2","+","-","Score",".","final","Deductions","FINAL","COLOR"]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F16:G16),H16,I16),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J16:K16),L16,M16),0)","v":0},null,{"$f":"IF(O16=0,N16-P16,((N16+O16)/2)-P16)","v":0},null,null,null,null,null,{"$f":"IF(T16=0,S16+U16-V16,((S16+T16)/2)+U16-V16)","v":0},null,{"$f":"W16+Q16","v":0},null,{"$f":"Y16-Z16","v":0},{"$f":"IF(AA16>18,\"GOLD\",IF(AA16>16,\"SILVER\",IF(AA16>0,\"BRONZE\",\"\")))","v":""}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F17:G17),H17,I17),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J17:K17),L17,M17),0)","v":0},null,0,null,null,null,null,null,0,null,0,null,{"$f":"Y17-Z17","v":0},{"$f":"IF(AA17>18,\"GOLD\",IF(AA17>16,\"SILVER\",IF(AA17>0,\"BRONZE\",\"\")))","v":""}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,{"$f":"IF(AA18>18,\"GOLD\",IF(AA18>16,\"SILVER\",IF(AA18>0,\"BRONZE\",\"\")))","v":""}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F24:G24),H24,I24),0)","v":0},0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"ADSN",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0,""]
[null,null,null,"UNI",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,{"$f":"(Q39+W39)-Z39","v":0},""]

{"sheet":"L2 Final","index":6,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 2",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L2 Scores\""]
[null,"Qualifying score for Nationals is 15 or >"]
[null,"OPEN FEMALE"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","MEDAL COLOR",null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L2 Scores'!A16","v":0},{"$f":"'L2 Scores'!B16","v":0},{"$f":"'L2 Scores'!Q16","v":0},{"$f":"'L2 Scores'!W16","v":0},{"$f":"'L2 Scores'!AA16","v":0},{"$f":"IF(F7>18,\"GOLD\",IF(F7>16,\"SILVER\",IF(F7>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A22","v":0},{"$f":"'L2 Scores'!B22","v":0},{"$f":"'L2 Scores'!Q22","v":0},{"$f":"'L2 Scores'!W22","v":0},{"$f":"'L2 Scores'!AA22","v":0},""]
[null,{"$f":"'L2 Scores'!A23","v":0},{"$f":"'L2 Scores'!B23","v":0},{"$f":"'L2 Scores'!Q23","v":0},{"$f":"'L2 Scores'!W23","v":0},{"$f":"'L2 Scores'!AA23","v":0},""]
[null,{"$f":"'L2 Scores'!A21","v":0},{"$f":"'L2 Scores'!B21","v":0},{"$f":"'L2 Scores'!Q21","v":0},{"$f":"'L2 Scores'!W21","v":0},{"$f":"'L2 Scores'!AA21","v":0},""]
[null,{"$f":"'L2 Scores'!A19","v":0},{"$f":"'L2 Scores'!B19","v":0},{"$f":"'L2 Scores'!Q19","v":0},{"$f":"'L2 Scores'!W19","v":0},{"$f":"'L2 Scores'!AA19","v":0},""]
[null,{"$f":"'L2 Scores'!A20","v":0},{"$f":"'L2 Scores'!B20","v":0},{"$f":"'L2 Scores'!Q20","v":0},{"$f":"'L2 Scores'!W20","v":0},{"$f":"'L2 Scores'!AA20","v":0},""]
[null,{"$f":"'L2 Scores'!A17","v":0},{"$f":"'L2 Scores'!B17","v":0},{"$f":"'L2 Scores'!Q17","v":0},{"$f":"'L2 Scores'!W17","v":0},{"$f":"'L2 Scores'!AA17","v":0},""]
[null,{"$f":"'L2 Scores'!A24","v":0},{"$f":"'L2 Scores'!B24","v":0},{"$f":"'L2 Scores'!Q24","v":0},{"$f":"'L2 Scores'!W24","v":0},{"$f":"'L2 Scores'!AA24","v":0},""]
[null,{"$f":"'L2 Scores'!A18","v":0},{"$f":"'L2 Scores'!B18","v":0},{"$f":"'L2 Scores'!Q18","v":0},{"$f":"'L2 Scores'!W18","v":0},{"$f":"'L2 Scores'!AA18","v":0},""]
[null,{"$f":"'L2 Scores'!A25","v":0},{"$f":"'L2 Scores'!B25","v":0},{"$f":"'L2 Scores'!Q25","v":0},{"$f":"'L2 Scores'!W25","v":0},{"$f":"'L2 Scores'!AA25","v":0},""]
[null,{"$f":"'L2 Scores'!A26","v":0},{"$f":"'L2 Scores'!B26","v":0},{"$f":"'L2 Scores'!Q26","v":0},{"$f":"'L2 Scores'!W26","v":0},{"$f":"'L2 Scores'!AA26","v":0},""]
[null,{"$f":"'L2 Scores'!A27","v":0},{"$f":"'L2 Scores'!B27","v":0},{"$f":"'L2 Scores'!Q27","v":0},{"$f":"'L2 Scores'!W27","v":0},{"$f":"'L2 Scores'!AA27","v":0},""]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","MEDAL COLOR"]
[null,{"$f":"'L2 Scores'!A30","v":0},{"$f":"'L2 Scores'!B30","v":0},{"$f":"'L2 Scores'!Q30","v":0},{"$f":"'L2 Scores'!W30","v":0},{"$f":"'L2 Scores'!AA30","v":0},{"$f":"IF(F22>18,\"GOLD\",IF(F22>16,\"SILVER\",IF(F22>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A28","v":0},{"$f":"'L2 Scores'!B28","v":0},{"$f":"'L2 Scores'!Q28","v":0},{"$f":"'L2 Scores'!W28","v":0},{"$f":"'L2 Scores'!AA28","v":0},{"$f":"IF(F23>18,\"GOLD\",IF(F23>16,\"SILVER\",IF(F23>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A29","v":0},{"$f":"'L2 Scores'!B29","v":0},{"$f":"'L2 Scores'!Q29","v":0},{"$f":"'L2 Scores'!W29","v":0},{"$f":"'L2 Scores'!AA29","v":0},{"$f":"IF(F24>18,\"GOLD\",IF(F24>16,\"SILVER\",IF(F24>0,\"BRONZE\",\"\")))","v":""}]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","MEDAL COLOR"]
[null,{"$f":"'L2 Scores'!A32","v":0},{"$f":"'L2 Scores'!B32","v":0},{"$f":"'L2 Scores'!Q32","v":0},{"$f":"'L2 Scores'!W32","v":0},{"$f":"'L2 Scores'!AA32","v":0},{"$f":"IF(F28>18,\"GOLD\",IF(F28>16,\"SILVER\",IF(F28>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A33","v":0},{"$f":"'L2 Scores'!B33","v":0},{"$f":"'L2 Scores'!Q33","v":0},{"$f":"'L2 Scores'!W33","v":0},{"$f":"'L2 Scores'!AA33","v":0},{"$f":"IF(F29>18,\"GOLD\",IF(F29>16,\"SILVER\",IF(F29>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A31","v":0},{"$f":"'L2 Scores'!B31","v":0},{"$f":"'L2 Scores'!Q31","v":0},{"$f":"'L2 Scores'!W31","v":0},{"$f":"'L2 Scores'!AA31","v":0},{"$f":"IF(F30>18,\"GOLD\",IF(F30>16,\"SILVER\",IF(F30>0,\"BRONZE\",\"\")))","v":""}]
[]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","MEDAL COLOR"]
[null,{"$f":"'L2 Scores'!A34","v":0},{"$f":"'L2 Scores'!B34","v":0},{"$f":"'L2 Scores'!Q34","v":0},{"$f":"'L2 Scores'!W34","v":0},{"$f":"'L2 Scores'!AA34","v":0},{"$f":"IF(F34>18,\"GOLD\",IF(F34>16,\"SILVER\",IF(F34>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A35","v":0},{"$f":"'L2 Scores'!B35","v":0},{"$f":"'L2 Scores'!Q35","v":0},{"$f":"'L2 Scores'!W35","v":0},{"$f":"'L2 Scores'!AA35","v":0},{"$f":"IF(F35>18,\"GOLD\",IF(F35>16,\"SILVER\",IF(F35>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A36","v":0},{"$f":"'L2 Scores'!B36","v":0},{"$f":"'L2 Scores'!Q36","v":0},{"$f":"'L2 Scores'!W36","v":0},{"$f":"'L2 Scores'!AA36","v":0},{"$f":"IF(F36>18,\"GOLD\",IF(F36>16,\"SILVER\",IF(F36>0,\"BRONZE\",\"\")))","v":""}]
[]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","MEDAL COLOR"]
[null,{"$f":"'L2 Scores'!A39","v":0},{"$f":"'L2 Scores'!B39","v":0},{"$f":"'L2 Scores'!Q39","v":0},{"$f":"'L2 Scores'!W39","v":0},{"$f":"'L2 Scores'!AA39","v":0},{"$f":"IF(F40>18,\"GOLD\",IF(F40>16,\"SILVER\",IF(F40>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A38","v":0},{"$f":"'L2 Scores'!B38","v":0},{"$f":"'L2 Scores'!Q38","v":0},{"$f":"'L2 Scores'!W38","v":0},{"$f":"'L2 Scores'!AA38","v":0},{"$f":"IF(F41>18,\"GOLD\",IF(F41>16,\"SILVER\",IF(F41>0,\"BRONZE\",\"\")))","v":""}]
[null,{"$f":"'L2 Scores'!A37","v":0},{"$f":"'L2 Scores'!B37","v":0},{"$f":"'L2 Scores'!Q37","v":0},{"$f":"'L2 Scores'!W37","v":0},{"$f":"'L2 Scores'!AA37","v":0},{"$f":"IF(F42>18,\"GOLD\",IF(F42>16,\"SILVER\",IF(F42>0,\"BRONZE\",\"\")))","v":""}]
[]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L3 Scores","index":7,"n_rows":32,"n_cols":27,"rows_kept":32,"cut":false,"hidden":false,"merged":[[12,5,12,8],[12,9,12,12],[12,13,12,14]]}
["Power TeamGym Scoresheet for Level 3",null,null,null,null,null,null,null,3]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division"]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet"]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information",null,null,"Important Note: Group squads by division on this tabulation sheet."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},""]
[null,null,null,null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1",null,null,null,"Judge 2",null,null,null,"Sub Totals",null,"Neu","JUMP",null,null,null,"Bon","Neu","FX",null,"sub-","Head Judge"]
["Club","Team Name","Sqd","Division",null,"TU Pass 1","TU Pass 2","VT","MT","TU Pass 1","TU Pass 2","VT","MT","Avg J1","Avg J2","-","Score",".","J-1","J-2","+","-","Score",".","final","Deductions","FINAL"]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F15:G15),H15,I15),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J15:K15),L15,M15),0)","v":0},null,{"$f":"IF(O15=0,N15-P15,((N15+O15)/2)-P15)","v":0},null,null,null,null,null,{"$f":"IF(T15=0,S15+U15-V15,((S15+T15)/2)+U15-V15)","v":0},null,{"$f":"W15+Q15","v":0},null,{"$f":"(Q15+W15)-Z15","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F16:G16),H16,I16),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J16:K16),L16,M16),0)","v":0},null,{"$f":"IF(O16=0,N16-P16,((N16+O16)/2)-P16)","v":0},null,null,null,null,null,{"$f":"IF(T16=0,S16+U16-V16,((S16+T16)/2)+U16-V16)","v":0},null,{"$f":"W16+Q16","v":0},null,{"$f":"(Q16+W16)-Z16","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F17:G17),H17,I17),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J17:K17),L17,M17),0)","v":0},null,{"$f":"IF(O17=0,N17-P17,((N17+O17)/2)-P17)","v":0},null,null,null,null,null,{"$f":"IF(T17=0,S17+U17-V17,((S17+T17)/2)+U17-V17)","v":0},null,{"$f":"W17+Q17","v":0},null,{"$f":"(Q17+W17)-Z17","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F18:G18),H18,I18),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J18:K18),L18,M18),0)","v":0},null,{"$f":"IF(O18=0,N18-P18,((N18+O18)/2)-P18)","v":0},null,null,null,null,null,{"$f":"IF(T18=0,S18+U18-V18,((S18+T18)/2)+U18-V18)","v":0},null,{"$f":"W18+Q18","v":0},null,{"$f":"(Q18+W18)-Z18","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F19:G19),H19,I19),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J19:K19),L19,M19),0)","v":0},null,{"$f":"IF(O19=0,N19-P19,((N19+O19)/2)-P19)","v":0},null,null,null,null,null,{"$f":"IF(T19=0,S19+U19-V19,((S19+T19)/2)+U19-V19)","v":0},null,{"$f":"W19+Q19","v":0},null,{"$f":"(Q19+W19)-Z19","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F20:G20),H20,I20),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J20:K20),L20,M20),0)","v":0},null,{"$f":"IF(O20=0,N20-P20,((N20+O20)/2)-P20)","v":0},null,null,null,null,null,{"$f":"IF(T20=0,S20+U20-V20,((S20+T20)/2)+U20-V20)","v":0},null,{"$f":"W20+Q20","v":0},null,{"$f":"(Q20+W20)-Z20","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,null,0,null,null,null,null,null,0,null,0,null,0]

{"sheet":"L3 Final","index":8,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 3",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L3 Scores\""]
[null,"Qualifying score for Nationals is 15 or >"]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L3 Scores'!A18","v":0},{"$f":"'L3 Scores'!B18","v":0},{"$f":"'L3 Scores'!Q18","v":0},{"$f":"'L3 Scores'!W18","v":0},{"$f":"'L3 Scores'!AA18","v":0},1,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L3 Scores'!A19","v":0},{"$f":"'L3 Scores'!B19","v":0},{"$f":"'L3 Scores'!Q19","v":0},{"$f":"'L3 Scores'!W19","v":0},{"$f":"'L3 Scores'!AA19","v":0},2]
[null,{"$f":"'L3 Scores'!A17","v":0},{"$f":"'L3 Scores'!B17","v":0},{"$f":"'L3 Scores'!Q17","v":0},{"$f":"'L3 Scores'!W17","v":0},{"$f":"'L3 Scores'!AA17","v":0},3]
[null,{"$f":"'L3 Scores'!A16","v":0},{"$f":"'L3 Scores'!B16","v":0},{"$f":"'L3 Scores'!Q16","v":0},{"$f":"'L3 Scores'!W16","v":0},{"$f":"'L3 Scores'!AA16","v":0},4]
[null,{"$f":"'L3 Scores'!A15","v":0},{"$f":"'L3 Scores'!B15","v":0},{"$f":"'L3 Scores'!Q15","v":0},{"$f":"'L3 Scores'!W15","v":0},{"$f":"'L3 Scores'!AA15","v":0},5]
[null,{"$f":"'L3 Scores'!A20","v":0},{"$f":"'L3 Scores'!B20","v":0},{"$f":"'L3 Scores'!Q20","v":0},{"$f":"'L3 Scores'!W20","v":0},{"$f":"'L3 Scores'!AA20","v":0},6]
[null,{"$f":"'L3 Scores'!A21","v":0},{"$f":"'L3 Scores'!B21","v":0},{"$f":"'L3 Scores'!Q21","v":0},{"$f":"'L3 Scores'!W21","v":0},{"$f":"'L3 Scores'!AA21","v":0},7]
[null,{"$f":"'L3 Scores'!A22","v":0},{"$f":"'L3 Scores'!B22","v":0},{"$f":"'L3 Scores'!Q22","v":0},{"$f":"'L3 Scores'!W22","v":0},{"$f":"'L3 Scores'!AA22","v":0},8]
[null,{"$f":"'L3 Scores'!A23","v":0},{"$f":"'L3 Scores'!B23","v":0},{"$f":"'L3 Scores'!Q23","v":0},{"$f":"'L3 Scores'!W23","v":0},{"$f":"'L3 Scores'!AA23","v":0},9]
[null,{"$f":"'L3 Scores'!A24","v":0},{"$f":"'L3 Scores'!B24","v":0},{"$f":"'L3 Scores'!Q24","v":0},{"$f":"'L3 Scores'!W24","v":0},{"$f":"'L3 Scores'!AA24","v":0},10]
[null,{"$f":"'L3 Scores'!A25","v":0},{"$f":"'L3 Scores'!B25","v":0},{"$f":"'L3 Scores'!Q25","v":0},{"$f":"'L3 Scores'!W25","v":0},{"$f":"'L3 Scores'!AA25","v":0},11]
[null,{"$f":"'L3 Scores'!A26","v":0},{"$f":"'L3 Scores'!B26","v":0},{"$f":"'L3 Scores'!Q26","v":0},{"$f":"'L3 Scores'!W26","v":0},{"$f":"'L3 Scores'!AA26","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L3 Scores'!A27","v":0},{"$f":"'L3 Scores'!B27","v":0},{"$f":"'L3 Scores'!Q27","v":0},{"$f":"'L3 Scores'!W27","v":0},{"$f":"'L3 Scores'!AA27","v":0},1]
[null,{"$f":"'L3 Scores'!A28","v":0},{"$f":"'L3 Scores'!B28","v":0},{"$f":"'L3 Scores'!Q28","v":0},{"$f":"'L3 Scores'!W28","v":0},{"$f":"'L3 Scores'!AA28","v":0},2]
[null,{"$f":"'L3 Scores'!A29","v":0},{"$f":"'L3 Scores'!B29","v":0},{"$f":"'L3 Scores'!Q29","v":0},{"$f":"'L3 Scores'!W29","v":0},{"$f":"'L3 Scores'!AA29","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L3 Scores'!A31","v":0},{"$f":"'L3 Scores'!B31","v":0},{"$f":"'L3 Scores'!Q31","v":0},{"$f":"'L3 Scores'!W31","v":0},{"$f":"'L3 Scores'!AA31","v":0},1]
[null,{"$f":"'L3 Scores'!A32","v":0},{"$f":"'L3 Scores'!B32","v":0},{"$f":"'L3 Scores'!Q32","v":0},{"$f":"'L3 Scores'!W32","v":0},{"$f":"'L3 Scores'!AA32","v":0},2]
[null,{"$f":"'L3 Scores'!A30","v":0},{"$f":"'L3 Scores'!B30","v":0},{"$f":"'L3 Scores'!Q30","v":0},{"$f":"'L3 Scores'!W30","v":0},{"$f":"'L3 Scores'!AA30","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L4 Scores","index":9,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,5,11,8],[11,9,11,12],[11,13,11,14]]}
["Power TeamGym Scoresheet for Level 4",null,null,null,null,null,null,null,4]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet"]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!"]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"",null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#on",null,null,"Judge 1",null,null,null,"Judge 2",null,null,null,"Sub Totals",null,"JUMP",null,null,null,"FX",null,"Final","HEAD JUDGE","FINAL"]
["Club","Team Name","Sqd","Division",null,"TU Pass 1","TU Pass 2","VT","MT","TU Pass 1","TU Pass 2","VT","MT","Avg J1","Avg J2","Score",null,"J-1","J-2","Score",null,"Subtotal","Deductions","SCORE"]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F14:G14),H14,I14),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J14:K14),L14,M14),0)","v":0},{"$f":"IF(O14=0,N14-O14,((N14+O14)/2))","v":0},null,null,null,{"$f":"IF(S14=0,R14,((R14+S14)/2))","v":0},null,{"$f":"T14+P14","v":0},null,{"$f":"(P14+T14)+W14","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F15:G15),H15,I15),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J15:K15),L15,M15),0)","v":0},{"$f":"IF(O15=0,N15-O15,((N15+O15)/2))","v":0},null,null,null,0,null,0,null,{"$f":"(P15+T15)+W15","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(O16=0,N16-O16,((N16+O16)/2))","v":0},null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L4 Final","index":10,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 4",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L4 Scores\""]
[null,"Qualifying score for Nationals is 16 or >"]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L4 Scores'!A17","v":0},{"$f":"'L4 Scores'!B17","v":0},{"$f":"'L4 Scores'!P17","v":0},{"$f":"'L4 Scores'!T17","v":0},{"$f":"'L4 Scores'!X17","v":0},1,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L4 Scores'!A14","v":0},{"$f":"'L4 Scores'!B14","v":0},{"$f":"'L4 Scores'!P14","v":0},{"$f":"'L4 Scores'!T14","v":0},{"$f":"'L4 Scores'!X14","v":0},2]
[null,{"$f":"'L4 Scores'!A15","v":0},{"$f":"'L4 Scores'!B15","v":0},{"$f":"'L4 Scores'!P15","v":0},{"$f":"'L4 Scores'!T15","v":0},{"$f":"'L4 Scores'!X15","v":0},3]
[null,{"$f":"'L4 Scores'!A16","v":0},{"$f":"'L4 Scores'!B16","v":0},{"$f":"'L4 Scores'!P16","v":0},{"$f":"'L4 Scores'!T16","v":0},{"$f":"'L4 Scores'!X16","v":0},4]
[null,{"$f":"'L4 Scores'!A19","v":0},{"$f":"'L4 Scores'!B19","v":0},{"$f":"'L4 Scores'!P19","v":0},{"$f":"'L4 Scores'!T19","v":0},{"$f":"'L4 Scores'!X19","v":0},5]
[null,{"$f":"'L4 Scores'!A18","v":0},{"$f":"'L4 Scores'!B18","v":0},{"$f":"'L4 Scores'!P18","v":0},{"$f":"'L4 Scores'!T18","v":0},{"$f":"'L4 Scores'!X18","v":0},6]
[null,{"$f":"'L4 Scores'!A20","v":0},{"$f":"'L4 Scores'!B20","v":0},{"$f":"'L4 Scores'!P20","v":0},{"$f":"'L4 Scores'!T20","v":0},{"$f":"'L4 Scores'!X20","v":0},7]
[null,{"$f":"'L4 Scores'!A21","v":0},{"$f":"'L4 Scores'!B21","v":0},{"$f":"'L4 Scores'!P21","v":0},{"$f":"'L4 Scores'!T21","v":0},{"$f":"'L4 Scores'!X21","v":0},8]
[null,{"$f":"'L4 Scores'!A22","v":0},{"$f":"'L4 Scores'!B22","v":0},{"$f":"'L4 Scores'!P22","v":0},{"$f":"'L4 Scores'!T22","v":0},{"$f":"'L4 Scores'!X22","v":0},9]
[null,{"$f":"'L4 Scores'!A23","v":0},{"$f":"'L4 Scores'!B23","v":0},{"$f":"'L4 Scores'!P23","v":0},{"$f":"'L4 Scores'!T23","v":0},{"$f":"'L4 Scores'!X23","v":0},10]
[null,{"$f":"'L4 Scores'!A24","v":0},{"$f":"'L4 Scores'!B24","v":0},{"$f":"'L4 Scores'!P24","v":0},{"$f":"'L4 Scores'!T24","v":0},{"$f":"'L4 Scores'!X24","v":0},11]
[null,{"$f":"'L4 Scores'!A25","v":0},{"$f":"'L4 Scores'!B25","v":0},{"$f":"'L4 Scores'!P25","v":0},{"$f":"'L4 Scores'!T25","v":0},{"$f":"'L4 Scores'!X25","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L4 Scores'!A26","v":0},{"$f":"'L4 Scores'!B26","v":0},{"$f":"'L4 Scores'!P26","v":0},{"$f":"'L4 Scores'!T26","v":0},{"$f":"'L4 Scores'!X26","v":0},1]
[null,{"$f":"'L4 Scores'!A27","v":0},{"$f":"'L4 Scores'!B27","v":0},{"$f":"'L4 Scores'!P27","v":0},{"$f":"'L4 Scores'!T27","v":0},{"$f":"'L4 Scores'!X27","v":0},2]
[null,{"$f":"'L4 Scores'!A28","v":0},{"$f":"'L4 Scores'!B28","v":0},{"$f":"'L4 Scores'!P28","v":0},{"$f":"'L4 Scores'!T28","v":0},{"$f":"'L4 Scores'!X28","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L4 Scores'!A31","v":0},{"$f":"'L4 Scores'!B31","v":0},{"$f":"'L4 Scores'!P31","v":0},{"$f":"'L4 Scores'!T31","v":0},{"$f":"'L4 Scores'!X31","v":0},1]
[null,{"$f":"'L4 Scores'!A30","v":0},{"$f":"'L4 Scores'!B30","v":0},{"$f":"'L4 Scores'!P30","v":0},{"$f":"'L4 Scores'!T30","v":0},{"$f":"'L4 Scores'!X30","v":0},2]
[null,{"$f":"'L4 Scores'!A29","v":0},{"$f":"'L4 Scores'!B29","v":0},{"$f":"'L4 Scores'!P29","v":0},{"$f":"'L4 Scores'!T29","v":0},{"$f":"'L4 Scores'!X29","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L5 Scores","index":11,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,5,11,8],[11,9,11,12],[11,13,11,14]]}
["Power TeamGym Scoresheet for Level 5",null,null,null,null,null,null,null,5]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet"]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!"]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"",null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#on",null,null,"Judge 1",null,null,null,"Judge 2",null,null,null,"Sub Totals",null,"JUMP",null,null,null,"FX",null,"Final","HEAD JUDGE","FINAL"]
["Club","Team Name","Sqd","Division",null,"TU Pass 1","TU Pass 2","Highest VT","MT","TU Pass 1","TU Pass 2","Highest VT","MT","Avg J1","Avg J2","Score",null,"J-1","J-2","Score",null,"Subtotal","Deductions","SCORE"]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F14:G14),H14,I14),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J14:K14),L14,M14),0)","v":0},{"$f":"IF(O14=0,N14,(N14+O14)/2)","v":0},null,null,null,{"$f":"IF(S14=0,R14,((R14+S14)/2))","v":0},null,{"$f":"T14+P14","v":0},null,{"$f":"(P14+T14)+W14","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(AVERAGE(AVERAGE(J15:K15),L15,M15),0)","v":0},0,null,null,null,{"$f":"IF(S15=0,R15,((R15+S15)/2))","v":0},null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F16:G16),H16,I16),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J16:K16),L16,M16),0)","v":0},0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F26:G26),H26,I26),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J26:K26),L26,M26),0)","v":0},0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L5 Final","index":12,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 5",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L5 Scores\""]
[null,"Qualifying score for Nationals is 16 or >"]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L5 Scores'!A17","v":0},{"$f":"'L5 Scores'!B17","v":0},{"$f":"'L5 Scores'!P17","v":0},{"$f":"'L5 Scores'!T17","v":0},{"$f":"'L5 Scores'!X17","v":0},1,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L5 Scores'!A14","v":0},{"$f":"'L5 Scores'!B14","v":0},{"$f":"'L5 Scores'!P14","v":0},{"$f":"'L5 Scores'!T14","v":0},{"$f":"'L5 Scores'!X14","v":0},2]
[null,{"$f":"'L5 Scores'!A15","v":0},{"$f":"'L5 Scores'!B15","v":0},{"$f":"'L5 Scores'!P15","v":0},{"$f":"'L5 Scores'!T15","v":0},{"$f":"'L5 Scores'!X15","v":0},3]
[null,{"$f":"'L5 Scores'!A16","v":0},{"$f":"'L5 Scores'!B16","v":0},{"$f":"'L5 Scores'!P16","v":0},{"$f":"'L5 Scores'!T16","v":0},{"$f":"'L5 Scores'!X16","v":0},4]
[null,{"$f":"'L5 Scores'!A19","v":0},{"$f":"'L5 Scores'!B19","v":0},{"$f":"'L5 Scores'!P19","v":0},{"$f":"'L5 Scores'!T19","v":0},{"$f":"'L5 Scores'!X19","v":0},5]
[null,{"$f":"'L5 Scores'!A18","v":0},{"$f":"'L5 Scores'!B18","v":0},{"$f":"'L5 Scores'!P18","v":0},{"$f":"'L5 Scores'!T18","v":0},{"$f":"'L5 Scores'!X18","v":0},6]
[null,{"$f":"'L5 Scores'!A20","v":0},{"$f":"'L5 Scores'!B20","v":0},{"$f":"'L5 Scores'!P20","v":0},{"$f":"'L5 Scores'!T20","v":0},{"$f":"'L5 Scores'!X20","v":0},7]
[null,{"$f":"'L5 Scores'!A21","v":0},{"$f":"'L5 Scores'!B21","v":0},{"$f":"'L5 Scores'!P21","v":0},{"$f":"'L5 Scores'!T21","v":0},{"$f":"'L5 Scores'!X21","v":0},8]
[null,{"$f":"'L5 Scores'!A22","v":0},{"$f":"'L5 Scores'!B22","v":0},{"$f":"'L5 Scores'!P22","v":0},{"$f":"'L5 Scores'!T22","v":0},{"$f":"'L5 Scores'!X22","v":0},9]
[null,{"$f":"'L5 Scores'!A23","v":0},{"$f":"'L5 Scores'!B23","v":0},{"$f":"'L5 Scores'!P23","v":0},{"$f":"'L5 Scores'!T23","v":0},{"$f":"'L5 Scores'!X23","v":0},10]
[null,{"$f":"'L5 Scores'!A24","v":0},{"$f":"'L5 Scores'!B24","v":0},{"$f":"'L5 Scores'!P24","v":0},{"$f":"'L5 Scores'!T24","v":0},{"$f":"'L5 Scores'!X24","v":0},11]
[null,{"$f":"'L5 Scores'!A25","v":0},{"$f":"'L5 Scores'!B25","v":0},{"$f":"'L5 Scores'!P25","v":0},{"$f":"'L5 Scores'!T25","v":0},{"$f":"'L5 Scores'!X25","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L5 Scores'!A27","v":0},{"$f":"'L5 Scores'!B27","v":0},{"$f":"'L5 Scores'!P27","v":0},{"$f":"'L5 Scores'!T27","v":0},{"$f":"'L5 Scores'!X27","v":0},1]
[null,{"$f":"'L5 Scores'!A26","v":0},{"$f":"'L5 Scores'!B26","v":0},{"$f":"'L5 Scores'!P26","v":0},{"$f":"'L5 Scores'!T26","v":0},{"$f":"'L5 Scores'!X26","v":0},2]
[null,{"$f":"'L5 Scores'!A28","v":0},{"$f":"'L5 Scores'!B28","v":0},{"$f":"'L5 Scores'!P28","v":0},{"$f":"'L5 Scores'!T28","v":0},{"$f":"'L5 Scores'!X28","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L5 Scores'!A31","v":0},{"$f":"'L5 Scores'!B31","v":0},{"$f":"'L5 Scores'!P31","v":0},{"$f":"'L5 Scores'!T31","v":0},{"$f":"'L5 Scores'!X31","v":0},1]
[null,{"$f":"'L5 Scores'!A30","v":0},{"$f":"'L5 Scores'!B30","v":0},{"$f":"'L5 Scores'!P30","v":0},{"$f":"'L5 Scores'!T30","v":0},{"$f":"'L5 Scores'!X30","v":0},2]
[null,{"$f":"'L5 Scores'!A29","v":0},{"$f":"'L5 Scores'!B29","v":0},{"$f":"'L5 Scores'!P29","v":0},{"$f":"'L5 Scores'!T29","v":0},{"$f":"'L5 Scores'!X29","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L6 Scores","index":13,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,13,11,14],[11,5,11,8],[11,9,11,12]]}
["Power TeamGym Scoresheet for Level 6",null,null,null,null,null,null,null,6]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet"]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information",null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!"]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"",null,null,"GROUP JUMP",null,null,null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#on",null,null,"Judge 1",null,null,null,"Judge 2",null,null,null,"Sub Totals",null,"JUMP",null,null,null,"FX",null,"Final","HEAD JUDGE","FINAL"]
["Club","Team Name","Sqd","Division",null,"TU Pass 1","TU Pass 2","Highest VT","MT","TU Pass 1","TU Pass 2","Highest VT","MT","Avg J1","Avg J2","Score",null,"J-1","J-2","Score",null,"Subtotal","Deductions","SCORE"]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F14:G14),H14,I14),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J14:K14),L14,M14),0)","v":0},{"$f":"IF(O14=0,N14,(N14+O14)/2)","v":0},null,null,null,{"$f":"IF(S14=0,R14,((R14+S14)/2))","v":0},null,{"$f":"T14+P14","v":0},null,{"$f":"(P14+T14)+W14","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AVERAGE(F15:G15),H15,I15),0)","v":0},{"$f":"IFERROR(AVERAGE(AVERAGE(J15:K15),L15,M15),0)","v":0},{"$f":"IF(O15=0,N15,(N15+O15)/2)","v":0},null,null,null,{"$f":"IF(S15=0,R15,((R15+S15)/2))","v":0},null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L6 Final","index":14,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results Level 6",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheet labelled \"L6 Scores\""]
[null,"Qualifying score for Nationals is 16 or >"]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L6 Scores'!A14","v":0},{"$f":"'L6 Scores'!B14","v":0},{"$f":"'L6 Scores'!P14","v":0},{"$f":"'L6 Scores'!T14","v":0},{"$f":"'L6 Scores'!X14","v":0},1,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L6 Scores'!A15","v":0},{"$f":"'L6 Scores'!B15","v":0},{"$f":"'L6 Scores'!P15","v":0},{"$f":"'L6 Scores'!T15","v":0},{"$f":"'L6 Scores'!X15","v":0},2]
[null,{"$f":"'L6 Scores'!A18","v":0},{"$f":"'L6 Scores'!B18","v":0},{"$f":"'L6 Scores'!O16","v":0},{"$f":"'L6 Scores'!T18","v":0},{"$f":"'L6 Scores'!X18","v":0},3]
[null,{"$f":"'L6 Scores'!A16","v":0},{"$f":"'L6 Scores'!B16","v":0},{"$f":"'L6 Scores'!O17","v":0},{"$f":"'L6 Scores'!T16","v":0},{"$f":"'L6 Scores'!X16","v":0},4]
[null,{"$f":"'L6 Scores'!A19","v":0},{"$f":"'L6 Scores'!B19","v":0},{"$f":"'L6 Scores'!O18","v":0},{"$f":"'L6 Scores'!T19","v":0},{"$f":"'L6 Scores'!X19","v":0},5]
[null,{"$f":"'L6 Scores'!A17","v":0},{"$f":"'L6 Scores'!B17","v":0},{"$f":"'L6 Scores'!O19","v":0},{"$f":"'L6 Scores'!T17","v":0},{"$f":"'L6 Scores'!X17","v":0},6]
[null,{"$f":"'L6 Scores'!A20","v":0},{"$f":"'L6 Scores'!B20","v":0},{"$f":"'L6 Scores'!O20","v":0},{"$f":"'L6 Scores'!T20","v":0},{"$f":"'L6 Scores'!X20","v":0},7]
[null,{"$f":"'L6 Scores'!A21","v":0},{"$f":"'L6 Scores'!B21","v":0},{"$f":"'L6 Scores'!O21","v":0},{"$f":"'L6 Scores'!T21","v":0},{"$f":"'L6 Scores'!X21","v":0},8]
[null,{"$f":"'L6 Scores'!A22","v":0},{"$f":"'L6 Scores'!B22","v":0},{"$f":"'L6 Scores'!O22","v":0},{"$f":"'L6 Scores'!T22","v":0},{"$f":"'L6 Scores'!X22","v":0},9]
[null,{"$f":"'L6 Scores'!A23","v":0},{"$f":"'L6 Scores'!B23","v":0},{"$f":"'L6 Scores'!O23","v":0},{"$f":"'L6 Scores'!T23","v":0},{"$f":"'L6 Scores'!X23","v":0},10]
[null,{"$f":"'L6 Scores'!A24","v":0},{"$f":"'L6 Scores'!B24","v":0},{"$f":"'L6 Scores'!O24","v":0},{"$f":"'L6 Scores'!T24","v":0},{"$f":"'L6 Scores'!X24","v":0},11]
[null,{"$f":"'L6 Scores'!A25","v":0},{"$f":"'L6 Scores'!B25","v":0},{"$f":"'L6 Scores'!O25","v":0},{"$f":"'L6 Scores'!T25","v":0},{"$f":"'L6 Scores'!X25","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L6 Scores'!A26","v":0},{"$f":"'L6 Scores'!B26","v":0},{"$f":"'L6 Scores'!O26","v":0},{"$f":"'L6 Scores'!T26","v":0},{"$f":"'L6 Scores'!X26","v":0},1]
[null,{"$f":"'L6 Scores'!A27","v":0},{"$f":"'L6 Scores'!B27","v":0},{"$f":"'L6 Scores'!O27","v":0},{"$f":"'L6 Scores'!T27","v":0},{"$f":"'L6 Scores'!X27","v":0},2]
[null,{"$f":"'L6 Scores'!A28","v":0},{"$f":"'L6 Scores'!B28","v":0},{"$f":"'L6 Scores'!O28","v":0},{"$f":"'L6 Scores'!T28","v":0},{"$f":"'L6 Scores'!X28","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","RANK"]
[null,{"$f":"'L6 Scores'!A31","v":0},{"$f":"'L6 Scores'!B31","v":0},{"$f":"'L6 Scores'!O31","v":0},{"$f":"'L6 Scores'!T31","v":0},{"$f":"'L6 Scores'!X31","v":0},1]
[null,{"$f":"'L6 Scores'!A30","v":0},{"$f":"'L6 Scores'!B30","v":0},{"$f":"'L6 Scores'!O30","v":0},{"$f":"'L6 Scores'!T30","v":0},{"$f":"'L6 Scores'!X30","v":0},2]
[null,{"$f":"'L6 Scores'!A29","v":0},{"$f":"'L6 Scores'!B29","v":0},{"$f":"'L6 Scores'!O29","v":0},{"$f":"'L6 Scores'!T29","v":0},{"$f":"'L6 Scores'!X29","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L7 Scores","index":15,"n_rows":33,"n_cols":32,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,11,13,12],[13,5,13,7],[13,8,13,10],[13,21,13,22],[13,15,13,17],[13,18,13,20]]}
["Power TeamGym Scoresheet for Level 7",null,null,null,null,null,null,null,7]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0}," here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet","At this level a Four Judge Panel is used for each event.  Discard the Highest and Lowest scores FOR EACH EVENT and input the two middle scores in the spreadsheet."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information","The three events at Level 7 are:  Tumbling; Vault & Trampet; and Floor.  Each one will have an individual score sheet.  Determine High, High Middle, Low Middle and Low."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!","After determining that the scores are within range for that event, discard High and Low.  Input the two middle scores."]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"","Note:  If a two judge panel is used, input both scores.",null,null,null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"TUMBLING  (3 PASSES)",null,null,null,null,null,null,null,null,null,"VAULT AND TRAMPET",null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals - TUMBLING",null,"TUMBLING",null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals -VAULT/TRAMPET",null,"TRAMPET",null,null,null,"FX",null,"sub-","HEAD JUDGE"]
["Club","Team Name","Sqd","Division",null,"TU 1","TU 2","TU 3","TU 1","TU 2","TU 3","Avg J1","Avg J2","Score",null,"Vault 1","V2 or Tr1","Trampet","Vault 1","V2 or Tr1","Trampet","Avg J1","Avg J2","Score",null,"Judge 1","Judge 2","Score",null,"final","Deductions","FINAL"]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F16,G16,H16)/3,0)","v":0},{"$f":"IFERROR(SUM(I16,J16,K16)/3,0)","v":0},{"$f":"IF(M16=0,L16,(L16+M16)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P16,Q16,R16)/3,0)","v":0},{"$f":"IFERROR(SUM(S16,T16,U16)/3,0)","v":0},{"$f":"IF(W16=0,V16,(V16+W16)/2)","v":0},null,null,null,{"$f":"IF(AA16=0,Z16,((Z16+AA16)/2))","v":0},null,{"$f":"SUM(N16+X16+AB16)","v":0},null,{"$f":"SUM(AD16+AE16)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F17,G17,H17)/3,0)","v":0},{"$f":"IFERROR(SUM(I17,J17,K17)/3,0)","v":0},{"$f":"IF(M17=0,L17,(L17+M17)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P17,Q17,R17)/3,0)","v":0},{"$f":"IFERROR(SUM(S17,T17,U17)/3,0)","v":0},{"$f":"IF(W17=0,V17,(V17+W17)/2)","v":0},null,null,null,0,null,{"$f":"SUM(N17+X17+AB17)","v":0},null,{"$f":"SUM(AD17+AE17)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L7 Final","index":16,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Power TeamGym Results Level 7",null,null,null,null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,null,"This data is imported from the spreadsheet labelled \"L7 Scores\""]
[null,"Qualifying score for Nationals is 24 or >"]
[null,"OPEN FEMALE",null,null,"Vault / "]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L7 Scores'!A18","v":0},{"$f":"'L7 Scores'!B18","v":0},{"$f":"'L7 Scores'!N18","v":0},{"$f":"'L7 Scores'!X18","v":0},{"$f":"'L7 Scores'!AB18","v":0},{"$f":"'L7 Scores'!AF18","v":0},1,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L7 Scores'!A17","v":0},{"$f":"'L7 Scores'!B17","v":0},{"$f":"'L7 Scores'!N17","v":0},{"$f":"'L7 Scores'!X17","v":0},{"$f":"'L7 Scores'!AB17","v":0},{"$f":"'L7 Scores'!AF17","v":0},2]
[null,{"$f":"'L7 Scores'!A16","v":0},{"$f":"'L7 Scores'!B16","v":0},{"$f":"'L7 Scores'!N16","v":0},{"$f":"'L7 Scores'!X16","v":0},{"$f":"'L7 Scores'!AB16","v":0},{"$f":"'L7 Scores'!AF16","v":0},3]
[null,{"$f":"'L7 Scores'!A21","v":0},{"$f":"'L7 Scores'!B21","v":0},{"$f":"'L7 Scores'!N19","v":0},{"$f":"'L7 Scores'!X21","v":0},{"$f":"'L7 Scores'!AB21","v":0},{"$f":"'L7 Scores'!AF21","v":0},4]
[null,{"$f":"'L7 Scores'!A20","v":0},{"$f":"'L7 Scores'!B20","v":0},{"$f":"'L7 Scores'!N21","v":0},{"$f":"'L7 Scores'!X20","v":0},{"$f":"'L7 Scores'!AB20","v":0},{"$f":"'L7 Scores'!AF20","v":0},5]
[null,{"$f":"'L7 Scores'!A19","v":0},{"$f":"'L7 Scores'!B19","v":0},{"$f":"'L7 Scores'!N20","v":0},{"$f":"'L7 Scores'!X19","v":0},{"$f":"'L7 Scores'!AB19","v":0},{"$f":"'L7 Scores'!AF19","v":0},6]
[null,{"$f":"'L7 Scores'!A22","v":0},{"$f":"'L7 Scores'!B22","v":0},{"$f":"'L7 Scores'!N22","v":0},{"$f":"'L7 Scores'!X22","v":0},{"$f":"'L7 Scores'!AB22","v":0},{"$f":"'L7 Scores'!AF22","v":0},7]
[null,{"$f":"'L7 Scores'!A23","v":0},{"$f":"'L7 Scores'!B23","v":0},{"$f":"'L7 Scores'!N24","v":0},{"$f":"'L7 Scores'!X23","v":0},{"$f":"'L7 Scores'!AB23","v":0},{"$f":"'L7 Scores'!AF23","v":0},8]
[null,{"$f":"'L7 Scores'!A24","v":0},{"$f":"'L7 Scores'!B24","v":0},{"$f":"'L7 Scores'!N23","v":0},{"$f":"'L7 Scores'!X24","v":0},{"$f":"'L7 Scores'!AB24","v":0},{"$f":"'L7 Scores'!AF24","v":0},9]
[null,{"$f":"'L7 Scores'!A25","v":0},{"$f":"'L7 Scores'!B25","v":0},{"$f":"'L7 Scores'!N25","v":0},{"$f":"'L7 Scores'!X25","v":0},{"$f":"'L7 Scores'!AB25","v":0},{"$f":"'L7 Scores'!AF25","v":0},10]
[null,{"$f":"'L7 Scores'!A26","v":0},{"$f":"'L7 Scores'!B26","v":0},{"$f":"'L7 Scores'!N27","v":0},{"$f":"'L7 Scores'!X26","v":0},{"$f":"'L7 Scores'!AB26","v":0},{"$f":"'L7 Scores'!AF26","v":0},11]
[null,{"$f":"'L7 Scores'!A27","v":0},{"$f":"'L7 Scores'!B27","v":0},{"$f":"'L7 Scores'!N26","v":0},{"$f":"'L7 Scores'!X27","v":0},{"$f":"'L7 Scores'!AB27","v":0},{"$f":"'L7 Scores'!AF27","v":0},12]
[]
[null,"OPEN MALE",null,null,"Vault / "]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L7 Scores'!A30","v":0},{"$f":"'L7 Scores'!B30","v":0},{"$f":"'L7 Scores'!M30","v":0},{"$f":"'L7 Scores'!X30","v":0},{"$f":"'L7 Scores'!AB30","v":0},{"$f":"'L7 Scores'!AF30","v":0},1]
[null,{"$f":"'L7 Scores'!A28","v":0},{"$f":"'L7 Scores'!B28","v":0},{"$f":"'L7 Scores'!M28","v":0},{"$f":"'L7 Scores'!X28","v":0},{"$f":"'L7 Scores'!AB28","v":0},{"$f":"'L7 Scores'!AF28","v":0},2]
[null,{"$f":"'L7 Scores'!A29","v":0},{"$f":"'L7 Scores'!B29","v":0},{"$f":"'L7 Scores'!M29","v":0},{"$f":"'L7 Scores'!X29","v":0},{"$f":"'L7 Scores'!AB29","v":0},{"$f":"'L7 Scores'!AF29","v":0},3]
[]
[null,"MIXED",null,null,"Vault /"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L7 Scores'!A31","v":0},{"$f":"'L7 Scores'!B31","v":0},{"$f":"'L7 Scores'!M31","v":0},{"$f":"'L7 Scores'!X33","v":0},{"$f":"'L7 Scores'!AB31","v":0},{"$f":"'L7 Scores'!AF31","v":0},1]
[null,{"$f":"'L7 Scores'!A33","v":0},{"$f":"'L7 Scores'!B33","v":0},{"$f":"'L7 Scores'!M33","v":0},{"$f":"'L7 Scores'!X32","v":0},{"$f":"'L7 Scores'!AB33","v":0},{"$f":"'L7 Scores'!AF33","v":0},2]
[null,{"$f":"'L7 Scores'!A32","v":0},{"$f":"'L7 Scores'!B32","v":0},{"$f":"'L7 Scores'!M32","v":0},{"$f":"'L7 Scores'!X31","v":0},{"$f":"'L7 Scores'!AB32","v":0},{"$f":"'L7 Scores'!AF32","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L8 Scores","index":17,"n_rows":33,"n_cols":32,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,15,13,17],[13,18,13,20],[13,21,13,22],[13,5,13,7],[13,8,13,10],[13,11,13,12]]}
["Power TeamGym Scoresheet for Level 8",null,null,null,null,null,null,null,8]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0},"ç here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet","At this level a Four Judge Panel is used for each event.  Discard the Highest and Lowest scores FOR EACH EVENT and input the two middle scores in the spreadsheet."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information","The three events at Level 7 are:  Tumbling; Vault & Trampet; and Floor.  Each one will have an individual score sheet.  Determine High, High Middle, Low Middle and Low."]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!","After determining that the scores are within range for that event, discard High and Low.  Input the two middle scores."]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"í","Note:  If a two judge panel is used, input both scores.",null,null,null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"TUMBLING  (3 PASSES)",null,null,null,null,null,null,null,null,null,"VAULT AND TRAMPET (3 PASSES TOTAL)",null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals - TUMBLING",null,"TUMBLING",null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals -VAULT/TRAMPET",null,"TRAMPET",null,null,null,"FX",null,"sub-","HEAD JUDGE"]
["Club","Team Name","Sqd","Division",null,"TU 1","TU 2","TU 3","TU 1","TU 2","TU 3","Avg J1","Avg J2","Score",null,"Vault 1","V2 or Tr1","Trampet","Vault 1","V2 or Tr1","Trampet","Avg J1","Avg J2","Score",null,"Judge 1","Judge 2","Score",null,"final","Deductions","FINAL"]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F16,G16,H16)/3,0)","v":0},{"$f":"IFERROR(SUM(I16,J16,K16)/3,0)","v":0},{"$f":"IF(M16=0,L16,(L16+M16)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P16,Q16,R16)/3,0)","v":0},{"$f":"IFERROR(SUM(S16,T16,U16)/3,0)","v":0},{"$f":"IF(W16=0,V16,(V16+W16)/2)","v":0},null,null,null,{"$f":"IF(AA16=0,Z16,((Z16+AA16)/2))","v":0},null,{"$f":"SUM(N16+X16+AB16)","v":0},null,{"$f":"SUM(AD16+AE16)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F17,G17,H17)/3,0)","v":0},{"$f":"IFERROR(SUM(I17,J17,K17)/3,0)","v":0},{"$f":"IF(M17=0,L17,(L17+M17)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P17,Q17,R17)/3,0)","v":0},{"$f":"IFERROR(SUM(S17,T17,U17)/3,0)","v":0},{"$f":"IF(W17=0,V17,(V17+W17)/2)","v":0},null,null,null,0,null,{"$f":"SUM(N17+X17+AB17)","v":0},null,{"$f":"SUM(AD17+AE17)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L8 Final","index":18,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Power TeamGym Results Level 8",null,null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,null,"This data is imported from the spreadsheet labelled \"L8 Scores\""]
[null,"Qualifying score for Nationals is 24 or >"]
[null,"OPEN FEMALE",null,null,"Vault / "]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L8 Scores'!A16","v":0},{"$f":"'L8 Scores'!B16","v":0},{"$f":"'L8 Scores'!N16","v":0},{"$f":"'L8 Scores'!X16","v":0},{"$f":"'L8 Scores'!AB16","v":0},{"$f":"'L8 Scores'!AF16","v":0},1,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L8 Scores'!A17","v":0},{"$f":"'L8 Scores'!B17","v":0},{"$f":"'L8 Scores'!N17","v":0},{"$f":"'L8 Scores'!X17","v":0},{"$f":"'L8 Scores'!AB17","v":0},{"$f":"'L8 Scores'!AF17","v":0},2]
[null,{"$f":"'L8 Scores'!A18","v":0},{"$f":"'L8 Scores'!B18","v":0},{"$f":"'L8 Scores'!N18","v":0},{"$f":"'L8 Scores'!X18","v":0},{"$f":"'L8 Scores'!AB18","v":0},{"$f":"'L8 Scores'!AF18","v":0},3]
[null,{"$f":"'L8 Scores'!A19","v":0},{"$f":"'L8 Scores'!B19","v":0},{"$f":"'L8 Scores'!N19","v":0},{"$f":"'L8 Scores'!X19","v":0},{"$f":"'L8 Scores'!AB19","v":0},{"$f":"'L8 Scores'!AF19","v":0},4]
[null,{"$f":"'L8 Scores'!A21","v":0},{"$f":"'L8 Scores'!B21","v":0},{"$f":"'L8 Scores'!N21","v":0},{"$f":"'L8 Scores'!X21","v":0},{"$f":"'L8 Scores'!AB21","v":0},{"$f":"'L8 Scores'!AF21","v":0},5]
[null,{"$f":"'L8 Scores'!A20","v":0},{"$f":"'L8 Scores'!B20","v":0},{"$f":"'L8 Scores'!N20","v":0},{"$f":"'L8 Scores'!X20","v":0},{"$f":"'L8 Scores'!AB20","v":0},{"$f":"'L8 Scores'!AF20","v":0},6]
[null,{"$f":"'L8 Scores'!A22","v":0},{"$f":"'L8 Scores'!B22","v":0},{"$f":"'L8 Scores'!N22","v":0},{"$f":"'L8 Scores'!X22","v":0},{"$f":"'L8 Scores'!AB22","v":0},{"$f":"'L8 Scores'!AF22","v":0},7]
[null,{"$f":"'L8 Scores'!A23","v":0},{"$f":"'L8 Scores'!B23","v":0},{"$f":"'L8 Scores'!N23","v":0},{"$f":"'L8 Scores'!X23","v":0},{"$f":"'L8 Scores'!AB23","v":0},{"$f":"'L8 Scores'!AF23","v":0},8]
[null,{"$f":"'L8 Scores'!A24","v":0},{"$f":"'L8 Scores'!B24","v":0},{"$f":"'L8 Scores'!N24","v":0},{"$f":"'L8 Scores'!X24","v":0},{"$f":"'L8 Scores'!AB24","v":0},{"$f":"'L8 Scores'!AF24","v":0},9]
[null,{"$f":"'L8 Scores'!A25","v":0},{"$f":"'L8 Scores'!B25","v":0},{"$f":"'L8 Scores'!N25","v":0},{"$f":"'L8 Scores'!X25","v":0},{"$f":"'L8 Scores'!AB25","v":0},{"$f":"'L8 Scores'!AF25","v":0},10]
[null,{"$f":"'L8 Scores'!A26","v":0},{"$f":"'L8 Scores'!B26","v":0},{"$f":"'L8 Scores'!N26","v":0},{"$f":"'L8 Scores'!X26","v":0},{"$f":"'L8 Scores'!AB26","v":0},{"$f":"'L8 Scores'!AF26","v":0},11]
[null,{"$f":"'L8 Scores'!A27","v":0},{"$f":"'L8 Scores'!B27","v":0},{"$f":"'L8 Scores'!N27","v":0},{"$f":"'L8 Scores'!X27","v":0},{"$f":"'L8 Scores'!AB27","v":0},{"$f":"'L8 Scores'!AF27","v":0},12]
[]
[null,"OPEN MALE",null,null,"Vault / "]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L8 Scores'!A28","v":0},{"$f":"'L8 Scores'!B28","v":0},{"$f":"'L8 Scores'!N28","v":0},{"$f":"'L8 Scores'!X28","v":0},{"$f":"'L8 Scores'!AB28","v":0},{"$f":"'L8 Scores'!AF28","v":0},1]
[null,{"$f":"'L8 Scores'!A29","v":0},{"$f":"'L8 Scores'!B29","v":0},{"$f":"'L8 Scores'!N29","v":0},{"$f":"'L8 Scores'!X29","v":0},{"$f":"'L8 Scores'!AB29","v":0},{"$f":"'L8 Scores'!AF29","v":0},2]
[null,{"$f":"'L8 Scores'!A30","v":0},{"$f":"'L8 Scores'!B30","v":0},{"$f":"'L8 Scores'!N30","v":0},{"$f":"'L8 Scores'!X30","v":0},{"$f":"'L8 Scores'!AB30","v":0},{"$f":"'L8 Scores'!AF30","v":0},3]
[]
[null,"MIXED",null,null,"Vault / "]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L8 Scores'!A31","v":0},{"$f":"'L8 Scores'!B31","v":0},{"$f":"'L8 Scores'!N31","v":0},{"$f":"'L8 Scores'!X31","v":0},{"$f":"'L8 Scores'!AB31","v":0},{"$f":"'L8 Scores'!AF31","v":0},1]
[null,{"$f":"'L8 Scores'!A32","v":0},{"$f":"'L8 Scores'!B32","v":0},{"$f":"'L8 Scores'!N32","v":0},{"$f":"'L8 Scores'!X32","v":0},{"$f":"'L8 Scores'!AB32","v":0},{"$f":"'L8 Scores'!AF32","v":0},2]
[null,{"$f":"'L8 Scores'!A33","v":0},{"$f":"'L8 Scores'!B33","v":0},{"$f":"'L8 Scores'!N33","v":0},{"$f":"'L8 Scores'!X33","v":0},{"$f":"'L8 Scores'!AB33","v":0},{"$f":"'L8 Scores'!AF33","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"ALL SCORES L1 to L6","index":19,"n_rows":139,"n_cols":11,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Power TeamGym Results",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheets labelled \"L1 Scores\", \"L2 Scores\" through \"L6 Scores\""]
[]
[null,"OPEN FEMALE",null,null,null,null,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
["Level","CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal","Rank"]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A16","v":0},{"$f":"'L1 Scores'!B16","v":0},{"$f":"'L1 Scores'!O16","v":0},{"$f":"'L1 Scores'!U16","v":0},{"$f":"'L1 Scores'!Y16","v":0},{"$f":"IF(F6>18,\"GOLD\",IF(F6>16,\"SILVER\",IF(F6>0,\"BRONZE\",\"\")))","v":""},1]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A17","v":0},{"$f":"'L1 Scores'!B17","v":0},{"$f":"'L1 Scores'!O17","v":0},{"$f":"'L1 Scores'!U17","v":0},{"$f":"'L1 Scores'!Y17","v":0},"",2]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A18","v":0},{"$f":"'L1 Scores'!B18","v":0},{"$f":"'L1 Scores'!O18","v":0},{"$f":"'L1 Scores'!U18","v":0},{"$f":"'L1 Scores'!Y18","v":0},"",3]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A20","v":0},{"$f":"'L1 Scores'!B20","v":0},{"$f":"'L1 Scores'!O20","v":0},{"$f":"'L1 Scores'!U20","v":0},{"$f":"'L1 Scores'!Y20","v":0},"",4]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A19","v":0},{"$f":"'L1 Scores'!B19","v":0},{"$f":"'L1 Scores'!O19","v":0},{"$f":"'L1 Scores'!U19","v":0},{"$f":"'L1 Scores'!Y19","v":0},"",5]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A21","v":0},{"$f":"'L1 Scores'!B21","v":0},{"$f":"'L1 Scores'!O21","v":0},{"$f":"'L1 Scores'!U21","v":0},{"$f":"'L1 Scores'!Y21","v":0},"",6]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A22","v":0},{"$f":"'L1 Scores'!B22","v":0},{"$f":"'L1 Scores'!O22","v":0},{"$f":"'L1 Scores'!U22","v":0},{"$f":"'L1 Scores'!Y22","v":0},"",7]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A23","v":0},{"$f":"'L1 Scores'!B23","v":0},{"$f":"'L1 Scores'!O23","v":0},{"$f":"'L1 Scores'!U23","v":0},{"$f":"'L1 Scores'!Y23","v":0},"",8]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A24","v":0},{"$f":"'L1 Scores'!B24","v":0},{"$f":"'L1 Scores'!O24","v":0},{"$f":"'L1 Scores'!U24","v":0},{"$f":"'L1 Scores'!Y24","v":0},"",9]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A25","v":0},{"$f":"'L1 Scores'!B25","v":0},{"$f":"'L1 Scores'!O25","v":0},{"$f":"'L1 Scores'!U25","v":0},{"$f":"'L1 Scores'!Y25","v":0},"",10]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A26","v":0},{"$f":"'L1 Scores'!B26","v":0},{"$f":"'L1 Scores'!O26","v":0},{"$f":"'L1 Scores'!U26","v":0},{"$f":"'L1 Scores'!Y26","v":0},"",11]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A27","v":0},{"$f":"'L1 Scores'!B27","v":0},{"$f":"'L1 Scores'!O27","v":0},{"$f":"'L1 Scores'!U27","v":0},{"$f":"'L1 Scores'!Y27","v":0},"",12]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A16","v":0},{"$f":"'L2 Scores'!B16","v":0},{"$f":"'L2 Scores'!Q16","v":0},{"$f":"'L2 Scores'!W16","v":0},{"$f":"'L2 Scores'!AA16","v":0},"",1]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A22","v":0},{"$f":"'L2 Scores'!B22","v":0},{"$f":"'L2 Scores'!Q22","v":0},{"$f":"'L2 Scores'!W22","v":0},{"$f":"'L2 Scores'!AA22","v":0},"",2]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A23","v":0},{"$f":"'L2 Scores'!B23","v":0},{"$f":"'L2 Scores'!Q23","v":0},{"$f":"'L2 Scores'!W23","v":0},{"$f":"'L2 Scores'!AA23","v":0},"",3]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A21","v":0},{"$f":"'L2 Scores'!B21","v":0},{"$f":"'L2 Scores'!Q21","v":0},{"$f":"'L2 Scores'!W21","v":0},{"$f":"'L2 Scores'!AA21","v":0},"",4]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A19","v":0},{"$f":"'L2 Scores'!B19","v":0},{"$f":"'L2 Scores'!Q19","v":0},{"$f":"'L2 Scores'!W19","v":0},{"$f":"'L2 Scores'!AA19","v":0},"",5]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A20","v":0},{"$f":"'L2 Scores'!B20","v":0},{"$f":"'L2 Scores'!Q20","v":0},{"$f":"'L2 Scores'!W20","v":0},{"$f":"'L2 Scores'!AA20","v":0},"",6]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A17","v":0},{"$f":"'L2 Scores'!B17","v":0},{"$f":"'L2 Scores'!Q17","v":0},{"$f":"'L2 Scores'!W17","v":0},{"$f":"'L2 Scores'!AA17","v":0},"",7]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A24","v":0},{"$f":"'L2 Scores'!B24","v":0},{"$f":"'L2 Scores'!Q24","v":0},{"$f":"'L2 Scores'!W24","v":0},{"$f":"'L2 Scores'!AA24","v":0},"",8]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A18","v":0},{"$f":"'L2 Scores'!B18","v":0},{"$f":"'L2 Scores'!Q18","v":0},{"$f":"'L2 Scores'!W18","v":0},{"$f":"'L2 Scores'!AA18","v":0},"",9]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A25","v":0},{"$f":"'L2 Scores'!B25","v":0},{"$f":"'L2 Scores'!Q25","v":0},{"$f":"'L2 Scores'!W25","v":0},{"$f":"'L2 Scores'!AA25","v":0},"",10]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A26","v":0},{"$f":"'L2 Scores'!B26","v":0},{"$f":"'L2 Scores'!Q26","v":0},{"$f":"'L2 Scores'!W26","v":0},{"$f":"'L2 Scores'!AA26","v":0},"",11]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A27","v":0},{"$f":"'L2 Scores'!B27","v":0},{"$f":"'L2 Scores'!Q27","v":0},{"$f":"'L2 Scores'!W27","v":0},{"$f":"'L2 Scores'!AA27","v":0},"",12]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A18","v":0},{"$f":"'L3 Scores'!B18","v":0},{"$f":"'L3 Scores'!Q18","v":0},{"$f":"'L3 Scores'!W18","v":0},{"$f":"'L3 Scores'!AA18","v":0},null,1]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A19","v":0},{"$f":"'L3 Scores'!B19","v":0},{"$f":"'L3 Scores'!Q19","v":0},{"$f":"'L3 Scores'!W19","v":0},{"$f":"'L3 Scores'!AA19","v":0},null,2]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A17","v":0},{"$f":"'L3 Scores'!B17","v":0},{"$f":"'L3 Scores'!Q17","v":0},{"$f":"'L3 Scores'!W17","v":0},{"$f":"'L3 Scores'!AA17","v":0},null,3]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A16","v":0},{"$f":"'L3 Scores'!B16","v":0},{"$f":"'L3 Scores'!Q16","v":0},{"$f":"'L3 Scores'!W16","v":0},{"$f":"'L3 Scores'!AA16","v":0},null,4]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A15","v":0},{"$f":"'L3 Scores'!B15","v":0},{"$f":"'L3 Scores'!Q15","v":0},{"$f":"'L3 Scores'!W15","v":0},{"$f":"'L3 Scores'!AA15","v":0},null,5]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A20","v":0},{"$f":"'L3 Scores'!B20","v":0},{"$f":"'L3 Scores'!Q20","v":0},{"$f":"'L3 Scores'!W20","v":0},{"$f":"'L3 Scores'!AA20","v":0},null,6]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A21","v":0},{"$f":"'L3 Scores'!B21","v":0},{"$f":"'L3 Scores'!Q21","v":0},{"$f":"'L3 Scores'!W21","v":0},{"$f":"'L3 Scores'!AA21","v":0},null,7]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A22","v":0},{"$f":"'L3 Scores'!B22","v":0},{"$f":"'L3 Scores'!Q22","v":0},{"$f":"'L3 Scores'!W22","v":0},{"$f":"'L3 Scores'!AA22","v":0},null,8]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A23","v":0},{"$f":"'L3 Scores'!B23","v":0},{"$f":"'L3 Scores'!Q23","v":0},{"$f":"'L3 Scores'!W23","v":0},{"$f":"'L3 Scores'!AA23","v":0},null,9]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A24","v":0},{"$f":"'L3 Scores'!B24","v":0},{"$f":"'L3 Scores'!Q24","v":0},{"$f":"'L3 Scores'!W24","v":0},{"$f":"'L3 Scores'!AA24","v":0},null,10]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A25","v":0},{"$f":"'L3 Scores'!B25","v":0},{"$f":"'L3 Scores'!Q25","v":0},{"$f":"'L3 Scores'!W25","v":0},{"$f":"'L3 Scores'!AA25","v":0},null,11]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A26","v":0},{"$f":"'L3 Scores'!B26","v":0},{"$f":"'L3 Scores'!Q26","v":0},{"$f":"'L3 Scores'!W26","v":0},{"$f":"'L3 Scores'!AA26","v":0},null,12]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A17","v":0},{"$f":"'L4 Scores'!B17","v":0},{"$f":"'L4 Scores'!P17","v":0},{"$f":"'L4 Scores'!T17","v":0},{"$f":"'L4 Scores'!X17","v":0},null,1]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A14","v":0},{"$f":"'L4 Scores'!B14","v":0},{"$f":"'L4 Scores'!P14","v":0},{"$f":"'L4 Scores'!T14","v":0},{"$f":"'L4 Scores'!X14","v":0},null,2]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A15","v":0},{"$f":"'L4 Scores'!B15","v":0},{"$f":"'L4 Scores'!P15","v":0},{"$f":"'L4 Scores'!T15","v":0},{"$f":"'L4 Scores'!X15","v":0},null,3]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A16","v":0},{"$f":"'L4 Scores'!B16","v":0},{"$f":"'L4 Scores'!P16","v":0},{"$f":"'L4 Scores'!T16","v":0},{"$f":"'L4 Scores'!X16","v":0},null,4]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A18","v":0},{"$f":"'L4 Scores'!B18","v":0},{"$f":"'L4 Scores'!P18","v":0},{"$f":"'L4 Scores'!T18","v":0},{"$f":"'L4 Scores'!X18","v":0},null,5]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A19","v":0},{"$f":"'L4 Scores'!B19","v":0},{"$f":"'L4 Scores'!P19","v":0},{"$f":"'L4 Scores'!T19","v":0},{"$f":"'L4 Scores'!X19","v":0},null,6]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A20","v":0},{"$f":"'L4 Scores'!B20","v":0},{"$f":"'L4 Scores'!P20","v":0},{"$f":"'L4 Scores'!T20","v":0},{"$f":"'L4 Scores'!X20","v":0},null,7]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A21","v":0},{"$f":"'L4 Scores'!B21","v":0},{"$f":"'L4 Scores'!P21","v":0},{"$f":"'L4 Scores'!T21","v":0},{"$f":"'L4 Scores'!X21","v":0},null,8]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A22","v":0},{"$f":"'L4 Scores'!B22","v":0},{"$f":"'L4 Scores'!P22","v":0},{"$f":"'L4 Scores'!T22","v":0},{"$f":"'L4 Scores'!X22","v":0},null,9]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A23","v":0},{"$f":"'L4 Scores'!B23","v":0},{"$f":"'L4 Scores'!P23","v":0},{"$f":"'L4 Scores'!T23","v":0},{"$f":"'L4 Scores'!X23","v":0},null,10]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A24","v":0},{"$f":"'L4 Scores'!B24","v":0},{"$f":"'L4 Scores'!P24","v":0},{"$f":"'L4 Scores'!T24","v":0},{"$f":"'L4 Scores'!X24","v":0},null,11]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A25","v":0},{"$f":"'L4 Scores'!B25","v":0},{"$f":"'L4 Scores'!P25","v":0},{"$f":"'L4 Scores'!T25","v":0},{"$f":"'L4 Scores'!X25","v":0},null,12]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A17","v":0},{"$f":"'L5 Scores'!B17","v":0},{"$f":"'L5 Scores'!P17","v":0},{"$f":"'L5 Scores'!T17","v":0},{"$f":"'L5 Scores'!X17","v":0},null,1]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A14","v":0},{"$f":"'L5 Scores'!B14","v":0},{"$f":"'L5 Scores'!P14","v":0},{"$f":"'L5 Scores'!T14","v":0},{"$f":"'L5 Scores'!X14","v":0},null,2]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A15","v":0},{"$f":"'L5 Scores'!B15","v":0},{"$f":"'L5 Scores'!P15","v":0},{"$f":"'L5 Scores'!T15","v":0},{"$f":"'L5 Scores'!X15","v":0},null,3]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A16","v":0},{"$f":"'L5 Scores'!B16","v":0},{"$f":"'L5 Scores'!P16","v":0},{"$f":"'L5 Scores'!T16","v":0},{"$f":"'L5 Scores'!X16","v":0},null,4]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A18","v":0},{"$f":"'L5 Scores'!B18","v":0},{"$f":"'L5 Scores'!P18","v":0},{"$f":"'L5 Scores'!T18","v":0},{"$f":"'L5 Scores'!X18","v":0},null,5]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A19","v":0},{"$f":"'L5 Scores'!B19","v":0},{"$f":"'L5 Scores'!P19","v":0},{"$f":"'L5 Scores'!T19","v":0},{"$f":"'L5 Scores'!X19","v":0},null,6]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A20","v":0},{"$f":"'L5 Scores'!B20","v":0},{"$f":"'L5 Scores'!P20","v":0},{"$f":"'L5 Scores'!T20","v":0},{"$f":"'L5 Scores'!X20","v":0},null,7]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A21","v":0},{"$f":"'L5 Scores'!B21","v":0},{"$f":"'L5 Scores'!P21","v":0},{"$f":"'L5 Scores'!T21","v":0},{"$f":"'L5 Scores'!X21","v":0},null,8]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A22","v":0},{"$f":"'L5 Scores'!B22","v":0},{"$f":"'L5 Scores'!P22","v":0},{"$f":"'L5 Scores'!T22","v":0},{"$f":"'L5 Scores'!X22","v":0},null,9]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A23","v":0},{"$f":"'L5 Scores'!B23","v":0},{"$f":"'L5 Scores'!P23","v":0},{"$f":"'L5 Scores'!T23","v":0},{"$f":"'L5 Scores'!X23","v":0},null,10]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A24","v":0},{"$f":"'L5 Scores'!B24","v":0},{"$f":"'L5 Scores'!P24","v":0},{"$f":"'L5 Scores'!T24","v":0},{"$f":"'L5 Scores'!X24","v":0},null,11]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A25","v":0},{"$f":"'L5 Scores'!B25","v":0},{"$f":"'L5 Scores'!P25","v":0},{"$f":"'L5 Scores'!T25","v":0},{"$f":"'L5 Scores'!X25","v":0},null,12]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A14","v":0},{"$f":"'L6 Scores'!B14","v":0},{"$f":"'L6 Scores'!P14","v":0},{"$f":"'L6 Scores'!T14","v":0},{"$f":"'L6 Scores'!X14","v":0},null,1]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A15","v":0},{"$f":"'L6 Scores'!B15","v":0},{"$f":"'L6 Scores'!P15","v":0},{"$f":"'L6 Scores'!T15","v":0},{"$f":"'L6 Scores'!X15","v":0},null,2]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A16","v":0},{"$f":"'L6 Scores'!B16","v":0},{"$f":"'L6 Scores'!P16","v":0},{"$f":"'L6 Scores'!T16","v":0},{"$f":"'L6 Scores'!X16","v":0},null,3]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A17","v":0},{"$f":"'L6 Scores'!B17","v":0},{"$f":"'L6 Scores'!P17","v":0},{"$f":"'L6 Scores'!T17","v":0},{"$f":"'L6 Scores'!X17","v":0},null,4]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A18","v":0},{"$f":"'L6 Scores'!B18","v":0},{"$f":"'L6 Scores'!P18","v":0},{"$f":"'L6 Scores'!T18","v":0},{"$f":"'L6 Scores'!X18","v":0},null,5]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A19","v":0},{"$f":"'L6 Scores'!B19","v":0},{"$f":"'L6 Scores'!P19","v":0},{"$f":"'L6 Scores'!T19","v":0},{"$f":"'L6 Scores'!X19","v":0},null,6]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A20","v":0},{"$f":"'L6 Scores'!B20","v":0},{"$f":"'L6 Scores'!P20","v":0},{"$f":"'L6 Scores'!T20","v":0},{"$f":"'L6 Scores'!X20","v":0},null,7]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A21","v":0},{"$f":"'L6 Scores'!B21","v":0},{"$f":"'L6 Scores'!P21","v":0},{"$f":"'L6 Scores'!T21","v":0},{"$f":"'L6 Scores'!X21","v":0},null,8]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A22","v":0},{"$f":"'L6 Scores'!B22","v":0},{"$f":"'L6 Scores'!P22","v":0},{"$f":"'L6 Scores'!T22","v":0},{"$f":"'L6 Scores'!X22","v":0},null,9]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A23","v":0},{"$f":"'L6 Scores'!B23","v":0},{"$f":"'L6 Scores'!P23","v":0},{"$f":"'L6 Scores'!T23","v":0},{"$f":"'L6 Scores'!X23","v":0},null,10]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A24","v":0},{"$f":"'L6 Scores'!B24","v":0},{"$f":"'L6 Scores'!P24","v":0},{"$f":"'L6 Scores'!T24","v":0},{"$f":"'L6 Scores'!X24","v":0},null,11]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A25","v":0},{"$f":"'L6 Scores'!B25","v":0},{"$f":"'L6 Scores'!P25","v":0},{"$f":"'L6 Scores'!T25","v":0},{"$f":"'L6 Scores'!X25","v":0},null,12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal","Rank"]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A28","v":0},{"$f":"'L1 Scores'!B28","v":0},{"$f":"'L1 Scores'!O28","v":0},{"$f":"'L1 Scores'!U28","v":0},{"$f":"'L1 Scores'!Y28","v":0},{"$f":"IF(F81>18,\"GOLD\",IF(F81>16,\"SILVER\",IF(F81>14,\"BRONZE\",\"\")))","v":""},1]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A29","v":0},{"$f":"'L1 Scores'!B29","v":0},{"$f":"'L1 Scores'!O29","v":0},{"$f":"'L1 Scores'!U29","v":0},{"$f":"'L1 Scores'!Y29","v":0},"",2]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A30","v":0},{"$f":"'L1 Scores'!B30","v":0},{"$f":"'L1 Scores'!O30","v":0},{"$f":"'L1 Scores'!U30","v":0},{"$f":"'L1 Scores'!Y30","v":0},"",3]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A30","v":0},{"$f":"'L2 Scores'!B30","v":0},{"$f":"'L2 Scores'!Q30","v":0},{"$f":"'L2 Scores'!W30","v":0},{"$f":"'L2 Scores'!AA30","v":0},"",1]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A28","v":0},{"$f":"'L2 Scores'!B28","v":0},{"$f":"'L2 Scores'!Q28","v":0},{"$f":"'L2 Scores'!W28","v":0},{"$f":"'L2 Scores'!AA28","v":0},"",2]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A29","v":0},{"$f":"'L2 Scores'!B29","v":0},{"$f":"'L2 Scores'!Q29","v":0},{"$f":"'L2 Scores'!W29","v":0},{"$f":"'L2 Scores'!AA29","v":0},"",3]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A27","v":0},{"$f":"'L3 Scores'!B27","v":0},{"$f":"'L3 Scores'!Q27","v":0},{"$f":"'L3 Scores'!W27","v":0},{"$f":"'L3 Scores'!AA27","v":0},null,1]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A28","v":0},{"$f":"'L3 Scores'!B28","v":0},{"$f":"'L3 Scores'!Q28","v":0},{"$f":"'L3 Scores'!W28","v":0},{"$f":"'L3 Scores'!AA28","v":0},null,2]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A29","v":0},{"$f":"'L3 Scores'!B29","v":0},{"$f":"'L3 Scores'!Q29","v":0},{"$f":"'L3 Scores'!W29","v":0},{"$f":"'L3 Scores'!AA29","v":0},null,3]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A26","v":0},{"$f":"'L4 Scores'!B26","v":0},{"$f":"'L4 Scores'!P26","v":0},{"$f":"'L4 Scores'!T26","v":0},{"$f":"'L4 Scores'!X25","v":0},null,1]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A27","v":0},{"$f":"'L4 Scores'!B27","v":0},{"$f":"'L4 Scores'!P27","v":0},{"$f":"'L4 Scores'!T27","v":0},{"$f":"'L4 Scores'!X26","v":0},null,2]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A28","v":0},{"$f":"'L4 Scores'!B28","v":0},{"$f":"'L4 Scores'!P28","v":0},{"$f":"'L4 Scores'!T28","v":0},{"$f":"'L4 Scores'!X27","v":0},null,3]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A27","v":0},{"$f":"'L5 Scores'!B27","v":0},{"$f":"'L5 Scores'!P27","v":0},{"$f":"'L5 Scores'!T27","v":0},{"$f":"'L5 Scores'!X27","v":0},null,1]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A26","v":0},{"$f":"'L5 Scores'!B26","v":0},{"$f":"'L5 Scores'!P26","v":0},{"$f":"'L5 Scores'!T26","v":0},{"$f":"'L5 Scores'!X26","v":0},null,2]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A28","v":0},{"$f":"'L5 Scores'!B28","v":0},{"$f":"'L5 Scores'!P28","v":0},{"$f":"'L5 Scores'!T28","v":0},{"$f":"'L5 Scores'!X28","v":0},null,3]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A26","v":0},{"$f":"'L6 Scores'!B26","v":0},{"$f":"'L6 Scores'!P26","v":0},{"$f":"'L6 Scores'!T26","v":0},{"$f":"'L6 Scores'!X26","v":0},null,1]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A27","v":0},{"$f":"'L6 Scores'!B27","v":0},{"$f":"'L6 Scores'!P27","v":0},{"$f":"'L6 Scores'!T27","v":0},{"$f":"'L6 Scores'!X27","v":0},null,2]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L6 Scores'!A28","v":0},{"$f":"'L6 Scores'!B28","v":0},{"$f":"'L6 Scores'!P28","v":0},{"$f":"'L6 Scores'!T28","v":0},{"$f":"'L6 Scores'!X28","v":0},null,3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal","Rank"]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A31","v":0},{"$f":"'L1 Scores'!B31","v":0},{"$f":"'L1 Scores'!O31","v":0},{"$f":"'L1 Scores'!U321","v":0},{"$f":"'L1 Scores'!Y31","v":0},{"$f":"IF(F102>18,\"GOLD\",IF(F102>16,\"SILVER\",IF(F102>14,\"BRONZE\",\"\")))","v":""},1]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A32","v":0},{"$f":"'L1 Scores'!B32","v":0},{"$f":"'L1 Scores'!O32","v":0},{"$f":"'L1 Scores'!U322","v":0},{"$f":"'L1 Scores'!Y32","v":0},"",2]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A33","v":0},{"$f":"'L1 Scores'!B33","v":0},{"$f":"'L1 Scores'!O33","v":0},{"$f":"'L1 Scores'!U323","v":0},{"$f":"'L1 Scores'!Y33","v":0},"",3]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A32","v":0},{"$f":"'L2 Scores'!B32","v":0},{"$f":"'L2 Scores'!Q32","v":0},{"$f":"'L2 Scores'!W32","v":0},{"$f":"'L2 Scores'!AA32","v":0},"",1]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A33","v":0},{"$f":"'L2 Scores'!B33","v":0},{"$f":"'L2 Scores'!Q33","v":0},{"$f":"'L2 Scores'!W33","v":0},{"$f":"'L2 Scores'!AA33","v":0},"",2]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A31","v":0},{"$f":"'L2 Scores'!B31","v":0},{"$f":"'L2 Scores'!Q31","v":0},{"$f":"'L2 Scores'!W31","v":0},{"$f":"'L2 Scores'!AA31","v":0},"",3]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A30","v":0},{"$f":"'L3 Scores'!B30","v":0},{"$f":"'L3 Scores'!Q30","v":0},{"$f":"'L3 Scores'!W30","v":0},{"$f":"'L3 Scores'!AA30","v":0},null,1]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A31","v":0},{"$f":"'L3 Scores'!B31","v":0},{"$f":"'L3 Scores'!Q31","v":0},{"$f":"'L3 Scores'!W31","v":0},{"$f":"'L3 Scores'!AA31","v":0},null,2]
[{"$f":"'L3 Scores'!I1","v":3},{"$f":"'L3 Scores'!A32","v":0},{"$f":"'L3 Scores'!B32","v":0},{"$f":"'L3 Scores'!Q32","v":0},{"$f":"'L3 Scores'!W32","v":0},{"$f":"'L3 Scores'!AA32","v":0},null,3]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A29","v":0},{"$f":"'L4 Scores'!B29","v":0},{"$f":"'L4 Scores'!P29","v":0},{"$f":"'L4 Scores'!T29","v":0},{"$f":"'L4 Scores'!X29","v":0},null,1]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A30","v":0},{"$f":"'L4 Scores'!B30","v":0},{"$f":"'L4 Scores'!P30","v":0},{"$f":"'L4 Scores'!T30","v":0},{"$f":"'L4 Scores'!X30","v":0},null,2]
[{"$f":"'L4 Scores'!I1","v":4},{"$f":"'L4 Scores'!A31","v":0},{"$f":"'L4 Scores'!B31","v":0},{"$f":"'L4 Scores'!P31","v":0},{"$f":"'L4 Scores'!T31","v":0},{"$f":"'L4 Scores'!X31","v":0},null,3]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A29","v":0},{"$f":"'L5 Scores'!B29","v":0},{"$f":"'L5 Scores'!P29","v":0},{"$f":"'L5 Scores'!T29","v":0},{"$f":"'L5 Scores'!X29","v":0},null,1]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A30","v":0},{"$f":"'L5 Scores'!B30","v":0},{"$f":"'L5 Scores'!P30","v":0},{"$f":"'L5 Scores'!T30","v":0},{"$f":"'L5 Scores'!X30","v":0},null,2]
[{"$f":"'L5 Scores'!I1","v":5},{"$f":"'L5 Scores'!A31","v":0},{"$f":"'L5 Scores'!B31","v":0},{"$f":"'L5 Scores'!P31","v":0},{"$f":"'L5 Scores'!T31","v":0},{"$f":"'L5 Scores'!X31","v":0},null,3]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L5 Scores'!A29","v":0},{"$f":"'L5 Scores'!B29","v":0},{"$f":"'L5 Scores'!P29","v":0},{"$f":"'L5 Scores'!T29","v":0},{"$f":"'L5 Scores'!X29","v":0},null,1]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L5 Scores'!A30","v":0},{"$f":"'L5 Scores'!B30","v":0},{"$f":"'L5 Scores'!P30","v":0},{"$f":"'L5 Scores'!T30","v":0},{"$f":"'L5 Scores'!X30","v":0},null,2]
[{"$f":"'L6 Scores'!I1","v":6},{"$f":"'L5 Scores'!A31","v":0},{"$f":"'L5 Scores'!B31","v":0},{"$f":"'L5 Scores'!P31","v":0},{"$f":"'L5 Scores'!T31","v":0},{"$f":"'L5 Scores'!X31","v":0},null,3]
[]
[null,"HUGS (Hope Unites Gymnastics with Special Needs)"]
[]
["Level","CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A34","v":0},{"$f":"'L1 Scores'!B34","v":0},{"$f":"'L1 Scores'!O34","v":0},{"$f":"'L1 Scores'!U34","v":0},{"$f":"'L1 Scores'!Y34","v":0},{"$f":"IF(F124>18,\"GOLD\",IF(F124>16,\"SILVER\",IF(F124>0,\"BRONZE\",\"\")))","v":""}]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A35","v":0},{"$f":"'L1 Scores'!B35","v":0},{"$f":"'L1 Scores'!O35","v":0},{"$f":"'L1 Scores'!U35","v":0},{"$f":"'L1 Scores'!Y35","v":0},""]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!A36","v":0},{"$f":"'L1 Scores'!B36","v":0},{"$f":"'L1 Scores'!O36","v":0},{"$f":"'L1 Scores'!U36","v":0},{"$f":"'L1 Scores'!Y36","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A34","v":0},{"$f":"'L2 Scores'!B34","v":0},{"$f":"'L2 Scores'!Q34","v":0},{"$f":"'L2 Scores'!W34","v":0},{"$f":"'L2 Scores'!AA34","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A35","v":0},{"$f":"'L2 Scores'!B35","v":0},{"$f":"'L2 Scores'!Q35","v":0},{"$f":"'L2 Scores'!W35","v":0},{"$f":"'L2 Scores'!AA35","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A36","v":0},{"$f":"'L2 Scores'!B36","v":0},{"$f":"'L2 Scores'!Q36","v":0},{"$f":"'L2 Scores'!W36","v":0},{"$f":"'L2 Scores'!AA36","v":0},""]
[]
[null,"UNIFIED"]
[]
[null,"CLUB","TEAM NAME","JUMP","FLOOR","TOTAL","Medal Color"]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!G37","v":0},{"$f":"'L1 Scores'!H37","v":0},{"$f":"'L1 Scores'!O37","v":0},{"$f":"'L1 Scores'!U37","v":0},{"$f":"'L1 Scores'!Y37","v":0},{"$f":"IF(F134>18,\"GOLD\",IF(F134>16,\"SILVER\",IF(F134>0,\"BRONZE\",\"\")))","v":""}]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!G38","v":0},{"$f":"'L1 Scores'!H38","v":0},{"$f":"'L1 Scores'!O38","v":0},{"$f":"'L1 Scores'!U38","v":0},{"$f":"'L1 Scores'!Y38","v":0},""]
[{"$f":"'L1 Scores'!I1","v":1},{"$f":"'L1 Scores'!G39","v":0},{"$f":"'L1 Scores'!H39","v":0},{"$f":"'L1 Scores'!O39","v":0},{"$f":"'L1 Scores'!U39","v":0},{"$f":"'L1 Scores'!Y39","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A39","v":0},{"$f":"'L2 Scores'!B39","v":0},{"$f":"'L2 Scores'!Q39","v":0},{"$f":"'L2 Scores'!W39","v":0},{"$f":"'L2 Scores'!AA39","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A38","v":0},{"$f":"'L2 Scores'!B38","v":0},{"$f":"'L2 Scores'!Q38","v":0},{"$f":"'L2 Scores'!W38","v":0},{"$f":"'L2 Scores'!AA38","v":0},""]
[{"$f":"'L2 Scores'!I1","v":2},{"$f":"'L2 Scores'!A37","v":0},{"$f":"'L2 Scores'!B37","v":0},{"$f":"'L2 Scores'!Q37","v":0},{"$f":"'L2 Scores'!W37","v":0},{"$f":"'L2 Scores'!AA37","v":0},""]

{"sheet":"ALL SCORES L7 and up","index":20,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Power TeamGym Results",null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,"This data is imported from the spreadsheets labelled L7 Scores, L8 Scores, L9 Scores and L10 Scores."]
[null,"Qualifying Score for Nationals is 24.0 or higher"]
[null,"OPEN FEMALE",null,null,"Vault / ",null,null,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
["Level","CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A18","v":0},{"$f":"'L7 Scores'!B18","v":0},{"$f":"'L7 Scores'!N18","v":0},{"$f":"'L7 Scores'!X18","v":0},{"$f":"'L7 Scores'!AB18","v":0},{"$f":"'L7 Scores'!AF18","v":0},1]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A17","v":0},{"$f":"'L7 Scores'!B17","v":0},{"$f":"'L7 Scores'!N17","v":0},{"$f":"'L7 Scores'!X17","v":0},{"$f":"'L7 Scores'!AB17","v":0},{"$f":"'L7 Scores'!AF17","v":0},2]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A16","v":0},{"$f":"'L7 Scores'!B16","v":0},{"$f":"'L7 Scores'!N16","v":0},{"$f":"'L7 Scores'!X16","v":0},{"$f":"'L7 Scores'!AB16","v":0},{"$f":"'L7 Scores'!AF16","v":0},3]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A19","v":0},{"$f":"'L7 Scores'!B19","v":0},{"$f":"'L7 Scores'!N19","v":0},{"$f":"'L7 Scores'!X19","v":0},{"$f":"'L7 Scores'!AB19","v":0},{"$f":"'L7 Scores'!AF19","v":0},4]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A20","v":0},{"$f":"'L7 Scores'!B20","v":0},{"$f":"'L7 Scores'!N20","v":0},{"$f":"'L7 Scores'!X20","v":0},{"$f":"'L7 Scores'!AB20","v":0},{"$f":"'L7 Scores'!AF20","v":0},5]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A21","v":0},{"$f":"'L7 Scores'!B21","v":0},{"$f":"'L7 Scores'!N21","v":0},{"$f":"'L7 Scores'!X21","v":0},{"$f":"'L7 Scores'!AB21","v":0},{"$f":"'L7 Scores'!AF21","v":0},6]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A22","v":0},{"$f":"'L7 Scores'!B22","v":0},{"$f":"'L7 Scores'!N22","v":0},{"$f":"'L7 Scores'!X22","v":0},{"$f":"'L7 Scores'!AB22","v":0},{"$f":"'L7 Scores'!AF22","v":0},7]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A23","v":0},{"$f":"'L7 Scores'!B23","v":0},{"$f":"'L7 Scores'!N23","v":0},{"$f":"'L7 Scores'!X23","v":0},{"$f":"'L7 Scores'!AB23","v":0},{"$f":"'L7 Scores'!AF23","v":0},8]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A24","v":0},{"$f":"'L7 Scores'!B24","v":0},{"$f":"'L7 Scores'!N24","v":0},{"$f":"'L7 Scores'!X24","v":0},{"$f":"'L7 Scores'!AB24","v":0},{"$f":"'L7 Scores'!AF24","v":0},9]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A25","v":0},{"$f":"'L7 Scores'!B25","v":0},{"$f":"'L7 Scores'!N25","v":0},{"$f":"'L7 Scores'!X25","v":0},{"$f":"'L7 Scores'!AB25","v":0},{"$f":"'L7 Scores'!AF25","v":0},10]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A26","v":0},{"$f":"'L7 Scores'!B26","v":0},{"$f":"'L7 Scores'!N26","v":0},{"$f":"'L7 Scores'!X26","v":0},{"$f":"'L7 Scores'!AB26","v":0},{"$f":"'L7 Scores'!AF26","v":0},11]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A27","v":0},{"$f":"'L7 Scores'!B27","v":0},{"$f":"'L7 Scores'!N27","v":0},{"$f":"'L7 Scores'!X27","v":0},{"$f":"'L7 Scores'!AB27","v":0},{"$f":"'L7 Scores'!AF27","v":0},12]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A16","v":0},{"$f":"'L8 Scores'!B16","v":0},{"$f":"'L8 Scores'!N16","v":0},{"$f":"'L8 Scores'!X16","v":0},{"$f":"'L8 Scores'!AB16","v":0},{"$f":"'L8 Scores'!AF16","v":0},1]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A17","v":0},{"$f":"'L8 Scores'!B17","v":0},{"$f":"'L8 Scores'!N17","v":0},{"$f":"'L8 Scores'!X17","v":0},{"$f":"'L8 Scores'!AB17","v":0},{"$f":"'L8 Scores'!AF17","v":0},2]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A18","v":0},{"$f":"'L8 Scores'!B18","v":0},{"$f":"'L8 Scores'!N18","v":0},{"$f":"'L8 Scores'!X18","v":0},{"$f":"'L8 Scores'!AB18","v":0},{"$f":"'L8 Scores'!AF18","v":0},3]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A19","v":0},{"$f":"'L8 Scores'!B19","v":0},{"$f":"'L8 Scores'!N19","v":0},{"$f":"'L8 Scores'!X19","v":0},{"$f":"'L8 Scores'!AB19","v":0},{"$f":"'L8 Scores'!AF19","v":0},4]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A20","v":0},{"$f":"'L8 Scores'!B20","v":0},{"$f":"'L8 Scores'!N20","v":0},{"$f":"'L8 Scores'!X20","v":0},{"$f":"'L8 Scores'!AB20","v":0},{"$f":"'L8 Scores'!AF20","v":0},5]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A21","v":0},{"$f":"'L8 Scores'!B21","v":0},{"$f":"'L8 Scores'!N21","v":0},{"$f":"'L8 Scores'!X21","v":0},{"$f":"'L8 Scores'!AB21","v":0},{"$f":"'L8 Scores'!AF21","v":0},6]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A16","v":0},{"$f":"'L9 Scores'!B16","v":0},{"$f":"'L9 Scores'!N16","v":0},{"$f":"'L9 Scores'!X16","v":0},{"$f":"'L9 Scores'!AB16","v":0},{"$f":"'L9 Scores'!AF16","v":0},1]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A17","v":0},{"$f":"'L9 Scores'!B17","v":0},{"$f":"'L9 Scores'!N17","v":0},{"$f":"'L9 Scores'!X17","v":0},{"$f":"'L9 Scores'!AB17","v":0},{"$f":"'L9 Scores'!AF17","v":0},2]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A18","v":0},{"$f":"'L9 Scores'!B18","v":0},{"$f":"'L9 Scores'!N18","v":0},{"$f":"'L9 Scores'!X18","v":0},{"$f":"'L9 Scores'!AB18","v":0},{"$f":"'L9 Scores'!AF18","v":0},3]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A19","v":0},{"$f":"'L10 Scores'!B19","v":0},{"$f":"'L10 Scores'!N19","v":0},{"$f":"'L10 Scores'!X19","v":0},{"$f":"'L10 Scores'!AB19","v":0},{"$f":"'L10 Scores'!AF19","v":0},1]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A18","v":0},{"$f":"'L10 Scores'!B18","v":0},{"$f":"'L10 Scores'!N18","v":0},{"$f":"'L10 Scores'!X18","v":0},{"$f":"'L10 Scores'!AB18","v":0},{"$f":"'L10 Scores'!AF18","v":0},2]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A17","v":0},{"$f":"'L10 Scores'!B17","v":0},{"$f":"'L10 Scores'!N17","v":0},{"$f":"'L10 Scores'!X17","v":0},{"$f":"'L10 Scores'!AB17","v":0},{"$f":"'L10 Scores'!AF17","v":0},3]
[]
[null,"OPEN MALE",null,null,"Vault / "]
["Level","CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A28","v":0},{"$f":"'L7 Scores'!M28","v":0},{"$f":"'L7 Scores'!W28","v":0},{"$f":"'L7 Scores'!AA28","v":0},{"$f":"'L7 Scores'!AE28","v":0},{"$f":"'L7 Scores'!AF28","v":0},1]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A29","v":0},{"$f":"'L7 Scores'!M29","v":0},{"$f":"'L7 Scores'!W29","v":0},{"$f":"'L7 Scores'!AA29","v":0},{"$f":"'L7 Scores'!AE29","v":0},{"$f":"'L7 Scores'!AF29","v":0},2]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A30","v":0},{"$f":"'L7 Scores'!M30","v":0},{"$f":"'L7 Scores'!W30","v":0},{"$f":"'L7 Scores'!AA30","v":0},{"$f":"'L7 Scores'!AE30","v":0},{"$f":"'L7 Scores'!AF30","v":0},3]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A28","v":0},{"$f":"'L8 Scores'!B28","v":0},{"$f":"'L8 Scores'!N28","v":0},{"$f":"'L8 Scores'!X28","v":0},{"$f":"'L8 Scores'!AB28","v":0},{"$f":"'L8 Scores'!AF28","v":0},1]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A29","v":0},{"$f":"'L8 Scores'!B29","v":0},{"$f":"'L8 Scores'!N29","v":0},{"$f":"'L8 Scores'!X29","v":0},{"$f":"'L8 Scores'!AB29","v":0},{"$f":"'L8 Scores'!AF29","v":0},2]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A30","v":0},{"$f":"'L8 Scores'!B30","v":0},{"$f":"'L8 Scores'!N30","v":0},{"$f":"'L8 Scores'!X30","v":0},{"$f":"'L8 Scores'!AB30","v":0},{"$f":"'L8 Scores'!AF30","v":0},3]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A30","v":0},{"$f":"'L9 Scores'!B30","v":0},{"$f":"'L9 Scores'!N30","v":0},{"$f":"'L9 Scores'!X30","v":0},{"$f":"'L9 Scores'!AB30","v":0},{"$f":"'L9 Scores'!AF30","v":0},1]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A29","v":0},{"$f":"'L9 Scores'!B29","v":0},{"$f":"'L9 Scores'!N29","v":0},{"$f":"'L9 Scores'!X29","v":0},{"$f":"'L9 Scores'!AB29","v":0},{"$f":"'L9 Scores'!AF29","v":0},2]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A28","v":0},{"$f":"'L9 Scores'!B28","v":0},{"$f":"'L9 Scores'!N28","v":0},{"$f":"'L9 Scores'!X28","v":0},{"$f":"'L9 Scores'!AB28","v":0},{"$f":"'L9 Scores'!AF28","v":0},3]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A29","v":0},{"$f":"'L10 Scores'!B29","v":0},{"$f":"'L10 Scores'!N29","v":0},{"$f":"'L10 Scores'!X29","v":0},{"$f":"'L10 Scores'!AB29","v":0},{"$f":"'L10 Scores'!AF29","v":0},1]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A30","v":0},{"$f":"'L10 Scores'!B30","v":0},{"$f":"'L10 Scores'!N30","v":0},{"$f":"'L10 Scores'!X30","v":0},{"$f":"'L10 Scores'!AB30","v":0},{"$f":"'L10 Scores'!AF30","v":0},2]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A31","v":0},{"$f":"'L10 Scores'!B31","v":0},{"$f":"'L10 Scores'!N31","v":0},{"$f":"'L10 Scores'!X31","v":0},{"$f":"'L10 Scores'!AB31","v":0},{"$f":"'L10 Scores'!AF31","v":0},3]
[]
[null,"MIXED"]
["Level","CLUB","TEAM NAME","Tumbling","Vault/Trampet","Floor","TOTAL","RANK"]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A31","v":0},{"$f":"'L7 Scores'!B31","v":0},{"$f":"'L7 Scores'!N31","v":0},{"$f":"'L7 Scores'!X31","v":0},{"$f":"'L7 Scores'!AB31","v":0},{"$f":"'L7 Scores'!AF31","v":0},1]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A33","v":0},{"$f":"'L7 Scores'!B33","v":0},{"$f":"'L7 Scores'!N33","v":0},{"$f":"'L7 Scores'!X33","v":0},{"$f":"'L7 Scores'!AB33","v":0},{"$f":"'L7 Scores'!AF33","v":0},2]
[{"$f":"'L7 Scores'!I1","v":7},{"$f":"'L7 Scores'!A32","v":0},{"$f":"'L7 Scores'!B32","v":0},{"$f":"'L7 Scores'!N32","v":0},{"$f":"'L7 Scores'!X32","v":0},{"$f":"'L7 Scores'!AB32","v":0},{"$f":"'L7 Scores'!AF32","v":0},3]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A32","v":0},{"$f":"'L8 Scores'!B32","v":0},{"$f":"'L8 Scores'!N32","v":0},{"$f":"'L8 Scores'!X32","v":0},{"$f":"'L8 Scores'!AB32","v":0},{"$f":"'L8 Scores'!AF32","v":0},1]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A31","v":0},{"$f":"'L8 Scores'!B31","v":0},{"$f":"'L8 Scores'!N31","v":0},{"$f":"'L8 Scores'!X31","v":0},{"$f":"'L8 Scores'!AB31","v":0},{"$f":"'L8 Scores'!AF31","v":0},2]
[{"$f":"'L8 Scores'!I1","v":8},{"$f":"'L8 Scores'!A33","v":0},{"$f":"'L8 Scores'!B33","v":0},{"$f":"'L8 Scores'!N33","v":0},{"$f":"'L8 Scores'!X33","v":0},{"$f":"'L8 Scores'!AB33","v":0},{"$f":"'L8 Scores'!AF33","v":0},3]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A33","v":0},{"$f":"'L9 Scores'!B33","v":0},{"$f":"'L9 Scores'!N33","v":0},{"$f":"'L9 Scores'!X33","v":0},{"$f":"'L9 Scores'!AB33","v":0},{"$f":"'L9 Scores'!AF33","v":0},1]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A32","v":0},{"$f":"'L9 Scores'!B32","v":0},{"$f":"'L9 Scores'!N32","v":0},{"$f":"'L9 Scores'!X32","v":0},{"$f":"'L9 Scores'!AB32","v":0},{"$f":"'L9 Scores'!AF32","v":0},2]
[{"$f":"'L9 Scores'!I1","v":9},{"$f":"'L9 Scores'!A31","v":0},{"$f":"'L9 Scores'!B31","v":0},{"$f":"'L9 Scores'!N31","v":0},{"$f":"'L9 Scores'!X31","v":0},{"$f":"'L9 Scores'!AB31","v":0},{"$f":"'L9 Scores'!AF31","v":0},3]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A32","v":0},{"$f":"'L10 Scores'!B32","v":0},{"$f":"'L10 Scores'!N32","v":0},{"$f":"'L10 Scores'!X32","v":0},{"$f":"'L10 Scores'!AB32","v":0},{"$f":"'L10 Scores'!AF32","v":0},1]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A33","v":0},{"$f":"'L10 Scores'!B33","v":0},{"$f":"'L10 Scores'!N33","v":0},{"$f":"'L10 Scores'!X33","v":0},{"$f":"'L10 Scores'!AB33","v":0},{"$f":"'L10 Scores'!AF33","v":0},2]
[{"$f":"'L10 Scores'!I1","v":10},{"$f":"'L10 Scores'!A34","v":0},{"$f":"'L10 Scores'!B34","v":0},{"$f":"'L10 Scores'!N34","v":0},{"$f":"'L10 Scores'!X34","v":0},{"$f":"'L10 Scores'!AB34","v":0},{"$f":"'L10 Scores'!AF34","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L9 Scores","index":21,"n_rows":33,"n_cols":32,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,18,13,20],[13,21,13,22],[13,5,13,7],[13,8,13,10],[13,11,13,12],[13,15,13,17]]}
["Power TeamGym Scoresheet for Level 9",null,null,null,null,null,null,null,9]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0},"ç here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet","At this level a Four Judge Panel is used for each event.  Discard the Highest and Lowest scores FOR EACH EVENT and input the two middle scores in the spreadsheet."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information","The three events at Level 9 are:  Tumbling; Trampet; and Group Floor.  Each one will have an individual score sheet.  Determine High, High Middle, Low Middle and Low.  "]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!","After determining that the scores are within range for that event, discard High and Low.  Input the two middle scores. Values depend upon the difficulty (EG. Scores can be up to 19.0 on a pass)"]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"í","Note:  If a two judge panel is used, input both scores.",null,null,null,null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"TUMBLING  (3 PASSES)",null,null,null,null,null,null,null,null,null,"TRAMPET",null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals - TUMBLING",null,"TUMBLING",null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals -VAULT/TRAMPET",null,"TRAMPET",null,null,null,"FX",null,"sub-","HEAD JUDGE","FINAL"]
["Club","Team Name","Sqd","Division",null,"TU 1","TU 2","TU 3","TU 1","TU 2","TU 3","Avg J1","Avg J2","Score",null,"Trampet 1","Trampet 2","Trampet 3","Trampet 1","Trampet 2","Trampet 3","Avg J1","Avg J2","Score",null,"Judge 1","Judge 2","Score",null,"final","Deductions","SCORE"]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F16,G16,H16)/3,0)","v":0},{"$f":"IFERROR(SUM(I16,J16,K16)/3,0)","v":0},{"$f":"IF(M16=0,L16,(L16+M16)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P16,Q16,R16)/3,0)","v":0},{"$f":"IFERROR(SUM(S16,T16,U16)/3,0)","v":0},{"$f":"IF(W16=0,V16,(V16+W16)/2)","v":0},null,null,null,{"$f":"IF(AA16=0,Z16,((Z16+AA16)/2))","v":0},null,{"$f":"SUM(N16+X16+AB16)","v":0},null,{"$f":"SUM(AD16+AE16)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F17,G17,H17)/3,0)","v":0},{"$f":"IFERROR(SUM(I17,J17,K17)/3,0)","v":0},{"$f":"IF(M17=0,L17,(L17+M17)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P17,Q17,R17)/3,0)","v":0},{"$f":"IFERROR(SUM(S17,T17,U17)/3,0)","v":0},{"$f":"IF(W17=0,V17,(V17+W17)/2)","v":0},null,null,null,0,null,{"$f":"SUM(N17+X17+AB17)","v":0},null,{"$f":"SUM(AD17+AE17)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L9 Final","index":22,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Power TeamGym Results Level 9",null,null,"Do NOT type into this spreadsheet",null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,null,"This data is imported from the spreadsheet labelled \"L9 Scores\""]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L9 Scores'!A18","v":0},{"$f":"'L9 Scores'!B18","v":0},{"$f":"'L9 Scores'!N18","v":0},{"$f":"'L9 Scores'!X18","v":0},{"$f":"'L9 Scores'!AB18","v":0},{"$f":"'L9 Scores'!AF18","v":0},1]
[null,{"$f":"'L9 Scores'!A16","v":0},{"$f":"'L9 Scores'!B16","v":0},{"$f":"'L9 Scores'!N16","v":0},{"$f":"'L9 Scores'!X16","v":0},{"$f":"'L9 Scores'!AB16","v":0},{"$f":"'L9 Scores'!AF16","v":0},2,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L9 Scores'!A17","v":0},{"$f":"'L9 Scores'!B17","v":0},{"$f":"'L9 Scores'!N17","v":0},{"$f":"'L9 Scores'!X17","v":0},{"$f":"'L9 Scores'!AB17","v":0},{"$f":"'L9 Scores'!AF17","v":0},3]
[null,{"$f":"'L9 Scores'!A19","v":0},{"$f":"'L9 Scores'!B19","v":0},{"$f":"'L9 Scores'!N19","v":0},{"$f":"'L9 Scores'!X19","v":0},{"$f":"'L9 Scores'!AB19","v":0},{"$f":"'L9 Scores'!AF19","v":0},4]
[null,{"$f":"'L9 Scores'!A21","v":0},{"$f":"'L9 Scores'!B21","v":0},{"$f":"'L9 Scores'!N21","v":0},{"$f":"'L9 Scores'!X21","v":0},{"$f":"'L9 Scores'!AB21","v":0},{"$f":"'L9 Scores'!AF21","v":0},5]
[null,{"$f":"'L9 Scores'!A20","v":0},{"$f":"'L9 Scores'!B20","v":0},{"$f":"'L9 Scores'!N20","v":0},{"$f":"'L9 Scores'!X20","v":0},{"$f":"'L9 Scores'!AB20","v":0},{"$f":"'L9 Scores'!AF20","v":0},6]
[null,{"$f":"'L9 Scores'!A22","v":0},{"$f":"'L9 Scores'!B22","v":0},{"$f":"'L9 Scores'!N22","v":0},{"$f":"'L9 Scores'!X22","v":0},{"$f":"'L9 Scores'!AB22","v":0},{"$f":"'L9 Scores'!AF22","v":0},7]
[null,{"$f":"'L9 Scores'!A23","v":0},{"$f":"'L9 Scores'!B23","v":0},{"$f":"'L9 Scores'!N23","v":0},{"$f":"'L9 Scores'!X23","v":0},{"$f":"'L9 Scores'!AB23","v":0},{"$f":"'L9 Scores'!AF23","v":0},8]
[null,{"$f":"'L9 Scores'!A24","v":0},{"$f":"'L9 Scores'!B24","v":0},{"$f":"'L9 Scores'!N24","v":0},{"$f":"'L9 Scores'!X24","v":0},{"$f":"'L9 Scores'!AB24","v":0},{"$f":"'L9 Scores'!AF24","v":0},9]
[null,{"$f":"'L9 Scores'!A25","v":0},{"$f":"'L9 Scores'!B25","v":0},{"$f":"'L9 Scores'!N25","v":0},{"$f":"'L9 Scores'!X25","v":0},{"$f":"'L9 Scores'!AB25","v":0},{"$f":"'L9 Scores'!AF25","v":0},10]
[null,{"$f":"'L9 Scores'!A26","v":0},{"$f":"'L9 Scores'!B26","v":0},{"$f":"'L9 Scores'!N26","v":0},{"$f":"'L9 Scores'!X26","v":0},{"$f":"'L9 Scores'!AB26","v":0},{"$f":"'L9 Scores'!AF26","v":0},11]
[null,{"$f":"'L9 Scores'!A27","v":0},{"$f":"'L9 Scores'!B27","v":0},{"$f":"'L9 Scores'!N27","v":0},{"$f":"'L9 Scores'!X27","v":0},{"$f":"'L9 Scores'!AB27","v":0},{"$f":"'L9 Scores'!AF27","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L9 Scores'!A30","v":0},{"$f":"'L9 Scores'!B30","v":0},{"$f":"'L9 Scores'!N30","v":0},{"$f":"'L9 Scores'!X30","v":0},{"$f":"'L9 Scores'!AB30","v":0},{"$f":"'L9 Scores'!AF30","v":0},1]
[null,{"$f":"'L9 Scores'!A28","v":0},{"$f":"'L9 Scores'!B28","v":0},{"$f":"'L9 Scores'!N28","v":0},{"$f":"'L9 Scores'!X28","v":0},{"$f":"'L9 Scores'!AB28","v":0},{"$f":"'L9 Scores'!AF28","v":0},2]
[null,{"$f":"'L9 Scores'!A29","v":0},{"$f":"'L9 Scores'!B29","v":0},{"$f":"'L9 Scores'!N29","v":0},{"$f":"'L9 Scores'!X29","v":0},{"$f":"'L9 Scores'!AB29","v":0},{"$f":"'L9 Scores'!AF29","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L9 Scores'!A31","v":0},{"$f":"'L9 Scores'!B31","v":0},{"$f":"'L9 Scores'!N31","v":0},{"$f":"'L9 Scores'!X31","v":0},{"$f":"'L9 Scores'!AB31","v":0},{"$f":"'L9 Scores'!AF31","v":0},1]
[null,{"$f":"'L9 Scores'!A33","v":0},{"$f":"'L9 Scores'!B33","v":0},{"$f":"'L9 Scores'!N33","v":0},{"$f":"'L9 Scores'!X33","v":0},{"$f":"'L9 Scores'!AB33","v":0},{"$f":"'L9 Scores'!AF33","v":0},2]
[null,{"$f":"'L9 Scores'!A32","v":0},{"$f":"'L9 Scores'!B32","v":0},{"$f":"'L9 Scores'!N32","v":0},{"$f":"'L9 Scores'!X32","v":0},{"$f":"'L9 Scores'!AB32","v":0},{"$f":"'L9 Scores'!AF32","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]

{"sheet":"L10 Scores","index":23,"n_rows":34,"n_cols":32,"rows_kept":34,"cut":false,"hidden":false,"merged":[[14,18,14,20],[14,21,14,22],[14,5,14,7],[14,8,14,10],[14,11,14,12],[14,15,14,17]]}
["Power TeamGym Scoresheet for Level 10",null,null,null,null,null,null,null,10]
[]
["Event Name: ",{"$f":"'Meet Information Sheet'!B3","v":0},"Please do","Division",null,"Important Note: Group squads by division on this tabulation sheet."]
["Event location:",{"$f":"'Meet Information Sheet'!B4","v":0},"NOT","OF","OPEN FEMALE: Squads that are all female, or predominantly female with a minority number males allowed. "]
["Event date: ",{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},"type","OM","OPEN MALE: Squads that are all male, or predominantly male with a minority number females allowed."]
["Meet Director: ",{"$f":"'Meet Information Sheet'!B7","v":0},"ç here.","MIX","MIXED: Squads must consist of 50% male and female members. ±1 is allowed"]
[null,null,"Use"]
["Jump Judge 1: ",{"$f":"'Meet Information Sheet'!B11","v":0},"Meet","At this level a Four Judge Panel is used for each event.  Discard the Highest and Lowest scores FOR EACH EVENT and input the two middle scores in the spreadsheet."]
["Jump Judge 2: ",{"$f":"'Meet Information Sheet'!B12","v":0},"Information","The three events at Level 10 are:  Tumbling; Trampet; and Group Floor.  Each one will have an individual score sheet.  Determine High, High Middle, Low Middle and Low.  "]
["Floor Judge 1: ",{"$f":"'Meet Information Sheet'!B15","v":0},"Sheet!","After determining that the scores are within range for that event, discard High and Low.  Input the two middle scores. "]
["Floor Judge 2: ",{"$f":"'Meet Information Sheet'!B16","v":0},"í","SCORES have open difficulty at this level so the scores may be out of greater than 19.0 per Tumbling and Vault events"]
[null,null,null,"Note:  If a two judge panel is used, input both scores.",null,null,null,null,null,"     Please DO NOT type in the yellow, grey or aqua areas.",null,null,null,null,null,null,null,"Do not delete rows or columns."]
[]
[null,null,null,null,null,"TUMBLING  (3 PASSES)",null,null,null,null,null,null,null,null,null,"TRAMPET",null,null,null,null,null,null,null,null,null,"GROUP FLOOR",null,null,null,"FINAL"]
[null,null,"#in",null,null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals - TUMBLING",null,"TUMBLING",null,"Judge 1 High MIDDLE",null,null,"Judge 2  Low MIDDLE",null,null,"Sub Totals -VAULT/TRAMPET",null,"TRAMPET",null,null,null,"FX",null,"sub-","HEAD JUDGE","FINAL"]
["Club","Team Name","Sqd","Division",null,"TU 1","TU 2","TU 3","TU 1","TU 2","TU 3","Avg J1","Avg J2","Score",null,"Trampet 1","Trampet 2","Trampet 3","Trampet 1","Trampet 2","Trampet 3","Avg J1","Avg J2","Score",null,"Judge 1","Judge 2","Score",null,"final","Deductions","SCORE"]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F17,G17,H17)/3,0)","v":0},{"$f":"IFERROR(SUM(I17,J17,K17)/3,0)","v":0},{"$f":"IF(M17=0,L17,(L17+M17)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P17,Q17,R17)/3,0)","v":0},{"$f":"IFERROR(SUM(S17,T17,U17)/3,0)","v":0},{"$f":"IF(W17=0,V17,(V17+W17)/2)","v":0},null,null,null,{"$f":"IF(AA17=0,Z17,((Z17+AA17)/2))","v":0},null,{"$f":"SUM(N17+X17+AB17)","v":0},null,{"$f":"SUM(AD17+AE17)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(F18,G18,H18)/3,0)","v":0},{"$f":"IFERROR(SUM(I18,J18,K18)/3,0)","v":0},{"$f":"IF(M18=0,L18,(L18+M18)/2)","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(P18,Q18,R18)/3,0)","v":0},{"$f":"IFERROR(SUM(S18,T18,U18)/3,0)","v":0},{"$f":"IF(W18=0,V18,(V18+W18)/2)","v":0},null,null,null,0,null,{"$f":"SUM(N18+X18+AB18)","v":0},null,{"$f":"SUM(AD18+AE18)","v":0}]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OF",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"OM",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]
[null,null,null,"MIX",null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,null,null,null,0,null,0,null,0]

{"sheet":"L10 Final","index":24,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Power TeamGym Results Level 10",null,null,null,null,"PLEASE Do NOT type into this spreadsheet"]
[null,{"$f":"'Meet Information Sheet'!B3","v":0},null,{"$f":"'Meet Information Sheet'!B4","v":0},null,null,null,{"$f":"'Meet Information Sheet'!B6","v":"00:00:00"},null,null,null,null,"This data is imported from the spreadsheet labelled \"L10 Scores\""]
[null,"OPEN FEMALE"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L10 Scores'!A17","v":0},{"$f":"'L10 Scores'!B17","v":0},{"$f":"'L10 Scores'!N17","v":0},{"$f":"'L10 Scores'!X17","v":0},{"$f":"'L10 Scores'!AB17","v":0},{"$f":"'L10 Scores'!AF17","v":0},1]
[null,{"$f":"'L10 Scores'!A18","v":0},{"$f":"'L10 Scores'!B18","v":0},{"$f":"'L10 Scores'!N18","v":0},{"$f":"'L10 Scores'!X18","v":0},{"$f":"'L10 Scores'!AB18","v":0},{"$f":"'L10 Scores'!AF18","v":0},2,null,null,null,null,"And will Tabulate when you click the \"button\" to the left"]
[null,{"$f":"'L10 Scores'!A19","v":0},{"$f":"'L10 Scores'!B19","v":0},{"$f":"'L10 Scores'!N19","v":0},{"$f":"'L10 Scores'!X19","v":0},{"$f":"'L10 Scores'!AB19","v":0},{"$f":"'L10 Scores'!AF19","v":0},3]
[null,{"$f":"'L10 Scores'!A20","v":0},{"$f":"'L10 Scores'!B20","v":0},{"$f":"'L10 Scores'!N20","v":0},{"$f":"'L10 Scores'!X20","v":0},{"$f":"'L10 Scores'!AB20","v":0},{"$f":"'L10 Scores'!AF20","v":0},4]
[null,{"$f":"'L10 Scores'!A21","v":0},{"$f":"'L10 Scores'!B21","v":0},{"$f":"'L10 Scores'!N21","v":0},{"$f":"'L10 Scores'!X21","v":0},{"$f":"'L10 Scores'!AB21","v":0},{"$f":"'L10 Scores'!AF21","v":0},5]
[null,{"$f":"'L10 Scores'!A22","v":0},{"$f":"'L10 Scores'!B22","v":0},{"$f":"'L10 Scores'!N22","v":0},{"$f":"'L10 Scores'!X22","v":0},{"$f":"'L10 Scores'!AB22","v":0},{"$f":"'L10 Scores'!AF22","v":0},6]
[null,{"$f":"'L10 Scores'!A23","v":0},{"$f":"'L10 Scores'!B23","v":0},{"$f":"'L10 Scores'!N23","v":0},{"$f":"'L10 Scores'!X23","v":0},{"$f":"'L10 Scores'!AB23","v":0},{"$f":"'L10 Scores'!AF23","v":0},7]
[null,{"$f":"'L10 Scores'!A24","v":0},{"$f":"'L10 Scores'!B24","v":0},{"$f":"'L10 Scores'!N24","v":0},{"$f":"'L10 Scores'!X24","v":0},{"$f":"'L10 Scores'!AB24","v":0},{"$f":"'L10 Scores'!AF24","v":0},8]
[null,{"$f":"'L10 Scores'!A25","v":0},{"$f":"'L10 Scores'!B25","v":0},{"$f":"'L10 Scores'!N25","v":0},{"$f":"'L10 Scores'!X25","v":0},{"$f":"'L10 Scores'!AB25","v":0},{"$f":"'L10 Scores'!AF25","v":0},9]
[null,{"$f":"'L10 Scores'!A26","v":0},{"$f":"'L10 Scores'!B26","v":0},{"$f":"'L10 Scores'!N26","v":0},{"$f":"'L10 Scores'!X26","v":0},{"$f":"'L10 Scores'!AB26","v":0},{"$f":"'L10 Scores'!AF26","v":0},10]
[null,{"$f":"'L10 Scores'!A27","v":0},{"$f":"'L10 Scores'!B27","v":0},{"$f":"'L10 Scores'!N27","v":0},{"$f":"'L10 Scores'!X27","v":0},{"$f":"'L10 Scores'!AB27","v":0},{"$f":"'L10 Scores'!AF27","v":0},11]
[null,{"$f":"'L10 Scores'!A28","v":0},{"$f":"'L10 Scores'!B28","v":0},{"$f":"'L10 Scores'!N28","v":0},{"$f":"'L10 Scores'!X28","v":0},{"$f":"'L10 Scores'!AB28","v":0},{"$f":"'L10 Scores'!AF28","v":0},12]
[]
[null,"OPEN MALE"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L10 Scores'!A31","v":0},{"$f":"'L10 Scores'!B31","v":0},{"$f":"'L10 Scores'!N31","v":0},{"$f":"'L10 Scores'!X31","v":0},{"$f":"'L10 Scores'!AB31","v":0},{"$f":"'L10 Scores'!AF31","v":0},1]
[null,{"$f":"'L10 Scores'!A29","v":0},{"$f":"'L10 Scores'!B29","v":0},{"$f":"'L10 Scores'!N29","v":0},{"$f":"'L10 Scores'!X29","v":0},{"$f":"'L10 Scores'!AB29","v":0},{"$f":"'L10 Scores'!AF29","v":0},2]
[null,{"$f":"'L10 Scores'!A30","v":0},{"$f":"'L10 Scores'!B30","v":0},{"$f":"'L10 Scores'!N30","v":0},{"$f":"'L10 Scores'!X30","v":0},{"$f":"'L10 Scores'!AB30","v":0},{"$f":"'L10 Scores'!AF30","v":0},3]
[]
[null,"MIXED"]
[null,"CLUB","TEAM NAME","Tumbling","Trampet","Floor","TOTAL","RANK"]
[null,{"$f":"'L10 Scores'!A32","v":0},{"$f":"'L10 Scores'!B32","v":0},{"$f":"'L10 Scores'!N32","v":0},{"$f":"'L10 Scores'!X32","v":0},{"$f":"'L10 Scores'!AB32","v":0},{"$f":"'L10 Scores'!AF32","v":0},1]
[null,{"$f":"'L10 Scores'!A34","v":0},{"$f":"'L10 Scores'!B34","v":0},{"$f":"'L10 Scores'!N34","v":0},{"$f":"'L10 Scores'!X34","v":0},{"$f":"'L10 Scores'!AB34","v":0},{"$f":"'L10 Scores'!AF34","v":0},2]
[null,{"$f":"'L10 Scores'!A33","v":0},{"$f":"'L10 Scores'!B33","v":0},{"$f":"'L10 Scores'!N33","v":0},{"$f":"'L10 Scores'!X33","v":0},{"$f":"'L10 Scores'!AB33","v":0},{"$f":"'L10 Scores'!AF33","v":0},3]
[]
[null,"OFFICIALS SIGNATURES:"]