I wish to develop a website for an association that distributes an annual grants to sports clubs. To receive this grant, each club must, of course, provide some basic information (club name, names of leaders, address, the sport name…) and others that are necessary to calculate the amount allocated (number of licensed competitors, number of licensed non-competitors, number of regional travel, number of national travel…).
This association asked me to develop a website that allows clubs to capture these various information. It means that I have already the approximately structure of the mysql database. I will provide this structure. But I've no time to develop the web interface. I will also provide a screenshot of each pages with the data it needs.
The first page of the website is the login page (a username that will be define by the association and the password). The password will be given but we have to provide the possibility of changing it. The next pages will contain the differents data needed.
Some club can have about 200 members. So there must be a possibility to copy and paste information from their Excel file (for example) directly into the web page (about 12 fields).
Finally, the association must be able to follow the evolution of inputs made by each club. Therefore the interface should have a page dedicated to the association to access all data and statistics they want. In this area, the association will have to be able to add, change or delete value. They also want to export the data in an excel file or/and access database.
Naturally, the website need to be safe and secure ! The design is important (theme on sports). I need that development is easily understandable (well commented) because I should keep it afterwards and I need to be able to add new information, without calling anyone to help me.