Spreadsheet: 550333d1512229344-needing-help-creating-a-template-for-hospital-equipment-uptime-biomed
Sheet: Sheet1

 | CHAZ REGIONAL HOSPITAL - Biomedial Engineering
 |  | Monthly Reporting
 | 2017-12-17 00:00:00
 | Linear Accelerator #1 | 1st Occurrence | 2nd Occurrence | 3rd Occurrence | 4th Occurrence | 5th Occurrence |  | Individual Monthly Totals |  |  |  | All Equipment Monthly Totals
 | Downtime | 2017-11-27 10:00:00 | 2017-11-27 14:00:00 | 2017-11-29 14:00:00
 | Uptime | 2017-11-28 09:00:00 | 2017-12-01 19:30:00 | 2017-12-01 19:30:00
 | Total |  |  |  |  |  |  | Down Time |  |  |  | Down Time :
 | Repair Time Total | 6.5 | 8.75 |  |  |  |  | Repair Time
 | Repair Cost Total | 525.33 | 235.41 |  |  |  |  | Cost Total |  |  |  | Repair Time :
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 |  |  |  |  |  |  |  |  |  |  |  | Repair Costs :
 | Linear Accelerator #2
 | Downtime |  |  |  |  |  |  |  |  |  |  | Wait Time :
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time |  |  |  | Instructions
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time |  |  |  | Only edit non-tinted cells. All other
 |  |  |  |  |  |  |  |  |  |  |  | cells may contain formulas that
 | Linear Accelerator #3 |  |  |  |  |  |  |  |  |  |  | should not be changed.
 | Downtime
 | Uptime |  |  |  |  |  |  |  |  |  |  | Edit monthly title (B3) with format of
 | Total |  |  |  |  |  |  | Down Time |  |  |  | [NAME]/dd/yyyy (ex: 01/01/2018).
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total |  |  |  | To copy this sheet as a TEMPLATE to
 | Patient Wait Times |  |  |  |  |  |  | Wait Time |  |  |  | another sheet … click 'arrow cell' above
 |  |  |  |  |  |  |  |  |  |  |  | #1 and left of A (upper left). This will
 | CT Scanner #1 |  |  |  |  |  |  |  |  |  |  | highlight all cells. Right click any cell,
 | Downtime |  |  |  |  |  |  |  |  |  |  | select COPY. Select new sheet,
 | Uptime |  |  |  |  |  |  |  |  |  |  | click A1, click PASTE. Clear all
 | Total |  |  |  |  |  |  | Down Time |  |  |  | non-tinted cells (new sheet) of data.
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | CT Scanner #2
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | Gamma Knife #1
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | HDR After Loader #1
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time
 | Downtime
 | Uptime
 | Total |  |  |  |  |  |  | Down Time
 | Repair Time Total |  |  |  |  |  |  | Repair Time
 | Repair Cost Total |  |  |  |  |  |  | Cost Total
 | Patient Wait Times |  |  |  |  |  |  | Wait Time