Worsted Weight Wool Yarn Yardage Calculator

	A	B	C	D	E	F
1	Worsted Weight Wool Yarn Calculator
2	by Kayla Pins of Pins's Needles
3	Use this calculator to determine how many yards of yarn your project took, or determine how many grams of yarn your project needs. Weighing yarn is a simpler alternative to measuring the yardage. It also allows you to use up scraps or thrifted yarn that lacks a label.
4	How to use this calculator
5	Save a copy of this spreadsheet to your Google Drive or download a copy and open it with your Excel program on your desktop.
6	Affiliate link to the scale I use, but any scale with grams will do
7	To tell how much yarn your project used				To tell how many grams of yarn your project will take
8	Weigh your finished project. Type how many grams your project weighed in the green box below. Your yardage will appear in the blue boxes.				Read your pattern instructions to deterine how many yards of yarn are required for your project. Type the number in the green box below. The grams of yarn needed will appear in the blue boxes.
9	How many grams does your finished project weigh?				How many yards do you need for your project?
10	Your project used				Your project needs
11	0.00	yards Wool of the Andes Worsted			0.00	grams Wool of the Andes Worsted
12	0.00	Cascade 220			0.00	grams Cascade 220
13	0.00	yards I Love This Wool			0.00	grams I Love This Wool
14	0.00	yards of worsted weight wool yarn, on average			0.00	grams of worsted weight wool scraps
15
16
17	Yarn Brand	Grams	Yards	Yards per gram
18	Wool of the Andes Worsted	50	110	2.20
19	Cascade 220	100	220	2.20
20	I Love This Wool Worsted	113	220	1.95
21	Scrappy stash variety			2.12
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100