{"text_format":"1","workbook":"xls","n_sheets":7,"sheets":["Pipeline Input","Month Calculations","Region Calculations","Lead Calculations","Month Totals","Region Totals","Source Totals"],"not_rendered":{"charts":3,"images":4,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Month Totals","index":4,"reason":"not_a_worksheet"},{"sheet":"Region Totals","index":5,"reason":"not_a_worksheet"},{"sheet":"Source Totals","index":6,"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>  "]
["Strategic Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Enter values into the white and yellow cells only."]
["Opportunity\nName","Customer\nContact","Sales\nRegion","Lead\nSource","Product\nLine","Forecast\nAmount","Sales\nPhase","Forecast\nClose"]
["A. Datum Corporation","Kim Abercrombie","US - Northeast","Web Inquiry","Product Line A",150000,"Contact","January"]
["Adventure Works","Angela Barbariol","US - Southeast","E-Mail","Product Line B",145200,"Lead","February"]
["Alpine Ski House","Gabriele Cannata","US - North Central","Partner","Product Line C",162500,"Qualified Lead","March"]
["Baldwin Museum of Science","Barbara S. Decker","US - South Central","Customer Reference","Product Line E",147500,"Opportunity","April"]
["Blue Yonder Airlines","Susan W. Eaton","US - Northwest","Web Event","Product Line D",148000,"Executive Sponsorship","May"]
["City Power & Light","Kathie Flood","US - Southwest","Trade Show","Product Line A",175000,"Written Proposal","June"]
["Coho Vineyard","Janice Galvin","Canada - East","E-Mail","Product Line E",149000,"Negotiation Phase","July"]
["Coho Winery","Adina Hagege","Canada - West","Partner","Product Line A",142000,"Verbal Approval","August"]
["Coho Vineyard & Winery","Shu Ito","US - Northeast","Customer Reference","Product Line B",189900,"Contract","September"]
["Contoso, Ltd.","David Jaffe","US - Southwest","Trade Show","Product Line D",172500,"Purchase Order","October"]
["Contoso Pharmaceuticals","Sandeep Kaliyath","US - Northeast","E-Mail","Product Line A",163500,"Invoice","November"]
["Consolidated Messenger","Rebecca Laszlo","US - Southwest","Customer Reference","Product Line D",155500,"Payment","December"]
["Fabrikam, Inc.","Diane Margheim","US - Northwest","Trade Show","Product Line A",166000,"Acceptance","January"]
["Fourth Coffee","Paula Nartker","US - Northeast","E-Mail","Product Line C",180000,"Contact","March"]
["Graphic Design Institute","Robert O'Hara","US - Southeast","Web Inquiry","Product Line A",140000,"Lead","May"]
["Humongous Insurance","Carol Philips","US - Southwest","Web Event","Product Line E",155000,"Qualified Lead","June"]
["Litware, Inc.","Kim Ralls","US - North Central","Web Inquiry","Product Line A",173200,"Executive Sponsorship","October"]
["Lucerne Publishing","Sharon Salavaria","US - Northeast","Partner","Product Line C",146500,"Written Proposal","December"]
["Margie's Travel","Andy Teal","US - South Central","E-Mail","Product Line B",156750,"Invoice","November"]
["Northwind Traders","Sunil Uppal","US - Southeast","Trade Show","Product Line B",162000,"Payment","February"]
["Proseware, Inc.","H. Brian Valentine","US - Southwest","Customer Reference","Product Line E",157000,"Acceptance","March"]
["School of Fine Art","Robert Walters","US - Northwest","Web Inquiry","Product Line D",173000,"Negotiation Phase","April"]
["TOTAL",null,null,null,null,3510050]

{"sheet":"Month Calculations","index":1,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Strategic 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","Internal\nCalculation","Internal\nCalculation"]
[0.1,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0.1,-1]
[0.2,0,29040,0,0,0,0,0,0,0,0,0,0,29040,0.2,-1]
[0.3,0,0,48750,0,0,0,0,0,0,0,0,0,48750,0.3,-1]
[0.4,0,0,0,59000,0,0,0,0,0,0,0,0,59000,0.4,-1]
[0.5,0,0,0,0,74000,0,0,0,0,0,0,0,74000,0.5,-1]
[0.6,0,0,0,0,0,105000,0,0,0,0,0,0,105000,0.6,-1]
[0.7,0,0,0,0,0,0,104300,0,0,0,0,0,104300,0.7,-1]
[0.75,0,0,0,0,0,0,0,106500,0,0,0,0,106500,-1,0.75]
[0.8,0,0,0,0,0,0,0,0,151920,0,0,0,151920,-1,0.8]
[0.85,0,0,0,0,0,0,0,0,0,146625,0,0,146625,-1,0.85]
[0.9,0,0,0,0,0,0,0,0,0,0,147150,0,147150,-1,0.9]
[0.95,0,0,0,0,0,0,0,0,0,0,0,147725,147725,-1,0.95]
[0.1,16600,0,0,0,0,0,0,0,0,0,0,0,16600,-1,0.1]
[0.1,0,0,18000,0,0,0,0,0,0,0,0,0,18000,0.1,-1]
[0.2,0,0,0,0,28000,0,0,0,0,0,0,0,28000,0.2,-1]
[0.3,0,0,0,0,0,46500,0,0,0,0,0,0,46500,0.3,-1]
[0.5,0,0,0,0,0,0,0,0,0,86600,0,0,86600,0.5,-1]
[0.6,0,0,0,0,0,0,0,0,0,0,0,87900,87900,0.6,-1]
[0.9,0,0,0,0,0,0,0,0,0,0,141075,0,141075,-1,0.9]
[0.95,0,153900,0,0,0,0,0,0,0,0,0,0,153900,-1,0.95]
[0.1,0,0,15700,0,0,0,0,0,0,0,0,0,15700,-1,0.1]
[0.7,0,0,0,121099.99999999999,0,0,0,0,0,0,0,0,121099.99999999999,0.7,-1]
["Monthly Total",31600,182940,82450,180100,102000,151500,104300,106500,151920,233225,288225,235625]
["Cumulative",31600,214540,296990,477090,579090,730590,834890,941390,1093310,1326535,1614760,1850385]

{"sheet":"Region Calculations","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Strategic Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Adjust the column headings to match your region names."]
["US - Northeast","US - Southeast","US - North Central","US - South Central","US - Northwest","US - Southwest","Canada - East","Canada - West"]
[15000,0,0,0,0,0,0,0]
[0,29040,0,0,0,0,0,0]
[0,0,48750,0,0,0,0,0]
[0,0,0,59000,0,0,0,0]
[0,0,0,0,74000,0,0,0]
[0,0,0,0,0,105000,0,0]
[0,0,0,0,0,0,104300,0]
[0,0,0,0,0,0,0,106500]
[151920,0,0,0,0,0,0,0]
[0,0,0,0,0,146625,0,0]
[147150,0,0,0,0,0,0,0]
[0,0,0,0,0,147725,0,0]
[0,0,0,0,16600,0,0,0]
[18000,0,0,0,0,0,0,0]
[0,28000,0,0,0,0,0,0]
[0,0,0,0,0,46500,0,0]
[0,0,86600,0,0,0,0,0]
[87900,0,0,0,0,0,0,0]
[0,0,0,141075,0,0,0,0]
[0,153900,0,0,0,0,0,0]
[0,0,0,0,0,15700,0,0]
[0,0,0,0,121099.99999999999,0,0,0]
[419970,210940,135350,200075,211700,461550,104300,106500]

{"sheet":"Lead Calculations","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Strategic Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Adjust the column headings to match your lead source names."]
["Web Inquiry","Partner","Customer Reference","Web Event","Trade Show"]
[15000,0,0,0,0]
[0,0,0,0,0]
[0,48750,0,0,0]
[0,0,59000,0,0]
[0,0,0,74000,0]
[0,0,0,0,105000]
[0,0,0,0,0]
[0,106500,0,0,0]
[0,0,151920,0,0]
[0,0,0,0,146625]
[0,0,0,0,0]
[0,0,147725,0,0]
[0,0,0,0,16600]
[0,0,0,0,0]
[28000,0,0,0,0]
[0,0,0,46500,0]
[86600,0,0,0,0]
[0,87900,0,0,0]
[0,0,0,0,0]
[0,0,0,0,153900]
[0,0,15700,0,0]
[121099.99999999999,0,0,0,0]
[250700,243150,374345,120500,422125]