Tag: excel

  • Stop paying for subscriptions

    Stop paying for subscriptions

    Do you remember the time when the internet was a free place? Information was there, and you just needed to use AltaVista or Yahoo to find it. There was Limewire, DC++ or Napster. There were free MP3s floating around the internet. There was MySpace!


    The programmes that we were using on the PC were “free” or almost free. At least there was no monthly subscription. Pay once, use it forever.


    But when MySpace disappeared and YouTube appeared, that’s when things started changing. Companies started charging for extra things and extra services. For example, Microsoft Excel was (and still is) a program that you can buy once. But fewer people buy it nowadays as a separate software. Most people use it as part of the Office suite that comes with Microsoft 365. AutoCAD, a very well-known CAD software, started the software-as-a-service charging model, without offering much of a service. What you would buy once and use forever, now became a quite expensive monthly subscription. And worth mentioning, “Photoshop” – the pioneering software for photo editing, the one and only go-to program that photographers use to edit their photos – went from a one-off program to a monthly subscription software. Music became the same way. Movies too.


    But things haven’t changed completely. There are still plenty and pretty good alternatives to the “I want you to pay us every month” model that the big players have adopted.


    LibreOffice: The open-source (and free) alternative to Microsoft Office. With this one, you can replace MS-Word, Excel, and many more. Find it here: https://www.libreoffice.org/

    Linux (Ubuntu): Microsoft Windows comes pre-installed on each laptop. But…their price is already included in the new laptop’s price tag. There are laptops out there without a pre-installed operating system that are significantly cheaper than the ones that have an OS installed. What you have to do is install a Linux distro such as Ubuntu, which is 100% free and easy to use. Especially if the computer is going to be used for online work, then why bother spending hundreds of pounds on an OS? Find it here: https://ubuntu.com/

    Affinity Photo/Designer: Adobe Photoshop and Illustrator are two well-known programs that photographers and designers use. About 10 years ago, they jumped to the subscription boat, and they are quite expensive, especially if you are not a professional designer/photographer. Thankfully, there are a dozen alternatives out there that aren’t following the monthly subscription model, and they are as good as Adobe’s programs (or even better). I am using Affinity’s Photo and Designer to do creative work, and I can say I am impressed. They work amazingly well on almost all platforms, even on iPad. Affinity sells them as a one-off payment/use forever product, and you can either buy them separately or as a package for all platforms (Windows, macOS, and iPadOS) at around £100. Get them here: https://affinity.serif.com/en-gb/


    ProgeCAD: The best AutoCAD alternative in the whole market. That’s it. It is a 100% AutoCAD clone (but the design engine is completely different), and it can do whatever a drafter that uses AutoCAD needs. I cannot recommend it enough! I really love this program. And not only this, it can read AutoLISP scripts that you might have! Find it at: https://www.progesoft.com/


    Stremio: An alternative to Netflix. The media center allows you to watch movies, series, YouTube channels instantly. You can watch in HD, with subtitles, and easily cast any file to TV through DLNA, Chromecast, or AppleTV! CAUTION: As it allows the user to use add-ons that have access to torrents, I would use it with a VPN, as this is considered piracy, which of course I condemn.


    Cloud storage: You can also set up your own online storage server and say goodbye to the expensive cloud storage from iDrive, Google Drive, Dropbox, etc. Although you have to buy and set up your own small file server, there are so many easy-to-use solutions out there that are user-friendly and can be set up in less than half an hour. I would recommend Synology (https://www.synology.com/en-uk) or Western Digital (https://www.westerndigital.com/solutions/network-attached-storage) because of their brands.


    One software at the time! Regain your freedom from the subscription model and control of your digital life. The options are hundreds.

  • Digitalisation of the construction industry

    Digitalisation of the construction industry

    We are living in the digital age. Everything nowadays is an app and the phones we have in our pockets are multiple times faster than the processor used to get the man to the moon. And yet, thousands of small/medium businesses haven’t jumped on the digital boat. Especially in the construction sector, pen and paper is still the king, even though COVID-19 gave a boost towards digital practices.

    There are several benefits into going digital but also there are some factors that for companies, especially small, are acting as blockers to the adoption. The negative factors include: the cost, effort and the changes needed. It is also worth mentioning that there is a shortage of skilled people that are equipped with the right digital capabilities to use new technologies.

    On the other hand, the benefits are countless. Just to mention a few:

    • Efficiency improvement: project management, project scheduling and communications can become more efficient, faster and reduce the project completion time.
    • Cost reduction: using software like BIM or CAD can help to avoid potential problems in the design, save costs on paperwork, printing and record keeping.
    • Better communication: Digital tools can enable better communication and collaboration among team members, subcontractors, and clients, leading to fewer misunderstandings and improved decision making.
    • Accuracy in data: Data are easier to access using specific software. Tools like Microsoft Excel can help with data analysis and keeping data up to date.
    • Remote working: The pandemic of 2019 showed that remote collaboration is achievable and, in many cases, can lead to even greater productivity between the team members, even if they are in different locations (even countries). This also leads to employee talented employees that would be difficult or impossible to employee before.
    • Reduced waste: Going digital can contribute to a reduced carbon footprint by omitting paperwork and physical folders and be replaced with digital storage and files.

    Simple digital tools and devices to make you become fully digital:

    • Storage Server

    First and foremost, going digital means you must have somewhere to store your files. Like old time folders and drawers, a server serves the same purpose. Of course, it takes way less space and money. There are 2 different ways to store files though. One is to hire cloud space or use services like DropBox, OneDrive etc. This is a solution that doesn’t require a physical server, but it adds on your monthly budget as it requires a subscription. The other solution is to buy a server.

    Server here, doesn’t mean the big chunky rack that will occupy a whole room. It is just a small device, or a computer (or in some cases a very small rack) that is 24/7 online. All of the office computers are connected to it and the files are accessible from all the connected devices that can see it as an additional Hard Drive.

    You can also add an additional remote server (somewhere far away from the first one, in another building probably) that will have the purpose of a backup machine. In case of a disaster there will be another exact copy of all your files somewhere.

    There are quite a few advantages using a server/cloud storage for your business:

    • There is a centralised file storage that can make it easier for employees to access the files they need.
    • It facilitates the collaboration between employees. Multiple employees can work on the same files from different locations.
    • It gives employees remote access to the files. Imagine being at the construction site and needing access to some drawings. You open a tablet, you go through the server, you open the drawings and voila! No need to carry any printed drawings with you.
    • It provides access to very old files that otherwise would be submerged under a pile of folders into a basement. You remember this old project back in 2018 near Exeter? You need to find your sign-off sheets from back then? No problem. Go through your server files and they will be there.
    • Microsoft Excel

    Excel is one of my favourite tools. Maybe it is my favourite, I don’t know. The one thing I know is that Excel has saved me thousands of working hours. It has helped me in calculations, in estimations, in tender preparation, in exporting hundreds of PDF files automatically. It is THE TOOL. It is a programming language wrapped around an understandable interface with understandable and easy commands.

    Excel can be helpful to construction companies in many ways. It can create and manage budgets, track expenses, create schedules, track progress, and identify potential problems, track inventory levels, order supplies and costs.

    It is used to create estimates for projects, track changes to estimates, and generate reports.

    It can be used to create and store documents, such as contracts, and invoices.

    I really don’t know why someone wouldn’t use it.

    If you are already using it check an article I have written back in 2019 regarding Excel commands that will make your life easier.

    • iPads (with a pen)

    When I bought my first iPad I wondered: “Why I haven’t bought one earlier?”. Yes, that was my reaction. I have written my review on my blog where you can read more about it. But how can it be used in the construction sector?

    As we are turning more of our processes into digital, the replacement of the physical paper is inevitable. We need something to depict the files we are using though. The mobile phone screens are too small. A laptop is too heavy. What a better replacement than an iPad? It has a large enough quality screen that can display drawings, photos and PDFs but it is not heavy and can be carried around. Add a digital pen to it and you have a killer combination for signing files, reading files and creating new ones. Give it access to your office server and you have your whole desk in a 10-inch computer machine!

    • AutoCAD

    AutoCAD is my second love (or first). I use it in combination with Excel in my everyday working tasks anyway. I could not live without it and despite that the software is around 40+ years, it is still irreplaceable.

    I use AutoCAD in all the take-offs I have to make in order to estimate budgets or quantities.

    Do you want to measure the volume of an excavation? AutoCAD is for you.

    Do you want to create a marked up drawing? AutoCAD will do this.

    Do you want to create a tender for a housing project? AutoCAD will help you with this as well.

    Do you want to draft a drawing of how your house’s front elevation will look like? AutoCAD…

    It is quite expensive though but there are lots of alternatives or clones out in the market.

    One of them is ProgeCAD. I discovered it in 2018 and I haven’t stopped using it since then.

    I wrote about my initial impressions on my personal block and you can read it here.

    • PDF Expert

    PDF Expert is a PDF editing app for iPhone, iPad, and Mac. It allows users to read, annotate, edit, and sign PDFs. PDF Expert also offers features such as OCR, form filling, and password protection. In my opinion is the best PDF tool on the app store but unfortunately it is only available for Apple devices.

    There are two reasons I like this app. First of all, it allows the user to annotate anywhere on a file. It means that you don’t have to use specific software to sign a document or to keep some notes on the PDFs. The second reason is that it has direct access to a WebDAV address. If you are using a server then it probably has the ability to provide access using various protocols (like FTP ie). One of them is WebDAV. I haven’t seen any other PDF tool using WebDAV protocol to be honest!

    • Project Managing tools (Trello etc)

    Project management tools are software applications that help project managers to plan, track, and manage projects.

    They can be used to improve the efficiency, productivity and profitability. They also help to improve the communication and the scheduling between different employees working on the same project.

    The most widely used software for Project Management are:

    • Microsoft Project: Microsoft Project is a popular project management tool that is used by businesses of all sizes. It offers a wide range of features, including scheduling, budgeting, and communication.
    • Trello: Trello is a visual project management tool that uses boards, lists, and cards to organize tasks. It is a popular choice for teams that need to collaborate on projects.
    • Monday.com: Monday.com is a flexible project management tool that can be customized to meet the specific needs of the organization. It offers a variety of features, including task management, scheduling, and reporting.
    • Wrike: Wrike is a cloud-based project management tool that is easy to use and affordable. It offers a variety of features, including task management, file sharing, and collaboration.

    I personally prefer using Trello and for smaller projects I also like KanbanFlow.

    • Communication apps

    Going digital means the meeting you would do face to face can be done online. Messages can be sent and received on various devices and files can be transmitted instantly with a press of a button.

    There are several communication apps on the market that can serve various needs.

    For normal messaging there are the classic apps like WhatApp, Signal, Viber etc.

    During the COVID-19 pandemic there was the boom of the online meeting apps. The usage of software like Zoom and Team skyrocketed.

    So which ones are the most popular?

    • Microsoft Teams: Microsoft Teams is a cloud-based collaboration platform that includes features for chat, video conferencing and file sharing. It is a popular choice for businesses of all sizes.
    • Zoom: Does the same as Microsoft Teams.
    • Google Workspace: Google Workspace is a suite of cloud-based productivity tools that includes Gmail, Docs, Sheets, Slides, and Calendar. It also offers features for chat, video conferencing, and file sharing. Google Workspace is a popular choice for businesses that need to collaborate on documents and spreadsheets.
    • Slack: Slack is a popular team messaging platform that allows real-time communication through channels, direct messaging, and integrations with various apps and services.

    I personally prefer Microsoft Teams. Not because is the best programme though, but because it is part of the Office365 suite.

    • Microsoft 365 Suite

    I assume that one way or another everyone uses some parts of the Microsoft 365 suite in their everyday work. Either, you login to your email account through Outlook, or you pay a monthly subscription for Excel then you are probably have access to the whole software package.

    The package includes so many programmes that can help you with productivity and digitalisation. Already mentioned, Teams and Excel are the ones that will help you a lot regarding productivity and admittedly, Outlook is a very nice email client.

    Other software included is the Microsoft Word (not much to explain here), Sharepoint, which can serve as a centralised document management and collaboration platform used for storing documents and allowing others to have access to them or create project specific sites and it also includes OneDrive which is cloud based storage.

    Overall, Microsoft 365 can improve the workflow of a business by improving collaboration, communication, file sharing and flexibility. It is definitely a must have.

    • Custom apps or specific apps for the sector

    Beside the above list, construction sector can benefit from various bespoke/sector specific apps.

    There are numerous platforms on the market that the user can build mobile/web apps with no code or low code (non or very little coding where the user uses a visual interface to build the apps by drag-n-drop).

    The most known are:

    The downside of those solutions is that the learning curve is quite steep and the monthly/yearly cost to use the platforms might be too high. The benefits of course are huge as you can build an app, that is not on the marker, as you want and make it do exactly what would help your workflow.

    On the contrary you can always hire an agency to code an application with normal code and databases that will run on a server. This is an even more costly solution but at the end you can have your own 100% bespoke app that can even scale.

    Finally, there are a handful of construction software on the market that might fit any purpose. To mention a few: COINS: an all-in-one ERP+ system that connects teams, devices, and all business processes on a single platform, On-screen Takeoff: a software that offers tools for estimating, managing bids and having project visibility, Bluebeam: a software application that allows users to markup, takeoff, organize, and collaborate with PDF files.

    Verdict

    The potential benefits in terms of efficiency, cost savings, communication, and environmental impact are undeniable. The digital era is here, and the construction sector should grab the opportunity to digitalise procedures in order to become more efficient and flexible. The benefits of going digital are numerous and compelling.

  • Things are changing. Constantly

    Things are changing. Constantly

    It has been 40 years since the first major breakthrough in construction software. It was 1982 and AutoCAD was first released. 1982 marks the beginning of construction innovation and automation.

    In the last 40 years lots of things changed.

    AutoCAD was only the beginning. Since then, we have seen the rise of the BIM software, structural calculation packages for complex construction calculations, estimating and project tracking packages and many more. And of course, the one and only Microsoft Excel that changed everything in the way we manage data. By the way, the first Excel version released in 1985.

    Even though it’s been 40 years of constant innovation, there are some sectors in the building industry that things haven’t changed much. Fieldwork has not experienced the same level of technological transformation as office-based tasks. The physical nature of the task, as well as the delayed acceptance of technology on construction sites, might explain part of the industry’s resistance to change.

    Take as an example scaffolding. In the office the workflow has changed. There are numerous software packages that can do structural calculation, can design scaffolds or manage a whole project, but on the field, the work pretty much remains the same (excluding some tools that are now working with batteries for example).

    The rise of AI

    The last decade we have seen huge steps done towards AI and automation. Especially, the last 3 years many AI products have made it to the market. Take a look at ChatGPT (the known AI chat machine) , Bard (Google’s AI chat), Stable Diffusion or Midjourney (two major tools for AI images). They didn’t even exist 5 years ago (or at least we didn’t know they existed) and now thousands of people rely their jobs on those tools.

    How this affects the construction

    Due to the complexity of the construction projects, AI is not as much of a threat to the construction (all levels) as it is to the humanity (as a whole). But, unless AI robots start designing and building other, more advanced robots (compared to them), construction is (almost) safe.

    But, there are some products that might replace some tradesmens’ work. Take a look at this robotic builder for example.

    4 days to build a 3-bedroom house. Not bad at all for the owner (that multiplies the profit margins) or the buyer that will buy a house cheaper. Bad news for the bricklayers though. Or the sculpturers (take a look at this  robotic sculpturer ).

    Even worse are the news for the setting out engineers. HP (Hewlett Packard) robots are already replacing their job.

    Things will just change.

    Even though automation is going to replace lots of humans there will be a huge shift in employment and new roles will be created. For example, the above “bricklaying” robot will need someone to feed it with material, check the setting out, feed it with designs etc. And, who you think will build those machines. The general idea that the west world has automated most of their production is of course false. The production has shifted to Asia, and it is coming to Europe/USA again.

    Conclusion?

    We are living in a very interesting era. The era that the new replaces the old, rapidly. Technologically, geopolitically, financially, and generally in every sector there are changes and transformations happening that will shape the future, which is unknown at the moment.

    From the perspective of the construction industry, innovation never stopped. Especially now automation at work is taking over every field and we should embrace this change. These technology innovations not only offer opportunities for cost-effectiveness and enhance efficiency, but also provide unreached levels of precision, safety, and sustainability in the construction industry.

  • Don’t use VLOOKUP

    Don’t use VLOOKUP

    VLOOKUP is probably one of the mostly used Excel functions. It is used when the user needs to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

    Its usage is quite simple: =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]).

    • lookup_value is the value you are looking for in the table.
    • table_array is the range of cells that contains the table you are searching.
    • column_index_number is the column number of the value you want to return. The first column is 1, the second column is 2, and so on.
    • range_lookup is a Boolean value that tells Excel whether to do an exact match (TRUE) or an approximate match (FALSE). If you omit this argument, Excel will do an approximate match by default.

    Despite being one of the most used formulas in excel it is not wise to use it in big excel sheets that are required to produce prices, forecasts or do other serious calculations.

    The reason is simple. Referring a column without any other references leads to probles as we will see below.

    At the picture exaples let’s assume that we want to add a column next to column E and expand our table.

    What happens is that the reference still remains the 2nd column of the table which is now zero or might have other values that we would insert.

    The previous VLOOKUP formula matching will give us the below:

    That’s why it is recomended to use a more advanced combination like INDEX MATCH MATCH that it’s reference is tied to the header of the table and not by the column distance from the 1st column of the table we want to match.

    To find how INDEX MATCH MATCH works, alongside with other super userful excel formulas visit this page. It’s an absolute MUST KNOW!

  • Print PDFs (multiple) from Excel with a press of a button

    Print PDFs (multiple) from Excel with a press of a button

    On a previous article, dated 2 years ago, I explained how to automatically print to pdf a sheet, with a press of a button.

    This one is the part 2. It is a tutorial of “how to print multiple pdf files from populated tables” in excel, with the help of VBA.

    I wrote the code in 2018 and since then it has saved me (or the company I work for) a massive number of working hours (or weeks to be more precise).

    (more…)
  • Print to PDF from Excel Automatically

    vba-logo.pngYou are working in your highly automated super excel spread sheet that you have created. After all these months of additions and formulas, cell updates and tests you are there! You finally mad your spread sheet fully automated that produces alone cells, numbers, prices and data that would take days to calculate them manually.But…

    Something is missing… (more…)

  • Excel Commands to make your life easier

    excel logo.pngExcel.

    It’s a program that you can fall in love. I guess the average user, just knows 5-10 commands like sum, average, a little bit or customizing the look of the spread sheets and that’s all. The work is done and the representation is more than fine.

    But excel is way more than 5 commands and colored cells. (more…)