Spreadsheet: 717761d1612837827-help-with-formula-to-identify-loss-amount-and-begin-cycle-again-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 |  |  | <--- first time sum is >= 200, so need to place a "1" in col C
-1.842105263157895
8.842105263157896
7
-2.058823529411764
-2.516339869281046
11.57516339869281
-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 |  |  | <--- first time sum is >= 400, so need to place a "1" in col C
-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
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 |  |  | <--- first time sum is >= 600, so need to place a "1" in col C
-2.25
-3.813559322033898
15.0635593220339
9
-3
-2.857142857142857
-3.714285714285714
-4.642857142857143
-5.527210884353742
-9.580498866213153
-22.54235027344271
-17.90127815832215
-22.50446397046214
-33.75669595569321
-37.50743995077024
172.5342237735431
9
-4.6875
13.6875
-2.432432432432432
-2.286486486486486
-3.346077785102175
-10.80063082532981
27.8656275293509
9
9
-3.673469387755102
-3.168367346938775
-3.600417439703154
-5.891592174059707
-9.934841705277153
35.26868805373389
-7.142857142857144
16.14285714285715
-3.461538461538461
-4.702467343976778
-5.536776066295238
22.70078187181048
-1.875
10.875
9
-2.571428571428572
-3.127413127413127
-10.49917264202979
-7.874379481522339
-11.40427373185994
-9.2659724071362
-14.52503782740269
-30.34119012835228
-23.4783018850345
-91.10982821058168
213.1969980127611
9
-4
-5.652173913043478
-3.80656610470275
-7.018356255545696
29.47709627329192
-3
-3.870967741935484
-5.290322580645161
21.16129032258064
-2.195121951219512
11.19512195121951
9
9
-3.6
12.6
-2.368421052631579
-3.343653250773993
-5.34984520123839
20.06191950464396
-2.173913043478261
12.17391304347826
-2.5
-3.048780487804878
-3.109756097560976
18.65853658536586
10
10
-2.380952380952381
12.38095238095238
-4.545454545454545
-5.015673981191223
-4.346917450365726
-5.831230726100364
-27.03570609373805
-23.6562428320208
80.4312256288707
-2.127659574468085
-3.191489361702128
-3.736377789309808
-5.604566683964712
-7.472755578619616
-11.47601749573727
-11.18176063687221
-23.31516047688248
78.10578759755631
-3.636363636363636
-5.05050505050505
-6.028022157054415
24.7148908439231
-2
-5.217391304347826
-5.217391304347827
-5.341614906832299
27.77639751552795
-2.380952380952381
-3.993855606758833
-3.638846219491381
20.0136542072026
-2.040816326530612
-3.440233236151603
-3.518420355155049
-5.428419976524933
24.4278898943622
-5.747126436781609
-4.374201787994892
20.1213282247765
10
10
-2.702702702702703
-3.257103257103257
-4.55994455994456
-20.11740247034364
-25.71971708233808
66.35687007243223
-3.03030303030303
-2.772404900064475
-3.854319007406709
-6.340976431540071
25.99800336931429
-3.921568627450981
-5.062388591800357
18.98395721925134
-2.631578947368421
-2.526315789473684
-8.237986270022885
-11.41262488139756
-8.702126472065636
43.51063236032818
10
-2.325581395348837
-4.930232558139535
-11.98320413436693
29.2390180878553
-3.142857142857143
-5.051020408163265
-4.921507064364206
-9.457013574660634
-19.29448171841681
-20.33341534940848
73.20029525787054
-3.4375
14.4375
-2.5
-6.75
-4.402173913043478
24.65217391304348
-2.82051282051282
-2.764102564102564
-6.503770739064858
-14.25209019980262
37.34047632348286
-2.2
-3.384615384615384
-8.548770816812054
-10.47224425059476
-13.96299233412635
-19.06485491774944
-20.1863169717347
-22.7743063270853
-25.36229568243591
-88.93272512022979
225.8891218053837
11
11
11
-2.5
-4.5
-5.000000000000001
-5.897435897435897
-14.74358974358974
-8.90633176347462
-21.89473225187511
-27.57114431717606
-22.17678999425031
-59.13810665133416
-155.3628225585897
-109.2551461863631
447.9460993640887
-4.615384615384615
16.61538461538461
11
-3.666666666666667
14.66666666666667
-3.548387096774194
-3.232974910394265
-3.556272401433692
-4.962240560140036
26.29987496874219
-2.75
-2.864583333333333
16.61458333333333
-2.82051282051282
13.82051282051282
-2.82051282051282
13.82051282051282
11
-3.793103448275862
-10.87728194726166
-5.704530087897227
-6.675513932645691
-21.61956216822752
-24.86249649346165
-33.14999532461554
-70.89306229059345
-43.85477806813456
-159.1988518911734
-105.8457231492666
497.4748988015533
12
-11.32075471698113
23.32075471698113
-6.666666666666667
-8.88888888888889
27.55555555555556
12
-3.243243243243243
-3.464373464373464
-4.923057028320185
-6.059147111778689
29.68982084771558
-2.4
-5.877551020408163
-4.055510204081632
24.33306122448979
-2.5
-3.918918918918919
-3.837274774774775
-5.428339925291146
-9.228177872994948
-7.382542298395959
44.29525379037575
-5.217391304347826
-5.739130434782609
-10.43478260869565
-9.024676850763809
-11.78221699960831
54.19819819819821
-4.285714285714286
16.28571428571428
-2.857142857142857
-5.306122448979592
-6.110080395794682
-14.27899222930279
-20.90326697485563
-16.17252760686199
-16.51662393892288
-41.84211397860464
135.9868704304651
-2.790697674418605
-6.879394267171445
21.67009194159005
-2.448979591836734
-5.666266506602641
20.11524609843937
-3.636363636363637
-3.553719008264463
-8.16599261473536
-13.81619962594114
-22.13563165876591
63.30790654407051
-4.615384615384615
-3.692307692307692
-7.963800904977376
28.27149321266968
-3.636363636363637
15.63636363636363
12
-2.5
14.5
-2.653061224489796
-6.261224489795919
21.91428571428571
-4.406779661016949
17.40677966101695
-2.76595744680851
15.76595744680851
-3.823529411764706
-5.25735294117647
-18.40073529411764
-28.50818144159073
-35.93218702533831
104.9219861139879
13
-6.5
-6.290322580645162
-8.059475806451612
-10.57806199596774
-13.88370636970766
58.31156675277217
-3.611111111111112
16.61111111111111
-4.0625
-5.783898305084746
-5.858050847457627
-7.757959230416858
36.46240838295923
-6.5
-7.222222222222221
-5.938271604938271
32.66049382716049
-2.6
-4
-5.444444444444445
-7.826388888888888
32.87083333333333
-8.125
-6.814516129032259
-9.803338992642898
-13.01477762816385
-10.57450682288313
-42.59176359216814
-50.69458690970258
154.6184900745928
-5.652173913043478
-6.54462242562929
25.19679633867277
-4.333333333333333
17.33333333333333
-2.653061224489796
-4.472303206997085
20.12536443148688
-5.777777777777778
18.77777777777778
-6.363636363636363
-5.358851674641149
-15.31100478468899
41.03349282296651
14
-3.888888888888889
-4.707602339181287
22.59649122807018
14
-2.8
16.8
14
-3.111111111111111
17.11111111111111
14
-5.833333333333334
19.83333333333334
-3.783783783783784
-4.559944559944559
-4.753984753984753
-5.645356895356895
32.74306999306999
-5
-5.9375
-10.84239130434783
35.77989130434783
-3.5
-7.291666666666667
-9.53525641025641
-8.173076923076923
-25
-25.47169811320755
92.97169811320755
-3.68421052631579
-3.536842105263158
-6.063157894736842
-14.51287793952968
-10.71720217072961
-19.0961056860273
-14.91883256720883
-20.12307648600261
-33.32884542994181
-36.83714494888306
-47.78872858233478
-74.8690081123245
-66.55022943317732
-234.6322191554329
-240.2633924151633
840.9218734530714
-3.191489361702128
18.19148936170213
14
-4.166666666666667
-6.388888888888889
-6.72514619883041
-6.868234415826801
-9.104403760514597
-24.12666996536368
72.38000989609105
-6.382978723404255
21.38297872340426
-3.488372093023256
18.48837209302325
-3.947368421052632
-4.406364749082007
-5.076898515246661
-7.683954509562513
-24.73601794174234
60.85060413668614
-5.555555555555555
20.55555555555556
-3
-4.285714285714286
-7.428571428571428
29.71428571428571
-9.615384615384615
24.61538461538461
-4.166666666666667
-8.712121212121213
27.87878787878788
-3.947368421052632
-7.017543859649122
-7.017543859649122
-12.21572449642625
45.19818063677712
-6.666666666666667
21.66666666666667
-8.522727272727273
23.52272727272727
-3.571428571428571
-6.295399515738498
-4.973365617433414
29.84019370460048
-3.125
-4.420731707317073
22.54573170731707
-3.2
-4.8
24
-6.153846153846153
22.15384615384615
-15.38461538461538
31.38461538461538
-3.265306122448979
-5.504373177842566
-5.504373177842566
-11.64386633774389
-15.52515511699185
57.44307393286986
16
-5.818181818181818
-4.363636363636364
26.18181818181818
-12.90322580645161
-6.881720430107525
-13.76344086021505
-11.26099706744868
-16.43496869303321
-29.14881239896456
-22.6368436715363
-45.27368734307261
-71.14436582482838
245.4480620956579
16
16
-3.404255319148936
-3.880851063829788
-4.954277953825261
-19.88689037803098
-17.1879552552982
-23.75062908004843
-21.72313635370283
110.7879954038844
-5.161290322580646
-7.425014148273911
28.58630447085456
-8
-8.421052631578947
-12.2343594836147
-16.23833167825223
-23.87989952684152
-30.82677938919542
-58.38405187347617
-49.70984988084543
-134.7556171468701
358.4499416106746
-7.272727272727272
23.27272727272727
-4.25
21.25
-4.473684210526316
-4.473684210526316
25.94736842105263
-5.762711864406779
-4.645451400899343
-20.76376004947434
-14.16821273964131
-26.52771746996671
-39.49682378861709
128.3646773130056
-8.854166666666668
25.85416666666667
-4.047619047619047
-5.846560846560847
26.8941798941799
-6.8
-14.875
-9.916666666666664
-14.72474747474747
-19.18679216406489
-27.96718857812848
110.4703948836075
-7.727272727272727
-4.945454545454545
29.67272727272727
-6.538461538461538
-7.355769230769231
-6.573240589198036
-14.69312602291326
-29.97735481686325
82.13795219820533
17
17
-8.292682926829269
-24.31988742964353
49.61257035647279
18
18
-5.000000000000001
-5.348837209302326
-7.661847894406034
36.01068510370835
-3.6
-7.714285714285715
-6.107142857142858
-13.11904761904762
-11.03192640692641
-19.85746753246753
-52.25649350649351
-94.06168831168831
-82.09020070838254
-114.0141676505313
421.8524203069658
18
-5.000000000000001
-10.22222222222222
-7.068557919621749
-12.99702585220773
53.2878059940517
-3.91304347826087
21.91304347826087
-8
-16.88311688311688
-9.124067421939762
52.00718430505664
-5.000000000000001
23
18
-5.454545454545455
-8.229665071770334
-9.901315789473683
41.58552631578947
19
-4.318181818181817
-6.858288770053475
-10.05882352941176
-31.9327731092437
-18.99159663865546
91.15966386554621
-3.877551020408163
-8.170553935860058
-6.209620991253644
-8.46766498807315
-23.56978914205929
-25.1982473009652
94.49342737861949
-6.333333333333333
-21.11111111111111
-21.60206718346253
68.04651162790698
19
-4.871794871794871
-5.551580202742993
-15.01192605843769
-15.86975040463413
60.30505153760968
-5.428571428571429
-10.17857142857143
-7.865259740259741
42.4724025974026
-9.047619047619047
28.04761904761905
-5.9375
-8.90625
-6.906887755102041
-16.6329133694294
57.38355112453144
19
-5.428571428571429
-11.36212624584718
-18.64098837209303
54.43168604651164
-4.878048780487806
-4.975609756097561
-8.29268292682927
-9.082462253193961
-12.76454154502935
-22.63899821193885
-19.21682406362251
-22.63314834159984
124.4823158787991
-4.444444444444445
-5.555555555555554
-29.41176470588235
-13.50267379679144
-37.20124413401724
-33.36838867778516
-117.6098945200624
-63.68145508159479
324.7754209161334
20
20
-5.714285714285714
-5.142857142857143
-7.012987012987012
-13.28776486671224
-20.06191950464397
-21.58176189135942
-25.08150706293121
-33.68088091307906
-47.36373878401743
198.9277028928732
-5.405405405405405
25.4054054054054
-5
-13.29787234042553
-29.92021276595746
-23.52347762289068
-19.11282556859868
-71.06050531914894
-77.41059302851968
-137.9390886412452
-211.310944301482
-126.7865665808892
-262.6293164889848
-243.4125372336933 |  |  |  | <-- if at any time there is a loss of > -1000 between this row and the last increment of 200 (cell B924), can it start again? E.g. new amount is 1704.60 in B968, the next occurance of +200 is cell B1081
6 | 1710.596060108163
6 | 1716.596060108163
-1.714285714285714 | 1714.881774393877
-3.214285714285714 | 1711.667488679592
10.92857142857143 | 1722.596060108163
-2.068965517241379 | 1720.527094590921
-7.612231620039037 | 1712.914862970882
15.68119713728042 | 1728.596060108163
-4.109589041095891 | 1724.486471067067
-2.660418168709445 | 1721.826052898358
12.77000720980534 | 1734.596060108163
-2.4 | 1732.196060108163
8.4 | 1740.596060108163
-1.463414634146342 | 1739.132645474016
7.463414634146342 | 1746.596060108163
-1.935483870967742 | 1744.660576237195
-2.088285229202037 | 1742.572291007993
10.02376910016978 | 1752.596060108163
-3.448275862068965 | 1749.147784246094
-4.499178981937602 | 1744.648605264156
-3.576270472822196 | 1741.072334791334
-5.310219792978414 | 1735.762114998356
-10.62043958595683 | 1725.141675412399
-6.827425448115101 | 1718.314249964284
-8.056362028775819 | 1710.257887935508
48.33817217265492 | 1758.596060108163
6 | 1764.596060108163
6 | 1770.596060108163
-1.2 | 1769.396060108163
-1.44 | 1767.956060108163
8.64 | 1776.596060108163
-1.304347826086957 | 1775.291712282076
7.304347826086958 | 1782.596060108163
-1.621621621621621 | 1780.974438486541
-3.243243243243243 | 1777.731195243298
10.86486486486486 | 1788.596060108163
-1.2 | 1787.396060108163
-1.945945945945946 | 1785.450114162217
-2.345114345114345 | 1783.104999817102
-2.498056585013107 | 1780.606943232089
-9.326077917382266 | 1771.280865314707
23.31519479345566 | 1794.596060108163
-1.538461538461538 | 1793.057598569701
7.538461538461538 | 1800.596060108163
-1.25 | 1799.346060108163
7.25 | 1806.596060108163
-1.875 | 1804.721060108163
-4.578488372093023 | 1800.14257173607
12.45348837209302 | 1812.596060108163
6 | 1818.596060108163
-1.463414634146342 | 1817.132645474016
7.463414634146342 | 1824.596060108163
6 | 1830.596060108163
-2.307692307692307 | 1828.28836780047
-2.186234817813765 | 1826.102132982656
-4.197570850202429 | 1821.904562132454
-4.197570850202429 | 1817.706991282251
-8.212638619961274 | 1809.49435266229
-8.212638619961274 | 1801.281714042329
-9.54441785563067 | 1791.737296186698
-9.96861420476981 | 1781.768681981928
-10.96547562524679 | 1770.803206356681
-18.79795821470879 | 1752.005248141973
-25.6335793836938 | 1726.371668758279
-84.78799334606411 | 1641.583675412215
-75.00476334459518 | 1566.57891206762
270.0171480405426 | 1836.596060108162
-1.75 | 1834.846060108162
-3.977272727272727 | 1830.868787380889
-3.349282296650718 | 1827.519505084239
-10.04784688995215 | 1817.471658194287
-5.224880382775119 | 1812.246777811511
-7.837320574162678 | 1804.409457237349
-11.19617224880382 | 1793.213284988545
-12.288481736492 | 1780.924803252053
-19.58476776753413 | 1761.340035484519
-16.78694380074354 | 1744.553091683775
99.04296842438688 | 1843.596060108162
-2.8 | 1840.796060108162
-3.92 | 1836.876060108162
-2.744 | 1834.132060108162
-3.430000000000001 | 1830.702060108162
-5.235263157894738 | 1825.466796950267
25.12926315789474 | 1850.596060108162
-1.578947368421053 | 1849.017112739741
-1.647597254004577 | 1847.369515485736
-4.500753474353966 | 1842.868762011382
13.7272980967796 | 1856.596060108162
-1.714285714285714 | 1854.881774393876
-2.805194805194805 | 1852.076579588681
-3.969615290370008 | 1848.106964298311
-5.467583324471898 | 1842.639380973839
19.95667913432243 | 1862.596060108162
6 | 1868.596060108162
-1.5 | 1867.096060108162
-2.205882352941176 | 1864.890177755221
-2.488687782805429 | 1862.401489972415
12.19457013574661 | 1874.596060108162
-1.5 | 1873.096060108162
7.5 | 1880.596060108162
-2.4 | 1878.196060108162
8.4 | 1886.596060108162
6 | 1892.596060108162
-1.578947368421053 | 1891.017112739741
-6.31578947368421 | 1884.701323266057
-4.342105263157895 | 1880.359218002899
-6.513157894736842 | 1873.846060108162
-16.5 | 1857.346060108162
-20.625 | 1836.721060108162
61.875 | 1898.596060108162
-1.666666666666667 | 1896.929393441495
-2.254901960784314 | 1894.674491480711
9.92156862745098 | 1904.596060108162
6 | 1910.596060108162