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

{"sheet":"Sales Activity Report","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[30,1,30,6]]}
[]
[]
[null,"Sales Activity Report"]
[null,"For December 2009"]
[]
[]
[null,"Salesperson"]
[null,"Territory  ",{"$nulls":3},"Date      "]
[]
[]
[{"$nulls":5},"FORECAST ","ACTUAL "]
[null,"Gross Sales",{"$nulls":3},{"v":100000,"d":"$100,000"},{"v":180000,"d":"$180,000"}]
[null,"Gross Profit",{"$nulls":3},{"v":25000,"d":"25,000 "},{"v":50000,"d":"50,000 "}]
[null,"% Gross Profit to Gross Sales",{"$nulls":3},{"$f":"IF(F12,F13/F12,\"\")","v":{"v":0.25,"d":"25.0%"}},{"$f":"IF(G12,G13/G12,\"\")","v":{"v":0.2777777777777778,"d":"27.8%"}}]
[null,"Net Profit",{"$nulls":3},{"v":15000,"d":"15,000 "},{"v":24000,"d":"24,000 "}]
[null,"% Net Profit to Gross Sales",{"$nulls":3},{"$f":"IF(F12,F15/F12,\"\")","v":{"v":0.15,"d":"15.0%"}},{"$f":"IF(G12,G15/G12,\"\")","v":{"v":0.13333333333333333,"d":"13.3%"}}]
[null,"Salary",{"$nulls":3},{"v":7000,"d":"7,000 "},{"v":7000,"d":"7,000 "}]
[null,"Commission",{"$nulls":3},{"v":3500,"d":"3,500 "},{"v":4000,"d":"4,000 "}]
[null,"Expense:",null,"Auto",null,{"v":1000,"d":"1,000 "},{"v":1100,"d":"1,100 "}]
[{"$nulls":3},"Travel",null,{"v":500,"d":"500 "},{"v":600,"d":"600 "}]
[{"$nulls":3},"Entertainment",null,{"v":1000,"d":"1,000 "},{"v":1200,"d":"1,200 "}]
[{"$nulls":3},"Other",null,{"v":100,"d":"100 "},{"v":500,"d":"500 "}]
[null,"Total Days Worked",{"$nulls":3},{"v":22,"d":"22.00"},{"v":21,"d":"21.00"}]
[null,"Number of Calls Made",{"$nulls":3},{"v":100,"d":"100 "},{"v":110,"d":"110 "}]
[null,"Average Calls Per Day",{"$nulls":3},{"$f":"IF(F23,F24/F23,\"\")","v":{"v":4.545454545454546,"d":"4.5"}},{"$f":"IF(G23,G24/G23,\"\")","v":{"v":5.238095238095238,"d":"5.2"}}]
[null,"Number of New Accounts",{"$nulls":3},{"v":10,"d":"10 "},{"v":12,"d":"12 "}]
[null,"Number of Accounts Lost",{"$nulls":3},{"v":3,"d":"3 "},{"v":4,"d":"4 "}]
[null,"Number of Accounts at Period End",{"$nulls":3},{"v":96,"d":"96 "},{"v":97,"d":"97 "}]
[null,"Number of Potential Accounts",{"$nulls":3},{"v":43,"d":"43 "},{"v":1500,"d":"1,500 "}]