We have a source spreadsheet (see attached) that will need a backed database (MSSQL preferred as we already have licensing) with a web front-end for data entry, editing, and reporting/exporting as csv or xls for adding to an internal report. If there is a native Office365 app that this can be done with we would like to discuss.
Table column description. Items marked with a * should be viewed on the data entry / report
*Group - these are sections of the data entry / report
Group Description - description of group
Markets to Show Group For - This is a subcategory of industries. When assigned to a client the form/report should show the relevant items
Group Sort Order - How the group should be sorted in the entry / report
*Item - This is is the individual item
* Grade - (not on Excel sheet) - should be a number of fields TBD
*Items Description - Description of the item
*Health Standard - Ideal standard of the item
Item Sort Order - How the items is sorted in data entry / report
*Status - A drop down with each status separated by a ";"
*Risks - Should show this only if grade is below a risk/warning
*Solution - a drop down with each status separated by a ";"
*Quarter - (not on Excel sheet) - a drop down with q1; q2; q3; q4
*Target Year - (not an Excel sheet) - s drop down with 2019, 2020, 2021, 2022, 2024
*Budget - a drop down with each status separated by a ";"
*Last Modified - shows the last edit date of the row
There should also be a clients page with just the clients business name with an add, edit, delete button. You can then drill-down to the client and the saved reports for each client.
Ideally, there will we be a way for us to add, edit, delete components of the report.
Once we successfully complete this project, there will be other similar forms that we need to run our business.
Được trao cho:
26 freelancer đang chào giá trung bình $496 cho công việc này
Hi. I am a full time developer and have high skills in web develop by PHP & MySQL. So I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.