{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1904"}

{"sheet":"Tabelle1","index":0,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[3,2,3,4],[4,2,4,4],[5,2,5,4],[46,0,46,2],[48,0,48,2],[34,4,39,4],[24,0,24,5],[23,0,23,2],[27,0,27,2],[29,0,29,2],[25,0,25,2],[32,0,32,2],[25,3,25,5],[27,4,30,4],[8,0,8,2],[9,0,9,2],[32,3,32,5],[39,0,39,2],[43,0,43,2],[69,0,69,2],[71,0,71,2],[47,0,47,2],[68,4,75,4],[67,0,67,5],[40,0,40,5],[49,0,49,5],[50,3,50,5],[52,0,52,2],[54,0,54,2],[56,0,56,5],[58,0,58,2],[57,3,57,5],[78,4,81,4],[80,0,80,3],[73,0,73,2],[72,0,72,2],[77,0,77,5],[55,0,55,2],[76,0,76,5],[75,0,75,2],[74,0,74,2],[57,0,57,2],[60,0,60,2],[82,0,82,5],[78,0,78,2],[79,0,79,2],[81,0,81,2],[42,0,42,2],[42,3,42,5],[63,0,63,5],[43,4,48,4],[59,0,59,2],[58,4,62,4],[62,0,62,2],[44,0,44,2],[53,0,53,2],[61,0,61,3],[51,4,55,4],[51,0,51,2],[10,0,10,2],[14,4,18,4],[14,0,14,2],[16,0,16,2],[12,3,12,5],[19,0,19,5],[20,3,20,5],[64,3,64,5],[12,0,12,2],[64,0,64,2],[28,0,28,2],[45,0,45,2],[30,0,30,2],[31,0,31,5],[34,0,34,2],[35,0,35,2],[36,0,36,2],[38,0,38,2],[37,0,37,2],[21,4,23,4],[50,0,50,2],[41,0,41,5],[66,0,66,2],[0,0,0,2],[1,0,1,5],[66,4,66,5],[0,3,0,5],[17,0,17,2],[65,0,65,2],[65,4,65,5],[7,0,7,5],[2,1,2,2],[18,0,18,2],[22,0,22,2],[11,0,11,5],[15,0,15,2],[20,0,20,2]]}
["Budget de camp\n     "]
[]
["Camp",null,null,null,"Nombre de jours:",0]
["Direction:",0,"Participants en âge J+S:",null,null,0]
["Cuisine: ",0,"Participants plus jeunes/âgés:",null,null,0,{"$nulls":5}," "]
["Accompagnants:",0,"Nombre total de personnes:",null,null,{"$f":"SUM(B4+B5+B6+F4+F5)","v":0}]
[]
["Dépenses"]
["Reconnaissance",null,null,"Budget:",null,"Décompte:",null,"Différence:"]
["Voyage, nourriture",{"$nulls":6},{"$f":"D10-F10","v":0}]
["Total intermédiaire Reconnaissance",null,null,{"$f":"SUM(D10:D10)","v":0},null,{"$f":"SUM(F10:F10)","v":0},null,{"$f":"D11-F11","v":0}]
[]
["Hébergement"]
["Francs par personne/nuit:",null,0]
["Loyer bâtiment de logement/place de camp",null,null,{"$f":"SUM(C14*F6*F3)","v":0},null,null,null,{"$f":"D15-F15","v":0}]
["Charges (électricité, bois, chauffage, etc.)",{"$nulls":6},{"$f":"D16-F16","v":0}]
["Taxe de séjour",{"$nulls":6},{"$f":"D17-F17","v":0}]
["Dégâts (p. ex. vaisselle) env. 2% de la location",null,null,{"$f":"0.02*D15","v":0},null,null,null,{"$f":"D18-F18","v":0}]
["Total intermédiaire Hébergement ",null,null,{"$f":"SUM(D15:D18)","v":0},null,{"$f":"SUM(F15:F18)","v":0},null,{"$f":"D19-F19","v":0}]
[]
["Nourriture"]
["Francs par personne/jour:",null,0]
["Calcul: francs par personne/jour x nombre de personnes x nombre de jours de camp",null,null,{"$f":"SUM(C22*F6*F3)","v":0},null,null,null,{"$f":"D23-F23","v":0}]
["Total intermédiaire Nourriture",null,null,{"$f":"SUM(D23:D23)","v":0},null,{"$f":"SUM(F23)","v":0},null,{"$f":"D24-F24","v":0}]
[]
["Transport et voyage"]
["Francs par personne:",null,0]
["Billet collectif",null,null,{"$f":"SUM(C27*F6)","v":0},null,null,null,{"$f":"D28-F28","v":0}]
["Transports extraordinaires",{"$nulls":6},{"$f":"D29-F29","v":0}]
["Transport du matériel, chauffeur",{"$nulls":6},{"$f":"D30-F30","v":0}]
["Total intermédiaire Transport et voyage",null,null,{"$f":"SUM(D28:D30)","v":0},null,{"$f":"SUM(F28:F30)","v":0},null,{"$f":"D31-F31","v":0}]
[]
["Programme"]
["Francs par personne:",null,0]
["Entrées piscine, musée, etc.",null,null,{"$f":"SUM(C34*F6)","v":0},null,null,null,{"$f":"D35-F35","v":0}]
["Frais d'utilisation des halles de gymnastique, etc.",{"$nulls":6},0]
["Excursions",{"$nulls":6},0]
["Prix pour des concours",{"$nulls":6},0]
["Films, projecteur",{"$nulls":6},0]
["Total intermédiaire Programme",null,null,{"$f":"SUM(D35:D39)","v":0},null,{"$f":"SUM(F35:F39)","v":0},null,0]
[]
[]
["Matériel"]
["Matériel courant",{"$nulls":6},{"$f":"D44-F44","v":0}]
["Matériel de jeu et de bricolage",{"$nulls":6},0]
["Pharmacie",{"$nulls":6},0]
["Réparations et remplacement",{"$nulls":6},0]
["Reddition du matériel J+S (cf. Aide-mémoire J+S)",{"$nulls":6},0]
["Total intermédiaire Matériel",null,null,{"$f":"SUM(D44:D48)","v":0},null,{"$f":"SUM(F44:F48)","v":0},null,0]
[]
["Organisation"]
["Affranchissements, frais de téléphone",{"$nulls":6},{"$f":"D52-F52","v":0}]
["Photocopies, etc.",{"$nulls":6},{"$f":"D53-F53","v":0}]
["Indemnisation moniteurs/cuisine",{"$nulls":6},{"$f":"D54-F54","v":0}]
["Cadeaux, pourboires",{"$nulls":6},{"$f":"D55-F55","v":0}]
["Total intermédiaire Organisation",null,null,{"$f":"SUM(D52:D55)","v":0},null,{"$f":"SUM(F52:F55)","v":0},null,{"$f":"D56-F56","v":0}]
[]
["Evaluation du camp"]
["Soirée des parents",{"$nulls":6},{"$f":"D59-F59","v":0}]
["Week-end de clôture des moniteurs",{"$nulls":6},{"$f":"D60-F60","v":0}]
["Total intermédiaire Evaluation du camp",null,null,{"$f":"SUM(D59:D60)","v":0},null,{"$f":"SUM(F59:F60)","v":0},null,{"$f":"D61-F61","v":0}]
[]
["Total intermédiaire Dépenses ",null,null,{"$f":"SUM(D11,D19,D24,D31,D40,D49,D56,D61)","v":0},null,{"$f":"SUM(F11,F19,F24,F31,F40,F49,F56,F61)","v":0},null,{"$f":"D63-F63","v":0}]
[]
["Imprévus"]
["Env. 5% des dépenses du camp",null,null,{"$f":"0.05*D63","v":0}]
["Total Dépenses ",null,null,{"$f":"D63+D66","v":0}]
["Recettes"]
["Cotisation des participants",null,0,{"$f":"C69*(F4+F5)","v":0},null,null,null,{"$f":"D69-F69","v":0}]
["Cotisation de l'équipe de moniteurs",{"$nulls":6},0]
["Subside J+S par part./jour:",null,0,{"$f":"C71*(F4)*F3","v":0},null,null,null,0]
["Subsides des communes, des écoles, de l'église, etc.",{"$nulls":6},0]
["Subsides de voilà ",{"$nulls":6},0]
["Campagnes financières",{"$nulls":6},0]
["Dons",{"$nulls":6},0]
["Total Recettes ",null,null,{"$f":"SUM(D69:D75)","v":0},null,{"$f":"SUM(F69:F75)","v":0},null,0]
[]
["Bilan"]
["Total Recettes",null,null,{"$f":"D76","v":0},null,{"$f":"F76","v":0},null,{"$f":"D79-F79","v":0}]
["Total Dépenses",null,null,{"$f":"D67","v":0},null,{"$f":"F63","v":0},null,{"$f":"D80-F80","v":0}]
[]
["Excédent/Déficit ",null,null,{"$f":"D79-D80","v":0},null,{"$f":"F79-F80","v":0},null,{"$f":"D82-F82","v":0}]