{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Media Budget by Quarter"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Media Budget by Quarter","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[20,1,20,7]]}
[]
[]
[null,"Media Budget by Quarter"]
[null,"Product"]
[null,{"$f":"NOW()","v":"2010-04-19T18:58:58.280"}]
[]
[null,"Medium","Q1",{"$f":"IF(SUM(C7)>0,CHOOSE(C7,2,3,4,1),LEFT(C7,LEN(C7)-1)&FIXED(CHOOSE(VALUE(RIGHT(C7,1)),2,3,4,1),0,TRUE))","v":"Q2"},{"$f":"IF(SUM(D7)>0,CHOOSE(D7,2,3,4,1),LEFT(D7,LEN(D7)-1)&FIXED(CHOOSE(VALUE(RIGHT(D7,1)),2,3,4,1),0,TRUE))","v":"Q3"},{"$f":"IF(SUM(E7)>0,CHOOSE(E7,2,3,4,1),LEFT(E7,LEN(E7)-1)&FIXED(CHOOSE(VALUE(RIGHT(E7,1)),2,3,4,1),0,TRUE))","v":"Q4"},"Total","Percent"]
[null,"Television",{"v":500000,"d":"$500,000"},{"v":540000,"d":"$540,000"},{"v":500000,"d":"$500,000"},{"v":600000,"d":"$600,000"},{"$f":"IF(SUM(C8:F8),SUM(C8:F8),\"\")","v":{"v":2140000,"d":"$2,140,000"}},{"$f":"IF(SUM(C8:F8),+G8/G17,\"\")","v":{"v":0.3912248628884826,"d":"39.1%"}}]
[null,"Radio",{"v":100000,"d":"100,000 "},{"v":120000,"d":"120,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":520000,"d":"520,000 "},{"$f":"IF(SUM(C9:F9),+G9/G17,\"\")","v":{"v":0.09506398537477148,"d":"9.5%"}}]
[null,"Newspapers",{"v":200000,"d":"200,000 "},{"v":210000,"d":"210,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":910000,"d":"910,000 "},{"$f":"IF(SUM(C10:F10),+G10/G17,\"\")","v":{"v":0.1663619744058501,"d":"16.6%"}}]
[null,"Magazines",{"v":200000,"d":"200,000 "},{"v":210000,"d":"210,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":910000,"d":"910,000 "},{"$f":"IF(SUM(C11:F11),+G11/G17,\"\")","v":{"v":0.1663619744058501,"d":"16.6%"}}]
[null,"Direct Mail",{"v":200000,"d":"200,000 "},{"v":210000,"d":"210,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":910000,"d":"910,000 "},{"$f":"IF(SUM(C12:F12),+G12/G17,\"\")","v":{"v":0.1663619744058501,"d":"16.6%"}}]
[null,"On-Line",{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":80000,"d":"80,000 "},{"$f":"IF(SUM(C13:F13),+G13/G17,\"\")","v":{"v":0.014625228519195612,"d":"1.5%"}}]
[null,"Trade Shows",{"$nulls":4},"",{"$f":"IF(SUM(C14:F14),+G14/G17,\"\")","v":""}]
[null,"Other",{"$nulls":4},"",{"$f":"IF(SUM(C15:F15),+G15/G17,\"\")","v":""}]
[{"$nulls":6},"",{"$f":"IF(SUM(C16:F16),+G16/G17,\"\")","v":""}]
[null,"Total",{"$f":"IF(SUM(C8:C16),SUM(C8:C16),\"\")","v":{"v":1220000,"d":"$1,220,000"}},{"$f":"IF(SUM(D8:D16),SUM(D8:D16),\"\")","v":{"v":1310000,"d":"$1,310,000"}},{"$f":"IF(SUM(E8:E16),SUM(E8:E16),\"\")","v":{"v":1420000,"d":"$1,420,000"}},{"$f":"IF(SUM(F8:F16),SUM(F8:F16),\"\")","v":{"v":1520000,"d":"$1,520,000"}},{"$f":"IF(SUM(G8:G16),SUM(G8:G16),\"\")","v":{"v":5470000,"d":"$5,470,000"}},{"$f":"IF(SUM(C17:F17),+G17/G17,\"\")","v":{"v":1,"d":"100.0%"}}]
[]
[null,"Percent",{"$f":"IF(SUM(G17),C17/G17,\"\")","v":{"v":0.2230347349177331,"d":"22.3%"}},{"$f":"IF(SUM(G17),D17/G17,\"\")","v":{"v":0.23948811700182815,"d":"23.9%"}},{"$f":"IF(SUM(G17),E17/G17,\"\")","v":{"v":0.2595978062157221,"d":"26.0%"}},{"$f":"IF(SUM(G17),F17/G17,\"\")","v":{"v":0.27787934186471663,"d":"27.8%"}},{"$f":"IF(SUM(G17),G17/G17,\"\")","v":{"v":1,"d":"100.0%"}}]