Tongfamily (Richtong.com Sync)

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…

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)…

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…

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…

I’ve been using MythTV pretty well along with XBMC. XBMC’s add-on even lets you watch MythTV recording from a HD HomeRun Prime from XBMC and it all worked fine on Mavericks. Now in the Yosemite world and also the latest XBMC now called Kodi and the new MythTV 0.27. Here…

Well, built the second of four Haswell towers based on the SG-10B mini-tower using the ASRock Z97m OC Formula with the Noctua NH-L12 and the Scythe Rev B: Scythe Rev B. This is a low profile fan unit. The main problem is there is no clearance possible with the heat…

Some of the older applications like Unify for the Mac, need Java 6. The latest Mavericks removes the Java 6 and even if you install Java 8, it doesn’t work, so you need to install it from the Apple site as 2014-001

The SSD pricing is sure dynamic. So it’s nice that Tom’s Hardware updates this regularly which updates the Anandtech Best SSDs for July 2014 as well as StorageReview.com which did a good comparison of the Evo 850 Pro, Evo 850, Evo 840 and the Sandisk Extreme Pro which showed the…

Why would you pay an extra $50 for a cooler rather than use the stock one that Intel gives you for free? Well the answer is pretty simply put by Tom’s Hardware. The short answer is if you are not overclocking, then the Intel fan makes lots of sense Great…

We got three Seagate Constellation SAS drives (ST4000NM0043) drives and one thing about ZFS is that it needs to have identical drives because the number of sectors need to be the same. These were $319 and are 6GB drives. To fill this out, looking at ZFS Solaris and Aaron’s best practices,…