Good Day,
I am new on the forum and would like help with an excel sheet I am working on.
I have various jobs done on a daily basis and each day is represented on a sheet, with the whole month as a workbook.
At the end of the month I have to create a summary of the activities carried out each day.
I have a several formulas on the summary sheet.
I need a way to quickly fill in the formula for the rest of the column if I have the formula on the first column.
I have attached a sample for January 2020.
Alternatively,
If their is a quicker way to achieve the same result, I am open to ideas.
I am new on the forum and would like help with an excel sheet I am working on.
I have various jobs done on a daily basis and each day is represented on a sheet, with the whole month as a workbook.
At the end of the month I have to create a summary of the activities carried out each day.
I have a several formulas on the summary sheet.
I need a way to quickly fill in the formula for the rest of the column if I have the formula on the first column.
I have attached a sample for January 2020.
Alternatively,
If their is a quicker way to achieve the same result, I am open to ideas.
Jan 2020.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | PREVENTINE MAINTENANCE WORK ORDER | ||||||||||
2 | Domain | Code | Label | Type | Site | Building | Status | Uploaded | Comment | ||
3 | HVAC | 228238 | Task PM FCU(3M) on 18FCUFLAT | PM | ECT1 | T1 | Closed | Yes | |||
4 | HVAC | 228234 | Task PM FCU(3M) on 18FCUT06B | PM | ECT1 | T1 | Closed | Yes | |||
5 | HVAC | 228230 | Task PM FCU(3M) on 18FCUT2F | PM | ECT1 | T1 | Closed | Yes | |||
6 | HVAC | 228226 | Task PM FCU(3M) on 18FCUT2E | PM | ECT1 | T1 | Closed | Yes | |||
7 | HVAC | 228222 | Task PM FCU(3M) on 18FCUT2D | PM | ECT1 | T1 | Closed | Yes | |||
8 | HVAC | 228218 | Task PM FCU(3M) on 18FCUT2C | PM | ECT1 | T1 | Closed | Yes | |||
9 | HVAC | 228214 | Task PM FCU(3M) on 18FCUT2B | PM | ECT1 | T1 | Closed | Yes | |||
10 | HVAC | 228210 | Task PM FCU(3M) on 18FCUT2A | PM | ECT1 | T1 | Closed | Yes | |||
11 | HVAC | 228206 | Task PM FCU(3M) on 18FCUT01 | PM | ECT1 | T1 | Closed | Yes | |||
12 | HVAC | 228202 | Task PM FCU(3M) on 18FCUT06A | PM | ECT1 | T1 | Closed | Yes | |||
13 | HVAC | 228198 | Task PM FCU(3M) on 18FCUT05 | PM | ECT1 | T1 | Closed | Yes | |||
14 | HVAC | 228194 | Task PM FCU(3M) on 18FCUT04 | PM | ECT1 | T1 | Closed | Yes | |||
15 | HVAC | 228190 | Task PM FCU(3M) on 18FCUT03 | PM | ECT1 | T1 | Closed | Yes | |||
16 | PLUMB | 227329 | DAILY CHECK LIST/SERVICE TOILET( DAY ... | PM | ECT1 | T1 | Closed | Yes | |||
17 | CIVIL | 223379 | Task PM WC CUBICLES on 14ALLRMWCUBICL... | PM | ECT1 | T1 | Closed | Yes | |||
18 | CIVIL | 223358 | Task PM WC CUBICLES on 16ALLRMWCUBIC... | PM | ECT1 | T1 | Closed | Yes | |||
19 | CIVIL | 209839 | DAILY CHECK ON DOORS - 01/01/2020 | PM | ECT1 | T1 | Closed | No | |||
20 | LIGHTS | 209384 | DAILY MAINTENANCE OF LIGHTING FITTING... | PM | ECT1 | T1 | Closed | No | |||
21 | LIGHTS | 209014 | DAILY MAINTENANCE OF LIGHTING FITTING... | PM | ECT1 | T1 | Closed | No | |||
22 | PLUMB | 208462 | DS ON WATER TREATMENT PLANT - 01/01/2020 | PM | ECT1 | T1 | Closed | Yes | |||
23 | PLUMB | 207809 | DAILY CHECK OF TECHNICAL EQUIP(PLUMB)... | PM | ECT1 | T1 | Closed | Yes | |||
24 | ELECT | 206905 | OPERATION CHECK LIST FOR MDB TECHNICA... | PM | ECT1 | T1 | Closed | Yes | |||
25 | MLTDOM | 206540 | DAILY MDB CHECKLIST NIGHT - 01/01/2020 | PM | ECT1 | T1 | Closed | Yes | |||
26 | HVAC | 205118 | Task PM-PRECISION A/C(m) on PAU10FDC04 | PM | ECT1 | T1 | Closed | Yes | |||
27 | HVAC | 205117 | Task PM-PRECISION A/C(m) on PAU10FDC03 | PM | ECT1 | T1 | Closed | Yes | |||
28 | HVAC | 205116 | Task PM-PRECISION A/C(m) on PAU10FDC02 | PM | ECT1 | T1 | Closed | Yes | |||
29 | CIVIL | 205115 | Task PM CEILING on 01ALLRMACCOUSTICEIL | PM | ECT1 | T1 | Closed | Yes | |||
30 | CIVIL | 205114 | Task PM CEILING on ACCOUSTICEILING | PM | ECT1 | T1 | Closed | No | |||
31 | HVAC | 205113 | Task PM-PRECISION A/C(m) on PAU10FDC01 | PM | ECT1 | T1 | Closed | Yes | |||
32 | HS | 205112 | Task PM-SMOKE DETECTORS on 17ALLRMSMKDT | PM | ECT1 | T1 | Closed | No | |||
33 | ELECT | 205108 | Task PM-ELECT BOARDS on 10F-C01-LP | PM | ECT1 | T1 | Closed | Yes | |||
34 | ELECT | 205107 | Task PM-ELECT BOARDS on RF-C01-LP | PM | ECT1 | T1 | Closed | Yes | |||
35 | PLUMB | 205099 | Task PM-PLUMBING FIXTURES on 01-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
36 | PLUMB | 205098 | Task PM-PLUMBING FIXTURES on GF-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
37 | PLUMB | 205097 | Task PM-PLUMBING FIXTURES on BA-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
38 | HVAC | 205085 | Task PM-PRECISION A/C(m) on PAU3FDC04 | PM | ECT1 | T1 | Closed | Yes | |||
39 | CIVIL | 205084 | Task PM CEILING on BAALLRMACCOUSTICEIL | PM | ECT1 | T1 | Closed | Yes | |||
40 | CIVIL | 161127 | CHECK ON KITCHEN DOORS AND CABINETS -... | PM | ECT1 | T1 | Closed | No | |||
41 | |||||||||||
Jan 1 |
Jan 2020.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | PREVENTINE MAINTENANCE WORK ORDER | ||||||||||
2 | Domain | Code | Label | Type | Site | Building | Status | Uploaded | Comment | ||
3 | HVAC | 228799 | Task PM FCU(3M) on 08FCUT06B | PM | ECT1 | T1 | Closed | Yes | |||
4 | HVAC | 228795 | Task PM FCU(3M) on 08FCUT04 | PM | ECT1 | T1 | Closed | Yes | |||
5 | HVAC | 228791 | Task PM FCU(3M) on 08FCUT2C | PM | ECT1 | T1 | Closed | Yes | |||
6 | HVAC | 228787 | Task PM FCU(3M) on 08FCUT2B | PM | ECT1 | T1 | Closed | Yes | |||
7 | HVAC | 228783 | Task PM FCU(3M) on 08FCUT2E | PM | ECT1 | T1 | Closed | Yes | |||
8 | HVAC | 228779 | Task PM FCU(3M) on 08FCUT2F | PM | ECT1 | T1 | Closed | Yes | |||
9 | HVAC | 228775 | Task PM FCU(3M) on 08FCUT03 | PM | ECT1 | T1 | Closed | Yes | |||
10 | HVAC | 228771 | Task PM FCU(3M) on 08FCUT05 | PM | ECT1 | T1 | Closed | Yes | |||
11 | HVAC | 228767 | Task PM FCU(3M) on 08FCUT06A | PM | ECT1 | T1 | Closed | Yes | |||
12 | HVAC | 228763 | Task PM FCU(3M) on 08FCUT1A | PM | ECT1 | T1 | Closed | Yes | |||
13 | HVAC | 228759 | Task PM FCU(3M) on 08FCUT2A | PM | ECT1 | T1 | Closed | Yes | |||
14 | HVAC | 228755 | Task PM FCU(3M) on 08FCUT1B | PM | ECT1 | T1 | Closed | Yes | |||
15 | HVAC | 228250 | Task PM FCU(3M) on 08FCUT2D | PM | ECT1 | T1 | Closed | Yes | |||
16 | PLUMB | 227330 | DAILY CHECK LIST/SERVICE TOILET( DAY ... | PM | ECT1 | T1 | Closed | Yes | |||
17 | CIVIL | 223392 | Task PM WC CUBICLES on 01ALLRMWCUBICL... | PM | ECT1 | T1 | Closed | Yes | |||
18 | LIGHTS | 209417 | DAILY MAINTENANCE OF LIGHTING FITTING... | PM | ECT1 | T1 | Closed | Yes | |||
19 | LIGHTS | 209045 | DAILY MAINTENANCE OF LIGHTING FITTING... | PM | ECT1 | T1 | Closed | Yes | |||
20 | PLUMB | 208463 | DS ON WATER TREATMENT PLANT - 02/01/2020 | PM | ECT1 | T1 | Closed | Yes | |||
21 | PLUMB | 207810 | DAILY CHECK OF TECHNICAL EQUIP(PLUMB)... | PM | ECT1 | T1 | Closed | Yes | |||
22 | ELECT | 206906 | OPERATION CHECK LIST FOR MDB TECHNICA... | PM | ECT1 | T1 | Closed | Yes | |||
23 | MLTDOM | 206541 | DAILY MDB CHECKLIST NIGHT - 02/01/2020 | PM | ECT1 | T1 | Closed | Yes | |||
24 | ELECT | 205160 | Task PM - THERMOGRAPHY INSPECTION on TR3 | PM | ECT1 | T1 | Closed | Yes | |||
25 | ELECT | 205159 | Task PM - THERMOGRAPHY INSPECTION on TR2 | PM | ECT1 | T1 | Closed | Yes | |||
26 | ELECT | 205158 | Task PM - THERMOGRAPHY INSPECTION on TR1 | PM | ECT1 | T1 | Closed | Yes | |||
27 | CIVIL | 205152 | Task PM CEILING on 02ALLRMACCOUSTICEIL | PM | ECT1 | T1 | Closed | Yes | |||
28 | HS | 205151 | Task PM-SMOKE DETECTORS on 15ALLRMSMKDT | PM | ECT1 | T1 | Closed | Yes | |||
29 | HS | 205150 | Task PM-SMOKE DETECTORS on 16ALLRMSMKDT | PM | ECT1 | T1 | Closed | Yes | |||
30 | ELECT | 205149 | Task PM ON AUTOMATIC EXIT GATE on EXI... | PM | ECT1 | T1 | Closed | No | |||
31 | LIGHTS | 205146 | Task PM EMERGENCY LIGHT FITTINGS(M) o... | PM | ECT1 | T1 | Closed | No | |||
32 | LIGHTS | 205145 | Task PM EMERGENCY LIGHT FITTINGS(M) o... | PM | ECT1 | T1 | Closed | No | |||
33 | ELECT | 205144 | Task PM-ELECT BOARDS on 12F-C01-LP | PM | ECT1 | T1 | Closed | Yes | |||
34 | ELECT | 205143 | Task PM-ELECT BOARDS on 11F-C01-LP | PM | ECT1 | T1 | Closed | Yes | |||
35 | HVAC | 205140 | Task PM-PRECISION A/C(m) on PAU10FMTC04 | PM | ECT1 | T1 | Closed | Yes | |||
36 | PLUMB | 205139 | Task PM-PLUMBING FIXTURES on 05-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
37 | PLUMB | 205138 | Task PM-PLUMBING FIXTURES on 04-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
38 | PLUMB | 205137 | Task PM-PLUMBING FIXTURES on 03-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
39 | PLUMB | 205136 | Task PM-PLUMBING FIXTURES on 02-FPLUM... | PM | ECT1 | T1 | Closed | Yes | |||
40 | CIVIL | 205123 | Task METALLICIELING on 02ALLRMMETALLI... | PM | ECT1 | T1 | Closed | Yes | |||
41 | CIVIL | 205122 | Task METALLICIELING on 01ALLRMMETALLI... | PM | ECT1 | T1 | Closed | Yes | |||
42 | HVAC | 205121 | Task PM-PRECISION A/C(m) on PAU10FMTC03 | PM | ECT1 | T1 | Closed | Yes | |||
43 | HVAC | 205120 | Task PM-PRECISION A/C(m) on PAU10FMTC02 | PM | ECT1 | T1 | Closed | Yes | |||
44 | HVAC | 205119 | Task PM-PRECISION A/C(m) on PAU10FMTC01 | PM | ECT1 | T1 | Closed | Yes | |||
45 | |||||||||||
46 | |||||||||||
47 | OTHER MAINTENANCE WORK ORDERS | ||||||||||
48 | Domain | Code | Label | Type | Site | Building | Status | Uploaded | Comment | ||
49 | HVAC | 303915 | NOISY AC VENT | TI | ECT1 | T1 | Closed | Yes | |||
50 | HVAC | 303913 | NOISY AC VENT | TI | ECT1 | T1 | Closed | Yes | |||
51 | HVAC | 303912 | A/C NOT COOLING | TI | ECT1 | T1 | Closed | Yes | |||
52 | PLUMB | 303911 | WATER RUNNING NON STOP | TI | ECT1 | T1 | Closed | Yes | |||
53 | ELECT | 303908 | LIGHT ISSUE | TI | ECT1 | T1 | Closed | No | |||
54 | HVAC | 303907 | AC TOO COLD | TI | ECT1 | T1 | Closed | No | |||
55 | CIVIL | 303899 | WATER LEAKAGE ON GF SICKBAY TOILET | CM | ECT1 | T1 | Closed | No | |||
56 | CIVIL | 301093 | FAULTY TISSUE HOLDER | CM | ECT1 | T1 | Closed | No | |||
57 | CIVIL | 206180 | DAILY WASTE DISPOSAL - 02/01/2020 | DS | ECT1 | T1 | Closed | No | |||
Jan 2 |
01-Jan | 02-Jan | 03-Jan | 04-Jan | 05-Jan | 06-Jan | 07-Jan | 08-Jan | 09-Jan | 10-Jan | 11-Jan | 12-Jan | 13-Jan | 14-Jan | 15-Jan | 16-Jan | 17-Jan | 18-Jan | 19-Jan | 20-Jan | 21-Jan | 22-Jan | 23-Jan | 24-Jan | 25-Jan | 26-Jan | 27-Jan | 28-Jan | 29-Jan | 30-Jan | 31-Jan | ||
PM | TOTAL | |||||||||||||||||||||||||||||||
TOTAL | 38 | 42 | 80 | |||||||||||||||||||||||||||||
Uploaded | 32 | 39 | 71 | |||||||||||||||||||||||||||||
Not-Uploaded | 6 | 3 | 9 | |||||||||||||||||||||||||||||
CM & Others | ||||||||||||||||||||||||||||||||
TOTAL | 0 | 9 | 9 | |||||||||||||||||||||||||||||
Uploaded | 0 | 4 | 4 | |||||||||||||||||||||||||||||
Not-Uploaded | 0 | 5 | 5 | |||||||||||||||||||||||||||||