Grid

Converts spreadsheet formulas (Excel/Google Sheets syntax) directly into executable calculator logic without requiring users to rewrite formulas or learn a new expression language. The system parses cell references, function calls, and dependencies from the source spreadsheet, builds a dependency graph to determine calculation order, and compiles formulas into a runtime that executes in the browser or on the server. This approach preserves spreadsheet semantics including relative/absolute references, array formulas, and conditional logic.

Maps spreadsheet cells to interactive UI input controls (text fields, dropdowns, sliders, date pickers) and automatically recalculates dependent formulas when inputs change. The system maintains a reactive computation graph where changes to input cells trigger a topological sort of dependent cells, executing only affected formulas in the correct order. Updates propagate through the dependency chain in real-time, with results reflected in output cells and bound UI elements without page reload.

Tracks calculator usage metrics (page views, unique users, input patterns, calculation frequency) and provides dashboards showing user behavior and engagement. The system logs which inputs users modify most frequently, which calculations are performed, and where users abandon the calculator. Analytics data is aggregated and anonymized, with optional integration to external analytics platforms (Google Analytics, Mixpanel). Insights help users optimize calculator design based on actual usage patterns.

Enables multiple users to edit a calculator simultaneously with real-time synchronization of changes. The system uses operational transformation or CRDT (Conflict-free Replicated Data Type) to merge concurrent edits, preventing conflicts when multiple users modify formulas, input mappings, or configuration simultaneously. Changes are broadcast to all connected editors in real-time, with visual indicators showing which user is editing which section. Version history captures all collaborative edits with author attribution.

Generates self-contained, embeddable calculator widgets that can be inserted into external websites via iframe tags without requiring the host site to modify its codebase or manage dependencies. The widget is packaged as a standalone HTML/JavaScript bundle with all necessary styles, logic, and assets embedded, communicating with the parent page through postMessage API for cross-origin safety. The iframe isolation prevents style conflicts and ensures the calculator operates independently of the host page's CSS or JavaScript context.

Provides a WYSIWYG interface for configuring which spreadsheet cells map to interactive input controls and output displays, with drag-and-drop or form-based binding. Users select cells from the imported spreadsheet and assign them to UI components (text inputs, sliders, dropdowns, result displays) without writing code. The designer generates a configuration schema that defines input validation rules, display formatting, and control properties, which the runtime uses to render the interactive calculator.

Analyzes imported spreadsheet formulas to identify compatibility issues, unsupported functions, circular references, and potential runtime errors before publishing the calculator. The system performs static analysis on the formula AST, checks for Excel/Sheets function compatibility, detects circular dependencies, and validates cell references. It provides detailed error reports with suggestions for remediation, allowing users to fix issues in the source spreadsheet or adjust the calculator configuration.

Allows importing spreadsheets with multiple sheets and supports formulas that reference cells across sheets (e.g., Sheet2!A1:B10). The system builds a unified dependency graph that spans all sheets, resolving cross-sheet references during compilation and ensuring calculations execute in the correct order regardless of sheet boundaries. This enables complex multi-sheet models to be converted into single calculators without flattening the spreadsheet structure.

Generates shareable URLs for published calculators with optional access controls (public, password-protected, or restricted to specific domains/email addresses). Each calculator receives a unique URL that can be distributed via email, embedded in websites, or shared directly. Access control is enforced at the URL level, with optional password protection or domain/email whitelisting. The system tracks sharing metadata (creation date, access logs) for audit purposes.

Allows users to export calculator results in multiple formats (PDF, CSV, JSON, email) with customizable report templates. The system captures input values and calculated outputs, formats them according to user-defined templates, and generates downloadable or emailable reports. PDF export includes optional branding (logos, headers, footers) for white-label use cases. JSON export enables programmatic integration with external systems.

Maintains version history of published calculators, tracking changes to formulas, input/output mappings, and configuration. Users can view a changelog showing what changed between versions, compare two versions side-by-side, and rollback to a previous version if needed. Each version receives a unique URL, allowing users to link to specific calculator versions. The system stores version metadata (author, timestamp, change description) for audit purposes.

Allows calculators to pull data from external sources (CSV uploads, API endpoints, database queries) to populate lookup tables, rate tables, or reference data used in formulas. The system caches imported data and refreshes it on a configurable schedule. Formulas can reference imported data using VLOOKUP or INDEX/MATCH patterns, enabling dynamic calculations based on external data without modifying the spreadsheet.