{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["umngeni LM","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"umngeni LM","index":0,"n_rows":14,"n_cols":19,"rows_kept":14,"hidden":true,"merged":[[0,0,0,18]]}
["UMNGENI LOCAL MUNICIPALITY"]
["Municipality","Operation Area","Name of \nPump Station","Co-Ords","Source of \nWater","H/Pump or Production borehole","Type of Pump","No. of per\nStation","Year Installed","Make of pump","Flow Rate","Residual Head","Production Rate","Capacity of Plant","Type of \nTreatment","Population\nServed","Maintenance Work and Servicing"," Major Repairs ","Comments"]
["Umngeni LM","Yarrow Farm","Yarrow Farm Borehole","x:- 29,345327        y:- 30,313569","Underground water","Production Borehole","Submersible borehole",1,2015,"CRI 5/17","1,5 L/SEC","27M","NA","NA","NA",2174,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Greendale","Greendale Pump station","x:- 29,474470      y:- 30,215101","Eridene  Reservoir","Vertical multi stage pump","centrifugal vertical",2,2017,"4KW SEOCA VMS 8-100","5-12Mᶟ/HR","92M","NA","NA","NA",1450,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Colebourne Farm","Colebourne\n Farm Borehole","x:- 29° 19' 34.2\"    y:- 30° 15' 17.7\"","Underground water","Production Borehole","Submersible borehole",1,2015,"QFN 6/25","2 L/SEC","24M","NA","NA","NA",792,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Senzani Borehole","Senzani\nBorehole","x:-29,378347 y:30,029617","Underground water","Production Borehole","Submersible borehole",1,"NA","5,5KW Franklin Electric 5VM242028/550","14.4mᶟ/HR","165M","NA","NA","NA",800,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Lions River","Lions river Borehole ","x:-29,470503 y:30,159269","Underground water","Production Borehole","Submersible borehole",1,"NA","4KW Franklin electric SVM 24022/400","14.4mᶟ/HR","126M","NA","NA","Conventional treatment. using Sodium hypo chroride and hydrochloric acid ",1080,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Lions River","Lions river Borehole ","x:-29,473263 y:30,159269","Underground water","Production Borehole","centrifugals pump",1,"NA","1,5 Pedrollo CP 160B","50-220L/MIN","36M","NA","NA","Conventional treatment. using Sodium hypo chroride and hydrochloric acid ",1080,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Lions River","Lions river Borehole ","x:-29,473263 y:30,159269","Underground water","Production Borehole","Centrifugal pump",1,"NA","1KW Ebara CDXHM/A 120/07","50-180L/MIN","22,5M","NA","NA","Conventional treatment. using Sodium hypo chroride and hydrochloric acid ",1080,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Lions River","Lions river Borehole ","x:-29,473263 y:30,159269","Underground water","Production Borehole","Centrifugal pump",1,"NA","1,15kw ebara CMC 1,00M","50-450 L/MIN","14M","NA","NA","Conventional treatment. using Sodium hypo chroride and hydrochloric acid ",1080,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Hilton ","Hilton pump station","x:-29,569714 y:30,215101","Groenekloof Reservoir","Vertical multi stage pump","MGE100LC2-FT130-G3",3,2016,"Grundfos pumps ","17Mᶟ/HR","31,6M","NA","NA","NA",11350,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Lidgeton","Lidgeton pump station ","x:-29,443779 y:30,101942","Lidgeton River","Vertical multi stage pump","centrifugals vertical",2,2019,"5KW Soeca VMS 32-30","32mᶟ/HR","40M","NA","NA","NA",3900,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Nxamalala  Village","Nxamalala borehole ","x:-29,326139 y:30,254910","Underground water","Production Borehole","Submersible borehole",1,2016,"CRI S4P 2/11","0,5L/SEC","38M","NA","NA","NA",1354,"Daily inspection by Jade star trading cc ","None ","None "]
[null,"Birnmwood farm","Birnmwood pump station ","x:-29,571514 y:30,233160","Groenekloof Reservoir","Centrifugal pump","Centrifugal pump",1,"NA","7,5kw Pedrollo pump 2GP 32/210A","40-250.4mᶟ/HR","112M","NA","NA","NA",960,"Daily inspection by Jade star trading cc ","None ","None "]

{"sheet":"Sheet1","index":1,"n_rows":64,"n_cols":20,"rows_kept":64,"merged":[[3,0,3,18],[5,1,12,1],[5,19,11,19],[14,1,18,1],[14,19,18,19],[21,1,25,1],[21,19,26,19],[29,1,44,1],[29,19,41,19],[43,19,44,19],[47,1,51,1],[47,19,51,19],[53,1,57,1],[53,19,57,19],[59,1,63,1],[60,19,67,19]]}
[]
[]
[{"$nulls":9},"ANNEXURE  F"]
["IMPENDLE LOCAL MUNICIPALITY"]
["Municipality","Operation Area","Name of \nPump Station","Co-Ords","Source of \nWater","H/Pump or Production borehole","Type of Pump","No. of per\nStation","Year Installed","Make of pump","Flow Rate","Residual Head","Production Rate","Capacity of Plant","Type of \nTreatment","Population\nServed","Maintenance Work and Servicing"," Major Repairs ","Comments","Frequency"]
["IMPENDLE ","Mahlutshini",{"$nulls":16},"None","Friday"]
[null,null,"River Abstraction ","x:- 29,32\"36.9              y:- 29\"36\"39\"1","River","Submersible-","Submersible-",2,2015,"N/A","22mᶟ/HR","45M",{"$nulls":3},1024,null,null,"Remove old grease on rotor bearings and repack with new"]
[null,null,"MAHLUTSHINI PLANT Water 2 PUMPS X7.5KWX2",null,"river","Vertical multi stage pump","vertical pumps",2,2015,"RAPID ALWEILER  74743 005/15","15mᶟ/HR","50M",null,null,"Conventional treatment. using Sodium hypo chroride and hydrochloric acid ",{"$nulls":3},"water meter reading and preasure gauge rreading"]
[{"$nulls":18},"None"]
[null,null,"Mahlutshini filter pumps x2",null,"river","Vertical multi stage pump","centrifugal pumps",2,2015,"RAPID ALWEILER  NB 50-160 01/HS","50mᶟ/HR","30M",{"$nulls":6},"None"]
[]
[]
[]
[]
[null,"Makhuzeni SCHEME","River Abstraction",null,"River","Submersible-","borehole pump",1,null,"N/A",{"$nulls":5},6240,{"$nulls":3},"Friday"]
[]
[null,null,"Water Treatment works","x:- 29,39\"03.9              y:- 29\"42\"19\"5","Mkhomazana River","Vertical multi stage pump","vertical pump",2,null,"grunforce -CR 32-11-A",null,"214.6M"]
[]
[null,null,"FILTER PUMPS","x:- 29,39\"03.9              y:- 29\"42\"19\"5","Mkhomazana River",null,"Pedrollo",null,null,"pedrollo 5F50/160A","300-1100L/MIN "]
[]
[]
[null,"INZINGA SCHEME","Inzinga Abstraction","x:- 29,35\"36.9              y:- 29\"45\"55\"5","Inzinga River",null,"Submersible-",2,2019,"WILO PUMP",null,50,{"$nulls":3},11304,{"$nulls":3},"Wednesday"]
[]
[null,null,"Inzinga WTW","x:- 29,35\"45.9              y:- 29\"45\"53\"5","inzinga river",null,"Centrifugal",2,2018,"ksb  etanorm 065-040-250"]
[]
[null,null,"inzinga booster pumps",null,"inzinga river",null,"centrifugal",2,null,"WKLN 50/4 ksb"]
[]
[]
[]
[null,"INGUGA SCHEME","Inguga abstraction","x:- 29,35\"36.9              y:- 29\"45\"55\"5","inzinga river","Submersible-","borehole pump",2,2019,"turbine T6 55/08 150mm","55mᶟ/HR","82.3M",{"$nulls":3},13376,{"$nulls":3},"Monday weekly"]
[]
[null,null,"filter pumps","x:- 29,35\"46 .9              y:- 29\"45\"51\"5","inzinga river","centrifugal","centrifugal",2,null,"lowara FHS 50-125"]
[]
[null,null,"inguga boreholes1","x:-29,34\"17.0               y:- 29\"44\"15\"4","GROUND WATER","Production on borehole"," Submersible-positive displacement",1,null,null,"5.2mᶟ/HR","143M"]
[]
[null,null,"inguga boreholes2","x:-29,34\"12.0               y:- 29\"43\"15\"4","GROUND WATER","Production on borehole"," Submersible-positive displacement",1,null,null,"5mᶟ/HR","135M"]
[]
[null,null,"Inguga high lift","x:- 29,35\"45.9              y:- 29\"45\"53\"5","inzinga river","centrifugal","centrifugal",2,null,"NORMAFLO 6580LTF4","165mᶟ/HR","230M"]
[]
[null,null,"RES B -A Booster pumps","x:-29,35\"17.0               y:- 29\"48\"15\"4","inzinga river","centrifugal","centrifugal",2,null,"NORMAFLO HMW 40-4","15.5mᶟ/HR","140M"]
[]
[null,null,"RES B -C Booster pumps","x:-29,35\"17.0               y:- 29\"48\"15\"4","inzinga river","centrifugal","centrifugal",2,null,"NORMAFLO HMW 50-4","42.1mᶟ/HR","112M"]
[]
[null,null,"RES D Booster pumps","x:-29,37\"28.0               y:- 29\"48\"08\"2","inzinga river","centrifugal","centrifugal",2,null,"MONO HD 115H","42.1mᶟ/HR",{"$nulls":8},"Tuesday"]
[]
[]
[]
[null,"KHETHA SCHEME","khetha abstraction","x:-29,37\"14.0               y:- 29\"51\"05\"5","khetha river","Submersible-","borehole pump",1,2013,"frankline 556 c 07 ","26mᶟ/HR",60,{"$nulls":3},6213,{"$nulls":3},"once a week"]
[]
[null,null,"khetha wtw","x:-29,37\"13.0               y:- 29\"50\"53\"4","khetha river","Vertical multi stage pump","vertical pumps",2,2013,"grunfos CR10-22-A-FJ","10mᶟ/HR","225M"]
[]
[null,null,"Similo wtw","x:-29,37\"13.0               y:- 29\"50\"53\"4","khetha river","Vertical multi stage pump","vertical pumps",2,2014,"grunfos CR20-14A-F-A","21mᶟ/HR","207M"]
[{"$nulls":19},"Tuesday"]
[null,"NOVUKA SCHEME","Borehole1 ","x:-29,33\"56.0               y:- 29\"50\"53\"4","underground water","Production on borehole","borehole pump",1,2012,"franklin 135R9F6A-22625","15mᶟ/HR","247M",{"$nulls":3},3125,{"$nulls":3},"once a week"]
[]
[null,null,"borehole2","x:-29,34\"02.0               y:- 29\"51\"16\"3","underground water","Production on borehole",null,null,2012,"FRANKLIN","7mᶟ/HR"]
[]
[null,null,"borehole3",null,"underground water","Production on borehole",null,null,2012,"FRANKLIN","7mᶟ/HR"]
[{"$nulls":19},"Thursday"]
[null,"GOMANE SCHEME","borehole1","x:-29,37\"23.0               y:- 29\"53\"32 \"3","underground water","Production on borehole","Submersible-",null,null,"WILO PUMP",{"$nulls":5},10432,{"$nulls":3},"Thursday"]
[{"$nulls":19},"once a week"]
[null,null,"borehole2",null,"underground water","Production on borehole","Submersible-",null,null,"WILO PUMP"]
[]
[null,null," New borehole",null,"underground water","Production on borehole","Submersible-",null,null,"WILO PUMP"]