I was hoping to get help using Google Spreadsheet data with a script I have paste below. The script is a calculator/comparison tool, that compares movie rating with one another. Essentially, the scrip displays two drop down lists (both lists are identical), and you choose one movie in one drop down and another movie in other drop down, then you hit calculate. Inside the script, which you will see below, I have assigned values to each movie and as you can imagine, this becomes tedious. So what I would like to do is use a Google Drive Spreadsheet to almost power the data inside this script, so when the google spreadsheet is saved, the values change inside the script.

1. Here is the google spreadsheet (viewable): https://docs.google.com/spreadsheet/...zRNakFVVHExYkE

... as you can see, the data is pretty straight forward, and matches what's inside the script, however, given I'm forced to surround the data by '<option value=xx.xx> and '</option>, I am unsure how to allow the data on the spreadsheet to power this calc.

2. Script:
HTML Code:
<html>
<head>

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-30589636-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
<body>

<select id="player1">
<option value=00.00>SELECT MOVIE</option>
<option value=80.50>X-Files 1 (Sci-Fi)</option>
<option value=78.50>Star Trek (Sci-Fi)</option>
<option value=100.00>Die Hard 1 (Action)</option>
<option value=88.50>Die Hard 2 (Action)</option>
<option value=58.00>Die Hard 3 (Action)</option>
</select>

<p>Vs.</p>

<select id="player2">
<option value=00.00>SELECT MOVIE</option>
<option value=80.50>X-Files 1 (Sci-Fi)</option>
<option value=78.50>Star Trek (Sci-Fi)</option>
<option value=100.00>Die Hard 1 (Action)</option>
<option value=88.50>Die Hard 2 (Action)</option>
<option value=58.00>Die Hard 3 (Action)</option>
</select>
<input type="button" value="Calc" onclick="calcVals()"/>

<p>=</p>

<div id="results"></div>
<script type="text/javascript">

function calcVals() {
var score1=document.getElementById("player1").value
var score2=document.getElementById("player2").value
var pick1=document.getElementById("player1").options[document.getElementById("player1").selectedIndex].text
var pick2=document.getElementById("player2").options[document.getElementById("player2").selectedIndex].text
var grandscore=score1-score2;
if (grandscore==0){
document.getElementById("results").innerHTML=pick1+" <p><strong>is as good as</strong></p> "+pick2
} else {
document.getElementById("results").innerHTML=grandscore>0?pick1+" <p><strong>is better than</strong></p> "+pick2+" <em>by</em> "+grandscore+" <strong>percent</strong>":pick2+" <p><strong>is better than</strong></p> "+pick1+" <em>by</em> "+Math.abs(grandscore)+" <strong>percent</strong>"
	}
}
</script>
So, again, in Summary:

I. I would love to have the above script adjusted so that automatic saves on the Google Spreadsheet will just show up on the calc.
II. I essentially do not want to even have to open up my javascript file any longer, I'd like to just have to update my google spreadsheet


Thanks in advance if anyone can provide a solution to this!!!!