{"text_format":"1","workbook":"xls","n_sheets":7,"sheets":["Pipeline Input","Month Calculations","Region Calculations","Phase Calculations","Month Totals","Region Totals","Phase 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":"Phase 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>  "]
["Tactical 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,"Proposal Discussed","May"]
["City Power & Light","Kathie Flood","US - Southwest","Trade Show","Support",175000,"Written Proposal","June"]
["Coho Vineyard","Janice Galvin","Canada - East","E-Mail","Mixture",149000,"Negotiation Phase","July"]
["Coho Winery","Adina Hagege","Canada - West","Partner","Training",142000,"Verbal Approval","August"]
["Coho Vineyard & Winery","Shu Ito","US - Northeast","Customer Reference","Consulting",189900,"Purchase Order","September"]
["Contoso, Ltd.","David Jaffe","US - Southwest","Trade Show","Mixture",172500,"Invoice","October"]
["Contoso Pharmaceuticals","Sandeep Kaliyath","US - Northeast","E-Mail","Products",163500,"Payment","November"]
["Consolidated Messenger","Rebecca Laszlo","US - Southwest","Customer Reference","Products",155500,"Payment","December"]
["Fabrikam, Inc.","Diane Margheim","US - Northwest","Trade Show","Consulting",166000,"Verbal Approval","January"]
["Fourth Coffee","Paula Nartker","US - Northeast","E-Mail","Training",180000,"Purchase Order","March"]
["Graphic Design Institute","Robert O'Hara","US - Southeast","Web Inquiry","Services",140000,"Lead","May"]
["Humongous Insurance","Carol Philips","US - Southwest","Web Event","Support",155000,"Qualified Lead","June"]
["Litware, Inc.","Kim Ralls","US - North Central","Web Inquiry","Prof. Services",173200,"Proposal Discussed","October"]
["Lucerne Publishing","Sharon Salavaria","US - Northeast","Partner","Services",146500,"Written Proposal","December"]
["Margie's Travel","Andy Teal","US - South Central","E-Mail","Support",156750,"Invoice","November"]
["Northwind Traders","Sunil Uppal","US - Southeast","Trade Show","Prof. Services",162000,"Payment","February"]
["Proseware, Inc.","H. Brian Valentine","US - Southwest","Customer Reference","Mixture",157000,"Verbal Approval","March"]
["School of Fine Art","Robert Walters","US - Northwest","Web Inquiry","Services",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>  "]
["Tactical 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.85,0,0,0,0,0,0,0,0,161415,0,0,0,161415,-1,0.85]
[0.9,0,0,0,0,0,0,0,0,0,155250,0,0,155250,-1,0.9]
[0.95,0,0,0,0,0,0,0,0,0,0,155325,0,155325,-1,0.95]
[0.95,0,0,0,0,0,0,0,0,0,0,0,147725,147725,-1,0.95]
[0.75,124500,0,0,0,0,0,0,0,0,0,0,0,124500,-1,0.75]
[0.85,0,0,153000,0,0,0,0,0,0,0,0,0,153000,-1,0.85]
[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.75,0,0,117750,0,0,0,0,0,0,0,0,0,117750,-1,0.75]
[0.7,0,0,0,121099.99999999999,0,0,0,0,0,0,0,0,121099.99999999999,0.7,-1]
["Monthly Total",139500,182940,319500,180100,102000,151500,104300,106500,161415,241850,296400,235625]
["Cumulative",139500,322440,641940,822040,924040,1075540,1179840,1286340,1447755,1689605,1986005,2221630]

{"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>  "]
["Tactical 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]
[161415,0,0,0,0,0,0,0]
[0,0,0,0,0,155250,0,0]
[155325,0,0,0,0,0,0,0]
[0,0,0,0,0,147725,0,0]
[0,0,0,0,124500,0,0,0]
[153000,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,117750,0,0]
[0,0,0,0,121099.99999999999,0,0,0]
[572640,210940,135350,200075,319600,572225,104300,106500]

{"sheet":"Phase Calculations","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Tactical Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Adjust the column headings to match your sales phase names."]
["Contact","Lead","Qualified Lead","Opportunity","Proposal Discussed","Written Proposal","Negotiation Phase","Verbal Approval","Purchase Order","Invoice","Payment"]
[15000,0,0,0,0,0,0,0,0,0,0]
[0,29040,0,0,0,0,0,0,0,0,0]
[0,0,48750,0,0,0,0,0,0,0,0]
[0,0,0,59000,0,0,0,0,0,0,0]
[0,0,0,0,74000,0,0,0,0,0,0]
[0,0,0,0,0,105000,0,0,0,0,0]
[0,0,0,0,0,0,104300,0,0,0,0]
[0,0,0,0,0,0,0,106500,0,0,0]
[0,0,0,0,0,0,0,0,161415,0,0]
[0,0,0,0,0,0,0,0,0,155250,0]
[0,0,0,0,0,0,0,0,0,0,155325]
[0,0,0,0,0,0,0,0,0,0,147725]
[0,0,0,0,0,0,0,124500,0,0,0]
[0,0,0,0,0,0,0,0,153000,0,0]
[0,28000,0,0,0,0,0,0,0,0,0]
[0,0,46500,0,0,0,0,0,0,0,0]
[0,0,0,0,86600,0,0,0,0,0,0]
[0,0,0,0,0,87900,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,141075,0]
[0,0,0,0,0,0,0,0,0,0,153900]
[0,0,0,0,0,0,0,117750,0,0,0]
[0,0,0,0,0,0,121099.99999999999,0,0,0,0]
[15000,57040,95250,59000,160600,192900,225400,348750,314415,296325,456950]