Excel Formula to Find the First Monday of the Month

If your date is in A2, this formula will figure out the first Monday of the month for the month of the date in A2.

=IF(WEEKDAY((DATE(YEAR(A2),MONTH(A2),1)))=1,(DATE(YEAR(A2),MONTH(A2),1))+1,(IF(WEEKDAY((DATE(YEAR(A2),MONTH(A2),1)))=7,(DATE(YEAR(A2),MONTH(A2),1))+2,(DATE(YEAR(A2),MONTH(A2),1)))))

Getting the Phoenix/DX6i connector to work.

For some reason, the connector that came in the Simulator bundle did not work properly with the Spektrum DX6i transmitter. Really weird. You’d think that since it was all bundled together, the correct connector would be included. It would work if I held the connector halfway out of the back of the transmitter, but this was not a good solution as you had to hold it exactly right or the sim would stop and say that it did not detect a transmitter.

Solution:
Purchase a stereo headphone extension cord
Cut the cord in half near the middle.
Connect the red to the ground and the black to the black.
Tape it back up and my new cable works just fine!

(null)

Learning to Fly RC Aircraft

Phoenix RC Sim with DX6i

I have been wanting to get into Remote Control (RC) aircraft for a long time and I finally took the plunge. Well, kind of. I purchased an RC flight simulator kit that came with a fully functioning radio. I bought the Phoenix R/C Pro Simulator V5.0 with a Spektrum DX6i. After loading the sim and setting up the transmitter*, it became apparent that there is a lot to know about flying RC aircraft, and, after crashing almost immediately the first five times, it was probably the cheaper way to go!

Having learned how to fly full-size airplanes, I thought I’d go looking for a training syllabus like they have for FAA Flight Training. A quick search didn’t turn up too much. The Phoenix flight sim had some videos, but I was looking for some sort of RC flight training program I could follow.

Finally, after a bunch of searching, I found this book which looks pretty good. I think I’ll start there.

One Week To Solo by David ScottOne Week To Solo by David Scott
Link: http://amzn.com/098172261X

 

* note, the USB connection to the transmitter didn’t work out of the box. It connects via a 3.5mm “headphone” jack, but the one coming out of the USB adapter was a “stereo” adapter, and I guess the Spektrum needs a “mono” plug. I ordered a stereo to mono adapter and that seems to have solved it (while waiting for the adapter to arrived, I was able to get it to work by plugging it in half way, but it was definitely a short-term solution because it would keep popping out and then the sim would pause.) It is a little weird that they wouldn’t include the appropriate adapter out-of-the-box.