Using AI to Write Excel Formulas: A Safe 5-Step Checklist
AI assistants are great at Excel formulas — when you give them the right details and test the result. A five-step checklist with an…
Read article →MaxL Basics: Automate Essbase Data Loads and Calculations
MaxL Basics: Automate Essbase Data Loads and Calculations
Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
Read article →12 Windows Shortcuts I Use Every Day (Most People Know Only 3)
12 Windows Shortcuts I Use Every Day (Most People Know Only 3)
Twelve Windows 10/11 keyboard shortcuts that save real time every day — clipboard history, screenshots, snapping windows, virtual desktops and more.
Read article →AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week
AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week
Use AutoHotkey v2 on Windows to expand abbreviations into full text, insert today’s date, and launch apps with shortcuts — with a starter script…
Read article →10 Tech Myths People Still Believe
10 Tech Myths People Still Believe
Incognito mode makes you anonymous, you must drain your battery, more megapixels means better photos — ten common tech myths, busted.
Read article →Run an LLM on Your Own Laptop with Ollama (Private, Free, Offline)
Run an LLM on Your Own Laptop with Ollama (Private, Free, Offline)
Install Ollama, run open models like Llama and Qwen locally, call them from Python and Excel-friendly scripts, and create a custom model with a…
Read article →Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Computers store numbers in binary, so 0.1 cannot be stored exactly. Why that makes 0.1+0.2 ≠ 0.3, how it shows up in Excel, Python…
Read article →Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Learn how FIX…ENDFIX focuses an Essbase calculation on a slice of the cube, with examples for aggregation, allocation, clearing data and copying scenarios —…
Read article →Why AI Chatbots Make Things Up (and 6 Ways to Catch It)
Why AI Chatbots Make Things Up (and 6 Ways to Catch It)
LLM "hallucinations" explained simply: why a next-token predictor can sound confident and still be wrong, and six practical habits to catch fabricated facts, formulas…
Read article →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Copy Text from Any Image or Screenshot on Windows
Copy Text from Any Image or Screenshot on Windows
Grab text from screenshots, scanned PDFs, videos or error dialogs on Windows — using the Snipping Tool’s text actions or Microsoft PowerToys Text Extractor.
Read article →Temperature and Top-p Explained: Why the Same Prompt Gives Different Answers
Temperature and Top-p Explained: Why the Same Prompt Gives Different Answers
What the temperature and top-p settings in AI models actually do, with a worked numeric example, and which values to use for code, data…
Read article →