On Sun, Apr 12, 2009 at 9:12 PM, MB Software Solutions General Account <mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > (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. -------------------------
I think that AE offers a webservice to get you the data. I remember someone telling me about doing this before. I think that 40 hrs is light for the initial estimate. But then you are just collecting the initial data, and not warning the peeps that checks will be cut. And then taking those charges and posting them against the various clients open bill so they are passed on if applicable. This was a consulting firm and just about everything on the AE bill was billable back to clients. It was not for the sales and marketing group. So if you failed to bill your expenses you were NOT paid for them. > 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 > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/c4313dbe0904131203i6f770c14k37a597c9015b2...@mail.gmail.com ** 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.
