Prevent Google App Script Memoization

Question

I have a function that I want to use to demonstrate flipping a coin 100 times:

function simulateFlips(n, pHeads){
   var head_count = 0; 
   var H; 
   for(var i=0; i < n; i++){
      H = 0; 
      if (Math.random() < pHeads){
        H = 1;
      } 
   head_count += H; 
   }
   return head_count; 
 }

However, it looks like the standard Google App Behavior is to "memoize" custom functions that are called with exactly the same inputs, which is not what you want for this kind of demo:

Screenshot from Google Spreadsheet I know I could do something hacky (like modify pHeads by a very small amount), but I was hoping there was some cleaner way to get the desired behavior.

score 2 · Accepted Answer · edited May 23 '17 at 12:15

2

Here's the explanation of this behavior: Script to summarise data not updating

Read the comments to see suggestions on how to workaround it.

edited May 23 '17 at 12:15

Community

1
1

answered Apr 13 '14 at 22:44

Henrique G. Abreu

17,406
3
56
65

score 1 · Answer 2 · answered Apr 10 '14 at 13:23

1

Pass a second param in that you ignore but which is different for each line.

answered Apr 10 '14 at 13:23

Corey G

7,754
1
28
28

Prevent Google App Script Memoization

2 Answers2