How to find out the data usage per SIM from my bills

Written description in .csv invoice

Use the relevant row marked 'Data' in column A 'ItemRef'

Navigate to column H 'Description'.

 

Numerical value in .csv invoice

Use the relevant row marked 'Data' in column A 'ItemRef'

Sum the 'Quantity' in column K - this is the number of bytes of overage used - with the 'InBundleQuantity' in column S - this is the number of bytes used inside the bundled amount.

This will return the total number of bytes used by the SIM within the month.

To return this number in kilobytes divide it by 1024.

To return this number in megabytes divide is by 1048576.

Have more questions? Submit a request

Comments

Powered by Zendesk