{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Expences2024","Type de Frais"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Expences2024","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"SUBTOTAL(109,Tableau1[Amount])","v":21233}]
["Date","Amount","Reason","Currency","Method of payment",null,"Virements:",{"$f":"SUMIF(Tableau1[Method of payment],\"Bank Payment\",Tableau1[Amount])","v":7941},{"$f":"H2/$H$5","v":0.37399331229689636}]
["2024-01-01",256,"Electricité","CHF","Bank Payment",null,"Carte de crédit:",{"$f":"SUMIF(Tableau1[Method of payment],\"Credit Card\",Tableau1[Amount])","v":7379},{"$f":"H3/$H$5","v":0.34752507888663875}]
["2024-01-03",54,"Frais d'hotel","CHF","Credit Card",null,"Cash::",{"$f":"SUMIF(Tableau1[Method of payment],\"Cash\",Tableau1[Amount])","v":5913},0.27848160881646494]
["2024-01-04",621,"Primes d'assurance","CHF","Bank Payment",null,"Totals:",{"$f":"SUM(H2:H4)","v":21233}]
["2024-01-03",1376,"Voyage d'affaire","CHF","Bank Payment",null,"Type de Frais","Montant","P%"]
["2024-01-02",754,"Frais de téléphone","CHF","Cash",null,"Chauffage",{"$f":"SUMIF(Tableau1[Reason],G7,Tableau1[Amount])","v":0},{"$f":"H7/$H$27","v":0}]
["2024-01-12",1962,"Voyage d'affaire","CHF","Bank Payment",null,"Eau",{"$f":"SUMIF(Tableau1[Reason],G8,Tableau1[Amount])","v":0},{"$f":"H8/$H$27","v":0}]
["2024-01-09",276,"Location de voiture","CHF","Credit Card",null,"Electricité",{"$f":"SUMIF(Tableau1[Reason],G9,Tableau1[Amount])","v":256},1.2056704186878915E-2]
["2024-01-07",835,"Location de voiture","CHF","Credit Card",null,"Frais de restaurant",{"$f":"SUMIF(Tableau1[Reason],G10,Tableau1[Amount])","v":0},0]
["2024-01-10",125,"Frais de téléphone","CHF","Cash",null,"Frais de téléphone",{"$f":"SUMIF(Tableau1[Reason],G11,Tableau1[Amount])","v":879},4.1397824141666276E-2]
["2024-01-15",2261,"Voyage d'affaire","CHF","Bank Payment",null,"Frais d'entretien",{"$f":"SUMIF(Tableau1[Reason],G12,Tableau1[Amount])","v":728},3.4286252531436912E-2]
["2024-01-16",1287,"Location de voiture","CHF","Cash",null,"Frais d'hotel",{"$f":"SUMIF(Tableau1[Reason],G13,Tableau1[Amount])","v":1519},7.153958460886356E-2]
["2024-01-15",1852,"Voyage d'affaire","CHF","Credit Card",null,"Gaz",{"$f":"SUMIF(Tableau1[Reason],G14,Tableau1[Amount])","v":0},0]
["2024-01-19",1465,"Frais d'hotel","CHF","Bank Payment",null,"Honoraires d'avocats",{"$f":"SUMIF(Tableau1[Reason],G15,Tableau1[Amount])","v":0},0]
["2024-01-10",728,"Frais d'entretien","CHF","Cash",null,"Location de voiture",{"$f":"SUMIF(Tableau1[Reason],G16,Tableau1[Amount])","v":2398},0.11293740875052984]
["2024-01-22",2784,"Events","CHF","Cash",null,"Mobilier",{"$f":"SUMIF(Tableau1[Reason],G17,Tableau1[Amount])","v":0},0]
["2024-01-02",4362,"Events","CHF","Credit Card",null,"Papeterie",{"$f":"SUMIF(Tableau1[Reason],G18,Tableau1[Amount])","v":0},0]
["2024-02-09",235,"Taxi","CHF","Cash",null,"Part de loyer",{"$f":"SUMIF(Tableau1[Reason],G19,Tableau1[Amount])","v":0},0]
[null,null,null,null,null,null,"Primes d'assurance",{"$f":"SUMIF(Tableau1[Reason],G20,Tableau1[Amount])","v":621},2.9246926953327368E-2]
[null,null,null,null,null,null,"Rénovation",{"$f":"SUMIF(Tableau1[Reason],G21,Tableau1[Amount])","v":0},0]
[null,null,null,null,null,null,"Vêtements professionnels",{"$f":"SUMIF(Tableau1[Reason],G22,Tableau1[Amount])","v":0},0]
[null,null,null,null,null,null,"Voiture de fonction",{"$f":"SUMIF(Tableau1[Reason],G23,Tableau1[Amount])","v":0},0]
[null,null,null,null,null,null,"Voyage d'affaire",{"$f":"SUMIF(Tableau1[Reason],G24,Tableau1[Amount])","v":7451},0.35091602693919843]
[null,null,null,null,null,null,"Events",{"$f":"SUMIF(Tableau1[Reason],G25,Tableau1[Amount])","v":7146},0.33655159421654973]
[null,null,null,null,null,null,"Taxi",{"$f":"SUMIF(Tableau1[Reason],G26,Tableau1[Amount])","v":235},1.1067677671549004E-2]
[null,null,null,null,null,null,"Total:",{"$f":"SUM(Tableau3[Montant])","v":21233}]

{"sheet":"Type de Frais","index":1,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Frais"]
["Chauffage"]
["Eau"]
["Electricité"]
["Frais de restaurant"]
["Frais de téléphone"]
["Frais d'entretien"]
["Frais d'hotel"]
["Gaz"]
["Honoraires d'avocats"]
["Location de voiture"]
["Mobilier"]
["Papeterie"]
["Part de loyer"]
["Primes d'assurance"]
["Rénovation"]
["Vêtements professionnels"]
["Voiture de fonction"]
["Voyage d'affaire"]
["Events"]
["Taxi"]
["Others"]
["Pharmacie"]
["Hospitals"]
["Laboratorie"]
["Supplement"]