{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","HMST Project Budget Template","HMST Financial Acquittal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS FOR HMSTRUST GRANT FINANCIAL ACQUITTAL"]
[]
[null,"As part of your final reporting back to HMSTrust, recipients of one-off grants are required to provide a financial acquittal using this template. "]
[]
[null,"Please save a copy of the template to enable you to attach it to your online progress or final report once completed. Make sure you include your organisation name in the field at the top of the template."]
[]
[null,"Only complete the shaded (coloured) areas. The Budget columns should be identical to that submitted in your original grant application. In the Actual columns, please provide details on what income you actually received and spent compared to 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."]
[]
[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,"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."]

{"sheet":"HMST Project Budget Template","index":1,"n_rows":84,"n_cols":6,"rows_kept":84,"cut":false,"hidden":false,"merged":[[2,2,2,3],[35,2,43,2],[78,1,81,4],[84,1,90,4],[3,2,4,2]]}
[null,"HMSTrust GRANT up to $30k PROJECT BUDGET TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:","<enter name>"]
[null,null,"Note #"]
[null,"INCOME",null,"Itemise detail / description","Budget Total","Confirmed (Yes/No)"]
[null,"Funding from HMSTrust (excluding GST):"]
[null,"Government funding (itemise):"]
[]
[]
[]
[null,"Other philanthropic sources (itemise):"]
[]
[]
[]
[]
[null,"Cash contribution from own organisation (itemise):"]
[null,"In-kind contribution from own organisation:"]
[null,"(itemise)"]
[]
[]
[null,"Earned income (itemise & explain in box below): "]
[]
[null,"Other income (specify & itemise):"]
[]
[]
[null,"Cash contribution from project partners:"]
[]
[]
[]
[null,"In-kind contributions from project partners:"]
[null,"(itemise and name project partners)"]
[]
[]
[]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E6:E34)","v":0}]
[null,null,"Note #",null,{"$f":"IF(E74<>E35,\"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",{"$f":"SUMIF(F6:F34,\"Yes\",E6:E34)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",{"$f":"SUMIF(F7:F34,\"No\",E7:E34)","v":0}]
[null,null,null,"HMST funding request",{"$f":"SUM(E6)","v":0}]
[null,null,null,null,{"$f":"SUM(E38:E40)","v":0}]
[null,null,null,null,{"$f":"IF(E41<>E35,\"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 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 (specify who conducts):"]
[null,"Other expenses (specify & itemise):"]
[]
[]
[]
[]
[]
[]
[]
[null,"In-kind contributions from own organisation:",null,{"$f":"IF(D17=\"\",\"\",D17)","v":""},{"$f":"E17","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},{"$f":"E18","v":0}]
[null,null,null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},0]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},0]
[null,"In-kind contributions from project parters:",null,{"$f":"IF(D30=\"\",\"\",D30)","v":""},{"$f":"E30","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"E31","v":0}]
[null,null,null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},0]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E45:E73)","v":0}]
[null,null,null,null,{"$f":"IF(E74<>E35,\"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":"HMST Financial Acquittal","index":2,"n_rows":85,"n_cols":8,"rows_kept":85,"cut":false,"hidden":false,"merged":[[35,2,43,2],[2,2,2,3],[78,1,81,4],[84,1,90,4],[3,2,4,2]]}
[null,"HMSTrust GRANT up to $30k PROJECT FINANCIAL ACQUITTAL TEMPLATE"]
[]
[null,"ORGANISATION TRADING NAME:",{"$f":"'HMST Project Budget Template'!C3:D3","v":"<enter name>"}]
[null,null,"Note #"]
[null,"INCOME",null,"Itemise detail / description","Budget Total","Confirmed (Yes/No)","Actual Total","Explanation of variance between actual and budget"]
[null,"Funding from HMSTrust (excluding GST):",{"$f":"IF('HMST Project Budget Template'!C6=\"\",\"\",'HMST Project Budget Template'!C6)","v":""},{"$f":"IF('HMST Project Budget Template'!D6=\"\",\"\",'HMST Project Budget Template'!D6)","v":""},{"$f":"'HMST Project Budget Template'!E6","v":0}]
[null,"Government funding (itemise):",{"$f":"IF('HMST Project Budget Template'!C7=\"\",\"\",'HMST Project Budget Template'!C7)","v":""},{"$f":"IF('HMST Project Budget Template'!D7=\"\",\"\",'HMST Project Budget Template'!D7)","v":""},{"$f":"'HMST Project Budget Template'!E7","v":0},{"$f":"IF('HMST Project Budget Template'!F7=\"\",\"\",'HMST Project Budget Template'!F7)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C8=\"\",\"\",'HMST Project Budget Template'!C8)","v":""},{"$f":"IF('HMST Project Budget Template'!D8=\"\",\"\",'HMST Project Budget Template'!D8)","v":""},{"$f":"'HMST Project Budget Template'!E8","v":0},{"$f":"IF('HMST Project Budget Template'!F8=\"\",\"\",'HMST Project Budget Template'!F8)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C9=\"\",\"\",'HMST Project Budget Template'!C9)","v":""},{"$f":"IF('HMST Project Budget Template'!D9=\"\",\"\",'HMST Project Budget Template'!D9)","v":""},{"$f":"'HMST Project Budget Template'!E9","v":0},{"$f":"IF('HMST Project Budget Template'!F9=\"\",\"\",'HMST Project Budget Template'!F9)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C10=\"\",\"\",'HMST Project Budget Template'!C10)","v":""},{"$f":"IF('HMST Project Budget Template'!D10=\"\",\"\",'HMST Project Budget Template'!D10)","v":""},{"$f":"'HMST Project Budget Template'!E10","v":0},{"$f":"IF('HMST Project Budget Template'!F10=\"\",\"\",'HMST Project Budget Template'!F10)","v":""}]
[null,"Other philanthropic sources (itemise):",{"$f":"IF('HMST Project Budget Template'!C11=\"\",\"\",'HMST Project Budget Template'!C11)","v":""},{"$f":"IF('HMST Project Budget Template'!D11=\"\",\"\",'HMST Project Budget Template'!D11)","v":""},{"$f":"'HMST Project Budget Template'!E11","v":0},{"$f":"IF('HMST Project Budget Template'!F11=\"\",\"\",'HMST Project Budget Template'!F11)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C12=\"\",\"\",'HMST Project Budget Template'!C12)","v":""},{"$f":"IF('HMST Project Budget Template'!D12=\"\",\"\",'HMST Project Budget Template'!D12)","v":""},{"$f":"'HMST Project Budget Template'!E12","v":0},{"$f":"IF('HMST Project Budget Template'!F12=\"\",\"\",'HMST Project Budget Template'!F12)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C13=\"\",\"\",'HMST Project Budget Template'!C13)","v":""},{"$f":"IF('HMST Project Budget Template'!D13=\"\",\"\",'HMST Project Budget Template'!D13)","v":""},{"$f":"'HMST Project Budget Template'!E13","v":0},{"$f":"IF('HMST Project Budget Template'!F13=\"\",\"\",'HMST Project Budget Template'!F13)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C14=\"\",\"\",'HMST Project Budget Template'!C14)","v":""},{"$f":"IF('HMST Project Budget Template'!D14=\"\",\"\",'HMST Project Budget Template'!D14)","v":""},{"$f":"'HMST Project Budget Template'!E14","v":0},{"$f":"IF('HMST Project Budget Template'!F14=\"\",\"\",'HMST Project Budget Template'!F14)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C15=\"\",\"\",'HMST Project Budget Template'!C15)","v":""},{"$f":"IF('HMST Project Budget Template'!D15=\"\",\"\",'HMST Project Budget Template'!D15)","v":""},{"$f":"'HMST Project Budget Template'!E15","v":0},{"$f":"IF('HMST Project Budget Template'!F15=\"\",\"\",'HMST Project Budget Template'!F15)","v":""}]
[null,"Cash contribution from own organisation (itemise):",{"$f":"IF('HMST Project Budget Template'!C16=\"\",\"\",'HMST Project Budget Template'!C16)","v":""},{"$f":"IF('HMST Project Budget Template'!D16=\"\",\"\",'HMST Project Budget Template'!D16)","v":""},{"$f":"'HMST Project Budget Template'!E16","v":0},{"$f":"IF('HMST Project Budget Template'!F16=\"\",\"\",'HMST Project Budget Template'!F16)","v":""}]
[null,"In-kind contribution from own organisation:",{"$f":"IF('HMST Project Budget Template'!C17=\"\",\"\",'HMST Project Budget Template'!C17)","v":""},{"$f":"IF('HMST Project Budget Template'!D17=\"\",\"\",'HMST Project Budget Template'!D17)","v":""},{"$f":"'HMST Project Budget Template'!E17","v":0},{"$f":"IF('HMST Project Budget Template'!F17=\"\",\"\",'HMST Project Budget Template'!F17)","v":""}]
[null,"(itemise)",{"$f":"IF('HMST Project Budget Template'!C18=\"\",\"\",'HMST Project Budget Template'!C18)","v":""},{"$f":"IF('HMST Project Budget Template'!D18=\"\",\"\",'HMST Project Budget Template'!D18)","v":""},{"$f":"'HMST Project Budget Template'!E18","v":0},{"$f":"IF('HMST Project Budget Template'!F18=\"\",\"\",'HMST Project Budget Template'!F18)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C19=\"\",\"\",'HMST Project Budget Template'!C19)","v":""},{"$f":"IF('HMST Project Budget Template'!D19=\"\",\"\",'HMST Project Budget Template'!D19)","v":""},{"$f":"'HMST Project Budget Template'!E19","v":0},{"$f":"IF('HMST Project Budget Template'!F19=\"\",\"\",'HMST Project Budget Template'!F19)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C20=\"\",\"\",'HMST Project Budget Template'!C20)","v":""},{"$f":"IF('HMST Project Budget Template'!D20=\"\",\"\",'HMST Project Budget Template'!D20)","v":""},{"$f":"'HMST Project Budget Template'!E20","v":0},{"$f":"IF('HMST Project Budget Template'!F20=\"\",\"\",'HMST Project Budget Template'!F20)","v":""}]
[null,"Earned income (itemise & explain in box below): ",{"$f":"IF('HMST Project Budget Template'!C21=\"\",\"\",'HMST Project Budget Template'!C21)","v":""},{"$f":"IF('HMST Project Budget Template'!D21=\"\",\"\",'HMST Project Budget Template'!D21)","v":""},{"$f":"'HMST Project Budget Template'!E21","v":0},{"$f":"IF('HMST Project Budget Template'!F21=\"\",\"\",'HMST Project Budget Template'!F21)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C22=\"\",\"\",'HMST Project Budget Template'!C22)","v":""},{"$f":"IF('HMST Project Budget Template'!D22=\"\",\"\",'HMST Project Budget Template'!D22)","v":""},{"$f":"'HMST Project Budget Template'!E22","v":0},{"$f":"IF('HMST Project Budget Template'!F22=\"\",\"\",'HMST Project Budget Template'!F22)","v":""}]
[null,"Other income (specify & itemise):",{"$f":"IF('HMST Project Budget Template'!C23=\"\",\"\",'HMST Project Budget Template'!C23)","v":""},{"$f":"IF('HMST Project Budget Template'!D23=\"\",\"\",'HMST Project Budget Template'!D23)","v":""},{"$f":"'HMST Project Budget Template'!E23","v":0},{"$f":"IF('HMST Project Budget Template'!F23=\"\",\"\",'HMST Project Budget Template'!F23)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C24=\"\",\"\",'HMST Project Budget Template'!C24)","v":""},{"$f":"IF('HMST Project Budget Template'!D24=\"\",\"\",'HMST Project Budget Template'!D24)","v":""},{"$f":"'HMST Project Budget Template'!E24","v":0},{"$f":"IF('HMST Project Budget Template'!F24=\"\",\"\",'HMST Project Budget Template'!F24)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C25=\"\",\"\",'HMST Project Budget Template'!C25)","v":""},{"$f":"IF('HMST Project Budget Template'!D25=\"\",\"\",'HMST Project Budget Template'!D25)","v":""},{"$f":"'HMST Project Budget Template'!E25","v":0},{"$f":"IF('HMST Project Budget Template'!F25=\"\",\"\",'HMST Project Budget Template'!F25)","v":""}]
[null,"Cash contribution from project partners:",{"$f":"IF('HMST Project Budget Template'!C26=\"\",\"\",'HMST Project Budget Template'!C26)","v":""},{"$f":"IF('HMST Project Budget Template'!D26=\"\",\"\",'HMST Project Budget Template'!D26)","v":""},{"$f":"'HMST Project Budget Template'!E26","v":0},{"$f":"IF('HMST Project Budget Template'!F26=\"\",\"\",'HMST Project Budget Template'!F26)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C27=\"\",\"\",'HMST Project Budget Template'!C27)","v":""},{"$f":"IF('HMST Project Budget Template'!D27=\"\",\"\",'HMST Project Budget Template'!D27)","v":""},{"$f":"'HMST Project Budget Template'!E27","v":0},{"$f":"IF('HMST Project Budget Template'!F27=\"\",\"\",'HMST Project Budget Template'!F27)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C28=\"\",\"\",'HMST Project Budget Template'!C28)","v":""},{"$f":"IF('HMST Project Budget Template'!D28=\"\",\"\",'HMST Project Budget Template'!D28)","v":""},{"$f":"'HMST Project Budget Template'!E28","v":0},{"$f":"IF('HMST Project Budget Template'!F28=\"\",\"\",'HMST Project Budget Template'!F28)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C29=\"\",\"\",'HMST Project Budget Template'!C29)","v":""},{"$f":"IF('HMST Project Budget Template'!D29=\"\",\"\",'HMST Project Budget Template'!D29)","v":""},{"$f":"'HMST Project Budget Template'!E29","v":0},{"$f":"IF('HMST Project Budget Template'!F29=\"\",\"\",'HMST Project Budget Template'!F29)","v":""}]
[null,"In-kind contributions from project partners:",{"$f":"IF('HMST Project Budget Template'!C30=\"\",\"\",'HMST Project Budget Template'!C30)","v":""},{"$f":"IF('HMST Project Budget Template'!D30=\"\",\"\",'HMST Project Budget Template'!D30)","v":""},{"$f":"'HMST Project Budget Template'!E30","v":0},{"$f":"IF('HMST Project Budget Template'!F30=\"\",\"\",'HMST Project Budget Template'!F30)","v":""}]
[null,"(itemise and name project partners)",{"$f":"IF('HMST Project Budget Template'!C31=\"\",\"\",'HMST Project Budget Template'!C31)","v":""},{"$f":"IF('HMST Project Budget Template'!D31=\"\",\"\",'HMST Project Budget Template'!D31)","v":""},{"$f":"'HMST Project Budget Template'!E31","v":0},{"$f":"IF('HMST Project Budget Template'!F31=\"\",\"\",'HMST Project Budget Template'!F31)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C32=\"\",\"\",'HMST Project Budget Template'!C32)","v":""},{"$f":"IF('HMST Project Budget Template'!D32=\"\",\"\",'HMST Project Budget Template'!D32)","v":""},{"$f":"'HMST Project Budget Template'!E32","v":0},{"$f":"IF('HMST Project Budget Template'!F32=\"\",\"\",'HMST Project Budget Template'!F32)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C33=\"\",\"\",'HMST Project Budget Template'!C33)","v":""},{"$f":"IF('HMST Project Budget Template'!D33=\"\",\"\",'HMST Project Budget Template'!D33)","v":""},{"$f":"'HMST Project Budget Template'!E33","v":0},{"$f":"IF('HMST Project Budget Template'!F33=\"\",\"\",'HMST Project Budget Template'!F33)","v":""}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C34=\"\",\"\",'HMST Project Budget Template'!C34)","v":""},{"$f":"IF('HMST Project Budget Template'!D34=\"\",\"\",'HMST Project Budget Template'!D34)","v":""},{"$f":"'HMST Project Budget Template'!E34","v":0},{"$f":"IF('HMST Project Budget Template'!F34=\"\",\"\",'HMST Project Budget Template'!F34)","v":""}]
[null,null,null,"TOTAL INCOME",{"$f":"SUM(E6:E34)","v":0},null,{"$f":"SUM(G6:G34)","v":0}]
[null,null,"Note #",null,{"$f":"IF(E74<>E35,\"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",{"$f":"SUMIF(F6:F34,\"Yes\",E6:E34)","v":0}]
[null,null,null,"Total unconfirmed income (excluding HMST funding request)",{"$f":"SUMIF(F7:F34,\"No\",E7:E34)","v":0}]
[null,null,null,"HMST funding request",{"$f":"SUM(E6)","v":0}]
[null,null,null,null,{"$f":"SUM(E38:E40)","v":0}]
[null,null,null,null,{"$f":"IF(E41<>E35,\"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 Total",null,"Actual \nTotal","Explanation of variance between actual and budget"]
[null,"Salaries (including super, payroll tax etc):",{"$f":"IF('HMST Project Budget Template'!C45=\"\",\"\",'HMST Project Budget Template'!C45)","v":""},{"$f":"IF('HMST Project Budget Template'!D45=\"\",\"\",'HMST Project Budget Template'!D45)","v":""},{"$f":"'HMST Project Budget Template'!E45","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C46=\"\",\"\",'HMST Project Budget Template'!C46)","v":""},{"$f":"IF('HMST Project Budget Template'!D46=\"\",\"\",'HMST Project Budget Template'!D46)","v":""},{"$f":"'HMST Project Budget Template'!E46","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C47=\"\",\"\",'HMST Project Budget Template'!C47)","v":""},{"$f":"IF('HMST Project Budget Template'!D47=\"\",\"\",'HMST Project Budget Template'!D47)","v":""},{"$f":"'HMST Project Budget Template'!E47","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C48=\"\",\"\",'HMST Project Budget Template'!C48)","v":""},{"$f":"IF('HMST Project Budget Template'!D48=\"\",\"\",'HMST Project Budget Template'!D48)","v":""},{"$f":"'HMST Project Budget Template'!E48","v":0}]
[null,"Consultant fees specific to this project:",{"$f":"IF('HMST Project Budget Template'!C49=\"\",\"\",'HMST Project Budget Template'!C49)","v":""},{"$f":"IF('HMST Project Budget Template'!D49=\"\",\"\",'HMST Project Budget Template'!D49)","v":""},{"$f":"'HMST Project Budget Template'!E49","v":0}]
[null,"Capital, fit-out, equipment costs (itemise):",{"$f":"IF('HMST Project Budget Template'!C50=\"\",\"\",'HMST Project Budget Template'!C50)","v":""},{"$f":"IF('HMST Project Budget Template'!D50=\"\",\"\",'HMST Project Budget Template'!D50)","v":""},{"$f":"'HMST Project Budget Template'!E50","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C51=\"\",\"\",'HMST Project Budget Template'!C51)","v":""},{"$f":"IF('HMST Project Budget Template'!D51=\"\",\"\",'HMST Project Budget Template'!D51)","v":""},{"$f":"'HMST Project Budget Template'!E51","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C52=\"\",\"\",'HMST Project Budget Template'!C52)","v":""},{"$f":"IF('HMST Project Budget Template'!D52=\"\",\"\",'HMST Project Budget Template'!D52)","v":""},{"$f":"'HMST Project Budget Template'!E52","v":0}]
[null,"Administration and consumable costs:",{"$f":"IF('HMST Project Budget Template'!C53=\"\",\"\",'HMST Project Budget Template'!C53)","v":""},{"$f":"IF('HMST Project Budget Template'!D53=\"\",\"\",'HMST Project Budget Template'!D53)","v":""},{"$f":"'HMST Project Budget Template'!E53","v":0}]
[null,"Travel and accommodation:",{"$f":"IF('HMST Project Budget Template'!C54=\"\",\"\",'HMST Project Budget Template'!C54)","v":""},{"$f":"IF('HMST Project Budget Template'!D54=\"\",\"\",'HMST Project Budget Template'!D54)","v":""},{"$f":"'HMST Project Budget Template'!E54","v":0}]
[null,"Marketing/advertising/promotion:",{"$f":"IF('HMST Project Budget Template'!C55=\"\",\"\",'HMST Project Budget Template'!C55)","v":""},{"$f":"IF('HMST Project Budget Template'!D55=\"\",\"\",'HMST Project Budget Template'!D55)","v":""},{"$f":"'HMST Project Budget Template'!E55","v":0}]
[null,"Evaluation (specify who conducts):",{"$f":"IF('HMST Project Budget Template'!C56=\"\",\"\",'HMST Project Budget Template'!C56)","v":""},{"$f":"IF('HMST Project Budget Template'!D56=\"\",\"\",'HMST Project Budget Template'!D56)","v":""},{"$f":"'HMST Project Budget Template'!E56","v":0}]
[null,"Other expenses (specify & itemise):",{"$f":"IF('HMST Project Budget Template'!C57=\"\",\"\",'HMST Project Budget Template'!C57)","v":""},{"$f":"IF('HMST Project Budget Template'!D57=\"\",\"\",'HMST Project Budget Template'!D57)","v":""},{"$f":"'HMST Project Budget Template'!E57","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C58=\"\",\"\",'HMST Project Budget Template'!C58)","v":""},{"$f":"IF('HMST Project Budget Template'!D58=\"\",\"\",'HMST Project Budget Template'!D58)","v":""},{"$f":"'HMST Project Budget Template'!E58","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C59=\"\",\"\",'HMST Project Budget Template'!C59)","v":""},{"$f":"IF('HMST Project Budget Template'!D59=\"\",\"\",'HMST Project Budget Template'!D59)","v":""},{"$f":"'HMST Project Budget Template'!E59","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C60=\"\",\"\",'HMST Project Budget Template'!C60)","v":""},{"$f":"IF('HMST Project Budget Template'!D60=\"\",\"\",'HMST Project Budget Template'!D60)","v":""},{"$f":"'HMST Project Budget Template'!E60","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C61=\"\",\"\",'HMST Project Budget Template'!C61)","v":""},{"$f":"IF('HMST Project Budget Template'!D61=\"\",\"\",'HMST Project Budget Template'!D61)","v":""},{"$f":"'HMST Project Budget Template'!E61","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C62=\"\",\"\",'HMST Project Budget Template'!C62)","v":""},{"$f":"IF('HMST Project Budget Template'!D62=\"\",\"\",'HMST Project Budget Template'!D62)","v":""},{"$f":"'HMST Project Budget Template'!E62","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C63=\"\",\"\",'HMST Project Budget Template'!C63)","v":""},{"$f":"IF('HMST Project Budget Template'!D63=\"\",\"\",'HMST Project Budget Template'!D63)","v":""},{"$f":"'HMST Project Budget Template'!E63","v":0}]
[null,null,{"$f":"IF('HMST Project Budget Template'!C64=\"\",\"\",'HMST Project Budget Template'!C64)","v":""},{"$f":"IF('HMST Project Budget Template'!D64=\"\",\"\",'HMST Project Budget Template'!D64)","v":""},{"$f":"'HMST Project Budget Template'!E64","v":0}]
[null,"In-kind contributions from own organisation:",null,{"$f":"IF(D17=\"\",\"\",D17)","v":""},{"$f":"'HMST Project Budget Template'!E65","v":0},null,{"$f":"G17","v":0}]
[null,"(automatically populated from Income section above)",null,{"$f":"IF(D18=\"\",\"\",D18)","v":""},{"$f":"'HMST Project Budget Template'!E66","v":0},null,{"$f":"G18","v":0}]
[null,null,null,{"$f":"IF(D19=\"\",\"\",D19)","v":""},{"$f":"'HMST Project Budget Template'!E67","v":0},null,0]
[null,null,null,{"$f":"IF(D20=\"\",\"\",D20)","v":""},{"$f":"'HMST Project Budget Template'!E68","v":0},null,0]
[null,"In-kind contributions from project parters:",null,{"$f":"IF(D30=\"\",\"\",D30)","v":""},{"$f":"'HMST Project Budget Template'!E69","v":0},null,{"$f":"G30","v":0}]
[null,"(automatically populated from Income section above):",null,{"$f":"IF(D31=\"\",\"\",D31)","v":""},{"$f":"'HMST Project Budget Template'!E70","v":0},null,{"$f":"G31","v":0}]
[null,null,null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},{"$f":"'HMST Project Budget Template'!E71","v":0},null,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",D33)","v":""},{"$f":"'HMST Project Budget Template'!E72","v":0},null,0]
[null,null,null,{"$f":"IF(D34=\"\",\"\",D34)","v":""},{"$f":"'HMST Project Budget Template'!E73","v":0},null,0]
[null,null,null,"TOTAL EXPENSES",{"$f":"SUM(E45:E73)","v":0},null,0]
[null,null,null,null,{"$f":"IF(E74<>E35,\"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,"ACTUAL NOTES - for additional general notes, or further details on specific income and expense items if required. "]
[null,{"$f":"IF('HMST Project Budget Template'!B79=\"\",\"\",'HMST Project Budget Template'!B79)","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('HMST Project Budget Template'!B85=\"\",\"\",'HMST Project Budget Template'!B85)","v":""}]