{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Checklist","1. TTS","2. MCC","3. OEM","4. ASS","5. OJT","DIA ONLY","Travel Costs","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":7,"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":"Checklist","index":0,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,3],[27,1,27,2],[0,0,0,3]]}
["Please refer to the guidelines if you are unsure of the requirements"]
[]
["Application Checklist"]
[]
[]
[null,"DIAs - ONLY"]
[null,"Complete Budget Template - DIA Only Tab"]
[null,"Project Risk and Management Plan for any project where total project costs exceed $100,000 or where there is more than 10 proposed participants."]
[null,"Accountant Declaration for applications for funding over $50,000."]
[]
[null,"ALL APPLICANTS"]
[null,"Itemised quotes that have been obtained in the last 12 months for proposed training activities"]
[null,"Itemised quotes that have been obtained in the last 6 months for domestic and international travel"]
[null,"Completed Budget Template"]
[null,"Project Risk and Management Plan for any project where total project costs exceed $100,000 or where there is more than 10 proposed participants."]
[null,"Accountant Declaration for applications for funding over $50,000."]
[null,"Trust Deed (if applicable)"]
[null,"You must address all assessment criteria in your application ensuring you address each sub criteria under the criterion in your responses. "]
[]
[null,"Internal Training - ONLY"]
[null,"Training plan/syllabus "]
[]
[null,"Original Equipment Manufacturer Training (OEM) - ONLY"]
[null,"Training plan/syllabus "]
[null,"Correspondence from the OEM that clearly states that the training costs were not incorporated in the product purchase price"]
[null,"Correspondence from the OEM that clearly states that the training is not available in Australia- if applying for training to be undertaken overseas"]
[]
[null,"Joint (consortia) applications"]
[null,"Letter of support from each of the project partners to include the details as per 7.2 of the guidelines."]

{"sheet":"1. TTS","index":1,"n_rows":98,"n_cols":38,"rows_kept":98,"cut":false,"hidden":false,"merged":[[3,4,3,5],[25,1,25,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[12,7,12,8],[5,3,5,4],[11,1,11,8],[5,6,5,7],[26,35,26,37],[26,16,26,17],[27,8,27,12],[27,1,27,7],[27,21,27,28],[27,31,27,34],[27,18,27,20],[27,29,27,30],[26,18,26,20],[26,21,26,34]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"$O$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$X$97","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"OEM:",{"$f":"'3. OEM'!$M$96","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$10","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$O$94","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7*$E$9","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$M$96","v":0},"Application Grant Percentage:"]
[null,"Total Project Cost",{"$f":"SUM(C5:C9)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Project 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$98","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"$AJ$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$AD$97","v":0},null,null,null,null,"MCC:",{"$f":"'2. MCC'!$BA$97","v":0}]
[null,"OEM:",{"$f":"'3. OEM'!$P$96","v":0},"Initial payment",null,null,null,"OEM:",{"$f":"'3. OEM'!$AH$96","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$X$94","v":0},"Report one payment",null,null,null,"ASS:",{"$f":"'4. ASS'!$AJ$94","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$S$96","v":0},"Report two payment",null,"Eligible Expenditure to date",{"$f":"$I$21","v":0},"OJT:",{"$f":"'5. OJT'!$AD$96","v":0}]
[null,null,null,"Report three payment",null,"Payments Made",{"$f":"E21","v":0}]
[null,null,null,"Final report payment",null,"Payment due this period",{"$f":"G18-G19","v":0}]
[null,"Total Eligible Project Value",{"$f":"SUM(C14:C20)","v":0},"Total",{"$f":"SUM(E16:E20)","v":0},"Funds Remaining",{"$f":"SUM(G14-G19-G20)","v":0},"Total ",{"$f":"SUM(I14:I20)","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: DefenceIndustryDevelopmentProgramSkilling@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 Skilling Program 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 names must match the milestones included in your application.","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                   \nexc 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 accomodation 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,"Cert in System Engineering","No","Bob Brown","Engineering Supervisor",null,"External ","Curtin University ",2000,100,100,0,100,null,{"$f":"SUM(I30:N30)","v":2300},null,null,null,{"$f":"IF((B30)=\"\",\" \",(B30))","v":"Cert in System Engineering"},{"$f":"IF((D30)=\"\",\" \",(D30))","v":"Bob Brown"},{"$f":"IF((H30)=\"\",\" \",(H30))","v":"Curtin University "},"One",2000,100,100,0,100,"DISO0099-151","2024-10-01",null,null,{"$f":"SUM(W30:AA30)","v":2300},"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((B32)=\"\",\" \",(B32))","v":"Begin entry from this line"},{"$f":"IF((D32)=\"\",\" \",(D32))","v":" "},{"$f":"IF((H32)=\"\",\" \",(H32))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W32:AA32,AD32:AE32)","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(W33:AA33,AD33:AE33)","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," ",{"$f":"IF((D59)=\"\",\" \",(D59))","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(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((B64)=\"\",\" \",(B64))","v":" "},{"$f":"IF((D64)=\"\",\" \",(D64))","v":" "},{"$f":"IF((H64)=\"\",\" \",(H64))","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(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,{"$f":"SUM(W95:AA95,AD95:AE95)","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 email:  DIDPSkilling@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," "," ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W97:AA97,AD97:AE97)","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},null,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. MCC","index":2,"n_rows":97,"n_cols":58,"rows_kept":97,"cut":false,"hidden":false,"merged":[[28,26,28,28],[27,7,27,13],[27,1,27,6],[27,34,27,40],[27,41,27,45],[27,14,27,21],[27,48,27,51],[27,30,27,32],[26,30,26,32],[27,46,27,47],[26,33,26,51],[26,52,26,57],[26,25,26,29],[25,1,25,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[3,4,3,5],[5,3,5,4],[5,6,5,7],[11,1,11,8],[12,7,12,8]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$Y$97","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"OEM:",{"$f":"'3. OEM'!$M$96","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$10","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$O$94","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7*$E$9","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$M$96","v":0},"Application Grant Percentage:"]
[null,"Total Project Cost",{"$f":"SUM(C5:C9)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Project 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$98","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$AD$97","v":0},null,null,null,null,"MCC:",{"$f":"$BA$97","v":0}]
[null,"OEM:",{"$f":"'3. OEM'!$P$96","v":0},"Initial payment",null,null,null,"OEM:",{"$f":"'3. OEM'!$AH$96","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$X$94","v":0},"Report one payment",null,null,null,"ASS:",{"$f":"'4. ASS'!$AJ$94","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$S$96","v":0},"Report two payment",null,"Eligible Expenditure to date",{"$f":"$I$21","v":0},"OJT:",{"$f":"'5. OJT'!$AD$96","v":0}]
[null,null,null,"Report three payment",null,"Payments Made",{"$f":"E21","v":0}]
[null,null,null,"Final report payment",null,"Payment due this period",{"$f":"G18-G19","v":0}]
[null,"Total Eligible Project Value",{"$f":"SUM(C14:C18,C20)","v":0},"Total",{"$f":"SUM(E16:E20)","v":0},"Funds Remaining",{"$f":"SUM(G14-G19-G20)","v":0},"Total ",{"$f":"SUM(I14:I20)","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,"2. 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: DefenceIndustryDevelopmentProgramSkilling@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 Skilling Program 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 names must match the milestones included in your application.","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 accomodation 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,"Cyber Defence Capability Skilling","Yes","Helen Hill","Systems Engineer",null,"External","IT Specialists Pty Ltd",500,0,15,0,0,{"$f":"SUM(I30:M30)","v":515},null,null,null,null,null,null,null,null,null,{"$f":"SUM(N30)","v":515},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","2024-10-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","Training Plan","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 Hourse 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(I32, J32, K32, L32, M32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(T32*U32)","v":0},null,{"$f":"SUM(N32,V32,W32)","v":0},null,null,null,null,null,null,{"$f":"IF((B32)=\"\",\" \",(B32))","v":"Begin entry from this line"},{"$f":"IF((D32)=\"\",\" \",(D32))","v":" "},{"$f":"IF((H32)=\"\",\" \",(H32))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR32*AS32)","v":0},null,null,{"$f":"SUM(AI32:AM32, AT32:AV32)","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(AI33:AM33, AT33:AV33)","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(N64,V64,W64)","v":0},null,null,null,null,null,null,{"$f":"IF((B64)=\"\",\" \",(B64))","v":" "},{"$f":"IF((D64)=\"\",\" \",(D64))","v":" "},{"$f":"IF((H64)=\"\",\" \",(H64))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR64*AS64)","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 email:  DIDPSkilling@industry.gov.au for an extended form.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I96, J96, K96, L96, M96)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(T96*U96)","v":0},null,{"$f":"SUM(N96,V96,W96)","v":0},null,null,null,null,null,null,"If further rows are required you must email:  DIDPSkilling@industry.gov.au for an extended form."," "," ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AR96*AS96)","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},null,{"$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 Hourse 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":"3. OEM","index":3,"n_rows":96,"n_cols":36,"rows_kept":96,"cut":false,"hidden":false,"merged":[[3,4,3,5],[5,3,5,4],[5,6,5,7],[11,1,11,8],[24,1,24,6],[23,1,23,6],[12,7,12,8],[25,1,25,6],[27,33,27,35],[27,14,27,15],[22,1,22,6],[28,1,28,5],[28,6,28,10],[27,1,27,12],[28,19,28,26],[28,29,28,32],[28,27,28,28],[27,19,27,32],[28,16,28,18],[27,16,27,18]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$Y$97","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"OEM:",{"$f":"'3. OEM'!$M$96","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$10","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$O$94","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7*$E$9","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$M$96","v":0},"Application Grant Percentage:"]
[null,"Total Project Cost",{"$f":"SUM(C5:C9)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Project 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$98","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$AD$97","v":0},null,null,null,null,"MCC:",{"$f":"'2. MCC'!$BA$97","v":0}]
[null,"OEM:",{"$f":"'3. OEM'!$P$96","v":0},"Initial payment",null,null,null,"OEM:",{"$f":"$AH$96","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$X$94","v":0},"Report one payment",null,null,null,"ASS:",{"$f":"'4. ASS'!$AJ$94","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$S$96","v":0},"Report two payment",null,"Eligible Expenditure to date",{"$f":"$I$21","v":0},"OJT:",{"$f":"'5. OJT'!$AD$96","v":0}]
[null,null,null,"Report three payment",null,"Payments Made",{"$f":"E21","v":0}]
[null,null,null,"Final report payment",null,"Payment due this period",{"$f":"G18-G19","v":0}]
[null,"Total Eligible Project Value",{"$f":"SUM(C14:C19)","v":0},"Total",{"$f":"SUM(E16:E20)","v":0},"Funds Remaining",{"$f":"SUM(G14-G19-G20)","v":0},"Total ",{"$f":"SUM(I14:I20)","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,"3. 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: DefenceIndustryDevelopmentProgramSkilling@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 Skilling Program 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 names must match the milestones included in your application.","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 accomodation 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",2500,0,0,0,150,3000,{"$f":"SUM(G31:L31)","v":5650},null,null,null,"4. OEM ANZAC Class OEM Gearbox","Steve Smith","Gearbox Suppliers Pty Ltd","One",2500,0,0,0,150,"JINTO-998","2025-03-10",0,3000,2500,"2025-04-10","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((B33)=\"\",\" \",(B33))","v":"Begin entry from this line"},{"$f":"IF((D33)=\"\",\" \",(D33))","v":" "},{"$f":"IF((E33)=\"\",\" \",(E33))","v":" "},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U33:Y33,AB33:AC33)","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((B65)=\"\",\" \",(B65))","v":" "},{"$f":"IF((D65)=\"\",\" \",(D65))","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 email:  DIDPSkilling@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},null,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":"4. ASS","index":4,"n_rows":94,"n_cols":39,"rows_kept":94,"cut":false,"hidden":false,"merged":[[27,35,27,38],[28,27,28,34],[27,27,27,34],[28,1,28,13],[28,24,28,26],[27,24,27,26],[27,16,27,23],[27,1,27,14],[3,4,3,5],[5,3,5,4],[5,6,5,7],[11,1,11,8],[12,7,12,8]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$Y$97","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"OEM:",{"$f":"'3. OEM'!$M$96","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$10","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$O$94","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7*$E$9","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$M$96","v":0},"Application Grant Percentage:"]
[null,"Total Project Cost",{"$f":"SUM(C5:C9)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Project 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$98","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$AD$97","v":0},null,null,null,null,"MCC:",{"$f":"'2. MCC'!$BA$97","v":0}]
[null,"OEM:",{"$f":"'3. OEM'!$P$96","v":0},"Initial payment",null,null,null,"OEM:",{"$f":"'3. OEM'!$AH$96","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$X$94","v":0},"Report one payment",null,null,null,"ASS:",{"$f":"$AJ$94","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$S$96","v":0},"Report two payment",null,"Eligible Expenditure to date",{"$f":"$I$21","v":0},"OJT:",{"$f":"'5. OJT'!$AD$96","v":0}]
[null,null,null,"Report three payment",null,"Payments Made",{"$f":"E21","v":0}]
[null,null,null,"Final report payment",null,"Payment due this period",{"$f":"G18-G19","v":0}]
[null,"Total Eligible Project Value",{"$f":"SUM(C14:C19)","v":0},"Total",{"$f":"SUM(E16:E20)","v":0},"Funds Remaining",{"$f":"SUM(G14-G19-G20)","v":0},"Total ",{"$f":"SUM(I14:I20)","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,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,"4. 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","Academic Transcript Received","Apprenticeship 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: DefenceIndustryDevelopmentProgramSkilling@industry.gov.au",null,null,"Approval must be obtained prior to making any changes to the agreed project activity, participants or provider. \nEmail: DefenceIndustryDevelopmentProgramSkilling@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 names must match the milestones included in your application.","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 -","- 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","Appentice","Yes",1,"David Davidson","Assembly Manager ","2021-01-01","2021-12-31","First",4000,2,8000,null,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","Transcript","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,null,null,{"$f":"IF((D33)=\"\",\" \",(D33))","v":" "},{"$f":"IF((H33)=\"\",\" \",(H33))","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,null,{"$f":"IF((B34)=\"\",\" \",(B34))","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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," ",{"$f":"IF((D65)=\"\",\" \",(D65))","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,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,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,{"$f":"IF((B67)=\"\",\" \",(B67))","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"IF((B82)=\"\",\" \",(B82))","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,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,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,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,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,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,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,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,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,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,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,"If further rows are required you must email:  DIDPSkilling@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,"If further rows are required you must email:  DIDPSkilling@industry.gov.au for an extended form."," "," ",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,null,null,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":"5. OJT","index":5,"n_rows":96,"n_cols":32,"rows_kept":96,"cut":false,"hidden":false,"merged":[[29,15,29,17],[27,29,27,31],[27,14,27,18],[27,1,27,12],[28,22,28,28],[27,22,27,28],[28,1,28,3],[28,19,28,21],[27,19,27,21],[12,7,12,8],[3,4,3,5],[5,3,5,4],[5,6,5,7],[11,1,11,8]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[null,"Application Totals "]
[null,"TTS:",{"$f":"'1. TTS'!$O$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$Y$97","v":0},"Applicant to Complete",null,null,"Calculated fields"]
[null,"OEM:",{"$f":"'3. OEM'!$M$96","v":0},"Application Number:",null,null,"Total Project Cost:",{"$f":"$C$10","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$O$94","v":0},"Company:",null,null,"Grant Value Requested:",{"$f":"$H$7*$E$9","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$M$96","v":0},"Application Grant Percentage:"]
[null,"Total Project Cost",{"$f":"SUM(C5:C9)","v":0}]
[]
[null," - Business Grants Hub Use Only -"]
[null,"Eligible Project 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$98","v":0},"Report Number or Final:",null,"Grant Value Awarded",null,"TTS:",{"$f":"'1. TTS'!$AJ$98","v":0}]
[null,"MCC:",{"$f":"'2. MCC'!$AD$97","v":0},null,null,null,null,"MCC:",{"$f":"'2. MCC'!$BA$97","v":0}]
[null,"OEM:",{"$f":"'3. OEM'!$P$96","v":0},"Initial payment",null,null,null,"OEM:",{"$f":"'3. OEM'!$AH$96","v":0}]
[null,"ASS:",{"$f":"'4. ASS'!$X$94","v":0},"Report one payment",null,null,null,"ASS:",{"$f":"'4. ASS'!$AJ$94","v":0}]
[null,"OJT:",{"$f":"'5. OJT'!$S$96","v":0},"Report two payment",null,"Eligible Expenditure to date",{"$f":"$I$21","v":0},"OJT:",{"$f":"$AD$96","v":0}]
[null,null,null,"Report three payment",null,"Payments Made",{"$f":"E21","v":0}]
[null,null,null,"Final report payment",null,"Payment due this period",{"$f":"G18-G19","v":0}]
[null,"Total Eligible Project Value",{"$f":"SUM(C14:C19)","v":0},"Total",{"$f":"SUM(E16:E20)","v":0},"Funds Remaining",{"$f":"SUM(G14-G19-G20)","v":0},"Total ",{"$f":"SUM(I14:I20)","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,"5. 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: DefenceIndustryDevelopmentProgramSkilling@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 Skilling Program 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 names must match the milestones included in your application.","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(K33*L33)","v":0},null,null,null,null,null,null,{"$f":"IF((B33)=\"\",\" \",(B33))","v":"Begin entry from this line"},{"$f":"IF((D33)=\"\",\" \",(D33))","v":" "},{"$f":"IF((G33)=\"\",\" \",(G33))","v":" "},null,null,null,null,null,{"$f":"SUM(Z33*AA33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF((B34)=\"\",\" \",(B34))","v":" "},{"$f":"IF((D34)=\"\",\" \",(D34))","v":" "},{"$f":"IF((G34)=\"\",\" \",(G34))","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(Z65*AA65)","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((G78)=\"\",\" \",(G78))","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 email:  DIDPSkilling@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":"DIA ONLY","index":6,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[25,16,25,17],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[25,12,26,12],[25,14,27,14],[25,5,26,9],[25,11,26,11],[25,10,27,10],[25,13,27,13],[12,3,12,4],[12,5,12,6],[11,1,11,9],[3,4,3,5],[5,4,5,6],[5,8,5,10],[6,5,6,6],[6,8,6,9],[7,5,7,6],[7,8,7,9],[8,5,8,6]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - for DIA only"]
[]
[]
[null,"Application Totals "]
[null,"Training Cost",{"$f":"$K$101","v":0},null,"DIA to Complete",null,null,null,"Calculated fields"]
[null,"Travel Cost",{"$f":"$L$101","v":0},null,"Application Number:",null,null,null,"Total Project Cost:",null,{"$f":"$N$101","v":0}]
[null,"Admin Cost",{"$f":"$M$101","v":0},null,"Company:",null,null,null,"Grant Value Requested:",null,{"$f":"$K$7*$F$9","v":0}]
[null,null,null,null,"Grant Percentage:"]
[]
[]
[null," - Business Grants Hub Use Only -"]
[null,null,null,"Reporting Period Start and End dates:",null,null,null,null,"Report Number or Final:"]
[null,null,null,null,"Initial payment"]
[null,"Eligible Project Value Total",null,null,"Report one payment"]
[null,"Total Eligible Grant Value (max 50%)",{"$f":"SUM(C15:C18)","v":0},null,"Report two payment",null,null,null,"Eligible Expenditure to date",{"$f":"$L$20","v":0}]
[null,"Grant Value Requested:",{"$f":"$K$10","v":0},null,"Report three payment",null,null,null,"Payments Made",{"$f":"F19","v":0}]
[null,"Grant Value Awarded",null,null,"Final report payment",null,null,null,"Payment due this period",{"$f":"J16-J17","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F14:F18)","v":0},null,null,"Funds Remaining",{"$f":"SUM(C18-J17-J18)","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,"Training Support Activities",null,null,null,null,"Total Training Costs","Travel","Admin","Total Project Costs","Estimated Cost per participant for training exc GST\nThis should be calculated using the the total project cost divided by the TARGET number of participants.  We understand that on occasion, charges are per group session rather than per person.",null," - Business Grants Hub Use Only -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application Comments","Eligible Costs"]
[null,"Proposed training activity","Minimum viable number of training participants","Target number of training participants","Maximum number of training participants","Training Cost exc GST\n\nEnter the training quote costs","Training Material Costs exc GST\n\nEnter quote costs for material needed for training","Text Books Costs exc 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  ",null,"Airfares and Accommodation Quote Costs exc GST\n\nComplete details in Travel Costs tab and insert the total here, for this participant","DIA Project Administration costs  exc GST\n\nMaximum 10% of total training and travel costs ",null,null,null,"- Business Grants Hub Use Only -","- Business Grants Hub Use Only -"]
[null,"Project Activity","Minimum","Target","Maximum","Training Cost","Material Cost","Text Books Cost","Venue Hire Cost","AV Hire Cost","Total Training Costs","Travel Costs","Admin Cost","Project Total","Estimated per person cost",null,"Comments","Eligible $"]
[null,"Begin entry from this line",null,null,null,null,null,null,null,null,{"$f":"SUM(F30:J30)","v":0},null,null,{"$f":"SUM(K30:M30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F31:J31)","v":0},null,null,{"$f":"SUM(K31:M31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F95:J95)","v":0},null,null,{"$f":"SUM(K95:M95)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K30:K100)","v":0},{"$f":"SUM(L30:L100)","v":0},{"$f":"SUM(M30:M100)","v":0},{"$f":"SUM(N30:N100)","v":0},null,null,null,{"$f":"SUM(R30:R100)","v":0}]

{"sheet":"Travel Costs","index":7,"n_rows":57,"n_cols":32,"rows_kept":57,"cut":false,"hidden":false,"merged":[[7,30,7,31],[7,16,7,17],[7,21,7,29],[8,21,8,29],[8,1,8,10],[7,11,7,14],[8,18,8,20],[7,18,7,20],[8,11,8,14]]}
[]
[null,"Defence Industry Development - Skilling Stream (DIDSKS) - Budget"]
[]
[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: DefenceIndustryDevelopmentProgramSkilling@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 names must match the milestones included in your application.","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. OEM Helicopter Maintenance Training","Overseas","Return trip from Adelaide to Madrid","John Smith","Applicant Pty Ltd","Adelaide","Madrid","2024-11-18","2024-11-26",5,"Airfare",2341,"AUD",2341,null,null,null,"1. OEM Helicopter Maintenance Training","John Smith","Airfare","One",null,"V","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","Nts 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, use one line for each item of either airfare or accommodation",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((B13)=\"\",\" \",(B13))","v":"Begin entry from this line, use one line for each item of either airfare or accommodation"},{"$f":"IF((E13)=\"\",\" \",(E13))","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((B14)=\"\",\" \",(B14))","v":" "},{"$f":"IF((E14)=\"\",\" \",(E14))","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 email:  DIDPSkilling@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":8,"n_rows":27,"n_cols":2,"rows_kept":27,"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"]