sum of column

[Gerald Weis]

Hi Folks

i have a table with 2 columns of numbers.

now i want to have the sum from every columns.

the Position of the sum shoud be above or below the columns.

I have no solution found for this.

Any Ideas?

thanks for all

[Mohammad]

I may recommend to use Shiraz with Dynamic tables.

Have a look here: https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-tables-numerical-summary

and here

https://kookma.github.io/TW-Shiraz/#Tutorial%20Dynamic%20Tables

Also if you make a search in the forum, Eric Shulman recently answered a similar question with a short and efficient solution.

--Mohammad

[Gerald Weis]

Hi Mohammed

this Macro shoud be very komplex.

i dont looking this.

i can english only with google and leo.org.

i have questions:

1. is it an plugin or macros

2. when it is an plugin, how i can import als plugin?

3. when it is an Macro  - drag and drop?

4. Where i become an german Manual?

thanks

[Mohammad]

Hi Gerald,

 Use Google translate! There is manual to use it!

Shiraz is a plugin! For install see

https://kookma.github.io/TW-Shiraz/#Shiraz%20Plugin

or simply drag and drop

https://kookma.github.io/TW-Shiraz/#%24%3A%2Fplugins%2Fkookma%2Fshiraz

to your wiki!

I hope a German speaking one can help here.

Good luck

Mohammad

[Gerald Weis]

hallo i follow your tip.

I have tested Shiraz-plugin and tiddlytables-plugin

But this tools are not what i need.

Problem:

the rate of liability insurance is calculated for one Year in row one. (with tiddliywiki)

the rate of comprehensive cover is calculated for one year in row two. (with tiddliwiki)

now i want the   results of this calculating  to add.

thatss all

[Mohammad]

Hi Gerald,

 The dynamic tables only works on columns NOT rows!

 So if you have a column created from a field you can use mathematical summaries!

--Mohammad

[TonyM]

Gerald,

This is a design approach I can see.

You will need to calculate the row value in each row with the information available in that row. You can display it in the table.

However to do an all of table sum you need to save these row details somewhere and sum them separately.

Once you are happy with your table, its logic and calculation "clone" it and remove all the display wikitext, then wrap it in a button that will contain the same list logic in it, however for each row it triggers an action widget that will save each row value somewhere such as a row related tiddler or a data tiddler. You can do this for multiple columns as well.

Once all these have being calculated and saved you can use a list filter to sum all the values and present the grand total.

I hope this helps (in translation), there are German speakers around.

Regards

Tony

[Gerald Weis]

Hallo Toniy

i have append a image, where you can see the structure of the tiddlyer wher shoud be calculated.

i'm in tiddlywiki not a professional.

that are the makros of me for this tiddler

\define Verstab()
<caption>{{!!title}}</caption>
<thead align=left valign=top>
<tr>
    <th>Unternehmen</th>
    <th>Versicherung</th>
    <th colspan=2>Klassen</th>
    <th colspan=4>Beitrag</th>
</tr>
<tr align=left valign=top>
    <th colspan=2></th>
    <th>Region</th>
    <th>Typ</th>
    <th>Satz %</th>
    <th>Zahle<br>Monate</th>
    <th>laut<br>Zahlweise</th>
    <th>Jahres-<br>Rate</th>
</tr>
</thead>
\end

   

\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

\define VersZwiSumme(Rate Jahresrate)
<thead>
<tr align=right>
    <th colspan=6>Zwischensumme</th>
    <th>$Rate$ €</th>
    <th>$Jahresrate$ €</th>
</tr>    
</thead>    
\end

   

\define VersGesSumme(Jahresrate)
<thead>
<tr align=right>
    <th colspan=6>Gesamtsumme</th>
    <th></th>
    <th>$Jahresrate$ €</th>
</tr>    
</thead>    
\end

But i <an't sum the culums

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

 

[Gerald Weis]

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

[Mark S.]

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!

[TonyM]

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

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

[Morgaine O'Herne]

I did it like this:  All of the data in the columns is in the Fields.   You can see this at http://morgensharn.tiddlyspot.com. The tiddler is "Eriel - Armor Weight."

@@.table

|ITEM|WEIGHT|

|{{!!a1}}|{{!!b1}}|

|{{!!a2}}|{{!!b2}}|

|{{!!a3}}|{{!!b3}}|

|{{!!a4}}|{{!!b4}}|

|{{!!a5}}|{{!!b5}}|

|{{!!a6}}|{{!!b6}}|

|{{!!a7}}|{{!!b7}}|

|{{!!a8}}|{{!!b8}}|

|{{!!a9}}|{{!!b9}}|

|{{!!a10}}|{{!!b10}}|

|TOTAL|<$macrocall $name="eval"  cell="(=!!b1+!!b2+!!b3+!!b4+!!b5+!!b6+!!b7+!!b8+!!b9+!!b10)" format="2" target="armor">|

@@

[Gerald Weis]

Hello Mark,

it is one car alone.

@TonyM

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

[Gerald Weis]

Hello Morgaine O'Herne

this is functional but its dosn't work if you use a template-tiddler

The fields of the template wil not be createt in the target tiddler.

for this to use i must know how i can make the Fields in the target tiddler.

then i can do.

[Mark S.]

You could use Morgaine's table as a template. Templates are very important in TW.

This is a simplified example, because I don't understand auto insurance etc. that well.

Let's say you had a template tiddler like this:

And a Auto tiddler like this:

Notice how the fields of the tiddlers contain the important information about the car. If youre TW is not using fields, you will

have to change each tiddler for each car every time there is a new car. That is a lot of work!

Notice also the template invocation {{||VersicherungTemplate}} .

When closed, this appears as this:

This, of course, is only the start. You would want to move all data about the auto, including the name and ID,

smogging, inspections, etc. to a tiddler about the car, or perhaps to a car/year (I am not sure which you are

tracking).

Your TW seems to have only two cars (Toyota Hybrid, Toyota Yaris). If that is all you need, then it doesn't matter.

But if you want to add many cars, then you will want to use templates.

Good luck!

[Gerald Weis]

hello Mark

thats right

in the wiki are 2 cars.

but the car with the licence-plate nk-cm-149 is completed.

the actual car have the licence-plate nk-wg-59

thats the only one car of me.

i have create a tiddler as the idol from Morgaine

but the formula dont work

i must all years edit the table

Is it possible to link the templatetable thats is editable and the data in the other Tiddler not changed

[Mark S.]

The !! markers indicate a field reference.

AFAIK, you can not invoke a macro inside a field.

Instead put the formula

<$macrocall $name="eval" cell="(=!!g2*12/!!f2)" format="2">

right in your template.

BUT the macro "eval" is not part of TiddlyWiki core. It is part of some plugin. If you

do not have it, you need to add it in.

Perhaps Morgaine or some other person here can say where the "eval" came from.

Good luck

On Thursday, February 27, 2020 at 10:20:55 AM UTC-8, Gerald Weis wrote:

hello Mark

thats right

in the wiki are 2 cars.

but the car with the licence-plate nk-cm-149 is completed.

the actual car have the licence-plate nk-wg-59

thats the only one car of me.

i have create a tiddler as the idol from Morgaine

but the formula dont work

[Gerald Weis]

hello Morgaine,

where can i find the "eval"Makro?

wich plugin i must have in use?

Am Donnerstag, 27. Februar 2020 07:21:09 UTC+1 schrieb Morgaine O'Herne:

[Mark S.]

After some research, I think it's from this:

http://mathcell.tiddlyspot.com/

[Gerald Weis]

Hello Mark

i have found it.

Now i want import Mathcell in my wiki.

But i not found how i can do that.

i'm using Tiddlywiki 5.21.

in the wiki mathcell are the information version 5.14.

can i use drag and drop?

[Birthe C]

In the tiddler "Start" you will find the necessary tiddlers listed. Drag and drop them into you own tiddlywiki and save.

Birthe

[Gerald Weis]

Hi Morgaine

thats the code of my tiddler

<<Headline "Toyota C-HR Hybrid" "NK-WG-59">

>

|{{!!title}}|c
|| A | B | C | D | E | F | G | H |h
|^ !1|{{!!a01}} |{{!!b01}} |{{!!c01}} |{{!!d01}} |{{!!e01}} |{{!!f01}} |{{!!g01}} |{{!!h01}} |h
|^ !2|{{!!a02}} |{{!!b02}}| {{!!c02}} | {{!!d02}} | {{!!e02}} | {{!!f02}} |  {{!!g02}}| <$macrocall $name="eval" cell="(=!!g02*12/!!f02)" format="2" target="summe_h02">|
|^ !3|{{!!a03}} |{{!!b03}}| {{!!c03}} | {{!!d03}} | {{!!e03}} | {{!!f03}} |  {{!!g03}}| <$macrocall $name="eval" cell="(=!!g03*12/!!f03)" format="2" target="summe_h03">|
|^ !4||<|<|<|<| {{!!summe_f04}}| <$macrocall $name="eval" cell="(=!!g02+g03)" format="2" target="summe_g04">| <$macrocall $name="eval" cell="(=!!h02+!!h03)" format="2" target="summe_h04">|h
|^!5|{{a05}} |{{b05}} |||| {{f05}} | {{g05}}| <$macrocall $name="eval" cell="(=!!g05*12/!!f05)" format="2" target="summe_h05">|
|^!6||||||| <$macrocal $name="eval" cell="(!!summe_f04+(!!summe_h05/!!f02))">| <$macrocall $name="eval" cell="(=!!summe_h04+!!summe_h05) format="2" target="summe_h06">|h
|^ !5|{{!!a5}}|{{!!b5}}|||| {{!!f5}} | {{!!g5}}| {{!!zwischensummen_h5}}|
|^ !6|>|>|>|>|>| {{!!summe_f6}}| {{!!summe_g6}}|{{!!summe_h6}}|h

and this is what he do -see Bild01

and this are the fields

Bild02 Fields A1 to F5 and

Bild03 Fields G1 to summe_H06

all Fields are filled.

all Fields form A2 to G2 and

and A3 got G3

and A5 to G5

must all year new editet.

the values you can see are testdata.

2 questions.

1. how can i the tiddler clone or of an other way copy that the fields are in the new tiddler.

2. what ist wrong, that the formulas not work:

i have all tiddlers on the site http://mathcell.tiddlyspot.com/ are listet importet.

then i have saved my wiki and closed.

Now i have do a new start of my wiki.

thanks for answer

Am Donnerstag, 27. Februar 2020 07:21:09 UTC+1 schrieb Morgaine O'Herne:

[Morgaine O'Herne]

Hi Gerald,

The eval formulas don't go in the fields. The eval macrocall in my example is in the tiddler itself.  

Here is an example of a formula that can  be in a field:

myfield: (= round(({{Eriel - Attributes!!agility}}+{{Eriel - Attributes!!dexterity}}+{{Eriel - Attributes!!strength}})/3) =)

This calls in fields from other tiddlers like so:  {{TiddlerName!!fieldName}}

The value of the formula above can be called into another tiddler by referencing the field, as in {{tiddlerTitle!!myfield}}

Another way to do this would be to use the eval macrocall in the cell of the tiddler, and target the field name, then reference that field name in another tiddler in the same way.

I hope this helps.

Don't feel bad; I spend a lllooooonnnnggg time studying all this before it started to make sense.

On Fri, Feb 28, 2020 at 2:41 AM Gerald Weis <gerald...@gmail.com> wrote:

Hi Morgaine

thats the code of my tiddler

<<Headline "Toyota C-HR Hybrid" "NK-WG-59">

>

|{{!!title}}|c
|| A | B | C | D | E | F | G | H |h

|^ 1|{{!!a1}} |{{!!b1}} |{{!!c1}} |{{!!d1}} |{{!!e1}} |{{!!f1}} |{{!!g1}} |{{!!h1}} |h
|^ !2|{{!!a2}} |{{!!b2}} | {{!!c2}} | {{!!d2}} | {{!!e2}} | {{!!f2}} | {{!!g2}}| {{!!zwischensummen_h2}}|
|^ !3|{{!!a3}} |{{!!b3}} | {{!!c3}} | {{!!d3}} | {{!!e3}} | {{!!f3}} | {{!!g3}}| {{!!zwischensummen_h3}}|
|^ !4|>|>|>|>|>| {{!!zwischensummen_f4}}| {{!!zwischensummen_g4}}| {{!!zwischensummen_h4}}|h

|^ !5|{{!!a5}}|{{!!b5}}|||| {{!!f5}} | {{!!g5}}| {{!!zwischensummen_h5}}|
|^ !6|>|>|>|>|>| {{!!summe_f6}}| {{!!summe_g6}}|{{!!summe_h6}}|h

--
You received this message because you are subscribed to a topic in the Google Groups "TiddlyWiki" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tiddlywiki/W2pVlzHI4CM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/5b60ea08-3295-407e-a580-2043eabb9123%40googlegroups.com.

[Gerald Weis]

Hi Morgaine,

i have new structured my tiddler:

the new code is

<<Headline "Toyota C-HR Hybrid" "NK-WG-59">

>

|{{!!title}}|c
|| A | B | C | D | E | F | G | H |h

|^ !1|{{!!a01}} |{{!!b01}} |{{!!c01}} |{{!!d01}} |{{!!e01}} |{{!!f01}} |{{!!g01}} | {{!!h01}}|h

|^ !2|{{!!a02}} |{{!!b02}}| {{!!c02}} | {{!!d02}} | {{!!e02}} | {{!!f02}} |  {{!!g02}}| {{!!summe_h02}}|
|^ !3|{{!!a03}} |{{!!b03}}| {{!!c03}} | {{!!d03}} | {{!!e03}} | {{!!f03}} |  {{!!g03}}| {{!!summe_h03}}|
|^ !4||<|<|<|<| {{!!summe_f04}}|{{!!summe_g04}}| {{!!summe_h04}}|h
|^!5|{{!!a05}} |{{!!b05}} |||| {{!!f05}} | {{!!g05}}| {{!!summe_h05}}|
|^!6||||||| {{!!summe_g06}}| {{!!summe_h06}}|h

i follow your tip. But i have a problem.

i have create for each formula an new field.

Now it dont work:

fields Formulas and what the result in to images wich append.

I'm worry

To unsubscribe from this group and all its topics, send an email to tiddl...@googlegroups.com.

[Morgaine O'Herne]

I think I've spotted some reasons for the problem.

1. You have to have only the formula in the field, nothing else. If you want other words in the cell with the value of the formula, you need to write them in the cell, not in the field.

2. When you write the formula, there has to be a space between the (=  =) and the formula itself, on both ends. 

As in (= {{!!field1}}+{{!!field2}} =)

not   (={{!!field1}}+{{!!field2}}=)

Some of your formulas do not have this space.

Hope that's all it takes to fix it. Let me know if you need any more help. 🤓

Morgaine

To unsubscribe from this group and all its topics, send an email to tiddlywiki+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d04e100f-8b34-4938-829a-200608b5969b%40googlegroups.com.

[Gerald Weis]

Hallo Morgaine,

i think my formula is  right right now.

but the results are an text not an calculate

i have appended 2 images

To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d04e100f-8b34-4938-829a-200608b5969b%40googlegroups.com.

[Mat]

Worth mentioning: Thomas has a neat macro called rpn (reverse polish notation) here. If I recall, he made it just before Evan made his much more general, and completely different, thing. For summing up stuff in a table, just maybe Thomas' solution is "neater"...

<:-)

[Gerald Weis]

Hello Mat

how i can delete deactivatetd plugins.

i have tested shiraz - to complicatet

i have tested mathcell is form writing of formulas the easiest

i have tested rpn - with the polsk notation i not came clear.

[Mohammad]

On Sunday, March 1, 2020 at 4:09:36 PM UTC+3:30, Gerald Weis wrote:

Hello Mat

how i can delete deactivatetd plugins.

1. Open $:/ControlPanel
2. Go to Plugins tab
3. Find the plugin you like to remove
4. Click on its title to open it in its own tiddler
5. You see top right (under plugin description) a disable button
1. If you clicked the plugin will be disabled,
2. save your Tiddlywiki and reload
6. To delete from drop down of more actions, select the delete button to permanently remove the plugin
7. Save and reload your wiki

--Mohammad

 

i have tested shiraz - to complicatet

Too bad! With many documentation and tutorial I have provided, I understood for newcomers it is useless :-)

So, I gonna to delete the repository! :-) :-)  

[Gerald Weis]

Hi Morgaine,

now the formula was show in table only as text

thats are my formula

field   formula

g4:    (= ({{!!g2}}+{{!!g3}}) =)

h2:    (= ({{!!g2}}*12/{{!!f2}}) =)

h3:    (= ({{!!g3}}*12/{{!!f3}}) =)

h4:    (= ({{!!g4}}*12/{{!!f3}}) =)

h5:    (= ({{!!g5}}*12/{{!!f05}}) =)

h6:    (= ({{!!h4}}+{{!!h5}}) =)

All formula are beginin at the first sign into the field

In all Formula are the ) the last sign.

To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/d04e100f-8b34-4938-829a-200608b5969b%40googlegroups.com.