{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Battle","Characters","Original Characters","The Battle"],"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":"Battle","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[[25,0,25,1],[26,0,26,1],[27,0,27,1],[1,0,5,0],[6,0,10,0],[11,0,15,0],[16,0,20,0],[24,0,24,1],[7,7,7,8],[9,7,9,8],[1,7,1,8],[28,2,28,3],[29,2,29,3],[11,7,11,8],[13,7,13,8],[3,7,3,8],[5,7,5,8]]}
["Type (Crush/Slash/Pierce)","","Alexander the Great","Attila the Hun",null,null,null,"distance:",100]
["Armor","Coverage",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":86},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":63},null," percent of body covered by armor","","weapon chosen"]
[null,"Crushing",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":40},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":10},null,"chance to resist said type","","long","mid"]
[null,"Slashing",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":25},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":25},null,"chance to resist said type","","lethal"]
[null,"Piercing",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":25},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":10},null,"chance to resist said type","",{"$f":"INDIRECT(ADDRESS(J5,COLUMN(C5),1,1),TRUE)","v":13.23},{"$f":"INDIRECT(ADDRESS(K5,COLUMN(D5),1,1),TRUE)","v":29.67},{"$f":"IF(H3=\"long\",8,IF(H3=\"mid\",13,18))","v":8},{"$f":"IF(I3=\"long\",8,IF(I3=\"mid\",13,18))","v":13}]
[null,"Speed",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":44},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":64},null,"movement speed in m/s*10 (usually between 45 & 90, normal human runs about 65 (6.5 m/s)","","speed"]
["Long Range","Weapon",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)","v":"Gastraphetes"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)","v":"Magyar Composite Longbow"},null,null,"",{"$f":"INDIRECT(ADDRESS(J7,COLUMN(C7),1,1),TRUE)","v":190},39,{"$f":"IF(H3=\"long\",9,IF(H3=\"mid\",14,19))","v":9},{"$f":"IF(I3=\"long\",9,IF(I3=\"mid\",14,19))","v":14}]
[null,"Lethality",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW(),FALSE)*VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)/100","v":13.23},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW(),FALSE)*VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)/100","v":8.8800000000000008},null,"% chance of kill shot","","reach"]
[null,"Reach",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)","v":190},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)","v":200},null,"in yards","",{"$f":"INDIRECT(ADDRESS(J9,COLUMN(C9),1,1),TRUE)","v":36},36,{"$f":"IF(H3=\"long\",10,IF(H3=\"mid\",15,20))","v":10},{"$f":"IF(I3=\"long\",10,IF(I3=\"mid\",15,20))","v":15}]
[null,"Speed",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)*50","v":36},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)*50","v":57.999999999999993},null,"attacks per second*50 (example, 2.5*50=125 means about 5 attacks every 2 seconds (2.5 per sec))","","type"]
[null,"Type",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)","v":"Crush"},null,"crush/slash/pierce","",{"$f":"INDIRECT(ADDRESS(J11,COLUMN(C11),1,1),TRUE)","v":"Pierce"},"Pierce",{"$f":"IF(H3=\"long\",11,IF(H3=\"mid\",16,21))","v":11},{"$f":"IF(I3=\"long\",11,IF(I3=\"mid\",16,21))","v":16}]
["Mid Range","Weapon",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)","v":"Xyston"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)","v":"Hunnic Light Spear"},null,null,"","speed_mult"]
[null,"Lethality",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+1,FALSE)*VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)/100","v":29.7},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+1,FALSE)*VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)/100","v":29.67},null,"% chance of kill shot","",{"$f":"IF(C6/D6>1,1,C6/D6)","v":0.6875},{"$f":"IF(D6/C6>1,1,D6/C6)","v":1}]
[null,"Reach",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)","v":36},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)","v":39},null,"in yards","","Covered?"]
[null,"Speed",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)*50","v":34},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)*50","v":36},null,"attacks per second*50 (example, 2.5*50=125 means about 5 attacks every 2 seconds (2.5 per sec))","",{"$f":"IF(RAND()*100<C2,1,0)","v":1},{"$f":"IF(RAND()*100<D2,1,0)","v":1}]
[null,"Type",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)","v":"Pierce"},null,"crush/slash/pierce",""]
["Short Range","Weapon",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)","v":"Makhara"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)","v":"Scythian Axe"},null,null,""]
[null,"Lethality",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+2,FALSE)*VLOOKUP(C$1,Characters!A:Y,ROW()+3,FALSE)/100","v":65.12},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+2,FALSE)*VLOOKUP(D$1,Characters!A:Y,ROW()+3,FALSE)/100","v":72.8},null,"% chance of kill shot",""]
[null,"Reach",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+3,FALSE)","v":2.9},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+3,FALSE)","v":2.8},null,"in yards",""]
[null,"Speed",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+3,FALSE)*50","v":76},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+3,FALSE)*50","v":80},null,"attacks per second*50 (example, 2.5*50=125 means about 5 attacks every 2 seconds (2.5 per sec))",""]
[null,"Type",{"$f":"VLOOKUP(C$1,Characters!A:Y,ROW()+3,FALSE)","v":"Slash"},{"$f":"VLOOKUP(D$1,Characters!A:Y,ROW()+3,FALSE)","v":"Slash"},null,"crush/slash/pierce",""]
[null,null,null,null,null,null,""]
[null,null,"Number of Battles:",1000,null,null,""]
[null,null,{"$f":"C1","v":"Alexander the Great"},{"$f":"D1","v":"Attila the Hun"},null,null,""]
["Wins",null,68,132,null,{"$f":"IF(ISNUMBER(C30)=TRUE,C30,MAX(C9:D9,C14:D14,C19:D19))","v":200},""]
["Long Range",null,51,71,null,null,""]
["Mid Range",null,8,26]
["Short Range",null,9,35]
[null,null,"Starting Distance (yds), leave blank to start at max reach"]

{"sheet":"Characters","index":1,"n_rows":18,"n_cols":33,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,24,12,24],[13,24,34,24],[0,18,0,23],[0,0,1,0],[0,1,0,5],[0,6,0,11],[0,12,0,17]]}
["Name","Armor",null,null,null,null,"Long Range",null,null,null,null,null,"Mid Range",null,null,null,null,null,"Short Range",null,null,null,null,null,"X-Factors","Armor Metallurgy","Audacity","Dominance","Generalship","Hand-To-Hand Combat","Intimidation","Physicality","Tactics"]
[null,"Coverage (%)","Crushing (%)","Slashing (%)","Piercing (%)","Speed (m/s*10)","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type",null,"Armor metallurgy signifies the quality of the material used to make the armor of the warriors, both in how well it protects them and how much it restricts their movement. ","Audacity is bravery, the will to charge into battle and avoiding surrender.","Dominance mainly signifies the amount of control the general had over his troops and their loyalty. It also shows the amount of aggression the general was able to show during battle. ","",null,"The ability to scare others, a type of psychological warfare.",""]
["Alexander the Great",86,40,25,25,44,"Gastraphetes",27,49,190,0.72,"Pierce","Xyston",45,66,36,0.68,"Pierce","Makhara",88,74,2.9,1.52,"Slash",null,null,85]
["Attila the Hun",63,10,25,10,64,"Magyar Composite Longbow",24,37,200,1.1599999999999999,"Crush","Hunnic Light Spear",43,69,39,0.72,"Pierce","Scythian Axe",91,80,2.8,1.6,"Slash"]
["Genghis Khan",53,10,25,10,60,"Mongol Bow",23,35,195,1.42,"Pierce","Mongol Spear",35,73,32,0.7,"Pierce","Mongol Mace",90,76,2.7,1.54,"Crush",null,85,null,null,null,null,89,76,89]
["Hannibal",58,25,10,10,85,"Soliferrum",23,45,95,1.04,"Pierce","Dory",41,66,38,0.78,"Pierce","Falcata",90,69,3,1.58,"Slash",null,74,85,null,null,null,86,81]
["Hernan Cortes",78,40,40,10,38,"Arquebus",16,84,215,0.4,"Crush","Alabarda",43,76,36,0.48,"Slash","Espada Ropera",90,66,3.4,1.68,"Pierce",null,null,null,85,76,null,82,69]
["Shaka Zulu",0,0,0,0,88,"Umkhonto",23,47,125,1.1599999999999999,"Pierce","Ikiwa",43,67,34,0.76,"Pierce","Imbeba",85,76,3.1,1.94,"Slash"]
["Sun Tzu",56,10,25,10,61,"Bow and Incendiary Arrows",19,39,190,1.1200000000000001,"Pierce","Ji",43,80,35,0.6,"Slash","Dao",80,78,2.1,1.62,"Slash",null,null,null,85,null,null,null,null,95]
["Vlad the Impaler",41,25,25,10,68,"Steel Crossbow",23,37,145,0.78,"Pierce","Ranseur",44,80,38,0.52,"Pierce","Kilij",90,81,3.1,1.48,"Slash",null,null,85,85,null,null,85]
["William Wallace",51,10,25,10,65,"Ettrick Longbow",23,42,175,0.96,"Pierce","Claymore",45,90,23,0.26,"Slash","Warhammer",90,72,2.7,1.24,"Crush",null,null,85]
[]
["Default",0,0,0,0,0,"Default",0,0,0,0,"Default","Default",0,0,0,0,"Default","Default",0,0,0,0,"Default"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note for X-Factors: To add new x-factors, go to the last blank column and add a name in the first row, description in the second (optional), and list the ratings for each warrior in their corresponding rows. If a warrior has a blank under an x-factor by default this does not mean ZERO, it means that information on that x-factor has not been found though it can be filled in at any time. X-factor ratings should be between 0 and 100. Typically the ratings are broken down as follows: poor or below average < 50, average warriors > 50 & < 70, warriors skilled in the x-factor are greater than 70 and 85 or higher usually indicates some kind of remarkable feat related to that x-factor."]
["Aztec Jaguar",35,25,15,5,72,"Atlatl & Tlacochtli",21,40,225,0.84,"Pierce","Maquahuitl",43,87,21,0.55000000000000004,"Pierce","Tecpatl",75,68,0.9,2.2599999999999998,"Pierce"]
["Spartan Hoplite",68,40,25,25,56,"Javelin",20,43,110,0.94,"Pierce","Dory",41,66,38,0.78,"Pierce","Xiphos",80,83,1.7,1.65,"Pierce",null,null,null,null,null,95,null,95]
[]
[null,"To simulate without x-factors is to create a clone of some random guy and have one copy use the first warrior's equipment and the other copy to use the other warrior's equipment. The more x factors you add, the more accurate it will be to the true match up. for example, sparta's strength and athleticism aren't captured by their weapon stats alone"]

{"sheet":"Original Characters","index":2,"n_rows":9,"n_cols":25,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,0,1,0],[0,1,0,5],[0,6,0,11],[0,12,0,17],[0,18,0,23]]}
["Name","Armor",null,null,null,null,"Long Range",null,null,null,null,null,"Mid Range",null,null,null,null,null,"Short Range",null,null,null,null,null,"X-Factors:"]
[null,"Coverage (%)","Crushing (%)","Slashing (%)","Piercing (%)","Speed (m/s*10)","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type","Weapon","Accuracy (%)","Kill Rate (%)","Reach (yds)","Speed (hits/sec)","Type"]
["Alexander the Great",95,55,60,35,55,"Javelin",15,55,100,1,"Pierce","Spear",60,40,10,1.5,"Pierce","Sword",90,40,1,2,"Slash"]
["Shaka Zulu",25,20,30,65,75,"Rock Sling",20,20,50,0.67,"Crush","Spear",60,40,10,1.5,"Pierce","Mace",100,45,1,2.2000000000000002,"Crush"]
["Elite Soldier",95,20,5,20,63,"Sniper Rifle",75,85,800,2,"Pierce","Assault Rifle",50,12,500,15,"Pierce","Handgun",90,80,100,2,"Pierce"]
["Assault Soldier",95,20,5,20,63,"Assault Rifle",50,12,500,15,"Pierce","AA-12",85,40,150,5,"Pierce","Handgun",90,80,100,2,"Pierce"]
["Iron Man",100,97,94,90,260,"Missile",100,400,1200,0.5,"Slash","Hand Cannon",50,175,600,0.5,"Crush","Punch",85,65,1,0.75,"Crush"]
["Hulk",100,99,88,94,325,"Shout",80,40,50,1,"Slash","Gamma Shock",80,400,22,0.7,"Crush","Punch",150,400,5,1,"Crush"]
["test dummy",100,50,50,50,0,"Stand",0,0,0,0,"Slash","Stand","Stand",0,0,0,"Crush","Stand",0,0,0,0,"Pierce"]

{"sheet":"The Battle","index":3,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,1,15,2],[15,3,15,5],[18,8,18,9],[14,8,14,9],[1,8,1,9],[10,8,10,9],[12,8,12,9],[17,3,17,4],[1,0,4,0],[13,3,13,5],[14,3,14,5],[0,1,0,3],[0,4,0,6],[2,1,2,2],[2,4,2,5],[12,1,12,3],[12,4,12,6],[13,1,13,2],[14,1,14,2],[1,4,1,5],[1,1,1,2],[23,0,23,6],[18,1,18,2],[18,3,18,4],[18,5,18,6],[19,1,19,2],[19,3,19,4],[19,5,19,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[21,1,21,2],[21,3,21,4],[21,5,21,6],[22,1,22,2],[22,3,22,4],[22,5,22,6]]}
[null,"Genghis Khan",null,null,"Hannibal"]
["Armor","Coverage",null,"Speed","Coverage",null,"Speed",null,"weapon chosen",null,"distance:"]
[null,{"$f":"VLOOKUP(B$1,Characters!$A:$Y,2,FALSE)","v":53},null,{"$f":"VLOOKUP(B$1,Characters!$A:$Y,6,FALSE)","v":60},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,2,FALSE)","v":58},null,{"$f":"VLOOKUP(E$1,Characters!$A:$Y,6,FALSE)","v":85},null,"long","long","200"]
[null,"Crushing","Slashing","Piercing","Crushing","Slashing","Piercing",null,"long",0,"Crush",0]
[null,{"$f":"VLOOKUP(B$1,Characters!$A:$Y,3,FALSE)","v":10},{"$f":"VLOOKUP(B$1,Characters!$A:$Y,4,FALSE)","v":25},{"$f":"VLOOKUP(B$1,Characters!$A:$Y,5,FALSE)","v":10},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,3,FALSE)","v":25},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,4,FALSE)","v":10},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,5,FALSE)","v":10},null,"mid",1,"Slash",1]
["Weapon",{"$f":"VLOOKUP(B$1,Characters!$A:$Y,7,FALSE)","v":"Mongol Bow"},{"$f":"VLOOKUP(B$1,Characters!$A:$Y,13,FALSE)","v":"Mongol Spear"},{"$f":"VLOOKUP(B$1,Characters!$A:$Y,19,FALSE)","v":"Mongol Mace"},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,7,FALSE)","v":"Soliferrum"},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,13,FALSE)","v":"Dory"},{"$f":"VLOOKUP(E$1,Characters!$A:$Y,19,FALSE)","v":"Falcata"},null,"short",2,"Pierce",2]
["Lethality",{"$f":"VLOOKUP(B1,Characters!$A:$Y,8,FALSE)*VLOOKUP(B1,Characters!$A:$Y,9,FALSE)/100","v":8.0500000000000007},{"$f":"VLOOKUP(B1,Characters!$A:$Y,14,FALSE)*VLOOKUP(B1,Characters!$A:$Y,15,FALSE)/100","v":25.55},{"$f":"VLOOKUP(B1,Characters!$A:$Y,20,FALSE)*VLOOKUP(B1,Characters!$A:$Y,21,FALSE)/100","v":68.400000000000006},{"$f":"VLOOKUP(E1,Characters!$A:$Y,8,FALSE)*VLOOKUP(E1,Characters!$A:$Y,9,FALSE)/100","v":10.35},{"$f":"VLOOKUP(E1,Characters!$A:$Y,14,FALSE)*VLOOKUP(E1,Characters!$A:$Y,15,FALSE)/100","v":27.06},{"$f":"VLOOKUP(E1,Characters!$A:$Y,20,FALSE)*VLOOKUP(E1,Characters!$A:$Y,21,FALSE)/100","v":62.1},null,"=INDIRECT(ADDRESS(ROW(),2+VLOOKUP(I$3,$I$4:$J$6,2,FALSE),1,1),TRUE)","=INDIRECT(ADDRESS(ROW(),5+VLOOKUP(J$3,$I$4:$J$6,2,FALSE),1,1),TRUE)"]
["Reach",{"$f":"VLOOKUP(B1,Characters!$A:$Y,10,FALSE)","v":195},{"$f":"VLOOKUP(B1,Characters!$A:$Y,16,FALSE)","v":32},{"$f":"VLOOKUP(B1,Characters!$A:$Y,22,FALSE)","v":2.7},{"$f":"VLOOKUP(E1,Characters!$A:$Y,10,FALSE)","v":95},{"$f":"VLOOKUP(E1,Characters!$A:$Y,16,FALSE)","v":38},{"$f":"VLOOKUP(E1,Characters!$A:$Y,22,FALSE)","v":3},null,"=INDIRECT(ADDRESS(ROW(),2+VLOOKUP(I$3,$I$4:$J$6,2,FALSE),1,1),TRUE)","=INDIRECT(ADDRESS(ROW(),5+VLOOKUP(J$3,$I$4:$J$6,2,FALSE),1,1),TRUE)"]
["Speed",{"$f":"VLOOKUP(B1,Characters!$A:$Y,11,FALSE)*50","v":71},{"$f":"VLOOKUP(B1,Characters!$A:$Y,17,FALSE)*50","v":35},{"$f":"VLOOKUP(B1,Characters!$A:$Y,23,FALSE)*50","v":77},{"$f":"VLOOKUP(E1,Characters!$A:$Y,11,FALSE)*50","v":52},{"$f":"VLOOKUP(E1,Characters!$A:$Y,17,FALSE)*50","v":39},{"$f":"VLOOKUP(E1,Characters!$A:$Y,23,FALSE)*50","v":79},null,"=INDIRECT(ADDRESS(ROW(),2+VLOOKUP(I$3,$I$4:$J$6,2,FALSE),1,1),TRUE)","=INDIRECT(ADDRESS(ROW(),5+VLOOKUP(J$3,$I$4:$J$6,2,FALSE),1,1),TRUE)"]
["Type",{"$f":"VLOOKUP(B1,Characters!$A:$Y,12,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(B1,Characters!$A:$Y,18,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(B1,Characters!$A:$Y,24,FALSE)","v":"Crush"},{"$f":"VLOOKUP(E1,Characters!$A:$Y,12,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(E1,Characters!$A:$Y,18,FALSE)","v":"Pierce"},{"$f":"VLOOKUP(E1,Characters!$A:$Y,24,FALSE)","v":"Slash"},null,"=INDIRECT(ADDRESS(ROW(),2+VLOOKUP(I$3,$I$4:$J$6,2,FALSE),1,1),TRUE)","=INDIRECT(ADDRESS(ROW(),5+VLOOKUP(J$3,$I$4:$J$6,2,FALSE),1,1),TRUE)"]
["Weapon","Long","Mid","Short","Long","Mid","Short",null,"speed_mult"]
["Wins",0,0,0,0,0,0,null,"=SQRT(IF(D3/G3>1,1,D3/G3))","=SQRT(IF(G3/D3>1,1,G3/D3))"]
["Total Wins",{"$f":"SUM(B12:D12)","v":0},null,null,{"$f":"SUM(E12:G12)","v":0},null,null,null,"Covered?"]
[null,"Number of Battles:",null,10000,null,null,null,null,"=IF(RAND()*100<B3,1,0)","=IF(RAND()*100<E3,1,0)"]
[null,"Starting Distance:",null,200,null,null,null,null,"Distance_mult"]
[null,"Delay Between Battles:",null,0]
[null,null,null,null,null,null,null,null,"=IF(K3>I8,(I8/K3)^2,1)","=IF(K3>J8,(J8/K3)^2,1)"]
[null,null,null,"Choose Your X-Factors Below:",null,null,null,null,"=IF(J14=1,(100-INDIRECT(ADDRESS(ROW(B5),5+VLOOKUP(I10,$K$4:$L$6,2,FALSE)),TRUE))/100,1)","=IF(I14=1,(100-INDIRECT(ADDRESS(ROW(B5),2+VLOOKUP(J10,$K$4:$L$6,2,FALSE)),TRUE))/100,1)"]
["X-Factor:",{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(B$1,Characters!$A:$A,0),25+MATCH($D19,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":76},null,"Physicality",null,{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(E$1,Characters!$A:$A,0),25+MATCH($D19,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":81},null,null,"Kill Chance"]
["X-Factor:",{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(B$1,Characters!$A:$A,0),25+MATCH($D20,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(E$1,Characters!$A:$A,0),25+MATCH($D20,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,null,"=J7*J12*J9/50*(D15-K3)/D15*J16*J18"]
["X-Factor:",{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(B$1,Characters!$A:$A,0),25+MATCH($D21,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(E$1,Characters!$A:$A,0),25+MATCH($D21,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,{"$f":"SUM(B19:C23)","v":76}]
["X-Factor:",{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(B$1,Characters!$A:$A,0),25+MATCH($D22,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(E$1,Characters!$A:$A,0),25+MATCH($D22,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,{"$f":"SUM(F19:G23)","v":81},null,0,"p1kill"]
["X-Factor:",{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(B$1,Characters!$A:$A,0),25+MATCH($D23,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDIRECT(ADDRESS(MATCH(E$1,Characters!$A:$A,0),25+MATCH($D23,Characters!$Z$1:$XFD$1,0),1,1,\"Characters\"),TRUE),\"\")","v":""},null,null,"rand","=RAND()*200",{"$f":"I20","v":0},"p2kill"]
["X-Factor's are optional. If you wish to use any X-Factors, select them from the drop downs above.",null,null,null,null,null,null,null,"result","=VLOOKUP(J23,K22:L24,2,TRUE)","=I20+J20","nokill"]