{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Dépenses","Revenu","Résumé des profits et pertes"],"not_rendered":{"charts":4,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Dépenses","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"Soirée de lancement de produit"]
[null,"DÉTAILS DES DÉPENSES"]
[]
[]
[null,"Total des dépenses","Estimé","Réel",null,"Programme","Estimé","Réel"]
[null,null,{"$f":"DépensesSite[[#Totals],[Estimé]]+DépensesDécoration[[#Totals],[Estimé]]+DépensesPublicité[[#Totals],[Estimé]]+DépensesDiverses[[#Totals],[Estimé]]+DépensesBoissons[[#Totals],[Estimé]]+DépensesProgramme[[#Totals],[Estimé]]+DépensesRécompenses[[#Totals],[Estimé]]","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"DépensesSite[[#Totals],[Réel]]+DépensesDécoration[[#Totals],[Réel]]+DépensesPublicité[[#Totals],[Réel]]+DépensesDiverses[[#Totals],[Réel]]+DépensesBoissons[[#Totals],[Réel]]+DépensesProgramme[[#Totals],[Réel]]+DépensesRécompenses[[#Totals],[Réel]]","v":{"v":1640,"d":"1,640.00 €"}},null,"Intervenants",{"v":750,"d":"750.00 €"},{"v":700,"d":"700.00 €"}]
[{"$nulls":5},"Présentateurs",{"v":150,"d":"150.00 €"},{"v":0,"d":"0.00 €"}]
[{"$nulls":5},"Déplacements"]
[null,"Site","Estimé","Réel",null,"Hôtel"]
[null,"Location de salle",{"v":500,"d":"500.00 €"},{"v":450,"d":"450.00 €"},null,"Autres"]
[null,"Personnel du site",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,DépensesProgramme[Estimé])","v":{"v":900,"d":"900.00 €"}},{"$f":"SUBTOTAL(109,DépensesProgramme[Réel])","v":{"v":700,"d":"700.00 €"}}]
[null,"Matériel"]
[null,"Tables et chaises",{"$nulls":3},"Publicité","Estimé","Réel"]
[null,"Total",{"$f":"SUBTOTAL(109,DépensesSite[Estimé])","v":{"v":500,"d":"500.00 €"}},{"$f":"SUBTOTAL(109,DépensesSite[Réel])","v":{"v":450,"d":"450.00 €"}},null,"Travail graphique"]
[{"$nulls":5},"Photocopie / Impression",{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"}]
[null,"Décorations","Estimé","Réel",null,"Affranchissement"]
[null,"Fleurs",{"v":200,"d":"200.00 €"},{"v":100,"d":"100.00 €"},null,"Total",{"$f":"SUBTOTAL(109,DépensesPublicité[Estimé])","v":{"v":20,"d":"20.00 €"}},{"$f":"SUBTOTAL(109,DépensesPublicité[Réel])","v":{"v":20,"d":"20.00 €"}}]
[null,"Bougies"]
[null,"Éclairage",{"$nulls":3},"Prix","Estimé","Réel"]
[null,"Ballons",{"$nulls":3},"Rubans / Trophées"]
[null,"Fournitures papier",{"$nulls":3},"Cadeaux",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"}]
[null,"Total",{"$f":"SUBTOTAL(109,DépensesDécoration[Estimé])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,DépensesDécoration[Réel])","v":{"v":100,"d":"100.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,DépensesRécompenses[Estimé])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,DépensesRécompenses[Réel])","v":{"v":100,"d":"100.00 €"}}]
[]
[null,"Rafraîchissements","Estimé","Réel",null,"Divers","Estimé","Réel"]
[null,"Repas",{"$nulls":3},"Téléphone",{"v":50,"d":"50.00 €"},{"v":50,"d":"50.00 €"}]
[null,"Boissons",{"v":220,"d":"220.00 €"},{"v":120,"d":"120.00 €"},null,"Transport",{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"}]
[null,"Linge de table",{"v":80,"d":"80.00 €"},{"v":80,"d":"80.00 €"},null,"Papeterie"]
[null,"Personnel et pourboires",{"$nulls":3},"Télécopie"]
[null,"Total",{"$f":"SUBTOTAL(109,DépensesBoissons[Estimé])","v":{"v":300,"d":"300.00 €"}},{"$f":"SUBTOTAL(109,DépensesBoissons[Réel])","v":{"v":200,"d":"200.00 €"}},null,"Total",{"$f":"SUBTOTAL(109,DépensesDiverses[Estimé])","v":{"v":70,"d":"70.00 €"}},{"$f":"SUBTOTAL(109,DépensesDiverses[Réel])","v":{"v":70,"d":"70.00 €"}}]

{"sheet":"Revenu","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[6,1,7,1],[9,1,9,6],[16,1,16,6],[23,1,23,6],[30,1,30,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Dépenses!B3","v":"Soirée de lancement de produit"}]
[null,"DÉTAILS DES REVENUS"]
[]
[]
[null,"Total des revenus","Estimé","Réel"]
[null,null,{"$f":"SUM(Entrées[[#Totals],[Revenus estimés]],AnnoncesDansProgramme[[#Totals],[Revenus estimés]],ExposantsEtVendeurs[[#Totals],[Revenus estimés]],VenteArticles[[#Totals],[Revenus estimés]])","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"SUM(Entrées[[#Totals],[Revenus réels]],AnnoncesDansProgramme[[#Totals],[Revenus réels]],ExposantsEtVendeurs[[#Totals],[Revenus réels]],VenteArticles[[#Totals],[Revenus réels]])","v":{"v":4170,"d":"4,170.00 €"}}]
[]
[null,"Entrées"]
[null,"Type","Estimé","Réel","Prix","Revenus estimés","Revenus réels"]
[null,"Adultes",30,25,{"v":20,"d":"20.00 €"},{"$f":"C12*E12","v":{"v":600,"d":"600.00 €"}},{"$f":"D12*E12","v":{"v":500,"d":"500.00 €"}}]
[null,"Enfants",20,22,{"v":10,"d":"10.00 €"},{"$f":"C13*E13","v":{"v":200,"d":"200.00 €"}},{"$f":"D13*E13","v":{"v":220,"d":"220.00 €"}}]
[null,"Autre",10,10,{"v":10,"d":"10.00 €"},{"$f":"C14*E14","v":{"v":100,"d":"100.00 €"}},{"$f":"D14*E14","v":{"v":100,"d":"100.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Entrées[Estimé])","v":60},{"$f":"SUBTOTAL(109,Entrées[Réel])","v":57},null,{"$f":"SUBTOTAL(109,Entrées[Revenus estimés])","v":{"v":900,"d":"900.00 €"}},{"$f":"SUBTOTAL(109,Entrées[Revenus réels])","v":{"v":820,"d":"820.00 €"}}]
[]
[null,"Publicités dans le programme"]
[null,"Type","Estimé","Réel","Prix","Revenus estimés","Revenus réels"]
[null,"Couvertures",2,4,{"v":50,"d":"50.00 €"},{"$f":"C19*E19","v":{"v":100,"d":"100.00 €"}},{"$f":"D19*E19","v":{"v":200,"d":"200.00 €"}}]
[null,"Demi-pages",2,2,{"v":30,"d":"30.00 €"},{"$f":"C20*E20","v":{"v":60,"d":"60.00 €"}},{"$f":"D20*E20","v":{"v":60,"d":"60.00 €"}}]
[null,"Quart de pages",2,2,{"v":20,"d":"20.00 €"},{"$f":"C21*E21","v":{"v":40,"d":"40.00 €"}},{"$f":"D21*E21","v":{"v":40,"d":"40.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,AnnoncesDansProgramme[Estimé])","v":6},{"$f":"SUBTOTAL(109,AnnoncesDansProgramme[Réel])","v":8},null,{"$f":"SUBTOTAL(109,AnnoncesDansProgramme[Revenus estimés])","v":{"v":200,"d":"200.00 €"}},{"$f":"SUBTOTAL(109,AnnoncesDansProgramme[Revenus réels])","v":{"v":300,"d":"300.00 €"}}]
[]
[null,"Exposants / Fournisseurs"]
[null,"Type","Estimé","Réel","Prix","Revenus estimés","Revenus réels"]
[null,"Grands stands",5,5,{"v":300,"d":"300.00 €"},{"$f":"C26*E26","v":{"v":1500,"d":"1,500.00 €"}},{"$f":"D26*E26","v":{"v":1500,"d":"1,500.00 €"}}]
[null,"Stands moyens",5,4,{"v":200,"d":"200.00 €"},{"$f":"C27*E27","v":{"v":1000,"d":"1,000.00 €"}},{"$f":"D27*E27","v":{"v":800,"d":"800.00 €"}}]
[null,"Petits stands",1,0,{"v":100,"d":"100.00 €"},{"$f":"C28*E28","v":{"v":100,"d":"100.00 €"}},{"$f":"D28*E28","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,ExposantsEtVendeurs[Estimé])","v":11},{"$f":"SUBTOTAL(109,ExposantsEtVendeurs[Réel])","v":9},null,{"$f":"SUBTOTAL(109,ExposantsEtVendeurs[Revenus estimés])","v":{"v":2600,"d":"2,600.00 €"}},{"$f":"SUBTOTAL(109,ExposantsEtVendeurs[Revenus réels])","v":{"v":2300,"d":"2,300.00 €"}}]
[]
[null,"Vente d’articles"]
[null,"Type","Estimé","Réel","Prix","Revenus estimés","Revenus réels"]
[null,"Article 1",2,2,{"v":150,"d":"150.00 €"},{"$f":"C33*E33","v":{"v":300,"d":"300.00 €"}},{"$f":"D33*E33","v":{"v":300,"d":"300.00 €"}}]
[null,"Bien 2",5,5,{"v":50,"d":"50.00 €"},{"$f":"C34*E34","v":{"v":250,"d":"250.00 €"}},{"$f":"D34*E34","v":{"v":250,"d":"250.00 €"}}]
[null,"Bien 3",5,5,{"v":20,"d":"20.00 €"},{"$f":"C35*E35","v":{"v":100,"d":"100.00 €"}},{"$f":"D35*E35","v":{"v":100,"d":"100.00 €"}}]
[null,"Élément 4",5,5,{"v":20,"d":"20.00 €"},{"$f":"C36*E36","v":{"v":100,"d":"100.00 €"}},{"$f":"D36*E36","v":{"v":100,"d":"100.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,VenteArticles[Estimé])","v":17},{"$f":"SUBTOTAL(109,VenteArticles[Réel])","v":17},null,{"$f":"SUBTOTAL(109,VenteArticles[Revenus estimés])","v":{"v":750,"d":"750.00 €"}},{"$f":"SUBTOTAL(109,VenteArticles[Revenus réels])","v":{"v":750,"d":"750.00 €"}}]

{"sheet":"Résumé des profits et pertes","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Dépenses!B3","v":"Soirée de lancement de produit"}]
[null,"RÉCAPITULATIF DES PROFITS ET PERTES"]
[]
[]
[null,"Récapitulatif des dépenses","Estimé","Réel",null,"Dépenses réelles",{"$nulls":5},"Classement","Dépenses","Estimé","Réel","Valeur de classement"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"Programme"},{"$f":"VLOOKUP(1,$L$8:$O$14,3,FALSE)","v":{"v":900,"d":"900.00 €"}},{"$f":"VLOOKUP(1,$L$8:$O$14,4,FALSE)","v":{"v":700,"d":"700.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P8,$P$8:$P$14)","v":2},"Site",{"$f":"DépensesSite[[#Totals],[Estimé]]","v":{"v":500,"d":"500 €"}},{"$f":"DépensesSite[[#Totals],[Réel]]","v":{"v":450,"d":"450 €"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"Site"},{"$f":"VLOOKUP(2,$L$8:$O$14,3,FALSE)","v":{"v":500,"d":"500.00 €"}},{"$f":"VLOOKUP(2,$L$8:$O$14,4,FALSE)","v":{"v":450,"d":"450.00 €"}},{"$nulls":7},5,"Décorations",{"$f":"DépensesDécoration[[#Totals],[Estimé]]","v":{"v":200,"d":"200 €"}},{"$f":"DépensesDécoration[[#Totals],[Réel]]","v":{"v":100,"d":"100 €"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"Rafraîchissements"},{"$f":"VLOOKUP(3,$L$8:$O$14,3,FALSE)","v":{"v":300,"d":"300.00 €"}},{"$f":"VLOOKUP(3,$L$8:$O$14,4,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$nulls":7},3,"Rafraîchissements",{"$f":"DépensesBoissons[[#Totals],[Estimé]]","v":{"v":300,"d":"300 €"}},{"$f":"DépensesBoissons[[#Totals],[Réel]]","v":{"v":200,"d":"200 €"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"Prix"},{"$f":"VLOOKUP(4,$L$8:$O$14,3,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$f":"VLOOKUP(4,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$nulls":7},1,"Programme",{"$f":"DépensesProgramme[[#Totals],[Estimé]]","v":{"v":900,"d":"900 €"}},{"$f":"DépensesProgramme[[#Totals],[Réel]]","v":{"v":700,"d":"700 €"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"Décorations"},{"$f":"VLOOKUP(5,$L$8:$O$14,3,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$f":"VLOOKUP(5,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"100.00 €"}},{"$nulls":7},7,"Publicité",{"$f":"DépensesPublicité[[#Totals],[Estimé]]","v":{"v":20,"d":"20 €"}},{"$f":"DépensesPublicité[[#Totals],[Réel]]","v":{"v":20,"d":"20 €"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"Divers"},{"$f":"VLOOKUP(6,$L$8:$O$14,3,FALSE)","v":{"v":70,"d":"70.00 €"}},{"$f":"VLOOKUP(6,$L$8:$O$14,4,FALSE)","v":{"v":70,"d":"70.00 €"}},{"$nulls":7},4,"Prix",{"$f":"DépensesRécompenses[[#Totals],[Estimé]]","v":{"v":100,"d":"100 €"}},{"$f":"DépensesRécompenses[[#Totals],[Réel]]","v":{"v":100,"d":"100 €"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"Publicité"},{"$f":"VLOOKUP(7,$L$8:$O$14,3,FALSE)","v":{"v":20,"d":"20.00 €"}},{"$f":"VLOOKUP(7,$L$8:$O$14,4,FALSE)","v":{"v":20,"d":"20.00 €"}},{"$nulls":7},6,"Divers",{"$f":"DépensesDiverses[[#Totals],[Estimé]]","v":{"v":70,"d":"70 €"}},{"$f":"DépensesDiverses[[#Totals],[Réel]]","v":{"v":70,"d":"70 €"}},70.0014]
[null,"Total",{"$f":"SUBTOTAL(109,RécapitulatifDesDépenses[Estimé])","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"SUBTOTAL(109,RécapitulatifDesDépenses[Réel])","v":{"v":1640,"d":"1,640.00 €"}}]
[]
[null,"Récapitulatif des revenus","Estimé","Réel",null,"Revenus réels",{"$nulls":5},"Classement","Revenus","Estimé","Réel","Valeur de classement"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"Exposants / Fournisseurs"},{"$f":"VLOOKUP(1,$L$18:$O$21,3,FALSE)","v":{"v":2600,"d":"2,600.00 €"}},{"$f":"VLOOKUP(1,$L$18:$O$21,4,FALSE)","v":{"v":2300,"d":"2,300.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P18,$P$18:$P$21)","v":2},"Entrées",{"$f":"Entrées[[#Totals],[Revenus estimés]]","v":{"v":900,"d":"900 €"}},{"$f":"Entrées[[#Totals],[Revenus réels]]","v":{"v":820,"d":"820 €"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"Entrées"},{"$f":"VLOOKUP(2,$L$18:$O$21,3,FALSE)","v":{"v":900,"d":"900.00 €"}},{"$f":"VLOOKUP(2,$L$18:$O$21,4,FALSE)","v":{"v":820,"d":"820.00 €"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P19,$P$18:$P$21)","v":4},"Publicités dans le programme",{"$f":"AnnoncesDansProgramme[[#Totals],[Revenus estimés]]","v":{"v":200,"d":"200 €"}},{"$f":"AnnoncesDansProgramme[[#Totals],[Revenus réels]]","v":{"v":300,"d":"300 €"}},300.0019]
[null,"Vente d’articles",{"$f":"VLOOKUP(3,$L$18:$O$21,3,FALSE)","v":{"v":750,"d":"750.00 €"}},{"$f":"VLOOKUP(3,$L$18:$O$21,4,FALSE)","v":{"v":750,"d":"750.00 €"}},{"$nulls":7},1,"Exposants / Fournisseurs",{"$f":"ExposantsEtVendeurs[[#Totals],[Revenus estimés]]","v":{"v":2600,"d":"2,600 €"}},{"$f":"ExposantsEtVendeurs[[#Totals],[Revenus réels]]","v":{"v":2300,"d":"2,300 €"}},{"v":2300.002,"d":"2,300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"Publicités dans le programme"},{"$f":"VLOOKUP(4,$L$18:$O$21,3,FALSE)","v":{"v":200,"d":"200.00 €"}},{"$f":"VLOOKUP(4,$L$18:$O$21,4,FALSE)","v":{"v":300,"d":"300.00 €"}},{"$nulls":7},3,"Vente d’articles",{"$f":"VenteArticles[[#Totals],[Revenus estimés]]","v":{"v":750,"d":"750 €"}},{"$f":"VenteArticles[[#Totals],[Revenus réels]]","v":{"v":750,"d":"750 €"}},750.0021]
[null,"Total",{"$f":"SUBTOTAL(109,RevenuRésumé[Estimé])","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"SUBTOTAL(109,RevenuRésumé[Réel])","v":{"v":4170,"d":"4,170.00 €"}}]
[]
[null,"Récapitulatif des profits et pertes","Estimé","Réel"]
[null,"Total des revenus",{"$f":"RevenuRésumé[[#Totals],[Estimé]]","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"RevenuRésumé[[#Totals],[Réel]]","v":{"v":4170,"d":"4,170.00 €"}}]
[null,"Total des dépenses",{"$f":"RécapitulatifDesDépenses[[#Totals],[Estimé]]","v":{"v":2090,"d":"2,090.00 €"}},{"$f":"RécapitulatifDesDépenses[[#Totals],[Réel]]","v":{"v":1640,"d":"1,640.00 €"}}]
[null,"Total des profits (ou pertes)",{"$f":"C25-C26","v":{"v":2360,"d":"2,360.00 €"}},{"$f":"D25-D26","v":{"v":2530,"d":"2,530.00 €"}}]
[]
[null,"Ratio dépenses/profits (pertes)",null,null,"Coûts estimés contre coûts réels"]