{"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":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[85,1,85,5],[8,2,9,2],[77,1,80,5],[45,2,47,2],[7,2,7,4],[82,1,82,5],[83,1,83,5],[84,1,84,5]]}
[null,"ONE-OFF 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 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,null,null,null,"Confirmed  "]
[null,"INCOME",null,"Itemise detail / description","Total","(Yes/No)"]
[null,"Funding request from HMSTrust (excluding GST):",null,null,null,"No"]
[null,"Government funding (itemise):"]
[]
[]
[]
[null,"Other philanthropic sources (itemise):"]
[]
[]
[]
[]
[null,"Cash contribution from own organisation (itemise):"]
[null,"In-kind(1) contribution from own organisation:"]
[null,"(Itemise)"]
[]
[]
[null,"Earned income(2) (itemise): ",null,null,null,null,{"$f":"IF(AND(SUM(E26:E27)>0,LEN(B78)=0),\"Please complete EARNED INCOME EXPLANATION BELOW\",\"\")","v":""}]
[]
[null,"Other (specify & itemise):"]
[]
[]
[null,"Cash contribution from project partners:"]
[]
[]
[]
[null,"In-kind(1) contributions from project partners:"]
[null,"(itemise)"]
[]
[]
[]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E11:E39)","v":0},{"$f":"IF(E75<>E40,\"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",{"$f":"SUMIF(F11:F39,\"Yes\",E11:E39)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",{"$f":"SUMIF(F11:F39,\"No\",E11:E39)-E45","v":0}]
[null,null,null,"HMST funding request",{"$f":"SUM(E11)","v":0}]
[null,null,"Note #",null,{"$f":"SUM(E43:E45)","v":0},{"$f":"IF(E46<>E40,\"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","Total"]
[null,"Salaries (including super, payroll tax etc):"]
[]
[]
[]
[null,"Consultant fees specific to this project:"]
[null,"Capital, fit-out, equipment costs (itemise):"]
[]
[]
[null,"Administration and consumable costs:"]
[null,"Travel and accommodation:"]
[null,"Marketing/advertising/promotion:"]
[null,"Evaluation:"]
[null,"Other (specify & itemise):"]
[]
[]
[]
[]
[null,"In-kind(1) contributions from own organisation:",null,{"$f":"IF(D22=\"\",\"\",D22)","v":""},{"$f":"E22","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D23=\"\",\"\",D23)","v":""},0]
[null,null,null,{"$f":"IF(D24=\"\",\"\",D24)","v":""},0]
[null,null,null,{"$f":"IF(D25=\"\",\"\",D25)","v":""},{"$f":"E25","v":0}]
[null,"In-kind(1) contributions from project parters:",null,{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"E35","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D36=\"\",\"\",D36)","v":""},0]
[null,null,null,{"$f":"IF(D37=\"\",\"\",D37)","v":""},0]
[null,null,null,{"$f":"IF(D38=\"\",\"\",D38)","v":""},0]
[null,null,null,{"$f":"IF(D39=\"\",\"\",D39)","v":""},{"$f":"E39","v":0}]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E49:E74)","v":0},{"$f":"IF(E75<>E40,\"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."]