Tuesday, August 23, 2016

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

Saturday, August 20, 2016

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.

Friday, August 12, 2016

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

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!