If I were doing the project, I would import it into a foxpro database, remove the headers (delete the first 7 records), then generate the individual worksheets with foxpro. If he wants to email them, you can have foxpro email them too.
I agree with you, I would create a webpage to do online editing, but sometimes customers have it in their mind only to do it one way. --- On Sun, 4/12/09, MB Software Solutions General Account <[email protected]> wrote: > From: MB Software Solutions General Account > <[email protected]> > Subject: Spreadsheet project > To: "ProFox Email List" <[email protected]> > Date: Sunday, April 12, 2009, 10:12 PM > (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. > _______________________________________________ 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.
