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 £19.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 £49.99. This suite includes all of our drainage design spreadsheets, more than 20, and represents an incredible saving of more than 85%.
Follow this link for the Australian version of this page.
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 £19.99.
Or alternatively big savings are available with our TP108 and Rainfall & Runoff design bundle. Get both spreadsheets for only £29.99.
Or why not bundle with the CivilWeb UK Rainfall Analysis spreadsheet for only £10 extra?
Or save £50+ by buying our full Drainage Design Suite including all our drainage design spreadsheets.
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.