====== Product Design Sheets ======
Product design sheets are PDF files for [[http://www.ncaa.com/|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 [[http://www.ncaa.com/|NCAA]] design sheets.
  - Obtain a list of product SKUs that require design sheets from Picnic Time's licensing department.
  - Open the design sheet spreadsheet:
     * [[\\PTFILES\SharedGraphics\___DAM\Licensing_Assets\0-Collegiate\Design_Sheets\DesignSheets-DataMerge-PC.xlsx]]
  - Paste the list of SKUs into the ''PSD List'' column of the ''PASTE PSD LIST'' worksheet.
  - <BOOKMARK:step4>Save the ''CSV'' worksheet as a CSV file.
  - 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]]
  - Select the CSV file (from [[start:ds#step4|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
  - Export PDF at 200ppi.
  - [[https://acrobat.adobe.com|Acrobat]] can be used to extract pages as seperate files from PDFs.
  - [[https://www.noodlesoft.com/|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).