{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Yearly Planner"],"not_rendered":{"external_links":2,"defined_names":34,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Yearly Planner","index":0,"n_rows":71,"n_cols":26,"rows_kept":71,"merged":[[52,1,52,23]]}
[]
[]
[null,{"$f":"FIXED(E70+(1600+300),0,TRUE)&\" Planning Calendar\"","v":"2010 Planning Calendar"}]
[null,"Your Company Name",{"$nulls":23},"Enter Year"]
[{"$nulls":25},2010]
[{"$nulls":4},"JANUARY",{"$nulls":7},"FEBRUARY",{"$nulls":7},"MARCH"]
[null,"S","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S"]
[null,{"$f":"IF(I58=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(B8),B8+1,IF($I$58=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(C8),C8+1,IF($I$58=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(D8),D8+1,IF($I$58=$F$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(E8),E8+1,IF($I$58=$G$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(F8),F8+1,IF($I$58=$H$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(G8),G8+1,IF($I$58=$I$71,1,\"\"))","v":2},null,{"$f":"IF(I59=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(J8),J8+1,IF($I$59=$D$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(K8),K8+1,IF($I$59=$E$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(L8),L8+1,IF($I$59=$F$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(M8),M8+1,IF($I$59=$G$71,1,\"\"))","v":4},{"$f":"IF(ISNUMBER(N8),N8+1,IF($I$59=$H$71,1,\"\"))","v":5},{"$f":"IF(ISNUMBER(O8),O8+1,IF($I$59=$I$71,1,\"\"))","v":6},null,{"$f":"IF(I60=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(R8),R8+1,IF($I$60=$D$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(S8),S8+1,IF($I$60=$E$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(T8),T8+1,IF($I$60=$F$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(U8),U8+1,IF($I$60=$G$71,1,\"\"))","v":4},{"$f":"IF(ISNUMBER(V8),V8+1,IF($I$60=$H$71,1,\"\"))","v":5},{"$f":"IF(ISNUMBER(W8),W8+1,IF($I$60=$I$71,1,\"\"))","v":6}]
[null,{"$f":"1+H8","v":3},{"$f":"1+B9","v":4},5,6,7,8,{"$f":"G9+1","v":9},null,{"$f":"1+P8","v":7},{"$f":"1+J9","v":8},9,10,11,12,{"$f":"O9+1","v":13},null,{"$f":"1+X8","v":7},{"$f":"1+R9","v":8},9,10,11,12,{"$f":"W9+1","v":13}]
[null,{"$f":"1+H9","v":10},11,12,13,14,15,{"$f":"G10+1","v":16},null,{"$f":"1+P9","v":14},15,16,17,18,19,{"$f":"O10+1","v":20},null,{"$f":"1+X9","v":14},15,16,17,18,19,{"$f":"W10+1","v":20}]
[null,{"$f":"1+H10","v":17},18,19,20,21,22,{"$f":"1+G11","v":23},null,{"$f":"1+P10","v":21},22,23,24,25,26,{"$f":"1+O11","v":27},null,{"$f":"1+X10","v":21},22,23,24,25,26,{"$f":"1+W11","v":27}]
[null,{"$f":"IF(H11=$C$58,\"\",H11+1)","v":24},{"$f":"IF(ISTEXT(B12),\"\",IF(B12=$C$58,\"\",B12+1))","v":25},26,27,28,29,30,null,{"$f":"IF(P11=$C$59,\"\",P11+1)","v":28},{"$f":"IF(ISTEXT(J12),\"\",IF(J12=$C$59,\"\",J12+1))","v":""},"","","","","",null,{"$f":"IF(X11=$C$60,\"\",X11+1)","v":28},{"$f":"IF(ISTEXT(R12),\"\",IF(R12=$C$60,\"\",R12+1))","v":29},30,31,"","",""]
[null,{"$f":"IF(ISTEXT(H12),\"\",IF(H12=$C$58,\"\",H12+1))","v":31},{"$f":"IF(ISTEXT(B13),\"\",IF(B13=$C$58,\"\",B13+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(P12),\"\",IF(P12=$C$59,\"\",P12+1))","v":""},{"$f":"IF(ISTEXT(J13),\"\",IF(J13=$C$59,\"\",J13+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(X12),\"\",IF(X12=$C$60,\"\",X12+1))","v":""},{"$f":"IF(ISTEXT(R13),\"\",IF(R13=$C$60,\"\",R13+1))","v":""}]
[]
[{"$nulls":4},"APRIL",{"$nulls":7},"MAY",{"$nulls":7},"JUNE"]
[null,"S","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S"]
[null,{"$f":"IF(I61=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(B17),B17+1,IF($I$61=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(C17),C17+1,IF($I$61=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(D17),D17+1,IF($I$61=$F$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(E17),E17+1,IF($I$61=$G$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(F17),F17+1,IF($I$61=$H$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(G17),G17+1,IF($I$61=$I$71,1,\"\"))","v":3},null,{"$f":"IF(I62=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(J17),J17+1,IF($I$62=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(K17),K17+1,IF($I$62=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(L17),L17+1,IF($I$62=$F$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(M17),M17+1,IF($I$62=$G$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(N17),N17+1,IF($I$62=$H$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(O17),O17+1,IF($I$62=$I$71,1,\"\"))","v":1},null,{"$f":"IF(I63=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(R17),R17+1,IF($I$63=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(S17),S17+1,IF($I$63=$E$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(T17),T17+1,IF($I$63=$F$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(U17),U17+1,IF($I$63=$G$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(V17),V17+1,IF($I$63=$H$71,1,\"\"))","v":4},{"$f":"IF(ISNUMBER(W17),W17+1,IF($I$63=$I$71,1,\"\"))","v":5}]
[null,{"$f":"1+H17","v":4},{"$f":"1+B18","v":5},6,7,8,9,{"$f":"G18+1","v":10},null,{"$f":"1+P17","v":2},{"$f":"1+J18","v":3},4,5,6,7,{"$f":"O18+1","v":8},null,{"$f":"1+X17","v":6},{"$f":"1+R18","v":7},8,9,10,11,{"$f":"W18+1","v":12}]
[null,{"$f":"1+H18","v":11},12,13,14,15,16,{"$f":"G19+1","v":17},null,{"$f":"1+P18","v":9},10,11,12,13,14,{"$f":"O19+1","v":15},null,{"$f":"1+X18","v":13},14,15,16,17,18,{"$f":"W19+1","v":19}]
[null,{"$f":"1+H19","v":18},19,20,21,22,23,{"$f":"1+G20","v":24},null,{"$f":"1+P19","v":16},17,18,19,20,21,{"$f":"1+O20","v":22},null,{"$f":"1+X19","v":20},21,22,23,24,25,{"$f":"1+W20","v":26}]
[null,{"$f":"IF(H20=$C$61,\"\",H20+1)","v":25},{"$f":"IF(ISTEXT(B21),\"\",IF(B21=$C$61,\"\",B21+1))","v":26},27,28,29,30,"",null,{"$f":"IF(P20=$C$62,\"\",P20+1)","v":23},{"$f":"IF(ISTEXT(J21),\"\",IF(J21=$C$62,\"\",J21+1))","v":24},25,26,27,28,29,null,{"$f":"IF(X20=$C$63,\"\",X20+1)","v":27},{"$f":"IF(ISTEXT(R21),\"\",IF(R21=$C$63,\"\",R21+1))","v":28},29,30,"","",""]
[null,{"$f":"IF(ISTEXT(H21),\"\",IF(H21=$C$61,\"\",H21+1))","v":""},{"$f":"IF(ISTEXT(B22),\"\",IF(B22=$C$61,\"\",B22+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(P21),\"\",IF(P21=$C$62,\"\",P21+1))","v":30},{"$f":"IF(ISTEXT(J22),\"\",IF(J22=$C$62,\"\",J22+1))","v":31},{"$nulls":6},{"$f":"IF(ISTEXT(X21),\"\",IF(X21=$C$63,\"\",X21+1))","v":""},{"$f":"IF(ISTEXT(R22),\"\",IF(R22=$C$63,\"\",R22+1))","v":""}]
[]
[{"$nulls":4},"JULY",{"$nulls":7},"AUGUST",{"$nulls":7},"SEPTEMBER"]
[null,"S","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S"]
[null,{"$f":"IF(I64=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(B26),B26+1,IF($I$64=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(C26),C26+1,IF($I$64=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(D26),D26+1,IF($I$64=$F$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(E26),E26+1,IF($I$64=$G$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(F26),F26+1,IF($I$64=$H$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(G26),G26+1,IF($I$64=$I$71,1,\"\"))","v":3},null,{"$f":"IF(I65=C71,1,\"\")","v":1},{"$f":"IF(ISNUMBER(J26),J26+1,IF($I$65=$D$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(K26),K26+1,IF($I$65=$E$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(L26),L26+1,IF($I$65=$F$71,1,\"\"))","v":4},{"$f":"IF(ISNUMBER(M26),M26+1,IF($I$65=$G$71,1,\"\"))","v":5},{"$f":"IF(ISNUMBER(N26),N26+1,IF($I$65=$H$71,1,\"\"))","v":6},{"$f":"IF(ISNUMBER(O26),O26+1,IF($I$65=$I$71,1,\"\"))","v":7},null,{"$f":"IF(I66=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(R26),R26+1,IF($I$66=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(S26),S26+1,IF($I$66=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(T26),T26+1,IF($I$66=$F$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(U26),U26+1,IF($I$66=$G$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(V26),V26+1,IF($I$66=$H$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(W26),W26+1,IF($I$66=$I$71,1,\"\"))","v":4}]
[null,{"$f":"1+H26","v":4},{"$f":"1+B27","v":5},6,7,8,9,{"$f":"G27+1","v":10},null,{"$f":"1+P26","v":8},{"$f":"1+J27","v":9},10,11,12,13,{"$f":"O27+1","v":14},null,{"$f":"1+X26","v":5},{"$f":"1+R27","v":6},7,8,9,10,{"$f":"W27+1","v":11}]
[null,{"$f":"1+H27","v":11},12,13,14,15,16,{"$f":"G28+1","v":17},null,{"$f":"1+P27","v":15},16,17,18,19,20,{"$f":"O28+1","v":21},null,{"$f":"1+X27","v":12},13,14,15,16,17,{"$f":"W28+1","v":18}]
[null,{"$f":"1+H28","v":18},19,20,21,22,23,{"$f":"1+G29","v":24},null,{"$f":"1+P28","v":22},23,24,25,26,27,{"$f":"1+O29","v":28},null,{"$f":"1+X28","v":19},20,21,22,23,24,{"$f":"1+W29","v":25}]
[null,{"$f":"IF(H29=$C$64,\"\",H29+1)","v":25},{"$f":"IF(ISTEXT(B30),\"\",IF(B30=$C$64,\"\",B30+1))","v":26},27,28,29,30,31,null,{"$f":"IF(P29=$C$65,\"\",P29+1)","v":29},{"$f":"IF(ISTEXT(J30),\"\",IF(J30=$C$65,\"\",J30+1))","v":30},31,"","","","",null,{"$f":"IF(X29=$C$66,\"\",X29+1)","v":26},{"$f":"IF(ISTEXT(R30),\"\",IF(R30=$C$66,\"\",R30+1))","v":27},28,29,30,"",""]
[null,{"$f":"IF(ISTEXT(H30),\"\",IF(H30=$C$64,\"\",H30+1))","v":""},{"$f":"IF(ISTEXT(B31),\"\",IF(B31=$C$64,\"\",B31+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(P30),\"\",IF(P30=$C$65,\"\",P30+1))","v":""},{"$f":"IF(ISTEXT(J31),\"\",IF(J31=$C$65,\"\",J31+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(X30),\"\",IF(X30=$C$66,\"\",X30+1))","v":""},{"$f":"IF(ISTEXT(R31),\"\",IF(R31=$C$66,\"\",R31+1))","v":""}]
[]
[{"$nulls":4},"OCTOBER",{"$nulls":7},"NOVEMBER",{"$nulls":7},"DECEMBER"]
[null,"S","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S",null,"S ","M","T","W","T","F","S"]
[null,{"$f":"IF(I67=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(B35),B35+1,IF($I$67=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(C35),C35+1,IF($I$67=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(D35),D35+1,IF($I$67=$F$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(E35),E35+1,IF($I$67=$G$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(F35),F35+1,IF($I$67=$H$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(G35),G35+1,IF($I$67=$I$71,1,\"\"))","v":2},null,{"$f":"IF(I68=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(J35),J35+1,IF($I$68=$D$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(K35),K35+1,IF($I$68=$E$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(L35),L35+1,IF($I$68=$F$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(M35),M35+1,IF($I$68=$G$71,1,\"\"))","v":4},{"$f":"IF(ISNUMBER(N35),N35+1,IF($I$68=$H$71,1,\"\"))","v":5},{"$f":"IF(ISNUMBER(O35),O35+1,IF($I$68=$I$71,1,\"\"))","v":6},null,{"$f":"IF(I69=C71,1,\"\")","v":""},{"$f":"IF(ISNUMBER(R35),R35+1,IF($I$69=$D$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(S35),S35+1,IF($I$69=$E$71,1,\"\"))","v":""},{"$f":"IF(ISNUMBER(T35),T35+1,IF($I$69=$F$71,1,\"\"))","v":1},{"$f":"IF(ISNUMBER(U35),U35+1,IF($I$69=$G$71,1,\"\"))","v":2},{"$f":"IF(ISNUMBER(V35),V35+1,IF($I$69=$H$71,1,\"\"))","v":3},{"$f":"IF(ISNUMBER(W35),W35+1,IF($I$69=$I$71,1,\"\"))","v":4}]
[null,{"$f":"1+H35","v":3},{"$f":"1+B36","v":4},5,6,7,8,{"$f":"G36+1","v":9},null,{"$f":"1+P35","v":7},{"$f":"1+J36","v":8},9,10,11,12,{"$f":"O36+1","v":13},null,{"$f":"1+X35","v":5},{"$f":"1+R36","v":6},7,8,9,10,{"$f":"W36+1","v":11}]
[null,{"$f":"1+H36","v":10},11,12,13,14,15,{"$f":"G37+1","v":16},null,{"$f":"1+P36","v":14},15,16,17,18,19,{"$f":"O37+1","v":20},null,{"$f":"1+X36","v":12},13,14,15,16,17,{"$f":"W37+1","v":18}]
[null,{"$f":"1+H37","v":17},18,19,20,21,22,{"$f":"1+G38","v":23},null,{"$f":"1+P37","v":21},22,23,24,25,26,{"$f":"1+O38","v":27},null,{"$f":"1+X37","v":19},20,21,22,23,24,{"$f":"1+W38","v":25}]
[null,{"$f":"IF(H38=$C$67,\"\",H38+1)","v":24},{"$f":"IF(ISTEXT(B39),\"\",IF(B39=$C$67,\"\",B39+1))","v":25},26,27,28,29,30,null,{"$f":"IF(P38=$C$68,\"\",P38+1)","v":28},{"$f":"IF(ISTEXT(J39),\"\",IF(J39=$C$68,\"\",J39+1))","v":29},30,"","","","",null,{"$f":"IF(X38=$C$69,\"\",X38+1)","v":26},{"$f":"IF(ISTEXT(R39),\"\",IF(R39=$C$69,\"\",R39+1))","v":27},28,29,30,31,""]
[null,{"$f":"IF(ISTEXT(H39),\"\",IF(H39=$C$67,\"\",H39+1))","v":31},{"$f":"IF(ISTEXT(B40),\"\",IF(B40=$C$67,\"\",B40+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(P39),\"\",IF(P39=$C$68,\"\",P39+1))","v":""},{"$f":"IF(ISTEXT(J40),\"\",IF(J40=$C$68,\"\",J40+1))","v":""},{"$nulls":6},{"$f":"IF(ISTEXT(X39),\"\",IF(X39=$C$69,\"\",X39+1))","v":""},{"$f":"IF(ISTEXT(R40),\"\",IF(R40=$C$69,\"\",R40+1))","v":""}]
[]
[null,"Notes"]
{"$rows_empty":13}
[null,"CALENDAR TABLES AND FORMULAS"]
[null,"DO NOT ERASE OR DELETE COLUMNS OR ROWS"]
[null,1,31,null,"JANUARY",null,1,{"$f":"DATE(E70,B58,1)","v":"2010-01-01"},{"$f":"MOD(H58,7)","v":6}]
[null,2,{"$f":"IF(MOD(E70,4)=0,29,28)","v":28},null,"FEBRUARY",null,2,{"$f":"H58+C58","v":"2010-02-01"},2]
[null,3,31,null,"MARCH",null,3,"2010-03-01",2]
[null,4,30,null,"APRIL",null,4,"2010-04-01",5]
[null,5,31,null,"MAY",null,5,"2010-05-01",0]
[null,6,30,null,"JUNE",null,6,"2010-06-01",3]
[null,7,31,null,"JULY",null,7,"2010-07-01",5]
[null,8,31,null,"AUGUST",null,8,"2010-08-01",1]
[null,9,30,null,"SEPTEMBER",null,9,"2010-09-01",4]
[null,10,31,null,"OCTOBER",null,10,"2010-10-01",6]
[null,11,30,null,"NOVEMBER",null,11,"2010-11-01",2]
[null,12,31,null,"DECEMBER",null,12,"2010-12-01",4]
[null,null,"YEAR CALC",null,{"$f":"IF('Yearly Planner'!Z5>1899,'Yearly Planner'!Z5-(1600+300),'Yearly Planner'!Z5)","v":110}]
[null,null,1,2,3,4,5,6,0]