TheBackShed.com

Forum Index : Microcontroller and PC projects : CMM2: MaxiCalc - Spreadsheets!

Author

Message

vegipete

Guru

Joined: 29/01/2013
Location: Canada
Posts: 1122

Posted: 01:03am 05 Jan 2021

Copy link to clipboard

Print this post

My oscillator mod a while back made the 1024 x 768 video mode so beautiful and stable that I had to think up something to use the vast screen space.

And the result is ....

Yes, a rudimentary working spreadsheet program!

Why? Well, why not? Bricklin and Frankston wrote the original in 6502 assembly language over the course of a couple of months. I wanted to see what I could quickly do in MMBasic. The result is remarkably usable, which is a testament to the STM32H7 chip and fine programming of Geoff and Peter.

Like Visicalc from 40 odd years ago, now your CMM2 too can enjoy a 63 column wide and 255 row high field of calculations. Built-in MMBasic functions should work in your equations.

Press F1 for the help page.

Error checking is indubitably less robust that it should be but oh well.

Missing at this point is file saving and loading.

Have fun!
MaxiCalc-v06.zip

Visit Vegipete's *Mite Library for cool programs.

LeoNicolas

Guru

Joined: 07/10/2020
Location: Canada
Posts: 500

Posted: 02:44am 05 Jan 2021

Copy link to clipboard

Print this post

Amazing Vegipete.

Are you having time to sleep?

TassyJim

Guru

Joined: 07/08/2011
Location: Australia
Posts: 6229

Posted: 06:45am 05 Jan 2021

Copy link to clipboard

Print this post

Impressive.

I made one change to line 1034

k$ = ucase$(inkey$)

I don't think the UCASE$() has done any damage and saves me remembering to use shift.

Now you 'just' have to add mouse support.

Jim

VK7JH
MMedit

JohnD
Newbie

Joined: 23/08/2020
Location: New Zealand
Posts: 6

Posted: 01:26am 27 Mar 2021

Copy link to clipboard

Print this post

Very interesting. Is it possible for the cells to read/write the state of digital I/O and is it possible to read an analogue input?

I'm just starting to program the CMM2.

In the days of Microbees I wrote a basic program that was a process control simulator that required the correct P, I and D values to be applied to control a choice of processes with different characteristics.

I'd like to have a layout similar to your spreadsheet to enter/edit the process and controller parameters. I was wondering how to do this using cursor control.

John

vegipete

Guru

Joined: 29/01/2013
Location: Canada
Posts: 1122

Posted: 02:17am 27 Mar 2021

Copy link to clipboard

Print this post

JohnD said Very interesting. Is it possible for the cells to read/write the state of digital I/O and is it possible to read an analogue input?

Interesting thought. There is a good chance that that already works. Might need to set pin directions first in the program itself at the very start during initialization.

Visit Vegipete's *Mite Library for cool programs.

JohnD
Newbie

Joined: 23/08/2020
Location: New Zealand
Posts: 6

Posted: 02:40am 27 Mar 2021

Copy link to clipboard

Print this post

Thanks for that I'll give it a go. I'll have to check out that I can set or read the pins first.

vegipete

Guru

Joined: 29/01/2013
Location: Canada
Posts: 1122

Posted: 04:45am 27 Mar 2021

Copy link to clipboard

Print this post

I doubt outputs will work, but inputs should.

Visit Vegipete's *Mite Library for cool programs.

RetroJoe

Senior Member

Joined: 06/08/2020
Location: Canada
Posts: 290

Posted: 05:44pm 27 Mar 2021

Copy link to clipboard

Print this post

Vegipete, I couldn't help but notice that MaxiCalc hasn't made it onto CMM2 Fun. You would have the "Business" category all to yourself :)

Enjoy Every Sandwich / Joe P.

jirsoft

Guru

Joined: 18/09/2020
Location: Czech Republic
Posts: 533

Posted: 09:53pm 27 Mar 2021

Copy link to clipboard

Print this post

I put it there now...

Jiri
Napoleon Commander and SimplEd for CMM2 (GitHub), CMM2.fun

Print this page

To reply to this topic, you need to log in.