Addiction LXVI
07-28-17, 09:31 AM
#2551
Administrator
Thread Starter
Join Date: Apr 2005
Location: Hudson Valley, NY
Posts: 33,135
Bikes: Merlin Cyrene '04; Bridgestone RB-1 '92
Liked 6,873 Times
in
3,576 Posts
Speaking of which, here's a typical morning smoothie in the making - almond milk, chocolate protein powder, blueberries, banana, rasberries, strawberries. This photo a couple of weeks old because the strawberries are now gone, season over. 
__________________
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
07-28-17, 09:34 AM
#2552
So it is
Join Date: Sep 2008
Location: Westminster, CO
Posts: 21,505
Bikes: Luzerne, 684, Boreas, Wheelhouse, Alize©®, Bayamo, Cayo
Liked 4,924 Times
in
2,845 Posts
Awesome picture, [MENTION=351576]Heathpack[/MENTION] It will be fun for all. 
07-28-17, 09:44 AM
#2553
So it is
Join Date: Sep 2008
Location: Westminster, CO
Posts: 21,505
Bikes: Luzerne, 684, Boreas, Wheelhouse, Alize©®, Bayamo, Cayo
Liked 4,924 Times
in
2,845 Posts
Lol.
What did you end up with?
At this point, I really don't know if early morning riding will end up being a thing for me or not. I'm kind of at a tipping point where I'm starting to get enough sleep through the night and it would be nice to open myself up for extra miles on rides other than Wed, Sat and Sun... whether or not I'll actually pry myself out of bed regularly remains to be seen.
What did you end up with?
At this point, I really don't know if early morning riding will end up being a thing for me or not. I'm kind of at a tipping point where I'm starting to get enough sleep through the night and it would be nice to open myself up for extra miles on rides other than Wed, Sat and Sun... whether or not I'll actually pry myself out of bed regularly remains to be seen.
07-28-17, 10:02 AM
#2555
Custom User Title
Join Date: May 2013
Location: SE MN
Posts: 11,239
Bikes: Fuji Roubaix Pro & Quintana Roo Kilo
Likes: 0
Liked 31 Times
in
14 Posts
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?
07-28-17, 10:06 AM
#2556
Senior Member
Join Date: Jan 2010
Location: TC, MN
Posts: 39,520
Bikes: R3 Disc, Haanjo
Liked 9,456 Times
in
4,672 Posts
Did [MENTION=160999]Bah Humbug[/MENTION] get a pup?
07-28-17, 10:21 AM
#2559
Senior Member
Join Date: Jan 2010
Location: TC, MN
Posts: 39,520
Bikes: R3 Disc, Haanjo
Liked 9,456 Times
in
4,672 Posts
1700 lumens? Daymn.
07-28-17, 10:30 AM
#2563
Farmer tan
Looking at the AA version, the light output is lower than the 18650 version, so may not be adequate.
If the Eagletac is the only light, mount on the helmet due to the beam focus. You can point it where you're looking.
Usjng 2 lighrs is analogous to wearing layers in the cold. It gives more flexibility, but neither in their own would be the best.
If I were starting over, I might try a magic shine clone. But dat 1lb battery doh.
07-28-17, 10:31 AM
#2564
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
Maybe our resident doc(s) can chime in but I've seen a study going around lately that NSAIDs can actually deny muscle recovery. Don't need that.
__________________
Keep the chain tight!
07-28-17, 10:32 AM
#2565
Silver Comet Fred
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?
07-28-17, 10:33 AM
#2566
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
07-28-17, 10:35 AM
#2567
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
Imgur is putting out some huge pics on here. Even on my desktop, Imgur posts are pushing the reply button way to the right and off the window display. The board needs to institute some size regulations like many other boards do.
__________________
Keep the chain tight!
07-28-17, 10:36 AM
#2568
Custom User Title
Join Date: May 2013
Location: SE MN
Posts: 11,239
Bikes: Fuji Roubaix Pro & Quintana Roo Kilo
Likes: 0
Liked 31 Times
in
14 Posts
It's not the finding of the duplicates that is hard it's the weeding out of the duplicate with the best data in the rest of the row.
You can remove duplicates through an option on the data tab... I might save the file and see what I can do with that option.
You can remove duplicates through an option on the data tab... I might save the file and see what I can do with that option.
07-28-17, 10:39 AM
#2570
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
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.
__________________
Keep the chain tight!
07-28-17, 10:39 AM
#2571
Silver Comet Fred
I am aware of the long-term effects of overuse of ibuprofen and other NSAIDs and limit the use to the worst cases. I usually loosen up gradually over the first hour of the day wish I had time for stretching but I barely have enough time to ride my bike and drop the hammer.
07-28-17, 10:42 AM
#2572
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
I am aware of the long-term effects of overuse of ibuprofen and other NSAIDs and limit the use to the worst cases. I usually loosen up gradually over the first hour of the day wish I had time for stretching but I barely have enough time to ride my bike and drope the hamer.
__________________
Keep the chain tight!
07-28-17, 10:44 AM
#2573
Super Modest
Join Date: Jun 2002
Location: Central Illinois
Posts: 23,580
Bikes: Trek Emonda, Giant Propel, Colnago V3, Co-Motion Supremo, ICE VTX WC
Liked 4,796 Times
in
2,186 Posts
I'd like to hang out more but I'm excavating for landscaping. I usually have people for this but my wife figures that I could probably do it without hurting myself. 
BTW, I was using a bench grinder a couple days ago and my finger slipped. Now my nasty finger on my left hand is shorter than it use to be by 1/2 a millimeter.
Hi, Ho, off to work i go...
BTW, I was using a bench grinder a couple days ago and my finger slipped. Now my nasty finger on my left hand is shorter than it use to be by 1/2 a millimeter.
Hi, Ho, off to work i go...
__________________
Keep the chain tight!
07-28-17, 10:48 AM
#2574
VFL For Life
Join Date: Feb 2005
Location: Knoxville, TN
Posts: 51,705
Bikes: Velo Volmobile
Liked 1,941 Times
in
1,367 Posts
07-28-17, 10:49 AM
#2575
Silver Comet Fred
I could buy more bike gear with the savings.
Last edited by DougRNS; 07-28-17 at 10:50 AM. Reason: To complete thought
