{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Moi","Autre","Feuil1"],"not_rendered":{"charts":0,"images":6,"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":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,4,0,5],[1,4,1,5],[0,1,0,2]]}
[null,"Dernier Relevé Bancaire",null,{"$f":"SUMIFS(L:L,K:K,\"=R*\")+J4","v":2926.01},{"$f":"\"Solde banque au  \"&TEXT(TODAY(),\"jj/mm/aa\")","v":"Solde banque au  25/04/23"},null,{"$f":"LOOKUP(9^9,J:J)","v":0},null,null,null,null,"Dépenses","D"]
[null,null,"Solde prévisionnel     fin de mois",{"$f":"LOOKUP(9^9,H:H)","v":670.5},{"$f":"\"Solde réel au \"&TEXT(TODAY(),\"jj/mm/aaaa\")","v":"Solde réel au 25/04/2023"},null,{"$f":"INDEX(H:H,MATCH(TODAY(),A:A,1),)","v":965.45999999999992},null,null,{"$f":"IF(H1=\"\",\"\",D1-H1)","v":""},null,"Recettes","R"]
["date opération","Mode","Tiers","Libellé","Montant","Sens","Date valeur ","Solde perso","Pointage","Solde banque","Relevé","Calcul","Vacances"]
["2022-12-22",null,null,"Solde",2000,null,null,{"$f":"+DécompteM[[#This Row],[Montant]]","v":2000},"P",4449.5600000000004,"R"]
["2022-12-23","Carte","AA",null,40,{"$f":"IF(E5=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2022-12-26",{"$f":"IF($F5=\"D\",H4-$E5,IF($F5=\"R\",H4+$E5,\"\"))","v":1960},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},{"$f":"+J4+E5*IF(G5=\"\",0,IF(F5=\"R\",1,-1))","v":4409.5600000000004},"R1",{"$f":"+IF(F5=\"D\",-E5,E5)","v":-40}]
["2023-04-10","Prélt","BB",null,10,{"$f":"IF(E6=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-11",1950,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},4399.5600000000004,"R4",{"$f":"+IF(F6=\"D\",-E6,E6)","v":-10}]
["2023-04-10","Prélt","FF",null,185,{"$f":"IF(E7=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-11",1765,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},4214.5600000000004,"R4",-185]
["2023-04-10","Virt-Emis","GG",null,50,{"$f":"IF(E8=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-10",1715,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},4164.5600000000004,"R4",-50]
["2023-04-10","Virt-Emis","HH",null,50,{"$f":"IF(E9=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-10",1665,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},4114.5600000000004,"R4",-50]
["2023-04-11","Chèque","JJ",null,760,{"$f":"IF(E10=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-13",905,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},3354.5600000000004,"R4",-760]
["2023-04-15","Prélt","JJ",null,194.35,{"$f":"IF(E11=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-17",710.65,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},3160.2100000000005,"R4",-194.35]
["2023-04-15","Prélt","KK",null,108,{"$f":"IF(E12=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-19",602.65,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},3052.2100000000005,"R4",-108]
["2023-04-15","Retrait","LL",null,40,{"$f":"IF(E13=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-14",562.65,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},3012.2100000000005,"R4",-40]
["2023-04-15","Carte","MM",null,41.2,{"$f":"IF(E14=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-18",521.44999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},2971.0100000000007,"R4",-41.2]
["2023-04-16","Prélt","ZZ",null,25,{"$f":"IF(E15=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-18",496.44999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},2946.0100000000007,"R4",-25]
["2023-04-19","Carte","SS",null,20,{"$f":"IF(E16=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-21",476.44999999999993,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},2926.0100000000007,"R4",-20]
["2023-04-24","Internet","SS",null,10.99,{"$f":"IF(E17=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-25",465.45999999999992,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":"P"},2915.0200000000009,null,-10.99]
["2023-04-25","Virt-reçu","SS",null,500,{"$f":"IF(E18=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"R"},null,965.45999999999992,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},2915.0200000000009,null,500]
["2023-04-28","Prélt","SS",null,294.95999999999998,{"$f":"IF(E19=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,670.5,{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},2915.0200000000009,null,-294.95999999999998]
["2023-04-29",null,null,null,null,{"$f":"IF(E20=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":""},null,{"$f":"IF(Moi!$F20=\"D\",H19-Moi!$E20,IF(Moi!$F20=\"R\",H19+Moi!$E20,\"\"))","v":""},{"$f":"+IF(DécompteM[[#This Row],[Date valeur ]]=\"\",\"\",\"P\")","v":""},{"$f":"+DécompteM[[#This Row],[Montant]]","v":0},null,{"$f":"+IF(F20=\"D\",-E20,E20)","v":0}]

{"sheet":"Autre","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5],[1,4,1,5]]}
[null,"Dernier relevé Bancaire",null,{"$f":"SUMIFS(L:L,K:K,\"=R*\")+J4","v":567.01},{"$f":"\"Solde banque au  \"&TEXT(TODAY(),\"jj/mm/aa\")","v":"Solde banque au  25/04/23"},null,{"$f":"LOOKUP(9^9,J:J)","v":891.05}]
[null,null,"Fin de mois",{"$f":"LOOKUP(9^9,H:H)","v":715.82999999999993},{"$f":"\"Solde réel au \"&TEXT(TODAY(),\"jj/mm/aaaa\")","v":"Solde réel au 25/04/2023"},null,{"$f":"INDEX(H:H,MATCH(TODAY(),A:A,1),)","v":715.82999999999993}]
["date opération","Mode","Tiers","Libellé","Montant","Sens","Date valeur ","Solde perso","Pointage","Solde banque","Relevé","Calcul","Vacances"]
["2023-01-01","Carte","Solde",null,567.01,null,null,{"$f":"Autre!$E4","v":567.01},"p",567.01]
["2023-01-05","Chèque","aze",null,38,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-01-02",{"$f":"IF($F5=\"D\",H4-$E5,IF($F5=\"R\",H4+$E5,\"\"))","v":529.01},{"$f":"IF(Autre!$G5=\"\",\"\",\"P\")","v":"P"},{"$f":"+J4+E5*IF(G5=\"\",0,IF(F5=\"R\",1,-1))","v":529.01},null,{"$f":"+IF(F5=\"D\",-E5,E5)","v":-38}]
["2023-02-10","Virt-Reçu","qsd",null,400,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"R"},"2023-03-22",929.01,{"$f":"IF(Autre!$G6=\"\",\"\",\"P\")","v":"P"},929.01,null,{"$f":"+IF(F6=\"D\",-E6,E6)","v":400}]
["2023-04-15","Carte","sdrt",null,11.11,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-20",917.9,{"$f":"IF(Autre!$G7=\"\",\"\",\"P\")","v":"P"},917.9,null,{"$f":"+IF(F7=\"D\",-E7,E7)","v":-11.11}]
["2023-04-19","Carte","fre",null,21.92,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,895.98,{"$f":"IF(Autre!$G8=\"\",\"\",\"P\")","v":""},917.9,null,{"$f":"+IF(F8=\"D\",-E8,E8)","v":-21.92}]
["2023-04-19","Carte","fgh",null,26.85,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},"2023-04-25",869.13,{"$f":"IF(Autre!$G9=\"\",\"\",\"P\")","v":"P"},891.05,null,-26.85]
["2023-04-24","Carte","nhy",null,6.99,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,862.14,{"$f":"IF(Autre!$G10=\"\",\"\",\"P\")","v":""},891.05,null,-6.99]
["2023-04-24","Carte","kiui",null,13.45,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,848.68999999999994,{"$f":"IF(Autre!$G11=\"\",\"\",\"P\")","v":""},891.05,null,-13.45]
["2023-04-24","Carte","mlk",null,107.86,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,740.82999999999993,{"$f":"IF(Autre!$G12=\"\",\"\",\"P\")","v":""},891.05,null,-107.86]
["2023-04-24","Chèque","jjjj",null,25,{"$f":"IF(DécompteG[[#This Row],[Montant]]=\"\",\"\",VLOOKUP(B:B,Sens,2))","v":"D"},null,715.82999999999993,{"$f":"IF(Autre!$G13=\"\",\"\",\"P\")","v":""},891.05,null,-25]

{"sheet":"Feuil1","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Carte","D"]
["Chèque","D"]
["Internet","D"]
["Paypal","D"]
["Prélt","D"]
["Remise chèque","R"]
["Retrait","D"]
["Virt-Emis","D"]
["Virt-Reçu","R"]