~~~ Please read before posting. ~~~

Important: We need your Club Number at a minimum, and as many details as possible.
For further info please read This page before posting.

Change spreadsheet role report to one number per column

  • haeaton
  • haeaton's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 34
  • Thanks: 1

Change spreadsheet role report to one number per column

1 year 11 months ago
#91815
The current role report spreadsheet combines "Completed roles / Future roles" so summary of roles for a given member appears in the role column of "Evaluator" as "3 / 1" with two numbers separated by a "/".  

It would much easier to create supplemental reports from the spreadsheet reports if each column contained one number per member.  Please separate Completed roles vs future roles for each function into separate columns.

Our club wants to score member participation by completed role performances so that we can easily see which members have performed the most key roles over a time period similar to the Toastmaster DCP program.  For example we might give Toastmaster, Table Topics Master & General Evaluator roles 3 points, Speakers & Evaluators 2 points, and other  functionary roles 1 point. 

We could automate the process if Completed Roles vs Future Roles were in separate columns for each function.  We see this as a valuable tool for clubs.   If FTH would provide separate columns with one number per column, we would share our automated scoring process.  

Please consider this request.
The topic has been locked.
Moderators: BrianPamrhtaylor3marc33NotLiableNSBjgavinLcala305Henipeterb323DebbieT
Time to create page: 1.598 seconds