{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Charts","Other Tools"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"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":"Charts","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Chart Color Change Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-04"]
[null,null,null,null,"Chart Color Set",null,null,null,null,null,"Suggested Color Sets"]
[null,null,null,null,"Color Order","Color","Red","Green","Blue",null,"Blue Gold Red","Blue Purple Gray","Major Colors"]
[null,null,null,null,1,null,3,78,110,null,1,1,1]
[null,null,"(Columns, Bars, Areas, Donuts)",null,2,null,52,157,202,null,2,2,7]
[null,null,null,null,3,null,6,121,171,null,3,3]
[null,null,null,null,4,null,108,206,249,null,4,4,13]
[null,null,null,null,5,null,1,52,74,null,5,5,2]
[null,null,"(Line, Scatter, Radar)",null,6,null,175,126,0,null,6]
[null,null,null,null,null,null,255,199,57,null,null,null,8]
[null,null,null,null,7,null,255,183,0,null,7]
[null,null,null,null,8,null,255,212,104,null,8,null,14]
[null,null,"(Line, Scatter, Radar)",null,9,null,118,84,0,null,9]
[null,null,null,null,10,null,175,34,0,null,10,null,3]
[null,null,null,null,null,null,255,95,57,null,null,null,9]
[null,null,null,null,11,null,255,49,0,null,11]
[null,null,"(Pie Charts)",null,12,null,255,133,104,null,12,null,15]
[null,null,null,null,13,null,118,23,0,null,13]
[null,null,null,null,null,null,0,126,51,null,null,null,4]
[null,null,null,null,null,null,48,215,115,null,null,null,10]
[null,null,null,null,null,null,0,191,77]
[null,null,null,null,null,null,102,250,162,null,null,null,16]
[null,null,null,null,14,null,175,93,0,null,14,null,5]
[null,null,null,null,null,null,255,162,57,null,null,null,11]
[null,null,null,null,15,null,255,135,0,null,15]
[null,null,null,null,null,null,255,184,104,null,null,null,17]
[null,null,null,null,null,null,118,62,0]
[null,null,null,null,null,null,10,25,120,null,null,null,6]
[null,null,null,null,null,null,68,88,210,null,null,6,12]
[null,null,null,null,null,null,19,42,183,null,null,7]
[null,null,null,null,null,null,121,139,250,null,null,8,18]
[null,null,null,null,16,null,230,230,230,null,16,9]
[null,null,null,null,17,null,150,150,150,null,17,10]
[null,null,null,null,18,null,0,0,0,null,18,11]
[null,null,null,"Custom Colors     ",null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[null,null,null,null,null,null,150,150,150]
[]
[null,null,null,null,"Instructions"]
[null,null,null,null,"To change chart colors, do the following:"]
[null,null,null,null,"1.       Have the excel sheet open that has the chart you want to modify"]
[null,null,null,null,"2.       Open the Colorize book and enable macros."]
[null,null,null,null,"3.       Enter the order than you want to apply the E3 colors in column B of the Colorize book"]
[null,null,null,null,"4.       Press one of the buttons at the top, depending on whether you want the change the fill color of a chart, line color of a chart, or a pie chart."]
[null,null,null,null,"5.       This will open an alert box --- you will then click on the sheet with your chart, and click on your chart to select it."]
[null,null,null,null,"6.       One the chart is selected, press the Colorize button on the alert box."]
[]
[null,null,null,null,"To make your own colors, do the following:"]
[null,null,null,null,"1.       Enter the RGB integer values in the Custom Colors section starting in row 36. Columns D:F"]
[null,null,null,null,"2.       Press the “Update Sample Colors” button to paint the colors into column C."]
[null,null,null,null,"3.       That’s it.  You can apply your customer colors like any of the existing ones."]

{"sheet":"Other Tools","index":1,"n_rows":145,"n_cols":17,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Add E3 Theme Colors to MS Office",null,null,null,null,null,null,null,null,null,null,null,"Updated","2015-09-04"]
[]
[null,null,null,null,"Installs the E3 Color theme to your computer.  The theme will be available to Excel, Word and Powerpoint"]
[null,null,null,null,"Themes are found in Page Layout -> Colors"]
[]
[null,null,null,null,"Activates the E3 Color theme from the available list of themes. "]
[null,null,null,null,"Same as selecting the E3 theme from Page Layout -> Colors"]
[]
[null,null,null,null,"Remove all non-default styles."]
[]
[]
[]
[null,"Excel Template Instructions (So all new Excel files use the E3 Color theme) (Word instructions to the right)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions for Word"]
[null,"1.  Install the E3 Color Theme (use button above)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.  Install the E3 Color Theme (use button above)"]
[null,"2.  Starting with a new workbook, assure that the E3 Colors are selected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.  Open a new Word file and assure that the E3 Colors are selected (Use Change Styles in the Home tab)"]
[null,null,"a."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.  Click on Change Styles again, and press Set as Default"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.  Save the E3 Colors as a New Theme"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4.  Save the Theme as E3 Colors (or whatever name you prefer)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.  Save the workbook as a new Template"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.  Save the Template with the name E3 Colors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This makes the template available when you "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7.  Save the same file as a Template to the XLSTART folder.  Back up a level then go -> Microsoft -> XLSTART"]
[null,null,"You need to name this one as  Book"]
[null,null,"That will tell Excel to open all new workbooks using your Template"]