{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Forecast Input","Forecast Totals","Forecast Graph"],"not_rendered":{"charts":1,"images":3,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Forecast Input","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]
[]
["  Instructions: Enter values into the white and yellow cells only."]
["Opportunity\nName","Sales\nAgent","Sales\nRegion","Sales\nCategory","Forecast\nAmount","Sales\nPhase","Probability\nof Sale","Forecast\nClose","Weighted\nForecast"]
["A. Datum Corporation"," Sales Agent 1","US - Northeast","Consulting",{"v":150000,"d":"$150,000"},"Formal Approval",{"v":0.9,"d":"90%"},"January",{"v":135000,"d":"$135,000"}]
["Adventure Works"," Sales Agent 2","US - Southeast","Products",{"v":145200,"d":"$145,200"},"Opportunity",{"v":0.1,"d":"10%"},"February",{"v":14520,"d":"$14,520"}]
["Alpine Ski House"," Sales Agent 3","US - North Central","Training",{"v":162500,"d":"$162,500"},"Identified Need",{"v":0.2,"d":"20%"},"March",{"v":32500,"d":"$32,500"}]
["Baldwin Museum of Science"," Sales Agent 4","US - South Central","Mixture",{"v":147500,"d":"$147,500"},"Sponsorship",{"v":0.3,"d":"30%"},"April",{"v":44250,"d":"$44,250"}]
["Blue Yonder Airlines"," Sales Agent 5","US - Northwest","Prof. Services",{"v":148000,"d":"$148,000"},"Budget Validated",{"v":0.4,"d":"40%"},"May",{"v":59200,"d":"$59,200"}]
["City Power & Light"," Sales Agent 1","US - Southwest","Support",{"v":175000,"d":"$175,000"},"Needs Analysis",{"v":0.5,"d":"50%"},"June",{"v":87500,"d":"$87,500"}]
["Coho Vineyard"," Sales Agent 3","Canada - East","Mixture",{"v":149000,"d":"$149,000"},"Solution Proposed",{"v":0.6,"d":"60%"},"July",{"v":89400,"d":"$89,400"}]
["Coho Winery"," Sales Agent 5","Canada - West","Training",{"v":142000,"d":"$142,000"},"Written Proposal",{"v":0.7,"d":"70%"},"August",{"v":99400,"d":"$99,400"}]
["Contoso, Ltd."," Sales Agent 3","EMEA - France","Mixture",{"v":172500,"d":"$172,500"},"Verbal Approval",{"v":0.9,"d":"90%"},"October",{"v":155250,"d":"$155,250"}]
["Contoso Pharmaceuticals"," Sales Agent 4","EMEA - Germany","Products",{"v":163500,"d":"$163,500"},"Sponsorship",{"v":0.2,"d":"20%"},"November",{"v":32700,"d":"$32,700"}]
["Consolidated Messenger"," Sales Agent 5","EMEA - Italy","Products",{"v":155500,"d":"$155,500"},"Formal Approval",{"v":1,"d":"100%"},"December",{"v":155500,"d":"$155,500"}]
["Fabrikam, Inc."," Sales Agent 4","EMEA - Other","Consulting",{"v":166000,"d":"$166,000"},"Opportunity",{"v":0.1,"d":"10%"},"January",{"v":16600,"d":"$16,600"}]
["Fourth Coffee"," Sales Agent 3","APSA - Asia","Training",{"v":180000,"d":"$180,000"},"Budget Validated",{"v":0.3,"d":"30%"},"March",{"v":54000,"d":"$54,000"}]
["Graphic Design Institute"," Sales Agent 2","APSA - Pacific","Services",{"v":140000,"d":"$140,000"},"Solution Proposed",{"v":0.6,"d":"60%"},"May",{"v":84000,"d":"$84,000"}]
["Humongous Insurance"," Sales Agent 1","APSA - Mexico","Support",{"v":155000,"d":"$155,000"},"Sponsorship",{"v":0.3,"d":"30%"},"June",{"v":46500,"d":"$46,500"}]
["Litware, Inc."," Sales Agent 2","APSA - Australia","Prof. Services",{"v":173200,"d":"$173,200"},"Needs Analysis",{"v":0.5,"d":"50%"},"October",{"v":86600,"d":"$86,600"}]
["Lucerne Publishing"," Sales Agent 5","APSA - Other","Services",{"v":146500,"d":"$146,500"},"Solution Proposed",{"v":0.6,"d":"60%"},"December",{"v":87900,"d":"$87,900"}]
["Margie's Travel"," Sales Agent 4","US - Northeast","Support",{"v":156750,"d":"$156,750"},"Written Proposal",{"v":0.7,"d":"70%"},"November",{"v":109725,"d":"$109,725"}]
["Northwind Traders"," Sales Agent 3","US - South Central","Prof. Services",{"v":162000,"d":"$162,000"},"Verbal Approval",{"v":0.9,"d":"90%"},"February",{"v":145800,"d":"$145,800"}]
["Proseware, Inc."," Sales Agent 4","Canada - East","Mixture",{"v":157000,"d":"$157,000"},"Formal Approval",{"v":1,"d":"100%"},"March",{"v":157000,"d":"$157,000"}]
["School of Fine Art"," Sales Agent 3","EMEA - France","Services",{"v":173000,"d":"$173,000"},"Budget Validated",{"v":0.4,"d":"40%"},"April",{"v":69200,"d":"$69,200"}]
["Southridge Video"," Sales Agent 5","EMEA - UK","Mixture",{"v":171000,"d":"$171,000"},"Needs Analysis",{"v":0.5,"d":"50%"},"August",{"v":85500,"d":"$85,500"}]
["Tailspin Toys"," Sales Agent 1","APSA - Australia","Products",{"v":168000,"d":"$168,000"},"Solution Proposed",{"v":0.6,"d":"60%"},"September",{"v":100800,"d":"$100,800"}]
["TOTAL",{"$nulls":3},{"v":3659150,"d":"$3,659,150"},{"$nulls":3},{"v":1948845,"d":"$1,948,845"}]

{"sheet":"Forecast Totals","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]
[]
[]
["January\nForecast","February\nForecast","March\nForecast","April\nForecast","May\nForecast","June\nForecast","July\nForecast","August\nForecast","September\nForecast","October\nForecast","November\nForecast","December\nForecast"]
[{"v":135000,"d":"$135,000"},0,0,0,0,0,0,0,0,0,0,0]
[0,{"v":14520,"d":"$14,520"},0,0,0,0,0,0,0,0,0,0]
[0,0,{"v":32500,"d":"$32,500"},0,0,0,0,0,0,0,0,0]
[0,0,0,{"v":44250,"d":"$44,250"},0,0,0,0,0,0,0,0]
[0,0,0,0,{"v":59200,"d":"$59,200"},0,0,0,0,0,0,0]
[0,0,0,0,0,{"v":87500,"d":"$87,500"},0,0,0,0,0,0]
[0,0,0,0,0,0,{"v":89400,"d":"$89,400"},0,0,0,0,0]
[0,0,0,0,0,0,0,{"v":99400,"d":"$99,400"},0,0,0,0]
[0,0,0,0,0,0,0,0,0,{"v":155250,"d":"$155,250"},0,0]
[0,0,0,0,0,0,0,0,0,0,{"v":32700,"d":"$32,700"},0]
[0,0,0,0,0,0,0,0,0,0,0,{"v":155500,"d":"$155,500"}]
[{"v":16600,"d":"$16,600"},0,0,0,0,0,0,0,0,0,0,0]
[0,0,{"v":54000,"d":"$54,000"},0,0,0,0,0,0,0,0,0]
[0,0,0,0,{"v":84000,"d":"$84,000"},0,0,0,0,0,0,0]
[0,0,0,0,0,{"v":46500,"d":"$46,500"},0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,{"v":86600,"d":"$86,600"},0,0]
[0,0,0,0,0,0,0,0,0,0,0,{"v":87900,"d":"$87,900"}]
[0,0,0,0,0,0,0,0,0,0,{"v":109725,"d":"$109,725"},0]
[0,{"v":145800,"d":"$145,800"},0,0,0,0,0,0,0,0,0,0]
[0,0,{"v":157000,"d":"$157,000"},0,0,0,0,0,0,0,0,0]
[0,0,0,{"v":69200,"d":"$69,200"},0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,{"v":85500,"d":"$85,500"},0,0,0,0]
[0,0,0,0,0,0,0,0,{"v":100800,"d":"$100,800"},0,0,0]
[{"v":151600,"d":"$151,600"},{"v":160320,"d":"$160,320"},{"v":243500,"d":"$243,500"},{"v":113450,"d":"$113,450"},{"v":143200,"d":"$143,200"},{"v":134000,"d":"$134,000"},{"v":89400,"d":"$89,400"},{"v":184900,"d":"$184,900"},{"v":100800,"d":"$100,800"},{"v":241850,"d":"$241,850"},{"v":142425,"d":"$142,425"},{"v":243400,"d":"$243,400"}]
[{"v":151600,"d":"$151,600"},{"v":311920,"d":"$311,920"},{"v":555420,"d":"$555,420"},{"v":668870,"d":"$668,870"},{"v":812070,"d":"$812,070"},{"v":946070,"d":"$946,070"},{"v":1035470,"d":"$1,035,470"},{"v":1220370,"d":"$1,220,370"},{"v":1321170,"d":"$1,321,170"},{"v":1563020,"d":"$1,563,020"},{"v":1705445,"d":"$1,705,445"},{"v":1948845,"d":"$1,948,845"}]

{"sheet":"Forecast Graph","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]