{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["General Information","Instructions","IE24 BUDGET tool","F2_ARC Contributions","F3_Non-ARC Contributions","UQ Research Academic Staff","UQ Professional Staff","Salary Gap Calculations","List","Lists","Salary Gap Calculations (2)","Admin-Salaries","Admin-Other"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":2,"defined_names":70,"comments":2,"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":"General Information","index":0,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 3","2023-09-06"]

{"sheet":"Instructions","index":1,"n_rows":186,"n_cols":14,"rows_kept":186,"cut":false,"hidden":false,"merged":[[181,13,181,18],[182,13,182,18],[177,13,177,18],[178,13,178,18],[179,13,179,18],[180,13,180,18],[130,13,130,18],[131,13,131,18],[132,13,132,18],[133,13,133,18],[134,13,134,18],[81,13,81,18],[75,13,75,18],[128,13,128,18],[129,13,129,18],[80,13,80,18],[5,13,5,18],[74,13,74,18],[135,13,135,18],[183,13,183,18],[10,13,10,18],[7,13,7,18],[6,13,6,18],[8,13,8,18],[9,13,9,18],[11,13,11,18],[76,13,76,18],[77,13,77,18],[78,13,78,18],[79,13,79,18],[12,13,12,18],[176,13,176,18]]}
["1. Selection of Fellowship Duration and autopopulation of UQ Earmarked HDR Scholarship"]
["The main tab for data entry is the IE24 BUDGET tool. To start the data entry process, select the duration of your fellowship in cell C5."]
["Based on the duration selected, the calculation will autopopulate with UQ Earmarked PhD Scholarship contributions (only 3 year fellowships will be eligible to receive a UQ PhD Scholarship)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NAVIGATION:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"1. Selection of Fellowship Duration and autopopulation of UQ Earmarked HDR Scholarship"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A21","v":"2. Selection of Salary Level and Contribution Amounts"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A44","v":"3. Expenditure Data Entry"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A68","v":"4. Fellow's Salary Level Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A92","v":"5. Budget Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A110","v":"6. F2 and F3 - Budget Justification"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A143","v":"7. Export into the Application"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A173","v":"8. Troubleshooting and Additional Resources"}]
[]
[]
[]
[]
[]
[]
[]
["2. Selection of Salary Level and Contribution Amounts"]
["Select the Academic Level for the Fellow's salary and values for contributions into the row highlighted in blue (see below)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Expenditure Data Entry"]
["Budget expenses go into the central section. Please provide detailed labels in the second column (B), based on the example "]
["provided in the first two lines (it is ok to overwrite them)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Fellow's Salary Level Check"]
["If Fellow's salary does not match contributions from funding sources, the cell will be highlighted in red (when there is a salary gap), or yellow (if you have allocated more than is needed for the proposed academic level)."]
["Salary Gap means you need to allocate more funding towards the salary, and this is expected to be covered by local cash or industry partner cash. "]
["Salary Gap cash contribution is to be entered against the fellowship salary, under the appropriate source of contribution (underlined below)."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NAVIGATION:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"1. Selection of Fellowship Duration and autopopulation of UQ Earmarked HDR Scholarship"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A21","v":"2. Selection of Salary Level and Contribution Amounts"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A44","v":"3. Expenditure Data Entry"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A68","v":"4. Fellow's Salary Level Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A92","v":"5. Budget Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A110","v":"6. F2 and F3 - Budget Justification"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A143","v":"7. Export into the Application"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A173","v":"8. Troubleshooting and Additional Resources"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5. Budget Check"]
["Budget check row and column are created to help you spot any inconsistencies in the budget. If the budget is balanced, both "]
["budget checks will be green. If a cell is highlighted in red, you have not allocated enough funding for the expenses. If a cell"]
["is yellow, you have more funding available than the expense and should balance the budget. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6. F2 and F3 - Budget Justification"]
["F2 and F3 tabs will populate values from the BUDGET tool tab automatically, you only need to enter the justification for each "]
["expense category. Please note that this table will group contributions from all industry partners together, so you might have "]
["to delineate contributions from each partner in the justification section. These tables can be entered directly into the UQ Template for the relevant sections."]
["Template for the relevant sections."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NAVIGATION:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"1. Selection of Fellowship Duration and autopopulation of UQ Earmarked HDR Scholarship"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A21","v":"2. Selection of Salary Level and Contribution Amounts"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A44","v":"3. Expenditure Data Entry"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A68","v":"4. Fellow's Salary Level Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A92","v":"5. Budget Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A110","v":"6. F2 and F3 - Budget Justification"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A143","v":"7. Export into the Application"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A173","v":"8. Troubleshooting and Additional Resources"}]
[]
[]
[]
[]
[]
[]
["7. Export into the Application"]
["RMS Data Entry table is a ready source for you to transfer the amounts into the RMS budget, to make sure it is aligned with "]
["your detailed expenditure and justification sections. F2 and F3 sections will populate values automatically, but you"]
["will need to enter justification into the relevant column. When you are done, press CTRL+SHIFT+H to run the algorithm that"]
["will hide rows that do not have any values. Then you can export these tables into the UQ Template. If you change "]
["anything, you will need to select the entire sheet and select 'Unhide' from the right-click menu, and then re-run the algorithm "]
["to collapse the rows again."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8. Troubleshooting and Additional Resources"]
["Please refer to the General Information tab for further information."]
[]
[" If you make any changes, and need to re-export F2 and F3 sections for the application, please select all working columns in F2 ",null,null,null,null,null,null,null,null,null,null,null,null,"NAVIGATION:"]
["and F3 tabs and select 'Unhide' in the right-click menu. Once you have finished making changes, press CTRL+SHIFT+H to run the ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"1. Selection of Fellowship Duration and autopopulation of UQ Earmarked HDR Scholarship"}]
["macros again to format these sections for export. ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A21","v":"2. Selection of Salary Level and Contribution Amounts"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A44","v":"3. Expenditure Data Entry"}]
["Please use the UQ Academic and UQ Professional Staff tabs as a reference guide to calculate correct salary values for any ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A68","v":"4. Fellow's Salary Level Check"}]
["additional personnel. You can change the FTE/Number of hours for the formula to calculate the salary value.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A92","v":"5. Budget Check"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A110","v":"6. F2 and F3 - Budget Justification"}]
["If you need a reference for Fellow's salary gap for different Academic Levels of employment, please refer to the Salary Gap ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A143","v":"7. Export into the Application"}]
["Calculations tab. ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A173","v":"8. Troubleshooting and Additional Resources"}]
[]
["If something isn't working correctly, please reach out to the Research Office at ARCFellowships@research.uq.edu.au for assistance."]

{"sheet":"IE24 BUDGET tool","index":2,"n_rows":139,"n_cols":28,"rows_kept":139,"cut":false,"hidden":false,"merged":[[1,18,1,25],[0,4,0,7],[0,8,0,9],[0,10,0,11],[2,0,41,0],[4,3,4,11],[0,0,1,1],[96,4,96,11],[98,3,98,11],[2,18,2,25],[7,18,7,25],[12,18,12,25],[2,4,2,11],[47,4,47,7],[47,8,47,9],[47,10,47,11],[49,4,49,11],[51,3,51,11],[94,4,94,7],[94,8,94,9],[94,10,94,11],[138,0,138,2],[47,0,48,1],[94,0,95,1],[6,2,41,2],[53,2,88,2],[100,2,135,2],[96,0,135,0],[44,0,44,2],[91,0,91,2],[49,0,88,0]]}
["Year 1",null,null,null,"UQ Contributions",null,null,null,"Key Industry Partner",null,"Other Industry Partners",null,"Total (red highlight - salary gap; yellow highlight - overspend) ","UQ cash total","Industry Parters cash totals","Industry Parters in-kind totals",null,null,null,null,null,null,null,null,null,null,null,"Stop Insert/Delete"]
[null,null,null,"Australian Research Council","UQ Graduate School Stipend (cash)","UQ Central Support (cash)","UQ Local Sources (cash)","In-kind","Cash","In-kind","Cash","In-kind",null,null,null,null,null,null,"RMS Data Entry",null,null,null,null,null,null,null,null,{"$f":"1","v":1}]
["Year 1",null,"Fellow salary",112897,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YEAR 1",null,null,null,null,null,null,null,null,1]
[null,null,"Project costs",50000,{"$f":"_xlfn.XLOOKUP($C$5,List!$B$3:$B$5,List!$C$3:$C$5,0)","v":32192},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARC","Administering Organisation",null,"Key Industry Partner",null,"Other Industry Partners",null,null,1]
[null,"Duration of Fellowship","3 Years",null,null,null,null,null,null,null,null,null,"Fellow salary",null,null,null,"Salary Gap",null,null,"Cash","Cash","In-kind","Cash","In-kind","Cash","In-kind",null,1]
[null,"Fellow [INSER YOUR NAME]","D02",{"$f":"D3","v":112897},null,null,null,null,null,null,null,null,{"$f":"(D6+G6+I6+K6)","v":112897},{"$f":"ROUNDUP(_xlfn.XLOOKUP(C6,'Salary Gap Calculations'!C7:C25,'Salary Gap Calculations'!D7:D25, \"Check Salary Code\"),0)","v":222524},null,null,{"$f":"M6-N6","v":-109627},null,"Personnel",{"$f":"D3","v":112897},{"$f":"E6+F6+G6","v":0},"-",{"$f":"I6","v":0},"-",{"$f":"K53","v":0},"-",null,1]
[null,"Personnel Other",null,null,null,null,null,null,null,null,null,null,"Project costs",null,null,null,null,null,"Project costs",{"$f":"D4","v":50000},{"$f":"E44+F44+G44","v":32192},{"$f":"H44","v":0},{"$f":"I44","v":0},{"$f":"J44","v":0},{"$f":"K91","v":0},{"$f":"L44","v":0},null,1]
[null,{"$f":"_xlfn.XLOOKUP(E4,List!$C$3:$C$5,List!$D$3:$D$5)","v":"Earmarked PhD Stipend"},null,null,{"$f":"_xlfn.XLOOKUP(B8,List!$D$3:$D$5,List!$C$3:$C$5,\"0\")","v":32192},null,null,null,null,null,null,null,{"$f":"SUM(D8:L8)","v":32192},{"$f":"E8+F8+G8","v":32192},{"$f":"I8+K8","v":0},{"$f":"J8+L8","v":0},null,null,"YEAR 2",null,null,null,null,null,null,null,null,1]
[null,"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D9:L9)","v":0},0,{"$f":"I9+K9","v":0},{"$f":"J9+L9","v":0},null,null,null,"ARC","Administering Organisation",null,"Key Industry Partner",null,"Other Industry Partners",null,null,1]
[null,"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,"Cash","Cash","In-kind","Cash","In-kind","Cash","In-kind",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Personnel",{"$f":"D50","v":112897},{"$f":"F53+G53","v":0},"-",{"$f":"I53","v":0},"-",null,"-",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Project costs",{"$f":"D51","v":50000},{"$f":"E91+F91+G91","v":32192},{"$f":"H91","v":0},{"$f":"I91","v":0},{"$f":"J91","v":0},{"$f":"K91","v":0},{"$f":"L91","v":0},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"YEAR 3",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,"ARC","Administering Organisation",null,"Key Industry Partner",null,"Other Industry Partners",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,"Cash","Cash","In-kind","Cash","In-kind","Cash","In-kind",null,1]
[null,"Travel",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Personnel",{"$f":"D97","v":112897},{"$f":"F100+G100","v":0},"-",{"$f":"I100","v":0},"-",{"$f":"K100","v":0},"-",null,1]
[null,"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Project costs",{"$f":"D98","v":50000},{"$f":"E91+F91+G91","v":32192},{"$f":"H138","v":0},{"$f":"I138","v":0},{"$f":"J138","v":0},{"$f":"K138","v":0},{"$f":"L138","v":0},null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"NAVIGATION:",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 1",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 2",null,null,null,null,null,null,null,null,1]
[null,"Field Research",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 3",null,null,null,null,null,null,null,null,1]
[null,"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Equipment ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project expenses",null,null,{"$f":"SUM(D7:D42)","v":0},{"$f":"SUM(E6:E42)","v":32192},0,0,0,0,0,0,0,{"$f":"SUM(M8:M42)","v":32192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project contributions",null,null,{"$f":"D4","v":50000},32192,0,0,0,0,0,0,0,{"$f":"SUM(D44:L44)-SUM(E6:L6)","v":82192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Project Budget check  (red highlight - deficit;\n yellow highlight - contributions and expenses do not match) ",null,null,{"$f":"D44-D43","v":50000},{"$f":"E44-E43","v":0},0,0,0,0,0,0,0,{"$f":"M44-M43","v":50000},0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Year 2",null,null,null,"UQ Contributions",null,null,null,"Key Industry Partner",null,"Other Industry Partners",null,"Total (red highlight - salary gap; yellow highlight - overspend) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"Australian Research Council","UQ Graduate School Stipend (cash)","UQ Central Support (cash)","UQ Local Sources (cash)","In-kind","Cash","In-kind","Cash","In-kind",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Year 2",null,"Fellow salary",112897,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Project costs",50000,{"$f":"_xlfn.XLOOKUP($C$5,List!$B$3:$B$5,List!$C$3:$C$5,0)","v":32192},null,null,null,null,null,null,null,null,32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fellow salary",0,0,0,"Salary Gap",null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"B6","v":"Fellow [INSER YOUR NAME]"},"D03",{"$f":"D50","v":112897},null,null,null,null,null,null,null,null,{"$f":"D53+G53+I53+K53","v":112897},{"$f":"ROUNDUP(_xlfn.XLOOKUP(C53,'Salary Gap Calculations'!C7:C25,'Salary Gap Calculations'!D7:D25, \"Check Salary Code\"),0)","v":229821},0,0,{"$f":"M53-N53","v":-116924},null,null,null,null,null,null,null,null,null,null,1]
[null,"Personnel Other",null,null,null,null,null,null,null,null,null,null,"Project costs",0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"_xlfn.XLOOKUP(E51,List!$C$3:$C$5,List!$D$3:$D$5)","v":"Earmarked PhD Stipend"},null,null,{"$f":"_xlfn.XLOOKUP(B55,List!$D$3:$D$5,List!$C$3:$C$5,\"0\")","v":32192},null,null,null,null,null,null,null,{"$f":"SUM(D55:L55)","v":32192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:L56)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"NAVIGATION:",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 1",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 2",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 3",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Travel",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Field Research",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"E73+F73+G73","v":0},{"$f":"I73+K73","v":0},{"$f":"J73+L73","v":0},null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Equipment ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,1,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,2,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,3,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project expenses",null,null,{"$f":"SUM(D54:D89)","v":0},{"$f":"SUM(E53:E89)","v":32192},0,0,0,0,0,0,0,{"$f":"SUM(M55:M89)","v":32192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project contributions",null,null,{"$f":"D51","v":50000},32192,0,0,0,0,0,0,0,{"$f":"SUM(D91:L91)-SUM(E53:L53)","v":82192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Project Budget check  (red highlight - deficit;\n yellow highlight - contributions and expenses do not match) ",null,null,{"$f":"D91-D90","v":50000},{"$f":"E91-E90","v":0},{"$f":"F91-F90","v":0},{"$f":"G91-G90","v":0},{"$f":"H91-H90","v":0},{"$f":"I91-I90","v":0},{"$f":"J91-J90","v":0},{"$f":"K91-K90","v":0},{"$f":"L91-L90","v":0},{"$f":"M91-M90","v":50000},0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Year 3",null,null,null,"UQ Contributions",null,null,null,"Key Industry Partner",null,"Other Industry Partners",null,"Total (red highlight - salary gap; yellow highlight - overspend) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"Australian Research Council","UQ Graduate School Stipend (cash)","UQ Central Support (cash)","UQ Local Sources (cash)","In-kind","Cash","In-kind","Cash","In-kind",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Year 3",null,"Fellow salary",112897,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Project costs",50000,{"$f":"_xlfn.XLOOKUP($C$5,List!$B$3:$B$5,List!$C$3:$C$5,0)","v":32192},null,null,null,null,null,null,null,null,32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fellow salary",0,0,0,"Salary Gap",null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"B6","v":"Fellow [INSER YOUR NAME]"},"D04",{"$f":"D97","v":112897},null,null,null,null,null,null,null,null,{"$f":"D100+G100+I100+K100","v":112897},{"$f":"_xlfn.XLOOKUP(C100,'Salary Gap Calculations'!C7:C25,'Salary Gap Calculations'!D7:D25, \"Check Salary Code\")","v":237116.33889346011},0,0,{"$f":"M100-N100","v":-124219.33889346011},null,null,null,null,null,null,null,null,null,null,1]
[null,"Personnel Other",null,null,null,null,null,null,null,null,null,null,"Project costs",0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"_xlfn.XLOOKUP(E98,List!$C$3:$C$5,List!$D$3:$D$5)","v":"Earmarked PhD Stipend"},null,null,{"$f":"_xlfn.XLOOKUP(B102,List!$D$3:$D$5,List!$C$3:$C$5,\"0\")","v":32192},null,null,null,null,null,null,null,{"$f":"SUM(D102:L102)","v":32192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D103:L103)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"NAVIGATION:",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 1",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 2",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,"Year 3",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Travel",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Field Research",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Equipment ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Maintenance",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Other ",null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project expenses",null,null,{"$f":"SUM(D101:D136)","v":0},{"$f":"SUM(E100:E136)","v":32192},{"$f":"SUM(F100:F136)","v":0},{"$f":"SUM(G100:G136)","v":0},{"$f":"SUM(H100:H136)","v":0},{"$f":"SUM(I100:I136)","v":0},{"$f":"SUM(J100:J136)","v":0},{"$f":"SUM(K100:K136)","v":0},{"$f":"SUM(L100:L136)","v":0},{"$f":"SUM(M102:M136)","v":32192},{"$f":"E137+F137+G137","v":32192},{"$f":"I137+K137","v":0},{"$f":"J137+L137","v":0},null,null,null,null,null,null,null,null,null,null,null,1]
["Total Project contributions",null,null,{"$f":"D98","v":50000},32192,0,0,0,0,0,0,0,{"$f":"SUM(D138:L138)-SUM(E100:L100)","v":82192},32192,0,0,null,null,null,null,null,null,null,null,null,null,null,1]
["Project Budget check  (red highlight - deficit;\n yellow highlight - contributions and expenses do not match) ",null,null,{"$f":"D138-D137","v":50000},{"$f":"E138-E137","v":0},{"$f":"F138-F137","v":0},{"$f":"G138-G137","v":0},{"$f":"H138-H137","v":0},{"$f":"I138-I137","v":0},{"$f":"J138-J137","v":0},{"$f":"K138-K137","v":0},{"$f":"L138-L137","v":0},{"$f":"M138-M137","v":50000},0,0,0,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"F2_ARC Contributions","index":3,"n_rows":139,"n_cols":5,"rows_kept":139,"cut":false,"hidden":false,"merged":[[0,0,1,2],[46,0,47,2],[93,0,94,2]]}
["Year 1"]
[]
["Description","Cost ","Justification ",null,"CLICK CTRL+SHIFT+H TO RUN MACROS BEFORE EXPORTING"]
[{"$f":"'IE24 BUDGET tool'!B6","v":"Fellow [INSER YOUR NAME]"},{"$f":"'IE24 BUDGET tool'!D3","v":112897}]
["Personnel Other","Total:",{"$f":"SUM(B6:B13)","v":1E-3}]
[{"$f":"'IE24 BUDGET tool'!B8","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!D8","v":0},"Justification should explain both the cost and the need for the project. "]
[{"$f":"'IE24 BUDGET tool'!B9","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D9","v":0},"Justification should explain both the cost and the need for the project. ",null,"NAVIGATION:"]
[{"$f":"'IE24 BUDGET tool'!B10","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D10","v":0},null,null,"Year 1"]
[{"$f":"'IE24 BUDGET tool'!B11","v":0},{"$f":"'IE24 BUDGET tool'!D11","v":0},null,null,"Year 2"]
[{"$f":"'IE24 BUDGET tool'!B12","v":0},{"$f":"'IE24 BUDGET tool'!D12","v":0},null,null,"Year 3"]
[{"$f":"'IE24 BUDGET tool'!B13","v":0},{"$f":"'IE24 BUDGET tool'!D13","v":0}]
[{"$f":"'IE24 BUDGET tool'!B14","v":0},{"$f":"'IE24 BUDGET tool'!D14","v":0}]
["N/A",1E-3]
["Travel","Total:",{"$f":"B15+B16+B17+B18+B19","v":0}]
[{"$f":"'IE24 BUDGET tool'!B17","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!D17","v":0}]
[{"$f":"'IE24 BUDGET tool'!B18","v":0},{"$f":"'IE24 BUDGET tool'!D18","v":0}]
[{"$f":"'IE24 BUDGET tool'!B19","v":0},{"$f":"'IE24 BUDGET tool'!D19","v":0}]
[{"$f":"'IE24 BUDGET tool'!B20","v":0},{"$f":"'IE24 BUDGET tool'!D20","v":0}]
[{"$f":"'IE24 BUDGET tool'!B21","v":0},{"$f":"'IE24 BUDGET tool'!D21","v":0}]
["N/A",1E-3]
["Field Research","Total:",{"$f":"B22+B23+B24+B25+B26","v":0}]
[{"$f":"'IE24 BUDGET tool'!B23","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!D23","v":0}]
[{"$f":"'IE24 BUDGET tool'!B24","v":0},{"$f":"'IE24 BUDGET tool'!D24","v":0}]
[{"$f":"'IE24 BUDGET tool'!B25","v":0},{"$f":"'IE24 BUDGET tool'!D25","v":0}]
[{"$f":"'IE24 BUDGET tool'!B26","v":0},{"$f":"'IE24 BUDGET tool'!D26","v":0}]
[{"$f":"'IE24 BUDGET tool'!B27","v":0},{"$f":"'IE24 BUDGET tool'!D27","v":0}]
["N/A",1E-3]
["Equipment ","Total:",{"$f":"B29+B30+B31+B32","v":0}]
[{"$f":"'IE24 BUDGET tool'!B29","v":0},{"$f":"'IE24 BUDGET tool'!D29","v":0}]
[{"$f":"'IE24 BUDGET tool'!B30","v":0},{"$f":"'IE24 BUDGET tool'!D30","v":0}]
[{"$f":"'IE24 BUDGET tool'!B31","v":0},{"$f":"'IE24 BUDGET tool'!D31","v":0}]
[{"$f":"'IE24 BUDGET tool'!B32","v":0},{"$f":"'IE24 BUDGET tool'!D32","v":0}]
["N/A",1E-3]
["Maintenance","Total:",{"$f":"B35+B36+B37+B38","v":0}]
[{"$f":"'IE24 BUDGET tool'!B34","v":0},{"$f":"'IE24 BUDGET tool'!D34","v":0}]
[{"$f":"'IE24 BUDGET tool'!B35","v":0},{"$f":"'IE24 BUDGET tool'!D35","v":0}]
[{"$f":"'IE24 BUDGET tool'!B36","v":0},{"$f":"'IE24 BUDGET tool'!D36","v":0}]
[{"$f":"'IE24 BUDGET tool'!B37","v":0},{"$f":"'IE24 BUDGET tool'!D37","v":0}]
["N/A",1E-3]
["Other ","Total:",{"$f":"B41+B42+B43+B44","v":0}]
[{"$f":"'IE24 BUDGET tool'!B39","v":0},{"$f":"'IE24 BUDGET tool'!D39","v":0}]
[{"$f":"'IE24 BUDGET tool'!B40","v":0},{"$f":"'IE24 BUDGET tool'!D40","v":0}]
[{"$f":"'IE24 BUDGET tool'!B41","v":0},{"$f":"'IE24 BUDGET tool'!D41","v":0}]
[{"$f":"'IE24 BUDGET tool'!B42","v":0},{"$f":"'IE24 BUDGET tool'!D42","v":0}]
["N/A",1E-3]
[]
["Year 2"]
[]
["Description","Cost ","Justification"]
[{"$f":"A4","v":"Fellow [INSER YOUR NAME]"},{"$f":"'IE24 BUDGET tool'!D53","v":112897}]
["Personnel Other","Total:",{"$f":"B52+B53+B54+B55+B56+B57+B58+B59","v":0}]
[{"$f":"'IE24 BUDGET tool'!B56","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D55","v":0}]
[{"$f":"'IE24 BUDGET tool'!B57","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D56","v":0},null,null,"NAVIGATION:"]
[{"$f":"'IE24 BUDGET tool'!#REF!","v":{"$error":"#REF!"}},{"$f":"'IE24 BUDGET tool'!D57","v":0},null,null,"Year 1"]
[{"$f":"'IE24 BUDGET tool'!B58","v":0},{"$f":"'IE24 BUDGET tool'!D58","v":0},null,null,"Year 2"]
[{"$f":"'IE24 BUDGET tool'!B59","v":0},{"$f":"'IE24 BUDGET tool'!D59","v":0},null,null,"Year 3"]
[{"$f":"'IE24 BUDGET tool'!B60","v":0},{"$f":"'IE24 BUDGET tool'!D60","v":0}]
[{"$f":"'IE24 BUDGET tool'!B61","v":0},{"$f":"'IE24 BUDGET tool'!D61","v":0}]
[{"$f":"'IE24 BUDGET tool'!B55","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!D62","v":0}]
["N/A",1E-3]
["Travel","Total:",{"$f":"B62+B63+B64+B65+B66","v":0}]
[{"$f":"'IE24 BUDGET tool'!B64","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!D64","v":0}]
[{"$f":"'IE24 BUDGET tool'!B65","v":0},{"$f":"'IE24 BUDGET tool'!D65","v":0}]
[{"$f":"'IE24 BUDGET tool'!B66","v":0},{"$f":"'IE24 BUDGET tool'!D66","v":0}]
[{"$f":"'IE24 BUDGET tool'!B67","v":0},{"$f":"'IE24 BUDGET tool'!D67","v":0}]
[{"$f":"'IE24 BUDGET tool'!B68","v":0},{"$f":"'IE24 BUDGET tool'!D68","v":0}]
["N/A",1E-3]
["Field Research","Total:",{"$f":"B69+B70+B71+B72+B73","v":0}]
[{"$f":"'IE24 BUDGET tool'!B70","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!D70","v":0}]
[{"$f":"'IE24 BUDGET tool'!B71","v":0},{"$f":"'IE24 BUDGET tool'!D71","v":0}]
[{"$f":"'IE24 BUDGET tool'!B72","v":0},{"$f":"'IE24 BUDGET tool'!D72","v":0}]
[{"$f":"'IE24 BUDGET tool'!B73","v":0},{"$f":"'IE24 BUDGET tool'!D73","v":0}]
[{"$f":"'IE24 BUDGET tool'!B74","v":0},{"$f":"'IE24 BUDGET tool'!D74","v":0}]
["N/A",1E-3]
["Equipment ","Total:",{"$f":"B76+B77+B78+B79","v":0}]
[{"$f":"'IE24 BUDGET tool'!B76","v":0},{"$f":"'IE24 BUDGET tool'!D76","v":0}]
[{"$f":"'IE24 BUDGET tool'!B77","v":0},{"$f":"'IE24 BUDGET tool'!D77","v":0}]
[{"$f":"'IE24 BUDGET tool'!B78","v":0},{"$f":"'IE24 BUDGET tool'!D78","v":0}]
[{"$f":"'IE24 BUDGET tool'!B79","v":0},{"$f":"'IE24 BUDGET tool'!D79","v":0}]
["N/A",1E-3]
["Maintenance","Total:",{"$f":"B82+B83+B84+B85","v":0}]
[{"$f":"'IE24 BUDGET tool'!B81","v":0},{"$f":"'IE24 BUDGET tool'!D81","v":0}]
[{"$f":"'IE24 BUDGET tool'!B82","v":0},{"$f":"'IE24 BUDGET tool'!D82","v":0}]
[{"$f":"'IE24 BUDGET tool'!B83","v":0},{"$f":"'IE24 BUDGET tool'!D83","v":0}]
[{"$f":"'IE24 BUDGET tool'!B84","v":0},{"$f":"'IE24 BUDGET tool'!D84","v":0}]
["N/A",1E-3]
["Other ","Total:",{"$f":"B88+B89+B90+B91","v":0}]
[{"$f":"'IE24 BUDGET tool'!B86","v":1},{"$f":"'IE24 BUDGET tool'!D86","v":0}]
[{"$f":"'IE24 BUDGET tool'!B87","v":2},{"$f":"'IE24 BUDGET tool'!D87","v":0}]
[{"$f":"'IE24 BUDGET tool'!B88","v":3},{"$f":"'IE24 BUDGET tool'!D88","v":0}]
[{"$f":"'IE24 BUDGET tool'!B89","v":0},{"$f":"'IE24 BUDGET tool'!D89","v":0}]
["N/A",1E-3]
[]
["Year 3"]
[]
["Description","Cost ","Justification"]
[{"$f":"A4","v":"Fellow [INSER YOUR NAME]"},{"$f":"'IE24 BUDGET tool'!D100","v":112897}]
["Personnel Other","Total:",{"$f":"B99+B100+B101+B102+B103+B104+B105+B106","v":0}]
[{"$f":"'IE24 BUDGET tool'!B103","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D102","v":0}]
[{"$f":"'IE24 BUDGET tool'!B104","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!D103","v":0},null,null,"NAVIGATION:"]
[{"$f":"'IE24 BUDGET tool'!#REF!","v":{"$error":"#REF!"}},{"$f":"'IE24 BUDGET tool'!D104","v":0},null,null,"Year 1"]
[{"$f":"'IE24 BUDGET tool'!B105","v":0},{"$f":"'IE24 BUDGET tool'!D105","v":0},null,null,"Year 2"]
[{"$f":"'IE24 BUDGET tool'!B106","v":0},{"$f":"'IE24 BUDGET tool'!D106","v":0},null,null,"Year 3"]
[{"$f":"'IE24 BUDGET tool'!B107","v":0},{"$f":"'IE24 BUDGET tool'!D107","v":0}]
[{"$f":"'IE24 BUDGET tool'!B108","v":0},{"$f":"'IE24 BUDGET tool'!D108","v":0}]
[{"$f":"'IE24 BUDGET tool'!B102","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!D109","v":0}]
["N/A",1E-3]
["Travel","Total:",{"$f":"B109+B110+B111+B112+B113","v":0}]
[{"$f":"'IE24 BUDGET tool'!B111","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!D111","v":0}]
[{"$f":"'IE24 BUDGET tool'!B112","v":0},{"$f":"'IE24 BUDGET tool'!D112","v":0}]
[{"$f":"'IE24 BUDGET tool'!B113","v":0},{"$f":"'IE24 BUDGET tool'!D113","v":0}]
[{"$f":"'IE24 BUDGET tool'!B114","v":0},{"$f":"'IE24 BUDGET tool'!D114","v":0}]
[{"$f":"'IE24 BUDGET tool'!B115","v":0},{"$f":"'IE24 BUDGET tool'!D115","v":0}]
["N/A",1E-3]
["Field Research","Total:",{"$f":"B116+B117+B118+B119+B120","v":0}]
[{"$f":"'IE24 BUDGET tool'!B117","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!D117","v":0}]
[{"$f":"'IE24 BUDGET tool'!B118","v":0},{"$f":"'IE24 BUDGET tool'!D118","v":0}]
[{"$f":"'IE24 BUDGET tool'!B119","v":0},{"$f":"'IE24 BUDGET tool'!D119","v":0}]
[{"$f":"'IE24 BUDGET tool'!B120","v":0},{"$f":"'IE24 BUDGET tool'!D120","v":0}]
[{"$f":"'IE24 BUDGET tool'!B121","v":0},{"$f":"'IE24 BUDGET tool'!D121","v":0}]
["N/A",1E-3]
["Equipment ","Total:",{"$f":"B123+B124+B125+B126","v":0}]
[{"$f":"'IE24 BUDGET tool'!B123","v":0},{"$f":"'IE24 BUDGET tool'!D123","v":0}]
[{"$f":"'IE24 BUDGET tool'!B124","v":0},{"$f":"'IE24 BUDGET tool'!D124","v":0}]
[{"$f":"'IE24 BUDGET tool'!B125","v":0},{"$f":"'IE24 BUDGET tool'!D125","v":0}]
[{"$f":"'IE24 BUDGET tool'!B126","v":0},{"$f":"'IE24 BUDGET tool'!D126","v":0}]
["N/A",1E-3]
["Maintenance","Total:",{"$f":"B129+B130+B131+B132","v":0}]
[{"$f":"'IE24 BUDGET tool'!B128","v":0},{"$f":"'IE24 BUDGET tool'!D128","v":0}]
[{"$f":"'IE24 BUDGET tool'!B129","v":0},{"$f":"'IE24 BUDGET tool'!D129","v":0}]
[{"$f":"'IE24 BUDGET tool'!B130","v":0},{"$f":"'IE24 BUDGET tool'!D130","v":0}]
[{"$f":"'IE24 BUDGET tool'!B131","v":0},{"$f":"'IE24 BUDGET tool'!D131","v":0}]
["N/A",1E-3]
["Other ","Total:",{"$f":"B135+B136+B137+B138","v":0}]
[{"$f":"'IE24 BUDGET tool'!B133","v":0},{"$f":"'IE24 BUDGET tool'!D133","v":0}]
[{"$f":"'IE24 BUDGET tool'!B134","v":0},{"$f":"'IE24 BUDGET tool'!D134","v":0}]
[{"$f":"'IE24 BUDGET tool'!B135","v":0},{"$f":"'IE24 BUDGET tool'!D135","v":0}]
[{"$f":"'IE24 BUDGET tool'!B136","v":0},{"$f":"'IE24 BUDGET tool'!D136","v":0}]
["N/A",1E-3]

{"sheet":"F3_Non-ARC Contributions","index":4,"n_rows":326,"n_cols":5,"rows_kept":326,"cut":false,"hidden":false,"merged":[[0,0,1,2],[109,0,110,2],[218,0,219,2]]}
["Year 1"]
[]
["Description","Cost ","Justification ",null,"CLICK CTRL+SHIFT+H TO RUN THE ALGORITHM BEFORE EXPORTING"]
[{"$f":"'IE24 BUDGET tool'!B6","v":"Fellow [INSER YOUR NAME]"}]
["UQ",{"$f":"'IE24 BUDGET tool'!F6+'IE24 BUDGET tool'!G6","v":0}]
["Industry Partner",{"$f":"'IE24 BUDGET tool'!I6+'IE24 BUDGET tool'!K6","v":0}]
["Personnel Other"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B10:B13)","v":32192},null,"NAVIGATION:"]
[{"$f":"'IE24 BUDGET tool'!B8","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!N8","v":32192},null,null,"Year 1"]
[{"$f":"'IE24 BUDGET tool'!B9","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N9","v":0},null,null,"Year 2"]
[{"$f":"'IE24 BUDGET tool'!B10","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N10","v":0},null,null,"Year 3"]
[{"$f":"'IE24 BUDGET tool'!B11","v":0},{"$f":"'IE24 BUDGET tool'!N11","v":0}]
["N/A",1E-3]
["In-kind","Total:",{"$f":"SUM(B16:B21)","v":1E-3}]
[{"$f":"'IE24 BUDGET tool'!B8","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!H8","v":0}]
[{"$f":"'IE24 BUDGET tool'!B9","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H9","v":0}]
[{"$f":"'IE24 BUDGET tool'!B10","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H10","v":0}]
[{"$f":"'IE24 BUDGET tool'!B11","v":0},{"$f":"'IE24 BUDGET tool'!H11","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B23:B26)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B8","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!O8","v":0}]
[{"$f":"'IE24 BUDGET tool'!B9","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O9","v":0}]
[{"$f":"'IE24 BUDGET tool'!B10","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O10","v":0}]
[{"$f":"'IE24 BUDGET tool'!B11","v":0},{"$f":"'IE24 BUDGET tool'!O11","v":0}]
[{"$f":"'IE24 BUDGET tool'!B12","v":0},1E-3]
["In-kind","Total:",{"$f":"SUM(B29:B32)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B8","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!P8","v":0}]
[{"$f":"'IE24 BUDGET tool'!B9","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P9","v":0}]
[{"$f":"'IE24 BUDGET tool'!B10","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P10","v":0}]
[{"$f":"'IE24 BUDGET tool'!B11","v":0},{"$f":"'IE24 BUDGET tool'!P11","v":0}]
["N/A",1E-3]
["Travel"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B37:B40)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B17","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!N17","v":0}]
[{"$f":"'IE24 BUDGET tool'!B18","v":0},{"$f":"'IE24 BUDGET tool'!N18","v":0}]
[{"$f":"'IE24 BUDGET tool'!B19","v":0},{"$f":"'IE24 BUDGET tool'!N19","v":0}]
[{"$f":"'IE24 BUDGET tool'!B20","v":0},{"$f":"'IE24 BUDGET tool'!N20","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B44:B47)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B17","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!O17","v":0}]
[{"$f":"'IE24 BUDGET tool'!B18","v":0},{"$f":"'IE24 BUDGET tool'!O18","v":0}]
[{"$f":"'IE24 BUDGET tool'!B19","v":0},{"$f":"'IE24 BUDGET tool'!O19","v":0}]
[{"$f":"'IE24 BUDGET tool'!B20","v":0},{"$f":"'IE24 BUDGET tool'!O20","v":0}]
["N/A",1E-3]
["Field Research"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B52:B55)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B23","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!N23","v":0}]
[{"$f":"'IE24 BUDGET tool'!B24","v":0},{"$f":"'IE24 BUDGET tool'!N24","v":0}]
[{"$f":"'IE24 BUDGET tool'!B25","v":0},{"$f":"'IE24 BUDGET tool'!N25","v":0}]
[{"$f":"'IE24 BUDGET tool'!B26","v":0},{"$f":"'IE24 BUDGET tool'!N26","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B59:B62)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B23","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!O23","v":0}]
[{"$f":"'IE24 BUDGET tool'!B24","v":0},{"$f":"'IE24 BUDGET tool'!O24","v":0}]
[{"$f":"'IE24 BUDGET tool'!B25","v":0},{"$f":"'IE24 BUDGET tool'!O25","v":0}]
[{"$f":"'IE24 BUDGET tool'!B26","v":0},{"$f":"'IE24 BUDGET tool'!O26","v":0}]
["N/A",1E-3]
["Equipment "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B67:B70)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B29","v":0},{"$f":"'IE24 BUDGET tool'!N29","v":0}]
[{"$f":"'IE24 BUDGET tool'!B30","v":0},{"$f":"'IE24 BUDGET tool'!N30","v":0}]
[{"$f":"'IE24 BUDGET tool'!B31","v":0},{"$f":"'IE24 BUDGET tool'!N31","v":0}]
[{"$f":"'IE24 BUDGET tool'!B32","v":0},{"$f":"'IE24 BUDGET tool'!N32","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B74:B77)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B29","v":0},{"$f":"'IE24 BUDGET tool'!O29","v":0}]
[{"$f":"'IE24 BUDGET tool'!B30","v":0},{"$f":"'IE24 BUDGET tool'!O30","v":0}]
[{"$f":"'IE24 BUDGET tool'!B31","v":0},{"$f":"'IE24 BUDGET tool'!O31","v":0}]
[{"$f":"'IE24 BUDGET tool'!B32","v":0},{"$f":"'IE24 BUDGET tool'!O32","v":0}]
["N/A",1E-3]
["Maintenance"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B82:B85)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B34","v":0},{"$f":"'IE24 BUDGET tool'!N34","v":0}]
[{"$f":"'IE24 BUDGET tool'!B35","v":0},{"$f":"'IE24 BUDGET tool'!N35","v":0}]
[{"$f":"'IE24 BUDGET tool'!B36","v":0},{"$f":"'IE24 BUDGET tool'!N36","v":0}]
[{"$f":"'IE24 BUDGET tool'!B37","v":0},{"$f":"'IE24 BUDGET tool'!N37","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B89:B92)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B34","v":0},{"$f":"'IE24 BUDGET tool'!O34","v":0}]
[{"$f":"'IE24 BUDGET tool'!B35","v":0},{"$f":"'IE24 BUDGET tool'!O35","v":0}]
[{"$f":"'IE24 BUDGET tool'!B36","v":0},{"$f":"'IE24 BUDGET tool'!O36","v":0}]
[{"$f":"'IE24 BUDGET tool'!B37","v":0},{"$f":"'IE24 BUDGET tool'!O37","v":0}]
["N/A",1E-3]
["Other "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B97:B100)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B39","v":0},{"$f":"'IE24 BUDGET tool'!N39","v":0}]
[{"$f":"'IE24 BUDGET tool'!B40","v":0},{"$f":"'IE24 BUDGET tool'!N40","v":0}]
[{"$f":"'IE24 BUDGET tool'!B41","v":0},{"$f":"'IE24 BUDGET tool'!N41","v":0}]
[{"$f":"'IE24 BUDGET tool'!B42","v":0},{"$f":"'IE24 BUDGET tool'!N42","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B104:B107)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B39","v":0},{"$f":"'IE24 BUDGET tool'!O39","v":0}]
[{"$f":"'IE24 BUDGET tool'!B40","v":0},{"$f":"'IE24 BUDGET tool'!O40","v":0}]
[{"$f":"'IE24 BUDGET tool'!B41","v":0},{"$f":"'IE24 BUDGET tool'!O41","v":0}]
[{"$f":"'IE24 BUDGET tool'!B42","v":0},{"$f":"'IE24 BUDGET tool'!O42","v":0}]
["N/A",1E-3]
[]
["Year 2"]
[null,null,null,null,"NAVIGATION:"]
["Description","Cost ","Justification ",null,"Year 1"]
[{"$f":"A4","v":"Fellow [INSER YOUR NAME]"},null,null,null,"Year 2"]
["UQ",{"$f":"'IE24 BUDGET tool'!F53+'IE24 BUDGET tool'!G53","v":0},null,null,"Year 3"]
["Industry Partner",{"$f":"'IE24 BUDGET tool'!I53+'IE24 BUDGET tool'!K53","v":0}]
["Personnel Other"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B119:B122)","v":32192}]
[{"$f":"'IE24 BUDGET tool'!B55","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!N55","v":32192}]
[{"$f":"'IE24 BUDGET tool'!B56","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N56","v":0}]
[{"$f":"'IE24 BUDGET tool'!B57","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N57","v":0}]
[{"$f":"'IE24 BUDGET tool'!B58","v":0},{"$f":"'IE24 BUDGET tool'!N58","v":0}]
["N/A",1E-3]
["In-kind","Total:",{"$f":"SUM(B125:B130)","v":1E-3}]
[{"$f":"'IE24 BUDGET tool'!B55","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!H55","v":0}]
[{"$f":"'IE24 BUDGET tool'!B56","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H56","v":0}]
[{"$f":"'IE24 BUDGET tool'!B57","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H57","v":0}]
[{"$f":"'IE24 BUDGET tool'!B58","v":0},{"$f":"'IE24 BUDGET tool'!H58","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B132:B135)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B55","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!O55","v":0}]
[{"$f":"'IE24 BUDGET tool'!B56","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O56","v":0}]
[{"$f":"'IE24 BUDGET tool'!B57","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O57","v":0}]
[{"$f":"'IE24 BUDGET tool'!B58","v":0},{"$f":"'IE24 BUDGET tool'!O58","v":0}]
["N/A",1E-3]
["In-kind","Total:",{"$f":"SUM(B138:B141)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B55","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!P55","v":0}]
[{"$f":"'IE24 BUDGET tool'!B56","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P56","v":0}]
[{"$f":"'IE24 BUDGET tool'!B57","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P57","v":0}]
[{"$f":"'IE24 BUDGET tool'!B58","v":0},{"$f":"'IE24 BUDGET tool'!P58","v":0}]
["N/A",1E-3]
["Travel"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B146:B149)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B64","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!N64","v":0}]
[{"$f":"'IE24 BUDGET tool'!B65","v":0},{"$f":"'IE24 BUDGET tool'!N65","v":0}]
[{"$f":"'IE24 BUDGET tool'!B66","v":0},{"$f":"'IE24 BUDGET tool'!N66","v":0}]
[{"$f":"'IE24 BUDGET tool'!B67","v":0},{"$f":"'IE24 BUDGET tool'!N67","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B153:B156)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B64","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!O64","v":0}]
[{"$f":"'IE24 BUDGET tool'!B65","v":0},{"$f":"'IE24 BUDGET tool'!O65","v":0}]
[{"$f":"'IE24 BUDGET tool'!B66","v":0},{"$f":"'IE24 BUDGET tool'!O66","v":0}]
[{"$f":"'IE24 BUDGET tool'!B67","v":0},{"$f":"'IE24 BUDGET tool'!O67","v":0}]
["N/A",1E-3]
["Field Research"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B161:B164)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B70","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!N70","v":0}]
[{"$f":"'IE24 BUDGET tool'!B71","v":0},{"$f":"'IE24 BUDGET tool'!N71","v":0}]
[{"$f":"'IE24 BUDGET tool'!B72","v":0},{"$f":"'IE24 BUDGET tool'!N72","v":0}]
[{"$f":"'IE24 BUDGET tool'!B73","v":0},{"$f":"'IE24 BUDGET tool'!N73","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B168:B171)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B70","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!O70","v":0}]
[{"$f":"'IE24 BUDGET tool'!B71","v":0},{"$f":"'IE24 BUDGET tool'!O71","v":0}]
[{"$f":"'IE24 BUDGET tool'!B72","v":0},{"$f":"'IE24 BUDGET tool'!O72","v":0}]
[{"$f":"'IE24 BUDGET tool'!B73","v":0},{"$f":"'IE24 BUDGET tool'!O73","v":0}]
["N/A",1E-3]
["Equipment "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B176:B179)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B76","v":0},{"$f":"'IE24 BUDGET tool'!N76","v":0}]
[{"$f":"'IE24 BUDGET tool'!B77","v":0},{"$f":"'IE24 BUDGET tool'!N77","v":0}]
[{"$f":"'IE24 BUDGET tool'!B78","v":0},{"$f":"'IE24 BUDGET tool'!N78","v":0}]
[{"$f":"'IE24 BUDGET tool'!B79","v":0},{"$f":"'IE24 BUDGET tool'!N79","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B183:B186)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B76","v":0},{"$f":"'IE24 BUDGET tool'!O76","v":0}]
[{"$f":"'IE24 BUDGET tool'!B77","v":0},{"$f":"'IE24 BUDGET tool'!O77","v":0}]
[{"$f":"'IE24 BUDGET tool'!B78","v":0},{"$f":"'IE24 BUDGET tool'!O78","v":0}]
[{"$f":"'IE24 BUDGET tool'!B79","v":0},{"$f":"'IE24 BUDGET tool'!O79","v":0}]
["N/A",1E-3]
["Maintenance"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B191:B194)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B81","v":0},{"$f":"'IE24 BUDGET tool'!N81","v":0}]
[{"$f":"'IE24 BUDGET tool'!B82","v":0},{"$f":"'IE24 BUDGET tool'!N82","v":0}]
[{"$f":"'IE24 BUDGET tool'!B83","v":0},{"$f":"'IE24 BUDGET tool'!N83","v":0}]
[{"$f":"'IE24 BUDGET tool'!B84","v":0},{"$f":"'IE24 BUDGET tool'!N84","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B198:B201)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B81","v":0},{"$f":"'IE24 BUDGET tool'!O81","v":0}]
[{"$f":"'IE24 BUDGET tool'!B82","v":0},{"$f":"'IE24 BUDGET tool'!O82","v":0}]
[{"$f":"'IE24 BUDGET tool'!B83","v":0},{"$f":"'IE24 BUDGET tool'!O83","v":0}]
[{"$f":"'IE24 BUDGET tool'!B84","v":0},{"$f":"'IE24 BUDGET tool'!O84","v":0}]
["N/A",1E-3]
["Other "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B206:B209)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B86","v":1},{"$f":"'IE24 BUDGET tool'!N86","v":0}]
[{"$f":"'IE24 BUDGET tool'!B87","v":2},{"$f":"'IE24 BUDGET tool'!N87","v":0}]
[{"$f":"'IE24 BUDGET tool'!B88","v":3},{"$f":"'IE24 BUDGET tool'!N88","v":0}]
[{"$f":"'IE24 BUDGET tool'!B89","v":0},{"$f":"'IE24 BUDGET tool'!N89","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B213:B216)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B86","v":1},{"$f":"'IE24 BUDGET tool'!O86","v":0}]
[{"$f":"'IE24 BUDGET tool'!B87","v":2},{"$f":"'IE24 BUDGET tool'!O87","v":0}]
[{"$f":"'IE24 BUDGET tool'!B88","v":3},{"$f":"'IE24 BUDGET tool'!O88","v":0}]
[{"$f":"'IE24 BUDGET tool'!B89","v":0},{"$f":"'IE24 BUDGET tool'!O89","v":0}]
["N/A",1E-3]
[]
["Year 3"]
[null,null,null,null,"NAVIGATION:"]
["Description","Cost ","Justification ",null,"Year 1"]
[{"$f":"A113","v":"Fellow [INSER YOUR NAME]"},null,null,null,"Year 2"]
["UQ",{"$f":"'IE24 BUDGET tool'!F100+'IE24 BUDGET tool'!G100","v":0},null,null,"Year 3"]
["Industry Partner",{"$f":"'IE24 BUDGET tool'!I100+'IE24 BUDGET tool'!K100","v":0}]
["Personnel Other"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B228:B231)","v":32192}]
[{"$f":"'IE24 BUDGET tool'!B102","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!N102","v":32192}]
[{"$f":"'IE24 BUDGET tool'!B103","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N103","v":0}]
[{"$f":"'IE24 BUDGET tool'!B104","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!N104","v":0}]
[{"$f":"'IE24 BUDGET tool'!B105","v":0},{"$f":"'IE24 BUDGET tool'!N105","v":0}]
["N/A",1E-3]
["In-kind","Total:",{"$f":"SUM(B234:B239)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B102","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!H102","v":0}]
[{"$f":"'IE24 BUDGET tool'!B103","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H103","v":0}]
[{"$f":"'IE24 BUDGET tool'!B104","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!H104","v":0}]
[{"$f":"'IE24 BUDGET tool'!B105","v":0},{"$f":"'IE24 BUDGET tool'!H105","v":0}]
["N/A",{"$f":"'IE24 BUDGET tool'!H106","v":0}]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B241:B244)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B102","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!O102","v":0}]
[{"$f":"'IE24 BUDGET tool'!B103","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O103","v":0}]
[{"$f":"'IE24 BUDGET tool'!B104","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!O104","v":0}]
[{"$f":"'IE24 BUDGET tool'!B105","v":0},{"$f":"'IE24 BUDGET tool'!O105","v":0}]
["N/A",1E-3]
["In-kind","Total:",{"$f":"SUM(B247:B250)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B102","v":"Earmarked PhD Stipend"},{"$f":"'IE24 BUDGET tool'!P102","v":0}]
[{"$f":"'IE24 BUDGET tool'!B103","v":"Format: Research Position (eg. Postdoctoal Research Associate), Appointment Level (A-E), FTE, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P103","v":0}]
[{"$f":"'IE24 BUDGET tool'!B104","v":"Format: Professional Staffer (eg. Research Assistant), Appointment Level (HEW), FTE or Hours, incl. 30% Oncosts"},{"$f":"'IE24 BUDGET tool'!P104","v":0}]
[{"$f":"'IE24 BUDGET tool'!B105","v":0},{"$f":"'IE24 BUDGET tool'!P105","v":0}]
["N/A",1E-3]
["Travel"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B255:B258)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B111","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!N111","v":0}]
[{"$f":"'IE24 BUDGET tool'!B112","v":0},{"$f":"'IE24 BUDGET tool'!N112","v":0}]
[{"$f":"'IE24 BUDGET tool'!B113","v":0},{"$f":"'IE24 BUDGET tool'!N113","v":0}]
[{"$f":"'IE24 BUDGET tool'!B114","v":0},{"$f":"'IE24 BUDGET tool'!N114","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B262:B265)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B111","v":"Format: Conference Name and number of people attending if applicable (flights, accom, daily allowance...) number of days"},{"$f":"'IE24 BUDGET tool'!O111","v":0}]
[{"$f":"'IE24 BUDGET tool'!B112","v":0},{"$f":"'IE24 BUDGET tool'!O112","v":0}]
[{"$f":"'IE24 BUDGET tool'!B113","v":0},{"$f":"'IE24 BUDGET tool'!O113","v":0}]
[{"$f":"'IE24 BUDGET tool'!B114","v":0},{"$f":"'IE24 BUDGET tool'!O114","v":0}]
["N/A",1E-3]
["Field Research"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B270:B273)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B117","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!N117","v":0}]
[{"$f":"'IE24 BUDGET tool'!B118","v":0},{"$f":"'IE24 BUDGET tool'!N118","v":0}]
[{"$f":"'IE24 BUDGET tool'!B119","v":0},{"$f":"'IE24 BUDGET tool'!N119","v":0}]
[{"$f":"'IE24 BUDGET tool'!B120","v":0},{"$f":"'IE24 BUDGET tool'!N120","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B277:B280)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B117","v":"Format:  Field work descriptor (eg. site, #days) number of people attending (if applicable)"},{"$f":"'IE24 BUDGET tool'!O117","v":0}]
[{"$f":"'IE24 BUDGET tool'!B118","v":0},{"$f":"'IE24 BUDGET tool'!O118","v":0}]
[{"$f":"'IE24 BUDGET tool'!B119","v":0},{"$f":"'IE24 BUDGET tool'!O119","v":0}]
[{"$f":"'IE24 BUDGET tool'!B120","v":0},{"$f":"'IE24 BUDGET tool'!O120","v":0}]
["N/A",1E-3]
["Equipment "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B285:B288)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B123","v":0},{"$f":"'IE24 BUDGET tool'!N123","v":0}]
[{"$f":"'IE24 BUDGET tool'!B124","v":0},{"$f":"'IE24 BUDGET tool'!N124","v":0}]
[{"$f":"'IE24 BUDGET tool'!B125","v":0},{"$f":"'IE24 BUDGET tool'!N125","v":0}]
[{"$f":"'IE24 BUDGET tool'!B126","v":0},{"$f":"'IE24 BUDGET tool'!N126","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B292:B295)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B123","v":0},{"$f":"'IE24 BUDGET tool'!O123","v":0}]
[{"$f":"'IE24 BUDGET tool'!B124","v":0},{"$f":"'IE24 BUDGET tool'!O124","v":0}]
[{"$f":"'IE24 BUDGET tool'!B125","v":0},{"$f":"'IE24 BUDGET tool'!O125","v":0}]
[{"$f":"'IE24 BUDGET tool'!B126","v":0},{"$f":"'IE24 BUDGET tool'!O126","v":0}]
["N/A",1E-3]
["Maintenance"]
["UQ"]
["Cash","Total:",{"$f":"SUM(B300:B303)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B128","v":0},{"$f":"'IE24 BUDGET tool'!N128","v":0}]
[{"$f":"'IE24 BUDGET tool'!B129","v":0},{"$f":"'IE24 BUDGET tool'!N129","v":0}]
[{"$f":"'IE24 BUDGET tool'!B130","v":0},{"$f":"'IE24 BUDGET tool'!N130","v":0}]
[{"$f":"'IE24 BUDGET tool'!B131","v":0},{"$f":"'IE24 BUDGET tool'!N131","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B307:B310)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B128","v":0},{"$f":"'IE24 BUDGET tool'!O128","v":0}]
[{"$f":"'IE24 BUDGET tool'!B129","v":0},{"$f":"'IE24 BUDGET tool'!O129","v":0}]
[{"$f":"'IE24 BUDGET tool'!B130","v":0},{"$f":"'IE24 BUDGET tool'!O130","v":0}]
[{"$f":"'IE24 BUDGET tool'!B131","v":0},{"$f":"'IE24 BUDGET tool'!O131","v":0}]
["N/A",1E-3]
["Other "]
["UQ"]
["Cash","Total:",{"$f":"SUM(B315:B318)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B133","v":0},{"$f":"'IE24 BUDGET tool'!N133","v":0}]
[{"$f":"'IE24 BUDGET tool'!B134","v":0},{"$f":"'IE24 BUDGET tool'!N134","v":0}]
[{"$f":"'IE24 BUDGET tool'!B135","v":0},{"$f":"'IE24 BUDGET tool'!N135","v":0}]
[{"$f":"'IE24 BUDGET tool'!B136","v":0},{"$f":"'IE24 BUDGET tool'!N136","v":0}]
["N/A",1E-3]
["Industry Partner"]
["Cash","Total:",{"$f":"SUM(B322:B325)","v":0}]
[{"$f":"'IE24 BUDGET tool'!B133","v":0},{"$f":"'IE24 BUDGET tool'!O133","v":0}]
[{"$f":"'IE24 BUDGET tool'!B134","v":0},{"$f":"'IE24 BUDGET tool'!O134","v":0}]
[{"$f":"'IE24 BUDGET tool'!B135","v":0},{"$f":"'IE24 BUDGET tool'!O135","v":0}]
[{"$f":"'IE24 BUDGET tool'!B136","v":0},{"$f":"'IE24 BUDGET tool'!O136","v":0}]
["N/A",1E-3]

{"sheet":"UQ Research Academic Staff","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,2,12,2],[13,2,18,2],[19,3,24,3],[25,3,27,3],[5,1,5,4],[13,1,18,1],[19,1,24,1],[25,1,32,1],[9,1,12,1]]}
[]
[null,null,null,"FTE Fraction",1]
[]
[null,"The University of Queensland - Research Academic Staff Salaries "]
[]
[]
[null,"LEVEL","CLASSIFICATION",null,"Salary\nLevel","Indicative 2024 Fraction FTE, including 30% On-Costs"]
["HDR Stipend","HDR Stipend","HDR Student","$32,192 (2023)","HDR"]
["Academic E1","E","Professorial Res. Fellow (U Qld)\nNHMRC Senior Principal Res. Fellow (NHMRC)",null,"01",{"$f":"VLOOKUP(A9,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":277243.71664162667}]
["Academic D4","D","All the classifications in the following group can be appointed to any level of the adjacent salary range.\n\nPrincipal Res. Fellow (U Qld)\nNHMRC Principal Res. Fellow (NHMRC)",null,"04",{"$f":"VLOOKUP(A10,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":237116.33889346011}]
["Academic D3",null,null,null,"03",{"$f":"VLOOKUP(A11,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":229820.56288294159}]
["Academic D2",null,null,null,"02",{"$f":"VLOOKUP(A12,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":222523.91588625926}]
["Academic D1",null,null,null,"01",{"$f":"VLOOKUP(A13,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":215228.17154796488}]
["Academic C6","C","All the classifications in each of the following groups can be appointed to any level of the corresponding salary range.\n\nSenior Res. Fellow (U Qld)\nNHMRC Senior Res. Fellow (NHMRC)",null,"06",{"$f":"VLOOKUP(A14,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":206108.43965773267}]
["Academic C5",null,null,null,"05",{"$f":"VLOOKUP(A15,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":200637.52218531576}]
["Academic C4",null,null,null,"04",{"$f":"VLOOKUP(A16,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":195166.54136845047}]
["Academic C3",null,null,null,"03",{"$f":"VLOOKUP(A17,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":189692.88424864563}]
["Academic C2",null,null,null,"02",{"$f":"VLOOKUP(A18,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":184221.95094011666}]
["Academic C1",null,null,null,"01",{"$f":"VLOOKUP(A19,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":178749.25982314802}]
["Academic B6","B","All the classifications in each of the following groups can be appointed to any level of the corresponding salary range.","ARC SENIOR RESEARCH ASSOCIATE","06",{"$f":"VLOOKUP(A20,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":173277.47136456729}]
["Academic B5",null,"Res. Fellow (U Qld)",null,"05",{"$f":"VLOOKUP(A21,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":167805.52454486594}]
["Academic B4",null,"Senior Res. Officer Grade 1 (U Qld)",null,"04",{"$f":"VLOOKUP(A22,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":162333.76775850938}]
["Academic B3",null,"NHMRC Res. Fellow (NHMRC)",null,"03",{"$f":"VLOOKUP(A23,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":156861.91595548036}]
["Academic B2",null,"NHMRC Senior Res. Officer (NHMRC)",null,"02",{"$f":"VLOOKUP(A24,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":151390.03248022724}]
["Academic B1",null,null,null,"01",{"$f":"VLOOKUP(A25,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":145918.27569387064}]
["Academic A8","A","All the classifications in each of the following groups can be appointed to any level of the corresponding salary range.","ARC RESEARCH ASSOCIATE","08",{"$f":"VLOOKUP(A26,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":138728.27611738606}]
["Academic A7",null,"Res. Officer (U Qld)",null,"07",{"$f":"VLOOKUP(A27,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":134165.78737551515}]
["Academic A6",null,"NHMRC Research Assistant ",null,"06**",{"$f":"VLOOKUP(A28,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":129601.79421975749}]
["Academic A5",null,"Postdoctoral Research Fellows ",null,"05",{"$f":"VLOOKUP(A29,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":125040.45214781891}]
["Academic A4",null,"** Entry level for PhD holders",null,"04",{"$f":"VLOOKUP(A30,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":120477.34268666766}]
["Academic A3",null,null,null,"03",{"$f":"VLOOKUP(A31,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":114860.80831026292}]
["Academic A2",null,null,null,"02",{"$f":"VLOOKUP(A32,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":109245.99561472924}]
["Academic A1",null,null,null,"01",{"$f":"VLOOKUP(A33,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$E$2","v":103681.66016455615}]

{"sheet":"UQ Professional Staff","index":6,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,5,7,6]]}
[]
[null,null,null,null,null,"FTE Fraction (rate per annum); OR",1]
[null,null,null,null,null,"Number of Hours (casual)",1]
[]
[]
[null,null,null,"The University of Queensland - Professional Staff Salaries"]
[]
[null,null,null,null,null,"Indicative 2024 Fraction FTE Including 30% On-Costs"]
[null,null,null,"HEW Level","Salary Point","Rate per Annum, including 30% On-Costs","Total Cost of Casual by Number of Hours"]
["HEW 1 1",null,null,"Level 1","01",{"$f":"VLOOKUP(A10,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":76356.512629675737},{"$f":"VLOOKUP(A10,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":50.46097814289287}]
["HEW 1 2",null,null,null,"02",{"$f":"VLOOKUP(A11,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":77933.298057497246},{"$f":"VLOOKUP(A11,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":51.503012833440145}]
["HEW 1 3",null,null,null,"03",{"$f":"VLOOKUP(A12,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":79504.552775971955},{"$f":"VLOOKUP(A12,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":52.54139249845192}]
["HEW 2 1",null,null,"Level 2","01",{"$f":"VLOOKUP(A13,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":81497.207932775869},{"$f":"VLOOKUP(A13,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":53.858258930022359}]
["HEW 2 2",null,null,null,"02",{"$f":"VLOOKUP(A14,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":83455.749430550946},{"$f":"VLOOKUP(A14,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":55.152581002986793}]
["HEW 3 1",null,null,"Level 3","01",{"$f":"VLOOKUP(A15,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":85029.731413414309},{"$f":"VLOOKUP(A15,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":56.192763008414147}]
["HEW 3 2",null,null,null,"02",{"$f":"VLOOKUP(A16,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":87953.069351869082},{"$f":"VLOOKUP(A16,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":58.124680624035122}]
["HEW 3 3",null,null,null,"03",{"$f":"VLOOKUP(A17,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":90876.346345868267},{"$f":"VLOOKUP(A17,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":60.056557963892629}]
["HEW 3 4",null,null,null,"04",{"$f":"VLOOKUP(A18,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":93803.599965596091},{"$f":"VLOOKUP(A18,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":61.991063297316963}]
["HEW 4 1",null,null,"Level 4","01",{"$f":"VLOOKUP(A19,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":95905.29998960378},{"$f":"VLOOKUP(A19,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":63.379993138687844}]
["HEW 4 2",null,null,null,"02",{"$f":"VLOOKUP(A20,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":97872.92221126506},{"$f":"VLOOKUP(A20,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":64.680316300410297}]
["HEW 4 3",null,null,null,"03",{"$f":"VLOOKUP(A21,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":99842.098516544429},{"$f":"VLOOKUP(A21,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":65.981666494101404}]
["HEW 4 4",null,null,null,"04",{"$f":"VLOOKUP(A22,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":101811.24434959603},{"$f":"VLOOKUP(A22,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":67.282996549910763}]
["HEW 5 1",null,null,"Level 5","01",{"$f":"VLOOKUP(A23,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":103779.62837695245},{"$f":"VLOOKUP(A23,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":68.583823158676665}]
["HEW 5 2",null,null,null,"02",{"$f":"VLOOKUP(A24,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":107717.26489015778},{"$f":"VLOOKUP(A24,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":71.186050305838023}]
["HEW 5 3",null,null,null,"03",{"$f":"VLOOKUP(A25,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":111650.14773582535},{"$f":"VLOOKUP(A25,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":73.785135943448182}]
["HEW 5 4",null,null,null,"04",{"$f":"VLOOKUP(A26,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":115589.35356876267},{"$f":"VLOOKUP(A26,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":76.388400191519054}]
["HEW 6 1",null,null,"Level 6","01",{"$f":"VLOOKUP(A27,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":118420.42160142089},{"$f":"VLOOKUP(A27,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":78.259340301236534}]
["HEW 6 2",null,null,null,"02",{"$f":"VLOOKUP(A28,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":121345.96877639164},{"$f":"VLOOKUP(A28,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":80.192717913283559}]
["HEW 6 3",null,null,null,"03",{"$f":"VLOOKUP(A29,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":124267.00606164701},{"$f":"VLOOKUP(A29,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":82.123115118833255}]
["HEW 6 4",null,null,null,"04",{"$f":"VLOOKUP(A30,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":127192.50752827604},{"$f":"VLOOKUP(A30,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":84.056462524057665}]
["HEW 7 1",null,null,"Level 7","01",{"$f":"VLOOKUP(A31,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":130116.54632797037},{"$f":"VLOOKUP(A31,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":85.988843310958615}]
["HEW 7 2",null,null,null,"02",{"$f":"VLOOKUP(A32,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":134014.44705611662},{"$f":"VLOOKUP(A32,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":88.564810660333222}]
["HEW 7 3",null,null,null,"03",{"$f":"VLOOKUP(A33,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":137914.67890969009},{"$f":"VLOOKUP(A33,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":91.142318557660857}]
["HEW 7 4",null,null,null,"04",{"$f":"VLOOKUP(A34,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":141873.77244210502},{"$f":"VLOOKUP(A34,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":93.758725794248207}]
["HEW 8 1",null,null,"Level 8","01",{"$f":"VLOOKUP(A35,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":146976.79309675339},{"$f":"VLOOKUP(A35,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":97.131108906685768}]
["HEW 8 2",null,null,null,"02",{"$f":"VLOOKUP(A36,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":152998.37969412826},{"$f":"VLOOKUP(A36,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":101.11053566690657}]
["HEW 8 3",null,null,null,"03",{"$f":"VLOOKUP(A37,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":159013.56850222751},{"$f":"VLOOKUP(A37,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":105.08573438300016}]
["HEW 8 4",null,null,null,"04",{"$f":"VLOOKUP(A38,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":165035.09175515414},{"$f":"VLOOKUP(A38,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":109.06511928139794}]
["HEW 9 1",null,null,"Level 9","01",{"$f":"VLOOKUP(A39,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":172312.9571229232},{"$f":"VLOOKUP(A39,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":113.87477064710451}]
["HEW 9 2",null,null,null,"02",{"$f":"VLOOKUP(A40,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":175522.96871143242},{"$f":"VLOOKUP(A40,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":115.99613946068287}]
["HEW 9 3",null,null,null,"03",{"$f":"VLOOKUP(A41,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":178734.45305836396},{"$f":"VLOOKUP(A41,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":118.11848156164695}]
["HEW 9 4",null,null,null,"04",{"$f":"VLOOKUP(A42,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*SalaryOncostsMultiplier*$G$2","v":182343.34463765458},{"$f":"VLOOKUP(A42,'Admin-Salaries'!$A$1:$B$60,2,FALSE)*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/'Admin-Other'!$B$22*CASUALHOURS","v":120.50345427492246}]

{"sheet":"Salary Gap Calculations","index":7,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,2,2,5],[3,2,3,5]]}
[]
[null,null,"ARC Industry Fellowships 2024 Salary Gap Calculations for UQ applicants "]
[null,null,"As the DECRA salary and salary on-costs paid by the ARC are at a fixed rate (and the total is less than UQ academic appointment levels), there will be a gap between this and your actual UQ salary. This is to be outlined as a cash commitment in Parts D2, E1 and E3 of the Application, as required by ARC. \n \nThe level of academic appointment nominated on the signed Application Certification Form will determine the salary gap calculated the Application budget, incremented yearly across the life of the three year award. For example, approximate figures would be calculated as follows:  \n"]
[null,null,"• A level B01 would have $32,589 in year 1 of the budget as a UQ cash contribution, incrementing to B02 ($37,902) and B03 ($43,214) in years 2 and 3 respectively.\n• If the nominated level of appointment is at the top of that pay band (e.g. B06) then you may include that salary level each year, with no increments."]
[]
[null,null,"Level ","Yearly UQ Salary 2024 (including on-costs) ","ARC IE24 salary Level (including on-costs) ","ARC IE24 Yearly salary gap "]
[null,null,"D04",{"$f":"+'UQ Research Academic Staff'!F10","v":237116.33889346011},112897,{"$f":"D7-E7","v":124219.33889346011}]
[null,null,"D03",{"$f":"+'UQ Research Academic Staff'!F11","v":229820.56288294159},112897,{"$f":"D8-E8","v":116923.56288294159}]
[null,null,"D02",{"$f":"+'UQ Research Academic Staff'!F12","v":222523.91588625926},112897,109626.91588625926]
[null,null,"D01",{"$f":"+'UQ Research Academic Staff'!F13","v":215228.17154796488},112897,102331.17154796488]
[null,null,"C06",{"$f":"+'[2]UQ Research Academic Staff'!F14","v":206108.43965773267},112897,{"$f":"+D11-E11","v":93211.43965773267}]
[null,null,"C05",{"$f":"+'[2]UQ Research Academic Staff'!F15","v":200637.52218531576},112897,87740.522185315756]
[null,null,"C04",{"$f":"+'[2]UQ Research Academic Staff'!F16","v":195166.54136845047},112897,82269.541368450475]
[null,null,"C03",{"$f":"+'[2]UQ Research Academic Staff'!F17","v":189692.88424864563},112897,76795.884248645627]
[null,null,"C02",{"$f":"+'[2]UQ Research Academic Staff'!F18","v":184221.95094011666},112897,71324.950940116658]
[null,null,"C01",{"$f":"+'[2]UQ Research Academic Staff'!F19","v":178749.25982314802},112897,65852.259823148022]
[null,null,"B06",{"$f":"+'[2]UQ Research Academic Staff'!F20","v":173277.47136456729},112897,60380.471364567289]
[null,null,"B05",{"$f":"+'[2]UQ Research Academic Staff'!F21","v":167805.52454486594},112897,54908.524544865941]
[null,null,"B04",{"$f":"+'[2]UQ Research Academic Staff'!F22","v":162333.76775850938},112897,49436.767758509377]
[null,null,"B03",{"$f":"+'[2]UQ Research Academic Staff'!F23","v":156861.91595548036},112897,43964.915955480363]
[null,null,"B02",{"$f":"+'[2]UQ Research Academic Staff'!F24","v":151390.03248022724},112897,38493.032480227237]
[null,null,"B01",{"$f":"+'[2]UQ Research Academic Staff'!F25","v":145918.27569387064},112897,33021.275693870644]
[null,null,"A08",{"$f":"+'[2]UQ Research Academic Staff'!F26","v":138728.27611738606},112897,25831.276117386064]
[null,null,"A07",{"$f":"+'[2]UQ Research Academic Staff'!F27","v":134165.78737551515},112897,21268.787375515152]
[null,null,"A06",{"$f":"+'[2]UQ Research Academic Staff'!F28","v":129601.79421975749},112897,16704.794219757488]

{"sheet":"List","index":8,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Dropdown"]
[null,"1 Year",0,"N/A"]
[null,"2 Years",0,"N/A"]
[null,"3 Years",32192,"Earmarked PhD Stipend"]

{"sheet":"Lists","index":9,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Academic Level"]
["D04"]
["D03"]
["D02"]
["D01"]
["C06"]
["C05"]
["C04"]
["C03"]
["C02"]
["C01"]
["B06"]
["B05"]
["B04"]
["B03"]
["B02"]
["B01"]
["A08"]
["A07"]
["A06"]

{"sheet":"Salary Gap Calculations (2)","index":10,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[2,2,2,5]]}
[null,null,"ARC Industry Fellowships 2024 Salary Gap Calculations for UQ applicants "]
[null,null,"As the DECRA salary and salary on-costs paid by the ARC are at a fixed rate (and the total is less than UQ academic appointment levels), there will be a gap between this and your actual UQ salary. This is to be outlined as a cash commitment in Parts D2, E1 and E3 of the Application, as required by ARC. \n \nThe level of academic appointment nominated on the signed Application Certification Form will determine the salary gap calculated the Application budget, incremented yearly across the life of the three year award. For example, approximate figures would be calculated as follows:  \n"]
[null,null,"• A level B01 would have $32,589 in year 1 of the budget as a UQ cash contribution, incrementing to B02 ($37,902) and B03 ($43,214) in years 2 and 3 respectively.\n• If the nominated level of appointment is at the top of that pay band (e.g. B06) then you may include that salary level each year, with no increments."]
[]
[null,null,"Level ","Yearly UQ Salary 2024 (including on-costs) ","ARC IE24 salary Level (including on-costs) ","ARC IE24 Yearly salary gap ","ARC IM24 salary Level (including on-costs) ","ARC IM24 Yearly salary gap ","ARC IL24 salary Level (including on-costs) ","ARC IL24 Yearly salary gap "]
[null,null,"E01",{"$f":"+'UQ Research Academic Staff'!F9","v":277243.71664162667},109079,{"$f":"+D6-E6","v":168164.71664162667},199824,{"$f":"+D6-G6","v":77419.71664162667},173758,{"$f":"+D6-I6","v":103485.71664162667}]
[null,null,"D04",{"$f":"+'UQ Research Academic Staff'!F10","v":237116.33889346011},109079,{"$f":"+D7-E7","v":128037.33889346011},199824,37292.33889346011,173758,{"$f":"+D7-I7","v":63358.33889346011}]
[null,null,"D03",{"$f":"+'UQ Research Academic Staff'!F11","v":229820.56288294159},109079,120741.56288294159,199824,29996.562882941595,173758,{"$f":"+D8-I8","v":56062.562882941595}]
[null,null,"D02",{"$f":"+'UQ Research Academic Staff'!F12","v":222523.91588625926},109079,113444.91588625926,199824,22699.915886259259,173758,48765.915886259259]
[null,null,"D01",{"$f":"+'UQ Research Academic Staff'!F13","v":215228.17154796488},109079,106149.17154796488,199824,15404.171547964885,173758,41470.171547964885]
[null,null,"C06",{"$f":"+'UQ Research Academic Staff'!F14","v":206108.43965773267},109079,97029.43965773267,199824,6284.4396577326697,173758,32350.43965773267]
[null,null,"C05",{"$f":"+'UQ Research Academic Staff'!F15","v":200637.52218531576},109079,91558.522185315756,199824,813.52218531575636,173758,26879.522185315756]
[null,null,"C04",{"$f":"+'UQ Research Academic Staff'!F16","v":195166.54136845047},109079,86087.541368450475,199824,-4657.4586315495253,173758,21408.541368450475]
[null,null,"C03",{"$f":"+'UQ Research Academic Staff'!F17","v":189692.88424864563},109079,80613.884248645627,199824,-10131.115751354373,173758,15934.884248645627]
[null,null,"C02",{"$f":"+'UQ Research Academic Staff'!F18","v":184221.95094011666},109079,75142.950940116658,199824,-15602.049059883342,173758,10463.950940116658]
[null,null,"C01",{"$f":"+'UQ Research Academic Staff'!F19","v":178749.25982314802},109079,69670.259823148022,199824,-21074.740176851978,173758,4991.2598231480224]
[null,null,"B06",{"$f":"+'UQ Research Academic Staff'!F20","v":173277.47136456729},109079,64198.471364567289,199824,-26546.528635432711,173758,-480.52863543271087]
[null,null,"B05",{"$f":"+'UQ Research Academic Staff'!F21","v":167805.52454486594},109079,58726.524544865941,199824,-32018.475455134059,173758,-5952.4754551340593]
[null,null,"B04",{"$f":"+'UQ Research Academic Staff'!F22","v":162333.76775850938},109079,53254.767758509377,199824,-37490.232241490623,173758,-11424.232241490623]
[null,null,"B03",{"$f":"+'UQ Research Academic Staff'!F23","v":156861.91595548036},109079,47782.915955480363,199824,-42962.084044519637,173758,-16896.084044519637]
[null,null,"B02",{"$f":"+'UQ Research Academic Staff'!F24","v":151390.03248022724},109079,42311.032480227237,199824,-48433.967519772763,173758,-22367.967519772763]
[null,null,"B01",{"$f":"+'UQ Research Academic Staff'!F25","v":145918.27569387064},109079,36839.275693870644,199824,-53905.724306129356,173758,-27839.724306129356]
[null,null,"A08",{"$f":"+'UQ Research Academic Staff'!F26","v":138728.27611738606},109079,29649.276117386064,199824,-61095.723882613936,173758,-35029.723882613936]
[null,null,"A07",{"$f":"+'UQ Research Academic Staff'!F27","v":134165.78737551515},109079,25086.787375515152,199824,-65658.212624484848,173758,-39592.212624484848]
[null,null,"A06",{"$f":"+'UQ Research Academic Staff'!F28","v":129601.79421975749},109079,20522.794219757488,199824,-70222.205780242512,173758,-44156.205780242512]

{"sheet":"Admin-Salaries","index":11,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[[1,6,1,10],[3,6,3,10]]}
["BaseSalary",2024,2025,2026]
["HDR Stipend",33383.103999999999,{"$f":"B2*(100%+3.7%)","v":34618.278847999994},{"$f":"C2*(100%+3.7%)","v":35899.155165375989},null,"RTP website","Refer to the latest HDR Stipend rate from RTP website, use 2% increase for stipend estimate from 2023 onwards"]
["Academic E1",213264.39741663591,{"$f":"B3*(100%+3.7%)","v":221155.18012105141},229337.92178553028]
["Academic D4",182397.18376420008,189145.87956347546,196144.27710732404,null,"Wage Indexation rate in Finance Workbook","Indexation for Calendar Year"]
["Academic D3",176785.04837149353,183326.09516123877,190109.16068220459,null,null,2023,2024,2025,2026,"2027 onwards"]
["Academic D2",171172.2429894302,177505.61598003912,184073.32377130055,null,null,3.5000000000000003E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,0.02]
["Academic D1",165560.13195997299,171685.85684249198,178038.23354566417]
["Academic C6",158544.95358287127,164411.11686543751,170494.32818945867]
["Academic C5",154336.55552716597,160047.00808167108,165968.74738069289]
["Academic C4",150128.10874496191,155682.84876852549,161443.11417296092]
["Academic C3",145917.60326818895,151316.55458911194,156915.26710890906]
["Academic C2",141709.19303085897,146952.43317300073,152389.67320040174]
["Academic C1",137499.43063319079,142586.90956661882,147862.62522058369]
["Academic B6",133290.36258812869,138222.10600388944,143336.32392603334]
["Academic B5",129081.17272681995,133857.17611771228,138809.89163406764]
["Academic B4",124872.12904500721,129492.39781967246,134283.61653900033]
["Academic B3",120663.01227344642,125127.54372756393,129757.26284548378]
["Academic B2",116453.87113863633,120762.66437076587,125230.8829524842]
["Academic B1",112244.82745682358,116397.88607272605,120704.60785741691]
["Academic A8",106714.05855183542,110662.47871825332,114756.99043082868]
["Academic A7",103204.45182731935,107023.01654493016,110982.86815709257]
["Academic A6",99693.687861351907,103382.35431222193,107207.50142177413]
["Academic A5",96184.963190629933,99743.806828683228,103434.3276813445]
["Academic A4",92674.878989744349,96103.84951236489,99659.691944322389]
["Academic A3",88354.46793097147,91623.583244417401,95013.655824460831]
["Academic A2",84035.381242099407,87144.690348057076,90369.04389093518]
["Academic A1",79755.123203504729,82706.062762034402,85766.187084229663]
["HEW 9 4",140264.11125973429,145453.88337634446,150835.67706126918]
["HEW 9 3",137488.04081412611,142575.09832424877,147850.37696224597]
["HEW 9 2",135017.66823956338,140013.32196442722,145193.81487711103]
["HEW 9 1",132548.42855609476,137452.72041267026,142538.47106793904]
["HEW 8 4",126950.0705808878,131647.22319238062,136518.1704504987]
["HEW 8 3",122318.12961709809,126843.90041293071,131537.12472820914]
["HEW 8 2",117691.06130317559,122045.63057139308,126561.31890253461]
["HEW 8 1",113059.07161288723,117242.25726256405,121580.22078127891]
["HEW 7 4",109133.67110931154,113171.61694035606,117358.96676714924]
["HEW 7 3",106088.21454591546,110013.47848411433,114083.97718802655]
["HEW 7 2",103088.03619701279,106902.29353630226,110857.67839714543]
["HEW 7 1",100089.65102151566,103792.96810931173,107633.30792935625]
["HEW 6 4",97840.390406366176,101460.48485140172,105214.52279090357]
["HEW 6 3",95590.004662805397,99126.834835329195,102794.52772423637]
["HEW 6 2",93343.052904916651,96796.745862398559,100378.2254593073]
["HEW 6 1",91092.632001092992,94463.059385133427,97958.192582383359]
["HEW 5 4",88914.887360586668,92204.738192928373,95616.313506066712]
["HEW 5 3",85884.729027557958,89062.464001577595,92357.775169635963]
["HEW 5 2",82859.43453089059,85925.233608533541,89104.467252049275]
["HEW 5 1",79830.483366886489,82784.211251461282,85847.227067765343]
["HEW 4 4",78316.341807381556,81214.046454254669,84218.966173062086]
["HEW 4 3",76801.614243495715,79643.273970505048,82590.075107413722]
["HEW 4 2",75286.863239434664,78072.477179293739,80961.158834927599]
["HEW 4 1",73773.307684310596,76502.920068630076,79333.528111169377]
["HEW 3 4",72156.615358150841,74826.410126402421,77594.987301079309]
["HEW 3 3",69904.881804514051,72491.362431281072,75173.542841238464]
["HEW 3 2",67656.207193745446,70159.486859914017,72755.387873730826]
["HEW 3 1",65407.485702626385,67827.562673623557,70337.182492547625]
["HEW 2 2",64196.73033119303,66572.009353447167,69035.173699524705]
["HEW 2 1",62690.159948289125,65009.69586637582,67415.054613431726]
["HEW 1 3",61157.3482892092,63420.170175909938,65766.7164724186]
["HEW 1 2",59948.69081345942,62166.792373557415,64466.963691379031]
["HEW 1 1",58735.778945904414,60909.002766902871,63162.635869278274]

{"sheet":"Admin-Other","index":12,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Data Entry",null,null,null,null,null,null,"UQ Standard Salary Oncosts"]
["Type","Cost,In Kind Support,Outgoing Payment,Direct Cost w Indirect Cost as In Kind Support"]
["People Categories","Personnel,Personnel - HDR",null,null,null,null,null,"Non-Casual"]
["Other Categories","Consumables,Equipment,Travel - Domestic,Travel - International,Hospitality,Collaborator Payments,Subcontracts,Other",null,null,null,null,null,"Payroll Tax","NonCasualPRT",5.7000000000000002E-2]
["Cash Categories","UQ Central Cash Support,UQ Faculty Cash Support,UQ School Cash Support,Other Cash Support",null,null,null,null,null,"Workers Compensation","NonCasualWC",2E-3]
[null,null,null,null,null,null,null,"Superannuation","NonCasualSuper",0.17]
[null,null,null,null,null,null,null,"PRT on Superannuation","NonCasualPRTSuper",9.6900000000000007E-3]
[null,"Default Overheads",null,"Default Markup",null,null,null,"Long Service Leave","NonCasualLSL",2.4400000000000002E-2]
[null,"Research","Consultancy","Research","Consultancy",null,null,"Recreation Leave","NonCasualRec",1.4999999999999999E-2]
["HDR",null,null,null,null,null,null,"Parental Leave","NonCasualParent",1.0699999999999999E-2]
["Outgoing Payment",0.4,0.4,null,null,null,null,null,null,{"$f":"SUM(J6:J12)","v":0.28878999999999999}]
["Personnel",0.4,0.4,null,0.428571429]
["Else (including In Kind)",0.4,0.4,null,null,null,null,"Casual"]
[null,null,null,null,null,null,null,"Payroll Tax","CasualPRT",5.7000000000000002E-2]
["Unit Of Pay Calculators",null,null,null,null,null,null,"Workers Compensation","CasualWC",2E-3]
["UnitsOfPay","Time Divisor","CasualLoading","OncostMultiplier",null,null,null,"Superannuation","CasualSuper",0.105]
["Annual Salary",1,null,1.3,null,null,null,"PRT on Superannuation","CasualPRTSuper",5.9849999999999999E-3]
["Days",260.89299999999997,null,1.3,null,null,null,"Long Service Leave","-"]
["Hours",1891.4742499999998,null,1.3,null,null,null,"Recreation Leave","-"]
["Casual Hours",1891.4742499999998,1.25,1.3,null,null,null,"Parental Leave","-"]
[null,null,null,"nb. OnCosts are dependant on OncostsExemption Input",null,null,null,null,null,{"$f":"SUM(J16:J22)","v":0.169985}]