{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["CONFIR","MENU","REGULATIONS","INSTRUCTIONS","COVER","APPLICATION","PROBLEM ID","OBJECTIVES","ACTIVITIES","BUDGET","MATCH","FRINGE","REIMBURSEMENT","CONTINUATION","AUDIT REQ","CERTS & ASSURANCES","SUMMARY"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":2,"defined_names":15,"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":"CONFIR","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":true,"merged":[[37,0,39,7],[41,0,42,7],[45,3,45,4],[49,0,49,7],[6,2,6,3],[13,4,13,5],[18,0,20,7],[22,0,24,7],[26,0,27,7],[29,0,31,7],[33,0,35,7],[6,4,6,5],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[5,0,5,7]]}
["Connecticut Department of Transportation"]
["Highway Safety Office"]
["2800 Berlin Turnpike PO Box 317546"]
["Newington, CT 06131-7546"]
[]
["GRANT APPROVAL CONFIRMATION"]
[null,"Delivered by email to:  ",{"$f":"APPLICATION!E49","v":0},null,{"$f":"NOW()","v":"2019-10-09T13:07:22.080"}]
[]
[null,"Approved Project Period:",null,null,null,{"$f":"TEXT(REIMBURSEMENT!A13,\"MMMM D, YYYY\")&\"-\"&TEXT(APPLICATION!E27, \"MMMM D, YYYY\")","v":"-September 30, 2020"}]
[null,"State Project Number: ",null,null,null,{"$f":"APPLICATION!C5","v":0}]
[null,"Project Name:",null,null,null,{"$f":"APPLICATION!A15","v":0}]
[null,"Governmental Unit:",null,null,null,{"$f":"APPLICATION!A18","v":0}]
[null,"Applicant:",null,null,null,{"$f":"APPLICATION!A21","v":0}]
[null,"Federal Funds:",null,null,{"$f":"SUMMARY!F13","v":0}]
[null,"Straight time Fringe Rate Percentage",null,null,null,{"$f":"FRINGE!F30","v":0}]
[null,"Overtime Fringe Rate Percentage",null,null,null,{"$f":"FRINGE!H30","v":0}]
[null,"CFDA:",null,null,null,"20.___"]
[]
[{"$f":"\"The Department of Transportation would like to notify you of the approval of the \"&APPLICATION!A18&\"'s\"&\" \"&\"\"&\"Highway Safety project application entitled \"&APPLICATION!A15&\" effective:  \"&TEXT(REIMBURSEMENT!A13,\"MMMM D, YYYY\")&\"\"&\" through \"&TEXT(APPLICATION!E27,\"MMMM D, YYYY\")&\".\"","v":"The Department of Transportation would like to notify you of the approval of the 's Highway Safety project application entitled  effective:   through September 30, 2020."}]
[]
[]
[]
[{"$f":"\"Federal funds in the amount of \"&TEXT(SUMMARY!F11,\"$#,##0.00\")&\" are allocated to this project in accordance with the approved 2020 Fiscal Year Connecticut Highway Safety Plan.  The total project cost may not exceed this amount for the approved project period.\"","v":"Federal funds in the amount of $0.00 are allocated to this project in accordance with the approved 2020 Fiscal Year Connecticut Highway Safety Plan.  The total project cost may not exceed this amount for the approved project period."}]
[]
[]
[]
["All grants greater than or equal to $25,000 are subject to FFATA (Federal Funding Accountability and Transparency Act) sub-award reporting requirements. For more information go to: https://www.fsrs.gov/#a-faqs. \n"]
[]
[]
["All costs incurred under this project must be in full compliance with both federal and State regulations, policies, and procedures that govern the use of highway safety funds.  Costs are subject to review by both Internal and External Auditors"]
[]
[]
[]
["Please note that deviations from the specifics of the approved budget must be reviewed and approved by the Highway Safety Office prior to their implementation in order for related costs to be eligible for reimbursement.  "]
[]
[]
[]
[]
[]
[]
[]
["If you have any additional questions or concerns regarding this program, please contact me at 860-594-2412."]
[]
[]
[]
["cc'd by email to:",null,null,"Joseph T. Cristalli"]
[{"$f":"APPLICATION!E33","v":0},null,null,"Transportation Principal Safety Program Coordinator"]
[{"$f":"APPLICATION!E41","v":0}]
[]
["PRINT CONFIRMATION AND GRANT FOR YOUR OWN RECORDS"]

{"sheet":"MENU","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"MENU"]
[]
[null,"CONFIR sheet in this workbook is set as xlSheetVeryHidden.  The HideSheets macro allows the user to toggle this sheet between hidden and visible. This macro is assigned to the Unlock/Lock button. The user must supply a password. \n\nThe Auto_Close macro runs automatically when the user attempts to close the book. It hides the two sheets and prompts the user to save.\n\nThis is not intended to be a highly secure method of hiding and protecting data, but could be used to stop casual users from accessing the sheets.\n"]

{"sheet":"REGULATIONS","index":2,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,0,3,2],[0,0,0,2]]}
["REGULATIONS GOVERNING HIGHWAY SAFETY PROJECTS"]
[]
["PURPOSE"]
["To provide potential Highway Safety Funding recipients with a comprehensive listing of regulations governing the administration of an approved highway safety project."]
[]
["GENERAL REGULATIONS"]
[1,null,"The grant shall be administered by a governmental agency, either local or state, having authority and responsibility to conduct the project."]
[2,null,"Grant expenditures must meet the following criteria:"]
[null,"A.","Supplement rather than replace existing activities."]
[null,"B.","Be necessary and reasonable, and supported in the budget narrative."]
[null,"C.","Be eligible expenses under federal, state and local laws/regulations."]
[null,"D.","Conform to the USDOT Federal Common Rule."]
[null,"E.","Be accorded consistent treatment through the application of generally accepted accounting principles."]
[null,"F.","Not be included as a cost of any other federally financed program."]
[null,"G.","Be net of all applicable credits."]
[null,"H.","Incur within an approved grant period."]
[null,"I.","Be adequately supported by source documentation."]
[null,"J.","Not result in a profit to the grantee."]
[3,null,"All state agencies must have state budget authority to accept highway safety funds."]
[4,null,"Only expenses contained within an approved grant budget may be claimed.  Any deviations from the approved budget must have prior Highway Safety Office (HSO) approval to be eligible for reimbursement.  Back-up documentation (i.e. fully executed time distribution report) and proof of payment (i.e. cancelled checks) must accompany request for reimbursement."]
[5,null,"All source documentation for incurred costs must be maintained for review purposes for a three year period following the final reimbursement of the project."]
[6,null,"All travel costs outside the state, extensive in-state trips, and conference registrations shall have prior written  approval of HSO."]
[7,null,"All agencies shall use purchasing practices and bid procedures that provide maximum open and free competition.  In addition, positive efforts should be in effect to utilize small business and minority-owned business sources of supplies and services.  The Minority Business Enterprise requirements of Title 49 Code of Federal Regulations (CFR) Part 23 apply to this project. "]
[8,null,"The APPLICANT shall comply with the regulations of the United States Department of Transportation (Title 49, CFR, Part 21), issued in implementation of Title VI of the Civil Rights Act of 1964, 78 Stat. 252, 42 United States Code 2000d to 2000d-4.  Further, the APPLICANT agrees and warrants that in the performance of this project, it will not discriminate or permit discrimination against any person or group of persons on the grounds of race, color, religion, national origin, sex, sexual orientation, or physical disability, including but not limited to blindness, unless it is shown to be that such disability prevents performance of the work involved, in any manner prohibited by the laws of the United States, or the State of Connecticut, and further agrees to provide the Commission on Human Rights and Opportunities with such information requested by the Commission concerning the employment practices and procedures of the APPLICANT as related to the provisions of this section. (Section 4-114a and 4a-60a of the Connecticut General Statutes, as revised.)"]
[9,null,"Purchases must be in accordance with normal state and/or agency and/or town procedures.  Purchases must also be in accordance with the requirements set forth in the Procurement Standards (based on \"OMB Circular A-102, Attachment O\"), available upon request.  Conformance with the \"Buy America Act\" (23 U.S.C. 101 Note and 41 U.S.C. 10a) is required."]
[10,null,"It is a requirement that all applicants comply with the \"Drug Free Workplace Act of 1988\" (Title 49 CFR Part 29 Subpart F)."]
[11,null,"The Highway Safety Office MUST be notified (in writing) within thirty (30) days of the receipt of any equipment.  Information provided shall consist of:  name, model, serial number, cost, date of delivery taken, and a brief description of each article purchased.  After the expiration date of this project, all non-expendable equipment purchased under this project will continue to  be used in a Highway Safety-related effort.  The APPLICANT shall notify the Highway Safety Office immediately if any equipment purchased under this project ceases to be used in the manner set forth in this project application.  In such event, the APPLICANT agrees to refund the residual value of such equipment in an amount to be determined by the Highway Safety Office, or to transfer or otherwise dispose of such equipment as directed by the Highway Safety Office.  NO EQUIPMENT WILL BE CONVEYED, SOLD, SALVAGED, TRANSFERRED, OR OTHERWISE BE USED OTHER THAN EXPRESSLY DETAILED IN THIS APPLICATION WITHOUT THE EXPRESS WRITTEN APPROVAL OF THE HIGHWAY SAFETY OFFICE."]
[12,null,"The APPLICANT shall maintain or cause to be maintained for its useful life, any equipment purchased under this project. Standard procedures governing the ownership, use, and disposition of equipment acquired under this project are covered in the Property Management Standards (based on \"OMB Circular A-102, Attachment N\")."]
[13,null,"Any contracts entered into as part of this project's performance must receive written approval PRIOR to contract award."]
[14,null,"Should the APPLICANT agency be audited, and the responsible unit, department, etc. of the grant be included as part of such audit, a copy of that applicable section [of said audit] must be forwarded to the Highway Safety Office."]
["ORIENTATION MEETING"]
[null,null,"First time approved applicants may be required to participate in an orientation meeting to discuss program requirements."]
["MONITORING REVIEWS"]
[null,null,"HSO may conduct a monitoring review of your highway safety project. The purpose of this review is to determine adherence to stated project objectives, to review financial procedures, and to ensure compliance with federal regulations."]
["COST REIMBURSEMENT"]
[1,null,"Highway safety projects are funded on a cost reimbursement concept.  An agency expends its own funds and then proceeds to claim reimbursement for the federal share of incurred project costs."]
[2,null,"It is the responsibility of the project director to ensure that reimbursement requests are submitted on a timely basis."]
[3,null,"ALL FINAL CLAIMS against this project, together with all supporting financial documentation, MUST be submitted to the Connecticut Highway Safety Office no later than forty-five (45) days after the funding period ending date."]
["COST DOCUMENTATION"]
[null,null,"The accounting system and cost documentation presently in use by an agency is generally adequate for project purposes.  If modification is necessary,  HSO will notify you and assistance will be provided."]
["PROJECT TERMINATION"]
[null,null,"A project may be terminated if HSO concludes that the grantee is not in compliance with the conditions or provisions of a grant.  HSO will extend an opportunity for the grantee to demonstrate compliance.  Notification of termination will be in writing."]

{"sheet":"INSTRUCTIONS","index":3,"n_rows":78,"n_cols":5,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,4],[31,0,31,4],[28,0,28,4],[37,0,37,4],[1,0,1,4],[2,0,2,4],[26,0,26,4],[77,0,81,4],[63,0,63,4],[56,0,56,4],[27,0,27,4],[65,0,65,4],[59,3,59,4],[34,0,34,4],[47,3,47,4],[50,3,50,4],[54,3,54,4],[58,3,58,4]]}
["INSTRUCTIONS FOR COMPLETING APPLICATION FORM"]
["NOTE: ONLY ENTER THE DATA IN YELLOW HIGHLIGHTED FIELDS"]
["INSTRUCTIONS FOR APPLICATION TAB"]
["1)","PROJECT TITLE"]
[null,null,null,null,"Enter a brief title of the program.  Example, \"FY20 DUI Enforcement Program.\""]
["2)","GOVERNMENTAL UNIT"]
[null,null,null,null,"Enter the name of the political jurisdiction responsible for the overall administration of the project (state agency, municipality, university)."]
["3)","ADDRESS OF GOVERNMENTAL UNIT"]
[null,null,null,null,"Enter the complete address of the governmental unit, including zip code and four digit extension"]
["4)","APPLICANT"]
[null,null,null,null,"Enter the organizational unit responsible for the administration of the project, (i.e.: police department).  "]
["5)","ADDRESS OF APPLICANT"]
[null,null,null,null,"Enter the complete address of the applicant including zip code and 4-digit extension"]
["6)","FEDERAL IDENTIFICATION NUMBER (FEIN):"]
[null,null,null,null,"Enter the nine-digit number assigned by the U.S. Department of Treasury, Internal Revenue Service, for tax reporting purposes. "]
["7)","DATA UNIVERSAL NUMBERING SYSTEM (DUNS):"]
[null,null,null,null,"Enter your assigned unique global business identification number."]
["8)","ANTICIPATED GRANT START-UP DATE (Month/Day/Year)"]
[null,null,null,null,"Enter the anticipated project start-up date."]
["9)","APPLICANT APPROVALS:"]
[null,null,"(i)","PROJECT DIRECTOR"]
[null,null,null,null,"Enter the full NAME, TITLE, ADDRESS, EMAIL ADDRESS, and TELEPHONE NUMBER of the person responsible for the overall administration of the project."]
[null,null,"(ii)","FINANCIAL OFFICER"]
[null,null,null,null,"Enter the full NAME, TITLE, ADDRESS, EMAIL ADDRESS, and TELEPHONE NUMBER of the person responsible for the overall fiscal administration of the project. "]
[null,null,"(iii)","AUTHORIZING OFFICIAL OF GOVERNMENTAL UNIT"]
[null,null,null,null,"Enter the NAME, TITLE, ADDRESS, EMAIL ADDRESS, and TELEPHONE NUMBER of the chief executive officer of the political subdivision (mayor, town manager, chief of police, university official, or state agency head).  The Authorizing Official, by his or her signature, assures that all Equal Employment Opportunity requirements will be met when the project is carried out. "]
["NOTE: APPLICATION MUST BE SUBMITTED WITH ORIGINAL SIGNATURES"]
[]
["INSTRUCTIONS FOR PROBLEM TAB"]
["10)","STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
[null,null,null,null,"Describe in detail, the specific problem to be corrected or impacted. Indicate the reason your current program or activity is not adequate and explain past efforts to resolve the problem.  Provide supporting data, facts, or statistics that will substantiate the need for the requested project."]
["INSTRUCTIONS FOR OBJECTIVES TAB"]
["11)","OBJECTIVES"]
[null,null,null,null,"Describe the objectives to be accomplished during this project.  The objectives should be specific, clearly written, measurable, achievable, and time-based. If personnel costs are included, be certain to include each job title along with a brief description of duties pertaining to the project.  The project will be evaluated on the approved objectives."]
["INSTRUCTIONS FOR ACTIVITIES TAB"]
["12)","ACTIVITIES AND PROCEDURES"]
[null,null,null,null,"Describe activities and procedures you will undertake to achieve each objective.  Identify project personnel and responsibilities.  Include activity timelines."]
["INSTRUCTIONS FOR BUDGET/MATCH TABS"]
["13)","BUDGET DETAILS"]
[null,null,null,null,"The budget must contain a detailed list of the total proposed expenditures.  The budget detail is to be prepared using the following cost categories for each participating agency.  "]
[null,null,"A.","PERSONNEL COSTS"]
[null,null,null,"A1)","Salaries and wages"]
[null,null,null,null,"Include each employees' position title, their grant-approved hourly rate, weekly scheduled hours, percentage allocated to grant, and number of pay periods from grant start date to grant end date. If budgeting a different hourly rate for the same position, use the separate column and provide the number of pay periods at each rate. Salary total will calculate through. (NOTE: Be certain to include position and description in your \"OBJECTIVES\" tab narrative.) "]
[null,null,null,"A2)","Fringe Benefits (IF APPLICABLE)"]
[null,null,null,null,"For fringe benefit reimbursement, you must complete the Fringe Benefit worksheet/tab (FRINGE). Once you complete this worksheet, you will have the option to choose from the drop-down list, the rate that is applicable to that position title. "]
[null,null,"B","TRAVEL"]
[null,null,null,null,"ALL TRAVEL MUST BE PRE-APPROVED BY THE HSO. When budgeting travel costs, consider all expenses that may be reimbursable (e.g. airfare/train/mileage/parking, baggage fees, lodging, meals, and registration, etc.) The HSO Pre-Approval Travel Authorization Form must be used when submitting travel requests. Double click on the icon below to see the HSO Policy and Procedures document, which includes the travel policy and forms."]
[null,null,"C"," CONTRACTUAL SERVICES"]
[null,null,null,null,"Contractual services are services of individual consultants or consulting firms engaged in performing special services pertinent to highway safety. "]
[null,null,null,null,"The HSO must approve any contract for services before the contract is finalized."]
[null,null,"D","OPERATING/SUPPLIES COSTS"]
[null,null,null,null,"This would include materials and supplies used directly on and for the project during the project period (e.g. office supplies, postage, printing, etc.). Itemize each cost and provide detail including quantities and per item cost. "]
[null,null,"E","EQUIPMENT"]
[null,null,null,null,"Identify all equipment to be purchased for the project.  Only items specifically detailed in the budget will be eligible for reimbursement.  Equipment purchased with project grant funding must be specifically used for the purpose it was acquired, throughout its useful life.  Any equipment purchased through a state agency-administered project must also adhere to all state equipment control procedures. "]
[null,null,"F","INDIRECT COSTS"]
[null,null,null,null,"To increase the benefits of the limited federal funds available for individual projects, the Highway Safety Office discourages the inclusion of this cost category. However, if an agency chooses to charge their own, federally-approved indirect rate they will need to provide the HSO with a current and signed agreement."]
["INSTRUCTIONS FOR CONTINUATION TAB"]
["14)","CONTINUATION AND COST ASSUMPTION"]
[null,null,null,"Describe how project activities will be supported when federal participation ends (if warranted). "]
[null,null,null,"The HSO shall obligate federal funds for this project, based on the following criteria:"]
[null,null,null,"(i)","Availability of Federal Funds"]
[null,null,null,"(ii)","Measured success in meeting project objectives as determined"]
[null,null,null,"(iii)","Continued significance in meeting the goals and objectives of Connecticut's Highway Safety Plan."]
["If successful, as determined by the HSO, the Applicant Agency and Governmental Unit intends to continue this effort beyond the termination of federal funding."]
[]
["INSTRUCTIONS FOR AUDIT REQ/CERT ASSURANCE TABS:"]
["15)",null,null,null,"INSTRUCTION ARE AVAILABLE ON THE PAGES."]
[null,"FORM SUBMISSION INSTRUCTIONS"]
[null,null,null,null,"Submit a minimum of one typed application with original signatures."]
[null,null,null,null,"State of Connecticut "]
[null,null,null,null,"Department of Transportation"]
[null,null,null,null,"Highway Safety Office "]
[null,null,null,null,"Attn: Joseph Cristalli"]
[null,null,null,null,"2800 Berlin Turnpike"]
[null,null,null,null,"P.O. Box 317546"]
[null,null,null,null,"Newington, Connecticut   06131-7546"]
[]
["If you have any questions regarding completion of the HSO highway safety project application, please call 860-594-2412.  If your application is approved, the Governor's Highway Safety Representative will sign your project application on page 1 beneath your agency's signatures.  The project application will then become a project agreement.  An approval letter will be sent to your agency and copy of the executed project agreement will be sent to the project director."]

{"sheet":"COVER","index":4,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[[19,0,19,9],[20,0,20,9],[28,0,29,9],[31,0,31,9],[21,0,21,9],[18,0,18,9],[0,0,0,9],[15,0,15,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9]]}
["State of Connecticut Department of Transportation"]
[]
["HIGHWAY SAFETY OFFICE"]
["2800 Berlin Turnpike"]
["P.O. BOX 317546"]
["Newington, Connecticut  06131-7546"]
["(860) 594-2412"]
[]
[]
[]
[]
[]
[]
[]
[]
["HIGHWAY SAFETY GRANT APPLICATION"]
[]
[]
["All shaded portions of this application will be"]
["completed by the Highway Safety Office and DOT Fiscal Office."]
["Please do not print or type in these shaded areas."]
["Fill-in all yellow shading."]
[]
[]
[]
[]
[]
[]
["HSO"]
[]
[]
["Highway Safety Office"]

{"sheet":"APPLICATION","index":5,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[[10,0,12,5],[14,0,15,5],[0,4,0,5],[0,1,1,3],[2,1,2,3],[3,1,3,3],[3,4,9,5],[4,1,5,1],[4,2,5,3],[6,1,7,1],[6,2,7,3],[8,1,9,1],[8,2,9,3],[16,0,16,2],[28,2,30,3],[17,0,18,2],[20,0,21,2],[17,3,18,5],[20,3,21,5],[25,0,25,5],[23,3,24,5],[19,0,19,2],[23,1,24,2],[23,0,24,0],[22,1,22,2],[26,4,26,5],[26,1,26,2],[40,2,42,3],[40,0,42,1],[32,0,34,1],[36,0,38,1],[28,4,28,5],[32,4,34,5],[40,4,42,5],[30,4,30,5],[28,0,30,1],[36,2,38,3],[36,4,36,5],[38,4,38,5],[32,2,34,3],[58,2,58,4],[55,2,55,4],[48,2,50,3],[44,2,46,3],[52,2,52,4],[44,4,44,5],[46,4,46,5],[51,0,51,5],[53,2,53,4],[54,2,54,4],[56,2,56,4],[44,0,46,1],[48,0,50,1],[48,4,50,5]]}
[null,"FY 2020 HIGHWAY SAFETY PROJECT APPLICATION",null,null,"CT-DOT/HSO"]
[null,null,null,null,"FORM"," HS-1"]
[null,"CT DEPARTMENT OF TRANSPORTATION",null,null,"CFDA #"]
[null,"SHADED AREA FOR HSO USE ONLY",null,null,"HSO Stamp"]
[null,"PROJECT NO:"]
[]
["REVISION:","PROGRAM AREA:"]
["2019-10-09"]
["EXPIRES:","PROGRAM AREA DESCRIPTION:"]
["2020-09-30"]
["ACCEPTANCE -- IT IS UNDERSTOOD AND AGREED BY THE UNDERSIGNED THAT FUNDS RECEIVED AS A RESULT OF THIS APPLICATION IS SUBJECT TO THE REGULATIONS GOVERNING HIGHWAY SAFETY PROJECTS.  THIS AGREEMENT MAY BE TERMINATED BY EITHER PARTY IN ACCORDANCE WITH TRANSPORTATION SAFETY SECTION POLICY.  COPY OF POLICY OBTAINED UPON REQUEST."]
[]
[]
["  PROJECT TITLE:"]
[]
[]
["  GOVERNMENTAL UNIT:",null,null,"  ADDRESS OF GOVERNMENTAL UNIT:"]
[]
[]
["  APPLICANT:",null,null,"  ADDRESS OF APPLICANT:"]
[]
[]
["FEIN:","DUNS NUMBER:",null,"  ANTICIPATED PROJECT STARTUP DATE:"]
[]
[]
["APPROVED PROJECT PERIOD:   ( mo/date/yr )  FOR HSO USE ONLY"]
["FROM: ",null,null,"THROUGH: ","2020-09-30"]
["  PROJECT DIRECTOR:",null,"  TITLE:",null,"  TELEPHONE NUMBER:"]
[]
[null,null,null,null,"  FAX NUMBER:"]
[]
["  SIGNATURE:",null,"  ADDRESS & ZIP CODE:",null," E-MAIL ADDRESS:"]
[]
[]
[]
["  FISCAL OFFICER:",null,"  TITLE:",null,"  TELEPHONE NUMBER:"]
[]
[null,null,null,null,"  FAX NUMBER:"]
[]
["  SIGNATURE:",null,"  ADDRESS & ZIP CODE:",null," E-MAIL ADDRESS:"]
[]
[]
[]
["  AUTHORIZING OFFICIAL OF GOVERNMENTAL UNIT:",null,"  TITLE:",null,"  TELEPHONE NUMBER:"]
[]
[null,null,null,null,"  FAX NUMBER:"]
[]
["  SIGNATURE:",null,"  ADDRESS & ZIP CODE:",null," E-MAIL ADDRESS:"]
[]
[]
[]
["  APPROVAL --  FOR HSO USE ONLY"]
[" FISCAL REVIEW COMPLETED BY:",null,"PROJECT MANAGER REVIEW COMPLETED BY:",null,null,"  DATE:"]
[]
["Christine Biske",null,"  PROGRAM COORDINATOR REVIEW COMPLETED BY:",null,null,"  DATE:"]
[" DATE:",null,"Joseph T. Cristalli, Jr."]
["REQUESTED AMOUNT",{"$f":"BUDGET!F56","v":0},"GOVERNOR'S HIGHWAY SAFETY REP:",null,null,"  DATE:"]
["HSO APPROVED $"]
["TOTAL ALLOTTED: ",null,"Thomas J. Maziarz"]

{"sheet":"PROBLEM ID","index":6,"n_rows":226,"n_cols":6,"rows_kept":226,"cut":false,"hidden":false,"merged":[[109,3,110,5],[64,0,107,5],[109,0,110,2],[111,0,114,2],[111,3,112,5],[113,3,114,4],[113,5,114,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,4],[4,5,5,5],[12,0,53,5],[55,0,56,2],[55,3,56,5],[57,0,60,2],[57,3,58,5],[59,3,60,4],[59,5,60,5],[118,0,161,5],[163,0,164,2],[163,3,164,5],[165,0,168,2],[165,3,166,5],[167,3,168,4],[167,5,168,5],[226,0,269,5],[172,0,215,5],[217,0,218,2],[217,3,218,5],[219,0,222,2],[219,3,220,5],[221,3,222,4],[221,5,222,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"PROBLEM ID"},null,"PAGE 1 OF 5"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
["PROBLEM IDENTIFICATION"]
["Describe in detail the specific problem to be corrected or impacted."]
["Indicate the reason your current program or activity is not adequate and explain past efforts to resolve the problem. "]
["Provide supporting data, facts, or statistics that will substantiate the need for requested project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"PROBLEM ID"},null,"PAGE 2 OF 5"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
["PROBLEM IDENTIFICATION (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"PROBLEM ID"},null,"PAGE 3 OF 5"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
["PROBLEM IDENTIFICATION (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"PROBLEM ID"},null,"PAGE 4 OF 5"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
["PROBLEM IDENTIFICATION (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"PROBLEM ID"},null,"PAGE 5 OF 5"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["STATEMENT OF THE PROBLEM AND BACKGROUND INFORMATION"]
["PROBLEM IDENTIFICATION (CONT.):"]

{"sheet":"OBJECTIVES","index":7,"n_rows":180,"n_cols":6,"rows_kept":180,"cut":false,"hidden":false,"merged":[[66,0,113,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,4],[4,5,5,5],[10,0,56,5],[58,0,59,2],[58,3,59,5],[60,0,63,2],[60,3,61,5],[62,3,63,4],[62,5,63,5],[115,0,116,2],[115,3,116,5],[117,0,120,2],[117,3,118,5],[119,3,120,4],[119,5,120,5],[180,0,227,5],[123,0,170,5],[172,0,173,2],[172,3,173,5],[174,0,177,2],[174,3,175,5],[176,3,177,4],[176,5,177,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"OBJECTIVES"},null,"PAGE 1 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["OBJECTIVES"]
["Describe the objectives to be accomplished during this project."]
["The objectives should be specific, clearly written, measurable, and time-framed.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B59),FIND(\"]\",CELL(\"filename\",B59))+1,255)","v":"OBJECTIVES"},null,"PAGE 2 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["OBJECTIVES (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B116),FIND(\"]\",CELL(\"filename\",B116))+1,255)","v":"OBJECTIVES"},null,"PAGE 3 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["OBJECTIVES (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B173),FIND(\"]\",CELL(\"filename\",B173))+1,255)","v":"OBJECTIVES"},null,"PAGE 4 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["OBJECTIVES (CONT.):"]

{"sheet":"ACTIVITIES","index":8,"n_rows":180,"n_cols":6,"rows_kept":180,"cut":false,"hidden":false,"merged":[[10,0,56,5],[66,0,113,5],[58,0,59,2],[58,3,59,5],[60,0,63,2],[60,3,61,5],[62,3,63,4],[62,5,63,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,4],[4,5,5,5],[115,0,116,2],[115,3,116,5],[117,0,120,2],[117,3,118,5],[119,3,120,4],[119,5,120,5],[180,0,227,5],[123,0,170,5],[172,0,173,2],[172,3,173,5],[174,0,177,2],[174,3,175,5],[176,3,177,4],[176,5,177,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"ACTIVITIES"},null,"PAGE 1 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["ACTIVITIES"]
["Describe activities and procedures you will undertake to achieve each objective. "]
["Identify project personnel and responsibilities.  Include activity timelines."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B59),FIND(\"]\",CELL(\"filename\",B59))+1,255)","v":"ACTIVITIES"},null,"PAGE 2 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["ACTIVITIES (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B116),FIND(\"]\",CELL(\"filename\",B116))+1,255)","v":"ACTIVITIES"},null,"PAGE 3 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["ACTIVITIES (CONT.):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B173),FIND(\"]\",CELL(\"filename\",B173))+1,255)","v":"ACTIVITIES"},null,"PAGE 4 OF 4"]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["ACTIVITIES (CONT.):"]

{"sheet":"BUDGET","index":9,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[53,2,53,5],[52,2,52,5],[51,5,51,10],[52,6,52,9],[53,6,53,9],[51,1,51,4],[55,0,55,4],[56,0,58,11],[55,5,55,11],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[43,6,43,10],[37,6,37,10],[31,6,31,10],[25,6,25,10],[19,3,19,10],[26,2,26,9],[27,2,30,9],[45,2,50,9],[0,0,1,3],[2,0,5,3],[0,4,1,11],[2,4,3,11],[4,4,5,11],[8,1,8,2],[39,2,42,9],[44,2,44,9],[6,0,7,11],[25,1,25,4],[31,1,31,4],[37,1,37,4],[43,1,43,4],[32,2,32,9],[33,2,36,9],[38,2,38,9],[20,2,20,9],[21,2,24,9]]}
["PROJECT TITLE",null,null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"BUDGET"}]
[]
["BUDGET DETAIL FOR ITEMS THAT ARE CHARGED TO THIS GRANT"]
[]
["A.","Personnel Cost:     Positions #",null,1,2,3,4,5,6,7,8]
[null,"Position Title"]
[null,"Hourly rate"]
[null,"Pay Period Scheduled Hours"]
[null,"Hours allotted for this grant"]
[null,"Number of Pay Periods"]
[null,"A1","Salary Total",{"$f":"D11*D13*D14","v":0},{"$f":"E11*E13*E14","v":0},0,0,0,0,0,0]
[null,null,"Fringe Rate %"]
[null,null,"Fringe Rate (Individual %)"]
[null,"A2","Fringe Amount $",{"$f":"IF(D17>0%,D15*D17,D15*D16)","v":0},{"$f":"IF(E17>0%,E15*E17,E15*E16)","v":0},0,0,0,0,0,0]
[null,null,"Salary and Fringe Total",{"$f":"D15+D18","v":0},{"$f":"E15+E18","v":0},{"$f":"F15+F18","v":0},{"$f":"G15+G18","v":0},0,0,0,{"$f":"K15+K18","v":0}]
[null,"Personnel Cost Total:",null,{"$f":"D19+E19+F19+G19+H19+I19+J19+K19","v":0}]
[null,null,"Additional Notes Regarding Personnel Costs:"]
[]
[]
[]
[]
["B.","Travel*",null,null,null,null,{"$f":"F26","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["C.","Contractual Services",null,null,null,null,{"$f":"F32","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["D.","Operating/Supplies Costs",null,null,null,null,{"$f":"F38","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["E.","Equipment",null,null,null,null,{"$f":"F44","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
[]
[]
["F.","Indirect Cost:",null,null,null,{"$f":"G53*G54","v":0}]
[null,null,"Indirect Rate",null,null,null,0]
[null,null,"Sum of Indirect Cost Applicable Categories",null,null,null,0]
[]
["Total Project Cost:",null,null,null,null,{"$f":"D20+G26+G32+G38+G44+F52","v":0}]
[" * ALL TRAVEL EXPENSES REQUIRE PRE-APPROVAL FROM THE CONNECTICUT HIGHWAY SAFETY OFFICE TRANSPORTATION PRINCIPALSAFETY PROGRAM MANAGER"]

{"sheet":"MATCH","index":10,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[39,2,42,9],[54,0,56,11],[49,1,49,4],[49,5,49,10],[50,2,50,5],[50,6,50,9],[51,2,51,5],[51,6,51,9],[53,0,53,4],[53,5,53,11],[43,1,43,4],[43,6,43,10],[44,2,44,9],[45,2,48,9],[33,2,36,9],[37,1,37,4],[37,6,37,10],[38,2,38,9],[26,2,26,9],[27,2,30,9],[31,1,31,4],[31,6,31,10],[32,2,32,9],[6,0,7,11],[19,3,19,10],[25,1,25,4],[25,6,25,10],[13,1,13,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[20,2,20,9],[21,2,24,9],[0,0,1,3],[2,0,5,3],[0,4,1,11],[2,4,3,11],[4,4,5,11]]}
["PROJECT TITLE",null,null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"MATCH"}]
[]
["BUDGET DETAIL FOR ITEMS THAT ARE SUBMITTED FOR MATCH FOR THIS GRANT"]
[]
["A.","Personnel Cost:        Positions # ",null,1,2,3,4,5,6,7,8]
[null,"Position Title"]
[null,"Hourly rate"]
[null,"Pay Period Scheduled Hours"]
[null,"Match Hours allotted for this grant"]
[null,"Number of Pay Periods"]
[null,"A1","Salary Total",{"$f":"D11*D13*D14","v":0},{"$f":"E11*E13*E14","v":0},0,0,0,0,0,0]
[null,null,"Fringe Rate %"]
[null,null,"Fringe Rate (Individual %)"]
[null,"A2","Fringe Amount $",{"$f":"IF(D17>0%,D15*D17,D15*D16)","v":0},{"$f":"IF(E17>0%,E15*E17,E15*E16)","v":0},0,0,0,0,0,0]
[null,null,"Salary and Fringe Total",{"$f":"D15+D18","v":0},{"$f":"E15+E18","v":0},0,0,0,0,0,{"$f":"K15+K18","v":0}]
[null,"Personnel Cost Total:",null,{"$f":"D19+E19+F19+G19+H19+I19+J19+K19","v":0}]
[null,null,"Additional Notes Regarding Personnel Costs:"]
[]
[]
[]
[]
["B.","Travel*",null,null,null,null,{"$f":"F26","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["C.","Contractual Services",null,null,null,null,{"$f":"F32","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["D.","Operating/Supplies Costs",null,null,null,null,{"$f":"F38","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["E.","Equipment",null,null,null,null,{"$f":"F44","v":0}]
[null,null,"Description:"]
[]
[]
[]
[]
["F.","Indirect Cost:",null,null,null,{"$f":"G51*G52","v":0}]
[null,null,"Indirect Rate",null,null,null,0]
[null,null,"Sum of Indirect Cost Applicable Categories",null,null,null,0]
[]
["Total Match:",null,null,null,null,{"$f":"D20+G26+G32+G38+G44+F50","v":0}]
[" * ALL TRAVEL EXPENSES REQUIRE PRE-APPROVAL FROM THE CONNECTICUT HIGHWAY SAFETY OFFICE TRANSPORTATION PRINCIPALSAFETY PROGRAM MANAGER"]

{"sheet":"FRINGE","index":11,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[17,11,18,14],[20,1,20,3],[21,1,21,3],[22,1,22,3],[7,0,7,9],[18,1,18,3],[19,1,19,3],[10,0,10,9],[15,6,15,8],[15,2,15,4],[12,0,12,9],[13,4,13,9],[13,0,13,3],[17,1,17,3],[22,7,22,9],[17,7,17,9],[18,7,18,9],[0,0,1,4],[0,5,1,9],[2,0,5,4],[2,5,3,9],[4,5,5,9],[26,1,26,3],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[37,2,37,4],[37,6,37,8],[33,0,33,9],[19,7,19,9],[20,7,20,9],[21,7,21,9],[35,2,35,4],[35,6,35,8],[27,7,27,9],[29,7,29,9],[31,0,31,9],[29,0,29,3],[23,1,23,3],[24,1,24,3],[27,1,27,3],[25,1,25,3]]}
["PROJECT TITLE",null,null,null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"FRINGE"}]
[]
[]
["FRINGE BENEFIT CERTIFICATION STATEMENT"]
[]
[]
["NOTE: If fringe rate is being charged/reimbursed, this page should be completed and signed. Fringe benefit charges should NOT be included in the hourly rate. No hourly rate should be inflated--all hourly rates should be reported as actuals."]
[]
["I hereby certify that the information below is the true and accurate and authorized by the City/Town/Agency of   "]
[{"$f":"F3","v":""},null,null,null,"for hours worked by personnel for the following time period:"]
[]
[null,"FROM Date:",null,null,null,"TO Date:"]
[]
["#","Actual Cost Category",null,null,"Straight Time Percentage","*Submitting for Reimbursement","Overtime Percentage","*Submitting for Reimbursement",null,null,null,"* Please be sure to select \"YES\" or \"NO\" in the \"Submitting for Reimbursement\" column"]
[1,null,null,null,0,null,0]
[2,null,null,null,0,null,0]
[3,null,null,null,0,null,0]
[4,null,null,null,0,null,0]
[5,null,null,null,0,null,0]
[6,null,null,null,0,null,0]
[7,null,null,null,0,null,0]
[8,null,null,null,0,null,0]
[9,null,null,null,0,null,0]
[10,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"St FR",{"$f":"F30","v":0}]
["Total Fringe Rate",null,null,null,{"$f":"SUM(E19:E28)","v":0},{"$f":"SUMIF(F19:F28,\"YES\",E19:E28)","v":0},{"$f":"SUM(G19:G28)","v":0},{"$f":"SUMIF(H19:J28,\"YES\",G19:G28)","v":0},null,null,null,null,null,"Ot FR",{"$f":"H30","v":0}]
[]
["I further certify that this statement is correct in all respects and that the fringe benefit rate(s) identified above accurately represents the fringe benefit costs to the city/town/agency for the individuals employed under or working on this project."]
[]
["City/Town/Agency's Chief Financial Officer or Authorized Official"]
[]
[null,"Name (Please Print):",null,null,null,"Ink Signature:"]
[]
[null,"Title:",null,null,null,"Date:"]

{"sheet":"REIMBURSEMENT","index":12,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[7,0,7,5],[46,1,50,4],[11,0,11,1],[11,2,11,3],[11,4,11,5],[12,0,13,1],[12,2,13,3],[12,4,13,5],[9,0,9,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"REIMBURSEMENT"}]
[]
[]
["PROJECT EXPENDITURES --- REIMBURSEMENT REQUIREMENTS"]
[]
["NOTE:  This is a federally reimbursable program. The cost of all expenses incurred under this project must first be paid for with municipal or state agency funds. The sub-grantee may then apply for reimbursement based on the procedures and policies listed below."]
[]
["Project Start Date",null,"Project Ending Date",null,"Reimbursement Deadline"]
[{"$f":"IF(APPLICATION!D24>1,APPLICATION!D24,\"\")","v":""},null,{"$f":"APPLICATION!E27","v":"2020-09-30"},null,"2020-10-30"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FAILURE TO MEET THE REIMBURSEMENT REQUIREMENTS SET FORTH WILL RESULT IN YOUR CLAIM BEING DENIED."]

{"sheet":"CONTINUATION","index":13,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[9,0,56,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"CONTINUATION"}]
[]
["**Press \"ALT\"&\"Enter\" together to insert new line"]
["CONTINUATION AND COST ASSUMPTION"]
["Describe how project activities will be supported when federal participation ends (if warranted)"]

{"sheet":"AUDIT REQ","index":14,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,2],[30,5,30,6],[18,1,18,2],[18,5,18,6],[22,0,23,7],[26,0,26,7],[28,1,28,2],[28,5,28,6],[25,2,25,6],[9,0,9,7],[10,0,10,7],[11,0,12,7],[15,0,15,7],[16,1,16,2],[16,5,16,6],[14,2,14,6],[7,0,7,7],[0,0,1,2],[0,3,1,7],[2,0,5,2],[2,3,3,7],[4,3,5,7]]}
["PROJECT TITLE",null,null,"   APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"AUDIT REQ"}]
[]
[]
["ATTACHMENT A                                                                                                                                                                                                                                                                                                                                                                             "]
[]
["SINGLE AGENCY AUDITING REQUIREMENTS AND PROCEDURES"]
["EFFECTIVE OCTOBER 1, 2019"]
["AUDIT  REQUIREMENT STATEMENT:         "]
[]
[]
["The town/city/agency of "]
["declares that for the fiscal year ending September 30, 2020, the sum total of Federal funds awarded to local government agencies from all sources DOES exceed $750,000 and that it will conduct an audit report as required under 2 CFR part 200 subpart F (REVISED) AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS AND 49 CFR UNIFORM ADMINISTRATIVE REQUIREMENTS FOR GRANTS AND COOPERATIVE AGREEMENTS TO STATE AND LOCAL GOVERNMENTS PART 18.26"]
["Name (Please Print):",null,null,null,"Signature:"]
[]
["Title:",null,null,null,"Date:"]
[]
["(NOTE: PLEASE DO NOT SIGN FOR BOTH STATEMENTS)"]
[]
["AUDIT EXEMPTION STATEMENT:"]
[]
[]
["The town/city/agency of "]
["declares that for the fiscal year ending September 30, 2020, the sum total of Federal funds awarded to local government agencies from all sources DOES NOT exceed $750,000 and that an independent audit is not required under 2 CFR part 200 subpart F (REVISED) AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS AND 49 CFR UNIFORM ADMINISTRATIVE REQUIREMENTS FOR GRANTS AND COOPERATIVE AGREEMENTS TO STATE AND LOCAL GOVERNMENTS PART 18.26"]
[]
["Name (Please Print):",null,null,null,"Signature:"]
[]
["Title:",null,null,null,"Date:"]

{"sheet":"CERTS & ASSURANCES","index":15,"n_rows":353,"n_cols":6,"rows_kept":353,"cut":false,"hidden":false,"merged":[[262,0,263,2],[262,3,263,5],[264,0,267,2],[343,0,344,5],[315,0,316,2],[315,3,316,5],[317,0,320,2],[317,3,318,5],[319,3,320,4],[338,0,340,5],[210,0,211,2],[210,3,211,5],[212,0,215,2],[212,3,213,5],[214,3,215,4],[214,5,215,5],[158,0,159,2],[158,3,159,5],[160,0,163,2],[160,3,161,5],[162,3,163,4],[162,5,163,5],[105,0,106,2],[105,3,106,5],[107,0,110,2],[107,3,108,5],[109,3,110,4],[109,5,110,5],[53,0,54,2],[53,3,54,5],[55,0,58,2],[55,3,56,5],[57,3,58,4],[57,5,58,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,4],[4,5,5,5],[346,1,346,4],[348,1,348,4],[350,1,350,4],[352,1,352,4],[264,3,265,5],[266,3,267,4],[266,5,267,5],[319,5,320,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"CERTS & ASSURANCES"},null,"PAGE 1 OF 7"]
[]
[]
["Certifications and Assurances"]
["for Fiscal Year 2020 Highway Safety Grants "]
["(23 U.S.C. Chapter 4; Sec. 1906, Public Law 109-59, As Amended)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 2 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 3 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 4 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 5 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 6 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"$A$3","v":""},null,null,{"$f":"$D$3","v":""}]
[]
[null,null,null,{"$f":"$D$5","v":"CERTS & ASSURANCES"},null,"PAGE 7 OF 7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I sign these Certifications and Assurances based on personal knowledge, and after appropriate inquiry."]
[]
[]
[]
[]
["Certifying Official:"]
[]
[]
["Name: "]
[]
["Title: "]
[]
["Ink Signature: "]
[]
["Date: "]

{"sheet":"SUMMARY","index":16,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,1],[37,3,37,4],[24,0,24,1],[24,3,24,4],[25,0,25,1],[25,3,25,4],[36,0,36,1],[36,3,36,4],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[30,3,30,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[0,0,1,2],[0,3,1,5],[2,0,5,2],[2,3,3,5],[4,3,5,5],[35,3,35,4],[20,0,20,1],[19,0,19,1],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[31,0,31,1],[31,3,31,4],[29,0,29,1],[29,3,29,4],[30,0,30,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[11,3,11,4],[10,3,10,4],[13,0,14,2],[18,0,18,1],[18,3,18,4],[17,3,17,4],[17,0,17,1],[13,3,16,3],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5]]}
["PROJECT TITLE",null,null,"APPLICANT"]
[]
[{"$f":"IF(APPLICATION!A15=\"\",\"\",APPLICATION!A15)","v":""},null,null,{"$f":"IF(APPLICATION!A21=\"\",\"\",APPLICATION!A21)","v":""}]
[]
[null,null,null,{"$f":"MID(CELL(\"filename\",B1),FIND(\"]\",CELL(\"filename\",B1))+1,255)","v":"SUMMARY"}]
[]
[]
[null,null,null,null,"Federal Share",1]
["BUDGET SUMMARY",null,null,null,"State/Local Share",{"$f":"IF(F26>0,F26/C26,0%)","v":0}]
[]
[null,null,null,"TOTAL FEDERAL BUDGET",null,{"$f":"C26","v":0}]
[null,null,null,"TOTAL MATCH BUDGET",null,{"$f":"F26","v":0}]
[]
["BUDGET SUMMARY SUBMITTAL",null,null,"FEDERAL AWARD IDENTIFIER NUMBER (FAIN):"]
[]
[]
[]
["CHARGES FOR THIS GRANT",null,"AMOUNT","MATCH FOR THIS GRANT",null,"AMOUNT"]
["SALARY",null,{"$f":"SUM(BUDGET!D15:K15)","v":0},"SALARY",null,{"$f":"SUM(MATCH!D15:K15)","v":0}]
["FRINGE BENEFIT",null,{"$f":"SUM(BUDGET!D18:K18)","v":0},"FRINGE BENEFIT",null,{"$f":"SUM(MATCH!D18:K18)","v":0}]
["TRAVEL",null,{"$f":"BUDGET!G26","v":0},"TRAVEL",null,{"$f":"MATCH!G26","v":0}]
["CONTRACTUAL SERVICES",null,{"$f":"BUDGET!G32","v":0},"CONTRACTUAL SERVICES",null,{"$f":"MATCH!G32","v":0}]
["OPERATING/SUPPLIES COSTS",null,{"$f":"BUDGET!G38","v":0},"OPERATING/SUPPLIES COSTS",null,{"$f":"MATCH!F38","v":0}]
["EQUIPMENT",null,{"$f":"BUDGET!G44","v":0},"EQUIPMENT",null,{"$f":"MATCH!F44","v":0}]
["INDIRECT COSTS",null,{"$f":"BUDGET!F52","v":0},"INDIRECT COSTS",null,{"$f":"MATCH!F50","v":0}]
["TOTAL FEDERAL BUDGET",null,{"$f":"SUM(C19:C25)","v":0},"TOTAL MATCH BUDGET",null,{"$f":"SUM(F19:F25)","v":0}]
[]
["BUDGET SUMMARY APPROVAL   ( HSO USE ONLY )"]
[]
["CHARGES FOR THIS GRANT",null,"AMOUNT","MATCH FOR THIS GRANT",null,"AMOUNT"]
["SALARY",null,null,"SALARY"]
["FRINGE BENEFIT",null,null,"FRINGE BENEFIT"]
["TRAVEL",null,null,"TRAVEL"]
["CONTRACTUAL SERVICES",null,null,"CONTRACTUAL SERVICES"]
["OPERATING/SUPPLIES COSTS",null,null,"OPERATING/SUPPLIES COSTS"]
["EQUIPMENT",null,null,"EQUIPMENT"]
["INDIRECT COSTS",null,null,"INDIRECT COSTS"]
["TOTAL FEDERAL BUDGET",null,null,"TOTAL MATCH BUDGET"]