(VFP9SP2)
Prospective client wants me to take excel output from an American
Express data export and parse out the rows by employee so that each
employee has his own spreadsheet and the charge categories are columns
in the output. Requirement is that each employee see only his charges,
and then employee must do cost accounting -- labeling each row to a job
# or client of theirs so the CFO can see where all the money is going.
The Excel output has this format:
Detailed Spending Report
The Business Platinum Card® - 91003
All Merchants
Jan - Feb 2009
Cardholder Name Process Date Merchant Category Subcategory Merchant
Name/Location Amount
SMITH, MIKE - 93041 01/02/2009 Materials, Supplies & Equipment
Wholesale
Discount Stores EMERSON ELECTRIC CO.EDEN PRAIRIE MN $859.86
SMITH, MIKE - 93041 01/02/2009 Other Other RESERVATIONREWARDS
NORWALK
CT $10.00
He'd then like to send the spreadsheets to each of the guys to fill out
after I've parsed them by employee, and then each employee would do that
cost accounting and email them back to him. To me, that's more work
than it needs to be. Imo, why don't I just create a few screens to
allow the parsing, each guy to do his cost accounting--all within the
same database via the screens, and then the CFO could poll the data at
will to see the results, rather than having to take each guy's
spreadsheet and review them, no doubt incorporating their inputs back
into some master spreadsheet?? But, I think if I pitch that, he may
feel overwhelmed. There's not a lot of tech savvy at this company.
They have no IT person. I'm hoping to fill the role part-time.
Back to my original reason for posting this: It's obviously very easy
if I could extract the bulk of data without the first 7 header rows,
given that the core output is in this format. Suggestions for achieving
this?
tia!
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
twitter: mbabcock16
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
