{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["SUMMARY BUDGET P.1 ","SALARIES P.2","SALARIES&FRINGE P.3","SALARIES&FRINGE P.3A","SUPPLIES,TRAVEL & EQUIP P.4","MISC  P.5","SUBCONTRACTS & INDIRECT P.6","BUDGET  JUSTIFICATION P.7"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":7,"comments":6,"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":"SUMMARY BUDGET P.1 ","index":0,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,2,31,4],[27,2,27,4],[32,2,32,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[8,0,8,2],[8,3,8,5],[11,1,11,7],[10,1,10,7],[12,1,12,7],[25,1,25,10],[22,1,22,8],[19,0,19,7],[24,1,24,8],[23,1,23,10],[22,0,23,0],[0,0,0,10],[5,3,5,5],[6,0,6,2],[7,0,7,2],[5,0,5,2],[6,3,6,5],[7,3,7,5],[1,0,1,10],[2,0,2,10],[14,1,14,7],[15,1,15,7],[17,1,17,7],[18,1,18,7],[13,1,13,7],[16,1,16,7]]}
["New York State Department Of Health"]
["Bureau of Health Equity and Community Engagement"]
["HRI Expenditure Based Budget Summary"]
[]
[]
["Contractor:",null,null,null,null,null,null,null,"Indicate intended voucher frequency with an (X) below:"]
["Contract Period:",null,null,null,null,null,null,null,"Quarterly"]
["Federal ID #:",null,null,null,null,null,null,null,"Monthly"]
[]
[]
[null,"Budget Items",null,null,null,null,null,null,"Amount Requested from Helath Disparities Program ",null,"Third Party Revenue"]
["(A)","SALARIES",null,null,null,null,null,null,{"$f":"'SALARIES P.2'!I33","v":0},null,{"$f":"'SALARIES P.2'!K33","v":0}]
["(B)","FRINGE BENEFITS",null,null,null,null,null,null,{"$f":"'SALARIES&FRINGE P.3'!H16","v":0},null,{"$f":"IF('SALARIES&FRINGE P.3'!H7=0,'SALARIES&FRINGE P.3'!H15*'SUMMARY BUDGET P.1 '!K12,'SALARIES&FRINGE P.3'!H7*'SUMMARY BUDGET P.1 '!K12)","v":0}]
["(C)","SUPPLIES",null,null,null,null,null,null,{"$f":"'SUPPLIES,TRAVEL & EQUIP P.4'!E13","v":0}]
["(D)","TRAVEL",null,null,null,null,null,null,{"$f":"'SUPPLIES,TRAVEL & EQUIP P.4'!J13","v":0}]
["(E)","EQUIPMENT",null,null,null,null,null,null,{"$f":"'SUPPLIES,TRAVEL & EQUIP P.4'!E43","v":0}]
["(F)","MISCELLANEOUS ",null,null,null,null,null,null,{"$f":"'MISC  P.5'!H50","v":0}]
["(G)","SUBCONTRACTS/CONSULTANTS",null,null,null,null,null,null,{"$f":"'SUBCONTRACTS & INDIRECT P.6'!J25","v":0}]
["(H)","INDIRECT COSTS",null,null,null,null,null,null,{"$f":"IF('SUBCONTRACTS & INDIRECT P.6'!E34=0,'SUBCONTRACTS & INDIRECT P.6'!E40,'SUBCONTRACTS & INDIRECT P.6'!E34)","v":0}]
["TOTAL (Sum of lines A through I)",null,null,null,null,null,null,null,{"$f":"SUM(I12:I19)","v":0},null,{"$f":"SUM(K12:K19)","v":0}]
[]
[null,"Notes:"]
[null,"1: Bureau of Health Equity and Community Engagement contract managers may require additional information necessary for approval of requested dollar amounts.  "]
[null,"2: In order to maintain confidentiality, please only put information in boxes as directed.Particular attention should be paid to position titles, job descriptions and any narrative that may"]
[null,"    contain personal information.  "]
[null,"3: When requesting payments for this contract, all expenses must be incurred within the contract period and paid for prior to the submittal of reimbursement vouchers."]
[]
[null,null,"Organization Type",null,null,"Administrative Requirements"]
[null,null,"Non-profit",null,null,"Uniform Guidance"]
[null,null,"Institutes of Higher Education",null,null,"Uniform Guidance"]
[null,null,"State, Local, and Indian Tribal governments",null,null,"Uniform Guidance"]
[null,null,"Hospitals ",null,null,"Appendix IX to 45 CFR Part 75"]
[null,null,"For Profit",null,null,"45 CFR Part 75"]

{"sheet":"SALARIES P.2","index":1,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,10],[10,1,10,3],[8,1,8,3],[3,3,3,4],[1,3,1,5],[6,1,6,3],[2,3,2,4],[3,8,3,10],[4,7,4,10],[23,1,23,3],[18,1,18,3],[27,1,27,3],[11,1,11,3],[1,0,1,2],[12,1,12,3],[2,0,2,2],[9,1,9,3],[3,0,3,2],[15,1,15,3],[7,1,7,3],[14,1,14,3],[25,1,25,3],[4,3,4,4],[5,1,5,3],[17,1,17,3],[30,1,30,3],[21,1,21,3],[36,1,36,10],[13,1,13,3],[31,1,31,3],[28,1,28,3],[20,1,20,3],[35,1,35,10],[22,1,22,3],[29,1,29,3],[19,1,19,3],[16,1,16,3],[34,1,34,10],[32,1,32,7],[26,1,26,3],[24,1,24,3]]}
["Salaries"]
["Contractor:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D7:E7","v":0}]
["Federal ID #:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D8:E8","v":0},null,null,null,null,"Number of pay periods in a calendar year:"]
[null,null,null,null,null,null,null,"Number of hours in full-time agency work week:"]
[null,"(1)",null,null,"(2)","(3)","(4)","(5)","(6)"]
[null,"Position Title/Incumbent Name(s)",null,null,"Hours Worked Per Week ","Annual Salary",null,null,"Amount Requested from BHECE","(1)","Third Party Revenue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SUBTOTAL ",null,null,null,null,null,null,{"$f":" SUM(I8:I32)","v":0},null,{"$f":"SUM(K8:K32)","v":0}]
[null,"Notes:",null,null,null,null,null,null,null,null,null,"(2)"]
[null,"1: If the full % of effort worked on this contract cannot be supported, this formula may need to be adjusted and a notation should be made that the balance is supported in-kind. "]
[null,"2: This rate has been calculated using the proportion of administrative salaries to the total salaries requested on the contract.  It may be applied to Other than Personal Services expenses where appropriate.   "]
[null,"3: Administrative salaries whose positions that are not directly related to patient care. When allocating salaries between administrative and program categories, the subcontractor must have a system of internal controls that justify the cost of the salaries, are reasonable over the long term, enter into the record on a timely manner, are consistent and auditable."]
[null,"4: Please note: Salary increases included on budget modifications must include the type of salary increase as well as a copy of the agency's approved written policy regarding salary increases. "]

{"sheet":"SALARIES&FRINGE P.3","index":2,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,8],[7,0,7,3],[24,0,25,8],[1,3,1,5],[2,3,2,4],[3,3,3,4],[1,0,1,2],[2,0,2,2],[3,0,3,2],[15,0,15,4],[9,0,9,6],[11,0,11,3],[19,1,19,7],[4,3,4,4],[28,3,31,8],[33,1,33,4],[44,1,44,4],[45,7,45,9],[40,3,43,8],[39,1,39,4],[34,3,37,8],[27,1,27,4],[18,1,18,7],[17,6,17,7]]}
["Fringe Benefits and Position Descriptions"]
["Contractor:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:"]
["Federal ID #:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D8:F8","v":0}]
[null,null,null,{"$f":"'SUMMARY BUDGET P.1 '!D9:E9","v":0}]
[" FRINGE BENEFITS"]
["1. Does your agency have a federally approved fringe benefit rate?    ",null,null,null,null,null,"Approved Rate (%) :"]
["    Contractor must attach a copy of federally approved rate agreement.",null,null,null,null,null,"Amount Requested ($):"]
[null,null,null,null,null,null,"Complete 2-7 below."]
["2. Total salary expense based on most recent audited financial statements:                "]
["3. Total fringe benefits expense based on most recent audited financial statements:   "]
["4. Agency Fringe Benefit Rate: (amount from #3 divided by amount from #2)",null,null,null,null,null,null,{"$f":"IF(H10 >0,(H11/H10),0)","v":0}]
["5. Date of most recently audited financial statements:"]
["     Attach a copy of the statement of functional expenses supporting the figures listed in #2 and #3."]
["6. Requested rate and amount for fringe benefits:",null,null,null,null,null,"Rate Requested (%) :"]
[null,null,null,null,null,null,"Amount Requested ($):"]
[]
["7. If the rate requested on this contract exceeds the rate supported by latest audited financials, please justify below."]
[]
[]
[]
[]
["POSITION DESCRIPTIONS"]
[]
["For each position listed on the salaries budget page, provide a brief description of the duties supported by this contract.   Contractors with consolidated contracts should indicate the initiative affiliated with the position.  All contractors must have full job descriptions on file and available upon request.  If additional space is needed, attach page 3a.  "]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]

{"sheet":"SALARIES&FRINGE P.3A","index":3,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,3,4,4],[37,3,40,8],[7,3,10,8],[36,1,36,4],[30,1,30,4],[31,3,34,8],[12,1,12,4],[18,1,18,4],[41,1,41,4],[5,0,5,8],[6,1,6,4],[24,1,24,4],[19,3,22,8],[13,3,16,8],[25,3,28,8],[3,0,3,2],[3,3,3,4],[0,0,0,8],[1,0,1,2],[2,0,2,2],[1,3,1,5],[2,3,2,4]]}
["Position Descriptions (continued)"]
["Contractor:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D7:E7","v":0}]
["Federal ID #:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D8:E8","v":0}]
[null,null,null,{"$f":"'SUMMARY BUDGET P.1 '!D9:E9","v":0}]
["For each position listed on the salary budget page, provide a brief description of the duties supported by this contract.   Contractors with consolidated contracts should indicate the initiative affiliated with the position.  All contractors must have full job descriptions on file and available upon request. "]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]
[]
[]
[]
[]
["Title:"]
["Contract Duties :"]

{"sheet":"SUPPLIES,TRAVEL & EQUIP P.4","index":4,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[44,0,44,4],[16,3,17,8],[5,7,6,9],[27,1,27,3],[28,1,28,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[23,5,23,9],[31,1,31,3],[33,1,33,3],[39,1,39,3],[41,1,41,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[0,0,0,9],[1,0,1,2],[2,0,2,2],[1,3,1,5],[2,3,2,4],[22,5,22,9],[26,5,26,9],[9,6,14,6],[5,2,5,4],[5,0,5,1],[21,1,21,3],[25,5,25,9],[26,1,26,3],[24,5,24,9],[22,1,22,3],[40,1,40,3],[29,1,29,3],[32,1,32,3],[3,0,3,2],[4,3,4,4],[3,3,3,4],[35,5,35,9],[30,5,30,9],[31,5,31,9],[33,5,33,9],[38,1,38,3],[30,1,30,3],[29,5,29,9],[32,5,32,9],[34,1,34,3],[27,5,27,9],[28,5,28,9],[34,5,34,9],[40,5,40,9],[41,5,41,9],[36,5,36,9],[37,5,37,9],[38,5,38,9],[39,5,39,9]]}
["Supplies, Travel and Equipment"]
["Contractor:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D7:F7","v":0}]
["Federal ID #:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D8:F8","v":0}]
[]
["SUPPLIES :",null,"Contractors should utilize their institution's policy for categorizing supplies and all software.",null,null,null," TRAVEL :","Include staff, client and conference travel.  Contract manager approval is required for out-of-state travel.  Funds budgeted for conference travel must be directly related to the funded program.  Contractors without reimbursement policies should use New York State travel reimbursement policy."]
[]
[]
[null,null,null,"Office :",null,null,"Is mileage requested?  Yes  No (circle one)",null,"Staff :"]
[null,null,null,"Program :",null,null,"(For personal auto or agency auto, proof of liability insurance is required. )",null,"Client (mileage only) :"]
[null,null,null,null,null,null,null,null,"Conference :"]
[]
[null,null,null,"Total  :",{"$f":"SUM(E9:E10)","v":0},null,null,null,"Total  :",{"$f":"SUM(J9:J11)","v":0}]
[null,null,null,null,{"$f":"E9","v":0}]
[]
[]
[" EQUIPMENT : ",null,null,"Itemize anticipated equipment purchases. Federal regulations define “equipment” as items with a unit cost of $5,000 or more. Some contractors will have similar thresholds to differentiate “equipment” from “supplies” and these thresholds may be lower than $5,000. Contractors should utilize their institution’s threshold policy for categorizing equipment for any items with a unit cost of less than $5,000. Items with a unit cost of $5,000 or more must be categorized as equipment"]
[]
[]
["What is your institution's threshold for equipment? _______________",null,null,null,"If your institution does not have a specific threshold you must follow the federal threshold of $5,000 or more."]
[]
[null,"Item",null,null,"Amount",null,null,"Justification"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total : ",{"$f":"SUM(E23:E42)","v":0}]

{"sheet":"MISC  P.5","index":5,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,6,6,8],[27,5,27,6],[28,5,31,8],[25,5,25,7],[20,5,20,6],[23,5,23,6],[22,5,22,6],[7,5,7,6],[15,5,15,6],[11,5,11,6],[14,5,14,6],[9,5,9,6],[8,5,8,6],[12,5,12,6],[26,5,26,6],[24,5,24,6],[5,0,5,4],[9,0,9,4],[22,0,22,4],[23,0,24,4],[20,0,20,3],[13,0,13,4],[8,0,8,4],[11,0,11,4],[7,0,7,4],[14,0,14,4],[12,0,12,4],[18,0,18,4],[19,0,19,4],[15,0,15,4],[0,0,0,8],[1,0,1,2],[4,3,4,4],[1,3,1,5],[3,0,3,2],[3,3,3,4],[2,0,2,2],[2,3,2,4],[42,5,42,6],[37,5,37,7],[47,5,48,8],[44,5,44,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[35,5,35,7],[36,5,36,7],[40,5,40,7],[38,5,38,7],[39,5,39,7],[21,5,21,6],[18,5,18,6],[16,0,16,4],[17,5,17,6],[17,0,17,4]]}
["Miscellaneous "]
["Contractor:",null,null,{"$f":"'[1]SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:",null,null,{"$f":"'[1]SUMMARY BUDGET P.1 '!D7:F7","v":0}]
["Federal ID #:",null,null,{"$f":"'[1]SUMMARY BUDGET P.1 '!D8:F8","v":0}]
[null,null,null,{"$f":"'[1]SUMMARY BUDGET P.1 '!D9:E9","v":0}]
["SPACE COSTS:",null,null,null,null," OTHER :","May include audit, postage, printing, insurance, equipment rental or maintenance, stipends, media advertising, recruitment, client travel or other appropriate costs.  Please indicate with an \"X\" if the item requested is a shared cost.  For shared costs, contractor must keep methodology on file to support the amount requested. If requesting insurance costs, please list type of insurance."]
["This Section for All Contracts"]
["(a) Provide an address for each site location in the box below. If additional space is needed, include additional sheets as necessary.",null,null,null,null,"Item",null,"Shared Cost","Amount"]
[]
[]
[]
[]
[]
["(b) Detail the methodology and calculation used to allocate space costs for each location supported by this contract in the box below. "]
[]
[]
[]
[]
[]
[]
["Total Space Costs Requested on this contract:"]
[]
[]
[]
[null,null,null,null,null,null,null,"Total :",{"$f":"SUM(I9:I24)","v":0}]
[]
[]
[null,null,null,null,null,"TELECOMMUNICATIONS:"]
[null,null,null,null,null,"Detail below the methodology and calculation used to allocate telecommunication costs to this contract. Include costs for all telephone lines funded by this contract, including fax and modem lines.  Include any telecommunication installation or equipment costs, hotline, long distance, cell phone or internet expenses that apply to this contract. Requests for cell phone costs must include a breakdown of those costs related to direct client services."]
[]
[]
[]
[null,null,null,null,null,"Item",null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total : ",{"$f":"SUM(I34:I41)","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I43-I44","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null," MISCELLANEOUS (Telecommunications, Space and Other)",{"$f":"I43+I25+E21","v":0}]

{"sheet":"SUBCONTRACTS & INDIRECT P.6","index":6,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,0,36,5],[19,0,19,3],[28,6,37,9],[23,0,23,3],[26,0,26,3],[20,0,20,3],[19,4,19,8],[22,4,22,8],[21,4,21,8],[18,0,18,3],[13,4,13,8],[17,4,17,8],[15,4,15,8],[14,4,14,8],[15,0,15,3],[5,3,5,4],[12,0,12,3],[13,0,13,3],[4,3,4,4],[4,0,4,2],[11,0,11,3],[7,1,9,9],[10,5,10,7],[41,5,42,9],[44,7,44,8],[11,4,11,8],[12,4,12,8],[17,0,17,3],[26,4,26,9],[25,0,25,3],[18,4,18,8],[23,4,23,8],[24,0,24,3],[14,0,14,3],[16,0,16,3],[21,0,21,3],[22,0,22,3],[20,4,20,8],[16,4,16,8],[0,0,0,9],[2,0,2,2],[3,0,3,2],[2,3,2,5],[3,3,3,4]]}
["Subcontracts/Consultants & Indirect Costs"]
[]
["Contractor:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D6:F6","v":0}]
["Contract Period:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D7:F7","v":0}]
["Federal ID #:",null,null,{"$f":"'SUMMARY BUDGET P.1 '!D8:E8","v":0}]
[]
[" SUBCONTRACTS/CONSULTANTS :"]
[null,"Provide a listing of all subcontracts, including consultant contracts, a description of the services to be provided and an estimate of the hours worked and rate per hour, if applicable.  If the subcontractor/consultant has not been selected, please indicate \"TBA\" in Agency/Name.  Contractors are required to use a structured selection process consistent with agency policy and maintain copies of all subcontracts and documentation of the selection process.  Line item budgets and workscopes must be submitted for each subcontractor/consultant budget over $10,000."]
[]
[]
[null,null,null,"Agency/Name",null,"Description of Services ",null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total  : ",{"$f":"SUM(J12:J24)","v":0}]
[null,null,null,null,null,null,null,null," For RW Grantee use only- Administrative Costs : "]
[null,null,null,null,"(Includes subcontracts/consultants who perform administrative, non service delivery functions.)"]
["INDIRECT COSTS:   Costs used to support the indirect rate requested may NOT be directly billed to the contract."]
[null,null,null,null,null,null,"MTDC defined:  All direct salaries and wages, applicable fringe, materials and supplies , and services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under each award).                                                                                                                                 Exclusions: equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support and the portion of each subaward in excess of $25,000.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      (1) All contractors are entitled to a 10% Indirect Cost Rate (MTDC) .\n(2) All contractors with a federally approved rate may request up to 20% of their approved rate unless otherwise stated in the RFA from which this contract was selected.\n"]
[" Does your agency have a federally approved indirect cost rate?    "]
[]
[null,null,null,"Rate Approved (%) : "]
[null,null,null,"Rate Requested (%) : "]
[null,null,null,"Amount Requested : "]
[]
["Submit a copy of the federally approved indirect rate agreement to support the request."]
[]
[null,null,null,"       Indicate the requested rate and amount for indirect costs."]
[null,null,null,"Rate Requested (%) : "]
[null,null,null,"Amount Requested ($) : "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"\n"]

{"sheet":"BUDGET  JUSTIFICATION P.7","index":7,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,3,6,7],[0,0,0,11],[1,0,1,11],[3,3,3,7],[4,3,4,7],[5,3,5,7]]}
["Bureau of Health Equity and Community Engagement"]
[" Budget Justification"]
[]
["Contractor:"]
["Contract Period:",null,null,{"$f":"'[2]SUMMARY BUDGET P.1 '!D7:F7","v":0}]
["Federal ID #:",null,null,{"$f":"'[2]SUMMARY BUDGET P.1 '!D8:F8","v":0}]
[]
["Please provide a narrative justification of all requested line items.  Attach this form to the budget forms. Budget Justification is limited to two double spaced pages."]
[null,null,null,null,"COLUMN III"]
[null,null,null,null,"EXPENDITURES","BALANCE"]
[null,null,null,null,"TO DATE"]