Blazor Spreadsheet Example - Formula
This sample demonstrates how the Spreadsheet component can be used for financial analysis through built-in formulas and named ranges. It showcases a practical example of tracking and analyzing a company's stock performance over time, with calculations for metrics like price changes, percentage fluctuations, and overall financial trends.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN |
|---|
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 26 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 33 |
| 34 |
| 35 |
| 36 |
| 37 |
| 38 |
| 39 |
| 40 |
| 41 |
| 42 |
| 43 |
| 44 |
| 45 |
| 46 |
| 47 |
| 48 |
| 49 |
| SALES | |||||||||||||||||||||||||||||||||||||||
| Period Starting: | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | ||||||||||||||||||||||||||
| Product 1 | $5,600.00 | $6,350.00 | $5,100.00 | $6,850.00 | $8,600.00 | $8,850.00 | $12,100.00 | $13,850.00 | $16,600.00 | $19,100.00 | $21,600.00 | $24,100.00 | $148,700.00 | ||||||||||||||||||||||||||
| Budget | $4,790.00 | $5,678.00 | $4,754.00 | $6,501.00 | $7,744.00 | $8,645.00 | $10,976.00 | $11,232.00 | $14,323.00 | $15,434.00 | $16,543.00 | $17,896.00 | $124,516.00 | ||||||||||||||||||||||||||
| Over / (Under Budget) | $810.00 | $672.00 | $346.00 | $349.00 | $856.00 | $205.00 | $1,124.00 | $2,618.00 | $2,277.00 | $3,666.00 | $5,057.00 | $6,204.00 | $24,184.00 | ||||||||||||||||||||||||||
| Product 2 | $5,600.00 | $6,350.00 | $16,400.00 | $16,830.00 | $19,260.00 | $17,690.00 | $15,600.00 | $17,350.00 | $10,600.00 | $11,350.00 | $10,100.00 | $13,850.00 | $160,980.00 | ||||||||||||||||||||||||||
| Budget | $4,595.00 | $5,678.00 | $9,754.00 | $9,168.00 | $18,747.50 | $14,327.00 | $14,906.50 | $15,486.00 | $9,065.50 | $10,645.00 | $8,224.50 | $12,804.00 | $133,401.00 | ||||||||||||||||||||||||||
| Over / (Under Budget) | $1,005.00 | $672.00 | $6,646.00 | $7,662.00 | $512.50 | $3,363.00 | $693.50 | $1,864.00 | $1,534.50 | $705.00 | $1,875.50 | $1,046.00 | $27,579.00 | ||||||||||||||||||||||||||
| Product 3 | $14,600.00 | $25,350.00 | $25,100.00 | $26,850.00 | $32,100.00 | $35,750.00 | $39,400.00 | $43,050.00 | $46,700.00 | $50,350.00 | $54,000.00 | $57,650.00 | $450,900.00 | ||||||||||||||||||||||||||
| Budget | $5,895.00 | $3,678.00 | $5,754.00 | $7,501.00 | $9,430.00 | $11,319.00 | $13,209.00 | $15,098.00 | $16,988.00 | $18,877.00 | $20,766.00 | $22,656.00 | $151,171.00 | ||||||||||||||||||||||||||
| Over / (Under Budget) | $8,705.00 | $21,672.00 | $19,346.00 | $19,349.00 | $22,670.00 | $24,431.00 | $26,191.00 | $27,952.00 | $29,712.00 | $31,473.00 | $33,234.00 | $34,994.00 | $299,729.00 | ||||||||||||||||||||||||||
| Product 4 | $16,850.00 | $17,690.00 | $18,830.00 | $19,260.00 | $20,690.00 | $21,439.00 | $22,364.00 | $23,289.00 | $24,214.00 | $25,139.00 | $26,064.00 | $26,989.00 | $262,818.00 | ||||||||||||||||||||||||||
| Budget | $8,895.00 | $14,678.00 | $7,754.00 | $6,501.00 | $9,430.00 | $11,319.00 | $13,209.00 | $15,098.00 | $16,988.00 | $18,877.00 | $20,766.00 | $22,656.00 | $166,171.00 | ||||||||||||||||||||||||||
| Over / (Under Budget) | $7,955.00 | $3,012.00 | $11,076.00 | $12,759.00 | $11,260.00 | $10,120.00 | $9,155.00 | $8,191.00 | $7,226.00 | $6,262.00 | $5,298.00 | $4,333.00 | $96,647.00 | ||||||||||||||||||||||||||
| Product 5 | $78,600.00 | $88,750.00 | $89,002.00 | $86,850.00 | $96,400.00 | $106,830.00 | $127,260.00 | $137,690.00 | $167,273.00 | $165,240.00 | $193,207.00 | $196,174.00 | $1,533,276.00 | ||||||||||||||||||||||||||
| Budget | $68,595.00 | $78,595.00 | $78,754.00 | $86,501.00 | $77,744.00 | $99,845.00 | $115,976.00 | $126,232.00 | $162,323.00 | $155,434.00 | $192,543.00 | $194,896.00 | $1,437,438.00 | ||||||||||||||||||||||||||
| Over / (Under Budget) | $10,005.00 | $10,155.00 | $10,248.00 | $349.00 | $18,656.00 | $6,985.00 | $11,284.00 | $11,458.00 | $4,950.00 | $9,806.00 | $664.00 | $1,278.00 | $95,838.00 | ||||||||||||||||||||||||||
| Total Sales | $121,250.00 | $144,490.00 | $154,432.00 | $156,640.00 | $177,050.00 | $190,559.00 | $216,724.00 | $235,229.00 | $265,387.00 | $271,179.00 | $304,971.00 | $318,763.00 | $2,556,674.00 | ||||||||||||||||||||||||||
| Total Sales Budget | $92,770.00 | $108,307.00 | $106,770.00 | $116,172.00 | $123,095.50 | $145,455.00 | $168,276.50 | $183,146.00 | $219,687.50 | $219,267.00 | $258,842.50 | $270,908.00 | $2,012,697.00 | ||||||||||||||||||||||||||
| Total Over / (Under Budget) | $28,480.00 | $36,183.00 | $47,662.00 | $40,468.00 | $53,954.50 | $45,104.00 | $48,447.50 | $52,083.00 | $45,699.50 | $51,912.00 | $46,128.50 | $47,855.00 | $543,977.00 | ||||||||||||||||||||||||||
The Spreadsheet component provides a comprehensive calculation library, supporting over 400+ formulas for mathematical, statistical, financial, logical, and text functions. In this example, you can explore how named ranges simplify formula references, making complex financial models more maintainable. The pre-loaded workbook contains real-world formulas for stock analysis that you can examine, modify, and immediately see recalculated. Try changing values in the input cells to see how formulas automatically update results throughout the connected cells.
More information on the Blazor Spreadsheet can be found in this documentation section.