Looking for someone experienced in Excel to build out a file that will automate the analysis of raw data. We are building out a research program that will run standardized surveys on a monthly basis. The survey questions will not change, but the respondents will be new each month, so the raw data output will be formatted in the same manner each month, but the responses will need to be reanalyzed. I would like create an Excel file that will have crosstabs and pivot tables already programmed to the cells, so that when I copy and paste the raw data into the file, the analysis will happen automatically.
The surveys are only about 15 questions long, and are not overly complicated, so someone experienced in building out Excel files should be able to accomplish this with relative ease.
There are multiple surveys that we currently have standardized, and more are in development, so if successful, there will be more projects similar to this one.
I am willing to pay higher rates for the most experienced freelancers