Rent A Coder - Excel Macros Needed

Show Bid Request

Excel Macros Needed
Bid Request Id: 39479

Bookmark in my 'To Do' list

Posted by:	TheStatMan (7 ratings) (Software buyer rating 10)
Non-action Ratio:	Very Good - 0.00%
Buyer Security Verifications:	Good
Approved on:	Dec 11, 2002 8:53:04 PM EDT
Bidding Closes:	Dec 16, 2002 9:09:58 PM EDT
Viewed (by coders):	233 times
Deadline:	12/23/2002 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:	Visual Basic

Enter chat room for this bid request
(0 active users at Sep 8, 2003 8:37:47 PM EDT)

Description:
I have a spreadsheet program that needs a little macro work (attached). It would be pretty easy to look it over and then read the rest of this. The purpose of the spreadsheet is that a user will be limited to selecting only 4 fruits or vegetables out of a total of about 20 in the list and they must stay under the amount of money they have available (say $100.00). The purpose is for them to maximize their point totals. Here is what I need accomplished with this spreadsheet:

1. There are columns off to the right with different currency data in them (columns S, T, U). Depending on which currency the user selects in a drop-down box (Dollars, Euro, GBP), I would like those currency figures to appear in column C.

2. The formulas in cells C5 and C7 currently work off of 1&'s or 0&'s in column F. I would like these to work off of check-boxes in column F instead.

3. Most importantly, I would like the user to select which ranking method they would like applied, (either Rank A, Rank B, Rank C or manual). Ranks A, B and C are located off to the right in columns P,Q and R. If they select either Rank A, Rank B, or Rank C I would like this data supplied to column A and have Colums A, B and C sorted in ascending order on Column A. I realize that the columns off to the right (O through U) would need to sort as well to keep the data from getting all jumbled.

4. If they select manual, I would like a pop-up listbox to appear (I'm open to other methods)and allow them to manually rank the fruits and vegetables. Here again, when they are finished I would like their ranking to appear in Column A and have all the right descriptions and currency figures appear in columns B and C as well. This data set would also be sorted in ascending order on column A.

This is all that I need accomplished on this spreadsheet.

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:
Windows (excel spreadsheet)

Must be 100% finished and received by buyer on:
Dec 23, 2002 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!

PVA
(30 ratings)
in Bangalore, Karnataka
India
Bid id: 427,040

$20 (USD) Dec 11, 2002
10:31:48 PM EDT 9.93
(Excellent)

Hi,
I have done many assignments like this using Excel VBA, so no problem in doing this work. Will do it in time and give good quality code with enough comments.

will report the progress of work regularly

Thanks,
PVA

PVA
(30 ratings)
in Bangalore, Karnataka
India
Bid id: 427,279

N/A Dec 12, 2002
10:37:19 AM EDT 9.93
(Excellent)

Hi,
Just to inform that, I finished most of the coding(80%). Will deliver for testing at the earliest once the acceptance of the bid.

Thanks,
PVA