{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Janvier"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Janvier","index":0,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[16,5,17,7],[22,5,22,6],[18,5,18,7],[19,5,19,6],[20,5,20,6],[21,5,21,6],[30,0,30,1],[37,0,37,1],[0,0,0,3],[2,5,2,7],[4,0,4,1],[5,0,5,1],[10,5,10,7],[9,5,9,6]]}
["Janvier"]
["CHARGES","PREV","PRODUITS","PREV"]
[null,null,null,null,null,"Répartition des revenus"]
["Intitulé",null,null,null,null,{"$f":"C5","v":"Pierre"},{"$f":"SUM(D5)","v":1000},{"$f":"G4/$G$8","v":0.51948051948051943}]
["Charges essentielles",null,"Pierre",{"$f":"SUM(D6:D9)","v":1000},null,{"$f":"C10","v":"Paul"},{"$f":"D10","v":500},{"$f":"G5/$G$8","v":0.25974025974025972}]
["PRELEVEMENTS",null,"Paie :",1000,null,{"$f":"C15","v":"Jacques"},{"$f":"D15","v":250},0.12987012987012986]
["Loyer",630,"CAF :",null,null,{"$f":"C20","v":"Luc"},{"$f":"D20","v":175},9.0909090909090912E-2]
["EDF",152.26,"Prime :",null,null,null,{"$f":"SUM(G4:G7)","v":1925}]
["Eau",71,"Autres :",null,null,null,null,null,null,null,"Revenus","Participation","Pourcentage de participation"]
[null,null,"Paul",{"$f":"SUM(D11:D14)","v":500},null,"CHARGES :",null,{"$f":"B47","v":899.75},null,{"$f":"F4","v":"Pierre"},1000,{"$f":"H12","v":467.40259740259734},{"$f":"L10/K10","v":0.46740259740259732}]
[null,null,"Paie :",500,null,"Participation aux charges",null,null,null,"Paul",500,{"$f":"H13","v":233.70129870129867},{"$f":"L11/K11","v":0.46740259740259732}]
[null,null,"CAF :",null,null,null,{"$f":"F4","v":"Pierre"},{"$f":"H4*H10","v":467.40259740259734},null,{"$f":"F6","v":"Jacques"},250,{"$f":"H14","v":116.85064935064933},{"$f":"L12/K12","v":0.46740259740259732}]
[null,null,"Prime :",null,null,null,{"$f":"F5","v":"Paul"},{"$f":"H5*H10","v":233.70129870129867},null,{"$f":"F7","v":"Luc"},{"$f":"G7","v":175},{"$f":"H15","v":81.795454545454547},{"$f":"L13/K13","v":0.46740259740259743}]
[null,null,"Autres :",null,null,null,{"$f":"F6","v":"Jacques"},{"$f":"H6*$H$10","v":116.85064935064933}]
[null,null,"Jacques",{"$f":"SUM(D16:D19)","v":250},null,null,{"$f":"F7","v":"Luc"},{"$f":"H7*$H$10","v":81.795454545454547}]
[null,null,"Paie :",250,null,null,null,{"$f":"SUM(H12:H15)","v":899.74999999999977}]
[null,null,"CAF :",null,null,"A déposer sur le compte commun"]
[null,null,"Prime :"]
[null,null,"Autres :",null,null,"Reste"]
[null,null,"Luc",{"$f":"SUM(D21:D24)","v":175},null,{"$f":"G12","v":"Pierre"},null,{"$f":"G4-H12","v":532.59740259740261}]
[null,null,"Paie :",175,null,{"$f":"G13","v":"Paul"},null,{"$f":"G5-H13","v":266.2987012987013}]
[null,null,"CAF :",null,null,{"$f":"G14","v":"Jacques"},null,{"$f":"G6-H14","v":133.14935064935065}]
[null,null,"Prime :",null,null,{"$f":"G15","v":"Luc"},null,{"$f":"G7-H15","v":93.204545454545453}]
[null,null,"Autres :",null,null,null,null,{"$f":"SUM(H20:H23)","v":1025.25}]
[]
[]
[]
[]
[]
[]
["NON PRELEVE"]
[]
[]
[]
["Courses",{"$f":"B51","v":0}]
["SOUS-TOTAL",{"$f":"SUM(B7:B35)","v":853.26},"TOTAL",{"$f":"SUM(D5+D10)","v":1500}]
[null,null,"SOUS-RESULTAT",{"$f":"SUM(D36-B36)","v":646.74}]
["Charges non essentielles"]
["Fer à repasser",44.99]
["Voyage",1.5]
["Autres",{"$f":"D51","v":0}]
[]
[]
[]
[]
["SOUS-TOTAL",{"$f":"SUM(B39:B45)","v":46.49}]
["TOTAL CHARGES",{"$f":"SUM(B36,B46)","v":899.75},"TOTAL PRODUITS",{"$f":"D36","v":1500}]
[null,null,"RESULTAT",{"$f":"D47-B47","v":600.25}]
[]
[]
["Courses",{"$f":"SUM(B52:B61)","v":0},{"$f":"A41","v":"Autres"},{"$f":"SUM(D52:D61)","v":0}]