Re: [office-formula] MIRR

["Andreas J. Guelzow" <aguelzow@pyrshep.ca>]

On Wed, 2009-12-23 at 19:40 -0500, Patrick Durusau wrote:
> Andreas,
> 
> Andreas J. Guelzow wrote:
> > I'll pick this one but the same applies to most other comments of this
> > type:
> >
> > On Wed, 2009-12-23 at 11:07 -0500, Patrick Durusau wrote:
> >   
> >> MIRR lacks parameters, at least as we define them for other functions.
> >>
> >>     
> >
> > In my copy, parameters are specified:
> > MIRR( Array Values ; Number Investment ; Number ReinvestRate )
> >
> > Stating that "Values" are a bunch of values, "Investment" is the
> > investment rate and blablabla doesn't mean anything and doesn't define
> > anything either.
> >
> > This function is defined by given a specific formula (with the little
> > problem that the lower case n and upper case N should be the same). I
> > would hope that all function definitions/descriptions would look like
> > the current 5.12.28 MIRR.
> >
> >   
> Well, but my point was that rather than having the listing of parameters 
> that you object to, MIRR instead has:
> 
> > Values is a series of periodic income (positive values) and payments 
> > (negative values) at regular intervals (text and empty cells are 
> > ignored). Investment is the rate of interest of the payments (negative 
> > values); ReinvestRate is the rate of interest of the reinvestment 
> > (positive values).
> >
> It just reports them in a paragraph of prose.
>
> Personally I don't find than any more useful than listing them in the 
> other style.


I would prefer to delete those paragraphs to. Unfortunately they also
appear elsewhere, for example:

"COMBIN returns the binomial coefficient, which is the number of
different R-length sets that can be selected from N items. Since they
are sets, order in the sets is not relevant. The parameters are
truncated (using INT) before use. For example, if a jar contains five
marbles, each one a distinct color, the number of different three-marble
groups COMBIN(5;3) = 10. The result is
(formula omitted)
Note that if order is important, use PERMUT instead."

I find that completely pointless. The formula alone should suffice.
(Note that COMBIN calculates lots of other things too.)

Andreas


-- 
Andreas J. Guelzow <aguelzow@pyrshep.ca>