Search results for query: *

Hi MajP Thank you very much. I have one last question (I hope) Your model allows a single stock length and two cut sizes. In real life I would have a single stock length with multiple cut sizes! I had a scenario today where I had one stock length and four cut sizes. Can you model be adapted...

Hi MajP My sincere apologies! As mentioned in a previous thread, I have been away. I returned this morning, but yes I am still monitoring this thread and would love to see your solution

I will look at this. I am away for the next three days, so my response will be delayed - but I will respond!

OK Thanks I will wait for you!

found this: www.dailydoseofexcel.com/archives/2005/09/12/cutting-stock-lengths/

I can only say two things: 1. Brilliant 2. Thank you so much I really appreciate your assistance Bravo Now to figure out how to automate solver!

Many thanks So now it makes sense and confirms that Excel can solve this using the solver. The question is now how much do you want to automate it? You could write the vba in either Access or Excel to set up the model or you can do it manually in Excel. Neither would be overly complicated, but...

Many thanks My sincere apologies! I got the column headings "Boards Required" & "Strips Required" mixed up Attached is the corrected file http://www.mediafire.com/file/7gull4z4u7uszau/Cutting%20Examples.xlsx

Many thanks http://www.astrokettle.com/pr1dsc.html They want to charge $1200! This is what they quoted me, and it is simply too expensive. I don't mind contributing, but this is too expensive I see my solution as a 1d. In order to visualize how you do this I will asks questions on the first...

Many thanks Answers at end of each question 1) are all the strips the same length? In other words are they ripping it from a stock of a specified length (i.e. 4x8)and you get the full length? If so what is that length? Or can you choose the length? Yes the are the same length. I will need to...

I manufacture wooden box’s and need to create a production order for the factory. The production order needs to include a cutting schedule so that the wood is cut to maximise usage (minimise waste) A box essentially contains 4 components. 2 sides, 2 lengths, 1 base and 1 lid. (The base and lid...

Hi MajP You have hit the nail on the head! Many thanks. The wiki article explains what I want Now I need to find an Access module that does just this! Any ideas where I can find one. I am also happy to contribute towards it

Hi MajP You are 100% correct. I need a fitting optimization model as you described! Here is a real example: The string is 2440mm in length It first needs to cut it into lengths of 442mm This will give 5 lengths of 442mm, with 430mm left over. The other lengths that need to cut are 142mm &...

I have a piece of string which I need to cut into lengths. I need to determine the the number of cuts per lenght to minimise waste Say the length of the string is 100mm Example 1 I need lengths of 40mm, 20mm I would cut 2 of 40mm & 1 of 20mm Example 2 I need lengths of 30mm I would cut 3 of...

I have found the reasons for forms being very slow to load. They include: 1. Having active filters on the form 2. Having combo boxes which allow users to navigate / select records If I remove these I don't experience and speed issues. To allow users to navigate / select records, I have a cmd...

I have just changed the design of the subform and based it on a query, rather than a table. In the query I do the row calculation "TotalValue", and in the form footer I now have a Sum(TotalValue) This appears to work. Many thanks for the response

Thanks Aceman, but this does not work

On a subform I have an unbound field, called TotalValue, =[Quantity] * [Price] In the footer of the subform I have another unbound field, called SumTotalValue, = Sum([Quantity] * [Price]) If I change records on the main form the unbound field called SumTotalValue sometimes flashes "#Error" This...

How can I set the size of a "Pop up" form using vba? When it opens, not all the fields are visible and I need to manualy increase the size of the form.\ Thanks in advance Tim

If I open the query in design view, and then open it in Datasheet View, it opens correctly!