exporting usage data

[mukuboy]

I just bought the latest Gargoyle router solely on the assurance that I could keep a log of per-user bandwidth usage. what I've seen after 2 days of using the router I believe this is possible. however, what I really want to do is to export the router's usage data to a spreadsheet so I can create my own reports. somehow I need to show each user their total down-uploads so when we run over the ISP limit and I have to buy more bandwidth I can charge the users their fair share.

[mukuboy]

okay. I'm answering my own question. using IE11 there is no automatic "save file". but when you get the csv downloaded you right click the page and select "view source". this brings up a new window with the data in a useful format. save this file and import to spreadsheet. the Unix timestamps are easily converted using this formula
=(A1/86400)+25569+(-5/24). A1 should be replaced with the actual timestamp cell and the "-5" replaced with your UTC offset. the formula returns a numeric value that can be formatted as a date/time. you're welcome!