{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Заявки","Склад1","Склад2","Премиум","Для вычислений","Выбираем склад"],"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":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["29.01.2015 Четверг","Тип склада","БАТОН","ХЛЕБ","КАРТОФЕЛЬ","картошк кр","КАПУСТА","МОРКОВЬ","СВЕКЛА","ЛУК"]
["99","OSN"]
["102","OSN",null,null,100,null,30,30,35,20]
["139","OSN",null,null,60,null,30,30,30]
["120","OSN",null,null,60,null,20,15,10,15]
["121","OSN",null,null,60,null,20,20,null,10]
["135-1","OSN",null,null,100,null,30,30,30,20]
["141","PR",null,null,100,null,40,25,10,10]
["6-1","PR",null,null,120,null,30,35,25,15]
["6-2","PR",null,null,80,null,20,20,30,20]
["7-1","PR",null,null,100,null,40,40,20,20]
["7-2","PR",null,null,120,null,35,35,25,15]
["34-1","PR",null,null,90,null,40,35,20,20]
["34-2","PR",null,null,80,null,35,30,20,20]

{"sheet":"Склад1","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["29.01.2015 Четверг","БАТОН","ХЛЕБ","КАРТОФЕЛЬ","картошк кр","КАПУСТА","МОРКОВЬ","СВЕКЛА","ЛУК"]
[{"$f":"Заявки!A2","v":"99"}]
[{"$f":"Заявки!A3","v":"102"}]
[{"$f":"Заявки!A4","v":"139"},null,null,null,null,30,30,30]
[{"$f":"Заявки!A5","v":"120"},null,null,null,null,20,15,10,15]
[{"$f":"Заявки!A6","v":"121"},null,null,null,null,20,20,null,10]
[{"$f":"Заявки!A7","v":"135-1"},null,null,null,null,30,30,30,20]
[{"$f":"Заявки!A8","v":"141"}]
[{"$f":"Заявки!A9","v":"6-1"}]
[{"$f":"Заявки!A10","v":"6-2"}]
[{"$f":"Заявки!A11","v":"7-1"}]
[{"$f":"Заявки!A12","v":"7-2"}]
[{"$f":"Заявки!A13","v":"34-1"}]
[{"$f":"Заявки!A14","v":"34-2"}]

{"sheet":"Склад2","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["29.01.2015 Четверг","БАТОН","ХЛЕБ","КАРТОФЕЛЬ","картошк кр","КАПУСТА","МОРКОВЬ","СВЕКЛА","ЛУК"]
[{"$f":"Заявки!A2","v":"99"},null,null,{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!E2-Склад1!D2,0)","v":0},{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!F2-Склад1!E2,0)","v":0},{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!G2-Склад1!F2,0)","v":0},{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!H2-Склад1!G2,0)","v":0},{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!I2-Склад1!H2,0)","v":0},{"$f":"IF(Заявки!$B2=\"OSN\",Заявки!J2-Склад1!I2,0)","v":0}]
[{"$f":"Заявки!A3","v":"102"},null,null,{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!E3-Склад1!D3,0)","v":100},{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!F3-Склад1!E3,0)","v":0},{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!G3-Склад1!F3,0)","v":30},{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!H3-Склад1!G3,0)","v":30},{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!I3-Склад1!H3,0)","v":35},{"$f":"IF(Заявки!$B3=\"OSN\",Заявки!J3-Склад1!I3,0)","v":20}]
[{"$f":"Заявки!A4","v":"139"},null,null,{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!E4-Склад1!D4,0)","v":60},{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!F4-Склад1!E4,0)","v":0},{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!G4-Склад1!F4,0)","v":0},{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!H4-Склад1!G4,0)","v":0},{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!I4-Склад1!H4,0)","v":0},{"$f":"IF(Заявки!$B4=\"OSN\",Заявки!J4-Склад1!I4,0)","v":0}]
[{"$f":"Заявки!A5","v":"120"},null,null,{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!E5-Склад1!D5,0)","v":60},{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!F5-Склад1!E5,0)","v":0},{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!G5-Склад1!F5,0)","v":0},{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!H5-Склад1!G5,0)","v":0},{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!I5-Склад1!H5,0)","v":0},{"$f":"IF(Заявки!$B5=\"OSN\",Заявки!J5-Склад1!I5,0)","v":0}]
[{"$f":"Заявки!A6","v":"121"},null,null,{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!E6-Склад1!D6,0)","v":60},{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!F6-Склад1!E6,0)","v":0},{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!G6-Склад1!F6,0)","v":0},{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!H6-Склад1!G6,0)","v":0},{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!I6-Склад1!H6,0)","v":0},{"$f":"IF(Заявки!$B6=\"OSN\",Заявки!J6-Склад1!I6,0)","v":0}]
[{"$f":"Заявки!A7","v":"135-1"},null,null,{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!E7-Склад1!D7,0)","v":100},{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!F7-Склад1!E7,0)","v":0},{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!G7-Склад1!F7,0)","v":0},{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!H7-Склад1!G7,0)","v":0},{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!I7-Склад1!H7,0)","v":0},{"$f":"IF(Заявки!$B7=\"OSN\",Заявки!J7-Склад1!I7,0)","v":0}]
[{"$f":"Заявки!A8","v":"141"},null,null,{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!E8-Склад1!D8,0)","v":0},{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!F8-Склад1!E8,0)","v":0},{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!G8-Склад1!F8,0)","v":0},{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!H8-Склад1!G8,0)","v":0},{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!I8-Склад1!H8,0)","v":0},{"$f":"IF(Заявки!$B8=\"OSN\",Заявки!J8-Склад1!I8,0)","v":0}]
[{"$f":"Заявки!A9","v":"6-1"},null,null,{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!E9-Склад1!D9,0)","v":0},{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!F9-Склад1!E9,0)","v":0},{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!G9-Склад1!F9,0)","v":0},{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!H9-Склад1!G9,0)","v":0},{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!I9-Склад1!H9,0)","v":0},{"$f":"IF(Заявки!$B9=\"OSN\",Заявки!J9-Склад1!I9,0)","v":0}]
[{"$f":"Заявки!A10","v":"6-2"},null,null,{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!E10-Склад1!D10,0)","v":0},{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!F10-Склад1!E10,0)","v":0},{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!G10-Склад1!F10,0)","v":0},{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!H10-Склад1!G10,0)","v":0},{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!I10-Склад1!H10,0)","v":0},{"$f":"IF(Заявки!$B10=\"OSN\",Заявки!J10-Склад1!I10,0)","v":0}]
[{"$f":"Заявки!A11","v":"7-1"},null,null,{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!E11-Склад1!D11,0)","v":0},{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!F11-Склад1!E11,0)","v":0},{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!G11-Склад1!F11,0)","v":0},{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!H11-Склад1!G11,0)","v":0},{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!I11-Склад1!H11,0)","v":0},{"$f":"IF(Заявки!$B11=\"OSN\",Заявки!J11-Склад1!I11,0)","v":0}]
[{"$f":"Заявки!A12","v":"7-2"},null,null,{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!E12-Склад1!D12,0)","v":0},{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!F12-Склад1!E12,0)","v":0},{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!G12-Склад1!F12,0)","v":0},{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!H12-Склад1!G12,0)","v":0},{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!I12-Склад1!H12,0)","v":0},{"$f":"IF(Заявки!$B12=\"OSN\",Заявки!J12-Склад1!I12,0)","v":0}]
[{"$f":"Заявки!A13","v":"34-1"},null,null,{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!E13-Склад1!D13,0)","v":0},{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!F13-Склад1!E13,0)","v":0},{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!G13-Склад1!F13,0)","v":0},{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!H13-Склад1!G13,0)","v":0},{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!I13-Склад1!H13,0)","v":0},{"$f":"IF(Заявки!$B13=\"OSN\",Заявки!J13-Склад1!I13,0)","v":0}]
[{"$f":"Заявки!A14","v":"34-2"},null,null,{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!E14-Склад1!D14,0)","v":0},{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!F14-Склад1!E14,0)","v":0},{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!G14-Склад1!F14,0)","v":0},{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!H14-Склад1!G14,0)","v":0},{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!I14-Склад1!H14,0)","v":0},{"$f":"IF(Заявки!$B14=\"OSN\",Заявки!J14-Склад1!I14,0)","v":0}]

{"sheet":"Премиум","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["29.01.2015 Четверг","БАТОН","ХЛЕБ","КАРТОФЕЛЬ","картошк кр","КАПУСТА","МОРКОВЬ","СВЕКЛА","ЛУК"]
[{"$f":"Заявки!A2","v":"99"},null,null,{"$f":"IF(Заявки!$B2=\"PR\",Заявки!E2,0)","v":0},{"$f":"IF(Заявки!$B2=\"PR\",Заявки!F2,0)","v":0},{"$f":"IF(Заявки!$B2=\"PR\",Заявки!G2,0)","v":0},{"$f":"IF(Заявки!$B2=\"PR\",Заявки!H2,0)","v":0},{"$f":"IF(Заявки!$B2=\"PR\",Заявки!I2,0)","v":0},{"$f":"IF(Заявки!$B2=\"PR\",Заявки!J2,0)","v":0}]
[{"$f":"Заявки!A3","v":"102"},null,null,{"$f":"IF(Заявки!$B3=\"PR\",Заявки!E3,0)","v":0},{"$f":"IF(Заявки!$B3=\"PR\",Заявки!F3,0)","v":0},{"$f":"IF(Заявки!$B3=\"PR\",Заявки!G3,0)","v":0},{"$f":"IF(Заявки!$B3=\"PR\",Заявки!H3,0)","v":0},{"$f":"IF(Заявки!$B3=\"PR\",Заявки!I3,0)","v":0},{"$f":"IF(Заявки!$B3=\"PR\",Заявки!J3,0)","v":0}]
[{"$f":"Заявки!A4","v":"139"},null,null,{"$f":"IF(Заявки!$B4=\"PR\",Заявки!E4,0)","v":0},{"$f":"IF(Заявки!$B4=\"PR\",Заявки!F4,0)","v":0},{"$f":"IF(Заявки!$B4=\"PR\",Заявки!G4,0)","v":0},{"$f":"IF(Заявки!$B4=\"PR\",Заявки!H4,0)","v":0},{"$f":"IF(Заявки!$B4=\"PR\",Заявки!I4,0)","v":0},{"$f":"IF(Заявки!$B4=\"PR\",Заявки!J4,0)","v":0}]
[{"$f":"Заявки!A5","v":"120"},null,null,{"$f":"IF(Заявки!$B5=\"PR\",Заявки!E5,0)","v":0},{"$f":"IF(Заявки!$B5=\"PR\",Заявки!F5,0)","v":0},{"$f":"IF(Заявки!$B5=\"PR\",Заявки!G5,0)","v":0},{"$f":"IF(Заявки!$B5=\"PR\",Заявки!H5,0)","v":0},{"$f":"IF(Заявки!$B5=\"PR\",Заявки!I5,0)","v":0},{"$f":"IF(Заявки!$B5=\"PR\",Заявки!J5,0)","v":0}]
[{"$f":"Заявки!A6","v":"121"},null,null,{"$f":"IF(Заявки!$B6=\"PR\",Заявки!E6,0)","v":0},{"$f":"IF(Заявки!$B6=\"PR\",Заявки!F6,0)","v":0},{"$f":"IF(Заявки!$B6=\"PR\",Заявки!G6,0)","v":0},{"$f":"IF(Заявки!$B6=\"PR\",Заявки!H6,0)","v":0},{"$f":"IF(Заявки!$B6=\"PR\",Заявки!I6,0)","v":0},{"$f":"IF(Заявки!$B6=\"PR\",Заявки!J6,0)","v":0}]
[{"$f":"Заявки!A7","v":"135-1"},null,null,{"$f":"IF(Заявки!$B7=\"PR\",Заявки!E7,0)","v":0},{"$f":"IF(Заявки!$B7=\"PR\",Заявки!F7,0)","v":0},{"$f":"IF(Заявки!$B7=\"PR\",Заявки!G7,0)","v":0},{"$f":"IF(Заявки!$B7=\"PR\",Заявки!H7,0)","v":0},{"$f":"IF(Заявки!$B7=\"PR\",Заявки!I7,0)","v":0},{"$f":"IF(Заявки!$B7=\"PR\",Заявки!J7,0)","v":0}]
[{"$f":"Заявки!A8","v":"141"},null,null,{"$f":"IF(Заявки!$B8=\"PR\",Заявки!E8,0)","v":100},{"$f":"IF(Заявки!$B8=\"PR\",Заявки!F8,0)","v":0},{"$f":"IF(Заявки!$B8=\"PR\",Заявки!G8,0)","v":40},{"$f":"IF(Заявки!$B8=\"PR\",Заявки!H8,0)","v":25},{"$f":"IF(Заявки!$B8=\"PR\",Заявки!I8,0)","v":10},{"$f":"IF(Заявки!$B8=\"PR\",Заявки!J8,0)","v":10}]
[{"$f":"Заявки!A9","v":"6-1"},null,null,{"$f":"IF(Заявки!$B9=\"PR\",Заявки!E9,0)","v":120},{"$f":"IF(Заявки!$B9=\"PR\",Заявки!F9,0)","v":0},{"$f":"IF(Заявки!$B9=\"PR\",Заявки!G9,0)","v":30},{"$f":"IF(Заявки!$B9=\"PR\",Заявки!H9,0)","v":35},{"$f":"IF(Заявки!$B9=\"PR\",Заявки!I9,0)","v":25},{"$f":"IF(Заявки!$B9=\"PR\",Заявки!J9,0)","v":15}]
[{"$f":"Заявки!A10","v":"6-2"},null,null,{"$f":"IF(Заявки!$B10=\"PR\",Заявки!E10,0)","v":80},{"$f":"IF(Заявки!$B10=\"PR\",Заявки!F10,0)","v":0},{"$f":"IF(Заявки!$B10=\"PR\",Заявки!G10,0)","v":20},{"$f":"IF(Заявки!$B10=\"PR\",Заявки!H10,0)","v":20},{"$f":"IF(Заявки!$B10=\"PR\",Заявки!I10,0)","v":30},{"$f":"IF(Заявки!$B10=\"PR\",Заявки!J10,0)","v":20}]
[{"$f":"Заявки!A11","v":"7-1"},null,null,{"$f":"IF(Заявки!$B11=\"PR\",Заявки!E11,0)","v":100},{"$f":"IF(Заявки!$B11=\"PR\",Заявки!F11,0)","v":0},{"$f":"IF(Заявки!$B11=\"PR\",Заявки!G11,0)","v":40},{"$f":"IF(Заявки!$B11=\"PR\",Заявки!H11,0)","v":40},{"$f":"IF(Заявки!$B11=\"PR\",Заявки!I11,0)","v":20},{"$f":"IF(Заявки!$B11=\"PR\",Заявки!J11,0)","v":20}]
[{"$f":"Заявки!A12","v":"7-2"},null,null,{"$f":"IF(Заявки!$B12=\"PR\",Заявки!E12,0)","v":120},{"$f":"IF(Заявки!$B12=\"PR\",Заявки!F12,0)","v":0},{"$f":"IF(Заявки!$B12=\"PR\",Заявки!G12,0)","v":35},{"$f":"IF(Заявки!$B12=\"PR\",Заявки!H12,0)","v":35},{"$f":"IF(Заявки!$B12=\"PR\",Заявки!I12,0)","v":25},{"$f":"IF(Заявки!$B12=\"PR\",Заявки!J12,0)","v":15}]
[{"$f":"Заявки!A13","v":"34-1"},null,null,{"$f":"IF(Заявки!$B13=\"PR\",Заявки!E13,0)","v":90},{"$f":"IF(Заявки!$B13=\"PR\",Заявки!F13,0)","v":0},{"$f":"IF(Заявки!$B13=\"PR\",Заявки!G13,0)","v":40},{"$f":"IF(Заявки!$B13=\"PR\",Заявки!H13,0)","v":35},{"$f":"IF(Заявки!$B13=\"PR\",Заявки!I13,0)","v":20},{"$f":"IF(Заявки!$B13=\"PR\",Заявки!J13,0)","v":20}]
[{"$f":"Заявки!A14","v":"34-2"},null,null,{"$f":"IF(Заявки!$B14=\"PR\",Заявки!E14,0)","v":80},{"$f":"IF(Заявки!$B14=\"PR\",Заявки!F14,0)","v":0},{"$f":"IF(Заявки!$B14=\"PR\",Заявки!G14,0)","v":35},{"$f":"IF(Заявки!$B14=\"PR\",Заявки!H14,0)","v":30},{"$f":"IF(Заявки!$B14=\"PR\",Заявки!I14,0)","v":20},{"$f":"IF(Заявки!$B14=\"PR\",Заявки!J14,0)","v":20}]

{"sheet":"Для вычислений","index":4,"n_rows":35,"n_cols":42,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["29.01.2015 Четверг","БАТОН","ХЛЕБ","КАРТОФЕЛЬ","картошк кр","КАПУСТА","МОРКОВЬ","СВЕКЛА","ЛУК","ЯБЛОКИ","ЯБЛ ЗЕЛ","ГРУША","АПЕЛЬСИН","МАНДАРИН","БАНАН","ЛИМОН","ЧЕСНОК","ОГУР СОЛ","КАП КВАШ","ОГУР СВ","ТОМАТЫ","ПЕРЕЦ","РЕПА","УКРОП","ПЕТРУШКА","ЛУК ЗЕЛ","КАП ЦВЕТ","КАБАЧКИ","КАП КИТ","БАКЛАЖАНЫ","РЕДИС","ТЫКВА ","СЕЛЬДЕРЕЙ","ЩАВЕЛЬ","КИВИ","ВИНОГРАД","СЛИВА","ЧЕРЕШНЯ","Персики","абрикос","Брюс. Кап","Чищ Карт"]
["99"]
["102"]
["139"]
["120"]
["121"]
["135-1"]
["141"]
["6-1"]
["6-2"]
["7-1"]
["7-2"]
["34-1"]
["34-2"]
[]
["36"]
["113"]
["140"]
["хосп-3"]
["Иоффе"]
["Мичур"]
["66-К"]
["701-К"]
["83-К"]
["295"]
["122"]
["вес",0,0]
["Шевченко Э.В.",0,0]
["37"]
["83"]
["110"]
["129"]
["128-1"]
["128-2"]
["53 д/д"]

{"sheet":"Выбираем склад","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Склад2",null,null,null,null,null,null,null,null,null,null,"Склад1",{"$f":"A1","v":"Склад2"}]
[null,null,null,null,null,null,null,null,null,null,null,"Склад2"]
[]
["Типы складов"]
["Основные","OSN"]
["Премиум","PR"]