Are you tired of constantly managing over 1000 participants? Stress out of having to choose and hire countless bounty managers? Tight in budget? Too much work?
I hope this post will help those that are still managing bounty campaigns, and reduce workload by almost 50% !!!
Excel has a way to implement smart functions that will ease our life, just like smart contracts, they are smart
Firstly, i think most know that google form has a way to import all responses into google excel.
https://support.google.com/docs/answer/2917686?hl=en this will help!
Secondly, lets say you are managing signature campaign, before you start importing to excel, do take down each participant's rank.
this is where it gets exciting! And you do not need to check how many stakes each one get according to their ranks anymore. All will be auto!
now to implement the auto function, u can put
=VLOOKUP(H14,N4:O8,2,false) into the function bar under the green box!
VLOOKUP is Vertical lookup where it search the database, in this case is N4:O8 so
H14 is legend rank,
N4 to O8 is the database,
2 is the number of vertical database,
FALSE forces the function to look for the exact value under the O table to be input on the green box ,
TRUE will force the function to round up to the nearest number to be input on the green box.
don't forget that H14 value and the text under N4 has to be the same name!
It works with numbers and texts too!
Once again, no more manually checking how many stakes each one get according to their ranks anymore!!
Unfortunately, you still need to manually check the number of posts, and comments each participant has and implement the SUM function to add up the initial automated stakes together with the post counts.
Unless you want to input the counts every week on google form and import them to excel, then you can also use the above functions too
If you have a better idea on how to auto check posts and comments count each has, without having to create new google form weekly, feel free to share!
Overall, I think with the auto checking of stakes, it will reduce the workload if you have over 2000 participants....
