{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Summary extent & value","Reservoirs and Towers","Water Pump Stations","Sewer Pump Stations","WWTW","Operational Buildings"],"read":"whole","date_system":"1900"}

{"sheet":"Summary extent & value","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[1,0,2,0],[3,0,8,0],[9,0,10,0],[11,0,19,0],[20,0,20,3]]}
["Asset Sub Category","Asset Group Type","Extent","Extent Unit"," AdjCRC (Rand)"]
["Operational Buildings","Buildings",15,"No",{"v":821935073,"d":"821,935,073"}]
[null,"Land",{"v":115480,"d":"115,480"},"sqm",{"v":4716203,"d":"4,716,203"}]
["Waste Water Network","Land",{"v":10739,"d":"10,739"},"sqm",{"v":292402,"d":"292,402"}]
[null,"Outfall Sewer",{"v":787076,"d":"787,076"},"m",{"v":15853739591,"d":"15,853,739,591"}]
[null,"Pump Station",37,"No",{"v":262711831,"d":"262,711,831"}]
[null,"Servitudes",{"v":4385268,"d":"4,385,268"},"sqm",{"v":86045735,"d":"86,045,735"}]
[null,"Sewer Connections",{"v":463767,"d":"463,767"},"No",{"v":2489970866,"d":"2,489,970,866"}]
[null,"Sewer Reticulation",{"v":11725586,"d":"11,725,586"},"m",{"v":35733518623,"d":"35,733,518,623"}]
["Waste Water Treatment Works","Land",{"v":23936146,"d":"23,936,146"},"sqm",{"v":977552203,"d":"977,552,203"}]
[null,"Treatment Works",6,"no",{"v":13011998637,"d":"13,011,998,637"}]
["Water Supply Network","Bulk Mains",{"v":2352171,"d":"2,352,171"},"m",{"v":19972169807,"d":"19,972,169,807"}]
[null,"Connections",{"v":548156,"d":"548,156"},"no",{"v":901023098,"d":"901,023,098"}]
[null,"Land",{"v":912793,"d":"912,793"},"sqm",{"v":34450087,"d":"34,450,087"}]
[null,"Meters",{"v":509281,"d":"509,281"},"no",{"v":3022292754,"d":"3,022,292,754"}]
[null,"PRV Stations",480,"no",{"v":85852207,"d":"85,852,207"}]
[null,"Pump Station",39,"no",{"v":320518656,"d":"320,518,656"}]
[null,"Reservoirs",128,"no",{"v":3896338351,"d":"3,896,338,351"}]
[null,"Servitudes",{"v":562274,"d":"562,274"},"sqm",{"v":10539792,"d":"10,539,792"}]
[null,"Water Distribution",{"v":10338904,"d":"10,338,904"},"m",{"v":17909926187,"d":"17,909,926,187"}]
["TOTAL",{"$nulls":3},{"v":115395592102,"d":"115,395,592,102"}]

{"sheet":"Reservoirs and Towers","index":1,"n_rows":132,"n_cols":3,"rows_kept":132,"merged":[[129,0,129,1]]}
["No","Reservoir Name","*Replacement Cost (Excl Land) (Rand)"]
[1,"Aeroton reservoir",{"v":47972714.85999997,"d":"47,972,714.86"}]
[2,"Aeroton Tower",{"v":13070228.48,"d":"13,070,228.48"}]
[3,"Alan Manor Reservoir",{"v":17403482.76999999,"d":"17,403,482.77"}]
[4,"Alexander Park Reservoir",{"v":75383462.54000008,"d":"75,383,462.54"}]
[5,"Berea Reservoir",{"v":41841451.19000001,"d":"41,841,451.19"}]
[6,"Blairgowrie Reservoir",{"v":15779015.079999996,"d":"15,779,015.08"}]
[7,"Boschkop Tower",{"v":5851568.97,"d":"5,851,568.97"}]
[8,"Boschkop_1 Reservoir",{"v":14351443.519999994,"d":"14,351,443.52"}]
[9,"Boschkop_2 Reservoir",{"v":15589410.139999993,"d":"15,589,410.14"}]
[10,"Braamficherville Reservoir (1)",{"v":15882283.409999996,"d":"15,882,283.41"}]
[11,"Braamficherville Reservoir (2)",{"v":16499213.929999987,"d":"16,499,213.93"}]
[12,"Brixton Reservoir",{"v":44574211.29000002,"d":"44,574,211.29"}]
[13,"Brixton Tower",{"v":8454747.700000001,"d":"8,454,747.70"}]
[14,"Bryanston Tower",{"v":9797754.269999988,"d":"9,797,754.27"}]
[15,"Bryanston_1 Reservoir",{"v":30625519.11,"d":"30,625,519.11"}]
[16,"Bryanston_2 Reservoir",{"v":18329238.9,"d":"18,329,238.90"}]
[17,"Bryanston_3 Reservoir",{"v":23266288.09,"d":"23,266,288.09"}]
[18,"Bryanston_4 Reservoir",{"v":25670510.639999993,"d":"25,670,510.64"}]
[19,"Bryanston_5 Reservoir",{"v":50482307.64999998,"d":"50,482,307.65"}]
[20,"Chester Reservoir",{"v":12750650.020000001,"d":"12,750,650.02"}]
[21,"Chiawelo Reservoir",{"v":53431061.12999997,"d":"53,431,061.13"}]
[22,"Constantia Kloof Tower",{"v":8480495.519999996,"d":"8,480,495.52"}]
[23,"Corporate Park  Tower",{"v":6661959.659999999,"d":"6,661,959.66"}]
[24,"Corporate Park Reservoir",{"v":12602024.559999995,"d":"12,602,024.56"}]
[25,"Corriemore  Reservoir",{"v":26141113.35,"d":"26,141,113.35"}]
[26,"Cosmo City  Reservoir",{"v":7768875.420000002,"d":"7,768,875.42"}]
[27,"Crosby  Reservoir",{"v":74428520.73999998,"d":"74,428,520.74"}]
[28,"Crown Gardens Reservoir",{"v":87560573.52000006,"d":"87,560,573.52"}]
[29,"Crown Gardens Tower",{"v":7631829.3999999985,"d":"7,631,829.40"}]
[30,"Dainfern Reservoir",{"v":430015728.23,"d":"430,015,728.23"}]
[31,"Diepkloof  Reservoir",{"v":30708638.679999992,"d":"30,708,638.68"}]
[32,"Diepsloot Reservoir",{"v":40738276.25000001,"d":"40,738,276.25"}]
[33,"Dobsonville Tower",{"v":7826149.3100000005,"d":"7,826,149.31"}]
[34,"Doornkop West Reservoir",{"v":25319251.370000087,"d":"25,319,251.37"}]
[35,"Dunkeld Reservoir",{"v":31913658.760000005,"d":"31,913,658.76"}]
[36,"Eagles Nest  Reservoir",{"v":30087298.439999998,"d":"30,087,298.44"}]
[37,"Ennerdale  1  Reservoir",{"v":49342349.670000024,"d":"49,342,349.67"}]
[38,"Ennerdale  2  Reservoir",{"v":15291386.8,"d":"15,291,386.80"}]
[39,"Erand Large Ground  Reservoir",{"v":42522440.85,"d":"42,522,440.85"}]
[40,"Erand Small  Ground  Reservoir",{"v":14360729.860000001,"d":"14,360,729.86"}]
[41,"Erand Tower",{"v":20175469.630000018,"d":"20,175,469.63"}]
[42,"Fairland  Reservoir",{"v":13287325.68,"d":"13,287,325.68"}]
[43,"Florida North Tower",{"v":6331825.119999998,"d":"6,331,825.12"}]
[44,"Forest Hill Tower",{"v":10389343.459999995,"d":"10,389,343.46"}]
[45,"Glenvista  Reservoir",{"v":48163618.459999956,"d":"48,163,618.46"}]
[46,"Grand Central Reservoir",{"v":26998359.759999998,"d":"26,998,359.76"}]
[47,"Grand Central Tower",{"v":15480676.039999973,"d":"15,480,676.04"}]
[48,"Helderkruin  Reservoir",{"v":31334487.710000012,"d":"31,334,487.71"}]
[49,"Honeydew Reservoir",{"v":33382099.41000001,"d":"33,382,099.41"}]
[50,"Honeydew Tower",{"v":6023275.619999998,"d":"6,023,275.62"}]
[51,"Horison Finch Tower",{"v":7200485,"d":"7,200,485.00"}]
[52,"Hursthill  Reservoir No1",{"v":57401215.73999997,"d":"57,401,215.74"}]
[53,"Hursthill  Reservoir No2",{"v":66880411.580000006,"d":"66,880,411.58"}]
[54,"Illovo Reservoir No1",{"v":14025799.89,"d":"14,025,799.89"}]
[55,"Illovo Reservoir No2",{"v":8274732.55,"d":"8,274,732.55"}]
[56,"Illovo Reservoir No3",{"v":8274732.55,"d":"8,274,732.55"}]
[57,"Illovo Reservoir No4",{"v":8468348.569999998,"d":"8,468,348.57"}]
[58,"Illovo Reservoir No5",{"v":8394643.23,"d":"8,394,643.23"}]
[59,"Illovo Reservoir No6",{"v":8274732.55,"d":"8,274,732.55"}]
[60,"Illovo Reservoir No7",{"v":6700431.33,"d":"6,700,431.33"}]
[61,"Illovo Reservoir No8",{"v":13518800.689999998,"d":"13,518,800.69"}]
[62,"Illovo Tower",{"v":7458580.839999999,"d":"7,458,580.84"}]
[63,"Jabulani  Tower",{"v":7473066.1,"d":"7,473,066.10"}]
[64,"Jabulani Reservoir",{"v":81060103.88000011,"d":"81,060,103.88"}]
[65,"Kensington 'B' Reservoir",{"v":20110947.439999998,"d":"20,110,947.44"}]
[66,"Kensington-B- Tower",{"v":7782746.089999998,"d":"7,782,746.09"}]
[67,"Kibler Park Reservoir",{"v":37380089.03999997,"d":"37,380,089.04"}]
[68,"Kite  Street Tower",{"v":6669142.029999999,"d":"6,669,142.03"}]
[69,"Lanseria Reservoir",{"v":8777856.44,"d":"8,777,856.44"}]
[70,"Lanseria Tower",{"v":4584837.39,"d":"4,584,837.39"}]
[71,"Lawley Reservoir",{"v":15488542.919999996,"d":"15,488,542.92"}]
[72,"Lenasia High Level  Reservoir",{"v":10887346.239999998,"d":"10,887,346.24"}]
[73,"Lenasia Reservoir (Cosmos)",{"v":76457397.89000005,"d":"76,457,397.89"}]
[74,"Lenasia Reservoir (Hospital Hill)",{"v":55715688.53999996,"d":"55,715,688.54"}]
[75,"Linbro Park 1 Reservoir",{"v":40112923.98000002,"d":"40,112,923.98"}]
[76,"Linbro Park 2 Reservoir",{"v":25073854.799999993,"d":"25,073,854.80"}]
[77,"Linden 1 Reservoir",{"v":38876195.969999984,"d":"38,876,195.97"}]
[78,"Linden 2 Reservoir",{"v":28407858.64,"d":"28,407,858.64"}]
[79,"Linden Tower",{"v":6803501.089999999,"d":"6,803,501.09"}]
[80,"Linksfield Reservoir",{"v":53160991.82999998,"d":"53,160,991.83"}]
[81,"Marlboro 1 Reservoir",{"v":35883723.790000014,"d":"35,883,723.79"}]
[82,"Marlboro 2 Reservoir",{"v":588554.3900000001,"d":"588,554.39"}]
[83,"Marlboro 3 Reservoir",{"v":21650392.809999995,"d":"21,650,392.81"}]
[84,"Meadowlands 1 Reservoir",{"v":39498337.87999999,"d":"39,498,337.88"}]
[85,"Meadowlands 2 Reservoir",{"v":44291076.019999996,"d":"44,291,076.02"}]
[86,"Meadowlands Tower",{"v":24562736.070000213,"d":"24,562,736.07"}]
[87,"Modderhill Reservoir",{"v":21007325.520000014,"d":"21,007,325.52"}]
[88,"Morningside Reservoir",{"v":16891913.710000005,"d":"16,891,913.71"}]
[89,"Naturena Reservoir",{"v":14649757.360000007,"d":"14,649,757.36"}]
[90,"Northcliff Reservoir",{"v":72036960.13000001,"d":"72,036,960.13"}]
[91,"Northcliff Tower",{"v":8950251.06,"d":"8,950,251.06"}]
[92,"Olivedale A Reservoir",{"v":19716228.799999986,"d":"19,716,228.80"}]
[93,"Olivedale B Reservoir",{"v":19255431.83,"d":"19,255,431.83"}]
[94,"Orange Farm High Level Reservoir",{"v":20662472.340000004,"d":"20,662,472.34"}]
[95,"Orange Farm Low  Level Reservoir",{"v":12016846.050000003,"d":"12,016,846.05"}]
[96,"Orange Farm Reservoir",{"v":51584742.24,"d":"51,584,742.24"}]
[97,"Orange Farm Tower",{"v":35139415.94,"d":"35,139,415.94"}]
[98,"Orlando Reservoir",{"v":25505204.480000008,"d":"25,505,204.48"}]
[99,"Parktown 1 Reservoir",{"v":49469072.69999998,"d":"49,469,072.70"}]
[100,"Parktown 2 Reservoir",{"v":59202903.930000015,"d":"59,202,903.93"}]
[101,"Poortje Tower",{"v":78573171.33000001,"d":"78,573,171.33"}]
[102,"Power Park Reservoir",{"v":90011428.26000018,"d":"90,011,428.26"}]
[103,"President Park Reservoir 2",{"v":5457386.099999999,"d":"5,457,386.10"}]
[104,"President Park Reservoir 1",{"v":39839295.6,"d":"39,839,295.60"}]
[105,"President Park Tower",{"v":12002080.780000014,"d":"12,002,080.78"}]
[106,"Protea Glen Reservoir",{"v":21199855.869999997,"d":"21,199,855.87"}]
[107,"Protea Glen Tower",{"v":8042849.770000001,"d":"8,042,849.77"}]
[108,"Quellerina Tower",{"v":5806653.300000001,"d":"5,806,653.30"}]
[109,"Rabie Ridge Reservoir",{"v":11168270.569999998,"d":"11,168,270.57"}]
[110,"Rabie Ridge Tower",{"v":8725659.049999999,"d":"8,725,659.05"}]
[111,"Randjesfontein Reservoir",{"v":14487094.299999999,"d":"14,487,094.30"}]
[112,"Randjesfontein Tower",{"v":5463756.450000001,"d":"5,463,756.45"}]
[113,"Randjieslaagte Reservoir",{"v":88851231.27000003,"d":"88,851,231.27"}]
[114,"Randpark Ridge Reservoir",{"v":13824291.429999996,"d":"13,824,291.43"}]
[115,"Robertville Reservoir",{"v":11810773.219999997,"d":"11,810,773.22"}]
[116,"South Hills Tower",{"v":86130751.82000002,"d":"86,130,751.82"}]
[117,"Waterval Tower",{"v":6452920.19,"d":"6,452,920.19"}]
[118,"Wilropark Tower",{"v":7283458.959999998,"d":"7,283,458.96"}]
[119,"Witpoorjie Tower",{"v":5277314.690000001,"d":"5,277,314.69"}]
[120,"Witpoortjie Reservoir",{"v":21561255.380000006,"d":"21,561,255.38"}]
[121,"Yeoville  Reservoir 1",{"v":32326455.970000017,"d":"32,326,455.97"}]
[122,"Yeoville  Reservoir 2",{"v":53075841.139999986,"d":"53,075,841.14"}]
[123,"Yeoville  Reservoir 3",{"v":43890250.78,"d":"43,890,250.78"}]
[124,"Yeoville Concrete Tower",{"v":7237614.69,"d":"7,237,614.69"}]
[125,"Yeoville Steel Tower",{"v":20386625,"d":"20,386,625.00"}]
[126,"Zondi Reservoir 1",{"v":132341762.57000016,"d":"132,341,762.57"}]
[127,"Zondi Reservoir 2",{"v":28280859.55,"d":"28,280,859.55"}]
[128,"Zondi Tower",{"v":8149339.3100000005,"d":"8,149,339.31"}]
["Total",null,{"v":3917891944.200001,"d":"3,917,891,944.20"}]
[]
["Note: * Replacement Costs are Exclusive of Land"]

{"sheet":"Water Pump Stations","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"merged":[[40,0,40,1]]}
["No","Pump Station Name","*Replacement Costs (Excl Land) (Rand)"]
[1,"Aeroton reservoir",{"v":4261359.220000001,"d":"4,261,359.22"}]
[2,"Berea Water Pump Station",{"v":10473903.680000002,"d":"10,473,903.68"}]
[3,"Boschkop Water Pump Station",{"v":3086716.9899999993,"d":"3,086,716.99"}]
[4,"Brixton Water Pump Station",{"v":4982647.949999999,"d":"4,982,647.95"}]
[5,"Bryanston Water Pump Station",{"v":7944598.14,"d":"7,944,598.14"}]
[6,"Constantia Kloof Water Pump Station",{"v":4725619.5200000005,"d":"4,725,619.52"}]
[7,"Corporate Park Water Pump Station",{"v":3638368.950000001,"d":"3,638,368.95"}]
[8,"CR Swart Booster Water Pump Station",{"v":2798698.43,"d":"2,798,698.43"}]
[9,"Crosby Water Pump Station",{"v":29960012.110000003,"d":"29,960,012.11"}]
[10,"Crown Gardens Water Pump Station",{"v":6598750.869999999,"d":"6,598,750.87"}]
[11,"Erand Water Pump Station",{"v":4461067.04,"d":"4,461,067.04"}]
[12,"Florida North Water Pump Station",{"v":5258731.1899999995,"d":"5,258,731.19"}]
[13,"Forest Hill Water Pump Station",{"v":10607007.879999999,"d":"10,607,007.88"}]
[14,"Grand Central Water Pump Station",{"v":6952238.500000001,"d":"6,952,238.50"}]
[15,"Hector Norris Booster Water Pump Station",{"v":28957464.74999999,"d":"28,957,464.75"}]
[16,"Helderkruin Water Pump Station",{"v":6887766.84,"d":"6,887,766.84"}]
[17,"Honeydew Water Pump Station",{"v":2338658.409999999,"d":"2,338,658.41"}]
[18,"Horizon Water Pump Station",{"v":8007051.730000003,"d":"8,007,051.73"}]
[19,"Illovo Water Pump Station",{"v":8826831.549999999,"d":"8,826,831.55"}]
[20,"J Fouche Booster Water Pump Station",{"v":987809.07,"d":"987,809.07"}]
[21,"Lenasia Cosmos Water Pump Station",{"v":8067330.950000003,"d":"8,067,330.95"}]
[22,"Lenasia Hospital Hill Water Pump Station",{"v":8097590.670000002,"d":"8,097,590.67"}]
[23,"Lenasia Hospital Hill Water Pump Station ",{"v":35372645.85,"d":"35,372,645.85"}]
[24,"Linden Water Pump Station",{"v":2115138.53,"d":"2,115,138.53"}]
[25,"Northcliff Booster Pump Station",{"v":5980231.9799999995,"d":"5,980,231.98"}]
[26,"Orange Farm Low Water Pump Station",{"v":9037683.830000002,"d":"9,037,683.83"}]
[27,"Orange Farm Pump Station",{"v":3257484.1799999992,"d":"3,257,484.18"}]
[28,"Pimville Booster Water Pump Station",{"v":518827.15,"d":"518,827.15"}]
[29,"President Park Water Pump Station",{"v":4030607.9100000006,"d":"4,030,607.91"}]
[30,"Protea Glen Pump Station",{"v":965186.7,"d":"965,186.70"}]
[31,"Rabie Ridge Water Pump Station",{"v":3506725.8000000003,"d":"3,506,725.80"}]
[32,"Randjesfontein Water Pump Station",{"v":3430860.3300000005,"d":"3,430,860.33"}]
[33,"Robertville Water Pump Station",{"v":8671240.829999996,"d":"8,671,240.83"}]
[34,"South Hills Water Pump Station",{"v":3307004.8,"d":"3,307,004.80"}]
[35,"Vuurlelie Booster Water Pump Station",{"v":293884.7800000001,"d":"293,884.78"}]
[36,"Waterval Water Pump Station",{"v":5042708.529999999,"d":"5,042,708.53"}]
[37,"Witpoortjie Water Pump Station",{"v":5298924.56,"d":"5,298,924.56"}]
[38,"Yeoville Water Pump Station",{"v":39859787.020000294,"d":"39,859,787.02"}]
[39,"Zondi Water Pump Station",{"v":10943464.059999999,"d":"10,943,464.06"}]
["Total",null,{"$f":"SUM(C2:C40)","v":{"v":319552631.28000027,"d":"319,552,631.28"}}]
[]
["Note: * Replacement Costs are Exclusive of Land"]

{"sheet":"Sewer Pump Stations","index":3,"n_rows":41,"n_cols":3,"rows_kept":41,"merged":[[38,0,38,1]]}
["No","Pump Station Name","*Replacement Costs (Excl Land) (Rand)"]
[1,"Adelaar High School Sewer Pump Station",{"v":1037870.7099999998,"d":"1,037,870.71"}]
[2,"Akasia Sewer pump Station",{"v":8640522.990000004,"d":"8,640,522.99"}]
[3,"Alveda Park Sewer Pump Station",{"v":9487890.750000002,"d":"9,487,890.75"}]
[4,"Beverley Sewer Pump Station",{"v":3634745.280000001,"d":"3,634,745.28"}]
[5,"Bushkoppies Sewer Pump Station",{"v":851928.1599999999,"d":"851,928.16"}]
[6,"Cosmo City Pump Station (X33-X49)",{"v":11614307.01,"d":"11,614,307.01"}]
[7,"Dainfern Sewer Pump Station",{"v":9963638.079999996,"d":"9,963,638.08"}]
[8,"Devland (Freedom Park) Sewer Pump Station",{"v":5824784.7700000005,"d":"5,824,784.77"}]
[9,"Elands Park Sewer Pump Station",{"v":1143518.7299999997,"d":"1,143,518.73"}]
[10,"Ennerdale Sewer Pump Station",{"v":2003855.25,"d":"2,003,855.25"}]
[11,"Fleurhof Sewer Pump Station",{"v":1503805.0199999998,"d":"1,503,805.02"}]
[12,"Helderkruin Sewer Pump Station",{"v":858111.6299999999,"d":"858,111.63"}]
[13,"Hurlingham Sewer Pump Station",{"v":955627.2200000001,"d":"955,627.22"}]
[14,"Jukskei Park Sewer Pump Station",{"v":5379868.640000003,"d":"5,379,868.64"}]
[15,"Kibler Park Sewer Pump Station",{"v":14847944.579999993,"d":"14,847,944.58"}]
[16,"King Street Sewer Pump Station",{"v":1022565.93,"d":"1,022,565.93"}]
[17,"Kyalami Sewer Pump Station",{"v":1254777.6199999999,"d":"1,254,777.62"}]
[18,"Lanseria Sewer Pump Station",{"v":2733568.28,"d":"2,733,568.28"}]
[19,"Liefde & Vrede 1 New Sewer Pump Station",{"v":17080781.990000002,"d":"17,080,781.99"}]
[20,"Longmeadow East Sewer Pump Station",{"v":1773650.4900000005,"d":"1,773,650.49"}]
[21,"Longmeadow West Sewer Pump Station",{"v":945265.09,"d":"945,265.09"}]
[22,"Malanshof Sewer Pump Station",{"v":1162704.72,"d":"1,162,704.72"}]
[23,"Nancefield Sewer Pump Station",{"v":13986830.249999993,"d":"13,986,830.25"}]
[24,"Nupen Crescent Sewer Pump Station",{"v":1433062.6399999994,"d":"1,433,062.64"}]
[25,"Pistol Club Sewer Pump Station",{"v":554376.76,"d":"554,376.76"}]
[26,"Poortview Sewer Pump Station",{"v":1965473.9799999995,"d":"1,965,473.98"}]
[27,"Pump station: Muldersdrift",{"v":2218811.79,"d":"2,218,811.79"}]
[28,"Putcoton Sewer Pump Station",{"v":1204326.77,"d":"1,204,326.77"}]
[29,"Steyn City Sewer Pump Station",{"v":5290242.76,"d":"5,290,242.76"}]
[30,"Suideroord Sewer Pump Station",{"v":2640638.6799999997,"d":"2,640,638.68"}]
[31,"Thornhill Sewer Pump Station",{"v":1263329.8500000003,"d":"1,263,329.85"}]
[32,"Waterval Park Sewer Pump Station",{"v":994394.9100000001,"d":"994,394.91"}]
[33,"Whisken Sewer Pump Station",{"v":698568.45,"d":"698,568.45"}]
[34,"Wilforden Sewer Pump Station",{"v":2571663.4299999992,"d":"2,571,663.43"}]
[35,"Woodmead Sewer Pump Station",{"v":1186021.5699999996,"d":"1,186,021.57"}]
[36,"Zandspruit New Sewer Pump Sation",{"v":50621211.45999994,"d":"50,621,211.46"}]
[37,"Zandspruit Old Sewer Pump Station",{"v":9561122.530000001,"d":"9,561,122.53"}]
["Total",null,{"$f":"SUM(C2:C38)","v":{"v":199911808.76999995,"d":"199,911,808.77"}}]
[]
["Note: * Replacement Costs are Exclusive of Land"]

{"sheet":"WWTW","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[7,0,7,1]]}
["No","WWTW Name","*Replacement Costs (Excl Land) (Rand)"]
[1,"Bushkoppies",{"v":2490389101.2799993,"d":"2,490,389,101.28"}]
[2,"Driefontein",{"v":1522821492.430012,"d":"1,522,821,492.43"}]
[3,"Ennerdale",{"v":139787504.78999978,"d":"139,787,504.79"}]
[4,"Goudkoppies",{"v":1751031683.7800088,"d":"1,751,031,683.78"}]
[5,"Northen Works",{"v":4263332715.809963,"d":"4,263,332,715.81"}]
[6,"Olifantsvlei",{"v":2844636139.0899744,"d":"2,844,636,139.09"}]
["Total",null,{"$f":"SUM(C2:C7)","v":{"v":13011998637.179958,"d":"13,011,998,637.18"}}]
[]
["Note: * Replacement Costs are Exclusive of Land"]

{"sheet":"Operational Buildings","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[15,0,15,1],[16,5,16,6]]}
["No","Building Facility Name","Replacement Cost Incl Land (Rand)","Land value (Rand)","Replacement Costs (Excl Land) (Rand)","No","Name","*Replacement Value (Excl Land) (Rand)"]
[1,"Avalon Depot - Gcinamanzi/Prepay",{"v":23755811.67,"d":"23,755,811.67"},{"v":349059.48,"d":"349,059.48"},{"v":23406752.19,"d":"23,406,752.19"},1,"Avalon Depot - Gcinamanzi/Prepay",{"v":23406752.19,"d":"23,406,752.19"}]
[2,"Avalon Depot - Networks",{"v":28555401.50000001,"d":"28,555,401.50"},{"v":366253.12,"d":"366,253.12"},{"v":28189148.38000001,"d":"28,189,148.38"},2,"Avalon Depot - Networks",{"v":28189148.38000001,"d":"28,189,148.38"}]
[3,"Cydna Laboratory",{"v":46760302.61000003,"d":"46,760,302.61"},null,{"v":46760302.61000003,"d":"46,760,302.61"},3,"Cydna Laboratory",{"v":46760302.61000003,"d":"46,760,302.61"}]
[4,"Ennerdale Depot",{"v":44265852.91000002,"d":"44,265,852.91"},{"v":605248.8,"d":"605,248.80"},{"v":43660604.11000002,"d":"43,660,604.11"},4,"Ennerdale Depot",{"v":43660604.11000002,"d":"43,660,604.11"}]
[5,"Fennell Road Depot",{"v":245993112.84000006,"d":"245,993,112.84"},{"v":933112.32,"d":"933,112.32"},{"v":245060000.52000007,"d":"245,060,000.52"},5,"Fennell Road Depot",{"v":245060000.52000007,"d":"245,060,000.52"}]
[6,"Glenvista Depot",{"v":15255601.620000001,"d":"15,255,601.62"},null,{"v":15255601.620000001,"d":"15,255,601.62"},6,"Glenvista Depot",{"v":15255601.620000001,"d":"15,255,601.62"}]
[7,"Hamberg Depot",{"v":30667380.56,"d":"30,667,380.56"},null,{"v":30667380.56,"d":"30,667,380.56"},7,"Hamberg Depot",{"v":30667380.56,"d":"30,667,380.56"}]
[8,"Hursthill Depot",{"v":10101192.77,"d":"10,101,192.77"},null,{"v":10101192.77,"d":"10,101,192.77"},8,"Hursthill Depot",{"v":10101192.77,"d":"10,101,192.77"}]
[9,"Klipspruit Depot",{"v":51871540.17000002,"d":"51,871,540.17"},{"v":667856.52,"d":"667,856.52"},{"v":51203683.65000001,"d":"51,203,683.65"},9,"Klipspruit Depot",{"v":51203683.65000001,"d":"51,203,683.65"}]
[10,"Langlaagte Depot",{"v":105464634.50000009,"d":"105,464,634.50"},{"v":1118362.56,"d":"1,118,362.56"},{"v":104346271.94000009,"d":"104,346,271.94"},10,"Langlaagte Depot",{"v":104346271.94000009,"d":"104,346,271.94"}]
[11,"Midrand Depot",{"v":53860239.67999999,"d":"53,860,239.68"},null,{"v":53860239.67999999,"d":"53,860,239.68"},11,"Midrand Depot",{"v":53860239.67999999,"d":"53,860,239.68"}]
[12,"Scott-Atholl Depot",{"v":11545025.009999998,"d":"11,545,025.01"},null,{"v":11545025.009999998,"d":"11,545,025.01"},12,"Scott-Atholl Depot",{"v":11545025.009999998,"d":"11,545,025.01"}]
[13,"Southdale Depot",{"v":44271571.46,"d":"44,271,571.46"},{"v":676310.4,"d":"676,310.40"},{"v":43595261.06,"d":"43,595,261.06"},13,"Southdale Depot",{"v":43595261.06,"d":"43,595,261.06"}]
[14,"Zandfontein North Depot",{"v":114283609.19,"d":"114,283,609.19"},null,{"v":114283609.19,"d":"114,283,609.19"},14,"Zandfontein North Depot",{"v":46101478.029999994,"d":"46,101,478.03"}]
["Total",null,{"$f":"SUM(C2:C15)","v":{"v":826651276.4900002,"d":"826,651,276.49"}},{"$f":"SUM(D2:D15)","v":{"v":4716203.2,"d":"4,716,203.20"}},{"v":821935073.2900002,"d":"821,935,073.29"},15,"Zandfontein South Depot",{"v":63284534.65,"d":"63,284,534.65"}]
[{"$nulls":5},"Total",null,{"v":817037476.7800001,"d":"817,037,476.78"}]
[]
[{"$nulls":5},"Note: * Replacement Costs are Exclusive of Land"]