{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["01_Workaround","02_VBA_Long","02_VBA_RGB","03_Professor_Excel_Tools_RGB","03_Professor_Excel_Tools_Long"],"not_rendered":{"macros":1,"external_links":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"01_Workaround","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[]
[null,"Summary: Sales per person"]
[]
[null,"Name","Region","Sales amount [USD k]","Color"]
[null,"Joe Miller","North",754]
[null,"Robert B. Klein","South",700,"Yellow"]
[null,"Michelle Adams","East",618]
[null,"Erich Brown Jr.","West",591]
[null,"Dafna Johnson","North",702,"Yellow"]
[null,"Rob C.","South",572]

{"sheet":"02_VBA_Long","index":1,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[]
[null,"Summary: Sales per person"]
[]
[null,"Name","Region","Sales amount [USD k]","Color"]
[null,"Joe Miller","North",754,{"$f":"ProfessorExcelBackgroundColor(D6)","v":16777215}]
[null,"Robert B. Klein","South",700,{"$f":"ProfessorExcelBackgroundColor(D7)","v":65535}]
[null,"Michelle Adams","East",618,{"$f":"ProfessorExcelBackgroundColor(D8)","v":16777215}]
[null,"Erich Brown Jr.","West",591,{"$f":"ProfessorExcelBackgroundColor(D9)","v":16777215}]
[null,"Dafna Johnson","North",702,{"$f":"ProfessorExcelBackgroundColor(D10)","v":65535}]
[null,"Rob C.","South",572,{"$f":"ProfessorExcelBackgroundColor(D11)","v":16777215}]

{"sheet":"02_VBA_RGB","index":2,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[]
[null,"Summary: Sales per person"]
[]
[null,"Name","Region","Sales amount [USD k]","Color"]
[null,"Joe Miller","North",754,{"$f":"ProfessorExcelBackgroundRGB(D6)","v":"255, 255, 255"}]
[null,"Robert B. Klein","South",700,{"$f":"ProfessorExcelBackgroundRGB(D7)","v":"255, 255, 0"}]
[null,"Michelle Adams","East",618,{"$f":"ProfessorExcelBackgroundRGB(D8)","v":"255, 255, 255"}]
[null,"Erich Brown Jr.","West",591,{"$f":"ProfessorExcelBackgroundRGB(D9)","v":"255, 255, 255"}]
[null,"Dafna Johnson","North",702,{"$f":"ProfessorExcelBackgroundRGB(D10)","v":"255, 255, 0"}]
[null,"Rob C.","South",572,{"$f":"ProfessorExcelBackgroundRGB(D11)","v":"255, 255, 255"}]

{"sheet":"03_Professor_Excel_Tools_RGB","index":3,"n_rows":16,"n_cols":5,"rows_kept":16}
[]
[]
[null,"Summary: Sales per person"]
[]
[null,"Name","Region","Sales amount [USD k]","Color"]
[null,"Joe Miller","North",754,{"$f":"[1]!profExBackgroundColor(D6,TRUE)","v":"255, 255, 255"}]
[null,"Robert B. Klein","South",700,{"$f":"[1]!profExBackgroundColor(D7,TRUE)","v":"255, 255, 0"}]
[null,"Michelle Adams","East",618,{"$f":"[1]!profExBackgroundColor(D8,TRUE)","v":"255, 255, 255"}]
[null,"Erich Brown Jr.","West",591,{"$f":"[1]!profExBackgroundColor(D9,TRUE)","v":"255, 255, 255"}]
[null,"Dafna Johnson","North",702,{"$f":"[1]!profExBackgroundColor(D10,TRUE)","v":"255, 255, 0"}]
[null,"Rob C.","South",572,{"$f":"[1]!profExBackgroundColor(D11,TRUE)","v":"255, 255, 255"}]
[]
[]
[null,"Please note: Only works if Professor Excel Tools is installed. You can download it here:"]
[null,"Download Professor Excel Tools"]
[null,"In order to use the Professor Excel functions (like PROFEXBackgroundColor) you don't have to purchase a license after 7 days. These functions work permanently."]

{"sheet":"03_Professor_Excel_Tools_Long","index":4,"n_rows":16,"n_cols":5,"rows_kept":16}
[]
[]
[null,"Summary: Sales per person"]
[]
[null,"Name","Region","Sales amount [USD k]","Color"]
[null,"Joe Miller","North",754,{"$f":"[1]!profExBackgroundColor(D6,FALSE)","v":16777215}]
[null,"Robert B. Klein","South",700,{"$f":"[1]!profExBackgroundColor(D7,FALSE)","v":65535}]
[null,"Michelle Adams","East",618,{"$f":"[1]!profExBackgroundColor(D8,FALSE)","v":16777215}]
[null,"Erich Brown Jr.","West",591,{"$f":"[1]!profExBackgroundColor(D9,FALSE)","v":16777215}]
[null,"Dafna Johnson","North",702,{"$f":"[1]!profExBackgroundColor(D10,FALSE)","v":65535}]
[null,"Rob C.","South",572,{"$f":"[1]!profExBackgroundColor(D11,FALSE)","v":16777215}]
[]
[]
[null,"Please note: Only works if Professor Excel Tools is installed. You can download it here:"]
[null,"Download Professor Excel Tools"]
[null,"In order to use the Professor Excel functions (like PROFEXBackgroundColor) you don't have to purchase a license after 7 days. These functions work permanently."]