Im designing an online game and Im having trouble finding a suitable
formula to calculate match attendance to a match.
Formula should consider quality of opposition, home team match streak,
home team flair and previous attendance.
Any suggestions and ideas are appreciated.
Please log in or register to post a reply.
totalAttendance needs to be bounded, likely by 0 and the capacity of the
gainAttendance is the maximum amount you would want Attendance to differ
deltaAttendance is the difference in current attendance to last game’s
lastAttendance is the attendance from the previous game.
Each of your criteria needs a weight, each weight to be determined by
yourself and a spreadsheet. Each criteria also needs to be bounded, by 0
some arbitrary maximum (what’s the max Steak that will make a difference
in attendance, what’s the max quality that will matter). These need to
be normalized to between 0 and 1 (divide actual value by your arbitrary
maximum for each criteria).
Weighted & Normalize Opposition Quality becomes wnOpposition.
Weighted & Normalize Home Team Match Streak becomes wnStreak.
Weighted & Normalize Home Team Flair becomes wnFlair.
** Apply Weights before Normalizing, to ensure values are all below 1.
Weights essentially are how important a given criteria is, compared to
the other criteria. For example, if you wanted Opposition Quality to
affect Attendance more than Flair, you could multiply Flair by a Weight
of 1, and Opposition by a Weight of 1.5.
Previous Attendance can serve as a relevant starting point for the next
game’s attendance, and the above criteria can serve to determine the
If you are going to use a winning streak as criteria, you will also want
total wins, or win vs loss ratio. If you use only winning streak, as
soon as the streak comes to an end, the next game will have
significantly less attendance, depending on the weight you give Streak.
So what we end up with is:
deltaAttendance = Average of ( wnOpposition, wnStreak, wnFlair )
actualAttendance = lastAttendance + ( gainAttendance * (
WTF is “home team flair”? ;)
“Now, it’s up to you whether or not you want to just do the bare
minimum. Well, like Brian, for example, has 37 pieces of flair. And a
Now sir, I’ve been made aware that, conversely, Jennifer Aniston would
attract a much larger crowd than Brian.