{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Щит","Param"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,16,4,17],[4,18,4,19],[5,16,5,17],[19,0,19,1],[19,10,20,10],[2,1,4,1],[5,1,6,1],[7,2,7,5],[8,2,8,5],[1,7,5,7],[1,8,1,9],[1,10,1,13],[2,8,2,9],[2,10,2,13],[3,8,3,9],[3,10,3,13],[0,1,0,5],[0,7,0,13],[4,15,7,15],[14,2,14,5],[19,18,19,21],[19,11,19,14],[19,15,19,17],[19,2,19,9],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[2,2,4,5],[1,2,1,5],[5,2,6,5],[4,8,5,9],[4,10,5,13],[6,7,10,7],[6,8,6,9],[6,10,6,13],[7,8,7,9],[7,10,7,13],[8,8,8,9],[8,10,8,13],[9,8,10,9],[9,10,10,13],[11,7,15,7],[11,8,11,9],[11,10,11,13],[12,8,12,9],[12,10,12,13],[13,8,13,9],[13,10,13,13],[14,8,15,9],[14,10,15,13],[0,15,0,19],[1,15,2,17],[1,18,2,19],[3,15,3,17],[3,18,3,19],[5,18,5,19],[6,16,6,17],[6,18,6,19],[7,16,7,17],[7,18,7,19],[9,15,9,19],[14,18,14,19],[10,18,10,19],[11,18,11,19],[12,18,12,19],[13,18,13,19],[11,17,14,17]]}
[null,"Общие данные",null,null,null,null,null,"Ввод",null,null,null,null,null,null,null,"Источник"]
[null,"Шифр проекта","01-02.ЭМ    ",null,null,null,null,"Рубиль ник","Наличие",null,"ДА",null,null,null,null,"Наименование",null,null,"ВРУ секция 2"]
[null,"Название проекта","  Реконструкция помещения по адресу: г. Санкт- Петербург, Смольный, каб. 101  ",null,null,null,null,null,"Марка",null," ВН-32 3Р"]
[null,null,null,null,null,null,null,null,"Номинал",null,40,null,null,null,null,"Номинал автомата",null,null,40]
[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,4]
[null,null,null,null,null,null,null,"Автомат","Наличие",null,"ДА",null,null,null,null,null,"Сечение",null,6]
[null,"Название щита","ЩС1",null,null,null,null,null,"Марка",null,{"$f":"model","v":"ВА47-29 3Р"},null,null,null,null,null,"Длина м",null,20]
[null,"Стадия","Р",null,null,null,null,null,"Номинал",null,{"$f":"I_nom","v":20}]
[null,"Номер листа",2,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:L451,\"L1\",J24:J451)","v":5.6818181818181808},{"$f":"(Q12+Q13+Q14)/3+Q15","v":14.046717171717173},{"$f":"((Q12+Q15)-R12)/R12","v":-3.3707865168539519E-2}]
[null,"Утвердил","Козлов",null,null,null,null,null,"Марка",null,"Меркурий 236 ART",null,null,null,null,"L2",{"$f":"SUMIF(L24:L451,\"L2\",J24:J451)","v":5.6818181818181817},null,{"$f":"((Q13+Q15)-R12)/R12","v":-3.3707865168539394E-2}]
[null,"Дата","02.18",null,null,null,null,null,"Номинал",null,"380/220В 5/60A",null,null,null,null,"L3",{"$f":"SUMIF(L24:L451,\"L3\",J24:J451)","v":7.1022727272727284},null,{"$f":"((Q14+Q15)-R12)/R12","v":6.7415730337078664E-2}]
[null,"Кабель для групп","NYM",null,null,null,null,null,"Примечание",null,"Счетчик запрограммировать в однотарифный режим",null,null,null,null,"L1L2L3",{"$f":"SUMIF(L24:L451,\"L1L2L3\",J24:J451)","v":7.8914141414141419}]
[]
[]
[]
[]
["Потребитель",null,"Расчетная нагрузка",null,null,null,null,null,null,null,"Тип потребителя","Автомат",null,null,null,"УЗО",null,null,"Кабель"]
["Номер группы","Наименование","P уст., кВт","Коэф-т спроса","cos φ","tg φ","Р акт., кВт","Q, кВАр","S, кВА","I расч.,  А",null,"Фаза","Номинал","Модель","Тип","Номинал","Ток утечки","Модель","Длина падения м","Сечение","Падение напр. %","Длина общая м"]
[]
[null,"Итого на щит",{"$f":"SUM(C24:C448)","v":8.6999999999999993},0.9,{"$f":"COS(ATAN(F23))","v":0.94551244991280259},{"$f":"SUM(H24:H451)/SUM(G24:G451)","v":0.34434865900383155},{"$f":"C23*D23","v":7.8299999999999992},{"$f":"F23*G23","v":2.6962500000000009},{"$f":"SQRT(G23^2+H23^2)","v":8.2812235848635307},{"$f":"IF(L23=\"L1L2L3\",I23/0.66,I23/0.22)","v":12.54730846191444},null,"L1L2L3",20,"ВА47-29 3Р"]
["Гр.1","Бойлер",5,1,0.96,{"$f":"TAN(ACOS(E24))","v":0.29166666666666685},{"$f":"C24*D24","v":5},{"$f":"F24*G24","v":1.4583333333333344},{"$f":"SQRT(G24^2+H24^2)","v":5.2083333333333339},{"$f":"IF(L24=\"L1L2L3\",I24/0.66,I24/0.22)","v":7.8914141414141419},"К","L1L2L3",16,"ВА47-29 3Р","АВТ",null,null,null,6,2.5,{"$f":"IF(L24=\"L1L2L3\",0.0125*G24*S24/T24,0.0756*G24*S24/T24)","v":0.15},20]
["Гр.2","Освещение пом. 2, 3, 4, 5",1,1,0.8,{"$f":"TAN(ACOS(E25))","v":0.74999999999999978},{"$f":"C25*D25","v":1},{"$f":"F25*G25","v":0.74999999999999978},{"$f":"SQRT(G25^2+H25^2)","v":1.2499999999999998},{"$f":"IF(L25=\"L1L2L3\",I25/0.66,I25/0.22)","v":5.6818181818181808},"Л","L1",16,"ВА47-29 1Р","АВТ",null,null,null,10,1.5,{"$f":"IF(L25=\"L1L2L3\",0.0125*G25*S25/T25,0.0756*G25*S25/T25)","v":0.504},20]
["Гр.3","Розетки  пом. 21, 22, 23, 24, 25, 33, 37, 39, 41, 44",1.2,1,0.96,0.29166666666666685,{"$f":"C26*D26","v":1.2},{"$f":"F26*G26","v":0.3500000000000002},{"$f":"SQRT(G26^2+H26^2)","v":1.25},{"$f":"IF(L26=\"L1L2L3\",I26/0.66,I26/0.22)","v":5.6818181818181817},"Р","L2",16,"ВА47-29 1Р","УЗО",16,30,"ВД1-63 2P",20,2.5,{"$f":"IF(L26=\"L1L2L3\",0.0125*G26*S26/T26,0.0756*G26*S26/T26)","v":0.72575999999999996},20]
["Гр.4","Оборудование  каб. 100-105",1.5,1,0.96,{"$f":"TAN(ACOS(E27))","v":0.29166666666666685},{"$f":"C27*D27","v":1.5},{"$f":"F27*G27","v":0.43750000000000028},{"$f":"SQRT(G27^2+H27^2)","v":1.5625000000000002},7.1022727272727284,"Р","L3",16,"АД12 2Р","ДИФ",null,null,null,20,2.5,{"$f":"IF(L27=\"L1L2L3\",0.0125*G27*S27/T27,0.0756*G27*S27/T27)","v":0.9071999999999999},20]
["Гр.5","Резерв",null,null,null,null,{"$f":"C28*D28","v":0},{"$f":"F28*G28","v":0},{"$f":"SQRT(G28^2+H28^2)","v":0},{"$f":"IF(L28=\"L1L2L3\",I28/0.66,I28/0.22)","v":0},"Р","L1",16,"ВА47-29 1Р","АВТ",null,null,null,null,null,{"$f":"IF(L28=\"L1L2L3\",0.0125*G28*S28/T28,0.0756*G28*S28/T28)","v":{"$error":"#DIV/0!"}},20]

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