{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Лист1","1.1-4.1к1","1.1-4.2к1","1.1-4.3","1.1-4.7","1.1-4.8","1.1-4.9","лист для нумерации"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":83,"defined_names":4689,"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":"Лист1","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,71775516.180000007,null,1.3057742064,null,null,{"$f":"C2*E2","v":93722617.680000007}]
[null,null,3443210,null,1.3057742064,null,null,{"$f":"C3*E3","v":4496054.8099999996}]
[null,null,37819459.859999999,null,1.3057742064,null,null,{"$f":"C4*E4","v":49383675.189999998}]
[null,null,36403853.329999998,null,1.3057742064,null,null,{"$f":"C5*E5","v":47535212.689999998}]
[null,null,91490182.030000001,null,1.3057742064,null,null,119465519.83]
[null,null,422220,null,1.3057742064,null,null,{"$f":"C7*E7","v":551323.99}]
[null,null,26924522.73,null,1.3057742064,null,null,{"$f":"C8*E8","v":35157347.299999997}]
[null,null,31400,null,1.3057742064,null,null,{"$f":"C9*E9","v":41001.31}]
[null,null,85900443.379999995,null,1.3057742064,null,null,{"$f":"C10*E10","v":112166583.28}]
[null,null,27715925.66,null,1.3057742064,null,null,{"$f":"C11*E11","v":36190740.829999998}]
[null,null,15082121.470000001,null,1.3057742064,null,null,19693845.190000001]
[null,null,1121130,null,1.3057742064,null,null,{"$f":"C13*E13","v":1463942.64}]
[null,null,345147452.85000002,null,1.3057742064,null,null,{"$f":"C14*E14","v":450684641.33999997}]
[null,null,858266369.75,null,1.3057742064,null,null,{"$f":"C15*E15","v":1120702087.8399999}]
[null,null,51380,null,1.3057742064,null,null,{"$f":"C16*E16","v":67090.679999999993}]
[null,null,25571188.460000001,null,1.3057742064,null,null,{"$f":"C17*E17","v":33390198.32}]
[null,null,402067507.5,null,1.3057742064,null,null,{"$f":"C18*E18","v":525009380.52999997}]
[null,null,39946960.200000003,null,1.3057742064,null,null,52161710.25]
[null,null,313980639.31999999,null,1.3057742064,null,null,409987820.13]
[null,null,74502373.840000004,null,1.3057742064,null,null,97283278.079999998]
[null,null,27649640,null,1.3057742064,null,null,36104186.729999997]
[null,null,213960,null,1.3057742064,null,null,279383.45]
[null,null,65191210,null,1.3057742064,null,null,85125000.5]
[null,null,38320278.439999998,null,1.3057742064,null,null,50037631.170000002]
[null,"итого",{"$f":"SUM(C2:C25)-C3-C7-C9-C13-C16","v":2583969605}]
[null,"ндс за искл. П.23",516615311]
[null,"всего",{"$f":"C26+C27","v":3100584916}]
[null,"возврат",{"$f":"C3+C7+C9+C13+C16","v":5069340}]
[null,2019,{"$f":"C28","v":3100584916}]
[null,2022,3824199423.6999998,{"$f":"C31/C30","v":1.23338000000126}]
[null,2027,4042812565.8099999,null,null,null,null,{"$f":"SUM(H2:H31)-H3-H7-H9-H13-H16","v":3374080860.3299999},null,{"$f":"C34-H32","v":-4876035.21}]
[null,null,673607740.69000006,null,{"$f":"C32/C30","v":1.3038870649689001}]
[null,null,{"$f":"C32-C33","v":3369204825.1199999},null,{"$f":"E33/1.2","v":1.0865725541408}]
[]
[null,null,{"$f":"C34/C30","v":1.0866352370300001}]

{"sheet":"1.1-4.1к1","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[43,7,44,7],[6,0,6,6],[7,0,7,3],[7,5,7,6],[9,0,9,6],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[14,7,27,7],[1,0,3,1],[1,3,1,6],[2,3,2,6],[132,0,132,1],[132,4,132,5],[70,1,73,1],[74,1,77,1],[78,1,81,1],[90,1,93,1],[130,0,130,1],[130,4,130,5],[82,1,85,1],[86,1,89,1],[94,1,97,1],[5,3,5,6],[51,8,56,8],[28,8,32,8],[57,8,60,8],[14,8,16,8],[17,8,20,8],[21,8,27,8],[45,8,47,8],[48,8,50,8],[33,8,39,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Перевозка грузов  на расстояние  до 15 км "]
["№"," № локальных смет","Наименование работ и затрат","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм."]
[null,null,null,null,null,"на единицу","общая"]
[1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,2.7,"Подг.раб","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.7E-2,{"$f":"G15+G16+G17+G18+G19+G20+G21+G22+G23+G24+G25+G26+G27+G28+G29+G30+G31+G32+G33+G34+G35+G36+G37+G38+G39+G40+G41","v":0},{"$f":"E15+E16+E17+E18+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E36+E37+E38+E39+E40+E41","v":0},{"$f":"K16/L16","v":{"$error":"#DIV/0!"}},{"$f":"M16*E71","v":{"$error":"#DIV/0!"}},{"$f":"N16*L16","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Сети связи"]
[null,null,null,null,null,null,null,null,null,{"$f":"318931+1018+198200","v":518149}]
[]
[]
[null,null,null,null,null,null,null,null,"переустр-во эл.снабж."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"теплосеть"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"НВК"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ГАЗ"]
[null,null,null,null,null,null,null,3.5,null,"ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2.5,null,3.5000000000000003E-2,{"$f":"G42","v":0},{"$f":"E42","v":0},{"$f":"K43/L43","v":{"$error":"#DIV/0!"}},{"$f":"M43*6.43","v":{"$error":"#DIV/0!"}},{"$f":"N43*L43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,2.15,null,"ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,{"$f":"G43","v":0},{"$f":"E43","v":0},{"$f":"K45/L45","v":{"$error":"#DIV/0!"}},{"$f":"M45*6.43","v":{"$error":"#DIV/0!"}},{"$f":"N45*L45","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"светофоры","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.1499999999999998E-2,{"$f":"G44+G45+G46+G47+G48","v":0},{"$f":"E44+E45+E46+E47+E48","v":0},{"$f":"ROUND(K47/L47,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M47*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N47*L47","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"эд.снабж. Светофоров","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2,null,0.02,{"$f":"G49+G50+G51+G52+G53+G54+G55+G56+G57","v":0},{"$f":"E49+E50+E51+E52+E53+E54+E55+E56+E57","v":0},{"$f":"ROUND(K50/L50,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M50*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N50*L50","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"эл. Снабж. КНС"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ЛОС, КНС","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2.6,null,2.5999999999999999E-2,{"$f":"G58+G59+G60+G61","v":0},{"$f":"E58+E59+E60+E61","v":0},{"$f":"ROUND(K59/L59,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M59*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N59*L59","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,"Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2.29,"ШЭ",null,{"$f":"G62","v":0},{"$f":"E62","v":0},{"$f":"ROUND(K62/L62,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M62*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N62*L62","v":{"$error":"#DIV/0!"}}]

{"sheet":"1.1-4.2к1","index":2,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,3,2,6],[5,3,5,6],[40,7,41,7],[36,7,37,7],[6,0,6,6],[7,0,7,3],[7,5,7,6],[9,0,9,6],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[14,7,18,7],[1,0,3,1],[1,3,1,6],[119,0,119,1],[119,4,119,5],[57,1,60,1],[61,1,64,1],[65,1,68,1],[77,1,80,1],[117,0,117,1],[117,4,117,5],[69,1,72,1],[73,1,76,1],[81,1,84,1],[42,8,43,8],[45,8,47,8],[14,8,16,8],[17,8,18,8],[19,8,24,8],[38,8,39,8],[40,8,41,8],[25,8,29,8],[30,8,33,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Перевозка  грузов на расстояние  до 13 км"]
["№"," № локальных смет","Наименование работ и затрат","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм.",null,null,null,null,null,null,null,null,null,null,{"$f":"O16+O36+O38+O40","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"на единицу","общая"]
[1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,2.7,"Подг.раб.","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.7E-2,{"$f":"G15+G16+G18+G19+G17+G20+G21+G22+G23+G24+G25+G26+G27+G28+G29+G30+G31+G32+G33+G34","v":0},{"$f":"E15+E16+E18+E19+E17+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34","v":0},{"$f":"K16/L16","v":{"$error":"#DIV/0!"}},{"$f":"M16*6.43","v":{"$error":"#DIV/0!"}},{"$f":"N16*L16","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"сети связи"]
[]
[null,null,null,null,null,null,null,null,"переустр-во эл.снабж."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"НВК"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"E26+E27+E28+E29+E30","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"ГАЗ"]
[]
[]
[]
[null,null,null,null,null,null,null,3.5,null,"ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2.5,null,3.5000000000000003E-2,{"$f":"G35","v":0},{"$f":"E35","v":0},{"$f":"K36/L36","v":{"$error":"#DIV/0!"}},{"$f":"M36*6.43","v":{"$error":"#DIV/0!"}},{"$f":"N36*L36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,2.15,null,"ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,{"$f":"G36","v":0},{"$f":"E36","v":0},{"$f":"K38/L38","v":{"$error":"#DIV/0!"}},{"$f":"M38*6.43","v":{"$error":"#DIV/0!"}},{"$f":"N38*L38","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"светофоры","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,2.1499999999999998E-2,{"$f":"G37+G38+G39+G40","v":0},{"$f":"E37+E38+E39+E40","v":0},{"$f":"ROUND(K40/L40,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M40*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N40*L40","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,2,"эд.снабж. Светофоров","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,null,null,0.02,{"$f":"G41+G42+G43+G44+G45","v":0},{"$f":"E41+E42+E43+E44+E45","v":0},{"$f":"ROUND(K42/L42,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M42*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N42*L42","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"эл. Снабж. КНС"]
[]
[null,null,null,null,null,null,null,null,"НО"]
[null,null,null,null,null,null,null,null,"ЛОС,КНС","ЗУ","Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,2.6,null,2.5999999999999999E-2,{"$f":"G46+G47+G48","v":0},{"$f":"E46+E47+E48","v":0},{"$f":"ROUND(K47/L47,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M47*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N47*L47","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Стоимость в базе ","Объем ","Стоимость за ед. в базе",null,"Пересчёт в текущие цены на 2 квартал 2019г."]
[null,null,null,null,null,null,null,1.95,"ШЭ",null,{"$f":"G49","v":0},{"$f":"E49","v":0},{"$f":"ROUND(K49/L49,2)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M49*6.43,2)","v":{"$error":"#DIV/0!"}},{"$f":"N49*L49","v":{"$error":"#DIV/0!"}}]

{"sheet":"1.1-4.3","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,9,6],[6,0,6,6],[7,0,7,3],[7,5,7,6],[1,0,3,1],[1,3,1,6],[2,3,2,6],[5,3,5,6],[14,7,16,7],[17,7,19,7],[47,0,47,1],[47,4,47,5],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[45,0,45,1],[45,4,45,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Перевозка грузов  на расстояние  до 19 км "]
["№"," № локальных смет","Наименование смет","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм."]
[null,null,null,null,null,"на единицу","общая"]
[1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,"подгт. Раб"]
[]
[]
[null,null,null,null,null,null,null,"ГАЗ"]

{"sheet":"1.1-4.7","index":4,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,20,0],[1,0,3,1],[1,3,1,6],[2,3,2,6],[5,3,5,6],[7,0,7,6],[8,0,8,3],[9,0,9,6],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[28,0,32,0],[41,0,41,1],[41,4,41,5],[43,0,43,1],[43,4,43,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Расчет единичной расценки",null,null,null,"Код",{"$f":"MIDB(CELL(\"filename\",F9),SEARCH(\"]\",CELL(\"filename\",F9))+1,9)","v":"1.1-4.7"},null,"согласовано 08.09.2023"]
["Перевозка грузов на расстояние до 20 км "]
["№","№ № локальных смет","Наименование работ и затрат","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм."]
[null,null,null,null,null,"на единицу","общая"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"254039+485+263069","v":517593}]

{"sheet":"1.1-4.8","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[16,0,20,0],[1,0,3,1],[1,3,1,6],[2,3,2,6],[5,3,5,6],[7,0,7,6],[8,0,8,3],[9,0,9,6],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[28,0,32,0],[40,0,40,1],[40,4,40,5],[42,0,42,1],[42,4,42,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Расчет единичной расценки",null,null,null,"Код",{"$f":"MIDB(CELL(\"filename\",F9),SEARCH(\"]\",CELL(\"filename\",F9))+1,8)","v":"1.1-4.8"},null,"согласовано 08.09.2023"]
["Перевозка грузов на расстояние до 11 км "]
["№","№ № локальных смет","Наименование смет","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм."]
[null,null,null,null,null,"на единицу","общая"]

{"sheet":"1.1-4.9","index":6,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[16,0,20,0],[1,0,3,1],[1,3,1,6],[2,3,2,6],[5,3,5,6],[7,0,7,6],[8,0,8,3],[9,0,9,6],[10,1,11,1],[10,2,11,2],[10,4,11,4],[10,5,11,6],[28,0,32,0],[40,0,40,1],[40,4,40,5],[42,0,42,1],[42,4,42,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Расчет единичной расценки",null,null,null,"Код",{"$f":"MIDB(CELL(\"filename\",F9),SEARCH(\"]\",CELL(\"filename\",F9))+1,9)","v":"1.1-4.9"},null,"согласовано 08.09.2023"]
["Перевозка грузов на расстояние до 10 км "]
["№","№ № локальных смет","Наименование смет","Ед.","Кол-во ед. изм.","Сметная стоимость с HP и СП в базисных ценах на 01.01.2000г., руб"]
["пп",null,null,"изм."]
[null,null,null,null,null,"на единицу","общая"]

{"sheet":"лист для нумерации","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.1к1"},{"$f":"INDIRECT(\"'\"&A2&\"'!A10\")","v":"Перевозка грузов  на расстояние  до 15 км "}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.2к1"},{"$f":"INDIRECT(\"'\"&A3&\"'!A10\")","v":"Перевозка  грузов на расстояние  до 13 км"}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.3"},{"$f":"INDIRECT(\"'\"&A4&\"'!A10\")","v":"Перевозка грузов  на расстояние  до 19 км "}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.7"},{"$f":"INDIRECT(\"'\"&A5&\"'!A10\")","v":"Перевозка грузов на расстояние до 20 км "}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.8"},{"$f":"INDIRECT(\"'\"&A6&\"'!A10\")","v":"Перевозка грузов на расстояние до 11 км "}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"1.1-4.9"},{"$f":"INDIRECT(\"'\"&A7&\"'!A10\")","v":"Перевозка грузов на расстояние до 10 км "}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":"лист для нумерации"}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(Список,ROW()),\"\")","v":""}]