---
title: Comparison of OSD results between software calculation and excel spreadsheet using ‘Simplified Method’
description: "1. **Project file MiTS 2 [here](https://largefilehosting.s3.ap-northeast-1.amazonaws.com/ProjectSharing/Client%20Project%20-%20Saiful/OSD-backup-2.10.39.0-040723172116.zip)** 2. **Software Report [here](https://largefilehosting.s3.ap-northeast-1.amazonaws.com/ProjectSharing/Client%20Project%20-%20Saiful/12277%20software%20calculation.zip)** 3. **Manual Excel Spreadsheet [here](https://docs.google.com/spreadsheets/d/1C8ivHHsF4AKbPXInj8TrKh-ZYc5sUAoSw5GFdOVjCq8/edit?usp=sharing)** 4. **Linear interpolator [here](https://www.johndcook.com/interpolator.html)** **kindly informed that you will need to download the manual excel spreadsheet and software report* **Objective** 1. **Comparison between software calculation…"
url: "https://mes100.com/docs/comparison-of-osd-results-between-software-calculation-and-excel-spreadsheet-using-simplified-method/"
updated: "2023-07-05"
category: Benchmark / MSMA
tags:
  - Pond
---

# Comparison of OSD results between software calculation and excel spreadsheet using ‘Simplified Method’

1. **Project file MiTS 2 [here](https://largefilehosting.s3.ap-northeast-1.amazonaws.com/ProjectSharing/Client%20Project%20-%20Saiful/OSD-backup-2.10.39.0-040723172116.zip)**
2. **Software Report [here](https://largefilehosting.s3.ap-northeast-1.amazonaws.com/ProjectSharing/Client%20Project%20-%20Saiful/12277%20software%20calculation.zip)**
3. **Manual Excel Spreadsheet [here](https://docs.google.com/spreadsheets/d/1C8ivHHsF4AKbPXInj8TrKh-ZYc5sUAoSw5GFdOVjCq8/edit?usp=sharing)**
4. **Linear interpolator [here](https://www.johndcook.com/interpolator.html)**

**kindly informed that you will need to download the manual excel spreadsheet and software report*

**Objective**

1. **Comparison between software calculation and manual calculation. To ensure that the results are the same**
2. **Software extract the correct value from Table in MSMA 2**

# **OSD Sizing Procedure (MSMA 2 – Simplified Method)**

| Manual Excel Spread Sheet | MiTS Software |
| --- | --- |

**Design Criteria**

Design Manual: MSMA 2

Method: Simplified Method

Type of OSD = Below Ground

**Proposed Development**

Location: Kuala Lumpur

Region: Region 1 – West Coast

Impervious = 0.8 ha ; Pervious = 0.2 ha

Terrain = Lowlying

## **Permissible Site Discharge (PSD) & Site Storage Requirement (SSR)**

| Table 5.A1![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A1-excel.jpg?resize=1080%2C375&ssl=1)Interpolate;PSD = 65.3 l/s/ha, SSR = 499 m3 | Table 5.A1![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/PSD-MiTS.jpg?resize=1080%2C763&ssl=1) |
| --- | --- |

Table 5.A1

![](https://i0.wp.com/mes100.com/wp-content/uploads/2023/07/Table-5.A1.jpg?resize=745%2C370&ssl=1)

| Table 5.A2![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A2-excel.jpg?resize=1080%2C380&ssl=1)Interpolate:PSD : 62.1 l/s/ha, SSR : 487.3 m3, Inlet : 196.67 l/s/ha | Table 5.A2 ![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/PSD-MiTS-A2.jpg?resize=1080%2C763&ssl=1) |
| --- | --- |

Table 5.A2

![](https://i0.wp.com/mes100.com/wp-content/uploads/2023/07/Table-5.A2.jpg?resize=676%2C482&ssl=1)

## **OSD Tank Sizing**

| ![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Tank-Sizing-excel.jpg?resize=1080%2C116&ssl=1) | ![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Tank-Sizing.jpg?resize=1000%2C581&ssl=1) |
| --- | --- |

## **Inlet & Outlet Sizing**

| Table 5.A![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A3-excel.jpg?resize=1080%2C122&ssl=1)![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A4-excel.jpg?resize=1080%2C194&ssl=1)Table 5.A3 Interpolate; Volume (m3) : 500 m3 Inlet & Overflow Dia. (mm): 510 mm Outlet Dia. (mm) : 195 mm Table 5.A4 Interpolate; i) Determine the Overflow Pipe Diameter using Inlet Flow obtained from Table 5.A2 as discharge : 0.1967    m3/s Pipe diameter = 448 mm ii) Determine the Outlet Pipe Diameter using PSD value obtained from Table 5.A2 as discharge 0.0621 Pipe diameter = 294 mm | Table 5.A ![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Inlet-Pipe.jpg?resize=1080%2C531&ssl=1)           |
| --- | --- |

| Table 5.A3![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A3.jpg?resize=1080%2C613&ssl=1) |
| --- |
| Table 5.A4 ** **![](https://i0.wp.com/mes100.com/wp-content/uploads/2019/05/Table-5.A4.jpg?resize=1080%2C755&ssl=1) |

### *Related*

 [![](https://i0.wp.com/mes100.com/wp-content/uploads/2024/10/me-small.jpg?resize=100%2C100&ssl=1)](https://mes100.com/author/admin/)[Ngu Soon Hui](https://mes100.com/author/admin/)

I’m the [Benevolent Dictator for Life](https://en.wikipedia.org/wiki/Benevolent_dictator_for_life) for MiTS Software cum Editor of this website. Read more [here](/about-ngu-soon-hui/).

You can also contact me at soonhui@mes100.com