{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Instructions ","Summary","FTC-Transition","FTC-Recurring","Breakout Points","FTC-Disengagement","CAPEX","Resource Rates","Scn 2 Voice - Recurring","Scn 3 Voice - Recurring","Scn 2 LAN - Recurring"],"not_rendered":{"images":4,"external_links":2,"defined_names":261,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions ","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[1,1,1,2],[15,1,15,2],[17,1,17,3]]}
[]
[null,"Instructions "]
[null,null,"Name of Service Provider"]
[null,null,"Date"]
[null,null,"The Exchange Rate to be used when completing this Pricing Workbook: ","R16,11 to 1 USD"]
[null,null,"All the Rand Values must be filled in as per the pricing workbook to 2 decimal places."]
[null,null,"All pricing must be Inclusive of Value Added Tax (VAT)."]
[null,null,"Validity of Pricing must be for One Hundred and Eighty (180) days."]
[null,"1.","This MS Excel Workbook contains a separate spreadsheets designed to provide a robust understanding of the costing model.  It is ESSENTIAL that this model be used in the pricing response.  "]
[null,"2.","The descriptions and Instructions/context for each spreadsheet, as well as convenient one-click navigation of the workbook are detailed below under the heading of \"Pricing Workbook Tab Instructions\" .\n"]
[null,"3.","Each worksheet is designed to elicit specific pricing information related to establishing, managing, developing, and deploying the work required by the Hosted PBX. If your typical pricing model does not normally charge for a specific element provided within this workbook, then please provide a statement in your \"Assumptions\" regarding your methodology for charging for that element (i.e., not applicable, charged on a time and material (T&M) basis, etc.)."]
[null,"4.","The worksheets in this Pricing Template are protected to minimize the risk of compromising the integrity of the workbook structure and formulas. As such, the editable cells within each worksheet are indicated in light blue highlight as shown =================================>","This cell is Editable"]
[null,"5.","Service provider must note that only unconditional discounts will be taken into account for purposes of pricing evaluation.”"]
[]
[]
[null,"Pricing Goals"]
[]
[null,"Transnet has developed the following Service pricing goals for RFP respondents to utilize in developing the Service Pricing proposal.  RFP respondent pricing should reflect:\n- Predetermined and Fixed Pricing for services over agreement term\n- Scalable to account for additions or reductions in business requirements\n- Ability to plug and unplug services to adapt new service delivery methods \n- All respondents assumptions in developing pricing are visible\n- Pricing Models ability to reflect ongoing continuous improvement gains\n- Pricing is structured so to encourage standardized use and behaviours\n- Transparent to underlying cost drivers \n- Enable external benchmarking of competitive services\n"]

{"sheet":"Summary","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"merged":[[1,2,1,8],[2,1,2,8],[4,1,4,8],[10,1,10,2]]}
[]
[null,null,"PROVISIONING OF VoIP SERVICES PRICING WORKBOOK\n"]
[null,{"$f":"'Instructions '!$C$3","v":"Name of Service Provider"}]
[]
[null,"Instructions for completing this Pricing Workbook"]
[null,"No","Pricing Elements","Year 1 ","Year 2","Year 3","Year 4","Year 5","Total"]
[null,1,"FTC-Transition",{"$f":"'FTC-Transition'!C15","v":0},{"$nulls":4},{"$f":"SUM(D7:H7)","v":0}]
[null,2,"FTC Recurring",{"$f":"'FTC-Recurring'!G32","v":0},{"$f":"'FTC-Recurring'!J32","v":0},{"$f":"'FTC-Recurring'!M32","v":0},{"$f":"'FTC-Recurring'!P32","v":0},{"$f":"'FTC-Recurring'!S32","v":0},{"$f":"SUM(D8:H8)","v":0}]
[null,3,"FTC-Disengagement",{"$nulls":4},{"$f":"'FTC-Disengagement'!C15","v":0},{"$f":"SUM(D9:H9)","v":0}]
[null,4,"CAPEX",{"$f":"CAPEX!F14","v":0},{"$nulls":4},{"$f":"SUM(D10:H10)","v":0}]
[null,"Total (Incl. VAT)",null,{"$f":"SUM(D7:D10)","v":0},0,0,0,0,0]

{"sheet":"FTC-Transition","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[1,1,1,3],[2,3,4,3],[2,4,3,5],[4,1,4,2]]}
[]
[null,"FIXED TELEPHONE COMMUNICATION TRANSITION"]
[null,"FTC Services ","Transition Fees",null,"NB: Estimated transition from current service provider is 3 months"]
[null,{"$f":"'Instructions '!C3","v":"Name of Service Provider"}]
[]
[null,"Resource Category (itemize all charges)","Cost Breakdown  Per Month (Incl. VAT)","Description of Services / Comments"]
[null,"Project Team / Management ",0]
[null,"Hardware",0]
[null,"Testing",0]
[null,"Training",0]
[null,"Shipping/Handling/Storage",0]
[null,"Installation / build-out",0]
[null,"Third-party consulting and/or labour",0]
[null,"TOTAL TRANSITION FEES ( Incl. VAT)",{"$f":"SUM(C7:C13)","v":0}]
[null,"ANNUAL SERVICE FEES ( Incl. VAT)",{"$f":"C14*12","v":0}]

{"sheet":"FTC-Recurring","index":3,"n_rows":48,"n_cols":19,"rows_kept":48,"merged":[[1,1,1,18],[3,1,4,3],[3,4,3,6],[3,7,3,9],[3,10,3,12],[3,13,3,15],[3,16,3,18],[4,4,4,6],[4,7,4,9],[4,10,4,12],[4,13,4,15],[4,16,4,18],[7,1,9,1],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,1,15,1],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,4,30,5],[31,4,31,5]]}
[]
[null,"FIXED TELEPHONE COMMUNICATION MAINTENANCE AND SUPPORT SERVICES"]
[]
[null,{"$f":"'Instructions '!C3","v":"Name of Service Provider"},null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5"]
[{"$nulls":4},"Price Per Month ( Incl. VAT)",null,null,"Price Per Month ( Incl. VAT)",null,null,"Price Per Month ( Incl. VAT)",null,null,"Price Per Month ( Incl. VAT)",null,null,"Price Per Month ( Incl. VAT)"]
[null,"Resource Category","Resource Unit of Measure","Service Level","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total"]
[null,"SIP Trunks","Trunk and channel fee","1 GB SIP  60 ( 360 Channels )",3,null,{"$f":"F7*E7","v":{"v":0,"d":"R0.00"}},3,null,{"$f":"I7*H7","v":{"v":0,"d":"R0.00"}},3,null,{"$f":"L7*K7","v":{"v":0,"d":"R0.00"}},3,null,{"$f":"O7*N7","v":{"v":0,"d":"R0.00"}},3,null,{"$f":"R7*Q7","v":{"v":0,"d":"R0.00"}}]
[null,"Call Rates","On-net per second (zero rated)",null,{"v":202915970,"d":"202,915,970"},null,{"v":0,"d":"R0.00"},{"v":202915970,"d":"202,915,970"},null,{"v":0,"d":"R0.00"},{"v":202915970,"d":"202,915,970"},null,{"v":0,"d":"R0.00"},{"v":202915970,"d":"202,915,970"},null,{"v":0,"d":"R0.00"},{"v":202915970,"d":"202,915,970"},null,{"v":0,"d":"R0.00"}]
[null,null,"Off-net per second (National Average Landline)",null,{"v":136347512,"d":"136,347,512"},null,{"v":0,"d":"R0.00"},{"v":136347512,"d":"136,347,512"},null,{"v":0,"d":"R0.00"},{"v":136347512,"d":"136,347,512"},null,{"v":0,"d":"R0.00"},{"v":136347512,"d":"136,347,512"},null,{"v":0,"d":"R0.00"},{"v":136347512,"d":"136,347,512"},null,{"v":0,"d":"R0.00"}]
[null,null,"Off-net per second (To Cellular networks)",null,{"v":201305524,"d":"201,305,524"},null,{"$f":"F10*E10","v":{"v":0,"d":"R0.00"}},{"v":201305524,"d":"201,305,524"},null,{"v":0,"d":"R0.00"},{"v":201305524,"d":"201,305,524"},null,{"v":0,"d":"R0.00"},{"v":201305524,"d":"201,305,524"},null,{"v":0,"d":"R0.00"},{"v":201305524,"d":"201,305,524"},null,{"v":0,"d":"R0.00"}]
[null,"Voice Service Build and Change (IMACDF)\nper month\n\n","Install","Qty of Installs",{"v":1000,"d":"1,000"},null,{"$f":"F11*E11","v":{"v":0,"d":"R0.00"}},{"v":1000,"d":"1,000"},null,{"$f":"I11*H11","v":{"v":0,"d":"R0.00"}},{"v":1000,"d":"1,000"},null,{"$f":"L11*K11","v":{"v":0,"d":"R0.00"}},{"v":1000,"d":"1,000"},null,{"$f":"O11*N11","v":{"v":0,"d":"R0.00"}},{"v":1000,"d":"1,000"},null,{"$f":"R11*Q11","v":{"v":0,"d":"R0.00"}}]
[null,null,"Move","Qty of Moves",100,null,{"$f":"F12*E12","v":{"v":0,"d":"R0.00"}},100,null,{"v":0,"d":"R0.00"},100,null,{"v":0,"d":"R0.00"},100,null,{"v":0,"d":"R0.00"},100,null,{"v":0,"d":"R0.00"}]
[null,null,"Add","Qty of Adds",50,null,{"v":0,"d":"R0.00"},50,null,{"v":0,"d":"R0.00"},50,null,{"v":0,"d":"R0.00"},50,null,{"v":0,"d":"R0.00"},50,null,{"v":0,"d":"R0.00"}]
[null,null,"Change","Qty of Changes",{"v":1000,"d":"1,000"},null,{"v":0,"d":"R0.00"},{"v":1000,"d":"1,000"},null,{"v":0,"d":"R0.00"},{"v":1000,"d":"1,000"},null,{"v":0,"d":"R0.00"},{"v":1000,"d":"1,000"},null,{"v":0,"d":"R0.00"},{"v":1000,"d":"1,000"},null,{"v":0,"d":"R0.00"}]
[null,null,"Dismantlement","Qty of Disposals",500,null,{"v":0,"d":"R0.00"},500,null,{"v":0,"d":"R0.00"},500,null,{"v":0,"d":"R0.00"},500,null,{"v":0,"d":"R0.00"},500,null,{"v":0,"d":"R0.00"}]
[null,null,"Faults","24/7 ",118,null,{"v":0,"d":"R0.00"},118,null,{"v":0,"d":"R0.00"},118,null,{"v":0,"d":"R0.00"},118,null,{"v":0,"d":"R0.00"},118,null,{"v":0,"d":"R0.00"}]
[null,"Voice Mailbox & Service","Fixed monthly fee per subscriber","Standard",{"v":1500,"d":"1,500"},null,{"v":0,"d":"R0.00"},{"v":1500,"d":"1,500"},null,{"v":0,"d":"R0.00"},{"v":1500,"d":"1,500"},null,{"v":0,"d":"R0.00"},{"v":1500,"d":"1,500"},null,{"$f":"O17*N17","v":{"v":0,"d":"R0.00"}},{"v":1500,"d":"1,500"},null,{"$f":"R17*Q17","v":{"v":0,"d":"R0.00"}}]
[null,"Inbound/Outbound Contact Centre Services","Cost per Transnet agent ","IVR",10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Advanced Service \n(with Multimedia)",200,null,{"v":0,"d":"R0.00"},200,null,{"v":0,"d":"R0.00"},200,null,{"v":0,"d":"R0.00"},200,null,{"v":0,"d":"R0.00"},200,null,{"v":0,"d":"R0.00"}]
[null,"Voice Switcboard-1 ","Basic fixed monthly rental fee","VIP",1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"Standard",6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"}]
[null,"Voice Recorder 60 sites with 10 000 hours per site","All CTC,NOC, Port Controls and Call Centers must be recorded",null,{"v":2000,"d":"2,000"},null,{"$f":"F22*E22","v":{"v":0,"d":"R0.00"}},{"v":2000,"d":"2,000"},null,{"v":0,"d":"R0.00"},{"v":2000,"d":"2,000"},null,{"v":0,"d":"R0.00"},{"v":2000,"d":"2,000"},null,{"v":0,"d":"R0.00"},{"v":2000,"d":"2,000"},null,{"v":0,"d":"R0.00"}]
[null,"Telephone Managenent System ( TMS )","TMS for 27,872 Extention lines ",null,1,null,{"$f":"F23*E23","v":{"v":0,"d":"R0.00"}},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"},1,null,{"v":0,"d":"R0.00"}]
[null,"Hosted PABX VoIP solution","Costing per unit ",null,{"v":27872,"d":"27,872"},null,{"$f":"F24*E24","v":{"v":0,"d":"R0.00"}},{"v":27872,"d":"27,872"},null,{"v":0,"d":"R0.00"},{"v":27872,"d":"27,872"},null,{"v":0,"d":"R0.00"},{"v":27872,"d":"27,872"},null,{"v":0,"d":"R0.00"},{"v":27872,"d":"27,872"},null,{"v":0,"d":"R0.00"}]
[null,"Flat rate billing for unmetered voice sites","Sites",null,106,null,{"$f":"F25*E25","v":{"v":0,"d":"R0.00"}},106,null,{"v":0,"d":"R0.00"},106,null,{"v":0,"d":"R0.00"},106,null,{"v":0,"d":"R0.00"},106,null,{"v":0,"d":"R0.00"}]
[null,"Telkom 0800 and associated PRIs","(specify units)",null,15,null,{"v":0,"d":"R0.00"},15,null,{"v":0,"d":"R0.00"},15,null,{"v":0,"d":"R0.00"},15,null,{"v":0,"d":"R0.00"},15,null,{"v":0,"d":"R0.00"}]
[null,"AudioCodes SBC’s Professional services and Support (360 hours for 5 years)","Professional service and support ( Not limited to 6 hours a month if not used, hours to be carried over in contract duration)",null,6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"},6,null,{"v":0,"d":"R0.00"}]
[null,"Geographical breakouts point with 2 Links on each site for Primary and secondary link (different Service providers), For this line item kindly populate on the breakout points TAB for the pricing.",null,null,1,null,null,1,null,null,1,null,null,1,null,null,1]
[null,"LTE’s currently deployed",null,null,98,null,{"v":0,"d":"R0.00"},98,null,{"v":0,"d":"R0.00"},98,null,{"v":0,"d":"R0.00"},98,null,{"v":0,"d":"R0.00"},98,null,{"v":0,"d":"R0.00"}]
[null,"Gateways currently running TPL Analogues",null,null,10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"},10,null,{"v":0,"d":"R0.00"}]
[{"$nulls":4},"MONTHLY TOTAL ( Incl. VAT)",null,{"$f":"SUM(G7:G30)","v":0},null,null,{"$f":"SUM(J7:J30)","v":0},null,null,{"$f":"SUM(M7:M30)","v":0},null,null,{"$f":"SUM(P7:P30)","v":0},null,null,{"$f":"SUM(S7:S30)","v":0}]
[{"$nulls":4}," ANNUAL SERVICE FEES ( Incl. VAT)",null,{"$f":"G31*12","v":0},null,null,{"$f":"J31*12","v":0},null,null,{"$f":"M31*12","v":0},null,null,{"$f":"P31*12","v":0},null,null,{"$f":"S31*12","v":0}]
{"$rows_empty":15}
[null," \n"]

{"sheet":"Breakout Points","index":4,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,0,1,16383],[2,0,13,0],[2,1,3,9]]}
[]
[]
[null,"Geographical breakouts point with 2 Links on each site for Primary and secondary link (different Service providers)"]
[]
[null,"Site Name","Bandwidth (MB)","Primary Access","Secondary Access","Unit Price Fibre ","Total Primary Access","Unit Price Microwave","Total Secondary Access","Total "]
[null,"East London",100,"Fibre","Microwave",null,{"$f":"C6*F6","v":0},null,{"$f":"C6*H6","v":0},{"$f":"G6+I6","v":0}]
[null,"Germiston",300,"Fibre","Fibre",null,{"$f":"C7*F7","v":0},null,{"$f":"C7*H7","v":0},{"$f":"G7+I7","v":0}]
[null,"Pretoria (NZASM Building)",200,"Fibre","Fibre",null,0,null,0,0]
[null,"Nelspruit",100,"Fibre","Microwave",null,0,null,0,0]
[null,"Durban (Queens’ warehouse)",250,"Fibre","Fibre",null,0,null,0,0]
[null,"Port Elizabeth (North-end)",100,"Fibre","Microwave",null,0,null,0,0]
[null,"Cape Town (Bellville)",200,"Fibre","Microwave",null,0,null,0,0]
[null,"Bloemfontein",100,"Fibre","Microwave",null,0,null,0,0]
[null,"Richards Bay",100,"Fibre","Microwave",null,0,null,0,0]
[{"$nulls":6},{"$f":"SUM(G6:G14)","v":0},null,{"$f":"SUM(I6:I14)","v":0},{"$f":"SUM(J6:J14)","v":0}]

{"sheet":"FTC-Disengagement","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[1,1,1,3],[2,4,4,5]]}
[]
[null,"FIXED TELEPHONE COMMUNICATION DISENGAGEMENT"]
[null,{"$f":"'FTC-Transition'!B4","v":"Name of Service Provider"},"Disengagement Fees",null,"NB: Estimated disengagement from Transnet is 3 months"]
[null,"Transnet"]
[]
[null,"Resource Category (itemize all charges)","Cost Breakdown  Per Month (Incl. VAT)","Description of Services / Comments"]
[null,"Project Team / Management ",0]
[null,"Hardware",0]
[null,"Testing",0]
[null,"Training",0]
[null,"Shipping/Handling/Storage",0]
[null,"Installation / build-out",0]
[null,"Third-party consulting and/or labour",0]
[null,"TOTAL TRANSITION FEES ( Incl. VAT)",{"$f":"SUM(C7:C13)","v":0}]
[null,"ANNUAL SERVICE FEES ( Incl. VAT)",{"$f":"C14*12","v":0}]

{"sheet":"CAPEX","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[1,1,1,5],[2,1,2,5],[3,0,4,2],[3,3,3,5],[4,3,4,5],[6,0,11,0],[12,3,12,4],[13,3,13,4]]}
[]
[null,"FIXED TELEPHONE COMMUNICATION MAINTANANCE AND SUPPORT SERVICES"]
[]
[{"$f":"'FTC-Transition'!B4","v":"Name of Service Provider"},null,null,"Year 1"]
[{"$nulls":3},"Purchase Price ( Incl. VAT)"]
["Resource Category","Resource Unit of Measure","Service Level","Baseline Quantity","Purchase Price Per\nUnit Cost"," Total Purchase Price"]
["MS Teams Devices","5 years AudioCodes OVOC\nLicense with Future upgrades",null,1,null,{"$f":"E7*D7","v":{"v":0,"d":"R0.00"}}]
[null,"License with Future upgrades",null,{"v":14546,"d":"14,546"},null,{"v":0,"d":"R0.00"}]
[null,"Executive User MS Teams fully compatible",null,159,null,{"v":0,"d":"R0.00"}]
[null,"Evolve2 65 Stereo MS Teams Headsets fully compatible",null,{"v":5944,"d":"5,944"},null,{"v":0,"d":"R0.00"}]
[null,"MS Teams boardrooms devices fully compatible",null,64,null,{"v":0,"d":"R0.00"}]
[null,"1 x SBC MS-Teams Compatible",null,1,null,{"v":0,"d":"R0.00"}]
[{"$nulls":3},"TOTAL ( Incl. VAT)",null,{"$f":"SUM(F7:F12)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":3},"ANNUAL SERVICE FEES ( Incl. VAT)",null,{"$f":"F13","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Resource Rates","index":7,"n_rows":37,"n_cols":7,"rows_kept":37,"merged":[[1,2,1,4],[4,2,4,4],[4,6,5,6],[23,2,23,4],[23,6,24,6]]}
[]
[null,"Hourly Rate Sheet"]
[null,"Transnet"]
[]
[null,"Minimum 1 Month Engagement","Onsite Hourly Rates",{"$nulls":3},"Provider Job Title - Reference Mapping "]
[null,"Job Title / Labour Category ","Senior","Middle","Junior"]
[null,"Network Architecture Specialist"]
[null,"Network Design Engineer"]
[null,"L1 Support Engineer"]
[null,"L2 Support Engineer"]
[null,"L3 Support Engineer"]
[null,"Voice services Specialist"]
[null,"Programme Manager"]
[null,"Project Manager"]
[null,"Project Administrator"]
[null,"Security Analyst"]
[null,"Security Architect"]
[null,"Security Systems Engineer"]
[null,"Other (specify"]
[null,"Other (specify"]
[null,"Other (specify"]
[null,"Other (specify"]
[]
[null,"Minimum 3 Month Engagement","Onsite Hourly Rates",{"$nulls":3},"Provider Job Title - Reference Mapping "]
[null,"Job Title / Labour Category ","Senior","Middle","Junior"]
[null,"Network Architecture Specialist"]
[null,"Network Design Engineer"]
[null,"L1 Support Engineer"]
[null,"L2 Support Engineer"]
[null,"L3 Support Engineer"]
[null,"Voice Services Specialist"]
[null,"Programme Manager"]
[null,"Project Manager"]
[null,"Project Administrator"]
[null,"Security Analyst"]
[null,"Security Architect"]
[null,"Security Systems Engineer"]

{"sheet":"Scn 2 Voice - Recurring","index":8,"n_rows":56,"n_cols":14,"rows_kept":56,"hidden":true,"merged":[[1,4,1,5],[2,7,4,12],[6,1,6,2],[8,1,9,3],[8,4,8,6],[8,7,8,9],[8,10,8,12],[9,4,9,6],[9,7,9,9],[9,10,9,12],[11,1,12,1],[11,2,12,2],[13,1,22,1],[13,2,17,2],[18,2,22,2],[23,0,27,0],[23,1,27,1],[28,1,31,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[31,4,31,13],[34,1,35,1],[34,2,35,2],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[45,1,46,2],[45,3,45,5],[45,6,45,8],[45,9,45,11],[46,3,46,5],[46,6,46,8],[46,9,46,11],[47,12,47,13],[52,13,52,14],[53,13,53,14],[54,13,54,14]]}
[]
[null,"Voice Services ","Recurring Fees",null,"Click links for ",null,null,"Notes"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"TOC page","Pricing Assumptions",null,"1:  - Price in South African Rand. Assume 0% Annual Inflation Rate. \n2: - All new CPPE devices are leased to own model (no residual at end of lease term[3 years]) Service Provider to be the Lessor. \n3:- NOTE: Assume greenfields for all Back Office PBX, gateway equipment for this pricing\nThis Scenario is contingent on the network being sized to support this traffic as follows: \n4: - NOTE: ALL WAN bandwidth costs required to support VOIP calls for your quoted solution must be included in the WAN Service pricing\n5: - NOTE: Any extension or expansion of the LAN required to underpin this service will be done and priced in the LAN Tower.\n"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Scenario Description\nNew centralised Voice infrastructure based on IP with all the infrastructure being owned by Transnet (Front office CPPE and Back Office PBX platforms, gateways ) Note: Contact centre is a hosted SP owned service"]
[]
[null,"Supplier Provided Services",null,null,"Year 1",null,null,"Year 2",null,null,"Year 3"]
[{"$nulls":4},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Resource Category","Resource Unit of Measure","Service Level","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Description of Services / Comments"]
[null,"Voice Subscibers","Basic fixed monthly rental fee","VIP",{"$f":"SUM(E14:E18)*0.05","v":{"v":1321,"d":"1,321"}},0,{"$f":"E12*F12","v":0},{"v":1500,"d":"1,500"},0,{"$f":"H12*I12","v":0},{"v":1500,"d":"1,500"},0,{"$f":"K12*L12","v":0}]
[{"$nulls":3},"Standard",{"$f":"SUM(E14:E18)*0.95","v":{"v":25105,"d":"25,105"}},0,0,{"v":25000,"d":"25,000"},0,0,{"v":26500,"d":"26,500"},0,0]
[null,"Voice CPPE devices\n","Lease to Own Model monthly payment\n","Basic (IP)",{"v":15386,"d":"15,386"},0,0,{"$f":"H13*0.66","v":{"v":16500,"d":"16,500"}},0,0,{"$f":"K13*0.66","v":{"v":17490,"d":"17,490"}},0,0]
[{"$nulls":3},"Intermediate (IP)",{"v":4533,"d":"4,533"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Fax to IP",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Advanced (IP)",{"v":2169,"d":"2,169"},0,{"$f":"E17*F17","v":0},{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,{"$f":"H17*I17","v":0},{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,{"$f":"K17*L17","v":0}]
[{"$nulls":3},"Softphone",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[null,null,"Ongoing monthly maintenance fee","Basic (IP)",{"v":15386,"d":"15,386"},0,0,{"$f":"H13*0.66","v":{"v":16500,"d":"16,500"}},0,0,{"$f":"K13*0.66","v":{"v":17490,"d":"17,490"}},0,0]
[{"$nulls":3},"Intermediate (IP)",{"v":4533,"d":"4,533"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Fax to IP",{"v":2169,"d":"2,169"},0,{"$f":"E21*F21","v":0},{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,{"$f":"H21*I21","v":0},{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,{"$f":"K21*L21","v":0}]
[{"$nulls":3},"Advanced (IP)",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Softphone",{"v":2169,"d":"2,169"},0,{"$f":"E23*F23","v":0},{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,{"$f":"H23*I23","v":0},{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,{"$f":"K23*L23","v":0}]
[null,"Voice Service Build and Change (IMACD)\nper month\n\n","Install","Qty of Installs",50,0,0,50,0,0,50,0,0]
[null,null,"Move","Qty of Moves",50,0,0,50,0,0,50,0,0]
[null,null,"Add","Qty of Adds",0,0,0,0,0,0,0,0,0]
[null,null,"Change","Qty of Changes",0,0,0,0,0,0,0,0,0]
[null,null,"Dismantlement","Qty of Disposals",10,0,0,10,0,0,10,0,0]
[null,"Call Rates","On-net per second (confirm that this is zero cost)",null,{"v":157752000,"d":"157,752,000"},0,0,{"$f":"E29+(E29*0.08)","v":{"v":170372160,"d":"170,372,160"}},0,0,{"$f":"H29+(H29*0.06)","v":{"v":180594490,"d":"180,594,490"}},0,0]
[null,null,"Off-net per second (Local & National Average Landline)",null,{"v":106000000,"d":"106,000,000"},0,0,{"$f":"E30+(E30*0.08)","v":{"v":114480000,"d":"114,480,000"}},0,0,{"$f":"H30+(H30*0.06)","v":{"v":121348800,"d":"121,348,800"}},0,0]
[null,null,"Off-net per second (To Cellular networks)",null,{"v":156500000,"d":"156,500,000"},0,0,{"$f":"E31+(E31*0.08)","v":{"v":169020000,"d":"169,020,000"}},0,0,{"$f":"H31+(H31*0.06)","v":{"v":179161200,"d":"179,161,200"}},0,0]
[null,null,"Maintain schedule of International call  tariffs"]
[null,"Voice Logging","Fixed monthly fee per subscriber","Standard",15,0,0,15,0,0,15,0,0]
[null,"Voice Mailbox & Service (catch & despatch to UC mailbox)\nE mail delivery platform is the responsibility of Transnet (Email delivery Platform)","Fixed monthly fee per subscriber","Standard",null,0,0,{"$f":"SUM(H13:H13)","v":{"v":25000,"d":"25,000"}},0,0,{"$f":"SUM(K13:K13)","v":{"v":26500,"d":"26,500"}},0,0]
[null,"Contact Centre Services","Cost per physical agent","Basic Service \n(ACD only)",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Advanced Service \n(ACD, IVR, Voice Logging, etc.)",{"v":3000,"d":"3,000"},0,0,{"v":3000,"d":"3,000"},0,0,{"v":3000,"d":"3,000"},0,0]
[null,"Security Services","To cover cost of all security activities for the service",null,1,0,0,1,null,0,1,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[{"$nulls":5},"MONTHLY FEE FOR SERVICES",{"$f":"SUM(G12:G41)","v":0},null,null,{"$f":"SUM(J12:J41)","v":0},null,null,{"$f":"SUM(M12:M41)","v":0}]
[{"$nulls":5},"ANNUAL FEE ",{"$f":"+G42*12","v":0},null,null,{"$f":"+J42*12","v":0},null,null,{"$f":"+M42*12","v":0}]
[]
[null,"NOTE: Complete only if there are Pass-Through charges"]
[null,"Pass-through Charges (Service Management Tools, Third-party provided products, services, and/or project expenses) ",null,"Year 1",null,null,"Year 2",null,null,"Year 3"]
[{"$nulls":3},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Pass-Through Description","Unit of Measure","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Description of Services / Comments"]
[null,"Service Management Tools ",null,1,null,{"$f":"D49*E49","v":0},1,null,{"$f":"G49*H49","v":0},1,null,{"$f":"J49*K49","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D50*E50","v":0},null,null,{"$f":"G50*H50","v":0},null,null,{"$f":"J50*K50","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D51*E51","v":0},null,null,{"$f":"G51*H51","v":0},null,null,{"$f":"J51*K51","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D52*E52","v":0},null,null,{"$f":"G52*H52","v":0},null,null,{"$f":"J52*K52","v":0}]
[{"$nulls":4},"MONTHLY TOTAL PASS-THROUGH",{"$f":"SUM(F49:F52)","v":0},null,null,{"$f":"SUM(I49:I52)","v":0},null,null,{"$f":"SUM(L49:L52)","v":0}]
[{"$nulls":4}," ANNUAL SERVICE FEES ",{"$f":"+F53*12","v":0},null,null,{"$f":"+I53*12","v":0},null,null,{"$f":"+L53*12","v":0}]
[]
[{"$nulls":4}," ANNUAL TOTAL SERVICE CHARGES",{"$f":"G43+F54","v":0},null,null,{"$f":"J43+I54","v":0},null,null,{"$f":"M43+L54","v":0}]

{"sheet":"Scn 3 Voice - Recurring","index":9,"n_rows":56,"n_cols":14,"rows_kept":56,"hidden":true,"merged":[[1,4,1,5],[2,7,4,12],[6,1,6,2],[8,1,9,3],[8,4,8,6],[8,7,8,9],[8,10,8,12],[9,4,9,6],[9,7,9,9],[9,10,9,12],[11,1,12,1],[11,2,12,2],[13,1,22,1],[13,2,17,2],[18,2,22,2],[23,0,27,0],[23,1,27,1],[28,1,31,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[31,4,31,13],[34,1,35,1],[34,2,35,2],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[45,1,46,2],[45,3,45,5],[45,6,45,8],[45,9,45,11],[46,3,46,5],[46,6,46,8],[46,9,46,11],[47,12,47,13],[52,13,52,14],[53,13,53,14],[54,13,54,14]]}
[]
[null,"Voice Services ","Recurring Fees",null,"Click links for ",null,null,"Notes"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"TOC page","Pricing Assumptions",null,"1:  - Price in South African Rand. Assume 0% Annual Inflation Rate. \n2: - All new CPPE devices are leased to own model (no residual at end of lease term) Service Provider to be the Lessor. \nThis Scenario is contingent on the network being sized to support this traffic as follows: \n3: - NOTE: ALL WAN bandwidth costs required to support VOIP calls for your quoted solution must be included in the WAN Service pricing\n4: - NOTE: Any extension or expansion of the LAN required to underpin this service will be done and priced in the LAN Tower.\n"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Scenario Description\nNew centralised Voice infrastructure based on IP with all the infrastructure being owned by the Service Provider (Back Office PBX platforms, gateways,  Note: excludes CPPE devices which are owned by Transnet)"]
[]
[null,"Supplier Provided Services",null,null,"Year 1",null,null,"Year 2",null,null,"Year 3"]
[{"$nulls":4},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Resource Category","Resource Unit of Measure","Service Level","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Description of Services / Comments"]
[null,"Voice Subscibers","Basic fixed monthly rental fee","VIP",{"$f":"SUM(E14:E18)*0.05","v":{"v":1321,"d":"1,321"}},0,{"$f":"E12*F12","v":0},{"v":1500,"d":"1,500"},0,{"$f":"H12*I12","v":0},{"v":1500,"d":"1,500"},0,{"$f":"K12*L12","v":0}]
[{"$nulls":3},"Standard",{"$f":"SUM(E14:E18)*0.95","v":{"v":25105,"d":"25,105"}},0,0,{"v":25000,"d":"25,000"},0,0,{"v":26500,"d":"26,500"},0,0]
[null,"Voice CPPE devices\n","Lease to Own Model monthly payment\n","Basic (IP)",{"v":15386,"d":"15,386"},0,0,{"$f":"H13*0.66","v":{"v":16500,"d":"16,500"}},0,0,{"$f":"K13*0.66","v":{"v":17490,"d":"17,490"}},0,0]
[{"$nulls":3},"Intermediate (IP)",{"v":4533,"d":"4,533"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Fax to IP",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Advanced (IP)",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Softphone",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[null,null,"Ongoing monthly maintenance fee","Basic (IP)",{"v":15386,"d":"15,386"},0,0,{"$f":"H13*0.66","v":{"v":16500,"d":"16,500"}},0,0,{"$f":"K13*0.66","v":{"v":17490,"d":"17,490"}},0,0]
[{"$nulls":3},"Intermediate (IP)",{"v":4533,"d":"4,533"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Fax to IP",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Advanced (IP)",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[{"$nulls":3},"Softphone",{"v":2169,"d":"2,169"},0,0,{"$f":"H13*0.2","v":{"v":5000,"d":"5,000"}},0,0,{"$f":"K13*0.2","v":{"v":5300,"d":"5,300"}},0,0]
[null,"Voice Service Build and Change (IMACD)\nper month\n\n","Install","Qty of Installs",50,0,0,50,0,0,50,0,0]
[null,null,"Move","Qty of Moves",50,0,0,50,0,0,50,0,0]
[null,null,"Add","Qty of Adds",0,0,0,0,0,0,0,0,0]
[null,null,"Change","Qty of Changes",0,0,0,0,0,0,0,0,0]
[null,null,"Dismantlement","Qty of Disposals",10,0,0,10,0,0,10,0,0]
[null,"Call Rates","On-net per second (confirm that this is zero cost)",null,{"v":157752000,"d":"157,752,000"},0,0,{"$f":"E29+(E29*0.08)","v":{"v":170372160,"d":"170,372,160"}},0,0,{"$f":"H29+(H29*0.06)","v":{"v":180594490,"d":"180,594,490"}},0,0]
[null,null,"Off-net per second (Local & National Average Landline)",null,{"v":106000000,"d":"106,000,000"},0,0,{"$f":"E30+(E30*0.08)","v":{"v":114480000,"d":"114,480,000"}},0,0,{"$f":"H30+(H30*0.06)","v":{"v":121348800,"d":"121,348,800"}},0,0]
[null,null,"Off-net per second (To Cellular networks)",null,{"v":156500000,"d":"156,500,000"},0,0,{"$f":"E31+(E31*0.08)","v":{"v":169020000,"d":"169,020,000"}},0,0,{"$f":"H31+(H31*0.06)","v":{"v":179161200,"d":"179,161,200"}},0,0]
[null,null,"Maintain schedule of International call  tariffs"]
[null,"Voice Logging","Fixed monthly fee per subscriber","Standard",15,0,0,15,0,0,15,0,0]
[null,"Voice Mailbox & Service (catch & despatch to UC mailbox)\nE mail delivery platform is the responsibility of Transnet (Email delivery Platform)","Fixed monthly fee per subscriber","Standard",null,0,0,{"$f":"SUM(H13:H13)","v":{"v":25000,"d":"25,000"}},0,0,{"$f":"SUM(K13:K13)","v":{"v":26500,"d":"26,500"}},0,0]
[null,"Contact Centre Services","Cost per physical agent","Basic Service \n(ACD only)",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Advanced Service \n(ACD, IVR, Voice Logging, etc.)",{"v":3000,"d":"3,000"},0,0,{"v":3000,"d":"3,000"},0,0,{"v":3000,"d":"3,000"},0,0]
[null,"Security Services","To cover cost of all security activities for the service",null,1,0,0,1,null,0,1,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,0,0,0,0,null,0,0,null,0]
[{"$nulls":5},"MONTHLY FEE FOR SERVICES",{"$f":"SUM(G12:G41)","v":0},null,null,{"$f":"SUM(J12:J41)","v":0},null,null,{"$f":"SUM(M12:M41)","v":0}]
[{"$nulls":5},"ANNUAL FEE ",{"$f":"+G42*12","v":0},null,null,{"$f":"+J42*12","v":0},null,null,{"$f":"+M42*12","v":0}]
[]
[null,"NOTE: Complete only if there are Pass-Through charges"]
[null,"Pass-through Charges (Service Management Tools, Third-party provided products, services, and/or project expenses) ",null,"Year 1",null,null,"Year 2",null,null,"Year 3"]
[{"$nulls":3},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Pass-Through Description","Unit of Measure","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Description of Services / Comments"]
[null,"Service Management Tools ",null,1,null,{"$f":"D49*E49","v":0},1,null,{"$f":"G49*H49","v":0},1,null,{"$f":"J49*K49","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D50*E50","v":0},null,null,{"$f":"G50*H50","v":0},null,null,{"$f":"J50*K50","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D51*E51","v":0},null,null,{"$f":"G51*H51","v":0},null,null,{"$f":"J51*K51","v":0}]
[null,"[list any other pass-throughs]",{"$nulls":3},{"$f":"D52*E52","v":0},null,null,{"$f":"G52*H52","v":0},null,null,{"$f":"J52*K52","v":0}]
[{"$nulls":4},"MONTHLY TOTAL PASS-THROUGH",{"$f":"SUM(F49:F52)","v":0},null,null,{"$f":"SUM(I49:I52)","v":0},null,null,{"$f":"SUM(L49:L52)","v":0}]
[{"$nulls":4}," ANNUAL SERVICE FEES ",{"$f":"+F53*12","v":0},null,null,{"$f":"+I53*12","v":0},null,null,{"$f":"+L53*12","v":0}]
[]
[{"$nulls":4}," ANNUAL TOTAL SERVICE CHARGES",{"$f":"G43+F54","v":0},null,null,{"$f":"J43+I54","v":0},null,null,{"$f":"M43+L54","v":0}]

{"sheet":"Scn 2 LAN - Recurring","index":10,"n_rows":59,"n_cols":21,"rows_kept":59,"hidden":true,"merged":[[1,5,1,6],[2,8,4,13],[3,1,3,2],[4,1,4,2],[6,1,6,2],[8,1,9,3],[8,5,8,7],[8,8,8,10],[8,11,8,13],[8,14,8,16],[8,17,8,19],[9,5,9,7],[9,8,9,10],[9,11,9,13],[9,14,9,16],[9,17,9,19],[11,1,18,1],[19,1,21,1],[19,2,21,2],[22,0,26,0],[22,1,28,1],[29,0,31,0],[29,1,31,1],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[47,1,48,2],[47,3,47,6],[47,7,47,9],[47,10,47,12],[47,13,47,15],[47,16,47,18],[48,3,48,6],[48,7,48,9],[48,10,48,12],[48,13,48,15],[48,16,48,18],[55,20,55,21],[56,20,56,21],[57,20,57,21]]}
[]
[null,"LAN Services ","Recurring Fees",null,null,"Click links for ",null,null,"Notes"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":3},"TOC page","Pricing Assumptions",null,"1:  - Price in South African Rand. Assume 0% Annual Inflation Rate. \n2: - All cabling is owned by Transnet and must NOT be factored into the LAN per port costs. Guidance as follows:\n        i) All cabling to be used for IMACDs must be included in the IMACD tariff with ownership of the associated cabling plant becoming Transnet assets\n        ii) For in scope cabling requiring replacement as part of a repair incident the cabling material costs will be recovered for this (see cabling material costs line item below)\n"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Scenario Description\nLAN Services to be priced per switch"]
[]
[null,"Supplier Provided Services",{"$nulls":3},"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5"]
[{"$nulls":5},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Resource Category","Unit of Measure","Service Level","Service Window","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Baseline Quantity","Monthly \nUnit Cost","Monthly Total","Description of Services / Comments"]
[null,"Wired LAN Switches","Access 8 Port","Bronze","Standard",{"v":1344,"d":"1,344"},{"v":144.91,"d":"R144.91"},{"v":194759.04,"d":"R194,759.04"},{"v":1357,"d":"1,357"},{"v":115.93,"d":"R115.93"},{"v":157317.01,"d":"R157,317.01"},{"v":1371,"d":"1,371"},{"v":97.38,"d":"R97.38"},{"v":133507.98,"d":"R133,507.98"},{"v":1385,"d":"1,385"},{"v":89.59,"d":"R89.59"},{"v":124082.15,"d":"R124,082.15"},{"v":1399,"d":"1,399"},{"v":82.42,"d":"R82.42"},{"v":115305.58,"d":"R115,305.58"}]
[null,null,"Access 24 Port","Bronze","Standard",{"v":1344,"d":"1,344"},{"v":595.88,"d":"R595.88"},{"v":800862.72,"d":"R800,862.72"},{"v":1357,"d":"1,357"},{"v":476.7,"d":"R476.70"},{"v":646881.9,"d":"R646,881.90"},{"v":1371,"d":"1,371"},{"v":400.43,"d":"R400.43"},{"v":548989.53,"d":"R548,989.53"},{"v":1385,"d":"1,385"},{"v":368.4,"d":"R368.40"},{"v":510234,"d":"R510,234.00"},{"v":1399,"d":"1,399"},{"v":338.93,"d":"R338.93"},{"v":474163.07,"d":"R474,163.07"}]
[null,null,"Access 48 Port","Bronze","Extended",650,{"v":1643.44,"d":"R1,643.44"},{"v":1068236,"d":"R1,068,236.00"},657,{"v":1314.75,"d":"R1,314.75"},{"v":863790.75,"d":"R863,790.75"},664,{"v":1104.39,"d":"R1,104.39"},{"v":733314.96,"d":"R733,314.96"},671,{"v":1016.04,"d":"R1,016.04"},{"v":681762.84,"d":"R681,762.84"},678,{"v":934.76,"d":"R934.76"},{"v":633767.28,"d":"R633,767.28"}]
[null,null,"Access 48 Port","Silver","Extended",217,{"v":1972.12,"d":"R1,972.12"},{"v":427950.04,"d":"R427,950.04"},219,{"v":1577.7,"d":"R1,577.70"},{"v":345516.3,"d":"R345,516.30"},221,{"v":1325.27,"d":"R1,325.27"},{"v":292884.67,"d":"R292,884.67"},223,{"v":1219.25,"d":"R1,219.25"},{"v":271892.75,"d":"R271,892.75"},225,{"v":1121.71,"d":"R1,121.71"},{"v":252384.75,"d":"R252,384.75"}]
[null,null,"Access 48 Port","Gold","Premium",217,{"v":3081.44,"d":"R3,081.44"},{"v":668672.48,"d":"R668,672.48"},219,{"v":2465.15,"d":"R2,465.15"},{"v":539867.85,"d":"R539,867.85"},221,{"v":2070.73,"d":"R2,070.73"},{"v":457631.33,"d":"R457,631.33"},223,{"v":1905.07,"d":"R1,905.07"},{"v":424830.61,"d":"R424,830.61"},225,{"v":1752.66,"d":"R1,752.66"},{"v":394348.5,"d":"R394,348.50"}]
[null,null,"Distribution 12 x 1 Gbps","Bronze","Standard",648,{"v":1136.87,"d":"R1,136.87"},{"v":736691.76,"d":"R736,691.76"},654,{"v":909.5,"d":"R909.50"},{"v":594813,"d":"R594,813.00"},661,{"v":763.98,"d":"R763.98"},{"v":504990.78,"d":"R504,990.78"},668,{"v":702.86,"d":"R702.86"},{"v":469510.48,"d":"R469,510.48"},675,{"v":646.63,"d":"R646.63"},{"v":436475.25,"d":"R436,475.25"}]
[null,null,"Distribution 12 x 1 Gbps","Gold","Premium",84,{"v":2557.96,"d":"R2,557.96"},{"v":214868.64,"d":"R214,868.64"},85,{"v":2046.37,"d":"R2,046.37"},{"v":173941.45,"d":"R173,941.45"},86,{"v":1718.95,"d":"R1,718.95"},{"v":147829.7,"d":"R147,829.70"},87,{"v":1581.43,"d":"R1,581.43"},{"v":137584.41,"d":"R137,584.41"},88,{"v":1454.92,"d":"R1,454.92"},{"v":128032.96,"d":"R128,032.96"}]
[null,null,"Core Configurable","Gold","Premium",28,{"v":14013.2,"d":"R14,013.20"},{"v":392369.6,"d":"R392,369.60"},28,{"v":11210.56,"d":"R11,210.56"},{"v":313895.68,"d":"R313,895.68"},28,{"v":9416.87,"d":"R9,416.87"},{"v":263672.36,"d":"R263,672.36"},28,{"v":8663.52,"d":"R8,663.52"},{"v":242578.56,"d":"R242,578.56"},28,{"v":7970.44,"d":"R7,970.44"},{"v":223172.32,"d":"R223,172.32"}]
[null,"Wireless LAN Access Points\n(To include all controllers and management solutions)","Qty of Wireless LAN Access Points","Gold",null,537,{"v":1537.2,"d":"R1,537.20"},{"v":825476.4,"d":"R825,476.40"},564,{"v":1229.76,"d":"R1,229.76"},{"v":693584.64,"d":"R693,584.64"},592,{"v":1033,"d":"R1,033.00"},{"v":611536,"d":"R611,536.00"},622,{"v":950.36,"d":"R950.36"},{"v":591123.92,"d":"R591,123.92"},653,{"v":874.33,"d":"R874.33"},{"v":570937.49,"d":"R570,937.49"}]
[{"$nulls":3},"Silver",null,0,{"v":1098,"d":"R1,098.00"},0,0,{"v":878.4,"d":"R878.40"},0,0,{"v":737.86,"d":"R737.86"},0,0,{"v":678.83,"d":"R678.83"},0,0,{"v":624.52,"d":"R624.52"},0]
[{"$nulls":3},"Bronze",null,197,{"v":732,"d":"R732.00"},{"v":144204,"d":"R144,204.00"},207,{"v":585.6,"d":"R585.60"},{"v":121219.2,"d":"R121,219.20"},217,{"v":491.9,"d":"R491.90"},{"v":106742.3,"d":"R106,742.30"},228,{"v":452.55,"d":"R452.55"},{"v":103181.4,"d":"R103,181.40"},239,{"v":416.35,"d":"R416.35"},{"v":99507.65,"d":"R99,507.65"}]
[null,"LAN Service Build and Change (IMACD) per port. Includes up to 80m Cat5e cable or better","Install","Qty of Installs",null,550,{"v":852.6,"d":"R852.60"},{"v":468930,"d":"R468,930.00"},606,{"v":920.81,"d":"R920.81"},{"v":558010.86,"d":"R558,010.86"},665,{"v":994.47,"d":"R994.47"},{"v":661322.55,"d":"R661,322.55"},698,{"v":1074.03,"d":"R1,074.03"},{"v":749672.94,"d":"R749,672.94"},733,{"v":1159.95,"d":"R1,159.95"},{"v":850243.35,"d":"R850,243.35"}]
[null,null,"Move","Qty of Moves",null,275,{"v":852.6,"d":"R852.60"},{"v":234465,"d":"R234,465.00"},303,{"v":920.81,"d":"R920.81"},{"v":279005.43,"d":"R279,005.43"},333,{"v":994.47,"d":"R994.47"},{"v":331158.51,"d":"R331,158.51"},350,{"v":1074.03,"d":"R1,074.03"},{"v":375910.5,"d":"R375,910.50"},368,{"v":1159.95,"d":"R1,159.95"},{"v":426861.6,"d":"R426,861.60"}]
[null,null,"Add","Qty of Adds",null,110,{"v":852.6,"d":"R852.60"},{"v":93786,"d":"R93,786.00"},121,{"v":920.81,"d":"R920.81"},{"v":111418.01,"d":"R111,418.01"},133,{"v":994.47,"d":"R994.47"},{"v":132264.51,"d":"R132,264.51"},140,{"v":1074.03,"d":"R1,074.03"},{"v":150364.2,"d":"R150,364.20"},147,{"v":1159.95,"d":"R1,159.95"},{"v":170512.65,"d":"R170,512.65"}]
[null,null,"Change","Qty of Changes",null,110,{"v":852.6,"d":"R852.60"},{"v":93786,"d":"R93,786.00"},121,{"v":920.81,"d":"R920.81"},{"v":111418.01,"d":"R111,418.01"},133,{"v":994.47,"d":"R994.47"},{"v":132264.51,"d":"R132,264.51"},140,{"v":1074.03,"d":"R1,074.03"},{"v":150364.2,"d":"R150,364.20"},147,{"v":1159.95,"d":"R1,159.95"},{"v":170512.65,"d":"R170,512.65"}]
[null,null,"Dismantlement","Qty of Dismantlement's",null,55,{"v":852.6,"d":"R852.60"},{"v":46893,"d":"R46,893.00"},61,{"v":920.81,"d":"R920.81"},{"v":56169.41,"d":"R56,169.41"},67,{"v":994.47,"d":"R994.47"},{"v":66629.49,"d":"R66,629.49"},70,{"v":1074.03,"d":"R1,074.03"},{"v":75182.1,"d":"R75,182.10"},74,{"v":1159.95,"d":"R1,159.95"},{"v":85836.3,"d":"R85,836.30"}]
[null,null,"Standard Site Survey (Indoor)","Qty of Surveys",null,68,{"v":1040,"d":"R1,040.00"},{"v":70720,"d":"R70,720.00"},68,{"v":1123.2,"d":"R1,123.20"},{"v":76377.6,"d":"R76,377.60"},68,{"v":1213.06,"d":"R1,213.06"},{"v":82488.08,"d":"R82,488.08"},68,{"v":1310.1,"d":"R1,310.10"},{"v":89086.8,"d":"R89,086.80"},68,{"v":1414.91,"d":"R1,414.91"},{"v":96213.88,"d":"R96,213.88"}]
[null,null,"Standard Site Survey (Outdoor, workshop/campus environments)","Qty of Surveys",null,8,{"v":2350,"d":"R2,350.00"},{"v":18800,"d":"R18,800.00"},8,{"v":2538,"d":"R2,538.00"},{"v":20304,"d":"R20,304.00"},8,{"v":2741.04,"d":"R2,741.04"},{"v":21928.32,"d":"R21,928.32"},8,{"v":2960.32,"d":"R2,960.32"},{"v":23682.56,"d":"R23,682.56"},8,{"v":3197.15,"d":"R3,197.15"},{"v":25577.2,"d":"R25,577.20"}]
[null,"Cabling Material Costs \n\nFor cabling material required to repair existing in scope cabling faults","UTP cable (Cat5e or better)","Per 100metre run",null,1,{"v":892.21,"d":"R892.21"},{"v":892.21,"d":"R892.21"},null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,"Multimode Fibre up to 24-core","Per running metre",null,1,{"v":21.11,"d":"R21.11"},{"v":21.11,"d":"R21.11"},null,0,0,null,0,0,null,0,0,null,0,0]
[null,null,"Single mode Fibre up to 24-core","Per running metre",null,1,{"v":9.1,"d":"R9.10"},{"v":9.1,"d":"R9.10"},null,0,0,null,0,0,null,0,0,null,0,0]
[null,"Security Services","To cover cost of all security activities for the service",null,null,1,0,0,1,null,0,1,null,0,1,null,0,1,null,0]
[null,"Cisco ISE and Prime",{"$nulls":3},1,0,0,1,0,0,1,0,0,1,0,0,1,0,0]
[null,"Other (specify)","(specify units)",null,null,1,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[null,"Other (specify)","(specify units)",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0]
[{"$nulls":6},"MONTHLY FEE FOR SERVICES",{"$f":"SUM(H12:H36)","v":{"v":6502393.1,"d":"R6,502,393.10"}},null,null,{"$f":"SUM(K12:K36)","v":{"v":5663531.1,"d":"R5,663,531.10"}},null,null,{"$f":"SUM(N12:N36)","v":{"v":5229155.58,"d":"R5,229,155.58"}},null,null,{"$f":"SUM(Q12:Q36)","v":{"v":5171044.42,"d":"R5,171,044.42"}},null,null,{"$f":"SUM(T12:T36)","v":{"v":5153852.48,"d":"R5,153,852.48"}}]
[{"$nulls":6},"ANNUAL FEE ",{"$f":"+H37*12","v":{"v":78028717.2,"d":"R78,028,717.20"}},null,null,{"$f":"+K37*12","v":{"v":67962373.2,"d":"R67,962,373.20"}},null,null,{"$f":"+N37*12","v":{"v":62749866.96,"d":"R62,749,866.96"}},null,null,{"$f":"+Q37*12","v":{"v":62052533.04,"d":"R62,052,533.04"}},null,null,{"$f":"+T37*12","v":{"v":61846229.76,"d":"R61,846,229.76"}}]
{"$rows_empty":8}
[null,"NOTE: Complete only if there are Pass-Through charges"]
[null,"Pass-through Charges (Service Management Tools, Third-party provided products, services, and/or project expenses) ",null,"Year 1",{"$nulls":3},"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5"]
[{"$nulls":3},"Price Per Month ",{"$nulls":3},"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month ",null,null,"Price Per Month "]
[null,"Pass-Through Description","Unit of Measure","Planned Quantity",null,"Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total","Planned Quantity","Monthly \nUnit Cost","Monthly Total"]
[null,"Service Management Tools ",null,1,null,null,{"$f":"D51*F51","v":0},1,null,{"$f":"H51*I51","v":{"v":0,"d":"R 0"}},1,null,{"$f":"K51*L51","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K51*O51","v":{"v":0,"d":"R 0"}},null,null,{"$f":"N51*R51","v":{"v":0,"d":"R 0"}}]
[null,"Storage and Logistics",{"$nulls":4},{"$f":"D52*F52","v":0},null,null,{"$f":"H52*I52","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K52*L52","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K52*O52","v":{"v":0,"d":"R 0"}},null,null,{"$f":"N52*R52","v":{"v":0,"d":"R 0"}}]
[null,"[list any other pass-throughs]",{"$nulls":4},{"$f":"D53*F53","v":0},null,null,{"$f":"H53*I53","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K53*L53","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K53*O53","v":{"v":0,"d":"R 0"}},null,null,{"$f":"N53*R53","v":{"v":0,"d":"R 0"}}]
[null,"[list any other pass-throughs]",{"$nulls":4},{"$f":"D54*F54","v":0},null,null,{"$f":"H54*I54","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K54*L54","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K54*O54","v":{"v":0,"d":"R 0"}},null,null,{"$f":"N54*R54","v":{"v":0,"d":"R 0"}}]
[null,"[list any other pass-throughs]",{"$nulls":4},{"$f":"D55*F55","v":0},null,null,{"$f":"H55*I55","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K55*L55","v":{"v":0,"d":"R 0"}},null,null,{"$f":"K55*O55","v":{"v":0,"d":"R 0"}},null,null,{"$f":"N55*R55","v":{"v":0,"d":"R 0"}}]
[{"$nulls":5},"MONTHLY TOTAL PASS-THROUGH",{"$f":"SUM(G51:G55)","v":0},null,null,{"$f":"SUM(J51:J55)","v":0},null,null,{"$f":"SUM(M51:M55)","v":0},null,null,{"$f":"SUM(P51:P55)","v":0},null,null,{"$f":"SUM(S51:S55)","v":0}]
[{"$nulls":5}," ANNUAL SERVICE FEES ",{"$f":"+G56*12","v":0},null,null,{"$f":"+J56*12","v":0},null,null,{"$f":"+M56*12","v":0},null,null,{"$f":"+P56*12","v":0},null,null,{"$f":"+S56*12","v":0}]
[]
[{"$nulls":5}," ANNUAL TOTAL SERVICE CHARGES",{"$f":"H38+G57","v":{"v":78028717.2,"d":"R78,028,717.20"}},null,null,{"$f":"K38+J57","v":{"v":67962373.2,"d":"R67,962,373.20"}},null,null,{"$f":"N38+M57","v":{"v":62749866.96,"d":"R62,749,866.96"}},null,null,{"$f":"Q38+P57","v":{"v":62052533.04,"d":"R62,052,533.04"}},null,null,{"$f":"T38+S57","v":{"v":61846229.76,"d":"R61,846,229.76"}}]