603 - 5885 1250 (4 lines) info@mes100.com
View Categories

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

< 1 min read

  1. Project file MiTS 2 here
  2. Software Report here
  3. Manual Excel Spreadsheet here
  4. Linear interpolator here

*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 SheetMiTS 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.A1Interpolate;PSD = 65.3 l/s/ha, SSR = 499 m3Table 5.A1

Table 5.A1

Table 5.A2Interpolate:PSD : 62.1 l/s/ha, SSR : 487.3 m3, Inlet : 196.67 l/s/haTable 5.A2

Table 5.A2

OSD Tank Sizing #

Inlet & Outlet Sizing #

Table 5.ATable 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
          
Table 5.A3
Table 5.A4
 

Powered by BetterDocs

× WhatsApp Help