AMarshall Posted September 10, 2010 Report Share Posted September 10, 2010 I originally posted this on the old Guild Forum, and finally realized that it hadn't made the move. This excel tool will help you to resize your Chest of Drawers if you want to deviate from the published plans. Link: http://thewoodwhisperer.com/files/chest-u-lator-v2.xls Options include: - Equal height drawers, or drawer heights based on a standard increment like Marc used. Manual input also available. - Overall case dimensions can be changed - Up to 10 levels of drawers can be used, and the top 5 levels can be split into 2 drawers like Marc did. Technical note: This spreadsheet uses a macro to redraw the simple diagram included. Excel macros are not supported by Google Docs, or by MS Office on the Mac. You can still use the spreadsheet to calculate part sizes, you just won't be able to redraw unless you have Excel. Also, you must enable the macro. I wrote it myself and personally guarantee that it is harmless. The current dimensions in the file match the recent Guild Build Chest of Drawers. The attached images show a few samples of what can be done using the tool. Be sure to check out the instructions on the first tab, and let me know if you have a question. 1 Quote Link to comment Share on other sites More sharing options...
woodcanuck Posted September 10, 2010 Report Share Posted September 10, 2010 Aaron...you are amazing...this is awesome, just what I was looking for. Thanks Quote Link to comment Share on other sites More sharing options...
PurpLev Posted September 10, 2010 Report Share Posted September 10, 2010 Just for the name it's worth it! NICE Quote Link to comment Share on other sites More sharing options...
scfriese Posted September 16, 2012 Report Share Posted September 16, 2012 The chest-u-lator is fantastic! I do have a question on the calculation for the "too much space used" field (cell T62). I've done my math backwards and forwards for a 50" chest but it keeps telling me i need to make my drawers smaller. Are there any known bugs that would prevent the calculation from displaying accurately? Thanks! Quote Link to comment Share on other sites More sharing options...
AMarshall Posted September 17, 2012 Author Report Share Posted September 17, 2012 Are there any known bugs that would prevent the calculation from displaying accurately? Wow, blast from the past! I had to dust it off and take a look to remind myself how it works! There's not a known bug, but you may have just discovered it first. I'll PM you with an e-mail address, feel free to send me your file and I'll take a look at your particular measurements. In the meantime, that message can sometimes be ignored. Column P contains the dimensions used for the drawing, and the "final" numbers in column P pull values from Columns R, S, T - depending on which option you select in cell D16. If you aren't using the "Manual Input" method for sizing the drawers, you should ignore the "too much space used" message entirely. It's just there to help you monkey around with the number in column T, and only if you want to manually set up your drawers. Quote Link to comment Share on other sites More sharing options...
Vic Posted September 17, 2012 Report Share Posted September 17, 2012 This is beyond cool! How did I ever miss it?!? I'll be sure and pull it off the guild site. Quote Link to comment Share on other sites More sharing options...
fransikaner Posted September 17, 2012 Report Share Posted September 17, 2012 Thanks, Aaron. A great addition to the toolbox. I may even get one for my wife!!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.