{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Subtotal Formats","Lookups","Crayons","Color Families","Color Wheel"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[52,1,52,6],[53,1,53,6],[52,7,52,16],[53,7,53,16],[45,7,45,16],[47,1,47,6],[47,7,47,16],[48,7,48,16],[49,7,49,16],[50,7,50,16],[51,7,51,16],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[44,7,44,16],[43,7,43,16],[44,1,44,6],[45,1,45,6],[46,1,46,6],[46,7,46,16],[43,1,43,6]]}
["Purpose of this spreadsheet"]
["The macros and calculations included in this template are provided solely for your convenience, and Sage does not make any assurances or claims regarding their accuracy. Please be aware that Sage will not offer customer support for any problems related to macros and/or calculations used in this template."]
["The purpose of this Excel spreadsheet is to facilitate the formatting of subtotal lines and grand total lines on Tables and Pivot Tables in ICRW."]
[]
["All references to \"subtotals\" in this spreadsheet are also applicable to \"grand totals\"."]
[]
["Ordinary lines of totals, without any special formatting, look like this in ICRW (subtotals by Customer)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Other than the use of bold text, there isn't much visual differentiation between total rows and detail rows."]
[]
["This spreadsheet allows us to build custom subtotal formats using Cascading Style Sheet (CSS) code.  The "]
["spreadsheet creates the CSS code based on the selection of various options on the Subtotal Formats sheet."]
[]
["An example of a custom subtotal format is shown here, with ten custom formatting options noted:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The following formatting options are available:"]
["Callout","Feature",null,null,null,null,null,"Comment"]
[null,"Line Color (all lines)"]
[null,"Line Thickness (all lines)"]
[null,"Upper line type (Single, Double, None; Single shown above)",null,null,null,null,null,"Standard ICRW formatting (non-CSS) does not permit different line types for the upper and lower lines."]
[null,"Extra vertical space above the values (Yes,No)",null,null,null,null,null,"Not available in standard ICRW formatting (non-CSS)"]
[null,"Alternate background color (Light yellow shown above)"]
[null,"Lower line type (Single, Double, None; Double shown above)",null,null,null,null,null,"Standard ICRW formatting (non-CSS) does not permit different line types for the upper and lower lines."]
[null,"Amount of vertical space between double lines",null,null,null,null,null,"Not changeable in standard ICRW formatting (non-CSS)"]
[null,"Extra vertical null space below the bottom line (Yes, No)",null,null,null,null,null,"Not available in standard ICRW formatting (non-CSS)"]
[null,"Color of the extra vertical null space below the bottom line",null,null,null,null,null,"Not available in standard ICRW formatting (non-CSS)"]
[null,"All of these options are available for values and for labels"]
[]
["Enabling Subtotals"]
[1,"Edit the table (or pivot table) view of interest."]
[{"$f":"MAX(A$57:A57)+1","v":2},"On the Editor screen, in the Layout section at the bottom half of the screen, click the Sum icon"]
[null,"(sigma symbol) for the column on which you wish to create rows of subtotals. "]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"MAX(A$57:A66)+1","v":3},"Select After Values (or, for Pivot Tables, Before Values is also available) to turn on the subtotals for each value of the selected column."]
[]
["Formatting Subtotal Values (if desired)"]
[{"$f":"MAX(A$57:A69)+1","v":4},"In this spreadsheet, create the CSS code by making the appropriate selections in the Format Values section"]
[null,"at the top of the Subtotal Formats sheet of this spreadsheet."]
[{"$f":"MAX(A$57:A70)+1","v":5},"In the ICRW view editor, click the same Sum icon again and select Format Values."]
[{"$f":"MAX(A$57:A72)+1","v":6},"On the Edit Format dialog, click the gray arrow to expand the Custom CSS Style Options (HTML Only) section."]
[{"$f":"MAX(A$57:A73)+1","v":7},"Tick the Use Custom CSS Style checkbox."]
[{"$f":"MAX(A$57:A74)+1","v":8},{"$f":"\"From this spreadsheet, on the Subtotal Formats sheet, copy (Ctrl+C) the CSS code found in cell \"&ADDRESS(ROW(VALUES_CSS),COLUMN(VALUES_CSS),4)&\".\"","v":"From this spreadsheet, on the Subtotal Formats sheet, copy (Ctrl+C) the CSS code found in cell A22."}]
[{"$f":"MAX(A$57:A75)+1","v":9},"In ICRW, paste the copied CSS code into the Use Custom CSS Style field on the Edit Format dialog."]
[{"$f":"MAX(A$57:A76)+1","v":10},"Click OK to close the Edit Format dialog."]
[{"$f":"MAX(A$57:A77)+1","v":11},"If the subtotal labels are also to be formatted, continue with the next steps, otherwise click Done to close the view editor."]
[]
["Formatting Subtotal Labels (if desired)"]
[{"$f":"MAX(A$57:A80)+1","v":12},"In this spreadsheet, create the CSS code by making the appropriate selections in the Format Labels section"]
[null,"at the top of the Subtotal Formats sheet of this spreadsheet."]
[{"$f":"MAX(A$57:A81)+1","v":13},"In the ICRW view editor, click the same Sum icon again and select Format Labels."]
[{"$f":"MAX(A$57:A83)+1","v":14},"On the Edit Format dialog, click the gray arrow to expand the Custom CSS Style Options (HTML Only) section."]
[{"$f":"MAX(A$57:A84)+1","v":15},"Tick the Use Custom CSS Style checkbox."]
[{"$f":"MAX(A$57:A85)+1","v":16},{"$f":"\"From this spreadsheet, on the Subtotal Formats sheet, copy (Ctrl+C) the CSS code found in cell \"&ADDRESS(ROW(LABELS_CSS),COLUMN(LABELS_CSS),4)&\".\"","v":"From this spreadsheet, on the Subtotal Formats sheet, copy (Ctrl+C) the CSS code found in cell I22."}]
[{"$f":"MAX(A$57:A86)+1","v":17},"In ICRW, paste the copied CSS code into the Use Custom CSS Style field on the Edit Format dialog."]
[{"$f":"MAX(A$57:A87)+1","v":18},"Click OK to close the Edit Format dialog."]
[{"$f":"MAX(A$57:A88)+1","v":19},"Click Done to close the view editor."]
[]
["Note for Formatting Values vs. Formatting Labels"]
["The two sections of the Subtotal Formats sheet, one for formatting Values, the other for formatting Labels, are"]
["identical in every respect. They are included as different sections so that you can create one standardized set of"]
["selections for values, and another for labels, and not have to constantly recreate one or the other every time you"]
["need them."]
[]
["CSS Generator"]
["On the Subtotal Formats sheet, the sections labeled CSS Generator should not be modified without a deep understanding"]
["of the various components involved.  Modifying the CSS Generator sections incorrectly will cause those sections to"]
["produce faulty CSS code, which will be ignored by ICRW."]
[]
["Color Selectors"]
[1,"Values for the Line Color and Background Color selectors in the top section of the Subtotal Formats sheet are"]
[null,"found on the Lookups sheet, in the secton entitled Range Name: COLOR_LOOKUP."]
[2,{"$f":"+\"In that range, between rows \"&CELL(\"row\",Lookups!B4)&\" and \"&CELL(\"row\",Lookups!B17)&\", you may add or remove rows to create your preferred\"","v":"In that range, between rows 4 and 17, you may add or remove rows to create your preferred"}]
[null,"list of selectable colors."]
[3,"Sample color swatches, names, and hex color codes are found on other tabs of this spreadsheet."]
[]
["Favorites"]
["The Favorites section at the bottom of the Subtotal Formats sheet can be used to maintain a library"]
["of preferred CSS definitions of your choosing."]
[]
["Backup copy"]
["We recommend always keeping a backup copy of this spreadsheet, or at least a backup copy of your"]
["list of CSS code Favorites."]

{"sheet":"Subtotal Formats","index":1,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,0,50,1],[46,2,46,14],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1]]}
["Subtotal Rows - Format Values",null,null,null,null,null,null,null,"Subtotal Rows - Format Labels"]
[]
["Cell Characteristics","Selections","Color","Value","Defaults","Associated Text","Legend from Instructions sheet",null,"Cell Characteristics","Selections","Color","Value","Defaults","Associated Text"]
["Upper Line Type (above values)",3,null,{"$f":"IF(LEN(INDEX(LINE_TYPES,B4,1))=0,\"None\",INDEX(LINE_TYPES,B4,1))","v":"Single"},"None",null,null,null,"Upper Line Type (above values)",3,null,{"$f":"IF(LEN(INDEX(LINE_TYPES,J4,1))=0,\"None\",INDEX(LINE_TYPES,J4,1))","v":"Single"},"None"]
["Lower Line Type (below values)",4,null,{"$f":"IF(LEN(INDEX(LINE_TYPES,B5,1))=0,\"None\",INDEX(LINE_TYPES,B5,1))","v":"Double"},"None",null,null,null,"Lower Line Type (below values)",3,null,{"$f":"IF(LEN(INDEX(LINE_TYPES,J5,1))=0,\"None\",INDEX(LINE_TYPES,J5,1))","v":"Single"},"None"]
["Background Color (behind values)",4,null,{"$f":"IF(LEN(INDEX(Color_Lookup,B6,1))=0,\"#000000\",INDEX(Color_Lookup,B6,2))","v":"#FFFFBF"},"White",{"$f":"IF(LEN(INDEX(Color_Lookup,B6,1))=0,\"Black\",INDEX(Color_Lookup,B6,3))","v":"Black"},null,null,"Background Color (behind values)",5,null,{"$f":"IF(LEN(INDEX(Color_Lookup,J6,1))=0,\"#FFFFFF\",INDEX(Color_Lookup,J6,2))","v":"#26EAEA"},"White",{"$f":"IF(LEN(INDEX(Color_Lookup,J6,1))=0,\"Black\",INDEX(Color_Lookup,J6,3))","v":"Black"}]
["Extra padding space above values",2,null,{"$f":"IF(INDEX(YES_NO,B7,1)=\"No\",0,6)&\"px\"","v":"6px"},"Yes - 6px",null,null,null,"Extra padding space above values",2,null,{"$f":"IF(INDEX(YES_NO,J7,1)=\"No\",0,6)&\"px\"","v":"6px"},"Yes - 5px"]
["Null space below lower line",2,null,{"$f":"IF(INDEX(YES_NO,B8,1)=\"No\",\"0px\",\"30px\")","v":"30px"},"Yes - 30px",null,null,null,"Null space below lower line",2,null,{"$f":"IF(INDEX(YES_NO,J8,1)=\"No\",\"0px\",\"30px\")","v":"30px"},"Yes - 30px"]
["Null space color",3,null,{"$f":"IF(LEN(INDEX(Color_Lookup,B9,1))=0,\"#000000\",INDEX(Color_Lookup,B9,2))","v":"#FFFFFF"},"White",null,null,null,"Null space color",13,null,{"$f":"IF(LEN(INDEX(Color_Lookup,J9,1))=0,\"#FFFFFF\",INDEX(Color_Lookup,J9,2))","v":"#FFB7D5"},"White"]
[]
[]
["Line Characteristics","Selections","Color","Value","Defaults",null,null," ","Line Characteristics","Selections","Color","Value","Defaults",null,null," "]
["Line Color (All lines)",2,null,{"$f":"IF(LEN(INDEX(Color_Lookup,B13,1))=0,\"#000000\",INDEX(Color_Lookup,B13,2))","v":"#000000"},"Black",null,null,null,"Line Color",8,null,{"$f":"IF(LEN(INDEX(Color_Lookup,J13,1))=0,\"#000000\",INDEX(Color_Lookup,J13,2))","v":"#003AF6"},"Black"]
["Line Thickness  (All lines)",3,null,{"$f":"IF(LEN(INDEX(LINE_THICKNESS,B14,1))=0,\"1px\",INDEX(LINE_THICKNESS,B14,1))","v":"2px"},"1px",null,null,null,"Line Thickness",3,null,{"$f":"IF(LEN(INDEX(LINE_THICKNESS,J14,1))=0,\"1px\",INDEX(LINE_THICKNESS,J14,1))","v":"2px"},"1px"]
["Vertical space between double lines",4,null,{"$f":"IF(LEN(INDEX(LINE_THICKNESS,B15,1))=0,\"3px\",INDEX(LINE_THICKNESS,B15,1))","v":"3px"},"3px",null,null,null,"Vertical space between double lines",4,null,{"$f":"IF(LEN(INDEX(LINE_THICKNESS,J15,1))=0,\"3px\",INDEX(LINE_THICKNESS,J15,1))","v":"3px"},"3px"]
[]
[]
[]
[]
["CSS Output",null,null,null,null,null,null," ","CSS Output"]
["Copy/Paste this string into the Custom CSS Style field on the Edit Format dialog",null,null,null,null,null,null,null,"Copy/Paste this string into the Custom CSS Style field on the Edit Format dialog"]
[{"$f":"F38&\"background-image: linear-gradient(180deg, \"&_xlfn.CONCAT(G29:G40)","v":"background-image: linear-gradient(180deg, #000000 0px, #000000 2px, #FFFFBF 2px, #FFFFBF 2px, #000000 2px, #000000 2px, #FFFFBF 2px, #FFFFBF 51.0%, #000000 51.0%, #000000 calc(51.0% + 2px), #FFFFBF calc(51.0% + 2px), #FFFFBF calc(51.0% + 5px), #000000 calc(51.0% + 5px), #000000 calc(51.0% + 7px), #FFFFFF calc(51.0% + 7px), #FFFFFF 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "},null,null,null,null,null,null," ",{"$f":"N38&\"background-image: linear-gradient(180deg, \"&_xlfn.CONCAT(O29:O40)","v":"background-image: linear-gradient(180deg, #003AF6 0px, #003AF6 2px, #26EAEA 2px, #26EAEA 2px, #003AF6 2px, #003AF6 2px, #26EAEA 2px, #26EAEA 51.0%, #003AF6 51.0%, #003AF6 calc(51.0% + 2px), #26EAEA calc(51.0% + 2px), #26EAEA calc(51.0% + 2px), #003AF6 calc(51.0% + 2px), #003AF6 calc(51.0% + 2px), #FFB7D5 calc(51.0% + 2px), #FFB7D5 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "}]
[]
[]
[]
["CSS Generator for Values (Reference only; do not modify)",null,null,null,null,null,null,null,"CSS Generator for Labels (Reference only; do not modify)"]
[]
["Formatting Feature","Color","Hex","Height\n(px or %)","Start","Stop","CSS Component",null,"Formatting Feature","Color","Hex","Height\n(px or %)","Start","Stop","CSS Component"]
["Upper Line #1",{"$f":"_xlfn.XLOOKUP(D$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Black"},{"$f":"+D$13&\" \"","v":"#000000 "},{"$f":"VALUE(IF(D4=\"None\",0,SUBSTITUTE(D14,\"px\",\"\")))","v":2},"0px, ",{"$f":"SUM(D$29:D29)&\"px\"","v":"2px"},{"$f":"IF(B29=\"None\",\"\",C29&E29&C29&F29&\", \")","v":"#000000 0px, #000000 2px, "},null,"Upper Line #1",{"$f":"_xlfn.XLOOKUP(L$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Vivid Blue"},{"$f":"+L$13&\" \"","v":"#003AF6 "},{"$f":"VALUE(IF(L4=\"None\",0,SUBSTITUTE(L14,\"px\",\"\")))","v":2},"0px, ",{"$f":"SUM(L$29:L29)&\"px\"","v":"2px"},{"$f":"IF(J29=\"None\",\"\",K29&M29&K29&N29&\", \")","v":"#003AF6 0px, #003AF6 2px, "}]
["Space between double upper lines",{"$f":"_xlfn.XLOOKUP(D$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Light Yellow"},{"$f":"+D$6&\" \"","v":"#FFFFBF "},{"$f":"VALUE(IF(D4<>\"Double\",0,SUBSTITUTE(D15,\"px\",\"\")))","v":0},{"$f":"+F29&\", \"","v":"2px, "},{"$f":"SUM(D$29:D30)&\"px\"","v":"2px"},{"$f":"IF(B30=\"None\",\"\",C30&E30&C30&F30&\", \")","v":"#FFFFBF 2px, #FFFFBF 2px, "},null,"Space between double upper lines",{"$f":"_xlfn.XLOOKUP(L$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Bright Turq"},{"$f":"+L$6&\" \"","v":"#26EAEA "},{"$f":"VALUE(IF(L4<>\"Double\",0,SUBSTITUTE(L15,\"px\",\"\")))","v":0},{"$f":"+N29&\", \"","v":"2px, "},{"$f":"SUM(L$29:L30)&\"px\"","v":"2px"},{"$f":"IF(J30=\"None\",\"\",K30&M30&K30&N30&\", \")","v":"#26EAEA 2px, #26EAEA 2px, "}]
["Upper Line #2",{"$f":"_xlfn.XLOOKUP(D$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Black"},{"$f":"+D$13&\" \"","v":"#000000 "},0,{"$f":"+F30&\", \"","v":"2px, "},{"$f":"SUM(D$29:D31)&\"px\"","v":"2px"},{"$f":"IF(B31=\"None\",\"\",C31&E31&C31&F31&\", \")","v":"#000000 2px, #000000 2px, "},null,"Upper Line #2",{"$f":"_xlfn.XLOOKUP(L$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Vivid Blue"},{"$f":"+L$13&\" \"","v":"#003AF6 "},{"$f":"VALUE(IF(L4<>\"Double\",0,SUBSTITUTE(L14,\"px\",\"\")))","v":0},{"$f":"+N30&\", \"","v":"2px, "},{"$f":"SUM(L$29:L31)&\"px\"","v":"2px"},{"$f":"IF(J31=\"None\",\"\",K31&M31&K31&N31&\", \")","v":"#003AF6 2px, #003AF6 2px, "}]
["Background color",{"$f":"_xlfn.XLOOKUP(D$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Light Yellow"},{"$f":"+D$6&\" \"","v":"#FFFFBF "},0.51,{"$f":"+F31&\", \"","v":"2px, "},{"$f":"TEXT(+D32,\"0.0%\")","v":"51.0%"},{"$f":"IF(B32=\"None\",\"\",C32&E32&C32&F32&\", \")","v":"#FFFFBF 2px, #FFFFBF 51.0%, "},null,"Background color",{"$f":"_xlfn.XLOOKUP(L$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Bright Turq"},{"$f":"+L$6&\" \"","v":"#26EAEA "},0.51,{"$f":"+N31&\", \"","v":"2px, "},{"$f":"TEXT(+L32,\"0.0%\")","v":"51.0%"},{"$f":"IF(J32=\"None\",\"\",K32&M32&K32&N32&\", \")","v":"#26EAEA 2px, #26EAEA 51.0%, "}]
["Lower line #1",{"$f":"_xlfn.XLOOKUP(D$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Black"},{"$f":"+D$13&\" \"","v":"#000000 "},{"$f":"VALUE(IF(B33=\"None\",0,SUBSTITUTE(D14,\"px\",\"\")))","v":2},{"$f":"+F32","v":"51.0%"},{"$f":"+\"calc(\"&F$32&\" + \"&INT(SUM(D$33:D33))&\"px), \"","v":"calc(51.0% + 2px), "},{"$f":"IF(B33=\"None\",\"\",C33&E33&\", \"&C33&F33)","v":"#000000 51.0%, #000000 calc(51.0% + 2px), "},null,"Lower line #1",{"$f":"_xlfn.XLOOKUP(L$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Vivid Blue"},{"$f":"+L$13&\" \"","v":"#003AF6 "},{"$f":"VALUE(IF(J33=\"None\",0,SUBSTITUTE(L14,\"px\",\"\")))","v":2},{"$f":"+N32","v":"51.0%"},{"$f":"+\"calc(\"&N$32&\" + \"&INT(SUM(L$33:L33))&\"px), \"","v":"calc(51.0% + 2px), "},{"$f":"IF(J33=\"None\",\"\",K33&M33&\", \"&K33&N33)","v":"#003AF6 51.0%, #003AF6 calc(51.0% + 2px), "}]
["Space between double lower lines",{"$f":"_xlfn.XLOOKUP(D$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Light Yellow"},{"$f":"+D$6&\" \"","v":"#FFFFBF "},{"$f":"VALUE(IF(D5<>\"Double\",0,SUBSTITUTE(D15,\"px\",\"\")))","v":3},"calc(51.0% + 2px), ",{"$f":"+\"calc(\"&F$32&\" + \"&INT(SUM(D$33:D34))&\"px), \"","v":"calc(51.0% + 5px), "},{"$f":"IF(B34=\"None\",\"\",C34&E34&C34&F34)","v":"#FFFFBF calc(51.0% + 2px), #FFFFBF calc(51.0% + 5px), "},null,"Space between double lower lines",{"$f":"_xlfn.XLOOKUP(L$6,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Bright Turq"},{"$f":"+L$6&\" \"","v":"#26EAEA "},{"$f":"VALUE(IF(L5<>\"Double\",0,SUBSTITUTE(L15,\"px\",\"\")))","v":0},"calc(51.0% + 2px), ",{"$f":"+\"calc(\"&N$32&\" + \"&INT(SUM(L$33:L34))&\"px), \"","v":"calc(51.0% + 2px), "},{"$f":"IF(J34=\"None\",\"\",K34&M34&K34&N34)","v":"#26EAEA calc(51.0% + 2px), #26EAEA calc(51.0% + 2px), "}]
["Lower line #2",{"$f":"_xlfn.XLOOKUP(D$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Black"},{"$f":"+D$13&\" \"","v":"#000000 "},{"$f":"VALUE(IF(D5<>\"Double\",0,SUBSTITUTE(D14,\"px\",\"\")))","v":2},"calc(51.0% + 5px), ",{"$f":"+\"calc(\"&F$32&\" + \"&INT(SUM(D$33:D35))&\"px), \"","v":"calc(51.0% + 7px), "},{"$f":"IF(B35=\"None\",\"\",C35&E35&C35&F35)","v":"#000000 calc(51.0% + 5px), #000000 calc(51.0% + 7px), "},null,"Lower line #2",{"$f":"_xlfn.XLOOKUP(L$13,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Vivid Blue"},{"$f":"+L$13&\" \"","v":"#003AF6 "},{"$f":"VALUE(IF(L5<>\"Double\",0,SUBSTITUTE(L14,\"px\",\"\")))","v":0},"calc(51.0% + 2px), ",{"$f":"+\"calc(\"&N$32&\" + \"&INT(SUM(L$33:L35))&\"px), \"","v":"calc(51.0% + 2px), "},{"$f":"IF(J35=\"None\",\"\",K35&M35&K35&N35)","v":"#003AF6 calc(51.0% + 2px), #003AF6 calc(51.0% + 2px), "}]
["Null space color",{"$f":"_xlfn.XLOOKUP(D$9,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"White"},{"$f":"+D$9&\" \"","v":"#FFFFFF "},null,"calc(51.0% + 7px), ",{"$f":"TEXT(1,\"0.0%\")","v":"100.0%"},{"$f":"IF(B36=\"None\",\"\",C36&E36&C36&F36&\");\")","v":"#FFFFFF calc(51.0% + 7px), #FFFFFF 100.0%);"},null,"Null space color",{"$f":"_xlfn.XLOOKUP(L$9,Lookups!$C$4:$C$17,Lookups!$B$4:$B$17)","v":"Cotton Candy"},{"$f":"+L$9&\" \"","v":"#FFB7D5 "},null,"calc(51.0% + 2px), ",{"$f":"TEXT(1,\"0.0%\")","v":"100.0%"},{"$f":"IF(J36=\"None\",\"\",K36&M36&K36&N36&\");\")","v":"#FFB7D5 calc(51.0% + 2px), #FFB7D5 100.0%);"}]
[]
["Bottom padding",{"$f":"+D8","v":"30px"},null,null,null,null,"padding-bottom: 30px; ",null,"Bottom padding",{"$f":"+L8","v":"30px"},null,null,null,null,"padding-bottom: 30px; "]
["Top padding",{"$f":"MAX(SUBSTITUTE(F31,\"px\",\"\")+SUBSTITUTE(D7,\"px\",\"\"),0)&\"px\"","v":"8px"},null,null,null,null,{"$f":"+\"padding-top: \"&B39&\"; \"","v":"padding-top: 8px; "},null,"Top padding",{"$f":"MAX(SUBSTITUTE(N31,\"px\",\"\")+SUBSTITUTE(L7,\"px\",\"\"),0)&\"px\"","v":"8px"},null,null,null,null,{"$f":"+\"padding-top: \"&J39&\"; \"","v":"padding-top: 8px; "}]
["Text color","Calculated",null,null,null,null,{"$f":"+\"color: \"&F6&\"; \"","v":"color: Black; "},null,"Text color","Calculated",null,null,null,null,{"$f":"+\"color: \"&N6&\"; \"","v":"color: Black; "}]
[]
[]
[]
["Favorites"]
["  - Copy CSS strings and paste them below (using Paste … Values) to maintain a library of favorites for quickly copying/pasting CSS into ICRW reports, instead of having to recreate them repeatedly."]
[]
["Description",null,"CSS String"]
["Values - Grand Totals - (Melon)",null,"background-image: linear-gradient(180deg, #000000 0px, #000000 2px, #FEBAAD 2px, #FEBAAD 2px, #000000 2px, #000000 2px, #FEBAAD 2px, #FEBAAD 51.0%, #000000 51.0%, #000000 calc(51.0% + 2px), #FEBAAD calc(51.0% + 2px), #FEBAAD calc(51.0% + 5px), #000000 calc(51.0% + 5px), #000000 calc(51.0% + 7px), #FFFFFF calc(51.0% + 7px), #FFFFFF 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "]
["Values - Sub-Totals - (Yellow)",null,"background-image: linear-gradient(180deg, #000000 0px, #000000 2px, #FFFFBF 2px, #FFFFBF 2px, #000000 2px, #000000 2px, #FFFFBF 2px, #FFFFBF 51.0%, #000000 51.0%, #000000 calc(51.0% + 2px), #FFFFBF calc(51.0% + 2px), #FFFFBF calc(51.0% + 5px), #000000 calc(51.0% + 5px), #000000 calc(51.0% + 7px), #FFFFFF calc(51.0% + 7px), #FFFFFF 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "]
["Labels - Sub-Totals - Invoices (Hudson Blue)",null,"background-image: linear-gradient(180deg, #000000 0px, #000000 2px, #95C0E7 2px, #95C0E7 2px, #000000 2px, #000000 2px, #95C0E7 2px, #95C0E7 51.0%, #000000 51.0%, #000000 calc(51.0% + 2px), #95C0E7 calc(51.0% + 2px), #95C0E7 calc(51.0% + 2px), #000000 calc(51.0% + 2px), #000000 calc(51.0% + 2px), #FFFFFF calc(51.0% + 2px), #FFFFFF 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "]
["Labels - Sub-Totals - Customers (Vivid Blue)",null,"background-image: linear-gradient(180deg, #000000 0px, #000000 2px, #95C0E7 2px, #95C0E7 2px, #000000 2px, #000000 2px, #95C0E7 2px, #95C0E7 51.0%, #000000 51.0%, #000000 calc(51.0% + 2px), #95C0E7 calc(51.0% + 2px), #95C0E7 calc(51.0% + 2px), #000000 calc(51.0% + 2px), #000000 calc(51.0% + 2px), #FFFFFF calc(51.0% + 2px), #FFFFFF 100.0%);padding-bottom: 30px; padding-top: 8px; color: Black; "]

{"sheet":"Lookups","index":2,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4]]}
[null,"Range name: COLOR_LOOKUP"]
[null,"Background Colors",null,"Associated Text Color",null,{"$f":"+\"Manage your list of selectable colors by adding or deleting lines between rows \"&ROW(C4)&\" and \"&ROW(C17)&\" below.\"","v":"Manage your list of selectable colors by adding or deleting lines between rows 4 and 17 below."}]
[null,"Color Names","Hex Code","Color Name","Hex Code","Samples of Hex Color Codes can be found on several other tabs of this spreadsheet."]
[]
[null,"Black","#000000","White","#FFFFFF"]
[null,"White","#FFFFFF","Black","#000000"]
[null,"Light Yellow","#FFFFBF","Black","#000000"]
[null,"Bright Turq","#26EAEA","Black","#000000"]
[null,"Pink","#FF8CC6","Black","#000000"]
[null,"Paris Green","#4AC286","Black","#000000"]
[null,"Vivid Blue","#003AF6","White","#FFFFFF"]
[null,"Navy Blue","#002086","White","#FFFFFF"]
[null,"Red","#FF0000","White","#FFFFFF"]
[null,"Hudson Blue","#95C0E7","Black","#000000"]
[null,"Melon","#FEBAAD","Black","#000000"]
[null,"Cotton Candy","#FFB7D5","Black","#000000"]
[]
[]
[]
[null,"Range name: LINE_TYPES"]
[]
[null,"None"]
[null,"Single"]
[null,"Double"]
[]
[]
[]
[null,"Range name: LINE_THICKNESS",null,null,{"$f":"+\"For more line thicknesses, insert additional lines between lines \"&\"lines \"&ROW(B29)&\" and \"&ROW(B35)&\", as desired.\"","v":"For more line thicknesses, insert additional lines between lines lines 29 and 35, as desired."}]
[]
[null,"1px"]
[null,"2px"]
[null,"3px"]
[null,"4px"]
[null,"5px"]
[]
[]
[]
[null,"Range name: YES_NO"]
[]
[null,"Yes"]
[null,"No"]

{"sheet":"Crayons","index":3,"n_rows":277,"n_cols":9,"rows_kept":277,"cut":false,"hidden":false,"merged":[]}
["Crayola ® Crayon Colors"]
[]
["For more cool information, see:"]
["https://en.wikipedia.org/wiki/List_of_Crayola_crayon_colors"]
[]
["Standard Colors - Current box of 64",null,null,null,null,"Standard Colors - Other"]
[]
["Color Name","Hex Color","Recommended\nText Color",null,null,"Color Name","Hex Color","Recommended\nText Color","Years in\nProduction"]
["Red","#ED0A3F","White",null,null,"Maroon","#C32148","White","1949–present"]
["Scarlet","#FD0E35","White",null,null,"English Vermilion","#CC474B","White","1903–1935"]
["Brick Red","#C62D42","White",null,null,"Madder Lake","#CC3336","White","1903–1935"]
["Chestnut","#B94E48","White",null,null,"Permanent Geranium Lake","#E12C2C","White","1903–circa 1910"]
["Bittersweet","#FE6F5E","White",null,null,"Maximum Red","#D92121","White","1926–1944"]
["Burnt Orange","#CC5500","White",null,null,"Orange-Red","#FF5349","White","1958–1990"]
["Red-Orange","#FF681F","White",null,null,"Sunset Orange","#FE4C40","White","1997–present"]
["Orange","#FF8833","Black",null,null,"Dark Venetian Red","#B33B24","White","1903–circa 1910"]
["Macaroni and Cheese","#FFB97B","Black",null,null,"Venetian Red","#CC553D","White","1903–1944"]
["Yellow-Orange","#FFAE42","Black",null,null,"Light Venetian Red","#E6735C","White","1903–circa 1910"]
["Goldenrod","#FCD667","Black",null,null,"Vivid Tangerine","#FF9980","Black","1990–present"]
["Dandelion","#FED85D","Black",null,null,"Mango Tango","#E77200","White","2003–present"]
["Yellow","#FBE870","Black",null,null,"Banana Mania","#FBE7B2","Black","1998–present"]
["Green-Yellow","#BDE861","Black",null,null,"Maize","#F2C649","Black","1903–1990"]
["Olive Green","#808000","White",null,null,"Orange-Yellow","#F8D568","Black","1958–1990"]
["Spring Green","#ECEBBD","Black",null,null,"Middle Yellow","#FFD600","Black","1926–1944"]
["Yellow-Green","#C5E17A","Black",null,null,"Maximum Yellow","#FAFA37","Black","1926–1944"]
["Asparagus","#7BA05B","White",null,null,"Canary","#FFFF99","Black","1998–present"]
["Granny Smith Apple","#9DE093","Black",null,null,"Lemon Yellow","#FFFF9F","Black","1903–1990"]
["Green","#01A638","White",null,null,"Inchworm","#AFE313","Black","2003–present"]
["Forest Green","#5FA777","White",null,null,"Fern","#63B76C","White","1998–present"]
["Sea Green","#93DFB8","Black",null,null,"Shamrock","#33CC99","Black","1993–present"]
["Robin's Egg Blue","#00CCCC","Black",null,null,"Mountain Meadow","#1AB385","White","1998–present"]
["Turquoise Blue","#00FFEF","Black",null,null,"Jungle Green","#29AB87","White","1990–present"]
["Sky Blue","#76D7EA","Black",null,null,"Caribbean Green","#00CC99","Black","1997–present"]
["Blue-Green","#0095B7","White",null,null,"Tropical Rain Forest","#00755E","White","1993–present"]
["Pacific Blue","#009DC4","White",null,null,"Pine Green","#01796F","White","1903–1949, 1958–present"]
["Cerulean","#02A4D3","White",null,null,"Teal Blue","#008080","White","1990–2003"]
["Cornflower","#93CCEA","Black",null,null,"Light Blue","#8FD8D8","Black",1958]
["Blue","#0066FF","White",null,null,"Aquamarine","#6BCAE2","Black","1949–present"]
["Cadet Blue","#5F9EA0","Black",null,null,"Green-Blue","#0B98BA","White","1958–1990"]
["Periwinkle","#C3CDE6","Black",null,null,"Midnight Blue","#003366","White","1903–present"]
["Bluetiful","#3C69E7","White",null,null,"Navy Blue","#000080","White","1958–present"]
["Indigo","#4F69C6","White",null,null,"Denim","#1560BD","White","1993–present"]
["Blue-Violet","#6456B7","White",null,null,"Wild Blue Yonder","#7A89B8","White","2003–present"]
["Violet","#8359A3","White",null,null,"Manatee","#8D90A1","White","1998–present"]
["Wisteria","#C9A0DC","Black",null,null,"Cobalt Blue","#0047AB","White","1903–1958"]
["Purple Mountain Majesties","#D6AEDD","Black",null,null,"Celestial Blue","#7070CC","White","1903–circa 1910"]
["Plum","#8E3179","White",null,null,"Blue Bell","#9999CC","White","1998–present"]
["Red-Violet","#BB3385","White",null,null,"Violet-Blue","#766EC8","White","1903–circa 1910, 1930–1990"]
["Magenta","#F653A6","White",null,null,"Ultramarine Blue","#3F26BF","White","1903–1944"]
["Wild Strawberry","#FF3399","White",null,null,"Purple Heart","#652DC1","White","1998–present"]
["Lavender","#FBAED2","Black",null,null,"Royal Purple","#6B3FA0","White","1990–present"]
["Carnation Pink","#FFA6C9","Black",null,null,"Medium Violet","#8F47B3","White","1949–1958"]
["Violet-Red","#F7468A","White",null,null,"Lavender","#BF8FCC","Black","1949–1958"]
["Tickle Me Pink","#FC80A5","Black",null,null,"Vivid Violet","#803790","White","1997–present"]
["Mauvelous","#F091A9","Black",null,null,"Maximum Purple","#733380","White","1926–1944"]
["Salmon","#FF91A4","Black",null,null,"Fuchsia","#C154C1","White","1990–present"]
["Mahogany","#CA3435","White",null,null,"Pink Flamingo","#FC74FD","Black","1997–present"]
["Melon","#FEBAAD","Black",null,null,"Brilliant Rose","#E667CE","White","1949–1958"]
["Burnt Sienna","#E97451","White",null,null,"Orchid","#E29CD2","Black","1949–present"]
["Brown","#AF593E","White",null,null,"Medium Rose","#D96CBE","White","1949–1958"]
["Sepia","#9E5B40","White",null,null,"Thistle","#D8BFD8","Black","1949–1999"]
["Tumbleweed","#DEA681","Black",null,null,"Mulberry","#C8509B","White","1958–2003"]
["Raw Sienna","#D27D46","White",null,null,"Jazzberry Jam","#A50B5E","White","2003–present"]
["Tan","#D2B48C","Black",null,null,"Eggplant","#614051","White","1998–present"]
["Peach","#EA8C8F","Black",null,null,"Cerise","#DA3287","White","1993–present"]
["Apricot","#FDD5B1","Black",null,null,"Cotton Candy","#FFB7D5","Black","1998–present"]
["Gold","#D4AF37","Black",null,null,"Razzmatazz","#E30B5C","White","1993–present"]
["Silver","#C9C0BB","Black",null,null,"Piggy Pink","#FDD7E4","Black","1998–present"]
["Black","#000000","White",null,null,"Carmine","#E62E6B","White","1935–1958"]
["Gray","#8B8680","White",null,null,"Blush","#DB5079","White","1998–present"]
["Timberwolf","#D9D6CF","Black",null,null,"Pink Sherbert","#F7A38E","Black","1998–present"]
["White","#FFFFFF","Black",null,null,"Fuzzy Wuzzy","#87421F","White","1998–present"]
[null,null,null,null,null,"Beaver","#926F5B","White","1998–present"]
[null,null,null,null,null,"Van Dyke Brown","#736A62","White","1903–1910"]
["Flourescents (1992)",null,null,null,null,"Desert Sand","#EDC9AF","Black","1998–present"]
[null,null,null,null,null,"Burnt Umber","#805533","White","1903–1944"]
["Name","Hex Code","Recommended\nText Color",null,null,"Almond","#EED9C4","Black","1998–present"]
["Radical Red","#FF355E","White",null,null,"Raw Umber","#665233","White","1903–1990"]
["Wild Watermelon","#FD5B78","White",null,null,"Shadow","#837050","White","1998–present"]
["Outrageous Orange","#FF6037","White",null,null,"Raw Sienna","#E6BC5C","Black","1958–present"]
["Atomic Tangerine","#FF9966","Black",null,null,"Copper","#DA8A67","White","1903–1915, 1958–present"]
["Neon Carrot","#FF9933","Black",null,null,"Antique Brass","#C88A65","White","1998–present"]
["Sunglow","#FFCC33","Black",null,null,"Charcoal Gray","#736A62","White","1903–1910"]
["Laser Lemon","#FFFF66","Black",null,null,"Blue-Gray","#C8C8CD","Black","1958–1990"]
["Electric Lime","#CCFF00","Black",null,null,"Crayellow","#F1D651","Black","2021, 2022"]
["Screamin' Green","#66FF66","Black",null,null,"Cool Mint","#DDEBEC","Black","2021, 2022"]
["Magic Mint","#AAF0D1","Black",null,null,"Oatmeal","#D9DAD2","Black","2021, 2022"]
["Blizzard Blue","#50BFE6","Black",null,null,"Powder Blue","#C0D5F0","Black","2021, 2022"]
["Shocking Pink","#FF6EFF","Black"]
["Razzle Dazzle Rose","#EE34D2","White"]
["Hot Magenta","#FF00CC","White"]
[]
[]
["Silver Swirls (1990)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Aztec Gold","#C39953","Black"]
["Copper Penny","#AD6F69","White"]
["Green Sheen","#6EAEA1","Black"]
["Pearly Purple","#B768A2","White"]
["Rose Dust","#9E5E6F","White"]
["Steel Teal","#5F8A8B","White"]
["Burnished Brown","#A17A74","White"]
["Cosmic Cobalt","#2E2D88","White"]
["Lilac Luster","#AE98AA","Black"]
["Pewter Blue","#8BA8B7","Black"]
["Rusty Red","#DA2C43","White"]
["Sugar Plum","#914E75","White"]
["Cerulean Frost","#6D9BC3","White"]
["Glossy Grape","#AB92B3","Black"]
["Misty Moss","#BBB477","Black"]
["Polished Pine","#5DA493","White"]
["Shadow Blue","#778BA5","White"]
["Twilight Lavender","#8A496B","White"]
["Cinnamon Satin","#CD607E","White"]
["Granite Gray","#676767","White"]
["Mystic Maroon","#AD4379","White"]
["Quick Silver","#A6A6A6","Black"]
["Shiny Shamrock","#5FA778","White"]
["Wintergreen Dream","#56887D","White"]
[]
[]
["Multicultural (1992)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Apricot","#FDD5B1","Black"]
["Black","#000000","White"]
["Burnt Sienna","#E97451","White"]
["Mahogany","#CA3435","White"]
["Peach","#EA8C8F","Black"]
["Sepia","#9E5B40","White"]
["Tan","#D2B48C","White"]
[]
[]
["Magic Scent (1994)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Mahogany","#CA3435","White"]
["Yellow","#FBE870","Black"]
["Violet","#8359A3","White"]
["Red","#ED0A3F","White"]
["Dandelion","#FED85D","Black"]
["Maroon","#C32148","White"]
["Sepia","#9E5B40","White"]
["Wisteria","#C9A0DC","Black"]
["Wild Strawberry","#FF3399","White"]
["Bluberry Blue","#4570E6","White"]
["Brown","#AF593E","White"]
["Jungle Green","#29AB87","Black"]
["Yellow Green","#C5E17A","Black"]
["Peach","#EA8C8F","Black"]
["Gray","#8B8680","White"]
["Tickle Me Pink","#FC80A5","Black"]
["Sky Blue","#76D7EA","Black"]
["Yellow","#FBE870","Black"]
["Pine Green","#01796F","White"]
["Periwinkle","#C3CDE6","Black"]
[]
[]
["Gem Tones (1994)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Amethyst","#64609A","White"]
["Citrine","#933709","White"]
["Emerald","#14A989","White"]
["Jade","#469A84","White"]
["Jasper","#D05340","White"]
["Lapis Lazuli","#436CB9","White"]
["Malachite","#469496","White"]
["Moonstone","#3AA8C1","White"]
["Onyx","#353839","White"]
["Peridot","#ABAD48","White"]
["Pink Pearl","#B07080","White"]
["Rose Quartz","#BD559C","White"]
["Ruby","#AA4069","White"]
["Sapphire","#2D5DA1","White"]
["Smokey Topaz","#832A0D","White"]
["Tiger's Eye","#B56917","White"]
[]
[]
["Pearl Tones (2019)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Antique Gray","#9F9F9F","Black"]
["Apple Orchard","#BF3F3F","White"]
["Berry Parfait","#A43482","White"]
["Black Pearl","#3A3A3A","White"]
["Bubble Gum","#DF9ACA","Black"]
["Butternut Squash","#E74F00","White"]
["Caribbean Sea","#67CD95","Black"]
["Cloudy Sky","#548CD0","White"]
["Hot Cocoa","#8F482F","White"]
["Iridescent Indigo","#3C32CD","White"]
["Lavender Silk","#6B4D82","White"]
["Leafy Canopy","#94DDCB","Black"]
["Liquid Gold","#FFD966","Black"]
["Mango Purée","#FF6137","Black"]
["Moonlit Pond","#4F2CD0","White"]
["Ocean Foam","#62C9D3","Black"]
["Orange Peel","#FF8021","Black"]
["Pesto","#5F7B4A","White"]
["Pink Luster","#FFB2E7","Black"]
["Red Satin","#9F3434","White"]
["Sea Glass","#C4EA7F","Black"]
["Shooting Star","#FFFF65","Black"]
["Snow Drift","#F3F3F3","Black"]
["Sunset Shimmer","#F79015","White"]
[]
[]
["Colors of the World (2020)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Deep Almond","#986A5A","White"]
["Deep Golden","#8D5B28","White"]
["Deep Rose","#B86F69","White"]
["Deepest Almond","#513529","White"]
["Extra Deep Almond","#6E5046","White"]
["Extra Deep Golden","#5F452E","White"]
["Extra Deep Rose","#6C4D4B","White"]
["Extra Light Almond","#EEE6CF","Black"]
["Light Almond","#E6B9B3","Black"]
["Light Golden","#EDDBC7","Black"]
["Light Medium Almond","#E0B5A4","Black"]
["Light Medium Golden","#F0C9A2","Black"]
["Light Medium Rose","#F4AFB2","Black"]
["Light Rose","#FAC7C3","Black"]
["Medium Almond","#D19C7D","Black"]
["Medium Deep Almond","#AC8065","White"]
["Medium Deep Golden","#A16B4F","White"]
["Medium Deep Rose","#EE8E99","Black"]
["Medium Golden","#DEA26C","Black"]
["Very Deep Almond","#88605E","White"]
["Very Deep Rose","#8F6C68","White"]
["Very Light Almond","#E6D2D3","Black"]
["Very Light Golden","#F0DFCF","Black"]
["Very Light Rose","#F7E1E3","Black"]
["Blonde Hair","#FFFF99","Black"]
["Blue Eyes","#6CDAE7","Black"]
["Brown Eyes","#AF593E","White"]
["Brown Hair","#9E5B40","White"]
["Green Eyes","#7BA05B","White"]
["Red Hair","#CA3435","White"]
[]
[]
["Metallic FX (2001)"]
[]
["Color Name","Hex Color","Recommended\nText Color"]
["Alloy Orange","#C46210","White"]
["B'dazzled Blue","#2E5894","White"]
["Big Dip O' Ruby","#9C2542","White"]
["Bittersweet Shimmer","#BF4F51","White"]
["Blast Off Bronze","#A57164","White"]
["Cyber Grape","#58427C","White"]
["Deep Space Sparkle","#4A646C","White"]
["Gold Fusion","#85754E","White"]
["Illuminating Emerald","#319177","White"]
["Metallic Seaweed","#0A7E8C","White"]
["Robot Canary","#9C7C38","White"]
["Razzmic Berry","#8D4E85","White"]
["Sheen Green","#8FD400","Black"]
["Shimmering Blush","#D98695","Black"]
["Sonic Silver","#757575","White"]
["Steel Blue","#0081AB","White"]
["Cheese Grater","#C89F56","Black"]
["Iron Indigo","#184FA1","White"]
["Magnetic Magenta","#BF3981","White"]
["Cobalt Cool","#028AAE","White"]
["Acid Wash Jeans","#5CB2C5","Black"]
["Petrified Forest","#005B39","White"]
["Rose Gold","#C88CA4","Black"]
["Gold Medal","#C5BC42","Black"]
[]
[]
["The 100,000,000,000th Crayon (1996)"]
[]
["Color Name","Hex Code","Recommended\nText Color"]
["Blue Ribbon","#0B10A2","White"]

{"sheet":"Color Families","index":4,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,3,1,7],[1,9,1,13]]}
[]
[null,null,null,"Blue",null,null,null,null,null,"Green",null,null,null,null,null,"Yellow/Gold",null,"Orange/Brown",null,"Red",null,"Magenta",null,"Purple",null,"Violet"]
[]
[null,"100% ",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF",null," #FFFFFF"]
[]
[null,"95% ",null," #E6EBFF",null," #E6F5FF",null," #E6FFFF",null," #ECF9F2",null," #EBFAEB",null," #EEFFE6",null," #FFFFE6",null," #FFF0E6",null," #FFE6E6",null," #FFE6F2",null," #F9E6FF",null," #F2E6FF"]
[]
[null,"90% ",null," #CCD8FF",null," #CCEBFF",null," #CCFFFF",null," #D9F2E6",null," #D6F5D6",null," #DDFFCC",null," #FFFFCC",null," #FFE0CC",null," #FFCCCC",null," #FFCCE6",null," #F3CCFF",null," #E6CCFF"]
[]
[null,"85% ",null," #B3C4FF",null," #B3E0FF",null," #B3FFFF",null," #C6ECD9",null," #C2F0C2",null," #CCFFB3",null," #FFFFB3",null," #FFD1B3",null," #FFB3B3",null," #FFB3D9",null," #EDB3FF",null," #D9B3FF"]
[]
[null,"80% ",null," #99B1FF",null," #99D6FF",null," #99FFFF",null," #B3E6CC",null," #ADEBAD",null," #BBFF99",null," #FFFF99",null," #FFC299",null," #FF9999",null," #FF99CC",null," #E799FF",null," #CC99FF"]
[]
[null,"75% ",null," #809DFF",null," #80CCFF",null," #80FFFF",null," #9FDFBF",null," #99E699",null," #AAFF80",null," #FFFF80",null," #FFB380",null," #FF8080",null," #FF80BF",null," #E180FF",null," #BF80FF"]
[]
[null,"70% ",null," #668AFF",null," #66C2FF",null," #66FFFF",null," #8CD9B3",null," #85E085",null," #99FF66",null," #FFFF66",null," #FFA366",null," #FF6666",null," #FF66B3",null," #DB66FF",null," #B366FF"]
[]
[null,"65% ",null," #4D76FF",null," #4DB8FF",null," #4DFFFF",null," #79D2A6",null," #70DB70",null," #88FF4D",null," #FFFF4D",null," #FF944D",null," #FF4D4D",null," #FF4DA6",null," #D54DFF",null," #A64DFF"]
[]
[null,"60% ",null," #3363FF",null," #33ADFF",null," #33FFFF",null," #66CC99",null," #5CD65C",null," #77FF33",null," #FFFF33",null," #FF8533",null," #FF3333",null," #FF3399",null," #CF33FF",null," #9933FF"]
[]
[null,"55% ",null," #1A4FFF",null," #1AA3FF",null," #1AFFFF",null," #53C68C",null," #47D147",null," #66FF1A",null," #FFFF1A",null," #FF751A",null," #FF1A1A",null," #FF1A8C",null," #C91AFF",null," #8C1AFF"]
[]
[null,"50% ",null," #003CFF",null," #0099FF",null," #00FFFF",null," #40BF80",null," #33CC33",null," #55FF00",null," #FFFF00",null," #FF6600",null," #FF0000",null," #FF0080",null," #C300FF",null," #8000FF"]
[]
[null,"45% ",null," #0036E6",null," #008AE6",null," #00E6E6",null," #39AC73",null," #2EB82E",null," #4CE600",null," #E6E600",null," #E65C00",null," #E60000",null," #E60073",null," #9900e6",null," #7300E6"]
[]
[null,"40% ",null," #0030CC",null," #007ACC",null," #00CCCC",null," #339966",null," #29A329",null," #44CC00",null," #CCCC00",null," #CC5200",null," #CC0000",null," #CC0066",null," #9C00CC",null," #6600CC"]
[]
[null,"35% ",null," #002AB3",null," #006BB3",null," #00B3B3",null," #2D8659",null," #248F24",null," #3BB300",null," #B3B300",null," #B34700",null," #B30000",null," #B30059",null," #8900B3",null," #5900B3"]
[]
[null,"30% ",null," #002499",null," #005C99",null," #009999",null," #26734D",null," #1F7A1F",null," #339900",null," #999900",null," #993D00",null," #990000",null," #99004D",null," #750099",null," #4D0099"]
[]
[null,"25% ",null," #001E80",null," #004D80",null," #008080",null," #206040",null," #196619",null," #2A8000",null," #808000",null," #803300",null," #800000",null," #800040",null," #620080",null," #400080"]
[]
[null,"20% ",null," #001866",null," #003D66",null," #006666",null," #194D33",null," #145214",null," #226600",null," #666600",null," #662900",null," #660000",null," #660033",null," #4E0066",null," #330066"]
[]
[null,"15% ",null," #00124D",null," #002E4D",null," #004D4D",null," #133926",null," #0F3D0F",null," #194D00",null," #4D4D00",null," #4D1F00",null," #4D0000",null," #4D0026",null," #3B004D",null," #26004D"]
[]
[null,"10% ",null," #000C33",null," #001F33",null," #003333",null," #0D261A",null," #0A290A",null," #113300",null," #333300",null," #331400",null," #330000",null," #33001A",null," #270033",null," #1A0033"]
[]
[null,"5% ",null," #00061A",null," #000F1A",null," #001A1A",null," #06130D",null," #051405",null," #081A00",null," #1A1A00",null," #1A0A00",null," #1A0000",null," #1A000D",null," #14001A",null," #0D001A"]
[]
[null,"0% ",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000",null," #000000"]

{"sheet":"Color Wheel","index":5,"n_rows":10,"n_cols":36,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,31,8,32],[8,33,8,34],[9,8,9,9],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,19],[9,20,9,21],[9,32,9,33],[8,19,8,20],[8,21,8,22],[8,23,8,24],[8,25,8,26],[8,27,8,28],[8,29,8,30],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[8,15,8,16],[8,17,8,18],[7,18,7,19],[7,20,7,21],[6,31,6,32],[6,33,6,34],[6,35,6,36],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[7,16,7,17],[6,19,6,20],[6,21,6,22],[6,23,6,24],[6,25,6,26],[6,27,6,28],[6,29,6,30],[7,30,7,31],[7,32,7,33],[7,34,7,35],[7,22,7,23],[7,24,7,25],[7,26,7,27],[7,28,7,29],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,15,6,16],[6,17,6,18],[5,18,5,19],[4,29,4,30],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,31,4,32],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[5,30,5,31],[5,32,5,33],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[4,3,4,4],[4,5,4,6],[3,14,3,15],[3,16,3,17],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,26,3,27],[3,28,3,29],[3,30,3,31],[3,18,3,19],[3,20,3,21],[3,22,3,23],[3,24,3,25],[1,18,1,19],[1,20,1,21],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[2,21,2,22]]}
[]
[null,null,null,null,null,null,"66CCCC",null,"99CCCC",null,"CCCCCC",null,"000000",null,"000066",null,"000099",null,"0000CC",null,"0000FF"]
[null,null,null,null,null,"6699CC",null,"9999CC",null,"CC99CC",null,"660000",null,"660066",null,"660099",null,"6600CC",null,"6600FF",null,"0066FF",null,"0066CC",null,"006699",null,"006666",null,"006600"]
[null,null,null,null,"6666CC",null,"9966CC",null,"CC66CC",null,"990000",null,"990066",null,"990099",null,"9900CC",null,"9900FF",null,"6666FF",null,"0099FF",null,"0099CC",null,"009999",null,"009966",null,"009900"]
[null,null,null,666699,null,"996699",null,"CC6699",null,"CC0000",null,"CC0066",null,"CC0099",null,"CC00CC",null,"CC00FF",null,"9966FF",null,"6699FF",null,"00CCFF",null,"00CCCC",null,"00CC99",null,"00CC66",null,"00CC00"]
[null,null,666666,null,"996666",null,"CC6666",null,"FF0000",null,"FF0066",null,"FF0099",null,"FF00CC",null,"FF00FF",null,"CC66FF",null,"9999FF",null,"66CCFF",null,"00FFFF",null,"00FFCC",null,"00FF99",null,"00FF66",null,"00FF00"]
[null,null,null,"666600",null,"996600",null,"CC6600",null,"FF6600",null,"FF6666",null,"FF6699",null,"FF66CC",null,"FF66FF",null,"CC99FF",null,"99CCFF",null,"66FFFF",null,"66FFCC",null,"66FF99",null,"66FF66",null,"66FF00",null,"66CC66",null,"66CC99"]
[null,null,null,null,"669900",null,"CC9966",null,"CC9900",null,"FF9900",null,"FF9966",null,"FF9999",null,"FF99CC",null,"FF99FF",null,"CCCCFF",null,"99FFFF",null,"99FFCC",null,"99FF99",null,"99FF66",null,"99FF00",null,"99CC66",null,"999966"]
[null,null,null,null,null,"66CC00",null,"99CC00",null,"CCCC00",null,"FFCC00",null,"FFCC66",null,"FFCC99",null,"FFCCCC",null,"FFCCFF",null,"CCFFFF",null,"CCFFCC",null,"CCFF99",null,"CCFF66",null,"CCFF00",null,"CCCC66",null,"99CC99"]
[null,null,null,null,null,null,null,null,"999900",null,null,null,"FFFF00",null,"FFFF66",null,"FFFF99",null,"FFFFCC",null,"FFFFFF",null,null,null,null,null,null,null,null,null,null,null,"CCCC99"]