I have a Survey123 form which my Hydrant inspection guys use when they go out inspecting Hydrants. What I want to do in Survey 123 is be able to calculate the flow rate for each hydrant but I am not sure how to enter this into the XLS form. They already are collecting data on the Static Pressure, Residual Pressure, PSI and Diameter. Can someone help me with the formula to calculate flow rate and where to enter it in the XLS form.
I assume it goes under the Calculate field but am not sure.
Thanks
Solved! Go to Solution.
Not an expert on this, but I found potential explanation here: https://blog.qrfs.com/240-pitot-gauges-how-do-i-calculate-the-psi-to-gpm-conversion/#pitot-calculati...
Following the formula in the blog above, the attached XLSForm would do the trick.
Additionally, it looks like this thread covers this problem too: https://community.esri.com/t5/arcgis-survey123-questions/sruvey-123-hydrant-flow-testing/m-p/802638
I could try to help with the Survey123 syntax (and yes, you'll put the expression in the Calculate column), but could you explain what mathematical formula you need to use to determine flow rate?
Thanks for the response!
I'm not sure if you could provide me with the formula for flow rate. I saw one when I tried searching for it and thought maybe there is a standard formula that is used and maybe if I asked someone would reply with it. I have someone else here working on trying to get it for me too. That's not the main question I had though.
Once I get this formula how would I enter it on the survey123 form. Should I use 'calculate' as type and then Flow Rate as name and label? Should the expression just be entered as is once I know what the expression is?
Thanks
Not an expert on this, but I found potential explanation here: https://blog.qrfs.com/240-pitot-gauges-how-do-i-calculate-the-psi-to-gpm-conversion/#pitot-calculati...
Following the formula in the blog above, the attached XLSForm would do the trick.
Additionally, it looks like this thread covers this problem too: https://community.esri.com/t5/arcgis-survey123-questions/sruvey-123-hydrant-flow-testing/m-p/802638
Thanks for that link! That's what I was looking for
I have added these fields and this calculation into my Survey123 form and the form opens in the Survey123 app like I wanted. Will the GPM field calculate once I submit the form?
When running the referenced calculation above, keep in mind a few variables that may impact results
To not get too worried about the detail if you don't need to, how accurate of a number do you need to report? I have seen everything from some utilities putting flow meters on the hydrant to measure the flow during tests (ideal but takes time and requires flow meters), all the way to to stop-stop-watching the flow event and assuming a flow rate (i.e. 500gpm or some avg based on the size of hydrant). Then multiply by the minutes flowed to arrive at the total volume flushed. If you have time, it could be worth confirming accuracy of calculation against the accuracy of the number you need to have entered: does the additional level of effort provide value.
Thanks for the reply MartinPflanz!
As of now I have the formula working as needed for what we are trying to accomplish.