Show Bid Request Need an excel macro Bid Request Id: 43927 Bookmark in my 'To Do' list Posted by: JTIDev (5 ratings) (Software buyer rating 9.8) Non-action Ratio: Above Average - 25.00% Buyer Security Verifications: Excellent Approved on: Jan 16, 2003 10:27:48 AM EDT Bidding Closes: Jan 21, 2003 10:29:57 AM EDT Viewed (by coders): 119 times Deadline: 1/30/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Documentation / Tech Writing, Visual Basic, Other, Other DB Enter chat room for this bid request (0 active users at Jul 10, 2003 1:53:33 PM EDT) Description: I need a an excel (2000) macro developed to do the following: 1. Bring up a file/open dialog box and let me select a tab separated file (see report.txt). 2. Macro should make the detail data look prity. 3. Macro should plot a pie chart using the summary information provided in the tab delimited file. 4. Macro should save the tab delimited file in xls format. Details about the report. Report (see attached file report.txt) has three parts. a. Header: Consists of first 12 rows. b. Detail: Each detail record contains 5 rows and variable number of columns, because this is a cross-tab report. c. Summary: Summary always starts with the following heading, "STATISTICS FOR REPORTED MESSAGES:". Summary may contain many rows of data. Summary ends with literal, "--END--", which also marks the end of this report. Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Platform: Excel 2000 Must be 100% finished and received by buyer on: Jan 30, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 474,995   $100 (USD) Jan 16, 2003 10:54:02 AM EDT  9.47 (Superb)     Hello, My name is John Morgan and I have been an Application Developer for almost 10 years, working 6+ years for a Fortune 500 financial organization and the past 3+ have been spent consulting for such companies as Aramark, Aetna, Computer Sciences Corporation and Towers Perrin. I have read your request and looked you your attachment and would like to work with you on this project. I have been working with VB and VBA for the past 8 years and my last rentacoder project involved a similar task, processing a text file and formatting it nicely in Excel. I have attached a copy of the text file as well as the output for your review. Simply save both files to a folder and when you open the excel file, simply change the path on the Main Form and click on Load Reports. The user didn't want a fancy Interface so that is why it is pretty basic. Anyway, I am ready to begin immediately, so let me know if you are interested. John Attached File           See 1 private reply(ies) to/from jsmorgan24.   jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 475,335   N/A Jan 16, 2003 2:33:29 PM EDT  9.47 (Superb)     Hello, Thanks for responding. If my bid is accepted, I would like to talk with you a little more about what you want, but the program itself will be done by Monday. John jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 475,404   N/A Jan 16, 2003 2:59:12 PM EDT  9.47 (Superb)     Hello again, If you can take the first 2 or three reports on the attachment and enter it on a spreadsheet the way you would like to see it, it would expedite the process and allow me to get started immediately. John           See 1 private reply(ies) to/from jsmorgan24.   jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 475,458   N/A Jan 16, 2003 3:33:22 PM EDT  9.47 (Superb)     Hello again, Just curious as to when you are expecting to make a final decision on your program? I would really like to work with you as VBA is my specialty. Thanks, John           See 1 private reply(ies) to/from jsmorgan24.   jsmorgan24 (21 ratings) in Royersford, Pennsylvania United States Bid id: 475,509   N/A Jan 16, 2003 4:06:55 PM EDT  9.47 (Superb)     Hello, I assure you it will be as readable as if you opened it with WordPad. Again, as far as asthetics, I can create something for your review, and if you don't like it, I can rework it with different colors, formatting, etc. I know making a decision is difficult, so one place I recommend people go to is the RAC resumes and ratings if you haven't already looked them over. Anyway, I will wait to hear from you as to who your selection is.           See 1 private reply(ies) to/from jsmorgan24.