JavaScript must be enabled for Sign In.
Please check your broswer settings.

Home \ Community \ Blogs \

Finally Embracing MTT Games!!!

So we are just starting on our poker career and we still can not afford those complicated tracking software.  Well, do not fret.  I am sure you have some sort of spreadsheet software installed on your PC or Laptop.  This simple spreadsheet keeps track of my running Bankroll Balance, my current ROI per Buy-In, and a few other things that I might want to know. This ain't Poker Tracker but it does give me a good idea how my game is doing.  I can also make a graph out to give me a visuals of my ups and downs.

The $25 is my starting bankroll.  You need to input the data on on columns A - F. The first line shows the formula i used to compute my Balance, Buy-In Total, etc. on columns G - L starting on Game 1. 

            =G4+(F5-C5) =H4+C5 =I4+F5 =J4+(F5-C5) =J5/A5 =(J5/H5)
A B C D E F G H I J K L
Game  Date  Buy in  Entries  Rank  Prize  Balance  Buy-in Total  Prize Total  Profit Total  Profit / Game  ROI / Buy-in
            $25.00 $0.00 $0.00 $0.00    
1 8/5/2009 18:14 $1.10 90 12 $1.98 $25.88 $1.10 $1.98 $0.88 $0.88 $0.80
2 11/9/2009 12:42 $1.10 90 48 $0.00 $24.78 $2.20 $1.98 ($0.22) ($0.11) ($0.10)
3 11/10/2009 15:49 $1.10 90 35 $0.00 $23.68 $3.30 $1.98 ($1.32) ($0.44) ($0.40)
4 11/10/2009 23:00 $1.10 90 5 $6.30 $28.88 $4.40 $8.28 $3.88 $0.97 $0.88
5 11/11/2009 11:42 $1.10 90 9 $2.25 $30.03 $5.50 $10.53 $5.03 $1.01 $0.91
6 11/29/2009 0:42 $1.10 90 32 $0.00 $28.93 $6.60 $10.53 $3.93 $0.66 $0.60
7 11/29/2009 22:16 $1.10 90 25 $0.00 $27.83 $7.70 $10.53 $2.83 $0.40 $0.37
8 12/12/2009 23:52 $1.10 90 48 $0.00 $26.73 $8.80 $10.53 $1.73 $0.22 $0.20
9 12/14/2009 22:20 $1.10 90 25 $0.00 $25.63 $9.90 $10.53 $0.63 $0.07 $0.06
10 12/14/2009 23:31 $1.10 90 18 $1.62 $26.15 $11.00 $12.15 $1.15 $0.12 $0.10
11 12/15/2009 21:08 $1.10 90 22 $0.00 $25.05 $12.10 $12.15 $0.05 $0.00 $0.00
12 12/24/2009 22:44 $1.10 90 39 $0.00 $23.95 $13.20 $12.15 ($1.05) ($0.09) ($0.08)
13 12/28/2009 19:39 $1.10 90 8 $2.70 $25.55 $14.30 $14.85 $0.55 $0.04 $0.04
14 12/29/2009 17:37 $1.10 90 67 $0.00 $24.45 $15.40 $14.85 ($0.55) ($0.04) ($0.04)
15 1/10/2010 19:49 $1.10 90 8 $2.70 $26.05 $16.50 $17.55 $1.05 $0.07 $0.06
16 1/10/2010 20:35 $1.10 90 42 $0.00 $24.95 $17.60 $17.55 ($0.05) ($0.00) ($0.00)
17 6/6/2010 12:44 $1.10 90 21 $0.00 $23.85 $18.70 $17.55 ($1.15) ($0.07) ($0.06)
18 6/15/2010 2:34 $1.10 90 55 $0.00 $22.75 $19.80 $17.55 ($2.25) ($0.13) ($0.11)
19 6/17/2010 2:18 $1.10 90 12 $1.98 $23.63 $20.90 $19.53 ($1.37) ($0.07) ($0.07)
20 6/24/2010 21:35 $1.10 90 52 $0.00 $22.53 $22.00 $19.53 ($2.47) ($0.12) ($0.11)
21 6/24/2010 23:40 $1.10 90 37 $0.00 $21.43 $23.10 $19.53 ($3.57) ($0.17) ($0.15)
22 6/25/2010 1:44 $1.10 90 5 $6.30 $26.63 $24.20 $25.83 $1.63 $0.07 $0.07
23 6/25/2010 13:35 $1.10 90 11 $1.98 $27.51 $25.30 $27.81 $2.51 $0.11 $0.10
24 6/28/2010 23:35 $1.10 90 18 $1.62 $28.03 $26.40 $29.43 $3.03 $0.13 $0.11
25 6/30/2010 0:25 $1.10 90 54 $0.00 $26.93 $27.50 $29.43 $1.93 $0.08 $0.07
26 8/15/2010 20:08 $1.10 90 31 $0.00 $25.83 $28.60 $29.43 $0.83 $0.03 $0.03
27 8/24/2010 23:30 $1.10 90 22 $0.00 $24.73 $29.70 $29.43 ($0.27) ($0.01) ($0.01)
28 8/26/2010 1:16 $1.10 90 52 $0.00 $23.63 $30.80 $29.43 ($1.37) ($0.05) ($0.04)
29 8/26/2010 22:05 $1.10 90 11 $1.98 $24.51 $31.90 $31.41 ($0.49) ($0.02) ($0.02)
30 8/28/2010 14:51 $1.10 90 41 $0.00 $23.41 $33.00 $31.41 ($1.59) ($0.05) ($0.05)
31 9/5/2010 18:51 $1.10 90 17 $1.62 $23.93 $34.10 $33.03 ($1.07) ($0.03) ($0.03)
32 9/5/2010 19:19 $1.10 90 3 $9.90 $32.73 $35.20 $42.93 $7.73 $0.24 $0.22
33 9/8/2010 23:31 $1.10 90 11 $1.98 $33.61 $36.30 $44.91 $8.61 $0.26 $0.24
34 9/9/2010 0:30 $1.10 90 59 $0.00 $32.51 $37.40 $44.91 $7.51 $0.22 $0.20
35 9/10/2010 23:56 $1.10 90 14 $1.80 $33.21 $38.50 $46.71 $8.21 $0.23 $0.21
36 9/10/2010 23:59 $1.10 90 22 $0.00 $32.11 $39.60 $46.71 $7.11 $0.20 $0.18
37 9/11/2010 19:45 $1.10 90 6 $4.95 $35.96 $40.70 $51.66 $10.96 $0.30 $0.27
38 9/11/2010 20:38 $1.10 90 23 $0.00 $34.86 $41.80 $51.66 $9.86 $0.26 $0.24
39 9/15/2010 0:09 $1.10 90 28 $0.00 $33.76 $42.90 $51.66 $8.76 $0.22 $0.20
40 9/15/2010 0:39 $1.10 90 69 $0.00 $32.66 $44.00 $51.66 $7.66 $0.19 $0.17
41 9/16/2010 1:06 $1.10 90 10 $1.98 $33.54 $45.10 $53.64 $8.54 $0.21 $0.19
42 9/19/2010 17:19 $1.10 90 34 $0.00 $32.44 $46.20 $53.64 $7.44 $0.18 $0.16
43 9/19/2010 17:22 $1.10 90 1 $22.50 $53.84 $47.30 $76.14 $28.84 $0.67 $0.61
44 9/25/2010 13:19 $1.10 90 15 $1.80 $54.54 $48.40 $77.94 $29.54 $0.67 $0.61
45 9/25/2010 13:46 $1.10 90 46 $0.00 $53.44 $49.50 $77.94 $28.44 $0.63 $0.57
46 9/25/2010 20:50 $1.10 90 20 $0.00 $52.34 $50.60 $77.94 $27.34 $0.59 $0.54
47 9/25/2010 21:48 $1.10 90 88 $0.00 $51.24 $51.70 $77.94 $26.24 $0.56 $0.51
48 9/26/2010 18:17 $1.10 90 32 $0.00 $50.14 $52.80 $77.94 $25.14 $0.52 $0.48
49 9/26/2010 18:51 $1.10 90 35 $0.00 $49.04 $53.90 $77.94 $24.04 $0.49 $0.45
50 9/26/2010 20:36 $1.10 90 4 $7.65 $55.59 $55.00 $85.59 $30.59 $0.61 $0.56
51 9/28/2010 0:40 $1.10 90 2 $13.95 $68.44 $56.10 $99.54 $43.44 $0.85 $0.77
52 9/29/2010 0:43 $1.10 90 58 $0.00 $67.34 $57.20 $99.54 $42.34 $0.81 $0.74
53 9/30/2010 0:25 $1.10 90 15 $1.80 $68.04 $58.30 $101.34 $43.04 $0.81 $0.74
54 10/3/2010 22:59 $1.10 90 63 $0.00 $66.94 $59.40 $101.34 $41.94 $0.78 $0.71
55 10/8/2010 0:22 $1.10 90 42 $0.00 $65.84 $60.50 $101.34 $40.84 $0.74 $0.68
56 10/9/2010 19:04 $1.10 90 7 $3.60 $68.34 $61.60 $104.94 $43.34 $0.77 $0.70
57 10/9/2010 20:25 $1.10 90 46 $0.00 $67.24 $62.70 $104.94 $42.24 $0.74 $0.67
58 10/10/2010 13:39 $1.10 90 43 $0.00 $66.14 $63.80 $104.94 $41.14 $0.71 $0.64
59 10/10/2010 18:54 $1.10 90 31 $0.00 $65.04 $64.90 $104.94 $40.04 $0.68 $0.62
60 10/14/2010 0:27 $1.10 90 50 $0.00 $63.94 $66.00 $104.94 $38.94 $0.65 $0.59
61 10/14/2010 0:31 $1.10 90 4 $7.65 $70.49 $67.10 $112.59 $45.49 $0.75 $0.68
62 10/16/2010 23:14 $1.10 90 40 $0.00 $69.39 $68.20 $112.59 $44.39 $0.72 $0.65
63 10/16/2010 23:30 $1.10 90 22 $0.00 $68.29 $69.30 $112.59 $43.29 $0.69 $0.62
64 10/16/2010 23:58 $1.10 90 27 $0.00 $67.19 $70.40 $112.59 $42.19 $0.66 $0.60
65 10/17/2010 18:40 $1.10 90 6 $4.95 $71.04 $71.50 $117.54 $46.04 $0.71 $0.64
66 10/19/2010 0:19 $1.10 90 23 $0.00 $69.94 $72.60 $117.54 $44.94 $0.68 $0.62
67 10/23/2010 12:56 $1.10 90 13 $1.80 $70.64 $73.70 $119.34 $45.64 $0.68 $0.62
68 10/23/2010 21:34 $1.10 90 51 $0.00 $69.54 $74.80 $119.34 $44.54 $0.66 $0.60
69 10/23/2010 23:26 $1.10 90 36 $0.00 $68.44 $75.90 $119.34 $43.44 $0.63 $0.57
70 10/24/2010 14:27 $1.10 90 76 $0.00 $67.34 $77.00 $119.34 $42.34 $0.60 $0.55
71 10/29/2010 0:39 $1.10 90 22 $0.00 $66.24 $78.10 $119.34 $41.24 $0.58 $0.53
72 10/30/2010 1:27 $1.10 90 29 $0.00 $65.14 $79.20 $119.34 $40.14 $0.56 $0.51
73 10/30/2010 10:56 $1.10 90 60 $0.00 $64.04 $80.30 $119.34 $39.04 $0.53 $0.49
74 10/30/2010 16:42 $1.10 90 8 $2.70 $65.64 $81.40 $122.04 $40.64 $0.55 $0.50
75 10/30/2010 18:12 $1.10 90 49 $0.00 $64.54 $82.50 $122.04 $39.54 $0.53 $0.48
76 10/31/2010 20:21 $1.10 90 21 $0.00 $63.44 $83.60 $122.04 $38.44 $0.51 $0.46
77 11/3/2010 1:11 $1.10 90 12 $1.98 $64.32 $84.70 $124.02 $39.32 $0.51 $0.46
78 11/4/2010 1:13 $1.10 90 61 $0.00 $63.22 $85.80 $124.02 $38.22 $0.49 $0.45
79 11/5/2010 0:52 $1.10 90 16 $1.62 $63.74 $86.90 $125.64 $38.74 $0.49 $0.45
80 11/6/2010 13:24 $1.10 90 12 $1.98 $64.62 $88.00 $127.62 $39.62 $0.50 $0.45
81 11/6/2010 19:14 $1.10 90 22 $0.00 $63.52 $89.10 $127.62 $38.52 $0.48 $0.43
82 11/19/2010 22:05 $1.10 90 4 $7.65 $70.07 $90.20 $135.27 $45.07 $0.55 $0.50
83 11/20/2010 13:30 $1.10 90 39 $0.00 $68.97 $91.30 $135.27 $43.97 $0.53 $0.48
84 11/20/2010 19:52 $1.10 90 27 $0.00 $67.87 $92.40 $135.27 $42.87 $0.51 $0.46
85 11/22/2010 16:33 $1.10 90 37 $0.00 $66.77 $93.50 $135.27 $41.77 $0.49 $0.45
86 11/23/2010 16:36 $1.10 90 45 $0.00 $65.67 $94.60 $135.27 $40.67 $0.47 $0.43
87 11/24/2010 21:57 $1.10 90 15 $1.80 $66.37 $95.70 $137.07 $41.37 $0.48 $0.43
88 11/25/2010 21:55 $1.10 90 14 $1.80 $67.07 $96.80 $138.87 $42.07 $0.48 $0.43
89 11/27/2010 0:15 $1.10 90 20 $0.00 $65.97 $97.90 $138.87 $40.97 $0.46 $0.42
90 11/27/2010 16:34 $1.10 90 39 $0.00 $64.87 $99.00 $138.87 $39.87 $0.44 $0.40
91 11/29/2010 22:48 $1.10 90 6 $4.95 $68.72 $100.10 $143.82 $43.72 $0.48 $0.44
92 12/1/2010 0:01 $1.10 90 48 $0.00 $67.62 $101.20 $143.82 $42.62 $0.46 $0.42
93 12/1/2010 22:33 $1.10 90 11 $1.98 $68.50 $102.30 $145.80 $43.50 $0.47 $0.43
94 12/1/2010 22:39 $1.10 90 51 $0.00 $67.40 $103.40 $145.80 $42.40 $0.45 $0.41
95 12/1/2010 23:41 $1.10 90 16 $1.62 $67.92 $104.50 $147.42 $42.92 $0.45 $0.41
96 12/4/2010 18:05 $1.10 90 6 $4.95 $71.77 $105.60 $152.37 $46.77 $0.49 $0.44
97 12/4/2010 18:51 $1.10 90 25 $0.00 $70.67 $106.70 $152.37 $45.67 $0.47 $0.43
98 12/7/2010 22:29 $1.10 90 33 $0.00 $69.57 $107.80 $152.37 $44.57 $0.45 $0.41
99 12/8/2010 23:23 $1.10 90 34 $0.00 $68.47 $108.90 $152.37 $43.47 $0.44 $0.40
100 12/19/2010 18:00 $1.10 90 51 $0.00 $67.37 $110.00 $152.37 $42.37 $0.42 $0.39
101 12/21/2010 22:06 $1.10 90 35 $0.00 $66.27 $111.10 $152.37 $41.27 $0.41 $0.37
102 12/21/2010 23:20 $1.10 90 19 $0.00 $65.17 $112.20 $152.37 $40.17 $0.39 $0.36
103 12/23/2010 0:21 $1.10 90 32 $0.00 $64.07 $113.30 $152.37 $39.07 $0.38 $0.34
104 12/26/2010 22:38 $1.10 90 21 $0.00 $62.97 $114.40 $152.37 $37.97 $0.37 $0.33
105 12/30/2010 17:09 $1.10 90 33 $0.00 $61.87 $115.50 $152.37 $36.87 $0.35 $0.32
106 12/30/2010 18:13 $1.10 90 42 $0.00 $60.77 $116.60 $152.37 $35.77 $0.34 $0.31
107 1/3/2011 7:32 $1.10 90 12 $1.98 $61.65 $117.70 $154.35 $36.65 $0.34 $0.31
108 1/13/2011 0:26 $1.10 90 27 $0.00 $60.55 $118.80 $154.35 $35.55 $0.33 $0.30
109 1/13/2011 21:36 $1.10 90 6 $4.95 $64.40 $119.90 $159.30 $39.40 $0.36 $0.33
110 1/13/2011 22:19 $1.10 90 22 $0.00 $63.30 $121.00 $159.30 $38.30 $0.35 $0.32
111 1/13/2011 22:28 $1.10 90 38 $0.00 $62.20 $122.10 $159.30 $37.20 $0.34 $0.30
112 1/16/2011 17:03 $1.10 90 22 $0.00 $61.10 $123.20 $159.30 $36.10 $0.32 $0.29
113 1/16/2011 17:38 $1.10 90 22 $0.00 $60.00 $124.30 $159.30 $35.00 $0.31 $0.28
114 1/25/2011 9:55 $1.10 90 51 $0.00 $58.90 $125.40 $159.30 $33.90 $0.30 $0.27
115 1/25/2011 10:51 $1.10 90 2 $13.95 $71.75 $126.50 $173.25 $46.75 $0.41 $0.37
116 1/26/2011 3:45 $1.10 90 11 $1.98 $72.63 $127.60 $175.23 $47.63 $0.41 $0.37
117 1/30/2011 18:17 $1.10 90 38 $0.00 $71.53 $128.70 $175.23 $46.53 $0.40 $0.36
118 1/30/2011 18:47 $1.10 90 16 $1.62 $72.05 $129.80 $176.85 $47.05 $0.40 $0.36
119 1/30/2011 19:38 $1.10 90 2 $13.95 $84.90 $130.90 $190.80 $59.90 $0.50 $0.46
120 2/5/2011 22:42 $1.10 90 24 $0.00 $83.80 $132.00 $190.80 $58.80 $0.49 $0.45
121 2/5/2011 23:45 $1.10 90 24 $0.00 $82.70 $133.10 $190.80 $57.70 $0.48 $0.43
122 2/5/2011 23:48 $1.10 90 9 $2.25 $83.85 $134.20 $193.05 $58.85 $0.48 $0.44
123 2/6/2011 22:41 $1.10 90 16 $1.62 $84.37 $135.30 $194.67 $59.37 $0.48 $0.44
124 2/6/2011 22:50 $1.10 90 7 $3.60 $86.87 $136.40 $198.27 $61.87 $0.50 $0.45
125 2/6/2011 23:21 $1.10 90 36 $0.00 $85.77 $137.50 $198.27 $60.77 $0.49 $0.44
126 2/8/2011 13:40 $1.10 90 21 $0.00 $84.67 $138.60 $198.27 $59.67 $0.47 $0.43
127 2/8/2011 13:43 $1.10 90 76 $0.00 $83.57 $139.70 $198.27 $58.57 $0.46 $0.42
128 2/8/2011 18:59 $1.10 90 14 $1.80 $84.27 $140.80 $200.07 $59.27 $0.46 $0.42
129 2/8/2011 19:42 $1.10 90 11 $1.98 $85.15 $141.90 $202.05 $60.15 $0.47 $0.42
130 2/8/2011 20:09 $1.10 90 25 $0.00 $84.05 $143.00 $202.05 $59.05 $0.45 $0.41
131 2/8/2011 21:56 $1.10 90 50 $0.00 $82.95 $144.10 $202.05 $57.95 $0.44 $0.40
132 2/9/2011 22:12 $1.10 90 29 $0.00 $81.85 $145.20 $202.05 $56.85 $0.43 $0.39
133 2/9/2011 22:27 $1.10 90 19 $0.00 $80.75 $146.30 $202.05 $55.75 $0.42 $0.38
134 2/9/2011 22:59 $1.10 90 5 $6.30 $85.95 $147.40 $208.35 $60.95 $0.45 $0.41
135 2/9/2011 23:39 $1.10 90 14 $1.80 $86.65 $148.50 $210.15 $61.65 $0.46 $0.42
136 2/11/2011 22:02 $1.10 90 43 $0.00 $85.55 $149.60 $210.15 $60.55 $0.45 $0.40
Game  Date  Buy in  Entries  Rank  Prize  Balance  Buy-in Total  Prize Total  Profit Total  Profit / Game  ROI / Buy-in

In order to comment, you must login or register.
Take Quiz
New here? Take our Poker Assessment to start your education.
already a member? sign in here
JavaScript must be enabled for Sign In.
Please check your broswer settings.
Learn From basics to advanced strategy
Practice Improve your skills with our trainers
Win! Establish yourself as a winning player
/Featured Promotions/
Progressive Jackpot Progressive Jackpot Playing our new 'Scratch & Match' game is free and very easy. If you match 3 symbols you win a prize!!!! View details
Earn 10 Tournament Tickets Today! Earn 10 Tournament Tickets Today! Invite your friends to join Poker School and you could earn up to 10 tournament tickets as a reward! View details

Getting PokerStars is easy: download and install the PokerStars game software, create your free player account, and validate your email address. Clicking on the download poker button will lead to the installation of compatible poker software on your PC of 51.7 MB, which will enable you to register and play poker on the PokerStars platform. To uninstall PokerStars use the Windows uninstaller: click Start > Control Panel and then select Add or Remove programs > Select PokerStars and click Uninstall or Remove.

Copyright (c) PokerSchoolOnline.com. All rights reserved, Rational Group, Douglas Bay Complex, King Edward Road, Onchan, Isle of Man, IM3 1DZ. You can email us on support@pokerschoolonline.com