Sparkline

So today at work I came across a really cool feature in Microsoft Excel 2013. Enter the Sparkline.

Probably more of a gimmick but they look cool. They are a little chart that is just inside a cell. It can be a line,column or win/loss. They are easy to create and could be used if you don't the all of the features and hassle of a full chart.

Here's how to create a sparkline in excel:
Start by putting you data into one column. There aren't any labels so they don't really matter for this.

Then in the Insert tab on the ribbon find the Sparkline section and choose the style you want. This time we will create a win/loss style.

This will open the Sparkline dialog.

Select the data range. Make sure you don't select any labels as this will give an error.

When the Sparkline is created it will be small, the size of your cell so you will probably want to make the cell bigger.

And there you have it.

Probably just a gimmick but might be useful eventually.

Cheers,
Rex

Another project on the go

So after watching this Youtube video. My brother and I have decided to build him a computer based on the same principals as in the linked video. That is using slightly outdated top end or server hardware to build a computer on the cheap.

In this case the goal is to be able to run N3V Games' Trainz: A New Era with reasonable performance. The parts we have selected will allow us to meet the recommended specs for what could be the first time of any of this franchise.

We have only just begun procuring parts for this. But I am very excited about it and I am looking forward to assembling a computer that is more than just the best of the parts I have lying around the place. To find a list of the parts we're using follow this link to see the e-bay collection for the parts we have selected.

We have to wait for the parts to arrive however and there are still some descisions that can't be made until the parts arrive like PSU, case. But stay tuned because this build will enjoy exciting performance for an equally exciting price.

If you have any suggestions or questions please comment below with them so we can all benifit from the discussion.

Cheers,
Rex

Bad Youtube Playback arch

Shortly before I left on my holiday I came across a problem that has been getting worse and worse over time. When I watch a video on Youtube on my laptop it would use quite a lot of CPU. Inititally I thought well that makes sense, seeing as it is a video and I know videos are a fairly intensive thing to handle.

However it got worse, to the point where my laptop with a quite reasonable for the task Core i5 processor and practically nothing else running would eventually reach thermal cutout temperatures (>100 degrees C) and eventually to the point where it couldn't really play videos. Surely there must be a better way.

And it turns out there is a better way, seeing as I am currently running Arch Linux on there. Also I didn't have that problem on Windows or Debian on the same computer.

Turns out that in Chromium (Not quite Chrome) there is something funny with the rendering for web based playback. This causes massive CPU usage for no good reason.

The Solution?

Go to the URL chrome://flags then enable "Override Software Rendering List" (#ignore-gpu-blacklist)

I'm not 100% sure what it does, but a guess for the blacklist mentioned in the # name make me think that perhaps it was trying to do all of the rendering in the CPU. Rather than getting the GPU (Integrated but still better) to do that part of the hard work, for which it is much more suited.

This may also work on Windows or Mac if you are having similar problems. It certainly hasn't hurt my computer and has made it barely load the CPU at all with video playback now.

If you have any other tips or tricks for Chrome/Chromium that make it perform better please let me know so we can help share this information.

Cheers,
Rex