If you need a free Windows spreadsheet that can cope with very large spreadsheets, these are the best choices: 1. LibreOffice Calc (recommended by ChatGPT but I had difficulties installing…
If you’re asking how to open DuckDB on Windows, it depends on what you downloaded. If you have duckdb.exe, simply double-click it. A command window will open with a D>…
One of the nicest features of DuckDB is that you don’t need to import a CSV before working with it. For example, if your file is called large.csv: View the…
You can do all of that cleanly in DuckDB using one SQL pipeline: combine date+time → filter by ID → build hourly pivot. I’ll assume your CSV has columns like:…
Keep only the first 100,000 rows and save them COPY ( SELECT * FROM ‘large.csv’ LIMIT 100000 ) TO ‘small.csv’ (HEADER, DELIMITER ‘,’); Extract a range of rows (e.g. rows…
In Excel, you typically do this with either IF, IFS, or lookup functions depending on what you mean by “select based on content”. Here are the most common patterns: 1)…
This is an example of a clock source which can be used with SDRs that will accept external clocks for e.g. pulsar observations – the recommendation was made by a…
A Kalman filter is a mathematical method used to estimate the true position and motion of a system when the measurements are noisy. For a radio dish, it can make…
The Airspy Mini has a maximum IQ sample rate of 6 MSPS, giving a maximum instantaneous bandwidth of approximately 6 MHz. However, there are a few subtleties: Available sample rates:…
Yes — there are a few very well-reviewed ~100Wh (airline-safe) power banks, but they are almost all from established brands (Anker, Nitecore, Ugreen). The key point is: anything near 100Wh…
Admin