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