Product Design Sheets

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. Open the design sheet template in InDesign:
   • Apple macOS \\PTFILES\SharedGraphics\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheet-TEMPLATE-DataMerge-MAC.indd
   • Microsoft Windows \\PTFILES\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheet-TEMPLATE-DataMerge-PC.indd
6. Select the CSV file (from step 4) as the Data Source and use Data Merge to create a Merged Document. 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
7. Export PDF at 200ppi.
8. Acrobat can be used to extract pages as seperate files from PDFs.
9. 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).