{"text_format":"1","workbook":"xls","n_sheets":4,"sheets":["Pipeline Details","Product Calculations","Pipeline Chart","Product 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":"Product 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":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Product Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Enter data into the white and yellow cells only."]
["Account\nName","Account\nContact","Pipeline\nStage","Product\nLine","Forecast\nClose","Potential Opportunity","Chance\nof Sale","Weighted\nForecast","Q1 Weighted\nForecast","Q2 Weighted\nForecast","Q3 Weighted\nForecast","Q4 Weighted\nForecast","Internal\nCalculation","Internal\nCalculation"]
["A. Datum Corporation","Kim Abercrombie","Contact","Product Line A","Q1",300000,0.1,30000,30000,0,0,0,0.1,-1]
["Adventure Works","Angela Barbariol","Lead","Product Line B","Q1",200000,0.2,40000,40000,0,0,0,0.2,-1]
["Alpine Ski House","Gabriele Cannata","Qualified Lead","Product Line C","Q1",100000,0.3,30000,30000,0,0,0,0.3,-1]
["Baldwin Museum of Science","Barbara S. Decker","Opportunity","Product Line C","Q2",500000,0.4,200000,0,200000,0,0,0.4,-1]
["Blue Yonder Airlines","Susan W. Eaton","Sponsorship","Product Line A","Q2",400000,0.5,200000,0,200000,0,0,0.5,-1]
["City Power & Light","Kathie Flood","Verbal Approval","Product Line A","Q2",300000,0.6,180000,0,180000,0,0,-1,0.6]
["Coho Vineyard","Janice Galvin","Purchase Order","Product Line B","Q3",200000,0.7,140000,0,0,140000,0,-1,0.7]
["Coho Winery","Adina Hagege","Invoice","Product Line A","Q3",100000,0.8,80000,0,0,80000,0,-1,0.8]
["Coho Vineyard & Winery","Shu Ito","Acceptance","Product Line A","Q3",500000,0.9,450000,0,0,450000,0,-1,0.9]
["Contoso, Ltd.","David Jaffe","Payment","Product Line B","Q4",300000,1,300000,0,0,0,300000,-1,1]
["Contoso Pharmaceuticals","Sandeep Kaliyath","Contact","Product Line C","Q4",400000,0.1,40000,0,0,0,40000,0.1,-1]
["Consolidated Messenger","Rebecca Laszlo","Lead","Product Line C","Q4",200000,0.2,40000,0,0,0,40000,0.2,-1]
["Fabrikam, Inc.","Diane Margheim","Qualified Lead","Product Line A","Q1",100000,0.3,30000,30000,0,0,0,0.3,-1]
["Fourth Coffee","Paula Nartker","Opportunity","Product Line A","Q1",200000,0.4,80000,80000,0,0,0,0.4,-1]
["Graphic Design Institute","Robert O'Hara","Sponsorship","Product Line C","Q2",300000,0.5,150000,0,150000,0,0,0.5,-1]
["Humongous Insurance","Carol Philips","Verbal Approval","Product Line A","Q2",300000,0.6,180000,0,180000,0,0,-1,0.6]
["Litware, Inc.","Kim Ralls","Purchase Order","Product Line A","Q4",400000,0.7,280000,0,0,0,280000,-1,0.7]
["Lucerne Publishing","Sharon Salavaria","Invoice","Product Line B","Q4",200000,0.8,160000,0,0,0,160000,-1,0.8]
["Margie's Travel","Andy Teal","Acceptance","Product Line B","Q4",500000,0.9,450000,0,0,0,450000,-1,0.9]
["Northwind Traders","Sunil Uppal","Payment","Product Line A","Q2",300000,1,300000,0,300000,0,0,-1,1]
["Proseware, Inc.","H. Brian Valentine","Payment","Product Line C","Q2",200000,1,200000,0,200000,0,0,-1,1]
["School of Fine Art","Robert Walters","Invoice","Product Line C","Q3",200000,0.8,160000,0,0,160000,0,-1,0.8]
["TOTAL",null,null,null,null,6200000,null,3720000,210000,1410000,830000,1270000]
[null,null,null,null,null,null,null,null,210000,1620000,2450000,3720000]

{"sheet":"Product Calculations","index":1,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Product Sales Pipeline Management"]
["Company Confidential"]
[]
["Instructions: Adjust the column headings to match your product line names."]
["Product Line A","Product Line B","Product Line C"]
[30000,0,0]
[0,40000,0]
[0,0,30000]
[0,0,200000]
[200000,0,0]
[180000,0,0]
[0,140000,0]
[80000,0,0]
[450000,0,0]
[0,300000,0]
[0,0,40000]
[0,0,40000]
[30000,0,0]
[80000,0,0]
[0,0,150000]
[180000,0,0]
[280000,0,0]
[0,160000,0]
[0,450000,0]
[300000,0,0]
[0,0,200000]
[0,0,160000]
[1810000,1090000,820000]