quote:

ORIGINAL: anevard

Sorry it takes a while to provide answers, but I have very little free time these days. I do really like that people are using this so I will try and help whenever I can. See my answers below.

So you actually need 3 line items in order to display a depth chart bin. You need the front and back items as well as the depth chart item. See the image below with the 3 items for a particluar bin highlighted. It was the simplist way I could make things work, although it does require the user to enter that 3rd line. I was hoping to automate that someday, but I just don't have enough bandwidth.

quote:

ORIGINAL: pinskycellar
Some other observations:

- If you have multiple tabs for different locations and those locations share a common bin name (Cellar1-A1 and Cellar2-A1), when you double click on that bin in either tab, all bottles from both tabs are listed. Similarly, if a bin shares the same name as the location (House-House), then when you double click on that bin, all bottles are listed twice.

Hmm, that seems like a bug. Not a situation in my cellar so I will have to try and hunt it down when I have some free time.

quote:

ORIGINAL: pinskycellar
- It seems that if you don't have enough bins across a tab, you can't access the dropdown that allows you to see different views (MaxBottles, BottlesofMax, etc) on that tab.

Well that dropdown does extend across 8 columns, so I guess if your bins don't go that far across it is an issue. There is some code that prevents scrolling too far to the right of the bins once the sheet is finalized. I could eventually prevent that scrolling from being no less than 8 columns in a future version. In the meantime why not put your bins a little further to the right so that they end at the 8 or 9th column even if there is nothing to their left.

quote:

ORIGINAL: pinskycellar
- You can't match bottles based on only location with no bin specified. This would be useful for locations where I don't track bins like inside my house. As a workaround, I created a fake bin name called "Inside" for a couple of locations which lead to the discovery above.

All the code revolves around Location-Bin combinations, except when there is a bug like the one mentioned above. So you do need to have some sort of bin name.

quote:

ORIGINAL: pinskycellar
All in all though, I'm really digging the self-service aspect of this new generation of the spreadsheet. If I can get the Depth Chart working, I think I can work around the other little idiosyncrasies.

Thanks!

Glad it is pretty much working for you. Makes me happy to help people drink more wine, except that prices are getting insane.

quote:

ORIGINAL: pinskycellar
The only thing I noticed is that if I change the view to the Bottles of Max or Actual Bottles in Bin, it shows 0/2 and 0 respectively. Not sure if that count is supposed to work or not for the Depth chart or if I'm missing one more piece.

quote:

ORIGINAL: anevard

quote:

ORIGINAL: pinskycellar
The only thing I noticed is that if I change the view to the Bottles of Max or Actual Bottles in Bin, it shows 0/2 and 0 respectively. Not sure if that count is supposed to work or not for the Depth chart or if I'm missing one more piece.

Ok I found that bug. Will try and fix it soon. The issue will be migrating to the new sheet, but at least we are advancing the cause.

quote:

ORIGINAL: pinskycellar

Hi Andrew -

Found another interesting little bug. If the Start or End date for a bottle is blank, that field will show 1899 for the bottle in the bin double-click dialog.

quote:

ORIGINAL: Sean McGrath

quote:

ORIGINAL: anevard

Hey

Glad to see you are trying the new version even if it’s not working for you

Take a look at this post. I believe it is a security issue in excel and power query. This is a solution that seems to solve the problem. However I am not sure this new version will work on a Mac. Please let me know.

CellarMap Excel security issue

That worked (on a Windows PC). Thanks, Andrew.

quote:

ORIGINAL: Stefan

Yes!
That works. I also found a work around in the other sheet you sent. The query "GetWeb = Web.Page(Web.Contents(Source))" did not work with the url as input Source. But when I just pasted the webquery-url in quotation marks, it worked.

Anyhow, now that my table is populated I can look further and see if all works as expected. Great!

quote:

ORIGINAL: wine247365

quote:

ORIGINAL: Sean McGrath

quote:

ORIGINAL: anevard

Hey

Glad to see you are trying the new version even if it’s not working for you

Take a look at this post. I believe it is a security issue in excel and power query. This is a solution that seems to solve the problem. However I am not sure this new version will work on a Mac. Please let me know.

CellarMap Excel security issue

That worked (on a Windows PC). Thanks, Andrew.

This fix didn't work for me, on a Windows PC too w/O365 but am saving files only to my PC. My inventory populates in the web browser, but not in Excel. Will PM jmc167 to see if he might have time to assist. I was also on the early download list!

quote:

ORIGINAL: wine247365
To close the loop on my login fails, it ended up being as simple as removing the special character from my Cellar tracker password. Unfortunately, jmc167 had to give up about 90 minutes this morning troubleshooting with me, with some diversions for wine talk along the way. Many thanks to you John and I sincerely appreciate your help with solving my data import challenge.

I searched this thread for any key words involving special or characters and couldn't find anything, so for anyone reading this in the future, I'm going to write this next sentence in ALL CAPS so that it pops out a little from the 6 pages of back-n-forth. Apologies to those with sensitive hearing in advance!

YOUR CELLARTACKER PASSWORD CANNOT HAVE A SPECIAL CHARACTER AS IT WILL MAKE THE DATA IMPORT OF YOUR BOTTLES FAIL DURING THE LOGIN PROCESS OF THE EXCEL FILE.

quote:

ORIGINAL: jmc167


1) So earlier this evening, per the screenshot below, I could not move my cursor past column R, so was unable to select any cells beyond column R and view the bottles in that bin, or do any formatting. I then moved the Bins to left (starting in column A) and then the cursor would not move past column O, so it seemed the cursor could never get to the last three columns in the sheet. After moving the Bins from Rows X through AJ to column A start at Row 30, now I can navigate to all cells, so perhaps I just needed to run the refresh bins a few times.

quote:

ORIGINAL: wine247365
I've moved onto the mapping part of my cellar and have a similar issue to what you called out above. I can't move my display to the right beyond column X nor down below row 25. As you noted at the end above, I have refreshed my bins a few times but it hasn't changed my restricted displays. Would you have any other suggestions?