{"text_format":"1","workbook":"xls","n_sheets":4,"sheets":["Pipeline","Effectiveness Results","Actual vs. Target","Sales Conversion"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Actual vs. Target","index":2,"reason":"not_a_worksheet"},{"sheet":"Sales Conversion","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","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[40,0,40,1],[41,0,41,1],[42,0,42,1],[36,0,36,1],[37,0,37,1],[39,0,39,4],[33,0,33,4],[27,0,27,1],[28,0,28,1],[22,0,22,1],[30,0,30,1],[25,0,25,1],[26,0,26,1],[34,0,34,1],[35,0,35,1],[19,0,19,1],[18,0,18,5],[29,0,29,1],[20,0,20,1],[21,0,21,1],[23,0,23,1],[24,0,24,1],[31,0,31,1],[10,0,10,1],[5,0,5,3],[4,0,4,3],[6,0,6,3],[9,0,9,5]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Pipeline"]
["[Date]"]
[]
["Model key"]
["Bold numbers in white cells are entered by user."]
["Italic numbers in gray cells are calculations that generally should not be altered."]
[]
[]
["Pipeline breakdown"]
[null,null,"A Opportunities","B Opportunities","C Opportunities"]
[null,null,"Value"," Value","Value","Total Value"]
[null,null,774865,2796830,354877,3926572]
["Goal",3500000,"Target","Target","Target","Total Target"]
[null,null,1050000,2100000,350000,3500000]
[null,null,"Variance","Variance","Variance","Total Variance"]
[null,null,-275135,696830,4877,426572]
[]
["Customer breakdown"]
["Customer list",null,"A Opportunities","B Opportunities","C Opportunities"]
["Proseware, Inc.",null,26865]
["A. Datum Corporation",null,23000]
["Northwind Traders",null,725000]
["Margie's Travel",null,null,555678]
["The Phone Company",null,null,1825400]
["Coho Winery",null,null,415752]
["Tailspin Toys",null,null,null,22000]
["Fabrikam, Inc.",null,null,null,15723]
["Wingtip Toys",null,null,null,317154]
[]
[null,null,774865,2796830,354877]
[null,null,null,null,"Total customer value",3926572]
[]
["Key performance indicators"]
["Average deal size",null,"Duration (weeks)","Weeks in pipeline"]
[436285.77777777775,null,5.35,13.7]
["Calls to conversion %",null,"Meeting to conversion %","Meeting to qualification opportunity %","Qualification to sold %"]
[0.18,null,0.2571428571428571,0.42857142857142855,0.6]
[]
["Activity breakdown"]
["Total customer calls",null,"Total customer meetings","Total qualified","Total sold"]
[50,null,35,15,9]

{"sheet":"Effectiveness Results","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,3],[5,0,5,3],[6,0,6,3],[32,0,32,1],[33,0,33,1],[29,5,29,6],[30,5,30,6],[26,5,26,6],[27,5,27,6],[28,5,28,6]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Sales Effectiveness Survey"]
["[Date]"]
[]
["Model key"]
["Bold numbers in white cells are entered by user."]
["Italic numbers in gray cells are calculations that generally should not be altered."]
[]
[]
["Sales effectiveness survey"]
["Quota"]
[null,"Target","Closed","%"]
["For year",3500000,3926572]
["Number of deals",8.022264713342835,9]
["Weekly run rate (52 weeks)",67307.69230769231,75511]
[]
[]
["A Opportunities",1050000,774865,0.7379666666666667]
["B Opportunities",2100000,2796830,1.3318238095238095]
["C Opportunities",350000,354877,1.0139342857142857]
[]
["Pipeline size (ongoing basis)",3500000,3926572,1.1218777142857144]
[]
["Average deal size",436285.77777777775]
["Average bill duration",5.35]
["Sales cycle"]
[]
["Sales calls converted",null,null,0.18]
["Sales meetings converted",null,null,0.2571428571428571]
["Sales meetings qualified",null,null,0.42857142857142855]
["Qualified sales closed",null,null,0.6]
["Averages"]
["Average closed deals",null,436285.77777777775]
["Win/loss ratio",null,0.6]