Ask Wireshark - RSS feedhttps://ask.wireshark.org/questions/Wireshark questions and answersenCopyright Wireshark Foundation, 2017-2019Sat, 02 Mar 2019 21:52:30 +0000Calculating Bandwidth Utilizationhttps://ask.wireshark.org/question/7695/calculating-bandwidth-utilization/Working a project to determine used bandwidth between two nodes. If I capture using the node pairs and then export "Packet Disections as CSV... then import to Excel and sum all of the "length" field entries I will have the total utilization in bits... is this correct?
I would like to export the "Statistics>Conversations>Ethernet" into a CSX but can only find a save as .CSV... any ideas how to get this into excel?
Thank you for helping a newbie... Sat, 02 Mar 2019 14:40:18 +0000https://ask.wireshark.org/question/7695/calculating-bandwidth-utilization/Answer by BenD for <p>Working a project to determine used bandwidth between two nodes. If I capture using the node pairs and then export "Packet Disections as CSV... then import to Excel and sum all of the "length" field entries I will have the total utilization in bits... is this correct?</p>
<p>I would like to export the "Statistics>Conversations>Ethernet" into a CSX but can only find a save as .CSV... any ideas how to get this into excel?</p>
<p>Thank you for helping a newbie... </p>
https://ask.wireshark.org/question/7695/calculating-bandwidth-utilization/?answer=7698#post-id-7698Hi,
First, you should take the IP length, which is in bytes. Then you need to multiply by 8 to have bits. About the time axis, you can calculate it based on the difference between the actual time of the current packet and the time of the following packet from the same host. This way, you got an approximation of actual speed. It's easier to do the same graph with I/O Graph (Menu Statistics). If you take the time based on the difference between the first and the last packet, you obtain an average, which isn't not very good to find bottleneck problems.
What is your need, have an approximation of consumed bandwidth or find a throughput problem ?
Regards
BenSat, 02 Mar 2019 21:52:30 +0000https://ask.wireshark.org/question/7695/calculating-bandwidth-utilization/?answer=7698#post-id-7698