Color Fiesta section, I noticed a tweet about something called the Pantone Spring 2013 color collection. I had no idea how pantone worked, so I went off to find out if it was a coding system that could be calculated - turns out it cant, but rather it's a look out. Since I was making a color table anyway, it seemed like a good set of test data. Turned out that the the mapping is pretty elusive - but I tracked down a large chunk from various scrapings. You can find out more about this at Looking up color table
When I was writing the Alternative ramp layout, Alternative schemes and Ramping color swatches are examples of ramping between members of a color scheme. Here let's look at a small application that brings together all the components covered so far in Color Fiesta
The target applicationTaking a sheet that has all the known data about the Pantone fashion and home color collections over the years - here's a snippet
Create a sheet that presents a swatch for each years Pantone colors, a ramp of those colors showing the transition between them, and a summary swatch of each of the colors of the year. The actual colors will be looked up name as described in Looking up color table.
The resultHere' what we end up with
The codeMost of what we'll use here is a mash up of code written for other sections in Color Fiesta and available the libraries in the cDataSet.xlsm workbook.
For help and more information join our forum,follow the blog or follow me on twitter.
|
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Color Fiesta >