{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Budget Instructions","Detail & Justification","Budget Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Budget Instructions","index":0,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[[50,1,50,7],[53,0,53,7],[55,1,55,7],[48,1,48,7],[49,1,49,7],[51,1,51,7],[29,1,29,7],[32,1,32,7],[31,1,31,7],[33,1,33,7],[34,1,34,7],[30,1,30,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[40,1,40,7],[46,1,46,7],[44,1,44,7],[43,1,43,7],[39,1,39,7],[45,1,45,7],[42,1,42,7],[28,1,28,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[24,0,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[16,0,16,7],[1,0,1,7],[2,0,2,7],[4,1,4,7],[5,1,5,7],[7,0,7,7],[9,1,9,7],[11,1,11,7],[12,1,12,7],[13,1,13,7],[14,1,14,7]]}
[]
["GENERAL INFORMATION"]
["The Excel file provided by the Riverside Community Health Foundation contains the following worksheet tabs: "]
[]
["Detail & Justification:","All budget details and justifications must be provided in this worksheet."]
["Budget Summary:","Information provided on the budget Detail and Justification worksheet are summarized on this worksheet."]
[]
["KEY POINTS TO REMEMBER"]
[]
["KEY POINTS:","The following are some key points to remember when working in the file:"]
[]
["1)","All worksheet cells that allow data input are highlighted in yellow.  In other cells, numbers are automatically calculated by formulas.  To prevent accidental entries, these cells have been protected. Note: Press the tab key to move to the next yellow highlighted cell."]
["2)","All worksheets accommodate dollars but not cents.  If you enter dollars and cents,  for example $10,797.77, the file will drop the cents and reflect $10,797.  Please limit entries to whole numbers. "]
["3)","The Excel print command is set up to print on Standard 8.5\" x 11\" paper in landscape format for the Budget Worksheet and Justification, and portrait format for all other worksheets."]
[]
[]
["DETAIL AND JUSTIFICATION"]
[]
[]
["Organization Information","What to Enter"]
["Project Title:","Title the project in the following format: \"RCHF - IHI/ [Your Organization Name]\"                                                                                                                                                                                          "]
["Organization Name:","Organization Name"]
["Grant Number:","Grant Number (if funding is awarded, this will be added by the Foundation)\n(Do not enter anything because this is a protected cell)"]
["Grant Period:","Grant Period (if funding is awarded)\n(Do not enter anything because this is a protected cell)"]
[]
["Personnel Detail","What to Enter"]
["Title/ Job Classification","Title/Classification of each staff performing project activities identified in the SOW (e.g. Project Director)"]
["Annual Salary","Full-time annual salary for each job classification listed in the Personnel column"]
["% FTE","Total percentage of time to be allocated to project activities for each job classification listed in the personnel column"]
["Budgeted Amount","Annual salary multiplied by full time equivalent percentage                                                                                                                               (Do not enter anything because this is a protected cell)"]
["Request from RCHF","Amount requested from RCHF. If no funds are requested for a line item, enter 0 or leave blank."]
["Description of Expense","Name of the personnel for each Title/Job classification. Enter \"Vacant position\" if the position is vacant."]
["Total Wages","Sum of the budgeted amount for each line item                                                                                                                                                                             (Do not enter anything because this is a protected cell)"]
["Total Fringe Benefits","Combined fringe benefit costs for all job classifications listed in the Personnel column                                                                                                                                                       "]
["Total Personnel Expenses","Sum of Total Wages and Total Fringe Benefits                                                                                                                                                                (Do not enter anything because this is a protected cell)"]
[]
["Operating Expenses Detail","What to Enter"]
["Line Item","Operating Expense line items e.g., General Project Expenses; Travel; Training; Communication/Software; Project Equipment; and Expenses associated with project participants. "]
["Budgeted Amount","Budgeted amount for each Operating Expense itemized"]
["Request from RCHF","Amount requested from RCHF. If no funds are requested for a line item, enter 0 or leave blank."]
["Description of Expense","Purpose and a brief description justifying each Operating Expense Line Item"]
[]
["Subcontractor Expenses","What to Enter"]
["Line Item","List the name of each subcontractor. Enter one subcontractor per line."]
["Budgeted Amount","Budgeted amount for each subcontractor "]
["Request from RCHF","Amount requested from RCHF. If no funds are requested for a line item, enter 0 or leave blank."]
["Description of Expense","Provide the purpose and a brief description of each subcontractor. For each proposed subcontractor, applicant must upload a separate budget in the application form. "]
[]
["Indirect Cost Detail","What to Enter"]
["Indirect Rate","Up To 15% of Total Personnel "]
["Budgeted Amount","Indirect Rate (the percentage entered in cell F70) multiplied by the Total Personnel Expenses.                                                                                                                                                                                                                      (Do not enter anything because this is a protected cell)"]
["Request from RCHF","Amount requested from RCHF. If no Indirect Costs are requested, enter 0 or leave blank. The allowable value is between 0 and 15% of the Total Personnel Expenses in the Request from RCHF column."]
[]
["BUDGET SUMMARY"]
[]
["General Information","The Budget Summary worksheet provides a summarized version of the Detail & Justification worksheet.  (Do not enter anything because these are protected cells)                                                                                                                              "]

{"sheet":"Detail & Justification","index":1,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,7,2,8],[5,4,5,7],[0,7,0,8],[1,7,1,8],[3,7,3,8],[11,6,13,6],[11,7,13,7],[11,8,13,8],[12,0,13,0],[12,1,13,3],[12,4,13,4],[12,5,13,5],[6,1,6,2],[7,1,7,2],[8,1,8,2],[11,0,11,5],[17,1,17,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[36,1,36,5],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,0,26,5],[28,0,28,5],[27,0,27,5],[31,0,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[52,1,52,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[51,1,51,5],[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[41,1,41,5],[42,1,42,5],[43,1,43,5],[44,1,44,5],[45,1,45,5],[57,0,57,5],[53,1,53,5],[54,0,54,5],[61,1,61,5],[62,1,62,5],[68,0,68,5],[69,0,69,4],[70,0,70,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[63,1,63,5],[64,1,64,5],[65,1,65,5],[66,0,66,5]]}
[null,null,null,null,null,null,"Project Title:"]
[null,null,null,null,null,null,"Organization Name:"]
[null,null,null,null,null,null,"Grant Number:","[Blank]"]
[null,null,null,null,null,null,"Grant Period:","12/01/2018 to 11/30/2019"]
[]
[null,null,null,null,"Funding Request Information"]
[null,null,null,null,null,null,"Funding Requested",{"$f":"H29+H55+H67+H71","v":0}]
[null,null,null,null,null,null,"Total Project Budget",{"$f":"G29+G55+G67+G71","v":0}]
[null,null,null,null,null,null,"% of Total Project Budget Requested",{"$f":"H7/H8","v":{"$error":"#DIV/0!"}}]
[]
[]
["Personnel Detail",null,null,null,null,null,"Budgeted Amount","Request from RCHF","Description of Expense"]
[null," Personnel Detail\nTitle / Job Classification ",null,null,"Annual Salary"," FTE"]
[]
[1,null,null,null,null,null,{"$f":"IF(F15=0,\" \",ROUND((E15*F15),0))","v":" "}]
[2,null,null,null,null,null,{"$f":"IF(F16=0,\" \",ROUND((E16*F16),0))","v":" "}]
[3,null,null,null,null,null," "]
[4,null,null,null,null,null," "]
[5,null,null,null,null,null," "]
[6,null,null,null,null,null," "]
[7,null,null,null,null,null," "]
[8,null,null,null,null,null," "]
[9,null,null,null,null,null," "]
[10,null,null,null,null,null," "]
[11,null,null,null,null,null," "]
[12,null,null,null,null,null," "]
["Total Wages",null,null,null,null,null,{"$f":"ROUND((SUM(G15:G26)), 0)","v":0},{"$f":"ROUND((SUM(H15:H26)), 0)","v":0}]
["Total Fringe Benefits"]
["Total Personnel Expenses",null,null,null,null,null,{"$f":"ROUND((G27+G28), 0)","v":0},{"$f":"ROUND((H27+H28), 0)","v":0}]
[]
[]
["Operating Expenses Detail",null,null,null,null,null,"Budgeted Amount","Request from RCHF","Description of Expense"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
["Total Operating Expenses",null,null,null,null,null,{"$f":"ROUND((SUM(G33:G54)), 0)","v":0},{"$f":"ROUND((SUM(H33:H54)), 0)","v":0}]
[]
[]
["Subcontractor Expenses",null,null,null,null,null,"Budgeted Amount","Request from RCHF","Description of Expense"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
["Total Subcontractor Expenses",null,null,null,null,null,{"$f":"ROUND((SUM(G59:G66)), 0)","v":0},{"$f":"ROUND((SUM(H59:H66)), 0)","v":0}]
[]
["Indirect Costs Detail",null,null,null,null,null,"Budgeted Amount","Request from RCHF"]
["Up To 15% of Total Personnel (Enter Indirect Cost)",null,null,null,null,null,{"$f":"F70*G29","v":0},null,{"$f":"F70*H29","v":0}]
["Total Indirect Costs",null,null,null,null,0.1,{"$f":"ROUND(G70,0)","v":0},{"$f":"ROUND(H70,0)","v":0}]

{"sheet":"Budget Summary","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[12,2,12,5],[14,2,14,5],[16,2,16,5],[9,0,9,5],[2,3,2,7],[3,3,3,7],[4,3,4,7],[5,3,5,7],[10,2,10,5]]}
[null,null,null,null,null,"       Budget Summary"]
[]
[null,null,"Project Title:",{"$f":"'Detail & Justification'!H1","v":0}]
[null,null,"Organization Name:",{"$f":"'Detail & Justification'!H2","v":0}]
[null,null,"Grant Number:",{"$f":"'Detail & Justification'!H3","v":"[Blank]"}]
[null,null,"Grant Period:",{"$f":"'Detail & Justification'!H4","v":"12/01/2018 to 11/30/2019"}]
[]
[]
[]
["             Expense Categories",null,null,null,null,null,"Budget","Request from RCHF"]
[1,null,"Personnel Expenses",null,null,null,{"$f":"'Detail & Justification'!G29","v":0},{"$f":"'Detail & Justification'!H29","v":0}]
[]
[2,null,"Operating Expenses",null,null,null,{"$f":"'Detail & Justification'!G55","v":0},{"$f":"'Detail & Justification'!H55","v":0}]
[]
[3,null,"Subcontractor Expenses",null,null,null,{"$f":"'Detail & Justification'!G67","v":0},{"$f":"'Detail & Justification'!H67","v":0}]
[]
[4,null,"Indirect Costs",null,null,null,{"$f":"'Detail & Justification'!F70","v":0}]
[null,null,"(Indirect Cost = ",null,{"$f":"'Detail & Justification'!F70","v":0},"of Total Personnel)",{"$f":"'Detail & Justification'!G71","v":0},{"$f":"'Detail & Justification'!H71","v":0}]
[]
[null,null,null,null,null,"Total Budget",{"$f":"'Detail & Justification'!H8","v":0},{"$f":"'Detail & Justification'!H7","v":0}]
[]
[]
[null,null,null,null,null,null,"Percent of Total Project Budget Requested:",{"$f":"'Detail & Justification'!H9","v":{"$error":"#DIV/0!"}}]