{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Говядина","Свинина"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Говядина","index":0,"n_rows":61,"n_cols":15,"rows_kept":61,"merged":[[2,2,2,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,7,7,8],[7,9,7,10],[9,2,9,3],[9,4,9,12],[10,4,10,12],[12,2,14,2],[12,3,14,3],[12,4,12,5],[12,6,12,9],[12,10,14,10],[12,11,14,11],[12,12,14,12],[12,13,12,14],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,13,9],[13,13,14,13],[13,14,14,14],[46,2,46,3],[52,6,52,11],[54,9,54,12],[55,6,55,9],[55,10,55,11],[57,3,57,4],[59,5,59,6],[60,5,60,6]]}
[]
[]
[null,null,"Подготовлено редакцией Правовой платформы «Бизнес-Инфо» \n(ООО «Профессиональные правовые системы»)"]
[]
[null,null,"ЖУРНАЛ"]
[null,null,"учета и начисления естественной убыли по нормам при замораживании охлажденных, полностью оттаявших,"]
[null,null,"домораживании частично оттаявших и при хранении мороженых мяса и субпродуктов"]
[{"$nulls":6},"на",null,null,"холодильниках"]
[]
[null,null,"Наименование",null,"говядина первой категории для передачи в производство"]
[{"$nulls":4},"(вид, категория, назначение)"]
[{"$nulls":14},"(в килограммах)"]
[null,null,"Дата поступления (число, месяц, год)","Номер приемного документа (товарно-транспортная накладная, акт закупки)","Остаток на начало месяца",null,"Поступило мяса и субпродуктов",{"$nulls":3},"Заморо-жено из охлаж-денного мяса","Номер расходного документа (накладная на внутреннее перемещение)","Отпущено мороже-ного мяса","Остатки на конец суток"]
[{"$nulls":4},"без учета НЕУ","за вычетом НЕУ","всего","в том числе с температурой, °С",{"$nulls":5},"без вычета НЕУ","за вычетом НЕУ"]
[{"$nulls":7},"минус 1,5 и выше","от минус 1,6 до минус 7,9","минус 8 \nи ниже"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,"2021-11-01",null,{"v":12300,"d":"12,300"},{"v":12000,"d":"12,000"},{"$f":"SUM(H17:J17)","v":0},{"$nulls":7},{"$f":"F17+G17+K17-M17","v":{"v":12000,"d":"12,000"}}]
[null,null,"2021-11-02",1754830,null,null,{"$f":"SUM(H18:J18)","v":{"v":13000,"d":"13,000"}},null,{"v":3000,"d":"3,000"},{"v":10000,"d":"10,000"},{"$nulls":3},{"$f":"O17+G18+K18-M18","v":{"v":25000,"d":"25,000"}}]
[null,null,"2021-11-03",{"$nulls":3},0,{"$nulls":4},104,{"v":13000,"d":"13,000"},{"$f":"N18+G19+K19-M19","v":{"v":12000,"d":"12,000"}}]
[null,null,"2021-11-04",1754838,null,null,{"v":2000,"d":"2,000"},null,null,{"v":2000,"d":"2,000"},{"$nulls":3},{"v":14000,"d":"14,000"}]
[null,null,"2021-11-05",{"$nulls":3},0,{"$nulls":6},{"v":14000,"d":"14,000"}]
[null,null,"2021-11-06",{"$nulls":3},0,{"$nulls":6},{"v":14000,"d":"14,000"}]
[null,null,"2021-11-07",{"$nulls":3},0,{"$nulls":6},{"v":14000,"d":"14,000"}]
[null,null,"2021-11-08",{"$nulls":3},0,{"$nulls":6},{"v":14000,"d":"14,000"}]
[null,null,"2021-11-09",1290908,null,null,{"v":10000,"d":"10,000"},{"v":6000,"d":"6,000"},{"v":4000,"d":"4,000"},null,null,108,{"v":20000,"d":"20,000"},{"v":4000,"d":"4,000"}]
[null,null,"2021-11-10",1089743,null,null,0,{"$nulls":3},{"v":5000,"d":"5,000"},null,null,{"v":9000,"d":"9,000"}]
[null,null,"2021-11-11",{"$nulls":3},0,{"$nulls":4},110,{"v":7000,"d":"7,000"},{"v":2000,"d":"2,000"}]
[null,null,"2021-11-12",{"$nulls":3},0,{"$nulls":6},{"v":2000,"d":"2,000"}]
[null,null,"2021-11-13",{"$nulls":3},0,{"$nulls":6},{"v":2000,"d":"2,000"}]
[null,null,"2021-11-14",{"$nulls":3},0,{"$nulls":6},{"v":2000,"d":"2,000"}]
[null,null,"2021-11-15",1758493,null,null,{"v":3100,"d":"3,100"},null,null,{"v":3100,"d":"3,100"},{"$nulls":3},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-16",{"$nulls":3},0,{"$nulls":6},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-17",1290920,null,null,{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"$nulls":3},115,{"v":7000,"d":"7,000"},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-18",{"$nulls":3},0,{"$nulls":6},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-19",{"$nulls":3},0,{"$nulls":6},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-20",{"$nulls":3},0,{"$nulls":6},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-21",{"$nulls":3},0,{"$nulls":6},{"v":5100,"d":"5,100"}]
[null,null,"2021-11-22",1290955,null,null,{"v":4000,"d":"4,000"},null,{"v":4000,"d":"4,000"},{"$nulls":4},{"v":9100,"d":"9,100"}]
[null,null,"2021-11-23",{"$nulls":3},0,{"$nulls":6},{"v":9100,"d":"9,100"}]
[null,null,"2021-11-24",{"$nulls":3},0,{"$nulls":6},{"v":9100,"d":"9,100"}]
[null,null,"2021-11-25",1089784,null,null,0,{"$nulls":3},{"v":4900,"d":"4,900"},null,null,{"v":14000,"d":"14,000"}]
[null,null,"2021-11-26",1291025,null,null,{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"$nulls":5},{"v":20000,"d":"20,000"}]
[null,null,"2021-11-27",{"$nulls":3},0,{"$nulls":6},{"v":20000,"d":"20,000"}]
[null,null,"2021-11-28",{"$nulls":3},0,{"$nulls":6},{"v":20000,"d":"20,000"}]
[null,null,"2021-11-29",1758527,null,null,{"v":5000,"d":"5,000"},null,null,{"v":5000,"d":"5,000"},{"$nulls":3},{"v":25000,"d":"25,000"}]
[null,null,"2021-11-30",{"$nulls":3},0,{"$nulls":4},122,{"v":7000,"d":"7,000"},{"$f":"N45+G46+K46-M46","v":{"v":18000,"d":"18,000"}},{"$f":"F58","v":{"v":17700,"d":"17,700"}}]
[null,null,"Итого за месяц",{"$nulls":3},{"v":50100,"d":"50,100"},{"$f":"SUM(H17:H46)","v":{"v":19000,"d":"19,000"}},{"$f":"SUM(I17:I46)","v":{"v":11000,"d":"11,000"}},{"$f":"SUM(J17:J46)","v":{"v":20100,"d":"20,100"}},{"$f":"SUM(K17:K46)","v":{"v":9900,"d":"9,900"}},null,{"$f":"SUM(M17:M46)","v":{"v":54000,"d":"54,000"}},{"$f":"SUM(N17:N46)","v":{"v":308000,"d":"308,000"}},{"$f":"O46","v":{"v":17700,"d":"17,700"}}]
[]
[null,null,"Естественная убыль по нормам на замораживание и домораживание:"]
[{"$nulls":5},"%",null,0.79,0.25,{"v":0.1,"d":"0.10"},0.79]
[{"$nulls":5},"кг",{"$f":"SUM(H51:K51)","v":{"v":275.90999999999997,"d":"275.91"}},{"$f":"ROUND(H47*H50/100,2)","v":{"v":150.1,"d":"150.10"}},{"$f":"ROUND(I47*I50/100,2)","v":{"v":27.5,"d":"27.50"}},{"v":20.1,"d":"20.10"},78.21]
[]
[null,null,"Естественная убыль по нормам при хранении",{"$nulls":3},"мороженой говядины первой категории",{"$nulls":6},{"$f":"ROUND((N47+M47-G51)*0.2%/30,2)","v":24.11},"кг"]
[]
[null,null,"Всего естественной убыли при замораживании, домораживании и хранении"]
[{"$nulls":6},"мороженой говядины первой категории",{"$nulls":3},"за ноябрь 2021 г.",null,null,{"$f":"G51+N53","v":300.02},"кг"]
[]
[null,null,"Остаток на","1 декабря 2021 г.",null,{"$f":"ROUND(N46-N56,0)","v":{"v":17700,"d":"17,700"}},"кг"]
[]
[null,null,"Бухгалтер",null,null,"А.Л.Липатова"]
[{"$nulls":3},"(подпись)",null,"(инициалы, фамилия)"]

{"sheet":"Свинина","index":1,"n_rows":61,"n_cols":15,"rows_kept":61,"merged":[[2,2,2,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,7,7,8],[7,9,7,10],[9,2,9,3],[9,4,9,12],[10,4,10,12],[12,2,14,2],[12,3,14,3],[12,4,12,5],[12,6,12,9],[12,10,14,10],[12,11,14,11],[12,12,14,12],[12,13,12,14],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,13,9],[13,13,14,13],[13,14,14,14],[46,2,46,3],[52,6,52,11],[54,9,54,12],[55,6,55,9],[55,10,55,11],[57,3,57,4],[59,5,59,6],[60,5,60,6]]}
[]
[]
[null,null,"Подготовлено редакцией Правовой платформы «Бизнес-Инфо» \n(ООО «Профессиональные правовые системы»)"]
[]
[null,null,"ЖУРНАЛ"]
[null,null,"учета и начисления естественной убыли по нормам при замораживании охлажденных, полностью оттаявших,"]
[null,null,"домораживании частично оттаявших и при хранении мороженых мяса и субпродуктов"]
[{"$nulls":6},"на",null,null,"холодильниках"]
[]
[null,null,"Наименование",null,"свинина первой категории для передачи в производство"]
[{"$nulls":4},"(вид, категория, назначение)"]
[{"$nulls":14},"(в килограммах)"]
[null,null,"Дата поступления (число, месяц, год)","Номер приемного документа (товарно-транспортная накладная, акт закупки)","Остаток на начало месяца",null,"Поступило мяса и субпродуктов",{"$nulls":3},"Заморо-жено из охлаж-денного мяса","Номер расходного документа (накладная на внутреннее перемещение)","Отпущено мороже-ного мяса","Остатки на конец суток"]
[{"$nulls":4},"без учета НЕУ","за вычетом НЕУ","всего","в том числе с температурой, °С",{"$nulls":5},"без вычета НЕУ","за вычетом НЕУ"]
[{"$nulls":7},"минус 1,5 и выше","от минус 1,6 до минус 7,9","минус 8 \nи ниже"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,"2021-11-01",null,{"v":8200,"d":"8,200"},{"v":8000,"d":"8,000"},{"$f":"SUM(H17:J17)","v":0},{"$nulls":7},{"$f":"F17+G17+K17-M17","v":{"v":8000,"d":"8,000"}}]
[null,null,"2021-11-02",1290876,null,null,{"$f":"SUM(H18:J18)","v":{"v":8700,"d":"8,700"}},{"v":5000,"d":"5,000"},{"v":3700,"d":"3,700"},null,null,102,{"v":7700,"d":"7,700"},{"$f":"O17+G18+K18-M18","v":{"v":9000,"d":"9,000"}}]
[null,null,"2021-11-03",1754835,null,null,{"v":1300,"d":"1,300"},null,null,{"v":1300,"d":"1,300"},{"$nulls":3},{"$f":"N18+G19+K19-M19","v":{"v":10300,"d":"10,300"}}]
[null,null,"2021-11-04",{"$nulls":3},0,{"$nulls":4},105,{"v":1000,"d":"1,000"},{"v":9300,"d":"9,300"}]
[null,null,"2021-11-05",{"$nulls":3},0,{"$nulls":6},{"v":9300,"d":"9,300"}]
[null,null,"2021-11-06",{"$nulls":3},0,{"$nulls":6},{"v":9300,"d":"9,300"}]
[null,null,"2021-11-07",{"$nulls":3},0,{"$nulls":6},{"v":9300,"d":"9,300"}]
[null,null,"2021-11-08",{"$nulls":3},0,{"$nulls":4},107,{"v":9000,"d":"9,000"},300]
[null,null,"2021-11-09",1089737,null,null,0,{"$nulls":3},{"v":4000,"d":"4,000"},109,500,{"v":3800,"d":"3,800"}]
[null,null,"2021-11-10",1758409,null,null,{"v":5900,"d":"5,900"},null,{"v":1900,"d":"1,900"},{"v":4000,"d":"4,000"},{"$nulls":3},{"v":9700,"d":"9,700"}]
[null,null,"2021-11-11",{"$nulls":3},0,{"$nulls":6},{"v":9700,"d":"9,700"}]
[null,null,"2021-11-12",1290891,null,null,{"v":1100,"d":"1,100"},{"v":1100,"d":"1,100"},{"$nulls":3},112,{"v":7000,"d":"7,000"},{"v":3800,"d":"3,800"}]
[null,null,"2021-11-13",{"$nulls":3},0,{"$nulls":6},{"v":3800,"d":"3,800"}]
[null,null,"2021-11-14",{"$nulls":3},0,{"$nulls":6},{"v":3800,"d":"3,800"}]
[null,null,"2021-11-15",{"$nulls":3},0,{"$nulls":6},{"v":3800,"d":"3,800"}]
[null,null,"2021-11-16",{"$nulls":3},0,{"$nulls":6},{"v":3800,"d":"3,800"}]
[null,null,"2021-11-17",1290922,null,null,900,null,900,{"$nulls":4},{"v":4700,"d":"4,700"}]
[null,null,"2021-11-18",{"$nulls":3},0,{"$nulls":6},{"v":4700,"d":"4,700"}]
[null,null,"2021-11-19",1758466,null,null,{"v":3700,"d":"3,700"},null,null,{"v":3700,"d":"3,700"},null,120,{"v":6200,"d":"6,200"},{"v":2200,"d":"2,200"}]
[null,null,"2021-11-20",{"$nulls":3},0,{"$nulls":6},{"v":2200,"d":"2,200"}]
[null,null,"2021-11-21",{"$nulls":3},0,{"$nulls":6},{"v":2200,"d":"2,200"}]
[null,null,"2021-11-22",1290953,null,null,{"v":2700,"d":"2,700"},{"v":2700,"d":"2,700"},{"$nulls":5},{"v":4900,"d":"4,900"}]
[null,null,"2021-11-23",{"$nulls":3},0,{"$nulls":6},{"v":4900,"d":"4,900"}]
[null,null,"2021-11-24",1758484,null,null,{"v":2000,"d":"2,000"},null,null,{"v":2000,"d":"2,000"},{"$nulls":3},{"v":6900,"d":"6,900"}]
[null,null,"2021-11-25",1290985,null,null,{"v":3300,"d":"3,300"},{"v":3300,"d":"3,300"},{"$nulls":5},{"v":10200,"d":"10,200"}]
[null,null,"2021-11-26",1291021,null,null,{"v":1400,"d":"1,400"},null,{"v":1400,"d":"1,400"},{"$nulls":4},{"v":11600,"d":"11,600"}]
[null,null,"2021-11-27",{"$nulls":3},0,{"$nulls":6},{"v":11600,"d":"11,600"}]
[null,null,"2021-11-28",{"$nulls":3},0,{"$nulls":6},{"v":11600,"d":"11,600"}]
[null,null,"2021-11-29",1758528,null,null,{"v":5000,"d":"5,000"},null,null,{"v":5000,"d":"5,000"},{"$nulls":3},{"v":16600,"d":"16,600"}]
[null,null,"2021-11-30",{"$nulls":3},0,{"$nulls":4},122,{"v":4600,"d":"4,600"},{"$f":"N45+G46+K46-M46","v":{"v":12000,"d":"12,000"}},{"$f":"F58","v":{"v":11800,"d":"11,800"}}]
[null,null,"Итого за месяц",{"$nulls":3},{"v":36000,"d":"36,000"},{"$f":"SUM(H17:H46)","v":{"v":12100,"d":"12,100"}},{"$f":"SUM(I17:I46)","v":{"v":7900,"d":"7,900"}},{"$f":"SUM(J17:J46)","v":{"v":16000,"d":"16,000"}},{"$f":"SUM(K17:K46)","v":{"v":4000,"d":"4,000"}},null,{"$f":"SUM(M17:M46)","v":{"v":36000,"d":"36,000"}},{"$f":"SUM(N17:N46)","v":{"v":205300,"d":"205,300"}},{"$f":"O46","v":{"v":11800,"d":"11,800"}}]
[]
[null,null,"Естественная убыль по нормам на замораживание и домораживание:"]
[{"$nulls":5},"%",null,0.92,0.25,{"v":0.1,"d":"0.10"},0.92]
[{"$nulls":5},"кг",{"$f":"SUM(H51:K51)","v":183.87},{"$f":"ROUND(H47*H50/100,2)","v":111.32},{"$f":"ROUND(I47*I50/100,2)","v":19.75},{"v":16,"d":"16.00"},{"v":36.8,"d":"36.80"}]
[]
[null,null,"Естественная убыль по нормам при хранении",{"$nulls":3},"мороженой свинины первой категории",{"$nulls":6},{"$f":"ROUND((N47+M47-G51)*0.2%/30,2)","v":16.07},"кг"]
[]
[null,null,"Всего естественной убыли при замораживании, домораживании и хранении"]
[{"$nulls":6},"мороженой свинины первой категории",{"$nulls":3},"за ноябрь 2021 г.",null,null,{"$f":"G51+N53","v":199.94},"кг"]
[]
[null,null,"Остаток на","1 декабря 2021 г.",null,{"$f":"ROUND(N46-N56,0)","v":{"v":11800,"d":"11,800"}},"кг"]
[]
[null,null,"Бухгалтер",null,null,"А.Л.Липатова"]
[{"$nulls":3},"(подпись)",null,"(инициалы, фамилия)"]