{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Données Journal","Synthèse Mensuelle"],"read":"whole","date_system":"1900"}

{"sheet":"Données Journal","index":0,"n_rows":6,"n_cols":6,"rows_kept":6}
["Date","Catégorie","Description","Recette (€)","Dépense (€)","Solde Cumulé (€)"]
["2025-06-01","Vente","Ticket repas",150,0,{"$f":"D2-E2","v":null}]
["2025-06-01","Achat","Fournitures",0,45,{"$f":"F2+D3-E3","v":null}]
["2025-06-02","Dépôt banque","Remise espèces",0,100,{"$f":"F3+D4-E4","v":null}]
["2025-06-03","Vente","Entrée événement",200,0,{"$f":"F4+D5-E5","v":null}]
["2025-06-04","Achat","Matériel",0,60,{"$f":"F5+D6-E6","v":null}]

{"sheet":"Synthèse Mensuelle","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[0,0,0,1]]}
["Synthèse Mensuelle de la Caisse"]
[]
["Total des Recettes (€)",{"$f":"SUM('Données Journal'!D2:D100)","v":null}]
["Total des Dépenses (€)",{"$f":"SUM('Données Journal'!E2:E100)","v":null}]
["Solde Final (€)",{"$f":"INDEX('Données Journal'!F:F, COUNTA('Données Journal'!A:A)+1)","v":null}]
["Nombre d'Opérations",{"$f":"COUNTA('Données Journal'!A2:A100)","v":null}]
["Recette Moyenne (€)",{"$f":"IF(COUNTA('Données Journal'!D2:D100)>0,SUM('Données Journal'!D2:D100)/COUNTA('Données Journal'!D2:D100),0)","v":null}]