{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Blatt1","event caclulation "],"read":"whole","date_system":"1900"}

{"sheet":"Blatt1","index":0,"n_rows":26,"n_cols":14,"rows_kept":26}
["Per person costs"]
[]
["airport transfer",{"v":10,"d":"€10.00"}]
["coffee breaks",{"$f":"3.9*2*3","v":{"v":23.4,"d":"€23.40"}},{"$nulls":4},"Break-even registration needed assuming €100 student fee"]
["luches",{"$f":"9.95*3","v":{"v":29.849999999999998,"d":"€29.85"}},{"$nulls":3},"student attendance",20,30,20,20,30,40,35,35]
["folders",{"v":10,"d":"€10.00"},{"$nulls":3},"regular attendance",20,30,40,50,50,20,50,60]
["bags",{"v":11,"d":"€11.00"},{"$nulls":3},"break-even reg. price",{"$f":"($B$26+$B$12*(G5+G6)-100*G5)/G6","v":{"v":300,"d":"€300.00"}},{"$f":"($B$26+$B$12*(H5+H6)-100*H5)/H6","v":{"v":255,"d":"€255.00"}},{"v":216.25,"d":"€216.25"},{"v":199.5,"d":"€199.50"},{"v":206,"d":"€206.00"},{"v":332.5,"d":"€332.50"},{"v":209.25,"d":"€209.25"},{"v":196.45833333333334,"d":"€196.46"}]
["badges",{"v":2,"d":"€2.00"}]
["program",{"v":6.25,"d":"€6.25"},"~11 Euro full cover - price for 100 copies"]
["conference dinner",{"v":40,"d":"€40.00"}]
[]
["TOTAL",{"$f":"SUM(B3:B10)","v":{"v":132.5,"d":"€132.50"}},{"$nulls":4},"proposed registration:",null,null,"€100 - to keep as cheap as possible for students"]
[{"$nulls":7},"keynote speakers",null,{"v":120,"d":"€120"}]
[{"$nulls":9},{"v":270,"d":"€270"}]
["fixed costs",{"$nulls":6},"Early bird deadline:",null,"Two months before conference start"]
["AV",{"v":0,"d":"€0.00"},"(Don't want, would cost 1950)"]
["poster stands",{"v":800,"d":"€800.00"},{"$nulls":5},"Late registration fee",null,"student",{"v":150,"d":"€150"}]
["Meals & regist 14 speakers",{"v":500,"d":"€500.00"},"Will be paid by Lonne",null,1300,{"$nulls":4},"full regist",{"v":350,"d":"€350"}]
["Social prog 14 speakers",{"v":900,"d":"€900.00"}]
["EasyChair",{"v":400,"d":"€400.00"}]
["Poster prize",{"v":100,"d":"€100.00"}]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B16:B25)","v":{"v":2700,"d":"€2,700.00"}}]

{"sheet":"event caclulation ","index":1,"n_rows":43,"n_cols":11,"rows_kept":43}
["Services","Quantity","Per item costs","per 80 participants","per 100 participants","per 120 participants",null,"Costs at various attendence levels"]
[{"$nulls":7},80,100,120,"total attendees"]
["proportial costs",null,"Fill in only cells having this color!",{"$nulls":4},{"$f":"H2*$B43","v":24},{"$f":"I2*$B43","v":30},36,"student attendees"]
["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 (per person 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",{"$nulls":4},"Fixed costs"]
["conference facility fee",1,0,{"$nulls":4},{"$f":"$C17","v":0},{"$f":"$C17","v":0},0]
["credit card services",1,0,{"$nulls":4},{"$f":"$C18","v":0},0,0]
["technical assistance",1,0,{"$nulls":4},0,0,0]
["poster stand rental",1,0,{"$nulls":4},0,0,0]
["Media rental fee",1,0,{"$nulls":4},0,0,0]
["Reception",1,0,{"$nulls":4},0,0,0]
["Awards / prizes",1,100,"Fixed, don't change",{"$nulls":3},100,100,100]
["Travel invited speakers",6,0,"average cost",{"$nulls":3},{"$f":"$B24*$C24","v":0},{"$f":"$B24*$C24","v":0},0]
["Accomodation invited speakers",18,0,"per night cost",{"$nulls":3},{"$f":"$B25*$C25","v":0},0,0]
["transport hotel to venue (if applicable)",18,0,{"$nulls":4},{"$f":"$B26*$C26","v":0},0,0]
["coffee speakers",{"$f":"6*B4","v":36},{"$f":"B27*C4","v":0},"Automatically",{"$nulls":3},0,0,0]
["lunch speakers",{"$f":"6*B5","v":18},{"$f":"B28*C5","v":0},"calculated",{"$nulls":3},0,0,0]
["bags speakers",6,{"$f":"B29*C6","v":0},"based",{"$nulls":3},0,0,0]
["booklet speakers",6,{"$f":"B30*C8","v":0},"on costs",{"$nulls":3},0,0,0]
["conference dinner speakers",6,{"$f":"B31*C37","v":0},"elsewhere",{"$nulls":3},0,0,0]
["Easychair/abstract management",1,400,"Fixed, don't change",{"$nulls":3},400,400,400]
["other",0,0,{"$nulls":4},0,0,0]
[{"$nulls":6},"Fixed expenses total",{"$f":"SUM(H17:H33)","v":500},{"$f":"SUM(I17:I33)","v":500},500]
[]
["Conference dinner fees","Attendance %","Price per person",{"$nulls":3},"TOTAL EXPENSES",{"$f":"SUM(H4:H33)","v":500},{"$f":"SUM(I4:I33)","v":500},{"$f":"SUM(J4:J33)","v":500}]
["(Amount charged to attendees)",{"v":0.8,"d":"80%"},0,{"$nulls":3},"Sponsorships + dinner fees",{"$f":"$B40+$B37*$C37*80","v":0},{"$f":"$B40+$B37*$C37*100","v":0},{"$f":"$B40+$B37*$C37*120","v":0}]
[{"$nulls":6},"Student registration income",{"$f":"$C43*H3","v":0},{"$f":"$C43*I3","v":0},0]
["Sponsorship","Amount",{"$nulls":4},"DIFFERENCE",{"$f":"H36-H37-H38","v":500},{"$f":"I36-I37-I38","v":500},500]
["Total expected sponsorship",0,{"$nulls":4},"Break-even full registration fee",{"$f":"H39/(H2-H3)","v":{"v":8.928571428571429,"d":"9"}},{"$f":"I39/(I2-I3)","v":{"v":7.142857142857143,"d":"7"}},{"v":5.9523809523809526,"d":"6"}]
[]
["Students","Attendance frac.","Student registration fee"]
["Student fee",{"v":0.3,"d":"30%"},0]