RE: excel

Pete,

You give me the opportunity to explain that you could do all of this
directly in Info/WorkPlace (IWP), the Mapics report writer.  It is easy to
start from a date, either entered or the current date, and calculate a set
of dates for future weeks using standard IWP date functions.  These dates
can then be used as the basis of a "Matrix" style report that simplifies the
summarization and bucketing of your sales data.  The final output can be an
Excel spreadsheet that contains exactly the information you want.

With the data transfer you are trying to do, you will get detail records and
have to use Excel to calculate the totals and spread it to the weeks -
probably not too difficult but a bit of work.  With IWP, the capabilities
are built in and the report can be presented in an already summarized
format.

Momentum is the developer of Info/WorkPlace, JacanaForms and Jacana
inTuator.

Regards,
-Greg

Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
 
Making Information Work for your Business
www.intuator.com



-----Original Message-----
From: Pete Olshavsky [mailto:polshavsky@xxxxxxxxx] 
Sent: Monday, May 03, 2004 1:32 PM
To: mapics-l@xxxxxxxxxxxx
Subject: excel


Happy Monday Group. 
Not sure there is an easy or simple answer.
Has anyone figured out in EXCEL the transfer from AS/400??? (Client Access
express 5.1).. 
Is there good documentation with examples anywhere????? I am not very
skilled with excel.. Which is probably issue one.
What I am trying to do, is create an excel spreadsheet with data I generated
on the as400 via a pgm that will get run once a week.  I would then like the
user to click an icon, and the data would get transfered / replaced to a
spreadsheet that was created and saved. And retain all the changes that I
have setup in the spreadsheet. 
 
                                    inp dte+7  +7            +7
 COMNO   Input date     99/99/99    99/99/99   99/99/99   <---     HEADINGs
  01           05/03/04       dollrs          dollars     dollrs       <---
Data from 400
The Input date fld would be used to calc the date that is 7 days, then 7
more days, then 7 more days, etc.

                
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs