{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main Sheet","American","British","Data"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Main Sheet","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Washington's Crossing"]

{"sheet":"American","index":1,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"v1.5"]
[]
[null,"American",null,null,"Attacker Leader Rating","Total Strength","Fatigue",null,"Defender Strength","Defender Fatigue","Defender Outflank Hexes","Attacker Outflank Hexes",null,null,null,null,"Surprise Table Die Roll Modifier"]
[null,null,null,null,{"$f":"MAX(IF(B7:B31=TRUE,D7:D31))","v":8},{"$f":"SUMPRODUCT((B7:B31=TRUE)*1,F7:F31)","v":2150},{"$f":"MAX(IF(B7:B31=TRUE,G7:G31))","v":2},null,1240,0,0,1,null,null,null,null,{"$f":"(I7*7)+(I8*3)+(I9*1)+(I10*0)+(I11*-1)+(I12*2)+(I15*1)+(I16*2)+(I17*-2)+(I18*-2)+(I19*-1)+(I20*-1)+(I21*-1)+(I22*-2)","v":9}]
[null,null,"De-select all leaders"]
[null,null,"Leaders","Leader Rating","Maximum","Current Strength","Current Fatigue",null,"Attacker",null,"Combat Ratio",null,null,"Worst Possible Result",null,null,"Min Surprise Combat Mod","Max Surprise Combat Mod","Actual Surprise Mod"]
[null,true,"Washington",8,140,130,2,null,true,{"$f":"IF(AND($I$7,$I$8),\"!\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,2,TRUE),\"\")","v":"3:2"},null,null,{"$f":"IFERROR(VLOOKUP($Q$17,CRT,$E$4,FALSE),\"  0/  0\")","v":" 20/ 20"},{"$f":"$Q$20","v":-0.05},null,{"$f":"VLOOKUP($Q$4,SurpriseTable,2,TRUE)","v":2},{"$f":"VLOOKUP($Q$4+9,SurpriseTable,2,TRUE)","v":6},{"$f":"VLOOKUP($Q$4+$L$9,SurpriseTable,2,TRUE)","v":2}]
[null,false,"Greene",6,0,0,0,null,false,{"$f":"IF(AND($I$7,$I$8),\"!\",\"\")","v":""},null,null,null,"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N7,FIND(\"/\",N7)-3,3))/100)+O7),-1))","v":190}]
[null,false,"Sullivan",5,0,0,0,null,false,{"$f":"IF(OR(AND($I$9,$I$10),AND($I$10,$I$11),AND($I$9,$I$11)),\"!\",\"\")","v":""},"Surprise Table Die Roll",0,null,"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N7,FIND(\"/\",N7)+1,3))/100,-1)","v":250},null,"Min Surpise Attacker %","Max Surpise Attacker %","Actual Surprise Attacker %",null,null,"Instructions"]
[null,false,"Cadwalader (M)",5,1380,380,2,null,true,"","Combat Table Die Roll",0,null,null,null,null,{"$f":"VLOOKUP($Q$4,SurpriseTable,3,TRUE)","v":-0.05},{"$f":"VLOOKUP($Q$4+9,SurpriseTable,3,TRUE)","v":-0.15},{"$f":"VLOOKUP($Q$4+$L$9,SurpriseTable,3,TRUE)","v":-0.05},null,null,"1. Check off the American Leaders to be included in the attack."]
[null,false,"Dickinson (M) *",3,400,400,0,null,false,"","Final Combat Results",null,null,"Best Possible Result",null,null,null,null,null,null,null,"2. Check off battle modifiers (e.g. \"Normal Attack\", \"Entrenched\", \"Rain\", etc.)"]
[null,false,"Ewing (M)",4,720,700,0,null,true,{"$f":"IF(AND($I$12,$I$13),\"!\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP($T$17+$L$10,CRT,$E$4,FALSE),\" 0 / 0  \")","v":" 20/ 20"},{"$f":"$T$20","v":-0.05},{"$f":"IFERROR(FIND(\"R\",$K$12),0)+IFERROR(FIND(\"?\",$K$12),0)+IFERROR(FIND(\"!\",$K$12),0)","v":0},{"$f":"IFERROR(VLOOKUP($R$17+9,CRT,$E$4,FALSE), \"  0/  0\")","v":"  5/ 90 !"},{"$f":"$R$20","v":-0.15},null,"Combat Ratio","Combat Ratio Modifier","Attacker Combat DRM",null,null,"3. Enter defender strength, defender fatigue, and outflank hexes."]
[null,true,"Fermoy",2,620,400,2,null,false,{"$f":"IF(AND($I$12,$I$13),\"!\",\"\")","v":""},"American Losses:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(K12,FIND(\"/\",K12)-3,3))/100)+L12),-1))","v":190},{"$f":"FIND(\"/\",$K$12)","v":4},"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N12,FIND(\"/\",N12)-3,3))/100)+O12),-1))","v":0},null,{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,2,TRUE),\"\")","v":"3:2"},{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,3,TRUE),\"\")","v":1},{"$f":"(I22*-1)+(I17*-1)+(I12*-1)+(I13*-2)+1+(I16*2)+(I15*1)+(I18*-2)+IF(G4=3,-1,0)+IF(G4=4,-2,0)+IF(J4>3,J4-3,0)+(I11*-1)","v":0},null,null,"4. Enter the actual \"Surprise Table Die Roll\" and \"Combat Table Die Roll\"."]
[null,false,"Glover *",5,850,160,2,null,"Defender",null,"British Losses:",{"$f":"ROUND($I$4*INT(MID(K12,FIND(\"/\",K12)+1,3))/100,-1)+$L$21","v":250},{"$f":"INT(MID(K12,FIND(\"/\",K12)-3,3))+($L$12*100)","v":15},"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N12,FIND(\"/\",N12)+1,3))/100,-1)","v":1120},null,null,null,null,null,null,"5. Read combat results (Retreat, Loss %, Troop Losses, Winner, Victory Points)."]
[null,false,"Griffin (M)",3,450,450,0,null,false,{"$f":"IF(AND($I$15,$I$16),\"!\",\"\")","v":""},"Winner:",{"$f":"IF($M$12=0,\"None\",IF($M$12>$M$13,\"American\",\"British\"))","v":"None"},{"$f":"INT(MID(K12,FIND(\"/\",K12)+1,3))","v":20}]
[null,false,"Hitchcock",4,710,710,2,null,false,{"$f":"IF(AND($I$15,$I$16),\"!\",\"\")","v":""},"Victory Points:",{"$f":"VLOOKUP(M16,VPTable,MATCH(M17,INDEX(VPTable,1,),1),TRUE)","v":0},{"$f":"IF($L$15=\"American\",IF(M14=0,0.00001,IFERROR(M14/M15,0)),IF($L$15=\"British\",IF(M15=0,0.00001,IFERROR(M15/M14,0)),0))","v":0},"Likely Result",null,null,"Worst Final DRM","Best Final DRM","Likely Final DRM","Actual Final DRM",null,"Keep the \"Current Strength\" and \"Current Fatigue\" values updated, and "]
[null,true,"Lord Stirling *",5,570,500,1,null,false,null,null,null,{"$f":"IF(L15=\"American\",L14,IF(L15=\"British\",L13,0))","v":0},{"$f":"IFERROR(VLOOKUP(INT(($S$17+$S$17+9)/2),CRT,$E$4,FALSE), \" 0 / 0 \")","v":" 20/ 40 ?"},{"$f":"$S$20","v":-0.1},null,{"$f":"IFERROR($Q$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":3},{"$f":"IFERROR($R$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":7},{"$f":"VLOOKUP(INT(($Q$4+($Q$4+9))/2),SurpriseTable,2,TRUE)","v":5},{"$f":"IFERROR($S$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":3},null,"there's no need to use the game's paper Leader Charts!"]
[null,false,"McDougall",5,750,0,0,null,false,null,null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"Subject to addt'l\", \"\"),\"\")","v":""},null,"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N17,FIND(\"/\",N17)-3,3))/100)+O17),-1))","v":120},null,null,null,null,null,null,"Note: The mobile version of this program is under construction, and will"]
[null,true,"Mercer",5,720,720,0,null,null,null,null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"30 troop losses\", \"\"),\"\")","v":""},null,"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N17,FIND(\"/\",N17)+1,3))/100,-1)","v":500},null,"Worst Attacker %","Best Attacker %","Likely Attacker %","Actual Attacker %",null,"allow you to run it on your phone!"]
[null,false,"Mifflin (M)",5,1800,0,0,null,null,null,null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"(see rule 17.1, item 6)\", \"\"),\"\")","v":""},null,null,null,null,{"$f":"$Q$10","v":-0.05},{"$f":"$R$10","v":-0.15},{"$f":"VLOOKUP(INT(($Q$4+($Q$4+9))/2),SurpriseTable,3,TRUE)","v":-0.1},{"$f":"$S$10","v":-0.05}]
[null,false,"Putnam (M)",2,1000,700,0,null,false,{"$f":"IF(AND($I$21,$I$22),\"!\",\"\")","v":""},null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),30,0),0)","v":0}]
[null,false,"Sargent *",4,710,500,5,null,false,{"$f":"IF(AND($I$21,$I$22),\"!\",\"\")","v":""}]
[null,false,"St. Clair **",5,"420 **",380,5,null,"*** (on or before Jan. 3)"]
[null,true,"Stephen",4,460,400,2]
[null,false,"Detachment 1",3,500,0,0]
[null,false,"Detachment 2",3,500,500,0]
[null,false,"Detachment 3",3,500,500,0]
[null,false,"Detachment 4 (M)",3,500,300,0]
[null,false,"Detachment 5 (M)",3,500,1000,2]
[null,false,"Detachment 6 (M)",3,500,0,0]
[null,false,"Detachment 7 (M)",3,500,0,0]
[null,"(M) = Militia"]
[null,"* End of enlistments on January 1st 12AM turn"]
[null,"** St. Clari's Command Limit increases to 1,400 starting on January 1st, 12AM turn"]

{"sheet":"British","index":2,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"British",null,null,"Attacker Leader Rating","Total Strength","Fatigue",null,"Defender Strength","Defender Fatigue","Defender Outflank Hexes","Attacker Outflank Hexes",null,null,null,null,"Surprise Table Die Roll Modifier"]
[null,null,null,null,{"$f":"MAX(IF(B7:B29=TRUE,D7:D29))","v":3},{"$f":"SUMPRODUCT((B7:B25=TRUE)*1,F7:F25)","v":1200},{"$f":"MAX(IF(B7:B25=TRUE,G7:G25))","v":0},null,600,0,0,1,null,null,null,null,{"$f":"(I7*2)+(I8*-1)+(I9*-2)+(I13*1)+(I14*2)+(I15*-2)+(I16*-2)+(I17*-1)+(I18*-1)+(I19*-1)+(I20*-2)","v":0}]
[null,null,"De-select all leaders"]
[null,null,"Leaders","Leader Rating","Maximum","Current Strength","Current Fatigue",null,"Attacker",null,"Combat Ratio",null,null,"Worst Possible Result",null,null,"Min Surprise Combat Mod","Max Surprise Combat Mod","Actual Surprise Mod"]
[null,false,"Cornwallis",6,0,0,0,null,false,{"$f":"IF(OR(AND($I$7,$I$8),AND($I$8,$I$9),AND($I$7,$I$9)),\"!\",\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,2,TRUE),\"\")","v":"2:1"},null,null,{"$f":"IFERROR(VLOOKUP($Q$17,CRT,$E$4,FALSE),\"'  0/  0\")","v":"'? 15/  5"},{"$f":"$Q$20","v":0.05},null,{"$f":"VLOOKUP($Q$4,SurpriseTable,2,TRUE)","v":-2},{"$f":"VLOOKUP($Q$4+9,SurpriseTable,2,TRUE)","v":2},{"$f":"VLOOKUP($Q$4+$L$9,SurpriseTable,2,TRUE)","v":0}]
[null,true,"Grant",2,2000,0,0,null,false,{"$f":"IF(OR(AND($I$7,$I$8),AND($I$8,$I$9),AND($I$7,$I$9)),\"!\",\"\")","v":""},null,null,null,"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N7,FIND(\"/\",N7)-3,3))/100)+O7),-1))","v":120}]
[null,true,"Grenadiers",3,1200,1200,0,null,false,{"$f":"IF(OR(AND($I$7,$I$8),AND($I$8,$I$9),AND($I$7,$I$9)),\"!\",\"\")","v":""},"Surprise Table Die Roll",5,null,"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N7,FIND(\"/\",N7)+1,3))/100,-1)","v":30},null,"Min Surpise Attacker %","Max Surpise Attacker %","Actual Surprise Attacker %",null,null,"Instructions"]
[null,false,"Leslie",4,2100,2100,0,null,false,{"$f":"IF(AND($I$10,$I$11),\"!\",\"\")","v":""},"Combat Table Die Roll",3,null,null,null,null,{"$f":"VLOOKUP($Q$4,SurpriseTable,3,TRUE)","v":0.05},{"$f":"VLOOKUP($Q$4+9,SurpriseTable,3,TRUE)","v":-0.05},{"$f":"VLOOKUP($Q$4+$L$9,SurpriseTable,3,TRUE)","v":0},null,null,"1. Check off the British Leaders to be included in the attack."]
[null,false,"Light Infantry",3,800,800,0,null,false,{"$f":"IF(AND($I$10,$I$11),\"!\",\"\")","v":""},"Final Combat Results",null,null,"Best Possible Result",null,null,null,null,null,null,null,"2. Check off battle modifiers (e.g. \"Normal Attack\", \"Entrenched\", \"Rain\", etc.)"]
[null,false,"Mathew",3,1000,1000,0,null,"Defender",null,{"$f":"IFERROR(VLOOKUP($T$17+$L$10,CRT,$E$4,FALSE),\" 0 / 0  \")","v":" 15/ 15"},{"$f":"$T$20","v":0},{"$f":"IFERROR(FIND(\"R\",$K$12),0)+IFERROR(FIND(\"?\",$K$12),0)+IFERROR(FIND(\"!\",$K$12),0)","v":0},{"$f":"IFERROR(VLOOKUP($R$17+9,CRT,$E$4,FALSE),\"'  0/  0\")","v":" 20/ 40 ?"},{"$f":"$R$20","v":-0.05},null,"Combat Ratio","Combat Ratio Modifier","Attacker Combat DRM",null,null,"3. Enter defender strength, defender fatigue, and outflank hexes."]
[null,false,"Mawhood",5,1400,1400,0,null,false,{"$f":"IF(AND($I$13,$I$14),\"!\",\"\")","v":""},"British Losses:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(K12,FIND(\"/\",K12)-3,3))/100)+L12),-1))","v":90},{"$f":"FIND(\"/\",$K$12)","v":4},"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N12,FIND(\"/\",N12)-3,3))/100)+O12),-1))","v":90},null,{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,2,TRUE),\"\")","v":"2:1"},{"$f":"IFERROR(VLOOKUP(ROUND($F$4/$I$4,6),CombatRatios,3,TRUE),\"\")","v":2},{"$f":"(I20*-1)+(I15*-1)+(I10*-1)+(I11*-2)+(I14*2)+(I13*1)+(I16*-2)+IF(F4=3,-1,0)+IF(F4=4,-2,0)+IF(J4>3,J4-3,0)+(I9*-1)","v":0},null,null,"4. Enter the actual \"Surprise Table Die Roll\" and \"Combat Table Die Roll\"."]
[null,false,"Monckton",4,1800,0,0,null,false,{"$f":"IF(AND($I$13,$I$14),\"!\",\"\")","v":""},"American Losses:",{"$f":"ROUND($I$4*INT(MID(K12,FIND(\"/\",K12)+1,3))/100,-1)+$L$21","v":90},{"$f":"INT(MID(K12,FIND(\"/\",K12)-3,3))+($L$12*100)","v":15},"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N12,FIND(\"/\",N12)+1,3))/100,-1)","v":240},null,null,null,null,null,null,"5. Read combat results (Retreat, Loss %, Troop Losses, Winner, Victory Points)."]
[null,false,"Stirling",3,500,500,1,null,false,null,"Winner:",{"$f":"IF($M$12=0,\"None\",IF($M$12>$M$13,\"British\",\"American\"))","v":"None"},{"$f":"INT(MID(K12,FIND(\"/\",K12)+1,3))","v":15}]
[null,false,"Vanguard",5,300,0,0,null,false,null,"Victory Points:",{"$f":"VLOOKUP(M16,VPTable,MATCH(M17,INDEX(VPTable,1,),1),TRUE)","v":0},{"$f":"IF($L$15=\"British\",IF(M14=0,0.00001,IFERROR(M14/M15,0)),IF($L$15=\"American\",IF(M15=0,0.00001,IFERROR(M15/M14,0)),0))","v":0},"Likely Result",null,null,"Worst Final DRM","Best Final DRM","Likely Final DRM","Actual Final DRM",null,"Keep the \"Current Strength\" and \"Current Fatigue\" values updated, and "]
[null,false,"Vaughan",3,1200,0,0,null,false,null,null,null,{"$f":"IF(L15=\"American\",L13,IF(L15=\"British\",L14,0))","v":0},{"$f":"IFERROR(VLOOKUP(INT(($S$17+$S$17+9)/2),CRT,$E$4,FALSE),\"'  0/  0\")","v":"'R 10/ 10"},{"$f":"$S$20","v":0},null,{"$f":"IFERROR($Q$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":0},{"$f":"IFERROR($R$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":4},{"$f":"VLOOKUP(INT(($Q$4+($Q$4+9))/2),SurpriseTable,2,TRUE)","v":0},{"$f":"IFERROR($S$7+$R$13+$S$13+MAX(0,$L$4-2)-MAX(0,$K$4-2),\"\")","v":2},null,"there's no need to use the game's paper Leader Charts!"]
[null,false,"Webster",3,1200,600,0,null,null,null,null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"Subject to addt'l\", \"\"),\"\")","v":""},null,"Attacker Result:",{"$f":"MAX(0,ROUND($I$4*((INT(MID(N17,FIND(\"/\",N17)-3,3))/100)+O17),-1))","v":60},null,null,null,null,null,null,"Note: The mobile version of this program is under construction, and will"]
[null,false,"Detachment 1",3,1200,0,0,null,false,{"$f":"IF(AND($I$19,$I$20),\"!\",\"\")","v":""},null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"30 troop losses\", \"\"),\"\")","v":""},null,"Defender Result:",{"$f":"ROUND($I$4*INT(MID(N17,FIND(\"/\",N17)+1,3))/100,-1)","v":60},null,"Worst Attacker %","Best Attacker %","Likely Attacker %","Actual Attacker %",null,"allow you to run it on your phone!"]
[null,false,"Detachment 2",3,1200,0,0,null,false,{"$f":"IF(AND($I$19,$I$20),\"!\",\"\")","v":""},null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),\"(see rule 17.1, item 6)\", \"\"),\"\")","v":""},null,null,null,null,{"$f":"$Q$10","v":0.05},{"$f":"$R$10","v":-0.05},{"$f":"VLOOKUP(INT(($Q$4+($Q$4+9))/2),SurpriseTable,3,TRUE)","v":0},{"$f":"$S$10","v":0}]
[null,false,"Detachment 3",3,1200,0,0,null,"*** (on or before Jan. 3)",null,null,{"$f":"IFERROR(IF(AND($I$4<=100,LEFT($K$7,FIND(\":\",$K$7,1)-1)>=7),30,0),0)","v":0}]
[null,false,"vonDonop (H)",5,2200,950,1]
[null,false,"Rall (H)",3,1400,1240,2]
[null,false,"Detachment 1 (H)",3,1200,150,1]
[null,false,"Detachment 2 (H)",3,1200,450,0]
[null,"(H) = Hessian"]

{"sheet":"Data","index":3,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,"Combat Odds",null,null,null,"Surprise Table",null,null,null,"Surprise Table",null,null,null,null,null,null,null,null,"Victory Point Table"]
[null,"Ratio","Odds","Modifier",null,"Die Roll","CRT Mod","Attacker %",null,null,"Attacker Leader Rating",null,null,null,null,null,null,null,null,"Loser Losses"]
[null,{"$f":"ROUND(1/9,6)","v":0.111111},"1:9",-9,null,-4,-6,0.15,null,"Die Roll",2,3,4,5,6,7,8,null,"Winner to Loser Ratio",0,100,200,400,600]
[null,{"$f":"ROUND(1/8,6)","v":0.125},"1:8",-8,null,-3,-5,0.1,null,-7,"! 25/  0","'! 25/  0","'! 25/  0","'! 20/  0","'! 20/  0","'! 15/  0","'! 15/  0",null,0,0,0,0,0,0]
[null,{"$f":"ROUND(1/7,6)","v":0.14285700000000001},"1:7",-7,null,-2,-4,0.1,null,-6,"'! 20/  0","'! 20/  0","'! 20/  0","'! 15/  0","'! 15/  0","'! 10/  0","'! 10/  0",null,9.9999999999999995E-7,0,1,2,4,6]
[null,{"$f":"ROUND(1/6,6)","v":0.16666700000000001},"1:6",-6,null,-1,-3,0.1,null,-5,"'! 15/  0","'! 15/  0","'! 15/  0","'! 15/  0","'! 15/  0","'! 15/5","'! 15/5",null,{"$f":"1/3+0.000001","v":0.33333433333333329},0,1,2,4,6]
[null,{"$f":"ROUND(1/5,6)","v":0.2},"1:5",-5,null,0,-2,0.05,null,-4,"'! 15/  0","'! 15/  0","'! 15/  0","'! 10/  0","'! 10/  0","'? 15/5","'? 15/5",null,{"$f":"1/2+0.000001","v":0.50000100000000003},0,1,2,4,4]
[null,{"$f":"ROUND(1/4,6)","v":0.25},"1:4",-4,null,1,-2,0.05,null,-3,"'! 10/  0","'! 10/  0","'! 10/  0","'! 10/  0","'! 10/  0","'? 10/5","'? 10/5",null,{"$f":"2/3+0.000001","v":0.66666766666666666},0,1,1,1,1]
[null,{"$f":"ROUND(1/3,6)","v":0.33333299999999999},"1:3",-3,null,2,-1,0.05,null,-2,"'? 10/  0","'? 10/  0","'? 10/  0","'? 15/5","'? 15/5","'? 20/ 10","'? 20/ 10",null,1,0,0,0,0,0]
[null,{"$f":"ROUND(1/2,6)","v":0.5},"1:2",-2,null,3,-1,0,null,-1,"'? 15/  5","'? 15/  5","'? 15/  5","'? 15/  5","'? 15/  5","'R 15/ 10","'R 15/ 10"]
[null,{"$f":"ROUND(2/3,6)","v":0.66666700000000001},"2:3",-1,null,4,0,0,null,0,"'? 15/  5","'? 15/  5","'? 15/  5","'R 10/  5","'R 10/  5","'R 10/ 10","'R 10/ 10",null,"Winner %",5,null,{"$f":"IF(T11=0,0.00001,IFERROR(T11/T12,0))","v":0.16666666666666666}]
[null,1,"1:1",0,null,5,0,0,null,1,"'R 10/  5","'R 10/  5","'R 10/  5","'R 10/  5","'R 10/  5","'R 20/ 15","'R 20/ 15",null,"Loser %",30]
[null,1.5,"3:2",1,null,6,1,0,null,2,"'R 10/  5","'R 10/  5","'R 10/  5","'R 15/ 10","'R 15/ 10","'R 15/ 15","'R 15/ 15",null,"Loser Losses",100]
[null,2,"2:1",2,null,7,1,0,null,3,"'R 15/ 10","'R 15/ 10","'R 15/ 10","'R 10/ 10","'R 10/ 10"," 20/ 20"," 20/ 20"]
[null,3,"3:1",3,null,8,2,-0.05,null,4,"'R 10/ 10","'R 10/ 10","'R 10/ 10"," 15/ 15"," 15/ 15"," 15/ 20"," 15/ 20",null,"VPs",{"$f":"VLOOKUP(V11,VPTable,MATCH(T13,INDEX(VPTable,1,),1),TRUE)","v":1},null,{"$f":"ADDRESS(MATCH(V11,INDEX(VPTable,,1),1),MATCH(T13,INDEX(VPTable,1,),1))","v":"$C$3"}]
[null,4,"4:1",4,null,9,2,-0.05,null,5," 15/ 15"," 15/ 15"," 15/ 15"," 10/ 15"," 10/ 15"," 25/ 25 R"," 25/ 25 R"]
[null,5,"5:1",5,null,10,3,-0.05,null,6,"' 10/ 15","' 10/ 15","' 10/ 15"," 20/ 20 R"," 20/ 20 R"," 20/ 25 R"," 20/ 25 R"]
[null,6,"6:1",6,null,11,3,-0.1,null,7,"' 20/ 20 R"," 20/ 20 R"," 20/ 20 R"," 15/ 20 R"," 15/ 20 R"," 25/ 30 R"," 25/ 30 R"]
[null,7,"7:1",7,null,12,4,-0.1,null,8,"' 15/ 20 R"," 15/ 20 R"," 15/ 20 R"," 20/ 25 R"," 20/ 25 R"," 20/ 30 R"," 20/ 30 R"]
[null,8,"8:1",8,null,13,5,-0.1,null,9,"' 20/ 25 R"," 20/ 25 R"," 20/ 25 R"," 15/ 25 R"," 15/ 25 R"," 20/ 40 ?"," 20/ 40 ?"]
[null,9,"9:1",9,null,14,6,-0.15,null,10,"' 15/ 25 R"," 15/ 25 R"," 15/ 25 R"," 10/ 25 ?"," 10/ 25 ?"," 15/ 40 ?"," 15/ 40 ?"]
[null,10,"10:1",10,null,null,null,null,null,11,"' 10/ 25 ?"," 10/ 25 ?"," 10/ 25 ?"," 15/ 30 ?"," 15/ 30 ?"," 20/ 50 ?"," 20/ 50 ?"]
[null,11,"11:1",11,null,null,null,null,null,12,"' 15/ 30 ?"," 15/ 30 ?"," 15/ 30 ?"," 15/ 40 ?"," 15/ 40 ?"," 20/ 60 !"," 20/ 60 !"]
[null,12,"12:1",12,null,null,null,null,null,13,"' 20/ 40 ?"," 20/ 40 ?"," 20/ 40 ?"," 20/ 50 !"," 20/ 50 !"," 15/ 70 !"," 15/ 70 !"]
[null,13,"13:1",13,null,null,null,null,null,14,"' 20/ 50 !"," 20/ 50 !"," 20/ 50 !"," 20/ 60 !"," 20/ 60 !"," 15/ 80 !"," 15/ 80 !"]
[null,14,"14:1",14,null,null,null,null,null,15,"' 25/ 60 !"," 25/ 60 !"," 25/ 60 !"," 15/ 70 !"," 15/ 70 !"," 10/ 90 !"," 10/ 90 !"]
[null,null,null,null,null,null,null,null,null,16," 25/ 70 !"," 25/ 70 !"," 25/ 70 !"," 15/ 80 !"," 15/ 80 !","  5/ 90 !","  5/ 90 !"]
[null,null,null,null,null,null,null,null,null,17," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,18," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,19," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,20," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,21," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,22," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,23," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,24," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,25," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,26," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,27," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,28," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,29," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]
[null,null,null,null,null,null,null,null,null,30," 15/ 80 !"," 15/ 80 !"," 15/ 80 !"," 10/100 !"," 10/100 !","  5/100 !","  5/100 !"]