VLOOKUP vs INDEX ( MATCH)

How awesome is this! Excel =INDEX, is a matrix retrieve i.e. =INDEX(array, row, col) retrieves an entry from the two dimensional array. If we combine this with MATCH which returns a row number we can use these functions instead of =VLOOKUP, its allegedly faster too. MATCH operates on a column or linguistically a list.

Read more

My little mail server

What a pile of poo! I have access to four smtp servers and they all have limits on the distribution list size! (They are all about the same size of 100). Google will allow 2000 per list but only if you use one of their clients. Let’s try and bring up an SMTP server, connect…

Read more

Planet, mingle & wordpress

While developing the new web site, I had a look at how my mingle was organised. The current regime has a conversion rules file for each output format and one for HTML. I need to incorporate the HTML output in a wordpress page and also apply the wordpress style rules to the HTML. I solved…

Read more

Docker

About Docker, looks awesome. Easy to create bootable, runnable images, easy to deploy because the global hub site is a crucial part of the proposition. The free usage of the hub, encourages the publication and sharing of images which are then imported over the internet. Originally written the summer of 2015, and revised in the…

Read more

JSON to XML

In order to export the ello.co feed, I need to convert the JSON to XML. This isn’t the first time I have needed to look at this sort of problem and so I have created a page to hold my notes. I have put these things together in a python script, and posted it to…

Read more

using github

I finally got a git account, my site is here. This page is about how to, but does not have any command runes. They are held elsewhere. This page was started in 2011 and I have returned to using git at several times over the years. I tidied up the page in Feb 2019 and…

Read more

Exporting ello.co

This it seems is no longer relevant. I have marked it deprecated. The ello URL syntax described i.e.  http://ello.co/username.json no longer works. They weren’t very helpful to the project when I first looked at it. This post morphed into a generic web login via scripts page. I will consider splitting it and making the ello…

Read more

Spacious Theme

By themegrill.com, they say, Spacious is incredibly spacious with a clean responsive design. And it has many awesome features like image slider, theme options & many more! I am cobsidering to freshen up http://davelevy.info, to see what it looks like, see http://davelevy.info

Read more

Estimation Errors

Is there any theory that talks to human optimism or pessimism when making estimates in the context of contracts. I have worked with project managers who when estimating effort & duration look to counter the uplift applied by people who think they’re going to have to do what they’re estimating and will be treated more…

Read more

User Styles & Stylish

I experimented with User Styles when I was using the old NWN Vault, because their look and feel was terrible, the vault has gone now and the code i.e. the customisations are held on the browser’s disk, so a growing use of cloud computing challenges this as an answer, but overwriting the CSS  can be…

Read more

Auto-translating a web page

This page was originally set up in 2015 when looking at using REST to invoke web site translations. My original code is still available on the test web site and below but Google & Babelfish have changed their APIs. I decided to refactor the page in 2022. The changes in the google API have been…

Read more