tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{' x m>]C .t ]5:(H_} gE2H`8LS0-iog9$:f:A꫾^fpPޓ\dzkR:җ6plT_ H߅f2@Ll9Od }& &0KoJh2P!7nF!`g\ +5Hd`;R0ƭYD,\; ?DK 1`={ss:*s@‚ۄV֕aovw$$A'syw.4M&L*\Iu)Q- ["$ k|B]RW8Q,cz4L4e JcTğ*uعwacG'2YQ\ +5Hd`;R0ƭYD,\; ?2{D1 -:ʒئDV\ +5Hd`;R0ƭYD,\; ? FŖwZ*RsF۰}ib|J/n\j&rJ%+j[Ʃ(nB sm??^`!?5vaȬ? /&H&ޫ唬tOJĨ}`݈sO>s_f/Xwl)mļ%rjru7DQy>oڥ>Sgc?yx?h1랰pE;b"'Xg ] 1HL`H$־H OkWXߩ~?p kˈ RFgt3/ߐUo%l8e(FbeRHOYNv?Ox E&3?OBBOdz&EV":QO*Z"0׼Ȱ}w[Tְp!IC g#0G= _1ИNM?kxܲ\PnqPPSnja&le,'wё2a,~%-P!AO{`PL /Xض$30k]eSA7Z}o[LZ@-1B83W\U##ٖAyYTe /cnoˆv>eE>AUbt9FX2Џ:`, WsE~T?1ϸ } >vMG$YytNYp N[}ЕrEVȜ*{ ؆/}Cn_f=ml'NBUSD<XPJl|I mR C*\U1.&:N㠔UEEjS~21AGpFy S_M'E!Kێȕ+MM:ܚ}Z5=ܹ0GMܣ fX9Wݎԧ鱌Ӛ .9c\r1_Y[5h9 keRs0"]|WYҋFoN_rR0 Et%a9ys0&/֝I)ɧlZ)ᄩ;:STE~0GJİ KQ>.*@# کwK7 Qo,1f&͊ijiF^,"uiYB-L>u[+[,';\uo&?52k@>P ̾lK0+e8D_Yt=e$YV6mW]EwW׮5_6^XNvԣΐ /:,!1Qe4o tLWʃwtnۚ9QqGFBkn%}VϺs|˘Jr~ͱU_~N)/Vf;Rf71$% ifCFy S_M';ClB( ʯ9MXNy1Sna Uܝ\e2@þ\rßSR?|cح',Ue/KgVM<^Iyu*IC_[WyQ[[ SG'vm#+5e.c3B[cyK\U{ow9Nا1 u1hD]d_Czh?:DpD $V?xNr[ޠ UOӬ  I|^@jc63Jt:fWE hj&Hbٟ֫1fFecXvvRNPw 򑜭&xqZ&(Ɏf|cHIhom)lsGX PxL{]l493A?$Lcڭo~AW[VˎWxt5>>30J5S0iH٦Sn '\Eh;熺['R7ē`]PDϽ;=u,{9RjV?~@ꕯ9MXNy1Sna Uܝ\gZm坷XFi 5YG4# +ϼ=8̲ -pⶖE%w7_Q$ߟe0-"0]$SIsƣȯsL!#T̰"#=& +!#oM{S)Ѓp,4w2TPdvA/NǴ33(7,TģY"TTRv%Rc &f.|ԟC]G"1DQK$h5/:,!1Qe4o tLWʃwtnۚ9QqGFBkn%}VϺs|˘Jr~iCRl`"N/dJF[$dO#k A!ש"\:޼=\ܯ)%8Ӳ#Snc%G8-plP4yrA3Sʧ;PNSP";[w)-JNG$YCWq1^ :}؝Ղg=jyfBkI_6k@V|qM>H?Y8hh#N!1y on-folder-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Calculation_DateTime

    category PHPExcel
    package PHPExcel_Calculation
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

    DATE

    DATE(integer $year, integer $month, integer $day) : mixed
    Static

    The DATE function returns a value that represents a particular date.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: DATE(year,month,day)

    PHPExcel is a lot more forgiving than MS Excel when passing non numeric values to this function. A Month name or abbreviation (English only at this point) such as 'January' or 'Jan' will still be accepted, as will a day value with a suffix (e.g. '21st' rather than simply 21); again only English language.

    access public
    category Date/Time Functions

    Parameters

    $year

    integer

    The value of the year argument can include one to four digits. Excel interprets the year argument according to the configured date system: 1900 or 1904. If year is between 0 (zero) and 1899 (inclusive), Excel adds that value to 1900 to calculate the year. For example, DATE(108,1,2) returns January 2, 2008 (1900+108). If year is between 1900 and 9999 (inclusive), Excel uses that value as the year. For example, DATE(2008,1,2) returns January 2, 2008. If year is less than 0 or is 10000 or greater, Excel returns the #NUM! error value.

    $month

    integer

    A positive or negative integer representing the month of the year from 1 to 12 (January to December). If month is greater than 12, month adds that number of months to the first month in the year specified. For example, DATE(2008,14,2) returns the serial number representing February 2, 2009. If month is less than 1, month subtracts the magnitude of that number of months, plus 1, from the first month in the year specified. For example, DATE(2008,-3,2) returns the serial number representing September 2, 2007.

    $day

    integer

    A positive or negative integer representing the day of the month from 1 to 31. If day is greater than the number of days in the month specified, day adds that number of days to the first day in the month. For example, DATE(2008,1,35) returns the serial number representing February 4, 2008. If day is less than 1, day subtracts the magnitude that number of days, plus one, from the first day of the month specified. For example, DATE(2008,1,-15) returns the serial number representing December 16, 2007.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    DATEDIF

    DATEDIF(mixed $startDate, mixed $endDate, string $unit) : integer
    Static

    Parameters

    $startDate

    mixed

    Excel date serial value, PHP date/time stamp, PHP DateTime object or a standard date string

    $endDate

    mixed

    Excel date serial value, PHP date/time stamp, PHP DateTime object or a standard date string

    $unit

    string

    Returns

    integerInterval between the dates

    DATENOW

    DATENOW() : mixed
    Static

    Returns the current date. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date and time format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: TODAY()

    access public
    category Date/Time Functions

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    DATETIMENOW

    DATETIMENOW() : mixed
    Static

    Returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date and time format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: NOW()

    access public
    category Date/Time Functions

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    DATEVALUE

    DATEVALUE(string $dateValue) : mixed
    Static

    Returns a value that represents a particular date. Use DATEVALUE to convert a date represented by a text string to an Excel or PHP date/time stamp value.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: DATEVALUE(dateValue)

    access public
    category Date/Time Functions

    Parameters

    $dateValue

    string

    Text that represents a date in a Microsoft Excel date format. For example, "1/30/2008" or "30-Jan-2008" are text strings within quotation marks that represent dates. Using the default date system in Excel for Windows, date_text must represent a date from January 1, 1900, to December 31, 9999. Using the default date system in Excel for the Macintosh, date_text must represent a date from January 1, 1904, to December 31, 9999. DATEVALUE returns the #VALUE! error value if date_text is out of this range.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    DAYOFMONTH

    DAYOFMONTH(mixed $dateValue) : int
    Static

    Returns the day of the month, for a specified date. The day is given as an integer ranging from 1 to 31.

    Excel Function: DAY(dateValue)

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    Returns

    intDay of the month

    DAYOFWEEK

    DAYOFWEEK(mixed $dateValue, int $style) : int
    Static

    Returns the day of the week for a specified date. The day is given as an integer ranging from 0 to 7 (dependent on the requested style).

    Excel Function: WEEKDAY(dateValue[,style])

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $style

    int

    A number that determines the type of return value 1 or omitted Numbers 1 (Sunday) through 7 (Saturday). 2 Numbers 1 (Monday) through 7 (Sunday). 3 Numbers 0 (Monday) through 6 (Sunday).

    Returns

    intDay of the week value

    DAYS360

    DAYS360(mixed $startDate, mixed $endDate, boolean $method) : integer
    Static

    Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.

    Excel Function: DAYS360(startDate,endDate[,method])

    access public
    category Date/Time Functions

    Parameters

    $startDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $endDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $method

    boolean

    US or European Method FALSE or omitted: U.S. (NASD) method. If the starting date is the last day of a month, it becomes equal to the 30th of the same month. If the ending date is the last day of a month and the starting date is earlier than the 30th of a month, the ending date becomes equal to the 1st of the next month; otherwise the ending date becomes equal to the 30th of the same month. TRUE: European method. Starting dates and ending dates that occur on the 31st of a month become equal to the 30th of the same month.

    Returns

    integerNumber of days between start date and end date

    EDATE

    EDATE(mixed $dateValue, int $adjustmentMonths) : mixed
    Static

    Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

    Excel Function: EDATE(dateValue,adjustmentMonths)

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $adjustmentMonths

    int

    The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    EOMONTH

    EOMONTH(mixed $dateValue, int $adjustmentMonths) : mixed
    Static

    Returns the date value for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

    Excel Function: EOMONTH(dateValue,adjustmentMonths)

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $adjustmentMonths

    int

    The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    HOUROFDAY

    HOUROFDAY(mixed $timeValue) : int
    Static

    Returns the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).

    Excel Function: HOUR(timeValue)

    Parameters

    $timeValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard time string

    Returns

    intHour

    MINUTEOFHOUR

    MINUTEOFHOUR(mixed $timeValue) : int
    Static

    Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59.

    Excel Function: MINUTE(timeValue)

    Parameters

    $timeValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard time string

    Returns

    intMinute

    MONTHOFYEAR

    MONTHOFYEAR(mixed $dateValue) : int
    Static

    Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).

    Excel Function: MONTH(dateValue)

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    Returns

    intMonth of the year

    NETWORKDAYS

    NETWORKDAYS(mixed $startDate, mixed $endDate) : integer
    Static

    Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

    Excel Function: NETWORKDAYS(startDate,endDate[,holidays[,holiday[,...]]])

    access public
    category Date/Time Functions

    Parameters

    $startDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $endDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    Returns

    integerInterval between the dates

    SECONDOFMINUTE

    SECONDOFMINUTE(mixed $timeValue) : int
    Static

    Returns the seconds of a time value. The second is given as an integer in the range 0 (zero) to 59.

    Excel Function: SECOND(timeValue)

    Parameters

    $timeValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard time string

    Returns

    intSecond

    TIME

    TIME(integer $hour, integer $minute, integer $second) : mixed
    Static

    The TIME function returns a value that represents a particular time.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the time format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: TIME(hour,minute,second)

    access public
    category Date/Time Functions

    Parameters

    $hour

    integer

    A number from 0 (zero) to 32767 representing the hour. Any value greater than 23 will be divided by 24 and the remainder will be treated as the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM.

    $minute

    integer

    A number from 0 to 32767 representing the minute. Any value greater than 59 will be converted to hours and minutes. For example, TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.

    $second

    integer

    A number from 0 to 32767 representing the second. Any value greater than 59 will be converted to hours, minutes, and seconds. For example, TIME(0,0,2000) = TIME(0,33,22) = .023148 or 12:33:20 AM

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    TIMEVALUE

    TIMEVALUE(string $timeValue) : mixed
    Static

    Returns a value that represents a particular time. Use TIMEVALUE to convert a time represented by a text string to an Excel or PHP date/time stamp value.

    NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the time format of your regional settings. PHPExcel does not change cell formatting in this way.

    Excel Function: TIMEVALUE(timeValue)

    access public
    category Date/Time Functions

    Parameters

    $timeValue

    string

    A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time. Date information in time_text is ignored.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    WEEKOFYEAR

    WEEKOFYEAR(mixed $dateValue, boolean $method) : int
    Static

    Returns the week of the year for a specified date. The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are incorrect according to the European standard.

    Excel Function: WEEKNUM(dateValue[,style])

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $method

    boolean

    Week begins on Sunday or Monday 1 or omitted Week begins on Sunday. 2 Week begins on Monday.

    Returns

    intWeek Number

    WORKDAY

    WORKDAY(mixed $startDate, integer $endDays) : mixed
    Static

    Returns the date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

    Excel Function: WORKDAY(startDate,endDays[,holidays[,holiday[,...]]])

    access public
    category Date/Time Functions

    Parameters

    $startDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $endDays

    integer

    The number of nonweekend and nonholiday days before or after startDate. A positive value for days yields a future date; a negative value yields a past date.

    Returns

    mixedExcel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag

    YEAR

    YEAR(mixed $dateValue) : int
    Static

    Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.

    Excel Function: YEAR(dateValue)

    Parameters

    $dateValue

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    Returns

    intYear

    YEARFRAC

    YEARFRAC(mixed $startDate, mixed $endDate, integer $method) : float
    Static

    Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.

    Excel Function: YEARFRAC(startDate,endDate[,method])

    access public
    category Date/Time Functions

    Parameters

    $startDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $endDate

    mixed

    Excel date serial value (float), PHP date timestamp (integer), PHP DateTime object, or a standard date string

    $method

    integer

    Method used for the calculation 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360

    Returns

    floatfraction of the year

    _getDateValue

    _getDateValue(string $dateValue) : mixed
    Static

    Parameters

    $dateValue

    string

    Returns

    mixedExcel date/time serial value, or string if error

    Identify if a year is a leap year or not

    _isLeapYear(integer $year) : boolean
    Static

    Parameters

    $year

    integer

    The year to test

    Returns

    booleanTRUE if the year is a leap year, otherwise FALSE

    _adjustDateByMonths() 

    _adjustDateByMonths($dateValue, $adjustmentMonths) 
    Static

    Parameters

    $dateValue

    $adjustmentMonths

    Return the number of days between two dates based on a 360 day calendar

    _dateDiff360(integer $startDay, integer $startMonth, integer $startYear, integer $endDay, integer $endMonth, integer $endYear, boolean $methodUS) : integer
    Static

    Parameters

    $startDay

    integer

    Day of month of the start date

    $startMonth

    integer

    Month of the start date

    $startYear

    integer

    Year of the start date

    $endDay

    integer

    Day of month of the start date

    $endMonth

    integer

    Month of the start date

    $endYear

    integer

    Year of the start date

    $methodUS

    boolean

    Whether to use the US method or the European method of calculation

    Returns

    integerNumber of days between the start date and the end date

    _getTimeValue

    _getTimeValue(string $timeValue) : mixed
    Static

    Parameters

    $timeValue

    string

    Returns

    mixedExcel date/time serial value, or string if error