{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Sheet1","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,"Color I want to count:",null,null,"Hoover over the coment in cell A1."]
[]
[]
["Division","Hours","PayRate","GrossPay","Output","Cost","Per Week"]
["Anacortes",40,23,{"$f":"B5*C5","v":920},{"$f":"D5/$D$44","v":3.1904121180175056E-2},{"$f":"G5*365+2000","v":12713.403892302784},{"$f":"E5*D5","v":29.351791485761051}]
["Anacortes",40,24,960,{"$f":"D6/$D$44","v":3.3291256883660927E-2},{"$f":"G6*365+2000","v":13665.256412034789},31.959606608314491]
["Anacortes",40,23,920,{"$f":"D7/$D$44","v":3.1904121180175056E-2},12713.403892302784,29.351791485761051]
["Bremerton",32,22.25,712,{"$f":"D8/$D$44","v":2.4691015522048519E-2},8416.7011138699709,17.580003051698547]
["Bremerton",36,15.45,556.19999999999993,{"$f":"D9/$D$44","v":1.9288121956971046E-2},5915.7395028505625,10.728053432467295]
["Bremerton",36,15.45,556.19999999999993,{"$f":"D10/$D$44","v":1.9288121956971046E-2},5915.7395028505625,10.728053432467295]
["Hoquiam",40,21.5,860,{"$f":"D11/$D$44","v":2.9823417624946245E-2},11361.570792470626,25.64813915745377]
["Hoquiam",40,22,880,{"$f":"D12/$D$44","v":3.0516985476689185E-2},11802.055735112566,26.854947219486483]
["Sedro Woolley",40,14,560,{"$f":"D13/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Sedro Woolley",40,14,560,{"$f":"D14/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Sedro Woolley",40,23,920,{"$f":"D15/$D$44","v":3.1904121180175056E-2},12713.403892302784,29.351791485761051]
["Walla Walla",40,18.5,740,{"$f":"D16/$D$44","v":2.5662010514488631E-2},8931.3090399633802,18.989887780721588]
["Walla Walla",32,17,544,{"$f":"D17/$D$44","v":1.8865045567407857E-2},5745.8434478645049,10.262584788669875]
["Yakima",40,24.75,990,{"$f":"D18/$D$44","v":3.4331608661275333E-2},14405.726789751841,33.98829257466258]
["Yakima",40,24.75,990,{"$f":"D19/$D$44","v":3.4331608661275333E-2},14405.726789751841,33.98829257466258]
["Yakima",40,21.8,872,{"$f":"D20/$D$44","v":3.0239558335992008E-2},11624.646627179536,26.368894868985031]
["Anacortes",40,18,720,{"$f":"D21/$D$44","v":2.4968442662745696E-2},8561.7067317695692,17.977278717176901]
["Anacortes",40,18,720,{"$f":"D22/$D$44","v":2.4968442662745696E-2},8561.7067317695692,17.977278717176901]
["Anacortes",40,17,680,{"$f":"D23/$D$44","v":2.3581306959259824E-2},7852.8803872882891,16.035288732296682]
["Yakima",40,17.25,690,{"$f":"D24/$D$44","v":2.392809088513129E-2},8026.289689420315,16.51038271074059]
["Yakima",32,23.25,744,{"$f":"D25/$D$44","v":2.5800724084837218E-2},9006.4446324783949,{"$f":"E25*D25","v":19.195738719118889}]
["Anacortes",32,14,448,{"$f":"D26/$D$44","v":1.5535919879041765E-2},4540.4336186209093,6.9600921058107108]
["Anacortes",32,14,448,{"$f":"D27/$D$44","v":1.5535919879041765E-2},4540.4336186209093,6.9600921058107108]
["Anacortes",36,23.25,837,{"$f":"D28/$D$44","v":2.902581459544187E-2},10867.531487980468,24.294606816384846]
["Anacortes",36,23.25,837,{"$f":"D29/$D$44","v":2.902581459544187E-2},10867.531487980468,24.294606816384846]
["Bremerton",40,14,560,{"$f":"D30/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Hoquiam",40,14,560,{"$f":"D31/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Hoquiam",40,14,560,{"$f":"D32/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Sedro Woolley",36,17.25,621,{"$f":"D33/$D$44","v":2.1535281796618164E-2},6881.2946484304566,13.37340999569988]
["Walla Walla",40,23,{"$f":"B34*C34","v":920},{"$f":"D34/$D$44","v":3.1904121180175056E-2},12713.403892302784,{"$f":"E34*D34","v":29.351791485761051}]
["Walla Walla",40,24,960,{"$f":"D35/$D$44","v":3.3291256883660927E-2},{"$f":"G35*365+2000","v":13665.256412034789},31.959606608314491]
["Wenatchee",36,14.25,513,{"$f":"D36/$D$44","v":1.7790015397206309E-2},5331.0914330498954,9.1262778987668369]
["Wenatchee",40,23.35,934,{"$f":"D37/$D$44","v":3.2389618676395109E-2},13041.944902969855,30.251903843753031]
["Yakima",36,22,792,{"$f":"D38/$D$44","v":2.7465286929020265E-2},9939.6651454411767,21.752507247784049]
["Yakima",36,22,792,{"$f":"D39/$D$44","v":2.7465286929020265E-2},9939.6651454411767,21.752507247784049]
["Anacortes",40,22,880,{"$f":"D40/$D$44","v":3.0516985476689185E-2},11802.055735112566,26.854947219486483]
["Anacortes",40,15,600,{"$f":"D41/$D$44","v":2.0807035552288078E-2},6556.7407859510895,12.484221331372847]
["Yakima",40,14,560,{"$f":"D42/$D$44","v":1.9419899848802206E-2},5969.4275290951709,10.875143915329236]
["Yakima",40,23,920,{"$f":"D43/$D$44","v":3.1904121180175056E-2},12713.403892302784,29.351791485761051]
[{"$f":"CountCcolor(A5:A43,D1)","v":12},null,null,{"$f":"SUM(D5:D43)","v":28836.400000000001}]