Blazor Spreadsheet Example - Formula
| 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 | ||||||||||||||||||||||||||
This sample demonstrates the formulas in the Blazor Spreadsheet for performing calculations and data analysis.
The Blazor Spreadsheet formulas provides a comprehensive calculation library with over 400+ formulas across mathematical, statistical, financial, logical, and text functions. Formulas support named ranges for simplified referencing and automatic recalculation when dependent values change.
In this demo:
- Examine the stock analysis workbook, which includes formulas for price changes, percentage fluctuations, and trend calculation
- Observe how named ranges simplify formula references and enhance formula readability.
- Modify input values to see dependent formulas automatically recalculate and update results in real-time
- Explore various formula categories including mathematical operations, statistical functions, and financial calculations
This feature provides a powerful calculation engine for creating dynamic spreadsheets with complex data analysis, improving productivity when working with numerical data and business scenarios.
For more detailed information about formulas and functions, refer to the formulas documentation.