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

{"sheet":"Tab 1 Variance Report","index":0,"n_rows":176,"n_cols":10,"rows_kept":176,"merged":[[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[8,1,8,4],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5]]}
[null,"VA's Supportive Services for Veteran Families Program "]
[null,"TAB 1: Grantee FY21 Financial Report - Variance Report"]
[]
[null,"Name of Grantee:"]
[null,"SSVF Program Number:"]
[null,"SSVF Grant Amount:"]
[null,"Grant Fiscal Year:",2021]
[]
[null,"Program Expenses",{"$nulls":3},"% of Total SSVF Grant","ACTUAL\nSSVF Grant Funds Spent (FY21)","BUDGETED\nSSVF Grant Funds (FY16)","% VARIANCE \nSSVF Grant Funds","VARIANCE EXPLANATION"]
[null,"I. Provision and Coordination of Supportive Services (Minimum of 90% of Total SSVF 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":"G13/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G13-H13)/H13","v":{"$error":"#DIV/0!"}}]
[null,null,{"v":0,"d":"0.0"},{"v":0,"d":"0%"},0,{"$error":"#DIV/0!"},0,0,{"$f":"(G14-H14)/H14","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":"G19/$C$6","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":"G61/$C$6","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":"(G62-H62)/H62","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Salaries/Wages",{"$nulls":3},{"$f":"G63/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G13:G62)","v":0},{"$f":"SUM(H13:H62)","v":0},{"$f":"(G63-H63)/H63","v":{"$error":"#DIV/0!"}}]
[null,"Fringe Benefits @",{"$nulls":3},{"$error":"#DIV/0!"},0,0,{"$f":"(G64-H64)/H64","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Personnel",{"$nulls":3},{"$f":"G65/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"G63+G64","v":0},{"$f":"H63+H64","v":0},{"$f":"(G65-H65)/H65","v":{"$error":"#DIV/0!"}}]
[]
[null,"2. Temporary Financial Assistance"]
[null,"Spent on Prevention Participants (Category 1)"]
[null,"Rent, penalties, fees",{"$nulls":3},{"$f":"G69/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Utility fees",{"$nulls":3},{"$f":"G70/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Security deposits",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Utility deposits",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Moving costs",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Transportation",{"$nulls":3},{"$f":"G74/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Child Care",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Other as approved by VA",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"General Housing Stability Assistance",{"$nulls":3},{"$f":"G77/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Emergency Housing Assistance",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Subtotal Prevention TFA",{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"SUM(G69:G78)","v":0},"NA","NA"]
[]
[null,"Spent on Rapid Re-Housing Participants (Categories 2 & 3)"]
[null,"Rent, penalties, fees",{"$nulls":3},{"$f":"G82/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Utility fees",{"$nulls":3},{"$f":"G83/$C$6","v":{"$error":"#DIV/0!"}},0,"NA","NA"]
[null,"Security deposits",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Utility deposits",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Moving costs",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Transportation",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Child Care",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"General Housing Stability Assistance",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Emergency Housing Assistance",{"$nulls":3},{"$error":"#DIV/0!"},0,"NA","NA"]
[null,"Subtotal Rapid Re-Housing TFA",{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"SUM(G82:G90)","v":0},"NA","NA"]
[]
[null,"Subtotal Temporary Financial Assistance ",{"$nulls":3},{"$f":"G93/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"G91+G79","v":0},0,{"$f":"(G93-H93)/H93","v":{"$error":"#DIV/0!"}}]
[]
[null,"3. Other Non-Personnel Provision and Coordination of Supportive Services Expenses"]
[{"$nulls":5},{"$f":"G96/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G96-H96)/H96","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"G97/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G97-H97)/H97","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},{"$f":"G100/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G100-H100)/H100","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"G101/$C$6","v":{"$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},{"$f":"G106/$C$6","v":{"$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,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[null,"Subtotal Other Program Expenses",{"$nulls":3},{"$f":"G132/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G96:G131)","v":0},{"$f":"SUM(H96:H131)","v":0},{"$f":"(G132-H132)/H132","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"# of Vehicles"]
[null,"4. Lease & Maintenance of Vehicle(s)",null,null,2,{"$f":"G134/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G134-H134)/H134","v":{"$error":"#DIV/0!"}}]
[]
[null,"Subtotal Provision and Coordination of Supportive Services",{"$nulls":3},{"$f":"G136/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"G134+G132+G93+G65","v":0},{"$f":"H134+H132+H93+H65","v":0},{"$f":"(G136-H136)/H136","v":{"$error":"#DIV/0!"}}]
[]
[null,"II. Administrative Expenses (Maximum of 10% of Total SSVF Grant Amount)"]
[{"$nulls":5},{"$f":"G139/$C$6","v":{"$error":"#DIV/0!"}},0,null,{"$f":"(G139-H139)/H139","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"G140/$C$6","v":{"$error":"#DIV/0!"}},0,0,{"$f":"(G140-H140)/H140","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$f":"G142/$C$6","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":"(G168-H168)/H168","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"}]
[{"$nulls":5},{"$error":"#DIV/0!"},0,0,{"$f":"(G170-H170)/H170","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":"(G173-H173)/H173","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal Administrative Expenses",{"$nulls":3},{"$f":"G174/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G139:G173)","v":0},{"$f":"SUM(H139:H173)","v":0},{"$f":"(G174-H174)/H174","v":{"$error":"#DIV/0!"}}]
[]
[null,"Grand Total",{"$nulls":3},{"$f":"G176/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(G174+G136,0)","v":0},{"$f":"ROUND(H174+H136,0)","v":0},{"$f":"(G176-H176)/H176","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tab 2 Spending by Sub","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"merged":[[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[8,7,8,17],[9,1,9,4]]}
[null,"VA's Supportive Services for Veteran Families Program "]
[null,"TAB 2:  Grantee FY16 Financial Report - Program Expenditures by Subcontractor"]
[]
[null,"Name of Grantee:",{"$f":"'Tab 1 Variance Report'!$C$4","v":0}]
[null,"SSVF Program Number",{"$f":"'Tab 1 Variance Report'!$C$5","v":0}]
[null,"SSVF Grant Amount:",{"$f":"'Tab 1 Variance Report'!$C$6","v":{"v":0,"d":"$0.00"}}]
[null,"Grant Fiscal Year:",{"$f":"'Tab 1 Variance Report'!C7:G7","v":2021}]
[]
[{"$nulls":7},"PROGRAM EXPENSES BY SUBCONTRACTOR:"]
[null,"Program Expenses",{"$nulls":3},"% of Total SSVF Grant","SPENT\nSSVF Grant Funds Total Annual to Date",{"$f":"C4","v":0},"INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME","INSERT SUB-CONTRACTOR NAME"]
[null,"I. Provision and Coordination of Supportive Services (Minimum of 90% of Total SSVF Grant Amount)"]
[null,"1. Personnel/Labor"]
[null,"Subtotal Personnel",{"$nulls":3},{"$f":"G13/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H13:R13)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[]
[null,"2. Temporary Financial Assistance",{"$nulls":3},{"$f":"G15/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H15:R15)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"3. Other Non-Personnel Provision and Coordination of Supportive Services Expenses"]
[null,"Subtotal Other Program Expenses",{"$nulls":3},{"$f":"G18/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H18:R18)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"# of Vehicles"]
[null,"4. Lease & Maintenance of Vehicle(s)",null,null,{"$f":"'Tab 1 Variance Report'!$E$134","v":2},{"$f":"G20/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H20:R20)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Subtotal Provision and Coordination of Supportive Services",{"$nulls":3},{"$f":"G22/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H22:R22)","v":0},{"$f":"SUM(H13,H20,H15,H18)","v":0},0,0,0,0,0,{"$f":"SUM(N13,N20,N15,N18)","v":0},0,0,0,0]
[]
[null,"II. Administrative Expenses (Maximum of 10% of Total SSVF Grant Amount)"]
[null,"Subtotal Administrative Expenses",{"$nulls":3},{"$f":"G25/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H25:R25)","v":0},{"$f":"'Tab 1 Variance Report'!G174","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Grand Total",{"$nulls":3},{"$f":"G27/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H27:R27)","v":0},{"$f":"SUM(H22,H25)","v":0},{"$f":"SUM(I22,I25)","v":0},{"$f":"SUM(J22,J25)","v":0},0,0,0,0,0,0,0,0]
[null,"% of Total SSVF Grant",{"$nulls":4},{"$f":"G27/$C$6","v":{"$error":"#DIV/0!"}},{"$f":"H27/$C$6","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"R27/$C$6","v":{"$error":"#DIV/0!"}}]

{"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"]