Bjorn Meijer

Bjorn Meijer

At My Playground

  • Home
  • About me
  • Wiki
  • Useful
    • 4-20mA calculator
    • ASCII table
    • Translations Excel functions EN-NL
    • Excel keyboard shortcuts
  • Trainings
    • Topography
  • Contact
  • Language
    • en_USEnglish
    • nl_NLNederlands
    • de_DEDeutsch
How does the VI editor work?

How does the VI editor work?

General Home assistant
Door Bjorn Meijer December 13, 2022 1

The VI editor is a handy tool and comes standard in almost all Linux distributions. It also comes standard… Lees verder

Modify Configuration.yaml via Home assistant Supervisor CLI

Modify Configuration.yaml via Home assistant Supervisor CLI

Home assistant
Door Bjorn Meijer December 7, 2022 0

It can happen to you (I succeeded too ;-)), you have adjusted a setting (for example the port) in the… Lees verder

Using Quick Fill in Excel

Using Quick Fill in Excel

Excel
Door Bjorn Meijer November 30, 2022 0

Since Excel 2013, Microsoft has added a new useful feature, QuickFill. As soon as Excel recognizes a pattern, the… Lees verder

Does a date fall on a weekend in Power BI

Does a date fall on a weekend in Power BI

Power BI
Door Bjorn Meijer November 17, 2022 0

Sometimes it can be useful to know whether a certain date falls on a weekend or not. It's possible… Lees verder

Highlight selected row in Excel

Highlight selected row in Excel

Excel Excel formulas VBA
Door Bjorn Meijer Nov 10, 2022 2

Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color… Lees verder

Does a date fall on a weekend?

Does a date fall on a weekend?

Excel Excel formulas
Door Bjorn Meijer 28 Oct 2022 0

In this article I explain how you can find out based on a date whether it is in… Lees verder

Convert JSON array to table in Power BI

Convert JSON array to table in Power BI

JSON Power BI
Door Bjorn Meijer 26 Oct 2022 0

Suppose you have a JSON file that looks like this and you want to import it as a table into Power BI: This… Lees verder

The best housing for the Raspberry Pi

The best housing for the Raspberry Pi

General
Door Bjorn Meijer 20 Oct 2022 0

The best way to protect your Raspberry Pi is to mount it in a case. Just like the… Lees verder

Keyboard shortcuts for filters in Excel

Keyboard shortcuts for filters in Excel

Excel
Door Bjorn Meijer 15 Oct 2022 0

Microsoft Excel is ideal for performing operations on large amounts of data. One of the useful features within Microsoft… Lees verder

Add Shelly 1PM WiFi switch in Domoticz

Add Shelly 1PM WiFi switch in Domoticz

domoticz
Door Bjorn Meijer March 30, 2022 0

The Shelly 1PM is a compact switch that you can not only use as a switch, but also to… Lees verder

Berichtnavigatie

1 2 3 Next

Categories

  • General (3)
  • domoticz (6)
  • Excel (15)
    • Excel formulas (6)
    • JSON (2)
    • VBA (3)
  • Home assistant (2)
  • Power BI (2)

Recent messages

  • How does the VI editor work?
  • Modify Configuration.yaml via Home assistant Supervisor CLI
  • Using Quick Fill in Excel
  • Does a date fall on a weekend in Power BI
  • Highlight selected row in Excel

© Copyright 2020 bjorn-meijer