Excel Log Tips And Tricks

[[old] Jim Barry]

Excel tips:<br /><br />Just thought I'd share a piece of my rowing log for those that log their sessions in Excel. Add to this FAQ if you have some more. <br /><br /><br />To have the spreadsheet do the 500m average pace automatically: <br />Put the distance in the A column. The minutes in the B column. The seconds and tenths of seconds in the C column. Then in the D column put this:<br /> <b>=(B1*60+C1)/(A1/500)/86400 </b><br /><br />Format the cell with <i>custom</i> type mm:ss.0 (may have to type this format in manually if it is not available from the custom selections "menu").<br /><br /><br />For watts it's <b> = (A1/(B1*60+C1))^3*2.79 </b>(put that in column E)<br /><br />If you put the Stroke rate in column F then you can get Watts/Stroke Rate Index (aka SPI) as easily as <b>=E1/F1</b><br /><br />Meters Per Stroke is <b>=A1/(B1+(C1/60))/F1 </b><br /><br /> <br /><br />And finally, the average airspeed of an unlaiden sparrow put in Bird's distance (meters) in column G, the time (in seconds) it took in column H and the formula as =G1/H1 <br />

[[old] tjod]

<!--QuoteBegin-Jim Barry+Dec 14 2005, 01:21 PM--><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td><div class='genmed'><b>QUOTE(Jim Barry @ Dec 14 2005, 01:21 PM)</b></div></td></tr><tr><td class='quote'><!--QuoteEBegin--><br /><br /> <br /><br />And finally,  the average airspeed of an unlaiden sparrow put in Bird's distance (meters) in column G, the time (in seconds) it took in column H and the formula as  =G1/H1  <br /> </td></tr></table><br /><br />English or Afican? <br />