{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sales Trend Analysis"],"not_rendered":{"external_links":1,"defined_names":32,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sales Trend Analysis","index":0,"n_rows":47,"n_cols":12,"rows_kept":47,"merged":[[48,1,48,11]]}
[]
[]
[null,"Sales Trend Analysis"]
[null,"For the Year 2009"]
[]
[null,null,"Q1",null,{"$f":"LEFT(C6,LEN(C6)-1)&FIXED(CHOOSE(VALUE(RIGHT(C6,1)),2,3,4,1),0,TRUE)","v":"Q2"},null,{"$f":"LEFT(E6,LEN(E6)-1)&FIXED(CHOOSE(VALUE(RIGHT(E6,1)),2,3,4,1),0,TRUE)","v":"Q3"},null,{"$f":"LEFT(G6,LEN(G6)-1)&FIXED(CHOOSE(VALUE(RIGHT(G6,1)),2,3,4,1),0,TRUE)","v":"Q4"},null,"Totals"]
[null,"Product 1"]
[null,"Last Year's Sales",{"v":10000,"d":"$10,000"},null,{"v":12000,"d":"$12,000"},null,{"v":10000,"d":"$10,000"},null,{"v":12000,"d":"$12,000"},null,{"$f":"IF(SUM(C8:J8),SUM(C8:J8),\"\")","v":{"v":44000,"d":"$44,000"}}]
[null,"This Year's Sales Goal",{"v":12000,"d":"$12,000"},null,{"v":15000,"d":"$15,000"},null,{"v":12000,"d":"$12,000"},null,{"v":16000,"d":"$16,000"},null,{"$f":"IF(SUM(C9:J9),SUM(C9:J9),\"\")","v":{"v":55000,"d":"$55,000"}}]
[null,"This Year's Actual Sales",{"v":11000,"d":"$11,000"},null,{"v":17000,"d":"$17,000"},null,{"v":11000,"d":"$11,000"},null,{"v":18000,"d":"$18,000"},null,{"$f":"IF(SUM(C10:J10),SUM(C10:J10),\"\")","v":{"v":57000,"d":"$57,000"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C8:C10),C10-C9,\"\")","v":{"v":-1000,"d":"($1,000)"}},{"$f":"IF(SUM(C8:C10),IF(C11<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(E8:E10),E10-E9,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(E8:E10),IF(E11<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(G8:G10),G10-G9,\"\")","v":{"v":-1000,"d":"($1,000)"}},{"$f":"IF(SUM(G8:G10),IF(G11<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(I8:I10),I10-I9,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(I8:I10),IF(I11<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(K8:K10),K10-K9,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(K8:K10),IF(K11<0,\"U\",\"F\"),\"\")","v":"F"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C8:C10),(C10-C8)/C8,\"\")","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"IF(SUM(E8:E10),(E10-E8)/E8,\"\")","v":{"v":0.4166666666666667,"d":"41.7%"}},null,{"$f":"IF(SUM(G8:G10),(G10-G8)/G8,\"\")","v":{"v":0.1,"d":"10.0%"}},null,{"$f":"IF(SUM(I8:I10),(I10-I8)/I8,\"\")","v":{"v":0.5,"d":"50.0%"}},null,{"$f":"IF(SUM(K8:K10),(K10-K8)/K8,\"\")","v":{"v":0.29545454545454547,"d":"29.5%"}}]
[]
[null,"Product 2"]
[null,"Last Year's Sales",{"v":9600,"d":"$9,600"},null,{"v":10000,"d":"$10,000"},null,{"v":10000,"d":"$10,000"},null,{"v":9700,"d":"$9,700"},null,{"$f":"IF(SUM(C15:J15),SUM(C15:J15),\"\")","v":{"v":39300,"d":"$39,300"}}]
[null,"This Year's Sales Goal",{"v":15000,"d":"$15,000"},null,{"v":15000,"d":"$15,000"},null,{"v":15000,"d":"$15,000"},null,{"v":15000,"d":"$15,000"},null,{"$f":"IF(SUM(C16:J16),SUM(C16:J16),\"\")","v":{"v":60000,"d":"$60,000"}}]
[null,"This Year's Actual Sales",{"v":11000,"d":"$11,000"},null,{"v":17000,"d":"$17,000"},null,{"v":18000,"d":"$18,000"},null,{"v":11000,"d":"$11,000"},null,{"$f":"IF(SUM(C17:J17),SUM(C17:J17),\"\")","v":{"v":57000,"d":"$57,000"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C15:C17),C17-C16,\"\")","v":{"v":-4000,"d":"($4,000)"}},{"$f":"IF(SUM(C15:C17),IF(C18<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(E15:E17),E17-E16,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(E15:E17),IF(E18<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(G15:G17),G17-G16,\"\")","v":{"v":3000,"d":"$3,000"}},{"$f":"IF(SUM(G15:G17),IF(G18<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(I15:I17),I17-I16,\"\")","v":{"v":-4000,"d":"($4,000)"}},{"$f":"IF(SUM(I15:I17),IF(I18<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(K15:K17),K17-K16,\"\")","v":{"v":-3000,"d":"($3,000)"}},{"$f":"IF(SUM(K15:K17),IF(K18<0,\"U\",\"F\"),\"\")","v":"U"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C15:C17),(C17-C15)/C15,\"\")","v":{"v":0.14583333333333334,"d":"14.6%"}},null,{"$f":"IF(SUM(E15:E17),(E17-E15)/E15,\"\")","v":{"v":0.7,"d":"70.0%"}},null,{"$f":"IF(SUM(G15:G17),(G17-G15)/G15,\"\")","v":{"v":0.8,"d":"80.0%"}},null,{"$f":"IF(SUM(I15:I17),(I17-I15)/I15,\"\")","v":{"v":0.13402061855670103,"d":"13.4%"}},null,{"$f":"IF(SUM(K15:K17),(K17-K15)/K15,\"\")","v":{"v":0.45038167938931295,"d":"45.0%"}}]
[]
[null,"Product 3"]
[null,"Last Year's Sales",{"v":31000,"d":"$31,000"},null,{"v":30000,"d":"$30,000"},null,{"v":31000,"d":"$31,000"},null,{"v":35000,"d":"$35,000"},null,{"$f":"IF(SUM(C22:J22),SUM(C22:J22),\"\")","v":{"v":127000,"d":"$127,000"}}]
[null,"This Year's Sales Goal",{"v":35000,"d":"$35,000"},null,{"v":35000,"d":"$35,000"},null,{"v":35000,"d":"$35,000"},null,{"v":35000,"d":"$35,000"},null,{"$f":"IF(SUM(C23:J23),SUM(C23:J23),\"\")","v":{"v":140000,"d":"$140,000"}}]
[null,"This Year's Actual Sales",{"v":41000,"d":"$41,000"},null,{"v":39000,"d":"$39,000"},null,{"v":28000,"d":"$28,000"},null,{"v":32000,"d":"$32,000"},null,{"$f":"IF(SUM(C24:J24),SUM(C24:J24),\"\")","v":{"v":140000,"d":"$140,000"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C22:C24),C24-C23,\"\")","v":{"v":6000,"d":"$6,000"}},{"$f":"IF(SUM(C22:C24),IF(C25<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(E22:E24),E24-E23,\"\")","v":{"v":4000,"d":"$4,000"}},{"$f":"IF(SUM(E22:E24),IF(E25<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(G22:G24),G24-G23,\"\")","v":{"v":-7000,"d":"($7,000)"}},{"$f":"IF(SUM(G22:G24),IF(G25<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(I22:I24),I24-I23,\"\")","v":{"v":-3000,"d":"($3,000)"}},{"$f":"IF(SUM(I22:I24),IF(I25<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(K22:K24),K24-K23,\"\")","v":{"v":0,"d":"$0"}},{"$f":"IF(SUM(K22:K24),IF(K25<0,\"U\",\"F\"),\"\")","v":"F"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C22:C24),(C24-C22)/C22,\"\")","v":{"v":0.3225806451612903,"d":"32.3%"}},null,{"$f":"IF(SUM(E22:E24),(E24-E22)/E22,\"\")","v":{"v":0.3,"d":"30.0%"}},null,{"$f":"IF(SUM(G22:G24),(G24-G22)/G22,\"\")","v":{"v":-0.0967741935483871,"d":"-9.7%"}},null,{"$f":"IF(SUM(I22:I24),(I24-I22)/I22,\"\")","v":{"v":-0.08571428571428572,"d":"-8.6%"}},null,{"$f":"IF(SUM(K22:K24),(K24-K22)/K22,\"\")","v":{"v":0.10236220472440945,"d":"10.2%"}}]
[]
[null,"Product 4"]
[null,"Last Year's Sales",{"v":10000,"d":"$10,000"},null,{"v":9000,"d":"$9,000"},null,{"v":12000,"d":"$12,000"},null,{"v":9000,"d":"$9,000"},null,{"$f":"IF(SUM(C29:J29),SUM(C29:J29),\"\")","v":{"v":40000,"d":"$40,000"}}]
[null,"This Year's Sales Goal",{"v":13000,"d":"$13,000"},null,{"v":13000,"d":"$13,000"},null,{"v":13000,"d":"$13,000"},null,{"v":13000,"d":"$13,000"},null,{"$f":"IF(SUM(C30:J30),SUM(C30:J30),\"\")","v":{"v":52000,"d":"$52,000"}}]
[null,"This Year's Actual Sales",{"v":9000,"d":"$9,000"},null,{"v":9000,"d":"$9,000"},null,{"v":15000,"d":"$15,000"},null,{"v":9700,"d":"$9,700"},null,{"$f":"IF(SUM(C31:J31),SUM(C31:J31),\"\")","v":{"v":42700,"d":"$42,700"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C29:C31),C31-C30,\"\")","v":{"v":-4000,"d":"($4,000)"}},{"$f":"IF(SUM(C29:C31),IF(C32<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(E29:E31),E31-E30,\"\")","v":{"v":-4000,"d":"($4,000)"}},{"$f":"IF(SUM(E29:E31),IF(E32<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(G29:G31),G31-G30,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(G29:G31),IF(G32<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(I29:I31),I31-I30,\"\")","v":{"v":-3300,"d":"($3,300)"}},{"$f":"IF(SUM(I29:I31),IF(I32<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(K29:K31),K31-K30,\"\")","v":{"v":-9300,"d":"($9,300)"}},{"$f":"IF(SUM(K29:K31),IF(K32<0,\"U\",\"F\"),\"\")","v":"U"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C29:C31),(C31-C29)/C29,\"\")","v":{"v":-0.1,"d":"-10.0%"}},null,{"$f":"IF(SUM(E29:E31),(E31-E29)/E29,\"\")","v":{"v":0,"d":"0.0%"}},null,{"$f":"IF(SUM(G29:G31),(G31-G29)/G29,\"\")","v":{"v":0.25,"d":"25.0%"}},null,{"$f":"IF(SUM(I29:I31),(I31-I29)/I29,\"\")","v":{"v":0.07777777777777778,"d":"7.8%"}},null,{"$f":"IF(SUM(K29:K31),(K31-K29)/K29,\"\")","v":{"v":0.0675,"d":"6.8%"}}]
[]
[null,"Product 5"]
[null,"Last Year's Sales",{"v":9000,"d":"$9,000"},null,{"v":9000,"d":"$9,000"},null,{"v":9000,"d":"$9,000"},null,{"v":9000,"d":"$9,000"},null,{"$f":"IF(SUM(C36:J36),SUM(C36:J36),\"\")","v":{"v":36000,"d":"$36,000"}}]
[null,"This Year's Sales Goal",{"v":9400,"d":"$9,400"},null,{"v":9400,"d":"$9,400"},null,{"v":9400,"d":"$9,400"},null,{"v":9400,"d":"$9,400"},null,{"$f":"IF(SUM(C37:J37),SUM(C37:J37),\"\")","v":{"v":37600,"d":"$37,600"}}]
[null,"This Year's Actual Sales",{"v":9500,"d":"$9,500"},null,{"v":9600,"d":"$9,600"},null,{"v":9700,"d":"$9,700"},null,{"v":9800,"d":"$9,800"},null,{"$f":"IF(SUM(C38:J38),SUM(C38:J38),\"\")","v":{"v":38600,"d":"$38,600"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C36:C38),C38-C37,\"\")","v":{"v":100,"d":"$100"}},{"$f":"IF(SUM(C36:C38),IF(C39<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(E36:E38),E38-E37,\"\")","v":{"v":200,"d":"$200"}},{"$f":"IF(SUM(E36:E38),IF(E39<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(G36:G38),G38-G37,\"\")","v":{"v":300,"d":"$300"}},{"$f":"IF(SUM(G36:G38),IF(G39<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(I36:I38),I38-I37,\"\")","v":{"v":400,"d":"$400"}},{"$f":"IF(SUM(I36:I38),IF(I39<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(K36:K38),K38-K37,\"\")","v":{"v":1000,"d":"$1,000"}},{"$f":"IF(SUM(K36:K38),IF(K39<0,\"U\",\"F\"),\"\")","v":"F"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C36:C38),(C38-C36)/C36,\"\")","v":{"v":0.05555555555555555,"d":"5.6%"}},null,{"$f":"IF(SUM(E36:E38),(E38-E36)/E36,\"\")","v":{"v":0.06666666666666667,"d":"6.7%"}},null,{"$f":"IF(SUM(G36:G38),(G38-G36)/G36,\"\")","v":{"v":0.07777777777777778,"d":"7.8%"}},null,{"$f":"IF(SUM(I36:I38),(I38-I36)/I36,\"\")","v":{"v":0.08888888888888889,"d":"8.9%"}},null,{"$f":"IF(SUM(K36:K38),(K38-K36)/K36,\"\")","v":{"v":0.07222222222222222,"d":"7.2%"}}]
[]
[null,"Product 6"]
[null,"Last Year's Sales",{"v":17000,"d":"$17,000"},null,{"v":19000,"d":"$19,000"},null,{"v":17000,"d":"$17,000"},null,{"v":17000,"d":"$17,000"},null,{"$f":"IF(SUM(C43:J43),SUM(C43:J43),\"\")","v":{"v":70000,"d":"$70,000"}}]
[null,"This Year's Sales Goal",{"v":18000,"d":"$18,000"},null,{"v":18000,"d":"$18,000"},null,{"v":18000,"d":"$18,000"},null,{"v":18000,"d":"$18,000"},null,{"$f":"IF(SUM(C44:J44),SUM(C44:J44),\"\")","v":{"v":72000,"d":"$72,000"}}]
[null,"This Year's Actual Sales",{"v":15000,"d":"$15,000"},null,{"v":15000,"d":"$15,000"},null,{"v":20000,"d":"$20,000"},null,{"v":21000,"d":"$21,000"},null,{"$f":"IF(SUM(C45:J45),SUM(C45:J45),\"\")","v":{"v":71000,"d":"$71,000"}}]
[null,"Variance from Goal",{"$f":"IF(SUM(C43:C45),C45-C44,\"\")","v":{"v":-3000,"d":"($3,000)"}},{"$f":"IF(SUM(C43:C45),IF(C46<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(E43:E45),E45-E44,\"\")","v":{"v":-3000,"d":"($3,000)"}},{"$f":"IF(SUM(E43:E45),IF(E46<0,\"U\",\"F\"),\"\")","v":"U"},{"$f":"IF(SUM(G43:G45),G45-G44,\"\")","v":{"v":2000,"d":"$2,000"}},{"$f":"IF(SUM(G43:G45),IF(G46<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(I43:I45),I45-I44,\"\")","v":{"v":3000,"d":"$3,000"}},{"$f":"IF(SUM(I43:I45),IF(I46<0,\"U\",\"F\"),\"\")","v":"F"},{"$f":"IF(SUM(K43:K45),K45-K44,\"\")","v":{"v":-1000,"d":"($1,000)"}},{"$f":"IF(SUM(K43:K45),IF(K46<0,\"U\",\"F\"),\"\")","v":"U"}]
[null,"% Change since Last Yr",{"$f":"IF(SUM(C43:C45),(C45-C43)/C43,\"\")","v":{"v":-0.11764705882352941,"d":"-11.8%"}},null,{"$f":"IF(SUM(E43:E45),(E45-E43)/E43,\"\")","v":{"v":-0.21052631578947367,"d":"-21.1%"}},null,{"$f":"IF(SUM(G43:G45),(G45-G43)/G43,\"\")","v":{"v":0.17647058823529413,"d":"17.6%"}},null,{"$f":"IF(SUM(I43:I45),(I45-I43)/I43,\"\")","v":{"v":0.23529411764705882,"d":"23.5%"}},null,{"$f":"IF(SUM(K43:K45),(K45-K43)/K43,\"\")","v":{"v":0.014285714285714285,"d":"1.4%"}}]