Yes this can be done.


  1. Enable packet trace and run the simulation (run it for short time because logging this file takes time, plus it would be a large file)
  2. After simulation open packet trace In excel, use format as table option available under Home Tab 
  3. Under transmitted ID column filter to Access point
  4. Add a new column which would be equal to PHY_LAYER_PAYLOAD(Bytes)*8 /  (PHY_LAYER_START_TIME(US)-PHY_LAYER_ARRIVAL_TIME(US)). Since the times are in micro seconds, this will give you the approximate PHY Rate in Mbps that each packet experiences. The exact formula would be


PHY_RATE (802.11a) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 20)

PHY_RATE (802.11b) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 192)

PHY_RATE (802.11g) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 20)     

PHY_RATE (802.11n) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 40)

PHY_RATE (802.11ac) = PHY_LAYER_PAYLOAD * 8 /(PHY_LAYER_END_TIME - PHY_LAYER_ARRIVAL_TIME - 45)