How to auto calculate grade rules in your tech pack using formulas in Excel
I see many designers doing tech packs in Illustrator and – gasp – MANUALLY calculating grade rules! Please, don’t do this! Use Excel and the simple formulas to make sure your spec sheet is accurate and that everything AUTOMATICALLY updates if you make any changes!
You will learn:
00:38 Defining your sample size in your spec sheet
00:55 Using formulas in Excel to automatically calculate the increases and decreases in your graded spec
02:20 Why you want to set your tech pack up this way – it auto updates like magic!
02:53 Using formulas to calculate deviance for proto / sample comments in your tech pack (and what deviance is)
04:40 Why I choose to do my tech packs in Excel and not Illustrator
MOST PEOPLE CHARGE FOR TECH PACK TEMPLATES. MINE IS FREE. 😱
I’ve used this template to successfully take 100’s of designs from idea to production, and you can too. It’s fully customizable for any garment, in any industry 💪
Drop your info below for a free copy of my tech pack template + step by step tutorials to use it 👇
By signing up, you’ll get access to weekly emails with free tutorials, templates and occasional offers.