[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: xyzzy Open Formula question on VDB
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 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]