I REQUIRE AN EXISTING SPREADSHEET WHICH WE CURRENTLY IS IN MICROSOFT EXCEL TO BE MODIFIED AND MADE MORE INTERACTIVE IF THIS IS POSSIBLE.
WE CURRENTLY ADD INFORMATION INTO THE LOCATION CELL WHICH IS ON A SHEET FOR EACH DAY AND DRIVEN BY HEADER ROWS ASKING FOR INFORMATION LIKE
CONSIGNMENT NOTE DETAILS
CUSTOMER NAME
PICK UP LOCATION
DELIVERY LOCATION
WEIGHT
NUMBER OF PALLETS
COMMENTS
ETC
WE REQUIRE TO BE ABLE TO ENTER THE INFORMATION INTO THE DAY SHEET AND CREATE THE ABILITY ENTERED ONTO THE SHEET TO BE MADE MORE USEFUL BY BEING ABLE TO ALLOCATE A NUMBER OR NAME ON THE ROW AND THEN THIS INFORMATION IS CREATING SOMEWHERE ELSE ON THE SHEET A SUMMARY FOR THE NAME OR NUMBER ALLOCATED.
IT IS A TRANSPORT BUSINESS SO WHEN WE ARE ALLOCATING THE FREIGHT TO THE DRIVER:
EG IF WE HAVE A DRIVER CALLED BOB AND WE ARE PUTTING HIS NAME ON THE WORK WE WANT HIM TO TAKE I WANT THE DETAILS ON THE ROW SELECTED TO PLACE THE INFORMATION INTO ANOTHER AREA SUMMARISING THE FREIGHT WHICH IS BEING ALLOCATED TO HIM.
SO IF I HAVE PLACED HIS NAME TO 7 PALLETS OF FREIGHT THEIR WILL BE A SUMMARY UNDER BOB SHOWING THE FOLLOWING:
# OF PALLETS 7
WEIGHT OF PALLETS 7000KG
DELIVERY DATE 21/7/05
DELIVERY TIME 0600 AM
CUSTOMERS NAMES
THE REQUIREMENT IS TO CREATE A QUICK SNAPHOT OF THE FREIGHT WE ARE ACCUMULATING TO CREATE THE TRUCK LOAD OF FREIGHT FOR OUR DRIVERS.
IT NEEDS TO READJUST IT SELF AS WE MAY CHANGE THE DRIVER NAME OR NUMBERS AS WE NEED TO. SO IT HAS TO BE LIVE FROM THAT RESPECT.
THE SUMMARY COMPONENT COULD BE DISPLAYED IN A TABLE FORMAT WITH THE DRIVER DETAILS AT THE TOP OR EVEN A VISUAL TOOL OF SOME SORT MIGHT BE DESIRABLE IF IT COULD BE DONE IN THE MICROSOFT ENVIRONMENT.
IF REQUIRED I COULD ATTACH A SAMPLE OF SPREADSHEET SO IT CAN BE VIEWED FOR EVALUATION.
I HAVE NOT USED THIS SERVICE BEFORE AND I HOPE THIS IS ENOUGH INFORMATION.
## Deliverables
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).
## Platform
IT MUST WORK IN WINDOWS XP ENVIROMENT
IT IS AND EXCEL SPREADSHEET VERSION 6.