Bid/RFP Database Analysis Tool

CLOSED
Bids
4
Avg Bid (USD)
$300
Project Budget (USD)
$30 - $250

Project Description:
I am looking for a way to analyze and review bid/RFP data. I have a database of ~25,000 records in ~300 unique categories. I would like to be able to import new records into the report, have them ranked and sorted and be able to review. I have attached a very basic example.

In the example, the attached would represent the current database. Then say I get a new proposal from provider XXX for the following:
Lane 1001 Rate 992
Lane 1003 Rate 1500

I would like to be able to import the data from XXX into the database, have the program sort and analyze the bid and then display all of the data for only the Lanes that XXX provide data for.

I live in a Excel world so I am very familiar with Excel. I could so something close to what I am looking for in Excel, but the amount of data and formulas I write tend to lock up my computer. If Excel is the best for this I am open to it, but if there is some other way to do it more efficiently I am open to that too. I'm not a huge Access fan, but again, if this is the best then I can work with it.

Skills required:
MySQL, PHP, Software Architecture
Additional Files: bids.xls
Hire kgshooter
Project posted by:
kgshooter United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 500
in 25 days
$ 200
in 3 days
$ 250
in 3 days
Hire ceinj
$ 250
in 3 days