This isn't really a data-driven or a tiddler-driven project. All I did was
make a macro to calculate
the total yearly amounts, then do the calculation 3 times, each time
putting it in a different
variable. Then, at the bottom, just sum the variables.
This is not the approach you would want if you were tracking dozens or
hundreds of cars, but
if there is only one or two then it might work. That's why I asked about
the number of vehicles.
The highly professional presentation makes me wonder if there is a larger
goal in view.
A tiddler-driven approach would require a lot more effort to understand
what is being tracked.
On Wednesday, February 26, 2020 at 3:30:35 PM UTC-8, TonyM wrote:
>
> Mark,
>
> Could you please do an English version to help us read it?, if possible. I
> am keen to read how you sum a calculated "column".
>
> Regards
> Tony
>
> On Thursday, February 27, 2020 at 7:15:07 AM UTC+11, Mark S. wrote:
>>
>> Here's what I made for
>>
>> Versicherung - 2020
>>
>> Enter code here...\define jahrlich(zm,lw) {{{ [[$lw$]multiply[12]divide[
>> $zm$]fixed[2]] }}}
>> <<Headline "Toyota C-HR Hybrid" "NK-WG-59">>
>> <table>
>> <<Verstab "Jahr">>
>> <<Verskauf "Generali" "Haftpflicht" "R9" "16" "70" "3" "308.22">>
>> <<Verskauf "Generali" "Vollkasko" "R4" "25" "44" "3" "249.65">>
>> <$wikify text=<<jahrlich 3 308.22>> name=jahres1>
>> <$wikify text=<<jahrlich 3 249.65>> name=jahres2>
>> <$wikify text=<<jahrlich 1 13.40>> name=jahres3>
>> <$vars jahresrate={{{ [<jahres1>][<jahres2>]+[sum[]] }}}
>> rate={{{ [[308.22]][[249.65]]+[sum[]] }}}
>> >
>> <$macrocall $name=VersZwiSumme Rate=<<rate>> Jahresrate=<<jahresrate>> />
>>
>> <<Verskauf "Unternehmen" "Kaufpreisschutz" "-" "-" "-" "1" "13.40" >>
>> <$vars jahresrate={{{ [<jahres1>][<jahres2>][<jahres3>]+[sum[]] }}} >
>> <$macrocall $name=VersGesSumme Jahresrate=<<jahresrate>> />
>> </$vars>
>> </$vars></$wikify></$wikify></$wikify>
>> </table>
>>
>> Do you plan on doing this for just two cars, or many cars?
>>
>> This approach will be difficult for many cars.
>>
>> For many cars, you will need something like the "dyanmic tables" that
>> Mohammad suggests. And you
>> will need to put your data (rates, monthly payments, etc.) into tiddlers.
>> The tables you create with
>> "dynamic tables" may not be as attractive, but they will be easier to
>> maintain.
>>
>> Viel Glück!
>>
>> On Wednesday, February 26, 2020 at 1:47:24 AM UTC-8, Gerald Weis wrote:
>>>
>>> Hello Mark
>>>
>>> i can do this.
>>>
>>> that is the wiki with the complete data.
>>> i hope you have idea or solution for me.
>>>
>>> thanks
>>> Gerald
>>>
>>> the complete Wiki is appended
>>>
>>> Am Mittwoch, 26. Februar 2020 01:21:08 UTC+1 schrieb Mark S.:
>>>>
>>>> Can you post your tiddlywiki somewhere?
>>>>
>>>> These macros do not show us your calculations, and we do not know the
>>>> structure of your tiddlers. Even
>>>> in English it would be hard to help without these things.
>>>>
>>>> This macro has at least one error:
>>>>
>>>>
>>>>> \define Verskauf(Unternehmen Versart Regionalklasse Typklasse
>>>>> BeitragssatzProzent Zahlmonate LautZahlweise Jahresrate)
>>>>> <$vars Jahr= {{{ [[$LautZahlweise$]multiply[12]divide[$Zahlmonate$]]
>>>>> }}}>
>>>>> <$vars Jahr={{{[<Jahr>fixed[2]]}}}>
>>>>> <tr align=center>
>>>>> <td align=left>$Unternehmen$</td>
>>>>> <td align=left>$Versart$</td>
>>>>> <td>$Regionalklasse$</td>
>>>>> <td>$Typklasse$</td>
>>>>> <td>$BeitragssatzProzent$</td>
>>>>> <td>$Zahlmonate$</td>
>>>>> <td align=right>$LautZahlweise$ €</td>
>>>>> <td align=right><<Jahr>> €</td>
>>>>> </tr>
>>>>> </$vars>
>>>>> \end
>>>>>
>>>>> The second <$vars> tag must match a second <$/vars> closing tag. All
>>>>> opening tags must match a closing tag.
>>>>>
>>>> <$vars Jahr=.....>
>>>> <$vars Jahr=.... mehr ...>
>>>> .... macro code ....
>>>> </$vars> FIRST CLOSING TAG
>>>> </$vars> SECOND CLOSING TAG
>>>>
>>>> Good luck!
>>>>
>>>>
>>>>
>>>
--
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/8ab50b6b-c779-4523-a21d-ffa2c97a0165%40googlegroups.com.
