{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Исходные данные","Теплопотери","Ориентация","Коэффициент_n","Добавка_на_проемы"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Исходные данные","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,4,2]],"flags":["formulas_cached_only"]}
[]
[null,"Исходные данные"]
[]
[null,"Наименование населенного пункта:",null,"Санкт-Петербург"]
[null,"Наружная температура:",null,-26]
[null,"Высота здания:",null,15]
[]
[null,"Список ограждающих конструкций"]
[null,"Полное наименование","Сокращенное наименование","Сопротивление теплопередаче ограждения R, м²·ºС/Вт","Добавочные теплопотери  β\n(только для проемов в стене)","Инфильтрация"]
[null,"Наружная стена 120мм","Нс1",2.55,"Нет"]
[null,"Наружная стена 150мм","Нс2",3.19,"Нет"]
[null,"Покрытие","По",3.456,"Нет"]
[null,"Окно","Ок",0.5,"Нет"]
[null,"Дверь","Дв",0.8,"Дверь наружная двойная"]
[null,"Ворота","Во",1.25,"Ворота наружные без тепловой завесы"]
[null,"Пол на грунте 1 зона","ПлI",2.1,"Нет"]
[null,"Пол на грунте 2 зона","ПлII",4.3,"Нет"]
[null,"Пол на грунте 3 зона","ПлIII",8.6,"Нет"]
[null,"Пол на грунте 4 зона","ПлIV",14.2,"Нет"]

{"sheet":"Теплопотери","index":1,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,17,1,19],[0,0,0,19],[1,4,1,9],[1,10,2,10],[1,11,2,11],[1,16,2,16],[1,0,2,0],[1,1,2,1],[1,3,2,3],[1,12,1,15],[1,2,2,2]],"flags":["formulas_cached_only"]}
["Расчет теплопотерь здания"]
["№ помещения","Наименование помещения","В помещении 2 и более наружные стены","Температура\nпомещения tв, ºС","Характеристика ограждений",{"$nulls":5},"Сопротивление теплопередаче ограждения R, м²·ºС/Вт","Расчетная разность температуры (tв - tн), ºС","Добавочные теплопотери β",null,null,null,"Коэффициент (1+Σβ)","Теплопотери, Вт"]
[{"$nulls":4},"Наименование","Ориентация","Длина","Высота","Площадь","Коэффициент n",null,null,"На ориентацию по сторонам горизонта","На проемы в стенах","При 2-х и более наружных стенах","Прочие",null,"Через ограждения","На нагрев инфильтрующегося воздуха","Помещения в целом"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,16,17,18,19]
["24.101","Помещение 1",null,20,"По","Нет",20,20,400,1,3.456,46,0,0,0,0,1,5324.074074074075]
[null,null,null,20,"Нс1","С",20,3,48.75999999999999,1,2.55,46,0.1,0,0,0,1.1,967.5513725490194]
[null,null,null,20,"Ок","С",1.2,2.1,2.52,1,0.5,46,0.1,0,0,0,1.1,255.02400000000003]
[null,null,null,20,"Ок","С",2,3.1,6.2,1,0.5,46,0.1,0,0,0,1.1,627.44]
[null,null,null,20,"Дв","С",1.2,2.1,2.52,1,0.8,46,0.1,5.1000000000000005,0,0,6.200000000000001,898.3800000000002]
[{"$nulls":17},8072.469446623095,null,8072.469446623095]
["24.102","Помещение 2","+",18,"По","Нет",20,20,400,1,3.456,44,0,0,0,0,1,5092.592592592593]
[null,null,"+",18,"Нс2","СВ",60,3,180,1,3.19,44,0.1,0,0.05,0,1.1500000000000001,2855.172413793104]
[null,null,"+",18,"Нс1","Ю",20,3,48.75999999999999,1,2.55,44,0,0,0.1,0,1.1,925.4839215686274]
[null,null,"+",18,"Ок","Ю",1.2,2.1,2.52,1,0.5,44,0,0,0.1,0,1.1,243.936]
[null,null,"+",18,"Ок","Ю",2,3.1,6.2,1,0.5,44,0,0,0.1,0,1.1,600.1600000000001]
[null,null,"+",18,"Дв","Ю",1.2,2.1,2.52,1,0.8,44,0,5.1000000000000005,0.1,0,6.2,859.3199999999999]
[{"$nulls":17},10576.664927954324,null,10576.664927954324]
["24.103","Помещение 3","+",16,"По","Нет",20,20,400,1,3.456,42,0,0,0,0,1,4861.111111111111]
[null,null,"+",16,"Нс2","С",60,3,180,1,3.19,42,0.1,0,0.05,0,1.1500000000000001,2725.391849529781]
[null,null,"+",16,"Нс2","З",20,3,60,1,3.19,42,0.05,0,0.1,0,1.1500000000000001,908.4639498432604]
[null,null,"+",16,"Нс1","В",20,3,48.75999999999999,1,2.55,42,0.1,0,0.05,0,1.1500000000000001,923.5717647058822]
[null,null,"+",16,"Ок","В",1.2,2.1,2.52,1,0.5,42,0.1,0,0.05,0,1.1500000000000001,243.43200000000004]
[null,null,"+",16,"Ок","В",2,3.1,6.2,1,0.5,42,0.1,0,0.05,0,1.1500000000000001,598.9200000000002]
[null,null,"+",16,"Во","В",1.2,2.1,2.52,1,1.25,42,0.1,3,0.05,0,4.1499999999999995,351.38879999999995]
[{"$nulls":17},10612.279475190036,null,10612.279475190036]
[{"$nulls":19},29261.413849767454]

{"sheet":"Ориентация","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Ориентация","Сокращенное наименование","Добавочные теплопотери  β","Добавочные теплопотери при 2-х и более стенах"]
[null,null,"Нет",0,0]
[null,"Север","С",0.1,0.05]
[null,"Северо-восток","СВ",0.1,0.05]
[null,"Восток","В",0.1,0.05]
[null,"Юго-восток","ЮВ",0.05,0.1]
[null,"Юг","Ю",0,0.1]
[null,"Юго-запад","ЮЗ",0,0.1]
[null,"Запад","З",0.05,0.1]
[null,"Северо-запад","СЗ",0.1,0.05]

{"sheet":"Коэффициент_n","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Ограждающие конструкции","Коэффициент n"]
[null,"Наружные стены и покрытия, зенитные фонари, перекрытия чердачные и над проездами; перекрытия над холодными (без ограждающих стенок) подпольями в Северной строительно-климатической зоне ",1]
[null,"Перекрытия над холодными подвалами, сообщающимися с наружным воздухом; перекрытия чердачные (с кровлей из рулонных материалов); перекрытия над холодными (с ограждающими стенками) подпольями и холодными этажами в Северной строительно-климатической зоне",0.9]
[null,"Перекрытия над неотапливаемыми подвалами со световыми проемами в стенах",0.75]
[null,"Перекрытия над неотапливаемыми подвалами без световых проемов в стенах, расположенные выше уровня земли",0.6]
[null,"Перекрытия над неотапливаемыми техническими подпольями, расположенными ниже уровня земли",0.4]

{"sheet":"Добавка_на_проемы","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Наименование ограждения (проема)","Добавка"]
[null,"Нет",0]
[null,"Дверь наружная одинарная",0.22]
[null,"Дверь, ворота наружные летние, запасные",0]
[null,"Дверь наружная запасная двойная с тамбуром",0]
[null,"Дверь наружная двойная",0.34]
[null,"Дверь наружная двойная с тамбуром",0.27]
[null,"Дверь наружная в изолированное помещение",0]
[null,"Дверь наружная с тепловой завесой",0]
[null,"Дверь наружная тройная с двумя тамбурами",0.2]
[null,"Дверь балконная",0]
[null,"Дверь наружная для покупателей, персонала, приемочной без тепловой завесы",5,1]
[null,"Ворота наружные без тепловой завесы",3,1]
[null,"Ворота наружные с тепловой завесой",0]
[null,"Ворота наружные с тамбуром без тепловой завесы",1]