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

Tina Norris Fields tinanfields at torchlake.com
Thu Dec 22 12:26:48 CST 2011


ABSOLUTELY!!!  John is right on!
T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787


On 12/22/2011 12:31 PM, jwcolby wrote:
> 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.
>>
>>
>>
>



More information about the AccessD mailing list