How to Analyse MOT test logs. Phase 1 set up and IP Address Analysis (before printing).

The DVSA stipulate that an MOT Test Centre manager should analyse test logs monthly. Do you know how to analyse your MOT Test Logs properly?
These short tutorials are here to help save time, save money and stay compliant.
Transcript
00:00:03
Continuing with our MOT test log analysis tutorial. Open the test log CSV in Excel
00:00:08
Column B, you'll notice is hashtagged out?
00:00:14
If we click on the right hand side and hold the left mouse key, you'll see two little arrows - open up drag to the right until you get above width 18.
00:00:23
We can then centre that to give ourselves a little bit of breathing space between the columns.
00:00:32
Move on to phase one of the MOT Test Log analysis.
00:00:37
We're going to go to column T by holding the control key and move across to column. You will select both.
00:00:46
Navigate to the middle click and hold again to drag it over to above 15, which will then give us the IP addresses.
00:00:57
We're going to check that all the IP addresses are the same.
00:01:00
The left hand side you will have client IP address at start and the client IP address on completion.
00:01:14
These should be the same unless you have multiple computers set up within your MOT Test Cente.
00:01:20
Don't worry about the gap, such as this one here.
00:01:25
You will see it's just for one second and the vehicle details are the same as the column above. This is when the MOT tester has logged back on to complete and pass an MOT Test.
00:01:41
Once you've done this once. You'll see any variations.
00:01:46
We're going to move on to phase two.
Do need help with your MOT Compliance?
Do you need more help - training or a refresher course.
Contact The MOT Group on 0800 1777 344
Or Visit themotgroup.co.uk