[OASIS Issue Tracker] Issue Comment Edited: (OFFICE-1095) PublicComment: ODFF: AMORLINC function

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19021#action_19021 ] 

Robert Weir  edited comment on OFFICE-1095 at 5/3/10 9:12 AM:
--------------------------------------------------------------

Resolution reflects behavior of Excel and OpenOffice Calc.  We should try to find a French accountant during the public review to verify.

      was (Author: rcweir):
    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