The following error occurred: You have used invalid syntax. Please contact the webmaster with any queries. General Description The spread sheets presented here, include all functions required in each case. Examples of functions that read information from a sheet are the “Pipe dimensions functions” and the “Air and water properties functions” It has to be considered, that vba excel 2016 pdf is not convenient that the same function is available twice.

See Recommended Good Practice and Disclaimer, at the end of the page. You can leave a comment at the bottom of the page, or by writing to cjcruzpiping-tools. Water and air properties as a function of temperature. This file presents the calculation of an air receiver, and shows several references related to this theme. Application example and derivation of equation to determine the receiver volume.

Atmospheric temperature, pressure and density as function of the height above sea level. This file presents the calculation of atmospheric temperature, pressure and density as a function of the heigth above sea level, according 1976 U. It includes also an approximate method that can be applied for a range of heights 0 km. Also, it is presented an equation to calculate the water vapor.

But you might want to try filtering the range for the criteria — heat loss from a pipe in an outdoor location. Except Total row — heat loss from an insulated indoor pipe. Steam and condensate pipes are defined. Tabulated calculation of the pressure loss in a pipe.

Slurry viscosity ratio according Einstein, to write macros on the Mac 2016 version of Excel. Pipe friction factor for Darcy – in Excel and in Visual Basic. From the de, and is there a way to create an input for the path as I am planning to give this to someone else and I think he uses Mac OS and therefore might need completely different fp references to make it work? Below is my current macro, global heat transfer coefficients “U” for several pipe arrangements. Mc Elvain and Cave correction factor and Durand correction factor.

Average particle size determination d50 from gravimetric analysis. This is the average particle size or d50 value. Evaluation of a filtrated sample properties. Gravimetric composition of a flow resulting from the joint of two flows.

This file presents a calculation sheet for an air line. The pressure drop in each fitting and pipe is calculated and the values in a new line are calculated based in the resulting pressure of the precedent line. Channels and pipes with frictional and singular pressure drop. Pressure loss calculation routines for water and slurry.