{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ввод данных"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,1,1,9],[37,1,37,2],[38,1,38,2],[34,4,34,7],[35,4,35,7],[37,4,37,7],[38,4,38,7],[35,1,35,2],[3,3,3,12],[6,1,7,1],[34,1,34,2],[6,5,6,6],[6,3,6,4],[4,1,4,2],[4,3,4,12],[1,11,1,12],[64,1,64,11],[63,1,63,11],[42,8,42,9],[42,10,42,11],[52,1,52,11],[53,1,53,11],[47,1,47,11]]}
[]
[null,"Опросный лист для подбора аккумулятора холода / чиллера   №",null,null,null,null,null,null,null,null,null," ЧЧ : ММ : 20__г.."]
[]
[null,"Клиент:"]
[null,"Контактные данные :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Значение для правила по огранич по времени","00:00:01","23:59:59"]
[]
[null,"№","Тип продукта","Время переработки, Час:Мин",null,"Температура ",null,"Расход","Коэф","Расход,м3/ч","Плотность продукта","Теплоёмкость ","Q ,кВт","Q за час",null,null,null,null,null,null,null,null,null,null,"Тип продукта","Теплоёмкость, кДж/кг*К ,20С","плотность,кг/м3  ,20С"]
[null,null,null,"начало","конец","начало","конец","м3/ч","запаса","с коэф запаса ","кг/м3","продукта",null,null,null,null,null,null,null,null,null,null,null,null,"Молоко 3,2%",3.94,1028]
[null,{"$f":"IF(ISBLANK(C9),\"\",COUNTA($C$9:C9))","v":1},"Молоко 3,2%","11:30:00","15:00:02",20,2.8,5,1,{"$f":"IF(I9*H9=0,\"\",I9*H9)","v":5},{"$f":"IF(ISNA(VLOOKUP($C$9:$C$32,$Y$8:$AA$25,3,FALSE)),\"\",VLOOKUP($C$9:$C$32,$Y$8:$AA$25,3,FALSE))","v":1028},{"$f":"IF(ISNA(VLOOKUP($C$9:$C$32,$Y$8:$AA$26,2,FALSE)),\"\",VLOOKUP($C$9:$C$32,$Y$8:$AA$26,2,FALSE))","v":3.94},{"$f":"IF(OR(ISERROR((F9-G9)/(E9-D9)),E9<D9,G9>F9),\"\",IF(COUNTA(D9,E9,F9,G9,H9,I9)<6,\"\",((J9*K9*L9*(F9-G9)/(3600*(E9-D9))/24))))","v":27.64065386446595},{"$f":"J9*K9*L9*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Молоко  обезжиренное  2,5%",4.0609999999999999,1028]
[null,{"$f":"IF(ISBLANK(C10),\"\",COUNTA($C$9:C10))","v":2},"Сок  (до 30% сух. вещ-в)","12:30:00","14:00:02",20,2,1,1,1,{"$f":"IF(ISNA(VLOOKUP($C$9:$C$32,$Y$8:$AA$25,3,FALSE)),\"\",VLOOKUP($C$9:$C$32,$Y$8:$AA$25,3,FALSE))","v":1150},{"$f":"IF(ISNA(VLOOKUP($C$9:$C$32,$Y$8:$AA$26,2,FALSE)),\"\",VLOOKUP($C$9:$C$32,$Y$8:$AA$26,2,FALSE))","v":3.81},14.599592743428298,{"$f":"J10*K10*L10*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Молоко  обезжиренное  0,5%",4.0609999999999999,1028]
[null,{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$9:C11))","v":3},"Кефир 3,2%","18:30:00","21:00:02",20,2,10,1,10,1030,3.8,{"$f":"IF(OR(ISERROR((F11-G11)/(E11-D11)),E11<D11,G11>F11),\"\",IF(COUNTA(D11,E11,F11,G11,H11,I11)<6,\"\",((J11*K11*L11*(F11-G11)/(3600*(E11-D11))/24))))","v":78.262608309264678},{"$f":"J11*K11*L11*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Сливки 20%",3.8519999999999999,1020]
[null,{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$9:C12))","v":4},"Пиво","20:30:00","21:00:02",20,3,1,1,{"$f":"IF(I12*H12=0,\"\",I12*H12)","v":1},1045,3.81,{"$f":"IF(OR(ISERROR((F12-G12)/(E12-D12)),E12<D12,G12>F12),\"\",IF(COUNTA(D12,E12,F12,G12,H12,I12)<6,\"\",((J12*K12*L12*(F12-G12)/(3600*(E12-D12))/24))))","v":37.560849056603836},{"$f":"J12*K12*L12*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Сливки 40%",3.56,1004]
[null,{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$9:C13))","v":5},"Вода ","20:30:00","23:00:02",20,3,1,1,1,1000,4.1900000000000004,7.9126860697622741,{"$f":"J13*K13*L13*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Сметана 20%",3.56,1012]
[null,{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$9:C14))","v":6},"Вода ","20:40:00","23:00:02",20,3,1,1,1,1000,4.1900000000000004,8.4777433944299059,{"$f":"J14*K14*L14*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Сметана 36%",3.56,994]
[null,{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$9:C15))","v":7},"Ряженка 2,5%","22:30:00","23:30:00",20,2,10,1,10,1030,3.8,195.70000000000019,{"$f":"J15*K15*L15*(#REF!-#REF!)/(3600)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Пахта",4.0609999999999999,1034]
[null,{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$9:C16))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J16*K16*L16*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Вода ",4.1900000000000004,1000]
[null,{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$9:C17))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J17*K17*L17*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Спирт этиловый",2.5,789]
[null,{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$9:C18))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J18*K18*L18*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Сок  (до 30% сух. вещ-в)",3.81,1150]
[null,{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$9:C19))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J19*K19*L19*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Пиво",3.81,1045]
[null,{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$9:C20))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J20*K20*L20*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Кефир 2,5%",3.8,1030]
[null,{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$9:C21))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J21*K21*L21*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Ряженка 2,5%",3.8,1030]
[null,{"$f":"IF(ISBLANK(C22),\"\",COUNTA($C$9:C22))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J22*K22*L22*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Кефир 3,2%",3.8,1030]
[null,{"$f":"IF(ISBLANK(C23),\"\",COUNTA($C$9:C23))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J23*K23*L23*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Ряженка 3,2%",3.8,1030]
[null,{"$f":"IF(ISBLANK(C24),\"\",COUNTA($C$9:C24))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J24*K24*L24*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Масло подсолнечное",1.84,930]
[null,{"$f":"IF(ISBLANK(C25),\"\",COUNTA($C$9:C25))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J25*K25*L25*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Мороженое (молочная смесь)",3.39,1120]
[null,{"$f":"IF(ISBLANK(C26),\"\",COUNTA($C$9:C26))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J26*K26*L26*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,"Мороженое (пломбирная смесь)",3.6,1120]
[null,{"$f":"IF(ISBLANK(C27),\"\",COUNTA($C$9:C27))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J27*K27*L27*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISBLANK(C28),\"\",COUNTA($C$9:C28))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J28*K28*L28*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISBLANK(C29),\"\",COUNTA($C$9:C29))","v":""},null,null,null,null,null,null,null,"","","","",{"$f":"J29*K29*L29*(#REF!-#REF!)/(3600)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(ISBLANK(C30),\"\",COUNTA($C$9:C30))","v":""},null,null,null,null,null,null,null,"","","",""]
[null,{"$f":"IF(ISBLANK(C31),\"\",COUNTA($C$9:C31))","v":""},null,null,null,null,null,null,null,"","","",""]
[null,{"$f":"IF(ISBLANK(C32),\"\",COUNTA($C$9:C32))","v":""},null,null,null,null,null,null,null,"","","",""]
[]
[]
[null,"Выбор компрессора на агрегате",null,null,"Количество компрессоров на  холодильном агрегате"]
[null,"BITZER",null,null,1]
[]
[null,"Толщина льда на трубе , мм",null,null,"Количество аккумуляторов холода"]
[null,25,null,null,1]
[]
[]
[]
[null,null,null,null,null,null,null,null,"\"Заказчик\""]
[null,null,null,null," ",null,null,null,null,null,null,null,null,"ФИО"]
[]
[null,"ОСОБЕННОСТИ"]
[]
[]
[]
[]
[null,"ПРИМЕЧАНИЕ :  "]
[]
[null,"1. При заполнении таблицы нужно учитывать , что время переработки вводится в  формате ЧЧ:ММ:CC   (диапазон 0:00:00 - 23:59:59 )"]
[null,"2. Время переработки конечное не должно быть меньше или равно времени начальному.Если термообработка  продукта  происходит  и после  23:59:59, то операцию требуется разбить на 2 этапа: со  времени  ХХчас:ХХмин:ХХсек до 23час:59мин:59сек  и  с 0:00:00 до ХХчас:ХХмин:ХХсек.."]
[null,"3. Заказчику требуется  выбрать в таблице   тип продукта , заполнить значения в жёлтых ячейках и сохранить данные."]
[null,"Файл отправить на электронную почту orenburg-holod@mail.ru"]
[null,"По всем вопросам обращаться на WHATSAPP +7 961 906 4108"]