{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Калькулятор","База"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[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,"Площадь помещения, кв. м",100,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",null,"Электричество, кВт*ч",null,"Диз. топливо, л",null,"Пеллеты, кг",null,"Дрова, м3"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Цена энергоносителя за единицу объема, руб.",24.4,null,6.63,null,5.38,null,48,null,11," ",1500," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Выделяемая энергия на единицу объема, кВт*ч",{"$f":"База!N6","v":7.085},null,{"$f":"База!M11","v":11.055555555555555},null,{"$f":"База!E16","v":1},null,{"$f":"База!N23","v":10.022638888888888},null,{"$f":"База!O30","v":5.2374999999999998},null,{"$f":"База!O37","v":2.9097222222222228}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Стоимость 1 кВт*ч, руб.",{"$f":"C7/C9","v":3.4438955539872969}," ",{"$f":"E7/E9","v":0.59969849246231155},null,{"$f":"G7/G9","v":5.38},null,{"$f":"I7/I9","v":4.7891578786912961},null,{"$f":"K7/K9","v":2.100238663484487},null,{"$f":"M7/M9","v":515.51312649164663}," "]
[null,null,null," ",null," ",null," ",null," ",null,null,null," "]
[null,"Расход энергоносителя в час",{"$f":"База!F42*$C$3","v":1.4000000000000001}," ",{"$f":"База!F43*C3","v":1.0999999999999999}," ",{"$f":"База!F44*C3","v":7.5}," ",{"$f":"База!G45*C3","v":0.99774122472735327}," ",{"$f":"База!F48*C3","v":1.9085999999999999}," ",{"$f":"База!F51*C3","v":8.0000000000000002E-3}," "]
[null,null,null," ",null," ",null," ",null," ",null," ",null," "]
[null,"Расход энергоносителя в год",{"$f":"C13*24*90","v":3024}," ",{"$f":"E13*24*90","v":2376}," ",{"$f":"G13*24*90","v":16200}," ",{"$f":"I13*24*90","v":2155.1210454110833}," ",{"$f":"K13*24*90","v":4122.576}," ",{"$f":"M13*24*90","v":17.28}," "]
[null,null,null," ",null," ",null," ",null," ",null," ",null," "]
[null,"Стоимость 1 часа отопления, руб.",{"$f":"C13*C7","v":34.160000000000004},null,{"$f":"E13*E7","v":7.2929999999999993},null,{"$f":"G13*G7","v":40.35},null,{"$f":"I13*I7","v":47.891578786912959},null,{"$f":"K13*K7","v":20.994599999999998},null,{"$f":"M13*M7","v":12}," "]
[null,null,null,null," "," "," "," "," "," ",null,null,null," "]
[null,"Годовые затраты на отопление, руб.",{"$f":"C17*24*90","v":73785.600000000006},null,{"$f":"E17*24*90","v":15752.88}," ",{"$f":"G17*24*90","v":87156.000000000015}," ",{"$f":"I17*24*90","v":103445.810179732}," ",{"$f":"K17*24*90","v":45348.335999999996},null,{"$f":"M17*24*90","v":25920}," "]
[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,"В листе БАЗА желтым выделен новый алгоритм расчета"]

{"sheet":"База","index":1,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":true,"merged":[[47,8,50,17],[55,8,57,16]]}
[]
["Пропан-бутан"]
[]
["Теплота сгорания",null,null,null,46.8,"МДж/кг"]
[]
[1,"л","=",{"$f":"545/1000","v":0.54500000000000004},"кг",{"$f":"E4*D6","v":25.506},"МДж/л",{"$f":"1000000*F6","v":25506000},"Дж",null,"1кВт*ч=",3600000,"Дж (3600 кДж)",{"$f":"H6/L6","v":7.085},"кВт*ч"]
[]
[]
["Природный газ"]
[]
["Теплота сгорания",null,null,null,39.799999999999997,"МДж/м3",{"$f":"1000000*E11","v":39800000},"Дж","1кВт*ч","=",3600000,"Дж (3600 кДж)",{"$f":"G11/K11","v":11.055555555555555},"кВт*ч"]
[]
[]
["Электричество"]
[]
["Теплота сгорания",null,null,null,1,"кВт*ч"]
[]
[]
["Дизельное топливо"]
[]
["Теплота сгорания",null,null,null,42.7,"МДж/кг"]
[]
[1,"л","=",{"$f":"(0.83+0.86)/2","v":0.84499999999999997},"кг",{"$f":"E21*D23","v":36.081499999999998},"МДж/л",{"$f":"1000000*F23","v":36081500},"Дж",null,"1кВт*ч=",3600000,"Дж (3600 кДж)",{"$f":"H23/L23","v":10.022638888888888},"кВт*ч"]
[]
[]
["Пеллеты"]
[]
["Теплота сгорания",null,null,null,4500,"ккал/кг"]
[]
[1,"кал.","=",4.1900000000000004,"Дж",null,{"$f":"E28","v":4500},"ккал =",{"$f":"G30*1000*D30","v":18855000},"Дж",null,"1кВт*ч =",3600000,"Дж (3600 кДж)",{"$f":"I30/M30","v":5.2374999999999998},"кВт*ч",null," "," "," "]
[]
[]
["Дрова"]
[]
["Теплота сгорания",null,null,null,2500,"ккал/кг"," "," "," "," "," "]
[]
[1,"кал.","=",4.1900000000000004,"Дж",null,{"$f":"E35","v":2500},"ккал =",{"$f":"G37*1000*D37","v":10475000.000000002},"Дж",null,"1кВт*ч =",3600000,"Дж (3600 кДж)",{"$f":"I37/M37","v":2.9097222222222228},"кВт*ч"]
[]
[]
["Расход энергоносителя в час (эмпирические данные)"]
[]
["Пропан-бутан",null,null,null,null,1.4E-2,"л"]
["Природный газ",null,null,null,null,1.0999999999999999E-2,"м3",null,null," "," "," "," "," "," "," "," "," "]
["Электричество ",null,null,null,null,7.4999999999999997E-2,"кВт",null,null," "," "," "," "," "," "," "," "," "]
["Дизельное топливо",null,null,null,null,{"$f":"10/N23","v":0.99774122472735338},{"$f":"F45*G46/F46","v":9.977412247273533E-3},"кг",null," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,100,1,null,null," "," "," "," "," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "]
["Пеллеты",null,null,null,null,1.9085999999999999E-2,"кг",null,"Общие эмпирические исходные данные.\nДля отопления дровами дома в 100 квадратных метров необходимо 100 кв. м.*100 Вт = 10 киловатт тепловой энергии в час. В сутки это будет 10 кВт/ч * 24 ч = 240 кВт; в месяц 240 кВт/день * 30 дней = 7200 киловатт, за весь отопительный период 240 кВт/день * 111 дней = 26 640 кВт."]
[]
[]
["Дрова",null,null,null,null,{"$f":"0.0344/430","v":8.0000000000000007E-5},"м3"]
[null,null,null,null,null,null,null,null,null," "," "," "," "," "," "," "," "," "]
[]
[]
["1 киловатт  - единица мощности",null,null,null,null,null,null,null,"Расчет загрузки электрического котла"]
[null,null,null,null,null,null,null,null,"Принимаем: пиковая нагрузка на котел в день составляет 12ч (с 21.00 до 9.00), это 100%загрузка котла , остальные 12ч это 50% загрузка котла, тогда общая 100% загрузка котла будет 18ч. Тогда в таблице /расход энергоносителя в час(эмпирические данные)/(отмечено желтым) примем коэффициент не 0,1кВт как был при 100%загрузке постоянно, а 0,075."]
["1 киловатт-час - единица энергии"]