{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","1. HMST Application Budget","2. HMST Financial Acquittal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR HMSTrust MULTI-YEAR and IMPACT BUDGETS & GRANT FINANCIAL ACQUITTAL TEMPLATES"]
[]
[null,"When you apply to HMSTrust for a grant, you are required to provide a budget for your request using this template. If your request is successful, as part of your annual progress and final reporting back to HMSTrust, you will be required to provide an annual financial acquittal using this same template. (Click on the relevant tab at the foot of your screen.)"]
[]
[null,"Please save a copy of this Excel document to enable you to attach it to your online application once completed, and for future reporting if successful. As you save it, we recommend you re-name your template with your organisation name in the title e.g. \"XY org budget\". Make sure you include your organisation name in the field at the top of the template."]
[]
[null,"1. COMPLETING YOUR APPLICATION BUDGET"]
[]
[null,"Make sure that your project budget details are accurate and realistic as you will be required to report against this budget should your application be successful."]
[]
[null,"Please note this template is locked so headings cannot be altered. Extra lines may not be inserted, however cell text will wrap."]
[]
[null,"GST: Note that grants made by HMSTrust are regarded as gifts and are not subject to GST. If you are registered for GST do not include GST in your income and expenditure figures. If you are not registered for GST you should include GST in your expenditure figures, where applicable."]
[]
[null,"Period (Yr 1/Yr2/Yr3): Please ensure you enter the dates for each project 'year' at the top of each column, e.g. the dates you expect your project to commence and conclude, and what period each year will align to. A ‘year’ does not have to align to a financial, calendar or 12 month period but needs to work for your project, and fit in with annual reporting against milestones back to the Trust and subsequent payments."]
[]
[null,"Income: Income from both HMSTrust and other sources can be spread across years and does not need to be the same amount or equally spread across each year. It should reflect the timing of project activities."]
[]
[null,"You must state whether income from other sources is confirmed (Yes) or not confirmed (No). If your budet includes income that is not confirmed (for example, an application to another funding body/foundation), you will need to update us with the results as they become available. Please note HMSTrust only pays out a grant once all funding for a project has been confirmed. If an application to another funding body is unsuccessful, or other income becomes unavailable, you must advise HMSTrust as soon as possible. You will need to submit a revised budget. If your application is successful, you will be required to report Actuals against your Budget."]
[]
[null,"Totals: The budgeted 'total income' MUST equal the budgeted 'total expenses'. The template will calculate totals as you complete the budget. You will receive a warning in red next to the totals if income and expenditure do not balance.  This will disappear once your budget balances."]
[]
[null,"You will be required to enter your project budget totals into your application form. Ensure that the totals in your application form match with the totals in your completed Project Budget Template."]
[]
[null,"Notes: 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 at the end."]
[]
[null,"DEFINITIONS"]
[]
[null,"In-kind is 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,"Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"2. COMPLETING YOUR FINANCIAL ACQUITTAL IF YOU RECEIVED A GRANT FROM HMSTrust"]
[]
[null,"All grantees are expected to report back to us with progress and final reports. When you receive notification from us that your report is due, you will be asked to update and save the Financial Acquittal sheet in this template and return as an attachment with your report. Do not amend actuals for years you have already reported on. Only amend and update the notes to reflect the year you are reporting on (you may need to overwrite notes pertaining to a previous year)."]
[]
[null,"We do not expect your actual expenditure to always be EXACTLY the same as your original budget."]
[]
[null,"Only complete the white areas. Some fields will automatically calculate and fill based on your entries. The Budget columns in the Financial Acquittal will be populated with information from the Application Budget.  In the Actual columns, please provide details on what income you actually received and what you actually spent against what you had budgetted. Include any additional income that was secured since the project commenced and provide explanation of what it was directed towards. If funding sources have changed from those in the original budget, please provide details. "]
[]
[null,"Variation between Budget and Actual: Use the right-hand column to explain any significant variation between your original project budget and the actual income or expenses. You may need to overwrite previously provided comments to reflect the year you are reporting on."]
[]
[null,"Please note this template is locked so headings cannot be altered. Extra lines may not be inserted, however cell text will wrap."]
[]
[null,"GST: Note that grants made by HMSTrust are regarded as gifts and are not subject to GST. If you are registered for GST you must not include GST in your income and expenditure figures. If you are not registered for GST you should include GST in your expenditure figures, where applicable."]
[]
[null,"Period (Yr 1/Yr2/Yr3): Please ensure you enter the dates for each project year at the top of each column. \"Year\" equals project period you are reporting on and is based on your project's start date, and is not neccesarily calendar or financial year. "]
[]
[null,"Notes: 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 at the end."]
[]
[null,"DEFINITIONS"]
[]
[null,"In-kind is 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,"Earned income is income that is expected to be generated from the project (e.g. ticket sales, fee-for-service etc.)"]
[]
[null,"CONTACT US"]
[null,"If you have any questions or issues, please call HMSTrust on 03 9999 3000 or email applications@hmstrust.org.au and we will assist you."]
[]
[null,"If your project ran for more than 3 years please contact HMSTrust for an alternate version of this form."]

{"sheet":"1. HMST Application Budget","index":1,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":false,"merged":[[2,2,2,6],[4,2,5,2],[36,2,45,2],[80,1,83,7],[86,1,92,7]]}
[null,"HMSTrust MULTI-YEAR / IMPACT GRANT PROJECT BUDGET TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:","<enter name>"]
[]
[null,null,"Note #",null,"<enter period>","<enter period>","<enter period>"]
[null,"INCOME",null,"Itemise detail / description","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total","Confirmed (Yes/No)"]
[null,"Funding from HMSTrust (excluding GST):",null,null,null,null,null,{"$f":"SUM(E7:G7)","v":0}]
[null,"Government funding (itemise):",null,null,null,null,null,{"$f":"SUM(E8:G8)","v":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,"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,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 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,0]
[null,null,null,null,null,null,null,0]
[null,"Earned income (itemise & explain in box below): ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Other income (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,0]
[null,null,null,null,null,null,null,0]
[null,"In-kind contributions from project partners:",null,null,null,null,null,0]
[null,"(itemise and name project partners)",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,"TOTAL INCOME",{"$f":"SUM(E7:E35)","v":0},{"$f":"SUM(F7:F35)","v":0},{"$f":"SUM(G7:G35)","v":0},{"$f":"SUM(H7:H35)","v":0}]
[null,null,"Note #",null,null,null,null,{"$f":"IF(H76<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,null,null,"SUMMARY OF TOTAL INCOME (automatically populated):"]
[null,null,null,"Total confirmed income",null,null,null,{"$f":"SUMIF(I7:I35,\"Yes\",H7:H35)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",null,null,null,{"$f":"SUMIF(I8:I35,\"No\",H8:H35)","v":0}]
[null,null,null,"HMST funding request",null,null,null,{"$f":"SUM(H7)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H40:H42)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H43<>H36,\"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","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total"]
[null,"Salaries (including super, payroll tax etc):",null,null,null,null,null,{"$f":"SUM(E47:G47)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(E49:G49)","v":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 expenses (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,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 contributions from own organisation:",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},{"$f":"E18","v":0},0,0,{"$f":"SUM(E67:G67)","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},0,0,0,{"$f":"SUM(E68:G68)","v":0}]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},0,0,0,{"$f":"SUM(E69:G69)","v":0}]
[null,null,null,{"$f":"IF(D21=\"\",\"\",D21)","v":""},{"$f":"E21","v":0},0,0,{"$f":"SUM(E70:G70)","v":0}]
[null,"In-kind contributions from project parters:",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"E31","v":0},0,0,0]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},0,0,0,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},0,0,0,{"$f":"SUM(E73:G73)","v":0}]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},0,0,0,{"$f":"SUM(E74:G74)","v":0}]
[null,null,null,{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"E35","v":0},0,0,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E47:E75)","v":0},0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(H76<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,"BUDGETED EARNED INCOME EXPLANATION"]
[null,"If your project relies on earned income, please provide brief details relating to rationale of revenue assumptions:"]
[]
[]
[]
[]
[]
[null,"BUDGET NOTES - for additional general notes, or further details on specific income and expense items if required. Please ensure corresponding 'Note #' is included."]

{"sheet":"2. HMST Financial Acquittal","index":2,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[[80,9,92,13],[4,2,5,2],[36,2,45,2],[2,2,2,6],[80,1,83,7],[86,1,92,7]]}
[null,"HMSTrust MULTI-YEAR / IMPACT GRANT PROJECT FINANCIAL ACQUITTAL TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:",{"$f":"'1. HMST Application Budget'!C3:G3","v":"<enter name>"}]
[]
[null,null,"Note #",null,{"$f":"'1. HMST Application Budget'!E5","v":"<enter period>"},{"$f":"'1. HMST Application Budget'!F5","v":"<enter period>"},{"$f":"'1. HMST Application Budget'!G5","v":"<enter period>"},null,null,"<enter period>","<enter period>","<enter period>"]
[null,"INCOME",null,"Itemise detail / description","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total","Confirmed (Yes/No)","Actual\nYear 1","Actual\nYear 2","Actual\nYear 3","Actual Total","Explanation of variance between actual and budget (update to reflect the year you are reporting on)."]
[null,"Funding from HMSTrust (excluding GST):",{"$f":"IF('1. HMST Application Budget'!C7=\"\",\"\",'1. HMST Application Budget'!C7)","v":""},{"$f":"IF('1. HMST Application Budget'!D7=\"\",\"\",'1. HMST Application Budget'!D7)","v":""},{"$f":"IF('1. HMST Application Budget'!E7=\"\",\"\",'1. HMST Application Budget'!E7)","v":""},{"$f":"IF('1. HMST Application Budget'!F7=\"\",\"\",'1. HMST Application Budget'!F7)","v":""},{"$f":"IF('1. HMST Application Budget'!G7=\"\",\"\",'1. HMST Application Budget'!G7)","v":""},{"$f":"SUM(E7:G7)","v":0},null,null,null,null,{"$f":"SUM(J7:L7)","v":0}]
[null,"Government funding (itemise):",{"$f":"IF('1. HMST Application Budget'!C8=\"\",\"\",'1. HMST Application Budget'!C8)","v":""},{"$f":"IF('1. HMST Application Budget'!D8=\"\",\"\",'1. HMST Application Budget'!D8)","v":""},{"$f":"IF('1. HMST Application Budget'!E8=\"\",\"\",'1. HMST Application Budget'!E8)","v":""},{"$f":"IF('1. HMST Application Budget'!F8=\"\",\"\",'1. HMST Application Budget'!F8)","v":""},{"$f":"IF('1. HMST Application Budget'!G8=\"\",\"\",'1. HMST Application Budget'!G8)","v":""},{"$f":"SUM(E8:G8)","v":0},{"$f":"IF('1. HMST Application Budget'!I8=\"\",\"\",'1. HMST Application Budget'!I8)","v":""},null,null,null,{"$f":"SUM(J8:L8)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C9=\"\",\"\",'1. HMST Application Budget'!C9)","v":""},{"$f":"IF('1. HMST Application Budget'!D9=\"\",\"\",'1. HMST Application Budget'!D9)","v":""},{"$f":"IF('1. HMST Application Budget'!E9=\"\",\"\",'1. HMST Application Budget'!E9)","v":""},{"$f":"IF('1. HMST Application Budget'!F9=\"\",\"\",'1. HMST Application Budget'!F9)","v":""},{"$f":"IF('1. HMST Application Budget'!G9=\"\",\"\",'1. HMST Application Budget'!G9)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I9=\"\",\"\",'1. HMST Application Budget'!I9)","v":""},null,null,null,{"$f":"SUM(J9:L9)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C10=\"\",\"\",'1. HMST Application Budget'!C10)","v":""},{"$f":"IF('1. HMST Application Budget'!D10=\"\",\"\",'1. HMST Application Budget'!D10)","v":""},{"$f":"IF('1. HMST Application Budget'!E10=\"\",\"\",'1. HMST Application Budget'!E10)","v":""},{"$f":"IF('1. HMST Application Budget'!F10=\"\",\"\",'1. HMST Application Budget'!F10)","v":""},{"$f":"IF('1. HMST Application Budget'!G10=\"\",\"\",'1. HMST Application Budget'!G10)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I10=\"\",\"\",'1. HMST Application Budget'!I10)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C11=\"\",\"\",'1. HMST Application Budget'!C11)","v":""},{"$f":"IF('1. HMST Application Budget'!D11=\"\",\"\",'1. HMST Application Budget'!D11)","v":""},{"$f":"IF('1. HMST Application Budget'!E11=\"\",\"\",'1. HMST Application Budget'!E11)","v":""},{"$f":"IF('1. HMST Application Budget'!F11=\"\",\"\",'1. HMST Application Budget'!F11)","v":""},{"$f":"IF('1. HMST Application Budget'!G11=\"\",\"\",'1. HMST Application Budget'!G11)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I11=\"\",\"\",'1. HMST Application Budget'!I11)","v":""},null,null,null,0]
[null,"Other philanthropic sources (itemise):",{"$f":"IF('1. HMST Application Budget'!C12=\"\",\"\",'1. HMST Application Budget'!C12)","v":""},{"$f":"IF('1. HMST Application Budget'!D12=\"\",\"\",'1. HMST Application Budget'!D12)","v":""},{"$f":"IF('1. HMST Application Budget'!E12=\"\",\"\",'1. HMST Application Budget'!E12)","v":""},{"$f":"IF('1. HMST Application Budget'!F12=\"\",\"\",'1. HMST Application Budget'!F12)","v":""},{"$f":"IF('1. HMST Application Budget'!G12=\"\",\"\",'1. HMST Application Budget'!G12)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I12=\"\",\"\",'1. HMST Application Budget'!I12)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C13=\"\",\"\",'1. HMST Application Budget'!C13)","v":""},{"$f":"IF('1. HMST Application Budget'!D13=\"\",\"\",'1. HMST Application Budget'!D13)","v":""},{"$f":"IF('1. HMST Application Budget'!E13=\"\",\"\",'1. HMST Application Budget'!E13)","v":""},{"$f":"IF('1. HMST Application Budget'!F13=\"\",\"\",'1. HMST Application Budget'!F13)","v":""},{"$f":"IF('1. HMST Application Budget'!G13=\"\",\"\",'1. HMST Application Budget'!G13)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I13=\"\",\"\",'1. HMST Application Budget'!I13)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C14=\"\",\"\",'1. HMST Application Budget'!C14)","v":""},{"$f":"IF('1. HMST Application Budget'!D14=\"\",\"\",'1. HMST Application Budget'!D14)","v":""},{"$f":"IF('1. HMST Application Budget'!E14=\"\",\"\",'1. HMST Application Budget'!E14)","v":""},{"$f":"IF('1. HMST Application Budget'!F14=\"\",\"\",'1. HMST Application Budget'!F14)","v":""},{"$f":"IF('1. HMST Application Budget'!G14=\"\",\"\",'1. HMST Application Budget'!G14)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I14=\"\",\"\",'1. HMST Application Budget'!I14)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C15=\"\",\"\",'1. HMST Application Budget'!C15)","v":""},{"$f":"IF('1. HMST Application Budget'!D15=\"\",\"\",'1. HMST Application Budget'!D15)","v":""},{"$f":"IF('1. HMST Application Budget'!E15=\"\",\"\",'1. HMST Application Budget'!E15)","v":""},{"$f":"IF('1. HMST Application Budget'!F15=\"\",\"\",'1. HMST Application Budget'!F15)","v":""},{"$f":"IF('1. HMST Application Budget'!G15=\"\",\"\",'1. HMST Application Budget'!G15)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I15=\"\",\"\",'1. HMST Application Budget'!I15)","v":""},null,null,null,{"$f":"SUM(J15:L15)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C16=\"\",\"\",'1. HMST Application Budget'!C16)","v":""},{"$f":"IF('1. HMST Application Budget'!D16=\"\",\"\",'1. HMST Application Budget'!D16)","v":""},{"$f":"IF('1. HMST Application Budget'!E16=\"\",\"\",'1. HMST Application Budget'!E16)","v":""},{"$f":"IF('1. HMST Application Budget'!F16=\"\",\"\",'1. HMST Application Budget'!F16)","v":""},{"$f":"IF('1. HMST Application Budget'!G16=\"\",\"\",'1. HMST Application Budget'!G16)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I16=\"\",\"\",'1. HMST Application Budget'!I16)","v":""},null,null,null,0]
[null,"Cash contribution from own organisation (itemise):",{"$f":"IF('1. HMST Application Budget'!C17=\"\",\"\",'1. HMST Application Budget'!C17)","v":""},{"$f":"IF('1. HMST Application Budget'!D17=\"\",\"\",'1. HMST Application Budget'!D17)","v":""},{"$f":"IF('1. HMST Application Budget'!E17=\"\",\"\",'1. HMST Application Budget'!E17)","v":""},{"$f":"IF('1. HMST Application Budget'!F17=\"\",\"\",'1. HMST Application Budget'!F17)","v":""},{"$f":"IF('1. HMST Application Budget'!G17=\"\",\"\",'1. HMST Application Budget'!G17)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I17=\"\",\"\",'1. HMST Application Budget'!I17)","v":""},null,null,null,0]
[null,"In-kind contribution from own organisation:",{"$f":"IF('1. HMST Application Budget'!C18=\"\",\"\",'1. HMST Application Budget'!C18)","v":""},{"$f":"IF('1. HMST Application Budget'!D18=\"\",\"\",'1. HMST Application Budget'!D18)","v":""},{"$f":"IF('1. HMST Application Budget'!E18=\"\",\"\",'1. HMST Application Budget'!E18)","v":""},{"$f":"IF('1. HMST Application Budget'!F18=\"\",\"\",'1. HMST Application Budget'!F18)","v":""},{"$f":"IF('1. HMST Application Budget'!G18=\"\",\"\",'1. HMST Application Budget'!G18)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I18=\"\",\"\",'1. HMST Application Budget'!I18)","v":""},null,null,null,0]
[null,"(itemise)",{"$f":"IF('1. HMST Application Budget'!C19=\"\",\"\",'1. HMST Application Budget'!C19)","v":""},{"$f":"IF('1. HMST Application Budget'!D19=\"\",\"\",'1. HMST Application Budget'!D19)","v":""},{"$f":"IF('1. HMST Application Budget'!E19=\"\",\"\",'1. HMST Application Budget'!E19)","v":""},{"$f":"IF('1. HMST Application Budget'!F19=\"\",\"\",'1. HMST Application Budget'!F19)","v":""},{"$f":"IF('1. HMST Application Budget'!G19=\"\",\"\",'1. HMST Application Budget'!G19)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I19=\"\",\"\",'1. HMST Application Budget'!I19)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C20=\"\",\"\",'1. HMST Application Budget'!C20)","v":""},{"$f":"IF('1. HMST Application Budget'!D20=\"\",\"\",'1. HMST Application Budget'!D20)","v":""},{"$f":"IF('1. HMST Application Budget'!E20=\"\",\"\",'1. HMST Application Budget'!E20)","v":""},{"$f":"IF('1. HMST Application Budget'!F20=\"\",\"\",'1. HMST Application Budget'!F20)","v":""},{"$f":"IF('1. HMST Application Budget'!G20=\"\",\"\",'1. HMST Application Budget'!G20)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I20=\"\",\"\",'1. HMST Application Budget'!I20)","v":""},null,null,null,{"$f":"SUM(J20:L20)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C21=\"\",\"\",'1. HMST Application Budget'!C21)","v":""},{"$f":"IF('1. HMST Application Budget'!D21=\"\",\"\",'1. HMST Application Budget'!D21)","v":""},{"$f":"IF('1. HMST Application Budget'!E21=\"\",\"\",'1. HMST Application Budget'!E21)","v":""},{"$f":"IF('1. HMST Application Budget'!F21=\"\",\"\",'1. HMST Application Budget'!F21)","v":""},{"$f":"IF('1. HMST Application Budget'!G21=\"\",\"\",'1. HMST Application Budget'!G21)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I21=\"\",\"\",'1. HMST Application Budget'!I21)","v":""},null,null,null,0]
[null,"Earned income (itemise & explain in box below): ",{"$f":"IF('1. HMST Application Budget'!C22=\"\",\"\",'1. HMST Application Budget'!C22)","v":""},{"$f":"IF('1. HMST Application Budget'!D22=\"\",\"\",'1. HMST Application Budget'!D22)","v":""},{"$f":"IF('1. HMST Application Budget'!E22=\"\",\"\",'1. HMST Application Budget'!E22)","v":""},{"$f":"IF('1. HMST Application Budget'!F22=\"\",\"\",'1. HMST Application Budget'!F22)","v":""},{"$f":"IF('1. HMST Application Budget'!G22=\"\",\"\",'1. HMST Application Budget'!G22)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I22=\"\",\"\",'1. HMST Application Budget'!I22)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C23=\"\",\"\",'1. HMST Application Budget'!C23)","v":""},{"$f":"IF('1. HMST Application Budget'!D23=\"\",\"\",'1. HMST Application Budget'!D23)","v":""},{"$f":"IF('1. HMST Application Budget'!E23=\"\",\"\",'1. HMST Application Budget'!E23)","v":""},{"$f":"IF('1. HMST Application Budget'!F23=\"\",\"\",'1. HMST Application Budget'!F23)","v":""},{"$f":"IF('1. HMST Application Budget'!G23=\"\",\"\",'1. HMST Application Budget'!G23)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I23=\"\",\"\",'1. HMST Application Budget'!I23)","v":""},null,null,null,0]
[null,"Other income (specify & itemise):",{"$f":"IF('1. HMST Application Budget'!C24=\"\",\"\",'1. HMST Application Budget'!C24)","v":""},{"$f":"IF('1. HMST Application Budget'!D24=\"\",\"\",'1. HMST Application Budget'!D24)","v":""},{"$f":"IF('1. HMST Application Budget'!E24=\"\",\"\",'1. HMST Application Budget'!E24)","v":""},{"$f":"IF('1. HMST Application Budget'!F24=\"\",\"\",'1. HMST Application Budget'!F24)","v":""},{"$f":"IF('1. HMST Application Budget'!G24=\"\",\"\",'1. HMST Application Budget'!G24)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I24=\"\",\"\",'1. HMST Application Budget'!I24)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C25=\"\",\"\",'1. HMST Application Budget'!C25)","v":""},{"$f":"IF('1. HMST Application Budget'!D25=\"\",\"\",'1. HMST Application Budget'!D25)","v":""},{"$f":"IF('1. HMST Application Budget'!E25=\"\",\"\",'1. HMST Application Budget'!E25)","v":""},{"$f":"IF('1. HMST Application Budget'!F25=\"\",\"\",'1. HMST Application Budget'!F25)","v":""},{"$f":"IF('1. HMST Application Budget'!G25=\"\",\"\",'1. HMST Application Budget'!G25)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I25=\"\",\"\",'1. HMST Application Budget'!I25)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C26=\"\",\"\",'1. HMST Application Budget'!C26)","v":""},{"$f":"IF('1. HMST Application Budget'!D26=\"\",\"\",'1. HMST Application Budget'!D26)","v":""},{"$f":"IF('1. HMST Application Budget'!E26=\"\",\"\",'1. HMST Application Budget'!E26)","v":""},{"$f":"IF('1. HMST Application Budget'!F26=\"\",\"\",'1. HMST Application Budget'!F26)","v":""},{"$f":"IF('1. HMST Application Budget'!G26=\"\",\"\",'1. HMST Application Budget'!G26)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I26=\"\",\"\",'1. HMST Application Budget'!I26)","v":""},null,null,null,0]
[null,"Cash contribution from project partners:",{"$f":"IF('1. HMST Application Budget'!C27=\"\",\"\",'1. HMST Application Budget'!C27)","v":""},{"$f":"IF('1. HMST Application Budget'!D27=\"\",\"\",'1. HMST Application Budget'!D27)","v":""},{"$f":"IF('1. HMST Application Budget'!E27=\"\",\"\",'1. HMST Application Budget'!E27)","v":""},{"$f":"IF('1. HMST Application Budget'!F27=\"\",\"\",'1. HMST Application Budget'!F27)","v":""},{"$f":"IF('1. HMST Application Budget'!G27=\"\",\"\",'1. HMST Application Budget'!G27)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I27=\"\",\"\",'1. HMST Application Budget'!I27)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C28=\"\",\"\",'1. HMST Application Budget'!C28)","v":""},{"$f":"IF('1. HMST Application Budget'!D28=\"\",\"\",'1. HMST Application Budget'!D28)","v":""},{"$f":"IF('1. HMST Application Budget'!E28=\"\",\"\",'1. HMST Application Budget'!E28)","v":""},{"$f":"IF('1. HMST Application Budget'!F28=\"\",\"\",'1. HMST Application Budget'!F28)","v":""},{"$f":"IF('1. HMST Application Budget'!G28=\"\",\"\",'1. HMST Application Budget'!G28)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I28=\"\",\"\",'1. HMST Application Budget'!I28)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C29=\"\",\"\",'1. HMST Application Budget'!C29)","v":""},{"$f":"IF('1. HMST Application Budget'!D29=\"\",\"\",'1. HMST Application Budget'!D29)","v":""},{"$f":"IF('1. HMST Application Budget'!E29=\"\",\"\",'1. HMST Application Budget'!E29)","v":""},{"$f":"IF('1. HMST Application Budget'!F29=\"\",\"\",'1. HMST Application Budget'!F29)","v":""},{"$f":"IF('1. HMST Application Budget'!G29=\"\",\"\",'1. HMST Application Budget'!G29)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I29=\"\",\"\",'1. HMST Application Budget'!I29)","v":""},null,null,null,{"$f":"SUM(J29:L29)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C30=\"\",\"\",'1. HMST Application Budget'!C30)","v":""},{"$f":"IF('1. HMST Application Budget'!D30=\"\",\"\",'1. HMST Application Budget'!D30)","v":""},{"$f":"IF('1. HMST Application Budget'!E30=\"\",\"\",'1. HMST Application Budget'!E30)","v":""},{"$f":"IF('1. HMST Application Budget'!F30=\"\",\"\",'1. HMST Application Budget'!F30)","v":""},{"$f":"IF('1. HMST Application Budget'!G30=\"\",\"\",'1. HMST Application Budget'!G30)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I30=\"\",\"\",'1. HMST Application Budget'!I30)","v":""},null,null,null,0]
[null,"In-kind contributions from project partners:",{"$f":"IF('1. HMST Application Budget'!C31=\"\",\"\",'1. HMST Application Budget'!C31)","v":""},{"$f":"IF('1. HMST Application Budget'!D31=\"\",\"\",'1. HMST Application Budget'!D31)","v":""},{"$f":"IF('1. HMST Application Budget'!E31=\"\",\"\",'1. HMST Application Budget'!E31)","v":""},{"$f":"IF('1. HMST Application Budget'!F31=\"\",\"\",'1. HMST Application Budget'!F31)","v":""},{"$f":"IF('1. HMST Application Budget'!G31=\"\",\"\",'1. HMST Application Budget'!G31)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I31=\"\",\"\",'1. HMST Application Budget'!I31)","v":""},null,null,null,0]
[null,"(itemise and name project partners)",{"$f":"IF('1. HMST Application Budget'!C32=\"\",\"\",'1. HMST Application Budget'!C32)","v":""},{"$f":"IF('1. HMST Application Budget'!D32=\"\",\"\",'1. HMST Application Budget'!D32)","v":""},{"$f":"IF('1. HMST Application Budget'!E32=\"\",\"\",'1. HMST Application Budget'!E32)","v":""},{"$f":"IF('1. HMST Application Budget'!F32=\"\",\"\",'1. HMST Application Budget'!F32)","v":""},{"$f":"IF('1. HMST Application Budget'!G32=\"\",\"\",'1. HMST Application Budget'!G32)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I32=\"\",\"\",'1. HMST Application Budget'!I32)","v":""},null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C33=\"\",\"\",'1. HMST Application Budget'!C33)","v":""},{"$f":"IF('1. HMST Application Budget'!D33=\"\",\"\",'1. HMST Application Budget'!D33)","v":""},{"$f":"IF('1. HMST Application Budget'!E33=\"\",\"\",'1. HMST Application Budget'!E33)","v":""},{"$f":"IF('1. HMST Application Budget'!F33=\"\",\"\",'1. HMST Application Budget'!F33)","v":""},{"$f":"IF('1. HMST Application Budget'!G33=\"\",\"\",'1. HMST Application Budget'!G33)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I33=\"\",\"\",'1. HMST Application Budget'!I33)","v":""},null,null,null,{"$f":"SUM(J33:L33)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C34=\"\",\"\",'1. HMST Application Budget'!C34)","v":""},{"$f":"IF('1. HMST Application Budget'!D34=\"\",\"\",'1. HMST Application Budget'!D34)","v":""},{"$f":"IF('1. HMST Application Budget'!E34=\"\",\"\",'1. HMST Application Budget'!E34)","v":""},{"$f":"IF('1. HMST Application Budget'!F34=\"\",\"\",'1. HMST Application Budget'!F34)","v":""},{"$f":"IF('1. HMST Application Budget'!G34=\"\",\"\",'1. HMST Application Budget'!G34)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I34=\"\",\"\",'1. HMST Application Budget'!I34)","v":""},null,null,null,{"$f":"SUM(J34:L34)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C35=\"\",\"\",'1. HMST Application Budget'!C35)","v":""},{"$f":"IF('1. HMST Application Budget'!D35=\"\",\"\",'1. HMST Application Budget'!D35)","v":""},{"$f":"IF('1. HMST Application Budget'!E35=\"\",\"\",'1. HMST Application Budget'!E35)","v":""},{"$f":"IF('1. HMST Application Budget'!F35=\"\",\"\",'1. HMST Application Budget'!F35)","v":""},{"$f":"IF('1. HMST Application Budget'!G35=\"\",\"\",'1. HMST Application Budget'!G35)","v":""},0,{"$f":"IF('1. HMST Application Budget'!I35=\"\",\"\",'1. HMST Application Budget'!I35)","v":""},null,null,null,0]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E7:E35)","v":0},{"$f":"SUM(F7:F35)","v":0},{"$f":"SUM(G7:G35)","v":0},{"$f":"SUM(H7:H35)","v":0},null,{"$f":"SUM(J7:J35)","v":0},{"$f":"SUM(K7:K35)","v":0},{"$f":"SUM(L7:L35)","v":0},{"$f":"SUM(M7:M35)","v":0}]
[null,null,"Note #",null,null,null,null,{"$f":"IF(H76<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,null,null,"SUMMARY OF TOTAL INCOME (automatically populated):"]
[null,null,null,"Total confirmed income",null,null,null,{"$f":"SUMIF(I7:I35,\"Yes\",H7:H35)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",null,null,null,{"$f":"SUMIF(I8:I35,\"No\",H8:H35)","v":0}]
[null,null,null,"HMST funding request",null,null,null,{"$f":"SUM(H7)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H40:H42)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(H43<>H36,\"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","Budget \nYear 1","Budget \nYear 2","Budget \nYear 3","Budget Total",null,"Actual\nYear 1","Actual\nYear 2","Actual\nYear 3","Actual \nTotal","Explanation of variance between actual and budget"]
[null,"Salaries (including super, payroll tax etc):",{"$f":"IF('1. HMST Application Budget'!C47=\"\",\"\",'1. HMST Application Budget'!C47)","v":""},{"$f":"IF('1. HMST Application Budget'!D47=\"\",\"\",'1. HMST Application Budget'!D47)","v":""},{"$f":"IF('1. HMST Application Budget'!E47=\"\",\"\",'1. HMST Application Budget'!E47)","v":""},{"$f":"IF('1. HMST Application Budget'!F47=\"\",\"\",'1. HMST Application Budget'!F47)","v":""},{"$f":"IF('1. HMST Application Budget'!G47=\"\",\"\",'1. HMST Application Budget'!G47)","v":""},{"$f":"SUM(E47:G47)","v":0},null,null,null,null,{"$f":"SUM(J47:L47)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C48=\"\",\"\",'1. HMST Application Budget'!C48)","v":""},{"$f":"IF('1. HMST Application Budget'!D48=\"\",\"\",'1. HMST Application Budget'!D48)","v":""},{"$f":"IF('1. HMST Application Budget'!E48=\"\",\"\",'1. HMST Application Budget'!E48)","v":""},{"$f":"IF('1. HMST Application Budget'!F48=\"\",\"\",'1. HMST Application Budget'!F48)","v":""},{"$f":"IF('1. HMST Application Budget'!G48=\"\",\"\",'1. HMST Application Budget'!G48)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C49=\"\",\"\",'1. HMST Application Budget'!C49)","v":""},{"$f":"IF('1. HMST Application Budget'!D49=\"\",\"\",'1. HMST Application Budget'!D49)","v":""},{"$f":"IF('1. HMST Application Budget'!E49=\"\",\"\",'1. HMST Application Budget'!E49)","v":""},{"$f":"IF('1. HMST Application Budget'!F49=\"\",\"\",'1. HMST Application Budget'!F49)","v":""},{"$f":"IF('1. HMST Application Budget'!G49=\"\",\"\",'1. HMST Application Budget'!G49)","v":""},{"$f":"SUM(E49:G49)","v":0},null,null,null,null,{"$f":"SUM(J49:L49)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C50=\"\",\"\",'1. HMST Application Budget'!C50)","v":""},{"$f":"IF('1. HMST Application Budget'!D50=\"\",\"\",'1. HMST Application Budget'!D50)","v":""},{"$f":"IF('1. HMST Application Budget'!E50=\"\",\"\",'1. HMST Application Budget'!E50)","v":""},{"$f":"IF('1. HMST Application Budget'!F50=\"\",\"\",'1. HMST Application Budget'!F50)","v":""},{"$f":"IF('1. HMST Application Budget'!G50=\"\",\"\",'1. HMST Application Budget'!G50)","v":""},0,null,null,null,null,0]
[null,"Consultant fees specific to this project:",{"$f":"IF('1. HMST Application Budget'!C51=\"\",\"\",'1. HMST Application Budget'!C51)","v":""},{"$f":"IF('1. HMST Application Budget'!D51=\"\",\"\",'1. HMST Application Budget'!D51)","v":""},{"$f":"IF('1. HMST Application Budget'!E51=\"\",\"\",'1. HMST Application Budget'!E51)","v":""},{"$f":"IF('1. HMST Application Budget'!F51=\"\",\"\",'1. HMST Application Budget'!F51)","v":""},{"$f":"IF('1. HMST Application Budget'!G51=\"\",\"\",'1. HMST Application Budget'!G51)","v":""},0,null,null,null,null,0]
[null,"Capital, fit-out, equipment costs (itemise):",{"$f":"IF('1. HMST Application Budget'!C52=\"\",\"\",'1. HMST Application Budget'!C52)","v":""},{"$f":"IF('1. HMST Application Budget'!D52=\"\",\"\",'1. HMST Application Budget'!D52)","v":""},{"$f":"IF('1. HMST Application Budget'!E52=\"\",\"\",'1. HMST Application Budget'!E52)","v":""},{"$f":"IF('1. HMST Application Budget'!F52=\"\",\"\",'1. HMST Application Budget'!F52)","v":""},{"$f":"IF('1. HMST Application Budget'!G52=\"\",\"\",'1. HMST Application Budget'!G52)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C53=\"\",\"\",'1. HMST Application Budget'!C53)","v":""},{"$f":"IF('1. HMST Application Budget'!D53=\"\",\"\",'1. HMST Application Budget'!D53)","v":""},{"$f":"IF('1. HMST Application Budget'!E53=\"\",\"\",'1. HMST Application Budget'!E53)","v":""},{"$f":"IF('1. HMST Application Budget'!F53=\"\",\"\",'1. HMST Application Budget'!F53)","v":""},{"$f":"IF('1. HMST Application Budget'!G53=\"\",\"\",'1. HMST Application Budget'!G53)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C54=\"\",\"\",'1. HMST Application Budget'!C54)","v":""},{"$f":"IF('1. HMST Application Budget'!D54=\"\",\"\",'1. HMST Application Budget'!D54)","v":""},{"$f":"IF('1. HMST Application Budget'!E54=\"\",\"\",'1. HMST Application Budget'!E54)","v":""},{"$f":"IF('1. HMST Application Budget'!F54=\"\",\"\",'1. HMST Application Budget'!F54)","v":""},{"$f":"IF('1. HMST Application Budget'!G54=\"\",\"\",'1. HMST Application Budget'!G54)","v":""},0,null,null,null,null,0]
[null,"Administration and consumable costs:",{"$f":"IF('1. HMST Application Budget'!C55=\"\",\"\",'1. HMST Application Budget'!C55)","v":""},{"$f":"IF('1. HMST Application Budget'!D55=\"\",\"\",'1. HMST Application Budget'!D55)","v":""},{"$f":"IF('1. HMST Application Budget'!E55=\"\",\"\",'1. HMST Application Budget'!E55)","v":""},{"$f":"IF('1. HMST Application Budget'!F55=\"\",\"\",'1. HMST Application Budget'!F55)","v":""},{"$f":"IF('1. HMST Application Budget'!G55=\"\",\"\",'1. HMST Application Budget'!G55)","v":""},0,null,null,null,null,0]
[null,"Travel and accommodation:",{"$f":"IF('1. HMST Application Budget'!C56=\"\",\"\",'1. HMST Application Budget'!C56)","v":""},{"$f":"IF('1. HMST Application Budget'!D56=\"\",\"\",'1. HMST Application Budget'!D56)","v":""},{"$f":"IF('1. HMST Application Budget'!E56=\"\",\"\",'1. HMST Application Budget'!E56)","v":""},{"$f":"IF('1. HMST Application Budget'!F56=\"\",\"\",'1. HMST Application Budget'!F56)","v":""},{"$f":"IF('1. HMST Application Budget'!G56=\"\",\"\",'1. HMST Application Budget'!G56)","v":""},0,null,null,null,null,0]
[null,"Marketing/advertising/promotion:",{"$f":"IF('1. HMST Application Budget'!C57=\"\",\"\",'1. HMST Application Budget'!C57)","v":""},{"$f":"IF('1. HMST Application Budget'!D57=\"\",\"\",'1. HMST Application Budget'!D57)","v":""},{"$f":"IF('1. HMST Application Budget'!E57=\"\",\"\",'1. HMST Application Budget'!E57)","v":""},{"$f":"IF('1. HMST Application Budget'!F57=\"\",\"\",'1. HMST Application Budget'!F57)","v":""},{"$f":"IF('1. HMST Application Budget'!G57=\"\",\"\",'1. HMST Application Budget'!G57)","v":""},0,null,null,null,null,0]
[null,"Evaluation (specify who conducts):",{"$f":"IF('1. HMST Application Budget'!C58=\"\",\"\",'1. HMST Application Budget'!C58)","v":""},{"$f":"IF('1. HMST Application Budget'!D58=\"\",\"\",'1. HMST Application Budget'!D58)","v":""},{"$f":"IF('1. HMST Application Budget'!E58=\"\",\"\",'1. HMST Application Budget'!E58)","v":""},{"$f":"IF('1. HMST Application Budget'!F58=\"\",\"\",'1. HMST Application Budget'!F58)","v":""},{"$f":"IF('1. HMST Application Budget'!G58=\"\",\"\",'1. HMST Application Budget'!G58)","v":""},0,null,null,null,null,{"$f":"SUM(J58:L58)","v":0}]
[null,"Other expenses (specify & itemise):",{"$f":"IF('1. HMST Application Budget'!C59=\"\",\"\",'1. HMST Application Budget'!C59)","v":""},{"$f":"IF('1. HMST Application Budget'!D59=\"\",\"\",'1. HMST Application Budget'!D59)","v":""},{"$f":"IF('1. HMST Application Budget'!E59=\"\",\"\",'1. HMST Application Budget'!E59)","v":""},{"$f":"IF('1. HMST Application Budget'!F59=\"\",\"\",'1. HMST Application Budget'!F59)","v":""},{"$f":"IF('1. HMST Application Budget'!G59=\"\",\"\",'1. HMST Application Budget'!G59)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C60=\"\",\"\",'1. HMST Application Budget'!C60)","v":""},{"$f":"IF('1. HMST Application Budget'!D60=\"\",\"\",'1. HMST Application Budget'!D60)","v":""},{"$f":"IF('1. HMST Application Budget'!E60=\"\",\"\",'1. HMST Application Budget'!E60)","v":""},{"$f":"IF('1. HMST Application Budget'!F60=\"\",\"\",'1. HMST Application Budget'!F60)","v":""},{"$f":"IF('1. HMST Application Budget'!G60=\"\",\"\",'1. HMST Application Budget'!G60)","v":""},{"$f":"SUM(E60:G60)","v":0},null,null,null,null,{"$f":"SUM(J60:L60)","v":0}]
[null,null,{"$f":"IF('1. HMST Application Budget'!C61=\"\",\"\",'1. HMST Application Budget'!C61)","v":""},{"$f":"IF('1. HMST Application Budget'!D61=\"\",\"\",'1. HMST Application Budget'!D61)","v":""},{"$f":"IF('1. HMST Application Budget'!E61=\"\",\"\",'1. HMST Application Budget'!E61)","v":""},{"$f":"IF('1. HMST Application Budget'!F61=\"\",\"\",'1. HMST Application Budget'!F61)","v":""},{"$f":"IF('1. HMST Application Budget'!G61=\"\",\"\",'1. HMST Application Budget'!G61)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C62=\"\",\"\",'1. HMST Application Budget'!C62)","v":""},{"$f":"IF('1. HMST Application Budget'!D62=\"\",\"\",'1. HMST Application Budget'!D62)","v":""},{"$f":"IF('1. HMST Application Budget'!E62=\"\",\"\",'1. HMST Application Budget'!E62)","v":""},{"$f":"IF('1. HMST Application Budget'!F62=\"\",\"\",'1. HMST Application Budget'!F62)","v":""},{"$f":"IF('1. HMST Application Budget'!G62=\"\",\"\",'1. HMST Application Budget'!G62)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C63=\"\",\"\",'1. HMST Application Budget'!C63)","v":""},{"$f":"IF('1. HMST Application Budget'!D63=\"\",\"\",'1. HMST Application Budget'!D63)","v":""},{"$f":"IF('1. HMST Application Budget'!E63=\"\",\"\",'1. HMST Application Budget'!E63)","v":""},{"$f":"IF('1. HMST Application Budget'!F63=\"\",\"\",'1. HMST Application Budget'!F63)","v":""},{"$f":"IF('1. HMST Application Budget'!G63=\"\",\"\",'1. HMST Application Budget'!G63)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C64=\"\",\"\",'1. HMST Application Budget'!C64)","v":""},{"$f":"IF('1. HMST Application Budget'!D64=\"\",\"\",'1. HMST Application Budget'!D64)","v":""},{"$f":"IF('1. HMST Application Budget'!E64=\"\",\"\",'1. HMST Application Budget'!E64)","v":""},{"$f":"IF('1. HMST Application Budget'!F64=\"\",\"\",'1. HMST Application Budget'!F64)","v":""},{"$f":"IF('1. HMST Application Budget'!G64=\"\",\"\",'1. HMST Application Budget'!G64)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C65=\"\",\"\",'1. HMST Application Budget'!C65)","v":""},{"$f":"IF('1. HMST Application Budget'!D65=\"\",\"\",'1. HMST Application Budget'!D65)","v":""},{"$f":"IF('1. HMST Application Budget'!E65=\"\",\"\",'1. HMST Application Budget'!E65)","v":""},{"$f":"IF('1. HMST Application Budget'!F65=\"\",\"\",'1. HMST Application Budget'!F65)","v":""},{"$f":"IF('1. HMST Application Budget'!G65=\"\",\"\",'1. HMST Application Budget'!G65)","v":""},0,null,null,null,null,0]
[null,null,{"$f":"IF('1. HMST Application Budget'!C66=\"\",\"\",'1. HMST Application Budget'!C66)","v":""},{"$f":"IF('1. HMST Application Budget'!D66=\"\",\"\",'1. HMST Application Budget'!D66)","v":""},{"$f":"IF('1. HMST Application Budget'!E66=\"\",\"\",'1. HMST Application Budget'!E66)","v":""},{"$f":"IF('1. HMST Application Budget'!F66=\"\",\"\",'1. HMST Application Budget'!F66)","v":""},{"$f":"IF('1. HMST Application Budget'!G66=\"\",\"\",'1. HMST Application Budget'!G66)","v":""},0,null,null,null,null,0]
[null,"In-kind contributions from own organisation:",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},{"$f":"E18","v":""},"","",{"$f":"SUM(E67:G67)","v":0},null,{"$f":"J18","v":0},0,0,{"$f":"SUM(J67:L67)","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},"","","",{"$f":"SUM(E68:G68)","v":0},null,0,0,0,0]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},"","","",{"$f":"SUM(E69:G69)","v":0},null,0,0,0,{"$f":"SUM(J69:L69)","v":0}]
[null,null,null,{"$f":"IF(D21=\"\",\"\",D21)","v":""},{"$f":"E21","v":""},"","",{"$f":"SUM(E70:G70)","v":0},null,{"$f":"J21","v":0},0,0,0]
[null,"In-kind contributions from project parters:",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"E31","v":""},"","",0,null,{"$f":"J31","v":0},0,0,0]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},"","","",0,null,0,0,0,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},"","","",{"$f":"SUM(E73:G73)","v":0},null,0,0,0,{"$f":"SUM(J73:L73)","v":0}]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},"","","",{"$f":"SUM(E74:G74)","v":0},null,0,0,0,{"$f":"SUM(J74:L74)","v":0}]
[null,null,null,{"$f":"IF(D35=\"\",\"\",D35)","v":""},{"$f":"E35","v":""},"","",0,null,{"$f":"J35","v":0},0,0,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E47:E75)","v":0},0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(H76<>H36,\"WARNING: Total expenses must be equal to total income\",\"Check OK\")","v":"Check OK"}]
[]
[null,"BUDGETED EARNED INCOME EXPLANATION"]
[null,"If your project relies on earned income, please provide brief details relating to rationale of revenue assumptions:",null,null,null,null,null,null,null,"ACTUAL NOTES - for additional general notes, or further details on specific income and expense items if required. "]
[null,{"$f":"IF('1. HMST Application Budget'!B81=\"\",\"\",'1. HMST Application Budget'!B81)","v":""}]
[]
[]
[]
[]
[null,"BUDGET NOTES - for additional general notes, or further details on specific income and expense items if required. Please ensure corresponding 'Note #' is included."]
[null,{"$f":"IF('1. HMST Application Budget'!B87=\"\",\"\",'1. HMST Application Budget'!B87)","v":""}]