Author: Rob Attrell

  • 15-minute neighbourhoods and their benefits for prosperous healthy communities

    15-minute neighbourhoods are a concept of urban planning that aims to create compact, well-connected, and diverse communities where residents can access most of their daily or weekly needs within a short walk or bike ride from their homes. The idea is to reduce car dependency, promote active transportation, improve air quality, enhance social cohesion, and support local businesses. 15-minute neighbourhoods are also seen as a way to increase health resilience and adaptability in the face of challenges such as pandemics, climate change, and economic shocks.

    The term 15-minute neighbourhood was popularized by Carlos Moreno, a professor at the Sorbonne University in Paris, who advised the city’s mayor Anne Hidalgo on her plan to transform Paris into a “city of 15 minutes” ¹. Moreno’s vision is based on four pillars: proximity, diversity, density, and ubiquity. Proximity means that people can access essential services and amenities within a short distance from their homes. Diversity means that there is a mix of land uses, housing types, and activities in each neighbourhood. Density means that there is enough population and activity to support local businesses and public services. Ubiquity means that there is a network of public spaces and infrastructure that connects different neighbourhoods and enables mobility and accessibility for all.

    The benefits of 15-minute neighbourhoods are manifold. For residents, they offer convenience, choice, affordability, and quality of life. By reducing the need to travel long distances by car or public transit, they save time and money, lower stress levels, and increase physical activity. By providing a variety of options for living, working, shopping, learning, playing, and socializing within walking distance, they foster a sense of community, belonging, and identity. By enhancing the attractiveness and livability of each neighbourhood, they increase property values and economic opportunities.

    For the environment, 15-minute neighbourhoods contribute to reducing greenhouse gas emissions, improving air quality, and preserving natural resources. By encouraging walking and cycling as the main modes of transportation, they reduce the reliance on fossil fuels and the associated pollution and congestion. By promoting compact and efficient land use patterns, they limit urban sprawl and the loss of agricultural land and green spaces. By integrating nature-based solutions such as urban forests, gardens, parks, and green roofs, they enhance biodiversity, mitigate heat islands, and improve stormwater management.

    For society as a whole, 15-minute neighbourhoods support social equity, inclusion, and justice. By providing access to basic services and amenities for all residents regardless of their income, age, gender, ethnicity, or ability, they reduce social disparities and improve health outcomes. By creating opportunities for interaction and participation among diverse groups of people, they strengthen social capital and civic engagement. By fostering a culture of cooperation and solidarity among neighbours, they enhance social resilience and adaptability in times of crisis.

    In conclusion, 15-minute neighbourhoods are a promising concept of urban planning that can create prosperous healthy communities for the 21st century. They are not only a matter of physical design but also of social innovation. They require a collaborative approach among various stakeholders such as governments, planners, developers, businesses, civil society organizations, and residents. They also require a shift in mindset from thinking in terms of zones and sectors to thinking in terms of places and people.

    References:

    ¹: What are 15-Minute Cities? – Geography Realm
    (1) 15-minute neighbourhoods | The New Official Plan – Engage Ottawa. https://engage.ottawa.ca/the-new-official-plan/news_feed/15-minute-neighbourhoods.
    (2) What are 15-Minute Cities? – Geography Realm. https://www.geographyrealm.com/what-are-15-minute-cities/.
    (3) 7 Rules for Creating “15-Minute Neighborhoods” – Strong Towns. https://www.strongtowns.org/journal/2019/9/6/7-rules-for-creating-15-minute-neighborhoods.
    (4) What is a 15-minute neighbourhood? | Healthy streets – Smart Transport. https://www.smarttransport.org.uk/insight-and-policy/latest-insight-and-policy/what-is-a-15-minute-neighbourhood.

  • Building a Versatile Variables Container in Excel

    Building a Versatile Variables Container in Excel

    Microsoft 365 (and specifically Microsoft Excel) is my favourite tool when it comes to work, and also really fun to play with in my spare time as a ‘hobby’ that also helps me improve my skills.

    I’ve used probably dozens of different methods of storing ‘sets’ of variables for the tools and mini programs I’ve created in Excel over the years, some very rudimentary, and others more involved but also difficult to maintain or fragile in various ways.

    However, recently while playing around with Power Query and Excel formulas (yes, I do this when I let my mind wander), I came across an idea for a robust variables container stored in an Excel table that can be accessed in several different ways throughout a given tool. You can access or refer to these variables using good old Excel functions (with a LAMBDA, or a UDF if you’re old school), with a simple Power Query function call, or a few lines of VBA in your editor (see the UDF), depending on the needs of your project.

    Getting Started

    Let’s go through the basics of the project’s needs first:

    First, create a basic table called Variables with a set of Name-Value pairs.

    This table will contain all the variables we want to reuse across different places in the tool or want to be user-configurable later on.

    1. The LAMBDA function

    First, we can create the LAMBDA function (if you use Excel 365, which I highly recommend!), by putting the following function in the Name Manager (I used the name getVariable for these functions, and variableName for the name of the variable):

    =LAMBDA(variableName, XLOOKUP(variableName, Variables[Name], Variables[Value], "No matching variable.", 0))

    Using this function elsewhere in the workbook, we get, just like we want:

    2. The Power Query function

    Next up, we will create a Power Query function to be able to refer to a variable from this table and get back the value for it.

    Launching the Power Query Editor (from the Data tab), I will create a function called getVariable (again), and include the following:

    (variableName) =>
    let
        Source = Excel.CurrentWorkbook(){[Name="Variables"]}[Content],
        #"Transposed Table" = Table.Transpose(Source),
        #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
        Result = Record.Field(#"Promoted Headers"{0}, variableName)
    in
        Result

    Note that I’m still using variableName for the variable here, and this allows you to invoke the function and get the expected result back if we want to refer to this variable in another function:

    3. The VBA function

    Finally, we can create a quick function in VBA that allows you to use these same variables across your project, making it fast and easy to maintain your code however you have it set up.

    Open the VBA editor, and in a new (or existing) module, I’ll write the getVariable (again!) function:

    Function getVariable(variableName As String)
    
    Dim VariablesTable As ListObject
    
    Set VariablesTable = Main.ListObjects("Variables")
    
    getVariable = WorksheetFunction.XLookup(variableName, VariablesTable.ListColumns(1).DataBodyRange,  VariablesTable.ListColumns(2).DataBodyRange, "No matching variable.", 0)
    
    End Function

    With this function, you can easily get any variable from your table anytime you need it, and you’ll be able to change the parameters in your code without digging in to the developer tools.

    Well, that’s it. With this simple, basic Excel table and three short code snippets, you’re ready to tackle nearly any Excel project imaginable while keeping your data in check and making sure you don’t leave hard-coded values anywhere in your Excel tools.

  • Wow, Flying a Kite is More Fun Than I Remember!

    Wow, Flying a Kite is More Fun Than I Remember!

    Today is the end of the 3rd week of my 5 weeks of parental leave from work. We’ve done lots of fun things as a family, but honestly today was one of the highlights so far! I can’t remember the last time I flew a kite but I’m sure it’s been literal decades.

    The feeling of getting the kite up in the air and keeping it there is very satisfying, and then being able to hand it off to your daughter and have her take control is a Big Dad moment. 10/10 would recommend.

  • You should be able to use TMs during Pokemon Go Community Days

    I have never posted about Pokemon Go on here before, and it’s possible once I start, I’ll just never stop.

    However, what happened this morning hits in just the right way to scratch all my itches, and that’s what this website is about. I posted the following on Reddit last night, and for reasons I don’t fully understand, it was removed this morning by the mods.

    This is part of a bigger thing I always think about, where I don’t understand how the cultural nuances of Reddit got to where they are. So rather than complain about cancel culture or how I’m being attacked in an echo chamber, I’m just going to re-express my point here. Free speech!

    If you don’t care about Pokemon Go, by all means you don’t have to keep reading.

    I realize Niantic wants to sell elite TMs, which is why they haven’t put anything like this in motion, but with PvP now being a big priority, you can officially buy access to moves like icy wind on dewgong, or psystrike on Mewtwo.

    With CD move TM windows, none of those uses change. Especially with something like a magikarp community day, where up until March nobody could have thought we would ever see this, people have great maxed out, powered up, best friend pokemon. These now either get replaced by new pokemon with a CD move, or people have to spend valuable elite TMs on something easily ‘replaceable’ to get extremely meta relevant moves.

    For example, I have a 100% Gyarados that’s currently maxed out as of S1 of GBL, but it’s now much less valuable than my 93% Aqua Tail Gyarados from today for PvP, unless I use my one and only elite TM (and because I only get one of these per season of GBL, I’m realistically effectively never using it).

    Even if using a TM during this window required candy and/or stardust (somehow) it would still let the pokemon we already have be usable down the road (like what happens every December so far).

    All of this to say, in an effort to increase fairness, especially in GBL, I don’t think it really takes anything away from the game (at this point) to let people use CD evolution windows to also TM those moves.

    r/TheSilphRoad Post
  • COVID Alert is now publicly available! [Links]

    You can download the COVID Alert exposure notification app in Canada now! It’s available on the iOS App Store as well as the Google Play Store.

    See more details of how it works and what it looks like in my older post when I started using the beta:

  • Here’s What Canada’s ‘COVID Alert’ app (beta) Looks Like

    Here’s What Canada’s ‘COVID Alert’ app (beta) Looks Like

    [UPDATE – July 31]: The app is now publicly available. Go get it!

    On Wednesday, Health Canada finally released a beta (test) version of the Canadian ‘COVID Alert’ exposure notification app.

    I have been waiting for a couple of months to finally be able to get this set up once Apple and Google announced they would be building exposure notifications in to their operating systems, and it’s finally here (if you are willing to jump through some hoops and help test it out).

    Let’s take a look!

    When you first launch the app, you’re given a bunch of info right off the top. You’ll also have to accept exchanging exposure tokens with other phones, as well as receipt of exposure notifications, and then standard iOS app notifications as well. Here’s what the setup screens look like:

    Once you’ve got everything activated, there’s not a whole lot to do besides look at the menus and edit your information.

    I was informed via email they will be testing what an ‘exposure’ looks like in the app over the next 2-4 days, so if that happens, I will definitely share that information!

    There’s not much to the app to be honest (which is a good thing), but there is a little more information to go over.

    In the meantime, here’s some information provided under ‘How it works’:

    These exposure notification apps (one per country, by rule) are meant to be for public health reasons only, so they’re very minimal, and outside of use in conjunction with your doctor, you won’t really notice it on your phone.

    The only information the app collects and is able to use is a set of randomly generated ‘codes’ from the phones of others you interact with, and your phone sends out a similar set of ‘codes’ to people around you. No private information is stored or sent anywhere, like location or your personal details.

    If you test positive, your doctor will give you a one-time use code which you enter in to the app, and this (if you choose to do it) will notify anybody else who has the app that you were nearby them and may have exposed them to the virus, because their phone has stored your ‘code’ from while you were near each other.

    It’s a pretty incredible, secure system, and I’m really eager to have it see wide use in Canada and around the world, on Android and on iOS, over the coming months and possibly years.

    When I hear more about the public release, I will post updates here!

  • 3 Things: WFH Edition

    Obviously, I would pick:

    • Fast internet
    • Multiple monitors
    • Good chair
  • Happy 2nd Birthday Evie! 🥳🎉🎂

    Happy 2nd Birthday Evie! 🥳🎉🎂

    Today is Evie’s 2nd birthday. In case there were any doubts she’s my daughter, check out this picture!

    We had such a good time celebrating her birthday today (and getting out on the bike), and Julia made a delicious pink cake that was so good!

  • Let’s walk through the opening sequence from Austin Powers 3

    Since we’re all spending some more time than usual twiddling our thumbs right now, it’s a good time to check out some light-hearted, relatively short YouTube videos.

    For today, here’s the director of Austin Powers 3: Goldmember, describing the process, reasoning, and storyboarding of the long, really fun opening sequence of Goldmember. Check it out!