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.
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
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.
Oct-18 | Nov-18 | Dec-18 | Jan-19 | Feb-19 | ||
Monthly | mechanicals | 06/10/2018 | 07/11/2018 | 06/12/2018 | 07/01/2019 | 07/02/2019 |
field size with ICP | ||||||
MLC QA | ||||||
photon output & energy | ||||||
photon gun-peaking ("checked" or "re-peaked") (and which energies) | ||||||
photon flatness & symmetry | ||||||
electron output | ||||||
XVI kV output & 2D image quality | ||||||
iView 2D image quality & Scaling | ||||||
XVI presets volume.ini batch-file check | ||||||
Review of Daily QA in ATLAS | ||||||
SABR Winston-Lutz Test | ||||||
Source Store Check (no. of sources) |
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>