Author: Olly

  • Remove text from end of cell content in entire Column – MS Excel

    We’ve been working on a large project now for a good 3 or 4 months for one of our customers, and the final stage of the project is to add a load of free listings to their new directory style website.

    We have the bulk data in a spreadsheet and i have spent a good few days sorting the content out so that each column contains the right data (such as ensuring the street from each entry is in the “Street” column etc.

    I needed to duplicate the postcode column and remove the last part of it so that i had a “Postcode district” column so the import would place the listings in the right part of the directory (the last category level is “Postcode district”)

    However, there are 1776 entries!

    I spoke to an Excel specialist who solved my problems 🙂

    (more…)

  • Removing the VAT from a VAT Inclusive Price

    Ok, so we just spent the last 30 mins figuring out how to remove the VAT (20%) from a VAT inclusive price.

    The reason for this, is a customer of ours has an awesome online shop made by us – and all his prices are INCLUSIVE of VAT/Tax. He trades internationally, so we’ve been working on a cool EUVAT/Vat Exempt module so that (example) if someone buys from the EU and is EUVAT registered, they input their EUVAT number, the site instantly checks it for validity and if its OK removes the Tax/VAT from the order.

    It has a whole heap of other “conditions” with it, but thats not the reason for this blog post.

    We wanted to bulk remove the vat from his products, but our initial plan fell flat on its face, becasue;

    £100 + 20% VAT = £120

    £120 – 20% VAT = £96

    Ah.

    The reason for this is that 20% of 100 is not the same as 20% of 120….

    So we racked our brains for all those formulas and junk we learnt in school, and asked a few friends who mostly pointed us to cool websites that seemed to do the job – but we were still no closer to actualyl figuring out what the formula was..

    Then all of a sudden, bingo!

    One of the lads figured it out, and here it is;

    (total_price/(100+VAT))*100

    So, as we break it down…..

    (120/(100+20))*100

    (120/120)*100

    1*100

    £100

    Bingo! 🙂

  • Chocolate Milk Review: Mars Milkshake

    When it comes to chocolate milk, there is one that (for me) stands above the rest. If an old friend was to meet up with me and wanted to bring a drink as a present, it would probably be a mars milkshake – ive often wondered why Mars haven’t sponsored me yet with how many ive bought and consumed throughout the years and how famous together we have become haha… 😐

    Mars. Probably my fav :)

    Anyway, Mars milk has a hint of caramel as well as its based around a mars bar – the taste is similar but you are never going to replicate an actual marsbar in a drink!

    They taste delicious and are apparently not too bad for athletes or something – i read it on the bottle once but didn’t pay that much attention.

    They also so an extra choc one that is ok but it loses its Mars Charm as there is less caramel – and the thick shake is nice but it will never be the original mars milkshake. And for those of you who dont drink it often you can get it in a powder form so you can enjoy whenever you want.

    I actually think it tastes better out a carton – like coke out a glass bottle – there is just something about it 🙂

     

  • Chocolate Milk Review: Battle of the Supermarkets Part 1

    Every supermarket sells their own brand chocolate milk alongside the popular brands, and most of them are pretty much on par with them too. It’s Tesco and Asda up first, and both offer a similar drink in terms of taste, quantity and value – except the tesco one tasted a lot sweeter and the packaging was more childish, whereas the asda drink tasted like it was less artificial, not as sweet – slightly better quality maybe?

    If I was to go and buy one of them again now, I’d buy the asda brand one!

    Tesco Chocolate Milk – 6/10
    Asda Chocolate Milk – 7/10

    And in the supermarket rankings it’s Asda in first place with Tesco not far behind..

    Next, Sainsburys and Co-op 🙂