Compile Feedback from CSV Files
I run a trade school, and, after each class we collect feedback from our instructors using Gravity Forms on a WordPress website.
The entries of this form are available for us to manually download as a CSV file as needed.
I am looking for way to be able to:
1) Take the information from the CSV file, format it into a simple report (see examples attached) including comments and add some simple averages for a total feedback scores
2) Send the feedback form to the specific instructors with one click. If we have a list of the instructor ID, name, and email, then I am hoping that our admins can review and send these forms to all instructors at once to save them time.
I imagine some custom VBA and/or application forms will be needed here. Ideally, our admins would simply open this Excel file, be prompted by a form, choose the CSV file, have the opportunity to review, and then one click to send the individual feedback form to the individual instructors.
3) Compile averages for all instructors across all classes. Have filters by date range.
I look forward to finding someone with experience in these areas who can help us build a better long term solution.
Hourly Range: $30.00-$65.00
Posted On: October 14, 2021 16:48 UTC
Category: Data Analytics
Skills:Microsoft Excel, Excel VBA, MS Excel, Spreadsheets, Data Analysis, Email
Country: United States