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] Commented: (OFFICE-2031) 6.11.23 PMT

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

Andreas Guelzow  commented on OFFICE-2031:

I don't thin kwe should say  "Note that this formula can be numerically unstable at very low interest rates."  There is nothing wrong with that formula. As we have indicated in general elsewhere, all these formulas give mathematical exact definitions only, not numerical methods.

If we want to include warnings of this kind here, we have to include them everywhere were forulas may be numerically unstable.

> 6.11.23 PMT
> -----------
>                 Key: OFFICE-2031
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2031
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eric Patterson
>            Assignee: Robert Weir 
>            Priority: Minor
>             Fix For: ODF 1.2 Part 2 CD 3
> The third test case for the IPMT Function appears to have an incorrect result specified.
> Expression:
> =IPMT(5%/12;10;360;100000)+IPMT(5%/12;10;360;100000)-PMT(5%/12;360;100000)
> Result:
> 0
> Also, it contains the note: "The total payment is the principle plus the interest.", but that is not included in the normative text.

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]