-
Power Query SumIF
Yesterday I wrote about how to calculate a running total (cumulative total) using Power Query. This used List.FirstN and the Index to select the elements to sum. A similar challenge is calculating a sum based on conditions (SUMIF) if the condition is Index <= current value then this degenerates to the Running Total case. The…
-
Creating running totals in Power Query
Power Query brings the power of ETL (extract, transform and load) tools to Excel. Almost every job I have now starts with using Power Query to clean and filter the data I am using. But cleaning and filtering is only the most basic of Power Query’s functionality. It can also be used to calculate custom…
-
How Orwellian
The premise of George Orwell’s 1984 was that history was continually rewritten to meet the needs of the current elite. How delicious is the irony that the author of a Orwell Prize winning book is to be compelled to rewrite it. https://www.bbc.co.uk/news/entertainment-arts-58151144
-
Fixed: Microsoft Teams Meeting button missing in Outlook Desktop
My daughter’s lap is 5 years old and started misbehaving. I advised her to “reset” it and do a clean install of all the applications that she uses. After installing Microsoft Teams and then Microsoft Office the “Microsoft Teams Meeting” button was missing in the Outlook Desktop application. On inspection of Outlook I found that…
-
The London Mayor’s Solar Together “Scam”
Solar Together is a group buying project that helps householders purchase solar panels for their roofs. It is actually a very sensible scheme and well executed. Householders can be confident that they will get a good price and that their house will not burn down due to shoddy work. So why do I say it…
-
Android users – you must use an SMS backup app
As a CTO and system admin I know that the three most important tasks are, Make sure that backups are running Make sure that restores are working Don’t forget 1. Therefore I was more than a little surprised to find that when I restored my Android phone the text messages were missing. It seems that…
-
This board game was played for 2000 years
One of the most interesting aspects of this game is the use of 4 tetrahedral “dice”. Unlike knucklebones that were used for gaming by the Romans and others, tetrahedrons are not easily found in nature and I think they would have had to been manufactured perhaps with some difficulty. My first idea was that since…
-
Oyster costs: commuting into London during COVID
My wife is a key worker and has to commute into London everyday. She wants to avoid the tube and walk if possible. We have just spent several hours trying to understand the costs of Oyster etc. In conclusion. The Oyster smartcard supports a Pay As You Go service with daily and weekly (only on…
-
When was the last time you checked your account recovery information?
(Header image credit: https://wiredsmart.io/) My phone died today. This is really bad because like most people in IT and crypto I use it a lot for 2 factor authentication. I am now in the process of restoring my phone and getting access to my accounts. This process is anxiety inducing but because I have good…
Dr James Bayley
Creating successful projects
Dr James Bayley 