[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Thanks for your replies... Time for another learning cliff?!?! -- 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+unsubscr...@googlegroups.com. To post

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Stephen — Yeah, SVG paths are their own mini-language. As BJ says, https://www.w3.org/TR/SVG/paths.html#DAttribute ... The upshot is that the path is defined by a letter followed by numbers (coordinates) with a space between each item. M marks the start of a path and other absolute

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

the d and M are part of the spec: https://www.w3.org/TR/SVG/paths.html#DAttribute On Tuesday, January 16, 2018 at 2:40:06 PM UTC+1, Stephen Wilson wrote: > > I've looked and looked at the the linegraph example... I give up... > > > Sets the limits for the svg... > > > > Draws the box > > >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

I've looked and looked at the the linegraph example... I give up... Sets the limits for the svg... Draws the box This I get, apart from (x&' '&... the rest is just formula and the area it needs to be drawn in. I am wondering why when I just have sin(x) as a function noting plots, is it

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Good catch, Diego. This is actually a symptom of a major value coercion error in formula 0.2, that gives rise to quite a few different goblins. I'll probably put out a version 0.2.1 tomorrow, as I've fixed this bug and added closure support (!!) in the repo. On Monday, 15 January 2018

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, Again - WOW - thanks! Just doing some testing and came across the following: - [tag[Expenses]get[value]] - 2.03 1.49 14.90 - map(function(x):(x*x), [tag[Expenses]get[value]]) - 4.12 2.22 222.01 - map(function(x):(x*x* & ','*), [tag[Expenses]get[value]]) -

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — The JavaScript error is a defect in attribute-modules — that's a core mod with a lot more potential to affect wiki stability, which is why I made some warnings about it. I think if you grab the latest version of the attribute-modules plugin from the formulas wiki, even though the

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Wow... I am truly paddling in the shallow end... -- 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+unsubscr...@googlegroups.com. To post to this group,

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, AWESOME! http://muritest.tiddlyspot.com/#analogue%20clock I just made this with it and now I can't stop thinking of possible things to do with your plugin, this is great great work, thanks again for version 0.2.0! all the best, BurningTreeC -- You received this message because you

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Ohh.. This is quite exciting. I was excited a couple of years ago by latex2html5.com but now with a bit of tinkering it looks like I can do the slider variables thing with your graphs thing! -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Update, I restored my wiki and disabled $:/plugins/ebalster/attribute-modules and $:/plugins/ebalster/condition Now wiki is live with $:/plugins/ebalster/formula v0.2.0 Tony On Monday, 15 January 2018 17:32:42 UTC+11, TonyM wrote: > > Evan, > > I dragged the new version plugin to two

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, I dragged the new version plugin to two different wikis, one saved and reloaded OK. The Other will not reload, nor does safemode work, giving the following error. Internal JavaScript Error Well, this is embarrassing. It is recommended that you restart TiddlyWiki by refreshing your

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Huh, maybe localhost is down. :) https://evanbalster.com/tiddlywiki/formulas.html#Demo%3A%20Line%20Graph Generating SVG paths in TiddlyWiki is something I've been wanting for ages... It was possible in a limited capacity with wikify before, but this makes it a lot more practical. On Sunday,

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan Thanks once again. I will start using ASAP. FYI Link dead (ie no tiddler) http://localhost:8080/#Demo%3A%20Line%20Graph Regards Tony On Monday, 15 January 2018 16:05:05 UTC+11, Evan Balster wrote: > > *Formula 0.2.0 released*: > https://evanbalster.com/tiddlywiki/formulas.html >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

*Formula 0.2.0 released*: https://evanbalster.com/tiddlywiki/formulas.html GitHub and issue tracking: https://github.com/EvanBalster/TiddlyWikiFormula This one's a doozie... Changelog: A substantial re-write of the formulas plugin that introduces various improvements and improves support for

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Ah, the joys of IEEE-754... <$if "anyone wants to see the gory details of fp in javascript (and a slew of other languages all of which are dependent on today's CPUs)"> https://www.h-schmidt.net/FloatConverter/ :) On Saturday, January 13, 2018 at 2:09:28 PM UTC-6, Evan Balster wrote: > >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, all — I get 5.6005 as a result (instead of 5.6). > Right now formula uses the JavaScript style for displaying numbers by default, and it's pretty terrible. The inaccuracy is "floating point" error and any reasonable system would round it off somehow. To get rid of it, refer

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hi Evan, I just ran into a weird problem. When I enter (= sum(1.5,1.2,2,0.9) =) (= 2+1.2+0.9+1.5 =) I get 5.6005 as a result (instead of 5.6). If I change the numbers slightly, I get the correct result. Is this a bug, or is there a well known explanation I'm not aware of? Kind

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, you know what? I solved it reading what I posted :D thanks for this plugin - I think now I kinda get it it's huge have a nice weekend -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

> > The latest version of Formula has some implementation errors in the > modulo, trim and subtitute functions. These have been found and patched, > but the change isn't yet released, as I'm working on some major > enhancements for release today or tomorrow. > thanks Evan, I've only seen

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hello, Simon — The latest version of Formula has some implementation errors in the modulo, trim and subtitute functions. These have been found and patched, but the change isn't yet released, as I'm working on some major enhancements for release today or tomorrow. Added a GitHub issue to

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hi Evan, I'm trying your plugin now and I've seen that the modulo function doesn't work as I expect, maybe I'm doing something wrong or there's a bug all the best, Simon -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Thank you, Evan! This was a perfect and intuitive fit for my invoicing system. /Mike -- 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

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Wow! That looks awesome! hopefully one-day you'll share that as well! Best, Diego On Monday, January 8, 2018 at 1:35:02 PM UTC-6, Evan Balster wrote: > > Hello, Diego — > > You can find a few curiosities hidden in the formulas wiki > if you

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hello all, Just want to ping the community and see if anyone has had any cool uses they wouldn't mind sharing? Diego On Saturday, December 30, 2017 at 7:31:27 PM UTC-6, TonyM wrote: > > Totaly Agree > > Let us state it upfront > > Formula uses wiki text references except in Filters where the

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Totaly Agree Let us state it upfront Formula uses wiki text references except in Filters where the modified form also matches normal TiddlyWiki filter syntax. Regards Tony On Saturday, 30 December 2017 14:56:08 UTC+11, Evan Balster wrote: > > Heheh, well, I'll reply anyway. > > The single vs.

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

On Saturday, December 30, 2017 at 4:56:08 AM UTC+1, Evan Balster wrote: > > I've considered allowing the shorter style anywhere in > formulas, and there isn't much stopping me on a technical level, but I > worry that supporting two styles might create more confusion than it's > worth. >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — The trouble in your case is that you're putting the formulas in quotes, which makes TiddlyWiki treat them as strings. The experimental syntax for attribute values is just ** — no quotes outside the mushroom brackets. Generally I use the formula-vars

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Post Script, Of note is being able to add calculations to elements in TiddlyWiki and HTML which would otherwise be controlled using java script which is not so accessible to a novice in TiddlyWiki. Keep up the good work. Tony On Saturday, 30 December 2017 14:16:00 UTC+11, TonyM wrote: > >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, That works like a dream. Thank you. As you say "tiddlywiki-oriented functions" here are some that come to mind I am trying to identify based on the current implementation if then else or other logical operators to transclude a tiddler, or include content. For example hiding or

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hello, Tony — Assuming you have both the formula plugin *and* the attribute-modules plugin installed, un-quoting your attributes will make them into formulas (instead of literal strings): \define showtodayrange(datefield1,datefield2) \end The attribute-modules plugin is really just a

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, Thanks for another update. FYI: I drag this to my wiki and it is named untitled until I hit the import button, not sure but there may be a plugin setting needing update. Also; I am trying to see if I can get the following to work, basicaly as a version of Formulas as Tag Attributes

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Formula 0.1.7 released: https://evanbalster.com/tiddlywiki/formulas.html GitHub and issue tracking: https://github.com/EvanBalster/TiddlyWikiFormula Changes: - Add math functions styled after GLSL for visual calculations - fract, modulo/mod, atan2, clamp, mix, step, smoothstep -

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, Very small font, and 6 was, not easy to read. Sorry. I am doing the same as you, investing a great deal of time in tiddlywiki for professional reasons and maximising my return to the community, I have a dozen solutions in Progress and Have not published any yet. If it interests you The

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — Pleased to serve! I'm building this with my own needs in mind foremost, but I happened to be in a situation where I could justify putting professional time into the project and make something fairly robust and feature-rich. I get a lot of satisfaction out of putting together a

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, For you At https://evanbalster.com/tiddlywiki/formulas.html the Get your Plugin indicates the plugin is Version 0.1.0 although it is now 0.1.6 >From me Thanks so much for your work here, Looking ahead I can see dozens of features/solutions I wish to build, being supported by "formulas".

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Announcing Formula 0.1.6: https://evanbalster.com/tiddlywiki/formulas.html GitHub & issue tracking: https://github.com/EvanBalster/TiddlyWikiFormula - Enhanced performance. - Add range Operator for counting. - *FormulaWidget results are now wikified by default*. - Made filter

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

On Friday, December 22, 2017 at 11:33:50 AM UTC-6, Evan Balster wrote: > > In the future, Formulas should include some ability to go through arrays > and apply a function to each item inside them, which would form a more > efficient solution than the one here (which will scale up poorly

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Josiah — Sounds like this may be one of the cases where the $button and $action-setfield widgets come in handy, as a way to apply computed values permanently to some tiddlers. It's usually good to write two versions of the code in these situations, where one displays the stuff you're

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Ciao Evan Thankyou. That's gonna work on one Ledger Tiddler at a time? Is there a way to get it seeded from a state Tiddler that gets incremented 1 each time that will always persist? Such that on Tiddler Ledger 2 it picks up numbering from where Tiddler Ledger 1 left off? Hope this is clear!

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Coda, Josiah — You could try something like this: <$formula-vars indexRange=" '1,' & count([myFilter]) "> <$list variable="index" filter="[range< indexRange >]"> <$list filter="[myFilter] +[nth]"> #< = {{!!title}} In the future, Formulas should include some ability to go

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hi Evan -- I have the exact same question... I was hoping to apply the range operator but couldn't figure out the syntax. <$list filter="[tag[x]range-magic-here[]]" variable=tid> I figured maybe I need textjoin outside the filter? But again... can't get my head around the two syntax

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — The reason for ([]=[]) being false is pretty dumb and has to do with me leaving more up to JavaScript than I should (because internal implementation is pretty rough right now). To summarize, [] is not interpreted as an empty list but a filter, and its result is *every tiddler in

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Ah I see - sorry I remember you mentioning that previously I should have gone back to look that up. I'm still not sure why IF([]=[]) comes out false though. Thanks again for all your hard work Diego On Thursday, December 21, 2017 at 7:33:46 PM UTC-6, Evan Balster wrote: > > Hey, Diego — > >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — Currently boolean expressions use JavaScript's concept of "truthyness" which is rather messy and not necessarily ideal. Pending more sensible behavior in formulas, I recommend this: (=

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, Is this expected: - IF([],'yes','no') - yes - IF([]=[],'yes','no') - no - IF([]='[]','yes','no') - no My motivation for testing this: I have several fields that if present, trigger a footer to be displayed preceded by tag. Recently, Ive had tiddlers with two

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — Yes, that kind of logic is a ways off yet and would likely need to be done with a for-loop like construct. For now, you'll need to construct it using the $list widget, like this; Recently modified: <$list filter="[all[tiddlers]]"> (= if(days(tw_date({{!!modified}}), now())<2,

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Thanks for this Evan! I was thinking of being able to use the if statement like this (in semi-pseduo code) IF( gt([all[tiddlers]get[modified]], add_days(date(now()),-5)), <> + "has been recently modified") And that would display all tiddlers who were recently modified. But as I understand

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — Using conditions to: - list / transclude - Both of these are a bit difficult because formula results aren't wikified right now. - You could have a formula result in a filter or tiddler and list or transclude that - <$list filter=<> >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, Im more and more impressed with this plugin, the more I use it. If anyone has some time and has already come up with cool examples, can you share? Also, Im interested in answering each of Tony's points from his earlier question: Evan, > Please forgive my Ignorance; What can a and b

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — I'm aware of the ordinary "de-duplication" behavior. In this case, it was happening even with filter operators that would normally allow duplication, like "get". This was because of a poorly-implemented optimization I'd written to reduce compilation overhead during filter

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, What you considered a Bug is a feature, because Titles are unique in TiddlyWiki so if you have two of the same name appear such as in when Tagged A, or B Or A and B we want the list of titles to be "de-duplicated", Of course when you use filters from non title sources we do not want this

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

*Formulas version 0.1.5*: https://evanbalster.com/tiddlywiki/formulas.html GitHub & issue tracking: https://github.com/EvanBalster/TiddlyWikiFormula - Duplicate values in filters are now handled correctly. On Wednesday, 20 December 2017 20:04:57 UTC-6, Evan Balster wrote: > > *General

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

*General warning*: There is a bug in filter processing that prevents filters in formulas from returning duplicate values. This is likely to cause trouble with formulas like sum([tag[Expense]get[value]]) if two Expenses have the same value. This bug appears to have existed since the first

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, TonyM — Are you formatting a lot of dates using the year/month/day functions? If so, you'll probably have better luck with the text conversion function T() and setting a dateFormat. See the documentation for the FormulaWidget for more information on date format strings (which use the

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, Once again for you great work. I have started playing with the date related functions and finding it a little complex using Make a date from a TiddlyWiki timestamp and return. Is there any way to make this more direct or can you suggest a pattern to follow if all my dates are TiddlyWiki

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

*Formulas version 0.1.4*: https://evanbalster.com/tiddlywiki/formulas.html GitHub & issue tracking: https://github.com/EvanBalster/TiddlyWikiFormula - Add text conversion functions: - t, value, textjoin - Add text utility functions: - len, exact, mid, substitute, split, trim

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Dear Evan Thank you for adding that simple demo. It really helped me better understand how to use the plugin and make steps towards what I need!! Best wishes Josiah Evan Balster wrote: > > Released version 0.1.2: http://evanbalster.com/tiddlywiki/formulas.html > ... > * Added badger

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hmm, it would probably be better if any unit tests were "self-contained" or relied on other data prefixed with UnitTest/data/ or some such. I'll probably write a bundle of them on my next pass and work out a system. On Tuesday, 19 December 2017 15:46:38 UTC-6, Diego Mesa wrote: > > Hey Evan, >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, Were you thinking something like this? Or peraps something more self-contained where the input is defined as a field of this tiddler? Let me know! Diego On Tuesday, December 19, 2017 at 3:00:27 PM UTC-6, Evan Balster wrote: > > Hey, Diego — > > Thanks again for all your hard work.

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

On Tuesday, December 19, 2017 at 10:02:36 PM UTC+1, Evan Balster wrote: > > >> Whoops! That's some JavaScript leaking through. Patched in git, hotfix > attached. > Wow, that was fast! Can confirm that it works (after a reload, if anyone else wants to try). ~Stef -- You received this

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — Thanks again for all your hard work. With a plugin of this complexity, Im > wondering if there should be "unit tests" tiddler that could keep track of > the various corner cases proposed here and that you also identify. > This, times a million. I had already been thinking about

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, Thanks again for all your hard work. With a plugin of this complexity, Im wondering if there should be "unit tests" tiddler that could keep track of the various corner cases proposed here and that you also identify. Also, if/when new functionality is added we can also make sure none

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hi, On Tuesday, December 19, 2017 at 2:32:36 AM UTC+1, Evan Balster wrote: > > Released version 0.1.2: http://evanbalster.com/tiddlywiki/formulas.html > > * Fix an off-by-one-month error parsing transcluded date fields in > -MM-DD format > Thank you! However, the "month" function still

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Diego — Noticed the COUNT error last night and fixed it in repo. Good catch on the IF error. I've also noticed that IFERROR won't behave correctly and I'll be looking into fixing that at some point. For the impatient, I'm attaching patch files that can be imported into a wiki that

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey Evan, In your demo, when I try: - count([tag[Expenses]]) - `ComputeError: ReferenceError: V_Num is not defined operand: [Operand function-call]` - [tag[Expenses]count[]] - [3.00] - This is normal - IF(([tag[Expenses]count[]]=*3*),"yes","no") - `ValueError:

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Time will tell. It's my experience that hasty decisions about syntax can make language design tougher later on, so I'm not inclined to jump the gun on brevity options. One of the tough things about filters, in particular, is that the multi-run syntax should be supported in the future. That

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

> > (= arraystring([tag[Expenses]], "[[", "]] [[", "]]") > A bit cumbersome. Maybe (= array*links*([tag[Expenses]]) =) ...and, btw, given how filters are delimited with outer square brackets, just maybe parentheses could be omitted for filters? (= arraylinks*[*tag[Expenses]*]* =) (=

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Mat — Getting greedy but... possible to make array output be links? I tried this > but no worky: > (= "[[" & nth([tag[Expenses]], 1) & "]]" =) Oh, yeah! This had actually crossed my mind. The default array-to-string conversion isn't very useful except as a display format, because it's

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, what you're doing is just terrific! It is such a big chunk that has been missing for so long. It's like you're coming into the dinner going "...so, guys, I just built these things called *chairs* for us all" ! <:-) -- You received this message because you are subscribed to the Google

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Getting greedy but... possible to make array output be links? I tried this but no worky: (= "[[" & nth([tag[Expenses]], 1) & "]]" =) This is so cl! <:-) -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

(= =) = Ten-Sodas Wohooo! <:-) -- 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+unsubscr...@googlegroups.com. To post to this group, send email

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Got a little absorbed apparently. Here's 0.1.3: http://evanbalster.com/tiddlywiki/formulas.html - Add array functions FIRST, LAST, NTH, COUNT, COUNTA, AVERAGE - Fix the parsing bug with zero-argument functions - Require parentheses for zero-argument functions like NOW(), RAND(),

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Issues targeted for next update: * Make arrays more useful (add NTH, AVERAGE, etc): https://github.com/EvanBalster/TiddlyWikiFormula/issues/11 * Parsing bug with zero-argument functions: https://github.com/EvanBalster/TiddlyWikiFormula/issues/8 On Monday, 18 December 2017 19:32:36 UTC-6,

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Released version 0.1.2: http://evanbalster.com/tiddlywiki/formulas.html * Add months, years, add_months, add_years functions. * The DATE function no longer rejects a date argument. * Fix an off-by-one-month error parsing transcluded date fields in -MM-DD format * Better documentation

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

On Monday, December 18, 2017 at 9:34:25 PM UTC+1, ste...@gmail.com wrote: > > > 2.) I created a group of tiddlers with the same tag. Each tiddler contains > a date in the "datum" field. I was able to pick the latest date from the > list and add 14 days with the following syntax: > Just in case

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Stef — I was running into some of the issues you mentioned when I tried to put together the example for @TiddlyTweeter. 1.) Apparently, a date from a tiddler field is accepted only when it is > formatted as "MMDD" (but not e.g. "-MM-DD"). Maybe you could add > this info to the

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hi, On Monday, December 18, 2017 at 12:14:02 AM UTC+1, Evan Balster wrote: > > > Please continue experimenting and reporting any issues you turn up. I'll > be interested to see if the date & time stuff suits the needs of the users > who've chimed in about that. > Very cool! Thank you! Two

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Josiah, (2) Quite important. Can I in the interface just add a line? That would > make for basic accounting bliss. > I'm pretty sure this is rather easily implemented by many people here so no worry if Evan doesn't personally make this. <:-) -- You received this message because you are

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

I'm interested in this as a spreadsheet like thing to do *basic accounts*. I can't really follow the discussion when I see formulae out of context. Can I ask some simple questions? (1) Can I create a table like this that auto gives the results?... Date Description Cost

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Amazing work, Evan! Thank you! On Monday, 18 December 2017 12:57:38 UTC, Mat wrote: > > Evan, I find it confusing that > > 2+3*4 > 12 works but not "2+3*4 = 12" nor "2+3*4 == 12" . > > And why does (= pow(3, 2) =) work but not (= gr(3, 2) =) ? > > <:-) > -- You received this message because

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, I find it confusing that 2+3*4 > 12 works but not "2+3*4 = 12" nor "2+3*4 == 12" . And why does (= pow(3, 2) =) work but not (= gr(3, 2) =) ? <:-) -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey all — What appears missing that I need at the moment is; Add_month, Add_year Heh, you got me. I haven't written add or difference functions for years or months yet because those entities represent variable quantities of time and the proper approach wasn't quite clear. For the moment you

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, Just to make sure it is intentional - concatenation: 1 & 2 = 1.002.00 (...i.e 1.00 and 2.00) ... is this supposed to be allowed? A user might expect "= 12" but missed the quote marks because he e.g transcluded the numbers. I can see use in concatenating numbers if constructing number

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, I have started using the date functions. What appears missing that I need at the moment is; Add_month Add_year In fact add_month would be sufficient because +12 months is add year +3 months is add quarter (next quarter) +6 months is next half year In an attempt to create a TW date 14

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Wow, is all I can say. Thanks Tony On Monday, 18 December 2017 10:14:02 UTC+11, Evan Balster wrote: > > Hey, all — > > Here's *Formula plugin* 0.1.1: > http://evanbalster.com/tiddlywiki/formulas.html > Source and issue tracking on GitHub: > https://github.com/EvanBalster/TiddlyWikiFormula >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, all — Here's *Formula plugin* 0.1.1: http://evanbalster.com/tiddlywiki/formulas.html Source and issue tracking on GitHub: https://github.com/EvanBalster/TiddlyWikiFormula This version adds: - A $formula-vars macro - Preliminary date and time support - Date literals as datum

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — I might have been a little terse in documenting the logical functions. The IF function chooses between its second and third arguments based on the first. For example, if({{!!x}}<1, "x is less than 1", "x is more than 1") The second and third argument can be whatever sort of date

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan, Please forgive my Ignorance; What can a and b be equal to in Formulas' logical functions, like IF and IFS? I am thinking if something evaluates to true how do I use this to - list - transclude - Use macro - Show some text etc... - Set a variable/field I imagine there is

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Hey, Tony — I'm not an impatient reader. :) I've added a Date type in my working copy, based on JavaScript's built-in Date (which is reasonably feature-rich). TiddlyWiki has some functions for date formatting in core, too. Libraries like moment.js offer a "kitchen sink" of features but I'm

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

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

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

> > 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

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

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*: >

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Great work Evan! I did find that the rounding functions fail when a second parameter is provided, so I submitted an issue on Github. Regards, Mal -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Reverse polish notation https://tid.li/tw5/hacks.html Den fredag den 15. december 2017 kl. 21.39.58 UTC+1 skrev Ste Wilson: > > Arrgghhh another option > rboue.tiddlyspot.com > mathcell.tiddlyspot.com > Reverse polish notation.. (can't find the link...) > > > I shall check this out! Cheers.

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

is this campaignWiki plugin available? On Thursday, December 14, 2017 at 11:05:58 PM UTC-6, Joshua Fontany wrote: > > Evan, this looks great! I think it will replace MathCell in my Earthdawn > "CampaignWiki" plugin. :) > > Mahalo (Thanks)! > > On Thursday, December 14, 2017 at 8:37:26 PM

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

I suppose I am a "Excel/Sheets nerd with Opinions", Also in addition to Excel a SharePoint user/developer I like implementing structures on top of Tiddlywiki we find elsewhere, such as hierarchies (one, two or multiple parents), Queues, Networks etc... because once you have a method it is easy

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Evan Balster wrote: > ... this does make some sense for the record. > :-) ... <$for x="0,100"> widget to make it easier to iterate over a series of > numbers. (I was also thinking about how useful it would be to have a > timer widget, which either fires events at an interval or advances a

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

Arrgghhh another option rboue.tiddlyspot.com mathcell.tiddlyspot.com Reverse polish notation.. (can't find the link...) I shall check this out! Cheers. -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and

[tw] Re: Formula: Spreadsheet-like mathematics for TiddlyWiki

That is a neat demo. Question: do you have or are you planning any rounding or averaging functions? Best, Joshua Fontany -- 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

  1   2   >