{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calcul env. achat-construction","Annexe II","Superficie","Annexe III","Annexe IV","Menu déroulant"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calcul env. achat-construction","index":0,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,3,10,5],[1,0,1,1],[2,0,2,1]]}
["Financement achat construction - acquisition"]
["Insérer dans l'espace en vert votre nombre de places totales, votre nombre de places poupons ainsi que votre région et le calcul se fera automatiquement."]
["Exemple fait pour un CPE de 80 places, dont 15 poupons, comprenant une salle multifonctionnelle, situé dans le Bas-Saint-Laurent"]
[]
["Nombre de places totales",80]
["Nombre de place 18 mois ou moins (poupons)",10]
["Région","Saguenay–Lac-Saint-Jean"]
["Salle multifonctionnelle","non"]
["Montant de base",{"$f":"VLOOKUP('Calcul env. achat-construction'!B5,'Annexe II'!A4:B83,2,FALSE)","v":1181052}]
["Montant poupon",{"$f":"B6*4670","v":46700}]
["Salle multifonctionnelle",{"$f":"VLOOKUP(B5,'Annexe III'!A4:B83,2,FALSE)","v":124267}]
["Sous-total avant indice régional de modulation ",{"$f":"IF(B8=\"oui\",B9+B10+B11,B9+B10)","v":1227752}]
[]
["Indice régional de modulation",{"$f":"VLOOKUP(B7,'Annexe IV'!A4:B27,2,FALSE)","v":1.05}]
[]
["Enveloppe maximale achat construction",{"$f":"B12*B14","v":1289139.6000000001}]
[]
["Enveloppe aménagement extérieur",{"$f":"0.07*B16","v":90239.772000000012}]
[]
["Enveloppe honoraires professionnels",{"$f":"_xlfn.IFS((B16+B18)<300000,(B16+B18)*0.09,(B16+B18)<600000,27000+(((B16+B18)-300000)*0.072),(B16+B18)<1250000,48600+(((B16+B18)-600000)*0.063),(B16+B18)>1250000,89550+(((B16+B18)-1250000)*0.0576))","v":97002.251827200016}]
[]
["Enveloppe chargé projet",{"$f":"_xlfn.IFS((B16+B18)<750000,(B16+B18)*0.03,(B16+B18)<1500000,22500+(((B16+B18)-750000)*0.02),(B16+B18)>1500000,37500+(((B16+B18)-1500000)*0.015))","v":35087.587440000003}]
[]
["Enveloppe mobilier-équipement",{"$f":"_xlfn.IFS(B5<41,15675,B5>40,(B5*522)+31351+(B6*522))","v":78331}]
[]
["Enveloppe jeux extérieurs",{"$f":"B5*418","v":33440}]
[]
["Enveloppe intégration des Arts à l'architecture","Si projet égal ou supérieur à 150 000$"]
[]
["Enveloppe achat de terrain","Selon opportunités"]
[]
["Enveloppe spécifique exceptionnelle","Exigences peu communes émanant d'autorités compétentes, telle une municipalité"]
[]
["Enveloppe totale préliminaire",{"$f":"B16+B18+B20+B22+B24+B26","v":1623240.2112672001}]
[]
["Superficie pi2 AVEC salle multi",{"$f":"SUM(VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D83,2,FALSE),VLOOKUP('Calcul env. achat-construction'!B6,Superficie!A3:D83,4,FALSE),VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D83,3,FALSE))","v":7481.5158684537164}]
[]
["Superficie pi2 SANS salle multi",{"$f":"SUM(VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D83,2,FALSE),VLOOKUP('Calcul env. achat-construction'!B6,Superficie!A3:D83,4,FALSE))","v":6793.7839399951163}]
[]
["Superficie minimum aire de jeu extérieur pi2 ",{"$f":"0.333*(43.0556*B5)","v":1147.001184}]

{"sheet":"Annexe II","index":1,"n_rows":83,"n_cols":2,"rows_kept":83,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Annexe II"]
["Montants de référence maximaux – Installation"]
["NOMBRE DE PLACES SUBVENTIONNÉES","MONTANT MAXIMAL ACHAT-CONSTRUCTION "]
[1,379502]
[2,379502]
[3,379502]
[4,379502]
[5,379502]
[6,379502]
[7,379502]
[8,379502]
[9,379502]
[10,379502]
[11,379502]
[12,379502]
[13,379502]
[14,379502]
[15,379502]
[16,379502]
[17,379502]
[18,379502]
[19,379502]
[20,392030]
[21,404561]
[22,417089]
[23,429620]
[24,442153]
[25,454679]
[26,467210]
[27,479740]
[28,492270]
[29,504803]
[30,517330]
[31,529860]
[32,542390]
[33,554919]
[34,567452]
[35,579984]
[36,592512]
[37,605043]
[38,617571]
[39,630102]
[40,655036]
[41,667567]
[42,680098]
[43,692625]
[44,705155]
[45,717687]
[46,730219]
[47,742750]
[48,755279]
[49,767809]
[50,780336]
[51,792870]
[52,805399]
[53,817930]
[54,830460]
[55,855395]
[56,867925]
[57,880456]
[58,892984]
[59,905514]
[60,918046]
[61,930573]
[62,943104]
[63,955636]
[64,968165]
[65,980696]
[66,993224]
[67,1005756]
[68,1018286]
[69,1030814]
[70,1055754]
[71,1068282]
[72,1080814]
[73,1093343]
[74,1105874]
[75,1118402]
[76,1130933]
[77,1143462]
[78,1155993]
[79,1168523]
[80,1181052]

{"sheet":"Superficie","index":2,"n_rows":83,"n_cols":4,"rows_kept":83,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Estimation superficie"]
["Nombre de places en installation    (0-59 mois)","Superficie pieds2","Superficies Salle Multi pieds2","Superficie pieds2 0-18 mois"]
[0,0,0,0]
[1,2099.9619337647505,299.88372791040001,25.8420407448485]
[2,2099.9619337647505,299.88372791040001,25.8420407448485]
[3,2099.9619337647505,299.88372791040001,25.8420407448485]
[4,2099.9619337647505,299.88372791040001,25.8420407448485]
[5,2099.9619337647505,299.88372791040001,129.210203724243]
[6,2099.9619337647505,299.88372791040001,129.210203724243]
[7,2099.9619337647505,299.88372791040001,129.210203724243]
[8,2099.9619337647505,299.88372791040001,129.210203724243]
[9,2099.9619337647505,299.88372791040001,129.210203724243]
[10,2099.9619337647505,299.88372791040001,258.42040744848498]
[11,2099.9619337647505,299.88372791040001,258.42040744848498]
[12,2099.9619337647505,299.88372791040001,258.42040744848498]
[13,2099.9619337647505,299.88372791040001,258.42040744848498]
[14,2099.9619337647505,299.88372791040001,258.42040744848498]
[15,2099.9619337647505,299.88372791040001,387.63061117272798]
[16,2099.9619337647505,299.88372791040001,387.63061117272798]
[17,2099.9619337647505,299.88372791040001,387.63061117272798]
[18,2099.9619337647505,299.88372791040001,387.63061117272798]
[19,2099.9619337647505,299.88372791040001,387.63061117272798]
[20,2169.2995812714121,399.82559487560002,516.84081489697041]
[21,2238.6372287780737,399.82559487560002,516.84081489697041]
[22,2307.9748762847353,399.82559487560002,516.84081489696996]
[23,2377.3030072325846,399.82559487560002,516.84081489696996]
[24,2446.6406547392462,399.82559487560002,516.84081489696996]
[25,2515.9783022459078,399.82559487560002,516.84081489696996]
[26,2585.3159497525694,399.82559487560002,516.84081489696996]
[27,2654.6440807004187,399.82559487560002,516.84081489696996]
[28,2723.9817282070803,399.82559487560002,516.84081489696996]
[29,2793.3193757137419,399.82559487560002,516.84081489696996]
[30,2862.6570232204035,399.82559487560002,516.84081489696996]
[31,2931.9851541682528,399.82559487560002,516.84081489696996]
[32,3001.3228016749144,399.82559487560002,516.84081489696996]
[33,3070.660449181576,399.82559487560002,516.84081489696996]
[34,3139.9980966882376,399.82559487560002,516.84081489696996]
[35,3209.326227636087,399.82559487560002,516.84081489696996]
[36,3278.6638751427486,399.82559487560002,516.84081489696996]
[37,3348.0015226494102,399.82559487560002,516.84081489696996]
[38,3417.3391701560718,399.82559487560002,516.84081489696996]
[39,3486.6673011039211,399.82559487560002,516.84081489696996]
[40,3624.6574038827562,499.80083105300002,516.84081489696996]
[41,3693.9855348306055,499.80083105300002,516.84081489696996]
[42,3763.3231823372671,499.80083105300002,516.84081489696996]
[43,3832.6608298439287,499.80083105300002,516.84081489696996]
[44,3901.9984773505903,499.80083105300002,516.84081489696996]
[45,3971.3266082984392,499.80083105300002,516.84081489696996]
[46,4040.6642558051008,499.80083105300002,516.84081489696996]
[47,4110.0019033117624,499.80083105300002,516.84081489696996]
[48,4179.339550818424,499.80083105300002,516.84081489696996]
[49,4248.6676817662737,499.80083105300002,516.84081489696996]
[50,4318.0053292729353,499.80083105300002,516.84081489696996]
[51,4387.3429767795969,499.80083105300002,516.84081489696996]
[52,4456.6806242862585,499.80083105300002,516.84081489696996]
[53,4526.0087552341074,499.80083105300002,516.84081489696996]
[54,4595.346402740769,499.80083105300002,516.84081489696996]
[55,4733.3269889607918,499.80083105300002,516.84081489696996]
[56,4802.6646364674534,499.80083105300002,516.84081489696996]
[57,4872.002283974115,499.80083105300002,516.84081489696996]
[58,4941.3399314807766,499.80083105300002,516.84081489696996]
[59,5010.6680624286255,499.80083105300002,516.84081489696996]
[60,5080.0057099352871,515.796524385,516.84081489696996]
[61,5149.3433574419487,515.796524385,516.84081489696996]
[62,5218.6810049486103,515.796524385,516.84081489696996]
[63,5288.0091358964601,515.796524385,516.84081489696996]
[64,5357.3467834031217,515.796524385,516.84081489696996]
[65,5426.6844309097833,558.7825282558,516.84081489696996]
[66,5496.0220784164449,558.7825282558,516.84081489696996]
[67,5565.3502093642937,558.7825282558,516.84081489696996]
[68,5634.6878568709553,558.7825282558,516.84081489696996]
[69,5704.0255043776169,558.7825282558,516.84081489696996]
[70,5842.0060905976397,601.759920717,516.84081489696996]
[71,5911.3437381043013,601.759920717,516.84081489696996]
[72,5980.6813856109629,601.759920717,516.84081489696996]
[73,6050.0095165588127,601.759920717,516.84081489696996]
[74,6119.3471640654743,601.759920717,516.84081489696996]
[75,6188.6848115721359,644.75453599740001,516.84081489696996]
[76,6258.0224590787975,644.75453599740001,516.84081489696996]
[77,6327.3505900266464,644.75453599740001,516.84081489696996]
[78,6396.688237533308,644.75453599740001,516.84081489696996]
[79,6466.0258850399696,644.75453599740001,516.84081489696996]
[80,6535.3635325466312,687.73192845860001,516.84081489696996]

{"sheet":"Annexe III","index":3,"n_rows":83,"n_cols":2,"rows_kept":83,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Annexe III"]
["Montants de référence maximaux – Salle multifonctionnelle"]
["NOMBRE DE PLACES SUBVENTIONNEES","MONTANT MAXIMAL POUR UNE SALLE MULTIFONCTIONNELLE"]
[1,54186]
[2,54186]
[3,54186]
[4,54186]
[5,54186]
[6,54186]
[7,54186]
[8,54186]
[9,54186]
[10,54186]
[11,54186]
[12,54186]
[13,54186]
[14,54186]
[15,54186]
[16,54186]
[17,54186]
[18,54186]
[19,54186]
[20,72245]
[21,72245]
[22,72245]
[23,72245]
[24,72245]
[25,72245]
[26,72245]
[27,72245]
[28,72245]
[29,72245]
[30,72245]
[31,72245]
[32,72245]
[33,72245]
[34,72245]
[35,72245]
[36,72245]
[37,72245]
[38,72245]
[39,72245]
[40,90309]
[41,90309]
[42,90309]
[43,90309]
[44,90309]
[45,90309]
[46,90309]
[47,90309]
[48,90309]
[49,90309]
[50,90309]
[51,90309]
[52,90309]
[53,90309]
[54,90309]
[55,90309]
[56,90309]
[57,90309]
[58,90309]
[59,90309]
[60,93200]
[61,93200]
[62,93200]
[63,93200]
[64,93200]
[65,100967]
[66,100967]
[67,100967]
[68,100967]
[69,100967]
[70,108732]
[71,108732]
[72,108732]
[73,108732]
[74,108732]
[75,116501]
[76,116501]
[77,116501]
[78,116501]
[79,116501]
[80,124267]

{"sheet":"Annexe IV","index":4,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Annexe IV"]
["Indices régionaux de modulation"]
["Région administrative"," INDICE"]
["Abitibi-Témiscamingue",1.1499999999999999]
["Bas-Saint-Laurent",1.05]
["Capitale-Nationale",1]
["Centre-du-Québec",1]
["Chaudière-Appalaches",1]
["Côte-Nord - Est de Pointe-Parent et Schefferville",2]
["Côte-Nord - Rivière Moisie à Pointe-Parent et Fermont ",1.6]
["Côte-Nord - Rivière Saguenay à rivière Moisie ",1.25]
["Estrie",1]
["Gaspésie ",1.1000000000000001]
["Gaspésie - Îles-de-la-Madeleine",1.6]
["Lanaudière",1]
["Laurentides - MRC d’Antoine-Labelle",1.1200000000000001]
["Laurentides - Sauf la MRC d’Antoine-Labelle",1]
["Laval",1]
["Mauricie - Région de La Tuque",1.05]
["Mauricie - Sauf la région de La Tuque",1]
["Montérégie",1]
["Montréal",1]
["Nord-du-Québec - Région de Chibougamau",1.25]
["Nord-du-Québec - Région du Nunavik",4]
["Nord-du-Québec - Sauf les régions de Chibougamau et du Nunavik",1.6]
["Outaouais",1.1200000000000001]
["Saguenay–Lac-Saint-Jean",1.05]

{"sheet":"Menu déroulant","index":5,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["oui"]
["non"]