Under the hood its mostly tables and reports, so ultimately not much, if you were dedicated enough to using Excel to rebuild GnuCash's views. It's more streamlined than excel would be because you won't have to worry about implementation, overhead of adding a new account, etc. Some things like auto-recommending accounts during import (and import itself) could be arduous in excel if not supported natively. Split transactions could be a headache (think your paycheck, which might be split into 401k contributions, several taxes, money into your bank, etc).
But fully recreating it in excel when it already exists would be a headache. More than likely you will have a more limited view in Excel if you're just creating a handful of tables to represent all of your many accounts.
I use GnuCash. I typically update every couple weeks up to a month. Beyond that it can be hard to remember what specific transactions were.
It's double ledger and I really like that it forces strict accounting. That sounds cumbersome but once you're set up (it may take some trial and error), for me my workflow is essentially:
Copy prior paycheck splits & update them to reflect new paychecks.
export QFX files from credit cards
import QFX, check / set transaction accounts
any small manual updates (interest payments in accounts, etc)
It's not automated but my data always remains local, and I can use the Linux or android application. I don't bother daily tracking on my phone, else it might be cumbersome. I've never used any of the budget features, just tracking where my money comes and goes.
I don't use Trillium, but I've enjoyed Logseq. I use it with nextcloud to back up. It is not browser friendly as far as I know when self hosted. It's primarily just markdown.
With normal split tunneling you can normally do something like this anyways, but it can be finicky to configure, and easy for something like DNS, etc to access the internet without your VPN in the middle. And sometimes if your VPN fails to connect, you could be connecting without your VPN.
By using docker with gluetun + qbit (I believe docker images for this setup exist already) you can force it to use only your VPN, and if the connection fails then your bittorrent client can't connect. With gluetun all your bittorrent traffic would flow through your VPN, but there's a way it can be configured to allow only your webui port to be accessed locally on your network
I realize it's not a satisfactory solution, since you won't be able to use facilities like artist/album/etc to explore.
But in navidrome I think you can make a smart playlist based on file path, which you could use to include all of YOUR songs in the playlist if it is in a different root path.
Anyone with Navidrome should consider trying this. It provides a means to create & modify the smart playlists graphically & makes it easier to rate songs with stars vs the web UI
Thanks! I need to look more into what the power implications of 8 drives is - they never spin down, so I assume they are a non-trivial portion of my power consumption.
That said, I've been considering upgrading to something recent and low power anyways. It would be a good opportunity to sneak in some useful features too,
Maybe the possibility of transcoding a video stream
USB3 (not a huge deal)
Non VGA display (useful, for when connection issues arise)
Audio jack (I could use navidrome jukebox mode!)
Which the old hardware wouldn't support without adapters, cards, etc.
Build - Intel server board & CPU based on old serverbuild naskiller guide
OS on SSD
ZFS ON 8 6TB DRIVES, YIELDING ~36TB of storage, recoverable with up to two failed drives
Runs (via docker)
Navidrome (webui used daily @ work, dsub on phone, feishin on desktop)
Jellyfin (used almost exclusively locally on my TV, occasionally to watch with friends on web)
Nextcloud (used occasionally, mostly backs up password files, etc or to share. Thinking about replacing.)
QBitTorrent with glutun VPN
Audiobookshelf - used frequently for audiobooks. Occasionally for podcasts. Often more convenient to use antennapod/pocket casts on phone for active podcasts)
Kavitas - used seldom. Thinking about stopping. I like using obps on my rooted kindle to access my library.
Kiwix (local wikipedia copy I use shortcuts in FF locally to search for things)
Homepage (local links I use on local machines to my services)
Raspberry pi
Adguard home & unbound - block most garbage for any traffic from my home
Thoughts - I'm considering downsizing. I don't really need all that much space, and it can be a headache at times. With drive replacement costs on top of power (~$320 a year) I consider either going to a vps or downsizing to what could run on a small compute like the n100 or a raspberry pi5, etc.
I can't speak for any specific version - but for awhile it was the same for me, but they eventually made a WebOS official release so I no longer have to fuss with developer mode.
Since it can't reach the Internet since that point ( maybe a year ago?) I can't vouch for if any update would have broken that
I'll happily say I must have overlooked something, but I did try using update-alternatives. I don't remember all the nuts and bolts from the start, but it involves python3 and distribution upgrades. I spent a good number of nights over the years trying to unmess it up, and am happy to never think about it ever again.
Installed python3 before it was made the native python on the dist. Half broke everything, including apt & python. So I uninstalled it, and then everything was broken. Finally got python3 reinstalled, and lived with it kindof working & awful distribution updates.
I have finally freed myself of that prison last month, by nuking everything and starting fresh.
Under the hood its mostly tables and reports, so ultimately not much, if you were dedicated enough to using Excel to rebuild GnuCash's views. It's more streamlined than excel would be because you won't have to worry about implementation, overhead of adding a new account, etc. Some things like auto-recommending accounts during import (and import itself) could be arduous in excel if not supported natively. Split transactions could be a headache (think your paycheck, which might be split into 401k contributions, several taxes, money into your bank, etc).
But fully recreating it in excel when it already exists would be a headache. More than likely you will have a more limited view in Excel if you're just creating a handful of tables to represent all of your many accounts.