I need to create a list of products that can be customized on their dimensions. Using their dimensions, I want to create a output table to work out their material and cutting list. So I need a table of products with certain formula in them to determine what to use to work out the outputs.
CUTTING LIST | CABINET HEIGHT | CABINET WIDTH | CABINET DETPH | OUTPUT | PART HEIGHT | PART WIDTH | |||
1 DOOR | 800 | 750 | 585 | 1 DOOR | this should equal 800 (B2) | this should be =750 (C2)-3 | |||
2 DOOR | 800 | 900 | 585 | 2 DOOR | this should equal 800 (B3) | this should be = 800 (C3) /2-3 | |||
3 DRAWER | 800 | 600 | 585 | 3 DRAWER | this should equal 800 (B4)/3-3= 263.333 | this should be =750 (C4)-3 | |||
0 | |||||||||
0 | |||||||||
PART | |||||||||
CABINET | HEIGHT | WIDTH | |||||||
1 DOOR | THIS FORMULA SHOULD BE THE HEIGHT OF THE CABINET | THIS FORMULA SHOULD BE THE WIDTH OF THE CABINET MINUS 3 | |||||||
2 DOOR | THIS FORMULA SHOULD BE THE HEIGHT OF THE CABINET | THIS FORMULA SHOULD BE THE WIDTH OF THE CABINET DIVIDE BY 2 THEN MINUS 3 | |||||||
3 DRAWER | THIS FORMULA SHOULD BE THE HEIGHT DIVIDED BY 3 THEN MINUS 3 | THIS FORMULA SHOULD BE THE WIDTH OF THE CABINET MINUS 3 |