Final spreadsheet -
https://docs.google.com/spreadsheets/d/1bNKTVyXhx97BmLq2yWsKPHpD8bmp4LjgWYzup9YHi28/edit
POY Points Calculating widget -
<script type="text/javascript">
function calcLeaguePoints() {
var participantCount = document.leaguePoints.participantCount.value * 1;
var buyInCost = document.leaguePoints.buyInCost.value * 1;
var totalExpense = document.leaguePoints.totalExpense.value * 1;
var finish = document.leaguePoints.finish.value * 1;
answer = (Math.sqrt(participantCount * buyInCost * buyInCost / totalExpense) / (finish + 1)).toFixed(2);
if(isNaN(answer)){answer="";}
document.leaguePoints.answer.value = answer;
return true;
}
</script>
<form name="leaguePoints">
<table class="pointsform">
<tr>
<td class="left-field">Participants:</td>
<td><input type="text" name="participantCount" size="5" maxlength="5"/></td>
</tr>
<tr>
<td class="left-field">Buy-in cost:</td>
<td><input type="text" name="buyInCost" size="5" maxlength="5"/></td>
</tr>
<tr>
<td class="left-field">Your total expense:</td>
<td><input type="text" name="totalExpense" size="5" maxlength="5"/></td>
</tr>
<tr>
<td class="left-field">Your finish:</td>
<td><input type="text" name="finish" size="5" maxlength="5"/></td>
</tr>
<tr>
<td style="text-align:center;" colspan="2">
<input type="button" style="text-align:center;font-size:0.5em;" value="Calculate League Points" onclick="calcLeaguePoints()"/></td>
</tr>
<tr>
<td class="left-field">League points:</td>
<td><input type="text" name="answer" size="5"/></td>
</tr>
</table>
</form>
No comments:
Post a Comment