{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Listes","Feuil3"],"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":"Feuil1","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,9,3,9],[0,2,0,4],[28,2,28,4],[28,6,28,8],[3,2,3,4],[3,6,3,8]]}
[null,null,"TABLEAU de CALCUL TDC ",null,null,null,"inserez votre position au-sein de l'alliance                                       Pour les Chasseur le code sera : AAou BB ou CC                                   Pour les Passeurs le code sera : A.1 - A.2 - A.3 - A.4 - A.5 - A.6                                                                -                                                                         B.1 - B.2 - B.3 - B.4 - B.5 - B.6                                                                                -                                                                         C.1 - C.2 - C.3 - C.4 - C.5 - C.6                     Pour les Greniers le code sera :  GA GB GC","AA","Je souhaite à ce que lorsque l'on écrit AA les cases C22 C24 C26 C28 G22 G24 G26 C31 soit de la même couleur que la grosse case ainsi de suite si on écrit BB etc","soit"]
[null,null,"TDC Grenier MERE","TDC Grenier MERE","TDC Grenier MERE",null,"insérez  le TDC du Grenier MERE si-dessous","insérez votre TDC si dessous"]
[null,null,{"$f":"G3","v":740000},{"$f":"C3","v":740000},{"$f":"C3","v":740000},null,740000,230000,null,"BB=D31=D28=D26=D24=D22=H22=H24=H26=H CC=E31;E28;E26;E24;E22;I22;I24;I26;I28                            A.1=C32;C28;C26;C24;C24;C26;C28;C9;G9 etc"]
[null,null,"VALEURS MINIMALES",null,null,null,"VALEURS MAXIMALES"]
[null,null,"TDC GRENIER A","TDC GRENIER B","TDC GRENIER C",null,"TDC GRENIER A","TDC GRENIER B","TDC GRENIER C"]
[null,null,{"$f":"ROUND(C3*50%,0)","v":370000},{"$f":"ROUND(C6*60%,0)","v":222000},{"$f":"ROUND(D6*60%,0)","v":133200},null,{"$f":"ROUND(G3*150%,0)","v":1110000},{"$f":"ROUND(G6*60%,0)","v":666000},{"$f":"ROUND(H6*60%,0)","v":399600}]
[]
[null,null,"TDC PASSEUR minimum A.1","TDC PASSEUR minimum B.1","TDC PASSEUR minimum C.1",null,"TDC PASSEUR maximum A.1","TDC PASSEUR maximum B.1","TDC PASSEUR maximum C.1"]
[null,null,{"$f":"ROUND(C6*50%,0)","v":185000},{"$f":"ROUND(D6*50%,0)","v":111000},{"$f":"ROUND(E6*50%,0)","v":66600},null,{"$f":"ROUND(G6*50%,0)","v":555000},{"$f":"ROUND(H6*50%,0)","v":333000},{"$f":"ROUND(I6*50%,0)","v":199800}]
[null,null,"TDC PASSEUR minimum A.2","TDC PASSEUR minimum B.2","TDC PASSEUR minimum C.2",null,"TDC PASSEUR maximum A.2","TDC PASSEUR maximum B.2","TDC PASSEUR maximum C.2"]
[null,null,{"$f":"ROUND(C9*50%,0)","v":92500},{"$f":"ROUND(D9*50%,0)","v":55500},{"$f":"ROUND(E9*50%,0)","v":33300},null,{"$f":"ROUND(G9*50%,0)","v":277500},{"$f":"ROUND(H9*50%,0)","v":166500},{"$f":"ROUND(I9*50%,0)","v":99900}]
[null,null,"TDC PASSEUR minimum A.3","TDC PASSEUR minimum B.3","TDC PASSEUR minimum C.3",null,"TDC PASSEUR maximum A.3","TDC PASSEUR maximum B.3","TDC PASSEUR maximum C.3"]
[null,null,{"$f":"ROUND(C11*50%,0)","v":46250},{"$f":"ROUND(D11*50%,0)","v":27750},{"$f":"ROUND(E11*50%,0)","v":16650},null,{"$f":"ROUND(G11*50%,0)","v":138750},{"$f":"ROUND(H11*50%,0)","v":83250},{"$f":"ROUND(I11*50%,0)","v":49950}]
[null,null,"TDC PASSEUR minimum A.4","TDC PASSEUR minimum B.4","TDC PASSEUR minimum C.4",null,"TDC PASSEUR maximum A.4","TDC PASSEUR maximum B.4","TDC PASSEUR maximum C.4"]
[null,null,{"$f":"ROUND(C13*50%,0)","v":23125},{"$f":"ROUND(D13*50%,0)","v":13875},{"$f":"ROUND(E13*50%,0)","v":8325},null,{"$f":"ROUND(G13*50%,0)","v":69375},{"$f":"ROUND(H13*50%,0)","v":41625},{"$f":"ROUND(I13*50%,0)","v":24975}]
[null,null,"TDC PASSEUR minimum A.5","TDC PASSEUR minimum B.5","TDC PASSEUR minimum C.5",null,"TDC PASSEUR maximum A.5","TDC PASSEUR maximum B.5","TDC PASSEUR maximum C.5"]
[null,null,{"$f":"ROUND(C15*50%,0)","v":11563},{"$f":"ROUND(D15*50%,0)","v":6938},{"$f":"ROUND(E15*50%,0)","v":4163},null,{"$f":"ROUND(G15*50%,0)","v":34688},{"$f":"ROUND(H15*50%,0)","v":20813},{"$f":"ROUND(I15*50%,0)","v":12488}]
[null,null,"TDC PASSEUR minimum A.6","TDC PASSEUR minimum B.6","TDC PASSEUR minimum C.6",null,"TDC PASSEUR maximum A.6","TDC PASSEUR maximum B.6","TDC PASSEUR maximum C.6"]
[null,null,{"$f":"ROUND(C17*50%,0)","v":5782},{"$f":"ROUND(D17*50%,0)","v":3469},{"$f":"ROUND(E17*50%,0)","v":2082},null,{"$f":"ROUND(G17*50%,0)","v":17344},{"$f":"ROUND(H17*50%,0)","v":10407},{"$f":"ROUND(I17*50%,0)","v":6244}]
[]
[null,null,"TDC CHASSEUR minimum AA.1","TDC CHASSEUR minimum BB.1","TDC CHASSEUR minimum CC.1",null,"TDC CHASSEUR maximum AA.1","TDC CHASSEUR maximum BB.1","TDC CHASSEUR maximum CC.1"]
[null,null,{"$f":"ROUND(C19*50%,0)","v":2891},{"$f":"ROUND(D19*50%,0)","v":1735},{"$f":"ROUND(E19*50%,0)","v":1041},null,{"$f":"ROUND(G19*50%,0)","v":8672},{"$f":"ROUND(H19*50%,0)","v":5204},{"$f":"ROUND(I19*50%,0)","v":3122}]
[null,null,"TDC CHASSEUR minimum AA.2","TDC CHASSEUR minimum BB.2","TDC CHASSEUR minimum CC.2",null,"TDC CHASSEUR maximum AA.2","TDC CHASSEUR maximum BB.2","TDC CHASSEUR maximum CC.2"]
[null,null,{"$f":"C22","v":2891},{"$f":"D22","v":1735},{"$f":"E22","v":1041},null,{"$f":"G22","v":8672},{"$f":"H22","v":5204},{"$f":"I22","v":3122}]
[null,null,"TDC CHASSEUR minimum AA.3","TDC CHASSEUR minimum BB.3","TDC CHASSEUR minimum CC.3",null,"TDC CHASSEUR maximum AA.3","TDC CHASSEUR maximum BB.3","TDC CHASSEUR maximum CC.3"]
[null,null,{"$f":"C24","v":2891},{"$f":"D24","v":1735},{"$f":"E24","v":1041},null,{"$f":"G24","v":8672},{"$f":"H24","v":5204},{"$f":"I24","v":3122}]
[null,null,"TDC CHASSEUR minimum AA.4","TDC CHASSEUR minimum BB.4","TDC CHASSEUR minimum CC.4",null,"TDC CHASSEUR maximum AA.4","TDC CHASSEUR maximum BB.4","TDC CHASSEUR maximum CC.4"]
[null,null,{"$f":"C26","v":2891},{"$f":"D26","v":1735},{"$f":"E26","v":1041},null,{"$f":"G26","v":8672},{"$f":"H26","v":5204},{"$f":"I26","v":3122}]
[null,null,"VOTRE TDC"]
[null,null,"IL MANQUE  (-) ou J'AI EN TROP","IL MANQUE  (-) ou J'AI EN TROP","IL MANQUE  (-) ou J'AI EN TROP"]
["Chasseur AA/BB/CC",{"$f":"H3","v":230000},{"$f":"B31-C28","v":227109},{"$f":"B31-D28","v":228265},{"$f":"B31-E28","v":228959}]
["Passeur A.1/B.1/C.1",{"$f":"B31","v":230000},{"$f":"B32-C9","v":45000},{"$f":"B32-D9","v":119000},{"$f":"B32-E9","v":163400}]
["Passeur A.2/B.2/.C2",{"$f":"B31","v":230000},{"$f":"B33-C11","v":137500},{"$f":"B33-D11","v":174500},{"$f":"B33-E11","v":196700}]
["Passeur A.3/B.3/C.3",{"$f":"B31","v":230000},{"$f":"B34-C13","v":183750},{"$f":"B34-D13","v":202250},{"$f":"B34-E13","v":213350}]
["Passeur A.4/B.4/.C4",{"$f":"B31","v":230000},{"$f":"B35-C15","v":206875},{"$f":"B35-D15","v":216125},{"$f":"B35-E15","v":221675}]
["Passeur A.5/B.5/C.5",{"$f":"B31","v":230000},{"$f":"B36-C17","v":218437},{"$f":"B36-D17","v":223062},{"$f":"B36-E17","v":225837}]
["Passeur A6./B.6/.C6",{"$f":"B31","v":230000},{"$f":"B37-C19","v":224218},{"$f":"B37-D19","v":226531},{"$f":"B37-E19","v":227918}]
["Grenier A/B/C",{"$f":"B31","v":230000},{"$f":"B38-C6","v":-140000},{"$f":"B38-D6","v":8000},{"$f":"B38-E6","v":96800}]

{"sheet":"Listes","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Code","Liste adresses"]
["AA","C22;C24;C26;C28;G22;G24;G26;C31"]
["A.1","C32;C28;C26;C24;C24;C26;C28;C9;G9"]
["BB","D31;D28;D26;D24;D22;H22;H24;H26"]
["CC","E31;E28;E26;E24;E22;I22;I24;I26;I28"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}