[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1106) Public Comment: ODFF:RRI function
[ http://tools.oasis-open.org/issues/browse/OFFICE-1106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andreas Guelzow updated OFFICE-1106:
-------------------------------------
Description:
Copied from office-comment list
Original author: "David King" <openoffice@drking.plus.com>
Original date: 7 Sep 2008 16:31:19 -0000
Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00011.html
1. "Summary: Returns the interest rate resulting from the profit
(return) of an investment"
That's more or less copied from Calc Help, and doesn't really
illuminate. How about:
"Returns an equivalent interest rate when an investment increases in
value."
2. Typo: N and P are both used for number of periods - need one or the
other.
3. "N is NOT truncated to an integer" - that's OK, but it might be wise
to note that for fractional N the result is slightly inaccurate, as a
partial period does not partially compound.
4. I wonder if this function should really be included in ODFF? Calc has
it, but Excel does not. It's a simple formula calculation, and you need
to understand
was:
Copied from office-comment list
Original author: "David King" <openoffice@drking.plus.com>
Original date: 7 Sep 2008 16:31:19 -0000
Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00011.html
Priority: Blocker
> Public Comment: ODFF: RRI function
> ----------------------------------
>
> Key: OFFICE-1106
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-1106
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Bug
> Components: OpenFormula
> Affects Versions: ODF 1.2
> Reporter: Robert Weir
> Assignee: Andreas Guelzow
> Priority: Blocker
> Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: "David King" <openoffice@drking.plus.com>
> Original date: 7 Sep 2008 16:31:19 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00011.html
> 1. "Summary: Returns the interest rate resulting from the profit
> (return) of an investment"
> That's more or less copied from Calc Help, and doesn't really
> illuminate. How about:
> "Returns an equivalent interest rate when an investment increases in
> value."
> 2. Typo: N and P are both used for number of periods - need one or the
> other.
> 3. "N is NOT truncated to an integer" - that's OK, but it might be wise
> to note that for fractional N the result is slightly inaccurate, as a
> partial period does not partially compound.
> 4. I wonder if this function should really be included in ODFF? Calc has
> it, but Excel does not. It's a simple formula calculation, and you need
> to understand
--
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]