A spreadsheet can be a database if it stores and returns data.

#data #databases #spreadsheets

Anyone out there know of a good source of templates for Apple Numbers spreadsheets?

I’m specifically looking for personal finance and budgeting templates that offer more depth than what's in Apple’s offerings.

#personalfinance #spreadsheets #templates

Join Attribute Tables in QGIS

https://videos.qwast-gis.com/w/crzh3ANTzNZvYCQRJfXifg

In meinen heutigen #TechTipps möchte ich Euch gerne #duckdb
vorstellen.
DuckDB (https://duckdb.org) könnte Euch dann interessieren wenn ihr:

- in der IT (#Softwareentwicklung, Datenanalyse #Olap, Qualitätssicherung, Forschung, etc ) arbeitet
- privat an Datenanlyse jenseits von unübesichtlichen Tabellen (#Spreadsheets) interessiert seid
- Daten wie Kontoauszüge, Telefonbücher oder (elektronische) Kataloge durchforsten wollt

DuckDB kann als eigenständiges Kommandozeilen (#CLI) Programm ohne Abhängigkeiten bezogen und verwendet werden oder auch intergriert in andere #programmiersprachen (#python) oder #tools wie #jupyter integriert werden.

Die CLI-Version kann mit Parameter "-ui" verwendet werden und startet damit ein recht komfortables #webui im lokalen #browser.
Im ersten Schritt legt man nun ein "Notebook" an das zellenweise strukturiert ist.
Es können jederzeit neue Zellen an jeder Stelle im #workflow hinzugefügt, eingefügt oder gelöscht werden.
Unterteilt man nun seinen Anwendungsfall in kleine Schritte (Zellen) wird ein komplexes Thema schon viel einfacher.

Beispiel:
1. Zelle:
-- Datenbank im Speicher anlegen
ATTACH IF NOT EXISTS ':memory:' AS memory;

2.Zelle:
-- Tablle BLS 4.0 importieren
CREATE OR REPLACE TABLE BLS AS
SELECT * FROM
read_xlsx('/home/XXX/Downloads/BLS_4_0_2025_DE/BLS_4_0_Daten_2025_DE.xlsx',
sheet = 'BLS_4_0_Daten_2025_DE',
header = true, all_varchar = true);

3. Zelle
-- Zeige mir Lebensmittel mit Vitamin D
select Lebensmittelbezeichnung, "VITD Vitamin D [µg/100g]" as VD
from'BLS'
where
VD is not null and VD not ilike '0'
order by VD DESC;

Ergebnisse können als Tabelle oder CSV mit "Download" gespeichert werden.
😀

I track my expenses using Google Sheets and use an XLOOKUP to get the available balance of a budget line e.g. groceries by searching for the previous mention of that budget line and getting the subtotal.

But if I forget to add an expense and want to insert a row it was breaking my cell references because the XLOOKUP can't include the current row (circular reference error).

I found I could use INDIRECT in the XLOOKUP *and* mix absolute R1C1 references with relative R[-1]C3 references *and* use ranges in INDIRECT which I didn't know was possible:

e.g.

=XLOOKUP(INDIRECT("R[0]C[-1]",FALSE),INDIRECT("R2C3:R[-1]C3",FALSE),INDIRECT("R2C6:R[-1]C6",FALSE),,0,-1)

If for some reason you needed to calculate a relative reference you can also calculate the R1C1 or even R[0]C[0] style reference because it's a string

e.g.

=INDIRECT("R[0]C"&IF(EQ(MOD(ROW(),2),1),2,3),FALSE)

#GoogleSheets #Spreadsheets

EyeingAI (@EyeingAI)

스프레드시트용 AI의 대규모 출시 소식: 엑셀(Excel) 상에서 자동 분석, 오류 검사, 모델링 속도 향상으로 컨설팅·금융팀의 의사결정에 큰 영향. 작은 변화처럼 보이지만 트릴리언 단위 의사결정에 적용되는 점을 강조하며 'Huge launch'로 평가됨.

https://x.com/EyeingAI/status/2013677660287959111

#spreadsheets #excel #automation #finance

In my experience, the #LibreOffice Calc "VALUEDATE" function can't parse most date text string formats that #Gnumeric, #Excel, Google Sheets (and even Apple's "Numbers" app, apparently) can handle.

I was quite surprised to not be able to find an existing bug report about this, so I filed one, and have to convince people that being able to parse different date formats is a nice thing for that parsing function to be able to do: https://bugs.documentfoundation.org/show_bug.cgi?id=170107

#DataScience #spreadsheets

#52booksin52weeks Title Starts with "P" Picks and Shovels by Cory Doctorow #technology #TechThriller #corporategreed #activisim #history #TechHistory #spreadsheets #corydoctorow #martinhench #bookstagram #booktok #booksky #gamemastersbookclub #ttrpgpodcast #GameMaster #ttrpg https://www.k-squareproductions.com/gmbc

Ah, the age-old battle of convenience store supremacy in #Japan, because clearly, analyzing the ratios of 7-Elevens to Lawsons is the hill we all want to die on. 🗺️📊 Who knew #spreadsheets could be so exhilarating? 😴
https://conbini.kikkia.dev/ #convenienceStores #7Eleven #Lawson #dataAnalysis #HackerNews #ngated

Ah; it’s that special time of year — that only comes along every few years — when I have to update my custom look-up table of US government holidays for currency exchange purposes… #spreadsheets #Numbers #iWork #USD #CAD

Who needs a financial advisor when you’ve got ten years of **plain text files**? 📂✨ Just spend a casual 3045 minutes each month in a thrilling relationship with #Beancount and voila, your bank statements become your best friends! 🤑🔧 Because nothing screams ‘financial wizard’ like being a spreadsheet sorcerer. 🪄📜
https://sgoel.dev/posts/10-years-of-personal-finances-in-plain-text-files/ #financialadvice #personalfinance #spreadsheets #moneymanagement #HackerNews #ngated

Working with large #projects can get messy—especially when dependencies between #spreadsheets, #formulas, or #plots aren’t clear. That’s why we’ve implemented a simple solution to track #data dependencies, so you can: :boost_love:

➡️ Spot errors faster – See how changes in one sheet impact others.
➡️ Save time – No more manual tracing of formulas or references.

@labplot@lemmy.kde.social
@opensource

#FreeSoftware #OpenSource #FLOSS #FOSS #DataAnalysis #DataViz #Productivity #Tech #Science #Statistics #InfoSec

Puh.

Found a way to get the USD->EUR conversion rate for a specific date in LibreOffice Calc by using a web-service in a formula. It's not pretty, but it works!

=NUMBERVALUE(REGEX(WEBSERVICE("https://api.frankfurter.app/"&TEXT(D10;"YYYY-MM-DD")&"?from=USD&to=EUR");".*EUR.:([0-9.]+).*";"$1");".")

This gets the correct official conversion rate from the date in field D10...

#excel #libreoffice #webservice #currency #spreadsheets

Tom’s Hardware: ‘LeBron James of Excel spreadsheets’ celebrates 2025 Microsoft Excel World Championships win — beat 256 other spreadsheet whizzes to claim the $60,000 first prize in Las Vegas tournament. “The 2025 Microsoft Excel World Championships final in Las Vegas has been won by Irishman Diarmuid Early. Bestowed with the nickname ‘the LeBron James of Excel spreadsheets,’ it might […]

I obtained these results through a pairing analysis of terms in the 2025 Gender Census.

I provided a walkthrough of the methodology behind my pairing analysis in Agender, Genderless, and Gendervoid.

https://jasonbeets.blogspot.com/2025/11/agender-genderless-and-gendervoid.html

43/x

#Agender #Genderless #Gendervoid #Survey #Spreadsheets #Data

My father used spreadsheets both in Xenix and MS-DOS, especially Lotus-123. I remember MS Multiplan and the ones included in MS Works and Open Access (I think I still have a backup somewhere). In the high school we also used Ashton-Tate’s Framework. #msdos #spreadsheets https://hackaday.social/@hackaday/115724197550673706

Semantic headers are a pretty cool thing! They are pretty useful when you need to compare multiple files that “aren’t exactly the same” but where you keep procrastinating clean-up because there are too many of them. I was looking for a way to standardize multiple files with a single click, and this seems a good first step in the right direction.

#Excel #Spreadsheets #xls #xlsx #csv #OpenXML #LocalFirst

I first discussed my pairing analysis of the Gender Census in "Agender, Genderless, and Gendervoid."

In that article, I also provided a step-by-step walkthrough of how I calculated my pairing analysis results.

https://jasonbeets.blogspot.com/2025/11/agender-genderless-and-gendervoid.html

16/x

#Agender #Genderless #Gendervoid #Math #Analysis #Spreadsheets #Data

This year, I switched to using LibreOffice, a free alternative to Microsoft Office products.

https://www.libreoffice.org/

28/x

#LibreOffice #Microsoft #SiliconValley #Tech #Technology #Word #Excel #Spreadsheets

When #spreadsheets get complicated, SheetCraft is your solution.
SheetCraft is an open-source #Rust toolchain that lint, analyze, query, and audit spreadsheets (#Excel & @libreoffice #LibreOffice) as if they were code.

https://github.com/cosmoscalibur/sheetcraft