{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Switchboard","Basics","Formulas","Advanced Formulas","Data Tables","Graphs","Graphs Parameters","Graphs Table","GraphsCCL","GraphsCCL1","Sheet1","Data Validation","Tasks","TaskSummary","CondFormat","Staff Eval","Rate Comp"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":2,"pivot_tables":1},"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":"Switchboard","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Hyperlink Menu"]
["Basics"]
["Graphs"]
["Graph Parameters"]
["Graphs + Table"]
["Formulas"]
["Advanced formulas"]
["Data Validation"]
["Task Management"]
["Task Summary"]
["Staff Management"]
["Cond Format"]
["Google"]

{"sheet":"Basics","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Definitions",null,"Return"]
["Cell"]
["Range",null,null,null,null,"or "]
["Location"]
[null,"Row",{"$f":"A2","v":"Cell"}]
[null,"Column",{"$f":"B6","v":"Column"}]
[]
["Copying/Moving  Cells"]
[]
[2,1,"2017-01-01","2017-01-01","2017-01-01","2017-01-01","2017-01-01"]
[null,2,"2017-01-02","2017-01-08","2017-01-14","2017-01-02","2018-01-01"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Right Click Patterns"]
["2017-01-01"]

{"sheet":"Formulas","index":2,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Sum","Return",null,null,"Basics of Sequences",null,null,"If then"]
[null,1,null,null,null,1,null,null,"If something is true then",null,null,"Show Rate Computation"]
[null,2,null,null,"Prev cell + 1",{"$f":"F2+1","v":2},null,null,null,"Do this"]
[null,1,null,null,null,{"$f":"F3+1","v":3},null,null,"else: If something is false"]
[null,4,null,null,null,4,null,null,null,"Do that"]
["Total = ",{"$f":"SUM(B2:B5)","v":8},null,null,null,5,null,null,null,null,{"$f":"IF(J6 = \"\",\"\",J6-I6)","v":""}]
[null,null,null,null,null,6,null,null,"Date Due","Date Done","Days Late"]
[null,null,null,null,null,7,null,null,"2015-01-01","2015-01-02",{"$f":"IF(J8 = \"\",\"\",J8-I8)","v":1}]
["Count",null,null,null,null,8,null,null,"2015-01-03","2017-01-06",{"$f":"IF(J9 = \"\",\"\",J9-I9)","v":734}]
[null,1,null,null,null,9,null,null,"2015-01-03","2015-01-07",{"$f":"IF(J10 = \"\",\"\",J10-I10)","v":4},null,null,null,null,null,{"$f":"IF(P10 = \"\",\"\",P10-O10)","v":""}]
[null,null,null,null,null,null,null,null,"2015-01-03","2015-01-07",4]
[null,"a",null,null,"Prev cell + 1 day","2015-01-01",null,null,null,null,""]
[null,7,null,null,null,{"$f":"F12+1","v":"2015-01-02"},null,null,null,null,""]
["Total",{"$f":"COUNT(B10:B13)","v":2},null,null,null,{"$f":"F13+1","v":"2015-01-03"},null,null,null,null,""]
[null,null,null,null,null,"2015-01-04"]
["Counta",null,null,null,null,"2015-01-05"]
[null,"Yes",null,null,null,"2015-01-06"]
[]
[null,"NO",null,null,"Prev cell + 7 days","2015-01-01"]
[null,"No",null,null,null,{"$f":"F19+7","v":"2015-01-08"}]
["Total",{"$f":"COUNTA(B17:B20)","v":3},null,null,null,{"$f":"F20+7","v":"2015-01-15"}]
[null,null,null,null,null,"2015-01-22"]
[null,null,null,null,null,"2015-01-29"]
["Countif",null,null,null,null,"2015-02-05"]
[null,"Yes",null,null,null,"2015-02-12"]
[null,"No"]
[null,"Yes",null,null,"Prev cell + 3 months","2015-01-01"]
[null,"Yes",null,null,null,{"$f":"EDATE(F27,3)","v":"2015-04-01"}]
["Total Yes",{"$f":"COUNTIF(B25:B28,\"Yes\")","v":3},null,null,null,{"$f":"EDATE(F28,3)","v":"2015-07-01"}]
["Total No",{"$f":"COUNTIF(B25:B28,\"No\")","v":1},null,null,null,"2015-10-01"]
["% Yes",{"$f":"100*B29/(B29+B30)","v":75},null,null,null,"2016-01-01"]
[]
[null,null,null,null,"Create weekdays","2015-01-01"]
[null,null,null,null,null,"2015-01-02"]
[null,null,null,null,null,"2015-01-05"]
[null,null,null,null,null,"2015-01-06"]
[null,null,null,null,null,{"$f":"WORKDAY(F36,1)","v":"2015-01-07"}]
[null,null,null,null,null,"2015-01-08"]
[null,null,null,null,null,"2015-01-09"]
[null,null,null,null,null,"2015-01-12"]
[null,null,null,null,null,"2015-01-13"]
[null,null,null,null,null,"2015-01-14"]
[null,null,null,null,null,"2015-01-15"]

{"sheet":"Advanced Formulas","index":3,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["New formulas","Return"]
[]
["Misc Formulas"]
["Today()",{"$f":"TODAY()","v":"2017-07-27"}]
["30 workdays from today",{"$f":"WORKDAY(TODAY(),30)","v":"2017-09-07"}]
["Date/time",{"$f":"NOW()","v":"2017-07-27T10:09:32.020"}]
["Maximum",{"$f":"MAX(C7:G7)","v":8},3,5,2,6,8]
["Minimum",{"$f":"MIN(C7:G7)","v":2}]
["Range",{"$f":"B7-B8","v":6}]
["Average",{"$f":"AVERAGE(C7:G7)","v":4.8}]
[]
[]
["Relative vs Absolute References"]
[null,"Relative","Absolute"]
[1,{"$f":"A15","v":1},{"$f":"$A$15","v":1}]
[2]
[3]
[4]
[5]
[6]
[7]
[]
[]
[]
[]
["Concantenation"]
[null,"/day"]
["#","Time","Rate","Rate with Unit"]
[3,5,{"$f":"A29/B29","v":0.6},{"$f":"C29 & \" \" & $B$27","v":"0.6 /day"}]
[2,2,{"$f":"A30/B30","v":1},{"$f":"C30 & \" \" & $B$27","v":"1 /day"}]
[5,4,1.25,{"$f":"C31 & \" \" & $B$27","v":"1.25 /day"}]
[1,2,0.5,{"$f":"C32 & \" \" & $B$27","v":"0.5 /day"}]

{"sheet":"Data Tables","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg",null,null,null,null,"Steps:"]
["2017-01-01",4,null,null,null,null,"1. Select Range"]
["2017-01-02",3,null,null,null,null,"2. Insert…Table"]
["2017-01-03",5,null,null,null,null,"3. Has headers?"]
["2017-01-04",2,null,null,null,null,"4. Table Tools"]
["2017-01-05",4,null,null,null,null,"   a. Style"]
["2017-01-06",5,null,null,null,null,"   b. Name"]
["2017-01-07",4,null,null,null,null,"5. Add columns"]
["2017-01-08",3,null,null,null,null,"6. Check out formulas"]

{"sheet":"Graphs","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg",null,"Return"]
["2016-01-01",10]
["2016-01-04",15]
["2016-01-05",12]
["2016-01-06",12]
["2016-01-07",11]
["2016-01-08",12]
["2016-01-11",10]
["2016-01-12",12]
["2016-01-13",13]
["2016-01-14",12]
["2016-01-15",11]
["2016-01-18",12]
["2016-01-19",12]
["2016-01-20",12]
["2016-01-21",14]
["2016-01-22",9]
["2016-01-25",10]
["2016-01-26",5]
["2016-01-27",0]

{"sheet":"Graphs Parameters","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg",null,"Return"]
["2016-01-01",10]
["2016-01-04",15]
["2016-01-05",12,null,"Parameters","Label"]
["2016-01-06",12,null,"Title","Test"]
["2016-01-07",11,null,"Y Axis label","# Beh"]
["2016-01-08",12,null,"X Axis Label","Day"]
["2016-01-11",10]
["2016-01-12",12]
["2016-01-13",13]
["2016-01-14",12]
["2016-01-15",11]
["2016-01-18",12]
["2016-01-19",12]
["2016-01-20",12]
["2016-01-21",14]
["2016-01-22",9]
["2016-01-25",10]
["2016-01-26",5]
["2016-01-27",10]

{"sheet":"Graphs Table","index":7,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg","Return"]
["2015-01-01",10]
[{"$f":"A2+1","v":"2015-01-02"},15]
[{"$f":"A3+1","v":"2015-01-03"},12]
["2015-01-04",12]
["2015-01-05",11]
["2015-01-06",12]
["2015-01-07",10]
["2015-01-08",12]
["2015-01-09",13]
["2015-01-10",12]
["2015-01-11",11]
["2015-01-12",12]
["2015-01-13",12]
["2015-01-14",12]
["2015-01-15",10]

{"sheet":"GraphsCCL","index":8,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg","CCL",null,"Return"]
["2017-01-01",10]
[{"$f":"A2+1","v":"2017-01-02"},15]
[{"$f":"A3+1","v":"2017-01-03"},12,null,null,null,null,null,null,"Parameters","Label"]
["2017-01-04",12,null,null,"CCL Techniques",null,null,null,"Title","Test"]
["2017-01-05",11,null,null,"1. Draw by hand",null,null,null,"Y Axis label","# Beh"]
["2017-01-06",12,null,null,"2. Setup dummy series with scatter graph",null,null,null,"X Axis Label","Day"]
["2017-01-07",10,null,null,null,"1. Create Scatter graph",null,null,"CCL Min",0]
["2017-01-08",12,null,null,null,"2. Create CCL Column in table",null,null,"CCL Max",16]
["2017-01-09",13,null,null,null,"3. Create CCL series"]
["2017-01-10",12,null,null,null,null,"a. Select data"]
["2017-01-11",11,null,null,null,null,"b. \"Add\" button"]
["2017-01-12",12,null,null,null,null,"c. Name"]
["2017-01-13",12,null,null,null,null,"d. x axis value w/comma"]
["2017-01-14",12,null,null,null,null,"e. y axis value w/comma"]
["2017-01-15",13]
[]
[]
[null,null,null,null,"3. Error bars"]

{"sheet":"GraphsCCL1","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg","CCL","Label",null,"Return"]
["2015-01-01",10]
[{"$f":"A2+1","v":"2015-01-02"},15]
[{"$f":"A3+1","v":"2015-01-03"},12]
["2015-01-04",12]
["2015-01-05",11]
["2015-01-06",12]
["2015-01-07",10]
["2015-01-08",12]
["2015-01-09",13,16]
["2015-01-10",12]
["2015-01-11",11]
["2015-01-12",12]
["2015-01-13",12]
["2015-01-14",12]
["2015-01-15",10]

{"sheet":"Sheet1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data Validation","index":11,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Data Validation",null,"Return",null,null,null,"Bill","John","Beth","Yes","No"]
[null,"Names","Evals"]
[null,"John","No"]
[null,"Bill","Yes"]
[null,"Beth"]

{"sheet":"Tasks","index":12,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Data Table","Meetings","Return",null,null,null,null,null,"Holly","Anna","Neil","Complete","In Process"]
[]
[null,"Staff","Task","Status","Due","Done","Late","Not Done"]
[null,"Anna","Task 2","In Process","2017-10-01","2017-10-05",{"$f":"IF(Table18[[#This Row],[Done]]=\"\",\"\",Table18[[#This Row],[Done]]-Table18[[#This Row],[Due]])","v":4},{"$f":"IF(Table18[[#This Row],[Done]]=\"\",1,\"\")","v":""}]
[null,"Holly","Task 1","In Process","2017-09-01","2017-09-02",{"$f":"IF(Table18[[#This Row],[Done]]=\"\",\"\",Table18[[#This Row],[Done]]-Table18[[#This Row],[Due]])","v":1},{"$f":"IF(Table18[[#This Row],[Done]]=\"\",1,\"\")","v":""}]
[null,"Holly","Task 3","In Process","2017-10-05",null,{"$f":"IF(Table18[[#This Row],[Done]]=\"\",\"\",Table18[[#This Row],[Done]]-Table18[[#This Row],[Due]])","v":""},{"$f":"IF(Table18[[#This Row],[Done]]=\"\",1,\"\")","v":1}]
[null,"Neil","Task 4","In Process","2017-10-01",null,{"$f":"IF(Table18[[#This Row],[Done]]=\"\",\"\",Table18[[#This Row],[Done]]-Table18[[#This Row],[Due]])","v":""},{"$f":"IF(Table18[[#This Row],[Done]]=\"\",1,\"\")","v":1}]
[null,"Neil","Task 5","In Process","2017-10-15","2017-10-16",{"$f":"IF(Table18[[#This Row],[Done]]=\"\",\"\",Table18[[#This Row],[Done]]-Table18[[#This Row],[Due]])","v":1},{"$f":"IF(Table18[[#This Row],[Done]]=\"\",1,\"\")","v":""}]

{"sheet":"TaskSummary","index":13,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Data Table","Meetings","Return",null,null,null,null,null,"Holly","Anna","Neil","Complete","In Process"]
[]
[null,"Staff","Task","Status","Due","Done","Late","Not Done",null,"Staff","# Tasks Active"]
[null,"Anna","Task 2","In Process","2017-10-01","2017-10-05",{"$f":"IF(Table1[[#This Row],[Done]]=\"\",\"\",Table1[[#This Row],[Done]]-Table1[[#This Row],[Due]])","v":4},{"$f":"IF(Table1[[#This Row],[Done]]=\"\",1,\"\")","v":""},null,"Anna",0]
[null,"Holly","Task 1","In Process","2017-09-01","2017-09-02",{"$f":"IF(Table1[[#This Row],[Done]]=\"\",\"\",Table1[[#This Row],[Done]]-Table1[[#This Row],[Due]])","v":1},{"$f":"IF(Table1[[#This Row],[Done]]=\"\",1,\"\")","v":""},null,"Holly",1]
[null,"Holly","Task 3","In Process","2017-10-05",null,{"$f":"IF(Table1[[#This Row],[Done]]=\"\",\"\",Table1[[#This Row],[Done]]-Table1[[#This Row],[Due]])","v":""},{"$f":"IF(Table1[[#This Row],[Done]]=\"\",1,\"\")","v":1},null,"Neil",1]
[null,"Neil","Task 4","In Process","2017-10-01",null,{"$f":"IF(Table1[[#This Row],[Done]]=\"\",\"\",Table1[[#This Row],[Done]]-Table1[[#This Row],[Due]])","v":""},{"$f":"IF(Table1[[#This Row],[Done]]=\"\",1,\"\")","v":1}]
[null,"Neil","Task 5","In Process","2017-10-15","2017-10-16",{"$f":"IF(Table1[[#This Row],[Done]]=\"\",\"\",Table1[[#This Row],[Done]]-Table1[[#This Row],[Due]])","v":1},{"$f":"IF(Table1[[#This Row],[Done]]=\"\",1,\"\")","v":""}]
[]
[]
[null,"Pivot table "]
[null,"1. Select range"]
[null,"2. \"Insert\" menu"]
[null,"3. \"Pivot Table\""]
[null,"4. Select location"]
[null,"5. Enter fields"]
[null,"6. Edits:  Field list"]
[null,"7. Options: right click on Pivot Table Options"]

{"sheet":"CondFormat","index":14,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Cond Format 1",null,"Return"]
[4]
[]
["Cond Format 2"]
["text"]
[]
["Cond Format 3"]
["#","Time","Rate"]
[4,null,{"$f":"A9/B9","v":{"$error":"#DIV/0!"}}]
[3,null,{"$f":"A10/B10","v":{"$error":"#DIV/0!"}}]

{"sheet":"Staff Eval","index":15,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Return","           Staff Core Responsibility Evaluation"]
[]
["Name:  ","Linda Smith","Date:"]
[]
[null,null,"Review Period"]
[null,null,"2014-06-14",{"$f":"EDATE(C6,6)","v":"2014-12-14"},{"$f":"EDATE(D6,6)","v":"2015-06-14"},"2015-12-14","2016-06-14","2016-12-14","2017-06-14","2017-12-14","2018-06-14","2018-12-14"]
[1,"Displays thorough job knowledge."]
[{"$f":"A7+1","v":2},"Fosters Trust. Earns respect from others for high consistency between attitudes and behaviors."]
[3,"Develops and maintains effective working relationships with all staff members, clients, and families based on\nmutual respect."]
[4,"All interactions reflect respect for the diversity of Quest’s workforce, work environment, clients and customers."]
[5,"Demonstrates flexibility by doing what is required to provide extraordinary customer service to all internal and external customers."]
[6,"Follows procedures and communicated directions. Requires a minimum of supervision."]
[7,"Paperwork and documentation is accurate, legible and completed on time."]
[8,"Organizes, prioritizes, and delegates work effectively."]
[9,"Follows-up on tasks and assignments to assure successful completion."]
[10,"Identifies problems and demonstrates solid decision making skills."]
[11,"Shows initiative when problems or opportunities arise, and is action oriented."]
[12,"Continuously strives to add value to our services and improve our work processes."]
[13,"Requires reports are completed and distributed on or before the due date."]
[14,"Ensures compliance with all regulations."]
[15,"Participates in required training as specified by Quest guidelines."]
[16,"Effective liaison between Quest and identified outside resources/services."]
[]
[null,"Below, please list any core responsibilities that were not included."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rating",{"$f":"IF(COUNT(C7:C31)=0,NA(),AVERAGE(C7:C31))","v":{"$error":"#N/A"}},{"$f":"IF(COUNT(D7:D31)=0,NA(),AVERAGE(D7:D31))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["N/A","Not Applicable"]
[1,"Below job requirements"]
[2,"Requires additional training and/or development"]
[3,"Meets job requirements"]
[4,"Often exceeds job requirements"]
[5,"Consistently exceeds job requirements"]

{"sheet":"Rate Comp","index":16,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Date","# Agg","Time","Rate",null,"Return"]
["2015-01-01",10,2,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":5}]
[{"$f":"A2+1","v":"2015-01-02"},15,3,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":5}]
[{"$f":"A3+1","v":"2015-01-03"},12,1,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":12}]
["2015-01-04",12,3,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":4}]
["2015-01-05",11,5,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":2.2000000000000002}]
["2015-01-06",12,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-07",10,3,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":3.3333333333333335}]
["2015-01-08",12,4,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":3}]
["2015-01-09",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-10",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-11",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-12",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-13",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-14",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]
["2015-01-15",null,null,{"$f":"MyData5[[#This Row],['# Agg]]/MyData5[[#This Row],[Time]]","v":{"$error":"#DIV/0!"}}]