{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["SADI Budget Guide ","SADI Attachment Guide","1. TTS","2. HRT","3. MCC","4. OEM","5. ASS","6. OJT","Travel Costs","Sheet2"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":3,"defined_names":23,"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":"SADI Budget Guide ","index":0,"n_rows":337,"n_cols":1,"rows_kept":337,"cut":false,"hidden":false,"merged":[]}
["Skilling Australia's Defence Industry (SADI) Budget Guidance "]
[]
["The SADI Application Budget spreadsheet will be a key document to assess your project's expenditure eligibility.\n"]
["All quotes and details should be for projects that are ready to be implemented. It is expected quotes will be firm. Include the names of anyone receiving training in the Budget spreadsheet. "]
[]
["Budget Overview"]
["This budget is an attachment that must be included with your application submission.  "]
["The budget provides a break-up of the costs for your project."]
["There are six grant activity type funding options available for applicants."]
["The first four are training activities and the last two are training supervision activities."]
["If you are applying as a defence industry association, only activity type options 1, 2 and 3 are applicable. \n"]
["Each section is colour coded as below to assist with finding the appropriate category for use. "]
[]
["The activity type sections are:"]
["     1. Technical and trade skills training (TTS)"]
["     2. Human resources training and skills development practices (HRT)"]
["     3. Micro-credentials courses (MCC)"]
["     4. Original Equipment Manufacturer training (OEM)"]
["     5. Apprenticeship supervision support (ASS)"]
["     6. On the job training supervision support (OJT)"]
[]
[]
["Entering Project Activities"]
["Ensure you can see all tabs as shown below, and use the appropriate tab for budget entries in each category type:"]
[]
[]
["For example, if you are seeking funds for Technical and trade skills training as well as Apprenticeship supervision support, you must complete details in both of these activity tabs with details of the project activities."]
[]
["You must use your \"Project Activities\" title as entered in your application as your budget \"Project Activity\" name (this will match your application \"Project Milestone\"). This must be entered into the correct activity type section e.g. Apprenticeship Supervision Support (ASS)."]
["For example the \"Project Activities\" name in your application for 5. ASS Engineering Cert III would be copied to section 5. Apprenticeship Supervision Support in the budget \"Project Activity\" column as 5. ASS Engineering Cert III. An example is shown below:"]
[]
["       Application extract                                                                                                                                               Budget extract"]
["       Project Activities                                                                                                                                                   Project Activity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Entering Project Costs"]
["The budget items must be directly linked to the \"Project activities\" as per your application submission. "]
["Check the \"Project milestone\" estimated cost and \"Project activities - Estimated total cost\" in the application exactly matches the \"Project Activity\" cost in the budget and the quote cost."]
["The value entered for each Project Activity against each activity type must exactly match the value entered for the related \"Project milestone\" and \"Project Activities - Estimated total cost\" in your Application. An example of how this would appear is shown below:"]
[]
["       Application extract                                                                             Application extract                                                                 Budget extract"]
["      Project milestones                                                                               Project activities                                                                       Project Activity                                                                                                     "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Quote Requirements"]
["The project should be ready to implement with costings supported by an itemised quote for proposed training activities."]
["All applications must have an attached quote detailing Project Activity costs (see Quotes section below for detail needed)."]
["All costs MUST be entered excluding GST."]
["I. Internal Training Quote/Costings (quotes/costings from the applicant company for an instructor who is an employee of your company)"]
["All internal training proposal quotes/costings need to have the following information:"]
["* project activity. The Project Activity name entered in the budget tab should be identical to the application's \"Project activities\" title, which exactly matches the application's \"Project milestone\""]
["* the specific skills set the training relates to (refer Grant Opportunity Guidelines section 5.1 Eligible activities)"]
["* evidence of instructor's qualifications to deliver the training"]
["* a training plan/syllabus. It is suggested the document includes a training plan table with the following:"]
["- details on the training being delivered. This must be clear, with each element of the training explained"]
["- details on who will be delivering the training"]
["- details on employee's qualifications to deliver the training"]
["- details on the costs per hour of each element of the training plan. Wages of the trainer can only be claimed on a cost recovery basis for the duration of the training"]
["- details on the hours allocated to each element of the training plan"]
["- costs for training materials and text books for each student (if applicable)"]
["- costs for external venue hire or audio visual equipment hire needed for the training (if applicable)"]
["- itemised costs for eligible travel (this will be expanded below)"]
["- total cost for the project activity"]
["* the Application Total Quote Cost in the Application Budget spreadsheet must be identical to the quote/costing  "]
[]
["II. External Training Quotes (quotes from training instructors who are external to your business)"]
["All external training proposal quotes need to have the following information:"]
["* project activity. The Project Activity name entered in the budget tab should be identical to the application's \"Project activities\" title, which exactly matches the application's \"Project milestone\""]
["* evidence training is being delivered by a registered training organisation, accredited training provider, professional or industry association or original equipment manufacturer (OEM activity type)"]
["* the specific skills set the training relates to (refer Grant Opportunity Guidelines section 5.1 Eligible activities)"]
["* a detailed course outline. It is suggested the course outline includes a training plan table with the following:"]
["- details on the training being delivered. This must be clear, with each element of the training explained"]
["- details on who will be delivering each element of the training"]
["- details on the costs per hour of each element of the training plan "]
["- details on the hours allocated to each element of the training plan"]
["- costs for training materials and text books for each student (if applicable)"]
["- costs for external venue hire or audio visual equipment hire needed for the training (if applicable)"]
["- itemised costs for eligible travel (this will be expanded below)"]
["- total cost for the project activity"]
["* the Application Total Quote Cost in the Application Budget spreadsheet must be identical to the provider's quote cost  "]
[]
["Other attachments "]
["The following general attachments are needed:"]
["a.     Itemised budget attachment - all applications"]
["The SADI Application Budget template (this document) must be attached to your application submission"]
["b.    Trust document (where applicable)"]
["To be provided by applicants who are incorporated trustees on behalf of a trust"]
["c.     Defence Industry Association membership evidence (where applicable)"]
["To be provided if you are applying as a defence industry association"]
[]
[]
["For Reference"]
["The following instructions are to help with entering the budget details for each project activity.                                                                                                                               This information can also be found on the budget tab."]
[]
["Entering Application Budget Details"]
["     1. Technical and trade skills training (TTS)"]
["     2. Human resources training and skills development practices (HRT)"]
["     3. Micro-credentials courses (MCC)"]
["Technical and trade skills training (TTS), Human resources training (HRT) and Micro-credentials courses (MCC) have the same budget details to be completed. "]
["Instructions to fill in the budget details are as follows:"]
["A. Not for use"]
["B. Project Activity"]
["The Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                  "]
["It is important to ensure these numbers and names are identical to enable reconciliation between the application and the budget. "]
["C. Primary Capability Stream"]
["Indicate for each project activity if the specific training relates to naval ship building by responding Yes or No."]
["D. Participant's Name"]
["Enter the name of the staff member and their title if they will be undertaking the training activity"]
["It is expected you might have multiple staff undertaking a project activity, you must enter a new line for each person against the activity name"]
["For example if 4 staff are attending 1. TTS Advanced CAD Use Training, you will repeat this project activity name 4 times so there is an entry for each employee"]
["E. Job Title"]
["Enter the job title for staff member who will be undertaking the training activity"]
["F. Company  "]
["To be completed by defence industry associations                                                                           "]
["Enter the name of the company that will be receiving training. The company must be a member of your association "]
["G. Type of Provider"]
["Select the type of provider from the drop down menu"]
["There are two types of providers, external or internal"]
["Training can be delivered externally, by a qualified instructor from outside the organisation. In this situation you will select external "]
["Training can be delivered internally, by a qualified instructor from inside the organisation. In this situation you will select internal"]
["H. Provider Name"]
["If the training is external enter the name of the organisation who is delivering the training"]
["If the training is internal enter the name and title of the internal employee who is delivering the training"]
["I. Training Quote"]
["Please ensure quotes exclude GST. Courses subsidised through fee assistance schemes (eg. FEE-HELP) are not be eligible for funding"]
["The value should equal the training cost element in your quote. If it does not, look at the figures entered and make any adjustments"]
["J-M. Training Support Activities"]
["The grant will cover a number of training support activities"]
["These must be included in the quote from your provider"]
["If the training is internal the training support activities costs must also be included in your quote/costings"]
["You must include the cost for the training support activities against each employee, so if you are buying a total of $100 of training material for 4 staff, you will allocate $25 against each person"]
["There are four support areas that are funded:"]
["- Training material. This is costs for any training material in the quote/costings needed for training facilitation  "]
["- Text books. This is the cost for text books that have been specifically prescribed for the course in the quote/costings"]
["- External venue hire. This is for any venue hire needed to run the course. This will be specifically included in the quote/costings"]
["- Audio visual equipment hire. This is for audio visual equipment hire costs needed specifically for the course. This will be included in the quote/costings"]
["- For external venue hire or audio visual equipment hire you can put this charge against one person attending the course, rather than divide by each attendee if there is more than one person nominated against the training activity/project milestone. This will be included in the quote/costings "]
["N. Travel - refer \"Entering Travel Costs Budget Details\" below"]
["O. Application Total Quote Cost"]
["This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application"]
[]
[]
["4. Original Equipment Manufacturer (OEM) budget - SME's Only"]
["The training activity OEM training costs must not be in the product's purchase price."]
["Instructions to fill in the budget details are as follows:"]
["As the eligibility of staff is determined at application stage, staff names will be needed to be included in the budget. "]
["A. Not for use"]
["B. Project Activity"]
["The Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                  "]
["It is very important these names are identical to enable reconciliation between the application and the budget. "]
["C. Primary Capability Stream"]
["Indicate for each project activity if the specific training relates to naval ship building by responding Yes or No."]
["D. Name"]
["Enter the name of the staff member if they will be undertaking the training activity"]
["It is expected you might have multiple staff undertaking a project activity, you must enter a new line for each person against the activity name"]
["For example if 4 staff are attending 4. OEN Anzac Class Gearbox training, you will repeat this project activity name 4 times so there is an entry for each employee"]
["E. Job Title"]
["Enter the job title of the staff member if they will be undertaking the training activity"]
["F. Not for use"]
["G. Provider Name"]
["Enter the name of the organisation who is delivering the training"]
["H. Training Quote"]
["This is a calculated field that multiplies the provider wage/charge by the number of hours of training"]
["The value should equal the training cost element in your quote/costings. If it does not, look at the figures entered and make any adjustments"]
["I-L. Training Support Activities"]
["The grant will cover a number of training support activities"]
["These must be included in the quote from your provider"]
["You must include the cost for the training support activities against each employee, so if you are buying a total of $100 of training material for 4 staff, you will allocate $25 against each person"]
["There are four support areas that are funded:"]
["- Training material. This is costs for any training material in the quote/costings needed for training facilitation  "]
["- Text books. This is the cost for text books that have been specifically prescribed for the course in the quote/costings"]
["- External venue hire. This is for any venue hire needed to run the course. This will be specifically included in the quote/costings"]
["- Audio visual equipment hire. This is for audio visual equipment hire costs needed specifically for the course. This will be included in the quote/costings"]
["- For external venue hire or audio visual equipment hire you can put this charge against one person attending the course, rather than divide by each attendee if there is more than one person nominated against the training activity/project milestone. This will be included in the quote/costings "]
["M. Travel - refer \"Entering Travel Costs Budget Details\" below"]
["N. Application Total Quote Cost"]
["This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application"]
[]
[]
["5. Apprenticeship Supervision Support (ASS) budget - SMEs Only"]
["Apprenticeship supervision support is a supervision training activity."]
["Instructions to fill in the costs are as follows:"]
["A. Not for use"]
["B. Project Activity "]
["The Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                  "]
["The activity will be for skilling qualification the supervision will support"]
["It is very important these names are identical to enable reconciliation between the application and the budget. "]
["Training is restricted to apprentice staff only"]
["C. Primary Capability Stream"]
["Indicate for each project activity if the specific training relates to naval ship building by responding Yes or No."]
["D. Employee Name "]
["Enter the name of each company apprentice being supervised. If more than one apprentice is being supervised against the activity, enter a new line for each and repeat the supervision support activity details"]
["It is expected you might have multiple staff undertaking a project activity, you must enter a new line for each person against the activity name"]
["For example if 4 staff are undertaking 5. ASS Engineering Certificate III, you will repeat this project activity name 4 times so there is an entry for each employee"]
["As the eligibility of staff is determined at application stage, staff names will need to be included in the budget. "]
["E. Employee Title"]
["Enter title of the apprentice undertaking the training"]
["F. Is the Employee an Apprentice?"]
["Using the drop down menu select yes or no against the question asked if the employee is an apprentice"]
["If the employee is not an apprentice all costs will be ineligible"]
["G. Not for use"]
["H. % Time on Defence Projects                                     "]
["Enter percentage of time the apprentice is expected to spend on defence projects"]
["I. Supervisor's Name"]
["Enter name of each appropriately qualified company employee(s) who will undertaking the supervision"]
["J. Supervisor's Title"]
["Enter title of each appropriately qualified company employee(s) who will be supervising"]
["K. Start Date"]
["Enter date supervision will start"]
["L. End Date"]
["Enter date supervision will end"]
["M. Apprenticeship Year"]
["This is the year of the apprenticeship"]
["N. Funding Scale Value "]
["This field is pre-populated based on the year of the apprentice"]
["Refer to the Grant Opportunity Guidelines for the funding cap values"]
["O. Enter number of semesters"]
["Select the number of semesters for the apprentice from the drop down menu"]
["P. Application Total Quote Cost"]
["This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application"]
[]
[]
["6. On the Job Training Supervision (OJT) - SMEs Only"]
["On the Job Training Supervision is a supervision training activity."]
["Instructions to fill in the costs are as follows:"]
["A. Not for use"]
["B. Project Activity "]
["The Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                  "]
["The activity will be for on the job training supervision support where the supervisor provides training to an appropriately qualified company employee"]
["It is very important these names are identical to enable reconciliation between the application and the budget. "]
["Training must only be technical in nature and cannot be class room based   "]
["C. Primary Capability Stream"]
["Indicate for each project activity if the specific training relates to naval ship building by responding Yes or No."]
["D Employee Name "]
["Enter the name of each employee receiving training from the supervisor. If more than one employee is being supervised against the activity, enter a new line for each employee and repeat the supervision support activity details"]
["It is expected you might have multiple staff undertaking a training activity, you must enter a new line for each person against the activity name"]
["For example if 3 staff are undertaking 6. OJT CNC Machine Use, you will repeat this project activity name 3 times so there is an entry for each employee"]
["As the eligibility of staff is determined at application stage, staff names will need to be included in the budget. "]
["E. Employee Title"]
["Enter title of the employee undertaking the training"]
["F. Not for use"]
["G. Is the Employee an Apprentice?"]
["Using the drop down menu select yes or no against the question asked if the employee is an apprentice"]
["If the employee is an apprentice all costs will be ineligible"]
["H. Not for use"]
["I. Supervisor's Name"]
["Enter name of each appropriately qualified company employee(s) who will undertaking the supervision"]
["J. Supervisor's Title"]
["Enter title of each appropriately qualified company employee(s) who will be responsible for supervising"]
["K. Start Date"]
["Enter date supervision will start"]
["L. End Date"]
["Enter date supervision will end"]
["M. Enter number of hours"]
["Select the number of hours of supervisor training"]
["This number of hours must be the same as those in the proposed training plan/syllabus"]
["N. Funding Value"]
["Enter the hourly rate of support being requested"]
["O. Not for use"]
["P. Application Total Quote Cost"]
["This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application"]
[]
[]
["Travel Costs Tab"]
["Details for travel costs are entered in the tab \"Travel Costs\" - the calculated totals should be copied into the activity table which the travel relates to"]
["Eligible air transportation is limited to economy class fare"]
["Where non-economy class air transport is used, evidence will be needed to show the cost of an economy airfare at the time of travel"]
["Accommodation is capped at $200 per night (excluding GST)"]
["Enter travel into the appropriate section of the tab. Travel can be either:"]
["- Domestic travel"]
["- International travel"]
["Entering Travel Costs Budget Details"]
["Information on travel costs are entered in the Travel Costs tab."]
["Go to the correct section for Domestic or International travel."]
["Instructions to fill the travel costs are as follows:"]
["A. Project Activity "]
["The Project Activity name must be identical to the Project Activity name in the budget tab. This will be same as the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                  "]
["B. Travel Details"]
["Fill in the journey details including places of departure and arrival. If there are multiple trips at different dates, list each one on a new line"]
["C. Name"]
["It is important that you include details of travel for each person. There may be multiple staff members being trained against a project activity. You will have a new line for each person travelling"]
["If the person travelling is the training provider details of their travel must also be included"]
["D. Company"]
["Enter organisation of traveller"]
["If the person travelling is internal, you will list the name of the applicant company"]
["If the person travelling is external, you will list the name of the training company"]
["E. Departure Place "]
["Enter the location you will be departing"]
["F. Destination Place"]
["Enter the location you will be arriving"]
["G. Arrival Date"]
["Enter the date you will be arriving at your destination"]
["H. Departure Date"]
["Enter the date you will be departing your destination"]
["I. Cost of Airfare Economy"]
["Enter the estimated cost of your return airfare for the journey. You will be required to provide a quote for travel"]
["Airfares reimbursement are only for facilitating training purposes. If the traveller has a stopover on the way to the training destination, the cost of the airfare will not be reimbursed and will be considered at the company's cost                                                                                                                              If the traveller does not return directly after training is completed, the return airfare will not be reimbursed and will be considered at the company's cost"]
["J. Cost of Accommodation"]
["Enter the estimated cost for accommodation. You will be required to provide a quote for accommodation"]
["This will be based on the number of nights multiplied by the accommodation cost (accommodation is capped at $200/night)"]
["Any accommodation outside of the training period will not be included"]
["K. Number of Nights' Accommodation"]
["Enter the number of nights of accommodation needed for training"]
["L. Total Quote Costs"]
["This is a calculated field that will add up the travel costs nominated for the individual relating to that journey and training activity"]
[]
[]
["Eligible Expenditure Guidance"]
["The Grant Opportunity Guidelines include eligible expenditure guidance. These requirements are listed below:"]
["1.       The eligible grant value is at least $5,000"]
["2.       The total grant value is no more than $500,000 in a three year period"]
["3.       Project expenditure can only be incurred between the project start and end date. A project cannot commence, should the application be successful, until a grant agreement is executed with the Commonwealth"]
["4.       Project costs are directly related to the project"]
["5.       Quote costs match the application budget"]
["6.       Costs exclude GST"]
["7.       Domestic travel is limited to the reasonable cost of airfares and accommodation required to conduct agreed project activities in Australia  "]
["8.       Overseas travel is limited to the reasonable cost of accommodation and airfares to receive approved training, where a comparable alternative is not available in Australia "]
["9.       Airfares are economy only   "]
["10.   Accommodation is capped at $200 night GST exclusive  "]
["11.   Staff training costs and OJT training fees include TAFE, University, online training courses, training instructors (internal and external) and OEM training"]

{"sheet":"SADI Attachment Guide","index":1,"n_rows":56,"n_cols":1,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Skilling Australia's Defence Industry (SADI) Attachments Guidance "]
[]
["There are a number of attachments which must be provided with your application."]
["To help you with that process, these are listed below:"]
[]
["Technical and trade skills training (TTS)"]
["1.       Internal training - detailed course outline/syllabus"]
["2.     Internal training - itemised quote/costing for proposed training activity"]
["3.       Internal training - instructor’s qualification documentation evidence to deliver the training"]
["4.       Internal training  - evidence of hourly wage for qualified instructor"]
["5.       External training - itemised quote for proposed training activity"]
["6.     External training - evidence training is being delivered by a registered training organisation, a tertiary education provider, an accredited training provider or a professional or industry association"]
["7.     Itemised quotes for domestic and international travel (airfares and accommodation only).  No third party agency websites.  Itemised snips and screenshots from airline or accommodation owned website may be acceptable.  Domestic travel quotes should clearly show GST charges"]
["8.     Where non-economy class air transport is used, evidence showing the cost of an economy airfare at the time of travel"]
["9.     Evidence applicant is a defence industry association (if applicable)"]
[]
["Human resources training (HRT)"]
["1.       Internal training - detailed course outline/syllabus "]
["2.       Internal training - itemised quote/costing for proposed training activity"]
["3.       Internal training - instructor’s qualification documentation evidence to deliver the training"]
["4.       Internal training  - evidence of hourly wage for qualified instructor "]
["5.     External training - itemised quote for proposed training activity"]
["6.     External training - evidence training is being delivered by a registered training organisation, a tertiary education provider, an accredited training provider or a professional or industry association"]
["7.     Itemised quotes for domestic and international travel (airfares and accommodation only).  No third party agency websites.  Itemised snips and screenshots from airline or accommodation owned website may be acceptable.  Domestic travel quotes should clearly show GST charges"]
["8.       Where non-economy class air transport is used, evidence showing the cost of an economy airfare at the time of travel"]
["9.     Evidence applicant is a defence industry association (if applicable)"]
[]
["Micro-credentials courses (MCC)"]
["1.       Internal training - detailed course outline/syllabus"]
["2.       Internal Training - itemised quote/costing for proposed training activity"]
["3.       Internal training - instructor’s qualification documentation evidence to deliver the training"]
["4.       Internal training  - Payslips for all participants including apprentices and supervisors - on submission of the application, and for the first and last payroll of each reporting period"]
["5.       External training - itemised quote for proposed training activity"]
["6.     External training - evidence training is being delivered by a registered training organisation, a tertiary education provider, an accredited training provider or a professional or industry association"]
["7.     Itemised quotes for domestic and international travel (airfares and accommodation only).  No third party agency websites.  Itemised snips and screenshots from airline or accommodation owned website may be acceptable.  Domestic travel quotes should clearly show GST charges"]
["8.      Where non-economy class air transport is used, evidence showing the cost of an economy airfare at the time of travel"]
["9.     Evidence applicant is a defence industry association (if applicable)"]
[]
["Original Equipment Manufacturer (OEM)"]
["1.       Training plan/syllabus "]
["2.       Itemised quote for proposed training activity"]
["3.       Evidence  training costs are not incorporated in product purchase price"]
["4.       Correspondence training is not available in Australia"]
["5.     Itemised quotes for domestic and international travel (airfares and accommodation only).  No third party agency websites.  Itemised snips and screenshots from airline or accommodation owned website may be acceptable.  Domestic travel quotes should clearly show GST charges"]
["6.       Where non-economy class air transport is used, evidence showing the cost of an economy airfare at the time of travel"]
[]
["Apprenticeship Supervision Support (ASS)"]
["1.       Apprenticeship Training Plan for each apprentice, issued by the tertiary education provider"]
["2.       Evidence that the employee carrying out the supervision support is a suitably qualified and experienced"]
["3.       Payslips for all participants including apprentices and supervisors - on submission of the application, and for the first and last payroll of each reporting period"]
["4.       Academic transcripts for all apprentices for the duration of the project, included with each report submission"]
[]
["On the job training supervision (OJT)"]
["1.         Training plan/syllabus"]
["2.         Evidence that the employee carrying out the training is a suitably qualified and experienced"]
["3.      Payslips for all participants including participants and supervisors - on submission of the application, and for the first and last payroll of each reporting period"]

{"sheet":"1. TTS","index":2,"n_rows":101,"n_cols":38,"rows_kept":101,"cut":false,"hidden":false,"merged":[[3,4,3,5],[28,1,28,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[14,7,14,8],[5,3,5,4],[13,1,13,8],[5,6,5,7],[29,35,29,37],[29,16,29,17],[30,8,30,12],[30,1,30,7],[30,21,30,28],[30,31,30,34],[30,18,30,20],[30,29,30,30],[29,18,29,20],[29,21,29,34]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the estimated total cost for each Project milestone in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"1. Technical and Trade Skills Training (TTS)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,null,null,"Training Support Activities",null,null,null,null,"Travel","Application \nTotal Quote \nCost (exc GST)",null,"Application Comments","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  \nYou cannot move funds to other items without SADI approval’",null,null,null,null,null,null,null,"Travel Costs\n\nComplete details in Travel Costs Tab and enter amount paid, below",null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,"Eligible Expenditure\nexc GST","Certificate Received","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" \n(which exactly matches \"Project milestones\")\nTraining is restricted to staff only","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No"," Participant's Name\n\nEnter the staff member's name for each company employee who will be receiving training. \n\nIf you have more than one employee undertaking the same Project Activity, a separate line must be entered for each employee with all details completed  \n                                                                                                                                                              ","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training\n","Company\n\nTo be completed by defence industry associations only\n\nEnter the name of the company that will be receiving  training. The company must be a member of your Association    ","Type of Provider\n\nIndicate if training will be delivered by an internal or external instructor.                       Select from drop down menu                                                                          \n           ","Provider Name\n\nEnter training provider's name.                                                   If internal provider selected, complete the name of the instructor and title","Training Quote Cost \nexc GST\n\nEnter the training cost. This should match the provided quote(s).","Training Material Quote Costs exc GST\n\nEnter quote costs for material needed for training","Text Books                      Quote Costs \nexc GST\n\nEnter quote costs for mandatory course text books for training","External Venue Hire Quote Costs                                        exc GST\n\nEnter quote costs if an external venue is needed for training delivery ","Audio Visual Equipment Hire Quote Costs \nexc GST\n\nEnter quote costs if audio visual equipment hire is needed for training  ","Airfares and Accommodation Quote Costs exc GST\n\nComplete details in Travel Costs tab and insert the total here, for this participant","This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.                                                                                        Complete the name and title of the staff member  undertaking training                                                               \n","Provider Name\n\nThese details should match your application budget information.\nComplete training provider's name.                                                  \nIf internal provider selected, complete the name of the instructor and title","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Training Cost $AUD \nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Training Material                  exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Text Books                   exc GST\n\nThis should not exceed approved quote(s) and must not include GST","External Venue Hire                           exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Audio Visual Equipment Hire\nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Invoice Number\n\nEnter invoice number for external providers. You must have a line for every invoice. This must be entered against the correct activity","Invoice Date\n\n Enter date of invoice for external provider. If internal provider complete period of training","Domestic Travel\nExc GST\n\nAirfares and accommodation claim\n\nThis should not exceed approved quote(s) and must not include GST","Overseas Travel\n\nAirfares and accommodation claim\n\nConvert to AUD\n\nThis should not exceed approved quote(s) and must not include GST","Claim Total in AUD exc GST\n\nThis is a calculated field","Date Paid\n\nComplete the date each invoice has been paid","Payment Reference\n\nEnter the invoice payment reference","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to the approved activity, participant or cost, please reference below."," - Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -"]
[null,"1. TTS Graduate Certificate in Project Management","No","Bob Brown","Apprentice",null,"External ","Curtin University ","exc GST",100,100,100,100,100,100,null,null,null,{"$f":"IF((B33)=\"\",\" \",(B33))","v":"1. TTS Graduate Certificate in Project Management"},{"$f":"IF((D33)=\"\",\" \",(D33))","v":"Bob Brown"},{"$f":"IF((H33)=\"\",\" \",(H33))","v":"Curtin University "},"One",100,100,100,100,100,"A123","2020-08-01",2000,3000,2000,"2020-08-30","NAB 438921"]
[null,"Project Activity","Yes/No","Participant's Name","Job Title","Company","Type of Provider","Provider Name","Training $","Training Materials $","Text Books $","Venue Hire $","AV Hire $","Travel $","Total $","Column15","Comments","Eligible $","Project Activity ","Participant's Name ","Provider Name ","Report Number","Actual Training $","Actual Materials $","Actual Text Books $","Actual Venue $","Actual AV Hire $","Invoice Number","Invoice Date","Domestic Travel","Overseas Travel","Claim Total","Date Paid","Payment Ref","Approved Changes","Eligible Actual $","Yes /  No","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B35)=\"\",\" \",(B35))","v":"Begin entry from this line"},{"$f":"IF((D35)=\"\",\" \",(D35))","v":" "},{"$f":"IF((H35)=\"\",\" \",(H35))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W35:AA35,AD35:AE35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W36:AA36,AD36:AE36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B98)=\"\",\" \",(B98))","v":" "},{"$f":"IF((D98)=\"\",\" \",(D98))","v":" "},{"$f":"IF((H98)=\"\",\" \",(H98))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W98:AA98,AD98:AE98)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table546[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,null,{"$f":"IF((D100)=\"\",\" \",(D100))","v":" "},{"$f":"IF((H100)=\"\",\" \",(H100))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W100:AA100,AD100:AE100)","v":0}]
[null,null,"TOTALS",null,null,null,null,null,{"$f":"SUM(Table546[Training $])","v":0},{"$f":"SUM(Table546[Training Materials $])","v":0},{"$f":"SUM(Table546[Text Books $])","v":0},{"$f":"SUM(Table546[Venue Hire $])","v":0},{"$f":"SUM(Table546[AV Hire $])","v":0},{"$f":"SUM(Table546[Travel $])","v":0},{"$f":"SUM(Table546[Total $])","v":0},null,null,{"$f":"SUM(Table546[Eligible $])","v":0},null,null,null,null,{"$f":"SUM(Table546[Actual Training $])","v":0},{"$f":"SUM(Table546[Actual Materials $])","v":0},{"$f":"SUM(Table546[Actual Text Books $])","v":0},{"$f":"SUM(Table546[Actual Venue $])","v":0},{"$f":"SUM(Table546[Actual AV Hire $])","v":0},null,null,{"$f":"SUM(Table546[Domestic Travel])","v":0},{"$f":"SUM(Table546[Domestic Travel])","v":0},{"$f":"SUBTOTAL(109,Table546[Claim Total])","v":0},null,null,null,{"$f":"SUM(Table546[Eligible Actual $])","v":0}]

{"sheet":"2. HRT","index":3,"n_rows":100,"n_cols":38,"rows_kept":100,"cut":false,"hidden":false,"merged":[[3,4,3,5],[5,3,5,4],[5,6,5,7],[13,1,13,8],[14,7,14,8],[28,1,28,8],[29,1,29,14],[25,1,25,8],[26,1,26,8],[27,1,27,8],[29,35,29,37],[29,16,29,17],[30,8,30,12],[30,1,30,7],[30,31,30,34],[30,18,30,20],[30,21,30,28],[30,29,30,30],[29,21,29,34],[29,18,29,20]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"'1. TTS'!$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the estimated total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"2. Human Resources Training and Skills Development Practices (HRT)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,null,null,"Training Support Activities",null,null,null,null,"Travel","Application \nTotal Quote \nCost (exc GST)",null,"Application Comments","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,null,null,null,null,"Travel Costs\n\nComplete details in Travel Costs Tab and enter amount paid, below",null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. \nYou cannot move funds to other items without SADI approval",null,null,null,"Eligible Expenditure\nexc GST","Certificate Received","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" \n(which exactly matches \"Project milestones\")\nTraining is restricted to staff only","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No"," Participant's Name\n\nEnter the staff member's name for each company employee who will be receiving training. \n\nIf you have more than one employee undertaking the same Project Activity, a separate line must be entered for each employee with all details completed.                                                    \n                                                                                            ","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training\n","Company\n\nTo be completed by defence industry associations only\n\nEnter the name of the company that will be receiving  training. The company must be a member of your Association    ","Type of Provider\n\nIndicate if training will be delivered by an internal or external instructor.                       Select from drop down menu                                                                          \n           ","Provider Name\n\nEnter training provider's name.\nIf internal provider selected, complete the name of the instructor and title","Training Quote Cost \nExc GST\n\nEnter the training cost. This should match the provided quote(s).","Training Material Quote Costs exc GST\n\nEnter quote costs for material needed for training","Text Books                      Quote Costs \nexc GST\n\nEnter quote costs for mandatory course text books for training","External Venue Hire Quote Costs                                        exc GST\n\nEnter quote costs if an external venue is needed for training delivery ","Audio Visual Equipment Hire Quote Costs \nexc GST\n\nEnter quote costs if audio visual equipment hire is needed for training  ","Airfares and Accommodation Quote Costs exc GST\n\nComplete details in Travel Costs tab and insert the total here, for this participant","This is a calculated field for all costs entered. The value must match the Milestone cost in your application (this also will be the same as the Project activity cost)",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.                                                                                        Complete the name and title of the staff member  undertaking training                                                               \n","Provider  Name\n\nThese details should match your application budget information.\nComplete training provider's name.                                                  \n If internal provider selected, complete the name of the instructor and title","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Actual Training Cost\nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Training Material                  exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Text Books                   exc GST\n\nThis should not exceed approved quote(s) and must not include GST","External Venue Hire                           exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Audio Visual \nEquipment Hire\nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Invoice Number\n\nEnter invoice number for external providers. You must have a line for every invoice. This must be entered against the correct activity","Invoice Date\n\n Enter date of invoice for external provider. If internal provider complete period of training","Domestic Travel\nExc GST\n\nAirfares and accommodation claim\n\nThis should not exceed approved quote(s) and must not include GST","Overseas Travel\nconverted to AUD\n\nAirfares and accommodation claim\n\nThis should not exceed approved quote(s) and must not include GST","Claim Total in AUD \nexc GST\n\nEnter the total period costs being claimed for the activity. All costs must be invoiced and paid to be eligible. Any costs incurred prior to the project start date are not eligible","Date Paid\n\nComplete the date each invoice has been paid","Payment Reference\n\nEnter the invoice payment reference","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to the approved activity, participant or cost, please reference below.","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -"]
[null,"2. HRT Change Management Planning","Yes","John Jones","Floor Supervisor",null,"External","HR Speciality Pty Ltd",100,100,100,100,100,100,10000,null,null,null,"2. HRT Change Management Planning","John Jones, Floor Supervisor","HR Speciality Pty Ltd","One",100,100,100,100,100,"TAFE8y9op","2020-06-19",2000,3000,5000,"2020-08-30","Receipt 890"]
[null,"Project Activity","Yes / No","Participant's Name","Job Title","Company","Type of Provider","Provider Name","Training $","Training Materials $","Text Books $","Venue Hire $","AV Hire $","Travel $","Total $","Column15","Comments","Eligible $","Project Activity ","Participant's Name ","Provider Name ","Report Number","Actual Training $","Actual Materials $","Actual Text Books $","Actual Venue $","Actual AV Hire $","Invoice Number","Invoice Date","Domestic Travel","Overseas Travel","Claim Total","Date Paid","Payment Ref","Approved Changes","Eligible Actual $","Yes /  No","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B35)=\"\",\" \",(B35))","v":"Begin entry from this line"},{"$f":"IF((D35)=\"\",\" \",(D35))","v":" "},{"$f":"IF((H35)=\"\",\" \",(H35))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W35:AA35,AD35:AE35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B36)=\"\",\" \",(B36))","v":" "},{"$f":"IF((D36)=\"\",\" \",(D36))","v":" "},{"$f":"IF((H36)=\"\",\" \",(H36))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W36:AA36,AD36:AE36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B37)=\"\",\" \",(B37))","v":" "},{"$f":"IF((D37)=\"\",\" \",(D37))","v":" "},{"$f":"IF((H37)=\"\",\" \",(H37))","v":" "},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B58)=\"\",\" \",(B58))","v":" "},{"$f":"IF((D58)=\"\",\" \",(D58))","v":" "},{"$f":"IF((H58)=\"\",\" \",(H58))","v":" "},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B59)=\"\",\" \",(B59))","v":" "},{"$f":"IF((D59)=\"\",\" \",(D59))","v":" "},{"$f":"IF((H59)=\"\",\" \",(H59))","v":" "},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W67:AA67,AD67:AE67)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B97)=\"\",\" \",(B97))","v":" "},{"$f":"IF((D97)=\"\",\" \",(D97))","v":" "},{"$f":"IF((H97)=\"\",\" \",(H97))","v":" "},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(Table11[Training $])","v":0},{"$f":"SUM(Table11[Training Materials $])","v":0},{"$f":"SUM(Table11[Text Books $])","v":0},{"$f":"SUM(Table11[Venue Hire $])","v":0},{"$f":"SUM(Table11[AV Hire $])","v":0},{"$f":"SUM(Table11[Travel $])","v":0},{"$f":"SUM(Table11[Total $])","v":0},null,null,{"$f":"SUM(Table11[Eligible $])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,Table11[Actual Training $])","v":0},{"$f":"SUM(Table11[Actual Materials $])","v":0},{"$f":"SUM(Table11[Actual Text Books $])","v":0},{"$f":"SUM(Table11[Actual Venue $])","v":0},{"$f":"SUM(Table11[Actual AV Hire $])","v":0},null,null,{"$f":"SUM(Table11[Domestic Travel])","v":0},{"$f":"SUM(Table11[Overseas Travel])","v":0},{"$f":"SUM(Table11[Claim Total])","v":0},null,null,null,{"$f":"SUM(Table11[Eligible Actual $])","v":0}]

{"sheet":"3. MCC","index":4,"n_rows":100,"n_cols":58,"rows_kept":100,"cut":false,"hidden":false,"merged":[[31,26,31,28],[30,7,30,13],[30,1,30,6],[30,34,30,40],[30,41,30,45],[30,14,30,21],[30,48,30,51],[30,30,30,32],[29,30,29,32],[30,46,30,47],[29,33,29,51],[29,52,29,57],[29,25,29,29],[3,4,3,5],[5,3,5,4],[5,6,5,7],[13,1,13,8],[14,7,14,8],[28,1,28,8],[25,1,25,8],[26,1,26,8],[27,1,27,8]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"'1. TTS'!$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the estimated total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,null,null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"3. Micro-credentials Courses (MCC)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,null,"External Training Support Activities\nOnly complete this section if you are applying for external training courses",null,null,null,null,null,null,"Internal Training Support Activities\nOnly complete this section if you are applying for external training courses",null,null,null,null,null,null,null,"Travel","Application \nTotal Quote \nCost (exc GST)",null,"Application Comments","Supervisor Qualifications Received\n(internal training)","Training Plan Received\n(internal training)","Payslips Received\n(internal training)","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null,null,"External Training Support Activities\nOnly complete this section if you are claiming for approved external training courses.\n Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,null,null,null,"Internal Training Support Activities\nOnly complete this section if you are claiming for approved internal training.\n Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,null,"Travel Costs\n\nComplete details in Travel Costs Tab and enter amount paid, below",null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity.\nYou cannot move funds to other items without SADI approval’",null,null,null,"Eligible Expenditure\nexc GST","(Internal Courses) \nLog Book Provided","(Internal Courses) \nSupervisor Payslips Provided","(Internal Courses) \nParticipant Payslips Provided","(External Courses) Certificate Provided","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" \n(which exactly matches \"Project milestones\")\nTraining is restricted to staff only","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No"," Participant's Name\n\nEnter the staff member's name for each company employee who will be receiving training. \n\nIf you have more than one employee undertaking the same Project Activity, a separate line must be entered for each employee with all details completed                                                                                                                                                             ","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training\n","Company\n\nTo be completed by defence industry associations only\n\nEnter the name of the company that will be receiving  training. The company must be a member of your Association    ","Type of Provider\n\nIndicate if training will be delivered by an internal or external instructor.                       Select from drop down menu                                                                          \n           ","Provider Name\n\nEnter training provider's name.                                                   \nIf internal provider selected, complete the name of the instructor and title","Training Quote Cost\nExc GST\n\nEnter the training cost. This should match the provided quote(s).","Training Material Quote Costs exc GST\n\nEnter quote costs for material needed for training","Text Books                      Quote Costs \nexc GST\n\nEnter quote costs for mandatory course text books for training","External Venue Hire Quote Costs                                        exc GST\n\nEnter quote costs if an external venue is needed for training delivery ","Audio Visual Equipment Hire Quote Costs \nexc GST\n\nEnter quote costs if audio visual equipment hire is needed for training  ","Total Cost\n\n\nThis is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application","Is the Employee an Apprentice?\n\nSelect from drop down menu. Funding is not available for apprentices  ","Supervisor's Name\n\nEnter name of each appropriately qualified company employee(s) who will be supervising","Supervisor's Job Title\n\nEnter title of each appropriately qualified company employee(s) who will be supervising","Start Date\n\nEnter date supervision will start","End Date\n\nEnter date supervision will end","Number of Hours \n\nEnter number of hours of supervision for activity","Hourly Rate\n\nSupport may be funded at up to $80/hour.                          Enter the hourly rate of support being requested","Total Cost\n\n\nThis is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application","Airfares and Accommodation Quote Costs exc GST\n\nComplete details in Travel Costs tab and insert the total here, for this participant","\n\nThis is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -",null,null,"- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.                                                                                        Complete the name and title of the staff member  undertaking training                                                               \n","Provider Name\n\nThese details should match your application budget information.\nComplete training provider's name.                                                  \nIf internal provider selected, complete the name of the instructor and title","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Actual Training Cost\nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Training Material                  exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Text Books                   exc GST\n\nThis should not exceed approved quote(s) and must not include GST","External Venue Hire                           exc GST\n\nThis should not exceed approved quote(s) and must not include GST","Audio Visual \nEquipment Hire\nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Invoice Number\n\nYou must have a line for every invoice. This must be entered against the correct activity","Invoice Date\n\n Enter date of invoice.","Start Date\n\nEnter date supervision started for this claim","End Date\n\nEnter date supervision end date for this claim","Number of Hours \n\nEnter number of hours of supervision for this claim","Hourly Rate\n\nUse approved rate","Total Claim\n\nThis is a calculated field for all costs entered.\n\n","Domestic Travel\nExc GST\n\nAirfares and accommodation claim\n\nThis should not exceed approved quote(s) and must not include GST","Overseas Travel\n\nAirfares and accommodation claim\n\nThis should not exceed approved quote(s) and must not include GST\n\nConvert to AUD","Claim Total in AUD \nexc GST\n\nThis is a calculated field for all costs entered.\n\nAll costs must be invoiced and paid to be eligible. Any costs incurred prior to the project start date are not eligible.","Date Paid\n\nComplete the date each invoice has been paid","Payment Reference\n\nEnter the invoice payment reference","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to the approved activity, participant or cost, please reference below."," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"]
[null,"3. MCC Cyber Defence Capability Skilling","Yes","Helen Hill","Systems Engineer",null,"External","IT Specialists Pty Ltd",50,50,50,50,null,null,null,null,null,null,null,null,50,null,3000,5000,null,null,null,null,null,null,"2. HRT Change Management Planning","John Jones, Floor Supervisor","HR Speciality Pty Ltd","One",100,100,100,100,100,"TAFE8y9op","2020-08-14",null,null,null,null,null,2000,3000,5000,"2020-08-30","Receipt 890"]
[null,"Project Activity","Yes / No","Participant's Name","Job Title","Company","Type of Provider","Provider Name","Training $","Training Materials $","Text Books $","Venue Hire $","AV Hire $","External Total","Yes / No ","Supervisor's Name","Supervisor Job Title","Start Date","End Date","Total Hours","Hourly Rate","Internal Total","Travel $","Total $","Column15","Comments","Supervisor Quals","Column1","Payslips Rec","Eligible $","Project Activity ","Participant's Name ","Provider Name ","Report Number","Actual Training $","Actual Materials $","Actual Text Books $","Actual Venue $","Actual AV Hire $","Invoice Number","Invoice Date","Claim Start Date","Claim End Date","Total Hours Claimed","Hourly Rate  ","Total   ","Domestic Travel","Overseas Travel","Claim Total","Date Paid","Payment Ref","Approved Changes","Eligible Actual $","Yes /  No","Yes  / No    ","Yes / No  ","Yes /  No ","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I35, J35, K35, L35, M35)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(T35*U35)","v":0},null,{"$f":"SUM(N35,V35,W35)","v":0},null,null,null,null,null,null,{"$f":"IF((B35)=\"\",\" \",(B35))","v":"Begin entry from this line"},{"$f":"IF((D35)=\"\",\" \",(D35))","v":" "},{"$f":"IF((H35)=\"\",\" \",(H35))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR35*AS35)","v":0},null,null,{"$f":"SUM(AI35:AM35, AT35:AV35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(AI36:AM36, AT36:AV36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,{"$f":"SUM(N67,V67,W67)","v":0},null,null,null,null,null,null,{"$f":"IF((B67)=\"\",\" \",(B67))","v":" "},{"$f":"IF((D67)=\"\",\" \",(D67))","v":" "},{"$f":"IF((H67)=\"\",\" \",(H67))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR67*AS67)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I99, J99, K99, L99, M99)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(T99*U99)","v":0},null,{"$f":"SUM(N99,V99,W99)","v":0},null,null,null,null,null,null,"If further rows are required you must contact SADI@industry.gov.au for an extended form."," "," ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR99*AS99)","v":0},null,null,0]
[null,null,"TOTALS",null,null,null,null,null,{"$f":"SUM(Table12[Training $])","v":0},{"$f":"SUM(Table12[Training Materials $])","v":0},{"$f":"SUM(Table12[Text Books $])","v":0},{"$f":"SUM(Table12[Venue Hire $])","v":0},null,{"$f":"SUM(Table12[External Total])","v":0},null,null,null,null,null,{"$f":"SUBTOTAL(109,Table12[Total Hours])","v":0},null,{"$f":"SUBTOTAL(109,Table12[Internal Total])","v":0},{"$f":"SUBTOTAL(109,Table12[Travel $])","v":0},{"$f":"SUM(Table12[Hourly Rate])","v":0},{"$f":"SUM(Table12[Total $])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,Table12[Eligible $])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,Table12[Actual Training $])","v":0},{"$f":"SUM(Table12[Actual Training $])","v":0},{"$f":"SUM(Table12[Actual Materials $])","v":0},{"$f":"SUM(Table12[Actual Text Books $])","v":0},{"$f":"SUM(Table12[Actual Venue $])","v":0},{"$f":"SUM(Table12[Actual AV Hire $])","v":0},null,null,null,{"$f":"SUBTOTAL(109,Table12[Total Hours Claimed])","v":0},null,{"$f":"SUBTOTAL(109,Table12[[Total   ]])","v":0},{"$f":"SUBTOTAL(109,Table12[Domestic Travel])","v":0},{"$f":"SUM(Table12[Domestic Travel])","v":0},{"$f":"SUM(Table12[Overseas Travel])","v":0},{"$f":"SUBTOTAL(109,Table12[Claim Total])","v":0},null,null,{"$f":"SUBTOTAL(109,Table12[Eligible Actual $])","v":0}]

{"sheet":"4. OEM","index":5,"n_rows":99,"n_cols":36,"rows_kept":99,"cut":false,"hidden":false,"merged":[[27,1,27,6],[31,16,31,18],[30,16,30,18],[25,1,25,6],[26,1,26,6],[28,1,28,6],[3,4,3,5],[5,3,5,4],[5,6,5,7],[13,1,13,8],[14,7,14,8],[30,33,30,35],[30,14,30,15],[31,1,31,5],[31,6,31,10],[30,1,30,12],[31,19,31,26],[31,29,31,32],[31,27,31,28],[30,19,30,32]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"'1. TTS'!$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the estimated total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[]
[null,"SME USE ONLY (not to be used by Defence Industry Associations)",null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"4. Original Equipment Manufacturer Training (OEM)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,"Training Support Activities",null,null,null,null,"Travel","Application \nTotal Quote \nCost (exc GST)",null,"Application Comments","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. \nYou cannot move funds to other items without SADI approval  ",null,null,null,null,null,null,null,"Travel Costs\n\nComplete details in Travel Costs Tab and enter amount paid, below",null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,"Eligible Expenditure\nexc GST","Certificate Received","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                       Training is restricted to staff only","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No","Participant's Name\n\nEnter the staff member's name for each company employee who will be receiving training. \n\nIf you have more than one employee undertaking the same Project Activity, a separate line must be entered for each employee with all details completed                                                                                                                                                              ","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training\n","Provider Name\n\nEnter training provider's name","Training Quote Cost\nexc GST\n\nEnter the training cost. This should match the provided quote(s).","Training Material Quote Costs exc GST\n\nEnter quote costs for material needed for training      ","Text Books                      Quote Costs \nexc GST\n\nEnter quote costs for mandatory course text books for training","External Venue Hire Quote Costs                                        exc GST\n\nEnter quote costs if an external venue is needed for training delivery","Audio Visual Equipment Hire Quote Costs \nexc GST\n\nEnter quote costs if audio visual equipment hire is needed for training","Airfares and Accommodation Quote Costs exc GST\n\nComplete details in Travel Costs tab and insert the total here, for this participant","This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.                                                                                        Complete the name and title of the staff member  undertaking training                                                               \n","Provider Name\n\nThese details should match your application budget information.\nComplete training provider's name.                                                  \nIf internal provider selected, complete the name of the instructor and title","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Actual Training Cost $AUD \nexc GST\n\nThis should not exceed approved quote(s) and must not include GST","Training Material                  exc GST\n\n\nThis should not exceed approved quote(s) and must not include GST","Text Books                   exc GST\n\n\nThis should not exceed approved quote(s) and must not include GST","External Venue Hire                           exc GST\n\n\nThis should not exceed approved quote(s) and must not include GST","Audio Visual Equipment Hire  exc GST\n\n\nThis should not exceed approved quote(s) and must not include GST","Invoice Number\n\nEnter invoice number for external providers. You must have a line for every invoice. This must be entered against the correct activity","Invoice Date\n\n Enter date of invoice for external provider. If internal provider complete period of training","Domestic Travel\nExc GST\n\n\nThis should not exceed approved quote(s) and must not include GST","Overseas Travel\n\nAirfares and accommodation claim\n\nConvert to AUD\n\nThis should not exceed approved quote(s) and must not include GST\n","Claim Total in AUD \nexc GST\n\nThis is a calculated field for all costs entered.\n\nAll costs must be invoiced and paid to be eligible. Any costs incurred prior to the project start date are not eligible.","Date Paid\n\nComplete the date each invoice has been paid","Payment Reference\n\nEnter the invoice payment reference","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to \nthe approved activity, participant or cost, please reference below."," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"]
[null,"4. OEM ANZAC Class OEM Gearbox","No","Steve Smith","Apprentice","Gear Suppliers Pty Ltd",50,50,50,50,50,3000,5000,null,null,null,"4. OEM ANZAC Class OEM Gearbox","Steve Smith, Apprentice","Gearbox Suppliers Pty Ltd","One",50,50,50,50,50,"GB2020-177","2020-08-10",1000,2000,2500,"2020-08-30","NAB956"]
[null,"Project Activity","Yes/No","Participant's Name","Job Title","Provider Name","Training $","Materials $","Text Books $","Venue Hire $","AV Hire $","Travel $","Total $","Column15","Comments","Eligible $","Project Activity ","Participant's Name ","Provider Name ","Report Number","Actual Training $","Actual Materials $","Actual Text Books $","Actual Venue $","Actual AV Hire $","Invoice Number","Invoice Date","Domestic Travel","Overseas Travel","Claim Total","Date Paid","Payment Ref","Approved changes","Eligible Actual $","Yes /  No","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B36)=\"\",\" \",(B36))","v":"Begin entry from this line"},{"$f":"IF((D36)=\"\",\" \",(D36))","v":" "},{"$f":"IF((E36)=\"\",\" \",(E36))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U36:Y36,AB36:AC36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,{"$f":"IF((B68)=\"\",\" \",(B68))","v":" "},{"$f":"IF((D68)=\"\",\" \",(D68))","v":" "}," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null," "," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table1[[#This Row],[Training $]:[Travel $]])","v":0},null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"TOTALS",null,null,null,{"$f":"SUM(Table1[Training $])","v":0},{"$f":"SUM(Table1[Materials $])","v":0},{"$f":"SUM(Table1[Text Books $])","v":0},{"$f":"SUM(Table1[Venue Hire $])","v":0},{"$f":"SUM(Table1[AV Hire $])","v":0},{"$f":"SUM(Table1[Travel $])","v":0},{"$f":"SUM(Table1[Total $])","v":0},null,null,{"$f":"SUM(Table1[Eligible $])","v":0},null,null,null,null,null,{"$f":"SUM(Table1[Actual Materials $])","v":0},{"$f":"SUM(Table1[Actual Text Books $])","v":0},{"$f":"SUM(Table1[Actual Venue $])","v":0},{"$f":"SUM(Table1[Actual AV Hire $])","v":0},null,null,{"$f":"SUM(Table1[Domestic Travel])","v":0},{"$f":"SUM(Table1[Domestic Travel])","v":0},{"$f":"SUBTOTAL(109,Table1[Claim Total])","v":0},null,null,null,{"$f":"SUM(Table1[Eligible Actual $])","v":0}]

{"sheet":"5. ASS","index":6,"n_rows":97,"n_cols":38,"rows_kept":97,"cut":false,"hidden":false,"merged":[[30,34,30,37],[31,26,31,33],[30,26,30,33],[31,1,31,13],[31,23,31,25],[30,23,30,25],[30,16,30,22],[30,1,30,14],[3,4,3,5],[5,3,5,4],[5,6,5,7],[13,1,13,8],[14,7,14,8]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"'1. TTS'!$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the estimated total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[]
[null,"SME USE ONLY (not to be used by Defence Industry Associations)",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,null,null,null,null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"5. Apprenticeship Supervision Support (ASS)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,null,null,null,null,null,null,null,null,"Application \nTotal Cost \n(exc GST)",null,"Application Comments","Supervisor Qualifications Received","Apprentice Training Plan Received","Training Plan Start Date","Supervisor Payslips Received","Participant Payslips Received","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null,"Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null,null,null,null,null,null,"Eligible Expenditure\nexc GST","Pay Slips Received\n(Supervisor and Apprentice)","Academic Transcript Received","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                        Enter details on the skilling qualification the supervision will support","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No","Participant's Name\n\nEnter apprentice's name. \nEnter a new line for each apprentice and a new line for any additional apprenticeship years being applied for.","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training","Is the Employee an Apprentice?\n\nSelect from drop down menu. Funding is only available for apprentices                                                                                     ","% Time on Defence Projects\n\nEnter % time apprentice spends on Defence projects","Supervisor's Name\n\nEnter name of each appropriately qualified company employee(s) who will be supervising","Supervisor's Job Title\n\nEnter title of each appropriately qualified company employee(s) who will be supervising","Start Date\n\nEnter date supervision will start","End Date\n\nEnter date supervision will end","Apprenticeship Year\n\nEnter year of apprentice. Select from drop down menu","Funding Scale Value\n\nYear one = $4,000 per semester                                                                                                                                                                                                                                                                                                                                   Year two = $3,000 per semester                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Year three = $2,000 per semester                                                                                                                                                                                                                                                                                                                                                       Year four = $1,000 per semester","Number of Semesters\n\nEnter number of semesters.                            Select from drop down menu","\n\nThe value must match the milestone cost (this also will be the same as the activity cost) in your application",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.\nComplete the name of the staff member undertaking training                                                               \n","Supervisor's Name\n\nThese details should match your application budget information.\nComplete the name of the qualified company employee(s) who undertook supervision","Start Date\n\nEnter start date of supervision in the period","End Date\n\nEnter end date of supervision in the period","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Apprenticeship Year\n\nEnter year of apprentice. Select from drop down menu","Funding Scale Value\n\nYear one = $4,000 per semester                                                                                                                                                                                                                                                                                                                                   Year two = $3,000 per semester                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Year three = $2,000 per semester                                                                                                                                                                                                                                                                                                                                                       Year four = $1,000 per semester","Number of Semesters\n\nEnter number of semesters.                         Select from drop down menu","Claim Total\nexc GST\n\nThis is a calculated field for all costs entered.\n\nAll costs must be invoiced and paid to be eligible. Any costs incurred prior to the project start date are not eligible.","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to \nthe approved activity, participant or cost, please reference below.","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","- Business Grants Hub Use Only -"]
[null,"5. ASS Engineering Certificate III","No","Ann Apple","Apprentice","Yes",1,"David Davidson","Assembly Manager ","2021-01-01","2021-12-31","First",4000,2,8000,null,null,null,null,null,null,null,8000,"5. ASS Engineering Certificate III","Ann Apple","David Davidson","2021-01-01","31/6/2021","Two","Fourth","                          $1,000",1,1000]
[null,"Project Activity","Yes/No","Participant's Name","Job Title","Yes / No","%","Supervisor's Name","Supervisor Job Title","Start Date","End Date","Year","Funding Scale","Semesters","Total $","Eligible $","Comments","Supervisor Certs","Training Plan Received","Start Date ","Supervisor Payslips","Participant Payslips","Eligible Costs","Project Activity  ","Participant's Name  ","Supervisor's Name  ","Start ","End ","Report Number","Year ","Funding Scale  ","Semesters ","Total $ ","Approved Changes","Eligible Actual","Yes / No    ","Yes / No     ","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF((B36)=\"\",\" \",(B36))","v":"Begin entry from this line"},{"$f":"IF((D36)=\"\",\" \",(D36))","v":" "},{"$f":"IF((H36)=\"\",\" \",(H36))","v":" "},null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "},{"$f":"IF((D68)=\"\",\" \",(D68))","v":" "}," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Project Activity]]=\"\",\" \",Table52345[[#This Row],[Project Activity]])","v":" "}," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Yes / No]]=\"No\",Table52345[[#This Row],[Yes / No]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale]]*Table52345[[#This Row],[Semesters]])","v":" "},null,null,null,null,null,null,null,null,null," "," ",null,null,null,null,{"$f":"IF(Table52345[[#This Row],[Year ]]=\"Fourth\",\"$1,000\",IF(Table52345[[#This Row],[Year ]]=\"Third\",\"$2,000\",IF(Table52345[[#This Row],[Year ]]=\"Second\",\"$3,000\",IF(Table52345[[#This Row],[Year ]]=\"First\",\"$4,000\",IF(Table52345[[#This Row],[Year ]]=\"\",\"\")))))","v":""},null,{"$f":"IF(OR(Table52345[[#This Row],[Year ]]=\"First,Second,Third,Fourth\",Table52345[[#This Row],[Year ]]=\"\"),\" \",Table52345[[#This Row],[Funding Scale  ]]*Table52345[[#This Row],[Semesters ]])","v":" "}]
[null,null,"TOTALS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table52345[Total $])","v":0},null,null,null,null,null,null,null,{"$f":"SUM(Table52345[Eligible Costs])","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table52345[Total $ ])","v":0},null,{"$f":"SUM(Table52345[Eligible Actual])","v":0}]

{"sheet":"6. OJT","index":7,"n_rows":99,"n_cols":32,"rows_kept":99,"cut":false,"hidden":false,"merged":[[32,15,32,17],[3,4,3,5],[5,3,5,4],[5,6,5,7],[13,1,13,8],[14,7,14,8],[30,29,30,31],[30,14,30,18],[30,1,30,12],[31,22,31,28],[30,22,30,28],[31,1,31,3],[31,19,31,21],[30,19,30,21]]}
[]
[null,"Skilling Australia's Defence Industry Budget (SADI) -  SME's and Defence Industry Associations (DIA's)"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$O$100","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"MCC:",{"$f":"'3. MCC'!$Y$100","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$12","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$M$99","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$O$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$M$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$O$55","v":0}]
[null,"Total Grant Value Requested",{"$f":"SUM(C5:C10)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Grant Value Totals",null,"Project Reporting Period:","(Enter start and end date)","Grant Value Requested:",{"$f":"$H$8","v":0},"Eligible Expenditure to date:"]
[null,"TTS:",{"$f":"'1. TTS'!$R$101","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$101","v":0}]
[null,"HRT:",{"$f":"'2. HRT'!$R$100","v":0},null,null,null,null,"HRT:",{"$f":"'2. HRT'!$AJ$100","v":0}]
[null,"MCC:",{"$f":"'3. MCC'!$AE$100","v":0},"Initial payment",null,"Eligible Expenditure to date",{"$f":"$I$23","v":0},"MCC:",{"$f":"'3. MCC'!$BE$100","v":0}]
[null,"OEM:",{"$f":"'4. OEM'!$P$99","v":0},"Report one payment",null,"Payments Made",{"$f":"E23","v":0},"OEM:",{"$f":"'4. OEM'!$AH$99","v":0}]
[null,"ASS:",{"$f":"'5. ASS'!$W$97","v":0},"Report two payment",null,"Payment due this period",{"$f":"G18-G19","v":0},"ASS:",{"$f":"'5. ASS'!$AI$97","v":0}]
[null,"OJT:",{"$f":"'6. OJT'!$S$99","v":0},"Report three payment",null,"Funds Remaining",{"$f":"SUM(G16-G19-G20)","v":0},"OJT:",{"$f":"'6. OJT'!$AD$99","v":0}]
[null,"Travel:",{"$f":"'Travel Costs'!$R$55","v":0},"Final report payment"]
[null,"Total Eligible Grant Value",{"$f":"SUM(C16:C21)","v":0},"Total",{"$f":"SUM(E18:E22)","v":0},null,null,"Total ",{"$f":"SUM(I16:I22)","v":0}]
[]
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[]
[null,"SME USE ONLY (not to be used by Defence Industry Associations)",null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,null,null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"6. On the Job Training Supervision (OJT)\nOnly complete this section if you are applying for this grant activity type",null,null,null,null,null,null,null,null,null,null,"Application \nTotal Quote \n(Cost exc GST)",null,"Application Comments","Participant Payslip Received","Supervisor Qualifications Received","Supervisor Payslip Received","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. \nYou cannot move funds to other items without SADI approval’ ",null,null,null,null,null,null,"Eligible Expenditure\nexc GST","Pay Slips Received\n(Supervisor and Participant)","Notes"]
[null,"Project Activity\n\nThe Project Activity name must be identical to the application section \"Project activities\" (which exactly matches \"Project milestones\")                                                                                                                                                                                                                    Training must only be technical in nature and cannot be class room based       ","Primary Capability Stream\n\nIs this activity related to naval shipbuilding? \nYes/No","Participant's Name\n\nEnter staff member's name of each company employee being supervised. If more than one employee is being supervised against the activity, enter a new line for each employee and repeat the supervision support activity","Job Title\n\nEnter the staff member's job title for each employee who will be receiving training                                                                                                                                                                                                                                                                                                                                               ","Is the Employee an Apprentice?\n\nSelect from drop down menu. Funding is not available for apprentices  ","Supervisor's Name\n\nEnter name of each appropriately qualified company employee(s) who will be supervising","Supervisor's Job Title\n\nEnter title of each appropriately qualified company employee(s) who will be supervising","Start Date\n\nEnter date supervision will start","End Date\n\nEnter date supervision will end","Number of Hours \n\nEnter number of hours of supervision for activity","Hourly Rate\n\nSupport may be funded at up to $80/hour.                          Enter the hourly rate of support being requested","This is a calculated field for all costs entered. The value must match the milestone cost (this also will be the same as the activity cost) in your application",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -",null,null,"- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same activity in the Activity Schedule in your Agreement.\nFill in claim details for each activity.\nIf you have made any changes to the approved activity contact CDIC","Participant's Name\n\nThese details should match your application budget information.\nComplete the name of the staff member undertaking training                                                               \n","Supervisor's Name\n\nThese details should match your application budget information.\nComplete the name of the qualified company employee(s) who undertook supervision","Start Date\n\nEnter start date of supervision in the period","End Date\n\nEnter end date of supervision in the period","Report\n(e.g. one, two, three, final)\n\nSelect report number from the drop down menu.  Copy the claim details in the next blank line for additional claims.","Number of Hours\n\nEnter number of hours of supervision for the period.   Evidence of hours must be kept","Hourly Rate\n\nEnter the approved hourly rate","Total Claim\n\nThis is a calculated field","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to \nthe approved activity, participant or cost, please reference below."," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"," - Business Grants Hub Use Only -"]
[null,"6. OJT CNC Machine Use","Yes","Gary Green","Leading Hand","No","David Davidson","Assembly Manager","2020-07-10","2020-12-31",100,80,8000,null,null,null,null,null,null,"6. OJT CNC Machine Use","Gary Green","David Davidson","2021-01-01","31/6/2021","Two",100,80]
[null,"Project Activity","Yes/No","Participant's Name","Job Title","Yes / No","Supervisor's Name","Supervisor Job Title","Start Date","End Date","Total Hours","Hourly Rate","Total $","Semesters","Comments","Participant Payslip","Supervisor Certs","Supervisor Payslip","Eligible $","Project Activity ","Participant's Name ","Supervisor's Name ","Start Date ","End Date ","Report Number","Total Hrs","Hourly Rate  ","Total Claim","Approved Changes","Eligible $ ","Yes /  No","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K36*L36)","v":0},null,null,null,null,null,null,{"$f":"IF((B36)=\"\",\" \",(B36))","v":"Begin entry from this line"},{"$f":"IF((D36)=\"\",\" \",(D36))","v":" "},{"$f":"IF((G36)=\"\",\" \",(G36))","v":" "},null,null,null,null,null,{"$f":"SUM(Z36*AA36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF((B37)=\"\",\" \",(B37))","v":" "},{"$f":"IF((D37)=\"\",\" \",(D37))","v":" "},{"$f":"IF((G37)=\"\",\" \",(G37))","v":" "},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,{"$f":"SUM(Z68*AA68)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," ",{"$f":"IF((G81)=\"\",\" \",(G81))","v":" "},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null," "," "," ",null,null,null,null,null,0]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null," "," ",null,null,null,null,null,0]
[null,null,"TOTALS",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table523453[Total $])","v":0},null,null,null,null,null,{"$f":"SUM(Table523453[Eligible $])","v":0},null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table523453[Total Claim])","v":0},null,{"$f":"SUBTOTAL(109,Table523453[Eligible $ ])","v":0}]

{"sheet":"Travel Costs","index":8,"n_rows":55,"n_cols":32,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,30,5,31],[5,16,5,17],[5,21,5,29],[6,21,6,29],[6,1,6,10],[5,11,5,14],[6,18,6,20],[5,18,5,20],[6,11,6,14]]}
[]
[null,"By completing this form, you acknowledge that details below have been correctly entered and represent eligible costs"]
[null,"Please fill in all relevant columns listed below against each Project Activity"]
[null,"Total cost for each Project Activity must match the total cost for each Project milestone  in your application"]
[null,"The Application Total Quote Costs must equal the Total Project Costs in your application."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -",null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,"THIS SECTION IS COMPLETED FOR PROGRESS REPORTS ONLY",null,null,null,null,null,null,null,null," - Business Grants Hub Use Only -"]
[null,"Travel Costs Budget - Domestic and International Travel\nOnly complete this section if you are applying for travel",null,null,null,null,null,null,null,null,null,"Quote Costs  - in AUD\nMust be directly related to training and supported by quotes",null,null,null,null,"Application Comments","Eligible Application Costs","Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: SADI@Industry.gov.au",null,null," Your claim is limited to the approved Agreement Schedule Cost for each Project Activity. You cannot move funds to other items.  ",null,null,null,null,null,null,null,null,"Eligible Expenditure\nexc GST","Notes"]
[null,"Project Activity\n\nThe Project Activity name should be identical to the application section \"Detailed project description and key activities\" (which exactly matches \"Project milestones\")  ","Domestic  or Overseas Travel","Travel Details\n\nEnter journey details including places of departure and arrival","Participant's Name             \n                   \nEnter name of traveller","Company\n\nEnter organisation of travelling participant","Departure Airport\n\n","Destination Airport\n\n","Departure Date","Return Date","Number of Nights Accommodation","Airfare or Accommodation\n\nSelect from pull down list.  Use one line for each item quoted.  Use additional lines for each item of expenditure","Airfare or Accommodation \nin AUD Exc GST\n\nAccommodation is capped at AUD 200 per night exc GST.  Quotes should be taken directly from hotel/airline hosted websites.","Quote Currency\n(Overseas travel only)\n\nConfirm the currency used  e.g. USD, GBP","Quote Cost in AUD\nExc GST",null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -","Project Activity\n\nCosts being claimed must only be for the same Project Activity name in the Activity Schedule of your Agreement.  Fill in claim details for each Project Activity line in the application section of this budget.   ","Participant's Name\n\nThese details should match your application budget information.\nComplete the name and title of the staff member approved to travel\n","Airfare or Accommodation\n\nSelect from pull down list\nUse one line for each item quoted","Report Number\n\nSelect from pull down list","Invoice Currency\n(Overseas travel only)\n\nConfirm the currency used in the invoice/receipt provided, e.g. USD, GBP","Invoice Value in AUD \nexc GST\n\nFor O/S payment, use RBA exchange rate on the application submission date.","Invoice Number       \n\n","Invoice Date                \n","Claim Total in AUD \nexc GST\n\nSubmission of Invoice and Proof of Payment is mandatory.","Date Paid \n\nEnter date invoice paid","Payment Reference \n\nEnter payment  reference","Comments\n\nIf you have received approval from the Business Grants Hub to make changes to \nthe approved activity, participant or cost, please reference below."," - Business Grants Hub \nUse Only -"," - Business Grants Hub Use Only -"]
[null,"1. TTS JSF Engine Design Training","International","Return trip from Adelaide to Madrid","John Smith","Applicant Pty Ltd","Melbourne","Los Angeles","2020-07-20","2020-07-24",4,2000,null,"USD",2800,null,null,null,"Airfare Melbourne to Los Angeles return",null,null,"One","USD",2000,"Q8x9b3","2020-07-15",1500,"2020-07-15","Mcard1899","no other costs applicable"]
[null,"Project Activity","DOM/OS","Travel Details","Participant's Name","Company","Departure Airport","Arrival Airport","Departure Date","Return Date","Nights Accom","Air or Accom","Quote $","Currency Type","Total Quote $","Column15","Comments","Eligible $","Project Activity ","Participant's Name ","Air or Accom ","Report Number","Currency Type ","Invoice $","Invoice Number","Invoice Date","Total Claim $","Date paid","Payment Ref","Approved Changes","Eligible $ ","Notes"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null,{"$f":"IF((B11)=\"\",\" \",(B11))","v":"Begin entry from this line"},{"$f":"IF((E11)=\"\",\" \",(E11))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null,{"$f":"IF((B12)=\"\",\" \",(B12))","v":" "},{"$f":"IF((E12)=\"\",\" \",(E12))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null," "," "]
[null,"If further rows are required you must contact SADI@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Table8[[#This Row],[Quote $]])","v":0},null,null,null,null," "]
[null,"TOTALS",null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table8[Quote $])","v":0},null,{"$f":"SUBTOTAL(109,Table8[Total Quote $])","v":0},null,null,{"$f":"SUBTOTAL(109,Table8[Eligible $])","v":0},null,null,null,null,null,{"$f":"SUBTOTAL(109,Table8[Invoice $])","v":0},null,null,{"$f":"SUBTOTAL(109,Table8[Total Claim $])","v":0},null,null,null,{"$f":"SUBTOTAL(109,Table8[Eligible $ ])","v":0}]

{"sheet":"Sheet2","index":9,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["ASS"]
["First",4000]
["Second",3000]
["Third",2000]
["Fourth",1000]
[]
["ASS_1"]
[1]
[2]
[" "]
["Provider"]
[]
["External"]
["Internal"]
[]
["Report"]
["One"]
["Two"]
["Three"]
["Final"]
[]
["OJT"]
[80]
[]
["Apprentice"]
["Yes"]
["No"]
[]
[]
[]
[]
["PASSWORD",null,"CDIC"]