{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["FY 11-12 Budget","11-12 Prof Services","11-12 Misc ","11-12 Admin Detail","FY 12-13 Budget","12-13 Prof Services ","12-13 Misc","12-13 Admin Detail "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":602,"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":"FY 11-12 Budget","index":0,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,3,1,5],[0,2,0,6],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[211,1,211,3],[2,2,2,3],[5,1,6,1],[141,0,142,0],[141,1,142,6],[3,2,3,6]]}
[null,"Program Name:","PEI Peer Mentorship Program"]
[null,"MHSA Funding Source:","PEI","County or Contract Program:",null,null,"Contract"]
[null,"Target Population ",null,null,"Fiscal Year","FY 11/12"]
[null,"Bidder Name:"]
[null,"SALARIES & WAGES"]
[null,"Position Titles/Classificaitons ","Direct Services ","Annualized Salary","Number of Positions","FTE","Annualized 12 month Budget"]
[null,null,"Mark with 'x'"]
[null,null,null,null,null,null,{"$f":"ROUND(D8*F8,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,"S/T Salaries & Wages",null,{"$f":"SUM(D8:D19)","v":0},{"$f":"SUM(E8:E19)","v":0},{"$f":"SUM(F8:F19)","v":0},{"$f":"SUBTOTAL(9,G7:G19)","v":0}]
[null,"Employee Benefits and Taxes (Enter %) ",null,null,null,null,{"$f":"ROUND(C21*G20,0)","v":0}]
[null,"TOTAL SAL, WAGES & BENEFITS",null,null,null,{"$f":"F20","v":0},{"$f":"SUBTOTAL(9,G7:G21)","v":0}]
[null,"Total Direct Service FTE",null,null,null,{"$f":"SUMIF(C8:C18,\"x\",F8:F18)","v":0}]
[]
[null,"OPERATING EXPENSES"]
[null,"Food"]
[null,"Office Expense"]
[null,"Recreational Supplies"]
[null,"Maintenance"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"Utilities"]
[null,"Communications"]
[null,"Membership Dues"]
[null,"Transportation"]
[null,"Travel"]
[null,"Training"]
[null,"*Professional & Specialized Services"]
[null,"Insurance"]
[null,"Taxes & Licenses"]
[null,"Rents & Leases"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"Depreciation"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"*Miscellaneous"]
[null,"     Marketing, Media & Educational Materials"]
[]
[]
[]
[]
[]
[]
[null,"TOTAL OPERATING EXPENSES",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G57)","v":0}]
[]
[]
[null,"*ADMINISTRATIVE COSTS",null,null,null,null,0]
[]
[null,"GROSS COST",null,null,null,null,{"$f":"G61+G58+G22","v":0}]
[]
[null,"REVENUE (SPECIFY, IF APPLICABLE):"]
[null,"Type",null,null,null,null,"Amount "]
[]
[]
[]
[]
[]
[null,"TOTAL REVENUE",null,null,null,null,{"$f":"SUM(G67:G71)","v":0}]
[]
[null,"MHSA COST",null,null,null,null,{"$f":"G63-G72","v":0}]

{"sheet":"11-12 Prof Services","index":1,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,1,8,2],[6,1,6,6],[0,0,1,6],[2,0,2,6],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6]]}
["EXPLANATION/DETAIL OF PROFESSIONAL AND SPECIALIZED SERVICES LINE ITEMS"]
[]
["Professional and Specialized Services"]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
["Bidder Nam",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 11-12 Budget'!F3","v":"FY 11/12"}]
["Line Item","*Professional & Specialized Services"]
[null,null,null,null,null,null,"Comments"]
[null,"Description/Detail",null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E49,E45,E41,E36,E32,E28,E24,E20,E16,E12)","v":0}]

{"sheet":"11-12 Misc ","index":2,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,1,8,2],[6,2,6,6],[0,0,1,6],[2,0,2,6],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6]]}
["EXPLANATION/DETAIL OF MISCELLANEOUS LINE ITEMS"]
[]
["Miscellaneous"]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
["Bidder Name",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 11-12 Budget'!F3","v":"FY 11/12"}]
["Line Item",null,"*Misc. "]
[null,null,null,null,null,null,"Comments"]
[null,"Description/Detail",null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E49,E45,E41,E36,E32,E28,E24,E20,E16,E12)","v":0}]

{"sheet":"11-12 Admin Detail","index":3,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,1,7,2],[5,2,5,6],[0,0,1,6],[2,2,2,6],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6]]}
["EXPLANATION/DETAIL OF ADMIN DETAIL"]
[]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
[" Bidder Name",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 11-12 Budget'!F3","v":"FY 11/12"}]
["Line Item",null,"* ADMIN"]
[null,null,null,null,null,null,"Comments"]
[null,{"$f":"'11-12 Misc '!B9:C9","v":"Description/Detail"},null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E48,E44,E40,E35,E31,E27,E23,E19,E15,E11)","v":0}]

{"sheet":"FY 12-13 Budget","index":4,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,2,0,6],[1,3,1,5],[2,2,2,3],[141,0,142,0],[141,1,142,6],[211,1,211,3],[3,2,3,6],[5,1,6,1],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6]]}
[null,"Program Name:","PEI Peer Mentorship Program"]
[null,"MHSA Funding Source:","PEI","County or Contract Program:",null,null,"Contract"]
[null,"Target Population ",{"$f":"'FY 11-12 Budget'!C3:D3","v":0},null,"Fiscal Year","FY 12/13"]
[null,"Bidder Name:",{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
[null,"SALARIES AND WAGES"]
[null,"Position Titles/Classifications","Direct Services ","Annualized Salary","Number of Positions","FTE","Annualized 12 month Budget"]
[null,null,"Mark with 'x'"]
[null,null,null,null,null,null,{"$f":"ROUND(D8*F8,0)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,"S/T Salaries & Wages",null,{"$f":"SUM(D8:D19)","v":0},{"$f":"SUM(E8:E19)","v":0},{"$f":"SUM(F8:F19)","v":0},{"$f":"SUBTOTAL(9,G8:G19)","v":0}]
[null,"Employee Benefits and Taxes (Enter %) ",null,null,null,null,{"$f":"ROUND(C21*G20,0)","v":0}]
[null,"TOTAL SAL, WAGES & BENEFITS",null,null,null,{"$f":"F20","v":0},{"$f":"SUBTOTAL(9,G7:G21)","v":0}]
[null,"Total Direct Service FTE",null,null,null,{"$f":"SUMIF(C8:C18,\"x\",F8:F18)","v":0}]
[]
[null,"OPERATING EXPENSES"]
[null,"Food"]
[null,"Office Expense"]
[null,"Recreational Supplies"]
[null,"Maintenance"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"Utilities"]
[null,"Communications"]
[null,"Membership Dues"]
[null,"Transportation"]
[null,"Travel"]
[null,"Training"]
[null,"*Professional & Specialized Services"]
[null,"Insurance"]
[null,"Taxes & Licenses"]
[null,"Rents & Leases"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"Depreciation"]
[null,"     Structure"]
[null,"     Equipment"]
[null,"     Vehicles"]
[null,"*Miscellaneous"]
[null,"     Marketing, Media & Educational Materials"]
[]
[]
[]
[]
[]
[]
[null,"TOTAL OPERATING EXPENSES",null,null,null,null,{"$f":"SUBTOTAL(9,G25:G57)","v":0}]
[]
[]
[null,"*ADMINISTRATIVE COSTS",null,null,null,null,0]
[]
[null,"GROSS COST",null,null,null,null,{"$f":"G61+G58+G22","v":0}]
[]
[null,"REVENUE (SPECIFY, IF APPLICABLE):"]
[null,"Type",null,null,null,null,"Amount "]
[]
[]
[]
[]
[]
[null,"TOTAL REVENUE",null,null,null,null,{"$f":"SUM(G67:G71)","v":0}]
[]
[null,"MHSA COST",null,null,null,null,{"$f":"G63-G72","v":0}]

{"sheet":"12-13 Prof Services ","index":5,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,1,8,2],[6,1,6,6],[0,0,1,6],[2,0,2,6],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6]]}
["EXPLANATION/DETAIL OF PROFESSIONAL AND SPECIALIZED SERVICES LINE ITEMS"]
[]
["Professional and Specialized Services"]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
["Bidder Nam",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 12-13 Budget'!F3","v":"FY 12/13"}]
["Line Item","*Professional & Specialized Services"]
[null,null,null,null,null,null,"Comments"]
[null,"Description/Detial ",null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E49,E45,E41,E36,E32,E28,E24,E20,E16,E12)","v":0}]

{"sheet":"12-13 Misc","index":6,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,1,8,2],[6,2,6,6],[0,0,1,6],[2,0,2,6],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6]]}
["EXPLANATION/DETAIL OF MISCELLANEOUS LINE ITEMS"]
[]
["Miscellaneous"]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
["Bidder Name",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 12-13 Budget'!F3","v":"FY 12/13"}]
["Line Item",null,"*Misc. "]
[null,null,null,null,null,null,"Comments"]
[null,"Description/Detail",null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E49,E45,E41,E36,E32,E28,E24,E20,E16,E12)","v":0}]

{"sheet":"12-13 Admin Detail ","index":7,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,1,7,2],[5,2,5,6],[0,0,1,6],[2,2,2,6],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6]]}
["EXPLANATION/DETAIL OF ADMIN DETAIL"]
[]
["Project Name",null,{"$f":"'FY 11-12 Budget'!C1:G1","v":"PEI Peer Mentorship Program"}]
[" Bidder Name",null,{"$f":"'FY 11-12 Budget'!C4:G4","v":0}]
["Fiscal Year",null,{"$f":"'FY 12-13 Budget'!F3","v":"FY 12/13"}]
["Line Item",null,"*ADMIN"]
[null,null,null,null,null,null,"Comments"]
[null,"Description/Detail",null,null,"Amount",null,"(Department Use)"]
["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,null,"Total Line Item Amount","$",{"$f":"SUM(E48,E44,E40,E35,E31,E27,E23,E19,E15,E11)","v":0}]