{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Pipeline Input","Pipeline Calculations","Pipeline Totals"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Pipeline Totals","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pipeline Input","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"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",150000,"Contact","January"]
["Adventure Works","Angela Barbariol","US - Southeast","E-Mail","Products",145200,"Lead","February"]
["Alpine Ski House","Gabriele Cannata","US - North Central","Partner","Training",162500,"Qualified Lead","March"]
["Baldwin Museum of Science","Barbara S. Decker","US - South Central","Customer Reference","Mixture",147500,"Opportunity","April"]
["Blue Yonder Airlines","Susan W. Eaton","US - Northwest","Web Event","Prof. Services",148000,"Executive Sponsorship","May"]
["City Power & Light","Kathie Flood","US - Southwest","Conference","Support",175000,"Proposal Discussed","June"]
["Coho Vineyard","Janice Galvin","Canada - East","E-Mail","Mixture",149000,"Written Proposal","July"]
["Coho Winery","Adina Hagege","Canada - West","Partner","Training",142000,"Contract","August"]
["Coho Vineyard & Winery","Shu Ito","EMEA - UK","Customer Reference","Consulting",189900,"Purchase Order","September"]
["Contoso, Ltd.","David Jaffe","EMEA - France","Conference","Mixture",172500,"Invoice","October"]
["Contoso Pharmaceuticals","Sandeep Kaliyath","EMEA - Germany","E-Mail","Products",163500,"Payment","November"]
["Consolidated Messenger","Rebecca Laszlo","EMEA - Italy","Customer Reference","Products",155500,"Acceptance","December"]
["Fabrikam, Inc.","Diane Margheim","EMEA - Other","Conference","Consulting",166000,"Executive Sponsorship","January"]
["Fourth Coffee","Paula Nartker","APSA - Asia","E-Mail","Training",180000,"Invoice","March"]
["Graphic Design Institute","Robert O'Hara","APSA - Pacific","Web Inquiry","Services",140000,"Contract","May"]
["Humongous Insurance","Carol Philips","APSA - Mexico","Web Event","Support",155000,"Qualified Lead","June"]
["Litware, Inc.","Kim Ralls","APSA - Australia","Web Inquiry","Prof. Services",173200,"Lead","October"]
["Lucerne Publishing","Sharon Salavaria","APSA - Other","Partner","Services",146500,"Contact","December"]
["Margie's Travel","Andy Teal","US - Northeast","E-Mail","Support",156750,"Payment","November"]
["Northwind Traders","Sunil Uppal","US - South Central","Conference","Prof. Services",162000,"Written Proposal","February"]
["Proseware, Inc.","H. Brian Valentine","Canada - East","Customer Reference","Mixture",157000,"Opportunity","March"]
["School of Fine Art","Robert Walters","EMEA - France","Web Inquiry","Services",173000,"Executive Sponsorship","April"]
["TOTAL",null,null,null,null,3510050]

{"sheet":"Pipeline Calculations","index":1,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"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"]
[0.9,135000,0,0,0,0,0,0,0,0,0,0,0,135000]
[0.1,0,14520,0,0,0,0,0,0,0,0,0,0,14520]
[0.2,0,0,32500,0,0,0,0,0,0,0,0,0,32500]
[0.3,0,0,0,44250,0,0,0,0,0,0,0,0,44250]
[0.4,0,0,0,0,59200,0,0,0,0,0,0,0,59200]
[0.5,0,0,0,0,0,87500,0,0,0,0,0,0,87500]
[0.6,0,0,0,0,0,0,89400,0,0,0,0,0,89400]
[0.7,0,0,0,0,0,0,0,99400,0,0,0,0,99400]
[0.8,0,0,0,0,0,0,0,0,151920,0,0,0,151920]
[0.9,0,0,0,0,0,0,0,0,0,155250,0,0,155250]
[0.2,0,0,0,0,0,0,0,0,0,0,32700,0,32700]
[1,0,0,0,0,0,0,0,0,0,0,0,155500,155500]
[0.1,16600,0,0,0,0,0,0,0,0,0,0,0,16600]
[0.3,0,0,54000,0,0,0,0,0,0,0,0,0,54000]
[0.6,0,0,0,0,84000,0,0,0,0,0,0,0,84000]
[0.3,0,0,0,0,0,46500,0,0,0,0,0,0,46500]
[0.5,0,0,0,0,0,0,0,0,0,86600,0,0,86600]
[0.6,0,0,0,0,0,0,0,0,0,0,0,87900,87900]
[0.7,0,0,0,0,0,0,0,0,0,0,109725,0,109725]
[0.9,0,145800,0,0,0,0,0,0,0,0,0,0,145800]
[1,0,0,157000,0,0,0,0,0,0,0,0,0,157000]
[0.4,0,0,0,69200,0,0,0,0,0,0,0,0,69200]
["Monthly Total",151600,160320,243500,113450,143200,134000,89400,99400,151920,241850,142425,243400]
["Cumulative",151600,311920,555420,668870,812070,946070,1035470,1134870,1286790,1528640,1671065,1914465]