{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Showing Statistics","Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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"}

{"sheet":"Showing Statistics","index":0,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
[]
["Event Date","School","City","State","Contact Name","School Position","Contact Phone #","Contact E-mail","Event Attendance","Ticket Price","Total Revenue","# of Attendees Wanting\nto Purchase DVD","Interest in Future Events?","Notes"]
["12/27/2010","Williams High School","Boise","ID","James Jameson","Drama Teacher","(208) 234-5678","james@school.com",50,"5","300","25","Yes","None"]
["3/5/11","Johns Hopkins","Baltimore","MD","Smithy Smithson","Band Teacher","(123) 456-7890","smithy@balty.com","200","6","300","43","Yes",""]
["3/12/11","Adams","New York","CA","John Johnson","Choir Teacher","(987) 654-3210","johnny@cali.com","100","5","110","23","No",""]
["3/12/11","Jimmy John","Salt Lake","IA","Jack Jackson","Band Teacher","(345) 678-9012","jacks@salt.com","100","5","65","21","Yes",""]
["4/1/11","Humphrey Bogart School for the Performing Arts","Los Angeles","NM","Humphrey Wilson","Principal","(287) 287-9045","wilson@humphrey.com","156","6","234","76","Yes",""]

{"sheet":"Analysis","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,6,4,7],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[1,5,1,7],[1,9,1,11],[2,1,2,3],[3,2,3,3],[3,6,3,7],[14,1,14,5],[15,1,15,5],[6,10,6,11],[8,10,8,11],[10,10,10,11],[13,1,13,5],[7,4,7,8],[11,2,11,3],[11,4,11,7],[11,10,11,11],[11,15,11,16],[10,2,10,3],[9,5,10,7],[7,14,7,16],[1,14,1,16],[6,14,6,16],[3,15,3,16],[8,15,8,16],[9,15,9,16],[10,15,10,16],[5,6,5,7],[2,5,2,7],[2,9,2,11],[3,10,3,11],[4,10,4,11],[1,1,1,3]]}
[]
[null,"Assumptions",null,null,null,"Fundraising Statistics",null,null,null,"Sales Figures",null,null,null,null,"DVD Revenue"]
[]
[null,"Cost to Produce\n1 DVD",1.5,null,null,"# of Viewers",606,null,null,"Total Expenses",{"$f":"SUM(C5:D7) + C4*C10","v":4332},null,null,null,"Total DVD Revenue",{"$f":"C9*C10","v":3760}]
[null,"Total Advertising\nCosts",1500,null,null,"Total Revenue to \nDate",1009,null,null,"# of DVD Sales to\nBreak-Even",{"$f":"K4/C9","v":216.6}]
[null,"Total Fundraising\nCosts",1200,null,null,"Ave. Attendance",121.2]
[null,"Total Employee\nWages",1350,null,null,null,null,null,null,"Projected # of DVD\nSales",188,null,null,null,"Hypothetical Scenarios"]
[null,null,null,null,"Please Input Assumptions Before Performing Analysis"]
[null,"Selling Price of 1\nDVD",20,null,null,null,null,null,null,"Projected Revenue\n(Loss)",{"$f":"(K7*C9)-K4","v":-572},null,null,false,"# of Additional\nViewers",34]
[null,"# of Viewers Who\nWill Purchase DVD",188,null,null,null,null,null,null,null,null,null,null,null,"Additional DVD\nSales Revenue",{"$f":"P9*C9","v":680}]
[null,"% of Viewers Who\nWill Purchase DVD\n-Calculated",{"$f":"C10/G4","v":0.31023102310231021},null,null,null,null,null,null,"Additional DVD\nSales Needed",{"$f":"-K9/C9","v":28.6},null,null,null,"Additional DVD\nSales Revenue Less\nAdditional Expense",{"$f":"P10-(P9*C4)","v":629}]
[null,"% of Viewers Who\nWill Purchase DVD\n-Assumption",0.17,null,null,null,null,null,null,"Additional\nScreenings Needed",{"$f":"K11/(G6*C11)","v":0.76063829787234039},null,null,{"$f":"P9/G6","v":0.28052805280528054},"Required # of\nAdditional\nShowings",{"$f":"ROUNDUP(N12, 0)","v":1}]
[]
[null,"These Figures are Estimates"]
[null,"These Figures Come from the Viewings Data"]
[null,"These are Our Calculated Estimates"]