{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Main Menu","Module3","Module2","Module1","Options","Shooters","Sample Scores","Team Template","Scores","Scores Template","H","Results","Options Template","Awards","Awards Template","Labels","SR1 Card Template","Docs Menu","NRAReport","Team Scores","Documentation","Results Template","Docs Macros","Print Page for Labels","SR1 Card","Scorecard Indoor","Scorecard Outdoor"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":5,"pivot_tables":0},"unopened":[{"sheet":"Module3","index":1,"reason":"part_missing"},{"sheet":"Module2","index":2,"reason":"part_missing"},{"sheet":"Module1","index":3,"reason":"part_missing"},{"sheet":"Docs Macros","index":22,"reason":"part_missing"}],"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":"Main Menu","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,9],[3,4,3,5],[26,0,26,10],[27,0,27,10]]}
[]
["Bullseye (Precision Pistol) Workbook"]
["Use mouse to make a selection"]
[null,null,null,null,{"$f":"NOW()","v":"2018-09-23T15:39:55.940"}]
["If the above date is incorrect, adjust the system clock before continuing!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This application is for use with Microsoft Excel.  It was written by Edwin C. Hall"]
["and updated by Robert Myers and Ed Hall.  For further information see Documentation"]
["and Changes page(s)."]
["Version 9.00, September 2018"]

{"sheet":"Options","index":4,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,1,38,8]]}
["OPTIONS LIST (do not change placement!)","Opts",null,null,null,null,null,null,null,null,"The below information is used to fill in the SR1 Card"]
[]
["How many top places? (0-3):",1]
["Combine Masters with High Masters? (Y/N):","N",null,null,null,null,null,null,null,null,"First Name","John"]
["Combine Experts with Masters? (Y/N):","N",null,null,null,null,null,null,null,null,"Middle Initial","D."]
["Combine Sharpshooters with Experts? (Y/N):","N",null,null,null,null,null,null,null,null,"Last Name","Doe "]
["Combine Marksmen with Sharpshooters? (Y/N):","N",null,null,null,null,null,null,null,null,"NRA#","123456789"]
["Combine Unclassified with which class? (MA/MK) [UN for own class]:","MA",null,null,null,null,null,null,null,null,"Date of Birth"]
[null,null,"HighMaster","Master","Expert","Sharpshooter","Marksman","Unclassified",null,null,"Street","123 Any St"]
["Combine Police with Service? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"City","Any Town"]
["Combine Service with Civilian? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"State","US"]
["Combine Civilian with Police? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"Zip code","00000"]
["Number of Awards for each Civilian class? (0-?):",null,1,1,1,1,1,1,null,null,"Tournament Date"]
["Number of Awards for each Service class? (0-?):",null,1,1,1,1,1,1,null,null,"Location"]
["Number of Awards for each Police class? (0-?):",null,1,1,1,1,1,1,null,null,"Team Name"]
[]
[null,null,null,null,null,"Payout Schedule"]
["Include Top winners in class listings? (Y/N):","N",null,null,null,null,"Grand-Agg"]
["Use Whole Name (John P. Doe Sr.) or Last, Inits (Doe, J. P. Sr.)? (W/L):","W",null,null,null,null,"Open Win:",15]
[null,null,null,null,null,null,"Open 2nd:",10]
["Special award for High Civilian(CIV)? (Y/N):","N",null,null,null,null,"Open 3rd:",5]
["Special award for High Police(POL)? (Y/N):","N",null,null,null,null,"Class 1st:",8]
["Special award for High Woman(WOM)? (Y/N):","N",null,null,null,null,"Class 2nd:",6]
["Special award for High Civilian Woman? (Y/N):","N",null,null,null,null,null,4]
["Special award for High Senior? (Y/N):","N",null,null,null,null,"Sub-Agg"]
["Special award for High Grand Senior? (Y/N):","N",null,null,null,null,"Open Win:",15]
["Special award for High Collegiate? (Y/N):","N",null,null,null,null,"Open 2nd:",10]
["Special award for High Junior? (Y/N):","N",null,null,null,null,"Open 3rd:",5]
["Special award for High Service? (Y/N):","N",null,null,null,null,"Class 1st:",8]
["Special award for High Guard? (Y/N):","N",null,null,null,null,"Class 2nd:",6]
["Special award for High Reservist? (Y/N):","N",null,null,null,null,null,4]
["Special award for High USAF? (Y/N):","N",null,null,null,null,"Match"]
["Special award for High USMC? (Y/N):","N",null,null,null,null,"Open Win:",8]
["Special award for High USN? (Y/N):","N",null,null,null,null,"Open 2nd:",6]
["Special award for High USA? (Y/N):","N",null,null,null,null,"Open 3rd:",4]
["Special award for High Veteran? (Y/N):","N",null,null,null,null,"Class 1st:",8]
["Special award2 for...(Enter title in Col C and Code in B.  See note!):","ST","High State Resident",null,null,null,"Class 2nd:",6]
["Special award3 for...(Enter title in Col C and Code in B.  See note!):",null,null,null,null,null,"All Class >2nd:",4]
["Title for Results Page:","Test Bullseye Match"]
["Add Date to Results Page? (only adds if there is a title in B39)","Y"]
["Fill in Award Page while calculating results? (Y/N)","N",null,"HM","MA","EX","SS","MK","UN"]
["Suggest Competitor Numbers using the matrix?","Y","CIV",1001,4001,7001,10001,13001,16001]
["                   The numbers in the matrix will be starting numbers for",null,"SER",2001,5001,8001,11001,14001,17001]
["                   for each class/category.",null,"POL",3001,6001,9001,12001,15001,18001]

{"sheet":"Shooters","index":5,"n_rows":3,"n_cols":131,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matches","Most","2nd most","3rd most","email Address","Phone#Day","Phone#Eve","DOB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E:E)-1","v":1},{"$f":"COUNTA(A:A)-1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Comp#","NRA#","First Name","MI.","Last Name","Sfx.","Address","City","State","Zip","Class","Category","Special","Special2","Special3","Special4","Attended","Recent","Recent","Recent"]
[null,"123456789","John","D.","Doe",null,"123 Any St","Any Town","US","00000","EX","CIV",null,null,null,null,1,"9/23/2018 "]

{"sheet":"Sample Scores","index":6,"n_rows":26,"n_cols":100,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Comp#","Competitor Name","22 Slow","22 NMC","22 Timed","22 Rapid","22 Agg","CF Slow","CF NMC","CF Timed","CF Rapid","CF Agg","45 Slow","45 NMC","45 Timed","45 Rapid","45 Agg","Grand Agg","Class","Category","Special","Special2","Special3","Special4","NRA#",null,"Shooter Awards Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor:",1,null,null,null,null,null,null,null,{"$f":"COUNTA(B:B)-2","v":18},18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["NULL","NULL","0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(C2,FIND(\"-\",C2)-1))+VALUE(LEFT(D2,FIND(\"-\",D2)-1))+VALUE(LEFT(E2,FIND(\"-\",E2)-1))+VALUE(LEFT(F2,FIND(\"-\",F2)-1))&\"-\"&VALUE(RIGHT(C2,(LEN(C2)-FIND(\"-\",C2))))+VALUE(RIGHT(D2,(LEN(D2)-FIND(\"-\",D2))))+VALUE(RIGHT(E2,(LEN(E2)-FIND(\"-\",E2))))+VALUE(RIGHT(F2,(LEN(F2)-FIND(\"-\",F2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(H2,FIND(\"-\",H2)-1))+VALUE(LEFT(I2,FIND(\"-\",I2)-1))+VALUE(LEFT(J2,FIND(\"-\",J2)-1))+VALUE(LEFT(K2,FIND(\"-\",K2)-1))&\"-\"&VALUE(RIGHT(H2,(LEN(H2)-FIND(\"-\",H2))))+VALUE(RIGHT(I2,(LEN(I2)-FIND(\"-\",I2))))+VALUE(RIGHT(J2,(LEN(J2)-FIND(\"-\",J2))))+VALUE(RIGHT(K2,(LEN(K2)-FIND(\"-\",K2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(M2,FIND(\"-\",M2)-1))+VALUE(LEFT(N2,FIND(\"-\",N2)-1))+VALUE(LEFT(O2,FIND(\"-\",O2)-1))+VALUE(LEFT(P2,FIND(\"-\",P2)-1))&\"-\"&VALUE(RIGHT(M2,(LEN(M2)-FIND(\"-\",M2))))+VALUE(RIGHT(N2,(LEN(N2)-FIND(\"-\",N2))))+VALUE(RIGHT(O2,(LEN(O2)-FIND(\"-\",O2))))+VALUE(RIGHT(P2,(LEN(P2)-FIND(\"-\",P2))))","v":"0-0"},{"$f":"VALUE(LEFT(G2,FIND(\"-\",G2)-1))+VALUE(LEFT(L2,FIND(\"-\",L2)-1))+VALUE(LEFT(Q2,FIND(\"-\",Q2)-1))&\"-\"&VALUE(RIGHT(G2,(LEN(G2)-FIND(\"-\",G2))))+VALUE(RIGHT(L2,(LEN(L2)-FIND(\"-\",L2))))+VALUE(RIGHT(Q2,(LEN(Q2)-FIND(\"-\",Q2))))","v":"0-0"},null,null,null,null,null,null,"NULL",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,{"$f":"(COUNTIF(AP2,\"W\")*$AT$6+(COUNTIF(AE2,\"W\")+COUNTIF(AJ2,\"W\")+COUNTIF(AO2,\"W\"))*$AT$13+(COUNTIF(AA2:AD2,\"W\")+COUNTIF(AF2:AI2,\"W\")+COUNTIF(AK2:AN2,\"W\"))*$AT$20+COUNTIF(AP2,\"1\")*$AT$9+(COUNTIF(AE2,\"1\")+COUNTIF(AJ2,\"1\")+COUNTIF(AO2,\"1\"))*$AT$16+(COUNTIF(AA2:AD2,\"1\")+COUNTIF(AF2:AI2,\"1\")+COUNTIF(AK2:AN2,\"1\"))*$AT$23+COUNTIF(AP2,\"S\")*$AT$7+(COUNTIF(AE2,\"S\")+COUNTIF(AJ2,\"S\")+COUNTIF(AO2,\"S\"))*$AT$14+(COUNTIF(AA2:AD2,\"S\")+COUNTIF(AF2:AI2,\"S\")+COUNTIF(AK2:AN2,\"S\"))*$AT$21+COUNTIF(AP2,\"T\")*$AT$8+(COUNTIF(AE2,\"T\")+COUNTIF(AJ2,\"T\")+COUNTIF(AO2,\"T\"))*$AT$15+(COUNTIF(AA2:AD2,\"T\")+COUNTIF(AF2:AI2,\"T\")+COUNTIF(AK2:AN2,\"T\"))*$AT$22+COUNTIF(AP2,\"2\")*$AT$10+(COUNTIF(AE2,\"2\")+COUNTIF(AJ2,\"2\")+COUNTIF(AO2,\"2\"))*$AT$17+(COUNTIF(AA2:AD2,\"2\")+COUNTIF(AF2:AI2,\"2\")+COUNTIF(AK2:AN2,\"2\"))*$AT$24+(COUNTIF(AA2:AP2,\">2\")*$AT$26))*$AS$1","v":16},"Total",{"$f":"SUM(AQ:AQ)-AQ2","v":0}]
["1001","TestHMCIV","192-4","295-15","200-14","196-9","883-42","189-8","290-5","197-10","188-6","864-29","191-5","289-10","197-8","191-7","868-30","2615-101","HM","CIV",null,null,null,null,"Test101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Payout Schedule"]
[1002,"TestHMSER","190-6","294-12","199-14","200-14","883-46","191-3","292-10","197-8","196-11","876-32","192-3","287-11","199-12","193-8","871-34","2630-112","HM","SER","WOM",null,null,"USAF","Test102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[1003,"TestHMPOL","190-4","295-15","199-12","195-7","879-38","186-4","295-11","199-8","197-8","877-31","185-3","286-16","198-8","197-11","866-38","2622-107","HM","POL","SEN","MD",null,null,"Test103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Grand-Agg"]
[1004,"TestMACIV","187-1","291-9","198-13","198-12","874-35","184-5","295-13","198-11","194-8","871-37","189-6","294-12","198-10","195-6","876-34","2621-106","MA","CIV",null,null,null,null,"Test104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open Win:",5]
[1005,"TestMASER","185-2","288-9","199-13","197-10","869-34","186-6","284-7","195-11","179-5","844-29","182-3","283-9","193-11","195-5","853-28","2566-91","MA","SER",null,null,null,null,"Test105",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open 2nd:",4]
[1006,"TestMAPOL","180-2","293-11","196-12","198-8","867-33","189-8","286-10","194-8","194-9","863-35","176-1","286-13","195-10","197-6","854-30","2584-98","MA","POL",null,null,null,null,"Test106",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open 3rd:",3]
[1007,"TestEXCIV","193-4","294-13","199-10","197-12","883-39","182-4","286-6","191-7","164-3","823-20","183-3","288-7","194-9","183-4","848-23","2554-82","EX","CIV",null,null,null,null,"Test107",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Class 1st:",3]
[1008,"TestEXSER","186-2","287-9","192-5","194-6","859-22","169-1","272-7","193-11","194-5","828-24","176-3","280-8","194-8","142-3","792-22","2479-68","EX","SER",null,null,null,null,"Test108",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Class 2nd:",2]
[1009,"TestEXPOL","190-1","283-10","195-8","193-9","861-28","123-2","241-2","193-4","191-4","748-12","165-3","281-5","187-5","181-2","814-15","2423-55","EX","POL",null,null,null,null,"Test109",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[1010,"TestSSCIV","172-1","282-7","191-8","188-6","833-22","182-1","265-4","180-6","188-5","815-16","182-2","233-3","194-9","177-1","786-15","2434-53","SS","CIV","JUN","MD",null,null,"Test110",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Sub-Agg"]
[1011,"TestSSSER","169-2","277-8","195-4","192-6","833-20","171-2","259-4","178-4","181-5","789-15","163-0","280-8","191-5","171-0","805-13","2427-48","SS","SER",null,null,null,null,"Test111",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open Win:",4]
[1012,"TestSSPOL","185-5","276-5","194-6","184-2","839-18","169-0","246-2","186-6","174-3","775-11","162-3","273-4","187-5","183-2","805-14","2419-43","SS","POL",null,"MD",null,null,"Test112",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open 2nd:",3]
[1013,"TestMKCIV","179-6","280-6","163-3","190-5","812-20","180-2","276-7","194-7","188-3","838-19","181-3","273-6","187-4","188-4","829-17","2479-56","MK","CIV","WOM","MD",null,null,"Test113",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open 3rd:",2]
[1014,"TestMKSER","175-2","273-4","191-3","188-8","827-17","144-0","228-3","163-2","128-1","663-6","147-3","261-2","182-7","181-6","771-18","2261-41","MK","SER","NG",null,null,null,"Test114",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Class 1st:",2]
[1015,"TestMKPOL","156-2","265-4","176-2","177-5","774-13","157-3","256-7","170-3","178-3","761-16","158-2","256-4","173-0","167-2","754-8","2289-37","MK","POL",null,null,null,null,"Test115",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Class 2nd:",1]
[1016,"TestUNCIV","164-1","284-5","191-6","191-6","830-18","161-3","255-5","186-4","174-3","776-15","156-3","275-8","189-4","182-3","802-18","2408-51","UN","CIV",null,"MD",null,null,"Test116",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[1017,"TestUNSER","176-1","273-6","191-7","195-8","835-22","152-2","237-5","169-6","133-1","691-14","147-2","231-2","180-5","138-3","696-12","2222-48","UN","SER",null,null,null,null,"Test117",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Match"]
[1018,"TestUNPOL","173-1","262-5","185-4","196-7","816-17","187-5","266-5","181-6","183-3","817-19","173-2","265-5","193-5","186-5","817-17","2450-53","UN","POL",null,null,null,null,"Test118",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Open Win:",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open 2nd:",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open 3rd:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class 1st:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Class 2nd:",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Class >2nd:",1]

{"sheet":"Team Template","index":7,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Team Matches"]
["Comp#","Names","22 NMC","22 Agg","CF NMC","CF Agg","45 NMC","45 Agg","Team Agg"]
[]
["Team:",null,null,null,null,null,null,"Class/Cat:"]
[null,"CompName1","0-0",null,"0-0",null,"0-0"]
[null,"CompName2","0-0",null,"0-0",null,"0-0"]
[null,"CompName3","0-0",null,"0-0",null,"0-0"]
[null,"CompName4","0-0",null,"0-0",null,"0-0"]
[null,"CompName5","0-0",null,"0-0",null,"0-0"]
[null,"CompName6","0-0",{"$f":"VALUE(LEFT(C5,FIND(\"-\",C5)-1))+VALUE(LEFT(C6,FIND(\"-\",C6)-1))+VALUE(LEFT(C7,FIND(\"-\",C7)-1))+VALUE(LEFT(C8,FIND(\"-\",C8)-1))+VALUE(LEFT(C9,FIND(\"-\",C9)-1))+VALUE(LEFT(C10,FIND(\"-\",C10)-1))&\"-\"&VALUE(RIGHT(C5,(LEN(C5)-FIND(\"-\",C5))))+VALUE(RIGHT(C6,(LEN(C6)-FIND(\"-\",C6))))+VALUE(RIGHT(C7,(LEN(C7)-FIND(\"-\",C7))))+VALUE(RIGHT(C8,(LEN(C8)-FIND(\"-\",C8))))+VALUE(RIGHT(C9,(LEN(C9)-FIND(\"-\",C9))))+VALUE(RIGHT(C10,(LEN(C10)-FIND(\"-\",C10))))","v":"0-0"},"0-0",{"$f":"VALUE(LEFT(E5,FIND(\"-\",E5)-1))+VALUE(LEFT(E6,FIND(\"-\",E6)-1))+VALUE(LEFT(E7,FIND(\"-\",E7)-1))+VALUE(LEFT(E8,FIND(\"-\",E8)-1))+VALUE(LEFT(E9,FIND(\"-\",E9)-1))+VALUE(LEFT(E10,FIND(\"-\",E10)-1))&\"-\"&VALUE(RIGHT(E5,(LEN(E5)-FIND(\"-\",E5))))+VALUE(RIGHT(E6,(LEN(E6)-FIND(\"-\",E6))))+VALUE(RIGHT(E7,(LEN(E7)-FIND(\"-\",E7))))+VALUE(RIGHT(E8,(LEN(E8)-FIND(\"-\",E8))))+VALUE(RIGHT(E9,(LEN(E9)-FIND(\"-\",E9))))+VALUE(RIGHT(E10,(LEN(E10)-FIND(\"-\",E10))))","v":"0-0"},"0-0",{"$f":"VALUE(LEFT(G5,FIND(\"-\",G5)-1))+VALUE(LEFT(G6,FIND(\"-\",G6)-1))+VALUE(LEFT(G7,FIND(\"-\",G7)-1))+VALUE(LEFT(G8,FIND(\"-\",G8)-1))+VALUE(LEFT(G9,FIND(\"-\",G9)-1))+VALUE(LEFT(G10,FIND(\"-\",G10)-1))&\"-\"&VALUE(RIGHT(G5,(LEN(G5)-FIND(\"-\",G5))))+VALUE(RIGHT(G6,(LEN(G6)-FIND(\"-\",G6))))+VALUE(RIGHT(G7,(LEN(G7)-FIND(\"-\",G7))))+VALUE(RIGHT(G8,(LEN(G8)-FIND(\"-\",G8))))+VALUE(RIGHT(G9,(LEN(G9)-FIND(\"-\",G9))))+VALUE(RIGHT(G10,(LEN(G10)-FIND(\"-\",G10))))","v":"0-0"},{"$f":"VALUE(LEFT(D10,FIND(\"-\",D10)-1))+VALUE(LEFT(F10,FIND(\"-\",F10)-1))+VALUE(LEFT(H10,FIND(\"-\",H10)-1))&\"-\"&VALUE(RIGHT(D10,(LEN(D10)-FIND(\"-\",D10))))+VALUE(RIGHT(F10,(LEN(F10)-FIND(\"-\",F10))))+VALUE(RIGHT(H10,(LEN(H10)-FIND(\"-\",H10))))","v":"0-0"}]
["Captain:","CaptName"]
["Coach:","CoachName"]

{"sheet":"Scores","index":8,"n_rows":2,"n_cols":100,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Comp#","Competitor Name","22 Slow","22 NMC","22 Timed","22 Rapid","22 Agg","CF Slow","CF NMC","CF Timed","CF Rapid","CF Agg","45 Slow","45 NMC","45 Timed","45 Rapid","45 Agg","Grand Agg","Class","Category","Special","Special2","Special3",null,"NRA#",null,"Shooter Awards Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor:",2,null,null,null,null,null,null,null,{"$f":"COUNTA(B:B)-2","v":0},18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["NULL","NULL","0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(C2,FIND(\"-\",C2)-1))+VALUE(LEFT(D2,FIND(\"-\",D2)-1))+VALUE(LEFT(E2,FIND(\"-\",E2)-1))+VALUE(LEFT(F2,FIND(\"-\",F2)-1))&\"-\"&VALUE(RIGHT(C2,(LEN(C2)-FIND(\"-\",C2))))+VALUE(RIGHT(D2,(LEN(D2)-FIND(\"-\",D2))))+VALUE(RIGHT(E2,(LEN(E2)-FIND(\"-\",E2))))+VALUE(RIGHT(F2,(LEN(F2)-FIND(\"-\",F2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(H2,FIND(\"-\",H2)-1))+VALUE(LEFT(I2,FIND(\"-\",I2)-1))+VALUE(LEFT(J2,FIND(\"-\",J2)-1))+VALUE(LEFT(K2,FIND(\"-\",K2)-1))&\"-\"&VALUE(RIGHT(H2,(LEN(H2)-FIND(\"-\",H2))))+VALUE(RIGHT(I2,(LEN(I2)-FIND(\"-\",I2))))+VALUE(RIGHT(J2,(LEN(J2)-FIND(\"-\",J2))))+VALUE(RIGHT(K2,(LEN(K2)-FIND(\"-\",K2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(M2,FIND(\"-\",M2)-1))+VALUE(LEFT(N2,FIND(\"-\",N2)-1))+VALUE(LEFT(O2,FIND(\"-\",O2)-1))+VALUE(LEFT(P2,FIND(\"-\",P2)-1))&\"-\"&VALUE(RIGHT(M2,(LEN(M2)-FIND(\"-\",M2))))+VALUE(RIGHT(N2,(LEN(N2)-FIND(\"-\",N2))))+VALUE(RIGHT(O2,(LEN(O2)-FIND(\"-\",O2))))+VALUE(RIGHT(P2,(LEN(P2)-FIND(\"-\",P2))))","v":"0-0"},{"$f":"VALUE(LEFT(G2,FIND(\"-\",G2)-1))+VALUE(LEFT(L2,FIND(\"-\",L2)-1))+VALUE(LEFT(Q2,FIND(\"-\",Q2)-1))&\"-\"&VALUE(RIGHT(G2,(LEN(G2)-FIND(\"-\",G2))))+VALUE(RIGHT(L2,(LEN(L2)-FIND(\"-\",L2))))+VALUE(RIGHT(Q2,(LEN(Q2)-FIND(\"-\",Q2))))","v":"0-0"},null,null,null,null,null,null,"NULL",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,{"$f":"(COUNTIF(AP2,\"W\")*$BA$2+(COUNTIF(AE2,\"W\")+COUNTIF(AJ2,\"W\")+COUNTIF(AO2,\"W\"))*$BF$2+(COUNTIF(AA2:AD2,\"W\")+COUNTIF(AF2:AI2,\"W\")+COUNTIF(AK2:AN2,\"W\"))*$BK$2+COUNTIF(AP2,\"1\")*$BD$2+(COUNTIF(AE2,\"1\")+COUNTIF(AJ2,\"1\")+COUNTIF(AO2,\"1\"))*$BI$2+(COUNTIF(AA2:AD2,\"1\")+COUNTIF(AF2:AI2,\"1\")+COUNTIF(AK2:AN2,\"1\"))*$BN$2+COUNTIF(AP2,\"S\")*$BB$2+(COUNTIF(AE2,\"S\")+COUNTIF(AJ2,\"S\")+COUNTIF(AO2,\"S\"))*$BG$2+(COUNTIF(AA2:AD2,\"S\")+COUNTIF(AF2:AI2,\"S\")+COUNTIF(AK2:AN2,\"S\"))*$BL$2+COUNTIF(AP2,\"T\")*$BC$2+(COUNTIF(AE2,\"T\")+COUNTIF(AJ2,\"T\")+COUNTIF(AO2,\"T\"))*$BH$2+(COUNTIF(AA2:AD2,\"T\")+COUNTIF(AF2:AI2,\"T\")+COUNTIF(AK2:AN2,\"T\"))*$BM$2+COUNTIF(AP2,\"2\")*$BE$2+(COUNTIF(AE2,\"2\")+COUNTIF(AJ2,\"2\")+COUNTIF(AO2,\"2\"))*$BJ$2+(COUNTIF(AA2:AD2,\"2\")+COUNTIF(AF2:AI2,\"2\")+COUNTIF(AK2:AN2,\"2\"))*$BO$2+(COUNTIF(AA2:AP2,\">2\")*$BP$2))*$AS$1","v":140},"Total",{"$f":"SUM(AQ:AQ)-AQ2","v":0},"Awards",null,null,"Payout Schedule -->> (see Options) -->>",null,null,null,{"$f":"Options!H19","v":15},{"$f":"Options!H20","v":10},{"$f":"Options!H21","v":5},{"$f":"Options!H22","v":8},{"$f":"Options!H23","v":6},{"$f":"Options!H26","v":15},{"$f":"Options!H27","v":10},{"$f":"Options!H28","v":5},{"$f":"Options!H29","v":8},{"$f":"Options!H30","v":6},{"$f":"Options!H33","v":8},{"$f":"Options!H34","v":6},{"$f":"Options!H35","v":4},{"$f":"Options!H36","v":8},{"$f":"Options!H37","v":6},{"$f":"Options!H38","v":4}]

{"sheet":"Scores Template","index":9,"n_rows":2,"n_cols":100,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Comp#","Competitor Name","22 Slow","22 NMC","22 Timed","22 Rapid","22 Agg","CF Slow","CF NMC","CF Timed","CF Rapid","CF Agg","45 Slow","45 NMC","45 Timed","45 Rapid","45 Agg","Grand Agg","Class","Category","Special","Special2","Special3",null,"NRA#",null,"Shooter Awards Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor:",1,null,null,null,null,null,null,null,{"$f":"COUNTA(B:B)-2","v":0},18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["NULL","NULL","0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(C2,FIND(\"-\",C2)-1))+VALUE(LEFT(D2,FIND(\"-\",D2)-1))+VALUE(LEFT(E2,FIND(\"-\",E2)-1))+VALUE(LEFT(F2,FIND(\"-\",F2)-1))&\"-\"&VALUE(RIGHT(C2,(LEN(C2)-FIND(\"-\",C2))))+VALUE(RIGHT(D2,(LEN(D2)-FIND(\"-\",D2))))+VALUE(RIGHT(E2,(LEN(E2)-FIND(\"-\",E2))))+VALUE(RIGHT(F2,(LEN(F2)-FIND(\"-\",F2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(H2,FIND(\"-\",H2)-1))+VALUE(LEFT(I2,FIND(\"-\",I2)-1))+VALUE(LEFT(J2,FIND(\"-\",J2)-1))+VALUE(LEFT(K2,FIND(\"-\",K2)-1))&\"-\"&VALUE(RIGHT(H2,(LEN(H2)-FIND(\"-\",H2))))+VALUE(RIGHT(I2,(LEN(I2)-FIND(\"-\",I2))))+VALUE(RIGHT(J2,(LEN(J2)-FIND(\"-\",J2))))+VALUE(RIGHT(K2,(LEN(K2)-FIND(\"-\",K2))))","v":"0-0"},"0-0","0-0","0-0","0-0",{"$f":"VALUE(LEFT(M2,FIND(\"-\",M2)-1))+VALUE(LEFT(N2,FIND(\"-\",N2)-1))+VALUE(LEFT(O2,FIND(\"-\",O2)-1))+VALUE(LEFT(P2,FIND(\"-\",P2)-1))&\"-\"&VALUE(RIGHT(M2,(LEN(M2)-FIND(\"-\",M2))))+VALUE(RIGHT(N2,(LEN(N2)-FIND(\"-\",N2))))+VALUE(RIGHT(O2,(LEN(O2)-FIND(\"-\",O2))))+VALUE(RIGHT(P2,(LEN(P2)-FIND(\"-\",P2))))","v":"0-0"},{"$f":"VALUE(LEFT(G2,FIND(\"-\",G2)-1))+VALUE(LEFT(L2,FIND(\"-\",L2)-1))+VALUE(LEFT(Q2,FIND(\"-\",Q2)-1))&\"-\"&VALUE(RIGHT(G2,(LEN(G2)-FIND(\"-\",G2))))+VALUE(RIGHT(L2,(LEN(L2)-FIND(\"-\",L2))))+VALUE(RIGHT(Q2,(LEN(Q2)-FIND(\"-\",Q2))))","v":"0-0"},null,null,null,null,null,null,"NULL",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,{"$f":"(COUNTIF(AP2,\"W\")*$BA$2+(COUNTIF(AE2,\"W\")+COUNTIF(AJ2,\"W\")+COUNTIF(AO2,\"W\"))*$BF$2+(COUNTIF(AA2:AD2,\"W\")+COUNTIF(AF2:AI2,\"W\")+COUNTIF(AK2:AN2,\"W\"))*$BK$2+COUNTIF(AP2,\"1\")*$BD$2+(COUNTIF(AE2,\"1\")+COUNTIF(AJ2,\"1\")+COUNTIF(AO2,\"1\"))*$BI$2+(COUNTIF(AA2:AD2,\"1\")+COUNTIF(AF2:AI2,\"1\")+COUNTIF(AK2:AN2,\"1\"))*$BN$2+COUNTIF(AP2,\"S\")*$BB$2+(COUNTIF(AE2,\"S\")+COUNTIF(AJ2,\"S\")+COUNTIF(AO2,\"S\"))*$BG$2+(COUNTIF(AA2:AD2,\"S\")+COUNTIF(AF2:AI2,\"S\")+COUNTIF(AK2:AN2,\"S\"))*$BL$2+COUNTIF(AP2,\"T\")*$BC$2+(COUNTIF(AE2,\"T\")+COUNTIF(AJ2,\"T\")+COUNTIF(AO2,\"T\"))*$BH$2+(COUNTIF(AA2:AD2,\"T\")+COUNTIF(AF2:AI2,\"T\")+COUNTIF(AK2:AN2,\"T\"))*$BM$2+COUNTIF(AP2,\"2\")*$BE$2+(COUNTIF(AE2,\"2\")+COUNTIF(AJ2,\"2\")+COUNTIF(AO2,\"2\"))*$BJ$2+(COUNTIF(AA2:AD2,\"2\")+COUNTIF(AF2:AI2,\"2\")+COUNTIF(AK2:AN2,\"2\"))*$BO$2+(COUNTIF(AA2:AP2,\">2\")*$BP$2))*$AS$1","v":70},"Total",{"$f":"SUM(AQ:AQ)-AQ2","v":0},null,null,null,"Payout Schedule -->> (see Options) -->>",null,null,null,{"$f":"Options!H19","v":15},{"$f":"Options!H20","v":10},{"$f":"Options!H21","v":5},{"$f":"Options!H22","v":8},{"$f":"Options!H23","v":6},{"$f":"Options!H26","v":15},{"$f":"Options!H27","v":10},{"$f":"Options!H28","v":5},{"$f":"Options!H29","v":8},{"$f":"Options!H30","v":6},{"$f":"Options!H33","v":8},{"$f":"Options!H34","v":6},{"$f":"Options!H35","v":4},{"$f":"Options!H36","v":8},{"$f":"Options!H37","v":6},{"$f":"Options!H38","v":4}]

{"sheet":"H","index":10,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":true,"merged":[[6,17,6,21],[0,0,2,0],[5,1,5,2],[6,0,6,2],[6,5,6,9],[6,11,6,15],[15,0,15,2],[8,0,8,2],[10,0,10,2],[11,1,11,2],[12,1,12,2],[13,0,13,2],[14,0,14,2]]}
[]
[null,"Bullseye Pistol 900 Match"]
[null,null,"Title, Date"]
[]
["Comp#","Cls/Cat","Competitor","NRA #",null,"Slow","NMC","Timed","Rapid","Sub Agg",null,"Slow","NMC","Timed","Rapid","Sub Agg",null,"Slow","NMC","Timed","Rapid","Sub Agg",null,"Grand"]
[null,"Open Winners"]
["First Place",null,null,null,null,"22 Caliber",null,null,null,null,null,"Center Fire Caliber",null,null,null,null,null,"45 Caliber",null,null,null,null,null,"Aggregate"]
[]
["Second Place"]
[]
["Third Place"]
[null,"Class Listings"]
[null,"Class"]
["Class First"]
["Class Second"]
["Class Third"]

{"sheet":"Results","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Options Template","index":12,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[[38,1,38,8]]}
["OPTIONS LIST (do not change placement!)","Opts",null,null,null,null,null,null,null,null,"The below information is used to fill in the SR1 Card"]
[]
["How many top places? (0-3):",1]
["Combine Masters with High Masters? (Y/N):","N",null,null,null,null,null,null,null,null,"First Name","John"]
["Combine Experts with Masters? (Y/N):","N",null,null,null,null,null,null,null,null,"Middle Initial","D."]
["Combine Sharpshooters with Experts? (Y/N):","N",null,null,null,null,null,null,null,null,"Last Name","Doe "]
["Combine Marksmen with Sharpshooters? (Y/N):","N",null,null,null,null,null,null,null,null,"NRA#","123456789"]
["Combine Unclassified with which class? (MA/MK) [UN for own class]:","MA",null,null,null,null,null,null,null,null,"Date of Birth"]
[null,null,"HighMaster","Master","Expert","Sharpshooter","Marksman","Unclassified",null,null,"Street","123 Any St"]
["Combine Police with Service? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"City","Any Town"]
["Combine Service with Civilian? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"State","US"]
["Combine Civilian with Police? (Y/N for each class):",null,"Y","Y","Y","Y","Y","Y",null,null,"Zip code","00000"]
["Number of Awards for each Civilian class? (0-?):",null,3,3,3,3,3,3,null,null,"Tournament Date"]
["Number of Awards for each Service class? (0-?):",null,0,0,0,0,0,0,null,null,"Location"]
["Number of Awards for each Police class? (0-?):",null,0,0,0,0,0,0,null,null,"Team Name"]
[]
[null,null,null,null,null,"Payout Schedule"]
["Include Top winners in class listings? (Y/N):","N",null,null,null,null,"Grand-Agg"]
["Use Whole Name (John P. Doe Sr.) or Last, Inits (Doe, J. P. Sr.)? (W/L):","W",null,null,null,null,"Open Win:",15]
[null,null,null,null,null,null,"Open 2nd:",10]
["Special award for High Civilian(CIV)? (Y/N):","N",null,null,null,null,"Open 3rd:",5]
["Special award for High Police(POL)? (Y/N):","N",null,null,null,null,"Class 1st:",8]
["Special award for High Woman(WOM)? (Y/N):","Y",null,null,null,null,"Class 2nd:",6]
["Special award for High Civilian Woman? (Y/N):","N",null,null,null,null,null,4]
["Special award for High Senior? (Y/N):","Y",null,null,null,null,"Sub-Agg"]
["Special award for High Grand Senior? (Y/N):","Y",null,null,null,null,"Open Win:",15]
["Special award for High Collegiate? (Y/N):","Y",null,null,null,null,"Open 2nd:",10]
["Special award for High Junior? (Y/N):","N",null,null,null,null,"Open 3rd:",5]
["Special award for High Service? (Y/N):","N",null,null,null,null,"Class 1st:",8]
["Special award for High Guard? (Y/N):","N",null,null,null,null,"Class 2nd:",6]
["Special award for High Reservist? (Y/N):","N",null,null,null,null,null,4]
["Special award for High USAF? (Y/N):","N",null,null,null,null,"Match"]
["Special award for High USMC? (Y/N):","N",null,null,null,null,"Open Win:",8]
["Special award for High USN? (Y/N):","N",null,null,null,null,"Open 2nd:",6]
["Special award for High USA? (Y/N):","N",null,null,null,null,"Open 3rd:",4]
["Special award for High Veteran? (Y/N):","Y",null,null,null,null,"Class 1st:",8]
["Special award2 for...(Enter title in Col C and Code in B.  See note!):","NY","NY Resident",null,null,null,"Class 2nd:",6]
["Special award3 for...(Enter title in Col C and Code in B.  See note!):",null,null,null,null,null,"All Class >2nd:",4]
["Title for Results Page:","Bullseye World Championship"]
["Add Date to Results Page? (only adds if there is a title in B39)","Y"]
["Fill in Award Page while calculating results? (Y/N)","N",null,"HM","MA","EX","SS","MK","UN"]
["Suggest Competitor Numbers using the matrix?","Y","CIV",1001,4001,7001,10001,13001,16001]
["                   The numbers in the matrix will be starting numbers for",null,"SER",2001,5001,8001,11001,14001,17001]
["                   for each class/category.",null,"POL",3001,6001,9001,12001,15001,18001]

{"sheet":"Awards","index":13,"n_rows":174,"n_cols":2,"rows_kept":174,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Options!B39","v":"Test Bullseye Match"}]
["Award Schedule"]
[]
["Overall Winners"]
[]
["Open Winner","Gold Medal"]
["Second Place","Silver Medal"]
["Third Place","Bronze Medal"]
["High Civilian","Black Marble with ASNPC Medallion"]
["High Police","Black Marble with ASNPC Medallion"]
["High Service","Black Marble with ASNPC Medallion"]
["High Senior","Black Marble with ASNPC Medallion"]
["High Junior","Black Marble with ASNPC Medallion"]
["High Woman","Black Marble with ASNPC Medallion"]
["High Soldier","Black Marble with ASNPC Medallion"]
["High Airman","Black Marble with ASNPC Medallion"]
["High Marine","Black Marble with ASNPC Medallion"]
["High Sailor","Black Marble with ASNPC Medallion"]
["High Guard","Black Marble with ASNPC Medallion"]
["High Reservist","Black Marble with ASNPC Medallion"]
[]
["Grand Aggregate Winners"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
[".22 Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
["CF Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
[".45 Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
["Team Match Aggregate"]
[]
["High Civilian Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Service Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Police Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Service Pistol Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]

{"sheet":"Awards Template","index":14,"n_rows":174,"n_cols":2,"rows_kept":174,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Options!B39","v":"Test Bullseye Match"}]
["Award Schedule"]
[]
["Overall Winners"]
[]
["Open Winner","Gold Medal"]
["Second Place","Silver Medal"]
["Third Place","Bronze Medal"]
["High Civilian","Black Marble with ASNPC Medallion"]
["High Police","Black Marble with ASNPC Medallion"]
["High Service","Black Marble with ASNPC Medallion"]
["High Senior","Black Marble with ASNPC Medallion"]
["High Junior","Black Marble with ASNPC Medallion"]
["High Woman","Black Marble with ASNPC Medallion"]
["High Soldier","Black Marble with ASNPC Medallion"]
["High Airman","Black Marble with ASNPC Medallion"]
["High Marine","Black Marble with ASNPC Medallion"]
["High Sailor","Black Marble with ASNPC Medallion"]
["High Guard","Black Marble with ASNPC Medallion"]
["High Reservist","Black Marble with ASNPC Medallion"]
[]
["Grand Aggregate Winners"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
[".22 Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
["CF Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
[".45 Aggregate Winners"]
[]
["High Junior","Wood Plaque with ASNPC Medallion"]
["High Senior","Wood Plaque with ASNPC Medallion"]
["High Woman","Wood Plaque with ASNPC Medallion"]
[]
["Civilian"]
["HM/CIV","Wood Plaque with ASNPC Medallion"]
["MA/CIV","Wood Plaque with ASNPC Medallion"]
["EX/CIV","Wood Plaque with ASNPC Medallion"]
["SS/CIV","Wood Plaque with ASNPC Medallion"]
["MK/CIV","Wood Plaque with ASNPC Medallion"]
[]
["Service"]
["HM/SER","Wood Plaque with ASNPC Medallion"]
["MA/SER","Wood Plaque with ASNPC Medallion"]
["EX/SER","Wood Plaque with ASNPC Medallion"]
["SS/SER","Wood Plaque with ASNPC Medallion"]
["MK/SER","Wood Plaque with ASNPC Medallion"]
[]
["Police"]
["HM/POL","Wood Plaque with ASNPC Medallion"]
["MA/POL","Wood Plaque with ASNPC Medallion"]
["EX/POL","Wood Plaque with ASNPC Medallion"]
["SS/POL","Wood Plaque with ASNPC Medallion"]
["MK/POL","Wood Plaque with ASNPC Medallion"]
[]
["Team Match Aggregate"]
[]
["High Civilian Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Service Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Police Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]
[]
["High Service Pistol Team"]
["Team Name"]
["Captain"]
["Coach"]
["Firing Member 1"]
["Firing Member 2"]
["Firing Member 3"]
["Firing Member 4"]
["Firing Member 5"]
["Firing Member 6"]
["Aggregate Score"]

{"sheet":"Labels","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SR1 Card Template","index":16,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["STATISTICAL OFFICE RECORD",null,"CIRCLE THE NUMBER OF EACH MATCH YOU WISH TO "]
["NRA CONVENTIONAL TOURNAMENTS ONLY",null,"ENTER:               All individual Matches (Check) [ ]"]
["(To be retained by Sponsor)",null,"1        2        3        4       5        6        7        8        9        10"]
[null,null,"11     12       13      14     15      16      17      18       19        20"]
[{"$f":"\"     \"&Options!L4&\" \"&Options!L5&\" \"&Options!L6","v":"     John D. Doe "}]
[" (Print)                    NAME                      COMP #",null,"I WILL FIRE TEAM MATCH NUMBER ______________________"]
[]
[{"$f":"\"     \"&Options!L9","v":"     123 Any St"},null,{"$f":"\" \"&Options!L15&\" \"","v":"  "}]
["STREET ADDRESS",null,"TEAM NAME"]
[]
[{"$f":"\"  \"&LEFT(Options!L10&\"                                 \",32)&Options!L11&RIGHT(\"                                             \"&Options!L12,45)","v":"  Any Town                        US                                        00000"},null,"CATEGORIES (circle one)"]
[" CITY                                STATE                                  ZIP CODE"]
[null,null,"Senior                                                                    Special_________________"]
["NRA CARD #1 FOR USE AS ENTRY CARD AND FOR REPORTING",null,"Civilian          Police          Reserve         Service          Woman        Nat'l Guard"]
["SCORES TO NRA. SPONSOR: IMMEDIATELY AFTER TOURNAMENT,",null,"Junior       Intermediate Jr.       Sub-Jr.       ROTC      Collegiate       High School"]
["DETACT OTHER PORTION AND SEND TO NRA. SEND ONE FOR"]
["EACH COMPETITOR. SEE RULE BOOK SECTION 19 FOR SCORES",null,"CLASSIFICATION (circle one)"]
["TO BE REPORTED FOR CLASSIFICATION. INCLUDE FIRED TEAM"]
["SCORES OF INDIVIDUALS.",null,"UNCLASSIFIED                        HIGH MASTER                             MASTER"]
[null,null,"EXPERT                                     SHARPSHOOTER                 MARKSMAN"]
[]
["No. Matches________________                Total Fees $__________________",null,"RELAY:  1st Choice____________    2nd Choice____________"]
[]
["Registration Fee $_______________               Amount Paid $_____________",null,"Relay time:__________   Day:_________   Date:___________"]
[]
[]
["SPONSOR SCORE REPORTING CARD",null,"NRA CONVENTIONAL TOURNAMENTS ONLY"]
["(Complete and return this portion to NRA)"]
[]
[{"$f":"\"NRA ID No.       \"&Options!L7","v":"NRA ID No.       123456789"}]
[null,null,"[ ] Indoor                           [ ] Outdoor"]
[{"$f":"\"Date of Birth:          \"&Options!L8","v":"Date of Birth:          "}]
[null,null,"                                                   INDIVIDUAL                            TEAM"]
["COMPETITOR NO.___________________                 (This Tournament)",null,"TYPE                              NO.        TOTAL        NO.         TOTAL"]
[null,null,"COMPETITION           SHOTS     SCORE    SHOTS     SCORE"]
[{"$f":"LEFT(\"          \"&Options!L6&\"                                \",40)&Options!L4&RIGHT(\"                                        \"&Options!L5,40)","v":"          Doe                           John                                      D."}]
["(print)    LAST NAME                   FIRST NAME                               MI",null,"Conv. Pistol                ______     ______      ______     ______"]
[null,null,"High Power Sporting   ______     ______      ______     ______"]
[{"$f":"A8","v":"     123 Any St"},null,"SBR Prone                 ______     ______      ______     ______"]
["STREET ADDRESS",null,"SBR Metric Prone       ______     ______      ______     ______"]
[null,null,"SBR 3-Position           ______     ______      ______     ______"]
[{"$f":"A11","v":"  Any Town                        US                                        00000"},null,"SBR 4-Position           ______     ______      ______     ______"]
["CITY                                 STATE                                   ZIP CODE",null,"Light Rifle                   ______     ______      ______     ______"]
[null,null,"BB Gun                      ______     ______      ______     ______"]
[{"$f":"\"                    \"&Options!L13&RIGHT(\"                                        \"&Options!L14,40)","v":"                                                            "},null,"Air Rifle 3-Position      ______     ______      ______     ______"]
["TOURNAMENT DATE & LOCATION",null,"Air Rifle 4-Position      ______     ______      ______     ______"]
[]
["Signature of Competitor:__________________________________________________"]
[]
["Excel copy of SR-1 Form for NRA Tournaments"]

{"sheet":"Docs Menu","index":17,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Quick Menu for Documentation (choose a button)"]

{"sheet":"NRAReport","index":18,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["NRA Reporting Information"]
["Date:",null,"Type:"]
[]
["NRA#","Total Shots","Total Score","Name","Address"]

{"sheet":"Team Scores","index":19,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Team Matches"]
["Comp#","Names","22 NMC","22 Agg","CF NMC","CF Agg","45 NMC","45 Agg","Team Agg"]
[]
["Team:",null,null,null,null,null,null,"Class/Cat:"]
[null,"CompName1","0-0",null,"0-0",null,"0-0"]
[null,"CompName2","0-0",null,"0-0",null,"0-0"]
[null,"CompName3","0-0",null,"0-0",null,"0-0"]
[null,"CompName4","0-0",null,"0-0",null,"0-0"]
[null,"CompName5","0-0",null,"0-0",null,"0-0"]
[null,"CompName6","0-0",{"$f":"VALUE(LEFT(C5,FIND(\"-\",C5)-1))+VALUE(LEFT(C6,FIND(\"-\",C6)-1))+VALUE(LEFT(C7,FIND(\"-\",C7)-1))+VALUE(LEFT(C8,FIND(\"-\",C8)-1))+VALUE(LEFT(C9,FIND(\"-\",C9)-1))+VALUE(LEFT(C10,FIND(\"-\",C10)-1))&\"-\"&VALUE(RIGHT(C5,(LEN(C5)-FIND(\"-\",C5))))+VALUE(RIGHT(C6,(LEN(C6)-FIND(\"-\",C6))))+VALUE(RIGHT(C7,(LEN(C7)-FIND(\"-\",C7))))+VALUE(RIGHT(C8,(LEN(C8)-FIND(\"-\",C8))))+VALUE(RIGHT(C9,(LEN(C9)-FIND(\"-\",C9))))+VALUE(RIGHT(C10,(LEN(C10)-FIND(\"-\",C10))))","v":"0-0"},"0-0",{"$f":"VALUE(LEFT(E5,FIND(\"-\",E5)-1))+VALUE(LEFT(E6,FIND(\"-\",E6)-1))+VALUE(LEFT(E7,FIND(\"-\",E7)-1))+VALUE(LEFT(E8,FIND(\"-\",E8)-1))+VALUE(LEFT(E9,FIND(\"-\",E9)-1))+VALUE(LEFT(E10,FIND(\"-\",E10)-1))&\"-\"&VALUE(RIGHT(E5,(LEN(E5)-FIND(\"-\",E5))))+VALUE(RIGHT(E6,(LEN(E6)-FIND(\"-\",E6))))+VALUE(RIGHT(E7,(LEN(E7)-FIND(\"-\",E7))))+VALUE(RIGHT(E8,(LEN(E8)-FIND(\"-\",E8))))+VALUE(RIGHT(E9,(LEN(E9)-FIND(\"-\",E9))))+VALUE(RIGHT(E10,(LEN(E10)-FIND(\"-\",E10))))","v":"0-0"},"0-0",{"$f":"VALUE(LEFT(G5,FIND(\"-\",G5)-1))+VALUE(LEFT(G6,FIND(\"-\",G6)-1))+VALUE(LEFT(G7,FIND(\"-\",G7)-1))+VALUE(LEFT(G8,FIND(\"-\",G8)-1))+VALUE(LEFT(G9,FIND(\"-\",G9)-1))+VALUE(LEFT(G10,FIND(\"-\",G10)-1))&\"-\"&VALUE(RIGHT(G5,(LEN(G5)-FIND(\"-\",G5))))+VALUE(RIGHT(G6,(LEN(G6)-FIND(\"-\",G6))))+VALUE(RIGHT(G7,(LEN(G7)-FIND(\"-\",G7))))+VALUE(RIGHT(G8,(LEN(G8)-FIND(\"-\",G8))))+VALUE(RIGHT(G9,(LEN(G9)-FIND(\"-\",G9))))+VALUE(RIGHT(G10,(LEN(G10)-FIND(\"-\",G10))))","v":"0-0"},{"$f":"VALUE(LEFT(D10,FIND(\"-\",D10)-1))+VALUE(LEFT(F10,FIND(\"-\",F10)-1))+VALUE(LEFT(H10,FIND(\"-\",H10)-1))&\"-\"&VALUE(RIGHT(D10,(LEN(D10)-FIND(\"-\",D10))))+VALUE(RIGHT(F10,(LEN(F10)-FIND(\"-\",F10))))+VALUE(RIGHT(H10,(LEN(H10)-FIND(\"-\",H10))))","v":"0-0"}]
["Captain:","CaptName"]
["Coach:","CoachName"]

{"sheet":"Documentation","index":20,"n_rows":600,"n_cols":2,"rows_kept":600,"cut":false,"hidden":false,"merged":[]}
[null,"Bullseye Scoresheet Documentation"]
[null,"By Edwin C. Hall"]
[]
[]
[null,"This application was created by Edwin C. Hall.  Questions, comments or"]
[null,"donations (if you think this package is worth a monetary award) should"]
[null,"be sent to 15 Lakeview Ave, Tupper Lake, NY 12986.  These sheets and the"]
[null,"accompanying procedures were designed to provide a basis for 2700"]
[null,"\"Bullseye\" competition management.  This package is capable of tracking"]
[null,"up to 998 competitors.  It is not a commercial program, however it"]
[null,"runs under Microsoft Excel, which is a commercially sold product.  This"]
[null,"version will display results for all matches through the Grand"]
[null,"Aggregate.  The order of matches is 22 Slow Fire through the Grand"]
[null,"Aggregate.  For the Sub-Aggregate (.22, CF, .45) results, the preceding"]
[null,"matches for that gun are also shown. In addition to the scores being"]
[null,"tallied, the application also finds the Open (W)inner, (S)econd and"]
[null,"(T)hird overall (if opted) and the place awards for each class grouping,"]
[null,"based on decisions made on the \"Options\" sheet.  For those familiar with"]
[null,"Microsoft Excel, the results as well as other items, can be further"]
[null,"groomed to fit most needs."]
[]
[null,"Important Note:  Do NOT rename this package!  Doing so will make it"]
[null,"impossible for some of the routines to be found."]
[]
[null,"Brief Description of Sheets (a more in-depth description for"]
[null,"each is provided further down):"]
[]
[null,"     Main Menu:  Provides an easy \"Push Button\" screen to"]
[null,"perform functions that are programmed into Visual Basic"]
[null,"Procedures."]
[]
[null,"     Shooters:  A datasheet which accumulates all the"]
[null,"personal information of any shooters entered in any previous"]
[null,"or current match.  As long as changes are saved when"]
[null,"leaving, this database will continue to grow with new"]
[null,"matches."]
[]
[null,"     Scores:  This is where the raw scores for a particular"]
[null,"competition are stored and compiled.  This sheet is cleared"]
[null,"by the user before each new competition is started."]
[]
[null,"     Options:  This very important sheet is the heart of"]
[null,"what you want displayed in the results.  It chooses up to"]
[null,"three top places, the special categories to display, where"]
[null,"the unclassified shooters should be placed, how to combine"]
[null,"classes and categories, and a number of other options."]
[]
[null,"     Results:   This sheet is where the results are"]
[null,"displayed.  It is updated only when the appropriate macro is"]
[null,"run.  Each update totally rewrites the sheet based on the"]
[null,"choices made on the \"Options\" sheet.  Therefore you can"]
[null,"change an option, and rerun the results with the new option."]
[]
[null,"     Documentation:  This information."]
[]
[null,"     There are sheets which are hidden and/or protected."]
[null,"These contain Visual Basic procedures and templates used to"]
[null,"run this application.  Do not disturb them with the"]
[null,"exception of the \"Sample Scores\" sheet.  This is a copy of"]
[null,"the sample scores originally provided with this package."]
[null,"You can copy and/or rename this sheet to practice setting up"]
[null,"the \"Options\" sheet."]
[]
[null,"Using the Application:"]
[null,"     This section gives a more detailed description of each"]
[null,"area as it is introduced."]
[]
[null,"The \"Main Menu\" sheet is provided to allow single buttons to"]
[null,"direct you through some of the macros built into the sheets."]
[null,"Some of the buttons leave you on a sheet to either work"]
[null,"directly with the information or to view the sheet, as with"]
[null,"the \"Results\" sheet.  The \"Shooters\" sheet also has buttons"]
[null,"which can be used to run procedures and return to the \"Main"]
[null,"Menu\" sheet.  You can also run Macros from the Macro list,"]
[null,"however the names may not be decipherable.  Experienced"]
[null,"Microsoft Excel users can edit various areas directly."]
[null,"NOTE, however, that many of the macros depend on the"]
[null,"existence, in certain locations, of prescribed information."]
[null,"In addition, many of the formulas also depend on specific"]
[null,"data in specific locations.  For example, if the \"null\" row"]
[null,"is removed from the \"Scores\" sheet, any added competitors"]
[null,"may not have scores, or the first competitor might not be"]
[null,"included in the results.  Specific guidelines for direct"]
[null,"editing will be given within each description below."]
[]
[null,"     Add Shooter to Data/Match:  By choosing this button you"]
[null,"can add a shooter to the \"Shooters\" sheet and/or to a"]
[null,"current competition.  The first prompt asks for the NRA#."]
[null,"You may add a new shooter to the list at this time or enter a"]
[null,"competitor #.  If you choose \"Cancel\" you are presented an, \"Add"]
[null,"another shooter?\" prompt.  \"Yes\" places you back at the NRA#"]
[null,"prompt.  \"No\" places you on the \"Shooters\" sheet in block"]
[null,"A3.   If instead you enter an NRA# at the prompt, you will"]
[null,"be taken through the steps of adding a shooter to the list."]
[null,"For the NRA# prompt, if the shooter doesn't yet have a"]
[null,"number, assign a unique value to identify them from the"]
[null,"others, such as \"awaiting1\" or similar.  This can be changed"]
[null,"later.  If this field is left blank, you will be returned to"]
[null,"the, \"Add another shooter?\" prompt.  If the NRA# is already"]
[null,"in the sheet, you will be prompted for a \"Unique Competitor Number.\""]
[null,"If the NRA# is not found in the list, prompts for the"]
[null,"personal data will be displayed.  There must be information"]
[null,"provided for each prompt except \"Special Category\" or you"]
[null,"will be returned to the, \"Add another shooter?\" prompt, and"]
[null,"any data already entered for the individual will be removed."]
[null,"For the Category prompt, use only CIV, SER, or POL.  For the"]
[null,"Classification prompt use the following codes only: HM, MA,"]
[null,"EX, SS, MK, UN.  For \"Special Category\" use only the"]
[null,"following codes: WOM, SEN, COL, JUN, NG.  Any other special"]
[null,"category will be covered later under the \"Options\" sheet"]
[null,"section.  After the \"Special Category\" prompt you will be"]
[null,"asked for a \"Unique Competitor Number.\"  This can be any"]
[null,"\"number\" (no letters) you wish to use, but must be unique for each"]
[null,"competitor.  Leave this blank, if the competitor is not to"]
[null,"be added to a current match.  If you use a number already in"]
[null,"use, you will not be able to add/edit scores for the"]
[null,"duplicate from the main menu.  A shorter number will be more"]
[null,"useful when adding/editing scores later.  After the"]
[null,"\"Competitor Number\" prompt, you will have a choice to add"]
[null,"another or you will exit to the sheet.  It is possible to"]
[null,"add shooters directly into the \"Shooters\" sheet, however the"]
[null,"main menu routine contains some error checking and uppercase"]
[null,"conversion."]
[]
[null,"     Whether you use the routine or choose to cancel, you"]
[null,"will end up on the \"Shooters\" sheet at some point.  You may"]
[null,"enter information onto the sheet or change existing"]
[null,"information.  Do NOT delete or change rows 1 or 2!  There"]
[null,"are formulas on these rows.  Additionally, don't leave any"]
[null,"blank rows between shooters in the list.  Four buttons are"]
[null,"available on row 1:  \"Add New Shooter\" will run the routine"]
[null,"described above;  \"Go To Main Menu\" goes to that sheet;"]
[null,"\"Add Shooters to Scoresheet\" will add any shooters that have"]
[null,"a number entered in the \"Comp#\" column of the \"Shooters\""]
[null,"sheet.  It will not overwrite existing competitors.  This"]
[null,"allows you to add someone during a match.  This works great"]
[null,"for multi-day matches.  \"Change UPPER/Lower Case\" will allow"]
[null,"you to change the case of those columns such as name,"]
[null,"address and city.  You may also return to the \"Main Menu\" by"]
[null,"choosing its tab."]
[]
[null,"     Edit Shooter Data:  This button takes you to the"]
[null,"\"Shooters\" worksheet in the same manner as if you choose the"]
[null,"sheet using its tab, with one exception.  This button"]
[null,"provides a message to remind you to use upper case for some"]
[null,"data.  Although most of the routines are case insensitive,"]
[null,"some are not.  It would be best to use only uppercase for"]
[null,"entries in the NRA#, Category, Class and Special columns."]
[null,"Shooters can be added directly while on this sheet, however"]
[null,"the \"Add Shooter\" routines contain some error checking and"]
[null,"uppercase conversion.  You may delete shooters from the list"]
[null,"by deleting the entire row, but do NOT remove rows 1 or 2,"]
[null,"or disturb cells past column Z of rows 1 & 2.  Cells there hold"]
[null,"shooter counting formulas which are used by the Visual Basic"]
[null,"routines.  Do NOT leave blank lines between shooters.  Choose"]
[null,"the row number to highlight the entire row and use Edit/Delete"]
[null,"from the Excel menu to remove the entire row and move the"]
[null,"others up.  When finished editing you may choose any of the"]
[null,"buttons described above or the \"Main Menu\" tab to return to"]
[null,"its sheet."]
[]
[null,"     Set/Edit Options: This button takes you to the"]
[null,"\"Options\" worksheet in the same manner as if you choose the"]
[null,"sheet using its tab.  This button also warns you not to"]
[null,"change the location of ANY data.  Although for most of the"]
[null,"entries, upper or lowercase can be used, for best results"]
[null,"uppercase should be used.  The following will explain in"]
[null,"detail each of the options:"]
[]
[null,"     How many top places? (0-3):  If 0 is chosen, no Open"]
[null,"Winner will be displayed separately at the top of the"]
[null,"\"Results\" when the \"Compose/Display Results\" button is"]
[null,"chosen.  1 displays the Open Winner; 2 displays Open and"]
[null,"Second; 3 displays Open, Second and Third places.  Anything"]
[null,"larger acts as 3.  The Open Winner will be flagged"]
[null,"regardless of this entry.  This number must be in cell B3"]
[]
[null,"     Combine Masters with High Masters? (Y/N):  This option"]
[null,"and the following three allow you to combine the classes in"]
[null,"various ways depending on the turn-out of competitors."]
[null,"Familiarize yourself with how these interact with the"]
[null,"Category options explained later.  These Y/N responses must"]
[null,"be in column B of their respective original rows."]
[]
[null,"     Combine Unclassified with which class? (MA/HM/MK) [UN"]
[null,"for own class]:  Since controversy exists over where to"]
[null,"place unclassified shooters, this option allows them to be"]
[null,"combined with either the Masters, High Masters or Marksmen."]
[null,"It also allows for their own category if appropriate.  This"]
[null,"program does not allow for any other combination for the"]
[null,"unclassified shooters.  These responses must be in column B"]
[null,"of their respective original rows."]
[]
[null,"     Combine Police with Service? (Y/N for each class):  The"]
[null,"next three rows are rather involved.  They allow the"]
[null,"separation/combining of the three categories: CIV, SER, POL,"]
[null,"within each class.  Note that choosing \"Y\" for two of the"]
[null,"three, will result in all three being combined.  Familiarize"]
[null,"yourself with how these interact with the Class options"]
[null,"explained earlier. These Y/N responses must be in their"]
[null,"respective original rows and columns."]
[]
[null,"     Number of Awards for each Civilian class? (0-?):  These"]
[null,"three rows allow for the calculation of class awards on the"]
[null,"\"Scores\" and \"Results\" sheets.  Note that if a class is"]
[null,"combined up, the combined class will only be given the"]
[null,"number of awards shown for the higher class.  Note also that"]
[null,"CIV/SER/POL combinations will have similar results. These"]
[null,"number responses must be in their respective original rows"]
[null,"and columns."]
[]
[null,"     Include Top winners in class listings? (Y/N):  This"]
[null,"chooses whether any competitors within the top winners"]
[null,"listed will also show in their respective class listing."]
[null,"Note that if 0 is chosen for \"How many top places?\" all"]
[null,"competitors will show no matter how this is set."]
[null,"Additionally, the overall winner is always flagged with a"]
[null,"{W} regardless of this setting or the above class awards."]
[null,"This Y/N response must be in cell B18."]
[]
[null,"     Use Whole Name (John P. Doe Sr.) or Last, Inits (Doe,"]
[null,"J. P. Sr.)? (W/L):  This option chooses how the \"competitor\""]
[null,"field will display the name for the match.  If \"W\" is"]
[null,"entered, the name will be First MI. Last plus any suffix."]
[null,"Otherwise, It will be displayed as Last, FI. MI. suffix, if"]
[null,"any.  Note that this option only changes the name format as"]
[null,"the shooter is added to the \"Scores\" sheet.  Changing this"]
[null,"option after a shooter is already added will have no affect."]
[null,"This response must be in cell B19."]
[]
[null,"     Special award for High Civilian? (Y/N):  This option"]
[null,"and the next eight choose whether or not to find and"]
[null,"display, on the \"Results\" sheet, the individual award winner"]
[null,"for the respective category.  This set of awards is for the"]
[null,"most common ones used, such as High Senior, High Junior,"]
[null,"etc.  It makes use of both the Category and the Special"]
[null,"Category columns.  If there are no matches to the category,"]
[null,"no title will be displayed.  These Y/N responses must be in"]
[null,"column B of their respective original rows."]
[]
[null,"     Special award(#) for...(Enter title in Col C and Code"]
[null,"in B.  See note!):  These three (almost identical looking)"]
[null,"options allow for awards different from the common ones used"]
[null,"above.  An example could be the \"High Resident\" for a state"]
[null,"competition.  If there are additional requirements such as"]
[null,"association membership, you would not want to rely solely on"]
[null,"address information.  This option allows you to individually"]
[null,"select those eligible and then have the \"Results\" find and"]
[null,"display the winner.  If there are to be no special awards,"]
[null,"leave column B blank for each respective option.  If you"]
[null,"wish to use this option, place the name of the award in"]
[null,"column C.  This name will show on the \"Results\" sheet in"]
[null,"bold with the winner.  If there are no matches to the"]
[null,"category, no title will be displayed.  Next place the code"]
[null,"you wish to use in column B, AND on the \"Scores\" sheet in"]
[null,"the \"Special2,\" \"Special3\" or \"Special4\" column, on the row"]
[null,"with each eligible competitor.  Use the appropriate column"]
[null,"for the award: \"Special2\" for the \"Special award2\" option."]
[null,"Use uppercase characters in both places.  Note that only one"]
[null,"code per competitor can be used in a single column.  If more"]
[null,"than one code is placed in the block, neither will be found."]
[null,"To follow the above example, You could place \"ST\" in cell"]
[null,"B31 and on the appropriate places on the \"Scores\" sheet,"]
[null,"then place \"State Champion\" in cell C31 and the \"Results\""]
[null,"sheet will show the winner of that award.  The \"Special2\""]
[null,"through \"Special4\" columns on the \"Shooters\" sheet can be"]
[null,"used for these codes.  However, they must be placed on the"]
[null,"\"Shooters\" sheet prior to the shooter(s) being added to the"]
[null,"\"Scores\" sheet.  To activate the award, there must be a code"]
[null,"in column B of the respective row."]
[]
[null,"     Enter/Edit 22 (CF/45) Scores:  These buttons run"]
[null,"corresponding Visual Basic routines to place or change"]
[null,"scores on the \"Scores\" sheet.  Choosing a button, shows you"]
[null,"the \"Scores\" sheet and prompts you for a Competitor Number,"]
[null,"(the reason for unique numbers).  After supplying the"]
[null,"number, you are prompted for the individual match scores for"]
[null,"that caliber.  The default for each entry will be the"]
[null,"current score for that competitor.  By choosing OK, you will"]
[null,"keep that entry.  The scores MUST be entered in the standard"]
[null,"manner of XXX-XX, meaning SCORE-(hyphen)Xs, or SCORE with no"]
[null,"hyphen or X count.  The following are valid scores:  200-13,"]
[null,"198-7, 56-1, 190, 35-0, 295-23, etc.  There is limited error"]
[null,"checking.  This program may allow erroneous scores that may"]
[null,"cause strange results.  However, if you use the preceding"]
[null,"format, everything should work.  A special note here:  This"]
[null,"program will not decide ties on its own.  It will display a"]
[null,"message when a tie is found within a match.  You must adjust"]
[null,"ties by examining the individual scoresheets based on"]
[null,"questions prompted.  The questions are based on NRA Pistol"]
[null,"Rules 15.3, 15.4, 15.5 and 15.10.  If not adjusted,"]
[null,"subsequent tied scores might not show up and/or errors may be"]
[null,"made determining winners.  The program will insert decimal"]
[null,"values into the scores on the \"Scores\" sheet to allow for"]
[null,"appropriate winners.  When the \"Results\" are run, any"]
[null,"decimal values are automatically removed.  Note that it is"]
[null,"possible for this application to mis-interpret a tied sub-"]
[null,"aggregate or grand-aggregate score under the following"]
[null,"condition:  If an early tie adds a \".1\" to a score, that"]
[null,"\".1\" is carried to the sub- and grand aggregates.  That \".1\""]
[null,"would automatically break a tie in favor of the \".1\" score."]
[null,"This would probably be very rare, but it is possible."]
[null,"Therefore, if two sub- or grand aggregate scores are the"]
[null,"same, and a tie prompt is not issued when you run the"]
[null,"Results, check for this condition.  If the results are"]
[null,"erroneous in breaking a sub- or grand aggregate tie, go to"]
[null,"the \"Scores\" sheet and add a decimal  of higher value, such"]
[null,"as .3, to one of the individual match scores for the"]
[null,"competitor who should win the tie.  Running the results"]
[null,"again should show the proper winner.  When finished with the"]
[null,"current competitor, you are prompted to add/edit another."]
[]
[null,"     Clear Scores for New Match:  This button, after a"]
[null,"validation prompt, will erase any shooter/score information"]
[null,"on the \"Scores\" sheet making it clean for a new match."]
[]
[null,"     Save Results to New Sheet:  This button will copy the"]
[null,"\"Results\" sheet to a new sheet.  You will be prompted for a"]
[null,"name.  The default name will be the current month and year"]
[null,"with the word \"Results.\"  You can keep this name or provide"]
[null,"your own.  This routine will fail if there is already a"]
[null,"sheet with the name you are trying to use."]
[]
[null,"     Compose/Display Results:  This is the compilation of"]
[null,"scores based on the options in the \"Options\" sheet.  It"]
[null,"prompts you for the match to display using match names."]
[null,"Each time the button is chosen, it reruns the award"]
[null,"calculations on the \"Scores\" sheet through the match"]
[null,"requested and then displays the results based on the current"]
[null,"contents of the \"Options\" sheet.  Therefore, you can check"]
[null,"the results, change an option and rerun the results over and"]
[null,"over again until they look as you want.  You can combine and"]
[null,"separate classes or categories, show fewer or more top"]
[null,"winners, show special award winners, etc.  You may also"]
[null,"fully edit the \"Results\" sheet, but remember that any future"]
[null,"running of the \"Compose/Display Results\" routine will"]
[null,"overwrite the current \"Results\" sheet."]
[]
[null,"     Sheets Used in the Application:  There are several"]
[null,"sheets used for this application.  Some of them are hidden"]
[null,"from view/direct access.  Some of these will become visible"]
[null,"for portions of the routines.  Additionally, there is much"]
[null,"flashing back and forth between screens as different"]
[null,"routines are run.  Please leave the hidden sheets alone."]
[null,"They contain information that should not be changed.  The"]
[null,"sheets you will work with are the following:"]
[]
[null,"     Main Menu:  This sheet has nine buttons to run various"]
[null,"Visual Basic routines explained above.  It is not necessary"]
[null,"to run these routines using the buttons.  They can be"]
[null,"accessed through the Macro feature, however the buttons make"]
[null,"it easier.  Some of the routines return you to this sheet."]
[null,"To access this sheet after those that don't, choose the Main"]
[null,"Menu tab at the bottom of the Microsoft Excel window or the"]
[null,"\"Main Menu\" button if provided."]
[]
[null,"     Shooters:  This sheet contains the personal information"]
[null,"for all the shooters you have ever entered, providing you"]
[null,"choose to save changes before exiting.  The various"]
[null,"information is placed in specific locations on the sheet."]
[null,"Care should be taken not to rearrange the columns."]
[null,"Additionally several cells contain formulas which count the"]
[null,"shooters on the sheet by counting entries in a particular"]
[null,"column, etc.  If this column is empty, the line is"]
[null,"considered \"free\" to use for any new shooter added, and the"]
[null,"current shooter may not be seen.  This is also true of the"]
[null,"NRA# column.  If a shooter doesn't have a number, use a"]
[null,"temporary number of your choice.  Do Not leave this column"]
[null,"blank.  Although case sensing/correcting is being done"]
[null,"throughout the program, it is best to leave all Class,"]
[null,"Category and Special information as Upper Case.  This sheet"]
[null,"must exist for the application to run."]
[]
[null,"     Scores:  This sheet contains all the scores that have"]
[null,"been entered since the last time it was cleared.  It also"]
[null,"contains in various specific locations, formulas and data"]
[null,"that allow the application to run.  Do Not relocate"]
[null,"information to the left of column AQ or above row 3.  An"]
[null,"award schedule has been added to this sheet which displays"]
[null,"the (W)inner, class awards, etc. and can be further used to"]
[null,"calculate points and other types of awards.  Formulas can be"]
[null,"placed in the area to the right of these lines, beginning"]
[null,"with column AQ and below line 2.  Some direct editing"]
[null,"elsewhere can be done on this sheet without interfering with"]
[null,"the operation, but it should be limited to that described"]
[null,"elsewhere in this document.  Do Not direct edit the formula"]
[null,"cells in the sub- or grand aggregate columns!  This sheet"]
[null,"must exist for the application to run."]
[]
[null,"     Options:  This sheet contains all the information to"]
[null,"develop the results.  Do Not relocate anything.  Most of the"]
[null,"data is case insensitive, however it may be better to use"]
[null,"Upper Case for the entries.  The codes for any special"]
[null,"awards in rows 31-33 must match those that will be placed on"]
[null,"the \"Scores\" sheet in \"Special2\" through \"Special4\""]
[null,"respectively.  This sheet must exist for the application to"]
[null,"run."]
[]
[null,"     Results:  This sheet will display the results compiled"]
[null,"from the \"Scores\" sheet and the \"Options\" sheet settings."]
[null,"You may edit this sheet as desired.  It will be overwritten"]
[null,"every time \"Compose/Display Results\" is run.  It may be"]
[null,"saved to another sheet.  This sheet must exist for the"]
[null,"application to run."]
[]
[null,"     Documentation: This is the \"Documentation\" which you"]
[null,"are viewing."]
[]
[null,"     Sample Scores:  This sheet is hidden, but can be"]
[null,"brought out by using Format:Sheet:Unhide.  It contains a"]
[null,"sample of shooters using each class and category.  You can"]
[null,"rename or copy this in place of the \"Scores\" sheet to"]
[null,"practice using different options.  This sheet does not need"]
[null,"to exist for the application to run."]
[]
[null,"     Labels:  This sheet is updated with all the names and addresses for"]
[null,"the competitors of a match.  As the shooters are added to the \"Scores\""]
[null,"sheet by pressing the \"Add Shooter to Scoresheet\" button on the"]
[null,"\"Shooters\" sheet, they are also added to the \"Labels\" sheet.  This"]
[null,"allows for making up mailing labels for the competitors in that particular"]
[null,"match.  The \"Labels\" sheet is erased at the same time the \"Scores\""]
[null,"sheet is cleared for a new match.  This sheet must exist for some of the "]
[null,"macros to run."]
[]
[null,"Two extra sheets called \"Docs Menu\" and \"Docs Macros\" have been"]
[null,"added to allow quick navigation though the documentation.  The first"]
[null,"sheet, \"Docs Menu\" has buttons which, when pressed, will take you"]
[null,"to that area in the documentation.  The second sheet, \"Docs Macros\""]
[null,"is the list of macros which perform those jumps.  If the documentation"]
[null,"is modified, these macros may also need to be modified."]
[]
[null,"     Additions and Changes:  Periodically changes and additions"]
[null,"will be made without revising the entire documentation.  Those changes"]
[null,"will appear under this heading."]
[]
[null,"Version 4.55, October 2000"]
[null,"First, a date block has been added to the \"Main Menu\" screen.  Check"]
[null,"that this date is correct.  If it isn't, correct the computer system clock."]
[null,"Do NOT enter a date into this block!  It currently reads the date from"]
[null,"the system.  If you enter something else, it will no longer work."]
[]
[null,"The \"Add Shooters to Scoresheet\" macro has been changed to delete"]
[null,"the competitor number once they have been added to the current \"Scores\""]
[null,"sheet.  Additionally, there are several new columns \"Matches Attended,"]
[null,"Most Recent, 2nd most Recent and 3rd most Recent\" which will track"]
[null,"and keep a running total of the matches a competitor has shot at your"]
[null,"location.  The competitors are then sorted to keep your most common"]
[null,"shooters at the top of the list."]
[]
[null,"Additionally, the \"Add Shooters to Scoresheet\" macro places the name"]
[null,"and address of competitors onto the new \"Labels\" sheet which can be used"]
[null,"to generate mailing labels for all the competitors.  The \"Labels\" sheet is"]
[null,"cleared at the same time the \"Scores\" sheet is cleared by the \"Clear"]
[null,"Scores for New Match\" button on the \"Main Menu\" sheet."]
[]
[null,"Version 4.70, April 2001"]
[null,"Some work has been done to eliminate duplicated shooters on the \"Results\""]
[null,"page when printing out shooters with 0-0 scores.  Also the tie breaker"]
[null,"routine has been removed from the 0-0 scores, in case shooters haven't"]
[null,"shot in their relay yet."]
[]
[null,"An option has been added to insert a title on the Results page.  To use this"]
[null,"option go to the \"Options\" page and enter a title into block B35.  The title"]
[null,"should center across the next several cells so as to be easily readable."]
[null,"You may also choose to add a date under the title by placing a \"Y\" in"]
[null,"block B36.  If no title is wanted delete any info in block B35.  This will also"]
[null,"keep the date from printing, regardless of the entry in block B36."]
[]
[null,"A suggested award schedule has been added to the \"Scores\" sheet in"]
[null,"block AQ3.  This formula will calculate award points based on all the wins"]
[null,"in various events for that shooter.  Block AR1 holds a value referred to as"]
[null,"a \"Factor\" which will allow choosing an amount to be factored into the"]
[null,"award formula to adjust the payout accordingly.  A total is then given in"]
[null,"block AR3 of all the awards calculated.  A decimal figure can be placed"]
[null,"in block AR1, however it may then give decimal values in the payout blocks"]
[null,"for each shooter.  The block can be copied down to each shooter by normal"]
[null,"Excel copying methods, or can be replaced by your own formula."]
[]
[null,"Two blocks have been added to the \"Shooters\" sheet to accept email"]
[null,"addresses and phone numbers.  Due to the routines that process the"]
[null,"shooter data, these clocumns have been added to the end of the row after"]
[null,"the match data.  This may make them more difficult to use, however, by"]
[null,"choosing a column by clicking on the letter at the top and then choosing"]
[null,"Window/Split from the Excel menu it is possible to move the information"]
[null,"over to coincide with the names, etc.  A future version may move this info"]
[null,"over to be with the rest, but there are so many blocks, it may be difficult to"]
[null,"choose which to go where.  For now, please do not rearrange any blocks"]
[null,"on this page.  It will scramble the routines that create the \"Scores\" page."]
[]
[null,"Version 4.71, April 2001"]
[null,"A change has been made to the entry routine for a shooter.  By entering the"]
[null,"NRA# for a shooter that is already in your list, you are now prompted for"]
[null,"the \"Unique Competitor Number.\"  This allows you to enter the NRA#"]
[null,"instead of looking through a long list of names to add a shooter to a match."]
[null,"If the NRA# is not found, you may then enter the new shooter data as before."]
[null,"Please note that with the changing of NRA#s, it will be possible to be prompted"]
[null,"for new information for an older shooter whose NRA# has not yet been updated"]
[null,"on your \"Shooters\" worksheet."]
[]
[null,"Version 5.51, September 2001"]
[null,"Several changes have been made to this version."]
[]
[null,"A change has been made to allow the entry of a last name as well as the"]
[null,"previous entry of the NRA# when adding shooters.  The routine additionally"]
[null,"allows the verification of the shooter's data and editing can be done to make"]
[null,"changes in the data."]
[]
[null,"The special category now allows more than one category to be entered.  "]
[null,"For example, if a competitor is both Senior and Woman, you can enter"]
[null,"SEN WOM and the program will evaluate for both categories."]
[]
[null,"The award schedule has been expanded to allow the user to choose the"]
[null,"basic payout for awards.  Awards will be calculated for all places, however"]
[null,"all class awards past second place will be the same as chosen for"]
[null,"the \"All Class >2nd\" value.  In other words, third, fourth, fifth, etc.,"]
[null,"will be paid the same amount.  This award schedule is what limits the"]
[null,"program to 998 competitors.  If more competitors than 998 (I know, not"]
[null,"likely), then the additional ones will have corrupted award values."]
[]
[null,"A \"Team Scores\" sheet has been added.  It must exist for a new option,"]
[null,"NRA Report Generation, to work.  At this time you will have to manually"]
[null,"enter all data and copy the first block down for other teams.  You will also"]
[null,"have to manually determine class/category breaks and the ranking.  The"]
[null,"Competitor Number is necessary for the NRA Report to be valid."]
[]
[null,"The NRA Report is generated by choosing its button from the Main Menu."]
[null,"The routine will erase old data in the \"NRAReport\" sheet and fill it in with "]
[null,"data from the current match.  Data on the sheet will include the NRA#, total "]
[null,"shots fired, total score (includes team), name and address information.  If a"]
[null,"title exists on the \"Options\" sheet, it is placed at the top of the report.  As"]
[null,"mentioned earlier, the competitor numbers must be entered on the \"Team"]
[null,"Scores\" sheet for this report to include those shots.  You will also have to"]
[null,"add the date and type of the match."]
[]
[null,"Version 6.00, July 2002"]
[null,"The special awards section has been modified such that all identifiers, like"]
[null,"WOM SER USAF, etc. can be placed in any manner in any of the four"]
[null,"columns associated with them.  Although, perhaps not necessary, you"]
[null,"should place a space between each and all should be upper case."]
[null,"The three extra user categories on the \"Options\" page are also free to"]
[null,"exist in any of the columns.  The four regular services are now part of the"]
[null,"normal categories.  The codes for the services are USAF, USMC, USN and"]
[null,"USA only.  NAVY and/or ARMY will not work."]
[]
[null,"An \"Awards\" sheet has been added that can automatically fill in as results"]
[null,"are run, based on an option on the \"Options\" page.  It will only fill in for the"]
[null,"sub-aggregates and grand aggregate at this time and although there is team"]
[null,"info on the page, there is no current automatic filling in for that section."]
[]
[null,"The competitor entry routine has been modified to (hopefully) make it easier"]
[null,"to use and verify/edit shooter data.  A suggested numbering scheme for"]
[null,"competiors has also been added.  The scheme is invoked and base starting"]
[null,"numbers assigned on the \"Options\" page.  When a competitor is added, the"]
[null,"routine checks for existing numbers and suggests the next higher available"]
[null,"number in the series.  It checks both the \"Scores\" and \"Shooters\" pages,"]
[null,"so if you're working up a new match, ensure you have cleared the previous"]
[null,"\"Scores\" page prior to assigning numbers."]
[]
[null,"The \"NRAReport\" page was skipping name and address information for"]
[null,"many shooters.  This has been repaired."]
[]
[null,"Version 7.00, August 2003"]
[null,"Leading zeroes on zip codes were being lost.  This has been fixed (I hope)."]
[null,"The suggested payout schedule has been moved to the \"Options\" page to"]
[null,"allow deletion of entire lines for shooters on the \"Scores\" page.  Previous"]
[null,"deletion caused the award formula area to lose references.  The \"Awards\""]
[null,"page has been modified to reflect prizes and to display the names in the"]
[null,"whole name format instead of initials.  The title of the page will copy the"]
[null,"title shown in the \"Options\" block that is used for the \"Results\" page.  The"]
[null,"awards for High Reservist and High Guard have been added to the Overall"]
[null,"section."]
[]
[null,"An \"SR1 Card\" page has been added with a corresponding button on the"]
[null,"\"Shooters\" page to fill in the SR1.  First, highlight an NRA number and then"]
[null,"choose the button marked, \"Copy Shooter to SR-1\" and the shooter info"]
[null,"will be copied to the \"Options\" page where it will be read by the \"SR1 Card\""]
[null,"page.  The SR1 Card can then be printed with most of the information filled"]
[null,"in.  Alternately, (or to add extra information not on the \"Shooters\" page) the"]
[null,"card can be filled in by entering the data into cells L4 through L15 on the"]
[null,"\"Options\" page with the corresponding data listed in K4 through K15."]
[null,"DO NOT try to fill in the form directly!"]
[]
[null,"A \"Print Page for Labels\" sheet has been added which automatically fills"]
[null,"in from the \"Labels\" page to provide formatting to print 30 labels per page"]
[null,"on Avery# 5160 (30 label) sheets with three columns of 10 labels."]
[]
[null,"Added Print sheets for Bullseye Indoor and Outdoor score cards and EIC"]
[null,"score cards.  The EIC score cards are configured so that you can print the"]
[null,"fronts and then turn over your stack of paper/card stock and print the backs."]
[null,"The front and back will be lined up such that you can then cut the 8.5x11\""]
[null,"paper or card/stock in half and have two complete EIC forms like the CMP"]
[null,"uses."]
[]
[null,"Version 8.00 changes were removed"]
[null,"Version 9.00, September 2018"]
[null,"Removed EIC score card worksheets since CMP now issues computer "]
[null,"based readable cards."]
[]
[null,"Removed one of the editable Special Cases (reduced to 2) on the Options"]
[null,"page, so Grand Senior (GSN) and Veteran (VET) could be added to the list."]

{"sheet":"Results Template","index":21,"n_rows":2,"n_cols":35,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"22 Caliber Sub-Aggregate",null,null,null,null,null,null,null,null,null,"Center Fire Caliber Sub-Aggregate",null,null,null,null,null,null,null,null,null,"45 Caliber Sub-Aggregate",null,null,null,null,null,null,null,null,null,"Final"]
["Comp#","Cls/Cat","Competitor","NRA #","Slow",null,"NMC",null,"Timed",null,"Rapid",null,"Sub-Agg",null,"Slow",null,"NMC",null,"Timed",null,"Rapid",null,"Sub-Agg",null,"Slow",null,"NMC",null,"Timed",null,"Rapid",null,"Sub-Agg",null,"Grand Agg"]

{"sheet":"Print Page for Labels","index":23,"n_rows":270,"n_cols":3,"rows_kept":270,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(Labels!A1<>\"\",Labels!A1,\"\")","v":""},{"$f":"IF(Labels!A2<>\"\",Labels!A2,\"\")","v":""},{"$f":"IF(Labels!A3<>\"\",Labels!A3,\"\")","v":""}]
[{"$f":"IF(Labels!B1<>\"\",Labels!B1,\"\")","v":""},{"$f":"IF(Labels!B2<>\"\",Labels!B2,\"\")","v":""},{"$f":"IF(Labels!B3<>\"\",Labels!B3,\"\")","v":""}]
[{"$f":"IF(Labels!C1<>\"\",Labels!C1,\"\")","v":""},{"$f":"IF(Labels!C2<>\"\",Labels!C2,\"\")","v":""},{"$f":"IF(Labels!C3<>\"\",Labels!C3,\"\")","v":""}]
[{"$f":"IF(Labels!A4<>\"\",Labels!A4,\"\")","v":""},{"$f":"IF(Labels!A5<>\"\",Labels!A5,\"\")","v":""},{"$f":"IF(Labels!A6<>\"\",Labels!A6,\"\")","v":""}]
[{"$f":"IF(Labels!B4<>\"\",Labels!B4,\"\")","v":""},{"$f":"IF(Labels!B5<>\"\",Labels!B5,\"\")","v":""},{"$f":"IF(Labels!B6<>\"\",Labels!B6,\"\")","v":""}]
[{"$f":"IF(Labels!C4<>\"\",Labels!C4,\"\")","v":""},{"$f":"IF(Labels!C5<>\"\",Labels!C5,\"\")","v":""},{"$f":"IF(Labels!C6<>\"\",Labels!C6,\"\")","v":""}]
[{"$f":"IF(Labels!A7<>\"\",Labels!A7,\"\")","v":""},{"$f":"IF(Labels!A8<>\"\",Labels!A8,\"\")","v":""},{"$f":"IF(Labels!A9<>\"\",Labels!A9,\"\")","v":""}]
[{"$f":"IF(Labels!B7<>\"\",Labels!B7,\"\")","v":""},{"$f":"IF(Labels!B8<>\"\",Labels!B8,\"\")","v":""},{"$f":"IF(Labels!B9<>\"\",Labels!B9,\"\")","v":""}]
[{"$f":"IF(Labels!C7<>\"\",Labels!C7,\"\")","v":""},{"$f":"IF(Labels!C8<>\"\",Labels!C8,\"\")","v":""},{"$f":"IF(Labels!C9<>\"\",Labels!C9,\"\")","v":""}]
[{"$f":"IF(Labels!A10<>\"\",Labels!A10,\"\")","v":""},{"$f":"IF(Labels!A11<>\"\",Labels!A11,\"\")","v":""},{"$f":"IF(Labels!A12<>\"\",Labels!A12,\"\")","v":""}]
[{"$f":"IF(Labels!B10<>\"\",Labels!B10,\"\")","v":""},{"$f":"IF(Labels!B11<>\"\",Labels!B11,\"\")","v":""},{"$f":"IF(Labels!B12<>\"\",Labels!B12,\"\")","v":""}]
[{"$f":"IF(Labels!C10<>\"\",Labels!C10,\"\")","v":""},{"$f":"IF(Labels!C11<>\"\",Labels!C11,\"\")","v":""},{"$f":"IF(Labels!C12<>\"\",Labels!C12,\"\")","v":""}]
[{"$f":"IF(Labels!A13<>\"\",Labels!A13,\"\")","v":""},{"$f":"IF(Labels!A14<>\"\",Labels!A14,\"\")","v":""},{"$f":"IF(Labels!A15<>\"\",Labels!A15,\"\")","v":""}]
[{"$f":"IF(Labels!B13<>\"\",Labels!B13,\"\")","v":""},{"$f":"IF(Labels!B14<>\"\",Labels!B14,\"\")","v":""},{"$f":"IF(Labels!B15<>\"\",Labels!B15,\"\")","v":""}]
[{"$f":"IF(Labels!C13<>\"\",Labels!C13,\"\")","v":""},{"$f":"IF(Labels!C14<>\"\",Labels!C14,\"\")","v":""},{"$f":"IF(Labels!C15<>\"\",Labels!C15,\"\")","v":""}]
[{"$f":"IF(Labels!A16<>\"\",Labels!A16,\"\")","v":""},{"$f":"IF(Labels!A17<>\"\",Labels!A17,\"\")","v":""},{"$f":"IF(Labels!A18<>\"\",Labels!A18,\"\")","v":""}]
[{"$f":"IF(Labels!B16<>\"\",Labels!B16,\"\")","v":""},{"$f":"IF(Labels!B17<>\"\",Labels!B17,\"\")","v":""},{"$f":"IF(Labels!B18<>\"\",Labels!B18,\"\")","v":""}]
[{"$f":"IF(Labels!C16<>\"\",Labels!C16,\"\")","v":""},{"$f":"IF(Labels!C17<>\"\",Labels!C17,\"\")","v":""},{"$f":"IF(Labels!C18<>\"\",Labels!C18,\"\")","v":""}]
[{"$f":"IF(Labels!A19<>\"\",Labels!A19,\"\")","v":""},{"$f":"IF(Labels!A20<>\"\",Labels!A20,\"\")","v":""},{"$f":"IF(Labels!A21<>\"\",Labels!A21,\"\")","v":""}]
[{"$f":"IF(Labels!B19<>\"\",Labels!B19,\"\")","v":""},{"$f":"IF(Labels!B20<>\"\",Labels!B20,\"\")","v":""},{"$f":"IF(Labels!B21<>\"\",Labels!B21,\"\")","v":""}]
[{"$f":"IF(Labels!C19<>\"\",Labels!C19,\"\")","v":""},{"$f":"IF(Labels!C20<>\"\",Labels!C20,\"\")","v":""},{"$f":"IF(Labels!C21<>\"\",Labels!C21,\"\")","v":""}]
[{"$f":"IF(Labels!A22<>\"\",Labels!A22,\"\")","v":""},{"$f":"IF(Labels!A23<>\"\",Labels!A23,\"\")","v":""},{"$f":"IF(Labels!A24<>\"\",Labels!A24,\"\")","v":""}]
[{"$f":"IF(Labels!B22<>\"\",Labels!B22,\"\")","v":""},{"$f":"IF(Labels!B23<>\"\",Labels!B23,\"\")","v":""},{"$f":"IF(Labels!B24<>\"\",Labels!B24,\"\")","v":""}]
[{"$f":"IF(Labels!C22<>\"\",Labels!C22,\"\")","v":""},{"$f":"IF(Labels!C23<>\"\",Labels!C23,\"\")","v":""},{"$f":"IF(Labels!C24<>\"\",Labels!C24,\"\")","v":""}]
[{"$f":"IF(Labels!A25<>\"\",Labels!A25,\"\")","v":""},{"$f":"IF(Labels!A26<>\"\",Labels!A26,\"\")","v":""},{"$f":"IF(Labels!A27<>\"\",Labels!A27,\"\")","v":""}]
[{"$f":"IF(Labels!B25<>\"\",Labels!B25,\"\")","v":""},{"$f":"IF(Labels!B26<>\"\",Labels!B26,\"\")","v":""},{"$f":"IF(Labels!B27<>\"\",Labels!B27,\"\")","v":""}]
[{"$f":"IF(Labels!C25<>\"\",Labels!C25,\"\")","v":""},{"$f":"IF(Labels!C26<>\"\",Labels!C26,\"\")","v":""},{"$f":"IF(Labels!C27<>\"\",Labels!C27,\"\")","v":""}]
[{"$f":"IF(Labels!A28<>\"\",Labels!A28,\"\")","v":""},{"$f":"IF(Labels!A29<>\"\",Labels!A29,\"\")","v":""},{"$f":"IF(Labels!A30<>\"\",Labels!A30,\"\")","v":""}]
[{"$f":"IF(Labels!B28<>\"\",Labels!B28,\"\")","v":""},{"$f":"IF(Labels!B29<>\"\",Labels!B29,\"\")","v":""},{"$f":"IF(Labels!B30<>\"\",Labels!B30,\"\")","v":""}]
[{"$f":"IF(Labels!C28<>\"\",Labels!C28,\"\")","v":""},{"$f":"IF(Labels!C29<>\"\",Labels!C29,\"\")","v":""},{"$f":"IF(Labels!C30<>\"\",Labels!C30,\"\")","v":""}]
[{"$f":"IF(Labels!A31<>\"\",Labels!A31,\"\")","v":""},{"$f":"IF(Labels!A32<>\"\",Labels!A32,\"\")","v":""},{"$f":"IF(Labels!A33<>\"\",Labels!A33,\"\")","v":""}]
[{"$f":"IF(Labels!B31<>\"\",Labels!B31,\"\")","v":""},{"$f":"IF(Labels!B32<>\"\",Labels!B32,\"\")","v":""},{"$f":"IF(Labels!B33<>\"\",Labels!B33,\"\")","v":""}]
[{"$f":"IF(Labels!C31<>\"\",Labels!C31,\"\")","v":""},{"$f":"IF(Labels!C32<>\"\",Labels!C32,\"\")","v":""},{"$f":"IF(Labels!C33<>\"\",Labels!C33,\"\")","v":""}]
[{"$f":"IF(Labels!A34<>\"\",Labels!A34,\"\")","v":""},{"$f":"IF(Labels!A35<>\"\",Labels!A35,\"\")","v":""},{"$f":"IF(Labels!A36<>\"\",Labels!A36,\"\")","v":""}]
[{"$f":"IF(Labels!B34<>\"\",Labels!B34,\"\")","v":""},{"$f":"IF(Labels!B35<>\"\",Labels!B35,\"\")","v":""},{"$f":"IF(Labels!B36<>\"\",Labels!B36,\"\")","v":""}]
[{"$f":"IF(Labels!C34<>\"\",Labels!C34,\"\")","v":""},{"$f":"IF(Labels!C35<>\"\",Labels!C35,\"\")","v":""},{"$f":"IF(Labels!C36<>\"\",Labels!C36,\"\")","v":""}]
[{"$f":"IF(Labels!A37<>\"\",Labels!A37,\"\")","v":""},{"$f":"IF(Labels!A38<>\"\",Labels!A38,\"\")","v":""},{"$f":"IF(Labels!A39<>\"\",Labels!A39,\"\")","v":""}]
[{"$f":"IF(Labels!B37<>\"\",Labels!B37,\"\")","v":""},{"$f":"IF(Labels!B38<>\"\",Labels!B38,\"\")","v":""},{"$f":"IF(Labels!B39<>\"\",Labels!B39,\"\")","v":""}]
[{"$f":"IF(Labels!C37<>\"\",Labels!C37,\"\")","v":""},{"$f":"IF(Labels!C38<>\"\",Labels!C38,\"\")","v":""},{"$f":"IF(Labels!C39<>\"\",Labels!C39,\"\")","v":""}]
[{"$f":"IF(Labels!A40<>\"\",Labels!A40,\"\")","v":""},{"$f":"IF(Labels!A41<>\"\",Labels!A41,\"\")","v":""},{"$f":"IF(Labels!A42<>\"\",Labels!A42,\"\")","v":""}]
[{"$f":"IF(Labels!B40<>\"\",Labels!B40,\"\")","v":""},{"$f":"IF(Labels!B41<>\"\",Labels!B41,\"\")","v":""},{"$f":"IF(Labels!B42<>\"\",Labels!B42,\"\")","v":""}]
[{"$f":"IF(Labels!C40<>\"\",Labels!C40,\"\")","v":""},{"$f":"IF(Labels!C41<>\"\",Labels!C41,\"\")","v":""},{"$f":"IF(Labels!C42<>\"\",Labels!C42,\"\")","v":""}]
[{"$f":"IF(Labels!A43<>\"\",Labels!A43,\"\")","v":""},{"$f":"IF(Labels!A44<>\"\",Labels!A44,\"\")","v":""},{"$f":"IF(Labels!A45<>\"\",Labels!A45,\"\")","v":""}]
[{"$f":"IF(Labels!B43<>\"\",Labels!B43,\"\")","v":""},{"$f":"IF(Labels!B44<>\"\",Labels!B44,\"\")","v":""},{"$f":"IF(Labels!B45<>\"\",Labels!B45,\"\")","v":""}]
[{"$f":"IF(Labels!C43<>\"\",Labels!C43,\"\")","v":""},{"$f":"IF(Labels!C44<>\"\",Labels!C44,\"\")","v":""},{"$f":"IF(Labels!C45<>\"\",Labels!C45,\"\")","v":""}]
[{"$f":"IF(Labels!A46<>\"\",Labels!A46,\"\")","v":""},{"$f":"IF(Labels!A47<>\"\",Labels!A47,\"\")","v":""},{"$f":"IF(Labels!A48<>\"\",Labels!A48,\"\")","v":""}]
[{"$f":"IF(Labels!B46<>\"\",Labels!B46,\"\")","v":""},{"$f":"IF(Labels!B47<>\"\",Labels!B47,\"\")","v":""},{"$f":"IF(Labels!B48<>\"\",Labels!B48,\"\")","v":""}]
[{"$f":"IF(Labels!C46<>\"\",Labels!C46,\"\")","v":""},{"$f":"IF(Labels!C47<>\"\",Labels!C47,\"\")","v":""},{"$f":"IF(Labels!C48<>\"\",Labels!C48,\"\")","v":""}]
[{"$f":"IF(Labels!A49<>\"\",Labels!A49,\"\")","v":""},{"$f":"IF(Labels!A50<>\"\",Labels!A50,\"\")","v":""},{"$f":"IF(Labels!A51<>\"\",Labels!A51,\"\")","v":""}]
[{"$f":"IF(Labels!B49<>\"\",Labels!B49,\"\")","v":""},{"$f":"IF(Labels!B50<>\"\",Labels!B50,\"\")","v":""},{"$f":"IF(Labels!B51<>\"\",Labels!B51,\"\")","v":""}]
[{"$f":"IF(Labels!C49<>\"\",Labels!C49,\"\")","v":""},{"$f":"IF(Labels!C50<>\"\",Labels!C50,\"\")","v":""},{"$f":"IF(Labels!C51<>\"\",Labels!C51,\"\")","v":""}]
[{"$f":"IF(Labels!A52<>\"\",Labels!A52,\"\")","v":""},{"$f":"IF(Labels!A53<>\"\",Labels!A53,\"\")","v":""},{"$f":"IF(Labels!A54<>\"\",Labels!A54,\"\")","v":""}]
[{"$f":"IF(Labels!B52<>\"\",Labels!B52,\"\")","v":""},{"$f":"IF(Labels!B53<>\"\",Labels!B53,\"\")","v":""},{"$f":"IF(Labels!B54<>\"\",Labels!B54,\"\")","v":""}]
[{"$f":"IF(Labels!C52<>\"\",Labels!C52,\"\")","v":""},{"$f":"IF(Labels!C53<>\"\",Labels!C53,\"\")","v":""},{"$f":"IF(Labels!C54<>\"\",Labels!C54,\"\")","v":""}]
[{"$f":"IF(Labels!A55<>\"\",Labels!A55,\"\")","v":""},{"$f":"IF(Labels!A56<>\"\",Labels!A56,\"\")","v":""},{"$f":"IF(Labels!A57<>\"\",Labels!A57,\"\")","v":""}]
[{"$f":"IF(Labels!B55<>\"\",Labels!B55,\"\")","v":""},{"$f":"IF(Labels!B56<>\"\",Labels!B56,\"\")","v":""},{"$f":"IF(Labels!B57<>\"\",Labels!B57,\"\")","v":""}]
[{"$f":"IF(Labels!C55<>\"\",Labels!C55,\"\")","v":""},{"$f":"IF(Labels!C56<>\"\",Labels!C56,\"\")","v":""},{"$f":"IF(Labels!C57<>\"\",Labels!C57,\"\")","v":""}]
[{"$f":"IF(Labels!A58<>\"\",Labels!A58,\"\")","v":""},{"$f":"IF(Labels!A59<>\"\",Labels!A59,\"\")","v":""},{"$f":"IF(Labels!A60<>\"\",Labels!A60,\"\")","v":""}]
[{"$f":"IF(Labels!B58<>\"\",Labels!B58,\"\")","v":""},{"$f":"IF(Labels!B59<>\"\",Labels!B59,\"\")","v":""},{"$f":"IF(Labels!B60<>\"\",Labels!B60,\"\")","v":""}]
[{"$f":"IF(Labels!C58<>\"\",Labels!C58,\"\")","v":""},{"$f":"IF(Labels!C59<>\"\",Labels!C59,\"\")","v":""},{"$f":"IF(Labels!C60<>\"\",Labels!C60,\"\")","v":""}]
[{"$f":"IF(Labels!A61<>\"\",Labels!A61,\"\")","v":""},{"$f":"IF(Labels!A62<>\"\",Labels!A62,\"\")","v":""},{"$f":"IF(Labels!A63<>\"\",Labels!A63,\"\")","v":""}]
[{"$f":"IF(Labels!B61<>\"\",Labels!B61,\"\")","v":""},{"$f":"IF(Labels!B62<>\"\",Labels!B62,\"\")","v":""},{"$f":"IF(Labels!B63<>\"\",Labels!B63,\"\")","v":""}]
[{"$f":"IF(Labels!C61<>\"\",Labels!C61,\"\")","v":""},{"$f":"IF(Labels!C62<>\"\",Labels!C62,\"\")","v":""},{"$f":"IF(Labels!C63<>\"\",Labels!C63,\"\")","v":""}]
[{"$f":"IF(Labels!A64<>\"\",Labels!A64,\"\")","v":""},{"$f":"IF(Labels!A65<>\"\",Labels!A65,\"\")","v":""},{"$f":"IF(Labels!A66<>\"\",Labels!A66,\"\")","v":""}]
[{"$f":"IF(Labels!B64<>\"\",Labels!B64,\"\")","v":""},{"$f":"IF(Labels!B65<>\"\",Labels!B65,\"\")","v":""},{"$f":"IF(Labels!B66<>\"\",Labels!B66,\"\")","v":""}]
[{"$f":"IF(Labels!C64<>\"\",Labels!C64,\"\")","v":""},{"$f":"IF(Labels!C65<>\"\",Labels!C65,\"\")","v":""},{"$f":"IF(Labels!C66<>\"\",Labels!C66,\"\")","v":""}]
[{"$f":"IF(Labels!A67<>\"\",Labels!A67,\"\")","v":""},{"$f":"IF(Labels!A68<>\"\",Labels!A68,\"\")","v":""},{"$f":"IF(Labels!A69<>\"\",Labels!A69,\"\")","v":""}]
[{"$f":"IF(Labels!B67<>\"\",Labels!B67,\"\")","v":""},{"$f":"IF(Labels!B68<>\"\",Labels!B68,\"\")","v":""},{"$f":"IF(Labels!B69<>\"\",Labels!B69,\"\")","v":""}]
[{"$f":"IF(Labels!C67<>\"\",Labels!C67,\"\")","v":""},{"$f":"IF(Labels!C68<>\"\",Labels!C68,\"\")","v":""},{"$f":"IF(Labels!C69<>\"\",Labels!C69,\"\")","v":""}]
[{"$f":"IF(Labels!A70<>\"\",Labels!A70,\"\")","v":""},{"$f":"IF(Labels!A71<>\"\",Labels!A71,\"\")","v":""},{"$f":"IF(Labels!A72<>\"\",Labels!A72,\"\")","v":""}]
[{"$f":"IF(Labels!B70<>\"\",Labels!B70,\"\")","v":""},{"$f":"IF(Labels!B71<>\"\",Labels!B71,\"\")","v":""},{"$f":"IF(Labels!B72<>\"\",Labels!B72,\"\")","v":""}]
[{"$f":"IF(Labels!C70<>\"\",Labels!C70,\"\")","v":""},{"$f":"IF(Labels!C71<>\"\",Labels!C71,\"\")","v":""},{"$f":"IF(Labels!C72<>\"\",Labels!C72,\"\")","v":""}]
[{"$f":"IF(Labels!A73<>\"\",Labels!A73,\"\")","v":""},{"$f":"IF(Labels!A74<>\"\",Labels!A74,\"\")","v":""},{"$f":"IF(Labels!A75<>\"\",Labels!A75,\"\")","v":""}]
[{"$f":"IF(Labels!B73<>\"\",Labels!B73,\"\")","v":""},{"$f":"IF(Labels!B74<>\"\",Labels!B74,\"\")","v":""},{"$f":"IF(Labels!B75<>\"\",Labels!B75,\"\")","v":""}]
[{"$f":"IF(Labels!C73<>\"\",Labels!C73,\"\")","v":""},{"$f":"IF(Labels!C74<>\"\",Labels!C74,\"\")","v":""},{"$f":"IF(Labels!C75<>\"\",Labels!C75,\"\")","v":""}]
[{"$f":"IF(Labels!A76<>\"\",Labels!A76,\"\")","v":""},{"$f":"IF(Labels!A77<>\"\",Labels!A77,\"\")","v":""},{"$f":"IF(Labels!A78<>\"\",Labels!A78,\"\")","v":""}]
[{"$f":"IF(Labels!B76<>\"\",Labels!B76,\"\")","v":""},{"$f":"IF(Labels!B77<>\"\",Labels!B77,\"\")","v":""},{"$f":"IF(Labels!B78<>\"\",Labels!B78,\"\")","v":""}]
[{"$f":"IF(Labels!C76<>\"\",Labels!C76,\"\")","v":""},{"$f":"IF(Labels!C77<>\"\",Labels!C77,\"\")","v":""},{"$f":"IF(Labels!C78<>\"\",Labels!C78,\"\")","v":""}]
[{"$f":"IF(Labels!A79<>\"\",Labels!A79,\"\")","v":""},{"$f":"IF(Labels!A80<>\"\",Labels!A80,\"\")","v":""},{"$f":"IF(Labels!A81<>\"\",Labels!A81,\"\")","v":""}]
[{"$f":"IF(Labels!B79<>\"\",Labels!B79,\"\")","v":""},{"$f":"IF(Labels!B80<>\"\",Labels!B80,\"\")","v":""},{"$f":"IF(Labels!B81<>\"\",Labels!B81,\"\")","v":""}]
[{"$f":"IF(Labels!C79<>\"\",Labels!C79,\"\")","v":""},{"$f":"IF(Labels!C80<>\"\",Labels!C80,\"\")","v":""},{"$f":"IF(Labels!C81<>\"\",Labels!C81,\"\")","v":""}]
[{"$f":"IF(Labels!A82<>\"\",Labels!A82,\"\")","v":""},{"$f":"IF(Labels!A83<>\"\",Labels!A83,\"\")","v":""},{"$f":"IF(Labels!A84<>\"\",Labels!A84,\"\")","v":""}]
[{"$f":"IF(Labels!B82<>\"\",Labels!B82,\"\")","v":""},{"$f":"IF(Labels!B83<>\"\",Labels!B83,\"\")","v":""},{"$f":"IF(Labels!B84<>\"\",Labels!B84,\"\")","v":""}]
[{"$f":"IF(Labels!C82<>\"\",Labels!C82,\"\")","v":""},{"$f":"IF(Labels!C83<>\"\",Labels!C83,\"\")","v":""},{"$f":"IF(Labels!C84<>\"\",Labels!C84,\"\")","v":""}]
[{"$f":"IF(Labels!A85<>\"\",Labels!A85,\"\")","v":""},{"$f":"IF(Labels!A86<>\"\",Labels!A86,\"\")","v":""},{"$f":"IF(Labels!A87<>\"\",Labels!A87,\"\")","v":""}]
[{"$f":"IF(Labels!B85<>\"\",Labels!B85,\"\")","v":""},{"$f":"IF(Labels!B86<>\"\",Labels!B86,\"\")","v":""},{"$f":"IF(Labels!B87<>\"\",Labels!B87,\"\")","v":""}]
[{"$f":"IF(Labels!C85<>\"\",Labels!C85,\"\")","v":""},{"$f":"IF(Labels!C86<>\"\",Labels!C86,\"\")","v":""},{"$f":"IF(Labels!C87<>\"\",Labels!C87,\"\")","v":""}]
[{"$f":"IF(Labels!A88<>\"\",Labels!A88,\"\")","v":""},{"$f":"IF(Labels!A89<>\"\",Labels!A89,\"\")","v":""},{"$f":"IF(Labels!A90<>\"\",Labels!A90,\"\")","v":""}]
[{"$f":"IF(Labels!B88<>\"\",Labels!B88,\"\")","v":""},{"$f":"IF(Labels!B89<>\"\",Labels!B89,\"\")","v":""},{"$f":"IF(Labels!B90<>\"\",Labels!B90,\"\")","v":""}]
[{"$f":"IF(Labels!C88<>\"\",Labels!C88,\"\")","v":""},{"$f":"IF(Labels!C89<>\"\",Labels!C89,\"\")","v":""},{"$f":"IF(Labels!C90<>\"\",Labels!C90,\"\")","v":""}]
[{"$f":"IF(Labels!A91<>\"\",Labels!A91,\"\")","v":""},{"$f":"IF(Labels!A92<>\"\",Labels!A92,\"\")","v":""},{"$f":"IF(Labels!A93<>\"\",Labels!A93,\"\")","v":""}]
[{"$f":"IF(Labels!B91<>\"\",Labels!B91,\"\")","v":""},{"$f":"IF(Labels!B92<>\"\",Labels!B92,\"\")","v":""},{"$f":"IF(Labels!B93<>\"\",Labels!B93,\"\")","v":""}]
[{"$f":"IF(Labels!C91<>\"\",Labels!C91,\"\")","v":""},{"$f":"IF(Labels!C92<>\"\",Labels!C92,\"\")","v":""},{"$f":"IF(Labels!C93<>\"\",Labels!C93,\"\")","v":""}]
[{"$f":"IF(Labels!A94<>\"\",Labels!A94,\"\")","v":""},{"$f":"IF(Labels!A95<>\"\",Labels!A95,\"\")","v":""},{"$f":"IF(Labels!A96<>\"\",Labels!A96,\"\")","v":""}]
[{"$f":"IF(Labels!B94<>\"\",Labels!B94,\"\")","v":""},{"$f":"IF(Labels!B95<>\"\",Labels!B95,\"\")","v":""},{"$f":"IF(Labels!B96<>\"\",Labels!B96,\"\")","v":""}]
[{"$f":"IF(Labels!C94<>\"\",Labels!C94,\"\")","v":""},{"$f":"IF(Labels!C95<>\"\",Labels!C95,\"\")","v":""},{"$f":"IF(Labels!C96<>\"\",Labels!C96,\"\")","v":""}]
[{"$f":"IF(Labels!A97<>\"\",Labels!A97,\"\")","v":""},{"$f":"IF(Labels!A98<>\"\",Labels!A98,\"\")","v":""},{"$f":"IF(Labels!A99<>\"\",Labels!A99,\"\")","v":""}]
[{"$f":"IF(Labels!B97<>\"\",Labels!B97,\"\")","v":""},{"$f":"IF(Labels!B98<>\"\",Labels!B98,\"\")","v":""},{"$f":"IF(Labels!B99<>\"\",Labels!B99,\"\")","v":""}]
[{"$f":"IF(Labels!C97<>\"\",Labels!C97,\"\")","v":""},{"$f":"IF(Labels!C98<>\"\",Labels!C98,\"\")","v":""},{"$f":"IF(Labels!C99<>\"\",Labels!C99,\"\")","v":""}]
[{"$f":"IF(Labels!A100<>\"\",Labels!A100,\"\")","v":""},{"$f":"IF(Labels!A101<>\"\",Labels!A101,\"\")","v":""},{"$f":"IF(Labels!A102<>\"\",Labels!A102,\"\")","v":""}]
[{"$f":"IF(Labels!B100<>\"\",Labels!B100,\"\")","v":""},{"$f":"IF(Labels!B101<>\"\",Labels!B101,\"\")","v":""},{"$f":"IF(Labels!B102<>\"\",Labels!B102,\"\")","v":""}]
[{"$f":"IF(Labels!C100<>\"\",Labels!C100,\"\")","v":""},{"$f":"IF(Labels!C101<>\"\",Labels!C101,\"\")","v":""},{"$f":"IF(Labels!C102<>\"\",Labels!C102,\"\")","v":""}]
[{"$f":"IF(Labels!A103<>\"\",Labels!A103,\"\")","v":""},{"$f":"IF(Labels!A104<>\"\",Labels!A104,\"\")","v":""},{"$f":"IF(Labels!A105<>\"\",Labels!A105,\"\")","v":""}]
[{"$f":"IF(Labels!B103<>\"\",Labels!B103,\"\")","v":""},{"$f":"IF(Labels!B104<>\"\",Labels!B104,\"\")","v":""},{"$f":"IF(Labels!B105<>\"\",Labels!B105,\"\")","v":""}]
[{"$f":"IF(Labels!C103<>\"\",Labels!C103,\"\")","v":""},{"$f":"IF(Labels!C104<>\"\",Labels!C104,\"\")","v":""},{"$f":"IF(Labels!C105<>\"\",Labels!C105,\"\")","v":""}]
[{"$f":"IF(Labels!A106<>\"\",Labels!A106,\"\")","v":""},{"$f":"IF(Labels!A107<>\"\",Labels!A107,\"\")","v":""},{"$f":"IF(Labels!A108<>\"\",Labels!A108,\"\")","v":""}]
[{"$f":"IF(Labels!B106<>\"\",Labels!B106,\"\")","v":""},{"$f":"IF(Labels!B107<>\"\",Labels!B107,\"\")","v":""},{"$f":"IF(Labels!B108<>\"\",Labels!B108,\"\")","v":""}]
[{"$f":"IF(Labels!C106<>\"\",Labels!C106,\"\")","v":""},{"$f":"IF(Labels!C107<>\"\",Labels!C107,\"\")","v":""},{"$f":"IF(Labels!C108<>\"\",Labels!C108,\"\")","v":""}]
[{"$f":"IF(Labels!A109<>\"\",Labels!A109,\"\")","v":""},{"$f":"IF(Labels!A110<>\"\",Labels!A110,\"\")","v":""},{"$f":"IF(Labels!A111<>\"\",Labels!A111,\"\")","v":""}]
[{"$f":"IF(Labels!B109<>\"\",Labels!B109,\"\")","v":""},{"$f":"IF(Labels!B110<>\"\",Labels!B110,\"\")","v":""},{"$f":"IF(Labels!B111<>\"\",Labels!B111,\"\")","v":""}]
[{"$f":"IF(Labels!C109<>\"\",Labels!C109,\"\")","v":""},{"$f":"IF(Labels!C110<>\"\",Labels!C110,\"\")","v":""},{"$f":"IF(Labels!C111<>\"\",Labels!C111,\"\")","v":""}]
[{"$f":"IF(Labels!A112<>\"\",Labels!A112,\"\")","v":""},{"$f":"IF(Labels!A113<>\"\",Labels!A113,\"\")","v":""},{"$f":"IF(Labels!A114<>\"\",Labels!A114,\"\")","v":""}]
[{"$f":"IF(Labels!B112<>\"\",Labels!B112,\"\")","v":""},{"$f":"IF(Labels!B113<>\"\",Labels!B113,\"\")","v":""},{"$f":"IF(Labels!B114<>\"\",Labels!B114,\"\")","v":""}]
[{"$f":"IF(Labels!C112<>\"\",Labels!C112,\"\")","v":""},{"$f":"IF(Labels!C113<>\"\",Labels!C113,\"\")","v":""},{"$f":"IF(Labels!C114<>\"\",Labels!C114,\"\")","v":""}]
[{"$f":"IF(Labels!A115<>\"\",Labels!A115,\"\")","v":""},{"$f":"IF(Labels!A116<>\"\",Labels!A116,\"\")","v":""},{"$f":"IF(Labels!A117<>\"\",Labels!A117,\"\")","v":""}]
[{"$f":"IF(Labels!B115<>\"\",Labels!B115,\"\")","v":""},{"$f":"IF(Labels!B116<>\"\",Labels!B116,\"\")","v":""},{"$f":"IF(Labels!B117<>\"\",Labels!B117,\"\")","v":""}]
[{"$f":"IF(Labels!C115<>\"\",Labels!C115,\"\")","v":""},{"$f":"IF(Labels!C116<>\"\",Labels!C116,\"\")","v":""},{"$f":"IF(Labels!C117<>\"\",Labels!C117,\"\")","v":""}]
[{"$f":"IF(Labels!A118<>\"\",Labels!A118,\"\")","v":""},{"$f":"IF(Labels!A119<>\"\",Labels!A119,\"\")","v":""},{"$f":"IF(Labels!A120<>\"\",Labels!A120,\"\")","v":""}]
[{"$f":"IF(Labels!B118<>\"\",Labels!B118,\"\")","v":""},{"$f":"IF(Labels!B119<>\"\",Labels!B119,\"\")","v":""},{"$f":"IF(Labels!B120<>\"\",Labels!B120,\"\")","v":""}]
[{"$f":"IF(Labels!C118<>\"\",Labels!C118,\"\")","v":""},{"$f":"IF(Labels!C119<>\"\",Labels!C119,\"\")","v":""},{"$f":"IF(Labels!C120<>\"\",Labels!C120,\"\")","v":""}]
[{"$f":"IF(Labels!A121<>\"\",Labels!A121,\"\")","v":""},{"$f":"IF(Labels!A122<>\"\",Labels!A122,\"\")","v":""},{"$f":"IF(Labels!A123<>\"\",Labels!A123,\"\")","v":""}]
[{"$f":"IF(Labels!B121<>\"\",Labels!B121,\"\")","v":""},{"$f":"IF(Labels!B122<>\"\",Labels!B122,\"\")","v":""},{"$f":"IF(Labels!B123<>\"\",Labels!B123,\"\")","v":""}]
[{"$f":"IF(Labels!C121<>\"\",Labels!C121,\"\")","v":""},{"$f":"IF(Labels!C122<>\"\",Labels!C122,\"\")","v":""},{"$f":"IF(Labels!C123<>\"\",Labels!C123,\"\")","v":""}]
[{"$f":"IF(Labels!A124<>\"\",Labels!A124,\"\")","v":""},{"$f":"IF(Labels!A125<>\"\",Labels!A125,\"\")","v":""},{"$f":"IF(Labels!A126<>\"\",Labels!A126,\"\")","v":""}]
[{"$f":"IF(Labels!B124<>\"\",Labels!B124,\"\")","v":""},{"$f":"IF(Labels!B125<>\"\",Labels!B125,\"\")","v":""},{"$f":"IF(Labels!B126<>\"\",Labels!B126,\"\")","v":""}]
[{"$f":"IF(Labels!C124<>\"\",Labels!C124,\"\")","v":""},{"$f":"IF(Labels!C125<>\"\",Labels!C125,\"\")","v":""},{"$f":"IF(Labels!C126<>\"\",Labels!C126,\"\")","v":""}]
[{"$f":"IF(Labels!A127<>\"\",Labels!A127,\"\")","v":""},{"$f":"IF(Labels!A128<>\"\",Labels!A128,\"\")","v":""},{"$f":"IF(Labels!A129<>\"\",Labels!A129,\"\")","v":""}]
[{"$f":"IF(Labels!B127<>\"\",Labels!B127,\"\")","v":""},{"$f":"IF(Labels!B128<>\"\",Labels!B128,\"\")","v":""},{"$f":"IF(Labels!B129<>\"\",Labels!B129,\"\")","v":""}]
[{"$f":"IF(Labels!C127<>\"\",Labels!C127,\"\")","v":""},{"$f":"IF(Labels!C128<>\"\",Labels!C128,\"\")","v":""},{"$f":"IF(Labels!C129<>\"\",Labels!C129,\"\")","v":""}]
[{"$f":"IF(Labels!A130<>\"\",Labels!A130,\"\")","v":""},{"$f":"IF(Labels!A131<>\"\",Labels!A131,\"\")","v":""},{"$f":"IF(Labels!A132<>\"\",Labels!A132,\"\")","v":""}]
[{"$f":"IF(Labels!B130<>\"\",Labels!B130,\"\")","v":""},{"$f":"IF(Labels!B131<>\"\",Labels!B131,\"\")","v":""},{"$f":"IF(Labels!B132<>\"\",Labels!B132,\"\")","v":""}]
[{"$f":"IF(Labels!C130<>\"\",Labels!C130,\"\")","v":""},{"$f":"IF(Labels!C131<>\"\",Labels!C131,\"\")","v":""},{"$f":"IF(Labels!C132<>\"\",Labels!C132,\"\")","v":""}]
[{"$f":"IF(Labels!A133<>\"\",Labels!A133,\"\")","v":""},{"$f":"IF(Labels!A134<>\"\",Labels!A134,\"\")","v":""},{"$f":"IF(Labels!A135<>\"\",Labels!A135,\"\")","v":""}]
[{"$f":"IF(Labels!B133<>\"\",Labels!B133,\"\")","v":""},{"$f":"IF(Labels!B134<>\"\",Labels!B134,\"\")","v":""},{"$f":"IF(Labels!B135<>\"\",Labels!B135,\"\")","v":""}]
[{"$f":"IF(Labels!C133<>\"\",Labels!C133,\"\")","v":""},{"$f":"IF(Labels!C134<>\"\",Labels!C134,\"\")","v":""},{"$f":"IF(Labels!C135<>\"\",Labels!C135,\"\")","v":""}]
[{"$f":"IF(Labels!A136<>\"\",Labels!A136,\"\")","v":""},{"$f":"IF(Labels!A137<>\"\",Labels!A137,\"\")","v":""},{"$f":"IF(Labels!A138<>\"\",Labels!A138,\"\")","v":""}]
[{"$f":"IF(Labels!B136<>\"\",Labels!B136,\"\")","v":""},{"$f":"IF(Labels!B137<>\"\",Labels!B137,\"\")","v":""},{"$f":"IF(Labels!B138<>\"\",Labels!B138,\"\")","v":""}]
[{"$f":"IF(Labels!C136<>\"\",Labels!C136,\"\")","v":""},{"$f":"IF(Labels!C137<>\"\",Labels!C137,\"\")","v":""},{"$f":"IF(Labels!C138<>\"\",Labels!C138,\"\")","v":""}]
[{"$f":"IF(Labels!A139<>\"\",Labels!A139,\"\")","v":""},{"$f":"IF(Labels!A140<>\"\",Labels!A140,\"\")","v":""},{"$f":"IF(Labels!A141<>\"\",Labels!A141,\"\")","v":""}]
[{"$f":"IF(Labels!B139<>\"\",Labels!B139,\"\")","v":""},{"$f":"IF(Labels!B140<>\"\",Labels!B140,\"\")","v":""},{"$f":"IF(Labels!B141<>\"\",Labels!B141,\"\")","v":""}]
[{"$f":"IF(Labels!C139<>\"\",Labels!C139,\"\")","v":""},{"$f":"IF(Labels!C140<>\"\",Labels!C140,\"\")","v":""},{"$f":"IF(Labels!C141<>\"\",Labels!C141,\"\")","v":""}]
[{"$f":"IF(Labels!A142<>\"\",Labels!A142,\"\")","v":""},{"$f":"IF(Labels!A143<>\"\",Labels!A143,\"\")","v":""},{"$f":"IF(Labels!A144<>\"\",Labels!A144,\"\")","v":""}]
[{"$f":"IF(Labels!B142<>\"\",Labels!B142,\"\")","v":""},{"$f":"IF(Labels!B143<>\"\",Labels!B143,\"\")","v":""},{"$f":"IF(Labels!B144<>\"\",Labels!B144,\"\")","v":""}]
[{"$f":"IF(Labels!C142<>\"\",Labels!C142,\"\")","v":""},{"$f":"IF(Labels!C143<>\"\",Labels!C143,\"\")","v":""},{"$f":"IF(Labels!C144<>\"\",Labels!C144,\"\")","v":""}]
[{"$f":"IF(Labels!A145<>\"\",Labels!A145,\"\")","v":""},{"$f":"IF(Labels!A146<>\"\",Labels!A146,\"\")","v":""},{"$f":"IF(Labels!A147<>\"\",Labels!A147,\"\")","v":""}]
[{"$f":"IF(Labels!B145<>\"\",Labels!B145,\"\")","v":""},{"$f":"IF(Labels!B146<>\"\",Labels!B146,\"\")","v":""},{"$f":"IF(Labels!B147<>\"\",Labels!B147,\"\")","v":""}]
[{"$f":"IF(Labels!C145<>\"\",Labels!C145,\"\")","v":""},{"$f":"IF(Labels!C146<>\"\",Labels!C146,\"\")","v":""},{"$f":"IF(Labels!C147<>\"\",Labels!C147,\"\")","v":""}]
[{"$f":"IF(Labels!A148<>\"\",Labels!A148,\"\")","v":""},{"$f":"IF(Labels!A149<>\"\",Labels!A149,\"\")","v":""},{"$f":"IF(Labels!A150<>\"\",Labels!A150,\"\")","v":""}]
[{"$f":"IF(Labels!B148<>\"\",Labels!B148,\"\")","v":""},{"$f":"IF(Labels!B149<>\"\",Labels!B149,\"\")","v":""},{"$f":"IF(Labels!B150<>\"\",Labels!B150,\"\")","v":""}]
[{"$f":"IF(Labels!C148<>\"\",Labels!C148,\"\")","v":""},{"$f":"IF(Labels!C149<>\"\",Labels!C149,\"\")","v":""},{"$f":"IF(Labels!C150<>\"\",Labels!C150,\"\")","v":""}]
[{"$f":"IF(Labels!A151<>\"\",Labels!A151,\"\")","v":""},{"$f":"IF(Labels!A152<>\"\",Labels!A152,\"\")","v":""},{"$f":"IF(Labels!A153<>\"\",Labels!A153,\"\")","v":""}]
[{"$f":"IF(Labels!B151<>\"\",Labels!B151,\"\")","v":""},{"$f":"IF(Labels!B152<>\"\",Labels!B152,\"\")","v":""},{"$f":"IF(Labels!B153<>\"\",Labels!B153,\"\")","v":""}]
[{"$f":"IF(Labels!C151<>\"\",Labels!C151,\"\")","v":""},{"$f":"IF(Labels!C152<>\"\",Labels!C152,\"\")","v":""},{"$f":"IF(Labels!C153<>\"\",Labels!C153,\"\")","v":""}]
[{"$f":"IF(Labels!A154<>\"\",Labels!A154,\"\")","v":""},{"$f":"IF(Labels!A155<>\"\",Labels!A155,\"\")","v":""},{"$f":"IF(Labels!A156<>\"\",Labels!A156,\"\")","v":""}]
[{"$f":"IF(Labels!B154<>\"\",Labels!B154,\"\")","v":""},{"$f":"IF(Labels!B155<>\"\",Labels!B155,\"\")","v":""},{"$f":"IF(Labels!B156<>\"\",Labels!B156,\"\")","v":""}]
[{"$f":"IF(Labels!C154<>\"\",Labels!C154,\"\")","v":""},{"$f":"IF(Labels!C155<>\"\",Labels!C155,\"\")","v":""},{"$f":"IF(Labels!C156<>\"\",Labels!C156,\"\")","v":""}]
[{"$f":"IF(Labels!A157<>\"\",Labels!A157,\"\")","v":""},{"$f":"IF(Labels!A158<>\"\",Labels!A158,\"\")","v":""},{"$f":"IF(Labels!A159<>\"\",Labels!A159,\"\")","v":""}]
[{"$f":"IF(Labels!B157<>\"\",Labels!B157,\"\")","v":""},{"$f":"IF(Labels!B158<>\"\",Labels!B158,\"\")","v":""},{"$f":"IF(Labels!B159<>\"\",Labels!B159,\"\")","v":""}]
[{"$f":"IF(Labels!C157<>\"\",Labels!C157,\"\")","v":""},{"$f":"IF(Labels!C158<>\"\",Labels!C158,\"\")","v":""},{"$f":"IF(Labels!C159<>\"\",Labels!C159,\"\")","v":""}]
[{"$f":"IF(Labels!A160<>\"\",Labels!A160,\"\")","v":""},{"$f":"IF(Labels!A161<>\"\",Labels!A161,\"\")","v":""},{"$f":"IF(Labels!A162<>\"\",Labels!A162,\"\")","v":""}]
[{"$f":"IF(Labels!B160<>\"\",Labels!B160,\"\")","v":""},{"$f":"IF(Labels!B161<>\"\",Labels!B161,\"\")","v":""},{"$f":"IF(Labels!B162<>\"\",Labels!B162,\"\")","v":""}]
[{"$f":"IF(Labels!C160<>\"\",Labels!C160,\"\")","v":""},{"$f":"IF(Labels!C161<>\"\",Labels!C161,\"\")","v":""},{"$f":"IF(Labels!C162<>\"\",Labels!C162,\"\")","v":""}]
[{"$f":"IF(Labels!A163<>\"\",Labels!A163,\"\")","v":""},{"$f":"IF(Labels!A164<>\"\",Labels!A164,\"\")","v":""},{"$f":"IF(Labels!A165<>\"\",Labels!A165,\"\")","v":""}]
[{"$f":"IF(Labels!B163<>\"\",Labels!B163,\"\")","v":""},{"$f":"IF(Labels!B164<>\"\",Labels!B164,\"\")","v":""},{"$f":"IF(Labels!B165<>\"\",Labels!B165,\"\")","v":""}]
[{"$f":"IF(Labels!C163<>\"\",Labels!C163,\"\")","v":""},{"$f":"IF(Labels!C164<>\"\",Labels!C164,\"\")","v":""},{"$f":"IF(Labels!C165<>\"\",Labels!C165,\"\")","v":""}]
[{"$f":"IF(Labels!A166<>\"\",Labels!A166,\"\")","v":""},{"$f":"IF(Labels!A167<>\"\",Labels!A167,\"\")","v":""},{"$f":"IF(Labels!A168<>\"\",Labels!A168,\"\")","v":""}]
[{"$f":"IF(Labels!B166<>\"\",Labels!B166,\"\")","v":""},{"$f":"IF(Labels!B167<>\"\",Labels!B167,\"\")","v":""},{"$f":"IF(Labels!B168<>\"\",Labels!B168,\"\")","v":""}]
[{"$f":"IF(Labels!C166<>\"\",Labels!C166,\"\")","v":""},{"$f":"IF(Labels!C167<>\"\",Labels!C167,\"\")","v":""},{"$f":"IF(Labels!C168<>\"\",Labels!C168,\"\")","v":""}]
[{"$f":"IF(Labels!A169<>\"\",Labels!A169,\"\")","v":""},{"$f":"IF(Labels!A170<>\"\",Labels!A170,\"\")","v":""},{"$f":"IF(Labels!A171<>\"\",Labels!A171,\"\")","v":""}]
[{"$f":"IF(Labels!B169<>\"\",Labels!B169,\"\")","v":""},{"$f":"IF(Labels!B170<>\"\",Labels!B170,\"\")","v":""},{"$f":"IF(Labels!B171<>\"\",Labels!B171,\"\")","v":""}]
[{"$f":"IF(Labels!C169<>\"\",Labels!C169,\"\")","v":""},{"$f":"IF(Labels!C170<>\"\",Labels!C170,\"\")","v":""},{"$f":"IF(Labels!C171<>\"\",Labels!C171,\"\")","v":""}]
[{"$f":"IF(Labels!A172<>\"\",Labels!A172,\"\")","v":""},{"$f":"IF(Labels!A173<>\"\",Labels!A173,\"\")","v":""},{"$f":"IF(Labels!A174<>\"\",Labels!A174,\"\")","v":""}]
[{"$f":"IF(Labels!B172<>\"\",Labels!B172,\"\")","v":""},{"$f":"IF(Labels!B173<>\"\",Labels!B173,\"\")","v":""},{"$f":"IF(Labels!B174<>\"\",Labels!B174,\"\")","v":""}]
[{"$f":"IF(Labels!C172<>\"\",Labels!C172,\"\")","v":""},{"$f":"IF(Labels!C173<>\"\",Labels!C173,\"\")","v":""},{"$f":"IF(Labels!C174<>\"\",Labels!C174,\"\")","v":""}]
[{"$f":"IF(Labels!A175<>\"\",Labels!A175,\"\")","v":""},{"$f":"IF(Labels!A176<>\"\",Labels!A176,\"\")","v":""},{"$f":"IF(Labels!A177<>\"\",Labels!A177,\"\")","v":""}]
[{"$f":"IF(Labels!B175<>\"\",Labels!B175,\"\")","v":""},{"$f":"IF(Labels!B176<>\"\",Labels!B176,\"\")","v":""},{"$f":"IF(Labels!B177<>\"\",Labels!B177,\"\")","v":""}]
[{"$f":"IF(Labels!C175<>\"\",Labels!C175,\"\")","v":""},{"$f":"IF(Labels!C176<>\"\",Labels!C176,\"\")","v":""},{"$f":"IF(Labels!C177<>\"\",Labels!C177,\"\")","v":""}]
[{"$f":"IF(Labels!A178<>\"\",Labels!A178,\"\")","v":""},{"$f":"IF(Labels!A179<>\"\",Labels!A179,\"\")","v":""},{"$f":"IF(Labels!A180<>\"\",Labels!A180,\"\")","v":""}]
[{"$f":"IF(Labels!B178<>\"\",Labels!B178,\"\")","v":""},{"$f":"IF(Labels!B179<>\"\",Labels!B179,\"\")","v":""},{"$f":"IF(Labels!B180<>\"\",Labels!B180,\"\")","v":""}]
[{"$f":"IF(Labels!C178<>\"\",Labels!C178,\"\")","v":""},{"$f":"IF(Labels!C179<>\"\",Labels!C179,\"\")","v":""},{"$f":"IF(Labels!C180<>\"\",Labels!C180,\"\")","v":""}]
[{"$f":"IF(Labels!A181<>\"\",Labels!A181,\"\")","v":""},{"$f":"IF(Labels!A182<>\"\",Labels!A182,\"\")","v":""},{"$f":"IF(Labels!A183<>\"\",Labels!A183,\"\")","v":""}]
[{"$f":"IF(Labels!B181<>\"\",Labels!B181,\"\")","v":""},{"$f":"IF(Labels!B182<>\"\",Labels!B182,\"\")","v":""},{"$f":"IF(Labels!B183<>\"\",Labels!B183,\"\")","v":""}]
[{"$f":"IF(Labels!C181<>\"\",Labels!C181,\"\")","v":""},{"$f":"IF(Labels!C182<>\"\",Labels!C182,\"\")","v":""},{"$f":"IF(Labels!C183<>\"\",Labels!C183,\"\")","v":""}]
[{"$f":"IF(Labels!A184<>\"\",Labels!A184,\"\")","v":""},{"$f":"IF(Labels!A185<>\"\",Labels!A185,\"\")","v":""},{"$f":"IF(Labels!A186<>\"\",Labels!A186,\"\")","v":""}]
[{"$f":"IF(Labels!B184<>\"\",Labels!B184,\"\")","v":""},{"$f":"IF(Labels!B185<>\"\",Labels!B185,\"\")","v":""},{"$f":"IF(Labels!B186<>\"\",Labels!B186,\"\")","v":""}]
[{"$f":"IF(Labels!C184<>\"\",Labels!C184,\"\")","v":""},{"$f":"IF(Labels!C185<>\"\",Labels!C185,\"\")","v":""},{"$f":"IF(Labels!C186<>\"\",Labels!C186,\"\")","v":""}]
[{"$f":"IF(Labels!A187<>\"\",Labels!A187,\"\")","v":""},{"$f":"IF(Labels!A188<>\"\",Labels!A188,\"\")","v":""},{"$f":"IF(Labels!A189<>\"\",Labels!A189,\"\")","v":""}]
[{"$f":"IF(Labels!B187<>\"\",Labels!B187,\"\")","v":""},{"$f":"IF(Labels!B188<>\"\",Labels!B188,\"\")","v":""},{"$f":"IF(Labels!B189<>\"\",Labels!B189,\"\")","v":""}]
[{"$f":"IF(Labels!C187<>\"\",Labels!C187,\"\")","v":""},{"$f":"IF(Labels!C188<>\"\",Labels!C188,\"\")","v":""},{"$f":"IF(Labels!C189<>\"\",Labels!C189,\"\")","v":""}]
[{"$f":"IF(Labels!A190<>\"\",Labels!A190,\"\")","v":""},{"$f":"IF(Labels!A191<>\"\",Labels!A191,\"\")","v":""},{"$f":"IF(Labels!A192<>\"\",Labels!A192,\"\")","v":""}]
[{"$f":"IF(Labels!B190<>\"\",Labels!B190,\"\")","v":""},{"$f":"IF(Labels!B191<>\"\",Labels!B191,\"\")","v":""},{"$f":"IF(Labels!B192<>\"\",Labels!B192,\"\")","v":""}]
[{"$f":"IF(Labels!C190<>\"\",Labels!C190,\"\")","v":""},{"$f":"IF(Labels!C191<>\"\",Labels!C191,\"\")","v":""},{"$f":"IF(Labels!C192<>\"\",Labels!C192,\"\")","v":""}]
[{"$f":"IF(Labels!A193<>\"\",Labels!A193,\"\")","v":""},{"$f":"IF(Labels!A194<>\"\",Labels!A194,\"\")","v":""},{"$f":"IF(Labels!A195<>\"\",Labels!A195,\"\")","v":""}]
[{"$f":"IF(Labels!B193<>\"\",Labels!B193,\"\")","v":""},{"$f":"IF(Labels!B194<>\"\",Labels!B194,\"\")","v":""},{"$f":"IF(Labels!B195<>\"\",Labels!B195,\"\")","v":""}]
[{"$f":"IF(Labels!C193<>\"\",Labels!C193,\"\")","v":""},{"$f":"IF(Labels!C194<>\"\",Labels!C194,\"\")","v":""},{"$f":"IF(Labels!C195<>\"\",Labels!C195,\"\")","v":""}]
[{"$f":"IF(Labels!A196<>\"\",Labels!A196,\"\")","v":""},{"$f":"IF(Labels!A197<>\"\",Labels!A197,\"\")","v":""},{"$f":"IF(Labels!A198<>\"\",Labels!A198,\"\")","v":""}]
[{"$f":"IF(Labels!B196<>\"\",Labels!B196,\"\")","v":""},{"$f":"IF(Labels!B197<>\"\",Labels!B197,\"\")","v":""},{"$f":"IF(Labels!B198<>\"\",Labels!B198,\"\")","v":""}]
[{"$f":"IF(Labels!C196<>\"\",Labels!C196,\"\")","v":""},{"$f":"IF(Labels!C197<>\"\",Labels!C197,\"\")","v":""},{"$f":"IF(Labels!C198<>\"\",Labels!C198,\"\")","v":""}]
[{"$f":"IF(Labels!A199<>\"\",Labels!A199,\"\")","v":""},{"$f":"IF(Labels!A200<>\"\",Labels!A200,\"\")","v":""},{"$f":"IF(Labels!A201<>\"\",Labels!A201,\"\")","v":""}]
[{"$f":"IF(Labels!B199<>\"\",Labels!B199,\"\")","v":""},{"$f":"IF(Labels!B200<>\"\",Labels!B200,\"\")","v":""},{"$f":"IF(Labels!B201<>\"\",Labels!B201,\"\")","v":""}]
[{"$f":"IF(Labels!C199<>\"\",Labels!C199,\"\")","v":""},{"$f":"IF(Labels!C200<>\"\",Labels!C200,\"\")","v":""},{"$f":"IF(Labels!C201<>\"\",Labels!C201,\"\")","v":""}]
[{"$f":"IF(Labels!A202<>\"\",Labels!A202,\"\")","v":""},{"$f":"IF(Labels!A203<>\"\",Labels!A203,\"\")","v":""},{"$f":"IF(Labels!A204<>\"\",Labels!A204,\"\")","v":""}]
[{"$f":"IF(Labels!B202<>\"\",Labels!B202,\"\")","v":""},{"$f":"IF(Labels!B203<>\"\",Labels!B203,\"\")","v":""},{"$f":"IF(Labels!B204<>\"\",Labels!B204,\"\")","v":""}]
[{"$f":"IF(Labels!C202<>\"\",Labels!C202,\"\")","v":""},{"$f":"IF(Labels!C203<>\"\",Labels!C203,\"\")","v":""},{"$f":"IF(Labels!C204<>\"\",Labels!C204,\"\")","v":""}]
[{"$f":"IF(Labels!A205<>\"\",Labels!A205,\"\")","v":""},{"$f":"IF(Labels!A206<>\"\",Labels!A206,\"\")","v":""},{"$f":"IF(Labels!A207<>\"\",Labels!A207,\"\")","v":""}]
[{"$f":"IF(Labels!B205<>\"\",Labels!B205,\"\")","v":""},{"$f":"IF(Labels!B206<>\"\",Labels!B206,\"\")","v":""},{"$f":"IF(Labels!B207<>\"\",Labels!B207,\"\")","v":""}]
[{"$f":"IF(Labels!C205<>\"\",Labels!C205,\"\")","v":""},{"$f":"IF(Labels!C206<>\"\",Labels!C206,\"\")","v":""},{"$f":"IF(Labels!C207<>\"\",Labels!C207,\"\")","v":""}]
[{"$f":"IF(Labels!A208<>\"\",Labels!A208,\"\")","v":""},{"$f":"IF(Labels!A209<>\"\",Labels!A209,\"\")","v":""},{"$f":"IF(Labels!A210<>\"\",Labels!A210,\"\")","v":""}]
[{"$f":"IF(Labels!B208<>\"\",Labels!B208,\"\")","v":""},{"$f":"IF(Labels!B209<>\"\",Labels!B209,\"\")","v":""},{"$f":"IF(Labels!B210<>\"\",Labels!B210,\"\")","v":""}]
[{"$f":"IF(Labels!C208<>\"\",Labels!C208,\"\")","v":""},{"$f":"IF(Labels!C209<>\"\",Labels!C209,\"\")","v":""},{"$f":"IF(Labels!C210<>\"\",Labels!C210,\"\")","v":""}]
[{"$f":"IF(Labels!A211<>\"\",Labels!A211,\"\")","v":""},{"$f":"IF(Labels!A212<>\"\",Labels!A212,\"\")","v":""},{"$f":"IF(Labels!A213<>\"\",Labels!A213,\"\")","v":""}]
[{"$f":"IF(Labels!B211<>\"\",Labels!B211,\"\")","v":""},{"$f":"IF(Labels!B212<>\"\",Labels!B212,\"\")","v":""},{"$f":"IF(Labels!B213<>\"\",Labels!B213,\"\")","v":""}]
[{"$f":"IF(Labels!C211<>\"\",Labels!C211,\"\")","v":""},{"$f":"IF(Labels!C212<>\"\",Labels!C212,\"\")","v":""},{"$f":"IF(Labels!C213<>\"\",Labels!C213,\"\")","v":""}]
[{"$f":"IF(Labels!A214<>\"\",Labels!A214,\"\")","v":""},{"$f":"IF(Labels!A215<>\"\",Labels!A215,\"\")","v":""},{"$f":"IF(Labels!A216<>\"\",Labels!A216,\"\")","v":""}]
[{"$f":"IF(Labels!B214<>\"\",Labels!B214,\"\")","v":""},{"$f":"IF(Labels!B215<>\"\",Labels!B215,\"\")","v":""},{"$f":"IF(Labels!B216<>\"\",Labels!B216,\"\")","v":""}]
[{"$f":"IF(Labels!C214<>\"\",Labels!C214,\"\")","v":""},{"$f":"IF(Labels!C215<>\"\",Labels!C215,\"\")","v":""},{"$f":"IF(Labels!C216<>\"\",Labels!C216,\"\")","v":""}]
[{"$f":"IF(Labels!A217<>\"\",Labels!A217,\"\")","v":""},{"$f":"IF(Labels!A218<>\"\",Labels!A218,\"\")","v":""},{"$f":"IF(Labels!A219<>\"\",Labels!A219,\"\")","v":""}]
[{"$f":"IF(Labels!B217<>\"\",Labels!B217,\"\")","v":""},{"$f":"IF(Labels!B218<>\"\",Labels!B218,\"\")","v":""},{"$f":"IF(Labels!B219<>\"\",Labels!B219,\"\")","v":""}]
[{"$f":"IF(Labels!C217<>\"\",Labels!C217,\"\")","v":""},{"$f":"IF(Labels!C218<>\"\",Labels!C218,\"\")","v":""},{"$f":"IF(Labels!C219<>\"\",Labels!C219,\"\")","v":""}]
[{"$f":"IF(Labels!A220<>\"\",Labels!A220,\"\")","v":""},{"$f":"IF(Labels!A221<>\"\",Labels!A221,\"\")","v":""},{"$f":"IF(Labels!A222<>\"\",Labels!A222,\"\")","v":""}]
[{"$f":"IF(Labels!B220<>\"\",Labels!B220,\"\")","v":""},{"$f":"IF(Labels!B221<>\"\",Labels!B221,\"\")","v":""},{"$f":"IF(Labels!B222<>\"\",Labels!B222,\"\")","v":""}]
[{"$f":"IF(Labels!C220<>\"\",Labels!C220,\"\")","v":""},{"$f":"IF(Labels!C221<>\"\",Labels!C221,\"\")","v":""},{"$f":"IF(Labels!C222<>\"\",Labels!C222,\"\")","v":""}]
[{"$f":"IF(Labels!A223<>\"\",Labels!A223,\"\")","v":""},{"$f":"IF(Labels!A224<>\"\",Labels!A224,\"\")","v":""},{"$f":"IF(Labels!A225<>\"\",Labels!A225,\"\")","v":""}]
[{"$f":"IF(Labels!B223<>\"\",Labels!B223,\"\")","v":""},{"$f":"IF(Labels!B224<>\"\",Labels!B224,\"\")","v":""},{"$f":"IF(Labels!B225<>\"\",Labels!B225,\"\")","v":""}]
[{"$f":"IF(Labels!C223<>\"\",Labels!C223,\"\")","v":""},{"$f":"IF(Labels!C224<>\"\",Labels!C224,\"\")","v":""},{"$f":"IF(Labels!C225<>\"\",Labels!C225,\"\")","v":""}]
[{"$f":"IF(Labels!A226<>\"\",Labels!A226,\"\")","v":""},{"$f":"IF(Labels!A227<>\"\",Labels!A227,\"\")","v":""},{"$f":"IF(Labels!A228<>\"\",Labels!A228,\"\")","v":""}]
[{"$f":"IF(Labels!B226<>\"\",Labels!B226,\"\")","v":""},{"$f":"IF(Labels!B227<>\"\",Labels!B227,\"\")","v":""},{"$f":"IF(Labels!B228<>\"\",Labels!B228,\"\")","v":""}]
[{"$f":"IF(Labels!C226<>\"\",Labels!C226,\"\")","v":""},{"$f":"IF(Labels!C227<>\"\",Labels!C227,\"\")","v":""},{"$f":"IF(Labels!C228<>\"\",Labels!C228,\"\")","v":""}]
[{"$f":"IF(Labels!A229<>\"\",Labels!A229,\"\")","v":""},{"$f":"IF(Labels!A230<>\"\",Labels!A230,\"\")","v":""},{"$f":"IF(Labels!A231<>\"\",Labels!A231,\"\")","v":""}]
[{"$f":"IF(Labels!B229<>\"\",Labels!B229,\"\")","v":""},{"$f":"IF(Labels!B230<>\"\",Labels!B230,\"\")","v":""},{"$f":"IF(Labels!B231<>\"\",Labels!B231,\"\")","v":""}]
[{"$f":"IF(Labels!C229<>\"\",Labels!C229,\"\")","v":""},{"$f":"IF(Labels!C230<>\"\",Labels!C230,\"\")","v":""},{"$f":"IF(Labels!C231<>\"\",Labels!C231,\"\")","v":""}]
[{"$f":"IF(Labels!A232<>\"\",Labels!A232,\"\")","v":""},{"$f":"IF(Labels!A233<>\"\",Labels!A233,\"\")","v":""},{"$f":"IF(Labels!A234<>\"\",Labels!A234,\"\")","v":""}]
[{"$f":"IF(Labels!B232<>\"\",Labels!B232,\"\")","v":""},{"$f":"IF(Labels!B233<>\"\",Labels!B233,\"\")","v":""},{"$f":"IF(Labels!B234<>\"\",Labels!B234,\"\")","v":""}]
[{"$f":"IF(Labels!C232<>\"\",Labels!C232,\"\")","v":""},{"$f":"IF(Labels!C233<>\"\",Labels!C233,\"\")","v":""},{"$f":"IF(Labels!C234<>\"\",Labels!C234,\"\")","v":""}]
[{"$f":"IF(Labels!A235<>\"\",Labels!A235,\"\")","v":""},{"$f":"IF(Labels!A236<>\"\",Labels!A236,\"\")","v":""},{"$f":"IF(Labels!A237<>\"\",Labels!A237,\"\")","v":""}]
[{"$f":"IF(Labels!B235<>\"\",Labels!B235,\"\")","v":""},{"$f":"IF(Labels!B236<>\"\",Labels!B236,\"\")","v":""},{"$f":"IF(Labels!B237<>\"\",Labels!B237,\"\")","v":""}]
[{"$f":"IF(Labels!C235<>\"\",Labels!C235,\"\")","v":""},{"$f":"IF(Labels!C236<>\"\",Labels!C236,\"\")","v":""},{"$f":"IF(Labels!C237<>\"\",Labels!C237,\"\")","v":""}]
[{"$f":"IF(Labels!A238<>\"\",Labels!A238,\"\")","v":""},{"$f":"IF(Labels!A239<>\"\",Labels!A239,\"\")","v":""},{"$f":"IF(Labels!A240<>\"\",Labels!A240,\"\")","v":""}]
[{"$f":"IF(Labels!B238<>\"\",Labels!B238,\"\")","v":""},{"$f":"IF(Labels!B239<>\"\",Labels!B239,\"\")","v":""},{"$f":"IF(Labels!B240<>\"\",Labels!B240,\"\")","v":""}]
[{"$f":"IF(Labels!C238<>\"\",Labels!C238,\"\")","v":""},{"$f":"IF(Labels!C239<>\"\",Labels!C239,\"\")","v":""},{"$f":"IF(Labels!C240<>\"\",Labels!C240,\"\")","v":""}]
[{"$f":"IF(Labels!A241<>\"\",Labels!A241,\"\")","v":""},{"$f":"IF(Labels!A242<>\"\",Labels!A242,\"\")","v":""},{"$f":"IF(Labels!A243<>\"\",Labels!A243,\"\")","v":""}]
[{"$f":"IF(Labels!B241<>\"\",Labels!B241,\"\")","v":""},{"$f":"IF(Labels!B242<>\"\",Labels!B242,\"\")","v":""},{"$f":"IF(Labels!B243<>\"\",Labels!B243,\"\")","v":""}]
[{"$f":"IF(Labels!C241<>\"\",Labels!C241,\"\")","v":""},{"$f":"IF(Labels!C242<>\"\",Labels!C242,\"\")","v":""},{"$f":"IF(Labels!C243<>\"\",Labels!C243,\"\")","v":""}]
[{"$f":"IF(Labels!A244<>\"\",Labels!A244,\"\")","v":""},{"$f":"IF(Labels!A245<>\"\",Labels!A245,\"\")","v":""},{"$f":"IF(Labels!A246<>\"\",Labels!A246,\"\")","v":""}]
[{"$f":"IF(Labels!B244<>\"\",Labels!B244,\"\")","v":""},{"$f":"IF(Labels!B245<>\"\",Labels!B245,\"\")","v":""},{"$f":"IF(Labels!B246<>\"\",Labels!B246,\"\")","v":""}]
[{"$f":"IF(Labels!C244<>\"\",Labels!C244,\"\")","v":""},{"$f":"IF(Labels!C245<>\"\",Labels!C245,\"\")","v":""},{"$f":"IF(Labels!C246<>\"\",Labels!C246,\"\")","v":""}]
[{"$f":"IF(Labels!A247<>\"\",Labels!A247,\"\")","v":""},{"$f":"IF(Labels!A248<>\"\",Labels!A248,\"\")","v":""},{"$f":"IF(Labels!A249<>\"\",Labels!A249,\"\")","v":""}]
[{"$f":"IF(Labels!B247<>\"\",Labels!B247,\"\")","v":""},{"$f":"IF(Labels!B248<>\"\",Labels!B248,\"\")","v":""},{"$f":"IF(Labels!B249<>\"\",Labels!B249,\"\")","v":""}]
[{"$f":"IF(Labels!C247<>\"\",Labels!C247,\"\")","v":""},{"$f":"IF(Labels!C248<>\"\",Labels!C248,\"\")","v":""},{"$f":"IF(Labels!C249<>\"\",Labels!C249,\"\")","v":""}]
[{"$f":"IF(Labels!A250<>\"\",Labels!A250,\"\")","v":""},{"$f":"IF(Labels!A251<>\"\",Labels!A251,\"\")","v":""},{"$f":"IF(Labels!A252<>\"\",Labels!A252,\"\")","v":""}]
[{"$f":"IF(Labels!B250<>\"\",Labels!B250,\"\")","v":""},{"$f":"IF(Labels!B251<>\"\",Labels!B251,\"\")","v":""},{"$f":"IF(Labels!B252<>\"\",Labels!B252,\"\")","v":""}]
[{"$f":"IF(Labels!C250<>\"\",Labels!C250,\"\")","v":""},{"$f":"IF(Labels!C251<>\"\",Labels!C251,\"\")","v":""},{"$f":"IF(Labels!C252<>\"\",Labels!C252,\"\")","v":""}]
[{"$f":"IF(Labels!A253<>\"\",Labels!A253,\"\")","v":""},{"$f":"IF(Labels!A254<>\"\",Labels!A254,\"\")","v":""},{"$f":"IF(Labels!A255<>\"\",Labels!A255,\"\")","v":""}]
[{"$f":"IF(Labels!B253<>\"\",Labels!B253,\"\")","v":""},{"$f":"IF(Labels!B254<>\"\",Labels!B254,\"\")","v":""},{"$f":"IF(Labels!B255<>\"\",Labels!B255,\"\")","v":""}]
[{"$f":"IF(Labels!C253<>\"\",Labels!C253,\"\")","v":""},{"$f":"IF(Labels!C254<>\"\",Labels!C254,\"\")","v":""},{"$f":"IF(Labels!C255<>\"\",Labels!C255,\"\")","v":""}]
[{"$f":"IF(Labels!A256<>\"\",Labels!A256,\"\")","v":""},{"$f":"IF(Labels!A257<>\"\",Labels!A257,\"\")","v":""},{"$f":"IF(Labels!A258<>\"\",Labels!A258,\"\")","v":""}]
[{"$f":"IF(Labels!B256<>\"\",Labels!B256,\"\")","v":""},{"$f":"IF(Labels!B257<>\"\",Labels!B257,\"\")","v":""},{"$f":"IF(Labels!B258<>\"\",Labels!B258,\"\")","v":""}]
[{"$f":"IF(Labels!C256<>\"\",Labels!C256,\"\")","v":""},{"$f":"IF(Labels!C257<>\"\",Labels!C257,\"\")","v":""},{"$f":"IF(Labels!C258<>\"\",Labels!C258,\"\")","v":""}]
[{"$f":"IF(Labels!A259<>\"\",Labels!A259,\"\")","v":""},{"$f":"IF(Labels!A260<>\"\",Labels!A260,\"\")","v":""},{"$f":"IF(Labels!A261<>\"\",Labels!A261,\"\")","v":""}]
[{"$f":"IF(Labels!B259<>\"\",Labels!B259,\"\")","v":""},{"$f":"IF(Labels!B260<>\"\",Labels!B260,\"\")","v":""},{"$f":"IF(Labels!B261<>\"\",Labels!B261,\"\")","v":""}]
[{"$f":"IF(Labels!C259<>\"\",Labels!C259,\"\")","v":""},{"$f":"IF(Labels!C260<>\"\",Labels!C260,\"\")","v":""},{"$f":"IF(Labels!C261<>\"\",Labels!C261,\"\")","v":""}]
[{"$f":"IF(Labels!A262<>\"\",Labels!A262,\"\")","v":""},{"$f":"IF(Labels!A263<>\"\",Labels!A263,\"\")","v":""},{"$f":"IF(Labels!A264<>\"\",Labels!A264,\"\")","v":""}]
[{"$f":"IF(Labels!B262<>\"\",Labels!B262,\"\")","v":""},{"$f":"IF(Labels!B263<>\"\",Labels!B263,\"\")","v":""},{"$f":"IF(Labels!B264<>\"\",Labels!B264,\"\")","v":""}]
[{"$f":"IF(Labels!C262<>\"\",Labels!C262,\"\")","v":""},{"$f":"IF(Labels!C263<>\"\",Labels!C263,\"\")","v":""},{"$f":"IF(Labels!C264<>\"\",Labels!C264,\"\")","v":""}]
[{"$f":"IF(Labels!A265<>\"\",Labels!A265,\"\")","v":""},{"$f":"IF(Labels!A266<>\"\",Labels!A266,\"\")","v":""},{"$f":"IF(Labels!A267<>\"\",Labels!A267,\"\")","v":""}]
[{"$f":"IF(Labels!B265<>\"\",Labels!B265,\"\")","v":""},{"$f":"IF(Labels!B266<>\"\",Labels!B266,\"\")","v":""},{"$f":"IF(Labels!B267<>\"\",Labels!B267,\"\")","v":""}]
[{"$f":"IF(Labels!C265<>\"\",Labels!C265,\"\")","v":""},{"$f":"IF(Labels!C266<>\"\",Labels!C266,\"\")","v":""},{"$f":"IF(Labels!C267<>\"\",Labels!C267,\"\")","v":""}]
[{"$f":"IF(Labels!A268<>\"\",Labels!A268,\"\")","v":""},{"$f":"IF(Labels!A269<>\"\",Labels!A269,\"\")","v":""},{"$f":"IF(Labels!A270<>\"\",Labels!A270,\"\")","v":""}]
[{"$f":"IF(Labels!B268<>\"\",Labels!B268,\"\")","v":""},{"$f":"IF(Labels!B269<>\"\",Labels!B269,\"\")","v":""},{"$f":"IF(Labels!B270<>\"\",Labels!B270,\"\")","v":""}]
[{"$f":"IF(Labels!C268<>\"\",Labels!C268,\"\")","v":""},{"$f":"IF(Labels!C269<>\"\",Labels!C269,\"\")","v":""},{"$f":"IF(Labels!C270<>\"\",Labels!C270,\"\")","v":""}]

{"sheet":"SR1 Card","index":24,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["STATISTICAL OFFICE RECORD",null,"CIRCLE THE NUMBER OF EACH MATCH YOU WISH TO "]
["NRA CONVENTIONAL TOURNAMENTS ONLY",null,"ENTER:               All individual Matches (Check) [ ]"]
["(To be retained by Sponsor)",null,"1        2        3        4       5        6        7        8        9        10"]
[null,null,"11     12       13      14     15      16      17      18       19        20"]
[{"$f":"\"     \"&Options!L4&\" \"&Options!L5&\" \"&Options!L6","v":"     John D. Doe "}]
[" (Print)                    NAME                      COMP #",null,"I WILL FIRE TEAM MATCH NUMBER ______________________"]
[]
[{"$f":"\"     \"&Options!L9","v":"     123 Any St"},null,{"$f":"\" \"&Options!L15&\" \"","v":"  "}]
["STREET ADDRESS",null,"TEAM NAME"]
[]
[{"$f":"\"  \"&LEFT(Options!L10&\"                                 \",32)&Options!L11&RIGHT(\"                                             \"&Options!L12,45)","v":"  Any Town                        US                                        00000"},null,"CATEGORIES (circle one)"]
[" CITY                                STATE                                  ZIP CODE"]
[null,null,"Senior                                                                    Special_________________"]
["NRA CARD #1 FOR USE AS ENTRY CARD AND FOR REPORTING",null,"Civilian          Police          Reserve         Service          Woman        Nat'l Guard"]
["SCORES TO NRA. SPONSOR: IMMEDIATELY AFTER TOURNAMENT,",null,"Junior       Intermediate Jr.       Sub-Jr.       ROTC      Collegiate       High School"]
["DETACT OTHER PORTION AND SEND TO NRA. SEND ONE FOR"]
["EACH COMPETITOR. SEE RULE BOOK SECTION 19 FOR SCORES",null,"CLASSIFICATION (circle one)"]
["TO BE REPORTED FOR CLASSIFICATION. INCLUDE FIRED TEAM"]
["SCORES OF INDIVIDUALS.",null,"UNCLASSIFIED                        HIGH MASTER                             MASTER"]
[null,null,"EXPERT                                     SHARPSHOOTER                 MARKSMAN"]
[]
["No. Matches________________                Total Fees $__________________",null,"RELAY:  1st Choice____________    2nd Choice____________"]
[]
["Registration Fee $_______________               Amount Paid $_____________",null,"Relay time:__________   Day:_________   Date:___________"]
[]
[]
["SPONSOR SCORE REPORTING CARD",null,"NRA CONVENTIONAL TOURNAMENTS ONLY"]
["(Complete and return this portion to NRA)"]
[]
[{"$f":"\"NRA ID No.       \"&Options!L7","v":"NRA ID No.       123456789"}]
[null,null,"[ ] Indoor                           [ ] Outdoor"]
[{"$f":"\"Date of Birth:          \"&Options!L8","v":"Date of Birth:          "}]
[null,null,"                                                   INDIVIDUAL                            TEAM"]
["COMPETITOR NO.___________________                 (This Tournament)",null,"TYPE                              NO.        TOTAL        NO.         TOTAL"]
[null,null,"COMPETITION           SHOTS     SCORE    SHOTS     SCORE"]
[{"$f":"LEFT(\"          \"&Options!L6&\"                                \",40)&Options!L4&RIGHT(\"                                        \"&Options!L5,40)","v":"          Doe                           John                                      D."}]
["(print)    LAST NAME                   FIRST NAME                               MI",null,"Conv. Pistol                ______     ______      ______     ______"]
[null,null,"High Power Sporting   ______     ______      ______     ______"]
[{"$f":"A8","v":"     123 Any St"},null,"SBR Prone                 ______     ______      ______     ______"]
["STREET ADDRESS",null,"SBR Metric Prone       ______     ______      ______     ______"]
[null,null,"SBR 3-Position           ______     ______      ______     ______"]
[{"$f":"A11","v":"  Any Town                        US                                        00000"},null,"SBR 4-Position           ______     ______      ______     ______"]
["CITY                                 STATE                                   ZIP CODE",null,"Light Rifle                   ______     ______      ______     ______"]
[null,null,"BB Gun                      ______     ______      ______     ______"]
[{"$f":"\"                    \"&Options!L13&RIGHT(\"                                        \"&Options!L14,40)","v":"                                                            "},null,"Air Rifle 3-Position      ______     ______      ______     ______"]
["TOURNAMENT DATE & LOCATION",null,"Air Rifle 4-Position      ______     ______      ______     ______"]
[]
["Signature of Competitor:__________________________________________________"]
[]
["Excel copy of SR-1 Form for NRA Tournaments"]

{"sheet":"Scorecard Indoor","index":25,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Comp #","Competitor Name",null,null,null,null,"Date",null,"Caliber",null,"Relay","Target"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Slow Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Slow Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Timed Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Timed Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Timed Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Rapid Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Rapid Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Rapid Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Gallery"]
[null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Gallery"]
[null,"Timed Fire",null,null,null,null,null,null,null,null,null,null,null,"Gallery"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Gallery"]
[null,"Rapid Fire"]
[null,"Range Officer's Initials",null,"Competitor's Signature",null,null,null,null,"Scorer's Signature",null,null,null,null,"Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match Total"]
[]
[]
[]
[]
[]
[]
[null,"Comp #","Competitor Name",null,null,null,null,"Date",null,"Caliber",null,"Relay","Target"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Slow Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Slow Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Timed Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Timed Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Timed Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Rapid Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Rapid Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Rapid Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Gallery"]
[null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Gallery"]
[null,"Timed Fire",null,null,null,null,null,null,null,null,null,null,null,"Gallery"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Gallery"]
[null,"Rapid Fire"]
[null,"Range Officer's Initials",null,"Competitor's Signature",null,null,null,null,"Scorer's Signature",null,null,null,null,"Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match Total"]

{"sheet":"Scorecard Outdoor","index":26,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Comp #","Competitor Name",null,null,null,null,"Date",null,"Caliber",null,"Relay","Target"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Slow Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Slow Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"NMC"]
[null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"NMC"]
[null,"Timed Fire",null,null,null,null,null,null,null,null,null,null,null,"NMC"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"NMC"]
[null,"Rapid Fire"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Timed Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Timed Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Timed Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Rapid Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Rapid Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Rapid Fire"]
[null,"Target 2"]
[null,"Range Officer's Initials",null,"Competitor's Signature",null,null,null,null,"Scorer's Signature",null,null,null,null,"Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match Total"]
[]
[]
[]
[]
[]
[]
[null,"Comp #","Competitor Name",null,null,null,null,"Date",null,"Caliber",null,"Relay","Target"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Slow Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Slow Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"NMC"]
[null,"Slow Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"NMC"]
[null,"Timed Fire",null,null,null,null,null,null,null,null,null,null,null,"NMC"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"NMC"]
[null,"Rapid Fire"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Timed Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Timed Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Timed Fire"]
[null,"Target 2"]
[null,"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score"]
[null,"Rapid Fire"]
[null,"Target 1",null,null,null,null,null,null,null,null,null,null,null,"Rapid Fire"]
[null,null,1,2,3,4,5,6,7,8,9,10,"Score","Match Total"]
[null,"Rapid Fire"]
[null,"Target 2"]
[null,"Range Officer's Initials",null,"Competitor's Signature",null,null,null,null,"Scorer's Signature",null,null,null,null,"Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Match Total"]