{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["EDW Solution Pricing Detail","EDW Pricing Summary","Parameters & Variables"],"read":"whole","date_system":"1900"}

{"sheet":"EDW Solution Pricing Detail","index":0,"n_rows":15,"n_cols":12,"rows_kept":15}
[null,"Annexure F: NLC Servers & Storage Pricing Detailed Schedule:"]
[null,"Item No","Section / Category","Component / Line Item","Unit","Implementation Phase","Qty","Unit Price (Excl VAT)","Subtotal (Excl VAT)","VAT","Total (Incl VAT)","Vendor Notes & Comments"]
[null,"1.","Architecture & Design","EDW Solution Architecture and Design","Lot","Phase 1",1,{"v":0,"d":"R0.00"},{"$f":"G3*H3","v":{"v":0,"d":"R0.00"}},{"$f":"I3*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"$f":"I3+J3","v":{"v":0,"d":"R0.00"}}]
[null,"2.","Platform Configuration","EDW Platform Installation and Configuration","Lot","Phase 1",1,{"v":0,"d":"R0.00"},{"$f":"G4*H4","v":{"v":0,"d":"R0.00"}},{"$f":"I4*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"3.","Data Integration","Development of Data Pipelines and ETL Processes","Lot","Phase 2",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I5*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"4.","Data Modelling","Data Modelling, Data Quality and Governance Setup","Lot","Phase 2",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I6*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"5.","Analytics Enablement","BI Dashboard and Analytics Configuration","Lot","Phase 3",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I7*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"6.","AI/ML Enablement","Machine Learning / AI Enablement Modules","Lot","Phase 3",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I8*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"7.","Security & Governance","Security, RBAC, SSO and Compliance Setup","Lot","Phase 2",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I9*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"8.","Training & Skills Transfer","Training for NLC Users and Technical Staff","Lot","Phase 4",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I10*'Parameters & Variables'!$C7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"9.","Deployment","Production Deployment and Go-Live Support","Lot","Phase 4",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I11*'Parameters & Variables'!$C$15","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"10.","Software Licencing","Licencing of all Software Tools, SAAS, IAAS Costs","Lot ","Ongoing ",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I12*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"11.","Solution Project Management","Solution Implmentation and Deployment Project\nManagement","Lot","Phases 1 to 4",1,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"I13*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,"12.","Support & Maintenance","Support and Maintenance (60 months)","Annual","Ongoing ",5,{"v":0,"d":"R0.00"},{"$f":"G14*H14","v":{"v":0,"d":"R0.00"}},{"$f":"I14*'Parameters & Variables'!$C$7","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"}]
[null,null,"Total Cost of Implementation and Support:",{"$nulls":5},{"$f":"SUM(I3:I14)","v":{"v":0,"d":"R0.00"}},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]

{"sheet":"EDW Pricing Summary","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[8,1,8,5]]}
[]
[null,"Category","Subtotal \n(Excl VAT)","VAT","Total \n(Incl VAT)"]
[null,"Implementation Services - Phases 1 to 3",{"$f":"SUM('EDW Solution Pricing Detail'!I3:I9)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM('EDW Solution Pricing Detail'!J3:J9)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM('EDW Solution Pricing Detail'!K3:K9)","v":{"v":0,"d":"R0.00"}}]
[null,"Licensing (as applicable)",{"$f":"'EDW Solution Pricing Detail'!I12","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!J12","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!K12","v":{"v":0,"d":"R0.00"}}]
[null,"Training, Skills Transfer & Deployment - Phase 4",{"$f":"SUM('EDW Solution Pricing Detail'!I10:I11)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM('EDW Solution Pricing Detail'!J10:J11)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM('EDW Solution Pricing Detail'!K10:K11)","v":{"v":0,"d":"R0.00"}}]
[null,"Project Management ",{"$f":"'EDW Solution Pricing Detail'!K13","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!J13","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!K13","v":{"v":0,"d":"R0.00"}}]
[null,"Support & Maintenance (5 years)",{"$f":"'EDW Solution Pricing Detail'!I14","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!I14","v":{"v":0,"d":"R0.00"}},{"$f":"'EDW Solution Pricing Detail'!K14","v":{"v":0,"d":"R0.00"}}]
[null,"Grand Total",{"$f":"SUM(C3:C7)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(D3:D7)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E3:E7)","v":{"v":0,"d":"R0.00"}}]
[null,"Further to the above Schedule Please could you itemise more specific cost categories as follows. User must complete these splits manually :\nThis is purely required for Management Information Purposes."]
[]
[null,"Cost Category ",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[null,"Implementation Services",null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(D12:H12)","v":{"v":0,"d":"R0.00"}}]
[null,"Licensing (if applicable)",null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Training, Skills transfer & Deployment",null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Project Management ",null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"}]
[null,"Support & Maintenance (5 years)",null,{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"v":0,"d":"R0.00"},{"$f":"SUM(D16:H16)","v":{"v":0,"d":"R0.00"}}]
[null,"Total Costs",null,{"$f":"SUM(D12:D16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E12:E16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F12:F16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G12:G16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(H12:H16)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(I12:I16)-SUM(I12:I16)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Parameters & Variables","index":2,"n_rows":7,"n_cols":4,"rows_kept":7}
[]
["#","Parameter","Value","Description"]
["1.","Currency","ZAR","All pricing must be submitted in South African Rand"]
["2.","Implementation Period","18 Months","Initial implementation duration"]
["3.","Support Period","60 Months","Support and maintenance contract period"]
["4.","Deployment Model","Hybrid Cloud","Supports cloud and on-premise deployment"]
["5.","VAT Rate",{"v":0.15,"d":"15.00%"}]