{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["tableau d'armée","Maj"],"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":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[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},"%",0,0,null,null,null,null,null,"jeunes Soldate naines",null,{"$f":"SUM(F5:G5)","v":0},null,null,null,null,null,null,null,"JSN =",null,1,{"$f":"O5","v":0}]
[null,0,null,{"$f":"O6*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Soldates Naines",null,0,null,null,null,null,null,null,null,"vous devez pondre"]
[null,0,null,{"$f":"O7*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Naines d'Elites",null,0,null,null,null,null,null,null,null,{"$f":"Z7-W22","v":0},null,0.9,{"$f":"Z5*90/100","v":0}]
[null,0,null,{"$f":"O8*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Jeunes Soldates",null,0,null,null,null,null,null,null,null,{"$f":"Z8-W22","v":0},null,0.8,{"$f":"Z5*80/100","v":0}]
[null,0,null,{"$f":"F9*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Soldates",null,0,null,null,null,null,null,null,null,{"$f":"Z9-W22","v":0},null,0.7,{"$f":"Z5*70/100","v":0}]
[null,0,null,{"$f":"O10*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Concierges",null,0,null,null,null,null,null,null,null,{"$f":"Z10-W22","v":0},null,0.6,{"$f":"Z5*60/100","v":0}]
[null,0,null,{"$f":"O11*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Concierges d'élites",null,0,null,null,null,null,null,null,null,{"$f":"Z11-W22","v":0},null,0.5,{"$f":"Z5*50/100","v":0}]
[null,0,null,{"$f":"O12*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Artilleuses",null,0,null,null,null,null,null,null,null,{"$f":"Z12-W22","v":0},null,0.4,{"$f":"Z5*40/100","v":0}]
[null,0,null,{"$f":"O13*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Artilleuses d'élites",null,0,null,null,null,null,null,null,null,{"$f":"Z13-W22","v":0},null,0.3,{"$f":"Z5*30/100","v":0}]
[null,0,null,{"$f":"O14*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Soldates d'élites",null,{"$f":"SUM(F14:G14)","v":0},null,null,null,null,null,null,null,{"$f":"Z14-W22","v":0},null,0.2,{"$f":"Z5*20/100","v":0}]
[null,0,null,{"$f":"O15*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Tanks ",null,0,null,null,null,null,null,null,null,{"$f":"Z15-W22","v":0},null,0.1,{"$f":"Z5*10/100","v":0}]
[null,0,null,{"$f":"O16*100/O5","v":{"$error":"#DIV/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":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Tueuses ",null,0]
[null,0,null,{"$f":"O18*100/O5","v":{"$error":"#DIV/0!"}},"%",0,0,null,null,null,null,null,"Tueuses d'élites",null,0,null,null,null,null,null,null,null,"Selectionnez dans la liste déroulante du dessous le type de fourmis que vous souhaitez créer"]
[]
[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,"Jeunes Soldates",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":0},null,"(+",{"$f":"O21-F21","v":0},")",0,null,null,null,{"$f":"F21*(10+K21)/10","v":0},null,{"$f":"((O21-O24)/O24)*100","v":{"$error":"#DIV/0!"}},"%",null,{"$f":"((O21-O27)/O27)*100","v":{"$error":"#DIV/0!"}},"%",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":0}]
[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":0},null,"(+",{"$f":"O24-F24","v":0},")",0,null,null,null,{"$f":"F24*(10+K24)/10","v":0},null,{"$f":"((O24-O21)/O21)*100","v":{"$error":"#DIV/0!"}},"%",null,{"$f":"((O24-O27)/O27)*100","v":{"$error":"#DIV/0!"}},"%"]
[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":0},null,"(+",{"$f":"O27-F27","v":0},")",null,null,null,null,{"$f":"F27*(10+K21)/10","v":0},null,{"$f":"((O27-O21)/O21)*100","v":{"$error":"#DIV/0!"}},"%",null,{"$f":"((O27-O24)/O24)*100","v":{"$error":"#DIV/0!"}},"%"]
[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":0},null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[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":0},null,"+",{"$f":"T36-O24","v":0}]
[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":0},null,null,{"$f":"F24*(1+0.1*K24+0.3+0.15*T30)","v":0}]
[null,0,0,null,null,{"$f":"F30","v":0}]
[null,"def notez ici",null,null,null,"Vous avez actuellement :"]
[null,0,null,null,null,{"$f":"Q41","v":0},"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,0]
[null,null,null,null,null,{"$f":"O5","v":0},"jeunes Soldate naines--",null,null,"soit",{"$f":"D5","v":100},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,{"$f":"O6","v":0},"Soldates Naines---------",null,null,"soit",{"$f":"D6","v":{"$error":"#DIV/0!"}},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Naines d'Elites----------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE VA"]
[null,null,null,null,null,0,"Jeunes Soldates---------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Soldates------------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN",null,null,null,0]
[null,null,null,null,null,0,"Concierges---------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Concierges d'élites-----",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Artilleuses----------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE VC"]
[null,null,null,null,null,0,"Artilleuses d'élites------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Soldates d'élites--------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN",null,null,null,0]
[null,null,null,null,null,0,"Tanks ---------------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Tanks d'élites------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,0,"Tueuses ------------------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN",null,null,null,"VOTRE TDP"]
[null,null,null,null,null,0,"Tueuses d'élites---------",null,null,"soit",{"$error":"#DIV/0!"},"%"," ------- selon le ratio 100% JSN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Vous avez une arme de niveau :",null,null,{"$f":"K21","v":0}]
[null,null,null,null,null,"Vous avez un bouclier de niveau :",null,null,{"$f":"K24","v":0}]
[null,null,null,null,null,"Vous avez un Dôme de niveau :",null,null,{"$f":"Q30","v":0}]
[null,null,null,null,null,"Vous avez une Loge Impèriale de niveau :",null,null,{"$f":"T30","v":0}]
[]
[null,null,null,null,null,"Vous avez une bonus de vie en Dôme de  :",null,{"$f":"Q33","v":0}]
[null,null,null,null,null,"soit un total de vie en dôme de  :",null,{"$f":"Q36","v":0}]
[null,null,null,null,null,"Vous avez un bonus de vie en Loge de :",null,{"$f":"T33","v":0}]
[null,null,null,null,null,"soit un total de vie en loge de :",null,{"$f":"T36","v":0}]
[]
[null,null,null,null,null,"Vous avez une force de frappe brut de : ",null,{"$f":"F21","v":0}]
[null,null,null,null,null,"Vous avez une vie brut de :",null,{"$f":"F24","v":0}]
[null,null,null,null,null,"Vous avez une force de défense brut de : ",null,{"$f":"F27","v":0}]
[]
[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":0}]
[null,null,null,null,null,"Le bonus d'arme en défense de :",null,null,{"$f":"I27","v":0}]
[null,null,null,null,null,"Le bonus de bouclier en vie de :",null,null,{"$f":"I24","v":0}]
[]
[null,null,null,null,null,"Soit :"]
[]
[null,null,null,null,null,"Une force de frappe totale de :",null,null,{"$f":"O21","v":0}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q21","v":{"$error":"#DIV/0!"}},"%","de différence, entre, la force de frappe et la vie"]
[null,null,null,null,null,"Aussi :",null,null,{"$f":"T21","v":{"$error":"#DIV/0!"}},"%","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":0}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q24","v":{"$error":"#DIV/0!"}},"%","de différence, entre, la vie et la force de frappe"]
[null,null,null,null,null,"Aussi :",null,null,{"$f":"T24","v":{"$error":"#DIV/0!"}},"%","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":0}]
[null,null,null,null,null,"Ce qui représente :",null,null,{"$f":"Q27","v":{"$error":"#DIV/0!"}},"%","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":{"$error":"#DIV/0!"}},"%","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":0}]
[null,null,null,null,null,"votre niveau de Vitesse de Chasse est de :",null,null,{"$f":"Q51","v":0}]
[]
[null,null,null,null,null,"Votre temps de ponte est d'actuellement :",null,null,{"$f":"Q56","v":0},"pour 1 ouvrière"]

{"sheet":"Maj","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,36,9]]}
["Mise à jour :\n\nV.2\n20-11-13\ncalcul automatisé du % pour la ponte en fonction de l'armée actuelle, afin d'éviter de faire des calculs \nMise en place et modification TDP VA VC nombre d'ouvrière\nModification du texte par copie/colle pour transmission par mp, rendu plus lisible"]