Show all posts by user

Re: In Excel, how to insert date in a cell based on another cell? - Today

Don C is my new hero. Thanks. Online references kept suggesting diving deep into VBA. I had just started a lynda course to become familiar with VBA. Will continue with the course, but without the urgency. Had I new how to compose a song, Don C would be remembered by ballad. thanks again, Todd's less-keys-typed board

by Todd's keyboard - Tips and Deals

In Excel, how to insert date in a cell based on another cell? - Today

A shared Excel spreadsheet asks people to enter their initials in one column (A) and today's date in another column (B). Is there a way to leave the cells in column B empty until someone enters an initial in a cell in A. Entering initials should automatically insert the current date in the corresponding cell in B. My first attempt using an IF statement in B1 does not work. The hope was that

by Todd's keyboard - Tips and Deals

Re: Likes the "idea" of engineering, but not necessarily creating things. Any parents of teens wanna check in here? - 7 days ago

Might there be any interest in serving in AmeriCorps? With the benefit of hindsight, I wish I would have been more open to the idea of taking on some student debt to go on to a doctoral program. Working one or two years as a university professor would have taken care of that debt. As it turned out, it's been a pretty varied (and interesting) career. Todd's multifaceted keyboard

by Todd's keyboard - Tips and Deals

Re: MR Forum Confessions - 8 days ago

If folks knew how long I use disposable razor blades, I might well be banned from this forum. (Or, given the motto, awarded a prize.) Todd's keyboard

by Todd's keyboard - Tips and Deals

Video of young woman performing an elegant, circus juggling routine - 21 days ago

Folks, In a thread some posts down, That girl and her bike, I mentioned the difference between bicycle performers and competitors. This video of a young woman's (Lena Smaha) juggling routine (about 1'05") is a good example of how a circus performer incorporates dance moves and poses into an act, instead of striving to make straight lines. It's also a beautiful routine. AFAIK, the id

by Todd's keyboard - Tips and Deals

Re: MR Forum Fit Club: Balancing out those carbs - 22 days ago

My wife and I are on an island for spring break. With the rowing machine left at home, I've been walking the in-laws' puppy twice a day. The puppy is too big and rambunctious for the eight-year-old nephew, so the task has fallen on me to teach it some restraint. Putting in 10k+ steps a day. I guess the upper-body workout comes from the puppy tugging on the leash to greet and jump on other peop

by Todd's keyboard - Tips and Deals

Re: That girl and her bike - 23 days ago

CNAC (Centre National des Arts du Cirque), the French circus school where I used to teach juggling, had a strong training program for bicycle riding similar to the skills demonstrated in the video. I remember the students commenting that the style was too German. For example, notice how the woman frequently poses with arms straight out to the side. While that is desirable in competition, a circus

by Todd's keyboard - Tips and Deals

Re: why does the media care so much about Meghan and the UK scandals? - 5 weeks ago

Quotesamintx I will spring for that. Royals a bunch of fallderall. Like fancy dressed puppets. Not much to say about the Royals. I do love that Sam spells folderol like a true Texan. Todd's Adesso y'all keyboard

by Todd's keyboard - 'Friendly' Political Ranting

Re: Question(s) about replacing spinning hard drive with SSD in 2010 MacBook Pro - 5 weeks ago

Success! Thanks again for the advice. Am writing this on a newly-upgraded, mid-2010, MacBook Pro 15" with 8GB of memory and a 1TB SSD. (Courtesy of our sponsor.) The difference in speed is noteworthy. I'm not sure why I did not opt for 16GB of memory when I place the order. What follows is lengthy. Before I get started I'd like to share some experience that may help someone. I also ord

by Todd's keyboard - Tips and Deals

Re: Question(s) about replacing spinning hard drive with SSD in 2010 MacBook Pro - 5 weeks ago

Thanks for the questions. I'll have to fire up what I have when I've got a bit more time. The SSD from the iMac is not a clone. It's the SSD that was pulled from a faulty iMac and has now got its own housing. The iMac was probably circa 2012, or so. T's kb

by Todd's keyboard - Tips and Deals

Re: Question(s) about replacing spinning hard drive with SSD in 2010 MacBook Pro - 5 weeks ago

Thanks for the advice. I've never created a bootable USB stick. Will look into it. I have already cloned the SSD from my MacBook Air to the MacBook Pro. The new Mac Mini (running Catalina) does not recognize my iPod Shuffle and older iPod. I listen to a lot of audiobooks on the iPod Shuffle and will use the MBP for that. Plus, the MBP has a Firewire port. I've got a lot of old Hi-8 videotapes

by Todd's keyboard - Tips and Deals

Question(s) about replacing spinning hard drive with SSD in 2010 MacBook Pro - 5 weeks ago

A friend kindly donated an unused 2010 MacBook Pro. My OWC order of 8GB of RAM (maximum in this model) and an SSD (to replace the current spinning hard drive) finally arrived. I knew shipping would take a while, as I opted to not pay for expedited shipping. I was surprised to follow (virtually) the package from Chicago, to Miami, to Fort Lauderdale, to Detroit, to Toronto, to Vancouver (with

by Todd's keyboard - Tips and Deals

Re: Tiger Woods injured in rollover car crash, extracted with 'Jaws of Life' - 6 weeks ago

My memory is that stretch of Hawthorne is a steep descent. Used to drive it fairly frequently in high school. I think it was posted at 45mph back in the seventies. I received my only speeding ticket doing 59. (Again, it's a pretty steep downgrade. To my new-driver sensibility, I was coasting.) Wish Tiger the best. Todd's knock-on-wood keyboard

by Todd's keyboard - Tips and Deals

Re: seeking recommendations for return-address labels - 8 weeks ago

Thanks for the feedback. I just ordered a stamp and some return-address labels from Vistaprint. A friend (former tenant) has agreed to handle fulfillment for my micro-business offering a book, DVD and supplies for dice stacking. All of the materials are in the US, and I am not allowed to cross the border from Canada. I need to make the situation as convenient as possible. thanks again, T

by Todd's keyboard - Tips and Deals

seeking recommendations for return-address labels - 8 weeks ago

Later today I will create an image for some custom-made, return-address labels. The current choice is vistaprintcom. The standard dimensions are 2.67" x o.83". I would prefer a standard size that is just a bit taller. Any recommendations? thanks, Todd's sticky keyboard (Oh, dear. Hope Newt doesn't see this sig.

by Todd's keyboard - Tips and Deals

Re: What’s your Super Bowl food will you have? - 2 months ago

To help support a local restaurant here in Vancouver, my wife and I ordered a "BBQ Tailgate Special" from Railtown Catering. After it comes home a brother-in-law and nephew will come by for some portions that they each can enjoy at home. After placing the order, the restaurant asked if we were having a party. We explained the situation, and all is good. I suspect the British Co

by Todd's keyboard - Tips and Deals

Update to: Any tips on for better long-exposure night photos? - 2 months ago

A few weeks back you all shared some advice on how to take better low-light photos. I didn't even know that mirrors could be locked. So, first thanks for that tip. One night after that I set the camera to Aperture Priority (f-stop 8) and took several shots at different ISO settings. The camera allowed far too much time for each exposure with blurry results. On a subsequent evening, I wen

by Todd's keyboard - Tips and Deals

Re: Driving from Wisconsin to Wyoming in June - 2 months ago

In the summer of 1971 the Crazy Horse Memorial was not much more than an idea. Some photographs of the mountain painted with an outline of the finished project let folks see the vision. It's on my modest bucket list of places to re-visit, to see what it looks like now. Todd's patient board

by Todd's keyboard - Tips and Deals

Re: Seeking tips on how to manage multiple browser windows - 2 months ago

Thanks for the suggestions. Have experimented a bit with Tabs today. It will take some time to understand how they work and to feel natural. I'm sure I unwittingly closed several Tabs (and Windows) throughout the day. I can see it will help. If it were not for the limited desk space, I would just buy a second monitor. In fact, I have an unused 19" monitor that would be very handy, but

by Todd's keyboard - Tips and Deals

Re: Seeking tips on how to manage multiple browser windows - 2 months ago

Hmm, I've never considered using Tabs before. I agree, I do keep having to move and re-size multiple windows, which takes up time. My initial reaction is that I need to see multiple items—from different windows—at the same time. I do a lot of copying and pasting to grab information from one online list over to send e-mails. I'll experiment with Tabs, though. thanks, Todd's keyboard

by Todd's keyboard - Tips and Deals

Seeking tips on how to manage multiple browser windows - 2 months ago

My work flow requires having multiple browser windows open. Some of the pages require passwords. Even though Safari remembers the passwords, I still have to click through to load them. At the end of the day, it's easiest to just Quit Safari and then open the pages I use for personal reasons. I'm assuming there is some app that can open sets of pages with one click. Providing appropriate pa

by Todd's keyboard - Tips and Deals

Re: Friday Funnies - 2 months ago

This Friday is a very strong batch. "Oops, I dropped the toothpaste," Tom said, crestfallen.

by Todd's keyboard - Tips and Deals

Re: Best practices for cold weather bicycling? - 2 months ago

ln Vancouver, BC, winters I found an insulated bib was much better than insulated pants at keeping my mid-section warm. I also discovered there were certain situations where it was better to walk my bike, rather than slip and fall on the ice (in front of cars). Todd's ski-board

by Todd's keyboard - Tips and Deals

Re: MR Forum Confessions - 2 months ago

In spite of being a former river guide, have never been able to step in the same river twice. Plus, after all these years, still can’t surrey down. Todd’s fluvial board

by Todd's keyboard - Tips and Deals

Re: Everything on Amazon just switched to Spanish. Anyone else? - 3 months ago

y-dos-k

by Todd's keyboard - Tips and Deals

Re: Bose 201's - 3 months ago

Stick around long enough, and many of your early fantasies may be fulfilled. A friend has offered his set of Bose 901s (that have been in storage for over ten years). It is tempting, but my own set of Energy Take 5.1 speakers are already in storage. Called another friend (about to retire from academia) over the weekend to see if his college has a program to sell off old MacBook Pros. His pa

by Todd's keyboard - Tips and Deals

Re: Any tips on for better long-exposure night photos? - 3 months ago

Thanks for the feedback. I was concentrating so much on using long exposures and adjusting the ISO, I forgot that the camera was set to Auto exposure. It’s raining today, so won’t try again until tomorrow or the next day. Thanks again, Todd’s learning-curve board

by Todd's keyboard - Tips and Deals

Any tips on for better long-exposure night photos? - 3 months ago

Folks, Here is the best of a series of photographs with a Canon dSLR EOS Rebel T2i camera. The lens is an 80-240 that came with the camera. The camera was set up on a cheap tripod (maybe too flimsy). I used a cable remote to activate the shutter. The camera was set on Shutter Priority. I took a series of the same shot. The settings were ISO 400, 800, and 1600. Each ISO got time-lapsed sh

by Todd's keyboard - Tips and Deals

Re: Third-party, wired remote not taking pictures with Canon Rebel T2i - 3 months ago

Mystery solved! Loosening four small screws let me open up the plastic housing containing the wires and connections. Depressing the plastic button depresses (depending on pressure) one, two, or three metal springs that make electrical contacts. One of the wires inside the housing was between two of the metal springs. Moving the wire to the side—next to the other two wires—allows all thr

by Todd's keyboard - Tips and Deals

Third-party, wired remote not taking pictures with Canon Rebel T2i - 3 months ago

What step am I missing to not be able to take photos with a KiwiFotos UR-232 remote cable switch? When plugged in, half-depressing the remote button gets the Canon to make the necessary meter and focus adjustments. Unfortunately, I get the same results when depressing the button all the way down. The camera never actually takes a photo. In low-light situations, the flash pops up and a flash

by Todd's keyboard - Tips and Deals