anevard
Posts: 109
Joined: 6/5/2006 Status: offline
|
Hi All - 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. I have been cleaning up and adding a lot of code and some interface enhancements. It's not quite there yet but hopefully by the end of this week. I have added a chunk of code to make it more efficient to set up the individual user layouts. Maybe one day I can automate this, but that's a long way off. Also dealing with some Mac bugs (seems Excel 2016 is a bit less stable on Macs), which is hard since I am on a PC. I think I quashed them, so far. A few big additions: Location. Now each Bin Sheet can be a unique location. Bins can have the same name in different locations, which was not accounted for in the earlier versions. This was a lot harder than I thought, but I believe I have worked it out. I am still trying to optimize the unGraphedBins code as it runs a bit slower with the additional loops to check for Location. Also, some people use the Location field rather than the Bin field for their storage cataloguing. I have tried to keep the formulas and code as open ended as I can, but I am not yet sure I have figured out how to handle this yet. I will eventually. Drink Dates. You can now visually display if a bottle is in the drinking window, ie. past the start drink date Or if a bottle is overdue to be drunk, ie. past the end drink date. This is fun, but boy was it tough to come up with formulas that didn't take 5 minutes to calculate. For those that really know Excel, UDFs were not the way to go! See the new feature pics below. The 9999 and 0 are from the CT database drinking window fields. Not sure how to clean this up, but it will probably have to be done by each user on their individual wine drinking windows in CT. For multiple bottle bins, I am using the average of all the bottles. Coming up with a way to use the earliest or latest date, just slowed things down to a crawl. If you are interested in enhancing your CT experience with my spreadsheet (name suggestions?), just drop me a PM. A bit busier now with work as well as the upgrade, but I'll get to everyone as soon as I can.
_____________________________
Andrew
|