Scot, THANK YOU for pointing out Spreadsheet Prototype, and suggesting I download Evan Balster's wiki. So convenient to download everything at once in one place!
I cloned the prototype spreadsheet, and put the following words in A1, B1, C1, D1, E1, F1 and G1: Category, Date, Description, Debit, Credit, Balance, Notes; filled in 2 more rows with the appropriate information and learned how to put =SUM(F2-D3+E3) in F3 [current balance = previous balance minus current debit plus current credit] But I have years of expenses to enter. Do I have to make a unique formula for the F cell in each row? In a normal spreadsheet app (and I barely know how to use those either, just learned tonight) I would just click on the corner of the cell and drag down to make all subsequent cells in that column do the same thing. But I can't click with this prototype spreadsheet. *So that I don't have to put something unique in every cell in F Column, is it possible to code it so that something like =SUM(F<previous>-D<current>+E<current>) appears in every F Column cell?* *Another problem: * *If I fill in 30 days of expenses, and suddenly discover a Day 8 expense, how do I add a row at the appropriate spot?* On Tuesday, September 22, 2020 at 9:44:51 PM UTC+8 scot wrote: > Sapphireslinger > > Here is the demo page of the Formula Plugin by Evan Balster. > > https://chronicles.wiki/TiddlyWikiFormula/ > > Have a look at "Demo: Tabulator" and "Spreadsheet Prototype" examples. > You can download the wiki by clicking on the "save changes" button in the > Toolbar. > > Scot > > On Tuesday, 22 September 2020 at 13:25:41 UTC+1 Atronoush wrote: > >> As Ste advised one tool is Shiraz Dynamic table >> >> See example here: >> https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-tables-numerical-summary >> >> Each item can be a tiddler with suitable fields. Then you can use a >> Dynamic Table to summarize all and calculate the balance. >> Shiraz has some good tutorials for dynamic tables. >> >> Atro >> >> >> >> >> On Tue, Sep 22, 2020 at 3:44 PM Sapphireslinger <[email protected]> >> wrote: >> >>> 1. Has anybody ever used Tiddlywiki to keep track of their daily >>> expenses? >>> >>> 2. Is there a demo anywhere of a simple expense sheet with 6 columns for >>> Date, Category, Description, Debit, Credit, Balance? >>> >>> I have looked at the links provided above more than once but can not >>> seem to figure out how to make them work. >>> >>> >>> On Thursday, May 14, 2020 at 8:52:47 PM UTC+8 Ste wrote: >>> >>>> https://github.com/EvanBalster/TiddlyWikiFormula >>>> >>>> http://tiddlytables.tiddlyspot.com/ >>>> >>>> https://kookma.github.io/TW-Shiraz/ >>>> >>>> And more at https://dynalist.io/d/zUP-nIWu2FFoXH-oM7L7d9DM#q=Tables >>>> >>>> -- >>> 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 view this discussion on the web visit >>> https://groups.google.com/d/msgid/tiddlywiki/4bad96dc-35cf-4da3-8ebd-dda442db939cn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/tiddlywiki/4bad96dc-35cf-4da3-8ebd-dda442db939cn%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/3e9ec88c-72ac-4592-a17c-a1bc0ed67167n%40googlegroups.com.
