Show Bid Request
Time Tally
Bid Request Id: 41356
|
|
|
|
Posted by: |
LenG (2 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 25.00%
|
|
Posted: |
Dec 27, 2002
10:23:26 PM EDT
|
|
Bidding Closes: |
Jan 10, 2003
10:48:48 PM EDT
|
|
Viewed (by coders): |
244 times
|
|
Deadline: |
1/15/2003
TIME EXPIRED
|
|
|
|
|
Description:
I have a collection of Excel Workbooks that have been completed by another VB program. These spreadsheets represent the amount of time a piece of equipment has been used. They are monthly workbooks with a different worksheet for each day. Each row represents 10 minutes.
The program I want must be written as a tutorial, so that I can see what you are doing every step of the way, and modify the program as necessary. It should be written in VB6. I expect 75% of the lines will be comments to explain fully what you are doing.
Here is the sequence of what must happen:
1. The program should ask for a machine serial number first.
2. Program should open the first Excel workbook, and go to the first worksheet in that workbook.
3. it should go to row 1 and increment across the columns in row 1 looking for the serial number requested in #1
4. If it finds the serial number, it should begin incrementing down the column. Depending on the data found in the column, either 10 minutes is added to a total or it is not. This proceeds to the end of the column.
5. The program should continue in this fashion to the next worksheet until all worksheets in the workbook are totaled.
6. The program should then continue to the next available workbook until all workbooks have been checked.
7. At this point the total time will be formatted into hours and printed to a report.
The serial number given in #1 will really be determined by a FOR NEXT loop as there are about 500 serial numbers I need to tally times for, in batch fashion.
I can email a sample of a workbook if desired.
I need this program in a hurry... 2 or 3 weeks.
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 2000 Running VB6.
Must be 100% finished and received by buyer on:
Jan 15, 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 |
|
|
|
|
$45 (USD)
|
Dec 28, 2002
1:21:55 AM EDT
|
9.84
(Excellent)
|
|
|
Hi LenG,
This is Scott Tripp, a programmer and consultant. I read over your specifications and put together a demo program that has the core functionality that you've outlined. It is definitely a proof-of-principle, and is nowhere near a finished product, but the core functionality is incorporated into the demo program.
That said, the application loops through all of the spreadsheets found in the directory entered in the top text box. By default, this is c:\clients\potential\ExcelReader\Data\ but I'd propose using a browse capability to select the directory for the final app. For each spreadsheet, the program looks through each worksheet in the spreadsheet. In each worksheet it reads the top row looking for the serial number that has been entered in the Serial Number text box. When it finds a match, it adds all of the numeric entries found in that column and pops up an informative text message. I realize that this isn't the final calculation, but I think it shows that the program is reading and operating on the Excel files.
I&'ve tested this out using the serial number 10066, on several copies of your spreadsheet, and it works perfectly. So, I really think that this could be wrapped up very quickly, hopefully by the end of the weekend.
Please don&'t hesitate to get in touch with any questions, comments, or ideas what so ever, or if you have any problems running this application.
Best regards,
Scott
|
|
|
Attached File
|
|
|
|
|
|
Scott1966