Spreadsheet: 838110d1690733632-need-help-with-stats-in-bankroll-sheet-to-calculate-results-from-tournament-sheet-example
Sheet: Sheet1

Day | Date | Buy-ins | Cashes | PNL | Rakeback | Bonuses | Day Results | Mawney | 123 | Fish points gained | Cash Game |  |  | Fish points
 | (Total) |  |  |  |  |  |  |  |  |  |  |  |  |  | _ Mawney is Total Balance, starts at $55,207 this year
(/B) |  |  |  |  |  |  |  | 55207 |  |  |  |  |  |  | _ PNL = Cashes - Buy-ins
 | (AVG) |  |  |  |  |  |  |  |  |  |  |  |  |  | _ Day Results = PNL + Rakeback + Bonuses + CashGame
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _ Coloured sessions are Saturday and Sunday, first Sunday session is May 1st.
1 | 2023-01-01 00:00:00 | 3850 | 7864 |  |  | 20 |  |  | https://i.imgur.com/WMOzwji.jpg |  |  |  |  | 5643474 | _ [NAME] is always ahead by 1 (May 1st is Monday but it's Sunday session)
2 | 3 | 3771 | 4391 |  |  | 40.81 |  |  | https://i.imgur.com/C02a8ee.png |  |  |  |  | 5668105 | _ 2022: Started at $5,000 on May 4th, ended at $55,207 on Dec 31 after 222 sesions played
3 | 4 | 3805 | 3883 |  |  | 75.66 |  |  |  |  |  |  |  | 5691486 | Ship it
4 | 5 | 3308 | 5253 |  |  | 4 |  |  | https://i.imgur.com/EYxG07X.jpg |  |  |  |  | 5712811 | _ [NAME]: Subtractive. Buy-ins is determined by the difference between Total Balance before and after the session
5 | 6 | 4043 | 3366 |  |  | 4 |  |  |  |  |  |  |  | 5738012 | _ The entire Book is error-proof because the only input is Total Balance after each session, so the Mawney is always the same as Total Balance
6 | 7 | 3450 | 4660 |  |  | 66.83 |  |  | https://i.imgur.com/kEeoysI.png |  |  |  |  | 5760949 | _ Coloured text black background wow imagine if it was white like this
7 | 8 | 3835 | 5217 |  |  | 8 |  |  | [NAME] |  |  |  |  | 5785621 | and Hit the River
8 | 10 | 4671 | 6703 |  |  |  |  |  | https://i.imgur.com/hhgqB2B.jpg |  |  |  |  | 5811263
9 | 11 | 4172 | 2950 |  |  | 10 |  |  |  |  |  |  |  | 5835438 | buy DOGE
10 | 12 | 4263 | 4571 |  |  |  |  |  | https://i.imgur.com/NEtvLpI.png |  |  |  |  | 5860964
11 | 13 | 3515 | 2213 |  |  |  |  |  |  |  |  |  |  | 5882005
12 | 14 | 3919 | 2269 |  |  |  |  |  | https://i.imgur.com/gzSqq5s.png |  |  |  |  | 5906623
13 | 15 | 3618 | 2021 |  |  |  |  |  | https://i.imgur.com/oRnEocO.png |  |  |  |  | 5929684
14 | 17 | 4382 | 4100 |  |  |  |  |  | https://i.imgur.com/2RJTBjW.jpg |  |  |  |  | 5956184
15 | 18 | 3821 | 12781 |  |  | 37.43 |  |  | https://i.imgur.com/4PiKtDr.jpg |  |  |  |  | 5979965
16 | 19 | 3235 | 5732 |  |  |  |  |  | https://i.imgur.com/0mZGDWD.jpg |  |  |  |  | 6002250
17 | 20 | 4404 | 2460 |  |  |  |  |  |  |  |  |  |  | 6029931
18 | 21 | 5045 | 4275 |  |  | 28.02 |  |  | [NAME] |  |  |  |  | 6051967
19 | 22 | 3923 | 3555 |  |  |  |  |  | https://i.imgur.com/oRnEocO.png |  |  |  |  | 6087214
20 | 24 | 4845 | 4301 |  |  | 19.64 |  |  |  |  |  |  |  | 6116879
21 | 25 | 4941 | 5737 |  |  |  |  |  |  |  |  |  |  | 6148004
22 | 26 | 4940 | 4736 |  |  |  |  |  |  |  |  |  |  | 6179720
23 | 27 | 4374 | 7641 |  |  |  |  |  | https://i.imgur.com/fsQEIY9.png |  |  |  |  | 6207244
24 | 28 | 4401 | 7715 |  |  |  |  |  | https://i.imgur.com/CBv4TM8.jpg |  |  |  |  | 6237555
25 | 29 | 4547 | 9816 |  |  |  |  |  | https://i.imgur.com/RiwEdtD.png |  |  |  |  | 6270236
26 | 31 | 5252 | 10900 |  |  |  |  |  | https://i.imgur.com/4FbZVCK.jpg |  |  |  |  | 6306183 | https://i.imgur.com/BFrSzEo.jpg
27 | 2023-02-01 00:00:00 | 4891 | 6409 |  |  |  |  |  | https://i.imgur.com/op2I8jy.jpg |  |  |  |  | 6337994
28 | 2 | 5440 | 4668 |  |  | 32.43 |  |  | https://i.imgur.com/7olIfhn.png |  |  |  |  | 6376474
29 | 3 | 5666 | 11020 |  |  |  |  |  | https://i.imgur.com/s1jD0Ua.jpg |  |  |  |  | 6415939
30 | 4 | 5779 | 7713 |  |  |  |  |  |  |  |  |  |  | 6456400
31 | 5 | 5270 | 7347 |  |  | 22.77 |  |  |  |  |  |  |  | 6491971
32 | 7 | 7496 | 5131 |  |  |  |  |  | https://i.imgur.com/cZypBUY.png |  |  |  |  | 6544253
33 | 8 | 7176 | 2867 |  |  |  |  |  |  |  |  |  |  | 6592266
34 | 9 | 6206 | 4296 |  |  | 19.64 |  |  |  |  |  |  |  | 6635033
35 | 10 | 7283 | 6103 |  |  |  |  |  | https://i.imgur.com/VLSXSSf.png |  |  |  |  | 6680866
36 | 11 | 5339 | 5241 |  |  |  |  |  | https://i.imgur.com/EYUHGRj.png |  |  |  |  | 6719197
37 | 12 | 6020 | 6512 |  |  | 19.64 |  |  | https://i.imgur.com/N9vEODv.png |  |  |  |  | 6759075
38 | 14 | 5715 | 4767 |  |  |  |  |  |  |  |  |  |  | 6796883
39 | 15 | 6305 | 4315 |  |  |  |  |  |  |  |  |  |  | 6839635
40 | 16 | 4814 | 4296 |  |  | 21.48 |  |  | https://i.imgur.com/lZOLces.png |  |  |  |  | 6871957
41 | 17 | 6532 | 6686 |  |  |  |  |  | https://i.imgur.com/LDOw1wP.png |  |  |  |  | 6915703
42 | 18 | 7945 | 4057 |  |  | 19.64 |  |  |  |  |  |  |  | 6968111
43 | 19 | 5566 | 12324 |  |  |  |  |  | https://i.imgur.com/uoO2Ysw.png |  |  |  |  | 7007145
44 | 21 | 6666 | 7620 |  |  |  |  |  | https://i.imgur.com/B59F5ok.png |  |  |  |  | 7052536
45 | 22 | 1989 | 1707 |  |  |  |  |  |  |  |  |  |  | 7066232
46 | 23 | 6816 | 6260 |  |  |  |  |  | https://i.imgur.com/3CabV9l.png |  |  |  |  | 7112514
47 | 24 | 7598 | 7057 |  |  |  |  |  |  |  |  |  |  | 7162446
48 | 25 | 6749 | 2652 |  |  |  |  |  |  |  |  |  |  | 7207856
49 | 26 | 6730 | 2563 |  |  |  |  |  |  |  |  |  |  | 7253408
50 | 28 | 6033 | 4154 |  |  |  |  |  |  |  |  |  |  | 7300628 | https://i.imgur.com/o7IsjZA.jpg
51 | 2023-03-01 00:00:00 | 7115 | 10802 |  |  |  |  |  | https://i.imgur.com/6TwjIar.png |  |  |  |  | 7346142
52 | 2 | 5142 | 3026 |  |  |  |  |  |  |  |  |  |  | 7381245
53 | 3 | 7701 | 7478 |  |  | 10 |  |  | https://i.imgur.com/9EYCsBU.png |  |  |  |  | 7429681
54 | 4 | 5688 | 8537 |  |  | 10 |  |  | https://i.imgur.com/Mys7dMq.png |  |  |  |  | 7472881
55 | 5 | 5424 | 5058 |  |  | 20 |  |  |  |  |  |  |  | 7509041
56 | 7 | 6304 | 3506 |  |  |  |  |  | https://i.imgur.com/oOP1hPD.png |  |  |  |  | 7547853
57 | 8 | 6502 | 3021 |  |  | 19.64 |  |  |  |  |  |  |  | 7585131
58 | 9 | 6878 | 8187 |  |  |  |  |  | https://i.imgur.com/Wn5QeAa.png |  |  |  |  | 7624393
59 | 10 | 6724 | 10138 |  |  | 29.64 |  |  | https://i.imgur.com/gXmIk2M.jpg |  |  |  |  | 7665453
60 | 11 | 7581 | 5152 |  |  | 28.85 |  |  |  |  |  |  |  | 7712357
61 | 12 | 6623 | 2473 |  |  | 20 |  |  |  |  |  |  |  | 7752467
62 | 14 | 6679 | 4140 |  |  |  |  |  |  |  |  |  |  | 7797106.33333333
63 | 15 | 5414 | 15810 |  |  | 40.75 |  |  | https://i.imgur.com/DJO14WU.png |  |  |  |  | 7828381
64 | 16 | 7838 | 5236 |  |  | 28.85 |  |  |  |  |  |  |  | 7876273
65 | 17 | 7212 | 5552 |  |  | 10 |  |  |  |  |  |  |  | 7920055
66 | 18 | 8489 | 9137 |  |  | 30 |  |  | https://i.imgur.com/T23PTLF.png |  |  |  |  | 7973055
67 | 19 | 6452 | 16562 |  |  |  |  |  | https://i.imgur.com/96h475w.jpg |  |  |  |  | 8009723 | https://i.imgur.com/x8YI4Jd.jpg
68 | 21 | 6739 | 2753 |  |  | 10 |  |  |  |  |  |  |  | 8053578
69 | 24 | 6843 | 2520 |  |  |  |  |  |  |  |  |  |  | 8096792
70 | 25 | 4814 | 7230 |  |  | 37.07 |  |  | https://i.imgur.com/qmiHb5e.png |  |  |  |  | 8131147
71 | 26 | 6188 | 4574 |  |  | 40.63 |  |  |  |  |  |  |  | 8167415
72 | 28 | 6973 | 3921 |  |  |  |  |  |  |  |  |  |  | 8211763
73 | 29 | 5760 | 3440 |  |  | 10 |  |  |  |  |  |  |  | 8249365
74 | 30 | 6608 | 2888 |  |  | 10 |  |  |  |  |  |  |  | 8294193
75 | 31 | 6082 | 3653 |  |  | 10 |  |  | https://i.imgur.com/35rlJWL.png |  |  |  |  | 8331327 | https://i.imgur.com/Kyyjx6H.jpg
76 | 2023-04-01 00:00:00 | 4525 | 3937 |  |  | 32.77 |  |  |  |  |  |  |  | 8360989
77 | 2 | 6139 | 4265 |  |  | 10 |  |  |  |  |  |  |  | 8401185
78 | 4 | 5431 | 4867 |  |  |  |  |  |  |  |  |  |  | 8436239
79 | 5 | 5711 | 7418 |  |  |  |  |  | https://i.imgur.com/ENjI050.png |  |  |  |  | 8474723
80 | 7 | 5227 | 5845 |  |  | 21.48 |  |  |  |  |  |  |  | 8507387
81 | 8 | 4785 | 2811 |  |  |  |  |  |  |  |  |  |  | 8540165
82 | 9 | 4966 | 2012 |  |  |  |  |  |  |  |  |  |  | 8571351
83 | 11 | 5110 | 7470 |  |  |  |  |  | https://i.imgur.com/37hNZiz.png |  |  |  |  | 8603395
84 | 12 | 2752 | 606 |  |  |  |  |  |  |  |  |  |  | 8619537
85 | 13 | 4276 | 2326 |  |  |  |  |  |  |  |  |  |  | 8646161
86 | 14 | 4740 | 2818 |  |  | 22.77 |  |  |  |  |  |  |  | 8673959
87 | 15 | 4295 | 9432 |  |  |  |  |  | https://i.imgur.com/GIycQHg.jpg |  |  |  |  | 8699975
88 | 16 | 4458 | 2418 |  |  | 22.77 |  |  |  |  |  |  |  | 8727823
89 | 19 | 5153 | 5122 |  |  |  |  |  | https://i.imgur.com/8K0gpj0.png |  |  |  |  | 8758090
90 | 20 | 4650 | 5928 |  |  |  |  |  | https://i.imgur.com/9j7zVfJ.png |  |  |  |  | 8784487
91 | 21 | 5674 | 5767 |  |  |  |  |  | https://i.imgur.com/ljtIO2p.png |  |  |  |  | 8817023
92 | 22 | 4666 | 5688 |  |  |  |  |  |  |  |  |  |  | 8844957
93 | 23 | 5149 | 7298 |  |  |  |  |  | https://i.imgur.com/eKDQ5ox.jpg |  |  |  |  | 8876299
94 | 25 | 6000 | 12051 |  |  |  |  |  | https://i.imgur.com/oWh4rmw.png |  |  |  |  | 8909472
95 | 26 | 6015 | 5983 |  |  |  |  |  |  |  |  |  |  | 8946038
96 | 27 | 4696 | 4944 |  |  |  |  |  | https://i.imgur.com/XvNJIMg.png |  |  |  |  | 8975377
97 | 28 | 5176 | 3004 |  |  |  |  |  |  |  |  |  |  | 9010815
98 | 29 | 5816 | 16110 |  |  | 26.51 |  |  | https://i.imgur.com/a8q6vIi.png |  |  |  |  | 9047263
99 | 30 | 6204 | 8372 |  |  |  |  |  | https://i.imgur.com/NEZ4xIx.png |  |  |  |  | 9082450 | https://i.imgur.com/Ap63QEh.jpg
100 | 2023-05-01 00:00:00 | 6562 | 5187 |  |  |  |  |  | https://i.imgur.com/KbAZtR5.png |  |  |  |  | 9122901
101 | 2 | 6303 | 5863 |  |  |  |  |  |  |  |  |  |  | 9162113
102 | 3 | 7008 | 9251 |  |  |  |  |  | https://i.imgur.com/dslrgqs.jpg |  |  |  |  | 9204371
103 | 4 | 5866 | 8025 |  |  | 37.24 |  |  | https://i.imgur.com/QWByPlg.jpg |  |  |  |  | 9242006
104 | 5 | 7161 | 9586 |  |  | 37.24 |  |  | https://i.imgur.com/2tTfTbP.png |  |  |  |  | 9287782 | https://i.imgur.com/SYQUCnK.jpg
105 | 6 | 5762 | 10270 |  |  |  |  |  | https://i.imgur.com/C2gy6xf.jpg |  |  |  |  | 9323961
106 | 7 | 6152 | 5264 |  |  |  |  |  |  |  |  |  |  | 9364834
107 | 8 | 6156 | 13010 |  |  | 43.49 |  |  | https://i.imgur.com/XMOq3t5.png |  |  |  |  | 9402702
108 | 9 | 7030 | 5687 |  |  |  |  |  | https://i.imgur.com/qHrC6nH.png |  |  |  |  | 9445009
109 | 10 | 6706 | 6437 |  |  | 38.38 |  |  | https://i.imgur.com/M2UYDOe.png |  |  |  |  | 9487732
110 | 11 | 6613 | 7467 |  |  |  |  |  | https://i.imgur.com/MNHEpdl.png |  |  |  |  | 9529155
111 | 12 | 6235 | 6848 |  |  | 28.11 |  |  | https://i.imgur.com/1dG2Fkf.png |  |  |  |  | 9568698
112 | 13 | 5997 | 2082 |  |  | 25.7 |  |  |  |  |  |  |  | 9607045
113 | 14 | 6450 | 8400 |  |  |  |  |  | https://i.imgur.com/9FEqxL1.png |  |  |  |  | 9648873
114 | 15 | 7107 | 8167 |  |  |  |  |  | https://i.imgur.com/I3mAY1o.png |  |  |  |  | 9694036
115 | 16 | 6154 | 5878 |  |  |  |  |  |  |  |  |  |  | 9733345
116 | 17 | 7032 | 1212 |  |  |  |  |  |  |  |  |  |  | 9775686
117 | 18 | 6581 | 12419 |  |  |  |  |  | https://i.imgur.com/BRVNdax.png |  |  |  |  | 9816018
118 | 19 | 7196 | 7002 |  |  |  |  |  | https://i.imgur.com/3f1KQPs.png |  |  |  |  | 9858698
119 | 20 | 6538 | 5442 |  |  |  |  |  | https://i.imgur.com/VEzZ3iI.png |  |  |  |  | 9900281
120 | 21 | 5892 | 13478 |  |  | 19.64 |  |  | https://i.imgur.com/dbsYbqB.jpg |  |  |  |  | 9939319
121 | 22 | 8115 | 7749 |  |  | 36.79 |  |  |  |  |  |  |  | 9988974
122 | 23 | 4326 | 4665 |  |  |  |  |  | https://i.imgur.com/7bz4Ha1.png |  |  |  |  | 10014221
123 | 24 | 6124 | 2653 |  |  |  |  |  |  |  |  |  |  | 10051397
124 | 25 | 7343 | 6580 |  |  | 21.48 |  |  | https://i.imgur.com/gEK1wzl.jpg |  |  |  |  | 10096376
125 | 26 | 6624 | 4993 |  |  |  |  |  |  |  |  |  |  | 10136084
126 | 27 | 7172 | 4831 |  |  | 220 |  |  |  |  |  |  |  | 10182380
127 | 28 | 5769 | 6197 |  |  |  |  |  |  |  |  |  |  | 10218694
128 | 29 | 7608 | 7599 |  |  |  |  |  |  |  |  |  |  | 10263626
129 | 30 | 8259 | 9652 |  |  | 17.22 |  |  |  |  |  |  |  | 10313066
130 | 31 | 8520 | 6371 |  |  |  |  |  | https://i.imgur.com/Aa2viXO.png |  |  |  |  | 10363336 | https://i.imgur.com/eRZCGAZ.jpg
131 | 2023-06-01 00:00:00 | 7229 | 8129 |  |  |  |  |  |  |  |  |  |  | 10410308
132 | 2 | 8427 | 17981 |  |  | 62.22 |  |  | https://i.imgur.com/wF7suar.png |  |  |  |  | 10457323
133 | 3 | 5928 | 9629 |  |  | 20.63 |  |  |  |  |  |  |  | 10497722
134 | 4 | 6039 | 8816 |  |  |  |  |  | https://i.imgur.com/ab6KjDe.png |  |  |  |  | 10537204
135 | 5 | 7280 | 6721 |  |  |  |  |  | https://i.imgur.com/yAfUMDA.png |  |  |  |  | 10583127
136 | 6 | 7854 | 2170 |  |  | 63.02 |  |  |  |  |  |  |  | 10625885
137 | 7 | 8218 | 7634 |  |  |  |  |  | https://i.imgur.com/jkAMqQO.png |  |  |  |  | 10678263
138 | 9 | 8482 | 17144 |  |  |  |  |  | [NAME] |  |  |  |  | 10729615
139 | 10 | 7848 | 15987 |  |  |  |  |  | https://i.imgur.com/UEKtsmD.png |  |  |  |  | 10781240 | https://i.imgur.com/st6Kugy.png
140 | 11 | 8795 | 5080 |  |  | 750 |  |  |  |  |  |  |  | 10832211 | https://i.imgur.com/7dTCCAl.png
141 | 12 | 10216 | 12597 |  |  | 28.11 |  |  | https://i.imgur.com/To9IrWo.png |  |  |  |  | 10893437
142 | 13 | 9413 | 5315 |  |  | 42.51 |  |  | https://i.imgur.com/xuHXrW7.png |  |  |  |  | 10952264
143 | 14 | 7339 | 4633 |  |  | 36.79 |  |  |  |  |  |  |  | 11003133 | 3030.56
144 | 15 | 8790 | 6793 |  |  |  |  |  |  |  |  |  |  | 11058046
145 | 16 | 10175 | 6560 |  |  |  |  |  |  |  |  |  |  | 11119416
146 | 17 | 11049 | 10372 |  |  |  |  |  | https://i.imgur.com/LgH5BNU.png |  |  |  |  | 11186469
147 | 18 | 12731 | 7888 |  |  |  |  |  |  |  |  |  |  | 11262075
148 | 19 | 11338 | 9255 |  |  | 30.75 |  |  |  |  |  |  |  | 11334796
149 | 21 | 9536 | 8526 |  |  |  |  |  | https://i.imgur.com/fCbiOxl.png |  |  |  |  | 11397660
150 | 23 | 14980 | 22112 |  |  |  |  |  | https://i.imgur.com/JSW64YU.png |  |  |  |  | 11489805
151 | 24 | 14074 | 16757 |  |  |  |  |  | https://i.imgur.com/2lstfdh.png |  |  |  |  | 11575910
152 | 25 | 14245 | 9539 |  |  |  |  |  | https://i.imgur.com/EnEXmx5.png |  |  |  |  | 11658736
153 | 26 | 16812 | 20692 |  |  |  |  |  | https://i.imgur.com/8uYUL9O.png |  |  |  |  | 11756014
154 | 28 | 12888 | 7883 |  |  | 28.11 |  |  |  |  |  |  |  | 11833636
155 | 30 | 10888 | 12403 |  |  |  |  |  |  |  |  |  |  | 11900754 | https://i.imgur.com/q51XqP1.jpg
156 | 2023-07-02 00:00:00 | 12941 | 17748 |  |  | 17.22 |  |  | https://i.imgur.com/b3pezBX.png |  |  |  |  | 11972961 | 3106.64
157 | 3 | 15426 | 36555 |  |  |  |  |  | https://i.imgur.com/uRu73yg.png |  |  |  |  | 12046649 | WSOP hype
158 | 4 | 19166 | 14655 |  |  |  |  |  |  |  |  |  |  | 12131089
159 | 5 | 17069 | 23376 |  |  |  |  |  | https://i.imgur.com/nodk7qJ.png |  |  |  |  | 12224824
160 | 6 | 13595 | 21955 |  |  |  |  |  | https://i.imgur.com/z9TQYzj.png |  |  |  |  | 12300366
161 | 7 | 15469 | 7797 |  |  | 107.22 |  |  |  |  |  |  |  | 12384523 | 3213.86
162 | 8 | 12766 | 8364 |  |  |  |  |  |  |  |  |  |  | 12463767
163 | 9 | 16923 | 9083 |  |  |  |  |  | https://i.imgur.com/A8jTPtQ.png |  |  |  |  | 12553058
164 | 10 | 24753 | 17990 |  |  |  |  |  | https://i.imgur.com/KjrYy6n.png |  |  |  |  | 12670447
165 | 11 | 15188 | 28003 |  |  | 17.22 |  |  | https://i.imgur.com/Vgfrkkt.png |  |  |  |  | 12758661 | 3141.08
166 | 12 | 15206 | 11007 |  |  | 20.63 |  |  | https://i.imgur.com/q45D75I.png |  |  |  |  | 12839034 | 3161.71
167 | 13 | 12198 | 11132 |  |  |  |  |  |  |  |  |  |  | 12913766
168 | 14 | 15533 | 17816 |  |  | 21.63 |  |  | https://i.imgur.com/wIjRSLg.png |  |  |  |  | 12999965
169 | 15 | 14688 | 16935 |  |  | 20.63 |  |  |  |  |  |  |  | 13079808 | 3182.34
170 | 16 | 15164 | 3110 |  |  |  |  |  |  |  |  |  |  | 13163283 | https://i.imgur.com/LOVZ6vw.png
171 | 17 | 23801 | 18346 |  |  |  |  |  | https://i.imgur.com/FIo3zrl.png |  |  |  |  | 13288681
172 | 18 | 20855 | 19461 |  |  |  |  |  | https://i.imgur.com/M31OhUc.png |  |  |  |  | 13390017