{"text_format":"3","workbook":"xls","n_sheets":14,"sheets":["Intro","Général","Rému","Loup·ves","Bâti","Budget_temps","Immo","Charges","Agri","Revenus","Accueil","Art.","Ress.","Chrono"],"not_rendered":{"charts":1,"images":1,"external_links":1,"defined_names":21,"comments":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Intro","index":0,"n_rows":45,"n_cols":19,"rows_kept":45,"merged":[[6,0,6,1],[8,1,8,8],[10,0,10,7],[11,0,11,7],[12,0,12,7],[13,0,13,7],[14,0,14,7]],"flags":["formulas_cached_only"]}
["Bienvenue dans le budget de la 10ème année de Loutopia"]
[null,"Version 11 / livre « La communauté Loutopia » (1ère édition)"]
[null,"Crédits : Audrey & Ludovic Gicquel"]
[null,"Plus d’informations sur loutopia.org"]
[]
[]
["Notice"]
[]
[null,"Les données sont à entrer  dans les cases jaunes claires"]
[{"$nulls":8},"Abréviations utilisées"]
["Vocabulaire",{"$nulls":7},"moy","moyenne",{"$nulls":7},"todo","ajouter le rabais des redev externes pour ceux qui ont bcp en CC"]
["Loup·ve : membre de la communauté",{"$nulls":7},"etp","équivalent temps plein",{"$nulls":8},"version publique"]
["Louveteau : personne en cours d’intégration de la communauté",{"$nulls":7},"HL","Habitat léger",{"$nulls":8},"colorer les chiffres général"]
["Salaire : versé par la communauté pour les Loup·ves qui travaillent à temps plein (Internes)",{"$nulls":7},"CA","Chiffre d’affaire"]
["Redevance : paiement par les Loup·ves Externes et externes partiels"]
[]
[]
[]
[]
[]
["Dimensionnement de la communauté"]
["Sur le logiciel Calc (Libreoffice), rdv sur Feuille > Plages ou expression nommées > Gérer"]
[]
[null,"Habitant·es",null,null,"⬇️ Nom de variable",null,null,"Salaires et redevances",{"$nulls":3},"Explications"]
[null,"rdv sur l’onglet « Loup·ves » pour modifier leur nombre",{"$nulls":5},"Salaire net mensuel (Internes) (€)",{"v":563.333333333333,"d":"563 €"},"SalaireMensuel",null,"validation retraite : 150 h / trimestre // Soit 1690€ par trim (SMIC 2023)"]
[null,"Nb adultes Loups",90,null,"NbLoups"]
[null,"Nb internes",28,{"v":0.311111111111111,"d":"31 %"},"NbInternes",null,null,"Redevance externe plancher (€)",900,"RedevExterne"]
[null,"Nb médians",18,{"v":0.2,"d":"20 %"},"NbMédians",null,null,"Redevance enfant (€)",200,"RedevEnfant"]
[null,"Nb externes partiels",19,{"v":0.211111111111111,"d":"21 %"},"NbExternesPartiels",null,null,"Taux de prime ( % masse salariale)",{"v":0.06,"d":"6 %"},"TxPrime",null,"Primes versées chaque année"]
[null,"Nb externes",25,{"v":0.277777777777778,"d":"28 %"},"NbExternes"]
[{"$nulls":7},"Autre"]
[null,"Nb Louveteaux",7,null,"NbLouveteaux",null,null,"Nombres de (grands) bâtiments",9,"NbBâtiments",null,"6 maisons + Manoir + Tanière + Ressourcerie"]
[null,"Dont internes",3,{"$nulls":4},"Nombres de voitures / utilitaires dans la flotte de véhicule",15,"NbVéhicules"]
[]
[null,"Nb enfants Loups",30,null,"NbEnfants"]
[null,"Nb enfants Louveteaux",3]
[null,"Nb habitant·es",130,null,"NbHabitants"]
[]
[null,"Temps de travail"]
[null,"Temps min hebdo (h)",8,null,"TpsMinHebdo"]
[null,"Temps plein hebdo (h)",40,null,"TpsPleinHebdo"]
[null,"Nb semaines de congés",5]
[null,"Nb semaines travaillées",47,null,"NbSemainesTravaillées"]
[null,"Temps plein Annuel (h)",1880,null,"TpsPleinAnnuel"]
[null,"Temps de travail Loup·ves et Louveteaux (Etp)",54.6,null,"NbEtp"]

{"sheet":"Général","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[22,5,22,6],[23,1,23,7],[31,3,31,5]],"flags":["formulas_cached_only"]}
["Budgets communautaires année 10"]
[]
[]
[null,"Recettes",{"v":922439.38,"d":"922,439 €"},null,"Dépenses",{"v":878920.428076193,"d":"878,920 €"},null,"par adulte par mois"]
[null,"Redevances",{"v":533150.48,"d":"533,150 €"},{"v":0.577978880303224,"d":"58 %"},"Charges domestiques",{"v":456701.974539636,"d":"456,702 €"},{"v":0.519616975497178,"d":"52 %"}]
[null,"Redevances externes",{"v":283500,"d":"283,500 €"},null,0,{"v":39487.7629818182,"d":"39,488 €"},null,{"v":33.924195001562,"d":"34 €"}]
[null,"Redevances externes partiel",{"v":121790,"d":"121,790 €"},null,0,{"v":55500,"d":"55,500 €"},null,{"v":47.680412371134,"d":"48 €"}]
[null,"Redevances enfants",{"v":72000,"d":"72,000 €"},null,0,{"v":225969,"d":"225,969 €"},null,{"v":194.131443298969,"d":"194 €"}]
[null,"Redevances Louveteaux",{"v":55860.48,"d":"55,860 €"},null,"Autres charges",{"v":135745.211557818,"d":"135,745 €"},null,{"v":116.619597558263,"d":"117 €"}]
[{"$nulls":7},{"v":392.355648229928,"d":"392 €"}]
[null,"Revenus des activités",{"v":355688.9,"d":"355,689 €"},{"v":0.385595961872313,"d":"39 %"},"Salaires",{"v":296304.768,"d":"296,305 €"},{"v":0.337123542171572,"d":"34 %"}]
[null,"Accueil",{"v":212908.5,"d":"212,909 €"},null,"Dont redistribution / prime",{"v":16771.968,"d":"16,772 €"}]
[null,"Autres activités",{"v":142780.4,"d":"142,780 €"}]
[{"$nulls":4},"Foncier et travaux",{"v":87370.9855365562,"d":"87,371 €"},{"v":0.0994071621793983,"d":"10 %"}]
[null,"Autres revenus",{"v":33600,"d":"33,600 €"},{"v":0.0364251578244632,"d":"4 %"},"Annualités foncier / travaux",{"v":44381.2755365562,"d":"44,381 €"},null,{"v":38.1282435881067,"d":"38 €"}]
[null,"Revenus locatifs",{"v":33600,"d":"33,600 €"},null,0,{"v":4000,"d":"4,000 €"},null,{"v":3.43642611683849,"d":"3 €"}]
[{"$nulls":4},"Amortissement / 100 ans",{"v":38989.71,"d":"38,990 €"},null,{"v":33.4963144329897,"d":"33 €"}]
[]
[{"$nulls":4},"Charges des activités",{"v":38542.7,"d":"38,543 €"},{"v":0.043852320151852,"d":"4 %"}]
[{"$nulls":4},"Charges accueil",{"v":23644.5,"d":"23,645 €"}]
[{"$nulls":4},"Charges autres activités",{"v":14898.2,"d":"14,898 €"}]
[]
[null,"Bilan",{"$nulls":3},{"v":43518.9519238076,"d":"43,519 €"}]
[]
[]
["Bilan d’utilisation du temps de travail sur l’année"]
[]
[null,"Capacité de travail",{"v":58.4574468085106,"d":"58"},null,"Temps affecté",{"v":57.3404255319149,"d":"57"}]
[null,"Loups & Louveteaux (h)",{"v":102600,"d":"102,600"},null,"Activités domestiques (h)",{"v":80300,"d":"80,300"}]
[null,"Autres (h)",{"v":7300,"d":"7,300"},null,"Activités revenus (h)",{"v":27500,"d":"27,500"}]
[]
[null,"Temps restant disponible",null,{"v":1.1170212765957,"d":"1.1"},{"$error":"#VALUE!"},{"v":57.3404255319149,"d":"57.3"}]

{"sheet":"Rému","index":2,"n_rows":61,"n_cols":8,"rows_kept":61,"merged":[[0,0,0,11],[15,0,15,2]],"flags":["formulas_cached_only"]}
["Temps de travail & rémunération / redevances des Loups"]
["Cet onglet permet de corréler le temps de travail avec le montant de la redevance ou du salaire"]
["Notre méthode de calcul pour obtenir le temps de travail par rapport au salaire / redevance"]
["La détermination des salaires reste également soumise aux réglementations en vigueur"]
[]
[]
["Données sources"]
[null,"nb h / semaine","redevance / salaires",{"$nulls":3},"Pour le graphique"]
[null,"x","y","Données 2023 France",null,null,"etp","Redevance / salaires"]
[1,8,{"v":-900,"d":"-900.00 €"},"SMIC mensuel net",1383,null,{"v":0.2,"d":"20 %"},{"v":-900,"d":"-900.00 €"}]
[2,40,{"v":563.333333333333,"d":"563.33 €"},"SMIC horaire net",9.11,null,{"v":1,"d":"100 %"},{"v":563.333333333334,"d":"563.33 €"}]
[]
[null,"Salaire : Ce chiffre est du reste à vivre. Les charges, les loyers, l’alimentation sont assurées par la communauté"]
[]
[]
["Comparaison SMIC"]
["Les internes gagnent",{"v":0.407327066763075,"d":"41 %"},"du smic mensuel"]
["1h à Loutopia rapporte",{"v":11.4325,"d":"11.43 €"}]
["soit",{"v":1.25493962678375,"d":"125 %"},"du smic horaire"]
[]
[0]
["a","A = (y2-y1)/(x2-x1)",{"v":45.7291666666667,"d":"45.7292"}]
["b","y1=ax1+b",{"v":-1265.83333333333,"d":"-1265.833"}]
[]
["Tableau des heures"]
[null,"heure hebdo","redev. Mensuelle","heures mensuelles","etp"]
[null,8,{"v":-900,"d":"-900.00 €"},32,{"v":0.2,"d":"20.00 %"}]
[null,9,{"v":-854.270833333334,"d":"-854.27 €"},36,{"v":0.225,"d":"22.50 %"}]
[null,10,{"v":-808.541666666667,"d":"-808.54 €"},40,{"v":0.25,"d":"25.00 %"}]
[null,11,{"v":-762.8125,"d":"-762.81 €"},44,{"v":0.275,"d":"27.50 %"}]
[null,12,{"v":-717.083333333334,"d":"-717.08 €"},48,{"v":0.3,"d":"30.00 %"}]
[null,13,{"v":-671.354166666667,"d":"-671.35 €"},52,{"v":0.325,"d":"32.50 %"}]
[null,14,{"v":-625.625,"d":"-625.63 €"},56,{"v":0.35,"d":"35.00 %"}]
[null,15,{"v":-579.895833333333,"d":"-579.90 €"},60,{"v":0.375,"d":"37.50 %"}]
[null,16,{"v":-534.166666666667,"d":"-534.17 €"},64,{"v":0.4,"d":"40.00 %"}]
[null,17,{"v":-488.4375,"d":"-488.44 €"},68,{"v":0.425,"d":"42.50 %"}]
[null,18,{"v":-442.708333333333,"d":"-442.71 €"},72,{"v":0.45,"d":"45.00 %"}]
[null,19,{"v":-396.979166666667,"d":"-396.98 €"},76,{"v":0.475,"d":"47.50 %"}]
[null,20,{"v":-351.25,"d":"-351.25 €"},80,{"v":0.5,"d":"50.00 %"}]
[null,21,{"v":-305.520833333333,"d":"-305.52 €"},84,{"v":0.525,"d":"52.50 %"}]
[null,22,{"v":-259.791666666667,"d":"-259.79 €"},88,{"v":0.55,"d":"55.00 %"}]
[null,23,{"v":-214.0625,"d":"-214.06 €"},92,{"v":0.575,"d":"57.50 %"}]
[null,24,{"v":-168.333333333333,"d":"-168.33 €"},96,{"v":0.6,"d":"60.00 %"}]
[null,25,{"v":-122.604166666667,"d":"-122.60 €"},100,{"v":0.625,"d":"62.50 %"}]
[null,26,{"v":-76.875,"d":"-76.88 €"},104,{"v":0.65,"d":"65.00 %"}]
[null,27,{"v":-31.1458333333333,"d":"-31.15 €"},108,{"v":0.675,"d":"67.50 %"}]
[null,{"v":27.6810933940775,"d":"27.7"},{"v":0,"d":"0.00 €"},110.72437357631,{"v":0.692027334851938,"d":"69.20 %"}]
[null,28,{"v":14.5833333333333,"d":"14.58 €"},112,{"v":0.7,"d":"70.00 %"}]
[null,29,{"v":60.3125,"d":"60.31 €"},116,{"v":0.725,"d":"72.50 %"}]
[null,30,{"v":106.041666666667,"d":"106.04 €"},120,{"v":0.75,"d":"75.00 %"}]
[null,31,{"v":151.770833333333,"d":"151.77 €"},124,{"v":0.775,"d":"77.50 %"}]
[null,32,{"v":197.5,"d":"197.50 €"},128,{"v":0.8,"d":"80.00 %"}]
[null,33,{"v":243.229166666667,"d":"243.23 €"},132,{"v":0.825,"d":"82.50 %"}]
[null,34,{"v":288.958333333333,"d":"288.96 €"},136,{"v":0.85,"d":"85.00 %"}]
[null,35,{"v":334.6875,"d":"334.69 €"},140,{"v":0.875,"d":"87.50 %"}]
[null,36,{"v":380.416666666667,"d":"380.42 €"},144,{"v":0.9,"d":"90.00 %"}]
[null,37,{"v":426.145833333333,"d":"426.15 €"},148,{"v":0.925,"d":"92.50 %"}]
[null,38,{"v":471.875,"d":"471.88 €"},152,{"v":0.95,"d":"95.00 %"}]
[null,39,{"v":517.604166666667,"d":"517.60 €"},156,{"v":0.975,"d":"97.50 %"}]
[null,40,{"v":563.333333333334,"d":"563.33 €"},160,{"v":1,"d":"100.00 %"}]
[null,41,{"v":609.0625,"d":"609.06 €"},164,{"v":1.025,"d":"102.50 %"}]

{"sheet":"Loup·ves","index":3,"n_rows":104,"n_cols":10,"rows_kept":104,"merged":[[0,0,0,15],[1,0,1,15],[5,0,6,0],[8,0,12,0],[13,0,16,0]],"flags":["formulas_cached_only"]}
["Statuts des Loup·ves, redevances et salaires (année 10)"]
["Quel montant la communauté doit assumer en fonction du nombre de loup·ves et de leur statut et combien de temps elle dispose"]
[]
[]
[null,null,"Internes – salariés","Médians","Externe partiel","Externes","Total","Total Avec Louveteaux",null,"Remarques et commentaires"]
["Répartition","ETP",1,0.7,0.4,0.2,2.3000000000000003,null,null,"Hypothèse simplificatrice : les externes partiels travaillent en moyenne 16h / semaine"]
[null,"nb h / sem (moyenne)",40,28,16,8,92]
["LOUP·VES",{"$nulls":5},120,130]
["Adultes","81 ans et plus",{"$nulls":3},5,5,5]
[null,"65 – 80 ans",null,10,10,4,24,27]
[null,"40 – 64 ans",9,5,6,12,32,34]
[null,"20 – 39 ans",19,3,3,4,29,31]
[null,"sous total",28,18,19,25,90,97]
["Enfants","13 – 19 ans",{"$nulls":3},10,10]
[null,"4 – 12 ans",{"$nulls":3},14,14]
[null,"0 – 3 ans",{"$nulls":3},6,6]
[null,"sous total",{"$nulls":3},30,30,33]
["LOUVETEAUX",{"$nulls":5},10]
["adultes","81 ans et plus",{"$nulls":4},0]
[null,"65 – 80 ans",2,1,null,null,3]
[null,"40 – 64 ans",{"$nulls":3},2,2]
[null,"20 – 39 ans",1,null,1,null,2]
["enfants","0 – 19 ans",{"$nulls":4},3]
[null,"sous total",3,1,1,2]
[]
["Temps de travail Loup·ves et Louveteaux",null,"Internes – salariés","Médians","Externe partiel","Externes","Total","moy",null,"Remarques et commentaires"]
[null,"%age de Loup·ves en congé long",{"v":0.08,"d":"8 %"},{"v":0.08,"d":"8 %"},{"v":0.05,"d":"5 %"},{"$nulls":4},"Les absences / congés maladies courts sont comptées dans le budget temps"]
[null,"Nb Loup·ves en congé long",2,1,1,null,4,null,null,"D’ailleurs, congés longs = sans solde…"]
[null,"Tps travail adulte / semaine (h)",1160,504,304,216,2184,{"v":24.2666666666667,"d":"24.3"},null,"dont Louveteaux"]
[null,"annuel (h)",54520,23688,14288,10152,102648]
[null,"Annuel (etp)",29,12.6,7.6,5.4,54.6,{"v":0.606666666666667,"d":"0.6"}]
[]
["Redevances",null,"Internes – salariés","Médians","Externe partiel","Externes"]
["Louveteaux","par mois",null,null,{"v":1074.24,"d":"1,074 €"},{"v":1790.4,"d":"1,790 €"},{"$nulls":3},"Les Louveteaux externes donnent leurs salaire à la communauté. Hypothèse : iels gagnent en moyenne 80% du salaire moyen en France"]
["Salaire donné à la communauté","annuel (moy)",null,null,{"v":12890.88,"d":"12,891 €"},{"v":42969.6,"d":"42,970 €"},{"v":55860.48,"d":"55,860 €"},null,null,"A noter que leur apport est significatif dans le modèle économique de la communauté"]
["Loup·ves","mensuelle",null,null,{"v":534.166666666667,"d":"534 €"},{"v":945,"d":"945 €"},{"$nulls":3},"Externes : on parle des revenus moyens (et non pas plancher)"]
[null,"annuelle",null,null,{"v":121790,"d":"121,790 €"},{"v":283500,"d":"283,500 €"},{"v":405290,"d":"405,290 €"}]
["Loup·ves & Louveteaux"," total annuel",null,null,{"v":134680.88,"d":"134,681 €"},{"v":326469.6,"d":"326,470 €"},{"v":461150.48,"d":"461,150 €"}]
["Ptis Loups",{"$nulls":4},{"v":72000,"d":"72,000 €"}]
["Ptis Louveteaux",{"$nulls":4},{"v":0,"d":"0 €"},{"$nulls":3},"C’est cadeau !"]
[]
["Coût des salaires et argent de poche des Internes",null,"Internes – salariés"]
["Louveteaux","par mois",{"v":100,"d":"100 €"},{"$nulls":6},"Les Louveteaux qui travaillent 40h par semaine n’ont pas de contrat de travail ni de salaire.Iels gagnent un peu d’argent de poche tout de même."]
["Argent de poche","annuel",{"v":3600,"d":"3,600 €"}]
["Salaire Loups","par mois",{"v":884.4,"d":"884 €"},{"$nulls":6},"Coût du salaire pour la structure, incluant les charges patronales"]
[null,"Coût horaire pour Loutopia",{"v":22.11,"d":"22 €"}]
["Salaire","annuel",{"v":275932.8,"d":"275,933 €"}]
["Loup·ves & Louveteaux"," total annuel",{"v":279532.8,"d":"279,533 €"}]
[]
["Revenus des Externes",null,"Externes"]
[null,"Mode de calcul",0.3,"des revenus pro / immo / financiers"]
[null,"Valeur plancher",900,"€ / mois"]
[null,"Tx des « Externes ++ »",0.15,"Hypothèse du taux d’externes qui doivent verser au-delà du plancher",{"$nulls":5},"Celleux qui gagnent plus de 3000€ par mois, quoi"]
[null,"Revenus moy des Externes ++",4000,"€ / mois"]
[null,"Redev externes++",1200,"€ / mois"]
[null,"Montant redev moyen",945,"€ / mois"]
[]
["Calcul salaire",{"$nulls":4},"validation retraite : 150 h / trimestre"]
[null,null,{"v":563.333333333333,"d":"563.33"},"€ par mois",null,1690,"€ par trim (SMIC 2023)"]
[null,"soit",{"v":0.407327066763075,"d":"0.41"},"du SMIC",{"v":61.5063870812243,"d":"61.51"},"H / mois"]
[{"$nulls":4},{"v":14.2564473367076,"d":"14.26"},"H / sem"]
[{"$nulls":4},"dérogation à travail – de 24h :  la demande du salarié","https://www.service-public.fr/particuliers/vosdroits/F32428"]
[null,"calcul des charges SMIC","https://www.urssaf.fr/accueil/outils-documentation/simulateurs/cotisations-employeur.html"]
[null,null,738,"salaire brut"]
[null,null,804,"Coût structure"]
[null,null,884.4,"Coût structure avec aléa, soit un taux de charge de",{"$nulls":4},1.56994082840237]
[null,"calcul en fonction du salaire",884.4000000000012,null,"attention : si on augmente le salaire au-delà du smic, le taux de charge doit augmenter !"]
[]
["Situation des Loup·ves"]
[null,null,"Nb / catégorie","chômage","maladie longue","handicap","parent solo","retraite"]
[null,"81 ans et plus",5,0,1,1,null,5]
[null,"65 – 80 ans",24,0,1,null,null,22]
[null,"40 – 64 ans",32,2,1,1,5]
[null,"20 – 39 ans",29,3,null,null,4]
[null," sous total",null,5,3,2,9,27]
[]
[]
["Budgets individuels selon situation (mensuel)"]
["Un couple plein temps communautaire avec deux enfants dont un -3 ans (continuent de travailler)"]
[null,"A noter qu’un système de nounou partagée est mis en place 4 jours / semaine (compte comme du travail)"]
[null,"salaires net",{"v":1126.66666666667,"d":"1,127 €"}]
[null,"redevance enfants",{"v":-400,"d":"-400 €"}]
[null,"allocation CAF",{"v":327,"d":"327 €"}]
[]
[null,"« reste à vivre »",{"v":1053.66666666667,"d":"1,054 €"}]
[]
["Un couple avec deux enfants dont un -3 ans, 1 parent Interne, 1 parent médian"]
[null,"Salaire net",{"v":563.333333333333,"d":"563 €"}]
[null,"Redevance médian",{"v":0,"d":"0 €"}]
[null,"Redevance enfants",{"v":-400,"d":"-400 €"}]
[null,"Allocation CAF",{"v":756,"d":"756 €"},"à voir si les 429€ de la CAF valent dans ce cas"]
[]
[null,"« reste à vivre »",{"v":919.333333333333,"d":"919 €"}]
[]
[]
["Nota Aides CAF enfance"]
[null,null,"prime naissance",1000,"€ une fois"]
[null,null,"3 premières années",185,"€ / mois par enfant"]
[null,null,"2 enfants à charge",142,"€ / mois jusqu’aux 20 ans"]
[null,null,"3 enfants à charge",325,"€ / mois jusqu’aux 20 ans"]
[]
[null,null,"si stop travail",429,"€ / mois pendant 6 mois"]
[{"$nulls":3},429,"€ / mois pendant 24 mois pour 2ème enfant"]
[{"$nulls":3},429,"€ / mois pendant 48 mois pour 3ème enfant"]

{"sheet":"Bâti","index":4,"n_rows":60,"n_cols":14,"rows_kept":60,"merged":[[0,0,0,12],[4,0,4,2]],"flags":["formulas_cached_only"]}
["Habitats : répartition des Loup·ves et surfaces (année 10)"]
[]
["Dans quels bâtiments vivent les Loups et quelles sont leur surface ?"]
[]
["Répartition des habitations en fonction des âges et des lieux",null,null,"Pigeonnier","cloître","Orangerie","Le belvédère","Le Moulin","Bergerie","3 Maisons Indépendantes","Totaux",null,"Récape surface pour onglet immo"]
[{"$nulls":3},"fêtards","vieux","律‍♀️méditants","jeunes","‍‍‍Inter-G","‍‍‍Familles",{"$nulls":3},"Pigeonnier",553.15]
["LOUPS",{"$nulls":11},"cloître",468.05]
[null,"adultes","81 ans et plus",null,4,null,null,1,null,null,5,null,"Orangerie",449.65]
[null,null,"65 – 80 ans",2,10,4,null,6,1,1,24,null,"Le belvédère",365.4]
[null,null,"40 – 64 ans",9,1,6,null,6,8,2,32,null,"Le Moulin",517.5]
[null,null,"20 – 39 ans",8,1,6,8,1,3,2,29,null,"Bergerie",564.65]
[null,null," sous total",19,16,16,8,14,12,5,90]
[null,"enfants","13 – 19 ans",2,null,null,7,1,null,null,10]
[null,null,"4 – 12 ans",1,{"$nulls":3},4,7,2,14]
[null,null,"0 – 3 ans",{"$nulls":4},2,3,1,6]
[null,null,"sous total",3,0,0,7,7,10,3,30]
["LOUVETEAUX"]
[null,"adultes","81 ans et plus",{"$nulls":7},0]
[null,null,"65 – 80 ans",null,1,2,{"$nulls":4},3]
[null,null,"40 – 64 ans",1,{"$nulls":4},1,null,2]
[null,null,"20 – 39 ans",{"$nulls":3},1,1,null,null,2]
[null,"enfants","0 – 19 ans",{"$nulls":4},1,2,null,3]
[null,null,"sous total",1,1,2,1,2,3,0,10]
[]
[null,null,"Total",23,17,18,16,23,25,8,130]
["HABITATS LEGERS autour des grandes maisons"]
[null,null,"Nb de HL à côté",3,1,4,3,3,3,null,17]
[null,null,"Type d’HL","kerterres",null,"roulotte","Caravane & camion","yourte","tiny"]
[null,null,"Nb personnes en HL",3,1,4,3,5,6,null,22]
[null,null,"Commentaires des habitant·es d’HL",{"$nulls":4},"Mère & 2 enfants","une famille"]
[]
["OCCUPATIONS MAISONS"]
[null,null,"Nb personnes logées",20,16,14,13,18,19,null,100]
[null,null,"Nb chambres dans la maison",20,16,14,13,18,20,null,101]
[null,null,"Nb de chambres inoccupées",0,0,0,0,0,1,null,1]
[]
["SURFACES (unité : m²)"]
[null,null,"surface moyenne 1 chb (m²)",18,18,18,18,18,18,null,null,"agencements différents : chambres plus petites & petits espaces de vie de famille"]
[null,null,"Cuisine – salle à manger",40,40,40,15,40,40]
[null,null,"salon",15,15,15,35,null,15]
[null,null,"grand salon jeux de société",{"$nulls":4},40]
[null,null,"salle musique – piano à queue",40]
[null,null,"bibliothèque",null,40]
[null,null,"buanderie friperie",null,null,60]
[null,null,"salle projection / fête",{"$nulls":3},40]
[null,null,"Friperie enfants",{"$nulls":4},20]
[null,null,"Espace créativité et de garderie",{"$nulls":5},50]
[]
[null,null,"Salles de bain (2 par bâtiment)",20,20,20,20,20,20]
[null,null,"WC (2 ou 3 par bâtiment)",6,4,4,4,6,6]
[null,null,"total",481,407,391,348,450,491]
[null,null,"Ratio Couloirs / placards",0.15,0.15,0.15,0.05,0.15,0.15]
[]
[null,null,"Surface habitable (m²)",553.15,468.05,449.65,365.4,517.5,564.65,null,2918.4]
[]
["ESTIMATION DE L’IMPLANTATION"]
[null,null,"Nb niveaux",3,1,3,2,3,3]
[null,null,"Surface au sol",184.38333333333333,468.05,149.88333333333333,182.7,172.5,188.21666666666667,null,1345.73333333333]
[null,"si rectangle :","longueur",20,null,16,20,20,20]
[null,null,"largeur",9.219166666666666,null,9.367708333333333,9.135,8.625,9.410833333333333]

{"sheet":"Budget_temps","index":5,"n_rows":142,"n_cols":9,"rows_kept":142,"merged":[[0,0,0,7]],"flags":["formulas_cached_only"]}
["Budgets temps, par activité, affectés pour l’année (année 10)"]
[]
[]
["Temps de travail disponible",null,null,"h / an",null,null,"Calculs / Remarques"]
[null,"Loups & Louveteaux",null,{"v":102648,"d":"102,648"}]
[null,"Chantiers participatifs (construction)",null,{"v":2940,"d":"2,940"},null,null,"4 chantiers d’une semaine avec 15 personnes"]
[null,"Woofing",null,{"v":1920,"d":"1,920"},null,null,"2 en moyenne pdt  8 mois","nb jours",480]
[null,"Renards",null,{"v":1600,"d":"1,600"},null,null,"4 Renards (comme Jean) s’impliquent comme des Loups Externes"]
[null,"Séjours immersifs",null,768,null,null,"Les visiteurs (comme Célia !) ne travaillent que les aprem => 3h par jour"]
["Total",null,null,{"v":109876,"d":"109,876"}]
[]
["Récape",null,null,"h / an","%","etp"]
["Total 14 meutes",null,null,{"v":97980.0402380952,"d":"97,980"},{"v":0.89173286466649,"d":"89 %"},{"v":52.1170426798379,"d":"52.1"}]
["Activités domestiques",null,null,{"v":72988.1952380952,"d":"72,988"},{"v":0.74492922293899,"d":"74 %"},{"v":38.8235081053698,"d":"38.8"}]
[null,"Marge d’incertitude",null,{"v":7298.81952380953,"d":"7,299"},{"v":0.1,"d":"10 %"},{"v":3.88235081053698,"d":"3.9"},"imprévus, transmission"]
[null,"Total domestique",null,{"v":80287.0147619048,"d":"80,287"}]
["Activités revenus",null,null,{"v":24991.845,"d":"24,992"},{"v":0.25507077706101,"d":"26 %"},{"v":13.2935345744681,"d":"13.3"}]
[null,"Marge d’incertitude",null,{"v":2499.1845,"d":"2,499"},{"v":0.1,"d":"10 %"},{"v":1.32935345744681,"d":"1.3"},"imprévus, transmission"]
[null,"Total revenus",null,{"v":27491.0295,"d":"27,491"}]
["Total 14 meutes avec marges",null,null,{"v":107778.044261905,"d":"107,778"},null,{"v":57.3287469478217,"d":"57.3"}]
[]
["Restent à affecter",null,null,{"v":2097.95573809523,"d":"2,098"},null,{"v":1.11593390324214,"d":"1.1"}]
[]
[]
["Meutes / activités",null,null,"h / an","%","etp","Calculs / Remarques"]
["Autres activités",null,null,14876,{"v":0.135388983945539,"d":"13.54 %"},{"v":7.91276595744681,"d":"7.9"}]
["Cuisine et transfo",null,null,12042,{"v":0.109596272161346,"d":"10.96 %"},{"v":6.40531914893617,"d":"6.4"}]
["Agriculture",null,null,{"v":12413.6,"d":"12414"},{"v":0.112978266409407,"d":"11.30 %"},{"v":6.60297872340426,"d":"6.6"},"Mêmes chiffres que TwinOaks, alors qu’iels étaient moins nombreux·euses. On estime une meilleure efficacité et/ou plus de recours aux achats."]
["Soins aux personnes",null,null,11762,{"v":0.107047944956132,"d":"10.70 %"},{"v":6.2563829787234,"d":"6.3"}]
["Fonctionnement & coordi",null,null,12050,{"v":0.109669081510066,"d":"10.97 %"},{"v":6.40957446808511,"d":"6.4"}]
["Infrastructures et maintenance",null,null,9805,{"v":0.0892369580254105,"d":"8.92 %"},{"v":5.21542553191489,"d":"5.2"},"Dont 6000 heures dédiées nouvelle maison"]
[]
[]
["Détails par meutes / activités",null,null,"h / an","%","etp","Calculs / Remarques"]
["Fonctionnement & coordi",null,null,12050,{"v":0.109669081510066,"d":"10.97 %"},{"v":6.40957446808511,"d":"6.4"}]
[null,"Réunions plénières",null,3492,null,{"v":1.85744680851064,"d":"1.9"},"3h toutes les 2 semaines pour la moitié des Loup·ves et Louveteaux"]
[null,"Animation cercle cœur",null,200,null,{"v":0.106382978723404,"d":"0.1"},"Une fois sur deux, ces cercles cœur ont lieu dans chacune des maisons afin de créer du lien entre cohabitants, et une fois sur deux l’ensemble des Loups sont invités dans l’Antre, mais viennent ceux qui veulent »"]
[null,"Eclaireurs",null,1600,null,{"v":0.851063829787234,"d":"0.9"},"4 éclaireur·eusesPar semaine : 4h de réu + 4h de lectures / discussion / observation autres réu"]
[null,"Enveloppe temps pour projets",null,900,null,{"v":0.478723404255319,"d":"0.5"},"10h par Loup·ves (moy)"]
[null,"Formation collective",null,960,null,{"v":0.51063829787234,"d":"0.5"},"2 journées par an pour les 2/3 des Loup·ves"]
[null,"Attribution du travail",null,860,null,{"v":0.457446808510638,"d":"0.5"},"Coordi des tâches ; réu 1x / semaine 10 PiloutesEt du suivi chaque jour"]
[{"$nulls":5},{"v":0,"d":"0.0"},"la place du marché = pas compté dans les heures ?"]
[null,"Lycanthropes – médiation & dev perso",null,673,null,{"v":0.357978723404255,"d":"0.4"},"Réu : 4 pers x 2h x 2x / mois (supervision, Orga formation coll, etc.)Temps indiv : 3h par an dès ado  Action médiation : 10h / mois Formation Lycanthrope : 8j/an"]
[null,"Planification économique",null,440,null,{"v":0.234042553191489,"d":"0.2"},"Comme à Twin Oaks – 1 temps plein durant 2,5 mois"]
[null,"Séjours immersifs",null,300,null,{"v":0.159574468085106,"d":"0.2"},"5 séjours : 1 semaine + 20h par session amont aval (comm’, mails, etc.)"]
[null,"Processus d’intégration",null,1880,null,{"v":1,"d":"1.0"},"Réunions régulières pour 3 ou 4 membres – liens avec Louveteaux, organisation de l’appel de la forêt, de l’histoire de ma vie et de la célébration.Ça vaut bien un temps plein !"]
[null,"Absentéisme",null,405,null,{"v":0.215425531914894,"d":"0.2"},"2 fois moins que Twin Oaks (?)4,5h / Loup"]
[null,"Communication",null,100,null,{"v":0.0531914893617021,"d":"0.1"},"Communication extérieure à la communauté (ne concerne pas les business communautaires)"]
[null,"Réseau Oasis / GEN / HPF",null,160,null,{"v":0.0851063829787234,"d":"0.1"},"20 j / an pour des investissements pluriels dans ces réseaux"]
[null,"Juridique",null,80,null,{"v":0.0425531914893617,"d":"0.0"}]
[null,"Anniversaire chômé",null,0,null,{"v":0,"d":"0.0"},"Ou pas… nan mais on n’est pas à Twin Oaks, quoi"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Administratif",null,null,3226,{"v":0.0293603698714915,"d":"2.94 %"},{"v":1.71595744680851,"d":"1.7"}]
[null,"Comptabilité & Admin",null,1880,null,{"v":1,"d":"1.0"},"Budgets, paiement factures, suivis comptable, gestions juridiques courantes, organisation des AG.=> 1 etp (le nb d’habitant·es d’influe peu)"]
[null,"Gestion humaine des ressources",null,1164,null,{"v":0.619148936170213,"d":"0.6"},"Contrats de travail des Internes, suivi des temps de travail et évolutions de statuts12h / travailleurs / an en moyenne (60% etp pour 100 Loup·ves)"]
[null,"Gestion investisseurs",null,132,null,{"v":0.0702127659574468,"d":"0.1"},"Cf les « apports externes de l’onglet Immo » => il faut les bichonner !=> 2h / semaine + qq journées par an"]
[null,"Gestions locatives",null,50,null,{"v":0.0265957446808511,"d":"0.0"},"1h / semaine"]
[null,"Accueil",null,0,null,{"v":0,"d":"0.0"},"L’accueil de personnes est prévu dans l’activité accueil (cf onglet éponyme)"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Agriculture",null,null,{"v":12413.6,"d":"12414"},{"v":0.112978266409407,"d":"11.30 %"},{"v":6.60297872340426,"d":"6.6"},"Mêmes chiffres que TwinOaks, alors qu’iels étaient moins nombreux·euses. On estime une meilleure efficacité et/ou plus de recours aux achats."]
[null,"Réunions de meute et coordination",null,100,null,{"v":0.0531914893617021,"d":"0.1"}]
[null,"Apiculture",null,120,null,{"v":0.0638297872340426,"d":"0.1"}]
[null,"Céréales",null,700,null,{"v":0.372340425531915,"d":"0.4"}]
[null,"Sylviculture",null,1823.6,null,{"v":0.97,"d":"1.0"},"Compter 1 etp pour gérer le bois de chauffage pour une centaine de personne. => sélection découpe et stockage de bois proche des bâtiments"]
[null,"Potager",null,5850,null,{"v":3.11170212765957,"d":"3.1"},"Comme Twin Oaks - 7 x 1/2j quotidien de travail hors hiver. Autre source la Rivoire (42) : production similaire avec 3,5 etp=> cela revient à 65h / Loup·ves / an"]
[null,"Jardin aromatique",null,300,null,{"v":0.159574468085106,"d":"0.2"}]
[null,"Champignon",null,20,null,{"v":0.0106382978723404,"d":"0.0"}]
[null,"Verger",null,500,null,{"v":0.265957446808511,"d":"0.3"}]
[null,"Poulailler",null,1000,null,{"v":0.531914893617021,"d":"0.5"},"gestion d’une cinquantaine de volailles : poules, coq, dindes, dindons, pintades."]
[null,"Brebis",null,2000,null,{"v":1.06382978723404,"d":"1.1"},"Environ 2 etp sur la moitié de l’année beaucoup de temps à laver (genre 30 % du temps)"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Infrastructures et maintenance",null,null,9805,{"v":0.0892369580254105,"d":"8.92 %"},{"v":5.21542553191489,"d":"5.2"},"Dont 6000 heures dédiées nouvelle maison"]
[null,"Réunions de meute et coordination",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[null,"Construction maison",null,6420,null,{"v":3.41489361702128,"d":"3.4"},"5 loups sur les chantier (4 chantiers / an d’une semaine, avec prépa & rangement soit 10j) + un coordi temps plein + le temps des volontaires (réseau twiza et autre)"]
[null,"Entretien général maisons & communs",null,3285,null,{"v":1.74734042553192,"d":"1.7"},"(équipements, systèmes de chauffage, élec réseaux, plomberie, traitement eaux). 1H / jour / bâti => budget à épaissir au fil des années, les bâtiments vieillissant"]
[null,"Atelier bois",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Maintenance mobilité route",null,null,{"v":1476.92857142857,"d":"1477"},{"v":0.0134417759240286,"d":"1.34 %"},{"v":0.785600303951368,"d":"0.8"}]
[null,"Réunions de meute et coordination",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[null,"Maintenance voitures",null,831.428571428571,null,{"v":0.442249240121581,"d":"0.4"},"5h / véhicule / mois, une quinzaine de véhicules de ville et utilitaires pour 100 personnes, soit 1 pour 7 adultes habitant·es"]
[null,"Maintenance vélos",null,145.5,null,{"v":0.0773936170212766,"d":"0.1"},"1h30 de maintenance par habitant·e en moyenne"]
[null,"Maintenance des routes",null,150,null,{"v":0.0797872340425532,"d":"0.1"}]
[null,"Trajets hebdo communautaire à la ville",null,300,null,{"v":0.159574468085106,"d":"0.2"},"2 trajets / semaines de 3h aux villes d’à côté"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Soins aux personnes",null,null,11762,{"v":0.107047944956132,"d":"10.70 %"},{"v":6.2563829787234,"d":"6.3"}]
[null,"Réunions de meute et coordination",null,120,null,{"v":0.0638297872340426,"d":"0.1"}]
[null,"Réunion meutes",null,80,null,{"v":0.0425531914893617,"d":"0.0"},"réunion de meute"]
[null,"Temps de maladie",null,5152,null,{"v":2.74042553191489,"d":"2.7"},"2 semaines par an pour internes & médians"]
[null,"Micro crèche – 3 ans",null,3600,null,{"v":1.91489361702128,"d":"1.9"},"Pour 6 enfants de moins de 3 ans, 2 « nounous » s’en occupent 8 h/j et 4 j/semaine.Compter 600h / enfants Loups et par an."]
[null,"Garderie enfants 4-12",null,2200,null,{"v":1.17021276595745,"d":"1.2"},"garderie 16 semaines de vacances – 2 adultes (10h/jour prépa incluse)Périsco : 3h/ jours un adulte (prépa incluse)"]
[null,"Aide aux personnes non autonomes",null,480,null,{"v":0.25531914893617,"d":"0.3"},"en moyenne 15h par an et par personne de plus de 60 ans"]
[null,"Aménagements extérieurs pour enfants",null,80,null,{"v":0.0425531914893617,"d":"0.0"},"5J par an à 2 pers"]
[null,"Friperie des enfants",null,50,null,{"v":0.0265957446808511,"d":"0.0"},"1 lessive par semaine"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Relations extérieures",null,null,{"v":1276.66666666667,"d":"1277"},{"v":0.0116191585666266,"d":"1.16 %"},{"v":0.679078014184397,"d":"0.7"}]
[null,"Relations voisinages",null,626.666666666667,null,{"v":0.333333333333333,"d":"0.3"},"Rencontres des habitant·esCoups de mains réguliers"]
[null,"Relations officielles",null,350,null,{"v":0.186170212765957,"d":"0.2"},"Implication municipales, représentations diverses de Loutopia"]
[null,"Activisme",null,300,null,{"v":0.159574468085106,"d":"0.2"},"5 activistes y passent une aprem par mois"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Cuisine et transfo",null,null,12042,{"v":0.109596272161346,"d":"10.96 %"},{"v":6.40531914893617,"d":"6.4"}]
[null,"Coordi meute",null,364,null,{"v":0.193617021276596,"d":"0.2"},"1h de réu à 7p. / semaine"]
[null,"Cuisine",null,5490,null,{"v":2.92021276595745,"d":"2.9"},"Chaque jour : - 1 pers. 3h le midi (restes) - 3 pers. x 4h pour repas du soir + => cela revient à 61h / Loup·ves / an"]
[null,"Nettoyage de la cuisine",null,2898,null,{"v":1.54148936170213,"d":"1.5"},"3 pers x 1,5h par service (break le dimanche) + un gros lavage mensuel"]
[null,"Approvisionnement",null,350,null,{"v":0.186170212765957,"d":"0.2"},"2 demi journée / semaineParce que c’est bien huilé, coco"]
[null,"Transformation mise en bocaux",null,910,null,{"v":0.484042553191489,"d":"0.5"},"5 demi jour / semaines"]
[null,"Transformation viande",null,450,null,{"v":0.23936170212766,"d":"0.2"}]
[null,"Transformation lait",null,850,null,{"v":0.452127659574468,"d":"0.5"}]
[null,"Boulangerie",null,730,null,{"v":0.388297872340426,"d":"0.4"},"2h par jour"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Travail domestique",null,null,5026,{"v":0.045742473333576,"d":"4.57 %"},{"v":2.67340425531915,"d":"2.7"}]
[null,"Réunions de meute et coordination",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[null,"Vêtements communautaires",null,496,null,{"v":0.263829787234043,"d":"0.3"},"Lavage, rangement, etc. : 1 journée par semaine + 10 journées de tri / récupe, etc."]
[null,"Ménage des maisons et des espaces communs",null,2340,null,{"v":1.24468085106383,"d":"1.2"},"5h / semaine / bâtiments"]
[null,"Décoration et embellissement",null,1800,null,{"v":0.957446808510638,"d":"1.0"},"200h / bâtiment / an"]
[null,"Dispatch  des chambres",null,40,null,{"v":0.0212765957446809,"d":"0.0"},"Changement de chambres, nouvelles arrivées"]
[null,"Divers",null,300,null,{"v":0.159574468085106,"d":"0.2"},"Budget à attribuer pour améliorations / mini réparations diverses"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Terrain",null,null,730,{"v":0.00664385307073428,"d":"0.66 %"},{"v":0.388297872340426,"d":"0.4"}]
[null,"Aménagement paysager",null,700,null,{"v":0.372340425531915,"d":"0.4"},"quasi 2j / semaine"]
[null,"Maintenance étang",null,30,null,{"v":0.0159574468085106,"d":"0.0"},"Les enfants adorent enlever les algues, mais ça iels le font gratuitement"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Support matériel",null,null,1430,{"v":0.0130146710837672,"d":"1.30 %"},{"v":0.76063829787234,"d":"0.8"}]
[null,"Réunions de meute et coordination",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[null,"Alimentation chaudières bûches",null,567,null,{"v":0.301595744680851,"d":"0.3"},"Astreinte pour mettre les bûches dans les chaudières :  20min / jour / bâtiment 7 mois dans l’année"]
[null,"Gestion recyclage / déchet’",null,500,null,{"v":0.265957446808511,"d":"0.3"},"un tiers temps pour pousser le recyclage et la valorisation de tous les déchets"]
[null,"Informatique réseau, sécurité, systèmes d’informations",null,208,null,{"v":0.11063829787234,"d":"0.1"},"4h / semaine"]
[null,"Bibliothèque",null,90,null,{"v":0.0478723404255319,"d":"0.0"},"Rangement des livres"]
[null,"Archives",null,15,null,{"v":0.00797872340425532,"d":"0.0"},"on y vire ?"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Evénements internes",null,null,1750,{"v":0.0159270450325822,"d":"1.59 %"},{"v":0.930851063829787,"d":"0.9"},"Fêtes des 10 ans"]
[null,"Réunions de meute et coordination",null,120,null,{"v":0.0638297872340426,"d":"0.1"}]
[null,"Préparation anniversaire communauté",null,940,null,0.5,"Préparation des 10 ans – 1/2 etp"]
[null,"Préparation fêtes des saisons",null,24,null,{"v":0.0127659574468085,"d":"0.0"},"4 fêtes – 6h de prépa"]
[null,"Autres fêtes",null,50,null,{"v":0.0265957446808511,"d":"0.0"}]
[null,"Ateliers / cours réguliers",null,416,null,{"v":0.221276595744681,"d":"0.2"},"yoga, cercles parole, méditations guidées… en moyenne 4 intervenant·es / activités de 2h semaines"]
[null,"Propositions d’activités diverses",null,200,null,{"v":0.106382978723404,"d":"0.1"},"4h / semaine"]
[{"$nulls":5},{"v":0,"d":"0.0"}]
["Accueil & Formations",null,null,10115.845,{"v":0.0920660107757836,"d":"9.21 %"},{"v":5.38076861702128,"d":"5.4"},"Détail dans l’onglet Accueil"]
["Autres activités",null,null,14876,{"v":0.135388983945539,"d":"13.54 %"},{"v":7.91276595744681,"d":"7.9"}]
[null,0,null,8460,null,4.5]
[null,0,null,5640,null,{"v":3,"d":"3.0"}]
[null,0,null,776,null,{"v":0.412765957446809,"d":"0.4"}]

{"sheet":"Immo","index":6,"n_rows":74,"n_cols":6,"rows_kept":74,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Montage financier"]
["Montage financier : ce qu’on a dû financer et comment on l’a fait"]
[]
[]
[]
["Bilan / Coût Immobilier","Année 1","Année 10"]
[]
["Coût du foncier",{"v":1,"d":"1 €"},{"v":1,"d":"1 €"},"Le foncier nous est mis à disposition par une fondation"]
["Montant travaux",{"v":376000,"d":"376,000 €"},{"v":4332190,"d":"4,332,190 €"},"détail en bas de feuille"]
["Taux subs",{"v":0,"d":"0 %"},{"v":0.1,"d":"10 %"},"AAP / Réno efficace / logements séniors / CEE / etc.Droits à des aides en tant que locataire & bailleurrésidence de service (4 services, dont pti dej, lingerie) => récupe totalité de la TVA // + défiscalisation"]
["Montant aides",0,{"v":433219,"d":"433,219 €"}]
["A financer",{"v":376000,"d":"376,000 €"},{"v":3898971,"d":"3,898,971 €"}]
[]
["Investissement moyen loup·ves",{"v":30000,"d":"30,000 €"},{"v":27000,"d":"27,000 €"},"Hypothèse conservatrice"]
["Apports internes",{"v":450000,"d":"450,000 €"},{"v":2430000,"d":"2,430,000 €"}]
["Apports externes",null,{"v":1600000,"d":"1,600,000 €"},"40 investisseurs dont 1 à 1M€"]
[]
["Taux fond de réserve",null,{"v":0.08,"d":"8 %"},"des apports","Fonds de réserve (Inspiration modèle Les Pas Sages)\nC’est un matelas à conserver pour sécuriser et rembourser rapidement les investisseur·euses\nEn liquidité, mais aussi sous forme de stock, de roulotte / échafaudages / tracteurs (revente facile)\n+ mutuelle avec différentes coopératives nationales"]
["Montant du fonds de réserve",{"v":0,"d":"0 €"},{"v":322400,"d":"322,400 €"}]
[]
["Emprunt bancaire",{"v":0,"d":"0 €"},{"v":500000,"d":"500,000 €"},"Permet de la souplesse financière et de la stabilité"]
["Durée d’emprunt (année)",null,{"v":15,"d":"15 €"}]
["Taux",null,{"v":0.04,"d":"0 €"},"« bon taux sur 25 ans » en oct. 2023 = 4,4 %"]
["Annualités",{"v":0,"d":"0 €"},{"v":44381.2755365562,"d":"44,381 €"}]
[]
["Surplus",{"v":74000,"d":"74,000 €"},{"v":308629,"d":"308,629 €"},"Trésorerie"]
[]
["Rémunération des investisseurs",null,{"v":0,"d":"0 €"},"pas de rémunération !"]
["lot / cadeaux investisseurs",{"v":0,"d":"0 €"},{"v":4000,"d":"4,000 €"},"Formalisation / garanties – souplesse dans le retrait des liquidités"]
[{"$nulls":3},"Stage / séjours / etc. // les investisseus·euses passent 10j sur place"]
[]
["Amortissement 100 ans à 1 %",{"v":3760,"d":"3,760 €"},{"v":38989.71,"d":"38,990 €"},"Affecté au projet (non redistribuable)Déductible fiscalementUtilité éco & philo : celui qui jouit compense l’usure de ce qu’il a jouitPermet de se désendetter sur le long terme (trésorerie et remboursement des associé·es)"]
[]
[]
[]
["Estimations des travaux"]
[null,null,"Surfaces","Ratio € / m²","Coût travaux"]
["Bâtiments communs"]
["Manoir",null,900,null,{"v":115000,"d":"115,000 €"},"Rafraichissement + 15k€ ascenseur"]
["Tanière",null,280,{"v":700,"d":"700 €"},{"v":196000,"d":"196,000 €"},"Rénovation ancienne grange"]
["Antre",null,150,{"v":600,"d":"600 €"},{"v":90000,"d":"90,000 €"},"Construction"]
["Chapeloise",{"$nulls":3},{"v":15000,"d":"15,000 €"},"Rénovation"]
["Hangars agricoles / bergerie",null,600,{"v":150,"d":"150 €"},{"v":90000,"d":"90,000 €"}]
["Ressourcerie",null,0,{"v":400,"d":"400 €"},{"v":0,"d":"0 €"},"Rénovation & extension"]
[]
["Grandes maisons"]
["Pigeonnier",null,553.15,{"v":800,"d":"800 €"},{"v":442520,"d":"442,520 €"},"Rénovation"]
["cloître",null,468.05,{"v":800,"d":"800 €"},{"v":374440,"d":"374,440 €"},"Rénovation"]
["Orangerie",null,449.65,{"v":900,"d":"900 €"},{"v":404685,"d":"404,685 €"},"Rénovation"]
["Le belvédère",null,365.4,{"v":900,"d":"900 €"},{"v":328860,"d":"328,860 €"},"Construction (root)"]
["Le Moulin",null,517.5,{"v":1000,"d":"1,000 €"},{"v":517500,"d":"517,500 €"},"Construction"]
["Bergerie",null,564.65,{"v":900,"d":"900 €"},{"v":508185,"d":"508,185 €"},"Fondation existante / construction"]
["Maison en construction",null,330,{"v":1000,"d":"1,000 €"},{"v":330000,"d":"330,000 €"},"10 – 15 chambres"]
[]
["Habitats légers",null,"Coût moyen","nombre"]
["Habitats légers à côté des maisons",null,{"v":30000,"d":"30,000 €"},11,{"v":330000,"d":"330,000 €"}]
["Habitats légers indépendants",null,{"v":30000,"d":"30,000 €"},3,{"v":90000,"d":"90,000 €"}]
[]
["Général"]
["Outillage pour travaux",{"$nulls":3},{"v":150000,"d":"150,000 €"}]
["VRD & Réseaux assainissement",{"$nulls":3},{"v":200000,"d":"200,000 €"}]
["Terrassements / aménagement  routes",{"$nulls":3},{"v":150000,"d":"150,000 €"}]
[]
["Totaux",{"$nulls":3},{"v":4332190,"d":"4,332,190 €"}]
[]
["Programmation architecturale",null,"m²"]
[" habitations et espaces communautaires",null,2918.4]
["3 maisons indépendantes",null,150]
["Habitat léger",null,340]
["Tannière et Antre",null,430]
["Manoir",null,900]
["Chapelloise",null,50]
["Ressourcerie",null,0]
["Hangars agricoles / bergerie",null,600]

{"sheet":"Charges","index":7,"n_rows":80,"n_cols":11,"rows_kept":80,"merged":[[0,0,0,7],[2,2,2,3],[2,4,2,5]],"flags":["formulas_cached_only"]}
["Charges"]
[]
[null,null,"Année 1",null,"Année 5",null,"Année 10"]
[null,0,{"v":7853.12884713805,"d":"7,853 €"},null,{"v":20621.3873349495,"d":"20,621 €"},null,{"v":39487.7629818182,"d":"39,488 €"},"inspiration Choux Lents"]
[null,0,{"v":34043.3333333333,"d":"34,043 €"},null,{"v":45410,"d":"45,410 €"},null,{"v":55500,"d":"55,500 €"},"inspiration Choux Lents"]
[null,0,{"v":73090,"d":"73,090 €"},null,{"v":155720.041666667,"d":"155,720 €"},null,{"v":225969,"d":"225,969 €"}]
[null,"Charges d’exploitation agriculture",{"v":0,"d":"0 €"},null,{"v":9922.22222222222,"d":"9,922 €"},null,{"v":19000,"d":"19,000 €"},"Cf onglet Agri"]
[null,0,{"v":14500,"d":"14,500 €"},null,{"v":20500,"d":"20,500 €"},null,{"v":30080,"d":"30,080 €"}]
[null,0,{"v":10000,"d":"10,000 €"},null,{"v":27101.9047619048,"d":"27,102 €"},null,{"v":32268.5714285714,"d":"32,269 €"}]
[null,0,{"v":500,"d":"500 €"},null,{"v":500,"d":"500 €"},null,{"v":1000,"d":"1,000 €"}]
[null,"Enveloppe pour projets à définir",{"v":5000,"d":"5,000 €"},null,{"v":5000,"d":"5,000 €"},null,{"v":5000,"d":"5,000 €"},"Gérée par les éclaireur·euses"]
[null,"Provisions pour imprévus",{"v":16798.3754616566,"d":"16,798 €"},null,{"v":33573.0667182892,"d":"33,573 €"},null,{"v":48396.6401292468,"d":"48,397 €"},0.12,"L’impermanence du monde…"]
[null,"Totaux",{"v":161784.837642128,"d":"161,785 €"},null,{"v":318348.622704032,"d":"318,349 €"},null,{"v":456701.974539636,"d":"456,702 €"}]
[]
["Détails"]
[null,"% d’adultes par rapport à année 10",{"v":0.166666666666667,"d":"17 %"},null,{"v":0.522222222222222,"d":"52 %"},null,{"v":1,"d":"100 %"}]
[]
["Energie et eau"]
[null,"Electricité (Abo & conso)",{"v":4055.30898181819,"d":"4,055 €"},null,{"v":12706.634809697,"d":"12,707 €"},null,{"v":24331.8538909091,"d":"24,332 €"},"Inspiration Choux Lents - coef 70 %",null,358.348363636364,"par adulte"]
[null,"Gaz (Abo & conso)",{"v":2000,"d":"2,000 €"},"chaudière fioul au début",{"v":1657.81818181818,"d":"1,658 €"},null,{"v":3174.54545454545,"d":"3,175 €"},"inspiration Choux Lents",null,32.7272727272727,"par adulte"]
[null,"Carburant pour machines",{"v":217.592592592593,"d":"218 €"},null,{"v":1305.55555555556,"d":"1,306 €"},null,{"v":2500,"d":"2,500 €"}]
[null,"Bûches locales",{"$nulls":4},{"v":0,"d":"0 €"}]
[null,"Complément achat granulés",{"v":500,"d":"500 €"},null,{"v":1566.66666666667,"d":"1,567 €"},null,{"v":3000,"d":"3,000 €"}]
[null,"Eau (Abo & conso)",{"v":1080.22727272727,"d":"1,080 €"},null,{"v":3384.71212121212,"d":"3,385 €"},null,{"v":6481.36363636364,"d":"6,481 €"},"Inspiration Choux Lents - coef 70 %",null,95.4545454545455,"par adulte"]
["Total",null,{"v":7853.12884713805,"d":"7,853 €"},null,{"v":20621.3873349495,"d":"20,621 €"},null,{"v":39487.7629818182,"d":"39,488 €"}]
[]
["Charges générales"]
[null,"Assurance habitation",{"v":1500,"d":"1,500 €"},null,{"v":4700,"d":"4,700 €"},null,{"v":9000,"d":"9,000 €"},"doigt mouillé"]
[null,"Frais administratifs & bancaires",{"v":833.333333333333,"d":"833 €"},null,{"v":2611.11111111111,"d":"2,611 €"},null,{"v":5000,"d":"5,000 €"}]
[null,"Système d’information : outils numériques et hébergements",{"v":333.333333333333,"d":"333 €"},null,{"v":1044.44444444444,"d":"1,044 €"},null,{"v":2000,"d":"2,000 €"}]
[null,"Usages communs des véhicules",null,null,{"v":4400,"d":"4,400 €"},null,{"v":4400,"d":"4,400 €"},"2AR / sem ville à 30km + 5000km  appro / utilitaires maintenance / déchet’"]
[null,"Taxe foncière",{"v":15000,"d":"15,000 €"},null,{"v":15000,"d":"15,000 €"},null,{"v":15000,"d":"15,000 €"},"Au pif !"]
[null,"Impôts / société",null,null,{"v":500,"d":"500 €"},null,{"v":1000,"d":"1,000 €"},"On gère pour qu’il n’y ait pas / peu de bénéfice"]
[null,"Maintenance chaudière",{"v":750,"d":"750 €"},null,{"v":2350,"d":"2,350 €"},null,{"v":4500,"d":"4,500 €"},"500€ par chaudière"]
[null,"Maintenance autre équipements",null,null,{"v":1044.44444444444,"d":"1,044 €"},null,{"v":2000,"d":"2,000 €"},"Dont 1000€ ascenseur"]
[null,"Réparations diverses",{"v":626.666666666667,"d":"627 €"},null,{"v":3760,"d":"3,760 €"},null,{"v":7200,"d":"7,200 €"}]
[null,"Achat équipements communs",{"v":15000,"d":"15,000 €"},null,{"v":10000,"d":"10,000 €"},null,{"v":5400,"d":"5,400 €"},"Électroménager / systèmes vidéo & hifi / systèmes sécurité / mobilier spécifique / bureautique"]
[null,"Dépenses",{"v":34043.3333333333,"d":"34,043 €"},null,{"v":45410,"d":"45,410 €"},null,{"v":55500,"d":"55,500 €"}]
[]
["Alimentation"]
[null,"nb jours d’absence moyen par personne",{"$nulls":4},43,"Un WE par mois + 3 semaines par an"]
[null,"Nb repas consommés sur place","internes",null,"internes",null,"internes","avec activités"]
[null,"Loup·ves & Louveteaux adultes",9390,null,{"v":31710.3777777778,"d":"31710"},null,60722,60722]
[null,"Enfants",1878,null,{"v":5394.03333333333,"d":"5394"},null,10329,10329,"Les ptis loups comptent pour 1/2 repas (moyenne)"]
[null,"Invité·es et woofeur·euses",600,null,{"v":2230.93333333333,"d":"2231"},null,4272,4272,"6 invité·es en moyenne"]
[null,"Accueil",2750,"en moyenne 3 personnes sur l’année + 5 personnes l’été",2190,"en moyenne 3 personnes sur l’année",null,6281.5]
[null,"Guinguette",{"$nulls":5},240]
[null,"Totaux",14618,null,{"v":41525.3444444445,"d":"41525"},null,75323,81844.5]
[]
[null,"Nombre de bouches à nourrir en moyenne",{"$nulls":4},{"v":105.790730337079,"d":"106"},{"v":114.950140449438,"d":"115"}]
[null,"coût du repas (sans autoproduction)",{"v":5,"d":"5.00 €"},null,{"v":5,"d":"5.00 €"},null,{"v":5,"d":"5.00 €"},"Régime bio, peu carné ; achats en gros\nLes ptis dej & produits d’entretien sont compris dedans (inspiration Choux Lents)"]
[null,"Part d’autoproduction",{"v":0,"d":"0 %"},null,{"v":0.25,"d":"25 %"},null,{"v":0.4,"d":"40 %"},"Considérant tout ce qui est produit sur place. \nÉlément important dans le modèle économique. \nLe régime alimentaire y joue pour beaucoup."]
[null,"Coût du repas réel",{"v":5,"d":"5 €"},null,{"v":3.75,"d":"4 €"},null,{"v":3,"d":"3 €"}]
[null,"Dépenses internes",{"v":73090,"d":"73,090 €"},null,{"v":155720.041666667,"d":"155,720 €"},null,{"v":225969,"d":"225,969 €"},"Les dépenses externes (accueil, guiguette) sont comptées dans les onglets d’activités"]
[null,"L’autoproduction économise",{"$nulls":4},{"v":150646,"d":"150,646 €"},"grâce aux",{"v":12413.6,"d":"12414"},"heures passées"]
[{"$nulls":7},"soit",{"v":12.1355609976155,"d":"12.14 €"},"par heure"]
["Prestations externes"]
[null,"Accompagnement externe et médiation",{"v":5000,"d":"5,000 €"},null,{"v":2000,"d":"2,000 €"},null,{"v":3000,"d":"3,000 €"},"Coopération avec la Coopérative Oasis ?"]
[null,"Expertises juridiques",{"v":5000,"d":"5,000 €"},null,{"v":3000,"d":"3,000 €"},null,{"v":1000,"d":"1,000 €"},"Coopération avec la Coopérative Oasis ?"]
[null,"Expertises comptables",{"v":500,"d":"500 €"},null,{"v":5000,"d":"5,000 €"},null,{"v":3000,"d":"3,000 €"}]
[null,"Expertises RH / fiches de paye",{"v":0,"d":"0 €"},null,{"v":5000,"d":"5,000 €"},null,{"v":10080,"d":"10,080 €"},"30€ par fiche de paye (seulement pour les Internes)"]
[null,"Formation collective",{"v":1000,"d":"1,000 €"},null,{"v":2500,"d":"2,500 €"},null,{"v":5000,"d":"5,000 €"},"2 journées par an pour les 2/3 des Loup·ves"]
[null,"Formation des Lycanthropes",{"$nulls":4},{"v":3000,"d":"3,000 €"},"8 jours sur l’année"]
[null,"Formations générales",{"$nulls":4},{"v":0,"d":"0 €"},"sollicitation CPF et OPCO"]
[null,"Autres prestations",{"v":3000,"d":"3,000 €"},null,{"v":3000,"d":"3,000 €"},null,{"v":5000,"d":"5,000 €"}]
[]
[null,"Dépenses",{"v":14500,"d":"14,500 €"},null,{"v":20500,"d":"20,500 €"},null,{"v":30080,"d":"30,080 €"}]
[]
["Amortissements matériel"]
[null,"Véhicules",{"v":4500,"d":"4,500 €"},null,{"v":9833.33333333333,"d":"9,833 €"},null,{"v":15000,"d":"15,000 €"},"1000€ / véhicule en moyenne"]
[null,"Agricoles",null,null,{"v":10768.5714285714,"d":"10,769 €"},null,{"v":10768.5714285714,"d":"10,769 €"},"Cf onglet Agri"]
[null,"Équipement cuisine",{"v":3000,"d":"3,000 €"},null,{"v":2000,"d":"2,000 €"},null,{"v":2000,"d":"2,000 €"},"Achats en seconde main"]
[null,"Chapiteau",{"v":0,"d":"0 €"},null,{"v":2000,"d":"2,000 €"},null,{"v":2000,"d":"2,000 €"}]
[null,"Machines pour activités",{"v":2500,"d":"2,500 €"},null,{"v":2500,"d":"2,500 €"},null,{"v":2500,"d":"2,500 €"}]
[]
[null,"Dépenses",{"v":10000,"d":"10,000 €"},null,{"v":27101.9047619048,"d":"27,102 €"},null,{"v":32268.5714285714,"d":"32,269 €"}]
[]
["Autres charges"]
[null,"Adhésion / cotisation aux réseaux",{"v":500,"d":"500 €"},null,{"v":500,"d":"500 €"},null,{"v":1000,"d":"1,000 €"},"Asso territoriales, etc.+ monde des éco-lieux : HPF, Oasis, GEN, etc."]
[null,"Dépenses",{"v":500,"d":"500 €"},null,{"v":500,"d":"500 €"},null,{"v":1000,"d":"1,000 €"}]

{"sheet":"Agri","index":8,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Agriculture"]
[]
["Surfaces nécessaires"]
[null,"légumineuse"]
[null,"Maraîchage (ha)",{"v":2.93939393939394,"d":"3"},"inspiration Rivoire"]
[null,"Consommation de pain",5044,"Kg / an (inspiration Choux Lents – 1 kg / adulte / semaine)"]
[null,"Blé (ha)",{"v":2.0176,"d":"2"},"1 hectare de blé = 2-3 tonnes de pain"]
[null,"Autre céréales & légumineuse & rotation","?","à creuser"]
[]
["Investissement"]
[null,null,"investissement initial","commentaires","amortissement",null,null,"Quelques chiffres selon terrain :\nRetenue d’eau = 80k€ \nTracteur d’occas = 5k€\nOutillage tracteur = 10k€",null,"Mécanisation : faire les buttes\nBroyer\nTransporter du bois / compost / épandre du fumier"]
[{"$nulls":4},"durée (an)","annuel"]
["Général"]
[null,"Tracteur seconde main",{"v":5000,"d":"5,000 €"},"inspiration Rivoire",5,{"v":1000,"d":"1,000 €"}]
[]
["Besoin maraîchage"]
[null,"Outillage",{"v":10000,"d":"10,000 €"},null,5,{"v":2000,"d":"2,000 €"}]
[null,"Irrigation",{"v":30000,"d":"30,000 €"},"dont système pompage / filtre – tuyaux enterrés",10,{"v":3000,"d":"3,000 €"}]
[null,"Serres d’occas – 1000m² x 12€/m² X 2",{"v":24000,"d":"24,000 €"},"ratio en maraîchage diversifié : 10 % de la surface abritée",7,{"v":3428.57142857143,"d":"3,429 €"}]
[null,"Bâches serres – 1500m²x2",{"v":5000,"d":"5,000 €"},null,5,{"v":1000,"d":"1,000 €"}]
[null,"Poulailler mobile",{"v":1700,"d":"1,700 €"},"1200€ poulailler pour 50 poules+ 500 Abreuvoir / mangeoire",5,{"v":340,"d":"340 €"},"40 œufs quotidien"]
[null,"Hangar",null,"stockage légume longue conservation=> conservés aileurs"]
[]
["Besoin céréales"]
[]
["Besoin bergerie",null,{"v":20000,"d":"20,000 €"},"Équipements, achat des animaux, compléments alimentation, yaourtière, etc.(Le bâtiment est compté dans l’onglet Immo)"]
[]
["Totaux",null,{"v":95700,"d":"95,700 €"},null,null,{"v":10768.5714285714,"d":"10,769 €"}]
[]
["Charges d’exploitation annuelles",{"$nulls":3},"Chiffres Rivoire 2022"]
[null,"Semences plants terreau",{"v":9000,"d":"9,000 €"},null,{"v":9000,"d":"9,000 €"},"(dont 3-4K€ endives & champi)en faisant les 3/4 des plants"]
[null,"Engrais",{"v":1000,"d":"1,000 €"},"car bergerie / autoproduction",{"v":4000,"d":"4,000 €"},"engrais"]
[null,"Petit consommable",{"v":3000,"d":"3,000 €"},"filets anti insecte / voiles thermiques",{"v":3000,"d":"3,000 €"},"filets anti insecte / voiles thermiques"]
[null,"Petit matériel",{"v":1000,"d":"1,000 €"},"pelles beches habits"]
[null,"Fuel",{"v":500,"d":"500 €"}]
[null,"Electricité",{"v":0,"d":"0 €"},"incluse dans les charges générales",{"v":1000,"d":"1,000 €"},"1/2 chambre froide - 1/4 chaud (endive)  - 1/4 irrigation"]
[null,"Entretien / mécanique",{"v":3000,"d":"3,000 €"}]
[]
[null,"Aliments pour les poules",{"v":1500,"d":"1,500 €"},null,{"v":1500,"d":"1,500 €"},"80 % de l’alimentation pour 50 poules"]
[]
["Total",null,{"v":19000,"d":"19,000 €"}]

{"sheet":"Revenus","index":9,"n_rows":46,"n_cols":8,"rows_kept":46,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["Revenus communautaires (année 10)"]
[]
[]
["Activité","Chiffre d’affaire","Temps passé (etp)","Temps passé (h)","Charges","Bénéfices","Rentabilité € / heure"]
["Accueil",{"v":212908.5,"d":"212,909 €"},{"v":5.38076861702128,"d":"5.38"},{"v":10115.845,"d":"10,116"},{"v":23644.5,"d":"23,645 €"},{"v":189264,"d":"189,264 €"},{"v":18.7096579672781,"d":"19 €"}]
["Artisanat",{"v":71064,"d":"71,064 €"},{"v":4.5,"d":"4.50"},{"v":8460,"d":"8,460"},{"v":12436.2,"d":"12,436 €"},{"v":58627.8,"d":"58,628 €"},{"v":6.93,"d":"7 €"}]
["Ressourcerie",{"v":64916.4,"d":"64,916 €"},{"v":3,"d":"3.00"},{"v":5640,"d":"5,640"},{"v":0,"d":"0 €"},{"v":64916.4,"d":"64,916 €"},{"v":11.51,"d":"12 €"}]
["Guinguette (détail ci-dessous)",{"v":6800,"d":"6,800 €"},{"v":0.412765957446809,"d":"0.41"},776,{"v":2462,"d":"2,462 €"},{"v":4338,"d":"4,338 €"},{"v":5.59020618556701,"d":"6 €"}]
[]
["Totaux",{"v":355688.9,"d":"355,689 €"},{"v":13.2935345744681,"d":"13 €"},{"v":24991.845,"d":"24,992"},{"v":38542.7,"d":"38,543 €"},{"v":317146.2,"d":"317,146 €"},{"v":12.689987473914,"d":"13 €"}]
[]
["Locations"]
[null,"mensuel","annuel"]
["Locaux ressourcerie",null,{"v":10000,"d":"10,000 €"}]
["Mobil home maison de naissance",{"v":300,"d":"300 €"},{"v":3600,"d":"3,600 €"}]
["Locaux pour activités externes",{"v":1000,"d":"1,000 €"},{"v":12000,"d":"12,000 €"},null,"4 locaux à 250€"]
["Chapiteau festival & parquet",null,{"v":8000,"d":"8,000 €"},"business qui peut se développer"]
["Totaux",null,{"v":33600,"d":"33,600 €"}]
[]
["Guinguette"]
["nb sessions",8]
["nb personnes extérieures / session",50]
[]
[null,"nb consos / pers","Nb consos années","Prix unitaire","CA / session","CA année","Charges","Bénéf"]
["Boissons",1.5,600,{"v":4,"d":"4 €"},{"v":300,"d":"300 €"},{"v":2400,"d":"2,400 €"},{"v":792,"d":"792 €"},{"v":1608,"d":"1,608 €"}]
["Repas",0.6,240,{"v":10,"d":"10 €"},{"v":300,"d":"300 €"},{"v":2400,"d":"2,400 €"},{"v":720,"d":"720 €"},{"v":1680,"d":"1,680 €"}]
["Produits faits maisons",0.5,200,{"v":10,"d":"10 €"},{"v":250,"d":"250 €"},{"v":2000,"d":"2,000 €"},{"v":400,"d":"400 €"},{"v":1600,"d":"1,600 €"}]
["Total",{"$nulls":4},{"v":6800,"d":"6,800 €"},{"v":1912,"d":"1,912 €"},{"v":4888,"d":"4,888 €"}]
[{"$nulls":3},"Achat moyen par personne",17,"hors chapeau"]
[]
["Charges"]
["Repas boisson produits",{"v":1912,"d":"1,912 €"}]
["consommables",{"v":200,"d":"200 €"}]
["communication",{"v":100,"d":"100 €"}]
["Tables chaises signalétique",{"v":50,"d":"50 €"},"récupe & réutilisation !"]
["Autre",{"v":200,"d":"200 €"}]
["total",{"v":2462,"d":"2,462 €"}]
[]
["Temps passé par session (heures)"]
["Amont",20,"Contacts zikos, créateurs / communication / menus"]
["Fabrication produits maisons ?",30,"Tisanes, Kombucha, Miel, gateaux (enfants)"]
["Jour J",45,"Installation, accueil, désinstallation, etc. 5 personnes sur le pont de 12h à 23h en moyenne"]
["Aval",2,"facturations, etc."]
["Total 1 session",97]
["Total année",776]
["Equivalent temps plein",{"v":0.412765957446809,"d":"0.41"}]

{"sheet":"Accueil","index":10,"n_rows":89,"n_cols":11,"rows_kept":89,"merged":[[0,0,0,11],[7,5,7,8]],"flags":["formulas_cached_only"]}
["Activité d’accueil (année 10)"]
[]
["Activités","Formations courtes","Formations longues","Séjours immersifs","Retraites méditation","Semaines participatives","Festivals","Chantier participatif","Proches en chambre",null,"Totaux"]
["Explications","Elles durent en moyenne 2 jours. Certaines sont dispensées par des Internes","Elles durent en moyenne 7 jours. Certaines sont dispensées par des Internes","Démarrage du processus d’intégration – ce que Célia vit durant 8 jours.","Utilisation des 3 cabanes pour des séjours solo / duo","2 semaines estivales où chaque participant·e peut proposer des activités / ateliers","Dans la zone festival – orga / programmation potentiellement assurée à l’externe","Volontaires (via réseau Twiza par ex.) pour la construction de bâtiments / maisons, etc.","accueil d’amis / familles au Manoir"]
["nb session par an",20,10,4,30,2,3,4,90,null,163]
["nb journées par session",2,7,8,7,7,3,7,2,null,43]
["nb de journées",40,70,32,210,14,9,28,180,null,583]
[{"$nulls":5},"nb jours par an sans accueil extérieur (hors retraites)",{"$nulls":4},172]
["nb participants moyen",10,10,8,1.2,100,150,15,1.5,null,295.7]
["proportion camping / chambre",{"v":0.3,"d":"30 %"},{"v":0.3,"d":"30 %"},{"v":0.3,"d":"30 %"},{"v":0,"d":"0 %"},{"v":0.75,"d":"75 %"},{"v":0.85,"d":"85 %"},{"v":0.5,"d":"50 %"},{"v":0,"d":"0 %"},null,3]
["nb personnes / an",200,100,32,36,200,450,60,135,null,1213]
["nb jours.personnes",400,700,256,252,1400,1350,420,270,null,5048]
["nb nuitées",200,600,224,216,1200,900,360,135,null,3835]
[]
["Coût orga / pédagogique"]
["Coût orga / logistique / pers",{"v":40,"d":"40 €"},{"v":50,"d":"50 €"},{"v":0,"d":"0 €"},{"v":50,"d":"50 €"},{"v":75,"d":"75 €"},{"v":10,"d":"10 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
["   CA orga",{"v":8000,"d":"8,000 €"},{"v":5000,"d":"5,000 €"},{"v":0,"d":"0 €"},{"v":1800,"d":"1,800 €"},{"v":15000,"d":"15,000 €"},{"v":4500,"d":"4,500 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},null,{"v":34300,"d":"34,300 €"}]
["Proportion péda interne",0.15,0.1,1,0.5,0,0,0,0]
["nb de journées péda",6,7,32,105,0,0,0,0]
["coût péda interne / pers / j",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"v":0,"d":"0 €"},{"v":15,"d":"15 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
["   CA pédagogique",{"v":6000,"d":"6,000 €"},{"v":7000,"d":"7,000 €"},{"v":0,"d":"0 €"},{"v":1890,"d":"1,890 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},null,{"v":14890,"d":"14,890 €"}]
["CA orga + pédagogique",{"v":14000,"d":"14,000 €"},{"v":12000,"d":"12,000 €"},{"v":0,"d":"0 €"},{"v":3690,"d":"3,690 €"},{"v":15000,"d":"15,000 €"},{"v":4500,"d":"4,500 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},null,{"v":49190,"d":"49,190 €"}]
[]
["Hébergement camping / camion"]
["Coût camping / nuit",{"v":20,"d":"20 €"},{"v":20,"d":"20 €"},{"v":10,"d":"10 €"},{"v":20,"d":"20 €"},{"v":20,"d":"20 €"},{"v":10,"d":"10 €"},{"v":0,"d":"0 €"},{"v":20,"d":"20 €"}]
["Nb nuitées camping",60,180,67.2,0,900,765,180,0,null,2152.2]
["CA camping",{"v":1200,"d":"1,200 €"},{"v":3600,"d":"3,600 €"},{"v":672,"d":"672 €"},{"v":0,"d":"0 €"},{"v":18000,"d":"18,000 €"},{"v":7650,"d":"7,650 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},null,{"v":31122,"d":"31,122 €"}]
[]
["Hébergement en chambres"]
["Coût chambre / nuit / pers",{"v":50,"d":"50 €"},{"v":50,"d":"50 €"},{"v":30,"d":"30 €"},{"v":40,"d":"40 €"},{"v":50,"d":"50 €"},{"v":40,"d":"40 €"},{"v":0,"d":"0 €"},{"v":10,"d":"10 €"}]
["Nb de personnes à loger lors d’une session",7,7,5.6,1.2,25,22.5,7.5,1.5]
["Nb nuitées chambre / an",140,420,156.8,216,300,135,180,135,null,1682.8]
["Nb nettoyages de chambre",140,70,22.4,36,50,67.5,30,135,null,550.9]
["CA chambres",{"v":7000,"d":"7,000 €"},{"v":21000,"d":"21,000 €"},{"v":4704,"d":"4,704 €"},{"v":8640,"d":"8,640 €"},{"v":15000,"d":"15,000 €"},{"v":5400,"d":"5,400 €"},{"v":0,"d":"0 €"},{"v":1350,"d":"1,350 €"},null,{"v":63094,"d":"63,094 €"}]
[]
["Restauration"]
["% de pers qui mangent",1,1,1,0.5,0.6,0.5,1,0.5]
["Nb de repas",{"v":600,"d":"600 €"},{"v":1300,"d":"1,300 €"},{"v":480,"d":"480 €"},{"v":234,"d":"234 €"},{"v":1560,"d":"1,560 €"},{"v":1125,"d":"1,125 €"},{"v":780,"d":"780 €"},{"v":202.5,"d":"203 €"},null,{"v":6281.5,"d":"6,282 €"}]
["Prix unitaire du repas",15,15,5,15,12,10,0,5]
["CA repas",{"v":9000,"d":"9,000 €"},{"v":19500,"d":"19,500 €"},{"v":2400,"d":"2,400 €"},{"v":3510,"d":"3,510 €"},{"v":18720,"d":"18,720 €"},{"v":11250,"d":"11,250 €"},{"v":0,"d":"0 €"},{"v":1012.5,"d":"1,013 €"},null,{"v":65392.5,"d":"65,393 €"}]
[]
["Buvette / snack bio"]
["Dépenses / jour / participant·e",{"$nulls":4},6,9]
["Taux de marge",{"$nulls":4},{"v":0.2,"d":"20 %"},{"v":0.2,"d":"20 %"}]
["Marges sur buvettes",{"$nulls":4},{"v":1680,"d":"1,680 €"},{"v":2430,"d":"2,430 €"}]
[]
["CA total",{"v":31200,"d":"31,200 €"},{"v":56100,"d":"56,100 €"},{"v":7776,"d":"7,776 €"},{"v":15840,"d":"15,840 €"},{"v":68400,"d":"68,400 €"},{"v":31230,"d":"31,230 €"},{"v":0,"d":"0 €"},{"v":2362.5,"d":"2,363 €"},null,{"v":212908.5,"d":"212,909 €"}]
[null,{"v":0.146541824304807,"d":"15 %"},{"v":0.263493472548066,"d":"26 %"},{"v":0.0365227315959673,"d":"4 %"},{"v":0.0743981569547482,"d":"7 %"},{"v":0.321264768668231,"d":"32 %"},{"v":0.1466827299051,"d":"15 %"},{"v":0,"d":"0 %"},{"v":0.0110963160230803,"d":"1 %"}]
[]
["€ / pers hors péda (camping)",{"v":120,"d":"120 €"},{"v":380,"d":"380 €"},{"v":150,"d":"150 €"},{"v":380,"d":"380 €"},{"v":363,"d":"363 €"},{"v":90,"d":"90 €"},{"v":0,"d":"0 €"},{"v":40,"d":"40 €"}]
["€ / pers hors péda (chambre)",{"v":150,"d":"150 €"},{"v":560,"d":"560 €"},{"v":290,"d":"290 €"},{"v":500,"d":"500 €"},{"v":543,"d":"543 €"},{"v":150,"d":"150 €"},{"v":0,"d":"0 €"},{"v":30,"d":"30 €"}]
["€ TTC / pers hors péda (camping)",{"v":144,"d":"144 €"},{"v":456,"d":"456 €"},{"v":180,"d":"180 €"},{"v":456,"d":"456 €"},{"v":435.6,"d":"436 €"},{"v":108,"d":"108 €"},{"v":0,"d":"0 €"},{"v":48,"d":"48 €"}]
["€ TTC / pers hors péda (chambre)",{"v":180,"d":"180 €"},{"v":672,"d":"672 €"},{"v":348,"d":"348 €"},{"v":600,"d":"600 €"},{"v":651.6,"d":"652 €"},{"v":180,"d":"180 €"},{"v":0,"d":"0 €"},{"v":36,"d":"36 €"}]
[]
[]
["Temps passé",{"v":5.38076861702128,"d":"5.38"},"etp"]
["postes","nb h","tâches"]
["Coordination meute",260,"1h / semaine à 5"]
["Responsable logistique & pédagogique (pour les formations)",396,"Préparation : lien formateur, installation salle & matériel => 8h / formation Participation à la formation / échange / essaimage 4h/formationMise à jour supports pédagogiques : 3h/mois"]
["Secrétariat",240,"accueil physique & tel, paiement, admin, répartition chambre => 8h / formation"]
["Accueil retraites",{"v":172.5,"d":"173"},"4h / pers pour l’accueil30 min / jour en moyenne pour les méditant·es qui le souhaitent"]
["Chargé·e de comm / outils en ligne=> pour tous les accueils",{"v":1880,"d":"1,880"},"Communication / média sociaux / suivi inscriptions en ligneParticipation à des forums / événements"]
["Gestion camping et chambres",400,"Ouverture / clôture et amélioration du camping (entretien terrain, sanitaires, etc)Suivi normes accueil"]
["Nettoyages",{"v":1371.8,"d":"1,372"},"Chambres & lavage draps (2h / chambre) + sanitaires (3h / semaine) + camping (6h/ sem sur 5 mois)"]
[]
["Orga festival"]
["Responsable logistique et financier",{"v":2496,"d":"2,496"},"lien artistes, recherche sub, logistique, location matériel (4 pers y travaillent un mois en amont et pendant et après +30%)"]
["Gestion des repas",270,"Approvisionnement, coordination des bénévoles, aménagement cuisine d’été, etc. => 2 Loup·ves à temps plein durant chaque festival + 2 jours"]
[]
["Orga semaines participatives"]
["resp logistique & péda formation",{"v":1020,"d":"1,020"},"lien proposants, logistique, location matériel (2 mois de travail à une personne + 5 personnes temps plein pendant"]
["Gestion des repas",324,"Approvisionnement, coordination des bénévoles, aménagement cuisine d’été, etc. => 2 Loup·ves à temps plein durant chaque festival + 2 jours"]
[]
["Autre / imprévus",{"v":1285.545,"d":"1,286"},{"v":0.15,"d":"15 %"}]
[]
["Total heures",{"v":10115.845,"d":"10,116"},{"v":5.38076861702128,"d":"5.4"},"ETP"]
[]
["Charges courantes",{"v":23644.5,"d":"23,645 €"}]
["Repas",{"v":18844.5,"d":"18,845 €"},"Coût réel du repas pris en compte"]
["Matériel d’entretien",{"v":500,"d":"500 €"}]
["Entretien chambres",{"v":1000,"d":"1,000 €"}]
["Remplacement literie / drap",{"v":500,"d":"500 €"}]
["Achat – entretien équipement salles formation",{"v":500,"d":"500 €"}]
["Impressions",{"v":200,"d":"200 €"}]
["Bureautique",{"v":300,"d":"300 €"}]
["Communication / hbgt site web spécifique",{"v":300,"d":"300 €"}]
["Autre",{"v":1500,"d":"1,500 €"}]
[]
["total",{"v":23644.5,"d":"23,645 €"}]

{"sheet":"Art.","index":11,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,0,0,8]],"flags":["formulas_cached_only"]}
["Artisanats / Valorisation"]
[]
["Données d’entrées"]
["Temps passé (etp)",4.5]
["Nb heures",8460]
["Rentabilité par défaut",8,"/ h","(SMIC horaire net 2023 : 9,12€)"]
[null,null,"La rentabilité s’est améliorée par rapport aux premières annéesMutualisation de la vente pour tous les objets de la communauté"]
["Taux de charge par défaut",{"v":0.1,"d":"10 %"}]
[]
["Activités","  % temps","etp","Taux horaire","CA","Tx Charges","Charges","Bénéfices"]
["Fabrication d’objets d’art pour la vente",{"v":0.3,"d":"30 %"},1.35,8,{"v":20304,"d":"20,304 €"},{"v":0.1,"d":"10 %"},{"v":2030.4,"d":"2,030 €"},{"v":18273.6,"d":"18,274 €"},"Poterie, peinture, sculpture, vitraux Céramique à partir d'assiettes cassées Créations textiles, bijoux Sculptures en métal Relooking de mobilier / vêtements"]
["Fabrication d’objets d’art pour la communauté",{"v":0.1,"d":"10 %"},0.45,0,{"v":0,"d":"0 €"},{"v":0.1,"d":"10 %"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
["Construction et location fleur de tri + sensibilisation",{"v":0.2,"d":"20 %"},0.9,7,{"v":11844,"d":"11,844 €"},{"v":0.1,"d":"10 %"},{"v":1184.4,"d":"1,184 €"},{"v":10659.6,"d":"10,660 €"}]
["Customisation mobilier pour la ressourcerie",{"v":0.1,"d":"10 %"},0.45,4,{"v":3384,"d":"3,384 €"},{"v":0.1,"d":"10 %"},{"v":338.4,"d":"338 €"},{"v":3045.6,"d":"3,046 €"}]
["Création et location scénographie",{"v":0.3,"d":"30 %"},1.35,14,{"v":35532,"d":"35,532 €"},{"v":0.25,"d":"25 %"},{"v":8883,"d":"8,883 €"},{"v":26649,"d":"26,649 €"}]
[]
["Totaux",1,4.5,null,{"v":71064,"d":"71,064 €"},null,{"v":12436.2,"d":"12,436 €"},{"v":58627.8,"d":"58,628 €"}]
[]
["Charges :","Coût matière"]
[null,"amortissement machines"]
[null,"Entretien / achat des outils"]
[]
["Ventes :","Marché artisanal \"La guingette des Loups\""]
[null,"Expo Hall du Manoir"]
[null,"Divers salons régionaux"]

{"sheet":"Ress.","index":12,"n_rows":83,"n_cols":10,"rows_kept":83,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["Ressourcerie – 4ème année d’activité"]
[]
["Structure juridique : association indépendante de Loutopia\nModèle économique non finalisé\nHypothèse : La ressourcerie paye des Loup·ves (prestation de la coopérative) pour travailler à la\nRessourcerie en parallèle des personnes en insertion"]
[3,"Etp – Loup·ves y travaillent"]
[11.51,"taux horaire brut (SMIC)"]
[64916.4,"Montant de la prestation annuelle",{"$nulls":7},"Enjeux de la Ressourcerie Loutopia"]
[{"$nulls":9},"Les aides emploi concernent également l’encadrement => quid des Loup·ves => Direction Loup statut externe"]
[{"$nulls":9},"Quid du bénévolat extérieur (très important dans les modèles de ressourceries)"]
["4 domaines d’activités :","Sensibilisation",{"$nulls":7},"Travail des Loup·ves en concurrence avec CDDI ?"]
[null,"Compta"]
[null,"réparation",{"$nulls":7},"Insertion par l’activité économique : 60 % des ressourceries ont l’agrément atelier chantier d’insertion :  (ACI)"]
[null,"Collecte",{"$nulls":7},"Dont travailleurs handicapés, + de 50 ans, RSA…"]
[]
["CA","Chiffre d’affaire",100000]
[null,"panier moyen",10]
[]
["investissement"]
[null,"véhicule, outils, stockage, matériel",70000]
[null,"financement collectivité",0.5]
[]
["charges",null,null,"découpage standard"]
[null,"charges salariales",0.8]
[null,"location",0.1,"'=> faible loyer de 10k€ pour Loutopia"]
[null,"achats",0.1]
[]
["recettes","Hors IAE","ACI"]
[null,"répartition N+3","répartition N+3"]
[null,0.4,0.15,"ventes réemploi"]
[null,0.05,0.05,"ventes matières"]
[null,0.1,0.05,"sensibilisation"]
[null,0.1,0.05,"autre presta (débarras, livraison)"]
[null,0.35,0.7,"sub publiques"]
[null,1,1]
[]
[]
["collecte",null,"contractualisation avec collectivité",null,null,"Catégorie objets collectés"]
[null,"tonne de déchets pour ACI :",450,null,null,"textile, accessoire",0.28]
[null,"apport volontaire",0.66,null,null,"mobilier",0.22]
[null,"collecte à domicile",0.2,null,null,"livre",0.13]
[{"$nulls":5},"matériel électrique",0.1]
[{"$nulls":5},"vaisselle",0.07]
[{"$nulls":5},"bibelots, quincaillerie",0.07]
["postes",null,"etp",null,null,"autre",0.13]
[null,"direction",1,"Clarisse"]
[null,"coordi",1]
[null,"(ACI) accompagnement socio pro",0.5,"accompagnement individuel et collectif"]
[null,"(ACI encadrement technique",1]
[null,"CDDI",5,"16 personnes sur l’année, en moyenne 6 mois,"]
[{"$nulls":3},"60 – 80 % de « sortie dynamique »"]
["Coût personnel"]
["personnel insertion","Coût",96000]
[null,"aides",-95000,"Etat + département"]
["Encadrement","Coût",56000,"Dont des mi temps…"]
[null,"aides",-22000]
[]
[null,"Total",35000]
[]
["Immobilier"]
[null,null,"Ressourcerie & artisanat","surface (m²)","RDC","R+1"]
[null,"Ressourcerie","boutique",155,155]
[null,null,"vente artisanat",15,15]
[]
[null,null,"zone stockage & tri",85,85]
[null,null,"atelier mobilier",65,65]
[null,null,"Sanitaire & vestiaire",60,null,60]
[null,null,"Bureaux ressourcerie",25,null,25]
[null,"Mutualisé","Salle de reunion",30,null,30]
[null,null,"Espace coworking",50,null,50]
[null,null,"Atelier artistique « sale »",60,60]
[null,null,"Atelier artistique « propre »",60,null,60]
[null,null,"zone de stockage scénographie",100,50,50]
[null,null,"Couloirs / zones perdues",80,50,30]
[]
[{"$nulls":3},785,480,305]
[]
[]
[]
["Sources de rapports d’activité (merci !)"]
[null,"http://ressourceriespaca.fr/wp-content/uploads/2020/01/Guide-cr%C3%A9er-ressourceries-ARR-Ademe-RegionSud.pdf"]
[null,"https://www.resistes.org/sites/default/files/upload/files/notre_rapport_dactivite_2021.pdf",{"$nulls":5},"grosse structure"]
[null,"https://imaj95.fr/wp-content/uploads/2022/03/RA-2020-RESSOURCERIE.pdf",{"$nulls":5},"IMAJ"]
[null,"https://v-assets.cdnsw.com/fs/Root/eu92p-Rapport-d-activite-2020-de-la-recyclerie.pdf"]
[null,"https://www.lesateliersligeteriens.org/wp-content/uploads/2019/06/190522_LALR_rapport-dactivit%C3%A9s-2018.pdf"]

{"sheet":"Chrono","index":13,"n_rows":40,"n_cols":17,"rows_kept":40,"merged":[[0,0,0,8],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,9,3,10],[3,15,3,16],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,9,4,10],[4,15,4,16],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,9,5,10],[6,2,6,3],[6,4,6,5],[6,6,6,7],[6,9,6,10],[8,2,8,3],[9,2,9,3],[9,4,9,5],[9,9,9,10],[10,1,11,1],[10,2,10,3],[10,4,10,5],[10,10,10,11],[10,12,10,14],[10,16,10,17],[11,6,11,7],[11,8,11,10],[11,12,11,13],[11,14,11,16],[12,2,12,3],[12,4,12,5],[12,6,12,7]],"flags":["formulas_cached_only"]}
["Chronologie des 10 premières années – avec équilibres financiers grosse maille"]
[]
[]
[null,null,"Année 1",null,"Année 2",null,"Année 3",null,"Année 4","Année 5",null,"Année 6","Année 7","Année 8","Année 9","Année 10"]
[null,"Nb Loup·ves adultes",15,null,23,null,31,null,39,47,null,55,63,71,79,90]
[null,"Généralités","1ère Installation / observation terrain / hébergement au manoir + HL / équilibre éco",null,"Démarrage jardin 1er festivalDémarrage semaines immersives ++",null,"Festival Oasis recherches subs",null,null,"10ème naissance à la maison",null,"développement mutuelle nationale pour fonds de réserve","achat du 10ème véhicule",{"$nulls":3},"Fête 10 ans"]
[null,"Travail / Activités","100 % partage de revenusInstallation campingEt guinguettes estivales",null,"début artisanat / récupe",null,"Début activité  accueil",null,"Début projet ressourcerie"," maison de naissance",null,"démarrage ressourcerie"]
[]
["Réhab & construction"]
[null,null,"conception globale + investissement dans les outil de chantier",null,"Achat pelleteuse",{"$nulls":4},"Pic de chantier participatif !"]
[null,"Maisons","conception pigeonnier + démarrage tx",null,"Pigeonnier (réno)",{"$nulls":5},"Bergerie",null,"Cloître (réno)",{"$nulls":3},"7ème maison"]
[{"$nulls":6},"conception orangerie",null,"Orangerie (réno)",{"$nulls":3},"Moulin",null,"Belvédère"]
[null,"Autres bâtiments communautaires","Tanière : Cuisine et salon",null,"Achat pelleteuse",null,"Construction AntreRafraîchissement manoir",{"$nulls":3},"Tavaux ressourcerie"]
[]
["Louves et Loups"]
[null,"% internes",{"v":0.5,"d":"50 %"},"Sans salaire Chômage / rentes moyen : 1000€",{"v":0.5,"d":"50 %"},"Sans salaire Chômage / rente moyen : 1000€",{"v":0.2,"d":"20 %"},null,null,{"v":0.27,"d":"27 %"},{"$nulls":5},{"v":0.311111111111111,"d":"31 %"}]
[null,"nb internes",{"v":7.5,"d":"750 %"},null,{"v":11.5,"d":"1150 %"},null,{"v":6.2,"d":"620 %"},null,null,{"v":12.69,"d":"1269 %"},{"$nulls":5},{"v":28,"d":"2800 %"}]
[null,"% médians",{"v":0,"d":"0 %"},{"$nulls":3},{"v":0.25,"d":"25 %"},null,null,{"v":0.2,"d":"20 %"},{"$nulls":5},{"v":0.2,"d":"20 %"}]
[null,"% partiels",{"v":0.3,"d":"30 %"},"Ramènent 800€ + mi temps Loutopie",{"v":0.3,"d":"30 %"},null,{"v":0.24,"d":"24 %"},null,null,{"v":0.21,"d":"21 %"},{"$nulls":5},{"v":0.211111111111111,"d":"21 %"}]
[null,"% externes",{"v":0.2,"d":"20 %"},"Ramènent 2k€ / mois + 20 % etp Loutopie",{"v":0.2,"d":"20 %"},"Ramènent 1,5k€ / mois + 20 % etp pour Loutopie",{"v":0.31,"d":"31 %"},"1 an obligatoire de revenus partagés pour les nouveaux arrivants soit 1 an interne sans revenus",null,{"v":0.32,"d":"32 %"},{"$nulls":5},{"v":0.277777777777778,"d":"28 %"}]
[null,"Nb etp travail",10.35,null,15.87,null,15.4566,null,null,25.7607,{"$nulls":5},54.6]
[null,"Nb enfants",6,null,9.2,null,12.4,null,null,18.8,{"$nulls":5},30]
[]
["Recettes"]
[null,"Redevances",{"v":205200,"d":"205,200 €"},null,{"v":287040,"d":"287,040 €"},null,{"v":218587.2,"d":"218,587 €"},null,null,{"v":278616,"d":"278,616 €"},{"$nulls":5},{"v":533150.48,"d":"533,150 €"}]
[null,"Revenus activités",{"v":0,"d":"0 €"},{"$nulls":3},{"v":42581.7,"d":"42,582 €"},"20 % d’accueil",null,{"v":149092.65,"d":"149,093 €"},"act. Accueil 50 % de Année 10 Artisanat 60 % année 10",{"$nulls":4},{"v":355688.9,"d":"355,689 €"}]
[null,"Autres",{"v":0,"d":"0 €"},{"$nulls":3},{"v":20000,"d":"20,000 €"},"Subvention",null,{"v":20000,"d":"20,000 €"},"Subvention",{"$nulls":4},{"v":33600,"d":"33,600 €"}]
[]
["Dépenses"]
[null,"Salaires",{"v":0,"d":"0 €"},{"$nulls":3},{"v":0,"d":"0 €"},null,null,{"v":0,"d":"0 €"},{"$nulls":5},{"v":296304.768,"d":"296,305 €"}]
[null,"Annualités foncier / travaux",{"v":3760,"d":"3,760 €"},{"$nulls":3},{"v":10747.4275,"d":"10,747 €"},null,null,{"v":21494.855,"d":"21,495 €"},"pas de prêt bancaire",{"$nulls":4},{"v":87370.9855365555,"d":"87,371 €"}]
[null,"Charges",{"v":161784.837642128,"d":"161,785 €"},{"$nulls":3},{"v":240066.73017308,"d":"240,067 €"},"moyenne entre année 1 et 5",null,{"v":318348.622704032,"d":"318,349 €"},"cf onglet charges",{"$nulls":4},{"v":456701.974539636,"d":"456,702 €"}]
[null,"Charges accueil",{"v":0,"d":"0 €"},{"$nulls":3},{"v":9641.985,"d":"9,642 €"},null,null,{"v":19283.97,"d":"19,284 €"},{"$nulls":5},{"v":38542.7,"d":"38,543 €"}]
[]
["Résultat",null,{"v":39655.1623578721,"d":"39,655 €"},{"$nulls":3},{"v":20712.7573269199,"d":"20,713 €"},null,null,{"v":88581.2022959677,"d":"88,581 €"},{"$nulls":5},{"v":43518.9519238086,"d":"43,519 €"}]
[]
[]
[]
[null,"Nota : Avant la première année :"]
[null,"construction valeur / gouv / modèle juridique financier"]