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

# 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

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Mon, 3 May 2010 09:12:24 -0400 (EDT)

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

Robert Weir  updated OFFICE-1095:
---------------------------------

Proposal:
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
-