{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Blatt1","event caclulation "],"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]
["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.849999999999998},null,null,null,"student attendance",20,30,20,20,30,40,35,35]
["folders",10,null,null,null,"regular attendance",20,30,40,50,50,20,50,60]
["bags",11,null,null,null,"break-even reg. price",{"$f":"($B$26+$B$12*(G5+G6)-100*G5)/G6","v":300},{"$f":"($B$26+$B$12*(H5+H6)-100*H5)/H6","v":255},216.25,199.5,206,332.5,209.25,196.45833333333334]
["badges",2]
["program",6.25,"~11 Euro full cover - price for 100 copies"]
["conference dinner",40]
[]
["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]
[null,null,null,null,null,null,null,null,null,270]
["fixed costs",null,null,null,null,null,null,"Early bird deadline:",null,"Two months before conference start"]
["AV",0,"(Don't want, would cost 1950)"]
["poster stands",800,null,null,null,null,null,"Late registration fee",null,"student",150]
["Meals & regist 14 speakers",500,"Will be paid by Lonne",null,1300,null,null,null,null,"full regist",350]
["Social prog 14 speakers",900]
["EasyChair",400]
["Poster prize",100]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B16:B25)","v":2700}]

{"sheet":"event caclulation ","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Services","Quantity","Per item costs","per 80 participants","per 100 participants","per 120 participants",null,"Costs / 80 participants","Costs / 100 participants","Costs / 120 participants"]
[]
["proportial costs",null,"Fill in only cells having this color"]
["coffee breaks",6,0,{"$f":"$B4*$C4*80","v":0},{"$f":"$B4*$C4*100","v":0},{"$f":"$B4*$C4*120","v":0},null,{"$f":"D4","v":0},{"$f":"E4","v":0},{"$f":"F4","v":0}]
["lunches",3,0,{"$f":"$B5*$C5*80","v":0},{"$f":"$B5*$C5*100","v":0},{"$f":"$B5*$C5*120","v":0},null,{"$f":"D5","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0}]
["bags",1,0,0,0,0,null,0,0,0]
["registration service",1,0,0,0,0,null,0,0,0]
["booklet",1,0,0,0,0,null,0,0,0]
["conference dinner (true cost)",1,0,{"$f":"$B9*$C9*80*$B37","v":0},{"$f":"$B9*$C9*100*$B37","v":0},{"$f":"$B9*$C9*120*$B37","v":0},null,0,0,0]
["other",0,0,0,0,0,null,0,0,0]
["other",0,0,0,0,0,null,0,0,0]
[]
[]
[]
[]
["fixed costs","Quantity","Total cost",null,null,null,null,"Fixed costs"]
["conference facility fee",1,0,null,null,null,null,{"$f":"$C17","v":0},{"$f":"$C17","v":0},0]
["credit card services",1,0,null,null,null,null,{"$f":"$C18","v":0},0,0]
["technical assistance",1,0,null,null,null,null,0,0,0]
["poster stand rental",1,0,null,null,null,null,0,0,0]
["Media rental fee",1,0,null,null,null,null,0,0,0]
["Reception",1,0,null,null,null,null,0,0,0]
["Awards / prizes",1,100,"Fixed, don't change",null,null,null,100,100,100]
["Travel invited speakers",6,0,"average cost",null,null,null,{"$f":"$B24*$C24","v":0},{"$f":"$B24*$C24","v":0},0]
["Accomodation invited speakers",18,0,"per night cost",null,null,null,{"$f":"$B25*$C25","v":0},0,0]
["transport hotel to venue (if applicable)",18,0,null,null,null,null,{"$f":"$B26*$C26","v":0},0,0]
["coffee speakers",{"$f":"6*B4","v":36},{"$f":"B27*C4","v":0},"Automatically",null,null,null,0,0,0]
["lunch speakers",{"$f":"6*B5","v":18},{"$f":"B28*C5","v":0},"calculated",null,null,null,0,0,0]
["bags speakers",6,{"$f":"B29*C6","v":0},"based",null,null,null,0,0,0]
["booklet speakers",6,{"$f":"B30*C8","v":0},"on costs",null,null,null,0,0,0]
["conference dinner speakers",6,{"$f":"B31*C37","v":0},"elsewhere",null,null,null,0,0,0]
["Easychair/abstract management",1,400,"Fixed, don't change",null,null,null,400,400,400]
["other",0,0,null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Fixed expenses total",{"$f":"SUM(H17:H33)","v":500},{"$f":"SUM(I17:I33)","v":500},500]
[]
["Conference dinner fees","Attendance %","Price per person",null,null,null,"TOTAL EXPENSES",{"$f":"SUM(H4:H32)","v":500},{"$f":"SUM(I4:I32)","v":500},500]
["(Amount charged to attendees)",0.8,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,"DIFFERENCE",{"$f":"H36-H37","v":500},{"$f":"I36-I37","v":500},500]
["Sponsorship","Amount",null,null,null,null,"Break-even registration fee",{"$f":"H38/80","v":6.25},{"$f":"I38/100","v":5},{"$f":"J38/120","v":4.166666666666667}]
["Total expected sponsorship",0]