DMIN
00:07:11 Returns the minimum value from selected database entries.
00:07:11 Database
array(7) {
[4]=>
array(5) {
["A"]=>
string(4) "Tree"
["B"]=>
string(6) "Height"
["C"]=>
string(3) "Age"
["D"]=>
string(5) "Yield"
["E"]=>
string(6) "Profit"
}
[5]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
int(18)
["C"]=>
int(20)
["D"]=>
int(14)
["E"]=>
float(105)
}
[6]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
int(12)
["C"]=>
int(12)
["D"]=>
int(10)
["E"]=>
float(96)
}
[7]=>
array(5) {
["A"]=>
string(6) "Cherry"
["B"]=>
int(13)
["C"]=>
int(14)
["D"]=>
int(9)
["E"]=>
float(105)
}
[8]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
int(14)
["C"]=>
int(15)
["D"]=>
int(10)
["E"]=>
float(75)
}
[9]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
int(9)
["C"]=>
int(8)
["D"]=>
int(8)
["E"]=>
float(76.8)
}
[10]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
int(8)
["C"]=>
int(9)
["D"]=>
int(6)
["E"]=>
float(45)
}
}
00:07:11 Criteria
00:07:11 ALL
00:07:11 The shortest tree in the orchard
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
Deprecated: Implicit conversion from float 76.8 to int loses precision in
/home/s/sunvito/holel-sea.ru/public_html/test/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Calculation.php on line
3913
00:07:11 DMIN() Result is 8
00:07:11 Criteria
array(2) {
[1]=>
array(1) {
["A"]=>
string(4) "Tree"
}
[2]=>
array(1) {
["A"]=>
string(6) "=Apple"
}
}
00:07:11 The Youngest apple tree in the orchard
00:07:11 DMIN() Result is 9