<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Rob Hammond on Medium]]></title>
        <description><![CDATA[Stories by Rob Hammond on Medium]]></description>
        <link>https://medium.com/@robhammond?source=rss-2e6430ef57d0------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*XXZIszCRAE1dOM1zjNf26w.jpeg</url>
            <title>Stories by Rob Hammond on Medium</title>
            <link>https://medium.com/@robhammond?source=rss-2e6430ef57d0------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 08:51:51 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@robhammond/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[EV Road Trip Report — Andalusia, Spain]]></title>
            <link>https://medium.com/@robhammond/ev-road-trip-report-andalusia-spain-e589f566a3b4?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/e589f566a3b4</guid>
            <category><![CDATA[electric-vehicles]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 01 Nov 2024 10:41:20 GMT</pubDate>
            <atom:updated>2024-11-01T10:41:20.028Z</atom:updated>
            <content:encoded><![CDATA[<h3>EV Road Trip Report — Andalusia, Spain</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XRxpf3SdyOOUYnX9skImVg.jpeg" /><figcaption>Mustang Mach-e, El Jaral, Spain</figcaption></figure><p>For our summer holiday this year my family decided to take a road trip through Spain down to Andalusia. Originally we planned to drive from the UK but due to time constraints we ended up flying to Madrid.</p><h4>TLDR;</h4><p>We drove 2,769km across central and South East Spain this summer. The experience of the road trip itself was fine, being armed with several RFID cards and a decent amount of experience of EV road tripping.</p><p>Charging in more rural places across a 2 week villa stay was more challenging, due to sparsely distributed rapid chargers. There were plenty of 7kw and below charging points, but they were often ICE’d or out of service.</p><p>In terms of cost, the rental itself was £680 for 3 weeks, and we spent roughly £185 on charging, working out at 11p/mile.</p><h4>Background</h4><p>We rented a Ford Mustang Mach-e well in advance through Europcar. I was considering buying one this year to replace our e-Niro, so it seemed a perfect opportunity to get an extended test drive.</p><p>As ever, the EV rental pickup experience was not great. At the rental desk they were surprised we wanted an EV, and tried to upgrade us to a hybrid Audi. It’s just as well we were experienced as we weren’t given any information about charging.</p><p>Our rental car had fairly low mileage, but was covered in large dents and scratches. I hadn’t driven a Mach-e before but I quickly found out the reason for the dents — the last driver had left it on “Untamed” mode, which gives an insane amount of instant torque, certainly too much for new drivers to the car, let alone new drivers to EVs.</p><p>I had to dive through a bunch of touchscreen menus to change the drive mode to Normal, so I suspect other renters hadn’t even known it was possible to tone down the accelerator pedal.</p><h4>Route</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*2dIAwoEhUOtb1XzSEyKTnw.png" /><figcaption>Overview of stops on our trip</figcaption></figure><p>Our plan was to drive from Madrid down to near Zahara de la Sierra in Andalusia, stay there for 2 weeks, and then drive back via Valencia.</p><h4>Madrid — Consuegra (136km)</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6DbgiF7eRM-ER58QmecIMw.jpeg" /><figcaption>At Don Quixote’s windmills in Consuegra</figcaption></figure><p>Our first leg was easy; we left the <a href="https://all.accor.com/hotel/1636/index.en.shtml">Novotel Madrid Campo de las Naciones</a> with 100% charge after charging overnight in their underground car park, meaning we didn’t have to stop en route to Consuegra.</p><p>This cost €15 for the parking, and we had to ask at the reception for an adapter we needed to plug in the (type 1) charger, which required a €10 deposit.</p><h4>Consuegra — Cordoba (270km)</h4><p>From the literal desert and figurative charging desert of Consuegra we drove down to Cordoba. We left Consuegra with probably about 60% charge — I don’t know the exact model of Mach-e we had but its full range was reported as around 330km.</p><p>I tried to avoid using Tesla chargers wherever possible (because, well, Elon Musk), so my planned charging stop was a <a href="https://maps.app.goo.gl/GCHFV6DaLXjR3q4r7">Wenea 100kw charger</a> at <a href="https://www.hotellaperdiz.es/EN/home.html">Hotel La Perdiz</a>. This did not go well as neither charger engaged with the car —I got a flashing red light of doom from the car and this seemed to become a pattern with the Mach-e.</p><p>My backup plan was to use the nearest Tesla charger, so I hastily punched that into <a href="https://abetterrouteplanner.com/">ABRP</a>.</p><p>Or I thought I did – it turned out we sped past it and on to a rather bizarre IONITY location on an <a href="https://maps.app.goo.gl/jDPaBWR57pHsi6w17">industrial estate just outside Jaén</a>. It delivered 25kwh in 15 mins and then decided to stop working. I tried again a few times but the car disconnected each time.</p><p>But the charger had at least given us enough for our onward journey so we went on our way.</p><h4>Cordoba — El Jaral (203km)</h4><p>As hoped on arrival in Cordoba we were able to use the single EV charger in our hotel’s underground car park (<a href="https://www.maciahoteles.com/en/maciaalfaros/">Hotel Macià Alfaros</a>). So for €15 we were able to get around 80kwh overnight to 100% which was great.</p><p>The exit from the underground car park was less great, in that the S-bend you had to exit through really wasn’t built with a car the width or length of a Mach-e. After probably the most stressful and tightest driving situation I’ve ever been in, we got out without even a tiny scratch — thankful for the front-camera in the car. (Incidentally if you ever park here I recommend speaking to reception and exiting through the entrance!)</p><p>For the drive itself we didn’t need to charge, but given our final destination seemed to be a bit of a charging desert we wanted to get in a fast charge as close as possible. This took us to a <a href="https://maps.app.goo.gl/T4TN17VuvEdhCWzRA">Tesla supercharger</a> just outside Osuna — a huge, deserted motorway service station with more than a hint of Twin Peaks about it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DULtu3Efmwd0BixqJN-c_Q.jpeg" /><figcaption>Wonderful display in the restaurant by the Tesla Supercharger location outside Osuna</figcaption></figure><p>From there we went on to our destination via Ronda and grabbed some food and a free charge from <a href="https://maps.app.goo.gl/BqAP23jJvgUGjRKR8">Lidl</a>.</p><h4>El Jaral &amp; around</h4><p>Our villa was up in the mountains, luckily not down too many narrow winding roads, and had a stunning view across to Zahara de la Sierra.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*o4RIGZ2clZcuc6xlZIiEpg.jpeg" /><figcaption>Arrival at El Jaral</figcaption></figure><p>We got by on the residual charge and another shopping trip to Lidl for the first week.</p><p>Week two started with a road trip around the area, stopping at the <a href="https://maps.app.goo.gl/eAt86ZWQfudY5WHL8">Enel X Way charger in Grazalema</a> for 2 hours (21kWh charged through Kia Charge RFID card for €8).</p><p>The next day we did a 275km round trip to a beach just south of Cadiz. This was a rather frustrating experience as the Electroverse app directed us to an impressive-sounding charging hub with 24 chargers up to 188kw. When we arrived it quickly became clear that not a single charger existed at the location!</p><p>After a search we found a relatively close <a href="https://maps.app.goo.gl/uNsDh9YgX43n2jUt8">100kw Wenea charger</a> down a random residential road which worked great. This was the first time we went below 20% charge, and given how close we were to a big city it was surprising how few fast chargers there were.</p><p>Other than that in week two we found the lack of fast chargers (or even very many destination chargers) around where we were staying a bit frustrating. In Ronda we found that the chargers in <a href="https://maps.app.goo.gl/By9aNn8McUXjcdcF8">La Concepción car park</a> worked well with the Shell RFID card, but were well below the 9kw advertised. We had a hugely frustrating experience in another car park near there, wasting 30 minutes trying to get a charger to work in the blazing heat before being told by the attendant that none of them worked!</p><p>Thankfully our hosts at our villa allowed us to charge using a home AC plug, which the Mach-e had in its frunk. We used this a little during the second week just to get us by without having to drive anywhere specifically just to charge.</p><h4>El Jaral — Almeria (362km)</h4><p>By comparison with the rural mountains, the return journey was simple. On this leg we only needed one 45min stop at a Tesla Supercharger (58kWh) to get us to our destination.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/656/1*mwPOW_AByDgHYf355DRPFw.png" /></figure><p>We arrived at our hotel and found an available Enel X Way charger just outside, so we got a good 57kWh out of that overnight and were ready for our trip to Cartagena the next day with 100%.</p><h4>Almeria — Mar Menor (233km)</h4><p>After an uneventful drive from Almeria (no charging stops), we arrived at the somewhat post-apocalyptic landscape of Occidental Mar Menor. Clearly we hadn’t done our research on hotels for this stop, because Mar Menor is famously an <a href="https://earthjournalism.net/stories/mar-menor-the-lagoon-that-struggles-to-survive">ecological disaster zone</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Rzu0NvPtP_iLfFuCnvj8aA.jpeg" /><figcaption>Occidental Mar Menor hotel — a surreal, otherworldly experience</figcaption></figure><p>We parked on the street so didn’t take advantage of the EV chargers that were on offer in the Occidental’s underground car park.</p><h4>Mar Menor — Valencia (293km)</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/874/1*GXJryPH8EIVnpyEum-ov0A.png" /><figcaption>Nice trip up the coast with a charge stop next to a McDonald’s</figcaption></figure><p>Not charging overnight meant that we had to find a rapid charger en route to the next stop in Valencia. We found an <a href="https://maps.app.goo.gl/1Q4xWwRKiit8xgJp9">Ionity charger</a> a 30min drive from the hotel — this was easily the worst charging experience we had the whole trip.</p><p>There were a bank of six 350kw chargers, but each one we tried, repeatedly disconnected after a few minutes, with the car reporting a fault with the charger. Other drivers including a Kia EV6 and Tesla pulled up and charged seemingly without issue.</p><p>Another Mustang Mach-e driver pulled up and also had issues. She was entirely new to EVs — the Mustang was foisted upon her by a car rental company with no help offered on how to charge the car.</p><p>She was having the same issues as us, but didn’t have any RFID cards, so was getting hit by a €30 pre-authorization charge every time she reconnected the car.</p><p>She was on the phone to Ionity who just suggested swapping chargers, which also didn’t really work for her, they all failed.</p><p>I suggested she try creating an account on the Tesla app and going to the nearest supercharger, at least that way she’d get a fast, reliable charge without the heavy pre-authorization fees. The problem was there weren’t any very near at all, and she just wanted to top up the car while her young family waited in the holiday place they were staying in.</p><h4>Valencia — Aranjuez (348km)</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*l7zWrgNMCWSe7_N_bvKW4A.png" /></figure><p>We used the underground car park of the Primus Valencia hotel and got a full overnight charge from one of the 2 charging points there.</p><p>The next leg was a long drive, but unremarkable for the most part. The Tesla charging stop was fine.</p><h4>Aranjuez — Madrid (62km)</h4><p>We stayed at another Occidental, which was again rather run-down, and again we parked on the street overnight.</p><p>Arriving back at Europcar in the morning, we had roughly 18% charge left. Incidentally, the Mach-e has a very panicked noise and light show up when you hit around 20%, which happened to us twice over the trip.</p><p>Europcar did a good job on returning the car and did not try to get any extra fees by finding phantom scratches on the car.</p><h4>Summary</h4><p>Overall it was a great trip with probably a total of 2 hours of frustration over the 3 weeks at various out of service charging points.</p><p>There was definitely a bit of anxiety about getting a full charge when we were staying up in the mountains, due to a 90min drive to the nearest rapid chargers.</p><p>Otherwise it was an enjoyable road trip; it seems Andalusia’s charging infrastructure clearly has a lot to catch up with France and the UK, and even <a href="https://medium.com/@robhammond/hiring-an-electric-car-in-mallorca-222f87816548">my experience of Mallorca</a> in 2022.</p><p>As for the Mustang Mach-e, it was ok to drive, quite spacious inside and a good looking car, we got quite a few head turns in some of the more rural villages.</p><p>But to me it seemed a bit of a silly car — the fake engine sounds on acceleration and lack of decent EV-specific info when driving or charging the car were frustrating. It’s kind of an EV that seems a bit embarrassed or unsure whether to fully embrace the electric part of itself.</p><p>Also it seemed that the Mach-e was a lot more temperamental with charging than my experiences with other EVs. Several times we had issues with chargers that other cars did not, and meeting another Mach-e driver with the same issues as us only reinforced that impression.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e589f566a3b4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Solar in Sussex install —One month review]]></title>
            <link>https://medium.com/@robhammond/solar-in-sussex-install-one-month-review-a70f5a408ec6?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/a70f5a408ec6</guid>
            <category><![CDATA[solar-panels]]></category>
            <category><![CDATA[solar-energy]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 05 May 2023 16:36:59 GMT</pubDate>
            <atom:updated>2023-05-05T16:36:59.295Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*co1RfzpsrzCq8166EviHbA.jpeg" /></figure><p>It has been 1 month since I had 12 solar panels installed on my house in West Sussex. After receiving various quotes and generation projections from different installers, I decided to share my experience and discuss the returns I am seeing so far.</p><h4>Installation</h4><p>13 months ago, after the UK government removed VAT from solar installations, I signed up with E.on Solar for an installation of 12 solar panels on my south-facing roof. Using E.on was a bad choice though — I waited 11 months with no progress, and evenutally cancelled the order in March.</p><p>I then signed up with a local solar company, who set up the survey, and the panels &amp; battery were installed within a month.</p><p>The actual installation took about 5 hours. The scaffolding was put up the day before, and taken down a few days later, all very straightforward.</p><h4>System</h4><p>My solar system consists of:</p><ul><li>12x 390W JA Solar panels</li><li>Solis 6kWp inverter</li><li>Pylontech US5000 4.8kWh battery</li></ul><p>It’s still early days, but everything seems to be running smoothly.</p><p>The SolisCloud app is ok for monitoring the system, but you can’t change any settings for the inverter within the app. Also the monitoring data updates only every 5mins which is a little slow for a data geek!</p><h4>Performance</h4><p>In one month (5 April–4 May 2023), the 12 panels generated 482 kWh of power, resulting in £153 savings on my current <a href="https://share.octopus.energy/great-sea-220">Octopus Energy</a> tariff. Not too bad for one quite cloudy month.</p><p>The battery has been crucial in maximising utilization, storing and discharging 97.4 kWh of solar-only electricity. Coupled with the off-peak savings gained by topping it up overnight on Octopus Go, we’ve saved about £70 purely from having the battery on the system.</p><h4>Usage</h4><p>With 2 people working from home full time, 2 EVs, and an <a href="https://medium.com/@robhammond/retrofitting-an-air-source-heat-pump-2ed63ca15e9c">air source heat pump</a>, our electricity usage is high.</p><p>I don’t have a solar wall charger (like the <a href="https://www.myenergi.com/zappi-ev-charger/">Zappi</a>) for the cars, and I’m not sure it would be a worthwhile investment as it seems there would only be enough excess solar to make it worthwhile in summer. However I have topped up roughly 50 miles of fuel for the cars just through plugging in a granny cable on sunny days.</p><p>I opted out of installing an <a href="https://www.marlec.co.uk/product/solar-iboost/">iBoost+</a> to use excess solar to heat our water tank, as I thought it would take too long get the £500 back in savings.</p><p>Even with our high usage, on the best day so far (26kWh) we still exported 3.3kWh to the grid after topping up the car, heating the immersion tank and running the washing machine a few times.</p><h4>Return on Investment</h4><p>Using the <a href="https://github.com/robhammond/home-analytics">HomeAnalytics</a> project, I set up a Python script that pulls daily generation data from the Solis Cloud API, and uploads them to BigQuery so I can use Looker Studio to analyze how the system is performing.</p><p>As the screengrab shows below, the savings so far have been pretty decent despite inconsistent weather:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lLImVEh2zCRsCCX8rYJ9Zg.png" /></figure><h4>Next steps</h4><p>I’m already thinking about getting another battery — the Pylontech batteries are modular, so it’s easy to add capacity. Assuming savings of ~£50 p/m, a 4.8kWh battery would pay for itself in less than 3 years on today’s energy prices which is pretty decent.</p><p>Now that <a href="https://homeanalytics.org/">HomeAnalytics</a> is humming along nicely picking up the daily stats (and adding current solar generation to <a href="https://medium.com/@robhammond/building-a-diy-energy-monitor-with-a-raspberry-pi-a5ae40c1a2a6">my Pi display</a>), I’m thinking of building my own DIY iBoost+, to hit the ‘Heat now’ button on the Ecodan heat pump whenever there’s excess solar.</p><p>Do you have any tips for maximizing the benefits of a new solar installation? Let me know in the comments!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a70f5a408ec6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Expose your hidden EV data with homeAnalytics]]></title>
            <link>https://medium.com/@robhammond/expose-your-hidden-ev-data-with-homeanalytics-2e5ee3c78fb9?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/2e5ee3c78fb9</guid>
            <category><![CDATA[electric-car]]></category>
            <category><![CDATA[electric-vehicles]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Mon, 07 Nov 2022 18:35:29 GMT</pubDate>
            <atom:updated>2022-11-07T18:35:29.145Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0RiknCikObKvtGFdv8ZVWA.png" /><figcaption>Expose real-world EV performance and cost data with homeAnalytics</figcaption></figure><p>Since going 100% EV last year, as a bit of a data geek I’ve loved the increased visibility of a car’s efficiency and performance you get as part of the package.</p><p>I’m lucky enough to have 2 EVs on my drive — a Kia e-Niro and a Renault Zoe. They both offer access to a basic smartphone app where you can check your battery’s state of charge (SoC), estimated range, and odometer.</p><p>None of that data is exportable though, and although Kia Connect offers a calendar screen logging your trips and recorded efficiency, the data disappears after 90 days, and the data can be a bit patchy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Bvp83ooeiIc9F0RYM8UXNA.png" /><figcaption>Kia Connect data (left &amp; middle) and My Renault data (right) — mildly interesting but ephemeral and not exportable</figcaption></figure><p>When I built <a href="https://homeanalytics.org/">homeAnalytics</a>, a bonus of collecting the SoC and range info for the <a href="https://homeanalytics.org/pi">In-Home Display</a> was that I could store this information, and plot my own efficiency and journey graphs with it.</p><p>With other info about the car such as the purchase date and mileage, I can see at a glance my average and total mileage since I bought the car. This data is mildly interesting on its own, but can also be useful for calculating total cost of ownership, insurance requirements, budgeting, etc.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*meC4fZ90aPWkXvqH_enVvw.png" /><figcaption>EV profile of a Renault Zoe in homeAnalytics</figcaption></figure><h4>EV Charging Costs</h4><p>With the addition of data from my Pod Point home charger, I can also see exactly how much money I’ve spent and energy I’ve used each month.</p><p>This helped me see the impact of switching to <a href="https://octopus.energy/go/">Octopus Go</a> tariff in July this year, which to-date in 4 months has saved me £184 in charging costs (vs my previous flat tariff with Ecotricity):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jusC1PNLtZgHPFxfFgJTxQ.png" /><figcaption>Monthly EV charging cost and usage data</figcaption></figure><h4>Data affecting change</h4><p>In my 22 years driving ICE and hybrid cars, I never really understood or paid too much attention to the cost of each journey I took. The data was (intentionally?) too opaque.</p><p>I remember tortuous times using budgeting apps, trying to classify bank transactions at petrol stations as fuel costs — which was never easy, and all the more difficult when you had filled up at a supermarket or anywhere without ‘fuel’ in the transaction name.</p><p>Now, armed with the data available to me I can not only budget better each month, but I can also easily guess how much each trip is going to cost — and implicitly question the cost/benefit of each trip.</p><p>Democratising the data that car manufacturers collect could over time cut down on unnecessary trips. Clearly as highlighted at COP27, we have some very serious challenges to face in reducing our emissions from transport and elsewhere; hopefully small steps like better ownership of the data we generate every day can help in some way.</p><h4><strong>Further developments</strong></h4><p>I hope to incorporate more data into the dashboards over time, including local weather data in order to estimate the impact of temperature on real-world EV efficiency.</p><p>Any other ideas are gratefully received at the <a href="https://github.com/electric-sheep-energy/home-analytics">Github project</a> :)</p><p><a href="https://homeanalytics.org/">Open Source Energy Monitor - homeAnalytics</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2e5ee3c78fb9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Building a DIY Energy Monitor with a Raspberry Pi]]></title>
            <link>https://medium.com/@robhammond/building-a-diy-energy-monitor-with-a-raspberry-pi-a5ae40c1a2a6?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/a5ae40c1a2a6</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[energy-efficiency]]></category>
            <category><![CDATA[electricity]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Thu, 22 Sep 2022 12:18:13 GMT</pubDate>
            <atom:updated>2022-11-03T09:47:00.536Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DwtidyQuB1y_eJZEyhlb5g.jpeg" /><figcaption>Incorrect data from our IHD (left) vs DIY homeAnalytics data (right)</figcaption></figure><p><a href="https://medium.com/electric-sheep-energy/how-to-build-your-own-diy-energy-monitor-a3769abed397"><em>Read instructions on how to set up your own energy monitor here</em></a></p><h4>Background</h4><p>Until January this year, electricity costs haven’t really been something I’ve paid much attention to.</p><p>However after <a href="https://medium.com/electric-sheep-energy/retrofitting-an-air-source-heat-pump-2ed63ca15e9c">installing a heat pump</a> last year, and switching to an <a href="https://medium.com/electric-sheep-energy/ev-road-trip-2022-sussex-to-the-dordogne-d937e4887a15">EV for our main family car</a> in December 2021, the monthly bill for January hit over £500, which was a bit of a shock.</p><p>Receiving the bill, one other thing that hit me was just how opaque electricity bills still are in 2022.</p><p>The detail I got from Ecotricity was woeful — the raw number of kWh used, the cost, and a crude year-on-year comparison (useless as I hadn’t been with them 12 months):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1H7MosWU0Kv3OC2CX14XIA.png" /><figcaption>Ecotricity bill detail leaves a lot to be desired</figcaption></figure><p>I wanted a better way to break this down and see what was driving the increased costs.</p><h4>Existing Smart Meter Device</h4><p>Our ‘smart’ meter device was supplied a few years ago, and shows real-time information on kWh consumed. But that’s about it —the device itself (a <a href="https://chameleontechnology.co.uk/solutions/smart-in-home-displays/">Chameleon IHD7</a>) stinks — the tariff data doesn’t update if you switch suppliers (and there’s no over-ride option), doesn’t support peak/off-peak tariffs, has a horrible resistive touch screen and poor visuals.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MsJYk9j-8ZN5bQ6ub75jOg.jpeg" /><figcaption>A Chameleon IHD7 — a device straight out of the 1990s</figcaption></figure><h4>Making a better Energy Monitor</h4><p>Finding a data source for our electricity consumption was a long slog — Ecotricity have no API, but after a <em>lot</em> of Googling I found the <a href="https://loop.homes/loop-smart-meter-app/">Loop Energy app</a>, which gave me access to almost a year’s worth of half-hourly usage data.</p><p>Loop had a couple of key issues though — they didn’t support custom tariff data, so their cost information was wrong, and they don’t offer an API, so getting that information programmatically was a problem.</p><p>I kept searching and eventually I found that every smart meter sends its data to an obscure data processing company called <a href="http://www.n3rgy.com/">n3rgy</a>. This is where Loop get their data from, and n3rgy offer a free (largely undocumented) API, with half-hourly usage data going back 90 days. It’s not real-time but does offer data with only a few hours lag.</p><h4>Breaking down usage data</h4><p>The next step was splitting out the consumption into different categories.</p><p>We have a reasonable amount of smart devices in our house, but no way to pull all the data together, so I investigated a bunch of options such as <a href="https://www.home-assistant.io/">HomeAssistant</a> and <a href="https://homebridge.io/">HomeBridge</a>, which are great, but didn’t offer the analytical approach I was after.</p><p>After playing around with <a href="https://mitmproxy.org/">MITMProxy</a> and some Python packages though, I managed to get enough incoming data from other sources to make the idea of building something bespoke worthwhile.</p><h4>Building the homeAnalytics Energy Monitor</h4><p>With this in mind I started putting together a rough idea of a website for my local network that I could run on a Raspberry Pi and check in on occasionally.</p><p>Once I had a basic project up &amp; running, it occurred to me I could probably build an In-Home Display (IHD) better than the Chameleon smart meter if I put a display directly on the Pi . I found a decent capacitive touch display <a href="https://thepihut.com/products/5-dsi-capacitive-touch-display-for-raspberry-pi-800x480">for £40 at The Pi Hut</a>.</p><p>After a good deal more hacking away, I now have an IHD that not only gives me an overview of my energy usage, but also shows a split of where that energy is going:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UPaNqYajUdm6Nk1mpDOGvQ.jpeg" /><figcaption>Breakdown of where energy is going shown on the home-brewed IHD (right)</figcaption></figure><p>Now the basics were in place I started exploring other useful smart home info it would be cool to see in my DIY IHD.</p><p>One thing I like about EVs is the ability to check if I have enough fuel to get me to a destination without opening up the car. But opening up an app is a pain, so an IHD is a perfect place to passively monitor state of charge.</p><p>This is especially useful now I’m on a <a href="https://share.octopus.energy/great-sea-220">variable rate tariff with Octopus Energy</a>, so I can reduce the amount I have to charge on the peak rate.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NGGq_QVTp3xbe7MPZ6eiUA.jpeg" /><figcaption>At-a-glance state of charge info for EVs in homeAnalytics</figcaption></figure><h4>Conclusion</h4><p>The software behind the Pi display is <a href="https://homeanalytics.org/">homeAnalytics</a>, and can be used entirely free of charge. It offers not just the Pi display, but also a Google Analytics-style web interface where you can do deeper analysis of your energy usage:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/664/1*2xRCPYv1bpGyOGwjoFgLHQ.png" /><figcaption>homeAnalytics web UI</figcaption></figure><p>I’ve hacked together a lot of stuff over the years, but building for a small, always-on, fixed-size screen was a new experience — there were some different rules to play by:</p><ol><li>Use black as the background colour — initially using white caused a good degree of glare in the evening coming from the cubby hole where the Pi is kept</li><li>Information density must be <strong>very</strong> low — every time I wanted to add in a new metric, I ended up either cutting it down or removing it entirely</li><li>Perfecting the layout can turn into a frustrating battle with available pixels vs CSS rules, but at least responsive layouts aren’t a concern</li><li>Useful/interesting information needs to have a reasonable freshness — ie data that is only updated on a monthly basis becomes stale and uninteresting quickly</li></ol><p>There are many more interesting things that can be done with the data being collected by the homeAnalytics project, and hopefully it can be part of a push to democratise energy usage data, increase energy efficiency and bring home energy reporting into the 21st century.</p><p>Now, build your own In-Home Display / Energy monitor:</p><p><a href="https://medium.com/electric-sheep-energy/how-to-build-your-own-diy-energy-monitor-a3769abed397">How to build your own DIY Energy Monitor</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a5ae40c1a2a6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[EV Road Trip 2022: Sussex to the Dordogne]]></title>
            <link>https://medium.com/@robhammond/ev-road-trip-2022-sussex-to-the-dordogne-d937e4887a15?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/d937e4887a15</guid>
            <category><![CDATA[roadtrip]]></category>
            <category><![CDATA[electric-vehicles]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 02 Sep 2022 12:53:54 GMT</pubDate>
            <atom:updated>2022-09-02T12:53:54.851Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*n0Yo-igLALUapNhfj-L5bQ.png" /><figcaption>The full 660+ mile route (split over 2 days)</figcaption></figure><p>This summer our family of 4 took our longest EV road trip to date from West Sussex down to the Dordogne in France (via the Eurotunnel).</p><p>We drove a Kia E-Niro 4+ (MY2021) with a 470L roof box attached.</p><h3>Trip Summary</h3><p>Overall the trip went very well, with only a few minor hiccups along the way. After some <a href="#Preparation">preparation</a>, the trip was smooth and far more enjoyable than our last road trip to France 4 years ago in our hybrid Toyota Auris.</p><p>99% of the issues we encountered were due to human behaviour rather than charging infrastructure — there were more than enough charge points in each destination, however <em>far</em> too many drivers were waiting for their EVs to reach 100% charge, blissfully ignoring the long queue behind them 🤬.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EBJ30Cywcvw5pWxtaoPK_A.jpeg" /><figcaption>A clear indication in a Niro (at an empty charging station mind you), that waiting for that extra 10–20% is a waste of time and money</figcaption></figure><p>The only faulty charge points we encountered were at Eurotunnel (both sides).</p><h3>Trip Details</h3><h4>Efficiency</h4><p>With the roof box we had to charge more often than we were used to, but got a solid efficiency of around 3.45 miles/kWh, which amounts to a range of around 220 miles in the Niro.</p><p>We were probably over-cautious with charging, as the lowest state of charge we reached was 30% (~84 miles), so next time I would probably push a bit further on that, in particular to increase the distance from the channel crossing before charging.</p><p>We took off the roof box when we arrived at our gite, which improved efficiency, though we didn’t drive a lot outside of the main journey, so the average efficiency wasn’t very different.</p><h4>Driving Experience</h4><p>Driving on the long highways in France was a smooth, easy experience, especially with the E-Niro’s adaptive cruise control doing most of the work.</p><p>We had a slight issue at the Eurotunnel (both ends) where the E-Niro’s multimedia system got confused and froze (outwards) and reset itself (return). Weird issue and has never happened before, but we had to reset it manually on the way out which was a bit annoying, must be something to do with crossing a border. I blame Brexit.</p><h4>Charging — Outward Journey</h4><p>Our outward journey was split into 2 legs — Sussex to Orléans, and Orléans to Dordogne.</p><p><strong><em>Stop 1 — Eurotunnel Folkestone</em></strong><br>Our first attempt at charging was at the UK side of the Eurotunnel as we had an hour to kill there. There are a few non-Tesla charge points there that are free, but one was occupied and the others were in very poor condition and didn’t work.</p><p>The Tesla Supercharger station was open to non-Teslas, but the cable was too short to reach without taking up 2 spaces and it was busy, so we decided to skip this one.</p><p><strong><em>Stop 2 — </em></strong><a href="https://fr.chargemap.com/ionity-a16-aire-de-la-baie-de-somme.html"><strong><em>Ionity, Aire de la Baie de Somme</em></strong></a><br>This was our first charging stop in France and it was a bad experience — around an hour’s wait in sweltering heat, mainly due to drivers waiting for a 100% charge. As you can see in the picture below, the Tesla superchargers opposite were all but empty most of the time, a frustrating experience, but at least everyone in the queue was patient and friendly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vhkkLMCbTA2vHKcjcIEBsQ.jpeg" /><figcaption>Long wait at Aire Baie de la Somme, largely due to some drivers waiting for a 100% charge</figcaption></figure><p>This station seemed to be a mix of drivers charging straight off the Eurotunnel and those heading back to the UK — clearly a busy bottleneck and the one area where infrastructure (or a charge per minute/overstay tariff) was truly lacking.</p><p><strong><em>Stop 3 — </em></strong><a href="https://www.google.com/maps/place/TotalEnergies+Charging+Station/@49.402916,2.128131,17z/data=!3m1!4b1!4m5!3m4!1s0x47e70099e8287e8d:0x1e18dd5cc888a9d0!8m2!3d49.4028808!4d2.1280989?hl=en-GB"><strong><em>TotalEnergies, Allonne</em></strong></a><br>Another slight disaster, due to one very inconsiderate VW ID3 driver who couldn’t figure out how to charge his car, and sat in a charging spot for 1.5 hrs, ignoring anyone who tried to help him (including an another ID3 driver who was desperate to get to his Eurotunnel on time).</p><p>As there were only 2 charge points, this meant we had to wait for another hour for the 2 cars ahead of us in the queue to charge.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1Z3sxitfkae2NcjqMvBrkg.jpeg" /><figcaption>Waiting at TotalEnergies Allonne, 2x 175kW chargers, 1x charge space hog</figcaption></figure><p><strong><em>Stop 4 — Novotel Orléans</em></strong><br>The first AC charge points on the journey, there were 2 charging posts, and 4 sockets. Both posts were occupied when we arrived, and it seemed that the post could only charge 1 car at a time; although the staff at reception had no clue when we asked.</p><p>However in the morning they were available, and we managed to get 24kWh in before checking out.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yPQS0FGaLZcg1zspB8os9g.jpeg" /><figcaption>Charging at Novotel Orléans</figcaption></figure><p><strong>Stop 5 —<em>Tesla Supercharger, Bloise<br></em></strong>Empty on arrival — relatively easy to set up (although the Tesla app had forgotten my payment details).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8c_IumYf6FHDsmhvW8wlCg.jpeg" /><figcaption>First Tesla Supercharger experience</figcaption></figure><p><strong><em>Stop 6 — </em></strong><a href="https://www.google.com/maps/place/Electric+Vehicle+Charging+Station/@46.7014579,0.3667592,17z/data=!3m1!4b1!4m5!3m4!1s0x47fda3059e6c2601:0xf46f7981d0ae0889!8m2!3d46.7014579!4d0.3667592?authuser=0&amp;hl=en"><strong><em>Ionity, Poitiers</em></strong></a><strong><em><br></em></strong>An uneventful top-up at a service station with a big shop and cafe on-site.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-FztBMZfcFZY5WjX6fAHwQ.jpeg" /><figcaption>Took the last available space at Ionity Poitiers to grab a coffee</figcaption></figure><p><strong><em>Stop 7 — </em></strong><a href="https://www.google.com/maps/place/Tesla+Supercharger/@45.69444,0.178841,17z/data=!3m1!4b1!4m5!3m4!1s0x47fe31aea1442a55:0x3f07bf0015ccacdf!8m2!3d45.69444!4d0.178841?hl=en-GB"><strong><em>Tesla Supercharger, Champniers</em></strong></a><br>Just outside Angoulême, this was our final charge stop before arriving. No problems, a rather random but quiet location behind a hotel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vNjI2_C7FlQtHBRThrG_oA.jpeg" /><figcaption>Surprise Supercharger station hidden in an Ibis hotel car park</figcaption></figure><h4>Charging — During the holiday</h4><p>Getting around was no problem once we arrived — most towns we visited had a car park with 2 <a href="https://www.mobive.fr/">Mobive</a> (previously known as Izivia) AC chargers that always worked well with our RFID cards.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*50zw3mPsrHCiNtXZQwSmhg.jpeg" /><figcaption>Lidl, Mobive and Total charging during our stay</figcaption></figure><p>The Lidl chargers weren’t free, and the instructions on the charge post led me to try to enable charging via a website, which took a €30 deposit, but didn’t work properly. After switching to another charge point and using our Kia Charge RFID card we got it working though.</p><p>One slight issue we did have was on a day trip to Bordeaux (~1hr drive away) — there don’t seem to be many out of town car parks with chargers, and we couldn’t see anything at the Park &amp; Ride we went to. When we arrived we noticed there were actually 10x chargers immediately at the entrance, however they were all Schuko 2 pin plugs for which we didn’t have an adapter. This was the one time we used a DC charger in the stay, another TotalEnergies charger just outside Bordeaux, which was fine.</p><h4>Charging — Return journey</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Igl0Ch2KM3s1ibRdWCIsCw.jpeg" /><figcaption>368 mile drive to Rouen on first leg, quick drive up to Calais on day 2</figcaption></figure><p>After 2 weeks we pretty much knew what to expect; we topped up to around 80% from Lidl the day before we set off.</p><p>The petrol station at <a href="https://www.google.com/maps/place/IONITY+Charging+Station/@46.7018085,0.316985,12z/data=!4m12!1m6!3m5!1s0x47fda3a9418cd5fd:0xac802cdba64e6ece!2sIONITY+Charging+Station!8m2!3d46.7018085!4d0.371054!3m4!1s0x47fda3a9418cd5fd:0xac802cdba64e6ece!8m2!3d46.7018085!4d0.371054?authuser=0&amp;hl=en">Jaunay-Marigny</a> was mayhem, and several EV charge points were ICE’d (the only time this happened in the whole 2 weeks). But we grabbed a space no problem and charged whilst we had lunch, pitying all those queueing for petrol.</p><p>Following that we stopped at Aire de la Dentelle (<a href="https://www.google.com/maps/place/TotalEnergies/@48.4571598,0.1265974,17z/data=!3m1!4b1!4m5!3m4!1s0x47e20c3c362e4477:0x3357af7ce234f2e3!8m2!3d48.4571536!4d0.1266031?authuser=0&amp;hl=en">TotalEnergies Valframbert</a>), which was fine, although the chargers were pretty hidden round the back of the car park.</p><p>The one downside was we booked <a href="https://all.accor.com/hotel/6342/index.en.shtml">Novotel Rouen</a> specifically as it had a car park and advertised EV chargers. So we paid €12 for parking on arrival, only to be told the charge points required a 2 pin plug, so no juice for us overnight.</p><p>This meant I had to make a trip specifically for charging (for only the second time) — around the corner there was a <a href="https://www.google.com/maps/place//data=!4m2!3m1!1s0x47e0dde48ac1efdb:0xa22b43d8aaf9117b?authuser=0&amp;hl=en&amp;gl=us">Freshmile station with 2x rapid charge points</a> at an Audi showroom.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OsHszdrGRgcI4oJVetZ0BA.jpeg" /><figcaption>Freshmile charge station on Rue de Constantine, Rouen</figcaption></figure><p>On the second leg, we used (with much trepidation) Ionity Baie de Somme. Again the Ionity points were full (and Tesla all but empty), and 4 of the 5 cars had over 90% state of charge. Grr.</p><p>We were at least the first in the queue, and after about 10mins a Jaguar iPace left and we grabbed a spot.</p><p>Our final charge was at Eurotunnel Calais — there were several <a href="https://www.engie.co.uk/business">Engie</a> chargers available despite the peak time crossing. The first 2 chargers we tried didn’t work, but the 3rd did, and we hit 80% just as we were called for boarding.</p><h3>Preparation</h3><p>As this was our first trip to France for 4 years, so I wanted to ensure things went as smoothly as possible. A few key things we did:</p><ul><li><strong>Legal requirements:</strong> Ordered UK <a href="https://www.amazon.co.uk/gp/product/B098PDSFFP/ref=ppx_yo_dt_b_asin_title_o03_s00?ie=UTF8&amp;psc=1">numberplate stickers</a>, warning triangle, family pack of yellow jackets</li><li><a href="https://www.certificat-air.gouv.fr/"><strong>Crit-air sticker</strong></a> — this takes a while to arrive so order well in advance. Only really needed for cities though.</li><li><strong>Route planning:</strong> a subscription to <a href="https://abetterrouteplanner.com/">ABRP</a> for route planning. This was quite useful but the CarPlay experience is very poor and would probably just use the free version next time.</li><li><strong>RFID cards:</strong> Ordered cards for <a href="https://electroverse.octopus.energy/">Octopus Electric Universe</a>, <a href="https://kiacharge.com/web/en/kia-gb">Kia Charge</a>, <a href="https://www.shell.co.uk/motorist/ev-charging.html">Shell Recharge</a>, and <a href="https://www.chargepoint.com/en-gb/support/activate">Chargepoint</a>. I considered a Chargemap card too, but the €20 cost put me off and I didn’t miss it.</li><li><strong>Road tolls: </strong>Ordered an <a href="https://www.emovis-tag.co.uk/">Emovis tag</a> for convenient road toll payment — this was great and saved delay and queueing at road toll booths. You also get a discount if you book through Eurotunnel.</li></ul><h3>Trip Stats</h3><ul><li><strong>Miles driven: </strong>1,655</li><li><strong>kWh consumed:</strong> 478.16</li><li><strong>Avg miles/kWh:</strong> 3.46</li><li><strong>Avg cost per mile:</strong> £0.12</li><li><strong>Total charging cost:</strong> £199.70 (£197.40 public charging)</li><li><strong>Estimated equivalent petrol cost:</strong> £313.85 (Assuming 35mpg at 146ppl, the average cost in France for this period *<a href="https://www.globalpetrolprices.com/France/gasoline_prices/">source</a>)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*3PqXcsKNdB2qBBmK-MShGA.png" /><figcaption>Breakdown of energy sources for the trip</figcaption></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d937e4887a15" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Retrofitting an Air Source Heat Pump]]></title>
            <link>https://medium.com/@robhammond/retrofitting-an-air-source-heat-pump-2ed63ca15e9c?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/2ed63ca15e9c</guid>
            <category><![CDATA[air-source-heat-pumps]]></category>
            <category><![CDATA[renewable-energy]]></category>
            <category><![CDATA[central-heating]]></category>
            <category><![CDATA[environmental-issues]]></category>
            <category><![CDATA[heating-systems]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Wed, 18 May 2022 08:03:01 GMT</pubDate>
            <atom:updated>2022-05-18T16:59:31.931Z</atom:updated>
            <content:encoded><![CDATA[<p>1 year on from installing an ASHP to a 1970s property</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QCYawuzyEYy-rz7-wLlfzg.jpeg" /><figcaption>Our new Mitsubishi Eco-Dan 8.5 kW heat pump in place</figcaption></figure><p>Since moving into our house 7 years ago (a detached, 4-bedroom 1970s build) one downer was the oil boiler that sat behind the kitchen and powered our heating and hot water.</p><p>The boiler smelled bad, it was noisy, required a huge tank of water in the loft, and was attached to a 1,000 litre oil tank in the garden that also smelled bad.</p><p>Over the years I looked into gas as an alternative, but the cost of installing a mains pipe as well as replacing the internal systems seemed prohibitive. It also didn’t seem like the best long term option given environmental concerns.</p><p>Eventually I heard of air source heat pumps as an environmentally friendly way of heating a home. However there was a lot of FUD around the technology at the time, and the upfront costs seemed prohibitive.</p><p>Eventually though we got three quotes to try and find a solution:</p><ul><li>In 2019, with the Renewable Heat Incentive (RHI) in mind we got a quote from a company who did a survey in-person, took a lot of measurements, but they never followed-up after the home visit. They didn’t seem very credible so we dropped it.</li><li>A quote from <a href="https://www.edfenergy.com/heating/electric/air-source-heat-pump">EDF</a> in mid-2020, who had a good financing model — small up-front payment, then sign over the RHI payments (which are phased over 7 years) to them to cover the majority of the cost. However this was for a <em>hybrid</em> heating system — so you still keep the oil boiler in place, and add to that equipment with a heat pump to take load off (EDF claim up to 80%). I was determined to get rid of oil completely and make our system <em>less</em> complicated, not more, so this wasn’t something we continued with.</li><li>The government’s announcement of the doomed <a href="https://www.theguardian.com/environment/2021/sep/08/audit-office-blames-uk-government-for-botched-15bn-green-homes-scheme">Green Homes Grant</a> in late 2020 prompted our third quote from a local company who seemed very knowledgeable and credible. They came back with a reasonable quote as well as a realistic assessment of the challenges of retrofitting a new heating system to a 1970s house.</li></ul><p>Once we decided to go ahead, the details of pressing ahead required a few further visits, and we established a few issues we would face:</p><ul><li>We needed a bigger and more modern immersion tank than the one we had in our airing cupboard</li><li>We were hoping to put a replacement immersion tank in the loft, but the pitch of our roof was too steep to fit any of the available models</li><li>We discussed putting the immersion tank in the garage at the front of the house, but it was too far away from the rest of the house’s plumbing to be practical</li><li>Our power shower needed replacing, as the new system would go from gravity fed (from the smelly water tank in the loft) to an unvented system where water pressure would be even throughout the house</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mc8RE626JVpgMc1DptFwaA.jpeg" /><figcaption>The old water tank in our loft — what a beauty!</figcaption></figure><p>The placement of the immersion tank was the biggest issue, and we eventually settled on sacrificing one bedroom’s built-in wardrobe and building into the bathroom a little.</p><p>The other issue was the Green Homes Grant application process, which was badly administered at all levels, but we were lucky to have been successful in applying and receiving the grant in a reasonable timeframe.</p><p>Once designed, the installation itself took about 4 weeks, as there was quite a lot of work that needed to be done, including:</p><ul><li>A large amount of pipework, a lot of it fixing decades of bad plumbing over the years</li><li>Taking out the old immersion tank, which appeared to have had the airing cupboard built around it</li><li>New electrics and monitoring equipment for the heat pump</li><li>Removal of the old boiler</li><li>Small extension of the old oil boiler’s concrete base, to fit the new ASHP</li><li>Replacing the power shower</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*E-KMUMoHLWsi97QfYKg0pA.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D43ejkliUuJ9iVPqwnW1hA.jpeg" /><figcaption>Hello to the new pre-plumbed immersion tank (left) Goodbye to the old oil boiler (right)</figcaption></figure><p>One thing we didn’t do was to replace <strong>a single radiator</strong> in our house.</p><p>This has been a source of FUD around ASHPs for a long time. We have relatively modern radiators downstairs, and very old single-panel radiators upstairs. All of them are under-powered compared to what our heat loss survey recommended, but we didn’t have the budget to replace any at the time of installation.</p><h4>How has it been?</h4><p>We’ve been very happy with the heat pump — yes it takes longer to heat the house, but with smart controls it’s not been a problem for us. We just set the timer to heat a few hours before we’re up in the mornings.</p><p>There were a few times where the house was a bit cold for a few hours, as it takes about 3 hours for the house to heat up once you’ve changed the thermostat. But given the house is at a constant, moderate temperature, it’s not been a major issue.</p><p>One of the concerns people have before installation is about the noise from heat pumps — this is not something I’ve had any issues with at all. In fact when we’re in our garden, our neighbour’s oil boiler burns louder than our ASHP.</p><p>Other benefits I hadn’t considered was the consistent water pressure we now have across the house is great, I was very happy to get rid of our noisy power shower. I also took great pleasure in cutting up the water tank in the loft and boarding over where it used to sit collecting dust, dead spiders and other gross gunk.</p><h4>Installation Cost</h4><p>In total the system cost us around £12,700 to install, £600 for extra plumbing (ie new shower), and £300 for oil tank removal. So with the GHG payment about £8,500 in upfront costs. We also qualified for around £2,500 in RHI payments, phased quarterly over 7 years, so eventually that will be more like £6,000.</p><h4>Running costs</h4><p>It’s hard to compare running costs with oil year-on-year, as both oil and electricity prices have gone haywire since we had the system installed.</p><p>If our electricity had stayed at the rate of 16p/kWh it was when we had the system installed, our 12 month costs would have been £646. As it is, the energy prices pushed that up to £992.</p><p>As the chart below shows — we started feeling the effects of energy price rises in November 2021. As we’re with Ecotricity they do not qualify for the energy price cap.</p><figure><img alt="Weekly costs of running an air source heat pump over 12 months" src="https://cdn-images-1.medium.com/max/911/1*43x0yT2INyBKK31GcSccZg.png" /><figcaption>Weekly costs of running an Air Source Heat Pump over 12 months</figcaption></figure><p>Would the running costs have been cheaper with oil? It’s hard to tell as I didn’t track the figures accurately beforehand.</p><p>My best guess is we got through about 1,400 litres of kerosine each year. If the oil price stayed £0.43 p/l as it was on the day our heat pump kicked in, that would have come in at £632, so including delivery costs and the electricity cost of running the oil boiler, probably slightly more expensive than the ASHP.</p><p>Of course oil prices have been anything but stable. Assuming a standard year’s order pattern, the oil cost would have been more like £1,200.</p><h4>Carbon emissions</h4><p>More importantly though, the main reason we took the decision to install a heat pump was to reduce our CO2 footprint. So how does that work out?</p><p>Assuming 1,400 litres of kerosine oil burned per year, according to <a href="http://www.carbon-calculator.org.uk/">carbon-calculator.org.uk</a> that amounts to 4,152 kgCO2e. Over 4 metric tonnes! Every year!</p><p>That’s pretty satisfying — and <a href="https://www.nimblefins.co.uk/average-co2-emissions-car-uk#:~:text=Average%20CO2%20Emissions%20Per%20Car%20Per%20Year%20UK,into%20the%20atmosphere%20each%20year.">roughly equivalent</a> to taking 2 and a half cars off the road!</p><h4>Finishing up</h4><p>Our installation didn’t include getting rid of our 1,000 litre tank in the garden. We ended up paying £300 for a local oil company to empty the tank and take it away.</p><p>It also didn’t include removing the old oil boiler, which was large and very, very heavy. It was in good condition so we tried selling it on eBay, but had no luck there. In the end we got a local scrap metal company to come and take it away for free.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2ed63ca15e9c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Hiring an electric car in Mallorca]]></title>
            <link>https://medium.com/@robhammond/hiring-an-electric-car-in-mallorca-222f87816548?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/222f87816548</guid>
            <category><![CDATA[renault-zoe]]></category>
            <category><![CDATA[electric-vehicles]]></category>
            <category><![CDATA[car-rental]]></category>
            <category><![CDATA[mallorca]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 29 Apr 2022 19:32:30 GMT</pubDate>
            <atom:updated>2022-05-10T20:30:23.465Z</atom:updated>
            <content:encoded><![CDATA[<h3>Hiring an Electric Car in Mallorca</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lDchOOHB2bTVRlU2h1OP4A.jpeg" /><figcaption>Sunset over Pollença, Mallorca (plus a Renault Zoe)</figcaption></figure><p>Our family of four took the plunge running a 100% EV household last year. Last week we holidayed in Mallorca, and hired an EV for the first time — how did it go?</p><p>I was a little apprehensive about the charging infrastructure on a small island, so did some basic research on ABRP, ChargePoint and Chargemap apps before hiring the car. The number of points looked reasonable, and although there seemed to be few, if any charging points over 50kW, for a small island that didn’t seem it would be an issue.</p><p>Beyond the practical, real world infrastructure, the Balearic Islands also seemed very forward thinking about their sustainability goals, announcing <a href="https://citiesofthefuture.eu/balearic-government-leans-towards-electric-as-rental-cars-overrun-islands/">back in 2018</a> the phase-out of fossil fuel cars by 2030. And more pressingly, that rental vehicle fleets must be 100% electric by 2025.</p><p>Waking at 2am, we stuffed our bags into our 22kWh 2015 Renault Zoe, and headed for Gatwick Airport for our flight. The Zoe’s decent-size boot easily held our 2 hold bags, 2 large cabin bags and 4 small cabin bags, so we had no concerns about fitting it in at our destination.</p><h3>Arrival Experience</h3><p>On arrival at the car rental desk in Mallorca we were pleased to be told our rental vehicle was, as booked, another Renault Zoe — so no worries about luggage capacity or getting used to the car.</p><p>We weren’t asked by the staff at the rental desk if we had driven an electric vehicle before (or more importantly charged one), so those expecting a primer or even a basic guide (beyond a car manual) would be disappointed.</p><p>The car was fully charged at pickup, with a range of about 320km, so we knew we would have no trouble reaching our villa in Pollença, 62km from Palma. As with our Zoe at home, there was a Type 2 cable in the trunk, but no trickle charge cable.</p><p>First impressions — if you’re not familiar with using (and more importantly charging) an EV, you’re likely facing an unpleasantly steep learning curve for a holiday.</p><h3>Charge Point #1</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/848/0*G-KpWV2kTcQ4x3xr.png" /><figcaption>Charge Point at Carrer de Cecili Metel car park</figcaption></figure><p>On arrival in Pollença, we pulled into the Carrer de Cecili Metel car park whilst we waited for our villa to be prepared. There was one charging point available, but it was out of service. We had used maybe 15–20% of battery getting there so no big deal.</p><h3>Charge Point #2</h3><p>Next stop was the supermarket Eroski Pollença, which had 2 charging points, though both appeared to be out of service.</p><h3>Charge Point #3</h3><p>Third time unlucky was a <a href="https://en.chargemap.com/fenieenergia-ajuntament-de-pollenca.html">FenieEnergia charge point</a> in Port de Pollença on Sunday. So 100% fail rate so far — not great, but we were yet to go below 70% charge, so I wasn’t worried yet…</p><h3>Charge Point #4</h3><p>Fourth time was in a car park just out of town in Pollença, with an ample 9 charge points. One was <a href="https://en.chargemap.com/palma-a-pto-pollenca-aparcamiento-polideportivo-port-de-pollenca.html">another FenieEnergia</a>, which had a green light but didn’t seem to unlock for any of the RFID cards we had packed for the trip.</p><p>The <a href="https://www.electromaps.com/en/map/p/8310">other 8</a> were operated by <a href="http://www.caib.es/sites/energiaicanviclimatic/ca/mobilitat_elactrica_a_les_illes_balears_melib/">MELIB</a> (a network specific to the Balearics), and didn’t appear on ChargeMap, ChargePoint, Kia Charge, ABRP or any of the other apps I had.</p><p>The only reason I found the charge points was because I was curious about the little green tag that was attached to the Zoe keys.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/889/1*L3Nco14fiAtrHBDQmmTdnw.jpeg" /><figcaption>That little green thing pays for fuel!</figcaption></figure><p>I saw the icon somewhere online whilst I was googling something, turns out this was an ‘Electromaps’ RFID tag. After downloading their app, I found more charge points across the island, and the RFID tag allowed us to use the charge points for free!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/679/0*F_d6w3mbWkdX463v.jpg" /><figcaption>Charging success at MELIB Pollença!</figcaption></figure><p>Happy days as we parked next to a stunning brushed chrome Ioniq 5, and easily got 15% charge whilst on a brief trip to town.</p><p>The next day I was going to top up again at a charge point at Parking Puerto De Alcúdia whilst we went on a dolphin watching trip, but we running late so missed out on that one. That was also run by MELIB and looked functional.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iVYKeE3sBh7TXhJbAJ3kDQ.jpeg" /><figcaption>View from Deià</figcaption></figure><p>After topping up in Pollença again during an evening meal, the next day we set off with 90% charge to Deià. This was a beautiful, 1hr 45min drive through serpentine mountain roads and narrow hairpin bends.</p><p>Usually I don’t relish these drives, but in the Zoe it was a dream. The calm induced by the quiet ride, the instant acceleration past the many, many cyclists, and no worries about range all combined into a wonderful day out.</p><p>And despite the many steep ascents and heavy acceleration there was no concern at all about range. Possibly less so than in a petrol car judging by all the signs for petrol stations dotted along the way.</p><p>I had already sussed there were several rapid chargers on the loop back past Inca, so the return journey was no concern.</p><p>On the way back, we pulled up at an <a href="https://goo.gl/maps/kVasaPoMpKoUUdKR9">Iberdrola charge point</a> outside a McDonalds while we did a quick shop in the nearby Aldi. It had 1 each of CCS, CHAdeMO and Type 2 ports.</p><p>There was momentary confusion as I thought the rental Zoe had a functioning CCS port (it didn’t — just a non-removable blanking plate) but using the Type 2 43kw connector, we got it going with our Kia Charge RFID card, and pulled 26% charge in 43mins.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1013/0*zuLYgkQuuN_LIxEs.jpg" /><figcaption>View from Mirador Es Colomer</figcaption></figure><p>The next day we drove up to the beautiful viewpoint at Mirador Es Colomer, a steep, winding drive with plenty of cyclists and pedestrians on the narrow road. The round trip from the villa used up only around 9% of the battery.</p><p>Following this we then drove out to two different beaches, the round trip was relatively flat and about a 60 minute drive in total.</p><p>With the battery dipping below 50% for the first time in the holiday, we wanted to ensure we had a good margin getting to the airport the next day.</p><p>This was the one point in the holiday where range could have been an issue. We had 37% battery left, which was too little to comfortably reach Palma airport from Pollença.</p><p>We had planned ahead though, and again used the Pollença MELIB charging points whilst we ate a delicious meal at the nearby <a href="https://goo.gl/maps/gKbtntbNNs3CHRGQ9">La Trencadora</a>. We got 36% more charge in 2h20min, taking us up to 73%.</p><p>An early morning, 45min highway trip back to Palma airport, and we were down to 49% at drop-off. Being electric, there was no need to fill-up the ‘tank’ prior to drop-off, which was handy.</p><h3>Conclusion</h3><p>Overall a it was great experience — some teething issues and it still needs to be a lot easier for it to be a pleasant experience for someone new to EVs. An information pack in the glovebox with a cheatsheet on charging the vehicle (connectors, charge speeds), and a guide to charging networks on the island would have been helpful.</p><p>Another thing that could have made the experience smoother would have been the inclusion of a trickle charge cable, so we could have charged overnight at our villa rather than out and about.</p><h3>Stats</h3><p><strong>Model:</strong> (2020?) 52kWh Renault Zoe (11k km on the clock)<br><strong>Distance driven:</strong> 639km<br><strong>Number of charges:</strong> 6<br><strong>Dedicated trips just to charge the car:</strong> 0<br><strong>Fuel cost:</strong> €4.85 for the Iberdrola charge (13.65 kWh)— all other charges on the island were free<br><strong>Estimated fuel cost in an equivalent petrol car:</strong> €65.15 (assuming 18.2 km/l in a Renault Clio at a price of €1.86 p/l)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=222f87816548" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Calculating image ratios from decimals in Perl]]></title>
            <link>https://medium.com/@robhammond/calculating-image-ratios-in-perl-c6ddf9f3ad79?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/c6ddf9f3ad79</guid>
            <category><![CDATA[webmaster]]></category>
            <category><![CDATA[perl]]></category>
            <category><![CDATA[tips-and-tricks]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[javascript]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 08 Jun 2018 17:06:24 GMT</pubDate>
            <atom:updated>2018-06-08T17:07:20.730Z</atom:updated>
            <content:encoded><![CDATA[<p>I recently had a need to grab a long list of images used in URLs, along with their dimensions and aspect ratios. One tricky thing with this was converting image sizes into ratios in a Perl script — after a quick Google I found a useful post <a href="http://jonisalonen.com/2012/converting-decimal-numbers-to-ratios/">here</a> about converting decimal numbers to fractions in Javascript but couldn’t find anything for Perl.</p><p>So I’ve shamelessly copied the script straight into Perl which was super easy:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/51c9f94a54a868a05b04419f7f29762f/href">https://medium.com/media/51c9f94a54a868a05b04419f7f29762f/href</a></iframe><p>In context it looks something like the script below:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/2cfd0a98c8dbafd9a1948d49f1efe7bc/href">https://medium.com/media/2cfd0a98c8dbafd9a1948d49f1efe7bc/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c6ddf9f3ad79" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Identifying evergreen content in Google Analytics]]></title>
            <link>https://medium.com/@robhammond/identifying-evergreen-content-in-google-analytics-ed5eb98d29f?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/ed5eb98d29f</guid>
            <category><![CDATA[publishing]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[seo-tips]]></category>
            <category><![CDATA[content-marketing]]></category>
            <category><![CDATA[google-analytics]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Fri, 02 Mar 2018 15:47:21 GMT</pubDate>
            <atom:updated>2018-04-16T11:23:50.828Z</atom:updated>
            <content:encoded><![CDATA[<p>It’s essential for content-focused sites to keep track of how different types of content are performing. One of the more important ones of these, especially following Facebook’s latest <a href="https://www.recode.net/2018/1/11/16881160/facebook-mark-zuckerberg-news-feed-algorithm-content-video-friends-family-media-publishers">publisher referral traffic apocalypse</a> is evergreen content.</p><p>It’s not immediately obvious how to do this in Google Analytics, as there’s no out-of-the-box way to track an article’s publish date.</p><p>There are a number of ways to do it, all of which involve setting up a <a href="https://support.google.com/analytics/answer/2709829?hl=en">custom dimension/metric</a>. However, even with a custom tracking set up, it’s not that obvious how you then use that to filter for articles published within a range of dates.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i12Z-QL58MU8O8MxdRnHPg.png" /><figcaption>Google Analytics has limited options for numerical operators in the standard reporting interface</figcaption></figure><h4>Hyphenated date format</h4><p>The first option is to create a publish date dimension that tracks the publish date in the date format below:</p><p>yyyy-mm-dd</p><p>This is pretty easy for people to read, and easy to find content published in a specific year, month or day. However, it’s pretty difficult to manipulate and segment articles that are performing well that were published, say 6 months ago and separate them from today’s top performers.</p><p>Thanks to GA’s support of regular expressions, it is <em>possible</em> to do this, though fairly tricky, and made slightly trickier by GA’s 128 character limit on regexes in the API.</p><p>After a fair bit of wrangling, this is what I came up with for articles published between the year 2000 and 6 months ago:</p><pre>^(20(00|01|02|03|04|05|06|07|08|09|10|11|12|13|14|15|16)-[0-9]+|2017-0?(1|2|3|4|5|6|7|8|9))-[0-9]+$</pre><p>Yuck. Pretty unreadable and good luck writing that manually. This regex was actually generated by the script below (hat tip to <a href="http://www.perlmonks.org/?node_id=329552">PerlMonks</a>):</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/6e796da9a8200ad837e3afdc62ebe4c4/href">https://medium.com/media/6e796da9a8200ad837e3afdc62ebe4c4/href</a></iframe><p>This approach has the benefit of having a date format that is clear to read in the GA interface, and the regex is flexible enough to use in segments and filters (although ideally driven by a script, so the regex changes with the date).</p><p>One way of using this directly in Google Sheets would be to set up a server to output the regex string, and use the IMPORTDATA function in Google Sheets to pull it in as per the example below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/619/1*COAwJnwc7_MWL8_V4RJpYw.png" /><figcaption>Using a combination of IMPORTDATA and CONCATENATE you can get a dynamically updating date regex</figcaption></figure><h4>Numerical date</h4><p>Another approach would be to remove the hyphen from the date, to create:</p><p>yyyymmdd</p><p>You would need to record this as a Custom Metric rather than Dimension, this way you can use <a href="https://developers.google.com/analytics/devguides/reporting/core/v3/reference#filters">metric filter operators</a> to simply filter for an absolute number less than 6 months ago, for example:</p><pre>ga:metric1&lt;20160902</pre><p>This has the same slight disadvantage as the first solution though, in that it only works well when it’s powered by a script to update the date. This one has the advantage of being a lot easier to achieve using the <a href="https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on">Google Sheets add-on</a> though.</p><p>You could equally use the regex approach above if it’s stored as a dimension, however it would become even less readable without the hyphens!</p><h4>Hours/Days since publish</h4><p>Probably the most robust solution though would be to set up your data layer to output the number of hours and/or the number of days since an article has been published, and track these as additional custom <strong>metrics</strong>.</p><p>This way you can set up a fairly static filter that looks for articles with a consistent <strong>&gt;x days since publish</strong> filter:</p><pre>ga:metric1&gt;10</pre><p>If you have this set up as a dimension, you could use regular expressions, but they would generally be less precise. For example the below regex would filter for a number greater than 99 (ie 3 numbers+):</p><pre>ga:dimension1=~\d{3}</pre><p>Note: this uses curly braces, which Google Analytics has only basic (and <a href="https://support.google.com/analytics/answer/1034324?hl=en&amp;ref_topic=1034375#">undocumented</a>) support for.</p><h4>Useful tools</h4><p>There are a few useful tools out there which will help in the process of using regular expressions to match dates.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/802/1*_zJbcibxeOsmtW2OO1x8nA.png" /></figure><ul><li><a href="http://gamon.webfactional.com/regexnumericrangegenerator/">Regex numeric range generator</a> — fairly easy to use, just input a minimum &amp; maximum date; it will even show you the steps taken to arrive at the regex</li><li><a href="https://www.npmjs.com/package/year-range-regex">Year-range-regex</a> — for the more technically-minded, this is a Node.js package that makes it easy to generate a regex for year-based ranges</li><li><a href="https://www.regextester.com/">Regex Tester</a> — more of a general tool but an easy way to tell if your regex is working, and if not, why not</li></ul><h4>Conclusion</h4><p>The standard reporting interface falls down in all of the solutions, as all of the custom dimension search options are focused on text searches and regular expressions (which are also intended for text matching).</p><p>It is pretty frustrating that neither the <strong><em>Advanced Search</em></strong> nor the filters option in <strong><em>Custom Reports</em></strong> has numerical operator support, but the above should at least be a workable solution for most reporting needs.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ed5eb98d29f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Reader relationship management at the Facebook Journalism Project hack day]]></title>
            <link>https://medium.com/trinity-mirror-digital/reader-relationship-management-at-the-facebook-journalism-project-hack-day-6196b8be93df?source=rss-2e6430ef57d0------2</link>
            <guid isPermaLink="false">https://medium.com/p/6196b8be93df</guid>
            <category><![CDATA[facebook]]></category>
            <category><![CDATA[crm]]></category>
            <category><![CDATA[hackathons]]></category>
            <category><![CDATA[journalism]]></category>
            <category><![CDATA[google]]></category>
            <dc:creator><![CDATA[Rob Hammond]]></dc:creator>
            <pubDate>Wed, 05 Apr 2017 13:37:59 GMT</pubDate>
            <atom:updated>2017-04-05T14:44:43.681Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*joFJflir8oex-oxcvslC-w.jpeg" /><figcaption>Our rough sketch of the problem we were trying to fix</figcaption></figure><p>The <a href="https://media.fb.com/2017/01/11/facebook-journalism-project/">Facebook Journalism Project</a> held its first UK hackathon last week, and Trinity Mirror sent along a team of developers and journalists to participate.</p><p>We did a little preparation before the hack day, but had no solid idea of what to work on. After a brief discussion over breakfast, we settled on trying to solve a fairly simple problem:</p><blockquote>The feedback forms we use at the bottom of articles are effective for gathering stories from readers, but they don’t work on Facebook Instant Articles or AMP</blockquote><p>However, as we looked into the processes behind this method of gathering reader feedback, and plotted out the workflows with editorial members of the team, we came across deeper problems:</p><ul><li>The workflow for creating these forms is cumbersome, and is Yet Another Tool for journalists to learn, use and forget</li><li>The forms don’t integrate very well with our websites and other products</li><li>The forms don’t integrate with our CMS or other internal systems</li></ul><p>Looking beyond these basic issues, we saw an array of options for readers who want to connect with our editorial teams — not just forms embedded in articles, but also:</p><ul><li>Email — direct and group mailboxes</li><li>Article comments</li><li>Facebook, Twitter and other social networks</li><li>Facebook Messenger, Whatsapp and other messaging apps</li><li>Phone and voicemail</li></ul><p>So there are multiple tools to log into constantly to stay on top of everything, phones ringing, notifications going off all over the place, emails stacking up, no way to filter reader feedback by type, urgency or quality, <em>and</em> editorial teams have to keep writing more articles. And (generally speaking) the key metric of their jobs is the last one.</p><p>With all the talk about trust in the news industry, treating readers well should be at the core of what we do. In retail, the customer comes first; in the situation above, this seems inverted, which can’t be good for reader perceptions of any publisher.</p><h3>The solution</h3><p>Our narrow mission statement at the start of the day was:</p><blockquote>To create a publisher-focused embedded form replacement to make it easier for users to submit stories / multimedia / tips on whatever platform they consume our content, and for journalists to assess the value of that content</blockquote><p>However that had expanded/contracted by the end of the day to:</p><blockquote>Making feedback better for journalists and readers across all platforms</blockquote><p>The diagram below shows a rough idea of the proposed ideal workflow to address these challenges.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/794/1*oo29zA63JhkwLmQbdBjcoQ.png" /><figcaption>Proposed workflow for a Reader Relationship Management system</figcaption></figure><p>The core element is a dashboard that collates feedback across all of the reader touchpoints, enabling editorial users to log into one tool to see all feedback, and filter based on importance, subject, sentiment or recency, across all platforms.</p><p>Having been inspired by seeing some of the upcoming capabilities of <a href="https://cloud.google.com/products/machine-learning/">Google Cloud Platform’s Machine Learning</a> stack earlier in the week, I was keen to get some form of AI in the solution. Using the various APIs to parse and help categorise and prioritise reader input seemed as if it could help tackle the issue of large volumes of feedback for small, time-poor editorial teams.</p><h3>The hack</h3><p>Our hack started with hacking together a basic form creation replacement. For this we forked and customised a <a href="https://github.com/minikomi/Bootstrap-Form-Builder/">Github project</a> which had the basic elements in place.</p><p>We then whipped up a basic app around it (using the <a href="http://www.mojolicious.org/">Mojolicious</a> framework) to save the form created in a static HTML file. The form can then be embedded into an article using the iframe code returned. (We looked into piping this directly into our CMS, but had issues with the wifi on the day).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1003/1*AJJK5YL4uDJadT5J0ny-3Q.png" /><figcaption>Form creation process — upon hitting publish, an HTML code block is returned with an iframe of the form</figcaption></figure><p>We then hooked up Google Cloud’s <a href="https://cloud.google.com/natural-language/">Natural Language Processing</a> capabilities to extract sentiment and entities from any messages received, and presented them in the dashboard view below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0f7WXVMmCJh0TYWO1cNoVQ.png" /><figcaption>Quick look dashboard where sentiments and entities are pulled from live data</figcaption></figure><p>To illustrate using the tool beyond simple form feedback, we also created a basic script to pull the latest messages from our Facebook Page inbox, and run these through the NLP APIs too. Although the information pulled through is quite basic, it shows how it might be helpful to see this information in one place.</p><p>The code for the hack can be found on Github:</p><p><a href="https://github.com/robhammond/in_touch">robhammond/in_touch</a></p><h3>Next steps</h3><p>Many businesses spend a lot of time with <a href="https://en.wikipedia.org/wiki/Customer_relationship_management">Consumer Relationship Management</a> tools to better understand and communicate with their users. A ‘Reader Relationship Management’ tool would aim to do the same for publishers.</p><p>There are inevitably pitfalls. It’s likely to suffer from the <a href="https://en.wikipedia.org/wiki/Customer_relationship_management#CRM_paradox">CRM paradox</a>, so it could “occasionally lead to favouritism within an audience” (although that may happen naturally anyway), and it would potentially place another filter between journalists and their audiences. However, if efficiencies can be made by saving journalists time in researching and responding to readers, there should be an overall improvement in communication.</p><p>The tool we put together was just a hack, but with further thought and work it could help publishers have a better go at relationship management between readers and writers.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6196b8be93df" width="1" height="1" alt=""><hr><p><a href="https://medium.com/trinity-mirror-digital/reader-relationship-management-at-the-facebook-journalism-project-hack-day-6196b8be93df">Reader relationship management at the Facebook Journalism Project hack day</a> was originally published in <a href="https://medium.com/trinity-mirror-digital">Reach Product Development</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>