31
January
2015

Canon MX700 does work with Yosemite despite what Canon says.

This is the first time I’ve seen a printer lose compatibility. Canon says that the MX700 no longer works with Yosemite. Somehow I can’t believe that it is this broken. So the investigation begins: One clue is that someone says that the Twain driver support was removed with Yosemite, but there is a fix where […]

31
January
2015

miniDisplayport adapters

Well, Apple just uses mini Displayport (and Thunderbolt 2.0), but the world of third party monitors use many other connectors. Here’s a connector decoder ring: To HDMI. The modern Retina MacBook Pro can pus the 

31
January
2015

MacBook Pro Retina tips and tricks on buying

As I said Appleinsider is a good place to buy. Adorama usually has the best prices for these things. The  best buy seems to be (for software developers) the MacBook Pro Retina 15″ with 16GB of memory and 256GB hard drive. But right now you can only get it in store for $2K with 3 years […]

30
January
2015

MythTV 0.27 on MacPorts using HDHomeRun Prime and schedules direct

Trying to build this. We used 0.25 for a long time, but this is now obsolete. And the RAID0 drives were showing problems, so went to a complete rebuild with MythTV with MacPorts. It now uses mariadb instead of mysql. So onto running setup for Mac MythTV isn’t the same as the MacPorts setup and isn’t quite right […]

30
January
2015

SUMIFS and blank cells

One thing that isn’t well documented is what happens to Excel is there is a blank in a cell. By experimentation it turns out that the wildcard “” does *not match a blank cell, so you need to make sure that you have something in every cell if you want to match it.  Interestingly, stackoverflow […]

26
January
2015

Excel SUMIFS, SUMPRODUCT and SUM magic

Man the old days of Excel are long gone, now you can generate incredibly powerful array actions so easily when doing the equivalent of database lookups. As ablebits.com explains this thing starts to look like APL: So for instance to add all the cells in column C where column A has the text “apple” and […]

25
January
2015

Mac Excel Shortcuts

Using Mac Excel heavily and it is good that some of my favorite commands are still there and there is a long shortcut list Most Mac keyboards, you need the additional FN key To Press Open the Formula Builder FN + SHIFT + F3 Repeat the last Find (Find Next) FN + SHIFT + F4 […]

25
January
2015

SSD recommendations for different server workloads

A great conversation with Vlad about setting up different servers in a development environment. Many of these loads are today run in virtual machines on a single system. The latest hypervisors have reduced the VM overhead to 5% so it makes so much sense to run them virtually particularly if you dedicate a slice of […]

02
January
2015

MSI GT72

Well, this is one shall we say “manly” laptop. I do have to say I’m spoiled by the industrial design of Apple. But nonetheless, it is certainly powerful (if amazingly thick and bulky). Here are some tips, tricks and traps: Tricks on Magic Keys The documentation is pretty unclear, but there is a BIOS setup […]

%d bloggers like this: