Tagging @john.desborough in case he has any handy ideas on figuring out the average!
@Liz @LMc_Omaha - that stuff that is pure excel calculation
- define a look up table to use to establish data ranges for ‘weeks’
- run a macro that looks up the submissions in a specific week and write it into an answer table
- divide the total score (sum) by the count of records in that week.
that should be simple enough to do in excel..
des
@Liz @LMc_Omaha - that stuff that is pure excel calculation
- define a look up table to use to establish data ranges for ‘weeks’
- run a macro that looks up the submissions in a specific week and write it into an answer table
- divide the total score (sum) by the count of records in that week.
that should be simple enough to do in excel..
des
Thank you @john.desborough
So, if I’m understanding you, the average that I’m trying to find will take place in the exported Excel file and not within Typeform, itself?
If so, I’m all set. Sounds like I was overcomplicating it.
@LMc_Omaha - you could calculate the average for a single form by using logic rules, but if you are not showing it to the user in an ending or elsewhere in the form, you should do it in the excel sheet.
des
Hey @LMc_Omaha let us know if you were able to get all your calculations sorted, hopefully @john.desborough’s suggestions helped 
