Sumo comes with a set of Excel-based tools to assist your work. This page contains more in-depth information about the available tools in Sumo. We are continuously working on this content to have all the details you are looking for.
In general, Sumo tools are accessible via buttons on the Inputs tab of the relevant process units (e.g. the Influent tool can be opened from the Influent process unit). When you start up a tool from a Sumo project, an Excel file will be opened with the default values. This file will have a unique filename, so that Sumo can assign it to the actual unit and store it within the sumo project file (.sumo, .msumo, etc.) for later use, when it is saved. Thus, multiple Excel tool files can be stored with the project (imagine having multiple influents, each with their own setup, based on data in individual Influent Tool files). This way you can keep all project-related changes to the Excel Tool file(s) within the Sumo project, which comes handy for archiving purposes, as well as when you are working in a group.
If you modify the contents of an Excel Tool file (which is very likely to happen), please make sure that you save it in Excel before saving your project in Sumo, as a project save command in Sumo will pack the saved version of any Excel Tool file that has been associated with the project. So the correct way to handle the management of project-assigned Excel Tool files, is to 1) always save all changes while the tool files are open in Excel and then 2) save your Sumo project.
When a process unit has a saved version of an Excel Tool file in a project, it is indicated by the blue color of the tool button (otherwise being white). If the project is opened again, by clicking the blue tool button on the Input tab, it will open up the relevant file with the last saved data in it.
The purpose of this tool is to help users fractionate their measured influent data into different COD, TKN, and TP fractions that is needed to properly set up the influent model input. Each of the Sumo full plant and focus models have a raw influent and a primary effluent tool which can be accessed by clicking on the influent unit in the Input tab (it is available at the bottom of the screen). The tool is Excel based and is specific to the project and the influent unit. Once the fractionation has been performed, the values should be saved in Excel and become part of the project. This tool will allow users to identify fractions for a constant dataset, meaning, it should be used for average values of a dataset. If multiple datasets are to be fractionated such as winter versus summer, then two tools must be used and saved with different names as part of the project. If the file name is changed, the file can be retrieved from the project directory.
Influent fractionation is one of the key tasks in process modeling and it is very important for users to familiarize themselves with the fractions and the fractionation workflow process. More details can be found in the Influent characterization chapter. Here we present a brief overview of the workflow a user must follow to achieve a successful fractionation and the logic behind the fractionation tool.
Read the Help sheet, it provides brief information regarding the use of the tool.
In the Data sheet tool input the available dataset wherever the values are blue (Column C).
The Check fractions sheet is for:
Copying the values from the tool’s Sumo form to the Sumo influent unit can be done by selecting, copying (Ctrl-C), and pasting (Ctrl-V) in Sumo.
If any of the model parameters including COD/VSS ratios were adjusted, then they should be copied to the Model Setup tab in Sumo.
The fractionation tree sheet helps you visualize fractions and are useful for documentation.
The Diurnal flow sheet creates three types of hourly dynamic influent data (small, medium and large plants) for 24 hours using the Flow value provided in the C3 of Data sheet. This dynamic table is useful for setting up dynamic simulation in case no diurnal data is available.
The Birthday cake sheet provides hourly data for a simplified birthday cake analysis of 16 days. This is useful for sizing and evaluating plant performance under diurnal variation, monthly maximum load and peak daily load conditions. For further details we suggest to look into the Guidelines for Using Activated Sludge Models published by IWA.
The purpose of this tool is to identify parameters for the clean water oxygen transfer modeling function through curve fitting using diffuser equipment testing data. The tool can be reached from View|Directories|Tools folder by opening Dynamita aeration (SOTE) tool.xlsm. Be aware that the tool is using VBA macros. You can save the tool anywhere, even drag and drop the file to the Notes (bottom right panel) on the Configure tab in Sumo so it will be stored with your project.
The parameters identified are plugged into the Oxygen transfer efficiency correlation parameters table in the reactor model for calibration of the plant’s diffuser system. In the Input methods sheet, users start by selecting the type of diffuser and the units for key information to be processed by the tool. The selection criteria are presented below.
Next step is to switch to the Data sheet and provide data from manufacturer specifications or plant measurement campaigns within the Measurements table and provide the Physical data such as Diffuser height from floor and Area per diffuser. The tool comes with a default set of demonstratory data which must be removed by clicking the Clear data input button at the upper left corner of the sheet. Also available is a reference sheet containing common diffuser type unit areas, for estimating the active surface area. Once the new data is entered, users must press the Import data button to start the automated data manipulation. The details of these calculations can be seen in the Calculations sheet where the dataset is processed for curve fitting.
In the Plot & estimate sheet the parameters are estimated for the expression predicting SSOTE, including the correction term for diffuser submergence and the diffuser density by adjusting the function parameters to match the measured data (Estimate parameters button on the left side of the sheet). See the figure below showing the fitted curve.
The last step is to copy the values from the Sumo forms sheet in the tool into the reactor’s Oxygen transfer efficiency correlation parameters in Sumo within the Inputs tab.