{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Help","Data Entry","Admin-ProRata","Admin - Tuition Fee","Admin - SCR","Admin-Salaries","Admin-Currencies","Admin-Other"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":110,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":215,"n_cols":6,"rows_kept":215,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"UQ Costing & Pricing Tool Version 3.9 updated Oct 2023."]
[null,null,"Check for the latest version of the Costing & Pricing Tool and help resources Under 'Budget Preparation'"]
[null,"a. Intro & Further Help","2","3","4","5"]
[null,"a. Intro & Further Help",null,"The Costing & Pricing tool has been designed to assist researchers in building, collating, and accurately calculating their project budgets. "]
[null,"a. Intro & Further Help",null,"The tool does not offer any embedded advice on how to go about costing your project; it would not be possible to cater for all users. "]
[null,"a. Intro & Further Help",null,"This is because there are many different norms and expectations dependant on a range of factors such as your discipline/org unit/granting scheme/partner organisations etc. "]
[null,"a. Intro & Further Help",null,"For this nuanced and specialist advice, please get in touch with the right team to help you, using the contact details below. "]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Research Grants"]
[null,"a. Intro & Further Help",null,"For budgeting advice on grants, please consult the relevant Research Office contact: "]
[null,"a. Intro & Further Help",null,"Research Office contact points "]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Consultancy contacts"]
[null,"a. Intro & Further Help",null,"For consultancy advice, including costing your consultancy project, please contact:"]
[null,"a. Intro & Further Help",null,"Consulting and Research Expertise"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Further research contacts"]
[null,"a. Intro & Further Help",null,"For general budgeting advice, please consult your HR and Finance Professional Services teams or your Research Partnerships Manager:"]
[null,"a. Intro & Further Help",null,"Finance Professional Services Teams"]
[null,"a. Intro & Further Help",null,"HR Professional Services Teams"]
[null,"a. Intro & Further Help",null,"Research Partnerships Manager"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"For enquiries on the UQ Costing and Pricing Tool:"]
[null,"a. Intro & Further Help",null,"grants-manager@research.uq.edu.au"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Costing Research Infrastructure/Equipment"]
[null,"a. Intro & Further Help",null,"Research Infrastructure Guide to Grants"]
[null,"a. Intro & Further Help",null,"Gatton Crop and Field Research Unit (New)"]
[null,"a. Intro & Further Help",null,"Gatton Grazing and Animal Production Units (New)"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Find a broad range of UQ resources relating to Research Management:"]
[null,"a. Intro & Further Help",null,"Research Management homepage"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help",null,"Consult the relevant UQ Policies and Procedures:"]
[null,"a. Intro & Further Help",null,"Research and Consultancy Costing and Pricing - UQ Procedure"]
[null,"a. Intro & Further Help",null,"Administration of Research Funding - UQ Policy"]
[null,"a. Intro & Further Help",null,"Contract Research and Grants Financial Management - UQ Procedures"]
[null,"a. Intro & Further Help",null,"Consultancy, Secondary Employment and Internal Work - UQ Policy"]
[null,"a. Intro & Further Help"]
[null,"a. Intro & Further Help"]
[null,"b. Before you Cost & Price your Project","Before you Cost & Price your Project"]
[null,"b. Before you Cost & Price your Project",null,"Orientate yourself to this tool"]
[null,"b. Before you Cost & Price your Project",null,"•          The header section contains a number of required data entry fields which will affect the way your totals are calculated. "]
[null,"b. Before you Cost & Price your Project",null,"•          In addition, there are 3 data entry tables to input all required budget data for all project calendar years. These are:"]
[null,"b. Before you Cost & Price your Project",null,"o    Data Entry for Personnel;"]
[null,"b. Before you Cost & Price your Project",null,"o    Data Entry for Other Costs;"]
[null,"b. Before you Cost & Price your Project",null,"o    Data Entry for Cash Contributions"]
[null,"b. Before you Cost & Price your Project",null,"•          There are 3 groups of columns which can be hidden/expanded depending on the requirements of your project. The placement of these are indicated with clickable text in Rows 61 & 62."]
[null,"b. Before you Cost & Price your Project",null,"o    Input Currency: Columns A-D"]
[null,"b. Before you Cost & Price your Project",null,"o    Salary Oncosts: Columns AK-AT"]
[null,"b. Before you Cost & Price your Project",null,"o    Year Apportionments: Columns AU-AY"]
[null,"b. Before you Cost & Price your Project",null,"•           Columns in the 3 data entry tables are aligned, however as not all columns are applicable in each table there are some gaps."]
[null,"b. Before you Cost & Price your Project",null,"•           Table cells with a white background are calculated based on formulas and should not be directly overwritten."]
[null,"b. Before you Cost & Price your Project",null,"•           You can click on the header of each column for a description of what should be entered."]
[null,"b. Before you Cost & Price your Project",null,"•           The Milestone table at the bottom presents the totals, and can be split by Amounts or Percentages as required."]
[null,"b. Before you Cost & Price your Project"]
[null,"b. Before you Cost & Price your Project",null,"General Data Entry Tips:"]
[null,"b. Before you Cost & Price your Project",null,"•          Click on column headings in the data entry tables for tips as you go, and hover over the 🛈 symbols for further descriptions and help."]
[null,"b. Before you Cost & Price your Project",null,"•          Use the ‘Add Row’ button to add as many rows as required, this will fill the row with the correct formulas."]
[null,"b. Before you Cost & Price your Project",null,"•          You can use all standard excel functions, e.g. show more decimal places, expand column widths etc. as required."]
[null,"b. Before you Cost & Price your Project",null,"•          Cells in the table are not protected to enable custom values to be entered, and to ensure macros can run. If you overwrite a cell formula by accident, you can always restore it by clicking the 'Add row' button, and copy or fill the formula from the new row. "]
[null,"b. Before you Cost & Price your Project",null,"•          Delete any unused rows from the table by right-clicking on the row number at the left of the spreadsheet and select 'Delete'."]
[null,"b. Before you Cost & Price your Project",null,"•          If you are adding additional info to blank cells in the data entry sheets, make sure it is not directly next to a table. Excel will add it as a table column, which will disrupt the macro calculations based on the data entry tables when running reports."]
[null,"b. Before you Cost & Price your Project"]
[null,"b. Before you Cost & Price your Project"]
[null,"c. Enter Basic Project Info","Enter Basic Project Info"]
[null,"c. Enter Basic Project Info",null,"1.    Enter a project Title. This information will copy over to Cost Summary pivot reports and Client Summary pivot reports."]
[null,"c. Enter Basic Project Info",null,"2.    Enter a project ID e.g. the RM number. Leave blank if n/a, as this information will copy over to Cost Summary pivot reports and Client Summary pivot reports."]
[null,"c. Enter Basic Project Info",null,"3.    Indicate whether the project is Contract Research, Research Grants, or Consultancy. In order for a project to be considered Research it must meet the definition of research as defined in HERDC. If your project does not meet this definition, it may be considered Consultancy. This informs the default behaviour of the tables, e.g. the percentage of markup which should be applied for a particular cost category.","Definition of research","Definition of consultancy"]
[null,"c. Enter Basic Project Info",null,"4.    Indicate whether the project will include the following types of costs: Personnel; Other (non-personnel); Cash Contributions. This informs the Working Totals and the Pivot Report macros which Data Entry Tables should be included. e.g. Some projects will not include personnel, while other may only involve personnel costs."]
[null,"c. Enter Basic Project Info",null,"5.    Select the currency that the budget will be displayed in. This option relates to the output currency. You can toggle between AUD and a selected Output currency at any point."]
[null,"c. Enter Basic Project Info",null,"6.    Indicate whether GST is applicable on this project. GST will be applicable to the majority of grants where services and payments occur within Australia. If you are unsure if GST is applicable on your project, please consult with your professional support staff."]
[null,"c. Enter Basic Project Info",null,"7.    Indicate whether this project has a mandate for 30% oncosts for personnel. Select whether an oncosts exception applies (No or 30%). Many competitive funding schemes require the inclusion of 30% oncosts. If there is no exception, standard UQ oncost rates will be applied."]
[null,"c. Enter Basic Project Info",null,"8.    Indicate whether the Service Recovery Rate (New) applies to the project. Currently, the SCR rate applies to Rural Research And Development Corporation (RDC) projects, but it may also apply to other grant schemes in the future. If you are unsure whether the SCR rate will apply to your project, please consult with your professional support staff. By selecting 'Yes,' the current indirect cost recovery rate of 50% on Direct Cost will be replaced by the SCR rate, while the remainder of 50% will be treated as UQ's In-Kind contribution."]
[null,"c. Enter Basic Project Info",null,"9.    Indicate whether 15% of the Total Markup will be retained by the organisational unit (OU).  It currently applies to consultancy project type only. "]
[null,"c. Enter Basic Project Info",null,"10.  Indicate whether tuition fee should be charged on Industry-Funded HDR student to offset the cost of training a research student. (New)  If tuition fee is allowed to be recovered from the granting body, at least 50% of the tuition fee must be included in the price. "]
[null,"c. Enter Basic Project Info"]
[null,"c. Enter Basic Project Info"]
[null,"d. Step-by-step how to enter Personnel Data","Step-by-step how to enter Personnel Data"]
[null,"d. Step-by-step how to enter Personnel Data",null,"If your project will include personnel data, enter data into the ‘Data Entry for Personnel’ table."]
[null,"d. Step-by-step how to enter Personnel Data",null,"1.     Optionally, Columns A-D will assist you to record the conversion of costs from an alternative currency, and calculate the resulting equivalent in AUD in column Q. You will still need to enter the desired value into the AUD Cost per Unit."]
[null,"d. Step-by-step how to enter Personnel Data",null,"2.     Select Type from list: Cost; In Kind Support; Outgoing Payment; Direct Cost w Indirect Cost as In Kind Support"]
[null,"d. Step-by-step how to enter Personnel Data",null,"3.     Select Category from list: Personnel; Personnel – HDR. Oncosts do not apply to HDRs. "]
[null,"d. Step-by-step how to enter Personnel Data",null,"4.     Enter a title for the Budget Item. This may be the name of the individual or role description."]
[null,"d. Step-by-step how to enter Personnel Data",null,"5.     Optionally enter additional details in Notes."]
[null,"d. Step-by-step how to enter Personnel Data",null,"6.     Enter Calendar Year"]
[null,"d. Step-by-step how to enter Personnel Data",null,"7.     Apportion to Start & End Dates within the calendar year"]
[null,"d. Step-by-step how to enter Personnel Data",null,"8.     Select a standard Salary Code from the drop down list (e.g. Academic B2; HEW 6 2; HDR Stipend), or select 'Senior Administrative Salary’ or ‘Other’ to enter a custom amount."]
[null,"d. Step-by-step how to enter Personnel Data",null,"9.     Select Unit of Pay from drop down list: Annual Salary; Days; Hours; Casual Hours."]
[null,"d. Step-by-step how to enter Personnel Data",null,"10.   Add percentage Salary Loading or leave as default 0%."]
[null,"d. Step-by-step how to enter Personnel Data",null,"11.   If the row has a calendar year, salary code, and unit of pay selected, the Cost per Unit should be automatically returned. If you have selected ‘Other’ for a custom salary amount, write directly into the Cost per Unit column. "]
[null,"d. Step-by-step how to enter Personnel Data",null,"12.   Enter the No of Units. This can be a whole number or a decimal, e.g. 10 Days, or 0.8 (FTE) of an Annual Salary."]
[null,"d. Step-by-step how to enter Personnel Data",null,"13.   Select option to apportion units from the drop-down menu. 'Yes - Pro Rata' will apportion the units to the Start and End Dates within the calendar year. 'Yes - Per Week' will apportion Pro Rata and then multiply by the number of weeks in the specified period. Select ‘No’ to make no adjustment to the entered No of Units."]
[null,"d. Step-by-step how to enter Personnel Data",null,"14.   Optionally overwrite the default Indirect Costs %."]
[null,"d. Step-by-step how to enter Personnel Data",null,"15.   Optionally overwrite the default Markup %. For consultancy projects, the default markup for personnel rounds to 43%, but is actually 42.8571429%, which represents twice the base costs."]
[null,"d. Step-by-step how to enter Personnel Data"]
[null,"d. Step-by-step how to enter Personnel Data"]
[null,"e. Step-by-step how to enter Other (non-personnel) data","Step-by-step how to enter Other (non-personnel) data"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"If your project will include Other (non-personnel) data, enter data into the ‘Data Entry for Other Costs’ table."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"1.     Optionally, Columns A-D will assist you to record the conversion of costs from an alternative currency, and calculate the resulting equivalent in AUD in column Q. You will still need to enter the desired value into the AUD Cost per Unit."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"2.     Select Type from list: Cost; In Kind Support; Outgoing Payment"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"3.     Select Category from list: Consumables; Equipment; Travel – Domestic; Travel – International; Hospitality; Collaborator Payments; Subcontracts; Other"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"4.     Enter a title for the Budget Item."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"5.     Optionally enter additional details in Notes."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"6.     Enter Calendar Year"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"7.     Apportion to a Start & End Dates within the calendar year"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"8.     Enter the Cost per Unit."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"9.     Enter the No of Units. This can be a whole number or a decimal."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"10.   Select option to apportion units from the drop-down menu. 'Yes - Pro Rata' will apportion the units to the Start and End Dates within the calendar year. 'Yes - Per Week' will apportion Pro Rata and then multiply by the number of weeks in the specified period. Select ‘No’ to make no adjustment to the entered No of Units – this is the default for non-personnel costs."]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"11.   Optionally overwrite the default Indirect Costs %"]
[null,"e. Step-by-step how to enter Other (non-personnel) data",null,"12.   Optionally overwrite the default Markup %"]
[null,"e. Step-by-step how to enter Other (non-personnel) data"]
[null,"e. Step-by-step how to enter Other (non-personnel) data"]
[null,"f. Step-by-step how to enter Cash Contributions","Step-by-step how to enter Cash Contributions"]
[null,"f. Step-by-step how to enter Cash Contributions",null,"If your project will include cash contributions, enter data into the ‘Data Entry for Cash Contributions' table."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"1.     Optionally, Columns A-D will assist you to record the conversion of costs from an alternative currency, and calculate the resulting equivalent in AUD in column Q. You will still need to enter the desired value into the Cost per Unit."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"2.     Select Type from list: Cash Contribution"]
[null,"f. Step-by-step how to enter Cash Contributions",null,"3.     Select Category from list: UQ Central; UQ Faculty; UQ School or Other Cash Support."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"4.     Enter a title for the Budget Item, e.g. 'Cash Contribution from UQ' or 'Cash Contribution from Funder A'."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"6.     Optionally enter additional details in Notes."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"7.     Enter Calendar Year"]
[null,"f. Step-by-step how to enter Cash Contributions",null,"8.     Apportion to a Start & End Dates within the calendar year"]
[null,"f. Step-by-step how to enter Cash Contributions",null,"9.     Enter the Cost per Unit."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"10.   Enter the No of Units. This can be a whole number or a decimal."]
[null,"f. Step-by-step how to enter Cash Contributions",null,"11.   Select option to apportion units from the drop-down menu. 'Yes - Pro Rata' will apportion the units to the Start and End Dates within the calendar year. 'Yes - Per Week' will apportion Pro Rata and then multiply by the number of weeks in the specified period. Select ‘No’ to make no adjustment to the entered No of Units – this is the default for non-personnel costs."]
[null,"f. Step-by-step how to enter Cash Contributions"]
[null,"f. Step-by-step how to enter Cash Contributions"]
[null,"g. Check & Review","Check & Review"]
[null,"g. Check & Review",null,"Once you have entered all your project data, review the Working Totals: Costing & Pricing Components (from Row 37), and Working Totals: Internal allocation of Recovered Costs & Markup (from Row 45)."]
[null,"g. Check & Review",null,"If your totals do not look quite right, common mistakes to check for are:"]
[null,"g. Check & Review",null,"•          Ensure that you have correctly indicated whether each of the Data Entry Tables - Personnel; Other (non-personnel); and Cash Contributions - are being utilised (at Q4 in the Basic Project Details section)."]
[null,"g. Check & Review",null,"•          For table which are being utilised, ensure that any unused rows at the end of the table is deleted."]
[null,"g. Check & Review",null,"•          Check that for each row with data, you have not missed any of the following critical columns: Type; Category; Budget item; Calendar year; AUD Cost per Unit; & Number of Units."]
[null,"g. Check & Review",null,"•         (New) A data validation button has been added to tab \"Data Entry\"  as an optional function. It is recommended to run before generating reports. The validation button does two things at the moment: \n              1. It checks if all the data entry tables have been completed based on the answer in Question 4 under project details section.  Any missing critical data cell will be circled out in red color.\n              2. It resets all the formula of those white cell in the table to the default one."]
[null,"g. Check & Review",null,"•          The Pivot reports are created using macros which read the data entry tables. For this reason, make sure you have not added/rearranged/renamed any table columns. "]
[null,"g. Check & Review"]
[null,"g. Check & Review"]
[null,"h. Milestone Totals","Milestone Totals"]
[null,"h. Milestone Totals",null,"•          You can create Milestones and review cost components using the Milestone Table. "]
[null,"h. Milestone Totals",null,"•          Optionally, enter information into the Milestone Title; Year; and Funding Provider (the blue columns)."]
[null,"h. Milestone Totals",null,"•          The essential information is to set the Milestone value either by placing a dollar value in the Set by Amount column, OR by entering the percentage in the Set by Percentage column (green columns). "]
[null,"h. Milestone Totals",null,"•          Do not overwrite any figures in the while columns (J onward), as these cells contain formulas that will calculate automatically. "]
[null,"h. Milestone Totals",null,"•          The slicer filters above the table will assist you to subtotal values by Year or Funding Provider. "]
[null,"h. Milestone Totals"]
[null,"h. Milestone Totals"]
[null,"i. Pivot Report Tips","Pivot Report Tips"]
[null,"i. Pivot Report Tips",null,"The 'Cost Summary' and 'Client Report' are the two key reports which you can automate from your data entry. Relevant drop down options are provided, such as whether you want an item included in the report."]
[null,"i. Pivot Report Tips",null,"•          The 'Cost Summary' and 'Client Report' are the two key reports which you can automate from your data entry. Select options from the drop down menus."]
[null,"i. Pivot Report Tips",null,"•          It is worth noting that Pivot Tables are a standard excel function, and as such there is an endless amount of online help about this feature."]
[null,"i. Pivot Report Tips",null,"•          You can use normal pivot table functionality if you prefer a different type of view e.g. subtotals and grant totals on/off, switch between compact and outline form."]
[null,"i. Pivot Report Tips",null,"•          If the pivot table results do not match the Working Totals on the data entry tab, revisit the tips above under 'Check & Review'."]
[null,"i. Pivot Report Tips"]
[null,"i. Pivot Report Tips"]
[null,"j. Goal Seek Tips","Goal Seek Tips"]
[null,"j. Goal Seek Tips",null,"Goal Seek, also known as 'what-if-analysis' or 'back-solving', assists you to calculate backward to obtain an input that would result in a given output. e.g. what Markup amount would result in the desired Cost to Client amount?"]
[null,"j. Goal Seek Tips",null,"•          The 'Set' cell must always contain a formula or a function."]
[null,"j. Goal Seek Tips",null,"•          The Changing Cell must contain a value only, not a formula or function. You may need to overwrite a cell formula with the value which the formula is producing."]
[null,"j. Goal Seek Tips",null,"•          It is worth noting that Goal Seek is a standard excel function, and as such there is an endless amount of online help about this feature."]
[null,"j. Goal Seek Tips"]
[null,"j. Goal Seek Tips"]
[null,"x.  ChangeLog","Change Log"]
[null,"x.  ChangeLog",null,"[C&P Tool 3.9] - 25/10/2023"]
[null,"x.  ChangeLog",null,"Changed:"]
[null,"x.  ChangeLog",null,"—     Salary Index to reflect the latest Enterprise Agreement."]
[null,"x.  ChangeLog",null,"—     Email link for Gatton Directors and Farm Unit Teams."]
[null,"x.  ChangeLog",null,"—     Hover-over Tips text for Input Currency Rate."]
[null,"x.  ChangeLog",null,"—     Indirect Cost Rate to 50% (was at 40%)."]
[null,"x.  ChangeLog",null,"—     Optional OU Margin is now calculated as 15% of the Total Markup."]
[null,"x.  ChangeLog",null,"—     Indirect Cost Recovery will apply to all consultancy & contract research."]
[null,"x.  ChangeLog",null,"—     Consultancy and Expert Witness project types have been consolidated into a single Consultancy project type."]
[null,"x.  ChangeLog",null,"—     Type 3 consultancy no longer exists as per the latest policy."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"Added:"]
[null,"x.  ChangeLog",null,"—    Working Totals for Costing & Pricing Components by Calendar Year."]
[null,"x.  ChangeLog",null,"—    MyResearch Data Tab: Reformatting data for testing and trials for the upcoming MyResearch integration."]
[null,"x.  ChangeLog",null,"—    Option for Service Cost Recovery (SCR) Model under Basic Project Details section, see the details under Help Sections: c. Enter Basic Project Info."]
[null,"x.  ChangeLog",null,"—    Option for Tuition Fee Recovery Model under Basic Project Details section, see the details under Help Sections: c. Enter Basic Project Info."]
[null,"x.  ChangeLog",null,"—    More Data Validation in basic project detail section to cross check data combo and data range."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"[C&P Tool 3.8] - 2/12/2022"]
[null,"x.  ChangeLog",null,"Changed:"]
[null,"x.  ChangeLog",null,"—     UQ stipend base rate in 2023 has been increased by the Dec 2022 CPI rate of 7.8% to be $32,192."]
[null,"x.  ChangeLog",null,"—     Add 3% administrative increase for all staff salary, this is in addition to the projected Enterprise agreement rate. \n            E.g: 2023 Base Salary = 2022  Base Salary * (1+3%)* (1+3.5%)"]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"Added:"]
[null,"x.  ChangeLog",null,"—     Invalid End Date Notification in Personnel Table: The End Date must be no earlier than the Start Date and fall within the same Calendar Year."]
[null,"x.  ChangeLog",null,"—     Reminder of using the latest version of C&P tool"]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"[C&P Tool 3.7] - 23/08/2022"]
[null,"x.  ChangeLog",null,"Changed:"]
[null,"x.  ChangeLog",null,"—     The payroll tax rate has increased for both casual and non-casual salaries by 0.75%. As a result, the casual on-cost rate has climbed to 16.9985%, and the non-casual rate has increased to 28.879%."]
[null,"x.  ChangeLog",null,"—     BaseSalary yearly Pay Rise Rate: was by default set to 2% for all upcoming years. It has been updated to the rates listed below to reflect the most recent RBA indexation of pay inflation and to make it consistent with the UQ finance budgeting tool."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"—     The stipend rate will increase by 3.5% in 2023 in accordance with the most recent RTP stipend rate."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"[C&P Tool 3.6] - 13/07/2022"]
[null,"x.  ChangeLog",null,"Changed:"]
[null,"x.  ChangeLog",null,"—     Fixed the VBA runtime error when running \"Summarie RO Block Tables\" in Mac version Excel"]
[null,"x.  ChangeLog",null,"—     Updated the PRT on Superannuation rate as part of the on-cost rate.  As the result,  on-cost rate has been updated to 28.0015% for Non-Casual and 16.170% for Casual."]
[null,"x.  ChangeLog",null,"—     Staff salary cost forecast method has been made consistent with the finance budgetting tool."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"[C&P Tool 3.5] - 25/02/2022"]
[null,"x.  ChangeLog",null,"Added:"]
[null,"x.  ChangeLog",null,"—     New Button \"Validation on Data Entry\" has been added to \"Data Entry\" tab, see the details under Help Sections: g. Check & Review"]
[null,"x.  ChangeLog",null,"—      Add column \"Total (Direct +Markup)\" under Milestone Table."]
[null,"x.  ChangeLog"]
[null,"x.  ChangeLog",null,"Changed:"]
[null,"x.  ChangeLog",null,"—     On-cost rate has been updated to 28% for Non-Casual and 15.65% for Casual."]
[null,"x.  ChangeLog",null,"—     Report \"Summarise Block Totals for OSR\" has been renamed to \"Summarise RO Block Totals\", it now displays the figure in AUD when Output Currency is in foreign Currency."]
[null,"x.  ChangeLog",null,"—     RO Block table has been re-worked to exlcude in-kind from Block Total, but keep it as a separate line for additional information."]
[null,"x.  ChangeLog",null,"—     The logic relating to “Reallocating Indirect Cost” has been re-worked in RO Block table:  In case the indirect cost needs to be reallocated , it calculates and displays row “Central allocation, Primary Faculty, Secondary Faculty Allocation” in those tables under tab “RO Block Totals”. Otherwise, it caculates and displays row “ACA overhead” instead."]
[null,"x.  ChangeLog",null,"—     Under \"Milestone Table\",  it now uses the figure ex-GST for field \"Set by Amount\" instead."]
[null,"x.  ChangeLog",null,"—     Under \"Milestone Table\", the total amount/percentage is now displayed for columm \"Set by Amount\", \"Set by Percentage\", \"Milestone Percentage\"."]

{"sheet":"Data Entry","index":1,"n_rows":147,"n_cols":51,"rows_kept":147,"cut":false,"hidden":false,"merged":[[113,19,113,25],[114,20,114,23],[114,24,114,25],[113,10,113,18],[114,10,114,18],[1,4,1,18],[114,7,114,8],[55,13,56,13],[55,10,55,11],[55,7,55,9]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51]
[null,null,null,null,"Important: Please always use the latest Costing & Pricing tool. Click here to download the latest version."]
[null,null,null,null,"Data Entry for Basic Project Details"]
[]
[null,null,null,null,null,"1. Title:","Enter Project Title"]
[null,null,null,null,null,"2. Project No.:","e.g. 20501234567"]
[]
[null,null,null,null,null,"3. Indicate whether the project is Contract Research, Research Grants, or Consultancy.",null,null,null,null,null,null,null,null,"Definition of Research as aligned with HERDC"]
[null,null,null,null,null,null,"Project Type:","Contract Research","🛈",null,null,null,null,null,"Research and Consultancy Costing and Pricing - UQ Procedure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Administration of Research Funding - UQ Policy"]
[null,null,null,null,null,"4. Indicate whether the project will include the following types of costs.",null,null,null,null,null,null,null,null,"Contract Research and Grants Financial Management - UQ Procedures"]
[null,null,null,null,null,null,"Personnel?","Yes","🛈",null,null,null,null,null,"Consultancy, Secondary Employment and Internal Work - UQ Policy"]
[null,null,null,null,null,null,"Other costs?","Yes"]
[null,null,null,null,null,null,"Cash support?","No"]
[]
[null,null,null,null,null,"5. Select the currency that the budget will be displayed in."]
[null,null,null,null,null,null,"Output Currency:","AUD","🛈"]
[null,null,null,null,null,null,null,"(If Alternative) Currency:","USD","🛈","oanda.com"]
[null,null,null,null,null,null,null,"Conversion Rate:",0.72,"🛈","commbank.com.au"]
[null,null,null,null,null,null,null,"Date of Conversion:",44562]
[]
[null,null,null,null,null,"6. Indicate whether GST is applicable on this project."]
[null,null,null,null,null,null,"Is GST Applicable?","Yes","🛈"]
[]
[null,null,null,null,null,"7. Indicate whether this project has a mandate for 30% oncosts for personnel."]
[null,null,null,null,null,null,"Oncosts Exception?","No","🛈"]
[]
[null,null,null,null,null,"8.[Not on Consultancy] Indicate whether this project's indirect cost applies SCR Rate? (New)"]
[null,null,null,null,null,null,"Does SCR apply?","No","🛈"]
[null,null,null,null,null,null,"(If applies) Include the following additional direct/indirect cost in the SCR pool?",null,null,null,"SCR Rate:",{"$f":"IF(SCRException=\"No\", \"Do not apply\",SCR_rate)","v":"Do not apply"}]
[null,null,null,null,null,null,null,"Office of Research Ethics & Integrity","No"]
[null,null,null,null,null,null,null,"Grad School","No"]
[null,null,null,null,null,null,null,"Marketing & Communication","No"]
[]
[null,null,null,null,null,"9. [Consultancy Only] Indicate whether 15% of the Total Markup will be retained by the organisational unit (OU)."]
[null,null,null,null,null,null,"Apply OU margin?","No","🛈"]
[]
[null,null,null,null,null,"10. [Contract Research Only] Indicate whether tuition fee should be charged on Industry-Funded HDR student to offset the cost of training a research student. (New)"]
[null,null,null,null,null,null,"Does Tuition Fee need to be recovered?","No","🛈"]
[null,null,null,null,null,null,"Tuition Fee Type?","Band A","🛈"]
[null,null,null,null,null,null,"% Tuition Fee to be recovered (at least 50%)",0.5]
[]
[]
[]
[null,null,null,null,"Working Totals: Costing & Pricing Components"]
[]
[null,null,null,null,null,null,"🛈","🛈","🛈","🛈",null,null,null,null,null,"🛈"]
[null,null,null,null,null,null,"Direct Costs","Indirect Costs","Total Markup","In Kind Support","Cash Support","Cost to Client","GST","Cost to Client inc GST",null,"Total Tuition Fee  Amount to be recovered"]
[null,null,null,null,null,"AUD:",{"$f":"      IF(OutputCurrencyOption=\"AUD\",                     (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Direct Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Direct Costs]],0)),      (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Direct Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Direct Costs]],0))/OutputCurrencyRate)","v":0},{"$f":"  IF(OutputCurrencyOption=\"AUD\",      (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Indirect Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Indirect Costs]],0)),  (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Indirect Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Indirect Costs]],0))/OutputCurrencyRate)","v":0},{"$f":"        IF(OutputCurrencyOption=\"AUD\",             (  IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Markup]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Markup]],0)),   (  IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Markup]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Markup]],0))/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[In Kind Support]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[In Kind Support]],0)), (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[In Kind Support]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[In Kind Support]],0))/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",   (IF(HasCashSupport=\"Yes\",CashTable[[#Totals],[Cash Support]],0)), (IF(HasCashSupport=\"Yes\",CashTable[[#Totals],[Cash Support]],0))/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",      (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Cost to Client]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Cost to Client]],0)),(IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Cost to Client]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Cost to Client]],0))/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",TotalCostToClientAUD*0.1,0)","v":0},{"$f":"TotalCostToClientAUD+M49","v":0},null,{"$f":"IF(TuitionFeeRecException=\"Yes\", SUMIF(PersonnelTable[Category],\"Personnel - HDR\",PersonnelTable[Indirect Costs]),\"n/a\")","v":"n/a"}]
[null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Direct Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Direct Costs]],0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Indirect Costs]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Indirect Costs]],0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Markup]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Markup]],0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[In Kind Support]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[In Kind Support]],0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\",CashTable[[#Totals],[Cash Support]],0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Cost to Client]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Cost to Client]],0)","v":0},{"$f":"IF(ClientGST=\"Yes\",L50*0.1,0)","v":0},{"$f":"TotalCostToClientOutput+M50","v":0}]
[]
[]
[null,null,null,null,"Working Totals: Internal allocation of Recovered Costs & Markup"]
[]
[null,null,null,null,null,null,"🛈","🛈","🛈",null,"🛈",null,null,"🛈",null,null,"🛈"]
[null,null,null,null,null,null,"Direct Costs Recovered","Indirect Costs Recovered",null,null,"Markup",null,null,"Project Account Total"]
[null,null,null,null,null,null,"Project Account","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","OU Margin","Project Account"]
[null,null,null,null,null,"AUD:",{"$f":"      IF(OutputCurrencyOption=\"AUD\",                     (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Direct Costs Recovered]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Direct Costs Recovered]],0)),      (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[Direct Costs Recovered]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[Direct Costs Recovered]],0))/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[60% Central Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[60% Central Allocation]],0)),\nIF(OutputCurrencyOption<>\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[60% Central Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[60% Central Allocation]],0))/OutputCurrencyRate))","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[20% Primary Faculty Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[20% Primary Faculty Allocation]],0)),\nIF(OutputCurrencyOption<>\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[20% Primary Faculty Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[20% Primary Faculty Allocation]],0))/OutputCurrencyRate))","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[20% Secondary Faculty Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[20% Secondary Faculty Allocation]],0)),\nIF(OutputCurrencyOption<>\"AUD\", (IF(HasPersonnel=\"Yes\",PersonnelTable[[#Totals],[20% Secondary Faculty Allocation]],0)+IF(HasOtherCosts=\"Yes\",OtherTable[[#Totals],[20% Secondary Faculty Allocation]],0))/OutputCurrencyRate))","v":0},{"$f":"IF(ApplyOUMargin=\"Yes\",TotalMarkupAUD*0.15,0)","v":0},{"$f":"TotalMarkupAUD-TotalMarkupToOU","v":0},null,{"$f":"TotalDCToProjectAccount+TotalMarkupToProjectAccount","v":0}]
[]
[]
[]
[]
["🛈 Currency converter",null,null,null,"🛈 With the exceptions of the 'Input Currency' columns (A;B;C: hidden by default) and Notes column (H) - all coloured columns must have a value. Greyed out columns do not apply to that table. Formulas in white columns should not be overwritten."]
[null,null,null,null,"🛈 Click on the column headers for more detailed tips about what should be entered and/or how the column is calculated."]
[]
[null,null,null,null,"Data Entry for Personnel Costs"]
["Input Currency Cost per Unit","Input Currency","Input Currency Rate","AUD Cost per Unit Converted from Input","Type","Category","Budget Item","Notes","Calendar Year","Start Date","End Date","Salary Code","Unit Of Pay","Salary Loading","AUD Cost per Unit","No Of Units","Prorate Units?","Apportioned Units","Indirect Costs %","Markup %","Output Currency Cost per Unit","Direct Costs","Indirect Costs Per Unit","Indirect Costs","Markup Per Unit","Markup","Cost to Client Per Unit","Cost to Client","Cost to Client inc GST","In Kind Support","Cash Support","Direct Costs Recovered","Indirect Costs Recovered","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","Salary Base Cost","Total Oncosts","Total Oncosts %","Payroll Tax","Workers Compensation","Superannuation","Payroll Tax on Superannuation","Long Service Leave","Recreation Leave","Parental Leave","CY %","FY1","FY2","FY1 % of CY %","FY2 % of CY %"]
[null,null,null,{"$f":"PersonnelTable[[#This Row],[Input Currency Cost per Unit]]*PersonnelTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Salary Code]]),,\"0%\")","v":0},{"$f":"IFERROR((IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0)), IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/260.893,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/260.893, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/1891.47425,))))))))*(1+PersonnelTable[[#This Row],[Salary Loading]]),\"\")","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes\", PersonnelTable[[#This Row],[No Of Units]]*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]), IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (PersonnelTable[[#This Row],[No Of Units]]*52.143)*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]),PersonnelTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"No\"),0,IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"Yes\"),INDEX(TuitionFee_Multipiler,MATCH(TuitionFee_CostType,LookupTuitionMultiplier,0),MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear_Tuition,0)), IF(AND(SCRException=\"Yes\",PersonnelTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)))","v":0.5},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"Outgoing Payment\",PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\"),0,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel\",ProjectType=\"Consultancy\"),0.428571429,\"0%\"))","v":"0%"},{"$f":"IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]], PersonnelTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Indirect Costs Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))+PersonnelTable[[#This Row],[Indirect Costs Per Unit]])*PersonnelTable[[#This Row],[Markup %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Markup Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]], PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Indirect Costs Per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Markup]], PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",PersonnelTable[[#This Row],[Cost to Client]]*1.1,PersonnelTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\", PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]], IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", PersonnelTable[[#This Row],[Indirect Costs]],IF(AND(PersonnelTable[[#This Row],[Type]]=\"Cost\",PersonnelTable[[#This Row],[Category]]<>\"Personnel - HDR\",SCRException=\"Yes\"),(0.5-PersonnelTable[[#This Row],[Indirect Costs %]])*PersonnelTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0,PersonnelTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsCasualMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsMultiplier)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", \"0\", PersonnelTable[[#This Row],[Direct Costs]]-PersonnelTable[[#This Row],[Salary Base Cost]])","v":0},{"$f":"IFERROR(IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, PersonnelTable[[#This Row],[Total Oncosts]]/PersonnelTable[[#This Row],[Salary Base Cost]]),)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualWC, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualWC)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuper, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuper)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuperPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuperPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Salary Base Cost]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualLSL)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualRec)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualParent)))","v":0},{"$f":"YEARFRAC(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)+1,PersonnelTable[[#This Row],[Start Date]]),IF((PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),IF((PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"PersonnelTable[[#This Row],[Input Currency Cost per Unit]]*PersonnelTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Salary Code]]),,\"0%\")","v":0},{"$f":"IFERROR((IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0)), IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/260.893,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/260.893, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/1891.47425,))))))))*(1+PersonnelTable[[#This Row],[Salary Loading]]),\"\")","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes\", PersonnelTable[[#This Row],[No Of Units]]*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]), IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (PersonnelTable[[#This Row],[No Of Units]]*52.143)*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]),PersonnelTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"No\"),0,IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"Yes\"),INDEX(TuitionFee_Multipiler,MATCH(TuitionFee_CostType,LookupTuitionMultiplier,0),MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear_Tuition,0)), IF(AND(SCRException=\"Yes\",PersonnelTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)))","v":0.5},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"Outgoing Payment\",PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\"),0,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel\",ProjectType=\"Consultancy\"),0.428571429,\"0%\"))","v":"0%"},{"$f":"IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]], PersonnelTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Indirect Costs Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))+PersonnelTable[[#This Row],[Indirect Costs Per Unit]])*PersonnelTable[[#This Row],[Markup %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Markup Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]], PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Indirect Costs Per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Markup]], PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",PersonnelTable[[#This Row],[Cost to Client]]*1.1,PersonnelTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\", PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]], IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", PersonnelTable[[#This Row],[Indirect Costs]],IF(AND(PersonnelTable[[#This Row],[Type]]=\"Cost\",PersonnelTable[[#This Row],[Category]]<>\"Personnel - HDR\",SCRException=\"Yes\"),(0.5-PersonnelTable[[#This Row],[Indirect Costs %]])*PersonnelTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0,PersonnelTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsCasualMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsMultiplier)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", \"0\", PersonnelTable[[#This Row],[Direct Costs]]-PersonnelTable[[#This Row],[Salary Base Cost]])","v":0},{"$f":"IFERROR(IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, PersonnelTable[[#This Row],[Total Oncosts]]/PersonnelTable[[#This Row],[Salary Base Cost]]),)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualWC, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualWC)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuper, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuper)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuperPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuperPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Salary Base Cost]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualLSL)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualRec)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualParent)))","v":0},{"$f":"YEARFRAC(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)+1,PersonnelTable[[#This Row],[Start Date]]),IF((PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),IF((PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"PersonnelTable[[#This Row],[Input Currency Cost per Unit]]*PersonnelTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Salary Code]]),,\"0%\")","v":0},{"$f":"IFERROR((IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0)), IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/260.893,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/260.893, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/1891.47425,))))))))*(1+PersonnelTable[[#This Row],[Salary Loading]]),\"\")","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes\", PersonnelTable[[#This Row],[No Of Units]]*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]), IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (PersonnelTable[[#This Row],[No Of Units]]*52.143)*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]),PersonnelTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"No\"),0,IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"Yes\"),INDEX(TuitionFee_Multipiler,MATCH(TuitionFee_CostType,LookupTuitionMultiplier,0),MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear_Tuition,0)), IF(AND(SCRException=\"Yes\",PersonnelTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)))","v":0.5},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"Outgoing Payment\",PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\"),0,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel\",ProjectType=\"Consultancy\"),0.428571429,\"0%\"))","v":"0%"},{"$f":"IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]], PersonnelTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Indirect Costs Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))+PersonnelTable[[#This Row],[Indirect Costs Per Unit]])*PersonnelTable[[#This Row],[Markup %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Markup Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]], PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Indirect Costs Per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Markup]], PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",PersonnelTable[[#This Row],[Cost to Client]]*1.1,PersonnelTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\", PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]], IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", PersonnelTable[[#This Row],[Indirect Costs]],IF(AND(PersonnelTable[[#This Row],[Type]]=\"Cost\",PersonnelTable[[#This Row],[Category]]<>\"Personnel - HDR\",SCRException=\"Yes\"),(0.5-PersonnelTable[[#This Row],[Indirect Costs %]])*PersonnelTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0,PersonnelTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsCasualMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsMultiplier)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", \"0\", PersonnelTable[[#This Row],[Direct Costs]]-PersonnelTable[[#This Row],[Salary Base Cost]])","v":0},{"$f":"IFERROR(IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, PersonnelTable[[#This Row],[Total Oncosts]]/PersonnelTable[[#This Row],[Salary Base Cost]]),)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualWC, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualWC)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuper, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuper)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuperPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuperPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Salary Base Cost]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualLSL)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualRec)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualParent)))","v":0},{"$f":"YEARFRAC(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)+1,PersonnelTable[[#This Row],[Start Date]]),IF((PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),IF((PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"PersonnelTable[[#This Row],[Input Currency Cost per Unit]]*PersonnelTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Calendar Year]]),\"\",DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,{"$f":"IF(ISBLANK(PersonnelTable[[#This Row],[Salary Code]]),,\"0%\")","v":0},{"$f":"IFERROR((IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0)), IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/260.893,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\",PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\"), INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Days\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/260.893, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*SalaryOncostsMultiplier/1891.47425, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", INDEX(BaseSalaries, MATCH(PersonnelTable[[#This Row],[Salary Code]],LookupSalary,0), MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear,0))*CasualLoadingMultiplier*SalaryOncostsCasualMultiplier/1891.47425,))))))))*(1+PersonnelTable[[#This Row],[Salary Loading]]),\"\")","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes\", PersonnelTable[[#This Row],[No Of Units]]*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]), IF(PersonnelTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (PersonnelTable[[#This Row],[No Of Units]]*52.143)*(PersonnelTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],1,1),DATE(PersonnelTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]])/PersonnelTable[[#This Row],[AUD Cost per Unit]]),PersonnelTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"No\"),0,IF(AND(PersonnelTable[[#This Row],[Category]] =\"Personnel - HDR\",TuitionFeeRecException=\"Yes\"),INDEX(TuitionFee_Multipiler,MATCH(TuitionFee_CostType,LookupTuitionMultiplier,0),MATCH(PersonnelTable[[#This Row],[Calendar Year]],LookupYear_Tuition,0)), IF(AND(SCRException=\"Yes\",PersonnelTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)))","v":0.5},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"Outgoing Payment\",PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\"),0,IF(AND(PersonnelTable[[#This Row],[Category]]=\"Personnel\",ProjectType=\"Consultancy\"),0.428571429,\"0%\"))","v":"0%"},{"$f":"IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]], PersonnelTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))*PersonnelTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Indirect Costs Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", PersonnelTable[[#This Row],[AUD Cost per Unit]],PersonnelTable[[#This Row],[Output Currency Cost per Unit]]))+PersonnelTable[[#This Row],[Indirect Costs Per Unit]])*PersonnelTable[[#This Row],[Markup %]]","v":0},{"$f":"PersonnelTable[[#This Row],[Markup Per Unit]]*PersonnelTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]], PersonnelTable[[#This Row],[Output Currency Cost per Unit]]+PersonnelTable[[#This Row],[Indirect Costs Per Unit]]+PersonnelTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Markup]], PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",PersonnelTable[[#This Row],[Cost to Client]]*1.1,PersonnelTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\", PersonnelTable[[#This Row],[Direct Costs]]+PersonnelTable[[#This Row],[Indirect Costs]]+PersonnelTable[[#This Row],[Markup]], IF(PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", PersonnelTable[[#This Row],[Indirect Costs]],IF(AND(PersonnelTable[[#This Row],[Type]]=\"Cost\",PersonnelTable[[#This Row],[Category]]<>\"Personnel - HDR\",SCRException=\"Yes\"),(0.5-PersonnelTable[[#This Row],[Indirect Costs %]])*PersonnelTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",0,PersonnelTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(PersonnelTable[[#This Row],[Type]]=\"In Kind Support\",PersonnelTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,PersonnelTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsCasualMultiplier, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Direct Costs]]/SalaryOncostsMultiplier)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", \"0\", PersonnelTable[[#This Row],[Direct Costs]]-PersonnelTable[[#This Row],[Salary Base Cost]])","v":0},{"$f":"IFERROR(IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, PersonnelTable[[#This Row],[Total Oncosts]]/PersonnelTable[[#This Row],[Salary Base Cost]]),)","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualWC, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualWC)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuper, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuper)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*CasualSuperPRT, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualSuperPRT)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Salary Base Cost]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualLSL)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualRec)))","v":0},{"$f":"IF(PersonnelTable[[#This Row],[Category]]=\"Personnel - HDR\", 0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]=\"Casual Hours\",0, IF(PersonnelTable[[#This Row],[Unit Of Pay]]<>\"Casual Hours\", PersonnelTable[[#This Row],[Salary Base Cost]]*NonCasualParent)))","v":0},{"$f":"YEARFRAC(PersonnelTable[[#This Row],[Start Date]],PersonnelTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"PersonnelTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(PersonnelTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)+1,PersonnelTable[[#This Row],[Start Date]]),IF((PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(PersonnelTable[[#This Row],[Start Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]]),IF(AND(PersonnelTable[[#This Row],[Start Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30),PersonnelTable[[#This Row],[End Date]]>DATE(PersonnelTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),IF((PersonnelTable[[#This Row],[End Date]]<DATE(PersonnelTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(PersonnelTable[[#This Row],[End Date]]+1,PersonnelTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null," Totals Row ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,PersonnelTable[Direct Costs])","v":0},null,{"$f":"SUBTOTAL(109,PersonnelTable[Indirect Costs])","v":0},null,{"$f":"SUBTOTAL(109,PersonnelTable[Markup])","v":0},null,{"$f":"SUBTOTAL(109,PersonnelTable[Cost to Client])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Cost to Client inc GST])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[In Kind Support])","v":0},null,{"$f":"SUBTOTAL(109,PersonnelTable[Direct Costs Recovered])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Indirect Costs Recovered])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[60% Central Allocation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[20% Primary Faculty Allocation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[20% Secondary Faculty Allocation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Salary Base Cost])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Total Oncosts])","v":0},null,{"$f":"SUBTOTAL(109,PersonnelTable[Payroll Tax])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Workers Compensation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Superannuation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Payroll Tax on Superannuation])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Long Service Leave])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Recreation Leave])","v":0},{"$f":"SUBTOTAL(109,PersonnelTable[Parental Leave])","v":0}]
[]
[]
[]
[null,null,null,null,"Data Entry for Other Costs"]
["Input Currency Cost per Unit","Input Currency","Input Currency Rate","AUD Cost per Unit Converted from Input","Type","Category","Budget Item","Notes","Calendar Year","Start Date","End Date","Salary Code","Unit Of Pay","Salary Loading","AUD Cost per Unit","No Of Units","Prorate Units?","Apportioned Units","Indirect Costs %","Markup %","Output Currency Cost per Unit","Direct Costs","Indirect Costs Per Unit","Indirect Costs","Markup Per Unit","Markup","Cost to Client Per Unit","Cost to Client","Cost to Client inc GST","In Kind Support","Cash Support","Direct Costs Recovered","Indirect Costs Recovered","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","Salary Base Cost","Total Oncosts","Total Oncosts %","Payroll Tax","Workers Compensation","Superannuation","Payroll Tax on Superannuation","Long Service Leave","Recreation Leave","Parental Leave","CY %","FY1","FY2","FY1 % of CY %","FY2 % of CY %"]
[null,null,null,{"$f":"OtherTable[[#This Row],[Input Currency Cost per Unit]]*OtherTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(OtherTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes\", OtherTable[[#This Row],[No Of Units]]*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]), IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (OtherTable[[#This Row],[No Of Units]]*52.143)*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]),OtherTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(_xlfn.SINGLE(SCRException)=\"Yes\",OtherTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)","v":0.5},{"$f":"0%","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]], OtherTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"OtherTable[[#This Row],[Indirect Costs Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))+OtherTable[[#This Row],[Indirect Costs Per Unit]])*OtherTable[[#This Row],[Markup %]]","v":0},{"$f":"OtherTable[[#This Row],[Markup Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Markup Per Unit]], OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Indirect Costs Per Unit]]+OtherTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Markup]], OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",OtherTable[[#This Row],[Cost to Client]]*1.1,OtherTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\", OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]], IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", OtherTable[[#This Row],[Indirect Costs]],IF(AND(OtherTable[[#This Row],[Type]]=\"Cost\",SCRException=\"Yes\"),(0.5-OtherTable[[#This Row],[Indirect Costs %]])*OtherTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0,OtherTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"OtherTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"OtherTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(OtherTable[[#This Row],[Calendar Year]],6,30)+1,OtherTable[[#This Row],[Start Date]]),IF((OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),IF((OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"OtherTable[[#This Row],[Input Currency Cost per Unit]]*OtherTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(OtherTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes\", OtherTable[[#This Row],[No Of Units]]*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]), IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (OtherTable[[#This Row],[No Of Units]]*52.143)*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]),OtherTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(_xlfn.SINGLE(SCRException)=\"Yes\",OtherTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)","v":0.5},{"$f":"0%","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]], OtherTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"OtherTable[[#This Row],[Indirect Costs Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))+OtherTable[[#This Row],[Indirect Costs Per Unit]])*OtherTable[[#This Row],[Markup %]]","v":0},{"$f":"OtherTable[[#This Row],[Markup Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Markup Per Unit]], OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Indirect Costs Per Unit]]+OtherTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Markup]], OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",OtherTable[[#This Row],[Cost to Client]]*1.1,OtherTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\", OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]], IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", OtherTable[[#This Row],[Indirect Costs]],IF(AND(OtherTable[[#This Row],[Type]]=\"Cost\",SCRException=\"Yes\"),(0.5-OtherTable[[#This Row],[Indirect Costs %]])*OtherTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0,OtherTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"OtherTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"OtherTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(OtherTable[[#This Row],[Calendar Year]],6,30)+1,OtherTable[[#This Row],[Start Date]]),IF((OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),IF((OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"OtherTable[[#This Row],[Input Currency Cost per Unit]]*OtherTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(OtherTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes\", OtherTable[[#This Row],[No Of Units]]*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]), IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (OtherTable[[#This Row],[No Of Units]]*52.143)*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]),OtherTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(_xlfn.SINGLE(SCRException)=\"Yes\",OtherTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)","v":0.5},{"$f":"0%","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]], OtherTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"OtherTable[[#This Row],[Indirect Costs Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))+OtherTable[[#This Row],[Indirect Costs Per Unit]])*OtherTable[[#This Row],[Markup %]]","v":0},{"$f":"OtherTable[[#This Row],[Markup Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Markup Per Unit]], OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Indirect Costs Per Unit]]+OtherTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Markup]], OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",OtherTable[[#This Row],[Cost to Client]]*1.1,OtherTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\", OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]], IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", OtherTable[[#This Row],[Indirect Costs]],IF(AND(OtherTable[[#This Row],[Type]]=\"Cost\",SCRException=\"Yes\"),(0.5-OtherTable[[#This Row],[Indirect Costs %]])*OtherTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0,OtherTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"OtherTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"OtherTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(OtherTable[[#This Row],[Calendar Year]],6,30)+1,OtherTable[[#This Row],[Start Date]]),IF((OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),IF((OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"OtherTable[[#This Row],[Input Currency Cost per Unit]]*OtherTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(OtherTable[[#This Row],[Calendar Year]]),\"\",DATE(OtherTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(OtherTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes\", OtherTable[[#This Row],[No Of Units]]*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]), IF(OtherTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (OtherTable[[#This Row],[No Of Units]]*52.143)*(OtherTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(OtherTable[[#This Row],[Calendar Year]],1,1),DATE(OtherTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]])/OtherTable[[#This Row],[AUD Cost per Unit]]),OtherTable[[#This Row],[No Of Units]]))","v":0},{"$f":"IF(AND(_xlfn.SINGLE(SCRException)=\"Yes\",OtherTable[[#This Row],[Type]]<>\"Direct Cost w Indirect Cost as In Kind Support\"),SCR_rate,0.5)","v":0.5},{"$f":"0%","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]], OtherTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"(IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))*OtherTable[[#This Row],[Indirect Costs %]]","v":0},{"$f":"OtherTable[[#This Row],[Indirect Costs Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"((IF(OutputCurrencyOption=\"AUD\", OtherTable[[#This Row],[AUD Cost per Unit]],OtherTable[[#This Row],[Output Currency Cost per Unit]]))+OtherTable[[#This Row],[Indirect Costs Per Unit]])*OtherTable[[#This Row],[Markup %]]","v":0},{"$f":"OtherTable[[#This Row],[Markup Per Unit]]*OtherTable[[#This Row],[Apportioned Units]]","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Markup Per Unit]], OtherTable[[#This Row],[Output Currency Cost per Unit]]+OtherTable[[#This Row],[Indirect Costs Per Unit]]+OtherTable[[#This Row],[Markup Per Unit]]))","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0, IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\",OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Markup]], OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]]))","v":0},{"$f":"IF(ClientGST=\"Yes\",OtherTable[[#This Row],[Cost to Client]]*1.1,OtherTable[[#This Row],[Cost to Client]])","v":0},{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\", OtherTable[[#This Row],[Direct Costs]]+OtherTable[[#This Row],[Indirect Costs]]+OtherTable[[#This Row],[Markup]], IF(OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\", OtherTable[[#This Row],[Indirect Costs]],IF(AND(OtherTable[[#This Row],[Type]]=\"Cost\",SCRException=\"Yes\"),(0.5-OtherTable[[#This Row],[Indirect Costs %]])*OtherTable[[#This Row],[Direct Costs]],)))","v":0},null,{"$f":"IF(OtherTable[[#This Row],[Type]]=\"In Kind Support\",0,OtherTable[[#This Row],[Direct Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]])","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.6)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},{"$f":"IF(OR(OtherTable[[#This Row],[Type]]=\"In Kind Support\",OtherTable[[#This Row],[Type]]=\"Direct Cost w Indirect Cost as In Kind Support\"),0,OtherTable[[#This Row],[Indirect Costs]]*0.2)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(OtherTable[[#This Row],[Start Date]],OtherTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"OtherTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"OtherTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(OtherTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(OtherTable[[#This Row],[Calendar Year]],6,30)+1,OtherTable[[#This Row],[Start Date]]),IF((OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(OtherTable[[#This Row],[Start Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]]),IF(AND(OtherTable[[#This Row],[Start Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],6,30),OtherTable[[#This Row],[End Date]]>DATE(OtherTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),IF((OtherTable[[#This Row],[End Date]]<DATE(OtherTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(OtherTable[[#This Row],[End Date]]+1,OtherTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Totals Row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,OtherTable[Direct Costs])","v":0},null,{"$f":"SUBTOTAL(109,OtherTable[Indirect Costs])","v":0},null,{"$f":"SUBTOTAL(109,OtherTable[Markup])","v":0},null,{"$f":"SUBTOTAL(109,OtherTable[Cost to Client])","v":0},{"$f":"SUBTOTAL(109,OtherTable[Cost to Client inc GST])","v":0},{"$f":"SUBTOTAL(109,OtherTable[In Kind Support])","v":0},null,{"$f":"SUBTOTAL(109,OtherTable[Direct Costs Recovered])","v":0},{"$f":"SUBTOTAL(109,OtherTable[Indirect Costs Recovered])","v":0},{"$f":"SUBTOTAL(109,OtherTable[60% Central Allocation])","v":0},{"$f":"SUBTOTAL(109,OtherTable[20% Primary Faculty Allocation])","v":0},{"$f":"SUBTOTAL(109,OtherTable[20% Secondary Faculty Allocation])","v":0}]
[null,null,null,null,null,null,"🛈 Costing UQ Research Facility Usage? See UQ Research Infrastructure Guide to Grants"]
[]
[]
[null,null,null,null,"Data Entry for Cash Contributions"]
["Input Currency Cost per Unit","Input Currency","Input Currency Rate","AUD Cost per Unit Converted from Input","Type","Category","Budget Item","Notes","Calendar Year","Start Date","End Date","Salary Code","Unit Of Pay","Salary Loading","AUD Cost per Unit","No Of Units","Prorate Units?","Apportioned Units","Indirect Costs %","Markup %","Output Currency Cost per Unit","Direct Costs","Indirect Costs Per Unit","Indirect Costs","Markup Per Unit","Markup","Cost to Client Per Unit","Cost to Client","Cost to Client inc GST","In Kind Support","Cash Support","Direct Costs Recovered","Indirect Costs Recovered","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","Salary Base Cost","Total Oncosts","Total Oncosts %","Payroll Tax","Workers Compensation","Superannuation","Payroll Tax on Superannuation","Long Service Leave","Recreation Leave","Parental Leave","CY %","FY1","FY2","FY1 % of CY %","FY2 % of CY %"]
[null,null,null,{"$f":"CashTable[[#This Row],[Input Currency Cost per Unit]]*CashTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(CashTable[[#This Row],[Calendar Year]]),\"\",DATE(CashTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(CashTable[[#This Row],[Calendar Year]]),\"\",DATE(CashTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(CashTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(CashTable[[#This Row],[Prorate Units?]]=\"Yes\", CashTable[[#This Row],[No Of Units]]*(CashTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(CashTable[[#This Row],[Calendar Year]],1,1),DATE(CashTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]])/CashTable[[#This Row],[AUD Cost per Unit]]), IF(CashTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (CashTable[[#This Row],[No Of Units]]*52.143)*(CashTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(CashTable[[#This Row],[Calendar Year]],1,1),DATE(CashTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]])/CashTable[[#This Row],[AUD Cost per Unit]]),CashTable[[#This Row],[No Of Units]]))","v":0},null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\", CashTable[[#This Row],[AUD Cost per Unit]], CashTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(IF(OutputCurrencyOption=\"AUD\", CashTable[[#This Row],[AUD Cost per Unit]],CashTable[[#This Row],[Output Currency Cost per Unit]]))*CashTable[[#This Row],[Apportioned Units]]","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"CashTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(CashTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"CashTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(CashTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1),CashTable[[#This Row],[End Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]]),IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(CashTable[[#This Row],[Calendar Year]],6,30)+1,CashTable[[#This Row],[Start Date]]),IF((CashTable[[#This Row],[Start Date]]>DATE(CashTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(CashTable[[#This Row],[Start Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]]),IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],6,30),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,DATE(CashTable[[#This Row],[Calendar Year]],7,1)),IF((CashTable[[#This Row],[End Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,{"$f":"CashTable[[#This Row],[Input Currency Cost per Unit]]*CashTable[[#This Row],[Input Currency Rate]]","v":0},null,null,null,null,null,{"$f":"IF(ISBLANK(CashTable[[#This Row],[Calendar Year]]),\"\",DATE(CashTable[[#This Row],[Calendar Year]],1,1))","v":""},{"$f":"IF(ISBLANK(CashTable[[#This Row],[Calendar Year]]),\"\",DATE(CashTable[[#This Row],[Calendar Year]],12,31))","v":""},null,null,null,null,null,{"$f":"IF(CashTable[[#This Row],[Unit Of Pay]]=\"Annual Salary\", \"Yes\", \"No\")","v":"No"},{"$f":"IF(CashTable[[#This Row],[Prorate Units?]]=\"Yes\", CashTable[[#This Row],[No Of Units]]*(CashTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(CashTable[[#This Row],[Calendar Year]],1,1),DATE(CashTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]])/CashTable[[#This Row],[AUD Cost per Unit]]), IF(CashTable[[#This Row],[Prorate Units?]]=\"Yes - Per Week\", (CashTable[[#This Row],[No Of Units]]*52.143)*(CashTable[[#This Row],[AUD Cost per Unit]]/NETWORKDAYS(DATE(CashTable[[#This Row],[Calendar Year]],1,1),DATE(CashTable[[#This Row],[Calendar Year]],12,31))*NETWORKDAYS(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]])/CashTable[[#This Row],[AUD Cost per Unit]]),CashTable[[#This Row],[No Of Units]]))","v":0},null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\", CashTable[[#This Row],[AUD Cost per Unit]], CashTable[[#This Row],[AUD Cost per Unit]]*OutputCurrencyRate)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(IF(OutputCurrencyOption=\"AUD\", CashTable[[#This Row],[AUD Cost per Unit]],CashTable[[#This Row],[Output Currency Cost per Unit]]))*CashTable[[#This Row],[Apportioned Units]]","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEARFRAC(CashTable[[#This Row],[Start Date]],CashTable[[#This Row],[End Date]]+1,0)","v":{"$error":"#VALUE!"}},{"$f":"CashTable[[#This Row],[Calendar Year]]-1&\" - \"&RIGHT(CashTable[[#This Row],[Calendar Year]],2)","v":"-1 - "},{"$f":"CashTable[[#This Row],[Calendar Year]]&\" - \"&RIGHT(CashTable[[#This Row],[Calendar Year]]+1,2)","v":" - 1"},{"$f":"IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1),CashTable[[#This Row],[End Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]]),IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(DATE(CashTable[[#This Row],[Calendar Year]],6,30)+1,CashTable[[#This Row],[Start Date]]),IF((CashTable[[#This Row],[Start Date]]>DATE(CashTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(CashTable[[#This Row],[Start Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]]),IF(AND(CashTable[[#This Row],[Start Date]]<DATE(CashTable[[#This Row],[Calendar Year]],6,30),CashTable[[#This Row],[End Date]]>DATE(CashTable[[#This Row],[Calendar Year]],6,30)),_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,DATE(CashTable[[#This Row],[Calendar Year]],7,1)),IF((CashTable[[#This Row],[End Date]]<DATE(CashTable[[#This Row],[Calendar Year]],7,1)),0,)))/_xlfn.DAYS(CashTable[[#This Row],[End Date]]+1,CashTable[[#This Row],[Start Date]])","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Totals Row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,CashTable[Cash Support])","v":0},{"$f":"SUBTOTAL(109,CashTable[Direct Costs Recovered])","v":0},{"$f":"SUBTOTAL(109,CashTable[Indirect Costs Recovered])","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Set Options to Create Pivot Reports"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"🛈"]
[null,null,null,null,null,"Options for Cost Summary",null,null,null,"Options for Client Report",null,null,null,null,null,null,"🛈"]
[null,null,null,null,null,"Year options:","Calendar Year",null,null,"Year options:","Calendar Year"]
[null,null,null,null,null,"Include type:","Yes",null,null,"Include units:","No"]
[null,null,null,null,null,"Include category:","No",null,null,"Include budget items:","Yes"]
[null,null,null,null,null,"Include budget item:","No",null,null,"Include in kind support:","Yes"]
[null,null,null,null,null,"Include item notes:","No",null,null,"Include cash support:","No",null,null,"Reports will reflect the selected Output Currency options. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" 🛈 Output Currency is set at \"&IF(OutputCurrencyOption=\"AUD\", \"AUD\",OutputCurrency)&\".\"","v":" 🛈 Output Currency is set at AUD."}]
[]
[]
[]
[null,null,null,null,"Milestone Totals"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"🛈",null,null,"Costing & Pricing Components are shown in the indicated Output Currency.",null,null,null,null,null,null,null,null,"Internal allocation of Recovered Costs & Markup are always shown in AUD."]
[null,null,null,null,null,"🛈","🛈","- OR - ",null,null,{"$f":"\" 🛈 Output Currency is set at \"&IF(OutputCurrencyOption=\"AUD\", \"AUD\",OutputCurrency)&\".\"","v":" 🛈 Output Currency is set at AUD."},null,null,null,null,null,null,null,null,"Direct Costs","Indirect Costs",null,null,null,"Markup"]
[null,null,null,null,"Milestone Title","Payment Year","Funding Provider","Set by Amount (AUD)","Set by Percentage","Milestone Percentage","Direct Costs","Indirect Costs","Total Markup","In Kind Support","Cash Support","Cost to Client","GST","Cost to Client inc GST","Total (Direct + Markup)","Project Account","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","ACA Account (Net Amount) ","OU Margin","Project Account  "]
[null,null,null,null,"A",2024,"Provider 1",null,0.4,{"$f":"IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Amount (AUD)]]), MilestoneTable[[#This Row],[Set by Amount (AUD)]]/TotalCostToClientAUD, IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Percentage]]), MilestoneTable[[#This Row],[Set by Percentage]],\"\"))","v":0.4},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalIndirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalInKindSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCashSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientOutput,\"\")","v":0},{"$f":"IFERROR(IF(ClientGST=\"Yes\",'Data Entry'!$P117*0.1,0),\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientIncGSTOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Direct Costs]]+MilestoneTable[[#This Row],[Total Markup]],\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDCToProjectAccount,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads60,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalICToACA,\"\")","v":""},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToOU,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToProjectAccount,\"\")","v":0}]
[null,null,null,null,"B",2025,"Provider 1",null,0.1,{"$f":"IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Amount (AUD)]]), MilestoneTable[[#This Row],[Set by Amount (AUD)]]/TotalCostToClientAUD, IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Percentage]]), MilestoneTable[[#This Row],[Set by Percentage]],\"\"))","v":0.1},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalIndirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalInKindSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCashSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientOutput,\"\")","v":0},{"$f":"IFERROR(IF(ClientGST=\"Yes\",'Data Entry'!$P118*0.1,0),\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientIncGSTOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Direct Costs]]+MilestoneTable[[#This Row],[Total Markup]],\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDCToProjectAccount,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads60,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalICToACA,\"\")","v":""},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToOU,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToProjectAccount,\"\")","v":0}]
[null,null,null,null,"C",2026,"Provider 2",null,0.25,{"$f":"IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Amount (AUD)]]), MilestoneTable[[#This Row],[Set by Amount (AUD)]]/TotalCostToClientAUD, IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Percentage]]), MilestoneTable[[#This Row],[Set by Percentage]],\"\"))","v":0.25},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalIndirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalInKindSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCashSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientOutput,\"\")","v":0},{"$f":"IFERROR(IF(ClientGST=\"Yes\",'Data Entry'!$P119*0.1,0),\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientIncGSTOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Direct Costs]]+MilestoneTable[[#This Row],[Total Markup]],\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDCToProjectAccount,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads60,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalICToACA,\"\")","v":""},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToOU,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToProjectAccount,\"\")","v":0}]
[null,null,null,null,"D",2027,"Provider 3",null,0.13,{"$f":"IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Amount (AUD)]]), MilestoneTable[[#This Row],[Set by Amount (AUD)]]/TotalCostToClientAUD, IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Percentage]]), MilestoneTable[[#This Row],[Set by Percentage]],\"\"))","v":0.13},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalIndirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalInKindSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCashSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientOutput,\"\")","v":0},{"$f":"IFERROR(IF(ClientGST=\"Yes\",'Data Entry'!$P120*0.1,0),\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientIncGSTOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Direct Costs]]+MilestoneTable[[#This Row],[Total Markup]],\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDCToProjectAccount,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads60,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalICToACA,\"\")","v":""},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToOU,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToProjectAccount,\"\")","v":0}]
[null,null,null,null,"D",2028,"Provider 3",null,0.12,{"$f":"IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Amount (AUD)]]), MilestoneTable[[#This Row],[Set by Amount (AUD)]]/TotalCostToClientAUD, IF(ISNUMBER(MilestoneTable[[#This Row],[Set by Percentage]]), MilestoneTable[[#This Row],[Set by Percentage]],\"\"))","v":0.12},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalIndirectCostsOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalInKindSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCashSupportOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientOutput,\"\")","v":0},{"$f":"IFERROR(IF(ClientGST=\"Yes\",'Data Entry'!$P121*0.1,0),\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalCostToClientIncGSTOutput,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Direct Costs]]+MilestoneTable[[#This Row],[Total Markup]],\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalDCToProjectAccount,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads60,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalOverheads20,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalICToACA,\"\")","v":""},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToOU,\"\")","v":0},{"$f":"IFERROR(MilestoneTable[[#This Row],[Milestone Percentage]]*TotalMarkupToProjectAccount,\"\")","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,"Working Totals: Costing & Pricing Components by Calendar Year"]
[null,null,null,null,"Overwrite the value in the 'Year' cell to view alternative years. "]
[null,null,null,null,null,null,null,null,"🛈","🛈","🛈","🛈"]
[null,null,null,null,null,null,null,null,"Direct Costs","Indirect Costs","Total Markup","In Kind Support","Cash Support","Cost to Client","GST","Cost to Client inc GST"]
[null,null,null,null,null,"Year:",{"$f":"MIN(PersonnelTable[Calendar Year],OtherTable[Calendar Year],CashTable[Calendar Year])","v":0},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear1,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear1,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear1,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear1,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N131*0.1,0)","v":0},{"$f":"N131+O131","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear1,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear1,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear1,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear1,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear1,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear1,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear1,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear1,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear1,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear1,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear1,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N132*0.1,0)","v":0},{"$f":"N132+O132","v":0}]
[]
[null,null,null,null,null,"Year:",{"$f":"G131+1","v":1},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear2,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear2,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear2,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear2,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N134*0.1,0)","v":0},{"$f":"N134+O134","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear2,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear2,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear2,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear2,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear2,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear2,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear2,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear2,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear2,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear2,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear2,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N135*0.1,0)","v":0},{"$f":"N135+O135","v":0}]
[]
[null,null,null,null,null,"Year:",{"$f":"G134+1","v":2},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear3,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear3,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear3,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear3,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N137*0.1,0)","v":0},{"$f":"N137+O137","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear3,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear3,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear3,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear3,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear3,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear3,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear3,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear3,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear3,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear3,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear3,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N138*0.1,0)","v":0},{"$f":"N138+O138","v":0}]
[]
[null,null,null,null,null,"Year:",{"$f":"G137+1","v":3},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear4,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear4,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear4,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear4,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N140*0.1,0)","v":0},{"$f":"N140+O140","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear4,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear4,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear4,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear4,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear4,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear4,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear4,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear4,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear4,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear4,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear4,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N141*0.1,0)","v":0},{"$f":"N141+O141","v":0}]
[]
[null,null,null,null,null,"Year:",{"$f":"G140+1","v":4},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear5,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear5,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear5,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear5,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N143*0.1,0)","v":0},{"$f":"N143+O143","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear5,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear5,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear5,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear5,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear5,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear5,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear5,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear5,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear5,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear5,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear5,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N144*0.1,0)","v":0},{"$f":"N144+O144","v":0}]
[]
[null,null,null,null,null,"Year:",{"$f":"G143+1","v":5},"AUD:",{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Direct Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Direct Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Indirect Costs]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Indirect Costs]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Markup]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Markup]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[In Kind Support]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[In Kind Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":" IF(OutputCurrencyOption=\"AUD\",\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear6,     CashTable[Cash Support]),0)),\n(IF(HasCashSupport=\"Yes\",  SUMIF(CashTable[Calendar Year],   WorkingTotalsYear6,     CashTable[Cash Support]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(OutputCurrencyOption=\"AUD\",\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Cost to Client]),0)),\n(IF(HasPersonnel=\"Yes\",   SUMIF(PersonnelTable[Calendar Year],   WorkingTotalsYear6,     PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",  SUMIF(OtherTable[Calendar Year],          WorkingTotalsYear6,     OtherTable[Cost to Client]),0))\n/OutputCurrencyRate)","v":0},{"$f":"IF(ClientGST=\"Yes\",N146*0.1,0)","v":0},{"$f":"N146+O146","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(OutputCurrencyOption=\"AUD\",\"Output in AUD:\",\"Output in \"&OutputCurrency&\":\")","v":"Output in AUD:"},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear6,       PersonnelTable[Direct Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear6,       OtherTable[Direct Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear6,       PersonnelTable[Indirect Costs]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear6,        OtherTable[Indirect Costs]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear6,       PersonnelTable[Markup]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear6,        OtherTable[Markup]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear6,       PersonnelTable[In Kind Support]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],             WorkingTotalsYear6,        OtherTable[In Kind Support]),0)","v":0},{"$f":"IF(HasCashSupport=\"Yes\", SUMIF(CashTable[Calendar Year],   WorkingTotalsYear6,     CashTable[Cash Support]),0)","v":0},{"$f":"IF(HasPersonnel=\"Yes\",SUMIF(PersonnelTable[Calendar Year],       WorkingTotalsYear6,       PersonnelTable[Cost to Client]),0)\n+IF(HasOtherCosts=\"Yes\",SUMIF(OtherTable[Calendar Year],              WorkingTotalsYear6,       OtherTable[Cost to Client]),0)","v":0},{"$f":"IF(ClientGST=\"Yes\",N147*0.1,0)","v":0},{"$f":"N147+O147","v":0}]

{"sheet":"Admin-ProRata","index":2,"n_rows":9,"n_cols":25,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Type","Category","Budget Item","Notes","Calendar Year","Start Date","End Date","Apportioned Units","Direct Costs","Indirect Costs","Markup","Cost to Client","Cost to Client inc GST","In Kind Support","Cash Support","Direct Costs Recovered","Indirect Costs Recovered","60% Central Allocation","20% Primary Faculty Allocation","20% Secondary Faculty Allocation","Financial Year","FY%","Block","ACA Overheads","Total Cost"]
["Cost","Personnel","test",null,2024,"2024-01-01","2024-12-31",0.49726775956284153,133447.93891101456,66723.969455507278,null,200171.90836652182,220189.09920317403,null,null,133447.93891101456,66723.969455507278,40034.381673304364,13344.793891101455,13344.793891101455,"2023 - 24",0.49726775956284153,{"$f":"IF(A2=\"In Kind Support\",0,I2+K2)","v":133447.93891101456},{"$f":"Q2","v":66723.969455507278},{"$f":"M2","v":220189.09920317403}]
["Cost","Personnel","test2",null,2025,"2025-01-01","2025-12-31",0.49589041095890413,111324.632937553,55662.316468776502,null,166986.94940632951,183685.64434696248,null,null,111324.632937553,55662.316468776502,33397.389881265903,11132.463293755301,11132.463293755301,"2024 - 25",0.49589041095890413,111324.632937553,55662.316468776502,183685.64434696248]
["Cost","Personnel","test3",null,2026,"2026-01-01","2026-12-31",0.49589041095890413,105249.56160217122,52624.78080108561,null,157874.34240325683,173661.7766435825,null,null,105249.56160217122,52624.78080108561,31574.868480651363,10524.956160217122,10524.956160217122,"2025 - 26",0.49589041095890413,105249.56160217122,52624.78080108561,173661.7766435825]
["In Kind Support","Personnel","ibi",null,2024,"2024-01-01","2024-12-31",9.9453551912568314E-2,20762.50820942405,10381.254104712025,null,null,null,31143.762314136078,null,null,null,null,null,null,"2023 - 24",0.49726775956284153,0,0,0]
["Cost","Personnel","test",null,2024,"2024-01-01","2024-12-31",0.50273224043715847,134914.39977816856,67457.199889084281,null,202371.59966725286,222608.75963397816,null,null,134914.39977816856,67457.199889084281,40474.319933450563,13491.439977816857,13491.439977816857,"2024 - 25",0.50273224043715847,134914.39977816856,67457.199889084281,222608.75963397816]
["Cost","Personnel","test2",null,2025,"2025-01-01","2025-12-31",0.50410958904109593,113169.79259950141,56584.896299750704,null,169754.6888992521,186730.15778917732,null,null,113169.79259950141,56584.896299750704,33950.937779850421,11316.979259950142,11316.979259950142,"2025 - 26",0.50410958904109593,113169.79259950141,56584.896299750704,186730.15778917732]
["Cost","Personnel","test3",null,2026,"2026-01-01","2026-12-31",0.50410958904109593,106994.02947403041,53497.014737015204,null,160491.04421104561,176540.14863215017,null,null,106994.02947403041,53497.014737015204,32098.208842209122,10699.402947403041,10699.402947403041,"2026 - 27",0.50410958904109593,106994.02947403041,53497.014737015204,176540.14863215017]
["In Kind Support","Personnel","ibi",null,2024,"2024-01-01","2024-12-31",0.1005464480874317,20990.667640296844,10495.333820148422,null,null,null,31486.001460445263,null,null,null,null,null,null,"2024 - 25",0.50273224043715847,0,0,0]

{"sheet":"Admin - Tuition Fee","index":3,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,0,5,0]]}
[null,"Tuition Fee Table",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,null,"Percentage to be recovered",{"$f":"TuitionFree_RecovPercent","v":0.5}]
[null,"Tuition Fee - High Band",48040,{"$f":"C2*1.03","v":49481.200000000004},{"$f":"D2*1.03","v":50965.636000000006},52494.605080000008,54069.443232400008,55691.526529372008,57362.272325253172,59083.140495010768,60855.634709861093,62681.303751156927,64561.742863691637,66498.595149602392,68493.55300409047]
[null,"Tuition Fee - Low Band",38400,{"$f":"C3*1.03","v":39552},{"$f":"D3*1.03","v":40738.559999999998},41960.716800000002,43219.538304000002,44516.124453119999,45851.608186713602,47227.156432315009,48643.971125284457,50103.290259042995,51606.388966814287,53154.580635818718,54749.218054893281]
[null,"HDR Stipend",{"$f":"'Admin-Salaries'!F4","v":32192},{"$f":"'Admin-Salaries'!G4","v":33640.639999999999},{"$f":"'Admin-Salaries'!H4","v":34999.721855999996},{"$f":"'Admin-Salaries'!I4","v":35699.71629312},{"$f":"'Admin-Salaries'!J4","v":36413.710618982397},{"$f":"'Admin-Salaries'!K4","v":37141.984831362046},{"$f":"'Admin-Salaries'!L4","v":37884.824527989287},{"$f":"'Admin-Salaries'!M4","v":38642.521018549072},{"$f":"'Admin-Salaries'!N4","v":39415.371438920054},{"$f":"'Admin-Salaries'!O4","v":40203.678867698458},{"$f":"'Admin-Salaries'!P4","v":41007.752445052429},{"$f":"'Admin-Salaries'!Q4","v":41827.907493953477},{"$f":"'Admin-Salaries'!R4","v":42664.465643832547}]
["Tuition Fee Multiplier","Band A",{"$f":"C2/C4*$R$1","v":0.74614811133200798},{"$f":"D2/D4*$R$1","v":0.73543785136073514},0.72808630036674105,0.73522440135072864,0.74243248371691228,0.74971123355727409,0.75706134369018863,0.76448351372636703,0.77197845013544897,0.77954686631324754,0.78718948264965194,0.79490702659719759,0.80270023274030744]
[null,"Band B",{"$f":"C3/C4*$R$1","v":0.59642147117296218},{"$f":"D3/D4*$R$1","v":0.58786039742406804},0.58198405358207428,0.58768977959758484,0.59345144410344353,0.59926959551622239,0.60514478762912649,0.61107757966470622,0.61706853632808567,0.62311822786071391,0.62922723009464254,0.63539612450733507,0.64162549827701487]

{"sheet":"Admin - SCR","index":4,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["SCR","2019 - 2021 Average"]
[null," Direct Indirect W/ P&F & CMAD ","If required?"]
["TOTAL",{"$f":"SUMIF(C4:C27,\"Yes\",B4:B27)","v":0.31440000000000001}]
["COO",{"$f":"SUM(B5:B11)","v":0.24229999999999999}]
["Finance support",5.7099999999999998E-2,"Yes"]
["Governance & Risk Management",0.04,"Yes"]
["HR support",4.6699999999999998E-2,"Yes"]
["Information Technology Services (ex. CIO)",8.0600000000000005E-2,"Yes"]
["Marketing & Communication",1.01E-2,{"$f":"SCR_MktComm","v":"No"}]
["Office of the CFO, CHRO and CIO",2.8E-3,"No"]
["Office of the Chief Operating Office",5.0000000000000001E-3,"No"]
["DVCR",{"$f":"SUM(B13:B20)","v":9.0900000000000009E-2}]
["Office of the DVC Research (& Research Impact activities)",1.8599999999999998E-2,"No"]
["Office of Research Ethics & Integrity",8.3000000000000001E-3,{"$f":"SCR_OffResEthicsIntegrity","v":"No"}]
["Research Office",1.72E-2,"Yes"]
["Office of the PVC (Research)",6.9999999999999999E-4,"No"]
["PVC Research & International",0,"No"]
["Research Infrastructure",6.4000000000000003E-3,"No"]
["Research Partnership Managers/ Business Dev't",1.55E-2,"Yes"]
["Grad School (ex Scholarships)",2.4199999999999999E-2,{"$f":"SCR_GradSchool","v":"No"}]
["DVCEE",{"$f":"SUM(B22:B22)","v":5.7999999999999996E-3}]
["Global Engagement & Entrepreneurship, Future Students & Office of DVC (EE)",5.7999999999999996E-3,"No"]
["DVCA",{"$f":"SUM(B24:B26)","v":6.6699999999999995E-2}]
["PVC T&L, Office of the DVCA, & Academic Services Division",5.7999999999999996E-3,"No"]
["Student Affairs Division",3.5999999999999999E-3,"No"]
["UQ Library",5.7299999999999997E-2,"Yes"]
["EXEC",2.7900000000000001E-2]
[]
[null,{"$f":"SCR_EXEC+SCR_DVCA+SCR_DVCEE+SCR_DVCR+SCR_COO","v":0.43359999999999999}]

{"sheet":"Admin-Salaries","index":5,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["BaseSalary",2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035]
["Senior Administrative (as entered)"]
["Other (as entered)"]
["HDR Stipend",27596,28092,28597,28854,32192,{"$f":"F4*(100%+4.5%)","v":33640.639999999999},{"$f":"G4*(100%+4.04%)","v":34999.721855999996},{"$f":"H4*(100%+2%)","v":35699.71629312},{"$f":"I4*(100%+2%)","v":36413.710618982397},{"$f":"J4*(100%+2%)","v":37141.984831362046},37884.824527989287,38642.521018549072,39415.371438920054,40203.678867698458,41007.752445052429,41827.907493953477,42664.465643832547]
["Academic E1",181964.84904659999,185422.18117848536,189130.62480205507,192913.23729809618,198700.63,208288.73,216703.59,221037.66,{"$f":"I5*(100%+2%)","v":225458.41320000001},{"$f":"J5*(100%+2%)","v":229967.58146400002},{"$f":"K5*(100%+2%)","v":234566.93309328001},{"$f":"L5*(100%+2%)","v":239258.2717551456},{"$f":"M5*(100%+2%)","v":244043.43719024851},{"$f":"N5*(100%+2%)","v":248924.3059340535},{"$f":"O5*(100%+2%)","v":253902.79205273459},{"$f":"P5*(100%+2%)","v":258980.84789378929},{"$f":"Q5*(100%+2%)","v":264160.46485166508}]
["Academic D4",155627.8329258,158584.76175139018,161756.45698641796,164991.58612614634,169941.34,178367.57,185573.62,189285.09,193070.79180000001,196932.20763600001,200870.85178872,204888.26882449441,208986.03420098432,213165.75488500402,217429.0699827041,221777.65138235819,226213.20441000536]
["Academic D3",150839.35729679998,153705.30508543918,156779.41118714795,159914.99941089092,164712.46,172927.44,179913.71,183511.98,187182.21960000001,190925.86399200003,194744.38127184004,198639.26889727684,202612.05427522238,206664.29536072683,210797.58126794136,215013.5328933002,219313.8035511662]
["Academic D2",146050.31000880001,148825.26589896719,151801.77121694654,154837.80664128545,159482.95000000001,167486.66,174253.12,177738.18,181292.9436,184918.80247200001,188617.17852144002,192389.52209186883,196237.31253370619,200162.05878438032,204165.29996006793,208248.60595926931,212413.57807845471]
["Academic D1",141261.8551674,143945.8304155806,146824.74702389221,149761.24196437004,154254.09,162046.54999999999,168593.23,171965.09,175404.39180000001,178912.479636,182490.72922872001,186140.54381329441,189863.35468956031,193660.62178335153,197533.83421901855,201484.51090339891,205514.2011214669]
["Academic C6",135276.25283579997,137846.50163968015,140603.43167247376,143415.50030592325,147717.97,155246.38,161518.32999999999,164748.70000000001,168043.67400000003,171404.54748000004,174832.63842960005,178329.29119819205,181895.87702215588,185533.79456259901,189244.47045385098,193029.35986292802,196889.94706018659]
["Academic C5",131685.49635599999,134187.52078676398,136871.27120249928,139608.69662654927,143796.95000000001,151166.95000000001,157274.09,160419.57,163627.9614,166900.520628,170238.53104055999,173643.3016613712,177116.16769459861,180658.4910484906,184271.66086946041,187957.09408684963,191716.23596858661]
["Academic C4",128094.698301,130528.49756871897,133139.06752009335,135801.84887049522,139875.91,147087.5,153029.82999999999,156090.43,159212.23859999998,162396.48337199999,165644.41303944,168957.30130022881,172336.44732623338,175783.17627275805,179298.83979821322,182884.81659417748,186542.51292606103]
["Academic C3",124502.1436938,126867.68442398217,129405.0381124618,131993.13887471103,135952.92000000001,143006.01999999999,148783.46,151759.13,154794.3126,157890.198852,161048.00282903999,164268.9628856208,167554.34214333323,170905.4289861999,174323.53756592391,177810.00831724238,181366.20848358722]
["Academic C2",120911.37682019999,123208.69297978378,125672.86683937945,128186.32417616705,132031.92000000001,138926.60999999999,144539.24,147430.01999999999,150378.62039999999,153386.19280799999,156453.91666416,159582.99499744319,162774.65489739206,166030.14799533991,169350.75095524671,172737.76597435164,176192.52129383868]
["Academic C1",117319.45623479999,119548.52590326116,121939.4964213264,124378.28634975293,128109.64,134845.87,140293.64000000001,143099.51999999999,145961.5104,148880.74060799999,151858.35542015999,154895.52252856319,157993.43297913446,161153.30163871715,164376.36767149149,167663.89502492134,171017.17292541976]
["Academic B6",113728.12809599997,115888.96252982397,118206.74178042045,120570.87661602884,124187.98,130765.78,136048.72,138769.70000000001,141545.09400000001,144375.99588,147263.5157976,150208.78611355202,153212.96183582305,156277.22107253951,159402.7654939903,162590.8208038701,165842.6372199475]
["Academic B5",110136.69601919998,112229.29324356478,114473.87910843607,116763.35669060479,120266.27,126685.63,131803.73000000001,134439.79999999999,137128.59599999999,139871.16792000001,142668.59127840001,145521.96310396801,148432.40236604738,151401.05041336833,154429.07142163569,157517.65285006841,160668.00590706978]
["Academic B4",106545.388668,108569.75105269199,110741.14607374584,112955.96899522076,116344.65,122605.57,127558.83,130110.01,132712.2102,135366.45440400002,138073.78349208002,140835.25916192163,143651.96434516006,146525.00363206325,149455.50370470452,152444.61377879861,155493.50605437459]
["Academic B3",102954.018954,104910.14531412598,107008.3482204085,109148.51518481667,112422.98,118525.47,123313.9,125780.18,128295.7836,130861.699272,133478.93325743999,136148.5119225888,138871.48216104059,141648.91180426141,144481.89004034665,147371.52784115358,150318.95839797665]
["Academic B2",99362.628452399993,101250.51839299558,103275.52876085551,105341.03933607262,108501.27,114445.32,119068.91,121450.29,123879.29579999999,126356.88171599999,128884.01935031998,131461.69973732639,134090.93373207291,136772.75240671437,139508.20745484866,142298.37160394562,145144.33903602452]
["Academic B1",95771.321101199996,97590.97620212278,99542.795726165234,101533.65164068853,104579.67,110365.29,114824.05,117120.53,119462.9406,121852.199412,124289.24340024,126775.0282682448,129310.5288336097,131896.73941028191,134534.67419848754,137225.36768245729,139969.87503610644]
["Academic A8",90982.263419399998,92782.263419399998,94637.908687788004,96530.666861543767,99426.59,105004.02,109246.18,111431.1,113659.72200000001,115932.91644000002,118251.57476880001,120616.60626417601,123028.93838945952,125489.51715724872,127999.3075003937,130559.29365040157,133170.47952340959]
["Academic A7",87930.844889999993,89730.844889999993,91525.461787799999,93355.971023555991,96156.65,101601.98,105706.7,107820.83,109977.2466,112176.791532,114420.32736264,116708.73390989281,119042.90858809066,121423.76675985249,123852.24209504954,126329.28693695054,128855.87267568955]
["Academic A6",84878.420199999993,86678.420199999993,88411.988603999998,90180.228376080006,92885.64,98198.82,102166.05,104209.37,106293.55739999999,108419.428548,110587.81711896,112799.5734613392,115055.56493056599,117356.6762291773,119703.80975376086,122097.88594883608,124539.84366781281]
["Academic A5",81827.768569999986,83627.768569999986,85300.323941399984,87006.330420227983,89616.53,94797.64,98627.46,100600.01,102612.01019999999,104664.25040399999,106757.53541207999,108892.6861203216,111070.53984272803,113291.95063958259,115557.78965237424,117868.94544542172,120226.32435433015]
["Academic A4",78775.934899999993,80575.934899999993,82187.453597999993,83831.202669959996,86346.14,91395.12,95087.48,96989.23,98929.014599999995,100907.59489199999,102925.74678983999,104984.2617256368,107083.94696014954,109225.62589935253,111410.13841733958,113638.34118568637,115911.10800940009]
["Academic A3",75019.564629999993,76819.564629999993,78355.955922599998,79923.075041051998,82320.759999999995,87207.12,90730.29,92544.89,94395.787800000006,96283.703556000008,98209.377627120004,100173.5651796624,102177.03648325565,104220.57721292076,106304.98875717918,108431.08853232276,110599.71030296921]
["Academic A2",71264.345830000006,73064.345830000006,74525.632746599993,76016.145401532005,78296.63,83020.41,86374.44,88101.93,89863.968599999993,91661.247971999997,93494.472931440003,95364.362390068811,97271.649637870185,99217.082630627585,101201.42428324014,103225.45276890494,105289.96182428305]
["Academic A1",67542.886499999993,69342.886499999993,70729.744229999997,72144.339114599992,74308.679999999993,78871.350000000006,82057.75,83698.91,85372.888200000001,87080.345964000007,88821.952883280013,90598.391940945614,92410.359779764534,94258.566975359819,96143.73831486702,98066.613081164367,100027.94534278766]
["HEW 9 4",119678.38111379999,121952.27035496218,124391.31576206142,126879.14207730265,130685.52,137525.81,143081.85999999999,145943.5,148862.37,151839.61739999999,154876.40974799998,157973.93794295998,161133.41670181919,164356.08503585559,167643.2067365727,170996.07087130417,174415.99228873025]
["HEW 9 3",117309.73803179999,119538.62305440416,121929.39551549226,124367.9834258021,128099.03,134834.82999999999,140282.16,143087.79999999999,145949.55599999998,148868.54711999997,151845.91806239999,154882.836423648,157980.49315212097,161140.10301516339,164362.90507546667,167650.163176976,171003.16644051552]
["HEW 9 2",115201.92736079998,117390.76398065519,119738.57926026829,122133.35084547364,125797.35,132440.16,137790.75,140546.56,143357.49119999999,146224.64102399998,149149.13384447998,152132.11652136958,155174.75885179697,158278.25402883292,161443.81910940958,164672.69549159778,167966.14940142975]
["HEW 9 1",113095.08331319998,115243.88989615078,117548.76769407379,119899.74304795526,123496.74,130046.6,135300.48000000001,138006.49,140766.61979999999,143581.952196,146453.59123992,149382.66306471839,152370.31632601278,155417.72265253303,158526.07710558371,161696.59864769538,164930.53062064928]
["HEW 8 4",108318.36307199998,110376.41197036798,112583.94020977533,114835.61901397083,118280.7,124619.84,129654.48,132247.57,134892.5214,137590.371828,140342.17926455999,143149.0228498512,146012.00330684823,148932.24337298519,151910.88824044491,154949.10600525382,158048.08812535889]
["HEW 8 3",104366.22456,106349.18282664001,108476.1664831728,110645.68981283625,113965.05,120129.84,124983.08,127482.75,130032.405,132633.05309999999,135285.71416199999,137991.42844523999,140751.25701414479,143566.2821544277,146437.60779751625,149366.35995346657,152353.68715253592]
["HEW 8 2",100418.24356799999,102326.19019579198,104372.71399970782,106460.16827970197,109653.96,115644.58,120316.62,122722.95,125177.409,127680.95718,130234.57632360001,132839.26785007201,135496.05320707345,138205.97427121492,140970.09375663922,143789.49563177201,146665.28554440744]
["HEW 8 1",96466.063480800003,98298.918686935198,100264.89706067392,102270.19500188739,105338.31,111154.58,115645.22,117958.12,120317.2824,122723.628048,125178.10060896,127681.6626211392,130235.29587356199,132840.00179103322,135496.80182685389,138206.73786339097,140970.8726206588]
["HEW 7 4",93085.989326999988,94885.989326999988,96783.709113539997,98719.383295810796,101680.96000000001,107349.47,111686.39,113920.12,116198.5224,118522.49284800001,120892.94270496001,123310.80155905921,125777.0175902404,128292.55794204521,130858.40910088611,133475.57728290383,136145.08882856191]
["HEW 7 3",90438.124959999986,92238.124959999986,94082.887459199977,95964.545208383992,98843.48,104397.36,108615.01,110787.31,113003.05620000001,115263.11732400001,117568.37967048,119919.7472638896,122318.14220916739,124764.50505335075,127259.79515441776,129804.99105750612,132401.09087865625]
["HEW 7 2",87829.627619999985,89629.627619999985,91422.22017239999,93250.664575847986,96048.18,101489.12,105589.28,107701.07,109855.0914,112052.193228,114293.23709256001,116579.10183441121,118910.68387109943,121288.89754852143,123714.67549949186,126188.96900948171,128712.74838967134]
["HEW 7 1",85222.689349999986,87022.689349999986,88763.143136999992,90538.405999739989,93254.55,98582.63,102565.37,104616.68,106709.01359999999,108843.19387199999,111020.05774943999,113240.45890442879,115505.26808251736,117815.37344416771,120171.68091305107,122575.11453131209,125026.61682193834]
["HEW 6 4",83267.075499999992,85067.075499999992,86768.41700999999,88503.785350199993,91158.9,96402.32,100296.97,102302.91,104348.9682,106435.947564,108564.66651528,110735.9598455856,112950.67904249732,115209.69262334726,117513.88647581422,119864.1642053305,122261.44748943711]
["HEW 6 3",81310.483409999986,83110.483409999986,84772.693078199998,86468.146939764003,89062.18,94220.89,98027.42,99987.96,101987.71920000001,104027.47358400001,106108.02305568001,108230.18351679361,110394.78718712948,112602.68293087206,114854.7365894895,117151.8313212793,119494.86794770489]
["HEW 6 2",79356.876990000004,81156.876990000004,82780.014529799999,84435.614820396018,86968.69,92042.82,95761.35,97676.58,99630.111600000004,101622.71383200001,103655.16810864001,105728.2714708128,107842.83690022906,109999.69363823364,112199.68751099832,114443.6812612183,116732.55488644267]
["HEW 6 1",77400.254329999996,79200.254329999996,80784.259416599991,82399.944604931996,84871.95,89861.38,93491.78,95361.61,97268.842199999999,99214.219043999998,101198.50342487999,103222.47349337759,105286.92296324515,107392.66142251005,109540.51465096025,111731.32494397946,113965.95144285905]
["HEW 5 4",75506.819859999989,77306.819859999989,78852.956257199985,80430.01538234399,82842.92,87750.37,91295.49,93121.4,94983.827999999994,96883.504560000001,98821.17465120001,100797.59814422402,102813.5501071085,104869.82110925067,106967.21753143569,109106.5618820644,111288.6931197057]
["HEW 5 3",72872.256499999989,74672.256499999989,76165.701629999996,77689.015662599995,80019.69,84813.08,88239.53,90004.32,91804.406400000007,93640.49452800001,95513.304418560016,97423.570506931224,99372.041917069844,101359.48275541124,103386.67241051947,105454.40585872986,107563.49397590446]
["HEW 5 2",70241.921990000003,72041.921990000003,73482.760429800008,74952.415638396007,77200.990000000005,81880.509999999995,85188.479999999996,86892.25,88630.095000000001,90402.69690000001,92210.750838000007,94054.965854760012,95936.065171855211,97854.78647529232,99811.882204798167,101808.11984889413,103844.28224587202]
["HEW 5 1",67608.408199999991,69408.408199999991,70796.576363999993,72212.507891279995,74378.89,78944.399999999994,82133.75,83776.429999999993,85451.958599999998,87160.997772000002,88904.217727440002,90682.302081988804,92495.948123628579,94345.867086101149,96232.784427823179,98157.440116379643,100120.58891870723]
["HEW 4 4",66291.941719999988,68091.941719999988,69453.780554399986,70842.856165487989,72968.149999999994,77476.66,80606.710000000006,82218.84,83863.216799999995,85540.481136000002,87251.290758720002,88996.316573894408,90776.242905372303,92591.767763479744,94443.603118749335,96332.475181124319,98259.124684746814]
["HEW 4 3",64974.96574,66774.965739999985,68110.465054799992,69472.674355895986,71556.86,76008.36,79079.09,80660.679999999993,82273.893599999996,83919.371471999999,85597.75890144,87309.714079468802,89055.908361058173,90837.026528279341,92653.767058844925,94506.842400021822,96396.979248022253]
["HEW 4 2",63657.969379999988,65457.969379999988,66767.128767599992,68102.471342951991,70145.539999999994,74540.02,77551.44,79102.47,80684.519400000005,82298.209788000007,83944.173983760003,85623.057463435209,87335.51861270392,89082.228984957997,90863.873564657159,92681.151035950301,94534.77405666931]
["HEW 4 1",62342.012399999992,64142.012399999992,65424.852647999993,66733.349700959996,68735.350000000006,73072.86,76025,77545.5,79096.41,80678.338199999998,82291.904964000001,83937.74306328001,85616.497924545605,87328.827883036516,89075.404440697253,90856.912529511203,92674.050780101432]
["HEW 3 4",60936.383419999998,62736.383419999998,63991.111088400001,65270.933310167995,67229.06,71505.710000000006,74394.539999999994,75882.429999999993,77400.078599999993,78948.080172000002,80527.041775439997,82137.582610948797,83780.334263167781,85455.940948431133,87165.059767399754,88908.360962747756,90686.528182002716]
["HEW 3 3",58978.619479999994,60778.619479999994,61994.191869599992,63234.075706991993,65131.09,69322.98,72123.63,73566.100000000006,75037.422000000006,76538.170440000002,78068.933848800007,79630.312525776011,81222.918776291539,82847.377151817374,84504.324694853727,86194.411188750804,87918.299412525826]
["HEW 3 2",57023.515129999992,58823.515129999992,59999.985432599991,61199.985141251986,63035.99,67143.240000000005,69855.820000000007,71252.94,72677.998800000001,74131.558776000005,75614.189951520006,77126.473750550402,78669.003225561406,80242.383290072641,81847.230955874096,83484.175574991576,85153.859086491415]
["HEW 3 1",55068.370019999988,56868.370019999988,58005.737420399993,59165.852168807993,60940.83,64963.44,67587.960000000006,68939.72,70318.5144,71724.884688000006,73159.382381760006,74622.57002939521,76115.021429983113,77637.321858582771,79190.068295754434,80773.869661669523,82389.347054902915]
["HEW 2 2",54015.681879999982,55815.681879999982,56931.995517599986,58070.635427951987,59812.75,63789.79,66366.89,67694.23,69048.114600000001,70429.076891999997,71837.658429839998,73274.411598436796,74739.899830405528,76234.697827013646,77759.391783553918,79314.579619224998,80900.871211609498]
["HEW 2 1",52705.798139999984,54505.798139999984,55595.914102799994,56707.832384855996,58409.08,62329.41,64847.51,66144.47,67467.359400000001,68816.706588000001,70193.04071976,71596.9015341552,73028.839564838301,74489.416356135072,75979.204683257776,77498.788776922927,79048.764552461391]
["HEW 1 3",51373.098989999984,53173.098989999984,54236.56096979999,55321.292189195992,56980.93,60843.56,63301.64,64567.67,65859.023400000005,67176.203868000011,68519.727945360006,69890.122504267201,71287.924954352551,72713.683453439604,74167.957122508393,75651.316264958557,77164.342590257729]
["HEW 1 2",50322.234859999997,52122.234859999997,53164.679557199997,54227.973148343997,55854.8,59671.93,62082.68,63324.33,64590.816600000006,65882.632932000008,67200.285590640007,68544.29130245281,69915.177128501862,71313.480671071899,72739.750284493333,74194.545290183203,75678.436195986869]
["HEW 1 1",49267.671759999997,51067.671759999997,52089.025195199996,53130.805699103999,54724.72,58496.19,60859.43,62076.62,63318.152400000006,64584.515448000006,65876.20575696,67193.729872099197,68537.604469541184,69908.356558932006,71306.523690110655,72732.65416391287,74187.307247191129]

{"sheet":"Admin-Currencies","index":6,"n_rows":115,"n_cols":2,"rows_kept":115,"cut":false,"hidden":true,"merged":[]}
["CountryCurrency","CurrencyCode"]
["Australia Dollar","AUD"]
["Canada Dollar","CAD"]
["Euro Member Countries","EUR"]
["United Kingdom Pound","GBP"]
["Japan Yen","JPY"]
["New Zealand Dollar","NZD"]
["United States Dollar","USD"]
[]
["United Arab Emirates Dirham","AED"]
["Afghanistan Afghani","AFN"]
["Albania Lek","ALL"]
["Armenia Dram","AMD"]
["Netherlands Antilles Guilder","ANG"]
["Angola Kwanza","AOA"]
["Argentina Peso","ARS"]
["Aruba Guilder","AWG"]
["Azerbaijan New Manat","AZN"]
["Bosnia and Herzegovina Convertible Marka","BAM"]
["Barbados Dollar","BBD"]
["Bangladesh Taka","BDT"]
["Bulgaria Lev","BGN"]
["Bahrain Dinar","BHD"]
["Burundi Franc","BIF"]
["Bermuda Dollar","BMD"]
["Brunei Darussalam Dollar","BND"]
["Bolivia Boliviano","BOB"]
["Brazil Real","BRL"]
["Bahamas Dollar","BSD"]
["Bhutan Ngultrum","BTN"]
["Botswana Pula","BWP"]
["Belarus Ruble","BYR"]
["Belize Dollar","BZD"]
["Congo/Kinshasa Franc","CDF"]
["Switzerland Franc","CHF"]
["Chile Peso","CLP"]
["China Yuan Renminbi","CNY"]
["Colombia Peso","COP"]
["Costa Rica Colon","CRC"]
["Cuba Convertible Peso","CUC"]
["Cuba Peso","CUP"]
["Cape Verde Escudo","CVE"]
["Czech Republic Koruna","CZK"]
["Djibouti Franc","DJF"]
["Denmark Krone","DKK"]
["Dominican Republic Peso","DOP"]
["Algeria Dinar","DZD"]
["Egypt Pound","EGP"]
["Eritrea Nakfa","ERN"]
["Ethiopia Birr","ETB"]
["Fiji Dollar","FJD"]
["Falkland Islands (Malvinas) Pound","FKP"]
["Georgia Lari","GEL"]
["Guernsey Pound","GGP"]
["Ghana Cedi","GHS"]
["Gibraltar Pound","GIP"]
["Gambia Dalasi","GMD"]
["Guinea Franc","GNF"]
["Guatemala Quetzal","GTQ"]
["Guyana Dollar","GYD"]
["Hong Kong Dollar","HKD"]
["Honduras Lempira","HNL"]
["Croatia Kuna","HRK"]
["Haiti Gourde","HTG"]
["Hungary Forint","HUF"]
["Indonesia Rupiah","IDR"]
["Israel Shekel","ILS"]
["Isle of Man Pound","IMP"]
["India Rupee","INR"]
["Iraq Dinar","IQD"]
["Iran Rial","IRR"]
["Iceland Krona","ISK"]
["Jersey Pound","JEP"]
["Jamaica Dollar","JMD"]
["Solomon Islands Dollar","SBD"]
["Seychelles Rupee","SCR"]
["Sudan Pound","SDG"]
["Sweden Krona","SEK"]
["Singapore Dollar","SGD"]
["Saint Helena Pound","SHP"]
["Sierra Leone Leone","SLL"]
["Somalia Shilling","SOS"]
["Seborga Luigino","SPL"]
["Suriname Dollar","SRD"]
["São Tomé and Príncipe Dobra","STD"]
["El Salvador Colon","SVC"]
["Syria Pound","SYP"]
["Swaziland Lilangeni","SZL"]
["Thailand Baht","THB"]
["Tajikistan Somoni","TJS"]
["Turkmenistan Manat","TMT"]
["Tunisia Dinar","TND"]
["Tonga Pa'anga","TOP"]
["Turkey Lira","TRY"]
["Trinidad and Tobago Dollar","TTD"]
["Tuvalu Dollar","TVD"]
["Taiwan New Dollar","TWD"]
["Tanzania Shilling","TZS"]
["Ukraine Hryvnia","UAH"]
["Uganda Shilling","UGX"]
["Uruguay Peso","UYU"]
["Uzbekistan Som","UZS"]
["Venezuela Bolivar","VEF"]
["Viet Nam Dong","VND"]
["Vanuatu Vatu","VUV"]
["Samoa Tala","WST"]
["Communauté Financière Africaine (BEAC) CFA Franc BEAC","XAF"]
["East Caribbean Dollar","XCD"]
["International Monetary Fund (IMF) Special Drawing Rights","XDR"]
["Communauté Financière Africaine (BCEAO) Franc","XOF"]
["Comptoirs Français du Pacifique (CFP) Franc","XPF"]
["Yemen Rial","YER"]
["South Africa Rand","ZAR"]
["Zambia Kwacha","ZMW"]
["Zimbabwe Dollar","ZWD"]

{"sheet":"Admin-Other","index":7,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[[27,8,34,8],[35,8,43,8]]}
[]
[]
["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",{"$f":"NonCasualSuper*NonCasualPRT","v":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,{"$f":"IF(OncostsException=\"Yes: 30%\", 1.3,(1+$J$13))","v":1.2887900000000001},null,null,null,"PRT on Superannuation","CasualPRTSuper",{"$f":"CasualSuper*CasualPRT","v":5.9849999999999999E-3}]
["Days",260.89299999999997,null,{"$f":"IF(OncostsException=\"Yes: 30%\", 1.3,(1+$J$13))","v":1.2887900000000001},null,null,null,"Long Service Leave","-"]
["Hours",1891.4742499999998,null,{"$f":"IF(OncostsException=\"Yes: 30%\", 1.3,(1+$J$13))","v":1.2887900000000001},null,null,null,"Recreation Leave","-"]
["Casual Hours",1891.4742499999998,1.25,{"$f":"IF(OncostsException=\"Yes: 30%\", 1.3,(1+$J$23))","v":1.1699850000000001},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}]
[]
[]
[]
[null,null,null,null,null,null,null,"UQ HDR Academic Area"]
[null,null,null,null,null,null,null,"Architechture"]
[null,null,null,null,null,null,null,"Argriculture and environment studies"]
[null,null,null,null,null,null,null,"Creative Arts"]
[null,null,null,null,null,null,null,"Dentistry"]
[null,null,null,null,null,null,null,"Education"]
[null,null,null,null,null,null,null,"Engineering"]
[null,null,null,null,null,null,null,"Health"]
[null,null,null,null,null,null,null,"Human Movement"]
[null,null,null,null,null,null,null,"Information Technology"]
[null,null,null,null,null,null,null,"Management and Commerce"]
[null,null,null,null,null,null,null,"Mathematical Sciences"]
[null,null,null,null,null,null,null,"Medical Studies"]
[null,null,null,null,null,null,null,"Natural and physical sciences"]
[null,null,null,null,null,null,null,"Pharmacy"]
[null,null,null,null,null,null,null,"Psychology"]
[null,null,null,null,null,null,null,"Social and cultural studies"]
[null,null,null,null,null,null,null,"Veterinary Science"]