{"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":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":false,"merged":[[7,9,12,9],[14,7,24,7]]}
["номер","Вес","Объем","Цена","Результат поиска",null,null,null,null,null,null,null,null,null,null,"Комбинирование значений"]
[1,17,70,{"$f":"MAX(B2*RANDBETWEEN(6900,7150),C2*RANDBETWEEN(1690,1800))","v":118626},3,null,null,"Ограничения",null,null,null,null,null,null,null,"Должно получиться значение таблиц из можества А(2:101) и б(2:101). При этом а>14 и <20 Б>70 и <84 (Т.е. 1 полученное значение из множеств"]
[2,3,11,{"$f":"MAX(B3*RANDBETWEEN(6900,7150),C3*RANDBETWEEN(1690,1800))","v":21270},20,null,null,"Вес","Объём","Цена",null,null,null,null,null,"2ое полученное значение из множеств Е2"]
[3,16,{"$f":"ROUND(65*RAND()+20,0)","v":72},{"$f":"MAX(B4*RANDBETWEEN(6900,7150),C4*RANDBETWEEN(1690,1800))","v":126648},"25+54",null,"min",14,70,100000,null,null,null,null,null,"3ое полученное значение из множеств Е2"]
[4,2,76,{"$f":"MAX(B5*RANDBETWEEN(6900,7150),C5*RANDBETWEEN(1690,1800))","v":132772},"25+57",null,"max",20,84,"-",null,null,null,null,null,"4ое полученное значение из множеств Е2"]
[5,11,34,{"$f":"MAX(B6*RANDBETWEEN(6900,7150),C6*RANDBETWEEN(1690,1800))","v":77187},"25+75",null,null,null,null,null,null,null,null,null,null,"И так далее."]
[6,{"$f":"ROUND(17*RAND()+3,0)","v":13},58,{"$f":"MAX(B7*RANDBETWEEN(6900,7150),C7*RANDBETWEEN(1690,1800))","v":99702},"25+90"]
[7,14,81,{"$f":"MAX(B8*RANDBETWEEN(6900,7150),C8*RANDBETWEEN(1690,1800))","v":138348},"27+75",null,null,null,null,"<-Хотелось бы поменять,чтобы все цены находились в столбце D, а все результаты поиска перенести на ячейки E) А так же включить в поиск цены и их значение (только минимум из I4)"]
[8,19,23,{"$f":"MAX(B9*RANDBETWEEN(6900,7150),C9*RANDBETWEEN(1690,1800))","v":133361},36]
[9,10,72,{"$f":"MAX(B10*RANDBETWEEN(6900,7150),C10*RANDBETWEEN(1690,1800))","v":129600},84]
[10,18,44,{"$f":"MAX(B11*RANDBETWEEN(6900,7150),C11*RANDBETWEEN(1690,1800))","v":127836}]
[11,16,57,{"$f":"MAX(B12*RANDBETWEEN(6900,7150),C12*RANDBETWEEN(1690,1800))","v":112784},null,null,null,null,null,null,null," <- Эту колонку перенести в D столбец"]
[12,20,39,{"$f":"MAX(B13*RANDBETWEEN(6900,7150),C13*RANDBETWEEN(1690,1800))","v":142460}]
[13,18,69,{"$f":"MAX(B14*RANDBETWEEN(6900,7150),C14*RANDBETWEEN(1690,1800))","v":124254}]
[14,6,28,{"$f":"MAX(B15*RANDBETWEEN(6900,7150),C15*RANDBETWEEN(1690,1800))","v":48300},null,null,null,"После окончания и выведения \"результат поиска\" Хотелось бы добавить вывод 3ех (можно больше) итоговых максимальных значений по сумме в колонки правее "]
[15,15,61,{"$f":"MAX(B16*RANDBETWEEN(6900,7150),C16*RANDBETWEEN(1690,1800))","v":108092}]
[16,10,38,{"$f":"MAX(B17*RANDBETWEEN(6900,7150),C17*RANDBETWEEN(1690,1800))","v":70120}]
[17,8,74,{"$f":"MAX(B18*RANDBETWEEN(6900,7150),C18*RANDBETWEEN(1690,1800))","v":129278},null,null,null,null,"Максимум 1ый(Номер комбинации из поиска)","1)->итоговый вес,объем и цена 1ого максимума"]
[18,11,81,{"$f":"MAX(B19*RANDBETWEEN(6900,7150),C19*RANDBETWEEN(1690,1800))","v":138672},null,null,null,null,"Максимум 2ой(Номер комбинации из поиска)","2)->итоговый вес,объем и цена 2ого максимума"]
[19,15,64,{"$f":"MAX(B20*RANDBETWEEN(6900,7150),C20*RANDBETWEEN(1690,1800))","v":109632},null,null,null,null,"Максимум 3ий(Номер комбинации из поиска)","3)->итоговый вес,объем и цена 3ого максимума"]
[20,18,78,{"$f":"MAX(B21*RANDBETWEEN(6900,7150),C21*RANDBETWEEN(1690,1800))","v":140088}]
[21,16,23,{"$f":"MAX(B22*RANDBETWEEN(6900,7150),C22*RANDBETWEEN(1690,1800))","v":111280}]
[22,12,67,{"$f":"MAX(B23*RANDBETWEEN(6900,7150),C23*RANDBETWEEN(1690,1800))","v":120332}]
[23,17,51,{"$f":"MAX(B24*RANDBETWEEN(6900,7150),C24*RANDBETWEEN(1690,1800))","v":118507}]
[24,14,40,{"$f":"MAX(B25*RANDBETWEEN(6900,7150),C25*RANDBETWEEN(1690,1800))","v":99120}]
[25,9,58,{"$f":"MAX(B26*RANDBETWEEN(6900,7150),C26*RANDBETWEEN(1690,1800))","v":103298}]
[26,16,26,{"$f":"MAX(B27*RANDBETWEEN(6900,7150),C27*RANDBETWEEN(1690,1800))","v":112560}]
[27,12,59,{"$f":"MAX(B28*RANDBETWEEN(6900,7150),C28*RANDBETWEEN(1690,1800))","v":101598}]
[28,5,62,{"$f":"MAX(B29*RANDBETWEEN(6900,7150),C29*RANDBETWEEN(1690,1800))","v":110980}]
[29,17,34,{"$f":"MAX(B30*RANDBETWEEN(6900,7150),C30*RANDBETWEEN(1690,1800))","v":119272}]
[30,10,70,{"$f":"MAX(B31*RANDBETWEEN(6900,7150),C31*RANDBETWEEN(1690,1800))","v":126000}]
[31,5,70,{"$f":"MAX(B32*RANDBETWEEN(6900,7150),C32*RANDBETWEEN(1690,1800))","v":125090}]
[32,7,35,{"$f":"MAX(B33*RANDBETWEEN(6900,7150),C33*RANDBETWEEN(1690,1800))","v":62195}]
[33,18,31,{"$f":"MAX(B34*RANDBETWEEN(6900,7150),C34*RANDBETWEEN(1690,1800))","v":124920}]
[34,4,77,{"$f":"MAX(B35*RANDBETWEEN(6900,7150),C35*RANDBETWEEN(1690,1800))","v":134519}]
[35,17,57,{"$f":"MAX(B36*RANDBETWEEN(6900,7150),C36*RANDBETWEEN(1690,1800))","v":117606}]
[36,15,71,{"$f":"MAX(B37*RANDBETWEEN(6900,7150),C37*RANDBETWEEN(1690,1800))","v":120416}]
[37,12,41,{"$f":"MAX(B38*RANDBETWEEN(6900,7150),C38*RANDBETWEEN(1690,1800))","v":85632}]
[38,15,38,{"$f":"MAX(B39*RANDBETWEEN(6900,7150),C39*RANDBETWEEN(1690,1800))","v":104295}]
[39,17,64,{"$f":"MAX(B40*RANDBETWEEN(6900,7150),C40*RANDBETWEEN(1690,1800))","v":118031}]
[40,7,69,{"$f":"MAX(B41*RANDBETWEEN(6900,7150),C41*RANDBETWEEN(1690,1800))","v":119853}]
[41,11,65,{"$f":"MAX(B42*RANDBETWEEN(6900,7150),C42*RANDBETWEEN(1690,1800))","v":112970}]
[42,12,47,{"$f":"MAX(B43*RANDBETWEEN(6900,7150),C43*RANDBETWEEN(1690,1800))","v":85272}]
[43,19,34,{"$f":"MAX(B44*RANDBETWEEN(6900,7150),C44*RANDBETWEEN(1690,1800))","v":132943}]
[44,8,82,{"$f":"MAX(B45*RANDBETWEEN(6900,7150),C45*RANDBETWEEN(1690,1800))","v":147272}]
[45,7,85,{"$f":"MAX(B46*RANDBETWEEN(6900,7150),C46*RANDBETWEEN(1690,1800))","v":150875}]
[46,12,82,{"$f":"MAX(B47*RANDBETWEEN(6900,7150),C47*RANDBETWEEN(1690,1800))","v":144730}]
[47,5,26,{"$f":"MAX(B48*RANDBETWEEN(6900,7150),C48*RANDBETWEEN(1690,1800))","v":45630}]
[48,17,30,{"$f":"MAX(B49*RANDBETWEEN(6900,7150),C49*RANDBETWEEN(1690,1800))","v":120972}]
[49,18,36,{"$f":"MAX(B50*RANDBETWEEN(6900,7150),C50*RANDBETWEEN(1690,1800))","v":125154}]
[50,13,78,{"$f":"MAX(B51*RANDBETWEEN(6900,7150),C51*RANDBETWEEN(1690,1800))","v":136110}]
[51,9,64,{"$f":"MAX(B52*RANDBETWEEN(6900,7150),C52*RANDBETWEEN(1690,1800))","v":111424}]
[52,18,38,{"$f":"MAX(B53*RANDBETWEEN(6900,7150),C53*RANDBETWEEN(1690,1800))","v":127026}]
[53,3,63,{"$f":"MAX(B54*RANDBETWEEN(6900,7150),C54*RANDBETWEEN(1690,1800))","v":110439}]
[54,9,25,{"$f":"MAX(B55*RANDBETWEEN(6900,7150),C55*RANDBETWEEN(1690,1800))","v":62307}]
[55,8,26,{"$f":"MAX(B56*RANDBETWEEN(6900,7150),C56*RANDBETWEEN(1690,1800))","v":56632}]
[56,10,41,{"$f":"MAX(B57*RANDBETWEEN(6900,7150),C57*RANDBETWEEN(1690,1800))","v":73513}]
[57,6,25,{"$f":"MAX(B58*RANDBETWEEN(6900,7150),C58*RANDBETWEEN(1690,1800))","v":42525}]
[58,20,52,{"$f":"MAX(B59*RANDBETWEEN(6900,7150),C59*RANDBETWEEN(1690,1800))","v":142480}]
[59,17,60,{"$f":"MAX(B60*RANDBETWEEN(6900,7150),C60*RANDBETWEEN(1690,1800))","v":120309}]
[60,18,45,{"$f":"MAX(B61*RANDBETWEEN(6900,7150),C61*RANDBETWEEN(1690,1800))","v":127530}]
[61,4,58,{"$f":"MAX(B62*RANDBETWEEN(6900,7150),C62*RANDBETWEEN(1690,1800))","v":101732}]
[62,15,57,{"$f":"MAX(B63*RANDBETWEEN(6900,7150),C63*RANDBETWEEN(1690,1800))","v":103560}]
[63,16,56,{"$f":"MAX(B64*RANDBETWEEN(6900,7150),C64*RANDBETWEEN(1690,1800))","v":113344}]
[64,20,71,{"$f":"MAX(B65*RANDBETWEEN(6900,7150),C65*RANDBETWEEN(1690,1800))","v":139120}]
[65,9,74,{"$f":"MAX(B66*RANDBETWEEN(6900,7150),C66*RANDBETWEEN(1690,1800))","v":125726}]
[66,{"$f":"ROUND(17*RAND()+3,0)","v":20},{"$f":"ROUND(65*RAND()+20,0)","v":52},{"$f":"MAX(B67*RANDBETWEEN(6900,7150),C67*RANDBETWEEN(1690,1800))","v":141280}]
[67,18,35,{"$f":"MAX(B68*RANDBETWEEN(6900,7150),C68*RANDBETWEEN(1690,1800))","v":126198}]
[68,7,63,{"$f":"MAX(B69*RANDBETWEEN(6900,7150),C69*RANDBETWEEN(1690,1800))","v":107856}]
[69,4,76,{"$f":"MAX(B70*RANDBETWEEN(6900,7150),C70*RANDBETWEEN(1690,1800))","v":128668}]
[70,8,82,{"$f":"MAX(B71*RANDBETWEEN(6900,7150),C71*RANDBETWEEN(1690,1800))","v":139810}]
[71,12,52,{"$f":"MAX(B72*RANDBETWEEN(6900,7150),C72*RANDBETWEEN(1690,1800))","v":90532}]
[72,15,69,{"$f":"MAX(B73*RANDBETWEEN(6900,7150),C73*RANDBETWEEN(1690,1800))","v":123855}]
[73,8,45,{"$f":"MAX(B74*RANDBETWEEN(6900,7150),C74*RANDBETWEEN(1690,1800))","v":76140}]
[74,12,81,{"$f":"MAX(B75*RANDBETWEEN(6900,7150),C75*RANDBETWEEN(1690,1800))","v":143856}]
[75,6,20,{"$f":"MAX(B76*RANDBETWEEN(6900,7150),C76*RANDBETWEEN(1690,1800))","v":42672}]
[76,11,72,{"$f":"MAX(B77*RANDBETWEEN(6900,7150),C77*RANDBETWEEN(1690,1800))","v":128016}]
[77,12,41,{"$f":"MAX(B78*RANDBETWEEN(6900,7150),C78*RANDBETWEEN(1690,1800))","v":83916}]
[78,8,43,{"$f":"MAX(B79*RANDBETWEEN(6900,7150),C79*RANDBETWEEN(1690,1800))","v":76239}]
[79,10,83,{"$f":"MAX(B80*RANDBETWEEN(6900,7150),C80*RANDBETWEEN(1690,1800))","v":143673}]
[80,8,74,{"$f":"MAX(B81*RANDBETWEEN(6900,7150),C81*RANDBETWEEN(1690,1800))","v":130092}]
[81,6,78,{"$f":"MAX(B82*RANDBETWEEN(6900,7150),C82*RANDBETWEEN(1690,1800))","v":139776}]
[82,17,56,{"$f":"MAX(B83*RANDBETWEEN(6900,7150),C83*RANDBETWEEN(1690,1800))","v":121040}]
[83,6,50,{"$f":"MAX(B84*RANDBETWEEN(6900,7150),C84*RANDBETWEEN(1690,1800))","v":87850}]
[84,15,82,{"$f":"MAX(B85*RANDBETWEEN(6900,7150),C85*RANDBETWEEN(1690,1800))","v":146534}]
[85,13,50,{"$f":"MAX(B86*RANDBETWEEN(6900,7150),C86*RANDBETWEEN(1690,1800))","v":90987}]
[86,5,57,{"$f":"MAX(B87*RANDBETWEEN(6900,7150),C87*RANDBETWEEN(1690,1800))","v":96843}]
[87,9,69,{"$f":"MAX(B88*RANDBETWEEN(6900,7150),C88*RANDBETWEEN(1690,1800))","v":121992}]
[88,9,49,{"$f":"MAX(B89*RANDBETWEEN(6900,7150),C89*RANDBETWEEN(1690,1800))","v":84133}]
[89,13,34,{"$f":"MAX(B90*RANDBETWEEN(6900,7150),C90*RANDBETWEEN(1690,1800))","v":91039}]
[90,6,25,{"$f":"MAX(B91*RANDBETWEEN(6900,7150),C91*RANDBETWEEN(1690,1800))","v":43100}]
[91,12,46,{"$f":"MAX(B92*RANDBETWEEN(6900,7150),C92*RANDBETWEEN(1690,1800))","v":82932}]
[92,6,56,{"$f":"MAX(B93*RANDBETWEEN(6900,7150),C93*RANDBETWEEN(1690,1800))","v":94640}]
[93,16,54,{"$f":"MAX(B94*RANDBETWEEN(6900,7150),C94*RANDBETWEEN(1690,1800))","v":111856}]
[94,15,54,{"$f":"MAX(B95*RANDBETWEEN(6900,7150),C95*RANDBETWEEN(1690,1800))","v":106125}]
[95,10,79,{"$f":"MAX(B96*RANDBETWEEN(6900,7150),C96*RANDBETWEEN(1690,1800))","v":137144}]
[96,12,28,{"$f":"MAX(B97*RANDBETWEEN(6900,7150),C97*RANDBETWEEN(1690,1800))","v":85200}]
[97,8,45,{"$f":"MAX(B98*RANDBETWEEN(6900,7150),C98*RANDBETWEEN(1690,1800))","v":76680}]
[98,19,22,{"$f":"MAX(B99*RANDBETWEEN(6900,7150),C99*RANDBETWEEN(1690,1800))","v":132354}]
[99,13,59,{"$f":"MAX(B100*RANDBETWEEN(6900,7150),C100*RANDBETWEEN(1690,1800))","v":103840}]
[100,10,57,{"$f":"MAX(B101*RANDBETWEEN(6900,7150),C101*RANDBETWEEN(1690,1800))","v":100548}]

{"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":[]}