 Notice. New forum software under development. It's going to miss a few functions and look a bit ugly for a while, but I'm working on it full time now as the old forum was too unstable. Couple days, all good. If you notice any issues, please contact me. |
Forum Index : Microcontroller and PC projects : CMM2: MaxiCalc - Spreadsheets!
| Author | Message | ||||
vegipete Guru  Joined: 29/01/2013 Location: CanadaPosts: 1082 |
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: CanadaPosts: 445 |
Amazing Vegipete.  Are you having time to sleep?  |
||||
TassyJim Guru Joined: 07/08/2011 Location: AustraliaPosts: 5907 |
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 MMBasic Help |
||||
| JohnD Newbie  Joined: 23/08/2020 Location: New ZealandPosts: 6 |
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: CanadaPosts: 1082 |
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 ZealandPosts: 6 |
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: CanadaPosts: 1082 |
I doubt outputs will work, but inputs should. Visit Vegipete's *Mite Library for cool programs. |
||||
RetroJoe Senior Member  Joined: 06/08/2020 Location: CanadaPosts: 290 |
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 RepublicPosts: 532 |
I put it there now... Jiri Napoleon Commander and SimplEd for CMM2 (GitHub), CMM2.fun |
||||
 Print this page |
