View Single Post
  #10   Spotlight this post!  
Unread 28-10-2016, 18:15
Ether's Avatar
Ether Ether is offline
systems engineer (retired)
no team
 
Join Date: Nov 2009
Rookie Year: 1969
Location: US
Posts: 8,088
Ether has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond reputeEther has a reputation beyond repute
Re: Google Sheets OPR Calculator

Quote:
Originally Posted by Rachel Lim View Post
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)?

Quote:
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.

Quote:
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

Quote:
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?

Quote:
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.


Quote:
Hopefully that now addresses your point?
Not really. But if you're satisfied with what you have I won't bug you



Last edited by Ether : 28-10-2016 at 18:21.
Reply With Quote