Spreadsheet App for DM42

Discussion around the Swiss Micros DM42 calculator.
Thomas Okken
Posts: 589
Joined: Tue May 02, 2017 3:48 pm
Location: New Jersey, USA
Contact:

Re: Spreadsheet App for DM42

Post by Thomas Okken » Tue Mar 26, 2019 9:04 am

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.

User avatar
PierreMengisen
Posts: 13
Joined: Wed Nov 29, 2017 12:38 pm
Location: Neuchâtel CH

Re: Spreadsheet App for DM42

Post by PierreMengisen » Tue Mar 26, 2019 12:57 pm

Pierre
[TI59; HP41CV; HP15C; HP28S; DM41; DM41L; DM42]

Dave Britten
Posts: 64
Joined: Wed Jun 14, 2017 7:27 pm

Re: Spreadsheet App for DM42

Post by Dave Britten » Tue Mar 26, 2019 1:35 pm

Jim_W wrote:
Tue Mar 26, 2019 4: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).

diamondsoftware
Posts: 3
Joined: Sat Jan 26, 2019 10:20 am
Location: BELGIUM
Contact:

Re: Spreadsheet App for DM42

Post by diamondsoftware » Wed Mar 27, 2019 5:45 pm

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.
Stephane Dujourdy
Softwares made on measure and computing advice since 1980
Softwares made on measure for Diamond sector since 1999
www.diamondsoftware.net

eulerfan
Posts: 20
Joined: Fri Aug 24, 2018 10:19 pm

Re: Spreadsheet App for DM42

Post by eulerfan » Thu Apr 04, 2019 6:24 pm

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.

Thomas Okken
Posts: 589
Joined: Tue May 02, 2017 3:48 pm
Location: New Jersey, USA
Contact:

Re: Spreadsheet App for DM42

Post by Thomas Okken » Thu Apr 04, 2019 7:13 pm

The original VisiCalc was less than 30k :mrgreen:

User avatar
pcscote
Posts: 43
Joined: Tue May 02, 2017 10:12 am
Location: Near Montreal, Québec, Canada

Re: Spreadsheet App for DM42

Post by pcscote » Thu Apr 04, 2019 11:06 pm

Thomas Okken wrote:
Thu Apr 04, 2019 7:13 pm
The original VisiCalc was less than 30k :mrgreen:
I agree, but completely written in assembly.
[DM1x/DM1xL/DM41/DM41L/DM42]

Jim_W
Posts: 14
Joined: Fri Mar 15, 2019 2:36 am

Re: Spreadsheet App for DM42

Post by Jim_W » Fri Apr 05, 2019 12: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

eulerfan
Posts: 20
Joined: Fri Aug 24, 2018 10:19 pm

Re: Spreadsheet App for DM42

Post by eulerfan » Fri Apr 05, 2019 8:47 pm

Thomas Okken wrote:
Thu Apr 04, 2019 7: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.

eulerfan
Posts: 20
Joined: Fri Aug 24, 2018 10:19 pm

Re: Spreadsheet App for DM42

Post by eulerfan » Fri Apr 05, 2019 9:23 pm

Jim_W wrote:
Fri Apr 05, 2019 12: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.

Post Reply