anevard
Posts: 109
Joined: 6/5/2006 Status: offline
|
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. quote:
ORIGINAL: pinskycellar Hi Andrew - So, I've got the Front and Back bin maps built for my cellar and they seem to be populating correctly. What I can't get working is the Depth Chart map. Maybe I don't understand what is required to make that work. Even if I put values in the DepthCell column, nothing is ever shown in that cell. For example, for bins A1-F and A1-B, I put B55 for the DepthCell for both but nothing is displayed in cell B55. 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.
_____________________________
Andrew
|