Engineering Automation in Interception and Diversion Design: A Production Management Approach Using an Excel-Based Tool

Abstract

Automation in early-stage infrastructure design remains limited in public sector contexts, where high-end digital tools are often inaccessible. In wastewater management, particularly Interception and Diversion (I&D) works, design workflows are still predominantly manual, leading to inconsistencies, delays, and suboptimal coordination across stakeholders.

To address these challenges, this paper introduces an Excel-based tool that automates the preliminary hydraulic design of I&D components, embedding Indian Standards (IS 6280, IS 6279) into its computational logic. The tool enables standardized design of screen chambers, grit chambers, and pump wells using simple user inputs such as flow, elevation, and pipe data. Outputs include key sizing parameters, BOQs, and equipment selection support.

Framed through the lens of Project Production Management (PPM), the tool’s performance is analysed against the five foundational levers: Product Design, Lead Time, Capacity, Inventory, and Variability. A case study from the Karaikal I&D project demonstrates time savings, repeatability, and reduced design variability. The paper further contrasts this approach with more advanced 3D modelling tools, clarifying the boundary between concept-level automation and detailed engineering.

This work contributes a replicable, low-cost alternative for semi-urban infrastructure design, offering production-aligned efficiency gains while maintaining regulatory compliance.

Keywords: Engineering Automation; Project Production Management (PPM); Interception and Diversion (I&D); Hydraulic Design; Excel-Based Design Tool; Infrastructure Standardization; Product Design Lever; Lead Time Reduction; Municipal Engineering; Civil Infrastructure Digitization.


Introduction

Design automation has transformed many domains of engineering, yet civil infrastructure, especially public sector water projects, continues to rely heavily on manual processes. In Interception and Diversion (I&D) works—used to intercept wastewater from open drains and route it to sewage treatment plants—manual design approaches lead to delays, cost overruns, and inconsistent outcomes.

This paper addresses the gap by presenting a lightweight, Excel-based tool tailored to automate early-phase I&D designs. The tool uses embedded engineering logic drawn from Indian Standards (IS), ensuring compliance and consistency. It is positioned as a pre-engineering automation tool: one that supports rapid, structured, and scalable design, while not replacing detailed 3D or structural modeling workflows.

The research is framed using the five levers of Project Production Management (PPM), illustrating how design standardization and automation contribute to system-wide improvements in delivery time, resource use, and variability reduction. A real-world application in Karaikal, India, grounds the discussion and highlights the tool’s capabilities and limitations.

Background and Related Work

Project Production Management in Infrastructure

Project Production Management (PPM) is a framework that conceptualizes project delivery as a production system. Originating from lean manufacturing principles, PPM introduces a systematic approach to reduce waste, control flow, and optimize variability across project stages. The five key levers—Product Design, Lead Time, Capacity, Inventory, and Variability—serve as actionable points to align planning, design, and execution.

In infrastructure, these levers are rarely applied during the design phase, which is paradoxical considering that early decisions significantly influence downstream execution efficiency. Design not only defines physical configuration but also governs how resources, time, and workflows interact during construction. Integrating PPM thinking into design therefore represents a strategic shift toward production-aware planning in civil projects.

This research explores how a pre-engineering tool—built using Excel—can inherently reflect these PPM levers by standardizing design outputs, reducing manual effort, and improving resource predictability for I&D infrastructure.

Engineering Automation in Civil Design

While automation in mechanical and industrial design is well-established, its adoption in civil engineering is uneven. High-end platforms like Revit, Civil 3D, and BIM 360 offer parametric modeling and simulation but demand significant investment in software and training.

Municipal infrastructure design is often done using spreadsheets, paper sketches, and manual checks. This presents a critical opportunity for intermediate-level tools—automated, standards-driven, and executable in Excel—to fill the gap between manual and BIM-based workflows.

Related Work and Tool Positioning

Prior studies in engineering automation have focused on 3D-driven tools for transportation, urban drainage, and treatment infrastructure. Most of these tools require integration with proprietary platforms or GIS engines. While effective, they often lack backward compatibility or customization for small-scale infrastructure projects.

This paper positions the Excel-based tool not as a replacement for full-scale modeling, but as a preliminary automation layer. It operates upstream of CAD/BIM, providing standardized sizing, BOQs, and logical frameworks. This aligns with recent research advocating for distributed intelligence in infrastructure systems, where localized, adaptable tools augment traditional workflows in design and procurement.

Tool Methodology

The Excel-based tool developed for this study functions as a decision-support system for engineers working on preliminary I&D designs. Its methodology is structured around converting user inputs into technically compliant design outputs using a standards-based rule engine.

Scope and Design Philosophy

The tool is designed specifically for early-stage planning. It does not perform structural simulations, geotechnical verifications, or 3D modeling. Instead, it focuses on:

  • Dimensional sizing of screen chambers, grit chambers, and pump wells
  • Preliminary pump selection
  • Flow-related checks and detention calculations
  • Generating BOQs and schematic summaries for tendering and coordination
  • The design logic is hard-coded using Indian Standards (IS 6280, IS 6279, CPHEEO Manual), ensuring regulatory compliance and repeatability.

Inputs and Configurable Parameters

User inputs are limited to essential, measurable quantities collected during field reconnaissance or preliminary planning:

  • Population served and peaking factor
  • Flow discharge (average and peak)
  • Drain geometry: width, slope, depth
  • Elevation data: Ground Level (GL), Invert Level (IL), Maximum Water Level (MWL)
  • Pipe diameter and material
  • Length and routing of rising main
  • Desired pump capacity or discharge head
  • Drop-down menus and cell-protection features ensure that inputs are validated and restricted to feasible ranges.

Computational Logic and Output Structure

Each subcomponent (screen, grit chamber, pump well) is linked to a backend logic table that contains:

  • Standard equations embedded with dynamic variables
  • Design thresholds and constraints
  • Warning triggers (e.g., velocity outside allowable range, insufficient detention)
  • Auto-generated BOQ templates and basic datasheet formats

Outputs include:

  • Chamber dimensions and volumes
  • Effective depth, velocity, detention time
  • Pump selection (flow, head, HP)
  • A tabulated bill of quantities
  • Summary charts for communication and review

Figure 1: Tool Workflow Diagram

Exclusions and Boundaries

The tool does not perform:

  • Structural verification or reinforcement design
  • Surge pressure simulation (CFD)
  • GIS-based spatial analysis
  • AutoCAD/BIM drawing export (planned in future updates)

It is intended to complement—not replace—professional judgment and detailed design packages.

Figure 2: Input–Output–Exclusion Map

Figure 3: Tool Usage Flowchart

Design Criteria and Engineering Equations

The Excel-based tool incorporates design logic drawn from Indian Standards and hydraulic engineering principles. It focuses on dimensioning core components of Interception and Diversion (I&D) works—namely, screen chambers, grit chambers, and pump wells—using standardized equations and parameter checks.

Screen Chamber Design

The screen chamber is the first line of defence against floating and coarse solid debris. Its efficiency depends on maintaining appropriate flow velocity, bar spacing, and head loss.

  • Reference Standard: IS 6280:1971 – “Requirements for Mechanical Screens”
  • Design Flow Velocity: 0.6 – 0.9 m/s through the screen opening
  • Permissible Head Loss: ≤ 0.3 m under peak flow conditions
  • Bar Spacing: Typically, 15 – 25 mm for coarse screens
  • Calculation Formula:
    A=Q/Vx Cf
    A = Required net open area (m²)
    Q = Peak discharge (m³/s)
    V = Approach velocity (m/s)
    Cf​ = Clearance factor (typically 0.7–0.8 to account for bar thickness and blockage)

The tool calculates required screen chamber dimensions based on site-specific flow data, bar spacing, and effective area requirements.

Grit Chamber Design

Grit chambers are designed to settle heavy inorganic particles such as sand, gravel, and silt without removing lighter organic matter. Design is governed by principles of sedimentation and flow control.

  • Reference Standard: IS 6279:1971 – “Design and Construction of Grit Removal Units”
  • Minimum Particle Size: ≥ 0.2 mm (medium silt)
  • Permissible Flow Velocity: 0.25 – 0.3 m/s
  • Detention Time: 60 – 90 seconds
  • Chamber Length:
    L=V x T
    L = Required chamber length (m)
    V = Flow velocity (m/s)
    T = Detention time (s)

The Excel tool selects grit chamber sizing to ensure sedimentation without re-suspension. It provides a warning if velocity exceeds recommended limits or if length is undersized.

Pump Well Design

The pump well (or wet well) collects wastewater and temporarily stores it before lifting it to the next treatment level. It is designed to hold peak inflows while maintaining minimum submergence to prevent vortex formation.

  • Reference: CPHEEO Manual, Part A (Government of India)
  • Design Flow: Peak Wet Weather Flow (PWWF)
  • Detention Time: 15 – 20 minutes
  • Volume Calculation:
    V=Q x t
    V = Required storage volume (m³)
    Q = Peak flow (m³/s)
    t = Detention time (s)
  • Depth Calculation:
    D=V/A
    A = plan area of pump chamber (m²)

The tool calculates the required volume, recommends well diameter, and adjusts for minimum submergence based on pump type.

Pump Selection and Power Estimation

Pump selection is based on required discharge and total dynamic head. Efficiency assumptions are configurable but default to standard motor and impeller ranges.

  • Total Head:
    H=Hs + Hf
    Hs​ = Static head (elevation difference)
    Hf​ = Friction head loss in the rising main
  • Pump Power:
    P=Q x H x 9.81/ η x 1000
    P = Power in kilowatts (kW)
    Q = Flow rate (m³/s)
    H = Total head (m)
    η = Efficiency (typically 0.6 – 0.7)

The tool outputs horsepower (HP), flow rate, and head recommendations, helping engineers create a procurement-ready pump datasheet.

Validation and Warnings

The Excel backend includes logic-based error prompts:

  • Warnings if detention time is too short or long
  • Alerts for invalid head loss or screen bar spacing
  • Visual cues (e.g., red cells) for any parameter out of range

Case Study: Drain No. 17, Karaikal

Project Context and Challenges

Drain No. 17 in Karaikal, Puducherry, is a critical urban drainage line discharging into the natural watercourses. It traverses a densely built environment with narrow road margins, limited utility corridors, and severe spatial constraints. This context made it practically impossible to implement conventional side-mounted I&D structures, such as grit chambers or pump wells adjacent to the drain. Moreover, the site was characterized by unpredictable ground conditions, service line congestion, and stakeholder-imposed requirements to avoid visible disruption or excavation outside the existing channel width.

The engineering challenge here was twofold: (1) how to develop an efficient I&D system within the geometry of the existing open drain, and (2) how to do so rapidly and accurately, given the programmatic urgency to complete detailed design within days, not weeks.

Figure 4: Site Photo – Drain No. 17, Karaikal with Flow Direction and Drain

Tool Deployment and Configuration

The Excel-based tool was utilized to develop an embedded solution within the existing drain structure. Key features include:

  • Design flow input: 5.454 liters per second, based on projected population and standard peaking factors.
  • Chamber design: A screen chamber of 1.4 m × 2.0 m was dimensioned to handle the peak flow, with bar spacing and velocity calculations embedded in the tool.
  • Pump well design: Based on calculated detention requirements, a circular pump well of 2.0 m diameter and 3.788 m depth was selected.
  • Pipe and pump selection: A 160 mm dia. pipe over 50 m was sized, and a 2 HP pump was selected to accommodate a 15 m head, with total dynamic head derived from elevation differences and pipe friction loss factors.
  • Output formats: The tool generated a bill of quantities (BOQ), design summary sheets, and key hydraulic performance metrics for stakeholder review.

Field-Level Application and Adjustments

The tool allowed for rapid iterations in response to minor site-level changes. For instance, an initial assumption about available invert levels was invalidated by on-ground survey, prompting a recalibration of pump head and well depth—carried out within minutes using the tool. This case validated the tool’s flexibility, reliability, and alignment with site constraints, confirming its relevance in tight urban geometries where traditional workflows falter.

Analysis Through the Lens of Ppm Levers

This section reframes the tool’s engineering output through the perspective of Project Production Management (PPM), demonstrating how the tool inherently addresses systemic inefficiencies common in civil infrastructure delivery.

Product Design Lever

The tool transforms infrastructure design from a bespoke engineering task into a configurable, template-driven system. Instead of independently sizing chambers and pumps for each site, standard component families are defined (e.g., pump wells in three size classes). This supports productization in public works, enabling modularity across multiple drains, reducing cost variability, and increasing interoperability of components.

Lead Time

Traditionally, hydraulic sizing, BOQ generation, and pump selection for I&D works require 3–5 days per site, including calculations, documentation, and validation. By encoding logic and standards, the tool reduces this cycle to 5–6 hours per drain. This ~75% reduction in lead time accelerates overall project progress, especially important when parallel drains must be commissioned concurrently.

Capacity

The tool optimizes capacity across engineering resources. A junior engineer can now perform tasks that previously required a senior designer’s attention. This liberates skilled personnel to focus on strategic design reviews, stakeholder engagement, and conflict resolution. It also allows multiple sites to be designed in parallel without requiring proportional increases in manpower.

Inventory

The tool improves alignment between design intent and material procurement. Over-sizing is avoided by matching dimensions precisely to required flows. This reduces the risk of excess pump capacity, unnecessary excavation, and overspend on concrete or reinforcement—particularly valuable in budget-constrained public works.

Variability

Manual design introduces variability due to interpretation differences and formula inconsistencies. By codifying the design process, this tool ensures that all outputs conform to the same standards regardless of who operates it. This promotes design repeatability, minimizes review time, and enhances trust between design and construction teams.

Discussion

Positioning the Tool in the Engineering Automation Landscape

This tool represents a middle ground in the spectrum of digital engineering. On one end lie manual workflows—time-intensive and error-prone. On the other lie comprehensive BIM ecosystems, integrating design, simulation, and lifecycle planning. The Excel tool falls in between: it automates the calculative and regulatory logic but stops short of 3D modeling, structural checks, or geospatial analysis.

For many municipalities and contractors in India, where BIM is either cost-prohibitive or underutilized, such a lightweight yet standards-compliant solution offers a pragmatic alternative. It ensures design intent aligns with execution feasibility, without requiring new software investment or specialized training.

Figure 5: Comparison of Traditional Manual Design vs Excel Tool-Based Workflow

Designing for Execution, Not Just Performance

One of the key distinctions raised during tool evaluation was whether the tool supports “doing the work” — that is, whether it accounts for how physical construction is actually executed in the field. While the tool is not a construction planning software, it does incorporate critical execution-related inputs:

  • Invert levels and depth constraints, which directly influence excavation effort
  • Pump well dimensions, kept within safe manual excavation and shoring limits
  • Pipe lengths and slopes, impacting constructability in narrow urban corridors
  • Lift height and head loss, guiding realistic pump selection and suction conditions

By embedding these physical parameters, the tool helps avoid overdesign — such as overly deep wells, oversized pump chambers, or infeasible slope profiles. It ensures that the resulting design is not just technically correct, but practical to build and maintain.

In this way, the tool supports a production-aware design mindset. It enables engineers to make decisions that reflect the constraints of actual construction work, bridging the gap between drawing-board logic and field execution. Thus, the tool advances an optimal design—not only in hydraulic terms, but also in how easily and efficiently that design can be built.

Limitations and Boundary of Application

The tool’s scope is clearly limited to preliminary hydraulic design. It does not:

  • Perform structural analysis
  • Simulate transient hydraulic phenomena (e.g., water hammer, surge)
  • Automatically generate CAD/BIM drawings
  • Account for constructability or site logistics

Thus, it does not replace engineering judgment or detailed design validation. However, it complements them by ensuring the upstream logic is sound, uniform, and repeatable.

Feedback and Evolution

The tool has already undergone multiple iterations based on user feedback. One example is the recalibration of detention time formulas after pump suction failures in early sites. This feedback loop supports continuous improvement, ensuring the tool evolves in line with field conditions and engineering best practices.

Future enhancements may include:

  • Integration with GIS platforms for terrain-aware design
  • Scripting add-ins for CAD export
  • Web-based versions for multi-user collaboration
  • Batch-processing capabilities for citywide drain mapping

Implications for Project Management and Public Works

By combining regulatory logic, automation, and production alignment, the tool offers a path for digitally transforming municipal engineering. It allows for:

  • Faster tender preparation
  • Evidence-based budgeting
  • Transparent design documentation

Moreover, the integration of PPM thinking at the design stage is a shift in how public infrastructure is conceived. Instead of firefighting downstream issues, production-aware design pre-empts them—aligning project management with execution reality.

Conclusion

This study presents a replicable, Excel-based tool that automates the hydraulic design of I&D structures using Indian Standards. It delivers practical value in early-stage design while aligning with core principles of Project Production Management.

By embedding logic around flow, head loss, and constructability, the tool supports faster, leaner, and more reliable civil infrastructure delivery — especially in small- to mid-scale municipal programs.

References

  1. IS 6280 (1971): Sewage Screens
  2. IS 6279 (1971): Grit Removal Equipment
  3. CPHEEO Manual on Sewerage and Sewage Treatment
  4. Project Production Institute (2023). Project Production Control Framework
  5. Ballard, G. (2008). Lean Project Delivery System
  6. Howell, G. & Koskela, L. (2002). Theory of Project Management
© 2025 Project Production Institute. All Rights Reserved.