{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Main","GalacticSearch","AutoNav","Hyperdrive","InterstellarAccuracy","POWERPORT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Instructions"]
["This document illustrates the Overall Score calculation used in the Infinite Recharge at Home Skills Challenge"]
["The Main sheet shows a display of teams in the hypothetical group, raw scores for each challenge, the calculated score for each challenge, and an overall score/leaderboard"]
["Individual Challenge sheets pull team and score data from the Main sheet and show details about the Calculated Score calculation for that challenge"]
["For an online version of these calculations, visit frcathome.org"]
[]
["The Main sheet also contains a button to generate random data and cells to control how many teams participate in each challenge when the data is randomized"]
["In addition to randomly generated data, users can provide their own data or modify the randomly generated dataset after it is created"]
["The random data is implemented using Macros so you can seamlessly switch between user entered data and randomized data without needing to restore any formulas"]
["If entering user provided challenge data, the Team number and Raw Score columns on the \"Main\" sheet are the only columns that should be modified"]
[]
["Randomizing Data"]
["Randomizing data using the button requires macros to be enabled"]
["Randomizing data overwrites all data in \"Raw Score\" columns, including user entered data. Proceed with caution!!"]
["1. Configure the number of teams in the group by adding or removing team numbers in the team number column of the Main sheet, up to a maximum of 35 teams. "]
["Don’t worry about clearing out data for any teams you remove, the randomization will handle that automatically"]
["Team numbers should be continuous in the column (i.e. don't leave a gap). They do not have to be in numerical order"]
["2. Configure the number of teams to participate in each challenge in the yellow cells of the Main sheet. The teams that participate in each challenge are randomly selected independent of other challenges"]
["3. Press \"Randomize\" to generate random data"]
["The generated data uses vaguely realistic data ranges for each challenge but has made no effort to estimate a realistic distribution of data within that range"]
["You can modify the data in the Raw Score columns by hand if desired. All calculated columns will update using the modified data."]
["Raw Score data will only be overwritten if the Randomize button is pressed again"]
[]
["Entering Data Manually"]
["1. Configure the number of teams in the group by adding or removing team numbers in the team number column of the Main sheet, up to a maximum of 35 teams. "]
["Team numbers should be continuous in the column (i.e. don't leave a gap). They do not have to be in numerical order"]
["2. Clear out Raw score data for any removed teams"]
["3. Manually enter data into the Raw Score columns"]
["If you are trying to enter data from your group, you can use a copy+paste to an empty scratch sheet to avoid having to manually type out all of the data"]
["To do this, copy the full table from the FRC events page and paste it onto an empty sheet. Then copy the correct columns into the team and Raw Score columns on the Main sheet"]
[]
["Document protection"]
["The sheets on this document have been protected to allow entry into the cells expected to be manipulated by users and protect the cells that contain formulas or other calculated results"]
["This protection is solely to try to prevent accidental modification from breaking the workbook, there is no password set for the protection, so selecting \"Unprotect Sheet\" from the Review Tab is all that is required to disable it"]

{"sheet":"Main","index":1,"n_rows":45,"n_cols":33,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,25,8,26],[6,10,7,10],[8,1,8,2],[6,2,7,2],[6,4,7,4],[6,6,7,6],[6,8,7,8],[8,9,8,10],[8,7,8,8],[8,5,8,6],[8,3,8,4]]}
[]
[]
[null,null,null,"Randomizing data overwrites all data in \"Raw Score\" columns, including user entered data. Proceed with caution!!"]
[]
[null,null,null,"A team's top 3 scores (those that contribute to their Overall Score) are indicated using bold text"]
[]
[null,null,"<- Challenge team count",null,"<- Challenge team count",null,"<- Challenge team count",null,"<- Challenge team count",null,"<- Challenge team count"]
[null,10,null,18,null,30,null,27,null,27]
[null,"Galactic Search",null,"AutoNav",null,"Hyperdrive",null,"Interstellar Accuracy",null,"POWERPORT",null,null,null,null,null,null,"Overall Info",null,null,null,null,null,null,null,null,"Leaderboard"]
["Team","Raw Score","Computed Score","Raw Score","Computed Score","Raw Score","Computed Score","Raw Score","Computed Score","Raw Score","Computed Score","C1","C2","C3","C4","C5","Challenges completed","Overall Score","TieBreak1","TieBreak2","TieBreak3","TieBreak4","TieBreak5","Overall score with Tiebreakers",null,"Rank","Team","Overall Score","Score with Tiebreaks","Tiebreaker 1","Tiebreaker 2","Tiebreaker 3","Tiebreaker 4"]
[1,45.799999237060547,{"$f":"VLOOKUP(A11,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":106.95},126.09999847412109,{"$f":"VLOOKUP(A11,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":66.25},146.10000610351563,{"$f":"VLOOKUP(A11,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":86.03},34,{"$f":"VLOOKUP(A11,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":120.27},50,{"$f":"VLOOKUP(A11,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":131.63},{"$f":"C11","v":106.95},{"$f":"E11","v":66.25},{"$f":"G11","v":86.03},{"$f":"I11","v":120.27},{"$f":"K11","v":131.63},{"$f":"COUNTIF(L11:P11,\">1\")","v":5},{"$f":"LARGE(L11:P11,1)+LARGE(L11:P11,2)+LARGE(L11:P11,3)","v":358.84999999999997},{"$f":"LARGE(L11:P11,1)","v":131.63},{"$f":"LARGE(L11:P11,2)","v":120.27},{"$f":"LARGE(L11:P11,4)","v":86.03},{"$f":"LARGE(L11:P11,5)","v":66.25},{"$f":"IF(ISBLANK(A11), 0, RANDBETWEEN(1,99))","v":25},{"$f":"R11+RANK(S11,$S$11:$S$45,1)*0.0001+RANK(T11,$T$11:$T$45,1)*0.000001+RANK(U11,$U$11:$U$45,1)*0.00000001+RANK(V11,$V$11:$V$45,1)*0.0000000001+W11*0.000000000001","v":358.85233131332495},null,1,{"$f":"INDEX($A$11:$A$45,MATCH(AC11,$X$11:$X$45,0))","v":7},{"$f":"INDEX($R$11:$R$45,MATCH(AC11,$X$11:$X$45,0))","v":415.63},{"$f":"LARGE($X$11:$X$45,ROW()-ROW($AC$10))","v":415.63303327011096},{"$f":"IFERROR(INDEX(S$11:S$45,MATCH($AA11,$A$11:$A$45,0)),0)","v":147.96},{"$f":"IFERROR(INDEX(T$11:T$45,MATCH($AA11,$A$11:$A$45,0)),0)","v":136.59},{"$f":"IFERROR(INDEX(U$11:U$45,MATCH($AA11,$A$11:$A$45,0)),0)","v":70.069999999999993},{"$f":"IFERROR(INDEX(V$11:V$45,MATCH($AA11,$A$11:$A$45,0)),0)","v":0}]
[2,38.700000762939453,{"$f":"VLOOKUP(A12,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":117.35},65.5,{"$f":"VLOOKUP(A12,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":120.07},83.699996948242188,{"$f":"VLOOKUP(A12,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":129.61000000000001},32,{"$f":"VLOOKUP(A12,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":114.86},18,{"$f":"VLOOKUP(A12,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":66.33},117.35,120.07,129.61000000000001,114.86,66.33,5,367.03,{"$f":"LARGE(L12:P12,1)","v":129.61000000000001},{"$f":"LARGE(L12:P12,2)","v":120.07},{"$f":"LARGE(L12:P12,4)","v":114.86},{"$f":"LARGE(L12:P12,5)","v":66.33},{"$f":"IF(ISBLANK(A12), 0, RANDBETWEEN(1,99))","v":58},{"$f":"R12+RANK(S12,$S$11:$S$45,1)*0.0001+RANK(T12,$T$11:$T$45,1)*0.000001+RANK(U12,$U$11:$U$45,1)*0.00000001+RANK(V12,$V$11:$V$45,1)*0.0000000001+W12*0.000000000001","v":367.03213035345789},null,2,{"$f":"INDEX($A$11:$A$45,MATCH(AC12,$X$11:$X$45,0))","v":24},{"$f":"INDEX($R$11:$R$45,MATCH(AC12,$X$11:$X$45,0))","v":402.76},402.76313530013005,{"$f":"IFERROR(INDEX(S$11:S$45,MATCH($AA12,$A$11:$A$45,0)),0)","v":150},{"$f":"IFERROR(INDEX(T$11:T$45,MATCH($AA12,$A$11:$A$45,0)),0)","v":145.91999999999999},{"$f":"IFERROR(INDEX(U$11:U$45,MATCH($AA12,$A$11:$A$45,0)),0)","v":78.069999999999993},{"$f":"IFERROR(INDEX(V$11:V$45,MATCH($AA12,$A$11:$A$45,0)),0)","v":0}]
[3,29,{"$f":"VLOOKUP(A13,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":131.55000000000001},0,{"$f":"VLOOKUP(A13,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},197.69999694824219,{"$f":"VLOOKUP(A13,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":50},32,{"$f":"VLOOKUP(A13,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":114.86},13,{"$f":"VLOOKUP(A13,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":56.12},131.55000000000001,0,50,114.86,56.12,4,302.53000000000003,131.55000000000001,114.86,50,0,20,302.53222718012,null,3,5,376.87,376.87293234353001,145.19999999999999,126.33,98.65,90.82]
[4,0,{"$f":"VLOOKUP(A14,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A14,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},54.5,{"$f":"VLOOKUP(A14,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":150},19,{"$f":"VLOOKUP(A14,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":79.73},56,{"$f":"VLOOKUP(A14,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":143.88},0,0,150,79.73,143.88,3,373.61,150,143.88,0,0,84,373.61313401018407,null,4,4,373.61,373.61313401018407,150,143.88,0,0]
[5,46.900001525878906,{"$f":"VLOOKUP(A15,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":105.34},37.200000762939453,{"$f":"VLOOKUP(A15,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":145.19999999999999},88.400001525878906,{"$f":"VLOOKUP(A15,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":126.33},26,{"$f":"VLOOKUP(A15,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":98.65},30,{"$f":"VLOOKUP(A15,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":90.82},105.34,145.19999999999999,126.33,98.65,90.82,5,376.87,145.19999999999999,126.33,98.65,90.82,30,376.87293234353001,null,5,2,367.03,367.03213035345789,129.61000000000001,120.07,114.86,66.33]
[6,0,{"$f":"VLOOKUP(A16,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A16,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},165.69999694824219,{"$f":"VLOOKUP(A16,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":72.349999999999994},41,{"$f":"VLOOKUP(A16,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":139.19},0,{"$f":"VLOOKUP(A16,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,72.349999999999994,139.19,0,2,211.54,139.19,72.349999999999994,0,0,73,211.54270801017299,null,6,18,360.59999999999997,360.60252933015289,135.88999999999999,117.57,96,0]
[7,0,{"$f":"VLOOKUP(A17,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},121.80000305175781,{"$f":"VLOOKUP(A17,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":70.069999999999993},73.699996948242188,{"$f":"VLOOKUP(A17,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":136.59},38,{"$f":"VLOOKUP(A17,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":131.08000000000001},58,{"$f":"VLOOKUP(A17,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":147.96},0,70.069999999999993,136.59,131.08000000000001,147.96,4,415.63,147.96,136.59,70.069999999999993,0,11,415.63303327011096,null,7,1,358.84999999999997,358.85233131332495,131.63,120.27,86.03,66.25]
[8,0,{"$f":"VLOOKUP(A18,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A18,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},156.5,{"$f":"VLOOKUP(A18,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":78.77},23,{"$f":"VLOOKUP(A18,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":90.54},13,{"$f":"VLOOKUP(A18,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":56.12},0,0,78.77,90.54,56.12,3,225.43,90.54,78.77,0,0,15,225.430712010115,null,8,20,353.15,353.15312828013697,150,115.31,72.42,0]
[9,16.399999618530273,{"$f":"VLOOKUP(A19,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":150},79.900001525878906,{"$f":"VLOOKUP(A19,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":107.28},141.39999389648438,{"$f":"VLOOKUP(A19,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":89.32},0,{"$f":"VLOOKUP(A19,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},22,{"$f":"VLOOKUP(A19,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":74.489999999999995},150,107.28,89.32,0,74.489999999999995,4,346.59999999999997,150,107.28,74.489999999999995,0,4,346.60312629010394,null,9,9,346.59999999999997,346.60312629010394,150,107.28,74.489999999999995,0]
[10,0,{"$f":"VLOOKUP(A20,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},140,{"$f":"VLOOKUP(A20,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":53.91},63.299999237060547,{"$f":"VLOOKUP(A20,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":143.85},27,{"$f":"VLOOKUP(A20,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":101.35},10,{"$f":"VLOOKUP(A20,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":50},0,53.91,143.85,101.35,50,4,299.11,143.85,101.35,50,0,77,299.11282218017698,null,10,22,332.89,332.89172324010701,128.38,103.11,62.24,0]
[11,0,{"$f":"VLOOKUP(A21,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A21,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},131.30000305175781,{"$f":"VLOOKUP(A21,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":96.37},28,{"$f":"VLOOKUP(A21,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":104.05},37,{"$f":"VLOOKUP(A21,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":105.1},0,0,96.37,104.05,105.1,3,305.52,105.1,104.05,0,0,52,305.52102401015196,null,11,16,316.91000000000003,316.91311320010703,150,83.67,52.7,0]
[12,86.800003051757813,{"$f":"VLOOKUP(A22,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":50},99.300003051757813,{"$f":"VLOOKUP(A22,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":90.05},161.60000610351563,{"$f":"VLOOKUP(A22,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":75.209999999999994},11,{"$f":"VLOOKUP(A22,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":58.11},22,{"$f":"VLOOKUP(A22,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":74.489999999999995},50,90.05,75.209999999999994,58.11,74.489999999999995,5,239.75,90.05,75.209999999999994,58.11,50,55,239.75060923315502,null,12,28,310.02,310.02182501013596,128.56,107.14,0,0]
[13,0,{"$f":"VLOOKUP(A23,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},118.59999847412109,{"$f":"VLOOKUP(A23,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":72.91},74.199996948242188,{"$f":"VLOOKUP(A23,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":136.24},9,{"$f":"VLOOKUP(A23,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":52.7},28,{"$f":"VLOOKUP(A23,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":86.73},0,72.91,136.24,52.7,86.73,4,295.88,136.24,86.73,52.7,0,34,295.88261520013396,null,13,23,305.60000000000002,305.60151932019909,123.04,92.86,87.84,0]
[14,0,{"$f":"VLOOKUP(A24,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A24,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},138.30000305175781,{"$f":"VLOOKUP(A24,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":91.48},9,{"$f":"VLOOKUP(A24,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":52.7},47,{"$f":"VLOOKUP(A24,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":125.51},0,0,91.48,52.7,125.51,3,269.69,125.51,91.48,0,0,54,269.691618010154,null,14,11,305.52,305.52102401015196,105.1,104.05,0,0]
[15,0,{"$f":"VLOOKUP(A25,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},55,{"$f":"VLOOKUP(A25,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":129.4},196.80000305175781,{"$f":"VLOOKUP(A25,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":50.63},11,{"$f":"VLOOKUP(A25,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":58.11},0,{"$f":"VLOOKUP(A25,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,129.4,50.63,58.11,0,3,238.14,129.4,58.11,0,0,78,238.14190601017799,null,15,3,302.53000000000003,302.53222718012,131.55000000000001,114.86,50,0]
[16,61.700000762939453,{"$f":"VLOOKUP(A26,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":83.67},0,{"$f":"VLOOKUP(A26,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},150.10000610351563,{"$f":"VLOOKUP(A26,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":83.24},9,{"$f":"VLOOKUP(A26,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":52.7},59,{"$f":"VLOOKUP(A26,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":150},83.67,0,83.24,52.7,150,4,316.91000000000003,150,83.67,52.7,0,7,316.91311320010703,null,16,10,299.11,299.11282218017698,143.85,101.35,50,0]
[17,74.400001525878906,{"$f":"VLOOKUP(A27,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":65.08},127.80000305175781,{"$f":"VLOOKUP(A27,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":64.739999999999995},143.30000305175781,{"$f":"VLOOKUP(A27,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":87.99},8,{"$f":"VLOOKUP(A27,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":50},37,{"$f":"VLOOKUP(A27,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":105.1},65.08,64.739999999999995,87.99,50,105.1,5,258.16999999999996,105.1,87.99,64.739999999999995,50,22,258.17101626312194,null,17,13,295.88,295.88261520013396,136.24,86.73,52.7,0]
[18,0,{"$f":"VLOOKUP(A28,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},92.599998474121094,{"$f":"VLOOKUP(A28,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":96},74.699996948242188,{"$f":"VLOOKUP(A28,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":135.88999999999999},33,{"$f":"VLOOKUP(A28,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":117.57},38,{"$f":"VLOOKUP(A28,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":107.14},0,96,135.88999999999999,117.57,107.14,4,360.59999999999997,135.88999999999999,117.57,96,0,53,360.60252933015289,null,18,19,293.53000000000003,293.53202001014802,129.59,98.65,0,0]
[19,0,{"$f":"VLOOKUP(A29,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A29,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},175.80000305175781,{"$f":"VLOOKUP(A29,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":65.290000000000006},26,{"$f":"VLOOKUP(A29,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":98.65},49,{"$f":"VLOOKUP(A29,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":129.59},0,0,65.290000000000006,98.65,129.59,3,293.53000000000003,129.59,98.65,0,0,48,293.53202001014802,null,19,27,283.42,283.42242101012005,132.4,101.02,0,0]
[20,0,{"$f":"VLOOKUP(A30,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},31.799999237060547,{"$f":"VLOOKUP(A30,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":150},165.60000610351563,{"$f":"VLOOKUP(A30,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":72.42},22,{"$f":"VLOOKUP(A30,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":87.84},42,{"$f":"VLOOKUP(A30,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":115.31},0,150,72.42,87.84,115.31,4,353.15,150,115.31,72.42,0,37,353.15312828013697,null,20,26,278.73,278.73141701012702,121.86,90.54,0,0]
[21,52.900001525878906,{"$f":"VLOOKUP(A31,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":96.56},125.80000305175781,{"$f":"VLOOKUP(A31,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":66.52},159,{"$f":"VLOOKUP(A31,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":77.03},0,{"$f":"VLOOKUP(A31,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A31,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},96.56,66.52,77.03,0,0,3,240.11,96.56,77.03,0,0,96,240.11081001019602,null,21,30,270.26,270.26121422011596,109.46,86.31,55.17,0]
[22,0,{"$f":"VLOOKUP(A32,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},84.599998474121094,{"$f":"VLOOKUP(A32,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":103.11},124.09999847412109,{"$f":"VLOOKUP(A32,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":101.4},37,{"$f":"VLOOKUP(A32,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":128.38},16,{"$f":"VLOOKUP(A32,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":62.24},0,103.11,101.4,128.38,62.24,4,332.89,128.38,103.11,62.24,0,7,332.89172324010701,null,22,14,269.69,269.691618010154,125.51,91.48,0,0]
[23,0,{"$f":"VLOOKUP(A33,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},99.699996948242188,{"$f":"VLOOKUP(A33,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":89.7},93.099998474121094,{"$f":"VLOOKUP(A33,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":123.04},22,{"$f":"VLOOKUP(A33,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":87.84},31,{"$f":"VLOOKUP(A33,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":92.86},0,89.7,123.04,87.84,92.86,4,305.60000000000002,123.04,92.86,87.84,0,99,305.60151932019909,null,23,17,258.16999999999996,258.17101626312194,105.1,87.99,64.739999999999995,50]
[24,0,{"$f":"VLOOKUP(A34,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},80.400001525878906,{"$f":"VLOOKUP(A34,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":106.84},157.5,{"$f":"VLOOKUP(A34,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":78.069999999999993},45,{"$f":"VLOOKUP(A34,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":150},57,{"$f":"VLOOKUP(A34,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":145.91999999999999},0,106.84,78.069999999999993,150,145.91999999999999,4,402.76,150,145.91999999999999,78.069999999999993,0,30,402.76313530013005,null,24,29,252.20999999999998,252.21130725016397,114.48,70.41,63.51,0]
[25,0,{"$f":"VLOOKUP(A35,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A35,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},157.10000610351563,{"$f":"VLOOKUP(A35,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":78.349999999999994},27,{"$f":"VLOOKUP(A35,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":101.35},13,{"$f":"VLOOKUP(A35,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":56.12},0,0,78.349999999999994,101.35,56.12,3,235.82,101.35,78.349999999999994,0,0,73,235.82091101017298,null,25,21,240.11,240.11081001019602,96.56,77.03,0,0]
[26,0,{"$f":"VLOOKUP(A36,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A36,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},94.800003051757813,{"$f":"VLOOKUP(A36,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":121.86},23,{"$f":"VLOOKUP(A36,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":90.54},18,{"$f":"VLOOKUP(A36,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":66.33},0,0,121.86,90.54,66.33,3,278.73,121.86,90.54,0,0,27,278.73141701012702,null,26,12,239.75,239.75060923315502,90.05,75.209999999999994,58.11,50]
[27,0,{"$f":"VLOOKUP(A37,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},144.39999389648438,{"$f":"VLOOKUP(A37,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":50},79.699996948242188,{"$f":"VLOOKUP(A37,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":132.4},0,{"$f":"VLOOKUP(A37,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},35,{"$f":"VLOOKUP(A37,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":101.02},0,50,132.4,0,101.02,3,283.42,132.4,101.02,0,0,20,283.42242101012005,null,27,15,238.14,238.14190601017799,129.4,58.11,0,0]
[28,0,{"$f":"VLOOKUP(A38,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A38,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},85.199996948242188,{"$f":"VLOOKUP(A38,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":128.56},17,{"$f":"VLOOKUP(A38,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":74.319999999999993},38,{"$f":"VLOOKUP(A38,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":107.14},0,0,128.56,74.319999999999993,107.14,3,310.02,128.56,107.14,0,0,36,310.02182501013596,null,28,25,235.82,235.82091101017298,101.35,78.349999999999994,0,0]
[29,0,{"$f":"VLOOKUP(A39,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},71.800003051757813,{"$f":"VLOOKUP(A39,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":114.48},172.89999389648438,{"$f":"VLOOKUP(A39,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":67.319999999999993},13,{"$f":"VLOOKUP(A39,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":63.51},20,{"$f":"VLOOKUP(A39,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":70.41},0,114.48,67.319999999999993,63.51,70.41,4,252.20999999999998,114.48,70.41,63.51,0,64,252.21130725016397,null,29,8,225.43,225.430712010115,90.54,78.77,0,0]
[30,59.900001525878906,{"$f":"VLOOKUP(A40,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":86.31},0,{"$f":"VLOOKUP(A40,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},190.30000305175781,{"$f":"VLOOKUP(A40,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":55.17},30,{"$f":"VLOOKUP(A40,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":109.46},22,{"$f":"VLOOKUP(A40,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":74.489999999999995},86.31,0,55.17,109.46,74.489999999999995,4,270.26,109.46,86.31,55.17,0,16,270.26121422011596,null,30,6,211.54,211.54270801017299,139.19,72.349999999999994,0,0]
[null,0,{"$f":"VLOOKUP(A41,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A41,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A41,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A41,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A41,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1.0101009999999999E-4,null,31,0,0,1.0101009999999999E-4,0,0,0,0]
[null,0,{"$f":"VLOOKUP(A42,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A42,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A42,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A42,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A42,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1.0101009999999999E-4,null,32,0,0,1.0101009999999999E-4,0,0,0,0]
[null,0,{"$f":"VLOOKUP(A43,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A43,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A43,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A43,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A43,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1.0101009999999999E-4,null,33,0,0,1.0101009999999999E-4,0,0,0,0]
[null,0,{"$f":"VLOOKUP(A44,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A44,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A44,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A44,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A44,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1.0101009999999999E-4,null,34,0,0,1.0101009999999999E-4,0,0,0,0]
[null,0,{"$f":"VLOOKUP(A45,GalacticSearch!B$14:'GalacticSearch'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A45,AutoNav!B$14:'AutoNav'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A45,Hyperdrive!B$14:'Hyperdrive'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A45,InterstellarAccuracy!B$14:'InterstellarAccuracy'!E$48,4, FALSE)","v":0},0,{"$f":"VLOOKUP(A45,POWERPORT!B$14:'POWERPORT'!E$48,4, FALSE)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,1.0101009999999999E-4,null,35,0,0,1.0101009999999999E-4,0,0,0,0]

{"sheet":"GalacticSearch","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,2,2],[7,5,7,6],[1,5,1,6]]}
[]
[null,"Reference Information (N is driven by value on Main Sheet)",null,null,null,"Outlier Rejection"]
[null,null,null,null,null,"Q1",{"$f":"IF(C4*0.25=INT(C4*0.25),(OFFSET(G13,C4*0.25,0)+OFFSET(G13,C4*0.25+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.25),0))","v":38.700000762939453}]
[null,"N:",{"$f":"COUNTIF(C14:C48, \"<>0\")","v":10},null,null,"Q3",{"$f":"IF(C4*0.75=INT(C4*0.75),(OFFSET(G13,C4*0.75,0)+OFFSET(G13,C4*0.75+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.75),0))","v":61.700000762939453}]
[null,"Score type:","1 decimal",null,null,"RLower",{"$f":"G3-1*(G4-G3)","v":15.700000762939453},"=Q1-1*(Q3-Q1)"]
[null,"Max or min to win?","Min",null,null,"RUpper",{"$f":"G4+1*(G4-G3)","v":84.700000762939453},"=Q3+1*(Q3-Q1)"]
[]
[null,"Minimum and Maximum score",null,null,null,"Bounded Score Information"]
[null,"Max score (CMax)",150,null,null,"BLast",{"$f":"MAX(OFFSET($D$14,0,0,35))","v":84.700000762939453}]
[null,"Min score (CMin)",{"$f":"MAX(C9-20*(C4-1),50)","v":50},"=Max(Cmax-20*(N-1), 50)",null,"BFirst",{"$f":"MIN(IF(OFFSET($D$14,0,0,35)=0,\"\",OFFSET($D$14,0,0,35)))","v":16.399999618530273}]
[null,null,null,null,"To re-sort after data has been updated, click the arrow next to"]
[null,"Computed Score = ABS((B-Blast)/(Bfirst-Blast)) * (Cmax - Cmin) + Cmin",null,null,"Computed Score and select \"Largest to Smallest\""]
[null,"Team #","Raw Score (R)","Bounded Score (B)","Computed Score (C)",null,"Sorted Raw Scores (for Quartile calcs)"]
[null,{"$f":"Main!A11","v":1},{"$f":"Main!B11","v":45.799999237060547},{"$f":"IF(C14<>0,IF(C14<$G$5,$G$5,IF(C14>$G$6,$G$6,C14)),0)","v":45.799999237060547},{"$f":"IF(D14>0,IF(($G$9-$G$10)<>0,ROUND((D14-$G$9)/($G$10-$G$9)*($C$9-$C$10)+$C$10,2),150),0)","v":106.95},null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":16.399999618530273}]
[null,{"$f":"Main!A41","v":0},{"$f":"Main!B41","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":29}]
[null,{"$f":"Main!A30","v":20},{"$f":"Main!B30","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":38.700000762939453}]
[null,{"$f":"Main!A43","v":0},{"$f":"Main!B43","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":45.799999237060547}]
[null,{"$f":"Main!A12","v":2},{"$f":"Main!B12","v":38.700000762939453},38.700000762939453,117.35,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":46.900001525878906}]
[null,{"$f":"Main!A31","v":21},{"$f":"Main!B31","v":52.900001525878906},52.900001525878906,96.56,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":52.900001525878906}]
[null,{"$f":"Main!A35","v":25},{"$f":"Main!B35","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":59.900001525878906}]
[null,{"$f":"Main!A20","v":10},{"$f":"Main!B20","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":61.700000762939453}]
[null,{"$f":"Main!A28","v":18},{"$f":"Main!B28","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":74.400001525878906}]
[null,{"$f":"Main!A21","v":11},{"$f":"Main!B21","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":86.800003051757813}]
[null,{"$f":"Main!A40","v":30},{"$f":"Main!B40","v":59.900001525878906},59.900001525878906,86.31,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A37","v":27},{"$f":"Main!B37","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A23","v":13},{"$f":"Main!B23","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A27","v":17},{"$f":"Main!B27","v":74.400001525878906},74.400001525878906,65.08,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A13","v":3},{"$f":"Main!B13","v":29},29,131.55000000000001,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A16","v":6},{"$f":"Main!B16","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A15","v":5},{"$f":"Main!B15","v":46.900001525878906},46.900001525878906,105.34,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A19","v":9},{"$f":"Main!B19","v":16.399999618530273},16.399999618530273,150,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A42","v":0},{"$f":"Main!B42","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A26","v":16},{"$f":"Main!B26","v":61.700000762939453},61.700000762939453,83.67,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A24","v":14},{"$f":"Main!B24","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A14","v":4},{"$f":"Main!B14","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A22","v":12},{"$f":"Main!B22","v":86.800003051757813},84.700000762939453,50,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A18","v":8},{"$f":"Main!B18","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A17","v":7},{"$f":"Main!B17","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A25","v":15},{"$f":"Main!B25","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A44","v":0},{"$f":"Main!B44","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A45","v":0},{"$f":"Main!B45","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A29","v":19},{"$f":"Main!B29","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A32","v":22},{"$f":"Main!B32","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A33","v":23},{"$f":"Main!B33","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A34","v":24},{"$f":"Main!B34","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A36","v":26},{"$f":"Main!B36","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A38","v":28},{"$f":"Main!B38","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A39","v":29},{"$f":"Main!B39","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]

{"sheet":"AutoNav","index":3,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,5,1,6],[7,5,7,6]]}
[]
[null,"Reference Information (N is driven by value on Main Sheet)",null,null,null,"Outlier Rejection"]
[null,null,null,null,null,"Q1",{"$f":"IF(C4*0.25=INT(C4*0.25),(OFFSET(G13,C4*0.25,0)+OFFSET(G13,C4*0.25+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.25),0))","v":71.800003051757813}]
[null,"N:",{"$f":"COUNTIF(C14:C48, \"<>0\")","v":18},null,null,"Q3",{"$f":"IF(C4*0.75=INT(C4*0.75),(OFFSET(G13,C4*0.75,0)+OFFSET(G13,C4*0.75+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.75),0))","v":125.80000305175781}]
[null,"Score type:","1 decimal",null,null,"RLower",{"$f":"G3-1*(G4-G3)","v":17.800003051757813},"=Q1-1*(Q3-Q1)"]
[null,"Max or min to win?","Min",null,null,"RUpper",{"$f":"G4+1*(G4-G3)","v":179.80000305175781},"=Q3+1*(Q3-Q1)"]
[]
[null,"Minimum and Maximum score",null,null,null,"Bounded Score Information"]
[null,"Max score (CMax)",150,null,null,"BLast",{"$f":"MAX(OFFSET($D$14,0,0,35))","v":144.39999389648438}]
[null,"Min score (CMin)",{"$f":"MAX(C9-20*(C4-1),50)","v":50},"=Max(Cmax-20*(N-1), 50)",null,"BFirst",{"$f":"MIN(IF(OFFSET($D$14,0,0,35)=0,\"\",OFFSET($D$14,0,0,35)))","v":31.799999237060547}]
[null,null,null,null,"To re-sort after data has been updated, click the arrow next to"]
[null,"Computed Score = ABS((B-Blast)/(Bfirst-Blast)) * (Cmax - Cmin) + Cmin",null,null,"Computed Score and select \"Largest to Smallest\""]
[null,"Team #","Raw Score (R)","Bounded Score (B)","Computed Score (C)",null,"Sorted Raw Scores (for Quartile calcs)"]
[null,{"$f":"Main!A11","v":1},{"$f":"Main!D11","v":126.09999847412109},{"$f":"IF(C14<>0,IF(C14<$G$5,$G$5,IF(C14>$G$6,$G$6,C14)),0)","v":126.09999847412109},{"$f":"IF(D14>0,IF(($G$10-$G$9)<>0,ROUND((D14-$G$9)/($G$10-$G$9)*($C$9-$C$10)+$C$10,2),150),0)","v":66.25},null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":31.799999237060547}]
[null,{"$f":"Main!A34","v":24},{"$f":"Main!D34","v":80.400001525878906},80.400001525878906,106.84,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":37.200000762939453}]
[null,{"$f":"Main!A30","v":20},{"$f":"Main!D30","v":31.799999237060547},31.799999237060547,150,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":55}]
[null,{"$f":"Main!A29","v":19},{"$f":"Main!D29","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":65.5}]
[null,{"$f":"Main!A44","v":0},{"$f":"Main!D44","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":71.800003051757813}]
[null,{"$f":"Main!A33","v":23},{"$f":"Main!D33","v":99.699996948242188},99.699996948242188,89.7,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":79.900001525878906}]
[null,{"$f":"Main!A39","v":29},{"$f":"Main!D39","v":71.800003051757813},71.800003051757813,114.48,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":80.400001525878906}]
[null,{"$f":"Main!A18","v":8},{"$f":"Main!D18","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":84.599998474121094}]
[null,{"$f":"Main!A14","v":4},{"$f":"Main!D14","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":92.599998474121094}]
[null,{"$f":"Main!A20","v":10},{"$f":"Main!D20","v":140},140,53.91,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":99.300003051757813}]
[null,{"$f":"Main!A45","v":0},{"$f":"Main!D45","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":99.699996948242188}]
[null,{"$f":"Main!A23","v":13},{"$f":"Main!D23","v":118.59999847412109},118.59999847412109,72.91,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":118.59999847412109}]
[null,{"$f":"Main!A43","v":0},{"$f":"Main!D43","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":121.80000305175781}]
[null,{"$f":"Main!A13","v":3},{"$f":"Main!D13","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":125.80000305175781}]
[null,{"$f":"Main!A42","v":0},{"$f":"Main!D42","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":126.09999847412109}]
[null,{"$f":"Main!A31","v":21},{"$f":"Main!D31","v":125.80000305175781},125.80000305175781,66.52,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":127.80000305175781}]
[null,{"$f":"Main!A41","v":0},{"$f":"Main!D41","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":140}]
[null,{"$f":"Main!A32","v":22},{"$f":"Main!D32","v":84.599998474121094},84.599998474121094,103.11,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":144.39999389648438}]
[null,{"$f":"Main!A25","v":15},{"$f":"Main!D25","v":55},55,129.4,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A22","v":12},{"$f":"Main!D22","v":99.300003051757813},99.300003051757813,90.05,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A12","v":2},{"$f":"Main!D12","v":65.5},65.5,120.07,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A19","v":9},{"$f":"Main!D19","v":79.900001525878906},79.900001525878906,107.28,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A16","v":6},{"$f":"Main!D16","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A21","v":11},{"$f":"Main!D21","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A17","v":7},{"$f":"Main!D17","v":121.80000305175781},121.80000305175781,70.069999999999993,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A15","v":5},{"$f":"Main!D15","v":37.200000762939453},37.200000762939453,145.19999999999999,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A24","v":14},{"$f":"Main!D24","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A26","v":16},{"$f":"Main!D26","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A27","v":17},{"$f":"Main!D27","v":127.80000305175781},127.80000305175781,64.739999999999995,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A28","v":18},{"$f":"Main!D28","v":92.599998474121094},92.599998474121094,96,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A35","v":25},{"$f":"Main!D35","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A36","v":26},{"$f":"Main!D36","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A37","v":27},{"$f":"Main!D37","v":144.39999389648438},144.39999389648438,50,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A38","v":28},{"$f":"Main!D38","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A40","v":30},{"$f":"Main!D40","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]

{"sheet":"Hyperdrive","index":4,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,5,1,6],[7,5,7,6]]}
[]
[null,"Reference Information (N is driven by value on Main Sheet)",null,null,null,"Outlier Rejection"]
[null,null,null,null,null,"Q1",{"$f":"IF(C4*0.25=INT(C4*0.25),(OFFSET(G13,C4*0.25,0)+OFFSET(G13,C4*0.25+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.25),0))","v":85.199996948242188}]
[null,"N:",{"$f":"COUNTIF(C14:C48, \"<>0\")","v":30},null,null,"Q3",{"$f":"IF(C4*0.75=INT(C4*0.75),(OFFSET(G13,C4*0.75,0)+OFFSET(G13,C4*0.75+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.75),0))","v":161.60000610351563}]
[null,"Score type:","1 decimal",null,null,"RLower",{"$f":"G3-1*(G4-G3)","v":8.79998779296875},"=Q1-1*(Q3-Q1)"]
[null,"Max or min to win?","Min",null,null,"RUpper",{"$f":"G4+1*(G4-G3)","v":238.00001525878906},"=Q3+1*(Q3-Q1)"]
[]
[null,"Minimum and Maximum score",null,null,null,"Bounded Score Information"]
[null,"Max score (CMax)",150,null,null,"BLast",{"$f":"MAX(OFFSET($D$14,0,0,35))","v":197.69999694824219}]
[null,"Min score (CMin)",{"$f":"MAX(C9-20*(C4-1),50)","v":50},"=Max(Cmax-20*(N-1), 50)",null,"BFirst",{"$f":"MIN(IF(OFFSET($D$14,0,0,35)=0,\"\",OFFSET($D$14,0,0,35)))","v":54.5}]
[null,null,null,null,"To re-sort after data has been updated, click the arrow next to"]
[null,"Computed Score = ABS((B-Blast)/(Bfirst-Blast)) * (Cmax - Cmin) + Cmin",null,null,"Computed Score and select \"Largest to Smallest\""]
[null,"Team #","Raw Score (R)","Bounded Score (B)","Computed Score (C)",null,"Sorted Raw Scores (for Quartile calcs)"]
[null,{"$f":"Main!A15","v":5},{"$f":"Main!F15","v":88.400001525878906},{"$f":"IF(C14<>0,IF(C14<$G$5,$G$5,IF(C14>$G$6,$G$6,C14)),0)","v":88.400001525878906},{"$f":"IF(D14>0,IF(($G$10-$G$9)<>0,ROUND((D14-$G$9)/($G$10-$G$9)*($C$9-$C$10)+$C$10,2),150),0)","v":126.33},null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":54.5}]
[null,{"$f":"Main!A43","v":0},{"$f":"Main!F43","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":63.299999237060547}]
[null,{"$f":"Main!A16","v":6},{"$f":"Main!F16","v":165.69999694824219},165.69999694824219,72.349999999999994,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":73.699996948242188}]
[null,{"$f":"Main!A29","v":19},{"$f":"Main!F29","v":175.80000305175781},175.80000305175781,65.290000000000006,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":74.199996948242188}]
[null,{"$f":"Main!A24","v":14},{"$f":"Main!F24","v":138.30000305175781},138.30000305175781,91.48,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":74.699996948242188}]
[null,{"$f":"Main!A40","v":30},{"$f":"Main!F40","v":190.30000305175781},190.30000305175781,55.17,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":79.699996948242188}]
[null,{"$f":"Main!A30","v":20},{"$f":"Main!F30","v":165.60000610351563},165.60000610351563,72.42,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":83.699996948242188}]
[null,{"$f":"Main!A39","v":29},{"$f":"Main!F39","v":172.89999389648438},172.89999389648438,67.319999999999993,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":85.199996948242188}]
[null,{"$f":"Main!A17","v":7},{"$f":"Main!F17","v":73.699996948242188},73.699996948242188,136.59,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":88.400001525878906}]
[null,{"$f":"Main!A23","v":13},{"$f":"Main!F23","v":74.199996948242188},74.199996948242188,136.24,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":93.099998474121094}]
[null,{"$f":"Main!A37","v":27},{"$f":"Main!F37","v":79.699996948242188},79.699996948242188,132.4,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":94.800003051757813}]
[null,{"$f":"Main!A18","v":8},{"$f":"Main!F18","v":156.5},156.5,78.77,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":124.09999847412109}]
[null,{"$f":"Main!A34","v":24},{"$f":"Main!F34","v":157.5},157.5,78.069999999999993,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":131.30000305175781}]
[null,{"$f":"Main!A20","v":10},{"$f":"Main!F20","v":63.299999237060547},63.299999237060547,143.85,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":138.30000305175781}]
[null,{"$f":"Main!A36","v":26},{"$f":"Main!F36","v":94.800003051757813},94.800003051757813,121.86,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":141.39999389648438}]
[null,{"$f":"Main!A42","v":0},{"$f":"Main!F42","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":143.30000305175781}]
[null,{"$f":"Main!A35","v":25},{"$f":"Main!F35","v":157.10000610351563},157.10000610351563,78.349999999999994,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":146.10000610351563}]
[null,{"$f":"Main!A28","v":18},{"$f":"Main!F28","v":74.699996948242188},74.699996948242188,135.88999999999999,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":150.10000610351563}]
[null,{"$f":"Main!A44","v":0},{"$f":"Main!F44","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":156.5}]
[null,{"$f":"Main!A41","v":0},{"$f":"Main!F41","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":157.10000610351563}]
[null,{"$f":"Main!A21","v":11},{"$f":"Main!F21","v":131.30000305175781},131.30000305175781,96.37,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":157.5}]
[null,{"$f":"Main!A12","v":2},{"$f":"Main!F12","v":83.699996948242188},83.699996948242188,129.61000000000001,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":159}]
[null,{"$f":"Main!A14","v":4},{"$f":"Main!F14","v":54.5},54.5,150,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":161.60000610351563}]
[null,{"$f":"Main!A38","v":28},{"$f":"Main!F38","v":85.199996948242188},85.199996948242188,128.56,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":165.60000610351563}]
[null,{"$f":"Main!A26","v":16},{"$f":"Main!F26","v":150.10000610351563},150.10000610351563,83.24,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":165.69999694824219}]
[null,{"$f":"Main!A27","v":17},{"$f":"Main!F27","v":143.30000305175781},143.30000305175781,87.99,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":172.89999389648438}]
[null,{"$f":"Main!A13","v":3},{"$f":"Main!F13","v":197.69999694824219},197.69999694824219,50,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":175.80000305175781}]
[null,{"$f":"Main!A33","v":23},{"$f":"Main!F33","v":93.099998474121094},93.099998474121094,123.04,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":190.30000305175781}]
[null,{"$f":"Main!A22","v":12},{"$f":"Main!F22","v":161.60000610351563},161.60000610351563,75.209999999999994,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":196.80000305175781}]
[null,{"$f":"Main!A32","v":22},{"$f":"Main!F32","v":124.09999847412109},124.09999847412109,101.4,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":197.69999694824219}]
[null,{"$f":"Main!A11","v":1},{"$f":"Main!F11","v":146.10000610351563},146.10000610351563,86.03,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A19","v":9},{"$f":"Main!F19","v":141.39999389648438},141.39999389648438,89.32,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A25","v":15},{"$f":"Main!F25","v":196.80000305175781},196.80000305175781,50.63,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A31","v":21},{"$f":"Main!F31","v":159},159,77.03,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A45","v":0},{"$f":"Main!F45","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]

{"sheet":"InterstellarAccuracy","index":5,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,5,1,6],[7,5,7,6]]}
[]
[null,"Reference Information (N is driven by value on Main Sheet)",null,null,null,"Outlier Rejection"]
[null,null,null,null,null,"Q1",{"$f":"IF(C4*0.25=INT(C4*0.25),(OFFSET(G13,C4*0.25,0)+OFFSET(G13,C4*0.25+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.25),0))","v":13}]
[null,"N:",{"$f":"COUNTIF(C14:C48, \"<>0\")","v":27},null,null,"Q3",{"$f":"IF(C4*0.75=INT(C4*0.75),(OFFSET(G13,C4*0.75,0)+OFFSET(G13,C4*0.75+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.75),0))","v":32}]
[null,"Score type:","1 decimal",null,null,"RLower",{"$f":"G3-1*(G4-G3)","v":-6},"=Q1-1*(Q3-Q1)"]
[null,"Max or min to win?","Max",null,null,"RUpper",{"$f":"G4+1*(G4-G3)","v":51},"=Q3+1*(Q3-Q1)"]
[]
[null,"Minimum and Maximum score",null,null,null,"Bounded Score Information"]
[null,"Max score (CMax)",150,null,null,"BLast",{"$f":"MIN(IF(OFFSET($D$14,0,0,35)=0,\"\",OFFSET($D$14,0,0,35)))","v":8}]
[null,"Min score (CMin)",{"$f":"MAX(C9-20*(C4-1),50)","v":50},"=Max(Cmax-20*(N-1), 50)",null,"BFirst",{"$f":"MAX(OFFSET($D$14,0,0,35))","v":45}]
[null,null,null,null,"To re-sort after data has been updated, click the arrow next to"]
[null,"Computed Score = ABS((B-Blast)/(Bfirst-Blast)) * (Cmax - Cmin) + Cmin",null,null,"Computed Score and select \"Largest to Smallest\""]
[null,"Team #","Raw Score (R)","Bounded Score (B)","Computed Score (C)",null,"Sorted Raw Scores (for Quartile calcs)"]
[null,{"$f":"Main!A35","v":25},{"$f":"Main!H35","v":27},{"$f":"IF(C14<>0,IF(C14<$G$5,$G$5,IF(C14>$G$6,$G$6,C14)),0)","v":27},{"$f":"IF(D14>0,IF(($G$10-$G$9)<>0,ROUND((D14-$G$9)/($G$10-$G$9)*($C$9-$C$10)+$C$10,2),150),0)","v":101.35},null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":8}]
[null,{"$f":"Main!A16","v":6},{"$f":"Main!H16","v":41},41,139.19,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":9}]
[null,{"$f":"Main!A13","v":3},{"$f":"Main!H13","v":32},32,114.86,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":9}]
[null,{"$f":"Main!A31","v":21},{"$f":"Main!H31","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":9}]
[null,{"$f":"Main!A23","v":13},{"$f":"Main!H23","v":9},9,52.7,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":11}]
[null,{"$f":"Main!A21","v":11},{"$f":"Main!H21","v":28},28,104.05,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":11}]
[null,{"$f":"Main!A32","v":22},{"$f":"Main!H32","v":37},37,128.38,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":13}]
[null,{"$f":"Main!A20","v":10},{"$f":"Main!H20","v":27},27,101.35,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":17}]
[null,{"$f":"Main!A41","v":0},{"$f":"Main!H41","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":19}]
[null,{"$f":"Main!A17","v":7},{"$f":"Main!H17","v":38},38,131.08000000000001,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":22}]
[null,{"$f":"Main!A33","v":23},{"$f":"Main!H33","v":22},22,87.84,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":22}]
[null,{"$f":"Main!A37","v":27},{"$f":"Main!H37","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":23}]
[null,{"$f":"Main!A43","v":0},{"$f":"Main!H43","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":23}]
[null,{"$f":"Main!A39","v":29},{"$f":"Main!H39","v":13},13,63.51,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":26}]
[null,{"$f":"Main!A15","v":5},{"$f":"Main!H15","v":26},26,98.65,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":26}]
[null,{"$f":"Main!A28","v":18},{"$f":"Main!H28","v":33},33,117.57,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":27}]
[null,{"$f":"Main!A24","v":14},{"$f":"Main!H24","v":9},9,52.7,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":27}]
[null,{"$f":"Main!A45","v":0},{"$f":"Main!H45","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":28}]
[null,{"$f":"Main!A14","v":4},{"$f":"Main!H14","v":19},19,79.73,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":30}]
[null,{"$f":"Main!A30","v":20},{"$f":"Main!H30","v":22},22,87.84,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":32}]
[null,{"$f":"Main!A22","v":12},{"$f":"Main!H22","v":11},11,58.11,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":32}]
[null,{"$f":"Main!A19","v":9},{"$f":"Main!H19","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":33}]
[null,{"$f":"Main!A42","v":0},{"$f":"Main!H42","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":34}]
[null,{"$f":"Main!A29","v":19},{"$f":"Main!H29","v":26},26,98.65,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":37}]
[null,{"$f":"Main!A38","v":28},{"$f":"Main!H38","v":17},17,74.319999999999993,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":38}]
[null,{"$f":"Main!A27","v":17},{"$f":"Main!H27","v":8},8,50,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":41}]
[null,{"$f":"Main!A18","v":8},{"$f":"Main!H18","v":23},23,90.54,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":45}]
[null,{"$f":"Main!A11","v":1},{"$f":"Main!H11","v":34},34,120.27,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A44","v":0},{"$f":"Main!H44","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A36","v":26},{"$f":"Main!H36","v":23},23,90.54,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A40","v":30},{"$f":"Main!H40","v":30},30,109.46,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A34","v":24},{"$f":"Main!H34","v":45},45,150,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A26","v":16},{"$f":"Main!H26","v":9},9,52.7,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A25","v":15},{"$f":"Main!H25","v":11},11,58.11,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A12","v":2},{"$f":"Main!H12","v":32},32,114.86,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]

{"sheet":"POWERPORT","index":6,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,5,1,6],[7,5,7,6]]}
[]
[null,"Reference Information (N is driven by value on Main Sheet)",null,null,null,"Outlier Rejection"]
[null,null,null,null,null,"Q1",{"$f":"IF(C4*0.25=INT(C4*0.25),(OFFSET(G13,C4*0.25,0)+OFFSET(G13,C4*0.25+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.25),0))","v":18}]
[null,"N:",{"$f":"COUNTIF(C14:C48, \"<>0\")","v":27},null,null,"Q3",{"$f":"IF(C4*0.75=INT(C4*0.75),(OFFSET(G13,C4*0.75,0)+OFFSET(G13,C4*0.75+1,0))/2,OFFSET(G13,_xlfn.CEILING.MATH(C4*0.75),0))","v":47}]
[null,"Score type:","1 decimal",null,null,"RLower",{"$f":"G3-1*(G4-G3)","v":-11},"=Q1-1*(Q3-Q1)"]
[null,"Max or min to win?","Max",null,null,"RUpper",{"$f":"G4+1*(G4-G3)","v":76},"=Q3+1*(Q3-Q1)"]
[]
[null,"Minimum and Maximum score",null,null,null,"Bounded Score Information"]
[null,"Max score (CMax)",150,null,null,"BLast",{"$f":"MIN(IF(OFFSET($D$14,0,0,35)=0,\"\",OFFSET($D$14,0,0,35)))","v":10}]
[null,"Min score (CMin)",{"$f":"MAX(C9-20*(C4-1),50)","v":50},"=Max(Cmax-20*(N-1), 50)",null,"BFirst",{"$f":"MAX(OFFSET($D$14,0,0,35))","v":59}]
[null,null,null,null,"To re-sort after data has been updated, click the arrow next to"]
[null,"Computed Score = ABS((B-Blast)/(Bfirst-Blast)) * (Cmax - Cmin) + Cmin",null,null,"Computed Score and select \"Largest to Smallest\""]
[null,"Team #","Raw Score (R)","Bounded Score (B)","Computed Score (C)",null,"Sorted Raw Scores (for Quartile calcs)"]
[null,{"$f":"Main!A20","v":10},{"$f":"Main!J20","v":10},{"$f":"IF(C14<>0,IF(C14<$G$5,$G$5,IF(C14>$G$6,$G$6,C14)),0)","v":10},{"$f":"IF(D14>0,IF(($G$10-$G$9)<>0,ROUND((D14-$G$9)/($G$10-$G$9)*($C$9-$C$10)+$C$10,2),150),0)","v":50},null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":10}]
[null,{"$f":"Main!A27","v":17},{"$f":"Main!J27","v":37},37,105.1,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":13}]
[null,{"$f":"Main!A17","v":7},{"$f":"Main!J17","v":58},58,147.96,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":13}]
[null,{"$f":"Main!A30","v":20},{"$f":"Main!J30","v":42},42,115.31,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":13}]
[null,{"$f":"Main!A21","v":11},{"$f":"Main!J21","v":37},37,105.1,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":16}]
[null,{"$f":"Main!A26","v":16},{"$f":"Main!J26","v":59},59,150,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":18}]
[null,{"$f":"Main!A42","v":0},{"$f":"Main!J42","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":18}]
[null,{"$f":"Main!A38","v":28},{"$f":"Main!J38","v":38},38,107.14,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":20}]
[null,{"$f":"Main!A13","v":3},{"$f":"Main!J13","v":13},13,56.12,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":22}]
[null,{"$f":"Main!A44","v":0},{"$f":"Main!J44","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":22}]
[null,{"$f":"Main!A16","v":6},{"$f":"Main!J16","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":22}]
[null,{"$f":"Main!A12","v":2},{"$f":"Main!J12","v":18},18,66.33,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":28}]
[null,{"$f":"Main!A40","v":30},{"$f":"Main!J40","v":22},22,74.489999999999995,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":30}]
[null,{"$f":"Main!A22","v":12},{"$f":"Main!J22","v":22},22,74.489999999999995,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":31}]
[null,{"$f":"Main!A41","v":0},{"$f":"Main!J41","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":35}]
[null,{"$f":"Main!A25","v":15},{"$f":"Main!J25","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":37}]
[null,{"$f":"Main!A36","v":26},{"$f":"Main!J36","v":18},18,66.33,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":37}]
[null,{"$f":"Main!A18","v":8},{"$f":"Main!J18","v":13},13,56.12,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":38}]
[null,{"$f":"Main!A31","v":21},{"$f":"Main!J31","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":38}]
[null,{"$f":"Main!A33","v":23},{"$f":"Main!J33","v":31},31,92.86,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":42}]
[null,{"$f":"Main!A23","v":13},{"$f":"Main!J23","v":28},28,86.73,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":47}]
[null,{"$f":"Main!A24","v":14},{"$f":"Main!J24","v":47},47,125.51,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":49}]
[null,{"$f":"Main!A15","v":5},{"$f":"Main!J15","v":30},30,90.82,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":50}]
[null,{"$f":"Main!A37","v":27},{"$f":"Main!J37","v":35},35,101.02,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":56}]
[null,{"$f":"Main!A11","v":1},{"$f":"Main!J11","v":50},50,131.63,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":57}]
[null,{"$f":"Main!A14","v":4},{"$f":"Main!J14","v":56},56,143.88,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":58}]
[null,{"$f":"Main!A28","v":18},{"$f":"Main!J28","v":38},38,107.14,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":59}]
[null,{"$f":"Main!A43","v":0},{"$f":"Main!J43","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A34","v":24},{"$f":"Main!J34","v":57},57,145.91999999999999,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A35","v":25},{"$f":"Main!J35","v":13},13,56.12,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A29","v":19},{"$f":"Main!J29","v":49},49,129.59,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A45","v":0},{"$f":"Main!J45","v":0},0,0,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A32","v":22},{"$f":"Main!J32","v":16},16,62.24,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A39","v":29},{"$f":"Main!J39","v":20},20,70.41,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]
[null,{"$f":"Main!A19","v":9},{"$f":"Main!J19","v":22},22,74.489999999999995,null,{"$f":"IFERROR(SMALL(IF(OFFSET($C$14,0,0,35)=0, \"\", OFFSET($C$14,0,0,35)),ROW()-ROW($G$13)),\"\")","v":""}]