Solved Formula to calculate the length of material required

March 2, 2013 at 15:48:59
Specs: Windows XP
need 4 sashes
length of material is 300 cm
width of material is 150 cm
width of sash is 50 cm
3 sashes per length of material
I need to have 600 cm of material
2 sashes left over

See More: Formula to calculate the length of material required

Report •


✔ Best Answer
March 4, 2013 at 10:46:12
You might want to consider using this formula, which answers your original question:

"therefore I need a formula to give me the required 6 metres"

=ROUNDUP(A1/3,0)*3

Enter the number of sashes required in A1.

Some examples of the results

Sashes   Metres
   1       3   1/3 = .333, ROUNDUP(.333,0) = 1, 1x3 = 3
   2       3   2/3 = .666, ROUNDUP(.666,0) = 1, 1x3 = 3
   3       3  
   4       6   4/3 = 1.333, ROUNDUP(1.333,0) = 2, 2x3 = 6
   5       6
   6       6
   7       9
   8       9
   9       9

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.



#1
March 2, 2013 at 16:32:47
Sounds like homework...

Aside from that, I don't know what you are asking for. It seems like you have it all figured out.

Three 300 x 50 sashes from one piece.
One 300 x 50 sash from a second piece.
One 300 x 100 "scrap" left over.

Make 2 more sashes. Keep them as spares or give them to a charity.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 3, 2013 at 03:08:37
Hi DerbyDad03 - yes that is correct, however when I use goal seek to find the length (in metres) of fabric required for 4 sashes it give me 4 metres instead of the required 6 metres, therefore I need a formula to give me the required 6 metres; ie 6 metres, cut into 2 lengths of 3 metres to produce the 4 sashes (2 left over for another day) - hope this makes sense, thanks.

Report •

#3
March 3, 2013 at 14:14:11
Since this sounds very much like a homework problem, which we do not like to answer directly in this forum, I'll offer a suggestion and let you see if you can figure out the final answer.

That is the standard approach for homework problems. We'll point you in the right direction and hope that you can follow the path to knowledge.

Please let us know if you figure it out, or if you need more help.

Take a look at the ROUNDUP function. By using the correct value for the num_digits argument, you should be able to use the number of sashes that you can get from 1 piece, along with the number of sashes you want, to determine how many 300 cm lengths of fabric you need.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
March 4, 2013 at 09:21:13
Hi DerbyDad03

I don't know where "homework" came from but it takes me back, almost 50 years!

Just to let you know that I have solved this a different way, by producing a table that has column headings from 3 to 96 lengths and beneath those the number of sashes available to that length, ie a 3 metre length produces 1, 2 and 3 sashes and a 9 metre length produces up to 9 sashes, then I just lookup the required amount and the column heading will tell me the length of material needed :) Long winded I know, but it gives me the answers.

Thanks & Regards, appreciate you taking the time...


Report •

#5
March 4, 2013 at 10:46:12
✔ Best Answer
You might want to consider using this formula, which answers your original question:

"therefore I need a formula to give me the required 6 metres"

=ROUNDUP(A1/3,0)*3

Enter the number of sashes required in A1.

Some examples of the results

Sashes   Metres
   1       3   1/3 = .333, ROUNDUP(.333,0) = 1, 1x3 = 3
   2       3   2/3 = .666, ROUNDUP(.666,0) = 1, 1x3 = 3
   3       3  
   4       6   4/3 = 1.333, ROUNDUP(1.333,0) = 2, 2x3 = 6
   5       6
   6       6
   7       9
   8       9
   9       9

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
March 4, 2013 at 11:43:17
Excellent DerbyDad03

I have used your formula to incorporate a change in the length of sash, the width of material and width of sash as shown below...

G H I
7 Length Sash 300 cm
8 Width Material 150 cm
9 Width Sash 50 cm
10 Number per Sash 3

12 Sashes Required 6

14 Length Material 6 m

=ROUNDUP(H12/(H8/H9),0)*H7/100

Hope it makes sense, and I appreciate you input, perfect!

Regards


Report •

#7
March 4, 2013 at 12:12:51
I'm glad I was able to help.

In the future, should you need to post example data, please click on the following line and read the instructions found via that link. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question