Category: Excel, Power BI & Google Sheets

Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately

After the Art Gallery App Free GlideApp for developing Art Gallery translation mobile app I wanted to extend it to a Museum app. As it does not take too much time to mock up an app I thought a specific app targeted at a specific Museum would capture more attention than if you were to

Further to HopOnHopOff (HOHO) for bus tour I could see that this idea could be extended to other instances like Museums, Art Galleries and events. A way of extending the information about a specific subject by translating it into different languages, thereby allowing people to engage more with the subject at hand. So, my initial

Following on from the HopOnHopOff tourist translation app that I developed and discussed in an earlier post, I wanted to extend the features in the app to suit specific needs. I decided to explore a Defects List app for a building site. Defect lists are common, both during and at the end of contracts. Near,

After the first test of the Glide app I found there was limited ways to input data. You had to edit a sheet tab of data but no method of automatically tagging that an item had been updated. That is, that I have identified so far. Video clip showing quick demousing Recordit The documentation and

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 an

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

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

AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys). AutoIt is also very small, self-contained and