Fun stuff with Obsidian and Dataview II - costs per week

You can do so much fun stuff with Obsidian and Dataview. I added notes for all of my electronic gear and based on properties for purchase date and price an inline dataview calculates the costs per week for each item, every time the note is opened ๐Ÿคฉ

This is the actual inline calculation for cost/week:

=round(number(replace(this.preis,",",".")) / number(durationformat(dur(date(now) - this.kaufdatum),"w")),2)

with

  • preis: price property; as I am located in GER I use a textfield with an entry like “42,99 โ‚ฌ”; therefore the replacement of “,” by “.” and conversion to a number
  • kaufdatum: purchase date property
Obsidian dataview with costs per week based on purchase date and price

Update 2023-12-05

Here is a slightly improved version of the inline field:

=replace(string(round(number(replace(this.preis,",",".")) / number(durationformat(dur(default(this.nutzung_bis, date(now)) - this.kaufdatum),"w")),2)),".",",")

with

  • nutzung_bis: a properties date field that marks the end of usage; the cost is calculated either until this date or if it is missing until today

and it changes the ENG decimal point back to the GER “,”

Fun stuff with Obsidian and Dataview - pico-8 game launcher

You can do so much fun stuff with Obsidian and Dataview. I added notes for all my pico-8 games, containing the cartridge png itself and added some Templater and Properties magic. With the help of Keyboard Maestro I can now click on the little play button in my Dataview table and the game just launches ๐Ÿคฉ

pico-8 games list in Obsidian with built-in launcher

Winter is coming

dog on field covered with snow

What caught my attention in week fourty-seven, 2023

Adam told me to stay on the path, so I’m trying to motivate myself to get back into the habit of writing down what has interested me throughout the week. So, here comes week 47.

  • ๐ŸŽฎ I finished playing Horizon Forbidden West. It was my first computer game in years, and probably the first AAA title in decades that I actually watched the end credits for. Usually, I start playing and then eventually stop. (Why should it be any different with video games than with other areas of my life?) I invested over 100 hours into Forbidden West, and whether or not that was a waste of time is for each person to decide, but I had a lot of fun. Over the past two weeks, I used the Playstation Portal. This accessory for the PS5 is essentially just a (pretty good, but unfortunately not OLED) screen with a built-in, very good controller - nothing more and nothing less. It allows me to play on the couch in the living room while my wife watches one of her shows. (My wife doesn’t like me playing games on the TV in the living room when she’s present.) The Portal suffers from the same weaknesses as Playstation’s Remote Play itself: even with very good Wi-Fi coverage and the PS5 connected to the router with a cable (and properly configured), there are regular artifacts, slow downs, and sometimes even stuttering. I really hope that Sony gives its Remote Play implementation a little bit more attention and love now that they sell a dedicated device for this feature. But ultimately, I’m quite satisfied, and the hardware is really well-made. (The lack of Bluetooth support doesn’t bother me at all; I wouldn’t want to constantly pair BT headphones anyway, and I actually have some very good headphones with a headphone jack that are happy to have found a new use.)

  • ๐Ÿ‘พ Recently, my Powkiddy RGB30 also arrived. The handheld device was highly praised by a bunch of youtubers and the 1:1 screen is really great for GB, GBA, and GBC games. I also really like JELOS. HOWEVER, the hardware quality and customer service of this device and this company are extremely poor. The device arrived defective, with a stuck shoulder button. I had to contact Powkiddy multiple times to get a response. They casually suggested that I could try opening it up. Opening up a device that is only a few days old, still under warranty, with a spatula and screwdriver is not exactly what I had in mind. I actually managed to open the case and free the button without causing major damage to the device. Shortly after, another shoulder button got stuck, and then the first one again. And if that wasn’t enough, the card slot eject mechanism also broke. All within one week. I really don’t feel like having to dismantle the device every two days just to play a game for a few minutes. Powkiddy mentioned that I could send the device back to China at my own expense and then get a refund - yeah, right. Never ever again! ๐Ÿ˜ก

  • ๐Ÿ‘พ Speaking of retro gaming, while setting up the RGB30, I stumbled upon the pico-8 Fantasy Console and was immediately impressed. I wasn’t aware of the extent of this community. There are so many nice games, and almost all of them are free. You can play them on macOS, a variety of other operating systems, and even on retro handhelds. And as if that weren’t enough, there’s also the TIC-80. Oh boy!

  • ๐Ÿ–ฅ๏ธ During the Black Week, or whatever this discount rally is called, I made my way through the impressive list of over 400 apps for macOS and iOS in the Indie App Sales 2023. Fortunately, I already own the ones that interest me most and “only” bought three additional small apps this year:

  • Nevertheless, itโ€™s an impressive list that also includes many Mastodon developer accounts that I didnโ€™t know about before. Definitely worth looking into.

  • ๐Ÿ–ฅ๏ธ I also noticedย the Appsย campaign: 10 applications for you and your Mac. It really only lists great apps. And even though I useย Moom, I’ve bought a single Mac license of Lasso and both play quite nicely together.

  • โŒจ๏ธ Launchbar, the launcher I’ve been using on macOS for almost 10 years, recently had noticeable delays when launching. It was impressive how my muscle memory was trained to expect to be able to perform actions immediately after pressing cmd+space. It was so bad, I took a look at Alfred and Raycast again, but thanks to the nightly build Version 6.18.5 nightly (6247), everything is back to how I’m used to it ๐Ÿ˜…

  • ๐Ÿ˜ Oh, and definitely not to be left unmentioned is this insanely awesome App Defaults movement that Robb unintentionally kicked off and wonderfully shows off.

  • ๐Ÿ‘– Furthermore, I enjoyed “the walkthrough explaining the inner workings of the ship that made the kessel run in less than 12 parsecs”, saved ASCIIFlow in my bookmarks, and pants whose pockets may not be worn out by the phone after a few months.

Indie App Sales 2023

It feels like every day for weeks now is a special day and everything is and will be discounted. Oh, wouldn’t life be nice if things were just generally cheaper and my inbox was spared the flood of advertising? Anyway …

There’s another Indie App Sale this year and there are now over 400 (!) programs listed for macOS and iOS. Fortunately, I already own the ones that interest me most and bought three additional apps this year:

Nevertheless, it’s an impressive list that also includes many Mastodon developer accounts that I didn’t know about before. Definitely worth looking into.

I also noticed the Apps campaign: 10 applications for you and your Mac. It really only lists great apps. And even though I use Moom, I’ve been dancing around Lasso for a long time, maybe I’ll buy it this time?

App Defaults

Shamelessly stolen from Robb ย and inspired by Hemispheric Views 097 - Duel of the Defaults!ย here are all the apps I use in the various categories as written by Andrew:

  • Mail Client: Mail.app
  • Mail Server: iCloud with custom domain and posteo.net
  • Notes: Obsidian and some stuff left in Notes
  • To-Do: Reminders (and Things at work)
  • iPhone Photo Shooting: iOS Camera
  • Photo Management: Photos
  • Calendar: Calendar
  • Cloud file storage: iCloud Drive
  • RSS: Reeder
  • Contacts: Contacts
  • Browser: Safari
  • Chat: iMessage, Threema, WhatsApp
  • Bookmarks:ย Anybox
  • Read It Later: Readwise Reader
  • Word Processing: Pages (MS Word at work)
  • Spreadsheets: Numbers (MS Excel at work)
  • Presentations: Keynote
  • Shopping Lists: Pons
  • Meal Planning: Mela
  • Budgeting & Personal Finance: YNAB
  • News: Mastodon, tagesschau.de
  • Music: Apple Music
  • Podcasts: Overcast
  • Password Management: 1Password

MS Office Reset

TIL that you can easily uninstall your entire MS Office package under #macOS with Office Reset (https://office-reset.com/), then download only the app(s) you need from the Mac Appstore and use your existing Office 365 subscription. I always thought you had to purchase a new one somehow via Apple IAP. Cool, now I’m rid of all that garbage MS AutoUpdater.

Here are a few things that caught my attention in week 37.

Teaser: and not much again ๐Ÿคทโ€โ™‚๏ธ

#weeknotes

Road with car driving towards sunset with bike lane next to it.

Here are a few things that caught my attention in week 36: week.esamecar.net/36

Teaser: not so much ๐Ÿคทโ€โ™‚๏ธ

#weeknotes

Hot air balloon that just landed on a field.

Here are a few things that caught my attention in week 35: week.esamecar.net/35

Teaser: iOS and macOS stuff

#weeknotes

[Old gas station in Bonn, Germany, no longer operated as such.

Here are a few things that caught my attention in week 32 - 34: week.esamecar.net/34

Teaser: Family vacation, lots of RetroGaming, a little Obsidian, iOS and macOS stuff, one movie and a little TV.

#weeknotes

A very, very nice old road bike in front of a brick wall.

How to use kagi search within Launchbar

There is a kagi help document for Alfred and another one for Search Templates in Launchbar I used as a reference. It’s really easy to set up:

  1. In your Browser
    1. go to kagi.com / Settings / Account
    2. copy your Session Link
  2. Invoke Launchbar
    1. select Menu bar / Index / Show Index
    2. in Launchbar index go to Web / My Search Templates 1 -> add a new one
    3. paste your Session Link into the Template URL field
    4. append &q=%s
  3. done

  1. on my system it’s in German, but you’ll figure it out ↩︎

Okay, until just now I thought my 3D printer was just such a useless thing. But far from it - look what you can do with it! ๐Ÿชฟ๐Ÿ˜

3d printed goose - reminiscent of Untitled Goose Game from Panic
A camera lies on a table in the restaurant with a half-drunk wheat beer glass next to it.

Let’s have some fun ๐Ÿ˜…

Free Fall Tower in Hansa Park, Germany

VW Bulli T1

Front of a yellow VW Bulli T1 with "Dunlop Reifen" written on it.
Brick wall of house with mailbox slot and door taped shut

Finished reading: Nutzen Sie Ihr zweites Gehirn by Tiago Forte ๐Ÿ“š

I finally found the answer ๐Ÿ™‚

Draft widget on iOS lockscreen stating 42 drafts in the inbox.

Our dog relaxes on the train ride towards the holiday.

Dog relaxes on train's floor.