How Software Gets Done  


(No Login on Secured Page)

Custom Software Buyers
Request new bids
Search Coders
My Account
 
My Buyer 'To Do' List
 
My bid requests
  My escrow account
 
My General Info
Verification
 
Help for Buyers
Articles for Buyers
FAQ for Buyers
Latest News
 

Custom Software Coders

Newest open work
Browse all work
Search all work
My Account
 
My Coder 'To Do' List
 
My bids
 
My General Info
  My credit account
 
Help for Coders
Articles for Coders
FAQ for Coders
Latest News
 

Affiliates

My account
 
My pipeline
 
My credit account
 
Help for Affiliates
Latest News
 
Newest Open Bid Requests.
Email Sender
By swainclubber on May 9
Max Bid: $50


Disk Format Utility
By CFC on May 9
Max Bid: Open to fair suggestions


Java Project along with UML design
By Silver Green on May 9
Max Bid: $20


rtf to html converter
By aramyus on May 9
Max Bid: Open to fair suggestions


A general class to simulate and extend collections
By aramyus on May 9
Max Bid: Open to fair suggestions


affiliate software
By rdlynch on May 9
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site

Open Work Categories.
Database 
(141 open)
   Access 
(63 open)
   MySQL 
(81 open)
   Oracle 
(10 open)
   SQL Server 
(55 open)
   Other DB 
(13 open)
Documentation / Tech Writing 
(31 open)
Data Entry 
(18 open)
Game Development 
(19 open)
Graphics / Art / Music 
(36 open)
   Graphics 
(44 open)
     3d Animation 
(10 open)
   Art (Misc.) 
(15 open)
   Music 
(4 open)
   3d Modeling 
(5 open)
Language Specific 
(102 open)
   ASP 
(73 open)
   C# 
(36 open)
   C++ / C 
(102 open)
   Cocoa / Obj-C 
(1 open)
   Cold Fusion 
(4 open)
   Delphi 
(28 open)
   Java 
(58 open)
   Perl 
(36 open)
   PHP 
(92 open)
   XML/XSL 
(23 open)
   Visual Basic 
(136 open)
   Visual Basic .Net 
(68 open)
   Other 
(46 open)
Misc 
(30 open)
   CAD 
(4 open)
MultiMedia 
(31 open)
Network 
(47 open)
   Network Design 
(10 open)
   Network Implementation 
(16 open)
Platforms 
(60 open)
   Windows 
(162 open)
     MS Exchange 
(3 open)
     MS Office 
(7 open)
     Other 
(7 open)
   Internet Browser 
(42 open)
   Linux 
(50 open)
   UNIX 
(24 open)
   Hand Held/PDA Programming 
(10 open)
Requirements 
(14 open)
Security 
(38 open)
Testing / Quality Assurance 
(18 open)
Web 
(150 open)
   Page Design 
(71 open)
   Flash 
(41 open)
   Web Services 
(75 open)
   Web (Other) 
(78 open)
Training 
(11 open)
   Computer Based 
(15 open)
 
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

Time Tally
Bid Request Id: 41356
Bookmark in my 'To Do' list
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
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: Windows, Visual Basic
Enter chat room for this bid request
(0 active users at May 9, 2003 10:31:41 AM EDT)

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  
Scott1966
(13 ratings)
in San Diego, California
United States
Bid id: 447,524
 
$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
 
 
 
 
  See 8 private reply(ies)
to/from Scott1966.
 




Quick Search
 

 Advanced Search
Newest Open Work
Latest News

 
Credentials


 

 
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.
 

Rent A Coder Top Coders.


Anuj Gakhar
Rated a 9.98 on 92 jobs 
Securenext
Rated a 9.98 on 97 jobs 
Buddies
Rated a 9.82 on 76 jobs 
Codman
Rated a 9.97 on 137 jobs 
Andrei Remenchuk
Rated a 10 on 12 jobs 
Michael Sharp
Rated a 9.98 on 168 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
RNA
Rated a 9.93 on 35 jobs 
hernest
Rated a 10 on 109 jobs 
markesh
Rated a 10 on 21 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers
 
Other
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.