In our business, we meet and talk to many companies every week. About 3/4 of them continue to use spreadsheets to plan and schedule their resources. They all have one other thing in common … they all manage several ‘resources’. The name of the resources may vary, but the concept is the same. A resource could be a client, a job, staff, vehicles, plant, machines, training courses, rooms, equipment, etc. It really doesn’t matter, it only matters that they are all looking after several ‘things’.
Every day, or every week, the planners within these businesses open up ‘their copy’ of the spreadsheet and wonder if there is a better way. Often times they even created the spreadsheet themselves, sometimes they inherited it or were given it as ‘the tool’ to use. However they got into this position, every day (or week), their starting point is a tool that was not designed to perform this function.
So why is a spreadsheet the wrong tool? Continue reading “Struggling To Plan Using A Spreadsheet? Find Out Why It Is Not Your Fault.”