{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Lapas1","Lapas2","Lapas3"],"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":"Lapas1","index":0,"n_rows":199,"n_cols":29,"rows_kept":199,"cut":false,"hidden":false,"merged":[[14,16,15,18],[14,19,15,21],[0,0,2,23],[10,16,10,18],[11,16,13,17],[11,18,13,19],[11,20,13,21],[11,24,12,26],[11,27,12,29],[13,24,15,25],[13,26,15,27],[13,28,15,29],[27,4,31,4],[27,5,31,5],[27,6,31,6],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[35,5,38,5],[27,1,31,1],[27,0,31,0],[27,2,31,2],[27,3,31,3]]}
["Есть партия товара сложенная в палеты. Надо отобрать случайным образом, в зависимости от колличества  товара,  для контроля образцы товара. В таблицу 1 вносим данные о партии товара. В таблице 2 надо сделать случайнаю выборку, и расположить по возрастающей какой товар надо взять. Количество палетов, рядов, упаковок может меняться."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 ряд",null,null,null,null,null,null,null,"2 ряд"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 упаковка(1)",null,"2 упаковка(1)",null,"3 упаковка(1)",null,null,null,"1 упаковка(1)",null,null,"2 упаковка(1)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 упаковка(1)",null,"4 упаковка(1)",null,"5 упаковка(1)"]
[null,null,"1ряд",null,null,null,null,null,null,null,null,null,null,null,null,null,"4 упаковка(1)",null,null,"5 упаковка(1)"]
[]
[null,null,"2ряд"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В  упаковке(1) 6 упаковок(2)"]
[null,null,"3 ряд",null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5,6]
[null,null,"4 ряд"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В упаковоке(2) 10 упаковок(3)"]
[null,null,"5 ряд",null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,7,8,9,10]
[]
[]
["Таблица 1"]
["Номер партии","Кол-во трвара для контроля шт.","Кол-во палетов","Кол-во рядов в палете","Кол-во упаковок(1) в ряде","Кол-во упаковок(2) в упакавке(1)","Кол-во упаковок(3) в упакавке(2)"]
[]
[]
[]
[]
[1,20,3,2,5,6,10]
[]
["Таблица 2"]
["Номер выбранного товара","Номер палета","Номер ряда","Упаковка(1)","Упаковка(2)","Упаковка(3)"]
[]
[]
[]
[1,2,1,5,1,10]
[2,1,1,2,2,7]
[3,2,1,3,1,9]
[4,2,2,2,4,3]
[5,1,1,2,1,9]
[6,2,1,5,2,1]
[7,3,2,4,5,5]
[8,3,2,2,1,9]
[9,2,1,2,3,10]
[10,3,1,4,6,7]
[11,2,1,4,6,4]
[12,2,2,2,3,9]
[13,1,2,3,4,2]
[14,2,1,3,5,4]
[15,1,1,1,2,9]
[16,3,2,3,2,5]
[17,1,2,5,4,8]
[18,1,2,4,2,5]
[19,2,2,3,5,9]
[20,1,2,2,6,8]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]

{"sheet":"Lapas2","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["товары"]
[20]
[60]
[80]
[160]

{"sheet":"Lapas3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}