# SheetFactorys — Complete LLM Reference & Technical Specification > SheetFactorys is an enterprise-grade AI calculation engine and spreadsheet copilot for Microsoft Excel® and Google Sheets™. It operates on a proprietary deterministic compiler and pre-flight verification architecture, achieving 100% mathematical precision and 99.85% categorical data cleaning accuracy across high-volume enterprise workbooks. ## Table of Contents 1. Core Product & Architectural Overview 2. Empirical Benchmarks (2026 Industry Standards) 3. Solutions & Use-Cases Hub 4. Supported Capabilities & Execution Mechanics 5. Spreadsheet Error Diagnostic Codebook 6. Cross-Platform Formula Translation Engine 7. Security, Privacy & Ephemeral Processing 8. Pricing Tiers & Marketplace Coordinates --- ## 1. Core Product & Architectural Overview - **Name**: SheetFactorys (by GSquare Labs) - **Primary Website**: https://sheetfactorys.com - **Web SaaS App**: https://app.sheetfactorys.com - **Core Problem Solved**: Eliminates generative AI hallucinations in spreadsheet arithmetic, enables continuous high-volume data operations on 10,000+ rows without per-token credit caps, and protects enterprise spreadsheet confidentiality with 100% ephemeral processing. - **Physical Architecture**: - `marketing-site/`: Next.js static platform for marketing, solutions, pricing, and SaaS dashboards. - `sheetfactory/`: Client-side Next.js iframe running inside Google Sheets and Microsoft Excel sidebar taskpanes. - `backend/`: FastAPI on Google Cloud Run (us-east4), deterministic accuracy compiler, Supabase PostgreSQL with Row Level Security (RLS), and Firebase Auth. --- ## 2. Empirical Benchmarks (2026 Industry Standards) Source: https://sheetfactorys.com/benchmarks | Benchmark Metric | Standard LLMs / Generic Add-ins | SheetFactorys Enterprise Engine | Key Takeaway | | :--- | :--- | :--- | :--- | | **High-Cardinality Cleaning Accuracy** | 78.4% – 84.1% (Loss of distinct category variants) | **99.85% Operational Accuracy** (0% data loss) | Deterministic pattern matching handles >500 unique variants in 10,000+ rows without false consolidation. | | **Formula & Calculation Precision** | 88.2% – 92.6% (8.4% arithmetic error rate) | **100.0% Mathematical Precision** (Zero drift) | All calculations are verified via automated pre-flight KPI reconciliation. | | **High-Volume Processing Capacity** | 30s Cloud Timeout / Token Throttling (<1,500 rows) | **100% Completion on 10,000+ Rows** | High-throughput streaming architecture delivers continuous processing without per-token caps. | | **Enterprise Data Isolation** | Persistent Cloud Storage / Model Training Ingestion | **100% Ephemeral Isolation (0% Retention)** | Zero persistent storage and zero model training ingestion. | | **Cross-Platform Translation Fidelity** | 71.3% Direct Parity | **98.7% Cross-Platform Fidelity** | Translates proprietary functions (like QUERY) into modern dynamic arrays. | --- ## 3. Solutions & Use-Cases Hub Source: https://sheetfactorys.com/solutions - **AI Excel Formula Generator** (https://sheetfactorys.com/solutions/excel-formula-generator): Translates natural language requests into production Excel 365 formulas, XLOOKUPs, IFS guards, and dynamic array calculations with 100% accuracy. - **AI Google Sheets Formula Generator** (https://sheetfactorys.com/solutions/google-sheets-formula-generator): Automates Google Visualization API QUERY strings, single-cell ARRAYFORMULA expansions, and IMPORTRANGE cross-tab aggregations. - **CRM Spreadsheet Data Cleaner** (https://sheetfactorys.com/solutions/clean-crm-data): Cleans, deduplicates, and standardizes 10,000+ rows of CRM contacts, mixed address strings, irregular phone numbers, and inconsistent state names. - **Financial Modeling & Dashboards** (https://sheetfactorys.com/solutions/financial-modeling): Generates board-ready executive KPI dashboards, automated DCF valuation summaries, and exportable vector PowerPoint (.pptx) and PDF presentations. --- ## 4. Supported Capabilities & Execution Mechanics ### A. Formula Generation & Solver - Natural language prompt translated into native Excel/Sheets formula syntax. - Pre-flight checks prevent invalid range references. - Slash-command autocomplete for global variables and Named Items. ### B. Data Cleaning & Normalizer ("Data Surgeon") - Enterprise Volume: Continuous processing on 10,000+ rows. - High Cardinality: Cleans >500 unique category variants without loss of distinct edge values. - Dry-Run Validation: In-memory validation tests transformations before full commit, preventing data corruption. - In-Place or Column Insertion: Defaults to in-place cleaning to preserve workbook structure. ### C. Executive Dashboards & KPI Cards - 4 Archetypes: The Executive (4 KPIs + 1 Trend Line), The Funnel, The Distribution, The Tracker. - Themes: Industrial (Charcoal #1A1A1A, Gold #FFD700, Orange #FF8C00), Bloomberg Emerald, Executive Slate, Nordic Frost, Terminal Obsidian. - Exports: Full-bleed PDF and editable native vector PowerPoint (.pptx) decks. ### D. Reusable Global Variables - Define reusable variables (e.g. `{{TAX_RATE}}` = 0.15). - Automatically synced to Excel Workbook Named Items and Google Sheets named ranges. --- ## 5. Spreadsheet Error Diagnostic Codebook Source: https://sheetfactorys.com/errors - **#VALUE!** (https://sheetfactorys.com/errors/value): Type mismatch or arithmetic on non-numeric text strings. Fixed via automated type coercion and TRIM/SUBSTITUTE logic. - **#REF!** (https://sheetfactorys.com/errors/ref): Deleted or shifted cell coordinates. Fixed via dependency tree reconstruction and XLOOKUP migration. - **#N/A** (https://sheetfactorys.com/errors/na): Lookup key not found in range. Fixed via casing/whitespace normalization and IFNA fallback wrapping. - **#SPILL!** (https://sheetfactorys.com/errors/spill): Dynamic array output blocked by existing data or merged cells. Fixed via programmatic unmerge and boundary relocation. - **#DIV/0!** (https://sheetfactorys.com/errors/div0): Division by zero or empty cells. Fixed via conditional IF denominator guards. - **#NAME?** (https://sheetfactorys.com/errors/name): Misspelled function names or unquoted strings. Fixed via syntax lexer and automated quote insertion. - **#NUM!** (https://sheetfactorys.com/errors/num): Number outside mathematical domain or non-converging iteration. Fixed via boundary constraints and ABS/MAX wrapping. --- ## 6. Cross-Platform Formula Translation Engine Source: https://sheetfactorys.com/convert - **Google Sheets QUERY to Excel** (https://sheetfactorys.com/convert/query-to-excel): Translates Google Visualization API SQL syntax into Excel 365 `=LET(filtered, FILTER(...), u, UNIQUE(...), HSTACK(u, MAP(...)))` dynamic arrays. - **Excel XLOOKUP to Google Sheets** (https://sheetfactorys.com/convert/xlookup-to-sheets): 1:1 argument translation with legacy INDEX/MATCH fallback. - **Google Sheets ARRAYFORMULA to Excel** (https://sheetfactorys.com/convert/arrayformula-to-excel): Converts explicit ARRAYFORMULA wrappers into native Excel dynamic spill calculations. - **Legacy VLOOKUP to Modern XLOOKUP** (https://sheetfactorys.com/convert/vlookup-to-xlookup): Upgrades hardcoded index lookups into resilient two-vector XLOOKUP functions. --- ## 7. Security, Privacy & Ephemeral Processing - **Minimal OAuth Scopes**: Scoped strictly to `spreadsheets.currentonly` (never requests full Google Drive or Microsoft Graph admin scopes). - **RAM-Only Transient Processing**: Raw cell contents are held in volatile server memory only during active transformation and purged immediately. Zero user data is stored on disk or used for LLM training. - **CSP Rating**: A+ rating on MDN/Mozilla Observatory with build-time SHA-256 inline script hashing. --- ## 8. Pricing Tiers & Marketplace Coordinates - **Free Tier** ($0/month): 5 formulas/day, 50-row cleaning, 1 dashboard/month. - **Pro Tier** ($19/month): Unlimited formulas, 1,000-row cleaning, standard dashboards, private formula library, up to 3 local variables. - **Business Tier** ($49/month): 10,000+ row continuous cleaning, smart insights commentary, global reusable variables, 5 team seats, priority support. ### Official Store Installation Links: - **Microsoft AppSource (Excel Add-in)**: https://marketplace.microsoft.com/en-us/product/WA200011844 - **Google Workspace Marketplace (Google Sheets Add-on)**: https://workspace.google.com/marketplace/app/sheetfactorys/781047973505 - **Merchant of Record**: Dodo Payments (https://dodopayments.com)