This is a sample event attendance worksheet for excel. It is basically designed for rally with following data to be inputted
Membership Number,Name,NUMBERS ATTENDING,CHARGES etc. You can get an idea on how to design one by yourself.

event attendance

View or download here