Spreadsheet - Overview

The Bootstrap Spreadsheet is an Excel-inspired control that allows you to introduce spreadsheet functionality to an ASP.NET application. It provides a rich UI and comprehensive API to create, manage and convert spreadsheet files. Your application does not require Microsoft Excel to be installed on user or developer machines.

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
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
Vader Enterprises
AMOUNTS SHOWN IN U.S. DOLLARS
SALES
SALES PRICE PER UNIT
$150.00
SALES VOLUME PER PERIOD (UNITS)
1,000
TOTAL SALES
$150,000.00
VARIABLE COSTS
COMMISSION PER UNIT
$4.00
DIRECT MATERIAL PER UNIT
$87.00
SHIPPING PER UNIT
$5.00
SUPPLIES PER UNIT
$1.20
OTHER VARIABLE COSTS PER UNIT
$3.40
VARIABLE COSTS PER UNIT
$100.60
BREAKEVEN ANALYSIS
TOTAL VARIABLE COSTS
$100,600.00
UNIT CONTRIBUTION MARGIN
49.40
GROSS MARGIN
$49,400.00
FIXED COSTS PER PERIOD
ADMINISTRATIVE COSTS
$15,000.00
INSURANCE
$12,000.00
PROPERTY TAX
$1,800.00
RENT
$8,000.00
OTHER FIXED COSTS
$750.00
TOTAL FIXED COSTS PER PERIOD
$37,550.00
NET PROFIT (LOSS)
$11,850.00
RESULTS
BREAKEVEN POINT (UNITS):
760.12
SALES VOLUME ANALYSIS:
SALES VOLUME PER PERIOD (UNITS)
0
100
200
300
400
500
600
700
800
900
1,000
SALES PRICE PER UNIT
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
FIXED COSTS PER PERIOD
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
VARIABLE COSTS
$0.00
$10,060.00
$20,120.00
$30,180.00
$40,240.00
$50,300.00
$60,360.00
$70,420.00
$80,480.00
$90,540.00
$100,600.00
TOTAL COSTS
$37,550.00
$47,610.00
$57,670.00
$67,730.00
$77,790.00
$87,850.00
$97,910.00
$107,970.00
$118,030.00
$128,090.00
$138,150.00
TOTAL SALES
$0.00
$15,000.00
$30,000.00
$45,000.00
$60,000.00
$75,000.00
$90,000.00
$105,000.00
$120,000.00
$135,000.00
$150,000.00
NET PROFIT (LOSS)
($37,550.00)
($32,610.00)
($27,670.00)
($22,730.00)
($17,790.00)
($12,850.00)
($7,910.00)
($2,970.00)
$1,970.00
$6,910.00
$11,850.00

The Bootstrap Spreadsheet control provides the following features.

  • A fully adaptive visual interface rendered using Bootstrap-powered markup
  • The ability to insert pictures into worksheets
  • The ability to insert and calculate formulas in a manner similar to Microsoft Excel
  • The ability to insert professional-looking charts that make it easier to understand large quantities of data by visualizing the relationship between different data series
  • The of use of Excel inspired comments - additional informational texts for individual cells
Screen Size
Color Themes
Demo QR Code
Calibri