Thursday, November 3, 2016

Aruba

Aruba gets my vote for the best Caribbean vacation island, but if you can't take the heat, stay out of this kitchen. But with the help of the consistently brisk winds and a beach umbrella you can hold your own. Personally I would go out and run in the heat and jump into the pool afterwards. Yeah, I'm nuts that way.

Aruba is Dutch and its location just north of Venezuela brings in Spanish influences. English is spoken everywhere, unlike some other islands. For a chillaxing vacation, check it out.

http://www.aruba.com/


Wednesday, November 2, 2016

Delta's Bag View

Delta Airlines bag app just got cooler with its newfangled ability to show you the last checkpoint your bag passed through.  If you suffer from "new-city-no-clothes" syndrome, this can help calm your fears.

http://news.delta.com/delta-gives-customers-first-ever-map-view-bag-s-journey


Tuesday, November 1, 2016

Google Domains

I've been using GoDaddy for years, but the next time I renew paulishing.com I'll be checking out Google Domains to save $3 per year.

https://domains.google/



Monday, October 31, 2016

Otto Beer Run

The first commercial delivery by a self-driving 18-wheeler is in the books, but who would have guessed that Uber and 2,000 cases of Budweiser would be involved?  Otto, a company that was just formed this year and purchased by Uber in August, was the tech behind the 120-mile trip between Fort Collins and Colorado Springs, and Uber's desire for a piece of the $720 billion annual trucking industry revenue.

http://www.nytimes.com/2016/10/26/technology/self-driving-trucks-first-mission-a-beer-run.html


Friday, October 28, 2016

Chicago Dog

I love Chicago-style hot hogs and this beauty was munched during a recent layover at O'Hare airport. Just looking at this picture makes my mouth water and my tummy grumble.

As a side note, O'Hare's airport code is ORD, but that first "O" does not stand for O'Hare. The original name was Orchard Field Airport, named after Orchard Place, the small farming community where the government built an air base in 1942.  So ORD came from ORcharD. It was bought by the city of Chicago after WWII and renamed to O'Hare in 1949.

https://en.wikipedia.org/wiki/Chicago-style_hot_dog

https://en.wikipedia.org/wiki/Orchard_Place,_Illinois


Thursday, October 27, 2016

Girls Named Richard, Boys Named Sue

Google's BigQuery tool includes a public data set (usa_names.usa in the query below) that contains 5,552,452 first names gleaned from U.S. Social Security applications between 1910 and 2013. Querying that data shows that some women are named using traditionally male names like "Richard", the top years shown below. Perhaps Johnny Cash would not be surprised that ten baby boys have been named "Sue". Sigh ... what were they thinking?

SELECT name, gender, year, count(*) as popular
FROM [bigquery-public-data:usa_names.usa_1910_2013] 
WHERE NAME = 'Richard' AND gender = 'F'
GROUP BY name, gender, year
ORDER BY popular DESC



Wednesday, October 26, 2016

Highlighting The Active Row In Excel

If long rows of numbers are numbing (pun intended) your eye balls, you can highlight entire rows. Here's all you need to do.
  1. Save your spreadsheet as a .xlsm (macro-enabled spreadsheet)
  2. Press ALT+F11
  3. Double-left-click your worksheet (e.g. Sheet1)
  4. Paste in the following nine lines of VBA code 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 0
With Target
.EntireRow.Interior.ColorIndex = 36
End With
Application.ScreenUpdating = True
End Sub

Go back to your spreadsheet and select a different cell.  The entire row of that cell is now highlighted in yellow, as shown below. If yellow isn't appealing, you can play around changing the value of the ColorIndex from 36 to other choices.  Visit the following link to see your options.

https://msdn.microsoft.com/en-us/library/cc296089(v=office.12).aspx#xlDiscoveringColorIndex_ColorIndexProperty


Tuesday, October 25, 2016

October 8, 1955

I was born on October 8, 1955, and courtesy of Weather Underground, I can see I was greeted into this world with a sunny day and a high of 63 degrees.  Can't they all be just like that?

https://www.wunderground.com/history/airport/KDAY/1955/10/20/MonthlyCalendar.html


Monday, October 24, 2016

Two Monitors, Two Spreadsheets

Your I.T. group has finally succumbed to your begging and pleading for a second monitor, but when you open two Excel spreadsheets you find you can't get them both visible at the same time, even though Word and PowerPoint behave nicely. Are you going crazy? Maybe, but this one is Microsoft's doing. But there is a solution.

Either hold the Shift key while left-clicking the Excel icon in your task bar, or right-click that icon and left-click on "Microsoft Excel".  Both methods will launch a separate instance of Excel, allowing you to put them on separate monitors.

http://www.thewindowsclub.com/open-a-second-instance-of-an-open-application-in-a-click-in-windows-7


Friday, October 21, 2016

Charlie's Deli

Located a couple of miles northeast of downtown Dayton, Ohio, Charlie's serves up delicious sandwiches like the Cuban I recently had (shown below). Cabbage Rolls, a Rueben and a Gyro are also on my gotta-have-soon list, but you will find about any kind of sandwich imaginable.

Open Monday through Friday from 8 am to 6 pm, so this is not a weekend joint.

https://charliedeliandcatering.com