{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Marcel"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"Marcel","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["date opération","Mode","Tiers","Libellé","Montant","Sens","Date valeur ","Solde perso","Pointage","Solde banque","Relevé","Calcul"]
["2021-12-05","Solde",null,null,0,null,"2021-12-05",null,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1500,"R"]
["2021-12-09","Carte","AA","Alimentation",4.32,"D","2021-12-11",{"$f":"+J2+E3*IF(F3=\"R\",1,-1)","v":1495.68},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J2+E3*IF(G3=\"\",0,IF(F3=\"R\",1,-1))","v":1495.68},"R",{"$f":"+IF(F3=\"D\",-E3,E3)","v":-4.32}]
["2021-12-11","Virement","AB","Santé",50,"D","2021-12-11",{"$f":"+H3+E4*IF(F4=\"R\",1,-1)","v":1445.68},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J3+E4*IF(G4=\"\",0,IF(F4=\"R\",1,-1))","v":1445.68},"R",-50]
["2021-12-11","Virement","AC","Carburant",50,"D","2021-12-11",{"$f":"+H4+E5*IF(F5=\"R\",1,-1)","v":1395.68},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J4+E5*IF(G5=\"\",0,IF(F5=\"R\",1,-1))","v":1395.68},"R",-50]
["2021-12-11","Carte","BA","Carburant",50,"D","2021-12-11",1345.68,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1345.68,"R",-50]
["2021-12-11","Carte","BC","Achat",50,"D","2021-12-14",1295.68,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1295.68,"R",-50]
["2021-12-13","Virement","BV","Alimentation",12.99,"D","2021-12-17",1282.69,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1282.69,"R",-12.99]
["2021-12-14","Prélèvt","CV","Santé",47.99,"D","2021-12-14",1234.7,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1234.7,"R1",-47.99]
["2021-12-14","Carte","CF","Carburant",32,"D","2021-12-16",1202.7,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1202.7,"R",-32]
["2021-12-14","Chèque","CG","Carburant",30,"D","2021-12-31",1172.7,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1172.7,"R1",-30]
["2021-12-15","Prélèvt","CV","Achat",181.45,"D","2021-12-16",991.25,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},991.25,"R",-181.45]
["2022-12-25",null,null,null,null,null,null,{"$f":"+H12+E13*IF(F13=\"R\",1,-1)","v":991.25},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},{"$f":"+J12+E13*IF(G13=\"\",0,IF(F13=\"R\",1,-1))","v":991.25},null,{"$f":"+IF(F14=\"D\",-E14,E14)","v":0}]