{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["How to","Expenditure Guidelines","Expenditure","Justifications","Hidden"],"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":"How to","index":0,"n_rows":68,"n_cols":1,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Instructions for completing the budget calculator"]
["This budget calculator is provided to record eligible expenditure for your AUSMURI project."]
["You must use this budget calculator to:"]
["§  itemise the eligible costs of your proposed project and submit it with your MURI submission and AUSMURI application form, and"]
["§  to record your actual eligible expenditure submitting it with each six monthly AUSMURI report."]
["All figures you enter into the calculator must be in AUD$ GST inclusive, less any GST credits you can claim."]
["You should only enter eligible expenditure into the calculator. Your project may involve additional costs that are not eligible for grant funding. You should not enter these costs into the calculator. Guidance on eligible and ineligible expenditure is provided in the program guidelines and on the ‘Expenditure Guidelines’ tab of this template."]
["The calculator accommodates projects that are extended to five years. However you must ensure your initial budget and associated costs are only allocated over three years, the initial maximum project period."]
["Do not change the tab descriptions, formatting or unprotect any worksheets. Any changes will cause errors in the budget calculations and you may lose your entered data. You are not able to copy and paste text into the Expenditure tab. This function has been disabled to ensure the integrity of the calculations."]
["You must ensure you have read the program guidelines before completing this budget calculator."]
["If you require assistance using the calculator, contact us on 13 28 46."]
["Getting started"]
["You can only enter data into white cells."]
["Grant number"]
["When you first submit your application you will not have a grant number so leave it as TBA. You should use this cell if your project is approved and when you submit the calculator with your progress and final reports."]
["Start date and end date"]
["You should enter the dates as provided in your MURI submission. You should note however that you cannot start your project until you have an executed grant agreement with the Commonwealth. Any expenditure incurred prior to an executed grant agreement is not eligible for grant funding."]
["Total grant"]
["When you first use this calculator to itemise your proposed budget, this field will be prefilled at $3 million. This is the maximum grant you can apply for under the program. It is prefilled to prevent you from exceeding this figure when entering your expenditure items."]
["Grant expenditure"]
["This field will tally the expenditure items you enter where you allocate ‘AUSMURI Grant’ as the funding source. You will receive a warning message if it exceeds $3 million. If you receive a warning message you can reallocate an expense to an alternate funding source."]
["University participants"]
["Enter the names of all participating Australian universities in your proposed project."]
["Completing the application budget calculator"]
["Your project expenses are divided into five categories. These categories are shown in the calculator and will be reflected in your grant agreement."]
["§  personnel"]
["§  travel"]
["§  equipment"]
["§  materials"]
["§  other"]
["Entering a line item"]
["To record your expenditure you must add a line in the relevant category by clicking on the relevant ‘Add’ button. This will create a new line in the calculator for you to complete."]
["Allocating a funding source"]
["For each line item you must determine the funding source. Usually you will be requesting the AUSMURI grant to be the funding source. However we would like a record of all your eligible costs, not just those funded through AUSMURI. If you have an eligible cost not funded by AUSMURI you should select the university contributing this cost from the drop down menu."]
["The universities listed in the drop down menu are those that you entered as participants in the top of the form."]
["In-kind expenditure"]
["Where a participating university provides an in-kind contribution you may enter this into the budget calculator. You must ensure you allocate the contributing university as the funding source. The AUSMURI grant will not fund in-kind contributions."]
["Timing of eligible expenditure"]
["You must also tell us when your project expenditure is expected to be incurred. The ‘Total Cost’ you entered in column H must be allocated appropriately across the half year intervals, for the 3 year project, in columns K through to P."]
["The start and end dates of your project that you entered at the top of the form will have created date parameters around the half yearly intervals."]
["Entering the timing of your expenditure will then pre-populate the financial years in columns V to Z."]
["When you have completed all information in the line item, including the timing of the expenditure, click on the ‘Calculate’ button."]
["You will receive an error message if your figures do not reconcile with the total cost in your line item or if you have exceeded your maximum grant amount in any one financial year."]
["Deleting a line item"]
["If you want to delete a line item, click on the ‘Delete a row’ button. You will be asked to confirm which row you want to delete."]
["Justifications tab"]
["Expenditure included in the budget calculator require an explanation of why they are necessary for the success of the project."]
["Use the Justifications tab to record the justification for each line item."]
["We recommend you write this justification elsewhere (such as MSWord) and then copy your text into the space provided. After you have entered your text here you should click on the ‘Format notes’ button to allow it to be easily read."]
["Completing the budget calculator for reporting"]
["You should save a copy of your original budget calculator as submitted with your application. If your application is approved, you should make a copy of your calculator that you can use for reporting purposes."]
["We use your original budget calculator to determine a budget as agreed in your grant agreement. We understand your eligible expenses may change. However any changes beyond what is agreed in the grant agreement may need a formal variation."]
["You must keep records of your expenditure. Your budget calculator entries should align with your internal accounts. At the completion of your project you will be required to provide an independently audited financial acquittal report to verify that you spent the grant in accordance with the grant agreement. We may also need to re-examine claims and seek further information."]
["Grant number"]
["Enter the grant number as per your grant agreement."]
["State date and end date"]
["Enter the dates as agreed in your grant agreement."]
["Total grant"]
["Enter this amount as agreed in your grant agreement."]
["Amending line items"]
["Amend your line items where they differ from the budget submitted with your application. Use the ‘Calculate’ button to confirm that all new entries reconcile."]
["Future expenditure"]
["The calculator allows for current and future expenditure simultaneously. For each six monthly (half yearly) reporting period you should enter in the actual expenditure (cash and in-kind) incurred for the reporting period and also review and amend the expenditure anticipated for the remainder of the project. In-kind expenditure can only be allocated to a university funding source. You cannot allocate in-kind contributions to the AUSMURI grant."]
["Adding or deleting line items"]
["It may be necessary to add or delete costs in the course of your project. Use the ‘Delete a row’ button to delete a line item and associated cost. Add a new cost using the ‘Add’ buttons as you did when creating your initial budget."]
["Variations"]
["Your customer service manager will compare your initial budget with your reporting budgets and discuss with you any material changes."]
["Where you anticipate a material change is likely, you will need to submit a request for a variation to your grant agreement. You should talk to your customer service manager for clarification."]

{"sheet":"Expenditure Guidelines","index":1,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Eligible expenditure"]
["You can only spend grant funds on eligible expenditure you have incurred on your AUSMURI project as defined in your grant agreement."]
["Eligible expenditure items are"]
["§  salaries for Australian employees or contractors including"]
["§  Australian principal investigator and Australian co-investigators"]
["§  research associates"]
["§  research assistants "]
["§  technicians"]
["§  laboratory assistants"]
["§  salary on-costs of up to 30 per cent - where direct Australian salary costs have been included in the budget "]
["§  stipends for postgraduate students in Australia at the appropriate rate for the university"]
["§  domestic and international travel costs (economy) for Australian employees directly related to the project  "]
["§  materials and supplies necessary to undertake the project"]
["§  equipment and facilities necessary and to be used exclusively for the project "]
["§  other direct costs – for example publication costs."]
["The Program Delegate, a Senior Responsible Officer within Defence with responsibility for the program, makes the final decision on what is eligible expenditure and may give additional guidance on eligible expenditure if required."]
["To be eligible, expenditure must:"]
["§  be a direct cost of the project, or "]
["§  be incurred by you for approved project audit activities."]
["You must incur the project expenditure between the project start and end date for it to be eligible unless stated otherwise."]
["Ineligible expenditure"]
["We will not provide grant funding for the following expenditure items"]
["§  research not directly related to the project"]
["§  fee profit"]
["§  general facilities and accommodation including laboratory and office space"]
["§  general IT equipment including desktop or portable computers, printers and standard software"]
["§  use of photocopiers, telephones, mail, email and internet services"]
["§  financial costs, including interest"]
["§  activities and equipment that are already being supported through other sources"]
["§  organisational overheads "]
["§  administrative and clerical labour unless your project requires a significant amount of administrative support and the claim is justified "]
["§  teaching relief"]
["§  capital works and general infrastructure costs"]
["§  Higher Education Loan Programme (HELP) liabilities for students"]
["§  fees for international students"]
["§  bench fees or similar laboratory access fees levied by the institution"]
["§  costs related to preparing your MURI submission or AUSMURI application and preparing any project variation requests"]
["§  standard reference material"]
["§  direct development of products and other commercialisation activities"]
["§  other costs not directly related to the project, including but not limited to professional membership fees, professional development courses, fees for patent application and maintenance, visas, insurance, and mobile phones (purchase or call charges)."]
["You may start your project from the date we notify you that your application has been successful. We are not responsible for any expenditure you incur until a grant agreement is executed. "]

{"sheet":"Expenditure","index":2,"n_rows":52,"n_cols":32,"rows_kept":52,"cut":false,"hidden":false,"merged":[[45,3,45,4],[38,2,38,4],[44,2,44,4],[43,1,43,8],[20,4,20,5],[37,1,37,8],[39,3,39,4],[0,1,2,8],[19,1,19,8],[31,1,31,8],[33,3,33,4],[25,1,25,8],[26,2,26,4],[13,5,13,8],[14,5,14,8],[32,2,32,4],[12,5,12,8],[15,5,15,8]]}
[null,"A  U  S  M  U  R  I      B  U  D  G  E  T      C  A  L  C  U  L  A  T  O  R"]
[]
[]
[]
[null,null,{"$f":"Hidden!F55","v":0}]
[null,"Grant No.","TBA",null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",IF(OR(Hidden!C4= \"Jan\", Hidden!C4=\"Feb\", Hidden!C4=\"Mar\", Hidden!C4=\"Apr\", Hidden!C4=\"May\", Hidden!C4=\"Jun\"), \"Half 2\", \"Half 1\"))","v":""},{"$f":"IF($C$7=\"\",\"\",IF(K6=\"Half 1\", \"Half 2\", \"Half 1\"))","v":""},"","","","","","","","",null,"FY 1",null,"FY 2",null,"FY 3",null,"FY 4",null,"FY 5",null,"FY 6"]
[null,"Start Date",null,null,null,null,null,null,null,null,"FY","FY","FY","FY","FY","FY","FY","FY","FY","FY",null,{"$f":"K8","v":""},null,{"$f":"IF($V$7=\"\",\"\",V7+1)","v":""},null,{"$f":"IF($V$7=\"\",\"\",X7+1)","v":""},null,{"$f":"IF($V$7=\"\",\"\",Z7+1)","v":""},null,{"$f":"IF($V$7=\"\",\"\",AB7+1)","v":""},null,{"$f":"IF($V$7=\"\",\"\",AD7+1)","v":""}]
[null,"End Date",null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",IF(K6=\"Half 1\",(Hidden!$C$5+1), Hidden!$C$5))","v":""},{"$f":"IF($C$7=\"\",\"\",IF(L6=\"Half 1\",(K8+1), K8))","v":""},"","","","","","","",""]
[]
[null,"Total Grant",3000000,null,null,null,null,null,null,null,{"$f":"IF($C$7=\"\",\"\",IF(K6=\"Half 1\",\"1 July\",\"1 January\"))","v":""},"","","","","","","","",""]
[null,"Grant Expenditure",{"$f":"SUM(K52:T52)","v":0},null,null,null,null,null,null,null,{"$f":"IF($C$7=\"\",\"\",Hidden!$C$5)","v":""},{"$f":"IF(L6=\"Half 1\", K11, (K11+1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"AUSMURI Grant"]
[null,"Lead University",null,null,null,"WARNING: one or more row totals are incorrect. Check red items.",null,null,null,null,"To","To","To","To","To","To","To","To","To","To"]
[null,"University 2",null,null,null,"WARNING: grant expenditure exceeds total grant amount"]
[null,"University 3",null,null,null,"WARNING: you've entered items without assigning a funding source",null,null,null,null,{"$f":"IF($C$7=\"\",\"\",IF(K6=\"Half 1\",\"31 December\",\"30 June\"))","v":""},"","","","","","","","",""]
[null,"University 4",null,null,null,"WARNING: annual grant expenses >$1m",null,null,null,null,{"$f":"IF($C$7=\"\",\"\",Hidden!$C$5)","v":""},{"$f":"IF(L6=\"Half 1\", K16, (K16+1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"University 5"]
[]
[]
[null,"P  E  R  S  O  N  N  E  L"]
[null,"Item","Institution","Role","Name",null,"FTE","Total\nCost","Funding Source"]
[null,"Personnel Total",null,null,null,null,null,{"$f":"SUM(V22:AF22)","v":0},null,null,{"$f":"(SUMIF($B24:$B$52, \"Personnel\", K24:K$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", L24:L$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", M24:M$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", N24:N$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", O24:O$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", P24:P$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", Q24:Q$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", R24:R$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", S24:S$52))","v":0},{"$f":"(SUMIF($B24:$B$52, \"Personnel\", T24:T$52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K22:$T22))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K22:$T22))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K22:$T22))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K22:$T22))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K22:$T22))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K22:$T22))","v":0}]
[null,"PERSONNEL GRANT FUNDING TOTAL",null,null,null,null,null,{"$f":"SUM(V23:AF23)","v":0},null,null,{"$f":"(SUMIFS(K24:K$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(L24:L$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(M24:M$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(N24:N$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(O24:O$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(P24:P$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(Q24:Q$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(R24:R$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(S24:S$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(T24:T$52, $B24:$B$52, \"Personnel\", $I24:$I$52, \"Ausmuri Grant\"))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K23:$T23))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K23:$T23))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K23:$T23))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K23:$T23))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K23:$T23))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K23:$T23))","v":0}]
[]
[]
[null,"T  R  A  V  E  L"]
[null,"Item","Reason for travel",null,null,"Duration\n(days)","No. of travellers","Total\nCost","Funding Source"]
[null,"Travel Total",null,null,null,null,null,{"$f":"SUM(V28:AF28)","v":0},null,null,{"$f":"(SUMIF($B30:$B$52, \"Travel\", K30:K$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", L30:L$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", M30:M$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", N30:N$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", O30:O$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", P30:P$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", Q30:Q$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", R30:R$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", S30:S$52))","v":0},{"$f":"(SUMIF($B30:$B$52, \"Travel\", T30:T$52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K28:$T28))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K28:$T28))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K28:$T28))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K28:$T28))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K28:$T28))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K28:$T28))","v":0}]
[null,"TRAVEL GRANT FUNDING TOTAL",null,null,null,null,null,{"$f":"SUM(V29:AF29)","v":0},null,null,{"$f":"(SUMIFS(K30:K$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(L30:L$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(M30:M$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(N30:N$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(O30:O$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(P30:P$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(Q30:Q$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(R30:R$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(S30:S$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(T30:T$52, $B30:$B$52, \"Travel\", $I30:$I$52, \"Ausmuri Grant\"))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K29:$T29))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K29:$T29))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K29:$T29))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K29:$T29))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K29:$T29))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K29:$T29))","v":0}]
[]
[]
[null,"E  Q  U  I  P  M  E  N  T"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Equipment Total",null,null,null,null,null,{"$f":"SUM(V34:AF34)","v":0},null,null,{"$f":"SUMIF($B36:$B$52, \"Equipment\", K36:K$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", L36:L$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", M36:M$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", N36:N$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", O36:O$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", P36:P$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", Q36:Q$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", R36:R$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", S36:S$52)","v":0},{"$f":"SUMIF($B36:$B$52, \"Equipment\", T36:T$52)","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K34:$T34)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K34:$T34)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K34:$T34)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K34:$T34)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K34:$T34)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K34:$T34)","v":0}]
[null,"EQUIPMENT GRANT FUNDING TOTAL",null,null,null,null,null,{"$f":"SUM(V35:AF35)","v":0},null,null,{"$f":"(SUMIFS(K36:K$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(L36:L$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(M36:M$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(N36:N$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(O36:O$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(P36:P$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(Q36:Q$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(R36:R$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(S36:S$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(T36:T$52, $B36:$B$52, \"Equipment\", $I36:$I$52, \"Ausmuri Grant\"))","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K35:$T35)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K35:$T35)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K35:$T35)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K35:$T35)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K35:$T35)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K35:$T35)","v":0}]
[]
[]
[null,"M  A  T  E  R  I  A  L  S"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Materials Total",null,null,null,null,null,{"$f":"SUM(V40:AF40)","v":0},null,null,{"$f":"SUMIF($B42:$B$52, \"Materials\", K42:K$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", L42:L$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", M42:M$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", N42:N$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", O42:O$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", P42:P$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", Q42:Q$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", R42:R$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", S42:S$52)","v":0},{"$f":"SUMIF($B42:$B$52, \"Materials\", T42:T$52)","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K40:$T40)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K40:$T40)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K40:$T40)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K40:$T40)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K40:$T40)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K40:$T40)","v":0}]
[null,"MATERIALS GRANT FUNDING TOTAL",null,null,null,null,null,{"$f":"SUM(V41:AF41)","v":0},null,null,{"$f":"(SUMIFS(K42:K$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(L42:L$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(M42:M$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(N42:N$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(O42:O$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(P42:P$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(Q42:Q$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(R42:R$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(S42:S$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(T42:T$52, $B42:$B$52, \"Materials\", $I42:$I$52, \"Ausmuri Grant\"))","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K41:$T41)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K41:$T41)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K41:$T41)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K41:$T41)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K41:$T41)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K41:$T41)","v":0}]
[]
[]
[null,"O  T  H  E  R"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Other Total",null,null,null,null,null,{"$f":"SUM(V46:AF46)","v":0},null,null,{"$f":"SUMIF($B48:$B$52, \"Other\", K48:K$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", L48:L$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", M48:M$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", N48:N$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", O48:O$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", P48:P$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", Q48:Q$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", R48:R$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", S48:S$52)","v":0},{"$f":"SUMIF($B48:$B$52, \"Other\", T48:T$52)","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K46:$T46)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K46:$T46)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K46:$T46)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K46:$T46)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K46:$T46)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K46:$T46)","v":0}]
[null,"OTHER GRANT FUNDING TOTAL",null,null,null,null,null,{"$f":"SUM(V47:AF47)","v":0},null,null,{"$f":"(SUMIFS(K48:K$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(L48:L$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(M48:M$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(N48:N$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(O48:O$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(P48:P$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(Q48:Q$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(R48:R$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(S48:S$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},{"$f":"(SUMIFS(T48:T$52, $B48:$B$52, \"Other\", $I48:$I$52, \"Ausmuri Grant\"))","v":0},null,{"$f":"SUMIF($K$8:$T$8,V$7, $K47:$T47)","v":0},null,{"$f":"SUMIF($K$8:$T$8,X$7, $K47:$T47)","v":0},null,{"$f":"SUMIF($K$8:$T$8,Z$7, $K47:$T47)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AB$7, $K47:$T47)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AD$7, $K47:$T47)","v":0},null,{"$f":"SUMIF($K$8:$T$8,AF$7, $K47:$T47)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Expenses:",null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K51:$T51))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K51:$T51))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K51:$T51))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K51:$T51))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K51:$T51))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K51:$T51))","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL GRANT EXPENSES:",null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(SUMIF($K$8:$T$8,V$7, $K52:$T52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,X$7, $K52:$T52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,Z$7, $K52:$T52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AB$7, $K52:$T52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AD$7, $K52:$T52))","v":0},null,{"$f":"(SUMIF($K$8:$T$8,AF$7, $K52:$T52))","v":0}]

{"sheet":"Justifications","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,2,1]]}
[null,"J  U  S  T  I  F  I  C  A  T  I  O  N  S"]

{"sheet":"Hidden","index":4,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":true,"merged":[[45,2,45,4],[37,1,37,8],[38,2,38,4],[43,1,43,8],[44,2,44,4],[33,2,33,4],[39,2,39,4],[19,1,19,8],[25,1,25,8],[26,2,26,4],[31,1,31,8],[32,2,32,4],[27,2,27,4],[20,4,20,5],[21,4,21,5]]}
[]
[]
[]
[null,"Month",{"$f":"TEXT(Expenditure!C7,\"mmm\")","v":"Jan"}]
[null,"Year",{"$f":"TEXT(Expenditure!C7,\"YYY\")","v":"1900"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"P  E  R  S  O  N  N  E  L"]
[null,"Item","Institution","Role","Name",null,"FTE","Total\nCost","Funding Source"]
[null,"Personnel"]
[]
[]
[]
[null,"T  R  A  V  E  L"]
[null,"Item","Reason for travel",null,null,"Duration\n(days)","No. of travellers","Total\nCost","Funding Source"]
[null,"Travel"]
[]
[]
[]
[null,"E  Q  U  I  P  M  E  N  T"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Equipment",null,null,null,null,null,{"$f":"F34*G34","v":0}]
[]
[]
[]
[null,"M  A  T  E  R  I  A  L  S"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Materials",null,null,null,null,null,{"$f":"F40*G40","v":0}]
[]
[]
[]
[null,"O  T  H  E  R"]
[null,"Item","Description",null,null,"Quantity","Unit\nCost","Total\nCost","Funding Source"]
[null,"Other",null,null,null,null,null,{"$f":"F46*G46","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Labour OnCosts",null,null,null,{"$f":"SUM(L55, N55, P55)","v":0},null,null,null,null,null,{"$f":"(SUM(L56:L$56)*0.4)","v":0},null,{"$f":"(SUM(N56:N$56)*0.4)","v":0},null,{"$f":"(SUM(P56:P$56)*0.4)","v":0}]