This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
start:creativeprocedures [2018/01/18 09:23] andre [Visual Matrix PDFs] |
start:creativeprocedures [2018/01/19 15:29] (current) andre [Visual Matrix PDFs] |
||
---|---|---|---|
Line 95: | Line 95: | ||
- Open the visual matrix spreadsheet:\\ [[\\PTFILES\SharedGraphics\___DAM\Licensing_Assets\VisualMatrix-MASTER.xlsx]] | - Open the visual matrix spreadsheet:\\ [[\\PTFILES\SharedGraphics\___DAM\Licensing_Assets\VisualMatrix-MASTER.xlsx]] | ||
- Update the lists of products in one of the ''PRODUCTS'' worksheet tabs (do not paste values over the formulas in column ''A''). | - Update the lists of products in one of the ''PRODUCTS'' worksheet tabs (do not paste values over the formulas in column ''A''). | ||
- | - Use the ''ENTER INFO'' sheet to generate a CSV file for one team from one of the ''CSV'' sheets, or one of the ''PC CSV'' sheets to generate a CSV file for all teams in an entity. | + | - Use the ''ENTER INFO'' sheet to generate a CSV file for one team from the ''MAC CSV'' sheet or the ''PC CSV'' sheet. The entity ''PC CSV'' sheets can be used to generate a CSV file for all teams in an entity. |
- <BOOKMARK:step5>Save the ''CSV'' worksheet as a CSV file and close the CSV file in Excel. | - <BOOKMARK:step5>Save the ''CSV'' worksheet as a CSV file and close the CSV file in Excel. | ||
- Open the visual matrix template in InDesign:\\ \\PTFILES\___DAM\Licensing_Assets\VisualMatrix-MASTER.indd | - Open the visual matrix template in InDesign:\\ \\PTFILES\___DAM\Licensing_Assets\VisualMatrix-MASTER.indd |