Please refer to http://coffee-table.4894995.n2.nabble.com/file/n4942112/Borehole.xls sheet which has a table that facilitates self-diagnosis. It also lists various factors that can affect borewell performance and parameters that can be monitored.
Contributor: The Community Engineer (https://www.indiawaterportal.org/users/thecommunityengineer)