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: xyzzy Open Formula question on VDB

• From: Patrick Durusau <patrick@durusau.net>
• To: dwheeler@dwheeler.com, ODF TC List <office@lists.oasis-open.org>
• Date: Mon, 13 Nov 2017 13:20:35 -0500

```Dave,

Sorry for the long silence! An interesting question has come up about:

*****

VDB

Summary: Calculates the depreciation allowance of an asset with an
initial value, an expected
useful life, and a final value of salvage for a period specified, using
the variable-rate declining
balance method..

Syntax: VDB( Number cost ; Number salvage ; Number lifeTime ; Number
startPeriod ; Number
endPeriod [ ; Number depreciationFactor = 2 [ ; Logical noSwitch =
FALSE() ] ] )

*****

In the prose, there is a paragraph that reads:

*****

VDB allows for the use of an initialPeriod option to calculate
depreciation for the period the asset
is placed in service. VDB uses the fractional part of startPeriod and
endPeriod to determine the
initialPeriod option. If both startPeriod and endPeriod have fractional
parts, then VDB uses the
fractional part of startPeriod.

*****

The initial issue was with the final sentence:

*****

If both startPeriod and endPeriod have fractional parts, then VDB uses the
fractional part of startPeriod.

*****

b/c that makes no sense and it isn't how LO has implemented VDB.
https://issues.oasis-open.org/browse/OFFICE-3920

When discussing the issue, several of us noticed that initialPeriod is
used twice but with no definition.

I suspect it means a startPeriod > 0 but that's a guess on my part.

InitialPeriod does not appear in the function signature and appears to
be the same text from Lotus documentation:

ftp://ftp.boulder.ibm.com/software/lotus/desktop/LotusDoc/10381.txt

Questions:

1) Does initialPeriod simply mean startPeriod > 0?

2) To confirm, VDB should use both fractional parts in its calculation. Yes?

Please respond to the comment list for IP purposes,
office-comment@lists.oasis-open.org.

Thanks!

Hope you are looking forward to a great holiday season!

Patrick

--
Patrick Durusau
patrick@durusau.net
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net