Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet metal estimating problem
I am wanting to put together an equation that will do the following. I
buy sheet metal to be stamped into various parts and the sheets come in 3 widths, 30", 36" and 48". They also come in different lengths of 96" and 120". When estimating the cost of a part I need to determine the best sheet size to use. By reading the blueprint I can firgure the length and width of one piece. then I need to divided the width and length of the available sheet sizes to determine which one will give me the least amount of scrap. For example: the part is 3.5" wide X 5" long. The width will determine the best sheet width and the length, the best sheet length. I'll divide 30" by 3.5 = 8.57. I will always round down as a portion of a part doesn't work. Then I try 36" = 10.29 and finally 48" = 13.71. Based on the amount to the right of the decimal, 36" is best as the scrap is only .29. Next I do the same thing with the length: 96 / 5 = 19.2 and 120/5 = 24. The most optimum sheet for me to use for this part is 36" X 120". I want to be able to list the sheet sizes available to purchase as not all thicknesses of metal come in the various widths and lengths. Once I determine the best sheet size, I want to take the two results and multiply them together to learn how many pieces one sheet can make. In this example it would be 10 X 24 or 240 pieces. Is someone able to help me with this? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting metal values using data validation | Excel Discussion (Misc queries) | |||
Looking for Construction estimating spreadsheet | Excel Discussion (Misc queries) | |||
Estimating costs | Excel Worksheet Functions | |||
Estimating figures | Excel Worksheet Functions | |||
estimating | Excel Discussion (Misc queries) |