how we can use the model builder to assign sanitary loads in SewerCAD if we have big network with different unit load type and rates? for example if we have some manholes has only residential and others has residential and commercial and others have residential, commercial and industrial; let us say based on population and different unit loads (280, 150, 80 L/cap/day), is that could be done buy model builder? if yes; how could be done and if there is example will be appreciated..!!
Please have a look the these support solutions, which would help you in importing sanitary loads using Modelbuilder.
communities.bentley.com/.../2708.importing-loading-information-using-modelbuilder-tn
communities.bentley.com/.../importing-patterns-using-modelbuilder
Regards,
Sushma Choure
Bentley Technical Suppport
Answer Verified By: Jesse Dringoli
Any idea how we can use model builder to accommodate the population if I have it in excel sheet as in the example below; please not I have at one manhole different categories.
Hi Scott, Exactly, I have different unit loads for the same manhole and I need to import them one at a time. That dose not work because it is override the previous import. would you please provide the steps to be in your TN; also if you can upload example for guidelines will be awesome and appreciated.
And also what is Load Definition (ID) and Load Definition (Label), Unit Sanitary Load (ID) and Unit Sanitary Load (Label); how to be used in the model builder.
last thing using model builder it does create new manholes in other locations; while I have the network and only needed to apply the loads.
Load Definition (ID) Regards
Hello,
I did some testing with a sample model. I created a simple model with just a couple of manholes. I also created spreadsheet as specified in the TechNote with the unit load information. Below is a screenshot of the spreadsheet setup:
Note that MH-1 is listed twice and that two different unit loads are being used (Industrial and Residential). The formatting of your spreadsheet will need to be similar, with each manhole and unit load in its own row. In your example, you have listings for Residential, visitors, and workers for MH-01. You will need to alter your spreadsheet so you have MH-01 listed in three rows, and the unit load each row being set to either Residential, visitors, or workers. The appropriate unit count will be included as well.
Back to my sample model, I went through the ModelBuilder process as stated in the support solution for the issue. When I did this, the two different unit loads were correctly applied to MH-1, as seen in the screenshot below.
The key is that you must have all unit loads in the spreadsheet to begin with. My suggestion of updating is not accurate, as this will overwrite the existing information. If it is all there to begin with though, all data should be included. I have updated the support solution to include the information above.
Regarding the attributes "Load Definition (ID)," "Load Definition (Label)," "Unit Sanitary Load (ID)," and "Unit Sanitary Load (Label)", the definitions for these are given in the support solution. "Load Definition (Label)" is the field containing the type of sanitary load you are importing and "Unit Sanitary Load (Label)" is the field containing the name of the unit load for a unit sanitary load. As for the "ID" attributes, the ID is an internal number generated by the program. This is not required in the process and you should just use the label instead.
Regarding the last item, if the Label you are using does not match up with any label in the model, a new manhole will be created. You will need to make sure that the labels in the spreadsheet match with the labels in the model. For instance, with the spreadsheet label is "MH-01" and the model label is "MH-1", a new manhole called MH-01 will be created at the default location in the model, which is typically at X:0.00 ft, Y:0.00 ft.
Scott
Answer Verified By: Mohd Azzam