{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Comptes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Budget","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,4,31,6],[25,0,25,1],[29,0,29,1],[9,4,9,5],[14,4,14,5],[19,4,19,5],[19,0,19,1],[7,0,7,2],[2,1,2,2],[1,1,1,2],[7,4,7,6],[14,0,14,1],[3,1,3,2],[5,1,5,2],[4,1,4,2],[9,0,9,1]]}
["Annexe 1: BUDGET (modèle à modifier en fonction de votre projet)"]
["Nom du projet "]
["Nom de l'organisme responsable"]
["Total des dépenses",{"$f":"SUM(C10,C15,C20,C26,C30)","v":0}]
["Total des recettes",{"$f":"SUM(G10,G15,G20)","v":0}]
["Bénéfice ou déficit",{"$f":"B5-B4","v":0}]
[]
["Dépenses",null,null,null,"Recettes "]
["Type de charges","Description détaillée","Montant en CHF",null,"Types de recettes","Description détaillée","Montant en CHF"]
["Charges de personnel (salaires et honoraires)",null,{"$f":"SUM(C11:C14)","v":0},null,"Contributions propres",null,{"$f":"SUM(G11:G14)","v":0}]
["Travail bénévole (25.-/heure/personne)",null,0,null,"Financement propre",null,0]
[null,null,0,null,"Travail bénévole ( = Dépenses)",null,0]
[null,null,0,null,"Matériel et infrastructure (locaux, …)",null,0]
[null,null,0,null,null,null,0]
["Coûts d'infrastructure (locations, téléphone,…)",null,{"$f":"SUM(C16:C19)","v":0},null,"Recettes espérées (ventes, entrées, inscriptions, ...)",null,{"$f":"SUM(G16:G19)","v":0}]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Frais de mise en œuvre (achat de mat., nourriture, …)",null,{"$f":"SUM(C21:C25)","v":0},null,"Contributions de tiers (sollicitées ou assurées)",null,{"$f":"SUM(G21:G25)","v":0}]
[null,null,0,null,"Subvention OPFE",null,0]
[null,null,0,null,"Autre(s) service(s) de l'Etat",null,0]
[null,null,0,null,"Commune(s)",null,0]
[null,null,0,null,"Confédération",null,0]
[null,null,0,null,"Privés (fondations, associations, autres organisations)",null,0]
["Travail de comm. (graphisme, imprimés., photocopies …)",null,{"$f":"SUM(C27:C29)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
["Frais divers",null,{"$f":"SUM(C31:C33)","v":0}]
[null,null,0,null,"Les montants sont indiqués en CHF"]
[null,null,0]
[null,null,0]

{"sheet":"Comptes","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,4,31,6],[4,1,4,2],[5,1,5,2],[3,1,3,2],[1,1,1,2],[2,1,2,2],[7,0,7,2],[3,5,3,6],[4,5,4,6],[1,5,1,6],[2,5,2,6],[7,4,7,6]]}
["Annexe 2: COMPTES (modèle à modifier en fonction de votre projet)"]
["Nom du projet ",{"$f":"IF(Budget!B2=\"\",\"\",Budget!B2)","v":""},null,null,"Total des dépenses au budget",{"$f":"IF(Budget!B4=\"\",\"\",Budget!B4)","v":0}]
["Nom de l'organisme responsable",{"$f":"IF(Budget!B3=\"\",\"\",Budget!B3)","v":""},null,null,"Total des dépenses finales",{"$f":"SUM(C10,C15,C20,C26,C30)","v":0}]
["Bénéfice ou déficit au budget",{"$f":"IF(Budget!B6=\"\",\"\",Budget!B6)","v":0},null,null,"Total des recettes au budget",{"$f":"IF(Budget!B5=\"\",\"\",Budget!B5)","v":0}]
["Bénéfice ou déficit final",{"$f":"F5-F3","v":0},null,null,"Total des recettes finales",{"$f":"SUM(G10,G15,G20)","v":0}]
["Ecart avec le budget",{"$f":"B5-B4","v":0}]
[]
["Dépenses: combien le projet a-t-il coûté?",null,null,null,"Recettes "]
["Type de charges","Budget ","Comptes\n(dépenses réelles)",null,"Types de recettes","Budget ","Comptes \n(recettes réelles)"]
["Charges de personnel (salaires et honoraires)",{"$f":"SUM(B11:B14)","v":0},{"$f":"SUM(C11:C14)","v":0},null,"Contributions propres",{"$f":"SUM(F11:F14)","v":0},{"$f":"SUM(G11:G14)","v":0}]
["Travail bénévole (25.-/heure/personne)",{"$f":"IF(Budget!C11=\"\",\"\",Budget!C11)","v":0},0,null,"Financement propre",{"$f":"IF(Budget!G11=\"\",\"\",Budget!G11)","v":0},0]
[null,{"$f":"IF(Budget!C12=\"\",\"\",Budget!C12)","v":0},0,null,"Travail bénévole ( = Dépenses)",{"$f":"IF(Budget!G12=\"\",\"\",Budget!G12)","v":0},0]
[null,{"$f":"IF(Budget!C13=\"\",\"\",Budget!C13)","v":0},0,null,"Matériel et infrastructure (locaux, …)",{"$f":"IF(Budget!G13=\"\",\"\",Budget!G13)","v":0},0]
[null,{"$f":"IF(Budget!C14=\"\",\"\",Budget!C14)","v":0},0,null,null,{"$f":"IF(Budget!G14=\"\",\"\",Budget!G14)","v":0},0]
["Coûts d'infrastructure (locations, téléphone,…)",{"$f":"SUM(B16:B19)","v":0},{"$f":"SUM(C16:C19)","v":0},null,"Recettes espérées (ventes, entrées, inscriptions, ...)",{"$f":"SUM(F16:F19)","v":0},{"$f":"SUM(G16:G19)","v":0}]
[null,{"$f":"IF(Budget!C16=\"\",\"\",Budget!C16)","v":0},0,null,null,{"$f":"IF(Budget!G16=\"\",\"\",Budget!G16)","v":0},0]
[null,{"$f":"IF(Budget!C17=\"\",\"\",Budget!C17)","v":0},0,null,null,{"$f":"IF(Budget!G17=\"\",\"\",Budget!G17)","v":0},0]
[null,{"$f":"IF(Budget!C18=\"\",\"\",Budget!C18)","v":0},0,null,null,{"$f":"IF(Budget!G18=\"\",\"\",Budget!G18)","v":0},0]
[null,{"$f":"IF(Budget!C19=\"\",\"\",Budget!C19)","v":0},0,null,null,{"$f":"IF(Budget!G19=\"\",\"\",Budget!G19)","v":0},0]
["Frais de mise en œuvre (achat de mat., nourriture, …)",{"$f":"SUM(B21:B25)","v":0},{"$f":"SUM(C21:C25)","v":0},null,"Contributions de tiers (sollicitées ou assurées)",{"$f":"SUM(F21:F25)","v":0},{"$f":"SUM(G21:G25)","v":0}]
[null,{"$f":"IF(Budget!C21=\"\",\"\",Budget!C21)","v":0},0,null,"Subvention OPFE",{"$f":"IF(Budget!G21=\"\",\"\",Budget!G21)","v":0},0]
[null,{"$f":"IF(Budget!C22=\"\",\"\",Budget!C22)","v":0},0,null,"Autre(s) service(s) de l'Etat",{"$f":"IF(Budget!G22=\"\",\"\",Budget!G22)","v":0},0]
[null,{"$f":"IF(Budget!C23=\"\",\"\",Budget!C23)","v":0},0,null,"Commune(s)",{"$f":"IF(Budget!G23=\"\",\"\",Budget!G23)","v":0},0]
[null,{"$f":"IF(Budget!C24=\"\",\"\",Budget!C24)","v":0},0,null,"Confédération",{"$f":"IF(Budget!G24=\"\",\"\",Budget!G24)","v":0},0]
[null,{"$f":"IF(Budget!C25=\"\",\"\",Budget!C25)","v":0},0,null,"Privés (fondations, associations, autres organisations)",{"$f":"IF(Budget!G25=\"\",\"\",Budget!G25)","v":0},0]
["Travail de comm. (graphisme, imprimés, photocopies …)",{"$f":"SUM(B27:B29)","v":0},{"$f":"SUM(C27:C29)","v":0}]
[null,{"$f":"IF(Budget!C27=\"\",\"\",Budget!C27)","v":0},0]
[null,{"$f":"IF(Budget!C28=\"\",\"\",Budget!C28)","v":0},0]
[null,{"$f":"IF(Budget!C29=\"\",\"\",Budget!C29)","v":0},0]
["Frais divers",{"$f":"SUM(B31:B33)","v":0},{"$f":"SUM(C31:C33)","v":0}]
["Déplacements",{"$f":"IF(Budget!C31=\"\",\"\",Budget!C31)","v":0},0,null,"Les montants sont indiqués en CHF"]
["Imprévus",{"$f":"IF(Budget!C32=\"\",\"\",Budget!C32)","v":0},0]
["Autres",{"$f":"IF(Budget!C33=\"\",\"\",Budget!C33)","v":0},0]