Links for March 2021
Solar System Cartogram
Might need revisiting when we get a submarine into Enceladus.
Solar System Cartogram
Might need revisiting when we get a submarine into Enceladus.
I deep faked myself! Using that MyHeritage deep nostalgia thing. I'm not convinced.
This animation shows a year of tides in San Francisco with the sun and moon:
I was inspired to create this after adding a tide forecast to a personal weather dashboard I have running on an old Surface Pro. I realized I didn't understand tides that much. I still don't, but I know more than I did before.
The animation illustrates four components of the tide. The obvious ones are the position of the sun and moon. When the moon is new or full the Earth, sun and moon are all lined up leading to larger 'spring' tides, which happen twice a month just like spring doesn't. As the moon waxes or wanes and becomes half full the moon and sun are at right angles and partially cancel each other out resulting in lower highs and higher lows. This is the neap tide, almost as unhelpful as 'spring'.
As orbits are not circles the Earth is closer or further away from the sun over the course of a year and the moon behaves the same way. When it's close than usual we get super moons and king tides (finally a type of tide that does what it sounds like). In the animation the sun and moon actually grow and shrink in proportion to their distance from Earth.
Here's how to read the animation. The date and time at the bottom of the screen refers to the tide right in the middle. The full screen shows the forecast running from 12 hours before the current time to 12 hours later. The vertical range is from -4 feet to 10 feet, relative to mean lower low water (MLLW), the average lowest tide over 19 years. The sun and moon are on a different scale - 360 degrees horizontally and 90 degrees vertically.
The tide forecast is pulled from the NOAA Tides and Currents API. I used SunCalc-Net for the position of the sun and moon, and the phase of and distance to the moon. For the distance to the sun I used a formula I found on StackExchange.
I wanted to both fit in a full year and run slowly enough to see what's going on each month so the video is around 20 minutes long. I won't be offended if you don't finish it.
It's been a while since I put out a newsletter after a fairly quiet end to last year. Here are some recent highlights.
How to Save a Planet (with an Infiniti QX55)
Lock up the Flexible Spending Account Administrators
Software: Catfood Earth 4.10 updates to the latest National Weather Service "API" and also 2021a timezones. Photo Sorter 1.10 helps control the scourge of duplicate JPEGs.
Timelapse: Sunset #6, what would happen if you used a style transfer neural network on every frame of a timelapse? This (instructions).
Hikes: Abrigo Valley, Grabtown Gulch and Mariposa Loop.
I'm not sure why during the pandemic I've used way more electricity but the same amount of gas.
Some thoughts on the results of the election, written before the Capitol riot.
Previously:
I've been meaning to check out the new Gimlet/Spotify podcast, How to Save a Planet, and finally listened to the first episode about wind power last week.
It was sponsored by the Infiniti QX55.
This is not even a hybrid. It's a 268 horsepower SUV. Consumer Reports says:
"The company cited 26 mpg combined (city and highway) when the QX50 was introduced for 2019. We measured just 22 mpg overall in our tests, putting it on par with larger, more powerful SUVs. And it required premium fuel. Subsequently, the official EPA estimate was downgraded to 25 mpg."
It's not even a particularly efficient SUV. You are really unlikely to be saving a planet this way. I'm not sure I can bear to find out who sponsors the second episode. I'm imagining a subscription panda steak service or bitcoin.
I shouldn't throw stones. I bought into a Volkswagen clean diesel (which came with a green tax credit before they got busted). I currently drive a Land Rover that can only hit it's claimed mpg if the engine stop technology is working. That only happens for about twelve miles after it has been serviced, which feels like the same sort of scam as the Volkswagen frankly.
Or maybe the clue is in the indefinite article and they read my post about extreme environmentalism.
I have just spent hours unfucking my FSA.
My dentist overcharged the FSA debit card by $2.10 due to some mix up between expected and actual insurance payment. Which would have sorted itself out on the next visit, but apparently it's an FSA emergency which needs paperwork now!
There are at least 28 million of these types of FSA/HSA accounts in the US.
Life expectancy at birth has fallen to 681,995 hours. So assuming that on average each account generates two hours of needless admin per year this is the equivalent of killing 68 people.
FSA administrators who won't chill and let the $2.10 go are killing us at a comparable rate to serial killers.
Serial killers are pretty terrifying and justifiably get a lot of TV shows and FBI task forces aimed at them. But we'd save as many lives by giving FSA administrators 25 years to life every time they decide to reconcile to the last cent. And we should be watching Law & Order: FSA where the detectives drink to conceal the pain of uploading a PDF and explaining your situation in 500 characters or less.
Or we could save the time and money and lives and implement single payer healthcare.
For no good reason I downloaded my gas and electricity consumption data by day for the last couple of years.
The electricity trend is unsurprising. At the start of the pandemic it jumps up and stays up. With work and school from home we're running four computers non-stop, burning lights and (the horror) printing things. Overall we used 24% more electricity in 2020.
Gas on the other hand is pretty flat. There are some different peaks at the start and end of the year, but our total gas consumption increased by 0.08%. This doesn't make any sense to me. Being at home doesn't make much of a difference to laundry but it should have had a big impact on everything else. The heating has been on way more, we're cooking breakfasts and lunches that would have occurred out of the house in 2019 and we must be using more hot water as well.
There is one strange difference between how electricity and gas are metered. Fractional kWh are distributed randomly between .00 and .99 as you'd expect. Fractional therms are totally different - we're apparently likely to use 1.02 or 2.03 therms but never 1.50. This feels like it must be some sort of rounding or other billing oddness but I can't find any reasonable explanation despite asking Google three different ways.
In a move that I might come to bitterly regret I have emailed PG&E to see if they can explain it. I'll update this post if I hear back. Or if you're a therm metering expert please leave a comment!
Updated 2021-02-20 13:51:
PG&E say:
"Thank you for contacting our Customer Service Center. Gas usage is registered by recording therms usage. If you view your daily usage online, you will see that therms are only registered in whole units. The only pace that you will see therms not as whole units is when you review the average daily usage. The pandemic started in March 2020 and since then your gas usage is up slightly versus previous years. Most customers will see a larger increase in electric usage versus gas usage when staying home more than normal. The majority of customers set the tempatures of the their heaters to very similar temperatures year over year and your heater will work to keep your house at the temperature whether you are home or not at home."
So the fractional therms are some sort of odd rounding on the downloaded data. Fair enough.
The majority of customers use the same temperature setting? Really? So that might be a good explanation if you constantly heat your house to the same temperature, but I know for sure that isn't us. We have a Nest Learning Thermostat and as I've previously reported this doesn't so much learn as just constantly turn the heating off. So staying warm is a constant battle with the thing.
Maybe the difference is that the pandemic started around Spring when San Francisco is warm enough to not need much heating. I'll look again when I can just compare winter vs winter in a couple of months.
Minutes spent so far this year waiting for Excel to talk to a printer: about 290.
Lifetime Excel print jobs: maybe 2?
How to fix Accessing Printer Press ESC to cancel:
The only real disadvantage is you'll need to select a different printer when you actually need to print anything (which you probably don't).
Endorsements: Biden, California Propositions, San Francisco Ballot Measures.
What is up with Android 11?
Hikes: Coastal/Julian loop in the Marin Headlands, Richards Fire Loop in San Mateo (with Hyperlapse!), the end of coronavirus (hikes).
Previously:
I migrated from Nest to Google Home today to save a few bucks and while eventually inevitable it was a really dumb move.
The first thing is that it doesn't work with your Google Workspace / G Suite account because of course it doesn't. So you need an unpaid Google account to move to. Luckily I already have one from that time that G Suite didn't support Google Fi. Interestingly while Google Home won't work with your paid account it has no problem reaching over to grab credit card information from it.
The next thing is goodbye Works with Nest, hello Works with Hey Google. So there goes my IFTTT integration. Because I can't use my main Google account it's kind of useless to me that this might work with Google Assistant. There is still Alexa integration though so I can play my Nest stream on the Echo Show once a year or so as a connected home party trick.
Having not read the changed terms of service I downloaded the Google Home app which a few minutes in I've take to calling Google Nope.
Nest Protect is not supported! This is my favorite smart home device just because when the battery runs out it can tell you which one to change. It's worth almost any amount of money to not spend several hours figuring out where in the house the omnidirectional smoke detector chirp is coming from. But for some reason Google Home doesn't integrate with Google Nest Protect so you need to keep the Nest app as well. Understandable, they only have several tens of thousands of engineers.
So they nailed the camera experience at least, right? Nope. In Nest there are about a hundred settings to play with. In Google Home you can change the name of the camera. In Nest you can scroll through all of your recorded history. In Google Home, despite specifically paying for the plan with 10 days of history you can't. It has a pre-Alpha feel to it. Good for a 'hey, we got the skeleton of an app thrown together' kind of internal demo but it feels like they probably should have added the things you've paid for before shipping it to anyone, let alone bribing them to go through a feature shredding 'migration' process.
My smart home ambitions are not that great. I had a nice little setup that switched some lights on and off around dawn and dusk, but Philips end-of-lifed the bridge and I'm not about to buy a new one. I had some fun making dropcam timelapses but Google broke the public cam URL. And thank goodness I didn't get the alarm system.
Lesson (eventually) learned. The only new smart home devices I'll install are the ones that I build myself.
Export Google Fit Daily Steps, Weight and Distance to a Google Sheet
Accessing Printer Press ESC to cancel
Is it safe to open securedoc.html (Cisco Registered Envelope)?
Migrating a C# Integration from GA3 to GA4
Upgrading from word2vec to OpenAI
User scoped custom dimensions in Google Analytics 4 using gtag
Monitor page index status with Google Sheets, Apps Script and the Google Search Console API
Reading and Writing Office 365 Excel from a Console app using the Microsoft.Graph C# Client API
Sending email via GMail in C#/.NET using SmtpClient
Enable GZIP compression for Amazon S3 hosted website in CloudFront
ITHCWY Newsletter for May 2023
10 Electoral College Votes Closer
Give your stupid niche kids app a useful name please!
Shipping a website in a day with Generative AI
3D Printing a Window Mount for a Google Nest Indoor Wired Gen 2 Camera