This was born from Kevin Burton's post a few weeks back, which included a spreadsheet that compared the raw r-values and weights of various sleeping pads. Most pads can be cut down or bought in a smaller size to save weight, so comparing raw weights to R-values doesn't really help decide which pad is the best to use. This got me thinking, so I took his spreadsheet and added a few pads but mostly another comparison–I factored in the dimensions of the sleeping pad, allowing for a more accurate description of the value of each material. Because most pads are the same size, this doesn't affect most pads, but without it some pads would gain an advantage over others simply by being smaller, shorter, more narrow, etc.
Basically, where 'weight' was on Kevin's spreadsheet, I added "area density"–a calculation of the number of grams in each square centimeter of pad area. Then, I calculated what the R-value of a "standard pad" would be, using the average weight and standard pad size. This came out to 500 g (about 1.1 lbs) and 184×54 cm (about 74"x20"). Essentially, column D is a raw, abstract number which standardizes all the data (and has complicated units), and column C simply converts that into a number we're familiar with, which is R-value.
I'll comment on the top pads of this list when I have more time. For now, here's the spreadsheet. I encourage you to download it and modify it to fit your own needs (as I did with Kevin's spreadsheet). I'm also going to keep this up to date with any new pads which come along, as well as any that people would like me to add. All I need is data.
https://docs.google.com/spreadsheet/ccc?key=0AoQR5Mz_cmEudGlZcW1hNUg0OHd2ZGZmSWdOT2lvd1E#gid=0
There are several factors which are still not, and cannot, be factored into this. The primary one is comfort, but I also take packed size very seriously–that's why I use the Klymit X-lite in summer.
Another thing to keep in mind is that I'm not sure how much value you get out of an R-value much greater than 5–do the increasing R-values keep improving sleep comfort or is there a point where it is no longer worth it?
Note: as mentioned above, most of the data was collected and produced by Kevin. My own modifications are simply one step further to flesh out the information provided here.

