hide

Read Next

Playing draft style fantasy football with a spreadsheet

Okay, so as asked by a couple of people, how were we playing this using spreadsheets before? Well, I'll outline the process here, while trying to find a balance between keeping it short and sweet and still providing enough detail.

1. Use Google Docs!

It's free, and it allows everyone to connect at the same time. Also, as it's in the cloud, it is always up to date. You can look back at past revisions if necessary and is the ideal tool (short of a fully dedicated site) to play fantasy football in this way. Sample: https://docs.google.com/spreadsheet/ccc?key=0AiNH-JHpkhe8dFVVX2RiaDNyNUdZTFdieHliaUtUemc&usp=sharing

2. Decide between doing the entire game manually vs using an existing salary cap based fantasy game

Personally, none of our group could be bothered going through the hassle of creating a point scoring system, updating each player's scores manually, keeping track of transfers/team sheets and scoring the entire game manually which is why we went with the second option.

Knowledge Building the SAAS way

On DROdio

I've always been a fan of productivity & efficiency hacks to allow me to do more with the limited time in each day.  But lately, I've been working really hard to institutionalize these things within our company, PointAbout.

Everyone reacts a little differently.  Some people take to keyboard shortcuts easily, while for others using the mouse is a very hard habit to break.  I would liken keyboard shortcuts to blogging:  With both, there's a "valley of death" you have to get through before you emerge in the sunny field on the other side, and most people don't make it.  Both blogging and keyboard shortcuts require several weeks or months of concerted effort to prove successful, but once you emerge on the other side of that time commitment, you look back with the realization you should've done it years ago, it's so valuable.  Initiatives like the F1 GeekSpeed Challenge help make it a bit more fun.

One thing that's been easier to institutionalize has been the use of Basecamp , a cloud-based Software As A Service (SAAS) lightweight project management tool, instead of email.  I've gotten quite militant with everyone around me that if a conversation turns into a thread on email, or if you know it's going to be one, it should be moved to Basecamp.  There are several huge benefits to this approach -- again, not all of them immediately obvious.  The first is that it allows you to assign owners and dates to tasks, something email is notoriously poor at.  The second is that you have a threaded conversation, all kept in one place, and various people can be added & dropped to comments along the way as necessary (no more 'reply to all' hell).  These benefits are nice when they're happening, but invaluable as time goes on and the knowledgebase builds.

Today I came across a great example of exactly this.  Hayat, our admin, had asked me how to do some transcription work.  About 4 months ago, I had previously trained another admin on this.  Since I put the original training instructions on Basecamp, I was able to very quickly & easily call up the thread and just have Hayat read it + watch a video I had posted in the thread.  That was it -- I didn't have to do anything more than point her in the right direction, the rest of what she needed was perfectly memorialized on Basecamp from the first time I went through it.

It felt so great and refreshing to have successfully stored the knowledge in a place where it could be readily reused that I did a video to show off the details. Here it is -- enjoy!

Rendering New Theme...