I need a small application which has to be in ASP.net either 2.0 or 1.1 with SQL 2000 Database.
I have attached an XLS sheet with basic calculations that have to be done. **You would need to replicate all of the columns (12). Basic calculations, except WTD, MTD, YTD which are based on calendar year.
**
All of the fields listed will be only for one day, exept WTD, MTD, YTD.
WTD, MTD, YTD and any automatically calculated columns are not editable based on current calendar year.
Few things need to be automated, WTD (Week to Date), MTD (Month to Date), YTD (Year to Date). If someone adds 1 to brokers lead in, it will update WTD, MTD, and YTD accordingly.
This information will need to be in a datagrid format.
This application will also have a bar graph, which will show total leads in for all brokers per month for the current year.
Furthermore, you should be able to add/remove broker from the list and the application will recalculate accordingly.
Application will need to be accessed from the Internet, with a login name, only one login name will do.
In this application there will be 5 different offices with different brokers, each office will have different numbers.
You should be able to switch between different offices by clicking drop down box.
All information in all of the fields once entered will be saved to the database automatically.
This application needs to have appealing color scheme; Similar color scheme as rent a coder uses will do.
All information will need to be stored in SQL database, will need to be well organized, ASP.net code will also need to be well organized since we are planning to add several other features to this application with several reports in the future.
## 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
ASP.NET 1.1 or 2.0.
SQL 2000.
Windows XP, IE 6.0 and higher.