CellarTracker Main Site
Register for Forum | Login | My Profile | Member List | Search

RE: Cellar Map - new spreadsheet

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Cellar Talk] >> CellarTracker Support >> RE: Cellar Map - new spreadsheet Page: <<   < prev  1 [2] 3 4 5   next >   >>
Login
Message << Older Topic   Newer Topic >>
RE: Cellar Map - new spreadsheet - 5/20/2018 12:11:25 PM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		I have been playing around with this.



It is IMPORTANT to note that this graph does not use a sophisticated algorithm like the ones used in the CellarTracker Availability (Drinkability) Index. It is a percentage of time, prior to, during or after the drinking window with some visual graphical tools to indicate where a wine is within those percentages.

Any thoughts?



_____________________________

Andrew

(in reply to anevard)
Post #: 31
RE: Cellar Map - new spreadsheet - 6/3/2018 8:22:31 PM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Take a look at the new version 9.70 Dashboard.

Dashboard demo video

_____________________________

Andrew

(in reply to anevard)
Post #: 32
RE: Cellar Map - new spreadsheet - 6/11/2018 8:55:14 AM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Hey All,

In addition to the info in the video in the previous post, I have just added price filters.



The minimum and maximum price paid per bottle can be filtered by changing the default amounts in the Max and Min cells.

The indicators turn yellow to indicate that the Max, Min or both filters are active. Deleting a value in either Max or Min filters will reset that filter.



_____________________________

Andrew

(in reply to anevard)
Post #: 33
RE: Cellar Map - new spreadsheet - 6/16/2018 6:11:46 PM   
mclancy10006

 

Posts: 4504
Joined: 3/19/2007
From: Cape Cod, MA & Bellevue, WA
Status: offline 		This is most excellent! Thanks again Andrew for setting me up for this.

-Mark

(in reply to anevard)
Post #: 34
RE: Cellar Map - new spreadsheet - 6/29/2018 8:41:11 AM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Glad you like it Mark.

It's a long weekend here so I have a bit of free time, if anyone is interested in getting a Cellar Map set up for them.

Cheers,


_____________________________

Andrew

(in reply to mclancy10006)
Post #: 35
RE: Cellar Map - new spreadsheet - 11/9/2018 11:09:19 AM   
Slye

 

Posts: 1922
Joined: 8/3/2013
Status: offline 		Hi Andrew -- just seeing this. How do I set this up? It looks like it is incredibly useful!

(in reply to anevard)
Post #: 36
RE: Cellar Map - new spreadsheet - 12/8/2018 9:57:29 AM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Hey All,

I have not been around for a while. Life has been hectic but good! Hope all your wine has been complex with a long finish these past few months.

I might have some time over the holidays to set up a few cellars on Cellar Map. I have finally responded to everyone that PM'd me and to Slye as well. Please understand that I have to setup the layout for each person's Cellar Map individually. Unfortunately I can't just send you an un-formatted file, the setup is just too involved. Perhaps one day.

If any high level Excel VBA coders want to help out upgrading and are willing to deal with with my non-professional code, I am happy to explore ways to improve Cellar Map.

Cheers,


_____________________________

Andrew

(in reply to anevard)
Post #: 37
RE: Cellar Map - new spreadsheet - 12/26/2018 12:00:01 PM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Been fiddling with adding a Last Drank column to the Dashboard. This way I can see at a glance when I last drank a wine without having to drill down on the CT website. Implementing it was a bit more complicated than I had hoped, but I finally got it working!

Love to hear your thoughts and ideas.



I also changed the color slicer to use the CT TYPE field. This now provides a much more granular level of filtration for wine types.




_____________________________

Andrew

(in reply to anevard)
Post #: 38
RE: Cellar Map - new spreadsheet - 1/5/2019 9:23:54 AM   
kobimaru

 

Posts: 2
Joined: 10/6/2017
Status: offline 		Andrew, Thanks for showing us the work you have been doing on the visual interface. I think this is very useful and would love to see the spreadsheet published in public forum. That said, I will send you a PM to see if you would send to me privately. I hope one day CellarTracker will include something of this sort in their application.
Gary

(in reply to anevard)
Post #: 39
RE: Cellar Map - new spreadsheet - 1/7/2019 3:37:59 PM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Hey Gary,

I replied to your PM.

As each cellar has a unique layout, it is impossible to provide a simple generic spreadsheet that can accomplish everything Cellar Map can do. Although I have automated 75% of the setup, it still requires individual tweaking and massaging to get each individual cellar layout to work properly. Most cellars only take me an hour or two to setup and most of the time is the back and forth with the cellar owner to make sure the layout is visually representative of their cellar.

I don't mind setting people up whenever I have a few free moments. I have ended up chatting with some interesting wine lovers like myself and I am sure I will someday share a glass with my new acquaintances.

Cheers,



_____________________________

Andrew

(in reply to kobimaru)
Post #: 40
RE: Cellar Map - new spreadsheet - 2/22/2019 8:41:14 PM   
pcartland

 

Posts: 7
Joined: 2/22/2019
Status: offline
quote:

CT webquery.xls
Any idea where I can download a copy of the spreadsheet?

(in reply to anevard)
Post #: 41
RE: Cellar Map - new spreadsheet - 2/22/2019 8:57:06 PM   
pcartland

 

Posts: 7
Joined: 2/22/2019
Status: offline 		I'm proficient in excel and can code in VBA if necessary. Thanks

(in reply to pcartland)
Post #: 42
RE: Cellar Map - new spreadsheet - 3/31/2019 8:01:37 PM   
mdavis

 

Posts: 134
Status: offline 		Amazing piece of Excel wizardry. Can't wait to play with it.

(in reply to pcartland)
Post #: 43
RE: Cellar Map - new spreadsheet - 4/6/2019 3:08:36 PM   
citizencain1

 

Posts: 1
Joined: 3/31/2019
Status: offline 		Does anyone know if Andrew is still involved with this spreadsheet? I PM him awhile back and have not heard anything.
Cheers,
Chris

(in reply to anevard)
Post #: 44
RE: Cellar Map - new spreadsheet - 4/6/2019 3:52:47 PM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		I sent him a note outside of the forum.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to citizencain1)
Post #: 45
RE: Cellar Map - new spreadsheet - 4/6/2019 4:50:28 PM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline
quote:

ORIGINAL: Eric

I sent him a note outside of the forum.

He just got back to me and said he must have missed your message. He does generally try to follow up with everyone.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 46
RE: Cellar Map - new spreadsheet - 4/10/2019 7:04:31 PM   
mdavis

 

Posts: 134
Status: offline 		I also didn't get a response - I'm super interested in the winemap..

Can someone send me the spreadsheet?

-mark

(in reply to Eric)
Post #: 47
RE: Cellar Map - new spreadsheet - 4/28/2019 7:23:58 PM   
AlexGarner

 

Posts: 135
Joined: 6/19/2010
From: Melbourne, Victoria, Australia
Status: offline
quote:

ORIGINAL: anevard

Happy that those of you that are using this Spreadsheet (it needs a good name) are enjoying it. It gives me a lot of pleasure to know that in a small way, I am enhancing your wine experience.



How about...

CellarMapper!!

(in reply to anevard)
Post #: 48
RE: Cellar Map - new spreadsheet - 5/26/2019 7:36:28 AM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Hey All,

Alex, good name. I have pretty much been calling it CellarMap so we are on the same page.

I have been really busy the last few months but I think I have finally managed to get back to everyone and create their CellarMaps.

I have added some new features, which unfortunately caused some regression in the compatibility of the spreadsheet. I had to spend a lot of time tracking down the bugs. In short, it turns out that the standalone version of Excel 2016 PC and the O365 subscription version do NOT have the same functionality. I develop this on the O365 subscription version so it took a lot of patience from a few CellarMap users to help me resolve the issues. There is now a legacy formula switch that allows standalone and previous version users to benefit from the full functionality of the spreadsheet, albeit in a slightly less efficient manner.

MACs are a whole other problem. A few recent MAC users are getting overflow errors on the latest versions. From what I can tell this is not resolved, but as long as I get feedback I will continue working on the bugs to try and eliminate them.

Some things that I am working on (a few in distribution, a few coming soon)

Dashboard zoom in on the Pie Graph, so when there is a lot of detail it is easier to read.
Dashboard Vintage Chart with zoom and cross hairs to easily see year versus region. (this is not my chart so I am not sure whether I can distribute it).
Dashboard filter last drank date, so I filter out wines I have drank in the last X # of years.
Dashboard filter wine name, to make the wine list even more searchable.

That's it for now. Thoughts, ideas, suggestions and help always appreciated.

Cheers,


_____________________________

Andrew

(in reply to AlexGarner)
Post #: 49
RE: Cellar Map - new spreadsheet - 7/30/2019 12:51:26 AM   
Squall

 

Posts: 1
Joined: 7/29/2019
Status: offline 		Hey everyone,

I just found cellartracker while searching a good software to create an inventory for my wine. Right now im using vivino but there is no way to create a layout of my new wine fridges.

Is it possible to get a copy of that excel sheet?

Thanks a lot

Have a nice one.

Thorsten

(in reply to anevard)
Post #: 50
RE: Cellar Map - new spreadsheet - 8/17/2019 5:53:10 AM   
cssmith

 

Posts: 2
Joined: 1/10/2015
Status: offline 		Hello all. I just stumbled across this today. Been using cellar tracker fro a while, but never saw this functionality. Totally amazing.

Is this spread "Cellar Map" still open for use? I would love to get a copy. I did download the web query tool and have it working.

Thanks for any guidance.

(in reply to Squall)
Post #: 51
RE: Cellar Map - new spreadsheet - 9/10/2019 4:15:28 PM   
Funrunner99

 

Posts: 1
Joined: 9/10/2019
Status: offline 		Hi Anevard,

I know I am late to the game but your program looks really interesting. What are the steps to take to use your Cellarmap program with Cellar Tracker? I have an approximately 1500 bottle room. Most of it is individual slots with a section on one wall with cubes that I can put cases & half cases in. And I have a 200 bottle wine refrigerator in the front corner of the room for white wine & champagne. Would love to figure out how your program works.

Thanks,

John

(in reply to anevard)
Post #: 52
RE: Cellar Map - new spreadsheet - 9/10/2019 10:30:24 PM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		I am not sure if Andrew has been replying. Can you let me know. If not I can email him directly.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Funrunner99)
Post #: 53
RE: Cellar Map - new spreadsheet - 9/19/2019 2:16:35 PM   
dsGris

 

Posts: 4712
Joined: 8/31/2009
From: Portland, OR
Status: offline 		It's about time for a revisit. I recently moved most of the cellar to a new room in the expanded basement. Relocated the racking and purchased a bunch of Weinboxes for the move and additional storage. I need instructions on how to proceed with getting started. Thanks, Dennis G

_____________________________

DennisG
Granpa Wino

(in reply to Eric)
Post #: 54
RE: Cellar Map - new spreadsheet - 12/1/2019 10:16:55 AM   
anevard

 

Posts: 109
Joined: 6/5/2006
Status: offline 		Hi All,

Just a quick note.

I have been extremely busy these past many months. Unfortunately, I have not had anytime to further develop or even setup new sheets for people. I still believe in this CellarMap project and would love an excel expert (both formulas and VBA) to partner with in order to keep moving forward and growing.

That being said, for those that have PM'd and emailed me, reach out again over the holidays and I will try and get you going.

Cheers,


_____________________________

Andrew

(in reply to dsGris)
Post #: 55
RE: Cellar Map - new spreadsheet - 12/10/2019 2:41:54 PM   
Daveluca

 

Posts: 5
Joined: 6/9/2015
Status: offline 		How can I obtain this worksheet?

(in reply to anevard)
Post #: 56
RE: Cellar Map - new spreadsheet - 12/11/2019 4:10:24 PM   
Daveluca

 

Posts: 5
Joined: 6/9/2015
Status: offline 		I would like to get on the spreadsheet, can you help me with this, I have 2 cellars one in RI and in UT, approx 400 btls in each.

(in reply to anevard)
Post #: 57
RE: Cellar Map - new spreadsheet - 12/16/2019 1:32:47 PM   
Daveluca

 

Posts: 5
Joined: 6/9/2015
Status: offline 		Hi Andrew, I too would like to be able to use the spreadsheet, how can I obtain a copy or purchase a copy..

thanks

(in reply to anevard)
Post #: 58
RE: Cellar Map - new spreadsheet - 2/9/2020 4:35:53 AM   
R. Weaver

 

Posts: 22
Joined: 4/26/2010
Status: offline 		Also very interested in this. How do I get started? Is there a way to download the sheet?

(in reply to Daveluca)
Post #: 59
RE: Cellar Map - new spreadsheet - 4/3/2020 5:30:11 PM   
Mcfly6667

 

Posts: 1
Joined: 3/8/2020
Status: offline 		I PMd Andrew today as well. Sounds like he's been very busy.

(in reply to R. Weaver)
Post #: 60
Page:   <<   < prev  1 [2] 3 4 5   next >   >>
All Forums >> [Cellar Talk] >> CellarTracker Support >> RE: Cellar Map - new spreadsheet Page: <<   < prev  1 [2] 3 4 5   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.143