Attendance Analysis Week 29, return of the tables. This sequel does not star small furry but vicious creatures. Nor the redemption of a wayward hero, it also is not a trap. I am ever so thankful for all the hard effort of the BigSoccer design and coding team, and while there is still room for improvement these tables are certainly several steps up from the attached text file, and are even clearer than the old borderless tables in the previous bigsoccer. Remember in this thread we discuss the: (AAQ = Attendance Analysis Quotient. This figure is an overall attendance assessment, calculated from the weighted values of average attendance, median attendance, <10K percentage and >20K percentage. A lower figure represents a better attendance performance.) This is a slight change from Andy's old formula which used simple ordinal values and provided a full ranking point separation for two numbers that may have been within a percentage. This ordinal system did not allow for fine differences to be seen, and may have painted a somewhat skewed view of the numbers (though to be honest there is not much difference in the two end of season sets). The formula to find the weighted value for each column is: Take the annual value and subtract it from the Max value for it's column. Then take that result and divide it by the (Max-Min) for its column. For example, for the average column 17869 is the max 13756 is the min 4113 is the difference To calculate the derived value for 2010 Subtract 16675 from 17869 to get 1194. Divide 1194 by 4113 then mulitply by 100* to get 29 *Note that this step is new as some people thought whole numbers would be easier to read. MLS Attendance is based on tickets distributed not tickets scanned. Therefore if a team sells or distributes X number of tickets, then X is the attendance for that match. Even if 0 people showed up for whatever reason, X would still be the official attendance. There are a number of reasons actual attendance may be lower or higher than the announced.