Chisato chichacha
Pathoschild
/ google-sheets-color-preview.js
Last active
August 1, 2024 21:43
A Google Sheets script which adds color preview to cells. When you edit a cell containing a valid CSS hexadecimal color code (like #000 or #000000), the background color is changed to that color and the font color is changed to the inverse color for readability.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| This script is meant to be used with a Google Sheets spreadsheet. When you edit a cell containing a | |
| valid CSS hexadecimal color code (like #000 or #000000), the background color will change to that | |
| color and the font color will be changed to the inverse color for readability. | |
| To use this script in a Google Sheets spreadsheet: | |
| 1. go to Tools » Script Editor; | |
| 2. replace everyting in the text editor with this code; | |
| 3. click File » Save; |
clarkenheim
/ Zip Codes to DMAs
Last active
November 13, 2024 03:00
TSV file containing zip codes and the DMA they fall in to. Method: calculate the centre point of every zip code geo boundary, plot those points on a DMA boundary map, find the containing DMA of each zip centroid
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| zip_code dma_code dma_description | |
| 01001 543 SPRINGFIELD - HOLYOKE | |
| 01002 543 SPRINGFIELD - HOLYOKE | |
| 01003 543 SPRINGFIELD - HOLYOKE | |
| 01004 543 SPRINGFIELD - HOLYOKE | |
| 01005 506 BOSTON (MANCHESTER) | |
| 01007 543 SPRINGFIELD - HOLYOKE | |
| 01008 543 SPRINGFIELD - HOLYOKE | |
| 01009 543 SPRINGFIELD - HOLYOKE | |
| 01010 543 SPRINGFIELD - HOLYOKE |