Coordinate Input

[jbrosen18]

I’m writing an ecosystem computer model where each cell on a grid needs to have specified values. Is there a way that, given the x and y size of the grid, I can automatically generate a column of all of the coordinates that I can then assign value to in the corresponding rows.

Ex: For a 50x50 grid, once given the size, the spreadsheet would automatically create either one column with 2500 entries like
(0,0)
(0,1)
(0,2)…

Or it would create two column, each with 2500 like
0 0
0 1
0 2…

Any ideas?

[w_whalley]

Sometimes LO isn’t the best solution. You might use a bash script to generate a csv file that LO could read. E.g. for i in $(seq 0 49); do for j in $(seq 0 49); do echo $i, $j; done; done > output.csv

[qubit1]

@w_whalley, Could you please turn your comment into an answer so we can resolve this question? Thanks!

[w_whalley]

Sometimes LO isn’t the best solution. You might use a bash script to generate a csv file that LO could read. E.g.

for i in $(seq 0 49); do for j in $(seq 0 49); do echo $i, $j; done; done > output.csv