Blazor Spreadsheet Example - Formula
This sample demonstrates formula calculations and data analysis using a stock analysis workbook. Explore named ranges, recalculation, and formula categories.
This demo passes automated axe checks with 0 violations — semantic markup, ARIA, full keyboard operation, visible focus. Section 508 conformant
Accessibility report
| 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 | ||||||||||||||||||||||||||