Creating a unit conversion app

[Roger Ward]

So, I have my HP Prime, and I'm enjoying playing with the apps and marvelling at the graphing speed, but not marvelling at converting units! I can't even get CONVERT() to work in RPN mode...

So, a question - is it possible to create an app or program which would recreate the 48g-50g version of the units mode with soft keys etc?
I could switch into this mode when doing conversions as I do with my 48g.

I work in the heritage building sector so I'm converting between imperial and metric daily.

Any guidance appreciated, I may have to learn to program!

[toperos]

You can create your own spreadsheet, with the units you need to convert, and then save it. The Spreadsheet app is very easy to use and you don't need any programming knowledge.

[Roger Ward]

Good idea - I have now done that - easy to use as you say.

Thanks!

[ndzied1]

This looked like a great idea but whenever I try to enter a formula into the spreadsheet I get a syntax error. ARGHHHH

[Roger Ward]

I found that you need to:
a) put the formula inside single quotes - SHIFT ()
b) leave out the "=" symbol

[ndzied1]

(11-13-2014 01:53 PM)ndzied1 Wrote:  This looked like a great idea but whenever I try to enter a formula into the spreadsheet I get a syntax error. ARGHHHH

Thanks! I thought I was going batty.

[CR Haeger]

Here is a simple unit conversion in a spreadsheet. Seems to work in Textbook, Alg or RPN. Didnt need to fuss with any quotation marks...

Cell Contents
C2: 10
C3: 10_ft

D2: =CONVERT(C2_ft,1_m)
D3: =CONVERT(D2,1_m)

The green and yellow highlighting are via Format 5-Fill

   

[Roger Ward]

Even better, thanks CR.
Entering formulae with RPN set is still awkward though, requires more brackets and single quotes to accomplish.
BUt once set up easy to use a "Units" spreadsheet app..