{"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":80,"n_cols":8,"rows_kept":80}
["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=16)"},null,null,"x","y"]
["Years per Cycle:",33,"years","Jitter","(days)",null,{"$f":"A14-1","v":0},{"$f":"JitterMax-Avg","v":0.484848}]
["Leaps Per Cycle:",8,"leaps",{"$f":"MAX(E:E)","v":0.484848},"maximum",{"$f":"reducefraction(JitterMax*YPC,YPC,FALSE,FALSE,FALSE)","v":"16 / 33"},256,{"$f":"H5","v":0.484848}]
["Common Year:",365,"days",{"$f":"MIN(E:E)","v":-0.484848},"minimum",{"$f":"reducefraction(JitterMin*YPC,YPC,FALSE,FALSE,FALSE)","v":"–16 / 33"}]
["Days Per Leap:",1,"days",{"$f":"D6-D7","v":0.969696},"range",{"$f":"reducefraction(JitterRange*YPC,YPC,FALSE,FALSE,TRUE)","v":"32/33"},{"$f":"G5","v":0},{"$f":"JitterMin-Avg","v":-0.484848}]
["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.484848}]
["Mean Year >365d:",{"$f":"LPC/YPC","v":0.24242424242424243},"days",{"$f":"\"Jitter range = \"&JitterRange&\" = \"&F8&\" days\"","v":"Jitter range = 0.969696 = 32/33 days"}]
[null,{"$f":"TEXT(Common,\"#\")&\"+\"&TEXT(LPC,\"#\")&\"/\"&TEXT(YPC,\"#\")&\" days = 365d 5h 49m 5+5/11s\"","v":"365+8/33 days = 365d 5h 49m 5+5/11s"},{"$nulls":3},{"$f":"LPC/YPC","v":"05:49:05.455"},"K =",16]
[]
["Year","Leap?","New Year Moment","Elapsed","Difference","Offset","Dee Leap","Same?"]
[1,{"$f":"MOD(8*A14+Kvalue,33)<8","v":false},0,0,{"$f":"ROUND(C14-D14,6)","v":0},{"$f":"E14-Avg","v":0},{"$f":"IsDeeLeapYear(A14)","v":false},{"$f":"G14=B14","v":true}]
[{"$f":"A14+1","v":2},false,{"$f":"C14+365+MeanYear","v":365.24242424242425},{"$f":"D14+365+IF(B14,1,0)","v":365},{"$f":"ROUND(C15-D15,6)","v":0.242424},0.242424,{"$f":"IsDeeLeapYear(A15)","v":false},{"$f":"G15=B15","v":true}]
[{"$f":"A15+1","v":3},true,{"$f":"C15+365+MeanYear","v":730.4848484848485},{"$f":"D15+365+IF(B15,1,0)","v":730},0.484848,0.484848,false,false]
[4,false,{"$f":"C16+365+MeanYear","v":1095.7272727272727},1096,-0.272727,-0.272727,true,false]
[5,false,1460.969696969697,1461,-0.030303,-0.030303,false,true]
[6,false,1826.2121212121212,1826,0.212121,0.212121,false,true]
[7,true,2191.454545454545,2191,0.454545,0.454545,false,false]
[8,false,2556.696969696969,2557,-0.30303,-0.30303,true,false]
[9,false,2921.939393939393,2922,-0.060606,-0.060606,false,true]
[10,false,3287.181818181817,3287,0.181818,0.181818,false,true]
[11,true,3652.424242424241,3652,0.424242,0.424242,false,false]
[12,false,4017.666666666665,4018,-0.333333,-0.333333,true,false]
[13,false,4382.909090909089,4383,-0.090909,-0.090909,false,true]
[14,false,4748.151515151513,4748,0.151515,0.151515,false,true]
[15,true,5113.393939393937,5113,0.393939,0.393939,false,false]
[16,false,5478.636363636361,5479,-0.363636,-0.363636,true,false]
[17,false,5843.878787878785,5844,-0.121212,-0.121212,false,true]
[18,false,6209.121212121209,6209,0.121212,0.121212,false,true]
[19,true,6574.363636363633,6574,0.363636,0.363636,false,false]
[20,false,6939.606060606057,6940,-0.393939,-0.393939,true,false]
[21,false,7304.848484848481,7305,-0.151515,-0.151515,false,true]
[22,false,7670.090909090905,7670,0.090909,0.090909,false,true]
[23,true,8035.333333333329,8035,0.333333,0.333333,false,false]
[24,false,8400.575757575753,8401,-0.424242,-0.424242,true,false]
[25,false,8765.818181818177,8766,-0.181818,-0.181818,false,true]
[26,false,9131.0606060606,9131,0.060606,0.060606,false,true]
[27,true,9496.303030303025,9496,0.30303,0.30303,false,false]
[{"$f":"A40+1","v":28},false,{"$f":"C40+365+MeanYear","v":9861.545454545449},{"$f":"D40+365+IF(B40,1,0)","v":9862},{"$f":"ROUND(C41-D41,6)","v":-0.454545},{"$f":"E41-Avg","v":-0.454545},true,false]
[{"$f":"A41+1","v":29},false,10226.787878787873,{"$f":"D41+365+IF(B41,1,0)","v":10227},{"$f":"ROUND(C42-D42,6)","v":-0.212121},-0.212121,false,true]
[30,false,10592.030303030297,10592,0.030303,0.030303,false,true]
[31,true,10957.27272727272,10957,0.272727,0.272727,false,false]
[32,false,11322.515151515145,11323,-0.484848,-0.484848,true,false]
[33,{"$f":"MOD(8*A46+Kvalue,33)<8","v":false},11687.757575757569,11688,-0.242424,-0.242424,false,true]
[34,false,12052.999999999993,12053,0,0,false,true]
[35,false,12418.242424242417,12418,0.242424,0.242424,false,true]
[36,true,12783.48484848484,12783,0.484848,0.484848,false,false]
[37,false,13148.727272727265,13149,-0.272727,-0.272727,true,false]
[38,false,13513.969696969689,13514,-0.030303,-0.030303,false,true]
[39,false,13879.212121212113,13879,0.212121,0.212121,false,true]
[40,true,14244.454545454537,14244,0.454545,0.454545,false,false]
[41,false,14609.69696969696,14610,-0.30303,-0.30303,true,false]
[42,false,14974.939393939385,14975,-0.060606,-0.060606,false,true]
[43,false,15340.181818181809,15340,0.181818,0.181818,false,true]
[44,true,15705.424242424233,15705,0.424242,0.424242,false,false]
[45,false,16070.666666666657,16071,-0.333333,-0.333333,true,false]
[46,false,16435.90909090908,16436,-0.090909,-0.090909,false,true]
[47,false,16801.151515151505,16801,0.151515,0.151515,false,true]
[48,true,17166.39393939393,17166,0.393939,0.393939,false,false]
[49,false,17531.636363636353,17532,-0.363636,-0.363636,true,false]
[50,false,17896.878787878777,17897,-0.121212,-0.121212,false,true]
[51,false,18262.1212121212,18262,0.121212,0.121212,false,true]
[52,true,18627.363636363625,18627,0.363636,0.363636,false,false]
[53,false,18992.60606060605,18993,-0.393939,-0.393939,true,false]
[54,false,19357.848484848473,19358,-0.151515,-0.151515,false,true]
[55,false,19723.090909090897,19723,0.090909,0.090909,false,true]
[56,true,20088.33333333332,20088,0.333333,0.333333,false,false]
[57,false,20453.575757575745,20454,-0.424242,-0.424242,true,false]
[58,false,20818.81818181817,20819,-0.181818,-0.181818,false,true]
[59,false,21184.060606060593,21184,0.060606,0.060606,false,true]
[60,true,21549.303030303017,21549,0.30303,0.30303,false,false]
[61,false,21914.54545454544,21915,-0.454545,-0.454545,true,false]
[62,false,22279.787878787865,22280,-0.212121,-0.212121,false,true]
[63,false,22645.03030303029,22645,0.030303,0.030303,false,true]
[64,true,23010.272727272713,23010,0.272727,0.272727,false,false]
[65,{"$f":"MOD(8*A78+Kvalue,33)<8","v":false},23375.515151515137,23376,-0.484848,-0.484848,true,false]
[{"$f":"A78+1","v":66},false,23740.75757575756,{"$f":"D78+365+IF(B78,1,0)","v":23741},{"$f":"ROUND(C79-D79,6)","v":-0.242424},-0.242424,{"$f":"IsDeeLeapYear(A79)","v":false},{"$f":"G79=B79","v":true}]
[{"$f":"A79+1","v":67},false,24105.999999999985,{"$f":"D79+365+IF(B79,1,0)","v":24106},{"$f":"ROUND(C80-D80,6)","v":0},0,false,true]