TP108 Spreadsheet

Rainfall analysis is a critical component of any drainage system design. The CivilWeb TP108 Spreadsheet includes rainfall analysis for New Zealand in accordance with the standard. This allows more detailed and therefore more accurate and often more economical drainage designs to be completed.

The CivilWeb TP108 Spreadsheet can be purchased lower down this page for only $39.99. Or why not buy our best value bundle? Our Full Drainage Design Spreadsheet Suite can be purchased at the bottom of this page for only $99.99. This suite includes all of our drainage design spreadsheets, more than 20, and represents an incredible saving of more than 85%.

TP108 Spreadsheet - License Type
Full Drainage Design Suite - License Type

What is TP108 New Zealand Rainfall?

TP108 refers to Auckland Council’s Technical Publication 108, a foundational document that provides rainfall depth–duration–frequency (DDF) data for use in stormwater and flood‑management design across much of New Zealand. It supplies statistically modelled rainfall intensities for a range of storm durations and return periods, allowing engineers to size pipes, culverts, detention basins, and overland flow paths with a consistent, evidence‑based approach.

The rainfall data in TP108 is derived from long‑term historical records and is presented in a way that supports both simple and advanced hydrological modelling. Designers use it to determine how much rain is expected during a 2‑year, 10‑year, 50‑year, or 100‑year storm, and how quickly that rain is likely to fall. This ensures stormwater systems are built to withstand realistic peak flows and protect communities from flooding.

Key features of TP108 rainfall data include:

  • Depth‑duration‑frequency tables for multiple storm return periods
  • Region‑specific calibration for New Zealand conditions
  • Compatibility with common hydrological models (e.g., Rational Method, SCS, HEC‑HMS)
  • Guidance for climate‑change allowances and sensitivity testing

Common TP108 New Zealand Rainfall Design Methods

Stormwater designers apply TP108 rainfall data through several established methods, each suited to different project scales and levels of complexity.

  • Rational Method — A widely used approach for small catchments. Designers combine TP108 rainfall intensity with catchment area and runoff coefficients to estimate peak flow. It is simple, fast, and ideal for pipes, channels, and small urban drainage networks.
  • Hydrograph‑Based Modelling — Tools such as HEC‑HMS, MIKE, or DRAINS use TP108 rainfall hyetographs to simulate how runoff accumulates and flows over time. This method is preferred for detention basins, wetlands, and larger catchments where timing and storage effects matter.
  • SCS Curve Number Method — Often used for rural or mixed‑use catchments. TP108 rainfall depths feed into the SCS equations to generate runoff volumes and peak flows, especially where soil type and land cover strongly influence infiltration.
  • Design Storm Hyetographs — TP108 provides the rainfall depths; engineers then apply standard hyetograph shapes (e.g., Auckland Council’s recommended temporal patterns) to model how rainfall intensity varies during the storm.
  • Climate‑Adjusted Design — Many councils require designers to apply climate‑change multipliers to TP108 rainfall depths. This ensures infrastructure remains resilient under future rainfall intensification scenarios.

Each method requires careful selection of storm duration, return period, catchment characteristics, and safety factors to ensure the final design meets regulatory and performance requirements.

Why Use a TP108 New Zealand Rainfall Design Spreadsheet?

A TP108 design spreadsheet streamlines the process of converting rainfall data into usable design inputs. Because TP108 includes multiple tables, durations, and return periods, a spreadsheet helps avoid errors and speeds up repetitive calculations.

Benefits include:

  • Automated lookup of rainfall depths and intensities for any duration or return period
  • Consistent application of formulas for peak flow, hydrographs, and storage sizing
  • Built‑in climate‑change adjustments to test future scenarios
  • Scenario comparison tools for different catchment assumptions or design storms
  • Clear documentation that supports council submissions and peer review

For consultants, councils, and developers, a well‑structured spreadsheet becomes a reliable tool that improves accuracy, reduces design time, and ensures compliance with New Zealand stormwater standards.

Get Started Today

Save hours of repetitive calculation time. Whether you’re working on a major project or a small renovation, this tool will give you clarity, accuracy, and confidence.

Buy the CivilWeb TP108 Spreadsheet now for only $39.99.

Or alternatively big savings are available with our TP108 and Rainfall & Runoff design bundle. Get both spreadsheets for only $99.99.

TP108 Spreadsheet - License Type

Or save $300+ by buying our full Drainage Design Suite including all our drainage design spreadsheets.

Full Drainage Design Suite - License Type
PIPE FLOW CALCULATOR

This spreadsheet uses the Colebrook-White and Manning Equations to calculate the flow capacity and velocity in pipes acting under gravity.

Find Out More

Buried Pipe Design Spreadsheet

This spreadsheet can be used to design concrete, steel, plastic and other buried pipes in accordance with BS EN 1295-1.

Learn More

Manning Open Channel Design Spreadsheet

This spreadsheet uses the Manning formula to calculate the flow conditions in an open channel acting under gravity only.

Learn More

Runoff Calculator Spreadsheet

This spreadsheet calculates the design runoff flow for a site in accordance with the Flood Estimation Handbook.

Learn More

Linear Drainage Design Spreadsheet

This spreadsheet calculates the maximum flow from a specified linear drainage channel and checks whether the channel is sufficient for the specified site and storm conditions.

Learn More

Attenuation Design Spreadsheet

This spreadsheet calculates the requirements for a attenuation system and assists the user to design a suitable system.

Learn More

Field Drain Design Spreadsheet

This spreadsheet can be used to design field drains, typically subsurface drainage systems used to drain fields and open areas.

Learn More

Drainage Field Design Spreadsheet

This spreadsheet can be used to design septic infiltration systems known as drainage fields, leach fields or septic drain fields.

Learn More

TP108 Spreadsheet

This spreadsheet calculates the rainfall for New Zealand catchments in accordance with TP108.

Learn More

Roof Downpipe Calculator Spreadsheet

This spreadsheet calculates the size of roof drainage downpipes depending on the roof catchment and rainfall requirements.

Learn More

Permeable Pavement Design Spreadsheet

This spreadsheet is designed to determine the size and characteristics of permeable pavements.

Learn More

Infiltration Blanket Design Spreadsheet

This spreadsheet can be used to design thin depth infiltration systems, typically called infiltration blanket systems.

Learn More

Swale Design Spreadsheet

This spreadsheet can be used to design swales. These linear grassed channels can be used both to convey, infiltrate and filter surface drainage runoff.

Learn More

Filter Strip Design Spreadsheet

This spreadsheet is designed to analyse surface water filter strips and to determine the max flow depth and max flow velocity and determine whether they are in accordance with relevant standards.

Learn More

Hydraulic Gradient Analysis Spreadsheet

This spreadsheet analyses the hydraulic and energy grade lines for drainage systems with up to 10 drainage runs.

Learn More

Soakaway Design Spreadsheet

This spreadsheet calculates the requirements for a soakaway system and assists the user to design a suitable system.

Learn More

Concrete Protection Slab

This detailed design spreadsheet designs a protection slab commonly installed to protect shallow pipes.

Learn More

French Drain Design

This spreadsheet completes French Drain Design in accordance with the SUDS Manual.

Learn More

Sharp Crested Weir Flow Calculator Spreadsheets

This suite of 5 separate spreadsheets calculates the flow over sharp crested weirs of all shapes and sizes.

Learn More

Drainage Design Spreadsheet

This is the full suite of drainage design spreadsheets, available at a massive discount for only £49.99.

Learn More