{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sales Seasonality by Month"],"not_rendered":{"charts":1,"defined_names":32,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sales Seasonality by Month","index":0,"n_rows":114,"n_cols":19,"rows_kept":114,"merged":[[39,1,39,6]]}
[]
[]
[null,"Sales Seasonality by Month"]
[null,"For the Year 2009"]
[]
[]
[null,null,"Actual","% of ","Company Index","Industry % ","Industry Index"]
[null,null,"Sales","Sales","To Average","of Sales","to Average"]
[null,"Jan",{"v":100000,"d":"$100,000"},{"$f":"IF(C9,C9/C21,\"\")","v":{"v":0.07754167769228514,"d":"7.75%"}},{"$f":"IF(C9,C9/AVERAGE(C9:C20),\"\")","v":{"v":0.9305001323074218,"d":"93.1%"}},{"v":0.07,"d":"7.0%"},{"$f":"IF(F9,F9/AVERAGE(F9:F20),\"\")","v":{"v":0.8400000000000001,"d":"84.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,I114)","v":"Feb"},{"v":101300,"d":"101,300 "},{"$f":"IF(C10,C10/C21,\"\")","v":{"v":0.07854971950228484,"d":"7.85%"}},{"$f":"IF(C10,C10/AVERAGE(C9:C20),\"\")","v":{"v":0.9425966340274182,"d":"94.3%"}},{"v":0.075,"d":"7.5%"},{"$f":"IF(F10,F10/AVERAGE(F9:F20),\"\")","v":{"v":0.9,"d":"90.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,J114)","v":"Mar"},{"v":102616.9,"d":"102,617 "},{"$f":"IF(C11,C11/C21,\"\")","v":{"v":0.07957086585581455,"d":"7.96%"}},{"$f":"IF(C11,C11/AVERAGE(C9:C20),\"\")","v":{"v":0.9548503902697746,"d":"95.5%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F11,F11/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,K114)","v":"Apr"},{"v":103950.9197,"d":"103,951 "},{"$f":"IF(C12,C12/C21,\"\")","v":{"v":0.08060528711194014,"d":"8.06%"}},{"$f":"IF(C12,C12/AVERAGE(C9:C20),\"\")","v":{"v":0.9672634453432817,"d":"96.7%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F12,F12/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,L114)","v":"May"},{"v":105302.2816561,"d":"105,302 "},{"$f":"IF(C13,C13/C21,\"\")","v":{"v":0.08165315584439536,"d":"8.17%"}},{"$f":"IF(C13,C13/AVERAGE(C9:C20),\"\")","v":{"v":0.9798378701327445,"d":"98.0%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F13,F13/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,M114)","v":"Jun"},{"v":106671.211317629,"d":"106,671 "},{"$f":"IF(C14,C14/C21,\"\")","v":{"v":0.08271464687037226,"d":"8.27%"}},{"$f":"IF(C14,C14/AVERAGE(C9:C20),\"\")","v":{"v":0.9925757624444673,"d":"99.3%"}},{"v":0.08,"d":"8.0%"},{"$f":"IF(F14,F14/AVERAGE(F9:F20),\"\")","v":{"v":0.9600000000000001,"d":"96.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,N114)","v":"Jul"},{"v":108057.937064758,"d":"108,058 "},{"$f":"IF(C15,C15/C21,\"\")","v":{"v":0.08378993727968698,"d":"8.38%"}},{"$f":"IF(C15,C15/AVERAGE(C9:C20),\"\")","v":{"v":1.0054792473562437,"d":"100.5%"}},{"v":0.07,"d":"7.0%"},{"$f":"IF(F15,F15/AVERAGE(F9:F20),\"\")","v":{"v":0.8400000000000001,"d":"84.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,O114)","v":"Aug"},{"v":109462.6902466,"d":"109,463 "},{"$f":"IF(C16,C16/C21,\"\")","v":{"v":0.08487920646432302,"d":"8.49%"}},{"$f":"IF(C16,C16/AVERAGE(C9:C20),\"\")","v":{"v":1.0185504775718763,"d":"101.9%"}},{"v":0.095,"d":"9.5%"},{"$f":"IF(F16,F16/AVERAGE(F9:F20),\"\")","v":{"v":1.1400000000000001,"d":"114.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,P114)","v":"Sep"},{"v":110885.705219806,"d":"110,886 "},{"$f":"IF(C17,C17/C21,\"\")","v":{"v":0.08598263614835937,"d":"8.60%"}},{"$f":"IF(C17,C17/AVERAGE(C9:C20),\"\")","v":{"v":1.0317916337803124,"d":"103.2%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F17,F17/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,Q114)","v":"Oct"},{"v":112327.219387664,"d":"112,327 "},{"$f":"IF(C18,C18/C21,\"\")","v":{"v":0.08710041041828843,"d":"8.71%"}},{"$f":"IF(C18,C18/AVERAGE(C9:C20),\"\")","v":{"v":1.0452049250194613,"d":"104.5%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F18,F18/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,R114)","v":"Nov"},{"v":113787.473239703,"d":"113,787 "},{"$f":"IF(C19,C19/C21,\"\")","v":{"v":0.08823271575372571,"d":"8.82%"}},{"$f":"IF(C19,C19/AVERAGE(C9:C20),\"\")","v":{"v":1.0587925890447085,"d":"105.9%"}},{"v":0.07,"d":"7.0%"},{"$f":"IF(F19,F19/AVERAGE(F9:F20),\"\")","v":{"v":0.8400000000000001,"d":"84.0%"}}]
[null,{"$f":"INDEX(H113:S114,1,S114)","v":"Dec"},{"v":115266.710391819,"d":"115,267 "},{"$f":"IF(C20,C20/C21,\"\")","v":{"v":0.08937974105852403,"d":"8.94%"}},{"$f":"IF(C20,C20/AVERAGE(C9:C20),\"\")","v":{"v":1.0725568927022884,"d":"107.3%"}},{"v":0.09,"d":"9.0%"},{"$f":"IF(F20,F20/AVERAGE(F9:F20),\"\")","v":{"v":1.08,"d":"108.0%"}}]
[null,"Total",{"$f":"IF(SUM(C9:C20),SUM(C9:C20),\"\")","v":{"v":1289629.0482240792,"d":"$1,289,629"}},{"$f":"IF(ISNUMBER(C21),C21/C21,\"\")","v":{"v":1,"d":"100.00%"}},null,{"$f":"IF(SUM(F9:F20),SUM(F9:F20),\"\")","v":{"v":0.9999999999999999,"d":"100.0%"}}]
{"$rows_empty":91}
[{"$nulls":7},"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[{"$nulls":7},{"$f":"IF(ISTEXT(B9),MATCH(PROPER(LEFT(B9,3)),H113:S113,0),1)","v":1},{"$f":"IF(H114=12,1,H114+1)","v":2},3,4,5,6,7,8,9,10,11,12]