Translate a excel staffing sheet into a webbased tool

IN PROGRESS
Bids
11
Avg Bid (EUR)
171
Project Budget (EUR)
€30 - €250

Project Description:
This project is to convert an staffing utilization tool made in excel. See attached images of the tool, what I'm looking for is a component for Joomla 1.7 with a backend and front end.

Backend is for administration, here the administrator can add, edit or delete data that exist in the following tables that needs to be created.
- Departments - hold the names of departments/business units - fields are id and department name
- Project type - hold the names of types of projects - fields are id and project type
- Employee Status - hold the names of employee status - fields are id and employee status
- Clients - hold the names of clients name - fields are id and clients name
- Title - hold the names of titles - fields are id and titles names
- Role - hold the names of roles - fields are id and roles names
- project name - project types - a table that holds the id of project names and project types and project number
- resource name - name of a person - the fields are id first & last name, employee status (id), title (id), employee number, department (id), skill set(id), joomla user id (all users could be copied into this table with a button) or that this table is linked to the joomla user table.
- skill set - hold the names of skill sets - fields are id and skill set
- host table - that includes the fields resource name(id), title(id), role(id), employment status(id), percentage allocated, project name(id), project number, allocation start date, allocation end date, client(id), project type(id), department (id), employee number, product skillset

These are the tables that should be in the backend and allow an admin to edit, delete or update.

On the front end, a user can login an view the projects that they are assigned to - at this point that all the user should be able to view.

An administrator that is logged in from the front end should be able to run a few reports - the reports are
- availability
- utilization
- project program view

See attached files.

The administrator should be able to edit, delete and update the host table - see the host table attachment.

Any questions let me know.

Skills required:
Joomla, MySQL, PHP, Software Architecture, Website Design
Additional Files: host+sheet.jpg utilization.jpg availability.jpg data+sheet.jpg report-role.jpg
About the employer:
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.


€ 181
in 5 days
€ 200
in 7 days
€ 250
in 3 days
€ 250
in 10 days
€ 200
in 7 days
€ 180
in 5 days
Hire ufkayolcu
€ 50
in 8 days
€ 200
in 25 days
€ 100
in 10 days
Hire erickne
€ 100
in 3 days