This article walks through building a minimalist VisiCalc clone in C, covering the core data model (cells, grid), a recursive‑descent parser for formulas, dependency handling via repeated recalculation, and a text‑based UI using ncurses. It explains how to parse cell references, evaluate expressions, and implement a simple modal interface with commands, editing, and navigation. The post culminates in a working terminal spreadsheet that supports basic functions like @SUM, @ABS, @INT, and @SQRT, and demonstrates how to render the grid, status bar, and edit line. It also discusses limitations and possible extensions, linking to the full implementation on GitHub.
This article details the author's experience with Nushell, a terminal shell that presents data in a spreadsheet-like format, improving usability and productivity compared to traditional command-line interfaces. It covers installation, core concepts, benefits for everyday tasks, customization options, and limitations.
This article details how the author created a personal finance dashboard in Google Sheets as an alternative to restrictive and subscription-based finance apps, emphasizing customization, transparency, and accessibility.
Google's AI function brings Gemini-powered language models right into your spreadsheet cells without any add-ons. With it, you can generate fresh text, summarize blocks of data, categorize entries, or even guess sentiments—all by typing a simple formula.
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
The article provides examples such as:
- *sentiment analysis* ```=AI("Is this customer feedback positive, negative, or neutral?", A2)```
- *data categorization* `=AI("Classify this expense as Travel, Office, or Other", D3)`
- *simple calculations* `=AI("Add the numbers in these cells", A1:A5)`
This article describes a workflow using Large Language Models (LLMs) to automate the process of normalising spreadsheet data, making it tidy and machine-readable for easier analysis and insights.
Use a new spreadsheet app to analyze large CSV files fast and locally.
Learn how to automate repetitive tasks in Google Sheets using Google Apps Script, a powerful scripting platform for automating various tasks across Google Workspace apps. Explore examples, step-by-step instructions, and use cases for streamlining your workflow and boosting productivity.
Quadratic is a modern spreadsheet that combines the familiarity of a spreadsheet with the power of code, allowing you to work with data and code collaboratively in real-time. It supports popular programming languages like Python, SQL, and JavaScript, and offers features such as dynamic charts, APIs, multi-line formulas, and AI integration.
