{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["итерации"],"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":"итерации","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"INDEX(RANDBETWEEN({1,6},{4,24}),1+(RAND()>4/23))","v":7},null,"значение","кол-во","всего",{"$f":"IF($B$3,G1,IF($B$2,G1+1,))","v":5000}]
[null,false,null,1,{"$f":"IF($B$3,E2,IF($B$2,IF($B$1=D2,E2+1,E2),))","v":202},"кол-во мин",{"$f":"SMALL(E2:E25,2)","v":196},null,"пуск - запуск пересчета  (и пальчиком на F9)"]
[null,true,null,2,{"$f":"IF($B$3,E3,IF($B$2,IF($B$1=D3,E3+1,E3),))","v":224},"кол-во макс",{"$f":"MAX(E2:E25)","v":258},null,"фиксатор  - фиксирование результата"]
[null,null,null,3,213,"среднее 1-4",{"$f":"AVERAGE(E2:E5)","v":215.75},null,"кнопка - автопересчет по указанному количеству цилов"]
[null,"итераций",null,4,224,"среднее 6-24",{"$f":"AVERAGE(E7:E25)","v":217.73684210526315}]
[null,5000,null,5,0,"среднее общ",{"$f":"IF(SUM(E2:E25),SUM(E2:E25)/COUNTIF(E2:E25,\">0\"),)","v":217.39130434782609}]
[null,null,null,6,248]
[null,null,null,7,225]
[null,null,null,8,228]
[null,null,null,9,226]
[null,null,null,10,214]
[null,null,null,11,225]
[null,null,null,12,222]
[null,null,null,13,221]
[null,null,null,14,197]
[null,null,null,15,199]
[null,null,null,16,202]
[null,null,null,17,201]
[null,null,null,18,205]
[null,null,null,19,258]
[null,null,null,20,204]
[null,null,null,21,196]
[null,null,null,22,199]
[null,null,null,23,232]
[null,null,null,24,235]