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


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



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.

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:



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,


Hope you are looking forward to a great holiday season!


Patrick Durusau
Technical Advisory Board, OASIS (TAB)
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
Twitter: patrickDurusau 

Attachment: signature.asc
Description: OpenPGP digital signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]