Borehole drilling contractors, water-well equipping engineers, and commercial solar-irrigation EPC firms manage mobile high-pressure rotary/DTH drilling rigs, air compressors, test-pumping units, and crane trucks across remote counties. Profitability on a borehole project can vanish overnight if daily rig diesel burn per meter drilled in hard basement granite goes unmonitored, expensive Down-The-Hole (DTH) tungsten-carbide button bits wear out prematurely without geological formation logs, plain vs. slotted uPVC/steel casing lengths and gravel-pack tonnage are miscounted on site, or Water Resources Authority (WRA) Completion Reports are delayed.
At devManue, we engineer specialized Borehole Drilling, Hydrogeological Survey & Solar Pumping EPC ERP platforms that unify vertical electrical sounding (VES) survey reports, WRA/NEMA regulatory compliance gates, mobile driller meterage & lithology logs, graphic borehole casing string designers, 24-hour step/constant-discharge test-pumping drawdown analytics, and submersible pump + solar PV sizing BOMs.
1. Controlling Rig Diesel, Bit Wear & Per-Meter Drilling Profitability
- Geological Lithology Stratum Logging & DTH Hammer Bit Life Tracking: As the driller advances from
0mto300m+, they log rock cutting samples every 2 meters (topsoil, weathered phonolite, fractured basalt, hard gneiss/granite), water-strike depths, airlift yields (m³/hr), drilling foam/polymer consumption, and exact meters drilled per serialized DTH hammer and tricone/button bit. - Plain vs. Slotted Screen Casing String & Gravel-Pack Reconciliation: Converts the hydrogeologist’s aquifer strike zones into an exact casing installation diagram (e.g., 6-inch plain casing in dry zones, 6-inch slotted screen across water-bearing fractures, bentonite sanitary seal, and 2–4mm washed quartz gravel pack)—billing the client for exact installed meters.
- 24-Hour Test-Pumping Drawdown, Recovery & Safe-Yield Sizing: Ingests timed water-level dipper readings during continuous test-pumping and recovery to compute Static Water Level (
SWL), Pumping Water Level (PWL), Specific Capacity (m³/hr/m), and Total Dynamic Head (TDH) for Grundfos/Dayliff submersible pump and solar array selection.
2. Borehole Test-Pumping Specific Capacity & Solar Pump TDH Sizing Engine
Our hydrogeological engineering engine analyzes 24-hour constant-discharge test-pumping data to compute Specific Capacity, safe sustainable abstraction yield, Total Dynamic Head (TDH), and required solar PV kilowatt-peak (kWp) array capacity:
from decimal import Decimal, ROUND_HALF_UP
class BoreholeHydroEngineeringEngine:
"""
Computes borehole Specific Capacity, safe abstraction yield, Total Dynamic
Head (TDH), and hydraulic/solar power requirements from test-pumping data.
"""
@staticmethod
def evaluate_test_pumping_and_pump_sizing(
static_water_level_m: Decimal,
pumping_water_level_24h_m: Decimal,
test_discharge_rate_m3_hr: Decimal,
elevated_tank_height_m: Decimal,
pipeline_friction_loss_m: Decimal,
safety_yield_factor: Decimal = Decimal("0.70"),
pump_efficiency: Decimal = Decimal("0.60"),
) -> dict:
drawdown_m = pumping_water_level_24h_m - static_water_level_m
specific_capacity = (
test_discharge_rate_m3_hr / drawdown_m
if drawdown_m > 0 else Decimal("0.00")
).quantize(Decimal("0.02"), rounding=ROUND_HALF_UP)
recommended_safe_yield_m3_hr = (
test_discharge_rate_m3_hr * safety_yield_factor
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
total_dynamic_head_m = (
pumping_water_level_24h_m + elevated_tank_height_m + pipeline_friction_loss_m
).quantize(Decimal("0.1"), rounding=ROUND_HALF_UP)
# Hydraulic power P_hyd (kW) = (Q * H * rho * g) / 3.6e6 = (Q * H) / 367
shaft_motor_kw = (
(recommended_safe_yield_m3_hr * total_dynamic_head_m) / (Decimal("367.0") * pump_efficiency)
).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
recommended_solar_pv_kwp = (shaft_motor_kw * Decimal("1.45")).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
return {
"drawdown_m": drawdown_m,
"specific_capacity_m3_hr_per_m": specific_capacity,
"recommended_safe_yield_m3_hr": recommended_safe_yield_m3_hr,
"total_dynamic_head_tdh_m": total_dynamic_head_m,
"required_pump_motor_kw": shaft_motor_kw,
"recommended_solar_array_kwp": recommended_solar_pv_kwp,
}3. Per-Meter Final Re-Measurement Billing & WRA Borehole Completion Certificates
Because borehole contracts are quoted at provisional depths (e.g., 200m) and settled on actual final drilled depth (e.g., 236m), the ERP automatically reconciles the Mobilization Deposit against actual meters drilled, actual plain/slotted casing installed, and test-pumping hours—while generating the statutory WRA Borehole Completion Record with one click.
| Borehole Drilling & Water EPC Metric | Legacy Spreadsheets & Manual Tallying | devManue Custom Enterprise ERP |
|---|---|---|
| Rig Diesel & DTH Hammer Bit Cost per Meter | Blind fuel & bit expenses across upcountry rigs | Exact diesel litres & bit wear tracked per meter & rock stratum |
| Casing, Screen & Gravel Pack Inventory | Leftover uPVC/steel casings disappearing on site | Stratum-linked casing string BOM vs. installed depth audit |
| Test-Pumping Analysis & Pump Selection | Manual Excel plotting; risk of over-pumping/dry-running | Automated drawdown curve, Specific Capacity & TDH sizing |
| Final Depth Re-Measurement & Invoicing | Disputes over extra meters & rock hardness tiers | Signed daily driller depth logs linked directly to final eTIMS bill |
Related Enterprise ERP & Engineering Guides
- Solar EPC & Commercial Clean Energy ERP — Sizing solar PV structures, VFD solar pump inverters, and remote telemetry.
- Smart Water Sub-Metering & Prepaid Utility Billing Software — Monetizing community boreholes and estate water reticulation with M-Pesa tokens.
- Custom Water Engineering, Drilling & EPC ERP — Build your borehole drilling and irrigation platform with devManue.