I’m in the middle of knee rehab after an ACL recon in june. Surgeon is dead keen on cycling for rehab so I started off using my old Rockhopper on a turbo then out on the road. I was interested to try and find out what gears on the MTB would be equivalent to my compact road bike so i made up a very basic spreadsheet to look at gear ratios and how that translated into road metres for each crank turn.
You can have a look at it here.
Should be self explanatory. Replace the red numbers for your own front and rear set ups and wheel size, then read across to the tables on the right for ratios, gear inches, and road metres. It’s interesting to see where up the cassette the crossovers occur.
It’s only my second ever go at a spreadsheet so no laughing, and no doubt there are slicker versions around.
ps, first go at using dropbox too so hope it works.