[AccessD] My Excel project...you won't believe this one

BACKUP the original!!!  You need to be able to prove that the old sucked and the new... sucks 
less... (you can only fix what you find).

Then you need to start a document of each thing like this that you find.  It will provide a huge 
evidence base for when you present the case for "your application sucks and this is why it takes so 
long to get it working".

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 12/22/2011 12:02 PM, Mark Simms wrote:
> Instead of using the number format to properly display the numbers,
> the original developer would use the Format function to round a large series
> of individual values,
>   and then total-up the rounded results instead of the original values.
> As you are aware, precision is likely lost in doing it this way.
> Ex: .55+.55=1.1
> His method would be to first "round-up" the .55 to .6:
> Ex: .6+.6=1.2
> In this case, the total is now "off" by almost 10% !
>
> And...this is a vital model that helps to run the company's main processing
> unit.
>
> Wowzer indeed.
>
>
>