Show Bid Request
Excel VBA Program
Bid Request Id: 40878
|
|
|
|
Posted by: |
sovratec (9 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 48.00%
|
|
Posted: |
Dec 22, 2002
5:23:00 PM EDT
|
|
Bidding Closes: |
Dec 24, 2002
5:52:07 PM EDT
|
|
Viewed (by coders): |
191 times
|
|
Deadline: |
12/27/2002
TIME EXPIRED
|
|
|
|
|
Description:
I need an advance Excel VBA programmer to add additional code to an automated worksheet report.
The workbook app has:
1. User form
2. 2 Data Worksheets
3. 1 Criteria Sheet
4. 1 Sample Report
The request is to build a report at runtime using input from the User form, and the data worksheets.
On the Input Worksheet, There is a button to a Userform.
Disregard the Filter button. Use the "New Trend" button on the form to create a Sales Trend report based on the selections and the Order_Data.
To do this: Apply the filters on the user form against data found on the Order_Data sheet.
Only serious bidders!
A bonus will be awarded upon satisfactory completion.
If you are an advance VBA programmer, and have experience building dynamic reports; This will be a quick project. I will assist during the development process and will answer all questions.
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 NT, Windows 2000, Windows XP.
Excel 97 +
Must be 100% finished and received by buyer on:
Dec 27, 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!
|
$40 (USD)
|
Dec 23, 2002
3:10:06 AM EDT
|
9.8
(Excellent)
|
|
|
Hi Sovratec,
This is Scott Tripp, a general programmer and consultant. I've attached a copy of the spreadsheet that incorporates some of the functionality that you outlined, but isn't a finished product. I wasn't sure about the 'proposed' fields, and left them empty. Also, the code doesn't update the formulas for the totals (e.g. Sum(E8:E9)), but this would be easy to do. That said, it does summarize the data for the selected people and products on the form.
Also, it's worth pointing out that this code takes into account the fact that many products have the same name, but different prices. The report takes this into account by calculating the revenue for each order.
If you're interested in wrapping this up, or have any questions or comments, please don't hesitate to get in touch. To reiterate, I consider this a basic proof-of-principle rather than a finished product.
Take care,
Scott
|
|
|
Attached File
|
|
|
|
|
|