{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["CBA"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"CBA","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[3,2,3,7],[4,2,4,7],[5,0,5,7],[6,2,6,4],[6,5,6,7],[24,2,24,4],[25,2,25,4],[33,4,33,7],[34,4,34,7]]}
[]
["PetroSA",null,"COMMERCIAL BID ANALYSIS (CBA) "]
[null,null,"Please only complete white blocks below"]
["ENQUIRY NO: CTT0000025371",null,"SERVICE:  PROVISION OF A NETWORK MONITORING TOOL, SYSTEM MANAGEMENT TOOL AND A SERVICE MANAGEMENT TOOL FOR PetroSA "]
[null,null,"Insert Company Name Here"]
["CBA - PRICING"]
["Tenderers can tender for only one or all of the three components (Scope 1 and/or Scope 2 and/or Scope 3),  which must be clearly marked on all correspondence in its Tender Documents, Returnable Schedule and Commercial Bid Analysis)",null,"1 YEAR CONTRACT",null,null,"3 YEAR CONTRACT"]
["DESCRIPTION ","Unit of Measure (Qty)","Qty","Rate","Total ","Qty","Rate","Total "]
[]
["Scope 1: Network Performance Monitoring/Configuration Tool","Max 3000 IP Devices",{"v":3000,"d":"3,000"},null,{"$f":"C10*D10","v":{"v":0,"d":"0.00"}},{"v":3000,"d":"3,000"},null,{"$f":"F10*G10","v":{"v":0,"d":"0.00"}}]
["Scope 2: System Management Tool (SCOM & SCCM)",1,1,null,{"$f":"C11*D11","v":{"v":0,"d":"0.00"}},1,null,{"$f":"F11*G11","v":{"v":0,"d":"0.00"}}]
["Scope 3a: ICT Services Management Solution","10 Agents",10,null,{"v":0,"d":"0.00"},10,null,{"v":0,"d":"0.00"}]
["Scope 3b: ICT Services Management Solution","20 Resolvers",20,null,{"v":0,"d":"0.00"},20,null,{"v":0,"d":"0.00"}]
["Scope 3c: ICT Services Management Solution","1000 End-Users",{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"},{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"}]
[]
["TOTAL CONTRACT RECURRING VALUE (1 Year)",{"$nulls":3},{"$f":"SUM(E10:E15)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(H10:H15)","v":{"v":0,"d":"0.00"}}]
[]
["Non- Recuring Costs (1 Year) - Implementation Costs (including training)"]
["Scope 1: Network Performance Monitoring/Configuration Tool","Max 3000 IP Devices",null,null,{"$f":"C19*D19","v":{"v":0,"d":"0.00"}},null,null,{"$f":"E19","v":{"v":0,"d":"0.00"}}]
["Scope 2: System Management Tool (SCOM & SCCM)",1,null,null,{"$f":"C20*D20","v":{"v":0,"d":"0.00"}},null,null,{"$f":"E20","v":{"v":0,"d":"0.00"}}]
["Scope 3: ICT Services Management Solution","10 Agents, 20 Resolvers, 1000 End-Users",null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":4},{"$f":"SUM(E19:E21)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"}]
["TOTAL CONTRACT VALUE (1 Year)",{"$nulls":3},{"$f":"E16+E22","v":{"v":0,"d":"0.00"}},null,null,{"$f":"H16+H22","v":{"v":0,"d":"0.00"}}]
[]
["Year Two"]
["Allow for escalation as per CPI index @  6%",{"$nulls":6},{"$f":"H16*0.06","v":{"v":0,"d":"0.00"}}]
["SUB TOTAL (Year 2)",{"$nulls":6},{"$f":"SUM(H23:H26)","v":{"v":0,"d":"0.00"}}]
[]
["Year Three"]
["Allow for escalation as per CPI index @ 6%",{"$nulls":6},{"$f":"H27*0.06","v":{"v":0,"d":"0.00"}}]
["SUB TOTAL (Year 3)",{"$nulls":6},{"$f":"SUM(H27:H30)","v":{"v":0,"d":"0.00"}}]
["TOTAL CONTRACT VALUE (3 Years)",{"$nulls":6},{"$f":"H16+H27+H31","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"Please insert this value on "]
[{"$nulls":4},"the e-procurement system"]
[]
["NOTE:   The escalation allowance and calculation of "]
["this contract value is for internal contract mangement  "]
["purposes only.       This amount is not a guarantee of "]
["allocated work and is by no means to be considered "]
["an actual and definite value of the service."]