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