Removing backgrounds from images in PowerPoint 2007

Posted on By Mark Wilson

One particularly useful feature in PowerPoint 2010 is the ability to remove backgrounds from images. Unfortunately for me, since I returned to using a corporate PC build (after years of building my own, I succumbed to the standard build as the bureaucracy of adding a machine to the domain, installing encryption software, etc. became too much to bear) I’ve gone back to  Office 2007 and that feature is no longer available to me.

But there is a way – last week I found out how to remove the background from an image in PowerPoint 2007.  By selecting the image, then chosing Recolor from the Format menu, it’s possible to Set Transparent Color.

Obviously this is not as simple as in PowerPoint 2010, and it will only work for plain backgrounds, but it can still come in useful at times…

Using LinkedIn as a B2B social media platform (#smwmecsocial #smwldn)

Posted on By Mark Wilson

Yesterday, I wrote about an event I’d attended as part of Social Media Week London, hosted by MEC Global, looking at thought leadership and B2B social media. For reasons of brevity, I skipped over much of LinkedIn‘s presentation in my original post but it provided a lot of insights that I would like to share… so here’s the follow-up!

LinkedIn’s Colin Smith was talking about the role of social in a digital ecosystem and he started out by saying that social media in 2011 was a bit of a knee-jerk reaction to an emerging audience, with organisations testing campaigns and activity, predicting that 2012 will be the year when social gets down to business.

Brands are now what people say they are, and:

“The impact of social media is far-reaching,well beyond how we connect with our friends.It has changed how we work. It is changing how we make markets. It has, critically, re-leveled the playing field.”

[George Gallate, Global Chairman, Euro RSCG 4D]

Citing various statistics from a recent CIM/Ipsos ASI study (Social Media Benchmark), Colin Smith highlighted that:

  • Consumers want to be engaged in a conversation – not sold to.
  • Brands are now what people say they are.
  • Business is evolving – moving from transactional to relational. This affects the speed to close deals, the size of those deals and the length of the relationship.
  • Liking, sharing and commenting are all emotions – we need to build an emotional relationship with our customers [I agree: people buy from people – not brands, although there are some brands that will always be considered “safe bets”].
  • Decision cycles in B2B take longer than in B2C – longevity makes a difference in the relationship.
  • People will, on average, follow just 2.8 companies in a given sector, but 50% will follow a company in perpetuity – so you want to your brand to be in that 2.8!
  • Don’t forget that your staff  have profiles, engage with, and are probably connected to competitors and customers – people will check what your staff profiles look like.
  • Sometimes you’ll know that someone is talking about you, sometimes you don’t – some reactions will be negative and some positive.

It’s important to consider that customers have [LinkedIn – and other social network] profiles too. Before they come to meetings they will check out yours, your staff, your company page, what people are saying and come armed – you need to do the same. They follow, like, share, comment – and expect engagement. They connect to your staff and communicate with them. And they will trust you if communicate and share useful information.

  • Social hygiene is about the ways in which people [your audience: customers; staff; business partners] expect you to engage. It’s about having an authentic voice and sharing. Businesses have a challenge to be open, authentic, honest, engaging.
  • Don’t just ask an agency to do this – it needs to go to the core of the business – the CEO, or others who are senior enough and have the credibility [and charisma] to speak on behalf of a brand.
  • Think about social media in the context of employment – it reflects your brand (even if you don’t employ someone they may make buying decisions elsewhere).

Colin gave some advice for engaging on LinkedIn:

  • Engagement starts with creating a presence, for example, a company page built out on LinkedIn. Many of these are generated through algorithms so claim yours and make it say what you need it to.
  • Once you have the presence right, think about who want to attract (think about a specific audience – CEOs, CIOs, procurement advisors, etc.) – LinkedIn can target specific audiences. Samsung ran a LinkedIn campaign and gained 20000 followers in 3 days. Mercedes were looking at just the C-suite and gained 12000 followers in 5 weeks. These are not just big numbers, they are highly targetted and therefore the reach is potentially significant.
  • Continue to engage through company status updates – provide value at scale. LinkedIn has found that 45% would like weekly updates.
  • Amplify – as with engagement, think who followers are connected to (LinkedIn average is 151 connections per person).
  • The only cost is building a content strategy, the hard bit is acquiring followers.
  • Groups can be used to position a company as a thought leader in an existing conversation or a topic that’s important. For example, Statoil is facilitating a conversation for people to talk about energy innovation. A strategy for content will be required when the group is first started (initial 3-6 months) after which it should take on a life of its own.

Involving your brand in a social conversation

Finally, Colin gave some tips for better use of LinkedIn [although many of these could equally be applied to other channels]:

  1. Improve your company page to attract a more relevant audience.
  2. Consider engagement with followers – questions and topics to seed into a group.
  3. Members expect insights and news from companies they follow: 66% expect industry insight; 65% expect upcoming company news (advance information before it hits the press); 45% expect the opportunity to join a group; 45% expect sneak peeks of upcoming products and services; and 43% desire inclusion in a community with similar interests.
  4. Interrogate the social hygiene of your company.
  5. Work across departments so that all customer-facing departments have profiles that are relevant to your company – make sure your brand is represented across the board with links to company pages, blogs, etc. Think about whether modifying a LinkedIn profile is part of the induction process for new employees – and, equally, what people say when they leave.

As an individual, I don’t use LinkedIn as a daily destination – it’s still about professional networking for me. For daily conversations, I prefer the immediacy of Twitter (besides, some of my tweets are more suitable for that audience – and the frequency would  just be too high for LinkedIn) but I took a lot away from this presentation about how brands might better engage on the platform.

One thing’s for sure, as MEC’s Shane O’Byrne highlighted at yesterday’s event, B2B social media requires effort on the part of the company, and cannot just be left to an agency. That means applying resource, possibly dedicated, but certainly as part of their work (not as an add-on to do “in their spare time”) to generate content that makes an audience want to engage.  That’s been the challenge that I’ve struggled with in my own work on corporate blogs and other B2B social media activities over the last couple of years – and making a B2B brand become “social” is a lot more work than simply setting up a few accounts on major platforms…

Thought leadership and B2B social media (#smwmecsocial #smwldn)

Posted on By Mark Wilson

This week is Social Media Week in London and there are a lot of events taking place at a variety of locations. I’m not London-based, but I do work there for a couple of days each week and I booked onto some that look particularly relevant to my role – the first of which was hosted by the social media team at MEC Global (@MECsocial), looking at thought leadership and the role of social media in B2B communications.

To be honest, it was a bit light in places on the “thought leadership” angle (MEC covered this, the invited guests less so) but I was pleased to see someone taking a serious look at B2B social media. In my experience most of the “advice” given at events like this is very B2C (or even C2C)-focused and when asking about specific challenges for B2B it’s often brushed under the carpet.

With presentations from MEC Global, LinkedIn and the Telegraph Media Group, followed by a panel discussion, there was a lot of information provided but I’d like to concentrate on just a few highlights.

Organisational considerations for social media

MEC’s Shane O’Byrne (@shaneysean) opened up the event with some organisational considerations for B2B social media. Taking the view that, in stark contrast to B2C (which is 80% agency, 20% client), B2B social media requires more client input (the 80:20 split is reversed), with the agency helping organisations to deliver thought leadership externally. Considerations include:

  • Hard vs. soft approach.
  • Thought leadership.
  • Lead generation.
  • C-suite.
  • Sales.
  • Credibility.
  • Prospect.

And, whilst Shane didn’t go into detail (after all, he’s showing just an insight – let’s call it thought leadership – maybe I should engage with MEC for more detail), in general, it’s about bringing people into a community, thinking about when to approach and move them down the pipeline, and shaping conversations with potential clients rather than selling.

Thought leadership may include advice about the marketplace, culture, political landscape, and even some “crystal ball” gazing; and Shane has seen success in organisations who have found the right seniority of stakeholders using a social media council – working as experts to nurture talent and expertise, turning that into rich content for digital ecosystem.

That digital ecosystem was a topic of conversation for LinkedIn’s Colin Smith and, I’ll hold back on that for a future blog post but Richard Fitzgerald, also from MEC (@fitzyrichard) spoke about the need to avoid treating social media in isolation – integrating with other channels.

Richard recommends setting a mission statement – whether that is a philosophy, a brand campaign, a goal, or a business objective, and building on top of that.  In terms of time allocation, a rough split might be:

  • 70% resource planning, data and insights, content audits, market analysis, futures studies (what are people expecting to hear about?).
  • 20% community management – engagement strategy, moderation guidelines, escalation documents, editorial guidelines, content calendars.
  • 10% for the unpredictable – breaking news, crisis management, reactive content, real time engagement and tactical campaigns.

Social is another means of communication, to be ignored at your peril

Matthew Margetts and Jonathan Davies spoke about the Telegraph Media Group’s experiences of social media, which they regard as another means of communicating and not as superseding a web presence or any other form of communication.

I was particularly interested to hear about their experience of digital media consumption. The Telegraph Media Group is a brand, a content provider and it has commercial solutions (with declining newspaper sales but new markets including competition applications, social video, bespoke applications and Twitter). And, on that last point – Twitter as a channel:

[blackbirdpie url=”https://twitter.com/#!/markwilsonit/status/169719030024900608″]

That shows that Twitter should not be ignored and, although monetising the output might be a challenge, there are opportunities to establish presence, create a groundswell of opinion, establish oneself as a thought leader, and become a recognised (and respected) brand – all of which have positive effects later – even if they don’t lead to direct sales.

Pick your channels with care; and who owns that social profile?

The event finished up with a panel discussion and there were two main areas of interest for me here.

Firstly, there’s a lot of talk about relative sizes of social networks (Facebook is huge, Twitter is pretty big too, Google+ may be significant too, and LinkedIn is relatively small) but then think about the audience that you are targetting.

[blackbirdpie url=”https://twitter.com/#!/markwilsonit/status/169725899212730368″]

This tweet is based on information given by Colin Smith from LinkedIn and, whilst it clearly plays into LinkedIn’s market position (connecting professional people), I think it makes a powerful point: perhaps the majority of those 800m people on Facebook are not actually your target audience?  Perhaps Saleforce.com Chatter might serve an organisation well, in a B2B context?

Finally, who owns your social profiles? Well, I’m pretty determined that I own my LinkedIn presence, this blog, my Twitter stream, etc., many of which predate my employment, but a communications director might take a different view, said the panel!  One argument is that you learned the points that you communicated whilst you were working for the company (but do we? Some might argue that we build personal brands, based on experience with a variety of roles and employments). There may be cultural differences between personal and company accounts and Matthew Margetts highlighted that The Telegraph has guidelines but, equally, it employs “contrarian thinkers who are encouraged to give their opinions”. Maybe some brands are threatened by the rise of the “personal brand” – that will depend on the company and the market. One thing’s for sure – this particular issue is far from clear cut and looks set to become more and more significant, most likely to be settled in the courts…

Useful to know: Google Chrome has its own task manager

Posted on By Mark Wilson

Earlier today, I was wondering why I was seeing a “missing plug-in” message in Google Chrome on a number of websites that I regularly view. I loaded the same websites in Internet Explorer and they worked OK, so something had obviously gone screwy inside Chrome. I could have guessed – it was Flash, although normally I get a yellow bar to tell me that has stopped working.

I rebooted my PC yesterday, so I don’t plan to do that again for another couple of weeks (until the memory leak that one of my apps has gets so bad that I’m forced to…) but I googled missing plug-in google chrome to see what comes up. As it happens, Chrome has a task manager built in (press shift and escape).  After ending the Shockwave Flash process, I refreshed the offending page(s) and everything worked as it should.

By then I was intrigued by the stats for nerds link which takes me to chrome://memory-redirect/ – an internal page that contains a breakdown of activity by process (including which tabs are managed by which processes) – which would have been handy to know about when Chrome had gobbled up a good chunk of my RAM earlier this week:

[blackbirdpie url=”https://twitter.com/#!/markwilsonit/status/167195412262961152″]

If anyone knows a similar memory management function for Internet Explorer, I’d be pleased to hear it as the relationship between tabs and processes seems to be a black art (and it may help to chase down problematic tabs) – I’ve tried Process Explorer and Windows Task Manager in the past, but it would be useful IE functionality…

Just bought the latest smartphone? Your old “brick” might come in useful somewhere too!

Posted on By Mark Wilson

I bought my first mobile phone in 1995 (a Nokia 2140). At the time my friends thought I was “yuppie” and there was a bit of a social stigma attached (to be fair, I was a bit of an idiot about it) but, within a couple of years mobiles were starting to become universally accepted…

Fast forward almost two decades and, a couple of weeks ago, I was at an event where Telefonica O2’s vice president of research and development, Mike Short, mentioned that there are now 6 billion mobile devices in our world and that’s still growing at a phenominal rate. The telcos count this based on subscriptions (which includes feature phones, smartphones, tablets, mobile payment systems, and more) but have you ever thought about the uses that old mobile handsets can be put to?

I have a Nokia 6021 that I keep as a spare handset (it’s pretty dumb, but makes calls, has Bluetooth, battery lasts a while, and it’s almost indestructable) but most of my other handsets have been sold or recycled over the years.

O2’s recycling scheme supports their Think Big programme but I’d like to think there’s a fair chance that old handsets can find a use in the developing world too. Because mobile commerce is not just about smartphones – the Mobile Internet and NFC – but, in parts of the world where bandwith is more scarce, there are many examples of mobile projects using SMS, or even a missed call:

So maybe it’s time to dig out that old mobile that’s gathering dust somewhere and send it for recycling? Even if there is limited financial reward for you, it might still have a life elsewhere, or, at the very least the components can be recycled for environmental purposes.

Culinary creations and “International English”

Posted on By Mark Wilson

As a bit of a foodie, I’ve always enjoyed creating meals although, if I’m perfectly honest, I normally do the “glory cooking” when we’re entertaining friends, and my wife looks after much of the everyday food preparation.

Right now, Mrs W. is very busy in her work (for which I’m very grateful – freelancers need to “make hay whilst the sun shines”!) and that means that I need to pick up a few more tasks around the house. Combined with my need to eat healthily and carefully count calories (I still have another 5kg to lose before the end of March) I’m currently taking on most of the responsibility for our meals, spending a good chunk of the last two weekends in the kitchen, with a good share of my culinary creations heading towards the freezer for use as ready meals.

I’m no Masterchef contender, but my food generally seems to go down well, and it’s good to try something different from time to time. Last weekend, I was creating a Spanish-inspired meal for friends and I decided to make Crema Catalana for desert.  The recipe I followed is pretty simple but I found myself thrown by two things:

  1. “Cups” of ingredients (give me grammes, or even pounds and ounces).
  2. Strange terms like cornstarch (could that be cornflour?)

I finally found a use for a kitchen computer as, with a little help from my smartphone, I had determined that quantity in a “cup” depends on the product. There’s a handy reference at AllRecipes.com. So that was number 1 sorted. As for 2., well, yes “cornstarch” is what we, in England, call “cornflour” and there’s a useful Wikipedia entry on “International English” food terms.

[English is the language spoken by (most) people in England and adopted by many other nations. Some of the variations even make sense (color instead of colour, for example) but I speak, read and write English – and find the term “International English” to be nonsensical. There is English, and there is American, Australian, etc. I know that languages constantly evolve, but… OK, I’ll come down off my soapbox now.]

My time in the kitchen is not normally a topic for this blog but I thought these references might be useful for others. As well as for me, next time I’m confused by a recipe written in “International English”.

Trying to tether the Nokia Lumia 800

Posted on By Mark Wilson

Since my company-supplied SIM stopped working in my iPad (it’s not blocked – it works in a 3G dongle, just not in the iPad…) I’ve been looking at other solutions. Before we switched from Vodafone to O2, I had a fantastic Wi-Fi router but the software needs a Vodafone SIM so that’s not working for me any more.  Another option is to use my smartphone as a modem: my company-supplied iPhone does not have the personal hotspot functionality enabled (and it’s not jailbroken either), so that leaves my personal Nokia Lumia 800; except that Internet sharing isn’t available on that device…

I spent a bit of time yesterday evening looking into this and, even though I was ultimately unsuccessful, I thought I’d share my research, in case it comes in useful later:

  • If you’re thinking of using the Lumia 800 as a Bluetooth modem, you’re out of luck.  According to Nokia’s device specifications the supported Bluetooth profiles are A2DP 1.2, AVCTP 1.0, AVDTP 1.0, AVRCP 1.0, AVRCP 1.3, GAVDP 1.2, HFP 1.5, HSP 1.1, PBAP 1.0, RFCOMM 1.0, and SPP 1.0. It’s also missing FTP, OPP and GEOP so file/contact transfers are out of the question too…
  • Nokia Lumia 800 driver installation fails on Windows 7For a cable-based solution, there is a method of tethering LG and Samsung phones that involves enabling diagnostics mode and switching into serial mode (more information at ilaptopphone.com, mywpstory.com and mobilitydigest.com). I used the same method to switch the Lumia into serial mode (requires a reboot and disables Zune sync, until you switch it back again) but Windows was unable to find any drivers.
  • Windows Phone connection not shared errorInternet Sharing in Windows Phone settingsInternet sharing tile on Windows Phone, enabled with Supreme ShortcutsThe Supreme Shortcuts app was another route I tried – it can be used (on an unlocked phone) to enable an Internet Sharing icon for a Settings option that’s hidden on the Lumia 800. Sadly, turning it on results in a dialogue that says “Internet sharing isn’t currently available” – I suspect I might be able to do something in the registry, if only there was an interop unlock available for the Lumia 800, and there isn’t at the time of writing…

There is a glimmer of hope though. Some reports indicate that Nokia will enable tethering in a future update (I believe the Lumia 900 has this feature) but there is no date given yet (just some time in 2012).  I do hope it comes soon though – the Lumia 800 is a great handset but it’s held back by far too many artificial software limitations…

Useful Links: January 2012

Posted on By Mark Wilson

A list of items I’ve come across recently that I found potentially useful, interesting, or just plain funny:

  • TimeRime – Create and view timelines of historical events (via Mark Locke)
  • ITU statistics on global ICT usage – A collection of statistics from the International Telecommunications Union (ITU) (via Mark Locke)
  • Minty Geek – Compact components that slot into a neat little mints tin: making learning electronics and building circuits fun and easy (via Computing)
  • DoesFollow – Find out who follows whom on Twitter (great for checking if someone follows you when you have more than a few tens of followers)
  • Scale of the universe – Amazing interactive scale of the universe tool (via Jason Perlow and Adi Kingsley-Hughes)
  • Vocabulary.com – Learn new words

Last Orders at The Fantastic Tavern (#TFTLondon)

Posted on By Mark Wilson

About a year ago, I wrote about a fantastic concept called The Fantastic Tavern (TFT), started by Matt Bagwell (@mattbagwell) of EMC Consulting (ex-Conchango – where I also have some history). Since then I’ve been to a few more TFTs (and written about them here) and they’ve got bigger, and bigger. What was a few people in a pub is now a major logistical challenge and Matt’s decided to call it a day. But boy did it go out with a bang?!

Last night’s TFT was at Ravensbourne (@RavensbourneUK) – a fantastic mixture of education and business innovation hub on London’s Greenwich peninsula. I was blown away by what Chris Thompson and the team at Ravensbourne have achieved, so I’ll write about that another day. Suffice to say, I wish my university had worked like that…

Last night’s topic was 2012 trends. Personally, I thought the Top Gear-style cool wall (“sooo last year, tepid, cool, sub-zero”) was way off the mark (in terms of placing the trends) but that doesn’t really matter – there were some great pitches from the Ravensbourne students and other invited speakers – more than I can do justice to in a single blog post so I’ll come back and edit this later as the presentations go online (assuming that they will!)

The evening was introduced by Mike Short, VP of Innovation and R&D at O2/Telefonica who also sits on the board of governors at Ravensbourne and so is intimately involved in taking an institution with its rooms in Bromley College of Art (of David Bowie fame) from Chiselhurst to provide art, design, fashion, Internet and multimedia education on Greenwich Peninsular, next to the most visited entertainment venue in the world (The O2 – or North Greenwich Arena). Mike spoke about O2’s plans for an new business incubator project that O2 is bringing to London in the next 3 months as O2 looks at taking the world’s 6bn mobile device subscribers (not just phones, but broadband, payment systems, etc.) to connect education, healthcare, transport and more. In an industry that’s barely 25 years old, by the end of the year there will be more devices than people (the UK passed this point in 2006) and the market is expected to grow to more than 20bn customers by 2020.

Matt then spoke about the omni-channel world in which we live (beyond multi-channel) – simultaneously interacting on all channels and fuelling a desire “to do things faster”.

Moving on to the 2012 trends, we saw:

  • A. Craddock talking about smart tags – RFID and NFC tokens that can interact with our mobile devices and change their behaviour (e.g. switch to/from silent mode).  These can be used to simplify our daily routine to simply enable/disable functionality, share information, make payments, etc. but we also need to consider privacy (location tracking, etc. – opt in/out), openness (may be a benefit for some), ecology (printable tags using biodegradable materials) and device functionality (i.e. will they work with all phones – or just a subset of smartphones).
  • Riccie Audrie-Janus (@_riccie) talking about how, in order to make good use of technology, we need to look at the people element first.  I was unconvinced – successful technology implementation is about people, process and technology and I don’t think it matters that kids don’t understand the significance of a floppy disk icon when saving a document – but she had some interesting points to make about our need to adapt to ever-more-rapidly developing technology as we progress towards an ever-more complex world where computing and biology combine.
  • @asenasen speaking about using DIY healthcare to help focus resources and address issues of population growth, economics and cost. Technology can’t replace surgeons but it can help people make better healthcare decisions with examples including: WebMD for self-diagnosis; PatientsLikeMe providing a social network; apps to interact with our environment and translate into health benefits (e.g. Daily Burn); peripheral devices like FitBit [Nike+, etc.] that interact with apps and present challenges. It’s not just in the consumer space either with Airstrip Technologies creating apps for healthcare professionals. Meanwhile, in the developing world SMS can be used (ChildCount), whilst in Japan new toilets are being developed that can, erhum, analyse our “output”.  Technology has the potential to transform personal health and enable the smart distribution of healthcare.
  • Matt Fox (@mattrfox) talked about 2012 becoming the year of the artist-entrepreneur, citing Louis CK as an example, talking about dangerous legislation like SOPA, YCombinator’s plans to “Kill Hollywood”, Megabox (foiled by the MegaUpload takedown) and Pirate Bay’s evolution of file sharing to include rapid prototype designs. Matt’s final point was that industry is curtaining innovation – and we need to innovate past this problem.
  • Chris Hall (@chrisrhall) spoke about “Grannies being the future” – using examples of early retirement leaving pensioners with money and an opportunity to become entrepreneurs (given life expectancy of 81 years for a man in the UK, and citing Trevor Baylis as an example). I think hit onto something here – we need to embrace experience to create new opportunities for the young, but I’m not sure how many more people will enjoy early retirement, or that there will be much money sloshing around from property as we increasingly find it necessary to have 35 year and even multi-generation mortgages.
  • James Greenaway (@jvgreenaway) talked about social accreditation – taking qualifications online, alongside our social personas. We gain achievements on our games consoles, casual games (Farmville), social media (Foursquare), crowdsourcing (Stack Overflow) etc. – so why not integrate that with education (P2PU, eHow and iTunes U) and open all of our achievements to the web. James showed more examples to help with reputation management (spider  graphs showing what we’re good at [maybe combined with a future of results-oriented working?]) and really sees a future for new ways of assessing and proving skills becoming accepted.
  • Ashley Pollak from ETIO spoke about the return of craft, as we turn off and tune out. Having only listened to Radio 4’s adaptation of Susan Maushart’s Winter of Our Disconnect the same day, I could relate to the need to step back from the always connected world and find a more relevant, less consuming experience. And as I struggle to balance work and this blog post this morning I see advantages in reducing the frequency of social media conversations but increasing the quality!
  • Ravensbourne’s Chris Thompson spoke about virtual innovation – how Cisco is creating a British Innovation Gateway to connect incubators and research centres of excellence – and how incubation projects can now be based in the cloud and are no longer predicated on where a university is located, but where ideas start and end.
  • The next pitch was about new perspectives – as traditional photography dies (er… not on my watch) in favour of new visual experiences. More than just 3D but plenoptic (or light field) cameras, time of flight cameras, depth sensors, LIDAR and 3D scanning and printing. There are certainly some exciting things happening (like Tesco Augmented Reality) – and the London 2012 Olympics will e filmed in 3D and presented in interactive 360 format.
  • Augment and Mix was a quick talk about how RSA Animate talks use a technique called scribing to take content that is great, but maybe not that well presented, and make it entertaining by re-interpreting/illustrating. Scribing may be “sooo last year” but there are other examples too – such as “Shakespeare in 90 seconds” and “Potted Potter”.
  • Lee Morgenroth’s (@leemailme‘s) pitch was for Leemail – a system that allows private addresses to be used for web sign-ups (one per site) and then turned on/off at will. My more-technically minded friends say “I’ve been doing that for years with different aliases” – personally I just use a single address and a decent spam filter (actually, not quite as good since switching from GMail to Office 365) – but I think Lee may be on to something for non-geeks… let’s see!
  • Finally, we saw a film from LS:N profiling some key trends from the last 10 years, as predicted and in reality (actually, I missed most of that for a tour of Ravensbourne!)

There were some amazing talks and some great ideas – I certainly took a lot away from last night in terms of inspiration so thank you to all the speakers. Thanks also to Matt, Michelle (@michelleflynn) and everyone else involved in making last night’s TFT (and all the previous events) happen. It’s been a blast – and I look forward to seeing what happens next…

[I rushed this post out this morning but fully intend to come back and add more links, videos, presentations, etc. later – so please check back next week!]

Changing Word’s bibliography style to use square parentheses

Posted on By Mark Wilson

One of my main activities right now is writing a white paper discussing how linked data potentially provides a solution to one of the problems that big data creates. I’m sure I’ll tweet the link when it’s published but, for a sneak preview of the main points, check out my lightning talk at CloudCamp London next week.

Unlike most of the stuff I create these days, it’s written for architects, rather than for a CIO/CTO and so the style is more of a technical journal than a piece of marketing collateral. That’s meant lots of graphics and fully-detailed sources. I’ve never used the citation capabilities in Microsoft Word before (I did write my dissertation in Word 2.0 for Windows, but that was in 1994 and it was still fairly feature-light then!) but I’ve been pretty impressed at its ability to create a bibliography for me.

Word lets me choose from a variety of bibliography styles but I have chosen ISO 690 (Numerical Reference). The only problem with this is that it uses normal round parentheses () rather than square parentheses [] which can be confusing when a sentence contains both text in parentheses (brackets) and a citation (1).

Custom Word 2007 bibliography styleA bit of googling turns up various solutions involving editing XSLT stylesheets but that all seems a bit of a pain. Then I found that “Yves” on CodePlex has already done the work and released ISO690NmericalSquare.XSL.  After downloading this to %ProgramFiles%\Microsoft Office\Office12\Bibliography\Style and restarting Word (2007 in my case – there’s anecdotal evidence to suggest it would work for Office14/2010 too), I have a new option in the bibliography style dropdown and my citations are all labelled with square parentheses.