============== TEST ==============
Test name: 01simple.php

12:18:48 Create new PHPExcel object
12:18:48 Set properties
12:18:48 Add some data
12:18:48 Rename sheet
12:18:48 Write to Excel2007 format


============== TEST ==============
Test name: 02types.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Set default font
12:18:49 Add some data
12:18:49 Rename sheet
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 03formulas.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add some data
12:18:49 Rename sheet
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 04printing.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add some data
12:18:49 Set header/footer
12:18:49 Add a drawing to the header
12:18:49 Set page orientation and size
12:18:49 Rename sheet
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 05featuredemo.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add some data
12:18:49 Add comments
12:18:49 Add rich-text string
12:18:49 Merge cells
12:18:49 Protect cells
12:18:49 Set cell number formats
12:18:49 Set column widths
12:18:49 Set fonts
12:18:49 Set alignments
12:18:49 Set column borders
12:18:49 Set border colors
12:18:49 Set fills
12:18:49 Set style for header row using alternative method
12:18:49 Unprotect a cell
12:18:49 Add a hyperlink to the sheet
12:18:49 Add a drawing to the worksheet
12:18:49 Add a drawing to the worksheet
12:18:49 Add a drawing to the worksheet
12:18:49 Play around with inserting and removing rows and columns
12:18:49 Set header/footer
12:18:49 Set page orientation and size
12:18:49 Rename sheet
12:18:49 Create new Worksheet object
12:18:49 Add some data
12:18:49 Set alignments
12:18:49 Set column widths
12:18:49 Set fonts
12:18:49 Add a drawing to the worksheet
12:18:49 Set page orientation and size
12:18:49 Rename sheet
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 06largescale.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add data
12:18:49 Hide "Phone" and "fax" column
12:18:49 Set outline levels
12:18:49 Freeze panes
12:18:49 Rows to repeat at top
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 07reader.php

Please run 05featuredemo.php first.


============== TEST ==============
Test name: 08conditionalformatting.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add some data
12:18:49 Set column widths
12:18:49 Add conditional formatting
12:18:49 Set fonts
12:18:49 Set header/footer
12:18:49 Set page orientation and size
12:18:49 Rename sheet
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 09pagebreaks.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add data and breaks
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 10autofilter.php

12:18:49 Create new PHPExcel object
12:18:49 Set properties
12:18:49 Add data
12:18:49 Set title row bold
12:18:49 Set autofilter
12:18:49 Write to Excel2007 format


============== TEST ==============
Test name: 11documentsecurity.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Rename sheet
12:18:50 Set document security
12:18:50 Set sheet security
12:18:50 Write to Excel2007 format


============== TEST ==============
Test name: 12serializedfileformat.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Add comments
12:18:50 Add rich-text string
12:18:50 Merge cells
12:18:50 Protect cells
12:18:50 Set cell number formats
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Set alignments
12:18:50 Set column borders
12:18:50 Set border colors
12:18:50 Set fills
12:18:50 Set style for header row using alternative method
12:18:50 Unprotect a cell
12:18:50 Add a hyperlink to the sheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Play around with inserting and removing rows and columns
12:18:50 Set header/footer
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Create new Worksheet object
12:18:50 Add some data
12:18:50 Set alignments
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Add a drawing to the worksheet
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Write to PHPExcel Serialized format


============== TEST ==============
Test name: 13calculation.php

12:18:50 List implemented functions
Array
(
    [0] => ABS
    [1] => ACOS
    [2] => ACOSH
    [3] => ADDRESS
    [4] => AND
    [5] => ASIN
    [6] => ASINH
    [7] => ATAN
    [8] => ATAN2
    [9] => ATANH
    [10] => AVEDEV
    [11] => AVERAGE
    [12] => AVERAGEA
    [13] => BESSELI
    [14] => BESSELJ
    [15] => BESSELK
    [16] => BESSELY
    [17] => BETADIST
    [18] => BETAINV
    [19] => BIN2DEC
    [20] => BIN2HEX
    [21] => BIN2OCT
    [22] => BINOMDIST
    [23] => CEILING
    [24] => CHAR
    [25] => CHIDIST
    [26] => CHIINV
    [27] => CHOOSE
    [28] => CLEAN
    [29] => CODE
    [30] => COLUMN
    [31] => COMBIN
    [32] => COMPLEX
    [33] => CONCATENATE
    [34] => CONFIDENCE
    [35] => COS
    [36] => COSH
    [37] => COUNT
    [38] => COUNTA
    [39] => COUNTBLANK
    [40] => CRITBINOM
    [41] => DATE
    [42] => DATEDIF
    [43] => DATEVALUE
    [44] => DAY
    [45] => DAYS360
    [46] => DEC2BIN
    [47] => DEC2HEX
    [48] => DEC2OCT
    [49] => DEGREES
    [50] => DELTA
    [51] => DEVSQ
    [52] => EDATE
    [53] => EFFECT
    [54] => EOMONTH
    [55] => ERF
    [56] => ERFC
    [57] => EVEN
    [58] => EXP
    [59] => EXPONDIST
    [60] => FACT
    [61] => FACTDOUBLE
    [62] => FALSE
    [63] => FIND
    [64] => FISHER
    [65] => FISHERINV
    [66] => FLOOR
    [67] => FV
    [68] => GAMMADIST
    [69] => GAMMAINV
    [70] => GAMMALN
    [71] => GCD
    [72] => GEOMEAN
    [73] => GESTEP
    [74] => HARMEAN
    [75] => HEX2BIN
    [76] => HEX2DEC
    [77] => HEX2OCT
    [78] => HOUR
    [79] => HYPGEOMDIST
    [80] => IF
    [81] => IFERROR
    [82] => IMABS
    [83] => IMAGINARY
    [84] => IMARGUMENT
    [85] => IMCONJUGATE
    [86] => IMCOS
    [87] => IMDIV
    [88] => IMEXP
    [89] => IMLN
    [90] => IMLOG10
    [91] => IMLOG2
    [92] => IMPOWER
    [93] => IMPRODUCT
    [94] => IMREAL
    [95] => IMSIN
    [96] => IMSQRT
    [97] => IMSUB
    [98] => IMSUM
    [99] => INDEX
    [100] => INT
    [101] => ISBLANK
    [102] => ISERR
    [103] => ISERROR
    [104] => ISEVEN
    [105] => ISLOGICAL
    [106] => ISNA
    [107] => ISNONTEXT
    [108] => ISNUMBER
    [109] => ISODD
    [110] => ISTEXT
    [111] => KURT
    [112] => LARGE
    [113] => LCM
    [114] => LEFT
    [115] => LEN
    [116] => LN
    [117] => LOG
    [118] => LOG10
    [119] => LOGINV
    [120] => LOGNORMDIST
    [121] => LOOKUP
    [122] => LOWER
    [123] => MATCH
    [124] => MAX
    [125] => MAXA
    [126] => MEDIAN
    [127] => MID
    [128] => MIN
    [129] => MINA
    [130] => MINUTE
    [131] => MOD
    [132] => MODE
    [133] => MONTH
    [134] => MROUND
    [135] => MULTINOMIAL
    [136] => NA
    [137] => NEGBINOMDIST
    [138] => NETWORKDAYS
    [139] => NOMINAL
    [140] => NORMDIST
    [141] => NORMINV
    [142] => NORMSDIST
    [143] => NORMSINV
    [144] => NOT
    [145] => NOW
    [146] => NPER
    [147] => NPV
    [148] => OCT2BIN
    [149] => OCT2DEC
    [150] => OCT2HEX
    [151] => ODD
    [152] => OFFSET
    [153] => OR
    [154] => PERCENTILE
    [155] => PERMUT
    [156] => PI
    [157] => PMT
    [158] => POISSON
    [159] => POWER
    [160] => PRODUCT
    [161] => PROPER
    [162] => PV
    [163] => QUARTILE
    [164] => QUOTIENT
    [165] => RADIANS
    [166] => RAND
    [167] => RANDBETWEEN
    [168] => REPT
    [169] => RIGHT
    [170] => ROUND
    [171] => ROUNDDOWN
    [172] => ROUNDUP
    [173] => ROW
    [174] => SEARCH
    [175] => SECOND
    [176] => SERIESSUM
    [177] => SIGN
    [178] => SIN
    [179] => SINH
    [180] => SKEW
    [181] => SLN
    [182] => SMALL
    [183] => SQRT
    [184] => SQRTPI
    [185] => STANDARDIZE
    [186] => STDEV
    [187] => STDEVA
    [188] => STDEVP
    [189] => STDEVPA
    [190] => SUBTOTAL
    [191] => SUM
    [192] => SUMSQ
    [193] => SYD
    [194] => T
    [195] => TAN
    [196] => TANH
    [197] => TDIST
    [198] => TIME
    [199] => TIMEVALUE
    [200] => TINV
    [201] => TODAY
    [202] => TRIM
    [203] => TRIMMEAN
    [204] => TRUE
    [205] => TRUNC
    [206] => UPPER
    [207] => VAR
    [208] => VARA
    [209] => VARP
    [210] => VARPA
    [211] => VERSION
    [212] => VLOOKUP
    [213] => WEEKDAY
    [214] => WEEKNUM
    [215] => WEIBULL
    [216] => WORKDAY
    [217] => YEAR
    [218] => YEARFRAC
)
12:18:50 Create new PHPExcel object
12:18:50 Add some data
12:18:50 Calculated data
Value of B14 [=COUNT(B2:B12)]: 6
Value of B15 [=SUM(B2:B12)]: 42
Value of B16 [=MAX(B2:B12)]: 12
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 7
Value of B19 [=MEDIAN(B2:B12)]: 7
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 12
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 3.74165738677394
Value of B27 [=STDEVA(B2:B12)]: 4.47337804249888
Value of B28 [=STDEVP(B2:B12)]: 3.41565025531987
Value of B29 [=STDEVPA(B2:B12)]: 4.24381903478459
Value of B31 [=DEVSQ(B2:B12)]: 70
Value of B32 [=VAR(B2:B12)]: 14
Value of B33 [=VARA(B2:B12)]: 20.0111111111111
Value of B34 [=VARP(B2:B12)]: 11.6666666666667
Value of B35 [=VARPA(B2:B12)]: 18.01
Value of C14 [=COUNT(C2:C12)]: 10
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 1
Value of C18 [=AVERAGE(C2:C12)]: 3
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.05409255338946
Value of C27 [=STDEVA(C2:C12)]: 1.34839972492648
Value of C28 [=STDEVP(C2:C12)]: 1
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 10
Value of C32 [=VAR(C2:C12)]: 1.11111111111111
Value of C33 [=VARA(C2:C12)]: 1.81818181818182
Value of C34 [=VARP(C2:C12)]: 1
Value of C35 [=VARPA(C2:C12)]: 1.65289256198347
Value of B37 [=DATE(2007, 12, 21)]: 1198195200
Value of B38 [=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )]: 1
Value of B39 [=DATEVALUE("01-Feb-2006 10:06 AM")]: 1138752000
Value of B40 [=DAY( DATE(2006, 1, 2) )]: 2
Value of B41 [=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )]: 1198
12:18:50 Peak memory usage: 4 MB
12:18:50 Done.


============== TEST ==============
Test name: 14excel5.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Add comments
12:18:50 Add rich-text string
12:18:50 Merge cells
12:18:50 Protect cells
12:18:50 Set cell number formats
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Set alignments
12:18:50 Set column borders
12:18:50 Set border colors
12:18:50 Set fills
12:18:50 Set style for header row using alternative method
12:18:50 Unprotect a cell
12:18:50 Add a hyperlink to the sheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Play around with inserting and removing rows and columns
12:18:50 Set header/footer
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Create new Worksheet object
12:18:50 Add some data
12:18:50 Set alignments
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Add a drawing to the worksheet
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Write to Excel5 format


============== TEST ==============
Test name: 15datavalidation.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add data
12:18:50 Set data validation
12:18:50 Write to Excel2007 format


============== TEST ==============
Test name: 16csv.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Add comments
12:18:50 Add rich-text string
12:18:50 Merge cells
12:18:50 Protect cells
12:18:50 Set cell number formats
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Set alignments
12:18:50 Set column borders
12:18:50 Set border colors
12:18:50 Set fills
12:18:50 Set style for header row using alternative method
12:18:50 Unprotect a cell
12:18:50 Add a hyperlink to the sheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Play around with inserting and removing rows and columns
12:18:50 Set header/footer
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Create new Worksheet object
12:18:50 Add some data
12:18:50 Set alignments
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Add a drawing to the worksheet
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Write to CSV format


============== TEST ==============
Test name: 17html.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Add comments
12:18:50 Add rich-text string
12:18:50 Merge cells
12:18:50 Protect cells
12:18:50 Set cell number formats
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Set alignments
12:18:50 Set column borders
12:18:50 Set border colors
12:18:50 Set fills
12:18:50 Set style for header row using alternative method
12:18:50 Unprotect a cell
12:18:50 Add a hyperlink to the sheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Add a drawing to the worksheet
12:18:50 Play around with inserting and removing rows and columns
12:18:50 Set header/footer
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Create new Worksheet object
12:18:50 Add some data
12:18:50 Set alignments
12:18:50 Set column widths
12:18:50 Set fonts
12:18:50 Add a drawing to the worksheet
12:18:50 Set page orientation and size
12:18:50 Rename sheet
12:18:50 Write to HTML format


============== TEST ==============
Test name: 18extendedcalculation.php

12:18:50 List implemented functions
Array
(
    [0] => ABS
    [1] => ACOS
    [2] => ACOSH
    [3] => ADDRESS
    [4] => AND
    [5] => ASIN
    [6] => ASINH
    [7] => ATAN
    [8] => ATAN2
    [9] => ATANH
    [10] => AVEDEV
    [11] => AVERAGE
    [12] => AVERAGEA
    [13] => BESSELI
    [14] => BESSELJ
    [15] => BESSELK
    [16] => BESSELY
    [17] => BETADIST
    [18] => BETAINV
    [19] => BIN2DEC
    [20] => BIN2HEX
    [21] => BIN2OCT
    [22] => BINOMDIST
    [23] => CEILING
    [24] => CHAR
    [25] => CHIDIST
    [26] => CHIINV
    [27] => CHOOSE
    [28] => CLEAN
    [29] => CODE
    [30] => COLUMN
    [31] => COMBIN
    [32] => COMPLEX
    [33] => CONCATENATE
    [34] => CONFIDENCE
    [35] => COS
    [36] => COSH
    [37] => COUNT
    [38] => COUNTA
    [39] => COUNTBLANK
    [40] => CRITBINOM
    [41] => DATE
    [42] => DATEDIF
    [43] => DATEVALUE
    [44] => DAY
    [45] => DAYS360
    [46] => DEC2BIN
    [47] => DEC2HEX
    [48] => DEC2OCT
    [49] => DEGREES
    [50] => DELTA
    [51] => DEVSQ
    [52] => EDATE
    [53] => EFFECT
    [54] => EOMONTH
    [55] => ERF
    [56] => ERFC
    [57] => EVEN
    [58] => EXP
    [59] => EXPONDIST
    [60] => FACT
    [61] => FACTDOUBLE
    [62] => FALSE
    [63] => FIND
    [64] => FISHER
    [65] => FISHERINV
    [66] => FLOOR
    [67] => FV
    [68] => GAMMADIST
    [69] => GAMMAINV
    [70] => GAMMALN
    [71] => GCD
    [72] => GEOMEAN
    [73] => GESTEP
    [74] => HARMEAN
    [75] => HEX2BIN
    [76] => HEX2DEC
    [77] => HEX2OCT
    [78] => HOUR
    [79] => HYPGEOMDIST
    [80] => IF
    [81] => IFERROR
    [82] => IMABS
    [83] => IMAGINARY
    [84] => IMARGUMENT
    [85] => IMCONJUGATE
    [86] => IMCOS
    [87] => IMDIV
    [88] => IMEXP
    [89] => IMLN
    [90] => IMLOG10
    [91] => IMLOG2
    [92] => IMPOWER
    [93] => IMPRODUCT
    [94] => IMREAL
    [95] => IMSIN
    [96] => IMSQRT
    [97] => IMSUB
    [98] => IMSUM
    [99] => INDEX
    [100] => INT
    [101] => ISBLANK
    [102] => ISERR
    [103] => ISERROR
    [104] => ISEVEN
    [105] => ISLOGICAL
    [106] => ISNA
    [107] => ISNONTEXT
    [108] => ISNUMBER
    [109] => ISODD
    [110] => ISTEXT
    [111] => KURT
    [112] => LARGE
    [113] => LCM
    [114] => LEFT
    [115] => LEN
    [116] => LN
    [117] => LOG
    [118] => LOG10
    [119] => LOGINV
    [120] => LOGNORMDIST
    [121] => LOOKUP
    [122] => LOWER
    [123] => MATCH
    [124] => MAX
    [125] => MAXA
    [126] => MEDIAN
    [127] => MID
    [128] => MIN
    [129] => MINA
    [130] => MINUTE
    [131] => MOD
    [132] => MODE
    [133] => MONTH
    [134] => MROUND
    [135] => MULTINOMIAL
    [136] => NA
    [137] => NEGBINOMDIST
    [138] => NETWORKDAYS
    [139] => NOMINAL
    [140] => NORMDIST
    [141] => NORMINV
    [142] => NORMSDIST
    [143] => NORMSINV
    [144] => NOT
    [145] => NOW
    [146] => NPER
    [147] => NPV
    [148] => OCT2BIN
    [149] => OCT2DEC
    [150] => OCT2HEX
    [151] => ODD
    [152] => OFFSET
    [153] => OR
    [154] => PERCENTILE
    [155] => PERMUT
    [156] => PI
    [157] => PMT
    [158] => POISSON
    [159] => POWER
    [160] => PRODUCT
    [161] => PROPER
    [162] => PV
    [163] => QUARTILE
    [164] => QUOTIENT
    [165] => RADIANS
    [166] => RAND
    [167] => RANDBETWEEN
    [168] => REPT
    [169] => RIGHT
    [170] => ROUND
    [171] => ROUNDDOWN
    [172] => ROUNDUP
    [173] => ROW
    [174] => SEARCH
    [175] => SECOND
    [176] => SERIESSUM
    [177] => SIGN
    [178] => SIN
    [179] => SINH
    [180] => SKEW
    [181] => SLN
    [182] => SMALL
    [183] => SQRT
    [184] => SQRTPI
    [185] => STANDARDIZE
    [186] => STDEV
    [187] => STDEVA
    [188] => STDEVP
    [189] => STDEVPA
    [190] => SUBTOTAL
    [191] => SUM
    [192] => SUMSQ
    [193] => SYD
    [194] => T
    [195] => TAN
    [196] => TANH
    [197] => TDIST
    [198] => TIME
    [199] => TIMEVALUE
    [200] => TINV
    [201] => TODAY
    [202] => TRIM
    [203] => TRIMMEAN
    [204] => TRUE
    [205] => TRUNC
    [206] => UPPER
    [207] => VAR
    [208] => VARA
    [209] => VARP
    [210] => VARPA
    [211] => VERSION
    [212] => VLOOKUP
    [213] => WEEKDAY
    [214] => WEEKNUM
    [215] => WEIBULL
    [216] => WORKDAY
    [217] => YEAR
    [218] => YEARFRAC
)
12:18:50 Create new PHPExcel object
12:18:50 Add some data
12:18:50 Calculated data
Value of B14 [=COUNT(B2:B12)]: 6
Value of B15 [=SUM(B2:B12)]: 42
Value of B16 [=MAX(B2:B12)]: 12
Value of B17 [=MIN(B2:B12)]: 2
Value of B18 [=AVERAGE(B2:B12)]: 7
Value of B19 [=MEDIAN(B2:B12)]: 7
Value of B20 [=MODE(B2:B12)]: #N/A
Value of B22 [=COUNTA(B2:B12)]: 10
Value of B23 [=MAXA(B2:B12)]: 12
Value of B24 [=MINA(B2:B12)]: 0
Value of B26 [=STDEV(B2:B12)]: 3.74165738677394
Value of B27 [=STDEVA(B2:B12)]: 4.47337804249888
Value of B28 [=STDEVP(B2:B12)]: 3.41565025531987
Value of B29 [=STDEVPA(B2:B12)]: 4.24381903478459
Value of B31 [=DEVSQ(B2:B12)]: 70
Value of B32 [=VAR(B2:B12)]: 14
Value of B33 [=VARA(B2:B12)]: 20.0111111111111
Value of B34 [=VARP(B2:B12)]: 11.6666666666667
Value of B35 [=VARPA(B2:B12)]: 18.01
Value of C14 [=COUNT(C2:C12)]: 10
Value of C15 [=SUM(C2:C12)]: 30
Value of C16 [=MAX(C2:C12)]: 4
Value of C17 [=MIN(C2:C12)]: 1
Value of C18 [=AVERAGE(C2:C12)]: 3
Value of C19 [=MEDIAN(C2:C12)]: 3
Value of C20 [=MODE(C2:C12)]: 4
Value of C22 [=COUNTA(C2:C12)]: 11
Value of C23 [=MAXA(C2:C12)]: 4
Value of C24 [=MINA(C2:C12)]: 0
Value of C26 [=STDEV(C2:C12)]: 1.05409255338946
Value of C27 [=STDEVA(C2:C12)]: 1.34839972492648
Value of C28 [=STDEVP(C2:C12)]: 1
Value of C29 [=STDEVPA(C2:C12)]: 1.28564869306645
Value of C31 [=DEVSQ(C2:C12)]: 10
Value of C32 [=VAR(C2:C12)]: 1.11111111111111
Value of C33 [=VARA(C2:C12)]: 1.81818181818182
Value of C34 [=VARP(C2:C12)]: 1
Value of C35 [=VARPA(C2:C12)]: 1.65289256198347
12:18:50 Peak memory usage: 4 MB
12:18:50 Done.


============== TEST ==============
Test name: 19namedrange.php

12:18:50 Create new PHPExcel object
12:18:50 Set properties
12:18:50 Add some data
12:18:50 Define named ranges
12:18:50 Rename named ranges
12:18:50 Rename sheet
12:18:50 Create new Worksheet object
12:18:50 Add some data
12:18:50 Resolve range
Cell B1 {=PersonFN}: Maarten
Cell B3 {=PersonFN & " " & PersonLN}: Maarten Balliauw
Cell Person!B1: Maarten
12:18:50 Rename sheet
12:18:50 Write to Excel2007 format


============== TEST ==============
Test name: 20readexcel5.php

Please run 14excel5.php first.


============== TEST ==============
Test name: 21pdf.php

12:18:51 Create new PHPExcel object
12:18:51 Set properties
12:18:51 Add some data
12:18:51 Add comments
12:18:51 Add rich-text string
12:18:51 Merge cells
12:18:51 Protect cells
12:18:51 Set cell number formats
12:18:51 Set column widths
12:18:51 Set fonts
12:18:51 Set alignments
12:18:51 Set column borders
12:18:51 Set border colors
12:18:51 Set fills
12:18:51 Set style for header row using alternative method
12:18:51 Unprotect a cell
12:18:51 Add a hyperlink to the sheet
12:18:51 Add a drawing to the worksheet
12:18:51 Add a drawing to the worksheet
12:18:51 Add a drawing to the worksheet
12:18:51 Play around with inserting and removing rows and columns
12:18:51 Set header/footer
12:18:51 Set page orientation and size
12:18:51 Rename sheet
12:18:51 Create new Worksheet object
12:18:51 Add some data
12:18:51 Set alignments
12:18:51 Set column widths
12:18:51 Set fonts
12:18:51 Add a drawing to the worksheet
12:18:51 Set page orientation and size
12:18:51 Rename sheet
12:18:51 Write to PDF format


============== TEST ==============
Test name: 22heavilyformatted.php

12:18:51 Create new PHPExcel object
12:18:51 Set properties
12:18:51 Add some data
12:18:51 Write to Excel2007 format


============== TEST ==============
Test name: 23sharedstyles.php

12:18:51 Create new PHPExcel object
12:18:51 Set properties
12:18:51 Add some data
12:18:51 Write to Excel2007 format


============== TEST ==============
Test name: 24readfilter.php

Please run 06largescale.php first.