{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Example","Mon","Tues","Wed","Thurs","Fri","Charts"],"not_rendered":{"charts":1,"images":3},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[30,0,30,3]]}
[]
[]
[]
[]
[]
["Purpose"]
["This template provides a snapshot of how school counselors spend their time in each of the components of the ASCA National Model."]
["ASCA recommends school counselors spend at least 80% of their time in direct and indirect services to students."]
[]
["Implementation Notes"]
["1. Complete the use-of-time calculator for one week (five consecutive days) in first semester and second semester of the academic year. "]
["2. Choose a week that involves a variety of activities and is free of predictable disruptions (e.g., special schedules, school holidays, planned absence for a medical absence)."]
["3. Ensure the activities/tasks identified are coded per the ASCA definition for direct services, indirect services, program planning, school support (fair share), and non-school counseling duties. "]
["4. Share use-of-time analysis with administration during the annual administrative conference."]
["5. Make decisions about specific time allocation in collaboration with administrator. "]
["Recommendation: 80% of time or more is spent in direct and indirect student services."]
["Recommendation: 20% of time or less is set aside for program planning, school support and fair-share activities."]
[]
["Directions"]
["1. Enter your activity for the corresponding contracted work time and day of the week. Provide enough details so how your time is spent is clear. "]
["2. If you did more than one activity in a 15-minute timeframe, record the activity where you spent the majority of time."]
["3. In the columns next to each activity, check the category that aligns with your activity. Do not mark more than one category. "]
["4. If you take a duty-free lunch break or any other duty-free break, do not check any category for this time. "]
["5. Do not use any other mark in the columns."]
["6. The spreadsheet will count your activities each day and calculate percent of time in each category. "]
["7. The spreadsheet will also calculate your percent of time for the week and will report that data in the \"Charts\" tab. "]
["8. The \"Example\" tab displays how one day will look after entering activities and checking the designate category."]
["9. Because there are formulas in the spreadsheets, do not alter any part of the Use-of-Time Calculator in any way. "]
[]
[]
["Updated Aug 25"]

{"sheet":"Example","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: ",null,"Jordan Counselor"]
[null,null,"Date (M/D/Y):      ",null,"2025-09-12"]
[null,null,"Contract start/end time",null,"7 a.m - 3 p.m. "]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.","conduct parent conference gr 6 (LS)",false,true,false,false,false]
["7:16-7:30 a.m.","conduct parent conference gr 6 (LS)",false,true,false,false,false]
["7:31-7:45 a.m.","data collection small group",false,false,true,false,false]
["7:46-8 a.m.","data collection small group",false,false,true,false,false]
["8:01-8:15 a.m.","data collection small group",false,false,true,false,false]
["8:16-8:30 a.m.","teach 5th grade career lesson (Smith)",true,false,false,false,false]
["8:31-8:45 a.m.","teach 5th grade career lesson (Smith)",true,false,false,false,false]
["8:46-9 a.m.","teach 5th grade career lesson (Smith)",true,false,false,false,false]
["9:01-9:15 a.m.","teach 5th grade career lesson (Jones)",true,false,false,false,false]
["9:16-9:30 a.m.","teach 5th grade career lesson (Jones)",true,false,false,false,false]
["9:31-9:45 a.m.","teach 5th grade career lesson (Jones)",true,false,false,false,false]
["9:46-10 a.m.","goal check w student (TR) 2nd gr",true,false,false,false,false]
["10:01-10:15 a.m.","goal check w student (TR) 2nd gr",true,false,false,false,false]
["10:16-10:30 a.m.","K lunch duty ",false,false,false,false,true]
["10:31-10:45 a.m.","K lunch duty ",false,false,false,false,true]
["10:46-11 a.m.","K lunch duty ",false,false,false,false,true]
["11:01-11:15 a.m.","Personal lunch",false,false,false,false,false]
["11:16-11:30 a.m.","Personal lunch",false,false,false,false,false]
["11:31-11:45 a.m.","teach 8th grade career lesson (Johnson)",true,false,false,false,false]
["11:45 a.m.-Noon","teach 8th grade career lesson (Johnson)",true,false,false,false,false]
["12:01-12:15 p.m.","teach 8th grade career lesson (Johnson)",true,false,false,false,false]
["12:16-12:30 p.m.","counseling w student (AC) 7th gr, family issue",true,false,false,false,false]
["12:31-12:45 p.m.","counseling w student (AC) 7th gr, family issue",true,false,false,false,false]
["12:46-1 p.m.","3rd gr study skills small group",true,false,false,false,false]
["1:01-1:15 p.m.","4th gr study skills small group",true,false,false,false,false]
["1:16-1:30 p.m.","5th gr study skills small group",true,false,false,false,false]
["1:31-1:45 p.m.","attend parent/teacher conference gr 3 (DW)",false,true,false,false,false]
["1:46-2 p.m.","attend parent/teacher conference gr 3 (DW)",false,true,false,false,false]
["2:01-2:15 p.m.","attend parent/teacher conference gr 3 (DW)",false,true,false,false,false]
["2:16-2:30 p.m.","Email check - school/district matters",false,false,false,true,false]
["2:31-2:45 p.m.","Email responses - teachers concerns/questions",false,true,false,false,false]
["2:46-3 p.m.","Car duty",false,false,false,true,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":16},{"$f":"COUNTIF(D6:D45,\"true\")","v":6},{"$f":"COUNTIF(E6:E45,\"true\")","v":3},{"$f":"COUNTIF(F6:F45,\"true\")","v":2},{"$f":"COUNTIF(G6:G45,\"true\")","v":3}]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":{"v":0.5333333333333333,"d":"53%"}},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.06666666666666667,"d":"7%"},{"v":0.1,"d":"10%"},{"$f":"SUM(C47:G47)","v":{"v":1,"d":"100%"}}]
[]
[]
[{"$nulls":5},"Updated 8 25"]

{"sheet":"Mon","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: "]
[null,null,"Date (M/D/Y):      "]
[null,null,"Contract start/end time"]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task ","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.",null,false,false,false,false,false]
["7:16-7:30 a.m.",null,false,false,false,false,false]
["7:31-7:45 a.m.",null,false,false,false,false,false]
["7:46-8 a.m.",null,false,false,false,false,false]
["8:01-8:15 a.m.",null,false,false,false,false,false]
["8:16-8:30 a.m.",null,false,false,false,false,false]
["8:31-8:45 a.m.",null,false,false,false,false,false]
["8:46-9 a.m.",null,false,false,false,false,false]
["9:01-9:15 a.m.",null,false,false,false,false,false]
["9:16-9:30 a.m.",null,false,false,false,false,false]
["9:31-9:45 a.m.",null,false,false,false,false,false]
["9:46-10 a.m.",null,false,false,false,false,false]
["10:01-10:15 a.m.",null,false,false,false,false,false]
["10:16-10:30 a.m.",null,false,false,false,false,false]
["10:31-10:45 a.m.",null,false,false,false,false,false]
["10:46-11 a.m.",null,false,false,false,false,false]
["11:01-11:15 a.m.",null,false,false,false,false,false]
["11:16-11:30 a.m.",null,false,false,false,false,false]
["11:31-11:45 a.m.",null,false,false,false,false,false]
["11:45 a.m.-Noon",null,false,false,false,false,false]
["12:01-12:15 p.m.",null,false,false,false,false,false]
["12:16-12:30 p.m.",null,false,false,false,false,false]
["12:31-12:45 p.m.",null,false,false,false,false,false]
["12:46-1 p.m.",null,false,false,false,false,false]
["1:01-1:15 p.m.",null,false,false,false,false,false]
["1:16-1:30 p.m.",null,false,false,false,false,false]
["1:31-1:45 p.m.",null,false,false,false,false,false]
["1:46-2 p.m.",null,false,false,false,false,false]
["2:01-2:15 p.m.",null,false,false,false,false,false]
["2:16-2:30 p.m.",null,false,false,false,false,false]
["2:31-2:45 p.m.",null,false,false,false,false,false]
["2:46-3 p.m.",null,false,false,false,false,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":0},0,0,0,0]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":""},"","","","",{"$f":"SUM(C47:G47)","v":{"v":0,"d":"0%"}}]

{"sheet":"Tues","index":3,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: "]
[null,null,"Date (M/D/Y):      "]
[null,null,"Contract start/end time"]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.",null,false,false,false,false,false]
["7:16-7:30 a.m.",null,false,false,false,false,false]
["7:31-7:45 a.m.",null,false,false,false,false,false]
["7:46-8 a.m.",null,false,false,false,false,false]
["8:01-8:15 a.m.",null,false,false,false,false,false]
["8:16-8:30 a.m.",null,false,false,false,false,false]
["8:31-8:45 a.m.",null,false,false,false,false,false]
["8:46-9 a.m.",null,false,false,false,false,false]
["9:01-9:15 a.m.",null,false,false,false,false,false]
["9:16-9:30 a.m.",null,false,false,false,false,false]
["9:31-9:45 a.m.",null,false,false,false,false,false]
["9:46-10 a.m.",null,false,false,false,false,false]
["10:01-10:15 a.m.",null,false,false,false,false,false]
["10:16-10:30 a.m.",null,false,false,false,false,false]
["10:31-10:45 a.m.",null,false,false,false,false,false]
["10:46-11 a.m.",null,false,false,false,false,false]
["11:01-11:15 a.m.",null,false,false,false,false,false]
["11:16-11:30 a.m.",null,false,false,false,false,false]
["11:31-11:45 a.m.",null,false,false,false,false,false]
["11:45 a.m.-Noon",null,false,false,false,false,false]
["12:01-12:15 p.m.",null,false,false,false,false,false]
["12:16-12:30 p.m.",null,false,false,false,false,false]
["12:31-12:45 p.m.",null,false,false,false,false,false]
["12:46-1 p.m.",null,false,false,false,false,false]
["1:01-1:15 p.m.",null,false,false,false,false,false]
["1:16-1:30 p.m.",null,false,false,false,false,false]
["1:31-1:45 p.m.",null,false,false,false,false,false]
["1:46-2 p.m.",null,false,false,false,false,false]
["2:01-2:15 p.m.",null,false,false,false,false,false]
["2:16-2:30 p.m.",null,false,false,false,false,false]
["2:31-2:45 p.m.",null,false,false,false,false,false]
["2:46-3 p.m.",null,false,false,false,false,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":0},0,0,0,0]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":""},"","","","",{"$f":"SUM(C47:G47)","v":{"v":0,"d":"0%"}}]

{"sheet":"Wed","index":4,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: "]
[null,null,"Date (M/D/Y):      "]
[null,null,"Contract start/end time"]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.",null,false,false,false,false,false]
["7:16-7:30 a.m.",null,false,false,false,false,false]
["7:31-7:45 a.m.",null,false,false,false,false,false]
["7:46-8 a.m.",null,false,false,false,false,false]
["8:01-8:15 a.m.",null,false,false,false,false,false]
["8:16-8:30 a.m.",null,false,false,false,false,false]
["8:31-8:45 a.m.",null,false,false,false,false,false]
["8:46-9 a.m.",null,false,false,false,false,false]
["9:01-9:15 a.m.",null,false,false,false,false,false]
["9:16-9:30 a.m.",null,false,false,false,false,false]
["9:31-9:45 a.m.",null,false,false,false,false,false]
["9:46-10 a.m.",null,false,false,false,false,false]
["10:01-10:15 a.m.",null,false,false,false,false,false]
["10:16-10:30 a.m.",null,false,false,false,false,false]
["10:31-10:45 a.m.",null,false,false,false,false,false]
["10:46-11 a.m.",null,false,false,false,false,false]
["11:01-11:15 a.m.",null,false,false,false,false,false]
["11:16-11:30 a.m.",null,false,false,false,false,false]
["11:31-11:45 a.m.",null,false,false,false,false,false]
["11:45 a.m.-Noon",null,false,false,false,false,false]
["12:01-12:15 p.m.",null,false,false,false,false,false]
["12:16-12:30 p.m.",null,false,false,false,false,false]
["12:31-12:45 p.m.",null,false,false,false,false,false]
["12:46-1 p.m.",null,false,false,false,false,false]
["1:01-1:15 p.m.",null,false,false,false,false,false]
["1:16-1:30 p.m.",null,false,false,false,false,false]
["1:31-1:45 p.m.",null,false,false,false,false,false]
["1:46-2 p.m.",null,false,false,false,false,false]
["2:01-2:15 p.m.",null,false,false,false,false,false]
["2:16-2:30 p.m.",null,false,false,false,false,false]
["2:31-2:45 p.m.",null,false,false,false,false,false]
["2:46-3 p.m.",null,false,false,false,false,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":0},0,0,0,0]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":""},"","","","",{"$f":"SUM(C47:G47)","v":{"v":0,"d":"0%"}}]

{"sheet":"Thurs","index":5,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: "]
[null,null,"Date (M/D/Y):      "]
[null,null,"Contract start/end time"]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.",null,false,false,false,false,false]
["7:16-7:30 a.m.",null,false,false,false,false,false]
["7:31-7:45 a.m.",null,false,false,false,false,false]
["7:46-8 a.m.",null,false,false,false,false,false]
["8:01-8:15 a.m.",null,false,false,false,false,false]
["8:16-8:30 a.m.",null,false,false,false,false,false]
["8:31-8:45 a.m.",null,false,false,false,false,false]
["8:46-9 a.m.",null,false,false,false,false,false]
["9:01-9:15 a.m.",null,false,false,false,false,false]
["9:16-9:30 a.m.",null,false,false,false,false,false]
["9:31-9:45 a.m.",null,false,false,false,false,false]
["9:46-10 a.m.",null,false,false,false,false,false]
["10:01-10:15 a.m.",null,false,false,false,false,false]
["10:16-10:30 a.m.",null,false,false,false,false,false]
["10:31-10:45 a.m.",null,false,false,false,false,false]
["10:46-11 a.m.",null,false,false,false,false,false]
["11:01-11:15 a.m.",null,false,false,false,false,false]
["11:16-11:30 a.m.",null,false,false,false,false,false]
["11:31-11:45 a.m.",null,false,false,false,false,false]
["11:45 a.m.-Noon",null,false,false,false,false,false]
["12:01-12:15 p.m.",null,false,false,false,false,false]
["12:16-12:30 p.m.",null,false,false,false,false,false]
["12:31-12:45 p.m.",null,false,false,false,false,false]
["12:46-1 p.m.",null,false,false,false,false,false]
["1:01-1:15 p.m.",null,false,false,false,false,false]
["1:16-1:30 p.m.",null,false,false,false,false,false]
["1:31-1:45 p.m.",null,false,false,false,false,false]
["1:46-2 p.m.",null,false,false,false,false,false]
["2:01-2:15 p.m.",null,false,false,false,false,false]
["2:16-2:30 p.m.",null,false,false,false,false,false]
["2:31-2:45 p.m.",null,false,false,false,false,false]
["2:46-3 p.m.",null,false,false,false,false,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":0},0,0,0,0]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":""},"","","","",{"$f":"SUM(C47:G47)","v":{"v":0,"d":"0%"}}]

{"sheet":"Fri","index":6,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,0,3,1],[0,2,0,3],[0,4,0,6],[1,2,1,3],[1,4,1,6],[2,2,2,3],[2,4,2,6]]}
[null,null,"School Counselor Name: "]
[null,null,"Date (M/D/Y):      "]
[null,null,"Contract start/end time"]
[null,null,"Direct Student Services","Indirect Student Services","Program Planning ","School Support","Non-School-Counseling Tasks"]
["Time frame","Activity or Task","Instruction, Appraisal & Advisement, Counseling","Referrals, Consultation, Collaboration","Defining, Managing, Assessing Activities","Fair-Share Responsibility Activities","﻿Non-School-\nCounseling \nTasks"]
["7-7:15 a.m.",null,false,false,false,false,false]
["7:16-7:30 a.m.",null,false,false,false,false,false]
["7:31-7:45 a.m.",null,false,false,false,false,false]
["7:46-8 a.m.",null,false,false,false,false,false]
["8:01-8:15 a.m.",null,false,false,false,false,false]
["8:16-8:30 a.m.",null,false,false,false,false,false]
["8:31-8:45 a.m.",null,false,false,false,false,false]
["8:46-9 a.m.",null,false,false,false,false,false]
["9:01-9:15 a.m.",null,false,false,false,false,false]
["9:16-9:30 a.m.",null,false,false,false,false,false]
["9:31-9:45 a.m.",null,false,false,false,false,false]
["9:46-10 a.m.",null,false,false,false,false,false]
["10:01-10:15 a.m.",null,false,false,false,false,false]
["10:16-10:30 a.m.",null,false,false,false,false,false]
["10:31-10:45 a.m.",null,false,false,false,false,false]
["10:46-11 a.m.",null,false,false,false,false,false]
["11:01-11:15 a.m.",null,false,false,false,false,false]
["11:16-11:30 a.m.",null,false,false,false,false,false]
["11:31-11:45 a.m.",null,false,false,false,false,false]
["11:45 a.m.-Noon",null,false,false,false,false,false]
["12:01-12:15 p.m.",null,false,false,false,false,false]
["12:16-12:30 p.m.",null,false,false,false,false,false]
["12:31-12:45 p.m.",null,false,false,false,false,false]
["12:46-1 p.m.",null,false,false,false,false,false]
["1:01-1:15 p.m.",null,false,false,false,false,false]
["1:16-1:30 p.m.",null,false,false,false,false,false]
["1:31-1:45 p.m.",null,false,false,false,false,false]
["1:46-2 p.m.",null,false,false,false,false,false]
["2:01-2:15 p.m.",null,false,false,false,false,false]
["2:16-2:30 p.m.",null,false,false,false,false,false]
["2:31-2:45 p.m.",null,false,false,false,false,false]
["2:46-3 p.m.",null,false,false,false,false,false]
["3:01-3:15 p.m.",null,false,false,false,false,false]
["3:16-3:30 p.m.",null,false,false,false,false,false]
["3:31-3:45 p.m.",null,false,false,false,false,false]
["3:46-4 p.m.",null,false,false,false,false,false]
["4:01-4:15 p.m.",null,false,false,false,false,false]
["4:16-4:30 p.m.",null,false,false,false,false,false]
["4:31-4:45 p.m.",null,false,false,false,false,false]
["4:46-5:00 p.m.",null,false,false,false,false,false]
["TOTALS",null,{"$f":"COUNTIF(C6:C45,\"true\")","v":0},0,0,0,0]
["% per category",null,{"$f":"IF(C46>0,C46/SUM($C$46:$G$46),\"\")","v":""},"","","","",{"$f":"SUM(C47:G47)","v":{"v":0,"d":"0%"}}]

{"sheet":"Charts","index":7,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[1,0,1,1]]}
[]
["Category"]
{"$rows_empty":26}
[{"$nulls":4},{"$f":"Mon!C46+Tues!C46+Wed!C46+Thurs!C46+Fri!C46","v":0},{"$f":"Mon!D46+Tues!D46+Wed!D46+Thurs!D46+Fri!D46","v":0},{"$f":"Mon!E46+Tues!E46+Wed!E46+Thurs!E46+Fri!E46","v":0},{"$f":"Mon!F46+Tues!F46+Wed!F46+Thurs!F46+Fri!F46","v":0},{"$f":"Mon!G46+Tues!G46+Wed!G46+Thurs!G46+Fri!G46","v":0}]
[{"$nulls":4},"Direct Student Services","Indirect Student Services","Program Planning","School Support (Fair Share)","Non-School-Counseling Tasks"]
[{"$nulls":4},{"$f":"IF(E29>0,E29/SUM($D$29:$J$29),\"\")","v":""},"","","","",{"$f":"SUM(E31:I31)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":10},"Updated 8 25 "]