Spreadsheet: 717570d1612746556-forumla-to-identify-increments-of-200-sample
Sheet: Sheet1

6
6
6
6
6
-2.790697674418605
8.790697674418604
6
-1.621621621621621
7.621621621621621
-1.578947368421053
-1.848523748395379
9.427471116816433
-5.88235294117647
-3.394957983193277
-10.32250738133091
25.59981830570066
6
-2.857142857142857
8.857142857142858
6
-1.621621621621621
-4.330466830466831
-7.114338364338363
-3.891107513556493
-5.101674295551846
-7.384002269877672
-16.48521436995945
51.92842526537228
-1.714285714285714
7.714285714285714
-1.621621621621621
-1.732186732186732
-3.40138485593031
-3.543109224927406
-4.289026956491071
-4.574962086923809
-9.677804414646518
-10.88752996647733
45.7276258592048
-1.666666666666667
-2.072072072072072
-2.497112497112497
-8.267467051250835
20.50331828710207
6
6
-1.224489795918367
-6.689342403628117
-6.471549860254179
-6.795127353266888
-16.17887465063545
43.359384063703
6
-2.222222222222222
-2.283950617283951
10.50617283950617
-2.608695652173913
-3.130434782608696
-3.786816269284713
15.52594670406732
-1.276595744680851
-1.45531914893617
-1.940425531914893
-2.178028658271819
-2.920538428137212
-5.734875458887616
-5.973828603007934
-8.327155022374695
35.80676659621119
6
6
-2.068965517241379
-1.716801173881144
-3.058052090975788
-6.116104181951577
-6.894517441472686
-9.233728716258062
-20.88581495344085
55.97398407522149
-3.79746835443038
-2.449367088607595
-3.401898734177215
-3.401898734177216
19.05063291139241
-1.395348837209302
7.395348837209302
-5.357142857142857
-2.271428571428571
-4.867346938775511
18.49591836734694
-1.818181818181818
-2.606060606060606
-2.424242424242424
-3.472563472563472
-4.663156663156663
-5.118098776635362
-6.21483422877151
-8.976982774892182
-12.51336992863759
-22.41978778880901
-64.59938854402594
-85.86991891827839
-83.9616984978722
-79.6559703697762
-118.277046912698
508.5913017246014
-1.521739130434783
8.521739130434783
-1.428571428571429
7.428571428571429
-3.225806451612903
-6.497046796910496
-5.823278980934592
-11.70985447253152
-14.15148370297426
-12.47565010656941
59.88312051153319 |  | 1 | <--- first time sum is >= 200, so need to place a "1" in col C
-2.105263157894737
10.10526315789474
8
-2.352941176470588
-2.875816993464052
13.22875816993464
-1.48936170212766
-5.895390070921986
14.38475177304965
7
-1.555555555555556
-2.592592592592593
-3.278867102396514
-4.974832845015401
-6.929231462700023
-10.12733829163849
-31.98106828938472
-16.29511574744841
84.73460188673171
-1.555555555555556
-1.859903381642512
-5.481820493262141
15.89727943046021
-1.891891891891892
-4.832549941245594
-5.083126604865734
-3.838279273061881
-4.71788493980523
-8.827010532538818
36.19074318340915
-1.707317073170732
8.707317073170731
7
-2.258064516129032
-4.977454040929588
14.23551855705862
-1.521739130434783
-5.606407322654462
-3.924485125858124
-12.53654970760234
-16.44579639061812
47.03497767716783
-2.5
9.5
7
-4.430379746835443
-2.484865162355531
-3.568011515177172
17.48325642436814
-1.794871794871795
-3.908831908831909
-7.939814814814815
-9.383417508417509
-8.57912457912458
-13.31243469174504
-14.03202575616369
65.95052105396934
-3.333333333333333
-3.974358974358974
-3.576923076923077
-7.299843014128728
25.18445839874411
-1.707317073170732
-2.808811959087333
-3.198924731182796
14.71505376344086
-2.333333333333333
9.333333333333334
-1.428571428571428
-3.511904761904762
-3.73139880952381
-13.28125
-6.294157608695652
-11.01477581521739
-14.45689325747283
-20.93756954530548
-18.14589360593141
-32.19432736536218
131.9967421979849
-1.4
-6.176470588235295
-2.974789915966387
-14.15424234209813
-6.745851669425491
38.4513545157253
-1.428571428571428
8.428571428571429
-3.804347826086957
10.80434782608696
-2.1875
-2.1875
11.375
-1.4
-2.27027027027027
-3.233415233415234
-4.21323803141985
-5.661538604720424
-6.257490036796258
-12.51498007359252
42.55093225021456
7
-1.891891891891892
-2.963963963963964
11.85585585585586
-1.521739130434783
8.521739130434783
-2.424242424242424
-2.266139657444005
-3.253944123509341
-3.188865241039154
-6.833282659369616
-15.45623458666937
-14.79382453295497
-12.77648482391565
-22.99767268304818
-28.74709085381022
-26.83061813022287
-31.39753185451612
-39.77020701572043
218.7361385864623 |  | 1 | <--- first time sum is >= 400, so need to place a "1" in col C
9
-3.076923076923077
11.07692307692308
-3.018867924528302
-2.504288164665523
-7.862300051856874
-4.455303362718896
-8.075237344927997
33.91599684869759
-1.666666666666667
9.666666666666666
-5.194805194805195
-5.497835497835498
-4.153920153920154
-4.56931216931217
27.41587301587302
-2.5
-2.5
-8.904109589041097
-6.258317025440314
-6.549401538251491
-9.642174486870253
-18.48083443316798
-26.73822854160474
89.57306561437588
-1.777777777777778
9.777777777777779
-4.123711340206186
-6.123086535457669
18.24679787566386
-6.349206349206351
-3.878163878163879
-3.645474045474046
21.87284427284428
8
8
-2.857142857142857
-3.102040816326531
-5.170068027210884
-5.465500485908649
-5.465500485908649
-19.02547637499846
49.08572904749603
-2.962962962962963
-2.491582491582491
-3.203463203463203
-8.955918633337987
-10.67246970472777
-21.59904583099667
-12.05946725563981
69.94491008271088
8
-4
-11.53846153846154
-6.035502958579881
-12.58466574342188
-15.90891707187295
-19.68391434316483
-29.90440832903887
-22.42830624677916
-32.52104405782978
162.6052202891489
-1.777777777777778
-2.222222222222222
-2.926829268292683
-11.66158536585366
-16.21244794765021
-32.42489589530042
75.22575847709697
-2.711864406779661
-2.818911685994648
13.53077609277431
-2.162162162162162
-2.988871224165341
-2.630206677265501
-7.173290937996819
22.95453100158982
8
-2
10
8
-1.86046511627907
-2.241014799154334
12.1014799154334
-2.285714285714286
-2.571428571428571
12.85714285714285
8 |  | 1 | <--- first time sum is >= 600, so need to place a "1" in col C