{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calcul agrandissement - Proprio","Superficie","Choix déroulant","Annexe II","Annexe III","Annexe IV"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"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 agrandissement - Proprio","index":0,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[0,0,0,1]]}
["Financement de l'agrandissement d'une installation - propriétaire"]
["Pour le PFI, le CPE locataire détenant un contrat d'emphytéose est considéré comme propriétaire."]
["Insérer 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 16 places, qui ajoute 26 places et qui constitue au moins un groupe complet dont 10 poupons, situé dans le Bas-Saint-Laurent"]
[]
["Nombre de places totales (AVANT l'ajout des nouvelles places)",80]
["Nombre de places ajoutées",20]
["Nombre de places totales (APRÈS l'ajout des nouvelles places)",{"$f":"B6+B7","v":100}]
["Nombre de NOUVELLES places 17 mois ou moins (poupons)",5]
["Durée du bail emphytéotique, si applicable (en années)",0]
["Région","Montérégie"]
["L'agrandissement permet-il l'ajout d'un groupe complet?","Oui"]
["Nombre de poupons dans un nouveau groupe poupon COMPLET no 1",5]
["Nombre de poupons dans un nouveau groupe poupon COMPLET no 2"]
["Nombre de poupons dans un nouveau groupe poupon COMPLET no 3"]
["Nombre de poupons dans un nouveau groupe poupon COMPLET no 4"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 1",8]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 2"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 3"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 4"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 5"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 6"]
["Nombre d'enfants dans un nouveau groupe COMPLET constitué no 7"]
[]
["Montant de base (APRÈS l'ajout de nouvelles places)",{"$f":"VLOOKUP('Calcul agrandissement - Proprio'!B8,'Annexe II'!A4:B103,2,FALSE)","v":2519708}]
["Montant de base (AVANT l'ajout de nouvelles places)",{"$f":"VLOOKUP('Calcul agrandissement - Proprio'!B6,'Annexe II'!A4:B103,2,FALSE)","v":2078652}]
["Montant poupon",{"$f":"B9*8219","v":41095}]
["Montant d'ajustement petite installation",{"$f":"IF(B8<19,((19-B6)*22055),IF(B6<19,(B7*22055),0))","v":0}]
["Sous-total avant indice régional de modulation ",{"$f":"B28+(B25-B26)+B27","v":482151}]
["Indice régional de modulation",{"$f":"VLOOKUP(B11,'Annexe IV'!A4:B27,2,FALSE)","v":1}]
["Sous-total incluant indice régional de modulation ",{"$f":"B29*B30","v":482151}]
[]
["Enveloppe maximale achat construction",{"$f":"_xlfn.IFS(B10=0,B31,B10<=20,B31*0.2,B10>20,B31)","v":482151}]
[]
["Enveloppe aménagement extérieur",{"$f":"B33*0.07","v":33750.57}]
[]
["Enveloppe honoraires professionnels",{"$f":"_xlfn.IFS((B33+B35)<300000,(B33+B35)*0.09,(B33+B35)<600000,27000+(((B33+B35)-300000)*0.072),(B33+B35)<1250000,48600+(((B33+B35)-600000)*0.063),(B33+B35)>1250000,89550+(((B33+B35)-1250000)*0.0576))","v":42544.913039999999}]
[]
["Enveloppe chargé projet",{"$f":"_xlfn.IFS((B33+B35)<750000,(B33+B35)*0.03,(B33+B35)<1500000,22500+(((B33+B35)-750000)*0.02),(B33+B35)>1500000,37500+(((B33+B35)-1500000)*0.015))","v":15477.0471}]
[]
["Calcul mobilier",{"$f":"27588+(((B13+B14+B15+B16+B17+B18+B19+B20+B21+B22+B23)*918)+((B13+B14+B15+B16)*918))","v":44112}]
["Enveloppe mobilier-équipement",{"$f":"IF(AND(B8>41,B12=\"Oui\"),B41,0)","v":44112}]
[]
["Enveloppe jeux extérieurs",{"$f":"IF(B12=\"Oui\",((B17+B18+B19+B20+B21+B22+B23++B13+B14+B15+B16)*735),0)","v":9555}]
[]
["Enveloppe intégration des Arts à l'architecture","Si projet égal ou supérieur à 150 000$"]
[]
["Enveloppe achat de terrain","Une enveloppe peut couvrir l'achat d'un terrain adjacent à l'installation si cette acquisition est nécessaire  et autorisée par le Ministre"]
[]
["Enveloppe spécifique exceptionnelle","Exigences peu communes émanant d'autorités compétentes, telle une municipalité"]
[]
["Enveloppe totale préliminaire",{"$f":"B33+B35+B42+B44+B37","v":612113.48304000008}]

{"sheet":"Superficie","index":1,"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,2099.9619337647505,299.88372791040001,{"$f":"25.84*A4","v":25.84}]
[2,2099.9619337647505,299.88372791040001,{"$f":"25.84*A5","v":51.68}]
[3,2099.9619337647505,299.88372791040001,77.52]
[4,2099.9619337647505,299.88372791040001,103.36]
[5,2099.9619337647505,299.88372791040001,129.19999999999999]
[6,2099.9619337647505,299.88372791040001,155.04]
[7,2099.9619337647505,299.88372791040001,180.88]
[8,2099.9619337647505,299.88372791040001,206.72]
[9,2099.9619337647505,299.88372791040001,232.56]
[10,2099.9619337647505,299.88372791040001,258.39999999999998]
[11,2099.9619337647505,299.88372791040001,284.24]
[12,2099.9619337647505,299.88372791040001,310.08]
[13,2099.9619337647505,299.88372791040001,335.92]
[14,2099.9619337647505,299.88372791040001,361.76]
[15,2099.9619337647505,299.88372791040001,387.6]
[16,2099.9619337647505,299.88372791040001,413.44]
[17,2099.9619337647505,299.88372791040001,439.28]
[18,2099.9619337647505,299.88372791040001,465.12]
[19,2099.9619337647505,299.88372791040001,490.96]
[20,2169.2995812714121,399.82559487560002,516.79999999999995]
[21,2238.6372287780737,399.82559487560002,542.64]
[22,2307.9748762847353,399.82559487560002,568.48]
[23,2377.3030072325846,399.82559487560002,594.32000000000005]
[24,2446.6406547392462,399.82559487560002,620.16]
[25,2515.9783022459078,399.82559487560002,646]
[26,2585.3159497525694,399.82559487560002,671.84]
[27,2654.6440807004187,399.82559487560002,697.68]
[28,2723.9817282070803,399.82559487560002,723.52]
[29,2793.3193757137419,399.82559487560002,749.36]
[30,2862.6570232204035,399.82559487560002,775.2]
[31,2931.9851541682528,399.82559487560002,801.04]
[32,3001.3228016749144,399.82559487560002,826.88]
[33,3070.660449181576,399.82559487560002,852.72]
[34,3139.9980966882376,399.82559487560002,878.56]
[35,3209.326227636087,399.82559487560002,904.4]
[36,3278.6638751427486,399.82559487560002,930.24]
[37,3348.0015226494102,399.82559487560002,956.08]
[38,3417.3391701560718,399.82559487560002,981.92]
[39,3486.6673011039211,399.82559487560002,1007.76]
[40,3624.6574038827562,499.80083105300002,1033.5999999999999]
[41,3693.9855348306055,499.80083105300002,1059.44]
[42,3763.3231823372671,499.80083105300002,1085.28]
[43,3832.6608298439287,499.80083105300002,1111.1199999999999]
[44,3901.9984773505903,499.80083105300002,1136.96]
[45,3971.3266082984392,499.80083105300002,1162.8]
[46,4040.6642558051008,499.80083105300002,1188.6400000000001]
[47,4110.0019033117624,499.80083105300002,1214.48]
[48,4179.339550818424,499.80083105300002,1240.32]
[49,4248.6676817662737,499.80083105300002,1266.1600000000001]
[50,4318.0053292729353,499.80083105300002,1292]
[51,4387.3429767795969,499.80083105300002,1317.84]
[52,4456.6806242862585,499.80083105300002,1343.68]
[53,4526.0087552341074,499.80083105300002,1369.52]
[54,4595.346402740769,499.80083105300002,1395.36]
[55,4733.3269889607918,499.80083105300002,1421.2]
[56,4802.6646364674534,499.80083105300002,1447.04]
[57,4872.002283974115,499.80083105300002,1472.8799999999999]
[58,4941.3399314807766,499.80083105300002,1498.72]
[59,5010.6680624286255,499.80083105300002,1524.56]
[60,5080.0057099352871,515.796524385,1550.4]
[61,5149.3433574419487,515.796524385,1576.24]
[62,5218.6810049486103,515.796524385,1602.08]
[63,5288.0091358964601,515.796524385,1627.92]
[64,5357.3467834031217,515.796524385,1653.76]
[65,5426.6844309097833,558.7825282558,1679.6]
[66,5496.0220784164449,558.7825282558,{"$f":"25.84*A69","v":1705.44}]
[67,5565.3502093642937,558.7825282558,1731.28]
[68,5634.6878568709553,558.7825282558,1757.12]
[69,5704.0255043776169,558.7825282558,1782.96]
[70,5842.0060905976397,601.759920717,1808.8]
[71,5911.3437381043013,601.759920717,1834.64]
[72,5980.6813856109629,601.759920717,1860.48]
[73,6050.0095165588127,601.759920717,1886.32]
[74,6119.3471640654743,601.759920717,1912.16]
[75,6188.6848115721359,644.75453599740001,1938]
[76,6258.0224590787975,644.75453599740001,1963.84]
[77,6327.3505900266464,644.75453599740001,1989.68]
[78,6396.688237533308,644.75453599740001,2015.52]
[79,6466.0258850399696,644.75453599740001,2041.36]
[80,6535.3635325466312,687.73192845860001,2067.1999999999998]
[81,{"$f":"'[1]Annexe II'!B84/318","v":6605.9874213836474},{"$f":"'[1]Annexe III'!B84/318","v":687.72327044025155},{"$f":"A84*25.84","v":2093.04}]
[82,{"$f":"'[1]Annexe II'!B85/318","v":6675.3364779874209},{"$f":"'[1]Annexe III'!B85/318","v":687.72327044025155},2118.88]
[83,{"$f":"'[1]Annexe II'!B86/318","v":6744.6855345911954},{"$f":"'[1]Annexe III'!B86/318","v":687.72327044025155},2144.7199999999998]
[84,{"$f":"'[1]Annexe II'!B87/318","v":6814.0345911949689},{"$f":"'[1]Annexe III'!B87/318","v":687.72327044025155},2170.56]
[85,{"$f":"'[1]Annexe II'!B88/318","v":6883.3836477987425},{"$f":"'[1]Annexe III'!B88/318","v":730.70125786163521},2196.4]
[86,{"$f":"'[1]Annexe II'!B89/318","v":6952.7295597484281},{"$f":"'[1]Annexe III'!B89/318","v":730.70125786163521},2222.2399999999998]
[87,{"$f":"'[1]Annexe II'!B90/318","v":7022.0786163522016},{"$f":"'[1]Annexe III'!B90/318","v":730.70125786163521},2248.08]
[88,{"$f":"'[1]Annexe II'!B91/318","v":7091.4276729559751},{"$f":"'[1]Annexe III'!B91/318","v":730.70125786163521},2273.92]
[89,{"$f":"'[1]Annexe II'!B92/318","v":7160.7767295597487},{"$f":"'[1]Annexe III'!B92/318","v":730.70125786163521},2299.7599999999998]
[90,{"$f":"'[1]Annexe II'!B93/318","v":7230.1257861635222},{"$f":"'[1]Annexe III'!B93/318","v":773.67924528301887},2325.6]
[91,{"$f":"'[1]Annexe II'!B94/318","v":7299.4716981132078},{"$f":"'[1]Annexe III'!B94/318","v":773.67924528301887},2351.44]
[92,{"$f":"'[1]Annexe II'!B95/318","v":7368.8207547169814},{"$f":"'[1]Annexe III'!B95/318","v":773.67924528301887},2377.2800000000002]
[93,{"$f":"'[1]Annexe II'!B96/318","v":7438.1698113207549},{"$f":"'[1]Annexe III'!B96/318","v":773.67924528301887},2403.12]
[94,{"$f":"'[1]Annexe II'!B97/318","v":7507.5188679245284},{"$f":"'[1]Annexe III'!B97/318","v":773.67924528301887},2428.96]
[95,{"$f":"'[1]Annexe II'!B98/318","v":7576.867924528302},{"$f":"'[1]Annexe III'!B98/318","v":816.6540880503145},2454.8000000000002]
[96,{"$f":"'[1]Annexe II'!B99/318","v":7646.2138364779876},{"$f":"'[1]Annexe III'!B99/318","v":816.6540880503145},2480.64]
[97,{"$f":"'[1]Annexe II'!B100/318","v":7715.5628930817611},{"$f":"'[1]Annexe III'!B100/318","v":816.6540880503145},2506.48]
[98,{"$f":"'[1]Annexe II'!B101/318","v":7784.9119496855346},{"$f":"'[1]Annexe III'!B101/318","v":816.6540880503145},2532.3200000000002]
[99,{"$f":"'[1]Annexe II'!B102/318","v":7854.2610062893082},{"$f":"'[1]Annexe III'!B102/318","v":816.6540880503145},2558.16]
[100,{"$f":"'[1]Annexe II'!B103/318","v":7923.6100628930817},{"$f":"'[1]Annexe III'!B103/318","v":859.63207547169816},2584]

{"sheet":"Choix déroulant","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Oui"]
["Non"]

{"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,667924]
[2,667924]
[3,667924]
[4,667924]
[5,667924]
[6,667924]
[7,667924]
[8,667924]
[9,667924]
[10,667924]
[11,667924]
[12,667924]
[13,667924]
[14,667924]
[15,667924]
[16,667924]
[17,667924]
[18,667924]
[19,667924]
[20,689973]
[21,712027]
[22,734077]
[23,756131]
[24,778189]
[25,800235]
[26,822290]
[27,844342]
[28,866395]
[29,888453]
[30,910501]
[31,932554]
[32,954606]
[33,976657]
[34,998716]
[35,1020772]
[36,1042821]
[37,1064876]
[38,1086925]
[39,1108980]
[40,1152863]
[41,1174918]
[42,1196972]
[43,1219020]
[44,1241073]
[45,1263129]
[46,1285185]
[47,1307240]
[48,1329291]
[49,1351344]
[50,1373391]
[51,1395451]
[52,1417502]
[53,1439557]
[54,1461610]
[55,1505495]
[56,1527548]
[57,1549603]
[58,1571652]
[59,1593705]
[60,1615761]
[61,1637808]
[62,1659863]
[63,1681919]
[64,1703970]
[65,1726025]
[66,1748074]
[67,1770131]
[68,1792183]
[69,1814233]
[70,1858127]
[71,1880176]
[72,1902233]
[73,1924284]
[74,1946338]
[75,1968388]
[76,1990442]
[77,2012493]
[78,2034548]
[79,2056600]
[80,2078652]
[81,2100704]
[82,2122757]
[83,2144810]
[84,2166863]
[85,2188916]
[86,2210968]
[87,2233021]
[88,2255074]
[89,2277127]
[90,2299180]
[91,2321232]
[92,2343285]
[93,2365338]
[94,2387391]
[95,2409444]
[96,2431496]
[97,2453549]
[98,2475602]
[99,2497655]
[100,2519708]

{"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,95362]
[2,95362]
[3,95362]
[4,95362]
[5,95362]
[6,95362]
[7,95362]
[8,95362]
[9,95362]
[10,95362]
[11,95362]
[12,95362]
[13,95362]
[14,95362]
[15,95362]
[16,95362]
[17,95362]
[18,95362]
[19,95362]
[20,127143]
[21,127143]
[22,127143]
[23,127143]
[24,127143]
[25,127143]
[26,127143]
[27,127143]
[28,127143]
[29,127143]
[30,127143]
[31,127143]
[32,127143]
[33,127143]
[34,127143]
[35,127143]
[36,127143]
[37,127143]
[38,127143]
[39,127143]
[40,158935]
[41,158935]
[42,158935]
[43,158935]
[44,158935]
[45,158935]
[46,158935]
[47,158935]
[48,158935]
[49,158935]
[50,158935]
[51,158935]
[52,158935]
[53,158935]
[54,158935]
[55,158935]
[56,158935]
[57,158935]
[58,158935]
[59,158935]
[60,164022]
[61,164022]
[62,164022]
[63,164022]
[64,164022]
[65,177691]
[66,177691]
[67,177691]
[68,177691]
[69,177691]
[70,191358]
[71,191358]
[72,191358]
[73,191358]
[74,191358]
[75,205030]
[76,205030]
[77,205030]
[78,205030]
[79,205030]
[80,218696]
[81,218696]
[82,218696]
[83,218696]
[84,218696]
[85,232363]
[86,232363]
[87,232363]
[88,232363]
[89,232363]
[90,246030]
[91,246030]
[92,246030]
[93,246030]
[94,246030]
[95,259696]
[96,259696]
[97,259696]
[98,259696]
[99,259696]
[100,273363]

{"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.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]