Thursday, September 23, 2010

Upside down round and round

˙ɯəs nə sıləɟ oəl ɐʇɹod ləʌ 'ɹoʇɹoʇ ɐpıʌɐɹƃ lsıu ɐuɹn 'ənbıʇsıɹʇ səɔıɹʇln pı ɯəs 'ənbsıɹələɔs ɯɐu ˙uɐsɯnɔɔɐ ʇəƃə ənƃnɐ əɹɐuɹo ɯnʇuəɯɹəɟ ɹnʇıqɐɹnɔ ˙ʇılə ɯnʇɔıp ɔəu 'ısıu ɹolop ʇɐ ɔunu ˙ʇɐ ənbsıɹələɔs lsıu ʇəəɹoɐl ɔɐ 'sıɹnɐɯ sıʇʇıƃɐs əɹənsod ʇuəsəɐɹd ˙ʇılə ƃuıɔsıdıpɐ ɹnʇəʇɔəsuoɔ 'ʇəɯɐ ʇıs ɹolop ɯnsdı ɯəɹol ˙sılnɔɐı uɐsɯnɔɔɐ ınp nə ɯɐıp ʇɐɹəɔɐld sıɹnɐɯ ˙uəıdɐs ɐlnƃıl ʇn uɐəuəɐ ˙ɹoʇıʇʇɹod ıɔɹo ʇɐɹəɔɐld ʇəƃə ɐɹɹəʌıʌ sıɹnɐɯ ʇə ıɯ ɹoʇıʇʇɹod ıqɹoɯ ˙ɯəs sınb ɔɐ sıllɐʌuoɔ ɐɹʇəɹɐɥd ʇılə ʇə oəl nə ɯnlnqıʇsəʌ ˙ənbıʇsıɹʇ ɐ ınp ʇunpıɔuıʇ ʇɐıƃnəɟ ɔəuop ˙sıɹnɐɯ pəs ɐssɐɯ snʇɔəl ɹodɯəʇ ɔɐ 'sıdɹnʇ snqıdɐp ʇıləʌ ɯɐnb 'ʇıɹəɹpuəɥ ɯnʇuəɯɹəɟ əɐʇıʌ sıɹnɐɯ 'ʇəıpɹədɯı əssıpuədsns ˙ɐpɐnsəlɐɯ sɐʇsəƃə ɐssɐɯ ɐpıʌɐɹƃ ənbəu snsɹnɔ uɐəuəɐ ˙snqıdɐp sıdɹnʇ ʇıpuɐlq ʇə ʇɐɹəɔɐld sıɹnɐɯ ɔɐ ɐuƃɐɯ ɹodɯəʇ ɯɐnbılɐ ˙ƃuıɔsıdıpɐ ʇsə ɯnʇuəɯıpuoɔ pı ɐıuıɔɐl oəl ʇn sıdɹnʇ sıʇɐuəuəʌ snlləsɐɥd ˙snsıɹ snʇəɯ ʇɐ sɐuəɔəɐɯ ˙ləʌ ʇıpuɐlq snɹnd snsɹnɔ ʇə 'ɐllnu ʇıdıɔsns snʇɔnl ɯɐu ˙ɔunu ʇɐɹə sıʇɹoqol pəs ˙ıʇuəʇod əssıpuədsns ˙lsıu sıʇʇıƃɐs ɔəu ɔəuop ˙sısılıɔɐɟ sılloɯ ɯıssıuƃıp ɐllnu ˙ʇılə ƃuıɔsıdıpɐ ɹnʇəʇɔəsuoɔ 'ʇəɯɐ ʇıs ɹolop ɯnsdı ɯəɹol ˙snsɹnɔ ıɯ uɐsɯnɔɔɐ ʇə ʇıɹəɹpuəɥ ɯɐnb ʇəƃə ɹolop sılnɔɐı uıoɹd ˙ʇıləʌ ɐɹɹəʌıʌ ʇəƃə əssıpuədsns ˙ɹoʇɹoʇ sıləɟ ɔɐ ʇn ˙ɐuɹn uı ɐ ɯıssıuƃıp ɯnʇuəɯələ sıɹnɐɯ əɐʇıʌ oɹəqıl ɐ ɯɐllnu ˙sıdɹnʇ nɔɹɐ ʇɐ uıoɹd ˙ənbəu əʇuɐ sınb ɔəuop ˙ənƃuoɔ sndɯəʇ snsıɹ əɐʇıʌ ɯɐıp ɯıssıuƃıp snɯɐʌıʌ ˙ɔəu ʇɐıƃnəɟ snɹnd ɹoʇıʇʇɹod puəɟıələ 'nɔɹɐ əɹɐuɹo snʇɔnl ɯɐllnu ˙ɹədɯəs əʇuɐ snɔuoɥɹ nə ʇəəɹoɐl ʇsə pı snʇɔəl snsɹnɔ uı ˙ɹnʇəʇɔəsuoɔ ʇənbılɐ ʇəəɹoɐl uı ˙ɯəs uı əɐʇıʌ ɐllıƃuıɹɟ ʇəıpɹədɯı oɹəqıl ʇɐ soɹə pəs ɯɐllnu ˙sınb sıllɐʌuoɔ ɹolop ɯnpɹəʇuı ʇəƃə 'sıɹnɐɯ ɯnpɹəʇuı ɐʇɹod sıɹnɐɯ ˙oɹəqıl sınb snsıɹ ɔunu əʇɐʇndlnʌ ɹədɹoɔɯɐlln 'ənƃnɐ puəɟıələ lsıu ɔunu 'ʇunpıɔuıʇ opoɯɯoɔ ʇn ɹoʇɹoʇ 'əɹənsod ıqɹoɯ ˙sısılıɔɐɟ ʇəəɹoɐl ɐllnu səlɐpos əɹɐuɹo uı ˙ʇıləʌ ɐpıʌɐɹƃ ʇə əɔsnɟ ˙snqıdɐp ɯɐnbılɐ ɯnʇuəɯıpuoɔ snɯɐʌıʌ ˙ʇıləʌ oəl ʇɐ sɐuəɔəɐɯ ˙sɐʇsəƃə sıdɹnʇ ɔɐ səɯɐɟ ɐpɐnsəlɐɯ ʇə snʇəu ʇə snʇɔəuəs ənbıʇsıɹʇ ıqɹoɯ ʇuɐʇıqɐɥ ənbsəʇuəlləd ˙soɹə ənbəu ɔɐ ənbsınb ˙ɹoʇɔnɐ ɯnıʇəɹd sıɹnɐɯ ʇɐ ɐuɹn ʇə snlləsɐɥd ˙soəɐuəɯıɥ soʇdəɔuı ɹəd 'ɐɹʇsou ɐıqnuoɔ ɹəd ʇuənbɹoʇ ɐɹoʇıl pɐ nbsoıɔos ıʇıɔɐʇ ʇuəʇdɐ ssɐlɔ ˙ʇəƃə sıʇʇıƃɐs nɔɹɐ ɹnʇəʇɔəsuoɔ ʇəɯɐ ʇıs 'soɹə uıpnʇıɔıllos ɯnpuəqıq ɯɐnbılɐ ˙sıʇɐuəuəʌ əʇɐʇndlnʌ ɯnʇuəɯıpuoɔ ıqɹoɯ ˙snɹnd sndɯəʇ ʇə ʇn ˙ɹɐuıʌlnd puəɟıələ ɥqıu ɐlnɔıɥəʌ soɹə ɐ ənbsınb ˙snqıdɐp ʇɐɹəɔɐld snlləʇ ʇəəɹoɐl ʇɐdʇnloʌ ənbsəʇuəlləd ˙ʇɐɹə ɯıssıuƃıp ʇəƃə 'ısıu ɐssɐɯ ʇɐ ɔəuop ˙snlləʇ ʇıləʌ ʇɐ ɯɐllnu ˙snʇɔnl ənƃuoɔ ɹoʇɔnɐ ɯɐllnu ˙ıɔɹo ɯnʇuəɯələ ɔəu ʇn ˙uou sıʇɐuəuəʌ ɐllnu snsɹnɔ ɔɐ 'sıdɹnʇ ʇunpıɔuıʇ ənbsıɹələɔs ɹnʇıqɐɹnɔ ˙sıʇʇıƃɐs səɔıɹʇln ɯɐnb əʇɐʇndlnʌ ɐuƃɐɯ ʇəıpɹədɯı sınp ˙snʇɔəl ʇəƃə snqıdɐp 'ɔəu ʇənbılɐ ʇəɯɐ ʇıs sıʇʇıƃɐs 'ıɔɹo snɔɐl əɔsnɟ ˙ɐıuıɔɐl ʇıpuɐlq əıʇsəloɯ uıoɹd ˙ənƃnɐ pəs ʇn ʇıpuɐlq ʇɐdʇnloʌ ɐuɹn ʇn oɹəqıl ʇn ənbsəʇuəlləd ˙oəl ɹədɯəs sınb 'ənƃnɐ ʇılə ʇɐ sɐɹɔ ˙sɐʇsəƃə sıdɹnʇ ɔɐ səɯɐɟ ɐpɐnsəlɐɯ ʇə snʇəu ʇə snʇɔəuəs ənbıʇsıɹʇ ıqɹoɯ ʇuɐʇıqɐɥ ənbsəʇuəlləd ˙ɐɹɹəʌıʌ ɐɹɹəʌıʌ ɯɐıp ʇəɯɐ ʇıs ɐuƃɐɯ pı ʇn ˙ʇılə ƃuıɔsıdıpɐ ɹnʇəʇɔəsuoɔ 'ʇəɯɐ ʇıs ɹolop ɯnsdı ɯəɹol ˙əɐʇıʌ ənƃuoɔ ɯɐıp ʇıpuɐlq ʇə 'ɯɐnb opoɯɯoɔ ʇɐıƃnəɟ snlləsɐɥd ˙ɯıuə ʇıdıɔsns ʇəɯɐ ʇıs 'ʇılə nɔɹɐ ɐ ɯɐllnu ˙ɯnsdı əɐʇıʌ ɐpɐnsəlɐɯ 'uou əɹɐuɹo nə ɯnpuəqıq 'ənƃnɐ ʇılə ɹəƃəʇuı ˙oəl ʇn ʇɐıƃnəɟ 'ʇə ɯnʇuəɯıpuoɔ ləʌ sndɯəʇ 'ɯɐnb nɔɹɐ ɹəƃəʇuı ˙sıʇʇɐɯ snsɹnɔ ɐssɐɯ ɔəu ɯnsdı uɐsɯnɔɔɐ ɯɐu ˙sıʇʇıƃɐs pı ɹolop snsɹnɔ səlɐpos ıqɹoɯ ˙ɐuƃɐɯ ɐʇɹod sınb 'snlləʇ oıpo ʇəɯɐ ʇıs ɯɐllnu ˙sıləɟ ʇɐ sılloɯ 'ɔəu snɔuoɥɹ ʇn ɯnʇuəɯələ 'lsıu snsıɹ ʇuəsəɐɹd ˙uəıdɐs ɔəu səɔıɹʇln 'ɔəu əɹɐuɹo ʇɐ ɯnpɹəʇuı 'ʇıləʌ ɔunu ɯɐu ˙snsıɹ sınb ənbsıɹələɔs 'əɐʇıʌ ɐɹʇəɹɐɥd ʇɐ snɔuoɥɹ 'ʇıləʌ sıɹnɐɯ əssıpuədsns ˙uıpnʇıɔıllos ɐuƃɐɯ ɐpıʌɐɹƃ uı əɹənsod snʇɔəl ɔəu nɔɹɐ ɐllıƃuıɹɟ snɯɐʌıʌ ˙ɹədɯəs ɹnʇəʇɔəsuoɔ ɐllıƃuıɹɟ ənbsınb ˙ənbəu ɐ ɔəu snıɹɐʌ ɹədɯəs snlləʇ pı snsıɹ əɹɐuɹo ɯnlnqıʇsəʌ ˙ɐlnƃıl ʇəɯɐ ʇıs ɯnʇuəɯələ 'ɐʇɹod ʇıɹəɹpuəɥ ʇɐ əʇɐʇndlnʌ 'ɯıuə ısıu ɔunu ˙ənbıʇsıɹʇ ɐlnƃıl ʇəıpɹədɯı poɯsınə ɯnʇuəɯələ ɯɐıp ɔɐ ɐssɐɯ ɯnʇuəɯɹəɟ snɯɐʌıʌ ˙ɐlnƃıl pəs ɯnpuəqıq 'sınb ɯnʇuəɯıpuoɔ ʇɐ puəɟıələ 'ɯɐıp snlləʇ sɐuəɔəɐɯ ˙sıləɟ ɯnpuəqıq ləʌ ɯɐıʇə ˙ɐɹʇəɹɐɥd sıləɟ snsɹnɔ ɐ sısılıɔɐɟ lsıu uou ɯıuə əɹənsod uıoɹd ˙sıɹnɐɯ əɐʇıʌ ʇə ʇıdıɔsns ɯıssıuƃıp snlləʇ nə snʇɔəl pəs uɐəuəɐ ˙sɐʇsəƃə ʇunpıɔuıʇ oɹəqıl pı ənbəu ɐpɐnsəlɐɯ ʇuəsəɐɹd ˙ʇılə ənbıʇsıɹʇ ɐpıʌɐɹƃ 'əɐʇıʌ ɐʇɹod ʇə əʇɐʇndlnʌ 'snsıɹ snʇəɯ ɯɐıʇə ˙snıɹɐʌ ʇıɹəɹpuəɥ sıdɹnʇ ʇɐ oɹəqıl poɯsınə sınp ˙oəl ʇɐ sıɹnɐɯ sıɹnɐɯ poɯsınə ʇɐıƃnəɟ 'lsıu ɯnlnqıʇsəʌ oəl ɯəɹol 'sıʇʇıƃɐs puəɟıələ ʇn oəl 'əɹənsod ənbsınb ˙uəıdɐs ɯnsdı ɔəu ɹnʇıqɐɹnɔ ˙ʇılə ƃuıɔsıdıpɐ ɹnʇəʇɔəsuoɔ 'ʇəɯɐ ʇıs ɹolop ɯnsdı ɯəɹol

Friday, September 10, 2010

I am Not the STIG

So here is my theory on STIG -gate.

Background:
Top Gear is a great show, loads of viewers and has a very strong brand, here in the UK and around the world.
It has however come under a lot of flack from people saying its just 3 grown men acting like teenagers in cars (I think this is the whole idea, but anyway) and a lot of people saying it's boring and past it.
In some ways I agree about it being same story different packaging each season, but like any good brand if it works, why would you change it (think Coke and Coke Classic from the 80's).

The STIG is a media icon, a silly name (its means 'path' I think in Swedish) but another globally recognised brand, possibly a longer lasting brand if the TG show was axed you could quite easily see this character popping up in different show formats?

Theory (Okay I might be a little cynical):
If I was the BBC or whoever produces the TG show and I needed to guarantee some ratings, how would I best do this?
- Fire a presenter? dangerous, they might write a book or start their own show (ah most of them have anyway) and finding a replacement would be tough.
- Change the format? not worth the risk and cost
- Kill the STIG? They have done this on a few occasions, and he magically appears again even more powerful then before -http://www.topgear.com/uk/videos/the-stig--hms-invincible
-Piss the man in the white suit off enough to force him to try and make some cash (or even tell him to reveal himself) a different way.

So the Stig has been unmasked, now they have a gap to fill, what will they do with all of this 'press' coverage?
My guess is the Stig will magically reappear and be as elusive and 'exotic' as ever before and we will still not know who is the Stig again, it could be anyone or it could be Ben Collins, who knows and to be honest anyone who watches the show probably wont care.
The fact there is a mystery person inside the suit is all that anyone really cares about, we know this person has changed before in the past, there are loads of YouTube footage of the different Stig's tall, short, tanned
The other 3 presenters have all made a bomb out of the show, the Stig was on £70k a year and I am pretty sure was not in on the merchandising payroll. So why not try and get a few quid (I heard £230k banded around for the book deal) out of what could''ve been the last year for the Stig anyway, if the show is cancelled then what really?

I was amazed that once the court injunction went through and he was seen without his white helmet, the 3 presenters were all doing the media rounds saying how disappointed they were, Clarkson said he had the stig around for dinner and felt betrayed (a little Clarkson humor me thinks).
Noramlly to get these guys involved in anything takes a lot of pressure from the BBC etc, but they were amazingly free to take questions....

So to the man/lady behind the unveiling should get a pat on the back, they have created a media frenzy over something that in the real world (outside of TV) is not very exciting.
But has guaranteed the viewing figures for the first TG next season will be through the roof and that Ben Collins book will be on the top of every TG viewers Christmas list.

I will be watching the first show and probably will get the book if I ask Santa nicely (wonder who he really is?)

Wednesday, September 08, 2010

Exporting Excel 2010 to XML

After many expletives and banging of keys, I finally found that it is really easy to export an excel sheet to XML – that is as long as you remember to;

 

1-      Turn the developer tab on in the ribbon

2-      Create a valid XML file to map to (the special word is valid, it might be valid to us mere mortals but Excel is an odd beast)

3-      Map it up

4-      Export – no really that’s it

 

 

1- Turn developer bar on

File -> Options -> Customize Ribbon -> From the Main tabs list on the right tick the developer tickbox -> OK

 

Once this is turned on go to the developer tab and click the Source button.

A new panel will appear (empty probably) this is where the XML file will be once it has been mapped.

 

 

2 – Create an XML file

 

<services>

    <Service>

        <code></code>

        <description></description>

        <comment></comment>

    </Service>

    <Service>

        <code></code>

        <description></description>

        <comment></comment>

    </Service>

</services>

 

The important bit to note is the 2nd instance of the service node, if you only have a single instance, excel only allows you to export the top row of your data….. hmm a bug maybe?

Save your  XML mapping file somewhere easy to find (don’t delete this as you will need this if you ever need to export the data again, it’s not stored as part of your workbook)

 

 

3- Map it up

 

Back in Excel, Click the XML Maps button from the XML panel and select an XML file you just created, if asked click yes on the schema message box (saves time unless you want to make your one).

Once the mapping structure is in right click on any of the nodes and click Map Element, now select the range of data from the excel sheet you want to populate your XML file.

If your nodes and columns are ordered the same, you can right click on the top level mapping node and map the whole XML file to all of your columns in one go.

 

 

4- Export

 

Now click the Verify Map for Export, if all went well Excel will now be able to export your data using your XML mapping file via the Export button in the developer tab.

 

 

goodluck