...
I have also modified the apparatus from my experiences playing with it (and having it produce very erratic results) in the lab. There were some pieces that caused the tubes to balance incorrectly and cause "hidden headloss". I set up the improved apparatus with pressure sensors to collect precise data, and I have taken a few data sets with it so far.
I plan to continue the data collection and get the MathCAD sheet working soon so I have plenty of time to compare the data to the theoretical expectations this semester. I have already found one more modification that I need to make to the apparatus from this preliminary data set, though.
...