{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Grand-livre","Libellés","Renseignements","Plan comptable"],"not_rendered":{"images":3,"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Grand-livre","index":0,"n_rows":149,"n_cols":60,"rows_kept":149,"merged":[[2,3,2,6],[2,9,2,12],[2,15,2,18],[2,21,2,24],[2,28,2,31],[2,34,2,37],[2,40,2,43],[2,46,2,49],[13,3,13,6],[13,9,13,12],[13,15,13,18],[13,21,13,24],[13,28,13,31],[13,34,13,37],[13,40,13,43],[13,46,13,49],[24,3,24,6],[24,9,24,12],[24,15,24,18],[24,21,24,24],[24,28,24,31],[24,34,24,37],[24,40,24,43],[24,46,24,49],[35,3,35,6],[35,9,35,12],[35,15,35,18],[35,21,35,24],[35,28,35,31],[35,34,35,37],[35,40,35,43],[35,46,35,49],[46,1,47,1],[46,3,47,24],[46,53,48,53],[49,3,49,6],[49,13,49,24],[49,48,49,49],[50,13,50,18],[50,19,50,24],[51,13,51,16],[51,19,51,22],[51,29,51,31],[52,13,52,16],[52,19,52,22],[53,13,53,16],[53,19,53,22],[54,13,54,16],[54,19,54,22],[55,13,55,16],[55,19,55,22],[56,13,56,16],[56,19,56,22],[57,13,57,16],[57,19,57,22],[58,13,58,16],[58,19,58,22],[59,13,59,16],[59,19,59,22],[60,13,60,16],[60,19,60,22],[61,13,61,16],[61,19,61,22],[62,13,62,16],[62,19,62,22],[63,13,63,16],[63,19,63,22],[64,13,64,16],[64,19,64,22],[65,13,65,16],[65,19,65,22],[66,13,66,16],[66,19,66,22],[99,7,99,9],[100,7,100,9],[106,3,106,6],[106,15,106,18],[128,3,128,6],[128,15,128,18],[139,15,139,18]]}
[{"$nulls":21},{"$f":"Libellés!C38","v":7},{"$nulls":4}," "]
[{"$nulls":3},{"$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":" -"},{"$nulls":3},{"$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,1000,null,{"$f":"IF(B3=\"\",\"\",B3 & \" \" & VLOOKUP(B3,Plancompta,2))","v":"1000 Caisse"},{"$nulls":3},1010,null,{"$f":"IF(H3=\"\",\"\",H3 & \" \" & VLOOKUP(H3,Plancompta,2))","v":"1010 Poste"},{"$nulls":3},1020,null,{"$f":"IF(N3=\"\",\"\",N3 & \" \" & VLOOKUP(N3,Plancompta,2))","v":"1020 Banque"},{"$nulls":3},1060,null,{"$f":"IF(T3=\"\",\"\",T3 & \" \" & VLOOKUP(T3,Plancompta,2))","v":"1060 Titres"},{"$nulls":6},{"$f":"IF(AA3=\"\",\"\",AA3 & \" \" & VLOOKUP(AA3,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AG3=\"\",\"\",AG3 & \" \" & VLOOKUP(AG3,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AM3=\"\",\"\",AM3 & \" \" & VLOOKUP(AM3,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AS3=\"\",\"\",AS3 & \" \" & VLOOKUP(AS3,Plancompta,2))","v":""}]
[{"$nulls":3},"Si",{"v":2850,"d":"2,850.00"},"6)",{"v":1290,"d":"1,290.00"},null,null,"si",{"v":2500,"d":"2,500.00"},"4)",{"v":145,"d":"145.00"},null,null,"si",{"v":20000,"d":"20,000.00"},"5)",58.75,null,null,"si",{"v":6000,"d":"6,000.00"},{"$nulls":32},"table"]
[{"$nulls":9},"3)",{"v":600,"d":"600.00"},{"$nulls":43},{"$f":"IF(INT(BD5/2)=BD5/2,1,2)","v":2},{"$f":"B11","v":41},{"$f":"IF(BC5=2,BH5*-1,BH5)","v":{"v":1560,"d":"1,560.00"}},{"$f":"D3","v":"1000 Caisse"},{"$f":"LEFT(BF5,4)","v":"1000"},{"$f":"C11","v":{"v":-1560,"d":"-1,560.00"}}]
[{"$nulls":54},{"$f":"IF(INT(BD6/2)=BD6/2,1,2)","v":2},{"$f":"H11","v":43},{"v":2955,"d":"2,955.00"},{"$f":"J3","v":"1010 Poste"},{"$f":"LEFT(BF6,4)","v":"1010"},{"$f":"I11","v":{"v":-2955,"d":"-2,955.00"}}]
[{"$nulls":54},2,{"$f":"N11","v":45},{"v":19941.25,"d":"19,941.25"},{"$f":"P3","v":"1020 Banque"},"1020",{"$f":"O11","v":{"v":-19941.25,"d":"-19,941.25"}}]
[{"$nulls":54},2,{"$f":"T11","v":47},{"v":6000,"d":"6,000.00"},{"$f":"V3","v":"1060 Titres"},"1060",{"$f":"U11","v":{"v":-6000,"d":"-6,000.00"}}]
[{"$nulls":54},2,{"$f":"B22","v":49},{"v":4200,"d":"4,200.00"},{"$f":"D14","v":"1100 Débiteurs"},"1100",{"$f":"C22","v":{"v":-4200,"d":"-4,200.00"}}]
[{"$nulls":54},2,{"$f":"H22","v":51},{"v":15.1,"d":"15.10"},{"$f":"J14","v":"1170 Impôt préalable I"},"1170",{"$f":"I22","v":{"v":-15.1,"d":"-15.10"}}]
[null,41,{"$f":"E11-G11","v":{"v":-1560,"d":"-1,560.00"}},{"$f":"IF(E11=0,\"\",C12)","v":""},{"$f":"IF(E4+G4=0,0,IF(SUM(E4:E10)>SUM(G4:G10),0,SUM(G4:G10)-SUM(E4:E10)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G11=0,\"\",C12)","v":"v/bi"},{"$f":"IF(E4+G4=0,0,IF(SUM(G4:G10)>SUM(E4:E10),0,SUM(E4:E10)-SUM(G4:G10)))","v":{"v":1560,"d":"1,560.00"}},43,{"$f":"K11-M11","v":{"v":-2955,"d":"-2,955.00"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(M11=0,\"\",I12)","v":"v/bi"},{"$f":"IF(K4+M4=0,0,IF(SUM(M4:M10)>SUM(K4:K10),0,SUM(K4:K10)-SUM(M4:M10)))","v":{"v":2955,"d":"2,955.00"}},45,{"$f":"Q11-S11","v":{"v":-19941.25,"d":"-19,941.25"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(S11=0,\"\",O12)","v":"v/bi"},{"$f":"IF(Q4+S4=0,0,IF(SUM(S4:S10)>SUM(Q4:Q10),0,SUM(Q4:Q10)-SUM(S4:S10)))","v":{"v":19941.25,"d":"19,941.25"}},47,{"$f":"W11-Y11","v":{"v":-6000,"d":"-6,000.00"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(Y11=0,\"\",U12)","v":"v/bi"},{"$f":"IF(W4+Y4=0,0,IF(SUM(Y4:Y10)>SUM(W4:W10),0,SUM(W4:W10)-SUM(Y4:Y10)))","v":{"v":6000,"d":"6,000.00"}},null,null,{"$f":"AD11-AF11","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AJ11-AL11","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AP11-AR11","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AV11-AX11","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$nulls":4},2,{"$f":"N22","v":53},95.55,{"$f":"P14","v":"1171 Impôt préalable II"},"1171",{"$f":"O22","v":-95.55}]
[null,null,{"$f":"IF(B11=\"\",\"spb\",IF(B11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(E4+G4=0,\"\",SUM(E4:E11))","v":{"v":2850,"d":"2,850.00"}},null,{"$f":"IF(E4+G4=0,\"\",SUM(G4:G11))","v":{"v":2850,"d":"2,850.00"}},null,{"$f":"IF(H11=\"\",\"spb\",IF(H11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(K4+M4=0,\"\",SUM(K4:K11))","v":{"v":3100,"d":"3,100.00"}},null,{"$f":"IF(K4+M4=0,\"\",SUM(M4:M11))","v":{"v":3100,"d":"3,100.00"}},null,{"$f":"IF(N11=\"\",\"spb\",IF(N11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(Q4+S4=0,\"\",SUM(Q4:Q11))","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"IF(Q4+S4=0,\"\",SUM(S4:S11))","v":{"v":20000,"d":"20,000.00"}},null,{"$f":"IF(T11=\"\",\"spb\",IF(T11>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(W4+Y4=0,\"\",SUM(W4:W11))","v":{"v":6000,"d":"6,000.00"}},null,{"$f":"IF(W4+Y4=0,\"\",SUM(Y4:Y11))","v":{"v":6000,"d":"6,000.00"}},null,null,{"$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":""},null,{"$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":""},null,{"$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":""},null,{"$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":""},{"$nulls":4},1,{"$f":"T22","v":42},{"v":3000,"d":"3,000.00"},{"$f":"V14","v":"2000 Fournisseurs"},"2000",{"$f":"U22","v":{"v":3000,"d":"3,000.00"}}]
[{"$nulls":3},{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,Plancompta,3))","v":" +"},null,null,{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,Plancompta,4))","v":" -"},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":" + "},{"$nulls":3},{"$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":""},{"$nulls":4},1,{"$f":"B33","v":44},{"v":44.449999999999996,"d":"44.45"},{"$f":"D25","v":"2200 TVA due"},"2200",{"$f":"C33","v":{"v":44.449999999999996,"d":"44.45"}}]
[null,1100,null,{"$f":"IF(B14=\"\",\"\",B14 & \" \" & VLOOKUP(B14,Plancompta,2))","v":"1100 Débiteurs"},{"$nulls":3},1170,null,{"$f":"IF(H14=\"\",\"\",H14 & \" \" & VLOOKUP(H14,Plancompta,2))","v":"1170 Impôt préalable I"},{"$nulls":3},1171,null,{"$f":"IF(N14=\"\",\"\",N14 & \" \" & VLOOKUP(N14,Plancompta,2))","v":"1171 Impôt préalable II"},{"$nulls":3},2000,null,{"$f":"IF(T14=\"\",\"\",T14 & \" \" & VLOOKUP(T14,Plancompta,2))","v":"2000 Fournisseurs"},{"$nulls":6},{"$f":"IF(AA14=\"\",\"\",AA14 & \" \" & VLOOKUP(AA14,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AG14=\"\",\"\",AG14 & \" \" & VLOOKUP(AG14,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AM14=\"\",\"\",AM14 & \" \" & VLOOKUP(AM14,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AS14=\"\",\"\",AS14 & \" \" & VLOOKUP(AS14,Plancompta,2))","v":""},{"$nulls":7},1,{"$f":"H33","v":46},{"v":32550,"d":"32,550.00"},{"$f":"J25","v":"2800 Capital"},"2800",{"$f":"I33","v":{"v":32550,"d":"32,550.00"}}]
[{"$nulls":3},"si",{"v":4200,"d":"4,200.00"},"3)",{"v":631.8,"d":"631.80"},null,null,"2)",{"v":11.1,"d":"11.10"},"4)",0.35,null,null,"6)",95.55,{"$nulls":4},"4)",{"v":149.6,"d":"149.60"},"si",{"v":3000,"d":"3,000.00"},{"$nulls":29},1,{"$f":"N33","v":48},{"v":0,"d":"0.00"},{"$f":"P25","v":"2850 Privé"},"2850",{"$f":"O33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"1)",{"v":631.8,"d":"631.80"},{"$nulls":4},"5)",4.35,{"$nulls":12},"2)",{"v":149.6,"d":"149.60"},{"$nulls":29},2,{"$f":"T33","v":55},{"v":1194.45,"d":"1,194.45"},{"$f":"V25","v":"1520 Informatique"},"1520",{"$f":"U33","v":{"v":-1194.45,"d":"-1,194.45"}}]
[{"$nulls":54},1,{"$f":"B44","v":2},555.55,{"$f":"D36","v":"3200 Ventes"},"3200",{"$f":"C44","v":555.55}]
[{"$nulls":54},2,{"$f":"H44","v":1},134.25,{"$f":"J36","v":"4200 Achats march."},"4200",{"$f":"I44","v":-134.25}]
[{"$nulls":54},2,{"$f":"N44","v":3},{"v":54.4,"d":"54.40"},{"$f":"P36","v":"4300 Frais de livraison"},"4300",{"$f":"O44","v":{"v":-54.4,"d":"-54.40"}}]
[{"$nulls":54},1,{"$f":"T44","v":4},{"v":0,"d":"0.00"},{"$f":"V36","v":"7400 Prod. financiers"},"7400",{"$f":"U44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"B66","v":0},{"v":366.9,"d":"366.90"},{"$f":"D50","v":"9000 Résultat"},"9000",{"$f":"C66","v":{"v":366.9,"d":"366.90"}}]
[null,49,{"$f":"E22-G22","v":{"v":-4200,"d":"-4,200.00"}},{"$f":"IF(E22=0,\"\",C23)","v":""},{"$f":"IF(E15+G15=0,0,IF(SUM(E15:E21)>SUM(G15:G21),0,SUM(G15:G21)-SUM(E15:E21)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G22=0,\"\",C23)","v":"v/bi"},{"$f":"IF(E15+G15=0,0,IF(SUM(G15:G21)>SUM(E15:E21),0,SUM(E15:E21)-SUM(G15:G21)))","v":{"v":4200,"d":"4,200.00"}},51,{"$f":"K22-M22","v":{"v":-15.1,"d":"-15.10"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(M22=0,\"\",I23)","v":"v/bi"},{"$f":"IF(K15+M15=0,0,IF(SUM(M15:M21)>SUM(K15:K21),0,SUM(K15:K21)-SUM(M15:M21)))","v":{"v":15.1,"d":"15.10"}},53,{"$f":"Q22-S22","v":-95.55},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(S22=0,\"\",O23)","v":"v/bi"},{"$f":"IF(Q15+S15=0,0,IF(SUM(S15:S21)>SUM(Q15:Q21),0,SUM(Q15:Q21)-SUM(S15:S21)))","v":95.55},42,{"$f":"W22-Y22","v":{"v":3000,"d":"3,000.00"}},{"$f":"IF(W22=0,\"\",U23)","v":"v/bi"},{"$f":"IF(W15+Y15=0,0,IF(SUM(W15:W21)>SUM(Y15:Y21),0,SUM(Y15:Y21)-SUM(W15:W21)))","v":{"v":3000,"d":"3,000.00"}},{"$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":{"v":0,"d":"0.00"}},null,null,{"$f":"AD22-AF22","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AJ22-AL22","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AP22-AR22","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AV22-AX22","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$nulls":4},1,{"$f":"AA11","v":0},{"v":0,"d":"0.00"},{"$f":"AC3","v":""},"",{"$f":"AB11","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(B22=\"\",\"spb\",IF(B22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(E15+G15=0,\"\",SUM(E15:E22))","v":{"v":4831.8,"d":"4,831.80"}},null,{"$f":"IF(E15+G15=0,\"\",SUM(G15:G22))","v":{"v":4831.8,"d":"4,831.80"}},null,{"$f":"IF(H22=\"\",\"spb\",IF(H22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(K15+M15=0,\"\",SUM(K15:K22))","v":15.45},null,{"$f":"IF(K15+M15=0,\"\",SUM(M15:M22))","v":15.45},null,{"$f":"IF(N22=\"\",\"spb\",IF(N22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(Q15+S15=0,\"\",SUM(Q15:Q22))","v":95.55},null,{"$f":"IF(Q15+S15=0,\"\",SUM(S15:S22))","v":95.55},null,{"$f":"IF(T22=\"\",\"spb\",IF(T22>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(W15+Y15=0,\"\",SUM(W15:W22))","v":{"v":3149.6,"d":"3,149.60"}},null,{"$f":"IF(W15+Y15=0,\"\",SUM(Y15:Y22))","v":{"v":3149.6,"d":"3,149.60"}},null,null,{"$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":""},null,{"$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":""},null,{"$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":""},null,{"$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":""},{"$nulls":4},1,{"$f":"AG11","v":0},{"v":0,"d":"0.00"},{"$f":"AI3","v":""},"",{"$f":"AH11","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$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":" -"},{"$nulls":3},{"$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":""},{"$nulls":4},1,{"$f":"AM11","v":0},{"v":0,"d":"0.00"},{"$f":"AO3","v":""},"",{"$f":"AN11","v":{"v":0,"d":"0.00"}}]
[null,2200,null,{"$f":"IF(B25=\"\",\"\",B25 & \" \" & VLOOKUP(B25,Plancompta,2))","v":"2200 TVA due"},{"$nulls":3},2800,null,{"$f":"IF(H25=\"\",\"\",H25 & \" \" & VLOOKUP(H25,Plancompta,2))","v":"2800 Capital"},{"$nulls":3},2850,null,{"$f":"IF(N25=\"\",\"\",N25 & \" \" & VLOOKUP(N25,Plancompta,2))","v":"2850 Privé"},{"$nulls":3},1520,null,{"$f":"IF(T25=\"\",\"\",T25 & \" \" & VLOOKUP(T25,Plancompta,2))","v":"1520 Informatique"},{"$nulls":6},{"$f":"IF(AA25=\"\",\"\",AA25 & \" \" & VLOOKUP(AA25,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AG25=\"\",\"\",AG25 & \" \" & VLOOKUP(AG25,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AM25=\"\",\"\",AM25 & \" \" & VLOOKUP(AM25,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AS25=\"\",\"\",AS25 & \" \" & VLOOKUP(AS25,Plancompta,2))","v":""},{"$nulls":7},1,{"$f":"AS11","v":0},{"v":0,"d":"0.00"},{"$f":"AU3","v":""},"",{"$f":"AT11","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"3)",2.35,"1)",{"v":46.8,"d":"46.80"},{"$nulls":4},"si",{"v":32550,"d":"32,550.00"},{"$nulls":8},"6)",{"v":1194.45,"d":"1,194.45"},{"$nulls":31},1,{"$f":"AA22","v":0},{"v":0,"d":"0.00"},{"$f":"AC14","v":""},"",{"$f":"AB22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AG22","v":0},{"v":0,"d":"0.00"},{"$f":"AI14","v":""},"",{"$f":"AH22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AM22","v":0},{"v":0,"d":"0.00"},{"$f":"AO14","v":""},"",{"$f":"AN22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AS22","v":0},{"v":0,"d":"0.00"},{"$f":"AU14","v":""},"",{"$f":"AT22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AA33","v":0},{"v":0,"d":"0.00"},{"$f":"AC25","v":""},"",{"$f":"AB33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AG33","v":0},{"v":0,"d":"0.00"},{"$f":"AI25","v":""},"",{"$f":"AH33","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},1,{"$f":"AM33","v":0},{"v":0,"d":"0.00"},{"$f":"AO25","v":""},"",{"$f":"AN33","v":{"v":0,"d":"0.00"}}]
[null,44,{"$f":"E33-G33","v":{"v":44.449999999999996,"d":"44.45"}},{"$f":"IF(E33=0,\"\",C34)","v":"v/bi"},{"$f":"IF(E26+G26=0,0,IF(SUM(E26:E32)>SUM(G26:G32),0,SUM(G26:G32)-SUM(E26:E32)))","v":{"v":44.449999999999996,"d":"44.45"}},{"$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":{"v":0,"d":"0.00"}},46,{"$f":"K33-M33","v":{"v":32550,"d":"32,550.00"}},{"$f":"IF(K33=0,\"\",I34)","v":"v/bi"},{"$f":"IF(K26+M26=0,0,IF(SUM(K26:K32)>SUM(M26:M32),0,SUM(M26:M32)-SUM(K26:K32)))","v":{"v":32550,"d":"32,550.00"}},{"$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":{"v":0,"d":"0.00"}},48,{"$f":"Q33-S33","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},55,{"$f":"W33-Y33","v":{"v":-1194.45,"d":"-1,194.45"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(Y33=0,\"\",U34)","v":"v/bi"},{"$f":"IF(W26+Y26=0,0,IF(SUM(Y26:Y32)>SUM(W26:W32),0,SUM(W26:W32)-SUM(Y26:Y32)))","v":{"v":1194.45,"d":"1,194.45"}},null,null,{"$f":"AD33-AF33","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AJ33-AL33","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AP33-AR33","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AV33-AX33","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$nulls":4},1,{"$f":"AS33","v":0},{"v":0,"d":"0.00"},{"$f":"AU25","v":""},"",{"$f":"AT33","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(B33=\"\",\"spb\",IF(B33>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(E26+G26=0,\"\",SUM(E26:E33))","v":{"v":46.8,"d":"46.80"}},null,{"$f":"IF(E26+G26=0,\"\",SUM(G26:G33))","v":{"v":46.8,"d":"46.80"}},null,{"$f":"IF(H33=\"\",\"spb\",IF(H33>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(K26+M26=0,\"\",SUM(K26:K33))","v":{"v":32550,"d":"32,550.00"}},null,{"$f":"IF(K26+M26=0,\"\",SUM(M26:M33))","v":{"v":32550,"d":"32,550.00"}},null,{"$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":""},null,{"$f":"IF(T33=\"\",\"spb\",IF(T33>40,\"v/bi\",\"v/ex\"))","v":"v/bi"},null,{"$f":"IF(W26+Y26=0,\"\",SUM(W26:W33))","v":{"v":1194.45,"d":"1,194.45"}},null,{"$f":"IF(W26+Y26=0,\"\",SUM(Y26:Y33))","v":{"v":1194.45,"d":"1,194.45"}},null,null,{"$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":""},null,{"$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":""},null,{"$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":""},null,{"$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":""},{"$nulls":4},1,{"$f":"AA44","v":0},{"v":0,"d":"0.00"},{"$f":"AC36","v":""},"",{"$f":"AB44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"$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":" +"},{"$nulls":3},{"$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":""},{"$nulls":4},1,{"$f":"AG44","v":0},{"v":0,"d":"0.00"},{"$f":"AI36","v":""},"",{"$f":"AH44","v":{"v":0,"d":"0.00"}}]
[null,3200,null,{"$f":"IF(B36=\"\",\"\",B36 & \" \" & VLOOKUP(B36,Plancompta,2))","v":"3200 Ventes"},{"$nulls":3},4200,null,{"$f":"IF(H36=\"\",\"\",H36 & \" \" & VLOOKUP(H36,Plancompta,2))","v":"4200 Achats march."},{"$nulls":3},4300,null,{"$f":"IF(N36=\"\",\"\",N36 & \" \" & VLOOKUP(N36,Plancompta,2))","v":"4300 Frais de livraison"},{"$nulls":3},7400,null,{"$f":"IF(T36=\"\",\"\",T36 & \" \" & VLOOKUP(T36,Plancompta,2))","v":"7400 Prod. financiers"},{"$nulls":6},{"$f":"IF(AA36=\"\",\"\",AA36 & \" \" & VLOOKUP(AA36,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AG36=\"\",\"\",AG36 & \" \" & VLOOKUP(AG36,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AM36=\"\",\"\",AM36 & \" \" & VLOOKUP(AM36,Plancompta,2))","v":""},{"$nulls":5},{"$f":"IF(AS36=\"\",\"\",AS36 & \" \" & VLOOKUP(AS36,Plancompta,2))","v":""},{"$nulls":7},1,{"$f":"AM44","v":0},{"v":0,"d":"0.00"},{"$f":"AO36","v":""},"",{"$f":"AN44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"3)",29.45,"1)",{"v":585,"d":"585.00"},null,null,"2)",{"v":138.5,"d":"138.50"},"4)",4.25,null,null,"5)",{"v":54.4,"d":"54.40"},{"$nulls":37},1,{"$f":"AS44","v":0},{"v":0,"d":"0.00"},{"$f":"AU36","v":""},"",{"$f":"AT44","v":{"v":0,"d":"0.00"}}]
[{"$nulls":54},2,1,{"$f":"AT46","v":0},0,"0",{"$f":"AT46","v":0}]
[{"$nulls":54},1,2,{"$f":"AT47","v":0},0,"0",{"$f":"AT47","v":0}]
[{"$nulls":54},2,3,{"$f":"AT48","v":0},0,"0",{"$f":"AT48","v":0}]
[{"$nulls":54},1,4,{"$f":"AT50","v":0},0,"0",{"$f":"AT50","v":0}]
[{"$nulls":54},2,5,{"$f":"AT51","v":0},0,"0",{"$f":"AT51","v":0}]
[{"$nulls":54},1,6,{"$f":"AT52","v":0},0,"0",{"$f":"AT52","v":0}]
[null,2,{"$f":"E44-G44","v":555.55},{"$f":"IF(E44=0,\"\",C45)","v":"v/ex"},{"$f":"IF(E37+G37=0,0,IF(SUM(E37:E43)>SUM(G37:G43),0,SUM(G37:G43)-SUM(E37:E43)))","v":555.55},{"$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":{"v":0,"d":"0.00"}},1,{"$f":"K44-M44","v":-134.25},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(M44=0,\"\",I45)","v":"v/ex"},{"$f":"IF(K37+M37=0,0,IF(SUM(M37:M43)>SUM(K37:K43),0,SUM(K37:K43)-SUM(M37:M43)))","v":134.25},3,{"$f":"Q44-S44","v":{"v":-54.4,"d":"-54.40"}},{"$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":{"v":0,"d":"0.00"}},{"$f":"IF(S44=0,\"\",O45)","v":"v/ex"},{"$f":"IF(Q37+S37=0,0,IF(SUM(S37:S43)>SUM(Q37:Q43),0,SUM(Q37:Q43)-SUM(S37:S43)))","v":{"v":54.4,"d":"54.40"}},4,{"$f":"W44-Y44","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,null,{"$f":"AD44-AF44","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AJ44-AL44","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AP44-AR44","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},null,{"$f":"AV44-AX44","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$nulls":4},2,7,{"$f":"AT53","v":0},0,"0",{"$f":"AT53","v":0}]
[null,null,{"$f":"IF(B44=\"\",\"spb\",IF(B44>40,\"v/bi\",\"v/ex\"))","v":"v/ex"},null,{"$f":"IF(E37+G37=0,\"\",SUM(E37:E44))","v":{"v":585,"d":"585.00"}},null,{"$f":"IF(E37+G37=0,\"\",SUM(G37:G44))","v":{"v":585,"d":"585.00"}},null,{"$f":"IF(H44=\"\",\"spb\",IF(H44>40,\"v/bi\",\"v/ex\"))","v":"v/ex"},null,{"$f":"IF(K37+M37=0,\"\",SUM(K37:K44))","v":{"v":138.5,"d":"138.50"}},null,{"$f":"IF(K37+M37=0,\"\",SUM(M37:M44))","v":{"v":138.5,"d":"138.50"}},null,{"$f":"IF(N44=\"\",\"spb\",IF(N44>40,\"v/bi\",\"v/ex\"))","v":"v/ex"},null,{"$f":"IF(Q37+S37=0,\"\",SUM(Q37:Q44))","v":{"v":54.4,"d":"54.40"}},null,{"$f":"IF(Q37+S37=0,\"\",SUM(S37:S44))","v":{"v":54.4,"d":"54.40"}},null,{"$f":"IF(T44=\"\",\"spb\",IF(T44>40,\"v/bi\",\"v/ex\"))","v":"v/ex"},null,{"$f":"IF(W37+Y37=0,\"\",SUM(W37:W44))","v":""},null,{"$f":"IF(W37+Y37=0,\"\",SUM(Y37:Y44))","v":""},null,null,{"$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":""},null,{"$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":""},null,{"$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":""},null,{"$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":""},{"$nulls":4},1,8,{"$f":"AT54","v":0},"","",{"$f":"AT54","v":0}]
[{"$nulls":54},1]
[null,22,null,{"$f":"IF(B47=0,\"\",VLOOKUP(B47,Libellés!B12:J37,2))","v":"                                                    Toutes les écritures sont comptabilisées"},{"$nulls":49},"Ges col.",2,9,{"$f":"AT55","v":0},{"$f":"AU45","v":0},"0",{"$f":"AT55","v":0}]
[{"$nulls":54},1,10,{"$f":"AT58","v":0},{"$f":"AU47","v":0},"0",{"$f":"AT58","v":0}]
[{"$nulls":54},1]
[{"$nulls":3},"9000 Résultat",{"$nulls":9},"B I L A N  final ",{"$nulls":39},1,2,11,{"$f":"AT59","v":0},{"$f":"AU48","v":0},"0",{"$f":"AT59","v":0}]
[null,1,null,{"$f":"IF(E51=0,\"\",VLOOKUP(B51,table,4,FALSE))","v":"4200"},{"$f":"VLOOKUP(B51,table,2,FALSE)","v":134.25},{"$f":"IF(G51=0,\"\",VLOOKUP(H51,table,4,FALSE))","v":"3200"},{"$f":"VLOOKUP(H51,table,2,FALSE)","v":555.55},2,{"$nulls":5},"Actif",{"$nulls":5},"Passif",{"$nulls":33},true,1,12,{"$f":"AT65","v":0},{"$f":"AU50","v":0},"0",{"$f":"AT65","v":0}]
[null,3,null,{"$f":"IF(E52=0,\"\",VLOOKUP(B52,table,4,FALSE))","v":"4300"},{"$f":"VLOOKUP(B52,table,2,FALSE)","v":{"v":54.4,"d":"54.40"}},{"$f":"IF(G52=0,\"\",VLOOKUP(H52,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H52,table,2,FALSE)","v":{"v":0,"d":"0.00"}},4,{"$nulls":4},41,{"$f":"IF(S52=0,\"\",VLOOKUP(M52,table,3,FALSE))","v":"1000 Caisse"},{"$nulls":4},{"$f":"VLOOKUP(M52,table,2,FALSE)","v":{"v":1560,"d":"1,560.00"}},{"$f":"IF(Y52=0,\"\",VLOOKUP(Z52,table,3,FALSE))","v":"2000 Fournisseurs"},{"$nulls":4},{"$f":"VLOOKUP(Z52,table,2,FALSE)","v":{"v":3000,"d":"3,000.00"}},42,{"$nulls":27},true,2,13,0,0,"0",0]
[null,5,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},6,{"$nulls":4},43,"1010 Poste",{"$nulls":4},{"v":2955,"d":"2,955.00"},"2200 TVA due",{"$nulls":4},{"v":44.449999999999996,"d":"44.45"},44,{"$nulls":27},true,1,14,0,0,"0",0]
[null,7,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},8,{"$nulls":4},45,"1020 Banque",{"$nulls":4},{"v":19941.25,"d":"19,941.25"},"2800 Capital",{"$nulls":4},{"v":32550,"d":"32,550.00"},46,{"$nulls":27},true,2,15,0,0,"0",0]
[null,9,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},10,{"$nulls":4},47,"1060 Titres",{"$nulls":4},{"v":6000,"d":"6,000.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},48,{"$nulls":27},true,1,16,0,0,"0",0]
[null,11,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},12,{"$nulls":4},49,"1100 Débiteurs",{"$nulls":4},{"v":4200,"d":"4,200.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},50,{"$nulls":27},true,2,17,0,0,"0",0]
[null,13,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},14,{"$nulls":4},51,"1170 Impôt préalable I",{"$nulls":4},{"v":15.1,"d":"15.10"},"",{"$nulls":4},{"v":0,"d":"0.00"},52,{"$nulls":27},true,1,18,0,0,"0",0]
[null,15,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},16,{"$nulls":4},53,{"$f":"IF(S58=0,\"\",VLOOKUP(M58,table,3,FALSE))","v":"1171 Impôt préalable II"},{"$nulls":4},95.55,{"$f":"IF(Y58=0,\"\",VLOOKUP(Z58,table,3,FALSE))","v":""},{"$nulls":4},{"v":0,"d":"0.00"},54,{"$nulls":27},true,2,19,0,0,"0",0]
[null,17,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},18,{"$nulls":4},55,"1520 Informatique",{"$nulls":4},{"v":1194.45,"d":"1,194.45"},"",{"$nulls":4},{"v":0,"d":"0.00"},56,{"$nulls":28},1,20,0,0,"0",0]
[null,19,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},20,{"$nulls":4},57,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},58,{"$nulls":28},{"$f":"IF(INT(BD60/2)=BD60/2,1,2)","v":2},21,0,0,"0",0]
[null,21,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},22,{"$nulls":4},59,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},60,{"$nulls":28},1,22,0,0,"0",0]
[null,23,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},24,{"$nulls":4},61,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},62,{"$nulls":28},2,23,0,0,"0",0]
[null,25,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},26,{"$nulls":4},63,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},64,{"$nulls":28},1,24,0,0,"0",0]
[null,27,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},28,{"$nulls":4},65,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},66,{"$nulls":28},2,25,0,0,"0",0]
[null,29,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},30,{"$nulls":4},67,"",{"$nulls":4},{"v":0,"d":"0.00"},"",{"$nulls":4},{"v":0,"d":"0.00"},68,{"$nulls":28},1,26,0,0,"0",0]
[null,null,{"$f":"E66-G66","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(E66=0,\"\",\"spb\")","v":"spb"},{"$f":"IF(SUM(E51:E65)>SUM(G51:G65),0,SUM(G51:G65)-SUM(E51:E65))","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(G66=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(G51:G65)>SUM(E51:E65),0,SUM(E51:E65)-SUM(G51:G65))","v":{"v":0,"d":"0.00"}},{"$nulls":10},{"$f":"IF(S66=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(S52:S65)>SUM(Y52:Y65),0,SUM(Y52:Y65)-SUM(S52:S65))","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(Y66=0,\"\",\"spb\")","v":"spb"},{"$f":"IF(SUM(Y52:Y65)>SUM(S52:S65),0,SUM(S52:S65)-SUM(Y52:Y65))","v":{"v":366.90000000000146,"d":"366.90"}},{"$nulls":29},2,27,0,0,"0",0]
[{"$nulls":4},{"$f":"SUM(E51:E66)","v":555.55},null,{"$f":"SUM(G51:G66)","v":555.55},{"$nulls":11},{"$f":"SUM(S52:S66)","v":{"v":35961.35,"d":"35,961.35"}},{"$nulls":5},{"$f":"SUM(Y52:Y66)","v":{"v":35961.35,"d":"35,961.35"}},{"$nulls":29},1,28,0,0,"0",0]
[{"$nulls":54},2,29,0,0,"0",0]
[{"$nulls":54},1,30,0,0,"0",0]
[]
[{"$nulls":54},{"$f":"IF(INT(BD71/2)=BD71/2,1,2)","v":2},41,{"$f":"AT74","v":0},{"$f":"AU59","v":0},{"$f":"LEFT(BF71,4)","v":"0"},{"$f":"AT74","v":0}]
[{"$nulls":54},{"$f":"IF(INT(BD72/2)=BD72/2,1,2)","v":1},42,{"$f":"AT75","v":0},{"$f":"AU60","v":0},{"$f":"LEFT(BF72,4)","v":"0"},{"$f":"AT75","v":0}]
[{"$nulls":54},2,43,0,0,"0",0]
[{"$nulls":54},1,44,0,0,"0",0]
[{"$nulls":10},true,{"$nulls":43},2,45,0,0,"0",0]
[{"$nulls":10},2,{"$nulls":43},1,46,0,0,"0",0]
[{"$nulls":10},1,{"$nulls":43},2,47,0,0,"0",0]
[{"$nulls":10},1,{"$nulls":43},1,48,0,0,"0",0]
[{"$nulls":10},true,{"$nulls":43},2,49,0,0,"0",0]
[{"$nulls":54},1,50,0,0,"0",0]
[{"$nulls":54},2,51,0,0,"0",0]
[{"$nulls":54},1,52,0,0,"0",0]
[{"$nulls":54},2,53,0,0,"0",0]
[{"$nulls":54},1,54,0,0,"0",0]
[{"$nulls":54},2,55,0,0,"0",0]
[{"$nulls":54},1,56,0,0,"0",0]
[{"$nulls":54},2,57,0,0,"0",0]
[{"$nulls":54},1,58,0,0,"0",0]
[{"$nulls":54},2,59,0,0,"0",0]
[{"$nulls":54},1,60,0,0,"0",0]
[{"$nulls":54},2,61,0,0,"0",0]
[{"$nulls":54},1,62,0,0,"0",0]
[{"$nulls":54},2,63,0,0,"0",0]
[{"$nulls":54},1,64,0,0,"0",0]
[{"$nulls":54},2,65,0,0,"0",0]
[{"$nulls":54},1,66,0,0,"0",0]
[null,true,null,false,false,{"$nulls":49},2,67,0,0,"0",0]
[{"$nulls":3},false,null,null,"non",{"$nulls":47},1,68,0,0,"0",0]
[null,"Symboles de "]
[null,"Schmalenbach"]
[{"$nulls":6},"zoom",100]
[]
[]
[]
[]
[]
[{"$nulls":3},"9000 Résultat",{"$nulls":11},"9000 Résultat"]
[null,1,null,{"$f":"IF(E108=0,\"\",VLOOKUP(B108,table,4,FALSE))","v":"4200"},{"$f":"VLOOKUP(B108,table,2,FALSE)","v":134.25},{"$f":"IF(G108=0,\"\",VLOOKUP(H108,table,4,FALSE))","v":"3200"},{"$f":"VLOOKUP(H108,table,2,FALSE)","v":555.55},2,{"$nulls":5},1,null,{"$f":"IF(Q108=0,\"\",VLOOKUP(N108,table,4,FALSE))","v":"4200"},{"$f":"VLOOKUP(N108,table,2,FALSE)","v":134.25},{"$f":"IF(S108=0,\"\",VLOOKUP(T108,table,4,FALSE))","v":"3200"},{"$f":"VLOOKUP(T108,table,2,FALSE)","v":555.55},2]
[null,3,null,{"$f":"IF(E109=0,\"\",VLOOKUP(B109,table,4,FALSE))","v":"4300"},{"$f":"VLOOKUP(B109,table,2,FALSE)","v":{"v":54.4,"d":"54.40"}},{"$f":"IF(G109=0,\"\",VLOOKUP(H109,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H109,table,2,FALSE)","v":{"v":0,"d":"0.00"}},4,{"$nulls":5},3,null,{"$f":"IF(Q109=0,\"\",VLOOKUP(N109,table,4,FALSE))","v":"4300"},{"$f":"VLOOKUP(N109,table,2,FALSE)","v":{"v":54.4,"d":"54.40"}},{"$f":"IF(S109=0,\"\",VLOOKUP(T109,table,4,FALSE))","v":""},{"$f":"VLOOKUP(T109,table,2,FALSE)","v":{"v":0,"d":"0.00"}},4]
[null,5,null,{"$f":"IF(E110=0,\"\",VLOOKUP(B110,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B110,table,2,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G110=0,\"\",VLOOKUP(H110,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H110,table,2,FALSE)","v":{"v":0,"d":"0.00"}},6,{"$nulls":5},5,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},6]
[null,7,null,{"$f":"IF(E111=0,\"\",VLOOKUP(B111,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B111,table,2,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G111=0,\"\",VLOOKUP(H111,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H111,table,2,FALSE)","v":{"v":0,"d":"0.00"}},8,{"$nulls":5},7,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},8]
[{"$nulls":3},{"$f":"IF(E112=0,\"\",\"BB\")","v":"BB"},{"$f":"IF(SUM(E108:E111)>SUM(G108:G111),0,SUM(G108:G111)-SUM(E108:E111))","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(G112=0,\"\",\"PB\")","v":""},{"$f":"IF(SUM(G108:G111)>SUM(E108:E111),0,SUM(E108:E111)-SUM(G108:G111))","v":{"v":0,"d":"0.00"}},{"$nulls":6},9,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},10]
[{"$nulls":4},{"$f":"SUM(E108:E112)","v":555.55},null,{"$f":"SUM(G108:G112)","v":555.55},{"$nulls":6},11,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},12]
[{"$nulls":3},{"$f":"F112","v":""},{"$f":"G112","v":{"v":0,"d":"0.00"}},{"$f":"D112","v":"BB"},{"$f":"E112","v":{"v":366.9,"d":"366.90"}},{"$nulls":6},13,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},14]
[null,15,null,{"$f":"IF(E115=0,\"\",VLOOKUP(B115,table,4,FALSE))","v":""},{"$f":"VLOOKUP(B115,table,2,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G115=0,\"\",VLOOKUP(H115,table,4,FALSE))","v":""},{"$f":"VLOOKUP(H115,table,2,FALSE)","v":{"v":0,"d":"0.00"}},16,{"$nulls":5},15,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},16]
[null,17,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},18,{"$nulls":5},17,null,{"$f":"IF(Q116=0,\"\",VLOOKUP(N116,table,4,FALSE))","v":""},{"$f":"VLOOKUP(N116,table,2,FALSE)","v":{"v":0,"d":"0.00"}},{"$f":"IF(S116=0,\"\",VLOOKUP(T116,table,4,FALSE))","v":""},{"$f":"VLOOKUP(T116,table,2,FALSE)","v":{"v":0,"d":"0.00"}},18]
[null,19,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},20,{"$nulls":5},19,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},20]
[null,21,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},22,{"$nulls":5},21,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},22]
[null,23,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},24,{"$nulls":5},23,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},24]
[null,25,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},26,{"$nulls":5},25,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},26]
[null,27,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},28,{"$nulls":5},27,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},28]
[null,29,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},30,{"$nulls":5},29,null,"",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},30]
[null,null,{"$f":"E123-G123","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(E123=0,\"\",\"BN\")","v":"BN"},{"$f":"IF(SUM(E114:E122)>SUM(G114:G122),0,SUM(G114:G122)-SUM(E114:E122))","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(G123=0,\"\",\"PN\")","v":""},{"$f":"IF(SUM(G114:G122)>SUM(E114:E122),0,SUM(E114:E122)-SUM(G114:G122))","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"Q123-S123","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(Q123=0,\"\",\"spb\")","v":"spb"},{"$f":"IF(SUM(Q108:Q122)>SUM(S108:S122),0,SUM(S108:S122)-SUM(Q108:Q122))","v":{"v":366.9,"d":"366.90"}},{"$f":"IF(S123=0,\"\",\"spb\")","v":""},{"$f":"IF(SUM(S108:S122)>SUM(Q108:Q122),0,SUM(Q108:Q122)-SUM(S108:S122))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"SUM(E114:E123)","v":{"v":366.9,"d":"366.90"}},null,{"$f":"SUM(G114:G123)","v":{"v":366.9,"d":"366.90"}},{"$nulls":9},{"$f":"SUM(Q108:Q123)","v":555.55},null,{"$f":"SUM(S108:S123)","v":555.55}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(B129=\"\",\"\",B129 & \" \" & VLOOKUP(B129,Plancompta,2))","v":""},{"$nulls":11},{"$f":"IF(N129=\"\",\"\",N129 & \" \" & VLOOKUP(N129,Plancompta,2))","v":""}]
{"$rows_empty":7}
[{"$nulls":14},{"$f":"Q137+S137","v":{"v":0,"d":"0.00"}},{"$f":"IF(Q137=0,\"\",O138)","v":""},{"$f":"IF(Q130+S130=0,0,IF(SUM(Q130:Q136)>SUM(S130:S136),0,SUM(S130:S136)-SUM(Q130:Q136)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(S137=0,\"\",O138)","v":""},{"$f":"IF(Q130+S130=0,0,IF(SUM(S130:S136)>SUM(Q130:Q136),0,SUM(Q130:Q136)-SUM(S130:S136)))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"$f":"IF(N137=\"\",\"spb\",IF(N137>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(Q130+S130=0,\"\",SUM(Q130:Q137))","v":""},null,{"$f":"IF(Q130+S130=0,\"\",SUM(S130:S137))","v":""}]
[{"$nulls":15},{"$f":"IF(N140=\"\",\"\",VLOOKUP(N140,Plancompta,3))","v":""},null,null,{"$f":"IF(N140=\"\",\"\",VLOOKUP(N140,Plancompta,4))","v":""}]
[{"$nulls":15},{"$f":"IF(N140=\"\",\"\",N140 & \" \" & VLOOKUP(N140,Plancompta,2))","v":""}]
{"$rows_empty":7}
[null,null,{"$f":"E148-G148","v":{"v":0,"d":"0.00"}},{"$f":"IF(E148=0,\"\",C149)","v":""},{"$f":"IF(E130+G130=0,0,IF(SUM(E130:E147)>SUM(G130:G147),0,SUM(G130:G147)-SUM(E130:E147)))","v":{"v":0,"d":"0.00"}},{"$f":"IF(G148=0,\"\",C149)","v":""},{"$f":"IF(E130+G130=0,0,IF(SUM(G130:G147)>SUM(E130:E147),0,SUM(E130:E147)-SUM(G130:G147)))","v":{"v":0,"d":"0.00"}},{"$nulls":7},{"$f":"Q148+S148","v":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}},{"$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":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF(B148=\"\",\"spb\",IF(B148>40,\"v/bi\",\"v/ex\"))","v":"spb"},null,{"$f":"IF(E130+G130=0,\"\",SUM(E130:E148))","v":""},null,{"$f":"IF(E130+G130=0,\"\",SUM(G130:G148))","v":""},{"$nulls":7},{"$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":""}]

{"sheet":"Libellés","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"merged":[[0,1,0,8],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,2,14,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],[21,2,21,9],[22,2,22,9],[23,2,23,9],[24,2,24,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[28,2,28,9],[29,2,29,9],[30,2,30,9],[31,2,31,9],[32,2,32,9],[33,2,33,9],[34,2,34,9],[35,2,35,9],[36,2,36,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,"Sàn",{"$nulls":7},"Ce libellé ne s'affiche pas"]
[null,1,"Déb. Fleur-de-Lys, facturé brut CHF 631.80, net 585.-"]
[null,2,"Four. Cellulose, brut CHF 149.60, net 138.50"]
[null,3,"Déb. Fleur-de-Lys, payé  CHF 600.- sur facture de  631.8-"]
[null,4,"Four. Cellulose, notre versement CHF 145.- sur fac. de CHF 149.60"]
[null,5,"MIGROL achat benzine - EC brut CHF 58.75, net 54.40"]
[null,6,"MEDIA MARKT, achat ordinateur, brut 1290.-, net 1194.45"]
[null,7]
[null,8]
[null,9]
[null,10]
[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 sont comptabilisées"]
[null,null,"Version TVA 8%",{"$nulls":7},"         boutons et macros à rajouter !"]
[]
[]
[null,null,{"$f":"COUNTA(C12:J33)","v":7}]

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

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