LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to use Excel to determine cutting and reusing stock to fill or

Hello,
we have a customer that requires we cut stock to different lengths. I've
seen the cutting stock programs, but they don't address my needs. After
determining the number of cuts I also have to combine the remaining material
to make units.

Example:
I have a 16" piece stock, which can be cut into 4" segments.

Customer requires:
5 units that are 40" 2X16" and adding an 8" piece
3 units that are 36" 2X16" and adding a 4" piece
4 units that are 32" 2X16"
1 unit 28" 1X16" and 1X12" piece
2 units 4" 2X4" pieces

I've been able to determine how many 16" pieces I need to start with, but I
run out of steam when trying to work through using the remaining pieces after
the 1st cut.
thanks
--
Joe
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Evaluate value of cell to determine fill upwards goss[_2_] Excel Discussion (Misc queries) 2 November 7th 07 12:14 PM
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel Jeroen Excel Worksheet Functions 0 February 16th 06 03:14 PM
CSP 5.6 : make your Cutting stock patterns in less than a second!!! [email protected] Excel Discussion (Misc queries) 0 February 6th 06 04:07 PM
Determine current default fill color Steve Conary Excel Programming 0 December 2nd 04 05:08 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"