SLOPE.php 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  1. <?php
  2. use PhpOffice\PhpSpreadsheet\Shared\Date;
  3. return [
  4. [
  5. 0.6,
  6. [3, 6, 9, 12],
  7. [5, 10, 15, 20],
  8. ],
  9. [
  10. 1.0,
  11. [1, 2, 3, 4],
  12. [10, 11, 12, 13],
  13. ],
  14. [
  15. 0.2,
  16. [2, 4, 6],
  17. [10, 20, 30],
  18. ],
  19. [
  20. 4.628571428571,
  21. [3, 7, 17, 20, 20, 27],
  22. [1, 2, 3, 4, 5, 6],
  23. ],
  24. [
  25. 9.472222222222,
  26. [
  27. Date::stringToExcel('1900-02-01'),
  28. Date::stringToExcel('1900-03-01'),
  29. Date::stringToExcel('1900-09-01'),
  30. Date::stringToExcel('1900-01-01'),
  31. Date::stringToExcel('1900-08-01'),
  32. Date::stringToExcel('1900-07-01'),
  33. Date::stringToExcel('1900-05-01'),
  34. ],
  35. [
  36. 6,
  37. 5,
  38. 11,
  39. 7,
  40. 5,
  41. 4,
  42. 4,
  43. ],
  44. ],
  45. [
  46. 0.305555555556,
  47. [
  48. Date::stringToExcel('1900-01-02'),
  49. Date::stringToExcel('1900-01-03'),
  50. Date::stringToExcel('1900-01-09'),
  51. Date::stringToExcel('1900-01-01'),
  52. Date::stringToExcel('1900-01-08'),
  53. Date::stringToExcel('1900-01-07'),
  54. Date::stringToExcel('1900-01-05'),
  55. ],
  56. [
  57. 6,
  58. 5,
  59. 11,
  60. 7,
  61. 5,
  62. 4,
  63. 4,
  64. ],
  65. ],
  66. [
  67. '#N/A',
  68. [1, 2, 3],
  69. [4, 5],
  70. ],
  71. [
  72. '#DIV/0!',
  73. [1, 2, 3],
  74. [4, null, null],
  75. ],
  76. ];