{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Without Circular Reference","With Circular Reference"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Without Circular Reference","index":0,"n_rows":31,"n_cols":4,"rows_kept":31}
["Year","Random 1-100","Flood that year?","Flood in 30 years?"]
[1,{"$f":"RANDBETWEEN(1,100)","v":67},{"$f":"IF(B2=32,1,0)","v":0},{"$f":"IF(SUM(C:C)=0,0,1)","v":1}]
[2,{"$f":"RANDBETWEEN(1,100)","v":39},{"$f":"IF(B3=32,1,0)","v":0}]
[3,81,0]
[4,61,0]
[5,28,0]
[6,16,0]
[7,92,0]
[8,82,0]
[9,73,0]
[10,5,0]
[11,69,0]
[12,84,0]
[13,32,1]
[14,55,0]
[15,75,0]
[16,14,0]
[17,97,0]
[18,71,0]
[19,40,0]
[20,76,0]
[21,90,0]
[22,94,0]
[23,18,0]
[24,41,0]
[25,45,0]
[26,69,0]
[27,4,0]
[28,37,0]
[29,61,0]
[30,98,0]

{"sheet":"With Circular Reference","index":1,"n_rows":31,"n_cols":6,"rows_kept":31}
["Year","Random 1-100","Flood that year?","Flood in 30 years?",null,"Relative Frequency"]
[1,{"$f":"RANDBETWEEN(1,100)","v":11},{"$f":"IF(B2=32,1,0)","v":0},{"$f":"IF(SUM(C:C)=0,0,1)","v":0},{"$f":"D2+E2","v":1},{"$f":"E2/(E3)","v":{"v":0.25,"d":"25.00%"}}]
[2,{"$f":"RANDBETWEEN(1,100)","v":2},{"$f":"IF(B3=32,1,0)","v":0},null,{"$f":"E3+1","v":5}]
[3,41,0]
[4,4,0]
[5,64,0]
[6,57,0]
[7,59,0]
[8,61,0]
[9,97,0]
[10,39,0]
[11,3,0]
[12,26,0]
[13,66,0]
[14,74,0]
[15,81,0]
[16,73,0]
[17,45,0]
[18,93,0]
[19,40,0]
[20,57,0]
[21,58,0]
[22,34,0]
[23,18,0]
[24,38,0]
[25,39,0]
[26,72,0]
[27,45,0]
[28,61,0]
[29,72,0]
[30,28,0]