AREA?

[SewStage]

Please bear with me as I explain better with pictures than words. I want to design a bag, and in doing so enter the quantities and sizes of each pattern piece that make up the bag, and from there have Excel calculate how much fabric (yardage) is truly needed; the most cost-effective solution. It seems backwards, but in the textile world 1 yard of fabric off the bolt is 40" wide (constant) x 36" long (variable; the length being what is cut to the customer's specification). If I need 2 pieces that are 6"x30" that would require a 12" length of fabric; but if I also need 1 piece that is 6"x10," all the formulas I've tried are adding that additional 6" to the total length instead of factoring in the remaining 10" of fabric from the previous 12" that it could be cut from:

That is ultimately the problem I'm trying to solve - a formula that will factor in both length and full width of fabric when calculating how much is needed.

Following the spreadsheet I use for this:

My Patterns Yardage Calculations.xlsx
	A	B	C	D	E	F	G	H	I	J
3	ITEM	QTY			DESIGNER/FABRIC LINE
4
5	CORK	1 1/4
6	Fabric 1	3/8
7	Fabric 2	3/4
8	Fabric 3	0
9
10	Fleece/Foam	5/8
11
12	SF101	2 1/8
13
14	DecorBond	0
15
16
17	CUTTING Instructions
18	For non-directional fabric
19		QTY	W		L	W	L	# strips	Desc
20	CORK	2	19	x	14 1/4	38	28 1/2	2	Bottom
21		2	27	x	3	54	6	1	Handles
25
26	Fabric 1:	2	5 1/2	x	19	11	38	1	Top
27		2	8	x	10	16	20	1	Inside zip pocket
32
33	Fabric 2:	2	19	x	18 1/4	38	36.5	1	Lining
34		2	8	x	18 1/4	16	36.5	1	Outer slip pockets
39
40	Fabric 3			x			0	1
41				x			0	1
46
47	Fleece or Foam	1	19	x	18 3/4	19	18.75	1	Top and bottom
52
53	SF101:	2	5 1/2	x	19	11	38	2	Top
54		2	8	x	10	16	20	1	Inside zip pocket
55		2	19	x	18 1/4	38	36.5	2	Lining
56		2	8	x	18 1/4	16	36.5	2	Outer slip pockets
Market Tote

Cell Formulas
Range	Formula
B5	B5	=CEILING(((SUM(C20:C21*H20:H21))/54),0.125)
B6	B6	=CEILING(((SUM(C26:C27*H26:H27))/36),0.125)
B7	B7	=CEILING(((SUM(C33:C34*H33:H34))/36),0.125)
B8	B8	=CEILING(((SUM(C40:C45*H40:H45))/36),0.125)
B10	B10	=CEILING(((SUM(C47:C47*H47:H47))/36),0.125)
B12	B12	=CEILING(((SUM(C53:C56*H53:H56))/36),0.125)
B14	B14	=CEILING(((SUM(C60:C69*H60:H60))/36),0.125)
F20:F21,F53:F56,F47,F33:F34,F26:F27	F20	=B20*C20
H20:H21	H20	=IF(G20<Ref!$B$3,1,ROUNDUP(G20/Ref!$B$3,0))
G20:G21,G53:G56,G47,G40:G41,G33:G34,G26:G27	G20	=B20*E20
H26:H27,H40:H41,H33:H34	H26	=IF(G26<Ref!$B$2,1,ROUNDUP(G26/Ref!$B$2,0))
H47	H47	=IF(G47<Ref!$B$4,1,ROUNDUP(G47/Ref!$B$4,0))
H53:H56	H53	=IF(G53<Ref!$B$5,1,ROUNDUP(G53/Ref!$B$5,0))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B20:C60,E20:E60	Cell Value	>0	text	NO

This tab is used to identify the maximum width of fabric by type:

My Patterns Yardage Calculations.xlsx
	A	B	C
1		WOF	LENGTH
2	WOF Cotton:	40	54
3	WOF Cork:	18	36
4	WOF Fleece:	45	36
5	WOF Interf:	20	36
6	WOF Decbond:	45	36
Ref

Would greatly appreciate any thoughts on this as I've been trying to learn and figure it out for a few months now. Thanks much. Ruth