{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Registre de chèques"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Registre de chèques","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"Registre de chèques"]
[null,"LÉGENDE",{"$nulls":5},"SOLDE ACTUEL"]
[null,"CB = Carte bancaire",null,"PA = Paiement automatique ",{"$nulls":3},{"$f":"SOLDE_ACTUEL","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"DAB = Distributeur automatique de billets",null,"PL = Paiement en ligne"]
[null,"DA = Dépôt automatique ",null,"VR = Virement en ligne ou par téléphone"]
[null,"CHÈQUE/CODE","DATE","OPÉRATION","DESCRIPTION","RETRAIT","DÉPÔT","SOLDE"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-25"},"Banque du Vaucluse","Solde d’ouverture",null,{"v":2000,"d":"2,000.00 €"},{"$f":"IFERROR(RegistreChèques[[#This Row],[DÉPÔT]], \"\")","v":{"v":2000,"d":"2,000.00 €"}}]
[null,1001,{"$f":"TODAY()-11","v":"2018-06-02"},"École des Beaux-Arts","Cours de dessin de Pauline - 6 semaines",{"v":100,"d":"100.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(RegistreChèques[[#This Row],[RETRAIT]]),H7+RegistreChèques[[#This Row],[DÉPÔT]],H7-RegistreChèques[[#This Row],[RETRAIT]]), \"\")","v":{"v":1900,"d":"1,900.00 €"}}]
[null,"DA",{"$f":"TODAY()-11","v":"2018-06-02"},"Salaire",null,null,{"v":1500,"d":"1,500.00 €"},{"$f":"IFERROR(IF(ISBLANK(RegistreChèques[[#This Row],[RETRAIT]]),H8+RegistreChèques[[#This Row],[DÉPÔT]],H8-RegistreChèques[[#This Row],[RETRAIT]]), \"\")","v":{"v":3400,"d":"3,400.00 €"}}]
[null,"CB",{"$f":"TODAY()-8","v":"2018-06-05"},"Sud Vidéo","Location de vidéo + remise en espèces de 10 €",{"v":16,"d":"16.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(RegistreChèques[[#This Row],[RETRAIT]]),H9+RegistreChèques[[#This Row],[DÉPÔT]],H9-RegistreChèques[[#This Row],[RETRAIT]]), \"\")","v":{"v":3384,"d":"3,384.00 €"}}]
[null,"DAB",{"$f":"TODAY()-5","v":"2018-06-08"},null,"Retrait pour dîner au restaurant",{"v":50,"d":"50.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(RegistreChèques[[#This Row],[RETRAIT]]),H10+RegistreChèques[[#This Row],[DÉPÔT]],H10-RegistreChèques[[#This Row],[RETRAIT]]), \"\")","v":{"v":3334,"d":"3,334.00 €"}}]
[null,"PL",{"$f":"TODAY()","v":"2018-06-13"},"Opérateur téléphonique",null,{"v":23,"d":"23.00 €"},null,{"$f":"IFERROR(IF(ISBLANK(RegistreChèques[[#This Row],[RETRAIT]]),H11+RegistreChèques[[#This Row],[DÉPÔT]],H11-RegistreChèques[[#This Row],[RETRAIT]]), \"\")","v":{"v":3311,"d":"3,311.00 €"}}]
[null,"Totaux",null,{"$f":"CONCATENATE(\"Nombre de transactions : \",SUBTOTAL(103,RegistreChèques[OPÉRATION]))","v":"Nombre de transactions : 5"},null,{"$f":"SUBTOTAL(109,RegistreChèques[RETRAIT])","v":{"v":189,"d":"189.00 €"}},{"$f":"SUBTOTAL(109,RegistreChèques[DÉPÔT])","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"RegistreChèques[[#Totals],[DÉPÔT]]-RegistreChèques[[#Totals],[RETRAIT]]","v":{"v":3311,"d":"3,311.00 €"}}]