วีดีโอ

I talked at the Heatons and Reddish Area Committee on the 28th of October. This was to raise our objections to the new bungalows on the Grafton Street Open Space. There was a recording. You can view that in full here: democracy.stockport.gov.uk/ieListDocuments.aspx?CId=134&MId=29515&Ver=4 Go to "Media" and view the webcast. It starts at 1:00:50. This is a pre-recording with some slides explaini...

The petition is described here: democracy.stockport.gov.uk/mgEPetitionDisplay.aspx?ID=154&RPID=65315448&HPID=65315448 Stockport's strategic open space assessment: www.stockport.gov.uk/evidence-planning-policy/open-space-sport-and-recreation

If clear, concise, and repeated rules are ignored, then what rules do protect open space? If you live in Stockport please consider signing the petition: democracy.stockport.gov.uk/mgEPetitionDisplay.aspx?ID=154&RPID=63821447&HPID=63821447

How to comment on the planning application online. I think the site only works properly on the Chrome or Edge browsers...

How to access the planning application online. The planning application is now live on the council website, ref. DC/090014. We will be delivering a letter to all residents in Grafton Street and the surrounding area starting tomorrow. This letter explains what to do if you want to comment on the planning application. The deadline for comments is Friday 2nd February, but the very important messag...

The audacious claim that home-grown gas has a quarter of the carbon footprint of imported LNG.

Excel has provided more functional programming tools for users in recent years. This video presents a use case for the functions, LET, MAP, and LAMBDA. They're used together with some of Excel's other built-in functions to convert a multi-line address into a single cell. It helps if you already know Excel's string manipulation functions: LEN and CONCAT. Error: I incorrectly refer to VBA at 27 s...

This Autolisp routine started out as a way of quickly and accurately performing "area take-offs" for SAP (the UK's building regulations' energy analysis). It has evolved since to become more of a general-purpose tool for listing lengths and areas in the drawing. Although the most recent development has taken place in BricsCad, the underlying code should be largely compatible with AutoCad.

Warm-front condensation occurs when a warm, humid front of weather meets a heavyweight structure.

ECAM from SBW consulting ( sbwconsulting.com/ecam/ ) is a great tool for energy profiling of facilities. It has some shortcomings: 1. Certain units, such as degrees Fahrenheit, are restricted to I-P. 2. It can't take input from Half-Hourly Loads (HHL) Let's fix the latter one at least!

AIDA is an algorithm for working out infiltration rates. It was originally authored by Martin Liddament in the 1980s using early BASIC. This video contains a demonstrator of the same algorithm implemented in Excel and written in object-oriented VBA. Re-writing the algorithm in the more contemporary medium of Excel will hopefully revive interest and even provide some education.

Using the clipboard to copy/ paste tabulated data in excel into autocad mtext objects. Uses basic string matching. With thanks to Lee-mac.com.