Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can Excel accurately calculate the maximum quantity of cut outs from a single
piece of card or metal? This is typically an element of CAD/CAM software. I don't want or need a CAD/CAM system, I do need to prevent wastage and limit offcuts. I know the non-variable - the size of the card to be cut up. 1110 by 810 mm. I know the variables - the size of the rectangles to be produced. These sizes are client driven. But exactly how many rectangles can I extract from one card. I only require rectangle shapes. If my variables are, for example, 320 x 320 then the number of rectangles I can produce is 6. But what is the ideal formula to calcuate any rectangle shape sized up to 555 x 405? Any size greater than this requires 1 x card per rectangle. I am not able to mix different sizes of rectables on one card. Appreciate any help on this conundrum. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Charts and Call Outs | Excel Discussion (Misc queries) | |||
Calculating Inventory Outs | New Users to Excel | |||
Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick, tota | Excel Worksheet Functions | |||
Pie Chart Sectional Pull-outs | Charts and Charting in Excel | |||
Print outs from Excel has symbols instead of words | Excel Discussion (Misc queries) |