{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["QS-Estimates","BOQ For PR"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"QS-Estimates","index":0,"n_rows":55,"n_cols":9,"rows_kept":55,"hidden":true,"merged":[[0,0,1,1],[0,2,1,6],[2,0,2,1],[2,2,2,6],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,0,5,1],[5,2,5,6],[7,0,7,6],[49,1,49,3]]}
[null,null,"GEMMA CLUSTER"]
[]
["Project Name:",null,"Template Identifier:"]
["Project ID:",null,"Effective Date:"]
["Job Name:",null,"Review Date:"]
["Job ID:"]
[]
["Cost Estimates for Electrical Trade Qualification"]
["Item No","Description ","Unit","Duration (days) "," Number to be trained","Cost per person per day","Total Cost"]
["A","Preliminaries & General"]
[null,"Accommodation","Per night",null,1354,{"v":850,"d":"R850.00"},{"$f":"E11*F11","v":{"v":1150900,"d":"R1,150,900.00"}},535]
["B","Transport"]
[null,"Travel","Per KM",null,14220,{"v":7.85,"d":"R7.85"},{"$f":"E13*F13","v":{"v":111627,"d":"R111,627.00"}}]
["C","ARPL Process"]
[null,"ARPL pre-assessment","day",1,200,{"v":1375,"d":"R1,375.00"},{"$f":"D15*E15*F15","v":{"v":275000,"d":"R275,000.00"}}]
[null,"ARPL Skills Gap Training","day",60,200,{"v":858,"d":"R858.00"},{"$f":"D16*E16*F16","v":{"v":10296000,"d":"R10,296,000.00"}}]
[null,"Trade Test Preparations","day",20,418,{"v":858,"d":"R858.00"},{"v":7172880,"d":"R7,172,880.00"},null,{"$f":"E11-200","v":1154}]
[null,"Trade Test","day",2,418,{"v":2750,"d":"R2,750.00"},{"v":2299000,"d":"R2,299,000.00"}]
[]
["D","Phase-1 "]
[" KM  Modules","Electrician\n"]
["671101000-KM-01","Health, Safety, Quality and Legislation, NQF Level 4, 5 Credits.                               KM-01-KT01: Safety, health, environment, risk and quality principles in the workplace                         ","day",6,106,{"v":860.868,"d":"R860.87"},{"$f":"D22*E22*F22","v":{"v":547512.0480000001,"d":"R547,512.05"}},null,{"$f":"30*D22","v":180}]
["671101000-KM-02","Tools, Equipment and Materials, NQF Level 4, 8 Credits.\nKM-02-KT01: Hand tools and power tools (5%)\nKM-02-KT02: Measuring and testing instruments (50%)","day",10,106,{"v":860.868,"d":"R860.87"},{"$f":"D23*E23*F23","v":{"v":912520.0800000001,"d":"R912,520.08"}},null,{"$f":"30*D23","v":300}]
["671101000-KM-03","Electricity and Electronics, NQF Level 4, 13 Credits.\nKM-03-KT01: Fundamentals of electricity (35%)\nKM-03-KT02: Electronics (30%)\nKM-03-KT03: Electrical principles of appliances (35%)\n","day",16,106,{"v":860.868,"d":"R860.87"},{"v":1460032.128,"d":"R1,460,032.13"},null,{"$f":"30*D24","v":480}]
["671101000-KM-04","Industry Context, NQF Level 3, 2 Credits.\nKM-04-KT01: Introduction to the world of work and the electrical trade (100%)","day",3,106,{"v":860.868,"d":"R860.87"},{"v":273756.02400000003,"d":"R273,756.02"},null,90]
["671101000-KM-05","Wireways and Wiring, NQF Level 4, 11 Credits.\nKM-05-KT01: Wire ways (35%)\nKM-05-KT02: Wiring of installations (35%)                                                                                     KM-05-KT03: Earthing and bonding (30%)","day",14,106,{"v":860.868,"d":"R860.87"},{"v":1277528.112,"d":"R1,277,528.11"},null,{"$f":"30*D26","v":420}]
["671101000-KM-06","Rotating Electrical Machinery, NQF Level 4, 13 Credits.\nKM-06-KT01: Rotating electrical machinery - AC motors (35%)\nKM-06-KT02: Rotating Electrical Machinery - DC motors (35%)\nKM-06-KT03: Rotating electrical machinery - Alternators and Generators (30%)\n","day",16,106,{"v":860.868,"d":"R860.87"},{"v":1460032.128,"d":"R1,460,032.13"},null,480]
["671101000-KM-07","Electrical Supply Systems and Components, NQF Level 4, 31 Credits.\nKM-07-KT01: Concepts, theories and principles of supply Systems (20%)               KM-07-KT02: Batteries (10%)\nKM-07-KT03: Transformers (20%)\nKM-07-KT04: Types of cables and applications (20%) \nKM-07-KT05: Switchgear and control gear\t(20%) \nKM-07-KT06: Lighting systems (10%)","day",39,106,{"v":860.868,"d":"R860.87"},{"v":3558828.3120000004,"d":"R3,558,828.31"},null,1170]
["671101000-KM-08","Low Voltage Protection, NQF Level 4, 5 Credits.\nKM-08-KT01: Low voltage protection (100%)","day",6,106,{"v":860.868,"d":"R860.87"},{"v":547512.0480000001,"d":"R547,512.05"},null,180]
["671101000-KM-09","Fault Finding, NQF Level 4, 3 Credits.\nKM-09-KT01: Fault finding (5%)","day",4,106,{"v":860.868,"d":"R860.87"},{"v":365008.032,"d":"R365,008.03"},null,120]
[{"$nulls":8},0]
["E","Phase-2",{"$nulls":6},0]
["PM Modules","Electrician",{"$nulls":6},0]
["671101000-PM-01","Use hand and power tools, NQF Level 3, Credits 22.\nPM-01-PS01: Select, use and care of engineering hand tools \nPM-01-PS02: Select, use and care for power tools\nPM-01-PS03: Select, use and care for electrical measuring instruments \nPM-01-PS04: Perform soldering activities\nPM-01-PS05: Carry out basic electric arc welding in an electrical environment \nPM-01-PS06: Carry out basic gas cutting in an electrical environment","day",28,218,{"v":860.87,"d":"R860.87"},{"$f":"D34*E34*F34","v":{"v":5254750.48,"d":"R5,254,750.48"}},null,840]
["671101000-PM-02","Plan worksite set up for installing, wiring and connecting electrical equipment and control systems, NQF Level 3, Credits 5.\nPM-02-PS01: Undertake risk assessment in accordance with all statutory requirements\nPM-02-PS02: Read and interpret electrical drawings \nPM-02-PS03: Plan the worksite set-up","day",6,218,{"v":860.87,"d":"R860.87"},{"$f":"D35*E35*F35","v":{"v":1126017.96,"d":"R1,126,017.96"}},null,180]
["671101000-PM-03","Prepare worksite set up for installing, wiring and connecting electrical equipment and control systems, NQF Level 3, Credits 3.\nPM-03-PS01: Procure resources\nPM-03-PS02: Prepare and transport resources\nPM-03-PS03: Prepare work site, equipment, tools, consumables and materials","day",4,218,{"v":860.87,"d":"R860.87"},{"v":750678.64,"d":"R750,678.64"},null,120]
["671101000-PM-04","Install wireways, NQF Level 4, 5 Credits.\nPM-04-PS01: Confirm the selection and installation method of the selected wire ways.                                                                                                                                                                       PM-04-PS02: Use installation tools and equipment\nPM-04-PS03: Design and install wire ways\n","day",6,218,{"v":860.87,"d":"R860.87"},{"v":1126017.96,"d":"R1,126,017.96"},null,180]
["671101000-PM-05","Install, wire and connect electrical equipment and control systems, NQF Level 4, 38 Credits.\nPM-05-PS01: Identify hazards within the installation\nPM-05-PS02: Confirm the selection and installation method of the electrical equipment and control systems\nPM-05-PS03: Use installation tools and personal protective equipment                                   PM-05-PS04: Install equipment and control systems\nPM-05-PS05: Wire electrical equipment and control systems                                                 PM-05-PS06: Terminate and connect cables and conductors","day",48,218,{"v":860.87,"d":"R860.87"},{"v":9008143.68,"d":"R9,008,143.68"},null,1440]
["671101000-PM-06","Conduct pre-commission inspection (power off) and test new and existing installations, NQF Level 4, 5 Credits.\nPM-06-PS01: Inspect electrical equipment, control systems and installations under power off conditions\nPM-06-PS02: Test electrical equipment, control systems and installations under power off conditions","day",6,218,{"v":860.87,"d":"R860.87"},{"v":1126017.96,"d":"R1,126,017.96"},null,180]
["671101000-PM-07","Carry out commissioning tests, NQF Level 4, 13 Credits.\nPM-07-PS01: Carry out commissioning tests (with power on) on electrical installations and control systems\nPM-07-PS02: Rectify defects found on electrical installations and control systems PM-07-PS03: Report product deficiencies and rectify workmanship","day",16,218,{"v":860.87,"d":"R860.87"},{"v":3002714.56,"d":"R3,002,714.56"},null,480]
["671101000-KM-08","Fault find and repair electrical control systems and electrical installations, NQF Level 4, 22 Credits.\nPM-08-PS01: Obtain work instructions and gather drawings and documentation PM-08-PS02: Select tools and testing instruments\nPM-08-PS03: Carry out fault finding\nPM-08-PS04: Rectify faults where applicable\nPM-08-PS05: Record findings and provide feedback","day",28,218,{"v":860.87,"d":"R860.87"},{"v":5254750.48,"d":"R5,254,750.48"},null,840]
[{"$nulls":8},0]
["F","Workplace modules – To be covered by the employer",{"$nulls":6},0]
[null,"Planning and preparation process for the wiring, connection,testing, inspecting, commissioning and maintaining of electrical installations and control systems, NQF Level 4, 8 Credits.","day",10,{"$nulls":4},300]
[null,"Processes of installing, wiring and connecting of electrical equipment and control systems, NQF Level 4, 74 Credits.","day",93,{"$nulls":4},2790]
[null,"Processes of testing and inspecting of electrical equipment, control systems and installations, NQF Level 4, 15 Credits.","day",19,{"$nulls":4},570]
[null,"Processes of commissioning electrical installations and control systems,NQF Level 4, 15 Credits.","day",19,{"$nulls":4},570]
[null,"Maintenance processes for electrical installations and control systems, NQF Level 4, 44 Credits.","day",55,{"$nulls":4},1650]
[{"$nulls":8},0]
[null,"Total",{"$nulls":4},{"$f":"SUM(G11:G49)","v":{"v":58357227.632,"d":"R58,357,227.63"}},null,0]
[]
[]
[{"$nulls":8},{"$f":"SUM(I22:I52)","v":13560}]
[{"$nulls":3},{"$f":"SUM(D17:D49)","v":474}]
[{"$nulls":3},{"$f":"D54*30","v":14220}]

{"sheet":"BOQ For PR","index":1,"n_rows":77,"n_cols":8,"rows_kept":77,"merged":[[0,1,1,2],[0,3,1,7],[2,1,2,2],[2,3,2,7],[3,1,3,2],[3,3,3,7],[4,1,4,2],[4,3,4,7],[6,1,7,2],[6,3,7,7],[8,1,8,2],[8,3,8,7],[9,1,9,2],[9,3,9,7],[10,1,10,2],[10,3,10,7],[11,1,11,2],[11,3,11,7],[12,1,12,7],[63,2,63,6],[65,1,65,4]]}
[{"$nulls":3},"GEMMA CLUSTER"]
[]
[null,"Project Name:",null,"Template Identifier:"]
[null,"Project ID:",null,"Effective Date:"]
[null,"Job Name:",null,"Review Date:"]
[]
[{"$nulls":3},"GEMMA CLUSTER"]
[]
[null,"Project Name:",null,"Template Identifier:"]
[null,"Project ID:",null,"Effective Date:"]
[null,"Job Name:",null,"Review Date:"]
[null,"Job ID:"]
[null,"Electrical Trade Qualification"]
[null,"Item No","Description ","Unit","Duration (days) ","Estimated Number to be trained","Cost per person per day","Total Cost"]
[null,"A","Preliminaries & General"]
[null,"A.1","Accomodation"]
[null,null,"Phase 1- Accommodation for learners (include breakfast and dinner)","Per night",null,270,null,{"$f":"E17*F17*G17","v":0}]
[null,null,"Phase 1 - Accommodation for the technicians (include breakfast and dinner)","Per night",null,50,null,{"$f":"E18*F18*G18","v":0}]
[null,null,"Phase 2- Accommodation for learners (include breakfast and dinner)","Per night",null,180,null,{"$f":"E19*F19*G19","v":0}]
[null,null,"Phase 3 - Accommodation for learners (include breakfast and dinner)","Per night",null,90,null,0]
[null,null,"Trade Test Preparation- Accommodation  for learners (include breakfast and dinner)","Per night",null,{"$f":"110+75","v":185},null,0]
[null,null,"Trade Test Preparation- Accommodation for permanent employees (include breakfast and dinner)","Per night",null,{"$f":"200+75","v":275},null,{"$f":"E22*F22*G22","v":0}]
[null,"A.2","Lunch"]
[null,null,"Phase 1- Lunch for learners","day",null,270,null,{"$f":"E24*F24*G24","v":0}]
[null,null,"Phase 1- Lunch for learners","day",null,50,null,{"$f":"E25*F25*G25","v":0}]
[null,null,"Phase 2- Lunch for learners","day",null,180,null,{"$f":"E26*F26*G26","v":0}]
[null,null,"Phase 3- Lunch for learners","day",null,90,null,{"$f":"E27*F27*G27","v":0}]
[null,null,"Trade Test Preparation- Lunch for learners","day",null,{"$f":"110+75","v":185},null,0]
[null,null,"Trade Test Preparation- Lunch for permanent employees","day",null,{"$f":"200+75","v":275},null,{"$f":"E29*F29*G29","v":0}]
[null,"B","Transport"]
[null,null,"Phase 1-Travel for learners","Per KM",null,540,null,{"$f":"E31*F31*G31","v":0}]
[null,null,"Phase 1-Travel for learners","Per KM",null,100,null,{"$f":"E32*F32*G32","v":0}]
[null,null,"Phase 2-Travel for learners","Per KM",null,360,null,{"$f":"E33*F33*G33","v":0}]
[null,null,"Phase 3-Travel for learners","Per KM",null,270,null,0]
[null,null,"Phase Trade Test Preparation-Travel for learners","Per KM",null,550,null,{"$f":"E35*F35*G35","v":0}]
[null,"C","Phase 1 (Year1)"]
[null,null,"First Year Modules"]
[null,null,"Year 1 or Phase 1","day",null,270,null,{"$f":"E38*F38*G38","v":0}]
[null,null,"Year 1 or Phase 1","day",null,50,null,{"$f":"E39*F39*G39","v":0}]
[null,"D","Phase 2 (Year 2)"]
[null,null,"Second Year Modules"]
[null,null,"Year 2","day",null,200,null,{"$f":"E42*F42*G42","v":0}]
[null,"E","Phase 3 (Year 3)"]
[null,null,"Third Year Modules"]
[null,null,"Year 3","day",null,100,null,{"$f":"E45*F45*G45","v":0}]
[null,"F","ARPL Process"]
[null,null,"ARPL pre-assessment for permanent employees","day",null,200,null,{"$f":"E47*F47*G47","v":0}]
[null,null,"ARPL Skills Gap Training for permanent employees","day",null,200,null,{"$f":"E48*F48*G48","v":0}]
[null,"G","Trade Test"]
[null,null,"Trade Test Preparations for both permanent employees and learners","day",null,385,null,{"$f":"E50*F50*G50","v":0}]
[null,null,"Trade Test for both permanent employees and learners","day",null,385,null,{"$f":"E51*F51*G51","v":0}]
[null,"H","Trade Test Second Attempt"]
[null,null,"Trade Test Preparations for both permanent employees and learners","day",5,150,{"v":858,"d":"R858.00"}]
[null,null,"Trade Test for both permanent employees and learners","day",1,150,{"v":2750,"d":"R2,750.00"}]
[null,null,"Accomodation for both permanent employees and learners","day",5,150,{"v":977.67,"d":"R977.67"}]
[null,null,"Launch for Learners for both permanent employees and learners","day",5,150,{"v":150,"d":"R150.00"}]
[null,null,"Travelling for learnres ","Per KM",5,{"$f":"(30*75)","v":2250},{"v":7.85,"d":"R7.85"}]
[null,"H","Tool box"]
[null,null,"Tool box set",null,null,300,null,{"$f":"E59*F59*G59","v":0}]
[null,"I","CoC"]
[null,null,"Certificate of Compliance - Single Phase","day",null,100,null,{"$f":"E61*F61*G61","v":0}]
[null,null,"Certificate of Compliance - Three Phase","day",null,50,null,0]
[]
[null,null,"Total",{"$nulls":4},{"$f":"SUM(H17:H62)","v":0}]
[]
[null,"SUMMARY OF BILL OF QUANTITIES  INSTITUTIONALISED TRAINING"]
[{"$nulls":5},"Total To be trained","Price ","Total Price"]
[null,"SECTION A","Preliminaries & Generals",null,null,"-","-",{"$f":"SUM(H17:H29)","v":0}]
[null,"SECTION B","Transport",null,null,"-","-",{"$f":"SUM(H31:H35)","v":0}]
[null,"SECTION C","Phase 1",null,null,"-","-",{"$f":"SUM(H38:H39)","v":0}]
[null,"SECTION D","Phase 2",null,null,"-","-",{"$f":"SUM(H41:H42)","v":0}]
[null,"SECTION E","Phase3",null,null,"-","-",{"$f":"SUM(H44:H45)","v":0}]
[null,"SECTION F","ARPL Process",null,null,"-","-",{"$f":"SUM(H47:H48)","v":0}]
[null,"SECTION G","Trade Test",null,null,"-","-",{"$f":"SUM(H50:H51)","v":0}]
[null,"SECTION H","Toolbox set",null,null,"-","-",{"$f":"H59","v":0}]
[null,"SECTION I","Certificate of Compliance",null,null,"-","-",{"$f":"H61+H62","v":0}]
[null,null,"Total ",{"$nulls":4},{"$f":"SUM(H68:H76)","v":0}]