{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Work Instruction","Summary","New Entrants","Other Workforce","Dropdowns"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":7,"comments":4,"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":"Work Instruction","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,0,10,16],[11,0,11,16],[27,0,27,16],[17,0,17,6],[18,0,18,8],[19,0,19,5],[22,0,22,6],[0,2,0,16],[2,0,2,15],[3,0,3,15],[6,0,6,16],[7,0,7,16]]}
[null,null,"\nPrincipal Contractor Evidence Validation Spreadsheet\n\nQueensland Government Building & Construction Training Policy"]
["Summary Tab"]
["Input data into the blue cells, to automatically populate information into the other tabs. This information includes: Project name, Actual Commencement Date, Actual Completion Date, Is this an indigenous project, Contract Sum GST (Inc), Is this a major project, Contracted agreed hours and actual achieved hours (Hours from TPAS)."]
["The folder structure is a suggested recording keeping format for your reference."]
[]
["New Entrants Tab"]
["In the green table section, complete the new entrant details. This includes: Registration ID, First Name, Surname, Engaged As, Employer, Indigenous, Total hours."]
["In the grey table section, link to evidence - ensure to complete one evidence link per line. Insert more lines if required. Provide description of evidence via free text and use the drop down in column L to select the evidence type. \nRefer to the evidence guide to ensure you have the required information for the submission. The \"Other notes\" column is to provide room for free text comments if required."]
[]
["Other Workforce"]
["In the green table section, complete the Other Workforce details. This includes Registration ID (If available), First Name, Surname, Engaged As, Employer, Indigenous, Accredited hrs or Non-Accredited hours. Total hours will automatically populate.  "]
["In the grey table section, link to evidence - ensure to complete one evidence link per line. Insert more lines if required. Complete the answer to question 1 in Column K via free text. If the individual is Indigenous, questions 2 (Column L) and 3 (Column M) will automatically generate as Not Applicable. Otherwise complete these questions using free text.  Use the drop down in column N to complete the evidence type and reference the evidence guide. The \"Other notes\" column is to provide room for free text comments if required."]
[]
["Dropdowns Tab"]
["Do not make changes to this section. This is used for report data selection only. "]
[]
["Resource Links: "]
["Queensland Government Building and Construction Training Policy"]
["Guidelines for Contractors – Queensland Government Building and Construction Training Policy"]
["FAQ – Training Policy Compliance for Other Workforce Training"]
["The following documents are available content on the QGP Compliance Branch website:"]
["QGP Compliance Branch"]
["Evidence Guide – Building and Construction Training Policy"]
["Building and Construction Training Policy Evidence Management Presentation"]
["Principal Contractor Evidence Validation Spreadsheet – sample template"]
[]
["Disclaimer"]
["This document is intended as a guide only and should be used in conjunction with the Queensland Government Building and Construction Training Policy, your agency’s procurement policies and procedures, and any other relevant documents.\nThe Department of Energy and Climate disclaims all liability that may arise from the use of this document. In preparing this document, reasonable efforts have been made to use accurate and current information. It should be noted that information may have changed since the publication of this document. Where errors or inaccuracies are brought to our attention a reasonable effort will be made to correct them."]

{"sheet":"Summary","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Project Name:"]
[null,null,null,"Actual Commencement \nDate:",null,"Actual Completion Date:"]
[]
[null,null,"Is this an Indigenous project?","No"]
[null,null,{"$f":"IF(D5=\"Yes\",\"Has an IEOP been upload into TPAS?\",\"\")","v":""}]
[null,null,"Contract Sum GST (Inc)"]
[null,null,"Is this a Major Project?",{"$f":"IF(D7>=100000000,\"Yes\",\"No\")","v":"No"}]
[null,null,{"$f":"IF(D7>=100000000,\"Has a Skills Development Plan been uploaded into TPAS?\",\"\")","v":""}]
[null,null,{"$f":"IF(D7>=100000000,\"Has a Training Coordinatro been employed by the Principal Contract?\",\"\")","v":""}]
[null,null,null,"New Entrant","Other Workforce"]
[null,null,"Contract Agreed hours"]
[null,null,"Actual Achieved (Progressive Subtotal)"]
[]
[]
[null,null,"TPAS - Training Hours at the time of the audit","Percentage","Actual","Contract Agreed","Variance"]
[null,null,{"$f":"D11","v":"New Entrant"},{"$f":"IFERROR(E17/F17,0)","v":0},{"$f":"D13","v":0},{"$f":"D12","v":0},{"$f":"E17-F17","v":0}]
[null,null,{"$f":"E11","v":"Other Workforce"},{"$f":"IFERROR(E18/F18,0)","v":0},{"$f":"E13","v":0},{"$f":"E12","v":0},{"$f":"E18-F18","v":0}]
[null,null,"Total Hours",0,{"$f":"SUM(E17:E18)","v":0},{"$f":"SUM(F17:F18)","v":0},{"$f":"SUM(G17:G18)","v":0}," "]
[]
[]
[]
[]
[null,{"$f":"IF(C24=\"\",\"\",\"!\")","v":""},{"$f":"IF(D5=\"Yes\",\"Has an Indiginous Employment Opportunities Plan been uploaded into TPAS?\",\"\")","v":""}]
[null,"",{"$f":"IF(D5=\"Yes\",\"Has the IEOP been signed off by all parties in agreement that all objectives have been achieved?\",\"\")","v":""}]
[null,{"$f":"IF(C26=\"\",\"\",\"!\")","v":""},{"$f":"IF(D8=\"Yes\",\"Has the Principal Contractor Developed a skills development plan?\",\"\")","v":""}]
[null,{"$f":"IF(C27=\"\",\"\",\"!\")","v":""},{"$f":"IF(D8=\"Yes\",\"Is the training linked to occupational outcomes in applicable nationally accreditated training packages that are identified in the skills development plan?\",\"\")","v":""}]
[null,"",{"$f":"IF(D8=\"Yes\",\"Has a training coordinator been employed by the principal contractor to ensure the implementation of the skills development plan?\",\"\")","v":""}]

{"sheet":"New Entrants","index":2,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,9,4,15],[4,0,4,6],[2,1,3,2],[2,11,3,11],[10,12,10,15],[5,12,5,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[9,12,9,15]]}
[null,"Note: Columns highlighted green and grey, ",null,"are formula driven."]
[]
["Project Name:",{"$f":"Summary!C3","v":0},null,"Project Duration:",{"$f":"Summary!E3","v":"00:00:00"},{"$f":"Summary!G3","v":"00:00:00"},{"$f":"F3-E3","v":0},null,null,"Contract Agreed Hours: ",{"$f":"Summary!D12","v":0},"Actual Achieved \n(Progressive Subtotal): ",{"$f":"Summary!E17","v":0},"Hours Evidenced: ",{"$f":"Summary!#REF!","v":{"$error":"#REF!"}}]
[" ",null,null,null,"Start","Finish","Days"]
["TPAS - Record Training New Entrants",null,null,null,null,null,null,null,null,"Evidence to support training hours"]
["Reg ID","First Name","Surname","Engaged As","Employer","Indigenous","Total Hours","Intentionally left blank","Intentionally left blank","Link to Evidence \n(link one document per cell)","Description of Evidence Provided","Evidence type (Drop down - reference evidence guide)","Other Notes"]
["Input data here",null,null,null,null,null,null,null,null,null,null,"New Entrant on-site"]
[null,null,null,null,null,null,null,null,null,null,null,"New Entrant off-site"]
[null,null,null,null,null,null,null,null,null,null,null,"New Entrant Subcontractor"]

{"sheet":"Other Workforce","index":3,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,3,3],[10,14,10,15],[11,14,11,15],[12,14,12,15],[4,0,4,8],[4,9,4,15],[5,14,5,15],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15]]}
[null,"Note: Columns highlighted grey, ",null,"are formula driven."]
[]
["Project Name:",{"$f":"Summary!C3","v":0},null,null,null,"Project Duration:",{"$f":"Summary!E3","v":"00:00:00"},{"$f":"Summary!G3","v":"00:00:00"},{"$f":"H3-G3","v":0},"Contract Agreed Hours:",{"$f":"Summary!E12","v":0},"Actual Achieved (Progressive Subtotal)",{"$f":"Summary!E18","v":0},"Hours Evidenced:",{"$f":"Summary!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Start","Finish","Days"]
["TPAS - Record Training Other Workforce",null,null,null,null,null,null,null,null,"BQAU Audit"]
["Reg ID","First Name","Surname","Engaged As","Employer","Indigenous","Accred. Hrs","Non-Accred. Hrs","Total Hours","Link to Evidence  \n(link one document per cell)","1. What evidence show the worker was working on the project (timesheet/labour reports)?","2. Does the evidence show details of the training being undertaken (list details of upskilling/training and dates)? Was the training within the project duration or reasonably prior to commencement?","3. Was the training related to the Buidling and Construction Industry and did it benefit the project?","Evidence type (Drop down - reference evidence guide)","Other notes"]
["Input data here",null,null,null,null,null,null,null,{"$f":"SUM(G7:H7)","v":0},null,null,{"$f":"IF(F7=\"Aboriginal\",\"Not applicable\",IF(F7=\"Aboriginal and Torres Strait Islander\",\"Not applicable\",IF(F7=\"Torres Strait Islander\",\"Not applicable\",\"\")))","v":""},{"$f":"IF(F7=\"Aboriginal\",\"Not applicable\",IF(F7=\"Aboriginal and Torres Strait Islander\",\"Not applicable\",IF(F7=\"Torres Strait Islander\",\"Not applicable\",\"\")))","v":""},"Existing Worker - Accredited"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G8:H8)","v":0},null,null,{"$f":"IF(F8=\"Aboriginal\",\"Not applicable\",IF(F8=\"Aboriginal and Torres Strait Islander\",\"Not applicable\",IF(F8=\"Torres Strait Islander\",\"Not applicable\",\"\")))","v":""},{"$f":"IF(F8=\"Aboriginal\",\"Not applicable\",IF(F8=\"Aboriginal and Torres Strait Islander\",\"Not applicable\",IF(F8=\"Torres Strait Islander\",\"Not applicable\",\"\")))","v":""},"Existing Worker - Non-Accredited"]
[null,null,null,null,null,null,null,null,0,null,null,"","","Student"]
[null,null,null,null,null,null,null,null,0,null,null,"","","Undergraduate"]
[null,null,null,null,null,null,null,null,0,null,null,"","","Cadet"]
[null,null,null,null,null,null,null,null,0,null,null,"","","Aboriginal/Torres Strait Islander Person"]
[null,null,null,null,null,null,null,null,0,null,null,"",""]

{"sheet":"Dropdowns","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Type of Evidence"]
[null,"New Entrant on-site"]
[null,"New Entrant off-site"]
[null,"New Entrant Subcontractor"]
[]
[null,"Existing Worker - Accredited"]
[null,"Existing Worker - Non-Accredited"]
[null,"Student"]
[null,"Undergraduate"]
[null,"Cadet"]
[null,"Aboriginal/Torres Strait Islander Person"]