{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Simulator","Datenbasis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":2,"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":"1904"}

{"sheet":"Simulator","index":0,"n_rows":47,"n_cols":35,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,31,10,34],[9,15,9,34],[35,7,41,9],[10,26,10,27],[10,28,10,29],[10,22,10,25],[2,2,3,7],[7,2,8,11],[8,13,8,14],[9,13,9,14],[9,2,9,6],[4,3,4,4],[4,5,4,6],[9,7,9,9],[9,10,9,12],[35,2,42,2],[42,3,42,14],[11,2,16,2],[23,2,28,2],[29,2,34,2],[17,2,22,2],[28,3,28,14],[34,3,34,14],[16,3,16,14],[22,3,22,14],[47,10,47,14],[48,1,48,14],[43,2,47,2],[47,3,47,6],[43,7,47,8],[43,10,43,11],[43,12,43,14],[44,12,44,14],[45,12,45,14],[46,12,46,14]]}
[]
[]
[null,null,"LofD-Kampfsimulator"]
[]
[null,null,null,"by Voidhawk ",null,"Version 1.3.3"]
[null,null,null,"letzte Änderung:","2012-11-10"]
[]
[null,null,"Kampfboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Spieltyp"]
[null,null,"Einheitenstatistiken",null,null,null,null,"Angreifer",null,null,"Verteidiger",null,null,null,null,"Versteckt"]
[null,null,"Typ","Einheitenname","Angriff","Ausdauer","Reichweite","Anzahl",null,"Verluste","Anzahl",null,"Verluste","Angriff","Ausdauer",null,null,"Angriff","Ausdauer","Angriff","Ausdauer",null,"UnitStats",null,null,null,"AttackerStats",null,"DefenderStats",null,null,"Speicher"]
[null,null,"Fusssoldaten",{"$f":"INDEX(Datenbasis!C16:I20,1,1)","v":"Krieger"},{"$f":"INDEX(Datenbasis!C16:I20,1,2)","v":7},{"$f":"INDEX(Datenbasis!C16:I20,1,3)","v":35},{"$f":"INDEX(Datenbasis!C16:I20,1,4)","v":1},0,0,0,0,0,0,{"$f":"INDEX(Datenbasis!C16:I20,1,2)*(1+attBoni)","v":9.1},{"$f":"INDEX(Datenbasis!C16:I20,1,3)*(1+defBoni)","v":61.25},null,null,{"$f":"E12*H12","v":0},{"$f":"F12*H12","v":0},{"$f":"N12*K12","v":0},{"$f":"O12*K12","v":0},"Name","Angriff Basis","Ausdauer Basis","Reichweite","KillID","Anzahl","Anzahl Temp","Anzahl","Anzahl Temp",null,"Angreifer Anzahl","Verteidiger Anzahl","Angreifer Verluste","Verteidiger Verluste"]
[null,null,null,{"$f":"INDEX(Datenbasis!C16:I20,2,1)","v":"Kurzschwertkämpfer"},{"$f":"INDEX(Datenbasis!C16:I20,2,2)","v":9},{"$f":"INDEX(Datenbasis!C16:I20,2,3)","v":60},{"$f":"INDEX(Datenbasis!C16:I20,2,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C16:I20,2,2)*(1+attBoni)","v":11.700000000000001},{"$f":"INDEX(Datenbasis!C16:I20,2,3)*(1+defBoni)","v":105},null,null,{"$f":"E13*H13","v":0},{"$f":"F13*H13","v":0},{"$f":"N13*K13","v":0},{"$f":"O13*K13","v":0},{"$f":"D12","v":"Krieger"},7,35,1,{"$f":"Datenbasis!I16","v":2},{"$f":"H12","v":0},0,{"$f":"K12","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C16:I20,3,1)","v":"Lanzenträger"},{"$f":"INDEX(Datenbasis!C16:I20,3,2)","v":15},{"$f":"INDEX(Datenbasis!C16:I20,3,3)","v":45},{"$f":"INDEX(Datenbasis!C16:I20,3,4)","v":2},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C16:I20,3,2)*(1+attBoni)","v":19.5},{"$f":"INDEX(Datenbasis!C16:I20,3,3)*(1+defBoni)","v":78.75},null,null,{"$f":"E14*H14","v":0},{"$f":"F14*H14","v":0},{"$f":"N14*K14","v":0},{"$f":"O14*K14","v":0},"Kurzschwertkämpfer",9,60,1,{"$f":"Datenbasis!I17","v":3},{"$f":"H13","v":0},0,{"$f":"K13","v":0},0,null,0,0,-3,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C16:I20,4,1)","v":"Schwertmeister"},{"$f":"INDEX(Datenbasis!C16:I20,4,2)","v":30},{"$f":"INDEX(Datenbasis!C16:I20,4,3)","v":120},{"$f":"INDEX(Datenbasis!C16:I20,4,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C16:I20,4,2)*(1+attBoni)","v":39},{"$f":"INDEX(Datenbasis!C16:I20,4,3)*(1+defBoni)","v":210},null,null,{"$f":"E15*H15","v":0},{"$f":"F15*H15","v":0},{"$f":"N15*K15","v":0},{"$f":"O15*K15","v":0},"Lanzenträger",15,45,2,{"$f":"Datenbasis!I18","v":10},{"$f":"H14","v":0},0,{"$f":"K14","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C16:I20,5,1)","v":"Crusader"},{"$f":"INDEX(Datenbasis!C16:I20,5,2)","v":40},{"$f":"INDEX(Datenbasis!C16:I20,5,3)","v":180},{"$f":"INDEX(Datenbasis!C16:I20,5,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C16:I20,5,2)*(1+attBoni)","v":52},{"$f":"INDEX(Datenbasis!C16:I20,5,3)*(1+defBoni)","v":315},null,null,{"$f":"E16*H16","v":0},{"$f":"F16*H16","v":0},{"$f":"N16*K16","v":0},{"$f":"O16*K16","v":0},"Schwertmeister",30,120,1,{"$f":"Datenbasis!I19","v":6},{"$f":"H15","v":0},0,{"$f":"K15","v":0},0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crusader",40,180,1,{"$f":"Datenbasis!I20","v":7},{"$f":"H16","v":0},0,{"$f":"K16","v":0},0,null,0,0,0,0]
[null,null,"Reiterei",{"$f":"INDEX(Datenbasis!C21:I25,1,1)","v":"Leichte Kavallerie"},{"$f":"INDEX(Datenbasis!C21:I25,1,2)","v":8},{"$f":"INDEX(Datenbasis!C21:I25,1,3)","v":40},{"$f":"INDEX(Datenbasis!C21:I25,1,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C21:I25,1,2)*(1+attBoni)","v":10.4},{"$f":"INDEX(Datenbasis!C21:I25,1,3)*(1+defBoni)","v":70},null,null,{"$f":"E18*H18","v":0},{"$f":"F18*H18","v":0},{"$f":"N18*K18","v":0},{"$f":"O18*K18","v":0},{"$f":"D18","v":"Leichte Kavallerie"},8,40,1,{"$f":"Datenbasis!I21","v":4},{"$f":"H18","v":0},0,{"$f":"K18","v":0},0,null,0,3,0,-2]
[null,null,null,{"$f":"INDEX(Datenbasis!C21:I25,2,1)","v":"Bogenreiter"},{"$f":"INDEX(Datenbasis!C21:I25,2,2)","v":12},{"$f":"INDEX(Datenbasis!C21:I25,2,3)","v":50},{"$f":"INDEX(Datenbasis!C21:I25,2,4)","v":2},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C21:I25,2,2)*(1+attBoni)","v":15.600000000000001},{"$f":"INDEX(Datenbasis!C21:I25,2,3)*(1+defBoni)","v":87.5},null,null,{"$f":"E19*H19","v":0},{"$f":"F19*H19","v":0},{"$f":"N19*K19","v":0},{"$f":"O19*K19","v":0},"Bogenreiter",12,50,2,{"$f":"Datenbasis!I22","v":11},{"$f":"H19","v":0},0,{"$f":"K19","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C21:I25,3,1)","v":"Schwere Kavallerie"},{"$f":"INDEX(Datenbasis!C21:I25,3,2)","v":25},{"$f":"INDEX(Datenbasis!C21:I25,3,3)","v":120},{"$f":"INDEX(Datenbasis!C21:I25,3,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C21:I25,3,2)*(1+attBoni)","v":32.5},{"$f":"INDEX(Datenbasis!C21:I25,3,3)*(1+defBoni)","v":210},null,null,{"$f":"E20*H20","v":0},{"$f":"F20*H20","v":0},{"$f":"N20*K20","v":0},{"$f":"O20*K20","v":0},"Schwere Kavallerie",25,120,1,{"$f":"Datenbasis!I23","v":5},{"$f":"H20","v":0},0,{"$f":"K20","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C21:I25,4,1)","v":"Ritter"},{"$f":"INDEX(Datenbasis!C21:I25,4,2)","v":38},{"$f":"INDEX(Datenbasis!C21:I25,4,3)","v":170},{"$f":"INDEX(Datenbasis!C21:I25,4,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C21:I25,4,2)*(1+attBoni)","v":49.4},{"$f":"INDEX(Datenbasis!C21:I25,4,3)*(1+defBoni)","v":297.5},null,null,{"$f":"E21*H21","v":0},{"$f":"F21*H21","v":0},{"$f":"N21*K21","v":0},{"$f":"O21*K21","v":0},"Ritter",38,170,1,{"$f":"Datenbasis!I24","v":8},{"$f":"H21","v":0},0,{"$f":"K21","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C21:I25,5,1)","v":"Ordensritter"},{"$f":"INDEX(Datenbasis!C21:I25,5,2)","v":38},{"$f":"INDEX(Datenbasis!C21:I25,5,3)","v":200},{"$f":"INDEX(Datenbasis!C21:I25,5,4)","v":2},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C21:I25,5,2)*(1+attBoni)","v":49.4},{"$f":"INDEX(Datenbasis!C21:I25,5,3)*(1+defBoni)","v":350},null,null,{"$f":"E22*H22","v":0},{"$f":"F22*H22","v":0},{"$f":"N22*K22","v":0},{"$f":"O22*K22","v":0},"Ordensritter",38,200,2,{"$f":"Datenbasis!I25","v":12},{"$f":"H22","v":0},0,{"$f":"K22","v":0},0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D24","v":"Speerwerfer"},7,20,3,{"$f":"Datenbasis!I26","v":15},{"$f":"H24","v":0},0,{"$f":"K24","v":0},0,null,0,0,0,0]
[null,null,"Fernkampfeinheiten",{"$f":"INDEX(Datenbasis!C26:I30,1,1)","v":"Speerwerfer"},{"$f":"INDEX(Datenbasis!C26:I30,1,2)","v":7},{"$f":"INDEX(Datenbasis!C26:I30,1,3)","v":20},{"$f":"INDEX(Datenbasis!C26:I30,1,4)","v":3},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C26:I30,1,2)*(1+attBoni)","v":9.1},{"$f":"INDEX(Datenbasis!C26:I30,1,3)*(1+defBoni)","v":35},null,null,{"$f":"E24*H24","v":0},{"$f":"F24*H24","v":0},{"$f":"N24*K24","v":0},{"$f":"O24*K24","v":0},"Bogenschütze",10,28,3,{"$f":"Datenbasis!I27","v":16},{"$f":"H25","v":0},0,{"$f":"K25","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C26:I30,2,1)","v":"Bogenschütze"},{"$f":"INDEX(Datenbasis!C26:I30,2,2)","v":10},{"$f":"INDEX(Datenbasis!C26:I30,2,3)","v":28},{"$f":"INDEX(Datenbasis!C26:I30,2,4)","v":3},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C26:I30,2,2)*(1+attBoni)","v":13},{"$f":"INDEX(Datenbasis!C26:I30,2,3)*(1+defBoni)","v":49},null,null,{"$f":"E25*H25","v":0},{"$f":"F25*H25","v":0},{"$f":"N25*K25","v":0},{"$f":"O25*K25","v":0},"Armbrustschütze",18,44,4,{"$f":"Datenbasis!I28","v":20},{"$f":"H26","v":0},0,{"$f":"K26","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C26:I30,3,1)","v":"Armbrustschütze"},{"$f":"INDEX(Datenbasis!C26:I30,3,2)","v":18},{"$f":"INDEX(Datenbasis!C26:I30,3,3)","v":44},{"$f":"INDEX(Datenbasis!C26:I30,3,4)","v":4},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C26:I30,3,2)*(1+attBoni)","v":23.400000000000002},{"$f":"INDEX(Datenbasis!C26:I30,3,3)*(1+defBoni)","v":77},null,null,{"$f":"E26*H26","v":0},{"$f":"F26*H26","v":0},{"$f":"N26*K26","v":0},{"$f":"O26*K26","v":0},"Langbogenschütze",32,75,5,{"$f":"Datenbasis!I29","v":23},{"$f":"H27","v":0},0,{"$f":"K27","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C26:I30,4,1)","v":"Langbogenschütze"},{"$f":"INDEX(Datenbasis!C26:I30,4,2)","v":32},{"$f":"INDEX(Datenbasis!C26:I30,4,3)","v":75},{"$f":"INDEX(Datenbasis!C26:I30,4,4)","v":5},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C26:I30,4,2)*(1+attBoni)","v":41.6},{"$f":"INDEX(Datenbasis!C26:I30,4,3)*(1+defBoni)","v":131.25},null,null,{"$f":"E27*H27","v":0},{"$f":"F27*H27","v":0},{"$f":"N27*K27","v":0},{"$f":"O27*K27","v":0},"Musketier",48,120,4,{"$f":"Datenbasis!I30","v":21},{"$f":"H28","v":0},0,{"$f":"K28","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C26:I30,5,1)","v":"Musketier"},{"$f":"INDEX(Datenbasis!C26:I30,5,2)","v":48},{"$f":"INDEX(Datenbasis!C26:I30,5,3)","v":120},{"$f":"INDEX(Datenbasis!C26:I30,5,4)","v":4},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C26:I30,5,2)*(1+attBoni)","v":62.400000000000006},{"$f":"INDEX(Datenbasis!C26:I30,5,3)*(1+defBoni)","v":210},null,null,{"$f":"E28*H28","v":0},{"$f":"F28*H28","v":0},{"$f":"N28*K28","v":0},{"$f":"O28*K28","v":0},{"$f":"D30","v":"Spionageballon"},0.1,0.1,1,{"$f":"Datenbasis!I31","v":9},{"$f":"H30","v":0},0,{"$f":"K30","v":0},0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belagerungsturm",5,140,1,{"$f":"Datenbasis!I32","v":1},{"$f":"H31","v":0},0,{"$f":"K31","v":0},0,null,0,0,0,0]
[null,null,"Maschinen",{"$f":"INDEX(Datenbasis!C31:I35,1,1)","v":"Spionageballon"},{"$f":"INDEX(Datenbasis!C31:I35,1,2)","v":0.1},{"$f":"INDEX(Datenbasis!C31:I35,1,3)","v":0.1},{"$f":"INDEX(Datenbasis!C31:I35,1,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C31:I35,1,2)*(1+attBoni)","v":0.13},{"$f":"INDEX(Datenbasis!C31:I35,1,3)*(1+defBoni)","v":0.17500000000000002},null,null,{"$f":"E30*H30","v":0},{"$f":"F30*H30","v":0},{"$f":"N30*K30","v":0},{"$f":"O30*K30","v":0},"Katapult",70,20,5,{"$f":"Datenbasis!I33","v":22},{"$f":"H32","v":0},0,{"$f":"K32","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C31:I35,2,1)","v":"Belagerungsturm"},{"$f":"INDEX(Datenbasis!C31:I35,2,2)","v":5},{"$f":"INDEX(Datenbasis!C31:I35,2,3)","v":140},{"$f":"INDEX(Datenbasis!C31:I35,2,4)","v":1},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C31:I35,2,2)*(1+attBoni)","v":6.5},{"$f":"INDEX(Datenbasis!C31:I35,2,3)*(1+defBoni)","v":245},null,null,{"$f":"E31*H31","v":0},{"$f":"F31*H31","v":0},{"$f":"N31*K31","v":0},{"$f":"O31*K31","v":0},"Flugschiff",30,120,3,{"$f":"Datenbasis!I34","v":17},{"$f":"H33","v":0},0,{"$f":"K33","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C31:I35,3,1)","v":"Katapult"},{"$f":"INDEX(Datenbasis!C31:I35,3,2)","v":70},{"$f":"INDEX(Datenbasis!C31:I35,3,3)","v":20},{"$f":"INDEX(Datenbasis!C31:I35,3,4)","v":5},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C31:I35,3,2)*(1+attBoni)","v":91},{"$f":"INDEX(Datenbasis!C31:I35,3,3)*(1+defBoni)","v":35},null,null,{"$f":"E32*H32","v":0},{"$f":"F32*H32","v":0},{"$f":"N32*K32","v":0},{"$f":"O32*K32","v":0},"Holzpanzer",110,350,2,{"$f":"Datenbasis!I35","v":13},{"$f":"H34","v":0},0,{"$f":"K34","v":0},0,null,0,0,0,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C31:I35,4,1)","v":"Flugschiff"},{"$f":"INDEX(Datenbasis!C31:I35,4,2)","v":30},{"$f":"INDEX(Datenbasis!C31:I35,4,3)","v":120},{"$f":"INDEX(Datenbasis!C31:I35,4,4)","v":3},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C31:I35,4,2)*(1+attBoni)","v":39},{"$f":"INDEX(Datenbasis!C31:I35,4,3)*(1+defBoni)","v":210},null,null,{"$f":"E33*H33","v":0},{"$f":"F33*H33","v":0},{"$f":"N33*K33","v":0},{"$f":"O33*K33","v":0},{"$f":"D36","v":"kleiner Turm (Kampf)"},31,105,2,{"$f":"Datenbasis!I36","v":14},"-",null,{"$f":"K36","v":0},0,null,null,0,null,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C31:I35,5,1)","v":"Holzpanzer"},{"$f":"INDEX(Datenbasis!C31:I35,5,2)","v":110},{"$f":"INDEX(Datenbasis!C31:I35,5,3)","v":350},{"$f":"INDEX(Datenbasis!C31:I35,5,4)","v":2},0,null,0,0,null,0,{"$f":"INDEX(Datenbasis!C31:I35,5,2)*(1+attBoni)","v":143},{"$f":"INDEX(Datenbasis!C31:I35,5,3)*(1+defBoni)","v":612.5},null,null,{"$f":"E34*H34","v":0},{"$f":"F34*H34","v":0},{"$f":"N34*K34","v":0},{"$f":"O34*K34","v":0},"Verteidigungsturm (Kampf)",50,175,3,{"$f":"Datenbasis!I37","v":18},"-",null,{"$f":"K37","v":0},0,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe","Summe",null,null,"Wehrturm (Kampf)",75,400,3,{"$f":"Datenbasis!I38","v":19},"-",null,{"$f":"K38","v":0},0,null,null,0,null,0]
[null,null,"Verteidigungsgebäude",{"$f":"INDEX(Datenbasis!C36:I39,1,1)","v":"kleiner Turm (Kampf)"},{"$f":"INDEX(Datenbasis!C36:I39,1,2)*POWER(1+Datenbasis!D7,K47)","v":31},{"$f":"INDEX(Datenbasis!C36:I39,1,3)*POWER(1+Datenbasis!D6,K46)","v":105},{"$f":"INDEX(Datenbasis!C36:I39,1,4)","v":2},"N.A.",null,null,0,null,0,{"$f":"INDEX(Datenbasis!C36:I39,1,2)*POWER(1+Datenbasis!D7,K47)*(1+attBoni)","v":40.300000000000004},{"$f":"INDEX(Datenbasis!C36:I39,1,3)*POWER(1+Datenbasis!D6,K46)*(1+defBoni)","v":183.75},null,null,{"$f":"SUM(R12:R34)","v":0},{"$f":"SUM(S12:S34)","v":0},{"$f":"N36*K36","v":0},{"$f":"O36*K36","v":0},"Magierturm (Kampf)",300,160,5,{"$f":"Datenbasis!I39","v":24},"wallIndex",null,{"$f":"K39","v":0},0,null,null,0,null,0]
[null,null,null,{"$f":"INDEX(Datenbasis!C36:I39,2,1)","v":"Verteidigungsturm (Kampf)"},{"$f":"INDEX(Datenbasis!C36:I39,2,2)*POWER(1+Datenbasis!D7,K47)","v":50},{"$f":"INDEX(Datenbasis!C36:I39,2,3)*POWER(1+Datenbasis!D6,K46)","v":175},{"$f":"INDEX(Datenbasis!C36:I39,2,4)","v":3},null,null,null,0,null,0,{"$f":"INDEX(Datenbasis!C36:I39,2,2)*POWER(1+Datenbasis!D7,K47)*(1+attBoni)","v":65},{"$f":"INDEX(Datenbasis!C36:I39,2,3)*POWER(1+Datenbasis!D6,K46)*(1+defBoni)","v":306.25},null,null,null,null,0,0,{"$f":"D42","v":"keine Burg"},{"$f":"P42","v":0},{"$f":"Q42","v":0},{"$f":"G42","v":0},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,7)","v":99},{"$f":"Datenbasis!F8","v":1},null,{"$f":"K42","v":0},0,null,null,1]
[null,null,null,{"$f":"INDEX(Datenbasis!C36:I39,3,1)","v":"Wehrturm (Kampf)"},{"$f":"INDEX(Datenbasis!C36:I39,3,2)*POWER(1+Datenbasis!D7,K47)","v":75},{"$f":"INDEX(Datenbasis!C36:I39,3,3)*POWER(1+Datenbasis!D6,K46)","v":400},{"$f":"INDEX(Datenbasis!C36:I39,3,4)","v":3},null,null,null,0,null,0,{"$f":"INDEX(Datenbasis!C36:I39,3,2)*POWER(1+Datenbasis!D7,K47)*(1+attBoni)","v":97.5},{"$f":"INDEX(Datenbasis!C36:I39,3,3)*POWER(1+Datenbasis!D6,K46)*(1+defBoni)","v":700},null,null,null,null,0,0,{"$f":"D40","v":"Wehrmauer (Kampf)"},{"$f":"P40","v":140},{"$f":"Q40","v":300},{"$f":"G40","v":0},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,7)","v":0},{"$f":"Datenbasis!F6","v":13},null,{"$f":"K40","v":1},0,null,null,1]
[null,null,null,{"$f":"INDEX(Datenbasis!C36:I39,4,1)","v":"Magierturm (Kampf)"},{"$f":"INDEX(Datenbasis!C36:I39,4,2)*POWER(1+Datenbasis!D7,K47)","v":300},{"$f":"INDEX(Datenbasis!C36:I39,4,3)*POWER(1+Datenbasis!D6,K46)","v":160},{"$f":"INDEX(Datenbasis!C36:I39,4,4)","v":5},null,null,null,0,null,0,{"$f":"INDEX(Datenbasis!C36:I39,4,2)*POWER(1+Datenbasis!D7,K47)*(1+attBoni)","v":390},{"$f":"INDEX(Datenbasis!C36:I39,4,3)*POWER(1+Datenbasis!D6,K46)*(1+defBoni)","v":280},null,null,null,null,0,0,{"$f":"D41","v":"kein Burggraben"},{"$f":"N41","v":0},{"$f":"Q41","v":0},{"$f":"G41","v":0},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,7)","v":99},{"$f":"Datenbasis!F7","v":1},null,{"$f":"K41","v":0},null,null,null,1]
[null,null,null,{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,1)","v":"Wehrmauer (Kampf)"},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,5)*INDEX(Datenbasis!C56:D68,Datenbasis!F6,2)","v":0.3},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,6)*INDEX(Datenbasis!C56:D68,Datenbasis!F6,2)","v":0.75},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,4)","v":0},null,null,null,{"$f":"IF(Datenbasis!G6=1,0,1)","v":1},null,null,{"$f":"P40*(1+attBoni)","v":182},{"$f":"Q40*(1+defBoni)","v":525},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,2)*POWER(1+Datenbasis!D7,K47)","v":140},{"$f":"INDEX(Datenbasis!C40:I43,Datenbasis!G6,3)*POWER(1+Datenbasis!D6,K46)","v":300},null,null,182,525,null,null,null,null,null,"attUnitsLeft",{"$f":"SUM(AB13:AB32)","v":0},"defUnitsLeft",{"$f":"SUM(AD13:AD37)","v":0},null,"CarryAtt",28]
[null,null,null,{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,1)","v":"kein Burggraben"},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,5)","v":0},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,6)","v":0},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,4)","v":0},null,null,null,{"$f":"Datenbasis!F7-1","v":0},null,null,{"$f":"P41*(1+attBoni)","v":0},{"$f":"Q41*(1+defBoni)","v":0},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,2)*POWER(1+Datenbasis!D7,K47)","v":0},{"$f":"INDEX(Datenbasis!C44:I45,Datenbasis!F7,3)*POWER(1+Datenbasis!D6,K46)","v":0},null,null,0,0,"CarryAtt",0,null,null,null,null,null,null,null,null,"CarryDef",12]
[null,null,null,{"$f":"IF(Datenbasis!F8=2,Datenbasis!C47,Datenbasis!C46)","v":"keine Burg"},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,5)","v":0},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,6)","v":0},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,4)","v":0},null,null,null,{"$f":"Datenbasis!F8-1","v":0},null,null,{"$f":"P42*(1+attBoni)","v":0},{"$f":"Q42*(1+defBoni)","v":0},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,2)*POWER(1+Datenbasis!D7,K47)","v":0},{"$f":"INDEX(Datenbasis!C46:I47,Datenbasis!F8,3)*POWER(1+Datenbasis!D6,K46)","v":0},null,null,0,0,"CarryDef",0,null,null,null,null,null,null,null,null,"FightCount",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:E42)","v":0.3},{"$f":"SUM(F40:F42)","v":0.75},null,null,"Summe","Summe","FightCount",0,null,null,null,null,null,null,null,null,"wallDestroyed",true]
[null,null,"Statistik",null,"Angreifer","vs.","Verteidiger","Forschung",null,null,"Stufe",null,"Forschungsgebiet",null,null,null,null,null,null,{"$f":"SUM(T12:T42)","v":182},{"$f":"SUM(U12:U42)","v":525},"wallDestroyed",false]
[null,null,null,"Gesamtstärke",{"$f":"R36","v":0},"vs.",{"$f":"T44","v":182},null,null,null,0,null,{"$f":"Datenbasis!B5","v":"Wirtschaft Ausdauer"}]
[null,null,null,"Gesamtausdauer",{"$f":"S36","v":0},"vs.",{"$f":"U44","v":525},null,null,null,0,null,{"$f":"Datenbasis!B6","v":"Militärgebäude Ausdauer"}]
[null,null,null,null,"-","0 Schlacht(en)","-",null,null,null,0,null,{"$f":"Datenbasis!B7","v":"Militärgebäude Angriff"}]

{"sheet":"Datenbasis","index":1,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[14,15,15,15],[53,1,53,3],[13,1,13,8],[3,4,3,6],[15,1,19,1],[20,1,24,1],[14,16,15,16],[14,17,15,17],[12,11,13,17],[14,11,14,12],[14,13,15,13],[14,14,15,14],[35,1,46,1],[1,1,2,3],[3,1,3,3],[7,1,7,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[25,1,29,1],[30,1,34,1]]}
[]
[null,"Globale Variablen"]
[]
[null,"Forschungsboni",null,null,"Auswahl"]
[null,"Wirtschaft Ausdauer",null,0.2,"Spieltyp",1]
[null,"Militärgebäude Ausdauer",null,0.15,"Mauer",13,{"$f":"IF(F6<2,1,IF(F6<5,2,IF(F6<9,3,4)))","v":4}]
[null,"Militärgebäude Angriff",null,0.15,"BG",1]
[null,"Spieltypen",null,null,"Burg",1]
[null,"Typen","Angriffsstärke","Gebäudefaktor"]
[null,"Kampf",1,1]
[null,"Wirtschaft  ",1,1]
[null,"Diplomatie",1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Grundwerte Übersicht"]
[null,"Einheiten & Gebäude (Werte nach Spielauswahl)"]
[null,"Typ","Name","Angriff 100%","Ausdauer","Reichweite","Angriffsboni","Vert.-Boni","ID",null,null,"Einheiten / Gebäude",null,"Angriff","Ausdauer","Reichweite","Angriffs- bonus","Ausdauer- bonus"]
[null,"Fusssoldaten",{"$f":"M17","v":"Krieger"},{"$f":"N17","v":7},{"$f":"O17","v":35},{"$f":"P17","v":1},{"$f":"Q17","v":0},{"$f":"R17","v":0},{"$f":"L17","v":2},null,null,"Kill-Priorität","Name"]
[null,null,"Kurzschwertkämpfer",{"$f":"N18","v":9},60,1,0,0,3,null,null,2,"Krieger",7,35,1,0,0]
[null,null,"Lanzenträger",{"$f":"N19","v":15},45,2,0,0,10,null,null,3,"Kurzschwertkämpfer",9,60,1,0,0]
[null,null,"Schwertmeister",{"$f":"N20","v":30},120,1,0,0,6,null,null,10,"Lanzenträger",15,45,2,0,0]
[null,null,"Crusader",{"$f":"N21","v":40},180,1,0,0,7,null,null,6,"Schwertmeister",30,120,1,0,0]
[null,"Reiterei","Leichte Kavallerie",{"$f":"N22","v":8},40,1,0,0,4,null,null,7,"Crusader",40,180,1,0,0]
[null,null,"Bogenreiter",{"$f":"N23","v":12},50,2,0,0,11,null,null,4,"Leichte Kavallerie",8,40,1,0,0]
[null,null,"Schwere Kavallerie",{"$f":"N24","v":25},120,1,0,0,5,null,null,11,"Bogenreiter",12,50,2,0,0]
[null,null,"Ritter",{"$f":"N25","v":38},170,1,0,0,8,null,null,5,"Schwere Kavallerie",25,120,1,0,0]
[null,null,"Ordensritter",{"$f":"N26","v":38},200,2,0,0,12,null,null,8,"Ritter",38,170,1,0,0]
[null,"Fernkampfeinheiten","Speerwerfer",{"$f":"N27","v":7},20,3,0,0,15,null,null,12,"Ordensritter",38,200,2,0,0]
[null,null,"Bogenschütze",{"$f":"N28","v":10},28,3,0,0,16,null,null,15,"Speerwerfer",7,20,3,0,0]
[null,null,"Armbrustschütze",{"$f":"N29","v":18},44,4,0,0,20,null,null,16,"Bogenschütze",10,28,3,0,0]
[null,null,"Langbogenschütze",{"$f":"N30","v":32},75,5,0,0,23,null,null,20,"Armbrustschütze",18,44,4,0,0]
[null,null,"Musketier",{"$f":"N31","v":48},120,4,0,0,21,null,null,23,"Langbogenschütze",32,75,5,0,0]
[null,"Maschinen","Spionageballon",{"$f":"N32","v":0.1},0.1,1,0,0,9,null,null,21,"Musketier",48,120,4,0,0]
[null,null,"Belagerungsturm",{"$f":"N33","v":5},140,1,0,0,1,null,null,9,"Spionageballon",0.1,0.1,1,0,0]
[null,null,"Katapult",{"$f":"N34","v":70},20,5,0,0,22,null,null,1,"Belagerungsturm",5,140,1,0,0]
[null,null,"Flugschiff",{"$f":"N35","v":30},120,3,0,0,17,null,null,22,"Katapult",70,20,5,0,0]
[null,null,"Holzpanzer",{"$f":"N36","v":110},350,2,0,0,13,null,null,17,"Flugschiff",30,120,3,0,0]
[null,"Militärgebäude",{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),2)","v":"kleiner Turm (Kampf)"},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),3)","v":31},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),4)","v":105},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),5)","v":2},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),6)","v":0},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),7)","v":0},{"$f":"INDEX(L37:R39,IF(F5=1,3,F5-1),1)","v":14},null,null,13,"Holzpanzer",110,350,2,0,0]
[null,null,{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),2)","v":"Verteidigungsturm (Kampf)"},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),3)","v":50},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),4)","v":175},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),5)","v":3},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),6)","v":0},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),7)","v":0},{"$f":"INDEX(L40:R42,IF(F5=1,3,F5-1),1)","v":18},null,null,14,"kleiner Turm (Wirtschaft)",20,175,2,0,0]
[null,null,{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),2)","v":"Wehrturm (Kampf)"},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),3)","v":75},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),4)","v":400},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),5)","v":3},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),6)","v":0},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),7)","v":0},{"$f":"INDEX(L43:R45,IF(F5=1,3,F5-1),1)","v":19},null,null,14,"kleiner Turm (Diplomatie)",20,175,2,0,0]
[null,null,{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),2)","v":"Magierturm (Kampf)"},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),3)","v":300},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),4)","v":160},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),5)","v":5},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),6)","v":0},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),7)","v":0},{"$f":"INDEX(L46:R48,IF(F5=1,3,F5-1),1)","v":24},null,null,14,"kleiner Turm (Kampf)",31,105,2,0,0]
[null,null,{"$f":"M49","v":"keine Mauer"},{"$f":"N49","v":0},{"$f":"O49","v":0},0,0,0,{"$f":"L49","v":99},null,null,18,"Verteidigungsturm (Wirtschaft)",40,300,3,0,0]
[null,null,{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),2)","v":"Palisadenzaun (Kampf)"},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),3)","v":20},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),4)","v":75},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),5)","v":0},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),6)","v":0.1},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),7)","v":0.25},{"$f":"INDEX(L50:R52,IF(F5=1,3,F5-1),1)","v":0},null,null,18,"Verteidigungsturm (Diplomatie)",40,350,3,0,0]
[null,null,{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),2)","v":"Mauer (Kampf)"},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),3)","v":60},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),4)","v":150},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),5)","v":0},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),6)","v":0.2},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),7)","v":0.5},{"$f":"INDEX(L53:R55,IF(F5=1,3,F5-1),1)","v":0},null,null,18,"Verteidigungsturm (Kampf)",50,175,3,0,0]
[null,null,{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),2)","v":"Wehrmauer (Kampf)"},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),3)","v":140},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),4)","v":300},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),5)","v":0},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),6)","v":0.3},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),7)","v":0.75},{"$f":"INDEX(L56:R58,IF(F5=1,3,F5-1),1)","v":0},null,null,19,"Wehrturm (Wirtschaft)",50,600,3,0,0]
[null,null,{"$f":"M59","v":"kein Burggraben"},{"$f":"N59","v":0},{"$f":"O59","v":0},{"$f":"P59","v":0},{"$f":"Q59","v":0},{"$f":"R59","v":0},{"$f":"L59","v":99},null,null,19,"Wehrturm (Diplomatie)",50,550,3,0,0]
[null,null,{"$f":"M60","v":"Burggraben"},{"$f":"N60","v":0},{"$f":"O60","v":0},{"$f":"P60","v":0},{"$f":"Q60","v":0.25},{"$f":"R60","v":0.25},{"$f":"L60","v":99},null,null,19,"Wehrturm (Kampf)",75,400,3,0,0]
[null,null,{"$f":"M61","v":"keine Burg"},{"$f":"N61","v":0},{"$f":"O61","v":0},{"$f":"P61","v":0},{"$f":"Q61","v":0},{"$f":"R61","v":0},{"$f":"L61","v":99},null,null,24,"Magierturm (Wirtschaft)",200,200,5,0,0]
[null,null,{"$f":"INDEX(L62:R64,F5,2)","v":"Burg (Wirtschaft)"},{"$f":"INDEX(L62:R64,F5,3)","v":50},{"$f":"INDEX(L62:R64,IF(F5=1,3,F5),4)","v":3000},{"$f":"INDEX(L62:R64,IF(F5=1,3,F5),5)","v":5},{"$f":"INDEX(L62:R64,IF(F5=1,3,F5),6)","v":0.25},{"$f":"INDEX(L62:R64,IF(F5=1,3,F5),7)","v":0.25},{"$f":"INDEX(L62:R64,IF(F5=1,3,F5),1)","v":25},null,null,24,"Magierturm (Diplomatie)",250,150,5,0,0]
[null,null,null,null,null,null,null,null,null,null,null,24,"Magierturm (Kampf)",300,160,5,0,0]
[null,null,null,null,null,null,null,null,null,null,null,99,"keine Mauer",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,0,"Palisadenzaun (Wirtschaft)",20,300,0,0.1,0.25]
[null,null,null,null,null,null,null,null,null,null,null,0,"Palisadenzaun (Diplo)",20,150,0,0.1,0.25]
[null,null,null,null,null,null,null,null,null,null,null,0,"Palisadenzaun (Kampf)",20,75,0,0.1,0.25]
[null,null,null,null,null,null,null,null,null,null,null,0,"Mauer (Wirtschaft)",40,500,0,0.2,0.5]
[null,"Beschädigungsstufen der Mauern",null,null,null,null,null,null,null,null,null,0,"Mauer (Diplo)",40,300,0,0.2,0.5]
[null,"lfd. Nr.","MauerStufen","Wirkung",null,null,null,null,null,null,null,0,"Mauer (Kampf)",60,150,0,0.2,0.5]
[null,1,"keine Mauer",0,null,null,null,null,null,null,null,0,"Wehrmauer (Wirtschaft)",60,1000,0,0.3,0.75]
[null,2,"Palisade 40%",0.4,null,null,null,null,null,null,null,0,"Wehrmauer (Diplo)",60,400,0,0.3,0.75]
[null,3,"Palisade 75%",0.75,null,null,null,null,null,null,null,0,"Wehrmauer (Kampf)",140,300,0,0.3,0.75]
[null,4,"Palisade 100%",1,null,null,null,null,null,null,null,99,"kein Burggraben",0,0,0,0,0]
[null,5,"Mauer 40%",0.4,null,null,null,null,null,null,null,99,"Burggraben",0,0,0,0.25,0.25]
[null,6,"Mauer 65%",0.65,null,null,null,null,null,null,null,99,"keine Burg",0,0,0,0,0]
[null,7,"Mauer 85%",0.85,null,null,null,null,null,null,null,25,"Burg (Wirtschaft)",50,3000,5,0.25,0.25]
[null,8,"Mauer 100%",1,null,null,null,null,null,null,null,25,"Burg (Diplomatie)",25,1000,5,0.25,0.25]
[null,9,"Wehrm. 30%",0.3,null,null,null,null,null,null,null,25,"Burg (Kampf)",50,3000,5,0.25,0.25]
[null,10,"Wehrm. 55%",0.55000000000000004]
[null,11,"Wehrm. 75%",0.75]
[null,12,"Wehrm. 90%",0.9]
[null,13,"Wehrm. 100%",1]
[null,1,"kein Burggraben",0]
[null,2,"Burggraben",1]
[null,1,"keine Burg",0]
[null,2,"Burg",0.25]