I tracked 100% of my waking hours in 2024—every meeting, work hour, workout, and moment with family

Hmm. Just idea Lightweight xlsx = CSV with json additions

Good points thanks. Will rad about TK solver.

The question is about the use case and how much technical people are.

Excel format is bad because it’s not clear simple text in the raw text format. Also for simple local database with not that much data.

CSV with quirks could be edited with any text editor, put into LLM, shared, GIT history edits. That’s also the benefits of local notes in filesystem in MD format (oobsidian).

Problem with plain CSV is that I can’t do any formatting even the simplest or make simple formulas. I could make calculations using DuckDB or something but it have friction.

I am the owner of TimeCamp app that can track usage of desktop apps.

75% of office workers that use Google Chrome use Notepad++ on Windows.

That's so cool to know! Is there anywhere one can go to read more interesting stats you've collected?

I just prepared some data https://docs.google.com/spreadsheets/d/1C73B9XI14rLxYD_4kedG...

we are migrating to Clickhouse so it will be easier to get some interesting stats soon, then from MySQL ;)

Thanks! Hope you publish more stats once you have the new stack in place!

feels like forbidden knowledge... I guess any app devs know things like these if their software's used widely enough like chrome/steam and your various motherboard software suites and crapware installed by laptop makers

Probably using CSV data format which is great. Can be used for example in Obsidian.

TSV, actually.

TSV always struck me as making a lot more sense than CSV. No need to worry about escaping quotes and commas and etc... Just disallow tabs in the data (which shouldn't be necessary anyway) and done.

Good news, ASCII has always had record and group separator characters that for some reason we have all forgotten they exist and nobody would ever use in non-binary data:

https://en.wikipedia.org/wiki/C0_and_C1_control_codes#Field_...

hah, I was actually aware of this, ironically because I side-projected an encoding/decoding that "visibled" normally unprintable ASCII characters into printable UTF-8

https://github.com/pmarreck/elixir-snippets/blob/master/prin...

Maybe we should bring field and record separators back and call it "ascii-separated values" (ASV) lol (because, you know... "as originally envisioned by the makers of ASCII")

The only caveat is the lack of visible printability of those (hence that project up there). It would be neat if (by default) the field separator ASCII character looked similar to a tab (maybe with some distinguishing detail such as a dotted underline) and the record separator ASCII character looked similar to a newline (again, with some extra visible difference, but also including the visible linefeed)

There's probably a font feature that lets you do this

The final issue with it is how in the world would we type those characters?

CSV stopped making sense really fast when commas are needed for thousands’ grouping of numbers or decimals, and what the heck, I even name all my scripts with a starting comma (read that somewhere as a short productivity burst). Anyhow, all my text file shenanigans are tabbed, the infamous \t then needs to be correctly parsed in all scripts which is a hell lot easier.

for me too

Figure out when SaaS growth might plateau.

I made a Shortcut + PHP to get text from a screenshot, ask ChatGPT to make a task name from text, and create new task in Clickup and attache a screenshot. Use it often.

I created https://www.timecamp.com that can track processes, window titles and url (free). Those informations presented visually can help make better timesheets :)

Can you recommend any accounting firm for Delaware INC company? We started with Stripe Atlas but can't find good and affortable firm.