Honest Skills Matrix & Formula Encyclopedia
A transparent, production-verified breakdown of our technical proficiencies, everyday Google Sheets formulas, script architectures, and modern web integrations.
Strong / Advanced Skills
Core everyday specializations backed by over a decade of hands-on enterprise production usage.
Complex multi-sheet models, ARRAYFORMULA, dynamic ranges, master data architectures.
Advanced macros, PivotTables, Power Query, automated financial reconciliation.
Enterprise automation, scheduled triggers, PDF compilation, API integrations, Web Apps.
Executive reports, departmental KPI scorecards, multi-tier data pipelines.
End-to-end digitization of manual sales, purchase, production, and audit workflows.
Multi-stage flow control (S00..S85), step ownership, turnaround time (TAT), escalations.
Deduplication, schema normalization, single source of truth data structures.
Interactive executive visual dashboards, real-time data sync, multi-page reports.
BOM tracking, rotavator/agri machinery shop floor workflows, vendor job-work.
Standard Operating Procedures, Gemba observations, team training manuals.
Practical Working Skills
Technologies actively used for frontend apps, system integrations, and automation pipelines.
Bi-directional data sync with third-party software (TrackOlap, ESSL, Meta WhatsApp).
Clean, responsive UI design, mobile-first layouts, responsive data tables.
DOM manipulation, async/await, fetch API, LocalStorage persistence, regex parsing.
Nested JSON parsing, flattening, schema transformation, and error recovery.
AiSensy & Meta webhook integration, automated templates, broadcast queuing.
Browser geolocation API, coordinate distance calculations, boundary fencing.
Live selfie capture, canvas image processing, mirrored camera preview.
Insprl API connectivity, click analytics, SMS character optimization.
Modern Stack & Active Proficiencies
Modern web and backend tools actively deployed in scalable production environments.
App router, Server Actions, modern component architecture, SSR/SSG.
Relational database schema design, Row-Level Security (RLS), real-time tables.
Production web deployments, environment secrets, custom domain routing.
Version control, repository management, continuous feature iteration.
Next.js API route handlers, JSON endpoints, server-side data processing.
LLM API integration, prompt engineering for business automation workflows.
Production Formulas Mastered
Formulas we use daily to build robust, crash-proof master data architectures that scale across thousands of rows.
Executes Google Visualization API SQL queries directly over spreadsheet ranges. Enables multi-condition filtering, sorting, column selection, and dynamic aggregations without modifying raw data.
=QUERY(SalesData!A1:Z, "SELECT B, SUM(E) WHERE C = 'Completed' GROUP BY B ORDER BY SUM(E) DESC LABEL SUM(E) 'Total Revenue'", 1)Securely pulls live datasets across separate Google Sheets files with automated permission management. Foundation for multi-department master data segregation.
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/FILE_ID", "MasterDB!A2:H")Applies a formula down an entire column dynamically. Eliminates the need to drag formulas manually, preventing accidental deletion and formula inconsistencies.
=ARRAYFORMULA(IF(A2:A="", "", IF(D2:D="Yes", E2:E*1.18, E2:E)))Modern two-way exact/approximate matching with built-in default fallback, replacing fragile VLOOKUP indices and complex INDEX/MATCH boilerplate.
=XLOOKUP(A2, Employees!A:A, Employees!D:D, "Not Found", 0)Returns filtered array results satisfying single or compound Boolean conditions without altering original rows.
=FILTER(Orders!A2:G, (Orders!C2:C="Pending") * (Orders!E2:E<=TODAY()))Extracts distinct values from a range, removing duplicates dynamically for dropdown lists and validation sources.
=SORT(UNIQUE(FILTER(MasterItems!B2:B, MasterItems!B2:B<>"")))Creates custom reusable lambda functions mapped across row arrays, enabling advanced calculations and multi-step data pipelines natively.
=MAP(A2:A, B2:B, LAMBDA(start, end, IF(start="", "", WORKDAY.INTL(start, end, 1))))Extracts phone numbers, order IDs, invoice codes, or GST numbers from unstructured text fields using regular expressions.
=REGEXEXTRACT(A2, "[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}")Calculates business day turnaround times excluding weekend rules and custom corporate holidays for accurate FMS SLA tracking.
=WORKDAY.INTL(C2, D2, 1, Holidays!A2:A)Extracts specific rows or columns from a dynamic array without nested queries, optimizing dashboard reload speed.
=CHOOSECOLS(SORT(Sales!A2:K, 5, FALSE), 1, 2, 5)The 3 Golden Rules of Sheet Architecture
Raw data entry sheets must remain purely tabular without inline calculation formulas. Aggregation must always occur in separate reporting views.
Formulas placed in row 1 or 2 with `=ARRAYFORMULA()` ensure that new rows automatically receive calculations without human dragging errors.
Item codes, dealer names, and GST numbers must be referenced from validated master lists via XLOOKUP to prevent spelling discrepancies.