This is the first time I work for a company that I actively want to personally advertise for, but I really like what #Grist does. It's like a #spreadsheet that's really a #database and lets you use #Python as a computational language. And it's all open source!
I had a sudden "what if…?" intuition for a potential #productivity speedup in my #opensource bug reporting workflow when tables of data are involved, and… it turns out that it is actually possible.
As you can see in this short demonstration I recorded below, you can paste #LibreOffice#spreadsheet cells into a #GitLab ticket, and it automatically converts it to a proper #MarkDown table. It just works! What is this sorcery!? 🤯 What a time to be alive.
Just discovered the Category Groupings in Apple Numbers. Useful! Extended my spreadsheet for Dasher tracking all the way out to the full year and now I can group by year, month and week (the Dasher app goes by week).
The one trick is if you want subgroups you really have to do it at the beginning. It's very hard (impossible?) to properly add subgroups after. They get all mixed up.
The groups create their own calculation line where you can sum, average, etc that column in the group.
I’m going to have to use this for my historical weather spreadsheets!
Need to sum values based on criteria? You're in luck. The 2 best functions to accomplish this will be SUMIF and SUMIFS. Learn how you can use these powerful functions in your #spreadsheet formulas to simplify calculations. #iWork#AppleNumbers
Hey #spreadsheet ninjas. Can anyone find the formula #error in this sheet? It’s supposed to be showing the full hierarchical number value.
I have seen many want to solve this problem unsuccessfully. This is the only one that claims victory. But over 2 years since being posted, it broke somehow (assuming it ever worked).
That’s the credit cards paid off and a new tab on my Christmas present #spreadsheet created, present budget set for next Christmas so I can save in my designated account all year. We don’t buy extravagantly, I just like to know the money has been set aside to cover it.
Using a sum formula that totals to zero in your #spreadsheet? No, your computer is not broken, but there is a reason that's happening. Learn how to fix this issue each and every time in #AppleNumbers. #iWork#iWorkExpert
https://gmkeros.files.wordpress.com/2023/12/campaign-tracker.pngI am currently going through a lot of trainings, and specifically I am doing something to work on my SQL knowledge. I only have hovered around the edges of the topic before. Some of my previous jobs involved making some basic database queries, but I never really looked further than basic database structures and simple queries.
But that got me thinking about doing a campaign database in SQL, with a better way to track all those elements that might be interesting to know for a campaign.
Now to be fair, I am not thinking about the usual wham bam 20 levels in a campaign thing 5e seems to have going on, I am talking about a multiplayer campaign in the OSR/West Marches vein where every single session might be played by different players. I think I should actually write about this ideal of a campaign I have.
But anyway… when thinking about it I remembered that years ago for my idea of a Harnworld campaign in my own Harnworld B/X derivative that got derailed quickly by parenthood and everything involved in that I made a campaign tracker spreadsheet in Google Sheets that was supposed to do a lot of this already. This was inspired by multiple other sheets I found, e.g. the old ADnD ones or the Hackmaster one. I found it a bit cumbersome to use, but mostly I was waiting for the campaign to continue which it never did, and forgot about the existence of the spreadsheet. I fully intended to improve on it, but haven’t gotten around to it for years now. It mostly is a layout without any formulas.
I did put some thought into it though, it has some Harn specific things (e.g. a tab about Godstones, which are dimensional gates in the setting), so if someone else might find it useful have a look. Maybe give me some feedback while you’re at it.
Here's a #spreadsheet question: what #calculation-based "stuff" do you do with spreadsheets, outside the realm of grid-based tasks (eg a multiplication table) or texty lists (eg a todo list) or things producing graphs?
I'm interested in anything with a series of calculations that's /not/ a big grid!
Suddenly remembered in 1991 when I needed to organise the data for my BA thesis, so I got a #database handler: PC File. Turned out that wasn't what I needed at all, and since then I've used #spreadsheet s instead for my research. The first one was Quattro Pro.
Grist is a "modern relational #spreadsheet". It combines the flexibility of a spreadsheet with the robustness of a database to organize your data and make you more productive.
Earlier this year I missed a major history of computing anniversary the tech press didn't cover either. In January of 1983, 40 years ago, the Lotus 1-2-3 spreadsheet software was released.
i've now added a 6 more months to my podcast listening spreadsheet. 5 of which were backlogs from before I created the spreadsheet, and then 1 for the month of May 2023.
Out of curiosity, as I sometimes need a 2nd #spreadsheet app running in parallel, apart from #LibreOffice (1), what #FOSS did you have in mind and which #Photoshop substitute, as #Adobe's licensing policy is getting ever more abusive (2)?
I have a Google form we use to record raffle entries for a cat rescue. Supporters enter by adding a Facebook comment with how many entries they want then one of the rescue’s volunteers adds them to the form - name and number of entries.
Is there then a way to get Google Sheets to automatically duplicate each entry (name) for as many times as the number of entries given in the form?