{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Tab 1 Variance Report","Tab 2 CAP","Y_N","Sheet1"],"not_rendered":{"images":2,"defined_names":46},"read":"whole","date_system":"1900"}

{"sheet":"Tab 1 Variance Report","index":0,"n_rows":140,"n_cols":10,"rows_kept":140,"merged":[[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[21,1,21,4],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5]]}
[null,"Legal Services for Homeless Veterans and Veterans At-Risk for Homelessness (LSV) Grant Program"]
[null,"TAB 1: Grantee Financial Variance Report",{"$nulls":7},"OMB Control Number:  2900-XXXX"]
[null,"VA Form 10-319b    (11HPO)",{"$nulls":7},"Estimated Burden:  120 Minutes"]
[{"$nulls":9},"Expiration Date:  XXX XX, XXXX"]
[null,"The Paperwork Reduction Act of 1995:  This information is collected in accordance with Section 3507 of the Paperwork Reduction Act of 1995. The public reporting burden for this  "]
[null,"collection of information is estimated to average 120 minutes per response, including the time to review instructions, search existing data sources, gather and maintain data needed,"]
[null,"and complete and review the collection of information. Respondents should be aware that we may not conduct or sponsor, and you are not required to respond to, a collection of"]
[null,"information unless it displays a valid OMB number. This collection of information is intended for use by the LSV Program as the Grantee's budget change and CAP report. Your  "]
[null,"response to this information collection is mandatory, and failure to provide the requested information may adversely affect your continued participation in the LSV Program."]
[]
[null,"Privacy Act Statement:  VA is asking you to provide the information requested in this report under the authority of 38 U.S.C. section 7366 in order for the VA to assess your financial "]
[null,"budget situation, any CAP, and maintain oversight of your participation in the LSV Program. VA may use or disclose your report information as permitted by law. VA may make a "]
[null,"routine use disclosure of the information for:  civil or criminal law enforcement; congressional communications; the collection of money owed to the United States; litigation in"]
[null,"which the United States is a party or has interest; the administration of VA programs, including verification of eligibility to participate; and personnel administration. You must "]
[null,"provide the requested information to VA in order to continue participation with the LSV Grant Program.  "]
[]
[null,"Name of Grantee:"]
[null,"LSV Program Number:"]
[null,"LSV Grant Amount:"]
[null,"Grant Fiscal Year:"]
[]
[null,"Program Expenses",{"$nulls":3},"% of Total LSV Grant","ACTUAL\nLSV Grant Funds Spent ","BUDGETED\nLSV Grant Funds (FY23)","% VARIANCE \nLSV Grant Funds","VARIANCE EXPLANATION"]
[null,"I. Provision and Coordination of Legal Services (Minimum of 90% of Total LSV Grant Amount)"]
[null,"1. Personnel/Labor","# FTE","% FTE","Base Annual Salary/Wage"]
[null,"Title and Organization"]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$f":"G26/$C$19","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G26-H26)/H26","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$f":"(G27-H27)/H27","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$f":"G32/$C$19","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},0]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$f":"G74/$C$19","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$f":"(G75-H75)/H75","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Salaries/Wages",{"$nulls":3},{"$f":"G76/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G26:G75)","v":0},{"$f":"SUM(H26:H75)","v":0},{"$f":"(G76-H76)/H76","v":{"$error":"#DIV/0!"}}]
[null,"Fringe Benefits @",{"$nulls":3},{"$error":"#DIV/0!"},0,0,{"$f":"(G77-H77)/H77","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Personnel",{"$nulls":3},{"$f":"G78/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"G76+G77","v":0},{"$f":"H76+H77","v":0},{"$f":"(G78-H78)/H78","v":{"$error":"#DIV/0!"}}]
[]
[null,"2. Other Non-Personnel Provision and Coordination of Legal Services Expenses"]
[null,"Court Fees/ Filing Fees"]
[{"$nulls":5},{"$f":"G82/$C$19","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[{"$nulls":5},{"$f":"G83/$C$19","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$f":"G87/$C$19","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$f":"G90/$C$19","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},0,"NA","NA"]
[{"$nulls":5},{"$error":"#DIV/0!"},{"$f":"SUM(G82:G91)","v":0},"NA","NA"]
[]
[]
[null,"Subtotal Other Program Expenses",{"$nulls":3},{"$f":"G95/$C$19","v":{"$error":"#REF!"}},{"$f":"#REF!+G92","v":{"$error":"#REF!"}},0,{"$f":"(G95-H95)/H95","v":{"$error":"#REF!"}}]
[]
[{"$nulls":4},"# of Vehicles"]
[null,"Vehicle Lease Costs",{"$nulls":3},{"$f":"G98/$C$19","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G98-H98)/H98","v":{"$error":"#DIV/0!"}}]
[]
[null,"Subtotal Provision and Coordination of Legal Services",{"$nulls":3},{"$f":"G100/$C$19","v":{"$error":"#REF!"}},{"$f":"G98+#REF!+G95+G78","v":{"$error":"#REF!"}},{"$f":"H98+#REF!+H95+H78","v":{"$error":"#REF!"}},{"$f":"(G100-H100)/H100","v":{"$error":"#REF!"}}]
[]
[null,"II. Administrative Expenses (Maximum of 10% of Total LSV Grant Amount)"]
[{"$nulls":5},{"$f":"G103/$C$19","v":{"$error":"#DIV/0!"}},0,null,{"$f":"(G103-H103)/H103","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"G104/$C$19","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G104-H104)/H104","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$f":"G106/$C$19","v":{"$error":"#DIV/0!"}},0,null,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,null,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$f":"(G132-H132)/H132","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$f":"(G134-H134)/H134","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$f":"(G137-H137)/H137","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Administrative Expenses",{"$nulls":3},{"$f":"G138/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G103:G137)","v":0},{"$f":"SUM(H103:H137)","v":0},{"$f":"(G138-H138)/H138","v":{"$error":"#DIV/0!"}}]
[]
[null,"Grand Total",{"$nulls":3},{"$f":"G140/$C$19","v":{"$error":"#REF!"}},{"$f":"ROUND(G138+G100,0)","v":{"$error":"#REF!"}},{"$f":"ROUND(H138+H100,0)","v":{"$error":"#REF!"}},{"$f":"(G140-H140)/H140","v":{"$error":"#REF!"}}]

{"sheet":"Tab 2 CAP","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,0,0,7],[1,0,1,7],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[10,0,10,7],[11,0,11,7],[19,0,19,7],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5],[30,1,30,7],[31,1,31,7],[32,1,32,7]]}
["Legal Services for Homeless Veterans and Veterans At-Risk for Homelessness (LSV) Grant Program"]
["Corrective Action Plan (CAP) "]
[{"$nulls":5},"                  VA Form","10-319b","OMB Control Number:  2900-XXXX"]
[{"$nulls":7},"Estimated  Burden: 120 Minutes "]
["Grantee Name:",{"$nulls":6},"Expiration Date:  XXX XX, 202X"]
["Program Number:"]
["Date issued "]
["Response Deadline"]
["LSV Point of Contact:"]
[]
["Instructions:"]
{"$rows_empty":8}
["Corrective Action Plan"]
["Finding/Concern Identified","Reason for the Non-Compliance and Plan to Address the Issue","Timeline/Action Steps for accomplishing corrective action and who will be involved in each step of the process",{"$nulls":3},"Describe system of internal controls to prevent reoccurrence","If a repeat finding:\nProvide documentation/evidence that the finding has been corrected. Evidence should include plan or system of internal controls to prevent the finding from reoccurring."]
["Prepopulated fron Grant Team"]
{"$rows_empty":8}
["Name:"]
["Title "]
["Date:"]

{"sheet":"Y_N","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"hidden":true}
["Yes"]
["No"]

{"sheet":"Sheet1","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"hidden":true}
["DropDown"]
["Approved"]
["Declined"]
["N/A"]