{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sales Promotion Expenses"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sales Promotion Expenses","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[33,1,33,7]]}
[]
[]
[null,"Sales Promotion Expenditures by Quarter"]
[null,"For the Year 2009"]
[]
[]
[{"$nulls":3},"Q1",{"$f":"LEFT(D7,LEN(D7)-1)&FIXED(CHOOSE(VALUE(RIGHT(D7,1)),2,3,4,1),0,TRUE)","v":"Q2"},{"$f":"LEFT(E7,LEN(E7)-1)&FIXED(CHOOSE(VALUE(RIGHT(E7,1)),2,3,4,1),0,TRUE)","v":"Q3"},{"$f":"LEFT(F7,LEN(F7)-1)&FIXED(CHOOSE(VALUE(RIGHT(F7,1)),2,3,4,1),0,TRUE)","v":"Q4"},"Total"]
[null,"Trade Promotions to Distributors"]
[null,null,"Promotion",{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},{"$f":"IF(SUM(D9:G9),SUM(D9:G9),\"\")","v":{"v":12000,"d":"$12,000"}}]
[null,null,"Promotion",{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(D10:G10),SUM(D10:G10),\"\")","v":{"v":8000,"d":"8,000 "}}]
[null,null,"Promotion",{"v":2500,"d":"2,500 "},{"v":2500,"d":"2,500 "},{"v":2500,"d":"2,500 "},{"v":2500,"d":"2,500 "},{"$f":"IF(SUM(D11:G11),SUM(D11:G11),\"\")","v":{"v":10000,"d":"10,000 "}}]
[null,null,"Promotion",{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(D12:G12),SUM(D12:G12),\"\")","v":{"v":4000,"d":"4,000 "}}]
[null,null,"Totals",{"$f":"IF(SUM(D9:D12),SUM(D9:D12),\"\")","v":{"v":8500,"d":"$8,500"}},{"$f":"IF(SUM(E9:E12),SUM(E9:E12),\"\")","v":{"v":8500,"d":"$8,500"}},{"$f":"IF(SUM(F9:F12),SUM(F9:F12),\"\")","v":{"v":8500,"d":"$8,500"}},{"$f":"IF(SUM(G9:G12),SUM(G9:G12),\"\")","v":{"v":8500,"d":"$8,500"}},{"$f":"IF(SUM(H9:H12),SUM(H9:H12),\"\")","v":{"v":34000,"d":"$34,000"}}]
[null,"Trade Shows"]
[null,null,"Promotion",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(D15:G15),SUM(D15:G15),\"\")","v":{"v":4000,"d":"$4,000"}}]
[null,null,"Promotion",{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(D16:G16),SUM(D16:G16),\"\")","v":{"v":8000,"d":"8,000 "}}]
[null,null,"Promotion",{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(D17:G17),SUM(D17:G17),\"\")","v":{"v":8000,"d":"8,000 "}}]
[null,null,"Promotion",{"v":3000,"d":"3,000 "},{"v":3000,"d":"3,000 "},{"v":3000,"d":"3,000 "},{"v":3000,"d":"3,000 "},{"$f":"IF(SUM(D18:G18),SUM(D18:G18),\"\")","v":{"v":12000,"d":"12,000 "}}]
[null,null,"Totals",{"$f":"IF(SUM(D15:D18),SUM(D15:D18),\"\")","v":{"v":8000,"d":"$8,000"}},{"$f":"IF(SUM(E15:E18),SUM(E15:E18),\"\")","v":{"v":8000,"d":"$8,000"}},{"$f":"IF(SUM(F15:F18),SUM(F15:F18),\"\")","v":{"v":8000,"d":"$8,000"}},{"$f":"IF(SUM(G15:G18),SUM(G15:G18),\"\")","v":{"v":8000,"d":"$8,000"}},{"$f":"IF(SUM(H15:H18),SUM(H15:H18),\"\")","v":{"v":32000,"d":"$32,000"}}]
[null,"Sales Force Promotion"]
[null,null,"Promotion",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"IF(SUM(D21:G21),SUM(D21:G21),\"\")","v":{"v":400,"d":"$400"}}]
[null,null,"Promotion",{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"v":500,"d":"500 "},{"$f":"IF(SUM(D22:G22),SUM(D22:G22),\"\")","v":{"v":2000,"d":"2,000 "}}]
[null,null,"Promotion",{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(D23:G23),SUM(D23:G23),\"\")","v":{"v":80000,"d":"80,000 "}}]
[null,null,"Promotion",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"$f":"IF(SUM(D24:G24),SUM(D24:G24),\"\")","v":{"v":400000,"d":"400,000 "}}]
[null,null,"Totals",{"$f":"IF(SUM(D21:D24),SUM(D21:D24),\"\")","v":{"v":120600,"d":"$120,600"}},{"$f":"IF(SUM(E21:E24),SUM(E21:E24),\"\")","v":{"v":120600,"d":"$120,600"}},{"$f":"IF(SUM(F21:F24),SUM(F21:F24),\"\")","v":{"v":120600,"d":"$120,600"}},{"$f":"IF(SUM(G21:G24),SUM(G21:G24),\"\")","v":{"v":120600,"d":"$120,600"}},{"$f":"IF(SUM(H21:H24),SUM(H21:H24),\"\")","v":{"v":482400,"d":"$482,400"}}]
[null,"Other Promotions"]
[null,null,"Promotion",{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"v":2500,"d":"$2,500"},{"$f":"IF(SUM(D27:G27),SUM(D27:G27),\"\")","v":{"v":10000,"d":"$10,000"}}]
[{"$nulls":7},{"$f":"IF(SUM(D28:G28),SUM(D28:G28),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(D29:G29),SUM(D29:G29),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(D30:G30),SUM(D30:G30),\"\")","v":""}]
[null,null,"Totals",{"$f":"IF(SUM(D27:D30),SUM(D27:D30),\"\")","v":{"v":2500,"d":"$2,500"}},{"$f":"IF(SUM(E27:E30),SUM(E27:E30),\"\")","v":{"v":2500,"d":"$2,500"}},{"$f":"IF(SUM(F27:F30),SUM(F27:F30),\"\")","v":{"v":2500,"d":"$2,500"}},{"$f":"IF(SUM(G27:G30),SUM(G27:G30),\"\")","v":{"v":2500,"d":"$2,500"}},{"$f":"IF(SUM(H27:H30),SUM(H27:H30),\"\")","v":{"v":10000,"d":"$10,000"}}]
[null,"Total Promotion Budget",null,{"$f":"IF(SUM(D13,D19,D25,D31),SUM(D13,D19,D25,D31),\"\")","v":{"v":139600,"d":"$139,600"}},{"$f":"IF(SUM(E13,E19,E25,E31),SUM(E13,E19,E25,E31),\"\")","v":{"v":139600,"d":"$139,600"}},{"$f":"IF(SUM(F13,F19,F25,F31),SUM(F13,F19,F25,F31),\"\")","v":{"v":139600,"d":"$139,600"}},{"$f":"IF(SUM(G13,G19,G25,G31),SUM(G13,G19,G25,G31),\"\")","v":{"v":139600,"d":"$139,600"}},{"$f":"IF(SUM(H13,H19,H25,H31),SUM(H13,H19,H25,H31),\"\")","v":{"v":558400,"d":"$558,400"}}]