{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["КЖ","ГРЩ","Param","Лист3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":1},"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":172,"n_cols":17,"rows_kept":172,"cut":false,"hidden":false,"merged":[[1,3,1,5],[1,6,1,9],[0,3,0,9],[0,1,0,2],[0,0,2,0]]}
["№ группы","Трасса",null,"Кабель (провод)",null,null,null,null,null,null,"25х16","40х25","гофра 25"]
[null,"Откуда","Куда","По проекту",null,null,"Проложено"]
[null," "," ","U,В","Марка Кабеля","Количество жил и сечение","Длина, м.","В кабель- канале ","В гофр. ПВХ трубе","В мет. рукаве (трубе)"]
[" ","Отходящие линии распределительной панели №1 (РП-1)",null," "," "," "," "," "," "," "]
["П1.1","Распределительная панель №1","Щит распределительный ЩР-1",380,"ППГнг(А)-HF","5х6",8,null,8," ",null,null,null,null,{"$f":"SUM(G5:G13)","v":694}]
["П1.2","Распределительная панель №1","Щит распределительный ЩР-2",380,"ППГнг(А)-HF","5х6",60,null,60," "]
["П1.3","Распределительная панель №1","Щит распределительный ЩР-3",380,"ППГнг(А)-HF","5х6",98,null,98," "]
["П1.4","Распределительная панель №1","Щит распределительный ЩР-4",380,"ППГнг(А)-HF","5х6",64,6,{"$f":"G8-H8","v":58}," "]
["П1.5","Распределительная панель №1","Щит распределительный ЩР-5",380,"ППГнг(А)-HF","5х6",104,6,{"$f":"G9-H9","v":98}," "]
["П1.6","Распределительная панель №1","Щит распределительный ЩР-6",380,"ППГнг(А)-HF","5х6",68,10,58," "]
["П1.7","Распределительная панель №1","Щит распределительный ЩР-7",380,"ППГнг(А)-HF","5х6",108,10,98," "]
["П1.8","Распределительная панель №1","Щит распределительный ЩР-8",380,"ППГнг(А)-HF","5х6",72,14,58," "]
["П1.9","Распределительная панель №1","Щит распределительный ЩР-9",380,"ППГнг(А)-HF","5х6",112,14,98," "]
["П1.10","Распределительная панель №1","Щит распределительный ЩР-10",380,"ППГнг(А)-HF","5х4",70,4,66," "]
[" ","Отходящие линии распределительной панели №2 (РП-2)"," "," "," "," "," "," "," "," "]
["П2.1","Распределительная панель №2","Вытяжной вентилятор на кровле спортзала",380,"ППГнг(А)-HF","5х1,5",28,4," ",24,null,null,null,null,null,null,{"$f":"SUM(J16:J21)","v":55}]
["П2.2","Распределительная панель №2","Вытяжной вентилятор на кровле спортзала",380,"ППГнг(А)-HF","5х1,5",20,4," ",16]
["П2.3","Распределительная панель №2","Приточный вентилятор (пом.13 1этаж)",220,"ППГнг(А)-HF","3х2,5",22,9,12,1]
["П2.4","Распределительная панель №2","Приточный вентилятор (пом.7 1этаж)",220,"ППГнг(А)-HF","3х2,5",14,6,7,1]
["П2.5","Распределительная панель №2","Приточный вентилятор (пом.2 1этаж)",220,"ППГнг(А)-HF","3х2,5",15,6,8,1]
["П2.6","Распределительная панель №3","Вытяжной вентилятор саузлов накровле",220,"ППГнг(А)-HF","3х2,5",15,16,4,12]
["П2.7","Распределительная панель №4","ЯТП-0,25 электрощитовая",220,"ППГнг(А)-HF","3х2,5",3,3]
[null,"Отходящие линии ЩАП"," "," "," "," "," "," "," "," "]
["ПА1","Щит аварийного питания ЩАП","Щит аварийного освещения ЩАО-1",380,"ППГнг(А)-FRHF","5х2,5",8,8," "," "]
["ПА2","Щит аварийного питания ЩАП","Щиты аварийного освещения левый стояк (ЩАО-2,4,6,8)",380,"ППГнг(А)-FRHF","5х2,5",107,107]
["ПА3","Щит аварийного питания ЩАП","Щиты аварийного освещения правый стояк (ЩАО-3,5,7)",380,"ППГнг(А)-FRHF","5х2,5",115,115]
[null,"Отходящие линии ППУ"]
["П2.13","Панель противопожарных устройств ППУ","Насос пожарного водопровода №1 подвал",380,"ППГнг(А)-FRHF","5х4",90,74,16]
["П2.14","Панель противопожарных устройств ППУ","Насос пожарного водопровода №1 подвал",380,"ППГнг(А)-FRHF","5х4",90,74,16]
["П2.15","Панель противопожарных устройств ППУ","Автоматическая пожарная сигнализация (пост охраны (уточнить по месту)",220,"ППГнг(А)-FRHF","3х2,5",116,116]
[null,"Отходящие линии ЩР-1 (1этаж)"]
["Гр.1.1","Щит распределительный ЩР-1","Розетки пом.2",220,"ППГнг(А)-HF","3х2,5",24.015039999999999,20.015039999999999,4,null,null,20.015039999999999]
["Гр.1.2","Щит распределительный ЩР-1","Розетка пом.8",220,"ППГнг(А)-HF","3х2,5",16.8,10,6.8000000000000007,null,null,10]
["Гр.1.3","Щит распределительный ЩР-1","Розетка пом.9",220,"ППГнг(А)-HF","3х2,5",28,11,17,null,null,11]
["Гр.1.4","Щит распределительный ЩР-1","Розетки пом.12",220,"ППГнг(А)-HF","3х2,5",8.70688,2,6.70688,null,null,2]
["Гр.1.5","Щит распределительный ЩР-1","Шкаф телекоммуникационный пом.12",220,"ППГнг(А)-HF","3х2,5",5.4678399999999998,2,3.4678399999999998,null,null,2]
["Гр.1.6","Щит распределительный ЩР-1","Освещение пом. 7-11;13",220,"ППГнг(А)-HF","3х1,5",47.04,30.04,17,null,30.04]
["Гр.1.7","Щит распределительный ЩР-1","Освещение пом. 4;5;12;14",220,"ППГнг(А)-HF","3х1,5",82.88,6,{"$f":"G38-H38","v":76.88},null,16]
["Гр.1.8","Щит распределительный ЩР-1","Освещение пом. 2;3",220,"ППГнг(А)-HF","3х1,5",25.759999999999998,21.759999999999998,5,null,21.759999999999998]
["Гр.1.9","Щит распределительный ЩР-2","Освещение пом.1",220,"ППГнг(А)-HF","3х1,5",85.12,81.12,4,null,81.12]
[null,"Отходящие линии ЩР-2 (1этаж)"]
["Гр.2.1","Щит распределительный ЩР-2","Розетки пом. 38; 40 ",220,"ППГнг(А)-HF","3х2,5",26.88,{"$f":"K42+L42+2","v":8},{"$f":"G42-K42-L42-2","v":18.88},null,6]
["Гр.2.2","Щит распределительный ЩР-2","Розетки пом. 17; 26; 27 ",220,"ППГнг(А)-HF","3х2,5",36.815519999999999,{"$f":"K43+L43+2","v":28.88},{"$f":"G43-K43-L43-2","v":7.9355200000000004},null,10,16.88]
["Гр.2.3","Щит распределительный ЩР-2","Розетки пом. 35",220,"ППГнг(А)-HF","3х2,5",14.336,2,12.336]
["Гр.2.4","Щит распределительный ЩР-2","Освещение пом. 17; 19; 20; 26; 27",220,"ППГнг(А)-HF","3х1,5",61.6,58.6,3,null,10,46.6]
["Гр.2.5","Щит распределительный ЩР-2","Освещение пом.  23",220,"ППГнг(А)-HF","3х1,5",61.6,2,59.6]
["Гр.2.6","Щит распределительный ЩР-2","Освещение пом. 35; 38; 39",220,"ППГнг(А)-HF","3х1,5",91.84,76.84,15,null,74.84]
["Гр.2.7","Щит распределительный ЩР-2","Освещение пом. 40; 41",220,"ППГнг(А)-HF","3х1,5",123.2,101.2,22,null,99.2]
["Гр.2.8","Щит распределительный ЩР-2","Освещение пом. 34(коридор 1 этаж)",220,"ППГнг(А)-HF","3х1,5",128.80000000000001,6,122.80000000000001,null,4]
[null,"Отходящие линии ЩР-3 (1этаж)"]
["Гр.3.1","Щит распределительный ЩР-3"," Розетки пом.34; 41; 42",220,"ППГнг(А)-HF","3х2,5",54.024319999999996,36.024319999999996,18,null,34.024319999999996]
["Гр.3.2","Щит распределительный ЩР-3","Розетки пом.34; 44; 46 ",220,"ППГнг(А)-HF","3х2,5",27.665120000000002,19.665120000000002,8,null,17.665120000000002]
["Гр.3.3","Щит распределительный ЩР-3","Розетки пом. 28 ",220,"ППГнг(А)-HF","3х2,5",28,7,21,null,3,2]
["Гр.3.4","Щит распределительный ЩР-3","Розетки пом.36",220,"ППГнг(А)-HF","3х2,5",14.28,2,12.28]
["Гр.3.5","Щит распределительный ЩР-3","Розетки пом.22 ",220,"ППГнг(А)-HF","3х2,5",16.721599999999999,11.721599999999999,5,null,9.7215999999999987]
["Гр.3.6","Щит распределительный ЩР-3","Розетки пом.18; 22",220,"ППГнг(А)-HF","3х2,5",31.77552,11.77552,20,null,9.7755200000000002]
["Гр.3.7","Щит распределительный ЩР-3","Освещение пом.42; 43",220,"ППГнг(А)-HF","3х1,5",50.4,41.4,9,null,39.4]
["Гр.3.8","Щит распределительный ЩР-3","Освещение пом.36; 44; 45; 46",220,"ППГнг(А)-HF","3х1,5",58.24,36.24,22,null,34.24]
["Гр.3.9","Щит распределительный ЩР-3","Освещение пом.22",220,"ППГнг(А)-HF","3х1,5",44.8,6,38.799999999999997,null,4]
["Гр.3.10","Щит распределительный ЩР-3","Освещение пом.18; 21; 24; 28; 29",220,"ППГнг(А)-HF","3х1,5",58.24,12,46.24,null,10]
[null,"Отходящие линии ЩР-4(2 этаж)"]
["Гр.4.1","Щит распределительный ЩР-4","Розетки пом. 1; 3; 9 ",220,"ППГнг(А)-HF","3х2,5",55.58,55.58,null,null,12,43.58]
["Гр.4.2","Щит распределительный ЩР-4","Розетки пом.5",220,"ППГнг(А)-HF","3х2,5",15,12,3]
["Гр.4.3","Щит распределительный ЩР-4","Розетки пом. 8 ",220,"ППГнг(А)-HF","3х2,5",28.92848,28.92848,null,null,10,6.9284800000000004]
["Гр.4.4","Щит распределительный ЩР-4","Розетки пом.12; 13 ",220,"ППГнг(А)-HF","3х2,5",52.159520000000001,52.159520000000001,null,null,21,19.159520000000001]
["Гр.4.5","Щит распределительный ЩР-4","Освещение пом.4; 9",220,"ППГнг(А)-HF","3х1,5",56,56,null,null,null,56]
["Гр.4.6","Щит распределительный ЩР-4","Освещение пом.1; 2; 3; 10",220,"ППГнг(А)-HF","3х1,5",62.72,62.72,38.72,null,10,14]
["Гр.4.7","Щит распределительный ЩР-4","Освещение пом.5; 6; 7; 8",220,"ППГнг(А)-HF","3х1,5",76.16,76.16,null,null,62.16]
["Гр.4.8","Щит распределительный ЩР-4","Освещение пом.12",220,"ППГнг(А)-HF","3х1,5",44.8,44.8,null,null,36.799999999999997]
["Гр.4.9","Щит распределительный ЩР-4","Освещение пом.13",220,"ППГнг(А)-HF","3х1,5",51.519999999999996,51.519999999999996,null,null,38.519999999999996]
["Гр.4.10","Щит распределительный ЩР-4","Освещение пом.4(коридор 2эт)",220,"ППГнг(А)-HF","3х1,5",128.80000000000001,6,122.80000000000001,null,4]
[null,"Отходящие линии ЩР-5 (2 этаж)"]
["Гр.5.1","Щит распределительный ЩР-5","Розетки пом.4; 14; 15 ",220,"ППГнг(А)-HF","3х2,5",43.469439999999999,43.469439999999999,null,null,10,25.469439999999999]
["Гр.5.2","Щит распределительный ЩР-5","Розетки пом.16; 17",220,"ППГнг(А)-HF","3х2,5",32.780160000000002,32.780160000000002,null,null,12,8.7801600000000022]
["Гр.5.3","Щит распределительный ЩР-5","Розетки пом.23",220,"ППГнг(А)-HF","3х2,5",14.60816,11.60816,3]
["Гр.5.4","Щит распределительный ЩР-5","Розетки пом.4; 18; 21 ",220,"ППГнг(А)-HF","3х2,5",48.223840000000003,48.223840000000003,null,null,20]
["Гр.5.5","Щит распределительный ЩР-5","Освещение пом.14;15",220,"ППГнг(А)-HF","3х1,5",53.76,53.76,null,null,33.76]
["Гр.5.6","Щит распределительный ЩР-5","Освещение пом.16",220,"ППГнг(А)-HF","3х1,5",48.16,48.16,null,null,38.159999999999997]
["Гр.5.7","Щит распределительный ЩР-5","Освещение пом.17; 23; 24",220,"ППГнг(А)-HF","3х1,5",58.24,50.24,8,null,37.24]
["Гр.5.8","Щит распределительный ЩР-5","Освещение пом.4; 18",220,"ППГнг(А)-HF","3х1,5",53.76,53.76,null,null,47.76,6]
["Гр.5.9","Щит распределительный ЩР-5","Освещение пом.19;21;22",220,"ППГнг(А)-HF","3х1,5",51.519999999999996,29.519999999999996,22,null,23.519999999999996,6]
[null,"Отходящие линии ЩР-6 (3 этаж)"]
["Гр.6.1","Щит распределительный ЩР-6","Розетки пом.5",220,"ППГнг(А)-HF","3х2,5",14.663040000000001,2,{"$f":"G83-K83-L83-2","v":12.663040000000001}]
["Гр.6.2","Щит распределительный ЩР-6","Розетки пом. 7",220,"ППГнг(А)-HF","3х2,5",28.92848,{"$f":"K84+L84+2","v":18.92848},{"$f":"G84-K84-L84-2","v":10},null,10,6.9284800000000004]
["Гр.6.3","Щит распределительный ЩР-6","Розетки пом.12; 13 ",220,"ППГнг(А)-HF","3х2,5",53,{"$f":"K85+L85+2","v":43},{"$f":"G85-K85-L85-2","v":10},null,21,20]
["Гр.6.4","Щит распределительный ЩР-6","Розетки пом.2; 3",220,"ППГнг(А)-HF","3х2,5",43.859199999999994,44,null,null,20,23.859199999999994]
["Гр.6.5","Щит распределительный ЩР-6","Розетки пом.1; 8; 9 ",220,"ППГнг(А)-HF","3х2,5",49.498400000000004,49,null,null,20,29.498400000000004]
["Гр.6.6","Щит распределительный ЩР-6","Освещение пом.8; 9",220,"ППГнг(А)-HF","3х1,5",63.84,55.84,8,null,53.84]
["Гр.6.7","Щит распределительный ЩР-6","Освещение пом.1; 2; 3",220,"ППГнг(А)-HF","3х1,5",60.48,25,35.479999999999997,null,23]
["Гр.6.8","Щит распределительный ЩР-6","Освещение пом.5; 6; 7",220,"ППГнг(А)-HF","3х1,5",76.16,64.16,12,null,62.16]
["Гр.6.9","Щит распределительный ЩР-6","Освещение пом.12",220,"ППГнг(А)-HF","3х1,5",44.8,38.799999999999997,6,null,36.799999999999997]
["Гр.6.10","Щит распределительный ЩР-6","Освещение пом.13",220,"ППГнг(А)-HF","3х1,5",51.519999999999996,40.519999999999996,11,null,38.519999999999996]
["Гр.6.11","Щит распределительный ЩР-6","Освещение пом.4(коридор 3эт)",220,"ППГнг(А)-HF","3х1,5",128.80000000000001,6,122.80000000000001,null,4]
[null,"Отходящие линии ЩР-7 (3 этаж)"]
["Гр.7.1","Щит распределительный ЩР-7","Розетки пом.14; 15 ",220,"ППГнг(А)-HF","3х2,5",44.840319999999998,{"$f":"K95+L95+2","v":26.840319999999998},{"$f":"G95-K95-L95-2","v":18},null,11,13.840319999999998]
["Гр.7.2","Щит распределительный ЩР-7","Розетки пом.16",220,"ППГнг(А)-HF","3х2,5",29,{"$f":"K96+L96+2","v":19},{"$f":"G96-K96-L96-2","v":10},null,10,7]
["Гр.7.3","Щит распределительный ЩР-7","Розетки пом.20",220,"ППГнг(А)-HF","3х2,5",14.614879999999999,2,12.614879999999999]
["Гр.7.4","Щит распределительный ЩР-7","Розетки пом.18",220,"ППГнг(А)-HF","3х2,5",44.673439999999999,32.673439999999999,12,null,20,10.673439999999999]
["Гр.7.5","Щит распределительный ЩР-7","Освещение пом.14",220,"ППГнг(А)-HF","3х1,5",57.12,39.119999999999997,18,null,37.119999999999997]
["Гр.7.6","Щит распределительный ЩР-7","Освещение пом.15",220,"ППГнг(А)-HF","3х1,5",48.16,40.159999999999997,8,null,38.159999999999997]
["Гр.7.7","Щит распределительный ЩР-7","Освещение пом.16; 20; 21",220,"ППГнг(А)-HF","3х1,5",58.24,39.24,19,null,37.24]
["Гр.7.8","Щит распределительный ЩР-7","Освещение пом.17; 18; 22",220,"ППГнг(А)-HF","3х1,5",78.400000000000006,40.400000000000006,38,null,38.400000000000006]
[null,"Отходящие линии ЩР-8 (4 этаж)"]
["Гр.8.1","Щит распределительный ЩР-8","Розетки пом.2",220,"ППГнг(А)-HF","3х2,5",14.614879999999999,11.614879999999999,3]
["Гр.8.2","Щит распределительный ЩР-8","Розетки пом1; 7 ",220,"ППГнг(А)-HF","3х2,5",31.800160000000002,31.800160000000002,null,null,27.800160000000002,4]
["Гр.8.3","Щит распределительный ЩР-8","Розетки пом1; 10; 11 ",220,"ППГнг(А)-HF","3х2,5",23.35088,23.35088,null,null,18.35088]
["Гр.8.4","Щит распределительный ЩР-8","Розетки пом1; 11; 12; 13 ",220,"ППГнг(А)-HF","3х2,5",54.79712,54.79712,null,null,27.79712,8]
["Гр.8.5","Щит распределительный ЩР-8","Освещение пом.2; 3; 4; 5; 6; 7",220,"ППГнг(А)-HF","3х1,5",73.92,73.92,null,null,59.92]
["Гр.8.6","Щит распределительный ЩР-8","Освещение пом.10; 11; ",220,"ППГнг(А)-HF","3х1,5",47.04,47.04,null,null,34.04]
["Гр.8.7","Щит распределительный ЩР-8","Освещение пом.12,13",220,"ППГнг(А)-HF","3х1,5",47.04,47.04,null,null,32.04]
["Гр.8.8","Щит распределительный ЩР-8","Освещение пом.1(коридор 4эт)",220,"ППГнг(А)-HF","3х1,5",128.80000000000001,6,122.80000000000001,null,6]
["Гр.8.9","Щит распределительный ЩР-8","Освещение пом.9",220,"ППГнг(А)-HF","3х1,5",13.44,13.44,null,null,13.44]
["Гр.8.10","Щит распределительный ЩР-8","Освещение пом.чердак леваясторона",220,"ППГнг(А)-HF","3х1,5",50,14,36,null,2]
[null,"Отходящие линии ЩР-9 -IV (4 этаж)"]
["Гр.9.1","Щит распределительный ЩР-9","Розетки пом. 1; 14; 15 ",220,"ППГнг(А)-HF","3х2,5",51.29824,{"$f":"G115-I115","v":46.29824},5,null,33.29824]
["Гр.9.2","Щит распределительный ЩР-9"," Розетки пом. 15; 16; 17; 18 ",220,"ППГнг(А)-HF","3х2,5",35.845600000000005,{"$f":"G116-I116","v":22.845600000000005},13,null,25.845600000000005]
["Гр.9.3","Щит распределительный ЩР-9","Розетки пом. 18; 19; 20 ",220,"ППГнг(А)-HF","3х2,5",28.628319999999999,{"$f":"G117-I117","v":22.628319999999999},6,null,23.628319999999999]
["Гр.9.4","Щит распределительный ЩР-9","Розетки пом. 23 ",220,"ППГнг(А)-HF","3х2,5",24.64,{"$f":"K118+L118+2","v":20.64},12,null,18.64]
["Гр.9.5","Щит распределительный ЩР-9","Розетки пом. 24 ",220,"ППГнг(А)-HF","3х2,5",19.04,4,{"$f":"G119-H119","v":15.04},null,5.0399999999999991,12]
["Гр.9.6","Щит распределительный ЩР-9","Освещение пом. 14; 15; ",220,"ППГнг(А)-HF","3х1,5",57.12,{"$f":"G120-I120","v":52.12},5,null,37.119999999999997]
["Гр.9.7","Щит распределительный ЩР-9","Освещение пом. 16-18",220,"ППГнг(А)-HF","3х1,5",42.56,{"$f":"G121-I121","v":37.56},5,null,32.56]
["Гр.9.8","Щит распределительный ЩР-9","Освещение пом. 20;23; 24; 25; 26",220,"ППГнг(А)-HF","3х1,5",73,{"$f":"K122+L122+2","v":72.8},5,null,58.8,12]
["Гр.9.9","Щит распределительный ЩР-9","Освещение пом. 21",220,"ППГнг(А)-HF","3х1,5",14,14,0,null,13.44]
["Гр.9.10","Щит распределительный ЩР-9","Освещение чердак правая сторона",220,"ППГнг(А)-HF","3х1,5",50,4,{"$f":"G124-K124-L124-2","v":46},null,2]
[null,"Отходящие линии ЩР-10-П (подвал)"]
["Гр.10.1","Щит распределительный ЩР-10-П","Розетки пом. 1; 14; 15 ",220,"ППГнг(А)-HF","3х1,5",64.959999999999994,null,64.959999999999994]
["Гр.10.2","Щит распределительный ЩР-10-П"," Розетки пом. 15; 16; 17; 18 ",220,"ППГнг(А)-HF","3х1,5",71.680000000000007,null,71.680000000000007]
["Гр.10.3","Щит распределительный ЩР-10-П","Розетки пом. 18; 19; 20 ",220,"ППГнг(А)-HF","3х1,5",118.72,null,118.72]
["Гр.10.4","Щит распределительный ЩР-10-П","Розетки пом. 23 ",220,"ППГнг(А)-HF","3х1,5",86.24,null,86.24]
["Гр.10.5","Щит распределительный ЩР-10-П","Розетки пом. 24 ",220,"ППГнг(А)-HF","3х1,5",132.16,null,132.16]
[null,"Отходящие линии ЩАО-1 (1 этаж)"]
["Гр.1.1А","Щит аварийного освещения ЩАО-1","Авар.освещение пом.1",220,"ППГнг(А)-FRHF","3х1,5",50.4,47.4,3]
["Гр.1.2А","Щит аварийного освещения ЩАО-1","Авар.освещение пом 5;6;12;14",220,"ППГнг(А)-FRHF","3х1,5",82.88,52.879999999999995,30]
[null,"Отходящие линии ЩАО-2(1 этаж)"]
["Гр.2.1А","Щит аварийного освещения ЩАО-2","Авар. освещение пом.15; 23; 34",220,"ППГнг(А)-FRHF","3х1,5",58.24,54.24,4,null,10]
["Гр.2.2А","Щит аварийного освещения ЩАО-2"," Авар. освещение пом.30; 32; 11(2эт,); 10(3эт,); 8(4эт,) ",220,"ППГнг(А)-FRHF","3х1,5",56,8,48,null,2]
["Гр.2.3А","Щит аварийного освещения ЩАО-2"," Освещение крыльца, табло выход левая сторона",220,"ППГнг(А)-FRHF","3х1,5",47.04,8,39.04,null,2]
["Гр.2.4А","Щит аварийного освещения ЩАО-2"," Авар. освещение пом.34(коридор)",220,"ППГнг(А)-FRHF","3х1,5",96.32,6,90.32,null,6]
[null,"Отходящие линии ЩАО-3(1 этаж)"]
["Гр.3.1А","Щит аварийного освещения ЩАО-3","Табло выход, освещние крыльца правая сторона ",220,"ППГнг(А)-FRHF","3х1,5",42,10,32,null,4]
["Гр.3.2А","Щит аварийного освещения ЩАО-3","Авар. Освещение  31; 33 (1эт); 20(2эт); 19(3эт); 22(4эт)",220,"ППГнг(А)-FRHF","3х1,5",67,8,59,null,6]
["Гр.3.3А","Щит аварийного освещения ЩАО-3","Авар. Освещение 16;  улица",220,"ППГнг(А)-FRHF","3х1,5",35.840000000000003,2,25.840000000000003,null,8]
["Гр.3.4А","Щит аварийного освещения ЩАО-3","Авар. Освещение 22; 24; 25; улица",220,"ППГнг(А)-FRHF","3х1,5",56,2,46,null,8]
[null,"Отходящие линии ЩАО-4 (2 этаж)"]
["Гр.4.1А","Щит аварийного освещения ЩАО-4","Авар.освещение пом. 4; табло выход",220,"ППГнг(А)-FRHF","3х1,5",12.32,12.32,null,null,6]
["Гр.4.2А","Щит аварийного освещения ЩАО-4","Авар.освещение пом. 4(коридор 2эт)",220,"ППГнг(А)-FRHF","3х1,5",112,6,106,null,6]
[null,"Отходящие линии ЩАО-5 (2 этаж)"]
["Гр.5.1А","Щит аварийного освещения ЩАО-5","Авар.освещение пом. 4; табло выход",220,"ППГнг(А)-FRHF","3х1,5",16,16,null,null,6]
[null,"Отходящие линии ЩАО-6 (3 этаж)"]
["Гр.6.1А","Щит аварийного освещения ЩАО-6"," Авар.освещение пом.11; табло выход",220,"ППГнг(А)-FRHF","3х1,5",12.32,12.32,null,null,6]
["Гр.6.2А","Щит аварийного освещения ЩАО-6"," Авар.освещение пом. 4(коридор 3эт)",220,"ППГнг(А)-FRHF","3х1,5",112,6,106,null,6]
[null,"Отходящие линии ЩАО-7 (3 этаж)"]
["Гр.7.1А","Щит аварийного освещения ЩАО-7","  Авар.освещение пом.4; 18; табло выход",220,"ППГнг(А)-FRHF","3х1,5",40,27,13,null,2]
[null,"Отходящие линии ЩАО-8 (4 этаж)"]
["Гр.8.1А","Щит аварийного освещения ЩАО-8","Авар.совещение пом.1(коридор 4эт)",220,"ППГнг(А)-FRHF","3х1,5",112,6,106,null,6]
[null,"Линии системы уравнивания потенциалов"]
["ЛСУП","Контур системы уравнивания потенциалов электрощитовой","Коробка уравнивания потенциалов (подвал)",null,null,"1х16",60,50,10]
["ЛСУП1","Контур системы уравнивания потенциалов электрощитовой","Токопроводящие элементы водопровода",null,null,"1X2,5",10,2,8]
["ЛСУП2","Контур системы уравнивания потенциалов электрощитовой","Токопроводящие элементы водопровода",null,null,"1X2,5",10,2,8]
["ЛСУП3","Коробка уравнивания потенциалов (подвал)","Токопроводящие элементы водопровода",null,null,"1X2,5",10,null,{"$f":"G160","v":10}]
["ЛСУП4","Коробка уравнивания потенциалов (подвал)","Токопроводящие элементы водопровода",null,null,"1X2,5",10,null,{"$f":"G161","v":10}]
["ЛСУП5","Коробка уравнивания потенциалов (подвал)","Токопроводящие элементы водопровода",null,null,"1X2,5",30,null,30]
["ЛСУП6","Коробка уравнивания потенциалов (подвал)","Токопроводящие элементы водопровода",null,null,"1X2,5",12,null,12]
[null,null,null,null,null,null,{"$f":"SUM(G158:G163)","v":82}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H5:H163)","v":3659.4086400000001},{"$f":"SUM(I5:I163)","v":3470.6041599999994},{"$f":"SUM(J16:J21)","v":55},{"$f":"SUM(K3:K163)","v":1968.70688},{"$f":"SUM(L3:L163)","v":444.21248000000003}]
[]
[null,null,null,null,null,null,null,"скобы 25",{"$f":"55+I166","v":3525.6041599999994}]
[null,null,null,null,null,null,null,"дюбель",{"$f":"(I168+K166+L166)*2","v":11877.047039999999}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"I166+J166+K166+L166","v":5938.5235199999997}]

{"sheet":"ГРЩ","index":1,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,7,0,13],[0,15,0,19],[1,2,1,5],[1,7,5,7],[1,8,1,9],[1,10,1,13],[1,15,2,17],[1,18,2,19],[2,1,4,1],[2,2,4,5],[2,8,2,9],[2,10,2,13],[3,8,3,9],[3,10,3,13],[3,18,3,19],[4,8,5,9],[4,10,5,13],[4,15,7,15],[4,16,4,17],[4,18,4,19],[7,8,7,9],[7,10,7,13],[7,16,7,17],[7,18,7,19],[3,15,3,17],[5,1,6,1],[5,2,6,5],[5,16,5,17],[5,18,5,19],[6,7,10,7],[6,8,6,9],[6,10,6,13],[6,16,6,17],[6,18,6,19],[7,2,7,5],[8,2,8,5],[8,8,8,9],[8,10,8,13],[9,2,9,5],[9,8,10,9],[9,10,10,13],[9,15,9,19],[10,2,10,5],[10,18,10,19],[11,2,11,5],[11,7,15,7],[11,8,11,9],[11,10,11,13],[11,17,14,17],[11,18,11,19],[12,2,12,5],[12,8,12,9],[12,10,12,13],[12,18,12,19],[13,2,13,5],[13,8,13,9],[13,10,13,13],[13,18,13,19],[14,2,14,5],[14,8,15,9],[14,10,15,13],[14,18,14,19],[19,18,19,21],[19,0,19,1],[19,2,19,9],[19,10,20,10],[19,11,19,14],[19,15,19,17]]}
[null,"Общие данные",null,null,null,null,null,"Ввод",null,null,null,null,null,null,null,"Источник"]
[null,"Шифр проекта","РД-176.ЭОМ    ",null,null,null,null,"Рубиль ник","Наличие",null,"ДА",null,null,null,null,"Наименование",null,null,"ВРУ секция 2"]
[null,"Название проекта","Объект 1",null,null,null,null,null,"Марка",null," ВН-32-363"]
[null,null,null,null,null,null,null,null,"Номинал",null,63,null,null,null,null,"Номинал автомата",null,null,25]
[null,null,null,null,null,null,null,null,"Примечание",null,"С возможностью опломбирования",null,null,null,null,"Кабель","Марка",null,"ППГнгА-HF"]
[null,"Раздел","Силовое оборудование и электроосвещение",null,null,null,null,null,null,null,null,null,null,null,null,null,"Кол-во жил",null,5]
[null,null,null,null,null,null,null,"Автомат","Наличие",null,"НЕТ",null,null,null,null,null,"Сечение",null,4]
[null,"Название щита","ЩС-1-I",null,null,null,null,null,"Марка",null,{"$f":"model","v":{"$error":"#REF!"}},null,null,null,null,null,"Длина м",null,20]
[null,"Стадия","РД",null,null,null,null,null,"Номинал",null,{"$f":"I_nom","v":{"$error":"#REF!"}}]
[null,"Номер листа",1,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,"L1",{"$f":"SUMIF(L24:L457,\"L1\",J24:J457)","v":0},{"$f":"(Q12+Q13+Q14)/3+Q15","v":{"$error":"#REF!"}},{"$f":"((Q12+Q15)-R12)/R12","v":{"$error":"#REF!"}}]
[null,"Утвердил","Потапов",null,null,null,null,null,"Марка",null,"Меркурий 236 ART",null,null,null,null,"L2",{"$f":"SUMIF(L24:L457,\"L2\",J24:J457)","v":0},null,{"$f":"((Q13+Q15)-R12)/R12","v":{"$error":"#REF!"}}]
[null,"Дата","09.05",null,null,null,null,null,"Номинал",null,"380/220В 5/60A",null,null,null,null,"L3",{"$f":"SUMIF(L24:L457,\"L3\",J24:J457)","v":0},null,{"$f":"((Q14+Q15)-R12)/R12","v":{"$error":"#REF!"}}]
[null,"Кабель для групп","ППГнгА-HF",null,null,null,null,null,"Примечание",null,"Счетчик запрограммировать в однотарифный режим",null,null,null,null,"L1L2L3",{"$f":"SUMIF(L24:L457,\"L1L2L3\",J24:J457)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
["Потребитель",null,"Расчетная нагрузка",null,null,null,null,null,null,null,"Тип потребителя","Автомат",null,null,null,"УЗО",null,null,"Кабель"]
["Номер группы","Наименование","P уст., кВт","Коэф-т спроса","cos φ","tg φ","Р акт., кВт","Q, кВАр","S, кВА","I расч.,  А",null,"Фаза","Номинал","Модель","Тип","Номинал","Ток утечки","Модель","Длина падения м","Сечение","Падение напр. %","Длина общая м"]
[]
[null,"Итого на щит",{"$f":"SUM(C24:C37)","v":{"$error":"#REF!"}},0.63,{"$f":"COS(ATAN(F23))","v":{"$error":"#REF!"}},{"$f":"SUM(H24:H457)/SUM(G24:G457)","v":{"$error":"#REF!"}},{"$f":"C23*D23","v":{"$error":"#REF!"}},{"$f":"F23*G23","v":{"$error":"#REF!"}},{"$f":"SQRT(G23^2+H23^2)","v":{"$error":"#REF!"}},{"$f":"IF(L23=\"L1L2L3\",I23/0.66,I23/0.22)","v":{"$error":"#REF!"}},null,"L1L2L3",100,"ВН-32-363 "]
["П1","ЩР-1-I",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"TAN(ACOS(E24))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"К","L1L2L3",25,"ВМ63-3В25 ","АВТ",null,null,null,8,4,{"$f":"IF(L24=\"L1L2L3\",0.0125*G24*S24/T24,0.0756*G24*S24/T24)","v":{"$error":"#REF!"}},8]
["П2","ЩР-2-I",4.76,0.75,0.9,{"$f":"TAN(ACOS(E25))","v":0.48432210483785254},3.57,1.7290299142711334,3.9666666666666663,6.0101010101010095,"К","L1L2L3",25,"ВМ63-3В25 ","АВТ",null,null,null,60,4,0.66937499999999994,60]
["П3","ЩР-3-I",4.76,0.75,0.9,{"$f":"TAN(ACOS(E26))","v":0.48432210483785254},3.57,1.7290299142711334,3.9666666666666663,6.0101010101010095,"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,98,4,1.0933124999999999,98]
["П4","ЩР-4-II",5.76,0.79,0.9,{"$f":"TAN(ACOS(E27))","v":0.48432210483785254},4.5503999999999998,2.2038593058541642,5.056,7.6606060606060602,"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,64,4,0.91008,64]
["П5","ЩР-5-II",4.9800000000000004,0.81,0.9,{"$f":"TAN(ACOS(E28))","v":0.48432210483785254},4.0338000000000003,1.9536585064949297,4.4820000000000002,6.790909090909091,"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,104,4,1.3109850000000003,104]
["П6","ЩР-6-III",6.54,0.82,0.91,0.45561346025555771,5.3628,2.443363864658505,5.893186813186813,8.929070929070928,"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,68,4,1.1395949999999999,68]
["П7","ЩР-7-III",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,108,4,{"$error":"#REF!"},108]
["П8","ЩР-8-IV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,72,4,{"$error":"#REF!"},72]
["П9","ЩР-9-IV",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"К","L1L2L3",25,"ВМ63-3В25","АВТ",null,null,null,112,4,{"$error":"#REF!"},112]
["П10","ЩР-10-П",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},"К","L1L2L3",63,"ВМ63-3С63","АВТ",null,null,null,70,2.5,{"$error":"#REF!"},70]
["П11",null,null,1,0.95,0.32868410517886321,0,0,0,0,"К","L1L2L3",13,"ВМ63-1B16","АВТ",null,null,null,null,1.5,0]
["П12",null,null,1,0.95,{"$f":"TAN(ACOS(E35))","v":0.32868410517886321},0,0,0,0,"К","L1L2L3",14,"ВМ63-1B16","АВТ",null,null,null,null,1.5,0]
["П13",null,0.25,1,0.95,{"$f":"TAN(ACOS(E36))","v":0.32868410517886321},0.25,8.2171026294715802E-2,0.26315789473684209,0.3987240829346092,"К","L1L2L3",15,"ВМ63-1B16","АВТ",null,null,null,3,1.5,6.2500000000000012E-3,3]
[]
["резерв"]
["резерв"]
[]
[]
[]
[null,"Ру ав.осв.",{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},1,null,null,null,null,null,null,"5Х4","5Х2,5","3Х2,5","3Х1,5",null,null,null,null,2.5,1.5]
[null,"Pу р.осв.",{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},0.9,null,null,null,null,null,null,{"$f":"SUM(S24:S32)","v":694},{"$f":"SUM(T33)","v":2.5},70,50,null,null,null,null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,"Ру. роз.",{"$f":"SUM(C24:C36)-30-C44-C43","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,{"$f":"K44+180","v":874},null,{"$f":"M49","v":{"$error":"#REF!"}},4450]
[null,"Ру. Сил.об",30,null,null,null,null,null,null,null,null,null,116,{"$f":"N45+N44","v":4500},null,null,null,null,null,{"$f":"T44-4450","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M44+M45+M46","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Param","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["L1","АВТ","Р","ДА"]
["L2","ДИФ","Л","НЕТ"]
["L3","УЗО","К"]
["L1L2L3"]

{"sheet":"Лист3","index":3,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Группа","потребитель","КОЛ-ВО","МОЩНОСТЬ","Мощность ед."]
["1.1","свет",2,{"$f":"C2*E2","v":7.0000000000000007E-2},3.5000000000000003E-2]
["1.1","свет",3,{"$f":"C3*E3","v":0.10500000000000001},3.5000000000000003E-2,null,"Группа","потребитель","Сумма по полю КОЛ-ВО","Сумма по полю МОЩНОСТЬ"]
["1.3","свет",4,0.14000000000000001,3.5000000000000003E-2,null,"1.1","свет",5,0.17500000000000002]
["1.4","свет",1,0.08,0.08,null,"1.10","розетки",3,0.18]
["1.5","розетки",3,0.18,0.06,null,"1.11","холодильник",5,0.2]
["1.5","розетки",4,0.14000000000000001,3.5000000000000003E-2,null,"1.3","свет",4,0.14000000000000001]
["1.6","розетки",5,0.4,0.08,null,"1.4","свет",1,0.08]
["1.8","холодильник",1,3.5000000000000003E-2,3.5000000000000003E-2,null,"1.5","розетки",7,0.32]
["1.9","холодильник",2,0.02,0.01,null,"1.6","розетки",5,0.4]
["1.10","розетки",3,0.18,0.06,null,"1.8","холодильник",1,3.5000000000000003E-2]
["1.11","холодильник",4,0.14000000000000001,3.5000000000000003E-2,null,"1.9","холодильник",2,0.02]
["1.11","холодильник",1,0.06,0.06,null,"Общий итог",null,33,1.55]
[]
[]
[]
[null,"потребитель","КОЛ-ВО","МОЩНОСТЬ"]
["1.1",null,5,0.17500000000000002]
["1.3",null,4,0.14000000000000001]
["1.4",null,1,0.08]
["1.5",null,7,0.32]
["1.6",null,5,0.4]
["1.8",null,1,3.5000000000000003E-2]
["1.9",null,2,0.02]
["1.10",null,3,0.18]
["1.11",null,5,0.2]