{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Расчет пайка","Нормы замены"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,7,6,19],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,0,5,0],[3,5,4,5]]}
[]
[null,"Сколько комплектов надо:",100]
[null,null,null,null,null,null,null,null,null,null,"спасибо) это лишнее"]
["Группа","Наименования пищевых продуктов","Единица измерения","Количество на одного человека в сутки","Остаток на","Положено к выдаче",null,null,null,null,"белорусам всегда с удовольствием помогаю)"]
[null,null,null,null,{"$f":"TODAY()","v":"2022-05-04"},null,null,"https://laifhak.ru/media/papamozet/suhpaek-specnaza-armii-respubliki-belarus-pokazyvaiu-chto-vnutri-5f6389e161cbe322d90cc253"]
[null,null,null,null,"кг.","кг."]
[{"$f":"IFERROR(--LEFT(B7),A6)","v":1},"1. Печенье затяжное крекер из муки пшеничной","гр.",300,56,{"$f":"giveout($A$7:$E$11,B7,$C$2,D7,E7,A7)","v":30}]
[{"$f":"IFERROR(--LEFT(B8),A7)","v":1},"галеты","гр.",165,78,{"$f":"giveout($A$7:$E$11,B8,$C$2,D8,E8,A8)","v":0}]
[1,"хлебцы","гр.",165,98,{"$f":"giveout($A$7:$E$11,B9,$C$2,D9,E9,A9)","v":0}]
[2,"2. Печенье Сахар пакетированное","гр.",50,76,{"$f":"giveout($A$7:$E$11,B10,$C$2,D10,E10,A10)","v":5}]
[2,"вафли","гр.",40,5,{"$f":"giveout($A$7:$E$11,B11,$C$2,D11,E11,A11)","v":0}]
[3,"3. Консервы мясные тушеные","гр.",338,70,{"$f":"giveout($A$12:$E$14,B12,$C$2,D12,E12,A12)","v":33.799999999999997}]
[4,"4. Консервы рыбные","гр.",250,0,{"$f":"giveout($A$12:$E$14,B13,$C$2,D13,E13,A13)","v":0}]
[5,"5. Консервы мясорастительные","банок",1,600,{"$f":"giveout($A$12:$E$14,B14,$C$2,D14,E14,A14)","v":200}]
[6,"6. Сахар пакетированный","гр.",60,67,{"$f":"giveout($A$15:$E$21,B15,$C$2,D15,E15,A15)","v":6}]
[6,"Сахар (50 кг в мешке)",null,60,250,{"$f":"giveout($A$15:$E$21,B16,$C$2,D16,E16,A16)","v":0}]
[7,"7. Чай пакетированный","гр.",6,7,{"$f":"giveout($A$15:$E$21,B17,$C$2,D17,E17,A17)","v":0.6}]
[7,"Чай весовой (1 кг в мешке)",null,6,125,{"$f":"giveout($A$15:$E$21,B18,$C$2,D18,E18,A18)","v":0}]
[8,"8. Карамель","гр.",25,78,{"$f":"giveout($A$15:$E$21,B19,$C$2,D19,E19,A19)","v":2.5}]
[{"$f":"IFERROR(--LEFT(B20),#REF!)","v":9},"9. Гематоген","гр.",20,1,{"$f":"giveout($A$15:$E$21,B20,$C$2,D20,E20,A20)","v":0}]
[9,"Соки плодовые и ягодные",null,200,30,{"$f":"giveout($A$15:$E$21,B21,$C$2,D21,E21,A21)","v":20}]

{"sheet":"Нормы замены","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Группа","Наименование","Ед. изм.","Кол-во"]
[1,"Печенье затяжное крекер из муки пшеничной","гр.",200]
[1,"Галеты","гр.",110]
[1,"Хлебцы","гр.",110]
[2,"Печенье Сахар пакетированное","гр.",100]
[2,"Вафли","гр.",80]
[3,"Консервы мясные тушеные","гр.",338]
[4,"Консервы рыбные","гр.",500]
[5,"Консервы мясорастительные","банки",2]
[6,"Сахар пакетированный","гр.",100]
[6,"Сахар (50 кг в мешке)","гр.",100]
[7,"Чай пакетированный","гр.",4]
[7,"Чай весовой (1 кг в мешке)","гр.",4]
[7,"Кофе натуральный растворимый","гр.",4]
[8,"Повидло, джем, конфитюр","гр.",100]
[8,"Карамель","гр.",50]
[8,"Сахар пакетированный","гр.",125]
[8,"Сахар (50 кг в мешке)","гр.",125]
[8,"Соки плодовые и ягодные","мл",400]
[8,"Шоколад","гр.",20]
[9,"Гематоген","гр.",40]
[9,"Соки плодовые и ягодные","мл",400]