{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Лист1","index":0,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[[7,8,12,8],[14,6,24,6]]}
["номер","Вес","Объем","Результат поиска",null,null,null,null,null,"Цена",null,null,null,null,"Комбинирование значений"]
[1,17,70,"1+22",null,null,"Ограничения",null,null,{"$f":"MAX(B2*RANDBETWEEN(6900,7150),C2*RANDBETWEEN(1690,1800))","v":125370},null,null,null,null,"Должно получиться значение таблиц из можества А(2:101) и б(2:101). При этом а>14 и <20 Б>70 и <84 (Т.е. 1 полученное значение из множеств"]
[2,3,11,"1+34",null,null,"Вес","Объём","Цена",{"$f":"MAX(B3*RANDBETWEEN(6900,7150),C3*RANDBETWEEN(1690,1800))","v":20802},null,null,null,null,"2ое полученное значение из множеств Е2"]
[3,16,{"$f":"ROUND(65*RAND()+20,0)","v":76},"1+62",null,"min",14,70,145000,134672,null,null,null,null,"3ое полученное значение из множеств Е2"]
[4,2,43,"1+74",null,"max",20,84,"-",72670,null,null,null,null,"4ое полученное значение из множеств Е2"]
[5,11,32,"1+87",null,null,null,null,null,77176,null,null,null,null,"И так далее."]
[6,{"$f":"ROUND(17*RAND()+3,0)","v":8},28,"1+95",null,null,null,null,null,56544]
[7,16,73,"2+13",null,null,null,null,"<-Хотелось бы поменять,чтобы все цены находились в столбце D, а все результаты поиска перенести на ячейки E) А так же включить в поиск цены и их значение (только минимум из I4)",129356]
[8,3,69,"2+18",null,null,null,null,null,122613]
[9,8,83,"2+20",null,null,null,null,null,148238]
[10,10,78,"2+26",null,null,null,null,null,136812]
[11,9,34,"2+46",null,null,null,null,null,63297," <- Эту колонку перенести в D столбец"]
[12,16,85,"2+84",null,null,null,null,null,144925]
[13,4,57,7,null,null,null,null,null,100719]
[14,16,47,"8+32",null,null,"После окончания и выведения \"результат поиска\" Хотелось бы добавить вывод 3ех (можно больше) итоговых максимальных значений по сумме в колонки правее ",null,null,113328]
[15,4,39,"8+42",null,null,null,null,null,66456]
[16,9,24,"8+62",null,null,null,null,null,63990]
[17,8,84,"8+75",null,null,null,"Максимум 1ый(Номер комбинации из поиска)","1)->итоговый вес,объем и цена 1ого максимума",145404]
[18,6,39,"8+84",null,null,null,"Максимум 2ой(Номер комбинации из поиска)","2)->итоговый вес,объем и цена 2ого максимума",66846]
[19,16,41,"10+42",null,null,null,"Максимум 3ий(Номер комбинации из поиска)","3)->итоговый вес,объем и цена 3ого максимума",113312]
[20,18,35,"10+62",null,null,null,null,null,127872]
[21,11,79,"10+74",null,null,null,null,null,135169]
[22,8,73,"10+87",null,null,null,null,null,126728]
[23,12,27,"10+95",null,null,null,null,null,84528]
[24,9,33,"13+18",null,null,null,null,null,62325]
[25,15,63,"13+27",null,null,null,null,null,111762]
[26,5,80,"13+28",null,null,null,null,null,141520]
[27,20,62,"13+32+75",null,null,null,null,null,140400]
[28,4,21,"13+35",null,null,null,null,null,35637]
[29,15,73,"13+46",null,null,null,null,null,124319]
[30,5,59,"13+61",null,null,null,null,null,105315]
[31,6,79,"15+26",null,null,null,null,null,135248]
[32,8,51,"15+42",null,null,null,null,null,87567]
[33,17,78,"15+62",null,null,null,null,null,139698]
[34,19,26,"15+84",null,null,null,null,null,134881]
[35,6,28,"16+52",null,null,null,null,null,50148]
[36,18,40,17,null,null,null,null,null,125154]
[37,8,36,"18+19",null,null,null,null,null,64548]
[38,12,60,"18+27",null,null,null,null,null,107520]
[39,3,55,"18+28",null,null,null,null,null,96690]
[40,6,59,"18+32+75",null,null,null,null,null,104902]
[41,6,27,"18+35",null,null,null,null,null,47331]
[42,19,31,"18+46",null,null,null,null,null,132810]
[43,12,71,"18+94",null,null,null,null,null,123611]
[44,12,43,"19+20",null,null,null,null,null,84468]
[45,12,71,"19+26",null,null,null,null,null,120913]
[46,18,67,"19+52",null,null,null,null,null,125028]
[47,3,69,"20+27",null,null,null,null,null,116886]
[48,6,25,"20+28",null,null,null,null,null,42864]
[49,3,70,"20+32+42",null,null,null,null,null,120190]
[50,16,83,"20+32+75",null,null,null,null,null,144171]
[51,8,47,"20+94",null,null,null,null,null,80699]
[52,5,59,"22+45",null,null,null,null,null,102188]
[53,18,81,"22+56",null,null,null,null,null,143775]
[54,16,23,"22+64",null,null,null,null,null,110832]
[55,17,77,"22+67",null,null,null,null,null,133364]
[56,17,76,"22+81",null,null,null,null,null,129048]
[57,15,50,"22+89",null,null,null,null,null,103725]
[58,19,71,"23+32",null,null,null,null,null,133665]
[59,7,70,"23+75",null,null,null,null,null,123690]
[60,18,53,"26+27",null,null,null,null,null,126972]
[61,16,66,"26+28",null,null,null,null,null,116292]
[62,4,24,"26+32+42",null,null,null,null,null,40776]
[63,12,40,"26+32+75",null,null,null,null,null,84180]
[64,10,44,"26+94",null,null,null,null,null,76296]
[65,10,38,"27+28",null,null,null,null,null,69710]
[66,{"$f":"ROUND(17*RAND()+3,0)","v":11},{"$f":"ROUND(65*RAND()+20,0)","v":22},"27+46",null,null,null,null,null,{"$f":"MAX(B67*RANDBETWEEN(6900,7150),C67*RANDBETWEEN(1690,1800))","v":78397}]
[67,12,30,"27+61",null,null,null,null,null,82896]
[68,5,78,"28+46",null,null,null,null,null,136110]
[69,9,35,"28+84",null,null,null,null,null,64080]
[70,13,33,"29+32",null,null,null,null,null,90779]
[71,3,45,"29+75",null,null,null,null,null,78075]
[72,12,83,30,null,null,null,null,null,146080]
[73,13,79,"32+46+75",null,null,null,null,null,133905]
[74,7,26,"32+75+84",null,null,null,null,null,48937]
[75,6,85,"32+83",null,null,null,null,null,144415]
[76,19,26,"34+64",null,null,null,null,null,132259]
[77,10,37,"35+46",null,null,null,null,null,69210]
[78,7,59,"35+61",null,null,null,null,null,103840]
[79,8,50,"35+89",null,null,null,null,null,85950]
[80,17,23,"39+52",null,null,null,null,null,118524]
[81,15,22,"42+61",null,null,null,null,null,106020]
[82,11,76,"42+89",null,null,null,null,null,129352]
[83,13,28,"45+87",null,null,null,null,null,92196]
[84,12,52,"45+95",null,null,null,null,null,92456]
[85,11,40,"46+61",null,null,null,null,null,76703]
[86,10,57,50,null,null,null,null,null,99009]
[87,4,55,"52+65",null,null,null,null,null,93280]
[88,20,30,"52+77",null,null,null,null,null,138100]
[89,7,42,"52+80",null,null,null,null,null,71988]
[90,12,50,"52+86",null,null,null,null,null,86800]
[91,4,51,"56+87",null,null,null,null,null,87516]
[92,19,76,"56+95",null,null,null,null,null,133228]
[93,18,42,"61+62",null,null,null,null,null,124920]
[94,7,59,"61+74",null,null,null,null,null,99946]
[95,20,32,"61+84",null,null,null,null,null,142360]
[96,13,70,"62+64",null,null,null,null,null,120470]
[97,7,28,"62+89",null,null,null,null,null,49651]
[98,18,45,"64+87",null,null,null,null,null,126684]
[99,4,85,"64+95",null,null,null,null,null,143820]
[100,17,74,"67+95",null,null,null,null,null,{"$f":"MAX(B101*RANDBETWEEN(6900,7150),C101*RANDBETWEEN(1690,1800))","v":127872}]
[null,null,null,"74+89"]
[null,null,null,"75+83"]
[null,null,null,"81+87"]
[null,null,null,"81+95"]
[null,null,null,"84+89"]
[null,null,null,"87+89"]
[null,null,null,"89+95"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}