Download this excel file: http://mentalindustries.orconhosting.net.nz/cap.xlsm
Only works for office 2007
Only works for the torrent usage plan.

You need to enter a number into B1 Peak Data Cap based on what you want to use eg 10 for 10GB or 20 for 20GB etc.

Add the path you save the file to as a trusted location.
http://office.microsoft.com/en-us/excel/HA100319991033.aspx

Change the default security settings so you dont get bugged each time you open the file.
http://office.microsoft.com/en-us/excel/HA100651761033.aspx

and allow macros - the code of the macro is at the bottom of the post
http://office.microsoft.com/en-us/help/HA100310711033.aspx

now the tricky part

go to http://tools.perceptus.ca/text-wiz.php?ops=9

and type in your xnet account password.
This will then give you the MD5 hash you need.
this website does nothing other than give you the md5 hash of your password, use any other method to get it if you wish.

Now open the Xnet xml sheet.
click Data -> from web
as the address enter:

changing putting in your username and the md5 hash you made before.
https://accounts.xport.co.nz/xml4.cgi?username=USERNAME@adsl.xnet.co.nz;token=MD5hashfromabove

click go
then import
when asked click A2 cell and click ok.

now check that the cells on the Xnet Usage sheet have vaild numbers in.
you may need to manually edit the number on the end to select the correct row.

You should now be getting some awesome useful information like below
[imgw]http://iforce.co.nz/i/5f4706bcb7012e2b78077297ff218d08.jpg[/imgw]

macro script in the file is:
Sub Auto_Open()
'
' Auto_Open Macro
'
'
   ActiveWorkbook.RefreshAll
End Sub

The macro basically presses the refresh button on file open for you.

If you want other plans added need to send me the output of the xml and what plan you are on so I can figure out whats different.


Disclaimer:
If anything goes wrong its not my fault.
The prices so have been correct for me, however any changes xnet make will not automatically be reflected in this spreadsheet.
For your current bill please login to the xnet account manager.


Thanks
mentalinc