WAN Link bandwidth usage report needed...

[jacob600]

Hello,


I need some help please. I don't use Excel very often except for viewing reports but I need some magic. I am pulling data from an open source firewall. The data is in the three columns below.


My WAN link is 1Gbps (Gigabits per second). I also know you can transfer 280GB (Gigabytes) in one hour over a 1GB link,theoretically.


How can I generate a pie chart that shows how much traffic (Data Transferred) my Top 10 services are using in a day, a week and especially a month? I guess it would be three charts. I have no idea what that formula would be. IF I can get it once, then I can just manually populate new values each month. Any examples would be VERY, VERY much appreciated.


_{Service Connections Data Data Transferred
tcp/https 2067899 12117.56 GB
udp/https 5286511 9900.21 GBB
tcp/http 253888 9601.87 MB
udp/18172 67402 8405.22 MB
tcp/5201 62011 7357.96 MB
udp/8801 57003 6263.11 MB
udp/5001 40389 5139.66 MB
udp/30694 32119 4128.94 MB
udp/16680 21110 3117.90 MB
udp/43211 20063 2115.90 MB
udp/33333 1902 1112.90 MB}



1024 Megabytes = 1 Gigabyte (GB)
1024 Gigabytes = 1 Terabyte (TB)


Thank you,
Jay

 

[jacob600]

Additional info:
I need to know about much of my bandwidth on the gig link is being used by each service/application. For example, http traffic used 30% of the gig link, https was 35% etc.. I assume I would have to tell Excel that I have a gig link or 10gig, etc.