How Software Gets Done  


Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
Newest Bid Requests.
cool flash design needed FAST!(repost)
By adrianbye on Jul 10
Max Bid: Open to fair suggestions

Logo for marketing firm
By 1212Kenwood on Jul 10
Max Bid: $30

Customer Tracking System(repost)
By cyrusb on Jul 10
Max Bid: $100

By KURTL34@MD on Jul 10
Max Bid: Open to fair suggestions

Logo for my company
By dgconsulting on Jul 10
Max Bid: Open to fair suggestions

PHP for Windows precompiled, ready to go
By mightycpa on Jul 10
Max Bid: Open to fair suggestions

Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
(139 open)
(50 open)
(82 open)
(9 open)
   SQL Server 
(46 open)
   Other DB 
(16 open)
Documentation / Tech Writing 
(13 open)
Data Entry 
(21 open)
Game Development 
(24 open)
Graphics / Art / Music 
(45 open)
(52 open)
     Adobe AfterEffects 
(1 open)
     Adobe Photoshop 
(15 open)
     Adobe Premiere 
(3 open)
     3d Animation 
(12 open)
   Art (Misc.) 
(18 open)
(11 open)
   3d Modeling 
(13 open)
Language Specific 
(95 open)
(52 open)
   ASP .NET 
(33 open)
(41 open)
   C++ / C 
(107 open)
   Carbon (Mac OS) 
(2 open)
   Cocoa / Obj-C 
(2 open)
   Cold Fusion 
(10 open)
(28 open)
(55 open)
(7 open)
(39 open)
(85 open)
(29 open)
   Visual Basic 
(134 open)
   Visual Basic .Net 
(53 open)
(54 open)
(29 open)
(3 open)
(36 open)
   Video Editing 
(4 open)
(43 open)
   Network Design 
(11 open)
   Network Implementation 
(13 open)
(75 open)
(157 open)
     MS Exchange 
(6 open)
     MS Office 
(13 open)
(15 open)
(1 open)
   Internet Browser 
(38 open)
(61 open)
(27 open)
   Hand Held/PDA Programming 
(9 open)
(13 open)
(28 open)
Testing / Quality Assurance 
(16 open)
(147 open)
   Page Design 
(75 open)
(34 open)
   Web Services 
(68 open)
   Web (Other) 
(76 open)
(12 open)
   Computer Based 
(11 open)
Other Sites

Download the free Rent A Coder IE toolbar!
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
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)

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.

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.

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.
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!
(21 ratings)
in Royersford, Pennsylvania
United States
Bid id: 474,995
$100 (USD) Jan 16, 2003
10:54:02 AM EDT

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.

Attached File
  See 1 private reply(ies)
to/from jsmorgan24.

(21 ratings)
in Royersford, Pennsylvania
United States
Bid id: 475,335
N/A Jan 16, 2003
2:33:29 PM EDT

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.


(21 ratings)
in Royersford, Pennsylvania
United States
Bid id: 475,404
N/A Jan 16, 2003
2:59:12 PM EDT
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.

  See 1 private reply(ies)
to/from jsmorgan24.

(21 ratings)
in Royersford, Pennsylvania
United States
Bid id: 475,458
N/A Jan 16, 2003
3:33:22 PM EDT
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.


  See 1 private reply(ies)
to/from jsmorgan24.

(21 ratings)
in Royersford, Pennsylvania
United States
Bid id: 475,509
N/A Jan 16, 2003
4:06:55 PM EDT

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.

Quick Bid Request Search
 Advanced Search
Newest Open Work
Latest News  


Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
Top Coders.

Anuj Gakhar
Rated a 9.98 on 100 jobs 
Rated a 9.96 on 109 jobs 
Rated a 9.82 on 80 jobs 
Andrei Remenchuk
Rated a 10 on 13 jobs 
Rated a 9.97 on 149 jobs 
Michael Sharp
Rated a 9.97 on 181 jobs 
Rated a 9.93 on 37 jobs 
Rated a 10 on 22 jobs 
Rated a 9.93 on 67 jobs 
Tometa Software, Inc.
Rated a 10 on 10 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:


Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.