Spreadsheet App for DM42

Discussion around the SwissMicros DM42 calculator
Thomas Okken
Posts: 1100
Joined: Tue May 02, 2017 5:48 pm
Location: Netherlands
Contact:

Re: Spreadsheet App for DM42

Post 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.
User avatar
PierreMengisen
Posts: 305
Joined: Wed Nov 29, 2017 1:38 pm
Location: Neuchâtel CH

Re: Spreadsheet App for DM42

Post by PierreMengisen »

Pierre
[TI59 with PC100C; TI-84 Plus CE-T; HP41CV with HP IL loop & 2*82161A DCD & 82162 TP; HP15C; HP28S; DM41; DM41L; DM42; DM41X]
Dave Britten
Posts: 137
Joined: Wed Jun 14, 2017 9:27 pm

Re: Spreadsheet App for DM42

Post 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).
diamondsoftware
Posts: 5
Joined: Sat Jan 26, 2019 11:20 am
Location: BELGIUM
Contact:

Re: Spreadsheet App for DM42

Post 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.
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: Sat Aug 25, 2018 12:19 am

Re: Spreadsheet App for DM42

Post 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.
Thomas Okken
Posts: 1100
Joined: Tue May 02, 2017 5:48 pm
Location: Netherlands
Contact:

Re: Spreadsheet App for DM42

Post by Thomas Okken »

The original VisiCalc was less than 30k :mrgreen:
User avatar
pcscote
Posts: 169
Joined: Tue May 02, 2017 12:12 pm
Location: Québec/Canada

Re: Spreadsheet App for DM42

Post 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.
[DM1x/DM1xL/DM41/DM41L/DM41X/DM42]
Jim_W
Posts: 33
Joined: Fri Mar 15, 2019 3:36 am

Re: Spreadsheet App for DM42

Post 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
eulerfan
Posts: 20
Joined: Sat Aug 25, 2018 12:19 am

Re: Spreadsheet App for DM42

Post 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.
eulerfan
Posts: 20
Joined: Sat Aug 25, 2018 12:19 am

Re: Spreadsheet App for DM42

Post 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.
Post Reply