{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["New drug and cost estimates"],"not_rendered":{"charts":4,"external_links":1,"comments":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"New drug and cost estimates","index":0,"n_rows":66,"n_cols":32,"rows_kept":66,"merged":[[0,1,0,4],[0,5,0,11],[0,24,0,29],[2,4,47,4],[2,11,8,11],[9,11,27,11],[28,11,62,11],[48,4,62,4]],"flags":["formulas_cached_only"]}
[null,"New drug output data",{"$nulls":3},"R&D cost data and assumptions",{"$nulls":18},"Linear regressions for 10 year gradients"]
["Year","NMEs","Biologics","New drug","Comments on new drug data","US government estimate of US R&D spend in the drug industry, 1956-1980","PhRMA R&D spend. From Table 1 of PhRMA annual survey 2011. PhRMA members only.","Industry R&D spend. From PhRMA annual survey 2011. PhRMA members plus all others","Estimated nominal growth in biopharma R&D spending","Estimate of real terms growth based on aggregrate data","Estimate of total R&D spend in 2008 dollars","Comments on cost data and estimates","Estimated new drugs per $bn 2008",{"$nulls":4},"Year","New drugs per bn$ R&D","New drugs","Long-term average","New drugs per bn$ R&D 5 years ago","Year","Log (drugs per $bn)","1950-1960","1960-1970","1970-1980","1980-1990","1990-2000","2000-2010"]
[1950,10,null,10,"From 1950 to 1995, data are from Munos (REF. 24)",{"$nulls":3},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.3157340445730698,"d":"0.3"},"Cost estimated from long term average trend from 1956-2010, also consistent with Munos (REF. 24)",{"v":31.672225950552242,"d":"31.67"},{"$nulls":4},1950,{"v":31.672225950552242,"d":"31.67"},10,{"v":20.933333333333334,"d":"20.9"},null,1950,{"v":1.5006785870242692,"d":"1.50"},{"v":1.625,"d":"1.63"},{"$nulls":6},"Total number of new drugs"]
[1951,15,null,15,{"$nulls":4},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.34193997027263456,"d":"0.3"},null,{"v":43.86734896198372,"d":"43.87"},{"$nulls":4},1951,{"v":43.86734896198372,"d":"43.87"},15,{"v":20.933333333333334,"d":"20.9"},null,1951,{"v":1.6421413894546302,"d":"1.64"},{"v":1.6124999999999972,"d":"1.61"}]
[1952,11,null,11,{"$nulls":4},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.37032098780526324,"d":"0.4"},null,{"v":29.70396051596312,"d":"29.70"},{"$nulls":4},1952,{"v":29.70396051596312,"d":"29.70"},11,{"v":20.933333333333334,"d":"20.9"},null,1952,{"v":1.4728143589318536,"d":"1.47"},{"v":1.5999999999999979,"d":"1.60"}]
[1953,26,null,26,{"$nulls":4},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.40105762979310006,"d":"0.4"},null,{"v":64.82858838370194,"d":"64.83"},{"$nulls":4},1953,{"v":64.82858838370194,"d":"64.83"},26,{"v":20.933333333333334,"d":"20.9"},null,1953,{"v":1.8117665651191261,"d":"1.81"},{"v":1.5874999999999986,"d":"1.59"}]
[1954,24,null,24,{"$nulls":4},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.43434541306592733,"d":"0.4"},null,{"v":55.25556222774511,"d":"55.26"},{"$nulls":4},1954,{"v":55.25556222774511,"d":"55.26"},24,{"v":20.933333333333334,"d":"20.9"},null,1954,{"v":1.742376002234594,"d":"1.74"},{"v":1.5749999999999993,"d":"1.58"}]
[1955,18,null,18,{"$nulls":4},{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.47039608235039926,"d":"0.5"},null,{"v":38.26562481145783,"d":"38.27"},{"$nulls":4},1955,{"v":38.26562481145783,"d":"38.27"},18,{"v":20.933333333333334,"d":"20.9"},{"v":57.010006710994034,"d":"57.01"},1955,{"v":1.5828088090009738,"d":"1.58"},{"v":1.5625,"d":"1.56"}]
[1956,17,null,17,null,{"v":0.094,"d":"0.09"},null,null,{"v":0.12252647179395139,"d":"12.3%"},{"v":0.083,"d":"8.3%"},{"v":0.5094389571854824,"d":"0.5"},null,{"v":33.370043182250086,"d":"33.37"},{"$nulls":4},1956,{"v":33.370043182250086,"d":"33.37"},17,{"v":20.933333333333334,"d":"20.9"},{"v":49.71632882358155,"d":"49.72"},1956,{"v":1.523356768650621,"d":"1.52"},{"v":1.5499999999999972,"d":"1.55"}]
[1957,24,null,24,null,{"v":0.104,"d":"0.10"},null,null,{"v":0.1063829787234043,"d":"10.6%"},{"v":0.06938297872340429,"d":"6.9%"},{"v":0.5517223906318774,"d":"0.6"},"Use growth rates reported in a consistent US data set from 1956 to 1980 to rather than absolute US spend. Assume global industry spending growth proportional to US spending growth",{"v":43.50013776405421,"d":"43.50"},{"$nulls":4},1957,{"v":43.50013776405421,"d":"43.50"},24,{"v":20.933333333333334,"d":"20.9"},{"v":64.80864112573772,"d":"64.81"},1957,{"v":1.6384906323586328,"d":"1.64"},{"v":1.5374999999999979,"d":"1.54"}]
[1958,14,null,14,null,{"v":0.128,"d":"0.13"},null,null,{"v":0.23076923076923084,"d":"23.1%"},{"v":0.19376923076923083,"d":"19.4%"},{"v":0.5900025335223148,"d":"0.6"},null,{"v":23.728711665727953,"d":"23.73"},{"$nulls":4},1958,{"v":23.728711665727953,"d":"23.73"},14,{"v":20.933333333333334,"d":"20.9"},{"v":34.907701437377966,"d":"34.91"},1958,{"v":1.3752741591337232,"d":"1.38"},{"v":1.5249999999999986,"d":"1.53"}]
[1959,30,null,30,null,{"v":0.154,"d":"0.15"},null,null,{"v":0.203125,"d":"20.3%"},{"v":0.166125,"d":"16.6%"},{"v":0.7043268705948311,"d":"0.7"},null,{"v":42.59385982912145,"d":"42.59"},{"$nulls":4},1959,{"v":42.59385982912145,"d":"42.59"},30,{"v":20.933333333333334,"d":"20.9"},{"v":69.06945278468139,"d":"69.07"},1959,{"v":1.6293469973532393,"d":"1.63"},{"v":1.5124999999999993,"d":"1.51"}]
[1960,21,null,21,null,{"v":0.162,"d":"0.16"},null,null,{"v":0.051948051948051965,"d":"5.2%"},{"v":0.014948051948051967,"d":"1.5%"},{"v":0.8213331719723975,"d":"0.8"},null,{"v":25.568186841363502,"d":"25.57"},{"$nulls":4},1960,{"v":25.568186841363502,"d":"25.57"},21,{"v":20.933333333333334,"d":"20.9"},{"v":44.6432289467008,"d":"44.64"},1960,{"v":1.4076999312836422,"d":"1.41"},{"v":1.5,"d":"1.50"},{"v":1.3259999999999934,"d":"1.33"}]
[1961,18,null,18,null,0.18,null,null,{"v":0.11111111111111094,"d":"11.1%"},{"v":0.07411111111111093,"d":"7.4%"},{"v":0.8336105028936993,"d":"0.8"},null,{"v":21.592818153702332,"d":"21.59"},{"$nulls":4},1961,{"v":21.592818153702332,"d":"21.59"},18,{"v":20.933333333333334,"d":"20.9"},{"v":35.33298689885304,"d":"35.33"},1961,{"v":1.3343093273147923,"d":"1.33"},null,{"v":1.2685999999999922,"d":"1.27"}]
[1962,12,null,12,null,{"v":0.195,"d":"0.20"},null,null,{"v":0.08333333333333348,"d":"8.3%"},{"v":0.04633333333333348,"d":"4.6%"},{"v":0.8953903034970434,"d":"0.9"},null,{"v":13.40197671689397,"d":"13.40"},{"$nulls":4},1962,{"v":13.40197671689397,"d":"13.40"},12,{"v":20.933333333333334,"d":"20.9"},{"v":21.750068882027104,"d":"21.75"},1962,{"v":1.1271688591055478,"d":"1.13"},null,{"v":1.2112000000000052,"d":"1.21"}]
[1963,13,null,13,null,{"v":0.216,"d":"0.22"},null,null,{"v":0.10769230769230753,"d":"10.8%"},{"v":0.07069230769230753,"d":"7.1%"},{"v":0.9368767208924066,"d":"0.9"},null,{"v":13.87589179034896,"d":"13.88"},{"$nulls":4},1963,{"v":13.87589179034896,"d":"13.88"},13,{"v":20.933333333333334,"d":"20.9"},{"v":22.03380368960453,"d":"22.03"},1963,{"v":1.1422609043843797,"d":"1.14"},null,{"v":1.153800000000004,"d":"1.15"}]
[1964,16,null,16,null,{"v":0.238,"d":"0.24"},null,null,{"v":0.10185185185185186,"d":"10.2%"},{"v":0.06485185185185185,"d":"6.5%"},{"v":1.0031066983154928,"d":"1.0"},null,{"v":15.95044677387624,"d":"15.95"},{"$nulls":4},1964,{"v":15.95044677387624,"d":"15.95"},16,{"v":20.933333333333334,"d":"20.9"},{"v":22.71672524219811,"d":"22.72"},1964,{"v":1.2027728522027086,"d":"1.20"},null,{"v":1.0964000000000027,"d":"1.10"}]
[1965,11,null,11,null,{"v":0.274,"d":"0.27"},null,null,{"v":0.1512605042016808,"d":"15.1%"},{"v":0.1142605042016808,"d":"11.4%"},{"v":1.0681600253062495,"d":"1.1"},null,{"v":10.298082440265649,"d":"10.30"},{"$nulls":4},1965,{"v":10.298082440265649,"d":"10.30"},11,{"v":20.933333333333334,"d":"20.9"},{"v":13.392859774047547,"d":"13.39"},1965,{"v":1.012756364206029,"d":"1.01"},null,{"v":1.0390000000000015,"d":"1.04"}]
[1966,12,null,12,null,{"v":0.318,"d":"0.32"},null,null,{"v":0.16058394160583944,"d":"16.1%"},{"v":0.12358394160583944,"d":"12.4%"},{"v":1.190208528365822,"d":"1.2"},null,{"v":10.082266858292655,"d":"10.08"},{"$nulls":4},1966,{"v":10.082266858292655,"d":"10.08"},12,{"v":20.933333333333334,"d":"20.9"},{"v":14.395212102468221,"d":"14.40"},1966,{"v":1.0035581881973685,"d":"1.00"},null,{"v":0.9816000000000003,"d":"0.98"}]
[1967,16,null,16,null,{"v":0.343,"d":"0.34"},null,null,{"v":0.07861635220125796,"d":"7.9%"},{"v":0.04161635220125796,"d":"4.2%"},{"v":1.337299189634156,"d":"1.3"},null,{"v":11.964413142564686,"d":"11.96"},{"$nulls":4},1967,{"v":11.964413142564686,"d":"11.96"},16,{"v":20.933333333333334,"d":"20.9"},{"v":17.869302289191957,"d":"17.87"},1967,{"v":1.07789140121971,"d":"1.08"},null,{"v":0.924199999999999,"d":"0.92"}]
[1968,6,null,6,null,{"v":0.394,"d":"0.39"},null,null,{"v":0.14868804664723023,"d":"14.9%"},{"v":0.11168804664723023,"d":"11.2%"},{"v":1.392952703708428,"d":"1.4"},null,{"v":4.307396786715248,"d":"4.31"},{"$nulls":4},1968,{"v":4.307396786715248,"d":"4.31"},6,{"v":20.933333333333334,"d":"20.9"},{"v":6.404257749391828,"d":"6.40"},1968,{"v":0.6342148797365333,"d":"0.63"},null,{"v":0.8667999999999978,"d":"0.87"},{"$nulls":5},"Total number of new drugs per $bn inflation-adjusted R&D costs"]
[1969,10,null,10,null,{"v":0.437,"d":"0.44"},null,null,{"v":0.1091370558375635,"d":"10.9%"},{"v":0.0721370558375635,"d":"7.2%"},{"v":1.5485288702576003,"d":"1.5"},null,{"v":6.4577420492886795,"d":"6.46"},{"$nulls":4},1969,{"v":6.4577420492886795,"d":"6.46"},10,{"v":20.933333333333334,"d":"20.9"},{"v":9.96902923367265,"d":"9.97"},1969,{"v":0.8100806933897341,"d":"0.81"},null,{"v":0.8093999999999966,"d":"0.81"}]
[1970,14,null,14,null,{"v":0.485,"d":"0.49"},null,null,{"v":0.10983981693363831,"d":"11.0%"},{"v":0.07283981693363831,"d":"7.3%"},{"v":1.660235183837452,"d":"1.7"},null,{"v":8.432540242666422,"d":"8.43"},{"$nulls":4},1970,{"v":8.432540242666422,"d":"8.43"},14,{"v":20.933333333333334,"d":"20.9"},{"v":13.106650378519918,"d":"13.11"},1970,{"v":0.9259584224525537,"d":"0.93"},null,{"v":0.7519999999999953,"d":"0.75"},{"v":0.789999999999992,"d":"0.79"}]
[1971,11,null,11,null,{"v":0.549,"d":"0.55"},null,null,{"v":0.13195876288659814,"d":"13.2%"},{"v":0.09495876288659813,"d":"9.5%"},{"v":1.7811664106949576,"d":"1.8"},null,{"v":6.1757284069309,"d":"6.18"},{"$nulls":4},1971,{"v":6.1757284069309,"d":"6.18"},11,{"v":20.933333333333334,"d":"20.9"},{"v":9.242077953434935,"d":"9.24"},1971,{"v":0.7906881885639494,"d":"0.79"},null,null,{"v":0.7557999999999936,"d":"0.76"}]
[1972,7,null,7,null,{"v":0.607,"d":"0.61"},null,null,{"v":0.10564663023679399,"d":"10.6%"},{"v":0.06864663023679399,"d":"6.9%"},{"v":1.9503037695497134,"d":"2.0"},null,{"v":3.5891844692563772,"d":"3.59"},{"$nulls":4},1972,{"v":3.5891844692563772,"d":"3.59"},7,{"v":20.933333333333334,"d":"20.9"},{"v":5.23443074987205,"d":"5.23"},1972,{"v":0.554995779849352,"d":"0.55"},null,null,{"v":0.7215999999999951,"d":"0.72"}]
[1973,13,null,13,null,{"v":0.698,"d":"0.70"},null,null,{"v":0.14991762767710037,"d":"15.0%"},{"v":0.11291762767710037,"d":"11.3%"},{"v":2.084185551267418,"d":"2.1"},null,{"v":6.237448480580121,"d":"6.24"},{"$nulls":4},1973,{"v":6.237448480580121,"d":"6.24"},13,{"v":20.933333333333334,"d":"20.9"},{"v":9.332693037883038,"d":"9.33"},1973,{"v":0.7950069715064495,"d":"0.80"},null,null,{"v":0.6873999999999967,"d":"0.69"}]
[1974,18,null,18,null,{"v":0.807,"d":"0.81"},null,null,{"v":0.1561604584527223,"d":"15.6%"},{"v":0.1191604584527223,"d":"11.9%"},{"v":2.319526839355425,"d":"2.3"},null,{"v":7.760203371909261,"d":"7.76"},{"$nulls":4},1974,{"v":7.760203371909261,"d":"7.76"},18,{"v":20.933333333333334,"d":"20.9"},{"v":11.623935688719623,"d":"11.62"},1974,{"v":0.8898731029773392,"d":"0.89"},null,null,{"v":0.6531999999999982,"d":"0.65"}]
[1975,12,null,12,null,{"v":0.981,"d":"0.98"},{"v":1.0615,"d":"1.06"},null,{"v":0.21561338289962806,"d":"21.6%"},{"v":0.17861338289962805,"d":"17.9%"},{"v":2.5959227209264113,"d":"2.6"},null,{"v":4.622633756877608,"d":"4.62"},{"$nulls":4},1975,{"v":4.622633756877608,"d":"4.62"},12,{"v":20.933333333333334,"d":"20.9"},{"v":7.227891636571219,"d":"7.23"},1975,{"v":0.664889486414971,"d":"0.66"},null,null,{"v":0.6189999999999998,"d":"0.62"}]
[1976,19,null,19,null,{"v":1.091,"d":"1.09"},{"v":1.1637,"d":"1.16"},null,{"v":0.09627885068299569,"d":"9.6%"},{"v":0.05927885068299569,"d":"5.9%"},{"v":3.059589259857085,"d":"3.1"},"PhRMA Annual Survey 2011 page 42. This underestimates industry R&D spending since it only includes PhRMA members and excludes biotechnology companies and some non-US. See column H for PhRMA's estimate of global spend across all companies",{"v":6.209983885512626,"d":"6.21"},{"$nulls":4},1976,{"v":6.209983885512626,"d":"6.21"},19,{"v":20.933333333333334,"d":"20.9"},{"v":10.667167248335192,"d":"10.67"},1976,{"v":0.7930904732132911,"d":"0.79"},null,null,{"v":0.5848000000000013,"d":"0.58"}]
[1977,17,null,17,null,{"v":1.117,"d":"1.12"},{"v":1.2761,"d":"1.28"},null,{"v":0.09658846781816632,"d":"9.7%"},{"v":0.059588467818166325,"d":"6.0%"},{"v":3.2409581947434507,"d":"3.2"},null,{"v":5.245362321418556,"d":"5.25"},{"$nulls":4},1977,{"v":5.245362321418556,"d":"5.25"},17,{"v":20.933333333333334,"d":"20.9"},{"v":8.716590853908345,"d":"8.72"},1977,{"v":0.719775492292787,"d":"0.72"},null,null,{"v":0.5506000000000029,"d":"0.55"}]
[1978,18,null,18,null,{"v":1.308,"d":"1.31"},{"v":1.404,"d":"1.40"},null,{"v":0.1002272549173262,"d":"10.0%"},{"v":0.0632272549173262,"d":"6.3%"},{"v":3.4340819278309436,"d":"3.4"},null,{"v":5.241575587967779,"d":"5.24"},{"$nulls":4},1978,{"v":5.241575587967779,"d":"5.24"},18,{"v":20.933333333333334,"d":"20.9"},{"v":8.636467126957092,"d":"8.64"},1978,{"v":0.7194618530726835,"d":"0.72"},null,null,{"v":0.5164000000000044,"d":"0.52"}]
[1979,14,null,14,null,{"v":1.517,"d":"1.52"},{"v":1.6268,"d":"1.63"},null,{"v":0.15868945868945872,"d":"15.9%"},{"v":0.12168945868945871,"d":"12.2%"},{"v":3.651209501288894,"d":"3.7"},null,{"v":3.8343458503429986,"d":"3.83"},{"$nulls":4},1979,{"v":3.8343458503429986,"d":"3.83"},14,{"v":20.933333333333334,"d":"20.9"},{"v":6.035713733707203,"d":"6.04"},1979,{"v":0.5836912828042802,"d":"0.58"},null,null,{"v":0.48220000000000596,"d":"0.48"}]
[1980,12,null,12,null,{"v":1.777,"d":"1.78"},{"v":1.9767000000000001,"d":"1.98"},null,{"v":0.21508482911236793,"d":"21.5%"},{"v":0.17808482911236792,"d":"17.8%"},{"v":4.095523209062549,"d":"4.1"},null,{"v":2.9300285671551007,"d":"2.93"},{"$nulls":4},1980,{"v":2.9300285671551007,"d":"2.93"},12,{"v":20.933333333333334,"d":"20.9"},{"v":4.622633756877608,"d":"4.62"},1980,{"v":0.46687185465354397,"d":"0.47"},null,null,{"v":0.4479999999999933,"d":"0.45"},{"v":0.5060000000000144,"d":"0.51"}]
[1981,26,null,26,null,null,{"v":2.3395,"d":"2.34"},null,{"v":0.1835382202661,"d":"18.4%"},{"v":0.1465382202661,"d":"14.7%"},{"v":4.8248737598741895,"d":"4.8"},null,{"v":5.38874202600442,"d":"5.39"},{"$nulls":4},1981,{"v":5.38874202600442,"d":"5.39"},26,{"v":20.933333333333334,"d":"20.9"},{"v":8.49787268543833,"d":"8.50"},1981,{"v":0.7314873932147923,"d":"0.73"},{"$nulls":3},{"v":0.4656000000000091,"d":"0.47"}]
[1982,24,1,25,null,null,{"v":2.7737,"d":"2.77"},null,{"v":0.18559521265227596,"d":"18.6%"},{"v":0.14859521265227596,"d":"14.9%"},{"v":5.5319021736547604,"d":"5.5"},null,{"v":4.519241160673537,"d":"4.52"},{"$nulls":4},1982,{"v":4.519241160673537,"d":"4.52"},25,{"v":20.933333333333334,"d":"20.9"},{"v":7.713768119733171,"d":"7.71"},1982,{"v":0.6550655172451727,"d":"0.66"},{"$nulls":3},{"v":0.4252000000000038,"d":"0.43"}]
[1983,13,0,13,null,null,{"v":3.2176,"d":"3.22"},null,{"v":0.1600389371597506,"d":"16.0%"},{"v":0.12303893715975059,"d":"12.3%"},{"v":6.353916353520577,"d":"6.4"},null,{"v":2.0459822378361907,"d":"2.05"},{"$nulls":4},1983,{"v":2.0459822378361907,"d":"2.05"},13,{"v":20.933333333333334,"d":"20.9"},{"v":3.78558236908784,"d":"3.79"},1983,{"v":0.31090185907154044,"d":"0.31"},{"$nulls":3},{"v":0.3848000000000127,"d":"0.38"}]
[1984,21,1,22,null,null,{"v":3.5788,"d":"3.58"},null,{"v":0.11225758329189461,"d":"11.2%"},{"v":0.07525758329189461,"d":"7.5%"},{"v":7.135695468459708,"d":"7.1"},null,{"v":3.083091213357072,"d":"3.08"},{"$nulls":4},1984,{"v":3.083091213357072,"d":"3.08"},22,{"v":20.933333333333334,"d":"20.9"},{"v":6.025400621967569,"d":"6.03"},1984,{"v":0.48898637353340535,"d":"0.49"},{"$nulls":3},{"v":0.34440000000000737,"d":"0.34"}]
[1985,26,1,27,null,null,{"v":4.0776,"d":"4.08"},null,{"v":0.1393763272605344,"d":"13.9%"},{"v":0.10237632726053439,"d":"10.2%"},{"v":7.67271066452291,"d":"7.7"},null,{"v":3.5189649630400686,"d":"3.52"},{"$nulls":4},1985,{"v":3.5189649630400686,"d":"3.52"},27,{"v":20.933333333333334,"d":"20.9"},{"v":6.592564276098977,"d":"6.59"},1985,{"v":0.5464149427561601,"d":"0.55"},{"$nulls":3},{"v":0.30400000000000205,"d":"0.30"}]
[1986,19,3,22,null,null,{"v":4.7401,"d":"4.74"},null,{"v":0.16247302334706681,"d":"16.2%"},{"v":0.1254730233470668,"d":"12.5%"},{"v":8.4582146024895,"d":"8.5"},null,{"v":2.601021732591741,"d":"2.60"},{"$nulls":4},1986,{"v":2.601021732591741,"d":"2.60"},22,{"v":20.933333333333334,"d":"20.9"},{"v":4.559704791234509,"d":"4.56"},1986,{"v":0.41514398091761046,"d":"0.42"},{"$nulls":3},{"v":0.26360000000001094,"d":"0.26"}]
[1987,19,1,20,null,null,{"v":5.5022,"d":"5.50"},null,{"v":0.16077719879327446,"d":"16.1%"},{"v":0.12377719879327445,"d":"12.4%"},{"v":9.519492360782166,"d":"9.5"},null,{"v":2.100952366157128,"d":"2.10"},{"$nulls":4},1987,{"v":2.100952366157128,"d":"2.10"},20,{"v":20.933333333333334,"d":"20.9"},{"v":3.6153929285388293,"d":"3.62"},1987,{"v":0.3224162059758604,"d":"0.32"},{"$nulls":3},{"v":0.22320000000000562,"d":"0.22"},{"$nulls":3},"Number of new drugs per $bn inflation-adjusted R&D costs 5 years previously"]
[1988,15,0,15,null,null,{"v":6.5375,"d":"6.54"},null,{"v":0.1881610991966849,"d":"18.8%"},{"v":0.15116109919668488,"d":"15.1%"},{"v":10.69778845913376,"d":"10.7"},null,{"v":1.4021589655937734,"d":"1.40"},{"$nulls":4},1988,{"v":1.4021589655937734,"d":"1.40"},15,{"v":20.933333333333334,"d":"20.9"},{"v":2.360748735964836,"d":"2.36"},1988,{"v":0.14679725326441903,"d":"0.15"},{"$nulls":3},{"v":0.1828000000000145,"d":"0.18"}]
[1989,21,4,25,null,null,7.33,null,{"v":0.12122370936902493,"d":"12.1%"},{"v":0.08422370936902493,"d":"8.4%"},{"v":12.314877921590028,"d":"12.3"},null,{"v":2.0300647849842544,"d":"2.03"},{"$nulls":4},1989,{"v":2.0300647849842544,"d":"2.03"},25,{"v":20.933333333333334,"d":"20.9"},{"v":3.503512742451218,"d":"3.50"},1989,{"v":0.30750989767292825,"d":"0.31"},{"$nulls":3},{"v":0.14240000000000919,"d":"0.14"}]
[1990,18,3,21,null,null,{"v":8.4203,"d":"8.42"},null,{"v":0.14874488403819908,"d":"14.9%"},{"v":0.11174488403819907,"d":"11.2%"},{"v":13.35208262057305,"d":"13.4"},null,{"v":1.5727883504587477,"d":"1.57"},{"$nulls":4},1990,{"v":1.5727883504587477,"d":"1.57"},21,{"v":20.933333333333334,"d":"20.9"},{"v":2.7369727490311644,"d":"2.74"},1990,{"v":0.1966702837089279,"d":"0.20"},{"$nulls":3},{"v":0.10200000000000387,"d":"0.10"},{"v":0.11199999999999832,"d":"0.11"}]
[1991,29,3,32,null,null,{"v":9.7054,"d":"9.7"},null,{"v":0.15261926534684034,"d":"15.3%"},{"v":0.11561926534684033,"d":"11.6%"},{"v":14.84410954467744,"d":"14.8"},null,{"v":2.155737257508588,"d":"2.16"},{"$nulls":4},1991,{"v":2.155737257508588,"d":"2.16"},32,{"v":20.933333333333334,"d":"20.9"},{"v":3.783304338315259,"d":"3.78"},1991,{"v":0.3335958276799841,"d":"0.33"},{"$nulls":4},{"v":0.09890000000000043,"d":"0.10"}]
[1992,24,3,27,null,null,{"v":11.4679,"d":"11.5"},null,{"v":0.1815999340573291,"d":"18.2%"},{"v":0.1445999340573291,"d":"14.5%"},{"v":16.560374584961068,"d":"16.6"},null,{"v":1.6303979032285565,"d":"1.63"},{"$nulls":4},1992,{"v":1.6303979032285565,"d":"1.63"},27,{"v":20.933333333333334,"d":"20.9"},{"v":2.836285694312123,"d":"2.84"},1992,{"v":0.212293608138766,"d":"0.21"},{"$nulls":4},{"v":0.08579999999999899,"d":"0.09"}]
[1993,22,3,25,null,null,{"v":12.74,"d":"12.7"},null,{"v":0.11092702238422025,"d":"11.1%"},{"v":0.07392702238422025,"d":"7.4%"},{"v":18.955003657911107,"d":"19.0"},null,{"v":1.3189129609883214,"d":"1.32"},{"$nulls":4},1993,{"v":1.3189129609883214,"d":"1.32"},25,{"v":20.933333333333334,"d":"20.9"},{"v":2.336931609322956,"d":"2.34"},1993,{"v":0.12021613610001126,"d":"0.12"},{"$nulls":4},{"v":0.0727000000000011,"d":"0.07"}]
[1994,15,4,19,null,null,{"v":13.449399999999999,"d":"13.4"},null,{"v":0.05568288854003134,"d":"5.6%"},{"v":0.01868288854003134,"d":"1.9%"},{"v":20.35629063762248,"d":"20.4"},null,{"v":0.9333724074898113,"d":"0.93"},{"$nulls":4},1994,{"v":0.9333724074898113,"d":"0.93"},19,{"v":20.933333333333334,"d":"20.9"},{"v":1.542849236588033,"d":"1.54"},1994,{"v":-0.029945041946728368,"d":"-0.03"},{"$nulls":4},{"v":0.05959999999999965,"d":"0.06"}]
[1995,27,0,27,null,null,{"v":15.2074,"d":"15.2"},null,{"v":0.13071215072791365,"d":"13.1%"},{"v":0.09371215072791364,"d":"9.4%"},{"v":20.736604946693664,"d":"20.7"},null,{"v":1.3020453477995684,"d":"1.30"},{"$nulls":4},1995,{"v":1.3020453477995684,"d":"1.30"},27,{"v":20.933333333333334,"d":"20.9"},{"v":2.022156450589818,"d":"2.02"},1995,{"v":0.1146261101585612,"d":"0.11"},{"$nulls":4},{"v":0.04649999999999821,"d":"0.05"}]
[1996,53,3,56,"Data from FDA website",null,{"v":16.9056,"d":"16.9"},null,{"v":0.11166931888422749,"d":"11.2%"},{"v":0.07466931888422748,"d":"7.5%"},{"v":22.679876795043423,"d":"22.7"},null,{"v":2.4691492156711594,"d":"2.47"},{"$nulls":4},1996,{"v":2.4691492156711594,"d":"2.47"},56,{"v":20.933333333333334,"d":"20.9"},{"v":3.772540200640029,"d":"3.77"},1996,{"v":0.3925473360171709,"d":"0.39"},{"$nulls":4},{"v":0.03340000000000032,"d":"0.03"}]
[1997,39,6,45,null,null,{"v":18.958099999999998,"d":"19.0"},null,{"v":0.12140947378383493,"d":"12.1%"},{"v":0.08440947378383493,"d":"8.4%"},{"v":24.373367747707515,"d":"24.4"},null,{"v":1.8462774806420652,"d":"1.85"},{"$nulls":4},1997,{"v":1.8462774806420652,"d":"1.85"},45,{"v":20.933333333333334,"d":"20.9"},{"v":2.7173298387142606,"d":"2.72"},1997,{"v":0.26629697255962004,"d":"0.27"},{"$nulls":4},{"v":0.020299999999998875,"d":"0.02"}]
[1998,30,7,37,null,null,{"v":20.966900000000003,"d":"21.0"},null,{"v":0.10595998544157936,"d":"10.6%"},{"v":0.06895998544157936,"d":"6.9%"},{"v":26.430710893631403,"d":"26.4"},null,{"v":1.3998866753491415,"d":"1.40"},{"$nulls":4},1998,{"v":1.3998866753491415,"d":"1.40"},37,{"v":20.933333333333334,"d":"20.9"},{"v":1.9519911822627156,"d":"1.95"},1998,{"v":0.14609287977639981,"d":"0.15"},{"$nulls":4},{"v":0.007200000000000983,"d":"0.01"}]
[1999,35,3,38,null,null,{"v":22.6907,"d":"22.7"},null,{"v":0.0822153012605582,"d":"8.2%"},{"v":0.045215301260558206,"d":"4.5%"},{"v":28.25337233206682,"d":"28.3"},null,{"v":1.3449721878641374,"d":"1.34"},{"$nulls":4},1999,{"v":1.3449721878641374,"d":"1.34"},38,{"v":20.933333333333334,"d":"20.9"},{"v":1.8667448149796226,"d":"1.87"},1999,{"v":0.12871330383134943,"d":"0.13"},{"$nulls":4},{"v":-0.00590000000000046,"d":"-0.01"}]
[2000,27,2,29,null,null,{"v":26.0308,"d":"26.0"},null,{"v":0.14720127629381197,"d":"14.7%"},{"v":0.11020127629381196,"d":"11.0%"},{"v":29.530857073687944,"d":"29.5"},null,{"v":0.9820236482685449,"d":"0.98"},{"$nulls":4},2000,{"v":0.9820236482685449,"d":"0.98"},29,{"v":20.933333333333334,"d":"20.9"},{"v":1.398493151340277,"d":"1.40"},2000,{"v":-0.007878053772241655,"d":"-0.01"},{"$nulls":4},{"v":-0.019000000000001904,"d":"-0.02"},{"v":-0.1150000000000091,"d":"-0.12"}]
[2001,24,5,29,null,null,{"v":29.7727,"d":"29.8"},null,{"v":0.14374894355916834,"d":"14.4%"},{"v":0.10674894355916834,"d":"10.7%"},{"v":32.785195213258504,"d":"32.8"},null,{"v":0.8845455947833505,"d":"0.88"},{"$nulls":4},2001,{"v":0.8845455947833505,"d":"0.88"},29,{"v":20.933333333333334,"d":"20.9"},{"v":1.278666558115422,"d":"1.28"},2001,{"v":-0.053279776035820216,"d":"-0.05"},{"$nulls":5},{"v":-0.147199999999998,"d":"-0.15"}]
[2002,17,7,24,null,null,{"v":31.0122,"d":"31.0"},null,{"v":0.04163209920497635,"d":"4.2%"},{"v":0.004632099204976349,"d":"0.5%"},{"v":36.284980166654954,"d":"36.3"},null,{"v":0.6614307046543583,"d":"0.66"},{"$nulls":4},2002,{"v":0.6614307046543583,"d":"0.66"},24,{"v":20.933333333333334,"d":"20.9"},{"v":0.9846813230091015,"d":"0.98"},2002,{"v":-0.17951564832095654,"d":"-0.18"},{"$nulls":5},{"v":-0.17940000000000111,"d":"-0.18"}]
[2003,21,6,27,null,null,{"v":34.453300000000006,"d":"34.5"},null,{"v":0.11095955785142642,"d":"11.1%"},{"v":0.07395955785142641,"d":"7.4%"},{"v":36.4530557944375,"d":"36.5"},null,{"v":0.740678645769939,"d":"0.74"},{"$nulls":4},2003,{"v":0.740678645769939,"d":"0.74"},27,{"v":20.933333333333334,"d":"20.9"},{"v":1.0215389252547789,"d":"1.02"},2003,{"v":-0.13037017615030547,"d":"-0.13"},{"$nulls":5},{"v":-0.21160000000000423,"d":"-0.21"}]
[2004,31,5,36,null,null,{"v":37.0181,"d":"37.0"},47.6,{"v":0.07444279648103347,"d":"7.4%"},{"v":0.03744279648103347,"d":"3.7%"},{"v":39.14910768332748,"d":"39.1"},null,{"v":0.9195611887555589,"d":"0.92"},{"$nulls":4},2004,{"v":0.9195611887555589,"d":"0.92"},36,{"v":20.933333333333334,"d":"20.9"},{"v":1.2741841779765513,"d":"1.27"},2004,{"v":-0.03641936696451978,"d":"-0.04"},{"$nulls":5},{"v":-0.24380000000000734,"d":"-0.24"}]
[2005,18,2,20,null,null,{"v":39.8579,"d":"39.9"},51.8,{"v":0.07671382377809777,"d":"7.7%"},{"v":0.03971382377809777,"d":"4.0%"},{"v":40.614959754728375,"d":"40.6"},null,{"v":0.4924293935234445,"d":"0.49"},{"$nulls":4},2005,{"v":0.4924293935234445,"d":"0.49"},20,{"v":20.933333333333334,"d":"20.9"},{"v":0.6772576884610655,"d":"0.68"},2005,{"v":-0.307656031565177,"d":"-0.31"},{"$nulls":5},{"v":-0.27599999999999625,"d":"-0.28"},null,"Slope of the productivity trend over time"]
[2006,18,4,22,null,null,{"v":42.9735,"d":"43.0"},56.1,{"v":0.07816769072128738,"d":"7.8%"},{"v":0.04116769072128738,"d":"4.1%"},{"v":42.22793510918219,"d":"42.2"},null,{"v":0.5209821399771982,"d":"0.52"},{"$nulls":4},2006,{"v":0.5209821399771982,"d":"0.52"},22,{"v":20.933333333333334,"d":"20.9"},{"v":0.67103458914599,"d":"0.67"},2006,{"v":-0.2831771646895353,"d":"-0.28"},{"$nulls":5},{"v":-0.30819999999999936,"d":"-0.31"}]
[2007,16,2,18,null,null,{"v":47.9031,"d":"47.9"},63.2,{"v":0.11471255541205627,"d":"11.5%"},{"v":0.07771255541205627,"d":"7.8%"},{"v":43.9663616815556,"d":"44.0"},null,{"v":0.4094039013364895,"d":"0.41"},{"$nulls":4},2007,{"v":0.4094039013364895,"d":"0.41"},18,{"v":20.933333333333334,"d":"20.9"},{"v":0.4960730284907687,"d":"0.50"},2007,{"v":-0.3878480231272588,"d":"-0.39"},{"$nulls":5},{"v":-0.3404000000000025,"d":"-0.34"}]
[2008,21,3,24,null,null,{"v":47.3831,"d":"47.4"},63.7,{"v":-0.010855247363949383,"d":"-1.1%"},{"v":-0.04785524736394938,"d":"-4.8%"},{"v":47.3831,"d":"47.4"},null,{"v":0.5065097049369923,"d":"0.51"},{"$nulls":4},2008,{"v":0.5065097049369923,"d":"0.51"},24,{"v":20.933333333333334,"d":"20.9"},{"v":0.658381018462168,"d":"0.66"},2008,{"v":-0.295412228960751,"d":"-0.30"},{"$nulls":5},{"v":-0.3726000000000056,"d":"-0.37"}]
[2009,19,7,26,null,null,{"v":46.4416,"d":"46.4"},65.9,{"v":-0.019869953633257387,"d":"-2.0%"},{"v":-0.056869953633257385,"d":"-5.7%"},{"v":44.6884253,"d":"44.7"},null,{"v":0.5818061349322148,"d":"0.58"},{"$nulls":4},2009,{"v":0.5818061349322148,"d":"0.58"},26,{"v":20.933333333333334,"d":"20.9"},{"v":0.6641275252123481,"d":"0.66"},2009,{"v":-0.235221703588856,"d":"-0.24"},{"$nulls":5},{"v":-0.4048000000000087,"d":"-0.40"}]
[2010,null,null,21,null,null,{"v":49.418,"d":"49.4"},67.4,{"v":0.06408909253772466,"d":"6.4%"},{"v":0.02708909253772466,"d":"2.7%"},{"v":45.8989941883169,"d":"45.9"},null,{"v":0.4575263656942035,"d":"0.46"},{"$nulls":4},2010,{"v":0.4575263656942035,"d":"0.46"},21,{"v":20.933333333333334,"d":"20.9"},{"v":0.5170508631996167,"d":"0.52"},2010,{"v":-0.33958387395693895,"d":"-0.34"},{"$nulls":5},{"v":-0.4369999999999976,"d":"-0.44"}]
[{"$nulls":24},"y = -0.0125x + 26.005\n","y = -0.0574x + 113.83\n","y = -0.0342x + 68.164\n","y = -0.0404x + 80.498\n","y = -0.0131x + 26.181\n","y = -0.0322x + 64.285\n"]
[{"$nulls":8},"Inflation",{"v":0.037,"d":"4%"}]
[{"$nulls":8},"R&D over inflation",{"v":0.083,"d":"8%"}]