{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Recettes","Personnel","Infrastructure","Fonctionnement","Transports","Communication","Investissements","Financement","Résumé","Projections An 1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Introduction et instructions pour le plan financier simplifié"]
["Cet outil est destiné à préparer des projections financières simples, avec deux particularités:\n\n 1) Être progressif avec plusieurs onglets, te permettant de ne réfléchir qu'à un bloc à la fois;\n 2) Être utilisé soit pour un projet déterminé dans le temps (un début et une fin) ou pour\n     la création d'une entreprise, que ce soit une association, un collectif ou encore une activité\n     entrepreneuriale.\n\nCette deuxième utilisation commence par le projet d'implantation et éventuellement la phase \"pilote\" et ajoute ensuite l'aspect de fonctionnement durant la première année, afin de vérifier la viabilité et la trésorerie."]
["Chaque onglet contient un seul tableau éditable de 10 lignes, que tu peux remplir avec tes informations. Ils sont construits pour ne garder que l'essentiel.\n\nUn deuxième tableau, non éditable est prérempli avec des exemples d'éléments que tu peux utiliser pour le nom des lignes du premier tableau, pour te faciliter l'édition; cependant, rien ne t'empêche de donner tes propres définitions.\n\nChaque onglet contient aussi un bouton pour copier le tableau éditable, afin que tu puisses, par exemple le coller dans un document texte (Word, LibreOffice ou autre)."]
["Les onglets sont organisés en commençant avant les éventuelles recettes, puis les dépenses pour la partie du projet suivis des investissements et du financement. Un onglet \"Résumé\" concentre les totaux des premiers onglets et effectue quelques calculs. Ensuite viennent les onglets concernant les projections pour la première année d'exercice, dans le cas d'une organisation ou entreprise."]
[]
["Recettes: produits des ventes, moins les charges variables liées aux volumes des ventes, tels que des billets, des repas, des objets, etc. "]
["Personnel: frais et charges liés au personnel interne du projet ou de l'organisation."]
["Infrastructure: charges liées à l'infrastructure telles que les loyers ou location, aménagements, la maintenance d'équipements, etc."]
["Fonctionnement: frais liés au fonctionnement courant tels que l'administratif, les frais de bureau, des abonnements, du petit matériel, etc."]
["Transports: frais et charges liées au transport et aux défraiements des bénévoles, etc."]
["Communication: tous les frais liés à la communication, tels que la réalisation d'affiches, de brochures, des annonces, des publicités et des services de tiers pour le graphisme et le site internet, etc."]
["Investissements: coût d'achats uniques, généralement pour l'infrastructure, tels que des machines, des équipements informatiques, des véhicules, etc."]
["Financement: autres entrées financières, telles des subventions, des dons, des fonds propres, des prestations offertes, la valorisation de l'effort bénévole, etc."]
["Résumé: Résumé des totaux des tableaux précédents et consolidation de la trésorerie"]
["Projections An 1: jonction de tous les tableaux des recettes au financement, avec le report des valeurs initiales plus 12 colonnes mensuelles pour introduire les chiffres des projections.\nDiverses lignes intermédiaires sont calculées, afin de suivre l'évolution de la trésorerie."]
["Important: \nLes valeurs positives présentées en noir ou vert représentent des rentrées ou des avoirs financiers, les valeurs en rouge, négatives, représentent des sorties ou des manques financiers. \nToutes les valeurs doivent être écrites sans le signe - , lorsqu'il s'agit de sorties financières, tels de des coûts ou des paiements, elles seront automatiquement converties en négatif, avec le signe - et montrées en rouge."]
["Toutes les feuilles sont protégées, pour éviter les petites erreurs de manipulation. Elles peuvent être déprotégées car il n'y a aucun mot de passe. Les macros doivent être autorisées pour certaines actions."]

{"sheet":"Recettes","index":1,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,0,55,3],[0,0,0,3],[26,0,26,2],[13,0,13,2]]}
["Instructions pour les recettes des prestations\n\nCe tableau te permet d'informer jusqu'à 10 de tes principales prestations,  éléments de recettes et de coûts. Pour chacune d'entre eux:\n\n 1) Choisis dans la première colonne du premier tableau une des prestations suggérées\n     ou écris ta propre définition;  (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité produite / vendue durant le projet;\n 3) Informe son prix de vente unitaire;\n 4) Dans le 2ème tableau, indique seulement les coûts de production unitaires.\n \nLes deux colonnes de la recette totale et du coût total sont calculées automatiquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Recettes variables des prestations         (unité)","Quantité","Prix unitaire","Recette totale",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,0,null,"Billets"]
[null,null,null,0,null,"Repas"]
[null,null,null,0,null,"Boissons"]
[null,null,null,0,null,"Souvenirs"]
[null,null,null,0,null,"Habits"]
[null,null,null,0,null,"Meubles"]
[null,null,null,0,null,"Autres services"]
[null,null,null,0,null,"Autres produits"]
[null,null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]
[]
["Coûts variables des prestations              (unité)","Quantité","Coût unitaire","Coût total"]
[{"$f":"IF(A4=\"\",\"\",A4)","v":""},{"$f":"IF(B4=\"\",0,B4)","v":0},null,{"$f":"B17*C17","v":0}]
[{"$f":"IF(A5=\"\",\"\",A5)","v":""},{"$f":"IF(B5=\"\",0,B5)","v":0},null,{"$f":"B18*C18","v":0}]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["",0,null,0]
["Total:",null,null,{"$f":"SUM(D17:D26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Marge positive ou déficit:",null,null,null,{"$f":"D14-D27","v":0}]

{"sheet":"Personnel","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[15,0,15,3],[13,0,13,2],[0,0,0,3]]}
["Instructions pour les frais de personnel\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux éléments de frais de personnel, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet, par exemple en EPT pour les salairesl;\n 3) Informe son coût unitaire, le cas échéant avec les charges salariales;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des frais de personne est calculé automatiquement.\n* Le bénévolat peut être valorisé comme une dépense dans les frais de personnel et sera\n   équilibré automatiquement par un même montant dans le financement, considéré\n   comme un don. Dans certains cas, il peut être ainsi considéré dans les fonds propres.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Frais de personnel","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Salaires / honoraires"]
[null,null,null,0,null,"Charges salariales"]
[null,null,null,0,null,"Défraiements"]
[null,null,null,0,null,"Hébergements"]
[null,null,null,0,null,"Notes de frais"]
[null,null,null,0,null,"Assurances spéciales"]
[null,null,null,0]
[null,null,null,0]
["Heures de bénévolat*",null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Infrastructure","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,2],[0,0,0,3]]}
["Instructions pour les coûts d'infrastructure\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux éléments d'infrastructure, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet;\n 3) Informe son coût unitaire;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des dépenses en infrastructure est calculé automaniquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Elément d'infrastructure                       (unité)","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Location / loyer"]
[null,null,null,0,null,"Entretien / nettoyage"]
[null,null,null,0,null,"Chauffage / électricité"]
[null,null,null,0,null,"Maintenance équipements"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Fonctionnement","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[13,0,13,2]]}
["Instructions pour les frais de fonctionnement\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux frais de fonctionnement, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet;\n 3) Informe son coût unitaire;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des dépenses en fonctionnement est calculé automatiquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Frais de fonctionnement                       (unité)","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Courrier"]
[null,null,null,0,null,"Téléphone (abo)"]
[null,null,null,0,null,"Papier"]
[null,null,null,0,null,"Encre imprimante"]
[null,null,null,0,null,"Stockage d'informations"]
[null,null,null,0,null,"Lanches et café"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Transports","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[13,0,13,2]]}
["Instructions pour les frais de transports\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux frais de transports, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet;\n 3) Informe son coût unitaire;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des dépenses en transports est calculé automatiquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Frais de transports                       (unité)","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Voyages"]
[null,null,null,0,null,"Km voiture"]
[null,null,null,0,null,"Essence"]
[null,null,null,0,null,"Train / bus"]
[null,null,null,0,null,"Taxi"]
[null,null,null,0,null,"Services logistiques (tiers)"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Communication","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[13,0,13,2]]}
["Instructions pour les coûts de communication\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux éléments de communication, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet;\n 3) Informe son coût unitaire;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des dépenses en communication est calculé automatiquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Elément de communication                  (unité)","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Affiches"]
[null,null,null,0,null,"Brochures"]
[null,null,null,0,null,"Dépliants"]
[null,null,null,0,null,"Annonces presse"]
[null,null,null,0,null,"Annonces WEB"]
[null,null,null,0,null,"Publicité WEB"]
[null,null,null,0,null,"Site internet"]
[null,null,null,0,null,"Charte graphique"]
[null,null,null,0,null,"Services de tiers"]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Investissements","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[13,0,13,2]]}
["Instructions pour les investissements\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux investissements, les plus coûteux. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n     (Indique aussi l'unité, pour faciliter la compréhension)\n 2) Informe la quantité nécessaire durant le projet;\n 3) Informe son coût unitaire;\n 4) La colonne du coût total est calculée automatiquement.\n\nLe total des dépenses en transports est calculé automatiquement.",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Investissement                                      (unité)","Quantité","Coût unitaire","Coût total",null,"Exemples"]
[null,null,null,{"$f":"B4*C4","v":0}]
[null,null,null,{"$f":"B5*C5","v":0},null,"Ordinateurs"]
[null,null,null,0,null,"Imprimantes"]
[null,null,null,0,null,"Réseau interne, Wifi"]
[null,null,null,0,null,"Véhicules"]
[null,null,null,0,null,"Machines"]
[null,null,null,0,null,"Mobilier"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Financement","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[11,0,11,2],[12,0,12,2],[13,0,13,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[15,0,15,3],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2]]}
["Instructions pour le financement\n\nCe tableau te permet d'informer jusqu'à 10 de tes principaux éléments de financement, les plus élevés, incluant les fonds propres, les subventions, etc. Pour chacun d'entre eux:\n\n 1) Choisis dans la première colonne un des éléments suggérés ou écris ta propre définition;\n 2) Informe sa valeur;\n \nLe total des ressources de financement est calculé automatiquement.\n\n* Le bénévolat peut être valorisé comme une dépense dans les frais de personnel et\n   équilibré par un même montant dans le financement. Le calcul vient de l'onglet \"Personnel\".",null,null,null,null,"\n\nCe bouton copie le tableau en mémoire, pour l'insérer dans un autre document, par exemple texte."]
[]
["Elément de financement",null,null,"Valeur",null,"Exemples"]
[]
[null,null,null,null,null,"Fonds propres"]
[null,null,null,null,null,"Dons"]
[null,null,null,null,null,"Legs"]
[null,null,null,null,null,"Contre-prestations"]
[null,null,null,null,null,"Cotisations"]
[null,null,null,null,null,"Prix / concours"]
[null,null,null,null,null,"Sponsors"]
[null,null,null,null,null,"Subventions"]
["Heures de bénévolat*",null,null,{"$f":"Personnel!D13","v":0}]
["Total:",null,null,{"$f":"SUM(D4:D13)","v":0}]

{"sheet":"Résumé","index":9,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Résumé du projet\n\nLe tableau ci-dessous te montre une synthèse des totaux des tableaux dans les onglets antérieurs:\n   1) La marge brute est la différence entre les recettes et les coûts de production\n       (ou achat) des prestations produites et vendues.\n   2) Le total des charges opérationnelles est la somme totaux des tableaux des onglets\n       antérieurs liées aux dépenses dites \"fixes\"\n   3) Les investissements et les financements sont aussi pris en compte pour évaluer la \n       trésorerie finale du projet"]
[]
["Prestations"]
["Recettes variables des prestations",{"$f":"Recettes!D14","v":0}]
["Coûts variables des prestations",{"$f":"Recettes!D27","v":0}]
["Marge brute",{"$f":"B4-B5","v":0}]
[]
["Charges opérationnelles"]
["Frais de personnel (y compris les heures de bénévolat*)",{"$f":"Personnel!D14","v":0}]
["Charges d'infrastructure",{"$f":"Infrastructure!D14","v":0}]
["Frais de fonctionnement",{"$f":"Fonctionnement!D14","v":0}]
["Frais de transports",{"$f":"Transports!D14","v":0}]
["Frais de communication",{"$f":"Communication!D14","v":0}]
["Total des charges opérationnelles",{"$f":"-SUM(B9:B13)","v":0}]
[]
["Marge nette (marge brute - charges opérationnelles)",{"$f":"B6+B14","v":0}]
[]
["Investissements",{"$f":"Investissements!D14","v":0}]
["Financements (y compris les heures de bénévolat*)",{"$f":"Financement!D14","v":0}]
[]
["Trésorerie (cash flow)",{"$f":"B6+B14-B18+B19","v":0}]

{"sheet":"Projections An 1","index":10,"n_rows":151,"n_cols":18,"rows_kept":151,"cut":false,"hidden":false,"merged":[[22,0,22,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[139,0,139,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[30,0,30,2],[58,0,58,2],[134,0,134,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[145,0,145,2],[59,0,59,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,0,65,2],[66,0,66,2],[67,0,67,2],[68,0,68,2],[140,0,140,2],[141,0,141,2],[142,0,142,2],[143,0,143,2],[144,0,144,2],[150,0,150,2],[2,1,2,3],[2,5,2,17],[116,0,116,2],[149,0,149,2],[131,0,131,2],[27,0,27,2],[41,0,41,2],[43,0,43,2],[69,0,69,2],[113,0,113,2],[115,0,115,2],[135,0,135,2],[136,0,136,2],[137,0,137,2],[138,0,138,2],[103,4,112,4],[120,4,131,4],[134,4,145,4],[0,6,0,10],[58,4,69,4],[73,4,82,4],[83,4,92,4],[93,4,102,4],[3,4,13,4],[16,4,27,4],[30,4,41,4],[46,4,56,4],[0,0,0,4],[16,0,16,2],[34,0,34,2],[35,0,35,2]]}
["Instructions\nCe tableau est construit à partir des informations des tableaux antérieurs, des recettes au financement.\n\nTote modification du \"Projet pilote\" doivent être faite dans les onglets antérieurs. Ensuite il faut actualiser le tableau avec le bouton \"Rafraichir...\"; les lignes vides sont automatiquement masquées.\n\n1) Prestations: des volumes doivent être informés; recettes et coûts sont calculés\n2) Personnel: des quantités doivent être informées; les frais sont calculés\n3) Charges fixes: des valeurs financières doivent être informées\n4) Investissements: des valeurs financières doivent être informées",null,null,null,null,null,"Le bouton \"Copie le tableau\" permet ensuite de le coller dans un nouvel onglet, par exemple pour une 2ème année de projections ou de le coller dans un document texte."]
[" "]
[null,"Projet pilote",null,null,null,"Organisation ou répétition du projet durant la 1ère année"]
["Prestations et leurs volumes","Prix Unit.","Coût Unit.","Qté Initiale","Prestations","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Recettes!A4=\"\",\"\",Recettes!A4)","v":""},{"$f":"Recettes!C4","v":0},{"$f":"-Recettes!C17","v":0},{"$f":"Recettes!B4","v":0},null,null,null,null,350,null,null,400,null,null,450,null,null,{"$f":"SUM(F5:Q5)","v":1200}]
[{"$f":"IF(Recettes!A5=\"\",\"\",Recettes!A5)","v":""},{"$f":"Recettes!C5","v":0},{"$f":"-Recettes!C18","v":0},{"$f":"Recettes!B5","v":0},null,null,null,null,150,null,null,150,null,null,150,null,null,450]
[{"$f":"IF(Recettes!A6=\"\",\"\",Recettes!A6)","v":""},{"$f":"Recettes!C6","v":0},{"$f":"-Recettes!C19","v":0},{"$f":"Recettes!B6","v":0},null,null,null,null,600,null,null,700,null,null,900,null,null,2200]
[{"$f":"IF(Recettes!A7=\"\",\"\",Recettes!A7)","v":""},{"$f":"Recettes!C7","v":0},{"$f":"-Recettes!C20","v":0},{"$f":"Recettes!B7","v":0},null,null,null,null,250,null,null,300,null,null,350,null,null,900]
[{"$f":"IF(Recettes!A8=\"\",\"\",Recettes!A8)","v":""},{"$f":"Recettes!C8","v":0},{"$f":"-Recettes!C21","v":0},{"$f":"Recettes!B8","v":0},null,null,null,null,60,null,null,80,null,null,100,null,null,240]
[{"$f":"IF(Recettes!A9=\"\",\"\",Recettes!A9)","v":""},{"$f":"Recettes!C9","v":0},{"$f":"-Recettes!C22","v":0},{"$f":"Recettes!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Recettes!A10=\"\",\"\",Recettes!A10)","v":""},{"$f":"Recettes!C10","v":0},{"$f":"-Recettes!C23","v":0},{"$f":"Recettes!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Recettes!A11=\"\",\"\",Recettes!A11)","v":""},{"$f":"Recettes!C11","v":0},{"$f":"-Recettes!C24","v":0},{"$f":"Recettes!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Recettes!A12=\"\",\"\",Recettes!A12)","v":""},{"$f":"Recettes!C12","v":0},{"$f":"-Recettes!C25","v":0},{"$f":"Recettes!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Recettes!A13=\"\",\"\",Recettes!A13)","v":""},{"$f":"Recettes!C13","v":0},{"$f":"-Recettes!C26","v":0},{"$f":"Recettes!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[" "]
["Recettes (variables)"]
["Prestation",null,null,"Val. Initiale","Recettes","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Recettes!A4=\"\",\"\",Recettes!A4)","v":""},null,null,{"$f":"D5*B5","v":0},null,{"$f":"F5*$B5","v":0},{"$f":"G5*$B5","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F18:Q18)","v":0}]
[{"$f":"IF(Recettes!A5=\"\",\"\",Recettes!A5)","v":""},null,null,0,null,0,{"$f":"G6*$B6","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A6=\"\",\"\",Recettes!A6)","v":""},null,null,0,null,0,{"$f":"G7*$B7","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A7=\"\",\"\",Recettes!A7)","v":""},null,null,0,null,0,{"$f":"G8*$B8","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A8=\"\",\"\",Recettes!A8)","v":""},null,null,0,null,0,{"$f":"G9*$B9","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A9=\"\",\"\",Recettes!A9)","v":""},null,null,0,null,0,{"$f":"G10*$B10","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A10=\"\",\"\",Recettes!A10)","v":""},null,null,0,null,0,{"$f":"G11*$B11","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A11=\"\",\"\",Recettes!A11)","v":""},null,null,0,null,0,{"$f":"G12*$B12","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A12=\"\",\"\",Recettes!A12)","v":""},null,null,0,null,0,{"$f":"G13*$B13","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A13=\"\",\"\",Recettes!A13)","v":""},null,null,0,null,0,{"$f":"G14*$B14","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Totaux:",null,null,{"$f":"SUM(D18:D27)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
["Coûts (variables)"]
["Prestation",null,null,"Val. Initiale","Coûts variables","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Recettes!A4=\"\",\"\",Recettes!A4)","v":""},null,null,{"$f":"D5*C5","v":0},null,{"$f":"F5*$C5","v":0},{"$f":"G5*$C5","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F32:Q32)","v":0}]
[{"$f":"IF(Recettes!A5=\"\",\"\",Recettes!A5)","v":""},null,null,{"$f":"D6*C6","v":0},null,{"$f":"F6*$C6","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A6=\"\",\"\",Recettes!A6)","v":""},null,null,0,null,{"$f":"F7*$C7","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A7=\"\",\"\",Recettes!A7)","v":""},null,null,0,null,{"$f":"F8*$C8","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A8=\"\",\"\",Recettes!A8)","v":""},null,null,0,null,{"$f":"F9*$C9","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A9=\"\",\"\",Recettes!A9)","v":""},null,null,0,null,{"$f":"F10*$C10","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A10=\"\",\"\",Recettes!A10)","v":""},null,null,0,null,{"$f":"F11*$C11","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A11=\"\",\"\",Recettes!A11)","v":""},null,null,0,null,{"$f":"F12*$C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A12=\"\",\"\",Recettes!A12)","v":""},null,null,0,null,{"$f":"F13*$C13","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(Recettes!A13=\"\",\"\",Recettes!A13)","v":""},null,null,0,null,{"$f":"F14*$C14","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Totaux:",null,null,{"$f":"SUM(D32:D41)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
["Marge brute",null,null,{"$f":"D28+D42","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
["Frais de personnel"]
["Eléments",null,"Coût Unit.","Qté Initiale","Personnel","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Personnel!A4=\"\",\"\",Personnel!A4)","v":""},null,{"$f":"IF(Personnel!C4=\"\",0,-Personnel!C4)","v":0},{"$f":"Personnel!B4","v":0},null,0.1,0.1,0.1,0.2,0.1,0.1,0.2,0.1,0.1,0.2,0.1,0.1,{"$f":"SUM(F48:Q48)","v":1.5}]
[{"$f":"IF(Personnel!A5=\"\",\"\",Personnel!A5)","v":""},null,{"$f":"IF(Personnel!C5=\"\",0,-Personnel!C5)","v":0},{"$f":"Personnel!B5","v":0},null,10,10,10,10,10,10,10,10,10,10,10,10,120]
[{"$f":"IF(Personnel!A6=\"\",\"\",Personnel!A6)","v":""},null,{"$f":"IF(Personnel!C6=\"\",0,-Personnel!C6)","v":0},{"$f":"Personnel!B6","v":0},null,null,null,null,50,null,null,80,null,null,100,null,null,230]
[{"$f":"IF(Personnel!A7=\"\",\"\",Personnel!A7)","v":""},null,{"$f":"IF(Personnel!C7=\"\",0,-Personnel!C7)","v":0},{"$f":"Personnel!B7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A8=\"\",\"\",Personnel!A8)","v":""},null,{"$f":"IF(Personnel!C8=\"\",0,-Personnel!C8)","v":0},{"$f":"Personnel!B8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A9=\"\",\"\",Personnel!A9)","v":""},null,{"$f":"IF(Personnel!C9=\"\",0,-Personnel!C9)","v":0},{"$f":"Personnel!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A10=\"\",\"\",Personnel!A10)","v":""},null,{"$f":"IF(Personnel!C10=\"\",0,-Personnel!C10)","v":0},{"$f":"Personnel!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A11=\"\",\"\",Personnel!A11)","v":""},null,{"$f":"IF(Personnel!C11=\"\",0,-Personnel!C11)","v":0},{"$f":"Personnel!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A12=\"\",\"\",Personnel!A12)","v":""},null,{"$f":"IF(Personnel!C12=\"\",0,-Personnel!C12)","v":0},{"$f":"Personnel!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Personnel!A13=\"\",\"\",Personnel!A13)","v":"Heures de bénévolat*"},null,{"$f":"IF(Personnel!C13=\"\",0,-Personnel!C13)","v":0},100,null,30,30,30,200,30,30,300,30,30,300,30,30,1070]
[" "]
["Frais",null,null," Val. Initiale","Personnel","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"A48","v":""},null,null,{"$f":"D48*C48","v":0},null,{"$f":"F48*$C48","v":0},{"$f":"G48*$C48","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F60:Q60)","v":0}]
["",null,null,{"$f":"D49*C49","v":0},null,{"$f":"F49*$C49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F50*$C50","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F51*$C51","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F52*$C52","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F53*$C53","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F54*$C54","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F55*$C55","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["",null,null,0,null,{"$f":"F56*$C56","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Heures de bénévolat*",null,null,0,null,{"$f":"F57*$C57","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Totaux:",null,null,{"$f":"SUM(D60:D69)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
["Charges fixes"]
["Elément","Unités","Coût Unit.","Coût Initial",null,"Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Infrastructure!A4=\"\",\"\",Infrastructure!A4)","v":""},{"$f":"IF(Infrastructure!A4=\"\",0,Infrastructure!B4)","v":0},{"$f":"IF(Infrastructure!A4=\"\",0,-Infrastructure!C4)","v":0},{"$f":"IF(Infrastructure!A4=\"\",0,-Infrastructure!D4)","v":0},"Infrastructure",null,null,null,250,null,null,250,null,null,250,null,null,{"$f":"-SUM(F74:Q74)","v":-750}]
[{"$f":"IF(Infrastructure!A5=\"\",\"\",Infrastructure!A5)","v":""},{"$f":"IF(Infrastructure!A5=\"\",0,Infrastructure!B5)","v":0},{"$f":"IF(Infrastructure!A5=\"\",0,-Infrastructure!C5)","v":0},{"$f":"IF(Infrastructure!A5=\"\",0,-Infrastructure!D5)","v":0},null,50,50,50,50,50,50,50,50,50,50,50,50,{"$f":"-SUM(F75:Q75)","v":-600}]
[{"$f":"IF(Infrastructure!A6=\"\",\"\",Infrastructure!A6)","v":""},{"$f":"IF(Infrastructure!A6=\"\",0,Infrastructure!B6)","v":0},{"$f":"IF(Infrastructure!A6=\"\",0,-Infrastructure!C6)","v":0},{"$f":"IF(Infrastructure!A6=\"\",0,-Infrastructure!D6)","v":0},null,100,100,100,100,100,100,100,100,100,100,100,100,-1200]
[{"$f":"IF(Infrastructure!A7=\"\",\"\",Infrastructure!A7)","v":""},{"$f":"IF(Infrastructure!A7=\"\",0,Infrastructure!B7)","v":0},{"$f":"IF(Infrastructure!A7=\"\",0,-Infrastructure!C7)","v":0},{"$f":"IF(Infrastructure!A7=\"\",0,-Infrastructure!D7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A8=\"\",\"\",Infrastructure!A8)","v":""},{"$f":"IF(Infrastructure!A8=\"\",0,Infrastructure!B8)","v":0},{"$f":"IF(Infrastructure!A8=\"\",0,-Infrastructure!C8)","v":0},{"$f":"IF(Infrastructure!A8=\"\",0,-Infrastructure!D8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A9=\"\",\"\",Infrastructure!A9)","v":""},{"$f":"IF(Infrastructure!A9=\"\",0,Infrastructure!B9)","v":0},{"$f":"IF(Infrastructure!A9=\"\",0,-Infrastructure!C9)","v":0},{"$f":"IF(Infrastructure!A9=\"\",0,-Infrastructure!D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A10=\"\",\"\",Infrastructure!A10)","v":""},{"$f":"IF(Infrastructure!A10=\"\",0,Infrastructure!B10)","v":0},{"$f":"IF(Infrastructure!A10=\"\",0,-Infrastructure!C10)","v":0},{"$f":"IF(Infrastructure!A10=\"\",0,-Infrastructure!D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A11=\"\",\"\",Infrastructure!A11)","v":""},{"$f":"IF(Infrastructure!A11=\"\",0,Infrastructure!B11)","v":0},{"$f":"IF(Infrastructure!A11=\"\",0,-Infrastructure!C11)","v":0},{"$f":"IF(Infrastructure!A11=\"\",0,-Infrastructure!D11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A12=\"\",\"\",Infrastructure!A12)","v":""},{"$f":"IF(Infrastructure!A12=\"\",0,Infrastructure!B12)","v":0},{"$f":"IF(Infrastructure!A12=\"\",0,-Infrastructure!C12)","v":0},{"$f":"IF(Infrastructure!A12=\"\",0,-Infrastructure!D12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Infrastructure!A13=\"\",\"\",Infrastructure!A13)","v":""},{"$f":"IF(Infrastructure!A13=\"\",0,Infrastructure!B13)","v":0},{"$f":"IF(Infrastructure!A13=\"\",0,-Infrastructure!C13)","v":0},{"$f":"IF(Infrastructure!A13=\"\",0,-Infrastructure!D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A4=\"\",\"\",Fonctionnement!A4)","v":""},{"$f":"IF(Fonctionnement!A4=\"\",0,Fonctionnement!B4)","v":0},{"$f":"IF(Fonctionnement!A4=\"\",0,-Fonctionnement!C4)","v":0},{"$f":"IF(Fonctionnement!A4=\"\",0,-Fonctionnement!D4)","v":0},"Fonctionnement",null,null,200,null,null,250,null,null,300,null,null,null,-750]
[{"$f":"IF(Fonctionnement!A5=\"\",\"\",Fonctionnement!A5)","v":""},{"$f":"IF(Fonctionnement!A5=\"\",0,Fonctionnement!B5)","v":0},{"$f":"IF(Fonctionnement!A5=\"\",0,-Fonctionnement!C5)","v":0},{"$f":"IF(Fonctionnement!A5=\"\",0,-Fonctionnement!D5)","v":0},null,60,60,60,60,60,60,60,60,60,60,60,60,-720]
[{"$f":"IF(Fonctionnement!A6=\"\",\"\",Fonctionnement!A6)","v":""},{"$f":"IF(Fonctionnement!A6=\"\",0,Fonctionnement!B6)","v":0},{"$f":"IF(Fonctionnement!A6=\"\",0,-Fonctionnement!C6)","v":0},{"$f":"IF(Fonctionnement!A6=\"\",0,-Fonctionnement!D6)","v":0},null,12,12,100,12,12,100,12,12,100,12,12,12,-408]
[{"$f":"IF(Fonctionnement!A7=\"\",\"\",Fonctionnement!A7)","v":""},{"$f":"IF(Fonctionnement!A7=\"\",0,Fonctionnement!B7)","v":0},{"$f":"IF(Fonctionnement!A7=\"\",0,-Fonctionnement!C7)","v":0},{"$f":"IF(Fonctionnement!A7=\"\",0,-Fonctionnement!D7)","v":0},null,null,null,null,200,null,null,300,null,null,400,null,null,-900]
[{"$f":"IF(Fonctionnement!A8=\"\",\"\",Fonctionnement!A8)","v":""},{"$f":"IF(Fonctionnement!A8=\"\",0,Fonctionnement!B8)","v":0},{"$f":"IF(Fonctionnement!A8=\"\",0,-Fonctionnement!C8)","v":0},{"$f":"IF(Fonctionnement!A8=\"\",0,-Fonctionnement!D8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A9=\"\",\"\",Fonctionnement!A9)","v":""},{"$f":"IF(Fonctionnement!A9=\"\",0,Fonctionnement!B9)","v":0},{"$f":"IF(Fonctionnement!A9=\"\",0,-Fonctionnement!C9)","v":0},{"$f":"IF(Fonctionnement!A9=\"\",0,-Fonctionnement!D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A10=\"\",\"\",Fonctionnement!A10)","v":""},{"$f":"IF(Fonctionnement!A10=\"\",0,Fonctionnement!B10)","v":0},{"$f":"IF(Fonctionnement!A10=\"\",0,-Fonctionnement!C10)","v":0},{"$f":"IF(Fonctionnement!A10=\"\",0,-Fonctionnement!D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A11=\"\",\"\",Fonctionnement!A11)","v":""},{"$f":"IF(Fonctionnement!A11=\"\",0,Fonctionnement!B11)","v":0},{"$f":"IF(Fonctionnement!A11=\"\",0,-Fonctionnement!C11)","v":0},{"$f":"IF(Fonctionnement!A11=\"\",0,-Fonctionnement!D11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A12=\"\",\"\",Fonctionnement!A12)","v":""},{"$f":"IF(Fonctionnement!A12=\"\",0,Fonctionnement!B12)","v":0},{"$f":"IF(Fonctionnement!A12=\"\",0,-Fonctionnement!C12)","v":0},{"$f":"IF(Fonctionnement!A12=\"\",0,-Fonctionnement!D12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Fonctionnement!A13=\"\",\"\",Fonctionnement!A13)","v":""},{"$f":"IF(Fonctionnement!A13=\"\",0,Fonctionnement!B13)","v":0},{"$f":"IF(Fonctionnement!A13=\"\",0,-Fonctionnement!C13)","v":0},{"$f":"IF(Fonctionnement!A13=\"\",0,-Fonctionnement!D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A4=\"\",\"\",Transports!A4)","v":""},{"$f":"IF(Transports!A4=\"\",0,Transports!B4)","v":0},{"$f":"IF(Transports!A4=\"\",0,-Transports!C4)","v":0},{"$f":"IF(Transports!A4=\"\",0,-Transports!D4)","v":0},"Transports",35,35,35,35,35,35,35,35,35,35,35,35,-420]
[{"$f":"IF(Transports!A5=\"\",\"\",Transports!A5)","v":""},{"$f":"IF(Transports!A5=\"\",0,Transports!B5)","v":0},{"$f":"IF(Transports!A5=\"\",0,-Transports!C5)","v":0},{"$f":"IF(Transports!A5=\"\",0,-Transports!D5)","v":0},null,100,100,100,200,100,100,200,100,100,200,100,100,-1500]
[{"$f":"IF(Transports!A6=\"\",\"\",Transports!A6)","v":""},{"$f":"IF(Transports!A6=\"\",0,Transports!B6)","v":0},{"$f":"IF(Transports!A6=\"\",0,-Transports!C6)","v":0},{"$f":"IF(Transports!A6=\"\",0,-Transports!D6)","v":0},null,60,60,120,60,60,120,60,60,120,60,60,120,-960]
[{"$f":"IF(Transports!A7=\"\",\"\",Transports!A7)","v":""},{"$f":"IF(Transports!A7=\"\",0,Transports!B7)","v":0},{"$f":"IF(Transports!A7=\"\",0,-Transports!C7)","v":0},{"$f":"IF(Transports!A7=\"\",0,-Transports!D7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A8=\"\",\"\",Transports!A8)","v":""},{"$f":"IF(Transports!A8=\"\",0,Transports!B8)","v":0},{"$f":"IF(Transports!A8=\"\",0,-Transports!C8)","v":0},{"$f":"IF(Transports!A8=\"\",0,-Transports!D8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A9=\"\",\"\",Transports!A9)","v":""},{"$f":"IF(Transports!A9=\"\",0,Transports!B9)","v":0},{"$f":"IF(Transports!A9=\"\",0,-Transports!C9)","v":0},{"$f":"IF(Transports!A9=\"\",0,-Transports!D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A10=\"\",\"\",Transports!A10)","v":""},{"$f":"IF(Transports!A10=\"\",0,Transports!B10)","v":0},{"$f":"IF(Transports!A10=\"\",0,-Transports!C10)","v":0},{"$f":"IF(Transports!A10=\"\",0,-Transports!D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A11=\"\",\"\",Transports!A11)","v":""},{"$f":"IF(Transports!A11=\"\",0,Transports!B11)","v":0},{"$f":"IF(Transports!A11=\"\",0,-Transports!C11)","v":0},{"$f":"IF(Transports!A11=\"\",0,-Transports!D11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A12=\"\",\"\",Transports!A12)","v":""},{"$f":"IF(Transports!A12=\"\",0,Transports!B12)","v":0},{"$f":"IF(Transports!A12=\"\",0,-Transports!C12)","v":0},{"$f":"IF(Transports!A12=\"\",0,-Transports!D12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Transports!A13=\"\",\"\",Transports!A13)","v":""},{"$f":"IF(Transports!A13=\"\",0,Transports!B13)","v":0},{"$f":"IF(Transports!A13=\"\",0,-Transports!C13)","v":0},{"$f":"IF(Transports!A13=\"\",0,-Transports!D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A4=\"\",\"\",Communication!A4)","v":""},{"$f":"IF(Communication!A4=\"\",0,Communication!B4)","v":0},{"$f":"IF(Communication!A4=\"\",0,-Communication!C4)","v":0},{"$f":"IF(Communication!A4=\"\",0,-Communication!D4)","v":0},"Communication",null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A5=\"\",\"\",Communication!A5)","v":""},{"$f":"IF(Communication!A5=\"\",0,Communication!B5)","v":0},{"$f":"IF(Communication!A5=\"\",0,-Communication!C5)","v":0},{"$f":"IF(Communication!A5=\"\",0,-Communication!D5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A6=\"\",\"\",Communication!A6)","v":""},{"$f":"IF(Communication!A6=\"\",0,Communication!B6)","v":0},{"$f":"IF(Communication!A6=\"\",0,-Communication!C6)","v":0},{"$f":"IF(Communication!A6=\"\",0,-Communication!D6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A7=\"\",\"\",Communication!A7)","v":""},{"$f":"IF(Communication!A7=\"\",0,Communication!B7)","v":0},{"$f":"IF(Communication!A7=\"\",0,-Communication!C7)","v":0},{"$f":"IF(Communication!A7=\"\",0,-Communication!D7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A8=\"\",\"\",Communication!A8)","v":""},{"$f":"IF(Communication!A8=\"\",0,Communication!B8)","v":0},{"$f":"IF(Communication!A8=\"\",0,-Communication!C8)","v":0},{"$f":"IF(Communication!A8=\"\",0,-Communication!D8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A9=\"\",\"\",Communication!A9)","v":""},{"$f":"IF(Communication!A9=\"\",0,Communication!B9)","v":0},{"$f":"IF(Communication!A9=\"\",0,-Communication!C9)","v":0},{"$f":"IF(Communication!A9=\"\",0,-Communication!D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A10=\"\",\"\",Communication!A10)","v":""},{"$f":"IF(Communication!A10=\"\",0,Communication!B10)","v":0},{"$f":"IF(Communication!A10=\"\",0,-Communication!C10)","v":0},{"$f":"IF(Communication!A10=\"\",0,-Communication!D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A11=\"\",\"\",Communication!A11)","v":""},{"$f":"IF(Communication!A11=\"\",0,Communication!B11)","v":0},{"$f":"IF(Communication!A11=\"\",0,-Communication!C11)","v":0},{"$f":"IF(Communication!A11=\"\",0,-Communication!D11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A12=\"\",\"\",Communication!A12)","v":""},{"$f":"IF(Communication!A12=\"\",0,Communication!B12)","v":0},{"$f":"IF(Communication!A12=\"\",0,-Communication!C12)","v":0},{"$f":"IF(Communication!A12=\"\",0,-Communication!D12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Communication!A13=\"\",\"\",Communication!A13)","v":""},{"$f":"IF(Communication!A13=\"\",0,Communication!B13)","v":0},{"$f":"IF(Communication!A13=\"\",0,-Communication!C13)","v":0},{"$f":"IF(Communication!A13=\"\",0,-Communication!D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Totaux:",null,null,{"$f":"SUM(D74:D113)","v":0},null,{"$f":"-SUM(F74:F113)","v":-417},-417,-765,-967,-417,-815,-1067,-417,-865,-1167,-417,-477,{"$f":"SUM(F114:Q114)","v":-8208}]
[" "]
["Total des charges opérationnelles",null,null,{"$f":"D70+D114","v":0},null,{"$f":"F70+F114","v":-417},-417,-765,-967,-417,-815,-1067,-417,-865,-1167,-417,-477,-8208]
["Marge nette (marge brute b-charges opérationnelles)",null,null,{"$f":"D44+D116","v":0},null,{"$f":"F44+F116","v":-417},-417,-765,-967,-417,-815,-1067,-417,-865,-1167,-417,-477,-8208]
[]
[" "]
["Investissements"]
["Elément d'investissement","Unités","Coût Unit.","Coût Initial","Investissements","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Investissements!A4=\"\",\"\",Investissements!A4)","v":""},{"$f":"IF(Investissements!A4=\"\",0,Investissements!B4)","v":0},{"$f":"IF(Investissements!A4=\"\",0,-Investissements!C4)","v":0},{"$f":"IF(Investissements!A4=\"\",0,-Investissements!D4)","v":0},null,null,null,null,null,null,2000,null,null,null,null,null,null,{"$f":"-SUM(F122:Q122)","v":-2000}]
[{"$f":"IF(Investissements!A5=\"\",\"\",Investissements!A5)","v":""},{"$f":"IF(Investissements!A5=\"\",0,Investissements!B5)","v":0},{"$f":"IF(Investissements!A5=\"\",0,-Investissements!C5)","v":0},{"$f":"IF(Investissements!A5=\"\",0,-Investissements!D5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-SUM(F123:Q123)","v":0}]
[{"$f":"IF(Investissements!A6=\"\",\"\",Investissements!A6)","v":""},{"$f":"IF(Investissements!A6=\"\",0,Investissements!B6)","v":0},{"$f":"IF(Investissements!A6=\"\",0,-Investissements!C6)","v":0},{"$f":"IF(Investissements!A6=\"\",0,-Investissements!D6)","v":0},null,null,null,120,null,null,120,null,null,120,null,null,120,-480]
[{"$f":"IF(Investissements!A7=\"\",\"\",Investissements!A7)","v":""},{"$f":"IF(Investissements!A7=\"\",0,Investissements!B7)","v":0},{"$f":"IF(Investissements!A7=\"\",0,-Investissements!C7)","v":0},{"$f":"IF(Investissements!A7=\"\",0,-Investissements!D7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A8=\"\",\"\",Investissements!A8)","v":""},{"$f":"IF(Investissements!A8=\"\",0,Investissements!B8)","v":0},{"$f":"IF(Investissements!A8=\"\",0,-Investissements!C8)","v":0},{"$f":"IF(Investissements!A8=\"\",0,-Investissements!D8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A9=\"\",\"\",Investissements!A9)","v":""},{"$f":"IF(Investissements!A9=\"\",0,Investissements!B9)","v":0},{"$f":"IF(Investissements!A9=\"\",0,-Investissements!C9)","v":0},{"$f":"IF(Investissements!A9=\"\",0,-Investissements!D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A10=\"\",\"\",Investissements!A10)","v":""},{"$f":"IF(Investissements!A10=\"\",0,Investissements!B10)","v":0},{"$f":"IF(Investissements!A10=\"\",0,-Investissements!C10)","v":0},{"$f":"IF(Investissements!A10=\"\",0,-Investissements!D10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A11=\"\",\"\",Investissements!A11)","v":""},{"$f":"IF(Investissements!A11=\"\",0,Investissements!B11)","v":0},{"$f":"IF(Investissements!A11=\"\",0,-Investissements!C11)","v":0},{"$f":"IF(Investissements!A11=\"\",0,-Investissements!D11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A12=\"\",\"\",Investissements!A12)","v":""},{"$f":"IF(Investissements!A12=\"\",0,Investissements!B12)","v":0},{"$f":"IF(Investissements!A12=\"\",0,-Investissements!C12)","v":0},{"$f":"IF(Investissements!A12=\"\",0,-Investissements!D12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Investissements!A13=\"\",\"\",Investissements!A13)","v":""},{"$f":"IF(Investissements!A13=\"\",0,Investissements!B13)","v":0},{"$f":"IF(Investissements!A13=\"\",0,-Investissements!C13)","v":0},{"$f":"IF(Investissements!A13=\"\",0,-Investissements!D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Totaux:",null,null,{"$f":"SUM(D122:D131)","v":0},null,{"$f":"-SUM(F122:F131)","v":0},0,-120,0,0,-2120,0,0,-120,0,0,-120,{"$f":"SUM(F132:Q132)","v":-2480}]
[" "]
["Financement"]
["Eléments de financement",null,null,"Valeur","Financement","Mois 1","Mois 2","Mois 3","Mois 4","Mois 5","Mois 6","Mois 7","Mois 8","Mois 9","Mois 10","Mois 11","Mois 12","Total année"]
[{"$f":"IF(Financement!A4=\"\",\"\",Financement!A4)","v":""},null,null,{"$f":"IF(Financement!A4=\"\",\"\",Financement!D4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F136:Q136)","v":0}]
[{"$f":"IF(Financement!A5=\"\",\"\",Financement!A5)","v":""},null,null,{"$f":"IF(Financement!A5=\"\",\"\",Financement!D5)","v":""},null,null,null,null,500,null,null,500,null,null,500,null,null,1500]
[{"$f":"IF(Financement!A6=\"\",\"\",Financement!A6)","v":""},null,null,{"$f":"IF(Financement!A6=\"\",\"\",Financement!D6)","v":""},null,null,null,null,1500,null,null,2000,null,null,1000,null,null,4500]
[{"$f":"IF(Financement!A7=\"\",\"\",Financement!A7)","v":""},null,null,{"$f":"IF(Financement!A7=\"\",\"\",Financement!D7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A8=\"\",\"\",Financement!A8)","v":""},null,null,{"$f":"IF(Financement!A8=\"\",\"\",Financement!D8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A9=\"\",\"\",Financement!A9)","v":""},null,null,{"$f":"IF(Financement!A9=\"\",\"\",Financement!D9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A10=\"\",\"\",Financement!A10)","v":""},null,null,{"$f":"IF(Financement!A10=\"\",\"\",Financement!D10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A11=\"\",\"\",Financement!A11)","v":""},null,null,{"$f":"IF(Financement!A11=\"\",\"\",Financement!D11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A12=\"\",\"\",Financement!A12)","v":""},null,null,{"$f":"IF(Financement!A12=\"\",\"\",Financement!D12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(Financement!A13=\"\",\"\",Financement!A13)","v":"Heures de bénévolat*"},null,null,{"$f":"IF(Financement!A13=\"\",\"\",Financement!D13)","v":0},null,{"$f":"-F69","v":0},{"$f":"-G69","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Totaux:",null,null,{"$f":"SUM(D136:D145)","v":0},null,0,0,0,2000,0,0,2500,0,0,1500,0,0,6000]
[]
[" "]
["Résultats"]
["Bénéfice/Perte du projet pilote ou mensuel:",null,null,{"$f":"D44+D116+D132+D146","v":0},null,{"$f":"F44+F116+F132+F146","v":-417},-417,-885,1033,-417,-2935,1433,-417,-985,333,-417,-597,-4688]
["Trésorerie (Cash flow):",null,null,{"$f":"D150","v":0},null,{"$f":"D151+F150","v":-417},{"$f":"F151+G150","v":-834},{"$f":"G151+H150","v":-1719},-686,-1103,-4038,-2605,-3022,-4007,-3674,-4091,-4688,-9376]