{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","A - Summary","B - Personnel","C - Benefits & Taxes","D - Benefits & Taxes Narrative","E - Merit","F - Operations","G - Equipment","H - Equipment Narrative","I - Consultants","J - General Bud Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Instructions","index":0,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,1,4],[16,1,16,4],[20,1,20,4],[22,1,22,4],[25,1,25,4],[29,1,29,4],[23,1,23,4],[24,1,24,4],[26,1,26,4],[27,1,27,4],[45,2,45,4],[34,1,34,4],[38,1,38,4],[39,1,39,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[36,1,36,4],[44,2,44,4],[40,1,40,4],[35,1,35,4],[37,1,37,4],[42,1,42,4],[41,1,41,4]]}
[]
["Please note: All calculations are rounded to the nearest whole dollar. Where input is required on your part, please round to the nearest whole dollar. For the purpose of this budget, use the category \"Community Services\" to record \"General Prevention and Diversion Programs referenced in the original RFP. "]
[null,"This file includes:"]
[1,null,"Instructions"]
[null,null,"Table A - Summary"]
[null,null,"9 Detail Tabs"]
[null,null,null,"Table B - Personnel"]
[null,null,null,"Table C - Benefits & Taxes"]
[null,null,null,"Table D - Benefits & Taxes Narrative"]
[null,null,null,"Table E - Operations"]
[null,null,null,"Table E - Merit"]
[null,null,null,"Table F - Equipment"]
[null,null,null,"Table G - Equipment Narrative"]
[null,null,null,"Table H - Consultants"]
[null,null,null,"Table I - General Budget Information"]
[]
[null,"To view tabs, maximize both the Excel program as well as the spreadsheet.  To maximize click double box symbol between _ and X in the upper right hand corner of program.  "]
[]
[null,"Print this sheet for reference."]
[]
[2,"To begin completing the Budget Portion of your application for funding Click on the \"Summary\" tab and insert the number of youth to be served by each program (Light Blue Cell).  At the bottom of the summary table is an area to enter the number of shelter beds by type.  In this section, you will indicate the number of DHS shelter beds available. The utilization rate will automatically calculate. Be sure and indicate the Entity name below the summary table - this populates on all tables. If your entity utilizes rates only then fill in the \"Rates Only\" section and submit a printout of the \"Summary\" tab and \"General Bud Info\" tab only."]
[]
[3,"For \"Personnel\", complete all information on each type of position individually. If there are not enough rows for all of your personnel, please contact OJA Contracts with the number needed and a custom file will be created and emailed to you. Below is a narrative of requirements for each column."]
[null,"a) \"Position\": list the title of the position."]
[null,"b) \"FTE\" is the percentage of time that an employee works relative to a normal work week (i.e. 100% = full time, 50% = half time or 20 hr. week) X the number of positions being totaled for this particular position. Example - Three 1/2 time positions would be 1.5 FTE (5 FTE X 3). "]
[null,"c) \"Total Annual Salary\" is the amount of compensation, excluding benefits and taxes, that is paid or would be paid if the employee were working full time. For multiple employees reported under the same title, a weighted average must be calculated."]
[null,"d) \"Benefits and payroll taxes\" This field is automatically calculated from the \"Benefits\" Sheet."]
[null,"e)\"% Time\": Enter the fraction of time that the employee or group of employees is expected to spend for each given program. The spreadsheet will distribute the appropriate amount to each program based on the % of Time. If the % of time exceeds 100% then the cell will turn red. Whenever you encounter a red cell or red text, it means that there is an error - either exceeding 100% or out-of-balance between two totals which should be the same. If the Total percentage of all programs combined is over 100% then ERROR will appear in each calculated field for that position. The total \"% of time\" (including all programs) for each FTE must always equal 100%."]
[]
[null,"f) \"$ Amount\": This figure is calculated by the other entries and is a protected cell. This represents the employee costs for the listed program The formula is: FTE X (Annual Salary+Benefits and Taxes) X % Time"]
[null,"g) Other Programs: This represents the percentage of personnel salary to be used for Other Programs."]
[4,"The funding section that was at the bottom of each schedule in prior years is now entered on the summary page."]
[5,"For sheet \"Benefits & Taxes\" The Position and Program Salary fields are automatically pulled from the Personnel Sheet. To the right of the Benefit 1 through Benefit 2 labels, are classes of typical benefits and taxes. Either use these (i.e. Fica, Retirement, WC Ins., Other) or type over the default label to create your own. Each type of benefit or tax contains two columns. "]
[null,"The first column is the percentage to be applied against the position salary indicated in column C. That figure is then multiplied by the corresponding figure in the FTE column to obtain a total cost for the group of employees occupying that position. If within a particular group of positions there may be temporary or part-time employees that have a different benefits package, then on the Personnel sheet these groups should be listed separately. If you have benefits that are flat rates (not based on a percentage of salary) then use the last two areas of the spread sheet under"]
[null,"the headings 'Monthly Rate 1' and/or 'Monthly Rate2'. The amount listed should be a monthly amount. The spreadsheet will factor it for 12 months and apply to the number of FTE to determine a cost for the particular position listed. If you have more than two flat rates then multiple rates can be combined to create a monthly rate. If this method is used, please explain the computations in the \"Benefits & Taxes Narrative\". Column Q is for Longevity. This should be the amount calculated based on current staff. If there are vacant positions, chances are there will be no longevity since the employee is required to complete two years before becoming eligible"]
[6,"For sheet \"Benefits & Taxes Narrative\", provide a narrative that describes how the taxes and benefits were calculated beyond what is not self-evident from the \"Tax & Benefits\" sheet."]
[7,"For the \"Merit\" sheet, enter the total projected annual cost in column D. Then allocate by percentage (in the light blue shaded cells) for each program applicable."]
[{"$f":"+A37+1","v":8},"For the \"Operations\" sheet, enter total projected annual costs for each of the listed categories. Enter the percentage allocation for each program. If the \"Other\" category is more than 5% of the total operations budget, then provide a narrative describing the components of items in the \"Other\" category. "]
[{"$f":"+A38+1","v":9},"For the \"Equipment\" tab, please enter a description in column B, the total cost under column C (See cost principles for what makes up total cost). In the columns marked by '%' indicate the percentage of use to be provided for each program."]
[10,"For the \"Equipment Narrative\" - please answer the indicated questions using a separate sheet for each piece or group of equipment."]
[11,"For the \"Consultant\" sheet enter the name in column B and in column C enter a description of the type of consultant work being performed. Enter the total estimated annual cost in column D. Enter the percentage that this service will be used under the appropriate heading under the column designated by \"%\". "]
[12,"Click on the \"General Bud Info\" tab and complete questionnaire. "]
[13,"After all expenditures are listed, then fill in the funding on the summary page. This is done the same as prior years only the information is recorded on the summary page."]
["Other Instructions:"]
[null,null,"Please follow the submission instructions in the RFA."]
[null,null,"Note that if due to copying the green stripping is disrupted on the spreadsheet, press the \"apply green bar\" button"]

{"sheet":"A - Summary","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,1,18,8],[17,0,17,3],[17,5,17,15],[31,1,31,2],[31,3,31,14],[23,0,23,15],[21,1,21,15],[20,0,20,3],[0,0,0,15],[2,14,3,15],[2,0,4,0],[2,1,4,1],[2,4,2,5],[2,2,2,3],[2,12,2,13],[2,6,2,7],[2,8,2,9],[2,10,2,11]]}
[{"$f":"+\"Table A - Summary \" & FY","v":"Table A - Summary FY22"}]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
["Line","Category","Prevention",null,"Emergency Shelter",null,"CARS",null,"Life Skills",null,"FTOP",null,"Other Programs",null,"Total Costs"]
[null,null,"# of Clients",0,"# of Clients",0,"# of Clients",0,"# of Clients",0,"# of Clients",0,"# of Clients",0]
[null,null,"Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage"]
[1," Personnel Programs",{"$f":"+'B - Personnel'!G36","v":0},{"$f":"IF(C6=0,0,C6/C$11)","v":0},{"$f":"+'B - Personnel'!I36","v":0},{"$f":"IF(E6=0,0,E6/E$11)","v":0},{"$f":"+'B - Personnel'!K36","v":0},{"$f":"IF(G6=0,0,G6/G$11)","v":0},{"$f":"+'B - Personnel'!M36","v":0},{"$f":"IF(I6=0,0,I6/I$11)","v":0},{"$f":"+'B - Personnel'!O36","v":0},{"$f":"IF(K6=0,0,K6/K$11)","v":0},{"$f":"+'B - Personnel'!Q36","v":0},{"$f":"IF(M6=0,0,M6/M$11)","v":0},{"$f":"+G6+M6+E6+C6+I6","v":0},{"$f":"IF(O6=0,0,O6/O$11)","v":0}]
[2," Operating Expenses",{"$f":"+'F - Operations'!E42","v":0},{"$f":"IF(C7=0,0,C7/C$11)","v":0},{"$f":"+'F - Operations'!G42","v":0},{"$f":"IF(E7=0,0,E7/E$11)","v":0},{"$f":"+'F - Operations'!I42","v":0},{"$f":"IF(G7=0,0,G7/G$11)","v":0},{"$f":"+'F - Operations'!K42","v":0},{"$f":"IF(I7=0,0,I7/I$11)","v":0},{"$f":"+'F - Operations'!M42","v":0},{"$f":"IF(K7=0,0,K7/K$11)","v":0},{"$f":"+'F - Operations'!O42","v":0},{"$f":"IF(M7=0,0,M7/M$11)","v":0},{"$f":"+G7+M7+E7+C7+I7","v":0},{"$f":"IF(O7=0,0,O7/O$11)","v":0}]
[3," Merit Pay",{"$f":"+'E - Merit'!D6","v":0},{"$f":"IF(C8=0,0,C8/C$11)","v":0},{"$f":"+'E - Merit'!F6","v":0},{"$f":"IF(E8=0,0,E8/E$11)","v":0},{"$f":"+'E - Merit'!H6","v":0},{"$f":"IF(G8=0,0,G8/G$11)","v":0},{"$f":"+'E - Merit'!J6","v":0},{"$f":"IF(I8=0,0,I8/I$11)","v":0},{"$f":"+'E - Merit'!L6","v":0},{"$f":"IF(K8=0,0,K8/K$11)","v":0},{"$f":"+'E - Merit'!N6","v":0},{"$f":"IF(M8=0,0,M8/M$11)","v":0},0,{"$f":"IF(O8=0,0,O8/O$11)","v":0}]
[4," Equipment",{"$f":"+'G - Equipment'!E36","v":0},{"$f":"IF(C9=0,0,C9/C$11)","v":0},{"$f":"+'G - Equipment'!G36","v":0},{"$f":"IF(E9=0,0,E9/E$11)","v":0},{"$f":"+'G - Equipment'!I36","v":0},{"$f":"IF(G9=0,0,G9/G$11)","v":0},{"$f":"+'G - Equipment'!K36","v":0},{"$f":"IF(I9=0,0,I9/I$11)","v":0},{"$f":"+'G - Equipment'!M36","v":0},{"$f":"IF(K9=0,0,K9/K$11)","v":0},{"$f":"+'G - Equipment'!O36","v":0},{"$f":"IF(M9=0,0,M9/M$11)","v":0},0,{"$f":"IF(O9=0,0,O9/O$11)","v":0}]
[5," Contractor/Consultants",{"$f":"+'I - Consultants'!F36","v":0},{"$f":"IF(C10=0,0,C10/C$11)","v":0},{"$f":"+'I - Consultants'!H36","v":0},{"$f":"IF(E10=0,0,E10/E$11)","v":0},{"$f":"+'I - Consultants'!J36","v":0},{"$f":"IF(G10=0,0,G10/G$11)","v":0},{"$f":"+'I - Consultants'!L36","v":0},{"$f":"IF(I10=0,0,I10/I$11)","v":0},{"$f":"+'I - Consultants'!N36","v":0},{"$f":"IF(K10=0,0,K10/K$11)","v":0},{"$f":"+'I - Consultants'!P36","v":0},{"$f":"IF(M10=0,0,M10/M$11)","v":0},0,{"$f":"IF(O10=0,0,O10/O$11)","v":0}]
[6,"    Total",{"$f":"SUM(C6:C10)","v":0},0,0,0,{"$f":"SUM(G6:G10)","v":0},0,0,0,0,0,0,{"$f":"SUM(N6:N10)","v":0},{"$f":"SUM(O5:O10)","v":0},0]
[null,null,null,null,""]
[7,"Cost Reimbursement",{"$f":"+C11","v":0},{"$f":"IF(C$16<>0,+C13/C$16,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(K$16<>0,+K13/K$16,0)","v":0},null,null,{"$f":"+E13+C13","v":0},{"$f":"IF(O$16<>0,+O13/O$16,0)","v":0}]
[8,"Fixed Rate",0,{"$f":"IF(C$16<>0,+C14/C$16,0)","v":0},0,{"$f":"IF(E$16<>0,+E14/E$16,0)","v":0},0,{"$f":"IF(G$16<>0,+G14/G$16,0)","v":0},0,{"$f":"IF(I$16<>0,+I14/I$16,0)","v":0},0,{"$f":"IF(K$16<>0,+K14/K$16,0)","v":0},null,null,{"$f":"+I14+G14+E14+C14","v":0},{"$f":"IF(O$16<>0,+O14/O$16,0)","v":0}]
[9,"Other Funding ",0,{"$f":"IF(C$16<>0,+C15/C$16,0)","v":0},0,{"$f":"IF(E$16<>0,+E15/E$16,0)","v":0},0,{"$f":"IF(G$16<>0,+G15/G$16,0)","v":0},0,{"$f":"IF(I$16<>0,+I15/I$16,0)","v":0},0,{"$f":"IF(K$16<>0,+K15/K$16,0)","v":0},{"$f":"+M11","v":0},{"$f":"IF(M$16<>0,+M15/M$16,0)","v":0},{"$f":"+C15+E15+G15+M15+I15","v":0},{"$f":"IF(O$16<>0,+O15/O$16,0)","v":0}]
[10,"  Total",{"$f":"SUM(C13:C15)","v":0},0,0,0,0,0,{"$f":"SUM(I13:I15)","v":0},{"$f":"SUM(J13:J15)","v":0},{"$f":"SUM(K13:K15)","v":0},{"$f":"SUM(L13:L15)","v":0},{"$f":"SUM(M13:M15)","v":0},{"$f":"SUM(N13:N15)","v":0},{"$f":"+O15+O14+O13","v":0},{"$f":"SUM(P13:P15)","v":0}]
[11,"  Check",{"$f":"IF((+C11-C16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+E11-E16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+G11-G16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+I11-I16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+K11-K16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+M11-M16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"},null,{"$f":"IF((+O11-O16) = 0,\"OK\",\"Out-of-Bal.\")","v":"OK"}]
[{"$f":"IF(C13<>0,IF(C14<>0,\"Look at Outreach - Can't Have Both Fixed Rate and Cost Reimbursement\",\"\"),\"\")","v":""},null,null,null,""]
[12,"Estimated number of juveniles to be served by the program (Formula - total of the blue cells above)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D4+F4+N4+H4+J4+L4","v":0}]
[13,"Total Request for Funding From OJA (Total of Green Cells Above  C7 + C8 + E7 + E8 + G8 + I8 + K7 + K8)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C13+C14+E13+G14+I14+E14+K13+K14","v":0}]
[]
[null,"IMPORTANT NOTICES!"]
[]
["Any expenditures for items not included in your budget are NOT reimburseable.  Any revisions to the budget must be pre-approved in accordance with contract provisions. For the cost reimbursement portion of this contract, paid claims will be based on documented expenditures and not budgeted amounts."]
[]
[14,"Fixed Rate Only Election","Prevention","%","Emergency Shelter","%","CARS","%","Life Skills","%","FTOP","%","Other Programs","%","Grand Total","%"]
[null,null,0,{"$f":"IF($O$27<>0,+C27/$O$27,0)","v":0},0,{"$f":"IF($O$27<>0,+E27/$O$27,0)","v":0},0,{"$f":"IF($O$27<>0,+G27/$O$27,0)","v":0},0,{"$f":"IF($O$27<>0,+I27/$O$27,0)","v":0},0,{"$f":"IF($O$27<>0,+K27/$O$27,0)","v":0},0,{"$f":"IF($O$27<>0,+M27/$O$27,0)","v":0},{"$f":"+M27+K27+I27+G27+E27+C27","v":0},{"$f":"+D27+F27+H27+J27+L27+N27","v":0}]
[null,null,null,"OJA","Other Beds","Licensed","On-line","Off-line",null,null,null,null,"OJA Programs","%"]
[null,"Shelter Information:","Shelter Beds",0,0,0,{"$f":"+D29+E29","v":0},{"$f":"+F29-G29","v":0},null,null,null,null,{"$f":"+C27+E27+G27+I27+K27","v":0},{"$f":"IF($O$27<>0,+M29/$O$27,0)","v":0}]
[]
[]
[null,"Name of Organization:"]
[]
[null,"2021-04-21"]

{"sheet":"B - Personnel","index":2,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,2,39,3],[40,2,40,3],[0,10,0,20],[4,18,4,20],[41,2,41,3],[0,1,0,6],[3,5,3,6],[3,11,3,12],[36,5,36,6],[36,7,36,8],[36,0,36,4],[40,5,40,17],[3,9,3,10],[1,1,1,16],[3,7,3,8],[3,15,3,16],[37,5,37,17],[3,13,3,14],[38,5,38,17],[38,2,38,3]]}
["FY22",{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,null,"If the alternating line shading is changed due to copying from one cell to another, then press \"Apply Alternant Line Shading\" button"]
[null,"Table B - Personnel  - Programs  DO NOT CUT OR MOVE ITEMS IN THIS SPREADSHEET"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U"]
[null,null,null,null,null,"Prevention",null,"Shelter",null,"CARS",null,"Life Skills",null,"FTOP",null,"Other Prog.",null,"Tot%","Total Salary","Total B&T","Total"]
["Line","Position","FTE","Total Annual Salary","Benefits / Payroll Taxes","% Time","$ Amount","% Time","$ Amount","% Time","$ Amount","% Time","$ Amount","% Time","$ Amount","% Time","$ Amount",null,"Totals may not agree with individual amounts due to round-off error"]
[1,null,null,null,{"$f":"+'C - Benefits & Taxes'!T6","v":0},null,{"$f":"IF(($R6)<=1,+ROUND(F6*$C6*($D6+$E6),0),IF(F6=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R6)<=1,+ROUND(H6*$C6*($D6+$E6),0),IF(H6=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R6)<=1,+ROUND(J6*$C6*($D6+$E6),0),IF(J6=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R6)<=1,+ROUND(L6*$C6*($D6+$E6),0),IF(L6=0,0,\"Error\"))","v":0},null,0,null,{"$f":"IF((ROUND(+$R6,0))<=1,+ROUND(P6*$C6*(D6+E6),0),IF(P6=0,0,\"ERROR\"))","v":0},{"$f":"+F6+H6+J6+L6+N6+P6","v":0},{"$f":"+D6*C6","v":0},{"$f":"+E6*C6","v":0},{"$f":"+S6+T6","v":0}]
[2,null,null,null,{"$f":"+'C - Benefits & Taxes'!T7","v":0},null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"+F7+H7+J7+L7+N7+P7","v":0},{"$f":"+D7*C7","v":0},{"$f":"+E7*C7","v":0},{"$f":"+S7+T7","v":0}]
[3,null,null,null,{"$f":"+'C - Benefits & Taxes'!T8","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[4,null,null,null,{"$f":"+'C - Benefits & Taxes'!T9","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[5,null,null,null,{"$f":"+'C - Benefits & Taxes'!T10","v":0},null,{"$f":"IF(($R10)<=1,+ROUND(F10*$C10*($D10+$E10),0),IF(F10=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R10)<=1,+ROUND(H10*$C10*($D10+$E10),0),IF(H10=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R10)<=1,+ROUND(J10*$C10*($D10+$E10),0),IF(J10=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R10)<=1,+ROUND(L10*$C10*($D10+$E10),0),IF(L10=0,0,\"Error\"))","v":0},null,{"$f":"IF(($R10)<=1,+ROUND(N10*$C10*($D10+$E10),0),IF(N10=0,0,\"Error\"))","v":0},null,{"$f":"IF((ROUND(+$R10,0))<=1,+ROUND(P10*$C10*(D10+E10),0),IF(P10=0,0,\"ERROR\"))","v":0},0,{"$f":"+D10*C10","v":0},{"$f":"+E10*C10","v":0},{"$f":"+S10+T10","v":0}]
[6,null,null,null,{"$f":"+'C - Benefits & Taxes'!T11","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[7,null,null,null,{"$f":"+'C - Benefits & Taxes'!T12","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[8,null,null,null,{"$f":"+'C - Benefits & Taxes'!T13","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[9,null,null,null,{"$f":"+'C - Benefits & Taxes'!T14","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[10,null,null,null,{"$f":"+'C - Benefits & Taxes'!T15","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[11,null,null,null,{"$f":"+'C - Benefits & Taxes'!T16","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[12,null,null,null,{"$f":"+'C - Benefits & Taxes'!T17","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[13,null,null,null,{"$f":"+'C - Benefits & Taxes'!T18","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[14,null,null,null,{"$f":"+'C - Benefits & Taxes'!T19","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[15,null,null,null,{"$f":"+'C - Benefits & Taxes'!T20","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[16,null,null,null,{"$f":"+'C - Benefits & Taxes'!T21","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[17,null,null,null,{"$f":"+'C - Benefits & Taxes'!T22","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[18,null,null,null,{"$f":"+'C - Benefits & Taxes'!T23","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[19,null,null,null,{"$f":"+'C - Benefits & Taxes'!T24","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[20,null,null,null,{"$f":"+'C - Benefits & Taxes'!T25","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[21,null,null,null,{"$f":"+'C - Benefits & Taxes'!T26","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[22,null,null,null,{"$f":"+'C - Benefits & Taxes'!T27","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[23,null,null,null,{"$f":"+'C - Benefits & Taxes'!T28","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[24,null,null,null,{"$f":"+'C - Benefits & Taxes'!T29","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[25,null,null,null,{"$f":"+'C - Benefits & Taxes'!T30","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[26,null,null,null,{"$f":"+'C - Benefits & Taxes'!T31","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[27,null,null,null,{"$f":"+'C - Benefits & Taxes'!T32","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[28,null,null,null,{"$f":"+'C - Benefits & Taxes'!T33","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[29,null,null,null,{"$f":"+'C - Benefits & Taxes'!T34","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[30,null,null,null,{"$f":"+'C - Benefits & Taxes'!T35","v":0},null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0]
[31,"   Total Expenses",null,null,"`",null,{"$f":"SUM(G6:G35)","v":0},null,{"$f":"SUM(I6:I35)","v":0},null,{"$f":"SUM(K5:K35)","v":0},null,{"$f":"SUM(M5:M35)","v":0},null,{"$f":"SUM(O6:O35)","v":0},null,{"$f":"SUM(Q5:Q35)","v":0},null,{"$f":"SUM(S6:S35)","v":0},{"$f":"SUM(T6:T35)","v":0},0]
["Starting in FY16 funding is entered on the summary page"]
[null,"Totals"]
[null,"FTE (Col. C Total)",{"$f":"SUM(C6:C35)","v":0}]
[null,"Salary (Col D total)",{"$f":"SUM(S6:S35)","v":0}]
[null,"B&T (Col E Totals)",{"$f":"SUM(T6:T35)","v":0}]
[null,"Salary + B&T ",{"$f":"+C41+C40","v":0}]

{"sheet":"C - Benefits & Taxes","index":3,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,6],[3,19,4,19],[37,0,37,8],[39,0,39,7],[3,0,4,0],[3,1,4,1],[3,3,4,3],[1,1,1,8],[0,9,1,19]]}
[null,{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,"If the alternating line shading has changed due to copying from one cell to another, then press \"Apply Alternating Line Shading\" button"]
[{"$f":"+FY","v":"FY22"},"Table C -  Benefits/Taxes DO NOT CUT OR MOVE WITHIN THIS SPREADSHEET"]
["A","B","C","D","E","F","G","H","I","J","K","L","M ","N","O","P","Q","R","S","T"]
["Line","Position",null,"Program Salary","Benefit 1:","Fica","Benefit 2:","Retirement","Benefit 3:","WC Ins.","Benefit 4:","Unemployment","Benefit 5:","Other","Monthly","Health Ins","Monthly","Other","Longevity","Total Benefits Cost (Formula)"]
[null,null,"FTE",null,"%","Amount","%","Amount","%","Amount","%","Amount","%","Amount","Rate 1","Amount","Rate 2","Amount","avg per FTE"]
[1,{"$f":"IF(+'B - Personnel'!B6<>0,+'B - Personnel'!B6,\"\")","v":""},{"$f":"+'B - Personnel'!C6","v":0},{"$f":"+'B - Personnel'!D6","v":0},null,{"$f":"ROUND((IF($D6=\" \",0,$D6*E6)),2)","v":0},null,{"$f":"ROUND((IF($D6=\" \",0,$D6*G6)),2)","v":0},null,{"$f":"ROUND((IF($D6=\" \",0,$D6*I6)),2)","v":0},null,0,null,{"$f":"ROUND((IF($D6=\" \",0,$D6*M6)),2)","v":0},null,{"$f":"ROUND(+O6*12,2)","v":0},null,{"$f":"ROUND(+Q6*12,2)","v":0},null,{"$f":"+F6+H6+J6+N6+P6+R6+S6+L6","v":0}]
[2,{"$f":"IF(+'B - Personnel'!B7<>0,+'B - Personnel'!B7,\"\")","v":""},{"$f":"+'B - Personnel'!C7","v":0},{"$f":"+'B - Personnel'!D7","v":0},null,{"$f":"ROUND((IF($D7=\" \",0,$D7*E7)),2)","v":0},null,{"$f":"ROUND((IF($D7=\" \",0,$D7*G7)),2)","v":0},null,{"$f":"ROUND((IF($D7=\" \",0,$D7*I7)),2)","v":0},null,{"$f":"ROUND((IF($D7=\" \",0,$D7*K7)),2)","v":0},null,{"$f":"ROUND((IF($D7=\" \",0,$D7*M7)),2)","v":0},null,{"$f":"ROUND(+O7*12,2)","v":0},null,{"$f":"ROUND(+Q7*12,2)","v":0},null,{"$f":"+F7+H7+J7+N7+P7+R7+S7+L7","v":0}]
[3,{"$f":"IF(+'B - Personnel'!B8<>0,+'B - Personnel'!B8,\"\")","v":""},{"$f":"+'B - Personnel'!C8","v":0},{"$f":"+'B - Personnel'!D8","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[4,{"$f":"IF(+'B - Personnel'!B9<>0,+'B - Personnel'!B9,\"\")","v":""},{"$f":"+'B - Personnel'!C9","v":0},{"$f":"+'B - Personnel'!D9","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[5,{"$f":"IF(+'B - Personnel'!B10<>0,+'B - Personnel'!B10,\"\")","v":""},{"$f":"+'B - Personnel'!C10","v":0},{"$f":"+'B - Personnel'!D10","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[6,{"$f":"IF(+'B - Personnel'!B11<>0,+'B - Personnel'!B11,\"\")","v":""},{"$f":"+'B - Personnel'!C11","v":0},{"$f":"+'B - Personnel'!D11","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[7,{"$f":"IF(+'B - Personnel'!B12<>0,+'B - Personnel'!B12,\"\")","v":""},{"$f":"+'B - Personnel'!C12","v":0},{"$f":"+'B - Personnel'!D12","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[8,{"$f":"IF(+'B - Personnel'!B13<>0,+'B - Personnel'!B13,\"\")","v":""},{"$f":"+'B - Personnel'!C13","v":0},{"$f":"+'B - Personnel'!D13","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[9,{"$f":"IF(+'B - Personnel'!B14<>0,+'B - Personnel'!B14,\"\")","v":""},{"$f":"+'B - Personnel'!C14","v":0},{"$f":"+'B - Personnel'!D14","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[10,{"$f":"IF(+'B - Personnel'!B15<>0,+'B - Personnel'!B15,\"\")","v":""},{"$f":"+'B - Personnel'!C15","v":0},{"$f":"+'B - Personnel'!D15","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[11,{"$f":"IF(+'B - Personnel'!B16<>0,+'B - Personnel'!B16,\"\")","v":""},{"$f":"+'B - Personnel'!C16","v":0},{"$f":"+'B - Personnel'!D16","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[12,{"$f":"IF(+'B - Personnel'!B17<>0,+'B - Personnel'!B17,\"\")","v":""},{"$f":"+'B - Personnel'!C17","v":0},{"$f":"+'B - Personnel'!D17","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[13,{"$f":"IF(+'B - Personnel'!B18<>0,+'B - Personnel'!B18,\"\")","v":""},{"$f":"+'B - Personnel'!C18","v":0},{"$f":"+'B - Personnel'!D18","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[14,{"$f":"IF(+'B - Personnel'!B19<>0,+'B - Personnel'!B19,\"\")","v":""},{"$f":"+'B - Personnel'!C19","v":0},{"$f":"+'B - Personnel'!D19","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[15,{"$f":"IF(+'B - Personnel'!B20<>0,+'B - Personnel'!B20,\"\")","v":""},{"$f":"+'B - Personnel'!C20","v":0},{"$f":"+'B - Personnel'!D20","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[16,{"$f":"IF(+'B - Personnel'!B21<>0,+'B - Personnel'!B21,\"\")","v":""},{"$f":"+'B - Personnel'!C21","v":0},{"$f":"+'B - Personnel'!D21","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[17,{"$f":"IF(+'B - Personnel'!B22<>0,+'B - Personnel'!B22,\"\")","v":""},{"$f":"+'B - Personnel'!C22","v":0},{"$f":"+'B - Personnel'!D22","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[18,{"$f":"IF(+'B - Personnel'!B23<>0,+'B - Personnel'!B23,\"\")","v":""},{"$f":"+'B - Personnel'!C23","v":0},{"$f":"+'B - Personnel'!D23","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[19,{"$f":"IF(+'B - Personnel'!B24<>0,+'B - Personnel'!B24,\"\")","v":""},{"$f":"+'B - Personnel'!C24","v":0},{"$f":"+'B - Personnel'!D24","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[20,{"$f":"IF(+'B - Personnel'!B25<>0,+'B - Personnel'!B25,\"\")","v":""},{"$f":"+'B - Personnel'!C25","v":0},{"$f":"+'B - Personnel'!D25","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[21,{"$f":"IF(+'B - Personnel'!B26<>0,+'B - Personnel'!B26,\"\")","v":""},{"$f":"+'B - Personnel'!C26","v":0},{"$f":"+'B - Personnel'!D26","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[22,{"$f":"IF(+'B - Personnel'!B27<>0,+'B - Personnel'!B27,\"\")","v":""},{"$f":"+'B - Personnel'!C27","v":0},{"$f":"+'B - Personnel'!D27","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[23,{"$f":"IF(+'B - Personnel'!B28<>0,+'B - Personnel'!B28,\"\")","v":""},{"$f":"+'B - Personnel'!C28","v":0},{"$f":"+'B - Personnel'!D28","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[24,{"$f":"IF(+'B - Personnel'!B29<>0,+'B - Personnel'!B29,\"\")","v":""},{"$f":"+'B - Personnel'!C29","v":0},{"$f":"+'B - Personnel'!D29","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[25,{"$f":"IF(+'B - Personnel'!B30<>0,+'B - Personnel'!B30,\"\")","v":""},{"$f":"+'B - Personnel'!C30","v":0},{"$f":"+'B - Personnel'!D30","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[26,{"$f":"IF(+'B - Personnel'!B31<>0,+'B - Personnel'!B31,\"\")","v":""},{"$f":"+'B - Personnel'!C31","v":0},{"$f":"+'B - Personnel'!D31","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[27,{"$f":"IF(+'B - Personnel'!B32<>0,+'B - Personnel'!B32,\"\")","v":""},{"$f":"+'B - Personnel'!C32","v":0},{"$f":"+'B - Personnel'!D32","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[28,{"$f":"IF(+'B - Personnel'!B33<>0,+'B - Personnel'!B33,\"\")","v":""},{"$f":"+'B - Personnel'!C33","v":0},{"$f":"+'B - Personnel'!D33","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[29,{"$f":"IF(+'B - Personnel'!B34<>0,+'B - Personnel'!B34,\"\")","v":""},{"$f":"+'B - Personnel'!C34","v":0},{"$f":"+'B - Personnel'!D34","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[30,{"$f":"IF(+'B - Personnel'!B35<>0,+'B - Personnel'!B35,\"\")","v":""},{"$f":"+'B - Personnel'!C35","v":0},{"$f":"+'B - Personnel'!D35","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[31,"Totals",{"$f":"SUM(C5:C35)","v":0},{"$f":"SUM(D4:D35)","v":0},null,{"$f":"SUM(F6:F35)","v":0},null,{"$f":"SUM(H6:H35)","v":0},null,{"$f":"SUM(J6:J35)","v":0},null,{"$f":"SUM(L6:L35)","v":0},null,{"$f":"SUM(N6:N35)","v":0},null,{"$f":"SUM(P6:P35)","v":0},null,{"$f":"SUM(R6:R35)","v":0},{"$f":"SUM(S6:S35)","v":0},{"$f":"+F36+H36+J36+N36+P36+R36+S36","v":0}]
[]
["Include a description in the \"Benefit\" box (e.g., Benefit 1: FICA, Benefit 2: Insurance, etc.)"]

{"sheet":"D - Benefits & Taxes Narrative","index":4,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[5,0,5,12],[6,0,6,12],[2,0,2,12],[0,0,0,7],[3,0,3,12],[4,0,4,12]]}
[{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"}]
["Table D - Benefits and Taxes Narrative",null,null,null,null,null,{"$f":"+FY","v":"FY22"}]
["1) Please describe your entity's benefits and taxes computations including a description of all components. If benefits vary by classification of employees, describe each class separately. Please do not expand the size of the boxes below - move to a new box if you run out of space. Attach additional pages as needed."]

{"sheet":"E - Merit","index":5,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,16],[0,0,0,7],[6,1,6,14],[0,9,0,16],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,12,3,13],[3,10,3,11]]}
[{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,null,"Enter into light blue shaded areas"]
[{"$f":"+FY","v":"FY22"},"Table E - Merit pay estimate and Narrative DO NOT CUT OR MOVE ITEMS IN THIS SPREADSHEET"]
[{"$f":"+'G - Equipment'!A3","v":"A"},"B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q"]
[null,null,{"$f":"+'G - Equipment'!D4","v":"Prevention"},null,"Shelter",null,"CARS",null,"Life Skills",null,"FTOP",null,"Other Programs",null,"Tot%","Total","Check"]
["Line","Merit Pay Total $","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount"]
[1,null,null,{"$f":"IF(($O6)<=1,+ROUND(C6*$B6,0),IF(C6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($O6)<=1,+ROUND(E6*$B6,0),IF(E6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($O6)<=1,+ROUND(G6*$B6,0),IF(G6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($O6)<=1,+ROUND(I6*$B6,0),IF(I6=0,\"\",\"Error\"))","v":0},null,0,null,{"$f":"IF(($O6)<=1,+ROUND(M6*$B6,0),IF(M6=0,\"\",\"Error\"))","v":0},{"$f":"+C6+E6+G6+M6+I6+K6","v":0},{"$f":"ROUND(+D6+F6+H6+J6+L6+N6,0)","v":0},{"$f":"IF(+P6-B6 = 0,\"Balanced\",P6-B6)","v":"Balanced"}]
[]
["Note: ","Any use of Merit Pay must comply with OJA policy P-15-01-01 \"Merit and Longevity Pay for Contracted Employees\""]

{"sheet":"F - Operations","index":6,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,9,1,17],[3,7,3,8],[3,3,3,4],[3,5,3,6],[3,13,3,14],[3,9,3,10],[3,11,3,12]]}
[null,{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,"If the alternating line shading has changed due to copying from one cell to another, then press \"Apply Alternating Line Shading\" button"]
[{"$f":"+FY","v":"FY22"},"Table F - Operations DO NOT CUT OR MOVE ITEMS IN THIS SPREADSHEET"]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R"]
[null,null,null,{"$f":"+'B - Personnel'!F4","v":"Prevention"},null,"Shelter",null,"Cars",null,"Life Skills",null,"FTOP",null,"Other Programs",null,"Tot%","Total","Check"]
["Line","Description","Total Annual Cost","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount"]
[1,null,null,{"$f":"IF(E6 = 0,0,+E6/$C6)","v":0},null,{"$f":"IF(G6 = 0,0,+G6/$C6)","v":0},null,{"$f":"IF(I6 = 0,0,+I6/$C6)","v":0},null,{"$f":"IF(K6 = 0,0,+K6/$C6)","v":0},null,{"$f":"IF(M6 = 0,0,+M6/$C6)","v":0},null,{"$f":"IF(O6 = 0,0,+O6/$C6)","v":0},null,{"$f":"IF(Q6 = 0,0,+Q6/$C6)","v":0},{"$f":"E6+G6+I6+K6+M6+O6","v":0},{"$f":"IF(ROUND(+E6+G6+I6+K6+M6+O6-C6,0) = 0,\"Balanced\",\"Error\")","v":"Balanced"}]
[2,null,null,{"$f":"IF(E7 = 0,0,+E7/$C7)","v":0},null,{"$f":"IF(G7 = 0,0,+G7/$C7)","v":0},null,{"$f":"IF(I7 = 0,0,+I7/$C7)","v":0},null,{"$f":"IF(K7 = 0,0,+K7/$C7)","v":0},null,{"$f":"IF(M7 = 0,0,+M7/$C7)","v":0},null,{"$f":"IF(O7 = 0,0,+O7/$C7)","v":0},null,{"$f":"IF(Q7 = 0,0,+Q7/$C7)","v":0},{"$f":"E7+G7+I7+K7+M7+O7","v":0},{"$f":"IF(ROUND(+E7+G7+I7+K7+M7+O7-C7,0) = 0,\"Balanced\",\"Error\")","v":"Balanced"}]
[3,null,null,0,null,{"$f":"IF(G8 = 0,0,+G8/$C8)","v":0},null,{"$f":"IF(I8 = 0,0,+I8/$C8)","v":0},null,{"$f":"IF(K8 = 0,0,+K8/$C8)","v":0},null,{"$f":"IF(M8 = 0,0,+M8/$C8)","v":0},null,{"$f":"IF(O8 = 0,0,+O8/$C8)","v":0},null,{"$f":"IF(Q8 = 0,0,+Q8/$C8)","v":0},0,"Balanced"]
[4,null,null,0,null,{"$f":"IF(G9 = 0,0,+G9/$C9)","v":0},null,{"$f":"IF(I9 = 0,0,+I9/$C9)","v":0},null,{"$f":"IF(K9 = 0,0,+K9/$C9)","v":0},null,{"$f":"IF(M9 = 0,0,+M9/$C9)","v":0},null,{"$f":"IF(O9 = 0,0,+O9/$C9)","v":0},null,{"$f":"IF(Q9 = 0,0,+Q9/$C9)","v":0},0,"Balanced"]
[5,null,null,0,null,{"$f":"IF(G10 = 0,0,+G10/$C10)","v":0},null,{"$f":"IF(I10 = 0,0,+I10/$C10)","v":0},null,{"$f":"IF(K10 = 0,0,+K10/$C10)","v":0},null,{"$f":"IF(M10 = 0,0,+M10/$C10)","v":0},null,{"$f":"IF(O10 = 0,0,+O10/$C10)","v":0},null,{"$f":"IF(Q10 = 0,0,+Q10/$C10)","v":0},0,"Balanced"]
[6,null,null,0,null,{"$f":"IF(G11 = 0,0,+G11/$C11)","v":0},null,{"$f":"IF(I11 = 0,0,+I11/$C11)","v":0},null,{"$f":"IF(K11 = 0,0,+K11/$C11)","v":0},null,{"$f":"IF(M11 = 0,0,+M11/$C11)","v":0},null,{"$f":"IF(O11 = 0,0,+O11/$C11)","v":0},null,{"$f":"IF(Q11 = 0,0,+Q11/$C11)","v":0},0,"Balanced"]
[7,null,null,0,null,{"$f":"IF(G12 = 0,0,+G12/$C12)","v":0},null,{"$f":"IF(I12 = 0,0,+I12/$C12)","v":0},null,{"$f":"IF(K12 = 0,0,+K12/$C12)","v":0},null,{"$f":"IF(M12 = 0,0,+M12/$C12)","v":0},null,{"$f":"IF(O12 = 0,0,+O12/$C12)","v":0},null,{"$f":"IF(Q12 = 0,0,+Q12/$C12)","v":0},0,"Balanced"]
[8,null,null,0,null,{"$f":"IF(G13 = 0,0,+G13/$C13)","v":0},null,{"$f":"IF(I13 = 0,0,+I13/$C13)","v":0},null,{"$f":"IF(K13 = 0,0,+K13/$C13)","v":0},null,{"$f":"IF(M13 = 0,0,+M13/$C13)","v":0},null,{"$f":"IF(O13 = 0,0,+O13/$C13)","v":0},null,{"$f":"IF(Q13 = 0,0,+Q13/$C13)","v":0},0,"Balanced"]
[9,null,null,0,null,{"$f":"IF(G14 = 0,0,+G14/$C14)","v":0},null,{"$f":"IF(I14 = 0,0,+I14/$C14)","v":0},null,{"$f":"IF(K14 = 0,0,+K14/$C14)","v":0},null,{"$f":"IF(M14 = 0,0,+M14/$C14)","v":0},null,{"$f":"IF(O14 = 0,0,+O14/$C14)","v":0},null,{"$f":"IF(Q14 = 0,0,+Q14/$C14)","v":0},0,"Balanced"]
[10,null,null,0,null,{"$f":"IF(G15 = 0,0,+G15/$C15)","v":0},null,{"$f":"IF(I15 = 0,0,+I15/$C15)","v":0},null,{"$f":"IF(K15 = 0,0,+K15/$C15)","v":0},null,{"$f":"IF(M15 = 0,0,+M15/$C15)","v":0},null,{"$f":"IF(O15 = 0,0,+O15/$C15)","v":0},null,{"$f":"IF(Q15 = 0,0,+Q15/$C15)","v":0},0,"Balanced"]
[11,null,null,0,null,{"$f":"IF(G16 = 0,0,+G16/$C16)","v":0},null,{"$f":"IF(I16 = 0,0,+I16/$C16)","v":0},null,{"$f":"IF(K16 = 0,0,+K16/$C16)","v":0},null,{"$f":"IF(M16 = 0,0,+M16/$C16)","v":0},null,{"$f":"IF(O16 = 0,0,+O16/$C16)","v":0},null,{"$f":"IF(Q16 = 0,0,+Q16/$C16)","v":0},0,"Balanced"]
[12,null,null,0,null,{"$f":"IF(G17 = 0,0,+G17/$C17)","v":0},null,{"$f":"IF(I17 = 0,0,+I17/$C17)","v":0},null,{"$f":"IF(K17 = 0,0,+K17/$C17)","v":0},null,{"$f":"IF(M17 = 0,0,+M17/$C17)","v":0},null,{"$f":"IF(O17 = 0,0,+O17/$C17)","v":0},null,{"$f":"IF(Q17 = 0,0,+Q17/$C17)","v":0},0,"Balanced"]
[13,null,null,0,null,{"$f":"IF(G18 = 0,0,+G18/$C18)","v":0},null,{"$f":"IF(I18 = 0,0,+I18/$C18)","v":0},null,{"$f":"IF(K18 = 0,0,+K18/$C18)","v":0},null,{"$f":"IF(M18 = 0,0,+M18/$C18)","v":0},null,{"$f":"IF(O18 = 0,0,+O18/$C18)","v":0},null,{"$f":"IF(Q18 = 0,0,+Q18/$C18)","v":0},0,"Balanced"]
[14,null,null,0,null,{"$f":"IF(G19 = 0,0,+G19/$C19)","v":0},null,{"$f":"IF(I19 = 0,0,+I19/$C19)","v":0},null,{"$f":"IF(K19 = 0,0,+K19/$C19)","v":0},null,{"$f":"IF(M19 = 0,0,+M19/$C19)","v":0},null,{"$f":"IF(O19 = 0,0,+O19/$C19)","v":0},null,{"$f":"IF(Q19 = 0,0,+Q19/$C19)","v":0},0,"Balanced"]
[15,null,null,0,null,{"$f":"IF(G20 = 0,0,+G20/$C20)","v":0},null,{"$f":"IF(I20 = 0,0,+I20/$C20)","v":0},null,{"$f":"IF(K20 = 0,0,+K20/$C20)","v":0},null,{"$f":"IF(M20 = 0,0,+M20/$C20)","v":0},null,{"$f":"IF(O20 = 0,0,+O20/$C20)","v":0},null,{"$f":"IF(Q20 = 0,0,+Q20/$C20)","v":0},0,"Balanced"]
[16,null,null,0,null,{"$f":"IF(G21 = 0,0,+G21/$C21)","v":0},null,{"$f":"IF(I21 = 0,0,+I21/$C21)","v":0},null,{"$f":"IF(K21 = 0,0,+K21/$C21)","v":0},null,{"$f":"IF(M21 = 0,0,+M21/$C21)","v":0},null,{"$f":"IF(O21 = 0,0,+O21/$C21)","v":0},null,{"$f":"IF(Q21 = 0,0,+Q21/$C21)","v":0},0,"Balanced"]
[17,null,null,0,null,{"$f":"IF(G22 = 0,0,+G22/$C22)","v":0},null,{"$f":"IF(I22 = 0,0,+I22/$C22)","v":0},null,{"$f":"IF(K22 = 0,0,+K22/$C22)","v":0},null,{"$f":"IF(M22 = 0,0,+M22/$C22)","v":0},null,{"$f":"IF(O22 = 0,0,+O22/$C22)","v":0},null,{"$f":"IF(Q22 = 0,0,+Q22/$C22)","v":0},0,"Balanced"]
[18,null,null,0,null,{"$f":"IF(G23 = 0,0,+G23/$C23)","v":0},null,{"$f":"IF(I23 = 0,0,+I23/$C23)","v":0},null,{"$f":"IF(K23 = 0,0,+K23/$C23)","v":0},null,{"$f":"IF(M23 = 0,0,+M23/$C23)","v":0},null,{"$f":"IF(O23 = 0,0,+O23/$C23)","v":0},null,{"$f":"IF(Q23 = 0,0,+Q23/$C23)","v":0},0,"Balanced"]
[19,null,null,0,null,{"$f":"IF(G24 = 0,0,+G24/$C24)","v":0},null,{"$f":"IF(I24 = 0,0,+I24/$C24)","v":0},null,{"$f":"IF(K24 = 0,0,+K24/$C24)","v":0},null,{"$f":"IF(M24 = 0,0,+M24/$C24)","v":0},null,{"$f":"IF(O24 = 0,0,+O24/$C24)","v":0},null,{"$f":"IF(Q24 = 0,0,+Q24/$C24)","v":0},0,"Balanced"]
[20,null,null,0,null,{"$f":"IF(G25 = 0,0,+G25/$C25)","v":0},null,{"$f":"IF(I25 = 0,0,+I25/$C25)","v":0},null,{"$f":"IF(K25 = 0,0,+K25/$C25)","v":0},null,{"$f":"IF(M25 = 0,0,+M25/$C25)","v":0},null,{"$f":"IF(O25 = 0,0,+O25/$C25)","v":0},null,{"$f":"IF(Q25 = 0,0,+Q25/$C25)","v":0},0,"Balanced"]
[21,null,null,0,null,{"$f":"IF(G26 = 0,0,+G26/$C26)","v":0},null,{"$f":"IF(I26 = 0,0,+I26/$C26)","v":0},null,{"$f":"IF(K26 = 0,0,+K26/$C26)","v":0},null,{"$f":"IF(M26 = 0,0,+M26/$C26)","v":0},null,{"$f":"IF(O26 = 0,0,+O26/$C26)","v":0},null,{"$f":"IF(Q26 = 0,0,+Q26/$C26)","v":0},0,"Balanced"]
[22,null,null,0,null,{"$f":"IF(G27 = 0,0,+G27/$C27)","v":0},null,{"$f":"IF(I27 = 0,0,+I27/$C27)","v":0},null,{"$f":"IF(K27 = 0,0,+K27/$C27)","v":0},null,{"$f":"IF(M27 = 0,0,+M27/$C27)","v":0},null,{"$f":"IF(O27 = 0,0,+O27/$C27)","v":0},null,{"$f":"IF(Q27 = 0,0,+Q27/$C27)","v":0},0,"Balanced"]
[23,null,null,0,null,{"$f":"IF(G28 = 0,0,+G28/$C28)","v":0},null,{"$f":"IF(I28 = 0,0,+I28/$C28)","v":0},null,{"$f":"IF(K28 = 0,0,+K28/$C28)","v":0},null,{"$f":"IF(M28 = 0,0,+M28/$C28)","v":0},null,{"$f":"IF(O28 = 0,0,+O28/$C28)","v":0},null,{"$f":"IF(Q28 = 0,0,+Q28/$C28)","v":0},0,"Balanced"]
[24,null,null,0,null,{"$f":"IF(G29 = 0,0,+G29/$C29)","v":0},null,{"$f":"IF(I29 = 0,0,+I29/$C29)","v":0},null,{"$f":"IF(K29 = 0,0,+K29/$C29)","v":0},null,{"$f":"IF(M29 = 0,0,+M29/$C29)","v":0},null,{"$f":"IF(O29 = 0,0,+O29/$C29)","v":0},null,{"$f":"IF(Q29 = 0,0,+Q29/$C29)","v":0},0,"Balanced"]
[25,null,null,0,null,{"$f":"IF(G30 = 0,0,+G30/$C30)","v":0},null,{"$f":"IF(I30 = 0,0,+I30/$C30)","v":0},null,{"$f":"IF(K30 = 0,0,+K30/$C30)","v":0},null,{"$f":"IF(M30 = 0,0,+M30/$C30)","v":0},null,{"$f":"IF(O30 = 0,0,+O30/$C30)","v":0},null,{"$f":"IF(Q30 = 0,0,+Q30/$C30)","v":0},0,"Balanced"]
[26,null,null,0,null,{"$f":"IF(G31 = 0,0,+G31/$C31)","v":0},null,{"$f":"IF(I31 = 0,0,+I31/$C31)","v":0},null,{"$f":"IF(K31 = 0,0,+K31/$C31)","v":0},null,{"$f":"IF(M31 = 0,0,+M31/$C31)","v":0},null,{"$f":"IF(O31 = 0,0,+O31/$C31)","v":0},null,{"$f":"IF(Q31 = 0,0,+Q31/$C31)","v":0},0,"Balanced"]
[27,null,null,0,null,{"$f":"IF(G32 = 0,0,+G32/$C32)","v":0},null,{"$f":"IF(I32 = 0,0,+I32/$C32)","v":0},null,{"$f":"IF(K32 = 0,0,+K32/$C32)","v":0},null,{"$f":"IF(M32 = 0,0,+M32/$C32)","v":0},null,{"$f":"IF(O32 = 0,0,+O32/$C32)","v":0},null,{"$f":"IF(Q32 = 0,0,+Q32/$C32)","v":0},0,"Balanced"]
[28,null,null,0,null,{"$f":"IF(G33 = 0,0,+G33/$C33)","v":0},null,{"$f":"IF(I33 = 0,0,+I33/$C33)","v":0},null,{"$f":"IF(K33 = 0,0,+K33/$C33)","v":0},null,{"$f":"IF(M33 = 0,0,+M33/$C33)","v":0},null,{"$f":"IF(O33 = 0,0,+O33/$C33)","v":0},null,{"$f":"IF(Q33 = 0,0,+Q33/$C33)","v":0},0,"Balanced"]
[29,null,null,0,null,{"$f":"IF(G34 = 0,0,+G34/$C34)","v":0},null,{"$f":"IF(I34 = 0,0,+I34/$C34)","v":0},null,{"$f":"IF(K34 = 0,0,+K34/$C34)","v":0},null,{"$f":"IF(M34 = 0,0,+M34/$C34)","v":0},null,{"$f":"IF(O34 = 0,0,+O34/$C34)","v":0},null,{"$f":"IF(Q34 = 0,0,+Q34/$C34)","v":0},0,"Balanced"]
[30,null,null,0,null,{"$f":"IF(G35 = 0,0,+G35/$C35)","v":0},null,{"$f":"IF(I35 = 0,0,+I35/$C35)","v":0},null,{"$f":"IF(K35 = 0,0,+K35/$C35)","v":0},null,{"$f":"IF(M35 = 0,0,+M35/$C35)","v":0},null,{"$f":"IF(O35 = 0,0,+O35/$C35)","v":0},null,{"$f":"IF(Q35 = 0,0,+Q35/$C35)","v":0},0,"Balanced"]
[31,null,null,0,null,{"$f":"IF(G36 = 0,0,+G36/$C36)","v":0},null,{"$f":"IF(I36 = 0,0,+I36/$C36)","v":0},null,{"$f":"IF(K36 = 0,0,+K36/$C36)","v":0},null,{"$f":"IF(M36 = 0,0,+M36/$C36)","v":0},null,{"$f":"IF(O36 = 0,0,+O36/$C36)","v":0},null,{"$f":"IF(Q36 = 0,0,+Q36/$C36)","v":0},0,"Balanced"]
[32,null,null,0,null,{"$f":"IF(G37 = 0,0,+G37/$C37)","v":0},null,{"$f":"IF(I37 = 0,0,+I37/$C37)","v":0},null,{"$f":"IF(K37 = 0,0,+K37/$C37)","v":0},null,{"$f":"IF(M37 = 0,0,+M37/$C37)","v":0},null,{"$f":"IF(O37 = 0,0,+O37/$C37)","v":0},null,{"$f":"IF(Q37 = 0,0,+Q37/$C37)","v":0},0,"Balanced"]
[33,null,null,0,null,{"$f":"IF(G38 = 0,0,+G38/$C38)","v":0},null,{"$f":"IF(I38 = 0,0,+I38/$C38)","v":0},null,{"$f":"IF(K38 = 0,0,+K38/$C38)","v":0},null,{"$f":"IF(M38 = 0,0,+M38/$C38)","v":0},null,{"$f":"IF(O38 = 0,0,+O38/$C38)","v":0},null,{"$f":"IF(Q38 = 0,0,+Q38/$C38)","v":0},0,"Balanced"]
[34,null,null,0,null,{"$f":"IF(G39 = 0,0,+G39/$C39)","v":0},null,{"$f":"IF(I39 = 0,0,+I39/$C39)","v":0},null,{"$f":"IF(K39 = 0,0,+K39/$C39)","v":0},null,{"$f":"IF(M39 = 0,0,+M39/$C39)","v":0},null,{"$f":"IF(O39 = 0,0,+O39/$C39)","v":0},null,{"$f":"IF(Q39 = 0,0,+Q39/$C39)","v":0},0,"Balanced"]
[35,null,null,0,null,{"$f":"IF(G40 = 0,0,+G40/$C40)","v":0},null,{"$f":"IF(I40 = 0,0,+I40/$C40)","v":0},null,{"$f":"IF(K40 = 0,0,+K40/$C40)","v":0},null,{"$f":"IF(M40 = 0,0,+M40/$C40)","v":0},null,{"$f":"IF(O40 = 0,0,+O40/$C40)","v":0},null,{"$f":"IF(Q40 = 0,0,+Q40/$C40)","v":0},0,"Balanced"]
[36,null,null,0,null,{"$f":"IF(G41 = 0,0,+G41/$C41)","v":0},null,{"$f":"IF(I41 = 0,0,+I41/$C41)","v":0},null,{"$f":"IF(K41 = 0,0,+K41/$C41)","v":0},null,{"$f":"IF(M41 = 0,0,+M41/$C41)","v":0},null,{"$f":"IF(O41 = 0,0,+O41/$C41)","v":0},null,{"$f":"IF(Q41 = 0,0,+Q41/$C41)","v":0},0,"Balanced"]
[37,"   Totals",{"$f":"SUM(C6:C41)","v":0},null,{"$f":"SUM(E6:E41)","v":0},null,{"$f":"SUM(G6:G41)","v":0},null,{"$f":"SUM(I6:I41)","v":0},null,{"$f":"SUM(K6:K41)","v":0},null,{"$f":"SUM(M6:M41)","v":0},null,{"$f":"SUM(O6:O41)","v":0}]

{"sheet":"G - Equipment","index":7,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,10,1,17],[3,9,3,10],[3,3,3,4],[3,5,3,6],[3,13,3,14],[3,7,3,8],[3,11,3,12]]}
[{"$f":"+FY","v":"FY22"},{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,null,"If the alternating line shading has changed due to copying from one cell to another, then press \"Apply Alternating Line Shading\" button"]
["Table G - Equipment DO NOT CUT OR MOVE ITEMS IN THIS SPREADSHEET"]
[{"$f":"+'F - Operations'!A3","v":"A"},{"$f":"+'F - Operations'!B3","v":"B"},{"$f":"+'F - Operations'!C3","v":"C"},{"$f":"+'F - Operations'!D3","v":"D"},{"$f":"+'F - Operations'!E3","v":"E"},{"$f":"+'F - Operations'!F3","v":"F"},{"$f":"+'F - Operations'!G3","v":"G"},{"$f":"+'F - Operations'!H3","v":"H"},{"$f":"+'F - Operations'!I3","v":"I"},"J","K","L","M",{"$f":"+'F - Operations'!N3","v":"N"},"O","P","Q","R"]
[null,null,null,{"$f":"+'F - Operations'!D4","v":"Prevention"},null,"Shelter",null,"Cars",null,"Life Skills",null,"FTOP",null,"Other Programs",null,"Tot%","Total","Check"]
["Line","Description","Total Cost","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount"]
[1,null,null,null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(D6*$C6,0),IF(D6=0,0,\"ERROR\"))","v":0},null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(F6*$C6,0),IF(F6=0,0,\"ERROR\"))","v":0},null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(H6*$C6,0),IF(H6=0,0,\"ERROR\"))","v":0},null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(J6*$C6,0),IF(J6=0,0,\"ERROR\"))","v":0},null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(L6*$C6,0),IF(L6=0,0,\"ERROR\"))","v":0},null,{"$f":"IF((ROUND(+$P6,0))<=1,+ROUND(N6*$C6,0),IF(N6=0,0,\"ERROR\"))","v":0},{"$f":"+D6+H6+F6+N6+J6","v":0},{"$f":"ROUND(+E6+G6+I6+K6+M6+O6,0)","v":0},{"$f":"IF(+Q6-C6 = 0,\"Balanced\",Q6-C6)","v":"Balanced"}]
[2,null,null,null,0,null,0,null,0,null,0,null,0,null,0,{"$f":"+D7+H7+F7+N7","v":0},{"$f":"ROUND(+E7+G7+I7+K7+M7+O7,0)","v":0},{"$f":"IF(+Q7-C7 = 0,\"Balanced\",Q7-C7)","v":"Balanced"}]
[3,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,{"$f":"IF(+Q8-C8 = 0,\"Balanced\",Q8-C8)","v":"Balanced"}]
[4,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[5,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[6,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[7,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[8,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[9,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[10,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[11,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[12,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[13,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[14,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[15,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[16,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[17,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[18,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[19,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[20,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[21,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[22,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[23,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[24,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[25,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[26,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[27,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[28,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[29,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[30,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[31,"   Totals",{"$f":"SUM(C6:C35)","v":0},null,{"$f":"SUM(E6:E35)","v":0},null,{"$f":"SUM(G6:G35)","v":0},null,{"$f":"SUM(I6:I35)","v":0},null,{"$f":"SUM(K6:K35)","v":0},null,{"$f":"SUM(M6:M35)","v":0},null,{"$f":"SUM(O6:O35)","v":0},null,{"$f":"SUM(Q6:Q35)","v":0}]

{"sheet":"H - Equipment Narrative","index":8,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,10],[9,0,9,3],[4,0,4,6],[6,0,6,2],[7,0,7,1],[8,0,8,1],[5,0,5,10]]}
[{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,null,null,null,{"$f":"+FY","v":"FY22"}]
["Table H - Equipment Narrative - Item# _____________"]
["Please submit a separate sheet for each type of equipment to be purchased with OJA funds."]
[]
["1) Explain  how the equipment will be used for the program:"]
[]
["2) Installments (Yes or No)"]
["3) Number of Units:"]
["4) Price per unit:"]
["5) Is this replacing existing equipment?"]

{"sheet":"I - Consultants","index":9,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,10,3,11],[0,1,0,5],[3,4,3,5],[3,14,3,15],[3,6,3,7],[3,8,3,9],[0,10,1,18],[3,12,3,13]]}
[{"$f":"+FY","v":"FY22"},{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"},null,null,null,null,null,null,null,null,"If the alternating line shading has changed due to copying from one cell to another, then press \"Apply Alternating Line Shading\" button"]
["Table I - Consultant - Contractor DO NOT CUT OR MOVE ITEMS IN THIS SPREADSHEET"]
[{"$f":"+'G - Equipment'!A3","v":"A"},{"$f":"+'G - Equipment'!B3","v":"B"},{"$f":"+'G - Equipment'!C3","v":"C"},{"$f":"+'G - Equipment'!D3","v":"D"},{"$f":"+'G - Equipment'!E3","v":"E"},{"$f":"+'G - Equipment'!F3","v":"F"},{"$f":"+'G - Equipment'!G3","v":"G"},{"$f":"+'G - Equipment'!H3","v":"H"},{"$f":"+'G - Equipment'!I3","v":"I"},"J","K","L","M","N","O","P","Q","R","S"]
[null,null,null,null,{"$f":"+'G - Equipment'!D4","v":"Prevention"},null,"Shelter",null,"CARS",null,"Life Skills",null,"FTOP",null,"Other Programs",null,"Tot%","Total","Check"]
["Line","Name or Organization if known","Service Description","Total Cost","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount","%","$ Amount"]
[1,null,null,null,null,{"$f":"IF(($Q6)<=1,+ROUND(E6*$D6,0),IF(E6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q6)<=1,+ROUND(G6*$D6,0),IF(G6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q6)<=1,+ROUND(I6*$D6,0),IF(I6=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q6)<=1,+ROUND(K6*$D6,0),IF(K6=0,\"\",\"Error\"))","v":0},null,0,null,{"$f":"IF(($Q6)<=1,+ROUND(O6*$D6,0),IF(O6=0,\"\",\"Error\"))","v":0},{"$f":"+E6+G6+I6+K6+M6+O6","v":0},{"$f":"ROUND(+F6+H6+J6+L6+N6+P6,0)","v":0},{"$f":"IF(+R6-D6 = 0,\"Balanced\",R6-D6)","v":"Balanced"}]
[2,null,null,null,null,{"$f":"IF(($Q7)<=1,+ROUND(E7*$D7,0),IF(E7=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q7)<=1,+ROUND(G7*$D7,0),IF(G7=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q7)<=1,+ROUND(I7*$D7,0),IF(I7=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q7)<=1,+ROUND(K7*$D7,0),IF(K7=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q7)<=1,+ROUND(M7*$D7,0),IF(M7=0,\"\",\"Error\"))","v":0},null,{"$f":"IF(($Q7)<=1,+ROUND(O7*$D7,0),IF(O7=0,\"\",\"Error\"))","v":0},0,{"$f":"ROUND(+F7+H7+J7+L7+N7+P7,0)","v":0},{"$f":"IF(+R7-D7 = 0,\"Balanced\",R7-D7)","v":"Balanced"}]
[3,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[4,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[5,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[6,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[7,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[8,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[9,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[10,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[11,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[12,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[13,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[14,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[15,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[16,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[17,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[18,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[19,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[20,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[21,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[22,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[23,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[24,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[25,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[26,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[27,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[28,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[29,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[30,null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,0,0,"Balanced"]
[31,"   Totals",null,{"$f":"SUM(D5:D35)","v":0},null,{"$f":"SUM(F6:F35)","v":0},null,{"$f":"SUM(H6:H35)","v":0},null,{"$f":"SUM(J6:J35)","v":0},null,{"$f":"SUM(L6:L35)","v":0},null,{"$f":"SUM(N6:N35)","v":0},null,{"$f":"SUM(P6:P35)","v":0}]

{"sheet":"J - General Bud Info","index":10,"n_rows":20,"n_cols":256,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,9],[6,1,6,8],[18,7,18,8],[18,2,18,5],[17,1,17,12],[11,11,11,12],[12,11,12,12],[15,1,15,9],[11,1,12,8],[11,0,12,0],[9,1,9,8],[7,1,7,8],[3,0,4,0],[3,10,4,10],[10,0,10,12],[8,1,8,8],[3,11,3,12],[3,9,4,9],[3,1,4,8],[5,1,5,8]]}
[{"$f":"+FY","v":"FY22"},{"$f":"IF(+'A - Summary'!$D32>0,+'A - Summary'!$D32,\"Please Enter Entity Name at the Bottom of Summary Sheet\")","v":"Please Enter Entity Name at the Bottom of Summary Sheet"}]
["Table J - General Budget Information",null,null,null,null,null,null,null,null,null,null,null,null,"Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information","Table N - General Budget Information"]
["A","B","C","D","E","F","G","H","I","J","K","L","M"]
["Line ","Question",null,null,null,null,null,null,null,"Yes","No","State use only for verification of applicant's response"]
[null,null,null,null,null,null,null,null,null,null,null,"Date verified","Initials"]
[1,"Applicant has not been debarred or suspended by the federal government. (If \"No,\" attach an explanation)"]
[2,"Applicant and its subcontractors are up-to-date on all financial and progress reports for existing contracts with OJA."]
[3,"Applicant and its subcontractors are up-to-date on all audit reports due to OJA."]
[4,"All acquisitions will be made in accordance with OJA procurement procedures (or applicant's procedures if such procedures are more restrictive than OJA procedures)."]
[5,"Applicant understands that it may not request funds in advance (i.e., applicant must incur and make payment for all acquisitions before seeking reimbursement from OJA)."]
[]
[6,"Applicant's fiscal year (starting month and ending month)",null,null,null,null,null,null,null,"Beginning Month","Ending Month","For OJA use only"]
[]
[]
[]
[]
[null,"Print Name",null,null,null,null,"Title"]
[null,"By electronicaly submitting this document the above individual represented by the printed signature certifies that to the best of their knowledge the information in this document and all other documents that make up the FY21 RFA Application for Community-based services are true and accurate."]
[null,"Signature",null,null,null,null,"Date"]
[null,"`"]