PHPSpreadsheet

Autofilter
- 10 Autofilter
- 10 Autofilter dynamic dates
- 10 Autofilter selection 1
- 10 Autofilter selection 2
- 10 Autofilter selection display
Basic
- 01 Simple
- 01 Simple download ods
- 01 Simple download pdf
- 01 Simple download xls
- 01 Simple download xlsx
- 02 Types
- 03 Formulas
- 04 Printing
- 05 Feature demo
- 05 UnexpectedCharacters
- 06 Largescale
- 07 Reader
- 08 Conditional formatting
- 08 Conditional formatting 2
- 09 Pagebreaks
Basic1
- 11 Documentsecurity
- 12 CellProtection
- 13 Calculation
- 13 CalculationCyclicFormulae
- 14 Xls
- 15 Datavalidation
- 16 Csv
- 17 Html
- 17a Html
- 17b Html
- 18 Extendedcalculation
- 19 Namedrange
Basic2
- 20 Read Excel2003XML
- 20 Read Gnumeric
- 20 Read Ods
- 20 Read Sylk
- 20 Read Xls
- 22 Heavily formatted
- 23 Sharedstyles
- 24 Readfilter
- 25 In memory image
- 26 Utf8
- 27 Images Html Pdf
- 27 Images Xls
- 27 Images Xlsx
- 28 Iterator
- 29 Advanced value binder
Basic3
- 30 Template
- 30 Templatebiff5
- 31 Document properties write
- 31 Document properties write xls
- 37 Page layout view
- 38 Clone worksheet
- 39 Dropdown
Basic4
- 40 Duplicate style
- 41 Password
- 42 RichText
- 42b RichText
- 43 Merge workbooks
- 44 Worksheet info
- 45 Quadratic equation solver
- 46 ReadHtml
- 47 xlsfill
- 47 xlsxfill
- 48 Image move size with cells
- 49 alignment
- 50 xlsverticalbreak
- 51 ProtectedSort
- 52 Currency
- 53 ImageOpacity
Bitwise
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
Chart
- 32 Chart read write
- 32 Chart read write HTML
- 32 Chart read write PDF
- 34 Chart update
- 37 Chart dynamic title
Chart33a
- 33 Chart create area
- 33 Chart create area 2
- 33 Chart create bar
- 33 Chart create bar custom colors
- 33 Chart create bar labels lines
- 33 Chart create bar stacked
- 33 Chart create bubble
- 33 Chart create column
- 33 Chart create column 2
- 33 Chart create composite.alternate
- 33 Chart create composite
- 33 Chart create line
- 33 Chart create line dateaxis
Chart33b
- 33 Chart create multiple charts
- 33 Chart create pie
- 33 Chart create pie custom colors
- 33 Chart create radar
- 33 Chart create scatter
- 33 Chart create scatter2
- 33 Chart create scatter3
- 33 Chart create scatter4
- 33 Chart create scatter5 trendlines
- 33 Chart create scatter6 value xaxis
- 33 Chart create scatter7 blanks
- 33 Chart create stock
- 33 Chart create stock2
ComplexNumbers1
- COMPLEX
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMREAL
ComplexNumbers2
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
ComplexNumbers3
- IMPOWER
- IMPRODUCT
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
ConditionalFormatting
- 01 Basic Comparisons
- 02 Text Comparisons
- 03 Blank Comparisons
- 04 Error Comparisons
- 05 Date Comparisons
- 06 Duplicate Comparisons
- 07 Expression Comparisons
- cond08 colorscale
- cond09 iconset
Database
- DAVERAGE
- DCOUNT
- DCOUNTA
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
DateTime
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DAYS
- DAYS360
- EDATE
- EOMONTH
- HOUR
- ISOWEEKNUM
- MINUTE
- MONTH
DateTime2
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
DefinedNames
- AbsoluteNamedRange
- CrossWorksheetNamedFormula
- NamedFormulaeAndRanges
- RelativeNamedRange
- RelativeNamedRange2
- RelativeNamedRangeAsFunction
- ScopedNamedRange
- ScopedNamedRange2
- SimpleNamedFormula
- SimpleNamedRange
Engineering
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- CONVERT
- Convert-Online
- DELTA
- ERF
- ERFC
- GESTEP
Financial1
- ACCRINT
- ACCRINTM
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CUMIPMT
- CUMPRINC
Financial2
- DB
- DDB
- DISC
- DOLLARDE
- DOLLARFR
- EFFECT
- FV
- FVSCHEDULE
Financial3
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
HexEtcConversions
- BIN2DEC
- BIN2HEX
- BIN2OCT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- HEX2BIN
- HEX2DEC
- HEX2OCT
- OCT2BIN
- OCT2DEC
- OCT2HEX
Html
- html 01 Basic Conditional Formatting
- html 02 More Conditional Formatting
- html 03 Color Scale
- html 04 Table Format without Conditional
- html 05 Table Format with Conditional
LookupRef
- ADDRESS
- COLUMN
- COLUMNS
- INDEX
- INDIRECT
- OFFSET
- ROW
- ROWS
- VLOOKUP
Pdf
- 21 Pdf Domdf
- 21 Pdf TCPDF
- 21 Pdf mPDF
- 21a Pdf
- 21b Pdf
- 21c Pdf
- 21d FitToHeightPdf
- 21e UnusualFont mpdf
- 21f Drawing
- 21g Direction
- 21h DirectionMultiple
- Mpdf2
Reader
- 01 Simple file reader using IOFactory
- 02 Simple file reader using a specified reader
- 03 Simple file reader using the IOFactory to return a reader
- 04 Simple file reader using the IOFactory to identify a reader to use
- 05 Simple file reader using the read data only option
- 06 Simple file reader loading all worksheets
- 07 Simple file reader loading a single named worksheet
- 08 Simple file reader loading several named worksheets
- 09 Simple file reader using a read filter
- 10 Simple file reader using a configurable read filter
- 11 Reading a workbook in chunks using a configurable read filter (version 1)
- 12 Reading a workbook in chunks using a configurable read filter (version 2)
Reader2
- 13 Simple file reader for multiple CSV files
- 14 Reading a large CSV file in chunks to split across multiple worksheets
- 15 Simple file reader for tab separated value file using the Advanced Value Binder
- 16 Handling loader exceptions using TryCatch
- 17 Simple file reader loading several named worksheets
- 18 Reading list of worksheets without loading entire file
- 19 Reading worksheet information without loading entire file
- 20 Reader worksheet hyperlink image
- 21 Reader CSV Long Integers with String Value Binder
- 22 Reader formscomments
- 22 Reader issue1767
- 23 iterateRowsYield
Reading workbook data
- Custom properties
- Custom property names
- Properties
- Worksheet count and names
Table
- 01 Table
- 02 Table Total
- 03 Column Formula
- 04 Column Formula with Totals
Wizards/NumberFormat
- Accounting
- Currency
- Number
- Percentage
- Scientific

AMORDEGRC

Returns the prorated linear depreciation of an asset for a specified accounting period.
=AMORDEGRC(B1, B2, B3, B4, B5, B6, B7)
AMORDEGRC() Result is $42.00