Addiction LXVI
#2603
Senior Member
Join Date: Jan 2010
Posts: 39,249
Mentioned: 211 Post(s)
Tagged: 1 Thread(s)
Quoted: 18420 Post(s)
Liked 15,566 Times
in
7,334 Posts
The place is a bit rough around the edges and was pretty dead on a Tuesday evening.
#2605
Farmer tan
I have a customer list from past sales in excel that is ~21,000 rows long. I'm preparing it for a mailer. There are duplicate names which are easy enough to pull out, but the addresses aren't always complete or the same so I want to be able to pull out the most accurate duplicate. I also don't want to go through all the duplicates and clean it up manually.
I thought about dumping it into a pivot table and seeing which have differing addresses that way, but it's still a lot of manual work to go through in that way...
Anyone have any thoughts?
I thought about dumping it into a pivot table and seeing which have differing addresses that way, but it's still a lot of manual work to go through in that way...
Anyone have any thoughts?
#2606
Custom User Title
Join Date: May 2013
Location: SE MN
Posts: 11,239
Bikes: Fuji Roubaix Pro & Quintana Roo Kilo
Mentioned: 40 Post(s)
Tagged: 1 Thread(s)
Quoted: 2863 Post(s)
Likes: 0
Liked 31 Times
in
14 Posts
I have the list down to ~5000 rows and I'm cleaning up from the top down and am on row ~2000. Getting there!
#2607
Farmer tan
Don't know nothing about board mechanics but a few boards that I frequent would never allow the Imgur pics that are being posted here just today. They wreak havoc with mobile devices when you quote.
I use Flickr and try to limit max dimension size to 800 and occasionally 1024. Most of these being posted are running 3x that size.
I use Flickr and try to limit max dimension size to 800 and occasionally 1024. Most of these being posted are running 3x that size.
But I guess we're all posting from phones on the toilet.
#2609
Custom User Title
Join Date: May 2013
Location: SE MN
Posts: 11,239
Bikes: Fuji Roubaix Pro & Quintana Roo Kilo
Mentioned: 40 Post(s)
Tagged: 1 Thread(s)
Quoted: 2863 Post(s)
Likes: 0
Liked 31 Times
in
14 Posts
Not me. I have horrible reception at the office and it's even worse in the bathroom. There's WiFi, but even though my laptop picks it up fine my phone can't seem to hold onto the signal.
#2610
Administrator
Thread Starter
Join Date: Apr 2005
Location: Hudson Valley, NY
Posts: 33,005
Bikes: Merlin Cyrene '04; Bridgestone RB-1 '92
Mentioned: 325 Post(s)
Tagged: 2 Thread(s)
Quoted: 11971 Post(s)
Liked 6,655 Times
in
3,486 Posts
Exactly.
And it must get used up 'less they go out and do something stupid . . . like make a baby or something.
And it must get used up 'less they go out and do something stupid . . . like make a baby or something.
__________________
See, this is why we can't have nice things. - - smarkinson
Where else but the internet can a bunch of cyclists go and be the tough guy? - - jdon
#2612
Administrator
Thread Starter
Join Date: Apr 2005
Location: Hudson Valley, NY
Posts: 33,005
Bikes: Merlin Cyrene '04; Bridgestone RB-1 '92
Mentioned: 325 Post(s)
Tagged: 2 Thread(s)
Quoted: 11971 Post(s)
Liked 6,655 Times
in
3,486 Posts
We have a Vitamix, I hear it's good stuff.
__________________
See, this is why we can't have nice things. - - smarkinson
Where else but the internet can a bunch of cyclists go and be the tough guy? - - jdon
#2613
Silver Comet Fred
Join Date: Jan 2017
Location: NW Metro Atl.
Posts: 12,073
Bikes: 1
Mentioned: 145 Post(s)
Tagged: 2 Thread(s)
Quoted: 8843 Post(s)
Liked 2,990 Times
in
1,738 Posts
Vitamix charge for $400 or so appeared on the credit card bill a couple days ago. that must have been the one she settled on. I guess I'll push back my purchase of my new bike to 2021.
Last edited by DougRNS; 07-28-17 at 02:19 PM. Reason: Clarity
#2614
Silver Comet Fred
Join Date: Jan 2017
Location: NW Metro Atl.
Posts: 12,073
Bikes: 1
Mentioned: 145 Post(s)
Tagged: 2 Thread(s)
Quoted: 8843 Post(s)
Liked 2,990 Times
in
1,738 Posts
Back in my day we didn't need a blender. we chewed our food 32 times each bite...and we liked it!
#2615
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,466
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Mentioned: 107 Post(s)
Tagged: 1 Thread(s)
Quoted: 10963 Post(s)
Liked 4,620 Times
in
2,123 Posts
#2616
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,466
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Mentioned: 107 Post(s)
Tagged: 1 Thread(s)
Quoted: 10963 Post(s)
Liked 4,620 Times
in
2,123 Posts
#2617
Administrator
Thread Starter
Join Date: Apr 2005
Location: Hudson Valley, NY
Posts: 33,005
Bikes: Merlin Cyrene '04; Bridgestone RB-1 '92
Mentioned: 325 Post(s)
Tagged: 2 Thread(s)
Quoted: 11971 Post(s)
Liked 6,655 Times
in
3,486 Posts
Happy wife, happy life.
__________________
See, this is why we can't have nice things. - - smarkinson
Where else but the internet can a bunch of cyclists go and be the tough guy? - - jdon
#2621
Senior Member
Join Date: Dec 2009
Location: Houston, TX
Posts: 28,682
Bikes: 1990 Romic Reynolds 531 custom build, Merlin Works CR Ti custom build, super light Workswell 066 custom build
Mentioned: 109 Post(s)
Tagged: 1 Thread(s)
Quoted: 6556 Post(s)
Likes: 0
Liked 58 Times
in
36 Posts
I avoid NSAIDS because of my heart condition and reflux disease, but not 100%. If I need them, I will use them for up to a few days. I don't think there is cause for alarm with occasional short periods of use.
#2624
VFL For Life
Join Date: Feb 2005
Location: Knoxville, TN
Posts: 51,230
Bikes: Velo Volmobile
Mentioned: 780 Post(s)
Tagged: 2 Thread(s)
Quoted: 28622 Post(s)
Liked 1,858 Times
in
1,320 Posts
#2625
VFL For Life
Join Date: Feb 2005
Location: Knoxville, TN
Posts: 51,230
Bikes: Velo Volmobile
Mentioned: 780 Post(s)
Tagged: 2 Thread(s)
Quoted: 28622 Post(s)
Liked 1,858 Times
in
1,320 Posts