{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Quarterly Marketing Budget"],"not_rendered":{"defined_names":29,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Quarterly Marketing Budget","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"merged":[[54,1,54,9]]}
[]
[]
[null,"Quarterly Marketing Budget"]
[null,{"$f":"NOW()","v":"2010-04-19T17:40:49.080"}]
[null,"For the Period Ending 12/31/2009"]
[]
[]
[null,null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4"]
[null,"Advertising","Expenses","% Total ","Expenses","% Total ","Expenses","% Total ","Expenses","% Total "]
[null,"Print",{"v":10000,"d":"$10,000"},{"$f":"IF(SUM(C10:C16),+C10/C17,\"\")","v":{"v":0.11627906976744186,"d":"11.6%"}},{"v":12000,"d":"$12,000"},{"$f":"IF(SUM(E10:E16),+E10/E17,\"\")","v":{"v":0.12371134020618557,"d":"12.4%"}},{"v":10000,"d":"$10,000"},{"$f":"IF(SUM(G10:G16),+G10/G17,\"\")","v":{"v":0.11627906976744186,"d":"11.6%"}},{"v":12000,"d":"$12,000"},{"$f":"IF(SUM(I10:I16),+I10/I17,\"\")","v":{"v":0.12371134020618557,"d":"12.4%"}}]
[null,"Radio",{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(C10:C16),+C11/C17,\"\")","v":{"v":0.11627906976744186,"d":"11.6%"}},{"v":11000,"d":"11,000 "},{"$f":"IF(SUM(E10:E16),+E11/E17,\"\")","v":{"v":0.1134020618556701,"d":"11.3%"}},{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(G10:G16),+G11/G17,\"\")","v":{"v":0.11627906976744186,"d":"11.6%"}},{"v":11000,"d":"11,000 "},{"$f":"IF(SUM(I10:I16),+I11/I17,\"\")","v":{"v":0.1134020618556701,"d":"11.3%"}}]
[null,"Television",{"v":25000,"d":"25,000 "},{"$f":"IF(SUM(C10:C16),+C12/C17,\"\")","v":{"v":0.29069767441860467,"d":"29.1%"}},{"v":28000,"d":"28,000 "},{"$f":"IF(SUM(E10:E16),+E12/E17,\"\")","v":{"v":0.28865979381443296,"d":"28.9%"}},{"v":25000,"d":"25,000 "},{"$f":"IF(SUM(G10:G16),+G12/G17,\"\")","v":{"v":0.29069767441860467,"d":"29.1%"}},{"v":28000,"d":"28,000 "},{"$f":"IF(SUM(I10:I16),+I12/I17,\"\")","v":{"v":0.28865979381443296,"d":"28.9%"}}]
[null,"Direct Mail",{"v":30000,"d":"30,000 "},{"$f":"IF(SUM(C10:C16),+C13/C17,\"\")","v":{"v":0.3488372093023256,"d":"34.9%"}},{"v":32000,"d":"32,000 "},{"$f":"IF(SUM(E10:E16),+E13/E17,\"\")","v":{"v":0.32989690721649484,"d":"33.0%"}},{"v":30000,"d":"30,000 "},{"$f":"IF(SUM(G10:G16),+G13/G17,\"\")","v":{"v":0.3488372093023256,"d":"34.9%"}},{"v":32000,"d":"32,000 "},{"$f":"IF(SUM(I10:I16),+I13/I17,\"\")","v":{"v":0.32989690721649484,"d":"33.0%"}}]
[null,"Point of Purchase",{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(C10:C16),+C14/C17,\"\")","v":{"v":0.05813953488372093,"d":"5.8%"}},{"v":6000,"d":"6,000 "},{"$f":"IF(SUM(E10:E16),+E14/E17,\"\")","v":{"v":0.061855670103092786,"d":"6.2%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(G10:G16),+G14/G17,\"\")","v":{"v":0.05813953488372093,"d":"5.8%"}},{"v":6000,"d":"6,000 "},{"$f":"IF(SUM(I10:I16),+I14/I17,\"\")","v":{"v":0.061855670103092786,"d":"6.2%"}}]
[null,"Co-op",{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(C10:C16),+C15/C17,\"\")","v":{"v":0.05813953488372093,"d":"5.8%"}},{"v":7000,"d":"7,000 "},{"$f":"IF(SUM(E10:E16),+E15/E17,\"\")","v":{"v":0.07216494845360824,"d":"7.2%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(G10:G16),+G15/G17,\"\")","v":{"v":0.05813953488372093,"d":"5.8%"}},{"v":7000,"d":"7,000 "},{"$f":"IF(SUM(I10:I16),+I15/I17,\"\")","v":{"v":0.07216494845360824,"d":"7.2%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C10:C16),+C16/C17,\"\")","v":{"v":0.011627906976744186,"d":"1.2%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(E10:E16),+E16/E17,\"\")","v":{"v":0.010309278350515464,"d":"1.0%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G10:G16),+G16/G17,\"\")","v":{"v":0.011627906976744186,"d":"1.2%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(I10:I16),+I16/I17,\"\")","v":{"v":0.010309278350515464,"d":"1.0%"}}]
[null,"Totals",{"$f":"IF(SUM(C10:C16),SUM(C10:C16),\"\")","v":{"v":86000,"d":"$86,000"}},{"$f":"IF(SUM(C10:C16),C17/C52,\"\")","v":{"v":0.12044817927170869,"d":"12.0%"}},{"$f":"IF(SUM(E10:E16),SUM(E10:E16),\"\")","v":{"v":97000,"d":"$97,000"}},{"$f":"IF(SUM(E10:E16),E17/E52,\"\")","v":{"v":0.13099257258609048,"d":"13.1%"}},{"$f":"IF(SUM(G10:G16),SUM(G10:G16),\"\")","v":{"v":86000,"d":"$86,000"}},{"$f":"IF(SUM(G10:G16),G17/G52,\"\")","v":{"v":0.12044817927170869,"d":"12.0%"}},{"$f":"IF(SUM(I10:I16),SUM(I10:I16),\"\")","v":{"v":97000,"d":"$97,000"}},{"$f":"IF(SUM(I10:I16),I17/I52,\"\")","v":{"v":0.13099257258609048,"d":"13.1%"}}]
[null,"Sales Promotion"]
[null,"Trade Shows",{"v":2000,"d":"$2,000"},{"$f":"IF(SUM(C19:C21),C19/C22,\"\")","v":{"v":0.15384615384615385,"d":"15.4%"}},{"v":3000,"d":"$3,000"},{"$f":"IF(SUM(E19:E21),E19/E22,\"\")","v":{"v":0.5454545454545454,"d":"54.5%"}},{"v":2000,"d":"$2,000"},{"$f":"IF(SUM(G19:G21),G19/G22,\"\")","v":{"v":0.15384615384615385,"d":"15.4%"}},{"v":3000,"d":"$3,000"},{"$f":"IF(SUM(I19:I21),I19/I22,\"\")","v":{"v":0.5454545454545454,"d":"54.5%"}}]
[null,"Sales Force Promotion",{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(C19:C21),C20/C22,\"\")","v":{"v":0.7692307692307693,"d":"76.9%"}},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(E19:E21),E20/E22,\"\")","v":{"v":0.36363636363636365,"d":"36.4%"}},{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(G19:G21),G20/G22,\"\")","v":{"v":0.7692307692307693,"d":"76.9%"}},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(I19:I21),I20/I22,\"\")","v":{"v":0.36363636363636365,"d":"36.4%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C19:C21),C21/C22,\"\")","v":{"v":0.07692307692307693,"d":"7.7%"}},{"v":500,"d":"500 "},{"$f":"IF(SUM(E19:E21),E21/E22,\"\")","v":{"v":0.09090909090909091,"d":"9.1%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G19:G21),G21/G22,\"\")","v":{"v":0.07692307692307693,"d":"7.7%"}},{"v":500,"d":"500 "},{"$f":"IF(SUM(I19:I21),I21/I22,\"\")","v":{"v":0.09090909090909091,"d":"9.1%"}}]
[null,"Totals",{"$f":"IF(SUM(C19:C21),SUM(C19:C21),\"\")","v":{"v":13000,"d":"$13,000"}},{"$f":"IF(SUM(C19:C21),+C22/C52,\"\")","v":{"v":0.018207282913165267,"d":"1.8%"}},{"$f":"IF(SUM(E19:E21),SUM(E19:E21),\"\")","v":{"v":5500,"d":"$5,500"}},{"$f":"IF(SUM(E19:E21),+E22/E52,\"\")","v":{"v":0.007427413909520594,"d":"0.7%"}},{"$f":"IF(SUM(G19:G21),SUM(G19:G21),\"\")","v":{"v":13000,"d":"$13,000"}},{"$f":"IF(SUM(G19:G21),+G22/G52,\"\")","v":{"v":0.018207282913165267,"d":"1.8%"}},{"$f":"IF(SUM(I19:I21),SUM(I19:I21),\"\")","v":{"v":5500,"d":"$5,500"}},{"$f":"IF(SUM(I19:I21),+I22/I52,\"\")","v":{"v":0.007427413909520594,"d":"0.7%"}}]
[null,"G&A"]
[null,"Clerical",{"v":100000,"d":"$100,000"},{"$f":"IF(SUM(C24:C29),C24/C30,\"\")","v":{"v":0.27472527472527475,"d":"27.5%"}},{"v":110000,"d":"$110,000"},{"$f":"IF(SUM(E24:E29),E24/E30,\"\")","v":{"v":0.2842377260981912,"d":"28.4%"}},{"v":100000,"d":"$100,000"},{"$f":"IF(SUM(G24:G29),G24/G30,\"\")","v":{"v":0.27472527472527475,"d":"27.5%"}},{"v":110000,"d":"$110,000"},{"$f":"IF(SUM(I24:I29),I24/I30,\"\")","v":{"v":0.2842377260981912,"d":"28.4%"}}]
[null,"Managerial",{"v":200000,"d":"200,000 "},{"$f":"IF(SUM(C24:C29),C25/C30,\"\")","v":{"v":0.5494505494505495,"d":"54.9%"}},{"v":210000,"d":"210,000 "},{"$f":"IF(SUM(E24:E29),E25/E30,\"\")","v":{"v":0.5426356589147286,"d":"54.3%"}},{"v":200000,"d":"200,000 "},{"$f":"IF(SUM(G24:G29),G25/G30,\"\")","v":{"v":0.5494505494505495,"d":"54.9%"}},{"v":210000,"d":"210,000 "},{"$f":"IF(SUM(I24:I29),I25/I30,\"\")","v":{"v":0.5426356589147286,"d":"54.3%"}}]
[null,"Telephone",{"v":40000,"d":"40,000 "},{"$f":"IF(SUM(C24:C29),C26/C30,\"\")","v":{"v":0.10989010989010989,"d":"11.0%"}},{"v":41000,"d":"41,000 "},{"$f":"IF(SUM(E24:E29),E26/E30,\"\")","v":{"v":0.10594315245478036,"d":"10.6%"}},{"v":40000,"d":"40,000 "},{"$f":"IF(SUM(G24:G29),G26/G30,\"\")","v":{"v":0.10989010989010989,"d":"11.0%"}},{"v":41000,"d":"41,000 "},{"$f":"IF(SUM(I24:I29),I26/I30,\"\")","v":{"v":0.10594315245478036,"d":"10.6%"}}]
[null,"Travel",{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(C24:C29),C27/C30,\"\")","v":{"v":0.04120879120879121,"d":"4.1%"}},{"v":16000,"d":"16,000 "},{"$f":"IF(SUM(E24:E29),E27/E30,\"\")","v":{"v":0.041343669250646,"d":"4.1%"}},{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(G24:G29),G27/G30,\"\")","v":{"v":0.04120879120879121,"d":"4.1%"}},{"v":16000,"d":"16,000 "},{"$f":"IF(SUM(I24:I29),I27/I30,\"\")","v":{"v":0.041343669250646,"d":"4.1%"}}]
[null,"Supplies",{"v":8000,"d":"8,000 "},{"$f":"IF(SUM(C24:C29),C28/C30,\"\")","v":{"v":0.02197802197802198,"d":"2.2%"}},{"v":9000,"d":"9,000 "},{"$f":"IF(SUM(E24:E29),E28/E30,\"\")","v":{"v":0.023255813953488372,"d":"2.3%"}},{"v":8000,"d":"8,000 "},{"$f":"IF(SUM(G24:G29),G28/G30,\"\")","v":{"v":0.02197802197802198,"d":"2.2%"}},{"v":9000,"d":"9,000 "},{"$f":"IF(SUM(I24:I29),I28/I30,\"\")","v":{"v":0.023255813953488372,"d":"2.3%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C24:C29),C29/C30,\"\")","v":{"v":2.7472527472527475E-3,"d":"0.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(E24:E29),E29/E30,\"\")","v":{"v":0.002583979328165375,"d":"0.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G24:G29),G29/G30,\"\")","v":{"v":2.7472527472527475E-3,"d":"0.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(I24:I29),I29/I30,\"\")","v":{"v":0.002583979328165375,"d":"0.3%"}}]
[null,"Totals",{"$f":"IF(SUM(C24:C29),SUM(C24:C29),\"\")","v":{"v":364000,"d":"$364,000"}},{"$f":"IF(SUM(C24:C29),C30/C52,\"\")","v":{"v":0.5098039215686274,"d":"51.0%"}},{"$f":"IF(SUM(E24:E29),SUM(E24:E29),\"\")","v":{"v":387000,"d":"$387,000"}},{"$f":"IF(SUM(E24:E29),E30/E52,\"\")","v":{"v":0.5226198514517219,"d":"52.3%"}},{"$f":"IF(SUM(G24:G29),SUM(G24:G29),\"\")","v":{"v":364000,"d":"$364,000"}},{"$f":"IF(SUM(G24:G29),G30/G52,\"\")","v":{"v":0.5098039215686274,"d":"51.0%"}},{"$f":"IF(SUM(I24:I29),SUM(I24:I29),\"\")","v":{"v":387000,"d":"$387,000"}},{"$f":"IF(SUM(I24:I29),I30/I52,\"\")","v":{"v":0.5226198514517219,"d":"52.3%"}}]
[null,"HR Development"]
[null,"Videos",{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(C32:C35),+C32/C36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(E32:E35),+E32/E36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(G32:G35),+G32/G36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(I32:I35),+I32/I36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}}]
[null,"Workshops",{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(C32:C35),+C33/C36,\"\")","v":{"v":0.5405405405405406,"d":"54.1%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(E32:E35),+E33/E36,\"\")","v":{"v":0.5405405405405406,"d":"54.1%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(G32:G35),+G33/G36,\"\")","v":{"v":0.5405405405405406,"d":"54.1%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(I32:I35),+I33/I36,\"\")","v":{"v":0.5405405405405406,"d":"54.1%"}}]
[null,"Tuition / Seminars",{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(C32:C35),+C34/C36,\"\")","v":{"v":0.40540540540540543,"d":"40.5%"}},{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(E32:E35),+E34/E36,\"\")","v":{"v":0.40540540540540543,"d":"40.5%"}},{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(G32:G35),+G34/G36,\"\")","v":{"v":0.40540540540540543,"d":"40.5%"}},{"v":15000,"d":"15,000 "},{"$f":"IF(SUM(I32:I35),+I34/I36,\"\")","v":{"v":0.40540540540540543,"d":"40.5%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C32:C35),+C35/C36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(E32:E35),+E35/E36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G32:G35),+G35/G36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(I32:I35),+I35/I36,\"\")","v":{"v":0.02702702702702703,"d":"2.7%"}}]
[null,"Totals",{"$f":"IF(SUM(C32:C35),SUM(C32:C35),\"\")","v":{"v":37000,"d":"$37,000"}},{"$f":"IF(SUM(C32:C35),+C36/C52,\"\")","v":{"v":0.05182072829131653,"d":"5.2%"}},{"$f":"IF(SUM(E32:E35),SUM(E32:E35),\"\")","v":{"v":37000,"d":"$37,000"}},{"$f":"IF(SUM(E32:E35),+E36/E52,\"\")","v":{"v":0.049966239027684,"d":"5.0%"}},{"$f":"IF(SUM(G32:G35),SUM(G32:G35),\"\")","v":{"v":37000,"d":"$37,000"}},{"$f":"IF(SUM(G32:G35),+G36/G52,\"\")","v":{"v":0.05182072829131653,"d":"5.2%"}},{"$f":"IF(SUM(I32:I35),SUM(I32:I35),\"\")","v":{"v":37000,"d":"$37,000"}},{"$f":"IF(SUM(I32:I35),+I36/I52,\"\")","v":{"v":0.049966239027684,"d":"5.0%"}}]
[null,"Sales Force"]
[null,"Motivational Programs",{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(C38:C43),+C38/C44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(E38:E43),+E38/E44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(G38:G43),+G38/G44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"$1,000"},{"$f":"IF(SUM(I38:I43),+I38/I44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}}]
[null,"Recruiting",{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(C38:C43),+C39/C44,\"\")","v":{"v":0.010869565217391304,"d":"1.1%"}},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(E38:E43),+E39/E44,\"\")","v":{"v":0.010869565217391304,"d":"1.1%"}},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(G38:G43),+G39/G44,\"\")","v":{"v":0.010869565217391304,"d":"1.1%"}},{"v":2000,"d":"2,000 "},{"$f":"IF(SUM(I38:I43),+I39/I44,\"\")","v":{"v":0.010869565217391304,"d":"1.1%"}}]
[null,"Salaries and Benefits",{"v":150000,"d":"150,000 "},{"$f":"IF(SUM(C38:C43),+C40/C44,\"\")","v":{"v":0.8152173913043478,"d":"81.5%"}},{"v":150000,"d":"150,000 "},{"$f":"IF(SUM(E38:E43),+E40/E44,\"\")","v":{"v":0.8152173913043478,"d":"81.5%"}},{"v":150000,"d":"150,000 "},{"$f":"IF(SUM(G38:G43),+G40/G44,\"\")","v":{"v":0.8152173913043478,"d":"81.5%"}},{"v":150000,"d":"150,000 "},{"$f":"IF(SUM(I38:I43),+I40/I44,\"\")","v":{"v":0.8152173913043478,"d":"81.5%"}}]
[null,"Telephone",{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(C38:C43),+C41/C44,\"\")","v":{"v":0.10869565217391304,"d":"10.9%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(E38:E43),+E41/E44,\"\")","v":{"v":0.10869565217391304,"d":"10.9%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(G38:G43),+G41/G44,\"\")","v":{"v":0.10869565217391304,"d":"10.9%"}},{"v":20000,"d":"20,000 "},{"$f":"IF(SUM(I38:I43),+I41/I44,\"\")","v":{"v":0.10869565217391304,"d":"10.9%"}}]
[null,"Training",{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(C38:C43),+C42/C44,\"\")","v":{"v":0.05434782608695652,"d":"5.4%"}},{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(E38:E43),+E42/E44,\"\")","v":{"v":0.05434782608695652,"d":"5.4%"}},{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(G38:G43),+G42/G44,\"\")","v":{"v":0.05434782608695652,"d":"5.4%"}},{"v":10000,"d":"10,000 "},{"$f":"IF(SUM(I38:I43),+I42/I44,\"\")","v":{"v":0.05434782608695652,"d":"5.4%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C38:C43),+C43/C44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(E38:E43),+E43/E44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G38:G43),+G43/G44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(I38:I43),+I43/I44,\"\")","v":{"v":5.434782608695652E-3,"d":"0.5%"}}]
[null,"Totals",{"$f":"IF(SUM(C38:C43),SUM(C38:C43),\"\")","v":{"v":184000,"d":"$184,000"}},{"$f":"IF(SUM(C38:C43),+C44/C52,\"\")","v":{"v":0.25770308123249297,"d":"25.8%"}},{"$f":"IF(SUM(E38:E43),SUM(E38:E43),\"\")","v":{"v":184000,"d":"$184,000"}},{"$f":"IF(SUM(E38:E43),+E44/E52,\"\")","v":{"v":0.24848075624577987,"d":"24.8%"}},{"$f":"IF(SUM(G38:G43),SUM(G38:G43),\"\")","v":{"v":184000,"d":"$184,000"}},{"$f":"IF(SUM(G38:G43),+G44/G52,\"\")","v":{"v":0.25770308123249297,"d":"25.8%"}},{"$f":"IF(SUM(I38:I43),SUM(I38:I43),\"\")","v":{"v":184000,"d":"$184,000"}},{"$f":"IF(SUM(I38:I43),+I44/I52,\"\")","v":{"v":0.24848075624577987,"d":"24.8%"}}]
[null,"Market Research"]
[null,"Salaries and Benefits",{"v":15000,"d":"$15,000"},{"$f":"IF(SUM(C46:C50),+C46/C51,\"\")","v":{"v":0.5,"d":"50.0%"}},{"v":15000,"d":"$15,000"},{"$f":"IF(SUM(E46:E50),+E46/E51,\"\")","v":{"v":0.5,"d":"50.0%"}},{"v":15000,"d":"$15,000"},{"$f":"IF(SUM(G46:G50),+G46/G51,\"\")","v":{"v":0.5,"d":"50.0%"}},{"v":15000,"d":"$15,000"},{"$f":"IF(SUM(I46:I50),+I46/I51,\"\")","v":{"v":0.5,"d":"50.0%"}}]
[null,"Supplies",{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(C46:C50),+C47/C51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(E46:E50),+E47/E51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(G46:G50),+G47/G51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(I46:I50),+I47/I51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}}]
[null,"Telephone",{"v":4000,"d":"4,000 "},{"$f":"IF(SUM(C46:C50),+C48/C51,\"\")","v":{"v":0.13333333333333333,"d":"13.3%"}},{"v":4000,"d":"4,000 "},{"$f":"IF(SUM(E46:E50),+E48/E51,\"\")","v":{"v":0.13333333333333333,"d":"13.3%"}},{"v":4000,"d":"4,000 "},{"$f":"IF(SUM(G46:G50),+G48/G51,\"\")","v":{"v":0.13333333333333333,"d":"13.3%"}},{"v":4000,"d":"4,000 "},{"$f":"IF(SUM(I46:I50),+I48/I51,\"\")","v":{"v":0.13333333333333333,"d":"13.3%"}}]
[null,"Travel",{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(C46:C50),+C49/C51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(E46:E50),+E49/E51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(G46:G50),+G49/G51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"v":5000,"d":"5,000 "},{"$f":"IF(SUM(I46:I50),+I49/I51,\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}}]
[null,"Other",{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(C46:C50),+C50/C51,\"\")","v":{"v":0.03333333333333333,"d":"3.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(E46:E50),+E50/E51,\"\")","v":{"v":0.03333333333333333,"d":"3.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(G46:G50),+G50/G51,\"\")","v":{"v":0.03333333333333333,"d":"3.3%"}},{"v":1000,"d":"1,000 "},{"$f":"IF(SUM(I46:I50),+I50/I51,\"\")","v":{"v":0.03333333333333333,"d":"3.3%"}}]
[null,"Totals",{"$f":"IF(SUM(C46:C50),SUM(C46:C50),\"\")","v":{"v":30000,"d":"$30,000"}},{"$f":"IF(SUM(C46:C50),+C51/C52,\"\")","v":{"v":0.04201680672268908,"d":"4.2%"}},{"$f":"IF(SUM(E46:E50),SUM(E46:E50),\"\")","v":{"v":30000,"d":"$30,000"}},{"$f":"IF(SUM(E46:E50),+E51/E52,\"\")","v":{"v":0.04051316677920324,"d":"4.1%"}},{"$f":"IF(SUM(G46:G50),SUM(G46:G50),\"\")","v":{"v":30000,"d":"$30,000"}},{"$f":"IF(SUM(G46:G50),+G51/G52,\"\")","v":{"v":0.04201680672268908,"d":"4.2%"}},{"$f":"IF(SUM(I46:I50),SUM(I46:I50),\"\")","v":{"v":30000,"d":"$30,000"}},{"$f":"IF(SUM(I46:I50),+I51/I52,\"\")","v":{"v":0.04051316677920324,"d":"4.1%"}}]
[null,"Grand Totals",{"$f":"IF(SUM(C17,C22,C30,C36,C44),SUM(C17,C22,C30,C36,C44,C51),\"\")","v":{"v":714000,"d":"$714,000"}},{"$f":"IF(SUM(C52),+C52/C52,\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(SUM(E17,E22,E30,E36,E44),SUM(E17,E22,E30,E36,E44,E51),\"\")","v":{"v":740500,"d":"$740,500"}},{"$f":"IF(SUM(E52),+E52/E52,\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(SUM(G17,G22,G30,G36,G44),SUM(G17,G22,G30,G36,G44,G51),\"\")","v":{"v":714000,"d":"$714,000"}},{"$f":"IF(SUM(G52),+G52/G52,\"\")","v":{"v":1,"d":"100%"}},{"$f":"IF(SUM(I17,I22,I30,I36,I44),SUM(I17,I22,I30,I36,I44,I51),\"\")","v":{"v":740500,"d":"$740,500"}},{"$f":"IF(SUM(I52),+I52/I52,\"\")","v":{"v":1,"d":"100%"}}]