2017-02-24T18:54:42.931133976P0D1LibreOfficeDev/6.1.0.0.alpha0$Linux_X86_64 LibreOffice_project/6e31851e72520ce08e5cd2bf1f3aaa9f100a3eff
0
0
45753
18813
view1
2
8
0
0
0
0
2
0
0
0
0
0
100
60
true
false
2
1
0
0
0
0
2
0
0
0
0
0
100
60
true
false
Sheet2
1459
0
100
60
false
true
true
true
12632256
true
true
true
true
true
false
false
1270
1270
1
1
true
false
7
true
false
false
0
false
iQH+/0dlbmVyaWMgUHJpbnRlcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAU0dFTlBSVAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAMAqgAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9R2VuZXJpYyBQcmludGVyCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCm1hcmdpbmRhanVzdG1lbnQ9MCwwLDAsMApjb2xvcmRlcHRoPTI0CnBzbGV2ZWw9MApwZGZkZXZpY2U9MApjb2xvcmRldmljZT0wClBQRENvbnRleERhdGEKUGFnZVNpemU6TGV0dGVyAAASAENPTVBBVF9EVVBMRVhfTU9ERQ8ARHVwbGV4TW9kZTo6T2Zm
Generic Printer
cs
CZ
de
DE
en
US
nl
NL
true
3
true
false
true
true
12632256
true
true
false
true
false
true
false
true
1
false
1270
1270
false
1
true
Kč
-
Kč
(
)
-
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
-
€
/
/
/
/
€
-
€
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
Kč
-
Kč
-
-
-
-
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
:
:
:
:
Yes
Yes
No
True
True
False
On
On
Off
¥€
(
€
)
€
-
€
$
($
)
€
-
€
€
-
€
€
€
-
€
€
-
€
-
-
€
-
€
- €
-
-
€
-
€
-
€
$
($
)
$
($
)
$
($
)
(
)
-
$
$
(
)
$
-
$
$
(
)
$
-
€
(
€
)
\
\-
\
\-
\
\-
\
\-
\
\
-
\
-
-
-
\
\
-
\
-
-
-
-
-
-
-
$
$(
)
$-
(
)
-
$
$(
)
$-
(
)
-
%
%
%
%
%
%
%
%
%
%
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
€
-
€
%
%
%
%
%
%
$
(
$
)
%
%
-
%
-
-
-
£
-
£
£
-
£
%
-
%
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
-
-
DM
-
DM
- DM
-
-
DM
-
DM
-
DM
Ouch! -
- Error detected!
- Result=0 - No Errordetection
/
/
/
/
£
-£
£
-£
£
-£
£
-£
-
-
£
-£
£
-
-
-
£
-£
£
-
¥
-
¥
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
DM
-
DM
€
€
-
tan
aa
zł
-
zł
€
-
€
:
:
:
:
€
-
€
€
-
€
(
)
-
$
$
(
)
$
-
(
)
-
$
$
(
)
$
-
€
(
€
)
ok
ERR!
-
-
Kč
-
Kč
- Kč
-
-
Kč
-
Kč
-
Kč
¥€
(
€
)
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
-
:
:
:
(
)
%
(
)
-
(
)
-
(
)
-
(
)
-
.
.
:
:
:
.
.
:
-
-
-
-
€
-
€
€
-
€
€
-
€
€
-
€
:
:
:
€
€
-
€
€
-
€
€
-
€
€
-
-
-
-
-
-
-
:
:
:
:
:
:
-
-
:
-
-
-
-
-
-
€
€
-
€
-
-
-
€
€
-
€
-
%
/
/
???
Page 1
???(???)
00/00/0000, 00:00:00
Page 1/ 99
T.DIST.RT Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple T.DIST.RT formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
1
10
1
0
Data
Data
0.17044656615103
0.17044656615103
TRUE
=T.DIST.RT(1, 10)
2
11
2
0
Known y
Known x
1.959999998
0.17044656615103
0.17044656615103
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
3
12
3
0
2
6
60
0.035401977534017
0.035401977534017
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
4
13
4
0
3
5
0.005533347843017
0.005533347843017
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
5
14
5
0
9
11
0.000756039679406
0.000756039679406
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
6
15
6
0
1
7
9.7257653128633E-05
9.7257653128633E-05
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
7
16
7
0
8
5
1.21632727555193E-05
1.21632727555193E-05
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
8
17
8
0
7
4
1.49794463195888E-06
1.49794463195888E-06
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
9
18
9
0
5
4
1.82496662157233E-07
1.82496662157233E-07
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
10
19
10
0
2.20213936459103E-08
2.20213936459103E-08
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
11
20
11
0
2.63151308116795E-09
2.63151308116795E-09
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
3.1123250806477E-10
3.1123250806477E-10
TRUE
{=T.DIST.RT(F1:F11,G1:G11)}
0.25
0.25
TRUE
=T.DIST.RT(F1,H1)
0.091751709536137
0.091751709536137
TRUE
=T.DIST.RT(F2,H2)
654654
654
1
0.028834442811219
0.028834442811219
TRUE
=T.DIST.RT(F3,H3)
0.008065044950046
0.008065044950046
TRUE
=T.DIST.RT(F4,H4)
0.002052357990027
0.002052357990027
TRUE
=T.DIST.RT(F5,H5)
0.000482267597208
0.000482267597208
TRUE
=T.DIST.RT(F6,H6)
0.000105777425973
0.000105777425973
TRUE
=T.DIST.RT(F7,H7)
0
0
TRUE
=T.DIST.RT(F15,G15)
0.000486711984885
0.000486711984885
TRUE
=T.DIST.RT(G15,H15)
4.62131557658376E-002
0.046213155765838
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
1.50496239487313E-002
0.015049623948731
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
1.04807918350441E-006
1.04807918350441E-06
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
1.75308331410104E-001
0.175308331410104
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
2.46453330286222E-004
0.000246453330286
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
1.09606490334647E-003
0.001096064903346
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
3.74521694063726E-003
0.003745216940637
TRUE
{=T.DIST.RT(L3:L9,M3:M9)}
Err:502
Err:502
TRUE
=T.DIST.RT(2,0.9)
5.00000000000000E-001
0.5
TRUE
=T.DIST.RT(0,9)
8.28281801931043E-001
0.828281801931043
TRUE
=T.DIST.RT(-1,9)
0.027322464987961
0.027322464987961
TRUE
=T.DIST.RT(O2,O3)