OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Updated: (OFFICE-1095) Public Comment: ODFF:AMORLINC function

     [ http://tools.oasis-open.org/issues/browse/OFFICE-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-1095:

In summary of function add "(l'amortissement linéaire comptable)" after "using linear depreciation".

In Semantics, replace "The period if interest" with "which period the depreciation should be calculated for"

Replace "The type of day-count basis to use" with "Indicates the day count basis to use;"

The text describing the formulas is also confusion.  We currently say "For the first period in the life time...".  That should really say, "When period = 0...", since the first period is 0, not 1.

Then we should say, "For full periods, where period >0, the depreciation is cost*rate" (we have that formula)

Then we should say, "For the last period, possibly a partial period, the depreciation = cost-salvage-accumulated-depreciation, where accumulated-depreciation is the sum of the depreciation in period 0 plus any full period depreciations.

Also, "When period > depreciated life of the asset, i.e., when period > (cost-salvage)/(cost*rate) then the depreciation is 0."

And finally, "Note: The behavior of this function is implementation-defined in cases where purchaseDate = firstPeriodEndDate  "

[Rob's note, this reflects current discrepancy between Excel and OpenOffice.  If we can resolve that we can remove the implementation-defined note.  But I think we need to find a French accountant first".

> Public Comment: ODFF: AMORLINC function
> ---------------------------------------
>                 Key: OFFICE-1095
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1095
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Robert Weir 
>            Assignee: Robert Weir 
>            Priority: Blocker
>             Fix For: ODF 1.2 Part 2 CD 3
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com> 
> Original date: 1 Sep 2008 20:27:21 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00000.html

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]