Re: D Coates Nuc Cutting Guide Spreadsheet
Originally Posted by Spinner
Thanks for the compliment and for taking the time to give the spreadsheet a go.
The 4.9mm cell size can be changed by the user. I didn't run different cell sizes to calculate honey weight. I suspect it won't make much difference on honey weight, just on the total number of cells on the frames. I thought some beeks might use that feature to estimate brood etc.
Your suggestion for locking cells is a really good one. I have inadvertently overwritten formulas too. It might be a good idea for those wanting to play with the spreadsheet to load two copies with a slightly different name so if that happens and the error can't UNDOed (lol) and revert the sheet to the original condition he could just open the extra saved original version. But then, everyone isn't as anal retentive as me. I have to admit I haven't learned how to lock just a few cells. I once, several months ago, read on a forum how to lock only certain chosen cells. If I understood it right, the writer had to juggle lock and unlock at appropriate times. I'm not much on mental gymnastics (or physical ones either.) Please advise, or any user has my permission to make that change before its finally released. Teamwork is a good thing.
Yes, yellow is sometimes hard to read. It showed up OK on my screen, but I'm open to suggestions as to a different color for the final version. (If you don't mind send me your version. It might be arranged in a much more logical way that everyone would like better than mine.) If a user is even a little familiar with writing a spreadsheet that's a simple enough change the user could make manually. I haven't a clue whether locking the calculating cells changes the other formatting such as color, sheet cell size and font size?
And finally, - 3/4" lumber. Hummnnnnn, I didn't think to make any allowance for rabbett joints, box joints etc. What an oversight - - If it works for all that as it is written its a completely unexpected blessing from Above. If it turns out modifications are needed to correct domensions for user defined joints that could be modified by putting a calculation in some of the cells containing no calculations. The user would then have to be sure to make that input while entering other variables. I modified the "form" of the sheet so it was as compact "on the screen" as possible. But that form doesn't have to be maintained.
I have no intentions to offer it for sale, so every user is free to modify it to his own satisfaction. If other forums or someone else wants to include it on their web site I only ask they give credit to Beesource or include a link to the Beesource forum page where the sheet resides.
Thanks again for your time, help and suggestions,
Last edited by beesintrees; 11-19-2013 at 07:50 PM.
Let's turn it around
America Bless God