Product design sheets are PDF files for NCAA licensed products. They include Picnic Time's contact information, the licensed team name, product information, the team's logo, a studio shot of the product and team color information. Below are steps for creating the NCAA design sheets.

1. Obtain a list of product SKUs that require design sheets from Picnic Time's licensing department.
2. Open the design sheet spreadsheet:
   • \\PTFILES\SharedGraphics\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheets-DataMerge-PC.xlsx
3. Paste the list of SKUs into the PSD List column of the PASTE PSD LIST worksheet.
4. Save the CSV worksheet as a CSV file.
5. Merge the CSV file into the design sheet template using InDesign:
   • \\PTFILES\SharedGraphics\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheet-TEMPLATE-DataMerge-MAC.indd
   • \\PTFILES\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheet-TEMPLATE-DataMerge-PC.indd
   • The templates include A and B masters. The B master layout is used for the following products:
     • 686 Mega Can Cooler
     • 690 - Can Cooler
     • 691 - Mini Can Cooler
     • 811 - Picnic Table
     • 910 - Icon
     • 919 - Concerto
6. Export PDF at 200ppi.
7. Acrobat can be used to extract individual pages from PDFs.
8. Hazel can be used to rename individual page files by SKU (currently, PDFs in \\PTFILES\ActiveProjects\Entities\0-Schools\TEMP_SAVES\2-Submissions\1-PENDING will be automatically renamed).