You already know how to make the work. This workbook is for the other half of a handmade business — knowing how much yarn a project needs, getting gauge so it fits, keeping your stash from becoming a mystery, and the one that changes everything: knowing what a finished piece really costs you, so you can price it for a profit instead of a loss. It turns the guessing into a calm, repeatable system without getting in the way of the part you love.
One workbook, the whole business side of the studio. Buy the right amount of yarn with a quantity calculator, get gauge with a sizing calculator, shop your stash first with an inventory that protects your dye lots, and finally price your work for a profit — with your hours counted, the step most sellers skip.
What’s inside:
- ✦ A yarn quantity calculator (Excel) — type a project’s yardage and the yards per skein; it works out the skeins to buy, rounded up with a safety skein for the dye lot. Plus a grams↔yards converter for substituting and weighing leftovers
- ✦ A yarn-weight reference — every weight from lace (0) to jumbo (7), with its knit and crochet gauge, the usual needle and hook sizes, and a rough yards-per-100g
- ✦ A gauge & sizing calculator (Excel) — enter your gauge and the size you want; it gives the cast-on stitches and rows, with ease built in, and checks a pattern’s gauge against yours
- ✦ A yarn stash inventory (Excel) — track your yarn by weight, fibre, colourway and dye lot; it totals your yardage and flags the staples when they run low
- ✦ A project & per-piece cost & pricing calculator (Excel) — yarn + notions + your honest hours + overhead → your true cost, then a price the market can bear (because keystone doubling doesn’t work when labour is the cost)
- ✦ A care, blocking & fixes reference — how to care for each fibre, the three blocking methods, and fixes for running short, gauge, curling edges, pooling, and pilling
- ✦ A Start Here guide + printable logs — yarn amounts, gauge, fibre care, costing, pricing, and print-and-use project / gauge-swatch / stash sheets
The working part really works: the Excel workbook has eight tabs and four live calculators — type your numbers and the skeins, the cast-on, and the prices compute for you.
Evergreen — use it any year: yarn weights, gauge math, fibre care, and the pricing method are timeless, and the logs use a date column you fill in yourself.
Instant digital download. Nothing ships. The files are yours to use in your own making.
Created with AI assistance under Ardent Workshop’s creative direction, then reviewed and edited before release. This is a maker’s reference, not certification or financial advice: gauge, yardage, needle sizes, and yarn weights are typical starting points — always swatch and follow your yarn’s ball band, because the real gauge and yardage depend on the exact yarn and the way you work it. The costing and pricing examples are illustrative, not financial or tax advice. Not affiliated with or endorsed by any yarn manufacturer, pattern designer, or marketplace.
