Skip to main content
24-Ruby IV
August 17, 2014
Solved

Two Why: Units in Mathcad and Excel

  • August 17, 2014
  • 1 reply
  • 9887 views

MathcadExcelUnits.png

PS

Is there a short name ofthe base US pressure units?

Best answer by FredLusk

Valery…

The base temperature unit in the US system *is* Rankine. Mathcad gets it wrong.

However, I and Mathcad are both unit-bilingual, so this Mathcad error is mearly an annoyance. BTW, I was just looking at the definition of the ICAO Standard Atmosphere (for something totally unrelated to this conversation and even my own work) and found that the standard lapse rate used to calculate temperatues in the lower atmosphere is officially defined as "-1.98°C per 1000 feet." Yep, mixed unit systems…at least according to the three semingly knowledgeable websites I checked.

In the US, the federal government requires the use of SI units for its projects…at least, they're supposed to. Most, if not all, state and local agencies still use the US unit system (the California Department of Transporation tried SI for a while, but gave up).

As a civil engineer, I have designed and/or managed the design of site and infrastructure improvements for three federal prisons and three other federal projects. In all six cases, the use of SI units was a problem for some members of the design team and for most members of the construction and construction management teams. I once even had a drafter ask me how to draw a 3:1 slope in metric (that's 3 horizontal to 1 vertical). I did it for him…fortunately he was fired soon after.

The worst situation was a couple of buildings at a local naval air station. I won't go into all the details, but at the project kick-off meeting, the architect complained about having to use SI units. The Navy's project manager said he and his staff didn't like SI units either so he made a command decision to design the project using US units. I piped up and said that the topographic survey the Navy had provided us was in SI units and I was not going to accept the liability of converting the data to SI (it would have been a fairly simple procedure, but it was not my responsibility). The Navy's PM said he didn't have the money for a new survey (maybe $7,000 out of a budget of $20,000,000 ) and the previous surveyor was no longer under contract. So, in the best tradition of King Solomon, the Navy's PM decreed that the site work would be designed using SI units and the buildings using US units. I told the Navy's PM and the rest of the design team that this was a VERY bad idea, but that my project engineer and I were fully able to make it work. And we did.

Fred

1 reply

14-Alexandrite
August 20, 2014

Valery…

R (Rankine) is in Mathcad 15.

The pressure unit I use most often is psi (pounds-force per square inch). I am a civil engineer and psi is the unit I use in water system modeling and design and for other hydraulic applications. When applicable, it is sometimes expressed as psia (psi absolute) and psig (psi gauge). Zero on the psig scale is one atmosphere.

Here are some common pressure units used in the US which are also built into Mathcad Prime 3.0. I didn't check Mathcad 15.

atm = atmosphere. 1 atm = 14.7 psi (±). Thus x psig + 1 atm = (x + 14.7) psia.

in_Hg = inches of mercury. This unit is commonly used in mechanical engineering applications. I have run across this unit when designing natural gas distribution systems, but I always convert to psi.

ksf = kips per square foot. 1 kip = 1000 lbf (kip stands for kilo-pounds-force). This unit is commonly used in geotechnical engineering and foundation engineering.

ksi = kips per square inch. This unit is commonly used in structural engeering for material stresses.

psf = pounds-force per square foot. This unit is commonly used in geotechnical engineering and foundation engineering.

psi = pounds-force per square inch. 1 psi = 6.9 kPa (±)

One common unit missing from Mathcad Prime 3.0 is in_water. It is similar to in_Hg, but is based on the density of water instead of mercury. This unit is also used by mechanical engineers. Two other less common units are ton per square inch and ton per square foot where 1 ton = 2000 lbf. I have never used these last two.

I hope this helps.

Fred

24-Ruby IV
August 20, 2014

Thanks, Fred!

But the questions were:

Why we have not R with temperature when we have US Units system...

23-Emerald I
August 20, 2014

Because PTC/Mathcad is still hoping that the USA will convert to metric?