The new sobriety test

When police pull over a driver, they need an efficient way to
ascertain whether that person is drunk or not. Here is the new test:
Pronounce "literally"
Post a Comment

Popular posts from this blog

How to connect your Roku to Xfinitywifi

Image
When you login to Xfinity wifi with a computer you need to login with a browser.


But if you login from Roku there is no browser.


So to fix this you:

1. Do Roku -> Settings -> Information
2. Buy a Mac
3. Open Terminal

    sudo bash
    ifconfig en ether
    ifconfig en ether ****TYPE IN THE WIRELESS MAC HERE****

4. Close and reopen Wifi and connect to xfinitywifi
5. Login to Comcast
6. Open Terminal

    ifconfig en ether ****TYPE IN THE OLD ETHER HERE****

7. Use the Roku and get on xfinitywifi
8. Drinking
Read more

I Was Kidnapped in Manila and Lived to Tell About it

Image
Other potential titles:
The US Embassy Doesn't Want You Know About This Kidnapping in ManilaScopolamine / Devil's Breath Trip Report It started Easter weekend This story starts at Noon Tuesday April 18th, 2017 on Makati Avenue. I just finished a meeting with the Philippines Board of Investments to discuss how my company can expand our business in Manila. (Also saw the QBO Innovation Hub, it was awesome.) I had plenty of time to kill and some emails to catch up on, so it's time for some brain food!

I walked right to the hottest part of town, Makati Ave. and Jupiter Ave., surely there will be something good to eat. And then suddenly, The Guy approaches me, I'm marked. Hey, I know you are you staying at the Jazz Residences? Jazz is about a 12 minute walk to here, and I did not walk towards Makati Ave. from that direction since I just came from the meeting. I'm always guarded with information and paying attention to stuff like that. There's about 20 other places I could…
Read more

Excel bug/feature: recursive VLOOKUP for hierarchy calculations

Image
There's lots of Q&A websites out there talking about Excel bugs that are actually formula errors, and others that talk about recursive VLOOKUPs when they really mean iterative. To be clear on what we are talking about:
Excel (2007, 2010, 2011)  has an undocumented feature where you can use circular reference in the third argument of VLOOKUP without iterative calculation. Why should I care?  Here's one type of problem you can solve with this "feature". Suppose we have an organizational chart and want to find how many levels deep each person is. Similar to this problem posted on MrExcel.


IDBOSSNAME1John Smith21Susan Jones32Alice Johnson42Tim Moore51Rachel Parker61Tom Allen75Michael Gross85Kim Dole96Kathy Roberts106Betsy Foster1110Mini Foster
You can do it with this in cell D2:  
Read more