{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Program Budget","Dependent Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Program Budget","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,4,49,5],[47,3,47,5],[46,1,46,2],[46,3,46,5],[45,3,45,5],[47,1,47,2],[41,3,41,5],[42,3,42,5],[32,1,32,2],[9,0,14,10],[6,2,6,5],[7,2,7,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,3,35,5],[36,3,36,5],[37,3,37,5],[39,3,39,5],[23,1,23,2],[34,1,34,2],[25,1,25,2],[28,0,28,2],[45,0,45,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[33,1,33,2],[19,0,19,2],[22,1,22,2],[24,1,24,2],[38,3,38,5],[42,1,42,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[41,1,41,2],[40,1,40,2],[39,1,39,2],[38,1,38,2],[40,3,40,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[49,8,49,10],[0,0,0,10],[2,2,2,5],[6,0,6,1],[7,0,7,1],[21,1,21,2],[16,9,17,9],[16,10,17,10],[16,8,17,8],[16,7,17,7],[2,0,2,1],[3,0,3,1],[4,0,4,1],[20,1,20,2],[3,2,3,5],[4,2,4,5]]}
["Application Program Budget with Formula"]
[]
["Organization:"]
["Project:"]
["Total Amount Requested:",null,{"$f":"H50","v":0}]
[]
["Grant Process (Select One):"]
["Year(s) of Project:"]
[]
["About This Worksheet\nThis budget worksheet includes built-in guidance and calculations based on the selected grant process. Some fields may auto-populate or adjust available options. Cells with a red triangle contain helpful notes—hover over them for details. If prompted to Enable Content for macros, please click Allow so the worksheet functions properly.\n\nQuestions? Contact Nyssa Berhorst, Skaggs Legacy Grant Administrator | nyssa.berhorst@skaggsfoundation.org | 417-335-7340"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total","Year 1","Year 2","Year 3"]
[]
[]
["Personnel Expenses (List Each Position)",null,null,"Salary","FTE","Benefits & Payroll"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D22=\"\",F22=\"\"),\"\",IF(E22=\"\",D22+F22,D22*E22+F22))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D23=\"\",F23=\"\"),\"\",IF(E23=\"\",D23+F23,D23*E23+F23))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,"Total Personnel Costs",null,{"$f":"SUM(D21:D25)","v":0},null,{"$f":"SUM(F21:F25)","v":0},null,{"$f":"I26+J26+K26","v":0},{"$f":"SUM(I21:I25)","v":0},{"$f":"SUM(J21:J25)","v":0},0]
[]
[]
["Direct Expenses (List Each Item)",null,null,"Projected Cost"]
[null,"Conferences"]
[null,"Equipment, Major (> $5,000)"]
[null,"Equipment, Minor (< $5,000)"]
[null,"Printing",null,null,null,null,null,{"$f":"IF(AND(D33=\"\",F33=\"\"),\"\",IF(E33=\"\",D33+F33,D33*E33+F33))","v":""}]
[null,"Supplies",null,null,null,null,null,{"$f":"IF(AND(D34=\"\",F34=\"\"),\"\",IF(E34=\"\",D34+F34,D34*E34+F34))","v":""}]
[null,"Travel"]
[null,"Scholarships/Direct Patient Assistance",null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D38=\"\",F38=\"\"),\"\",IF(E38=\"\",D38+F38,D38*E38+F38))","v":""}]
[null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,"Total Direct Expenses",null,{"$f":"SUM(D30:D42)","v":0},null,null,null,{"$f":"SUM(H30:H42)","v":0},{"$f":"SUM(I30:I42)","v":0},{"$f":"SUM(J30:J42)","v":0},{"$f":"SUM(K30:K42)","v":0}]
[]
[]
["Indirect Expenses",null,null,"Projected Cost"]
[null,"Administrative Costs",null,null,null,null,null,{"$f":"IF(AND(D47=\"\",F47=\"\"),\"\",IF(E47=\"\",D47+F47,D47*E47+F47))","v":""}]
[null,"Total Administrative Costs",null,{"$f":"IF(D47=\"\",0,D47)","v":0},null,null,null,{"$f":"IF(H47=\"\",0,H47)","v":0},{"$f":"IF(I47=\"\",0,I47)","v":0},{"$f":"IF(J47=\"\",0,J47)","v":0},0]
[]
[null,null,null,null,"Total Amount to Request:",null,null,{"$f":"H26+H43+H48","v":0},{"$f":"IF(AND($C$7=\"Priority Health Needs > $10,001\",$H$50<=10000),\"PHN must be at least $10,001\",\nIF(AND($C$7=\"Helping Hands < $10,000\",$H$50>=10001),\"Helping Hands must be $10,000 or less\",\"\"))","v":""}]

{"sheet":"Dependent Lists","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Grant_Process","PHN_Years","HH_Year","FTE_Values"]
["Priority Health Needs > $10,001","1 Year (2026-2027)","1 Year (2026-2027)",0.25]
["Helping Hands < $10,000","2 Years (2026-2028)",null,0.5]
[null,"3 Years (2026-2029)",null,0.75]
[null,null,null,1]