{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Employee - Month 1","Employee - Month 2","Employee - Month 3","Employee - Quarter Total"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Employee - Month 1","index":0,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,27,0,34],[5,18,5,27],[5,9,5,17],[5,28,5,34],[3,32,3,34],[2,29,2,34],[1,27,1,34],[2,11,2,14],[3,11,3,14],[4,10,4,17],[4,7,4,9],[4,18,4,22],[4,23,4,34],[6,0,7,2],[4,2,4,6],[4,0,4,1],[5,4,5,8],[12,0,12,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[5,0,5,1],[5,2,5,3],[13,0,13,33],[14,0,14,33],[30,0,31,33],[20,0,20,33],[18,0,18,33],[19,0,19,33],[21,0,21,33],[25,0,26,33],[27,0,28,33]]}
["MONTHLY TIME AND EFFORT FORM FOR EMPLOYEES PERFORMING CALFRESH OUTREACH ACTIVITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB1:AI1","v":"CSU, Chico Research Foundation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB2:AI2","v":"Contract No: 16-SUB-00890"}]
[null,null,null,null,null,null,null,null,null,null,null,"Employee Time Base:",null,null,null,{"$f":"'Employee - Quarter Total'!P3","v":1},"(1.0 = Full Time)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C6","v":"October, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,"Work Days in Month:",null,null,null,22,"Include Holidays",null,null,null,null,null,null,null,null,null,"TOTAL BILLABLE HOURS:",null,null,null,null,null,{"$f":"AI13","v":0}]
["Employee Name: ",null,{"$f":"'Employee - Quarter Total'!C5:G5","v":0},null,null,null,null,"Employee Title: ",null,null,{"$f":"'Employee - Quarter Total'!K5:R5","v":0},null,null,null,null,null,null,null,"Organization Name: ",null,null,null,null,{"$f":"'Employee - Quarter Total'!X5:AI5","v":0}]
["Month: ",null,"October, 2020",null,"Total Hours in Month:",null,null,null,null,{"$f":"IF(OR(P3=0,P4=0),0.000000001,(P4*8*P3))","v":176},null,null,null,null,null,null,null,null,"Percentage of Work Month applied to CFO:",null,null,null,null,null,null,null,null,null,{"$f":"IF(J6=0,\"\",(AI9+AI11)/J6)","v":0}]
["Complete Lines 1, 2 and 4 Below",null,null,"Day of the Month"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Total"]
[1,"Hours Worked on CalFresh Outreach Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D9:AH9)","v":0}]
[2,"Paid Time Off                        (Total for day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:AH10)","v":0}]
[3,"Pro-rated PTO (will calculate automatically)",null,{"$f":"INT(D10*$AC$6)+CEILING((((D10*$AC$6)-INT(D10*$AC$6))*100),25)/100","v":0},{"$f":"INT(E10*$AC$6)+CEILING((((E10*$AC$6)-INT(E10*$AC$6))*100),25)/100","v":0},{"$f":"INT(F10*$AC$6)+CEILING((((F10*$AC$6)-INT(F10*$AC$6))*100),25)/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:AH11)","v":0}]
[4,"Specify (v) for vacation, (s) for sick, or (h) for holiday"]
["TOTAL BILLABLE HOURS ",null,null,{"$f":"ROUND(SUM(D9+D11),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:AH13)","v":0}]
[]
["Instructions"]
["1. Enter your name, your title, the name of your organization, and the month for which you are reporting hours."]
["2. Enter your employee time base. If you work full-time for your agency, but only part-time on CalFresh, you should still enter 1.0 as your employee time base."]
["3. Enter the number of work days in the current month. Include holidays, sick days and vacation days. Do not count weekends if they are not regular working days. A typical month will have about 22 working days, but months may differ."]
["4. Enter the amount of time spent performing CalFresh Outreach activities for that day (Line 1). Activities should include allowable activities only as detailed in your scope of work."]
["5. Time should be recorded in 15 minute increments, using decimals to record partial-hour increments (i.e., .25, .50, and .75) ."]
["6. The \"Total Hours\" box at the bottom of each column represents the total hours spent on CalFresh Outreach Activities each day.     "]
["7. The box at the bottom right corner represents all time spent on allowable activities for the month.  "]
["8. Sign and date your form on the last working day of the month and give it to your supervisor for signature. "]
["9. Paid time-off (e.g., vacation, sick leave, holiday time, etc.) should be recorded as the actual paid vacation, paid sick time or paid holiday time earned per the organization’s policies. The form will prorate this automatically based on the percentage of your time "]
["spent on CalFresh Outreach."]
["I certify that documented time represents only allowable activities as detailed in my scope of work. "]
[]
["Staff Signature (required)*_________________________________________________________  Date________________"]
[]
[]
["Supervisor Signature (required)*____________________________________________________  Date________________"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 12/22/2014"]

{"sheet":"Employee - Month 2","index":1,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,0,26,33],[27,0,28,33],[30,0,31,33],[13,0,13,33],[14,0,14,33],[18,0,18,33],[19,0,19,33],[20,0,20,33],[21,0,21,33],[12,0,12,2],[5,0,5,1],[5,2,5,3],[5,4,5,8],[5,9,5,17],[6,0,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[5,18,5,27],[5,28,5,34],[4,0,4,1],[4,2,4,6],[4,7,4,9],[4,10,4,17],[4,18,4,22],[4,23,4,34],[0,27,0,34],[1,27,1,34],[2,11,2,14],[2,29,2,34],[3,11,3,14],[3,32,3,34]]}
["MONTHLY TIME AND EFFORT FORM FOR EMPLOYEES PERFORMING CALFRESH OUTREACH ACTIVITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB1:AI1","v":"CSU, Chico Research Foundation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB2:AI2","v":"Contract No: 16-SUB-00890"}]
[null,null,null,null,null,null,null,null,null,null,null,"Employee Time Base:",null,null,null,{"$f":"'Employee - Quarter Total'!P3","v":1},"(1.0 = Full Time)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C6","v":"November, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,"Work Days in Month:",null,null,null,21,"Include Holidays",null,null,null,null,null,null,null,null,null,"TOTAL BILLABLE HOURS:",null,null,null,null,null,{"$f":"AI13","v":0}]
["Employee Name: ",null,{"$f":"'Employee - Quarter Total'!C5:G5","v":0},null,null,null,null,"Employee Title: ",null,null,{"$f":"'Employee - Quarter Total'!K5:R5","v":0},null,null,null,null,null,null,null,"Organization Name: ",null,null,null,null,{"$f":"'Employee - Quarter Total'!X5:AI5","v":0}]
["Month: ",null,"November, 2020",null,"Total Hours in Month:",null,null,null,null,{"$f":"IF(OR(P3=0,P4=0),0.000000001,(P4*8*P3))","v":168},null,null,null,null,null,null,null,null,"Percentage of Work Month applied to CFO:",null,null,null,null,null,null,null,null,null,{"$f":"IF(J6=0,\"\",(AI9+AI11)/J6)","v":0}]
["Complete Lines 1, 2 and 4 Below",null,null,"Day of the Month"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Total"]
[1,"Hours Worked on CalFresh Outreach Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D9:AH9)","v":0}]
[2,"Paid Time Off                        (Total for day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:AH10)","v":0}]
[3,"Pro-rated PTO (will calculate automatically)",null,{"$f":"INT(D10*$AC$6)+CEILING((((D10*$AC$6)-INT(D10*$AC$6))*100),25)/100","v":0},{"$f":"INT(E10*$AC$6)+CEILING((((E10*$AC$6)-INT(E10*$AC$6))*100),25)/100","v":0},{"$f":"INT(F10*$AC$6)+CEILING((((F10*$AC$6)-INT(F10*$AC$6))*100),25)/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:AH11)","v":0}]
[4,"Specify (v) for vacation, (s) for sick, or (h) for holiday"]
["TOTAL BILLABLE HOURS ",null,null,{"$f":"ROUND(SUM(D9+D11),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:AH13)","v":0}]
[]
["Instructions"]
["1. Enter your name, your title, the name of your organization, and the month for which you are reporting hours."]
["2. Enter your employee time base. If you work full-time for your agency, but only part-time on CalFresh, you should still enter 1.0 as your employee time base."]
["3. Enter the number of work days in the current month. Include holidays, sick days and vacation days. Do not count weekends if they are not regular working days. A typical month will have about 22 working days, but months may differ."]
["4. Enter the amount of time spent performing CalFresh Outreach activities for that day (Line 1). Activities should include allowable activities only as detailed in your scope of work."]
["5. Time should be recorded in 15 minute increments, using decimals to record partial-hour increments (i.e., .25, .50, and .75) ."]
["6. The \"Total Hours\" box at the bottom of each column represents the total hours spent on CalFresh Outreach Activities each day.     "]
["7. The box at the bottom right corner represents all time spent on allowable activities for the month.  "]
["8. Sign and date your form on the last working day of the month and give it to your supervisor for signature. "]
["9. Paid time-off (e.g., vacation, sick leave, holiday time, etc.) should be recorded as the actual paid vacation, paid sick time or paid holiday time earned per the organization’s policies. The form will prorate this automatically based on the percentage of your time "]
["spent on CalFresh Outreach."]
["I certify that documented time represents only allowable activities as detailed in my scope of work. "]
[]
["Staff Signature (required)*_________________________________________________________  Date________________"]
[]
[]
["Supervisor Signature (required)*____________________________________________________  Date________________"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 12/22/2014"]

{"sheet":"Employee - Month 3","index":2,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,0,26,33],[27,0,28,33],[30,0,31,33],[13,0,13,33],[14,0,14,33],[18,0,18,33],[19,0,19,33],[20,0,20,33],[21,0,21,33],[12,0,12,2],[5,0,5,1],[5,2,5,3],[5,4,5,8],[5,9,5,17],[6,0,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[5,18,5,27],[5,28,5,34],[4,0,4,1],[4,2,4,6],[4,7,4,9],[4,10,4,17],[4,18,4,22],[4,23,4,34],[0,27,0,34],[1,27,1,34],[2,11,2,14],[2,29,2,34],[3,11,3,14],[3,32,3,34]]}
["MONTHLY TIME AND EFFORT FORM FOR EMPLOYEES PERFORMING CALFRESH OUTREACH ACTIVITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB1:AI1","v":"CSU, Chico Research Foundation"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Employee - Quarter Total'!AB2:AI2","v":"Contract No: 16-SUB-00890"}]
[null,null,null,null,null,null,null,null,null,null,null,"Employee Time Base:",null,null,null,{"$f":"'Employee - Quarter Total'!P3","v":1},"(1.0 = Full Time)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C6","v":"December, 2020"}]
[null,null,null,null,null,null,null,null,null,null,null,"Work Days in Month:",null,null,null,23,"Include Holidays",null,null,null,null,null,null,null,null,null,"TOTAL BILLABLE HOURS:",null,null,null,null,null,{"$f":"AI13","v":0}]
["Employee Name: ",null,{"$f":"'Employee - Month 1'!C5:G5","v":0},null,null,null,null,"Employee Title: ",null,null,{"$f":"'Employee - Month 1'!K5:R5","v":0},null,null,null,null,null,null,null,"Organization Name: ",null,null,null,null,{"$f":"'Employee - Month 1'!X5:AI5","v":0}]
["Month: ",null,"December, 2020",null,"Total Hours in Month:",null,null,null,null,{"$f":"IF(OR(P3=0,P4=0),0.000000001,(P4*8*P3))","v":184},null,null,null,null,null,null,null,null,"Percentage of Work Month applied to CFO:",null,null,null,null,null,null,null,null,null,{"$f":"IF(J6=0,\"\",(AI9+AI11)/J6)","v":0}]
["Complete Lines 1, 2 and 4 Below",null,null,"Day of the Month"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Total"]
[1,"Hours Worked on CalFresh Outreach Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D9:AH9)","v":0}]
[2,"Paid Time Off                        (Total for day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:AH10)","v":0}]
[3,"Pro-rated PTO (will calculate automatically)",null,{"$f":"INT(D10*$AC$6)+CEILING((((D10*$AC$6)-INT(D10*$AC$6))*100),25)/100","v":0},{"$f":"INT(E10*$AC$6)+CEILING((((E10*$AC$6)-INT(E10*$AC$6))*100),25)/100","v":0},{"$f":"INT(F10*$AC$6)+CEILING((((F10*$AC$6)-INT(F10*$AC$6))*100),25)/100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:AH11)","v":0}]
[4,"Specify (v) for vacation, (s) for sick, or (h) for holiday"]
["TOTAL BILLABLE HOURS ",null,null,{"$f":"ROUND(SUM(D9+D11),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:AH13)","v":0}]
[]
["Instructions"]
["1. Enter your name, your title, the name of your organization, and the month for which you are reporting hours."]
["2. Enter your employee time base. If you work full-time for your agency, but only part-time on CalFresh, you should still enter 1.0 as your employee time base."]
["3. Enter the number of work days in the current month. Include holidays, sick days and vacation days. Do not count weekends if they are not regular working days. A typical month will have about 22 working days, but months may differ."]
["4. Enter the amount of time spent performing CalFresh Outreach activities for that day (Line 1). Activities should include allowable activities only as detailed in your scope of work."]
["5. Time should be recorded in 15 minute increments, using decimals to record partial-hour increments (i.e., .25, .50, and .75) ."]
["6. The \"Total Hours\" box at the bottom of each column represents the total hours spent on CalFresh Outreach Activities each day.     "]
["7. The box at the bottom right corner represents all time spent on allowable activities for the month.  "]
["8. Sign and date your form on the last working day of the month and give it to your supervisor for signature. "]
["9. Paid time-off (e.g., vacation, sick leave, holiday time, etc.) should be recorded as the actual paid vacation, paid sick time or paid holiday time earned per the organization’s policies. The form will prorate this automatically based on the percentage of your time "]
["spent on CalFresh Outreach."]
["I certify that documented time represents only allowable activities as detailed in my scope of work. "]
[]
["Staff Signature (required)*_________________________________________________________  Date________________"]
[]
[]
["Supervisor Signature (required)*____________________________________________________  Date________________"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 12/22/2014"]

{"sheet":"Employee - Quarter Total","index":3,"n_rows":35,"n_cols":35,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,0,26,33],[27,0,28,33],[30,0,31,33],[13,0,13,33],[14,0,14,33],[18,0,18,33],[19,0,19,33],[20,0,20,33],[21,0,21,33],[12,0,12,2],[5,0,5,1],[5,2,5,3],[5,4,5,8],[5,9,5,17],[6,0,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[5,18,5,27],[5,28,5,34],[4,0,4,1],[4,2,4,6],[4,7,4,9],[4,10,4,17],[4,18,4,22],[4,23,4,34],[0,27,0,34],[1,27,1,34],[2,11,2,14],[2,29,2,34],[3,11,3,14],[3,32,3,34]]}
["QUARTERLY TIME AND EFFORT FORM FOR EMPLOYEES PERFORMING CALFRESH OUTREACH ACTIVITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSU, Chico Research Foundation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contract No: 16-SUB-00890"]
[null,null,null,null,null,null,null,null,null,null,null,"Employee Time Base:",null,null,null,1,"(1.0 = Full Time)",null,null,null,null,null,null,null,null,null,null,null,null,"Quarter 1, FFY 2021"]
[null,null,null,null,null,null,null,null,null,null,null,"Work Days in Month:",null,null,null,{"$f":"'Employee - Month 1'!P4+'Employee - Month 2'!P4+'Employee - Month 3'!P4","v":66},"Include Holidays",null,null,null,null,null,null,null,null,null,"TOTAL BILLABLE HOURS:",null,null,null,null,null,{"$f":"AI13","v":0}]
["Employee Name: ",null,null,null,null,null,null,"Employee Title: ",null,null,null,null,null,null,null,null,null,null,"Organization Name: "]
["Timeframe:",null,{"$f":"AD3","v":"Quarter 1, FFY 2021"},null,"Total Hours in Month:",null,null,null,null,{"$f":"IF(OR(P3=0,P4=0),0.000000001,(P4*8*P3))","v":528},null,null,null,null,null,null,null,null,"Percentage of Work Month applied to CFO:",null,null,null,null,null,null,null,null,null,{"$f":"IF(J6=0,\"\",(AI9+AI11)/J6)","v":0}]
["Complete Lines 1, 2 and 4 Below",null,null,"Day of the Month"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Total"]
[1,"Hours Worked on CalFresh Outreach Activities",null,{"$f":"'Employee - Month 1'!D9+'Employee - Month 2'!D9+'Employee - Month 3'!D9","v":0},{"$f":"'Employee - Month 1'!E9+'Employee - Month 2'!E9+'Employee - Month 3'!E9","v":0},{"$f":"'Employee - Month 1'!F9+'Employee - Month 2'!F9+'Employee - Month 3'!F9","v":0},{"$f":"'Employee - Month 1'!G9+'Employee - Month 2'!G9+'Employee - Month 3'!G9","v":0},{"$f":"'Employee - Month 1'!H9+'Employee - Month 2'!H9+'Employee - Month 3'!H9","v":0},{"$f":"'Employee - Month 1'!I9+'Employee - Month 2'!I9+'Employee - Month 3'!I9","v":0},{"$f":"'Employee - Month 1'!J9+'Employee - Month 2'!J9+'Employee - Month 3'!J9","v":0},{"$f":"'Employee - Month 1'!K9+'Employee - Month 2'!K9+'Employee - Month 3'!K9","v":0},{"$f":"'Employee - Month 1'!L9+'Employee - Month 2'!L9+'Employee - Month 3'!L9","v":0},{"$f":"'Employee - Month 1'!M9+'Employee - Month 2'!M9+'Employee - Month 3'!M9","v":0},{"$f":"'Employee - Month 1'!N9+'Employee - Month 2'!N9+'Employee - Month 3'!N9","v":0},{"$f":"'Employee - Month 1'!O9+'Employee - Month 2'!O9+'Employee - Month 3'!O9","v":0},{"$f":"'Employee - Month 1'!P9+'Employee - Month 2'!P9+'Employee - Month 3'!P9","v":0},{"$f":"'Employee - Month 1'!Q9+'Employee - Month 2'!Q9+'Employee - Month 3'!Q9","v":0},{"$f":"'Employee - Month 1'!R9+'Employee - Month 2'!R9+'Employee - Month 3'!R9","v":0},{"$f":"'Employee - Month 1'!S9+'Employee - Month 2'!S9+'Employee - Month 3'!S9","v":0},{"$f":"'Employee - Month 1'!T9+'Employee - Month 2'!T9+'Employee - Month 3'!T9","v":0},{"$f":"'Employee - Month 1'!U9+'Employee - Month 2'!U9+'Employee - Month 3'!U9","v":0},{"$f":"'Employee - Month 1'!V9+'Employee - Month 2'!V9+'Employee - Month 3'!V9","v":0},{"$f":"'Employee - Month 1'!W9+'Employee - Month 2'!W9+'Employee - Month 3'!W9","v":0},{"$f":"'Employee - Month 1'!X9+'Employee - Month 2'!X9+'Employee - Month 3'!X9","v":0},{"$f":"'Employee - Month 1'!Y9+'Employee - Month 2'!Y9+'Employee - Month 3'!Y9","v":0},{"$f":"'Employee - Month 1'!Z9+'Employee - Month 2'!Z9+'Employee - Month 3'!Z9","v":0},{"$f":"'Employee - Month 1'!AA9+'Employee - Month 2'!AA9+'Employee - Month 3'!AA9","v":0},{"$f":"'Employee - Month 1'!AB9+'Employee - Month 2'!AB9+'Employee - Month 3'!AB9","v":0},{"$f":"'Employee - Month 1'!AC9+'Employee - Month 2'!AC9+'Employee - Month 3'!AC9","v":0},{"$f":"'Employee - Month 1'!AD9+'Employee - Month 2'!AD9+'Employee - Month 3'!AD9","v":0},{"$f":"'Employee - Month 1'!AE9+'Employee - Month 2'!AE9+'Employee - Month 3'!AE9","v":0},{"$f":"'Employee - Month 1'!AF9+'Employee - Month 2'!AF9+'Employee - Month 3'!AF9","v":0},{"$f":"'Employee - Month 1'!AG9+'Employee - Month 2'!AG9+'Employee - Month 3'!AG9","v":0},{"$f":"'Employee - Month 1'!AH9+'Employee - Month 2'!AH9+'Employee - Month 3'!AH9","v":0},{"$f":"SUM(D9:AH9)","v":0}]
[2,"Paid Time Off                        (Total for day)",null,{"$f":"'Employee - Month 1'!D10+'Employee - Month 2'!D10+'Employee - Month 3'!D10","v":0},{"$f":"'Employee - Month 1'!E10+'Employee - Month 2'!E10+'Employee - Month 3'!E10","v":0},{"$f":"'Employee - Month 1'!F10+'Employee - Month 2'!F10+'Employee - Month 3'!F10","v":0},{"$f":"'Employee - Month 1'!G10+'Employee - Month 2'!G10+'Employee - Month 3'!G10","v":0},{"$f":"'Employee - Month 1'!H10+'Employee - Month 2'!H10+'Employee - Month 3'!H10","v":0},{"$f":"'Employee - Month 1'!I10+'Employee - Month 2'!I10+'Employee - Month 3'!I10","v":0},{"$f":"'Employee - Month 1'!J10+'Employee - Month 2'!J10+'Employee - Month 3'!J10","v":0},{"$f":"'Employee - Month 1'!K10+'Employee - Month 2'!K10+'Employee - Month 3'!K10","v":0},{"$f":"'Employee - Month 1'!L10+'Employee - Month 2'!L10+'Employee - Month 3'!L10","v":0},{"$f":"'Employee - Month 1'!M10+'Employee - Month 2'!M10+'Employee - Month 3'!M10","v":0},{"$f":"'Employee - Month 1'!N10+'Employee - Month 2'!N10+'Employee - Month 3'!N10","v":0},{"$f":"'Employee - Month 1'!O10+'Employee - Month 2'!O10+'Employee - Month 3'!O10","v":0},{"$f":"'Employee - Month 1'!P10+'Employee - Month 2'!P10+'Employee - Month 3'!P10","v":0},{"$f":"'Employee - Month 1'!Q10+'Employee - Month 2'!Q10+'Employee - Month 3'!Q10","v":0},{"$f":"'Employee - Month 1'!R10+'Employee - Month 2'!R10+'Employee - Month 3'!R10","v":0},{"$f":"'Employee - Month 1'!S10+'Employee - Month 2'!S10+'Employee - Month 3'!S10","v":0},{"$f":"'Employee - Month 1'!T10+'Employee - Month 2'!T10+'Employee - Month 3'!T10","v":0},{"$f":"'Employee - Month 1'!U10+'Employee - Month 2'!U10+'Employee - Month 3'!U10","v":0},{"$f":"'Employee - Month 1'!V10+'Employee - Month 2'!V10+'Employee - Month 3'!V10","v":0},{"$f":"'Employee - Month 1'!W10+'Employee - Month 2'!W10+'Employee - Month 3'!W10","v":0},{"$f":"'Employee - Month 1'!X10+'Employee - Month 2'!X10+'Employee - Month 3'!X10","v":0},{"$f":"'Employee - Month 1'!Y10+'Employee - Month 2'!Y10+'Employee - Month 3'!Y10","v":0},{"$f":"'Employee - Month 1'!Z10+'Employee - Month 2'!Z10+'Employee - Month 3'!Z10","v":0},{"$f":"'Employee - Month 1'!AA10+'Employee - Month 2'!AA10+'Employee - Month 3'!AA10","v":0},{"$f":"'Employee - Month 1'!AB10+'Employee - Month 2'!AB10+'Employee - Month 3'!AB10","v":0},{"$f":"'Employee - Month 1'!AC10+'Employee - Month 2'!AC10+'Employee - Month 3'!AC10","v":0},{"$f":"'Employee - Month 1'!AD10+'Employee - Month 2'!AD10+'Employee - Month 3'!AD10","v":0},{"$f":"'Employee - Month 1'!AE10+'Employee - Month 2'!AE10+'Employee - Month 3'!AE10","v":0},{"$f":"'Employee - Month 1'!AF10+'Employee - Month 2'!AF10+'Employee - Month 3'!AF10","v":0},{"$f":"'Employee - Month 1'!AG10+'Employee - Month 2'!AG10+'Employee - Month 3'!AG10","v":0},{"$f":"'Employee - Month 1'!AH10+'Employee - Month 2'!AH10+'Employee - Month 3'!AH10","v":0},{"$f":"SUM(D10:AH10)","v":0}]
[3,"Pro-rated PTO (will calculate automatically)",null,{"$f":"IF((INT(D10*$AC$6)+CEILING((((D10*$AC$6)-INT(D10*$AC$6))*100),25)/100)>D10,D10,INT(D10*$AC$6)+CEILING((((D10*$AC$6)-INT(D10*$AC$6))*100),25)/100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D11:AH11)","v":0}]
[4,"Specify (v) for vacation, (s) for sick, or (h) for holiday"]
["TOTAL BILLABLE HOURS ",null,null,{"$f":"ROUND(SUM(D9+D11),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:AH13)","v":0}]
[]
["Instructions"]
["1. Enter your name, your title, the name of your organization, and the month for which you are reporting hours."]
["2. Enter your employee time base. If you work full-time for your agency, but only part-time on CalFresh, you should still enter 1.0 as your employee time base."]
["3. Enter the number of work days in the current month. Include holidays, sick days and vacation days. Do not count weekends if they are not regular working days. A typical month will have about 22 working days, but months may differ."]
["4. Enter the amount of time spent performing CalFresh Outreach activities for that day (Line 1). Activities should include allowable activities only as detailed in your scope of work."]
["5. Time should be recorded in 15 minute increments, using decimals to record partial-hour increments (i.e., .25, .50, and .75) ."]
["6. The \"Total Hours\" box at the bottom of each column represents the total hours spent on CalFresh Outreach Activities each day.     "]
["7. The box at the bottom right corner represents all time spent on allowable activities for the month.  "]
["8. Sign and date your form on the last working day of the month and give it to your supervisor for signature. "]
["9. Paid time-off (e.g., vacation, sick leave, holiday time, etc.) should be recorded as the actual paid vacation, paid sick time or paid holiday time earned per the organization’s policies. The form will prorate this automatically based on the percentage of your time "]
["spent on CalFresh Outreach."]
["I certify that documented time represents only allowable activities as detailed in my scope of work. "]
[]
["Staff Signature (required)*_________________________________________________________  Date________________"]
[]
[]
["Supervisor Signature (required)*____________________________________________________  Date________________"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated 12/22/2014"]