{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Sales Costing","Expense Chart","Pipeline Chart"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Expense Chart","index":1,"reason":"not_a_worksheet"},{"sheet":"Pipeline Chart","index":2,"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":"Sales Costing","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,2,25,3],[26,2,26,3],[27,2,27,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[15,2,15,3],[16,2,16,3],[18,2,18,3],[17,2,17,3],[14,2,14,3],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[9,2,9,3],[10,2,10,3],[11,2,11,3],[14,5,14,7],[1,2,1,8],[13,2,13,3],[12,2,12,3],[8,2,8,3],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[15,5,15,7],[16,5,16,7],[8,5,8,7],[20,5,20,7],[25,5,25,7],[17,5,17,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[24,5,24,7]],"flags":["formulas_cached_only"]}
[]
[null,null,"Sales Costing Calculator"]
[]
[null,null,"Model Key"]
[null,null,"Numbers in white cells are entered by user."]
[null,null,"Numbers in gray cells are calculated for you. These generally should not be altered."]
[]
[]
[null,null,"Expense category",null,"Expense","Notes"]
[null,null,"Sales force salary",null,180000]
[null,null,"Travel",null,115000,"per year"]
[null,null,"Advertising",null,175000,"per year"]
[null,null,"Entertainment",null,112000,"per year"]
[null,null,"Catalog production",null,150000,"per year"]
[null,null,"Marketing department salaries",null,260000,"per year entire department"]
[null,null,"Telemarketing costs",null,112000,"per year"]
[null,null,"Mailing expenses",null,118500,"per year ($1,500 per mailing)"]
[]
[null,null,"Total",null,1222500]
[]
[null,null,"Customers",null,"Sales this year","% of sales expenses"]
[null,null,"Adventure Works",null,575665,0.47089161554192227]
[null,null,"Trey Research",null,120000,0.09815950920245399]
[null,null,"Fourth Coffee",null,345678,0.2827631901840491]
[null,null,"Lucerne Publishing",null,234765,0.19203680981595092]
[]
[null,null,"Totals",null,1276108,1.0438511247443762]