Forum Discussion

RobAnderson1's avatar
RobAnderson1
Community Member
24 days ago

Storing Variables in Excel or XML

Trying to solution variable storage and retrieval for a scenario-based decision course. Here are the elements. It's a single course output in a web format (no LMS)

  • It is designed to accommodate 6 teams
  • Each team opens the same course from the same location
  • Each team chooses their "team" and adds a team name
  • They each go through the same scenarios with the same choices
  • Each choice has 3 scored elements and each element has pre-assigned values
  • The scoring can go up or down based on the choice. 
  • There is a leaderboard for the facilitator to display and track scoring across all 6 teams. 

Here's what we're solving for... with 6 teams each on their own computer, variable data is being stored in cookies on each computer. We want it to push to a table that can store the variable data across all the 5 scenarios (6 teams, 5 scenarios each) and display on the facilitator's leaderboard.

We are using a paid widget that uses a Google sheet to store the data and Javascript to push/pull at each design point, using a trigger... then the facilitator uses their refresh trigger to update their view. My question is... Can't you just use an Excel sheet or XML file created within the file structure to do the same thing? AND... has anyone done this? Lastly... How?