Hello Mark, it is one car alone. @MonyM Kennzeichen is the licence plate of the car. Unternehmen = insurance company Versicherung = insurance type Klasse: Regional(Regionalklasse) = category of region Klasse: Typ(Typklasse)=category of typ Beitragsatz % = membership rate per percent Beitrag Zahle Monate = month to pay Beitrag laut Zahlweise =membership rate for month to pay
Am Donnerstag, 27. Februar 2020 05:47:57 UTC+1 schrieb Mark S.: > > 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 tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/a6007092-b46f-4d98-9da0-6899439401a1%40googlegroups.com.