Building a Quoting Application with SpreadsheetWeb Hub

Convert a sophisticated Excel quoting model into a shared configure-price-quote application without rewriting its formulas or business rules. SpreadsheetWeb keeps the existing calculation logic while replacing disconnected workbook copies with one controlled application and a central record store.

Why file-based quoting stops scaling

An Excel quoting tool can calculate accurate prices, validate inputs, and hide complex product rules behind a simple worksheet. The limitation appears after multiple sales representatives begin saving a separate workbook for every customer and quote.

Over time, those files become difficult to search, consolidate, and update. Earlier quotes continue using the pricing tables embedded in old workbook copies, while pipeline reporting requires manual collection from many folders.

Deliver the same model through a browser

The web application exposes the familiar customer, product, and coverage inputs while keeping workbook formulas protected on the server. Every permitted sales representative uses the same published model, so calculations run against the active pricing and business rules.

Inputs can be constrained to valid choices just as they are in the source workbook. Calculated premiums or prices update as the user changes the configuration, without exposing the formulas or requiring the user to download Excel.

Generate a proposal from the quote

Attach a print process to an action button to create a branded PDF proposal. The document can combine customer data, selected options, calculated prices, coverage details, and fixed legal language.

Because the proposal is generated from the same calculation state, the document does not require manually copying values into Word and exporting a PDF.

Centralize quote data

Save each quote to the application database. The Data page provides one structured list that can be searched and filtered by customer attributes, product selections, status, or other stored values.

Export the centralized records when a manager needs an Excel pipeline report. The export contains the current dataset without opening and consolidating individual quote files.

Revise quotes with current pricing and history

Open an existing quote record when a prospect requests changes. The stored inputs are loaded into the active application, and the result is recalculated using the currently published workbook rules.

Record history preserves prior versions, timestamps, and the user responsible for each change. A historical version can be viewed or restored, providing an audit trail for regulated or approval-sensitive quoting processes.

This pattern applies beyond insurance: any Excel model that configures products, calculates prices, and produces customer quotes can become a controlled multi-user application while retaining the spreadsheet logic that already works.