{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Chart","Data"],"not_rendered":{"charts":1,"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Chart","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Data","index":1,"n_rows":41,"n_cols":8,"rows_kept":41}
["Leap Cycle Jitter Evaluator"]
["by Dr. Irv Bromberg, University of Toronto, Canada"]
["http://individual.utoronto.ca/intervalmath/jitter/index.html",{"$nulls":5},"Limits for Chart:"]
[{"$nulls":3},{"$f":"\"Jitter vs. Mean Year\" & IF(C9,IF(Avg<0,\" + \",\" - \")&ABS(Avg),\"\")&\" (K=\"&Kvalue&\")\"","v":"Jitter vs. Mean Year (K=0)"},null,null,"x","y"]
["Years per Cycle:",28,"years","Jitter","(days)",null,{"$f":"A14-1","v":0},{"$f":"JitterMax-Avg","v":0.75}]
["Leaps Per Cycle:",7,"leaps",{"$f":"MAX(E:E)","v":{"v":0.75,"d":"0.750000"}},"maximum",{"$f":"reducefraction(JitterMax*YPC,YPC,FALSE,FALSE,FALSE)","v":"3 / 4"},256,{"$f":"H5","v":0.75}]
["Common Year:",365,"days",{"$f":"MIN(E:E)","v":{"v":0,"d":"0.000000"}},"minimum",{"$f":"reducefraction(JitterMin*YPC,YPC,FALSE,FALSE,FALSE)","v":"0"}]
["Days Per Leap:",1,"days",{"$f":"D6-D7","v":{"v":0.75,"d":"0.750000"}},"range",{"$f":"reducefraction(JitterRange*YPC,YPC,FALSE,FALSE,TRUE)","v":"3/4"},{"$f":"G5","v":0},{"$f":"JitterMin-Avg","v":0}]
["Leap Year:",{"$f":"SUM(B7:B8)","v":366},false,{"$f":"IF(C9,AVERAGE(D6:D7),0)","v":{"v":0,"d":"0.000000"}},"average",null,{"$f":"G6","v":256},{"$f":"H8","v":0}]
["Mean Year >365d:",{"$f":"LPC/YPC","v":0.25},"days",{"$f":"\"Jitter range = \"&JitterRange&\" = \"&F8&\" days\"","v":"Jitter range = 0.75 = 3/4 days"}]
[null,{"$f":"TEXT(Common,\"#\")&\"+\"&TEXT(LPC,\"#\")&\"/\"&TEXT(YPC,\"#\")&\" days = 365d 6h\"","v":"365+7/28 days = 365d 6h"},{"$nulls":3},{"$f":"LPC/YPC","v":"06:00:00"},"K =",0]
[]
["Year","Leap?","New Year Moment","Elapsed","Difference","Offset"]
[1,{"$f":"MOD(1*A14+Kvalue,4)<1","v":false},0,0,{"$f":"ROUND(C14-D14,6)","v":0},{"$f":"E14-Avg","v":0}]
[{"$f":"A14+1","v":2},false,{"$f":"C14+365+MeanYear","v":365.25},{"$f":"D14+365+IF(B14,1,0)","v":365},{"$f":"ROUND(C15-D15,6)","v":0.25},0.25]
[{"$f":"A15+1","v":3},false,{"$f":"C15+365+MeanYear","v":730.5},{"$f":"D15+365+IF(B15,1,0)","v":730},0.5,0.5]
[4,true,{"$f":"C16+365+MeanYear","v":1095.75},1095,0.75,0.75]
[5,false,1461,1461,0,0]
[6,false,1826.25,1826,0.25,0.25]
[7,false,2191.5,2191,0.5,0.5]
[8,true,2556.75,2556,0.75,0.75]
[9,false,2922,2922,0,0]
[10,false,3287.25,3287,0.25,0.25]
[11,false,3652.5,3652,0.5,0.5]
[12,true,4017.75,4017,0.75,0.75]
[13,false,4383,4383,0,0]
[14,false,4748.25,4748,0.25,0.25]
[15,false,5113.5,5113,0.5,0.5]
[16,true,5478.75,5478,0.75,0.75]
[17,false,5844,5844,0,0]
[18,false,6209.25,6209,0.25,0.25]
[19,false,6574.5,6574,0.5,0.5]
[20,true,6939.75,6939,0.75,0.75]
[21,false,7305,7305,0,0]
[22,false,7670.25,7670,0.25,0.25]
[23,false,8035.5,8035,0.5,0.5]
[24,true,8400.75,8400,0.75,0.75]
[25,false,8766,8766,0,0]
[26,false,9131.25,9131,0.25,0.25]
[27,false,9496.5,9496,0.5,0.5]
[28,true,9861.75,9861,0.75,0.75]