Just throwing out there that you could use one tiddler to enter all your
data, then use splitregexp to find the specific records and columns. Add in
fields for the column offsets.
<$list filter="[{$ur_acct$!!text}splitregexp[\n]count[]]">
<$list filter="[range<currentTiddler>!match[1]]"><$vars
rownum=<<currentTiddler>> >
<$list filter="[{$ur_acct$!!text}splitregexp[\n]nth<rownum>]"><$vars
cur_line=<<currentTiddler>> ><tr>
<$list
filter="[<cur_line>split[|]nth{$ur_acct$!!date}]"><td><<currentTiddler>></td></$list>
\define month_entries(ur_assign_col, ur_match_val)
<$list filter="[tag[UrTag]]">
<$macrocall $name=month_entries_acct ur_acct=<<currentTiddler>>
ur_assign_col="$ur_assign_col$" ur_match_val="$ur_match_val$" />
</$list>
\end
<$wikify name=month_entry_list text=<<month_entries 2 UrLookupValue>> >
<$macrocall $name=month_total ur_list=<<month_entry_list>> />
</$wikify>
On Saturday, October 3, 2020 at 12:28:44 AM UTC-7 TW Tones wrote:
> Sapphireslinger,
>
> Perhaps this helps?
>
> In case like this make a tiddler that acts as a template for new expenses,
> including formulas separate from values entered. The create a new tiddler
> from that template when adding a new expense.
>
> I am working on a generic way to generate new tiddlers from templates,
> clone, spawn or generate child tiddlers so ths is at the forefront of my
> mind, not sure how long and if I publish publicly.
>
> Regards
> Tones
>
>
> On Friday, 2 October 2020 23:34:43 UTC+10, Sapphireslinger wrote:
>>
>> 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 lots 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/f995e6f8-2b09-49aa-aa56-80d7a18557cen%40googlegroups.com.
