I use Lotus 1-2-3 spreadsheet for consignment inventory on service trucks. The spreadsheet has several columns: Part# Balance Brought Forward Pickups Since Last Reconciliation Balance Total (Brought Fwd + Pickups) Current Balance Quantity Sold Balance Brought Forward The pickups data comes from an exported 123 file with items picked up sorted in part# order. This file contains 2 fields: the part # and the quantity picked up. Each part# may have multiple lines of pickups since they may have ordered the same part several times since the last "settlement". I want a coder to modify the spreadsheet with use of formulas and lotus script so that: 1) The exported data is imported into the workbook 2) The imported spreadsheet with multiple lines for each part is converted to a summary-- i.e. if partA is listed 3 times with pickups of 1, 2, and 3-- instead of listing 3 lines there is now 1 line with the total pickup up of 6. 3) A formula is created so that this value is matched to the appropriate part# in the spreadsheet. 4) Any imported items that are not matched with a consignment item in the spreadsheet is entered in an "adjustments" section of the workbook to be billed outright. Basically, you're modifying and updating an existing spreadsheet so I don't have to manually enter pickups.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows XP .. Lotus 1-2-3 verison 9.8