{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Application","Required Documentation","Extra Space","Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[9,2,9,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[8,2,8,9]]}
["Instructions for Match Waiver Application"]
[]
["1.  ","Agencies must respond to all questions on the Application tab – there is no page limit to the response.  You may add the additional sheet if extra space is needed."]
["2.  ","There is a checklist of required documentation that must be submitted with the application (see Required Documentation tab).  This application and the required documents must be submitted to ocjp.compliance@tn.gov by the match waiver deadline.  FAILURE TO SUBMIT ALL REQUIRED DOCUMENTS REFERENCED ABOVE WILL RESULT IN THE APPLICATION NOT BEING PROCESSED."]
["3.  ","The following circumstances make an agency ineligible to receive a match waiver:"]
[null,null,"Current ratio above 2.9"]
[null,null,"Cash reserves sufficient to cover match, including supplementing for lack of volunteers or donations. It is expected to utilize cash reserves to cover for lack of in-kind when available."]
[null,null,"Sufficient nonfederal fund sources supporting the same project and not currently used to match other sources."]
[null,null,"Volunteers or other in-kind donations not currently used to match other sources should be utilized as match before seeking match waiver. All in-kind sources must be exhausted, or you are not eligible to be considered."]
[null,null,"Must maintain same level of match currently met unless there has been an extreme change in the source of that match and there is no other match option available to replace the loss of the prior source of match."]

{"sheet":"Application","index":1,"n_rows":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[31,3,36,8],[24,5,24,6],[30,4,30,5],[1,0,1,1],[1,2,1,3],[2,2,2,3],[4,1,6,1],[4,3,4,5],[5,3,5,5],[6,3,6,5],[39,1,47,8],[50,1,58,8],[61,1,69,8],[71,1,71,8],[0,0,0,8],[26,1,26,8],[60,1,60,8],[49,1,49,8],[38,1,38,8],[29,1,29,8],[8,1,8,8],[22,1,22,8],[24,1,24,3],[31,1,31,2],[20,3,20,8],[9,1,17,8]]}
["Agencies must respond to all questions below – there is no page limit to the response.  You may use the additional sheet if extra space is needed."]
["Agency Name"]
[null,"Contract # (if applicable)"]
[]
[null,"Person of completing application:","Name"]
[null,null,"Email"]
[null,null,"Phone #"]
[]
["1.  ","Explain in detail the hardship and/or type of circumstances that will hinder the program’s ability to provide the required level of match."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Current Assets:  $"]
[null,"Current Liabilities:  $"]
[null,"Current ratio:",{"$f":"IFERROR(C19/C20,\"\")","v":""},{"$f":"IFERROR(IF(C19/C20>2.9,\"A current ratio over 2.9 means your agency is not eligible to be considered for a match waiver with our office.  Please contact your PM with any questions.\",\"\"),\"\")","v":""}]
[]
["2.  ","What is the dollar amount the agency can provide, without hindering services to recipients, including in-kind match, that demonstrates the need for a full or partial (10%) match waiver?"]
[null,"Response:  $"]
[null,"Are you applying for a full or partial waiver?",null,null,null,"Choose answer"]
[]
["3.  ","What is the amount of federal funds requested?"]
[null,"Response:  $"]
[]
["4.  ","If a match waiver is approved, does the organization anticipate this is a one-time request, or are there extenuating circumstances that will require a waiver request for the life of the contract?"]
[null,null,"Response:",null,"Choose answer"]
[null,"Explain if recurring:"]
[]
[]
[]
[]
[]
[]
["5.  ","Explain in detail how the denial of a match waiver would impact the VOCA project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6.  ","Advise whether the program would have to decline all or part of the grant award if a match waiver is not granted."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7.  ","Outline what steps the organization plans to take in order to be able to meet the match requirement in the future."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8.  ","Agencies must include all required documents listed on the following page as attachments to the application for match waiver. Failure to provide documentation may render an application void."]
[]
[]
["For agency use only:"]
[null,null,"Full match amount: ",{"$f":"IF($E$25=\"Full\",($C$28/0.8)*0.2,\"\")","v":""}]
[1,null,"Partial (10%) amount:",{"$f":"IF($E$25=\"Partial\",($C$28/0.8)*0.1,\"\")","v":""}]

{"sheet":"Required Documentation","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,2,14,9],[16,2,16,9],[18,0,18,9],[0,0,0,10],[2,0,2,9],[6,2,6,9],[5,2,5,9],[8,2,8,9],[10,2,10,9],[12,2,12,9],[4,2,4,10]]}
["Required Documentation for Fiscal Review"]
[]
["Agencies requesting a match waiver are required to provide the following information as attachments to the Application for Match Waiver Form:"]
[]
[null,"1.  ","Letter requesting the match waiver from the Authorized Official on letterhead addressed to the director of OCJP"]
[null,"2.  ","Other Funds Table"]
[null,null,"This table should list all funds (federal, state, local, and private) which are dedicated to the program. This should also include any appropriations received from units of State or local government as well."]
[]
[null,"3.  ","Current Balance Sheet (must have current assets and current liabilities broken out)"]
[]
[null,"4.  ","Current profit/loss statement"]
[]
[null,"5.  ","Most recent Form 990"]
[]
[null,"6.  ","Most recent audit report"]
[]
[null,"7.  ","Agency's approved overall total budget for current fiscal year"]
[]
["AGENCIES SHOULD RETURN THIS APPLICATION AND ALL REQUIRED DOCUMENTS TO ocjp.compliance@tn.gov BY THE MATCH WAIVER DEADLINE.  FAILURE TO SUBMIT ALL REQUIRED DOCUMENTS REFERENCED ABOVE WILL RESULT IN THE APPLICATION NOT BEING PROCESSED."]

{"sheet":"Extra Space","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Question #","Additional Information"]

{"sheet":"Lists","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Full","One-time"]
["Partial","Recurring"]