Re: [office-formula] office-2246

From
Andreas J. Guelzow <>
Date
2010-01-06T04:38:30+00:00
ID
1262752681.3907.3.camel@localhost
Thread
Re: [office-formula] office-2246
On Tue, 2010-01-05 at 20:28 -0500, Patrick Durusau wrote:
> Andreas,
> 
> Thanks!
> 
> One question:
> 
> Under constraints it reads:
> 
> >    *
> >
> >       The sum of the probabilities in /Probability/ must equal 1.
> >
> Err, isn't the sum going to depend on rounding errors?
> 
> That is to say the sum of the probabilities must not exceed 1.
> 
> Yes?
> 
> Thinking that equaling exactly one may be a test that some evaluators 
> may not be able to meet.


Well, both Openoffice and Gnumeric require equality (probably subject to
some plus/minus epsilon). We could say that SUM(/Probability/) = 1 must
evaluate to true.

We definitely can't change it to "must not exceed 1" if we want to
encode what current spreadsheet applications do.

Andreas



> 
> Hope you are having a great evening!
> 
> Patrick
> 
> PS: Signing off for the night.
> 
> Andreas J. Guelzow wrote:
> > I am attaching an odf file containing a proposed adjustment to the
> > description of PROB.
> >
> > I could not discover any reasonable way of attaching this tot eh IORA
> > issue directly (and needed some math formatting).
> >
> > Andreas
> >   
> > ------------------------------------------------------------------------
> >
> > ---------------------------------------------------------------------
> > 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 <>