{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HMST Project Budget Template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"HMST Project Budget Template","index":0,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[8,2,10,2],[79,1,82,7],[46,2,48,2],[7,2,7,6],[84,1,90,7]]}
[null,"MULTI-YEAR GRANT PROJECT BUDGET TEMPLATE"]
[null,"Only complete the shaded areas below.  The budgeted total income MUST equal the budgeted total expenses. "]
[null,"Please note this template is locked so headings cannot be altered and you cannot copy and paste. Lines cannot be inserted but cell text will wrap."]
[null,"You may provide additional narrative notes for particular line items if required by putting a number in the 'Note #' column, and include corresponding narrative detail in the Notes section below."]
[null,"(1) In-kind are non-cash contributions of time, services, equipment, materials etc. The in-kind Income line item must match the in-kind Expense line item.  Only enter the in-kind details in the Income section and it will auto populate in the Expense section."]
[null,"(2) Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"ORGANISATION TRADING NAME:"]
[null,null,"Note #"]
[null,null,null,null,"<enter period>","<enter period>","<enter period>",null,"Confirmed  "]
[null,"INCOME",null,"Itemise detail / description","Year 1","Year 2","Year 3","Total","(Yes/No)"]
[null,"Funding request from HMSTrust (excluding GST):",null,null,null,null,null,{"$f":"SUM(E12:G12)","v":0},"No"]
[null,"Government funding (itemise):",null,null,null,null,null,{"$f":"SUM(E13:G13)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E14:G14)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Other philanthropic sources (itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E20:G20)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"Cash contribution from own organisation (itemise):",null,null,null,null,null,0]
[null,"In-kind(1) contribution from own organisation:",null,null,null,null,null,0]
[null,"(Itemise)",null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E25:G25)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"Earned income(2) (itemise): ",null,null,null,null,null,0,null,{"$f":"IF(AND(SUM(H27:H28)>0,LEN(B80)=0),\"Please complete EARNED INCOME EXPLANATION BELOW\",\"\")","v":""}]
[null,null,null,null,null,null,null,0]
[null,"Other (specify & itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Cash contribution from project partners:",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E34:G34)","v":0}]
[null,null,null,null,null,null,null,0]
[null,"In-kind(1) contributions from project partners:",null,null,null,null,null,0]
[null,"(itemise and name project partners)",null,null,null,null,null,{"$f":"SUM(E37:G37)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E38:G38)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E39:G39)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E12:E40)","v":0},{"$f":"SUM(F12:F40)","v":0},{"$f":"SUM(G12:G40)","v":0},{"$f":"SUM(H12:H40)","v":0},{"$f":"IF(H76<>H41,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,null,null,"SUMMARY OF TOTAL INCOME:"]
[null,null,null,"Total confirmed income",null,null,null,{"$f":"SUMIF(I12:I40,\"Yes\",H12:H40)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",null,null,null,{"$f":"SUMIF(I12:I40,\"No\",H12:H40)-H46","v":0}]
[null,null,null,"HMST funding request",null,null,null,{"$f":"SUM(H12:H12)","v":0}]
[null,null,"Note #",null,null,null,null,{"$f":"SUM(H44:H46)","v":0},{"$f":"IF(H47<>H41,\"Warning: Please make sure Confirmed (Yes/No) is selected for each completed income line\",\"Check OK\")","v":"Check OK"}]
[]
[null,"EXPENSES",null,"Itemise detail / description (Provide detailed information such as hours, rates, quantities, position descriptions, contractor/evaluator name etc)\n","Year 1","Year 2","Year 3"]
[null,"Salaries (including super, payroll tax etc):",null,null,null,null,null,{"$f":"SUM(E50:G50)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(E51:G51)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Consultant fees specific to this project:",null,null,null,null,null,0]
[null,"Capital, fit-out, equipment costs (itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Administration and consumable costs:",null,null,null,null,null,0]
[null,"Travel and accommodation:",null,null,null,null,null,0]
[null,"Marketing/advertising/promotion:",null,null,null,null,null,0]
[null,"Evaluation (specify who conducts):",null,null,null,null,null,0]
[null,"Other (specify & itemise):",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"In-kind(1) contributions from own organisation:",null,{"$f":"IF(D23=\"\",\"\",D23)","v":""},{"$f":"E23","v":0},0,0,{"$f":"SUM(E67:G67)","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D24=\"\",\"\",D24)","v":""},0,0,0,{"$f":"SUM(E68:G68)","v":0}]
[null,null,null,{"$f":"IF(D25=\"\",\"\",D25)","v":""},0,0,0,{"$f":"SUM(E69:G69)","v":0}]
[null,null,null,{"$f":"IF(D26=\"\",\"\",D26)","v":""},{"$f":"E26","v":0},0,0,{"$f":"SUM(E70:G70)","v":0}]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D36=\"\",\"\",D36)","v":""},{"$f":"E36","v":0},0,0,0]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D37=\"\",\"\",D37)","v":""},0,0,0,0]
[null,null,null,{"$f":"IF(D38=\"\",\"\",D38)","v":""},0,0,0,{"$f":"SUM(E73:G73)","v":0}]
[null,null,null,{"$f":"IF(D39=\"\",\"\",D39)","v":""},0,0,0,{"$f":"SUM(E74:G74)","v":0}]
[null,null,null,{"$f":"IF(D40=\"\",\"\",D40)","v":""},{"$f":"E40","v":0},0,0,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E50:E75)","v":0},{"$f":"SUM(F50:F75)","v":0},{"$f":"SUM(G50:G75)","v":0},{"$f":"SUM(H50:H75)","v":0},{"$f":"IF(H76<>H41,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,"EARNED INCOME EXPLANATION"]
[null,"If your project relies on earned income, please provide brief details relating to rationale of revenue assumptions:"]
[]
[]
[]
[]
[null,"NOTES - for additional details on itemised income and expense items, if required. Please ensure corresponding 'Note #' is included."]