Scenario controls
Try a what-if
Preparing workbook
Workbook
TXWB retains the native dashboards. XLSX retains the worksheet model and formulas.
Download the starting workbook
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
What-if business simulator
Northstar Software models 24 months of subscription growth. All three scenarios share the same worksheet formulas. Dashboard charts and KPI cards query formula-backed tables in the Summary sheet.
APIs used
Workbook.batch()
Range.setFormulas()
Workbook.calculation.recalculateAsync()
Workbook.onChange()
Worksheet.validation.set()
Dashboard.addWidget()
Workbook.activeView
editor.load()
editor.save()
How to explore
Adjust an assumption, select a forecast month, or compare how the three scenarios perform at month 24.
Operating profit is the monthly cash-flow proxy. The forecast excludes taxes, financing, capital spending, and working-capital timing. Marketing has no automatic effect on acquisition.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0