{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Journal Comptable","Fiche de Caisse"],"read":"whole","date_system":"1900"}

{"sheet":"Journal Comptable","index":0,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[0,0,0,6]]}
["Journal Comptable - Opérations Générales"]
["Date","Numéro de pièce","Compte Débit","Compte Crédit","Montant (CHF)","Description","Moyen de Paiement"]

{"sheet":"Fiche de Caisse","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,0,0,6]]}
["Fiche de Caisse - Suivi Journalier"]
["Date","Description","Entrée (CHF)","Sortie (CHF)","Moyen de Paiement","Responsable","Solde Cumulatif (CHF)"]
[{"$nulls":6},{"$f":"IF(AND(C3=\"\",D3=\"\"),\"\",C3-D3)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C4=\"\",D4=\"\"),\"\",G3+C4-D4)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C5=\"\",D5=\"\"),\"\",G4+C5-D5)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C6=\"\",D6=\"\"),\"\",G5+C6-D6)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C7=\"\",D7=\"\"),\"\",G6+C7-D7)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C8=\"\",D8=\"\"),\"\",G7+C8-D8)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C9=\"\",D9=\"\"),\"\",G8+C9-D9)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C10=\"\",D10=\"\"),\"\",G9+C10-D10)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C11=\"\",D11=\"\"),\"\",G10+C11-D11)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C12=\"\",D12=\"\"),\"\",G11+C12-D12)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C13=\"\",D13=\"\"),\"\",G12+C13-D13)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C14=\"\",D14=\"\"),\"\",G13+C14-D14)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C15=\"\",D15=\"\"),\"\",G14+C15-D15)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C16=\"\",D16=\"\"),\"\",G15+C16-D16)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C17=\"\",D17=\"\"),\"\",G16+C17-D17)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C18=\"\",D18=\"\"),\"\",G17+C18-D18)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C19=\"\",D19=\"\"),\"\",G18+C19-D19)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C20=\"\",D20=\"\"),\"\",G19+C20-D20)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C21=\"\",D21=\"\"),\"\",G20+C21-D21)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C22=\"\",D22=\"\"),\"\",G21+C22-D22)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C23=\"\",D23=\"\"),\"\",G22+C23-D23)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C24=\"\",D24=\"\"),\"\",G23+C24-D24)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C25=\"\",D25=\"\"),\"\",G24+C25-D25)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C26=\"\",D26=\"\"),\"\",G25+C26-D26)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C27=\"\",D27=\"\"),\"\",G26+C27-D27)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C28=\"\",D28=\"\"),\"\",G27+C28-D28)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C29=\"\",D29=\"\"),\"\",G28+C29-D29)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C30=\"\",D30=\"\"),\"\",G29+C30-D30)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C31=\"\",D31=\"\"),\"\",G30+C31-D31)","v":{"v":0,"d":"0.00 CHF"}}]
[{"$nulls":6},{"$f":"IF(AND(C32=\"\",D32=\"\"),\"\",G31+C32-D32)","v":{"v":0,"d":"0.00 CHF"}}]
[null,"TOTAL",{"$f":"SUM(C3:C32)","v":{"v":0,"d":"0.00 CHF"}},{"$f":"SUM(D3:D32)","v":{"v":0,"d":"0.00 CHF"}},null,null,{"$f":"IF(G32=\"\",\"\",G32)","v":{"v":0,"d":"0.00 CHF"}}]