Page 2 of 5

Re: Spreadsheet App for DM42

Posted: Tue Mar 26, 2019 10:04 am
by Thomas Okken
Wouldn't it make more sense to tie a spreadsheet to a matrix variable? Real matrices can hold six-character strings as well as numbers, so it sounds like that would do what you're looking for. It would basically be a fancier version of the Matrix Editor, showing multiple cells at once, instead of only one at a time.

Re: Spreadsheet App for DM42

Posted: Tue Mar 26, 2019 1:57 pm
by PierreMengisen

Re: Spreadsheet App for DM42

Posted: Tue Mar 26, 2019 2:35 pm
by Dave Britten
Jim_W wrote:
Tue Mar 26, 2019 5:19 am
Yes, Dave, I have quite a few spreadsheets loaded in my Casio fx-CG50. The spreadsheet app is not a full blown spreadsheet program. It lacks some functions that I use (like VLOOKUP), but on the whole, it is very useful. It does exactly what I first wrote about. That is, in column 1 I can list all of my input variables, in column 2 - the input variables values, in column 3 the output variables, and in column 4 the output variables values. The Casio spreadsheet handles the scientific functions very well. It even handles both degrees and radians regardless of what mode the calculator is in.
Yeah, it's very basic, but it at least has enough functionality to be useful for simple things. It's perfect for doing short probability distribution charts, or multiple TVM cases for loan comparisons.

If you want the king of handheld spreadsheets, get one of the palmtops (95LX, 100LX, or 200LX). Lotus 1-2-3 beats the pants off of anything I've tried for Windows CE, Palm OS, Psion, and even my iPhone and iPad (and it's certainly not for lack of trying to find something better).

Re: Spreadsheet App for DM42

Posted: Wed Mar 27, 2019 6:45 pm
by diamondsoftware
Hi from Belgium,

A real spreadsheet will be a very complementary way of programming the DM42, Formula in RPN or not
In this we could have the good things of both word : RPN programming and spreadsheet way of programming/presenting informations.
It could be an extension of the HP42 actual emulator with new Spreadsheet functions , and each cells saved in registers or other special registers but accessible to the RPN Language,etc...
I continue to think that there is a great potential in this idea, to improve the DM42. I think the hardware is enough powerful for that.
Stephane D.

Re: Spreadsheet App for DM42

Posted: Thu Apr 04, 2019 8:24 pm
by eulerfan
A spreadsheet is a major application. I seem to recall that only about 100k of the 1 MB internal flash memory is free; that may not be enough program space for a decent spreadsheet.

Re: Spreadsheet App for DM42

Posted: Thu Apr 04, 2019 9:13 pm
by Thomas Okken
The original VisiCalc was less than 30k :mrgreen:

Re: Spreadsheet App for DM42

Posted: Fri Apr 05, 2019 1:06 am
by pcscote
Thomas Okken wrote:
Thu Apr 04, 2019 9:13 pm
The original VisiCalc was less than 30k :mrgreen:
I agree, but completely written in assembly.

Re: Spreadsheet App for DM42

Posted: Fri Apr 05, 2019 2:40 am
by Jim_W
Hi all - My post on 18 Mar 19 was not very clear. Let me try again using ...........
……………..…..INPUT DATA………………………|….…………… OUTPUT DATA……..……
Departure Airport LAT………… 41-33.14….|……Magnetic Heading (deg).…. 276
Departure Airport LONG…... 112-03.73..|…..Distance (nm)…………………...122
Destination Airport LAT………..42-28.91..|....Ground Speed (kts)…….….….118
Destination Airport LONG…..114-29.27….|…..Leg Time (h.m).…….………..1.02
Magnetic Variation (deg).……………..-13….|……Leg Fuel (gal) ………….………..9.8
Wind Direction (deg)…………………….180….|
Wind Velocity (kts)…………..…….…....20….|
True Air Speed (kts).…………….……..110….|
Fuel Burn Rate (gal/hr)……….….…….9.5….|

I hope that this will help. If it does, you can see that all I am asking for is a display on which I can input and output data (like on a spreadsheet). Gee, I did not know that the free memory on the DM42 is only 100K. I guess that would not allow for a usable spreadsheet. However, I would be happy with just a display page with four columns that could be used to enter and read data from my RPN programs. That wouldn't take very much memory, would it? - Jim

Re: Spreadsheet App for DM42

Posted: Fri Apr 05, 2019 10:47 pm
by eulerfan
Thomas Okken wrote:
Thu Apr 04, 2019 9:13 pm
The original VisiCalc was less than 30k :mrgreen:
People expect more from a spreadsheet these days. Somebody mentioned Lotus 1-2-3. I forget how big it was, but I'm pretty sure it was larger than 30 kb.

A textmode spreadsheet might be possible in 100k, if we use Forth. It'll still be a tight fit though.

Re: Spreadsheet App for DM42

Posted: Fri Apr 05, 2019 11:23 pm
by eulerfan
Jim_W wrote:
Fri Apr 05, 2019 2:40 am
Hi all - My post on 18 Mar 19 was not very clear. Let me try again using ...........
……………..…..INPUT DATA………………………|….…………… OUTPUT DATA……..……
Departure Airport LAT………… 41-33.14….|……Magnetic Heading (deg).…. 276
Departure Airport LONG…... 112-03.73..|…..Distance (nm)…………………...122
Destination Airport LAT………..42-28.91..|....Ground Speed (kts)…….….….118
Destination Airport LONG…..114-29.27….|…..Leg Time (h.m).…….………..1.02
Magnetic Variation (deg).……………..-13….|……Leg Fuel (gal) ………….………..9.8
Wind Direction (deg)…………………….180….|
Wind Velocity (kts)…………..…….…....20….|
True Air Speed (kts).…………….……..110….|
Fuel Burn Rate (gal/hr)……….….…….9.5….|

I hope that this will help. If it does, you can see that all I am asking for is a display on which I can input and output data (like on a spreadsheet). Gee, I did not know that the free memory on the DM42 is only 100K. I guess that would not allow for a usable spreadsheet. However, I would be happy with just a display page with four columns that could be used to enter and read data from my RPN programs. That wouldn't take very much memory, would it? - Jim
Maybe an extension to VARMENU would be good enough, or maybe you need a more general forms facility. I need to think about this.