Thursday, 7 February 2019

Ramsey Marina Thoughts

Such a large investment into the town of Ramsey is sure to bring much comment and speculation. I'm not sure whether the whole idea is a good one or a bad one for the town - everyone will have an opinion about this and each one will be different. I'm sure that, the older the person, the more nostalgic the view will be and users of the beach will surely be more vocal.

In this entry, I'm going to look at the cost of the proposal and whether it's a realistic, practical and financially viable proposition.

So, £100m to build a 400-berth marina and 200 homes by reclaiming an area of the bay about the size of the existing town centre of Ramsey. This will - if it happens - be the biggest single investment in the island ever and one of the biggest capital projects as well. Apparently, £50m is to be funded by selling the 200 properties - an average selling price of £250k which is quite reasonable for a new development.

It could be argued that 200 properties - probably being sold off-plan - is quite a hard sell anywhere. Without knowing the exact proposed mix of properties (the proposal suggests apartments and town houses without further details) it is hard to make any estimate of the viability of such a proposal. Does Ramsey have the infrastructure for several hundred new residents? Parking requirements for the development will obviously require the suggested underground facilities to be substantial. The recent work in Ramsey and the north to upgrade sewerage treatment facilities probably never envisioned a large development in that part of the town either. These increased requirements can, to a moderate extent, be paid for by the rates on the properties once occupied and this does indeed make a positive contribution to the town.

So, the other £50m is to come from private investment for the construction of the Marina, Hotel and Yacht club. This must be assumed to be an investment for profit in the medium to long term - there's no quick killing to be made here.

The Island already has two marina facilities, both restricted by tidal access and both managed by central government. Current charges here are £151 per metre per year for annual payments. Berths include access to electricity and water.

From the vague plans on show on the ramseymarina.com website, it's not obvious just how many linear metres of berthing space are to be made available. I'm going to assume that 400 berths at 10m (4000m) is about fair, particularly given the limited depth available at low water and the relatively restricted nature of the entrance to the marina.

So, if the government were running this at the same rates as they do for the existing marinas, they would see a maximum income of £604,000 per year from mooring fees. This would be less the running costs and maintenance / dredging expenses that would be ongoing. So, being generous because the proposal is for a 24/7 access marina, let's assume a maximum potential income of £1m per year gross. What this would be net of expenses, I don't know, but the income would be subject to VAT and taxes, so we're already down to £800k or less per year without paying any staff or maintenance.

Now, I'm no financial advisor, but I can wield a spreadsheet fairly well and I hope I do understand money at least a little. These sort of figures (£800K per year on £50M invested) give a return of 1.6%. You can get similar rates at the bank for just a few thousand pounds of capital, never mind what they'd give you for millions.

Is it a risk? Sure - it could silt up so fast the dredgers can't keep up, or simply wash away in an easterly gale. People might not come, too few people may come or they may just find too little to do in Ramsey despite a new hotel, restaurants and the yacht club.

My conclusion, I wouldn't get out of bed for 1.6% if I had £50M to invest and I don't think many other potential third-party investors would either, particularly considering the risks involved.

I would be very concerned about allowing such a venture to be started unless all the funding was in place and guarantees for completion were imposed. There could be nothing worse for Ramsey than to see the promenade and foreshore destroyed then the money dry up and everything be abandoned either to be left in disarray or to allow people to persuade the government to spend tens of millions completing what may be a huge white elephant.

Monday, 28 January 2019

Travel Books Update

I've updated my Travel Books page to reflect the availability of my new book, detailing my trip to Uganda in December 2018. As always, it's available on Blurb.com, but they are never cheap.


Wednesday, 9 January 2019

The Uganda Report

I've just finished writing up my Uganda 2018 Trip report. It's six pages and not really like any report I've written before. I had a really strange trip and an even stranger run-up to going, so it is all a bit of a confused mess really.



Still, you might enjoy reading about where we went and what we did again.

There's a link in the main menu to the right of this article, or by following this one: https://darkmann-iom.blogspot.com/p/uganda-2018-part-1.html

Sunday, 30 September 2018

More BookingTrack News

I'm still working on BookingTrack - see THIS page for the detailed description. The current focus of the work is to make some key parts of the database available on the local network of computers and devices that the client uses.

So far, I have the Contact Logging part of the program working as a stand-alone module that will allow staff members to log contact with the clients from any machine connected to the network. These devices can be either a PC or an Android-powered mobile phone or tablet device.

If I'm honest, I've never done this type of client/server programming before and I'm finding it all a bit of a challenge to get things working smoothly. I need to write down much more - in terms of notes about rules and data structures - than I've ever had to do before. Still, it is enjoyable and has given me loads of ideas for more projects over the long winter.

Saturday, 8 September 2018

Working With RFID Tags

As often happens, I was asked an unusual question by a customer the other day and just had to investigate further. The customer had been looking at quite expensive RFID chip-based cards to use in order to use them as gift vouchers and then as ongoing membership cards.

Well it turns out the cards and readers are really inexpensive if you don't actually need to write data to the cards. I wouldn't write to the cards anyway as that has all sorts of GDPR ramifications that are better avoided.


So, I ordered a card reader from Amazon and while I waited for it to arrive, I started to work out some basic software to manage some cards. As is usually the case with something I'm interested in, progress is fairly quick and after just a couple of days working at it on and off, here's the current state of progress.


So, once you start the program, it will sit and wait for you to scan a tag. If that tag is in the database, then you will be able to display and update the account information for that person as shown below.


As you can see in the top image, I have both cards and key fobs to test with, so the program allows you to register one of each with a given customer. For this customer, the program offers basic account management, to keep track of the balance associated with the account.

I'm going to work on a loyalty card type system next, based on this same framework, but simply counting up the number of times the card is used to offer discounts, bonuses and so on. I've found a source of ready-printed cards (they work out at about £1 each or so in sensible quantities).

As always, watch this space.

Tuesday, 28 August 2018

BookingTrack Progress and InvoiceBuilder

Well, development is slowing down a bit - mostly because the primary requirements are mostly written and tested - but that's another 2200 lines of code during the long weekend.


The system now has support for the creation and management of menus for functions - something the client requested at our last progress meeting. Loads of bugs have been squashed and I'm currently adding lots of range checks and input limits to help trap more possible bugs. Find out more by following the link HERE.

On a related front, I'm also working on InvoiceBuilder. This fairly simple program makes it possible to create an invoice or quotation from a database of products or services. It will record the details and create a nice, well-laid-out printable document on demand.



It's totally configurable and "Just Works", ideal for any small business that still prepares their accounts manually or on a spreadsheet and want something more professional and consistent in look and feel. it even allows you to create an Invoice Wizard that guides you step by step through creating a standard invoice or quotation.


The main invoice screen even looks similar to the final invoice to make it easy to follow and easy to use.

Sunday, 19 August 2018

BookingTrack

Once I get started on a new project, there's just no stopping me until it is complete. After just eight days of development, BookingTrack is almost 4000 lines of code and getting close to being ready for real-world testing.



It will allow the client who has asked for it to keep track of client contacts and manage bookings across their multi-space events and hospitality venue here on the Isle of Man. I'll probably make it available to others later, but much testing needs to be done yet.

Full details of progress and features can be found at this link - BookingTrack