Writing some formulations

-- SinanGUL - 24 Jan 2018

TABLE 1

Nr.	Description	Nr of Employee (Digital data)	Minutes/Per Employee (Digital data)	Minutes/Month	Hour/Month	Total (Euro)	VAT	Total (Euro)
1	Occupational Safety Expert	A1	A2	A3=A1*A2	A4=A3/60	A5=A4*120	A6=%18	A7=A5+A5*18/100	edit
2	Occupational Physician	B1	B2	B3=B1*B2	B4=B3/60	B5=B4*120	B7=%8	B7=B5+B5*18/100	edit

TABLE 2

Nr.	Description	Nr of Employee (Digital data)	Minutes/Per Employee (Digital data)	Minutes/Month	Hour/Month	Total (Euro)	VAT	Total (Euro)
1	Occupational Safety Expert	A1	A2	A3=A1*A2	A4=A3/60	A5=A4*120	A6=%18	A7=A5+A5*18/100	edit
2	Occupational Physician	B1	B2	B3=B1*B2	B4=B3/60	B5=B4*120	B6=%8	B7=B5+B5*8/100	edit

Could you please help me to write the calculation ( %CALC {...% ) formulations of "TABLE 1 cells" to "TABLE 2 cells as described. Thanks in advance for your support.

-- SinanGUL - 24 Jan 2018

I know my above question is really beginner level question to foswiki gurus, especially while their agendas is full of developing tasks&issues. But for now, this is my question and still needs your support.

-- SinanGUL - 24 Jan 2018

Here is a bit of a tutorial starting with how to reference an individual cell, and how to do calculations, finishing with a couple of columns from your example:

25	`%CALC{"$T(R1:C1)"}%`
25	25

Reference to a single cell is done with $T(Rn:Cn) So this example uses %CALC{"$T(R1:C1)"}% to access Row 1 Column 1.

25	`%CALC{"$T(R$ROW():C1)"}%`
25	25

However to be flexible, you might want to reference columns in "this row", without having to enter an explicit row number. $ROW() returns the absolute row number, so replace the row number with R$ROW() to reference to cells in "this" row. This example uses %CALC{"$T(R$ROW():C1)"}%

25	`%CALC{"$EVAL($T(R$ROW():C1) * 2)"}%`
25	`50`

To make calculations, you use the $EVAL() function. For example, to multiple Column 1 times 2:

Description	20	5	A3=A1*A2	A4=A3/60	A5=A4*120
column numbers	C3	C4	C5	C6	C7
Formulas	20	5	C3 * C4	C5 / 60	C6 * 120
Some text	20	5	`%CALC{"$EVAL($T(R$ROW():C3) * $T(R$ROW():C4) ) "}%`	`%CALC{"$EVAL($T(R$ROW():C5) / 60)"}%`	`%CALC{"$EVAL($T(R$ROW():C6) * 120)"}%`
Some text	20	5	100	1.66666666666667	200