{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Camp «familial» 2019"],"not_rendered":{"images":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Camp «familial» 2019","index":0,"n_rows":40,"n_cols":54,"rows_kept":40,"merged":[[1,3,3,6],[1,7,2,8],[1,10,3,12],[1,39,1,40],[1,41,1,44],[2,39,2,40],[3,39,3,40],[4,10,5,12],[4,39,4,40],[5,39,5,40],[6,10,8,12],[6,39,6,40],[7,39,7,40],[8,1,8,2],[9,1,9,2],[10,10,11,12],[11,2,11,4],[11,6,11,8],[11,14,15,19],[12,4,12,8],[13,1,13,2],[13,3,13,4],[13,7,13,8],[13,10,14,12],[14,1,14,2],[14,3,14,4],[14,7,14,8],[15,1,15,2],[15,3,15,4],[15,7,15,8],[16,1,16,2],[16,3,16,4],[16,7,16,8],[16,10,17,12],[17,1,17,2],[17,3,17,4],[17,7,17,8],[18,1,18,2],[18,3,18,4],[18,7,18,8],[19,1,19,2],[19,3,19,4],[19,7,19,8],[19,10,22,12],[20,1,20,2],[20,3,20,4],[20,7,20,8],[20,14,26,14],[21,1,21,2],[22,3,22,6],[24,10,28,12],[25,7,28,8],[29,14,36,19],[30,1,30,2],[31,10,33,12],[34,4,34,8],[35,4,35,8],[35,10,39,12],[45,1,45,2],[45,4,45,5],[45,7,45,8],[46,1,46,8],[48,7,48,8],[49,1,49,2],[49,4,49,5],[49,7,49,8],[51,4,51,5],[54,1,54,8],[55,1,55,8],[56,44,56,47]]}
[]
[{"$nulls":3},"Calculateur de cout de séjour CF 2019",{"$nulls":3},"SVP bien lire les instructions avant d'utiliser !",null,null,"Ceci est un modèle Excel. Les formules qui le compose sont normalement inaltérables. Si vous voulez conserver les données produites simplement enregistrer le tout. Pour utiliser un nouoveau formulaire, alors rouvrir le modèle."]
[]
[{"$nulls":53},{"$f":"IF(AND(F5=7,#REF!=3),AX4,IF(AND(F5=5,#REF!=3),AY4,IF(AND(F5=2,#REF!=3),AZ4,IF(AND(F5=7,#REF!=4),AX5,IF(AND(F5=5,#REF!=4),AY5,IF(AND(F5=2,#REF!=4),AZ5,IF(AND(F5=7,#REF!=5),AX6,\" \")))))))","v":{"$error":"#REF!"}}]
[{"$nulls":4},"Forfait :",null,"# nuitées","À partir du :",null,null,"Si vous voulez effacer une entrée, SVP utilisez «Effacez le contenu» avec un «clic» à droite."]
[]
[{"$nulls":7},"Jusqu'au :",{"$f":"IF(F5=7,(I5+7),(IF(F5=5,(I5+5),(IF(F5=2,(I5+2),\"\")))))","v":""},null,"Ce calculateur permet d'évaluer le cout pour un séjour pour une famille en forfait Camp familial au Centre Plein Air l'Étincelle. ",{"$nulls":26},2]
[{"$nulls":4},"En jaune …","cases à remplir directement",{"$nulls":31},5]
[null,"www.cpaetincelle.com",null,null,"En vert …","cases à choix de la liste déroulante",{"$nulls":27},{"$f":"IF(H15=\" \",\" \",IF(H15>0,($I$5-H15)/365.00274))","v":" "},{"$nulls":3},7]
[null,"infos.etincelle@xplornet.com",{"$nulls":31}," ",null,"Chambre #","Jumelage"]
[null,"RESPONSABLE DE LA FAMILLE",{"$nulls":8},"Il s'agit d'abord d'inscrire la durée du séjour en F 5, la date du début du séjour en I 5 (AA/MM/JJ).",{"$nulls":22}," ","À confirmer",1,"OUI",{"$nulls":3},{"$f":"(385-350)/385","v":0.09090909090909091}]
[null,"Prénom :"," ",null,null,"Nom :"," ",{"$nulls":7},"Notez que pour l'évaluation du code de rabais, tous les membres d'une même famille doivent être pris en considération. Parent(s) (selon 1 ou 2 parents) et le ou les enfants de moins de 18 ans, ceci indépendamment qu'ils participent ou non au séjour.",{"$nulls":18}," ","Lien",2,"NON"]
[{"$nulls":33}," ","Père",3,"N/A"]
[null,"Prénom",null,"Nom",null,"Lien","Âge","Date de naissance (aa/mm/jj)",null,null," Ensuite, inscrire prénom et nom des participants de la famille.",{"$nulls":22}," ","Mère",4]
[null,{"$f":"IF(C12=\" \",\" \",C12)","v":" "},null,{"$f":"IF(G12=\" \",\" \",G12)","v":" "},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null," ",{"$nulls":25}," ","Fils",5,"Sexe"]
[{"$nulls":6},{"$f":"IF(H16=\" \",\" \",ROUNDDOWN(AH10,0))","v":" "}," ",{"$nulls":26},"Fille",6,"Homme"]
[{"$nulls":6},{"$f":"IF(H17=\" \",\" \",ROUNDDOWN(AH11,0))","v":" "}," ",null,null,"Les dates de naissances qui sont importantes sont celles des enfants de moins de 4 ans au moment du séjour. ",{"$nulls":22},{"$f":"COUNTIF(G16:G21,\"<=3\")","v":0},null,7,"Femme"]
[{"$nulls":6}," "," ",{"$nulls":8},"Code 3","Code 2","Code 1","Code 0 ",{"$nulls":13},{"$f":"COUNTIF(G16:G21,\">=1\")","v":0},"Enf. de l'homme",null,"Garçon"]
[{"$nulls":6}," "," ",{"$nulls":8},{"v":-0.5,"d":"-50.0%"},{"v":-0.4,"d":"-40.0%"},{"v":-0.15,"d":"-15.0%"},{"v":0,"d":"0%"},{"$nulls":13},{"$f":"AH17-AH18","v":0},"Enf. de la femme",null,"Fille"]
[{"$nulls":3}," ",null,null,{"$f":"IF(H20=\" \",\" \",ROUNDDOWN(AH14,0))","v":" "}," ",null,null,"Le code de rabais en G 28 doit être en lien avec la grille tarifaire. Code 0 = aucun rabais, Code 1 = 15 % de rabais, Code 2 = 40 % de rabais et Code 3 = 50 % de rabais.",{"$nulls":5},"- de","à","à","+ de",{"$nulls":14},"Grand-mère"]
[{"$nulls":3}," ",null,null,{"$f":"IF(H21=\" \",\" \",ROUNDDOWN(AH15,0))","v":" "}," ",{"$nulls":6},"Revenu familial annuel selon le nombre de personnes composant la famille",1,{"$f":"R21-(R21*25%)","v":{"v":18282.75,"d":"18,283 $"}},{"v":24377,"d":"24,377 $"},{"$f":"R21+(R21*25%)","v":{"v":30471.25,"d":"30,471 $"}},{"$f":"S21","v":{"v":30471.25,"d":"30,471 $"}},{"$nulls":14},"Sœur"]
[{"$nulls":15},2,{"v":25855.5,"d":"25,856 $"},{"v":34474,"d":"34,474 $"},{"$f":"R22+(R22*25%)","v":{"v":43092.5,"d":"43,093 $"}},{"v":43092.5,"d":"43,093 $"},{"$nulls":14},"Ami (e)",{"$nulls":3},"7 jours","5jours","2jours",{"$nulls":3},{"$f":"AVERAGE(AP24:AR30)","v":{"v":0.13517930312975637,"d":"13.52%"}}]
[null,"Jumelage :",null,"Si oui, inscrire le # de personnes de plus de 4 ans à jumeler :",{"$nulls":11},3,{"v":31666.5,"d":"31,667 $"},{"v":42222,"d":"42,222 $"},{"v":52777.5,"d":"52,778 $"},{"v":52777.5,"d":"52,778 $"},{"$nulls":13},"Rabais",{"$f":"IF(C28=\" \",\" \",IF(C28=7,AM23,IF(C28=5,AN23,IF(C28=2,AO23,\" \"))))","v":" "},{"$f":"IF(G28=0,0,ROUND((AI27*AK24),0))","v":0},null,null,523,416,183]
[{"$nulls":15},4,{"v":36565.5,"d":"36,566 $"},{"v":48754,"d":"48,754 $"},{"v":60942.5,"d":"60,943 $"},{"v":60942.5,"d":"60,943 $"},{"$nulls":13},{"$f":"IF(AK24=\" \",\" \",D31*AK24*E31)","v":" "},{"$f":"IF(D34=0,\"0\",IF(D34=1,\"0\",IF(D34=2,AL24,IF(D34=3,AL25,IF(D34=4,AL27,IF(D34=5,AL28,IF(D34=6,AL29,IF(D34=7,AL30,\"0\"))))))))","v":"0"},{"$f":"IF(AI27=\" \",\" \",AI27-AJ23)","v":" "},{"$f":"IF($G$28=0,\" \",IF($G$28=1,AJ38,IF($G$28=2,AJ39,IF($G$28=3,AJ40,\"0$\"))))","v":" "},{"$f":"AP24","v":{"v":0.07839388145315487,"d":"7.84%"}},482,383,168,{"$f":"($AM$23-AM24)/$AM$23","v":{"v":0.07839388145315487,"d":"7.84%"}},{"$f":"(AN23-AN24)/AN23","v":{"v":0.07932692307692307,"d":"7.93%"}},{"$f":"(AO23-AO24)/AO23","v":{"v":0.08196721311475409,"d":"8.20%"}},{"$f":"AVERAGE(AP24:AR24)","v":{"v":0.07989600588161068,"d":"7.99%"}}]
[{"$nulls":10},"Si un jumelage (dans une même chambre) est envisagée avec une autre famille (ex. : 2 mamans avec enfants se mettent ensemble pour économiser sur le cout) inscrire le nombre de personnes de plus de 4 ans de la famille qui sera jumelée. ",{"$nulls":4},5,{"v":40881.75,"d":"40,882 $"},{"v":54509,"d":"54,509 $"},{"v":68136.25,"d":"68,136 $"},{"v":68136.25,"d":"68,136 $"},{"$nulls":13},{"$f":"IF(AK25=\" \",\" \",(D32*AK25*E32))","v":" "},{"$f":"IF(AI23=\" \",\" \",IF(D31=0,\" \",ROUND((AI23*AI24),0)))","v":" "},null,{"$f":"IF(D32=0,\" \",IF($G$28=0,\" \",IF($G$28=1,AJ38,IF($G$28=2,AJ39,IF($G$28=3,AJ40,\"0\")))))","v":" "},{"v":0.14722753346080306,"d":"14.72%"},446,355,156,{"$f":"($AM$23-AM25)/$AM$23","v":{"v":0.14722753346080306,"d":"14.72%"}},{"v":0.0731070496083551,"d":"7.31%"},{"v":0.07142857142857142,"d":"7.14%"},{"v":0.09725438483257653,"d":"9.73%"}]
[null,"Demande un rabais:",null,"OUI",null,"Revenu Familial en 2018 :",null,"Choisir le code de rabais de la grille tarifaire qui correspond au revenu familial et au nombre de personnes qui composent la famille. ",{"$nulls":7},6,{"v":44783.25,"d":"44,783 $"},{"v":59711,"d":"59,711 $"},{"v":74638.75,"d":"74,639 $"},{"v":74638.75,"d":"74,639 $"},{"$nulls":16},{"$f":"IF(D33=0,\" \",IF($G$28=0,\" \",IF($G$28=1,AJ38,IF($G$28=2,AJ39,IF($G$28=3,AJ40,\"0\")))))","v":" "}]
[{"$nulls":15},7,{"v":48371.25,"d":"48,371 $"},{"v":64495,"d":"64,495 $"},{"v":80618.75,"d":"80,619 $"},{"v":80618.75,"d":"80,619 $"},{"$nulls":14},{"$f":"IF(AI23=\" \",\" \",IF(D31=\" \",\" \",IF(D31=0,\" \",(AI23-AI25))))","v":" "},{"$f":"IF(AK25=\" \",\" \",D32*E32*AK25)","v":" "},null,{"v":0.20650095602294455,"d":"20.65%"},415,330,145,{"$f":"($AM$23-AM27)/$AM$23","v":{"v":0.20650095602294455,"d":"20.65%"}},{"$f":"(AN25-AN27)/AN25","v":{"v":0.07042253521126761,"d":"7.04%"}},{"$f":"(AO25-AO27)/AO25","v":{"v":0.07051282051282051,"d":"7.05%"}},{"v":0.11581210391567758,"d":"11.58%"}]
[null,"Forfait :",{"$f":"IF(F5=\" \",\" \",IF(F5=0,\" \",F5))","v":" "},null,null,"Code Rabais :",{"$nulls":28},{"$f":"IF(C28=\" \",\" \",IF(C28=7,AM32,IF(C28=5,AN32,IF(C28=2,AO32,\" \"))))","v":" "},{"$f":"IF(G28=\" \",\" \",IF(G28=0,\" \",ROUND((AI28*AK25),0)))","v":" "},{"$f":"IF(AJ24>=176,AJ24,176)","v":" "},{"v":0.2734225621414914,"d":"27.34%"},380,302,133,{"$f":"($AM$23-AM28)/$AM$23","v":{"v":0.2734225621414914,"d":"27.34%"}},{"v":0.08484848484848485,"d":"8.48%"},{"v":0.08275862068965517,"d":"8.28%"},{"v":0.14700988922654382,"d":"14.70%"}]
[{"$nulls":33},{"$f":"(G34*50/100)-D46","v":{"v":0,"d":"0.00 $"}},null,{"$f":"IF(AJ28=\" \",\" \",E32-AJ28)","v":" "},{"$f":"IF(AJ24>=140,AJ24,140)","v":" "},{"v":0.3384321223709369,"d":"33.84%"},346,275,121,{"$f":"($AM$23-AM29)/$AM$23","v":{"v":0.3384321223709369,"d":"33.84%"}},{"v":0.08940397350993377,"d":"8.94%"},{"v":0.09022556390977443,"d":"9.02%"},{"v":0.17268721993021505,"d":"17.27%"}]
[null,"Coûts par personne :",null,"Nb. Pers,","Coût rég./pers.","*Coût réd./pers.","Total rég.","* Rabais-Total","Total - final",{"$nulls":5},"L'Évaluation du cout de séjour lui tiendra compte de seulement les membres de la famille qui eux participeront au séjour, lesquels corresponderont au taux d'occupation de la chambre pendant le séjour, d'où l'importance du jumelage pour les petites familles ou ajout d'une personne seule (ex : grand-maman)",{"$nulls":18},14,null,null,{"$f":"IF(AJ24>=61,AJ24,61)","v":" "},{"v":0.40152963671128106,"d":"40.15%"},313,249,109,{"$f":"($AM$23-AM30)/$AM$23","v":{"v":0.40152963671128106,"d":"40.15%"}},{"v":0.09454545454545454,"d":"9.45%"},{"v":0.09917355371900827,"d":"9.92%"},{"v":0.19841621499191464,"d":"19.84%"}]
[null,"Occupation du # pers. en séjour",null,{"$f":"COUNTIF(B15:C21,\">=a\")-D32","v":0},{"$f":"AI27","v":" "},{"$f":"IF(G28=\" \",\" \",IF(G28=0,0,IF(F5=7,AK28,IF(F5=5,AK29,IF(F5=2,AK30,0)))))","v":0},{"$f":"IF(D31=0,0,D31*E31)","v":0},{"$f":"IF(AK24=\" \",0,(E31-F31)*D31)","v":0},{"$f":"G31-H31","v":0},{"$nulls":24},60,null,null,{"$f":"IF(AJ29>=AM33,AJ29,AM33)","v":" "}]
[null,"# enfant de 3 ans et -",null,{"$f":"COUNTIF(G15:G21,\"<=3\")","v":0},{"$f":"IF(D32=0,\" \",IF(F5=7,AM32,IF(F5=5,AN32,IF(F5=2,AO32,\" \"))))","v":" "},{"$f":"IF(D32=0,0,IF(F5=7,AK31,IF(F5=5,AK32,IF(F5=2,AK33,0))))","v":0},{"$f":"IF(D32=0,\" \",D32*E32)","v":" "},{"$f":"IF(AK25=\" \",0,(E32-F32)*D32)","v":0},{"$f":"IF(D32=0,\" \",G32-H32)","v":" "},null,"Ces personnes jumelées auront un impact sur le cout de séjour des deux familles et ce, selon leur propre % rabais qui lui leur est individuellement attribué. ",{"$nulls":25},{"$f":"IF(AJ29>=AN33,AJ29,AN33)","v":" "},null,125,99,43]
[null,"# enfant de moins de 12 mois (0$)",null,{"$f":"COUNTIF(AH9:AH15,\"<=1\")","v":0},{"$f":"-IF(D33=0,0,IF(F5=7,AM32,IF(F5=5,AN32,IF(F5=2,AO32,\" \"))))","v":0},{"$f":"IF(F32=\" \",\" \",-IF(D33=0,0,IF(F5=7,AK31,IF(F5=5,AK32,IF(F5=2,AK33,0)))))","v":0},{"$f":"IF(D33>0,(D33*E33),0)","v":0},{"$f":"IF(AK26=\" \",0,(E33-F33)*D33)","v":0},{"$f":"IF(D33=0,\" \",G33-H33)","v":" "},{"$nulls":26},{"$f":"IF(D31>3,3,D31)","v":0},{"$f":"IF(AJ29>=AO33,AJ29,AO33)","v":" "},null,{"$f":"ROUNDUP(AM32/2,0)","v":63},{"$f":"ROUNDUP(AN32/2,0)","v":50},22]
[null,"# personnes de 4 ans et + jumelées",null,{"$f":"IF(D31=0,\" \",(D31+H23))","v":" "},null,null,{"$f":"SUM(G31:G33)","v":0},{"$f":"SUM(H31:H33)","v":0},{"$f":"SUM(I31:I33)","v":0}]
[]
[{"$nulls":10},"Enfin, si l'organisme octroi un montant $ de réduction aux familles participantes, alors veuillez l'ajouter en E 38 et alors le cout à payer par la famille en sera réduit d'autant … le résultat final en E 40",{"$nulls":23}," "]
[null,"Cout de séjour pour la famille :",null,null,{"$f":"I34","v":0},{"$nulls":29},0,{"v":0,"d":"0.0%"}]
[null,"Réduction offerte par l'organisme",{"$nulls":32},1,{"v":0.15,"d":"15.0%"}]
[{"$nulls":34},2,{"v":0.4,"d":"40.0%"}]
[null,"Cout à payer par la famille :",null,null,{"$f":"E37-E38","v":0},{"$nulls":29},3,{"v":0.5,"d":"50.0%"}]