{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Онраниченный перебор"],"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":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[165,null,"Минимальная выборка",1,null,"=165+160+85",410]
[160,null,"Максимальная выборка",10,null,"=165+160+70",395]
[135,null,"Количествово чисел",{"$f":"COUNT(A:A)","v":8},null,"=165+135+110",410]
[125,null,null,null,null,"=165+135+100",400]
[110,null,"Желаемая сумма",420,null,"=165+135+85",385]
[100,null,"Допустимая погрешность -",60,null,"=165+135+70",370]
[85,null,"Допустимая погрешность +",0,null,"=165+125+110",400]
[70,null,"Возможных комбинаций",{"$f":"SUMPRODUCT(COMBIN(D3,ROW(INDEX(A:A,D1+1):INDEX(A:A,D2+1))-1))","v":{"$error":"#NUM!"}},null,"=165+125+100",390]
[null,null,"Подобранная сумма",{"$f":"SUM(F:F)","v":0},null,"=165+125+85",375]
[null,null,"Отклонение",{"$f":"D9-D5","v":-420},null,"=165+125+70",360]
[null,null,null,null,null,"=165+110+100",375]
[null,null,null,null,null,"=165+110+85",360]
[null,null,null,null,null,"=160+135+125",420]
[null,null,null,null,null,"=160+135+110",405]
[null,null,null,null,null,"=160+135+100",395]
[null,null,null,null,null,"=160+135+85",380]
[null,null,"Сложность алгоритма O(2^n), в случае перебора всех вариантов",null,null,"=160+135+70",365]
[null,null,"При ограничении по слагаемым, количество перебираемых вариантов",null,null,"=160+125+110",395]
[null,null,"определяется по формуле",null,null,"=160+125+100",385]
[null,null,null,null,null,"=160+125+85",370]
[null,null,null,null,null,"=160+110+100",370]
[null,null,null,null,null,"=135+125+110",370]
[null,null,"За счет отсечения неоптимальных вариантов, скорость перебора приемлема",null,null,"=135+125+100",360]
[null,null,null,null,null,"=165+100+85+70",420]
[null,null,null,null,null,"=160+100+85+70",415]
[null,null,null,null,null,"=135+125+85+70",415]
[null,null,null,null,null,"=135+110+100+70",415]
[null,null,null,null,null,"=135+110+85+70",400]
[null,null,null,null,null,"=135+100+85+70",390]
[null,null,null,null,null,"=125+110+100+85",420]
[null,null,null,null,null,"=125+110+100+70",405]
[null,null,null,null,null,"=125+110+85+70",390]
[null,null,null,null,null,"=125+100+85+70",380]
[null,null,null,null,null,"=110+100+85+70",365]