{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Marcel"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Solde réel",{"$f":"LOOKUP(9^9,H:H)","v":506.85},null,{"$f":"LOOKUP(9^9,J:J)","v":761.29},"Solde banque","Ecart banque et réél",{"$f":"+C1-E1","v":-254.43999999999994}]
[]
["date opération","Mode","Tiers","Libellé","Montant","Sens","Date valeur ","Solde perso","Pointage","Solde banque"]
["2021-12-05","carte",null,null,0,null,"2021-12-05",null,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},1000,null,null,"carte"]
["2021-12-09","carte",null,null,4.32,"D","2021-12-11",{"$f":"+J4+E5*IF(F5=\"R\",1,-1)","v":995.68},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J4+E5*IF(G5=\"\",0,IF(F5=\"R\",1,-1))","v":995.68},null,null,"chèque"]
["2021-12-11","Prélèvement",null,null,50,"D","2021-12-11",{"$f":"+H5+E6*IF(F6=\"R\",1,-1)","v":945.68},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},945.68,null,null,"Prélèvement"]
["2021-12-11","Prélèvement",null,null,50,"D","2021-12-11",895.68,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},895.68,null,null,"Retrait"]
["2021-12-11","Virt-émis",null,null,50,"D","2021-12-11",845.68,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},845.68,null,null,"Virt-émis"]
["2021-12-11","virt-reçu",null,null,50,"R","2021-12-14",895.68,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},895.68,null,null,"virt-reçu"]
["2021-12-13","chèque",null,null,12.99,"D","2021-12-17",882.68999999999994,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},882.68999999999994]
["2021-12-14","carte",null,null,47.99,"D",null,834.69999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},882.68999999999994]
["2021-12-14","carte",null,null,32,"D","2021-12-16",802.69999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},850.68999999999994]
["2021-12-14","Retrait",null,null,30,"D","2021-12-31",772.69999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},820.68999999999994]
["2021-12-15","carte",null,null,181.45,"D",null,591.25,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},820.68999999999994]
["2021-12-15","chèque",null,null,52.3,"D","2021-12-15",{"$f":"+H14+E15*IF(F15=\"R\",1,-1)","v":538.95000000000005},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J14+E15*IF(G15=\"\",0,IF(F15=\"R\",1,-1))","v":768.39}]
["2021-12-17","carte",null,null,50,"R","2021-12-18",588.95000000000005,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},818.39]
["2021-12-17","Prélèvement",null,null,57.1,"D","2021-12-21",531.85,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},761.29]
["2022-03-02","chèque",null,null,25,"D",null,{"$f":"+H17+E18*IF(F18=\"R\",1,-1)","v":506.85},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},{"$f":"+J17+E18*IF(G18=\"\",0,IF(F18=\"R\",1,-1))","v":761.29}]