{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["B-1 Funded Program ","Prof & Spec Sv Detail "," Misc Detail","Admin Detail","Billable Staff Hours"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":128,"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":"B-1 Funded Program ","index":0,"n_rows":1014,"n_cols":12,"rows_kept":1014,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,1,2,2],[4,2,4,3],[5,2,5,3],[5,4,5,5],[3,0,3,1],[3,2,3,5],[4,4,4,5],[4,6,5,7],[85,9,85,10],[81,9,81,11],[84,9,84,10],[6,4,6,5],[7,4,7,5],[76,9,76,11],[79,9,79,10],[80,9,80,10],[82,9,82,10],[83,9,83,10],[66,1,70,4],[49,0,49,2],[75,3,75,5],[76,3,76,5],[58,0,58,2],[92,9,92,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[77,9,77,10],[78,9,78,10],[91,9,91,10],[90,9,90,10],[86,9,86,11]]}
["B-1 BUDGET WORKBOOK "]
["Bidder Name:"]
["Date Prepared:",{"$f":"NOW()","v":"2013-07-30T10:24:27.320"}]
["Priority Program Category:"]
[]
[]
[]
[null,null,null,"Maximum Contract Amount:"]
["SALARIES AND WAGES"]
["Positions/Titles","Direct Service (choose x)","Admin Staff (choose x)","Annualized Salary (12 months)","FTE","Total Cost (12 months)"]
[null,null,null,null,{"$f":"IFERROR(F11/D11,\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,{"$f":"COUNTA(directservice)","v":0},{"$f":"COUNTA(admin)","v":0},null,{"$f":"SUM(FTE)","v":0},{"$f":"SUM(Costs)","v":0}]
["Percentage Employee Benefits & Taxes",null,null,null,null,{"$f":"SUM(total*percentage)","v":0}]
["TOTAL PROPOSED PERSONNEL COSTS (INCLUDES BENEFITS/TAXES)",null,null,null,null,{"$f":"SUM(employeepercentage:total)","v":0}]
[]
["OPERATING EXPENSES "]
[null,null,null,"Food"]
[null,null,null,"Office Expense"]
[null,null,null,"Recreational Supplies"]
[null,null,null,"Structure Maintenance"]
[null,null,null,"Equipment: Maintenance"]
[null,null,null,"Utilities"]
[null,null,null,"Communications"]
[null,null,null,"Membership Dues"]
[null,null,null,"Transportation"]
[null,null,null,"Travel"]
[null,null,null,"Training"]
["*(Justification/Detail Worksheet Required)",null,null,"Professional & Specialized Svcs*",null,{"$f":"[0]!profworksheettotal","v":0}]
[null,null,null,"Insurance"]
[null,null,null,"Taxes & Licenses"]
[null,null,null,"Structure: Rent/Lease"]
[null,null,null,"Equipment: Rent/Lease"]
[null,null,null,"Vehicle: Rent/Lease"]
[null,null,null,"Depreciation: Structure"]
[null,null,null,"Depreciation: Equipment"]
[null,null,null,"Depreciation: Vehicle"]
["*(Justification/Detail Worksheet Required)",null,null,"Miscellaneous*",null,{"$f":"misctot","v":0}]
[]
[]
["TOTAL OPERATING EXPENSES",null,null,null,null,{"$f":"SUM(OperatingExpenses)","v":0}]
["Admin* (Justification/Detail Worksheet Required) ",null,null,null,null,{"$f":"admintotalworksheet","v":0}]
["GROSS COST",null,null,null,null,{"$f":"SUM(PersonnelCosts+Totaloperating+admincosts)","v":0}]
[]
["REVENUE (specify type)",null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
["TOTAL REVENUE",null,null,null,null,{"$f":"SUM(Revenue)","v":0}]
["NET COSTS",null,null,null,"NET COST",{"$f":"Gross-Totalrevenue","v":0}]
[]
[]
[]
[null,null,null,"Case Management"]
[null,null,null,"Total Hours"]
[null,null,null,"Cost Per Hour",null,{"$f":"cmgross/cmhours","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Cost per Minute",null,{"$f":"cmcost/60","v":{"$error":"#DIV/0!"}},{"$f":"IF(cmmins>2.02,\"Exceeds 2.02\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Gross Cost"]
[null,null,null,"Mental Health Services"]
[null,null,null,"Total Hours"]
[null,null,null,"Cost Per Hour",null,{"$f":"mhgross/mhhours","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Cost per Minute",null,{"$f":"mhcost/60","v":{"$error":"#DIV/0!"}},{"$f":"IF(mhmins>2.61,\"Exceeds 2.61\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Gross Cost"]
[null,null,null,"Crisis Intervention"]
[null,null,null,"Total Hours"]
[null,null,null,"Cost Per Hour",null,{"$f":"cigross/cihours","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Cost per Minute",null,{"$f":"cicost/60","v":{"$error":"#DIV/0!"}},{"$f":"IF(cimins>3.88,\"Exceeds 3.88\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Gross Cost"]
[null,null,null,"Total Outpatient Hours",null,{"$f":"cmhours+mhhours+cihours","v":0}]
[null,null,null,"Total Gross Cost",null,{"$f":"cmgross+mhgross+cigross","v":0}]
[null,null,null,"Current","Client (from application","Cost per client",null,null,null,"Current","Client (from application","Cost per client"]
[null,null,null,"Per year ",null,{"$f":"F73/E95","v":{"$error":"#DIV/0!"}},null,null,null,"Per year ",null,{"$f":"L73/K95","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Per month",null,{"$f":"F73/E96","v":{"$error":"#DIV/0!"}},null,null,null,"Per month",null,{"$f":"L73/K96","v":{"$error":"#DIV/0!"}}]
[null,null,null,"At any given time",null,{"$f":"F73/E97","v":{"$error":"#DIV/0!"}},null,null,null,"At any given time",null,{"$f":"L73/K97","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Culturally & Linguistically Responsive Svcs Asian/Southeast Asian Languages"]
["School Based Svcs"]
["TAY Santa Rita Jail Mental Health Programs"]
["REACH Ashland Youth Center"]
[]
["Vincent Academy Charter School  (West Oakland)"]
["Oakland Technical High School (North Oakland)"]
["Academy of Alameda Charter School (West Alameda)"]
["Oakland High School (Central Oakland)"]
["Fremont Federation High School (Central Oakland)"]
["Aspire Millsmont Charter School (Central East Oakland)"]
["100 Black Men Community Charter School (East Oakland)"]
["Lighthouse Community Charter School (East Oakland)"]
["Education for Change Learning Without Limits Charter Academy (East Oakland)"]
[]
["Both"]

{"sheet":"Prof & Spec Sv Detail ","index":1,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,1,5,2],[4,0,4,5],[0,0,0,6],[1,2,1,5],[2,2,2,5],[1,0,1,1],[2,0,2,1],[3,0,3,1],[46,1,46,2],[6,1,8,2],[10,1,12,2],[14,1,16,2],[18,1,20,2],[22,1,24,2],[26,1,28,2],[30,1,32,2],[34,1,36,2],[38,1,40,2],[42,1,44,2]]}
["Justification/Detail: Professional & Specialized Services"]
["Provider Name",null,{"$f":"Provider","v":0}]
["Program Name",null,{"$f":"Program","v":0}]
["Date Prepared",null,{"$f":"NOW()","v":"2013-07-30T10:24:27.320"}]
["*The total amount from this form will populate on the budget form for this line-item."]
[null,"Detail",null,null,"Amount",null,"Comments"]
[1]
[]
[null,null,null,"$"]
[]
["2."]
[]
[null,null,null,"$"]
[]
["3."]
[]
[null,null,null,"$"]
[]
["4."]
[]
[null,null,null,"$"]
[]
["5."]
[]
[null,null,null,"$"]
[]
["6."]
[]
[null,null,null,"$"]
[]
["7."]
[]
[null,null,null,"$"]
[]
["8."]
[]
[null,null,null,"$"]
[]
["9."]
[]
[null,null,null,"$"]
[]
["10."]
[]
[null,null,null,"$"]
[]
[null,"Total Line Item Amount",null,"$",{"$f":"SUM(Amountprof)","v":0}]

{"sheet":" Misc Detail","index":2,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,1,47,2],[18,1,20,2],[22,1,24,2],[26,1,28,2],[30,1,32,2],[35,1,37,2],[39,1,41,2],[5,1,5,2],[6,1,8,2],[10,1,12,2],[14,1,16,2],[43,1,45,2],[0,0,0,6],[2,0,2,1],[3,0,3,1],[4,0,4,5],[1,0,1,1],[1,2,1,5],[2,2,2,5],[3,2,3,5]]}
["Justification/Detail: Miscellaneous Costs"]
["Provider Name",null,{"$f":"Provider","v":0}]
["Program Name",null,{"$f":"Program","v":0}]
["Date Prepared",null,{"$f":"NOW()","v":"2013-07-30T10:24:27.320"}]
["*The total amount from this form will populate on the budget form for this line-item."]
[null,"Detail",null,null,"Amount",null,"Comments"]
[1]
[]
[null,null,null,"$"]
[]
["2."]
[]
[null,null,null,"$"]
[]
["3."]
[]
[null,null,null,"$"]
[]
["4."]
[]
[null,null,null,"$"]
[]
["5."]
[]
[null,null,null,"$"]
[]
["6."]
[]
[null,null,null,"$"]
[]
["7."]
[]
[null,null,null,"$"]
[]
[]
["8."]
[]
[null,null,null,"$"]
[]
["9."]
[]
[null,null,null,"$"]
[]
["10."]
[]
[null,null,null,"$"]
[]
[null,"Total Line Item Amount",null,"$",{"$f":"SUM(miscamount)","v":0}]

{"sheet":"Admin Detail","index":3,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,1,45,2],[47,1,47,2],[22,1,24,2],[26,1,28,2],[30,1,32,2],[35,1,37,2],[39,1,41,2],[5,1,5,2],[6,1,8,2],[10,1,12,2],[14,1,16,2],[18,1,20,2],[0,0,0,6],[1,0,1,1],[4,0,4,5],[1,2,1,5],[2,0,2,1],[2,2,2,5],[3,0,3,1],[3,2,3,5]]}
["Justification/Detail: Administrative Costs"]
["Provider Name",null,{"$f":"Provider","v":0}]
["Program Name",null,{"$f":"Program","v":0}]
["Date Prepared",null,{"$f":"NOW()","v":"2013-07-30T10:24:27.320"}]
["*List only Admin Costs not already included in Salaries & Wages section. The total amount from this form will populate on the budget form for this line-item."]
[null,"Detail",null,null,"Amount",null,"Comments"]
[1]
[]
[null,null,null,"$"]
[]
["2."]
[]
[null,null,null,"$"]
[]
["3."]
[]
[null,null,null,"$"]
[]
["4."]
[]
[null,null,null,"$"]
[]
["5."]
[]
[null,null,null,"$"]
[]
["6."]
[]
[null,null,null,"$"]
[]
["7."]
[]
[null,null,null,"$"]
[]
[]
["8."]
[]
[null,null,null,"$"]
[]
["9."]
[]
[null,null,null,"$"]
[]
["10."]
[]
[null,null,null,"$"]
[]
[null,"Total Line Item Amount",null,"$",{"$f":"SUM(adminamount)","v":0}]

{"sheet":"Billable Staff Hours","index":4,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Positions/Titles","Direct Service","Admin Staff ","Annualized Salary                  (12 months)","FTE","Total Cost (12 months)"]
[{"$f":"'B-1 Funded Program '!A11","v":0},{"$f":"'B-1 Funded Program '!B11","v":0},{"$f":"'B-1 Funded Program '!C11","v":0},{"$f":"'B-1 Funded Program '!D11","v":0},{"$f":"'B-1 Funded Program '!E11","v":""},{"$f":"'B-1 Funded Program '!F11","v":0}]
[{"$f":"'B-1 Funded Program '!A12","v":0},{"$f":"'B-1 Funded Program '!B12","v":0},{"$f":"'B-1 Funded Program '!C12","v":0},{"$f":"'B-1 Funded Program '!D12","v":0},{"$f":"'B-1 Funded Program '!E12","v":""},{"$f":"'B-1 Funded Program '!F12","v":0}]
[{"$f":"'B-1 Funded Program '!A14","v":0},{"$f":"'B-1 Funded Program '!B14","v":0},{"$f":"'B-1 Funded Program '!C14","v":0},{"$f":"'B-1 Funded Program '!D14","v":0},{"$f":"'B-1 Funded Program '!E14","v":""},{"$f":"'B-1 Funded Program '!F14","v":0}]
[{"$f":"'B-1 Funded Program '!A16","v":0},{"$f":"'B-1 Funded Program '!B16","v":0},{"$f":"'B-1 Funded Program '!C16","v":0},{"$f":"'B-1 Funded Program '!D16","v":0},{"$f":"'B-1 Funded Program '!E16","v":""},{"$f":"'B-1 Funded Program '!F16","v":0}]
[{"$f":"'B-1 Funded Program '!A17","v":0},{"$f":"'B-1 Funded Program '!B17","v":0},{"$f":"'B-1 Funded Program '!C17","v":0},{"$f":"'B-1 Funded Program '!D17","v":0},{"$f":"'B-1 Funded Program '!E17","v":""},{"$f":"'B-1 Funded Program '!F17","v":0}]
[{"$f":"'B-1 Funded Program '!A18","v":0},{"$f":"'B-1 Funded Program '!B18","v":0},{"$f":"'B-1 Funded Program '!C18","v":0},{"$f":"'B-1 Funded Program '!D18","v":0},{"$f":"'B-1 Funded Program '!E18","v":""},{"$f":"'B-1 Funded Program '!F18","v":0}]
[{"$f":"'B-1 Funded Program '!A19","v":0},{"$f":"'B-1 Funded Program '!B19","v":0},{"$f":"'B-1 Funded Program '!C19","v":0},{"$f":"'B-1 Funded Program '!D19","v":0},{"$f":"'B-1 Funded Program '!E19","v":""},{"$f":"'B-1 Funded Program '!F19","v":0}]
[{"$f":"'B-1 Funded Program '!A22","v":0},{"$f":"'B-1 Funded Program '!B22","v":0},{"$f":"'B-1 Funded Program '!C22","v":0},{"$f":"'B-1 Funded Program '!D22","v":0},{"$f":"'B-1 Funded Program '!E22","v":""},{"$f":"'B-1 Funded Program '!F22","v":0}]
[{"$f":"'B-1 Funded Program '!A23","v":0},{"$f":"'B-1 Funded Program '!B23","v":0},{"$f":"'B-1 Funded Program '!C23","v":0},{"$f":"'B-1 Funded Program '!D23","v":0},{"$f":"'B-1 Funded Program '!E23","v":""},{"$f":"'B-1 Funded Program '!F23","v":0}]
[{"$f":"'B-1 Funded Program '!A24","v":0},{"$f":"'B-1 Funded Program '!B24","v":0},{"$f":"'B-1 Funded Program '!C24","v":0},{"$f":"'B-1 Funded Program '!D24","v":0},{"$f":"'B-1 Funded Program '!E24","v":""},{"$f":"'B-1 Funded Program '!F24","v":0}]
[{"$f":"'B-1 Funded Program '!A25","v":0},{"$f":"'B-1 Funded Program '!B25","v":0},{"$f":"'B-1 Funded Program '!C25","v":0},{"$f":"'B-1 Funded Program '!D25","v":0},{"$f":"'B-1 Funded Program '!E25","v":""},{"$f":"'B-1 Funded Program '!F25","v":0}]
[{"$f":"'B-1 Funded Program '!A26","v":0},{"$f":"'B-1 Funded Program '!B26","v":0},{"$f":"'B-1 Funded Program '!C26","v":0},{"$f":"'B-1 Funded Program '!D26","v":0},{"$f":"'B-1 Funded Program '!E26","v":""},{"$f":"'B-1 Funded Program '!F26","v":0}]
[{"$f":"'B-1 Funded Program '!A27","v":0},{"$f":"'B-1 Funded Program '!B27","v":0},{"$f":"'B-1 Funded Program '!C27","v":0},{"$f":"'B-1 Funded Program '!D27","v":0},{"$f":"'B-1 Funded Program '!E27","v":""},{"$f":"'B-1 Funded Program '!F27","v":0}]
[{"$f":"'B-1 Funded Program '!A28","v":0},{"$f":"'B-1 Funded Program '!B28","v":0},{"$f":"'B-1 Funded Program '!C28","v":0},{"$f":"'B-1 Funded Program '!D28","v":0},{"$f":"'B-1 Funded Program '!E28","v":""},{"$f":"'B-1 Funded Program '!F28","v":0}]
[{"$f":"'B-1 Funded Program '!A29","v":0},{"$f":"'B-1 Funded Program '!B29","v":0},{"$f":"'B-1 Funded Program '!C29","v":0},{"$f":"'B-1 Funded Program '!D29","v":0},{"$f":"'B-1 Funded Program '!E29","v":""},{"$f":"'B-1 Funded Program '!F29","v":0}]
[{"$f":"'B-1 Funded Program '!A30","v":0},{"$f":"'B-1 Funded Program '!B30","v":0},{"$f":"'B-1 Funded Program '!C30","v":0},{"$f":"'B-1 Funded Program '!D30","v":0},{"$f":"'B-1 Funded Program '!E30","v":""},{"$f":"'B-1 Funded Program '!F30","v":0}]
[{"$f":"'B-1 Funded Program '!A31","v":0},{"$f":"'B-1 Funded Program '!B31","v":0},{"$f":"'B-1 Funded Program '!C31","v":0},{"$f":"'B-1 Funded Program '!D31","v":0},{"$f":"'B-1 Funded Program '!E31","v":""},{"$f":"'B-1 Funded Program '!F31","v":0}]
[{"$f":"'B-1 Funded Program '!A32","v":0},{"$f":"'B-1 Funded Program '!B32","v":0},{"$f":"'B-1 Funded Program '!C32","v":0},{"$f":"'B-1 Funded Program '!D32","v":0},{"$f":"'B-1 Funded Program '!E32","v":""},{"$f":"'B-1 Funded Program '!F32","v":0}]
[{"$f":"'B-1 Funded Program '!A33","v":0},{"$f":"'B-1 Funded Program '!B33","v":0},{"$f":"'B-1 Funded Program '!C33","v":0},{"$f":"'B-1 Funded Program '!D33","v":0},{"$f":"'B-1 Funded Program '!E33","v":""},{"$f":"'B-1 Funded Program '!F33","v":0}]
[null,{"$f":"COUNTIF(DirectServicesummary,\"X\")","v":0},{"$f":"COUNTIF(adminstaffsummary,\"X\")","v":0},null,{"$f":"SUM(ftesummary)","v":0},{"$f":"'B-1 Funded Program '!F34","v":0}]
["Total Direct Services FTE per Budget Proposal:",{"$f":"SUMIFS(E2:E20,B2:B20,\"X\")","v":0}]
["Available Annual Staff Hours per FTE (* 1,779)",{"$f":"1779*B22","v":0}]
["Annual Units (Must match B-1 Service Hours)",{"$f":"[0]!cmhours+[0]!mhhours+[0]!cihours","v":0}]
["Billable Staff Hours (Staff Hours/Annual Units)",{"$f":"B24/B23","v":{"$error":"#DIV/0!"}}]
["Bidder Name",{"$f":"[0]!Provider","v":0}]
["Program Name",{"$f":"[0]!Program","v":0}]
["Date Prepared",{"$f":"NOW()","v":"2013-07-30T10:24:27.320"}]