Author Archives: saasmd

About saasmd

I am an experienced software-as-a-service entrepreneur, based in London, UK. I love building interesting software businesses. My current venture is StorIQ, a platform to help bricks-and-mortar retailers manage their operations more effectively. This blog is a space to share low-level techie stuff that I think other people will find useful.

Excel function to count the number of matching words in two cells (‘fuzzy matching’)

I had a requirement to do a ‘fuzzy match’ of two columns of data, based on the number of matching words in each. Add the following code to your Visual Basic module, and then in your Excel spreadsheet, do something … Continue reading

Posted in Uncategorized | Leave a comment

Installing Windows 10 over Linux (Ubuntu)

I have an Intel NUC that I’d installed Ubuntu on, and now I have decided to install Windows 10 over the top of it so the kids can use it. I have just spent a merry two hours trying to … Continue reading

Posted in Uncategorized | Leave a comment

Updating Rails / MySQL database datetime fields

We have a demo site that we show to prospective clients, and we reset it occasionally using a ‘seed database’ that we have created to give realistic reporting data. The problem is that the timestamps on the seed database get … Continue reading

Posted in Uncategorized | Leave a comment

Some tips on getting Windows 10 to run VirtualBox with Ubuntu 14.04 for Rails

Here are some commands I found useful setting up my virtual machine ready for Ruby on Rails – as usual, exercise your own caution! Host system Windows 10 VirtualBox 4.3.30 Virtual Machine Ubuntu 14.04 Set up a new unix user … Continue reading

Posted in Techy Stuff | Leave a comment

Owncloud upgrade when data directory is not in standard htdocs folder

When I installed owncloud on our Debian Jessie server I didn’t like the way the data directory was under the htdocs path, so I did a custom install and created an owncloud-specific apache config file (owncloud.conf) in the apache sites-available directory … Continue reading

Posted in Techy Stuff | Tagged , , , | Leave a comment

Xero bank reconciliation with GoCardless

If you’re using automatic repeating invoice generation with Xero, and a monthly direct debit plan with GoCardless, there’s a ‘problem’ in that the value credited to your bank account by GoCardless already has their transaction fee deducted – so Xero won’t spot … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

How to get Squirrels Reflector working from iPad to Mac

If you want to record your iPad using Squirrels Reflector software*, but the iPad won’t show your Mac on the list of Airplay devices, here’s a workaround I found that others might find helpful – assuming you’ve got an iPhone, that … Continue reading

Posted in Uncategorized | Leave a comment