{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Grand-livre","Libellés","Renseignements","Plan comptable"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Grand-livre","index":0,"n_rows":160,"n_cols":60,"rows_kept":160,"cut":false,"hidden":false,"merged":[[62,29,62,31],[46,28,46,31],[46,34,46,37],[46,40,46,43],[46,46,46,49],[57,53,59,53],[60,48,60,49],[116,1,116,3],[70,19,70,23],[71,19,71,23],[72,19,72,23],[73,19,73,23],[70,62,70,64],[68,13,68,17],[150,15,150,18],[77,13,77,16],[117,15,117,18],[139,15,139,18],[111,7,111,9],[115,6,115,7],[139,3,139,6],[117,3,117,6],[115,1,115,3],[46,9,46,12],[69,19,69,23],[74,19,74,23],[60,3,60,6],[69,13,69,17],[70,13,70,17],[71,13,71,17],[62,13,62,17],[67,13,67,17],[63,13,63,17],[2,21,2,24],[2,3,2,6],[110,7,110,9],[24,3,24,6],[24,9,24,12],[13,9,13,12],[2,9,2,12],[35,3,35,6],[35,9,35,12],[46,3,46,6],[2,40,2,43],[24,46,24,49],[2,46,2,49],[2,28,2,31],[2,34,2,37],[13,15,13,18],[13,21,13,24],[2,15,2,18],[13,28,13,31],[13,34,13,37],[35,46,35,49],[35,34,35,37],[24,34,24,37],[24,40,24,43],[13,40,13,43],[13,46,13,49],[35,28,35,31],[35,40,35,43],[35,21,35,24],[24,15,24,18],[24,28,24,31],[24,21,24,24],[35,15,35,18],[46,15,46,18],[46,21,46,24],[67,19,67,23],[64,19,64,23],[65,19,65,23],[66,19,66,23],[64,13,64,17],[68,19,68,23],[57,1,58,1],[60,13,60,24],[61,13,61,18],[61,19,61,24],[57,3,58,24],[62,19,62,23],[65,13,65,17],[66,13,66,17],[63,19,63,23],[77,19,77,22],[76,13,76,16],[75,13,75,17],[72,13,72,17],[73,13,73,17],[74,13,74,17],[75,19,75,23],[76,19,76,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Libellés!C38","v":10},null,null,null,null," "]
[null,null,null,{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Plancompta,3))","v":""},null,null,{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Plancompta,4))","v":""},null,null,{"$f":"IF(H3=\"\",\"\",VLOOKUP(H3,Plancompta,3))","v":""},null,null,{"$f":"IF(H3=\"\",\"\",VLOOKUP(H3,Plancompta,4))","v":""},null,null,{"$f":"IF(N3=\"\",\"\",VLOOKUP(N3,Plancompta,3))","v":""},null,null,{"$f":"IF(N3=\"\",\"\",VLOOKUP(N3,Plancompta,4))","v":""},null,null,{"$f":"IF(T3=\"\",\"\",VLOOKUP(T3,Plancompta,3))","v":""},null,null,{"$f":"IF(T3=\"\",\"\",VLOOKUP(T3,Plancompta,4))","v":""},null,null,null,{"$f":"IF(AA3=\"\",\"\",VLOOKUP(AA3,Plancompta,3))","v":""},null,null,{"$f":"IF(AA3=\"\",\"\",VLOOKUP(AA3,Plancompta,4))","v":""},null,null,{"$f":"IF(AG3=\"\",\"\",VLOOKUP(AG3,Plancompta,3))","v":""},null,null,{"$f":"IF(AG3=\"\",\"\",VLOOKUP(AG3,Plancompta,4))","v":""},null,null,{"$f":"IF(AM3=\"\",\"\",VLOOKUP(AM3,Plancompta,3))","v":""},null,null,{"$f":"IF(AM3=\"\",\"\",VLOOKUP(AM3,Plancompta,4))","v":""},null,null,{"$f":"IF(AS3=\"\",\"\",VLOOKUP(AS3,Plancompta,3))","v":""},null,null,{"$f":"IF(AS3=\"\",\"\",VLOOKUP(AS3,Plancompta,4))","v":""}]
[null,null,null,"Caisse",null,null,null,null,null,"Jeux",null,null,null,null,null,"Livres",null,null,null,null,null,{"$f":"IF(T3=\"\",\"\",T3 & \" \" & VLOOKUP(T3,Plancompta,2))","v":""},null,null,null,null,null,null,{"$f":"IF(AA3=\"\",\"\",AA3 & \" \" & VLOOKUP(AA3,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AG3=\"\",\"\",AG3 & \" \" & VLOOKUP(AG3,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AM3=\"\",\"\",AM3 & \" \" & VLOOKUP(AM3,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AS3=\"\",\"\",AS3 & \" \" & VLOOKUP(AS3,Plancompta,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD5/2)=BD5/2,1,2)","v":2},{"$f":"B22","v":41},{"$f":"IF(BC5=2,BH5*-1,BH5)","v":0},{"$f":"D3","v":"Caisse"},{"$f":"LEFT(BF5,4)","v":"Cais"},{"$f":"C22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD6/2)=BD6/2,1,2)","v":2},{"$f":"H11","v":43},0,{"$f":"J3","v":"Jeux"},{"$f":"LEFT(BF6,4)","v":"Jeux"},{"$f":"I11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"N11","v":45},0,{"$f":"P3","v":"Livres"},"Livr",{"$f":"O11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"T11","v":0},0,{"$f":"V3","v":""},"",{"$f":"U11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"B22","v":41},0,{"$f":"D14","v":0},"0",{"$f":"C22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"H22","v":47},0,{"$f":"J14","v":"Véhicule"},"Véhi",{"$f":"I22","v":0}]
[null,null,null,null,null,null,null,43,{"$f":"K11-M11","v":0},{"$f":"IF(K11=0,\"\",I12)","v":""},{"$f":"IF(K4+M4=0,0,IF(SUM(K4:K10)>SUM(M4:M10),0,SUM(M4:M10)-SUM(K4:K10)))","v":0},{"$f":"IF(M11=0,\"\",I12)","v":""},{"$f":"IF(K4+M4=0,0,IF(SUM(M4:M10)>SUM(K4:K10),0,SUM(K4:K10)-SUM(M4:M10)))","v":0},45,{"$f":"Q11-S11","v":0},{"$f":"IF(Q11=0,\"\",O12)","v":""},{"$f":"IF(Q4+S4=0,0,IF(SUM(Q4:Q10)>SUM(S4:S10),0,SUM(S4:S10)-SUM(Q4:Q10)))","v":0},{"$f":"IF(S11=0,\"\",O12)","v":""},{"$f":"IF(Q4+S4=0,0,IF(SUM(S4:S10)>SUM(Q4:Q10),0,SUM(Q4:Q10)-SUM(S4:S10)))","v":0},null,{"$f":"W11-Y11","v":0},{"$f":"IF(W11=0,\"\",U12)","v":""},{"$f":"IF(W4+Y4=0,0,IF(SUM(W4:W10)>SUM(Y4:Y10),0,SUM(Y4:Y10)-SUM(W4:W10)))","v":0},{"$f":"IF(Y11=0,\"\",U12)","v":""},{"$f":"IF(W4+Y4=0,0,IF(SUM(Y4:Y10)>SUM(W4:W10),0,SUM(W4:W10)-SUM(Y4:Y10)))","v":0},null,null,{"$f":"AD11-AF11","v":0},{"$f":"IF(AD11=0,\"\",AB12)","v":""},{"$f":"IF(AD4+AF4=0,0,IF(SUM(AD4:AD10)>SUM(AF4:AF10),0,SUM(AF4:AF10)-SUM(AD4:AD10)))","v":0},{"$f":"IF(AF11=0,\"\",AB12)","v":""},{"$f":"IF(AD4+AF4=0,0,IF(SUM(AF4:AF10)>SUM(AD4:AD10),0,SUM(AD4:AD10)-SUM(AF4:AF10)))","v":0},null,{"$f":"AJ11-AL11","v":0},{"$f":"IF(AJ11=0,\"\",AH12)","v":""},{"$f":"IF(AJ4+AL4=0,0,IF(SUM(AJ4:AJ10)>SUM(AL4:AL10),0,SUM(AL4:AL10)-SUM(AJ4:AJ10)))","v":0},{"$f":"IF(AL11=0,\"\",AH12)","v":""},{"$f":"IF(AJ4+AL4=0,0,IF(SUM(AL4:AL10)>SUM(AJ4:AJ10),0,SUM(AJ4:AJ10)-SUM(AL4:AL10)))","v":0},null,{"$f":"AP11-AR11","v":0},{"$f":"IF(AP11=0,\"\",AN12)","v":""},{"$f":"IF(AP4+AR4=0,0,IF(SUM(AP4:AP10)>SUM(AR4:AR10),0,SUM(AR4:AR10)-SUM(AP4:AP10)))","v":0},{"$f":"IF(AR11=0,\"\",AN12)","v":""},{"$f":"IF(AP4+AR4=0,0,IF(SUM(AR4:AR10)>SUM(AP4:AP10),0,SUM(AP4:AP10)-SUM(AR4:AR10)))","v":0},null,{"$f":"AV11-AX11","v":0},{"$f":"IF(AV11=0,\"\",AT12)","v":""},{"$f":"IF(AV4+AX4=0,0,IF(SUM(AV4:AV10)>SUM(AX4:AX10),0,SUM(AX4:AX10)-SUM(AV4:AV10)))","v":0},{"$f":"IF(AX11=0,\"\",AT12)","v":""},{"$f":"IF(AV4+AX4=0,0,IF(SUM(AX4:AX10)>SUM(AV4:AV10),0,SUM(AV4:AV10)-SUM(AX4:AX10)))","v":0},null,null,null,null,1,{"$f":"N22","v":42},0,{"$f":"P14","v":"Emprunt"},"Empr",{"$f":"O22","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"spb\",IF(H11>20,\"v/b.\",\"v/e\"))","v":"v/b."},{"$f":"IF(H11=\"\",\"spb\",IF(H11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(K4+M4=0,\"\",SUM(K4:K11))","v":""},null,{"$f":"IF(K4+M4=0,\"\",SUM(M4:M11))","v":""},{"$f":"IF(N11=\"\",\"spb\",IF(N11>20,\"v/b.\",\"v/e\"))","v":"v/b."},{"$f":"IF(N11=\"\",\"spb\",IF(N11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(Q4+S4=0,\"\",SUM(Q4:Q11))","v":""},null,{"$f":"IF(Q4+S4=0,\"\",SUM(S4:S11))","v":""},{"$f":"IF(T11=\"\",\"spb\",IF(T11>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(T11=\"\",\"spb\",IF(T11>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(W4+Y4=0,\"\",SUM(W4:W11))","v":""},null,{"$f":"IF(W4+Y4=0,\"\",SUM(Y4:Y11))","v":""},null,{"$f":"IF(AA11=\"\",\"spb\",IF(AA11>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AA11=\"\",\"spb\",IF(AA11>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AD4+AF4=0,\"\",SUM(AD4:AD11))","v":""},null,{"$f":"IF(AD4+AF4=0,\"\",SUM(AF4:AF11))","v":""},{"$f":"IF(AG11=\"\",\"spb\",IF(AG11>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AG11=\"\",\"spb\",IF(AG11>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AJ4+AL4=0,\"\",SUM(AJ4:AJ11))","v":""},null,{"$f":"IF(AJ4+AL4=0,\"\",SUM(AL4:AL11))","v":""},{"$f":"IF(AM11=\"\",\"spb\",IF(AM11>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AM11=\"\",\"spb\",IF(AM11>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AP4+AR4=0,\"\",SUM(AP4:AP11))","v":""},null,{"$f":"IF(AP4+AR4=0,\"\",SUM(AR4:AR11))","v":""},{"$f":"IF(AS11=\"\",\"spb\",IF(AS11>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AS11=\"\",\"spb\",IF(AS11>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AV4+AX4=0,\"\",SUM(AV4:AV11))","v":""},null,{"$f":"IF(AV4+AX4=0,\"\",SUM(AX4:AX11))","v":""},null,null,null,null,1,{"$f":"T22","v":0},0,{"$f":"V14","v":""},"",{"$f":"U22","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,Plancompta,3))","v":""},null,null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,Plancompta,4))","v":""},null,null,{"$f":"IF(N14=\"\",\"\",VLOOKUP(N14,Plancompta,3))","v":""},null,null,{"$f":"IF(N14=\"\",\"\",VLOOKUP(N14,Plancompta,4))","v":""},null,null,{"$f":"IF(T14=\"\",\"\",VLOOKUP(T14,Plancompta,3))","v":""},null,null,{"$f":"IF(T14=\"\",\"\",VLOOKUP(T14,Plancompta,4))","v":""},null,null,null,{"$f":"IF(AA14=\"\",\"\",VLOOKUP(AA14,Plancompta,3))","v":""},null,null,{"$f":"IF(AA14=\"\",\"\",VLOOKUP(AA14,Plancompta,4))","v":""},null,null,{"$f":"IF(AG14=\"\",\"\",VLOOKUP(AG14,Plancompta,3))","v":""},null,null,{"$f":"IF(AG14=\"\",\"\",VLOOKUP(AG14,Plancompta,4))","v":""},null,null,{"$f":"IF(AM14=\"\",\"\",VLOOKUP(AM14,Plancompta,3))","v":""},null,null,{"$f":"IF(AM14=\"\",\"\",VLOOKUP(AM14,Plancompta,4))","v":""},null,null,{"$f":"IF(AS14=\"\",\"\",VLOOKUP(AS14,Plancompta,3))","v":""},null,null,{"$f":"IF(AS14=\"\",\"\",VLOOKUP(AS14,Plancompta,4))","v":""},null,null,null,null,1,{"$f":"B33","v":0},0,{"$f":"D25","v":"Charges et Produits"},"Char",{"$f":"C33","v":0}]
[null,null,null,null,null,null,null,null,null,"Véhicule",null,null,null,null,null,"Emprunt",null,null,null,null,null,{"$f":"IF(T14=\"\",\"\",T14 & \" \" & VLOOKUP(T14,Plancompta,2))","v":""},null,null,null,null,null,null,{"$f":"IF(AA14=\"\",\"\",AA14 & \" \" & VLOOKUP(AA14,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AG14=\"\",\"\",AG14 & \" \" & VLOOKUP(AG14,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AM14=\"\",\"\",AM14 & \" \" & VLOOKUP(AM14,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AS14=\"\",\"\",AS14 & \" \" & VLOOKUP(AS14,Plancompta,2))","v":""},null,null,null,null,null,null,null,1,{"$f":"H33","v":0},0,{"$f":"J25","v":""},"",{"$f":"I33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"N33","v":44},0,{"$f":"P25","v":"Capital"},"Capi",{"$f":"O33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"T33","v":0},0,{"$f":"V25","v":""},"",{"$f":"U33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"B44","v":0},0,{"$f":"D36","v":""},"",{"$f":"C44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"H44","v":0},0,{"$f":"J36","v":""},"",{"$f":"I44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"N44","v":0},0,{"$f":"P36","v":""},"",{"$f":"O44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"T44","v":0},0,{"$f":"V36","v":""},"",{"$f":"U44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"B77","v":0},0,{"$f":"D61","v":"9000 Résultat"},"9000",{"$f":"C77","v":0}]
[null,41,{"$f":"E22-G22","v":0},{"$f":"IF(E22=0,\"\",C23)","v":""},{"$f":"IF(E4+G4=0,0,IF(SUM(E4:E21)>SUM(G4:G21),0,SUM(G4:G21)-SUM(E4:E21)))","v":0},{"$f":"IF(G22=0,\"\",C23)","v":""},{"$f":"IF(E4+G4=0,0,IF(SUM(G4:G21)>SUM(E4:E21),0,SUM(E4:E21)-SUM(G4:G21)))","v":0},47,{"$f":"K22-M22","v":0},{"$f":"IF(K22=0,\"\",I23)","v":""},{"$f":"IF(K15+M15=0,0,IF(SUM(K15:K21)>SUM(M15:M21),0,SUM(M15:M21)-SUM(K15:K21)))","v":0},{"$f":"IF(M22=0,\"\",I23)","v":""},{"$f":"IF(K15+M15=0,0,IF(SUM(M15:M21)>SUM(K15:K21),0,SUM(K15:K21)-SUM(M15:M21)))","v":0},42,{"$f":"Q22-S22","v":0},{"$f":"IF(Q22=0,\"\",O23)","v":""},{"$f":"IF(Q15+S15=0,0,IF(SUM(Q15:Q21)>SUM(S15:S21),0,SUM(S15:S21)-SUM(Q15:Q21)))","v":0},{"$f":"IF(S22=0,\"\",O23)","v":""},{"$f":"IF(Q15+S15=0,0,IF(SUM(S15:S21)>SUM(Q15:Q21),0,SUM(Q15:Q21)-SUM(S15:S21)))","v":0},null,{"$f":"W22-Y22","v":0},{"$f":"IF(W22=0,\"\",U23)","v":""},{"$f":"IF(W15+Y15=0,0,IF(SUM(W15:W21)>SUM(Y15:Y21),0,SUM(Y15:Y21)-SUM(W15:W21)))","v":0},{"$f":"IF(Y22=0,\"\",U23)","v":""},{"$f":"IF(W15+Y15=0,0,IF(SUM(Y15:Y21)>SUM(W15:W21),0,SUM(W15:W21)-SUM(Y15:Y21)))","v":0},null,null,{"$f":"AD22-AF22","v":0},{"$f":"IF(AD22=0,\"\",AB23)","v":""},{"$f":"IF(AD15+AF15=0,0,IF(SUM(AD15:AD21)>SUM(AF15:AF21),0,SUM(AF15:AF21)-SUM(AD15:AD21)))","v":0},{"$f":"IF(AF22=0,\"\",AB23)","v":""},{"$f":"IF(AD15+AF15=0,0,IF(SUM(AF15:AF21)>SUM(AD15:AD21),0,SUM(AD15:AD21)-SUM(AF15:AF21)))","v":0},null,{"$f":"AJ22-AL22","v":0},{"$f":"IF(AJ22=0,\"\",AH23)","v":""},{"$f":"IF(AJ15+AL15=0,0,IF(SUM(AJ15:AJ21)>SUM(AL15:AL21),0,SUM(AL15:AL21)-SUM(AJ15:AJ21)))","v":0},{"$f":"IF(AL22=0,\"\",AH23)","v":""},{"$f":"IF(AJ15+AL15=0,0,IF(SUM(AL15:AL21)>SUM(AJ15:AJ21),0,SUM(AJ15:AJ21)-SUM(AL15:AL21)))","v":0},null,{"$f":"AP22-AR22","v":0},{"$f":"IF(AP22=0,\"\",AN23)","v":""},{"$f":"IF(AP15+AR15=0,0,IF(SUM(AP15:AP21)>SUM(AR15:AR21),0,SUM(AR15:AR21)-SUM(AP15:AP21)))","v":0},{"$f":"IF(AR22=0,\"\",AN23)","v":""},{"$f":"IF(AP15+AR15=0,0,IF(SUM(AR15:AR21)>SUM(AP15:AP21),0,SUM(AP15:AP21)-SUM(AR15:AR21)))","v":0},null,{"$f":"AV22-AX22","v":0},{"$f":"IF(AV22=0,\"\",AT23)","v":""},{"$f":"IF(AV15+AX15=0,0,IF(SUM(AV15:AV21)>SUM(AX15:AX21),0,SUM(AX15:AX21)-SUM(AV15:AV21)))","v":0},{"$f":"IF(AX22=0,\"\",AT23)","v":""},{"$f":"IF(AV15+AX15=0,0,IF(SUM(AX15:AX21)>SUM(AV15:AV21),0,SUM(AV15:AV21)-SUM(AX15:AX21)))","v":0},null,null,null,null,1,{"$f":"AA11","v":0},0,{"$f":"AC3","v":""},"",{"$f":"AB11","v":0}]
[null,null,{"$f":"IF(B22=\"\",\"spb\",IF(B22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(E4+G4=0,\"\",SUM(E4:E22))","v":""},null,{"$f":"IF(E4+G4=0,\"\",SUM(G4:G22))","v":""},{"$f":"IF(H22=\"\",\"spb\",IF(H22>20,\"v/b.\",\"v/e\"))","v":"v/b."},{"$f":"IF(H22=\"\",\"spb\",IF(H22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(K15+M15=0,\"\",SUM(K15:K22))","v":""},null,{"$f":"IF(K15+M15=0,\"\",SUM(M15:M22))","v":""},{"$f":"IF(N22=\"\",\"spb\",IF(N22>20,\"v/b.\",\"v/e\"))","v":"v/b."},{"$f":"IF(N22=\"\",\"spb\",IF(N22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(Q15+S15=0,\"\",SUM(Q15:Q22))","v":""},null,{"$f":"IF(Q15+S15=0,\"\",SUM(S15:S22))","v":""},{"$f":"IF(T22=\"\",\"spb\",IF(T22>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(T22=\"\",\"spb\",IF(T22>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(W15+Y15=0,\"\",SUM(W15:W22))","v":""},null,{"$f":"IF(W15+Y15=0,\"\",SUM(Y15:Y22))","v":""},null,{"$f":"IF(AA22=\"\",\"spb\",IF(AA22>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AA22=\"\",\"spb\",IF(AA22>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AD15+AF15=0,\"\",SUM(AD15:AD22))","v":""},null,{"$f":"IF(AD15+AF15=0,\"\",SUM(AF15:AF22))","v":""},{"$f":"IF(AG22=\"\",\"spb\",IF(AG22>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AG22=\"\",\"spb\",IF(AG22>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AJ15+AL15=0,\"\",SUM(AJ15:AJ22))","v":""},null,{"$f":"IF(AJ15+AL15=0,\"\",SUM(AL15:AL22))","v":""},{"$f":"IF(AM22=\"\",\"spb\",IF(AM22>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AM22=\"\",\"spb\",IF(AM22>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AP15+AR15=0,\"\",SUM(AP15:AP22))","v":""},null,{"$f":"IF(AP15+AR15=0,\"\",SUM(AR15:AR22))","v":""},{"$f":"IF(AS22=\"\",\"spb\",IF(AS22>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AS22=\"\",\"spb\",IF(AS22>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AV15+AX15=0,\"\",SUM(AV15:AV22))","v":""},null,{"$f":"IF(AV15+AX15=0,\"\",SUM(AX15:AX22))","v":""},null,null,null,null,1,{"$f":"AG11","v":0},0,{"$f":"AI3","v":""},"",{"$f":"AH11","v":0}]
[null,null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Plancompta,3))","v":""},null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,Plancompta,4))","v":""},null,null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,Plancompta,3))","v":""},null,null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,Plancompta,4))","v":""},null,null,{"$f":"IF(N25=\"\",\"\",VLOOKUP(N25,Plancompta,3))","v":""},null,null,{"$f":"IF(N25=\"\",\"\",VLOOKUP(N25,Plancompta,4))","v":""},null,null,{"$f":"IF(T25=\"\",\"\",VLOOKUP(T25,Plancompta,3))","v":""},null,null,{"$f":"IF(T25=\"\",\"\",VLOOKUP(T25,Plancompta,4))","v":""},null,null,null,{"$f":"IF(AA25=\"\",\"\",VLOOKUP(AA25,Plancompta,3))","v":""},null,null,{"$f":"IF(AA25=\"\",\"\",VLOOKUP(AA25,Plancompta,4))","v":""},null,null,{"$f":"IF(AG25=\"\",\"\",VLOOKUP(AG25,Plancompta,3))","v":""},null,null,{"$f":"IF(AG25=\"\",\"\",VLOOKUP(AG25,Plancompta,4))","v":""},null,null,{"$f":"IF(AM25=\"\",\"\",VLOOKUP(AM25,Plancompta,3))","v":""},null,null,{"$f":"IF(AM25=\"\",\"\",VLOOKUP(AM25,Plancompta,4))","v":""},null,null,{"$f":"IF(AS25=\"\",\"\",VLOOKUP(AS25,Plancompta,3))","v":""},null,null,{"$f":"IF(AS25=\"\",\"\",VLOOKUP(AS25,Plancompta,4))","v":""},null,null,null,null,1,{"$f":"AM11","v":0},0,{"$f":"AO3","v":""},"",{"$f":"AN11","v":0}]
[null,null,null,"Charges et Produits",null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25 & \" \" & VLOOKUP(H25,Plancompta,2))","v":""},null,null,null,null,null,"Capital",null,null,null,null,null,{"$f":"IF(T25=\"\",\"\",T25 & \" \" & VLOOKUP(T25,Plancompta,2))","v":""},null,null,null,null,null,null,{"$f":"IF(AA25=\"\",\"\",AA25 & \" \" & VLOOKUP(AA25,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AG25=\"\",\"\",AG25 & \" \" & VLOOKUP(AG25,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AM25=\"\",\"\",AM25 & \" \" & VLOOKUP(AM25,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AS25=\"\",\"\",AS25 & \" \" & VLOOKUP(AS25,Plancompta,2))","v":""},null,null,null,null,null,null,null,1,{"$f":"AS11","v":0},0,{"$f":"AU3","v":""},"",{"$f":"AT11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AA22","v":0},0,{"$f":"AC14","v":""},"",{"$f":"AB22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AG22","v":0},0,{"$f":"AI14","v":""},"",{"$f":"AH22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AM22","v":0},0,{"$f":"AO14","v":""},"",{"$f":"AN22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AS22","v":0},0,{"$f":"AU14","v":""},"",{"$f":"AT22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AA33","v":0},0,{"$f":"AC25","v":""},"",{"$f":"AB33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AG33","v":0},0,{"$f":"AI25","v":""},"",{"$f":"AH33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AM33","v":0},0,{"$f":"AO25","v":""},"",{"$f":"AN33","v":0}]
[null,null,{"$f":"E33-G33","v":0},{"$f":"IF(E33=0,\"\",C34)","v":""},{"$f":"IF(E26+G26=0,0,IF(SUM(E26:E32)>SUM(G26:G32),0,SUM(G26:G32)-SUM(E26:E32)))","v":0},{"$f":"IF(G33=0,\"\",C34)","v":""},{"$f":"IF(E26+G26=0,0,IF(SUM(G26:G32)>SUM(E26:E32),0,SUM(E26:E32)-SUM(G26:G32)))","v":0},null,{"$f":"K33-M33","v":0},{"$f":"IF(K33=0,\"\",I34)","v":""},{"$f":"IF(K26+M26=0,0,IF(SUM(K26:K32)>SUM(M26:M32),0,SUM(M26:M32)-SUM(K26:K32)))","v":0},{"$f":"IF(M33=0,\"\",I34)","v":""},{"$f":"IF(K26+M26=0,0,IF(SUM(M26:M32)>SUM(K26:K32),0,SUM(K26:K32)-SUM(M26:M32)))","v":0},44,{"$f":"Q33-S33","v":0},{"$f":"IF(Q33=0,\"\",O34)","v":""},{"$f":"IF(Q26+S26=0,0,IF(SUM(Q26:Q32)>SUM(S26:S32),0,SUM(S26:S32)-SUM(Q26:Q32)))","v":0},{"$f":"IF(S33=0,\"\",O34)","v":""},{"$f":"IF(Q26+S26=0,0,IF(SUM(S26:S32)>SUM(Q26:Q32),0,SUM(Q26:Q32)-SUM(S26:S32)))","v":0},null,{"$f":"W33-Y33","v":0},{"$f":"IF(W33=0,\"\",U34)","v":""},{"$f":"IF(W26+Y26=0,0,IF(SUM(W26:W32)>SUM(Y26:Y32),0,SUM(Y26:Y32)-SUM(W26:W32)))","v":0},{"$f":"IF(Y33=0,\"\",U34)","v":""},{"$f":"IF(W26+Y26=0,0,IF(SUM(Y26:Y32)>SUM(W26:W32),0,SUM(W26:W32)-SUM(Y26:Y32)))","v":0},null,null,{"$f":"AD33-AF33","v":0},{"$f":"IF(AD33=0,\"\",AB34)","v":""},{"$f":"IF(AD26+AF26=0,0,IF(SUM(AD26:AD32)>SUM(AF26:AF32),0,SUM(AF26:AF32)-SUM(AD26:AD32)))","v":0},{"$f":"IF(AF33=0,\"\",AB34)","v":""},{"$f":"IF(AD26+AF26=0,0,IF(SUM(AF26:AF32)>SUM(AD26:AD32),0,SUM(AD26:AD32)-SUM(AF26:AF32)))","v":0},null,{"$f":"AJ33-AL33","v":0},{"$f":"IF(AJ33=0,\"\",AH34)","v":""},{"$f":"IF(AJ26+AL26=0,0,IF(SUM(AJ26:AJ32)>SUM(AL26:AL32),0,SUM(AL26:AL32)-SUM(AJ26:AJ32)))","v":0},{"$f":"IF(AL33=0,\"\",AH34)","v":""},{"$f":"IF(AJ26+AL26=0,0,IF(SUM(AL26:AL32)>SUM(AJ26:AJ32),0,SUM(AJ26:AJ32)-SUM(AL26:AL32)))","v":0},null,{"$f":"AP33-AR33","v":0},{"$f":"IF(AP33=0,\"\",AN34)","v":""},{"$f":"IF(AP26+AR26=0,0,IF(SUM(AP26:AP32)>SUM(AR26:AR32),0,SUM(AR26:AR32)-SUM(AP26:AP32)))","v":0},{"$f":"IF(AR33=0,\"\",AN34)","v":""},{"$f":"IF(AP26+AR26=0,0,IF(SUM(AR26:AR32)>SUM(AP26:AP32),0,SUM(AP26:AP32)-SUM(AR26:AR32)))","v":0},null,{"$f":"AV33-AX33","v":0},{"$f":"IF(AV33=0,\"\",AT34)","v":""},{"$f":"IF(AV26+AX26=0,0,IF(SUM(AV26:AV32)>SUM(AX26:AX32),0,SUM(AX26:AX32)-SUM(AV26:AV32)))","v":0},{"$f":"IF(AX33=0,\"\",AT34)","v":""},{"$f":"IF(AV26+AX26=0,0,IF(SUM(AX26:AX32)>SUM(AV26:AV32),0,SUM(AV26:AV32)-SUM(AX26:AX32)))","v":0},null,null,null,null,1,{"$f":"AS33","v":0},0,{"$f":"AU25","v":""},"",{"$f":"AT33","v":0}]
[null,{"$f":"IF(B33=\"\",\"spb\",IF(B33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(B33=\"\",\"spb\",IF(B33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(E26+G26=0,\"\",SUM(E26:E33))","v":""},null,{"$f":"IF(E26+G26=0,\"\",SUM(G26:G33))","v":""},{"$f":"IF(H33=\"\",\"spb\",IF(H33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(H33=\"\",\"spb\",IF(H33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(K26+M26=0,\"\",SUM(K26:K33))","v":""},null,{"$f":"IF(K26+M26=0,\"\",SUM(M26:M33))","v":""},{"$f":"IF(N33=\"\",\"spb\",IF(N33>20,\"v/b.\",\"v/e\"))","v":"v/b."},{"$f":"IF(N33=\"\",\"spb\",IF(N33>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(Q26+S26=0,\"\",SUM(Q26:Q33))","v":""},null,{"$f":"IF(Q26+S26=0,\"\",SUM(S26:S33))","v":""},{"$f":"IF(T33=\"\",\"spb\",IF(T33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(T33=\"\",\"spb\",IF(T33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(W26+Y26=0,\"\",SUM(W26:W33))","v":""},null,{"$f":"IF(W26+Y26=0,\"\",SUM(Y26:Y33))","v":""},null,{"$f":"IF(AA33=\"\",\"spb\",IF(AA33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AA33=\"\",\"spb\",IF(AA33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AD26+AF26=0,\"\",SUM(AD26:AD33))","v":""},null,{"$f":"IF(AD26+AF26=0,\"\",SUM(AF26:AF33))","v":""},{"$f":"IF(AG33=\"\",\"spb\",IF(AG33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AG33=\"\",\"spb\",IF(AG33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AJ26+AL26=0,\"\",SUM(AJ26:AJ33))","v":""},null,{"$f":"IF(AJ26+AL26=0,\"\",SUM(AL26:AL33))","v":""},{"$f":"IF(AM33=\"\",\"spb\",IF(AM33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AM33=\"\",\"spb\",IF(AM33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AP26+AR26=0,\"\",SUM(AP26:AP33))","v":""},null,{"$f":"IF(AP26+AR26=0,\"\",SUM(AR26:AR33))","v":""},{"$f":"IF(AS33=\"\",\"spb\",IF(AS33>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AS33=\"\",\"spb\",IF(AS33>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AV26+AX26=0,\"\",SUM(AV26:AV33))","v":""},null,{"$f":"IF(AV26+AX26=0,\"\",SUM(AX26:AX33))","v":""},null,null,null,null,1,{"$f":"AA44","v":0},0,{"$f":"AC36","v":""},"",{"$f":"AB44","v":0}]
[null,null,null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Plancompta,3))","v":""},null,null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Plancompta,4))","v":""},null,null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,Plancompta,3))","v":""},null,null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,Plancompta,4))","v":""},null,null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,Plancompta,3))","v":""},null,null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,Plancompta,4))","v":""},null,null,{"$f":"IF(T36=\"\",\"\",VLOOKUP(T36,Plancompta,3))","v":""},null,null,{"$f":"IF(T36=\"\",\"\",VLOOKUP(T36,Plancompta,4))","v":""},null,null,null,{"$f":"IF(AA36=\"\",\"\",VLOOKUP(AA36,Plancompta,3))","v":""},null,null,{"$f":"IF(AA36=\"\",\"\",VLOOKUP(AA36,Plancompta,4))","v":""},null,null,{"$f":"IF(AG36=\"\",\"\",VLOOKUP(AG36,Plancompta,3))","v":""},null,null,{"$f":"IF(AG36=\"\",\"\",VLOOKUP(AG36,Plancompta,4))","v":""},null,null,{"$f":"IF(AM36=\"\",\"\",VLOOKUP(AM36,Plancompta,3))","v":""},null,null,{"$f":"IF(AM36=\"\",\"\",VLOOKUP(AM36,Plancompta,4))","v":""},null,null,{"$f":"IF(AS36=\"\",\"\",VLOOKUP(AS36,Plancompta,3))","v":""},null,null,{"$f":"IF(AS36=\"\",\"\",VLOOKUP(AS36,Plancompta,4))","v":""},null,null,null,null,1,{"$f":"AG44","v":0},0,{"$f":"AI36","v":""},"",{"$f":"AH44","v":0}]
[null,null,null,{"$f":"IF(B36=\"\",\"\",B36 & \" \" & VLOOKUP(B36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(H36=\"\",\"\",H36 & \" \" & VLOOKUP(H36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(N36=\"\",\"\",N36 & \" \" & VLOOKUP(N36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(T36=\"\",\"\",T36 & \" \" & VLOOKUP(T36,Plancompta,2))","v":""},null,null,null,null,null,null,{"$f":"IF(AA36=\"\",\"\",AA36 & \" \" & VLOOKUP(AA36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AG36=\"\",\"\",AG36 & \" \" & VLOOKUP(AG36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AM36=\"\",\"\",AM36 & \" \" & VLOOKUP(AM36,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AS36=\"\",\"\",AS36 & \" \" & VLOOKUP(AS36,Plancompta,2))","v":""},null,null,null,null,null,null,null,1,{"$f":"AM44","v":0},0,{"$f":"AO36","v":""},"",{"$f":"AN44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AS44","v":0},0,{"$f":"AU36","v":""},"",{"$f":"AT44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD38/2)=BD38/2,1,2)","v":1},{"$f":"B55","v":0},0,{"$f":"D47","v":""},"",{"$f":"C55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"H55","v":0},0,{"$f":"J47","v":""},"",{"$f":"I55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"N55","v":0},0,{"$f":"P47","v":""},"",{"$f":"O55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"T55","v":0},0,{"$f":"V47","v":""},"",{"$f":"U55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AA55","v":0},0,{"$f":"AC47","v":""},"",{"$f":"AB55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AG55","v":0},0,{"$f":"AI47","v":""},"",{"$f":"AH55","v":0}]
[null,null,{"$f":"E44-G44","v":0},{"$f":"IF(E44=0,\"\",C45)","v":""},{"$f":"IF(E37+G37=0,0,IF(SUM(E37:E43)>SUM(G37:G43),0,SUM(G37:G43)-SUM(E37:E43)))","v":0},{"$f":"IF(G44=0,\"\",C45)","v":""},{"$f":"IF(E37+G37=0,0,IF(SUM(G37:G43)>SUM(E37:E43),0,SUM(E37:E43)-SUM(G37:G43)))","v":0},null,{"$f":"K44-M44","v":0},{"$f":"IF(K44=0,\"\",I45)","v":""},{"$f":"IF(K37+M37=0,0,IF(SUM(K37:K43)>SUM(M37:M43),0,SUM(M37:M43)-SUM(K37:K43)))","v":0},{"$f":"IF(M44=0,\"\",I45)","v":""},{"$f":"IF(K37+M37=0,0,IF(SUM(M37:M43)>SUM(K37:K43),0,SUM(K37:K43)-SUM(M37:M43)))","v":0},null,{"$f":"Q44-S44","v":0},{"$f":"IF(Q44=0,\"\",O45)","v":""},{"$f":"IF(Q37+S37=0,0,IF(SUM(Q37:Q43)>SUM(S37:S43),0,SUM(S37:S43)-SUM(Q37:Q43)))","v":0},{"$f":"IF(S44=0,\"\",O45)","v":""},{"$f":"IF(Q37+S37=0,0,IF(SUM(S37:S43)>SUM(Q37:Q43),0,SUM(Q37:Q43)-SUM(S37:S43)))","v":0},null,{"$f":"W44-Y44","v":0},{"$f":"IF(W44=0,\"\",U45)","v":""},{"$f":"IF(W37+Y37=0,0,IF(SUM(W37:W43)>SUM(Y37:Y43),0,SUM(Y37:Y43)-SUM(W37:W43)))","v":0},{"$f":"IF(Y44=0,\"\",U45)","v":""},{"$f":"IF(W37+Y37=0,0,IF(SUM(Y37:Y43)>SUM(W37:W43),0,SUM(W37:W43)-SUM(Y37:Y43)))","v":0},null,null,{"$f":"AD44-AF44","v":0},{"$f":"IF(AD44=0,\"\",AB45)","v":""},{"$f":"IF(AD37+AF37=0,0,IF(SUM(AD37:AD43)>SUM(AF37:AF43),0,SUM(AF37:AF43)-SUM(AD37:AD43)))","v":0},{"$f":"IF(AF44=0,\"\",AB45)","v":""},{"$f":"IF(AD37+AF37=0,0,IF(SUM(AF37:AF43)>SUM(AD37:AD43),0,SUM(AD37:AD43)-SUM(AF37:AF43)))","v":0},null,{"$f":"AJ44-AL44","v":0},{"$f":"IF(AJ44=0,\"\",AH45)","v":""},{"$f":"IF(AJ37+AL37=0,0,IF(SUM(AJ37:AJ43)>SUM(AL37:AL43),0,SUM(AL37:AL43)-SUM(AJ37:AJ43)))","v":0},{"$f":"IF(AL44=0,\"\",AH45)","v":""},{"$f":"IF(AJ37+AL37=0,0,IF(SUM(AL37:AL43)>SUM(AJ37:AJ43),0,SUM(AJ37:AJ43)-SUM(AL37:AL43)))","v":0},null,{"$f":"AP44-AR44","v":0},{"$f":"IF(AP44=0,\"\",AN45)","v":""},{"$f":"IF(AP37+AR37=0,0,IF(SUM(AP37:AP43)>SUM(AR37:AR43),0,SUM(AR37:AR43)-SUM(AP37:AP43)))","v":0},{"$f":"IF(AR44=0,\"\",AN45)","v":""},{"$f":"IF(AP37+AR37=0,0,IF(SUM(AR37:AR43)>SUM(AP37:AP43),0,SUM(AP37:AP43)-SUM(AR37:AR43)))","v":0},null,{"$f":"AV44-AX44","v":0},{"$f":"IF(AV44=0,\"\",AT45)","v":""},{"$f":"IF(AV37+AX37=0,0,IF(SUM(AV37:AV43)>SUM(AX37:AX43),0,SUM(AX37:AX43)-SUM(AV37:AV43)))","v":0},{"$f":"IF(AX44=0,\"\",AT45)","v":""},{"$f":"IF(AV37+AX37=0,0,IF(SUM(AX37:AX43)>SUM(AV37:AV43),0,SUM(AV37:AV43)-SUM(AX37:AX43)))","v":0},null,null,null,null,1,{"$f":"AM55","v":0},0,{"$f":"AO47","v":""},"",{"$f":"AN55","v":0}]
[null,{"$f":"IF(B44=\"\",\"spb\",IF(B44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(B44=\"\",\"spb\",IF(B44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(E37+G37=0,\"\",SUM(E37:E44))","v":""},null,{"$f":"IF(E37+G37=0,\"\",SUM(G37:G44))","v":""},{"$f":"IF(H44=\"\",\"spb\",IF(H44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(H44=\"\",\"spb\",IF(H44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(K37+M37=0,\"\",SUM(K37:K44))","v":""},null,{"$f":"IF(K37+M37=0,\"\",SUM(M37:M44))","v":""},{"$f":"IF(N44=\"\",\"spb\",IF(N44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(N44=\"\",\"spb\",IF(N44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(Q37+S37=0,\"\",SUM(Q37:Q44))","v":""},null,{"$f":"IF(Q37+S37=0,\"\",SUM(S37:S44))","v":""},{"$f":"IF(T44=\"\",\"spb\",IF(T44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(T44=\"\",\"spb\",IF(T44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(W37+Y37=0,\"\",SUM(W37:W44))","v":""},null,{"$f":"IF(W37+Y37=0,\"\",SUM(Y37:Y44))","v":""},null,{"$f":"IF(AA44=\"\",\"spb\",IF(AA44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AA44=\"\",\"spb\",IF(AA44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AD37+AF37=0,\"\",SUM(AD37:AD44))","v":""},null,{"$f":"IF(AD37+AF37=0,\"\",SUM(AF37:AF44))","v":""},{"$f":"IF(AG44=\"\",\"spb\",IF(AG44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AG44=\"\",\"spb\",IF(AG44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AJ37+AL37=0,\"\",SUM(AJ37:AJ44))","v":""},null,{"$f":"IF(AJ37+AL37=0,\"\",SUM(AL37:AL44))","v":""},{"$f":"IF(AM44=\"\",\"spb\",IF(AM44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AM44=\"\",\"spb\",IF(AM44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AP37+AR37=0,\"\",SUM(AP37:AP44))","v":""},null,{"$f":"IF(AP37+AR37=0,\"\",SUM(AR37:AR44))","v":""},{"$f":"IF(AS44=\"\",\"spb\",IF(AS44>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AS44=\"\",\"spb\",IF(AS44>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AV37+AX37=0,\"\",SUM(AV37:AV44))","v":""},null,{"$f":"IF(AV37+AX37=0,\"\",SUM(AX37:AX44))","v":""},null,null,null,null,1,{"$f":"AS55","v":0},0,{"$f":"AU47","v":""},"",{"$f":"AT55","v":0}]
[null,null,null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Plancompta,3))","v":""},null,null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Plancompta,4))","v":""},null,null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,Plancompta,3))","v":""},null,null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,Plancompta,4))","v":""},null,null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,Plancompta,3))","v":""},null,null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,Plancompta,4))","v":""},null,null,{"$f":"IF(T47=\"\",\"\",VLOOKUP(T47,Plancompta,3))","v":""},null,null,{"$f":"IF(T47=\"\",\"\",VLOOKUP(T47,Plancompta,4))","v":""},null,null,null,{"$f":"IF(AA47=\"\",\"\",VLOOKUP(AA47,Plancompta,3))","v":""},null,null,{"$f":"IF(AA47=\"\",\"\",VLOOKUP(AA47,Plancompta,4))","v":""},null,null,{"$f":"IF(AG47=\"\",\"\",VLOOKUP(AG47,Plancompta,3))","v":""},null,null,{"$f":"IF(AG47=\"\",\"\",VLOOKUP(AG47,Plancompta,4))","v":""},null,null,{"$f":"IF(AM47=\"\",\"\",VLOOKUP(AM47,Plancompta,3))","v":""},null,null,{"$f":"IF(AM47=\"\",\"\",VLOOKUP(AM47,Plancompta,4))","v":""},null,null,{"$f":"IF(AS47=\"\",\"\",VLOOKUP(AS47,Plancompta,3))","v":""},null,null,{"$f":"IF(AS47=\"\",\"\",VLOOKUP(AS47,Plancompta,4))","v":""},null,null,null,null,1,null,{"$f":"IF(BC46=2,BH46*-1,BH46)","v":0},{"$f":"AU45","v":0}]
[null,null,null,{"$f":"IF(B47=\"\",\"\",B47 & \" \" & VLOOKUP(B47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(H47=\"\",\"\",H47 & \" \" & VLOOKUP(H47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(N47=\"\",\"\",N47 & \" \" & VLOOKUP(N47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(T47=\"\",\"\",T47 & \" \" & VLOOKUP(T47,Plancompta,2))","v":""},null,null,null,null,null,null,{"$f":"IF(AA47=\"\",\"\",AA47 & \" \" & VLOOKUP(AA47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AG47=\"\",\"\",AG47 & \" \" & VLOOKUP(AG47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AM47=\"\",\"\",AM47 & \" \" & VLOOKUP(AM47,Plancompta,2))","v":""},null,null,null,null,null,{"$f":"IF(AS47=\"\",\"\",AS47 & \" \" & VLOOKUP(AS47,Plancompta,2))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD49/2)=BD49/2,1,2)","v":2},1,{"$f":"AT57","v":0},{"$f":"AU37","v":0},{"$f":"LEFT(BF49,4)","v":"0"},{"$f":"AT57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6]
[null,null,{"$f":"E55-G55","v":0},{"$f":"IF(E55=0,\"\",C56)","v":""},{"$f":"IF(E48+G48=0,0,IF(SUM(E48:E54)>SUM(G48:G54),0,SUM(G48:G54)-SUM(E48:E54)))","v":0},{"$f":"IF(G55=0,\"\",C56)","v":""},{"$f":"IF(E48+G48=0,0,IF(SUM(G48:G54)>SUM(E48:E54),0,SUM(E48:E54)-SUM(G48:G54)))","v":0},null,{"$f":"K55-M55","v":0},{"$f":"IF(K55=0,\"\",I56)","v":""},{"$f":"IF(K48+M48=0,0,IF(SUM(K48:K54)>SUM(M48:M54),0,SUM(M48:M54)-SUM(K48:K54)))","v":0},{"$f":"IF(M55=0,\"\",I56)","v":""},{"$f":"IF(K48+M48=0,0,IF(SUM(M48:M54)>SUM(K48:K54),0,SUM(K48:K54)-SUM(M48:M54)))","v":0},null,{"$f":"Q55-S55","v":0},{"$f":"IF(Q55=0,\"\",O56)","v":""},{"$f":"IF(Q48+S48=0,0,IF(SUM(Q48:Q54)>SUM(S48:S54),0,SUM(S48:S54)-SUM(Q48:Q54)))","v":0},{"$f":"IF(S55=0,\"\",O56)","v":""},{"$f":"IF(Q48+S48=0,0,IF(SUM(S48:S54)>SUM(Q48:Q54),0,SUM(Q48:Q54)-SUM(S48:S54)))","v":0},null,{"$f":"W55-Y55","v":0},{"$f":"IF(W55=0,\"\",U56)","v":""},{"$f":"IF(W48+Y48=0,0,IF(SUM(W48:W54)>SUM(Y48:Y54),0,SUM(Y48:Y54)-SUM(W48:W54)))","v":0},{"$f":"IF(Y55=0,\"\",U56)","v":""},{"$f":"IF(W48+Y48=0,0,IF(SUM(Y48:Y54)>SUM(W48:W54),0,SUM(W48:W54)-SUM(Y48:Y54)))","v":0},null,null,{"$f":"AD55-AF55","v":0},{"$f":"IF(AD55=0,\"\",AB56)","v":""},{"$f":"IF(AD48+AF48=0,0,IF(SUM(AD48:AD54)>SUM(AF48:AF54),0,SUM(AF48:AF54)-SUM(AD48:AD54)))","v":0},{"$f":"IF(AF55=0,\"\",AB56)","v":""},{"$f":"IF(AD48+AF48=0,0,IF(SUM(AF48:AF54)>SUM(AD48:AD54),0,SUM(AD48:AD54)-SUM(AF48:AF54)))","v":0},null,{"$f":"AJ55-AL55","v":0},{"$f":"IF(AJ55=0,\"\",AH56)","v":""},{"$f":"IF(AJ48+AL48=0,0,IF(SUM(AJ48:AJ54)>SUM(AL48:AL54),0,SUM(AL48:AL54)-SUM(AJ48:AJ54)))","v":0},{"$f":"IF(AL55=0,\"\",AH56)","v":""},{"$f":"IF(AJ48+AL48=0,0,IF(SUM(AL48:AL54)>SUM(AJ48:AJ54),0,SUM(AJ48:AJ54)-SUM(AL48:AL54)))","v":0},null,{"$f":"AP55-AR55","v":0},{"$f":"IF(AP55=0,\"\",AN56)","v":""},{"$f":"IF(AP48+AR48=0,0,IF(SUM(AP48:AP54)>SUM(AR48:AR54),0,SUM(AR48:AR54)-SUM(AP48:AP54)))","v":0},{"$f":"IF(AR55=0,\"\",AN56)","v":""},{"$f":"IF(AP48+AR48=0,0,IF(SUM(AR48:AR54)>SUM(AP48:AP54),0,SUM(AP48:AP54)-SUM(AR48:AR54)))","v":0},null,{"$f":"AV55-AX55","v":0},{"$f":"IF(AV55=0,\"\",AT56)","v":""},{"$f":"IF(AV48+AX48=0,0,IF(SUM(AV48:AV54)>SUM(AX48:AX54),0,SUM(AX48:AX54)-SUM(AV48:AV54)))","v":0},{"$f":"IF(AX55=0,\"\",AT56)","v":""},{"$f":"IF(AV48+AX48=0,0,IF(SUM(AX48:AX54)>SUM(AV48:AV54),0,SUM(AV48:AV54)-SUM(AX48:AX54)))","v":0},null,null,null,null,2,7]
[null,{"$f":"IF(B55=\"\",\"spb\",IF(B55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(B55=\"\",\"spb\",IF(B55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(E48+G48=0,\"\",SUM(E48:E55))","v":""},null,{"$f":"IF(E48+G48=0,\"\",SUM(G48:G55))","v":""},{"$f":"IF(H55=\"\",\"spb\",IF(H55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(H55=\"\",\"spb\",IF(H55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(K48+M48=0,\"\",SUM(K48:K55))","v":""},null,{"$f":"IF(K48+M48=0,\"\",SUM(M48:M55))","v":""},{"$f":"IF(N55=\"\",\"spb\",IF(N55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(N55=\"\",\"spb\",IF(N55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(Q48+S48=0,\"\",SUM(Q48:Q55))","v":""},null,{"$f":"IF(Q48+S48=0,\"\",SUM(S48:S55))","v":""},{"$f":"IF(T55=\"\",\"spb\",IF(T55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(T55=\"\",\"spb\",IF(T55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(W48+Y48=0,\"\",SUM(W48:W55))","v":""},null,{"$f":"IF(W48+Y48=0,\"\",SUM(Y48:Y55))","v":""},null,{"$f":"IF(AA55=\"\",\"spb\",IF(AA55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AA55=\"\",\"spb\",IF(AA55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AD48+AF48=0,\"\",SUM(AD48:AD55))","v":""},null,{"$f":"IF(AD48+AF48=0,\"\",SUM(AF48:AF55))","v":""},{"$f":"IF(AG55=\"\",\"spb\",IF(AG55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AG55=\"\",\"spb\",IF(AG55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AJ48+AL48=0,\"\",SUM(AJ48:AJ55))","v":""},null,{"$f":"IF(AJ48+AL48=0,\"\",SUM(AL48:AL55))","v":""},{"$f":"IF(AM55=\"\",\"spb\",IF(AM55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AM55=\"\",\"spb\",IF(AM55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AP48+AR48=0,\"\",SUM(AP48:AP55))","v":""},null,{"$f":"IF(AP48+AR48=0,\"\",SUM(AR48:AR55))","v":""},{"$f":"IF(AS55=\"\",\"spb\",IF(AS55>20,\"v/b.\",\"v/e\"))","v":"spb"},{"$f":"IF(AS55=\"\",\"spb\",IF(AS55>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(AV48+AX48=0,\"\",SUM(AV48:AV55))","v":""},null,{"$f":"IF(AV48+AX48=0,\"\",SUM(AX48:AX55))","v":""},null,null,null,null,1,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,0,null,{"$f":"IF(B58=0,\"\",VLOOKUP(B58,Libellés!B12:J37,2))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ges col.",2,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"9000 Résultat",null,null,null,null,null,null,null,null,null,"B I L A N  final ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,2,11]
[null,1,null,{"$f":"IF(E62=0,\"\",VLOOKUP(B62,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B62,table,2,FALSE)","v":0},{"$f":"IF(G62=0,\"\",VLOOKUP(H62,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H62,table,2,FALSE)","v":0},2,null,null,null,null,null,"Actif",null,null,null,null,null,"Passif",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,12]
[null,3,null,{"$f":"IF(E63=0,\"\",VLOOKUP(B63,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B63,table,2,FALSE)","v":0},{"$f":"IF(G63=0,\"\",VLOOKUP(H63,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H63,table,2,FALSE)","v":0},4,null,null,null,null,41,{"$f":"IF(S63=0,\"\",VLOOKUP(M63,table,3,FALSE))","v":""},null,null,null,null,{"$f":"VLOOKUP(M63,table,2,FALSE)","v":0},{"$f":"IF(Y63=0,\"\",VLOOKUP(Z63,table,3,FALSE))","v":""},null,null,null,null,{"$f":"VLOOKUP(Z63,table,2,FALSE)","v":0},42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2,13]
[null,5,null,"",0,"",0,6,null,null,null,null,43,"",null,null,null,null,0,"",null,null,null,null,0,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,14]
[null,7,null,"",0,"",0,8,null,null,null,null,45,"",null,null,null,null,0,"",null,null,null,null,0,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2,15]
[null,9,null,"",0,"",0,10,null,null,null,null,47,"",null,null,null,null,0,"",null,null,null,null,0,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,16]
[null,11,null,"",0,"",0,12,null,null,null,null,49,"",null,null,null,null,0,"",null,null,null,null,0,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2,17]
[null,13,null,"",0,"",0,14,null,null,null,null,51,"",null,null,null,null,0,"",null,null,null,null,0,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,1,18]
[null,15,null,"",0,"",0,16,null,null,null,null,53,{"$f":"IF(S69=0,\"\",VLOOKUP(M69,table,3,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(Y69=0,\"\",VLOOKUP(Z69,table,3,FALSE))","v":""},null,null,null,null,0,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,2,19]
[null,17,null,"",0,"",0,18,null,null,null,null,55,"",null,null,null,null,0,"",null,null,null,null,0,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,20]
[null,19,null,"",0,"",0,20,null,null,null,null,57,"",null,null,null,null,0,"",null,null,null,null,0,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD71/2)=BD71/2,1,2)","v":2},21]
[null,21,null,"",0,"",0,22,null,null,null,null,59,"",null,null,null,null,0,"",null,null,null,null,0,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,22]
[null,23,null,"",0,"",0,24,null,null,null,null,61,"",null,null,null,null,0,"",null,null,null,null,0,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,23]
[null,25,null,"",0,"",0,26,null,null,null,null,63,"",null,null,null,null,0,"",null,null,null,null,0,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,24]
[null,27,null,"",0,"",0,28,null,null,null,null,65,"",null,null,null,null,0,"",null,null,null,null,0,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,25]
[null,29,null,"",0,"",0,30,null,null,null,null,67,"",null,null,null,null,0,"",null,null,null,null,0,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,26]
[null,null,{"$f":"E77-G77","v":0},{"$f":"IF(E77=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(E62:E76)>SUM(G62:G76),0,SUM(G62:G76)-SUM(E62:E76))","v":0},{"$f":"IF(G77=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(G62:G76)>SUM(E62:E76),0,SUM(E62:E76)-SUM(G62:G76))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S77=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(S63:S76)>SUM(Y63:Y76),0,SUM(Y63:Y76)-SUM(S63:S76))","v":0},null,null,null,null,{"$f":"IF(Y77=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(Y63:Y76)>SUM(S63:S76),0,SUM(S63:S76)-SUM(Y63:Y76))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,27]
[null,null,null,null,{"$f":"SUM(E62:E77)","v":0},null,{"$f":"SUM(G62:G77)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S63:S77)","v":0},null,null,null,null,null,{"$f":"SUM(Y63:Y77)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,30]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INT(BD82/2)=BD82/2,1,2)","v":2},41,{"$f":"AT85","v":0},{"$f":"AU70","v":0},{"$f":"LEFT(BF82,4)","v":"0"},{"$f":"AT85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,45]
[null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,46]
[null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,47]
[null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,48]
[null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,49]
[null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,51]
[null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,52]
[null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,66]
[null,true,null,false,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,67]
[null,null,null,false,null,null,"oui",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,68]
[null,"Symboles de "]
[null,"Schmalenbach"]
[null,null,null,null,null,null,"zoom :",100]
[]
[null,null,null,1]
[]
[0,"Zoom 1",null,null,{"$f":"H112","v":100},null,"Rév. 12.02.06"]
[null,"Zoom 2",null,null,160]
[null,null,null,"9000 Résultat",null,null,null,null,null,null,null,null,null,null,null,"9000 Résultat"]
[null,1,null,{"$f":"IF(E119=0,\"\",VLOOKUP(B119,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B119,table,2,FALSE)","v":0},{"$f":"IF(G119=0,\"\",VLOOKUP(H119,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H119,table,2,FALSE)","v":0},2,null,null,null,null,null,1,null,{"$f":"IF(Q119=0,\"\",VLOOKUP(N119,table,4,FALSE))","v":""},{"$f":"VLOOKUP(N119,table,2,FALSE)","v":0},{"$f":"IF(S119=0,\"\",VLOOKUP(T119,table,4,FALSE))","v":""},{"$f":"VLOOKUP(T119,table,2,FALSE)","v":0},2]
[null,3,null,{"$f":"IF(E120=0,\"\",VLOOKUP(B120,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B120,table,2,FALSE)","v":0},{"$f":"IF(G120=0,\"\",VLOOKUP(H120,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H120,table,2,FALSE)","v":0},4,null,null,null,null,null,3,null,{"$f":"IF(Q120=0,\"\",VLOOKUP(N120,table,4,FALSE))","v":""},{"$f":"VLOOKUP(N120,table,2,FALSE)","v":0},{"$f":"IF(S120=0,\"\",VLOOKUP(T120,table,4,FALSE))","v":""},{"$f":"VLOOKUP(T120,table,2,FALSE)","v":0},4]
[null,5,null,{"$f":"IF(E121=0,\"\",VLOOKUP(B121,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B121,table,2,FALSE)","v":0},{"$f":"IF(G121=0,\"\",VLOOKUP(H121,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H121,table,2,FALSE)","v":0},6,null,null,null,null,null,5,null,"",0,"",0,6]
[null,7,null,{"$f":"IF(E122=0,\"\",VLOOKUP(B122,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B122,table,2,FALSE)","v":0},{"$f":"IF(G122=0,\"\",VLOOKUP(H122,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H122,table,2,FALSE)","v":0},8,null,null,null,null,null,7,null,"",0,"",0,8]
[null,null,null,{"$f":"IF(E123=0,\"\",\"BB\")","v":""},{"$f":"IF(SUM(E119:E122)>SUM(G119:G122),0,SUM(G119:G122)-SUM(E119:E122))","v":0},{"$f":"IF(G123=0,\"\",\"PB\")","v":""},{"$f":"IF(SUM(G119:G122)>SUM(E119:E122),0,SUM(E119:E122)-SUM(G119:G122))","v":0},null,null,null,null,null,null,9,null,"",0,"",0,10]
[null,null,null,null,{"$f":"SUM(E119:E123)","v":0},null,{"$f":"SUM(G119:G123)","v":0},null,null,null,null,null,null,11,null,"",0,"",0,12]
[null,null,null,{"$f":"F123","v":""},{"$f":"G123","v":0},{"$f":"D123","v":""},{"$f":"E123","v":0},null,null,null,null,null,null,13,null,"",0,"",0,14]
[null,15,null,{"$f":"IF(E126=0,\"\",VLOOKUP(B126,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B126,table,2,FALSE)","v":0},{"$f":"IF(G126=0,\"\",VLOOKUP(H126,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H126,table,2,FALSE)","v":0},16,null,null,null,null,null,15,null,"",0,"",0,16]
[null,17,null,"",0,"",0,18,null,null,null,null,null,17,null,{"$f":"IF(Q127=0,\"\",VLOOKUP(N127,table,4,FALSE))","v":""},{"$f":"VLOOKUP(N127,table,2,FALSE)","v":0},{"$f":"IF(S127=0,\"\",VLOOKUP(T127,table,4,FALSE))","v":""},{"$f":"VLOOKUP(T127,table,2,FALSE)","v":0},18]
[null,19,null,"",0,"",0,20,null,null,null,null,null,19,null,"",0,"",0,20]
[null,21,null,"",0,"",0,22,null,null,null,null,null,21,null,"",0,"",0,22]
[null,23,null,"",0,"",0,24,null,null,null,null,null,23,null,"",0,"",0,24]
[null,25,null,"",0,"",0,26,null,null,null,null,null,25,null,"",0,"",0,26]
[null,27,null,"",0,"",0,28,null,null,null,null,null,27,null,"",0,"",0,28]
[null,29,null,"",0,"",0,30,null,null,null,null,null,29,null,"",0,"",0,30]
[null,null,{"$f":"E134-G134","v":0},{"$f":"IF(E134=0,\"\",\"BN\")","v":""},{"$f":"IF(SUM(E125:E133)>SUM(G125:G133),0,SUM(G125:G133)-SUM(E125:E133))","v":0},{"$f":"IF(G134=0,\"\",\"PN\")","v":""},{"$f":"IF(SUM(G125:G133)>SUM(E125:E133),0,SUM(E125:E133)-SUM(G125:G133))","v":0},null,null,null,null,null,null,null,{"$f":"Q134-S134","v":0},{"$f":"IF(Q134=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(Q119:Q133)>SUM(S119:S133),0,SUM(S119:S133)-SUM(Q119:Q133))","v":0},{"$f":"IF(S134=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(S119:S133)>SUM(Q119:Q133),0,SUM(Q119:Q133)-SUM(S119:S133))","v":0}]
[null,null,null,null,{"$f":"SUM(E125:E134)","v":0},null,{"$f":"SUM(G125:G134)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q119:Q134)","v":0},null,{"$f":"SUM(S119:S134)","v":0}]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(B140=\"\",\"\",B140 & \" \" & VLOOKUP(B140,Plancompta,2))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N140=\"\",\"\",N140 & \" \" & VLOOKUP(N140,Plancompta,2))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q148+S148","v":0},{"$f":"IF(Q148=0,\"\",O149)","v":""},{"$f":"IF(Q141+S141=0,0,IF(SUM(Q141:Q147)>SUM(S141:S147),0,SUM(S141:S147)-SUM(Q141:Q147)))","v":0},{"$f":"IF(S148=0,\"\",O149)","v":""},{"$f":"IF(Q141+S141=0,0,IF(SUM(S141:S147)>SUM(Q141:Q147),0,SUM(Q141:Q147)-SUM(S141:S147)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N148=\"\",\"spb\",IF(N148>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(Q141+S141=0,\"\",SUM(Q141:Q148))","v":""},null,{"$f":"IF(Q141+S141=0,\"\",SUM(S141:S148))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N151=\"\",\"\",VLOOKUP(N151,Plancompta,3))","v":""},null,null,{"$f":"IF(N151=\"\",\"\",VLOOKUP(N151,Plancompta,4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N151=\"\",\"\",N151 & \" \" & VLOOKUP(N151,Plancompta,2))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"E159-G159","v":0},{"$f":"IF(E159=0,\"\",C160)","v":""},{"$f":"IF(E141+G141=0,0,IF(SUM(E141:E158)>SUM(G141:G158),0,SUM(G141:G158)-SUM(E141:E158)))","v":0},{"$f":"IF(G159=0,\"\",C160)","v":""},{"$f":"IF(E141+G141=0,0,IF(SUM(G141:G158)>SUM(E141:E158),0,SUM(E141:E158)-SUM(G141:G158)))","v":0},null,null,null,null,null,null,null,{"$f":"Q159+S159","v":0},{"$f":"IF(Q159=0,\"\",O160)","v":""},{"$f":"IF(Q152+S152=0,0,IF(SUM(Q152:Q158)>SUM(S152:S158),0,SUM(S152:S158)-SUM(Q152:Q158)))","v":0},{"$f":"IF(S159=0,\"\",O160)","v":""},{"$f":"IF(Q152+S152=0,0,IF(SUM(S152:S158)>SUM(Q152:Q158),0,SUM(Q152:Q158)-SUM(S152:S158)))","v":0}]
[null,null,{"$f":"IF(B159=\"\",\"spb\",IF(B159>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(E141+G141=0,\"\",SUM(E141:E159))","v":""},null,{"$f":"IF(E141+G141=0,\"\",SUM(G141:G159))","v":""},null,null,null,null,null,null,null,{"$f":"IF(N159=\"\",\"spb\",IF(N159>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(Q152+S152=0,\"\",SUM(Q152:Q159))","v":""},null,{"$f":"IF(Q152+S152=0,\"\",SUM(S152:S159))","v":""}]

{"sheet":"Libellés","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[31,2,31,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[36,2,36,9],[32,2,32,9],[33,2,33,9],[34,2,34,9],[35,2,35,9],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[29,2,29,9],[30,2,30,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,9],[19,2,19,9],[20,2,20,9],[0,1,0,8],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,9]]}
[null,"Libellés"]
[]
[null,"Les libellés donnés ci-dessous correspondent aux boutons. Ils sont affichés automatiquement"]
[]
[null,"lorsqu'un bouton est activé. "]
[]
[]
[]
[]
[]
[null,"Bouton","Libellé"]
[null,0,null,null,null,null,null,null,null,null,"Ce libellé ne s'affiche pas"]
[null,1,"Reçu des parents un dictionnaire CHF 75.-"]
[null,2,"Reçu de la tante Agathe CHF 100.-"]
[null,3,"Rétribution pour lle nettoyage des vitres CHF 20.-."]
[null,4,"Rendu à Kati en remboursement partiel de son prêt CHF 15.-"]
[null,5,"Vendu un livre à un copain CHF 50.-"]
[null,6,"Billet de cinéma CHF 10.-"]
[null,7,"Ice-cream CHF 3.-"]
[null,8,"Acheté Nitendo CHF 80.-"]
[null,9,"Acheté un porte-bagages pour le vélo CHF 25.-"]
[null,10,"Acheté un carnet pour le bus CHF 15.-"]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22,"                                                    Toutes les écritures \"rouges\" sont comptabilisées"]
[null,23,"Complément à La comptabilité un jeu d'enfant - La comptabilité de Toto ",null,null,null,null,null,null,null,"         boutons et macros à rajouter !"]
[]
[]
[null,null,{"$f":"COUNTA(C12:J33)","v":10}]

{"sheet":"Renseignements","index":2,"n_rows":106,"n_cols":34,"rows_kept":106,"cut":false,"hidden":false,"merged":[[61,19,61,22],[56,13,56,16],[57,13,57,16],[58,13,58,16],[55,19,55,22],[49,3,49,6],[52,13,52,16],[52,19,52,22],[53,13,53,16],[53,19,53,22],[59,13,59,16],[59,19,59,22],[54,13,54,16],[54,19,54,22],[61,13,61,16],[51,19,51,22],[56,19,56,22],[57,19,57,22],[58,19,58,22],[60,19,60,22],[4,3,4,6],[4,9,4,12],[4,15,4,18],[4,21,4,24],[60,13,60,16],[49,13,49,24],[50,13,50,18],[50,19,50,24],[51,13,51,16],[55,13,55,16]]}
[]
[null,null,null,null,null,null,null,"Entrer dans ces carrés le numéro du compte selon le plan comptable de la feuille 3"]
[]
[]
[null,1000,null,"1000 Caisse",null,null,null,1010,null,"1010 Poste",null,null,null,2000,null,"2000 Fournisseurs",null,null,null,null,null,"Blablabla"]
[null,null,null,"1)",100,null,null,null,null,"san",2000,"1)",100,null,null,null,null,"san",300,null,null,"3)",20,null,null,null,null,null,null,null,"table"]
[null,null,null,null,null,"3)",20,null,null,null,null,"2)",120,null,null,"2)",120,null,null,null,null,"4)",30,null,null,null,null,null,null,null,{"$f":"B13","v":41},{"$f":"C13","v":80},{"$f":"D5","v":"1000 Caisse"},{"$f":"LEFT(AG7,4)","v":"1000"}]
[null,null,null,null,null,null,null,null,null,null,null,"4)",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H13","v":43},{"$f":"I13","v":1750},{"$f":"J5","v":"1010 Poste"},"1010"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N13","v":42},{"$f":"O13","v":180},{"$f":"P5","v":"2000 Fournisseurs"},"2000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T13","v":1},{"$f":"U13","v":50},{"$f":"V5","v":"Blablabla"},"Blab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B24","v":0},{"$f":"C24","v":0},{"$f":"D16","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H24","v":0},{"$f":"I24","v":0},{"$f":"J16","v":0},"0"]
[null,41,{"$f":"E13+G13","v":80},{"$f":"IF(E13=0,\"\",B14)","v":""},{"$f":"IF(E6+G6=0,0,IF(SUM(E6:E12)>SUM(G6:G12),0,SUM(G6:G12)-SUM(E6:E12)))","v":0},{"$f":"IF(G13=0,\"\",B14)","v":"v/b."},{"$f":"IF(E6+G6=0,0,IF(SUM(G6:G12)>SUM(E6:E12),0,SUM(E6:E12)-SUM(G6:G12)))","v":80},43,{"$f":"K13+M13","v":1750},{"$f":"IF(K13=0,\"\",H14)","v":""},{"$f":"IF(K6+M6=0,0,IF(SUM(K6:K12)>SUM(M6:M12),0,SUM(M6:M12)-SUM(K6:K12)))","v":0},{"$f":"IF(M13=0,\"\",H14)","v":"v/b."},{"$f":"IF(K6+M6=0,0,IF(SUM(M6:M12)>SUM(K6:K12),0,SUM(K6:K12)-SUM(M6:M12)))","v":1750},42,{"$f":"Q13+S13","v":180},{"$f":"IF(Q13=0,\"\",N14)","v":"v/b."},{"$f":"IF(Q6+S6=0,0,IF(SUM(Q6:Q12)>SUM(S6:S12),0,SUM(S6:S12)-SUM(Q6:Q12)))","v":180},{"$f":"IF(S13=0,\"\",N14)","v":""},{"$f":"IF(Q6+S6=0,0,IF(SUM(S6:S12)>SUM(Q6:Q12),0,SUM(Q6:Q12)-SUM(S6:S12)))","v":0},1,{"$f":"W13+Y13","v":50},{"$f":"IF(W11=0,\"\",T12)","v":""},{"$f":"IF(W6+Y6=0,0,IF(SUM(W6:W12)>SUM(Y6:Y12),0,SUM(Y6:Y12)-SUM(W6:W12)))","v":0},{"$f":"IF(Y13=0,\"\",T14)","v":"v/e"},{"$f":"IF(W6+Y6=0,0,IF(SUM(Y6:Y12)>SUM(W6:W12),0,SUM(W6:W12)-SUM(Y6:Y12)))","v":50},null,null,null,null,null,{"$f":"N24","v":0},{"$f":"O24","v":0},{"$f":"P16","v":0},"0"]
[null,{"$f":"IF(B13=\"\",\"spb\",IF(B13>20,\"v/b.\",\"v/e\"))","v":"v/b."},null,null,{"$f":"IF(E6+G6=0,\"\",SUM(E6:E13))","v":100},null,{"$f":"IF(E6+G6=0,\"\",SUM(G6:G13))","v":100},{"$f":"IF(H13=\"\",\"spb\",IF(H13>20,\"v/b.\",\"v/e\"))","v":"v/b."},null,null,{"$f":"IF(K6+M6=0,\"\",SUM(K6:K13))","v":2000},null,{"$f":"IF(K6+M6=0,\"\",SUM(M6:M13))","v":2000},{"$f":"IF(N13=\"\",\"spb\",IF(N13>20,\"v/b.\",\"v/e\"))","v":"v/b."},null,null,{"$f":"IF(Q6+S6=0,\"\",SUM(Q6:Q13))","v":300},null,{"$f":"IF(Q6+S6=0,\"\",SUM(S6:S13))","v":300},{"$f":"IF(T13=\"\",\"spb\",IF(T13>20,\"v/b.\",\"v/e\"))","v":"v/e"},null,null,{"$f":"IF(W6+Y6=0,\"\",SUM(W6:W13))","v":50},null,{"$f":"IF(W6+Y6=0,\"\",SUM(Y6:Y13))","v":50},null,null,null,null,null,{"$f":"T24","v":0},{"$f":"U24","v":0},{"$f":"V16","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B35","v":0},{"$f":"C35","v":0},{"$f":"D27","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H35","v":0},{"$f":"I35","v":0},{"$f":"J27","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N35","v":0},{"$f":"O35","v":0},{"$f":"P27","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T35","v":0},{"$f":"U35","v":0},{"$f":"V27","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B46","v":0},{"$f":"C46","v":0},{"$f":"D38","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H46","v":0},{"$f":"I46","v":0},{"$f":"J38","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N46","v":0},{"$f":"O46","v":0},{"$f":"P38","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T46","v":0},{"$f":"U46","v":0},{"$f":"V38","v":0},"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B58","v":68},{"$f":"C58","v":50},{"$f":"D50","v":"9000 Résultat"},"9000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0,"  "]
[null,null,null,"9000 Résultat",null,null,null,null,null,null,null,null,null,"B I L A N  final ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0,"  "]
[null,1,null,{"$f":"IF(E51=0,\"\",VLOOKUP(B51,table,4,FALSE))","v":"Blab"},{"$f":"VLOOKUP(B51,table,2,FALSE)","v":50},{"$f":"IF(G51=0,\"\",VLOOKUP(H51,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H51,table,2,FALSE)","v":0},2,null,null,null,null,null,"Actif",null,null,null,null,null,"Passif",null,null,null,null,null,null,null,null,null,null,48,0,"  "]
[null,3,null,"",0,"",0,4,null,null,null,null,41,{"$f":"IF(S52=0,\"\",VLOOKUP(M52,table,3,FALSE))","v":"1000 Caisse"},null,null,null,null,{"$f":"VLOOKUP(M52,table,2,FALSE)","v":80},{"$f":"IF(Y52=0,\"\",VLOOKUP(Z52,table,3,FALSE))","v":"2000 Fournisseurs"},null,null,null,null,{"$f":"VLOOKUP(Z52,table,2,FALSE)","v":180},42,null,null,null,null,49,0,"  "]
[null,5,null,"",0,"",0,6,null,null,null,null,43,{"$f":"IF(S53=0,\"\",VLOOKUP(M53,table,3,FALSE))","v":"1010 Poste"},null,null,null,null,1750,{"$f":"IF(Y53=0,\"\",VLOOKUP(Z53,table,3,FALSE))","v":""},null,null,null,null,{"$f":"VLOOKUP(Z53,table,2,FALSE)","v":0},44,null,null,null,null,50,0,"  "]
[null,7,null,"",0,"",0,8,null,null,null,null,45,{"$f":"IF(S54=0,\"\",VLOOKUP(M54,table,3,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(Y54=0,\"\",VLOOKUP(Z54,table,3,FALSE))","v":""},null,null,null,null,{"$f":"VLOOKUP(Z54,table,2,FALSE)","v":0},46,null,null,null,null,51,0,"  "]
[null,9,null,"",0,"",0,10,null,null,null,null,47,"",null,null,null,null,0,"",null,null,null,null,0,48,null,null,null,null,52,0,"  "]
[null,11,null,"",0,"",0,12,null,null,null,null,49,"",null,null,null,null,0,"",null,null,null,null,0,50,null,null,null,null,53,0,"  "]
[null,13,null,"",0,"",null,14,null,null,null,null,51,"",null,null,null,null,0,"",null,null,null,null,0,52,null,null,null,null,54,0,"  "]
[null,68,{"$f":"E58+G58","v":50},{"$f":"IF(E58=0,\"\",\"spb\")","v":""},{"$f":"IF(E51+G51=0,0,IF(SUM(E51:E57)>SUM(G51:G57),0,SUM(G51:G57)-SUM(E51:E57)))","v":0},{"$f":"IF(G58=0,\"\",\"spb\")","v":"spb"},{"$f":"IF(E51+G51=0,0,IF(SUM(G51:G57)>SUM(E51:E57),0,SUM(E51:E57)-SUM(G51:G57)))","v":50},null,null,null,null,null,53,"",null,null,null,null,{"$f":"VLOOKUP(M58,table,2,FALSE)","v":0},"",null,null,null,null,0,54,null,null,null,null,55,0,"  "]
[null,null,null,null,{"$f":"IF(E51+G51=0,\"\",SUM(E51:E58))","v":50},null,{"$f":"IF(E51+G51=0,\"\",SUM(G51:G58))","v":50},null,null,null,null,null,55,"",null,null,null,null,{"$f":"VLOOKUP(M59,table,2,FALSE)","v":0},"",null,null,null,null,0,56,null,null,null,null,56,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,57,"",null,null,null,null,{"$f":"VLOOKUP(M60,table,2,FALSE)","v":0},{"$f":"IF(Y60=0,\"\",VLOOKUP(Z60,table,3,FALSE))","v":"9000 Résultat"},null,null,null,null,{"$f":"VLOOKUP(Z60,table,2,FALSE)","v":50},68,null,null,null,null,57,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,67,null,null,null,null,{"$f":"IF(S61=0,\"\",\"spb\")","v":""},{"$f":"IF(S52+V52=0,0,IF(SUM(S52:S60)>SUM(V52:V60),0,SUM(V52:V60)-SUM(S52:S60)))","v":0},null,null,null,null,{"$f":"IF(Y61=0,\"\",\"spb\")","v":""},{"$f":"IF(W52+Y52=0,0,IF(SUM(Y52:Y60)>SUM(W52:W60),0,SUM(W52:W60)-SUM(Y52:Y60)))","v":0},null,null,null,null,null,38,0,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S52+V52=0,\"\",SUM(S52:S61))","v":1830},null,null,null,null,null,{"$f":"IF(W52+Y52=0,\"\",SUM(Y52:Y61))","v":230},null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PS: Les boutons macros (voir macros) situés en haut de l'écran, sont déjà affectés aux ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"macros ecr1,  ecr2....ecr20;  del1, del2,...del20."]
[null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,"Il suffit donc de créer des macros ecrX pour les écritures  et des macros delX "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour effacer les écritures (X = no de l'écriture)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," © Yvan Péguiron - mars 2003"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Afficher ou masquer les soldes ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Afficher ou masquer les comptes \"Résultat\" et \"Bilan\"."]
[null,null,null,null,null,null,null,null,null,null,"pour balance."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montrer ou cacher les boutons macro du haut de la page."]
[null,null,null,null,null,null,null,null,null,null,"Petits ou grands comptes.",null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Si des titres de comptes ont été rentrés"]
[null,null,null,null,null,null,null,null,null,null,"à la main, la programmation de ces ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Effacer le contenu de tous les comptes. Les"]
[null,null,null,null,null,null,null,null,null,null,"titres en fonction du petit numéro disparaît. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"titres et la programmation des soldes demeurent."]
[null,null,null,null,null,null,null,null,null,null,"Ce bouton remettre les formules initiales ."]
[]
[null,null,null,null,null,null,null,null,null,null,"Choix de la grandeur du grand-livre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afficher ou masquer les petits carrés bleus ou gris."]
[null,null,null,null,null,null,"Le compte de résultat peut s'afficher avec 8 ou 15 lignes."]
[null,null,null,null,null,null,"                                                                           (Bilan; 7 ou 14 lignes)"]
[null,null,null,null,null,null,"Une présentation à deux niveaux est possible; 4 lignes pour"]
[null,null,null,null,null,null,"le BB et 3 lignes pour le BN.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attention, ce bouton n'efface pas les écritures mais"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vide les carrés bleus et gris. Ecrivez \"oui\" si vous êtes sûr !"]
[null,null,null,null,null,null,null,null,null,null,"Le premier compte peut être agrandi."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adaptez le grand-livre à votre écran ou à votre beamer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avec cette commande de zoom."]
[null,null,null,null,null,null,"Si vous souhaitez placer les symboles dans les titres,"]
[null,null,null,null,null,null,"il faut les copier et les coller à l'endroit voulu, manuellement !",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voir le grand-livre (remonte)."]

{"sheet":"Plan comptable","index":3,"n_rows":150,"n_cols":17,"rows_kept":150,"cut":false,"hidden":false,"merged":[[0,0,1,5]]}
["La liste ci-dessous est modifiable.                   (Veuillez respecter la hiérarchie des no)"]
[]
[null,1000,"Caisse"," +"," -",null,{"$f":"B46","v":2000},{"$f":"C46","v":"Fournisseurs"},null,{"$f":"B85","v":4000},{"$f":"C85","v":"Achats matière"},null,{"$f":"B76","v":3000},{"$f":"C76","v":"Production"},null,null,{"$f":"B3 & \"  \" & C3","v":"1000  Caisse"}]
[null,1010,"Poste"," +"," -",null,{"$f":"B47","v":2010},{"$f":"C47","v":"Autres dettes"},null,{"$f":"B86","v":4200},{"$f":"C86","v":"Achats march."},null,{"$f":"B77","v":3200},{"$f":"C77","v":"Ventes"},null,null,{"$f":"B4 & \"  \" & C4","v":"1010  Poste"}]
[null,1020,"Banque"," +"," -",null,2030,"Acomptes clients",null,4270,"Frais d'achats",null,3290,"Déduc.  Accord.",null,null,"1020  Banque"]
[null,1040,"Effets à recevoir"," +"," -",null,2100,"Dettes bancaires",null,4280,"Variation stock",null,3293,"Commis. versées",null,null,"1040  Effets à recevoir"]
[null,1060,"Titres"," +"," -",null,2150,"Dettes fin.",null,4290,"Déd. obtenues",null,3295,"Pertes /créances",null,null,"1060  Titres"]
[null,1100,"Créance débiteurs"," +"," -",null,2170,"Dettes AVS",null,4400,"Sous-traitance",null,3400,"Honoraires",null,null,"1100  Créance débiteurs"]
[null,1108,"Cré. douteuses"," +"," -",null,2175,"Dettes LPP",null,4700,"Charges directes",null,3600,"Produits  travaux",null,null,"1108  Cré. douteuses"]
[null,1109,"Prov. s/créances"," +"," -",null,2180,"Dettes Caisse AF",null,4900,"Déductions",null,3700,"Pres. à soi-même",null,null,"1109  Prov. s/créances"]
[null,1110,"Autres créances"," +"," -",null,null,null,null,null,null,null,3900,"Réd. s/ventes",null,null,"1110  Autres créances"]
[null,1140,"Avances salaires"," +"," -",null,{"$f":"B54","v":2200},"TVA due",null,{"$f":"B93","v":5000},"Salaires prod.",null,null,null,null,null,"1140  Avances salaires"]
[null,1170,"Impôt préalable I"," +"," -",null,2201,"TVA à décaisser",null,5200,"Salaires",null,null,null,null,null,"1170  Impôt préalable I"]
[null,1171,"Impôt préalable II"," +"," -",null,2230,"Dividendes",null,5270,"Charges sociales",null,null,null,null,null,"1171  Impôt préalable II"]
[null,1172,"Solde TVA"," +"," -",null,2235,"Tantièmes",null,5280,"Ch. de personnel",null,null,null,null,null,"1172  Solde TVA"]
[null,1176,"Créance AFC"," +"," -",null,2270,"AVS",null,null,null,null,{"$f":"B118","v":7400},{"$f":"C118","v":"Prod. financiers"},null,null,"1176  Créance AFC"]
[null,1192,"Acomptes four."," +"," -",null,2271,"Caisse pension",null,{"$f":"B97","v":6000},{"$f":"C97","v":"Loyer"},null,{"$f":"B119","v":7410},{"$f":"C119","v":"Ch. s/placements"},null,null,"1192  Acomptes four."]
[null,1193,"Effets protestés"," +"," -",null,2272,"Caisse comp.",null,{"$f":"B98","v":6100},{"$f":"C98","v":"Entretien & répar."},null,7500,"Prod. d'immeubles",null,null,"1193  Effets protestés"]
[null,1200,"Stock "," +"," -",null,null,null,null,6110,"Réparations",null,7510,"Ch.  s/ immeubles",null,null,"1200  Stock "]
[null,1210,"Stock matière"," +"," -",null,{"$f":"B61","v":2300},"Passif transitoire",null,6160,"Leasing",null,7520,"Chauffage",null,null,"1210  Stock matière"]
[null,1300,"Actif transitoire"," +"," -",null,2301,"Charges à payer",null,6200,"Frais véhicules",null,8000,"Produits exception.",null,null,"1300  Actif transitoire"]
[null,1301,"Ch. cons. d'av."," +"," -",null,2302,"Prod. cons. d'av.",null,6280,"Frais expédition",null,8005,"Subventions",null,null,"1301  Ch. cons. d'av."]
[null,1302,"Prod. à recevoir"," +"," -",null,2440,"Dettes hypoth.",null,6300,"Assurances",null,8010,"Charges exception.",null,null,"1302  Prod. à recevoir"]
[null,1420,"Participations"," +"," -",null,2500,"Prêt obtenu",null,6302,"Taxes",null,8015,"Pertes s/créances",null,null,"1420  Participations"]
[null,1440,"Prêts accordés"," +"," -",null,2600,"Provisions ",null,6400,"Electricité",null,8900,"Impôt sur bénéfice",null,null,"1440  Prêts accordés"]
[null,1450,"Cré. long terme"," +"," -",null,null,null,null,6500,"Frais adminis.",null,8910,"Impôt sur capital",null,null,"1450  Cré. long terme"]
[null,1500,"Machines"," +"," -",null,{"$f":"B67","v":2800},{"$f":"C67","v":"Capital"},null,6510,"Téléphones",null,9000,"Résultat",null,null,"1500  Machines"]
[null,1509,"Amo. s/machines"," +"," -",null,2850,"Privé",null,6520,"Abonnementgs",null,9100,"Bilan d'ouverture",null,null,"1509  Amo. s/machines"]
[null,1510,"Mobilier"," +"," -",null,2900,"Réserve générale",null,6570,"Frais informatique",null,9110,"Bilan de clôture",null,null,"1510  Mobilier"]
[null,1519,"Amor. s/mobilier"," +"," -",null,2910,"Réserve actions ",null,6600,"Publicité",null,null,null,null,null,"1519  Amor. s/mobilier"]
[null,1520,"Informatique"," +"," -",null,2920,"Réserve réévaluation",null,6700,"ACE",null,null,null,null,null,"1520  Informatique"]
[null,1529,"Amor. s/info."," +"," -",null,2930,"Réserve spéciale",null,6710,"Diff. de caisse",null,null,null,null,null,"1529  Amor. s/info."]
[null,1530,"Véhicules"," +"," -",null,2940,"Prime émission",null,6800,"Intérêts-charges",null,null,null,null,null,"1530  Véhicules"]
[null,1539,"Amor. s/véhicules"," +"," -",null,2990,"Bénéfice reporté",null,6840,"Frais bancaires",null,null,null,null,null,"1539  Amor. s/véhicules"]
[null,1540,"Outillage"," +"," -",null,2992,"Bénéfice bilan",null,6850,"Intérêts-produits",null,null,null,null,null,"1540  Outillage"]
[null,1549,"Amor. s/outillage"," +"," -",null,null,null,null,6860,"Frais d'émission",null,null,null,null,null,"1549  Amor. s/outillage"]
[null,1600,"Immeuble"," +"," -",null,null,null,null,6900,"Amortissements",null,null,null,null,null,"1600  Immeuble"]
[null,1609,"Amo. s/immeuble"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1609  Amo. s/immeuble"]
[null,1700,"Brevets"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1700  Brevets"]
[null,1709,"Amor. s/brevet"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1709  Amor. s/brevet"]
[null,1770,"Goodwill"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1770  Goodwill"]
[null,1779,"Amor. s/goodwill"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1779  Amor. s/goodwill"]
[null,1800,"Frais de fondation"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1800  Frais de fondation"]
[null,1850,"Actionnaires"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1850  Actionnaires"]
[null,1860,"Participants"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"1860  Participants"]
[null,2000,"Fournisseurs"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2000  Fournisseurs"]
[null,2010,"Autres dettes"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2010  Autres dettes"]
[null,2030,"Acomptes clients"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2030  Acomptes clients"]
[null,2100,"Dettes bancaires"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2100  Dettes bancaires"]
[null,2150,"Dettes fin."," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2150  Dettes fin."]
[null,2170,"Dettes AVS"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2170  Dettes AVS"]
[null,2175,"Dettes LPP"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2175  Dettes LPP"]
[null,2180,"Dettes Caisse AF"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2180  Dettes Caisse AF"]
[null,2200,"TVA due"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2200  TVA due"]
[null,2201,"TVA à décaisser"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2201  TVA à décaisser"]
[null,2230,"Dividendes"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2230  Dividendes"]
[null,2235,"Tantièmes"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2235  Tantièmes"]
[null,2270,"AVS"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2270  AVS"]
[null,2271,"Caisse pension"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2271  Caisse pension"]
[null,2272,"Caisse comp."," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2272  Caisse comp."]
[null,2300,"Passif transitoire"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2300  Passif transitoire"]
[null,2301,"Charges à payer"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2301  Charges à payer"]
[null,2302,"Prod. cons. d'av."," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2302  Prod. cons. d'av."]
[null,2440,"Dettes hypoth."," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2440  Dettes hypoth."]
[null,2500,"Prêt obtenu"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2500  Prêt obtenu"]
[null,2600,"Provisions "," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2600  Provisions "]
[null,2800,"Capital"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2800  Capital"]
[null,2850,"Privé"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B68 & \"  \" & C68","v":"2850  Privé"}]
[null,2900,"Réserve générale"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2900  Réserve générale"]
[null,2910,"Réserve actions "," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2910  Réserve actions "]
[null,2920,"Réserve réévaluation"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2920  Réserve réévaluation"]
[null,2930,"Réserve spéciale"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2930  Réserve spéciale"]
[null,2940,"Prime émission"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2940  Prime émission"]
[null,2990,"Bénéfice reporté"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2990  Bénéfice reporté"]
[null,2992,"Bénéfice bilan"," -"," + ",null,null,null,null,null,null,null,null,null,null,null,"2992  Bénéfice bilan"]
[null,3000,"Production"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3000  Production"]
[null,3200,"Ventes"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3200  Ventes"]
[null,3290,"Déduc.  Accord."," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3290  Déduc.  Accord."]
[null,3293,"Commis. versées"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3293  Commis. versées"]
[null,3295,"Pertes /créances"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3295  Pertes /créances"]
[null,3400,"Honoraires"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3400  Honoraires"]
[null,3600,"Produits  travaux"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3600  Produits  travaux"]
[null,3700,"Pres. à soi-même"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3700  Pres. à soi-même"]
[null,3900,"Réd. s/ventes"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"3900  Réd. s/ventes"]
[null,4000,"Achats matière"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4000  Achats matière"]
[null,4200,"Achats march."," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4200  Achats march."]
[null,4270,"Frais d'achats"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4270  Frais d'achats"]
[null,4280,"Variation stock"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4280  Variation stock"]
[null,4290,"Déd. obtenues"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4290  Déd. obtenues"]
[null,4400,"Sous-traitance"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4400  Sous-traitance"]
[null,4700,"Charges directes"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4700  Charges directes"]
[null,4900,"Déductions"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"4900  Déductions"]
[null,5000,"Salaires prod."," +"," -",null,null,null,null,null,null,null,null,null,null,null,"5000  Salaires prod."]
[null,5200,"Salaires"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"5200  Salaires"]
[null,5270,"Charges sociales"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"5270  Charges sociales"]
[null,5280,"Ch. de personnel"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"5280  Ch. de personnel"]
[null,6000,"Loyer"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6000  Loyer"]
[null,6100,"Entretien & répar."," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6100  Entretien & répar."]
[null,6110,"Réparations"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6110  Réparations"]
[null,6160,"Leasing"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6160  Leasing"]
[null,6200,"Frais véhicules"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6200  Frais véhicules"]
[null,6280,"Frais expédition"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6280  Frais expédition"]
[null,6300,"Assurances"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6300  Assurances"]
[null,6302,"Taxes"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6302  Taxes"]
[null,6400,"Electricité"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6400  Electricité"]
[null,6500,"Frais adminis."," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6500  Frais adminis."]
[null,6510,"Téléphones"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6510  Téléphones"]
[null,6520,"Abonnementgs"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6520  Abonnementgs"]
[null,6570,"Frais informatique"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6570  Frais informatique"]
[null,6600,"Publicité"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6600  Publicité"]
[null,6700,"ACE"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6700  ACE"]
[null,6710,"Diff. de caisse"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6710  Diff. de caisse"]
[null,6800,"Intérêts-charges"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6800  Intérêts-charges"]
[null,6840,"Frais bancaires"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6840  Frais bancaires"]
[null,6850,"Intérêts-produits"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6850  Intérêts-produits"]
[null,6860,"Frais d'émission"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6860  Frais d'émission"]
[null,6900,"Amortissements"," +"," -",null,null,null,null,null,null,null,null,null,null,null,"6900  Amortissements"]
[null,7400,"Prod. financiers"," -"," +",null,null,null,null,null,null,null,null,null,null,null,"7400  Prod. financiers"]
[null,7410,"Ch. s/placements",null,null,null,null,null,null,null,null,null,null,null,null,null,"7410  Ch. s/placements"]
[null,7500,"Prod. d'immeubles",null,null,null,null,null,null,null,null,null,null,null,null,null,"7500  Prod. d'immeubles"]
[null,7510,"Ch.  s/ immeubles",null,null,null,null,null,null,null,null,null,null,null,null,null,"7510  Ch.  s/ immeubles"]
[null,7520,"Chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"7520  Chauffage"]
[null,8000,"Produits exception.",null,null,null,null,null,null,null,null,null,null,null,null,null,"8000  Produits exception."]
[null,8005,"Subventions",null,null,null,null,null,null,null,null,null,null,null,null,null,"8005  Subventions"]
[null,8010,"Charges exception.",null,null,null,null,null,null,null,null,null,null,null,null,null,"8010  Charges exception."]
[null,8015,"Pertes s/créances",null,null,null,null,null,null,null,null,null,null,null,null,null,"8015  Pertes s/créances"]
[null,8900,"Impôt sur bénéfice",null,null,null,null,null,null,null,null,null,null,null,null,null,"8900  Impôt sur bénéfice"]
[null,8910,"Impôt sur capital",null,null,null,null,null,null,null,null,null,null,null,null,null,"8910  Impôt sur capital"]
[null,9000,"Résultat",null,null,null,null,null,null,null,null,null,null,null,null,null,"9000  Résultat"]
[null,9100,"Bilan d'ouverture",null,null,null,null,null,null,null,null,null,null,null,null,null,"9100  Bilan d'ouverture"]
[null,9110,"Bilan de clôture",null,null,null,null,null,null,null,null,null,null,null,null,null,"9110  Bilan de clôture"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B132 & \"  \" & C132","v":"  "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]