RE: AS400 file with formulas into Excel

I disagree, I think there is value in having the formula in there:

1) It can act as a default value that might be ok 90% of the time, and the
user can change manually the other 10% of the time
2) Depending on the data it might be ok for the user to insert rows, the
excel formula will handle this gracefully, the pre-computed value will not.

Regards

Neill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Evan Harris
Sent: 09 July 2009 00:08
To: 'Midrange Systems Technical Discussion'
Subject: RE: AS400 file with formulas into Excel

I agree with Sharon.

If they are going to "use the formula" (by this I presume you mean the
result of the calc) then having the actual value in there makes no
difference.

If they are going to alter the formula then what's the value of you putting
it in for them ? They may as well add it themselves and get what they want.

Regards
Evan Harris


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Wilson
Sent: Thursday, 9 July 2009 8:16 a.m.
To: Midrange Systems Technical Discussion
Subject: Re: AS400 file with formulas into Excel

Because the users will want to use or alter that formula.



________________________________
From: "Wintermute, Sharon" <Sharon.Wintermute@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, July 8, 2009 3:51:47 PM
Subject: RE: AS400 file with formulas into Excel


Why not do the calc in sequel and let it go?

Sharon Wintermute