{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Справка","Подбор по котлу","Подбор","Смешение ГВС","Оборудование"],"not_rendered":{"images":6,"macros":1,"defined_names":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Справка","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"merged":[[2,0,2,8],[4,0,4,5],[4,7,4,8],[6,0,6,5],[6,7,6,8],[9,0,9,8],[10,0,11,8],[20,0,21,8]]}
[]
[]
["При использовании данного калькулятора, вы можете подобрать бойлер двумя способами:"]
[]
["1.   У Вас уже есть котел и вы знаете его тепловую мощность.",{"$nulls":6},"Подобрать >>>"]
[]
["2.   Вам известно сколько вам нужно горячей воды",{"$nulls":6},"Подобрать >>>"]
[]
[]
["Вам необходимо заполнить поля, закрашенные красным цветом."]
["Вы можете изменить объем воды, необходимый для приготовления ванной или душа, а также изменять эксплуатационный режим работы котла."]
{"$rows_empty":9}
["Данная расчетная программа предоставляется только в качестве справочной информации. Компания ACV не несет ответственность за результат или любое иное использование"]

{"sheet":"Подбор по котлу","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[0,0,1,9],[3,1,3,5],[5,1,5,4],[7,2,7,3],[7,5,7,6],[9,1,9,6],[11,0,11,2],[13,0,13,2],[15,0,15,2],[17,2,17,6],[19,0,19,1],[19,2,19,3],[19,5,19,6],[21,0,21,1],[21,2,21,3],[21,5,21,6],[23,0,23,1],[26,0,26,5],[28,0,28,5],[30,0,30,8],[31,2,31,4],[33,0,33,4],[34,0,35,9],[36,0,37,9],[38,0,38,2],[39,0,39,2]]}
["Подбор бойлера косвенного нагрева под Ваш котел"]
[]
[]
[null,"Укажите мощность вашего котла, кВт:",{"$nulls":4},40]
[]
[null,"Вам подойдет бойлер:"]
[]
[null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<8,\"\",IF(G4<20,Оборудование!F2,IF(G4<30,Оборудование!G2,IF(G4<39,Оборудование!H2,IF('Подбор по котлу'!G4<50,Оборудование!I2,Оборудование!J2))))))","v":"Comfort 210"},null,"или",{"$f":"IF(G4=\"\",\"\",IF(G4<20,\"\",IF(G4<30,Оборудование!P2,IF(G4<39,Оборудование!Q2,IF('Подбор по котлу'!G4<50,Оборудование!R2,IF(G4<68,Оборудование!S2,IF('Подбор по котлу'!G4<73,Оборудование!T2,IF('Подбор по котлу'!G4<88,Оборудование!U2,Оборудование!V2))))))))","v":"Smart 160"}]
[null,null,{"$f":"IF(G4=\"\",\"\",IF(C8=\"\",\"Обратитесь в представительство ACV: +7 (499) 272-19-65\",\"\"))","v":""}]
[null,"Данный бойлер обеспечит вам производительность:"]
[]
["Пиковая при нагреве до 40°С:",null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,Оборудование!BD3:BG43,2,FALSE))","v":406},"л/10'",{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,Оборудование!BD3:BG43,2,FALSE))","v":406},"л/10'"]
[]
["Пиковая при нагреве до 40°С:",null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,Оборудование!BD3:BG43,3,FALSE))","v":1349},"л/60'",{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,Оборудование!BD3:BG43,3,FALSE))","v":1349},"л/60'"]
[]
["Непрерывная при нагреве до 40°С:",null,null,{"$f":"IF(C8=\"\",\"\",VLOOKUP(C8,Оборудование!BD3:BG43,4,FALSE))","v":1132},"л/60'",{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,Оборудование!BD3:BG43,4,FALSE))","v":1132},"л/60'"]
[]
[null,null,"Используя данный бойлер вы сможете нагреть:"]
[]
["Душ:",null,{"$f":"IF(C8=\"\",\"\",ROUNDDOWN((D12/G27)+0.1,0))","v":5},null,null,{"$f":"IF(F8=\"\",\"\",ROUNDDOWN((F12/G27)+0.1,0))","v":5}]
[]
["Ванная",null,{"$f":"IF(C8=\"\",\"\",ROUNDDOWN((D12/G29)+0.1,0))","v":3},null,null,{"$f":"IF(F8=\"\",\"\",ROUNDDOWN((F12/G29)+0.1,0))","v":3}]
[]
["Ванная + Душ:",null,{"$f":"IF(C8=\"\",\"\",(ROUNDDOWN((D12/G29),0)))","v":2},{"$f":"IF(C8=\"\",\"\",ROUNDDOWN(((D12-((ROUNDDOWN((D12/G29),0)*G29)))/G27)+0.1,0))","v":1},null,{"$f":"IF(F8=\"\",\"\",(ROUNDDOWN((F12/G29),0)))","v":2},{"$f":"IF(F8=\"\",\"\",ROUNDDOWN(((F12-((ROUNDDOWN((F12/G29),0)*G29)))/G27)+0.1,0))","v":1}]
[]
[]
["При расчете принимаем, что расход воды в душе составляет:",{"$nulls":5},72,"л/10'"]
[]
["При расчете принимаем, что объем воды, для заполнения одной ванны составляет:",{"$nulls":5},140,"л/10'"]
[]
["Если вам недостаточно данного количества воды, то попробуйте подобрать бойлер другим способом"]
[null,null,"Перейти >>>"]
[]
["Данные приведены для пиковой производительности за 10 минут (ΔT=30°)"]
["*  Данная расчетная программа предоставляется только в качестве справочной информации. Компания ACV не несет ответственность за результат или любое иное использование"]
[]
["Показатели производительности в таблице даны на основе указанного эксплуатационного режима и подводимой тепловой мощности. В случае изменения параметров производительность понижается (см. документацию на водонагреватель)."]
[]
["        Температура холодной воды: +10 °C"]
["Температура теплоносителя (+90/+80 °С)"]

{"sheet":"Подбор","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"merged":[[0,0,1,10],[4,1,4,6],[6,1,6,6],[8,2,8,4],[9,2,9,4],[10,2,10,4],[12,0,12,8],[14,0,14,8],[16,0,16,8],[18,1,18,6],[20,0,20,7],[22,2,22,3],[22,5,22,6],[23,1,23,6],[23,7,23,9],[25,0,25,2],[27,0,27,2],[29,0,29,2],[31,0,31,2],[33,0,35,10],[36,0,37,10],[38,0,38,2],[38,3,38,6],[38,7,38,10],[39,0,39,2],[39,3,39,6],[39,7,39,10],[40,0,41,10]]}
["Подбор бойлера по необходимому количеству горячей воды"]
[]
[]
[{"$nulls":10},{"$f":"INDEX(Оборудование!AX3:AY7,MATCH(Подбор!H19,Оборудование!AY3:AY7,-1))","v":{"$error":"#N/A"}}]
[null,"Укажите суммарное потребление воды (если известно):",{"$nulls":6},"л/10мин",null,{"$f":"INDEX(Оборудование!BA3:BB9,MATCH(Подбор!H19,Оборудование!BB3:BB9,-1),1)","v":{"$error":"#N/A"}}]
[]
[null,"Или укажите количество точек водоразбора:"]
[{"$nulls":10},{"$f":"IF(H5=\"\",F9*J13+F10*J15+F11*J17,H5)","v":0}]
[null,null,"Количество душевых/раковин",{"$nulls":3},"шт"]
[null,null,"Количество ванных",{"$nulls":3},"шт"]
[null,null,"Количество джакузи",{"$nulls":3},"шт"]
[]
["При расчете принимаем, что расход воды в душе составляет:",{"$nulls":8},72,"л/10'"]
[]
["При расчете принимаем, что объем воды, для заполнения одной ванны составляет:",{"$nulls":8},140,"л/10'"]
[]
["При расчете принимаем, что объем воды, для заполнения одного джакузи составляет:",{"$nulls":8},400,"л/10'"]
[]
[null,"Суммарное потребление воды составит:",{"$nulls":5},{"$f":"IF(K8=0,\"\",K8)","v":""},"л/10мин"]
[]
["Чтобы обеспечить комфортное использование всех приборов разбора ГВС одновременно, вам подойдет бойлер:"]
[]
[null,null,{"$f":"IF(ISNA(K4),\"\",INDEX(Оборудование!AX3:AY7,MATCH(Подбор!H19,Оборудование!AY3:AY7,-1),1))","v":""},null,null,{"$f":"IF(ISNA(K5),\"\",INDEX(Оборудование!BA3:BB9,MATCH(Подбор!H19,Оборудование!BB3:BB9,-1),1))","v":""}]
[null,{"$f":"IF(H19=\"\",\" \",IF(F23=\"\",\"Пожалуйста обратитесь к представителю компании:\",\"\"))","v":" "},{"$nulls":5},{"$f":"IF(H19=\"\",\" \",IF(F23=\"\",\"+7 (499) 272-19-65\",\"\"))","v":" "}]
[]
["Пиковая при нагреве до 40°С:",null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Оборудование!BD3:BG43,2,FALSE))","v":""},"л/10'",{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Оборудование!BD3:BG43,2,FALSE))","v":""},"л/10'"]
[]
["Пиковая при нагреве до 40°С:",null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Оборудование!BD3:BG43,3,FALSE))","v":""},"л/60'",{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Оборудование!BD3:BG43,3,FALSE))","v":""},"л/60'"]
[]
["Непрерывная при нагреве до 40°С:",null,null,{"$f":"IF(C23=\"\",\"\",(VLOOKUP(C23,Оборудование!BD3:BG43,4,FALSE)))","v":""},"л/60'",{"$f":"IF(F23=\"\",\"\",(VLOOKUP(F23,Оборудование!BD3:BG43,4,FALSE)))","v":""},"л/60'"]
[]
["Необходимая мощность котла:",null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Оборудование!BD3:BH43,5,FALSE))","v":""},"кВт",{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,Оборудование!BD3:BH43,5,FALSE))","v":""},"кВт"]
[]
["Данные по производительности в таблице даны с учетом смешения потоков горячей и холодной воды на выходе из бойлера до приведенных температур. Без учета технических параметров смесительного клапана. воды на выходе из бойлера до\nприведенных температур. Без учета технических параметров смесительного клапана."]
[]
[]
["Показатели производительности в таблице даны на основе указанного эксплуатационного режима и подводимой тепловой мощности. В случае изменения параметров производительность понижается (см. документацию на водонагреватель)."]
[]
["        Температура холодной воды: +10 °C",null,null,"         Температура холодной воды: +10 °C",{"$nulls":3},"           Температура холодной воды: +10 °C"]
[]
["*  Данная расчетная программа предоставляется только в качестве справочной информации. Компания ACV не несет ответственность за результат или любое иное использование"]

{"sheet":"Смешение ГВС","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[1,0,1,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[8,0,8,2],[9,0,9,2]]}
[]
["Исходные данные:"]
[]
["Температура холодной воды",null,null,10,"°С"]
["Объем холодной воды",null,null,100,"л"]
["Температра горячей воды",null,null,60,"°С"]
["Объем горячей воды",null,null,30,"л"]
[]
["Результат:"]
["Температура воды на выходе:",null,null,{"$f":"(D5*D4+D6*D7)/(D5+D7)","v":{"v":21.53846153846154,"d":"21.5"}},"°С"]

{"sheet":"Оборудование","index":4,"n_rows":44,"n_cols":60,"rows_kept":44,"hidden":true}
[{"$nulls":5},"06631201","06631301","06631401","06631501","06631601","06642701","06642801","06642901","06643001","06643101","06602401","06602501","06602601","06602701","06602801","06618501","06618601","06623501","06623601","06623701","06623801","06623901","06618801","06618901","06619001","06619101","06605201","06625101","06625201","06624601","06651301","06625301","06632101","06632201","06632301","06632801","06632901","06633001","06633101","06648501","06648601"]
[{"$nulls":5},"Comfort 100","Comfort 130","Comfort 160","Comfort 210","Comfort 240","Comfort E 100","Comfort E 130","Comfort E 160","Comfort E 210","Comfort E 240","Smart 100","Smart 130","Smart 160","Smart 210","Smart 240","Smart 320","Smart 420","SLEW 100","SLEW 130","SLEW 160","SLEW 210","SLEW 240","SLE 130","SLE 160","SLE 210","SLE 240","SLE 300","SLME 200","SLME 300","SLME 400","SLME 600","SLME 800","HRi 321","HRi 601","HRi 800","HRs 321","HRs 601","HRs 800","HRs 1000","JUMBO 800","JUMBO 1000",{"$nulls":10},"пик л/10","пик л/60","непрерыв"]
[null,"06631201","Comfort 100","пиковая при нагреве до 40°C","л/10'",212,236,321,406,547,212,236,321,406,547,236,321,406,547,700,922,1195,236,321,406,547,700,236,321,406,547,800,"321 / 321","418 / 418","558 / 558","686 / 686","922 / 860",922,1345,1881,922,1345,1881,2265,1881,2265,{"$nulls":3},"Comfort 240",547,null,"Smart 420",1195,null,"Comfort 100",{"$f":"TRANSPOSE(F3:AT3)","v":212},{"$f":"TRANSPOSE(F6:AT6)","v":705},{"$f":"TRANSPOSE(F9:AT9)","v":592},{"$f":"TRANSPOSE(F13:AT13)","v":23}]
[null,"06631301","Comfort 130","пиковая при нагреве до 45°C","л/10'",182,202,275,348,469,182,202,275,348,469,202,275,348,469,600,790,1012,202,275,348,469,600,202,275,348,469,640,{"$nulls":5},790,1153,1612,790,1153,1612,1941,1612,1941,{"$nulls":3},"Comfort 210",406,null,"Smart 320",922,null,"Comfort 130",236,784,658,23]
[null,"06631401","Comfort 160","пиковая при нагреве до 60°C","л/10'",117,117,161,209,272,117,117,161,209,272,117,161,209,272,337,504,620,117,161,209,272,337,117,161,209,272,370,"116 / 161","206 / 206","274 / 274","358 / 358","504 / 444",504,706,961,504,706,961,1145,961,1145,{"$nulls":3},"Comfort 160",321,null,"Smart 240",700,null,"Comfort 160",321,1063,890,31]
[null,"06631501","Comfort 210","пиковая при нагреве до 40°C","л/60'",705,784,1063,1349,1820,705,784,1063,1349,1820,784,1063,1349,1820,2319,2666,3151,784,1063,1349,1820,2319,784,1063,1349,1820,2360,"1063 / 738","1225 / 888","1633 / 1184","1872 / 1416","2666 / 1691",2732,3437,4270,2732,3437,4270,4940,4270,4940,{"$nulls":3},"Comfort 130",236,null,"Smart 210",547,null,"Comfort 210",406,1349,1132,39]
[null,"06631601","Comfort 240","пиковая при нагреве до 45°C","л/60'",604,672,911,1156,1560,604,672,911,1156,1560,672,911,1156,1560,1988,2285,2608,672,911,1156,1560,1988,672,911,1156,1560,1920,{"$nulls":5},2342,2946,3660,2342,2946,3660,4234,3660,4234,{"$nulls":3},"Comfort 100",212,null,"Smart 160",406,null,"Comfort 240",547,1820,1527,53]
[null,"06642701","Comfort E 100","пиковая при нагреве до 60°C","л/60'",345,384,549,689,913,345,384,549,689,913,384,549,689,913,1165,1368,1513,384,549,689,913,1165,384,549,689,913,1100,"536 / 333","590 / 402","786 / 536","935 / 661","1368 / 808",1402,1733,2124,1402,1733,2124,2438,2124,2438,{"$nulls":6},"Smart 130",321,null,"Comfort E 100",212,705,592,23]
[null,"06642801","Comfort E 130","непрерывная при нагреве до 40°C","л/ч",592,658,890,1132,1527,592,658,890,1132,1527,658,890,1132,1527,1943,2093,2536,658,890,1132,1527,1943,658,890,1132,1527,2100,"890 / 501","967 / 564","1289 / 752","1423 / 876","2093 / 998",2172,2511,2868,2172,2511,2868,3210,2868,3210,{"$nulls":6},"Smart 100",236,null,"Comfort E 130",236,784,658,23]
[null,"06642901","Comfort E 160","непрерывная при нагреве до 45°C","л/ч",507,564,763,970,1309,507,564,763,970,1309,564,763,970,1309,1665,1794,2058,564,763,970,1309,1665,564,763,970,1309,1710,{"$nulls":5},1862,2152,2458,1862,2152,2458,2751,2458,2751,{"$nulls":9},"Comfort E 160",321,1063,890,31]
[null,"06643001","Comfort E 210","непрерывная при нагреве до 60°C","л/ч",288,320,465,576,769,288,320,465,576,769,320,465,576,769,994,1037,1153,320,465,576,769,994,320,465,576,769,970,"450 / 207","461 / 235","614 / 314","693 / 364","1037 / 437",1077,1232,1395,1077,1232,1395,1562,1395,1562,{"$nulls":9},"Comfort E 210",406,1349,1132,39]
[null,"06643101","Comfort E 240","Время нагрева от котла от 10 до 80°C","минут",24,24,22,22,20,24,24,22,22,20,24,22,22,20,20,23,24,24,22,22,20,20,22,22,20,"20'",22,29,45,45,60,53,23,35,60,"23'","35'","60'","65'",60,65,{"$nulls":9},"Comfort E 240",547,1820,1527,53]
[null,"06602401","Smart 100","Подводимая тепловая мощность","кВт",23,23,31,39,53,23,23,31,39,53,23,31,39,53,68,73,88,23,31,39,53,68,23,31,39,53,68,31,32,43,48,73,76,88,100,76,88,100,112,100,112,{"$nulls":9},"Smart 100",236,784,658,23]
[null,"06602501","Smart 130","ванна",{"$nulls":51},"Smart 130",321,1063,890,31]
[null,"06602601","Smart 160","душ",{"$nulls":51},"Smart 160",406,1349,1132,39]
[null,"06602701","Smart 210",{"$nulls":52},"Smart 210",547,1820,1527,53]
[null,"06602801","Smart 240",{"$nulls":52},"Smart 240",700,2319,1943,68]
[null,"06618501","Smart 320",{"$nulls":52},"Smart 320",922,2666,2093,73]
[null,"06618601","Smart 420",{"$nulls":52},"Smart 420",1195,3151,2536,88]
[null,"06508101","Smart 420 Duplex",{"$nulls":52},"SLEW 100",236,784,658,23]
[null,"06623501","SLEW 100",{"$nulls":52},"SLEW 130",321,1063,890,31]
[null,"06623601","SLEW 130",{"$nulls":52},"SLEW 160",406,1349,1132,39]
[null,"06623701","SLEW 160",{"$nulls":52},"SLEW 210",547,1820,1527,53]
[null,"06623801","SLEW 210",{"$nulls":52},"SLEW 240",700,2319,1943,68]
[null,"06623901","SLEW 240",{"$nulls":52},"SLE 130",236,784,658,23]
[null,"06618801","SLE 130",{"$nulls":52},"SLE 160",321,1063,890,31]
[null,"06618901","SLE 160",{"$nulls":52},"SLE 210",406,1349,1132,39]
[null,"06619001","SLE 210",{"$nulls":52},"SLE 240",547,1820,1527,53]
[null,"06619101","SLE 240",{"$nulls":52},"SLE 300",800,2360,2100,68]
[null,"06605201","SLE 300",{"$nulls":52},"SLME 200","321 / 321","1063 / 738","890 / 501",31]
[null,"06625101","SLME 200",{"$nulls":52},"SLME 300","418 / 418","1225 / 888","967 / 564",32]
[null,"06625201","SLME 300",{"$nulls":52},"SLME 400","558 / 558","1633 / 1184","1289 / 752",43]
[null,"06624601","SLME 400",{"$nulls":52},"SLME 600","686 / 686","1872 / 1416","1423 / 876",48]
[null,"06651301","SLME 600",{"$nulls":52},"SLME 800","922 / 860","2666 / 1691","2093 / 998",73]
[null,"06625301","SLME 800",{"$nulls":52},"HRi 321",922,2732,2172,76]
[null,"06632101","HRi 321",{"$nulls":52},"HRi 601",1345,3437,2511,88]
[null,"06632201","HRi 601",{"$nulls":52},"HRi 800",1881,4270,2868,100]
[null,"06632301","HRi 800",{"$nulls":52},"HRs 321",922,2732,2172,76]
[null,"06632801","HRs 321",{"$nulls":52},"HRs 601",1345,3437,2511,88]
[null,"06632901","HRs 601",{"$nulls":52},"HRs 800",1881,4270,2868,100]
[null,"06633001","HRs 800",{"$nulls":52},"HRs 1000",2265,4940,3210,112]
[null,"06633101","HRs 1000",{"$nulls":52},"JUMBO 800",1881,4270,2868,100]
[null,"06648501","JUMBO 800",{"$nulls":52},"JUMBO 1000",2265,4940,3210,112]
[null,"06648601","JUMBO 1000"]