Cellartracker Fun with Numbers

[Mark_Christenson]

Consumed: 5,469
Purchased: 7,284

Yikes.

[Howard_Cooper]

No one so far has consumed > purchased.
Just saying’ ….

I’m in similar ratio to the others but am fairly recent into CellarTracker and still don’t have all the data uploaded.

That’d be mathematically impossible in CT as for it to be marked consumed, it has to be purchased first. At most you could have consumption=purchases, but then you’d have no wines left in the cellar

As Eric said, purchased - consumed = # of bottles in your cellar (including pending)?

[Eric_LeVine]

I’ve heard of lawsuits involving doctors where their credit card statements were brought in play trying to demonstrate an alcohol problem. Anyone heard of anything similar involving CT data?

Not yet.

Divorce is the most common scenario where there are lawsuits and scuffles over data.

[Neal.Mollen]

Consumed 2554
Purchased 4589

But some of the data is bad. How did I drink a 2005 Pax in 2002? In January of 2014, I consumed 814 bottles. I think I built a cellar and relocated bottles so I (maybe that was when Eric did me a favor) treated everything as a missing bottle and then re-entered it in the new individual bin location. BUT even if I take that away, it’s still a lot of wine. The scary statistic is the current value of the wine I have drunk since joining CT in 2006. I do not know if it is available but I am afraid to look.

It is unfortunately. All the way on the bottom of the consumed list. Alternatively, if you don’t want to scroll all the way down, summarise purchases by any category and those $ statistics will appear at the top of the page (on the new version that is, in classic it’s always at the bottom)

Ouch

If you ignore it maybe it will go away

[Rodrigo_B]

No one so far has consumed > purchased.
Just saying’ ….

I’m in similar ratio to the others but am fairly recent into CellarTracker and still don’t have all the data uploaded.

That’d be mathematically impossible in CT as for it to be marked consumed, it has to be purchased first. At most you could have consumption=purchases, but then you’d have no wines left in the cellar

As Eric said, purchased - consumed = # of bottles in your cellar (including pending)?

Yep, that’s correct. Aside from that math, I was also speaking to the fact that you can’t mark something in CT as consumed if you haven’t entered it in as a purchase beforehand. Though you can add TNs to wines not marked as purchased or consumed in CT

[Howard_Cooper]

That’d be mathematically impossible in CT as for it to be marked consumed, it has to be purchased first. At most you could have consumption=purchases, but then you’d have no wines left in the cellar

As Eric said, purchased - consumed = # of bottles in your cellar (including pending)?

Yep, that’s correct. Aside from that math, I was also speaking to the fact that you can’t mark something in CT as consumed if you haven’t entered it in as a purchase beforehand. Though you can add TNs to wines not marked as purchased or consumed in CT

Absolutely. When I first started using CT, all my prior purchases that I had not drunk, sold or given away were entered into the program and treated as purchases. Wines entered as consumed (drunk, sold or given away) were all from dates on or after the date I started using CT.

[AndrewH]

I guess I wasn’t thinking or writing clearly. What I really had in mind was more on a current basis, ie a cellar running down, as opposed to lifetime basis.

(One of my problems getting some of my older wines into CT is not being sure when they were purchased. I’m using Jan 1 as a flag that the year of purchase is a guess. )

Oh, you mean a feature where you could easily display cellar size over time?

[RichardFlack]

You say that like it exists already? Can’t say I’ve seen it

[Rodrigo_B]

You say that like it exists already? Can’t say I’ve seen it

No the most elegant solution and it requires a bit of work on your end, but you can run a report on consumption and purchases over time and then the difference between those for each year is how much was added or reduced from your cellar holdings over time.

[RichardFlack]

You say that like it exists already? Can’t say I’ve seen it

No the most elegant solution and it requires a bit of work on your end, but you can run a report on consumption and purchases over time and then the difference between those for each year is how much was added or reduced from your cellar holdings over time.

Ah ok. That’s using the desktop version, yes? One of my issues is that not everything is in the mobile versions. Hopefully that will change before too long.

[Rodrigo_B]

You say that like it exists already? Can’t say I’ve seen it

No the most elegant solution and it requires a bit of work on your end, but you can run a report on consumption and purchases over time and then the difference between those for each year is how much was added or reduced from your cellar holdings over time.

Ah ok. That’s using the desktop version, yes? One of my issues is that not everything is in the mobile versions. Hopefully that will change before too long.

Yes, in the desktop version. I seldom use the mobile app, I’m accustomed to the desktop version to using it is faster for me. Using it to run analytics or do any kind of big inventory work seems really daunting to me. Hopefully the feature set available on mobile improves

[PaulMills]

Consumed 1703
Purchased 2565

That is as far as CT knows.
When considering the time purchases have been tracked, it does not look too bad.

[RichardFlack]

No the most elegant solution and it requires a bit of work on your end, but you can run a report on consumption and purchases over time and then the difference between those for each year is how much was added or reduced from your cellar holdings over time.

Ah ok. That’s using the desktop version, yes? One of my issues is that not everything is in the mobile versions. Hopefully that will change before too long.

Yes, in the desktop version. I seldom use the mobile app, I’m accustomed to the desktop version to using it is faster for me. Using it to run analytics or do any kind of big inventory work seems really daunting to me. Hopefully the feature set available on mobile improves

Yeah, I’m not really doing any analytics yet my focus is on getting the data in. Desktop is in office on 2nd floor (in North American speak) , cellar in basement.
So iPad is handy for updating etc.

I answered the entire quiz they did so that should earn some brownie points for feature improvements, yes?

[AndrewH]

You say that like it exists already? Can’t say I’ve seen it

I think this is the feature that has been longest hoped for by users (at least posting their thoughts here) and something Eric has said maybe in the future.

[Rodrigo_B]

Ah ok. That’s using the desktop version, yes? One of my issues is that not everything is in the mobile versions. Hopefully that will change before too long.

Yes, in the desktop version. I seldom use the mobile app, I’m accustomed to the desktop version to using it is faster for me. Using it to run analytics or do any kind of big inventory work seems really daunting to me. Hopefully the feature set available on mobile improves

Yeah, I’m not really doing any analytics yet my focus is on getting the data in. Desktop is in office on 2nd floor (in North American speak) , cellar in basement.
So iPad is handy for updating etc.

I answered the entire quiz they did so that should earn some brownie points for feature improvements, yes?

Eric had noted a few times they are working a more robust mobile app, so hopefully that come soon.

I live in an apartment, so no proper cellar (just wine fridges) or multiple floors so popping my laptop on the top of the wine fridge is easy. But I can certainly understand the appeal of using a more portable solution for inventory work. That said the current mobile version seems horrible to do any kind of batch work in inventory

[MChang]

I have more shelving arriving tomorrow, hopefully will help a bit with organization. I’m eventually gonna use bins and boxes for multiples and shelving for things that are in 1-3s.

[RichardFlack]

You say that like it exists already? Can’t say I’ve seen it

I think this is the feature that has been longest hoped for by users (at least posting their thoughts here) and something Eric has said maybe in the future.

I’m just an amateur in the tech field but it seems to me there are potentially three groups of devices… ‘phones’, tablets, lap/desktops. The big thing (haha) about phones is screen real estate , or lack of. And I guess they are used differently than the other two. I’d guess more for quick queries (what do I have for tonight’s duck) than updating inventory for today’s shipment.

This is totally a web based app, is that right? So I’m not clear why tablets get the restricted version. They have good screen sizes and reasonable processing power.

[AndrewH]

You can always use the web based version rather than the app … on a tablet it should be fine.

[Adam_G]

3235 consumed
5583 purchased

Purchased usually lags for things like mystery wines and such. I’ve probably got a total of 1.5 cases in that category.
The dollar thing is truly scary sometimes.

[K_N_Haque]

I showed my wife this thread and my numbers to prove my purchasing is harmless. Instead, she thinks you are all nuts. Me, I’m a bit jealous.