Tabulating/computation of daily participation rate for survey

Help Activities
, ,
1

I have an excel on ‘Staff List’ which shows the people who have participated in the survey everyday, separated by different daily tabs.

I have another excel ‘Tabulation’ which will calculate the % of people who have participated in the survey by extracting the count from ‘Staff List’, but the columns would add on by day as it would be computed daily.

There is a ‘Template’ tab in the Tabulation excel file where the data would be fixed and the output I want would look like the tab ‘Output’ in the Tabulation excel file.

I did a very draft workflow but I can’t figure it out because there are so many requirements.

Staff List - Test (1).xlsx (16.2 KB) Tabulation.xlsx (12.1 KB) Test.xaml (7.1 KB)