Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jgreg43

  1. jgreg43

    2 lb. Natural Gas Calculation

    What is the Formedia website so I can checkout the information there. I want to calculate 2 lb. gas pressure losses and be able to choose any gas pressure and have it use the correct constant to use. Thanks Zapster and RGasEng for assistance.
  2. jgreg43

    2 lb. Natural Gas Calculation

    David Thanks for the information, but I believe I am looking for the pressure loss formula. I am looking for either the constants for 6" W.C. up to 5 lb. gas or a constant that will allow some flexiblity (not sure about the last one). I am looking to place the formula into a spreadsheet so it...
  3. jgreg43

    2 lb. Natural Gas Calculation

    I am trying to find a calculation either a spreadsheet or the formula to calculate 2 lb. gas pressure loss for pipe sizes and lengths. I have found two but both are different.
  4. jgreg43

    ANSI A17.1

    Can anyone tell me if I have an existing elevator shaft that we are adding onto the top of, if I will be required to add a sump pit and pump too. The building previously has no sump pump or sump for that matter. The code official here is saying since we are adding onto the existing shaft, that...
  5. jgreg43

    Control box with index

    Here is what I finished up with. =(4.52*D9^1.85)/(P2^1.85*(INDEX($S$4:$W$14,MATCH(E8,$S$4:$S$14,),MATCH(B9,$S$4:$W$4,))^4.87)) and it works. Thanks for the input.
  6. jgreg43

    Control box with index

    Here is my latest improvement on the above formula, but when I change combo box in cell B9 my results do not change with it. I know I need to add it in somewhere into the formula below but not sure where...
  7. jgreg43

    Control box with index

    I have a control box where I will select a type of pipe, then in another cell I have placed the size of pipe i will use. In this last cell where i want to place the results from a friction loss formula by using the control box to find the inside pipe dia. of the pipe type and pipe size I have...
  8. jgreg43

    friction loss formula into excel

    I',m also finding out that it really does not work. I should get a number around .0217 for a 1" CPVC flowing 11 gpm.
  9. jgreg43

    friction loss formula into excel

    Thanks. I picked this formula up out of the fire protection design handbook. If there is an easier way then by all means share. Thanks again.
  10. jgreg43

    friction loss formula into excel

    I am looking to figure pressure loss per foot for sprinkler piping. I have the formula and am trying to figure out how to place it into excel. p= 4.52 Q to the power of 1.85 over C to the power of 1.85 D to the power of 4.87. P = friction loss per foot Q = gpm flowing D = actual inside dia...
  11. jgreg43

    Looking for LPG gas sizing info

    I need to find something which will help guide me in sizing LPG piping and requirements for the piping system. I will be inside the building attic space.
  12. jgreg43

    VLOOUP or LOOKUP?

    It seems that INDEX is automatically rounding up. The formula appears to work for what I need at this time. here is the formula: =INDEX(AP8:AX34,MATCH(A15,AO8:AO34,TRUE),MATCH(A16,AP7:AX7,TRUE)) Thanks for getting me in the right area.
  13. jgreg43

    VLOOUP or LOOKUP?

    I found a formula that has brought me a little closer, but I seem to only get 1 cell and not the next in the list. =INDEX(AP8:AX34,MATCH(A15,AO8:AO34,TRUE),MATCH(A16,AP7:AX7,TRUE)) even if I change TRUE to FALSE it does not go down the line to next number.
  14. jgreg43

    Oxygen friction loss calculation?

    For 100' of pipe or a given length of pipe
  15. jgreg43

    Oxygen friction loss calculation?

    Does anyone have the formula to calculate Oxygen - I want to know the friction loss if given the LPM and the pipe size. I was trying to work with a chart in a spreadsheet and am running into more problems, so I wanted to get the actual friction loss for size of pipe given the LPM.

Part and Inventory Search