bluep
2016-01-06, 03:53 PM
Dear friends
Just give you a small macro for calculating the SMS time in driving test by TEMS
As you know, there are 02 times need to report in driving test : SMS Delivery time ( from send to receive ) and SMS Delay time ( From request to send )
When using Tems investigation , you can get the logfile with details about SMS : RP_MTI, TP_MTI.
Pls export them into 01 workbook , then filter RP_MTI to remove blank, copy to marco, run to get the report
- T1: SMS Delay
- T2: SMS Delivery
- Trung binh T1 , T2 = Average T1, T2
If you find helpful, pls add rep for me ^^
Just give you a small macro for calculating the SMS time in driving test by TEMS
As you know, there are 02 times need to report in driving test : SMS Delivery time ( from send to receive ) and SMS Delay time ( From request to send )
When using Tems investigation , you can get the logfile with details about SMS : RP_MTI, TP_MTI.
Pls export them into 01 workbook , then filter RP_MTI to remove blank, copy to marco, run to get the report
- T1: SMS Delay
- T2: SMS Delivery
- Trung binh T1 , T2 = Average T1, T2
If you find helpful, pls add rep for me ^^