{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Instructions_TODO","1 General Questionnaire","2 Mandatory","3a A&B 2-way","3b Risk & Support 2-way","4a A&B 4-way","4b Risk & Support 4-way","5a A&B 6-way","5b Risk & Support 6-way","6a A&B 8-way","6b Risk & Support 8-way","7. Deviation schedule"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Instructions_TODO","index":0,"n_rows":60,"n_cols":2,"rows_kept":60,"merged":[[14,0,15,0],[17,0,18,0],[20,0,23,0]]}
["Instructions for completing this workbook"]
[]
["1) The cells where information is required to be entered is unprotected in this workbook."]
["2) Complete all Light Green shaded areas with the relevant requested information. Where the colour shading is not shown, complete the accessible cells."]
["3) All information shall be submitted in electronic format and this workbook complete in MS Excel format as requested."]
["4) Any other format for the submission of the requested electronic information will NOT be evaluated."]
["5) Reference files shall be posted under the relevant folder names indicated below for the different sections of this workbook."]
["6) Filenames shall be descriptive to indicate what information it contains."]
["7) This excel document must be provided in duplicate with the name of the duplicate being “Metering kiosks Schedules - Copy”.  "]
["8) The reference columns in all sheets are to be completed . Suppliers are required to reference supporting documentation to justify stated compliance."]
["9) Risk and Support Questionnaires must be completed for each group of items, where multiple offers are submitted for a single item, on separate sheets."]
[]
["Completing the Worksheets"]
["Sheet Description","Sheet Instructions"]
["General Questionnaire","1) Complete all questions in the space provided."]
[null,"2) Post all relevant electronic copies of documents under a folder named the same as the sheet"]
[]
[" A&B Schedules","1) Complete these worksheets with all relevant deviations."]
[null,"2) Post all relevant electronic copies of documents under a folder named the same as the sheet"]
[]
["Risk & Support Questionnaires","1) Complete these worksheets as required."]
[null,"2) Give justification and references to support the answers provided"]
[null,"3) Post all relevant electronic copies of documents under a folder named the same as the sheet"]
[null,"4) The Risk and Support Questionnaire needs to be completed for each item/product, in separate worksheets, that a tender is being submitted "]
{"$rows_empty":35}
["Pole top kiosks 2022"]

{"sheet":"1 General Questionnaire","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"merged":[[0,0,0,3]]}
["General Questionnaire"]
[null,"Question","Response","Proof to be submitted"]
["A","Tenderer"]
[1,"Company name"]
[2,"Address of Head Quarters"]
[3,"Contact details"]
[4,"Website adress"]
[5,"State Name  of Metering kiosks manufacturer (if not in-house)"]
[6,"State Name  of Metering kiosk assembly and wiring manufacturer (if not in-house)"]

{"sheet":"2 Mandatory","index":2,"n_rows":8,"n_cols":14,"rows_kept":8,"merged":[[0,0,0,5]]}
["Mandatory requirements\nPole top kiosks"]
[null,"Technical Mandatory Requirements","Response","Reference e.g. page #, section # in manual/brochure, test certificate or response","Deviation proposal","Evaluator score",{"$nulls":7},"Yes"]
[1,"Type test reports/certificates (from an accredited facility) to be provided for the pole top kiosk - (Maximum timeframe - six months after tender award).",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement",{"$nulls":8},"Devate"]
[2," Completed technical schedules in original Microsoft Excel format and copies in Acrobat format.",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement",{"$nulls":8},"No"]
[3," Pole top box construction drawings submitted with all dimensions shown.",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement"]
[4," Proof or a certificate for the MOV (surge arrester) complies with SANS 1524-1-2",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement"]
[5,"Proof or a certificate which shows that the cabling used complies with SANS 1507",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement"]
[6,"Proof or a certificate which shows that the miniature circuit breakers (MCB) used complies with VC 8036 (NRCS approved)",null,"State where the reference can be found in the tender submission","State full details of any deviation from the mandatory requirement"]

{"sheet":"3a A&B 2-way","index":3,"n_rows":38,"n_cols":17,"rows_kept":38,"merged":[[0,0,0,4]]}
["Metering kiosks: Pole top split meters 2-way\n"]
["Clause","DESCRIPTION","\nSCHEDULE A","SCHEDULE B\nYes (or Y), Partial (or P), No (or N)","Response","Evaluator response","Weight\nHeigh = 10, \nMedium = 5, \nLow = 1","Score\nYes = 3, \nPartially = 1, \nNo = 0","Total"]
[1,"General",{"$nulls":14},"Yes"]
[1.1,"Manufactured to the requirements of 240-75659760 Pole mounted service distribution boxes for split prepayment metering standard.","State compliance with the standard",null," Describe any deviation or state full compliance",null,1,{"$f":"IF(OR(F4=\"Yes\",F4=\"Y\",F4=\"YES\",F4=\"y\"),3,IF(OR(F4=\"Partial\",F4=\"P\",F4=\"PARTIAL\",F4=\"p\"),1,0))","v":0},{"$f":"H4*G4","v":0},{"$nulls":7},"Partial"]
[2,"Pole top 2-way 50A","State if tendered for",{"$nulls":4},0,{"$f":"H5*G5","v":0},{"$nulls":7},"No"]
[2.1,"Manufactured to the requirements of D-1042; Manufacturing drawings for 2-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[2.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,{"$f":"H7*G7","v":0}]
[2.3,"Electrical equipment:",{"$nulls":6},{"$f":"H8*G8","v":0}]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring ","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[2.4,"Layout  according to D-1042",{"$nulls":6},0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F16=\"Yes\",F16=\"Y\",F16=\"YES\",F16=\"y\"),3,IF(OR(F16=\"Partial\",F16=\"P\",F16=\"PARTIAL\",F16=\"p\"),1,0))","v":0},0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F17=\"Yes\",F17=\"Y\",F17=\"YES\",F17=\"y\"),3,IF(OR(F17=\"Partial\",F17=\"P\",F17=\"PARTIAL\",F17=\"p\"),1,0))","v":0},0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[3,"Pole top 2-way 120A","State if tendered for",{"$nulls":5},0]
[3.1,"Manufactured to the requirements of D-1042; Manufacturing drawings for 2-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[3.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[3.3,"Electrical equipment:",{"$nulls":5},0,{"$f":"H24*G24","v":0}]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[3.4,"Layout  according to D-1042",{"$nulls":5},0,0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[{"$nulls":6},{"$f":"SUM(G4:G36)*3","v":549},null,{"$f":"SUM(I4:I36)","v":0}]
[{"$nulls":6},"Score",{"$f":"I37/G37*100","v":0}]

{"sheet":"3b Risk & Support 2-way","index":4,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,3],[3,0,6,0],[3,4,6,4],[3,5,6,5],[7,0,8,0],[9,0,15,0],[10,4,15,4],[10,5,15,5],[16,0,20,0],[17,4,20,4],[17,5,20,5],[22,5,24,5],[25,0,31,0],[26,4,31,4],[26,5,31,5],[32,0,34,0],[33,4,34,4],[33,5,34,5]]}
["Risk and Support Questionnaire"]
[null,"Question","Response","Reference/ Justification","Scoring"]
[]
[1,"Installed base/time that the product has been installed",{"$nulls":3},"1. Existing contract with Eskom for this range of metering pole top kiosks = 25\n2. Existing contract with Eskom for part of the range or with other municipalities = 20\n3. Existing contract for other panels not part of this range = 15\n4. New entry to market = 15\n5. No previous customers for metering pole top kiosks = 5\n6. No references = 5\n7. Some fields left open or no meaningful information provided = -5 for each item\n8. Nothing entered = 0\n"]
[null,"a.     Supplier to state the date of first production of similar metering pole top kiosks"]
[null,"b.     State the customer(s) that you have delivered to or that are still in progress during the past five (5) years. Provide documentation on proof of orders."]
[null,"c.     Provide customers references, quantities and contract values of the above.\nProvide documentation on proof of orders."]
[2,"Deviations from standard"]
[null,"a.     Deviation schedules within the A&B technical schedules for all items being offered to be completed",{"$nulls":3},"1. None = 25\n2. Deviations found 15\n3. Nothing listed = 0\n"]
[3,"Ability to deliver"]
[null,"a.     Briefly describe the nature of your resources in the Republic of South Africa e.g. workshop facilities, test equipment, etc\nProvide documentation / brochures to proof your response.",{"$nulls":3},"1. Adequate facilities = 25\n2. Not adequate = 15\n3. Guaranteed lead times > 8 weeks = - 5\n4. Guaranteed lead times > 12 weeks = -10\n5. Number of metering pole top kiosks per month < 8000 = -5\n6. Number of metering pole top kiosks per month < 5000 = -10\n7. Number of metering pole top kiosks per month < 2500= - 15\n8. Number of metering pole top kiosks currently in production = -5 for none\n9. Some fields left open or no meaningful information provided = -5 for each item\n10. Nothing entered = 0\n"]
[null,"b.     Briefly describe the sizes and capacities of your design, production and testing facilities.\nProvide documentation / brochures to proof your response."]
[null,"c.     State the guaranteed lead times for the manufacture and delivery of metering pole top kiosks"]
[null,"d.     State the number of metering pole top kiosks that can be produced per month with the Tenderer’s current capability.\nProvide documentation / brochures to proof your response."]
[null,"e.     State how it will implicate your manufacturing operations if the number of metering pole top kiosks are increased above the normal delivery number."]
[null,"f.     List and describe the number of metering pole top kiosks that are currently in manufacturing progress and / or planned to start through the year versus the number of technical staff directly involved with the production of metering pole top kiosks."]
[4,"Historical performance"]
[null,"a.     Provide the original and actual delivery dates of those metering pole top kiosks listed in point 1 above.",{"$nulls":3},"1. Previous experience with manufacturing metering pole top kiosks = 25\n2. No experience = 15\n3. Late deliveries = -5\n4. No references of similar projects = -5\n5. No references from customers = -5\n6. Some fields left open or no meaningful information provided = -5 for each item\n7. Nothing entered = 0\n"]
[null,"b.     Where applicable provide the major reasons for delivery delays for those metering pole top kiosks that were delivered more than six (6) months behind the original delivery schedule"]
[null,"c.     If not already detailed in your answers to the above questions, state what experience you have had with the different types of metering pole top kiosks.\nProvide details of orders delivered of these kiosks."]
[null,"d.     Provide details of any similar projects that have been undertaken by the Tenderer and references from relevant customers.  "]
[5,"Link between supplier / manufacturer and sub-contractor"]
[null,"a.     State what functions during the manufacturing are sub-contracted?",{"$nulls":3},"1. No work subcontracted = 30\n2. Work subcontracted and details provided = 30\n3. Work subcontracted and no details stated = 15\n4. Subcontractor has experience less than 2 years = 5\n5. No subcontractor experience stated = -5\n6. No quality controls stated for subcontractor = -5\n7. Some fields left open or no meaningful information provided = -10 for each item.\n8. Nothing entered = 0\n"]
[null,"b.     State how long has each sub-contractor being doing the sub-contracted work?"]
[null,"c.     State what quality controls are in place to guarantee work from the sub-contractors?"]
[6,"Maintenance and testing"]
[null,"a.     Provide details on the companies staff complement dedicated to the following:",{"$nulls":3},"1. Adequate staff = 50\n2. Not adequate staff = 25\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"i. Sales "]
[null,"ii. Technical support "]
[null,"iii. Maintenance "]
[null,"iv. Kiosk testing "]
[null,"iv. Quality testing "]
[7,"Spares holding"]
[null,"a.     Describe the recommended metering pole top kiosks spares holdings with respect to Eskom’s geographical locations and scheme availability requirements.",{"$nulls":3},"1. Spares holding listed = 20\n2. Limited spares holding = 10\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"b.     Describe your policy on availability of spare parts and expansion parts for a period of ten years subsequent to the expiry of the supply contract."]
[{"$nulls":4},{"$f":"(E4+E9+E11+E18)*0.6+(E23+E27+E34)*0.4","v":0}]

{"sheet":"4a A&B 4-way","index":5,"n_rows":38,"n_cols":17,"rows_kept":38,"merged":[[0,0,0,4]]}
["Metering kiosks: Pole top split meters 4-way\n"]
["Clause","DESCRIPTION","\nSCHEDULE A","SCHEDULE B\nYes (or Y), Partial (or P), No (or N)","Response","Evaluator response","Weight\nHeigh = 10, \nMedium = 5, \nLow = 1","Score\nYes = 3, \nPartially = 1, \nNo = 0","Total"]
[1,"General",{"$nulls":14},"Yes"]
[1.1,"Manufactured to the requirements of 240-75659760 Pole mounted service distribution boxes for split prepayment metering standard.","State compliance with the standard",null," Describe any deviation or state full compliance",null,1,{"$f":"IF(OR(F4=\"Yes\",F4=\"Y\",F4=\"YES\",F4=\"y\"),3,IF(OR(F4=\"Partial\",F4=\"P\",F4=\"PARTIAL\",F4=\"p\"),1,0))","v":0},{"$f":"H4*G4","v":0},{"$nulls":7},"Partial"]
[2,"Pole top 4-way 50A","State if tendered for",{"$nulls":4},0,0,{"$nulls":7},"No"]
[2.1,"Manufactured to the requirements of D-1043; Manufacturing drawings for 4-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[2.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[2.3,"Electrical equipment:",{"$nulls":6},0]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring ","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[2.4,"Layout  according to D-1043",{"$nulls":6},0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F16=\"Yes\",F16=\"Y\",F16=\"YES\",F16=\"y\"),3,IF(OR(F16=\"Partial\",F16=\"P\",F16=\"PARTIAL\",F16=\"p\"),1,0))","v":0},0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F17=\"Yes\",F17=\"Y\",F17=\"YES\",F17=\"y\"),3,IF(OR(F17=\"Partial\",F17=\"P\",F17=\"PARTIAL\",F17=\"p\"),1,0))","v":0},0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[3,"Pole top 4-way 120A","State if tendered for",{"$nulls":5},0]
[3.1,"Manufactured to the requirements of D-1043; Manufacturing drawings for 4-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[3.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[3.3,"Electrical equipment:",{"$nulls":5},0,0]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[3.4,"Layout  according to D-1043",{"$nulls":5},0,0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[{"$nulls":6},{"$f":"SUM(G4:G36)*3","v":549},null,{"$f":"SUM(I4:I36)","v":0}]
[{"$nulls":6},"Score",{"$f":"I37/G37*100","v":0}]

{"sheet":"4b Risk & Support 4-way","index":6,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,3],[3,0,6,0],[3,4,6,4],[3,5,6,5],[7,0,8,0],[9,0,15,0],[10,4,15,4],[10,5,15,5],[16,0,20,0],[17,4,20,4],[17,5,20,5],[22,5,24,5],[25,0,31,0],[26,4,31,4],[26,5,31,5],[32,0,34,0],[33,4,34,4],[33,5,34,5]]}
["Risk and Support Questionnaire"]
[null,"Question","Response","Reference/ Justification","Scoring"]
[]
[1,"Installed base/time that the product has been installed",{"$nulls":3},"1. Existing contract with Eskom for this range of metering pole top kiosks = 25\n2. Existing contract with Eskom for part of the range or with other municipalities = 20\n3. Existing contract for other panels not part of this range = 15\n4. New entry to market = 15\n5. No previous customers for metering pole top kiosks = 5\n6. No references = 5\n7. Some fields left open or no meaningful information provided = -5 for each item\n8. Nothing entered = 0\n"]
[null,"a.     Supplier to state the date of first production of similar metering pole top kiosks"]
[null,"b.     State the customer(s) that you have delivered to or that are still in progress during the past five (5) years. Provide documentation on proof of orders."]
[null,"c.     Provide customers references, quantities and contract values of the above.\nProvide documentation on proof of orders."]
[2,"Deviations from standard"]
[null,"a.     Deviation schedules within the A&B technical schedules for all items being offered to be completed",{"$nulls":3},"1. None = 25\n2. Deviations found 15\n3. Nothing listed = 0\n"]
[3,"Ability to deliver"]
[null,"a.     Briefly describe the nature of your resources in the Republic of South Africa e.g. workshop facilities, test equipment, etc\nProvide documentation / brochures to proof your response.",{"$nulls":3},"1. Adequate facilities = 25\n2. Not adequate = 15\n3. Guaranteed lead times > 8 weeks = - 5\n4. Guaranteed lead times > 12 weeks = -10\n5. Number of metering pole top kiosks per month < 8000 = -5\n6. Number of metering pole top kiosks per month < 5000 = -10\n7. Number of metering pole top kiosks per month < 2500= - 15\n8. Number of metering pole top kiosks currently in production = -5 for none\n9. Some fields left open or no meaningful information provided = -5 for each item\n10. Nothing entered = 0\n"]
[null,"b.     Briefly describe the sizes and capacities of your design, production and testing facilities.\nProvide documentation / brochures to proof your response."]
[null,"c.     State the guaranteed lead times for the manufacture and delivery of metering pole top kiosks"]
[null,"d.     State the number of metering pole top kiosks that can be produced per month with the Tenderer’s current capability.\nProvide documentation / brochures to proof your response."]
[null,"e.     State how it will implicate your manufacturing operations if the number of metering pole top kiosks are increased above the normal delivery number."]
[null,"f.     List and describe the number of metering pole top kiosks that are currently in manufacturing progress and / or planned to start through the year versus the number of technical staff directly involved with the production of metering pole top kiosks."]
[4,"Historical performance"]
[null,"a.     Provide the original and actual delivery dates of those metering pole top kiosks listed in point 1 above.",{"$nulls":3},"1. Previous experience with manufacturing metering pole top kiosks = 25\n2. No experience = 15\n3. Late deliveries = -5\n4. No references of similar projects = -5\n5. No references from customers = -5\n6. Some fields left open or no meaningful information provided = -5 for each item\n7. Nothing entered = 0\n"]
[null,"b.     Where applicable provide the major reasons for delivery delays for those metering pole top kiosks that were delivered more than six (6) months behind the original delivery schedule"]
[null,"c.     If not already detailed in your answers to the above questions, state what experience you have had with the different types of metering pole top kiosks.\nProvide details of orders delivered of these kiosks."]
[null,"d.     Provide details of any similar projects that have been undertaken by the Tenderer and references from relevant customers.  "]
[5,"Link between supplier / manufacturer and sub-contractor"]
[null,"a.     State what functions during the manufacturing are sub-contracted?",{"$nulls":3},"1. No work subcontracted = 30\n2. Work subcontracted and details provided = 30\n3. Work subcontracted and no details stated = 15\n4. Subcontractor has experience less than 2 years = 5\n5. No subcontractor experience stated = -5\n6. No quality controls stated for subcontractor = -5\n7. Some fields left open or no meaningful information provided = -10 for each item.\n8. Nothing entered = 0\n"]
[null,"b.     State how long has each sub-contractor being doing the sub-contracted work?"]
[null,"c.     State what quality controls are in place to guarantee work from the sub-contractors?"]
[6,"Maintenance and testing"]
[null,"a.     Provide details on the companies staff complement dedicated to the following:",{"$nulls":3},"1. Adequate staff = 50\n2. Not adequate staff = 25\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"i. Sales "]
[null,"ii. Technical support "]
[null,"iii. Maintenance "]
[null,"iv. Kiosk testing "]
[null,"iv. Quality testing "]
[7,"Spares holding"]
[null,"a.     Describe the recommended metering pole top kiosks spares holdings with respect to Eskom’s geographical locations and scheme availability requirements.",{"$nulls":3},"1. Spares holding listed = 20\n2. Limited spares holding = 10\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"b.     Describe your policy on availability of spare parts and expansion parts for a period of ten years subsequent to the expiry of the supply contract."]
[{"$nulls":4},{"$f":"(E4+E9+E11+E18)*0.6+(E23+E27+E34)*0.4","v":0}]

{"sheet":"5a A&B 6-way","index":7,"n_rows":38,"n_cols":17,"rows_kept":38,"merged":[[0,0,0,4]]}
["Metering kiosks: Pole top split meters 6-way\n"]
["Clause","DESCRIPTION","\nSCHEDULE A","SCHEDULE B\nYes (or Y), Partial (or P), No (or N)","Response","Evaluator response","Weight\nHeigh = 10, \nMedium = 5, \nLow = 1","Score\nYes = 3, \nPartially = 1, \nNo = 0","Total"]
[1,"General",{"$nulls":14},"Yes"]
[1.1,"Manufactured to the requirements of 240-75659760 Pole mounted service distribution boxes for split prepayment metering standard.","State compliance with the standard",null," Describe any deviation or state full compliance",null,1,{"$f":"IF(OR(F4=\"Yes\",F4=\"Y\",F4=\"YES\",F4=\"y\"),3,IF(OR(F4=\"Partial\",F4=\"P\",F4=\"PARTIAL\",F4=\"p\"),1,0))","v":0},{"$f":"H4*G4","v":0},{"$nulls":7},"Partial"]
[2,"Pole top 6-way 50A","State if tendered for",{"$nulls":4},0,0,{"$nulls":7},"No"]
[2.1,"Manufactured to the requirements of D-1044; Manufacturing drawings for 6-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[2.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[2.3,"Electrical equipment:",{"$nulls":6},0]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring ","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[2.4,"Layout  according to D-1044",{"$nulls":6},0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F16=\"Yes\",F16=\"Y\",F16=\"YES\",F16=\"y\"),3,IF(OR(F16=\"Partial\",F16=\"P\",F16=\"PARTIAL\",F16=\"p\"),1,0))","v":0},0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F17=\"Yes\",F17=\"Y\",F17=\"YES\",F17=\"y\"),3,IF(OR(F17=\"Partial\",F17=\"P\",F17=\"PARTIAL\",F17=\"p\"),1,0))","v":0},0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[3,"Pole top 6-way 120A","State if tendered for",{"$nulls":5},0]
[3.1,"Manufactured to the requirements of D-1044; Manufacturing drawings for 6-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[3.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[3.3,"Electrical equipment:",{"$nulls":5},0,0]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[3.4,"Layout  according to D-1042",{"$nulls":5},0,0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[{"$nulls":6},{"$f":"SUM(G4:G36)*3","v":549},null,{"$f":"SUM(I4:I36)","v":0}]
[{"$nulls":6},"Score",{"$f":"I37/G37*100","v":0}]

{"sheet":"5b Risk & Support 6-way","index":8,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,3],[3,0,6,0],[3,4,6,4],[3,5,6,5],[7,0,8,0],[9,0,15,0],[10,4,15,4],[10,5,15,5],[16,0,20,0],[17,4,20,4],[17,5,20,5],[22,5,24,5],[25,0,31,0],[26,4,31,4],[26,5,31,5],[32,0,34,0],[33,4,34,4],[33,5,34,5]]}
["Risk and Support Questionnaire"]
[null,"Question","Response","Reference/ Justification","Scoring"]
[]
[1,"Installed base/time that the product has been installed",{"$nulls":3},"1. Existing contract with Eskom for this range of metering pole top kiosks = 25\n2. Existing contract with Eskom for part of the range or with other municipalities = 20\n3. Existing contract for other panels not part of this range = 15\n4. New entry to market = 15\n5. No previous customers for metering pole top kiosks = 5\n6. No references = 5\n7. Some fields left open or no meaningful information provided = -5 for each item\n8. Nothing entered = 0\n"]
[null,"a.     Supplier to state the date of first production of similar metering pole top kiosks"]
[null,"b.     State the customer(s) that you have delivered to or that are still in progress during the past five (5) years. Provide documentation on proof of orders."]
[null,"c.     Provide customers references, quantities and contract values of the above.\nProvide documentation on proof of orders."]
[2,"Deviations from standard"]
[null,"a.     Deviation schedules within the A&B technical schedules for all items being offered to be completed",{"$nulls":3},"1. None = 25\n2. Deviations found 15\n3. Nothing listed = 0\n"]
[3,"Ability to deliver"]
[null,"a.     Briefly describe the nature of your resources in the Republic of South Africa e.g. workshop facilities, test equipment, etc\nProvide documentation / brochures to proof your response.",{"$nulls":3},"1. Adequate facilities = 25\n2. Not adequate = 15\n3. Guaranteed lead times > 8 weeks = - 5\n4. Guaranteed lead times > 12 weeks = -10\n5. Number of metering pole top kiosks per month < 1000 = -5\n6. Number of metering pole top kiosks per month < 600 = -10\n7. Number of metering pole top kiosks per month <300= - 15\n8. Number of metering pole top kiosks currently in production = -5 for none\n9. Some fields left open or no meaningful information provided = -5 for each item\n10. Nothing entered = 0\n"]
[null,"b.     Briefly describe the sizes and capacities of your design, production and testing facilities.\nProvide documentation / brochures to proof your response."]
[null,"c.     State the guaranteed lead times for the manufacture and delivery of metering pole top kiosks"]
[null,"d.     State the number of metering pole top kiosks that can be produced per month with the Tenderer’s current capability.\nProvide documentation / brochures to proof your response."]
[null,"e.     State how it will implicate your manufacturing operations if the number of metering pole top kiosks are increased above the normal delivery number."]
[null,"f.     List and describe the number of metering pole top kiosks that are currently in manufacturing progress and / or planned to start through the year versus the number of technical staff directly involved with the production of metering pole top kiosks."]
[4,"Historical performance"]
[null,"a.     Provide the original and actual delivery dates of those metering pole top kiosks listed in point 1 above.",{"$nulls":3},"1. Previous experience with manufacturing metering pole top kiosks = 25\n2. No experience = 15\n3. Late deliveries = -5\n4. No references of similar projects = -5\n5. No references from customers = -5\n6. Some fields left open or no meaningful information provided = -5 for each item\n7. Nothing entered = 0\n"]
[null,"b.     Where applicable provide the major reasons for delivery delays for those metering pole top kiosks that were delivered more than six (6) months behind the original delivery schedule"]
[null,"c.     If not already detailed in your answers to the above questions, state what experience you have had with the different types of metering pole top kiosks.\nProvide details of orders delivered of these kiosks."]
[null,"d.     Provide details of any similar projects that have been undertaken by the Tenderer and references from relevant customers.  "]
[5,"Link between supplier / manufacturer and sub-contractor"]
[null,"a.     State what functions during the manufacturing are sub-contracted?",{"$nulls":3},"1. No work subcontracted = 30\n2. Work subcontracted and details provided = 30\n3. Work subcontracted and no details stated = 15\n4. Subcontractor has experience less than 2 years = 5\n5. No subcontractor experience stated = -5\n6. No quality controls stated for subcontractor = -5\n7. Some fields left open or no meaningful information provided = -10 for each item.\n8. Nothing entered = 0\n"]
[null,"b.     State how long has each sub-contractor being doing the sub-contracted work?"]
[null,"c.     State what quality controls are in place to guarantee work from the sub-contractors?"]
[6,"Maintenance and testing"]
[null,"a.     Provide details on the companies staff complement dedicated to the following:",{"$nulls":3},"1. Adequate staff = 50\n2. Not adequate staff = 25\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"i. Sales "]
[null,"ii. Technical support "]
[null,"iii. Maintenance "]
[null,"iv. Kiosk testing "]
[null,"iv. Quality testing "]
[7,"Spares holding"]
[null,"a.     Describe the recommended metering pole top kiosks spares holdings with respect to Eskom’s geographical locations and scheme availability requirements.",{"$nulls":3},"1. Spares holding listed = 20\n2. Limited spares holding = 10\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"b.     Describe your policy on availability of spare parts and expansion parts for a period of ten years subsequent to the expiry of the supply contract."]
[{"$nulls":4},{"$f":"(E4+E9+E11+E18)*0.6+(E23+E27+E34)*0.4","v":0}]

{"sheet":"6a A&B 8-way","index":9,"n_rows":22,"n_cols":17,"rows_kept":22,"merged":[[0,0,0,4]]}
["Metering kiosks: Pole top split meters 8-way\n"]
["Clause","DESCRIPTION","\nSCHEDULE A","SCHEDULE B\nYes (or Y), Partial (or P), No (or N)","Response","Evaluator response","Weight\nHeigh = 10, \nMedium = 5, \nLow = 1","Score\nYes = 3, \nPartially = 1, \nNo = 0","Total"]
[1,"General",{"$nulls":14},"Yes"]
[1.1,"Manufactured to the requirements of 240-75659760 Pole mounted service distribution boxes for split prepayment metering standard.","State compliance with the standard",null," Describe any deviation or state full compliance",null,1,{"$f":"IF(OR(F4=\"Yes\",F4=\"Y\",F4=\"YES\",F4=\"y\"),3,IF(OR(F4=\"Partial\",F4=\"P\",F4=\"PARTIAL\",F4=\"p\"),1,0))","v":0},{"$f":"H4*G4","v":0},{"$nulls":7},"Partial"]
[2,"Pole top 8-way 50A","State if tendered for",{"$nulls":4},0,0,{"$nulls":7},"No"]
[2.1,"Manufactured to the requirements of D-1045; Manufacturing drawings for 8-way pole top split prepayment metering kiosks. ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[2.2,"Material composition of kiosk","State manufacturer of the material and types used",null,"State types of materials used, manufacturers and composition\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[2.3,"Electrical equipment:",{"$nulls":6},0]
[null,"1. Miniature circuit breaker","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"2. Surge arrestor","State manufacturer, type and electrical ratings",null,"State full details of manufacturer, type and electrical ratings\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"3. Busbar","State material and dimensions",null,"State full details of material used and dimensions\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"4. Internal wiring ","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[null,"5. Supply cable wiring","State manufacturer, type and wire diameter",null,"State full details of manufacturer, type and wiring diameter\nProvide brochures / technical data sheets with technical data to verify the response",null,10,0,0]
[2.4,"Layout  according to D-1045",{"$nulls":6},0]
[null,"1. Dimensions","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,10,0,0]
[null,"2. External layout, hinges, locking mechanism, brackets","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F16=\"Yes\",F16=\"Y\",F16=\"YES\",F16=\"y\"),3,IF(OR(F16=\"Partial\",F16=\"P\",F16=\"PARTIAL\",F16=\"p\"),1,0))","v":0},0]
[null,"3. Internal layout","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,{"$f":"IF(OR(F17=\"Yes\",F17=\"Y\",F17=\"YES\",F17=\"y\"),3,IF(OR(F17=\"Partial\",F17=\"P\",F17=\"PARTIAL\",F17=\"p\"),1,0))","v":0},0]
[null,"4. DIN-rail ","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,5,0,0]
[null,"5. Glands","State manufacturer, type and size",null,"State full details of manufacturer and type\nProvide brochures / technical data sheets with technical data to verify the response",null,5,0,0]
[null,"6. Notices and labels","State compliance with the manufacturing drawings",null,"Describe any deviation or state full compliance",null,1,0,0]
[{"$nulls":6},{"$f":"SUM(G4:G20)*3","v":276},null,{"$f":"SUM(I4:I20)","v":0}]
[{"$nulls":6},"Score",{"$f":"I21/G21*100","v":0}]

{"sheet":"6b Risk & Support 8-way","index":10,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[0,0,0,3],[3,0,6,0],[3,4,6,4],[3,5,6,5],[7,0,8,0],[9,0,15,0],[10,4,15,4],[10,5,15,5],[16,0,20,0],[17,4,20,4],[17,5,20,5],[22,5,24,5],[25,0,31,0],[26,4,31,4],[26,5,31,5],[32,0,34,0],[33,4,34,4],[33,5,34,5]]}
["Risk and Support Questionnaire"]
[null,"Question","Response","Reference/ Justification","Scoring"]
[]
[1,"Installed base/time that the product has been installed",{"$nulls":3},"1. Existing contract with Eskom for this range of metering pole top kiosks = 25\n2. Existing contract with Eskom for part of the range or with other municipalities = 20\n3. Existing contract for other panels not part of this range = 15\n4. New entry to market = 15\n5. No previous customers for metering pole top kiosks = 5\n6. No references = 5\n7. Some fields left open or no meaningful information provided = -5 for each item\n8. Nothing entered = 0\n"]
[null,"a.     Supplier to state the date of first production of similar metering pole top kiosks"]
[null,"b.     State the customer(s) that you have delivered to or that are still in progress during the past five (5) years. Provide documentation on proof of orders."]
[null,"c.     Provide customers references, quantities and contract values of the above.\nProvide documentation on proof of orders."]
[2,"Deviations from standard"]
[null,"a.     Deviation schedules within the A&B technical schedules for all items being offered to be completed",{"$nulls":3},"1. None = 25\n2. Deviations found 15\n3. Nothing listed = 0\n"]
[3,"Ability to deliver"]
[null,"a.     Briefly describe the nature of your resources in the Republic of South Africa e.g. workshop facilities, test equipment, etc\nProvide documentation / brochures to proof your response.",{"$nulls":3},"1. Adequate facilities = 25\n2. Not adequate = 15\n3. Guaranteed lead times > 8 weeks = - 5\n4. Guaranteed lead times > 12 weeks = -10\n5. Number of metering pole top kiosks per month < 1000 = -5\n6. Number of metering pole top kiosks per month < 600 = -10\n7. Number of metering pole top kiosks per month < 300= - 15\n8. Number of metering pole top kiosks currently in production = -5 for none\n9. Some fields left open or no meaningful information provided = -5 for each item\n10. Nothing entered = 0\n"]
[null,"b.     Briefly describe the sizes and capacities of your design, production and testing facilities.\nProvide documentation / brochures to proof your response."]
[null,"c.     State the guaranteed lead times for the manufacture and delivery of metering pole top kiosks"]
[null,"d.     State the number of metering pole top kiosks that can be produced per month with the Tenderer’s current capability.\nProvide documentation / brochures to proof your response."]
[null,"e.     State how it will implicate your manufacturing operations if the number of metering pole top kiosks are increased above the normal delivery number."]
[null,"f.     List and describe the number of metering pole top kiosks that are currently in manufacturing progress and / or planned to start through the year versus the number of technical staff directly involved with the production of metering pole top kiosks."]
[4,"Historical performance"]
[null,"a.     Provide the original and actual delivery dates of those metering pole top kiosks listed in point 1 above.",{"$nulls":3},"1. Previous experience with manufacturing metering pole top kiosks = 25\n2. No experience = 15\n3. Late deliveries = -5\n4. No references of similar projects = -5\n5. No references from customers = -5\n6. Some fields left open or no meaningful information provided = -5 for each item\n7. Nothing entered = 0\n"]
[null,"b.     Where applicable provide the major reasons for delivery delays for those metering pole top kiosks that were delivered more than six (6) months behind the original delivery schedule"]
[null,"c.     If not already detailed in your answers to the above questions, state what experience you have had with the different types of metering pole top kiosks.\nProvide details of orders delivered of these kiosks."]
[null,"d.     Provide details of any similar projects that have been undertaken by the Tenderer and references from relevant customers.  "]
[5,"Link between supplier / manufacturer and sub-contractor"]
[null,"a.     State what functions during the manufacturing are sub-contracted?",{"$nulls":3},"1. No work subcontracted = 30\n2. Work subcontracted and details provided = 30\n3. Work subcontracted and no details stated = 15\n4. Subcontractor has experience less than 2 years = 5\n5. No subcontractor experience stated = -5\n6. No quality controls stated for subcontractor = -5\n7. Some fields left open or no meaningful information provided = -10 for each item.\n8. Nothing entered = 0\n"]
[null,"b.     State how long has each sub-contractor being doing the sub-contracted work?"]
[null,"c.     State what quality controls are in place to guarantee work from the sub-contractors?"]
[6,"Maintenance and testing"]
[null,"a.     Provide details on the companies staff complement dedicated to the following:",{"$nulls":3},"1. Adequate staff = 50\n2. Not adequate staff = 25\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"i. Sales "]
[null,"ii. Technical support "]
[null,"iii. Maintenance "]
[null,"iv. Kiosk testing "]
[null,"iv. Quality testing "]
[7,"Spares holding"]
[null,"a.     Describe the recommended metering pole top kiosks spares holdings with respect to Eskom’s geographical locations and scheme availability requirements.",{"$nulls":3},"1. Spares holding listed = 20\n2. Limited spares holding = 10\n3. Some fields left open or no meaningful information provided = -10 for each item\n4. Nothing entered = 0\n"]
[null,"b.     Describe your policy on availability of spare parts and expansion parts for a period of ten years subsequent to the expiry of the supply contract."]
[{"$nulls":4},{"$f":"(E4+E9+E11+E18)*0.6+(E23+E27+E34)*0.4","v":0}]

{"sheet":"7. Deviation schedule","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"merged":[[0,0,0,2]]}
["Deviation schedule"]
[]
["Item","Clause","Proposed Deviation"]