{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Расчет пайка","Нормы замены"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,8,6,18],[4,2,6,2],[4,3,6,3],[4,4,6,4],[4,1,6,1],[4,6,5,6]]}
[]
[]
[null,null,"Сколько комплектов надо:",100]
[]
[null,"Группа","Наименования пищевых продуктов","Единица измерения","Количество на одного человека в сутки","Остаток на","Положено к выдаче"]
[null,null,null,null,null,{"$f":"TODAY()","v":"2022-05-05"}]
[null,null,null,null,null,"кг.","кг.",null,"Вот возможные варианты цифр"]
[null,{"$f":"IFERROR(--LEFT(C8),B7)","v":1},"1. Печенье затяжное крекер из муки пшеничной","гр.",300,56,{"$f":"giveout($B$8:$F$12,C8,$D$3,E8,F8,B8)","v":{"$error":"#VALUE!"}},null,{"$f":"$D$3*$E8/1000","v":30},{"$f":"$D$3*$E8/1000","v":30},null,null,null,null,{"$f":"$D$3*$E8/1000+$D$3*$E11*200/100/1000","v":40}]
[null,{"$f":"IFERROR(--LEFT(C9),B8)","v":1},"галеты","гр.",165,78,{"$f":"giveout($B$8:$F$12,C9,$D$3,E9,F9,B9)","v":0},null,null,null,{"$f":"$D$3*$E9/1000","v":16.5},{"$f":"$D$3*$E9/1000","v":16.5},null,null,null,{"$f":"$D$3*$E9/1000+$D$3*$E11*110/100/1000","v":22}]
[null,1,"хлебцы","гр.",165,98,{"$f":"giveout($B$8:$F$12,C10,$D$3,E10,F10,B10)","v":0},null,null,null,null,null,{"$f":"$D$3*$E10/1000","v":16.5},{"$f":"$D$3*$E10/1000","v":16.5},null,null,{"$f":"$D$3*$E10/1000+$D$3*$E11*110/100/1000","v":22}]
[null,2,"2. Печенье cахарное пакетированное","гр.",50,0,{"$f":"giveout($B$8:$F$12,C11,$D$3,E11,F11,B11)","v":0},null,{"$f":"$D$3*$E11/1000","v":5},null,{"$f":"$D$3*$E11/1000","v":5},null,{"$f":"$D$3*$E11/1000","v":5},null,null,null,null,{"$f":"$D$3*$E11/1000+$D$3*$E8*100/200/1000","v":20}]
[null,2,"вафли","гр.",40,0,{"$f":"giveout($B$8:$F$12,C12,$D$3,E12,F12,B12)","v":0},null,null,{"$f":"$D$3*$E12/1000","v":4},null,{"$f":"$D$3*$E12/1000","v":4},null,{"$f":"$D$3*$E12/1000","v":4},null,null,null,null,{"$f":"$D$3*$E12/1000+$D$3*$E8*80/200/1000","v":16}]
[null,3,"3. Консервы мясные тушеные","гр.",338,70,{"$f":"giveout($B$13:$F$15,C13,$D$3,E13,F13,B13)","v":33.799999999999997}]
[null,4,"4. Консервы рыбные","гр.",250,0,{"$f":"giveout($B$13:$F$15,C14,$D$3,E14,F14,B14)","v":0}]
[null,5,"5. Консервы мясорастительные","банок",1,600,{"$f":"giveout($B$13:$F$15,C15,$D$3,E15,F15,B15)","v":200}]
[null,6,"6. Сахар пакетированный","гр.",60,67,{"$f":"giveout($B$16:$F$22,C16,$D$3,E16,F16,B16)","v":6}]
[null,6,"Сахар (50 кг в мешке)","гр.",60,250,{"$f":"giveout($B$16:$F$22,C17,$D$3,E17,F17,B17)","v":0},null,null,"Вот что заметил:"]
[null,7,"7. Чай пакетированный","гр.",6,7,{"$f":"giveout($B$16:$F$22,C18,$D$3,E18,F18,B18)","v":0.6},null,"1. Если по 2 группе 0, то сахарное печенье заменяется на затяжное или галеты или хлебцы"]
[null,7,"Чай весовой (1 кг в мешке)","гр.",6,125,{"$f":"giveout($B$16:$F$22,C19,$D$3,E19,F19,B19)","v":0},null,null,null,"2. или наоборот если по 1 группе 0, то затяжное меняется на сахарное или вафли"]
[null,8,"8. Карамель","гр.",25,78,{"$f":"giveout($B$16:$F$22,C20,$D$3,E20,F20,B20)","v":2.5}]
[null,{"$f":"IFERROR(--LEFT(C21),#REF!)","v":9},"9. Гематоген","гр.",20,1,{"$f":"giveout($B$16:$F$22,C21,$D$3,E21,F21,B21)","v":0},null,"У меня с этим и был стопор. Показывало перекрестные ссылки и в графах по 0."]
[null,9,"Соки плодовые и ягодные","гр.",200,30,{"$f":"giveout($B$16:$F$22,C22,$D$3,E22,F22,B22)","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]