Does anyone know of a good way to pass temperatures into an Excel component? The method of "stripping" the units by dividing by the units doesn't seem to work with temperatures. The workarounds I can think of are not very elegant. Thanks!
1 ACCEPTED SOLUTION
Accepted Solutions
You need to use the inverse unit:
Although the inverse unit exists in Prime, I don't know how to create it. I cannot find it anywhere. I created the one in the attached file by converting a Mathcad 15 worksheet.
Hey, thanks Richard. I did the copy and paste and it worked:
And the units of T1 are preserved for use later in the sheet.
Thanks Valery Ochkov and Richard Jackson for your help with this issue! It is appreciated.
> But, to make this work, I would have to be using a sheet that was converted from Mathcad 15, correct?
Not necessarily! Only if you insist on postfix notation.
"°F" and also "/°F" are not units (even if they look like units) but they are functions. That was the reason dividing T by °F failed.
But the function is displayed in so called postfix notation (instead of "f(x)" we see "x f"). There seems to be no way to enter that kind of notation in Prime like we were used from Mathcad 15 and below. So the only way to be able to see "T /°F = 100" is to edit a region from an converted worksheet.
But the function "/°F" is there and can be used in normal function notation and you can do that in any sheet - you don't need a converted worksheet for this to work:
The problem is how to enter "/°F" because as soon as you enter "/" you get a fraction. The trick to use "forbidden" characters in a variable or function name is to begin with double quotes and enter the name with all its odd characters
When the cursor is after the last character you press "del" to delete the double quotes
and you have just created a name with special characters in it and can continue by typing "( T ) ="
That way you could use this function in your sheet like
But if you don't want to go through the hassle of having to type that function name, create a function on your own either using the built-in on
or writing it from scratch
and then use it in your sheet the normal way like
Regards Werner
Errata:
After the text "or writing it from scratch" I had inserted the wrong picture. It should have been this one:
Additional general remarks:
Postfix notation seems the only of the for special notations which is available in Prime, too, at the moment.
According to the annotation the converter itself seems to be not aware of that that, even though it creates a correct expression in postfix notation.
Mathcad 15:
Converted sheet (Prime 3):
So using a converted sheet and editing the converted expressions we can use at least postfix notation in Prime sheets:
If anybody finds a way to enter postfix notation in a Prime sheet without having to resort to a converted region and without tampering with the xml-code of the sheet, this sure would be an interesting information to share with us.
Regards, Werner
If anybody finds a way to enter postfix notation in a Prime sheet without having to resort to a converted region and without tampering with the xml-code of the sheet, this sure would be an interesting information to share with us.
That's the easy bit. Use the scaling operator:
The pop up help is kind of useless. The actual help says:"Scales x by y. If y is a function, it is applied to x. Otherwise, x and y are multiplied".
What I couldn't figure out is how to type the inverse temperature function.
> Use the scaling operator:
Wasn't aware of that operator. Strange that it is called "scaling" operator. If I want to scale I'd rather use a normal multiplication. But it can be used with success to replace the postfix notation. Thanks for pointing that out.
The help info seems to be wrong as x obviously can't be a function (at best it could be a function result)
> What I couldn't figure out is how to type the inverse temperature function.
So combined we can now insert a working /°F in a Prime sheet without using a converted sheet.
Werner
So combined we can now insert a working /°F in a Prime sheet without using a converted sheet.
Only if you know the undocumented function exists, and also know some undocumented tricks to create a function name with special characters. The problem with undocumented features is that, as we have learned in the past, they can be taken away 
True.
Unfortunately we also learned in the past (and still learn in the present) that software development not always is going in forward direction and that subsequent versions of a piece of software may lose a significant amount of features - documented or not.
Richard Jackson написал(а):
You need to use the inverse unit:
I don't know how to create it. I cannot find it anywhere. I created the one in the attached file by converting a Mathcad 15 worksheet.
Prefix, infix and tree operators in Mathcad 15 and Prime:
