{"id":2379,"date":"2011-03-14T09:21:38","date_gmt":"2011-03-14T09:21:38","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=2379"},"modified":"2011-03-14T09:21:38","modified_gmt":"2011-03-14T09:21:38","slug":"why-paper-li-is-just-plain-wrong","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm","title":{"rendered":"Why paper.li is just plain wrong"},"content":{"rendered":"

When I first saw paper.li<\/a>last year, I thought it was an interesting concept. Kind of like the Flipboard app on my iPad, although nowhere near as attractive, but universally available, picking the most popular updates from my Twitter and Facebook “friends” and presenting them to me in a newspaper format. I quickly grew tired of the format though along with the increasing number of tweets telling me that “The Daily<insert name of person><\/em>\u00c2\u00a0is out” – I can see the value for an individual but tweeting about it just seems a bit spammy. (Sorry if you’re one of the people that does this – if you think there is some real value, I’d be pleased to hear your view.)<\/p>\n

More worrying though is the way that paper.li seems to misrepresent my views and opinions when it “retweets” me…<\/p>\n

I work for a Japanese company and spent a lot of Friday and the weekend thinking of colleagues whose friends and family might be affected by the recent events in Japan. For that reason, I was appalled to see a ZD Net article last Friday questioning whether the iPad 2 would be hit by supply problems as a consequence.<\/p>\n

I can see why the writer\/publisher put this out (perhaps it is a legitimate concern for some) but really, in the big scheme of things, does a shortage of NAND memory matter that much, given the scale of the human disaster in Japan?\u00c2\u00a0 Any iPad 2 supply chain issues strike me as a “first world problem<\/a>” and,\u00c2\u00a0even though the earthquake\/tsunami did strike on iPad 2 launch day (presumably why this was newsworthy to ZD Net), couldn’t the publisher have held back, if only for reasons of taste and decency? I tweeted<\/a>:<\/p>\n

RT @ZDNet<\/a>: Will the earthquake in Japan ding Apple’s iPad 2 rollout? http:\/\/zd.net\/ibvmgp<\/a> ^MW FFS get a grip. Bigger issues at stake here!<\/p><\/blockquote>\n

(If you’re not familiar with the FFS acronym, don’t worry, I was just expressing my frustration.)<\/p>\n

I think that tweet is pretty clear, I’m RT (retweeting) ZD Net’s tweet about their article, with a comment – in the socially-acceptable manner for the Twitter community (the “new-style” RT built into Twitter misses the ability\/potential added value of a comment).<\/p>\n

Unfortunately, when I saw paper.li’s version, it was completely out of context:<\/p>\n

\"Paper.li<\/p>\n

It simply grabs the title and first few lines from the link and credits the person who retweeted it (me)\u00c2\u00a0as the source. Not only does this appear to be crediting me as the author of the article, which I would be uncomfortable with, even if I did approve of the content but, in this case, I\u00c2\u00a0fundamentally disagree with the article and would certainly not want to be associated with it.\u00c2\u00a0<\/p>\n

Paper.li does include the ability to stop mentions<\/a>, but that misses the point\u00c2\u00a0– by all means mention my tweets but they should really make it clear who the original source of an article is and, where that’s not possible, include the whole tweet to ensure that it remains in context.<\/p>\n

And it seems I’m not the only one to see issues with the way in which Paper.li uses the Twitter API, disregarding the social<\/em> networking element of Twitter<\/a>. Then there’s the fact that some people thank others for mentioning them in their paper.li edition<\/a> (which, of course, was entirely automated).<\/p>\n

Indeed, I’d go as far as to say that the way paper.li handles retweets is sloppy and demonstrates a lack of knowledge\/understanding on how platforms like Twitter really work – they are (or should be) about conversation, not broadcast – and that’s why the newspaper format is really\u00c2\u00a0not a good fit.<\/p>\n","protected":false},"excerpt":{"rendered":"

When I first saw paper.lilast year, I thought it was an interesting concept. Kind of like the Flipboard app on my iPad, although nowhere near as attractive, but universally available, picking the most popular updates from my Twitter and Facebook “friends” and presenting them to me in a newspaper format. I quickly grew tired of … Continue reading Why paper.li is just plain wrong<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[38],"tags":[157],"class_list":["post-2379","post","type-post","status-publish","format-standard","hentry","category-inane-waffle","tag-social-networking"],"yoast_head":"\nWhy paper.li is just plain wrong - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why paper.li is just plain wrong - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"When I first saw paper.lilast year, I thought it was an interesting concept. Kind of like the Flipboard app on my iPad, although nowhere near as attractive, but universally available, picking the most popular updates from my Twitter and Facebook “friends” and presenting them to me in a newspaper format. I quickly grew tired of … Continue reading Why paper.li is just plain wrong\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2011-03-14T09:21:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Why paper.li is just plain wrong\",\"datePublished\":\"2011-03-14T09:21:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm\"},\"wordCount\":641,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/paper.li-ipad2.png\",\"keywords\":[\"Social Networking\"],\"articleSection\":[\"Waffle and randomness\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm\",\"name\":\"Why paper.li is just plain wrong - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/paper.li-ipad2.png\",\"datePublished\":\"2011-03-14T09:21:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/paper.li-ipad2.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/paper.li-ipad2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2011\\\/03\\\/why-paper-li-is-just-plain-wrong.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why paper.li is just plain wrong\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output > \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why paper.li is just plain wrong - markwilson.it","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm","og_locale":"en_GB","og_type":"article","og_title":"Why paper.li is just plain wrong - markwilson.it","og_description":"When I first saw paper.lilast year, I thought it was an interesting concept. Kind of like the Flipboard app on my iPad, although nowhere near as attractive, but universally available, picking the most popular updates from my Twitter and Facebook “friends” and presenting them to me in a newspaper format. I quickly grew tired of … Continue reading Why paper.li is just plain wrong","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm","og_site_name":"markwilson.it","article_published_time":"2011-03-14T09:21:38+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Why paper.li is just plain wrong","datePublished":"2011-03-14T09:21:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm"},"wordCount":641,"commentCount":2,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png","keywords":["Social Networking"],"articleSection":["Waffle and randomness"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm","name":"Why paper.li is just plain wrong - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png","datePublished":"2011-03-14T09:21:38+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/paper.li-ipad2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2011\/03\/why-paper-li-is-just-plain-wrong.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Why paper.li is just plain wrong"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output > \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1955,"url":"https:\/\/www.markwilson.co.uk\/blog\/2010\/08\/useful-links-august-2010.htm","url_meta":{"origin":2379,"position":0},"title":"Useful Links: August 2010","author":"Mark Wilson","date":"Tuesday 31 August 2010","format":false,"excerpt":"A list of items I've come across recently that I found potentially useful, interesting, or just plain funny: How to use Facebook Chat with Apple iChat - Henry Hernandez describes how to connect Apple's iChat client (or any other Jabber client) to Facebook How to create iPad formatted videos using\u2026","rel":"","context":"In \"Useful Websites\"","block_context":{"text":"Useful Websites","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/useful-websites"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4137,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/07\/why-brands-need-to-think-about-social-media-monitoring-and-analytics.htm","url_meta":{"origin":2379,"position":1},"title":"Why brands need social media monitoring and analytics","author":"Mark Wilson","date":"Wednesday 4 July 2012","format":false,"excerpt":"Last week, I was asked to give a short (10 minute) talk about social media monitoring and analytics. I'm not exactly what you might call an expert in this field, but I have been around the loop with this as part of some work I did a couple of years\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"http:\/\/www.assoc-amazon.co.uk\/e\/ir?t=marsweblo-21&l=as2&o=2&a=B0057Z7H40","width":350,"height":200},"classes":[]},{"id":8502,"url":"https:\/\/www.markwilson.co.uk\/blog\/2023\/01\/formatting-cells-in-excel-if-they-match-a-value-in-another-column.htm","url_meta":{"origin":2379,"position":2},"title":"Formatting cells in Excel if they match a value in another column","author":"Mark Wilson","date":"Thursday 12 January 2023","format":false,"excerpt":"A few months ago, I wrote about using Excel to sort a table of names that had been created in Word. And last year, I mentioned a dynamic report I'd created with a colleague, stringing together a few formulae, some data validation and some conditionally formatted cells. Well, today, that\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/Screenshot-2023-01-12-175952.png?fit=771%2C553&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1508,"url":"https:\/\/www.markwilson.co.uk\/blog\/2009\/08\/backing-up-my-tweets.htm","url_meta":{"origin":2379,"position":3},"title":"Backing up my tweets","author":"Mark Wilson","date":"Friday 21 August 2009","format":false,"excerpt":"Over the last month or so, I have gone Twitter crazy. I've been transformed from someone who didn't \"get it\" into someone who uses Twitter as his main source of news... leaving behind a big pile of unread RSS feeds from blogs (which is exactly why this blog integrates with\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6942,"url":"https:\/\/www.markwilson.co.uk\/blog\/2017\/02\/social-media-journey.htm","url_meta":{"origin":2379,"position":4},"title":"My social media journey","author":"Mark Wilson","date":"Wednesday 15 February 2017","format":false,"excerpt":"Last week, I spent some time with the risual Marketing team recording a short interview on \"my social media journey\". The idea was that\u00a0I have an established blog and I'm prolific on Twitter - what could colleagues pick up from my experience that might help them? Then\u00a0the team\u00a0decided to put\u2026","rel":"","context":"In "Waffle and randomness"","block_context":{"text":"Waffle and randomness","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/inane-waffle"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/dFonTCm11EA\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":4403,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/09\/social-media-plunge.htm","url_meta":{"origin":2379,"position":5},"title":"Social Media: Taking the Plunge","author":"Nikki Wilson","date":"Wednesday 26 September 2012","format":false,"excerpt":"January 2012 new year\u2019s resolution: to join the 21st century! With two young children, the past few years have flown by in a time-starved, sleep-deprived haze. Juggling motherhood with work has left little time or head-space for anything new. I\u2019m firmly stuck in the age of email. If I want\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/guest-post.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=2379"}],"version-history":[{"count":1,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2379\/revisions"}],"predecessor-version":[{"id":2380,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/2379\/revisions\/2380"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=2379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=2379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=2379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}