{"text_format":"1","workbook":"xls","n_sheets":7,"sheets":["Revenue Input","Optimistic Revenue","Most Likely Revenue","Pessimistic Revenue","Mean Revenue","Monthly Revenue","Cumulative Revenue"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Monthly Revenue","index":5,"reason":"not_a_worksheet"},{"sheet":"Cumulative Revenue","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":"Revenue Input","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name] "]
["Detailed Revenue Plan—Input"]
["[Company Name] Confidential"]
["[Date]"]
[]
["FISCAL YEAR BEGINNING","2005-01-01"]
[]
["Gray cells are calculated for you, and they generally should not be altered. "]
[]
["Opportunity\nname","Sales\ncategory","Optimistic\nforecast","Most likely\nforecast","Pessimistic\nforecast","Forecast\nclose","Mean\nforecast"]
["A. Datum Corporation","Consulting",150000,120000,90000,"January",120000]
["Adventure Works","Products",145200,122000,89000,"February",120366.66666666667]
["Alpine Ski House","Training",162500,120000,84000,"March",121083.33333333333]
["Baldwin Museum of Science","Mixture",147500,125000,99000,"April",124416.66666666667]
["Blue Yonder Airlines","Prof. services",148000,140000,132000,"May",140000]
["City Power & Light","Support",175000,150000,125000,"June",150000]
["Coho Vineyard","Mixture",149000,125000,101000,"July",125000]
["Coho Winery","Training",142000,131000,119000,"August",130833.33333333333]
["Coho Vineyard & Winery","Consulting",189900,175000,145000,"September",172483.33333333334]
["Contoso, Ltd.","Mixture",172500,156000,142000,"October",156416.66666666666]
["Contoso Pharmaceuticals","Products",163500,146000,123000,"November",145083.33333333334]
["Consolidated Messenger","Products",155500,150000,141000,"December",149416.66666666666]
["Fabrikam, Inc.","Consulting",166000,133000,112000,"January",135000]
["Fourth Coffee","Training",180000,170000,160000,"March",170000]
["Graphic Design Institute","Services",140000,120000,100000,"May",120000]
["Humongous Insurance","Support",155000,135000,115000,"June",135000]
["Litware, Inc.","Prof. services",173200,168500,161900,"October",168183.33333333334]
["Lucerne Publishing","Services",146500,142400,137500,"December",142266.66666666666]
["Margie's Travel","Support",156750,152500,145200,"November",151991.66666666666]
["Northwind Traders","Prof. services",162000,142000,122000,"February",142000]
["Proseware, Inc.","Mixture",157000,143000,127000,"March",142666.66666666666]
["School of Fine Art","Services",173000,165000,154000,"April",164500]
["Southridge Video","Mixture",171000,161000,151000,"August",161000]
["Tailspin Toys","Products",168000,146000,129000,"September",146833.33333333334]
["TOTAL",null,3849050,3438400,3004600,null,3434541.6666666665]

{"sheet":"Optimistic Revenue","index":1,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name] "]
["Optimistic Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["Gray cells are calculated for you, and they generally should not be altered."]
["2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01"]
[150000,0,0,0,0,0,0,0,0,0,0,0]
[0,145200,0,0,0,0,0,0,0,0,0,0]
[0,0,162500,0,0,0,0,0,0,0,0,0]
[0,0,0,147500,0,0,0,0,0,0,0,0]
[0,0,0,0,148000,0,0,0,0,0,0,0]
[0,0,0,0,0,175000,0,0,0,0,0,0]
[0,0,0,0,0,0,149000,0,0,0,0,0]
[0,0,0,0,0,0,0,142000,0,0,0,0]
[0,0,0,0,0,0,0,0,189900,0,0,0]
[0,0,0,0,0,0,0,0,0,172500,0,0]
[0,0,0,0,0,0,0,0,0,0,163500,0]
[0,0,0,0,0,0,0,0,0,0,0,155500]
[166000,0,0,0,0,0,0,0,0,0,0,0]
[0,0,180000,0,0,0,0,0,0,0,0,0]
[0,0,0,0,140000,0,0,0,0,0,0,0]
[0,0,0,0,0,155000,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,173200,0,0]
[0,0,0,0,0,0,0,0,0,0,0,146500]
[0,0,0,0,0,0,0,0,0,0,156750,0]
[0,162000,0,0,0,0,0,0,0,0,0,0]
[0,0,157000,0,0,0,0,0,0,0,0,0]
[0,0,0,173000,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,171000,0,0,0,0]
[0,0,0,0,0,0,0,0,168000,0,0,0]
[316000,307200,499500,320500,288000,330000,149000,313000,357900,345700,320250,302000,"TOTALS"]
[316000,623200,1122700,1443200,1731200,2061200,2210200,2523200,2881100,3226800,3547050,3849050,"Running TOTALS"]

{"sheet":"Most Likely Revenue","index":2,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name] "]
["Most Likely Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["Gray cells are calculated for you, and they generally should not be altered."]
["2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01"]
[120000,0,0,0,0,0,0,0,0,0,0,0]
[0,122000,0,0,0,0,0,0,0,0,0,0]
[0,0,120000,0,0,0,0,0,0,0,0,0]
[0,0,0,125000,0,0,0,0,0,0,0,0]
[0,0,0,0,140000,0,0,0,0,0,0,0]
[0,0,0,0,0,150000,0,0,0,0,0,0]
[0,0,0,0,0,0,125000,0,0,0,0,0]
[0,0,0,0,0,0,0,131000,0,0,0,0]
[0,0,0,0,0,0,0,0,175000,0,0,0]
[0,0,0,0,0,0,0,0,0,156000,0,0]
[0,0,0,0,0,0,0,0,0,0,146000,0]
[0,0,0,0,0,0,0,0,0,0,0,150000]
[133000,0,0,0,0,0,0,0,0,0,0,0]
[0,0,170000,0,0,0,0,0,0,0,0,0]
[0,0,0,0,120000,0,0,0,0,0,0,0]
[0,0,0,0,0,135000,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,168500,0,0]
[0,0,0,0,0,0,0,0,0,0,0,142400]
[0,0,0,0,0,0,0,0,0,0,152500,0]
[0,142000,0,0,0,0,0,0,0,0,0,0]
[0,0,143000,0,0,0,0,0,0,0,0,0]
[0,0,0,165000,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,161000,0,0,0,0]
[0,0,0,0,0,0,0,0,146000,0,0,0]
[253000,264000,433000,290000,260000,285000,125000,292000,321000,324500,298500,292400,"TOTALS"]
[253000,517000,950000,1240000,1500000,1785000,1910000,2202000,2523000,2847500,3146000,3438400,"Running TOTALS"]

{"sheet":"Pessimistic Revenue","index":3,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name] "]
["Pessimistic Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["Gray cells are calculated for you, and they generally should not be altered."]
["2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01"]
[90000,0,0,0,0,0,0,0,0,0,0,0]
[0,89000,0,0,0,0,0,0,0,0,0,0]
[0,0,84000,0,0,0,0,0,0,0,0,0]
[0,0,0,99000,0,0,0,0,0,0,0,0]
[0,0,0,0,132000,0,0,0,0,0,0,0]
[0,0,0,0,0,125000,0,0,0,0,0,0]
[0,0,0,0,0,0,101000,0,0,0,0,0]
[0,0,0,0,0,0,0,119000,0,0,0,0]
[0,0,0,0,0,0,0,0,145000,0,0,0]
[0,0,0,0,0,0,0,0,0,142000,0,0]
[0,0,0,0,0,0,0,0,0,0,123000,0]
[0,0,0,0,0,0,0,0,0,0,0,141000]
[112000,0,0,0,0,0,0,0,0,0,0,0]
[0,0,160000,0,0,0,0,0,0,0,0,0]
[0,0,0,0,100000,0,0,0,0,0,0,0]
[0,0,0,0,0,115000,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,161900,0,0]
[0,0,0,0,0,0,0,0,0,0,0,137500]
[0,0,0,0,0,0,0,0,0,0,145200,0]
[0,122000,0,0,0,0,0,0,0,0,0,0]
[0,0,127000,0,0,0,0,0,0,0,0,0]
[0,0,0,154000,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,151000,0,0,0,0]
[0,0,0,0,0,0,0,0,129000,0,0,0]
[202000,211000,371000,253000,232000,240000,101000,270000,274000,303900,268200,278500,"TOTALS"]
[202000,413000,784000,1037000,1269000,1509000,1610000,1880000,2154000,2457900,2726100,3004600,"Running TOTALS"]

{"sheet":"Mean Revenue","index":4,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name] "]
["Mean Revenue Forecast"]
["[Company Name] Confidential"]
["[Date]"]
[]
["Gray cells are calculated for you, and they generally should not be altered."]
["2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01"]
[120000,0,0,0,0,0,0,0,0,0,0,0]
[0,120366.66666666667,0,0,0,0,0,0,0,0,0,0]
[0,0,121083.33333333333,0,0,0,0,0,0,0,0,0]
[0,0,0,124416.66666666667,0,0,0,0,0,0,0,0]
[0,0,0,0,140000,0,0,0,0,0,0,0]
[0,0,0,0,0,150000,0,0,0,0,0,0]
[0,0,0,0,0,0,125000,0,0,0,0,0]
[0,0,0,0,0,0,0,130833.33333333333,0,0,0,0]
[0,0,0,0,0,0,0,0,172483.33333333334,0,0,0]
[0,0,0,0,0,0,0,0,0,156416.66666666666,0,0]
[0,0,0,0,0,0,0,0,0,0,145083.33333333334,0]
[0,0,0,0,0,0,0,0,0,0,0,149416.66666666666]
[135000,0,0,0,0,0,0,0,0,0,0,0]
[0,0,170000,0,0,0,0,0,0,0,0,0]
[0,0,0,0,120000,0,0,0,0,0,0,0]
[0,0,0,0,0,135000,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,168183.33333333334,0,0]
[0,0,0,0,0,0,0,0,0,0,0,142266.66666666666]
[0,0,0,0,0,0,0,0,0,0,151991.66666666666,0]
[0,142000,0,0,0,0,0,0,0,0,0,0]
[0,0,142666.66666666666,0,0,0,0,0,0,0,0,0]
[0,0,0,164500,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,161000,0,0,0,0]
[0,0,0,0,0,0,0,0,146833.33333333334,0,0,0]
[255000,262366.6666666667,433750,288916.6666666667,260000,285000,125000,291833.3333333333,319316.6666666667,324600,297075,291683.3333333333,"TOTALS"]
[255000,517366.6666666667,951116.6666666667,1240033.3333333335,1500033.3333333335,1785033.3333333335,1910033.3333333335,2201866.666666667,2521183.3333333335,2845783.3333333335,3142858.3333333335,3434541.666666667,"Running TOTALS"]