Case Studies


Lincoln City FC

When we first began to work with Lincoln City Football Club, they already had a well-organised and disciplined setup. All paperwork was completed and returned in a timely and orderly fashion, staff had a role and were comfortable within that role, a board of directors who were firmly behind the organisation and a Youth Department who had a place for everything and everything in its place. What use were we in a case like that? An obvious question with a simple answer! We would help them to streamline and manage their data in an orderly way which would allow for multiple users to access at will.

Our first task was to look at the existing data management system and identify how it could be improved. We had, in the past maintained and re-organised the database used to store not only names and addresses, but also relevant dates and squad info. The system was beginning to become a little slow and cumbersome due to the outmoded method of storage. Although working, it would be better served becoming a multi-user, heirarchical system with security and access levels. The system was held on one PC which was operated by a member of staff who had access to the system when they were in the office. This person was very efficient when it came to managing and updating the system and had to this point done a very good job, it just needed to be made available to a wider user-base.

Read More…


Sole Trader


Sole Trader We were contacted by this particular company several months ago to see if we could help them get a better grip on the office-based activities. The company consisted of one man, on his own finding the work, doing the work and carrying out all paperwork related to the work. The work load was huge and at times he found he was snowed-under due to catching up on paperwork. Quotes needed to be created, invoices needed sending, customers were notes on a pad or pieces of paper in a filing cabinet under the desk. He was only doing what so many sole traders have done - swim as fast as possible, often against the tide. He knew he needed help but wanted a simple means to get done what he needed to do.

When we first went to see him, it was at the third attempt. Two previous meetings had been rearranged due to heavy workload on his part. He could see it was getting harder but couldn't find the time to meet to see if he could make it easier! Finally, he bit the bullet and decided he couldn't wait any longer. We arranged a date and time and advised us we were to turn up whether he cancelled or not! Unusual but we could see what he meant. His home office was awash with pieces of paper, a paper calendar with so many marks, crosses and names o it you struggled to make any information out. We deliberately asked him to pick a time when he would be in the office doing paperwork so we could see what he did. Luckily for us, the phone rang several times in our meeting so we got an even better idea on what he faced. We could see the solution and could see how we could help.

He would answer a call from a prospective, new or existing client. He wrote on a piece of paper what they wanted and arranged a time to go see them. He wrote the date on the calendar and a brief description on what they needed. In between, he was preparing a quote for a couple of clients he had been to see. Both needed very similar quotes creating but one had additional items. He wrote them out by hand. He had said he set up an Excel spreadsheet and used that for a while but found that too restrictive as he forgot to change the names a couple of times and sent it out. Simple mistake but potentially embarrassing.

Once we had collected our information we said we could create a solution for him that would absolutely save him time and allow him to spend time on actual work, rather than paperwork. He was delighted, but sceptical. He wasn't the first and wouldn't be the last! After a couple more calls to check information, he instructed us to go ahead.

Two weeks later, we went back to his office to install the new system and show him how it worked (that is always part of the service if required). Within 30 minutes he was, to use his own words 'absolutely speechless!'. We had not only reduced the time involved to create a quote so it could now be done within 30 seconds, we had also removed the possibility of any wrong information appearing on it. His quotes were now in the system and could be viewed again, modified, sent again, printed and, best of all.. converted to an invoice on job completion. His customers were all in the system so any work carried out in future could be allocated directly to them. He could see a list of all work carried out for that customer. He could see who his suppliers were and how much he had bought from them. He could see which suppliers he owed money to and which invoices to him were outstanding. At a glance he had a complete picture of his business.

We visited him again after 2 months had elapsed to check how he was doing and to modify anything he may need tweaking. What we found was a relaxed, in control and, most of all happy customer. He said that his work-life balance had improved as he was no longer spending several hours at night in his office catching up. He had a better indication of where he currently was and what he had to do. His turnover had increased a little as a result of being able to manage the invoicing better and being more efficient with suppliers. He had also negotiated a better discount with his main supplier as he agreed to pay in a shorter time which meant he made a little more on jobs.

We are scheduled to go back in a couple of weeks as he now wants us to put graphs into the system and create an output he can pass to his accountant with an overall annual picture of incomings and outgoings. Small enhancements to the system that will add to the value to him as a business-owner.

Removals and Storage Company

A company who specialise in the relocation and storage industry contacted us looking to find a solution to a problem they had. When we arrived, they were still using a clipboard and pen to measure the items and quantity within a property. Whilst this was effective and did what they needed, they knew there was a better way.

After seeing how they carried out their estimating and the subsequent work involved afterwards, we set about creating a solution. From this, StorM was born!

The problem they had was that the offices held a mixture of both Windows-based and Apple computers. They needed a solution which would work on both platforms. We had something similar previously when we created a web-based solution but the company wanted something which would be in-house.

Read More…


Construction Company

We were contacted by a construction company who had always managed their data using a mixture of spreadsheets, database and hard copy.  They knew this was a system that needed to be modernised yet retain the simplicity they had become accustomed to.

We were tasked with carrying out a complete analysis of their current work method and building a system around what they did.  This involved us spending time with them and watching how things worked (we were even roped into lifting at one point!) before building an outline construct of what we proposed.  They system itself was easy to understand, it just needed to be built in an electronic way.

The screenshot shown above shows what we built and what it can do. The system is designed to be used by 4 office staff and is managed by one of those users. Data is centralised so that all see the same information, 3 users can update and 1 is view-only.

Read More…


Sports Player Management System


Sports Player Management System We were contacted in mid-2015 by a sports company based in Lincolnshire to provide a means to showcase the athletes they had registered with them. They needed to be able to update the system themselves and allow general access for those interested. Following discussions to establish exactly what was required, we set about creating a system which would effectively be two systems in one - a public system to view athletes and a private system for the company to register and keep details on the athletes themselves but ensuring the information stayed private.

In 2012 we were asked to speak at a conference in Atlanta, Gerogia on football administration and the need for better record-keeping in sport. This, coupled with the system we had designed led us down the path to where we are today. We were aware of the large number of UK students heading to the USA for sports scholarships. This was done mainly through email and YouTube-type videos. We knew there must be a better way.

We built from scratch a system which would not only allow front-end access but also access for adding and administering players. We also needed to built a third access system which would be for coaches to view player details. The system we built allowed coaches to build a list of players they had contacted and were trying to draft into their teams. This was perfect for the US scholarship system. Following discussions with several companies who specialised in sports scholarships and player representation, we added a couple of hundred players in a very short space of time. Whilst we had been speaking with these companies, we were also in contact with US colleges who use foreign players for their squads. The result of this was that we built a system which quickly had 300 players and over 800 US college coaches accessing the system!

The system has been up and running successfully for a number of years now and currently has just over 1500 college coaches registered to use the system.

Email:
Call: 01754 896677

Get in touch:

For more information, enquiries or to have a chat about what we can do for you just get in touch by using our contact details.

Contact Form Contact Form

Thanks for stopping by enjoy the rest of your Sunday


© 2018 All rights reserved Polarsun CreativeSite Developed by - Polarsun