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.
I will create a custom web app using mssql. it will have the ability to edit the data shown in the spreadsheet and export to CSV etc
Bu iş için 26 freelancer ortalamada $496 teklif veriyor
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.