Skip to content

Instantly share code, notes, and snippets.

View todd's full-sized avatar
🤘

Todd Bealmear todd

🤘
View GitHub Profile
@todd
todd / getissues.py
Created December 23, 2011 23:30
Download Hacker Monthly's Xmas Special off S3
# Edit: Changes inspired by comments from HN users jules and anthonyb
import os
for i in range(1,20):
os.system("wget http://s3.amazonaws.com/bearwithclaws.baconfile.com/hackermonthly-issue%03d.zip" % i)
@todd
todd / get_position.py
Created November 18, 2011 01:42
Count Columns in a Spreadsheet
"""
This is an overly complicated method I threw together to do something I could have easily done by
tallying on paper or something similar. That's not how I roll.
The method below will calculate the numerical position of a spreadsheet column based on its alphabetic
representation. I use a lot of VBA and Excel formulas at work that need this information to function
properly and I got tired to counting these columns manually - a real chore when you start getting into
columns represented by multiple characters.
NOTE: Excel is kind of inconsistent with its numbering format. Depending on what you're trying to