{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Смета","Схема распределения от периодов","Шаблон карточки проекта","Приложения","1. Теплоснабжение","2. Водоснабжение","3. Водоотведение","4. Электроснабжение","5. Газоснабжение","data"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":8,"comments":0,"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":"Смета","index":0,"n_rows":208,"n_cols":13,"rows_kept":208,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Шифр расценки","Наименование сооружения","Раздел","Ед. изм.","Объем работ","Стоимость ед.,\nруб.","Коэф-т пересчета","НДС, коэф","Интегральный коэффициент","Всего, млн руб.","Готовность, год","Срок реализации, лет"]
[null,"1. Теплоснабжение",null,1]
[1,"1","Работа №1",1.1000000000000001,"км",5,100000000,1.1000000000000001,1.2,{"$f":"H4*I4","v":1.32},{"$f":"IFERROR(F4*G4*J4,0)/1000000","v":660},2025,2]
[2,"3","Работа №2",1.2,"км",10,50000000,1.2,1,{"$f":"H5*I5","v":1.2},{"$f":"IFERROR(F5*G5*J5,0)/1000000","v":600},"2026","3"]
[3,"6","Работа №3",1.3,"МВт",100,1000000,1,1.2,1.2,120,"2030","5"]
[4,"9","Новая работа",1.2,"км",100,2500000,1.5,1,1.5,375,"2029","2"]
[5,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,0,0]
[7,null,null,null,null,null,null,null,null,0,0]
[8,null,null,null,null,null,null,null,null,0,0]
[9,null,null,null,null,null,null,null,null,0,0]
[10,null,null,null,null,null,null,null,null,0,0]
[11,null,null,null,null,null,null,null,null,0,0]
[12,null,null,null,null,null,null,null,null,0,0]
[13,null,null,null,null,null,null,null,null,0,0]
[14,null,null,null,null,null,null,null,null,0,0]
[15,null,null,null,null,null,null,null,null,0,0]
[16,null,null,null,null,null,null,null,null,0,0]
[17,null,null,null,null,null,null,null,null,0,0]
[18,null,null,null,null,null,null,null,null,0,0]
[19,null,null,null,null,null,null,null,null,0,0]
[20,null,null,null,null,null,null,null,null,0,0]
[21,null,null,null,null,null,null,null,null,0,0]
[22,null,null,null,null,null,null,null,null,0,0]
[23,null,null,null,null,null,null,null,null,0,0]
[24,null,null,null,null,null,null,null,null,0,0]
[25,null,null,null,null,null,null,null,null,0,0]
[26,null,null,null,null,null,null,null,null,0,0]
[27,null,null,null,null,null,null,null,null,0,0]
[28,null,null,null,null,null,null,null,null,0,0]
[29,null,null,null,null,null,null,null,null,0,0]
[30,null,null,null,null,null,null,null,null,0,0]
[31,null,null,null,null,null,null,null,null,0,0]
[32,null,null,null,null,null,null,null,null,0,0]
[33,null,null,null,null,null,null,null,null,0,0]
[34,null,null,null,null,null,null,null,null,0,0]
[35,null,null,null,null,null,null,null,null,0,0]
[36,null,null,null,null,null,null,null,null,0,0]
[37,null,null,null,null,null,null,null,null,0,0]
[38,null,null,null,null,null,null,null,null,0,0]
[39,null,null,null,null,null,null,null,null,0,0]
[40,null,null,null,null,null,null,null,null,0,0]
[null,"2. Водоснабжение",null,2]
[41,"12","Работа №4",2.1,"куб. м в сутки",1000,10000000,1.2,1,{"$f":"H45*I45","v":1.2},12000,"2024","1"]
[42,"15","Работа №5",2.2000000000000002,"км",10,100000000,1.1000000000000001,1.2,1.32,1320,"2027","4"]
[43,"67","Работа №6",2.2999999999999998,"км",5,200000000,1,1,1,1000,"2026","2"]
[44,"35","Работа №7",2.4,"куб. м в сутки",500,20000000,1.1499999999999999,1.2,1.38,13799.999999999998,"2025","2"]
[45,null,null,null,null,null,null,null,null,0,0]
[46,null,null,null,null,null,null,null,null,0,0]
[47,null,null,null,null,null,null,null,null,0,0]
[48,null,null,null,null,null,null,null,null,0,0]
[49,null,null,null,null,null,null,null,null,0,0]
[50,null,null,null,null,null,null,null,null,0,0]
[51,null,null,null,null,null,null,null,null,0,0]
[52,null,null,null,null,null,null,null,null,0,0]
[53,null,null,null,null,null,null,null,null,0,0]
[54,null,null,null,null,null,null,null,null,0,0]
[55,null,null,null,null,null,null,null,null,0,0]
[56,null,null,null,null,null,null,null,null,0,0]
[57,null,null,null,null,null,null,null,null,0,0]
[58,null,null,null,null,null,null,null,null,0,0]
[59,null,null,null,null,null,null,null,null,0,0]
[60,null,null,null,null,null,null,null,null,0,0]
[61,null,null,null,null,null,null,null,null,0,0]
[62,null,null,null,null,null,null,null,null,0,0]
[63,null,null,null,null,null,null,null,null,0,0]
[64,null,null,null,null,null,null,null,null,0,0]
[65,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(F69*G69*J69,0)/1000000","v":0}]
[66,null,null,null,null,null,null,null,null,0,0]
[67,null,null,null,null,null,null,null,null,0,0]
[68,null,null,null,null,null,null,null,null,0,0]
[69,null,null,null,null,null,null,null,null,0,0]
[70,null,null,null,null,null,null,null,null,0,0]
[71,null,null,null,null,null,null,null,null,0,0]
[72,null,null,null,null,null,null,null,null,0,0]
[73,null,null,null,null,null,null,null,null,0,0]
[74,null,null,null,null,null,null,null,null,0,0]
[75,null,null,null,null,null,null,null,null,0,0]
[76,null,null,null,null,null,null,null,null,0,0]
[77,null,null,null,null,null,null,null,null,0,0]
[78,null,null,null,null,null,null,null,null,0,0]
[79,null,null,null,null,null,null,null,null,0,0]
[80,null,null,null,null,null,null,null,null,0,0]
[null,"3. Водоотведение",null,3]
[81,"21","Работа №8",3.1,"км",100,10000000,1.4,1.2,{"$f":"H86*I86","v":1.68},{"$f":"IFERROR(F86*G86*J86,0)/1000000","v":1680},"2029","5"]
[82,"5","Работа №9",3.2,"км",20,20000000,1.2,1.2,1.44,{"$f":"IFERROR(F87*G87*J87,0)/1000000","v":576},"2028","3"]
[83,"89","Работа №10",3.3,"куб. м в сутки",1000,30000000,1,1.2,1.2,36000,"2031","4"]
[84,"73","Работа №11",3.4,"куб. м в сутки",2000,40000000,0.87,1.2,1.044,83520,"2023","2"]
[85,null,null,null,null,null,null,null,null,0,0]
[86,null,null,null,null,null,null,null,null,0,0]
[87,null,null,null,null,null,null,null,null,0,0]
[88,null,null,null,null,null,null,null,null,0,0]
[89,null,null,null,null,null,null,null,null,0,0]
[90,null,null,null,null,null,null,null,null,0,0]
[91,null,null,null,null,null,null,null,null,0,0]
[92,null,null,null,null,null,null,null,null,0,0]
[93,null,null,null,null,null,null,null,null,0,0]
[94,null,null,null,null,null,null,null,null,0,0]
[95,null,null,null,null,null,null,null,null,0,0]
[96,null,null,null,null,null,null,null,null,0,0]
[97,null,null,null,null,null,null,null,null,0,0]
[98,null,null,null,null,null,null,null,null,0,0]
[99,null,null,null,null,null,null,null,null,0,0]
[100,null,null,null,null,null,null,null,null,0,0]
[101,null,null,null,null,null,null,null,null,0,0]
[102,null,null,null,null,null,null,null,null,0,0]
[103,null,null,null,null,null,null,null,null,0,0]
[104,null,null,null,null,null,null,null,null,0,0]
[105,null,null,null,null,null,null,null,null,0,0]
[106,null,null,null,null,null,null,null,null,0,0]
[107,null,null,null,null,null,null,null,null,0,0]
[108,null,null,null,null,null,null,null,null,0,0]
[109,null,null,null,null,null,null,null,null,0,0]
[110,null,null,null,null,null,null,null,null,0,0]
[111,null,null,null,null,null,null,null,null,0,0]
[112,null,null,null,null,null,null,null,null,0,0]
[113,null,null,null,null,null,null,null,null,0,0]
[114,null,null,null,null,null,null,null,null,0,0]
[115,null,null,null,null,null,null,null,null,0,0]
[116,null,null,null,null,null,null,null,null,0,0]
[117,null,null,null,null,null,null,null,null,0,0]
[118,null,null,null,null,null,null,null,null,0,0]
[119,null,null,null,null,null,null,null,null,0,0]
[120,null,null,null,null,null,null,null,null,0,0]
[null,"4. Электроснабжение",null,4]
[121,"14","Работа №12",4.0999999999999996,"км",50,100000000,0.84,1,{"$f":"H127*I127","v":0.84},4200,"2026","2"]
[122,"82","Работа №13",4.2,"км",100,110000000,0.97,1,0.97,10670,"2027","3"]
[123,"83","Работа №14",4.3,"МВт",1000,120000000,1.1499999999999999,1,1.1499999999999999,138000,"2026","1"]
[124,null,null,null,null,null,null,null,null,0,0]
[125,null,null,null,null,null,null,null,null,0,0]
[126,null,null,null,null,null,null,null,null,0,0]
[127,null,null,null,null,null,null,null,null,0,0]
[128,null,null,null,null,null,null,null,null,0,0]
[129,null,null,null,null,null,null,null,null,0,0]
[130,null,null,null,null,null,null,null,null,0,0]
[131,null,null,null,null,null,null,null,null,0,0]
[132,null,null,null,null,null,null,null,null,0,0]
[133,null,null,null,null,null,null,null,null,0,0]
[134,null,null,null,null,null,null,null,null,0,0]
[135,null,null,null,null,null,null,null,null,0,0]
[136,null,null,null,null,null,null,null,null,0,0]
[137,null,null,null,null,null,null,null,null,0,0]
[138,null,null,null,null,null,null,null,null,0,0]
[139,null,null,null,null,null,null,null,null,0,0]
[140,null,null,null,null,null,null,null,null,0,0]
[141,null,null,null,null,null,null,null,null,0,0]
[142,null,null,null,null,null,null,null,null,0,0]
[143,null,null,null,null,null,null,null,null,0,0]
[144,null,null,null,null,null,null,null,null,0,0]
[145,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(F151*G151*J151,0)/1000000","v":0}]
[146,null,null,null,null,null,null,null,null,0,0]
[147,null,null,null,null,null,null,null,null,0,0]
[148,null,null,null,null,null,null,null,null,0,0]
[149,null,null,null,null,null,null,null,null,0,0]
[150,null,null,null,null,null,null,null,null,0,0]
[151,null,null,null,null,null,null,null,null,0,0]
[152,null,null,null,null,null,null,null,null,0,0]
[153,null,null,null,null,null,null,null,null,0,0]
[154,null,null,null,null,null,null,null,null,0,0]
[155,null,null,null,null,null,null,null,null,0,0]
[156,null,null,null,null,null,null,null,null,0,0]
[157,null,null,null,null,null,null,null,null,0,0]
[158,null,null,null,null,null,null,null,null,0,0]
[159,null,null,null,null,null,null,null,null,0,0]
[160,null,null,null,null,null,null,null,null,0,0]
[null,"5. Газоснабжение",null,5]
[161,"33","Работа №15",5.0999999999999996,"куб. м в час",50,50000000,0.84,1,{"$f":"H168*I168","v":0.84},2100,"2026","3"]
[162,"8","Работа №16",5.2,"км",100,100000000,0.95,1.2,1.1399999999999999,11399.999999999998,"2027","4"]
[163,null,null,null,null,null,null,null,null,0,0]
[164,null,null,null,null,null,null,null,null,0,0]
[165,null,null,null,null,null,null,null,null,0,0]
[166,null,null,null,null,null,null,null,null,0,0]
[167,null,null,null,null,null,null,null,null,0,0]
[168,null,null,null,null,null,null,null,null,0,0]
[169,null,null,null,null,null,null,null,null,0,0]
[170,null,null,null,null,null,null,null,null,0,0]
[171,null,null,null,null,null,null,null,null,0,0]
[172,null,null,null,null,null,null,null,null,0,0]
[173,null,null,null,null,null,null,null,null,0,0]
[174,null,null,null,null,null,null,null,null,0,0]
[175,null,null,null,null,null,null,null,null,0,0]
[176,null,null,null,null,null,null,null,null,0,0]
[177,null,null,null,null,null,null,null,null,0,0]
[178,null,null,null,null,null,null,null,null,0,0]
[179,null,null,null,null,null,null,null,null,0,0]
[180,null,null,null,null,null,null,null,null,0,0]
[181,null,null,null,null,null,null,null,null,0,0]
[182,null,null,null,null,null,null,null,null,0,0]
[183,null,null,null,null,null,null,null,null,0,0]
[184,null,null,null,null,null,null,null,null,0,0]
[185,null,null,null,null,null,null,null,null,0,0]
[186,null,null,null,null,null,null,null,null,0,0]
[187,null,null,null,null,null,null,null,null,0,0]
[188,null,null,null,null,null,null,null,null,0,0]
[189,null,null,null,null,null,null,null,null,0,0]
[190,null,null,null,null,null,null,null,null,0,0]
[191,null,null,null,null,null,null,null,null,0,0]
[192,null,null,null,null,null,null,null,null,0,0]
[193,null,null,null,null,null,null,null,null,0,0]
[194,null,null,null,null,null,null,null,null,0,0]
[195,null,null,null,null,null,null,null,null,0,0]
[196,null,null,null,null,null,null,null,null,0,0]
[197,null,null,null,null,null,null,null,null,0,0]
[198,null,null,null,null,null,null,null,null,0,0]
[199,null,null,null,null,null,null,null,null,0,0]
[200,null,null,null,null,null,null,null,null,0,0]
[null,"Затраты на подключение к инженерным сетям"]

{"sheet":"Схема распределения от периодов","index":1,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[1,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,{"$f":"IF(B2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(C2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(D2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(E2=$B$17,$B$19*data!$F$3,\"-\")","v":660},{"$f":"IF(F2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(G2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(H2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(I2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(J2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(K2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(L2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(M2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(N2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(O2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(P2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(Q2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(R2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(S2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"},{"$f":"IF(T2=$B$17,$B$19*data!$F$3,\"-\")","v":"-"}]
[]
[2,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,null,{"$f":"$B$17-$B$18+1","v":2023}]
[null,{"$f":"IF(B5=$V$5,$B$19*data!$F$4,IF(B5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(C5=$V$5,$B$19*data!$F$4,IF(C5=$B$17,$B$19*data!$G$4,\"-\"))","v":330},{"$f":"IF(D5=$V$5,$B$19*data!$F$4,IF(D5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(E5=$V$5,$B$19*data!$F$4,IF(E5=$B$17,$B$19*data!$G$4,\"-\"))","v":330},{"$f":"IF(F5=$V$5,$B$19*data!$F$4,IF(F5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(G5=$V$5,$B$19*data!$F$4,IF(G5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(H5=$V$5,$B$19*data!$F$4,IF(H5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(I5=$V$5,$B$19*data!$F$4,IF(I5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(J5=$V$5,$B$19*data!$F$4,IF(J5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(K5=$V$5,$B$19*data!$F$4,IF(K5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(L5=$V$5,$B$19*data!$F$4,IF(L5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(M5=$V$5,$B$19*data!$F$4,IF(M5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(N5=$V$5,$B$19*data!$F$4,IF(N5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(O5=$V$5,$B$19*data!$F$4,IF(O5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(P5=$V$5,$B$19*data!$F$4,IF(P5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(Q5=$V$5,$B$19*data!$F$4,IF(Q5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(R5=$V$5,$B$19*data!$F$4,IF(R5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(S5=$V$5,$B$19*data!$F$4,IF(S5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},{"$f":"IF(T5=$V$5,$B$19*data!$F$4,IF(T5=$B$17,$B$19*data!$G$4,\"-\"))","v":"-"},null,{"$f":"V5+1","v":2024}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V6+1","v":2025}]
[3,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,null,2026]
[null,{"$f":"IF(B8=$V$6,$B$19*data!$G$5,IF(B8=$V$5,$B$19*data!$F$5,IF(B8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(C8=$V$6,$B$19*data!$G$5,IF(C8=$V$5,$B$19*data!$F$5,IF(C8=$B$17,$B$19*data!$H$5,\"-\")))","v":198},{"$f":"IF(D8=$V$6,$B$19*data!$G$5,IF(D8=$V$5,$B$19*data!$F$5,IF(D8=$B$17,$B$19*data!$H$5,\"-\")))","v":198},{"$f":"IF(E8=$V$6,$B$19*data!$G$5,IF(E8=$V$5,$B$19*data!$F$5,IF(E8=$B$17,$B$19*data!$H$5,\"-\")))","v":264},{"$f":"IF(F8=$V$6,$B$19*data!$G$5,IF(F8=$V$5,$B$19*data!$F$5,IF(F8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(G8=$V$6,$B$19*data!$G$5,IF(G8=$V$5,$B$19*data!$F$5,IF(G8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(H8=$V$6,$B$19*data!$G$5,IF(H8=$V$5,$B$19*data!$F$5,IF(H8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(I8=$V$6,$B$19*data!$G$5,IF(I8=$V$5,$B$19*data!$F$5,IF(I8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(J8=$V$6,$B$19*data!$G$5,IF(J8=$V$5,$B$19*data!$F$5,IF(J8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(K8=$V$6,$B$19*data!$G$5,IF(K8=$V$5,$B$19*data!$F$5,IF(K8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(L8=$V$6,$B$19*data!$G$5,IF(L8=$V$5,$B$19*data!$F$5,IF(L8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(M8=$V$6,$B$19*data!$G$5,IF(M8=$V$5,$B$19*data!$F$5,IF(M8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(N8=$V$6,$B$19*data!$G$5,IF(N8=$V$5,$B$19*data!$F$5,IF(N8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(O8=$V$6,$B$19*data!$G$5,IF(O8=$V$5,$B$19*data!$F$5,IF(O8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(P8=$V$6,$B$19*data!$G$5,IF(P8=$V$5,$B$19*data!$F$5,IF(P8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(Q8=$V$6,$B$19*data!$G$5,IF(Q8=$V$5,$B$19*data!$F$5,IF(Q8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(R8=$V$6,$B$19*data!$G$5,IF(R8=$V$5,$B$19*data!$F$5,IF(R8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(S8=$V$6,$B$19*data!$G$5,IF(S8=$V$5,$B$19*data!$F$5,IF(S8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"},{"$f":"IF(T8=$V$6,$B$19*data!$G$5,IF(T8=$V$5,$B$19*data!$F$5,IF(T8=$B$17,$B$19*data!$H$5,\"-\")))","v":"-"}]
[]
[4,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,{"$f":"IF(B8=$V$7,$B$19*data!$H$6,IF(B8=$V$6,$B$19*data!$G$6,IF(B8=$V$5,$B$19*data!$F$6,IF(B8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(C8=$V$7,$B$19*data!$H$6,IF(C8=$V$6,$B$19*data!$G$6,IF(C8=$V$5,$B$19*data!$F$6,IF(C8=$B$17,$B$19*data!$I$6,\"-\"))))","v":132},{"$f":"IF(D8=$V$7,$B$19*data!$H$6,IF(D8=$V$6,$B$19*data!$G$6,IF(D8=$V$5,$B$19*data!$F$6,IF(D8=$B$17,$B$19*data!$I$6,\"-\"))))","v":132},{"$f":"IF(E8=$V$7,$B$19*data!$H$6,IF(E8=$V$6,$B$19*data!$G$6,IF(E8=$V$5,$B$19*data!$F$6,IF(E8=$B$17,$B$19*data!$I$6,\"-\"))))","v":198},{"$f":"IF(F8=$V$7,$B$19*data!$H$6,IF(F8=$V$6,$B$19*data!$G$6,IF(F8=$V$5,$B$19*data!$F$6,IF(F8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(G8=$V$7,$B$19*data!$H$6,IF(G8=$V$6,$B$19*data!$G$6,IF(G8=$V$5,$B$19*data!$F$6,IF(G8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(H8=$V$7,$B$19*data!$H$6,IF(H8=$V$6,$B$19*data!$G$6,IF(H8=$V$5,$B$19*data!$F$6,IF(H8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(I8=$V$7,$B$19*data!$H$6,IF(I8=$V$6,$B$19*data!$G$6,IF(I8=$V$5,$B$19*data!$F$6,IF(I8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(J8=$V$7,$B$19*data!$H$6,IF(J8=$V$6,$B$19*data!$G$6,IF(J8=$V$5,$B$19*data!$F$6,IF(J8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(K8=$V$7,$B$19*data!$H$6,IF(K8=$V$6,$B$19*data!$G$6,IF(K8=$V$5,$B$19*data!$F$6,IF(K8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(L8=$V$7,$B$19*data!$H$6,IF(L8=$V$6,$B$19*data!$G$6,IF(L8=$V$5,$B$19*data!$F$6,IF(L8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(M8=$V$7,$B$19*data!$H$6,IF(M8=$V$6,$B$19*data!$G$6,IF(M8=$V$5,$B$19*data!$F$6,IF(M8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(N8=$V$7,$B$19*data!$H$6,IF(N8=$V$6,$B$19*data!$G$6,IF(N8=$V$5,$B$19*data!$F$6,IF(N8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(O8=$V$7,$B$19*data!$H$6,IF(O8=$V$6,$B$19*data!$G$6,IF(O8=$V$5,$B$19*data!$F$6,IF(O8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(P8=$V$7,$B$19*data!$H$6,IF(P8=$V$6,$B$19*data!$G$6,IF(P8=$V$5,$B$19*data!$F$6,IF(P8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(Q8=$V$7,$B$19*data!$H$6,IF(Q8=$V$6,$B$19*data!$G$6,IF(Q8=$V$5,$B$19*data!$F$6,IF(Q8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(R8=$V$7,$B$19*data!$H$6,IF(R8=$V$6,$B$19*data!$G$6,IF(R8=$V$5,$B$19*data!$F$6,IF(R8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(S8=$V$7,$B$19*data!$H$6,IF(S8=$V$6,$B$19*data!$G$6,IF(S8=$V$5,$B$19*data!$F$6,IF(S8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"},{"$f":"IF(T8=$V$7,$B$19*data!$H$6,IF(T8=$V$6,$B$19*data!$G$6,IF(T8=$V$5,$B$19*data!$F$6,IF(T8=$B$17,$B$19*data!$I$6,\"-\"))))","v":"-"}]
[]
[5,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,{"$f":"IF(B8=$V$8,$B$19*data!$I$7,IF(B8=$V$7,$B$19*data!$H$7,IF(B8=$V$6,$B$19*data!$G$7,IF(B8=$V$5,$B$19*data!$F$7,IF(B8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(C8=$V$8,$B$19*data!$I$7,IF(C8=$V$7,$B$19*data!$H$7,IF(C8=$V$6,$B$19*data!$G$7,IF(C8=$V$5,$B$19*data!$F$7,IF(C8=$B$17,$B$19*data!$J$7,\"-\")))))","v":132},{"$f":"IF(D8=$V$8,$B$19*data!$I$7,IF(D8=$V$7,$B$19*data!$H$7,IF(D8=$V$6,$B$19*data!$G$7,IF(D8=$V$5,$B$19*data!$F$7,IF(D8=$B$17,$B$19*data!$J$7,\"-\")))))","v":132},{"$f":"IF(E8=$V$8,$B$19*data!$I$7,IF(E8=$V$7,$B$19*data!$H$7,IF(E8=$V$6,$B$19*data!$G$7,IF(E8=$V$5,$B$19*data!$F$7,IF(E8=$B$17,$B$19*data!$J$7,\"-\")))))","v":132},{"$f":"IF(F8=$V$8,$B$19*data!$I$7,IF(F8=$V$7,$B$19*data!$H$7,IF(F8=$V$6,$B$19*data!$G$7,IF(F8=$V$5,$B$19*data!$F$7,IF(F8=$B$17,$B$19*data!$J$7,\"-\")))))","v":132},{"$f":"IF(G8=$V$8,$B$19*data!$I$7,IF(G8=$V$7,$B$19*data!$H$7,IF(G8=$V$6,$B$19*data!$G$7,IF(G8=$V$5,$B$19*data!$F$7,IF(G8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(H8=$V$8,$B$19*data!$I$7,IF(H8=$V$7,$B$19*data!$H$7,IF(H8=$V$6,$B$19*data!$G$7,IF(H8=$V$5,$B$19*data!$F$7,IF(H8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(I8=$V$8,$B$19*data!$I$7,IF(I8=$V$7,$B$19*data!$H$7,IF(I8=$V$6,$B$19*data!$G$7,IF(I8=$V$5,$B$19*data!$F$7,IF(I8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(J8=$V$8,$B$19*data!$I$7,IF(J8=$V$7,$B$19*data!$H$7,IF(J8=$V$6,$B$19*data!$G$7,IF(J8=$V$5,$B$19*data!$F$7,IF(J8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(K8=$V$8,$B$19*data!$I$7,IF(K8=$V$7,$B$19*data!$H$7,IF(K8=$V$6,$B$19*data!$G$7,IF(K8=$V$5,$B$19*data!$F$7,IF(K8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(L8=$V$8,$B$19*data!$I$7,IF(L8=$V$7,$B$19*data!$H$7,IF(L8=$V$6,$B$19*data!$G$7,IF(L8=$V$5,$B$19*data!$F$7,IF(L8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(M8=$V$8,$B$19*data!$I$7,IF(M8=$V$7,$B$19*data!$H$7,IF(M8=$V$6,$B$19*data!$G$7,IF(M8=$V$5,$B$19*data!$F$7,IF(M8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(N8=$V$8,$B$19*data!$I$7,IF(N8=$V$7,$B$19*data!$H$7,IF(N8=$V$6,$B$19*data!$G$7,IF(N8=$V$5,$B$19*data!$F$7,IF(N8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(O8=$V$8,$B$19*data!$I$7,IF(O8=$V$7,$B$19*data!$H$7,IF(O8=$V$6,$B$19*data!$G$7,IF(O8=$V$5,$B$19*data!$F$7,IF(O8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(P8=$V$8,$B$19*data!$I$7,IF(P8=$V$7,$B$19*data!$H$7,IF(P8=$V$6,$B$19*data!$G$7,IF(P8=$V$5,$B$19*data!$F$7,IF(P8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(Q8=$V$8,$B$19*data!$I$7,IF(Q8=$V$7,$B$19*data!$H$7,IF(Q8=$V$6,$B$19*data!$G$7,IF(Q8=$V$5,$B$19*data!$F$7,IF(Q8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(R8=$V$8,$B$19*data!$I$7,IF(R8=$V$7,$B$19*data!$H$7,IF(R8=$V$6,$B$19*data!$G$7,IF(R8=$V$5,$B$19*data!$F$7,IF(R8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(S8=$V$8,$B$19*data!$I$7,IF(S8=$V$7,$B$19*data!$H$7,IF(S8=$V$6,$B$19*data!$G$7,IF(S8=$V$5,$B$19*data!$F$7,IF(S8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"},{"$f":"IF(T8=$V$8,$B$19*data!$I$7,IF(T8=$V$7,$B$19*data!$H$7,IF(T8=$V$6,$B$19*data!$G$7,IF(T8=$V$5,$B$19*data!$F$7,IF(T8=$B$17,$B$19*data!$J$7,\"-\")))))","v":"-"}]
[]
["год",2025,"Лист \"Смета\" графа \"L\""]
["срок",3,"Лист \"Смета\" графа \"M\""]
["стоимость",660,"Лист \"Смета\" графа \"K\""]

{"sheet":"Шаблон карточки проекта","index":2,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,3],[3,4,3,14],[4,4,4,14],[5,4,5,14]]}
[null,"Шаблон карточки проекта"]
[]
[null,null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\" \",A3)","v":"1.2.2 "},"Наименование проекта"]
["1",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A4)","v":"1.2.2.1"},"Ссылка на соответствующие подразделы обосновывающих материалов"]
["2",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A5)","v":"1.2.2.2"},"Краткое описание проекта"]
["3",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A6)","v":"1.2.2.3"},"Цель проекта"]
["4",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A7)","v":"1.2.2.4"},"Технические характеристики проекта, в том числе:"]
[null,null,null,"ввод мощностей, куб. м в сутки"]
[null,null,null,"строительство сетей, км"]
["5",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A10)","v":"1.2.2.5"},"Необходимые капитальные затраты, млн руб."]
["6",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A11)","v":"1.2.2.6"},"Срок реализации проекта"]
["7",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A12)","v":"1.2.2.7"},"Источники инвестиций, в том числе:"]
["8",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A13)","v":"1.2.2.8"},"Бюджетные источники, в том числе:"]
[null,null,null,"Федеральный бюджет"]
[null,null,null,"Региональный бюджет"]
[null,null,null,"Местный бюджет"]
["9",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A17)","v":"1.2.2.9"},"Внебюджетные источники"]
[null,null,null,"Источники возврата внебюджетных инвестиций, в том числе:"]
[null,null,null,"Инвестиционная составляющая в тарифе"]
[null,null,null,"Плата за подключение к системе ресурсоснабжения"]
["10",null,{"$f":"CONCATENATE($C$25,\".\",$C$26,\".\",$C$27,\".\",A21)","v":"1.2.2.10"},"Срок окупаемости внебюджетных инвестиций, лет"]
[]
[]
[null,"Нумерация"]
[null,"Приложение",1]
[null,"Раздел",2]
[null,"Проект",2]

{"sheet":"Приложения","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"№ приложения","Наименование","Начало периода, год"]
[null,"1","ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ТЕПЛОСНАБЖЕНИИ",2022]
[null,"2","ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ВОДОСНАБЖЕНИИ",2022]
[null,"3","ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ВОДООТВЕДЕНИИ",2022]
[null,"4","ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ЭЛЕКТРОСНАБЖЕНИИ",2022]
[null,"5","ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ГАЗОСНАБЖЕНИИ",2022]

{"sheet":"1. Теплоснабжение","index":4,"n_rows":96,"n_cols":15,"rows_kept":96,"cut":false,"hidden":false,"merged":[[16,14,24,14],[84,14,93,14],[45,14,63,14],[2,1,4,1],[2,2,4,2],[2,3,2,13],[3,3,4,3]]}
[null,{"$f":"CONCATENATE(\"ПРИЛОЖЕНИЕ\",\" \",Приложения!B3,\". \",Приложения!C3)","v":"ПРИЛОЖЕНИЕ 1. ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ТЕПЛОСНАБЖЕНИИ"}]
[]
[null,"№ пп","Инвестиционные проекты","Финансовые затраты на реализацию (млн руб.)"]
[null,null,null,"Всего",{"$f":"Приложения!D3","v":2022},{"$f":"E4+1","v":2023},{"$f":"F4+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,null,null,null,"год","год","год","год","год","год","год","год","год","год"]
[null,1.1000000000000001,"Реконструкция объектов и сетей теплоснабжения"]
[null,"1.1.1","Наименование проекта",{"$f":"Смета!C4","v":"Работа №1"},null,null,null,null,null,null,null,null,null,null,"\"Наименование сооружения\" из листа \"Смета\""]
[null,"1.1.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"1.1.1.2","Краткое описание проекта"]
[null,"1.1.1.3","Цель проекта"]
[null,"1.1.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"1.1.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K4","v":660},{"$f":"E16","v":"-"},{"$f":"F16","v":"-"},330,330,"-","-","-","-","-","-","\"Всего, руб.\" из листа \"Смета\", сформатированием без десятичных"]
[null,"1.1.1.6","Срок реализации проекта",{"$f":"Смета!M4","v":2},null,null,null,null,null,null,null,null,null,null,"\"Срок реализации, лет\" из листа \"Смета\""]
[null,"1.1.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E16:N16)=D14,D14,\"Ошибка!\")","v":660},"-","-",330,330,"-","-","-","-","-","-","Разбивка общей суммы согласно алгоритму из листа \"Схема распределения от периодов\""]
[null,"1.1.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},0,0,0,0,0,0,0,0,0,"на данном этапе ячейки, выделенные желтым цветом, не требуют автоматизации"]
[null,null,"Федеральный бюджет",{"$f":"SUM(E18:N18)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E19:N19)","v":0}]
[null,null,"Местный бюджет",0]
[null,"1.1.1.9","Внебюджетные источники",{"$f":"SUM(E21:N21)","v":660},{"$f":"E22","v":0},{"$f":"F22","v":0},330,330,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D23:D24)","v":660},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},330,330,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E23:N23)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E24:N24)","v":660},null,null,330,330]
[null,"1.1.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,1.2,"Строительство объектов и сетей теплоснабжения"]
[null,"1.2.1 ","Наименование проекта",{"$f":"Смета!C5","v":"Работа №2"}]
[null,"1.2.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"1.2.1.2","Краткое описание проекта"]
[null,"1.2.1.3","Цель проекта"]
[null,"1.2.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"1.2.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K5","v":600},{"$f":"E36","v":"-"},{"$f":"F36","v":"-"},180,180,240,"-","-","-","-","-"]
[null,"1.2.1.6","Срок реализации проекта",{"$f":"Смета!M5","v":"3"}]
[null,"1.2.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E36:N36)=D34,D34,\"Ошибка!\")","v":600},"-","-",180,180,240,"-","-","-","-","-"]
[null,"1.2.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D38:D40)","v":600},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":180},{"$f":"SUM(H38:H40)","v":180},{"$f":"SUM(I38:I40)","v":240},{"$f":"SUM(J38:J40)","v":0},{"$f":"SUM(K38:K40)","v":0},{"$f":"SUM(L38:L40)","v":0},{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E38:N38)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E39:N39)","v":0}]
[null,null,"Местный бюджет",600,null,null,180,180,240]
[null,"1.2.1.9","Внебюджетные источники",{"$f":"SUM(E41:N41)","v":0},{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0},{"$f":"K42","v":0},{"$f":"L42","v":0},{"$f":"M42","v":0},{"$f":"N42","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},{"$f":"SUM(M43:M44)","v":0},{"$f":"SUM(N43:N44)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E43:N43)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E44:N44)","v":0}]
[null,"1.2.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"1.2.2 ","Наименование проекта",{"$f":"Смета!C7","v":"Новая работа"},null,null,null,null,null,null,null,null,null,null,"При внесении информации в графы “С” и “D” листа “Смета” здесь автоматически должен появляться новый блок, со всеми формулами и т.п."]
[null,"1.2.2.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"1.2.2.2","Краткое описание проекта"]
[null,"1.2.2.3","Цель проекта"]
[null,"1.2.2.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"1.2.2.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K7","v":375},{"$f":"E55","v":"-"},{"$f":"F55","v":"-"},"-","-","-","-",187.5,187.5,"-","-"]
[null,"1.2.2.6","Срок реализации проекта",{"$f":"Смета!M7","v":"2"}]
[null,"1.2.2.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E55:N55)=D53,D53,\"Ошибка!\")","v":375},"-","-","-","-","-","-",187.5,187.5,"-","-"]
[null,"1.2.2.8","Бюджетные источники, в том числе:",{"$f":"SUM(D57:D59)","v":375},{"$f":"SUM(E57:E59)","v":0},{"$f":"SUM(F57:F59)","v":0},{"$f":"SUM(G57:G59)","v":0},{"$f":"SUM(H57:H59)","v":0},{"$f":"SUM(I57:I59)","v":0},{"$f":"SUM(J57:J59)","v":0},{"$f":"SUM(K57:K59)","v":187.5},{"$f":"SUM(L57:L59)","v":187.5},{"$f":"SUM(M57:M59)","v":0},{"$f":"SUM(N57:N59)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E57:N57)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E58:N58)","v":375},null,null,null,null,null,null,187.5,187.5]
[null,null,"Местный бюджет",0]
[null,"1.2.2.9","Внебюджетные источники",{"$f":"SUM(E60:N60)","v":0},{"$f":"E61","v":0},{"$f":"F61","v":0},{"$f":"G61","v":0},{"$f":"H61","v":0},{"$f":"I61","v":0},{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"L61","v":0},{"$f":"M61","v":0},{"$f":"N61","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D62:D63)","v":0},{"$f":"SUM(E62:E63)","v":0},{"$f":"SUM(F62:F63)","v":0},{"$f":"SUM(G62:G63)","v":0},{"$f":"SUM(H62:H63)","v":0},{"$f":"SUM(I62:I63)","v":0},{"$f":"SUM(J62:J63)","v":0},{"$f":"SUM(K62:K63)","v":0},{"$f":"SUM(L62:L63)","v":0},{"$f":"SUM(M62:M63)","v":0},{"$f":"SUM(N62:N63)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E62:N62)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E63:N63)","v":0}]
[null,"1.2.2.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,1.3,"Строительство объектов и сетей теплоснабжения для перспективной застройки"]
[null,"1.3.1 ","Наименование проекта",{"$f":"Смета!C6","v":"Работа №3"}]
[null,"1.3.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"1.3.1.2","Краткое описание проекта"]
[null,"1.3.1.3","Цель проекта"]
[null,"1.3.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"1.3.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K6","v":120},{"$f":"E75","v":"-"},{"$f":"F75","v":"-"},"-","-",{"$f":"I75","v":24},24,24,24,24,"-"]
[null,"1.3.1.6","Срок реализации проекта",{"$f":"Смета!M6","v":"5"}]
[null,"1.3.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E75:N75)=D73,D73,\"Ошибка!\")","v":120},"-","-","-","-",24,24,24,24,24,"-"]
[null,"1.3.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D77:D79)","v":120},{"$f":"SUM(E77:E79)","v":0},{"$f":"SUM(F77:F79)","v":0},{"$f":"SUM(G77:G79)","v":0},{"$f":"SUM(H77:H79)","v":0},{"$f":"SUM(I77:I79)","v":24},{"$f":"SUM(J77:J79)","v":24},{"$f":"SUM(K77:K79)","v":24},{"$f":"SUM(L77:L79)","v":24},{"$f":"SUM(M77:M79)","v":24},{"$f":"SUM(N77:N79)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E77:N77)","v":120},null,null,null,null,24,24,24,24,24]
[null,null,"Региональный бюджет",{"$f":"SUM(E78:N78)","v":0}]
[null,null,"Местный бюджет",0]
[null,"1.3.1.9","Внебюджетные источники",{"$f":"SUM(E80:N80)","v":0},{"$f":"E81","v":0},{"$f":"F81","v":0},{"$f":"G81","v":0},{"$f":"H81","v":0},{"$f":"I81","v":0},{"$f":"J81","v":0},{"$f":"K81","v":0},{"$f":"L81","v":0},{"$f":"M81","v":0},{"$f":"N81","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D82:D83)","v":0},{"$f":"SUM(E82:E83)","v":0},{"$f":"SUM(F82:F83)","v":0},{"$f":"SUM(G82:G83)","v":0},{"$f":"SUM(H82:H83)","v":0},{"$f":"SUM(I82:I83)","v":0},{"$f":"SUM(J82:J83)","v":0},{"$f":"SUM(K82:K83)","v":0},{"$f":"SUM(L82:L83)","v":0},{"$f":"SUM(M82:M83)","v":0},{"$f":"SUM(N82:N83)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E82:N82)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E83:N83)","v":0}]
[null,"1.3.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,1.4,"ВСЕГО ПО СИСТЕМЕ",{"$f":"SUMIF($C7:$N84,$C$14,D7:D84)","v":1755},{"$f":"SUMIF($C7:$N84,$C$14,E7:E84)","v":0},0,510,510,264,24,211.5,211.5,24,0,"При добавлении карточек проектов и расширении таблицы формула должна включать добавляемые разделы"]
[null,null,"Источники инвестиций, в том числе:",{"$f":"SUM(D87,D91)","v":1755},{"$f":"SUM(E87,E91)","v":0},0,510,510,264,24,211.5,211.5,24,0]
[null,"1.4.1","Бюджетные источники, в том числе:",{"$f":"SUM(D88:D90)","v":1095},{"$f":"SUM(E88:E90)","v":0},0,180,180,264,24,211.5,211.5,24,0]
[null,null,"Федеральный бюджет",{"$f":"SUMIF($C7:$N84,$C$18,D7:D84)","v":120},{"$f":"SUMIF($C7:$N84,$C$18,E7:E84)","v":0},0,0,0,24,24,24,24,24,0]
[null,null,"Региональный бюджет",{"$f":"SUMIF($C7:$N84,$C$19,D7:D84)","v":375},{"$f":"SUMIF($C7:$N84,$C$19,E7:E84)","v":0},0,0,0,0,0,187.5,187.5,0,0]
[null,null,"Местный бюджет",{"$f":"SUMIF($C7:$N84,$C$20,D7:D84)","v":600},{"$f":"SUMIF($C7:$N84,$C$20,E7:E84)","v":0},0,180,180,240,0,0,0,0,0]
[null,"1.4.2","Внебюджетные источники",{"$f":"D92","v":660},{"$f":"E92","v":0},0,330,330,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D93:D94)","v":660},{"$f":"SUM(E93:E94)","v":0},0,330,330,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUMIF($C7:$N84,$C$23,D7:D84)","v":0},{"$f":"SUMIF($C7:$N84,$C$23,E7:E84)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUMIF($C7:$N84,$C$24,D7:D84)","v":660},{"$f":"SUMIF($C7:$N84,$C$24,E7:E84)","v":0},0,330,330,0,0,0,0,0,0]
[]
[null,null,"Control",{"$f":"IF(D85=D86,\"ОК\",\"Ошибка\")","v":"ОК"},{"$f":"IF(E85=E86,\"ОК\",\"Ошибка\")","v":"ОК"},"ОК","ОК","ОК","ОК","ОК","ОК","ОК","ОК","ОК"]

{"sheet":"2. Водоснабжение","index":5,"n_rows":95,"n_cols":14,"rows_kept":95,"cut":false,"hidden":false,"merged":[[85,2,85,13],[8,3,8,13],[49,3,49,13],[69,3,69,13],[68,3,68,13],[67,3,67,13],[27,3,27,13],[28,3,28,13],[29,3,29,13],[47,3,47,13],[48,3,48,13],[26,3,26,13],[46,3,46,13],[66,3,66,13],[25,2,25,13],[45,2,45,13],[74,3,74,13],[9,3,9,13],[65,2,65,13],[2,1,4,1],[2,2,4,2],[2,3,2,13],[3,3,4,3],[7,3,7,13],[6,3,6,13],[5,2,5,13],[14,3,14,13],[34,3,34,13],[54,3,54,13]]}
[null,{"$f":"CONCATENATE(\"ПРИЛОЖЕНИЕ\",\" \",Приложения!B4,\". \",Приложения!C4)","v":"ПРИЛОЖЕНИЕ 2. ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ВОДОСНАБЖЕНИИ"}]
[]
[null,"№ пп","Инвестиционные проекты","Финансовые затраты на реализацию (млн руб.)"]
[null,null,null,"Всего",{"$f":"Приложения!D4","v":2022},{"$f":"E4+1","v":2023},{"$f":"F4+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,null,null,null,"год","год","год","год","год","год","год","год","год","год"]
[null,"2.1","Реконструкция и строительство объектов инженерной инфраструктуры"]
[null,"2.1.1 ","Наименование проекта",{"$f":"Смета!C4","v":"Работа №1"}]
[null,"2.1.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"2.1.1.2","Краткое описание проекта"]
[null,"2.1.1.3","Цель проекта"]
[null,"2.1.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"2.1.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K4","v":660},{"$f":"E16","v":"-"},{"$f":"F16","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"2.1.1.6","Срок реализации проекта",{"$f":"Смета!M4","v":2}]
[null,"2.1.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E16:N16)=D14,D14,\"Ошибка!\")","v":660},"-","-",330,330,"-","-","-","-","-","-"]
[null,"2.1.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Федеральный бюджет",{"$f":"SUM(E18:N18)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E19:N19)","v":0}]
[null,null,"Местный бюджет",0]
[null,"2.1.1.9","Внебюджетные источники",{"$f":"SUM(E21:N21)","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E23:N23)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E24:N24)","v":0}]
[null,"2.1.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"2.2","Строительство и реконструкция объектов коммунальной инфраструктуры для перспективной застройки"]
[null,"2.2.1 ","Наименование проекта",{"$f":"Смета!C24","v":0}]
[null,"2.2.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"2.2.1.2","Краткое описание проекта"]
[null,"2.2.1.3","Цель проекта"]
[null,"2.2.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"2.2.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K24","v":0},{"$f":"E36","v":"-"},{"$f":"F36","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"2.2.1.6","Срок реализации проекта",{"$f":"Смета!M24","v":0}]
[null,"2.2.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E36:N36)=D34,D34,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"2.2.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D38:D40)","v":0},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":0},{"$f":"SUM(H38:H40)","v":0},{"$f":"SUM(I38:I40)","v":0},{"$f":"SUM(J38:J40)","v":0},{"$f":"SUM(K38:K40)","v":0},{"$f":"SUM(L38:L40)","v":0},{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E38:N38)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E39:N39)","v":0}]
[null,null,"Местный бюджет",0]
[null,"2.2.1.9","Внебюджетные источники",{"$f":"SUM(E41:N41)","v":0},{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0},{"$f":"K42","v":0},{"$f":"L42","v":0},{"$f":"M42","v":0},{"$f":"N42","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},{"$f":"SUM(M43:M44)","v":0},{"$f":"SUM(N43:N44)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E43:N43)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E44:N44)","v":0}]
[null,"2.2.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"2.3","Строительство и реконструкция объектов коммунальной инфраструктуры для существующей застройки"]
[null,"2.3.1 ","Наименование проекта",{"$f":"Смета!C44","v":0}]
[null,"2.3.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"2.3.1.2","Краткое описание проекта"]
[null,"2.3.1.3","Цель проекта"]
[null,"2.3.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"2.3.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K44","v":0},{"$f":"E56","v":"-"},{"$f":"F56","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"2.3.1.6","Срок реализации проекта",{"$f":"Смета!M44","v":0}]
[null,"2.3.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E56:N56)=D54,D54,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"2.3.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D58:D60)","v":0},{"$f":"SUM(E58:E60)","v":0},{"$f":"SUM(F58:F60)","v":0},{"$f":"SUM(G58:G60)","v":0},{"$f":"SUM(H58:H60)","v":0},{"$f":"SUM(I58:I60)","v":0},{"$f":"SUM(J58:J60)","v":0},{"$f":"SUM(K58:K60)","v":0},{"$f":"SUM(L58:L60)","v":0},{"$f":"SUM(M58:M60)","v":0},{"$f":"SUM(N58:N60)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E58:N58)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E59:N59)","v":0}]
[null,null,"Местный бюджет",0]
[null,"2.3.1.9","Внебюджетные источники",{"$f":"SUM(E61:N61)","v":0},{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0},{"$f":"M62","v":0},{"$f":"N62","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D63:D64)","v":0},{"$f":"SUM(E63:E64)","v":0},{"$f":"SUM(F63:F64)","v":0},{"$f":"SUM(G63:G64)","v":0},{"$f":"SUM(H63:H64)","v":0},{"$f":"SUM(I63:I64)","v":0},{"$f":"SUM(J63:J64)","v":0},{"$f":"SUM(K63:K64)","v":0},{"$f":"SUM(L63:L64)","v":0},{"$f":"SUM(M63:M64)","v":0},{"$f":"SUM(N63:N64)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E63:N63)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E64:N64)","v":0}]
[null,"2.3.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"2.4","Модернизация объектов инженерной инфраструктуры"]
[null,"2.4.1 ","Наименование проекта",{"$f":"Смета!C64","v":0}]
[null,"2.4.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"2.4.1.2","Краткое описание проекта"]
[null,"2.4.1.3","Цель проекта"]
[null,"2.4.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"2.4.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K64","v":0},{"$f":"E76","v":"-"},{"$f":"F76","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"2.4.1.6","Срок реализации проекта",{"$f":"Смета!M64","v":0}]
[null,"2.4.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E76:N76)=D74,D74,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"2.4.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D78:D80)","v":0},{"$f":"SUM(E78:E80)","v":0},{"$f":"SUM(F78:F80)","v":0},{"$f":"SUM(G78:G80)","v":0},{"$f":"SUM(H78:H80)","v":0},{"$f":"SUM(I78:I80)","v":0},{"$f":"SUM(J78:J80)","v":0},{"$f":"SUM(K78:K80)","v":0},{"$f":"SUM(L78:L80)","v":0},{"$f":"SUM(M78:M80)","v":0},{"$f":"SUM(N78:N80)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E78:N78)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E79:N79)","v":0}]
[null,null,"Местный бюджет",0]
[null,"2.4.1.9","Внебюджетные источники",{"$f":"SUM(E81:N81)","v":0},{"$f":"E82","v":0},{"$f":"F82","v":0},{"$f":"G82","v":0},{"$f":"H82","v":0},{"$f":"I82","v":0},{"$f":"J82","v":0},{"$f":"K82","v":0},{"$f":"L82","v":0},{"$f":"M82","v":0},{"$f":"N82","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D83:D84)","v":0},{"$f":"SUM(E83:E84)","v":0},{"$f":"SUM(F83:F84)","v":0},{"$f":"SUM(G83:G84)","v":0},{"$f":"SUM(H83:H84)","v":0},{"$f":"SUM(I83:I84)","v":0},{"$f":"SUM(J83:J84)","v":0},{"$f":"SUM(K83:K84)","v":0},{"$f":"SUM(L83:L84)","v":0},{"$f":"SUM(M83:M84)","v":0},{"$f":"SUM(N83:N84)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E83:N83)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E84:N84)","v":0}]
[null,"2.4.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,2.5,"ВСЕГО ПО СИСТЕМЕ"]
[null,null,"Источники инвестиций, в том числе:"]
[null,"2.5.1","Бюджетные источники, в том числе:"]
[null,null,"Федеральный бюджет"]
[null,null,"Региональный бюджет"]
[null,null,"Местный бюджет"]
[null,"2.5.2","Внебюджетные источники"]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:"]
[null,null,"Инвестиционная составляющая в тарифе"]
[null,null,"Плата за подключение к системе ресурсоснабжения"]

{"sheet":"3. Водоотведение","index":6,"n_rows":95,"n_cols":14,"rows_kept":95,"cut":false,"hidden":false,"merged":[[45,2,45,13],[65,2,65,13],[85,2,85,13],[9,3,9,13],[54,3,54,13],[74,3,74,13],[67,3,67,13],[68,3,68,13],[69,3,69,13],[49,3,49,13],[47,3,47,13],[48,3,48,13],[46,3,46,13],[66,3,66,13],[2,1,4,1],[2,2,4,2],[2,3,2,13],[3,3,4,3],[7,3,7,13],[8,3,8,13],[6,3,6,13],[5,2,5,13],[14,3,14,13],[34,3,34,13],[27,3,27,13],[28,3,28,13],[29,3,29,13],[26,3,26,13],[25,2,25,13]]}
[null,{"$f":"CONCATENATE(\"ПРИЛОЖЕНИЕ\",\" \",Приложения!B5,\". \",Приложения!C5)","v":"ПРИЛОЖЕНИЕ 3. ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ВОДООТВЕДЕНИИ"}]
[]
[null,"№ пп","Инвестиционные проекты","Финансовые затраты на реализацию (млн руб.)"]
[null,null,null,"Всего",{"$f":"Приложения!D5","v":2022},{"$f":"E4+1","v":2023},{"$f":"F4+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,null,null,null,"год","год","год","год","год","год","год","год","год","год"]
[null,3.1,"Реконструкция и строительство объектов водоотведения"]
[null,"3.1.1 ","Наименование проекта",{"$f":"Смета!C4","v":"Работа №1"}]
[null,"3.1.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"3.1.1.2","Краткое описание проекта"]
[null,"3.1.1.3","Цель проекта"]
[null,"3.1.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"3.1.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K4","v":660},{"$f":"E16","v":"-"},{"$f":"F16","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"3.1.1.6","Срок реализации проекта",{"$f":"Смета!M4","v":2}]
[null,"3.1.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E16:N16)=D14,D14,\"Ошибка!\")","v":660},"-","-",330,330,"-","-","-","-","-","-"]
[null,"3.1.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Федеральный бюджет",{"$f":"SUM(E18:N18)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E19:N19)","v":0}]
[null,null,"Местный бюджет",0]
[null,"3.1.1.9","Внебюджетные источники",{"$f":"SUM(E21:N21)","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E23:N23)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E24:N24)","v":0}]
[null,"3.1.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,3.2,"Строительство и реконструкция объектов коммунальной инфраструктуры для перспективной застройки"]
[null,"3.2.1 ","Наименование проекта",{"$f":"Смета!C24","v":0}]
[null,"3.2.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"3.2.1.2","Краткое описание проекта"]
[null,"3.2.1.3","Цель проекта"]
[null,"3.2.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"3.2.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K24","v":0},{"$f":"E36","v":"-"},{"$f":"F36","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"3.2.1.6","Срок реализации проекта",{"$f":"Смета!M24","v":0}]
[null,"3.2.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E36:N36)=D34,D34,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"3.2.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D38:D40)","v":0},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":0},{"$f":"SUM(H38:H40)","v":0},{"$f":"SUM(I38:I40)","v":0},{"$f":"SUM(J38:J40)","v":0},{"$f":"SUM(K38:K40)","v":0},{"$f":"SUM(L38:L40)","v":0},{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E38:N38)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E39:N39)","v":0}]
[null,null,"Местный бюджет",0]
[null,"3.2.1.9","Внебюджетные источники",{"$f":"SUM(E41:N41)","v":0},{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0},{"$f":"K42","v":0},{"$f":"L42","v":0},{"$f":"M42","v":0},{"$f":"N42","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},{"$f":"SUM(M43:M44)","v":0},{"$f":"SUM(N43:N44)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E43:N43)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E44:N44)","v":0}]
[null,"3.2.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,3.3,"Строительство и реконструкция объектов коммунальной инфраструктуры для существующей застройки"]
[null,"3.3.1 ","Наименование проекта",{"$f":"Смета!C44","v":0}]
[null,"3.3.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"3.3.1.2","Краткое описание проекта"]
[null,"3.3.1.3","Цель проекта"]
[null,"3.3.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"3.3.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K44","v":0},{"$f":"E56","v":"-"},{"$f":"F56","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"3.3.1.6","Срок реализации проекта",{"$f":"Смета!M44","v":0}]
[null,"3.3.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E56:N56)=D54,D54,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"3.3.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D58:D60)","v":0},{"$f":"SUM(E58:E60)","v":0},{"$f":"SUM(F58:F60)","v":0},{"$f":"SUM(G58:G60)","v":0},{"$f":"SUM(H58:H60)","v":0},{"$f":"SUM(I58:I60)","v":0},{"$f":"SUM(J58:J60)","v":0},{"$f":"SUM(K58:K60)","v":0},{"$f":"SUM(L58:L60)","v":0},{"$f":"SUM(M58:M60)","v":0},{"$f":"SUM(N58:N60)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E58:N58)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E59:N59)","v":0}]
[null,null,"Местный бюджет",0]
[null,"3.3.1.9","Внебюджетные источники",{"$f":"SUM(E61:N61)","v":0},{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0},{"$f":"M62","v":0},{"$f":"N62","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D63:D64)","v":0},{"$f":"SUM(E63:E64)","v":0},{"$f":"SUM(F63:F64)","v":0},{"$f":"SUM(G63:G64)","v":0},{"$f":"SUM(H63:H64)","v":0},{"$f":"SUM(I63:I64)","v":0},{"$f":"SUM(J63:J64)","v":0},{"$f":"SUM(K63:K64)","v":0},{"$f":"SUM(L63:L64)","v":0},{"$f":"SUM(M63:M64)","v":0},{"$f":"SUM(N63:N64)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E63:N63)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E64:N64)","v":0}]
[null,"3.3.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"3.4","Модернизация объектов инженерной инфраструктуры"]
[null,"3.4.1 ","Наименование проекта",{"$f":"Смета!C64","v":0}]
[null,"3.4.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"3.4.1.2","Краткое описание проекта"]
[null,"3.4.1.3","Цель проекта"]
[null,"3.4.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в сутки"]
[null,null,"строительство сетей, км"]
[null,"3.4.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K64","v":0},{"$f":"E76","v":"-"},{"$f":"F76","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"3.4.1.6","Срок реализации проекта",{"$f":"Смета!M64","v":0}]
[null,"3.4.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E76:N76)=D74,D74,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"3.4.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D78:D80)","v":0},{"$f":"SUM(E78:E80)","v":0},{"$f":"SUM(F78:F80)","v":0},{"$f":"SUM(G78:G80)","v":0},{"$f":"SUM(H78:H80)","v":0},{"$f":"SUM(I78:I80)","v":0},{"$f":"SUM(J78:J80)","v":0},{"$f":"SUM(K78:K80)","v":0},{"$f":"SUM(L78:L80)","v":0},{"$f":"SUM(M78:M80)","v":0},{"$f":"SUM(N78:N80)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E78:N78)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E79:N79)","v":0}]
[null,null,"Местный бюджет",0]
[null,"3.4.1.9","Внебюджетные источники",{"$f":"SUM(E81:N81)","v":0},{"$f":"E82","v":0},{"$f":"F82","v":0},{"$f":"G82","v":0},{"$f":"H82","v":0},{"$f":"I82","v":0},{"$f":"J82","v":0},{"$f":"K82","v":0},{"$f":"L82","v":0},{"$f":"M82","v":0},{"$f":"N82","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D83:D84)","v":0},{"$f":"SUM(E83:E84)","v":0},{"$f":"SUM(F83:F84)","v":0},{"$f":"SUM(G83:G84)","v":0},{"$f":"SUM(H83:H84)","v":0},{"$f":"SUM(I83:I84)","v":0},{"$f":"SUM(J83:J84)","v":0},{"$f":"SUM(K83:K84)","v":0},{"$f":"SUM(L83:L84)","v":0},{"$f":"SUM(M83:M84)","v":0},{"$f":"SUM(N83:N84)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E83:N83)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E84:N84)","v":0}]
[null,"3.4.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"3.5","ВСЕГО ПО СИСТЕМЕ"]
[null,null,"Источники инвестиций, в том числе:"]
[null,"3.5.1","Бюджетные источники, в том числе:"]
[null,null,"Федеральный бюджет"]
[null,null,"Региональный бюджет"]
[null,null,"Местный бюджет"]
[null,"3.5.2","Внебюджетные источники"]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:"]
[null,null,"Инвестиционная составляющая в тарифе"]
[null,null,"Плата за подключение к системе ресурсоснабжения"]

{"sheet":"4. Электроснабжение","index":7,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":false,"merged":[[65,2,65,13],[6,3,6,13],[26,3,26,13],[46,3,46,13],[5,2,5,13],[25,2,25,13],[45,2,45,13],[14,3,14,13],[34,3,34,13],[54,3,54,13],[9,3,9,13],[8,3,8,13],[49,3,49,13],[27,3,27,13],[28,3,28,13],[29,3,29,13],[47,3,47,13],[48,3,48,13],[2,1,4,1],[2,2,4,2],[2,3,2,13],[3,3,4,3],[7,3,7,13]]}
[null,{"$f":"CONCATENATE(\"ПРИЛОЖЕНИЕ\",\" \",Приложения!B6,\". \",Приложения!C6)","v":"ПРИЛОЖЕНИЕ 4. ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ЭЛЕКТРОСНАБЖЕНИИ"}]
[]
[null,"№ пп","Инвестиционные проекты","Финансовые затраты на реализацию (млн руб.)"]
[null,null,null,"Всего",{"$f":"Приложения!D6","v":2022},{"$f":"E4+1","v":2023},{"$f":"F4+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,null,null,null,"год","год","год","год","год","год","год","год","год","год"]
[null,4.0999999999999996,"Реконструкция объектов и сетей электроснабжения"]
[null,"4.1.1 ","Наименование проекта",{"$f":"Смета!C4","v":"Работа №1"}]
[null,"4.1.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"4.1.1.2","Краткое описание проекта"]
[null,"4.1.1.3","Цель проекта"]
[null,"4.1.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"4.1.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K4","v":660},{"$f":"E16","v":"-"},{"$f":"F16","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"4.1.1.6","Срок реализации проекта",{"$f":"Смета!M4","v":2}]
[null,"4.1.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E16:N16)=D14,D14,\"Ошибка!\")","v":660},"-","-",330,330,"-","-","-","-","-","-"]
[null,"4.1.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Федеральный бюджет",{"$f":"SUM(E18:N18)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E19:N19)","v":0}]
[null,null,"Местный бюджет",0]
[null,"4.1.1.9","Внебюджетные источники",{"$f":"SUM(E21:N21)","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E23:N23)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E24:N24)","v":0}]
[null,"4.1.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,4.2,"Строительство объектов и сетей электроснабжения"]
[null,"4.2.1 ","Наименование проекта",{"$f":"Смета!C24","v":0}]
[null,"4.2.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"4.2.1.2","Краткое описание проекта"]
[null,"4.2.1.3","Цель проекта"]
[null,"4.2.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"4.2.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K24","v":0},{"$f":"E36","v":"-"},{"$f":"F36","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"4.2.1.6","Срок реализации проекта",{"$f":"Смета!M24","v":0}]
[null,"4.2.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E36:N36)=D34,D34,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"4.2.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D38:D40)","v":0},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":0},{"$f":"SUM(H38:H40)","v":0},{"$f":"SUM(I38:I40)","v":0},{"$f":"SUM(J38:J40)","v":0},{"$f":"SUM(K38:K40)","v":0},{"$f":"SUM(L38:L40)","v":0},{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E38:N38)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E39:N39)","v":0}]
[null,null,"Местный бюджет",0]
[null,"4.2.1.9","Внебюджетные источники",{"$f":"SUM(E41:N41)","v":0},{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0},{"$f":"K42","v":0},{"$f":"L42","v":0},{"$f":"M42","v":0},{"$f":"N42","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},{"$f":"SUM(M43:M44)","v":0},{"$f":"SUM(N43:N44)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E43:N43)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E44:N44)","v":0}]
[null,"4.2.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,4.3,"Строительство объектов и сетей электроснабжения для перспективной застройки"]
[null,"4.3.1 ","Наименование проекта",{"$f":"Смета!C44","v":0}]
[null,"4.3.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"4.3.1.2","Краткое описание проекта"]
[null,"4.3.1.3","Цель проекта"]
[null,"4.3.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, МВт"]
[null,null,"строительство сетей, км"]
[null,"4.3.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K44","v":0},{"$f":"E56","v":"-"},{"$f":"F56","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"4.3.1.6","Срок реализации проекта",{"$f":"Смета!M44","v":0}]
[null,"4.3.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E56:N56)=D54,D54,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"4.3.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D58:D60)","v":0},{"$f":"SUM(E58:E60)","v":0},{"$f":"SUM(F58:F60)","v":0},{"$f":"SUM(G58:G60)","v":0},{"$f":"SUM(H58:H60)","v":0},{"$f":"SUM(I58:I60)","v":0},{"$f":"SUM(J58:J60)","v":0},{"$f":"SUM(K58:K60)","v":0},{"$f":"SUM(L58:L60)","v":0},{"$f":"SUM(M58:M60)","v":0},{"$f":"SUM(N58:N60)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E58:N58)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E59:N59)","v":0}]
[null,null,"Местный бюджет",0]
[null,"4.3.1.9","Внебюджетные источники",{"$f":"SUM(E61:N61)","v":0},{"$f":"E62","v":0},{"$f":"F62","v":0},{"$f":"G62","v":0},{"$f":"H62","v":0},{"$f":"I62","v":0},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0},{"$f":"M62","v":0},{"$f":"N62","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D63:D64)","v":0},{"$f":"SUM(E63:E64)","v":0},{"$f":"SUM(F63:F64)","v":0},{"$f":"SUM(G63:G64)","v":0},{"$f":"SUM(H63:H64)","v":0},{"$f":"SUM(I63:I64)","v":0},{"$f":"SUM(J63:J64)","v":0},{"$f":"SUM(K63:K64)","v":0},{"$f":"SUM(L63:L64)","v":0},{"$f":"SUM(M63:M64)","v":0},{"$f":"SUM(N63:N64)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E63:N63)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E64:N64)","v":0}]
[null,"4.3.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,4.4000000000000004,"ВСЕГО ПО СИСТЕМЕ"]
[null,null,"Источники инвестиций, в том числе:"]
[null,"4.4.1","Бюджетные источники, в том числе:"]
[null,null,"Федеральный бюджет"]
[null,null,"Региональный бюджет"]
[null,null,"Местный бюджет"]
[null,"4.4.2","Внебюджетные источники"]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:"]
[null,null,"Инвестиционная составляющая в тарифе"]
[null,null,"Плата за подключение к системе ресурсоснабжения"]

{"sheet":"5. Газоснабжение","index":8,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[14,3,14,13],[26,3,26,13],[25,2,25,13],[45,2,45,13],[34,3,34,13],[27,3,27,13],[28,3,28,13],[29,3,29,13],[2,1,4,1],[7,3,7,13],[8,3,8,13],[9,3,9,13],[2,3,2,13],[3,3,4,3],[6,3,6,13],[5,2,5,13],[2,2,4,2]]}
[null,{"$f":"CONCATENATE(\"ПРИЛОЖЕНИЕ\",\" \",Приложения!B7,\". \",Приложения!C7)","v":"ПРИЛОЖЕНИЕ 5. ПРОГРАММА ИНВЕСТИЦИОННЫХ ПРОЕКТОВ В ГАЗОСНАБЖЕНИИ"}]
[]
[null,"№ пп","Инвестиционные проекты","Финансовые затраты на реализацию (млн руб.)"]
[null,null,null,"Всего",{"$f":"Приложения!D7","v":2022},{"$f":"E4+1","v":2023},{"$f":"F4+1","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,null,null,null,"год","год","год","год","год","год","год","год","год","год"]
[null,"5.1","Реконструкция объектов и сетей газоснабжения"]
[null,"5.1.1 ","Наименование проекта",{"$f":"Смета!C4","v":"Работа №1"}]
[null,"5.1.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"5.1.1.2","Краткое описание проекта"]
[null,"5.1.1.3","Цель проекта"]
[null,"5.1.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в час"]
[null,null,"строительство сетей, км"]
[null,"5.1.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K4","v":660},{"$f":"E16","v":"-"},{"$f":"F16","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"5.1.1.6","Срок реализации проекта",{"$f":"Смета!M4","v":2}]
[null,"5.1.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E16:N16)=D14,D14,\"Ошибка!\")","v":660},"-","-",330,330,"-","-","-","-","-","-"]
[null,"5.1.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Федеральный бюджет",{"$f":"SUM(E18:N18)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E19:N19)","v":0}]
[null,null,"Местный бюджет",0]
[null,"5.1.1.9","Внебюджетные источники",{"$f":"SUM(E21:N21)","v":0},{"$f":"E22","v":0},{"$f":"F22","v":0},0,0,0,0,0,0,0,0]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E23:N23)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E24:N24)","v":0}]
[null,"5.1.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"5.2","Строительство объектов и сетей газоснабжения"]
[null,"5.2.1 ","Наименование проекта",{"$f":"Смета!C24","v":0}]
[null,"5.2.1.1","Ссылка на соответствующие подразделы обосновывающих материалов"]
[null,"5.2.1.2","Краткое описание проекта"]
[null,"5.2.1.3","Цель проекта"]
[null,"5.2.1.4","Технические характеристики проекта, в том числе:"]
[null,null,"ввод мощностей, куб. м в час"]
[null,null,"строительство сетей, км"]
[null,"5.2.1.5","Необходимые капитальные затраты, млн руб.",{"$f":"Смета!K24","v":0},{"$f":"E36","v":"-"},{"$f":"F36","v":"-"},330,330,"-","-","-","-","-","-"]
[null,"5.2.1.6","Срок реализации проекта",{"$f":"Смета!M24","v":0}]
[null,"5.2.1.7","Источники инвестиций, в том числе:",{"$f":"IF(SUM(E36:N36)=D34,D34,\"Ошибка!\")","v":"Ошибка!"},"-","-",330,330,"-","-","-","-","-","-"]
[null,"5.2.1.8","Бюджетные источники, в том числе:",{"$f":"SUM(D38:D40)","v":0},{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0},{"$f":"SUM(G38:G40)","v":0},{"$f":"SUM(H38:H40)","v":0},{"$f":"SUM(I38:I40)","v":0},{"$f":"SUM(J38:J40)","v":0},{"$f":"SUM(K38:K40)","v":0},{"$f":"SUM(L38:L40)","v":0},{"$f":"SUM(M38:M40)","v":0},{"$f":"SUM(N38:N40)","v":0}]
[null,null,"Федеральный бюджет",{"$f":"SUM(E38:N38)","v":0}]
[null,null,"Региональный бюджет",{"$f":"SUM(E39:N39)","v":0}]
[null,null,"Местный бюджет",0]
[null,"5.2.1.9","Внебюджетные источники",{"$f":"SUM(E41:N41)","v":0},{"$f":"E42","v":0},{"$f":"F42","v":0},{"$f":"G42","v":0},{"$f":"H42","v":0},{"$f":"I42","v":0},{"$f":"J42","v":0},{"$f":"K42","v":0},{"$f":"L42","v":0},{"$f":"M42","v":0},{"$f":"N42","v":0}]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:",{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$f":"SUM(I43:I44)","v":0},{"$f":"SUM(J43:J44)","v":0},{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},{"$f":"SUM(M43:M44)","v":0},{"$f":"SUM(N43:N44)","v":0}]
[null,null,"Инвестиционная составляющая в тарифе",{"$f":"SUM(E43:N43)","v":0}]
[null,null,"Плата за подключение к системе ресурсоснабжения",{"$f":"SUM(E44:N44)","v":0}]
[null,"5.2.1.10","Срок окупаемости внебюджетных инвестиций, лет"]
[null,"5.3","ВСЕГО ПО СИСТЕМЕ"]
[null,null,"Источники инвестиций, в том числе:"]
[null,"5.3.1","Бюджетные источники, в том числе:"]
[null,null,"Федеральный бюджет"]
[null,null,"Региональный бюджет"]
[null,null,"Местный бюджет"]
[null,"5.3.2","Внебюджетные источники"]
[null,null,"Источники возврата внебюджетных инвестиций, в том числе:"]
[null,null,"Инвестиционная составляющая в тарифе"]
[null,null,"Плата за подключение к системе ресурсоснабжения"]

{"sheet":"data","index":9,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Единицы измерений",null,null,"Освоение инвестиций"]
[null,null,"км",null,1,1]
[null,null,"куб. м в сутки",null,2,0.5,0.5]
[null,null,"куб. м в час",null,3,0.3,0.3,0.4]
[null,null,"МВт",null,4,0.2,0.2,0.3,0.3]
[null,null,null,null,5,0.2,0.2,0.2,0.2,0.2]
[null,"НДС"]
[null,null,1]
[null,null,1.2]
[]
[null,"Теплоснабжение",1]
[null,1.1000000000000001,"Реконструкция объектов и сетей теплоснабжения"]
[null,1.2,"Строительство объектов и сетей теплоснабжения"]
[null,1.3,"Строительство объектов и сетей теплоснабжения для перспективной застройки"]
[]
[null,"Водоснабжение",2]
[null,2.1,"Реконструкция и строительство объектов инженерной инфраструктуры"]
[null,2.2000000000000002,"Строительство и реконструкция объектов коммунальной инфраструктуры для перспективной застройки"]
[null,2.2999999999999998,"Строительство и реконструкция объектов коммунальной инфраструктуры для существующей застройки"]
[null,2.4,"Модернизация объектов инженерной инфраструктуры"]
[]
[null,"Водоотведение",3]
[null,3.1,"Реконструкция и строительство объектов водоотведения"]
[null,3.2,"Строительство и реконструкция объектов коммунальной инфраструктуры для перспективной застройки"]
[null,3.3,"Строительство и реконструкция объектов коммунальной инфраструктуры для существующей застройки"]
[null,3.4,"Модернизация объектов инженерной инфраструктуры"]
[]
[null,"Электроснабжение",4]
[null,4.0999999999999996,"Реконструкция объектов и сетей электроснабжения"]
[null,4.2,"Строительство объектов и сетей электроснабжения"]
[null,4.3,"Строительство объектов и сетей электроснабжения для перспективной застройки"]
[]
[null,"Газоснабжение",5]
[null,5.0999999999999996,"Реконструкция объектов и сетей газоснабжения"]
[null,5.2,"Строительство объектов и сетей газоснабжения"]