The Journal
Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.
Excel Cell References: Relative, Absolute, Mixed
Excel cell references explained: relative, absolute ($A$1) and mixed ($A1, A$1) references, the F4 key, ranges, other sheets…
Apps Script Deployment Types Explained
Apps Script deployment types explained: versions vs deployments, /dev vs /exec, web app access settings, libraries and updating…
Build a Web App Frontend With Apps Script
Build a web app frontend with Apps Script: HtmlService pages, google.script.run, include() files and a working task list…
What Is doGet in Apps Script? Explained
What is doGet in Apps Script? How web app URLs call doGet(e), read query parameters, return JSON or…
Apps Script Time Triggers: Cron for Google Sheets
Apps Script time-driven triggers explained: schedule scripts in Google Sheets like cron, with a daily email example, limits…
onOpen in Apps Script: How It Works, Use Cases
onOpen in Apps Script explained: build a custom menu, show a toast, open on the right tab, and…
onEdit in Apps Script: How It Works, Use Cases
onEdit in Apps Script explained: the event object, guard clauses, timestamps, change logs, row colors and when you…
Google Apps Script for Beginners: A Simple Intro
Google Apps Script for beginners: what it is, how to open the editor in Google Sheets, read and…
10 Coding Interview Patterns in Python
10 coding interview patterns in Python with short, tested examples: hash map, two pointers, sliding window, binary search,…