It is currently Thu Feb 22, 2018 4:58 am

Reply to topic  [ 5 posts ] 
 Lost spreadsheet 
Author Message

Joined: Tue Sep 21, 2010 8:39 pm
Posts: 4
Hi All,

I just signed up to the new forum after being away for a few years. I've dusted off my flowbench for a new project and found that my laptop crashed and took out all the spreadsheets I used for my flowbench (pitot style with liquid manometers). Anyone have a pointer to the calcs necessary and/or an excel spreadsheet to do them? I tried searching the old forum but can't login there and can't search without logging in.



Wed Sep 22, 2010 9:25 am

Joined: Fri Jan 08, 2010 10:36 pm
Posts: 1171
Location: Maryland
Posting For Doug "SLRacer" as he has been MIA
The following is a repost of his from the old forum.

Hi all, Here is the pitot style bench spreadsheet I promised in my “Finally Working” post. I am posting it here because I didn't know where else to put it. A thanks to Ed L. (86rocco) as I used his for the “Pitot Tube Calculations” section. I did change my inputs to Imperial from metric as my weather station reads that way. I also hid a few of his lines, which I used only to “debug” my later calcs. The “Master” worksheet is protected as it is my intention to copy that page and make a new worksheet for each change of configuration or run.

The “Head Geometry” area is to make notes and (later) will be used to interface with other prograns (if possible). Simplicity is my first goal!

The “Flow Calculations” section sets up the manometer and flow element data as both are variable in my bench. The inclined manometer rise being used is input and, for now, a geometry correction is applied. I am making a change to the manometer to eliminate this part. Also input here are specific gravity of the fluid used and the correction for well drop. These same values are also currently being used for the vertical manometer. Additional input for the vertical is the test depression desired. The scale reading for the corrected level is output. I put a small piece of blue tape on the scale for easier “indexing”. The final input in this section is the flow element ID as I have interchangeable sizes. This is the value Ed uses in his “flow in a tube” calcs.

The final sections are the test results, intake and exhaust. Both work the same, but exhaust is a dummy here, just checking that everything works. The Green “Valve Lift” numbers are those you wish to (or did) test to. Lift/Dia is for those who like to test that way, but are calculated, not input. The actual reading along the inclined manometer scale is input and (using Ed’s “flow in a tube” methodology) the rest is calculated. The SLS Corrected Flow value is the one that is used for comparison to other results and plotted. I added a column for comparing a smooth curve fit through the points with the actual (corrected) points.

I would like to take this opportunity to thank all of the forum members who helped me get this far. Without them, I don’t think I would have made it. I also want to thank the members who took the time to look and comment on my various posts along the way. This is a great place! -- Doug

You do not have the required permissions to view the files attached to this post.

Thu Sep 23, 2010 9:41 am

Joined: Tue Sep 21, 2010 8:39 pm
Posts: 4
Perfect. Thanks 1960!

Thu Sep 23, 2010 12:06 pm

Joined: Tue Jan 03, 2012 12:05 am
Posts: 15
Thanks for sharing, small problem.
"Protected cells can not be modified" ?
I get this message whenever I try to change a value in red or green.

What am I doing wrong ?

I'm using Calc, instead of Excell; if it makes a difference.

Thu Jan 05, 2012 10:47 pm

Joined: Tue Jan 03, 2012 12:05 am
Posts: 15
FOUND IT ! :mrgreen:

Open the spreadsheet, very top of the screen,
click on Tools, then Protect Document.

Uncheck Sheet, and it should work.

Fri Jan 06, 2012 4:51 pm
Display posts from previous:  Sort by  
Reply to topic   [ 5 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software for PTF