KiBs and MiBs

RouterOS The User Manager
1

I’ve been working on an Excel worksheet into which I can import data from User-Manager’s reports to meet my needs.

One report just generated reports usage over a particular period by a particular users as 1771.6 KiB upload and 10.3 MiB download.

By my book a Mebibyte (MiB) = 1024 KiB so 1771.6 KiB = 1 MiB 747.6 KiB or 1.73 MiB. The same report also allocates 3.3 MiB to another user.

So can someone at Mikrotik tell me when the report generator begins reporting B as KiB, KiB as MiB and, presumably, MiB as GiB as I need to factor this into the worksheet.

Thanks

2

Values calculation sheet looks like this,


x=current data usage statistic

  1. B are shown, when 0 <= x < 2048, then x B;
  2. KiB are shown, when 2048 <= x < 2048 * 1024, then x/1024;
  3. MiB are shown, when 2048 * 1024 <= x < 2048 * 1024 * 1024 ,
    x/ 1024 /1024;
  4. GiB are shown, when 2048 * 1024 * 1024 <= x, x/1024/1024 /1024;
3

OK. Thanks sergejs.

Will make for an interesting Excel IF formula. :unamused: