{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calcul amélioration locative","Menu déroulant","Superficie","Annexe II","Annexe III","Annexe IV"],"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 amélioration locative","index":0,"n_rows":43,"n_cols":2,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,1,1],[3,0,3,1],[2,0,2,1],[0,0,0,1]]}
["Financement améliorations locatives"]
["Pour être admissible, le bail de location doit être prévu pour une période d'au moins 5 ans et offrir une option ferme de renouvellement d'une durée équivalente."]
["Insérer dans l'espace en vert votre nombre de places totales, votre nombre de places poupons, la durée de votre bail 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 17 mois ou moins (poupons)",20]
["Région","Montréal"]
["Durée du bail (en années)",10]
["Salle Multifonctionnelle","oui"]
["Montant de base",{"$f":"VLOOKUP('Calcul amélioration locative'!B6,'Annexe II'!A4:B103,2,FALSE)","v":2313748}]
["Montant poupon",{"$f":"B7*9149","v":182980}]
["Salle Multifonctionnelle",{"$f":"VLOOKUP(B6,'Annexe III'!A4:B103,2,FALSE)","v":243422}]
["Total avant indice régional de modulation ",{"$f":"IF(B10=\"oui\",B11+B12+B13,B11+B12)","v":2740150}]
["Indice régional de modulation ",{"$f":"VLOOKUP(B8,'Annexe IV'!A4:B27,2,FALSE)","v":1.07}]
["Total incluant indice régional de modulation ",{"$f":"B14*B15","v":2931960.5}]
["Facteur du durée du bail (20% si au moins 5 ans et 25 % pour 10 ans et plus)",{"$f":"_xlfn.IFS(B9<5,0,B9<10,(B16*0.2),B9<10,(B16*0.2),B9>9,(B16*0.25))","v":732990.125}]
[]
["Enveloppe maximale achat construction",{"$f":"B17","v":732990.125}]
[]
["Enveloppe aménagement extérieur",{"$f":"0.07*B19","v":51309.308750000004}]
[]
["Enveloppe honoraires professionnels",{"$f":"_xlfn.IFS((B19+B21)<587000,(B19+B21)*0.09,(B19+B21)<1175000,52830+(((B19+B21)-587000)*0.072),(B19+B21)<2449000,95166+(((B19+B21)-1175000)*0.063),(B19+B21)>2449000,175428+(((B19+B21)-2449000)*0.0576))","v":67035.559229999999}]
[]
["Enveloppe chargé projet",{"$f":"_xlfn.IFS((B19+B21)<1470000,(B19+B21)*0.03,(B19+B21)<2940000,44100+(((B19+B21)-1470000)*0.02),(B19+B21)>2940000,73500+(((B19+B21)-2940000)*0.015))","v":23528.983012499997}]
[]
["Enveloppe mobilier-équipement",{"$f":"_xlfn.IFS(B6<41,30709,B6>40,(B6*1022)+61419+(B7*1022))","v":163619}]
[]
["Enveloppe jeux extérieurs",{"$f":"B6*819","v":65520}]
[]
["Enveloppe intégration des Arts à l'architecture","Si projet égal ou supérieur à 150 000$"]
[]
["Enveloppe achat de terrain","Aucune enveloppe"]
[]
["Enveloppe spécifique exceptionnelle","Exigences peu communes émanant d'autorités compétentes, telle une municipalité"]
[]
["Enveloppe totale préliminaire",{"$f":"B19+B21+B23+B25+B27+B29","v":1104002.9759924999}]
[]
["Superficie pi2 AVEC salle multi",{"$f":"SUM(VLOOKUP('Calcul amélioration locative'!B6,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul amélioration locative'!B6,Superficie!A3:D103,3,FALSE),VLOOKUP('Calcul amélioration locative'!B7,Superficie!A3:D103,4,FALSE))","v":7741.1647798742142}]
[]
["Superficie pi2 SANS salle multi",{"$f":"SUM(VLOOKUP('Calcul amélioration locative'!B6,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul amélioration locative'!B7,Superficie!A3:D103,4,FALSE))","v":7053.4415094339629}]
[]
["Superficie minimum aire de jeu extérieur pi2 ",{"$f":"0.333*(43.0556*B6)","v":1147.001184}]

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

{"sheet":"Superficie","index":2,"n_rows":103,"n_cols":4,"rows_kept":103,"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,2100.3899371069183,299.88050314465409,25.84]
[2,2100.3899371069183,299.88050314465409,51.68]
[3,2100.3899371069183,299.88050314465409,77.52]
[4,2100.3899371069183,299.88050314465409,103.36]
[5,2100.3899371069183,299.88050314465409,129.19999999999999]
[6,2100.3899371069183,299.88050314465409,155.04]
[7,2100.3899371069183,299.88050314465409,180.88]
[8,2100.3899371069183,299.88050314465409,206.72]
[9,2100.3899371069183,299.88050314465409,232.56]
[10,2100.3899371069183,299.88050314465409,258.39999999999998]
[11,2100.3899371069183,299.88050314465409,284.24]
[12,2100.3899371069183,299.88050314465409,310.08]
[13,2100.3899371069183,299.88050314465409,335.92]
[14,2100.3899371069183,299.88050314465409,361.76]
[15,2100.3899371069183,299.88050314465409,387.6]
[16,2100.3899371069183,299.88050314465409,413.44]
[17,2100.3899371069183,299.88050314465409,439.28]
[18,2100.3899371069183,299.88050314465409,465.12]
[19,2100.3899371069183,299.88050314465409,490.96]
[20,2169.7264150943397,399.82075471698113,516.79999999999995]
[21,2239.0786163522012,399.82075471698113,542.64]
[22,2308.4182389937105,399.82075471698113,568.48]
[23,2377.7704402515724,399.82075471698113,594.32000000000005]
[24,2447.135220125786,399.82075471698113,620.16]
[25,2516.4622641509436,399.82075471698113,646]
[26,2585.817610062893,399.82075471698113,671.84]
[27,2655.1635220125786,399.82075471698113,697.68]
[28,2724.5125786163521,399.82075471698113,723.52]
[29,2793.8773584905662,399.82075471698113,749.36]
[30,2863.2106918238992,399.82075471698113,775.2]
[31,2932.5597484276727,399.82075471698113,801.04]
[32,3001.9056603773583,399.82075471698113,826.88]
[33,3071.248427672956,399.82075471698113,852.72]
[34,3140.616352201258,399.82075471698113,878.56]
[35,3209.9748427672957,399.82075471698113,904.4]
[36,3279.3113207547171,399.82075471698113,930.24]
[37,3348.6666666666665,399.82075471698113,956.08]
[38,3418.0031446540879,399.82075471698113,981.92]
[39,3487.3584905660377,399.82075471698113,1007.76]
[40,3625.3553459119498,499.79559748427675,1033.5999999999999]
[41,3694.7106918238992,499.79559748427675,1059.44]
[42,3764.0628930817611,499.79559748427675,1085.28]
[43,3833.3962264150941,499.79559748427675,1111.1199999999999]
[44,3902.7452830188681,499.79559748427675,1136.96]
[45,3972.1037735849059,499.79559748427675,1162.8]
[46,4041.4622641509436,499.79559748427675,1188.6400000000001]
[47,4110.8176100628934,499.79559748427675,1214.48]
[48,4180.1603773584902,499.79559748427675,1240.32]
[49,4249.5094339622638,499.79559748427675,1266.1600000000001]
[50,4318.8396226415098,499.79559748427675,1292]
[51,4388.2106918238997,499.79559748427675,1317.84]
[52,4457.5534591194964,499.79559748427675,1343.68]
[53,4526.9088050314467,499.79559748427675,1369.52]
[54,4596.2578616352203,499.79559748427675,1395.36]
[55,4734.2610062893082,499.79559748427675,1421.2]
[56,4803.6100628930817,499.79559748427675,1447.04]
[57,4872.9654088050311,499.79559748427675,1472.8799999999999]
[58,4942.3018867924529,499.79559748427675,1498.72]
[59,5011.6509433962265,499.79559748427675,1524.56]
[60,5081.0094339622638,515.79245283018872,1550.4]
[61,5150.3396226415098,515.79245283018872,1576.24]
[62,5219.6949685534591,515.79245283018872,1602.08]
[63,5289.0534591194964,515.79245283018872,1627.92]
[64,5358.3962264150941,515.79245283018872,1653.76]
[65,5427.7515723270444,558.77672955974845,1679.6]
[66,5497.0880503144654,558.77672955974845,1705.44]
[67,5566.4496855345915,558.77672955974845,1731.28]
[68,5635.7955974842771,558.77672955974845,1757.12]
[69,5705.135220125786,558.77672955974845,1782.96]
[70,5843.166666666667,601.75471698113211,1808.8]
[71,5912.5031446540879,601.75471698113211,1834.64]
[72,5981.864779874214,601.75471698113211,1860.48]
[73,6051.2075471698117,601.75471698113211,1886.32]
[74,6120.5597484276732,601.75471698113211,1912.16]
[75,6189.8993710691821,644.74842767295593,1938]
[76,6259.2515723270444,644.74842767295593,1963.84]
[77,6328.5943396226412,644.74842767295593,1989.68]
[78,6397.9496855345915,644.74842767295593,2015.52]
[79,6467.2955974842771,644.74842767295593,2041.36]
[80,6536.6415094339627,687.72327044025155,2067.1999999999998]
[81,6605.9874213836474,687.72327044025155,2093.04]
[82,6675.3364779874209,687.72327044025155,2118.88]
[83,6744.6855345911954,687.72327044025155,2144.7199999999998]
[84,6814.0345911949689,687.72327044025155,2170.56]
[85,6883.3836477987425,730.70125786163521,2196.4]
[86,6952.7295597484281,730.70125786163521,2222.2399999999998]
[87,7022.0786163522016,730.70125786163521,2248.08]
[88,7091.4276729559751,730.70125786163521,2273.92]
[89,7160.7767295597487,730.70125786163521,2299.7599999999998]
[90,7230.1257861635222,773.67924528301887,2325.6]
[91,7299.4716981132078,773.67924528301887,2351.44]
[92,7368.8207547169814,773.67924528301887,2377.2800000000002]
[93,7438.1698113207549,773.67924528301887,2403.12]
[94,7507.5188679245284,773.67924528301887,2428.96]
[95,7576.867924528302,816.6540880503145,2454.8000000000002]
[96,7646.2138364779876,816.6540880503145,2480.64]
[97,7715.5628930817611,816.6540880503145,2506.48]
[98,7784.9119496855346,816.6540880503145,2532.3200000000002]
[99,7854.2610062893082,816.6540880503145,2558.16]
[100,7923.6100628930817,859.63207547169816,2584]

{"sheet":"Annexe II","index":3,"n_rows":103,"n_cols":2,"rows_kept":103,"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,743466]
[2,743466]
[3,743466]
[4,743466]
[5,743466]
[6,743466]
[7,743466]
[8,743466]
[9,743466]
[10,743466]
[11,743466]
[12,743466]
[13,743466]
[14,743466]
[15,743466]
[16,743466]
[17,743466]
[18,743466]
[19,743466]
[20,768009]
[21,792557]
[22,817101]
[23,841649]
[24,866202]
[25,890742]
[26,915291]
[27,939837]
[28,964384]
[29,988937]
[30,1013479]
[31,1038026]
[32,1062572]
[33,1087117]
[34,1111671]
[35,1136221]
[36,1160764]
[37,1185313]
[38,1209856]
[39,1234406]
[40,1283252]
[41,1307801]
[42,1332350]
[43,1356891]
[44,1381438]
[45,1405989]
[46,1430539]
[47,1455089]
[48,1479634]
[49,1504181]
[50,1528722]
[51,1553277]
[52,1577821]
[53,1602371]
[54,1626918]
[55,1675766]
[56,1700314]
[57,1724863]
[58,1749406]
[59,1773953]
[60,1798504]
[61,1823044]
[62,1847594]
[63,1872144]
[64,1896689]
[65,1921238]
[66,1945781]
[67,1970333]
[68,1994879]
[69,2019423]
[70,2068281]
[71,2092824]
[72,2117376]
[73,2141921]
[74,2166469]
[75,2191013]
[76,2215561]
[77,2240106]
[78,2264655]
[79,2289201]
[80,2313748]
[81,2338294]
[82,2362841]
[83,2387388]
[84,2411935]
[85,2436482]
[86,2461028]
[87,2485576]
[88,2510123]
[89,2534670]
[90,2559217]
[91,2583763]
[92,2608311]
[93,2632858]
[94,2657405]
[95,2681952]
[96,2706498]
[97,2731045]
[98,2755593]
[99,2780140]
[100,2804687]

{"sheet":"Annexe III","index":4,"n_rows":103,"n_cols":2,"rows_kept":103,"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,106144]
[2,106144]
[3,106144]
[4,106144]
[5,106144]
[6,106144]
[7,106144]
[8,106144]
[9,106144]
[10,106144]
[11,106144]
[12,106144]
[13,106144]
[14,106144]
[15,106144]
[16,106144]
[17,106144]
[18,106144]
[19,106144]
[20,141518]
[21,141518]
[22,141518]
[23,141518]
[24,141518]
[25,141518]
[26,141518]
[27,141518]
[28,141518]
[29,141518]
[30,141518]
[31,141518]
[32,141518]
[33,141518]
[34,141518]
[35,141518]
[36,141518]
[37,141518]
[38,141518]
[39,141518]
[40,176904]
[41,176904]
[42,176904]
[43,176904]
[44,176904]
[45,176904]
[46,176904]
[47,176904]
[48,176904]
[49,176904]
[50,176904]
[51,176904]
[52,176904]
[53,176904]
[54,176904]
[55,176904]
[56,176904]
[57,176904]
[58,176904]
[59,176904]
[60,182566]
[61,182566]
[62,182566]
[63,182566]
[64,182566]
[65,197781]
[66,197781]
[67,197781]
[68,197781]
[69,197781]
[70,212992]
[71,212992]
[72,212992]
[73,212992]
[74,212992]
[75,228210]
[76,228210]
[77,228210]
[78,228210]
[79,228210]
[80,243422]
[81,243422]
[82,243422]
[83,243422]
[84,243422]
[85,258634]
[86,258634]
[87,258634]
[88,258634]
[89,258634]
[90,273846]
[91,273846]
[92,273846]
[93,273846]
[94,273846]
[95,289057]
[96,289057]
[97,289057]
[98,289057]
[99,289057]
[100,304269]

{"sheet":"Annexe IV","index":5,"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.2]
["Bas-Saint-Laurent",1.07]
["Capitale-Nationale",1.02]
["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.1499999999999999]
["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.03]
["Mauricie - Région de La Tuque",1.05]
["Mauricie - Sauf la région de La Tuque",1]
["Montérégie",1]
["Montréal",1.07]
["Nord-du-Québec - Région de Chibougamau",1.43]
["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]