{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Notes","Data Transformation","Currency"],"not_rendered":{"external_links":7,"defined_names":301},"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":17,"n_cols":2,"rows_kept":17}
[]
[]
[]
[null,"IMPORTANT NOTES"]
[null,"All cells highlighted in GREEN must be completed"]
[null,"Quoted prices MUST be in ZAR, EXCLUDING VAT and ESCALATIONS"]
[]
[null,"Professional Services to implement Data Management and Governance Landscape"]
[]
[null,"Prices MUST be quoted based on the SCOPE provided"]
[null,"Select the currency from the CURRENCY drop-down list in COLUMN \"G\""]
[]
[null,"Capture the applicable Currency, ROE and ROE Published Date on the \"Currency sheet\". "]
[null,"The adjustments for prevailing rates and the basis for future price adjustments will be determined at time of contracting. "]
[null,"Exchange rate variations may not be claimed for the local mark-up in the pricing structure"]
[]
[null,"All Prices must be exclusive of VAT"]

{"sheet":"Data Transformation","index":1,"n_rows":58,"n_cols":12,"rows_kept":58,"merged":[[2,1,2,6],[4,5,4,7],[4,8,4,11],[5,5,5,7],[6,0,12,0],[6,1,12,1],[18,3,18,5],[19,1,23,1],[19,10,23,10],[24,1,28,1],[24,10,28,10],[29,1,33,1],[29,10,33,10],[34,1,38,1],[34,10,38,10],[39,1,43,1],[39,10,43,10],[44,1,48,1],[44,10,48,10],[49,1,53,1],[49,10,53,10],[57,1,60,1],[57,2,60,2]]}
[null,"Pricing Schedule : Professional Services to implement Data Management and Governance Landscape"]
[]
[null,"VENDOR NAME"]
[]
[null," ",{"$nulls":6},"TOTAL COST BASED ON MILESTONES"]
["Item Number","Service Category","Description","Total Estimated Quantity","Unit charge","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR"]
[1,"Professional Service\n(As defined in the SOW)","Milestone 1: Establish Data Governance",1,"SUM",{"$f":"IF(G7=\"\",\"\",IF(G7=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F7=\"\",\"\",IF(F7=\"Foreign\",VLOOKUP(G7,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I7*$H7","v":0},{"$f":"I7*$D7","v":0},{"$f":"K20","v":0}]
[null,null,"Milestone 2: Establish Data Ownership Function across Eskom",1,"SUM",{"$f":"IF(G8=\"\",\"\",IF(G8=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F8=\"\",\"\",IF(F8=\"Foreign\",VLOOKUP(G8,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K25","v":0}]
[null,null,"Milestone 3: Establish and ensure compliance of data of data regulations in the scope of Eskom",1,"SUM","Local","ZAR",{"$f":"IF(F9=\"\",\"\",IF(F9=\"Foreign\",VLOOKUP(G9,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K30","v":0}]
[null,null,"Milestone 4: Implement the enterprise data architecture (EDA) discipline across Eskom",1,"SUM","Local","ZAR",{"$f":"IF(F10=\"\",\"\",IF(F10=\"Foreign\",VLOOKUP(G10,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K35","v":0}]
[null,null,"Milestone 5: As-Is and To-be EDA landscape. Identification/Recommendation",1,"SUM","Local","ZAR",{"$f":"IF(F11=\"\",\"\",IF(F11=\"Foreign\",VLOOKUP(G11,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K40","v":0}]
[null,null,"Milestone 6: Implement data quality management (DQM) discipline",1,"SUM","Local","ZAR",{"$f":"IF(F12=\"\",\"\",IF(F12=\"Foreign\",VLOOKUP(G12,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K45","v":0}]
[null,null,"Milestone 7: Establish and drive the data culture program across the organisation",1,"SUM","Local","ZAR",{"$f":"IF(F13=\"\",\"\",IF(F13=\"Foreign\",VLOOKUP(G13,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"K50","v":0}]
[2,"Training","Continuous transfer of skills, knowledge, and training of Eskom employees",1,"No.",{"$f":"IF(G14=\"\",\"\",IF(G14=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F14=\"\",\"\",IF(F14=\"Foreign\",VLOOKUP(G14,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I14*$H14","v":0},{"$f":"I14*$D14","v":0},{"$f":"J14*$D14","v":0}]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L7:L14)","v":0}]
[]
[]
[]
[null,"Professional Services Breakdown based on the required Resources PER Milestone","Resource (Skill type)","Currency",null,null,"Number of Resources","Number of Hours","Resource Rate (Hourly)","Total"]
[null,"Milestone 1",null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(D20=\"\",\"\",IF(D20=\"Foreign\",VLOOKUP(E20,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I20*F20)*H20*G20","v":0},{"$f":"SUM(J20:J24)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D21=\"\",\"\",IF(D21=\"Foreign\",VLOOKUP(E21,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I21*F21)*H21*G21","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D22=\"\",\"\",IF(D22=\"Foreign\",VLOOKUP(E22,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D23=\"\",\"\",IF(D23=\"Foreign\",VLOOKUP(E23,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D24=\"\",\"\",IF(D24=\"Foreign\",VLOOKUP(E24,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 2",null,{"$f":"IF(E25=\"\",\"\",IF(E25=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(D25=\"\",\"\",IF(D25=\"Foreign\",VLOOKUP(E25,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I25*F25)*H25*G25","v":0},{"$f":"SUM(J25:J29)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D26=\"\",\"\",IF(D26=\"Foreign\",VLOOKUP(E26,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I26*F26)*H26*G26","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D27=\"\",\"\",IF(D27=\"Foreign\",VLOOKUP(E27,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D28=\"\",\"\",IF(D28=\"Foreign\",VLOOKUP(E28,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D29=\"\",\"\",IF(D29=\"Foreign\",VLOOKUP(E29,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 3",null,"Local","ZAR",{"$f":"IF(D30=\"\",\"\",IF(D30=\"Foreign\",VLOOKUP(E30,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I30*F30)*H30*G30","v":0},{"$f":"SUM(J30:J34)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D31=\"\",\"\",IF(D31=\"Foreign\",VLOOKUP(E31,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I31*F31)*H31*G31","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D32=\"\",\"\",IF(D32=\"Foreign\",VLOOKUP(E32,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D33=\"\",\"\",IF(D33=\"Foreign\",VLOOKUP(E33,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D34=\"\",\"\",IF(D34=\"Foreign\",VLOOKUP(E34,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 4",null,"Local","ZAR",{"$f":"IF(D35=\"\",\"\",IF(D35=\"Foreign\",VLOOKUP(E35,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I35*F35)*H35*G35","v":0},{"$f":"SUM(J35:J39)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D36=\"\",\"\",IF(D36=\"Foreign\",VLOOKUP(E36,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I36*F36)*H36*G36","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D37=\"\",\"\",IF(D37=\"Foreign\",VLOOKUP(E37,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D38=\"\",\"\",IF(D38=\"Foreign\",VLOOKUP(E38,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D39=\"\",\"\",IF(D39=\"Foreign\",VLOOKUP(E39,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 5",null,"Local","ZAR",{"$f":"IF(D40=\"\",\"\",IF(D40=\"Foreign\",VLOOKUP(E40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I40*F40)*H40*G40","v":0},{"$f":"SUM(J40:J44)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D41=\"\",\"\",IF(D41=\"Foreign\",VLOOKUP(E41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I41*F41)*H41*G41","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D42=\"\",\"\",IF(D42=\"Foreign\",VLOOKUP(E42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D43=\"\",\"\",IF(D43=\"Foreign\",VLOOKUP(E43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D44=\"\",\"\",IF(D44=\"Foreign\",VLOOKUP(E44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 6",null,"Local","ZAR",{"$f":"IF(D45=\"\",\"\",IF(D45=\"Foreign\",VLOOKUP(E45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I45*F45)*H45*G45","v":0},{"$f":"SUM(J45:J49)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D46=\"\",\"\",IF(D46=\"Foreign\",VLOOKUP(E46,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I46*F46)*H46*G46","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D47=\"\",\"\",IF(D47=\"Foreign\",VLOOKUP(E47,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D48=\"\",\"\",IF(D48=\"Foreign\",VLOOKUP(E48,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D49=\"\",\"\",IF(D49=\"Foreign\",VLOOKUP(E49,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[null,"Milestone 7",null,{"$f":"IF(E50=\"\",\"\",IF(E50=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(D50=\"\",\"\",IF(D50=\"Foreign\",VLOOKUP(E50,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I50*F50)*H50*G50","v":0},{"$f":"SUM(J50:J54)","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D51=\"\",\"\",IF(D51=\"Foreign\",VLOOKUP(E51,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"(I51*F51)*H51*G51","v":0}]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D52=\"\",\"\",IF(D52=\"Foreign\",VLOOKUP(E52,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D53=\"\",\"\",IF(D53=\"Foreign\",VLOOKUP(E53,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[{"$nulls":3},"Local","ZAR",{"$f":"IF(D54=\"\",\"\",IF(D54=\"Foreign\",VLOOKUP(E54,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},0]
[]
[]
[]
[null,"SCOPE OF WORK","Establish Data Governance\n• Eskom Data Office and Data Operating Model (which include the POPIA Office)\n• Establish the Eskom Data Governance Committee and working group\n• Enterprise Data and Information Framework (EDIF)\n• Data and Information governance policy (Data Policy)\n• Data Standards\n• Data governance oversight structures\n• Data and Analytics Office\n\nEstablish Data Ownership Function across Eskom\n• On board identified data owners\n• Role descriptions for Data Owners and Data Stewards\n• Data Owner and Data Steward Training material\n• Data Asset Register\n\nEstablish and ensure compliance of data of data regulations in the scope of Eskom\n• Data Compliance Framework\n• Data Risk Register\n• Consolidated data controls register\n• Data Compliance Assessment models\n• Combined assurance model\n• Compliance reports\n\nImplement the enterprise data architecture (EDA) discipline across Eskom\n• Centralised Data Asset Register\n• Current state EDA\n• Target EDA\n\nImplement data quality management (DQM) discipline\n• Data Quality Management policy and procedures\n• DQM plan and roadmap\n• DQ standards\n• List of critical data sources and fields\n• DQ Metrics, Thresholds and Reporting requirements\n• DQ training material\n• DQ reporting structure\n• DQ validation rules and profiling rules\n• DQ dashboards\n• DQ exception reports\n• Remediation plans/ specifications for data fixes\n•  DQ SLA’s\n\nEstablish and drive the data culture program across the organisation\n• Communication plan and activities\n• DM Training material\n• DM Quick Reference Guides\n• Change Management Process\n• Survey Reports\n\nEstablish the required security controls to ensure Confidentiality, Integrity, and Availability of information in the Data Lifecycle process which includes Data:\n• Creation\n• Processing\n• Storage\n• Usage\n• Archival\n• Destruction\n\nImplement a data combined assurance framework to ensure business adoption during implementation of the respective data disciplines in BAU. Business adoption includes the implementation of supervision, reporting processes, incident management, process controls, risk management, monitoring, reporting and issue mitigation.\nDevelop plan to mature the data management across the organisation post the project. "]

{"sheet":"Currency","index":2,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[1,1,1,5],[6,2,6,7],[7,1,9,1],[7,2,7,7],[7,15,7,20],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,14,1],[12,2,12,7],[13,2,13,7],[14,2,14,7],[17,2,17,7]]}
[]
[null,{"$f":"'Data Transformation'!B3","v":"VENDOR NAME"}]
[]
[null,"EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[]
[null,"NOTES:"]
[null,1,"The table below needs to be completed if the Employer will be exposed to any currency fluctuation as stipulated in Secondary Clause X3.  For conversion of the foreign portions to Rand, please use the South African Reserve Bank's (SARB) exchange rate at 12:00 on the day of advertisement of the bid.  This is in terms of the Preferential Procurement Policy Framework Act (PPPFA) with which the Employer has to comply.\nNB: Tenderers must submit proof of the SARB rate(s) of exchange used  "]
[null,2,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,null,"www.resbank.co.za"]
[null,null,"-  Select Research\n-  Then select Rates\n-  Click on \"Select historical exchange rates and other interest rates\"\n-  Clicking on the exchange rate in the following page opens the daily rates per currency and SA Rand"]
[null,3,"The Employer deals only in the currencies listed below unless other currencies are specifically approved for this tender.  Kindly notify the Employer of any currency that the tenderer intends to use, but is not stipulated in the table, to consider sanctioning such currency.  Sufficient time must be allowed for the assessment and to respond to such request.  The onus is on the tenderer to submit a bid with approved currencies"]
[null,4,"The format in which the exchange rate must be inserted in the table is:  1 (One) Foreign Currency = R Amount  (i.e. the Rand amount for one of each foreign currency applicable).  Exchange rates must be rounded to 4 decimals\n\nNB :  Only the USD/ZAR, GBP/ZAR and EUR/ZAR are published in this way on the SARB web pages above.  The Rand rate with the other currencies must be inverted (1/Foreign Currency Rate) in order to list it in the required format in the table below\n"]
[null,5,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,null,"Payment in terms of Payment Method 2  is considered as a \"foreign payment\" although it will be effected in South African Rand. However, amounts for  \"F.O.R. Price-Goods supplied from Imported Items\", are NOT considered as \"foreign payments\""]
[null,null,"If more than one payment method apply for a currency, the Tenderer must request an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[]
[]
[null,null,"MULTIPLE CURRENCIES"]
[null,null,"No","Currency Description","Code","Exchange Rate Currency 1,00 =","Date Published","Source"]
[null,null,1,"Australian Dollar","AUD"]
[null,null,2,"Canadian Dollar","CAN"]
[null,null,3,"Swiss Franc","CHF"]
[null,null,4,"Danish Krone","DKK"]
[null,null,5,"European Currency","EUR"]
[null,null,6,"British Pound","GBP"]
[null,null,7,"Hong Kong Dollar","HKD"]
[null,null,8,"Japanese Yen","JPY"]
[null,null,9,"Norwegian Krone","NOK"]
[null,null,10,"New Zealand Dollar","NZD"]
[null,null,11,"Swedish Krone","SEK"]
[null,null,12,"Singapore Dollar","SGD"]
[null,null,13,"United States Dollar","USD"]
[null,null,14,"South African Rand","ZAR",{"v":1,"d":"R 1.000000"}]