### Apple's amusingly round reuse figures

If you take a look at Apple's Environment page you might well be impressed by the amount of reuse Apple is getting by taking back devices. The numbers look great:

What's weird about these numbers is that they are round numbers. In fact they are very simple, round numbers. You just have to be using the right units.

Just look at that... 2,204 lbs of gold.

But wait! Isn't 1kg roughly 2.204 lbs? (Why, yes. It's 2.20462 lbs). So, sounds like Apple recovered 1,000 kg of gold. Now take a look at tin... 4,408 lbs... 2,000 kg. And silver... 6,612 lbs... 3,000 kg. And lead... 44,080 lbs... 20,000 kg.

Here are the figures above converted to kg using 1 kg = 2.204 lbs.

```Steel    28,101,000 lbs = 12,750,000 kg
Plastics 13,422,360 lbs = 6,090,000 kg
Glass    11,945,680 lbs = 5,420,000 kg
Aluminum  4,518,200 lbs = 2,050,000 kg
Copper    2,953,360 lbs = 1,340,000 kg
Cobalt      189,544 lbs = 86,000 kg
Zinc        130,036 lbs = 59,000 kg
Lead         44,080 lbs = 20,000 kg
Nickel       39,672 lbs = 18,000 kg
Silver        6,612 lbs = 3,000 kg
Tin           4,408 lbs = 2,000 kg
Gold          2,204 lbs = 1,000 kg
```

Every single number given by Apple is an exact number of metrics tons (tonnes).

It's doubtful that Apple obtained precisely 1,000 kg of gold or 86,000 kg of cobalt. My guess is someone in Apple came up with rounded figures and they got converted to lbs for public consumption.

In the process they ended up looking precise.

One mystery remains. The total recovered is 27,839,000 kg which is 61,357,156 lbs (using 1kg == 2.204 lbs). But Apple reports an extra 644 lbs (total 61,357,800 lbs). I'll send a copy of my book, The Geek Atlas, to the first person to send me a convincing argument where those 644 lbs came from.

PS This comment points out that the UK Apple site gives the figures in tonnes.

PPS Another comment points out that the Australian Apple site appears to have converted back from lbs to kg.

PPPS Khalil Kacem (and below) has a convincing answer to the 644 lbs question. He gets the book.

Mark L said…
This comment has been removed by the author.
Unknown said…
They used more precise conversion for calculations and then rounded it to 1lbs for display.
tacos said…
"911 Metallurgist, which helps mines and recyclers extract precious metals from ore and, apparently, phones, has exhaustively checked the iPhones and other mobile devices. Each iPhone 5, for instance, contains \$1.58 of gold, \$.36 of silver, \$.05 of platinum, and \$.12 of copper."

So I'll say the missing item is platinum.
Lex Lexical said…
I can suggest an answer for the remaining 644lbs: rounding errors

Here's my hypothesis:

1. The figures were measured with reasonable accuracy on a per-material basis.
2. The per-material measurements were taken in kg. That's an ISO standard unit, and the initiatives are global after all.
3. The accurate measurements for 12 materials were then summed to produce the grand total that was probably a bit less than 27,839,000kg.
4. Next, all the figures were rounded to the nearest 1,000kg. Because hey, iProducts have round edges.
5. Some precision was lost in the process for each measurement. Across a large set, we can expect the errors to average out – but here our set is only N=12, so not huge. So, more of the numbers were reduced than increased; but the grand total number happened to be increased in the rounding.

Sanity check: the discrepancy is about 292kg, or ~25kg for each measurement. That's a couple of orders of magnitude lower than the rounding margin (nearest 1000).

T
This comment has been removed by the author.
JMart said…
Maybe they threw in the scraps from the manufacturing process. They realized they actually had a little more on hand that was "salvageable" and over 600 lb moves the needle enough to be worth adding to the number?
Aren Cambre said…
My guess: one or a few of the metric figures had more degrees of precision, and the total incorporated those numbers and then rounded, instead of just adding up the rounded ones. I've seen this in scientific calculations.
Luc said…
I don't know. The closest I can get if by summing ceil(pounds / 1000, 1 sf), which gets me to 61.357.700.
Dave said…
I suggest it's the rounded totals of various other precious elements.
For example, there's no mention of Indium which is supposedly rare and expensive, so we'd have to assume they did recover it. http://link.springer.com/article/10.1007%2Fs11661-009-9786-4#/page-1 gives a method for recovery and a figure of 6.2mg indium/phone.
http://money.cnn.com/2011/10/13/technology/iphone_trade_in/ gives a figure of 34mg of gold/phone; so taking the 2204lbs of gold as the start,

6.2*2204
-------- = 402lb
34

(Or 1000kg->182kg which you round to 200kg and call 440lb)

My bet is that the Indium end up rounded to 300kg which ends up as 661kg which gets to within the rounding to 100lb that your total has.
Unknown said…
They simply rounded the weights in pounds to next hundred which resulted in the extra 644lbs.

Python code:

import math
def roundup(x):
return int(math.ceil(x / 100.0)) * 100

materials_in_kgs = [12750000,6090000,5420000,2050000,1340000,86000,18000,20000,59000,2000,3000,1000]

materials_in_lbs = [i*2.204 for i in materials_in_kgs]

materials_in_lbs_rounded = [roundup(i) for i in materials_in_lbs]

print sum(materials_in_lbs_rounded)
Unknown said…
This comment has been removed by the author.
Unknown said…
This comment has been removed by the author.
Unknown said…
The logistics company who operates this waste would have supplied these figures, there's no conspiracy at work here.

### Your last name contains invalid characters

My last name is "Graham-Cumming". But here's a typical form response when I enter it:

Does the web site have any idea how rude it is to claim that my last name contains invalid characters? Clearly not. What they actually meant is: our web site will not accept that hyphen in your last name. But do they say that? No, of course not. They decide to shove in my face the claim that there's something wrong with my name.

There's nothing wrong with my name, just as there's nothing wrong with someone whose first name is Jean-Marie, or someone whose last name is O'Reilly.

What is wrong is that way this is being handled. If the system can't cope with non-letters and spaces it needs to say that. How about the following error message:

Our system is unable to process last names that contain non-letters, please replace them with spaces.

Don't blame me for having a last name that your system doesn't like, whose fault is that? Saying "Your last name …

### Importing an existing SSL key/certificate pair into a Java keystore

I'm writing this blog post in case anyone else has to Google that. In Java 6 keytool has been improved so that it now becomes possible to import an existing key and certificate (say one you generated outside of the Java world) into a keystore.

You need: Java 6 and openssl.

1. Suppose you have a certificate and key in PEM format. The key is named host.key and the certificate host.crt.

2. The first step is to convert them into a single PKCS12 file using the command: openssl pkcs12 -export -in host.crt -inkey host.key > host.p12. You will be asked for various passwords (the password to access the key (if set) and then the password for the PKCS12 file being created).

3. Then import the PKCS12 file into a keystore using the command: keytool -importkeystore -srckeystore host.p12 -destkeystore host.jks -srcstoretype pkcs12. You now have a keystore named host.jks containing the certificate/key you need.

For the sake of completeness here's the output of a full session I performe…

### More fun with toys: the Ikea LILLABO Train Set

As further proof of my unsuitability to be a child minder (see previous post) I found myself playing with an Ikea LILLABO 20-piece basic set train.

The train set has 16 pieces of track (12 curves, two straight pieces and a two part bridge) and 4 pieces of train. What I wondered was... how many possible looping train tracks can be made using all 16 pieces?

The answer is... 9. Here's a picture of the 9 different layouts.

The picture was generated using a little program written in Processing. The bridge is red, the straight pieces are green and the curves are blue or magenta depending on whether they are oriented clockwise or anticlockwise. The curved pieces can be oriented in either way.

To generate those layouts I wrote a small program which runs through all the possible layouts and determines which form a loop. The program eliminates duplicate layouts (such as those that are mirror images of each other).

It outputs a list of instructions for building loops. These instructions con…