{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","FAQs","Summary","Variances","Warnings","Labour Expenditure","Contract Expenditure","Plant Expenditure","SMP-PMP Expenditure","Prototype Expenditure","Other Expenditure","Cash Flow","Guidelines"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[28,4,28,13],[45,3,45,13],[47,3,47,13],[34,4,34,13],[36,4,36,13],[38,4,38,13],[40,3,40,13],[30,4,30,13],[32,4,32,13],[42,3,42,13],[10,2,10,13],[26,4,26,13],[4,2,4,13],[6,2,6,13],[8,2,8,13],[20,3,20,13],[22,4,22,13],[24,4,24,13],[14,3,14,13],[15,3,15,13],[18,3,18,13]]}
[]
[null,null,"Instructions for Completing the Budget Calculator"]
[]
[]
[null,null,"This budget calculator has been provided to assist you in calculating eligible expenditure for an Accelerating Commercialisation Grant."]
[]
[null,null,"The calculator forms part of the Accelerating Commercialisation Grant Application Form.  The application and the related instructions should be read before completing this form.  To assist in the costing of your project, links have been provided to the Eligible Expenditure Guidelines."]
[]
[null,null,"Macros must be enabled in order to use the budget calculator. The security level for macros should be set at medium or lower for the budget calculator to work. For Excel 2010 users, the security level can modified via Windows Office Button; Excel Options; Trust Centre; Trust Centre Settings; Macro Settings. Please remember to save it as an 'xlsm' (Macro Enabled) instead of an 'xlsx' (Macro Disabled) file. If you do save the calculator as an xlsx file, the macros are deleted and the budget calculator will no longer operate correctly. To fix this requires a new version of the budget calculator and re-entry of the data."]
[]
[null,null,"Warning: If you wish to paste information onto the Budget Calculator ensure that \"Paste Special\" as \"Values\" is used (available under the \"Edit\"or \"Home\" menu). This ensures the Budget calculator formatting and data validation is retained and that the Budget Calculator continues to operate correctly. You are allowed to paste decimal numbers, however the values will be formatted as whole numbers."]
[]
[null,null,"Also: Please do not change the tab description of any worksheet. Any changes may cause loss of entered data."]
[]
[null,null,null,"IMPORTANT: ALL FIGURES IN THE CALCULATOR SHOULD BE GST EXCLUSIVE"]
[null,null,null,"YOU MAY BE REQUIRED TO VALIDATE ANY, OR ALL, OF THE INFORMATION IN THE CALCULATOR"]
[]
[null,null,"STEPS TO COMPLETE THE APPLICATION BUDGET CALCULATOR"]
[null,null,1,"On the \"Summary\" tab, enter the start and end dates for the project for which you are applying for Accelerating Commercialisation grant funding.  This step needs to be completed first as it determines the timeframe in which costs can be claimed.  Entry of these dates will automatically populate the column headings throughout the workbook as well as populating the Project Start Date and Project End Date fields on the Summary tab.  Any subsequent changes to these dates may affect the period in which the costs have been entered. To assist you, any dates previously entered in the worksheets that fall outside the new period will appear RED. "]
[]
[null,null,2,"Once step 1 is complete, the remaining tabs can be completed in any order.  Please be aware that only fields shaded in GREEN can have data entered into them.  Please ensure you enter the quarterly breakup of the financial figures into the GREEN cells to the right of the annual summary columns. It is not necessary to input data in all GREEN fields.  If you require additional GREEN lines, a button to the left of each table allows extra lines to be inserted  You can edit data previously entered in the GREEN fields by selecting the field and then pressing the F2 key.  Below is a brief description of how to complete the worksheets for each head of expenditure."]
[]
[null,null,null,null,"Summary - The summary sheet provides totals for all other worksheets within the calculator. "]
[]
[null,null,null,null,"Warnings - The warnings sheet displays any eligible expenditure rules that have been exceeded in your budget.  Please check the warnings page regularly whilst completing the spreadsheet and ensure any warnings that appear in RED have been cleared before submitting.  Additional warnings are available after project commencement to assist you in identifying differences for agreed costs when entering actual expenditure."]
[]
[null,null,null,null,"Labour Expenditure - In section A, please complete fields shaded in GREEN including apportioning the costs across the relevant periods.  Any salary on-costs and overhead costs allowed by the Eligible Expenditure Guidelines will be automatically calculated for you in Table B of the Worksheet."]
[]
[null,null,null,null,"Contract Expenditure - Please input the information relevant to contractors that work at least 35hrs per week on the applicant's premises in Table A, including fields to the right of the sheet to reflect the period in which the expenditure is expected to be incurred.  Table B will automatically calculate on-costs for the > 35 hrs per week contractors.  If you will be using any contractor that typically works less than 35 hrs per week on the applicant's premises, please input their information in Table C.  Table C also requires that fields to the right of the sheet be completed."]
[]
[null,null,null,null,"Plant Expenditure - Tables A and B require you to enter the details for each item of purchased, hired/leased and/or constructed plant as well as the breakdown of quarterly expenses to the right. Information relating to running costs will also need to be entered in the quarterly expenses.  "]
[]
[null,null,null,null,"State of the Art Manufacturing Plant/Pilot Manufacturing Plant Expenditure - Tables A requires you to enter the details for each item of plant as well as the breakdown of quarterly expenses to the right. Information relating to running costs will also need to be entered in the quarterly expenses.  "]
[]
[null,null,null,null,"Prototype Expenditure - Table A requires you to enter quarterly expenses for each item individually including the number of prototypes to be produced and the total costs of materials consumed when testing the prototype."]
[]
[null,null,null,null,"Other Expenditure - This worksheet requires you to enter quarterly expenses for each item individually."]
[]
[null,null,null,null,"Guidelines - The Eligible Expenditure Guidelines have also been included in the calculator.  Each of the worksheets have buttons which will direct you to relevant parts of the guidelines."]
[]
[null,null,3,"Return to the \"Summary\" tab and enter the Grant sought amount. This amount must be in line with the Eligible Expenditure Guidelines for Accelerating Commercialisation. Thus, a grant recipient is only entitled to 50% of their total project costs up to $1 million. If the Grant recipient is a Commercialisation Office or eligible partner entity, the grant sought is restricted to $250,000."]
[]
[null,null,4,"Once Steps 1 - 2 are complete, please review the \"Warnings\" and \"Summary\" tabs. Please ensure that all warnings on the \"Warnings\" tab show a white background and GREEN text. If any warnings are triggered with a RED or AMBER background, please resolve this in an appropriate fashion."]
[]
[null,null,"STEPS TO ENTER ACTUAL EXPENDITURE DURING CONDUCT OF PROJECT"]
[null,null,5,"The budget calculator allows you to monitor your actual expenditure throughout the life of the project and adjust expenditure in future periods as necessary.  After entering into an agreement your Customer Service Manager will provide you with a copy of the project budget calculator containing agreed project expenditure for use during progress reporting.  At this point the calculator will include an additional worksheet with a summary of your agreed expenditure and with \"Actuals\" buttons enabled.  As you progress the project, entering actual expenditure and adjusting future periods as appropriate, any variations from your agreed budget will be highlighted.  The additional warning at the bottom of the Warnings worksheet will identify if these differences exceed Eligible Expenditure Guidelines, resulting in the need to either adjust expenditure or discuss the possibility of a project variation with your Customer Service Manager. "]
[]
[null,null,6,"To enter actual expenditure for any quarter that has been completed, press the \"Actuals\" button on the relevant sheet above the applicable quarter.  Editable fields will be set to YELLOW and all figures in the YELLOW cells are then able to be adjusted as necessary.  All GREEN colour fields remain editable as explained above.  Please note that actual expenditure may only be entered for quarters that have passed. If the \"Actuals\" buttons are not displayed, please contact your Customer Service Manager."]

{"sheet":"FAQs","index":1,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,2,45,10],[40,2,40,10],[41,2,41,10],[43,2,43,10],[39,2,39,10],[44,2,44,10],[37,2,37,10],[36,2,36,10],[35,2,35,10],[25,2,25,10],[23,2,23,10],[30,2,30,10],[32,2,32,10],[34,2,34,10],[33,2,33,10],[31,2,31,10],[29,2,29,10],[22,2,22,10],[24,2,24,10],[26,2,26,10],[28,2,28,10],[27,2,27,10],[11,2,11,10],[17,2,17,10],[21,2,21,10],[7,2,7,10],[3,2,3,10],[4,2,4,10],[8,2,8,10],[10,2,10,10],[12,2,12,10],[13,2,13,10],[14,2,14,10],[20,2,20,10],[19,2,19,10],[15,2,15,10],[16,2,16,10],[18,2,18,10],[1,2,1,10],[5,2,5,10],[6,2,6,10],[9,2,9,10],[2,2,2,10]]}
[]
[null,null,"Accelerating Commercialisation Budget Calculator - Frequently Asked Questions"]
[]
[null,null,"Do macros have to be enabled in order to use the budget calculator?"]
[]
[null,null,"Yes. Macros must be enabled in order the use the budget calculator. The security level for macros should be set at medium or lower for the budget calculator to work. For Excel 2010 users, the security macro level can be modified via Windows Office Button; Excel Options; Trust Centre; Trust Centre Settings; Macro Settings. Please remember to save it as an 'xlsm' (Macro Enabled) instead of an 'xlsx' (Macro Disabled) file. If you do save the calculator as an xlsx, the macros are deleted and the budget calculator will no longer operate correctly. To fix this requires a new version of the budget calculator and re-entry of the data."]
[]
[null,null,"Can I unprotect the spreadsheet?"]
[]
[null,null,"No - The protection is important to ensure the integrity of the calculations and compliance with the Eligible Expenditure Guidelines. If the spreadsheet has been unprotected then it will not be accepted by AusIndustry as it may have been corrupted."]
[]
[null,null,"Is it OK to enter formulas in the green cells?"]
[]
[null,null,"Yes, provided the formula will produce a result that meets the data validation rules for the cell."]
[]
[null,null,"Is it OK to assemble calculations in a different spreadsheet and copy the results into the calculator?"]
[]
[null,null,"Yes, but ensure that \"Paste Special\" as \"Values\" is used (available under the \"Edit\" or \"Home\" menu). \"Paste Special\" - \"Values\" ensures the budget calculator formatting and data validation is retained and that the budget calculator continues to operate correctly."]
[]
[null,null,"Can I copy and paste information within the calculator?"]
[]
[null,null,"Yes - but you can only use \"Paste Special\" - \"Values\" as mentioned in the previous answer."]
[]
[null,null,"Can I \"share\" the workbook for use by more than one person at a time?"]
[]
[null,null,"No - \"sharing\" does not work with protected worksheets in Microsoft Excel. "]
[]
[null,null,"Can I place a border on a cell?"]
[]
[null,null,"No - changing any formatting in the budget calculator including the colour data entry cells, may affect the macros it contains. This will impact on the effectiveness of the budget calculator for the user. "]
[]
[null,null,"How do I reflect Pay Increases on the Labour Expenditure Tab?"]
[]
[null,null,"This can be reflected in one of two ways:"]
[]
[null,null,"1. The annual salary is used as a guide to ensure that the quarterly figures do not exceed the annual amount. Consquently, when entering the annual salary, you can input the maximum salary you expect the person to earn over the term of the project. For the year(s) prior to the employee reaching this maximum salary, the total of the quarterly amounts will be less than the annual salary, which is accepted by the data validation tests."]
[null,null,"OR"]
[null,null,"2. Insert a new line for each employee on each salary increment. Enter the start and end date for the salary in the Period Start and Period End cells."]
[]
[null,null,"Do I need to explain the calculations for effective life of Plant Expenditure within the budget calculator?"]
[]
[null,null,"No - however it is advisable that you maintain these records as your Customer Service Manager may request information on how the effective life of the asset has been derived. "]
[]
[null,null,"Why don't the totals at the bottom of the tab add up correctly?"]
[]
[null,null,"The final total at the bottom of each tab rounds down to the nearest whole number. This may result in minor differences when compared to manually adding individual figures."]

{"sheet":"Summary","index":2,"n_rows":64,"n_cols":31,"rows_kept":64,"cut":false,"hidden":false,"merged":[[10,0,10,2],[11,0,11,1],[23,1,23,3],[24,1,24,3],[25,1,25,3],[19,1,22,2],[17,0,17,2],[39,1,39,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[31,0,31,1],[29,1,29,3]]}
["Accelerating Commercialisation",null,null,null,null,null,"Please Select","Yes","No"]
["Project Budget Calculator",null,"AC Version 2.5 Excel 2010 onwards"]
["Company Name:"]
["Enter Project Start Date:"]
["Enter Project End Date:",null,null,null,null,{"$f":"B56","v":"3799-07-01"},{"$f":"F5","v":"3799-07-01"}]
["Version Number:"]
[null,null,{"$f":"IF(C5-C4>(365*2),\"Warning - project must not exceed 2 years.\",\"\")","v":""}]
["Total Project Costs:",null,{"$f":"+AD30","v":0}]
["Grant Percentage (max 50%)",null,{"$f":"IF(ABS(C8/2-C10)<1,IF(AND(IFERROR(ROUNDDOWN(C10/C8,4),0)>0.4997,IFERROR(ROUNDDOWN(C10/C8,4),0)<0.5),0.5,IFERROR(ROUNDDOWN(C10/C8,4),0)),IFERROR(ROUNDDOWN(C10/C8,4),0))","v":0},{"$f":"IF(C12=\"Yes\",IF(C8<=500000,0.5,250000/C8),IF(C8<=2000000,0.5,1000000/C8))","v":0.5}]
["Grant Sought (max 50%):",null,null,{"$f":"ROUNDDOWN(C8*D9,0)","v":0}]
[{"$f":"IF(C10>ROUNDDOWN(C8*D9,0),\"Grant Sought cannot exceed maximum grant percentage or maximum grant allowed. See Eligible Expenditure Guidelines for further information.\",\"\")","v":""}]
["Is the applicant a Commercialisation Office or Eligible Partner Entity?",null,"No"]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(C16=0,\"\",IF(C16=100%,\"\",\"Total % must equal 100%\"))","v":""}]
[]
[{"$f":"IF(SUM(Warnings!Q6:Q12)>0,\"Your current calculation includes ineligible expenditure, please check Warnings page for further information.\",\"\")","v":""}]
["Summary of Eligible Project Expenditure"]
[null,null,null,null,null,"Q1","Q2","Q3","Q4","Year 1",null,"Q1","Q2","Q3","Q4","Year 2",null,"Q1","Q2","Q3","Q4","Year 3",null,"Q1","Q2","Q3","Q4","Year 4"]
[null,null,null,null,null,{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(AND(C4<>\"\",C5=\"\"),\"Enter Project End Date\",IF($C$4>B46,IF(B47>=$C$4,$C$4,\"Not Started\"),IF(C5<B46,\"Finalised\",B46))))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(AND(C4<>\"\",C5=\"\"),\"Enter Project End Date\",IF($C$4>C46,IF(C47>=$C$4,$C$4,\"Not Started\"),IF(C5<C46,\"Finalised\",C46))))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(AND(C4<>\"\",C5=\"\"),\"Enter Project End Date\",IF($C$4>D46,IF(D47>=$C$4,$C$4,\"Not Started\"),IF(C5<D46,\"Finalised\",D46))))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(AND(C4<>\"\",C5=\"\"),\"Enter Project End Date\",IF($C$4>E46,IF(E47>=$C$4,$C$4,\"Not Started\"),IF(C5<E46,\"Finalised\",E46))))","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!O7","v":"Enter Project Start Date"},null,{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(F46>$C$5,\"Finalised\",F46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(G46>$C$5,\"Finalised\",G46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(H46>$C$5,\"Finalised\",H46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(I46>$C$5,\"Finalised\",I46))","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!P7","v":"Enter Project Start Date"},null,{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(J46>$C$5,\"Finalised\",J46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(K46>$C$5,\"Finalised\",K46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(L46>$C$5,\"Finalised\",L46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(M46>$C$5,\"Finalised\",M46))","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!Q7","v":"Enter Project Start Date"},null,{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(N46>$C$5,\"Finalised\",N46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(O46>$C$5,\"Finalised\",O46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(P46>$C$5,\"Finalised\",P46))","v":"Enter Project Start Date"},{"$f":"IF(C4=\"\",\"Enter Project Start Date\",IF(Q46>$C$5,\"Finalised\",Q46))","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!R7","v":"Enter Project Start Date"}]
[null,null,null,null,null,"to","to","to","to",{"$f":"'Labour Expenditure'!O8","v":"to"},null,"to","to","to","to",{"$f":"'Labour Expenditure'!P8","v":"to"},null,"to","to","to","to",{"$f":"'Labour Expenditure'!Q8","v":"to"},null,"to","to","to","to",{"$f":"'Labour Expenditure'!R8","v":"to"},null,"Total"]
[null,null,null,null,null,{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF(B47<$C$4,\"Not Started\",IF(C5<B46,\"Finalised\",IF(C5<B47,C5,B47))))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF(C47<$C$4,\"Not Started\",IF(C5<C46,\"Finalised\",IF(C5<C47,C5,C47))))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF(D47<$C$4,\"Not Started\",IF(C5<D46,\"Finalised\",IF(C5<D47,C5,D47))))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF(E47<$C$4,\"Not Started\",IF(C5<E46,\"Finalised\",IF(C5<E47,C5,E47))))","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!O9","v":"Enter Project End Date"},null,{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>F47,F47,IF($C$5<F46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>G47,G47,IF($C$5<G46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>H47,H47,IF($C$5<H46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>I47,I47,IF($C$5<I46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!P9","v":"Enter Project End Date"},null,{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>J47,J47,IF($C$5<J46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>K47,K47,IF($C$5<K46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>L47,L47,IF($C$5<L46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>M47,M47,IF($C$5<M46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!Q9","v":"Enter Project End Date"},null,{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>N47,N47,IF($C$5<N46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>O47,O47,IF($C$5<O46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>P47,P47,IF($C$5<P46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"IF(C5=\"\",\"Enter Project End Date\",IF($C$5>Q47,Q47,IF($C$5<Q46,\"Finalised\",$C$5)))","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!R9","v":"Enter Project End Date"}]
[null,"Labour Expenditure",null,null,null,{"$f":"'Labour Expenditure'!$T$45","v":0},{"$f":"'Labour Expenditure'!$U$45","v":0},{"$f":"'Labour Expenditure'!$V$45","v":0},{"$f":"'Labour Expenditure'!$W$45","v":0},{"$f":"SUM(F24:I24)","v":0},null,{"$f":"'Labour Expenditure'!$Z$45","v":0},{"$f":"'Labour Expenditure'!$AA$45","v":0},{"$f":"'Labour Expenditure'!$AB$45","v":0},{"$f":"'Labour Expenditure'!$AC$45","v":0},{"$f":"SUM(L24:O24)","v":0},null,{"$f":"'Labour Expenditure'!$AF$45","v":0},{"$f":"'Labour Expenditure'!$AG$45","v":0},{"$f":"'Labour Expenditure'!$AH$45","v":0},{"$f":"'Labour Expenditure'!$AI$45","v":0},{"$f":"SUM(R24:U24)","v":0},null,{"$f":"'Labour Expenditure'!$AL$45","v":0},{"$f":"'Labour Expenditure'!$AM$45","v":0},{"$f":"'Labour Expenditure'!$AN$45","v":0},{"$f":"'Labour Expenditure'!$AO$45","v":0},{"$f":"SUM(X24:AA24)","v":0},null,{"$f":"J24+P24+V24+AB24","v":0}]
[null,"Contract Expenditure",null,null,null,{"$f":"'Contract Expenditure'!R41","v":0},{"$f":"'Contract Expenditure'!S41","v":0},{"$f":"'Contract Expenditure'!T41","v":0},{"$f":"'Contract Expenditure'!U41","v":0},0,null,{"$f":"'Contract Expenditure'!X41","v":0},{"$f":"'Contract Expenditure'!Y41","v":0},{"$f":"'Contract Expenditure'!Z41","v":0},{"$f":"'Contract Expenditure'!AA41","v":0},0,null,{"$f":"'Contract Expenditure'!AD41","v":0},{"$f":"'Contract Expenditure'!AE41","v":0},{"$f":"'Contract Expenditure'!AF41","v":0},{"$f":"'Contract Expenditure'!AG41","v":0},0,null,{"$f":"'Contract Expenditure'!AJ41","v":0},{"$f":"'Contract Expenditure'!AK41","v":0},{"$f":"'Contract Expenditure'!AL41","v":0},{"$f":"'Contract Expenditure'!AM41","v":0},0,null,0]
[null,"Plant Expenditure",null,null,null,{"$f":"'Plant Expenditure'!R33","v":0},{"$f":"'Plant Expenditure'!S33","v":0},{"$f":"'Plant Expenditure'!T33","v":0},{"$f":"'Plant Expenditure'!U33","v":0},0,null,{"$f":"'Plant Expenditure'!X33","v":0},{"$f":"'Plant Expenditure'!Y33","v":0},{"$f":"'Plant Expenditure'!Z33","v":0},{"$f":"'Plant Expenditure'!AA33","v":0},0,null,{"$f":"'Plant Expenditure'!AD33","v":0},{"$f":"'Plant Expenditure'!AE33","v":0},{"$f":"'Plant Expenditure'!AF33","v":0},{"$f":"'Plant Expenditure'!AG33","v":0},0,null,{"$f":"'Plant Expenditure'!AJ33","v":0},{"$f":"'Plant Expenditure'!AK33","v":0},{"$f":"'Plant Expenditure'!AL33","v":0},{"$f":"'Plant Expenditure'!AM33","v":0},0,null,0]
[null,"State of the Art Manufacturing Plant/Pilot Manufacturing Plant Expenditure",null,null,null,{"$f":"'SMP-PMP Expenditure'!R15","v":0},{"$f":"'SMP-PMP Expenditure'!S15","v":0},{"$f":"'SMP-PMP Expenditure'!T15","v":0},{"$f":"'SMP-PMP Expenditure'!U15","v":0},0,null,{"$f":"'SMP-PMP Expenditure'!X15","v":0},{"$f":"'SMP-PMP Expenditure'!Y15","v":0},{"$f":"'SMP-PMP Expenditure'!Z15","v":0},{"$f":"'SMP-PMP Expenditure'!AA15","v":0},0,null,{"$f":"'SMP-PMP Expenditure'!AD15","v":0},{"$f":"'SMP-PMP Expenditure'!AE15","v":0},{"$f":"'SMP-PMP Expenditure'!AF15","v":0},{"$f":"'SMP-PMP Expenditure'!AG15","v":0},0,null,{"$f":"'SMP-PMP Expenditure'!AJ15","v":0},{"$f":"'SMP-PMP Expenditure'!AK15","v":0},{"$f":"'SMP-PMP Expenditure'!AL15","v":0},{"$f":"'SMP-PMP Expenditure'!AM15","v":0},0,null,0]
[null,"Prototype Expenditure",null,null,null,{"$f":"'Prototype Expenditure'!R15","v":0},{"$f":"'Prototype Expenditure'!S15","v":0},{"$f":"'Prototype Expenditure'!T15","v":0},{"$f":"'Prototype Expenditure'!U15","v":0},0,null,{"$f":"'Prototype Expenditure'!X15","v":0},{"$f":"'Prototype Expenditure'!Y15","v":0},{"$f":"'Prototype Expenditure'!Z15","v":0},{"$f":"'Prototype Expenditure'!AA15","v":0},0,null,{"$f":"'Prototype Expenditure'!AD15","v":0},{"$f":"'Prototype Expenditure'!AE15","v":0},{"$f":"'Prototype Expenditure'!AF15","v":0},{"$f":"'Prototype Expenditure'!AG15","v":0},0,null,{"$f":"'Prototype Expenditure'!AJ15","v":0},{"$f":"'Prototype Expenditure'!AK15","v":0},{"$f":"'Prototype Expenditure'!AL15","v":0},{"$f":"'Prototype Expenditure'!AM15","v":0},0,null,0]
[null,"Other Expenditure",null,null,null,{"$f":"'Other Expenditure'!$N$15","v":0},{"$f":"'Other Expenditure'!$O$15","v":0},{"$f":"'Other Expenditure'!$P$15","v":0},{"$f":"'Other Expenditure'!$Q$15","v":0},0,null,{"$f":"'Other Expenditure'!$T$15","v":0},{"$f":"'Other Expenditure'!$U$15","v":0},{"$f":"'Other Expenditure'!$V$15","v":0},{"$f":"'Other Expenditure'!$W$15","v":0},0,null,{"$f":"'Other Expenditure'!$Z$15","v":0},{"$f":"'Other Expenditure'!$AA$15","v":0},{"$f":"'Other Expenditure'!$AB$15","v":0},{"$f":"'Other Expenditure'!$AC$15","v":0},0,null,{"$f":"'Other Expenditure'!$AF$15","v":0},{"$f":"'Other Expenditure'!$AG$15","v":0},{"$f":"'Other Expenditure'!$AH$15","v":0},{"$f":"'Other Expenditure'!$AI$15","v":0},0,null,0]
[null,"Total eligible expenditure",null,null,null,{"$f":"SUM(F24:F29)","v":0},{"$f":"SUM(G24:G29)","v":0},{"$f":"SUM(H24:H29)","v":0},{"$f":"SUM(I24:I29)","v":0},0,null,{"$f":"SUM(L24:L29)","v":0},{"$f":"SUM(M24:M29)","v":0},{"$f":"SUM(N24:N29)","v":0},{"$f":"SUM(O24:O29)","v":0},0,null,{"$f":"SUM(R24:R29)","v":0},{"$f":"SUM(S24:S29)","v":0},{"$f":"SUM(T24:T29)","v":0},{"$f":"SUM(U24:U29)","v":0},0,null,{"$f":"SUM(X24:X29)","v":0},{"$f":"SUM(Y24:Y29)","v":0},{"$f":"SUM(Z24:Z29)","v":0},{"$f":"SUM(AA24:AA29)","v":0},0,null,0]
[]
[{"$f":"NOW()","v":"2018-03-08T14:46:01.580"}]
[]
[]
[]
[null,"Grant workings",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":"SUM(X36:AA36)","v":0},null,{"$f":"AB36+V36+P36+J36","v":0}]
[null,"Hide cells","Cumulative Entitlement",{"$f":"IF(D30>0,ROUNDDOWN(D30*$C$9,0),0)","v":0},null,{"$f":"IF(F30>0,ROUNDDOWN(F30*$C$9,0),0)","v":0},{"$f":"IF(G30>0,ROUNDDOWN(SUM(F30:G30)*$C$9,0),F37)","v":0},{"$f":"IF(H30>0,ROUNDDOWN(SUM(F30:H30)*$C$9,0),G37)","v":0},{"$f":"IF(I30>0,ROUNDDOWN(SUM(F30:I30)*$C$9,0),H37)","v":0},{"$f":"I37","v":0},null,{"$f":"IF(L30>0,ROUNDDOWN((SUM(F30:I30)+L30)*$C$9,0),I37)","v":0},{"$f":"IF(M30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:M30))*$C$9,0),L37)","v":0},{"$f":"IF(N30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:N30))*$C$9,0),M37)","v":0},{"$f":"IF(O30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30))*$C$9,0),N37)","v":0},{"$f":"O37","v":0},null,{"$f":"IF(R30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+R30)*$C$9,0),O37)","v":0},{"$f":"IF(S30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:S30))*$C$9,0),R37)","v":0},{"$f":"IF(T30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:T30))*$C$9,0),S37)","v":0},{"$f":"IF(U30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:U30))*$C$9,0),T37)","v":0},{"$f":"U37","v":0},null,{"$f":"IF(X30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:U30)+X30)*$C$9,0),U37)","v":0},{"$f":"IF(Y30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:U30)+SUM(X30:Y30))*$C$9,0),X37)","v":0},{"$f":"IF(Z30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:U30)+SUM(X30:Z30))*$C$9,0),Y37)","v":0},{"$f":"IF(AA30>0,ROUNDDOWN((SUM(F30:I30)+SUM(L30:O30)+SUM(R30:U30)+SUM(X30:AA30))*$C$9,0),Z37)","v":0},{"$f":"AA37","v":0},null,{"$f":"AB37","v":0}]
[null,null,"Quarterly Payment < 95% total",{"$f":"IF(D37>=0.95*$C10,IF(0.95*$C10-D37>=0,0.95*$C10-D37,0),D37-C37)","v":0},null,{"$f":"IF(F37>=(0.95*$C10),IF(0.95*$C10-F37<=0,0.95*$C10-E37,0),F37-E37)","v":0},{"$f":"IF(G37>=(0.95*$C10),IF(0.95*$C10-G37<=0,0.95*$C10-F37,0),G37-F37)","v":0},{"$f":"IF(H37>=(0.95*$C10),IF(0.95*$C10-H37<=0,0.95*$C10-G37,0),H37-G37)","v":0},{"$f":"IF(I37>=(0.95*$C10),IF(0.95*$C10-I37<=0,0.95*$C10-H37,0),I37-H37)","v":0},{"$f":"SUM(F38:I38)","v":0},null,{"$f":"IF(L37>=(0.95*$C10),IF(0.95*$C10-L37<=0,0.95*$C10-I37,0),L37-I37)","v":0},{"$f":"IF(M37>=(0.95*$C10),IF(0.95*$C10-M37<=0,0.95*$C10-L37,0),M37-L37)","v":0},{"$f":"IF(N37>=(0.95*$C10),IF(0.95*$C10-N37<=0,0.95*$C10-M37,0),N37-M37)","v":0},{"$f":"IF(O37>=(0.95*$C10),IF(0.95*$C10-O37<=0,0.95*$C10-N37,0),O37-N37)","v":0},{"$f":"SUM(L38:O38)","v":0},null,{"$f":"IF(R37>=(0.95*$C10),IF(0.95*$C10-R37<=0,0.95*$C10-O37,0),R37-O37)","v":0},{"$f":"IF(S37>=(0.95*$C10),IF(0.95*$C10-S37<=0,0.95*$C10-R37,0),S37-R37)","v":0},{"$f":"IF(T37>=(0.95*$C10),IF(0.95*$C10-T37<=0,0.95*$C10-S37,0),T37-S37)","v":0},{"$f":"IF(U37>=(0.95*$C10),IF(0.95*$C10-U37<=0,0.95*$C10-T37,0),U37-T37)","v":0},{"$f":"SUM(R38:U38)","v":0},null,{"$f":"IF(X37>=(0.95*$C10),IF(0.95*$C10-X37<=0,0.95*$C10-U37,0),X37-U37)","v":0},{"$f":"IF(Y37>=(0.95*$C10),IF(0.95*$C10-Y37<=0,0.95*$C10-X37,0),Y37-X37)","v":0},{"$f":"IF(Z37>=(0.95*$C10),IF(0.95*$C10-Z37<=0,0.95*$C10-Y37,0),Z37-Y37)","v":0},{"$f":"IF(AA37>=(0.95*$C10),IF(0.95*$C10-AA37<=0,0.95*$C10-Z37,0),AA37-Z37)","v":0},{"$f":"SUM(X38:AA38)","v":0}]
[null,null,"Retention in first finalised period",null,null,{"$f":"IF(E23=\"Finalised\",0,IF(F23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(F23=\"Finalised\",0,IF(G23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(G23=\"Finalised\",0,IF(H23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(H23=\"Finalised\",0,IF(I23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"SUM(F39:I39)","v":0},null,{"$f":"IF(I23=\"Finalised\",0,IF(L23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(L23=\"Finalised\",0,IF(M23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(M23=\"Finalised\",0,IF(N23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(N23=\"Finalised\",0,IF(O23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"SUM(L39:O39)","v":0},null,{"$f":"IF(O23=\"Finalised\",0,IF(R23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(R23=\"Finalised\",0,IF(S23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(S23=\"Finalised\",0,IF(T23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(T23=\"Finalised\",0,IF(U23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"SUM(R39:U39)","v":0},null,{"$f":"IF(U23=\"Finalised\",0,IF(X23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(X23=\"Finalised\",0,IF(Y23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(Y23=\"Finalised\",0,IF(Z23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"IF(Z23=\"Finalised\",0,IF(AA23=\"Finalised\",0.05*$C10,0))","v":0},{"$f":"SUM(X39:AA39)","v":0}]
[null,"Indicative Grant Payment / Financial Year Caps",null,null,null,{"$f":"IF(F38<0,F39,SUM(F38:F39))","v":0},{"$f":"IF(G38<0,G39,SUM(G38:G39))","v":0},{"$f":"IF(H38<0,H39,SUM(H38:H39))","v":0},{"$f":"IF(I38<0,I39,SUM(I38:I39))","v":0},{"$f":"SUM(F40:I40)","v":0},null,{"$f":"IF(L38<0,L39,SUM(L38:L39))","v":0},{"$f":"IF(M38<0,M39,SUM(M38:M39))","v":0},{"$f":"IF(N38<0,N39,SUM(N38:N39))","v":0},{"$f":"IF(O38<0,O39,SUM(O38:O39))","v":0},{"$f":"SUM(L40:O40)","v":0},null,{"$f":"IF(R38<0,R39,SUM(R38:R39))","v":0},{"$f":"IF(S38<0,S39,SUM(S38:S39))","v":0},{"$f":"IF(T38<0,T39,SUM(T38:T39))","v":0},{"$f":"IF(U38<0,U39,SUM(U38:U39))","v":0},{"$f":"SUM(R40:U40)","v":0},null,{"$f":"IF(X38<0,X39,SUM(X38:X39))","v":0},{"$f":"IF(Y38<0,Y39,SUM(Y38:Y39))","v":0},{"$f":"IF(Z38<0,Z39,SUM(Z38:Z39))","v":0},{"$f":"IF(AA38<0,AA39,SUM(AA38:AA39))","v":0},{"$f":"SUM(X40:AA40)","v":0},null,{"$f":"ROUNDDOWN(AB40+V40+P40+J40,0)","v":0}]
[]
[]
[]
[null,"DATE FORMULA"]
[null,{"$f":"YEAR(B46)","v":3799},3799,3800,3800,3800,3800,3801,3801,3801,3801,3802,3802,3802,3802,3803,3803,3803,3803,3804,3804,3804,3804,3805,3805,3805,3805,3806,3806,3806]
[null,{"$f":"F5","v":"3799-07-01"},{"$f":"B47+1","v":"3799-10-01"},"3800-01-01","3800-04-01","3800-07-01","3800-10-01","3801-01-01","3801-04-01","3801-07-01","3801-10-01","3802-01-01","3802-04-01","3802-07-01","3802-10-01","3803-01-01","3803-04-01","3803-07-01","3803-10-01","3804-01-01","3804-04-01","3804-07-01","3804-10-01","3805-01-01","3805-04-01","3805-07-01","3805-10-01","3806-01-01","3806-04-01","3806-07-01"]
[null,{"$f":"DATE(B45,B48,B49)-1","v":"3799-09-30"},"3799-12-31","3800-03-31","3800-06-30","3800-09-30","3800-12-31","3801-03-31","3801-06-30","3801-09-30","3801-12-31","3802-03-31","3802-06-30","3802-09-30","3802-12-31","3803-03-31","3803-06-30","3803-09-30","3803-12-31","3804-03-31","3804-06-30","3804-09-30","3804-12-31","3805-03-31","3805-06-30","3805-09-30","3805-12-31","3806-03-31","3806-06-30","3806-09-30"]
[null,{"$f":"MONTH(B46)+3","v":10},13,4,7,10,13,4,7,10,13,4,7,10,13,4,7,10,13,4,7,10,13,4,7,10,13,4,7,10]
[null,{"$f":"DAY(B46)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Adjusts Start Date to 1st period of financial year"]
[null,{"$f":"C4","v":"00:00:00"}]
[null,{"$f":"IF(MONTH(B51)<7,YEAR(B51)-1,YEAR(B51))","v":1899},null,null,null,3]
[null,{"$f":"MONTH(B51)","v":1}]
[null,1]
[null,7]
[null,{"$f":"DATE(B52,B55,B54)","v":"3799-07-01"}]
[null,{"$f":"NOW()","v":"2018-03-08T14:46:01.580"},"Version 1.1 2008"]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,{"$f":"AH61","v":0}]

{"sheet":"Variances","index":3,"n_rows":64,"n_cols":30,"rows_kept":64,"cut":false,"hidden":true,"merged":[[11,0,11,1],[19,1,22,2],[29,1,29,3],[43,1,46,2],[53,1,53,3],[12,0,12,1]]}
["Accelerating Commercialisation"]
["Project Expenditure Calculator"]
["Company Name"]
["Enter Project Start Date:"]
["Enter Project End Date:"]
["Version Number:"]
[]
["Total Project Costs:",null,0]
["Grant Percentage (max 50%)",null,"0%"]
["Grant Sought (max 50%):"]
[]
["Is the grant recipient a Commercialisation Office or Eligible Partner Entity?",null,"Please Select"]
[]
[]
[]
[]
[]
[]
["Summary of Eligible Project Expenditure"]
[null,"Research & development expenditure",null,null,null,"Q1","Q2","Q3","Q4","Year 1",null,"Q1","Q2","Q3","Q4","Year 2",null,"Q1","Q2","Q3","Q4","Year 3",null,"Q1","Q2","Q3","Q4","Year4"]
[null,null,null,null,null,{"$f":"Summary!F21","v":"Enter Project Start Date"},{"$f":"Summary!G21","v":"Enter Project Start Date"},{"$f":"Summary!H21","v":"Enter Project Start Date"},{"$f":"Summary!I21","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!O7","v":"Enter Project Start Date"},null,{"$f":"Summary!L21","v":"Enter Project Start Date"},{"$f":"Summary!M21","v":"Enter Project Start Date"},{"$f":"Summary!N21","v":"Enter Project Start Date"},{"$f":"Summary!O21","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!P7","v":"Enter Project Start Date"},null,{"$f":"Summary!R21","v":"Enter Project Start Date"},{"$f":"Summary!S21","v":"Enter Project Start Date"},{"$f":"Summary!T21","v":"Enter Project Start Date"},{"$f":"Summary!U21","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!Q7","v":"Enter Project Start Date"},null,{"$f":"Summary!X21","v":"Enter Project Start Date"},{"$f":"Summary!Y21","v":"Enter Project Start Date"},{"$f":"Summary!Z21","v":"Enter Project Start Date"},{"$f":"Summary!AA21","v":"Enter Project Start Date"},{"$f":"'Labour Expenditure'!R7","v":"Enter Project Start Date"}]
[null,null,null,null,null,{"$f":"Summary!F22","v":"to"},{"$f":"Summary!G22","v":"to"},{"$f":"Summary!H22","v":"to"},{"$f":"Summary!I22","v":"to"},{"$f":"'Labour Expenditure'!O8","v":"to"},null,{"$f":"Summary!L22","v":"to"},{"$f":"Summary!M22","v":"to"},{"$f":"Summary!N22","v":"to"},{"$f":"Summary!O22","v":"to"},{"$f":"'Labour Expenditure'!P8","v":"to"},null,{"$f":"Summary!R22","v":"to"},{"$f":"Summary!S22","v":"to"},{"$f":"Summary!T22","v":"to"},{"$f":"Summary!U22","v":"to"},{"$f":"'Labour Expenditure'!Q8","v":"to"},null,{"$f":"Summary!X22","v":"to"},{"$f":"Summary!Y22","v":"to"},{"$f":"Summary!Z22","v":"to"},{"$f":"Summary!AA22","v":"to"},{"$f":"'Labour Expenditure'!R8","v":"to"},null,"Total"]
[null,null,null,null,null,{"$f":"Summary!F23","v":"Enter Project End Date"},{"$f":"Summary!G23","v":"Enter Project End Date"},{"$f":"Summary!H23","v":"Enter Project End Date"},{"$f":"Summary!I23","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!O9","v":"Enter Project End Date"},null,{"$f":"Summary!L23","v":"Enter Project End Date"},{"$f":"Summary!M23","v":"Enter Project End Date"},{"$f":"Summary!N23","v":"Enter Project End Date"},{"$f":"Summary!O23","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!P9","v":"Enter Project End Date"},null,{"$f":"Summary!R23","v":"Enter Project End Date"},{"$f":"Summary!S23","v":"Enter Project End Date"},{"$f":"Summary!T23","v":"Enter Project End Date"},{"$f":"Summary!U23","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!Q9","v":"Enter Project End Date"},null,{"$f":"Summary!X23","v":"Enter Project End Date"},{"$f":"Summary!Y23","v":"Enter Project End Date"},{"$f":"Summary!Z23","v":"Enter Project End Date"},{"$f":"Summary!AA23","v":"Enter Project End Date"},{"$f":"'Labour Expenditure'!R9","v":"Enter Project End Date"}]
[null,"Salary Expenditure",null,null,null,0,0,0,0,{"$f":"SUM(F24:I24)","v":0},null,0,0,0,0,{"$f":"SUM(L24:O24)","v":0},null,0,0,0,0,{"$f":"SUM(R24:U24)","v":0},null,0,0,0,0,{"$f":"SUM(X24:AA24)","v":0},null,{"$f":"J24+P24+V24+AB24","v":0}]
[null,"Contract Expenditure",null,null,null,0,0,0,0,0,null,0,0,0,0,{"$f":"SUM(L25:O25)","v":0},null,0,0,0,0,{"$f":"SUM(R25:U25)","v":0},null,0,0,0,0,0,null,{"$f":"J25+P25+V25+AB25","v":0}]
[null,"Plant Expenditure",null,null,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0]
[null,"SMP/PMP Expenditure",null,null,null,0,0,0,0,{"$f":"SUM(F27:I27)","v":0},null,0,0,0,0,{"$f":"SUM(L27:O27)","v":0},null,0,0,0,0,{"$f":"SUM(R27:U27)","v":0},null,0,0,0,0,{"$f":"SUM(X27:AA27)","v":0},null,{"$f":"J27+P27+V27+AB27","v":0}]
[null,"Prototype Expenditure",null,null,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0]
[null,"Other Expenditure",null,null,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,0,0,null,0]
[null,"Total eligible expenditure",null,null,null,{"$f":"SUM(F24:F29)","v":0},{"$f":"SUM(G24:G29)","v":0},{"$f":"SUM(H24:H29)","v":0},{"$f":"SUM(I24:I29)","v":0},0,null,{"$f":"SUM(L24:L29)","v":0},{"$f":"SUM(M24:M29)","v":0},{"$f":"SUM(N24:N29)","v":0},{"$f":"SUM(O24:O29)","v":0},0,null,{"$f":"SUM(R24:R29)","v":0},{"$f":"SUM(S24:S29)","v":0},{"$f":"SUM(T24:T29)","v":0},{"$f":"SUM(U24:U29)","v":0},0,null,{"$f":"SUM(X24:X29)","v":0},{"$f":"SUM(Y24:Y29)","v":0},{"$f":"SUM(Z24:Z29)","v":0},{"$f":"SUM(AA24:AA29)","v":0},0,null,0]
[]
[]
["Total Project Costs:",null,{"$f":"Summary!C8","v":0}]
["Grant Percentage (max 50%)",null,{"$f":"Summary!C9","v":0}]
["Grant Sought (max 50%):",null,{"$f":"Summary!C10","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Summary of Differences Between Forecasted Expenditure In Agreement and Current Forecast"]
[null,null,null,null,null,"Q1","Q2","Q3","Q4",{"$f":"J20","v":"Year 1"},null,"Q1","Q2","Q3","Q4",{"$f":"P20","v":"Year 2"},null,"Q1","Q2","Q3","Q4",{"$f":"V20","v":"Year 3"},null,"Q1","Q2","Q3","Q4",{"$f":"AB20","v":"Year4"}]
[null,null,null,null,null,{"$f":"F21","v":"Enter Project Start Date"},"Enter Project Start Date","Enter Project Start Date","Enter Project Start Date",{"$f":"J21","v":"Enter Project Start Date"},null,{"$f":"L21","v":"Enter Project Start Date"},"Enter Project Start Date","Enter Project Start Date","Enter Project Start Date",{"$f":"P21","v":"Enter Project Start Date"},null,{"$f":"R21","v":"Enter Project Start Date"},"Enter Project Start Date","Enter Project Start Date","Enter Project Start Date",{"$f":"V21","v":"Enter Project Start Date"},null,{"$f":"X21","v":"Enter Project Start Date"},"Enter Project Start Date","Enter Project Start Date","Enter Project Start Date",{"$f":"AB21","v":"Enter Project Start Date"}]
[null,null,null,null,null,"to","to","to","to",{"$f":"J22","v":"to"},null,"to","to","to","to",{"$f":"P22","v":"to"},null,"to","to","to","to",{"$f":"V22","v":"to"},null,"to","to","to","to",{"$f":"AB22","v":"to"},null,"Total"]
[null,null,null,null,null,"Enter Project End Date","Enter Project End Date","Enter Project End Date","Enter Project End Date",{"$f":"J23","v":"Enter Project End Date"},null,"Enter Project End Date","Enter Project End Date","Enter Project End Date","Enter Project End Date",{"$f":"P23","v":"Enter Project End Date"},null,"Enter Project End Date","Enter Project End Date","Enter Project End Date","Enter Project End Date",{"$f":"V23","v":"Enter Project End Date"},null,"Enter Project End Date","Enter Project End Date","Enter Project End Date","Enter Project End Date",{"$f":"AB23","v":"Enter Project End Date"}]
[null,"Salary Expenditure",null,null,null,{"$f":"Summary!F24-Variances!F24","v":0},{"$f":"Summary!G24-Variances!G24","v":0},{"$f":"Summary!H24-Variances!H24","v":0},{"$f":"Summary!I24-Variances!I24","v":0},{"$f":"SUM(F48:I48)","v":0},null,{"$f":"Summary!L24-Variances!L24","v":0},{"$f":"Summary!M24-Variances!M24","v":0},{"$f":"Summary!N24-Variances!N24","v":0},{"$f":"Summary!O24-Variances!O24","v":0},{"$f":"SUM(L48:O48)","v":0},null,{"$f":"Summary!R24-Variances!R24","v":0},{"$f":"Summary!S24-Variances!S24","v":0},{"$f":"Summary!T24-Variances!T24","v":0},{"$f":"Summary!U24-Variances!U24","v":0},{"$f":"SUM(R48:U48)","v":0},null,{"$f":"Summary!X24-Variances!X24","v":0},{"$f":"Summary!Y24-Variances!Y24","v":0},{"$f":"Summary!Z24-Variances!Z24","v":0},{"$f":"Summary!AA24-Variances!AA24","v":0},{"$f":"SUM(X48:AA48)","v":0},null,{"$f":"J48+P48+V48+AB48","v":0}]
[null,"Contract Expenditure",null,null,null,{"$f":"Summary!F25-Variances!F25","v":0},{"$f":"Summary!G25-Variances!G25","v":0},{"$f":"Summary!H25-Variances!H25","v":0},{"$f":"Summary!I25-Variances!I25","v":0},0,null,{"$f":"Summary!L25-Variances!L25","v":0},{"$f":"Summary!M25-Variances!M25","v":0},{"$f":"Summary!N25-Variances!N25","v":0},{"$f":"Summary!O25-Variances!O25","v":0},{"$f":"SUM(L49:O49)","v":0},null,{"$f":"Summary!R25-Variances!R25","v":0},{"$f":"Summary!S25-Variances!S25","v":0},{"$f":"Summary!T25-Variances!T25","v":0},{"$f":"Summary!U25-Variances!U25","v":0},{"$f":"SUM(R49:U49)","v":0},null,{"$f":"Summary!X25-Variances!X25","v":0},{"$f":"Summary!Y25-Variances!Y25","v":0},{"$f":"Summary!Z25-Variances!Z25","v":0},{"$f":"Summary!AA25-Variances!AA25","v":0},0,null,{"$f":"J49+P49+V49+AB49","v":0}]
[null,"Plant Expenditure",null,null,null,{"$f":"Summary!F26-Variances!F26","v":0},{"$f":"Summary!G26-Variances!G26","v":0},{"$f":"Summary!H26-Variances!H26","v":0},{"$f":"Summary!I26-Variances!I26","v":0},0,null,{"$f":"Summary!L26-Variances!L26","v":0},{"$f":"Summary!M26-Variances!M26","v":0},{"$f":"Summary!N26-Variances!N26","v":0},{"$f":"Summary!O26-Variances!O26","v":0},0,null,{"$f":"Summary!R26-Variances!R26","v":0},{"$f":"Summary!S26-Variances!S26","v":0},{"$f":"Summary!T26-Variances!T26","v":0},{"$f":"Summary!U26-Variances!U26","v":0},0,null,{"$f":"Summary!X26-Variances!X26","v":0},{"$f":"Summary!Y26-Variances!Y26","v":0},{"$f":"Summary!Z26-Variances!Z26","v":0},{"$f":"Summary!AA26-Variances!AA26","v":0},0,null,0]
[null,"SMP/PMP Expenditure",null,null,null,{"$f":"Summary!F27-Variances!F27","v":0},{"$f":"Summary!G27-Variances!G27","v":0},{"$f":"Summary!H27-Variances!H27","v":0},{"$f":"Summary!I27-Variances!I27","v":0},{"$f":"SUM(F51:I51)","v":0},null,{"$f":"Summary!L27-Variances!L27","v":0},{"$f":"Summary!M27-Variances!M27","v":0},{"$f":"Summary!N27-Variances!N27","v":0},{"$f":"Summary!O27-Variances!O27","v":0},{"$f":"SUM(L51:O51)","v":0},null,{"$f":"Summary!R27-Variances!R27","v":0},{"$f":"Summary!S27-Variances!S27","v":0},{"$f":"Summary!T27-Variances!T27","v":0},{"$f":"Summary!U27-Variances!U27","v":0},{"$f":"SUM(R51:U51)","v":0},null,{"$f":"Summary!X27-Variances!X27","v":0},{"$f":"Summary!Y27-Variances!Y27","v":0},{"$f":"Summary!Z27-Variances!Z27","v":0},{"$f":"Summary!AA27-Variances!AA27","v":0},{"$f":"SUM(X51:AA51)","v":0},null,{"$f":"J51+P51+V51+AB51","v":0}]
[null,"Prototype Expenditure",null,null,null,{"$f":"Summary!F28-Variances!F28","v":0},{"$f":"Summary!G28-Variances!G28","v":0},{"$f":"Summary!H28-Variances!H28","v":0},{"$f":"Summary!I28-Variances!I28","v":0},0,null,{"$f":"Summary!L28-Variances!L28","v":0},{"$f":"Summary!M28-Variances!M28","v":0},{"$f":"Summary!N28-Variances!N28","v":0},{"$f":"Summary!O28-Variances!O28","v":0},0,null,{"$f":"Summary!R28-Variances!R28","v":0},{"$f":"Summary!S28-Variances!S28","v":0},{"$f":"Summary!T28-Variances!T28","v":0},{"$f":"Summary!U28-Variances!U28","v":0},0,null,{"$f":"Summary!X28-Variances!X28","v":0},{"$f":"Summary!Y28-Variances!Y28","v":0},{"$f":"Summary!Z28-Variances!Z28","v":0},{"$f":"Summary!AA28-Variances!AA28","v":0},0,null,0]
[null,"Other Expenditure",null,null,null,{"$f":"Summary!F29-Variances!F29","v":0},{"$f":"Summary!G29-Variances!G29","v":0},{"$f":"Summary!H29-Variances!H29","v":0},{"$f":"Summary!I29-Variances!I29","v":0},0,null,{"$f":"Summary!L29-Variances!L29","v":0},{"$f":"Summary!M29-Variances!M29","v":0},{"$f":"Summary!N29-Variances!N29","v":0},{"$f":"Summary!O29-Variances!O29","v":0},0,null,{"$f":"Summary!R29-Variances!R29","v":0},{"$f":"Summary!S29-Variances!S29","v":0},{"$f":"Summary!T29-Variances!T29","v":0},{"$f":"Summary!U29-Variances!U29","v":0},0,null,{"$f":"Summary!X29-Variances!X29","v":0},{"$f":"Summary!Y29-Variances!Y29","v":0},{"$f":"Summary!Z29-Variances!Z29","v":0},{"$f":"Summary!AA29-Variances!AA29","v":0},0,null,0]
[null,"Total eligible expenditure",null,null,null,{"$f":"SUM(F48:F53)","v":0},{"$f":"SUM(G48:G53)","v":0},{"$f":"SUM(H48:H53)","v":0},{"$f":"SUM(I48:I53)","v":0},0,null,{"$f":"SUM(L48:L53)","v":0},{"$f":"SUM(M48:M53)","v":0},{"$f":"SUM(N48:N53)","v":0},{"$f":"SUM(O48:O53)","v":0},0,null,{"$f":"SUM(R48:R53)","v":0},{"$f":"SUM(S48:S53)","v":0},{"$f":"SUM(T48:T53)","v":0},{"$f":"SUM(U48:U53)","v":0},0,null,{"$f":"SUM(X48:X53)","v":0},{"$f":"SUM(Y48:Y53)","v":0},{"$f":"SUM(Z48:Z53)","v":0},{"$f":"SUM(AA48:AA53)","v":0},0,null,0]
[]
[]
["Difference in Project Costs:",null,{"$f":"ROUNDDOWN((C33-C8),0)","v":0}]
["Difference in Grant %",null,{"$f":"C34-C9","v":0}]
["Difference in Grant Sought:",null,{"$f":"ROUNDDOWN((C35-C10),0)","v":0}]
[]
["Difference in Estimated Activity Proportions:"]
["Research and development:"]
["Proof of Concept:"]
["Early Stage Commercialisation:"]

{"sheet":"Warnings","index":4,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,3,4,9],[5,3,5,9],[6,3,6,9],[7,3,7,9],[15,3,15,9],[14,3,14,9],[8,3,8,9],[9,3,9,9],[10,3,10,9]]}
["Accelerating Commercialisation"]
[]
["Warnings where expenditure appears outside guidelines"]
[]
[null,null,null,"The nature of the organisation on the Summary page must be specified",null,null,null,null,null,null,{"$f":"IF(Summary!C12=\"Please Select\",\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\")","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"}]
[null,null,null,"Project period must not commence before 1/11/2014",null,null,null,null,null,null,{"$f":"IF(Summary!C4=0,\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\",IF(AND(Summary!C4>=O6,Summary!C5<=P6),\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\",\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\"))","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"},null,null,null,"2014-11-01","2030-06-30",{"$f":"IF(K6=\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\",1,0)","v":0}]
[null,null,null,"Project period cannot exceed 2 years",null,null,null,null,null,null,{"$f":"IF(Summary!C5-Summary!C4<=(365*2),\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\",\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\")","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"},null,null,null,null,null,0]
[null,null,null,"Grant Amount cannot exceed 50% of Total Project Costs",null,null,null,null,null,null,{"$f":"IF(Summary!C10>Summary!D10,\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\")","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"},null,null,null,null,null,0]
[null,null,null,"Total overseas expenditure is limited to 10% of total expenditure, unless a higher limit is approved by the Programme Delegate",null,null,null,null,null,null,{"$f":"IF($G$42>T9,\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, SPECIAL APPROVAL IS REQUIRED - PLEASE CONTACT YOUR CSM\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\")","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"},null,{"$f":"IF(AND(G37=0,Summary!C8=0),0,G37/Summary!C8)","v":0},{"$f":"G37","v":0},"Total Overseas Expenditure Rate",null,{"$f":"IF(K9=\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, SPECIAL APPROVAL IS REQUIRED - PLEASE CONTACT YOUR CSM\",1,0)","v":0},null,"Overseas Expenditure Rate",0.1]
[null,null,null,"IP expenditure is limited to 10% of total expenditure",null,null,null,null,null,null,{"$f":"IF(K42>T10,\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\")","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"}]
[null,null,null,"SMP/PMP Expenditure is limited to amount approved by the Programme Delegate",null,null,null,null,null,null,{"$f":"IF(T11=\"\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\",IF(Summary!AD27>Warnings!T11,\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, SPECIAL APPROVAL IS REQUIRED - PLEASE CONTACT YOUR CSM\",\"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES\"))","v":"OK - CURRENT INFORMATION IS WITHIN ELIGIBLE EXPENDITURE GUIDELINES"},null,null,{"$f":"K41","v":0},"Total SMP/PMP Expenditure",null,{"$f":"IF(K11=\"WARNING - NOT WITHIN ELIGIBLE EXPENDITURE GUIDELINES, PLEASE AMEND\",1,0)","v":0},null,"SMP/PMP Expenditure Amount"]
[]
["Warnings following project commencement where expenditure is inconsistent with agreed funding"]
[]
[null,null,null,"Expenditure now exceeds that previously agreed",null,null,null,null,null,null,{"$f":"IF(Variances!AD54>0,\"WARNING - YOUR CURRENT FORECAST IS NOT IN ACCORDANCE WITH YOUR AGREEMENT - PLEASE DISCUSS WITH YOUR CSM\",\"OK - YOUR CURRENT FORECAST IS IN ACCORDANCE WITH YOUR AGREEMENT\")","v":"OK - YOUR CURRENT FORECAST IS IN ACCORDANCE WITH YOUR AGREEMENT"}]
[]
["AusIndustry Internal Use Only"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Overseas Expenditure",null,"O/S",{"$f":"SUM('Labour Expenditure'!O59:R59,'Contract Expenditure'!M55:P55,'Plant Expenditure'!M50:P50,'SMP-PMP Expenditure'!M27:P27,'Prototype Expenditure'!M26:P26,'Other Expenditure'!I25:L25)","v":0},"Tech",{"$f":"SUM('Labour Expenditure'!O58:R58,'Contract Expenditure'!M54:P54,'Plant Expenditure'!M49:P49,'SMP-PMP Expenditure'!M26:P26,'Prototype Expenditure'!M25:P25,'Other Expenditure'!I24:L24)","v":0}]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G37:G37)","v":0},null,{"$f":"SUM(I37)","v":0},null,{"$f":"Summary!AD30","v":0},null,"Totall Expenditure"]
[null,null,null,null,null,null,{"$f":"Summary!AD30","v":0},null,{"$f":"Summary!AD30","v":0},null,{"$f":"Summary!AD27","v":0},null,"SMP/PMP Expenditure"]
[null,null,null,null,null,null,{"$f":"IF(AND(G40=0,G41=0),0,(G40/G41))","v":0},null,{"$f":"IF(AND(I40=0,I41=0),0,I40/I41)","v":0},null,{"$f":"IF(AND(K40=0,K41=0),0,(K41/K40))","v":0}]
[]
[]
["!"]

{"sheet":"Labour Expenditure","index":5,"n_rows":59,"n_cols":193,"rows_kept":59,"cut":false,"hidden":false,"merged":[[11,2,11,3],[11,4,11,5],[6,4,8,5],[9,4,9,5],[52,14,52,17],[40,14,40,17],[50,5,50,7],[49,2,49,11],[47,3,47,7],[31,10,33,11],[31,9,33,9],[36,10,36,11],[36,2,36,9],[35,10,35,11],[34,10,34,11],[35,2,35,9],[31,8,33,8],[34,2,34,9],[31,7,33,7],[31,2,33,2],[31,4,33,4],[7,61,7,64],[7,43,7,45],[19,43,19,53],[6,7,8,7],[9,2,9,3],[10,2,10,3],[10,4,10,5],[13,2,13,3],[6,8,8,8],[6,6,8,6],[13,4,13,5],[18,2,20,3],[6,2,8,3],[6,9,8,9],[12,2,12,3],[12,4,12,5],[30,14,30,17],[22,2,22,3],[21,2,21,3],[18,4,20,5],[18,6,20,6],[23,4,23,5],[18,10,20,10],[18,11,20,11],[18,9,20,9],[25,2,25,3],[24,2,24,3],[25,4,25,5],[22,4,22,5],[23,2,23,3],[24,4,24,5],[21,4,21,5],[5,14,5,17],[18,7,20,7],[6,11,8,11],[6,10,8,10],[17,14,17,17],[18,8,20,8]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,{"$f":"Summary!C5","v":"00:00:00"},null,"Project Period:",null,{"$f":"Summary!$C$4","v":"00:00:00"},"to",{"$f":"Summary!$C$5","v":"00:00:00"},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,null,null,null,null,null,null,null,"Year","Year",{"$f":"YEAR(AS2)","v":3799},3799,3800,3800,3800,3800,3801,3801,3801,3801,3802,3802,3802,3802,3803,3803,3803]
[null,"1. Labour Expenditure",null,null,null,null,"Project Period:",null,null,null,null,null,null,null,"2004-07-01","2005-07-01","2006-07-01","2007-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Q","Start Q",{"$f":"Summary!F5","v":"3799-07-01"},{"$f":"AS4","v":"3799-10-01"},{"$f":"AT4","v":"3800-01-01"},"3800-04-01","3800-07-01","3800-10-01","3801-01-01","3801-04-01","3801-07-01","3801-10-01","3802-01-01","3802-04-01","3802-07-01","3802-10-01","3803-01-01","3803-04-01",695239,null,30000,"do not change graduate supervisor limit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2005-06-30","2006-06-30","2007-06-30","2008-06-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Q","End Q",{"$f":"DATE(AS1,AS5,AS6)","v":"3799-10-01"},{"$f":"DATE(AT1,AT5,AT6)","v":"3800-01-01"},{"$f":"DATE(AU1,AU5,AU6)","v":"3800-04-01"},"3800-07-01","3800-10-01","3801-01-01","3801-04-01","3801-07-01","3801-10-01","3802-01-01","3802-04-01","3802-07-01","3802-10-01","3803-01-01","3803-04-01","3803-07-01",695331]
["Y","A. Salary (only employees directly working on project)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month+3","Month+3",{"$f":"MONTH(AS2)+3","v":10},{"$f":"MONTH(AT2)+3","v":13},{"$f":"MONTH(AU2)+3","v":4},7,10,13,4,7,10,13,4,7,10,13,4,7,10]
["N",null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,"Day","Day",{"$f":"DAY(AS2)","v":1},{"$f":"DAY(AT2)","v":1},{"$f":"DAY(AU2)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["General",null,"Employee Name",null,"Employee Title",null,"Is the employee a Director or a Shareholder (Y/N)?","Annual salary","Period to be employed on project Start","Period to be employed on project End","% of time on \nproject*","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conditional formatting set up for salary costs - Table 1"]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"},null,null,null,"CALCULATES SALARY EXPENSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALARY EXPENSE BY QUARTER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Testing to see if annual costs exceed salary",null,null,null,null,null,null,null,null,null,null,null,null,null,"Workings  to test if the quaterly costs are greater that 30% of the annual costs"]
["Experienced Executive",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4"]
["Overseas Experienced Executive",{"$f":"IF(OR(L10=\"Experienced Executive\",L10=\"Overseas Experienced Executive\"),250000,175000)","v":175000},"Insert Employee Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T10:W10)","v":0},{"$f":"SUM(Z10:AC10)","v":0},{"$f":"SUM(AF10:AI10)","v":0},{"$f":"SUM(AL10:AO10)","v":0},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,null,{"$f":"(IF($I10<AS$2,IF($J10<AS$4,(((AS$4-AS$2)-(AS$4-$J10-1))/(AT$2-AS$2))*($H10*$K10),($H10*$K10)),IF($J10<AS$4,(((AS$4-AS$2)-(($I10-AS$2)+(AS$4-$J10-1)))/(AS$4-AS$2))*($H10*$K10),(((AS$4-AS$2)-($I10-AS$2))/(AS$4-AS$2))*($H10*$K10))))*((AS$4-AS$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AS10>0,AS10,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(O10>($H10*$K10),1,0)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(T10>(($K10*$H10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(Z10>(($K10*$H10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AF10>(($K10*$H10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AL10>(($K10*$H10)*0.3),1,0)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C10","v":"Insert Employee Name"},{"$f":"E10","v":0}]
[null,{"$f":"IF(OR(L11=\"Experienced Executive\",L11=\"Overseas Experienced Executive\"),250000,175000)","v":175000},"Insert Employee Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T11:W11)","v":0},{"$f":"SUM(Z11:AC11)","v":0},{"$f":"SUM(AF11:AI11)","v":0},{"$f":"SUM(AL11:AO11)","v":0},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,null,{"$f":"(IF($I11<AS$2,IF($J11<AS$4,(((AS$4-AS$2)-(AS$4-$J11-1))/(AT$2-AS$2))*($H11*$K11),($H11*$K11)),IF($J11<AS$4,(((AS$4-AS$2)-(($I11-AS$2)+(AS$4-$J11-1)))/(AS$4-AS$2))*($H11*$K11),(((AS$4-AS$2)-($I11-AS$2))/(AS$4-AS$2))*($H11*$K11))))*((AS$4-AS$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AS11>0,AS11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(T11>(($K11*$H11)*0.3),1,0)","v":0},{"$f":"IF(U11>(($K11*$H11)*0.3),1,0)","v":0},0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C11","v":"Insert Employee Name"},{"$f":"E11","v":0}]
[null,175000,"Insert Employee Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T12:W12)","v":0},0,0,0,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,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(O12>($H12*$K12),1,0)","v":0},{"$f":"IF(P12>($H12*$K12),1,0)","v":0},{"$f":"IF(Q12>($H12*$K12),1,0)","v":0},{"$f":"IF(R12>($H12*$K12),1,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(T12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(U12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(V12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(W12>(($K12*$H12)*0.3),1,0)","v":0},null,{"$f":"IF(Z12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AA12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AB12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AC12>(($K12*$H12)*0.3),1,0)","v":0},null,{"$f":"IF(AF12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AG12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AH12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AI12>(($K12*$H12)*0.3),1,0)","v":0},null,{"$f":"IF(AL12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AM12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AN12>(($K12*$H12)*0.3),1,0)","v":0},{"$f":"IF(AO12>(($K12*$H12)*0.3),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Insert Employee Name",0]
["Overseas Experienced Executive",{"$f":"IF(OR(L13=\"Experienced Executive\",L13=\"Overseas Experienced Executive\"),250000,175000)","v":175000},"Insert Employee Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,0,0,0,0,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,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(T13>(($K13*$H13)*0.3),1,0)","v":0},{"$f":"IF(U13>(($K13*$H13)*0.3),1,0)","v":0},0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Employee Name",0]
[null,175000,null,null,null,null,null,null,null,null,null,null,"Ineligible",null,0,0,0,0,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,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(O14>($H14*$K14),1,0)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(T14>(($K14*$H14)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(Z14>(($K14*$H14)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AF14>(($K14*$H14)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AL14>(($K14*$H14)*0.3),1,0)","v":0},0,0,0]
[null,null,null,null,"Total A: Total Salary Expenditure",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O10:O14)","v":0},{"$f":"ROUNDDOWN(SUM(P10:P14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Q10:Q14),0)","v":0},{"$f":"ROUNDDOWN(SUM(R10:R14),0)","v":0},null,{"$f":"(SUM(T10:T14))","v":0},{"$f":"(SUM(U10:U14))","v":0},{"$f":"(SUM(V10:V14))","v":0},{"$f":"(SUM(W10:W14))","v":0},null,null,{"$f":"(SUM(Z10:Z14))","v":0},{"$f":"(SUM(AA10:AA14))","v":0},{"$f":"(SUM(AB10:AB14))","v":0},{"$f":"(SUM(AC10:AC14))","v":0},null,null,{"$f":"(SUM(AF10:AF14))","v":0},{"$f":"(SUM(AG10:AG14))","v":0},{"$f":"(SUM(AH10:AH14))","v":0},{"$f":"(SUM(AI10:AI14))","v":0},null,null,{"$f":"(SUM(AL10:AL14))","v":0},{"$f":"(SUM(AM10:AM14))","v":0},{"$f":"(SUM(AN10:AN14))","v":0},{"$f":"(SUM(AO10:AO14))","v":0}]
[null,null,{"$f":"IF(SUM(CB10:CE14)>0,\"WARNING YOUR ANNUAL COSTS FOR THIS EMPLOYEE HAVE EXCEEDED THEIR SALARY IN THE HIGHLIGHTED YEAR, PLEASE AMEND\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CO10:DG15)>0,\"WARNING YOUR QUARTERLY COSTS FOR THIS EMPLOYEE HAVE EXCEEDED MORE THAN 30% OF THEIR ANNUAL SALARY IN THE HIGHLIGHTED QUARTER, PLEASE AMEND\",\"\")","v":""}]
[null,"B. Graduate Salary Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1","Q2","Q3","Q4",null,"Q1","Q2","Q3","Q4",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,null,null,null,"Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4","Q1","Q2","Q3","Q4"]
[null,null,"Graduate Name",null,"Supervisor Name",null,"Supervisor Full time salary","Graduate full time annual salary","Period to be employed on project Start","Period to be employed on project End","% of time on \nproject*","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},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,null,null,null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},null,"Conditional formatting set up for salary costs - Table 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"},null,null,null,"CALCULATES GRADUATE SALARY EXPENSE (Step 1: Sorts the calaculation into correct date formula)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRADUATE SALARY EXPENSE BY QUARTER (Step 2: Ensures only positive numbers from step two are used in calculation (avoids another if))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPERVISOR EXPENSE (step 1, ENSURES WE DO NOT INCLUDE THE SAME SUPERVISOR ON MORE THAN ONE GRADUATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPERVISOR EXPENSE (step 2, ENSURES WE DO NOT MORE THAN MAX PER YEAR",null,null,null,null,null,null,null,null,null,null,"Enter Max per Year:",null,null,15000,null,null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},"TOTAL",{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},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,null,null,null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"},null,"Testing to see if annual costs exceed salary",null,null,null,null,null,null,null,"Workings  to test if the quarterly costs are greater that 30% of the annual costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},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,null,null,null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Insert Graduate Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T22:W22)","v":0},{"$f":"SUM(Z22:AC22)","v":0},{"$f":"SUM(AF22:AI22)","v":0},{"$f":"SUM(AL22:AO22)","v":0},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,null,{"$f":"(IF($I22<AS$2,IF($J22<AS$4,(((AS$4-AS$2)-(AS$4-$J22-1))/(AT$2-AS$2))*($H22*$K22),($H22*$K22)),IF($J22<AS$4,(((AS$4-AS$2)-(($I22-AS$2)+(AS$4-$J22-1)))/(AS$4-AS$2))*($H22*$K22),(((AS$4-AS$2)-($I22-AS$2))/(AS$4-AS$2))*($H22*$K22))))*((AS$4-AS$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AS22>0,AS22,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(BK22=0,0,($G22*$K$37)*(T22/$H22))","v":0},0,0,0,{"$f":"IF(BO22=0,0,($G22*$K$37)*(Z22/$H22))","v":0},0,0,0,{"$f":"IF(BS22=0,0,($G22*$K$37)*(AF22/$H22))","v":0},0,0,0,{"$f":"IF(BW22=0,0,($G22*$K$37)*(AL22/$H22))","v":0},0,0,0,null,{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},{"$f":"IF(COUNTIF($E22:$F$22,$E22)>1,\"null\",$E22)","v":0},null,{"$f":"IF(CS22=\"null\",0,SUMIF($E$22:$F$26,CS22,CB$22:CB$26))","v":0},0,0,0,{"$f":"SUM(DJ22:DM22)","v":0},{"$f":"IF(CW22=\"null\",0,SUMIF($E$22:$F$26,CW22,CF$22:CF$26))","v":0},0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O22>($H22*$K22),1,0)","v":0},0,0,0,null,null,null,{"$f":"IF(T22>(($K22*$H22)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(Z22>(($K22*$H22)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AF22>(($K22*$H22)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AL22>(($K22*$H22)*0.3),1,0)","v":0},0,0,0]
[null,null,"Insert Graduate Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T23:W23)","v":0},{"$f":"SUM(Z23:AC23)","v":0},{"$f":"SUM(AF23:AI23)","v":0},{"$f":"SUM(AL23:AO23)","v":0},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,null,{"$f":"(IF($I23<AS$2,IF($J23<AS$4,(((AS$4-AS$2)-(AS$4-$J23-1))/(AT$2-AS$2))*($H23*$K23),($H23*$K23)),IF($J23<AS$4,(((AS$4-AS$2)-(($I23-AS$2)+(AS$4-$J23-1)))/(AS$4-AS$2))*($H23*$K23),(((AS$4-AS$2)-($I23-AS$2))/(AS$4-AS$2))*($H23*$K23))))*((AS$4-AS$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AS23>0,AS23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},{"$f":"IF(COUNTIF($E$22:$F23,$E23)>1,\"null\",$E23)","v":0},null,0,0,0,0,{"$f":"SUM(DJ23:DM23)","v":0},0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,"Insert Graduate Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T24:W24)","v":0},{"$f":"SUM(Z24:AC24)","v":0},{"$f":"SUM(AF24:AI24)","v":0},{"$f":"SUM(AL24:AO24)","v":0},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,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},{"$f":"IF(COUNTIF($E$22:$F24,$E24)>1,\"null\",$E24)","v":0},null,0,0,0,0,{"$f":"SUM(DJ24:DM24)","v":0},0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,"Insert Graduate Name",null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T25:W25)","v":0},{"$f":"SUM(Z25:AC25)","v":0},{"$f":"SUM(AF25:AI25)","v":0},{"$f":"SUM(AL25:AO25)","v":0},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,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},{"$f":"IF(COUNTIF($E$22:$F25,$E25)>1,\"null\",$E25)","v":0},null,0,0,0,0,{"$f":"SUM(DJ25:DM25)","v":0},0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(T26:W26)","v":0},{"$f":"SUM(Z26:AC26)","v":0},{"$f":"SUM(AF26:AI26)","v":0},{"$f":"SUM(AL26:AO26)","v":0},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,null,{"$f":"(IF($I26<AS$2,IF($J26<AS$4,(((AS$4-AS$2)-(AS$4-$J26-1))/(AT$2-AS$2))*($H26*$K26),($H26*$K26)),IF($J26<AS$4,(((AS$4-AS$2)-(($I26-AS$2)+(AS$4-$J26-1)))/(AS$4-AS$2))*($H26*$K26),(((AS$4-AS$2)-($I26-AS$2))/(AS$4-AS$2))*($H26*$K26))))*((AS$4-AS$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AS26>0,AS26,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},{"$f":"IF(COUNTIF($E$26:$F26,$E26)>1,\"null\",$E26)","v":0},null,0,0,0,0,{"$f":"SUM(DJ26:DM26)","v":0},0,0,0,0,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,"Total B: Graduate Salaries",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O22:O26)","v":0},{"$f":"SUM(P22:P26)","v":0},{"$f":"SUM(Q22:Q26)","v":0},{"$f":"SUM(R22:R26)","v":0},null,{"$f":"SUM(T22:T26)","v":0},{"$f":"SUM(U22:U26)","v":0},{"$f":"SUM(V22:V26)","v":0},{"$f":"SUM(W22:W26)","v":0},null,null,{"$f":"SUM(Z22:Z26)","v":0},{"$f":"SUM(AA22:AA26)","v":0},{"$f":"SUM(AB22:AB26)","v":0},{"$f":"SUM(AC22:AC26)","v":0},null,null,{"$f":"SUM(AF22:AF26)","v":0},{"$f":"SUM(AG22:AG26)","v":0},{"$f":"SUM(AH22:AH26)","v":0},{"$f":"SUM(AI22:AI26)","v":0},null,null,{"$f":"SUM(AL22:AL26)","v":0},{"$f":"SUM(AM22:AM26)","v":0},{"$f":"SUM(AN22:AN26)","v":0},{"$f":"SUM(AO22:AO26)","v":0}]
[null,null,{"$f":"IF(SUM(FL23:FO26)>0,\"WARNING YOUR ANNUAL COSTS FOR THIS GRADUATE HAVE EXCEEDED THEIR SALARY IN THE HIGHLIGHTED YEAR, PLEASE AMEND\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(FS23:GK26)>0,\"WARNING YOUR QUARTERLY COSTS FOR THIS GRADUATE HAVE EXCEEDED MORE THAN 30% OF THEIR ANNUAL SALARY IN THE HIGHLIGHTED QUARTER, PLEASE AMEND\",\"\")","v":""}]
[]
[null,"B. On costs and overheads **"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,null,null,null,null,"% of Salaries",null,null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Salary On Costs and Administrative Overheads (set at a rate of 40% )",null,null,null,null,null,null,null,0.4,null,null,null,{"$f":"SUM(T35:W35)","v":0},{"$f":"SUM(Z35:AC35)","v":0},{"$f":"SUM(AF35:AI35)","v":0},{"$f":"SUM(AL35:AO35)","v":0},null,{"$f":"((T15+T27)*$K$35)","v":0},{"$f":"((U15+U27)*$K$35)","v":0},{"$f":"((V15+V27)*$K$35)","v":0},{"$f":"((W15+W27)*$K$35)","v":0},null,null,{"$f":"((Z15+Z27)*$K$35)","v":0},{"$f":"((AA15+AA27)*$K$35)","v":0},{"$f":"((AB15+AB27)*$K$35)","v":0},{"$f":"((AC15+AC27)*$K$35)","v":0},null,null,{"$f":"((AF15+AF27)*$K$35)","v":0},{"$f":"((AG15+AG27)*$K$35)","v":0},{"$f":"((AH15+AH27)*$K$35)","v":0},{"$f":"((AI15+AI27)*$K$35)","v":0},null,null,{"$f":"((AL15+AL27)*$K$35)","v":0},{"$f":"((AM15+AM27)*$K$35)","v":0},{"$f":"((AN15+AN27)*$K$35)","v":0},{"$f":"((AO15+AO27)*$K$35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BK10:BK19)*$K35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Employee Administrative Overhead (included )",null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(T36:W36)","v":0},{"$f":"SUM(Z36:AC36)","v":0},{"$f":"SUM(AF36:AI36)","v":0},{"$f":"SUM(AL36:AO36)","v":0},null,{"$f":"ROUNDDOWN((T15+T27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((U15+U27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((V15+V27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((W15+W27)*$K$36,0)","v":0},null,null,{"$f":"ROUNDDOWN((Z15+Z27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AA15+AA27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AB15+AB27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AC15+AC27)*$K$36,0)","v":0},null,null,{"$f":"ROUNDDOWN((AF15+AF27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AG15+AG27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AH15+AH27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AI15+AI27)*$K$36,0)","v":0},null,null,{"$f":"ROUNDDOWN((AL15+AL27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AM15+AM27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AN15+AN27)*$K$36,0)","v":0},{"$f":"ROUNDDOWN((AO15+AO27)*$K$36,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BK10:BK17)*$K36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Additional costs of Supervisor in relation to Graduate costs",null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(T37:W37)","v":0},{"$f":"SUM(Z37:AC37)","v":0},{"$f":"SUM(AF37:AI37)","v":0},{"$f":"SUM(AL37:AO37)","v":0},null,{"$f":"ROUNDDOWN(IF(T$7=T$9,0,SUM(ED22:ED26)),0)","v":0},{"$f":"ROUNDDOWN(IF(U$7=U$9,0,SUM(EE22:EE26)),0)","v":0},{"$f":"ROUNDDOWN(IF(V$7=V$9,0,SUM(EF22:EF26)),0)","v":0},{"$f":"ROUNDDOWN(IF(W$7=W$9,0,SUM(EG22:EG26)),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(EH22:EH26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EI22:EI26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EJ22:EJ26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EK22:EK26),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(EL22:EL26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EM22:EM26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EN22:EN26),0)","v":0},{"$f":"ROUNDDOWN(SUM(EO22:EO26),0)","v":0},null,null,{"$f":"ROUNDDOWN(IF(AL$7=AL$9,0,SUM(EP22:EP26)),0)","v":0},{"$f":"ROUNDDOWN(IF(AM$7=AM$9,0,SUM(EQ22:EQ26)),0)","v":0},{"$f":"ROUNDDOWN(IF(AN$7=AN$9,0,SUM(ER22:ER26)),0)","v":0},{"$f":"ROUNDDOWN(IF(AO$7=AO$9,0,SUM(ES22:ES26)),0)","v":0}]
[null,null,null,null,"Total B: On costs and overheads",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O35:O37)","v":0},{"$f":"SUM(P35:P37)","v":0},0,0,null,{"$f":"SUM(T35:T37)","v":0},0,0,0,null,null,{"$f":"SUM(Z35:Z37)","v":0},0,0,0,null,null,{"$f":"SUM(AF35:AF37)","v":0},0,0,0,null,null,{"$f":"SUM(AL35:AL37)","v":0},0,0,0]
[]
[]
[null,"C. Total Salary Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Total Labour Expenditure = ",null,"Total A+B",null,null,null,null,null,null,null,null,null,{"$f":"SUM(T45:W45)","v":0},{"$f":"SUM(Z45:AC45)","v":0},{"$f":"SUM(AF45:AI45)","v":0},{"$f":"SUM(AL45:AO45)","v":0},null,{"$f":"ROUNDDOWN((T15+T38+T27),0)","v":0},{"$f":"ROUNDDOWN((U15+U38+U27),0)","v":0},{"$f":"ROUNDDOWN((V15+V38+V27),0)","v":0},0,null,null,{"$f":"ROUNDDOWN((Z15+Z38+Z27),0)","v":0},0,0,0,null,null,{"$f":"ROUNDDOWN((AF15+AF38+AF27),0)","v":0},0,0,0,null,null,{"$f":"ROUNDDOWN((AL15+AL38+AL27),0)","v":0},0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BK10:BK31)+BK35+BK36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"*","Eligible salary costs = Incurred salary in period x Actual time spent on agreed project in period    (See section 3.1.2 of the expenditure guide)."]
[null,null,null,"Actual time employed by grantee in period"]
[null,"**","To calculate both salary on costs and administrative overhead a set rate of 40% can be applied to total remuneration (See section 3.1.1 of expenditure guide)."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$12","v":"00:00:00"},{"$f":"Summary!$R$12","v":"00:00:00"},{"$f":"Summary!$X$12","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$14","v":"00:00:00"},{"$f":"Summary!$O$14","v":"00:00:00"},{"$f":"Summary!$U$14","v":"00:00:00"},{"$f":"Summary!$AA$14","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($L$7:$L$51,\"General\",O$7:O$51)*1.4","v":0},{"$f":"SUMIF($L$7:$L$51,\"General\",P$7:P$51)*1.4","v":0},{"$f":"SUMIF($L$7:$L$51,\"General\",Q$7:Q$51)*1.4","v":0},{"$f":"SUMIF($L$7:$L$51,\"General\",R$7:R$51)*1.4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Tech"]
[null,null,null,null,null,null,null,null,null,null,null,"OS",null,null,{"$f":"(SUMIF($L$7:$L$51,\"Overseas\",O$7:O$51)+SUMIF($L$7:$L$51,\"Overseas Experienced Executive\",O$7:O$51))*1.4","v":0},{"$f":"(SUMIF($L$7:$L$51,\"Overseas\",P$7:P$51)+SUMIF($L$7:$L$51,\"Overseas Experienced Executive\",P$7:P$51))*1.4","v":0},{"$f":"(SUMIF($L$7:$L$51,\"Overseas\",Q$7:Q$51)+SUMIF($L$7:$L$51,\"Overseas Experienced Executive\",Q$7:Q$51))*1.4","v":0},{"$f":"(SUMIF($L$7:$L$51,\"Overseas\",R$7:R$51)+SUMIF($L$7:$L$51,\"Overseas Experienced Executive\",R$7:R$51))*1.4","v":0},{"$f":"(SUMIF($L$7:$L$51,\"Overseas\",S$7:S$51)+SUMIF($L$7:$L$51,\"Overseas Experienced Executive\",S$7:S$51))*1.4","v":0}]

{"sheet":"Contract Expenditure","index":6,"n_rows":55,"n_cols":100,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,1,4,3],[7,59,7,62],[17,12,17,15],[25,2,27,2],[6,2,8,2],[5,12,5,15],[18,8,20,9],[21,8,21,9],[25,8,27,8],[6,9,8,9],[6,8,8,8],[25,9,27,9],[48,12,48,15],[36,12,36,15],[7,41,7,43],[24,12,24,15],[28,3,28,7],[46,3,46,6],[32,3,32,7],[6,3,8,3],[6,5,8,5],[25,3,27,7],[6,4,8,4],[6,7,8,7],[6,6,8,6],[30,3,30,7],[31,3,31,7],[29,3,29,7]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,null,null,null,"Project Period:",{"$f":"Summary!$C$4","v":"00:00:00"},"to",{"$f":"Summary!$C$5","v":"00:00:00"},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,null,null,null,null,null,"Year",{"$f":"YEAR(AP2)","v":3799},3799,3800,3800,3800,3800,3801,3801,3801,3801,3802,3802,3802,3802,3803,3803,3803]
[null,"2. Contract Expenditure",null,null,null,null,null,null,null,null,null,null,"2004-07-01","2005-07-01","2006-07-01","2007-07-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Q",{"$f":"Summary!F5","v":"3799-07-01"},{"$f":"AP4","v":"3799-10-01"},{"$f":"AQ4","v":"3800-01-01"},"3800-04-01","3800-07-01","3800-10-01","3801-01-01","3801-04-01","3801-07-01","3801-10-01","3802-01-01","3802-04-01","3802-07-01","3802-10-01","3803-01-01","3803-04-01","3803-07-01",null,null,"Drop down box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[null,"A. Contract expenditure (contractors working more than 35hrs/week or more on premises)",null,null,null,null,null,null,null,null,null,null,"2005-06-30","2006-06-30","2007-06-30","2008-06-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Q",{"$f":"DATE(AP1,AP5,AP6)","v":"3799-10-01"},{"$f":"DATE(AQ1,AQ5,AQ6)","v":"3800-01-01"},{"$f":"DATE(AR1,AR5,AR6)","v":"3800-04-01"},"3800-07-01","3800-10-01","3801-01-01","3801-04-01","3801-07-01","3801-10-01","3802-01-01","3802-04-01","3802-07-01","3802-10-01","3803-01-01","3803-04-01","3803-07-01","3803-10-01",null,null,"Y"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month+3",{"$f":"MONTH(AP2)+3","v":10},{"$f":"MONTH(AQ2)+3","v":13},{"$f":"MONTH(AR2)+3","v":4},7,10,13,4,7,10,13,4,7,10,13,4,7,10,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,"Day",{"$f":"DAY(AP2)","v":1},{"$f":"DAY(AQ2)","v":1},{"$f":"DAY(AR2)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["General",null,"Contractor Name","Purpose of work","Is the contractor a Director or a Shareholder (Y/N)?","Planned annual payments","Period to be employed on project Start","Period to be employed on project End","% of time on\n project*","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},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,null,null,null,null,null,null,null,null,null,null,null,"Conditional formatting set up for salary costs - Table 1",null,null,null,null,null,"workings to test if quarter costs are >30% of annual costs"]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"},null,null,"CALCULATES Contractor EXPENSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor EXPENSE BY QUARTER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Testing to see if annual costs exceed salary"]
["Experienced Executive",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4",null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4"]
["Overseas Experienced Executive",{"$f":"IF(OR(J10=\"Experienced Executive\",J10=\"Overseas Experienced Executive\"),250000)","v":false},"Insert Contractor Name",null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(R10:U10)","v":0},{"$f":"SUM(X10:AA10)","v":0},{"$f":"SUM(AD10:AG10)","v":0},{"$f":"SUM(AJ10:AM10)","v":0},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":"G10-H10","v":0},{"$f":"(IF($G10<AP$2,IF($H10<AP$4,(((AP$4-AP$2)-(AP$4-$H10-1))/(AQ$2-AP$2))*($F10*$I10),($F10*$I10)),IF($H10<AP$4,(((AP$4-AP$2)-(($G10-AP$2)+(AP$4-$H10-1)))/(AP$4-AP$2))*($F10*$I10),(((AP$4-AP$2)-($G10-AP$2))/(AP$4-AP$2))*($F10*$I10))))*((AP$4-AP$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AP10>0,AP10,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M10>($F10*$I10),1,0)","v":0},0,0,0,null,null,{"$f":"IF(R10>(($I10*$F10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(X10>(($I10*$F10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AD10>(($I10*$F10)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AJ10>(($I10*$F10)*0.3),1,0)","v":0},0,0,0]
[null,{"$f":"IF(OR(J11=\"Experienced Executive\",J11=\"Overseas Experienced Executive\"),250000)","v":false},"Insert Contractor Name",null,null,null,null,null,null,null,"Ineligible",null,{"$f":"SUM(R11:U11)","v":0},{"$f":"SUM(X11:AA11)","v":0},{"$f":"SUM(AD11:AG11)","v":0},{"$f":"SUM(AJ11:AM11)","v":0},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":"G11-H11","v":0},{"$f":"(IF($G11<AP$2,IF($H11<AP$4,(((AP$4-AP$2)-(AP$4-$H11-1))/(AQ$2-AP$2))*($F11*$I11),($F11*$I11)),IF($H11<AP$4,(((AP$4-AP$2)-(($G11-AP$2)+(AP$4-$H11-1)))/(AP$4-AP$2))*($F11*$I11),(((AP$4-AP$2)-($G11-AP$2))/(AP$4-AP$2))*($F11*$I11))))*((AP$4-AP$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AP11>0,AP11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M11>($F11*$I11),1,0)","v":0},0,0,0,null,null,{"$f":"IF(R11>(($I11*$F11)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(X11>(($I11*$F11)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AD11>(($I11*$F11)*0.3),1,0)","v":0},0,0,0,null,{"$f":"IF(AJ11>(($I11*$F11)*0.3),1,0)","v":0},0,0,0]
["Overseas Experienced Executive",false,"Insert Contractor Name",null,null,null,null,null,null,null,"Ineligible",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"(IF($G12<AP$2,IF($H12<AP$4,(((AP$4-AP$2)-(AP$4-$H12-1))/(AQ$2-AP$2))*($F12*$I12),($F12*$I12)),IF($H12<AP$4,(((AP$4-AP$2)-(($G12-AP$2)+(AP$4-$H12-1)))/(AP$4-AP$2))*($F12*$I12),(((AP$4-AP$2)-($G12-AP$2))/(AP$4-AP$2))*($F12*$I12))))*((AP$4-AP$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
["Overseas Experienced Executive",false,"Insert Contractor Name",null,null,null,null,null,null,null,"Ineligible",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"(IF($G13<AP$2,IF($H13<AP$4,(((AP$4-AP$2)-(AP$4-$H13-1))/(AQ$2-AP$2))*($F13*$I13),($F13*$I13)),IF($H13<AP$4,(((AP$4-AP$2)-(($G13-AP$2)+(AP$4-$H13-1)))/(AP$4-AP$2))*($F13*$I13),(((AP$4-AP$2)-($G13-AP$2))/(AP$4-AP$2))*($F13*$I13))))*((AP$4-AP$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,false,null,null,null,null,null,null,null,null,"Ineligible",null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F14>150000,\"WARNING - SALARIES MUST BE < $150K\",\"\")","v":""},0,{"$f":"(IF($G14<AP$2,IF($H14<AP$4,(((AP$4-AP$2)-(AP$4-$H14-1))/(AQ$2-AP$2))*($F14*$I14),($F14*$I14)),IF($H14<AP$4,(((AP$4-AP$2)-(($G14-AP$2)+(AP$4-$H14-1)))/(AP$4-AP$2))*($F14*$I14),(((AP$4-AP$2)-($G14-AP$2))/(AP$4-AP$2))*($F14*$I14))))*((AP$4-AP$2)/365)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(AP14>0,AP14,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,"Total A: Total Contract Expenditure more than 35 hours per week",null,null,null,null,null,null,null,null,{"$f":"(SUM(M10:M14))","v":0},{"$f":"(SUM(N10:N14))","v":0},{"$f":"(SUM(O10:O14))","v":0},{"$f":"(SUM(P10:P14))","v":0},null,{"$f":"(SUM(R10:R14))","v":0},{"$f":"(SUM(S10:S14))","v":0},{"$f":"(SUM(T10:T14))","v":0},{"$f":"(SUM(U10:U14))","v":0},null,null,{"$f":"(SUM(X10:X14))","v":0},{"$f":"(SUM(Y10:Y14))","v":0},{"$f":"(SUM(Z10:Z14))","v":0},{"$f":"(SUM(AA10:AA14))","v":0},null,null,{"$f":"(SUM(AD10:AD14))","v":0},{"$f":"(SUM(AE10:AE14))","v":0},{"$f":"(SUM(AF10:AF14))","v":0},{"$f":"(SUM(AG10:AG14))","v":0},null,null,{"$f":"(SUM(AJ10:AJ14))","v":0},{"$f":"(SUM(AK10:AK14))","v":0},{"$f":"(SUM(AL10:AL14))","v":0},{"$f":"(SUM(AM10:AM14))","v":0}]
[null,null,{"$f":"IF(SUM(BX10:CA14)>0,\"WARNING YOUR ANNUAL COSTS FOR THIS CONTRACTOR HAVE EXCEEDED THEIR SALARY IN THE HIGHLIGHTED YEAR, PLEASE AMEND\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(CD10:CV15)>0,\"WARNING YOUR QUARTERLY COSTS FOR THIS CONTRACTOR HAVE EXCEEDED MORE THAN 30% OF THEIR ANNUAL SALARY IN THE HIGHLIGHTED QUARTER, PLEASE AMEND\",\"\")","v":""}]
[null,"B. On costs and overheads **"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by project year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,null,null,"% of Salaries",null,null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,"Total B: Contractor Overheads >35hrs per week (set at 20%)",null,null,null,null,0.2,null,null,null,{"$f":"(M$15*$I22)","v":0},{"$f":"(N$15*$I22)","v":0},0,0,null,{"$f":"(R$15*$I22)","v":0},0,0,0,null,null,{"$f":"(X$15*$I22)","v":0},0,0,0,null,null,{"$f":"(AD$15*$I22)","v":0},0,0,0,null,null,{"$f":"(AJ$15*$I22)","v":0},0,0,0]
[]
[null,"C. Contract expenditure (contractors not working 35hrs/week or more on premises)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,"Contractor Name","Purpose of work",null,null,null,null,"Planned total payments","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,{"$f":"IF(OR(J29=\"Experienced Executive\",J29=\"Overseas Experienced Executive\"),250000)","v":false},"Insert Contractor Name ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M29:P29)>$I29,1,0)","v":0},{"$f":"SUM(R29:U29)","v":0},{"$f":"SUM(X29:AA29)","v":0},{"$f":"SUM(AD29:AG29)","v":0},{"$f":"SUM(AJ29:AM29)","v":0}]
[null,{"$f":"IF(OR(J30=\"Experienced Executive\",J30=\"Overseas Experienced Executive\"),250000)","v":false},"Insert Contractor Name ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M30:P30)>$I30,1,0)","v":0},{"$f":"SUM(R30:U30)","v":0},{"$f":"SUM(X30:AA30)","v":0},{"$f":"SUM(AD30:AG30)","v":0},{"$f":"SUM(AJ30:AM30)","v":0}]
[null,false,"Insert Contractor Name ",null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,false,"Insert Contractor Name ",null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,false,null,null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,null,null,"Total C: Total Contract expenditure less than 35 hours per week",null,null,null,null,null,null,null,null,{"$f":"(SUM(M29:M33))","v":0},{"$f":"(SUM(N29:N33))","v":0},{"$f":"(SUM(O29:O33))","v":0},{"$f":"(SUM(P29:P33))","v":0},null,{"$f":"(SUM(R29:R33))","v":0},{"$f":"(SUM(S29:S33))","v":0},{"$f":"(SUM(T29:T33))","v":0},{"$f":"(SUM(U29:U33))","v":0},null,null,{"$f":"(SUM(X29:X33))","v":0},{"$f":"(SUM(Y29:Y33))","v":0},{"$f":"(SUM(Z29:Z33))","v":0},{"$f":"(SUM(AA29:AA33))","v":0},null,null,{"$f":"(SUM(AD29:AD33))","v":0},{"$f":"(SUM(AE29:AE33))","v":0},{"$f":"(SUM(AF29:AF33))","v":0},{"$f":"(SUM(AG29:AG33))","v":0},null,null,{"$f":"(SUM(AJ29:AJ33))","v":0},{"$f":"(SUM(AK29:AK33))","v":0},{"$f":"(SUM(AL29:AL33))","v":0},{"$f":"(SUM(AM29:AM33))","v":0}]
[null,null,{"$f":"IF(SUM(L29:L33)>0,\"WARNING THE ANNUAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE > THE TOTAL COSTS, PLEASE AMEND\",\"\")","v":""}]
[]
[null,"D. Total Contractor Expenditure",null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Total Contract Expenditure","Total A+B+C",null,null,null,null,null,null,null,null,{"$f":"SUM(R41:U41)","v":0},{"$f":"SUM(X41:AA41)","v":0},{"$f":"SUM(AD41:AG41)","v":0},{"$f":"SUM(AJ41:AM41)","v":0},null,{"$f":"ROUNDDOWN(R15+R22+R34,0)","v":0},{"$f":"ROUNDDOWN(S15+S22+S34,0)","v":0},{"$f":"ROUNDDOWN(T15+T22+T34,0)","v":0},{"$f":"ROUNDDOWN(U15+U22+U34,0)","v":0},null,null,{"$f":"ROUNDDOWN(X15+X22+X34,0)","v":0},{"$f":"ROUNDDOWN(Y15+Y22+Y34,0)","v":0},{"$f":"ROUNDDOWN(Z15+Z22+Z34,0)","v":0},{"$f":"ROUNDDOWN(AA15+AA22+AA34,0)","v":0},null,null,{"$f":"ROUNDDOWN(AD15+AD22+AD34,0)","v":0},{"$f":"ROUNDDOWN(AE15+AE22+AE34,0)","v":0},{"$f":"ROUNDDOWN(AF15+AF22+AF34,0)","v":0},{"$f":"ROUNDDOWN(AG15+AG22+AG34,0)","v":0},null,null,{"$f":"ROUNDDOWN(AJ15+AJ22+AJ34,0)","v":0},{"$f":"ROUNDDOWN(AK15+AK22+AK34,0)","v":0},{"$f":"ROUNDDOWN(AL15+AL22+AL34,0)","v":0},{"$f":"ROUNDDOWN(AM15+AM22+AM34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BH10:BH18)+BH22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"*","Eligible fees in period = Incurred fees in period x Actual time spent on agreed project in period    (See section 3.2.2 of the expenditure guide)."]
[null,null,null,"Actual time contracted by grantee in period"]
[null,"** ","To calculate both salary on costs and administrative overhead a set rate of 20% can be applied to total remuneration (See section 3.2.2 of expenditure guide)."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,null,null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($J$7:$J$47,\"General\",M$7:M$47)+SUMIF($J$7:$J$15,\"General\",M$7:M$15)*0.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"General\",N$7:N$47)+SUMIF($J$7:$J$15,\"General\",N$7:N$15)*0.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"General\",O$7:O$47)+SUMIF($J$7:$J$15,\"General\",O$7:O$15)*0.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"General\",P$7:P$47)+SUMIF($J$7:$J$15,\"General\",P$7:P$15)*0.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"General\",Q$7:Q$47)+SUMIF($J$7:$J$15,\"General\",Q$7:Q$15)*0.2","v":0}]
[null,null,null,null,null,null,null,null,null,"Tech Acq"]
[null,null,null,null,null,null,null,null,null,"OS",null,null,{"$f":"SUMIF($J$7:$J$47,\"Overseas\",M$7:M$47)+SUMIF($J$7:$J$15,\"Overseas\",M$7:M$15)*0.2+SUMIF($J$7:$J$47,\"Overseas Experienced Executive\",M$7:M$47)*1.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"Overseas\",N$7:N$47)+SUMIF($J$7:$J$15,\"Overseas\",N$7:N$15)*0.2+SUMIF($J$7:$J$47,\"Overseas Experienced Executive\",N$7:N$47)*1.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"Overseas\",O$7:O$47)+SUMIF($J$7:$J$15,\"Overseas\",O$7:O$15)*0.2+SUMIF($J$7:$J$47,\"Overseas Experienced Executive\",O$7:O$47)*1.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"Overseas\",P$7:P$47)+SUMIF($J$7:$J$15,\"Overseas\",P$7:P$15)*0.2+SUMIF($J$7:$J$47,\"Overseas Experienced Executive\",P$7:P$47)*1.2","v":0},{"$f":"SUMIF($J$7:$J$47,\"Overseas\",Q$7:Q$47)+SUMIF($J$7:$J$15,\"Overseas\",Q$7:Q$15)*0.2+SUMIF($J$7:$J$47,\"Overseas Experienced Executive\",Q$7:Q$47)*1.2","v":0}]

{"sheet":"Plant Expenditure","index":7,"n_rows":50,"n_cols":75,"rows_kept":50,"cut":false,"hidden":false,"merged":[[38,2,39,4],[38,5,39,9],[5,12,5,15],[17,12,17,15],[18,6,20,6],[18,8,20,8],[18,9,20,9],[6,7,8,7],[6,6,8,6],[18,4,20,4],[18,7,20,7],[6,2,8,2],[6,3,8,3],[6,4,8,4],[18,2,20,2],[18,3,20,3],[43,12,43,15],[6,9,8,9],[6,8,8,8],[28,12,28,15],[18,5,20,5],[6,5,8,5]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,null,null,"Project Period:",{"$f":"Summary!$C$4","v":"00:00:00"},"to",{"$f":"Summary!$C$5","v":"00:00:00"},{"$f":"Summary!$C$5","v":"00:00:00"},null,null,"Purchased","Hired","Leased"]
[null,"3. Plant Expenditure",null,null,null,null,null,null,null,{"$f":"Summary!$C$5","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[]
[null,"A. Purchased, pre-existing, hired or leased plant"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
["General",null,"Description of plant being used, purchased, hired or leased","Purchased, hired or leased?","Date acquired","Purchase Cost","Total Depreciation/Total Lease or Hiring Costs","Total Running Costs","% of use on project","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Insert Description ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G10+H10)*I10)<SUM(M10:P10),1,0)","v":0},{"$f":"SUM(R10:U10)","v":0},{"$f":"SUM(X10:AA10)","v":0},{"$f":"SUM(AD10:AG10)","v":0},{"$f":"SUM(AJ10:AM10)","v":0}]
[null,null,"Insert Description ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G11+H11)*I11)<SUM(M11:P11),1,0)","v":0},{"$f":"SUM(R11:U11)","v":0},{"$f":"SUM(X11:AA11)","v":0},{"$f":"SUM(AD11:AG11)","v":0},{"$f":"SUM(AJ11:AM11)","v":0}]
[null,null,"Insert Description ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G12+H12)*I12)<SUM(M12:P12),1,0)","v":0},0,0,0,0]
[null,null,"Insert Description ",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G13+H13)*I13)<SUM(M13:P13),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G14+H14)*I14)<SUM(M14:P14),1,0)","v":0},0,0,0,0]
[null,null,null,"Total A: Pre-existing or purchased plant",null,null,null,null,null,null,null,null,{"$f":"SUM(M10:M14)","v":0},{"$f":"SUM(N10:N14)","v":0},{"$f":"SUM(O10:O14)","v":0},{"$f":"SUM(P10:P14)","v":0},null,{"$f":"SUM(R10:R14)","v":0},{"$f":"SUM(S10:S14)","v":0},{"$f":"SUM(T10:T14)","v":0},{"$f":"SUM(U10:U14)","v":0},null,null,{"$f":"SUM(X10:X14)","v":0},{"$f":"SUM(Y10:Y14)","v":0},{"$f":"SUM(Z10:Z14)","v":0},{"$f":"SUM(AA10:AA14)","v":0},null,null,{"$f":"SUM(AD10:AD14)","v":0},{"$f":"SUM(AE10:AE14)","v":0},{"$f":"SUM(AF10:AF14)","v":0},{"$f":"SUM(AG10:AG14)","v":0},null,null,{"$f":"SUM(AJ10:AJ14)","v":0},{"$f":"SUM(AK10:AK14)","v":0},{"$f":"SUM(AL10:AL14)","v":0},{"$f":"SUM(AM10:AM14)","v":0}]
[null,null,{"$f":"IF(SUM(L10:L14)>0,\"WARNING THE TOTAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE > THE TOTAL DEPRECIATION PLUS RUNNING COSTS MULTIPLIED BY % USE ON PROJECT, PLEASE AMEND\",\"\")","v":""}]
[null,"B. Constructed plant"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,"Description of plant constructed","Date Deployed on Project","Capitalised Cost of Constructed Plant","Residual value (at project end date)*","Total Depreciation Costs","Total Running Costs","% of use on project","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G22+H22)*I22)<SUM(M22:P22),1,0)","v":0},{"$f":"SUM(R22:U22)","v":0},{"$f":"SUM(X22:AA22)","v":0},{"$f":"SUM(AD22:AG22)","v":0},{"$f":"SUM(AJ22:AM22)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(((G23+H23)*I23)<SUM(M23:P23),1,0)","v":0},{"$f":"SUM(R23:U23)","v":0},{"$f":"SUM(X23:AA23)","v":0},{"$f":"SUM(AD23:AG23)","v":0},{"$f":"SUM(AJ23:AM23)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,null,null,"Total B: Constructed plant",null,null,null,null,null,null,null,null,{"$f":"SUM(M22:M26)","v":0},{"$f":"SUM(N22:N26)","v":0},{"$f":"SUM(O22:O26)","v":0},{"$f":"SUM(P22:P26)","v":0},null,{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(S22:S26)","v":0},{"$f":"SUM(T22:T26)","v":0},{"$f":"SUM(U22:U26)","v":0},null,null,{"$f":"SUM(X22:X26)","v":0},{"$f":"SUM(Y22:Y26)","v":0},{"$f":"SUM(Z22:Z26)","v":0},{"$f":"SUM(AA22:AA26)","v":0},{"$f":"SUM(AB22:AB22)","v":0},null,{"$f":"SUM(AD22:AD26)","v":0},{"$f":"SUM(AE22:AE26)","v":0},{"$f":"SUM(AF22:AF26)","v":0},{"$f":"SUM(AG22:AG26)","v":0},null,null,{"$f":"SUM(AJ22:AJ26)","v":0},{"$f":"SUM(AK22:AK26)","v":0},{"$f":"SUM(AL22:AL26)","v":0},{"$f":"SUM(AM22:AM26)","v":0}]
[null,null,{"$f":"IF(SUM(L22:L26)>0,\"WARNING THE TOTAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE > THE TOTAL DEPRECIATION PLUS RUNNING COSTS MULTIPLIED BY % USE ON PROJECT, PLEASE AMEND\",\"\")","v":""}]
[null,"C. Total Plant Expenditure",null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,null,null,null,null,null,null,null,"Y1 Q1","Y1 Q2","Y1 Q3","Y1 Q4","Y2 Q1","Y2 Q2","Y2 Q3","Y2 Q4","Y3 Q1","Y3 Q2","Y3 Q3","Y3 Q4","Y4 Q1","Y4 Q2","Y4 Q3","Y4 Q4","Y5 Q1","Y5 Q2","Y5 Q3","Y5 Q4","Y6 Q1","Y6 Q2","Y6 Q3","Y6 Q4","Y7 Q1","Y7 Q2","Y7 Q3","Y7 Q4"]
[null,null,null,"Total A+B",null,null,null,null,null,null,null,null,{"$f":"SUM(R33:U33)","v":0},{"$f":"SUM(X33:AA33)","v":0},{"$f":"SUM(AD33:AG33)","v":0},{"$f":"SUM(AJ33:AM33)","v":0},null,{"$f":"ROUNDDOWN(R15+R27,0)","v":0},{"$f":"ROUNDDOWN(S15+S27,0)","v":0},{"$f":"ROUNDDOWN(T15+T27,0)","v":0},{"$f":"ROUNDDOWN(U15+U27,0)","v":0},null,null,{"$f":"ROUNDDOWN(X15+X27,0)","v":0},{"$f":"ROUNDDOWN(Y15+Y27,0)","v":0},{"$f":"ROUNDDOWN(Z15+Z27,0)","v":0},{"$f":"ROUNDDOWN(AA15+AA27,0)","v":0},null,null,{"$f":"ROUNDDOWN(AD15+AD27,0)","v":0},{"$f":"ROUNDDOWN(AE15+AE27,0)","v":0},{"$f":"ROUNDDOWN(AF15+AF27,0)","v":0},{"$f":"ROUNDDOWN(AG15+AG27,0)","v":0},null,null,{"$f":"ROUNDDOWN(AJ15+AJ27,0)","v":0},{"$f":"ROUNDDOWN(AK15+AK27,0)","v":0},{"$f":"ROUNDDOWN(AL15+AL27,0)","v":0},{"$f":"ROUNDDOWN(AM15+AM27,0)","v":0}]
[null,"Purchased"]
[null,"Leased"]
[null,"Hired"]
[]
[]
[null,null,"Please state basis for calculation of residual value:"]
[null,"*"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,null,null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($J$7:$K$42,\"General\",M$7:M$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"General\",N$7:N$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"General\",O$7:O$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"General\",P$7:P$42)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tech Acq"]
[null,null,null,null,null,null,null,null,null,"O/S",null,null,{"$f":"SUMIF($J$7:$K$42,\"Overseas\",M$7:M$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"Overseas\",N$7:N$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"Overseas\",O$7:O$42)","v":0},{"$f":"SUMIF($J$7:$K$42,\"Overseas\",P$7:P$42)","v":0}]

{"sheet":"SMP-PMP Expenditure","index":8,"n_rows":27,"n_cols":39,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,35,0,38],[20,23,20,26],[20,29,20,32],[20,35,20,38],[6,8,8,8],[6,9,8,9],[20,12,20,15],[20,17,20,20],[5,12,5,15],[0,12,0,15],[0,17,0,20],[0,23,0,26],[0,29,0,32],[6,7,8,7],[6,2,8,2],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,6,8,6]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,null,"Project Period:",{"$f":"Summary!$C$4","v":"00:00:00"},null,"to",{"$f":"Summary!$C$5","v":"00:00:00"}]
[null,"4. State-of-the-art Manufacturing Plant/Pilot Manufacturing Plant Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[]
["General"]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
["General",null,"Description of Components","Date Deployed on Project","Capitalised Cost of Constructed Plant","Residual value (at project end date)",null,"Total Running Costs","% of use on project","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M10:P10)>SUM(E10,H10)*I10,1,0)","v":0},{"$f":"SUM(R10:U10)","v":0},{"$f":"SUM(X10:AA10)","v":0},{"$f":"SUM(AD10:AG10)","v":0},{"$f":"SUM(AJ10:AM10)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M11:P11)>SUM(E11,H11)*I11,1,0)","v":0},{"$f":"SUM(R11:U11)","v":0},{"$f":"SUM(X11:AA11)","v":0},{"$f":"SUM(AD11:AG11)","v":0},{"$f":"SUM(AJ11:AM11)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M12:P12)>SUM(E12,H12)*I12,1,0)","v":0},0,0,0,0]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M13:P13)>SUM(E13,H13)*I13,1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"E14+F14+G14","v":0},null,null,"Ineligible",{"$f":"IF(SUM(M14:P14)>SUM(E14:G14)*I14,1,0)","v":0},0,0,0,0]
[null,null,null,"Total: State-of-the-art Manufacturing Plant/Pilot Manufacturing Plant Expenditure",null,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"ROUNDDOWN(SUM(R10:R14),0)","v":0},{"$f":"ROUNDDOWN(SUM(S10:S14),0)","v":0},{"$f":"ROUNDDOWN(SUM(T10:T14),0)","v":0},{"$f":"ROUNDDOWN(SUM(U10:U14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(X10:X14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Y10:Y14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Z10:Z14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AA10:AA14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(AD10:AD14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AE10:AE14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AF10:AF14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AG10:AG14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(AJ10:AJ14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AK10:AK14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AL10:AL14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AM10:AM14),0)","v":0}]
[]
[null,null,{"$f":"IF(SUM(L10:L14)>0,\"WARNING THE TOTAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE > THE TOTAL CONSTRUCTION PLUS RUNNING COSTS MULTIPLIED BY % USE ON PROJECT, PLEASE AMEND\",\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,null,null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($J$7:$J$15,\"General\",M$7:M$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",N$7:N$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",O$7:O$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",P$7:P$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",Q$7:Q$15)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tech Acq"]
[null,null,null,null,null,null,null,null,null,"O/S",null,null,{"$f":"SUMIF($J$7:$J$15,\"Overseas\",M$7:M$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",N$7:N$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",O$7:O$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",P$7:P$15)","v":0}]

{"sheet":"Prototype Expenditure","index":9,"n_rows":26,"n_cols":39,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,29,19,32],[19,35,19,38],[19,12,19,15],[19,17,19,20],[19,23,19,26],[5,12,5,15],[6,7,8,7],[6,8,8,8],[6,2,8,2],[6,3,8,3],[6,4,8,4],[6,5,8,5],[6,9,8,9],[6,6,8,6]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,null,null,"Project Period:",{"$f":"Summary!$C$4","v":"00:00:00"},null,"to",{"$f":"Summary!$C$5","v":"00:00:00"}]
[null,"5. Prototype Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
["General",null,"Description of Prototype","No. of prototypes","Material Costs","Labour Costs","Other Construction Costs","Total Construction costs","Material Costs consumed during testing","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
["Overseas",null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M10:P10)>SUM(E10,F10,G10,I10),1,0)","v":0},{"$f":"SUM(R10:U10)","v":0},{"$f":"SUM(X10:AA10)","v":0},{"$f":"SUM(AD10:AG10)","v":0},{"$f":"SUM(AJ10:AM10)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M11:P11)>SUM(E11,F11,G11,I11),1,0)","v":0},{"$f":"SUM(R11:U11)","v":0},{"$f":"SUM(X11:AA11)","v":0},{"$f":"SUM(AD11:AG11)","v":0},{"$f":"SUM(AJ11:AM11)","v":0}]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M12:P12)>SUM(E12,F12,G12,I12),1,0)","v":0},0,0,0,0]
[null,null,"Insert Description",null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M13:P13)>SUM(E13,F13,G13,I13),1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Ineligible",{"$f":"IF(SUM(M14:P14)>SUM(E14,F14,G14,I14),1,0)","v":0},0,0,0,0]
[null,null,null,"Total: Prototype expenditure",null,null,null,null,null,null,null,null,0,0,0,0,null,{"$f":"ROUNDDOWN(SUM(R10:R14),0)","v":0},{"$f":"ROUNDDOWN(SUM(S10:S14),0)","v":0},{"$f":"ROUNDDOWN(SUM(T10:T14),0)","v":0},{"$f":"ROUNDDOWN(SUM(U10:U14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(X10:X14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Y10:Y14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Z10:Z14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AA10:AA14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(AD10:AD14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AE10:AE14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AF10:AF14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AG10:AG14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(AJ10:AJ14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AK10:AK14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AL10:AL14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AM10:AM14),0)","v":0}]
[]
[null,null,{"$f":"IF(SUM(L10:L14)>0,\"WARNING THE TOTAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE > THE TOTAL CONSTRUCTION COSTS PLUS MATERIALS CONSUMED COSTS, PLEASE AMEND\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,null,null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($J$7:$J$15,\"General\",M$7:M$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",N$7:N$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",O$7:O$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"General\",P$7:P$15)","v":0}]
[null,null,null,null,null,null,null,null,null,"Tech Acq"]
[null,null,null,null,null,null,null,null,null,"O/S",null,null,{"$f":"SUMIF($J$7:$J$15,\"Overseas\",M$7:M$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",N$7:N$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",O$7:O$15)","v":0},{"$f":"SUMIF($J$7:$J$15,\"Overseas\",P$7:P$15)","v":0}]

{"sheet":"Other Expenditure","index":10,"n_rows":25,"n_cols":37,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,8,18,11],[6,2,8,2],[6,3,8,3],[5,8,5,11],[6,5,8,5],[6,4,8,4]]}
[null,{"$f":"IF(Summary!C3=\"\",\"\",Summary!C3)","v":""},null,null,"Project Period:",{"$f":"Summary!$C$4","v":"00:00:00"},null,"to",{"$f":"Summary!$C$5","v":"00:00:00"}]
[null,"6. Other Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Actuals","Actuals","Actuals","Actuals",null,0,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals",null,null,"Actuals","Actuals","Actuals","Actuals"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Travel"]
[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,null,null,null,null,null,null,null,null,null,null,null,"Training"]
[null,null,null,null,null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,"New and Leading Edge Technologies"]
["General",null,"Description of other expenditure","Total Costs","Expenditure Classification","Expenditure Type",null,null,{"$f":"IF(Summary!$C$4=\"\",\"Enter Project Start Date\",Summary!$C$4)","v":"Enter Project Start Date"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"},null,"Product liability Insurance"]
["Overseas",null,null,null,null,null,null,null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"},null,"Intellectual Property"]
[null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"},null,"Other"]
[null,null,"Insert Description",null,null,null,"Ineligible",{"$f":"IF(SUM(I10:L10)>$D10,1,0)","v":0},{"$f":"SUM(N10:Q10)","v":0},{"$f":"SUM(T10:W10)","v":0},{"$f":"SUM(Z10:AC10)","v":0},{"$f":"SUM(AF10:AI10)","v":0}]
[null,null,"Audit Reports",null,"Audit","General","Ineligible",0,0,0,0,0]
[null,null,"Insert Description",null,null,null,"Ineligible",{"$f":"IF(SUM(I12:L12)>$D12,1,0)","v":0},{"$f":"SUM(N12:Q12)","v":0},{"$f":"SUM(T12:W12)","v":0},{"$f":"SUM(Z12:AC12)","v":0},{"$f":"SUM(AF12:AI12)","v":0}]
[null,null,"Insert Description",null,null,null,"Ineligible",0,0,0,0,0]
[null,null,null,null,null,null,"Ineligible",0,0,0,0,0]
[null,null,null,"Total: Other expenditure",null,null,null,null,{"$f":"SUM(N15:Q15)","v":0},{"$f":"SUM(T15:W15)","v":0},{"$f":"SUM(Z15:AC15)","v":0},{"$f":"SUM(AF15:AI15)","v":0},null,{"$f":"ROUNDDOWN(SUM(N10:N14),0)","v":0},{"$f":"ROUNDDOWN(SUM(O10:O14),0)","v":0},{"$f":"ROUNDDOWN(SUM(P10:P14),0)","v":0},{"$f":"ROUNDDOWN(SUM(Q10:Q14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(T10:T14),0)","v":0},{"$f":"ROUNDDOWN(SUM(U10:U14),0)","v":0},{"$f":"ROUNDDOWN(SUM(V10:V14),0)","v":0},{"$f":"ROUNDDOWN(SUM(W10:W14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(Z10:Z14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AA10:AA14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AB10:AB14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AC10:AC14),0)","v":0},null,null,{"$f":"ROUNDDOWN(SUM(AF10:AF14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AG10:AG14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AH10:AH14),0)","v":0},{"$f":"ROUNDDOWN(SUM(AI10:AI14),0)","v":0}]
[null,null,{"$f":"IF(D11>$D$21,\"WARNING: Audit fees must not exceed 1% of total project costs\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(SUM($I$11:$L$11)>$D$21,\"WARNING: Audit fees must not exceed 1% of total project costs\",\"\")","v":""}]
[null,null,{"$f":"IF(SUM(H10:H14)>0,\"WARNING THE TOTAL COSTS FOR THE ITEM HIGHLIGHTED ABOVE ARE GREATER THAN THE TOTAL COSTS, PLEASE AMEND\",\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Expenditure by financial year"]
[null,null,null,null,null,null,null,null,{"$f":"Summary!$C$4","v":"00:00:00"},{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$X$21","v":"Enter Project Start Date"}]
[null,null,"total project cost * 1% ",{"$f":"Summary!C8*1%","v":0},null,null,null,null,"to","to","to","to"]
[null,null,null,null,null,null,null,null,{"$f":"Summary!$I$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,null,null,null,"Gen","Overseas Expenditure",null,{"$f":"SUMIF($F$7:$F$15,\"General\",I$7:I$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"General\",J$7:J$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"General\",K$7:K$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"General\",L$7:L$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"General\",M$7:M$15)","v":0}]
[null,null,null,null,null,"Tech Acq"]
[null,null,null,null,null,"O/S",null,null,{"$f":"SUMIF($F$7:$F$15,\"Overseas\",I$7:I$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"Overseas\",J$7:J$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"Overseas\",K$7:K$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"Overseas\",L$7:L$15)","v":0},{"$f":"SUMIF($F$7:$F$15,\"Overseas\",M$7:M$15)","v":0}]

{"sheet":"Cash Flow","index":11,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":true,"merged":[[4,4,4,7],[30,6,30,7],[32,4,33,12],[2,2,3,5]]}
[]
[null,"8. Company Cash Flow"]
[null,null,"Please enter cash flow estimates for total company activity, not just proposed project"]
[]
[null,null,null,null,"Expenditure by financial year",null,null,null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4",null,null,"Q1","Q2","Q3","Q4"]
[null,null,null,null,{"$f":"Summary!$J$21","v":"Enter Project Start Date"},{"$f":"Summary!$P$21","v":"Enter Project Start Date"},{"$f":"Summary!$V$21","v":"Enter Project Start Date"},{"$f":"Summary!$AB$21","v":"Enter Project Start Date"},null,{"$f":"Summary!$F$21","v":"Enter Project Start Date"},{"$f":"Summary!$G$21","v":"Enter Project Start Date"},{"$f":"Summary!$H$21","v":"Enter Project Start Date"},{"$f":"Summary!$I$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$L$21","v":"Enter Project Start Date"},{"$f":"Summary!$M$21","v":"Enter Project Start Date"},{"$f":"Summary!$N$21","v":"Enter Project Start Date"},{"$f":"Summary!$O$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$R$21","v":"Enter Project Start Date"},{"$f":"Summary!$S$21","v":"Enter Project Start Date"},{"$f":"Summary!$T$21","v":"Enter Project Start Date"},{"$f":"Summary!$U$21","v":"Enter Project Start Date"},null,null,{"$f":"Summary!$X$21","v":"Enter Project Start Date"},{"$f":"Summary!$Y$21","v":"Enter Project Start Date"},{"$f":"Summary!$Z$21","v":"Enter Project Start Date"},{"$f":"Summary!$AA$21","v":"Enter Project Start Date"}]
[null,null,"Description",null,"to","to","to","to",null,{"$f":"Summary!$F$22","v":"to"},{"$f":"Summary!$G$22","v":"to"},{"$f":"Summary!$H$22","v":"to"},{"$f":"Summary!$I$22","v":"to"},null,null,{"$f":"Summary!$L$22","v":"to"},{"$f":"Summary!$M$22","v":"to"},{"$f":"Summary!$N$22","v":"to"},{"$f":"Summary!$O$22","v":"to"},null,null,{"$f":"Summary!$R$22","v":"to"},{"$f":"Summary!$S$22","v":"to"},{"$f":"Summary!$T$22","v":"to"},{"$f":"Summary!$U$22","v":"to"},null,null,{"$f":"Summary!$X$22","v":"to"},{"$f":"Summary!$Y$22","v":"to"},{"$f":"Summary!$Z$22","v":"to"},{"$f":"Summary!$AA$22","v":"to"}]
[null,null,null,null,{"$f":"Summary!$J$23","v":"Enter Project End Date"},{"$f":"Summary!$P$23","v":"Enter Project End Date"},{"$f":"Summary!$V$23","v":"Enter Project End Date"},{"$f":"Summary!$AB$23","v":"Enter Project End Date"},null,{"$f":"Summary!$F$23","v":"Enter Project End Date"},{"$f":"Summary!$G$23","v":"Enter Project End Date"},{"$f":"Summary!$H$23","v":"Enter Project End Date"},{"$f":"Summary!$I$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$L$23","v":"Enter Project End Date"},{"$f":"Summary!$M$23","v":"Enter Project End Date"},{"$f":"Summary!$N$23","v":"Enter Project End Date"},{"$f":"Summary!$O$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$R$23","v":"Enter Project End Date"},{"$f":"Summary!$S$23","v":"Enter Project End Date"},{"$f":"Summary!$T$23","v":"Enter Project End Date"},{"$f":"Summary!$U$23","v":"Enter Project End Date"},null,null,{"$f":"Summary!$X$23","v":"Enter Project End Date"},{"$f":"Summary!$Y$23","v":"Enter Project End Date"},{"$f":"Summary!$Z$23","v":"Enter Project End Date"},{"$f":"Summary!$AA$23","v":"Enter Project End Date"}]
[null,null,"Cash receipts"]
[null,null,"Sales from the project",null,{"$f":"SUM(J10:M10)","v":0},{"$f":"SUM(P10:S10)","v":0},{"$f":"SUM(V10:Y10)","v":0},{"$f":"SUM(AB10:AE10)","v":0}]
[null,null,"Other revenue",null,{"$f":"SUM(J11:M11)","v":0},{"$f":"SUM(P11:S11)","v":0},{"$f":"SUM(V11:Y11)","v":0},{"$f":"SUM(AB11:AE11)","v":0}]
[null,null,"Other:"]
[null,null," - Climate Ready grant",null,{"$f":"SUM(J13:M13)","v":0},{"$f":"SUM(P13:S13)","v":0},{"$f":"SUM(V13:Y13)","v":0},{"$f":"SUM(AB13:AE13)","v":0}]
[null,null," - Borrowings",null,0,0,0,0]
[null,null," - Equity raising",null,0,0,0,0]
[null,null," - Other",null,0,0,0,0]
[null,null,"Total receipts (A)",null,0,0,0,0,null,{"$f":"SUM(J13:J16)+SUM(J10:J11)","v":0},{"$f":"SUM(K13:K16)+SUM(K10:K11)","v":0},{"$f":"SUM(L13:L16)+SUM(L10:L11)","v":0},{"$f":"SUM(M13:M16)+SUM(M10:M11)","v":0},null,null,{"$f":"SUM(P13:P16)+SUM(P10:P11)","v":0},{"$f":"SUM(Q13:Q16)+SUM(Q10:Q11)","v":0},{"$f":"SUM(R13:R16)+SUM(R10:R11)","v":0},{"$f":"SUM(S13:S16)+SUM(S10:S11)","v":0},null,null,{"$f":"SUM(V13:V16)+SUM(V10:V11)","v":0},{"$f":"SUM(W13:W16)+SUM(W10:W11)","v":0},{"$f":"SUM(X13:X16)+SUM(X10:X11)","v":0},{"$f":"SUM(Y13:Y16)+SUM(Y10:Y11)","v":0},null,null,{"$f":"SUM(AB13:AB16)+SUM(AB10:AB11)","v":0},{"$f":"SUM(AC13:AC16)+SUM(AC10:AC11)","v":0},{"$f":"SUM(AD13:AD16)+SUM(AD10:AD11)","v":0},{"$f":"SUM(AE13:AE16)+SUM(AE10:AE11)","v":0}]
[]
[null,null,"Cash payments"]
[null,null,"Project costs",null,0,0,0,0]
[null,null,"Production & other costs of commercialising the project outcome",null,0,0,0,0]
[null,null,"Other operating expenses",null,0,0,0,0]
[null,null,"Loan repayments",null,{"$f":"SUM(J23:M23)","v":0},{"$f":"SUM(P23:S23)","v":0},{"$f":"SUM(V23:Y23)","v":0},{"$f":"SUM(AB23:AE23)","v":0}]
[null,null,"Other outlays",null,{"$f":"SUM(J24:M24)","v":0},{"$f":"SUM(P24:S24)","v":0},{"$f":"SUM(V24:Y24)","v":0},{"$f":"SUM(AB24:AE24)","v":0}]
[null,null,"Total payments (B)",null,{"$f":"SUM(J25:M25)","v":0},{"$f":"SUM(P25:S25)","v":0},{"$f":"SUM(V25:Y25)","v":0},{"$f":"SUM(AB25:AE25)","v":0},null,{"$f":"SUM(J20:J24)","v":0},{"$f":"SUM(K20:K24)","v":0},{"$f":"SUM(L20:L24)","v":0},{"$f":"SUM(M20:M24)","v":0},null,null,{"$f":"SUM(P20:P24)","v":0},{"$f":"SUM(Q20:Q24)","v":0},{"$f":"SUM(R20:R24)","v":0},{"$f":"SUM(S20:S24)","v":0},null,null,{"$f":"SUM(V20:V24)","v":0},{"$f":"SUM(W20:W24)","v":0},{"$f":"SUM(X20:X24)","v":0},{"$f":"SUM(Y20:Y24)","v":0},null,null,{"$f":"SUM(AB20:AB24)","v":0},{"$f":"SUM(AC20:AC24)","v":0},{"$f":"SUM(AD20:AD24)","v":0},{"$f":"SUM(AE20:AE24)","v":0}]
[]
[null,null,"Net cash flow (C )",null,{"$f":"SUM(J27:M27)","v":0},{"$f":"SUM(P27:S27)","v":0},{"$f":"SUM(V27:Y27)","v":0},{"$f":"SUM(AB27:AE27)","v":0},null,{"$f":"J17-J25","v":0},{"$f":"K17-K25","v":0},{"$f":"L17-L25","v":0},{"$f":"M17-M25","v":0},null,null,{"$f":"P17-P25","v":0},{"$f":"Q17-Q25","v":0},{"$f":"R17-R25","v":0},{"$f":"S17-S25","v":0},null,null,{"$f":"V17-V25","v":0},{"$f":"W17-W25","v":0},{"$f":"X17-X25","v":0},{"$f":"Y17-Y25","v":0},null,null,{"$f":"AB17-AB25","v":0},{"$f":"AC17-AC25","v":0},{"$f":"AD17-AD25","v":0},{"$f":"AE17-AE25","v":0}]
[null,null,"Opening cash (D)",null,{"$f":"J28","v":0},{"$f":"P28","v":0},{"$f":"V28","v":0},{"$f":"AB28","v":0},null,null,{"$f":"J29","v":0},{"$f":"K29","v":0},{"$f":"L29","v":0},null,null,{"$f":"M29","v":0},{"$f":"P29","v":0},{"$f":"Q29","v":0},{"$f":"R29","v":0},null,null,{"$f":"S29","v":0},{"$f":"V29","v":0},{"$f":"W29","v":0},{"$f":"X29","v":0},null,null,{"$f":"Y29","v":0},{"$f":"AB29","v":0},{"$f":"AC29","v":0},{"$f":"AD29","v":0}]
[null,null,"Closing cash ",null,{"$f":"M29","v":0},{"$f":"S29","v":0},{"$f":"Y29","v":0},{"$f":"AE29","v":0},null,{"$f":"J27+J28","v":0},{"$f":"K27+K28","v":0},{"$f":"L27+L28","v":0},{"$f":"M27+M28","v":0},null,null,{"$f":"P27+P28","v":0},{"$f":"Q27+Q28","v":0},{"$f":"R27+R28","v":0},{"$f":"S27+S28","v":0},null,null,{"$f":"V27+V28","v":0},{"$f":"W27+W28","v":0},{"$f":"X27+X28","v":0},{"$f":"Y27+Y28","v":0},null,null,{"$f":"AB27+AB28","v":0},{"$f":"AC27+AC28","v":0},{"$f":"AD27+AD28","v":0},{"$f":"AE27+AE28","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J28=\"\",\"Warning - opening balance not entered\",\"\")","v":"Warning - opening balance not entered"}]
[null,null,null,null,"Applicant's Overdraft Limit"]
[]
[]
[null,null,"Please state basis for these figures:"]

{"sheet":"Guidelines","index":12,"n_rows":234,"n_cols":4,"rows_kept":234,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Accelerating Commercialisation Eligible Expenditure Guidelines"]
[]
[]
[1,null,null,"Introduction"]
[null,null,null,"These guidelines operate on and from 1 November 2014. The Programme Delegate may revise these guidelines from time to time. The guidelines that apply to your project are those that apply on the date that your application is accepted for merit assessment (the date of the application acceptance letter)."]
[null,null,null,"These guidelines set out the principles governing what is eligible expenditure. Applicants for Accelerating Commercialisation must use these guidelines in completing an application. For guidance on project eligibility please refer to section 5 of the Accelerating Commercialisation Customer Information Guide."]
[null,null,null,"Participants must use these guidelines when conducting their project and completing project progress reports. The Programme Delegate (and his or her authorised officers) will use these guidelines to determine eligibility of budgeted project costs and the grant amount, and to determine a Participant’s entitlement to grant progress payments during the period of a funding agreement. The project budget calculator will assist you in calculating your project costs. These guidelines are also used by the independent auditors to conduct independent audits required as part of the reporting requirements of the programme. The Programme Delegate has the final decision in determining eligible expenditure and may issue additional guidance on eligible expenditure on a case-by-case basis as required."]
[2,null,null,"Eligible expenditure governing principles"]
[null,null,null,"Accelerating Commercialisation focuses on helping Australian entrepreneurs, researchers, inventors, start-ups, Commercialisation Offices and small and medium enterprises address the challenges associated with commercialising novel intellectual property in the form of new products, processes and/or services."]
[null,null,null,"This statement conveys in a broad sense the spirit and intention behind the programme. It should be referred to so as to provide direction and support on decisions regarding the eligibility of expenditure detailed in the guidelines."]
[null,2.1,null,"Eligible expenditure is restricted to expenditure incurred directly on the agreed project or on agreed activities as detailed in the funding agreement"]
[null,null,null,"Eligible expenditure is any expense (inclusive of Goods and Services Tax (GST) but less related input tax credits), that qualifies as eligible expenditure under these guidelines."]
[null,null,null,"Only expenditure incurred in relation to agreed milestones within the agreed project duration (as highlighted in the funding agreement) is eligible expenditure, unless otherwise noted in the eligible expenditure guidelines."]
[null,null,null,"To be eligible, the Participant must incur expenditure on or after the project commencement date, and on or before the project completion date, with the exception of final audit costs which can be incurred within three months of the project completion date."]
[null,null,null,"The Participant must pay expenditure in the period between the project commencement date and three months after the project completion date (including final audit costs)."]
[null,null,null,"Eligible expenditure can include depreciation of assets due to performing project activities but excludes any costs, direct or otherwise, of obtaining such assets for their use on project activities and also excludes any opportunity costs from using assets on the agreed project rather than other uses."]
[null,2.2000000000000002,null,"Grant funding is provided to support the project; it is not provided for the benefit or profit of related bodies corporate of the Participant"]
[null,null,null,"Related body corporate has the same meaning as in section 50 of the Corporations Act 2001 (Cth)."]
[null,null,null,"Where project activities are conducted through contracting related bodies corporate of the Participant, these costs (known as ‘intra-group payments’) may qualify as eligible expenditure only if a reliable, measurable cost is incurred by the related body, and a verifiable process is used to transfer that cost to the Participant with no profit margin attached, 'at cost'."]
[null,null,null,"Only that proportion of costs which directly relates to activities performed on the agreed project can be claimed as eligible expenditure. Where there is a mutual benefit arising from project activities, either to another company or for another project, the Participant must be able to show how they reasonably apportioned such costs so as to claim only for those activities which directly apply to the funded project."]
[null,2.2999999999999998,null,"Non-cash considerations are not eligible expenditure"]
[null,null,null,"For Accelerating Commercialisation purposes, non-cash considerations are contributions to a project that have the following common characteristics:"]
[null,null,null,"·         no impact on entity cash flow, and"]
[null,null,null,"·         no record in the entity’s statement of financial performance."]
[null,null,null,"·         Examples include:"]
[null,null,null,"·         the use of resources—whether internally or externally sourced—for no cost to the project, and"]
[null,null,null,"·         issuing shares in payment for services rendered."]
[null,null,null,"These arrangements are sometimes referred to as ‘in-kind’ contributions. Non-cash considerations do not include using resources, at a cost, to conduct activities for the agreed project. The latter costs of conducting activities to achieve agreed milestones are generally allowed as eligible expenditure."]
[null,2.4,null,"How eligible expenditure is verified"]
[null,null,null,"If your application is successful, you will be asked to verify the project budget that you provided in your application when negotiating your funding agreement. You may need to provide evidence for major cost items such as labour, plant and equipment. Evidence can include:"]
[null,null,null,"·         quotations"]
[null,null,null,"·         purchase orders"]
[null,null,null,"·         supply agreements"]
[null,null,null,"·         sales catalogues"]
[null,null,null,"·         details of all employees working on the project, including name, title, function, time spent on the project and salary."]
[null,null,null,"The funding agreement will also include details of the evidence you may need to provide with each project progress report. This may include evidence related to eligible expenditure, including:"]
[null,null,null,"·         supply agreements"]
[null,null,null,"·         leasing or purchasing arrangements"]
[null,null,null,"·         invoices"]
[null,null,null,"·         associated payments."]
[null,null,null,"If requested, you will need to provide the agreed evidence along with your project progress report."]
[null,null,null,"You must also keep records of all eligible expenditure that has been paid , and must be able to explain how those costs relate to agreed project milestones and activities. At any time, you may be asked to provide records of your paid expenditure. If these records are not provided when requested, the expense may not qualify as eligible expenditure."]
[null,null,null,"At the end of the project, you will be required to provide an independent financial audit of all eligible expenditure for the project."]
[3,null,null,"Heads of expenditure"]
[null,null,null,"This section sets out the heads of expenditure under which applicants and Participants must record project eligible expenditure in applications and project reports. The heads of expenditure are:"]
[null,null,null,"·         Labour expenditure"]
[null,null,null,"·         Contract expenditure"]
[null,null,null,"·         Plant expenditure"]
[null,null,null,"·         State-of-the-art plant or pilot manufacturing plant expenditure"]
[null,null,null,"·         Prototype expenditure"]
[null,null,null,"·         Other expenditure."]
[null,null,null,"These heads of expenditure are explained in more detail below."]
[null,null,null,"Experienced Executives expenditure"]
[null,null,null,"The employment of an experienced chief executive officer or other senior executive is supported under Accelerating Commercialisation for all applicants other than Commercialisation Offices and Eligible Partner Entities. Such an appointment is referred to as an Experienced Executive. The executive is expected to bring complementary skills and experience to the business and to drive it towards commercialisation of its novel product, process or service in the marketplace. Expenditure in relation to an Experienced Executive may be claimed under either Labour expenditure or Contract expenditure depending on the executive’s employment status. For more information on Experienced Executives refer to section 4.1."]
[null,3.1,null,"Labour expenditure"]
[null,null,null,"Eligible labour expenditure covers the cost to the Participant of its employees directly employed on the core elements of the agreed project. An employee is a person who is paid a regular salary or wage out of which regular tax instalment deductions are made."]
[null,null,null,"Eligible labour expenditure includes any components of an employee’s total remuneration package that are itemised on their Pay As You Go (PAYG) Annual Payment Summary submitted to the Australian Taxation Office (ATO). Salary-sacrificed superannuation contributions are considered part of an employee’s salary package where this amount exceeds that required by the Superannuation Guarantee. Employer contributions under the Superannuation Guarantee are included in the labour on-costs allowance."]
[null,null,null,"For grant claim purposes, the maximum salary for an employee, including packaged components, is $175,000 in each full financial year (July-June) of the project period. The maximum salary claim for an Experienced Executive is $250,000 per financial year. The maximum salary claim in a less-than-complete financial year that is part of the project period is reduced proportionately from the $175,000 (or $250,000) maximum."]
[null,null,null,"Any salary claim above these caps will not qualify as eligible expenditure, except where the Participant obtains the Programme Delegate’s prior approval. The Programme Delegate will assess all such requests on a case-by-case basis, and may take into account whether the additional salary is warranted to attract an employee to the agreed project, and whether the additional salary expenditure is likely to aid the project in meeting Accelerating Commercialisation’s policy objective."]
[null,null,"3.1.1","Salary on-costs and administrative overhead"]
[null,null,null,"Eligible salary costs can be increased by an additional 40 per cent allowance to cover on-costs such as employer paid superannuation, payroll tax and workers compensation insurance. This allowance also includes administrative overheads such as incidental travel, a proportion of communications, accommodation, computing facilities, recruitment, printing and stationery, postage, administrative support salaries, legal, accounting and auditing fees, and bank charges."]
[null,null,"3.1.2","Eligible labour expenditure calculation"]
[null,null,null,"Eligible labour expenditure must be calculated using the formula below:"]
[]
[]
[null,null,null,"Example"]
[null,null,null,"Tim, an engineer, is paid a total annual salary package of $130,000. Tim will spend 14 weeks integrating a prototype into a commercial partner’s facility. During this period, Tim will work on eligible project activities 70 per cent of the time. The remaining 30 per cent of Tim’s time will be spent on other non-project activities. Eligible labour cost for Tim is calculated as follows:"]
[null,null,null,"$130,000 x 14/52 x 0.70 = $24,500"]
[null,null,null,"Plus the 40 per cent allowance for on costs and overhead:"]
[null,null,null,"$24,500 + (24,500 x 0.40) = $34,300"]
[null,null,null,"Therefore, total eligible labour expenditure that may be claimed for Tim is $34,300."]
[null,null,"3.1.3","Ineligible labour expenditure"]
[null,null,null,"Non-cash salary: Salary costs based on an estimation of the employee’s worth to the Participant where no cash changes hands and no amount is credited to a loan account or to a Participant’s current accounts are not eligible salary expenditure."]
[null,null,null,"Related parties: Amounts credited by journal entry to the loan accounts or current accounts of principals and/or their relatives are not eligible salary expenditure until the individual income tax returns have been sighted by Accelerating Commercialisation and the tax payable on the salary has been assessed by the ATO, or similar satisfactory evidence has been provided that income tax has been paid."]
[null,null,null,"Labour expenditure for leadership or administrative staff not approved as Experienced Executives: Labour expenditure for leadership or administrative staff (such as CEOs, CFOs, accountants and lawyers) is not eligible expenditure unless the Participant substantiates to the Programme Delegate’s satisfaction that these costs directly relate to performance of core elements of the agreed project. Please note:"]
[null,null,null,"·         the costs to the Participant of its employees performing an administrative function are included in the employee administrative overhead (see section 3.1.1)."]
[null,null,null,"·         the costs to the Participant of its factory employees working solely on the installation or construction of plant or prototypes are included in the plant expenditure category (see section 3.3), State-of-the-art plant or pilot manufacturing plant category (see section 3.4), or prototype expenditure category (see section 3.5)."]
[null,3.2,null,"Contract expenditure"]
[null,null,null,"Eligible contract expenditure is the cost of any agreed project activities performed for the Participant by:"]
[null,null,null,"·         another organisation, or"]
[null,null,null,"·         an individual engaged under separate contract."]
[null,null,null,"To be eligible, all contractor project work must be the subject of a prior written contract—for example, a formal agreement, letter or purchase order—which specifies the nature of the work to be performed for the Participant and the applicable fees, charges and other costs payable."]
[null,null,null,"Invoices from contractors must provide a detailed description of the nature of the work, the hours and hourly rates involved, and any specific plant or prototype expenses incurred. Invoices must enable the Programme Delegate to determine whether the proposed expenditure directly relates to the agreed project, would qualify as eligible expenditure if it was claimed directly by the Participant and is reasonable and commensurate for the activities performed."]
[null,null,null,"Where a contractor is engaged in constructing, assembling, installing and/or commissioning plant or prototypes, the contractor's costs should be apportioned between:"]
[null,null,null,"·         design costs, claimed as contract expenditure, and"]
[null,null,null,"·         constructing, assembling, installing and/or commissioning costs, claimed as either plant expenditure (see section 3.3), and State-of-the-art manufacturing plant or pilot manufacturing plant expenditure (see section 3.4), or prototype expenditure (see section 3.5)."]
[null,null,"3.2.1","Contractors that are a related body corporate of the Participant"]
[null,null,null,"Where the contractor is a related body corporate of the Participant, eligible contract expenditure is limited to the measurable direct cost to the contractor of performing the contracted project work transferred to the Participant with no profit margin attached, 'at cost'."]
[null,null,null,"In accordance with the general conditions of the funding agreement, the Participant is required to ensure all project contractors keep a record of the costs of their work on the project. For purposes of verifying that contract expenses are purely 'at cost' (refer governing principles) and contain no element of profit the Department may require the Participant to obtain and provide a contractor’s records of its costs of doing project work. If such records are not provided the Department may deem the relevant contract expense not to be eligible expenditure."]
[null,null,"3.2.2","Calculation of eligible expenditure for an individual engaged under separate contract"]
[null,null,null,"The cost of administrative overheads for certain contractors engaged on the agreed project is recognised as a component of eligible contract expenditure. Administrative overhead may be claimed for each contractor who regularly works a minimum of 35 hours per week at the Participant’s premises, but not necessarily on the agreed project or agreed activities. The contractor administrative overhead rate is a set rate of 20 per cent of the contractor’s fee for work performed on project activities."]
[null,null,null,"Eligible contract expenditure must be calculated using the formula below."]
[]
[]
[null,null,null,"Example"]
[null,null,null,"Anne is the new full time CEO of the company. She has been approved as an Experienced Executive for a period of two years and is paid an annual contract fee of $250,000. Anne will work 40 per cent of the time on agreed project activities (mainly business development), 40 per cent of the time on other agreed activities (mainly capital raising and business planning) and 20 per cent of the time on unrelated not agreed activities (e.g. the company’s new research project). Eligible contract expenditure for Anne is calculated as follows:"]
[null,null,null,"$250,000 x 104/52 x 0.80 = $400,000"]
[null,null,null,"Plus the 20 per cent allowance for administrative overheads:"]
[null,null,null,"$400,000 + (400,000 x 0.20) = $480,000"]
[null,null,null,"Therefore, total eligible contract expenditure that may be claimed for Anne is $480,000."]
[null,null,null,"For grant claim purposes, the maximum contractor fee for an Experienced Executive is $250,000 in each full financial year (July-June) of the project period. The maximum contractor fee for an Experienced Executive in a less-than-complete financial year that is part of the project period is reduced proportionately from the $250,000 maximum."]
[null,null,null,"Contract costs for leadership and administrative contractors not approved as Experienced Executives (such as contracted CEOs, CFOs, accountants and lawyers) are not eligible expenditure unless the Participant substantiates to Accelerating Commercialisation’s satisfaction that these costs relate to performance of core elements of the agreed project."]
[null,3.3,null,"Plant expenditure"]
[null,null,null,"Plant is usually an input to the agreed project or the tools or infrastructure used to pursue the agreed project. Plant is likely to have a value or use outside of the agreed project and can be constructed or otherwise obtained with minimal technical risk or new learning. Further guidance on how to treat plant expenditure is at Appendix A."]
[null,null,"3.3.1","Newly purchased plant and pre-existing purchased plant"]
[null,null,null,"Eligible expenditure on newly purchased and pre-existing purchased plant is the depreciation—that is, decline in asset value—of an item of plant allowed through the Commissioner of Taxation’s effective life schedules, according to the proportion of time for which it is used on the agreed project. In extraordinary situations, for instance where the plant is subject to heavy usage, and where this is in accordance with Commissioner of Taxation’s rules, a higher rate of depreciation may be applied than is otherwise provided for by the effective life schedules."]
[null,null,null,"Total depreciation charges for each particular item of purchased plant, for the proportion and length of time it is used on the project, can be claimed in full at the time of its deployment."]
[null,null,null,"Running costs for purchased or pre-existing plant are eligible expenditure but must be readily verifiable and may include items such as rent, light and power, and repairs and maintenance."]
[null,null,"3.3.2","Hired/leased plant"]
[null,null,null,"Eligible expenditure for hired, rented, or leased plant is the number of payment periods dedicated to the agreed project use multiplied by the period hiring fee. Where plant is purchased under a hire purchase agreement, or a lease is used to finance the purchase of the plant, the cost of the item of plant, excluding interest, is capitalised, and then depreciated in the manner set out in section 3.3.1."]
[null,null,null,"Running costs for hired or leased plant are eligible expenditure but must be readily verifiable and may include items such as rent, light and power, and repairs and maintenance."]
[null,null,"3.3.3","Constructed plant"]
[null,null,null,"Eligible expenditure on constructed plant is the depreciation—that is, decline in asset value—of the item of constructed plant allowed through the Commissioner of Taxation’s effective life schedules, according to the proportion of time for which it is used on the agreed project. In extraordinary situations, for instance where the plant is subject to heavy usage, and where this is in accordance with Commissioner of Taxation’s rules, a higher rate of depreciation may be applied than is otherwise provided for by the effective life schedules."]
[null,null,null,"Leasehold improvements to a leased project facility may be claimed as constructed plant eligible expenditure if the improvement cost is capitalised in the Participant’s financial statements (balance sheet) and depreciated in the manner highlighted above."]
[null,null,null,"The starting value for constructed plant depreciation calculations is the capitalised construction cost or capitalised leasehold improvement cost for the plant item in accordance with ATO requirements. Total depreciation charges for each particular item of constructed plant, for the proportion and length of time it is used on the project, can be claimed in full at the time of its deployment."]
[null,null,null,"Once fully completed, running costs for constructed plant are eligible expenditure but must be readily verifiable and may include items such as rent, light and power, and repairs and maintenance."]
[null,3.4,null,"State-of-the-art manufacturing plant or pilot manufacturing plant"]
[null,null,null,"The full cost (rather than depreciation cost only) of establishing a state-of-the-art manufacturing plant (SMP) or pilot manufacturing plant (PMP) is eligible expenditure if the following conditions are met:"]
[null,null,null,"·         In the case of a PMP, the establishment of the plant is necessary to demonstrate the commercial feasibility of:"]
[null,null,null,"§  producing a novel product or service; or"]
[null,null,null,"§  a substantially novel process for the production of an existing product where the novel production method is the IP being commercialised."]
[null,null,null,"In other words, the pilot plant is established primarily for testing and/or market validation purposes."]
[null,null,null,"·         In the case of an SMP, the establishment of the plant is necessary to achieve first sales of a novel product or service (i.e. it is established as a long term sustainable production facility). The plant must be a “state-of-the-art” manufacturing plant utilised in the manufacture of a novel product (or the commercialisation of a novel service), where such a product cannot be manufactured in (or the service cannot use) an existing plant in Australia, meaning:"]
[null,null,null,"§  no manufacturing process of its kind currently exists in Australia;"]
[null,null,null,"§  current manufacturing capability in Australia does not satisfy the definition of “state-of-the-art”; or"]
[null,null,null,"§  competition or capacity constraints means the applicant cannot access an existing plant."]
[null,null,null,"In cases where the manufacturing process could reasonably be split into several process steps for manufacturing operations at different sites, the above tests must be applied to each step or operation that performs a part of the overall manufacturing process."]
[null,null,null,"·         The plant must be established in Australia."]
[null,null,null,"·         The plant must be used exclusively for the purposes of the project, unless otherwise approved by the Programme Delegate. This obligation applies for a period of two years from the start date of the project, unless the Commonwealth, by written notice, advises otherwise."]
[null,null,null,"The following criteria must be satisfied in order for an individual item of plant to be claimable at full cost as part of a state-of-the-art manufacturing plant or pilot manufacturing plant:"]
[null,null,null,"·         The item must be used exclusively for the purposes of the project;"]
[null,null,null,"·         It is not feasible to hire, rent or lease the item;"]
[null,null,null,"·         The item must be owned by the Participant; and"]
[null,null,null,"·         The item cannot be a block of land or a building."]
[null,null,null,"Expenditure for hired, rented, or leased plant or facility cannot be claimed under the ‘state-of-the-art manufacturing plant or pilot manufacturing plant’ head of expenditure, but may be eligible to be claimed under the ‘Plant’ head of expenditure (see section 3.3)."]
[null,null,null,"Once fully completed, running costs for the plant or facility are eligible expenditure but must be readily verifiable and may include items such as rent, light and power, and repairs and maintenance."]
[null,null,null,"Note that these eligible expenditure rules are for the purpose of the Accelerating Commercialisation programme only and different rules are likely to apply in relation to a Participant’s financial reporting and taxation obligations."]
[null,null,null,"Additional guidance on manufacturing plant expenditure is in Appendix A."]
[null,null,"3.4.1","Eligible expenditure limit in relation to the SMP or PMP head of expenditure"]
[null,null,null,"There is no pre-set limit on SMP or PMP expenditure at the application stage. However, if an application that includes SMP or PMP expenditure is approved, it will only be approved with a condition that eligible expenditure on SMP or PMP is limited to a certain amount, which is typically the amount the applicant has requested in their application. The upper limit on SMP or PMP eligible expenditure will be included in the funding agreement and any changes to that upper limit will require Programme Delegate approval for variation of the funding agreement."]
[null,3.5,null,"Prototype expenditure"]
[null,null,null,"Prototype expenditure is eligible expenditure only where the construction and use of the prototype in the agreed project contributes directly to proving the commercial viability of a novel product, process or service. The Programme Delegate may refuse to accept a prototype eligible expenditure claim where the number of prototypes and the scale of prototypes exceed the level needed to prove the concept(s) underpinning the agreed project and/or establish its commercial viability."]
[null,null,null,"The total costs of constructing prototypes are included under this category, with the exceptions that:"]
[null,null,null,"·         equipment or tools used in the construction of the prototype should be claimed as plant expenditure—see section 3.3"]
[null,null,null,"·         the Programme Delegate may determine that part or all of the prototype should be claimed as plant expenditure, consistent with the following approach:"]
[null,null,null,"·        if the prototype includes significant items of machinery, equipment or tools and these items have a value beyond the project period, then these items should be claimed as depreciable plant items under the plant expenditure category—see section 3.3. Such items will normally be stand-alone modules that are acquired off the shelf or are constructed with a low level of technical risk. To have a ‘value beyond the project period’ means it is highly likely the applicant will be able to sell an item to an independent party for use in activities unrelated to the project."]
[null,null,null,"Costs incurred in the construction of a number of identical prototypes are eligible expenditure only where a strong reason for multiples exists, such as to enable testing under varied operating conditions. Prototype expenditure includes the cost of materials used in testing a process or prototype."]
[null,null,null,"Once fully completed, running costs for prototypes are eligible expenditure but must be readily verifiable and may include items such as rent, light and power, and repairs and maintenance."]
[null,3.6,null,"Other expenditure"]
[null,null,null,"This eligible expenditure category captures most miscellaneous costs not covered by any of the above categories. These may constitute eligible expenditure to the extent that they are a direct cost to the agreed project, and may include:"]
[null,null,null,"·         substantial travel on the agreed project—limited to the reasonable cost of accommodation (excluding meals and incidentals) and transportation required to conduct agreed project activities in Australia and overseas and/or to conduct agreed collaboration activities (note: meals and incidental costs are covered by fixed loadings on salaries)."]
[null,null,null,"§  if specific travel costs are not identified in the application, this ‘other expenditure’ is not eligible during the project period unless the Programme Delegate subsequently approves a request from the Participant."]
[null,null,null,"§  ‘reasonable cost of transportation’ for air transportation is an economy class fare for each sector travelled; where non-economy class air transport is used only the equivalent of an economy fare for that sector is eligible expenditure. Where non-economy class air transport is used, the Participant will be required to show evidence of what an economy air fare costs at the time of travel where requested."]
[null,null,null,"§  accommodation refers to room cost only. Associated costs such as meals, internet, entertainment and other incidentals are not eligible travel expenditure and cannot be claimed as part of the cost of accommodation."]
[null,null,null,"§  transport may include the cost of local transport at outward destinations."]
[null,null,null,"·         training costs—where the skills acquired are specific to the requirements of an agreed project and are not covered under other heads of expenditure"]
[null,null,null,"·         product liability insurance in relation to an agreed project—where this insurance is a normal and essential cost of undertaking the project. If the product liability insurance has a value or usage outside the project the cost of the insurance must be apportioned on the basis of the proportion of the insurance directed to covering the project."]
[null,null,null,"·         IP protection expenditure - reasonable costs that protect IP that is related to the agreed project and that the Participant does or will directly own are eligible expenditure. These costs can include fees to a patent office for the cost of filing a patent application, patent search and examination fees, freedom to operate review costs, and annual patent maintenance fees. The cost of defending IP rights is not eligible expenditure, with the exception of legal expenses insurance as it relates to IP."]
[4,null,null,"Treatment of certain activities"]
[null,4.0999999999999996,null,"Experienced Executive - engage an experienced chief executive officer or other senior executive."]
[null,null,null,"The employment of an experienced chief executive officer or other senior executive is supported under Accelerating Commercialisation for all applicants other than Commercialisation Offices and Eligible Partner Entities. The executive is expected to bring complementary skills and experience to the business and to drive it towards a successful launch of their novel product, process or service in the marketplace. The executive may be engaged on a part-time basis, or engaged full time and split their time between the agreed project and other projects, but combined hours of work on the agreed project and agreed activities cannot be less than three days per week (or equivalent)."]
[null,null,null,"The executive’s main role is to execute the agreed project, but time spent on other activities in support of the business is also considered ‘agreed activities’ and therefore eligible expenditure if either noted in the approved application or agreed to by the Commercialisation Adviser during the course of the project."]
[null,null,null,"The application must clearly outline the key performance indicators for the Experienced Executive and how these correlate with the project’s execution plan and milestones."]
[null,null,null,"Where the Experienced Executive to be employed by the applicant is not known at the time of application the applicant must select a person and seek the consent of the Programme Delegate within three months of notification that the application was successful. Similarly, consent of the Programme Delegate is required if a Participant wishes to appoint a different Experienced Executive during the course of the project. A replacement Experienced Executive must be in place within three months of the departure of an existing Experienced Executive. The role of an Experienced Executive must be identified in the project budget calculator."]
[null,null,"4.1.1","Previous association of the Experienced Executive with the applicant"]
[null,null,null,"Previous association with the applicant does not necessarily preclude a person from being approved as the Experienced Executive. The application must demonstrate that the person:"]
[null,null,null,"·         has the required skills critical to the success of the project and the company and would be the most appropriate person for the position;"]
[null,null,null,"·         brings complementary skills and experience that assist existing management to drive the business towards a successful launch of its novel product, process or service in the marketplace; and"]
[null,null,null,"·         did not receive and will not receive any favourable treatment by virtue of their association with the company and any of its directors or major shareholders. This includes the selection process, the remuneration and terms of employment, and the management of potential underperformance once employed."]
[null,null,null,"However, significant shareholders (controlling 20 per cent or more of a company’s shares at the time the grant application is lodged) and founders are not eligible Experienced Executives."]
[null,4.2,null,"Business development and supporting activities"]
[null,null,null,"The cost of business development activities and other activities geared towards building the supporting elements for successful commercialisation of a particular product, process or service is eligible expenditure if:"]
[null,null,null,"·         the activity is consistent with the project eligibility requirements set out in section 5 of the Customer Information Guide; and"]
[null,null,null,"·         the activity is not listed under section 5 of these Eligible Expenditure Guidelines as an ineligible activity, or the Programme Delegate has otherwise determined that the activity is ineligible."]
[null,null,null,"Examples of eligible business development and supporting activities expenditure are:"]
[null,null,null,"·         Labour expenditure for a sales person or a business development manager."]
[null,null,null,"·         Labour expenditure or legal costs in regards to setting up licensing, distribution or manufacturing agreements."]
[null,null,null,"·         Contractor’s fees for developing a capital plan and/or an investment proposal in order to secure continuing funding for the project beyond the grant period."]
[null,null,null,"·         Labour expenditure and other costs in relation to developing a partnership or collaboration with another business or organisation to increase the chances of commercial success for the project."]
[null,null,null,"·         Labour expenditure and other costs in relation to obtaining regulation and standards compliance, such as certification or accreditation, in the market(s) relevant to the project."]
[null,null,null,"·         Labour expenditure and travel costs to attend a trade show (as either exhibitor or visitor to the trade show)."]
[null,null,null,"·         Labour expenditure, travel and other costs to participate in roadshows organised by Accelerating Commercialisation (refer to section 3.4 in the Customer Information Guide)."]
[null,4.3,null,"Overseas activities"]
[null,null,null,"Eligible overseas activities expenditure is eligible expenditure on project activities that are not undertaken in Australia by a Participant’s staff, contractors or subcontractors. This includes all types of expenditure directly related to such activities, including on-costs, travel and depreciation of plant. For example, travel expenditure in relation to an overseas activity that has been booked and paid for in Australia is considered overseas expenditure."]
[null,null,null,"Plant and other goods, including goods purchased for inclusion in a prototype, that are purchased overseas are not necessarily treated as overseas expenditure. Where plant is used, not where it is purchased, is the basis of treating plant expenditure as overseas or domestic expenditure."]
[null,null,null,"Eligible overseas activities expenditure generally is limited to 10 per cent of total eligible expenditure. All overseas activities expenditure above this cap will not qualify as eligible expenditure, except where the applicant or Participant obtains the Programme Delegate’s prior approval (before incurring the expenditure). The Programme Delegate will assess all such requests on a case-by-case basis, taking into account factors such as:"]
[null,null,null,"·         the availability of domestic resources and facilities."]
[null,null,null,"·         the appropriateness of carrying out activities overseas rather than within Australia."]
[null,null,null,"·         cost implications."]
[null,null,null,"·         how the additional overseas activities expenditure is likely to aid the project in meeting Accelerating Commercialisation’s policy objective."]
[null,null,null,"The Programme Delegate may seek advice from the advisory committee when making a decision on whether to allow a claim for more than 10 per cent of an agreed project’s eligible expenditure on overseas activities."]
[null,4.4000000000000004,null,"Acquisition of new and leading-edge technology"]
[null,null,null,"Acquisition of new and leading-edge technology is eligible expenditure where subsequent adaptation of that technology will contribute directly to completion of the agreed project."]
[null,null,null,"Eligible expenditure on this activity includes, but is not limited to:"]
[null,null,null,"·         technology audit fees"]
[null,null,null,"·         network membership fees"]
[null,null,null,"·         expert advice fees"]
[null,null,null,"·         process or systems changes to take into account the novel technology"]
[null,null,null,"·         information dissemination relating to technology acquisition that is part of the project."]
[null,null,null,"Where access to technology or IP is essential for the conduct of an agreed project, licence fees or purchase costs to access such technology or IP may qualify as eligible expenditure. Independent valuations of purchased technology, including IP, are needed to substantiate the cost of any expenditure claimed. Where the Participant licenses technology or IP from a related body corporate, expenditure must be calculated 'at cost' (refer governing principles in section 2)."]
[null,4.5,null,"Project-related use of acquired technology"]
[null,null,null,"If acquired technology has a value or usage outside the agreed project then acquisition costs must be apportioned on the basis of agreed project-related usage of the purchased technology. In the event that the acquired technology is in the form of plant expenditure or purchased capital goods, this item of eligible expenditure will be subject to the same depreciation treatment as set out in section 3.3."]
[null,4.5999999999999996,null,"Product/process design activities"]
[null,null,null,"The costs of product/process design activities are eligible where they relate to turning the prototype of a working product or process into a commercially viable design. This includes using engineering expertise to determine prototype structure, function and materials. These costs may include, for example, development of new or improved:"]
[null,null,null,"·         measurement and control systems"]
[null,null,null,"·         operational approaches—for example, through process optimisation or increased prototype functionality"]
[null,null,null,"·         materials handling techniques."]
[null,null,null,"The design costs of routine or periodic alterations to existing products, production lines, manufacturing processes, services, and other on-going operations are eligible expenditure only if they relate directly to the agreed project."]
[null,4.7,null,"Trial production runs"]
[null,null,null,"The cost of a number of trial production runs sufficient to demonstrate commercial viability is eligible expenditure. The total costs of the trial production runs are eligible expenditure. However, the cost of equipment or tools used in the construction of the run is to be claimed under ‘Plant expenditure’ (section 3.3) or ‘state-of-the-art plant or pilot manufacturing plant expenditure’ (section 3.4)."]
[null,null,null,"Eligible expenditure under this category includes costs incurred in validation, establishing efficacy, demonstration of capability, scale-up, and development of evidence of the stability or reproducibility of processes, and production of product necessary to achieve first sales."]
[null,null,null,"Income from the sale of prototype(s) and/or first sales has no impact on the agreed grant amount, i.e. it does not need to be offset from project eligible expenditure."]
[null,4.8,null,"Quality control activities"]
[null,null,null,"Quality control activities, including achieving quality control accreditation, are eligible activities if they are necessary for the commercialisation of the subject novel product, process or service."]
[5,null,null,"Activities not funded under Accelerating Commercialisation"]
[null,null,null,"The cost of some activities conducted as part of an agreed project may not be eligible expenditure. A Participant must ensure it has adequate funds to meet the cost of both the eligible and ineligible expenditure associated with its project."]
[null,null,null,"Ineligible activities include but are not limited to:"]
[null,null,null,"·         preparing the grant application, any project variation requests and any project reports (except costs of independent audit reports as set out in section 6)."]
[null,null,null,"·         full scale production and inventory costs where the project has already achieved first sales."]
[null,null,null,"·         all forms of advertising and the production of promotional material (including web sites and apps whose primary purpose is advertising or promotion)."]
[null,null,null,"·         establishing general infrastructure or obtaining resources used on the project—such as interest on loans, job advertising and recruiting, and transporting goods to be used on the project (note: some or all of these costs are covered by fixed loadings on salaries and contractor fees for salary on-costs and administration overheads)."]
[null,null,null,"·         general business management and administration not directly related to the eligible project (note: project related general business costs may be covered by fixed loadings on salaries and contractor fees for salary on-costs and administration overheads)."]
[null,null,null,"·         defending intellectual property rights."]
[null,null,null,"·         prospecting, exploring or drilling for minerals, petroleum or natural gas for the purpose of discovering deposits, determining more precisely the location of deposits or determining the size or quality of deposits."]
[null,null,null,"·         making donations/sponsorships/gifts."]
[null,null,null,"·         opportunity costs relating to forgone production and production downtime arising from the allocation of resources to the agreed grant project."]
[null,null,null,"·         any activity related to the reproduction of a commercial product or process by a physical examination of an existing system or from plans, blueprints, detailed specifications or publicly available information."]
[null,null,null,"·         acquisition or development of land and buildings (unless otherwise noted in the eligible expenditure guidelines)."]
[null,null,null,"This list is not exhaustive. Other specific expenditure may be ineligible because the Programme Delegate decides it does not directly support the achievement of the planned outcomes of the project or it is contrary to the spirit and intention of Accelerating Commercialisation."]
[6,null,null,"Audit certificate"]
[null,null,null,"The preparation of an audit certificate is eligible expenditure. It is restricted to a maximum of one per cent of total eligible expenditure on the agreed project, unless otherwise agreed to by the Programme Delegate."]
[]
["Appendix A",null,null,"Plant expenditure decision tree"]
[null,null,null,"Accelerating Commercialisation offers grant assistance for the establishment of manufacturing plants under three different heads of expenditure. Below is a decision tree assisting applicants in determining which head of expenditure they should claim their plant expenditure under."]