{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["RFSI Budget Worksheet for Web"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"RFSI Budget Worksheet for Web","index":0,"n_rows":74,"n_cols":9,"rows_kept":74,"merged":[[8,0,8,6],[14,1,14,2],[15,1,15,2],[16,1,16,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[52,0,52,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[61,0,61,2],[66,0,66,6],[67,0,67,6]]}
{"$rows_empty":8}
["RFSI SAMPLE BUDGET WORKSHEET"]
[]
[{"$nulls":4},"Grant",null,"Total "]
[null,null,"Budget Category",null,"Request","Match ","Project"]
[{"$nulls":4},"Budget","Budget","Costs"]
["Equipment"]
[null,"Refrigerated Vehicle",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E15:F15)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E16:F16)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E17:F17)","v":{"v":0,"d":"0 "}}]
[null,"Equipment Total",null,null,{"$f":"SUM(E15:E17)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F15:F17)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G15:G17)","v":{"v":0,"d":"0 "}}]
[]
["Construction"]
[null,"General Contractor",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E21:F21)","v":{"v":0,"d":"0 "}}]
[null,"Electrical Contractor",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E22:F22)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E23:F23)","v":{"v":0,"d":"0 "}}]
[null,"Construction Total",null,null,{"$f":"SUM(E21:E23)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F21:F23)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G21:G23)","v":{"v":0,"d":"0 "}}]
[]
["Supplies"]
[null,"Building Materials",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E27:F27)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E28:F28)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E29:F29)","v":{"v":0,"d":"0 "}}]
[null,"Supplies Total",null,null,{"$f":"SUM(E27:E29)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F27:F29)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G27:G29)","v":{"v":0,"d":"0 "}}]
[]
["Professional & Outside Services (Contractual)"]
[null,"Painting Contractor",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E33:F33)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E34:F34)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E35:F35)","v":{"v":0,"d":"0 "}}]
[null,"P&O Total",null,null,{"$f":"SUM(E33:E35)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F33:F35)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G33:G35)","v":{"v":0,"d":"0 "}}]
[]
["Personnel Expenses"]
[null,"Project Manager",null,".50 FTE",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E39:F39)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,"Level of Effort (# of hours OR % FTE)",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E40:F40)","v":{"v":0,"d":"0 "}}]
[null,"Personnel Total",null,null,{"$f":"SUM(E39:E40)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
["Employee Related Expenses (Fringe Benefits)"]
[null,"Project Manager",null,{"v":0.28,"d":"28%"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E44:F44)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,"Fringe Benefit Rate (%)",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E45:F45)","v":{"v":0,"d":"0 "}}]
[null,"ERE Total",null,null,{"$f":"SUM(E44:E45)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F44:F45)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G44:G45)","v":{"v":0,"d":"0 "}}]
[]
["Travel"]
[null,"Mileage",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E49:F49)","v":{"v":0,"d":"0 "}}]
[null,"Meals",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E50:F50)","v":{"v":0,"d":"0 "}}]
[null,"Lodging",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E51:F51)","v":{"v":0,"d":"0 "}}]
[null,"Travel Total",null,null,{"$f":"SUM(E49:E51)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F49:F51)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G49:G51)","v":{"v":0,"d":"0 "}}]
[]
["Other Operating Expenses"]
[null,"Facility Rent",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E55:F55)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E56:F56)","v":{"v":0,"d":"0 "}}]
[null,"(Enter description here)",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"OOE Total",null,null,{"$f":"SUM(E55:E57)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F55:F57)","v":{"v":0,"d":"0 "}},{"$f":"SUM(G55:G57)","v":{"v":0,"d":"0 "}}]
[]
["DIRECT COSTS SUB-TOTAL",{"$nulls":3},{"$f":"SUM(E41,E46,E52,E18,E30,E24,E36,E58)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F41,F46,F52,F18,F30,F24,F36,F58)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
["Modified Total Direct Costs (MTDC)*",null,null,"10% de minimus",{"$f":"SUM(E30,E36,E41,E46,E52,E58)","v":{"v":0,"d":"0 "}}]
["Recoverable Indirect Costs*",null,null,{"$f":"SUM(E61)*0.1","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(E62:F62)","v":{"v":0,"d":"0 "}}]
["TOTALS",{"$nulls":3},{"$f":"SUM(E60,E62)","v":{"v":0,"d":"0 "}},{"$f":"SUM(F60,F62)","v":{"v":0,"d":"0 "}},{"v":0,"d":"0 "}]
[]
["*See Scope and Requirements - Page 20"]
[]
["RFSI Grant Match Calculator"]
["Click in the gray cell below and use the drop down arrow to choose your match percentage."]
[]
[null,null,"Grant Funds Requested",{"$f":"SUM(E63)","v":0},"Between $100,000 and $1,000,000",{"$nulls":3},0.25]
[null,null,"Required Match Rate",0.25,"Must be .50 or .25.",{"$nulls":3},0.5]
[null,null,"Match Funds Required",{"$f":"D74-D70","v":0},null,{"$f":"SUM(D72-F63)","v":0},"Match difference should be zero"]
[]
[null,null,"Total Grant Budget",{"$f":"D70/(1-D71)","v":0},"Grant + Match"]