{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blatt1","event calculation "],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Blatt1","index":0,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Per person costs"]
[]
["airport transfer",10.0]
["coffee breaks",{"$f":"3.9*2*3","v":23.4},null,null,null,null,"Break-even registration needed assuming €100 student fee"]
["luches",{"$f":"9.95*3","v":29.85},null,null,null,"student attendance",20.0,30.0,20.0,20.0,30.0,40.0,35.0,35.0]
["folders",10.0,null,null,null,"regular attendance",20.0,30.0,40.0,50.0,50.0,20.0,50.0,60.0]
["bags",11.0,null,null,null,"break-even reg. price",{"$f":"($B$26+$B$12*(G5+G6)-100*G5)/G6","v":300},255,216.25,199.5,206,332.5,209.25,196.4583333]
["badges",2.0]
["program",6.25,"~11 Euro full cover - price for 100 copies"]
["conference dinner",40.0]
[]
["TOTAL",{"$f":"SUM(B3:B10)","v":132.5},null,null,null,null,"proposed registration:",null,null,"€100 - to keep as cheap as possible for students"]
[null,null,null,null,null,null,null,"keynote speakers",null,120.0]
[null,null,null,null,null,null,null,null,null,270.0]
["fixed costs",null,null,null,null,null,null,"Early bird deadline:",null,"Two months before conference start"]
["AV",0.0,"(Don't want, would cost 1950)"]
["poster stands",800.0,null,null,null,null,null,"Late registration fee",null,"student",150.0]
["Meals & regist 14 speakers",500.0,"Will be paid by Lonne",null,1300.0,null,null,null,null,"full regist",350.0]
["Social prog 14 speakers",900.0]
["EasyChair",400.0]
["Poster prize",100.0]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B16:B25)","v":2700}]

{"sheet":"event calculation ","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Services","Quantity","Per item costs","per 80 participants","per 100 participants","per 120 participants",null,"Costs at various attendence levels"]
[null,null,null,null,null,null,null,80.0,100.0,120.0,"total attendees"]
["proportial costs",null,"Fill in only cells having this color!",null,null,null,null,{"$f":"H2*$B43","v":24},30,36,"student attendees"]
["coffee breaks",6.0,0.0,{"$f":"$B4*$C4*80","v":0},{"$f":"$B4*$C4*100","v":0},{"$f":"$B4*$C4*120","v":0},null,{"$f":"D4","v":0},0,0]
["lunches",3.0,0.0,0,0,0,null,{"$f":"D5","v":0},0,0]
["bags",1.0,0.0,0,0,0,null,{"$f":"D6","v":0},0,0]
["registration service",1.0,0.0,0,0,0,null,{"$f":"D7","v":0},0,0]
["booklet",1.0,0.0,0,0,0,null,{"$f":"D8","v":0},0,0]
["conference dinner (per person cost)",1.0,0.0,{"$f":"$B9*$C9*80*$B37","v":0},{"$f":"$B9*$C9*100*$B37","v":0},{"$f":"$B9*$C9*120*$B37","v":0},null,{"$f":"D9","v":0},0,0]
["other",0.0,0.0,{"$f":"$B10*$C10*80","v":0},{"$f":"$B10*$C10*100","v":0},{"$f":"$B10*$C10*120","v":0},null,{"$f":"D10","v":0},0,0]
["other",0.0,0.0,0,0,0,null,{"$f":"D11","v":0},0,0]
[]
[]
[]
[]
["fixed costs","Quantity","Total cost",null,null,null,null,"Fixed costs"]
["conference facility fee",1.0,0.0,null,null,null,null,{"$f":"$C17","v":0},0,0]
["credit card services",1.0,0.0,null,null,null,null,{"$f":"$C18","v":0},0,0]
["technical assistance",1.0,0.0,null,null,null,null,{"$f":"$C19","v":0},0,0]
["poster stand rental",1.0,0.0,null,null,null,null,{"$f":"$C20","v":0},0,0]
["Media rental fee",1.0,0.0,null,null,null,null,{"$f":"$C21","v":0},0,0]
["Reception",1.0,0.0,null,null,null,null,{"$f":"$C22","v":0},0,0]
["Awards / prizes",1.0,100.0,"Fixed, don't change",null,null,null,{"$f":"$C23","v":100},100,100]
["Travel invited speakers/co-chairs",8.0,0.0,"average cost",null,null,null,{"$f":"$B24*$C24","v":0},0,0]
["Accomodation invited speakers/co-chairs",32.0,0.0,"per night cost",null,null,null,{"$f":"$B25*$C25","v":0},0,0]
["transport hotel to venue (if applicable)",32.0,0.0,null,null,null,null,{"$f":"$B26*$C26","v":0},0,0]
["coffee speakers/co-chairs",{"$f":"6*B4","v":36},{"$f":"B27*C4","v":0},"Automatically",null,null,null,{"$f":"$C27","v":0},0,0]
["lunch speakers/co-chairs",36.0,0,"calculated",null,null,null,{"$f":"$C28","v":0},0,0]
["bags speakers",6.0,0,"based",null,null,null,{"$f":"$C29","v":0},0,0]
["booklet speakers",6.0,{"$f":"B30*C8","v":0},"on costs",null,null,null,{"$f":"$C30","v":0},0,0]
["conference dinner speakers/co-chairs",8.0,{"$f":"B31*C37","v":0},"elsewhere",null,null,null,{"$f":"$C31","v":0},0,0]
["Oxford Abstracts",1.0,830.0,"Fixed, don't change",null,null,null,{"$f":"$C32","v":830},830,830]
["other",0.0,0.0,null,null,null,null,{"$f":"$C33","v":0},0,0]
[null,null,null,null,null,null,"Fixed expenses total",{"$f":"SUM(H17:H33)","v":930},930,930]
[]
["Conference dinner fees","Attendance %","Price per person",null,null,null,"TOTAL EXPENSES",{"$f":"SUM(H4:H33)","v":930},930,930]
["(Amount charged to attendees)",0.8,0.0,null,null,null,"Sponsorships + dinner fees",{"$f":"$B40+$B37*$C37*80","v":0},{"$f":"$B40+$B37*$C37*100","v":0},{"$f":"$B40+$B37*$C37*120","v":0}]
[null,null,null,null,null,null,"Student registration income",{"$f":"$C43*H3","v":0},0,0]
["Sponsorship","Amount",null,null,null,null,"DIFFERENCE",{"$f":"H36-H37-H38","v":930},930,930]
["Total expected sponsorship",0.0,null,null,null,null,"Break-even full registration fee",{"$f":"H39/(H2-H3)","v":16.60714286},13.28571429,11.07142857]
[]
["Students","Attendance frac.","Student registration fee"]
["Student fee",0.3,0.0]