Morning Excellers,
I have a sheets used for tracking tests done regularly at 12 centres (monthly, quarterly and yearly tests). I want to make a audit page that will check tasks have been done within allowed timeframes. Ideally this would be come automated but for now a manual approach would suffice. Below is a sample of what the sheet looks like. Each sheet is identical except for the date o completion. I would like to be able to call up say the last years data (not attached to the time frame) and have some form of formatting happen if dates are out. In the example below tasks should be done every 28 days and have a limit of 35 days. What do people think? All help is greatly appreciated.
[TABLE="width: 1106"]
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Oct-18[/TD]
[TD="align: right"]Nov-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD="align: right"]Jan-19[/TD]
[TD="align: right"]Feb-19[/TD]
[/TR]
[TR]
[TD]Monthly[/TD]
[TD]mechanicals[/TD]
[TD="align: right"]06/10/2018[/TD]
[TD="align: right"]07/11/2018[/TD]
[TD="align: right"]06/12/2018[/TD]
[TD="align: right"]07/01/2019[/TD]
[TD="align: right"]07/02/2019[/TD]
[/TR]
[TR]
[TD]field size with ICP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MLC QA [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]photon
output & energy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]photon gun-peaking
("checked" or "re-peaked")
(and which energies)[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]photon
flatness & symmetry[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]electron
output[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XVI
kV output
& 2D image quality[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]iView
2D image quality
& Scaling[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XVI presets volume.ini
batch-file check[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Review of Daily QA
in ATLAS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SABR
Winston-Lutz Test[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Source Store Check
(no. of sources)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a sheets used for tracking tests done regularly at 12 centres (monthly, quarterly and yearly tests). I want to make a audit page that will check tasks have been done within allowed timeframes. Ideally this would be come automated but for now a manual approach would suffice. Below is a sample of what the sheet looks like. Each sheet is identical except for the date o completion. I would like to be able to call up say the last years data (not attached to the time frame) and have some form of formatting happen if dates are out. In the example below tasks should be done every 28 days and have a limit of 35 days. What do people think? All help is greatly appreciated.
[TABLE="width: 1106"]
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]Oct-18[/TD]
[TD="align: right"]Nov-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD="align: right"]Jan-19[/TD]
[TD="align: right"]Feb-19[/TD]
[/TR]
[TR]
[TD]Monthly[/TD]
[TD]mechanicals[/TD]
[TD="align: right"]06/10/2018[/TD]
[TD="align: right"]07/11/2018[/TD]
[TD="align: right"]06/12/2018[/TD]
[TD="align: right"]07/01/2019[/TD]
[TD="align: right"]07/02/2019[/TD]
[/TR]
[TR]
[TD]field size with ICP[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MLC QA [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]photon
output & energy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]photon gun-peaking
("checked" or "re-peaked")
(and which energies)[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]photon
flatness & symmetry[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]electron
output[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XVI
kV output
& 2D image quality[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]iView
2D image quality
& Scaling[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XVI presets volume.ini
batch-file check[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Review of Daily QA
in ATLAS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SABR
Winston-Lutz Test[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Source Store Check
(no. of sources)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]