PhpSpreadsheet/tests/data/Calculation/Engineering/ERF.php

582 lines
7.7 KiB
PHP
Raw Permalink Normal View History

<?php
// lower, bound, upper bound, Result
return [
[
0.0,
0,
],
[
0.0112834155558496,
0.01,
],
[
0.056371977797016602,
0.050000000000000003,
],
[
0.11246291601828499,
0.10000000000000001,
],
[
0.140316204801334,
0.125,
],
[
0.167995971427363,
0.14999999999999999,
],
[
0.222702589210478,
0.20000000000000001,
],
[
0.27632639016823701,
0.25,
],
[
0.328626759459127,
0.29999999999999999,
],
[
0.37938205356230997,
0.34999999999999998,
],
[
0.42839235504666801,
0.40000000000000002,
],
[
0.475481719786924,
0.45000000000000001,
],
[
0.52049987781304696,
0.5,
],
[
0.60385609084792602,
0.59999999999999998,
],
[
0.67780119383741799,
0.69999999999999996,
],
[
0.74210096470766096,
0.80000000000000004,
],
[
0.79690821242283205,
0.90000000000000002,
],
[
0.84270079294971501,
1,
],
[
0.88020506957408196,
1.1000000000000001,
],
[
0.910313978229635,
1.2,
],
[
0.93400794494065198,
1.3,
],
[
0.95228511976264896,
1.3999999999999999,
],
[
0.96610514647531098,
1.5,
],
[
0.98667167121918198,
1.75,
],
[
0.99532226501895305,
2,
],
[
0.99959304798255499,
2.5,
],
[
0.99997790950300103,
3,
],
[
0.99999925690162805,
3.5,
],
[
0.99999998458274197,
4,
],
[
0.99999999980338405,
4.5,
],
[
0.99999999999846301,
5,
],
[
0.99999999999999301,
5.5,
],
[
1.0,
6,
],
[
1.0,
32,
],
[
-0.11246291601828499,
-0.10000000000000001,
],
[
-0.84270079294971501,
-1,
],
[
'#VALUE!',
true,
],
[
'#VALUE!',
false,
],
[
0.99532226501895305,
'2',
],
[
'#VALUE!',
'TWO',
],
[
0.0,
-1.5,
-1.5,
],
[
-0.25494951282179601,
-0.75,
-1.5,
],
[
-0.96610514647531098,
0,
-1.5,
],
[
-1.67726078012883,
0.75,
-1.5,
],
[
-1.93221029295062,
1.5,
-1.5,
],
[
-1.96464242988863,
2.25,
-1.5,
],
[
-1.96608305597831,
3,
-1.5,
],
[
-1.96610503274805,
3.75,
-1.5,
],
[
-1.96610514627869,
4.5,
-1.5,
],
[
0.25494951282179601,
-1.5,
-0.75,
],
[
0.0,
-0.75,
-0.75,
],
[
-0.71115563365351497,
0,
-0.75,
],
[
-1.4223112673070299,
0.75,
-0.75,
],
[
-1.67726078012883,
1.5,
-0.75,
],
[
-1.70969291706683,
2.25,
-0.75,
],
[
-1.71113354315652,
3,
-0.75,
],
[
-1.71115551992626,
3.75,
-0.75,
],
[
-1.7111556334569,
4.5,
-0.75,
],
[
0.96610514647531098,
-1.5,
0,
],
[
0.71115563365351497,
-0.75,
0,
],
[
0.0,
0,
0,
],
[
-0.71115563365351497,
0.75,
0,
],
[
-0.96610514647531098,
1.5,
0,
],
[
-0.99853728341331904,
2.25,
0,
],
[
-0.99997790950300103,
3,
0,
],
[
-0.99999988627274305,
3.75,
0,
],
[
-0.99999999980338405,
4.5,
0,
],
[
1.67726078012883,
-1.5,
0.75,
],
[
1.4223112673070299,
-0.75,
0.75,
],
[
0.71115563365351497,
0,
0.75,
],
[
0.0,
0.75,
0.75,
],
[
-0.25494951282179601,
1.5,
0.75,
],
[
-0.28738164975980401,
2.25,
0.75,
],
[
-0.288822275849486,
3,
0.75,
],
[
-0.28884425261922803,
3.75,
0.75,
],
[
-0.28884436614986903,
4.5,
0.75,
],
[
1.93221029295062,
-1.5,
1.5,
],
[
1.67726078012883,
-0.75,
1.5,
],
[
0.96610514647531098,
0,
1.5,
],
[
0.25494951282179601,
0.75,
1.5,
],
[
0.0,
1.5,
1.5,
],
[
-0.032432136938008102,
2.25,
1.5,
],
[
-0.0338727630276906,
3,
1.5,
],
[
-0.033894739797432599,
3.75,
1.5,
],
[
-0.033894853328073203,
4.5,
1.5,
],
[
1.96464242988863,
-1.5,
2.25,
],
[
1.70969291706683,
-0.75,
2.25,
],
[
0.99853728341331904,
0,
2.25,
],
[
0.28738164975980401,
0.75,
2.25,
],
[
0.032432136938008102,
1.5,
2.25,
],
[
0.0,
2.25,
2.25,
],
[
-0.0014406260896824999,
3,
2.25,
],
[
-0.0014626028594246,
3.75,
2.25,
],
[
-0.0014627163900651,
4.5,
2.25,
],
[
1.96608305597831,
-1.5,
3,
],
[
1.71113354315652,
-0.75,
3,
],
[
0.99997790950300103,
0,
3,
],
[
0.288822275849486,
0.75,
3,
],
[
0.0338727630276906,
1.5,
3,
],
[
0.0014406260896824999,
2.25,
3,
],
[
0.0,
3,
3,
],
[
-2.1976769741999999E-5,
3.75,
3,
],
[
-2.2090300382599999E-5,
4.5,
3,
],
[
1.96610503274805,
-1.5,
3.75,
],
[
1.71115551992626,
-0.75,
3.75,
],
[
0.99999988627274305,
0,
3.75,
],
[
0.28884425261922803,
0.75,
3.75,
],
[
0.033894739797432599,
1.5,
3.75,
],
[
0.0014626028594246,
2.25,
3.75,
],
[
2.1976769741999999E-5,
3,
3.75,
],
[
0.0,
3.75,
3.75,
],
[
-1.135306406E-7,
4.5,
3.75,
],
[
1.96610514627869,
-1.5,
4.5,
],
[
1.7111556334569,
-0.75,
4.5,
],
[
0.99999999980338405,
0,
4.5,
],
[
0.28884436614986903,
0.75,
4.5,
],
[
0.033894853328073203,
1.5,
4.5,
],
[
0.0014627163900651,
2.25,
4.5,
],
[
2.2090300382599999E-5,
3,
4.5,
],
[
1.135306406E-7,
3.75,
4.5,
],
[
0.0,
4.5,
4.5,
],
[
-1.84270079294818,
5,
-1,
],
[
1.84270079294818,
-5,
1,
],
];