Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2031

5.12.37 PMT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      As Eric noted, the function should return -287.35 for that test case. However, we're stripping out test cases, so that change is note needed

      However, we do need to change the line "Note that the formula may be numerically unstable at very low rates." This is good English, but bad ISO. "May" should be used exclusively "to indicate a course of action permissible within the limits of the document." We are not giving permission to be numerically unstable, but just noting that it is possible. In that case, the proper ISO term to use is "can", which is used for " statements of possibility and capability, whether material, physical or causal." So we should say, "Note that this formula can be numerically unstable at very low interest rates."

      Show
      As Eric noted, the function should return -287.35 for that test case. However, we're stripping out test cases, so that change is note needed However, we do need to change the line "Note that the formula may be numerically unstable at very low rates." This is good English, but bad ISO. "May" should be used exclusively "to indicate a course of action permissible within the limits of the document." We are not giving permission to be numerically unstable, but just noting that it is possible. In that case, the proper ISO term to use is "can", which is used for " statements of possibility and capability, whether material, physical or causal." So we should say, "Note that this formula can be numerically unstable at very low interest rates."
    • Resolution:
      Hide

      Deleted that test case in IPMT (not PMT), the comment apparently was meant for the (wrong) result 0 and doesn't match the test case. The test case is useless.
      Corrected first test case in IPMT from =IPMT(5%;/12;10;360;100000) to =IPMT(5%/12;10;360;100000)
      Deleted "Note that the formula may be numerically unstable at very low rates." from PMT.

      Show
      Deleted that test case in IPMT (not PMT), the comment apparently was meant for the (wrong) result 0 and doesn't match the test case. The test case is useless. Corrected first test case in IPMT from =IPMT(5%;/12;10;360;100000) to =IPMT(5%/12;10;360;100000) Deleted "Note that the formula may be numerically unstable at very low rates." from PMT.

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              rcweir Robert Weir (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: