DMC Thread Google Sheet

A Google Sheet to keep inventory of DMC threads. It will automatically colour cells and add the colour name for any valid DMC code.

♥️ cross stitch by lastspark from the Noun Project

What is DMC

It's a thread company that has its own color coding schema. Their threads are commonly used for cross-stiching: https://www.dmc.com/us/thread-5000/

How to use

1. Create a copy of the base Google Sheet: File -> Make a copy.
   The default layout has a column per colour group, but you can aggregate all colours in a single column if you want.
2. Add a valid DMC code in any of the Number columns. If you added it to the cell A3, then A3 will be coloured with the appropriate colour and B3 will be filled up with the DMC name.

How to modify the code

Click on Tools -> Script Editor to open the code. From here you can modify:

• the name of the sheets that contain the colours and the sheet that contains the codes
• the columns that will be considered to be colored over
• the columns that define the DMC code, name and HEX codes. By default, these codes live in the colour_codes sheet, feel free to modify it as needed.

♥️ Shoutout to @adrianj, as I took the DMC-to-HEX mapping from his CrossStitchCreator project.