{"text_format":"1","workbook":"xls","n_sheets":14,"sheets":["Summary","Detail Total","Schedule 1-Part I ","Schedule 1-Part II","Schedule 1-Part III","Schedule 1 Part IV","Schedule 1-Part V","Schedule 1-Part VI","Schedule 1 Part VII","Edu. Coordinator Total","Edu. Coordinator Sal. 1","Edu. Coordinator Sal. 2","Edu. Coordinator Sal. 3","TIME SHEET"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":80,"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","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,9],[38,0,38,3],[38,6,38,9],[39,0,39,3],[39,6,39,9],[1,0,1,9],[2,0,2,9],[29,0,29,9],[30,0,35,9],[20,0,20,2],[27,0,27,9],[8,0,8,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[18,0,18,9]],"flags":["formulas_cached_only"]}
[]
["ENVIRONMENTAL DIVISION"]
["BEAUTIFICATION OFFICE"]
["SAMPLE COUNTY, TN"]
["LITTER GRANT PROGRAM COST ANALYSIS"]
["Fiscal Year July 1, 2009 Through June 30, 2010"]
[]
[]
["Section I-General Information"]
[]
["County:   ",null,null,null,null,null,"Department"]
["Address: "]
["               ",null,null,null,null,null,"Month",null,"Year"]
["                "]
["Preparer:",null,null,null,null,null,"Telephone:"]
["Email for Preparer",null,null,null,null,null,"Date:"]
[]
[]
["Section II-Financial Data Summary"]
[null,null,null,"Cost Analysis Amount",null,"Approved TDOT Litter Grant amount",null,"Year-To-Date Requested",null,"Monthly Invoice Amount Requested"]
["LITTER PROGRAM OPERATING COST:"]
["Direct Cost-Personnel (Schedule 1)",null,null,0,null,0,null,0,null,0]
["Direct Cost (Schedule 2)",null,null,0,null,0,null,0,null,0]
["Education Cost (Schedule 3)",null,null,0,null,0,null,0,null,0]
[null,"Net Operating Cost",null,0,null,0,null,0,null,0]
[]
[]
[]
[]
[" "]
["     This is to certify that, to the best of my knowledge and belief, the above data is accurate, complete, and current, and does not include any unallowable costs prohibited by the Rules and Regulations of the State of Tennessee Litter Grant Program.  The records of this agency are available for review by the authorized representative of the Comptroller of the Treasury or the Department of Transportation pursuant to Tennessee Code Annotated and the Rules and Regulations of the Tennessee Department of Transportation.  I understand that, while the total cost of the county's litter grant program may be greater then the TDOT litter grant fundng amount, that I will only request reimbursement for the amount budgeted in the approved grant application"]
[]
[]
[]
[]
[]
[]
[]
[]
["Signature ",null,null,null,null,null,"Date"]
[]
[1]

{"sheet":"Detail Total","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,7],[54,1,54,4],[54,5,54,6],[50,5,50,6],[50,1,50,4],[51,5,51,6],[52,1,52,4],[52,5,52,6],[51,1,51,4],[53,1,53,4],[53,5,53,6],[47,1,47,4],[47,5,47,6],[48,1,48,4],[48,5,48,6],[49,1,49,4],[49,5,49,6],[39,0,39,7],[40,0,40,7],[45,1,45,4],[45,5,45,6],[46,1,46,4],[46,5,46,6],[30,1,30,4],[31,1,31,4],[34,0,36,7],[30,5,30,6],[31,5,31,6],[27,1,27,4],[28,1,28,4],[29,1,29,4],[27,5,27,6],[29,5,29,6],[28,5,28,6],[26,5,26,6],[24,5,24,6],[25,5,25,6],[20,1,20,4],[22,1,22,4],[23,1,23,4],[26,1,26,4],[24,1,24,4],[25,1,25,4],[15,0,15,7],[19,5,19,6],[19,1,19,4],[21,1,21,4],[20,5,20,6],[23,5,23,6],[21,5,21,6],[22,5,22,6],[37,0,37,7],[0,0,0,7],[1,0,1,7],[2,1,2,3],[2,5,2,7],[3,1,3,3],[4,1,4,3],[14,0,14,7],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[11,1,11,3],[12,1,12,3],[9,1,9,3],[10,1,10,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL SUMMARY"]
[]
[105,"Superrvisor (Sch. 1  part I)",null,null,null,0]
[149,"Laborer (Sch. 1 part II)",null,null,null,0]
[149,"Laborer (Sch. 1 part III)",null,null,null,0]
[149,"Laborer (Sch. 1 part IV)",null,null,null,0]
[149,"Laborer (Sch. 1 part V)",null,null,null,0]
[169,"Part-Time Employee(Sch. 1 part VI)",null,null,null,0]
[169,"Part-Time Employee (Sch. 1 part VII)",null,null,null,0]
[]
[]
[null,"Total Direct Costs-Personnel",null,null,null,0]
[]
["Schedule 2"]
["Direct Cost"]
[]
[null,null,null,null,null,null,null,"Percentage"]
["Object",null,null,null,null,null,null,"Allocated"]
["Code","Type of Service",null,null,null,"Total Cost",null,"To Program","Monthly Cost "]
[null,"Equipment (under $5,000.00)*",null,null,null,0,null,0.25,0]
[null,"Vehicle Operational Cost (Repair, Services, Gas, Oil, Tires)",null,null,null,0,null,1,0]
[null,"Equipment/Rental",null,null,null,0,null,0.25,0]
[null,"Landfill",null,null,null,0,null,0.5,0]
[null,"Meals (Prisoner)",null,null,null,0,null,1,0]
[null,"Supplies (Litter Pickup & Safety)",null,null,null,0,null,0.5,0]
[null,"TDOT/KTNB Sponsored Training, Travel and Lodging",null,null,null,0,null,1,0]
[]
[]
[]
[]
[]
[]
[null,"Total Prorated Direct Costs",null,null,null,null,null,null,0]
[]
[]
[]
["Comments:"]
[]
["Schedule 3"]
["Education"]
[]
[]
[null,null,null,null,null,null,null,"Percentage"]
["Object",null,null,null,null,null,null,"Allocated"]
["Code","Type of Service",null,null,null,"Total Cost",null,"To Program","Monthly Cost "]
[null,"Education Coordinator Salary",null,null,null,0,null,1,0]
[null,"Communication",null,null,null,0,null,1,0]
[null,"Instructional Supplies",null,null,null,0,null,1,0]
[null,"Meetings and Events",null,null,null,0,null,0.5,0]
[null,"TDOT/KTNB Sponsored Training, Travel and Lodging",null,null,null,0,null,1,0]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Education Costs",null,null,null,null,null,null,0]
["Comment:"]
[null,null,null,2]

{"sheet":"Schedule 1-Part I ","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,1,6,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[27,1,27,3],[26,1,26,3],[18,1,18,3],[17,1,17,3],[16,1,16,3],[14,1,14,3],[28,0,28,4],[7,1,7,3],[15,1,15,3],[9,1,9,3],[13,1,13,3],[12,1,12,3],[11,1,11,3],[10,1,10,3],[8,1,8,3],[24,1,24,3],[25,1,25,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[19,1,19,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[105,"Supervisor - ",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
[3]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Schedule 1-Part II","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,1,12,3],[13,1,13,3],[14,1,14,3],[6,1,6,3],[7,1,7,3],[25,1,25,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[17,1,17,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[28,0,28,4],[21,1,21,3],[8,1,8,3],[15,1,15,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[27,1,27,3],[22,1,22,3],[23,1,23,3],[16,1,16,3],[26,1,26,3],[24,1,24,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[149,"Laborer-Billy Smith",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
[3]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Schedule 1-Part III","index":4,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,1,19,3],[28,0,28,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[26,1,26,3],[27,1,27,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[17,1,17,3],[18,1,18,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[6,1,6,3],[7,1,7,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[149,"Laborer-",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,10,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
[3]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Schedule 1 Part IV","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,1,19,3],[28,0,28,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[26,1,26,3],[27,1,27,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[17,1,17,3],[18,1,18,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[6,1,6,3],[7,1,7,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[149,"Laborer-",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
[3]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Schedule 1-Part V","index":6,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,3],[9,1,9,3],[10,1,10,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[6,1,6,3],[7,1,7,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[26,1,26,3],[27,1,27,3],[28,0,28,4],[23,1,23,3],[24,1,24,3],[25,1,25,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[160,"Guard- ",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,12,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
[3]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Schedule 1-Part VI","index":7,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,1,7,3],[6,1,6,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[8,1,8,3],[22,0,22,4],[19,1,19,3],[20,1,20,3],[17,1,17,3],[18,1,18,3],[16,1,16,3],[9,1,9,3],[10,1,10,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  PART-TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[169,"Part Time Educator-",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Monthly Cost for Part-time employee",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,20]
[]
[null,"Hourly Pay rate for employee",null,null,null,10]
[]
[3]

{"sheet":"Schedule 1 Part VII","index":8,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,0,22,4],[0,0,0,4],[1,0,1,4],[3,0,3,4],[17,1,17,3],[18,1,18,3],[14,1,14,3],[6,1,6,3],[7,1,7,3],[15,1,15,3],[16,1,16,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[8,1,8,3],[9,1,9,3],[10,1,10,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  PART-TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[169,"Part Time-",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Monthly Cost for Part-time employee",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Hourly Pay rate for employee",null,null,null,10]
[]
[3]

{"sheet":"Edu. Coordinator Total","index":9,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,1,2,3],[2,5,2,7],[3,1,3,3],[4,1,4,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[20,1,20,3],[21,1,21,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[23,0,23,7],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3]],"flags":["formulas_cached_only"]}
["Schedule 1"]
["DIRECT COSTS-EDUCATIONAL PERSONNEL SUMMARY"]
[]
[105,"Educator Coordinator ",null,null,null,0]
[149,"Educator Coordinator 2",null,null,null,0]
[169,"Part Time Educator Coordinator 3",null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Direct Costs-Personnel",null,null,null,0]
[]
[4]

{"sheet":"Edu. Coordinator Sal. 1","index":10,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[6,1,6,3],[7,1,7,3],[20,1,20,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[27,1,27,3],[28,0,28,4],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3]],"flags":["formulas_cached_only"]}
["Schedule 3"]
["Education-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[160,"Educator",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
["                                                             5"]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Edu. Coordinator Sal. 2","index":11,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,3],[0,0,0,4],[1,0,1,4],[3,0,3,4],[6,1,6,3],[7,1,7,3],[20,1,20,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[27,1,27,3],[28,0,28,4],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3]],"flags":["formulas_cached_only"]}
["Schedule 3"]
["Education-PERSONNEL"]
[]
["Part I:  FULL TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[160,"Educator",null,null,null,0]
[186,"Longevity Pay",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[204,"State Retirement",null,null,null,0]
[206,"Life Insurance",null,null,null,0]
[207,"Health Insurance",null,null,null,0]
[208,"Dental Insurance",null,null,null,0]
[210,"Unemployment Compensation",null,null,null,0]
[]
[null,"  Subtotal",null,null,null,0]
[]
[null,"Vacation  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Sick Time  (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[null,"Paid Holidays   (based on subtotal divided by 2080 hours times 8 hour workday)",null,null,0,0]
[]
[null,"Total Annual Employee Payroll Expense",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Total cost to county (for this employee) for work on Litter Program",null,null,null,0]
[]
["                                                   5"]
["Note:","Put number of annual days of vacation, sick and holidays earned in small, shaded cells"]

{"sheet":"Edu. Coordinator Sal. 3","index":12,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,4],[6,1,6,3],[7,1,7,3],[20,1,20,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[21,1,21,3],[22,0,22,4],[19,1,19,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3]],"flags":["formulas_cached_only"]}
["Schedule 3"]
["DIRECT COSTS-PERSONNEL"]
[]
["Part I:  PART-TIME PERSONNEL COSTS"]
[]
["Object"]
["Code","Title of Position",null,null,null,"Amount"]
[169,"Part Time Educator-",null,null,null,0]
[201,"Social Secuity",null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Monthly Cost for Part-time employee",null,null,null,0]
[]
[null,"Enter number of hours employee worked during month for litter program",null,null,null,0]
[]
[null,"Hourly Pay rate for employee",null,null,null,10]
[]
[5]

{"sheet":"TIME SHEET","index":13,"n_rows":32,"n_cols":33,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,1,4,31],[5,0,5,16]],"flags":["formulas_cached_only"]}
["LITTER GRANT PROGRAM"]
["MONTH:"]
["DATE:"]
["COUNTY:"]
["Employee Time Sheet","Dates",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,"Total"]
["EMPLOYEE NAMES: "]
["Program/Funding Source",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," Hours"]
["County ",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,0]
["Litter Grant  ",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,0]
["GhSO Grant",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,0]
["Annual Leave",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,0]
["Sick Leave",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,0]
["Holiday",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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
["Total:",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,0]
[]
["Supervisor Signature________________________________________"]
[]
["Employee Signature_________________________________________"]
[]
["County","01"]
["Litter Grant","02"]
["GHSO","03"]
["Annual Leave","04"]
["Sick Leave","05"]
["Holiday","06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]