Vehicle and Trailer inspection sheets

[David Jones]

Hi All,

I need to carry out 6 weekly and 10 weekly inspections on our units and trailers. How do I set up the sheets so that:-
1) It automatically records the next date of Inspection and respective dates for the next 6 months so that I have a list of due and completed inspections.
2) On the 2nd page/sheet, I want to have the the identical list of trailers, but instead of showing the inspections as being due in either 6 weeks or 10 weeks, I want to be able to see what vehicle and/or trailer is currently (within the next 7 days) due inspection


Thank you

David

 

[Jeffrey Mahoney]

You need two databases. One to record the history of inspections per trailer and one to keep the status of the trailer. The status DB is going to show the last inspection and the next inspection date. You can create Conditional Formatting on the Status DB to show upcoming inspections with a certain date range. You can filter and sort the Status DB so it shows a chronological upcoming inspections list.

Take it one step at a time and ask for help.

Welcome to the site.

Jeff

 

[David Jones]

Hi Jeff,

Thank you for your reply. I can use Excel, but I am very much a novice when it comes to setting up databases,etc. I most certainly will need a lot of help.

Thank you

David

You need two databases. One to record the history of inspections per trailer and one to keep the status of the trailer. The status DB is going to show the last inspection and the next inspection date. You can create Conditional Formatting on the Status DB to show upcoming inspections with a certain date range. You can filter and sort the Status DB so it shows a chronological upcoming inspections list.

Take it one step at a time and ask for help.

Welcome to the site.

Jeff

 

[Jeffrey Mahoney]

A database (DB) is nothing more than a table on a sheet. Each row is a record. Columns of data are called fields. Usually, the left most column is used for a unique field that identifies each trailer or piece of equipment; no duplicates. It could be a serial number or VIN. A Short name field is helpful and so is a description field. What fields you put after that is up to you. You can add more later.

In your case, you wanted to track when a trailer needs inspection. If you have different types of inspections, then you will need different fields to indicate completion of the last inspection and next inspection for each type. You could include a field to indicate the period of time between each inspection. You might want to include the result of the last inspection. You might want to include a field to indicate special requirements for the next inspection. This "Inspection Status" DB will change all the time. Meaning, you won't have multiple lines for each trailer as record, each record will change as an inspection is completed.

The other DB you need, I think, is an "Inspection History" DB. Setup the same way as the other, but the Unique identifier field will have duplicates. Because you're just maintaining a historical inspection db. You won't need the fields that indicate the next inspection date.

Next, you can learn how to filter the data and create conditional formatting on the inspection dates to indicate upcoming inspections. I can show you how to create formulas to count the number of upcoming inspections. We can create Date Range Cells or length of time to control the variable for the conditional formatting. I can show you how to create VBA code that will automatically filter the inspections based on the Date Range.

Get your databases created.

Jeff

 

[David Jones]

Thanks Jeff
I appreciate your help.
I have created my data base and presumably, will mirror database1 in sheet 2. With the exception of future dates, only actually completed inspection dates. Will this automatically copy from sheet1 to sheet2 on completion of the inspection.
I would also like every second inspection to include a brakes test, is this possible to show?
I am at 1st base ( with the data base completed), can you please get me to 2nd base?

Many thanks

David

 

[Jeffrey Mahoney]

I'm still with you. OK, it would be nice to have a list of your fields. Can you type out your column headers for each DB please.

Concerning your brakes test inspections. As I said before, you can have multiple inspection types in your Inspection Status DB. For instance:

Excel 2013/2016

	A	B	C	D	E	F	G	H	I
Item #	Last Tire Date	Next Tire Insp Date	Last Tire Result	Next Tire Needs	Last Break Date	Next Break Date	Last Break Result	Next Break Needs
TR14778	@ 30% tread	Look for side wall wear, Uneven wear on right inside	Pads on both sides at 50%	Check drum parts

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]1/1/2019[/TD]
[TD="align: center"]6/1/2019[/TD]

[TD="align: center"]1/1/2019[/TD]
[TD="align: center"]8/1/2019[/TD]

</tbody>

Sheet1​

When all data is in, you can filter the data by inspection dates; you could select to filter by the next tire inspection or by the next break inspection. I would add a column that calculates the earliest date for all inspections so you can filter all the inspections by date range.

To answer your question about getting data from one DB to another. I would create some macros to help with this or make some formulas on the Inspection Status DB. Your Inspection History DB should be the master data set, IMO. You could go a couple ways. We can create formulas to find the last date of inspection for each inspection type. You could have a field on the Inspection Status DB that allows you to set the period of time between inspections, then simply calculate the next inspection date. Do you usually work in Months, Weeks, or Days?

Jeff

 

[David Jones]

I'm still with you. OK, it would be nice to have a list of your fields. Can you type out your column headers for each DB please.

Concerning your brakes test inspections. As I said before, you can have multiple inspection types in your Inspection Status DB. For instance:

Excel 2013/2016

	A	B	C	D	E	F	G	H	I
Item #	Last Tire Date	Next Tire Insp Date	Last Tire Result	Next Tire Needs	Last Break Date	Next Break Date	Last Break Result	Next Break Needs
TR14778	@ 30% tread	Look for side wall wear, Uneven wear on right inside	Pads on both sides at 50%	Check drum parts

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]1/1/2019[/TD]
[TD="align: center"]6/1/2019[/TD]

[TD="align: center"]1/1/2019[/TD]
[TD="align: center"]8/1/2019[/TD]

</tbody>

Sheet1​

When all data is in, you can filter the data by inspection dates; you could select to filter by the next tire inspection or by the next break inspection. I would add a column that calculates the earliest date for all inspections so you can filter all the inspections by date range.

To answer your question about getting data from one DB to another. I would create some macros to help with this or make some formulas on the Inspection Status DB. Your Inspection History DB should be the master data set, IMO. You could go a couple ways. We can create formulas to find the last date of inspection for each inspection type. You could have a field on the Inspection Status DB that allows you to set the period of time between inspections, then simply calculate the next inspection date. Do you usually work in Months, Weeks, or Days?

Jeff

Hi Jeff,

Below is the type of layout that I refer to and this is only a part of it. Can you work with this?

Regards,

David
[TABLE="width: 872"]
<colgroup><col span="4"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Trailer[/TD]
[TD]Chassis No[/TD]
[TD]MOT date[/TD]
[TD]Year[/TD]
[TD]Tail Lift Lola Test[/TD]
[TD]Inspection Date[/TD]
[TD]Inspection Date[/TD]
[TD]Inspection Date[/TD]
[TD]Inspection Date[/TD]
[/TR]
[TR]
[TD]MTT100SB[/TD]
[TD]C312228[/TD]
[TD="align: right"]Feb-20[/TD]
[TD="align: right"]2010[/TD]
[TD][/TD]
[TD="align: right"]04/04/2019[/TD]
[TD="align: right"]16/05/2019[/TD]
[TD="align: right"]27/06/2019[/TD]
[TD="align: right"]08/08/2019[/TD]
[/TR]
[TR]
[TD]MTT02[/TD]
[TD]C241030[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]2007[/TD]
[TD][/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]26/04/2019[/TD]
[TD="align: right"]07/06/2019[/TD]
[TD="align: right"]19/07/2019[/TD]
[/TR]
[TR]
[TD]MTT20[/TD]
[TD]C300808[/TD]
[TD="align: right"]Jan-20[/TD]
[TD="align: right"]2012[/TD]
[TD][/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]19/08/2019[/TD]
[TD="align: right"]28/10/2019[/TD]
[/TR]
[TR]
[TD]MTT34[/TD]
[TD]C346051[/TD]
[TD="align: right"]Jul-19[/TD]
[TD="align: right"]2012[/TD]
[TD][/TD]
[TD="align: right"]04/03/2019[/TD]
[TD="align: right"]13/05/2019[/TD]
[TD="align: right"]22/07/2019[/TD]
[TD="align: right"]30/09/2019[/TD]
[/TR]
[TR]
[TD]MTT37[/TD]
[TD]C356564[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]2013[/TD]
[TD][/TD]
[TD="align: right"]15/04/2019[/TD]
[TD="align: right"]24/06/2019[/TD]
[TD="align: right"]02/09/2019[/TD]
[TD="align: right"]11/11/2019[/TD]
[/TR]
[TR]
[TD]MTT38[/TD]
[TD]C356563[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]2013[/TD]
[TD][/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]19/08/2019[/TD]
[TD="align: right"]28/10/2019[/TD]
[/TR]
[TR]
[TD]MTT41[/TD]
[TD]C361685[/TD]
[TD="align: right"]Feb-20[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]21/02/2019[/TD]
[TD="align: right"]02/05/2019[/TD]
[TD="align: right"]11/07/2019[/TD]
[TD="align: right"]19/09/2019[/TD]
[/TR]
[TR]
[TD]MTT42 (2020)[/TD]
[TD]C361720[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]19/03/2019[/TD]
[TD="align: right"]28/05/2019[/TD]
[TD="align: right"]06/08/2019[/TD]
[TD="align: right"]15/10/2019[/TD]
[/TR]
[TR]
[TD]MTT43[/TD]
[TD]C361681[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]10/04/2019[/TD]
[TD="align: right"]19/06/2019[/TD]
[TD="align: right"]28/08/2019[/TD]
[TD="align: right"]06/11/2019[/TD]
[/TR]
[TR]
[TD]MTT44[/TD]
[TD]C361682[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]04/02/2019[/TD]
[TD="align: right"]15/04/2019[/TD]
[TD="align: right"]24/06/2019[/TD]
[TD="align: right"]02/09/2019[/TD]
[/TR]
[TR]
[TD]MTT45[/TD]
[TD]C361721[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]28/02/2019[/TD]
[TD="align: right"]09/05/2019[/TD]
[TD="align: right"]18/07/2019[/TD]
[TD="align: right"]26/09/2019[/TD]
[/TR]
[TR]
[TD]MTT46[/TD]
[TD]C361684[/TD]
[TD="align: right"]Apr-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]10/04/2019[/TD]
[TD="align: right"]19/06/2019[/TD]
[TD="align: right"]28/08/2019[/TD]
[TD="align: right"]06/11/2019[/TD]
[/TR]
[TR]
[TD]MTT47[/TD]
[TD]C361683[/TD]
[TD="align: right"]Feb-20[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]12/02/2019[/TD]
[TD="align: right"]23/04/2019[/TD]
[TD="align: right"]02/07/2019[/TD]
[TD="align: right"]10/09/2019[/TD]
[/TR]
[TR]
[TD]MTT48[/TD]
[TD]C361680[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]06/05/2019[/TD]
[TD="align: right"]15/07/2019[/TD]
[TD="align: right"]23/09/2019[/TD]
[/TR]
[TR]
[TD]MTT49[/TD]
[TD]C361686[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]15/05/2019[/TD]
[TD="align: right"]24/07/2019[/TD]
[TD="align: right"]02/10/2019[/TD]
[/TR]
[TR]
[TD]MTT50[/TD]
[TD]C361687[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]04/03/2019[/TD]
[TD="align: right"]13/05/2019[/TD]
[TD="align: right"]22/07/2019[/TD]
[TD="align: right"]30/09/2019[/TD]
[/TR]
[TR]
[TD]MTT51[/TD]
[TD]C253752[/TD]
[TD="align: right"]Aug-19[/TD]
[TD="align: right"]2008[/TD]
[TD][/TD]
[TD="align: right"]25/03/2019[/TD]
[TD="align: right"]06/05/2019[/TD]
[TD="align: right"]17/06/2019[/TD]
[TD="align: right"]29/07/2019[/TD]
[/TR]
[TR]
[TD]MTT52[/TD]
[TD]C253755[/TD]
[TD="align: right"]Jul-19[/TD]
[TD="align: right"]2008[/TD]
[TD][/TD]
[TD="align: right"]19/03/2019[/TD]
[TD="align: right"]30/04/2019[/TD]
[TD="align: right"]11/06/2019[/TD]
[TD="align: right"]23/07/2019[/TD]
[/TR]
[TR]
[TD]MTT53[/TD]
[TD]C253753[/TD]
[TD="align: right"]Aug-19[/TD]
[TD="align: right"]2008[/TD]
[TD][/TD]
[TD="align: right"]18/03/2019[/TD]
[TD="align: right"]29/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]22/07/2019[/TD]
[/TR]
[TR]
[TD]MTT68[/TD]
[TD]C374154[/TD]
[TD="align: right"]Sep-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]19/08/2019[/TD]
[TD="align: right"]28/10/2019[/TD]
[/TR]
[TR]
[TD]MTT69[/TD]
[TD]C374155[/TD]
[TD="align: right"]Sep-19[/TD]
[TD="align: right"]2014[/TD]
[TD][/TD]
[TD="align: right"]22/04/2019[/TD]
[TD="align: right"]01/07/2019[/TD]
[TD="align: right"]09/09/2019[/TD]
[TD="align: right"]18/11/2019[/TD]
[/TR]
[TR]
[TD]MTT58DD[/TD]
[TD]C234717[/TD]
[TD="align: right"]Nov-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]21/01/2019[/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]19/08/2019[/TD]
[/TR]
[TR]
[TD]MTT72DD[/TD]
[TD]C234723[/TD]
[TD="align: right"]Sep-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]26/03/2019[/TD]
[TD="align: right"]04/06/2019[/TD]
[TD="align: right"]13/08/2019[/TD]
[TD="align: right"]22/10/2019[/TD]
[/TR]
[TR]
[TD]MTT76DD[/TD]
[TD]C234733[/TD]
[TD="align: right"]Nov-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]15/03/2019[/TD]
[TD="align: right"]24/05/2019[/TD]
[TD="align: right"]02/08/2019[/TD]
[TD="align: right"]11/10/2019[/TD]
[/TR]
[TR]
[TD]MTT79DD[/TD]
[TD]C300575[/TD]
[TD="align: right"]Oct-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25/04/2019[/TD]
[TD="align: right"]04/07/2019[/TD]
[TD="align: right"]12/09/2019[/TD]
[TD="align: right"]21/11/2019[/TD]
[/TR]
[TR]
[TD]MTT80DD[/TD]
[TD]C301387[/TD]
[TD="align: right"]Nov-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]08/01/2019[/TD]
[TD="align: right"]19/03/2019[/TD]
[TD="align: right"]28/05/2019[/TD]
[TD="align: right"]06/08/2019[/TD]
[/TR]
[TR]
[TD]MTT81DD[/TD]
[TD]C303015[/TD]
[TD="align: right"]Jun-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]09/01/2019[/TD]
[TD="align: right"]20/03/2019[/TD]
[TD="align: right"]29/05/2019[/TD]
[TD="align: right"]07/08/2019[/TD]
[/TR]
[TR]
[TD]MTT82DD[/TD]
[TD]C303027[/TD]
[TD="align: right"]Aug-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]20/05/2019[/TD]
[TD="align: right"]29/07/2019[/TD]
[TD="align: right"]07/10/2019[/TD]
[/TR]
[TR]
[TD]MTT83DD[/TD]
[TD]C303038[/TD]
[TD="align: right"]Mar-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16/03/2019[/TD]
[TD="align: right"]25/05/2019[/TD]
[TD="align: right"]03/08/2019[/TD]
[TD="align: right"]12/10/2019[/TD]
[/TR]
[TR]
[TD]MTT84DD[/TD]
[TD]C301089[/TD]
[TD="align: right"]Mar-20[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/03/2019[/TD]
[TD="align: right"]12/05/2019[/TD]
[TD="align: right"]21/07/2019[/TD]
[TD="align: right"]29/09/2019[/TD]
[/TR]
[TR]
[TD]MTT86DD[/TD]
[TD]C303028[/TD]
[TD="align: right"]Jun-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]07/03/2019[/TD]
[TD="align: right"]16/05/2019[/TD]
[TD="align: right"]25/07/2019[/TD]
[TD="align: right"]03/10/2019[/TD]
[/TR]
[TR]
[TD]MTT87DD[/TD]
[TD]C301249[/TD]
[TD="align: right"]Nov-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11/03/2019[/TD]
[TD="align: right"]20/05/2019[/TD]
[TD="align: right"]29/07/2019[/TD]
[TD="align: right"]07/10/2019[/TD]
[/TR]
[TR]
[TD]MTT88DD[/TD]
[TD]C301400[/TD]
[TD="align: right"]Jul-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]27/02/2019[/TD]
[TD="align: right"]08/05/2019[/TD]
[TD="align: right"]17/07/2019[/TD]
[TD="align: right"]25/09/2019[/TD]
[/TR]
[TR]
[TD]MTT89DD[/TD]
[TD]C303017[/TD]
[TD="align: right"]May-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]19/08/2019[/TD]
[TD="align: right"]28/10/2019[/TD]
[/TR]
[TR]
[TD]MTT90DD[/TD]
[TD]C303021[/TD]
[TD="align: right"]Jul-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11/04/2019[/TD]
[TD="align: right"]20/06/2019[/TD]
[TD="align: right"]29/08/2019[/TD]
[TD="align: right"]07/11/2019[/TD]
[/TR]
[TR]
[TD]MTT91DD[/TD]
[TD]C303055[/TD]
[TD="align: right"]Jul-19[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]27/03/2019[/TD]
[TD="align: right"]05/06/2019[/TD]
[TD="align: right"]14/08/2019[/TD]
[TD="align: right"]23/10/2019[/TD]
[/TR]
[TR]
[TD]MTT92SK[/TD]
[TD]C390485[/TD]
[TD="align: right"]Feb-20[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]12/02/2019[/TD]
[TD="align: right"]23/04/2019[/TD]
[TD="align: right"]02/07/2019[/TD]
[TD="align: right"]10/09/2019[/TD]
[/TR]
[TR]
[TD]MTT93SK[/TD]
[TD]C390488[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]15/05/2019[/TD]
[TD="align: right"]24/07/2019[/TD]
[TD="align: right"]02/10/2019[/TD]
[/TR]
[TR]
[TD]MTT94SK[/TD]
[TD]C390487[/TD]
[TD="align: right"]Mar-20[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]14/03/2019[/TD]
[TD="align: right"]23/05/2019[/TD]
[TD="align: right"]01/08/2019[/TD]
[TD="align: right"]10/10/2019[/TD]
[/TR]
[TR]
[TD]MTT95SK[/TD]
[TD]C390486[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]15/01/2019[/TD]
[TD="align: right"]26/03/2019[/TD]
[TD="align: right"]04/06/2019[/TD]
[TD="align: right"]13/08/2019[/TD]
[/TR]
[TR]
[TD]MTT96SK[/TD]
[TD]C390489[/TD]
[TD="align: right"]Feb-20[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]06/02/2019[/TD]
[TD="align: right"]17/04/2019[/TD]
[TD="align: right"]26/06/2019[/TD]
[TD="align: right"]04/09/2019[/TD]
[/TR]
[TR]
[TD]MTT97SK[/TD]
[TD]C390490[/TD]
[TD="align: right"]Jan-20[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]29/01/2019[/TD]
[TD="align: right"]09/04/2019[/TD]
[TD="align: right"]18/06/2019[/TD]
[TD="align: right"]27/08/2019[/TD]
[/TR]
[TR]
[TD]MTT98SB[/TD]
[TD]C391894[/TD]
[TD="align: right"]Jun-19[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]13/03/2019[/TD]
[TD="align: right"]22/05/2019[/TD]
[TD="align: right"]31/07/2019[/TD]
[TD="align: right"]09/10/2019[/TD]
[/TR]
[TR]
[TD]MTT99SC[/TD]
[TD]C385981[/TD]
[TD="align: right"]Jun-19[/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD="align: right"]06/03/2019[/TD]
[TD="align: right"]15/05/2019[/TD]
[TD="align: right"]24/07/2019[/TD]
[TD="align: right"]02/10/2019[/TD]
[/TR]
[TR]
[TD]S1[/TD]
[TD]C187979[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]22/04/2019[/TD]
[TD="align: right"]03/06/2019[/TD]
[TD="align: right"]15/07/2019[/TD]
[TD="align: right"]26/08/2019[/TD]
[/TR]
[TR]
[TD]S2[/TD]
[TD]C187980[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]29/04/2019[/TD]
[TD="align: right"]10/06/2019[/TD]
[TD="align: right"]22/07/2019[/TD]
[TD="align: right"]02/09/2019[/TD]
[/TR]
[TR]
[TD]S3[/TD]
[TD]C187984[/TD]
[TD="align: right"]Jul-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]01/04/2019[/TD]
[TD="align: right"]13/05/2019[/TD]
[TD="align: right"]24/06/2019[/TD]
[TD="align: right"]05/08/2019[/TD]
[/TR]
[TR]
[TD]S5[/TD]
[TD]C187986[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]14/03/2019[/TD]
[TD="align: right"]25/04/2019[/TD]
[TD="align: right"]06/06/2019[/TD]
[TD="align: right"]18/07/2019[/TD]
[/TR]
[TR]
[TD]S6[/TD]
[TD]C187987[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]26/03/2019[/TD]
[TD="align: right"]07/05/2019[/TD]
[TD="align: right"]18/06/2019[/TD]
[TD="align: right"]30/07/2019[/TD]
[/TR]
[TR]
[TD]S7[/TD]
[TD]C187988[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]29/03/2019[/TD]
[TD="align: right"]10/05/2019[/TD]
[TD="align: right"]21/06/2019[/TD]
[TD="align: right"]02/08/2019[/TD]
[/TR]
[TR]
[TD]S8[/TD]
[TD]C187990[/TD]
[TD="align: right"]Dec-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]23/04/2019[/TD]
[TD="align: right"]04/06/2019[/TD]
[TD="align: right"]16/07/2019[/TD]
[TD="align: right"]27/08/2019[/TD]
[/TR]
[TR]
[TD]S10[/TD]
[TD]C187992[/TD]
[TD="align: right"]Dec-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]09/02/2019[/TD]
[TD="align: right"]23/03/2019[/TD]
[TD="align: right"]04/05/2019[/TD]
[TD="align: right"]15/06/2019[/TD]
[/TR]
[TR]
[TD]S14[/TD]
[TD]C188606[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]22/04/2019[/TD]
[TD="align: right"]03/06/2019[/TD]
[TD="align: right"]15/07/2019[/TD]
[TD="align: right"]26/08/2019[/TD]
[/TR]
[TR]
[TD]S15[/TD]
[TD]C188607[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]2005[/TD]
[TD][/TD]
[TD="align: right"]26/03/2019[/TD]
[TD="align: right"]07/05/2019[/TD]
[TD="align: right"]18/06/2019[/TD]
[TD="align: right"]30/07/2019[/TD]
[/TR]
[TR]
[TD]SB2001[/TD]
[TD]C292703[/TD]
[TD="align: right"]Aug-19[/TD]
[TD="align: right"]2009[/TD]
[TD][/TD]
[TD="align: right"]14/01/2019[/TD]
[TD="align: right"]25/02/2019[/TD]
[TD="align: right"]08/04/2019[/TD]
[TD="align: right"]20/05/2019[/TD]
[/TR]
[TR]
[TD]SB2002[/TD]
[TD]C292704[/TD]
[TD="align: right"]Aug-19[/TD]
[TD="align: right"]2009[/TD]
[TD][/TD]
[TD="align: right"]22/02/2019[/TD]
[TD="align: right"]05/04/2019[/TD]
[TD="align: right"]17/05/2019[/TD]
[TD="align: right"]28/06/2019[/TD]
[/TR]
[TR]
[TD]SB2003[/TD]
[TD]C292708[/TD]
[TD="align: right"]Sep-19[/TD]
[TD="align: right"]2009[/TD]
[TD][/TD]
[TD="align: right"]02/04/2019[/TD]
[TD="align: right"]14/05/2019[/TD]
[TD="align: right"]25/06/2019[/TD]
[TD="align: right"]06/08/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[David Jones]

Hi Jeff,

I forgot to mention that inspection dates vary according to the age of the trailer. So dates range from 6 weekly to 10 weekly inspections. Some are even at 12 weeks (Hire trailers).

Kind regards,

David

 

[Jeffrey Mahoney]

David,

What are the 4 different columns of inspection dates?

Jeff

 

[Jeffrey Mahoney]

I tried to paste the data into Excel. Not a good format. Have you looked at the forum tools you can download? I use the Mr Excel HTML Maker to copy worksheet data. Very easy to use.