Query Report Manager for Customized Reports in InfoSWMM and InfoSWMM SA

Here is my suggestion to closely replicate your excel table of a mixture of input and output link variables:
  1. Run the model and then make an output relate of the Conduit Summary Table
  2. Create a DB Query (a Query is needed) based on finding ALL link data, I used length > 0
  3. Use the Tool Query Report Manager
  4. Select your needed mixture of Link Variables and Link Output Data
  5. Generate your table and customize the look
  6. Copy the table to Excel for further customization

Privileged and Confidential Communication: This electronic mail communication and any documents included hereto may contain confidential and privileged material for the sole use of the intended recipient(s) named above. If you are not the intended recipient (or authorized to receive for the recipient) of this message, any review, use, distribution or disclosure by you or others is strictly prohibited. Please contact the sender by reply email and delete and/or destroy the accompanying message.

Comments

Post a Comment

Popular posts from this blog

Soffit Level

Image
Soffit Level
(pipe technology)The top point of the inside open section of a pipe or box conduit.
The soffit is the highest point of the internal surface of a pipe or culvert at any cross-section. The soffit is also referred to as the pipe obvert.
So it is not quite the Crown of the Pipe.  Here is an image I found that hopefully explains it better.


Read more

SWMM 5 Error Messages

Engine Error Number Description ERROR 101: memory allocation error.                                                                                             ERROR 103: cannot solve KW equations for Link                                                                                   ERROR 105: cannot open ODE solver.                                                                                              ERROR 107: cannot compute a valid time step.                                                                                     ERROR 108: ambiguous outlet ID name for Subcatchment
Read more

Orifice and Weir flow calculations

Note:Orifice and Weir Flow ComputationsThe orifice flow calculation proceeds as follows:1. Initially and whenever the setting (i.e., the fraction opened) changes, flow coefficients for both orifice and weir behavior are computed as follows: a. For side orifices: Define Hcrit = h/2 where h is the opening height. b. For bottom orifices: i. For a circular orifice, compute area over length (i.e., circumference) as AL = h /4. ii. For a rectangular orifice compute AL = h*w/(2*(h+w)) where w is the opening width. iii. Compute Hcrit = Cd*AL/0.414 where Cd is the orifice discharge coefficient.At step 1b, the critical head for the bottom orifice, where orifice flow turns into weir flow, is found by equating the result of the orifice equation to that of the weir equation Cd*Area*sqrt(2g)*sqrt(Hcrit) = Cw*Length*sqrt(Hcrit)*Hcrit or Hcrit = (Cd * Area) / (Cw/sqrt(2g) * Length) The value of Cw/sqrt(2g) for a sharp crested weir is 0.414. c. Compute the flow coefficients …
Read more