[AccessD] This doesn't look right

MartyConnelly martyconnelly at shaw.ca
Thu Jan 29 14:24:19 CST 2004


I know of an oil and gas company TransAlta in Calgary that lost $24 
million last summer due to an Excel spreadsheet error.
Ray Panko at University of Hawaii came up with a figure of 4% of all 
cells in Excel have logic errors ,without doing deep debugging
or using analysis tools. Errors are not unusual.

Charlotte Foust wrote:

>If they've been looking at bogus information all this time, it's hard to
>tell.  "Shoot the messenger" often prevails, but if the information is
>being used to make business decisions, would they rather make them on
>valid information or not?
>
>Charlotte Foust
>
>-----Original Message-----
>From: Steven W. Erbach [mailto:serbach at new.rr.com] 
>Sent: Thursday, January 29, 2004 9:22 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] This doesn't look right
>
>
>Charlotte,
>
>  
>
>>>HAVING includes the field being evaluated, and that has a profound 
>>>effect of the results, since you're also grouping by those fields. <<
>>>      
>>>
>
>Very succinctly explained. Thank you. This could wind up to be
>embarrassing since this app has been in operation for some time using
>the original developer's code. I just took it over at the beginning of
>the month. Will I be a savior or a stooge? The question of the day...
>
>Regards,
> 
>Steve Erbach
>Scientific Marketing
>Neenah, WI
>920-969-0504
>
>Message created with Bloomba
> 
>Disclaimer: No tree was killed in the transmission of this message.
>However, several coulombs of electrons were temporarily inconvenienced.
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada





More information about the AccessD mailing list