{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["2023 Salary Supplement Roster","TOTAL TIME OF SERVICE TOOL "],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"2023 Salary Supplement Roster","index":0,"n_rows":50,"n_cols":26,"rows_kept":50,"cut":false,"hidden":false,"merged":[[8,10,8,11],[7,10,7,12],[6,2,6,5],[6,10,6,12],[4,1,5,1],[4,2,5,3],[4,4,4,6],[5,4,5,6],[7,2,7,5],[4,10,4,12],[5,10,5,12],[3,10,3,12],[1,1,1,2],[2,1,2,2],[0,7,1,9],[0,0,0,6],[3,1,3,6]]}
[null,null,null,null,null,null,null,"2023 Salary Supplement Reporting Roster "]
[null,"After completing, save the form as an (Excel Workbook (*.xlsx). You will then be able to upload the form into Acadis and complete your submission."]
[null,"(Steps) Go to the file menu, select save a copy, select (Excel Workbook (*.xlsx), select location to save the file, and click save. "]
[null,null,null,null,null,null,null,null,"  POST USE ONLY",null,"Corrected Numbers By POST",null,null," POST USE ONLY"]
[null,"Agency Name:",null,null,"Total Officers the Agency Request are Eligible: ",null,null,{"$f":"COUNTIF(Table2[[Agency Request Officer Eligibility ]],\"YES Eligible\")","v":0},null,null,"Total Number Eligible Officers:",null,null,{"$f":"+H5+H9-H8","v":0}]
[null,null,null,null,"Total Officers NOT Eligible: ",null,null,{"$f":"COUNTIF(Table2[[Agency Request Officer Eligibility ]],\"NOT Eligible\")","v":0},{"$f":"H6-H9+H8","v":0},null,"Total Number of Ineligible Officers:",null,null,{"$f":"H6-H9+H8","v":0}]
[null,"Agency Head Print Name:",null,null,null,null,"Correct (OK)",{"$f":"COUNTIF(Table2[[#All],[POST USE ONLY ]],\"OK\")","v":0},null,null,"POST Signature: "]
[null,"Agency Head Signature:",null,null,null,null,"Subtracted from Eligible List (-)1",{"$f":"COUNTIF(Table2[[POST USE ONLY ]],\"(-)1 Not Eligible\")","v":0}]
[null,"Date:",{"$f":"TODAY()","v":"2024-01-11"},null,null,null,"Added to Eligible List (+) 1",{"$f":"COUNTIF(Table2[[#All],[POST USE ONLY ]],\"(+)1 Eligible\")","v":0},null,null,"DATE:",null,{"$f":"TODAY()","v":"2024-01-11"}]
[]
[null,"Officer Name (Last, First, MI)","PSID Number","Date of Hire with Current Agency","Year of POST Certification","Officer Has Eight Months of Fulltime LE Service ","ALL In-Service Training Completed","Agency Request Officer Eligibility ","Waiver Included for Officer","Please Indicate Type of Waiver Attached","Please Select Description of Eligibility or Ineligibility","Column1","POST USE ONLY ","POST USE ONLY NOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Waiver Needed ",null,null,null,null,"OK",null,"NOT Eligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Military Waiver with Active Orders (Eligible w/waiver+orders)+",null,null,null,null,"(+)1 Eligible",null,"YES Eligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 Month Waiver (Officer Completed All In-service but Does NOT Have a Total of 8 Months Fulltime Service Due to Retirement, Death, Medical Disability, or Change of Administration) (Eligible w/waiver) +",null,null,null,null,"(-)1 Not Eligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In-Service Waiver (Compliance Only, Did Not Complete In-service, Ineligible )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical Waiver (Compliance Only, Ineligible, Did Not Complete In-service Due to Medical Reason)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer was Terminated by a Law Enforcement Agency During 2023 (No Waiver Needed, Ineligible)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Did NOT Complete In-Service Training (Ineligible, Waiver Needed for Compliance Only) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Waiting to Attend Academy or Transition School and Not POST Cert. (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer POST Certified in 2023 (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Attended Transition School in 2023 and DID NOT Complete all Training (Ineligible, Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Attended Transition School in 2023 and Completed all Training (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Retired and Did Not Complete In-Service. (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed all Training but Less than 8 Total Months of Fulltime Law Enforcement Service with One or All Combined 2023 Employing Agencies (Ineligible, No Waiver Needed))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed all Training but has Less than 8 Total Months of Fulltime Law Enforcement Service Due to Being Separated to a NON L.E. Position (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Did not Complete Training and Separated to a NON Law Enforcement Position ( Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Separated and Employed with Other Agency at End of Calendar Year (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parttime or Reserve Employment (Ineligible, No Waiver Needed) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Separated from Agency with Less than 8 mo. (Ineligible, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Did Not Complete In-Service Training Due to Illness or Injury (Ineligible, Waiver Needed for Compliance Only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Law Enforcement (Ineligible, No Waiver Needed) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ineligible to Receive Supplement Pay Due to Retirement Benefits (Officer is in Compliance, No Waiver Needed)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Completed All In-Service Training and Meets all POST Standards (Eligible, No Waiver Needed) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer on Active Military Duty With Active Orders  (Eligible w/waiver+orders) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Completed all In-Service Training and Retired with Less Than 8 Months of Service  (Eligible w/waiver) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Completed all In-Service Training with Less Than 8 Months of Service Due to Medical Disability or Injury (Eligible w/waiver) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Completed all In-Service Training with Less Than 8 Months of Service due to Separation from Change of Administration (Eligible w/waiver) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In-Line of Duty Fatality (Eligible w/waiver) +"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Officer Passed Away and Completed All In-Service Training (Eligible w/waiver) +"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eligible"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Requesting Eligible With Waiver "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ineligible NO Waiver Needed "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ineligible Requesting Compliance Only With Waiver "]

{"sheet":"TOTAL TIME OF SERVICE TOOL ","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,0,21,0],[19,5,21,5],[23,1,25,3],[23,5,24,5],[15,0,17,0],[1,1,2,8],[7,0,9,0],[1,0,2,0],[7,5,9,5],[11,0,13,0],[11,5,13,5],[4,3,5,3],[4,5,5,5],[4,7,8,7],[4,8,8,8],[12,7,17,8],[15,5,17,5]]}
[]
[null,"Use This Tool to Help Determine if Officer Has Eight (8) Full Months of Service "]
[]
[]
[null,null,null,"Enter Date(s) Below",null,"Total Days of Service",null,"Officer Has Eight (8) Full Months of Law Enforcement Service:",{"$f":"SUM(F8:F22)","v":0}]
[]
[]
[null,"Current Employer Start Date in 2023",null,null,null,{"$f":"DAYS360(D8,D10)","v":0}]
[]
[null,"Current Employer End Date in 2023 ",null,null,null,null,null,null,null,null,"2023-12-31"]
[null,null,null,null,null,null,null,null,null,null,"2023-01-01"]
[null,"Previous Employer 1 Start Date in 2023",null,null,null,{"$f":"DAYS360(D12,D14)","v":0}]
[null,null,null,null,null,null,null,"Service Time Has to be Completed at an Eligible Law Enforcement Agency. State Agencies Are Not Eligible for the Salary Supplement. "]
[null,"Previous Employer 1 End Date in 2023"]
[]
[null,"Previous Employer 2 Start Date in 2023",null,null,null,{"$f":"DAYS360(D16,D18)","v":0}]
[]
[null,"Previous Employer 2 End Date in 2023"]
[]
[null,"Previous Employer 3 Start Date In 2023",null,null,null,{"$f":"DAYS360(D20,D22)","v":0}]
[]
[null,"Previous Employer 3 End Date in 2023"]