Hi, I was tasked with figuring out if auto-sizing storm piping with dynamo is something my office should adopt into our workflow. I created the graph below following an autodesk university class on pipe sizing but ran into an issue on the last step.
My goal is to pull the flow parameter from all storm piping (hydronic return classification) and compare this demand with the IPC storm piping sizing table that I have in excel (capacity) and then use that table to set the diameter parameter of the pipe. EX: a pipe with flow of 75 gpm falls in the range 56-115 and would require a 4" pipe. I originally used the list.firstindexof node to compare the demand and capacity lists but it returned all -1 values. I am guessing this is because the demand flow does not exactly match the capacity.
I messed with a couple other ideas but could not get anything to work
So, I just wrote a code block for the ranges and used Boolean filters. This got the job done but it is not very flexible. Ideally others in my office could use this in dynamo player and modify the capacities by editing the excel file and not have to edit the code block.
I am very new to dynamo so it is probably a simple fix but I have spent hours reading posts on here and cannot figure out what needs to be changed. Any suggestions would be greatly appreciated!