{"text_format":"1","workbook":"xls","n_sheets":4,"sheets":["Pipeline Details","Phase Calculations","Pipeline Chart","Phase Chart"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Pipeline Chart","index":2,"reason":"not_a_worksheet"},{"sheet":"Phase Chart","index":3,"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 Details","index":0,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Solution Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Enter data into the white and yellow cells only."]
["Potential\nSolution","Customer\nContact","Pipeline\nStage","Forecast\nClose","Potential Opportunity","Q1 Weighted\nForecast","Q2 Weighted\nForecast","Q3 Weighted\nForecast","Q4 Weighted\nForecast","Weighted\nForecast","Chance\nof Sale","Internal\nCalculation","Internal\nCalculation"]
["A. Datum Corporation","Kim Abercrombie","Contact","Q1",300000,30000,0,0,0,30000,0.1,0.1,-1]
["Adventure Works","Angela Barbariol","Lead","Q1",200000,40000,0,0,0,40000,0.2,0.2,-1]
["Alpine Ski House","Gabriele Cannata","Qualified Lead","Q1",100000,30000,0,0,0,30000,0.3,0.3,-1]
["Baldwin Museum of Science","Barbara S. Decker","Opportunity","Q2",500000,0,200000,0,0,200000,0.4,0.4,-1]
["Blue Yonder Airlines","Susan W. Eaton","Executive Sponsorship","Q2",400000,0,200000,0,0,200000,0.5,0.5,-1]
["City Power & Light","Kathie Flood","Proposal Discussed","Q2",300000,0,180000,0,0,180000,0.6,-1,0.6]
["Coho Vineyard","Janice Galvin","Negotiation Phase","Q3",200000,0,0,140000,0,140000,0.7,-1,0.7]
["Coho Winery","Adina Hagege","Verbal Approval","Q3",100000,0,0,80000,0,80000,0.8,-1,0.8]
["Coho Vineyard & Winery","Shu Ito","Contract","Q3",500000,0,0,450000,0,450000,0.9,-1,0.9]
["Contoso, Ltd.","David Jaffe","Purchase Order","Q4",300000,0,0,0,300000,300000,1,-1,1]
["Contoso Pharmaceuticals","Sandeep Kaliyath","Contact","Q4",400000,0,0,0,40000,40000,0.1,0.1,-1]
["Consolidated Messenger","Rebecca Laszlo","Lead","Q4",200000,0,0,0,40000,40000,0.2,0.2,-1]
["Fabrikam, Inc.","Diane Margheim","Qualified Lead","Q1",100000,30000,0,0,0,30000,0.3,0.3,-1]
["Fourth Coffee","Paula Nartker","Opportunity","Q1",200000,80000,0,0,0,80000,0.4,0.4,-1]
["Graphic Design Institute","Robert O'Hara","Executive Sponsorship","Q2",300000,0,150000,0,0,150000,0.5,0.5,-1]
["Humongous Insurance","Carol Philips","Proposal Discussed","Q2",300000,0,180000,0,0,180000,0.6,-1,0.6]
["Litware, Inc.","Kim Ralls","Negotiation Phase","Q4",400000,0,0,0,280000,280000,0.7,-1,0.7]
["Lucerne Publishing","Sharon Salavaria","Verbal Approval","Q4",200000,0,0,0,160000,160000,0.8,-1,0.8]
["Margie's Travel","Andy Teal","Contact","Q4",500000,0,0,0,50000,50000,0.1,0.1,-1]
["Northwind Traders","Sunil Uppal","Executive Sponsorship","Q2",300000,0,150000,0,0,150000,0.5,0.5,-1]
["Proseware, Inc.","H. Brian Valentine","Proposal Discussed","Q2",200000,0,120000,0,0,120000,0.6,-1,0.6]
["School of Fine Art","Robert Walters","Contract","Q3",200000,0,0,180000,0,180000,0.9,-1,0.9]
["TOTAL",null,null,null,6200000,210000,1180000,850000,870000,3110000]
[null,null,null,null,null,210000,1390000,2240000,3110000]

{"sheet":"Phase Calculations","index":1,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Solution Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Adjust the column headings to match your sales phase names."]
["Contact","Lead","Qualified Lead","Opportunity","Executive Sponsorship","Proposal Discussed","Negotiation Phase","Verbal Approval","Contract","Purchase Order"]
[30000,0,0,0,0,0,0,0,0,0]
[0,40000,0,0,0,0,0,0,0,0]
[0,0,30000,0,0,0,0,0,0,0]
[0,0,0,200000,0,0,0,0,0,0]
[0,0,0,0,200000,0,0,0,0,0]
[0,0,0,0,0,180000,0,0,0,0]
[0,0,0,0,0,0,140000,0,0,0]
[0,0,0,0,0,0,0,80000,0,0]
[0,0,0,0,0,0,0,0,450000,0]
[0,0,0,0,0,0,0,0,0,300000]
[40000,0,0,0,0,0,0,0,0,0]
[0,40000,0,0,0,0,0,0,0,0]
[0,0,30000,0,0,0,0,0,0,0]
[0,0,0,80000,0,0,0,0,0,0]
[0,0,0,0,150000,0,0,0,0,0]
[0,0,0,0,0,180000,0,0,0,0]
[0,0,0,0,0,0,280000,0,0,0]
[0,0,0,0,0,0,0,160000,0,0]
[50000,0,0,0,0,0,0,0,0,0]
[0,0,0,0,150000,0,0,0,0,0]
[0,0,0,0,0,120000,0,0,0,0]
[0,0,0,0,0,0,0,0,180000,0]
[120000,80000,60000,280000,500000,480000,420000,240000,630000,300000]