Got fed up having to refresh Sheldon Brown's site over and over and over again trying to work out all the information I needed to know for what my chosen Alfine gearing would give me...
So seeing as I had an hour spare, got busy on Excel and created myself an all singing, all dancing (well, not quite, but it does the job) spreadsheet for the Alfine, and now also the Rohloff Speedhub too.
Anyway, if you're interested, post your email address up on this thread and I'll email it to you for you to play with til your heart's content.
Hopefully it's fairly self explanatory, but it's totally unprotected so I should just mention that only input anything into the yellow boxes, and all measurements need to be in mm... That means 26" MTB rims are 559mm, 29ers and 700c are 622mm, tyre widths likewise in mm (so a 2" tyre is 51mm, a 2.2" is 56mm etc.), and also crank lengths...
Also the calculator works out what your equivalent gear would be if you had "normal" sized chainrings up front too... Say you wanted to know what your bottom gear is on your Alfine, but as an equivalent to if you had a "normal" 22T granny gear... Yup, it does that too...
So, just pop your email addy on here, I'll send it to you forthwith...
Feedback/comments/suggestions for improvement will all be gratefully appreciated too.
could I use it to factor in Hammerschmidt ratios as well? I guess I'd just run it twice with the different equivalent front gears?
Really helps me see what I'm going to end up with when I finally get my Hammer + Alfine rig up and running (the gearing looks quite good according to your table, which is nice to know 
