I am wanting to do a project where feedback data is saved in google sheets or excel. I am still working out how the data will get there, but once there I want to be able to generate reports on it. The data might look like this:
clientemaiil, first name, last name, date, score, comment, tech1, tech2, tech3, tech4
I envision the data coming in like this for each customer review.
1)Be able to edit, add or delete a score for client or tech. So two techs might get a 2 score. Be able to go in and change tech1 score to 3 while leaving tech2 and client with a 2 score
Generate weekly reports based on dates. I want a report for the week of Sep3 to sep10. It finds all rows with those dates and will generate a report and graph for EACH tech that I can then print. That is roughly what I am looking to do. I want several different types of reports but for now wanted to get your thoughts.
Same for client report and company overall
tech 1 (weekly average score) (date range)