{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Заставка","Симплекс","МетодМ","СП","РЗ","ММ","ТЗ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":3,"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":100,"n_cols":29,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"H14/$G$11","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["62CA5D80INTERNET"]
[]
[]
[]
[]
["qaz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qaz"]
[]
["62CA5D80INTERNET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,4,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Симплекс","index":1,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
[]
[null,"Max"]
[null,"T-тэта","i","Базис","C_базисное(i)","B(i)",12,7,0,6,0,0,0]
[null,null,null,null,null,null,"X 1","X 2","X 3","X 4","X 5","X 6","X 7"]
[null,0,1,null,0,26,2,15,38,4,0,0,0]
[null,0,2,null,0,24,6,18,6,3,0,0,0]
[null,0,3,null,0,56,8,4,1,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,4,1]

{"sheet":"МетодМ","index":2,"n_rows":100,"n_cols":15,"rows_kept":100,"cut":false,"hidden":true,"merged":[[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
[]
[]
[null,"T-тэта","i","Базис","C_базисное(i)","B(i)",0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"X 1","X 2","X 3","X 4","X 5","X 6","X 7","X 8","X 9"]
[null,0,1,null,0,0]
[null,0,2,null,0,0]
[null,0,3,null,0,0]
[null,0,4,null,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"M",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,5,1]

{"sheet":"СП","index":3,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[0.9]
[]
[null,null,"Количество->"]
["Наим. изд.","На скл.","Использ."]
[null,null,{"$f":"MMULT(Vvod1_2,TRANSPOSE(IZM1))","v":{"$error":"#NAME?"}}]
[null,null,{"$error":"#NAME?"}]
[null,null,{"$error":"#NAME?"}]
[null,null,{"$error":"#NAME?"}]
["Уд. Веса в прибыли"]
["Прибыль: по видам изделий",null,null,{"$f":"D12*MAX(D$6,0)^$A$4","v":0},{"$f":"E12*MAX(E$6,0)^$A$4","v":0},0,0,0]
["Всего:",null,null,{"$f":"SUM(Ogr1_2)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,5,1]

{"sheet":"РЗ","index":4,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C18:G18)","v":0},{"$f":"MMULT(VvodRZ_1,TRANSPOSE(OgrRZ_2))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(C19:G19)","v":0},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,{"$f":"SUM(C20:G20)","v":0},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,{"$f":"SUM(C21:G21)","v":0},{"$error":"#NAME?"}]
[]
[null,null,{"$f":"SUMPRODUCT(VvodRZ_1,VvodRZ_2,IzmRZ)","v":{"$error":"#NAME?"}}]
[]
[null,null,{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0},{"$f":"SUM(F18:F21)","v":0},{"$f":"SUM(G18:G21)","v":0}]
[null,null,{"$f":"MMULT(TRANSPOSE(OgrRZ_1),VvodRZ_1)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,5,1]

{"sheet":"ММ","index":5,"n_rows":100,"n_cols":8,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,{"$f":"SUMPRODUCT(VvodMM_1,IzmMM)/DetMM_1","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[null,{"$f":"SUMPRODUCT(VvodMM_2,IzmMM)/DetMM_2","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(C13:G13)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C14:G14)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C15:G15)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(C16:G16)","v":0}]
[null,null,{"$f":"MIN(F_MM_1,F_MM_2)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,5,1,2]

{"sheet":"ТЗ","index":6,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Число перевозок от завода x к складу y:"]
["Заводы:"," Всего"]
[null,{"$f":"SUM(C8:F8)","v":4},1,1,1,1]
[null,{"$f":"SUM(C9:F9)","v":4},1,1,1,1]
[null,4,1,1,1,1]
[null,4,1,1,1,1]
[null,4,1,1,1,1]
[]
["Итого:",null,{"$f":"SUM(C8:C12)","v":5},{"$f":"SUM(D8:D12)","v":5},5,5]
[]
["Потребности складов -->"]
["Заводы:"," Поставки","Затраты на перевозку от завода x к складу y:"]
["Заводы:"]
[]
[]
[]
[]
[]
["Перевозка:",{"$f":"SUM(OgrTZ_5)","v":{"$error":"#NAME?"}},{"$f":"TRANSPOSE(MMULT(TRANSPOSE(TZ_Zatr),IzmTZ))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,5,1]