{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Data","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,10,1,12]]}
[null,"Нужно распределить:",40]
[null,null,null,null,null,null,null,null,null,null,"Должно быть"]
["№","Норматив","Остаток","Необеспеченность","%Необ к данной позиции",null,"Распределение шт.","Необ. посл. распред","%Необ. посл. распред.",null,"распред должен быть","необесп","%необесп"]
[1,500,450,{"$f":"MAX(B4-C4,0)","v":50},{"$f":"D4/B4","v":0.1},null,0,{"$f":"D4-G4","v":50},{"$f":"H4/B4","v":0.1},null,18,{"$f":"B4-C4-K4","v":32},{"$f":"L4/B4","v":6.4000000000000001E-2}]
[2,15,10,{"$f":"MAX(B5-C5,0)","v":5},{"$f":"D5/B5","v":0.33333333333333331},null,0,{"$f":"D5-G5","v":5},{"$f":"H5/B5","v":0.33333333333333331},null,4,{"$f":"B5-C5-K5","v":1},{"$f":"L5/B5","v":6.6666666666666666E-2}]
[3,35,15,20,0.5714285714285714,null,0,{"$f":"D6-G6","v":20},{"$f":"H6/B6","v":0.5714285714285714},null,18,{"$f":"B6-C6-K6","v":2},{"$f":"L6/B6","v":5.7142857142857141E-2}]
[4,20,40,0,0,null,0,{"$f":"D7-G7","v":0},{"$f":"H7/B7","v":0},null,0,0,{"$f":"L7/B7","v":0}]
[5,25,25,0,0,null,0,{"$f":"D8-G8","v":0},{"$f":"H8/B8","v":0},null,0,{"$f":"B8-C8-K8","v":0},{"$f":"L8/B8","v":0}]