Google Spreadsheet into Wordpress - Marktastic + GrowSocial

$gsRSSArray = array(SimplePieWP('https://spreadsheets.google.com/feeds/cells/YOUR-KEY/od6/public/basic?min-row=2&min-col=10&max-row=6&max-col=10', array('enable_order_by_date' => false)));
unset ($RSSParseString);
foreach ($gsRSSArray as $key=>$value) { $RSSParseString = $value; }
$RSSParseArray = explode('<br />', $RSSParseString);
foreach ($RSSParseArray as $key=>$value)
{
switch($key) {
case 1:
$tmp = trim(substr($value,strlen(""),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewHuron'] = $tmp;
unset($tmp);
break;
case 2:
$tmp = trim(substr($value,strlen(""),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewOntario'] = $tmp;
unset($tmp);
break;
case 3:
$tmp = trim(substr($value,strlen(""),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewSuperior'] = $tmp;
unset($tmp);
break;
case 4:
$tmp = trim(substr($value,strlen(""),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewMichigan'] = $tmp;
unset($tmp);
break;
case 5:
$tmp = trim(substr($value,strlen(""),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewErie'] = $tmp;
unset($tmp);
break;
}
}

$huron = $_SESSION['crewHuron'];
$ontario = $_SESSION['crewOntario'];
$superior = $_SESSION['crewSuperior'];
$michigan = $_SESSION['crewMichigan'];
$erie = $_SESSION['crewErie'];
?>
<table>
	<tbody width="50" cellpadding="0" cellspacing="0" align="right" valign="top">
		<tr height="15">
			<td><h4>Huron</h4></td>
			<td><h4>  <? echo "$huron"; ?></h4></td>
		</tr>
		<tr height="15">
			<td><h4>Ontario</h4></td>
			<td><h4>  <? echo "$ontario"; ?></h4></td>
		</tr>
		<tr height="15">
			<td><h4>Superior</h4></td>
			<td><h4>  <? echo "$superior"; ?></h4></td>
		</tr>
		<tr height="15">
			<td><h4>Michigan</h4></td>
			<td><h4>  <? echo "$michigan"; ?></h4></td>
		</tr>
		<tr height="15">
			<td><h4>Erie</h4></td>
			<td><h4>  <? echo "$erie"; ?></h4></td>
		</tr>
	</tbody>
</table>
<?