Forum Discussion
Help w/ interactive graphs data representation
Ok, might be attempting to break new ground here, however..here goes...
Remember those fully integrated xcel spreadsheets full of macros, functions and pivot tables? Anyone ever thought of putting that into an interactive eLearning?
Looking to have user input data and depending on the data input, we can calculate overall project ROI. Im diving in, looking at the usage of sliders, variables and triggers, however, conversations and research have netted me limited information.
This is the closest I have found to representing what I'm looking for, however, actual design behind the scenes programming is somewhat lacking..
CALL TO ACTION!! HELP!!
1 Reply
Several approaches i can imagine.
- embed a Google Sheet in Storyline.
- use Javascript libraries to emulate or use Google Sheets or Excel
As seen in this example where i made a Feature Request Sheet that works perfectly.https://360.articulate.com/review/content/5a4ac47f-cd5a-45d5-aa97-85bfd22024b8/review
Some of the libraries you could use for that are:JExcel
https://www.jqueryscript.net/table/jQuery-Plugin-For-Dynamic-Spreadsheet-like-Data-Grid-jExcel.html#vanilla
JSpreadsheet
https://bossanova.uk/jspreadsheet/v3/Tabulator
http://tabulator.info/
I used Tabulator to display data i read, write and update from Google Sheet in the above sample.
So with the above approach i can create a fully working Google Sheet in Storyline.
Im quite sure there are more possibilities, but these i know and use.Kind regards,
Math
