Thread
:
excel formula to create a cutting list help needed please
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
excel formula to create a cutting list help needed please
I thought I said, Ask OFF list ONLY!!!!
Besides I can't send to
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"davers" wrote in message
...
Thanks a lot a a workbook would be great.
cheers
"Don Guillett" wrote:
Not as simple as it sounds. Set up a table of lengths, inventory,
formula,
and desire such as
Formula for col c copied down =MIN(B5,INT((D4/A5)))
formula for col d copied down
=D4-(A5*C5)
I can send you a workbook, if desired. Ask OFF list ONLY!!!!
Length Inv Use 5,000.00 5,000.00
2,000.00 10 2 1,000.00
4,000.00
1,800.00 10 -
-
1,600.00 0 -
-
1,400.00 10 -
-
1,200.00 0 -
-
1,000.00 0 -
-
800.00 0 -
-
600.00 10 1 400.00
600.00
400.00 2 1 -
400.00
200.00
- - -
100.00
- - -
1.00
- - -
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"davers" wrote in message
...
I dont know if this is the right place to ask this question but i am
looking
for a simple excel formula to create a cutting list.
ie
1200
1400
1800
2000
600
The above lengths needs to be cut from 4000
so 1200 + 1800 = 4000 and 1200+2000+600 =3200
so i require 2 lengths at 4000, surely its a simple excel formula, any
help
would be much appreciated.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett