pinskycellar
Posts: 6
Joined: 2/26/2019 Status: offline
|
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. Ok, adding the Depth row entry was the missing piece for me. Once I added those, the Depth chart began showing up and matches the Front/Back for where bins are full/empty/partial. 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: 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. No worries, I've worked around the issue by add a unique bin name for each of my different locations. Not as "wife friendly" as I would like, but it works for now. 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. Yeah, I'll do that for now. 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. Ok, I've got the made up bin names to deal with it. 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. Thanks for providing this new version. It just confirms what the visual of my wine cellar tells me...I have too much wine and no room left to add any more!
|