Quick Link to Re-Setup Google Chomecast

I don't known why this doesn't always pop-up when I search but I've recently had to setup a bunch and I keep ending up on the "Set up Chromecast" support page link which is not helpful when all I need is this:

https://www.google.com/chromecast/setup/
Just click "Set up your chromecast" using this computer

Google Calendar Copy Event

Needed to Copy an event, not do a re-occuring event, just wanted to copy and Edit:

• Click on the Event to Copy
• [More Actions] Drop down tab 
• [Duplicate Event]

Turn off gray brackets in header in Word 2016

So I had to temporarily change my app local to Japan to run a Japanese game. Anyway when I went into word I had these strange gray brackets appearing in the header section. As described here it turns out they are "Crop Marks" or "Text Boundaries" the guy in that forum had the same issue. Anyway the solution is found here

Basically:

File > Options > Advanced > Scroll down to "Show Document Content" > Uncheck the Text Boundaries and Crop Marks

Clustered and Stacked Column and Bar Charts Excel 2016

This was an incredibly annoying issue I had since I could not figure out how to have multiple stacked columns for different categories on a chart. What worked for me was a combination of these two guides:

1. http://www.exceldashboardtemplates.com/how-to-easily-create-a-stacked-clustered-column-chart-in-excel/ This has good ideas on how to configure the table
2. http://excelhelphq.com/tutorial-clustered-stacked-column-bar-charts-free/ This actually shows you how to layout the data. Basically, you end up having multiple rows for the same series to have individual columns 

Debugging Diablo 3 with Steam Link and Steam Controller

So I really wanted to use my Steam Controller to play Diablo 3. However, when I added it to Steam and then launched it in Steam Link with the Controller, the sound came through fine, but the Steam Link would not display the actual game playing. Here are some quick recommendations

• When you add Diablo 3 to steam, go ahead and click the auto program link that pops up, once it has been added to the library: Right Click > Properties > Target > and change this from the Diablo III Launcher.exe to Diablo III.exe. 
• If you did this properly you should actually see the Diablo III Icon switch from the Red Icon to the Blue Reaper of Souls one, it also means you will have to manually sign into your Blizzard account when the game first launches
• Since I had the launcher set before, the steam controller was only in the desktop configuration, but once you have it launching the actual game you can see the community configurations for it. The very top one with the most downloads is quite good
• Once I switched it to the game instead of the launcher it also worked for Steam Link fine.

WNR3500Lv2 Poor Performance, Slow Wifi drops to < 1mbps

We had an old Netgear WNR3500Lv2 and some devices on the network would barely go over 1 mbps. There this post on the Amazon page
Amazon

YES! I've reported this to Netgear support and all they want me to do is keep sending them proof of purchase information and what not, and not addressing the issue! I had a batch of routers come stock with firmware versions 1.2.0.16_40.0.66 & 1.2.0.32_40.0.74 and both give insanely poor wireless speed tests, barely over 1M. After I installed firmware version 1.2.0.28_40.0.72, then wireless speed tests matched wired tests. Hope this was helpful to anyone having the same issues! see less 
By James B. on July 10, 2015

The Netgear Community forum had this thread on it Netgear

Re: Slow wireless 1/2mbs WNR3500Lv2

‎2016-01-06 10:20 PM

We restarted the router each time. We do not want to go through the trouble to re-configure by a factory reset. We down graded two versions to 1.2.0.28 and got back the speed. You have really got an performance issue for the last two releases! 

Backups for Windchill Quality Solutions 10.2+

I had a failed hard drive recently and with it a corrupted back up. It turns out that Relex / WQS files are not easily saved like a simple .file or .proj it turns out you need to make a backup of your SQL database that was created for Relex. You need to make sure when you installed SQL Server EXPRESS you also installed the management studio tools. If you didn't download the SQL Server Management Studio (SSMS). Sign in with the sa account, or if you forget you might be able to with windows credentials. Expand the Databases heading. Right-click on the database to be migrated and choose Tasks > Back Up. On the Back Up Database window make sure the Backup Type is set to Full. Lastly make sure to actually set a file name / location in by clicking [Add...] intuitively they don't have an automatic name for the .bak setup, so without it you can't actually create the backup. I'd recommend committing this .bak file somewhere safe because without it a migration to a new system is a horrible process.

Once again I'd still like to make note that PTC has excellent support.