Okay, I ran a very simple test file through the .csv to JSON converter you provided:

Here is the .csv:

a1,b1,c1,d1

a2,b2,c2,d2

a3,b3,c3,d3

a4,b4,c4,d4

I ran it through the converter and got this output:

[ { "a1": "a2", "b1": "b2", "c1": "c2", "d1": "d2" }, { "a1": "a3", "b1": "b3", "c1": "c3", "d1": "d3" }, { "a1": "a4", "b1": "b4", "c1": "c4", "d1": "d4" } ]

Now if I save this data in a .JSON file and use the JSON plugin to open it in Construct3, will it become a regular array with regular indices?

I'm working on a game that stores a LOT of data on all the different objects. The game is a real estate game and there will be several hundred unique houses, each has an address, value, and 5 different characteristics that all need to be stored in one large array that the game will access. Is there a way to convert a spreadsheet to C3 as a 2 dimensional array?

I'm working on a game that requires a seemingly random, but constrained and continuous wave function that controls the values of certain (think of stock market graphs).

I've created a wave function using a Factional Brownian Motion or Fractal Noise.

(See Nepeo's tutorial on FBM/Fractal Noise)

construct.net/en/tutorials/getting-started-with-the-advanced-random-plugin-30

I then plug this function into a sigmoid which restricts the range of the function to (0,1), then translate and stretch this function to fit the range (-1,1).

y = 2(1/(1+e^(-1/8)a))-1

(Where a is the output of the fractal noise function)

The result is a beautifully random looking wave function that sits neatly between -1 and 1.

This is just a really cool piece of math and the concepts can be applied in many areas of game design. The ability to create apparent randomness from sine functions that follow a coherent pattern and smoothly transitions between values is incredibly useful.

I used Desmos to create the graphs and functions, you can see the actual graphs and tweak them yourself here: desmos.com/calculator/f7zznq1zeq

Thank you that is very helpful. You said "web storage", do you mean local storage or are those one and the same?

Hello, I'm working on a real estate game where players buy, sell, and rent properties to make money. They are given a certain amount of *Energy* every day to work with and that energy regenerates over time. When the player is not playing the game, their Energy is still depleting. Does anyone know how to track the passage of time when the game is closed? Thanks!