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

Sep 17, 2013

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.


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.


Steve Gannon

Hi Jill,

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

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
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)

This discussion is closed. You can start a new discussion or contact Articulate Support.