Spreadsheet: 71042d1271786684-vlookup-formula-with-match-march-meter-reads
Sheet: Links

Serial Number | Model | Location | Description | Room # | B/W Copy | B/W Print | B/W Volume | Color Copy | [NAME] | Color Volume | [NAME] | Fax Sent | Fax Receive | Network Scans
AGF422099 | 6204 | Kramer C | KRMC_220XP | 220 |  | 145285
AGF422146 | 6204 | 721 Barton Springs | 1st floor Rm 124 | 124 |  | 166063
BNB501601 | 721P | Kramer E | KRME_222XP | 222 |  | 919712
CXF033425 | 8560MFP | Kramer C | KRMC_213XC | 213 |  |  | 33252 | 28201
CXF033431 | 8560MFP | Kramer E | [NAME] | 102
CXF033630 | 8560MFP | Kramer E | KRME_101XC | 101 |  |  | 13151 | 6294
CXF034068 | 8560MFP | Kramer C | KRMC_110XC | 110 |  |  | 5543 | 10701
CXF034241 | 8560MFP | Kramer C | KRMC_226XC | 226 |  |  | 25945 | 29131
[NAME] | 8560MFP | 721 Barton Springs | 3rd Floor Call Center | 317 |  |  | 41031 | 21768
CXF300876 | 8560MFP | Kramer D | KRMD_304XC | 304 |  |  | 7780 | 13075
CXF300877 | 8560MFP | East Branch | EASTB_XC | office |  |  | 4516 | 11230
CXF300879 | 8560MFP | Kramer C | KRMC_112XC | 112 |  |  | 5150 | 8477
CXF334195 | 8560MFP | St. Elmo | STE_106XC | 106 |  |  | 45494 | 9646
CXF334224 | 8560MFP | 721 Barton Springs | Finance 5th Floor | 574 |  |  | 38522 | 26705
CXF334273 | 8560MFP | [NAME] | DKR_STEELYDXC | office |  |  | 6078 | 4638
FKA616117 | WC7345 | [NAME] | CICWASKOM | 200 | 131841 | 108066 | 239907 | 19317 | 60308 | 79625 | 3172 | 0 | 0
GAL100277 | 3200MFP | St. Elmo | STE_TREE TREAMING_3B | 3B
[NAME] | WCP 4150 | [NAME] | DKR_TRAINX | BLDG. 6 | 10826 | 28514 | 40514 |  |  |  | 123 | 529 | 1174
L99034829 | WCP 4150 | 811 Barton Springs | CIS Operations RM 802 | 200 | 32474 | 28828 | 61302 |  |  |  | 1098 | 0 | 0
L99037714 | WC4150 | Kramer C | KRME_ANXX | ANX. | 16794 | 6640 | 23435 |  |  |  | 1 | 1 | 1
L99041449 | WCP 4150 | DOMAIN | DOM_4150X | office | 3725 | 4818 | 8937 |  |  |  | 22 | 323 | 394
LBP241998 | 3635MFP | Sand hill | SHEC_TRL_X | Trl. | 1635 | 10888 | 12523 |  |  |  | 1069 | 1087 | 0
LBP242161 | 3635MFP | One Texas Center | OTC_175_X | 175 | 250 | 3045 | 5894 |  |  |  | 102 | 4801 | 2599
LBP244209 | 3635MFP | Decker | Purchasing | [NAME] | 2657 | 9737 | 14809 |  |  |  | 488 | 1311 | 2415
LBP244351 | 3635MFP | 721 Barton Springs | 4th floor | 409 | 3285 | 5765 | 9050 |  |  |  | 1232 | 2206
MDH000819G | 510 | 811 Barton Springs | [NAME] 601 | 601 |  | 48127
[NAME] | 510 | St. Elmo | STE_102XP | 102 |  | 139103
RYU331075 | M20i | [NAME] | HOL_CONTRMX | [NAME] |  |  | 5318
RYU331103 | M20i | [NAME] | DKR_WHSEX | Office |  |  | 16661
RYU331116 | M20i | Kramer D | KRMD_312X | 312 |  |  | 29121
RYU331120 | M20i | St. Elmo | STE_NETWORK_1 | 1A |  |  | 35075
[NAME] | M20i | Holly Maint Shop | HOL_MAINTSHP | Maint Shop |  |  | 15654
RYU331127 | M20i | 906 [NAME] | JUSTIN_XEROX1 | Office |  |  | 7864
RYU331128 | M20i | St. Elmo | STE_206X | 206 |  |  | 13838
RYU331572 | M20i | St. Elmo | [NAME] | 2A |  |  | 36860
RYU331589 | M20i | Kramer D | [NAME] | 1 |  |  | 107050
RYU331590 | M20i | 811 Barton Springs | Processing RM305 | 305 |  |  | 36845
RYU331592 | M20i | St. Elmo | STE_ADMINISTRATION_LOBBY_100X | Admin. |  |  | 90789
RYU331594 | M20i | [NAME] | DKR_TRIBLABX | Lab |  |  | 3241
RYU331596 | M20i | 721 Barton Springs |  | 126 |  |  | 33236
TFN049829 | WCP3545 | 811 Barton Springs | Power Production | 607 | 24543 | 59630 | 84173 | 5616 | 54705 | 60321 | 3058 | 656 | 0
TFN196336 | WCP 2636 | St. Elmo | STE_ADMINISTRATION_102 | 102 | 189034 | 196960 | 385994 | 16222 | 64308 | 80530 | 7157 | 1045 | 0
TFN196337 | WCP 2636 | [NAME] | SHEC_ADMINXC | File | 94355 | 184459 | 278816 | 8160 | 34539 | 42699 | 13613 | 2 | 2
TFN196338 | WCP 2636 | ECC RM249 | WST_249XC | 249 | 150586 | 211689 | 362275 | 15018 | 120915 | 135933 | 12545 | 1 | 0
TFN196375 | WCP 2636 | Kramer C | KRMC_BRKRMXC | Brkrm | 172410 | 90330 | 262742 | 9708 | 13224 | 22932 | 70838 | 580 | 2
TFN196408 | WCP 2636 | Holly Lab B | HOLLYLAB_BXC | St. Off | 39588 | 32777 | 72365 | 1159 | 2517 | 3676 | 1210 | 2 | 0
TFN196607 | WCP 2636 | Kramer C | KRMC_200XC | 200 | 83803 | 179644 | 263447 | 7415 | 68699 | 76114 | 5561 | 3860 | 0
TFN196615 | WCP 2636 | [NAME] X | HOLLYADMINXC | 106 | 36691 | 19460 | 56151 | 4303 | 11654 | 15957 | 724 | 938 | 0
TFN196616 | WCP 2636 | DOMAIN | DOM_CNTLRMXC | [NAME] | 26766 | 52949 | 79717 | 1564 | 23478 | 25042 | 9573 | 79 | 2
TFN196635 | WCP2636 | St. Elmo | STE_ADMINISTRATION_212 | 212 | 50763 | 113760 | 164523 | 14094 | 73646 | 87740 | 1980 | 1050 | 0
TFN196637 | WCP 2636 | Kramer E | KRME_2120XC_METERING SHOP | 2120 | 49122 | 105722 | 154844 | 805 | 22708 | 23513 | 7413 | 79 | 0
TFN196649 | WCP 2636 | Kramer C | KRMC_100XC_ADMIN | 100 | 60114 | 88962 | 149076 | 15834 | 17207 | 33041 | 4648 | 38 | 0
TFN196684 | WCP 2636 | Kramer E | KRME_222XC | 222 | 32518 | 89064 | 121582 | 2417 | 7990 | 10407 | 7129 | 80 | 0
TFN196691 | WCP 2636 | ECC RM 109 | WST_109XC | 116 | 111657 | 153323 | 264980 | 6927 | 60033 | 66960 | 2400 | 1 | 0
TFN196700 | WCP 2636 | ECC RM 043 | WST_043XC | 43 | 15232 | 56118 | 71350 | 816 | 31275 | 32091 | 916 | 642 | 0
TFN196858 | WCP 2636 | [NAME] | CAM_XEROX1 | 121 | 42982 | 103625 | 146609 | 26398 | 50649 | 77047 | 4800 | 88 | 2
TFN196878 | WCP 2636 | Kramer E | KRME_229XC | 229 | 51816 | 192196 | 244012 | 1570 | 27205 | 28775 | 5455 | 115 | 0
TFN201872 | WCP3545 | [NAME] | CICWATERLOO | 300 | 39260 | 44720 | 83980 | 2155 | 42859 | 45014 | 487 | 0
TFN690555 | WCP2636 | 721 Barton Springs | Administration RM 575 | 575 | 163210 | 357762 | 520978 | 30748 | 193680 | 224428 | 8937 | 340 | 6
TFN691868 | WCP2636 | 721 Barton Springs | Legal RM 506 | 506 | 198328 | 311509 | 510505 | 18424 | 99384 | 117808 | 11933 | 4563 | 668
TFN691935 | WCP2636 | 721 Barton Springs | Market Research RM 238 | 238 | 29836 | 172702 | 202538 | 21555 | 118628 | 140183 | 3923 | 8 | 0
TFN691936 | WCP2636 | 721 Barton Springs | Customer Care RM 306 | 306 | 33835 | 59106 | 92956 | 2909 | 19293 | 22202 | 531 | 22 | 15
[NAME] | WCP2636 | 721 Barton Springs | Power Production RM 243 | 243 | 76892 | 202076 | 278968 | 42352 | 187218 | 229570 | 7273 | 56 | 0
TFN692140 | WCP2636 | 721 Barton Springs | IT DDAS RM 429 | 429 | 102860 | 208709 | 311569 | 33224 | 113070 | 146294 | 3695 | 404 | 0
TFN692455 | WCP 2636 | [NAME] | MON_LDOCK_XC | load dock office | 78257 | 163586 | 241846 | 14908 | 82347 | 97255 | 7081 | 0 | 3
TFN692458 | WCP2636 | 811 Barton Springs | Corp Consultant [NAME] 230 | 230 | 70717 | 295933 | 366661 | 15117 | 168410 | 183527 | 3763 | 2462 | 11
TFN692459 | WCP2636 | 811 Barton Springs | Energy Efficiency Svcs RM 310 | 310 | 106149 | 217297 | 323450 | 39654 | 232546 | 272200 | 5270 | 81 | 4
TFN692460 | WCP2636 | 721 Barton Springs | [NAME] | 460 | 80930 | 294860 | 375869 | 28631 | 236360 | 264991 | 4715 | 389 | 79
TFN692697 | WCP2636 | 721 Barton Springs | Human Relations RM 125 | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TFN692709 | WCP2636 | 721 Barton Springs | Public Involvement RM102 | 102 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TFN692798 | WCP2636 | 811 Barton Springs | 2nd [NAME] | 215 | 66062 | 163121 | 229198 | 7886 | 139263 | 147149 | 1447 | 0 | 15
TFN699402 | WCP2636 | 721 Barton Springs | Energy Marketing RM 208 | 208 | 73704 | 307548 | 381252 | 40001 | 148472 | 188473 | 7941 | 71 | 0
TFN699414 | WCP2636 | 721 Barton Springs | Finance RM 575 | 556 | 50289 | 89920 | 140209 | 29789 | 63620 | 93409 | 2718 | 220 | 0
TFN699937 | WCP2636 | 721 Barton Springs | Key Account/ Commercial RM 331 | 331 | 30819 | 159949 | 190768 | 12827 | 70932 | 83759 | 9682 | 0 | 0
TFN700114 | WCP 3545 | Kramer E | KRME_108XC_ADMIN | 108 | 157673 | 172529 | 330203 | 11558 | 49341 | 60899 | 8980 | 2502 | 1
URT102223 | WCP 232 | Crossdocks | Crossdock_X | 100 | 28330 | 28040 | 56374 |  |  |  | 81235 | 338 | 4
URT103867 | WCP232 | 721 Barton Springs | ITT RM 453 | 453 | 113355 | 426531 | 540931 |  |  |  | 4541 | 1982 | 1045
URT103900 | WCP 232 | [NAME] | CAM_XEROX2 | 114C | 30550 | 9695 | 40245 |  |  |  | 42473 | 50 | 0
URT103907 | WCP232 | 721 Barton Springs | 2nd Flr File Rm RM 223 | 223 | 76095 | 123201 | 199296 |  |  |  | 6553 | 488 | 0
URT103922 | WCP232 | 721 Barton Springs | 2nd Floor | 260 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
URT103930 | WCP232 | 721 Barton Springs | 5th Floor General Managers Off | 520 | 99532 | 150284 | 249816 |  |  |  | 781 | 466 | 0
URT103943 | WCP232 | 721 Barton Springs | ITT RM 432 | 432 | 37245 | 282599 | 319894 |  |  |  | 2643 | 1954 | 50
URT103950 | WCP232 | 721 Barton Springs | Purchasing RM 404 | 404 | 402674 | 375083 | 777757 |  |  |  | 15212 | 52 | 0
URT103955 | WCP232 | 721 Barton Springs | Key Account/ Commercial RM 337 | 337 | 89299 | 340659 | 429958 |  |  |  | 18246 | 1259 | 0
URT103956 | WCP232 | 811 Barton Springs | Green Building Program RM300 | 300 | 105554 | 278075 | 383639 |  |  |  | 7868 | 1 | 10
URT103961 | WCP232 | 721 Barton Springs | Customer Care RM 314 | 314 | 44238 | 116678 | 160916 |  |  |  | 1 | 0 | 0
[NAME] | WCP232 | 721 Barton Springs | Finance RM 400 | 400.12 | 175352 | 214073 | 389428 |  |  |  | 13872 | 2111 | 3
URT104015 | WCP 232 | [NAME] | CAM_XEROX3 | 115 | 148805 | 133979 | 282788 |  |  |  | 28339 | 33 | 4
URT104022 | WCP232 | 721 Barton Springs | Finance RM 545 | 545 | 22921 | 61832 | 84753 |  |  |  | 1076 | 0
URT104025 | WCP232 | 721 Barton Springs | Credit/Collections RM 348 | 348 | 66189 | 414530 | 480719 |  |  |  | 29854 | 105 | 0
URT104054 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 310 | 310 | 125134 | 154180 | 279318 |  |  |  | 8941 | 2183 | 4
URT104057 | WCP232 | 721 Barton Springs | Power Production RM 275 | 275 | 47425 | 133077 | 180502 |  |  |  | 1982 | 48 | 0
URT104061 | WCP232 | 721 Barton Springs | Purchasing RM 410 | 410 | 367901 | 371728 | 739807 |  |  |  | 17075 | 450 | 178
[NAME] | WCP232 | 721 Barton Springs | Payment Processing  RM 243 | 129 | 103854 | 401243 | 505097 |  |  |  | 306 | 1043 | 0
URT104082 | WCP232 | 811 Barton Springs | [NAME] | 305b | 85978 | 713362 | 799340 |  |  |  | 8323 | 173 | 0
URT104125 | WCP 232 | Holly Lab E | HOLLYLAB_EX | 102 | 17351 | 47075 | 64432 |  |  |  | 3273 | 503 | 6
URT809963 | WCP 232 | Kramer D | KRMD_002X | 2 | 71412 | 84283 | 155695 |  |  |  | 227 | 3469 | 0
URT810028 | WCP 232 | St. Elmo | STE_ADMINISTRATION_205 | 205 | 83915 | 126266 | 210181 |  |  |  | 6372 | 1387 | 0
URT810070 | WCP 232 | St. Elmo | STE_WHSE1X | Whse | 95176 | 101025 | 196201 |  |  |  | 81 | 8 | 0
URT951428 | WCP232 | 721 Barton Springs | Service Orders/Billing RM349 | 349 | 69372 | 258265 | 327637 |  |  |  | 2985 | 225 | 0
URT951462 | WCP232 | 721 Barton Springs | Cust Svc Management RM 323 | 323 | 161675 | 274758 | 436448 |  |  |  | 2367 | 721 | 15
URT952655 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 311 | 311 | 132121 | 261757 | 393878 |  |  |  | 7405 | 1281 | 0
URT955238 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 317 | 317 | 111771 | 184113 | 295885 |  |  |  | 3554 | 354 | 1
URT963141 | WCP232 | 811 Barton Springs | Marketing Communications RM 250 | 250 | 191827 | 100887 | 292714 |  |  |  | 5034 | 4681 | 0
UTU104309 | WCP275 | 721 Barton Springs | Human Relations RM 108 | 108 | 359601 | 494398 | 853999 |  |  |  | 4719 | 3 | 0
UTU105163 | WCP232 | 811 Barton Springs | Energy Efficiency Svcs RM 302 | 302 | 307349 | 26492 | 333846 |  |  |  | 11165 | 1389 | 5
UTV851888 | WCP 255 | St. Elmo | STE_ADMINISTRATION_101 | 101 | 242758 | 32135 | 274893 |  |  |  | 3336 | 34 | 0
VDR002448 | WC7655 | 721 Barton Springs | TLC_250XC | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VDR002764 | WC7655 | 811 Barton Springs | 811_100XC | 100 | 4857 | 28889 | 33746 | 6821 | 64292 | 71113 | 45 | 209 | 0
VDR003309 | WC7655 | Nmopac RM 425B | NMOPAC_425XC | 425B | 10019 | 40854 | 50873 | 1879 | 10804 | 12683 | 4600 | 221 | 0 | 17
VDR003399 | WC7655 | Nmopac RM 425C | MOPC_425XC | 425C | 499 | 4382 | 4881 | 156 | 3119 | 3275 | 403 | 95 | 0 | 25
VDR545541 | WC7655 | Decker | DKR_ADMIN | Admin. | 66769 | 111812 | 178581 | 14302 | 52590 | 66892 | 9745 | 1038 | 0 | 5438
VDR555935 | WC7655 | 811 Barton Springs | 811_807XC | 807 | 10444 | 43165 | 53609 | 2466 | 33319 | 35785 | 10073 | 1401
VDR556100 | WC7655 | 811 Barton Springs | 811_805XC | 805 | 15549 | 242304 | 257853 | 2078 | 59486 | 61564 | 16923 | 234 | 0
VDR556109 | WC7655 | 721 Barton Springs | 5th Floor | 530 | 103318 | 113589 | 216907 | 36371 | 53382 | 89753 | 6525 | 316 | 0
[NAME] | WC7655 | 811 Barton Springs | 811_810XC | 810 | 34907 | 124645 | 159552 | 3128 | 18209 | 21337 | 37383 | 413 | 0
VGW619389 | DC240 | 811 Barton Springs | Marketing Communications RM 250 | 250 |  |  | 123692 |  |  | 421078
WTD004630 | WC5645 | Nmopac RM425B | MOPB_425X | 425B | 641 | 8385 | 9026 |  |  |  | 321 | 77 | 0