{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Sommaire budget cumulé","Frais mensuels","1000-Bureau","2000-Magasin","3000-Dotation en personnel","4000-Équipement","5000-Autre"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Sommaire budget cumulé","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,5]]}
[]
["Budget 2006 réel vs Budget cumulé sur l'exercice en cours"]
[]
["N° de compte","Compte","Réel cumulé sur l'exercice en cours","Budget cumulé sur l'exercice en cours","Budget restant €","% budget restant"]
[1000,"Bureau",{"$f":"'Frais mensuels'!O5","v":{"v":100,"d":"100.00 €"}},{"v":50000,"d":"50,000.00 €"},{"$f":"SUM(D5-C5)","v":{"v":49900,"d":"49,900.00 €"}},{"$f":"SUM(Tableau1[Budget restant €]/Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":0.998,"d":"99.80%"}}]
[2000,"Magasin",{"$f":"'Frais mensuels'!O6","v":{"v":905.27,"d":"905.27 €"}},{"v":75000,"d":"75,000.00 €"},{"$f":"SUM(D6-C6)","v":{"v":74094.73,"d":"74,094.73 €"}},{"$f":"SUM(Tableau1[Budget restant €]/Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":0.9879297333333332,"d":"98.79%"}}]
[3000,"Dotation en personnel",{"$f":"'Frais mensuels'!O7","v":0},{"v":100000,"d":"100,000.00 €"},{"$f":"SUM(D7-C7)","v":{"v":100000,"d":"100,000.00 €"}},{"$f":"SUM(Tableau1[Budget restant €]/Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":1,"d":"100.00%"}}]
[4000,"Équipement",{"$f":"'Frais mensuels'!O8","v":{"v":1854,"d":"1,854.00 €"}},{"v":25000,"d":"25,000.00 €"},{"$f":"SUM(D8-C8)","v":{"v":23146,"d":"23,146.00 €"}},{"$f":"SUM(Tableau1[Budget restant €]/Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":0.92584,"d":"92.58%"}}]
[5000,"Autre",{"$f":"'Frais mensuels'!O9","v":{"v":35.6,"d":"35.60 €"}},{"v":50000,"d":"50,000.00 €"},{"$f":"SUM(D9-C9)","v":{"v":49964.4,"d":"49,964.40 €"}},{"$f":"SUM(Tableau1[Budget restant €]/Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":0.9992880000000001,"d":"99.93%"}}]
["Total",null,{"$f":"SUBTOTAL(109,Tableau1[Réel cumulé sur l''exercice en cours])","v":{"v":2894.87,"d":"2,894.87 €"}},{"$f":"SUBTOTAL(109,Tableau1[Budget cumulé sur l''exercice en cours])","v":{"v":300000,"d":"300,000.00 €"}},{"$f":"SUBTOTAL(109,Tableau1[Budget restant €])","v":{"v":297105.13,"d":"297,105.13 €"}},{"$f":"Tableau1[[#Totals],[Budget restant €]]/Tableau1[[#Totals],[Budget cumulé sur l''exercice en cours]]","v":{"v":0.9903504333333334,"d":"99.04%"}}]

{"sheet":"Frais mensuels","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[1,0,1,14]]}
[]
["Frais mensuels 2006"]
[]
["N° de compte","Compte","Jan-06","Fév-06","Mar-06","Avr-06","Mai-06","Juin-06","Juil-06","Août-06","Sep-06","Oct-06","Nov-06","Déc-06","Total 2006"]
[1000,"Bureau",{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":{"v":100,"d":"100.00 €"}},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUMIF('1000-Bureau'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-aa\")),'1000-Bureau'!$E:$E)","v":0},{"$f":"SUM(Tableau2[Jan-06]+Tableau2[Fév-06]+Tableau2[Mar-06]+Tableau2[Avr-06]+Tableau2[Mai-06]+Tableau2[Juin-06]+Tableau2[Juil-06]+Tableau2[Août-06]+Tableau2[Sep-06]+Tableau2[Oct-06]+Tableau2[Nov-06]+Tableau2[Déc-06])","v":{"v":100,"d":"100.00 €"}}]
[2000,"Magasin",{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":{"v":905.27,"d":"905.27 €"}},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUMIF('2000-Magasin'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-aa\")),'2000-Magasin'!$E:$E)","v":0},{"$f":"SUM(Tableau2[Jan-06]+Tableau2[Fév-06]+Tableau2[Mar-06]+Tableau2[Avr-06]+Tableau2[Mai-06]+Tableau2[Juin-06]+Tableau2[Juil-06]+Tableau2[Août-06]+Tableau2[Sep-06]+Tableau2[Oct-06]+Tableau2[Nov-06]+Tableau2[Déc-06])","v":{"v":905.27,"d":"905.27 €"}}]
[3000,"Dotation en personnel",{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUMIF('3000-Dotation en personnel'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-aa\")),'3000-Dotation en personnel'!$E:$E)","v":0},{"$f":"SUM(Tableau2[Jan-06]+Tableau2[Fév-06]+Tableau2[Mar-06]+Tableau2[Avr-06]+Tableau2[Mai-06]+Tableau2[Juin-06]+Tableau2[Juil-06]+Tableau2[Août-06]+Tableau2[Sep-06]+Tableau2[Oct-06]+Tableau2[Nov-06]+Tableau2[Déc-06])","v":0}]
[4000,"Équipement",{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":{"v":1854,"d":"1,854.00 €"}},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUMIF('4000-Équipement'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-aa\")),'4000-Équipement'!$E:$E)","v":0},{"$f":"SUM(Tableau2[Jan-06]+Tableau2[Fév-06]+Tableau2[Mar-06]+Tableau2[Avr-06]+Tableau2[Mai-06]+Tableau2[Juin-06]+Tableau2[Juil-06]+Tableau2[Août-06]+Tableau2[Sep-06]+Tableau2[Oct-06]+Tableau2[Nov-06]+Tableau2[Déc-06])","v":{"v":1854,"d":"1,854.00 €"}}]
[5000,"Autre",{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(C$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":{"v":35.6,"d":"35.60 €"}},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(D$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(E$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(F$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(G$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(H$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(I$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(J$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(K$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(L$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(M$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUMIF('5000-Autre'!$J:$J,\"=\"&(TEXT(N$4,\"mmm-aa\")),'5000-Autre'!$E:$E)","v":0},{"$f":"SUM(Tableau2[Jan-06]+Tableau2[Fév-06]+Tableau2[Mar-06]+Tableau2[Avr-06]+Tableau2[Mai-06]+Tableau2[Juin-06]+Tableau2[Juil-06]+Tableau2[Août-06]+Tableau2[Sep-06]+Tableau2[Oct-06]+Tableau2[Nov-06]+Tableau2[Déc-06])","v":{"v":35.6,"d":"35.60 €"}}]
["Total",null,{"$f":"SUBTOTAL(109,Tableau2[Jan-06])","v":{"v":2894.87,"d":"2,894.87 €"}},{"$f":"SUBTOTAL(109,Tableau2[Fév-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Mar-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Avr-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Mai-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Juin-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Juil-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Août-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Sep-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Oct-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Nov-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Déc-06])","v":0},{"$f":"SUBTOTAL(109,Tableau2[Total 2006])","v":{"v":2894.87,"d":"2,894.87 €"}}]

{"sheet":"1000-Bureau","index":2,"n_rows":6,"n_cols":10,"rows_kept":6}
["G/L - Frais","Date de facture","N° de facture ","Demandée par ","Montant du chèque","Nom du bénéficiaire","Utilisation du chèque","Méthode de distribution","Date de dépôt","Champ clé construit"]
[1000,"2006-01-15",1,"André Martin",{"v":100,"d":"100.00 €"},"Consolidated Messenger ","CD-ROM vierges","Crédit","2006-01-20",{"$f":"TEXT(B2,\"mmm-aa\")","v":"Jan-aa"}]
[1000,"2006-02-07",5,"André Martin",{"v":50,"d":"50.00 €"},"Consolidated Messenger ","Encre imprimante","Crédit","2006-02-10",{"$f":"TEXT(B3,\"mmm-aa\")","v":"Feb-aa"}]
[1000,"2006-02-15",10,"André Martin",{"v":275,"d":"275.00 €"},"Acme","Services administratifs","Crédit","2006-02-10",{"$f":"TEXT(B4,\"mmm-aa\")","v":"Feb-aa"}]
[1000,{"$nulls":8},{"$f":"TEXT(B5,\"mmm-aa\")","v":"Jan-aa"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tableau3[Montant du chèque])","v":{"v":425,"d":"425.00 €"}}]

{"sheet":"2000-Magasin","index":3,"n_rows":5,"n_cols":10,"rows_kept":5}
["G/L - Frais","Date de facture","N° de facture ","Demandée par ","Montant du chèque","Nom du bénéficiaire","Utilisation du chèque","Méthode de distribution","Date de dépôt","Champ clé construit"]
[2000,"2006-01-17",2,"Marc Faeber",{"v":550,"d":"550.00 €"},"Fabrikam, Inc. ","Remplacer la fenêtre du magasin","Crédit","2006-01-20",{"$f":"TEXT(B2,\"mmm-aa\")","v":"Jan-aa"}]
[2000,"2006-01-19",3,"Marc Faeber",{"v":355.27,"d":"355.27 €"},"A. Datum Corporation ","Nouvelle caisse enregistreuse","Crédit","2006-01-20",{"$f":"TEXT(B3,\"mmm-aa\")","v":"Jan-aa"}]
[2000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-aa\")","v":"Jan-aa"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tableau4[Montant du chèque])","v":{"v":905.27,"d":"905.27 €"}}]

{"sheet":"3000-Dotation en personnel","index":4,"n_rows":5,"n_cols":10,"rows_kept":5}
["G/L - Frais","Date de facture","N° de facture ","Demandée par ","Montant du chèque","Nom du bénéficiaire","Utilisation du chèque","Méthode de distribution","Date de dépôt","Champ clé construit"]
[3000,"2006-02-10",6,"Marc Durant",{"v":2500,"d":"2,500.00 €"},"Institut d'arts graphiques ","Rédacteur de contrat","Chèque","2006-02-20",{"$f":"TEXT(B2,\"mmm-aa\")","v":"Feb-aa"}]
[3000,"2006-02-15",11,"Sandeep Kaliyath",{"v":15000,"d":"15,000.00 €"},"Adventure Works","Rédacteur de contrat","Chèque","2006-02-20",{"$f":"TEXT(B3,\"mmm-aa\")","v":"Feb-aa"}]
[3000,{"$nulls":8},{"$f":"TEXT(B4,\"mmm-aa\")","v":"Jan-aa"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tableau5[Montant du chèque])","v":{"v":17500,"d":"17,500.00 €"}}]

{"sheet":"4000-Équipement","index":5,"n_rows":4,"n_cols":10,"rows_kept":4}
["G/L - Frais","Date de facture","N° de facture ","Demandée par ","Montant du chèque","Nom du bénéficiaire","Utilisation du chèque","Méthode de distribution","Date de dépôt","Champ clé construit"]
[4000,"2006-01-25",5,"Jean Dupont",{"v":1854,"d":"1,854.00 €"},"Trey Research ","Nouvel ordinateur portable","Crédit","2006-01-25",{"$f":"TEXT(B2,\"mmm-aa\")","v":"Jan-aa"}]
[4000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-aa\")","v":"Jan-aa"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tableau6[Montant du chèque])","v":{"v":1854,"d":"1,854.00 €"}}]

{"sheet":"5000-Autre","index":6,"n_rows":4,"n_cols":10,"rows_kept":4}
["G/L - Frais","Date de facture","N° de facture ","Demandée par ","Montant du chèque","Nom du bénéficiaire","Utilisation du chèque","Méthode de distribution","Date de dépôt","Champ clé construit"]
[5000,"2006-01-23",4,"Bob Gage",{"v":35.6,"d":"35.60 €"},"Bob Gage","Frais de taxi","Chèque","2006-01-23",{"$f":"TEXT(B2,\"mmm-aa\")","v":"Jan-aa"}]
[5000,{"$nulls":8},{"$f":"TEXT(B3,\"mmm-aa\")","v":"Jan-aa"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Tableau7[Montant du chèque])","v":{"v":35.6,"d":"35.60 €"}}]