{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Moi"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Moi","index":0,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5]]}
[null,"Dernier relevé Bancaire",null,{"$f":"SUMIFS(L:L,K:K,\"=R*\")+J3","v":1000},{"$f":"\"Rapprochement bancaire au  \"&TEXT(TODAY(),\"jj/mm/aa\")","v":"Rapprochement bancaire au  04/01/24"},null,{"$f":"LOOKUP(9^9,J:J)","v":929.68000000000006}]
["date opération","Mode","Tiers","Libellé","Montant","Sens","Date valeur ","Solde","Pointage","Rapprochement","Relevé","Calcul","Vacances"]
["2023-01-01","Carte","Solde",null,1000,null,null,{"$f":"Moi!$E3","v":1000},"P",{"$f":"+DécompteG[[#This Row],[Montant]]","v":1000},null,null,null,null,"Carte","D"]
["2023-12-23","Carte","Epicerie",null,95.32,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-12-29",{"$f":"IF($F4=\"D\",H3-$E4,IF($F4=\"R\",H3+$E4,\"\"))","v":904.68000000000006},{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"J3+E4*IF(G4=\"\",0,IF(F4=\"R\",1,-1))","v":904.68000000000006},null,{"$f":"+IF(F4=\"D\",-E4,E4)","v":-95.32},null,null,"Prélt","D"]
["2023-12-23","Retrait",null,null,80,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2024-01-01",824.68000000000006,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J4+E5*IF(G5=\"\",0,IF(F5=\"R\",1,-1))","v":824.68000000000006},null,-80,null,null,"Retrait","D"]
["2023-12-23","Virt-Emis","Amazon",null,33.08,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,791.6,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},824.68000000000006,null,-33.08,null,null,"Virt-Emis","D"]
["2023-12-25","Virt-Reçu","Remboursement",null,105,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"R"},"2024-01-02",896.6,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},929.68000000000006,null,105,null,null,"Virt-Reçu","R"]
["2024-01-02","Carte","Intermarché",null,45.84,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,850.76,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},929.68000000000006,null,-45.84]
["2024-01-02","Carte","Marché",null,12.58,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,838.18,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},929.68000000000006,null,-12.58]
["2024-01-03","Carte","Resto",null,85,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,753.18,{"$f":"IF(DécompteG[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},929.68000000000006,null,-85]
["2024-01-04","Carte",null,null,23.25,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,729.93,{"$f":"IF(Moi!$G11=\"\",\"\",\"P\")","v":""},{"$f":"+J10+E11*IF(G11=\"\",0,IF(F11=\"R\",1,-1))","v":929.68000000000006},null,{"$f":"+IF(F11=\"D\",-E11,E11)","v":-23.25}]
[]
[null,null,null,null,null,null,null,null,"Voir formule I10 et I11"]