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!

...(A) with values from 0 to 17 (representing the possible amount of small boards in a pattern. Round down to integer 3) Make a column B equal to A * lengths of small board. That will show how much of the pattern is used up by small boards 4) Make a column C which divides the (stock minus B) by...

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...

...box essentially contains 4 components. 2 sides, 2 lengths, 1 base and 1 lid. (The base and lid can be different dimensions) What I manually do is: * calculate the width of each component. (I need to allow for saw blade thickness etc.) * I know the dimensions of the board that will be used to...

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

...left over. The other lengths that need to cut are 142mm & 100mm I need to figure out how to cut the 430mm piece to minimise waste. I could cut: * 4 pieces of 100mm and have 30mm waste * 2 pieces of 142mm and 1 piece of 100mm and have 16mm waste * 3 pieces of 142mm and have 4mm waste...

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...

...records, I have a cmd button on the form. When clicked it opens a pop up form allowing the user to select the record of choice. I store the record id as a variable, close the pop up form and filter the recordset of the form e.g select * from tblInvoice where InvoiceId = tmpInvoiceId works...

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!