Ian Waring

Simplicity Sells


Ask me anything  
Last year I bought a one year subscription to Wired for my iPad. Yesterday, without any pre-warning, they elected to help themselves to another £13.90 off my credit card. I have no recollection of ever agreeing to continuous billing, and even if it was there somewhere hidden in the terms and conditions, I’d expect an advanced warning before they went ahead. Normal buying protocol and common courtesy.As it is, I cancelled the subscription. I did the same when the Economist pulled the same stunt, never to return. Convenience to grant Apple access to my credit card for my use is great. To support pick pocket behaviours of publishers, intentional or not, is unwelcome.

Last year I bought a one year subscription to Wired for my iPad. Yesterday, without any pre-warning, they elected to help themselves to another £13.90 off my credit card. I have no recollection of ever agreeing to continuous billing, and even if it was there somewhere hidden in the terms and conditions, I’d expect an advanced warning before they went ahead. Normal buying protocol and common courtesy.


As it is, I cancelled the subscription. I did the same when the Economist pulled the same stunt, never to return. Convenience to grant Apple access to my credit card for my use is great. To support pick pocket behaviours of publishers, intentional or not, is unwelcome.
Leo Laporte interviewed “Throwboy” on Triangulation (one of my favourite podcasts) this week. I’ve never heard of throw pillows, and he has some neat ones with speech bubbles on board (like Fail, LoL, Like, etc). His web site was the one selling iCEO dolls, like the one pictured outside the mother ship in Cupertino.Meanwhile, there are a few comments about Microsoft selling out of launch volumes of Surface tablets and/or putting the availability for pre-orders back a week. Given no retail channels, I can’t help thinking this is the easiest thing in the world to game, not least as they’ve not run out of models bundled with mandatory expensive covers. I know folks who’d buy the Pro version scheduled for next year, but don’t know of a single person waiting to buy an RT tablet.Apple are reputed to be announcing the iPad Mini on Tuesday, with availability expected from Nov 2nd. While I’m not buying one, I suspect Microsoft would be happy if they sold 1/50 of the unit volume Apple will see this side of Christmas.

Leo Laporte interviewed “Throwboy” on Triangulation (one of my favourite podcasts) this week. I’ve never heard of throw pillows, and he has some neat ones with speech bubbles on board (like Fail, LoL, Like, etc). His web site was the one selling iCEO dolls, like the one pictured outside the mother ship in Cupertino.


Meanwhile, there are a few comments about Microsoft selling out of launch volumes of Surface tablets and/or putting the availability for pre-orders back a week. Given no retail channels, I can’t help thinking this is the easiest thing in the world to game, not least as they’ve not run out of models bundled with mandatory expensive covers. I know folks who’d buy the Pro version scheduled for next year, but don’t know of a single person waiting to buy an RT tablet.

Apple are reputed to be announcing the iPad Mini on Tuesday, with availability expected from Nov 2nd. While I’m not buying one, I suspect Microsoft would be happy if they sold 1/50 of the unit volume Apple will see this side of Christmas.
I’m used to running successful, £100m+ Software Businesses that continue to prosper long after I move on.  I help develop the best fast track talent. I think i’ve got a reasonable handle on high technology business trends and how to exploit them. I’ve somehow managed to get myself in a position where my value has morphed into drawing graphs, without the responsibility to use the insights to fix or improve what they expose.Given the long track record of successes, I must be the most crap salesperson out. Agonising a lot on how to turn this around. Worrying time.

I’m used to running successful, £100m+ Software Businesses that continue to prosper long after I move on.  I help develop the best fast track talent. I think i’ve got a reasonable handle on high technology business trends and how to exploit them. I’ve somehow managed to get myself in a position where my value has morphed into drawing graphs, without the responsibility to use the insights to fix or improve what they expose.


Given the long track record of successes, I must be the most crap salesperson out. Agonising a lot on how to turn this around. Worrying time.
A couple of days ago, Sanjay in the office fired up tethering on his “3” network 3G connected iPhone 4, which I then connected to over WiFi from my iPhone 5. It appeared to be really snappy, so I tried the iOS speed test. Sanjay was seeing over 4Mb/s, and me 2.5Mb/s; that’s over twice as fast as the broadband I get through my BT exchange at home.One of the nice things about buying a SIM free iPhone from Apple is that I could walk into a 3 store, and agree to pay £12.90/month for “all you can eat” data and more minutes/texts than I know I’m unlikely to get anywhere close to using. This be cancelled at a months notice. There’s then the option to add £5/month to get 1GB of tethering capacity, or £25/month all in to get a huge bundle of minutes, texts, all you can eat Internet access and unlimited tethered data.While in the store, I was told that the network was getting upgraded shortly close to our house, so we’ll shortly have a strong signal inside and out. Music to Jane’s ears, as O2 are routinely sitting between 1 bar and “No Service” on her iPhone every day.The performance is already very impressive. With that, we plan to cancel our O2 contract at the weekend, complete the move to 3. Much faster, no data caps and lower cost all at once - with the ability to change quickly should we ever need to.

A couple of days ago, Sanjay in the office fired up tethering on his “3” network 3G connected iPhone 4, which I then connected to over WiFi from my iPhone 5. It appeared to be really snappy, so I tried the iOS speed test. Sanjay was seeing over 4Mb/s, and me 2.5Mb/s; that’s over twice as fast as the broadband I get through my BT exchange at home.


One of the nice things about buying a SIM free iPhone from Apple is that I could walk into a 3 store, and agree to pay £12.90/month for “all you can eat” data and more minutes/texts than I know I’m unlikely to get anywhere close to using. This be cancelled at a months notice. There’s then the option to add £5/month to get 1GB of tethering capacity, or £25/month all in to get a huge bundle of minutes, texts, all you can eat Internet access and unlimited tethered data.

While in the store, I was told that the network was getting upgraded shortly close to our house, so we’ll shortly have a strong signal inside and out. Music to Jane’s ears, as O2 are routinely sitting between 1 bar and “No Service” on her iPhone every day.

The performance is already very impressive. With that, we plan to cancel our O2 contract at the weekend, complete the move to 3. Much faster, no data caps and lower cost all at once - with the ability to change quickly should we ever need to.
Another battle with SSRS today. The way outlined to stick a ranking position on a league table running down a page was to insert something like:=runningvalue(field.customername.value,CountDistinct,Nothing)which effectively counts the number of different customer names as it runs down the table. This worked fine for all the tables I built yesterday.Today, the Scottish customer list went 1, 2, 5, 6 and then every number up well into three figures. So, why the blip from 2 to 5? Likewise the occasional blip on other customer name lists for other Sales Managers. Despite an hour under the bonnet, it still beats me.Come back, Tableau, all is forgiven. A simple index() function is all I need.

Another battle with SSRS today. The way outlined to stick a ranking position on a league table running down a page was to insert something like:


=runningvalue(field.customername.value,CountDistinct,Nothing)

which effectively counts the number of different customer names as it runs down the table. This worked fine for all the tables I built yesterday.

Today, the Scottish customer list went 1, 2, 5, 6 and then every number up well into three figures. So, why the blip from 2 to 5? Likewise the occasional blip on other customer name lists for other Sales Managers. Despite an hour under the bonnet, it still beats me.

Come back, Tableau, all is forgiven. A simple index() function is all I need.
Eventful Day.Microsoft announce UK prices for their Surface tablet. I’m still very apprehensive about the chances of selling a new to market tablet at the same price point as an iPad, even if it does (as rumoured) include a preview copy of touch-enabled Microsoft Office. Not least as it’s being touted as a consumer device up against the Kindle Fire HD and Nexus 7 at more than double their price, and where businesses that might otherwise buy have no sales channel nor VBA customisation capabilities available to them. Time will tell if it makes it to the promised land of volume, and away from the bargain buckets where most Blackberry Playbooks ended up a few months after their launch.Then Sanjay at work opened up his iPhone 4, tethered to an “all you can eat” data plan with 3. I ran up the speed test on my iPhone 5 and was getting a sustained 2.5MB/s through the connection. Given I have an unlocked iPhone 5, it looks like I can contract onto the basic all-you-can-eat data plan with 3 for £12.90 per month. Tethering for my other devices is an extra, but I can’t yet see that price; however, I suspect the works is not going to be much more. Something to work out before my next O2 PAYG £10 top-up is due on Thursday, given the 1GB 3G plan for my iPad alone is £10/month.Final change is that Android is now upgraded to Jelly Bean 4.1.2 on my Nexus 7. We now have the home screen able to operate in landscape as well as in portrait orientation. The user experience on this device, in my humble opinion, flows much better than that of any version of iOS. No mean feat.I wonder if there are any unexpected surprises to come from Microsoft in the next few days, to see if they can leverage their strong channels of distribution into volume buying businesses in some way. In the interim, the invites to an Apple event for next week are out, as I predicted last July when Microsoft first outlined their own likely release timescales. I’m fully expecting the iPad Mini to ship in plenty of time before Christmas, at the very time Microsoft are at the most vulnerable time with Windows RT. My gut says that Apple will trample all over them.

Eventful Day.


Microsoft announce UK prices for their Surface tablet. I’m still very apprehensive about the chances of selling a new to market tablet at the same price point as an iPad, even if it does (as rumoured) include a preview copy of touch-enabled Microsoft Office. Not least as it’s being touted as a consumer device up against the Kindle Fire HD and Nexus 7 at more than double their price, and where businesses that might otherwise buy have no sales channel nor VBA customisation capabilities available to them. Time will tell if it makes it to the promised land of volume, and away from the bargain buckets where most Blackberry Playbooks ended up a few months after their launch.

Then Sanjay at work opened up his iPhone 4, tethered to an “all you can eat” data plan with 3. I ran up the speed test on my iPhone 5 and was getting a sustained 2.5MB/s through the connection. Given I have an unlocked iPhone 5, it looks like I can contract onto the basic all-you-can-eat data plan with 3 for £12.90 per month. Tethering for my other devices is an extra, but I can’t yet see that price; however, I suspect the works is not going to be much more. Something to work out before my next O2 PAYG £10 top-up is due on Thursday, given the 1GB 3G plan for my iPad alone is £10/month.

Final change is that Android is now upgraded to Jelly Bean 4.1.2 on my Nexus 7. We now have the home screen able to operate in landscape as well as in portrait orientation. The user experience on this device, in my humble opinion, flows much better than that of any version of iOS. No mean feat.

I wonder if there are any unexpected surprises to come from Microsoft in the next few days, to see if they can leverage their strong channels of distribution into volume buying businesses in some way. In the interim, the invites to an Apple event for next week are out, as I predicted last July when Microsoft first outlined their own likely release timescales. I’m fully expecting the iPad Mini to ship in plenty of time before Christmas, at the very time Microsoft are at the most vulnerable time with Windows RT. My gut says that Apple will trample all over them.
I’d like to stick that sign on Microsoft SQL Server Reporting Services. Consider this.

I built a table to show each Internal Sales Team Manager what their units Revenue and Profit was, year to date, by month, or customer, or vendor. The last column of the table was a percentage profit margin, aka “Profit” divided by “Revenue”.

The gotcha with this is that if something is given away for free, profit over revenue throws a divide by zero error. So simple me thinks: =iif(revenue>0, profit/revenue, 0)  Which, roughly translated, tells the software to calculate the percentage profit if revenue is greater than zero, otherwise just stick zero in as the answer. So, I rerun the view, and get #error in all the same places and the same 13 examples of attempted divide by zeroes in as before.  Brain thinks - oh, there must be some minuscule revenue numbers in the thousandths of pence in there, so change the formula to:  =iif(revenue>1,profit/revenue, 0)  so that the denominator is at least one, so the chance of throwing a divide by zero error is extremely remote. The giveaway would need to be mind bogglingly huge to get anything close to a divide by zero exception. Re-run the view. Result:

Same 13 divide by zero #error exceptions.  WTF? Look at where the exceptions are being thrown, and the revenue is zero, so the division shouldn’t even be being attempted. So off to Google with “SQL Services Reporting iif divide by zero” I go. 

The answer came from a Microsoft engineer who admits, nominally for performance reasons, both paths of the iif get executed at the same time as a performance shortcut, so that whichever half needs to give it’s result, it’s already populated and ready to use. So, the literal effect of  =iif(revenue>0, profit/revenue,0)  works like this:

Calculate 0 on the one side. Calculate Profit/Revenue on the other. If Revenue > 0, pick the second option, else pick the first. If either side throws an exception (like divide by zero), blat the answer, substitute “#Error” instead. Solution is to construct two nested iif statements in such a way that the optimiser does’t execute the division before the comparison with zero is made. With that, I’m sure wearing underpants on your head has the same sort of perverse logic somewhere. This is simply atrociously bad software engineering. 

I’d like to stick that sign on Microsoft SQL Server Reporting Services. 


Consider this. I built a table to show each Internal Sales Team Manager what their units Revenue and Profit was, year to date, by month, or customer, or vendor. The last column of the table was a percentage profit margin, aka “Profit” divided by “Revenue”. The gotcha with this is that if something is given away for free, profit over revenue throws a divide by zero error. So simple me thinks:

 =iif(revenue>0, profit/revenue, 0) 

 Which, roughly translated, tells the software to calculate the percentage profit if revenue is greater than zero, otherwise just stick zero in as the answer. So, I rerun the view, and get #error in all the same places and the same 13 examples of attempted divide by zeroes in as before. 

 Brain thinks - oh, there must be some minuscule revenue numbers in the thousandths of pence in there, so change the formula to: 

 =iif(revenue>1,profit/revenue, 0) 

 so that the denominator is at least one, so the chance of throwing a divide by zero error is extremely remote. The giveaway would need to be mind bogglingly huge to get anything close to a divide by zero exception. Re-run the view. Result: Same 13 divide by zero #error exceptions. 

 WTF? Look at where the exceptions are being thrown, and the revenue is zero, so the division shouldn’t even be being attempted. So off to Google with “SQL Services Reporting iif divide by zero” I go. The answer came from a Microsoft engineer who admits, nominally for performance reasons, both paths of the iif get executed at the same time as a performance shortcut, so that whichever half needs to give it’s result, it’s already populated and ready to use. So, the literal effect of 

 =iif(revenue>0, profit/revenue,0) 

 works like this: Calculate 0 on the one side. 
Calculate Profit/Revenue on the other. 
If Revenue > 0, pick the second option, else pick the first. 
If either side throws an exception (like divide by zero), blat the answer, substitute “#Error” instead. 

Solution is to construct two nested iif statements in such a way that the optimiser does’t execute the division before the comparison with zero is made. With that, I’m sure wearing underpants on your head has the same sort of perverse logic somewhere. This is simply atrociously bad software engineering. 
Headlines and Copy vs Facts
The headline appeared after someone got beheaded in a bar of ill repute, and became one of the most remembered tabloid headlines in history. At the moment, the press is having quite a feeding frenzy on Apple being awarded over one billion dollars in damages against Samsung in their recent (and probably first of several) patent spats in California. Peel the story back a bit, and things don’t look so clear cut.
On the subject of Trade dress, I think anyone would have a difficult job defending Samsung. Much in the same way any car manufacturer would run into trouble if their designs flew too close to looking like a Ferrari. Not in basic shape, or having four wheels on a rectangular floor pan, or the layout of pedals; however, distinctive shape or slavish copying of unique detail causing consumers to be confused are big no-no’s. Conceptually, passing off. Copying so closely that you are living on the values of a competitors unique brand image, or serving to dilute theirs. As long as Apple steer clear of questionable basics (rectangles with rounded corners being cited as one), then they deserve the legal protection.
The three gotchas in this case were procedural. The Judge denied Samsung providing examples of prior art into the case that would easily have proved invalidity of patents on which the jury assigned both guilt and damages. Secondly, the judge demonstrably didn’t hold Apple to the same standards of email evidence retention that she’d applied to Samsung. Finally, having returned a significant workload of questions within 3 days and just before the weekend, the jury foreman has gone public with statements suggesting that agonising over prior art was not a priority in the juries deliberations. It sounded like presumed guilt and an unseemly rush to get paperwork done by the weekend, an impression compounded by several products found to be non infringing and yet assigned damages awards to Apple.
Whatever the merits, this will be a slam dunk appeal for Samsung. They need to pay for trade dress issues, but the current set of patents will be subject to more equitable review next time around. The long term story will unfold after that, when more compelling Apple patents may be brought to bear. A fine PR line for Apple to navigate, to try to look reasonable with their claims and not to be perceived by the public in patenting the obvious (I also wonder how close to various working Google prototypes out in the wild are to claims that Apple are filing in writing only with the US Patent Office recently). And for Samsung to be more grown up in the way their PR bleats insults at iPhone users, who in the final analysis are prospects for them in the future.
Apple appear to be worried about the attractiveness of some Samsung phones and tablets, or are at least conveying that impression to consumers by seeking trade bans. The Law of unintended consequences in play.
In the long term, Apple have a difficult job to keep innovating as a single entity where they are competing against multi vendor ecosystems doing likewise. In the meantime, I hope they continue producing products we love, can be seen to behaving in the market fairly, and at the same time avoid becoming a patent troll from hell.

Headlines and Copy vs Facts

The headline appeared after someone got beheaded in a bar of ill repute, and became one of the most remembered tabloid headlines in history. At the moment, the press is having quite a feeding frenzy on Apple being awarded over one billion dollars in damages against Samsung in their recent (and probably first of several) patent spats in California. Peel the story back a bit, and things don’t look so clear cut.

On the subject of Trade dress, I think anyone would have a difficult job defending Samsung. Much in the same way any car manufacturer would run into trouble if their designs flew too close to looking like a Ferrari. Not in basic shape, or having four wheels on a rectangular floor pan, or the layout of pedals; however, distinctive shape or slavish copying of unique detail causing consumers to be confused are big no-no’s. Conceptually, passing off. Copying so closely that you are living on the values of a competitors unique brand image, or serving to dilute theirs. As long as Apple steer clear of questionable basics (rectangles with rounded corners being cited as one), then they deserve the legal protection.

The three gotchas in this case were procedural. The Judge denied Samsung providing examples of prior art into the case that would easily have proved invalidity of patents on which the jury assigned both guilt and damages. Secondly, the judge demonstrably didn’t hold Apple to the same standards of email evidence retention that she’d applied to Samsung. Finally, having returned a significant workload of questions within 3 days and just before the weekend, the jury foreman has gone public with statements suggesting that agonising over prior art was not a priority in the juries deliberations. It sounded like presumed guilt and an unseemly rush to get paperwork done by the weekend, an impression compounded by several products found to be non infringing and yet assigned damages awards to Apple.

Whatever the merits, this will be a slam dunk appeal for Samsung. They need to pay for trade dress issues, but the current set of patents will be subject to more equitable review next time around. The long term story will unfold after that, when more compelling Apple patents may be brought to bear. A fine PR line for Apple to navigate, to try to look reasonable with their claims and not to be perceived by the public in patenting the obvious (I also wonder how close to various working Google prototypes out in the wild are to claims that Apple are filing in writing only with the US Patent Office recently). And for Samsung to be more grown up in the way their PR bleats insults at iPhone users, who in the final analysis are prospects for them in the future.

Apple appear to be worried about the attractiveness of some Samsung phones and tablets, or are at least conveying that impression to consumers by seeking trade bans. The Law of unintended consequences in play.

In the long term, Apple have a difficult job to keep innovating as a single entity where they are competing against multi vendor ecosystems doing likewise. In the meantime, I hope they continue producing products we love, can be seen to behaving in the market fairly, and at the same time avoid becoming a patent troll from hell.

Bizarro!

I’m using Microsoft SQLserver Reporting Services to plot some Sales by Month graphs, with one line for 2010, one for 2011, a 2012 target and a 2012 year to date. Sample spoof graph above.

Gotcha is that this year goes up to August, then the running sum flat lines the YTD total for Sep, Oct, Nov and Dec. I just want to stop the YTD line at the point of the last data point.

In Tableau, that’s the default behaviour. In SSRS, I’m three hours into the docs and Google searches trying to find out if it’s even possible, let alone fixing it. Wondering if its just me… but the search continues.

Bizarro!

I’m using Microsoft SQLserver Reporting Services to plot some Sales by Month graphs, with one line for 2010, one for 2011, a 2012 target and a 2012 year to date. Sample spoof graph above.

Gotcha is that this year goes up to August, then the running sum flat lines the YTD total for Sep, Oct, Nov and Dec. I just want to stop the YTD line at the point of the last data point.

In Tableau, that’s the default behaviour. In SSRS, I’m three hours into the docs and Google searches trying to find out if it’s even possible, let alone fixing it. Wondering if its just me… but the search continues.