News


Poker in a Spreadsheet

posted Aug 17, 2010, 7:15 PM by Jonathan Rochelle   [ updated Oct 21, 2011, 6:49 AM ]

Check out the "Texas Hold'em Simulator" if you want to see the kookiest thing ever done in a spreadsheet - well, besides all the companies who run their whole businesses on spreadsheets ;) .
This is serious spreadsheet formula madness. There's some value in learning how to do the card dealing using a series of random numbers and the Rank function - and perhaps some interesting ways to interpret numeric results into a set of coherent sentences (for saying things like "Two Pair, Aces over Jacks" or "Straight, ten high". Other than that, the simulation is just for fun - allowing up to 14 hands to be dealt, with a simple Script used to poke a value into a dependent cell to make the whole thing recalculate.

Tweetquency 1.0 - chart of tweeting frequency

posted May 20, 2009, 6:57 PM by Jonathan Rochelle   [ updated May 20, 2009, 7:00 PM ]

Given all the various styles of tweeters, we thought it would be interesting to see a chart of the duration between tweets for various people. Theory has it that there are distinct patterns here - so look for a post soon on that - so you can quickly size up any tweeter you're considering following. Get a feel for their style first so you don't follow a chatty Matty if that's not your thing.

This is a really basic version...
> Enter a twitter screen name
> the spreadsheet grabs (into the second sheet), the 99 most recent tweets from that person
> the chart reflects the duration between tweets

Look for a new version coming soon which gives much more information on the Tweeter and lets you grab up to 500 tweets for analysis. Be sure to contact us by filling out the feedback form if you have ideas or questions!

Learn more - and Get your own copy of Tweetquency

Tweeting Tools - what's popular?

posted May 20, 2009, 6:54 PM by Jonathan Rochelle   [ updated May 20, 2009, 6:56 PM ]

See this quick(-ish) analysis of 3,000 public tweets to see what tools people are using to tweet. The Twitter api provides the "source" tool used for public tweets, so I grabbed 1,000 tweets each day for 3 of the days in the week of May 11 - 17, 2009. This spreadsheet shows the results - it does't show the detailed summaries or other boring details - just the answer ;)   - We'll likely repeat this analysis on a semi-regular basis if enough people find it useful.

TweeterSheet: Tweeting Tools Used - report


1-3 of 3