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: Re: [office] OFFICE-3920 VDB startPerio and endPeriod


Hi,

I am confused:

If I evaluate =vdb(20000,500,5,1.75,3.5,2,false()) in current Gnumeric, I get 5035. Regina's email below seems to say that Gnumeric yields 4873.33. That does not seem to be the case.

Andreas


On 18-10-25 03:24 PM, Regina Henschel wrote:
Hi members,

I have looked at issue 3920 for fractional startPeriod and endPeriod. I get the problem, that Gnumeric, Excel and GoogleDocs[1] calculate different from LibreOffice for the case of fractional and switch at same time. So we need to define first the algorithm before we can improve the wording.

Andreas, Alfred: Can you please explain, how the result on the sheet "with_switch" is calculated?
Written without references it is about the formula
=VDB(20000;500;5;1.75;3.5;2;FALSE()).
LibreOffice calculates result 5035, which is identic to my manually calculation on the same sheet. Others calculate result 4873.33

The results for fractional without switch (last parameter TRUE()) and for integer with switch are identical in all tested applications.

[1] https://docs.google.com/spreadsheets/d/1jNbUijAZbPyFbPOEKtNffQAJ5M8hkyrdqRPbU8mslUY/edit?usp=sharing

Kind regards
Regina


---------------------------------------------------------------------
To unsubscribe from this mail list, you must leave the OASIS TC that 
generates this mail.  Follow this link to all your TCs in OASIS at:
https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php 

--

Andreas J. Guelzow, PhD FTICA

Registrar & Director of Enrolment Services

Professor, Mathematical & Computing Sciences

Direct: +1 780 479 9290
Toll-Free: +1 866 479 5200

Concordia University of
                                        Edmonton

concordia.ab.ca


Concordia University of
                                      Edmonton Twitter Concordia University of
                                      Edmonton Instagram Concordia University of
                                      Edmonton Facebook



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