Hi,

I have used Network Analyst to create a model that has resources going from Demand to Facility, with a set number of demand points and a variable number of facilities. I have a model in Model Builder that solves this problem, but I need to do several calculations on the solution.

Each line from Demand to facility has a weight, and time associated with it. I want to use Model Builder to sum these up for the lines that end in the same location. The lines all have a field that contains ONLY the destination, so I want to separate the table by those values.

Is there a way to use Model Builder to sum up all the times and weights for Dest1, Dest2, Dest3 etc.? I want to find the total amount of weight that ends up at the different destinations, and the total amount of time necessary to get all of it there.

Thanks a bundle,

Nathan S.

I have used Network Analyst to create a model that has resources going from Demand to Facility, with a set number of demand points and a variable number of facilities. I have a model in Model Builder that solves this problem, but I need to do several calculations on the solution.

Each line from Demand to facility has a weight, and time associated with it. I want to use Model Builder to sum these up for the lines that end in the same location. The lines all have a field that contains ONLY the destination, so I want to separate the table by those values.

Is there a way to use Model Builder to sum up all the times and weights for Dest1, Dest2, Dest3 etc.? I want to find the total amount of weight that ends up at the different destinations, and the total amount of time necessary to get all of it there.

Thanks a bundle,

Nathan S.

As far as I understand your problem, you should look to the tool named "Summary Statistics". In your case you can use your destination field ("The lines all have a field that contains ONLY the destination") as the "Case field". Then just select the others fields in "Statistics Field(s)". You will then be able to calculate their SUM (or MEAN,..) for each "Destination Field value (Dest1, Dest2,...)" and export the results to a new table.

Link to "Summary Statistics":

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00080000001z000000

Hope this helps :confused:

Cheers,

Theo