{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Случайна выборка","Онраниченный перебор","Тест2"],"not_rendered":{"charts":0,"images":1,"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":"Случайна выборка","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[521848.8,null,"Минимальная выборка",1,null,482170.15]
[286898.40000000002,null,"Максимальная выборка",19,null,849792.25]
[64931.05,null,"Количествово чисел",{"$f":"COUNT(A:A)","v":19},null,64931.05]
[395516.9,null,null,null,null,2168335.7000000002]
[701050.2,null,"Желаемая сумма",9189949,null,701050.2]
[2725062,null,"Допустимая погрешность ±",100,null,142031.85]
[849792.25,null,"Возможных комбинаций",{"$f":"SUMPRODUCT(COMBIN(D3,ROW(INDEX(A:A,D1+1):INDEX(A:A,D2+1))-1))","v":524287},null,306917.59999999998]
[482170.15,null,null,null,null,2201775.75]
[2272883.9,null,"Подобранная сумма",{"$f":"SUM(F:F)","v":9189888.4499999993},null,2272883.9]
[1518399,null,"Отклонение",{"$f":"D9-D5","v":-60.550000000745058}]
[2600603.1]
[1493963.95]
[375053.9]
[2101802.5499999998]
[2168335.7000000002]
[352513.1]
[306917.59999999998,null,"В основе идея Николая Павлова"]
[2201775.75,null,"http://www.planetaexcel.ru/techniques/11/179/"]
[142031.85]
[]
[null,null,"См. колонка F"]

{"sheet":"Онраниченный перебор","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[521848.8,null,"Минимальная выборка",1,null,"=2600603,1+2201775,75+2101802,55+1518399+395516,9+306917,6+64931,05",9189945.9499999993]
[286898.40000000002,null,"Максимальная выборка",19,null,"=2600603,1+2168335,7+1518399+849792,25+701050,2+482170,15+375053,9+352513,1+142031,85",9189949.25]
[64931.05,null,"Количествово чисел",{"$f":"COUNT(A:A)","v":19},null,"=2168335,7+2101802,55+1493963,95+849792,25+521848,8+482170,15+395516,9+375053,9+352513,1+306917,6+142031,85",9189946.75]
[395516.9]
[701050.2,null,"Желаемая сумма",9189949]
[2725062,null,"Допустимая погрешность ±",10]
[849792.25,null,"Возможных комбинаций",{"$f":"SUMPRODUCT(COMBIN(D3,ROW(INDEX(A:A,D1+1):INDEX(A:A,D2+1))-1))","v":524287}]
[482170.15]
[2272883.9,null,"Подобранная сумма",{"$f":"SUM(F:F)","v":0}]
[1518399,null,"Отклонение",{"$f":"D9-D5","v":-9189949}]
[2600603.1]
[1493963.95]
[375053.9]
[2101802.5499999998]
[2168335.7000000002]
[352513.1]
[306917.59999999998,null,"Сложность алгоритма O(2^n), в случае перебора всех вариантов"]
[2201775.75,null,"При ограничении по слагаемым, количество перебираемых вариантов"]
[142031.85,null,"определяется по формуле"]
[]
[]
[]
[null,null,"За счет отсечения неоптимальных вариантов, скорость перебора приемлема"]

{"sheet":"Тест2","index":2,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[521848.8,null,"Минимальная выборка",1,null,"=2600603,1+2201775,75+2101802,55+1518399+395516,9+306917,6+64931,05",9189945.9499999993]
[286898.40000000002,null,"Максимальная выборка",19,null,"=2600603,1+2168335,7+1518399+849792,25+701050,2+482170,15+375053,9+352513,1+142031,85",9189949.25]
[64931.05,null,"Количествово чисел",{"$f":"COUNT(A:A)","v":19},null,"=2168335,7+2101802,55+1493963,95+849792,25+521848,8+482170,15+395516,9+375053,9+352513,1+306917,6+142031,85",9189946.75]
[395516.9]
[701050.2,null,"Желаемая сумма",9189949]
[2725062,null,"Допустимая погрешность ±",10]
[849792.25,null,"Возможных комбинаций",{"$f":"SUMPRODUCT(COMBIN(D3,ROW(INDEX(A:A,D1+1):INDEX(A:A,D2+1))-1))","v":524287}]
[482170.15]
[2272883.9,null,"Подобранная сумма",{"$f":"SUM(F:F)","v":0}]
[1518399,null,"Отклонение",{"$f":"D9-D5","v":-9189949}]
[2600603.1]
[1493963.95]
[375053.9]
[2101802.5499999998]
[2168335.7000000002]
[352513.1]
[306917.59999999998]
[2201775.75]
[142031.85]