The first process I did Architectural Colour Schedule in Excel used VLookup() to lookup a table on a separate sheet, but it did not show you the choice of selections. This time I want to be able, when looking up a room finish, to see what the selections are, so that I can choose
The last post I tried to use AirTable to create a Colour Schedule from a Revit export. Thinking I could use the Database to cross reference items in the room such as doors/windows etc to be able to pull those in to make the colour scheme planning more comprehensive. It didn’t work. Along the way
Obvibase database with Google Sheets I was thinking about my expenses Form/Sheet process Spending Tracker that I’m very pleased with. A method to capture my spending. My concern is that the sheet will bloat over time with older records. I was surprised that one of my big sheets in Excel could not be opened in
Background I have written a post on showing internal building fabric condition over time in this article Revit Internal Condition over Time. I was not, at the time, happy with the presentation of the information as it was a series of screenshots that I then put in as slides to step through the process. Two
I thought I’d have a look at QGis again now that it has been updated. I’m always wow’d by what people can do with the GIS mapping. Unfortunately for me I’m an amateur playing in this area. I did a cartography course at Uni way back and enjoy exploring some mapping tools. As QGis and
I wrote a post on using Excel filterable Heatmaps for Asset Condition over time online. This was an excel file on my OneDrive that I then embedded in a web page. I had filtered the columns so that you could filter columns to do forecasting for building items that would need work to be done
Further to my previous post Google Sheets “GOOGLEFINANCE()” for free Stock data that started with referencing 5 things that Excel couldn’t do but Google Sheets can, I wanted to explore a few of the features mentioned in that video. It mentioned the following Google Sheet Functions: ImportFEED(), Import HTML() &ImportXML() 1. ImportFeed() Well, I followed
Further to my previous post on 12 Free Productivity Tools for Win 10 (initially 8 but I added some more) I have since found a few more free programmes that can help with productivity. RocketDock RocketDock is a task bar, but it looks a bit like the Apple Task Bar and can be configured in
Macro Tools Following on from Macro productivity tools using AlternativeTo I came across: SikuliX automates anything you see on the screen of your desktop computer running Windows, Mac or some Linux/Unix. It uses image recognition powered by OpenCV to identify and control GUI components. This is handy in cases when there is no easy access to
While at Wellington City Council working on Strategic Assets, one of the exercises of the Building Asset Team Leader, Tane Dunne, was to work out what the top major cost items were for the assets over a period of time, in this case 50 years. The assets were captured by the SPM survey team of
