This file is something I put together to relate sols for all Mars lander missions to the standard Mars calendar devised by Clancy et al. and now widely used with orbital data. I'm posting it in case it might be useful to others.
It's an Excel file, so it can easily be extended if necessary. Each mission is given three columns, one for mission sols on the surface (some start with sol 0, some with sol 1, according to mission usage), one for the Mars year and one for the sol of that year.
Please note that there may be discrepancies of one sol here and there because I am simplifying things quite a lot here. For instance, MER-A and MER-B are half a planet apart, so their sols are half a sol out of phase, but I'm ignoring that in relating them to the planet-wide sol of the Clancy system. Details of the Mars calendar can be found on Emily's website at:
http://www.planetary.org/explore/space-top...s-calendar.html
(I have made independent lists of Mars historical dates in my forthcoming Mars atlas). And conversions to Earth dates can be made via this VERY useful website:
http://www-mars.lmd.jussieu.fr/mars/time/martian_time.html
Phil
Click to view attachment