{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dashboard","Feuil1","Budget","Réel","Transactions","Transfert","Contrôle","Traitement"],"not_rendered":{"charts":11,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":2,"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":"Dashboard","index":0,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[7,1,8,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Août"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Revenus","Réel","Budget",null,"Charges","Réel","Budget",null,"Autres charges & Loisirs","Réel","Budget",null,"Crédits","Réel","Budget",null,"Investissements","Réel","Budget",null,"Epargnes","Réel","Budget"]
[null,{"$f":"Budget!B7","v":"Salaire"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B32)*(Transactions[Montant]))","v":673885},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B32,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":650000},null,{"$f":"Budget!B15","v":"Loyer"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F32)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F32,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":65000},null,{"$f":"Budget!B28","v":"Assistances familles"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J32)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J32,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":30000},null,{"$f":"Budget!B43","v":"emprunt bancaire"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N32)*(Transactions[Montant]))","v":92072},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N32,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":92000},null,{"$f":"Budget!B51","v":"Formations"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R32)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R32,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B59","v":"Compte bloqué"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V32)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V32,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":77000}]
[null,{"$f":"Budget!B8","v":"Revenus complémentaires"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B33)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B33,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":0},null,{"$f":"Budget!B16","v":"CIE"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F33)*(Transactions[Montant]))","v":5000},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F33,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":5000},null,{"$f":"Budget!B29","v":"Entretien logement"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J33)*(Transactions[Montant]))","v":51000},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J33,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":50000},null,{"$f":"Budget!B44","v":"Remboursement hors banque"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N33)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N33,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B52","v":"Projets"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R33)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R33,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B60","v":"Fond d'urgence"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V33)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V33,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0}]
[null,{"$f":"Budget!B9","v":"Autres revenus"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B34)*(Transactions[Montant]))","v":3000},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B34,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":30000},null,{"$f":"Budget!B17","v":"SODECI"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F34)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F34,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B30","v":"Divers"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J34)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J34,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":5000},null,{"$f":"Budget!B45","v":"Autres crédits"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N34)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N34,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B53","v":"Autres projets"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R34)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R34,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":50000},null,{"$f":"Budget!B61","v":"Autres epargnes"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V34)*(Transactions[Montant]))","v":50000},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V34,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":50000}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B35,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B18","v":"Gaz"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F35,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,{"$f":"Budget!B31","v":"Pressing"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J35,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N35,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R35,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V35)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V35,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B36)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B36,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B19","v":"Nourriture"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F36)*(Transactions[Montant]))","v":21000},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F36,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":50000},null,{"$f":"Budget!B32","v":"Shopping"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J36)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J36,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":20000},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N36)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N36,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R36)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R36,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V36)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V36,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B37)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B37,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B20","v":"Transport"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F37)*(Transactions[Montant]))","v":23500},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F37,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":55000},null,{"$f":"Budget!B33","v":"Restaurant/Loisirs"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J37)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J37,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":36000},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N37)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N37,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R37)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R37,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V37)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V37,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B38)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B38,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B21","v":"Agios bancaire"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F38)*(Transactions[Montant]))","v":12000},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F38,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":12000},null,{"$f":"Budget!B34","v":"Dons & libéralités diverses"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J38)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J38,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":0},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N38)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N38,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R38)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R38,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V38)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V38,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B39,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B22","v":"Frais de télécommunication & internet"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F39,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":15000},null,{"$f":"Budget!B35","v":"Cotisations"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J39,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":10000},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N39,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R39,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V39)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V39,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B40)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B40,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B23","v":"Dîme & Aumônes"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F40)*(Transactions[Montant]))","v":5500},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F40,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":5000},null,{"$f":"Budget!B36","v":"Abonnements multimédia"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J40)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J40,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":8000},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N40)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N40,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R40)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R40,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V40)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V40,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=B41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(IFERROR(INDEX(Revenus_budget[[Janvier]:[Décembre]],MATCH(B41,Revenus,0),MATCH($B$8,Revenus_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\"),0)","v":""},null,{"$f":"Budget!B24","v":"Imprévus"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=F41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Dépenses_budget[[Janvier]:[Décembre]],MATCH(F41,Charges,0),MATCH($B$8,Dépenses_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":5000},null,{"$f":"Budget!B37","v":"Autres charges"},{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=J41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Autres_charges_budget[[Janvier]:[Décembre]],MATCH(J41,Autres_charges,0),MATCH($B$8,Autres_charges_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":12000},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=N41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Crédits_budget[[Janvier]:[Décembre]],MATCH(N41,Crédits,0),MATCH($B$8,Crédits_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=R41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Investissements_budget[[Janvier]:[Décembre]],MATCH(R41,Investissements,0),MATCH($B$8,Investissements_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""},null,null,{"$f":"SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&$B$8&\"2000\")))*(Transactions[Catégorie]=V41)*(Transactions[Montant]))","v":0},{"$f":"IFERROR(INDEX(Epargnes_budget[[Janvier]:[Décembre]],MATCH(V41,Epargnes,0),MATCH($B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)),\"\")","v":""}]
[null,"Total",{"$f":"SUM(C32:C41)","v":676885},{"$f":"SUM(D32:D41)","v":680000},null,"Total",{"$f":"SUM(G32:G41)","v":67000},{"$f":"SUM(H32:H41)","v":212000},null,"Total",{"$f":"SUM(K32:K41)","v":51000},{"$f":"SUM(L32:L41)","v":171000},null,"Total",{"$f":"SUM(O32:O41)","v":92072},{"$f":"SUM(P32:P41)","v":92000},null,"Total",{"$f":"SUM(S32:S41)","v":0},{"$f":"SUM(T32:T41)","v":50000},null,"Total",{"$f":"SUM(W32:W41)","v":50000},{"$f":"SUM(X32:X41)","v":127000}]

{"sheet":"Feuil1","index":1,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Car 1","Car 2","Ecart"]
[null,null,{"$f":"20000+2000*20","v":60000},{"$f":"20000+1500*20","v":50000},{"$f":"C4-D4","v":10000}]

{"sheet":"Budget","index":2,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,{"$f":"C10-C25-C38-C46-C54-C62","v":0},0,0,0,0,0,0,28000,3000,18000,18000,180500,247500]
[null,"Revenus","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Salaire",null,null,null,null,null,null,null,650000,650000,650000,650000,650000,{"$f":"SUM(Revenus_budget[[#This Row],[Janvier]:[Décembre]])","v":3250000}]
[null,"Revenus complémentaires",null,null,null,null,null,null,null,null,null,null,null,487500,{"$f":"SUM(Revenus_budget[[#This Row],[Janvier]:[Décembre]])","v":487500}]
[null,"Autres revenus",null,null,null,null,null,null,null,30000,null,null,null,null,{"$f":"SUM(Revenus_budget[[#This Row],[Janvier]:[Décembre]])","v":30000}]
[null,"Total",{"$f":"SUBTOTAL(109,C7:C9)","v":0},{"$f":"SUBTOTAL(109,D7:D9)","v":0},0,0,0,0,0,680000,650000,650000,650000,1137500,{"$f":"SUM(Revenus_budget[[#This Row],[Janvier]:[Décembre]])","v":3767500}]
[]
[]
[]
[null,"Charges","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Loyer",null,null,null,null,null,null,null,65000,65000,65000,65000,65000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":325000}]
[null,"CIE",null,null,null,null,null,null,null,5000,10000,10000,10000,10000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":45000}]
[null,"SODECI",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Gaz",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Nourriture",null,null,null,null,null,null,null,50000,50000,50000,50000,50000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":250000}]
[null,"Transport",null,null,null,null,null,null,null,55000,55000,55000,55000,55000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":275000}]
[null,"Agios bancaire",null,null,null,null,null,null,null,12000,12000,12000,12000,12000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":60000}]
[null,"Frais de télécommunication & internet",null,null,null,null,null,null,null,15000,15000,15000,15000,15000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":75000}]
[null,"Dîme & Aumônes",null,null,null,null,null,null,null,5000,5000,10000,10000,10000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":40000}]
[null,"Imprévus",null,null,null,null,null,null,null,5000,5000,5000,5000,5000,{"$f":"SUM(Dépenses_budget[[#This Row],[Janvier]:[Décembre]])","v":25000}]
[null,"Total",{"$f":"SUBTOTAL(109,C15:C24)","v":0},{"$f":"SUBTOTAL(109,D15:D24)","v":0},0,0,0,0,{"$f":"SUBTOTAL(109,I15:I24)","v":0},212000,217000,222000,222000,222000,1095000]
[]
[null,"Autres charges & Loisirs","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Assistances familles",null,null,null,null,null,null,null,30000,30000,30000,30000,250000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":370000}]
[null,"Entretien logement",null,null,null,null,null,null,null,50000,3000,3000,3000,3000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":62000}]
[null,"Divers",null,null,null,null,null,null,null,5000,5000,5000,5000,5000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":25000}]
[null,"Pressing",null,null,null,null,null,null,null,null,5000,5000,5000,5000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":20000}]
[null,"Shopping",null,null,null,null,null,null,null,20000,30000,20000,20000,20000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":110000}]
[null,"Restaurant/Loisirs",null,null,null,null,null,null,null,36000,20000,20000,20000,20000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":116000}]
[null,"Dons & libéralités diverses",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Cotisations",null,null,null,null,null,null,null,10000,10000,null,null,null,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":20000}]
[null,"Abonnements multimédia",null,null,null,null,null,null,null,8000,8000,8000,8000,8000,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":40000}]
[null,"Autres charges",null,null,null,null,null,null,null,12000,null,null,null,null,{"$f":"SUM(Autres_charges_budget[[#This Row],[Janvier]:[Décembre]])","v":12000}]
[null,"Total",{"$f":"SUBTOTAL(109,C28:C37)","v":0},{"$f":"SUBTOTAL(109,D28:D37)","v":0},0,0,{"$f":"SUBTOTAL(109,G28:G37)","v":0},0,{"$f":"SUBTOTAL(109,I28:I37)","v":0},{"$f":"SUBTOTAL(109,J28:J37)","v":171000},{"$f":"SUBTOTAL(109,K28:K37)","v":111000},{"$f":"SUBTOTAL(109,L28:L37)","v":91000},{"$f":"SUBTOTAL(109,M28:M37)","v":91000},{"$f":"SUBTOTAL(109,N28:N37)","v":311000},{"$f":"SUBTOTAL(109,O28:O37)","v":775000}]
[]
[]
[]
[null,"Crédits","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"emprunt bancaire",null,null,null,null,null,null,null,92000,92000,92000,92000,92000,{"$f":"SUM(Crédits_budget[[#This Row],[Janvier]:[Décembre]])","v":460000}]
[null,"Remboursement hors banque",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Crédits_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres crédits",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Crédits_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,C43:C45)","v":0},{"$f":"SUBTOTAL(109,D43:D45)","v":0},0,0,0,0,0,92000,92000,92000,92000,92000,{"$f":"SUBTOTAL(109,O43:O45)","v":460000}]
[]
[]
[]
[null,"Investissements","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Formations",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Investissements_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Projets",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Investissements_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres projets",null,null,null,null,null,null,null,50000,null,null,null,null,{"$f":"SUM(Investissements_budget[[#This Row],[Janvier]:[Décembre]])","v":50000}]
[null,"Total",{"$f":"SUBTOTAL(109,C51:C53)","v":0},{"$f":"SUBTOTAL(109,D51:D53)","v":0},0,0,0,0,0,50000,0,0,0,0,{"$f":"SUBTOTAL(109,O51:O53)","v":50000}]
[]
[]
[]
[null,"Epargnes","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Compte bloqué",null,null,null,null,null,null,null,77000,77000,77000,77000,77000,{"$f":"SUM(Epargnes_budget[[#This Row],[Janvier]:[Décembre]])","v":385000}]
[null,"Fond d'urgence",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Epargnes_budget[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres epargnes",null,null,null,null,null,null,null,50000,150000,150000,150000,255000,{"$f":"SUM(Epargnes_budget[[#This Row],[Janvier]:[Décembre]])","v":755000}]
[null,"Total",{"$f":"SUBTOTAL(109,C59:C61)","v":0},{"$f":"SUBTOTAL(109,D59:D61)","v":0},0,0,0,0,0,127000,227000,227000,227000,332000,1140000]

{"sheet":"Réel","index":3,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,{"$f":"C10-C26-C41-C49-C57-C65","v":0},{"$f":"D10-D26-D41-D49-D57-D65","v":0},0,0,0,0,0,416813,0,0,0,0,416813]
[null,"Revenus","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Salaire",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":673885},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Revenus_budget10[[#This Row],[Janvier]:[Décembre]])","v":673885}]
[null,"Revenus complémentaires",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Revenus_budget10[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres revenus",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":3000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Revenus_budget10[[#This Row],[Revenus]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Revenus_budget10[[#This Row],[Janvier]:[Décembre]])","v":3000}]
[null,"Total",{"$f":"SUBTOTAL(109,C7:C9)","v":0},{"$f":"SUBTOTAL(109,D7:D9)","v":0},0,0,0,0,0,676885,0,0,0,0,{"$f":"SUM(Revenus_budget10[[#This Row],[Janvier]:[Décembre]])","v":676885}]
[]
[]
[]
[]
[null,"Charges","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Loyer",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"CIE",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":5000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":5000}]
[null,"SODECI",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Gaz",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Nourriture",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":21000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":21000}]
[null,"Transport",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":23500},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":23500}]
[null,"Agios bancaire",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":12000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":12000}]
[null,"Frais de télécommunication & internet",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Dîme & Aumônes",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":5500},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":5500}]
[null,"Imprévus",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Dépenses_budget11[[#This Row],[Charges]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$6&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Dépenses_budget11[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses_budget11[Janvier])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Février])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Mars])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Avril])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Mai])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Juin])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Juillet])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Août])","v":67000},{"$f":"SUBTOTAL(109,Dépenses_budget11[Septembre])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Octobre])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Novembre])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Décembre])","v":0},{"$f":"SUBTOTAL(109,Dépenses_budget11[Total])","v":67000}]
[]
[]
[]
[null,"Autres charges & Loisirs","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Assistances familles",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Entretien logement",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":51000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":51000}]
[null,"Divers",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Pressing",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Shopping",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Restaurant/Loisirs",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Dons & libéralités diverses",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Cotisations",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Abonnements multimédia",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres charges",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Autres_charges_budget12[[#This Row],[Autres charges & Loisirs]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$30&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Autres_charges_budget12[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,C31:C40)","v":0},{"$f":"SUBTOTAL(109,D31:D40)","v":0},0,0,0,0,0,51000,0,0,0,0,{"$f":"SUBTOTAL(109,O31:O40)","v":51000}]
[]
[]
[]
[null,"Crédits","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"emprunt bancaire",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$45&\"2000\")))*(Transactions[Montant]))","v":92072},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Crédits_budget15[[#This Row],[Janvier]:[Décembre]])","v":92072}]
[null,"Remboursement hors banque",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Crédits_budget15[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres crédits",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Crédits_budget15[[#This Row],[Crédits]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$45&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Crédits_budget15[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,C46:C48)","v":0},{"$f":"SUBTOTAL(109,D46:D48)","v":0},0,0,0,0,0,92072,0,0,0,0,{"$f":"SUBTOTAL(109,O46:O48)","v":92072}]
[]
[]
[]
[null,"Investissements","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Formations",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Investissements_budget13[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Projets",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Investissements_budget13[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres projets",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Investissements_budget13[[#This Row],[Investissements]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$53&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Investissements_budget13[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,C54:C56)","v":0},{"$f":"SUBTOTAL(109,D54:D56)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,O54:O56)","v":0}]
[]
[]
[]
[null,"Epargnes","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre","Total"]
[null,"Compte bloqué",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Epargnes_budget14[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Fond d'urgence",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Epargnes_budget14[[#This Row],[Janvier]:[Décembre]])","v":0}]
[null,"Autres epargnes",{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$61&\"2000\")))*(Transactions[Montant]))","v":50000},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((Transactions[Catégorie]=Epargnes_budget14[[#This Row],[Epargnes]])*(MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$61&\"2000\")))*(Transactions[Montant]))","v":0},{"$f":"SUM(Epargnes_budget14[[#This Row],[Janvier]:[Décembre]])","v":50000}]
[null,"Total",{"$f":"SUBTOTAL(109,C62:C64)","v":0},0,0,0,0,0,0,50000,0,0,0,0,50000]

{"sheet":"Transactions","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,2,8,5]]}
[]
[]
[]
[]
[]
[null,"Date",{"$f":"TODAY()","v":"2025-08-07"},null,"Type"]
[null,"Catégorie",null,null,"Montant"]
[null,"Finances"]
[null,"Commentaire"]
[]
[null,"Liste des transactions"]
[]
[null,"Date","Type","Catégorie","Finances","Montant","Commentaire"]
[null,"2025-08-06","Charges","Transport","Espèce",1500,"Transport retour pour la maison"]
[null,"2025-08-06","Charges","CIE","Wave",5000,"Facture CIE du mois de juillet"]
[null,"2025-08-05","Epargnes","Autres epargnes","Banque",50000,"Epargne"]
[null,"2025-08-05","Crédits","emprunt bancaire","Banque",10000,"Garantie prêt"]
[null,"2025-08-05","Revenus","Salaire","Banque",650000,"Paie du mois de juin"]
[null,"2025-08-05","Charges","Transport","Espèce",1000,"Transport du matin pour le travail"]
[null,"2025-08-04","Revenus","Autres revenus","Wave",3000,"Remboursement de crédit (Léti)"]
[null,"2025-08-04","Charges","Nourriture","Espèce",2000,"Nourriture du soir (garba chez nicaise)"]
[null,"2025-08-04","Charges","Transport","Espèce",1000,"Transport retour à la maison"]
[null,"2025-08-04","Charges","Nourriture","Espèce",1000,"Porc"]
[null,"2025-08-04","Charges","Transport","Espèce",20000,"Abonnement mensuel au car de transport"]
[null,"2025-08-03","Revenus","Salaire","Wave",3535,"RAN du mois précédent"]
[null,"2025-08-03","Revenus","Salaire","Espèce",20350,"RAN du mois précédent"]
[null,"2025-08-03","Crédits","emprunt bancaire","Banque",72,"Correction des écarts"]
[null,"2025-08-03","Autres_charges","Entretien logement","Espèce",1000,"entretien poubelle"]
[null,"2025-08-03","Charges","Agios bancaire","Banque",12000,"agios mensuel"]
[null,"2025-08-03","Crédits","emprunt bancaire","Banque",82000,"Remboursement de prêt bancaire"]
[null,"2025-08-03","Autres_charges","Entretien logement","Espèce",50000,"Achat de pot de peinture, seau d'eau,remboursement + MOD"]
[null,"2025-08-03","Charges","Nourriture","Espèce",18000,"Achat de sac de riz rizière 25kg"]
[null,"2025-08-03","Charges","Dîme & Aumônes","Espèce",5500,"Quête du 03/08/2025"]

{"sheet":"Transfert","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,2,8,5]]}
[]
[]
[]
[]
[]
[null,"Date",{"$f":"TODAY()","v":"2025-08-07"}]
[null,"Sources",null,null,"Montant",300000]
[null,"Destinations"]
[null,"Commentaire"]
[]
[null,"Liste des transactions"]
[]
[null,"Date","Sources","Destinations","Montant","Commentaire"]
[null,"2025-08-03","Banque","Espèce",105000,"Retrait au guichet le 01/08/2025"]

{"sheet":"Contrôle","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Contrôle"]
[null,"Comptes","Théorique","Final","Ecarts"]
[null,"Espèce",{"$f":"_xlfn.XLOOKUP(B7,Traitement!$B$60:$B$63,Traitement!$N$60:$N$63,0,0)","v":{"$error":"#NAME?"}},50850,{"$f":"C7-D7","v":{"$error":"#NAME?"}}]
[null,"Banque",{"$f":"_xlfn.XLOOKUP(B8,Traitement!$B$60:$B$63,Traitement!$N$60:$N$63,0,0)","v":{"$error":"#NAME?"}},200928,{"$f":"C8-D8","v":{"$error":"#NAME?"}}]
[null,"Wave",{"$f":"_xlfn.XLOOKUP(B9,Traitement!$B$60:$B$63,Traitement!$N$60:$N$63,0,0)","v":{"$error":"#NAME?"}},3535,{"$error":"#NAME?"}]
[null,"Djamo",{"$f":"_xlfn.XLOOKUP(B10,Traitement!$B$60:$B$63,Traitement!$N$60:$N$63,0,0)","v":{"$error":"#NAME?"}},null,{"$error":"#NAME?"}]
[null,"Autres comptes",{"$f":"SUM(C9:C10)","v":{"$error":"#NAME?"}},null,{"$error":"#NAME?"}]
[null,"Total",{"$f":"C11+C8+C7","v":{"$error":"#NAME?"}},{"$f":"D11+D8+D7","v":251778},{"$f":"E11+E8+E7","v":{"$error":"#NAME?"}}]

{"sheet":"Traitement","index":7,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[48,0,48,1],[53,0,53,1],[58,0,58,1],[63,0,63,1]]}
[null,"Réel","Budget","Ratios","Total"]
["Revenus",{"$f":"Dashboard!C42","v":676885},{"$f":"Dashboard!D42","v":680000},{"$f":"IFERROR(B2/C2,0)","v":0.99541911764705882},1]
["Charges fixes",{"$f":"Dashboard!G42+Dashboard!O42","v":159072},{"$f":"Dashboard!H42+Dashboard!P42","v":304000},0.52326315789473687,1]
["Charges variables",{"$f":"Dashboard!K42","v":51000},{"$f":"Dashboard!L42","v":171000},0.2982456140350877,1]
["Investissements",{"$f":"Dashboard!K43","v":0},{"$f":"Dashboard!L43","v":0},0,1]
["Epargnes",{"$f":"Dashboard!W42","v":50000},{"$f":"Dashboard!X42","v":127000},0.39370078740157483,1]
["Solde Net",{"$f":"B2-SUM(B3:B6)","v":416813},{"$f":"C2-SUM(C3:C6)","v":78000}]
[]
[]
[]
[]
["Vue d'ensemble",null,"Réel"]
["Revenus",null,{"$f":"Dashboard!C42","v":676885}]
["Charges",null,{"$f":"Dashboard!G42","v":67000}]
["Autres charges & Loisirs",null,{"$f":"Dashboard!K42","v":51000}]
["Crédits",null,{"$f":"Dashboard!O42","v":92072}]
["Investissements",null,{"$f":"Dashboard!S42","v":0}]
["Epargnes",null,{"$f":"Dashboard!W42","v":50000}]
[]
[]
[]
["Dépenses de revenu"]
["Revenus",{"$f":"Dashboard!C42","v":676885}]
["Dépenses",{"$f":"Dashboard!G42+Dashboard!K42+Dashboard!O42+Dashboard!S42+Dashboard!W42","v":260072}]
["Ratios",{"$f":"B24/B23","v":0.3842188850395562},{"$f":"1-B25","v":0.61578111496044374}]
[null,null,null,null,{"$f":"MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\"))<=MATCH(Dashboard!$B$8,Epargnes_budget[[#Headers],[Janvier]:[Décembre]],0)","v":true}]
[]
["Répartitions des dépenses"]
[]
["Charges",null,{"$f":"Dashboard!G42","v":67000}]
["Autres charges & Loisirs",null,{"$f":"Dashboard!$K$42","v":51000}]
["Crédits",null,{"$f":"Dashboard!$O$42","v":92072}]
["Investissements",null,{"$f":"Dashboard!$S$42","v":0}]
["Epargnes",null,{"$f":"Dashboard!$W$42","v":50000}]
[]
[]
["Evolution epargne"]
["Epargne","Réel","Budget"]
["Compte bloqué",{"$f":"SUMPRODUCT((MONTH(Transactions[Date])<=MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*(Transactions[Catégorie]=A39)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(DATEVALUE(\"1\"&Epargnes_budget[[#Headers],[Janvier]:[Décembre]]&\"2000\"))<= MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*($A39=Epargnes)* (Budget!$C59:$N59)\n)","v":77000}]
["Fond d'urgence",{"$f":"SUMPRODUCT((MONTH(Transactions[Date])<=MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*(Transactions[Catégorie]=A40)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(DATEVALUE(\"1\"&Epargnes_budget[[#Headers],[Janvier]:[Décembre]]&\"2000\"))<= MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*($A40=Epargnes)* (Budget!$C60:$N60)\n)","v":0}]
["Autres epargnes",{"$f":"SUMPRODUCT((MONTH(Transactions[Date])<=MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*(Transactions[Catégorie]=A41)*(Transactions[Montant]))","v":50000},{"$f":"SUMPRODUCT((MONTH(DATEVALUE(\"1\"&Epargnes_budget[[#Headers],[Janvier]:[Décembre]]&\"2000\"))<= MONTH(DATEVALUE(\"1\"&Dashboard!$B$8&\"2000\")))*($A41=Epargnes)* (Budget!$C61:$N61)\n)","v":50000}]
[]
["Situation Nette de la tréso"]
["Rubriques","Evolution trésorerie","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
["SI","Espèce",null,{"$f":"C60","v":0},{"$f":"D60","v":0},0,0,0,0,0,24350,24350,24350,24350]
["SI","Banque",null,{"$f":"C61","v":0},0,0,0,0,0,400000,790928,790928,790928,790928]
["SI","Wave",null,0,0,0,0,0,0,0,1535,1535,1535,1535]
["SI","Djamo",null,0,0,0,0,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},0,0,0,0,0,400000,816813,816813,816813,816813]
["Entrées","Espèce",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":125350},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Destinations]=$B50)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0}]
["Entrées","Banque",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":650000},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Destinations]=$B51)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0}]
["Entrées","Wave",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":6535},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Destinations]=$B52)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0}]
["Entrées","Djamo",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Destinations]=$B53)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]=\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0}]
["Total",null,{"$f":"SUM(C50:C53)","v":0},{"$f":"SUM(D50:D53)","v":0},{"$f":"SUM(E50:E53)","v":0},{"$f":"SUM(F50:F53)","v":0},{"$f":"SUM(G50:G53)","v":0},{"$f":"SUM(H50:H53)","v":0},{"$f":"SUM(I50:I53)","v":0},{"$f":"SUM(J50:J53)","v":781885},{"$f":"SUM(K50:K53)","v":0},{"$f":"SUM(L50:L53)","v":0},{"$f":"SUM(M50:M53)","v":0},{"$f":"SUM(N50:N53)","v":0}]
["Sorties","Espèce",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B55)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":101000},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Sources]=$B55)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B50)*(Transactions[Montant]))","v":0}]
["Sorties","Banque",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B56)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":259072},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Sources]=$B56)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B51)*(Transactions[Montant]))","v":0}]
["Sorties","Wave",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B57)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":5000},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Sources]=$B57)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B52)*(Transactions[Montant]))","v":0}]
["Sorties","Djamo",{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&C$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&D$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B58)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&E$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&F$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&G$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&H$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&I$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&J$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&K$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&L$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&M$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0},{"$f":"SUMPRODUCT((MONTH(Transferts[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transferts[Sources]=$B58)*(Transferts[Montant]))+SUMPRODUCT((MONTH(Transactions[Date])=MONTH(DATEVALUE(\"1\"&N$44&\"2000\")))*(Transactions[Type]<>\"Revenus\")*(Transactions[Finances]=$B53)*(Transactions[Montant]))","v":0}]
["Total",null,{"$f":"SUM(C55:C58)","v":0},{"$f":"SUM(D55:D58)","v":0},{"$f":"SUM(E55:E58)","v":0},{"$f":"SUM(F55:F58)","v":0},{"$f":"SUM(G55:G58)","v":0},{"$f":"SUM(H55:H58)","v":0},{"$f":"SUM(I55:I58)","v":0},{"$f":"SUM(J55:J58)","v":365072},{"$f":"SUM(K55:K58)","v":0},{"$f":"SUM(L55:L58)","v":0},{"$f":"SUM(M55:M58)","v":0},{"$f":"SUM(N55:N58)","v":0}]
["SF","Espèce",{"$f":"C45+C50-C55","v":0},{"$f":"D45+D50-D55","v":0},0,0,0,0,0,24350,24350,24350,24350,24350]
["SF","Banque",{"$f":"C46+C51-C56","v":0},0,0,0,0,0,0,790928,790928,790928,790928,790928]
["SF","Wave",{"$f":"C47+C52-C57","v":0},0,0,0,0,0,0,1535,1535,1535,1535,1535]
["SF","Djamo",{"$f":"C48+C53-C58","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total",null,{"$f":"SUM(C60:C63)","v":0},{"$f":"SUM(D60:D63)","v":0},{"$f":"SUM(E60:E63)","v":0},{"$f":"SUM(F60:F63)","v":0},{"$f":"SUM(G60:G63)","v":0},{"$f":"SUM(H60:H63)","v":0},{"$f":"SUM(I60:I63)","v":0},{"$f":"SUM(J60:J63)","v":816813},{"$f":"SUM(K60:K63)","v":816813},{"$f":"SUM(L60:L63)","v":816813},{"$f":"SUM(M60:M63)","v":816813},{"$f":"SUM(N60:N63)","v":816813}]
[]
["Variation",null,{"$f":"C64-C45","v":0},{"$f":"D64-D45","v":0},0,0,0,0,0,816813,792463,792463,792463,792463]
[]
[null,null,{"$f":"C66","v":0},{"$f":"D66","v":0},0,0,0,0,0,816813,792463,792463,792463,792463]