{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Forecast Input","Forecast Totals","Forecast Graph"],"not_rendered":{"charts":1,"images":3,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"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":"Forecast Input","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]
[]
["  Instructions: Enter values into the white and yellow cells only."]
["Opportunity\nName","Sales\nAgent","Sales\nRegion","Sales\nCategory","Forecast\nAmount","Sales\nPhase","Probability\nof Sale","Forecast\nClose","Weighted\nForecast"]
["A. Datum Corporation"," Sales Agent 1","US - Northeast","Consulting",150000,"Formal Approval",0.9,"January",135000]
["Adventure Works"," Sales Agent 2","US - Southeast","Products",145200,"Opportunity",0.1,"February",14520]
["Alpine Ski House"," Sales Agent 3","US - North Central","Training",162500,"Identified Need",0.2,"March",32500]
["Baldwin Museum of Science"," Sales Agent 4","US - South Central","Mixture",147500,"Sponsorship",0.3,"April",44250]
["Blue Yonder Airlines"," Sales Agent 5","US - Northwest","Prof. Services",148000,"Budget Validated",0.4,"May",59200]
["City Power & Light"," Sales Agent 1","US - Southwest","Support",175000,"Needs Analysis",0.5,"June",87500]
["Coho Vineyard"," Sales Agent 3","Canada - East","Mixture",149000,"Solution Proposed",0.6,"July",89400]
["Coho Winery"," Sales Agent 5","Canada - West","Training",142000,"Written Proposal",0.7,"August",99400]
["Contoso, Ltd."," Sales Agent 3","EMEA - France","Mixture",172500,"Verbal Approval",0.9,"October",155250]
["Contoso Pharmaceuticals"," Sales Agent 4","EMEA - Germany","Products",163500,"Sponsorship",0.2,"November",32700]
["Consolidated Messenger"," Sales Agent 5","EMEA - Italy","Products",155500,"Formal Approval",1,"December",155500]
["Fabrikam, Inc."," Sales Agent 4","EMEA - Other","Consulting",166000,"Opportunity",0.1,"January",16600]
["Fourth Coffee"," Sales Agent 3","APSA - Asia","Training",180000,"Budget Validated",0.3,"March",54000]
["Graphic Design Institute"," Sales Agent 2","APSA - Pacific","Services",140000,"Solution Proposed",0.6,"May",84000]
["Humongous Insurance"," Sales Agent 1","APSA - Mexico","Support",155000,"Sponsorship",0.3,"June",46500]
["Litware, Inc."," Sales Agent 2","APSA - Australia","Prof. Services",173200,"Needs Analysis",0.5,"October",86600]
["Lucerne Publishing"," Sales Agent 5","APSA - Other","Services",146500,"Solution Proposed",0.6,"December",87900]
["Margie's Travel"," Sales Agent 4","US - Northeast","Support",156750,"Written Proposal",0.7,"November",109725]
["Northwind Traders"," Sales Agent 3","US - South Central","Prof. Services",162000,"Verbal Approval",0.9,"February",145800]
["Proseware, Inc."," Sales Agent 4","Canada - East","Mixture",157000,"Formal Approval",1,"March",157000]
["School of Fine Art"," Sales Agent 3","EMEA - France","Services",173000,"Budget Validated",0.4,"April",69200]
["Southridge Video"," Sales Agent 5","EMEA - UK","Mixture",171000,"Needs Analysis",0.5,"August",85500]
["Tailspin Toys"," Sales Agent 1","APSA - Australia","Products",168000,"Solution Proposed",0.6,"September",100800]
["TOTAL",null,null,null,3659150,null,null,null,1948845]

{"sheet":"Forecast Totals","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]
[]
[]
["January\nForecast","February\nForecast","March\nForecast","April\nForecast","May\nForecast","June\nForecast","July\nForecast","August\nForecast","September\nForecast","October\nForecast","November\nForecast","December\nForecast"]
[135000,0,0,0,0,0,0,0,0,0,0,0]
[0,14520,0,0,0,0,0,0,0,0,0,0]
[0,0,32500,0,0,0,0,0,0,0,0,0]
[0,0,0,44250,0,0,0,0,0,0,0,0]
[0,0,0,0,59200,0,0,0,0,0,0,0]
[0,0,0,0,0,87500,0,0,0,0,0,0]
[0,0,0,0,0,0,89400,0,0,0,0,0]
[0,0,0,0,0,0,0,99400,0,0,0,0]
[0,0,0,0,0,0,0,0,0,155250,0,0]
[0,0,0,0,0,0,0,0,0,0,32700,0]
[0,0,0,0,0,0,0,0,0,0,0,155500]
[16600,0,0,0,0,0,0,0,0,0,0,0]
[0,0,54000,0,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,46500,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,86600,0,0]
[0,0,0,0,0,0,0,0,0,0,0,87900]
[0,0,0,0,0,0,0,0,0,0,109725,0]
[0,145800,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,69200,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,85500,0,0,0,0]
[0,0,0,0,0,0,0,0,100800,0,0,0]
[151600,160320,243500,113450,143200,134000,89400,184900,100800,241850,142425,243400]
[151600,311920,555420,668870,812070,946070,1035470,1220370,1321170,1563020,1705445,1948845]

{"sheet":"Forecast Graph","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["<Company Name>"]
["Detailed Sales Forecast"]
["Company Confidential"]