How to add 8GB of memory to Sony Ericsson K750i

My previous memory stick in my mobile phone was a 4GB MS Pro Duo card. This is the maximum the phone is supposed to be able to cope with. I took a slight risk and paid £23 for an 8GB MS2 card (with Pro Duo adapter) with the intent of extending my mobile's life as a thrifty guy's iPod.

Initially there seemed to be a problem reliably writing files but after re-formatting and using a card reader (rather than the phone cable) to update files, it seems to do the job. I formatted using DOS with the command FORMAT E: /FS:FAT32 /A:4096, check this discussion as to why I chose these options. The phone status only reports a 4GB card but it actually does cope with 8GB.

I'm amazed to fit such a large card on a three year old mobile phone. This is enough space to take a large MP3 music collection (about 50 CD's worth of music, including 15 hours of Wagner's Ring of the Nibelung), 40 podcast subscriptions, a couple of free audio books, various maps supporting my GPS bluetooth gadget, document backups and 2.5GB spare for future growth.

For document backups I use TrueCrypt to keep an encrypted 400MB disk image which can be mounted on my Mac or a PC that includes all my scanned documents over the last two years (I use a Fujitsu ScanSnap scanner to keep PDF versions of bank statements, tax bills etc.) as well as other key reference documents. This may seem an odd thing to keep on the phone but if I was on holiday and my laptop got stolen I could still print out identity documents if someone lent me a PC. By using encryption if the phone was stolen at least I wouldn't worry about my ID being compromised.

My old 4GB memory card? This is now in my pocket camera (Sony T100) giving enough space for 3 hours of 640x480 video or 1,600 photos at 2592x1944 (5MB) resolution.

How to write a spreadsheet formula for ISBN-10 to ISBN-13 and ASIN

I wanted to convert 10 digit ISBNs to the new 13 digit format and vice versa for my "checking second-hand book prices given an ISBN" spreadsheet. It turns out that (for the moment) any ISBN-13 starting with 978 can be converted to an ISBN-10 and this will be the same as the ASIN used by Amazon, so this can be used to look up their data. The problem is that the last digit of the ISBN may change due to it being calculated using a different ISBN standard, so to convert from one to the other your spreadsheet needs to do the checksum calculation.

The following formulae are based on a 13 or 10 digit ISBN in cell A3 and cell A6 reserved for a check digit calculation. These should be in one line in a spreadsheet cell, the layout here is to help readability.

Formula to create ISBN-13 from ISBN-10

=if(
 len(A3)<11,
 concatenate(
   "978",
   mid(A3,1,9),
   mod(
     mid(A3,1,1)*3+
     mid(A3,2,1)+
     mid(A3,3,1)*3+
     mid(A3,4,1)+
     mid(A3,5,1)*3+
     mid(A3,6,1)+
     mid(A3,7,1)*3+
     mid(A3,8,1)+
     mid(A3,9,1)*3,
     10
     )
   ),
 A3
 )

Formula to create ISBN-10 from ISBN-13 (starting with 978)

=if(
len(A3)>10,
concatenate(
  mid(A3,4,9),
  if(A6=10,"X",A6)
  ),
A3
)

To calculate the check digit (A6)

=if(
len(A3)>10,
mod(
  mid(A3,4,1)+
  mid(A3,5,1)*2+
  mid(A3,6,1)*3+
  mid(A3,7,1)*4+
  mid(A3,8,1)*5+
  mid(A3,9,1)*6+
  mid(A3,10,1)*7+
  mid(A3,11,1)*8+
  mid(A3,12,1)*9,
  11
  ),
""
)