This question about Using an extension: Answered

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

-- 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:

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(R1: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{"$T(R$ROW():C1)"}%
25
25

To make calculations, you use the $EVAL() function. For example, to multiple Column 1 times 2:
25
%CALC{"$EVAL($T(R$ROW():C1) * 2)"}%
25
50

 
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
-- GeorgeClark - 24 Jan 2018
 

FİYAT TEKLİFİ DETAYI

Hizmet Tanımı Çal.Say KBÇS Dak/Ay Saat/Ay Toplam %KDV TOPLAM
İşyeri Hekimi Hizmet Bedeli
41
10
410
7
525
8
567
edit
İş Güvenliği Uzmanı Hizmet Bedeli
41
20
820
14
155
18
183
edit
Toplam
 
 
 
 
680
 
750
edit

I would like to thank so much to GeorgeClark for helping me to learn such kind above formulations. smile smile smile

-- SinanGUL - 30 Jan 2018
 

QuestionForm edit

Subject Using an extension
Extension SpreadSheetPlugin
Version Foswiki 2.1.4
Status Answered
Related Topics
Topic revision: r4 - 30 Jan 2018, SinanGUL
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy