{"id":1283,"date":"2012-11-17T14:27:27","date_gmt":"2012-11-17T02:27:27","guid":{"rendered":"https:\/\/www.deltics.co.nz\/blog\/?p=1283"},"modified":"2012-11-17T14:27:27","modified_gmt":"2012-11-17T02:27:27","slug":"lies-damned-lies-and-statistics-and-the-margin-on-spirits","status":"publish","type":"post","link":"https:\/\/www.deltics.co.nz\/blog\/posts\/1283\/","title":{"rendered":"Lies, Damned Lies and Statistics (and the Margin on Spirits)"},"content":{"rendered":"<span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">[Estimated Reading Time: <\/span> <span class=\"rt-time\">6<\/span> <span class=\"rt-label rt-postfix\">minutes]<\/span><\/span><p>I have decided I need to explain more clearly why I am so skeptical of the confident claims made for the &#8220;health&#8221; of Delphi based on the sales performance announced in the press release by Embarcadero earlier this year.  Not that I don&#8217;t wish it were true, only that I fear that misplaced satisfaction can lead to complacency that I think could be costly.<\/p>\n<p>Rest assured, I shall respond to <a href=\"https:\/\/www.deltics.co.nz\/blog\/?p=1264&#038;cpage=1#comment-13425\" target=\"_blank\">David I&#8217;s invitation to contribute to the list of things that the new Product Manager for Delphi might focus on<\/a> soon.  In the meantime I shall elevate his invitation to the status of a &#8220;New Post&#8221;, so as to elicit responses from others.<\/p>\n<p>But first, that press release.<br \/>\n<!--more--><br \/>\nThe <a href=\"http:\/\/www.embarcadero.com\/press-releases\/embarcadero-technologies-grows-delphi-and-c-by-54-in-2011\" target=\"_blank\">Embarcadero press release of Feb 2012<\/a> states that worldwide sales &#8220;grew 54% over sales of the previous version&#8221; and that this followed 3 years of 15% year-over-year growth, but crucially &#8211; if we are to draw any meaningful conclusions from these numbers &#8211; it doesn&#8217;t say <em>how<\/em> or <em>on what<\/em> those percentages are calculated.<\/p>\n<p>What &#8220;growth&#8221; do these percentage sales increases represent ?<\/p>\n<p>Is it based on comparing sales of <strong>new<\/strong> user licenses (predominantly Starter? Pro? Enterprise?) ? Or was it <strong>Upgrades<\/strong> sales ? Sales <em>including a purchase of SA<\/em> ? What ?<\/p>\n<p>At an even more fundamental level, it isn&#8217;t even stated whether it is a percentage increase in sales <em>volumes<\/em> (numbers of customers\/licenses) or sales <em>value<\/em> (raw $&#8217;s). Given that there was a big push to move people on to SA and that SA agreements themselves provide a built-in annual increase of up to 5%, if the increase was based on sales <em>value<\/em> and SA renewals were included then how much is real growth and how much was built-in, mandated &#8220;growth&#8221; under the terms of SA agreements ?<\/p>\n<p>To add to the muddle, the 54% cited is for the &#8220;RAD family .. including RAD Studio, Delphi and C++ Builder&#8221;, whilst the 15% figures relate only to &#8220;RAD Studio and Delphi&#8221;.<\/p>\n<p>As the saying goes (and the title of this post): &#8220;Lies damned lies and statistics&#8221;.<\/p>\n<p>I do not mean to imply that Embarcadero are lying with these numbers. I don&#8217;t doubt for a minute that Embarcadero would have been sure to be entirely accurate with the 54% and 15% figures, but without the underlying numbers or at least a concrete explanation for the derivation of the percentages quoted, it is simply impossible to say what those numbers actually mean.<\/p>\n<p>The one absolute number that does get quoted time and time again, that of &#8220;<a href=\"https:\/\/www.deltics.co.nz\/blog\/?p=1264&amp;cpage=1#comment-13400\" target=\"_blank\">3 million Delphi\/C++ Builder users<\/a>&#8220;.<\/p>\n<p>I seem to recall &#8220;3 million&#8221; being a figure that was widely cited at the time that Embarcadero purchased CodeGear, over 4 years ago. It stuck in my memory because a joke that went around the Delphi users here was that at the bargain price of $30 million, each user could have chipped in just $10 and the &#8216;community&#8217; could have bought it ourselves!<\/p>\n<p>And I wasn&#8217;t the only one.  Bret Graffin had heard the same figure at around that time also, <a href=\"http:\/\/blog.marcocantu.com\/blog\/embarcadero_allaccess.html\">as he mentioned in the comments to the blog of a one Marco Cantu<\/a> (you&#8217;ll need to scroll down to the post addressed to &#8220;King of All Access&#8221;).<\/p>\n<p><a href=\"http:\/\/coding.derkeiler.com\/Archive\/Delphi\/borland.public.delphi.non-technical\/2007-08\/msg02092.html\" target=\"_blank\">In 2007, Michael Swindell quoted a figure of 1.75 million, along with an admission that this included what could only be an estimate, to account for piracy<\/a>, i.e. unlicensed users.<\/p>\n<p>Currently Embarcadero do cite <a href=\"http:\/\/www.embarcadero.com\/products\/appwave\/developers\" target=\"_blank\">3 million, on their AppWave store marketing\/PR landing page<\/a>. But in this case the 3 millions account not just for Delphi, C++ Builder or any other combination of &#8220;RAD Family&#8221; products, but ALL Embarcadero Technologies customers, including &#8211; one must presume &#8211; those customers of their wide variety of database tools.<\/p>\n<p>In any event, taking 3 million at face value, 4 years after the acquisition, after a year of 54% growth on top of 2 years (3 years in total, only 2 under Embarcadero as of Feb 2012) of 15% year-over-year growth and <em>still<\/em> the number of Delphi users is the same &#8220;3 million&#8221; ?<\/p>\n<p>Something isn&#8217;t adding up if everything really is as rosy as some people have concluded, based on the &#8220;official numbers&#8221;.<\/p>\n<p>And have people already forgotten that <a href=\"http:\/\/www.infoworld.com\/d\/developer-world\/codegear-supply-1-million-dev-tool-licenses-russia-030\" target=\"_blank\">2008 was also the year that saw CodeGear close a deal with the Russian universities for 1 million licenses<\/a> ?<\/p>\n<p>This 1 million license deal would account for the 3 million total in 2008, since when added to the 1.75 million would yield a total user number of 2.75 million. Add a slightly more generous estimate for unlicensed users and you can easily round this up to 3 million &#8211; what&#8217;s 250,000 users among friends, eh ? \ud83d\ude09 Though how much allowance was made for the fact that some of those unlicensed users might now be licensed as a result of the Russian deal ?<\/p>\n<p>Maybe we can make sense of things if we work the numbers backwards, from the information in the press release ?<\/p>\n<p>We are told that in 2011, sales grew 54% and that this followed 3 previous years (2010, 2009, 2008) of 15% growth. We also know that in 2008 1 million licenses were added as the result of the deal in Russia. This is an immediate problem for the numbers because 1 million is neither 15% of 1.75 million nor can it possibly represent 15% of the sales in 2007. We&#8217;ll just have to ignore this for the time being, yet we do also know that in 2007 the number of Delphi licenses claimed was 1.75 million. So let&#8217;s plug those numbers in to a rudimentary calculator:<\/p>\n<p><strong>2007<\/strong> 1.75<br \/>\n<strong>2008<\/strong> = + 15% + 1 million<br \/>\n<strong>2009<\/strong> = + 15%<br \/>\n<strong>2010<\/strong> = + 15%<br \/>\n<strong>2011<\/strong> = + 54%<\/p>\n<p>If you do the math, the total you get is 6.1 million.  Clearly this is out of whack with the assertion that there are currently 3 million users.<\/p>\n<p>So let&#8217;s take the 1 million license boost in 2008 out completely.  But we still get 4.1 million.<\/p>\n<p>Ok, so let&#8217;s now assume that the &#8220;1&#8221; in the &#8220;1.75&#8221; in 2007 already accounted for\/anticipated the 1 million license deal in 2008.  This means we start with just 0.75 million, but we <strong>still<\/strong> end up with 3.8 million.<\/p>\n<p>If we hack and slash at the numbers, we still cannot get the claimed &#8220;growth&#8221; to tally with the asserted number of users.<\/p>\n<p>I am being facetious, but this appears to be the interpretation of &#8220;growth&#8221; that some people are using, despite the fact that the numbers don&#8217;t actually fit, however hard you try (so presumably, they simply haven&#8217;t tried).<\/p>\n<p>Because of course the percentages in the press release are increases in <strong>sales<\/strong>, not increases in total licenses. This makes things a sight more complicated because now you really do need to be able to know whether it is sales volumes or sales values that are the basis for the quoted increases.<\/p>\n<p>Furthermore, without a breakdown of new user licenses vs SA renewals or upgrades, the percentages are quite simply meaningless.  More people may be upgrading and renewing SA when compared to previous years, yet the number of overall users might still be in decline.<\/p>\n<p>I don&#8217;t mean to say that this is the case, only that the numbers as presented in this press release &#8211; as accurate as they may be &#8211; do not support any meaningful conclusions, and certainly not the ones that some people are so determined to draw.<\/p>\n<h3>Let&#8217;s Take This Debate Down the Pub<\/h3>\n<p>My response to David I&#8217;s assurance that the numbers in the press release were indeed accurate was to say that &#8220;percentages can&#8217;t be taken to the bank&#8221; &#8211; a saying that I first became familiar with when I ran a pub for almost two years in the UK (a great way to spend money, incidentally).<\/p>\n<p>In the UK, spirits have to be sold &#8211; by law &#8211; in measures of <strong>either<\/strong> 25ml or 35ml (so a &#8220;double&#8221; can be either 50ml or 70ml, depending on where you buy it, for example).<\/p>\n<p>As a retailer you have to choose &#8211; one or the other. This affects your prices obviously, but more relevantly here, also affects your margin.<\/p>\n<p>If you increase your serving from 25ml to 35ml, then you increase the volume per serve by 40%, but you cannot increase the price by the same amount &#8211; nobody would stand those prices. So you have to take a lower margin.<\/p>\n<p>But that doesn&#8217;t matter &#8211; you are still selling &#8220;1 drink&#8221; and although the margin is lower as a percentage cost of sale, the actual bankable money in the till is higher. And you still sell the same number of drinks, because people don&#8217;t buy alcohol by volume (&#8220;No more for me thanks, I&#8217;ve had my 70 ml of whisky for the night&#8221;) but by the serving (&#8220;Yeah, go on, I&#8217;ll have another one&#8221;).<\/p>\n<p>The point being, that percentages rarely tell the whole story.<\/p>\n<p>The real question is, what are the absolute numbers ? What was the baseline figure for Delphi 2010 sales over which 2011 represented a 54% increase ? Or, getting straight to the point, how many active (in use) licenses are there ? Really ?<\/p>\n<p>As I said before, with the need to activate licenses these days, this should be an easy number to determine.<\/p>\n<p>Whether you would choose to talk about those numbers of course &#8211; that&#8217;s a different matter.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">[Estimated Reading Time: <\/span> <span class=\"rt-time\">6<\/span> <span class=\"rt-label rt-postfix\">minutes]<\/span><\/span> I have decided I need to explain more clearly why I am so skeptical of the confident claims made for the &#8220;health&#8221; of Delphi based on the sales performance announced in the press release by Embarcadero earlier this year. Not that I don&#8217;t wish it were true, only that I fear that misplaced satisfaction can [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":[]},"categories":[4],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1TKYv-kH","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2376,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/2376\/","url_meta":{"origin":1283,"position":0},"title":"Official: Idera to Acquire Embarcadero","date":"09 Oct 2015","format":false,"excerpt":"The recently sign-posted potential acquisition of Embarcadero by Idera has now been officially confirmed by a press release from Idera, as reported by The Register. What is starkly apparent in the press release is the extent to which neither the Idera nor the Embarcadero commentary make any reference to development\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":653,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/653\/","url_meta":{"origin":1283,"position":1},"title":"RAD Studio &#8220;XE&#8221;","date":"11 Aug 2010","format":false,"excerpt":"News is starting to come out about the upcoming release of Delphi, RAD Studio XE. So what can we expect? Well, based on what has been revealed so far, anyone thinking that the time that has passed since we were supposed to have received 64-bit support has been well spent\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":995,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/995\/","url_meta":{"origin":1283,"position":2},"title":"The Problem with Embarcadero","date":"07 Aug 2012","format":false,"excerpt":"I recently got into an email exchange with David Intersimone of Embarcadero, during which a number of questions came up. The answers I gave to those questions I think are worth sharing, as they also reflect where I think Embarcadero are going, and have been going, wrong. I cannot say\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":636,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/636\/","url_meta":{"origin":1283,"position":3},"title":"Nick Hodges &#8220;Let Go&#8221; by Embarcadero","date":"19 Jul 2010","format":false,"excerpt":"I hadn't posted on this news before as I expected there to be a veritable deluge of opinion flooding the Delphi blog-o-sphere and didn't see any point adding to that noise, but there has been a curious silence on the matter, so here is my two-penneth after all. Nick Hodges\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1068,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/1068\/","url_meta":{"origin":1283,"position":4},"title":"Info From the World Tour (Hamburg)","date":"22 Aug 2012","format":false,"excerpt":"In the Embarcadero forums, Roland Kossow posted his report on the first of the \"RAD Studio World Tour\" events in Hamburg yesterday, reporting on what's new in XE3 and adding some more detail to the \"XE3 And Beyond\" blog post. In a nutshell we have \"FM2\" (FireMonkey 2 - no\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":582,"url":"https:\/\/www.deltics.co.nz\/blog\/posts\/582\/","url_meta":{"origin":1283,"position":5},"title":"On the Qt and all very Hush, Hush&#8230;","date":"14 Oct 2009","format":false,"excerpt":"A commenter on my blog suggested that Cross Platform could be a big win for Delphi, making it \u201cthe first\u201d to achieve this. \u00a0This I think says a lot about the awareness and expectation of (some) of the people asking for cross platform, because far from being first Delphi would\u2026","rel":"","context":"In &quot;Delphi&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/posts\/1283"}],"collection":[{"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/comments?post=1283"}],"version-history":[{"count":7,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/posts\/1283\/revisions"}],"predecessor-version":[{"id":1513,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/posts\/1283\/revisions\/1513"}],"wp:attachment":[{"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/media?parent=1283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/categories?post=1283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.deltics.co.nz\/blog\/wp-json\/wp\/v2\/tags?post=1283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}