Build A new spreadsheet: Tracking playc

[mushin]

To date my spreadsheet for tracking my play is pretty basic. I am getting ready to update it. This will also be a great way for me to actually work through the math a bit. Anyway... what categories do you track on your spreadsheet.

Right now I am am simply tracking:

Total Bankroll
Session Bankroll
Buy In Total
Win / Loss
Table Minimum
Comps received
Notes

and the obvious things like location and date.

I am planning to add:
total session time (Time at the location)
play time (Approx time actually playing)

Win / Loss per session on that trip
Average Win/Loss (based upon all session)
Hourly Win/Loss per session / trip
Hourly Win/Loss per total time
Hourly Win/Loss per total play time

Any other suggestions or ideas are greatly appreciated.

[Bodarc]

I would leave out some of the win/loss info and insert Casino, Rules & Decks, Penetration, Dealer, Dealer Rating & General Notes

[mushin]

I would leave out some of the win/loss info and insert Casino, Rules & Decks, Penetration, Dealer, Dealer Rating & General Notes

I track those already but as text fields (No Penetration though) and thus don't perform any calculations on them... however you did bring to mind an idea where I could calculate some figures based on the number of decks and penetration as that changes from dealer to dealer.

What do you mean by dealer rating?

[Bodarc]

Dealer who yaks all the time and slows the game, grumpy, bad cuts etc. I rate them * to *****
Also a good dealer, try to get their hours and shifts etc

[max85]

i use paper cards which i take to each shop then write the results of each session on. then at the end of the trip i write the total hrs on a spreadsheet and result for tracking. i also have another sheet for BO's and anything note worthy.

the playing cards have:

Time start, time end (actual table time)
shop
BR start
BR end
HRS
Result

[mushin]

Dealer who yaks all the time and slows the game, grumpy, bad cuts etc. I rate them * to *****
Also a good dealer, try to get their hours and shifts etc

Oh I like this... I'll rate them in terms of dealers to play when seeking an increase in comps and player card tier points (The Slow ones) and... time to make money dealers for hit and run sessions!
I am training my wife as the non-counting comp hustler (although she will keep count). But if she wants to play I could have her hit the SLOW tables while I hit the profitable dealers. Or for those times where I am playing a bit more for recreation with friends and family and my goal is entertainment rather then working my game.

[Avincow]

gotta have the last column in your spreadsheet be Misc. Comments so you can jot down anything interesting that happened during a particular session.

[terry0222]

I infer from your post that you maintain your results in terms of $$. (Win/loss, average win/loss). I also keep my results in $, but ALSO keep a separate record based upon UNITS. I define a unit as the minimum bet I play at a given table. I suspect most of us do not always play with the same min bet, but may find that sometimes we play, for instance a $15 min bet table and other times a $25 min bet table, or perhaps $50/$100. I know I pick different tables based upon who is dealing, availability, conditions, etc. At any rate, if everything on my spreadsheet is in $ only, the results can be deceiving. Therefore, I also maintain a record of units won/lost, units/hour, etc. It is actually a better way to compare results that using $$ (unless you absolutely play at the same stakes every time).

By-the-way, I don't believe you are keeping a record of your bet spreads. For instance, if you are playing a shoe game with a $10 min bet, you might also want to note that you are spreading your bets from, for instance, $10-$120 or whatever your spread is. In terms of units, I would note a UNIT spread of 1-12. In my comments column I would note why I bet spread deviated from my "typical" spread. (Heat, no heat, big bettor at table getting all the attention, etc.) Hope this helps

[mushin]

I infer from your post that you maintain your results in terms of $$. (Win/loss, average win/loss). I also keep my results in $, but ALSO keep a separate record based upon UNITS. I define a unit as the minimum bet I play at a given table. I suspect most of us do not always play with the same min bet, but may find that sometimes we play, for instance a $15 min bet table and other times a $25 min bet table, or perhaps $50/$100. I know I pick different tables based upon who is dealing, availability, conditions, etc. At any rate, if everything on my spreadsheet is in $ only, the results can be deceiving. Therefore, I also maintain a record of units won/lost, units/hour, etc. It is actually a better way to compare results that using $$ (unless you absolutely play at the same stakes every time).

By-the-way, I don't believe you are keeping a record of your bet spreads. For instance, if you are playing a shoe game with a $10 min bet, you might also want to note that you are spreading your bets from, for instance, $10-$120 or whatever your spread is. In terms of units, I would note a UNIT spread of 1-12. In my comments column I would note why I bet spread deviated from my "typical" spread. (Heat, no heat, big bettor at table getting all the attention, etc.) Hope this helps

I do record what I managed to get my max bet up to for each session as well as the table minimum. I have not bothered with the table max because... well it frankly does not apply to me yet. While recording my max bet is not exactly the same a what you mention regarding regarding keeping track of the spread it has helped me just knowing if I got a chance to fire away at the game. I really appreciate your idea of recording / tracking units. I have said in other posts that I am not quite ready to up my level of lay to be primarily $25 and up minimum... however by tracking units I can say play at a $10.00 minimum on a $5.00 table and spread from $10 to $100 or $120 for a 1 to 12 spread.

This is a way that I might gradually ramp up my play. Regardless of that units are going to now be tracked thanks to your input.

[Stealth]

To date my spreadsheet for tracking my play is pretty basic. I am getting ready to update it. This will also be a great way for me to actually work through the math a bit. Anyway... what categories do you track on your spreadsheet.

Right now I am am simply tracking:

Total Bankroll
Session Bankroll
Buy In Total
Win / Loss
Table Minimum
Comps received
Notes

and the obvious things like location and date.

I am planning to add:
total session time (Time at the location)
play time (Approx time actually playing)

Win / Loss per session on that trip
Average Win/Loss (based upon all session)
Hourly Win/Loss per session / trip
Hourly Win/Loss per total time
Hourly Win/Loss per total play time

Any other suggestions or ideas are greatly appreciated.

FYI, team reporting requirements for each session (session = one table, one sitting) were:

Casino
Unit$
Bet ramp (units by true count)
Game (decks, pen, rules)
Rounds played (provided means to estimate based on game)
Spots played (has big impact on variance)
Win/loss
Wong in @
RC at call in
Called in by

With this data we could calculate ev, and sd and accumulate those metrics over multiple sessions. Very important to develop play history by player. Multitude of reports and analysis of casinos, players, game types, etc.

All of this was reporting of play that was within approved protocols.

The lone wolf would be well advised to develop this level of detail to prudently manage his/her long term performance.

Hope this is helpful.

[mushin]

FYI, team reporting requirements for each session (session = one table, one sitting) were:

Casino
Unit$
Bet ramp (units by true count)
Game (decks, pen, rules)
Rounds played (provided means to estimate based on game)
Spots played (has big impact on variance)
Win/loss
Wong in @
RC at call in
Called in by

With this data we could calculate ev, and sd and accumulate those metrics over multiple sessions. Very important to develop play history by player. Multitude of reports and analysis of casinos, players, game types, etc.

All of this was reporting of play that was within approved protocols.

The lone wolf would be well advised to develop this level of detail to prudently manage his/her long term performance.

Hope this is helpful.

Ok I may take things to the next level with a more robust too than just the spreadsheet. Maybe a phone app for logging all this. After all is said and done data collection is the key and a spread sheet is just a way to look at that data. I see the biggest problem with having a robust spreadsheet is that the data has to be reliably collected. The easier the collection process the better. There is no better time to "input" data than as events occur. Imagine an app that would facilitate the collection of this data and also provide near real time reporting for a team environment.