Spreadsheets (3 Viewers)

[horseshoez]

Does anyone use a spreadsheet to manage their collection? I created one with a separate sheet for each set—pretty straightforward—but I’m curious to see what others are using. If anyone has a template to share, I’d love to check it out in case it’s more efficient than mine.

Thanks in advance!

 

[TheRealTeddyKGB]

@Godzilla28

 

[sethwanab]

Mine is in Keynote so it easier to add/crop pictures. I also use it as a picture idea board. It’s 32 pages right now.

 

[horseshoez]

I didn't even think about Keynote. Probably looks better for what you mentioned above, being able to add pictures next to the quantities or actual table.

 

[BearMetal]

Here's an example of mine - I mostly wanted to have accurate counts so that if I needed to snap-buy something, I didn't have to run down to the basement to check what I already had.

 

[Moxie Mike]

Here's an example of mine - I mostly wanted to have accurate counts so that if I needed to snap-buy something, I didn't have to run down to the basement to check what I already had.

View attachment 1464741

Dibs on the 336 Circus Circus $1s lol

 

[fsupolo]

Here's an example of mine - I mostly wanted to have accurate counts so that if I needed to snap-buy something, I didn't have to run down to the basement to check what I already had.

View attachment 1464741

Love this. May "borrow" your format.

 

[BearMetal]

I can turn it into a template if anyone wants it. I tried not to put too much emphasis on design since it was only for me. Also, there's this:

... I may have a problem

 

[fsupolo]

I can turn it into a template if anyone wants it. I tried not to put too much emphasis on design since it was only for me. Also, there's this:

View attachment 1464750

... I may have a problem

Love this!!!! I may delete column A from this sheet in my version though…hahahahahaha

 

[NotRealNameNoSir]

Definitely! I use something like this to game out starting stacks and breakdowns. Cash, then tournament. "Estimated Need" came from somewhere on here, obviously not set in stone.

 

[doublebooyah85]

Y’all should have seen the chicken scratch I was working up on a used envelope as I built out a new t100 tourney set.

 

[MC_CPA]

Tiger Stats:

"Only" another $6,290 until my collection is complete. Let's hope $SPY has a good year.

 

[Himewad]

I have a spreadsheet for each of my chip sets. Plus a monster spreadsheet to keep track of my dealer button collection.

 

[Poker Zombie]

Here's how I track what I have. I can sort to show only cash sets/tourney sets/HU-games, or whatever.
It's just one worksheet in a workbook, which has one or more sheets for each set and how distribute optimize starting stacks depending on blind structure and number of players.

 

[horseshoez]

What in the Sam Hill world did I just discover?! I mean I knew I’d see some interesting stuff but some of you guys really dive into the nitty gritty details. Impressive. Especially @BearMetal pull down options. Wow!

 

[BearMetal]

Well, for anyone who wants it, here it is. I removed most of the set names, left 3 for examples. All other dropdowns I left. I'm sure you all can figure it out. Google's a little weird with how they do grouping; you always need at least 1 row to anchor to. That's what the examples are for

https://docs.google.com/spreadsheets/d/1Sh-9Pn0cyq--d83nXmfTtDCM4D4e5XIbMUygF3FZUdw/template/preview

 

[NotRealNameNoSir]

Well, for anyone who wants it, here it is. I removed most of the set names, left 3 for examples. All other dropdowns I left. I'm sure you all can figure it out. Google's a little weird with how they do grouping; you always need at least 1 row to anchor to. That's what the examples are for

https://docs.google.com/spreadsheets/d/1Sh-9Pn0cyq--d83nXmfTtDCM4D4e5XIbMUygF3FZUdw/template/preview

You are crazy helpful. Thank you for all that you do! Still using the Poker Mavens home server you helped me setup.

 

[fsupolo]

Well, for anyone who wants it, here it is. I removed most of the set names, left 3 for examples. All other dropdowns I left. I'm sure you all can figure it out. Google's a little weird with how they do grouping; you always need at least 1 row to anchor to. That's what the examples are for

https://docs.google.com/spreadsheets/d/1Sh-9Pn0cyq--d83nXmfTtDCM4D4e5XIbMUygF3FZUdw/template/preview

Really appreciate this!

 

[sethwanab]

I also have a table for tracking and history. Have to know who you bought from and for how much. I also keep track of value from current sales. Incoming tracking #'s and if you have received them or not. When you have packaged showing up that you forgot you ordered it becomes useful.

 

[sethwanab]

you also have to get your order list ready for upcoming chips so you can pull the trigger when the time is right.

 

[fsupolo]

You guys don’t mess around…hahahahaha

 

[Poker Zombie]

Have to know who you bought from and for how much.

I used to track this as well, but have since deleted that info.

I really do not want to know exactly how much I have spent on this hobby.

 

[Machine]

Can't wait to revamp this =)

 

[Machine]

Here's an example of mine - I mostly wanted to have accurate counts so that if I needed to snap-buy something, I didn't have to run down to the basement to check what I already had.

View attachment 1464741

These drop-downs are the biggest lowkey flex in the thread!

 

[ShuffleNDeal]

After reading this thread I can see I'm not the only one. TY

 

[horseshoez]

These drop-downs are the biggest lowkey flex in the thread!

View attachment 1465015

That's exactly what I said when I opened up to it. Holy crap.