{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Annexe II","Annexe III","Annexe IV","Superficie","Calcul env. achat-construction","Mobilier","Budget d'implantation","Budget modifié","Budget coûts réels","Budget final","Menu déroulant"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":9,"comments":6,"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":"Annexe II","index":0,"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":1,"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":2,"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":"Superficie","index":3,"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,{"$f":"'Annexe II'!B4/318","v":2100.3899371069183},{"$f":"'Annexe III'!B4/318","v":299.88050314465409},{"$f":"A4*25.84","v":25.84}]
[2,{"$f":"'Annexe II'!B5/318","v":2100.3899371069183},{"$f":"'Annexe III'!B5/318","v":299.88050314465409},{"$f":"A5*25.84","v":51.68}]
[3,{"$f":"'Annexe II'!B6/318","v":2100.3899371069183},{"$f":"'Annexe III'!B6/318","v":299.88050314465409},77.52]
[4,{"$f":"'Annexe II'!B7/318","v":2100.3899371069183},{"$f":"'Annexe III'!B7/318","v":299.88050314465409},103.36]
[5,{"$f":"'Annexe II'!B8/318","v":2100.3899371069183},{"$f":"'Annexe III'!B8/318","v":299.88050314465409},129.19999999999999]
[6,{"$f":"'Annexe II'!B9/318","v":2100.3899371069183},{"$f":"'Annexe III'!B9/318","v":299.88050314465409},155.04]
[7,{"$f":"'Annexe II'!B10/318","v":2100.3899371069183},{"$f":"'Annexe III'!B10/318","v":299.88050314465409},180.88]
[8,{"$f":"'Annexe II'!B11/318","v":2100.3899371069183},{"$f":"'Annexe III'!B11/318","v":299.88050314465409},206.72]
[9,{"$f":"'Annexe II'!B12/318","v":2100.3899371069183},{"$f":"'Annexe III'!B12/318","v":299.88050314465409},232.56]
[10,{"$f":"'Annexe II'!B13/318","v":2100.3899371069183},{"$f":"'Annexe III'!B13/318","v":299.88050314465409},258.39999999999998]
[11,{"$f":"'Annexe II'!B14/318","v":2100.3899371069183},{"$f":"'Annexe III'!B14/318","v":299.88050314465409},284.24]
[12,{"$f":"'Annexe II'!B15/318","v":2100.3899371069183},{"$f":"'Annexe III'!B15/318","v":299.88050314465409},310.08]
[13,{"$f":"'Annexe II'!B16/318","v":2100.3899371069183},{"$f":"'Annexe III'!B16/318","v":299.88050314465409},335.92]
[14,{"$f":"'Annexe II'!B17/318","v":2100.3899371069183},{"$f":"'Annexe III'!B17/318","v":299.88050314465409},361.76]
[15,{"$f":"'Annexe II'!B18/318","v":2100.3899371069183},{"$f":"'Annexe III'!B18/318","v":299.88050314465409},387.6]
[16,{"$f":"'Annexe II'!B19/318","v":2100.3899371069183},{"$f":"'Annexe III'!B19/318","v":299.88050314465409},413.44]
[17,{"$f":"'Annexe II'!B20/318","v":2100.3899371069183},{"$f":"'Annexe III'!B20/318","v":299.88050314465409},439.28]
[18,{"$f":"'Annexe II'!B21/318","v":2100.3899371069183},{"$f":"'Annexe III'!B21/318","v":299.88050314465409},465.12]
[19,{"$f":"'Annexe II'!B22/318","v":2100.3899371069183},{"$f":"'Annexe III'!B22/318","v":299.88050314465409},490.96]
[20,{"$f":"'Annexe II'!B23/318","v":2169.7264150943397},{"$f":"'Annexe III'!B23/318","v":399.82075471698113},516.79999999999995]
[21,{"$f":"'Annexe II'!B24/318","v":2239.0786163522012},{"$f":"'Annexe III'!B24/318","v":399.82075471698113},542.64]
[22,{"$f":"'Annexe II'!B25/318","v":2308.4182389937105},{"$f":"'Annexe III'!B25/318","v":399.82075471698113},568.48]
[23,{"$f":"'Annexe II'!B26/318","v":2377.7704402515724},{"$f":"'Annexe III'!B26/318","v":399.82075471698113},594.32000000000005]
[24,{"$f":"'Annexe II'!B27/318","v":2447.135220125786},{"$f":"'Annexe III'!B27/318","v":399.82075471698113},620.16]
[25,{"$f":"'Annexe II'!B28/318","v":2516.4622641509436},{"$f":"'Annexe III'!B28/318","v":399.82075471698113},646]
[26,{"$f":"'Annexe II'!B29/318","v":2585.817610062893},{"$f":"'Annexe III'!B29/318","v":399.82075471698113},671.84]
[27,{"$f":"'Annexe II'!B30/318","v":2655.1635220125786},{"$f":"'Annexe III'!B30/318","v":399.82075471698113},697.68]
[28,{"$f":"'Annexe II'!B31/318","v":2724.5125786163521},{"$f":"'Annexe III'!B31/318","v":399.82075471698113},723.52]
[29,{"$f":"'Annexe II'!B32/318","v":2793.8773584905662},{"$f":"'Annexe III'!B32/318","v":399.82075471698113},749.36]
[30,{"$f":"'Annexe II'!B33/318","v":2863.2106918238992},{"$f":"'Annexe III'!B33/318","v":399.82075471698113},775.2]
[31,{"$f":"'Annexe II'!B34/318","v":2932.5597484276727},{"$f":"'Annexe III'!B34/318","v":399.82075471698113},801.04]
[32,{"$f":"'Annexe II'!B35/318","v":3001.9056603773583},{"$f":"'Annexe III'!B35/318","v":399.82075471698113},826.88]
[33,{"$f":"'Annexe II'!B36/318","v":3071.248427672956},{"$f":"'Annexe III'!B36/318","v":399.82075471698113},852.72]
[34,{"$f":"'Annexe II'!B37/318","v":3140.616352201258},{"$f":"'Annexe III'!B37/318","v":399.82075471698113},878.56]
[35,{"$f":"'Annexe II'!B38/318","v":3209.9748427672957},{"$f":"'Annexe III'!B38/318","v":399.82075471698113},904.4]
[36,{"$f":"'Annexe II'!B39/318","v":3279.3113207547171},{"$f":"'Annexe III'!B39/318","v":399.82075471698113},930.24]
[37,{"$f":"'Annexe II'!B40/318","v":3348.6666666666665},{"$f":"'Annexe III'!B40/318","v":399.82075471698113},956.08]
[38,{"$f":"'Annexe II'!B41/318","v":3418.0031446540879},{"$f":"'Annexe III'!B41/318","v":399.82075471698113},981.92]
[39,{"$f":"'Annexe II'!B42/318","v":3487.3584905660377},{"$f":"'Annexe III'!B42/318","v":399.82075471698113},1007.76]
[40,{"$f":"'Annexe II'!B43/318","v":3625.3553459119498},{"$f":"'Annexe III'!B43/318","v":499.79559748427675},1033.5999999999999]
[41,{"$f":"'Annexe II'!B44/318","v":3694.7106918238992},{"$f":"'Annexe III'!B44/318","v":499.79559748427675},1059.44]
[42,{"$f":"'Annexe II'!B45/318","v":3764.0628930817611},{"$f":"'Annexe III'!B45/318","v":499.79559748427675},1085.28]
[43,{"$f":"'Annexe II'!B46/318","v":3833.3962264150941},{"$f":"'Annexe III'!B46/318","v":499.79559748427675},1111.1199999999999]
[44,{"$f":"'Annexe II'!B47/318","v":3902.7452830188681},{"$f":"'Annexe III'!B47/318","v":499.79559748427675},1136.96]
[45,{"$f":"'Annexe II'!B48/318","v":3972.1037735849059},{"$f":"'Annexe III'!B48/318","v":499.79559748427675},1162.8]
[46,{"$f":"'Annexe II'!B49/318","v":4041.4622641509436},{"$f":"'Annexe III'!B49/318","v":499.79559748427675},1188.6400000000001]
[47,{"$f":"'Annexe II'!B50/318","v":4110.8176100628934},{"$f":"'Annexe III'!B50/318","v":499.79559748427675},1214.48]
[48,{"$f":"'Annexe II'!B51/318","v":4180.1603773584902},{"$f":"'Annexe III'!B51/318","v":499.79559748427675},1240.32]
[49,{"$f":"'Annexe II'!B52/318","v":4249.5094339622638},{"$f":"'Annexe III'!B52/318","v":499.79559748427675},1266.1600000000001]
[50,{"$f":"'Annexe II'!B53/318","v":4318.8396226415098},{"$f":"'Annexe III'!B53/318","v":499.79559748427675},1292]
[51,{"$f":"'Annexe II'!B54/318","v":4388.2106918238997},{"$f":"'Annexe III'!B54/318","v":499.79559748427675},1317.84]
[52,{"$f":"'Annexe II'!B55/318","v":4457.5534591194964},{"$f":"'Annexe III'!B55/318","v":499.79559748427675},1343.68]
[53,{"$f":"'Annexe II'!B56/318","v":4526.9088050314467},{"$f":"'Annexe III'!B56/318","v":499.79559748427675},1369.52]
[54,{"$f":"'Annexe II'!B57/318","v":4596.2578616352203},{"$f":"'Annexe III'!B57/318","v":499.79559748427675},1395.36]
[55,{"$f":"'Annexe II'!B58/318","v":4734.2610062893082},{"$f":"'Annexe III'!B58/318","v":499.79559748427675},1421.2]
[56,{"$f":"'Annexe II'!B59/318","v":4803.6100628930817},{"$f":"'Annexe III'!B59/318","v":499.79559748427675},1447.04]
[57,{"$f":"'Annexe II'!B60/318","v":4872.9654088050311},{"$f":"'Annexe III'!B60/318","v":499.79559748427675},1472.8799999999999]
[58,{"$f":"'Annexe II'!B61/318","v":4942.3018867924529},{"$f":"'Annexe III'!B61/318","v":499.79559748427675},1498.72]
[59,{"$f":"'Annexe II'!B62/318","v":5011.6509433962265},{"$f":"'Annexe III'!B62/318","v":499.79559748427675},1524.56]
[60,{"$f":"'Annexe II'!B63/318","v":5081.0094339622638},{"$f":"'Annexe III'!B63/318","v":515.79245283018872},1550.4]
[61,{"$f":"'Annexe II'!B64/318","v":5150.3396226415098},{"$f":"'Annexe III'!B64/318","v":515.79245283018872},1576.24]
[62,{"$f":"'Annexe II'!B65/318","v":5219.6949685534591},{"$f":"'Annexe III'!B65/318","v":515.79245283018872},1602.08]
[63,{"$f":"'Annexe II'!B66/318","v":5289.0534591194964},{"$f":"'Annexe III'!B66/318","v":515.79245283018872},1627.92]
[64,{"$f":"'Annexe II'!B67/318","v":5358.3962264150941},{"$f":"'Annexe III'!B67/318","v":515.79245283018872},1653.76]
[65,{"$f":"'Annexe II'!B68/318","v":5427.7515723270444},{"$f":"'Annexe III'!B68/318","v":558.77672955974845},1679.6]
[66,{"$f":"'Annexe II'!B69/318","v":5497.0880503144654},{"$f":"'Annexe III'!B69/318","v":558.77672955974845},{"$f":"A69*25.84","v":1705.44}]
[67,{"$f":"'Annexe II'!B70/318","v":5566.4496855345915},{"$f":"'Annexe III'!B70/318","v":558.77672955974845},1731.28]
[68,{"$f":"'Annexe II'!B71/318","v":5635.7955974842771},{"$f":"'Annexe III'!B71/318","v":558.77672955974845},1757.12]
[69,{"$f":"'Annexe II'!B72/318","v":5705.135220125786},{"$f":"'Annexe III'!B72/318","v":558.77672955974845},1782.96]
[70,{"$f":"'Annexe II'!B73/318","v":5843.166666666667},{"$f":"'Annexe III'!B73/318","v":601.75471698113211},1808.8]
[71,{"$f":"'Annexe II'!B74/318","v":5912.5031446540879},{"$f":"'Annexe III'!B74/318","v":601.75471698113211},1834.64]
[72,{"$f":"'Annexe II'!B75/318","v":5981.864779874214},{"$f":"'Annexe III'!B75/318","v":601.75471698113211},1860.48]
[73,{"$f":"'Annexe II'!B76/318","v":6051.2075471698117},{"$f":"'Annexe III'!B76/318","v":601.75471698113211},1886.32]
[74,{"$f":"'Annexe II'!B77/318","v":6120.5597484276732},{"$f":"'Annexe III'!B77/318","v":601.75471698113211},1912.16]
[75,{"$f":"'Annexe II'!B78/318","v":6189.8993710691821},{"$f":"'Annexe III'!B78/318","v":644.74842767295593},1938]
[76,{"$f":"'Annexe II'!B79/318","v":6259.2515723270444},{"$f":"'Annexe III'!B79/318","v":644.74842767295593},1963.84]
[77,{"$f":"'Annexe II'!B80/318","v":6328.5943396226412},{"$f":"'Annexe III'!B80/318","v":644.74842767295593},1989.68]
[78,{"$f":"'Annexe II'!B81/318","v":6397.9496855345915},{"$f":"'Annexe III'!B81/318","v":644.74842767295593},2015.52]
[79,{"$f":"'Annexe II'!B82/318","v":6467.2955974842771},{"$f":"'Annexe III'!B82/318","v":644.74842767295593},2041.36]
[80,{"$f":"'Annexe II'!B83/318","v":6536.6415094339627},{"$f":"'Annexe III'!B83/318","v":687.72327044025155},2067.1999999999998]
[81,{"$f":"'Annexe II'!B84/318","v":6605.9874213836474},{"$f":"'Annexe III'!B84/318","v":687.72327044025155},2093.04]
[82,{"$f":"'Annexe II'!B85/318","v":6675.3364779874209},{"$f":"'Annexe III'!B85/318","v":687.72327044025155},2118.88]
[83,{"$f":"'Annexe II'!B86/318","v":6744.6855345911954},{"$f":"'Annexe III'!B86/318","v":687.72327044025155},2144.7199999999998]
[84,{"$f":"'Annexe II'!B87/318","v":6814.0345911949689},{"$f":"'Annexe III'!B87/318","v":687.72327044025155},2170.56]
[85,{"$f":"'Annexe II'!B88/318","v":6883.3836477987425},{"$f":"'Annexe III'!B88/318","v":730.70125786163521},2196.4]
[86,{"$f":"'Annexe II'!B89/318","v":6952.7295597484281},{"$f":"'Annexe III'!B89/318","v":730.70125786163521},2222.2399999999998]
[87,{"$f":"'Annexe II'!B90/318","v":7022.0786163522016},{"$f":"'Annexe III'!B90/318","v":730.70125786163521},2248.08]
[88,{"$f":"'Annexe II'!B91/318","v":7091.4276729559751},{"$f":"'Annexe III'!B91/318","v":730.70125786163521},2273.92]
[89,{"$f":"'Annexe II'!B92/318","v":7160.7767295597487},{"$f":"'Annexe III'!B92/318","v":730.70125786163521},2299.7599999999998]
[90,{"$f":"'Annexe II'!B93/318","v":7230.1257861635222},{"$f":"'Annexe III'!B93/318","v":773.67924528301887},2325.6]
[91,{"$f":"'Annexe II'!B94/318","v":7299.4716981132078},{"$f":"'Annexe III'!B94/318","v":773.67924528301887},2351.44]
[92,{"$f":"'Annexe II'!B95/318","v":7368.8207547169814},{"$f":"'Annexe III'!B95/318","v":773.67924528301887},2377.2800000000002]
[93,{"$f":"'Annexe II'!B96/318","v":7438.1698113207549},{"$f":"'Annexe III'!B96/318","v":773.67924528301887},2403.12]
[94,{"$f":"'Annexe II'!B97/318","v":7507.5188679245284},{"$f":"'Annexe III'!B97/318","v":773.67924528301887},2428.96]
[95,{"$f":"'Annexe II'!B98/318","v":7576.867924528302},{"$f":"'Annexe III'!B98/318","v":816.6540880503145},2454.8000000000002]
[96,{"$f":"'Annexe II'!B99/318","v":7646.2138364779876},{"$f":"'Annexe III'!B99/318","v":816.6540880503145},2480.64]
[97,{"$f":"'Annexe II'!B100/318","v":7715.5628930817611},{"$f":"'Annexe III'!B100/318","v":816.6540880503145},2506.48]
[98,{"$f":"'Annexe II'!B101/318","v":7784.9119496855346},{"$f":"'Annexe III'!B101/318","v":816.6540880503145},2532.3200000000002]
[99,{"$f":"'Annexe II'!B102/318","v":7854.2610062893082},{"$f":"'Annexe III'!B102/318","v":816.6540880503145},2558.16]
[100,{"$f":"'Annexe II'!B103/318","v":7923.6100628930817},{"$f":"'Annexe III'!B103/318","v":859.63207547169816},2584]

{"sheet":"Calcul env. achat-construction","index":4,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[[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",52]
["Nombre de place 18 mois ou moins (poupons)",10]
["Région","Montréal"]
["Salle multifonctionnelle","oui"]
["Montant de base",{"$f":"VLOOKUP('Calcul env. achat-construction'!B5,'Annexe II'!A4:B103,2,FALSE)","v":1417502}]
["Montant poupon",{"$f":"B6*8219","v":82190}]
["Salle multifonctionnelle",{"$f":"VLOOKUP(B5,'Annexe III'!A4:B103,2,FALSE)","v":158935}]
["Sous-total avant indice régional de modulation ",{"$f":"IF(B8=\"oui\",B9+B10+B11,B9+B10)","v":1658627}]
[]
["Indice régional de modulation",{"$f":"VLOOKUP(B7,'Annexe IV'!A4:B27,2,FALSE)","v":1}]
[]
["Enveloppe maximale achat construction",{"$f":"B12*B14","v":1658627}]
[]
["Enveloppe aménagement extérieur",{"$f":"0.07*B16","v":116103.89000000001}]
[]
["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":119774.49926400001}]
[]
["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":41620.963350000005}]
[]
["Enveloppe mobilier-équipement",{"$f":"_xlfn.IFS(B5<41,(B5*918)+27588+(B6*918),B5>40,(B5*918)+55179+(B6*918))","v":112095}]
[]
["Enveloppe jeux extérieurs",{"$f":"B5*735","v":38220}]
[]
["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":2086441.3526140002}]
[]
["Superficie pi2 AVEC salle multi",{"$f":"SUM(VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul env. achat-construction'!B6,Superficie!A3:D103,4,FALSE),VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D103,3,FALSE))","v":5215.7490566037732}]
[]
["Superficie pi2 SANS salle multi",{"$f":"SUM(VLOOKUP('Calcul env. achat-construction'!B5,Superficie!A3:D103,2,FALSE),VLOOKUP('Calcul env. achat-construction'!B6,Superficie!A3:D103,4,FALSE))","v":4715.9534591194961}]
[]
["Superficie minimum aire de jeu extérieur pi2 ",{"$f":"0.333*(43.0556*B5)","v":745.55076960000008}]
[]
["Superficie recommandée par AQCPE aire de jeu extérieur pi2 ",{"$f":"B40*3","v":2236.6523088000004}]

{"sheet":"Mobilier","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Mobiliers","Qn","Coût","Total",null,"Aménagement extérieur","Qn enfants",null,"Total"]
["Lit poupon",{"$f":"'Calcul env. achat-construction'!B6","v":10},550,{"$f":"B3*C3","v":5500},null,"Sationnement",{"$f":"'Calcul env. achat-construction'!B5","v":52},1225,{"$f":"G3*H3","v":63700}]
["Chaises hautes",{"$f":"'Calcul env. achat-construction'!B6","v":10},350,{"$f":"B4*C4","v":3500},null,"Aménagement paysager",{"$f":"'Calcul env. achat-construction'!B5","v":52},155,{"$f":"G4*H4","v":8060}]
["Tables",{"$f":"('Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6)/4","v":10.5},350,{"$f":"B5*C5","v":3675},null,"Gazon ",{"$f":"'Calcul env. achat-construction'!B5","v":52},250,13000]
["Chaises",{"$f":"'Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6","v":42},150,{"$f":"B6*C6","v":6300},null,"Clôture",{"$f":"'Calcul env. achat-construction'!B5","v":52},300,15600]
["Tables perso et chaises",1,1500,{"$f":"B7*C7","v":1500},null,"TOTAL AMÉNAGEMENT EXTÉRIEUR",null,{"$f":"SUM(H3:H6)","v":1930},{"$f":"SUM(I3:I6)","v":100360}]
["TOTAL ÉQUIPEMENT MEUBLE",null,null,{"$f":"SUM(D3:D7)","v":20475}]
[]
["Buanderie"]
["Laveuse",1,1500,{"$f":"C11*B11","v":1500}]
["Sécheuse",1,1500,{"$f":"C12*B12","v":1500}]
["Cuisine"]
["Hotte",1,5000,{"$f":"B14*C14","v":5000}]
["Frigo",1,6000,{"$f":"B15*C15","v":6000}]
["Congélo",1,6000,{"$f":"B16*C16","v":6000}]
["Cuisinière",1,5000,{"$f":"B17*C17","v":5000}]
["Lave-vaisselle",1,5000,{"$f":"B18*C18","v":5000}]
["TOTAL CUISINE BUANDERIE",null,null,{"$f":"SUM(D10:D18)","v":30000}]
[]
["Bureaux et chaises",1,1250,{"$f":"C21*B21","v":1250}]
["TOTAL ÉQUIPEMENT BUREAU",null,null,{"$f":"SUM(D21:D21)","v":1250}]
[]
["Ordinateur",1,1250,{"$f":"C24*B24","v":1250}]
["Imprimante",1,1250,{"$f":"C25*B25","v":1250}]
["TOTAL MATÉRIEL INFORMATIQUE",null,null,{"$f":"SUM(D24:D25)","v":2500}]
[]
["Matériel éducatif",{"$f":"'Calcul env. achat-construction'!B5","v":52},425,{"$f":"C28*B28","v":22100}]
["TOTAL MATÉRIEL ÉDUCATIF",null,null,{"$f":"SUM(D28:D28)","v":22100}]
[]
["Jouets",{"$f":"'Calcul env. achat-construction'!B5","v":52},400,{"$f":"C31*B31","v":20800}]
["TOTAL JOUETS",null,null,{"$f":"D31","v":20800}]

{"sheet":"Budget d'implantation","index":6,"n_rows":235,"n_cols":9,"rows_kept":235,"cut":false,"hidden":true,"merged":[[91,3,91,6],[192,3,192,6],[223,6,223,7],[1,5,1,6],[1,7,1,8],[2,7,2,8],[4,2,4,7],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,null,null,null,"Date de préparation:"]
[null,null,null,null,null,null,"Préparé par:"]
[]
[null,null,"BUDGET D'IMPLANTATION PFI"]
[]
["Type de projet:",null,"Achat terrain pour installation d'un préfabriqué",null,null,null,null,"R/B:"]
["Nom du CPE :"]
["No de division :",null,null,null,null,null,"Nombre de places 0-17 mois :",null,{"$f":"'Calcul env. achat-construction'!B6","v":10}]
["No d'installation :",null,null,null,null,null,"Nombre de places 18-59 mois :",null,{"$f":"'Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6","v":42}]
["Dimension installation (en m2):",null,null,null,null,null,"Date d'ouverture :"]
["Dimension salle multi (en m2):"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
["Achat - construction"]
[null,null,"Enveloppe Achat-Construction",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B16","v":1658627}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I21:I24)","v":1658627}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I43","v":0}]
[]
[null,null,"Enveloppe reconnue Achat-Construction (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I25,I27)","v":0}]
[]
[]
[null,"Coût de construction ou d'agrandissement",null,null,null,null,{"$f":"(F32*TPS)+(F32*TVQ)","v":0},{"$f":"(F32+G32)","v":0},{"$f":"ROUND(F32+(G32/2),2)","v":0}]
[null,"Branchement temporaire aux services publics",null,null,null,null,0,{"$f":"(F33+G33)","v":0},{"$f":"ROUND(F33+(G33/2),2)","v":0}]
[null,"Aménagement de voies de circulation temporaire",null,null,null,null,0,0,0]
[null,"Permis de construction",null,null,null,null,0,0,0]
[null,"Assurances exigées pour les travaux",null,null,null,null,0,0,0]
[null,"Achat d'un bâtiment",null,null,null,null,0,0,0]
[null,"Amélioration locative",null,null,null,null,0,0,0]
[null,"Rénovation ou réaménagement",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F41*TPS)+(F41*TVQ)","v":0},0,0]
[null,"Autres (préciser) :","Contingences ",null,null,null,0,0,0]
["Total – Achat - construction",null,null,null,null,null,{"$f":"SUM(G32:G42)","v":0},{"$f":"SUM(H32:H42)","v":0},{"$f":"SUM(I32:I42)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I25-I43","v":1658627}]
[]
[]
["Mobilier et Équipement"]
[null,null,"Enveloppe Mobilier et Équipement",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B24","v":112095}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I48:I51)","v":112095}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I67","v":104397.23999999999}]
[]
[null,null,"Enveloppe reconnue Mobilier et Équipement (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I52,I54)","v":104397.23999999999}]
[]
[]
[null,"Équipements meubles",null,null,null,{"$f":"Mobilier!D8","v":20475},{"$f":"(F59*TPS)+(F59*TVQ)","v":3066.1312500000004},{"$f":"(F59+G59)","v":23541.131249999999},{"$f":"ROUND(F59+(G59/2),2)","v":22008.07}]
[null,"Équipements de cuisine ou de buanderie",null,null,null,{"$f":"Mobilier!D19","v":30000},4492.5,{"$f":"(F60+G60)","v":34492.5},{"$f":"ROUND(F60+(G60/2),2)","v":32246.25}]
[null,"Matériel et mobilier de bureau",null,null,null,{"$f":"Mobilier!D22","v":1250},187.1875,1437.1875,1343.59]
[null,"Matériel informatique",null,null,null,{"$f":"Mobilier!D26","v":2500},374.375,2874.375,2687.19]
[null,"Matériel éducatif",null,null,null,{"$f":"Mobilier!D29","v":22100},3309.4749999999999,25409.474999999999,23754.74]
[null,"Jouets destinés aux aires de jeux",null,null,null,{"$f":"Mobilier!D32","v":20800},3114.8,23914.799999999999,22357.4]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Mobilier et équipement",null,null,null,null,null,{"$f":"SUM(G59:G66)","v":14544.46875},{"$f":"SUM(H59:H66)","v":111669.46875},{"$f":"SUM(I59:I66)","v":104397.23999999999}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I52-I67","v":7697.7600000000093}]
[]
[]
[]
["Jeux Extérieurs"]
[null,null,"Enveloppe Jeux Extérieurs",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B26","v":38220}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I73:I76)","v":38220}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I87","v":0}]
[]
[null,null,"Enveloppe reconnue Jeux extérieurs (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I77,I79)","v":0}]
[]
[]
[null,"Jeux extérieurs",null,null,null,null,{"$f":"(F84*TPS)+(F84*TVQ)","v":0},{"$f":"(F84+G84)","v":0},{"$f":"ROUND(F84+(G84/2),2)","v":0}]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F85*TPS)+(F85*TVQ)","v":0},{"$f":"(F85+G85)","v":0},{"$f":"ROUND(F85+(G85/2),2)","v":0}]
[null,"Réserves pour imprévus",null,null,null,null,{"$f":"(F86*TPS)+(F86*TVQ)","v":0},0,0]
["Total – Jeux extérieurs",null,null,null,null,null,{"$f":"SUM(G84:G86)","v":0},{"$f":"SUM(H84:H86)","v":0},{"$f":"SUM(I84:I86)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I77-I87","v":38220}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
[]
[null,null,null,"Budget d'implantantion (suite)"]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[]
["Aménagement Extérieur"]
[null,null,"Enveloppe Aménagement Extérieur",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B18","v":116103.89000000001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I98:I101)","v":116103.89000000001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I116","v":107874.46}]
[]
[null,null,"Enveloppe reconnue Aménagement extérieur (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I102,I104)","v":107874.46}]
[]
[]
[null,"Stationnement",null,null,null,{"$f":"Mobilier!I3","v":63700},{"$f":"(F109*TPS)+(F109*TVQ)","v":9539.0750000000007},{"$f":"(F109+G109)","v":73239.074999999997},{"$f":"ROUND(F109+(G109/2),2)","v":68469.539999999994}]
[null,"Aménagement paysager",null,null,null,{"$f":"Mobilier!I4","v":8060},1206.9850000000001,{"$f":"(F110+G110)","v":9266.9850000000006},{"$f":"ROUND(F110+(G110/2),2)","v":8663.49}]
[null,"Gazonnement",null,null,null,{"$f":"Mobilier!I5","v":13000},1946.75,14946.75,13973.38]
[null,"Clôture",null,null,null,{"$f":"Mobilier!I6","v":15600},2336.1000000000004,17936.099999999999,16768.05]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :"]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
["Total – Aménagement extérieur",null,null,null,null,null,{"$f":"SUM(G109:G115)","v":15028.910000000002},{"$f":"SUM(H109:H115)","v":115388.91},{"$f":"SUM(I109:I115)","v":107874.46}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I102-I116","v":8229.4300000000076}]
[]
[" Honoraires Professionnels"]
[null,null,"Enveloppe Honoraire Professionnels",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B20","v":119774.49926400001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I120:I123)","v":119774.49926400001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I140","v":0}]
[]
[null,null,"Enveloppe reconnue Honoraires Professionnels (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I124,I126)","v":0}]
[]
[]
[null,"Architecte ",null,null,null,null,{"$f":"(F131*TPS)+(F131*TVQ)","v":0},{"$f":"(F131+G131)","v":0},{"$f":"ROUND(F131+(G131/2),2)","v":0}]
[null,"Ingénieur (génie civil et structure)",null,null,null,null,0,{"$f":"(F132+G132)","v":0},{"$f":"ROUND(F132+(G132/2),2)","v":0}]
[null,"Ingénieur (génie mécanique et électrique) ",null,null,null,null,{"$f":"(F133*TPS)+(F133*TVQ)","v":0},0,0]
[null,"Arpenteur",null,null,null,null,0,0,0]
[null,"Comptable",null,null,null,null,0,0,0]
[null,"Notaire, Avocat",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F138*TPS)+(F138*TVQ)","v":0},0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Honoraires professionnels",null,null,null,null,{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},{"$f":"SUM(H131:H139)","v":0},{"$f":"SUM(I131:I139)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I124-I140","v":119774.49926400001}]
[]
["Chargé de Projet"]
[null,null,"Enveloppe Chargé de Projet"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B22","v":41620.963350000005}]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I145:I147)","v":41620.963350000005}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I156","v":0}]
[]
[null,null,"Enveloppe reconnue Chargé de Projet (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I148,I150)","v":0}]
[]
[]
[null,"Chargé de Projet",null,null,null,null,{"$f":"(F155*TPS)+(F155*TVQ)","v":0},{"$f":"(F155+G155)","v":0},{"$f":"ROUND(F155+(G155/2),2)","v":0}]
["Total – Chargé de Projet",null,null,null,null,null,{"$f":"SUM(G155)","v":0},{"$f":"SUM(H155)","v":0},{"$f":"SUM(I155)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I148-I156","v":41620.963350000005}]
[]
["Terrain"]
[null,null,"Enveloppe Terrain"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I160:I163)","v":0}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I162+I163","v":0}]
[]
[null,null,"Enveloppe reconnue Terrain (minimum entre A et B)",null,null,null,null,null,{"$f":"I164+I165","v":0}]
[]
[]
[null,"Coût d'achat du terrain 2",null,null,null,null,{"$f":"(F171*TPS)+(F171*TVQ)","v":0},{"$f":"(F171+G171)","v":0},{"$f":"ROUND(F171+(G171/2),2)","v":0}]
[null,"Études de sol",null,null,null,null,0,{"$f":"(F172+G172)","v":0},{"$f":"ROUND(F172+(G172/2),2)","v":0}]
[null,"Certificat de localisation",null,null,null,null,0,0,0]
[null,"Nivellement du terrain",null,null,null,null,0,0,0]
[null,"Frais de déboisement",null,null,null,null,0,0,0]
[null,"Frais de démolition sur le terrain",null,null,null,null,0,0,0]
[null,"Infrastructures 3",null,null,null,null,0,0,0]
[null,"Décontamination du terrain",null,null,null,0,0,0,0]
[null,"Autres (préciser) : ","Bolard, 2 ponceaux, végétalisation, clôture",null,null,null,0,0,0]
[null,"Réserves pour imprévus","Contingence 10%",null,null,null,0,0,0]
["Total – Terrain",null,null,null,null,{"$f":"SUM(F171:F180)","v":0},{"$f":"SUM(G171:G180)","v":0},{"$f":"SUM(H171:H180)","v":0},{"$f":"SUM(I171:I180)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I164-I181","v":0}]
[]
[]
["TOTAL DES COÛTS RÉELS DU PROJET",null,null,null,null,{"$f":"F43+F67+F87+F116+F140+F156+F181","v":0},{"$f":"G43+G67+G87+G116+G140+G156+G181","v":29573.378750000003},{"$f":"H43+H67+H87+H116+H140+H156+H181","v":227058.37875},{"$f":"I43+I67+I87+I116+I140+I156+I181","v":212271.7}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
["2 Comprend aussi le pourcentage du terrain si on achète un bâtiment."]
["3 Infrastructures (branchement aux services publics, fosse septique, puits artésien)."]
[]
[]
[]
[null,null,null,"Financement du Projet"]
["Nom du CPE:"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
[]
["Total de toutes les enveloppes de financement du MFA",null,null,null,null,null,null,null,{"$f":"I148+I124+I102+I77+I52+I25+I164","v":2086441.352614}]
[]
[]
["Liquidités qui viennent diminuer les enveloppes de financement du MFA"]
[]
[null,"Indemnités de l'assurance ou d'un prog gouv.",null,null,null,null,{"$f":"(F208*TPS)+(F208*TVQ)","v":0},{"$f":"(F208+G208)","v":0},{"$f":"ROUND(F208+(G208/2),2)","v":0}]
[null,"Produit de vente d'actifs immobiliers",null,null,null,null,0,0,0]
[null,"Liquidités investies dans le projet par le CPE",null,null,null,null,0,0,0]
[null,"Subventions d'autres organismes",null,null,null,null,{"$f":"(F211*TPS)+(F211*TVQ)","v":0},0,0]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
["Total des Liquidités (Mise de fonds)",null,null,null,null,{"$f":"SUM(F208:F210)","v":0},{"$f":"SUM(G208:G210)","v":0},{"$f":"SUM(H208:H210)","v":0},{"$f":"SUM(I208:I210)","v":0}]
[]
[]
["Liquidités qui s'ajoutent aux enveloppes de financement du MFA"]
[]
[null,"Subventions de d'autres organismes",null,null,null,null,{"$f":"(F219*TPS)+(F219*TVQ)","v":0},{"$f":"(F219+G219)","v":0},{"$f":"ROUND(F219+(G219/2),2)","v":0}]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
[null,"Liquidité investies par le CPE (Liquidité Plus)",null,null,null,null,null,null,0]
["Total des Liquidités Bonifiant Le Projet",null,null,null,null,{"$f":"SUM(F219:F222)","v":0},{"$f":"SUM(G219:G222)","v":0},{"$f":"SUM(H219:H222)","v":0},{"$f":"SUM(I219:I222)","v":0}]
[]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE PAR LE PROGRAMME DE FINANCEMENT DES INFRASTRUCTURES",null,null,null,null,null,null,null,{"$f":"I203-I214","v":2086441.352614}]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE POUR LE PROJET :",null,null,null,null,null,null,null,{"$f":"I214+I223+I228","v":2086441.352614}]
[]
[]
[null,null,null,"Équilibre du budget:",null,null,"(Doit être  à 0$ ou  +)",null,{"$f":"I232-I185","v":1874169.652614}]

{"sheet":"Budget modifié","index":7,"n_rows":235,"n_cols":9,"rows_kept":235,"cut":false,"hidden":true,"merged":[[91,3,91,6],[192,3,192,6],[223,6,223,7],[1,5,1,6],[1,7,1,8],[2,7,2,8],[4,2,4,7],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,null,null,null,"Date de préparation:"]
[null,null,null,null,null,null,"Préparé par:"]
[]
[null,null,"BUDGET D'IMPLANTATION PFI"]
[]
["Type de projet:",null,null,null,null,null,null,"R/B:"]
["Nom du CPE :"]
["No de division :",null,null,null,null,null,"Nombre de places 0-17 mois :",null,{"$f":"'Calcul env. achat-construction'!B6","v":10}]
["No d'installation :",null,null,null,null,null,"Nombre de places 18-59 mois :",null,{"$f":"'Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6","v":42}]
["Dimension installation (en m2):",null,null,null,null,null,"Date d'ouverture :"]
["Dimension salle multi (en m2):"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
["Achat - construction"]
[null,null,"Enveloppe Achat-Construction",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B16","v":1658627}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I21:I24)","v":1658627}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I43","v":0}]
[]
[null,null,"Enveloppe reconnue Achat-Construction (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I25,I27)","v":0}]
[]
[]
[null,"Coût de construction ou d'agrandissement",null,null,null,null,{"$f":"(F32*TPS)+(F32*TVQ)","v":0},{"$f":"(F32+G32)","v":0},{"$f":"ROUND(F32+(G32/2),2)","v":0}]
[null,"Branchement temporaire aux services publics",null,null,null,null,0,{"$f":"(F33+G33)","v":0},{"$f":"ROUND(F33+(G33/2),2)","v":0}]
[null,"Aménagement de voies de circulation temporaire",null,null,null,null,0,0,0]
[null,"Permis de construction",null,null,null,null,0,0,0]
[null,"Assurances exigées pour les travaux",null,null,null,null,0,0,0]
[null,"Achat d'un bâtiment",null,null,null,null,0,0,0]
[null,"Amélioration locative",null,null,null,null,0,0,0]
[null,"Rénovation ou réaménagement",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F41*TPS)+(F41*TVQ)","v":0},0,0]
[null,"Autres (préciser) :","Contingences ",null,null,null,0,0,0]
["Total – Achat - construction",null,null,null,null,null,{"$f":"SUM(G32:G42)","v":0},{"$f":"SUM(H32:H42)","v":0},{"$f":"SUM(I32:I42)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I25-I43","v":1658627}]
[]
[]
["Mobilier et Équipement"]
[null,null,"Enveloppe Mobilier et Équipement",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B24","v":112095}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I48:I51)","v":112095}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I67","v":104397.23999999999}]
[]
[null,null,"Enveloppe reconnue Mobilier et Équipement (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I52,I54)","v":104397.23999999999}]
[]
[]
[null,"Équipements meubles",null,null,null,{"$f":"Mobilier!D8","v":20475},{"$f":"(F59*TPS)+(F59*TVQ)","v":3066.1312500000004},{"$f":"(F59+G59)","v":23541.131249999999},{"$f":"ROUND(F59+(G59/2),2)","v":22008.07}]
[null,"Équipements de cuisine ou de buanderie",null,null,null,{"$f":"Mobilier!D19","v":30000},4492.5,{"$f":"(F60+G60)","v":34492.5},{"$f":"ROUND(F60+(G60/2),2)","v":32246.25}]
[null,"Matériel et mobilier de bureau",null,null,null,{"$f":"Mobilier!D22","v":1250},187.1875,1437.1875,1343.59]
[null,"Matériel informatique",null,null,null,{"$f":"Mobilier!D26","v":2500},374.375,2874.375,2687.19]
[null,"Matériel éducatif",null,null,null,{"$f":"Mobilier!D29","v":22100},3309.4749999999999,25409.474999999999,23754.74]
[null,"Jouets destinés aux aires de jeux",null,null,null,{"$f":"Mobilier!D32","v":20800},3114.8,23914.799999999999,22357.4]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Mobilier et équipement",null,null,null,null,null,{"$f":"SUM(G59:G66)","v":14544.46875},{"$f":"SUM(H59:H66)","v":111669.46875},{"$f":"SUM(I59:I66)","v":104397.23999999999}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I52-I67","v":7697.7600000000093}]
[]
[]
[]
["Jeux Extérieurs"]
[null,null,"Enveloppe Jeux Extérieurs",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B26","v":38220}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I73:I76)","v":38220}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I87","v":0}]
[]
[null,null,"Enveloppe reconnue Jeux extérieurs (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I77,I79)","v":0}]
[]
[]
[null,"Jeux extérieurs",null,null,null,null,{"$f":"(F84*TPS)+(F84*TVQ)","v":0},{"$f":"(F84+G84)","v":0},{"$f":"ROUND(F84+(G84/2),2)","v":0}]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F85*TPS)+(F85*TVQ)","v":0},{"$f":"(F85+G85)","v":0},{"$f":"ROUND(F85+(G85/2),2)","v":0}]
[null,"Réserves pour imprévus",null,null,null,null,{"$f":"(F86*TPS)+(F86*TVQ)","v":0},0,0]
["Total – Jeux extérieurs",null,null,null,null,null,{"$f":"SUM(G84:G86)","v":0},{"$f":"SUM(H84:H86)","v":0},{"$f":"SUM(I84:I86)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I77-I87","v":38220}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
[]
[null,null,null,"Budget d'implantantion (suite)"]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[]
["Aménagement Extérieur"]
[null,null,"Enveloppe Aménagement Extérieur",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B18","v":116103.89000000001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I98:I101)","v":116103.89000000001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I116","v":107874.46}]
[]
[null,null,"Enveloppe reconnue Aménagement extérieur (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I102,I104)","v":107874.46}]
[]
[]
[null,"Stationnement",null,null,null,{"$f":"Mobilier!I3","v":63700},{"$f":"(F109*TPS)+(F109*TVQ)","v":9539.0750000000007},{"$f":"(F109+G109)","v":73239.074999999997},{"$f":"ROUND(F109+(G109/2),2)","v":68469.539999999994}]
[null,"Aménagement paysager",null,null,null,{"$f":"Mobilier!I4","v":8060},1206.9850000000001,{"$f":"(F110+G110)","v":9266.9850000000006},{"$f":"ROUND(F110+(G110/2),2)","v":8663.49}]
[null,"Gazonnement",null,null,null,{"$f":"Mobilier!I5","v":13000},1946.75,14946.75,13973.38]
[null,"Clôture",null,null,null,{"$f":"Mobilier!I6","v":15600},2336.1000000000004,17936.099999999999,16768.05]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :"]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
["Total – Aménagement extérieur",null,null,null,null,null,{"$f":"SUM(G109:G115)","v":15028.910000000002},{"$f":"SUM(H109:H115)","v":115388.91},{"$f":"SUM(I109:I115)","v":107874.46}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I102-I116","v":8229.4300000000076}]
[]
[" Honoraires Professionnels"]
[null,null,"Enveloppe Honoraire Professionnels",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B20","v":119774.49926400001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I120:I123)","v":119774.49926400001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I140","v":0}]
[]
[null,null,"Enveloppe reconnue Honoraires Professionnels (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I124,I126)","v":0}]
[]
[]
[null,"Architecte ",null,null,null,null,{"$f":"(F131*TPS)+(F131*TVQ)","v":0},{"$f":"(F131+G131)","v":0},{"$f":"ROUND(F131+(G131/2),2)","v":0}]
[null,"Ingénieur (génie civil et structure)",null,null,null,null,0,{"$f":"(F132+G132)","v":0},{"$f":"ROUND(F132+(G132/2),2)","v":0}]
[null,"Ingénieur (génie mécanique et électrique) ",null,null,null,null,{"$f":"(F133*TPS)+(F133*TVQ)","v":0},0,0]
[null,"Arpenteur",null,null,null,null,0,0,0]
[null,"Comptable",null,null,null,null,0,0,0]
[null,"Notaire, Avocat",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F138*TPS)+(F138*TVQ)","v":0},0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Honoraires professionnels",null,null,null,null,{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},{"$f":"SUM(H131:H139)","v":0},{"$f":"SUM(I131:I139)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I124-I140","v":119774.49926400001}]
[]
["Chargé de Projet"]
[null,null,"Enveloppe Chargé de Projet"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B22","v":41620.963350000005}]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I145:I147)","v":41620.963350000005}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I156","v":0}]
[]
[null,null,"Enveloppe reconnue Chargé de Projet (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I148,I150)","v":0}]
[]
[]
[null,"Chargé de Projet",null,null,null,null,{"$f":"(F155*TPS)+(F155*TVQ)","v":0},{"$f":"(F155+G155)","v":0},{"$f":"ROUND(F155+(G155/2),2)","v":0}]
["Total – Chargé de Projet",null,null,null,null,null,{"$f":"SUM(G155)","v":0},{"$f":"SUM(H155)","v":0},{"$f":"SUM(I155)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I148-I156","v":41620.963350000005}]
[]
["Terrain"]
[null,null,"Enveloppe Terrain"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I160:I163)","v":0}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I162+I163","v":0}]
[]
[null,null,"Enveloppe reconnue Terrain (minimum entre A et B)",null,null,null,null,null,{"$f":"I164+I165","v":0}]
[]
[]
[null,"Coût d'achat du terrain 2",null,null,null,null,{"$f":"(F171*TPS)+(F171*TVQ)","v":0},{"$f":"(F171+G171)","v":0},{"$f":"ROUND(F171+(G171/2),2)","v":0}]
[null,"Études de sol",null,null,null,null,0,{"$f":"(F172+G172)","v":0},{"$f":"ROUND(F172+(G172/2),2)","v":0}]
[null,"Certificat de localisation",null,null,null,null,0,0,0]
[null,"Nivellement du terrain",null,null,null,null,0,0,0]
[null,"Frais de déboisement",null,null,null,null,0,0,0]
[null,"Frais de démolition sur le terrain",null,null,null,null,0,0,0]
[null,"Infrastructures 3",null,null,null,null,0,0,0]
[null,"Décontamination du terrain",null,null,null,0,0,0,0]
[null,"Autres (préciser) : ","Bolard, 2 ponceaux, végétalisation, clôture",null,null,null,0,0,0]
[null,"Réserves pour imprévus","Contingence 10%",null,null,null,0,0,0]
["Total – Terrain",null,null,null,null,{"$f":"SUM(F171:F180)","v":0},{"$f":"SUM(G171:G180)","v":0},{"$f":"SUM(H171:H180)","v":0},{"$f":"SUM(I171:I180)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I164-I181","v":0}]
[]
[]
["TOTAL DES COÛTS RÉELS DU PROJET",null,null,null,null,{"$f":"F43+F67+F87+F116+F140+F156+F181","v":0},{"$f":"G43+G67+G87+G116+G140+G156+G181","v":29573.378750000003},{"$f":"H43+H67+H87+H116+H140+H156+H181","v":227058.37875},{"$f":"I43+I67+I87+I116+I140+I156+I181","v":212271.7}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
["2 Comprend aussi le pourcentage du terrain si on achète un bâtiment."]
["3 Infrastructures (branchement aux services publics, fosse septique, puits artésien)."]
[]
[]
[]
[null,null,null,"Financement du Projet"]
["Nom du CPE:"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
[]
["Total de toutes les enveloppes de financement du MFA",null,null,null,null,null,null,null,{"$f":"I148+I124+I102+I77+I52+I25","v":2086441.352614}]
[]
[]
["Liquidités qui viennent diminuer les enveloppes de financement du MFA"]
[]
[null,"Indemnités de l'assurance ou d'un prog gouv.",null,null,null,null,{"$f":"(F208*TPS)+(F208*TVQ)","v":0},{"$f":"(F208+G208)","v":0},{"$f":"ROUND(F208+(G208/2),2)","v":0}]
[null,"Produit de vente d'actifs immobiliers",null,null,null,null,0,0,0]
[null,"Liquidités investies dans le projet par le CPE",null,null,null,null,0,0,0]
[null,"Subventions d'autres organismes",null,null,null,null,{"$f":"(F211*TPS)+(F211*TVQ)","v":0},0,0]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
["Total des Liquidités (Mise de fonds)",null,null,null,null,{"$f":"SUM(F208:F210)","v":0},{"$f":"SUM(G208:G210)","v":0},{"$f":"SUM(H208:H210)","v":0},{"$f":"SUM(I208:I210)","v":0}]
[]
[]
["Liquidités qui s'ajoutent aux enveloppes de financement du MFA"]
[]
[null,"Subventions de d'autres organismes",null,null,null,null,{"$f":"(F219*TPS)+(F219*TVQ)","v":0},{"$f":"(F219+G219)","v":0},{"$f":"ROUND(F219+(G219/2),2)","v":0}]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
[null,"Liquidité investies par le CPE (Liquidité Plus)",null,null,null,null,null,null,0]
["Total des Liquidités Bonifiant Le Projet",null,null,null,null,{"$f":"SUM(F219:F222)","v":0},{"$f":"SUM(G219:G222)","v":0},{"$f":"SUM(H219:H222)","v":0},{"$f":"SUM(I219:I222)","v":0}]
[]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE PAR LE PROGRAMME DE FINANCEMENT DES INFRASTRUCTURES",null,null,null,null,null,null,null,{"$f":"I203-I214","v":2086441.352614}]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE POUR LE PROJET :",null,null,null,null,null,null,null,{"$f":"I214+I223+I228","v":2086441.352614}]
[]
[]
[null,null,null,"Équilibre du budget:",null,null,"(Doit être  à 0$ ou  +)",null,{"$f":"I232-I185","v":1874169.652614}]

{"sheet":"Budget coûts réels","index":8,"n_rows":235,"n_cols":9,"rows_kept":235,"cut":false,"hidden":true,"merged":[[91,3,91,6],[192,3,192,6],[223,6,223,7],[1,5,1,6],[1,7,1,8],[2,7,2,8],[4,2,4,7],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,null,null,null,"Date de préparation:"]
[null,null,null,null,null,null,"Préparé par:"]
[]
[null,null,"BUDGET D'IMPLANTATION PFI"]
[]
["Type de projet:",null,null,null,null,null,null,"R/B:"]
["Nom du CPE :"]
["No de division :",null,null,null,null,null,"Nombre de places 0-17 mois :",null,{"$f":"'Calcul env. achat-construction'!B6","v":10}]
["No d'installation :",null,null,null,null,null,"Nombre de places 18-59 mois :",null,{"$f":"'Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6","v":42}]
["Dimension installation (en m2):",null,null,null,null,null,"Date d'ouverture :"]
["Dimension salle multi (en m2):"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
["Achat - construction"]
[null,null,"Enveloppe Achat-Construction",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B16","v":1658627}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I21:I24)","v":1658627}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I43","v":0}]
[]
[null,null,"Enveloppe reconnue Achat-Construction (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I25,I27)","v":0}]
[]
[]
[null,"Coût de construction ou d'agrandissement",null,null,null,null,{"$f":"(F32*TPS)+(F32*TVQ)","v":0},{"$f":"(F32+G32)","v":0},{"$f":"ROUND(F32+(G32/2),2)","v":0}]
[null,"Branchement temporaire aux services publics",null,null,null,null,0,{"$f":"(F33+G33)","v":0},{"$f":"ROUND(F33+(G33/2),2)","v":0}]
[null,"Aménagement de voies de circulation temporaire",null,null,null,null,0,0,0]
[null,"Permis de construction",null,null,null,null,0,0,0]
[null,"Assurances exigées pour les travaux",null,null,null,null,0,0,0]
[null,"Achat d'un bâtiment",null,null,null,null,0,0,0]
[null,"Amélioration locative",null,null,null,null,0,0,0]
[null,"Rénovation ou réaménagement",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F41*TPS)+(F41*TVQ)","v":0},0,0]
[null,"Autres (préciser) :","Contingences ",null,null,null,0,0,0]
["Total – Achat - construction",null,null,null,null,null,{"$f":"SUM(G32:G42)","v":0},{"$f":"SUM(H32:H42)","v":0},{"$f":"SUM(I32:I42)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I25-I43","v":1658627}]
[]
[]
["Mobilier et Équipement"]
[null,null,"Enveloppe Mobilier et Équipement",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B24","v":112095}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I48:I51)","v":112095}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I67","v":104397.23999999999}]
[]
[null,null,"Enveloppe reconnue Mobilier et Équipement (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I52,I54)","v":104397.23999999999}]
[]
[]
[null,"Équipements meubles",null,null,null,{"$f":"Mobilier!D8","v":20475},{"$f":"(F59*TPS)+(F59*TVQ)","v":3066.1312500000004},{"$f":"(F59+G59)","v":23541.131249999999},{"$f":"ROUND(F59+(G59/2),2)","v":22008.07}]
[null,"Équipements de cuisine ou de buanderie",null,null,null,{"$f":"Mobilier!D19","v":30000},4492.5,{"$f":"(F60+G60)","v":34492.5},{"$f":"ROUND(F60+(G60/2),2)","v":32246.25}]
[null,"Matériel et mobilier de bureau",null,null,null,{"$f":"Mobilier!D22","v":1250},187.1875,1437.1875,1343.59]
[null,"Matériel informatique",null,null,null,{"$f":"Mobilier!D26","v":2500},374.375,2874.375,2687.19]
[null,"Matériel éducatif",null,null,null,{"$f":"Mobilier!D29","v":22100},3309.4749999999999,25409.474999999999,23754.74]
[null,"Jouets destinés aux aires de jeux",null,null,null,{"$f":"Mobilier!D32","v":20800},3114.8,23914.799999999999,22357.4]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Mobilier et équipement",null,null,null,null,null,{"$f":"SUM(G59:G66)","v":14544.46875},{"$f":"SUM(H59:H66)","v":111669.46875},{"$f":"SUM(I59:I66)","v":104397.23999999999}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I52-I67","v":7697.7600000000093}]
[]
[]
[]
["Jeux Extérieurs"]
[null,null,"Enveloppe Jeux Extérieurs",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B26","v":38220}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I73:I76)","v":38220}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I87","v":0}]
[]
[null,null,"Enveloppe reconnue Jeux extérieurs (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I77,I79)","v":0}]
[]
[]
[null,"Jeux extérieurs",null,null,null,null,{"$f":"(F84*TPS)+(F84*TVQ)","v":0},{"$f":"(F84+G84)","v":0},{"$f":"ROUND(F84+(G84/2),2)","v":0}]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F85*TPS)+(F85*TVQ)","v":0},{"$f":"(F85+G85)","v":0},{"$f":"ROUND(F85+(G85/2),2)","v":0}]
[null,"Réserves pour imprévus",null,null,null,null,{"$f":"(F86*TPS)+(F86*TVQ)","v":0},0,0]
["Total – Jeux extérieurs",null,null,null,null,null,{"$f":"SUM(G84:G86)","v":0},{"$f":"SUM(H84:H86)","v":0},{"$f":"SUM(I84:I86)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I77-I87","v":38220}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
[]
[null,null,null,"Budget d'implantantion (suite)"]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[]
["Aménagement Extérieur"]
[null,null,"Enveloppe Aménagement Extérieur",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B18","v":116103.89000000001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I98:I101)","v":116103.89000000001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I116","v":107874.46}]
[]
[null,null,"Enveloppe reconnue Aménagement extérieur (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I102,I104)","v":107874.46}]
[]
[]
[null,"Stationnement",null,null,null,{"$f":"Mobilier!I3","v":63700},{"$f":"(F109*TPS)+(F109*TVQ)","v":9539.0750000000007},{"$f":"(F109+G109)","v":73239.074999999997},{"$f":"ROUND(F109+(G109/2),2)","v":68469.539999999994}]
[null,"Aménagement paysager",null,null,null,{"$f":"Mobilier!I4","v":8060},1206.9850000000001,{"$f":"(F110+G110)","v":9266.9850000000006},{"$f":"ROUND(F110+(G110/2),2)","v":8663.49}]
[null,"Gazonnement",null,null,null,{"$f":"Mobilier!I5","v":13000},1946.75,14946.75,13973.38]
[null,"Clôture",null,null,null,{"$f":"Mobilier!I6","v":15600},2336.1000000000004,17936.099999999999,16768.05]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :"]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
["Total – Aménagement extérieur",null,null,null,null,null,{"$f":"SUM(G109:G115)","v":15028.910000000002},{"$f":"SUM(H109:H115)","v":115388.91},{"$f":"SUM(I109:I115)","v":107874.46}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I102-I116","v":8229.4300000000076}]
[]
[" Honoraires Professionnels"]
[null,null,"Enveloppe Honoraire Professionnels",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B20","v":119774.49926400001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I120:I123)","v":119774.49926400001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I140","v":0}]
[]
[null,null,"Enveloppe reconnue Honoraires Professionnels (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I124,I126)","v":0}]
[]
[]
[null,"Architecte ",null,null,null,null,{"$f":"(F131*TPS)+(F131*TVQ)","v":0},{"$f":"(F131+G131)","v":0},{"$f":"ROUND(F131+(G131/2),2)","v":0}]
[null,"Ingénieur (génie civil et structure)",null,null,null,null,0,{"$f":"(F132+G132)","v":0},{"$f":"ROUND(F132+(G132/2),2)","v":0}]
[null,"Ingénieur (génie mécanique et électrique) ",null,null,null,null,{"$f":"(F133*TPS)+(F133*TVQ)","v":0},0,0]
[null,"Arpenteur",null,null,null,null,0,0,0]
[null,"Comptable",null,null,null,null,0,0,0]
[null,"Notaire, Avocat",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F138*TPS)+(F138*TVQ)","v":0},0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Honoraires professionnels",null,null,null,null,{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},{"$f":"SUM(H131:H139)","v":0},{"$f":"SUM(I131:I139)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I124-I140","v":119774.49926400001}]
[]
["Chargé de Projet"]
[null,null,"Enveloppe Chargé de Projet"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B22","v":41620.963350000005}]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I145:I147)","v":41620.963350000005}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I156","v":0}]
[]
[null,null,"Enveloppe reconnue Chargé de Projet (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I148,I150)","v":0}]
[]
[]
[null,"Chargé de Projet",null,null,null,null,{"$f":"(F155*TPS)+(F155*TVQ)","v":0},{"$f":"(F155+G155)","v":0},{"$f":"ROUND(F155+(G155/2),2)","v":0}]
["Total – Chargé de Projet",null,null,null,null,null,{"$f":"SUM(G155)","v":0},{"$f":"SUM(H155)","v":0},{"$f":"SUM(I155)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I148-I156","v":41620.963350000005}]
[]
["Terrain"]
[null,null,"Enveloppe Terrain"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I160:I163)","v":0}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I162+I163","v":0}]
[]
[null,null,"Enveloppe reconnue Terrain (minimum entre A et B)",null,null,null,null,null,{"$f":"I164+I165","v":0}]
[]
[]
[null,"Coût d'achat du terrain 2",null,null,null,null,{"$f":"(F171*TPS)+(F171*TVQ)","v":0},{"$f":"(F171+G171)","v":0},{"$f":"ROUND(F171+(G171/2),2)","v":0}]
[null,"Études de sol",null,null,null,null,0,{"$f":"(F172+G172)","v":0},{"$f":"ROUND(F172+(G172/2),2)","v":0}]
[null,"Certificat de localisation",null,null,null,null,0,0,0]
[null,"Nivellement du terrain",null,null,null,null,0,0,0]
[null,"Frais de déboisement",null,null,null,null,0,0,0]
[null,"Frais de démolition sur le terrain",null,null,null,null,0,0,0]
[null,"Infrastructures 3",null,null,null,null,0,0,0]
[null,"Décontamination du terrain",null,null,null,0,0,0,0]
[null,"Autres (préciser) : ","Bolard, 2 ponceaux, végétalisation, clôture",null,null,null,0,0,0]
[null,"Réserves pour imprévus","Contingence 10%",null,null,null,0,0,0]
["Total – Terrain",null,null,null,null,{"$f":"SUM(F171:F180)","v":0},{"$f":"SUM(G171:G180)","v":0},{"$f":"SUM(H171:H180)","v":0},{"$f":"SUM(I171:I180)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I164-I181","v":0}]
[]
[]
["TOTAL DES COÛTS RÉELS DU PROJET",null,null,null,null,{"$f":"F43+F67+F87+F116+F140+F156+F181","v":0},{"$f":"G43+G67+G87+G116+G140+G156+G181","v":29573.378750000003},{"$f":"H43+H67+H87+H116+H140+H156+H181","v":227058.37875},{"$f":"I43+I67+I87+I116+I140+I156+I181","v":212271.7}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
["2 Comprend aussi le pourcentage du terrain si on achète un bâtiment."]
["3 Infrastructures (branchement aux services publics, fosse septique, puits artésien)."]
[]
[]
[]
[null,null,null,"Financement du Projet"]
["Nom du CPE:"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
[]
["Total de toutes les enveloppes de financement du MFA",null,null,null,null,null,null,null,{"$f":"I148+I124+I102+I77+I52+I25","v":2086441.352614}]
[]
[]
["Liquidités qui viennent diminuer les enveloppes de financement du MFA"]
[]
[null,"Indemnités de l'assurance ou d'un prog gouv.",null,null,null,null,{"$f":"(F208*TPS)+(F208*TVQ)","v":0},{"$f":"(F208+G208)","v":0},{"$f":"ROUND(F208+(G208/2),2)","v":0}]
[null,"Produit de vente d'actifs immobiliers",null,null,null,null,0,0,0]
[null,"Liquidités investies dans le projet par le CPE",null,null,null,null,0,0,0]
[null,"Subventions d'autres organismes",null,null,null,null,{"$f":"(F211*TPS)+(F211*TVQ)","v":0},0,0]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
["Total des Liquidités (Mise de fonds)",null,null,null,null,{"$f":"SUM(F208:F210)","v":0},{"$f":"SUM(G208:G210)","v":0},{"$f":"SUM(H208:H210)","v":0},{"$f":"SUM(I208:I210)","v":0}]
[]
[]
["Liquidités qui s'ajoutent aux enveloppes de financement du MFA"]
[]
[null,"Subventions de d'autres organismes",null,null,null,null,{"$f":"(F219*TPS)+(F219*TVQ)","v":0},{"$f":"(F219+G219)","v":0},{"$f":"ROUND(F219+(G219/2),2)","v":0}]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
[null,"Liquidité investies par le CPE (Liquidité Plus)",null,null,null,null,null,null,0]
["Total des Liquidités Bonifiant Le Projet",null,null,null,null,{"$f":"SUM(F219:F222)","v":0},{"$f":"SUM(G219:G222)","v":0},{"$f":"SUM(H219:H222)","v":0},{"$f":"SUM(I219:I222)","v":0}]
[]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE PAR LE PROGRAMME DE FINANCEMENT DES INFRASTRUCTURES",null,null,null,null,null,null,null,{"$f":"I203-I214","v":2086441.352614}]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE POUR LE PROJET :",null,null,null,null,null,null,null,{"$f":"I214+I223+I228","v":2086441.352614}]
[]
[]
[null,null,null,"Équilibre du budget:",null,null,"(Doit être  à 0$ ou  +)",null,{"$f":"I232-I185","v":1874169.652614}]

{"sheet":"Budget final","index":9,"n_rows":235,"n_cols":9,"rows_kept":235,"cut":false,"hidden":true,"merged":[[91,3,91,6],[192,3,192,6],[223,6,223,7],[1,5,1,6],[1,7,1,8],[2,7,2,8],[4,2,4,7],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,null,null,null,"Date de préparation:"]
[null,null,null,null,null,null,"Préparé par:"]
[]
[null,null,"BUDGET D'IMPLANTATION PFI"]
[]
["Type de projet:",null,null,null,null,null,null,"R/B:"]
["Nom du CPE :"]
["No de division :",null,null,null,null,null,"Nombre de places 0-17 mois :",null,{"$f":"'Calcul env. achat-construction'!B6","v":10}]
["No d'installation :",null,null,null,null,null,"Nombre de places 18-59 mois :",null,{"$f":"'Calcul env. achat-construction'!B5-'Calcul env. achat-construction'!B6","v":42}]
["Dimension installation (en m2):",null,null,null,null,null,"Date d'ouverture :"]
["Dimension salle multi (en m2):"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
["Achat - construction"]
[null,null,"Enveloppe Achat-Construction",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B16","v":1658627}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I21:I24)","v":1658627}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I43","v":0}]
[]
[null,null,"Enveloppe reconnue Achat-Construction (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I25,I27)","v":0}]
[]
[]
[null,"Coût de construction ou d'agrandissement",null,null,null,null,{"$f":"(F32*TPS)+(F32*TVQ)","v":0},{"$f":"(F32+G32)","v":0},{"$f":"ROUND(F32+(G32/2),2)","v":0}]
[null,"Branchement temporaire aux services publics",null,null,null,null,0,{"$f":"(F33+G33)","v":0},{"$f":"ROUND(F33+(G33/2),2)","v":0}]
[null,"Aménagement de voies de circulation temporaire",null,null,null,null,0,0,0]
[null,"Permis de construction",null,null,null,null,0,0,0]
[null,"Assurances exigées pour les travaux",null,null,null,null,0,0,0]
[null,"Achat d'un bâtiment",null,null,null,null,0,0,0]
[null,"Amélioration locative",null,null,null,null,0,0,0]
[null,"Rénovation ou réaménagement",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F41*TPS)+(F41*TVQ)","v":0},0,0]
[null,"Autres (préciser) :","Contingences ",null,null,null,0,0,0]
["Total – Achat - construction",null,null,null,null,null,{"$f":"SUM(G32:G42)","v":0},{"$f":"SUM(H32:H42)","v":0},{"$f":"SUM(I32:I42)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I25-I43","v":1658627}]
[]
[]
["Mobilier et Équipement"]
[null,null,"Enveloppe Mobilier et Équipement",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B24","v":112095}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle, si applicable"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I48:I51)","v":112095}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I67","v":104397.23999999999}]
[]
[null,null,"Enveloppe reconnue Mobilier et Équipement (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I52,I54)","v":104397.23999999999}]
[]
[]
[null,"Équipements meubles",null,null,null,{"$f":"Mobilier!D8","v":20475},{"$f":"(F59*TPS)+(F59*TVQ)","v":3066.1312500000004},{"$f":"(F59+G59)","v":23541.131249999999},{"$f":"ROUND(F59+(G59/2),2)","v":22008.07}]
[null,"Équipements de cuisine ou de buanderie",null,null,null,{"$f":"Mobilier!D19","v":30000},4492.5,{"$f":"(F60+G60)","v":34492.5},{"$f":"ROUND(F60+(G60/2),2)","v":32246.25}]
[null,"Matériel et mobilier de bureau",null,null,null,{"$f":"Mobilier!D22","v":1250},187.1875,1437.1875,1343.59]
[null,"Matériel informatique",null,null,null,{"$f":"Mobilier!D26","v":2500},374.375,2874.375,2687.19]
[null,"Matériel éducatif",null,null,null,{"$f":"Mobilier!D29","v":22100},3309.4749999999999,25409.474999999999,23754.74]
[null,"Jouets destinés aux aires de jeux",null,null,null,{"$f":"Mobilier!D32","v":20800},3114.8,23914.799999999999,22357.4]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Mobilier et équipement",null,null,null,null,null,{"$f":"SUM(G59:G66)","v":14544.46875},{"$f":"SUM(H59:H66)","v":111669.46875},{"$f":"SUM(I59:I66)","v":104397.23999999999}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I52-I67","v":7697.7600000000093}]
[]
[]
[]
["Jeux Extérieurs"]
[null,null,"Enveloppe Jeux Extérieurs",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B26","v":38220}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I73:I76)","v":38220}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I87","v":0}]
[]
[null,null,"Enveloppe reconnue Jeux extérieurs (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I77,I79)","v":0}]
[]
[]
[null,"Jeux extérieurs",null,null,null,null,{"$f":"(F84*TPS)+(F84*TVQ)","v":0},{"$f":"(F84+G84)","v":0},{"$f":"ROUND(F84+(G84/2),2)","v":0}]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F85*TPS)+(F85*TVQ)","v":0},{"$f":"(F85+G85)","v":0},{"$f":"ROUND(F85+(G85/2),2)","v":0}]
[null,"Réserves pour imprévus",null,null,null,null,{"$f":"(F86*TPS)+(F86*TVQ)","v":0},0,0]
["Total – Jeux extérieurs",null,null,null,null,null,{"$f":"SUM(G84:G86)","v":0},{"$f":"SUM(H84:H86)","v":0},{"$f":"SUM(I84:I86)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I77-I87","v":38220}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
[]
[null,null,null,"Budget d'implantantion (suite)"]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[]
["Aménagement Extérieur"]
[null,null,"Enveloppe Aménagement Extérieur",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B18","v":116103.89000000001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I98:I101)","v":116103.89000000001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I116","v":107874.46}]
[]
[null,null,"Enveloppe reconnue Aménagement extérieur (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I102,I104)","v":107874.46}]
[]
[]
[null,"Stationnement",null,null,null,{"$f":"Mobilier!I3","v":63700},{"$f":"(F109*TPS)+(F109*TVQ)","v":9539.0750000000007},{"$f":"(F109+G109)","v":73239.074999999997},{"$f":"ROUND(F109+(G109/2),2)","v":68469.539999999994}]
[null,"Aménagement paysager",null,null,null,{"$f":"Mobilier!I4","v":8060},1206.9850000000001,{"$f":"(F110+G110)","v":9266.9850000000006},{"$f":"ROUND(F110+(G110/2),2)","v":8663.49}]
[null,"Gazonnement",null,null,null,{"$f":"Mobilier!I5","v":13000},1946.75,14946.75,13973.38]
[null,"Clôture",null,null,null,{"$f":"Mobilier!I6","v":15600},2336.1000000000004,17936.099999999999,16768.05]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :"]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
["Total – Aménagement extérieur",null,null,null,null,null,{"$f":"SUM(G109:G115)","v":15028.910000000002},{"$f":"SUM(H109:H115)","v":115388.91},{"$f":"SUM(I109:I115)","v":107874.46}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I102-I116","v":8229.4300000000076}]
[]
[" Honoraires Professionnels"]
[null,null,"Enveloppe Honoraire Professionnels",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B20","v":119774.49926400001}]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I120:I123)","v":119774.49926400001}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I140","v":0}]
[]
[null,null,"Enveloppe reconnue Honoraires Professionnels (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I124,I126)","v":0}]
[]
[]
[null,"Architecte ",null,null,null,null,{"$f":"(F131*TPS)+(F131*TVQ)","v":0},{"$f":"(F131+G131)","v":0},{"$f":"ROUND(F131+(G131/2),2)","v":0}]
[null,"Ingénieur (génie civil et structure)",null,null,null,null,0,{"$f":"(F132+G132)","v":0},{"$f":"ROUND(F132+(G132/2),2)","v":0}]
[null,"Ingénieur (génie mécanique et électrique) ",null,null,null,null,{"$f":"(F133*TPS)+(F133*TVQ)","v":0},0,0]
[null,"Arpenteur",null,null,null,null,0,0,0]
[null,"Comptable",null,null,null,null,0,0,0]
[null,"Notaire, Avocat",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,0,0,0]
[null,"Autres (préciser) :",null,null,null,null,{"$f":"(F138*TPS)+(F138*TVQ)","v":0},0,0]
[null,"Réserves pour imprévus",null,null,null,null,0,0,0]
["Total – Honoraires professionnels",null,null,null,null,{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},{"$f":"SUM(H131:H139)","v":0},{"$f":"SUM(I131:I139)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I124-I140","v":119774.49926400001}]
[]
["Chargé de Projet"]
[null,null,"Enveloppe Chargé de Projet"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle",null,null,null,null,null,{"$f":"'Calcul env. achat-construction'!B22","v":41620.963350000005}]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I145:I147)","v":41620.963350000005}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I156","v":0}]
[]
[null,null,"Enveloppe reconnue Chargé de Projet (minimum entre A et B)",null,null,null,null,null,{"$f":"MIN(I148,I150)","v":0}]
[]
[]
[null,"Chargé de Projet",null,null,null,null,{"$f":"(F155*TPS)+(F155*TVQ)","v":0},{"$f":"(F155+G155)","v":0},{"$f":"ROUND(F155+(G155/2),2)","v":0}]
["Total – Chargé de Projet",null,null,null,null,null,{"$f":"SUM(G155)","v":0},{"$f":"SUM(H155)","v":0},{"$f":"SUM(I155)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I148-I156","v":41620.963350000005}]
[]
["Terrain"]
[null,null,"Enveloppe Terrain"]
[null,"Plus:","Enveloppe Spécifique Exceptionelle"]
[null,"+ ou -","Transfert d'enveloppe (provenant ou vers)"]
[null,"Moins:","Mise de fonds, si applicable ici"]
[null,null,"Totale de l'enveloppe maximum admissible (A)",null,null,null,null,null,{"$f":"SUM(I160:I163)","v":0}]
[]
[null,null,"Coûts de construction budgétés (B)",null,null,null,null,null,{"$f":"I162+I163","v":0}]
[]
[null,null,"Enveloppe reconnue Terrain (minimum entre A et B)",null,null,null,null,null,{"$f":"I164+I165","v":0}]
[]
[]
[null,"Coût d'achat du terrain 2",null,null,null,null,{"$f":"(F171*TPS)+(F171*TVQ)","v":0},{"$f":"(F171+G171)","v":0},{"$f":"ROUND(F171+(G171/2),2)","v":0}]
[null,"Études de sol",null,null,null,null,0,{"$f":"(F172+G172)","v":0},{"$f":"ROUND(F172+(G172/2),2)","v":0}]
[null,"Certificat de localisation",null,null,null,null,0,0,0]
[null,"Nivellement du terrain",null,null,null,null,0,0,0]
[null,"Frais de déboisement",null,null,null,null,0,0,0]
[null,"Frais de démolition sur le terrain",null,null,null,null,0,0,0]
[null,"Infrastructures 3",null,null,null,null,0,0,0]
[null,"Décontamination du terrain",null,null,null,0,0,0,0]
[null,"Autres (préciser) : ","Bolard, 2 ponceaux, végétalisation, clôture",null,null,null,0,0,0]
[null,"Réserves pour imprévus","Contingence 10%",null,null,null,0,0,0]
["Total – Terrain",null,null,null,null,{"$f":"SUM(F171:F180)","v":0},{"$f":"SUM(G171:G180)","v":0},{"$f":"SUM(H171:H180)","v":0},{"$f":"SUM(I171:I180)","v":0}]
[null,null,null,null,null,null,null,"Dépassement",{"$f":"I164-I181","v":0}]
[]
[]
["TOTAL DES COÛTS RÉELS DU PROJET",null,null,null,null,{"$f":"F43+F67+F87+F116+F140+F156+F181","v":0},{"$f":"G43+G67+G87+G116+G140+G156+G181","v":29573.378750000003},{"$f":"H43+H67+H87+H116+H140+H156+H181","v":227058.37875},{"$f":"I43+I67+I87+I116+I140+I156+I181","v":212271.7}]
[]
["1 Attention! Les taux de taxation peuvent varier au cours du projet."]
["2 Comprend aussi le pourcentage du terrain si on achète un bâtiment."]
["3 Infrastructures (branchement aux services publics, fosse septique, puits artésien)."]
[]
[]
[]
[null,null,null,"Financement du Projet"]
["Nom du CPE:"]
[]
[]
[null,null,null,null,null,"Coûts                      avant taxes","Taxes (100%) 1","Total                          + 100 % des taxes","Coûts                              + 50% des taxes"]
[]
[null,null,null,null,null,null,"TPS",0.05]
[null,null,null,null,null,null,"TVQ",9.9750000000000005E-2]
[]
[]
["Total de toutes les enveloppes de financement du MFA",null,null,null,null,null,null,null,{"$f":"I148+I124+I102+I77+I52+I25","v":2086441.352614}]
[]
[]
["Liquidités qui viennent diminuer les enveloppes de financement du MFA"]
[]
[null,"Indemnités de l'assurance ou d'un prog gouv.",null,null,null,null,{"$f":"(F208*TPS)+(F208*TVQ)","v":0},{"$f":"(F208+G208)","v":0},{"$f":"ROUND(F208+(G208/2),2)","v":0}]
[null,"Produit de vente d'actifs immobiliers",null,null,null,null,0,0,0]
[null,"Liquidités investies dans le projet par le CPE",null,null,null,null,0,0,0]
[null,"Subventions d'autres organismes",null,null,null,null,{"$f":"(F211*TPS)+(F211*TVQ)","v":0},0,0]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
["Total des Liquidités (Mise de fonds)",null,null,null,null,{"$f":"SUM(F208:F210)","v":0},{"$f":"SUM(G208:G210)","v":0},{"$f":"SUM(H208:H210)","v":0},{"$f":"SUM(I208:I210)","v":0}]
[]
[]
["Liquidités qui s'ajoutent aux enveloppes de financement du MFA"]
[]
[null,"Subventions de d'autres organismes",null,null,null,null,{"$f":"(F219*TPS)+(F219*TVQ)","v":0},{"$f":"(F219+G219)","v":0},{"$f":"ROUND(F219+(G219/2),2)","v":0}]
[null,"Dons",null,null,null,null,0,0,0]
[null,"Financement de partenaires",null,null,null,null,0,0,0]
[null,"Liquidité investies par le CPE (Liquidité Plus)",null,null,null,null,null,null,0]
["Total des Liquidités Bonifiant Le Projet",null,null,null,null,{"$f":"SUM(F219:F222)","v":0},{"$f":"SUM(G219:G222)","v":0},{"$f":"SUM(H219:H222)","v":0},{"$f":"SUM(I219:I222)","v":0}]
[]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE PAR LE PROGRAMME DE FINANCEMENT DES INFRASTRUCTURES",null,null,null,null,null,null,null,{"$f":"I203-I214","v":2086441.352614}]
[]
[]
[]
["TOTAL DU FINANCEMENT DISPONIBLE POUR LE PROJET :",null,null,null,null,null,null,null,{"$f":"I214+I223+I228","v":2086441.352614}]
[]
[]
[null,null,null,"Équilibre du budget:",null,null,"(Doit être  à 0$ ou  +)",null,{"$f":"I232-I185","v":1874169.652614}]

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