Can I insert an editable spreadsheet, e.g a payment calculator?

A client has asked whether I can insert a spreadsheet that calculates a monthly payment based on numbers that would be entered by the user.  Users have to enter 8 values.

I uploaded the spreadsheet to Google, made it public, and inserted it as a web object, published and it comes out as a static document.  Does anyone know of a way to upload this so learners can edit it?  Can I create something like this using variables?

Any ideas would be appreciated.

Jill

23 Replies
Dustin Bauman

Hi Jill,

Storyline is very powerful and you can use variables and triggers to calculate monthly and yearly payments based on entries by the user. I have attached a calculator that was done for a client of mine. It will give you a good idea of what you can do and hopefully save you some time when building yours.

Please let me know if you have any questions.

Dustin

Steve Gannon

Hi Jill,

Yes, you can develop a spreadsheet of sorts in Storyline using variables. Here's an example:

http://www.gantekmultimedia.com/sl_test/array/story.html

In that example, each cell in the table can be clicked on (or tabbed to) and edited. When the user selects various rows using the checkboxes and clicks the Update button, the sum and average of the columns is calculated. Each cell in the table is monitored by a unique variable defined for that cell.

This example isn't a payment calculator of course but the principles are the same. I believe there are a few simple payment calculator examples floating around here in the forums.

Hope that gives you some ideas!

Steve Gannon

GanTek Multimedia

Jill McNair

Thanks Seth!  That is definitely progress...but now that I see it, I need a more custom look.  I don't want to show the entire spreadsheet...I just want to show the calculation area and cut out the rest....but duh...that isn't how web objects work - they show the entire page.  

Still searching for a solution...I like Dustin's idea, but I am concerned that the programming may get too complex, and the full functionality of the spreadsheet will not be there.

Wondering if anyone knows whether this could be created say in javascript?  

Still open to ideas and thanks to all for the input!

Jill McNair
Seth Ozen

Jill,

Take a look at this; slightly involved but not too complicated.

http://www.articulatefreak.com/presenter/load-only-a-portion-of-a-website-into-a-web-object/

p.s: I assume you are aware of the characteristics of a shared GoogleDoc document; it'll get auto saved every time someone types in something.

Cheers,

Seth 

Jill McNair

Easy for you guys to say!  

I have worked with variables - but mostly true/false and single instances of numeric and text variables.  I am not sure how to create a variable that performs multiple calculations...e.g. add the values from lines 3 through 8 and divide  by the value in line 9.  Gulp!

Jill McNair

Here is an image of the spreadsheet with the formulas revealed.  Lines 30 and 34 are the ones that worry me.  How would you program these? 

Also, I want to be able to reset it...or make it so that any change in the calculations will automatically update the bottom line. I would prefer that a user would not have to restart the entire calculation if they only want to change one number.  Any ideas on this would be soooo welcome!

Cory Warshawsky

I too am looking to build a simple payment calculator, however using sliders. One slider would need to be used to select a total dollar amount - which would increase in increments of $100. Then a second slider to select the number of payments (6, 12, 24, 36, 48, 60).

Using the combination of both sliders, the total dollar amount would be divided by the number of payments, and displayed in a separate area on the slide. 

Has anyone see or tried something like this before? I would greatly appreciate the advice and direction. I do not have a strong understanding of variable (but am more than willing to try)