My TiddlyWiki Math Project

[Stephen Kimmel]

My TiddlyWiki math project, which I'm calling Mathcell, has progressed far enough to actually be of some use to people. So I'm unleashing it on the unsuspecting public in hopes of getting some feedback and comments.

A bit of background. About the only software I use more than TiddlyWiki is Microsoft Excel. Inspired by a programming effort that created a Tiny Excel-like app in plain vanilla javascript with no libraries and just 30 lines of code, http://jsfiddle.net/ondras/hYfN3/, I set to work creating my own version. I succeeded and Mathcell (math in a cell) is the result. The essential tiddlers are about 3,000 bytes in total and there are three examples and two datatiddlers that total about another 5,000 bytes.

In essence, you can enter a macrocall, <$macrocall $name="eval1" datatiddler="$:/sk/data" cell="a1"/> in any tiddler and create a Mathcell. In that Mathcell, you can enter formulas or javascript math functions and using a button toggle back and forth between the data entry form and the result. The routine can handle complex math operations, string concatenation and has circular reference protection.

This routine is no match for Excel or even some of the much bigger add-in spreadsheets, but if you need some very flexible mathematics in your wiki, this may suit your needs.

You'll find Mathcell at http://mathcell.tiddlyspot.com/

[Mat]

That's VERY cool!!! Great job Stephen!

<:-)

[Alex Hough]

I especially like the inline example

Could this be used to create data visualisations?

Alex

On Wednesday, 23 March 2016, Mat <matia...@gmail.com> wrote:

That's VERY cool!!! Great job Stephen!

<:-)

--
You received this message because you are subscribed to the Google Groups "TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+...@googlegroups.com.
To post to this group, send email to tiddl...@googlegroups.com.
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/5c0066d0-0ee9-4869-a9c0-f9390438c898%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ste Wilson]

Excellent stuff.  I'm currently slogging through making an engineering wiki/ text book for my level 3 students and this could be very handy for exercise questions/ examples.

stephenteacher.tiddlyspot.com

[Ste Wilson]

On Wednesday, 23 March 2016 03:22:51 UTC, Stephen Kimmel wrote:

Hi Stephen,
Finally got around to trying something with your Mathcell.
I think I have everything set up but it doesn't seem to evaluate any formula.
I'm sure it's a school boy error on my part...

http://stephenteacher.tiddlyspot.com/#Math%20Force
is the tiddler I am using to present the data and as you can see it returns values but doesn't do the calc.

http://stephenteacher.tiddlyspot.com/#Math%20Force%20Data
Is the data tiddler.

Any insight much appreciated.

Stephen W

[Mark S.]

Hi Stephen W,

Looking over Stephen's (K) code, it looks like you have to use a data tiddler in all lower case. All references to the data tiddler should also be in lower case.

HTH
Mark

On Friday, July 15, 2016 at 12:57:18 PM UTC-7, Ste Wilson wrote:

On Wednesday, 23 March 2016 03:22:51 UTC, Stephen Kimmel  wrote:
> My TiddlyWiki math project, which I'm calling Mathcell, has progressed far enough to actually be of some use to people. So I'm unleashing it on the unsuspecting public in hopes of getting some feedback and comments.
> 

Hi Stephen,

Finally got around to trying something with your Mathcell.
I think I have everything set up but it doesn't seem to evaluate any formula.
I'm sure it's a school boy error on my part...

[Ste Wilson]

That's got it, thank you.
Now my only problem is how to integrate this without making it ridiculously easy for my students....

[reakt...@gmail.com]

This is outstanding! I've been looking for something like this for quite some time, thank you so very much!

Only thing left for me to do is find a way to sort the tables in ascending or descending order by clicking column headers. I haven't had much success with that yet.

[Josiah]

Table sorting is already done for TW. I just can't recall who did it or where the plugin is.

"Sorttable" is a classic Javascript. I mean its phenomenal & been around a long, long time & honed many times.

Someone recently in TW5 impressively replicated well many of its features and without its overhead.

Let's hope they reply here so you can benefit from it.

Best wishes
Josiah

[Jed Carty]

I made suitable tables using only wikitext but I am not sure if it can be adapted to this situation. The demo site for what I made is here if you want to look http://ooktech.com/jed/ExampleWikis/DynamicTables/

[reakt...@gmail.com]

It appears that only sorting in ascending order works, is it possible to also allow sorting in descending? Also, one of the features I think I like best about the Dynamic Tables is the inline editing, is there a way to enable this in just a wikitext static table?

[Ste Wilson]

IF OR AND & ELSE

One of the things I do use in excel is conditional statements in cells. I've had a go putting this in a field with:

=@if(accel="?") text = "blah"

Which hopefully means that if the field accel =? then return the text blah.
My question then is, is this not working due to my appalling syntax or is it beyond the scope of Mathcell?

My follow up question is can text be inserted depending on the value of a field using a widget or macro?

On Wednesday, 23 March 2016 03:22:51 UTC, Stephen Kimmel wrote:

[Stephen Kimmel]

That was beyond the scope of what I was doing with Mathcell when I wrote it. It's an interesting idea and I'll give it some thought. At this point, the extent Mathcell handles text operations is to add them together or simply reference them.