{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TAB 1-Budget Worksheet ACT Team","TAB 2-Project Summary Budget"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"TAB 1-Budget Worksheet ACT Team","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"merged":[[0,0,2,4],[15,0,15,3]]}
["TAB 1:  Budget Worksheet ACT Team                                                                                                                                                                                                 Complete the chart to show how your organization will establish the interdisciplinary ACT Team model and provide/implement the services as listed in the RFP specifications. Enter the total personnel cost in Category A on the Project Summary Budget:"]
[]
[]
[]
["Position \n(1)","Name or New Hire \n(2)","Annual Salary / Rate \n(3)","Level of Effort / FTE percentage \n(4)","Total Annual Salary \n(5)"]
["Example:  Team Lead","Jane Doe",{"v":45000,"d":"$45,000"},{"v":1,"d":"100%"},{"$f":"D6*C6","v":{"v":45000,"d":"$45,000"}}]
["Example:  Forensic Specialist","John Doe","In-kind",{"v":0.1,"d":"10%"},{"v":0,"d":"$0"}]
[{"$nulls":4},{"$f":"D8*C8","v":{"v":0,"d":"$0"}}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
[{"$nulls":4},{"v":0,"d":"$0"}]
["Total:",{"$nulls":3},{"$f":"SUM(E8:E15)","v":{"v":0,"d":"$0"}}]
["Italicized text is meant to provide an example."]
[]
[]
[]
[]
[]
[]
["KEY:"]
["(1) Position:","Enter position title"]
["(2) Name or New Hire:","Enter name if existing, new for new hire"]
["(3) Annual Salary/Rate:","Enter $ amount, or in-kind"]
["(4) Level of Effort/FTE Percentage:","Enter % of time committed to ACT Team"]
["(5) Total Annual Salary:","Calculation, % level of effort * annual salary. If in-kind enter $0"]

{"sheet":"TAB 2-Project Summary Budget","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[0,0,2,8],[4,0,5,0],[4,1,5,1],[4,2,4,4],[4,5,5,5],[4,6,4,8]]}
["TAB 2 - Project Summary Budget                                                                                                                                                                                                                                                                                Please complete the Project Summary Budget form provided below.  Identify any funding sources you anticipate using to support the implementation and operation of the ACT Team over the two-year pilot. Note that County funding is intended to serve as “gap” funding paid on a reimbursement basis once all other sources of funding have been applied."]
[]
[]
[]
["Category","Year 1 Total \n(1)","Year 1 Funding Sources \n(2)",null,null,"Year 2 Total \n(3)","Year 2 Funding Sources \n(4)"]
[null,null,"TennCare","Other","Gap/FUSE",null,"TennCare","Other","Gap/FUSE"]
["A. Personnel"]
["B. Fringe"]
["C. Travel"]
["D. Equipment"]
["E. Supplies"]
["F. Contractual"]
["G. Occupancy Expenses"]
["H. Communications"]
["I. Staff Development & Training"]
["J. Consumer housing cost other than cost covered by housing voucher"]
["K. Other"]
["L. Total Direct Charges"]
["M. Indirect Charges"]
["Total Project Costs",{"$f":"SUM(B7:B19)","v":{"v":0,"d":"$0"}},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[]
[]
["KEY:"]
["(1) Year 1 Total:","Enter year 1 total budget for each category "]
["(2) Funding Sources:","Specify amount from each funding source to cover cost of category item (in rows 7-20, columns C, D, & E must = column B)"]
["(3) Year 2 Total:","Enter year 2 total budget for each category "]
["(4) Funding Sources:","Specify amount from each funding source to cover cost of category item (in rows 7-20, columns G, H, & I must = column F)"]