{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["tableau d'armée","Feuil1"],"not_rendered":{"charts":0,"images":2,"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":"tableau d'armée","index":0,"n_rows":95,"n_cols":27,"rows_kept":95,"cut":false,"hidden":false,"merged":[[24,22,24,25],[23,22,23,25],[19,22,20,25],[17,22,18,25],[21,22,22,25],[2,22,2,25],[1,22,1,25],[12,22,12,23],[13,22,13,23],[14,22,14,23],[5,22,5,23],[3,22,3,23],[4,22,4,23],[6,22,6,23],[7,22,7,23],[8,22,8,23],[9,22,9,23],[10,22,10,23],[11,22,11,23],[1,3,1,20],[64,7,64,8],[35,15,36,15],[31,5,33,14],[38,6,38,8],[38,9,38,10],[35,16,36,17],[32,19,32,20],[32,16,32,17],[34,16,34,17],[34,19,34,20],[35,19,36,20],[61,7,61,8],[63,7,63,8],[62,7,62,8],[38,16,39,20],[40,16,41,20],[43,16,44,20],[45,16,46,20],[47,16,47,20],[48,16,49,20],[50,16,51,20],[31,19,31,20],[31,16,31,17],[53,16,54,20],[55,16,56,20],[28,16,28,17],[29,16,29,17],[28,19,28,20],[30,16,30,17],[30,19,30,20],[29,19,29,20],[45,6,45,8],[46,6,46,8],[47,6,47,8],[48,6,48,8],[49,6,49,8],[41,6,41,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[39,6,39,8],[36,5,36,8],[35,5,35,8],[35,2,35,3],[36,2,36,3],[37,1,37,3],[38,1,38,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[19,1,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[66,7,66,8],[67,7,67,8],[68,7,68,8],[65,5,65,8],[50,6,50,8],[51,6,51,8],[52,6,52,8],[53,6,53,8],[54,6,54,8],[56,5,56,7],[57,5,57,6],[58,5,58,7],[59,5,59,7],[22,16,22,17],[25,16,25,17],[22,19,22,20],[25,19,25,20],[29,5,29,14],[19,7,19,9],[28,5,28,14],[25,10,26,12],[22,7,22,9],[25,7,25,9],[20,10,20,12],[22,10,22,12],[23,10,23,12],[10,6,10,10],[19,16,19,17],[3,16,17,20],[8,6,8,10],[11,6,11,10],[12,6,12,10],[13,6,13,10],[3,6,3,10],[4,6,4,10],[5,6,5,10],[6,6,6,10],[7,6,7,10],[9,6,9,10],[19,10,19,12],[15,6,15,10],[16,6,16,10],[17,6,17,10],[14,6,14,10],[19,19,19,20]]}
[]
[null,"DATE :",null,"2013-11-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tableau de calcul perso"]
[]
[null,"Prévision de ponte : \n(notez si dessous)",null,"pourcentage de votre armée sur 100% JSN\n(à titre d'indication)",null,"Actuellement j'ai : \n(notez si dessous)","Je lance une ponte de : \n(notez si dessous)",null,null,null,null,null,"dénomination :",null,"TOTAL FINAL APRES PONTE",null,"\n\nidéal de ponte \n(selon i-sork)\n\n\n-Début de serveur-\n\nChasseur :\nSur 100% de JSN\n80 à 90% de JS\n20 à 30% d'ARTI\n\n",null,null,null,null,null,"calcul perso :",null,"sur","soit"]
[null,0,null,{"$f":"100","v":100},"%",167923,0,null,null,null,null,null,"jeunes Soldate naines",null,{"$f":"SUM(F5:G5)","v":167923},null,null,null,null,null,null,null,"JSN =",null,1,{"$f":"O5","v":167923}]
[null,0,null,{"$f":"O6*100/O5","v":23.218379852670569},"%",38989,0,null,null,null,null,null,"Soldates Naines",null,38989,null,null,null,null,null,null,null,"vous devez pondre"]
[null,0,null,{"$f":"O7*100/O5","v":4.9087974845613767},"%",8243,0,null,null,null,null,null,"Naines d'Elites",null,8243,null,null,null,null,null,null,null,{"$f":"Z7-W22","v":105909.70000000001},null,0.9,{"$f":"Z5*90/100","v":151130.70000000001}]
[null,27286,null,{"$f":"O8*100/O5","v":63.750647618253602},"%",107052,0,null,null,null,null,null,"Jeunes Soldates",null,107052,null,null,null,null,null,null,null,{"$f":"Z8-W22","v":89117.4},null,0.8,{"$f":"Z5*80/100","v":134338.4}]
[null,0,null,{"$f":"F9*100/O5","v":11.597577461098242},"%",19475,0,null,null,null,null,null,"Soldates",null,19475,null,null,null,null,null,null,null,{"$f":"Z9-W22","v":72325.100000000006},null,0.7,{"$f":"Z5*70/100","v":117546.1}]
[null,0,null,{"$f":"O10*100/O5","v":0},"%",0,0,null,null,null,null,null,"Concierges",null,0,null,null,null,null,null,null,null,{"$f":"Z10-W22","v":55532.800000000003},null,0.6,{"$f":"Z5*60/100","v":100753.8}]
[null,0,null,{"$f":"O11*100/O5","v":0},"%",0,0,null,null,null,null,null,"Concierges d'élites",null,0,null,null,null,null,null,null,null,{"$f":"Z11-W22","v":38740.5},null,0.5,{"$f":"Z5*50/100","v":83961.5}]
[null,21948,null,{"$f":"O12*100/O5","v":26.929604640222006},"%",45221,0,null,null,null,null,null,"Artilleuses",null,45221,null,null,null,null,null,null,null,{"$f":"Z12-W22","v":21948.199999999997},null,0.4,{"$f":"Z5*40/100","v":67169.2}]
[null,0,null,{"$f":"O13*100/O5","v":8.5711903670134522},"%",14393,0,null,null,null,null,null,"Artilleuses d'élites",null,14393,null,null,null,null,null,null,null,{"$f":"Z13-W22","v":5155.9000000000015},null,0.3,{"$f":"Z5*30/100","v":50376.9}]
[null,0,null,{"$f":"O14*100/O5","v":3.28364786241313},"%",5514,0,null,null,null,null,null,"Soldates d'élites",null,{"$f":"SUM(F14:G14)","v":5514},null,null,null,null,null,null,null,{"$f":"Z14-W22","v":-11636.400000000001},null,0.2,{"$f":"Z5*20/100","v":33584.6}]
[null,0,null,{"$f":"O15*100/O5","v":0},"%",0,0,null,null,null,null,null,"Tanks ",null,0,null,null,null,null,null,null,null,{"$f":"Z15-W22","v":-28428.7},null,0.1,{"$f":"Z5*10/100","v":16792.3}]
[null,0,null,{"$f":"O16*100/O5","v":0},"%",0,0,null,null,null,null,null,"Tanks d'élites",null,{"$f":"SUM(F16:G16)","v":0}]
[null,0,null,{"$f":"O17*100/O5","v":0},"%",0,0,null,null,null,null,null,"Tueuses ",null,0]
[null,0,null,{"$f":"O18*100/O5","v":0},"%",0,0,null,null,null,null,null,"Tueuses d'élites",null,0,null,null,null,null,null,null,null,"LISTE DEROULANTE SI DESSOUS \n- je souhaite pondre de la : -"]
[]
[null,"mon ancienne armée sauvegarde ",null,null,null,"FDF brut",null,"bonus AR",null,null,"ARME NIVEAU (notez si dessous)",null,null,null,"TOTAL DE FDF",null,"diff : fdf/vie en %",null,null,"diff : fdf/def en %",null,null,"Artilleuses",null,null,null,"<="]
[null,0,"jeunes Soldate naines",null,null,{"$f":"(O5*3)+(O6*5)+(O7*7)+(O8*10)+(O9*15)+(O10*1)+(O11*1)+(O12*30)+(O13*35)+(O14*24)+(O15*55)+(O16*80)+(O17*50)+(O18*55)","v":4111781},null,"(+",{"$f":"O21-F21","v":4522959.0999999996},")",11,null,null,null,{"$f":"F21*(10+K21)/10","v":8634740.0999999996},null,{"$f":"((O21-O24)/O24)*100","v":-12.822625938473504},"%",null,{"$f":"((O21-O27)/O27)*100","v":44.700060423938844},"%",null,null,null,null,null,"<="]
[null,0,"Soldates Naines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W20=\"\",\"\",VLOOKUP(W20,'tableau d''armée'!M5:O18,3,0))","v":45221}]
[null,0,"Naines d'Elites",null,null,"VIE brut",null,"bonus BOU",null,null,"BOUCLIER NIVEAU (notez si dessous)",null,null,null,"TOTAL DE VIE \nen attaque ",null,"diff : vie/fdf en %",null,null,"diff : vie/def en %"]
[null,0,"Jeunes Soldates",null,null,{"$f":"(O5*8)+(O6*10)+(O7*13)+(O8*16)+(O9*20)+(O10*30)+(O11*40)+(O12*10)+(O13*12)+(O14*27)+(O15*35)+(O16*50)+(O17*50)+(O18*55)","v":4716569},null,"(+",{"$f":"O24-F24","v":5188225.9000000004},")",11,null,null,null,{"$f":"F24*(10+K24)/10","v":9904794.9000000004},null,{"$f":"((O24-O21)/O21)*100","v":14.708662742495292},"%",null,{"$f":"((O24-O27)/O27)*100","v":65.98350429988291},"%"]
[null,0,"Soldates"]
[null,0,"Concierges",null,null,"DEFENSE brut",null,"bonus AR",null,null,null,null,null,null,"TOTAL DEFENSE",null,"diff : def/fdf en %",null,null,"diff : def/ vie en %"]
[null,0,"Concierges d'élites",null,null,{"$f":"(O5*2)+(O6*4)+(O7*6)+(O8*9)+(O9*14)+(O10*25)+(O11*35)+(O12*15)+(O13*18)+(O14*23)+(O15*1)+(O16*1)+(O17*50)+(O18*55)","v":2841589},null,"(+",{"$f":"O27-F27","v":3125747.9000000004},")",null,null,null,null,{"$f":"F27*(10+K21)/10","v":5967336.9000000004},null,{"$f":"((O27-O21)/O21)*100","v":-30.891528512826916},"%",null,{"$f":"((O27-O24)/O24)*100","v":-39.753049303423737},"%"]
[null,0,"Artilleuses"]
[null,0,"Artilleuses d'élites",null,null,"TOTAL DE FOURMIS",null,null,null,null,null,null,null,null,null,null,"DOME (notez si dessous)",null,null,"LOGE (notez si dessous)"]
[null,0,"Soldates d'élites",null,null,{"$f":"SUM(O5:O18)","v":406810},null,null,null,null,null,null,null,null,null,null,6,null,null,10]
[null,0,"Tanks ",null,null,null,null,null,null,null,null,null,null,null,"i-sork 2013"]
[null,0,"Tanks d'élites",null,null,"RESUME \n(si vous devez envoyer ces informations copiez/collez la zone blanche et envoyez par mp -ATTENTION REVELER SON ARMEE COMPORTE UN RISQUE restez vigilant-)",null,null,null,null,null,null,null,null,null,null,"Bonus de bouclier ",null,null,"Bonus de bouclier"]
[null,0,"Tueuses ",null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"Q36-O24","v":1886627.5999999996},null,"+",{"$f":"T36-O24","v":8489824.1999999974}]
[null,0,"Tueuses d'élites"]
[null,null,null,null,null,"date :",null,null,{"$f":"D2","v":"2013-11-20"},null,null,null,null,null,null,null,"TOTAL DE VIE \nEN DOME",null,null,"TOTAL DE VIE \nEN LOGE"]
[null,"fdf notez ici","vie notez ici",null,null,"Vous avez actuellement un total de fourmis de :",null,null,null,null,null,null,null,null,null,null,{"$f":"F24*(1+0.1*K24+0.1+0.05*Q30)","v":11791422.5},null,null,{"$f":"F24*(1+0.1*K24+0.3+0.15*T30)","v":18394619.099999998}]
[null,0,0,null,null,{"$f":"F30","v":406810}]
[null,"def notez ici",null,null,null,"Vous avez actuellement :"]
[null,0,null,null,null,{"$f":"Q41","v":218451},"ouvrières",null,null,null,null,null,null,null,null,null,"NOMBRE D'OUVRIERES (notez si dessous)"]
[null,null,null,null,null,"Avec  un nombre total de :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,218451]
[null,null,null,null,null,{"$f":"O5","v":167923},"jeunes Soldate naines--",null,null,"soit",{"$f":"D5","v":100},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,{"$f":"O6","v":38989},"Soldates Naines---------",null,null,"soit",{"$f":"D6","v":23.218379852670569},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,8243,"Naines d'Elites----------",null,null,"soit",4.9087974845613767,"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE VA"]
[null,null,null,null,null,107052,"Jeunes Soldates---------",null,null,"soit",63.750647618253602,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,19475,"Soldates------------------",null,null,"soit",11.597577461098242,"%"," ------- selon le ratio 100% JSN",null,null,null,9]
[null,null,null,null,null,0,"Concierges---------------",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Concierges d'élites-----",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,45221,"Artilleuses----------------",null,null,"soit",26.929604640222006,"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE VC"]
[null,null,null,null,null,14393,"Artilleuses d'élites------",null,null,"soit",8.5711903670134522,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,5514,"Soldates d'élites--------",null,null,"soit",3.28364786241313,"%"," ------- selon le ratio 100% JSN",null,null,null,10]
[null,null,null,null,null,0,"Tanks ---------------------",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Tanks d'élites------------",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Tueuses ------------------",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE TDP"]
[null,null,null,null,null,0,"Tueuses d'élites---------",null,null,"soit",0,"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,null,null,null,"Vous avez une arme de niveau :",null,null,{"$f":"K21","v":11}]
[null,null,null,null,null,"Vous avez un bouclier de niveau :",null,null,{"$f":"K24","v":11}]
[null,null,null,null,null,"Vous avez un Dôme de niveau :",null,null,{"$f":"Q30","v":6}]
[null,null,null,null,null,"Vous avez une Loge Impèriale de niveau :",null,null,{"$f":"T30","v":10}]
[]
[null,null,null,null,null,"Vous avez une bonus de vie en Dôme de  :",null,{"$f":"Q33","v":1886627.5999999996}]
[null,null,null,null,null,"soit un total de vie en dôme de  :",null,{"$f":"Q36","v":11791422.5}]
[null,null,null,null,null,"Vous avez un bonus de vie en Loge de :",null,{"$f":"T33","v":8489824.1999999974}]
[null,null,null,null,null,"soit un total de vie en loge de :",null,{"$f":"T36","v":18394619.099999998}]
[]
[null,null,null,null,null,"Vous avez une force de frappe brut de : ",null,{"$f":"F21","v":4111781}]
[null,null,null,null,null,"Vous avez une vie brut de :",null,{"$f":"F24","v":4716569}]
[null,null,null,null,null,"Vous avez une force de défense brut de : ",null,{"$f":"F27","v":2841589}]
[]
[null,null,null,null,null,"A cela s'ajoute :"]
[]
[null,null,null,null,null,"Le bonus d'arme en force de frappe de :",null,null,{"$f":"I21","v":4522959.0999999996}]
[null,null,null,null,null,"Le bonus d'arme en défense de :",null,null,{"$f":"I27","v":3125747.9000000004}]
[null,null,null,null,null,"Le bonus de bouclier en vie de :",null,null,{"$f":"I24","v":5188225.9000000004}]
[]
[null,null,null,null,null,"Soit :"]
[]
[null,null,null,null,null,"Une force de frappe totale de :",null,null,{"$f":"O21","v":8634740.0999999996}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q21","v":-12.822625938473504},"%","de différence, entre, la force de frappe et la vie"]
[null,null,null,null,null,"Aussi :",null,null,{"$f":"T21","v":44.700060423938844},"%","de différence, entre, la force de frappe et la force de défense"]
[]
[null,null,null,null,null,"Une vie totale de :",null,null,{"$f":"O24","v":9904794.9000000004}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q24","v":14.708662742495292},"%","de différence, entre, la vie et la force de frappe"]
[null,null,null,null,null,"Aussi :",null,null,{"$f":"T24","v":65.98350429988291},"%","de différence, entre, la vie et la force de défense"]
[]
[]
[null,null,null,null,null,"Une force de défense totale de :",null,null,{"$f":"O27","v":5967336.9000000004}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q27","v":-30.891528512826916},"%","de différence, entre la force de défense et la force de frappe"]
[null,null,null,null,null,"Aussi :",null,null,{"$f":"T27","v":-39.753049303423737},"%","de différence, entre la force de défense et la vie"]
[]
[null,null,null,null,null,"Votre niveau de vitesse d'Attaque est de :",null,null,{"$f":"Q46","v":9}]
[null,null,null,null,null,"votre niveau de Vitesse de Chasse est de :",null,null,{"$f":"Q51","v":10}]
[]
[null,null,null,null,null,"Votre temps de ponte est d'actuellement :",null,null,{"$f":"Q56","v":0.34},"pour 1 ouvrière"]

{"sheet":"Feuil1","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"jeunes Soldate naines",{"$f":"'tableau d''armée'!O5","v":167923}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Soldates Naines",{"$f":"'tableau d''armée'!O6","v":38989}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Naines d'Elites",{"$f":"'tableau d''armée'!O7","v":8243}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jeunes Soldates",{"$f":"'tableau d''armée'!O8","v":107052}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Soldates",{"$f":"'tableau d''armée'!O9","v":19475}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Concierges",{"$f":"'tableau d''armée'!O10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Concierges d'élites",{"$f":"'tableau d''armée'!O11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Artilleuses",{"$f":"'tableau d''armée'!O12","v":45221}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Artilleuses d'élites",{"$f":"'tableau d''armée'!O13","v":14393}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Soldates d'élites",{"$f":"'tableau d''armée'!O14","v":5514}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tanks ",{"$f":"'tableau d''armée'!O15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tanks d'élites",{"$f":"'tableau d''armée'!O16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tueuses ",{"$f":"'tableau d''armée'!O17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tueuses d'élites",{"$f":"'tableau d''armée'!O18","v":0}]