JavaScript modification/fix for Embedded Excel Web App

IN PROGRESS
Bids
3
Avg Bid (USD)
$103
Project Budget (USD)
$30 - $250

Project Description:
This project requires you to have or obtain knowledge of Excel Web App embedding using Javascript API. Found here http://www.excelmashup.com/APIBrowser#example100

Essentially, it is possible to embed a SkyDrive hosted Excel Spreadsheet into an HTML file located anywhere and create interaction with the spreadsheet live. I have a part completed project that needs completing to spec. You will need to understand how to embed files from Microsoft Sky Drive.

Take a look here http://www.selfpacedstudy.com/project/1/

It's a simple spreadsheet that allows you to select a test by entering an x next to the desired test. When you press enter after entering the x, the column that says, "Test Selected Was" will tell you what test was selected. Ignore where it says, "Fake Tests" as this is in development. A JavaScript was produced that adds a drop down box (bottom left). See here so far so good http://www.selfpacedstudy.com/project/2/

Ok, so what I now need is to only show the part I need people to see. Take a look here to see roughly what I want the embedded part to look like http://www.selfpacedstudy.com/project/3/

See what happens though when the embedded part is shows along with the drop down script.

Click here http://www.selfpacedstudy.com/project/4/

It works except that it's all over the place. The script is still working just it's no good basically.

My requirement is for this script to work so that when you select the test, the spreadsheet remains presentable and look like http://www.selfpacedstudy.com/project/3/

Please be aware that this is a test spreadsheet and will not be the actual spreadsheet or HTML file that will be used. I will need the Javascript to be portable onto another spreadsheet.

Some things to know about the script:

1) js.js has a variable defRange:"G3",

G3 is the location of a cell where the test range is found. I need the JavaScript file to not use G3 but instead refer to a pre-defines named range. The spreadsheet is already setup with a named range which can be used. The reason for this requirement is so that I eventually wont have to define the range in a cell but rather in a variable in the spreadsheet.

2) item: "testArea"

This variable is setup when a create the embed code from the Sky Drive. It's also possible to just create a named range in the spreadsheet itself and then use that.

Additional Project Description:
01/24/2013 at 16:12 GMT
Please note that once the script is completed, I will need to test it on my live site to ensure it works correctly. Small modifications may be required if it fails to work. The project is complete when it works on my live site.

Skills required:
Embedded Software, Excel, HTML5, Javascript, jQuery / Prototype
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: js.js index.html jquery.js
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire LightITGroup
$ 70
in 10 days
$ 40
in 20 days
$ 200
in 3 days