Spreadsheet: 264247d1378828527-extracting-and-sorting-data-from-source-worksheet-excel-2003-top-5-autosort-revised
Sheet: WOPL

Note:
Shorter name on [NAME] for easier linking to other Worksheets
Conditional formatting to turn Column P and Column Q "amber" is the Purpose Code (Column Q) is "SAH"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ranking!
Priority | Installation Name | Installation Number | Fiscal Year | Building Number | Yr Built | [NAME] | FCG | GSF | Q-Rating | F-Rating | DOL Division | Construction Type | HDR Assigned WO Number | Project/WO Number | Project Title/Short Job Description | Purpose Code | Purpose Points | Condition Code | Condition Points | Component Code | Group | Component Points | Project MCI | Building MCI | Total Points | Total Points (Hard Code) | Cost Estimate (ROM) | Funding Source | Comments
7 | Template | 8675309 | FY14 | 1277 | 2011 | 21855 | 21885 | 3750 | 2 | 2 | Maint | P | HT-00014 | E-00030 | replace receptacles | SAH |  | 1 |  | 07C |  |  | 4 | 8 |  | 42 | 1345789
10 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00010 | A-00026 | build partition | CMR |  | 1 |  | 07C |  |  | 8 | 6 |  | 41 | 9800
12 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00012 | A-00028 | install rails | SAH |  | 1 |  | 16A |  |  | 6 | 6 |  | 40 | 546678
16 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00007 | M-00023 | HVAC | CMR |  | 1 |  | 02J |  |  | 10 | 6 |  | 38 | 76589
20 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00011 | A-00027 | ADA bathrooms | SAH |  | 4 |  | 07C |  |  | 8 | 6 |  | 36 | 67899
21 | Template | 8675309 | FY14 | 1277 | 2011 | 21855 | 21885 | 3750 | 2 | 2 | Maint | P | HT-00013 | E-00029 | GFCI | SAH |  | 2 |  | 09A |  |  | 6 | 8 |  | 36 | 66789
28 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00009 | M-00025 | exhaust | CMR |  | 4 |  | 16A |  |  | 8 | 6 |  | 31 | 1234
29 | Template | 8675309 | FY14 | 1276 | 2011 | 21885 | 21885 | 15000 | 1 | 1 | Maint | P | HT-00008 | M-00024 | plumbing fixtures | CMR |  | 5 |  | 07D |  |  | 8 | 6 |  | 30 | 12345
26 | Template | 8675309 | FY14 | 7366 | 1973 | 61050 | 60000 | 3000 | 1 | 1 | PO | P | HT-00025 | A-00041 | remodel break room | MSN |  | 4 |  | 17A |  |  | 6 | 6 |  | 33 | 43567
1 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00001 | A-00017 | Build a wall | MSN |  | 1 |  | 07C |  |  | 10 | 10 |  | 50 | 220265
2 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | HT-00017 | A-00033 | remodel serving line | FIR |  | 1 |  | 07C |  |  | 10 | 8 |  | 48 | 42333
3 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | [NAME] | M-00035 | replace vent hoods | MSN |  | 1 |  | 17A | New Construction |  | 8 | 8 |  | 45 | 12678
4 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | HT-00016 | E-00032 | forklift charging station | FIR |  | 2 |  | 16A |  |  | 10 | 8 |  | 44 | 56444
5 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00004 | A-00020 | fix entrance | MMR |  | 1 |  | 07C |  |  | 4 | 10 |  | 42 | 12345
6 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00005 | E-00021 | GFCI | MMR |  | 1 |  | 15B |  |  | 6 | 10 |  | 42 | 3445
8 | Template | 8675309 | FY14 | 7368 | 1973 | 61050 | 60000 | 3000 | NA | 2 | SS | T | HT-00027 | E-00043 | GFCI | MSN |  | 1 |  | 16A |  |  | 8 | 6 |  | 42 | 4567890
9 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00002 | A-00018 | ADA bathrooms | MMR |  | 3 |  | 11B |  |  | 8 | 10 |  | 41 | 43556
11 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00006 | M-00022 | HVAC | MMR |  | 2 |  | 15B |  |  | 6 | 10 |  | 40 | 8675309
14 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | HT-00020 | M-00036 | install condensate capture | MSN |  | 2 |  | 02J |  |  | 8 | 8 |  | 39 | 15444
15 | Template | 8675309 | FY14 | 7368 | 1973 | 61050 | 60000 | 3000 | NA | 2 | SS | T | HT-00029 | A-00045 | fix entrance | MSN |  | 2 |  | 17A |  |  | 6 | 6 |  | 39 | 135790
17 | Template | 8675309 | FY14 | 1178 | 1942 | 44220 | 44210 | 9800 | 2 | 2 | SS | P | HT-00030 | M-00046 | HVAC | CMR |  | 1 |  | 15B |  |  | 8 | 4 |  | 37 | 23445
18 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | HT-00015 | E-00031 | replace board | FIR |  | 3 |  | 05A |  |  | 4 | 8 |  | 37 | 76889
19 | Template | 8675309 | FY14 | 1180 | 1942 | 44220 | 44210 | 11000 | 3 | 2 | SS | P | HT-00003 | A-00019 | replace windows | MMR |  | 2 |  | 09A |  |  | 6 | 10 |  | 36 | 1679003
23 | Template | 8675309 | FY14 | 4283 | 1975 | 72210 | 72200 | 4800 | 1 | 2 | SS | P | HT-00018 | M-00034 | HVAC | EQP |  | 5 |  | 07C |  |  | 8 | 8 |  | 34 | 11334
27 | Template | 8675309 | FY14 | 7368 | 1973 | 61050 | 60000 | 3000 | NA | 2 | SS | T | HT-00028 | E-00044 | replace board | SAH |  | 2 |  | 02J |  |  | 4 | 6 |  | 33 | 1123556
30 | Template | 8675309 | FY14 | 1179 | 1942 | 44220 | 44210 | 9800 | 2 | 2 | SS | P | HT-00024 | M-00040 | HVAC | QWL |  | 5 |  | 15C |  |  | 6 | 4 |  | 21 | 2456
13 | Template | 8675309 | FY14 | 1033 | 1918 | 14166 | 14163 | 800 | 4 | 4 | Trans | P | HT-00022 | A-00038 | fix entrance | MSN |  | 1 |  | 17A |  |  | 4 | 6 |  | 39 | 678
22 | Template | 8675309 | FY14 | 1033 | 1918 | 14166 | 14163 | 800 | 4 | 4 | Trans | P | HT-00023 | A-00039 | ADA bathrooms | MSN |  | 1 |  | 07B |  |  | 4 | 6 |  | 35 | 6678
24 | Template | 8675309 | FY14 | 7367 | 1973 | 61050 | 60000 | 3000 | 1 | 1 | Trans | P | HT-00026 | A-00042 | Build a wall | SAH |  | 3 |  | 17A | New Construction |  | 4 | 6 |  | 34 | 34222
25 | Template | 8675309 | FY14 | 1033 | 1918 | 14166 | 14163 | 800 | 4 | 4 | Trans | P | HT-00021 | M-00037 | HVAC | MSN |  | 5 |  | 07C |  |  | 6 | 6 |  | 33 | 87990