{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Pipeline Input","Pipeline Calculations","Pipeline Totals","Drop-down list data"],"not_rendered":{"charts":1,"images":1,"defined_names":19,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Pipeline Input","index":0,"n_rows":30,"n_cols":13,"rows_kept":30}
[]
[null,"<Company Name>"]
[null,"Detailed Sales Pipeline Management"]
[null,"Company Confidential"]
[]
[null,"Instructions: Enter values into the white and yellow cells only."]
[null,"Opportunity Name","Customer Contact","Sales Rep","Lead Source","Sales Phase","Sales Category","Forecast \nAmount","Forecast Close","Year","Probability of Sale","Timeline","Probability Forecast"]
[null,"A. Datum Corporation","Kim Abercrombie","Anne Hellung-Larsen","Partner","Contact","All",{"v":150000,"d":"$150,000"},"January",2017,{"v":0.9,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42736,"d":"4273600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":135000,"d":"$135,000"}}]
[null,"Adventure Works","Angela Barbariol","Jan Kotas","E-Mail","Lead","Beverages",{"v":145200,"d":"$145,200"},"February",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42767,"d":"4276700.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":116160,"d":"$116,160"}}]
[null,"Alpine Ski House","Gabriele Cannata","Mariya Sergienko","Partner","Qualified Lead","Dried Fruit & Nuts",{"v":162500,"d":"$162,500"},"March",2017,{"v":0.25,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42795,"d":"4279500.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":40625,"d":"$40,625"}}]
[null,"Baldwin Museum of Science","Barbara S. Decker","Michael Neipper","Customer Reference","Opportunity","Baked Goods & Mixes",{"v":147500,"d":"$147,500"},"April",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42826,"d":"4282600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":118000,"d":"$118,000"}}]
[null,"Blue Yonder Airlines","Susan W. Eaton","Laura Giussani","Web Event","Executive Sponsorship","Candy",{"v":148000,"d":"$148,000"},"May",2017,{"v":0.3,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42856,"d":"4285600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":44400,"d":"$44,400"}}]
[null,"City Power & Light","Kathie Flood","Nancy Freehafer","Conference","Proposal Discussed","Soups",{"v":175000,"d":"$175,000"},"June",2017,{"v":0.1,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42887,"d":"4288700.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":17500,"d":"$17,500"}}]
[null,"Coho Vineyard","Janice Galvin","Robert Zare","E-Mail","Written Proposal","Sauces",{"v":149000,"d":"$149,000"},"July",2017,{"v":0.6,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42917,"d":"4291700.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":89400,"d":"$89,400"}}]
[null,"Coho Winery","Adina Hagege","Andrew Cencini","Partner","Contract","Jams, Preserves",{"v":142000,"d":"$142,000"},"August",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42948,"d":"4294800.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":113600,"d":"$113,600"}}]
[null,"Coho Vineyard & Winery","Shu Ito","Anne Hellung-Larsen","Customer Reference","Purchase Order","Condiments",{"v":189900,"d":"$189,900"},"September",2017,{"v":0.4,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42979,"d":"4297900.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":75960,"d":"$75,960"}}]
[null,"Contoso, Ltd.","David Jaffe","Jan Kotas","Conference","Invoice","Canned Meat",{"v":172500,"d":"$172,500"},"October",2017,{"v":0.7,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43009,"d":"4300900.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":120749.99999999999,"d":"$120,750"}}]
[null,"Contoso Pharmaceuticals","Sandeep Kaliyath","Mariya Sergienko","E-Mail","Payment","Pasta",{"v":163500,"d":"$163,500"},"November",2017,{"v":0.9,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43040,"d":"4304000.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":147150,"d":"$147,150"}}]
[null,"Consolidated Messenger","Rebecca Laszlo","Michael Neipper","Customer Reference","Acceptance","Oil",{"v":155500,"d":"$155,500"},"December",2017,{"v":0.3,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43070,"d":"4307000.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":46650,"d":"$46,650"}}]
[null,"Fabrikam, Inc.","Diane Margheim","Laura Giussani","Conference","Executive Sponsorship","Canned Fruit & Vegetables",{"v":166000,"d":"$166,000"},"January",2017,{"v":0.3,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42736,"d":"4273600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":49800,"d":"$49,800"}}]
[null,"Fourth Coffee","Paula Nartker","Nancy Freehafer","E-Mail","Invoice","Grains",{"v":180000,"d":"$180,000"},"March",2017,{"v":0.3,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42795,"d":"4279500.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":54000,"d":"$54,000"}}]
[null,"Graphic Design Institute","Robert O'Hara","Anne Hellung-Larsen","Web Inquiry","Contract","All",{"v":140000,"d":"$140,000"},"May",2017,{"v":0.2,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42856,"d":"4285600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":28000,"d":"$28,000"}}]
[null,"Humongous Insurance","Carol Philips","Jan Kotas","Web Event","Qualified Lead","Beverages",{"v":155000,"d":"$155,000"},"June",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42887,"d":"4288700.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":124000,"d":"$124,000"}}]
[null,"Litware, Inc.","Kim Ralls","Mariya Sergienko","Web Inquiry","Lead","Dried Fruit & Nuts",{"v":173200,"d":"$173,200"},"October",2017,{"v":0.6,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43009,"d":"4300900.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":103920,"d":"$103,920"}}]
[null,"Lucerne Publishing","Sharon Salavaria","Michael Neipper","Partner","Contact","Baked Goods & Mixes",{"v":146500,"d":"$146,500"},"December",2017,{"v":0.7,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43070,"d":"4307000.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":102550,"d":"$102,550"}}]
[null,"Margie's Travel","Andy Teal","Laura Giussani","E-Mail","Payment","Candy",{"v":156750,"d":"$156,750"},"November",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":43040,"d":"4304000.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":125400,"d":"$125,400"}}]
[null,"Northwind Traders","Sunil Uppal","Nancy Freehafer","Conference","Written Proposal","Soups",{"v":162000,"d":"$162,000"},"February",2017,{"v":0.4,"d":"$0"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42767,"d":"4276700.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":64800,"d":"$64,800"}}]
[null,"Proseware, Inc.","H. Brian Valentine","Mariya Sergienko","Customer Reference","Opportunity","Sauces",{"v":157000,"d":"$157,000"},"March",2017,{"v":0.9,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42795,"d":"4279500.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":141300,"d":"$141,300"}}]
[null,"School of Fine Art","Robert Walters","Michael Neipper","Web Inquiry","Executive Sponsorship","Jams, Preserves",{"v":173000,"d":"$173,000"},"April",2017,{"v":0.8,"d":"$1"},{"$f":"IFERROR(DATE(tblData[[#This Row],[Year]],LOOKUP(tblData[[#This Row],[Forecast Close]],{\"April\",4;\"August\",8;\"December\",12;\"February\",2;\"January\",1;\"July\",7;\"June\",6;\"March\",3;\"May\",5;\"November\",11;\"October\",10;\"September\",9}),1),\"\")","v":{"v":42826,"d":"4282600.00%"}},{"$f":"tblData[[#This Row],[Forecast \nAmount]]*tblData[[#This Row],[Probability of Sale]]","v":{"v":138400,"d":"$138,400"}}]
[null,"Total",{"$nulls":5},{"$f":"SUBTOTAL(109,tblData[Forecast \nAmount])","v":{"v":3510050,"d":"$3,510,050"}},{"$nulls":4},{"$f":"SUBTOTAL(109,tblData[Probability Forecast])","v":{"v":1997365,"d":"$1,997,365"}}]

{"sheet":"Pipeline Calculations","index":1,"n_rows":39,"n_cols":18,"rows_kept":39}
[]
[null,{"$f":"'Pipeline Input'!B2","v":"<Company Name>"}]
[null,{"$f":"'Pipeline Input'!B3","v":"Detailed Sales Pipeline Management"}]
[null,{"$f":"'Pipeline Input'!B4","v":"Company Confidential"}]
{"$rows_empty":10}
[null,"Forecast",null,null,"Forecast Close"]
[null,"Opportunity Name","Year","Probability of Sale","January","February","March","April","May","June","July","August","September","October","November","December","Grand Total","Trend"]
[null,"A. Datum Corporation",2017,{"v":0.9,"d":"$1"},{"v":135000,"d":"$135,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":135000,"d":"$135,000"}]
[null,"Adventure Works",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":116160,"d":"$116,160"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":116160,"d":"$116,160"}]
[null,"Alpine Ski House",2017,{"v":0.25,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":40625,"d":"$40,625"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":40625,"d":"$40,625"}]
[null,"Baldwin Museum of Science",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":118000,"d":"$118,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":118000,"d":"$118,000"}]
[null,"Blue Yonder Airlines",2017,{"v":0.3,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":44400,"d":"$44,400"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":44400,"d":"$44,400"}]
[null,"City Power & Light",2017,{"v":0.1,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":17500,"d":"$17,500"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":17500,"d":"$17,500"}]
[null,"Coho Vineyard",2017,{"v":0.6,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":89400,"d":"$89,400"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":89400,"d":"$89,400"}]
[null,"Coho Winery",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":113600,"d":"$113,600"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":113600,"d":"$113,600"}]
[null,"Consolidated Messenger",2017,{"v":0.3,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":46650,"d":"$46,650"},{"v":46650,"d":"$46,650"}]
[null,"Contoso Pharmaceuticals",2017,{"v":0.9,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":147150,"d":"$147,150"},{"v":0,"d":"$0"},{"v":147150,"d":"$147,150"}]
[null,"Contoso, Ltd.",2017,{"v":0.7,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":120749.99999999999,"d":"$120,750"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":120749.99999999999,"d":"$120,750"}]
[null,"Fabrikam, Inc.",2017,{"v":0.3,"d":"$0"},{"v":49800,"d":"$49,800"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":49800,"d":"$49,800"}]
[null,"Fourth Coffee",2017,{"v":0.3,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":54000,"d":"$54,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":54000,"d":"$54,000"}]
[null,"Graphic Design Institute",2017,{"v":0.2,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":28000,"d":"$28,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":28000,"d":"$28,000"}]
[null,"Humongous Insurance",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":124000,"d":"$124,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":124000,"d":"$124,000"}]
[null,"Litware, Inc.",2017,{"v":0.6,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":103920,"d":"$103,920"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":103920,"d":"$103,920"}]
[null,"Lucerne Publishing",2017,{"v":0.7,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":102550,"d":"$102,550"},{"v":102550,"d":"$102,550"}]
[null,"Margie's Travel",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":125400,"d":"$125,400"},{"v":0,"d":"$0"},{"v":125400,"d":"$125,400"}]
[null,"Northwind Traders",2017,{"v":0.4,"d":"$0"},{"v":0,"d":"$0"},{"v":64800,"d":"$64,800"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":64800,"d":"$64,800"}]
[null,"Proseware, Inc.",2017,{"v":0.9,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":141300,"d":"$141,300"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":141300,"d":"$141,300"}]
[null,"School of Fine Art",2017,{"v":0.8,"d":"$1"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":138400,"d":"$138,400"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":138400,"d":"$138,400"}]
[null,"Coho Vineyard & Winery",2017,{"v":0.4,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":75960,"d":"$75,960"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":75960,"d":"$75,960"}]
[null,"Grand Total",null,null,{"v":379200,"d":"$379,200"},{"v":368640.00000000006,"d":"$368,640"},{"v":724275.0000000001,"d":"$724,275"},{"v":512800,"d":"$512,800"},{"v":144000,"d":"$144,000"},{"v":297000,"d":"$297,000"},{"v":89400,"d":"$89,400"},{"v":113600,"d":"$113,600"},{"v":75960,"d":"$75,960"},{"v":449409.99999999994,"d":"$449,410"},{"v":544425,"d":"$544,425"},{"v":302000,"d":"$302,000"},{"v":44402132.50000001,"d":"$44,402,133"}]

{"sheet":"Pipeline Totals","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[null,{"$f":"'Pipeline Input'!B2&\" - Monthly Forecast\"","v":"<Company Name> - Monthly Forecast"}]
[]
[null,"Month"," Probability Forecast","Cumulative Total"]
[null,"Jan",{"v":184800,"d":"$184,800"},{"v":184800,"d":"$184,800"}]
[null,"Feb",{"v":180960,"d":"$180,960"},{"v":365760,"d":"$365,760"}]
[null,"Mar",{"v":235925,"d":"$235,925"},{"v":601685,"d":"$601,685"}]
[null,"Apr",{"v":256400,"d":"$256,400"},{"v":858085,"d":"$858,085"}]
[null,"May",{"v":72400,"d":"$72,400"},{"v":930485,"d":"$930,485"}]
[null,"Jun",{"v":141500,"d":"$141,500"},{"v":1071985,"d":"$1,071,985"}]
[null,"Jul",{"v":89400,"d":"$89,400"},{"v":1161385,"d":"$1,161,385"}]
[null,"Aug",{"v":113600,"d":"$113,600"},{"v":1274985,"d":"$1,274,985"}]
[null,"Sep",{"v":75960,"d":"$75,960"},{"v":1350945,"d":"$1,350,945"}]
[null,"Oct",{"v":224670,"d":"$224,670"},{"v":1575615,"d":"$1,575,615"}]
[null,"Nov",{"v":272550,"d":"$272,550"},{"v":1848165,"d":"$1,848,165"}]
[null,"Dec",{"v":149200,"d":"$149,200"},{"v":1997365,"d":"$1,997,365"}]

{"sheet":"Drop-down list data","index":3,"n_rows":27,"n_cols":11,"rows_kept":27}
["Sales Reps",null,"Lead Source",null,"Sales Category",null,"Phase",null,"Months"]
["Anne Hellung-Larsen",null,"Web Inquiry",null,"All",null,"Contact",null,"January"]
["Jan Kotas",null,"E-Mail",null,"Beverages",null,"Lead",null,"February"]
["Mariya Sergienko",null,"Partner",null,"Dried Fruit & Nuts",null,"Qualified Lead",null,"March"]
["Michael Neipper",null,"Customer Reference",null,"Baked Goods & Mixes",null,"Opportunity",null,"April"]
["Laura Giussani",null,"Web Event",null,"Candy",null,"Executive Sponsorship",null,"May"]
["Nancy Freehafer",null,"Conference",null,"Soups",null,"Proposal Discussed",null,"June"]
["Robert Zare",null,"E-Mail",null,"Sauces",null,"Written Proposal",null,"July"]
["Andrew Cencini",null,"Partner",null,"Jams, Preserves",null,"Contract",null,"August"]
[null,null,"Customer Reference",null,"Condiments",null,"Purchase Order",null,"September"]
[null,null,"Conference",null,"Canned Meat",null,"Invoice",null,"October"]
[null,null,"E-Mail",null,"Pasta",null,"Payment",null,"November"]
[null,null,"Customer Reference",null,"Dairy Products",null,"Acceptance",null,"December"]
[null,null,"Conference",null,"Oil"]
[null,null,"E-Mail",null,"Canned Fruit & Vegetables"]
[null,null,"Web Inquiry",null,"Grains"]
[null,null,"Web Event"]
[null,null,"Web Inquiry"]
[null,null,"Partner"]
[null,null,"E-Mail"]
[null,null,"Conference"]
[null,null,"Customer Reference"]
[null,null,"Web Inquiry"]
[]
[{"$nulls":10},"Learn more:"]
[{"$nulls":10},"Excel tables"]
[{"$nulls":10},"Apply data validation to cells"]