Google Sheets OPR Calculator

[Ether]

Originally Posted by Rachel Lim

the array must be a consistent size, so I had to keep the loop to create T so I could initialize A.

Can't you simply initialize A with a single command (no looping) to a size greater than what you expect is needed? And when you so initialize it, doesn't it set all the array elements to zero (some languages do)?

It also seems like fill() doesn't work in scripts,

I find it hard to imagine the script language provides no way to zero an array without looping through all its elements.

so I had to loop through T to set A to zero

why do you need to "loop through T" to set A? Just initialize the entire array A to zero before beginning the processing of the 8col data

otherwise when I printed out A...

I meant to ask this earlier: What does "print out" mean in this context, and why do you need to do that?

It also results in the OPRs not being sorted, which is a convenience I'd sacrifice a bit of time for.

Please read my earlier post#15 in this thread.

Hopefully that now addresses your point?

Not really. But if you're satisfied with what you have I won't bug you