Evan, Very exciting, date manipulation is timely for me, rather than wait I will look into some existing options. *Is there value sharing what I find, or do you have it covered?*
On multidimensional, I am not so much looking for array manipulation. Tiddlywiki and your solution already meets my requirements. Imagin a large 2d spreadsheet with 3 columns containing unique keys (or missing keys) even including date/time. If you choose a key and sort on it before you manipulate a 2D array you are effectively looking at the data in another dimension. This is very easy for TiddlyWiki. *May I ask how you use the results TRUE and FALSE in wikitest once calculated?* Do you use it in filters etc? Regards Tony On Sunday, 17 December 2017 03:20:17 UTC+11, Evan Balster wrote: > > Question: do you have or are you planning any rounding or averaging >> functions? > > > There are rounding functions in there now. See "Functions" and > "FormulaWidget" in the doc wiki. No averaging yet, but that's a popular > function I'll replicate at some point soon. (My last round of functions > was ). > > I did find that the rounding functions fail when a second parameter is >> provided, so I submitted an issue on Github. > > > Ah, I'll fix those then. Good catch. > > > I am very interested in "Multidimensional" arrays. > > > From what I can tell Excel and Sheets can do 1D and 2D arrays, and these > may be internally represented as selection sets. Anyway, there's a lot of > flexibility in what "value" types could be added (especially with > extensions) but I'll probably imitate spreadsheet conventions and functions > to begin with. > > > One question: Could this be made to work with date and time? > > > Yes, I'll be adding support for a date/time datatype. There's a long > history of date/time functionality in Excel/Sheets and there are some > standard TiddlyWiki/javascript functions that can be built upon. > > > Reverse polish notation https://tid.li/tw5/hacks.html > > > Useful reference. Before I was driven to implement this plugin I > experimented various macro-based solutions (including some homemade ones). > I even have an accounting wiki built around a sum macro. It was my > conclusion that the $set/$vars/$macrocall boilerplate makes recursive JS > macros a bit too unwieldy compared to a dedicated formula syntax. A widget > also has more potential for caching/optimization/efficiency in the long > term. > > > > On Saturday, 16 December 2017 04:29:18 UTC-6, [email protected] wrote: >> >> This looks very good, especially since it is incredibly easy to set up >> and use! One question: Could this be made to work with date and time? >> >> Cheers, >> >> Stef >> >> On Friday, December 15, 2017 at 5:37:26 AM UTC+1, Evan Balster wrote: >>> >>> >>> Introducing the *Formula plugin*: >>> http://evanbalster.com/tiddlywiki/formulas.html (version 0.1.0 at time >>> of posting) >>> >>> >>> -- 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 [email protected]. To post to this group, send email to [email protected]. 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/fc274668-af83-44e3-a1da-9678c0885417%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
