Using Excel to Generate Unique Wi-Fi User Reports

This one goes out to my library people who need to report unique clients by location to Uncle Sam in order to get paid.  If you can get a data dump of your Wi-Fi stats that include all connected client MAC addresses you can use Microsoft Excel on Windows & PowerPivot table tools to create a report of what you need.

Many libraries across the nation chose Aerohive and HiveManager Classic for this very reason.  Our ExtremeCloud IQ reports aren't quite as elegant so this is an easy way to get your stats.

"When in doubt, go to the library." — Ron Weasley in Harry Potter and the Chamber of Secrets by J.K. Rowling

If you want a good laugh, just read the outcry from users who want PowerPivot on Mac: https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19568977-add-powerpivot-to-mac-excel

Until next time.
-Mike