Spreadsheet: 698831d1602191653-need-help-with-if-and-and-else-formula-rate-plan-cleanup
Sheet: Data

2019 Revenue by Rate Code - Summary from Choice Advantage |  |  |  |  |  |  | 2020 Revenue by Rate Code - Summary from Choice Advantage |  |  |  |  |  |  | Property Local Rate Plan List - Copy and Paste from Rates Center
Rate Code | Room Nights | %Room Nights | Room Revenue | %Room Revenue | Daily AVG |  | Rate Code | Room Nights | %Room Nights | Room Revenue | %Room Revenue | Daily AVG |  | L5RC | Five Rivers Cattle |  | NO | PCT4
GROUP~ | 1428 | 0 | 0 | 0 | 0 |  | LCPM | 426 | 0 | 0 | 0 | 0 |  |  | LADF | Anchor Drilling Fluids | INACTIVE | NO | PCT4
LCLC | 283 | 0 | 0 | 0 | 0 |  | [NAME] | 93 | 0 | 0 | 0 | 0 |  |  | LALPRO | All Pro Moving |  | NO | PCT3
LCPM | 1429 | 0 | 0 | 0 | 0 |  | LMGR | 376 | 0 | 0 | 0 | 0 |  |  | LAWC | AWC Fraq Valves |  | NO | L99
[NAME] | 500 | 0 | 0 | 0 | 0 |  | LNCRH | 10 | 0 | 0 | 0 | 0 |  |  | LBAH | [NAME] |  | YES | L119
LGWR | 155 | 0 | 0 | 0 | 0 |  | RACK | 1715 | 0 | 0 | 0 | 0 |  |  | LBDAY | Birthday Promo |  | NO | PCT4
LJPN | 145 | 0 | 0 | 0 | 0 |  | S20M4M | 159 | 0 | 0 | 0 | 0 |  |  | LBEE | BlackEagle Energy |  | NO | L104
LMCR | 134 | 0 | 0 | 0 | 0 |  | SAPR1M | 715 | 0 | 0 | 0 | 0 |  |  | LBERE | Bereavement rate |  | NO | PCT2P
LMGR | 393 | 0 | 0 | 0 | 0 |  | SAPR1R | 376 | 0 | 0 | 0 | 0 |  |  | LBJC | Big Johnson Construction |  | NO | 100
RACK | 4250 | 0 | 0 | 0 | 0 |  | SAPR2M | 315 | 0 | 0 | 0 | 0 |  |  | LBOC | Bank of Colorado |  | NO | [NAME]
SAPR1R | 188 | 0 | 0 | 0 | 0 |  | SCPM | 377 | 0 | 0 | 0 | 0 |  |  | LBREZ | Breeze Thru Car Wash |  | NO | PCT3
SCPM | 2119 | 0 | 0 | 0 | 0 |  | SGM | 234 | 0 | 0 | 0 | 0 |  |  | LBRIDG | Bridgewater Homes |  | NO | PCT3
SCR | 157 | 0 | 0 | 0 | 0 |  | SNP | 129 | 0 | 0 | 0 | 0 |  |  | LBUD | Budweiser Events Center |  | NO | PCT1
SRTL | 336 | 0 | 0 | 0 | 0 |  | [NAME] | 58 | 0 | 0 | 0 | 0 |  |  | LBULL | Bulls-Eye Testing LLC |  | NO | L104
PKPR2 | 69 | 0 | 0 | 0 | 0 |  | SP2AG | 20 | 0 | 0 | 0 | 0 |  |  | LCACT | Cactus Wellhead |  | NO | L104
SAPR1M | 360 | 0 | 0 | 0 | 0 |  | SP2R | 89 | 0 | 0 | 0 | 0 |  |  | [NAME] | [NAME] |  | NO | PCT3
SAPR2R | 198 | 0 | 0 | 0 | 0 |  | SPC | 46 | 0 | 0 | 0 | 0 |  |  | LCCL | [NAME] | INACTIVE | NO | L119
SBOOK | 183 | 0 | 0 | 0 | 0 |  | SRD | 264 | 0 | 0 | 0 | 0 |  |  | LCDPH | Candlelight Dinner Playhouse |  | NO | L119
SED | 362 | 0 | 0 | 0 | 0 |  | SRTL | 58 | 0 | 0 | 0 | 0 |  |  | LCHH | Canyon Homecare and Hospice |  | NO | FIXED4
SN15 | 40 | 0 | 0 | 0 | 0 |  | LHIGH | 22 | 0 | 0 | 0 | 0 |  |  | LCLC1 | Corporate Lodging | INACTIVE | YES | 99/119
SPC | 260 | 0 | 0 | 0 | 0 |  | LLAA | 475 | 0 | 0 | 0 | 0 |  |  | LCMS | Corrosion Monitoring Systems Inc | INACTIVE | NO | PCT3
SRD | 417 | 0 | 0 | 0 | 0 |  | LVACA | 34 | 0 | 0 | 0 | 0 |  |  | LCOMP | Comp rate plan - MANAGER USE ONLY |  | NO | COMP
SSC | 230 | 0 | 0 | 0 | 0 |  | S10M2M | 231 | 0 | 0 | 0 | 0 |  |  | [NAME] | [NAME] | INACTIVE | NO | [NAME]
LLAA | 665 | 0 | 0 | 0 | 0 |  | S15M3M | 325 | 0 | 0 | 0 | 0 |  |  | LCPM | Choice Priviledge Member incentive rate |  | YES | [NAME]
LSTATE | 132 | 0 | 0 | 0 | 0 |  | SAPR2R | 147 | 0 | 0 | 0 | 0 |  |  | LCSLLC | Conveying Solutions LLC | INACTIVE | NO | FIXED7
LVACA | 168 | 0 | 0 | 0 | 0 |  | SP20M4 | 14 | 0 | 0 | 0 | 0 |  |  | LCTC | ClinTech Center for Spine Health |  | NO | PCT3
SAPR2M | 304 | 0 | 0 | 0 | 0 |  | SP2EXP | 86 | 0 | 0 | 0 | 0 |  |  | LCTMI | Central Mechanical Inc |  | NO | LOW
SNP | 217 | 0 | 0 | 0 | 0 |  | LPMD | 29 | 0 | 0 | 0 | 0 |  |  | LCTS | Colorado Time Systems | INACTIVE | NO | FIXED7
SP2BK | 110 | 0 | 0 | 0 | 0 |  | SED | 213 | 0 | 0 | 0 | 0 |  |  | LCVBH | Clear View Behavioral Health |  | NO | PCT3
SAPR2A | 41 | 0 | 0 | 0 | 0 |  | SSC | 158 | 0 | 0 | 0 | 0 |  |  | LDECK | Artisan [NAME] |  | NO | L69
SP2EXP | 228 | 0 | 0 | 0 | 0 |  | [NAME] | 81 | 0 | 0 | 0 | 0 |  |  | LDFA | Dairy Farmers of America |  | NO | L109
LEXP2 | 17 | 0 | 0 | 0 | 0 |  | LSCH | 37 | 0 | 0 | 0 | 0 |  |  | LDVTA | DaVita |  | NO | FIXED5
LSCH | 157 | 0 | 0 | 0 | 0 |  | LSTATE | 9 | 0 | 0 | 0 | 0 |  |  | LEAGL | Colorado Eagles Nation Discount |  | NO | PCT4
SAPR1 | 56 | 0 | 0 | 0 | 0 |  | SAGOD | 12 | 0 | 0 | 0 | 0 |  |  | LECJ | Employers Council of Loveland |  | NO | PCT3
SAPR1B | 39 | 0 | 0 | 0 | 0 |  | SAPR2A | 49 | 0 | 0 | 0 | 0 |  |  | LECP | Elite Custom Painting |  | YES | L99
LCLC1 | 433 | 0 | 0 | 0 | 0 |  | SP15M3 | 77 | 0 | 0 | 0 | 0 |  |  | LECRET | Elite Crete | INACTIVE | NO | L114
S10M2M | 419 | 0 | 0 | 0 | 0 |  | LTRC | 51 | 0 | 0 | 0 | 0 |  |  | LELI | Elite Drilling |  | NO | L99
SP2AG | 36 | 0 | 0 | 0 | 0 |  | LCLC1 | 9 | 0 | 0 | 0 | 0 |  |  | LENC | Entrec Cranes & Heavy Haul |  | NO | L99
LPSC | 22 | 0 | 0 | 0 | 0 |  | LCVBH | 26 | 0 | 0 | 0 | 0 |  |  | LEXSP | Extreme Scapes LLC |  | NO | L109
LNCLA | 44 | 0 | 0 | 0 | 0 |  | LJPN | 71 | 0 | 0 | 0 | 0 |  |  | LFALC | Falcon Technologies |  | NO | L104
LWPI | 189 | 0 | 0 | 0 | 0 |  | LMCR | 89 | 0 | 0 | 0 | 0 |  |  | LFAX | Faxed OTA reservations |  | NO | PCT3
SAPR2 | 67 | 0 | 0 | 0 | 0 |  | LOIL | 25 | 0 | 0 | 0 | 0 |  |  | LFISK | Fiske Electric |  | NO | L99
[NAME] | 153 | 0 | 0 | 0 | 0 |  | PKPR1 | 7 | 0 | 0 | 0 | 0 |  |  | LGONY | Gonyon Cosmetics |  | NO | PCT3
LCOMP | 8 | 0 | 0 | 0 | 0 |  | PKPR2 | 5 | 0 | 0 | 0 | 0 |  |  | LGOSS | Goss Foundations | INACTIVE | YES | FIXED2
SC15 | 8 | 0 | 0 | 0 | 0 |  | S3A | 194 | 0 | 0 | 0 | 0 |  |  | LGRC | Gracon LLC | INACTIVE | YES | LP3
SSO | 99 | 0 | 0 | 0 | 0 |  | LCHH | 10 | 0 | 0 | 0 | 0 |  |  | LGWR | Great Western Railway |  | NO | L99
LENC | 82 | 0 | 0 | 0 | 0 |  | LRKNRL | 6 | 0 | 0 | 0 | 0 |  |  | LHAL | Halliburton | INACTIVE | NO | L99
LCVBH | 182 | 0 | 0 | 0 | 0 |  | LBULL | 6 | 0 | 0 | 0 | 0 |  |  | LHAP | Helmerich and Payne |  | NO | L104
PKPR1 | 16 | 0 | 0 | 0 | 0 |  | LFISK | 27 | 0 | 0 | 0 | 0 |  |  | LHAYD | Hayden Outdoors |  | NO | PCT3
L5RC | 128 | 0 | 0 | 0 | 0 |  | LKLX | 14 | 0 | 0 | 0 | 0 |  |  | LHCB | High Country Beverage |  | NO | L104
LLASPN | 12 | 0 | 0 | 0 | 0 |  | LOPQ | 32 | 0 | 0 | 0 | 0 |  |  | LHEART | I Heart Media |  | NO | L109
LSAMC | 26 | 0 | 0 | 0 | 0 |  | LSAMC | 10 | 0 | 0 | 0 | 0 |  |  | [NAME] | HERO Rate 20 Percent Off |  | NO | PCT4
SN25 | 39 | 0 | 0 | 0 | 0 |  | SAPR2 | 76 | 0 | 0 | 0 | 0 |  |  | LHHH | Henderson Heavy Haul |  | NO | L99
LFF | 117 | 0 | 0 | 0 | 0 |  | LBERE | 4 | 0 | 0 | 0 | 0 |  |  | LHIGH | HighPoint Electric |  | NO | FIXED5
LHAL | 13 | 0 | 0 | 0 | 0 |  | LFF | 77 | 0 | 0 | 0 | 0 |  |  | LHPR | High Point Resources | INACTIVE | NO | HIGH
LPES | 2 | 0 | 0 | 0 | 0 |  | SIT | 8 | 0 | 0 | 0 | 0 |  |  | LINNX | Innovex |  | NO | L99
SP2R | 153 | 0 | 0 | 0 | 0 |  | L5RC | 54 | 0 | 0 | 0 | 0 |  |  | LJACA | Jacam Chemicals |  | NO | L109
LNET2 | 44 | 0 | 0 | 0 | 0 |  | LDVTA | 10 | 0 | 0 | 0 | 0 |  |  | LJBS | JBS UBS |  | NO | L99
LOIL | 90 | 0 | 0 | 0 | 0 |  | LJRI | 2 | 0 | 0 | 0 | 0 |  |  | LJFT | [NAME] | INACTIVE | NO | L114
LWTO | 5 | 0 | 0 | 0 | 0 |  | NJSW | 21 | 0 | 0 | 0 | 0 |  |  | LJPN | Johnstown Plaza Neighbor |  | NO | PCT3
SGM | 226 | 0 | 0 | 0 | 0 |  | NUV1 | 4 | 0 | 0 | 0 | 0 |  |  | LJPPS | JPPS | INACTIVE | NO | L99
LKLX | 169 | 0 | 0 | 0 | 0 |  | LINNX | 6 | 0 | 0 | 0 | 0 |  |  | LJRI | JR Industries |  | NO | L99
LBULL | 108 | 0 | 0 | 0 | 0 |  | LMESA | 3 | 0 | 0 | 0 | 0 |  |  | LKCOE | K Coe ISOM |  | NO | L114
SAPR2B | 48 | 0 | 0 | 0 | 0 |  | LRDI | 1 | 0 | 0 | 0 | 0 |  |  | LKLX | KLX Energy |  | YES | L99
S3A | 178 | 0 | 0 | 0 | 0 |  | SP3EXP | 152 | 0 | 0 | 0 | 0 |  |  | LKMS | Kimbel Mechanical Systems |  | NO | L104
LKPS | 1227 | 0 | 0 | 0 | 0 |  | LPEFN | 116 | 0 | 0 | 0 | 0 |  |  | LKPS | Perspecta / KeyPoint |  | NO | L90
LNCRH | 44 | 0 | 0 | 0 | 0 |  | LWAL | 6 | 0 | 0 | 0 | 0 |  |  | LKRNA | [NAME] |  | YES | L109
LPAVCO | 1 | 0 | 0 | 0 | 0 |  | LCTC | 18 | 0 | 0 | 0 | 0 |  |  | LKRSC | KR Swerdfiger Construction |  | NO | L104
LOPQ | 28 | 0 | 0 | 0 | 0 |  | SN25 | 25 | 0 | 0 | 0 | 0 |  |  | LLAA | Loveland Auto Auction |  | NO | LNR89
LKMS | 1 | 0 | 0 | 0 | 0 |  | SAPR1 | 210 | 0 | 0 | 0 | 0 |  |  | [NAME] | Northern Colorado Forensic Laboratory |  | YES | FIXED1
LMESA | 10 | 0 | 0 | 0 | 0 |  | SAPR2B | 39 | 0 | 0 | 0 | 0 |  |  | LLASPN | Aspen View Homes |  | NO | FIXED7
LBERE | 20 | 0 | 0 | 0 | 0 |  | SSO | 37 | 0 | 0 | 0 | 0 |  |  | LLJT | Loveland Jet Center |  | NO | L119
NJSW | 130 | 0 | 0 | 0 | 0 |  | SAPR1A | 121 | 0 | 0 | 0 | 0 |  |  | LLOVE | Love's Truck Stop |  | NO | L104
SAGOD | 67 | 0 | 0 | 0 | 0 |  | SP3R | 75 | 0 | 0 | 0 | 0 |  |  | [NAME] | LPR Construction |  | NO | L104
LKCOE | 28 | 0 | 0 | 0 | 0 |  | [NAME] | 79 | 0 | 0 | 0 | 0 |  |  | LMCR | Medical Center of the Rockies |  | NO | L104
LTRC | 26 | 0 | 0 | 0 | 0 |  | LNET2 | 8 | 0 | 0 | 0 | 0 |  |  | LMEDI | Traveling Nurse Ext Stay |  | YES | [NAME]
LSBC | 22 | 0 | 0 | 0 | 0 |  | SP4AG | 14 | 0 | 0 | 0 | 0 |  |  | LMERB | Merberee Holdings |  | NO | L104
SAPR1A | 40 | 0 | 0 | 0 | 0 |  | LBJC | 149 | 0 | 0 | 0 | 0 |  |  | LMESA | Mesa Production |  | NO | L104
LBOC | 37 | 0 | 0 | 0 | 0 |  | NEL002 | 36 | 0 | 0 | 0 | 0 |  |  | LMGR | Manager rate - MUST BE APPROVED BY MGR |  | NO | PCT3
LPEFN | 57 | 0 | 0 | 0 | 0 |  | NO SHOW |  | 0 | 0 | 0 | 0 |  |  | LMNGS | Mesa Natural Gas Solutions |  | NO | L109
LKRNA | 22 | 0 | 0 | 0 | 0 |  | LKRNA | 4 | 0 | 0 | 0 | 0 |  |  | LMRT | Modern Transportation |  | YES | L109
[NAME] | 53 | 0 | 0 | 0 | 0 |  | NBNH | 8 | 0 | 0 | 0 | 0 |  |  | LMUR | Murphy Company/Insulation USA |  | NO | L104
SIT | 11 | 0 | 0 | 0 | 0 |  | LCLC | 356 | 0 | 0 | 0 | 0 |  |  | LNATG | Natural Gas Solutions Inc |  | NO | L109
LBRIDG | 1 | 0 | 0 | 0 | 0 |  | LWPI | 41 | 0 | 0 | 0 | 0 |  |  | LNCLA | Northern CO Long-term Acute Hospital |  | NO | PCT4
LBAH | 6 | 0 | 0 | 0 | 0 |  | LENC | 24 | 0 | 0 | 0 | 0 |  |  | LNCRH | Northern CO Rehab Hospital |  | NO | PCT4
LPRO | 6 | 0 | 0 | 0 | 0 |  | SAPR1B | 108 | 0 | 0 | 0 | 0 |  |  | LNUTR | Nutrien |  | NO | L104
LCTC | 36 | 0 | 0 | 0 | 0 |  | LVOL | 16 | 0 | 0 | 0 | 0 |  |  | LNVB | Norco Volleyball |  | NO | PCT3
GTR | 4 | 0 | 0 | 0 | 0 |  | [NAME] | 2 | 0 | 0 | 0 | 0 |  |  | LOIL | Oil States Energy Services |  | NO | L99
NO SHOW |  | 0 | 0 | 0 | 0 |  | NXVU | 9 | 0 | 0 | 0 | 0 |  |  | LONBRO | Loenbro | INACTIVE | NO | L129
NWDR | 35 | 0 | 0 | 0 | 0 |  | LBUD | 3 | 0 | 0 | 0 | 0 |  |  | [NAME] | Power2Play Sports |  | NO | PCT4
NOIX | 131 | 0 | 0 | 0 | 0 |  | LKMS | 1 | 0 | 0 | 0 | 0 |  |  | LPAVCO | Pavilion Construction | INACTIVE | NO | FIXED7
LECJ | 6 | 0 | 0 | 0 | 0 |  | LLOVE | 4 | 0 | 0 | 0 | 0 |  |  | LPEFN | PE Fusion |  | NO | L99
LJPPS | 2 | 0 | 0 | 0 | 0 |  | LECJ | 1 | 0 | 0 | 0 | 0 |  |  | LPERF | Performance Over Sized Logistics |  | NO | PCT4
NBNH | 9 | 0 | 0 | 0 | 0 |  | LNATG | 4 | 0 | 0 | 0 | 0 |  |  | LPES | Pioneer Energy Services |  | NO | PCT4
LEXSP | 32 | 0 | 0 | 0 | 0 |  | SN15 | 18 | 0 | 0 | 0 | 0 |  |  | LPLV | Pelican Lakes Venue |  | NO | PCT4
LTIS | 25 | 0 | 0 | 0 | 0 |  | GROUP~ | 210 | 0 | 0 | 0 | 0 |  |  | LPMD | [NAME] |  | NO | L104
LCMS | 2 | 0 | 0 | 0 | 0 |  | LCOMP | 10 | 0 | 0 | 0 | 0 |  |  | LPPE | Pinnacle Propane Express | INACTIVE | NO | PCT4
LCHH | 34 | 0 | 0 | 0 | 0 |  | LBDAY | 8 | 0 | 0 | 0 | 0 |  |  | LPRO | ProPetro Services | INACTIVE | NO | PCT3
LRKNRL | 2 | 0 | 0 | 0 | 0 |  | SCPO | 4 | 0 | 0 | 0 | 0 |  |  | LPSC | Premier Stem Cell & Wellness | INACTIVE | NO | PCT3
LHCB | 30 | 0 | 0 | 0 | 0 |  | LTRAX | 3 | 0 | 0 | 0 | 0 |  |  | LRANCH | The Ranch Events Complex |  | NO | PCT3
NHAL | 7 | 0 | 0 | 0 | 0 |  | LTRIST | 18 | 0 | 0 | 0 | 0 |  |  | LRBB | Rise Broadband |  | NO | L100
LDVTA | 21 | 0 | 0 | 0 | 0 |  | [NAME] | 15 | 0 | 0 | 0 | 0 |  |  | LRDI | RDI Ironworks |  | NO | L119
LGOSS | 304 | 0 | 0 | 0 | 0 |  | LHCB | 1 | 0 | 0 | 0 | 0 |  |  | [NAME] | Resurrection Fellowship |  | NO | PCT3
LRDI | 31 | 0 | 0 | 0 | 0 |  | LCDPH | 2 | 0 | 0 | 0 | 0 |  |  | LRKNRL | Rock N Rail |  | NO | FIXED7
LBJC | 289 | 0 | 0 | 0 | 0 |  | LNCLA | 17 | 0 | 0 | 0 | 0 |  |  | LROCK | Rock Water Energy | INACTIVE | NO | L119
LCTS | 2 | 0 | 0 | 0 | 0 |  | LEXSP | 7 | 0 | 0 | 0 | 0 |  |  | LSALI | Safelite |  | NO | FIXED4
[NAME] | 10 | 0 | 0 | 0 | 0 |  | SBOOK | 35 | 0 | 0 | 0 | 0 |  |  | LSAMC | Sampson Construction |  | NO | L99
LHIGH | 16 | 0 | 0 | 0 | 0 |  | LAWC | 9 | 0 | 0 | 0 | 0 |  |  | LSBC | Schmeeckle Bros Construction |  | NO | L109
S15M3M | 94 | 0 | 0 | 0 | 0 |  | SCR | 39 | 0 | 0 | 0 | 0 |  |  | LSCH | Scheels |  | NO | PCT4
LTMHD | 38 | 0 | 0 | 0 | 0 |  | SP3BK | 88 | 0 | 0 | 0 | 0 |  |  | LSCHO | SCHOOL Rate Percent Off |  | NO | PCT4
LHEART | 30 | 0 | 0 | 0 | 0 |  | LJACA | 2 | 0 | 0 | 0 | 0 |  |  | LSFE | [NAME] |  | YES | FIXED7
LWAL | 15 | 0 | 0 | 0 | 0 |  | LEXP2 | 6 | 0 | 0 | 0 | 0 |  |  | LSFM | State Farm Mobile |  | NO | PCT3
SP15M3 | 29 | 0 | 0 | 0 | 0 |  | NOIX | 28 | 0 | 0 | 0 | 0 |  |  | LSKY | Skyline Well Testing |  | NO | L109
[NAME] | 12 | 0 | 0 | 0 | 0 |  | LBOC | 9 | 0 | 0 | 0 | 0 |  |  | LSLMBJ | Schlumberger |  | NO | L104
LFISK | 16 | 0 | 0 | 0 | 0 |  | LELI | 16 | 0 | 0 | 0 | 0 |  |  | LSPING | Spring Break Discount |  | YES | PCT3
SP3EXP | 46 | 0 | 0 | 0 | 0 |  | SP3AG | 29 | 0 | 0 | 0 | 0 |  |  | LSQUAD | Construction Squad |  | YES | L104
SP3R | 31 | 0 | 0 | 0 | 0 |  | [NAME] | 339 | 0 | 0 | 0 | 0 |  |  | LSRAN | Rock'n S Ranch |  | NO | PCT4
GNT | 1 | 0 | 0 | 0 | 0 |  | LSPING | 1 | 0 | 0 | 0 | 0 |  |  | LSTES | Steel Energy Services | INACTIVE | NO | FIXED6
LPMD | 47 | 0 | 0 | 0 | 0 |  | LHHH | 36 | 0 | 0 | 0 | 0 |  |  | LTCC | Tri City Cycle |  | NO | FIXED4
SP1BK | 2 | 0 | 0 | 0 | 0 |  | SP2BK | 40 | 0 | 0 | 0 | 0 |  |  | LTEI | Trigger Energy Inc |  | NO | L119
LFALC | 18 | 0 | 0 | 0 | 0 |  | SAPR1C | 5 | 0 | 0 | 0 | 0 |  |  | LTIS | Team Industrial Services |  | NO | L104
SP1EXP | 3 | 0 | 0 | 0 | 0 |  | SEGEN | 1 | 0 | 0 | 0 | 0 |  |  | LTMHD | Thunder Mountain Harley-Davidson |  | NO | FIXED7
LVOL | 20 | 0 | 0 | 0 | 0 |  | [NAME] | 7 | 0 | 0 | 0 | 0 |  |  | LTPC | TPC Golf Course Berthoud |  | NO | PCT3
LTCC | 6 | 0 | 0 | 0 | 0 |  | LCTMI | 81 | 0 | 0 | 0 | 0 |  |  | LTRAX | OmniTrax |  | NO | L99
LNUTR | 2 | 0 | 0 | 0 | 0 |  | S25M4M | 9 | 0 | 0 | 0 | 0 |  |  | LTRC | TRC Construction |  | NO | L104
[NAME] | 34 | 0 | 0 | 0 | 0 |  | [NAME] | 4 | 0 | 0 | 0 | 0 |  |  | LTRIST | Tri State Generation & Transmission |  | NO | L129
NUV1 | 19 | 0 | 0 | 0 | 0 |  | LSBC | 39 | 0 | 0 | 0 | 0 |  |  | LUFPI | Universal Forest Products |  | NO | L104
NMQA02 | 1 | 0 | 0 | 0 | 0 |  | SP4EXP | 4 | 0 | 0 | 0 | 0 |  |  | [NAME] | Colorado State USBC |  | NO | L104
S20M4M | 83 | 0 | 0 | 0 | 0 |  | LPERF | 87 | 0 | 0 | 0 | 0 |  |  | LUTILI | Utili Link |  | NO | L109
[NAME] | 7 | 0 | 0 | 0 | 0 |  | LDECK | 6 | 0 | 0 | 0 | 0 |  |  | LVACA | Staycation for local residents |  | NO | PCT4
SP3BK | 12 | 0 | 0 | 0 | 0 |  | LWAG | 10 | 0 | 0 | 0 | 0 |  |  | LVALP | Valpak |  | NO | PCT0
LINNX | 5 | 0 | 0 | 0 | 0 |  | SP45M2 | 4 | 0 | 0 | 0 | 0 |  |  | LVOL | Volumetrics |  | NO | L104
LWDR | 3 | 0 | 0 | 0 | 0 |  | SCCEO1 | 6 | 0 | 0 | 0 | 0 |  |  | LWAG | Wagner Equipment |  | NO | PCT4
LALPRO | 2 | 0 | 0 | 0 | 0 |  | SP35M1 | 16 | 0 | 0 | 0 | 0 |  |  | LWAL | Walmart |  | NO | L104
SP4AG | 25 | 0 | 0 | 0 | 0 |  | SC20M1 | 520 | 0 | 0 | 0 | 0 |  |  | LWDR | Woodward | INACTIVE | NO | L104
LJRI | 28 | 0 | 0 | 0 | 0 |  | SP4R | 9 | 0 | 0 | 0 | 0 |  |  | LWED | WEDDING Rate 20 Percent Off |  | NO | PCT4
LRANCH | 2 | 0 | 0 | 0 | 0 |  | SP25M2 | 31 | 0 | 0 | 0 | 0 |  |  | LWETHR | [NAME] |  | NO | PCT3
[NAME] | 6 | 0 | 0 | 0 | 0 |  | SP25M4 | 14 | 0 | 0 | 0 | 0 |  |  | LWPI | Waukesha Pearce Industries |  | NO | L99
[NAME] | 9 | 0 | 0 | 0 | 0 |  | NHAL | 1 | 0 | 0 | 0 | 0
SP3AG | 6 | 0 | 0 | 0 | 0 |  | LSFM | 2 | 0 | 0 | 0 | 0
SP20M4 | 21 | 0 | 0 | 0 | 0 |  | SC25M3 | 23 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | S15M2M | 28 | 0.23 | 3334.56 | 0.28 | 119.09
 |  |  |  |  |  |  | SP15M2 | 16 | 0.13 | 1858.87 | 0.15 | 116.18
 |  |  |  |  |  |  | LHAYD | 1 | 0.01 | 114.32 | 0.01 | 114.32
 |  |  |  |  |  |  | SC15 | 2 | 0.02 | 283.89 | 0.02 | 141.95