25:["$","title",null,{"children":"2018 pay offer, HWUCU | scjoss | Observable"}] 4b:T89a,inflation={// set the dimensions and margins of the graph var svg = d3.select(DOM.svg(700, 500)), margin = {top: 40, right: 10, bottom: 20, left: 20}, width = +svg.attr("width") - margin.left - margin.right, height = +svg.attr("height") - margin.top - margin.bottom, //g = svg.append("g").attr("transform", "translate(" + margin.left + ",-" + margin.top + ")"); //FIX THE TRANSLATIONS g = svg.append("g") .attr("transform", "translate("+margin.left+",0)"); //THEN ADD PAYRISE DATA FOR NOMINAL 35000 SALARY //ADD LEGEND AND LABELS // set the ranges const x = d3.scaleLinear().domain([2008,2017]).range([0, width]); const y = d3.scaleLinear().domain([-2,20]).range([height, 0]); // define the 1st line const valueline = d3.line() .curve(d3.curveBasis) .x(function(d) { return x(d.year); }) .y(function(d) { return y(d.rate); }); var color=['yellowgreen','olive','darkkhaki', 'blue','orangered','deeppink', 'orange'] var titles=["RPI","CPI","CPIH","RPIJ","Employee base increase..", "VC average pay increases..", "HWU Principal's salary increase.."] g.selectAll("path") .data(data()) .enter() .append("path") .attr('d',valueline) .attr('class','line') .attr('fill','none') .attr('stroke-width',function(d,i){return i%2==1?3:4}) .attr('stroke',function(d,i){return color[i]}) .attr('id',function(d,i){return titles[i]}) var tp=svg.append("g") .attr("transform", "translate("+margin.left+",-3)"); tp.selectAll("g") .data(data()) .enter() .append("text") .style("font-size", "12px") .append("textPath") .attr("xlink:href", function(d,i){return '#'+titles[i]}) .text(function(d,i){var st=titles[i]; while(st.length<300){st+=titles[i]+' '}; return st }) .attr('fill',function(d,i){return color[i]}) // Add the X Axis svg.append("g") .attr("transform", "translate("+margin.left+"," + height + ")") .call(d3.axisBottom(x)) // //; // Add the Y Axis svg.append("g") .attr("transform", "translate(" + margin.left + ",0)") .call(d3.axisLeft(y)); //.attr("transform", "translate(" + margin.left + ",0)") // return svg.node() }4c:T619,ucu_payspine_data=[ [2,14257,14599,15052, 15417], [3,14631,14953,15356, 15721], [4,14959,15258,15670, 16035], [5,15356,15632,15976, 16341], [6,15765,16017,16289, 16654], [7,16131,16357,16618, 16983], [8,16577,16776,16961, 17326], [9,17039,17209,17399, 17764], [10,17528,17703,17898, 18263], [11,18031,18211,18412, 18777], [12,18549,18734,18940, 19305], [13,19083,19274,19485, 19850], [14,19632,19828,20046, 20411], [15,20198,20400,20624, 20989], [16,20781,20989,21220, 21581], [17,21391,21605,21843, 22214], [18,22029,22249,22494, 22876], [19,22685,22912,23164, 23557], [20,23386,23620,23879, 24285], [21,24057,24298,24565, 24983], [22,24775,25023,25298, 25728], [23,25513,25768,26052, 26495], [24,26274,26537,26829, 27285], [25,27057,27328,27629, 28098], [26,27864,28143,28452, 28936], [27,28695,28982,29301, 29799], [28,29552,29848,30175, 30688], [29,30434,30738,31076, 31604], [30,31342,31655,32004, 32548], [31,32277,32600,32958, 33518], [32,33242,33574,33943, 34520], [33,34233,34575,34956, 35550], [34,35256,35609,36001, 36613], [35,36309,36672,37075, 37706], [36,37394,37768,38183, 38833], [37,38511,38896,39324, 39992], [38,39685,40082,40523, 41212], [39,40847,41255,41709, 42418], [40,42067,42488,42955, 43685], [41,43325,43758,44240, 44992], [42,44620,45066,45562, 46336], [43,45954,46414,46924, 47722], [44,47328,47801,48327, 49149], [45,48743,49230,49772, 50618], [46,50200,50702,51260, 52132], [47,51702,52219,52793, 53691], [48,53248,53780,54372, 55297], [49,54841,55389,55998, 56950], [50,56482,57047,57674, 58655], [51,58172,58754,59400, 60410]]4d:[] 47:{"id":"8f9af46396028d88","slug":"2018-pay-offer-hwucu","title":"2018 pay offer, HWUCU","thumbnail":"a886616ea52ef25933aeabbe255d2d30ee3194858b49904b99ba2575f4a397b7","access_level":"public","create_time":"$D2018-09-04T08:28:39.921Z","update_time":"$D2018-09-06T11:42:03.545Z","view_time":null,"first_public_time":"$D2018-09-04T08:54:19.783Z","has_unpublished_edits":null,"fork":{"id":"22afca7acf4001b7","slug":"2018-pay-offer","title":"2018 pay offer","owner":{"id":"4e0b7814735d54e8","login":"scjoss","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"4e0b7814735d54e8","login":"scjoss","name":"","avatar_url":"https://avatars-next.observableusercontent.com/ea9fef1266e0d838ca6666cf7e030d00255c2b78fcc489e7210ee925975c8136","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1502,"publish_version":1502,"role":null,"authored":false,"authors":[{"type":"individual","id":"c69857c6f0859135","login":"scjoss","name":"","avatar_url":"https://avatars-next.observableusercontent.com/ea9fef1266e0d838ca6666cf7e030d00255c2b78fcc489e7210ee925975c8136","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"c69857c6f0859135","login":"scjoss","name":"","avatar_url":"https://avatars-next.observableusercontent.com/ea9fef1266e0d838ca6666cf7e030d00255c2b78fcc489e7210ee925975c8136","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"2018 pay offer, HWUCU","cells":[{"id":0,"value":"md`# 2018 pay offer, HWUCU`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"md`### Summary of proposed offer \n` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"md`The final offer from employers was 2% for spine point>15 and £425 for spine points<=15 \n` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":132,"value":"md`# Model`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"md`The table shows pay at August 2014, August 2017 and the proposed 2018 pay offer for all spine points above 2 plus the 2018 equivalent of the 2014 salary and the difference between that and the offer.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1045,"value":"md` What you can do:\n* Change the inflation measure, including VC salary inflation and local Principal salary inflation (Controls are below table)\n* View a **specific spine point**.\n* Enter a salary figure from 2008 to see it's equivalent value today.\n* View a graph of inflation measures v employee and VC wage increases`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":754,"value":"table(combined_data_table, {\n sortable: false,\n columns:{\n point:{title:'Spine point'},\n y2014:{title:'Pay August 2014',\n formatter(val) {\n return d3.format(',')(val);\n }\n },\n y2017:{title:'Pay August 2017',\n formatter(val) {\n return d3.format(',')(val);\n }\n },\n proposed:{title:'2018 pay offer',\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n },\n inflation:{title:'2018 equivalent of 2014 pay (inflated using '+chosenInflationMeasure.name+')',\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n },\n difference:{title:'Difference ('+chosenInflationMeasure.name+')',\n formatter(val) { \n return html`${d3.format(',.0f')(val)}`;\n \n \n }\n }\n }\n\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"md`## Inflation`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"md`The **default inflation measure is RPI** (${inflationMeasures[0].longName}) because this is the measure used to inflate **student loan interest**. Inflation rate are taken from ONS figures for July of each year (July is chosen so that we can get figures to date).\n\nFor fun a 4th index has been added- VCRI (${inflationMeasures[3].longName}). Based on data from the UCU`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":982,"value":"md`#### Choose a different measure of inflation`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1078,"value":"selector=html`${measureSelector}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":883,"value":"md`Current inflation measure is **${chosenInflationMeasure.name}**. Use the selector above to change the measure`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":977,"value":"md`## View selected spine point `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1011,"value":"viewof spinePoint= html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":995,"value":"table([combined_data_table[spinePoint-2]], {\n sortable: false,\n columns:{\n point:{title:'Spine point'},\n y2014:{title:'Aug `14',\n formatter(val) {\n return d3.format(',')(val);\n }\n },\n y2017:{title:'Aug `17',\n formatter(val) {\n return d3.format(',')(val);\n }\n },\n proposed:{title:'Pay offer',\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n },\n inflation:{title:'Equivalent',\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n },\n difference:{title:'Real terms difference ('+chosenInflationMeasure.name+')' ,\n formatter(val) {\n return d3.format(',.0f')(val);\n }\n }\n }\n\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"md`## Inflation and wages`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":741,"value":"md`This graph shows the 4 inflation measures, Employee base pay increases (red) %, VCs average pay increases (pink) and Heriot Watt Principal's salary increase (orange) `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":745,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1313,"value":"md` *Staff pay data ${annualEmployeePayIncrease.map(d=>' '+d.year+ '='+d.rate+'%').toString()}* `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1247,"value":"md`Staff pay increases before 2014 are from various sources and are based on best information available. If anyone has better information please send to @josstified`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1421,"value":"md`*A curved line is not ideal for showing wages that step annually. However the stepped graph was unreadable*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1018,"value":"md`## Ten year inflation`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1021,"value":"md`Enter a salary figure for ${2008+yearNum} to see the 2018 real term equivalent using ${chosenInflationMeasure.name}.(As spine point have changed in the interim, you will need to compare this to your actual pay to see the difference) NB.VCRI is only a 4 year series so does not really apply here.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1028,"value":"md`#### Equivalent (${chosenInflationMeasure.name}) ${chosenInflationMeasure.name=='VCRI'?'VCRI cannot be applied over 10 years':d3.format(',.0f')(inflateBy(salary, chosenInflationMeasure.vals.slice(yearNum,chosenInflationMeasure.vals.length)))}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1026,"value":"viewof salary= html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1086,"value":"viewof year=html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1124,"value":" data=function(){\n var measures=[annualRPI, annualCPI, annualCPIH, annualRPIJ]\n var data= measures.map(d=>d.map((d,i)=>({year:2008+i,rate:d})));\n data.push(annualEmployeePayIncrease)\n data.push(annualVCRemunerationIncreases)\n data.push(annualHWPrincipalSalaryIncrease)\n return data\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1250,"value":"md`## Conclusion\nEmployers (and government), pick and choose their inflation measures, tending to use RPI as the measure when increasing incomes (student loans, fees) and CPI when increasing outgoings (wages, benefits). \n\nThe ONS classify CPIH as an official national statistic.\n\n@MikeOtsuka recommends we use RPIJ as this reflects household costs but without the errors caused by using RPI.\n\nViewed over 10 years the pay erosion is significant.\n\nThe downward pressure on wages does not appear to apply VC pay.\n\nUCU asked for 7%. This is why.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":921,"value":"viewof selectedvalue=selector","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":918,"value":"chosenInflationMeasure=inflationMeasures[parseInt(selectedvalue)]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":896,"value":"measureSelector={ \nvar sel=document.createElement(\"select\",{\n \"id\": \"measureSelect\"\n})\nvar fragment = document.createDocumentFragment();\n\ninflationMeasures.forEach(function(measure, index) {\n var opt = document.createElement('option');\n opt.innerHTML = measure.name + ' ('+measure.longName+')';\n opt.value = index;\n fragment.appendChild(opt);\n});\n sel.appendChild(fragment)\nreturn sel}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"inflationmeasure=chosenInflationMeasure.vals.slice(chosenInflationMeasure.vals.length-4,chosenInflationMeasure.vals.length)//we only want hte last 4 values","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":886,"value":"inflationMeasures=[{name:'RPI',vals:annualRPI, longName:\"Retail Prices Index\"},{name:'RPIJ', vals:annualRPIJ, longName:\"Retail Prices Index Jevons\"},{name:'CPI',vals:annualCPI,longName:\"Consumer Prices Index\"},{name:'CPIH',vals:annualCPIH, longName:\"Consumer Price Inflation including owner-occupiers’ Housing costs'\"},{name:'VCRI', vals:annualVCRI, longName:\"Average Vice Chancellor Remuneration Index\"}, {name:'HWPSI', vals:annualHWPSI, longName:'Yearly salary increase % for Principal of HWU'}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"ucu_payspine_data_indexes=['Spine point', '2014','2015','2016','2017']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":786,"value":"combined_data_table=ucu_payspine_data.map((d,i)=>({'point':d[0],'y2014':d[1],'y2017':d[4],proposed:(d[4]*payoffer), inflation:inflateBy(parseInt(d[1]),inflationmeasure), difference:(d[4]*payoffer-inflateBy(parseInt(d[1]),inflationmeasure))}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":843,"value":"inflateBy(100,annualRPI)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":855,"value":"tv=50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":546,"value":"payoffer=1.02","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"frsp=15","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":726,"value":"fr=425","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":729,"value":"annualRPI=[-1.4,4.8,5,3.2,3.1,2.5,1.0,1.9,3.6,3.2]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":836,"value":"inflateBy=(val, measure)=>(val*measure.map(d=>1+d/100).reduce((a,b)=>a*b))//where val is the principal amount and measure is the inflation nidex. Take all values in inflation index convert to %multiplier, get product cuumulative infaltion but mulitplying resulting array. ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":734,"value":"annualCPI=[1.8,3.1,4.4,2.6,2.8,1.6,0.1,0.6,2.6,2.5]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":737,"value":"annualCPIH=[1.6,2.3,3.8,2.4,2.5,1.6,0.5,0.9,2.6,2.3]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1385,"value":"annualRPIJ=[-1.8,4.2,4.3,2.5,2.6,1.8,0.4,1.1,2.9,2.5]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1192,"value":"md`*Source ONS*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"annualEmployeePayIncrease=[{year:2009, rate:0.5},{year:2010, rate:0.4},{year:2012, rate:0.4},{year:2013, rate:1},{year:2014, rate:2},{year:2015, rate:1},{year:2016, rate:1.1},{year:2017, rate:1.7}]//for spine point above 17, and from year 2013? pay is HE only","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1191,"value":"md`*Source UCU pay and negotiations and Cambridge Reporter caveat: some of the data appears to be offers and the 2012 offer seemed to be a flat rate so approx % for spine point 30 was used*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1181,"value":"annualVCRemunerationIncreases=[{year:2014, rate:3},{year:2015, rate:4.6},{year:2016, rate:2},{year:2017, rate:3.2}]//note this takes into account perks as well as pay","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1185,"value":"md`*Source UCU reports on pay and transparency and THE*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1480,"value":"annualHWPrincipalSalaryIncrease=[{year:2012,rate:0},{year:2013, rate:13},{year:2014, rate:8.2},{year:2015,rate:11.6},{year:2016, rate:0.9},{year:2017, rate:18.8}]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1487,"value":"annualHWPSI=annualHWPrincipalSalaryIncrease.map(d=>d.rate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1482,"value":"md`*Source Annual Financial reports of Heriot Watt University. Figure is for salary only and includes the acting principals salary duringhte inter regnum in 2015 (the laternative would have been to use a pro rata for the outgoing/incoming Principals but the result is similar)*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1240,"value":"annualVCRI=annualVCRemunerationIncreases.map(d=>d.rate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1099,"value":"yearNum=parseInt(year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":750,"value":"d3 = require(\"https://d3js.org/d3.v5.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":752,"value":"import {table} from \"@tmcw/tables@444\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null