{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template","Calc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Template","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"Hits",null,null,null,"Wounds"]
[null,null,null,null,null,"Non-Armor",null,"Armor",null,"Pierce Imm","Pierce Imm","Impervious"]
[null,"Hit","Crit","Net Hits","Net Impact","White Surge","Red","White","White Surge","Red","Red Surge","Red Surge"]
[0,{"$f":"COUNTIF(B$52:B$100051,$A4)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A4)/25000","v":0},0,0,0,0,0,0,0,0,0]
[1,{"$f":"COUNTIF(B$52:B$100051,$A5)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A5)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A5)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A5)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A5)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A5)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A5)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A5)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A5)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A5)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A5)/25000","v":0}]
[2,{"$f":"COUNTIF(B$52:B$100051,$A6)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A6)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A6)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A6)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A6)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A6)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A6)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A6)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A6)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A6)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A6)/25000","v":0}]
[3,{"$f":"COUNTIF(B$52:B$100051,$A7)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A7)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A7)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A7)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A7)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A7)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A7)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A7)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A7)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A7)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A7)/25000","v":0}]
[4,{"$f":"COUNTIF(B$52:B$100051,$A8)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A8)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A8)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A8)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A8)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A8)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A8)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A8)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A8)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A8)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A8)/25000","v":0}]
[5,{"$f":"COUNTIF(B$52:B$100051,$A9)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A9)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A9)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A9)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A9)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A9)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A9)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A9)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A9)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A9)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A9)/25000","v":0}]
[6,{"$f":"COUNTIF(B$52:B$100051,$A10)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A10)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A10)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A10)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A10)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A10)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A10)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A10)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A10)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A10)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A10)/25000","v":0}]
[7,{"$f":"COUNTIF(B$52:B$100051,$A11)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A11)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A11)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A11)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A11)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A11)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A11)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A11)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A11)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A11)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A11)/25000","v":0}]
[8,{"$f":"COUNTIF(B$52:B$100051,$A12)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A12)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A12)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A12)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A12)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A12)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A12)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A12)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A12)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A12)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A12)/25000","v":0}]
[9,{"$f":"COUNTIF(B$52:B$100051,$A13)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A13)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A13)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A13)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A13)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A13)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A13)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A13)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A13)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A13)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A13)/25000","v":0}]
[10,{"$f":"COUNTIF(B$52:B$100051,$A14)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A14)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A14)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A14)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A14)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A14)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A14)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A14)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A14)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A14)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A14)/25000","v":0}]
[11,{"$f":"COUNTIF(B$52:B$100051,$A15)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A15)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A15)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A15)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A15)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A15)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A15)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A15)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A15)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A15)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A15)/25000","v":0}]
[12,{"$f":"COUNTIF(B$52:B$100051,$A16)/25000","v":0},{"$f":"COUNTIF(C$52:C$100051,$A16)/25000","v":0},{"$f":"COUNTIF(D$52:D$100051,$A16)/25000","v":0},{"$f":"COUNTIF(E$52:E$100051,$A16)/25000","v":0},{"$f":"COUNTIF(F$52:F$100051,$A16)/25000","v":0},{"$f":"COUNTIF(G$52:G$100051,$A16)/25000","v":0},{"$f":"COUNTIF(H$52:H$100051,$A16)/25000","v":0},{"$f":"COUNTIF(I$52:I$100051,$A16)/25000","v":0},{"$f":"COUNTIF(J$52:J$100051,$A16)/25000","v":0},{"$f":"COUNTIF(K$52:K$100051,$A16)/25000","v":0},{"$f":"COUNTIF(L$52:L$100051,$A16)/25000","v":0}]
[null,"Hit","Crit","Net Hits","Net Impact","White Surge","Red","White","White Surge","Red","Red Surge","Red Surge"]
["Averages",{"$f":"ROUND(AVERAGE(B52:B100052),2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(C52:C100052),2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Wounds"]
[]
[null,null,null,null,null,"Non-Armor",null,"Armor",null,"Pierce Imm","Pierce Imm","Impervious"]
["Iteration","Hit","Crit","Net Hits","Net Impact","White Surge","Red","White","White Surge","Red","Red Surge","Red Surge"]

{"sheet":"Calc","index":1,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Surge","Miss",null,null,"Unit Name",null,null,null,null,null,"Hit",{"$f":"COUNTIF($B$21:$D$43,K1)","v":3},"Modified Hits",{"$f":"MAX(0,L1-B4-B5)","v":3},null,null,"Miss"]
["Impact",0,null,null,"Rebel Troopers with Z-6",null,null,null,null,null,"Crit",{"$f":"COUNTIF($B$21:$D$43,K2)","v":1},null,null,null,null,"Hit"]
["Pierce",0,null,null,null,null,null,null,null,null,"Net Hits",{"$f":"N1+L2","v":4},null,null,null,null,"Crit"]
["Cover",0,null,null,null,null,null,null,null,null,"Net Impact",{"$f":"L2+MIN(N1,B2)","v":1}]
["Dodge",0]
["Aim",0]
[null,null,null,null,null,null,null,null,null,null,5,4,6,5,4,3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Armor",null,"Pierce Imm","Pierce Imm","Boba"]
[null,"White","Black","Red",null,null,null,null,null,null,"White Surge","Red","White","White Surge","Red","Red Surge","Red Surge"]
["Dice",6,5,0,null,null,null,null,null,1,{"$f":"IF($J10<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J10<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J10<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J10<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J10<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J10<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($L$3=0,\"Miss\",IF($J10-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Save"}]
[null,"Value tables",null,null,null,null,null,null,null,2,{"$f":"IF($J11<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J11<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J11<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J11<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J11<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J11<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($L$3=0,\"Miss\",IF($J11-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Save"}]
[1,"Miss","Miss","Miss",null,null,null,null,null,3,{"$f":"IF($J12<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J12<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J12<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J12<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J12<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J12<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($L$3=0,\"Miss\",IF($J12-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Wound"}]
[2,"Miss","Miss",{"$f":"$B$1","v":"Miss"},null,null,null,null,null,4,{"$f":"IF($J13<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($J13<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J13<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J13<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J13<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Wound"},{"$f":"IF($J13<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Save"},{"$f":"IF($L$3=0,\"Miss\",IF($J13-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Wound"}]
[3,"Miss","Miss","Hit",null,null,null,null,null,5,{"$f":"IF($J14<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J14<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J14<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J14<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J14<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J14<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($L$3=0,\"Miss\",IF($J14-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Miss"}]
[4,"Miss",{"$f":"$B$1","v":"Miss"},"Hit",null,null,null,null,null,6,{"$f":"IF($J15<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J15<=$L$3,IF(RANDBETWEEN(1,6)>=L$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J15<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J15<=$L$4,IF(RANDBETWEEN(1,6)>=N$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J15<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($J15<=$L$3,IF(RANDBETWEEN(1,6)>=P$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},{"$f":"IF($L$3=0,\"Miss\",IF($J15-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Miss"}]
[5,"Miss","Hit","Hit",null,null,null,null,null,7,{"$f":"IF($J16<=$L$3,IF(RANDBETWEEN(1,6)>=K$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},"Miss",{"$f":"IF($J16<=$L$4,IF(RANDBETWEEN(1,6)>=M$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},"Miss",{"$f":"IF($J16<=$L$3,IF(RANDBETWEEN(1,6)>=O$7,\"Save\",\"Wound\"),\"Miss\")","v":"Miss"},"Miss",{"$f":"IF($L$3=0,\"Miss\",IF($J16-$B$3<=$L$3,IF(RANDBETWEEN(1,6)>=Q$7,\"Save\",\"Wound\"),\"Miss\"))","v":"Miss"}]
[6,{"$f":"$B$1","v":"Miss"},"Hit","Hit",null,null,null,null,null,8,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[7,"Hit","Hit","Hit",null,null,null,null,null,9,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[8,"Crit","Crit","Crit",null,null,null,null,null,10,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[null,null,null,null,null,null,null,null,null,11,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[1,{"$f":"IF($A21<=B$10,INDEX(B$12:B$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"Miss"},{"$f":"IF($A21<=C$10,INDEX(C$12:C$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"Miss"},"No Roll",null,null,null,null,null,12,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[2,{"$f":"IF($A22<=B$10,INDEX(B$12:B$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"Miss"},"Hit","No Roll",null,null,null,null,null,13,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[3,"Miss","Hit","No Roll",null,null,null,null,null,14,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[4,"Miss","Miss","No Roll",null,null,null,null,null,15,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[5,"Hit","Crit","No Roll",null,null,null,null,null,16,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[6,"Miss","No Roll","No Roll",null,null,null,null,null,17,"Miss","Miss","Miss","Miss","Miss","Miss","Miss"]
[7,"No Roll","No Roll","No Roll"]
[8,"No Roll","No Roll","No Roll",null,"Iteration","Hit","Crit","Net Hits","Net Impact",{"$f":"COUNTIF(K10:K26,\"Save\")","v":1},2,{"$f":"COUNTIF(M10:M26,\"Save\")","v":0},0,{"$f":"COUNTIF(O10:O26,\"Save\")","v":3},3,2]
[9,"No Roll","No Roll","No Roll",null,25052,{"$f":"L1","v":3},{"$f":"L2","v":1},{"$f":"L3","v":4},{"$f":"L4","v":1},{"$f":"COUNTIF(K10:K26,\"Wound\")+MIN(K28,$B$3)","v":3},2,{"$f":"COUNTIF(M10:M26,\"Wound\")+MIN(M28,$B$3)","v":1},1,{"$f":"COUNTIF(O10:O26,\"Wound\")","v":1},{"$f":"COUNTIF(P10:P26,\"Wound\")","v":1},{"$f":"L3-COUNTIF(Q10:Q26,\"Save\")+MIN(Q28,$B$3)","v":2}]
[10,"No Roll","No Roll","No Roll"]
[11,"No Roll","No Roll","No Roll"]
[12,"No Roll","No Roll","No Roll"]
[13,"No Roll","No Roll","No Roll"]
[14,"No Roll","No Roll","No Roll"]
[15,"No Roll","No Roll","No Roll"]
[16,"No Roll","No Roll","No Roll"]
[17,"No Roll","No Roll","No Roll"]
[]
["Aim"]
[1,{"$f":"IF($A40<=B$48,INDEX(B$12:B$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"No Roll"},{"$f":"IF($A40<=C$48,INDEX(C$12:C$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"No Roll"},"No Roll"]
[2,{"$f":"IF($A41<=B$48,INDEX(B$12:B$19,MATCH(RANDBETWEEN(1,8),$A$12:$A$19,0)),\"No Roll\")","v":"No Roll"},"No Roll","No Roll"]
[3,"No Roll","No Roll","No Roll"]
[4,"No Roll","No Roll","No Roll"]
[]
["Hits",{"$f":"COUNTIF(B$21:B$37,\"Hit\")","v":1},{"$f":"COUNTIF(C$21:C$37,\"Hit\")","v":2},0]
["Crits",{"$f":"COUNTIF(B$21:B$37,\"Crit\")","v":0},{"$f":"COUNTIF(C$21:C$37,\"Crit\")","v":1},{"$f":"COUNTIF(D$21:D$37,\"Crit\")","v":0}]
["Net",{"$f":"SUM(B45:B46)","v":1},{"$f":"SUM(C45:C46)","v":3},{"$f":"SUM(D45:D46)","v":0}]
["Rerolls",{"$f":"MIN(B10-B47,$B$6-C48-D48)","v":0},{"$f":"MIN(C10-C47,$B$6-D48)","v":0},{"$f":"MIN(D10-D47,$B$6)","v":0}]