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 - This page was cached on 18 Oct 2018 - 01:42.

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