{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Data","SummaryTime","datac","CSP","INVADD","Instructions","Process","Cover","Officers","Invoice","Holiday","Macros","Merged Data","BlankOIC","BlankTS","DATES","Auto","Summary","Stats","Hol. Costs","Hol. Stats","Signature","Recap","Export","Dates2"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":26,"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":"Data","index":0,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date#","Name","Shift Rate Tot.","Hrs Worked+"," Salaries$","Start Time","End Time"]

{"sheet":"SummaryTime","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Cover!A109","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM     SELECT TOWN        0"}]
[null,"Summary Costs"]
[]
[null,"Worksheets","Date#","Name","Shift Rate Tot.","Hrs Worked+"," Salaries$",null,"Beg Time","In Chkpt","Out Chkpt"]

{"sheet":"datac","index":2,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Date#","Name","Shift Rate Tot.","Hrs Worked+"," Salaries$","Start Time","End Time"]

{"sheet":"CSP","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,4,0,11],[15,4,19,9]]}
[null,null,null,null,"ADDITIONAL MACROS FOR DESPP"]
[]
[]
[null,null,null,1,null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FOR HSO ONLY:"]
[null,null,null,null,"“Note:  This signature report is being used only to provide the back-up for date, time, and total number of hours worked.  The actual hourly rate and the amount paid will be verified against the Core-run report along with the date, time, and total number of hours worked.  A unique identifier is entered on the individual’s timesheet in Core, and a Core query report is run and the specific information is extracted using that criteria to identify the overtime worked on a particular enforcement activity.” "]

{"sheet":"INVADD","index":4,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["SELECT TOWN",null,null,"SELECT TOWN"]
["BERLIN","0200-0722-BY",0.1169,"TOWN OF BERLIN","240 KENSINGTON ROAD","N/A","BERLIN","CT","06037",7,4]
["BETHANY","0200-0722-AE",0.97099999999999997,"TOWN OF BETHANY","40 PECK ROAD","N/A","BETHANY","CT","06524",8,1]
["BETHEL","0200-0722-BE",7.6499999999999999E-2,"BETHEL POLICE DEPARTMENT","49 PLUMTREES ROAD","N/A","BETHEL","CT","06801",9,21]
["BLOOMFIELD","0200-0722-BR",0.5756,"BLOOMFIELD POLICE DEPARTMENT","785 PARK AVENUE","N/A","BLOOMFIELD","CT","06002",11,6]
["BRANFORD","0200-0722-BI",0.61899999999999999,"TOWN OF BRANFORD POLICE DEPARTMENT","33 LAUREL STREET","N/A","BRANFORD","CT","06405",14,2]
["BRISTOL","0200-0722-AJ",0.40429999999999999,"CITY OF BRISTOL ","COMPTROLLER'S OFFICE","111 NORTH MAIN STREET","BRISTOL","CT","06010",17,28]
["BROOKLYN","0200-0722-DM",0.97099999999999997,"TOWN OF BROOKLYN","4 WOLF DEN ROAD","N/A","BROOKLYN","CT","06234",19,4]
["CCSU","0200-0722-BV",0.70930000000000004,"CENTRAL CONNECTICUT STATE UNIVERSITY","1615 STANLEY STREET","N/A","NEW BRITAIN","CT","06050",89,4]
["CHESHIRE","0200-0722-DH",0.89380000000000004,"TOWN OF CHESHIRE","84 SOUTH MAIN STREET","N/A","CHESHIRE","CT","06410",25,1]
["CHESTER","0200-0722-CG",0.97099999999999997,"TOWN OF CHESTER","203 MIDDLESEX AVENUE","N/A","CHESTER","CT","06412",26,2]
["COLCHESTER","0200-0722-CP",0.1095,"COLCHESTER POLICE","127 NORWICH AVENUE","N/A","COLCHESTER","CT","06415",28,7]
["COVENTRY","0200-0722-BL",0.25969999999999999,"COVENTRY POLICE DEPARTMENT","1585 MAIN STREET","N/A","COVENTRY","CT","06238",32,4]
["CROMWELL","0200-0722-BC",0.30480000000000002,"TOWN OF CROMWELL","41 WEST STREET","N/A","CROMWELL","CT","06416",33,1]
["DANBURY","0200-0722-BX",1.29E-2,"DANBURY POLICE DEPARTMENT","C/O FINANCE DEPARTMENT","155 DEER HILL AVENUE","DANBURY","CT","06810",34,8]
["DARIEN","0200-0722-BW",0.39779999999999999,"TOWN OF DARIEN POLICE","25 HECKER AVENUE","N/A","DARIEN","CT","06820",35,2]
["DEEP RIVER","0200-0722-AW",0.97099999999999997,"TOWN OF DEEP RIVER","174 MAIN STREET","N/A","DEEP RIVER","CT","06417",36,4]
["DESPP","0200-0743-1-DM",null,"STATE OF CONNECTICUT","DEPT. OF EMRG SVC & PUBLIC PROT.","1111 COUNTRY CLUB ROAD","MIDDLETOWN","CT","06457-9294","DPSM1",1]
["DURHAM","0200-0722-AH",0.97099999999999997,"TOWN OF DURHAM","30 TOWN HOUSE ROAD","P.O. BOX 428","DURHAM","CT","06422",38,4]
["EAST HAVEN","0200-0722-BO",0.61350000000000005,"EAST HAVEN POLICE DEPARTMENT","471 NORTH HIGH STREET","N/A","EAST HAVEN","CT","06512",44,4]
["EAST HADDAM","0200-0722-CD",null,"TOWN OF EAST HADDAM","1 PLAINS ROAD","P.O. BOX 385","MOODUS","CT","06469",41,2]
["EAST LYME","0200-0722-CA",0.12670000000000001,"TOWN OF EAST LYME","108 PENNSYLVANIA AVENUE","N/A","NIANTIC","CT","06357",45,2]
["EAST WINDSOR","0200-0722-DW",7.6499999999999999E-2,"TOWN OF EAST WINDSOR","11 RYE STREET ","N/A","BROAD BROOK","CT","06016",47,1]
["ELLINGTON","0200-0722-AO",0.97099999999999997,"TOWN OF ELLINGTON","33 ARBOR WAY","N/A","ELLINGTON","CT","06029",48,23]
["ENFIELD","0200-0722-CN",3.5499999999999997E-2,"TOWN OF ENFIELD","293 ELM STREET","N/A","ENFIELD","CT","06082",49,2]
["FAIRFIELD","0200-0722-AT",0.60470000000000002,"FAIRFIELD POLICE DEPARTMENT","100 REEF ROAD","N/A","FAIRFIELD","CT","06824",51,2]
["FARMINGTON","0200-0722-DS",0.51470000000000005,"TOWN OF FARMINGTON","1 MONTEITH DRIVE","N/A","UNIONVILLE","CT","06085",52,5]
["GLASTONBURY","0200-0722-AG",0.50060000000000004,"TOWN OF GLASTONBURY","2155 MAIN STREET","P.O. BOX 6523","GLASTONBURY","CT","06033",54,1]
["GREENWICH","0200-0722-AL",0,"TOWN OF GREENWICH","GREENWICH POLICE DEPARTMENT","11 BRUCE PLACE","GREENWICH","CT","06830",57,6]
["GROTON CITY","0200-0722-AV",0.54269999999999996,"CITY OF GROTON POLICE DEPARTMENT","295 MERIDIAN STREET","N/A","GROTON","CT","06340",501,3]
["GROTON TOWN","0200-0722-BK",0.56759999999999999,"TOWN OF GROTON POLICE DEPARTMENT","68 GROTON LONG POINT ROAD","N/A","GROTON","CT","06340-4806",59,3]
["HADDAM","0200-0722-CK",0.97099999999999997,"TOWN OF HADDAM","30 FIELD PARK DRIVE","N/A","HADDAM","CT","06438",61,1]
["HARTFORD","0200-0722-CB",0.57050000000000001,"CITY OF HARTFORD ","POLICE DEPARTMENT","253 HIGH STREET","HARTFORD","CT","06103",64,2]
["JEWETT CITY","0200-0722-BT",0.97099999999999997,"BOROUGH OF JEWETT CITY","28 MAIN STREET","N/A","JEWETT CITY","CT","06351",606,1]
["KILLINGLY","0200-0722-AF",0.97099999999999997,"TOWN OF KILLINGLY","172 MAIN STREET","N/A","DANIELSON","CT","06239",69,1]
["KILLINGWORTH","0200-0722-BF",0.97099999999999997,"TOWN OF KILLINGWORTH","323 ROUTE 81","N/A","KILLINGWORTH","CT","06419",70,1]
["LEDYARD","0200-0722-AK",0.52,"TOWN OF LEDYARD","741 COLONEL LEDYARD HIGHWAY","N/A","LEDYARD","CT ","06351",72,1]
["LISBON","0200-0722-CQ",0.97099999999999997,"TOWN OF LISBON","1 NEWENT ROAD","N/A","LISBON","CT","06351",73,1]
["MADISON","0200-0722-CT",0.69820000000000004,"TOWN OF MADISON","8 CAMPUS DRIVE","N/A","MADISON","CT","06443",76,4]
["MANCHESTER","0200-0722-BH",0.27150000000000002,"TOWN OF MANCHESTER","239 EAST MIDDLE TURNPIKE","P.O. BOX 191","MANCHESTER","CT","06045-0191",77,6]
["MANSFIELD","0200-0722-DU",0.97099999999999997,"TOWN OF MANSFIELD ","ATTN:  FINANCE DEPARTMENT","4 SOUTH EAGLEVILLE ROAD ","MANSFIELD","CT","06268",78,5]
["MERIDEN","0200-0722-AU",7.6499999999999999E-2,"MERIDEN POLICE DEPARTMENT","50 WEST MAIN STREET","N/A","MERIDEN","CT","06451",80,5]
["MIDDLEFIELD","0200-0722-AI",0.97099999999999997,"MIDDLEFIELD RESIDENT TROOPER'S OFFICE","393 JACKSON HILL ROAD","N/A","MIDDLEFIELD","CT","06455",82,4]
["MONROE","0200-0722-CI",0.29399999999999998,"TOWN OF MONROE","7 FAN HILL ROAD","N/A","MONROE","CT","06468",85,5]
["MONTVILLE","0200-0722-CS",0.29380000000000001,"MONTVILLE POLICE DEPARTMENT","911 ROUTE 32","N/A","UNCASVILLE","CT ","06382",86,6]
["NAUGATUCK","0200-0722-AQ",0.62680000000000002,"NAUGATUCK POLICE DEPARTMENT","211 SPRING STREET","N/A","NAUGATUCK","CT","06770",88,6]
["NEW BRITAIN","0200-0722-AN",0,"CITY OF NEW BRITAIN","27 WEST MAIN STREET ","N/A","NEW BRITAIN","CT","06051",89,4]
["NEW CANAAN","0200-0722-BU",7.0000000000000007E-2,"TOWN OF NEW CANAAN","77 MAIN STREET","N/A","NEW CANAAN","CT","06840",90,1]
["NEW HAVEN","0200-0722-DI",0.58050000000000002,"NEW HAVEN POLICE DEPARTMENT","200 ORANGE STREET","TREASURER'S OFFICE","NEW HAVEN","CT","06510",93,5]
["NEW LONDON","0200-0722-DZ",null,"NEW LONDON POLICE DEPARTMTNET","5 GOVERNOR WINTHROP BOULEVARD","N/A","NEW LONDON","CT","06320",95,2]
["NEW MILFORD","0199-0722-FA",0.13730000000000001,"TOWN OF MILFORD","49 POPLAR STREET","N/A","NEW MILFORD","CT","06776",96,5]
["NEWTOWN","0200-0722-DA",0.62670000000000003,"NEWTOWN POLICE DEPARTMENT","3 MAIN STREET","N/A","NEWTOWN","CT","06470",97,4]
["NORTH BRANFORD","0200-0722-DO",0.51759999999999995,"TOWN OF NORTH BRANFORD","909 FOXON ROAD","N/A","NORTH BRANFORD","CT","06472",99,1]
["NORTH HAVEN","0200-0722-BJ",null,"TOWN OF NORTH HAVEN","18 CHURCH STREET","N/A","NORTH HAVEN","CT","06473",101,3]
["NORTH STONINGTON","0200-0722-CE",0.97099999999999997,"TOWN OF NORTH STONINGTON","40 MAIN STREET","N/A","NORTH STONINGTON","CT","06359",102,4]
["NORWALK","0200-0722-BD",1.4500000000000001E-2,"CITY OF NORWALK","COMPTROLLER'S OFFICE ROOM 233","125 EAST AVENUE","NORWALK","CT","06851",103,8]
["NORWICH","0200-0722-BM",0.38650000000000001,"NORWICH POLICE DEPARTMENT","70 THAMES STREET","N/A","NORWICH","CT","06360",104,3]
["OLD LYME","0200-0722-BQ",0.19400000000000001,"TOWN OF OLD LYME","52 LYME STREET","N/A","OLD LYME","CT","06371",105,1]
["OLD SAYBROOK","0200-0722-DL",0.1767,"OLD SAYBROOK DEPARTMENT OF POLICE SERVICES","36 LYNDE STREET","N/A","OLD SAYBROOK","CT","06475",106,5]
["ORANGE","0200-0722-DN",0.52,"ORANGE POLICE DEPARTMENT","314 LAMBERT ROAD","N/A","ORANGE","CT","06477",107,4]
["PLAINFIELD","0200-0722-DK",0.26,"PLAINFIELD POLICE DEPARTMENT","210 NORWICH ROAD","N/A","PLAINFIELD","CT","06374",109,2]
["PLAINVILLE","0200-0722-AZ",0.11900000000000001,"PLAINVILLE POLICE DEPARTMENT","19 NEAT CT.","N/A","PLAINVILLE","CT","06062",110,4]
["PLYMOUTH","0200-0722-CX",null,"TOWN OF PLYMOUTH","80 MAIN STREET","N/A","TERRYVILLE","CT","06786",111,5]
["PRESTON","0200-0722-EC",null,"PRESTON RESIDENT TROOPER'S OFFICE","389 ROUTE 2","N/A","PRESTON","CT","06365",114,6]
["PROSPECT","0200-0722-AS",0,"TOWN OF PROSPECT","PROSPECT RESIDENT TROOPER'S OFFICE","8 CENTER STREET","PROSPECT","CT","06712",115,3]
["ROCKY HILL","0200-0722-DV",0.42120000000000002,"TOWN OF ROCKY HILL","FINANCE DEPARTMENT","761 OLD MAIN STREET","ROCKY HILL","CT","06067",119,1]
["SOMERS","0200-0722-AP",0.97099999999999997,"TOWN OF SOMERS","600 MAIN STREET","N/A","SOMERS","CT","06071",129,2]
["SOUTH WINDSOR","0200-0722-DJ",0.36799999999999999,"TOWN OF SOUTH WINDSOR ","ATTN:  FINANCE","1540 SULLIVAN AVENUE","SOUTH WINDSOR","CT","06074",132,4]
["SPRAGUE","0200-0722-EB",0.97099999999999997,"TREASURER, TOWN OF SPRAGUE","1 MAIN STREET","N/A","BALTIC","CT","06330",133,6]
["STAFFORD","0200-0722-BB",0.97099999999999997,"TOWN OF STAFFORD","1 MAIN STREET","N/A","STAFFORD SPRINGS","CT","06076",134,6]
["STAMFORD","0200-0722-EZ",1.4500000000000001E-2,"STAMFORD POLICE DEPARTMENT","805 BEDFORD STREET","N/A","STAMFORD","CT","06901",135,5]
["STRATFORD","0200-0722-CM",0.20150000000000001,"TOWN OF STRATFORD","900 LONGBROOK AVENUE","N/A","STRATFORD","CT","06614",138,4]
["SUFFIELD","0200-0722-DR",null,"TOWN OF SUFFIELD","83 MOUNTAIN ROAD","N/A","SUFFIELD","CT","06078",139]
["TOLLAND","0200-0722-CF",0.97099999999999997,"TOWN OF TOLLAND","ATTN:  LAURA SCHWABE, ACCOUNTANT","21 TOLLAND GREEN","TOLLAND","CT","06084",142,21]
["TORRINGTON","0200-0722-DE",8.5099999999999995E-2,"TORRINGTON POLICE DEPARTMENT","576 MAIN STREET","N/A","TORRINGTON ","CT ","06790",143,5]
["TRUMBULL","0200-0722-CL",0.50180000000000002,"TOWN OF TRUMBULL","158 EDISON ROAD","N/A","TRUMBULL","CT","06611",144,3]
["VERNON","0200-0722-CH",0.50170000000000003,"VERNON POLICE DEPARTENT","725 HARTFORD TURNPIKE","N/A","VERNON","CT","06066",146,16]
["WALLINGFORD","0200-0722-CC",0.2145,"TOWN OF WALLINGFORD POLICE DEPARTMENT","135 NORTH MAIN STREET","N/A","WALLINGFORD","CT","06492",148,10]
["WATERBURY","0200-0722-ED",null,"WATERBURY POLICE DEPARTMENT","255 EAST MAIN STREET","N/A","WATERBURY","CT","06702",151,9]
["WATERFORD","0200-0722-CV",0.29399999999999998,"TOWN OF WATERFORD","ATTN: FINANCE","15 ROPE FERRY ROAD","WATERFORD","CT","06385",152,5]
["WATERTOWN","0200-0722-AM",0.35,"TOWN OF WATERTOWN","424 MAIN STREET","N/A","WATERTOWN","CT","06795",153,1]
["WEST HARTFORD","0200-0722-DR",0,"TOWN OF WEST HARTFORD FINANCE  ","C/O BARBARA RUA","50 SOUTH MAIN STREET","WEST HARTFORD","CT","06107",155,1]
["WESTBROOK","0200-0722-DC",null,"WESTBROOK RESIDENT TROOPER","866 BOSTON POST ROAD","N/A","WESTBROOK","CT","06498",154,1]
["WESTON","0200-0722-CW",0.2969,"WESTON POLICE DEPARTMENT","56 NORFIELD ROAD","N/A","WESTON","CT","06071",157,7]
["WETHERSFIELD","0200-0722-AR",0.27300000000000002,"TOWN OF WETHERSFIELD","ATTN:  FINANCE DEPARTMENT","505 SILAS DEANE HIGHWAY","WETHERSFIELD","CT","06109",159,1]
["WILLIMANTIC","0200-0722-CJ",6.2700000000000006E-2,"TOWN OF WINDHAM","979 MAIN STREET","N/A","WILLIMANTIC","CT","06226",163,7]
["WILTON","0200-0722-BZ",0,"TOWN OF WILTON - POLICE DEPARTMENT","240 DANBURY ROAD","N/A","WILTON","CT","06897",161,4]
["WINDSOR","0200-0722-BN",0.2145,"WINDSOR POLICE DEPARTMENT","340 BLOOMFIELD AVE","N/A","WINDSOR","CT","06095",164,4]
["WINDSOR LOCKS","0200-0722-DQ",0.31230000000000002,"WINDSOR LOCKS POLICE DEPARTMENT","4 VOLUNTEER DRIVE","N/A","WINDSOR LOCKS","CT","06096",165,5]
["WOLCOTT","0200-0722-EF",0.35,"WOLCOTT POLICE DEPARTMENT","225 NICHOLS ROAD","N/A","WOLCOTT","CT","06716",166,4]
["WOODBRIDGE","0200-0722-CZ",null,"WOODBRIDGE POLICE DEPARTMENT","4 MEETINGHOUSE LANE","N/A","WOODBRIDGE","CT","06525",167,2]

{"sheet":"Instructions","index":5,"n_rows":112,"n_cols":4,"rows_kept":112,"cut":false,"hidden":false,"merged":[[52,1,52,4],[39,1,42,4],[44,1,46,4],[48,1,49,4],[50,1,50,4]]}
[null,"INSTRUCTIONS FOR REIMBURSEMENT:",null,"Revised:  10/16/2019"]
[]
[null,"SECURITY WARNINGS:"]
[null,"SECURITY WARNING:  \"MACROS HAVE BEEN DISABLED” "]
[null,"YOU MUST ENABLE THE CONTENTS.  Or"]
[null,"SECURITY WARNING:  \"MACROS HAVE BEEN DISABLED”   "]
[null,"YOU MUST ENABLE THE MACROS."]
[null,"PROCESS SHEET:"]
[null,"OVERVIEW OF THE REIMBURSEMENT PROCESS."]
[null,"COVER SHEET:"]
[null,"REPORTING PROCEDURES AND CHECKLIST."]
[null,"DROP DOWN BOX FOR CHOOSING CITY/TOWN."]
[null,"OFFICERS SHEET:"]
[null,"ENTER IN OFFICER NAMES, HOURLY RATES, BADGE NUMBERS and SHIFT RATES."]
[null,"READ OTHER INSTRUCTIONS ON THE OFFICER SHEET."]
[null,"HOLIDAY SHEET:"]
[null,"ONLY FILL IN WHERE IT IS HIGHLIGHTED IN YELLOW."]
[null,"INVOICE SHEET:"]
[null,"ONLY FILL IN WHERE IT IS HIGHLIGHTED IN YELLOW."]
[null,"MACROS SHEET:"]
[null,"GENERATES REPORTS.  THIS IS DONE AFTER YOU CREATE ACTIVITY REPORTS."]
[null,"ATTACHES THE REIMBURSEMENT WORKBOOK TO OUTLOOK."]
[null,"SIGNATURE SHEET:"]
[null,"SEE INSTRUCTIONS BELOW."]
[null,"START USING THE REIMBURSEMENT WORKBOOK BY:"]
[null,"GENERATING AN ACTIVITY REPORT FOR ROVING ENFORCEMENT:"]
[null,"CTRL + t.  ONLY FILL IN WHERE IT IS HIGHLIGHTED IN YELLOW."]
[null,"DO NOT CHECK THE BOXES."]
[null,"GENERATING AN ACTIVITY REPORT FOR CHECKPOINT ENFORCEMENT:"]
[null,"INDICATE EITHER \"IN TOWN\" OR \"OUT OF TOWN\" BY CHECKING THE PROPER BOX."]
[null,"ENTER THE CHECKPOINT LOCATION."]
[null,"CHECKPOINT STATISTICS CAN EITHER BE ASSIGNED TO ONE OFFICER OR DISTRIBUTED"]
[null,"AMONG MULTIPLE OFFICERS."]
[null,"GENERATING REPORTS:  "]
[null,"CLICK THE BUTTON \"ALL REPORTS\" IN THE MACROS SHEET TO GENERATE THE FOLLOWING "]
[null,"REPORTS:"]
[null,"SUMMARY","HOL. COSTS","HOLIDAY"]
[null,"STATS","HOL. STATS","INVOICE"]
[null,"SIGNATURE (PLEASE READ)"]
[null,"EACH TIME REPORT MUST INCLUDE TWO ORIGINAL INK SIGNATURES; THE WORKING EMPLOYEE AND THE HIGHER-RANKING SUPERVISOR. THE EXCEPTION TO THIS WOULD ONLY BE: A SHIFT SUPERVISOR MAY SIGN AS THE SUPERVISOR OF EMPLOYEES WORKING WITH THE SAME RANK; HOWEVER, TWO EMPLOYEES SHOULD NOT BE SIGNING EACH OTHER’S TIME REPORTS.\n\n"]
[]
[]
[]
[]
[null,"IF AN EMPLOYEE IS NOT AVAILABLE TO SIGN DUE TO AN EXTENDED ABSENCE (E.G. RETIREMENT, MEDICAL LEAVE), THEN A SUPERVISOR CAN SIGN ON BEHALF OF THE EMPLOYEE. IF THIS IS THE CASE, THEN A HIGHER-RANKING SUPERVISOR MUST SIGN ON THE SUPERVISOR LINE."]
[]
[]
[]
[null,"ALL SIGNERS MUST COMPLY WITH THE CERTIFICATION STATEMENTS THEY ARE SIGNING, AND MUST PRINT THEIR NAME & RANK, AND INCLUDE THE DATE IT WAS SIGNED."]
[]
[]
[]
[null,"MACRO KEYSTROKES:"]
[null,"CTRL + t  = ACTIVITY REPORT"]
[null,"CTRL + p = PRINT.  CHECK OFF ONLY WHAT IS REQUESTED IN THE CHECKLIST."]
[null,"CTRL + x = AUTOMATICALLY ATTACHES A WORKSHEET THAT WILL BE EMAILED TO HSO."]
[null,"ELECTRONIC SUBMITTAL:"]
[null,"IF YOU DO NOT USE MICROSOFT OUTLOOK THEN,"]
[null,"OPEN YOUR EMAIL PROGRAM AND MANUALLY ATTACH THE WORKBOOK AND EMAIL"]
[null,"TO: Drink-Drive-Lose.DOT@ct.gov"]
[null,"HARDCOPY SUBMITTAL:"]
[null,"MAIL ALL REIMBURSEMENT MATERIALS TO:"]
[null,"CONNECTICUT DEPARTMENT OF TRANSPORTATION"]
[null,"HIGHWAY SAFETY OFFICE"]
[null,"PO BOX 317546"]
[null,"NEWINGTON, CT 06131-7546"]
[null,"ATTN:  IMPAIRED DRIVING PROGRAM COORDINATOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B1&\"     \"&#REF!&\"        \"&H37","v":{"$error":"#REF!"}}]

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

{"sheet":"Cover","index":7,"n_rows":114,"n_cols":12,"rows_kept":114,"cut":false,"hidden":false,"merged":[[48,4,48,5],[47,11,50,16],[0,1,0,9],[27,2,30,8],[31,2,34,8],[1,1,1,9],[22,2,25,8],[19,2,21,8],[9,2,11,8],[47,4,47,5],[50,4,50,5],[49,4,49,5],[102,3,103,6],[36,2,36,4],[36,7,36,8],[105,3,106,6],[38,1,38,9],[40,1,40,9],[42,3,44,4],[42,5,44,7],[79,6,79,7],[90,2,92,8],[81,1,81,9],[83,1,83,9],[71,2,71,8],[46,4,46,5],[52,2,54,8],[51,4,51,5],[114,0,114,8],[129,3,131,9],[145,3,146,6],[148,3,149,6],[153,2,153,8],[124,1,124,9],[126,1,126,9],[133,2,135,8],[122,3,122,11]]}
[null,"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"]
[null,"Reporting Procedures"]
[]
[null,1,"Reimbursement Claim Checklist"]
[null,2,"Invoice"]
[null,3,"Summary Cost Sheet"]
[null,4,"Summary Stats Sheet"]
[null,5,"NTHSA Holiday TCNY Crackdown"]
[null,6,"Activity Report"]
[null,null,"These reports are used for roaming and checkpoint patrols.  If you have a checkpoint, check the appropriate box indicating \"in town\" or \"out of town\".  Also type in the location of the checkpoint."]
[]
[]
[null,null,"ALL SHIFTS SHOULD BEGIN AT 5PM AND END AT 4 AM."]
[null,null,"SHIFTS CANNOT EXCEED 8 HOURS PER ENFORCEMENT PERIOD, "]
[null,null,"UNLESS OTHERWISE NOTED."]
[null,7,"Sign Reports"]
[null,null,"These reports must be signed by personnel and supervisor."]
[]
[null,8,"Media Coverage"]
[null,null,"Please provide photocopies of local or regional news clippings and/or an informational statements regarding media coverage of your enforcement program. "]
[]
[]
[null,null,"WHILE THE MUNICIPALITY CANNOT BE HELD RESPONSIBLE FOR WHAT THE NEWS MEDIA CHOOSES TO PUBLICIZE, AN EFFORT SHOULD BE MADE TO INFORM THE MOTORING PUBLIC OF YOUR PLANNED DUI ENFORCEMENT EFFORTS.  CHECKPOINTS MUST BE PUBLICIZED. "]
[]
[]
[]
[]
[null,null,"Once the claim for reimbursement has been received, it will be reviewed for accuracy and processed for reimbursement.  Processing time is approximately 4-6 weeks.  The check will be made payable to the Payee listed on the invoice."]
[]
[]
[]
[null,null,"Financial or operational questions/issues should be directed to Highway Safety Office."]
[]
[]
[]
[null,"City/"]
[null,"Town of:  ","SELECT TOWN",null,null,"State Project No.",null,{"$f":"VLOOKUP(Invoice!$A$8,PAYEE,2,FALSE)","v":0}]
[]
[null,{"$f":"B1","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"}]
[]
[null,"Reimbursement Claim Checklist"]
[]
[null,null,null,"Claims for reimbursement to be submitted by:",null,"2020-01-31"]
[]
[]
[null,null,null,"APPROXIMATE BALANCE:  (OPTIONAL)"]
[null,null,null,null,0,null,"FEDERAL AMOUNT",null,null,null,null,"BALANCE FEATURE:  (optional)"]
[null,null,null,null,{"$f":"Invoice!R25","v":0},null,"BP1 REIMBURSEMENT AMOUNT",null,null,null,null,"Enter in your federal fund amount.  This balance is based on the assumption that your federal reimbursement for TCNY has been properly submitted."]
[null,null,null,null,0,null,"BP2 REIMBURSEMENT AMOUNT"]
[null,null,null,null,0,null,"BP3 REIMBURSEMENT AMOUNT"]
[null,null,null,null,0,null,"BP4 REIMBURSEMENT AMOUNT"]
[null,null,null,null,{"$f":"E47-E48-E49-E50-E51","v":0}]
[null,null,"The following items are submitted to claim reimbursement for allowable expenses as listed under the above named DUI Enforcement Project:"]
[]
[]
[null,"Check","Name of Documentation"]
[null,"(       )","Invoice  -- REMEMBER TO INCLUDE THE FRINGE WHERE APPLICABLE"]
[]
[null,"(       )","Summary Costs",null,"(Generated from Activity Reports)"]
[]
[null,"(       )","NHTSA Holiday TCNY"]
[null,null,"Crackdown",null,"(Generated from Activity Reports)"]
[]
[null,"(       )","Signature Reports ",null,"(Generated from Activity Reports)"]
[]
[null,"(       )","E-mail attachment to Highway Safety Office (Ctrl + x)"]
[null,null,"REIMBURSEMENT WILL BE PROCESSED ONLY AFTER ELECTRONIC"]
[null,null,"DATA HAS BEEN RECEIVED."]
[]
[null,"(       )","Photocopies of Media Coverage ( if applicable )"]
[]
[null,null,"Please return the above items to the following address:"]
[null,null,null,null,"Department of Transportation"]
[null,null,null,null,"Highway Safety Office"]
[null,null,null,null,"P. O. Box 317546"]
[null,null,null,null,"2800 Berlin Turnpike"]
[null,null,null,null,"Newington, CT  06131-7546"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"B1&\"     \"&C37&\"        \"&H37","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM     SELECT TOWN        0"}]
[null,{"$f":"B1&\"          \"&C37&\"            \"&H37","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM          SELECT TOWN            0"}]
[]
[]
[]
[null,{"$f":"B1&\"       \"&C37&\"             \"&H37","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM       SELECT TOWN             0"}]

{"sheet":"Officers","index":8,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Officer Information"]
[]
["Title","FI","Last Name","Badge No.","OT Rate","Prem. Rate","Name"]
[null,null,null,null,null,null,null,null,"Leave this row blank."]
[null,null,null,null,0,0,{"$f":"C5&\" \"&B5&\" \"&A5&\" \"&\" \"&D5","v":"    "},null,"Enter officer information where it is highlighted in yellow."]
[null,null,null,null,0,0,"    ",null,"Title:  Use abbreviated titles."]
[null,null,null,null,0,0,"    ",null,"FI:  First Initial only."]
[null,null,null,null,0,0,"    ",null,"Badge No.:  Optional."]
[null,null,null,null,0,0,"    ",null,"Name:  Will automatically fill-in."]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    ",null,"Do CTRL + o to put the officer information in alphabetically order."]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    ",null,"What you see on the Activity Reports (AR):"]
[null,null,null,null,0,0,"    ",null,"The activity report will have a down arrow in the officer name cell.  "]
[null,null,null,null,0,0,"    ",null,"Officer name will fill-in automatically once you chose a name."]
[null,null,null,null,0,0,"    ",null,"The OT rate and shift premium rate will automatically fill-in when you"]
[null,null,null,null,0,0,"    ",null,"chose an officer name."]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    ",null,"If an OT rate or premium rate changes during a reimbursement cycle, existing activity reports"]
[null,null,null,null,0,0,"    ",null,"will retain the older rate.  Once you enter a new rate, activity reports from this point forward will "]
[null,null,null,null,0,0,"    ",null,"appear with the newer rate."]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    ",null,null,null,null,null,"`"]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,{"$f":"C37&\" \"&B37&\" \"&A37&\" \"&\" \"&D37","v":"    "}]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,{"$f":"C69&\" \"&B69&\" \"&A69&\" \"&\" \"&D69","v":"    "}]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]
[null,null,null,null,0,0,"    "]

{"sheet":"Invoice","index":9,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,11],[14,7,14,10],[15,9,15,10],[11,9,11,11],[12,9,12,11],[8,3,8,11],[9,3,9,6],[10,3,10,6],[11,3,11,6],[12,3,12,6],[1,0,1,4],[3,0,3,1],[9,9,9,11],[10,0,10,2],[22,17,22,18],[22,0,22,11],[19,0,19,2],[20,0,20,2],[21,0,21,2],[19,3,19,10],[20,3,20,10],[21,3,21,10],[11,0,11,2],[12,0,12,2],[10,9,10,11],[9,0,9,2],[4,0,4,1],[5,0,5,1],[6,0,6,1],[8,13,9,18],[1,13,6,18],[2,0,2,1],[1,10,1,11],[2,10,2,11],[3,10,3,11],[4,10,4,11],[5,10,5,11],[6,10,6,11],[17,9,17,10],[14,1,14,5],[15,1,15,4],[16,1,16,4],[17,1,17,4],[17,7,17,8]]}
["REIMBURSEMENT INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,"NEW FEATURE:"]
["CT DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,"PAYEE:",{"$f":"VLOOKUP($A$8,PAYEE,4,FALSE)","v":"SELECT TOWN"},null,null,"Must choose your police department name from the drop-down  on the 2nd page of the Cover sheet.   Your \"Payee and Address\" will automatically populate based on DOT's CORE System.  "]
["OFFICE:",null,"HIGHWAY SAFETY OFFICE",null,null,null,null,null,null,"ADDRESS LINE #1:",{"$f":"VLOOKUP(A8,PAYEE,5,FALSE)","v":0}]
["ADDRESS:",null,"2800 BERLIN TURNPIKE",null,null,null,null,null,null,"ADDRESS LINE #2:",{"$f":"IF(VLOOKUP(A8,PAYEE,6,FALSE)=\"\",\"\",VLOOKUP(A8,PAYEE,6,FALSE))","v":""}]
["CITY:",null,"NEWINGTON",null,null,null,null,null,null,"CITY/TOWN:",{"$f":"VLOOKUP(A8,PAYEE,7,FALSE)","v":0}]
["STATE:",null,"CT",null,null,null,null,null,null,"STATE:",{"$f":"VLOOKUP(A8,PAYEE,8,FALSE)","v":0}]
["ZIP CODE:",null,"06131-7546",null,null,null,null,null,null,"ZIP CODE:",{"$f":"VLOOKUP(A8,PAYEE,9,FALSE)","v":0}]
[{"$f":"Cover!C37","v":"SELECT TOWN"},null,null,null,null,null,null,null,null,null,null,null,null,"NEW FEATURE:"]
["GRANT NAME:",null,null,{"$f":"Cover!B1","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"},null,null,null,null,null,null,null,null,null,"Date will automatically populate based on the last entry or edit you perform."]
["INVOICE DATE:",null,null,{"$f":"NOW()","v":"2019-11-12T13:30:37.930"},null,null,null,"VENDOR ID #",null,{"$f":"VLOOKUP(A8,PAYEE,10,FALSE)","v":0}]
["INVOICE #",null,null,{"$f":"LEFT(Cover!$H$37,12)& \"-BP1\"","v":"0-BP1"},null,null,null,"ADDRESS #",null,{"$f":"VLOOKUP(A8,PAYEE,11,FALSE)","v":0}]
["STATE PROJECT #",null,null,{"$f":"LEFT(Cover!$H$37,12)& \"\"","v":"0"},null,null,null,"PURCHASE ORDER #"]
["BILLING PERIOD:",null,null,"10/3/2019 - 1/1/2020",null,null,null,"RECEIPT #"]
[]
[null,"STAT'S SUMMARY",null,null,null,null,null,"INVOICE SUMMARY"]
[null,"DUI CITATIONS:",null,null,null,{"$f":"Export!$F$2+Export!$G$2+Export!$H$2","v":0},null,"SALARIES: ",null,{"$f":"Auto!G3","v":0}]
[null,"OTHER CITATIONS:",null,null,null,{"$f":"SUM(Export!$F$2:$W$2)-F16","v":0},null,"FRINGE BENEFITS %:",null,1.1385000000000001,{"$f":"J16*J17","v":0}]
[null,"TOTAL CITATIONS:",null,null,null,{"$f":"F16+F17","v":0},null,"  TOTAL INVOICE:",null,{"$f":"J16+K17","v":0}]
[]
["CONTACT:"]
["PHONE:"]
["EMAIL:"]
["FOR HSO USE ONLY"]
["EUGENE INTERLANDI, PROJECT MANAGER"]
[]
[]
[]
["SIGNATURE",null,null,null,null,null,null,null,null,"DATE"]
[]
["JOSEPH T. CRISTALLI, SAFETY PROGRAM COORDINATOR"]
[]
[]
[]
["SIGNATURE",null,null,null,null,null,null,null,null,"DATE"]
[]
["FISCAL APPROVAL"]
[]
[]
[]
["SIGNATURE",null,null,null,null,null,null,null,null,"DATE"]
[]
["NOTES:"]

{"sheet":"Holiday","index":10,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,0,40,2],[42,0,44,2],[0,0,1,2],[31,0,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[36,0,37,2]]}
["NHTSA HOLIDAY TCNY CRACKDOWN "]
[]
["DATES: 11/21/-12/1/19 , 12/5/-12/7/19, 12/12-1/1/20"]
["CGS NUMBER","TOTAL ARRESTS","TOTAL WARNINGS"]
["14-227a-DUI [ALCOHOL ONLY]",{"$f":"Auto!D1","v":0}]
["14-227a-DUI [DRUGS ONLY]",{"$f":"Auto!E1","v":0}]
["14-227a-DUI [ALCOHOL & DRUGS]",{"$f":"Auto!F1","v":0}]
["14-100a-Seatbelts",{"$f":"Auto!G1","v":0},{"$f":"Auto!H1","v":0}]
["14-100a ( d )-Child Car Seat",{"$f":"Auto!I1","v":0}]
["Felony Arrests",{"$f":"Auto!J1","v":0}]
["Recovered Stolen Vehicles",{"$f":"Auto!K1","v":0}]
["Fugitives Apprehended",{"$f":"Auto!L1","v":0}]
["Suspended License",{"$f":"Auto!M1","v":0}]
["Uninsured Motorists",{"$f":"Auto!N1","v":0}]
["Speeding",{"$f":"Auto!O1","v":0},{"$f":"Auto!P1","v":0}]
["Reckless Driving ",{"$f":"Auto!Q1","v":0}]
["Drug Possession",{"$f":"Auto!R1","v":0}]
["Other MV Citations",{"$f":"Auto!S1","v":0}]
["14-296aa-Cell Phone",{"$f":"Auto!T1","v":0}]
["14-296aa (i)-Distracted Driving",{"$f":"Auto!U1","v":0}]
[]
["Officer Hours Worked On Mobilization:"]
["Specifically on DUI",{"$f":"Auto!F2","v":0}]
["Specifically on Safety Belts",0]
["Specifically on Combined DWI/Belts",{"$f":"B23","v":0}]
["Percent (%) Hours Worked as Overtime",1]
["Percent (%) Hours Worked at Checkpoints",{"$f":"IF(ISERROR(B28/B23),0,B28/B23)","v":0}]
["Number of Hours Worked at Checkpoints"]
["Number of Checkpoints Conducted"]
["Total Cost of Holiday Period",{"$f":"Auto!G2","v":0},{"$f":"(B30+C31)","v":0}]
["Number of Days Worked ",{"$f":"Auto!C2","v":0},{"$f":"B30*Invoice!P23","v":0}]
["PROJECT DIRECTORS REPORT"]
["NAME:"]
["TELEPHONE:"]
["EMAIL:"]
["SUMMARIZE PROJECT OPERATION:"]
[]
[]
["IDENTIFY SIGNIFICANT PROBLEMS:"]
[]
[]
["GENERAL COMMENTS:"]

{"sheet":"Macros","index":11,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,4,5,14]]}
[null,"MACRO BUTTONS FOR GENERATING REPORTS"]
[]
[]
["1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORKSHEET TAB COLORS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IN-TOWN CHECKPOINT=DARK BLUE"]
[null,null,null,null,"BE PATIENT.  WAIT UNTIL YOU SEE \"REPORTS GENERATED\" ",null,null,null,null,null,null,null,null,null,null,"OUT-OF-TOWN CHECKPOINT=LIGHT BLUE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROVING=GREEN"]
[]
["2)",null,null,null,null,"IF YOU DO NOT USE MICROSOFT OUTLOOK THEN,"]
[null,null,null,null,null,"OPEN YOUR EMAIL PROGRAM AND MANUALLY ATTACH THE WORKBOOK AND MAIL"]
[null,null,null,null,null,"TO: Drink-Drive-Lose.DOT@ct.gov"]
[]
[]
[]
[null,"CLOSING THE REIMBURSEMENT WORKBOOK:"]
[null,"To close the workbook you must fill-in all required highlighted (yellow) areas.  If you leave blank any highlighted"]
[null,"areas, a pop-up box will appear indicating which highlighted area you did not fill-in."]
[]
[null,"If you are unable to fill-in any pop-up box, enter NA.  Make sure you change any NA's before submitting the "]
[null,"reimbursement."]

{"sheet":"Merged Data","index":12,"n_rows":195,"n_cols":11,"rows_kept":195,"cut":false,"hidden":true,"merged":[[267,1,267,7],[153,0,153,7],[154,0,154,4],[154,5,154,7],[155,0,155,4],[156,0,156,1],[156,2,156,7],[157,0,157,7],[158,0,158,1],[238,0,238,8],[177,0,177,3],[177,4,177,5],[177,6,177,7],[178,0,178,3],[178,4,178,5],[178,6,178,7],[194,0,194,7],[179,0,179,7],[180,0,182,7],[183,0,185,7],[186,0,186,7],[188,0,190,7],[191,0,193,7],[163,0,163,1],[165,0,165,3],[204,1,206,7],[167,0,167,3],[167,4,167,5],[167,6,167,7],[168,0,168,3],[168,4,168,5],[168,6,168,7],[171,0,171,3],[171,4,171,5],[171,6,171,7],[175,4,175,5],[175,6,175,7],[165,4,165,5],[165,6,165,7],[262,2,263,5],[240,0,240,8],[243,2,245,3],[243,4,245,6],[247,1,249,7],[259,2,260,5],[197,0,197,8],[169,4,169,5],[172,0,172,3],[172,4,172,5],[172,6,172,7],[169,0,169,3],[216,2,217,5],[219,2,220,5],[224,1,224,7],[236,5,236,6],[126,1,130,7],[148,5,148,6],[176,0,176,3],[176,4,176,5],[176,6,176,7],[173,0,173,3],[173,4,173,5],[173,6,173,7],[174,0,174,3],[174,4,174,5],[174,6,174,7],[169,6,169,7],[170,0,170,3],[170,4,170,5],[170,6,170,7],[175,0,175,3],[150,0,150,8],[152,0,152,8],[162,0,162,1],[162,6,162,7],[166,0,166,3],[166,4,166,5],[166,6,166,7],[163,6,163,7],[6,0,6,8],[8,0,8,8],[11,1,13,7],[15,3,15,5],[16,3,16,5],[19,1,20,7],[161,0,161,1],[161,6,161,7],[158,2,158,7],[159,0,159,1],[159,2,159,7],[160,0,160,1],[80,1,81,7],[84,1,93,7],[23,1,26,7],[29,1,40,7],[46,1,47,7],[53,1,62,7],[64,1,71,7],[74,1,77,7],[96,1,98,7],[110,1,113,7],[115,1,119,7],[124,2,124,6]]}
[]
["Summary Stats"]
[]
["Worksheets","Date","Total A","Total C","C Warn","Total D","D Warn","Felony Arr.","Recov'd Stolen Vec.","Fugitives App.","Susp. Lic"]
["TS1","2011-05-14",4,3,2,1,0,1,1,1,1]
["TS2","2011-05-30",1,2,0,1,0,0,0,0,1]
["FY 2010/2011 Comprehensive DUI Enforcement Program"]
[]
["Reimbursement and Reporting Procedures"]
[]
[]
[null,"TO RECEIVE REIMBURSEMENT, PLEASE SUBMIT ALL CLAIMS AND SUPPORTING DOCUMENTATION TO THE DIVISION OF HIGHWAY SAFETY BY:"]
[]
[]
[]
[null,null,null,"SUBMISSION DATES *LISTED BELOW*"]
[null,null,null,"February, August, & October 2011"]
[]
[]
[null,"CLAIMS RECEIVED BEYOND 45 DAYS AFTER OCTOBER 15, 2011 CANNOT BE REIMBURSED UNDER FEDERAL GUIDELINES."]
[]
[]
[]
[null,"To claim reimbursement of Highway Safety Funds once the project activity has been completed, please complete the following and return to the Division of Highway Safety."]
[]
[]
[]
[]
[]
[null,"PLEASE NOTE THAT THIS OFFICE HAS RECEIVED MANY COMMENTS FROM PROJECT DIRECTORS REGARDING THE REPORTING INFORMATION REQUIRED FOR THESE PROJECTS AND REVIEWED THOSE COMMENTS WITH GREAT INTEREST.  Therefore, most of the reporting forms have been changed or modified and much of the reporting detail has been eliminated.  Summaries of activities are all that will be required instead of specific information on every contact made while working under this project.  Please take a few moments and review the new forms and if you have any suggestions on how the reporting/reimbursement process can be further streamlined, please include these comments in the General Comments portion of the HIGHWAY SAFETY PROJECT SUMMARY SHEET. -- THANK YOU."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1.  Reimbursement Claim Checklist:   A blank form for use is enclosed."]
[]
[]
[null,"2.  Invoice-Voucher for Goods and Services (CLA-3):   A blank form for use and a sample form for reference are enclosed.  "]
[]
[]
[]
[null,"3.  Cost Summary Sheet:  A sample for reference is enclosed."]
[]
[]
[null,"4.  Highway Safety Project Time Sheet & Activity Report:  A time sheet MUST be completed for each officer for hours worked to be claimed for reimbursement under this project.  Each sheet must be signed by the officer employed under this project and claiming eligible expenses and MUST be signed by the officer's supervisor.  Each report must ONLY reflect the officer's time worked and wages paid under this highway safety project.  The PREVIOUS DAILY ACTIVITY REPORT FORM HAS BEEN ELIMINATED and in its place is an activity report summary which highlights the number of contacts that were made by this police officer while working under this project.  A blank reporting form for photocopying and use is enclosed.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.  Daily Activity Report Totals:  This form allows for the summarizing of all enforcement by all police officers working on a specific day.  This form allows for a final summation of all activities performed during the life of this project and will be used in completing the HIGHWAY SAFETY PROJECT SUMMARY SHEET which will serve as a final completion report by the Project Director and allow for any and all final comments, problems encountered, etc. under this project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"6.  Sobriety Check Point Activity Sheet:  If your department conducts a Sobriety Check Point(s) under this project, please complete a separate form per checkpoint completed and include the enforcement statistics in the HIGHWAY SAFETY PROJECT SUMMARY SHEET. "]
[]
[]
[]
[]
[]
[null,"7.  Media Coverage:  Please provide photocopies of local or regional news clippings and/or an informational statement regarding media coverage of your enforcement program. "]
[]
[]
[]
[null,"*******   WHILE THE MUNICIPALITY CANNOT BE HELD RESPONSIBLE FOR WHAT THE NEWS MEDIA CHOOSES TO PUBLICIZE, AN EFFORT SHOULD BE MADE TO INFORM THE MOTORING PUBLIC OF YOUR PLANNED DUI ENFORCEMENT EFFORTS.  THE FEAR OF APPREHENSION IS OFTEN ENOUGH OF A DETERMENT TO KEEP PEOPLE WHO THINK THEY MIGHT BE UNDER THE INFLUENCE FROM OPERATING THEIR VEHICLES.  THIS IS AS EFFECTIVE A TOOL OR TECHNIQUE AS THE DUI ENFORCEMENT ACTIVITY ITSELF.  PLEASE NOTE THAT STATEWIDE COVERAGE OF THIS ENFORCEMENT ACTIVITY WILL BE PROVIDED BY THROUGH THE D.O.T., REGIONAL/LOCAL COVERAGE IS NEEDED TO ENHANCE THE ENFORCEMENT ACTIVITY.  SOBRIETY CHECKPOINTS MUST BE PUBLICIZED. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have completed the above, send the claim for reimbursement with all supporting documentation to:"]
[]
[]
[]
[]
[null,null,null,"Department of Transportation"]
[null,null,null,"Transportation Safety Section"]
[null,null,null,"P. O. Box 317546"]
[null,null,null,"2800 Berlin Turnpike"]
[null,null,null,"Newington, CT  06131-7546"]
[]
[null,null,null,"Attn: Lorna Zirolli"]
[]
[]
[null,"Once the claim for reimbursement has been received, it will be reviewed for form and accuracy and processed for reimbursement.  Normal processing time is approximately 4-6 weeks.  The check will be made payable to the Vendor Payee listed on your form."]
[]
[]
[]
[]
[null,"Financial or operational questions/issues should be directed to Transportation Safety Section staff member Lorna Zirolli at 860-594-2366 or lorna.zirolli@po.state.ct.us."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SCROLL DOWN FOR COVER SHEETS"]
[]
[null,"APPLICABLE HOLIDAY NHTSA SHEET NEEDS TO BE ENCLOSED WITH EACH REIMBURSEMENT                                                                                              "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"City/Town of:  ","Simsbury Police Department",null,null,"State Project No.",null,7890]
[]
[{"$f":"A7","v":"FY 2010/2011 Comprehensive DUI Enforcement Program"}]
[]
["Reimbursement Claim Checklist"]
["Highway Safety Program Time Sheet & Activity Report"]
["  Town/City of:",null,null,null,null,"  State Project No:  "]
[{"$f":"Cover!D188","v":0},null,null,null,null,null,{"$f":"Cover!I188","v":0}]
["  Project Title:",null,{"$f":"Cover!B46","v":0}]
["( One time sheet/activity report per officer -- per enforcement shift )"]
["  Employee Name:"]
["  Date Worked:"]
["  Hours of Event:",null,"  Start:",null,"  End:",null,"Total Hours:"]
["  Hourly Rate:",null,null,"Hours Worked",null,"Cost:",{"$f":"SUM(C162*E162)","v":0}]
["  Shift Premium Rate:",null,null,"Hours Worked",null,"Cost:",{"$f":"SUM(C163*E163)","v":0}]
["Shift Total",null,{"$f":"SUM(C162:C163)","v":0},"Hours Worked",{"$f":"SUM(E162:E163)","v":0},"Cost:",{"$f":"SUM(G162:H163)","v":0}]
["CGS NUMBER",null,null,null,"TOTAL ARRESTS",null,"TOTAL WARNINGS"]
["14-227a"]
["14-100a ©"]
["14-100a (d)"]
["Felony Arrests"]
["Recovered Stolen Vehicles"]
["Fugitives Apprehended"]
["Suspended License"]
["Uninsured Motorists"]
["Speeding"]
["Reckless Driving"]
["Drug Arrests"]
["Other Arrests"]
["Motorcycle Contacts"]
["Total Stops and/or Contacts"]
["CERTIFICATIONS"]
["         I hereby certify that this statement is correct in all respects and that the time and expenses claimed herein are authorized by the Transportation Safety Section Project identified by the above listed State Project Number."]
[]
[]
["        SIGNED:"]
[]
[]
["( Employee's Ink Signature Required )"]
[]
["         I hereby certify that this statement is correct in all respects and that the time and expenses claimed herein are authorized by the Transportation Safety Section Project identified by the above listed State Project Number."]
[]
[]
["        SIGNED:"]
[]
[]
["( Supervisor's Ink Signature Required )"]

{"sheet":"BlankOIC","index":13,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,4],[1,5,1,7],[2,0,2,4],[3,0,3,1],[3,2,3,7],[4,5,4,7],[4,9,4,15],[5,0,5,1],[5,2,5,7],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,6,7,7],[8,0,8,1],[8,6,8,7],[9,0,9,1],[9,6,9,7],[9,9,9,15],[10,0,10,1],[10,6,10,7],[12,0,12,3],[12,4,12,5],[12,6,12,7],[13,0,13,3],[13,4,13,5],[13,6,13,7],[14,0,14,3],[14,4,14,5],[14,6,14,7],[15,0,15,3],[15,4,15,5],[15,6,15,7],[16,0,16,3],[16,4,16,5],[16,6,16,7],[17,0,17,3],[17,4,17,5],[17,6,17,7],[18,0,18,3],[18,4,18,5],[18,6,18,7],[19,0,19,3],[19,4,19,5],[19,6,19,7],[20,0,20,3],[20,4,20,5],[20,6,20,7],[21,0,21,3],[21,4,21,5],[21,6,21,7],[22,0,22,3],[22,4,22,5],[22,6,22,7],[23,0,23,3],[23,4,23,5],[23,6,23,7],[24,0,24,3],[24,4,24,5],[24,6,24,7],[25,0,25,3],[25,4,25,5],[25,6,25,7],[27,0,28,7],[29,0,29,1],[29,3,29,7],[38,0,38,7],[39,0,42,7],[44,0,45,7],[31,0,37,7],[30,0,30,7]]}
["Activity Report"]
["  Town/City of:",null,null,null,null,"  State Project No:  ",null,null,0,null,false,false,false]
[{"$f":"Cover!C37","v":"SELECT TOWN"},null,null,null,null,null,{"$f":"Cover!H37","v":0}]
["  Project Title:",null,{"$f":"Cover!B1","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"}]
[null,null,null,null,null,"LOCATION",null,null,null,"IMPORTANT UPDATE"]
["Officer Name:",null,null,null,null,null,null,null,null,"CHECK BOXES:  ONLY ONE BOX SHOULD BE CHECKED."]
["  Date Worked:",null,null,null,null,null,null,null,null,null,"Click the appropriate box for checkpoint enforcement."]
["Hours of Event:              ",null,"  Start:",null,"  End:",null,"EX: 5 PM or 17:00",null,null,null,"Type in your location of the checkpoint."]
["  Hourly Rate:",null,null,"Hours Worked",{"$f":"IF(F8<D8,24,0)+(F8-D8)*24","v":0},"Cost:",{"$f":"SUM(C9*E9)","v":0}]
["  Shift Premium Rate:",null,null,"Hours Worked",0,"Cost:",{"$f":"SUM(C10*E10)","v":0},null,null,"FEATURE"]
["Shift Total",null,{"$f":"IF(AND(E9>0,E10>0),C9+C10,IF(C9*E9=0,C10,C9))","v":0},"Hours Worked",{"$f":"E9+E10","v":0},"Cost:",{"$f":"SUM(G9:H10)","v":0},null,null,"Date Worked:"]
["CGS NUMBER",null,null,null,"TOTAL ARRESTS",null,"TOTAL WARNINGS",null,null,null,"Click in highlighted area and a down arrow will appear.  Click"]
["14-227a-DUI",null,null,null,null,null,null,null,null,null,"on down arrow and dates for crackdown will appear."]
["14-100a-Seatbelts",null,null,null,null,null,null,null,null,null,"If you have an approved special enforcement or open activity, "]
["14-100a ( d )-Child Car Seat",null,null,null,null,null,null,null,null,null,"then type in the date."]
["Felony Arrests"]
["Recovered Stolen Vehicles"]
["Fugitives Apprehended"]
["Suspended License"]
["Uninsured Motorists"]
["Speeding"]
["Reckless Driving"]
["Drug Arrests"]
["Other MV Citations"]
["14-296aa-Cell Phone"]
["14-296aa (i)-Distracted Driving"]
["SHIFT EXCEEDED PROGRAM PARAMETERS DUE TO:"]
[]
[]
["No. of Stops:",null,null,"(Optional-for law enforement use only)"]
["IMPORTANT"]
["  THIS ACTIVITY REPORT IS USED TO REPORT THE STATS FOR THE CHECKPOINT CONDUCTED.  AN INDIVIUAL ACTIVITY REPORT WILL NEED TO BE GENERATED FOR EACH PERSON WORKING THE CHECKPOINT--DO NOT ENTER STATS INTO THESE INDIVIDUAL ACTIVITY REPORTS.  THIS ACTIVITY REPORT HAS THE ACCUMULATOR FEATURE."]
[]
[]
[]
[]
[]
[]
["LAW ENFORCEMENT NOTES (OPTIONAL)"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"MID(CELL(\"filename\",A1),(FIND(\"]\",CELL(\"filename\"))+1),50)","v":""}]

{"sheet":"BlankTS","index":14,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[4,9,4,16],[0,0,0,7],[1,0,1,4],[1,5,1,7],[2,0,2,4],[3,0,3,1],[3,2,3,7],[4,5,4,7],[25,0,25,3],[25,4,25,5],[25,6,25,7],[23,4,23,5],[23,6,23,7],[24,4,24,5],[13,0,13,3],[5,0,5,1],[5,2,5,7],[24,0,24,3],[22,6,22,7],[22,0,22,3],[15,0,15,3],[12,4,12,5],[6,0,6,1],[7,6,7,7],[7,0,7,1],[8,0,8,1],[8,6,8,7],[14,0,14,3],[6,2,6,7],[9,2,9,7],[25,9,28,15],[12,6,12,7],[10,0,10,1],[17,0,17,3],[18,0,18,3],[19,0,19,3],[10,6,10,7],[12,0,12,3],[16,0,16,3],[15,4,15,5],[15,6,15,7],[13,4,13,5],[13,6,13,7],[14,4,14,5],[14,6,14,7],[10,9,11,16],[33,0,45,7],[16,4,16,5],[18,6,18,7],[21,4,21,5],[21,6,21,7],[20,6,20,7],[20,4,20,5],[17,4,17,5],[17,6,17,7],[18,4,18,5],[19,4,19,5],[19,6,19,7],[20,0,20,3],[16,6,16,7],[21,0,21,3],[23,0,23,3],[34,9,34,15],[14,9,14,15],[32,0,32,7],[26,0,26,3],[27,0,27,3],[26,4,26,5],[26,6,26,7],[27,4,27,5],[27,6,27,7],[24,6,24,7],[22,4,22,5],[15,9,16,15],[18,9,18,15],[29,0,30,7],[31,0,31,1],[31,3,31,7]]}
["Activity Report"]
["  Town/City of:",null,null,null,null,"  State Project No:  ",null,null,0,null,false,false,false]
[{"$f":"Cover!C37","v":"SELECT TOWN"},null,null,null,null,null,{"$f":"Cover!H37","v":0}]
["  Project Title:",null,{"$f":"Cover!B1","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"}]
[null,null,null,null,null,"LOCATION",null,null,null,"IMPORTANT UPDATE"]
["Officer Name:",null,null,null,null,null,null,null,null,"OT AND PREMIUM RATES ARE ENTERED IN THE OFFICERS SHEET"]
["  Date Worked:",null,null,null,null,null,null,null,null,"CHECK BOX BACK COLOR FOR PREMIUM RATE WILL APPEAR IN PINK WHEN CHECKED"]
["Hours of Event:              ",null,"  Start:",null,"  End:",null,"EX: 5 PM or 17:00",null,null,"OT RATE :  REGULAR OVERTIME RATE."]
["OT/Premuim Rate:",null,0,"Hours Worked",{"$f":"IF(F8<D8,24,0)+(F8-D8)*24","v":0},"Cost:",{"$f":"SUM(C9*E9)","v":0},null,null,"PREMIUM RATE:  HOLIDAY OVERTIME RATE."]
[null,null,"IF PREMUIM RATE, RATE WILL BE HIGHER."]
["Shift Total",null,{"$f":"C9","v":0},"Hours Worked",{"$f":"E9+E10","v":0},"Cost:",{"$f":"G9","v":0},null,null,"If “Hours Worked” appears highlighted in red, then a justification is required on the Activity Report in the designated field."]
["CGS NUMBER",null,null,null,"TOTAL ARRESTS",null,"TOTAL WARNINGS"]
["14-227a-DUI [ALCOHOL ONLY]"]
["14-277a-DUI [DRUGS ONLY]"]
["14-277a-DUI [ALCOHOL & DRUGS]",null,null,null,null,null,null,null,null,"CHECKPOINT STATISTICS"]
["14-100a-Seatbelts",null,null,null,null,null,null,null,null,"CHECKPOINT STATISTICS MAY BE ASSIGNED TO ONE OFFICER OR DISTRIBUTED AMONG MULTIPLE OFFICERS.  "]
["14-100a ( d )-Child Car Seat"]
["Felony Arrests"]
["Recovered Stolen Vehicles",null,null,null,null,null,null,null,null,"ACCUMULATOR FEATURE:"]
["Fugitives Apprehended"]
["Suspended License",null,null,null,null,null,null,null,null,null,null,"IF YOU TYPE IN A VALUE, A COMMENT WILL APPEAR"]
["Uninsured Motorists",null,null,null,null,null,null,null,null,null,null,"IN THE CELL. THE COMMENT RECORDS CELL ENTRIES."]
["Speeding",null,null,null,null,null,null,null,null,null,null,"FOR EXAMPLE, IF YOU TYPED A 6, THEN ANOTHER 3"]
["Reckless Driving",null,null,null,null,null,null,null,null,null,null,"IT SHOWS IN THE COMMENT AS 36.  THE "]
["Drug Possession",null,null,null,null,null,null,null,null,null,null,"CELL DISPLAYS 9."]
["Other MV Citations",null,null,null,null,null,null,null,null,"RESET TO ZERO:  MUST DELETE COMMENT VALUES BY CHOOSING REVIEW, EDIT COMMENT, BACKSPACE OUT THE COMMENTS.  TYPE IN CELL NEW VALUE AND IT WILL RESET.  "]
["14-296aa-Cell Phone"]
["14-296aa (i)-Distracted Driving"]
["PROGRAM PARAMETERS WERE NOT MET DUE TO:  (MAX. HOURS 8, MIN. HOURS 4)"]
[]
[]
["No. of Stops:",null,null,"(Optional-for law enforcement use only)"]
["LAW ENFORCEMENT NOTES (OPTIONAL)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"MID(CELL(\"filename\",A1),(FIND(\"]\",CELL(\"filename\"))+1),50)","v":""}]

{"sheet":"DATES","index":15,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["2019-11-21"]
["2019-11-22"]
["2019-11-23"]
["2019-11-24"]
["2019-11-25"]
["2019-11-26"]
["2019-11-27"]
["2019-11-28"]
["2019-11-29"]
["2019-11-30"]
["2019-12-01"]
["2019-12-05"]
["2019-12-06"]
["2019-12-07"]
["2019-12-12"]
["2019-12-13"]
["2019-12-14"]
["2019-12-15"]
["2019-12-16"]
["2019-12-17"]
["2019-12-18"]
["2019-12-19"]
["2019-12-20"]
["2019-12-21"]
["2019-12-22"]
["2019-12-23"]
["2019-12-24"]
["2019-12-25"]
["2019-12-26"]
["2019-12-27"]
["2019-12-28"]
["2019-12-29"]
["2019-12-30"]
["2019-12-31"]
["2020-01-01"]

{"sheet":"Auto","index":16,"n_rows":4,"n_cols":23,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Other Totals",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
["Other Totals",null,0,null,null,0,0]
["Other Totals",null,0,null,null,0,0]
["Other Totals",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]

{"sheet":"Summary","index":17,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Cover!A109","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM     SELECT TOWN        0"}]
[null,"Summary Costs"]
[]
[null,"Worksheets","Date#","Name","Shift Rate Tot.","Hrs Worked+"," Salaries$"]
[]
["Other Totals",null,{"$f":"SUM(IF(FREQUENCY(C4:C5,C4:C5)>0,1))","v":0},{"$f":"COUNTIFS(D4:D$5,\"*Total\",D4:D$5,\"<>Grand Total\")","v":0},null,{"$f":"SUM(F4:F5)","v":0},"NA"]
[]
[null,null,null,{"$f":"COUNTIFS(D$5:D6,\"*Total\",D$5:D6,\"<>Grand Total\")","v":0}]

{"sheet":"Stats","index":18,"n_rows":6,"n_cols":27,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Cover!A109","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM     SELECT TOWN        0"}]
[null,"Summary Stats"]
[]
[null,"Worksheets","Date#","DUIA+","DUID+","DUIAD+","Belts+","Belts W+","Car Seat+","Felony+","Recd Veh+","Fugitives+","Susp+","Uninsured+","Speed+","Speed W+","Reckless+","Drug+","Other+","Cell+","Distracted+",null,"Stops+","CP-In","CP-Out","Locale","Name"]
[]
["Other Totals",null,{"$f":"SUM(IF(FREQUENCY(C4:C5,C4:C5)>0,1))","v":0},{"$f":"SUM(D4:D5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(W4:W5)","v":0}]

{"sheet":"Hol. Costs","index":19,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["NHSTA DAYS & COST FOR HOLIDAY MOBILIZATION"]
[null,"Worksheets","Date#","Name","Shift Rate Tot.","Hrs Worked+"," Salaries$"]
[]
["Other Totals",null,{"$f":"SUM(IF(FREQUENCY(C2:C3,C2:C3)>0,1))","v":0},null,null,{"$f":"SUM(F2:F3)","v":0},{"$f":"SUM(G2:G3)","v":0}]

{"sheet":"Hol. Stats","index":20,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["NHSTA STATS FOR HOLIDAY MOBILIZATION"]
[null,"Worksheets","Date#","DUIA+","DUID+","DUIAD+","Belts+","Belts W+","Car Seat+","Felony+","Recd Veh+","Fugitives+","Susp+","Uninsured+","Speed+","Speed W+","Reckless+","Drug+","Other+","Cell+","Distracted+",null,"Stops+","CP-In","CP-Out","Locale","Name"]
[]
["Other Totals",null,{"$f":"SUM(IF(FREQUENCY(C2:C3,C2:C3)>0,1))","v":0},{"$f":"SUM(D2:D3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(W2:W3)","v":0}]

{"sheet":"Signature","index":21,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,22,5],[9,0,9,4],[0,0,1,5],[10,0,12,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[8,3,8,4],[18,4,18,5]]}
[{"$f":"Cover!B1","v":"FY 2019/2020 COMPREHENSIVE DUI ENFORCEMENT PROGRAM"}]
[]
["I certify that during the period covered by the payroll listed below, I was working directly on the project, and my rate of compensation, hours worked, and amount earned, are a true and accurate report."]
["OR"]
["If the individual who performed the grant activities is either no longer employeed by the grantee or is on an extended leave of absence, I certify that during the period covered by the payroll listed below, personnel shown was working directly on the project and the rate of compensation, hours worked, and amount earned, are a true and accurate report."]
[]
[]
["   INKED PERSONNEL SIGNATURE ",null,null,null,"DATE"]
["   PRINTED NAME & RANK:"]
[]
["I certify, as the supervisor or as a duly authorized representative that during the period covered by the payroll listed below,  personnel shown were working directly on the project, and their rate of compensation, hours worked, and amount earned, is a true and accurate report.  "]
[]
[]
[]
[]
["   INKED SUPERVISOR SIGNATURE",null,null,null,"DATE"]
["   PRINTED NAME & RANK:"]
[{"$f":"OFFSET(datac!$A$1,0,0,COUNTA(datac!$A:$A),7)","v":"Date#"}]
["City/Town of:",{"$f":"CoverTown","v":"SELECT TOWN"},null,"State Project No:",{"$f":"StateProjNo","v":0}]
[{"$f":"IF(B19=\"DESPP\",CSP!E16,\" \")","v":" "}]

{"sheet":"Recap","index":22,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[[37,0,41,10],[44,0,48,10],[0,6,0,9],[4,0,8,10],[11,0,11,1],[14,0,18,10],[22,0,26,10],[30,0,34,10]]}
["ENFORCEMENT RECAP-FY 2016-2017",null,null,null,null,"Town: ",{"$f":"Cover!C37","v":"SELECT TOWN"}]
[]
["Question 1:  Did your agency conduct roving patrols, DUI checkpoints or both?  What holiday crackdown periods "]
[null,"did your agency participate in, for example TCNY, MD, J4, LABOR?"]
[]
[]
[]
[]
[]
[]
["Question 2:  If you conducted DUI checkpoints, how many did you conduct during the entire project period?"]
[]
[]
["Question 3:  What impact did project activities have on meeting the objectives identified in the project narrative?"]
[]
[]
[]
[]
[]
[]
["Question 4:  How did your DUI arrest totals for the entire project period compare to previous years?  Have you noticed"]
[null,"any trends in alcohol impaired arrests versus drug impaired arrests compared to previous years?"]
[]
[]
[]
[]
[]
[]
["Question 5:  If you were not able to expend the majority of your allocated funding or made very few DUI arrests, please"]
[null,"explain why."]
[]
[]
[]
[]
[]
[]
["Question 6:  What problems did you encounter during the entire project period?"]
[]
[]
[]
[]
[]
[]
["Additional Comments (optional):"]

{"sheet":"Export","index":23,"n_rows":4,"n_cols":29,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["FYSPN","PROJNO","START DATE","TIME PERIOD","AGENCY","DUI/A","DUI/D","DUI/AD","SAF BELTS","SAF WARN","CAR SEAT","FELONY ","RECOVD. CARS","FUG. APPRE.","SUSP. LIC.","UNINS. MOT.","SPEEDING","SPEEDING WARNS","RECKLESS DRIVING","DRUG ARRESTS","OTHER MV CIT.","CELL PHONE","DISTRACTED DRIV","HOURS WRKD","HRS  SAF BELTS","HRS CHKPTS","# CHKPTS","TOTAL COST","DAYS"]
[{"$f":"LEFT(Cover!H37,4)","v":"0"},{"$f":"RIGHT(Cover!H37,7)","v":"0"},null,"TCNY (T)-2019",{"$f":"Cover!C37","v":"SELECT TOWN"},{"$f":"Auto!D4","v":0},{"$f":"Auto!E4","v":0},{"$f":"Auto!F4","v":0},{"$f":"Auto!G4","v":0},{"$f":"Auto!H4","v":0},{"$f":"Auto!I4","v":0},{"$f":"Auto!J4","v":0},{"$f":"Auto!K4","v":0},{"$f":"Auto!L4","v":0},{"$f":"Auto!M4","v":0},{"$f":"Auto!N4","v":0},{"$f":"Auto!O4","v":0},{"$f":"Auto!P4","v":0},{"$f":"Auto!Q4","v":0},{"$f":"Auto!R4","v":0},{"$f":"Auto!S4","v":0},{"$f":"Auto!T4","v":0},{"$f":"Auto!U4","v":0},{"$f":"Auto!F3","v":0},0,0,0,{"$f":"Invoice!R25","v":0},{"$f":"Auto!C3","v":0}]
[{"$f":"LEFT(Cover!H37,4)","v":"0"},{"$f":"RIGHT(Cover!H37,7)","v":"0"},null,"TCNY (H)-2019",{"$f":"Cover!C37","v":"SELECT TOWN"},{"$f":"Holiday!B5","v":0},{"$f":"Holiday!B6","v":0},{"$f":"Holiday!B7","v":0},{"$f":"Holiday!B8","v":0},{"$f":"Holiday!C8","v":0},{"$f":"Holiday!B9","v":0},{"$f":"Holiday!B10","v":0},{"$f":"Holiday!B11","v":0},{"$f":"Holiday!B12","v":0},{"$f":"Holiday!B13","v":0},{"$f":"Holiday!B14","v":0},{"$f":"Holiday!B15","v":0},{"$f":"Holiday!C15","v":0},{"$f":"Holiday!B16","v":0},{"$f":"Holiday!B17","v":0},{"$f":"Holiday!B18","v":0},{"$f":"Holiday!B19","v":0},{"$f":"Holiday!B20","v":0},{"$f":"Holiday!B23","v":0},{"$f":"Holiday!B24","v":0},{"$f":"Holiday!B28","v":0},{"$f":"Holiday!B29","v":0},{"$f":"Holiday!C30","v":0},{"$f":"Holiday!B31","v":0}]
[{"$f":"LEFT(Cover!H37,4)","v":"0"},{"$f":"RIGHT(Cover!H37,7)","v":"0"},null,"EXP1-2019",{"$f":"Cover!C37","v":"SELECT TOWN"},{"$f":"(IF(F2=0,0,F2-F3))","v":0},{"$f":"(IF(G2=0,0,G2-G3))","v":0},0,{"$f":"(IF(I2=0,0,I2-I3))","v":0},0,0,0,{"$f":"(IF(M2=0,0,M2-M3))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Dates2","index":24,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["2019-10-03"]
["2019-10-04"]
["2019-10-05"]
["2019-10-10"]
["2019-10-11"]
["2019-10-12"]
["2019-10-17"]
["2019-10-18"]
["2019-10-19"]
["2019-10-24"]
["2019-10-25"]
["2019-10-26"]
["2019-10-31"]
["2019-11-01"]
["2019-11-02"]
["2019-11-07"]
["2019-11-08"]
["2019-11-09"]
["2019-11-14"]
["2019-11-15"]
["2019-11-16"]
["2019-11-21"]
["2019-11-22"]
["2019-11-23"]
["2019-11-24"]
["2019-11-25"]
["2019-11-26"]
["2019-11-27"]
["2019-11-28"]
["2019-11-29"]
["2019-11-30"]
["2019-12-01"]
["2019-12-05"]
["2019-12-06"]
["2019-12-07"]
["2019-12-12"]
["2019-12-13"]
["2019-12-14"]
["2019-12-15"]
["2019-12-16"]
["2019-12-17"]
["2019-12-18"]
["2019-12-19"]
["2019-12-20"]
["2019-12-21"]
["2019-12-22"]
["2019-12-23"]
["2019-12-24"]
["2019-12-25"]
["2019-12-26"]
["2019-12-27"]
["2019-12-28"]
["2019-12-29"]
["2019-12-30"]
["2019-12-31"]
["2020-01-01"]
["  "]