{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Requirements","Tables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Requirements","index":0,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,21],[6,1,6,21],[7,1,7,21],[3,1,3,9],[4,5,4,9],[5,5,5,9]]}
[]
[null,"Guns of Glory - WTO Upgrade Program"]
[]
[null,"Select your Next SH Level, Armor Type and whether to include Wall Requirements"]
[null,"Stronghold",24,"Armor","ORANGE","SELECT SH Level & Armor"]
[null,"Wall",{"$f":"$C$5-1","v":23},"Include ?","NO","SELECT Upgrade Wall  Yes/No"]
[null,"Please don't modify the shaded & colored areas below this line."]
[null,"For Modifications Please ask LrdWreckingBunny."]
[]
[null,null,"Food","Wood","Iron","Silver",null,"Food","In Bags","Totals",null,"Wood","In Bags","Totals",null,"Iron","In Bags","Totals",null,"Silver","In Bags","Totals"]
[null,"Wall",{"$f":"IF($E$6=\"Yes\",VLOOKUP($C$5-1,Tables!$S$3:$W$37,2,0),0)","v":0},{"$f":"IF($E$6=\"Yes\",VLOOKUP($C$5-1,Tables!$S$3:$W$37,3,0),0)","v":0},{"$f":"IF($E$6=\"Yes\",VLOOKUP($C$5-1,Tables!$S$3:$W$37,4,0),0)","v":0},{"$f":"IF($E$6=\"Yes\",VLOOKUP($C$5-1,Tables!$S$3:$W$37,5,0),0)","v":0},null,1000,null,{"$f":"H11*I11","v":0},null,1000,null,{"$f":"L11*M11","v":0},null,200,null,{"$f":"P11*Q11","v":0},null,50,null,{"$f":"T11*U11","v":0}]
[null,"Stronghold",{"$f":"VLOOKUP($C$5,Tables!$M$3:$Q$37,2,0)","v":48000000},{"$f":"VLOOKUP($C$5,Tables!$M$3:$Q$37,3,0)","v":9220000},{"$f":"VLOOKUP($C$5,Tables!$M$3:$Q$37,4,0)","v":9220000},{"$f":"VLOOKUP($C$5,Tables!$M$3:$Q$37,5,0)","v":1850000},null,3000,null,{"$f":"H12*I12","v":0},null,3000,null,{"$f":"L12*M12","v":0},null,600,null,0,null,150,null,{"$f":"T12*U12","v":0}]
[null,"Total",{"$f":"SUM(C11:C12)","v":48000000},{"$f":"SUM(D11:D12)","v":9220000},9220000,1850000,null,5000,null,0,null,5000,null,0,null,1000,null,0,null,250,null,0]
[null,"Have",{"$f":"J19","v":0},{"$f":"N19","v":0},{"$f":"R19","v":0},{"$f":"V19","v":0},null,10000,null,0,null,10000,null,0,null,2000,null,0,null,500,null,0]
[null,"Armor %",{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,3,0))","v":0.1},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,5,0))","v":0.1},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,7,0))","v":0.1},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,7,0))","v":0.1},null,30000,null,0,null,30000,null,0,null,6000,null,0,null,1500,null,0]
[null,"Armor Qty",{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,2,0))","v":6000000},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,4,0))","v":3000000},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,6,0))","v":600000},{"$f":"ABS(VLOOKUP($E$5,Tables!$B$2:$J$46,8,0))","v":1200000},null,50000,null,0,null,50000,null,0,null,30000,null,0,null,2500,null,0]
[null,"Reduction",{"$f":"((C15*C13)+C16)","v":10800000},{"$f":"((D15*D13)+D16)","v":3922000},1522000,1385000,null,150000,null,0,null,150000,null,0,null,100000,null,0,null,25000,null,0]
[null,null,null,null,null,null,null,"ON HAND",null,null,null,"ON HAND",null,null,null,"ON HAND",null,null,null,"ON HAND",null,"nn"]
[null,"Need ",{"$f":"IF(C13-(C14+C17)<0,0,C13-(C14+C17))","v":37200000},{"$f":"IF(D13-(D14+D17)<0,0,D13-(D14+D17))","v":5298000},7698000,465000,null,"Total",null,{"$f":"SUM(J11:J18)","v":0},null,"Total",null,{"$f":"SUM(N11:N18)","v":0},null,"Total",null,{"$f":"SUM(R11:R18)","v":0},null,"Total",null,{"$f":"SUM(V11:V18)","v":0}]

{"sheet":"Tables","index":1,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,1,0,15],[23,1,23,9],[24,2,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[1,1,1,9],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[12,1,12,9],[34,1,34,9],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9]]}
[null,"Please Do Not Modify Anything On This Page"]
[null,"Blue Iseult Armor",null,null,null,null,null,null,null,null,null,"Armor","SH","Food","Wood","Iron","Silver",null,"Wall","Food","Wood","Iron","Silver"]
[null,null,"food",null,"wood",null,"Silver",null,"Iron",null,null,"NONE",1,null,null,null,null,null,1,0,0,0,0]
[null,"Helm",-750000,null,null,null,null,null,null,null,null,"BLUE",2,2900,2900,null,null,null,2,0,2040,0,0]
[null,"Armor",null,null,-500000,null,null,null,null,null,null,"PURPLE",3,4400,4400,null,null,null,3,0,3060,0,0]
[null,"Ring",null,null,null,null,null,null,-300000,null,null,"ORANGE",4,7000,7000,null,null,null,4,0,4900,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Retribution",5,12000,12000,null,null,null,5,0,8320,0,0]
[null,"Weapon",-750000,null,null,null,null,null,null,null,null,null,6,21000,21000,null,null,null,6,0,15000,0,0]
[null,"Boots",null,null,-250000,null,null,null,null,null,null,null,7,41000,41000,null,null,null,7,0,28500,0,0]
[null,"Pendant",null,null,null,null,null,null,-300000,null,null,"Query",8,81000,81000,null,null,null,8,0,56900,0,0]
[null,"BLUE",{"$f":"SUM(C4:C10)","v":-1500000},0,-750000,0,0,0,-600000,0,null,"YES",9,163000,163000,null,null,null,9,0,114000,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"NO",10,326000,326000,null,null,null,10,0,228000,0,0]
[null,"Purple Iseult Armor",null,null,null,null,null,null,null,null,null,null,11,627000,627000,6600,null,null,11,0,439000,4620,0]
[null,null,"food",null,"wood",null,"Silver",null,"Iron",null,null,null,12,1140000,1140000,25000,null,null,12,0,795000,17660,0]
[null,"Helm",null,null,-500000,-2.5000000000000001E-2,null,null,-200000,null,null,null,13,1920000,1920000,68000,null,null,13,0,1300000,48000,0]
[null,"Armor",-1000000,-0.05,null,null,-100000,null,null,null,null,null,14,3020000,3020000,151000,null,null,14,0,2110000,105600,0]
[null,"Ring",-1000000,null,null,null,null,-2.5000000000000001E-2,-200000,null,null,null,15,4380000,4380000,292000,null,null,15,0,3070000,206000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,16,6020000,5850000,502000,null,null,16,0,4100000,352000,0]
[null,"Weapon",-1000000,null,null,null,-100000,null,null,-0.05,null,null,17,7780000,6770000,790000,28000,null,17,0,4740000,554000,19750]
[null,"Boots",null,null,-500000,-2.5000000000000001E-2,-100000,null,null,null,null,null,18,10100000,7610000,1220000,77000,null,18,0,5330000,854000,53500]
[null,"Pendant",null,null,-500000,null,null,-2.5000000000000001E-2,-200000,null,null,null,19,13000000,8220000,1850000,155000,null,19,0,5760000,1296000,108000]
[null,"PURPLE",{"$f":"SUM(C15:C21)","v":-3000000},-0.05,-1500000,-0.05,-300000,-0.05,-600000,-0.05,null,null,20,16700000,8330000,2780000,278000,null,20,0,5830000,1942000,194500]
[null,null,null,null,null,null,null,null,null,null,null,null,21,21400000,7490000,4120000,469000,null,21,0,5250000,2900000,328000]
[null,"Orange Iseult Armor",null,null,null,null,null,null,null,null,null,null,22,27300000,5060000,6080000,760000,null,22,0,3540000,4260000,535000]
[null,null,"food",null,"wood",null,"Silver",null,"Iron",null,null,null,23,36200000,6830000,7520000,1200000,null,23,0,4780000,5260000,840000]
[null,"Helm",null,null,-1000000,-0.05,null,null,-400000,null,null,null,24,48000000,9220000,9220000,1850000,null,24,0,6450000,6460000,1290000]
[null,"Armor",-2000000,-0.1,null,null,-200000,null,null,null,null,null,25,63500000,12500000,11200000,2800000,null,25,0,8710000,7840000,1960000]
[null,"Ring",-2000000,null,null,null,null,-0.05,-400000,null,null,null,26,84000000,16800000,13440000,4200000,null,26,0,12000000,9400000,2960000]
[null,null,null,null,null,null,null,null,null,null,null,null,27,114000000,22700000,15880000,6250000,null,27,0,15900000,11120000,4365000]
[null,"Weapon",-2000000,null,null,null,-200000,null,null,-0.1,null,null,28,154000000,30700000,18380000,9200000,null,28,0,21500500,12860000,6450000]
[null,"Boots",null,null,-1000000,-0.05,-200000,null,null,null,null,null,29,206950000,41400000,24800000,12400000,null,29,0]
[null,"Pendant",null,null,-1000000,null,null,-0.05,-400000,null,null,null,30,279000000,55800000,33600000,16750000,null,30,0]
[null,"ORANGE",{"$f":"SUM(C26:C32)","v":-6000000},-0.1,-3000000,-0.1,-600000,-0.1,-1200000,-0.1,null,null,31,377000000,75000000,45200000,22600000,null,31,0,49200000,23600000,11750000]
[null,null,null,null,null,null,null,null,null,null,null,null,32,377000000,75000000,45200000,22600000,null,32,0]
[null,"Retribution Armor",null,null,null,null,null,null,null,null,null,null,33,null,114300000,null,null,null,33,0,69400000,23600000,11750000]
[null,null,"food",null,"wood",null,"Silver",null,"Iron",null,null,null,34,null,null,null,null,null,34,0]
[null,"Helm",null,null,-2000000,-0.1,null,null,-800000,null,null,null,35,null,null,null,null,null,35,0]
[null,"Armor",-4000000,-0.2,null,null,-400000]
[null,"Ring",-4000000,null,null,null,null,-0.1,-800000]
[]
[null,"Weapon",-4000000,null,null,null,-400000,null,null,-0.2]
[null,"Boots",null,null,-2000000,-0.1,-400000]
[null,"Pendant",-2000000,null,null,null,null,-0.1,-800000]
[null,"Retribution",{"$f":"SUM(C37:C43)","v":-14000000},{"$f":"SUM(D37:D43)","v":-0.2},-4000000,-0.2,-1200000,-0.2,-2400000,-0.2]
[]
[null,"NONE",0,0,0,0,0,0,0,0]