Microvellum Knowledge Network

Formulating Drawer Sub-Front drop based on stock heights and lock locations?

I have been asked if it’s possible to formulate the Drawer Sub-Front drop based on stock drawer heights we use and stock as well as adjustments to make sure we clear the locks and drawer pulls.



Mostly we are using stock sizes. (3, 4, 6, 8, 10)  The others in our list are custom sizes we make and use as stock when needed. 











Setting the stock drop height to 2” works for the most part but not for the odd 9.625 box size and then the smaller 4” and under as well. I wrote a quick little formula to try and drop it to the next stock size but I think there has to be a better way. 


One of the things I have run into is that the Lock vertical location is in the Front Sub-Assembly and thus not readily available to transfer and use in the DrawerBox Sub-Assembly for all the math.  I considered moving the information up to the cabinet level but then it creates problems based on drawer location and where the info is getting pulled from.  

               


Formula:  =IF(VLOOKUP(Bay_Position,G!LookUpTableBayDrawerBox,6,TRUE)=1,IF(S!Height=9.625,1.625,IF(Height>=6,2,IF(Height>=4,1,G!Lock_Drop_Front_Distance))),0)


 



 


 



A few things I have noted and ran into that should be considered:




  1. On taller drawers there are times where they are locked but the drawer front is tall enough to not need the Drawer Sub-Front drop. 


  1. There are times that dropping the Sub-Front creates issues with the screws for attaching the pulls.


  1. It would be nice at certain times for the sub front the drop a custom distance to make sure it clears the lock hole and body while leaving as much material as possible for the building and connecting to the drawer front.  We would want to have sub front sized so it could have at least 2 dowels in each side for assembly. 



    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review