{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Pipeline Input","Pipeline Calculations","Pipeline Totals"],"not_rendered":{"charts":1,"images":2,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Pipeline Totals","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pipeline Input","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Detailed Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Enter values into the white and yellow cells only."]
["Opportunity\nName","Customer\nContact","Sales\nRegion","Lead\nSource","Sales\nCategory","Forecast\nAmount","Sales\nPhase","Forecast\nClose"]
["A. Datum Corporation","Kim Abercrombie","US - Northeast","Web Inquiry","Consulting",{"v":150000,"d":"$150,000"},"Contact","January"]
["Adventure Works","Angela Barbariol","US - Southeast","E-Mail","Products",{"v":145200,"d":"$145,200"},"Lead","February"]
["Alpine Ski House","Gabriele Cannata","US - North Central","Partner","Training",{"v":162500,"d":"$162,500"},"Qualified Lead","March"]
["Baldwin Museum of Science","Barbara S. Decker","US - South Central","Customer Reference","Mixture",{"v":147500,"d":"$147,500"},"Opportunity","April"]
["Blue Yonder Airlines","Susan W. Eaton","US - Northwest","Web Event","Prof. Services",{"v":148000,"d":"$148,000"},"Executive Sponsorship","May"]
["City Power & Light","Kathie Flood","US - Southwest","Conference","Support",{"v":175000,"d":"$175,000"},"Proposal Discussed","June"]
["Coho Vineyard","Janice Galvin","Canada - East","E-Mail","Mixture",{"v":149000,"d":"$149,000"},"Written Proposal","July"]
["Coho Winery","Adina Hagege","Canada - West","Partner","Training",{"v":142000,"d":"$142,000"},"Contract","August"]
["Coho Vineyard & Winery","Shu Ito","EMEA - UK","Customer Reference","Consulting",{"v":189900,"d":"$189,900"},"Purchase Order","September"]
["Contoso, Ltd.","David Jaffe","EMEA - France","Conference","Mixture",{"v":172500,"d":"$172,500"},"Invoice","October"]
["Contoso Pharmaceuticals","Sandeep Kaliyath","EMEA - Germany","E-Mail","Products",{"v":163500,"d":"$163,500"},"Payment","November"]
["Consolidated Messenger","Rebecca Laszlo","EMEA - Italy","Customer Reference","Products",{"v":155500,"d":"$155,500"},"Acceptance","December"]
["Fabrikam, Inc.","Diane Margheim","EMEA - Other","Conference","Consulting",{"v":166000,"d":"$166,000"},"Executive Sponsorship","January"]
["Fourth Coffee","Paula Nartker","APSA - Asia","E-Mail","Training",{"v":180000,"d":"$180,000"},"Invoice","March"]
["Graphic Design Institute","Robert O'Hara","APSA - Pacific","Web Inquiry","Services",{"v":140000,"d":"$140,000"},"Contract","May"]
["Humongous Insurance","Carol Philips","APSA - Mexico","Web Event","Support",{"v":155000,"d":"$155,000"},"Qualified Lead","June"]
["Litware, Inc.","Kim Ralls","APSA - Australia","Web Inquiry","Prof. Services",{"v":173200,"d":"$173,200"},"Lead","October"]
["Lucerne Publishing","Sharon Salavaria","APSA - Other","Partner","Services",{"v":146500,"d":"$146,500"},"Contact","December"]
["Margie's Travel","Andy Teal","US - Northeast","E-Mail","Support",{"v":156750,"d":"$156,750"},"Payment","November"]
["Northwind Traders","Sunil Uppal","US - South Central","Conference","Prof. Services",{"v":162000,"d":"$162,000"},"Written Proposal","February"]
["Proseware, Inc.","H. Brian Valentine","Canada - East","Customer Reference","Mixture",{"v":157000,"d":"$157,000"},"Opportunity","March"]
["School of Fine Art","Robert Walters","EMEA - France","Web Inquiry","Services",{"v":173000,"d":"$173,000"},"Executive Sponsorship","April"]
["TOTAL",{"$nulls":4},{"v":3510050,"d":"$3,510,050"}]

{"sheet":"Pipeline Calculations","index":1,"n_rows":29,"n_cols":14,"rows_kept":29,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Detailed Sales Pipeline Management"]
["Company Confidential"]
[]
["Probability\nof Sale","January\nForecast","February\nForecast","March\nForecast","April\nForecast","May\nForecast","June\nForecast","July\nForecast","August\nForecast","September\nForecast","October\nForecast","November\nForecast","December\nForecast","Weighted\nForecast"]
[{"v":0.9,"d":"90%"},{"v":135000,"d":"$135,000"},0,0,0,0,0,0,0,0,0,0,0,{"v":135000,"d":"$135,000"}]
[{"v":0.1,"d":"10%"},0,{"v":14520,"d":"$14,520"},0,0,0,0,0,0,0,0,0,0,{"v":14520,"d":"$14,520"}]
[{"v":0.2,"d":"20%"},0,0,{"v":32500,"d":"$32,500"},0,0,0,0,0,0,0,0,0,{"v":32500,"d":"$32,500"}]
[{"v":0.3,"d":"30%"},0,0,0,{"v":44250,"d":"$44,250"},0,0,0,0,0,0,0,0,{"v":44250,"d":"$44,250"}]
[{"v":0.4,"d":"40%"},0,0,0,0,{"v":59200,"d":"$59,200"},0,0,0,0,0,0,0,{"v":59200,"d":"$59,200"}]
[{"v":0.5,"d":"50%"},0,0,0,0,0,{"v":87500,"d":"$87,500"},0,0,0,0,0,0,{"v":87500,"d":"$87,500"}]
[{"v":0.6,"d":"60%"},0,0,0,0,0,0,{"v":89400,"d":"$89,400"},0,0,0,0,0,{"v":89400,"d":"$89,400"}]
[{"v":0.7,"d":"70%"},0,0,0,0,0,0,0,{"v":99400,"d":"$99,400"},0,0,0,0,{"v":99400,"d":"$99,400"}]
[{"v":0.8,"d":"80%"},0,0,0,0,0,0,0,0,{"v":151920,"d":"$151,920"},0,0,0,{"v":151920,"d":"$151,920"}]
[{"v":0.9,"d":"90%"},0,0,0,0,0,0,0,0,0,{"v":155250,"d":"$155,250"},0,0,{"v":155250,"d":"$155,250"}]
[{"v":0.2,"d":"20%"},0,0,0,0,0,0,0,0,0,0,{"v":32700,"d":"$32,700"},0,{"v":32700,"d":"$32,700"}]
[{"v":1,"d":"100%"},0,0,0,0,0,0,0,0,0,0,0,{"v":155500,"d":"$155,500"},{"v":155500,"d":"$155,500"}]
[{"v":0.1,"d":"10%"},{"v":16600,"d":"$16,600"},0,0,0,0,0,0,0,0,0,0,0,{"v":16600,"d":"$16,600"}]
[{"v":0.3,"d":"30%"},0,0,{"v":54000,"d":"$54,000"},0,0,0,0,0,0,0,0,0,{"v":54000,"d":"$54,000"}]
[{"v":0.6,"d":"60%"},0,0,0,0,{"v":84000,"d":"$84,000"},0,0,0,0,0,0,0,{"v":84000,"d":"$84,000"}]
[{"v":0.3,"d":"30%"},0,0,0,0,0,{"v":46500,"d":"$46,500"},0,0,0,0,0,0,{"v":46500,"d":"$46,500"}]
[{"v":0.5,"d":"50%"},0,0,0,0,0,0,0,0,0,{"v":86600,"d":"$86,600"},0,0,{"v":86600,"d":"$86,600"}]
[{"v":0.6,"d":"60%"},0,0,0,0,0,0,0,0,0,0,0,{"v":87900,"d":"$87,900"},{"v":87900,"d":"$87,900"}]
[{"v":0.7,"d":"70%"},0,0,0,0,0,0,0,0,0,0,{"v":109725,"d":"$109,725"},0,{"v":109725,"d":"$109,725"}]
[{"v":0.9,"d":"90%"},0,{"v":145800,"d":"$145,800"},0,0,0,0,0,0,0,0,0,0,{"v":145800,"d":"$145,800"}]
[{"v":1,"d":"100%"},0,0,{"v":157000,"d":"$157,000"},0,0,0,0,0,0,0,0,0,{"v":157000,"d":"$157,000"}]
[{"v":0.4,"d":"40%"},0,0,0,{"v":69200,"d":"$69,200"},0,0,0,0,0,0,0,0,{"v":69200,"d":"$69,200"}]
["Monthly Total",{"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":99400,"d":"$99,400"},{"v":151920,"d":"$151,920"},{"v":241850,"d":"$241,850"},{"v":142425,"d":"$142,425"},{"v":243400,"d":"$243,400"}]
["Cumulative",{"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":1134870,"d":"$1,134,870"},{"v":1286790,"d":"$1,286,790"},{"v":1528640,"d":"$1,528,640"},{"v":1671065,"d":"$1,671,065"},{"v":1914465,"d":"$1,914,465"}]