May 2015

Splitting .csv files that exceed Excel's row limit

  • Posted on: 29 May 2015
  • By: davis

Best tool for the job I've found: Open Source CSV File Splitter (OSV)

Very quick and easy to use. Specify lines per chunk file and you're good to go.

Keep in mind many office suites (OpenOffice/LibreOffice) have row limits around 65k (pre 3.3.3: limit is 65,536 rows | 3.3.3 and later: 1,048,576 rows)

In Excel 2010, the maximum worksheet size is 1,048,576 rows.

If You Use Reddit, Bernie Sanders Is Hoping You're A Fucking Idiot

  • Posted on: 5 May 2015
  • By: davis

Isn't it crazy how Bernie Sanders articles keep appearing on Reddit?

On the front page, no less. It's almost as if there's a concerted effort to game the voting system and shove a candidate into a demographic hotspot.

Good for them, Reddit needs to learn its lesson. It probably won't.

A Beautiful Game

  • Posted on: 3 May 2015
  • By: davis

If you've met me and talked with me for some length of time, you're probably aware that I really like video games. I don't just like video games - I specifically enjoy matching up against players of equal skill and playing a thrilling mental battle.

When I was young, I used to butt heads against the world's best (matter of fact, I was the world's best in one game). 

I am sometimes asked if "that's it." So.. you play a video game against people?

The point isn't the video game. I happen to prefer First Person Shooters - they are raw, real, and in your face. You are against them. Nothing else matters.

What's lovely about video games is that it's a very even playing field. There are certain limitations that everyone is limited by - a player model can only move 100 units/second. That applies to everyone. Now, who can do the most damage with that restriction?