{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Распределительная сеть"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":46,"n_cols":46,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,10,45,12],[45,13,45,15],[45,17,45,19],[45,20,45,22],[45,23,45,25],[16,10,16,12],[16,13,16,15],[16,17,16,19],[16,20,16,22],[16,23,16,25],[41,10,41,12],[41,13,41,15],[41,17,41,19],[41,20,41,22],[41,23,41,25],[1,41,2,41],[1,42,2,42],[1,43,2,43],[1,44,2,44],[1,45,2,45],[0,40,0,42],[0,43,0,45],[1,10,1,12],[1,13,1,15],[1,17,1,19],[1,20,1,22],[1,23,1,25],[1,31,2,31],[1,32,2,32],[1,33,2,33],[0,30,2,30],[0,31,0,35],[0,36,2,36],[0,37,2,37],[0,38,2,38],[0,39,2,39],[1,34,1,35],[0,20,0,22],[0,28,2,28],[0,29,2,29],[0,7,2,7],[0,8,1,9],[0,10,0,12],[0,13,0,15],[0,16,2,16],[0,17,0,19],[1,40,2,40],[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,23,0,25],[0,26,2,26],[0,27,2,27]]}
["Наин. щита",null,"Наименование ЭП, групп ЭП, узлов питания","Кол-во эл. прием.","Ру одного","Ру","Фазность","Коэф. использ., Ки","Коэф. Реактивной",null,"Ру.пр.",null,null,"Qу.пр.",null,null,"Iу.пр.","Рр.пр.",null,null,"Qр.пр.",null,null,"Iу",null,null,"Iр.пр.",null,"nэ","Кр","Рр с учетом Кр","Аппараты защиты",null,null,null,null,"Sмм кв по меди 3х\"-\"","Sмм кв по меди 5х\"-\"","Кол-во модулей","Марка щита","МЩ1",null,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,"вводной, Iн/Iу","3Ф Iн/Iу","1Ф Iн/Iу","УЗО",null,null,null,null,null,"Ру","Рр","Iр","Ру","Рр","Iр"]
[null,null,null,null,null,null,null,null,"cos φ","tg φ","А","В","С","А","В","С",null,"А","В","С","А","В","С","А","В","С",null,null,null,null,null,null,null,null,"3Ф Iн/Iу","1Ф Iн/Iу"]
["ЩР1.1",null,"Облучатель бактерицидный настенный рециркуляционный",2,0.14000000000000001,{"$f":"E4*D4","v":0.28000000000000003},220,1,0.95,{"$f":"IF(I4=0,\" \",IF(I4=1,\"-\",TAN(ACOS(I4))))","v":0.32868410517886321},null,null,{"$f":"F4","v":0.28000000000000003},null,{"$f":"IF(L4=0,\" \",$F4*$J4)","v":" "},9.2031549450081712E-2,{"$f":"IF($I4=0,\" \",IF($G4=220,$F4/(0.22*$I4),$F4/(0.38*$I4*3^0.5)))","v":1.3397129186602872},{"$f":"IF(K4=0,\" \",$F4*$H4)","v":" "}," ",0.28000000000000003,{"$f":"IF(K4=0,\" \",$J4*$F4*$H4)","v":" "}," ",9.2031549450081712E-2,{"$f":"IF(K4=0,0,K4/(0.22*I4))","v":0},{"$f":"IF(L4=0,0,L4/(0.22*I4))","v":0},{"$f":"IF(M4=0,0,M4/(0.22*I4))","v":1.3397129186602872},null,{"$f":"F4^2","v":7.8400000000000011E-2},null,null,null,null,{"$f":"IF(G4=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G4=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G4=220,VLOOKUP(AH4,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G4=380,VLOOKUP(AG4,#REF!,2),\" \")","v":" "},{"$f":"IF(AG4=0,IF(AG4<101,\"СТАЦ.\",3),IF(AH4>101,\"СТАЦ.\",1))","v":{"$error":"#REF!"}}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,{"$f":"F5","v":2},null,null,{"$f":"IF(K5=0,\" \",$F5*$J5)","v":0.65736821035772641}," "," ",9.5693779904306222,0.3," "," ",9.8605231553658954E-2," "," ",9.5693779904306222,0,0,null,4,null,null,null,null,{"$f":"IF(G5=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G5=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G5=220,VLOOKUP(AH5,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G5=380,VLOOKUP(AG5,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null,{"$f":"IF(K6=0,\" \",$F6*$J6)","v":" "},0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G6=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G6=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G6=220,VLOOKUP(AH6,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G6=380,VLOOKUP(AG6,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,null,2," "," ",0.65736821035772641,9.5693779904306222," "," ",0.3," "," ",9.8605231553658954E-2,0,0,9.5693779904306222,null,4,null,null,null,null,{"$f":"IF(G7=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G7=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G7=220,VLOOKUP(AH7,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G7=380,VLOOKUP(AG7,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,{"$f":"F8","v":2},null,null,0.65736821035772641," "," ",9.5693779904306222,0.3," "," ",9.8605231553658954E-2," "," ",9.5693779904306222,0,0,null,4,null,null,null,null,{"$f":"IF(G8=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G8=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G8=220,VLOOKUP(AH8,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G8=380,VLOOKUP(AG8,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G9=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G9=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G9=220,VLOOKUP(AH9,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G9=380,VLOOKUP(AG9,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,null,2," "," ",0.65736821035772641,9.5693779904306222," "," ",0.3," "," ",9.8605231553658954E-2,0,0,9.5693779904306222,null,4,null,null,null,null,{"$f":"IF(G10=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G10=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G10=220,VLOOKUP(AH10,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G10=380,VLOOKUP(AG10,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,{"$f":"F11","v":2},null,null,0.65736821035772641," "," ",9.5693779904306222,0.3," "," ",9.8605231553658954E-2," "," ",9.5693779904306222,0,0,null,4,null,null,null,null,{"$f":"IF(G11=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G11=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G11=220,VLOOKUP(AH11,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G11=380,VLOOKUP(AG11,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G12=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G12=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G12=220,VLOOKUP(AH12,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G12=380,VLOOKUP(AG12,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,null,2," "," ",0.65736821035772641,9.5693779904306222," "," ",0.3," "," ",9.8605231553658954E-2,0,0,9.5693779904306222,null,4,null,null,null,null,{"$f":"IF(G13=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G13=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G13=220,VLOOKUP(AH13,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G13=380,VLOOKUP(AG13,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,2,null,null,0.65736821035772641," "," ",9.5693779904306222,0.3," "," ",9.8605231553658954E-2," "," ",9.5693779904306222,0,0,null,4,null,null,null,null,{"$f":"IF(G14=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G14=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G14=220,VLOOKUP(AH14,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G14=380,VLOOKUP(AG14,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G15=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G15=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G15=220,VLOOKUP(AH15,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G15=380,VLOOKUP(AG15,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K15)","v":8},8,6.28,2.6294728414309056,2.6294728414309056,2.0641361805232608,null,{"$f":"SUM(R4:R15)","v":1.2},1.2,1.1800000000000002,0.39442092621463581,0.39442092621463581,0.38784724411105859,{"$f":"mmax(X4:X15)","v":28.708133971291865},{"$f":"mmax(Y4:Y15)","v":28.708133971291865},{"$f":"mmax(Z4:Z15)","v":28.708133971291865}]
[null,null,null,{"$f":"SUM(D4:D15)","v":13},null,{"$f":"SUM(F4:F15)","v":22.28},380,{"$f":"R17/K17","v":0.15},{"$f":"COS(ATAN(J17))","v":0.95},{"$f":"U17/R17","v":0.32868410517886321},{"$f":"MAX(SUM(K4:K15),SUM(L4:L15),SUM(M4:M15))*3","v":24},null,null,{"$f":"MAX(SUM(N4:N15),SUM(O4:O15),SUM(P4:P15))*3","v":7.8884185242927174},null,null,{"$f":"IF($F17=0,\" \",IF($G17=220,$K17/(0.22*COS(ATAN(N17/K17))),$K17/(0.38*COS(ATAN(N17/K17))*3^0.5)))","v":38.38339739764826},{"$f":"MAX(SUM(R4:R15),SUM(S4:S15),SUM(T4:T15))*3","v":3.5999999999999996},null,null,{"$f":"MAX(SUM(U4:U15),SUM(V4:V15),SUM(W4:W15))*3","v":1.1832627786439074},null,null,{"$f":"MAX(X16,Y16,Z16)","v":28.708133971291865},null,null,{"$f":"IF($F17=0,\" \",IF($G17=220,$R17/(0.22*COS(ATAN(U17/R17))),$R17/(0.38*COS(ATAN(U17/R17))*3^0.5)))","v":5.7575096096472382},{"$f":"SUM(AB4:AB15)","v":44.078400000000002},{"$f":"F17^2/AB17","v":11.261715488765473},{"$f":"VLOOKUP(FLOOR(AC17,1),#REF!,IF(H17>0.75,10,IF(H17>0.65,9,IF(H17>0.55,8,IF(H17>0.45,7,IF(H17>0.35,6,IF(H17>0.25,5,IF(H17>0.175,4,3))))))))","v":{"$error":"#REF!"}},{"$f":"AD17*#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(G17=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G17=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},null,null,{"$f":"IF(G17=220,VLOOKUP(AH17,#REF!,2),\" \")","v":" "},{"$f":"IF(G17=380,VLOOKUP(AG17,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)+3","v":{"$error":"#REF!"}},{"$f":"IF(F17=0,\" \",IF(AM17+5<9,\"ЩРн-9з-3 38 УХЛ3\",IF(AM17+5<12,\"ЩРн-12з-3 38 УХЛ3\",IF(AM17+5<18,\"ЩРн-18з-3 38 УХЛ3\",IF(AM17+5<24,\"ЩРн-24з-3 38 УХЛ3\",IF(AM17+5<36,\"ЩРн-36з-3 38 УХЛ3\",IF(AM17+5<48,\"ЩРн-48з-3 38 УХЛ3\",IF(AM17+5<54,\"ЩРн-54з-3 38 УХЛ3\",\"ЩРн-72з-3 38 УХЛ3\"))))))))","v":{"$error":"#REF!"}}]
[]
["ЩР1.2",null,"Холодильник бытовой",1,0.18,{"$f":"E19*D19","v":0.18},220,1,0.65,{"$f":"IF(I19=0,\" \",IF(I19=1,\"-\",TAN(ACOS(I19))))","v":1.1691295502746664},null,null,{"$f":"F19","v":0.18},{"$f":"IF(K19=0,\" \",$F19*$J19)","v":" "},{"$f":"IF(L19=0,\" \",$F19*$J19)","v":" "},0.21044331904943994,1.2587412587412585,{"$f":"IF(K19=0,\" \",$F19*$H19)","v":" "},{"$f":"IF(L19=0,\" \",$F19*$H19)","v":" "},0.18,{"$f":"IF(K19=0,\" \",$J19*$F19*$H19)","v":" "},{"$f":"IF(L19=0,\" \",$J19*$F19*$H19)","v":" "},0.21044331904943994,{"$f":"IF(K19=0,0,K19/(0.22*I19))","v":0},{"$f":"IF(L19=0,0,L19/(0.22*I19))","v":0},{"$f":"IF(M19=0,0,M19/(0.22*I19))","v":1.2587412587412585},null,{"$f":"F19^2","v":3.2399999999999998E-2},null,null,null,null,{"$f":"IF(G19=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G19=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G19=220,VLOOKUP(AH19,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G19=380,VLOOKUP(AG19,#REF!,2),\" \")","v":" "},{"$f":"IF(AG19=0,IF(AG19<101,\"СТАЦ.\",3),IF(AH19>101,\"СТАЦ.\",1))","v":{"$error":"#REF!"}}]
["23",null,"Холодильник бытовой",1,0.18,0.18,220,1,0.65,1.1691295502746664,null,null,{"$f":"F20","v":0.18},{"$f":"IF(K20=0,\" \",$F20*$J20)","v":" "}," ",0.21044331904943994,1.2587412587412585,{"$f":"IF(K20=0,\" \",$F20*$H20)","v":" "}," ",0.18,{"$f":"IF(K20=0,\" \",$J20*$F20*$H20)","v":" "}," ",0.21044331904943994,0,0,1.2587412587412585,null,3.2399999999999998E-2,null,null,null,null,{"$f":"IF(G20=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G20=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G20=220,VLOOKUP(AH20,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G20=380,VLOOKUP(AG20,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["35",null,"Судномоечная машина",1,6.3,6.3,380,0.7,0.98,0.20305866063400418,{"$f":"$F21/3","v":2.1},2.1,2.1,{"$f":"IF(K21=0,\" \",IF($I21=1,#REF!,$K21*$J21))","v":0.42642318733140883},{"$f":"IF(L21=0,\" \",IF($I21=1,#REF!,$L21*$J21))","v":0.42642318733140883},{"$f":"IF(M21=0,\" \",IF($I21=1,#REF!,$M21*$J21))","v":0.42642318733140883},9.7672038020801359,{"$f":"IF(K21=0,\" \",($F21*$H21)/3)","v":1.4699999999999998},1.4699999999999998,1.4699999999999998,{"$f":"IF(K21=0,\" \",IF($I21=1,#REF!,$J21*$K21*$H21))","v":0.29849623113198614},{"$f":"IF(L21=0,\" \",IF($I21=1,#REF!,$J21*$L21*$H21))","v":0.29849623113198614},{"$f":"IF(M21=0,\" \",IF($I21=1,#REF!,$J21*$M21*$H21))","v":0.29849623113198614},9.7402597402597415,9.7402597402597415,9.7402597402597415]
["35",null,"Судномоечная машина",1,6.3,6.3,380,0.7,0.98,0.20305866063400418,2.1,2.1,2.1,{"$f":"IF(K22=0,\" \",IF($I22=1,#REF!,$K22*$J22))","v":0.42642318733140883},{"$f":"IF(L22=0,\" \",IF($I22=1,#REF!,$L22*$J22))","v":0.42642318733140883},{"$f":"IF(M22=0,\" \",IF($I22=1,#REF!,$M22*$J22))","v":0.42642318733140883},9.7672038020801359,1.4699999999999998,1.4699999999999998,1.4699999999999998,{"$f":"IF(K22=0,\" \",IF($I22=1,#REF!,$J22*$K22*$H22))","v":0.29849623113198614},{"$f":"IF(L22=0,\" \",IF($I22=1,#REF!,$J22*$L22*$H22))","v":0.29849623113198614},{"$f":"IF(M22=0,\" \",IF($I22=1,#REF!,$J22*$M22*$H22))","v":0.29849623113198614},9.7402597402597415,9.7402597402597415,9.7402597402597415]
["58",null,"Посудомоечная машина",1,6.8,6.8,380,0.7,0.98,0.20305866063400418,2.2666666666666666,2.2666666666666666,2.2666666666666666,{"$f":"IF(K23=0,\" \",IF($I23=1,#REF!,$K23*$J23))","v":0.46026629743707614},{"$f":"IF(L23=0,\" \",IF($I23=1,#REF!,$L23*$J23))","v":0.46026629743707614},{"$f":"IF(M23=0,\" \",IF($I23=1,#REF!,$M23*$J23))","v":0.46026629743707614},10.54237870700713,1.5866666666666667,1.5866666666666667,1.5866666666666667,{"$f":"IF(K23=0,\" \",IF($I23=1,#REF!,$J23*$K23*$H23))","v":0.32218640820595329},{"$f":"IF(L23=0,\" \",IF($I23=1,#REF!,$J23*$L23*$H23))","v":0.32218640820595329},{"$f":"IF(M23=0,\" \",IF($I23=1,#REF!,$J23*$M23*$H23))","v":0.32218640820595329},10.513296227581943,10.513296227581943,10.513296227581943]
["34",null,"Облучатель бактерицидный настенный рециркуляционный",2,0.14000000000000001,0.28000000000000003,220,0.6,0.95,0.32868410517886321,{"$f":"F24","v":0.28000000000000003},null,null,{"$f":"IF(K24=0,\" \",$F24*$J24)","v":9.2031549450081712E-2}," "," ",1.3397129186602872,{"$f":"IF(K24=0,\" \",$F24*$H24)","v":0.16800000000000001}," "," ",{"$f":"IF(K24=0,\" \",$J24*$F24*$H24)","v":5.5218929670049023E-2}," "," ",1.3397129186602872,0,0,null,{"$f":"F24^2","v":7.8400000000000011E-2},null,null,null,null,{"$f":"IF(G24=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G24=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G24=220,VLOOKUP(AH24,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G24=380,VLOOKUP(AG24,#REF!,2),\" \")","v":" "},{"$f":"IF(AG24=0,IF(AG24<101,\"СТАЦ.\",3),IF(AH24>101,\"СТАЦ.\",1))","v":{"$error":"#REF!"}}]
["34",null,"Облучатель бактерицидный настенный рециркуляционный",1,0.14000000000000001,0.14000000000000001,220,0.6,0.95,0.32868410517886321,{"$f":"F25","v":0.14000000000000001},null,null,4.6015774725040856E-2," "," ",0.66985645933014359,8.4000000000000005E-2," "," ",2.7609464835024512E-2," "," ",0.66985645933014359,0,0,null,1.9600000000000003E-2,null,null,null,null,{"$f":"IF(G25=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G25=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G25=220,VLOOKUP(AH25,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G25=380,VLOOKUP(AG25,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["44",null,"Облучатель бактерицидный настенный рециркуляционный",1,0.02,0.02,220,0.6,0.95,0.32868410517886321,null,0.02,null,{"$f":"IF(K26=0,\" \",$F26*$J26)","v":" "},{"$f":"IF(L26=0,\" \",$F26*$J26)","v":6.5736821035772639E-3}," ",9.569377990430622E-2,{"$f":"IF(K26=0,\" \",$F26*$H26)","v":" "},{"$f":"IF(L26=0,\" \",$F26*$H26)","v":1.2E-2}," ",{"$f":"IF(K26=0,\" \",$J26*$F26*$H26)","v":" "},{"$f":"IF(L26=0,\" \",$J26*$F26*$H26)","v":3.9442092621463582E-3}," ",0,9.569377990430622E-2,0,null,4.0000000000000002E-4,null,null,null,null,{"$f":"IF(G26=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G26=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G26=220,VLOOKUP(AH26,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G26=380,VLOOKUP(AG26,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["34",null,"Облучатель бактерицидный настенный рециркуляционный",3,0.14000000000000001,0.42000000000000004,220,0.6,0.95,0.32868410517886321,null,0.42,null,{"$f":"IF(K27=0,\" \",$F27*$J27)","v":" "},{"$f":"IF(L27=0,\" \",$F27*$J27)","v":0.13804732417512255}," ",2.0095693779904309,{"$f":"IF(K27=0,\" \",$F27*$H27)","v":" "},{"$f":"IF(L27=0,\" \",$F27*$H27)","v":0.252}," ",{"$f":"IF(K27=0,\" \",$J27*$F27*$H27)","v":" "},{"$f":"IF(L27=0,\" \",$J27*$F27*$H27)","v":8.2828394505073524E-2}," ",0,2.0095693779904304,0,null,0.17640000000000003,null,null,null,null,{"$f":"IF(G27=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G27=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G27=220,VLOOKUP(AH27,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G27=380,VLOOKUP(AG27,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["79",null,"Обогреватель, излучающий для новорожденных",1,0.9,0.9,220,0.9,0.95,0.32868410517886321,0.9,null,null,{"$f":"IF(K28=0,\" \",$F28*$J28)","v":0.2958156946609769}," "," ",4.3062200956937806,{"$f":"IF(K28=0,\" \",$F28*$H28)","v":0.81}," "," ",{"$f":"IF(K28=0,\" \",$J28*$F28*$H28)","v":0.26623412519487921}," "," ",4.3062200956937806,0,0]
["44",null,"Смотровой осветитель",1,0.02,0.02,220,0.6,0.95,0.32868410517886321,null,null,{"$f":"F29","v":0.02}," "," ",6.5736821035772639E-3,9.569377990430622E-2," "," ",1.2E-2," "," ",3.9442092621463582E-3,0,0,9.569377990430622E-2,null,4.0000000000000002E-4,null,null,null,null,{"$f":"IF(G29=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G29=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G29=220,VLOOKUP(AH29,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G29=380,VLOOKUP(AG29,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,{"$f":"F30","v":2},null,null,0.65736821035772641," "," ",9.5693779904306222,0.3," "," ",9.8605231553658954E-2," "," ",9.5693779904306222,0,0,null,4,null,null,null,null,{"$f":"IF(G30=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G30=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G30=220,VLOOKUP(AH30,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G30=380,VLOOKUP(AG30,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G31=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G31=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G31=220,VLOOKUP(AH31,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G31=380,VLOOKUP(AG31,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,null,2," "," ",0.65736821035772641,9.5693779904306222," "," ",0.3," "," ",9.8605231553658954E-2,0,0,9.5693779904306222,null,4,null,null,null,null,{"$f":"IF(G32=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G32=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G32=220,VLOOKUP(AH32,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G32=380,VLOOKUP(AG32,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,2,null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G33=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G33=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G33=220,VLOOKUP(AH33,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G33=380,VLOOKUP(AG33,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["59",null,"Консоль палатная  длина 1240 6 розеток + освещение",1,2,2,220,0.15,0.95,0.32868410517886321,null,{"$f":"F34","v":2},null," ",0.65736821035772641," ",9.5693779904306222," ",0.3," "," ",9.8605231553658954E-2," ",0,9.5693779904306222,0,null,4,null,null,null,null,{"$f":"IF(G34=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},{"$f":"IF(G34=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},null,null,{"$f":"IF(G34=220,VLOOKUP(AH34,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G34=380,VLOOKUP(AG34,#REF!,2),\" \")","v":" "},{"$error":"#REF!"}]
["135",null,"Плита настольная электрическая",1,5,5,380,0.8,0.98,0.20305866063400418,{"$f":"$F35/3","v":1.6666666666666667},1.6666666666666667,1.6666666666666667,{"$f":"IF(K35=0,\" \",IF($I35=1,#REF!,$K35*$J35))","v":0.33843110105667368},{"$f":"IF(L35=0,\" \",IF($I35=1,#REF!,$L35*$J35))","v":0.33843110105667368},{"$f":"IF(M35=0,\" \",IF($I35=1,#REF!,$M35*$J35))","v":0.33843110105667368},7.7517490492699492,{"$f":"IF(K35=0,\" \",($F35*$H35)/3)","v":1.3333333333333333},1.3333333333333333,1.3333333333333333,{"$f":"IF(K35=0,\" \",IF($I35=1,#REF!,$J35*$K35*$H35))","v":0.27074488084533893},{"$f":"IF(L35=0,\" \",IF($I35=1,#REF!,$J35*$L35*$H35))","v":0.27074488084533893},{"$f":"IF(M35=0,\" \",IF($I35=1,#REF!,$J35*$M35*$H35))","v":0.27074488084533893},7.7303648732220172,7.7303648732220172,7.7303648732220172]
["152",null,"Куллер",1,0.55000000000000004,0.55000000000000004,220,0.8,0.98,0.20305866063400418,null,null,{"$f":"F36","v":0.55000000000000004},{"$f":"IF(K36=0,\" \",$F36*$J36)","v":" "}," ",0.11168226334870231,2.5510204081632657,{"$f":"IF(K36=0,\" \",$F36*$H36)","v":" "}," ",0.44000000000000006,{"$f":"IF(K36=0,\" \",$J36*$F36*$H36)","v":" "}," ",8.9345810678961857E-2,0,0,2.5510204081632657]
["50",null,"вытяжка бытовая",1,0.24,0.24,220,0.8,0.65,1.1691295502746664,null,null,0.24," "," ",0.28059109206591992,1.6783216783216781," "," ",0.192," "," ",0.22447287365273594,0,0,1.6783216783216781]
[null,null,"PC Smart-UPS RT 1000VA RM",1,1,{"$f":"E38*D38","v":1},220,1,0.85,{"$f":"IF(I38=0,\" \",IF(I38=1,\"-\",TAN(ACOS(I38))))","v":0.61974433840310228},null,{"$f":"F38","v":1},null,{"$f":"IF(K38=0,\" \",$F38*$J38)","v":" "},{"$f":"IF(L38=0,\" \",$F38*$J38)","v":0.61974433840310228},{"$f":"IF(M38=0,\" \",$F38*$J38)","v":" "},{"$f":"IF($I38=0,\" \",IF($G38=220,$F38/(0.22*$I38),$F38/(0.38*$I38*3^0.5)))","v":5.3475935828877006},{"$f":"IF(K38=0,\" \",$F38*$H38)","v":" "},{"$f":"IF(L38=0,\" \",$F38*$H38)","v":1},{"$f":"IF(M38=0,\" \",$F38*$H38)","v":" "},{"$f":"IF(K38=0,\" \",$J38*$F38*$H38)","v":" "},{"$f":"IF(L38=0,\" \",$J38*$F38*$H38)","v":0.61974433840310228},{"$f":"IF(M38=0,\" \",$J38*$F38*$H38)","v":" "},{"$f":"IF(K38=0,0,K38/(0.22*I38))","v":0},{"$f":"IF(L38=0,0,L38/(0.22*I38))","v":5.3475935828877006},{"$f":"IF(M38=0,0,M38/(0.22*I38))","v":0}]
["137",null,"микроволновая печь",1,1.2,1.2,220,0.8,0.98,0.20305866063400418,{"$f":"F39","v":1.2},null,null,0.24367039276080502," "," ",5.5658627087198518,0.96," "," ",0.19493631420864402," "," ",5.5658627087198518,0,0]
[null,null,"Водоподогреватель",1,1.5,{"$f":"E40*D40","v":1.5},220,0.8,0.98,0.20305866063400418,null,null,{"$f":"F40","v":1.5}," "," ",0.3045879909510063,6.9573283858998147," "," ",1.2000000000000002," "," ",0.24367039276080504,0,0,6.9573283858998147]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K19:K40)","v":12.653333333333332},{"$f":"SUM(L19:L40)","v":15.573333333333332},{"$f":"SUM(M19:M40)","v":12.803333333333335},{"$f":"SUM(N19:N40)","v":2.9864453951111982},4.3880137489115487,3.4332336500823799,null,{"$f":"SUM(R19:R40)","v":8.1819999999999986},8.0239999999999974,8.363999999999999,1.8325278167775203,2.1922563881465633,2.2708489073224527,{"$f":"mmax(X19:X40)","v":29.993815708101426},{"$f":"mmax(Y19:Y40)","v":29.993815708101426},{"$f":"mmax(Z19:Z40)","v":29.993815708101426}]
[null,null,null,{"$f":"SUM(D19:D40)","v":25},null,{"$f":"SUM(F19:F40)","v":41.030000000000008},380,{"$f":"R42/K42","v":0.53707191780821917},{"$f":"COS(ATAN(J42))","v":0.9650631775637003},{"$f":"U42/R42","v":0.27150273879991066},{"$f":"MAX(SUM(K19:K40),SUM(L19:L40),SUM(M19:M40))*3","v":46.72},null,null,{"$f":"MAX(SUM(N19:N40),SUM(O19:O40),SUM(P19:P40))*3","v":13.164041246734646},null,null,{"$f":"IF($F42=0,\" \",IF($G42=220,$K42/(0.22*COS(ATAN(N42/K42))),$K42/(0.38*COS(ATAN(N42/K42))*3^0.5)))","v":73.747629067257833},{"$f":"MAX(SUM(R19:R40),SUM(S19:S40),SUM(T19:T40))*3","v":25.091999999999999},null,null,{"$f":"MAX(SUM(U19:U40),SUM(V19:V40),SUM(W19:W40))*3","v":6.8125467219673581},null,null,{"$f":"MAX(X41,Y41,Z41)","v":29.993815708101426},null,null,{"$f":"IF($F42=0,\" \",IF($G42=220,$R42/(0.22*COS(ATAN(U42/R42))),$R42/(0.38*COS(ATAN(U42/R42))*3^0.5)))","v":39.50347579991756},{"$f":"SUM(AB19:AB34)","v":20.34},{"$f":"F42^2/AB42","v":82.766022615535931},{"$f":"VLOOKUP(FLOOR(AC42,1),#REF!,IF(H42>0.75,10,IF(H42>0.65,9,IF(H42>0.55,8,IF(H42>0.45,7,IF(H42>0.35,6,IF(H42>0.25,5,IF(H42>0.175,4,3))))))))","v":{"$error":"#REF!"}},{"$f":"AD42*#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(G42=380,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"IF(G42=220,VLOOKUP(CEILING(#REF!,1),#REF!,2),\" \")","v":" "},null,null,{"$f":"IF(G42=220,VLOOKUP(AH42,#REF!,2),\" \")","v":" "},{"$f":"IF(G42=380,VLOOKUP(AG42,#REF!,2),\" \")","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)+3","v":{"$error":"#REF!"}},{"$f":"IF(F42=0,\" \",IF(AM42+5<9,\"ЩРн-9з-3 38 УХЛ3\",IF(AM42+5<12,\"ЩРн-12з-3 38 УХЛ3\",IF(AM42+5<18,\"ЩРн-18з-3 38 УХЛ3\",IF(AM42+5<24,\"ЩРн-24з-3 38 УХЛ3\",IF(AM42+5<36,\"ЩРн-36з-3 38 УХЛ3\",IF(AM42+5<48,\"ЩРн-48з-3 38 УХЛ3\",IF(AM42+5<54,\"ЩРн-54з-3 38 УХЛ3\",\"ЩРн-72з-3 38 УХЛ3\"))))))))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K41+K16","v":20.653333333333332},{"$f":"L41+L16","v":23.573333333333331},{"$f":"M41+M16","v":19.083333333333336}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(SUM(K19:K40,K4:K15),SUM(L19:L40,L4:L15),SUM(M19:M40,M4:M15))*3","v":70.72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F46=0,\" \",IF($G46=220,$R46/(0.22*COS(ATAN(U46/R46))),$R46/(0.38*COS(ATAN(U46/R46))*3^0.5)))","v":" "}]