{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Income 06-07","Expenditure 06-07","Financial Models"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Income 06-07","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["CERL - Income 2006-2007",{"$nulls":4},"Forecast","Forecast",null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[{"$nulls":5},"£","€","NOTES to FORECAST",null,null,"£","€","£","€","£","€"]
[{"$nulls":5},"£1= €",1.48,null,null,null,"£1= €",1.46,"£1= €",1.5,"£1= €",1.52]
[{"$nulls":12},"Variant exchange rates"]
[1,"Membership fees"]
["1.1","Full members",null,null,null,200000,296000,"37 members @ € 8,000",null,null,202739.72602739726,296000,197333.33333333334,296000,194736.84210526315,296000]
["1.2","Group members",null,null,null,21621.621621621623,32000,"1 group @ € 32,000",null,null,21917.80821917808,32000,21333.333333333332,32000,21052.631578947367,32000]
["1.3","Special members",null,null,null,2364.864864864865,3500,"2 members @ € 1,750",null,null,2397.2602739726026,3500,2333.3333333333335,3500,2302.6315789473683,3500]
["1.4","Associate members",null,null,null,1418.918918918919,2100,"14 members @ €150",null,null,1438.3561643835617,2100,1400,2100,1381.578947368421,2100]
[null,"Sub total",null,null,null,225405.40540540538,333600,null,null,null,228493.15068493152,333600,222400.00000000003,333600,219473.6842105263,333600]
[]
[2,"License fees (see FM/2006/3)"]
[null,"I",2000,null,null,2702.702702702703,4000,"2 licenses",null,null,2739.72602739726,4000,2666.6666666666665,4000,2631.578947368421,4000]
[null,"II",1750,null,null,4729.72972972973,7000,"4 licenses",null,null,4794.520547945205,7000,4666.666666666667,7000,4605.263157894737,7000]
[null,"III",1000,null,null,4054.054054054054,6000,"6 licenses",null,null,4109.589041095891,6000,4000,6000,3947.3684210526317,6000]
[null,"IV",500,null,null,337.83783783783787,500,"1 license",null,null,342.4657534246575,500,333.3333333333333,500,328.9473684210526,500]
[null,"Sub total",null,null,null,11824.324324324325,17500,null,null,null,11986.301369863015,17500,11666.666666666668,17500,11513.157894736843,17500]
[]
[3,"Special grants"]
[]
[4,"Revenues",null,null,null,"£1 = $",1.87,null,null,null,"£1 = $",1.87,"£1 = $",1.87,"£1 = $",1.87]
[4.1,"OCLC - royalties for sale of access",null,null,null,5347.5935828877,7914.4385026737955,"$10,000",null,null,5347.5935828877,7807.486631016041,5347.5935828877,8021.3903743315495,5347.5935828877,8128.3422459893045]
[4.2,"Income from chargeable BIB searches",null,null,null,4598.9304812834225,6806.417112299465,"10,000 searches @ $ 0.86",null,null,4598.9304812834225,6714.438502673796,4598.9304812834225,6898.395721925133,4598.9304812834225,6990.374331550803]
[4.3,"Sale of Conf. Proc.",null,null,null,450,666,"Sale of 30 copies @ £15",null,null,450,657,450,675,450,684]
[4.4,"Sale CLCi access",null,null,null,180,266.4,"2 access @ £90",null,null,180,262.8,180,270,180,273.6]
[4.5,"Seminars, workshops etc."]
[null,"Sub total",null,null,null,10576.524064171123,15653.25561497326,null,null,null,10576.524064171123,15441.725133689837,10576.524064171123,15864.786096256683,10576.524064171123,16076.316577540108]
[]
[]
[5,"Bank interest"]
[5.1,"CERL bank accounts",null,null,null,11500,17020,null,null,null,11500,16790,11500,17250,11500,17480]
[5.2,"OCLC - Credit for prepayment"]
[null,"Sub total",null,null,null,11500,17020,null,null,null,11500,16790,11500,17250,11500,17480]
[]
[6,"Other"]
[]
["TOTAL",{"$nulls":4},259306.25379390083,383773.25561497326,null,null,null,262555.97611896566,383331.7251336898,256143.1907308378,384214.7860962567,253063.36616943427,384656.3165775401]

{"sheet":"Expenditure 06-07","index":1,"n_rows":219,"n_cols":17,"rows_kept":219,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["CERL - Expenditure 2006-2007",{"$nulls":5},"Forecast","Forecast",null,null,null,"Forecast","Forecast","Forecast","Forecast","Forecast","Forecast"]
[{"$nulls":6},"£","€","Notes to forecast 2005-2006",null,null,"£","€","£","€","£","€"]
[{"$nulls":6},"£1= €",1.48,null,null,null,"£1= €",1.46,"£1= €",1.5,"£1= €",1.52]
[1,"CENTRAL ADMINISTRATION",{"$nulls":11},"Variant exchange rates"]
["1.1","Salaries"]
[null,"1.1.1.","Company Secretary"]
[null,null,"1.1.1.1.","Gross for employee",null,null,17117.88,25334.4624,"13h/w @ for 48 wks *",null,null,17117.88,24992.1048,17117.88,25676.82,17117.88,26019.177600000003]
[null,null,"1.1.1.2.","Employers' costs"]
[null,null,"1.1.1.3.","Administration"]
[null,null,null,"Sub total",null,null,17117.88,25334.4624,null,null,null,17117.88,24992.1048,17117.88,25676.82,17117.88,26019.177600000003]
[null,"1.1.2.","Executive Manager"]
[null,null,"1.1.2.1.","Gross for employee",null,null,46695.94594594595,69110,"40 hrs *",null,null,47335.61643835616,69110,46073.333333333336,69110,45467.10526315789,69110]
[null,null,"1.1.2.2.","Employers' costs",null,null,5472.972972972973,8100,null,null,null,5547.945205479452,8100,5400,8100,5328.9473684210525,8100]
[null,null,"1.1.2.3.","Administration",null,null,202.7027027027027,300,null,null,null,205.47945205479454,300,200,300,197.3684210526316,300]
[null,null,null,"Sub total",null,null,52371.62162162162,77510,null,null,null,53089.04109589041,77510,51673.333333333336,77510,50993.42105263158,77510]
[null,"1.1.3.","Assistant Secretary"]
[null,null,"1.1.3.1.","Gross for employee",null,null,27070,40063.6,"29 hrs *",null,null,27070,39522.2,27070,40605,27070,41146.4]
[null,null,"1.1.3.2.","Employers' costs",null,null,2835,4195.8,null,null,null,2835,4139.099999999999,2835,4252.5,2835,4309.2]
[null,null,"1.1.3.3.","Administration",null,null,270,250,null,null,null,270,250,270,250,270,250]
[null,null,null,"Sub total",null,null,30175,44659,null,null,null,30175,44055.5,30175,45262.5,30175,45866]
[null,"Sub total",{"$nulls":4},99664.50162162162,147503.46240000002,null,null,null,100381.92109589042,146557.6048,98966.21333333333,148449.32,98286.30105263158,149395.1776]
[{"$nulls":9},"* All salaries include an estimated 2% inflation, as well as an optinal 1% discretionary pay increase"]
["1.2","Accounts and Audit"]
[null,"1.2.1. ","Annual Audit",null,null,null,3760,5564.8,null,null,null,3760,5489.599999999999,3760,5640,3760,5715.2]
[null,"1.2.2. ","Company fees",null,null,null,30,44.4,null,null,null,30,43.8,30,45,30,45.6]
[null,"1.2.3.","Legal fees",null,null,null,3000,4440,null,null,null,3000,4380,3000,4500,3000,4560]
[null,"1.2.4.","Bank charges",null,null,null,1013.5135135135135,1500,null,null,null,1027.3972602739727,1500,1000,1500,986.8421052631579,1500]
[null,"Sub total",{"$nulls":4},7803.513513513513,11549.2,null,null,null,7817.397260273972,11413.4,7790,11685,7776.842105263158,11820.8]
[null,null,null,"BGL - Bowling Green Lane, London"]
["1.3","Accommodation",null,"KB - Royal Library, The Hague"]
[null,"1.3.1.","Rent - BGL",null,null,null,11280,16694.4,"£ 940/m",null,null,11280,16468.8,11280,16920,11280,17145.6]
[null,"1.3.2.","Rent - KB",null,null,null,279.72972972972974,414,"€ 23 / 18m2 / year",null,null,283.56164383561645,414,276,414,272.36842105263156,414]
[null,"1.3.3.","Insurance - BGL",null,null,null,600,888,null,null,null,600,876,600,900,600,912]
[null,"1.3.4.","Cleaning - BGL"]
[null,"1.3.5.","Electricity - BGL",null,null,null,120,177.6,null,null,null,120,175.2,120,180,120,182.4]
[null,"1.3.6.","Security"]
[null,"1.3.7.","Removal costs"]
[null,"1.3.8.","Contingency"]
[null,"Sub total",{"$nulls":4},12279.72972972973,18174,null,null,null,12283.561643835616,17934,12276,18414,12272.368421052632,18654]
[]
["1.4","Office costs"]
[null,"1.4.1.","Stationery and Printing",null,null,null,800,1184,null,null,null,800,1168,800,1200,800,1216]
[null,"1.4.2.","Postage"]
[null,null,"1.4.2.1.","Post office",null,null,275,407,null,null,null,275,401.5,275,412.5,275,418]
[null,null,"1.4.2.2.","BGL mailhandling",null,null,400,592,null,null,null,400,584,400,600,400,608]
[null,null,"1.4.2.3.","Postroom KB",null,null,33.78378378378378,50,null,null,null,34.24657534246575,50,33.333333333333336,50,32.89473684210526,50]
[null,null,"1.4.2.4.","Couriers",null,null,200,296,null,null,null,200,292,200,300,200,304]
[null,null,null,"Sub total",null,null,908.7837837837837,1345,null,null,null,909.2465753424658,1327.5,908.3333333333334,1362.5,907.8947368421052,1380]
[null,"1.4.3.","Communications"]
[null,null,"1.4.3.1. ","Phone/Fax - BGL",null,null,500,740,null,null,null,500,730,500,750,500,760]
[null,null,"1.4.3.2.","Telecomm - BGL",null,null,2500,3700,null,null,null,2500,3650,2500,3750,2500,3800]
[null,null,"1.4.3.3.","Century IT Consultancy - BGL",null,null,450,666,null,null,null,450,657,450,675,450,684]
[null,null,"1.4.3.4.","Phone/Fax - KB",null,null,128.3783783783784,190,null,null,null,130.13698630136986,190,126.66666666666667,190,125,190]
[null,null,"1.4.3.5.","Telecomm - KB",null,null,1013.5135135135135,1500,"PC plus 3 wall outlets",null,null,1027.3972602739727,1500,1000,1500,986.8421052631579,1500]
[null,null,null,"Subtotal",null,null,4591.891891891892,6796,null,null,null,4607.534246575342,6727,4576.666666666666,6865,4561.842105263158,6934]
[null,"1.4.4.","Photocopying"]
[null,null,"1.4.4.1.","Rental"]
[null,null,"1.4.4.2.","Consumables"]
[null,null,"1.4.4.3.","Copy charges"]
[null,null,"1.4.4.4.","External copies"]
[null,null,"1.4.4.5.","Repair/maintenance",null,null,100,148,null,null,null,100,146,100,150,100,152]
[null,null,null,"Sub total",null,null,100,148,null,null,null,100,146,100,150,100,152]
[null,"1.4.5.","Equipment"]
[null,null,"1.4.5.1.","Purchase",null,null,500,740,null,null,null,500,730,500,750,500,760]
[null,null,"1.4.5.2.","Rental"]
[null,null,"1.4.5.3.","Consumables",null,null,250,370,null,null,null,250,365,250,375,250,380]
[null,null,"1.4.5.4.","Repair/maintenance"]
[null,null,null,"Sub total",null,null,750,1110,null,null,null,750,1095,750,1125,750,1140]
[null,"1.4.6.","Furniture"]
[null,null,"1.4.6.1.","Purchase",null,null,100,148,null,null,null,100,146,100,150,100,152]
[null,null,"1.4.6.2.","Rental"]
[null,null,null,"Sub total",null,null,100,148,null,null,null,100,146,100,150,100,152]
[null,"Sub total",{"$nulls":4},7250.675675675675,10731,null,null,null,7266.780821917808,10609.5,7235,10852.5,7219.736842105263,10974]
[]
["1.5","Operating costs"]
[null,"1.5.1. ","Travel costs"]
[null,null,"1.5.1.1.","CSec/ExMan liaison",null,null,1000,1480,null,null,null,1000,1460,1000,1500,1000,1520]
[null,null,"1.5.1.2.","CERL meetings",null,null,4750,7030,null,null,null,4750,6935,4750,7125,4750,7220]
[null,null,null,"Sub total",null,null,5750,8510,null,null,null,5750,8395,5750,8625,5750,8740]
[null,"1.5.3.","Travel insurance",null,null,null,100,148,null,null,null,100,146,100,150,100,152]
[null,"1.5.4.","Meeting costs internal",null,null,null,300,444,null,null,null,300,438,300,450,300,456]
[null,"1.5.5.","Meeting costs external",null,null,null,300,444,null,null,null,300,438,300,450,300,456]
[null,"1.5.6.","Miscellaneous"]
[null,"1.5.7.","Contingency",null,null,null,1000,1480,null,null,null,1000,1460,1000,1500,1000,1520]
[null,"Sub total",{"$nulls":4},7450,11026,null,null,null,7450,10877,7450,11175,7450,11324]
[]
["1.6","Staff training",{"$nulls":4},300,444,null,null,null,300,438,300,450,300,456]
[]
["SUB TOTAL",{"$nulls":5},134748.42054054054,199427.66240000003,null,null,null,135499.66082191782,197829.5048,134017.21333333332,201025.82,133305.24842105265,202623.97759999998]
[]
[2,"CONSULTANCY"]
["2.1","Technical support"]
[null,"2.1.1.","Crossnet hosting ZedMARC",null,null,null,1250,1850,null,null,null,1250,1825,1250,1875,1250,1900]
[null,"2.1.2.","Consultants (TC or other)",null,null,null,5000,7400,null,null,null,5000,7300,5000,7500,5000,7600]
[null,"Sub total",{"$nulls":4},6250,9250,null,null,null,6250,9125,6250,9375,6250,9500]
[]
["2.2","Technical advice on new developments"]
[null,"2.2.1.","TC"]
[null,"2.2.2.","Other"]
[null,"Subtotal",{"$nulls":4},750,1110,null,null,null,750,1095,750,1125,750,1140]
[]
["2.3","ATG consultancy"]
[null,"2.3.1.","Consultancy",null,null,null,1500,2220,null,null,null,1500,2190,1500,2250,1500,2280]
[null,"2.3.2.","Travel to meetings",null,null,null,1013.5135135135135,1500,null,null,null,1027.3972602739727,1500,1000,1500,986.8421052631579,1500]
[null,"Sub total",{"$nulls":4},2513.5135135135133,3720,null,null,null,2527.3972602739727,3690,2500,3750,2486.842105263158,3780]
[]
["2.4","Travel and subsistence/Tel. exp."]
[null,"2.4.1.","TC"]
[null,"2.4.2.","Other"]
[null,"Sub total",{"$nulls":4},1689.1891891891892,2500,null,null,null,1712.3287671232877,2500,1666.6666666666667,2500,1644.7368421052631,2500]
[]
["2.5","Contingency"]
[]
["SUB TOTAL",{"$nulls":5},11202.702702702703,16580,null,null,null,11239.72602739726,16410,11166.666666666666,16750,11131.578947368422,16920]
[]
[3,"HPB FILE PROCESSING"]
[]
["3.1","Vetting and Conversion"]
[null,"3.1.1."]
[null,null,"3.1.1.1.","TC"]
[null,null,"3.1.1.2.","DCG"]
[null,null,"3.1.1.3.","Other"]
[null,null,"Sub total"]
[null,"Sub total"]
[]
["3.2","File updates"]
[null,"3.2.1."]
[null,null,"3.2.1.1.","TC"]
[null,null,"3.2.1.2.","DCG"]
[null,null,"3.2.1.3.","Other"]
[null,null,"Sub total"]
[null,"Sub total"]
[]
["3.3","Downloads"]
[]
["3.4","Miscellaneous"]
[null,"Sub total"]
[null,null,"TC in 05-06",null,null,null,4480,6630.4,"5 files @ 28hrs each",null,null,4480,6540.8,4480,6720,4480,6809.6]
[null,null,"DCG in 05-06",null,null,null,15500,22940,"6 files, taking 7,2 days per file @ € 531/day",null,null,15712.328767123288,22940,15293.333333333334,22940,15092.105263157895,22940]
["SUB TOTAL",{"$nulls":5},19980,29570.4,null,"or 3.6 days per month",null,20192.32876712329,29480.8,19773.333333333336,29660,19572.105263157893,29749.6]
[]
[4,"HPB DATABASE MANAGEMENT",{"$nulls":4},"£1= $",1.87,"$",null,null,"£1= $",1.87,"£1= $",1.87,"£1= $",1.87]
["4.1","Admin fee",{"$nulls":4},10160.42780748663,15037.433155080213,19000,null,null,10160.42780748663,14834.224598930481,10160.42780748663,15240.641711229946,10160.42780748663,15443.85026737968]
["4.2","Subscription fees"]
[null,"4.2.1.","HPB access",null,null,null,7824.598930481283,11580.4064171123,14632,null,"was 4,740",7824.598930481283,11423.914438502672,7824.598930481283,11736.898395721924,7824.598930481283,11893.39037433155]
[null,"4.2.2.","ESTC access",null,null,null,0,0,24498,null,"was 6,260",0,0,0,0,0,0]
[null,"4.2.3.","BIB search block",null,null,null,5882.35294117647,8705.882352941177,11000,null,null,5882.35294117647,8588.235294117647,5882.35294117647,8823.529411764706,5882.35294117647,8941.176470588234]
[null,"4.2.4.","Telecommunications",null,null,null,"N/A","N/A",null,null,null,"N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Sub total",{"$nulls":4},13706.951871657753,20286.288770053477,null,null,null,13706.951871657753,20012.149732620317,13706.951871657753,20560.42780748663,13706.951871657753,20834.566844919784]
["4.3","File loads"]
[null,"4.3.1.","UL Szeged",null,null,null,4010.695187165775,5935.828877005347,"estimate 60 hrs at $125/hr",null,null,4010.695187165775,5855.6149732620315,4010.695187165775,6016.042780748663,4010.695187165775,6096.256684491978]
[null,"4.3.2.","KB Stockholm - legal material",null,null,null,4010.695187165775,5935.828877005347,null,null,null,4010.695187165775,5855.6149732620315,4010.695187165775,6016.042780748663,4010.695187165775,6096.256684491978]
[null,"4.3.3.","UL Helsinki",null,null,null,4010.695187165775,5935.828877005347,null,null,null,4010.695187165775,5855.6149732620315,4010.695187165775,6016.042780748663,4010.695187165775,6096.256684491978]
[null,"4.3.4.","NL Scotland",null,null,null,4010.695187165775,5935.828877005347,null,null,null,4010.695187165775,5855.6149732620315,4010.695187165775,6016.042780748663,4010.695187165775,6096.256684491978]
[null,"4.3.5.","VD16",null,null,null,4010.695187165775,5935.828877005347,null,null,null,4010.695187165775,5855.6149732620315,4010.695187165775,6016.042780748663,4010.695187165775,6096.256684491978]
[null,"Sub total",{"$nulls":4},20053.475935828876,29679.144385026735,null,null,null,20053.475935828876,29278.07486631016,20053.475935828876,30080.213903743315,20053.475935828876,30481.283422459892]
["4.4","Services fee",{"$nulls":6},"N/A"]
["4.5","Documentation/training"]
["4.6","Meeting costs (incl. travel)"]
["4.7","Other"]
["SUB TOTAL",{"$nulls":5},43920.85561497326,65002.86631016043,null,null,null,43920.85561497326,64124.44919786096,43920.85561497326,65881.28342245989,43920.85561497326,66759.70053475935]
[]
[5,"CERL THESAURUS - Development and Maintenance"]
["5.1","Data Conversion Group, Göttingen",{"$nulls":6},"4,71 days/m @ € 531/day"]
[null,"5.1.1","Staff time",null,null,null,20270.27027027027,30000,null,null,null,20547.945205479453,30000,20000,30000,19736.842105263157,30000]
[null,"5.1.2","PND update files",null,null,null,212.83783783783784,315,null,null,null,215.75342465753425,315,210,315,207.23684210526315,315]
[null,null,"Sub total",null,null,null,20483.108108108107,30315,null,null,null,20763.698630136987,30315,20210,30315,19944.07894736842,30315]
["5.2","Manual Editing"]
[null,"5.2.1.","Ute Klier (BSB)",null,null,null,9121.621621621622,13500,"Up to 50h/m @ € 22.50",null,null,9246.575342465754,13500,9000,13500,8881.578947368422,13500]
[null,"5.2.2.","Other"]
[null,null,"Sub total",null,null,null,9121.621621621622,13500,null,null,null,9246.575342465754,13500,9000,13500,8881.578947368422,13500]
["5.3","Miscellaneous"]
["SUB TOTAL",{"$nulls":5},29604.729729729726,43815,null,null,null,30010.273972602743,43815,29210,43815,28825.65789473684,43815]
[]
[6,"DIGITAL RESOURCES"]
["6.1","Preparation of resources",{"$nulls":4},1351.3513513513515,2000,null,null,null,1369.86301369863,2000,1333.3333333333333,2000,1315.7894736842104,2000]
["SUB TOTAL",{"$nulls":5},1351.3513513513515,2000,null,null,null,1369.86301369863,2000,1333.3333333333333,2000,1315.7894736842104,2000]
[]
["7","NEW DATABASE DEVELOPMENT"]
["7.1","Contingency",{"$nulls":4},6756.756756756757,10000,null,null,null,6849.315068493151,10000,6666.666666666667,10000,6578.9473684210525,10000]
["SUB TOTAL",{"$nulls":5},6756.756756756757,10000,null,null,null,6849.315068493151,10000,6666.666666666667,10000,6578.9473684210525,10000]
[]
["8","CERL Portal"]
["8.1","Consultancy / Staffing",{"$nulls":4},13175.675675675675,19500,null,null,null,13356.164383561643,19500,13000,19500,12828.947368421052,19500]
["8.2","Operational service"]
[null,"8.2.1","System maintenance",null,null,null,8108.108108108108,12000,"Server and back up",null,null,8219.178082191782,12000,8000,12000,7894.736842105263,12000]
[null,"8.2.2.","CERL Portal development",null,null,null,6385.135135135135,9450,null,null,null,6472.602739726028,9450,6300,9450,6217.105263157895,9450]
[null,"8.2.3","New developments",null,null,null,1689.1891891891892,2500,null,null,null,1712.3287671232877,2500,1666.6666666666667,2500,1644.7368421052631,2500]
["8.3","Travel expenses",{"$nulls":4},675.6756756756757,1000,null,null,null,684.931506849315,1000,666.6666666666666,1000,657.8947368421052,1000]
["8.4","Miscellaneous",{"$nulls":4},405.4054054054054,600,"PC + wall outlet",null,null,410.95890410958907,600,400,600,394.7368421052632,600]
["SUB TOTAL",{"$nulls":5},30439.189189189194,45050,null,null,null,30856.164383561645,45050,30033.333333333336,45050,29638.15789473684,45050]
[]
["9","PROMOTION"]
["9.1","Marketing and publicity"]
[null,"9.1.1","Printing",null,null,null,1500,2220,null,null,null,1500,2190,1500,2250,1500,2280]
[null,"9.1.2.","Design",null,null,null,1000,1480,null,null,null,1000,1460,1000,1500,1000,1520]
[null,"9.1.3.","Translation",null,null,null,500,740,null,null,null,500,730,500,750,500,760]
[null,"Sub total",{"$nulls":4},3000,4440,null,null,null,3000,4380,3000,4500,3000,4560]
["9.2","Education"]
[null,"9.2.1.","CERL Seminars/Workshops"]
[null,"9.2.2.","Training costs"]
[null,"Sub total",{"$nulls":4},3000,4440,null,null,null,3000,4380,3000,4500,3000,4560]
["9.3","Conferences (not organised for/by CERL)"]
[null,"9.3.1.","Conference fees"]
[null,"9.3.2.","Travel"]
[null,"9.3.2.","Subsistence"]
[null,"Sub total",{"$nulls":4},1250,1850,"2/3 conferences",null,null,1250,1825,1250,1875,1250,1900]
["SUB TOTAL",{"$nulls":5},7250,10730,null,null,null,7250,10585,7250,10875,7250,11020]
[]
["10","[Undefined]"]
[]
["11","RESERVES"]
["11.1","Allocation to Capital Reserve"]
["11.2","Allocation to Restricted Reserve",{"$nulls":4},1500,2220,null,null,null,1500,2190,1500,2250,1500,2280]
["SUB TOTAL",{"$nulls":5},1500,2220,null,null,null,1500,2190,1500,2250,1500,2280]
[]
[null,null,null,"TOTAL EXPENDITURE",null,null,286754.00588524353,424395.9287101604,null,null,null,288688.1876697678,421484.75399786094,284871.4022816399,427307.1034224599,283038.34087813116,430218.27813475934]
[null,null,null,"Total Income",null,null,259306,383773,null,null,null,262556,383332,256143,384215,253063,384656]
[null,null,null,"[Released from assets]",null,null,-27448.005885243532,-40622.92871016043,null,null,null,-26132.187669767824,-38152.75399786094,-28728.402281639923,-43092.10342245991,-29975.34087813116,-45562.27813475934]

{"sheet":"Financial Models","index":2,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Assumptions:",null,"£1 = ",1.48]
[null,"Inc.","CERL stays with the current fee structure and has a stable membership"]
[null,"Exp.","3% inflation on expenditure"]
[]
[null,null,null,"2005-2006 *",null,"2006-2007**",null,"2007-2008",null,"2008-2009",null,"2009-2010"]
[null,null,null,"£","€","£","€","£","€","£","€","£","€"]
["Income",null,null,247879,356556,254576.35135135136,376773,254576.35135135136,376773,254576.35135135136,376773,254576.35135135136,376773]
["Expenditure",null,null,274865,404499,286754,424396,295356.62,437127.88,304217.3186,450241.71640000003,313343.838158,463748.96789200004]
["Deficit",null,null,-26986,-47943,-32177.64864864864,-47623,-40780.268648648635,-60354.880000000005,-49640.96724864864,-73468.71640000003,-58767.48680664867,-86975.96789200004]
["Assets on 30 Sept",null,2005]
[null,"£","€"]
[null,314725,461701,287739,413758,255561.35135135136,366135,214781.08270270273,305780.12,165140.1154540541,232311.40359999996,106372.62864740542,145335.43570799992]
["Restricted Reserve",null,null,56000,81760,57500,83950,59000,86140,60500,88330,62000,90520]
[]
["Free assets",null,null,231739,331998,198061.35135135136,282185,155781.08270270273,219640.12,104640.11545405409,143981.40359999996,44372.62864740542,54815.43570799992]
[]
[null,null,null,"* see also FM/2006/2",null,"** For income see p.3 , for expenditure see FM/2006/7b"]
[]
["Assumptions:",null,"£1 = ",1.48]
[null,"Inc.","CERL stays with the current fee structure and gains one Full Member each year"]
[null,"Exp.","3% inflation on expenditure"]
[]
[null,null,null,"2005-2006 *",null,"2006-2007**",null,"2007-2008",null,"2008-2009",null,"2009-2010"]
[null,null,null,"£","€","£","€","£","€","£","€","£","€"]
["Income",null,null,247879,356556,254576.35135135136,376773,254576.35135135136,376773,254576.35135135136,376773,254576.35135135136,376773]
[{"$nulls":5},5405.405405405406,8000,10810.810810810812,16000,16216.216216216217,24000,21621.621621621623,32000]
["Expenditure",null,null,274865,404499,286754,424396,295356.62,437127.88,304217.3186,450241.71640000003,313343.838158,463748.96789200004]
["Deficit",null,null,-26986,-47943,-26772.243243243225,-39623,-29969.457837837806,-44354.880000000005,-33424.751032432425,-49468.716400000034,-37145.86518502707,-54975.967892000044]
["Assets on 30 Sept",null,2005]
[null,"£","€"]
[null,314725,461701,287739,413758,260966.75675675677,374135,230997.29891891897,329780.12,197572.54788648654,280311.40359999996,160426.68270145947,225335.43570799992]
["Restricted Reserve",null,null,56000,81760,57500,83950,59000,86140,60500,88330,62000,90520]
[]
["Free assets",null,null,231739,331998,203466.75675675677,290185,171997.29891891897,243640.12,137072.54788648654,191981.40359999996,98426.68270145947,134815.43570799992]
[]
[null,null,null,"* see also FM/2006/2",null,"** For income see p.3 , for expenditure see FM/2006/7b"]
[]
["Assumptions:",null,"£1 = ",1.48]
[null,"Inc.","CERL adopts new fee structure and has a stable membership"]
[null,"Exp.","3% inflation on expenditure"]
[]
[null,null,null,"2005-2006 *",null,"2006-2007**",null,"2007-2008",null,"2008-2009",null,"2009-2010"]
[null,null,null,"£","€","£","€","£","€","£","€","£","€"]
["Income",null,null,247879,356556,259306,383773,264373.64864864864,391273,266400.6756756757,394273,266400.6756756757,394273]
["Expenditure",null,null,274865,404499,286754,424396,295356.62,437127.88,304217.3186,450241.71640000003,313343.838158,463748.96789200004]
["Deficit",null,null,-26986,-47943,-27448,-40623,-30982.971351351356,-45854.880000000005,-37816.64292432432,-55968.716400000034,-46943.16248232435,-69475.96789200004]
["Assets on 30 Sept",null,2005]
[null,"£","€"]
[null,314725,461701,287739,413758,260291,373135,229308.02864864864,327280.12,191491.38572432433,271311.40359999996,144548.22324199998,201835.43570799992]
["Restricted Reserve",null,null,56000,81760,57500,83950,59000,86140,60500,88330,62000,90520]
[]
["Free assets",null,null,231739,331998,202791,289185,170308.02864864864,241140.12,130991.38572432433,182981.40359999996,82548.22324199998,111315.43570799992]
[]
[null,null,null,"* see also FM/2006/2",null,"** For income and expenditure see FM/2006/7b"]
[]
["Assumptions:",null,"£1 = ",1.48]
[null,"Inc.","CERL adopts new fee structure and gains one new Full Member each year"]
[null,"Exp.","3% inflation on expenditure"]
[]
[null,null,null,"2005-2006 *",null,"2006-2007**",null,"2007-2008",null,"2008-2009",null,"2009-2010"]
[null,null,null,"£","€","£","€","£","€","£","€","£","€"]
["Income",null,null,247879,356556,259306,383773,264373.64864864864,391273,266400.6756756757,394273,266400.6756756757,394273]
[{"$nulls":5},5405.405405405406,8000,10810.810810810812,16000,16216.216216216217,24000,21621.621621621623,32000]
["Expenditure",null,null,274865,404499,286754,424396,295356.62,437127.88,304217.3186,450241.71640000003,313343.838158,463748.96789200004]
["Deficit",null,null,-26986,-47943,-22042.594594594615,-32623,-20172.160540540528,-29854.880000000005,-21600.426708108105,-31968.716400000034,-25321.54086070275,-37475.967892000044]
["Assets on 30 Sept",null,2005]
[null,"£","€"]
[null,314725,461701,287739,413758,265696.4054054054,381135,245524.24486486486,351280.12,223923.81815675675,319311.40359999996,198602.277296054,281835.4357079999]
["Restricted Reserve",null,null,56000,81760,57500,83950,59000,86140,60500,88330,62000,90520]
[]
["Free assets",null,null,231739,331998,208196.40540540538,297185,186524.24486486486,265140.12,163423.81815675675,230981.40359999996,136602.277296054,191315.43570799992]
[]
[null,null,null,"* see also FM/2006/2",null,"** For income and expenditure see FM/2006/7b"]
[]
[]
["See also FM/2006/3:",null,null,"Current structure",{"$nulls":5},"2006/07","2007/08","2008/09","2009/2010"]
[null,null,null,"Full ",37,8000,null,null,null,296000]
[null,null,null,"Group",6,8000,null,null,null,32000]
[null,null,null,"Associate",14,150,null,null,null,2100]
[null,null,null,"Special",14,1000,null,null,null,14000]
[{"$nulls":9},344100,344100,344100,344100]
[null,null,null,"Proposed structure",null,"2006/07","2007/08","2008/09",null,"2006/07","2007/08","2008/09","2009/2010"]
[null,null,null,"Full",37,8000,8000,8000,null,296000,296000,296000,296000]
[null,null,null,"Group",6,8000,8000,8000,null,32000,32000,32000,32000]
[null,null,null,"Associate",14,150,150,150,null,2100,2100,2100,2100]
[null,null,null,"Tariff I",2,2000,3500,5000,null,4000,7000,10000,10000]
[null,null,null,"Tariff II",6,1750,2500,2500,null,10500,15000,15000,15000]
[null,null,null,"Tariff III",6,1000,1000,1000,null,6000,6000,6000,6000]
[null,null,null,"Tariff IV",1,500,500,500,null,500,500,500,500]
[{"$nulls":9},351100,358600,361600,361600]
[null,null,null,"Additional Income",{"$nulls":5},32673,32673,32673,32673]