{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Documentation","Invoice","Ticket Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Documentation","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Eugene Community Theatre"]
[]
[]
["Author:"]
["Date:"]
[]
["Purpose:","Prepare invoices for theatre patrons"]

{"sheet":"Invoice","index":1,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,2],[23,5,23,9],[22,0,22,2],[1,0,1,2],[13,0,13,2],[12,1,12,2],[21,0,21,1],[21,2,21,3],[9,6,9,8],[10,6,10,8],[11,6,11,8],[2,5,2,9],[3,5,3,9],[4,5,4,9],[8,6,8,8],[23,1,23,2]]}
[]
["Invoice Data"]
["Invoice Date",null,null,null,null,"Eugene Community Theatre"]
["Subscriber",null,null,null,null,"777 Monroe Street"]
["Address",null,null,null,null,"Eugene, OR 70777"]
["City State Zip"]
["Phone",null,null,null,null,null,null,null,"Date:",{"$f":"B3","v":"00:00:00"}]
["Ticket Quantity"]
["Series",null,null,null,null,"Subscriber",{"$f":"B4","v":0}]
["Location",null,null,null,null,"Address",{"$f":"B5","v":0}]
["No. Parking Decals",null,null,null,null,"City State Zip",{"$f":"B6","v":0}]
["Donation",null,null,null,null,"Phone",{"$f":"B7","v":0}]
[]
["Ticket Price Table",null,null,null,null,"Ticket Quantity",null,null,null,{"$f":"B8","v":0}]
["Series","Orchestra","Balcony",null,null,"Series",null,null,null,{"$f":"B9","v":0}]
["A",225,175,null,null,"Location",null,null,null,{"$f":"B10","v":0}]
["B",200,165]
["C",175,150,null,null,"Ticket Cost "]
["D",150,125,null,null,"Handling",null,null,null,{"$f":"B24","v":10}]
["E",125,100,null,null,"Parking",null,"Decals",null,{"$f":"B25*B11","v":0}]
["F",100,75,null,null,"Donation ",null,null,null,{"$f":"B12","v":0}]
[null,null,null,null,null,"Total ",null,null,null,{"$f":"SUM(J18:J21)","v":10}]
["Invoice Constants"]
["Handling Cost",10,null,null,null,"Transfer Area"]
["Parking Fee",15,null,null,null,{"$f":"B4","v":0},{"$f":"B3","v":"00:00:00"},{"$f":"B8","v":0},{"$f":"J18","v":0},{"$f":"J22","v":10}]

{"sheet":"Ticket Data","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer Name","Date","Nbr Tickets","Ticket Amount","Total Amount"]
["Ellen Felton","2013-06-25",1,240,240]
["Mark Johnson","2013-06-25",3,600,663]
["Emily Rosen","2013-06-26",1,200,225]
["Michael Fee","2013-07-01",3,600,600]