Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2001
    Location
    Bellevue, Nebraska, USA
    Posts
    569
    Thanks
    0
    Thanked 1 Time in 1 Post

    PC Mag responsible for RAND Fix! (2003)

    Just thought Woody, Peter, and the rest of you would be happy to know that, according to the April 6, 2004 issue of PC Magazine, Vol 23, Number 6, PC Mag brought the RAND bug to the addtion of Microsoft, based on a reader's input to the magazine in December.

    That's pretty tricky since I have a copy of Woody's Office Watch, Vol 1, Number 11, (note the 11 means November) that spells the whole issue out.

    I used to really like PC Mag and other Ziff Davis pubs - unfortunately, they seem to have really gone downhill in the last year or so.
    Bill (AFE7Ret)
    Freedom is NOT Free!
    Heat is the bane of all electronics!

    ─────────────────────

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PC Mag responsible for RAND Fix! (2003)

    PC Mag has become not so useful, tho the 6 April issue has a useful aticle comparing services for paid PC support.
    Lots of users should use one of those services.

    Alas, the KB article referenced regarding Rand indicates that there is no download, rather one would have to call MSFT and beg for he fix, or wait until the next Office update hat includes th eallegedly tested patch.

    Worse is the way MSFT words the KB article to try to cover up the shortcomings in their implementations of Rand in earler versions.

    MSFT has been, at best, irresponsible in the implementation of the math/statistical functions in Excel.
    At DEC, we had several numerical analysts on staff and, as needed, hired consultants.
    The crap implementations from MSFT implies that they do not do the same.

    An effective software design and quality assurance process can easily eliminate such problems.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: PC Mag responsible for RAND Fix! (2003)

    I can't disagree about squirrely wording: <!mskb=833618>Microsoft Knowledge Base Article 833618<!/mskb> Especially:

    "A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article"

    ... after MS lists 3 KB problems and 11 not-previously-documented problems, several of which would apply to most users!
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PC Mag responsible for RAND Fix! (2003)

    MSFT, like most companies, refuse to admit fault and cost users much.

    The mealy mouthed wording in a number of important KB articles cost users quite a bit.

    Anyone doing serious math/statistics in Excel should not rely on Excel's built-in crap.
    Fixing math/stat stuff is trivial, compared with fixing typical software problems, as there are NO side effects.

    It is an all to common practice in software vendors to NOT fix some problems because thgey do not want to break INCORRECT user code.
    It's been this way for 40+ years.

    With math/stat functions, as there are NO side effects, it would be easy to provide an option to use the previous (incorrect) behavior.
    There's just no excuse.

    At DEC we had full time numerical analysts on staff and hired consultants, surely MSFT could do the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •