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

{"sheet":"Price Line Sales Projections","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[25,1,25,11]]}
[]
[]
[null,"Product Line Sales Projections"]
[null,"For July, 2009"]
[]
[]
[{"$nulls":3},"MONTH",null,null,"YEAR TO DATE",null,null,"ESTIMATED YEAR END"]
[null," Product Line",null,"Forecast","Actual","Variance","Forecast","Actual","Variance","Forecast","Actual","Variance"]
[null,"Product",null,{"v":24000,"d":"$24,000"},{"v":21870,"d":"$21,870"},{"$f":"IF(OR(D9>0,E9),+E9-D9,\"\")","v":{"v":-2130,"d":"($2,130)"}},{"v":237000,"d":"$237,000"},{"v":231543,"d":"$231,543"},{"$f":"IF(OR(G9>0,H9),+H9-G9,\"\")","v":{"v":-5457,"d":"($5,457)"}},{"v":310000,"d":"$310,000"},{"v":300000,"d":"$300,000"},{"$f":"IF(OR(J9>0,K9),+K9-J9,\"\")","v":{"v":-10000,"d":"($10,000)"}}]
[null,"Product",null,{"v":18000,"d":"18,000 "},{"v":17145,"d":"17,145 "},{"v":-855,"d":"(855)"},{"v":157500,"d":"157,500 "},{"v":162304,"d":"162,304 "},{"v":4804,"d":"4,804 "},{"v":205000,"d":"205,000 "},{"v":210000,"d":"210,000 "},{"v":5000,"d":"5,000 "}]
[null,"Product",null,{"v":6800,"d":"6,800 "},{"v":9480,"d":"9,480 "},{"v":2680,"d":"2,680 "},{"v":76500,"d":"76,500 "},{"v":82130,"d":"82,130 "},{"v":5630,"d":"5,630 "},{"v":100000,"d":"100,000 "},{"v":107000,"d":"107,000 "},{"v":7000,"d":"7,000 "}]
[null,"Product",null,{"v":37500,"d":"37,500 "},{"v":42066,"d":"42,066 "},{"v":4566,"d":"4,566 "},{"v":423000,"d":"423,000 "},{"v":456205,"d":"456,205 "},{"v":33205,"d":"33,205 "},{"v":550000,"d":"550,000 "},{"v":585000,"d":"585,000 "},{"v":35000,"d":"35,000 "}]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[{"$nulls":5},"",null,null,"",null,null,""]
[null,"Totals",null,{"$f":"IF(SUM(D9:D22),SUM(D9:D22),\"\")","v":{"v":86300,"d":"$86,300"}},{"v":90561,"d":"$90,561"},{"v":4261,"d":"$4,261"},{"v":894000,"d":"$894,000"},{"v":932182,"d":"$932,182"},{"v":38182,"d":"$38,182"},{"v":1165000,"d":"$1,165,000"},{"v":1202000,"d":"$1,202,000"},{"v":37000,"d":"$37,000"}]