{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["BASE Router BoQ","CC Sub-Components","Technical S&M Sub-Components"],"read":"whole","date_system":"1900"}

{"sheet":"BASE Router BoQ","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,0,0,6],[1,1,1,6],[3,1,5,1],[3,7,5,7],[6,1,6,5],[7,1,7,6],[9,1,14,1],[9,2,14,2],[15,1,15,6],[18,1,18,6],[20,1,21,1]]}
["PRICING SCHEDULE"]
[1,"Communnications Controller / Virtual RTU"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
[1.1,"Master-station \nSupply & Install Items \n","Once-off cost per site","Comms Controller Hardware (fully redundant) as per 240-71630971:  tenderer to populate CC Sub-componets table to list & price each component which build up complete system",1,{"$f":"'CC Sub-Components'!G9","v":0},{"$f":"E4*F4","v":0}]
[1.2,null,"Once-off cost per site","Comms Controller Software & perpetual licencing:  tenderer to populate CC Sub-componets table to list & price each component which build up complete system",1,{"$f":"'CC Sub-Components'!G15","v":0},{"$f":"E5*F5","v":0}]
[1.3,null,"Once-off cost per site","Comms Controller Installation and Commissioning:  tenderer to populate CC Sub-componets table to list & price each component which build up complete system",1,{"$f":"'CC Sub-Components'!G21","v":0},0]
[null,"Note for Item 1 above: Eskom currently has 7 master stations which will be upgraded as and when required"]
[2,"Field Modem/Router supply items"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
[2.1,"Std Modem/Router (incl SIMs, pwr cables, antennae, etc.): tenderer to list and price each component which build up a complete system ","Per item","Modem/router",1]
[2.2,null,null,"Antenna with fly lead",1]
[2.3,null,null,"Power cable",1]
[2.4,null,null,"SIM card (dual SIM if applicable)",1]
[2.5,null,null,"Sub-component  (if applicable)",1]
[2.6,null,null,"Sub-component  (if applicable)",1]
[3,"Technical Support & Maintenance"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
[3.1,"Support Services Items\n","Annual cost per master site as per Item 1 ","Comms Controller Support and Maintenance: tenderer to populate Technical S&M Sub-componets table to list & price each component which build up complete system",1,{"$f":"'Technical S&M Sub-Components'!G9","v":0},{"$f":"E18*F18","v":0}]
[4,"Training"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
[4.1,"Training","Rate per person","Comms Controller User Course (minimum class of 10 persons)",1]
[4.2,null,"Rate per person","Comms Controller Administrator Course (minimum class of 5 persons)",1]

{"sheet":"CC Sub-Components","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[0,0,0,6],[1,1,1,6],[3,1,20,1],[3,2,7,2],[3,7,15,7],[9,2,13,2],[15,2,19,2]]}
["PRICING SCHEDULE"]
[1,"Communnications Controller (CC) Sub-components"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
["1.1.1","Master-station \nSupply & Install Items \n","Once-off cost per site","Comms Controller (CC) Hardware: Sub-component 1.1 (if applicable)",null,null,{"$f":"E4*F4","v":0}]
["1.1.2",null,null,"Comms Controller (CC) Hardware: Sub-component 1.1 (if applicable)",null,null,{"$f":"E5*F5","v":0}]
["1.1.3",null,null,"Comms Controller (CC) Hardware: Sub-component 1.1 (if applicable)",null,null,0]
["1.1.4",null,null,"Comms Controller (CC) Hardware: Sub-component 1.1 (if applicable)",null,null,0]
["1.1.5",null,null,"Comms Controller (CC) Hardware: Sub-component 1.1 (if applicable)",null,null,0]
[{"$nulls":3},"CC Hardware Sub-Total",null,null,{"$f":"SUM(G4:G8)","v":0}]
["1.2.1",null,"Once-off cost per site","Comms Controller (CC) Software & perpetual licencing: Sub-component of 1.2 (if applicable)",null,null,{"$f":"E10*F10","v":0}]
["1.2.2",null,null,"Comms Controller (CC) Software & perpetual licencing: Sub-component of 1.2 (if applicable)",null,null,{"$f":"E11*F11","v":0}]
["1.2.3",null,null,"Comms Controller (CC) Software & perpetual licencing: Sub-component of 1.2 (if applicable)",null,null,0]
["1.2.4",null,null,"Comms Controller (CC) Software & perpetual licencing: Sub-component of 1.2 (if applicable)",null,null,0]
["1.2.5",null,null,"Comms Controller (CC) Software & perpetual licencing: Sub-component of 1.2 (if applicable)",null,null,{"$f":"E14*F14","v":0}]
[{"$nulls":3},"CC Software & perpetual licencing Sub-Total",null,null,{"$f":"SUM(G10:G14)","v":0}]
["1.3.1",null,"Once-off cost per site","Comms Controller (CC) Installation and Commissioning: Sub-component of 1.3 (if applicable)",null,null,{"$f":"E16*F16","v":0}]
["1.3.2",null,null,"Comms Controller (CC) Installation and Commissioning: Sub-component of 1.3 (if applicable)",null,null,{"$f":"E17*F17","v":0}]
["1.3.3",null,null,"Comms Controller (CC) Installation and Commissioning: Sub-component of 1.3 (if applicable)",null,null,0]
["1.3.4",null,null,"Comms Controller (CC) Installation and Commissioning: Sub-component of 1.3 (if applicable)",null,null,0]
["1.3.5",null,null,"Comms Controller (CC) Installation and Commissioning: Sub-component of 1.3 (if applicable)",null,null,0]
[{"$nulls":3},"CC Installation and Commissioning Sub-Total",null,null,{"$f":"SUM(G16:G20)","v":0}]

{"sheet":"Technical S&M Sub-Components","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,0,0,6],[1,1,1,6],[3,1,8,1],[3,2,7,2]]}
["PRICING SCHEDULE"]
[3,"Technical Support & Maintenance (S&M) Sub-components"]
["Item No.","Heading ","Unit charge","Detail","Quantity","Unit Price","Sub-total"]
["3.1.1","Support Services Items\n","Annual cost per master site as per Item 3","Technical Support & Maintenance (S&M) Sub-component (if applicable)",1,null,{"$f":"E4*F4","v":0}]
["3.1.2",null,null,"Technical Support & Maintenance (S&M) Sub-component (if applicable)",1,null,{"$f":"E5*F5","v":0}]
["3.1.3",null,null,"Technical Support & Maintenance (S&M) Sub-component (if applicable)",1,null,0]
["3.1.4",null,null,"Technical Support & Maintenance (S&M) Sub-component (if applicable)",1,null,0]
["3.1.5",null,null,"Technical Support & Maintenance (S&M) Sub-component (if applicable)",1,null,0]
[{"$nulls":3},"Technical S&M Sub-component",null,null,{"$f":"SUM(G4:G8)","v":0}]