KPI Dashboard
This example showcases a key performance indicator (KPI) dashboard built with a JavaScript spreadsheet UI. It includes embedded charts and progress bars for budget tracking and revenue insights, demonstrating how spreadsheet components can drive executive reporting tools.
<html>
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@jspreadsheet/charts/dist/style.min.css" type="text/css" />
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@lemonadejs/studio/dist/style.min.css" type="text/css" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<script src="https://cdn.jsdelivr.net/npm/lemonadejs/dist/lemonade.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@lemonadejs/studio/dist/index.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/charts/dist/index.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/chart.umd.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/[email protected]/dist/index.min.js"></script>
<div id="spreadsheet"></div>
<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('MDBhOTAxYjc3Zjk2NDk2NGNmOWI3ZDI2ZTZmYjlmOWQyZTU5YTc4ZjNhMDg0YmJlNmYwYmNjYTMxMDIyYzBjYjViY2QzYjlkMWE5MmY4ZjEwNmRhYmY2MmZhZGI0NDQ4MjlhMGZlNmUwMmIzMzQyZTcyNjcwNjVjNDQ5NzVlYjIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
jspreadsheet.setExtensions({ formula, charts });
// Create the spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
"style": [
"font-size: 29px;font-weight: bold;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"font-size: 16px;font-family: Arial;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;border-bottom: 2px dashed #70AD47;",
"font-size: 29px;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #70AD47;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #009844;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #2E75B6;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #806000;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 16px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #92D050;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #79AE40;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #5B9BD5;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D6A000;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #E2F0D9;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D0E08D;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #DEEBF7;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFF2CC;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #00B050;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #009844;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #385724;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #806000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 16px;font-family: Arial;color: #000000;text-align: center;",
"font-size: 16px;font-weight: bold;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;text-align: center;",
"",
"background-color:#d7ccc8",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff8a65",
"font-size:16px;font-family:Arial;color:#000000;background-color:#f57c00",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff9800",
"font-size:16px;font-family:Arial;color:#000000;background-color:#fb8c00",
"background-color:#70AD47;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#2E75B6;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#2E75B6;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid black;border-top:1px solid black;border-left:1px solid black",
"background-color:#92D050;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#5B9BD5;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#5B9BD5;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid black;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#00B050;text-align:center;vertical-align:middle;border-bottom:1px solid black;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#385724;text-align:center;vertical-align:middle;border-bottom:1px solid black;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#385724;text-align:center;vertical-align:middle;border-right:1px solid black;border-bottom:1px solid black;border-top:1px solid black;border-left:1px solid black",
"background-color:#70AD47;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"background-color:#2E75B6;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"background-color:#2E75B6;font-size:19px;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #eeeeee;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"background-color:#92D050;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"background-color:#5B9BD5;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"background-color:#5B9BD5;font-size:13px;font-weight:bold;font-family:Century Gothic;color:#FFFFFF;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #eeeeee;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#00B050;text-align:center;vertical-align:middle;border-bottom:1px solid #eeeeee;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#385724;text-align:center;vertical-align:middle;border-bottom:1px solid #eeeeee;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee",
"font-size:13px;font-weight:bold;font-family:Century Gothic;color:#385724;text-align:center;vertical-align:middle;border-right:1px solid #eeeeee;border-bottom:1px solid #eeeeee;border-top:1px solid #eeeeee;border-left:1px solid #eeeeee"
],
"worksheets": [
{
"data": [
["KPI DASHBOARD DATA", "", "", "", "", "", "", "", "", "", "", ""],
[
"Products",
"",
"Budget",
"",
"",
"Net Expenses",
"",
"Revenue",
"",
"",
"Profit Margins",
""
],
[
"N.º",
"NAME",
"TARGET",
"ACTUAL",
"REMAINING",
"EXTRA",
"TOTAL",
"TARGET",
"ACTUAL",
"REMAINING",
"GROSS",
"NET"
],
[
1,
"PRODUCT 1",
160344,
259757.28000000003,
"=(D4-C4)",
16007,
"=F4+E4",
500916,
1073357,
"=H4-I4",
"=(J4-E4)/J4",
"=(J4-H4)/J4"
],
[
2,
"PRODUCT 2",
200816,
311264.8,
"=(D5-C5)",
14816,
"=F5+E5",
215534,
878162,
"=H5-I5",
"=(J5-E5)/J5",
"=(J5-H5)/J5"
],
[
3,
"PRODUCT 3",
170989,
237674.71,
"=(D6-C6)",
17057,
"=F6+E6",
820719,
1193784,
"=H6-I6",
"=(J6-E6)/J6",
"=(J6-H6)/J6"
],
[
4,
"PRODUCT 4",
281053,
61831.66,
"=(D7-C7)",
17459,
"=F7+E7",
620242,
420345,
"=H7-I7",
"=(J7-E7)/J7",
"=(J7-H7)/J7"
],
[
5,
"PRODUCT 5",
262319,
459058.25,
"=(D8-C8)",
13985,
"=F8+E8",
821177,
1175811,
"=H8-I8",
"=(J8-E8)/J8",
"=(J8-H8)/J8"
],
[
6,
"PRODUCT 6",
206881,
157229.56,
"=(D9-C9)",
11183,
"=F9+E9",
901263,
1015766,
"=H9-I9",
"=(J9-E9)/J9",
"=(J9-H9)/J9"
],
[
7,
"PRODUCT 7",
130194,
213518.15999999997,
"=(D10-C10)",
17111,
"=F10+E10",
878528,
733751,
"=H10-I10",
"=(J10-E10)/J10",
"=(J10-H10)/J10"
],
[
8,
"PRODUCT 8",
208451,
214704.53,
"=(D11-C11)",
16494,
"=F11+E11",
838380,
955983,
"=H11-I11",
"=(J11-E11)/J11",
"=(J11-H11)/J11"
],
[
9,
"PRODUCT 9",
206422,
177522.91999999998,
"=(D12-C12)",
17311,
"=F12+E12",
1073157,
924095,
"=H12-I12",
"=(J12-E12)/J12",
"=(J12-H12)/J12"
],
[
10,
"PRODUCT 10",
251504,
2515.04,
"=(D13-C13)",
17315,
"=F13+E13",
941047,
1061074,
"=H13-I13",
"=(J13-E13)/J13",
"=(J13-H13)/J13"
],
[
"",
"",
"=SUM(C4:C13)",
"=SUM(D4:D13)",
"=SUM(E4:E13)",
"=SUM(F4:F13)",
"=SUM(G4:G13)",
"=SUM(H4:H13)",
"=SUM(I4:I13)",
"=SUM(J4:JK13)",
"=SUM(K4:K13)/10",
"=SUM(L4:L13)/10"
],
["", "", "", "", "", "", "", "", "", "", "", ""],
[
"",
"",
"",
"LIABILITIES / EQUITY RATIO",
"",
"",
"",
"Budget",
"",
"Revenue",
"",
""
],
[
"",
"",
"",
"CALENDAR",
"LIABILITIES",
"EQUITY",
"",
"TARGET",
"ACTUAL",
"TARGET",
"ACTUAL",
""
],
[
"",
"",
"",
2027,
3613439,
3293202,
"",
"=SUM(C4:C13)",
"=SUM(D4:D13)",
"=SUM(H4:H13)",
"=SUM(I4:I13)",
""
],
["", "", "", 2028, 3508776, 3441854, "", "", "", "", "", ""],
["", "", "", 2029, 3719457, 3531844, "", "", "", "", "", ""],
["", "", "", 2030, 3310212, 3354051, "", "", "", "", "", ""],
["", "", "", 2031, 3945202, 3476155, "", "", "", "", "", ""],
["", "", "", 2032, 3938152, 3538468, "", "", "", "", "", ""],
["", "", "", 2033, 3733706, 3727037, "", "", "", "", "", ""],
["", "", "", 2034, 3526698, 3425405, "", "", "", "", "", ""],
["", "", "", 2035, 3632971, 3734041, "", "", "", "", "", ""],
["", "", "", 2036, 3206487, 3677074, "", "", "", "", "", ""]
],
"columns": [
{ "width": 44, "type": "text", "align": "left" },
{ "width": 190, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 103, "type": "text", "align": "left" },
{ "width": 101, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 107, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" }
],
"rows": [
{ "height": 67 },
{ "height": 53 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 52 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 }
],
"cells": {
"C4": { "format": "$#,##0" },
"D4": { "format": "$#,##0" },
"E4": { "format": "$#,##0" },
"F4": { "format": "$#,##0" },
"G4": { "format": "$#,##0" },
"H4": { "format": "$#,##0" },
"I4": { "format": "$#,##0" },
"J4": { "format": "$#,##0" },
"K4": { "format": "0%" },
"L4": { "format": "0%" },
"C5": { "format": "$#,##0" },
"D5": { "format": "$#,##0" },
"E5": { "format": "$#,##0" },
"F5": { "format": "$#,##0" },
"G5": { "format": "$#,##0" },
"H5": { "format": "$#,##0" },
"I5": { "format": "$#,##0" },
"J5": { "format": "$#,##0" },
"K5": { "format": "0%" },
"L5": { "format": "0%" },
"C6": { "format": "$#,##0" },
"D6": { "format": "$#,##0" },
"E6": { "format": "$#,##0" },
"F6": { "format": "$#,##0" },
"G6": { "format": "$#,##0" },
"H6": { "format": "$#,##0" },
"I6": { "format": "$#,##0" },
"J6": { "format": "$#,##0" },
"K6": { "format": "0%" },
"L6": { "format": "0%" },
"C7": { "format": "$#,##0" },
"D7": { "format": "$#,##0" },
"E7": { "format": "$#,##0" },
"F7": { "format": "$#,##0" },
"G7": { "format": "$#,##0" },
"H7": { "format": "$#,##0" },
"I7": { "format": "$#,##0" },
"J7": { "format": "$#,##0" },
"K7": { "format": "0%" },
"L7": { "format": "0%" },
"C8": { "format": "$#,##0" },
"D8": { "format": "$#,##0" },
"E8": { "format": "$#,##0" },
"F8": { "format": "$#,##0" },
"G8": { "format": "$#,##0" },
"H8": { "format": "$#,##0" },
"I8": { "format": "$#,##0" },
"J8": { "format": "$#,##0" },
"K8": { "format": "0%" },
"L8": { "format": "0%" },
"C9": { "format": "$#,##0" },
"D9": { "format": "$#,##0" },
"E9": { "format": "$#,##0" },
"F9": { "format": "$#,##0" },
"G9": { "format": "$#,##0" },
"H9": { "format": "$#,##0" },
"I9": { "format": "$#,##0" },
"J9": { "format": "$#,##0" },
"K9": { "format": "0%" },
"L9": { "format": "0%" },
"C10": { "format": "$#,##0" },
"D10": { "format": "$#,##0" },
"E10": { "format": "$#,##0" },
"F10": { "format": "$#,##0" },
"G10": { "format": "$#,##0" },
"H10": { "format": "$#,##0" },
"I10": { "format": "$#,##0" },
"J10": { "format": "$#,##0" },
"K10": { "format": "0%" },
"L10": { "format": "0%" },
"C11": { "format": "$#,##0" },
"D11": { "format": "$#,##0" },
"E11": { "format": "$#,##0" },
"F11": { "format": "$#,##0" },
"G11": { "format": "$#,##0" },
"H11": { "format": "$#,##0" },
"I11": { "format": "$#,##0" },
"J11": { "format": "$#,##0" },
"K11": { "format": "0%" },
"L11": { "format": "0%" },
"C12": { "format": "$#,##0" },
"D12": { "format": "$#,##0" },
"E12": { "format": "$#,##0" },
"F12": { "format": "$#,##0" },
"G12": { "format": "$#,##0" },
"H12": { "format": "$#,##0" },
"I12": { "format": "$#,##0" },
"J12": { "format": "$#,##0" },
"K12": { "format": "0%" },
"L12": { "format": "0%" },
"C13": { "format": "$#,##0" },
"D13": { "format": "$#,##0" },
"E13": { "format": "$#,##0" },
"F13": { "format": "$#,##0" },
"G13": { "format": "$#,##0" },
"H13": { "format": "$#,##0" },
"I13": { "format": "$#,##0" },
"J13": { "format": "$#,##0" },
"K13": { "format": "0%" },
"L13": { "format": "0%" },
"C14": { "format": "$#,##0" },
"D14": { "format": "$#,##0" },
"E14": { "format": "$#,##0" },
"F14": { "format": "$#,##0" },
"G14": { "format": "$#,##0" },
"H14": { "format": "$#,##0" },
"I14": { "format": "$#,##0" },
"J14": { "format": "$#,##0" },
"K14": { "format": "0%" },
"L14": { "format": "0%" },
"D18": { "format": "0" },
"E18": { "format": "0" },
"F18": { "format": "$#,##0" },
"H18": { "format": "$#,##0" },
"I18": { "format": "$#,##0" },
"J18": { "format": "$#,##0" },
"K18": { "format": "$#,##0" },
"D19": { "format": "0" },
"E19": { "format": "0" },
"F19": { "format": "$#,##0" },
"D20": { "format": "0" },
"E20": { "format": "0" },
"F20": { "format": "$#,##0" },
"D21": { "format": "0" },
"E21": { "format": "0" },
"F21": { "format": "$#,##0" },
"D22": { "format": "0" },
"E22": { "format": "0" },
"F22": { "format": "$#,##0" },
"D23": { "format": "0" },
"E23": { "format": "0" },
"F23": { "format": "$#,##0" },
"D24": { "format": "0" },
"E24": { "format": "0" },
"F24": { "format": "$#,##0" },
"D25": { "format": "0" },
"E25": { "format": "0" },
"F25": { "format": "$#,##0" },
"D26": { "format": "0" },
"E26": { "format": "0" },
"F26": { "format": "$#,##0" },
"D27": { "format": "0" },
"E27": { "format": "0" },
"F27": { "format": "$#,##0" }
},
"style": {
"A1": 3,
"B1": 3,
"C1": 3,
"D1": 3,
"E1": 3,
"F1": 3,
"G1": 3,
"H1": 3,
"I1": 3,
"J1": 3,
"K1": 1,
"L1": 1,
"A2": 4,
"B2": 5,
"C2": 6,
"D2": 6,
"E2": 6,
"F2": 7,
"G2": 7,
"H2": 8,
"I2": 8,
"J2": 8,
"K2": 9,
"L2": 9,
"A3": 10,
"B3": 11,
"C3": 12,
"D3": 12,
"E3": 12,
"F3": 13,
"G3": 13,
"H3": 14,
"I3": 14,
"J3": 14,
"K3": 15,
"L3": 15,
"A4": 16,
"B4": 17,
"C4": 18,
"D4": 18,
"E4": 18,
"F4": 18,
"G4": 18,
"H4": 18,
"I4": 18,
"J4": 18,
"K4": 18,
"L4": 18,
"A5": 16,
"B5": 17,
"C5": 19,
"D5": 19,
"E5": 19,
"F5": 20,
"G5": 20,
"H5": 21,
"I5": 21,
"J5": 21,
"K5": 22,
"L5": 22,
"A6": 16,
"B6": 17,
"C6": 18,
"D6": 18,
"E6": 18,
"F6": 18,
"G6": 18,
"H6": 18,
"I6": 18,
"J6": 18,
"K6": 18,
"L6": 18,
"A7": 16,
"B7": 17,
"C7": 19,
"D7": 19,
"E7": 19,
"F7": 20,
"G7": 20,
"H7": 21,
"I7": 21,
"J7": 21,
"K7": 22,
"L7": 22,
"A8": 16,
"B8": 17,
"C8": 18,
"D8": 18,
"E8": 18,
"F8": 18,
"G8": 18,
"H8": 18,
"I8": 18,
"J8": 18,
"K8": 18,
"L8": 18,
"A9": 16,
"B9": 17,
"C9": 19,
"D9": 19,
"E9": 19,
"F9": 20,
"G9": 20,
"H9": 21,
"I9": 21,
"J9": 21,
"K9": 22,
"L9": 22,
"A10": 16,
"B10": 17,
"C10": 18,
"D10": 18,
"E10": 18,
"F10": 18,
"G10": 18,
"H10": 18,
"I10": 18,
"J10": 18,
"K10": 18,
"L10": 18,
"A11": 16,
"B11": 17,
"C11": 19,
"D11": 19,
"E11": 19,
"F11": 20,
"G11": 20,
"H11": 21,
"I11": 21,
"J11": 21,
"K11": 22,
"L11": 22,
"A12": 16,
"B12": 17,
"C12": 18,
"D12": 18,
"E12": 18,
"F12": 18,
"G12": 18,
"H12": 18,
"I12": 18,
"J12": 18,
"K12": 18,
"L12": 18,
"A13": 16,
"B13": 17,
"C13": 19,
"D13": 19,
"E13": 19,
"F13": 20,
"G13": 20,
"H13": 21,
"I13": 21,
"J13": 21,
"K13": 22,
"L13": 22,
"A14": 23,
"B14": 24,
"C14": 25,
"D14": 25,
"E14": 25,
"F14": 26,
"G14": 26,
"H14": 27,
"I14": 27,
"J14": 27,
"K14": 28,
"L14": 28,
"C15": 1,
"D15": 1,
"E15": 1,
"F15": 1,
"G15": 1,
"H15": 1,
"I15": 1,
"J15": 1,
"K15": 1,
"L15": 1,
"C16": 1,
"D16": 46,
"E16": 46,
"F16": 46,
"G16": 1,
"H16": 56,
"I16": 56,
"J16": 57,
"K16": 58,
"L16": 1,
"C17": 1,
"D17": 32,
"E17": 32,
"F17": 33,
"G17": 1,
"H17": 59,
"I17": 59,
"J17": 60,
"K17": 61,
"L17": 1,
"C18": 1,
"D18": 34,
"E18": 34,
"F18": 18,
"G18": 1,
"H18": 62,
"I18": 62,
"J18": 63,
"K18": 64,
"L18": 1,
"C19": 1,
"D19": 35,
"E19": 35,
"F19": 36,
"G19": 1,
"H19": 37,
"I19": 37,
"J19": 1,
"K19": 1,
"L19": 1,
"C20": 1,
"D20": 34,
"E20": 34,
"F20": 18,
"G20": 1,
"H20": 37,
"I20": 37,
"J20": 38,
"C21": 1,
"D21": 35,
"E21": 35,
"F21": 36,
"G21": 1,
"H21": 37,
"I21": 37,
"J21": 38,
"M21": 39,
"D22": 34,
"E22": 34,
"F22": 18,
"H22": 40,
"I22": 40,
"J22": 38,
"D23": 35,
"E23": 35,
"F23": 36,
"H23": 37,
"I23": 40,
"J23": 38,
"D24": 34,
"E24": 34,
"F24": 18,
"H24": 40,
"I24": 40,
"J24": 38,
"D25": 35,
"E25": 35,
"F25": 36,
"J25": 38,
"D26": 34,
"E26": 34,
"F26": 18,
"J26": 38,
"D27": 35,
"E27": 35,
"F27": 36,
"J27": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Data",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [12, 27],
"mergeCells": {
"A1": [10, 1],
"A2": [2, 1],
"C2": [3, 1],
"F2": [2, 1],
"H2": [3, 1],
"K2": [2, 1],
"D16": [3, 1]
},
"worksheetId": "50f4c91c-5e48-493b-8abe-08096772c049",
"meta": {},
"comments": {},
"cache": {},
"media": []
},
{
"data": [
[
"",
"KPI DASHBOARD",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
[null, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "type": "text", "width": 15, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 38, "align": "left" }
],
"rows": [
{ "height": 77 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 118, "id": null },
{ "height": 71, "id": null },
{ "height": 58, "id": null },
{ "height": 51, "id": null },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 36 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 29 },
{ "height": 190 },
{ "height": 147 },
{ "height": 127 },
{ "height": 118 },
{ "height": 30 }
],
"cells": {},
"style": {
"B1": 0,
"C1": 0,
"D1": 0,
"E1": 0,
"F1": 0,
"G1": 0,
"H1": 0,
"I1": 0,
"J1": 0,
"K1": 1,
"L1": 1,
"M1": 1,
"A31": 41,
"B31": 39,
"C31": 39,
"D31": 39,
"E31": 39,
"F31": 39,
"G31": 39,
"H31": 39,
"I31": 39,
"J31": 39,
"K31": 39,
"L31": 39,
"M31": 39,
"N31": 39,
"O31": 39,
"P31": 39,
"Q31": 39
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [17, 42],
"mergeCells": {
"B1": [9, 1],
"B17": [7, 4],
"J17": [7, 4],
"B38": [15, 4]
},
"media": [
{
"id": "19bb08c4-6a32-441b-90e5-9db66be86313",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!C3:E13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "BUDGET",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#92D050", "xAxis": "top" },
{ "color": "#00B050", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "display": false }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"max": 500000,
"forceTheLimits": true
}
}
},
"cellAnchor": "B2",
"left": 0,
"top": 0,
"width": 434,
"height": 408,
"zIndex": 3,
"rotate": 0
},
{
"id": "afed067c-148d-42e1-aff6-49c328d7a22c",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!H3:J13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "REVENUE",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#B4C7E7", "xAxis": "top" },
{ "color": "#2E75B6", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "display": false }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"min": 0,
"max": 1250000,
"forceTheLimits": true
}
}
},
"cellAnchor": "J2",
"left": 0,
"top": 0,
"width": 421,
"height": 408,
"zIndex": 3,
"rotate": 0
},
{
"type": "chart",
"width": 434,
"height": 300,
"options": {
"type": "bar",
"range": "'KPI DATA'!H17:I18",
"title": { "text": "TOTAL BUDGET", "position": "top" },
"legend": { "position": "bottom", "display": true },
"series": [
{ "color": "#B4C7E7", "xAxis": "top" },
{ "color": "#2E75B6", "xAxis": "top" }
]
},
"id": "717cc7d8-abbe-4842-b394-b64ad59ed550",
"top": 0,
"left": 0,
"cellAnchor": "B17",
"zIndex": 4,
"rotate": 0
},
{
"type": "chart",
"width": 420,
"height": 300,
"options": {
"type": "bar",
"range": "'KPI DATA'!J17:K18",
"title": { "text": "TOTAL REVENUE", "position": "top" },
"legend": { "position": "bottom", "display": true },
"series": [
{ "color": "#92D050", "xAxis": "top" },
{ "color": "#00B050", "xAxis": "top" }
]
},
"id": "fd82c8d4-0409-4eab-8033-e09f7bc9d8cd",
"top": 0,
"left": 0,
"cellAnchor": "J17",
"zIndex": 4,
"rotate": 0
},
{
"id": "df9ad462-1f05-46af-8b3f-d3d2a11e1212",
"type": "chart",
"options": {
"type": "line",
"range": "'KPI DATA'!K3:L13",
"labels": 0,
"title": {
"text": "PROFIT MARGINS",
"position": "top",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{
"drawNullValues": false,
"borderColor": "#4472C4",
"line": { "width": 1 },
"color": "#00B0F0",
"point": { "style": "circle", "radius": 7 }
},
{
"drawNullValues": false,
"borderColor": "#FFC000",
"line": { "width": 1 },
"color": "#ED7D31",
"point": { "style": "circle", "radius": 5.5 }
}
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "display": false }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 16, "color": "#000000" },
"forceTheLimits": true
}
}
},
"cellAnchor": "B22",
"left": 0,
"top": 0,
"width": 873,
"height": 444,
"zIndex": 3,
"rotate": 0
},
{
"type": "chart",
"width": 870,
"height": 584,
"options": {
"type": "column",
"range": "'KPI DATA'!D17:F27",
"labels": 0,
"datasets": [1, 2],
"title": {
"text": "LIABILITIES vs EQUITY per Year",
"position": "top"
},
"legend": { "position": "bottom", "display": true },
"series": [
{ "color": "#ED7D31", "xAxis": "bottom" },
{ "color": "#00B050", "xAxis": "bottom" }
]
},
"id": "a1699cf7-e71c-45d5-91a2-4a47c195bb33",
"top": 0,
"left": 0,
"cellAnchor": "B38",
"zIndex": 4,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "cb45f57c-907c-4070-8cc5-b7b0df77babe",
"meta": {},
"comments": {},
"cache": {}
}
],
"plugins": {},
"validations": [],
"definedNames": {},
"bar": true,
"toolbar": true,
onload: function(instance) {
instance.openWorksheet(1);
}
});
</script>
</html>
import React, { useEffect, useRef } from 'react';
import jspreadsheet from 'jspreadsheet';
import formula from '@jspreadsheet/formula-pro';
import charts from '@jspreadsheet/charts';
import studio from '@lemonadejs/studio';
import chartjs from '@jspreadsheet/formula-charts';
import '@lemonadejs/studio';
import '@lemonadejs/studio/dist/style.css';
import 'jsuites/dist/jsuites.css';
import 'jspreadsheet/dist/jspreadsheet.css';
import '@jspreadsheet/formula-charts';
import '@jspreadsheet/charts/dist/style.css';
import './App.css';
// Set your JSS license key (The following key only works for one day)
const license = 'MDBhOTAxYjc3Zjk2NDk2NGNmOWI3ZDI2ZTZmYjlmOWQyZTU5YTc4ZjNhMDg0YmJlNmYwYmNjYTMxMDIyYzBjYjViY2QzYjlkMWE5MmY4ZjEwNmRhYmY2MmZhZGI0NDQ4MjlhMGZlNmUwMmIzMzQyZTcyNjcwNjVjNDQ5NzVlYjIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5';
export default function App() {
const spreadsheetRef = useRef(null);
useEffect(() => {
jspreadsheet.setLicense(license);
jspreadsheet.setExtensions({ formula, charts });
const instance = jspreadsheet(spreadsheetRef.current, {
"style": [
"font-size: 29px;font-weight: bold;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"font-size: 16px;font-family: Arial;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;border-bottom: 2px dashed #70AD47;",
"font-size: 29px;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #70AD47;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #009844;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #2E75B6;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #806000;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 16px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #92D050;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #79AE40;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #5B9BD5;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D6A000;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #E2F0D9;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D0E08D;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #DEEBF7;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFF2CC;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #00B050;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #009844;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #385724;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #806000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 16px;font-family: Arial;color: #000000;text-align: center;",
"font-size: 16px;font-weight: bold;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;text-align: center;",
"",
"background-color:#d7ccc8",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff8a65",
"font-size:16px;font-family:Arial;color:#000000;background-color:#f57c00",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff9800",
"font-size:16px;font-family:Arial;color:#000000;background-color:#fb8c00"
],
"worksheets": [
{
"data": [
["KPI DASHBOARD DATA", "", "", "", "", "", "", "", "", "", "", ""],
[
"Products",
"",
"Budget",
"",
"",
"Net Expenses",
"",
"Revenue",
"",
"",
"Profit Margins",
""
],
[
"N.º",
"NAME",
"TARGET",
"ACTUAL",
"REMAINING",
"EXTRA",
"TOTAL",
"TARGET",
"ACTUAL",
"REMAINING",
"GROSS",
"NET"
],
[
1,
"PRODUCT 1",
160344,
259757.28000000003,
"=(D4-E4)",
16007,
"=G4+E4",
1100916,
1073357,
"=J4-I4",
"=(J4-E4)/J4",
"=(J4-H4)/J4"
],
[
2,
"PRODUCT 2",
200816,
311264.8,
"=(D5-E5)",
14816,
"=G5+E5",
215534,
878162,
"=J5-I5",
"=(J5-E5)/J5",
"=(J5-H5)/J5"
],
[
3,
"PRODUCT 3",
170989,
237674.71,
"=(D6-E6)",
17057,
"=G6+E6",
820719,
1193784,
"=J6-I6",
"=(J6-E6)/J6",
"=(J6-H6)/J6"
],
[
4,
"PRODUCT 4",
281053,
61831.66,
"=(D7-E7)",
17459,
"=G7+E7",
620242,
420345,
"=J7-I7",
"=(J7-E7)/J7",
"=(J7-H7)/J7"
],
[
5,
"PRODUCT 5",
262319,
459058.25,
"=(D8-E8)",
13985,
"=G8+E8",
821177,
1175811,
"=J8-I8",
"=(J8-E8)/J8",
"=(J8-H8)/J8"
],
[
6,
"PRODUCT 6",
206881,
157229.56,
"=(D9-E9)",
11183,
"=G9+E9",
901263,
1015766,
"=J9-I9",
"=(J9-E9)/J9",
"=(J9-H9)/J9"
],
[
7,
"PRODUCT 7",
130194,
213518.15999999997,
"=(D10-E10)",
17111,
"=G10+E10",
878528,
733751,
"=J10-I10",
"=(J10-E10)/J10",
"=(J10-H10)/J10"
],
[
8,
"PRODUCT 8",
208451,
214704.53,
"=(D11-E11)",
16494,
"=G11+E11",
838380,
955983,
"=J11-I11",
"=(J11-E11)/J11",
"=(J11-H11)/J11"
],
[
9,
"PRODUCT 9",
206422,
177522.91999999998,
"=(D12-E12)",
17311,
"=G12+E12",
1073157,
924095,
"=J12-I12",
"=(J12-E12)/J12",
"=(J12-H12)/J12"
],
[
10,
"PRODUCT 10",
251504,
2515.04,
"=(D13-E13)",
17315,
"=G13+E13",
1141047,
1061074,
"=J13-I13",
"=(J13-E13)/J13",
"=(J13-H13)/J13"
],
[
"",
"",
"=SUM(C4:C13)",
"=SUM(D4:D13)",
"=SUM(E4:E13)",
"=SUM(F4:F13)",
"=SUM(G4:G13)",
"=SUM(H4:H13)",
"=SUM(I4:I13)",
"=SUM(J4:JK13)",
"=SUM(K4:K13)/10",
"=SUM(L4:L13)/10"
],
["", "", "", "", "", "", "", "", "", "", "", ""],
[
"",
"",
"",
"LIABILITIES / EQUITY RATIO",
"",
"",
"",
"",
"",
"",
"",
""
],
[
"",
"",
"",
"CALENDAR",
"LIABILITIES",
"EQUITY",
"",
"",
"",
"",
"",
""
],
["", "", "", 2027, 3613439, 3293202, "", "", "", "", "", ""],
["", "", "", 2028, 3508776, 3441854, "", "", "", "", "", ""],
["", "", "", 2029, 3719457, 3531844, "", "", "", "", "", ""],
["", "", "", 2030, 3310212, 3354051, "", "", "", "", "", ""],
["", "", "", 2031, 3945202, 3476155, "", "", "", "", "", ""],
["", "", "", 2032, 3938152, 3538468, "", "", "", "", "", ""],
["", "", "", 2033, 3733706, 3727037, "", "", "", "", "", ""],
["", "", "", 2034, 3526698, 3425405, "", "", "", "", "", ""],
["", "", "", 2035, 3632971, 3734041, "", "", "", "", "", ""],
["", "", "", 2036, 3206487, 3677074, "", "", "", "", "", ""]
],
"columns": [
{ "width": 44, "type": "text", "align": "left" },
{ "width": 190, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 103, "type": "text", "align": "left" },
{ "width": 101, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 107, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" }
],
"rows": [
{ "height": 67 },
{ "height": 53 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 52 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 }
],
"cells": {
"C4": { "format": "$#,##0" },
"D4": { "format": "$#,##0" },
"E4": { "format": "$#,##0" },
"F4": { "format": "$#,##0" },
"G4": { "format": "$#,##0" },
"H4": { "format": "$#,##0" },
"I4": { "format": "$#,##0" },
"J4": { "format": "$#,##0" },
"K4": { "format": "0%" },
"L4": { "format": "0%" },
"C5": { "format": "$#,##0" },
"D5": { "format": "$#,##0" },
"E5": { "format": "$#,##0" },
"F5": { "format": "$#,##0" },
"G5": { "format": "$#,##0" },
"H5": { "format": "$#,##0" },
"I5": { "format": "$#,##0" },
"J5": { "format": "$#,##0" },
"K5": { "format": "0%" },
"L5": { "format": "0%" },
"C6": { "format": "$#,##0" },
"D6": { "format": "$#,##0" },
"E6": { "format": "$#,##0" },
"F6": { "format": "$#,##0" },
"G6": { "format": "$#,##0" },
"H6": { "format": "$#,##0" },
"I6": { "format": "$#,##0" },
"J6": { "format": "$#,##0" },
"K6": { "format": "0%" },
"L6": { "format": "0%" },
"C7": { "format": "$#,##0" },
"D7": { "format": "$#,##0" },
"E7": { "format": "$#,##0" },
"F7": { "format": "$#,##0" },
"G7": { "format": "$#,##0" },
"H7": { "format": "$#,##0" },
"I7": { "format": "$#,##0" },
"J7": { "format": "$#,##0" },
"K7": { "format": "0%" },
"L7": { "format": "0%" },
"C8": { "format": "$#,##0" },
"D8": { "format": "$#,##0" },
"E8": { "format": "$#,##0" },
"F8": { "format": "$#,##0" },
"G8": { "format": "$#,##0" },
"H8": { "format": "$#,##0" },
"I8": { "format": "$#,##0" },
"J8": { "format": "$#,##0" },
"K8": { "format": "0%" },
"L8": { "format": "0%" },
"C9": { "format": "$#,##0" },
"D9": { "format": "$#,##0" },
"E9": { "format": "$#,##0" },
"F9": { "format": "$#,##0" },
"G9": { "format": "$#,##0" },
"H9": { "format": "$#,##0" },
"I9": { "format": "$#,##0" },
"J9": { "format": "$#,##0" },
"K9": { "format": "0%" },
"L9": { "format": "0%" },
"C10": { "format": "$#,##0" },
"D10": { "format": "$#,##0" },
"E10": { "format": "$#,##0" },
"F10": { "format": "$#,##0" },
"G10": { "format": "$#,##0" },
"H10": { "format": "$#,##0" },
"I10": { "format": "$#,##0" },
"J10": { "format": "$#,##0" },
"K10": { "format": "0%" },
"L10": { "format": "0%" },
"C11": { "format": "$#,##0" },
"D11": { "format": "$#,##0" },
"E11": { "format": "$#,##0" },
"F11": { "format": "$#,##0" },
"G11": { "format": "$#,##0" },
"H11": { "format": "$#,##0" },
"I11": { "format": "$#,##0" },
"J11": { "format": "$#,##0" },
"K11": { "format": "0%" },
"L11": { "format": "0%" },
"C12": { "format": "$#,##0" },
"D12": { "format": "$#,##0" },
"E12": { "format": "$#,##0" },
"F12": { "format": "$#,##0" },
"G12": { "format": "$#,##0" },
"H12": { "format": "$#,##0" },
"I12": { "format": "$#,##0" },
"J12": { "format": "$#,##0" },
"K12": { "format": "0%" },
"L12": { "format": "0%" },
"C13": { "format": "$#,##0" },
"D13": { "format": "$#,##0" },
"E13": { "format": "$#,##0" },
"F13": { "format": "$#,##0" },
"G13": { "format": "$#,##0" },
"H13": { "format": "$#,##0" },
"I13": { "format": "$#,##0" },
"J13": { "format": "$#,##0" },
"K13": { "format": "0%" },
"L13": { "format": "0%" },
"C14": { "format": "$#,##0" },
"D14": { "format": "$#,##0" },
"E14": { "format": "$#,##0" },
"F14": { "format": "$#,##0" },
"G14": { "format": "$#,##0" },
"H14": { "format": "$#,##0" },
"I14": { "format": "$#,##0" },
"J14": { "format": "$#,##0" },
"K14": { "format": "0%" },
"L14": { "format": "0%" },
"D18": { "format": "0" },
"E18": { "format": "0" },
"F18": { "format": "$#,##0" },
"D19": { "format": "0" },
"E19": { "format": "0" },
"F19": { "format": "$#,##0" },
"D20": { "format": "0" },
"E20": { "format": "0" },
"F20": { "format": "$#,##0" },
"D21": { "format": "0" },
"E21": { "format": "0" },
"F21": { "format": "$#,##0" },
"D22": { "format": "0" },
"E22": { "format": "0" },
"F22": { "format": "$#,##0" },
"D23": { "format": "0" },
"E23": { "format": "0" },
"F23": { "format": "$#,##0" },
"D24": { "format": "0" },
"E24": { "format": "0" },
"F24": { "format": "$#,##0" },
"D25": { "format": "0" },
"E25": { "format": "0" },
"F25": { "format": "$#,##0" },
"D26": { "format": "0" },
"E26": { "format": "0" },
"F26": { "format": "$#,##0" },
"D27": { "format": "0" },
"E27": { "format": "0" },
"F27": { "format": "$#,##0" }
},
"style": {
"A1": 3,
"B1": 3,
"C1": 3,
"D1": 3,
"E1": 3,
"F1": 3,
"G1": 3,
"H1": 3,
"I1": 3,
"J1": 3,
"K1": 1,
"L1": 1,
"A2": 4,
"B2": 5,
"C2": 6,
"D2": 6,
"E2": 6,
"F2": 7,
"G2": 7,
"H2": 8,
"I2": 8,
"J2": 8,
"K2": 9,
"L2": 9,
"A3": 10,
"B3": 11,
"C3": 12,
"D3": 12,
"E3": 12,
"F3": 13,
"G3": 13,
"H3": 14,
"I3": 14,
"J3": 14,
"K3": 15,
"L3": 15,
"A4": 16,
"B4": 17,
"C4": 18,
"D4": 18,
"E4": 18,
"F4": 18,
"G4": 18,
"H4": 18,
"I4": 18,
"J4": 18,
"K4": 18,
"L4": 18,
"A5": 16,
"B5": 17,
"C5": 19,
"D5": 19,
"E5": 19,
"F5": 20,
"G5": 20,
"H5": 21,
"I5": 21,
"J5": 21,
"K5": 22,
"L5": 22,
"A6": 16,
"B6": 17,
"C6": 18,
"D6": 18,
"E6": 18,
"F6": 18,
"G6": 18,
"H6": 18,
"I6": 18,
"J6": 18,
"K6": 18,
"L6": 18,
"A7": 16,
"B7": 17,
"C7": 19,
"D7": 19,
"E7": 19,
"F7": 20,
"G7": 20,
"H7": 21,
"I7": 21,
"J7": 21,
"K7": 22,
"L7": 22,
"A8": 16,
"B8": 17,
"C8": 18,
"D8": 18,
"E8": 18,
"F8": 18,
"G8": 18,
"H8": 18,
"I8": 18,
"J8": 18,
"K8": 18,
"L8": 18,
"A9": 16,
"B9": 17,
"C9": 19,
"D9": 19,
"E9": 19,
"F9": 20,
"G9": 20,
"H9": 21,
"I9": 21,
"J9": 21,
"K9": 22,
"L9": 22,
"A10": 16,
"B10": 17,
"C10": 18,
"D10": 18,
"E10": 18,
"F10": 18,
"G10": 18,
"H10": 18,
"I10": 18,
"J10": 18,
"K10": 18,
"L10": 18,
"A11": 16,
"B11": 17,
"C11": 19,
"D11": 19,
"E11": 19,
"F11": 20,
"G11": 20,
"H11": 21,
"I11": 21,
"J11": 21,
"K11": 22,
"L11": 22,
"A12": 16,
"B12": 17,
"C12": 18,
"D12": 18,
"E12": 18,
"F12": 18,
"G12": 18,
"H12": 18,
"I12": 18,
"J12": 18,
"K12": 18,
"L12": 18,
"A13": 16,
"B13": 17,
"C13": 19,
"D13": 19,
"E13": 19,
"F13": 20,
"G13": 20,
"H13": 21,
"I13": 21,
"J13": 21,
"K13": 22,
"L13": 22,
"A14": 23,
"B14": 24,
"C14": 25,
"D14": 25,
"E14": 25,
"F14": 26,
"G14": 26,
"H14": 27,
"I14": 27,
"J14": 27,
"K14": 28,
"L14": 28,
"C15": 1,
"D15": 1,
"E15": 1,
"F15": 1,
"G15": 1,
"H15": 1,
"I15": 1,
"J15": 1,
"K15": 1,
"L15": 1,
"C16": 1,
"D16": 46,
"E16": 46,
"F16": 46,
"G16": 1,
"H16": 1,
"I16": 1,
"J16": 1,
"K16": 1,
"L16": 1,
"C17": 1,
"D17": 32,
"E17": 32,
"F17": 33,
"G17": 1,
"H17": 1,
"I17": 1,
"J17": 1,
"K17": 1,
"L17": 1,
"C18": 1,
"D18": 34,
"E18": 34,
"F18": 18,
"G18": 1,
"H18": 1,
"I18": 1,
"J18": 1,
"K18": 1,
"L18": 1,
"C19": 1,
"D19": 35,
"E19": 35,
"F19": 36,
"G19": 1,
"H19": 37,
"I19": 37,
"J19": 1,
"K19": 1,
"L19": 1,
"C20": 1,
"D20": 34,
"E20": 34,
"F20": 18,
"G20": 1,
"H20": 37,
"I20": 37,
"J20": 38,
"C21": 1,
"D21": 35,
"E21": 35,
"F21": 36,
"G21": 1,
"H21": 37,
"I21": 37,
"J21": 38,
"M21": 39,
"D22": 34,
"E22": 34,
"F22": 18,
"H22": 40,
"I22": 40,
"J22": 38,
"D23": 35,
"E23": 35,
"F23": 36,
"H23": 37,
"I23": 40,
"J23": 38,
"D24": 34,
"E24": 34,
"F24": 18,
"H24": 40,
"I24": 40,
"J24": 38,
"D25": 35,
"E25": 35,
"F25": 36,
"J25": 38,
"D26": 34,
"E26": 34,
"F26": 18,
"J26": 38,
"D27": 35,
"E27": 35,
"F27": 36,
"J27": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Data",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [12, 27],
"mergeCells": {
"A1": [10, 1],
"A2": [2, 1],
"C2": [3, 1],
"F2": [2, 1],
"H2": [3, 1],
"K2": [2, 1],
"D16": [3, 1],
"H16": [5, 6]
},
"worksheetId": "50f4c91c-5e48-493b-8abe-08096772c049",
"meta": {},
"comments": {},
"cache": {}
},
{
"data": [
[
"",
"KPI DASHBOARD",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
[
null,
"=CHART('bar',['Target','Actual'],[{'label':'TOTAL BUDGET','data':('KPI Data'!D14:E14),'backgroundColor':['#00b04f','#92d14f'],'disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL BUDGET','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':FALSE}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
"",
"",
"",
"",
"",
"",
"",
"=CHART('bar',[''],[{'label':'Actual','data':['KPI Data'!I14],'backgroundColor':'#b5c8e8','disableJssSimplification':TRUE},{'label':'Target','data':['KPI Data'!J14],'backgroundColor':'#2d73b5','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL REVENUE','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':TRUE,'labels':{'color':'#000'}}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
[
"",
"=CHART('bar',('KPI Data'!D18:D27),[{'label':'LIABILITIES','data':('KPI Data'!E18:E27),'backgroundColor':'#1a345c','disableJssSimplification':TRUE},{'label':'EQUITY','data':('KPI Data'!F18:F27),'backgroundColor':'#e64300','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'plugins':{'legend':{'display':TRUE,'labels':{'color':'#000'}},'title':{'display':TRUE,'text':'LIABILITIES vs EQUITY per Year','color':'#000','font':{'size':16,'weight':'bold'}}},'scales':{'x':{'stacked':FALSE,'ticks':{'color':'#000'}},'y':{'stacked':FALSE,'ticks':{'color':'#000'},'beginAtZero':TRUE}}})",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "type": "text", "width": 15, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 38, "align": "left" }
],
"rows": [
{ "height": 77 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 118, "id": null },
{ "height": 71, "id": null },
{ "height": 58, "id": null },
{ "height": 51, "id": null },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 36 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 29 },
{ "height": 190 },
{ "height": 147 },
{ "height": 127 },
{ "height": 118 },
{ "height": 30 }
],
"cells": {},
"style": {
"B1": 0,
"C1": 0,
"D1": 0,
"E1": 0,
"F1": 0,
"G1": 0,
"H1": 0,
"I1": 0,
"J1": 0,
"K1": 1,
"L1": 1,
"M1": 1,
"A31": 41,
"B31": 39,
"C31": 39,
"D31": 39,
"E31": 39,
"F31": 39,
"G31": 39,
"H31": 39,
"I31": 39,
"J31": 39,
"K31": 39,
"L31": 39,
"M31": 39,
"N31": 39,
"O31": 39,
"P31": 39,
"Q31": 39
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [17, 42],
"mergeCells": {
"B1": [9, 1],
"B17": [7, 4],
"J17": [7, 4],
"B38": [15, 4]
},
"media": [
{
"id": "19bb08c4-6a32-441b-90e5-9db66be86313",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!C3:E13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "BUDGET",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#92D050", "xAxis": "top" },
{ "color": "#00B050", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"max": 300000,
"forceTheLimits": true
}
}
},
"cellAnchor": "B2",
"left": 0,
"top": 5,
"width": 434,
"height": 408,
"zIndex": 3,
"rotate": 0
},
{
"id": "afed067c-148d-42e1-aff6-49c328d7a22c",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!H3:J13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "REVENUE",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#B4C7E7", "xAxis": "top" },
{ "color": "#2E75B6", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"min": 0,
"max": 1250000,
"forceTheLimits": true
}
}
},
"cellAnchor": "J2",
"left": 1,
"top": 5,
"width": 421,
"height": 409,
"zIndex": 3,
"rotate": 0
},
{
"id": "df9ad462-1f05-46af-8b3f-d3d2a11e1212",
"type": "chart",
"options": {
"type": "line",
"range": "'KPI Data'!C3:L13",
"labels": 0,
"datasets": [9, 8],
"title": {
"text": "PROFIT MARGINS",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{
"drawNullValues": false,
"borderColor": "#4472C4",
"line": { "width": 1 },
"color": "#00B0F0",
"point": { "style": "circle", "radius": 11.5 }
},
{
"drawNullValues": false,
"borderColor": "#FFC000",
"line": { "width": 1 },
"color": "#ED7D31",
"point": { "style": "circle", "radius": 11.5 }
}
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 16, "color": "#000000" },
"forceTheLimits": true
}
}
},
"cellAnchor": "A1",
"left": 22,
"top": 862,
"width": 873,
"height": 444,
"zIndex": 3,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "cb45f57c-907c-4070-8cc5-b7b0df77babe",
"meta": {},
"comments": {},
"cache": {}
}
],
"plugins": {},
"validations": [],
"definedNames": {},
"bar": true,
"toolbar": true
});
return () => {
instance?.destroy?.();
};
}, []);
return <div ref={spreadsheetRef}></div>;
}
<template>
<Spreadsheet
ref="spreadsheet"
:license="license"
:worksheets="worksheets"
:styles="globalStyle"
toolbar="true"
/>
</template>
<script>
import { Spreadsheet, Worksheet } from "@jspreadsheet/vue";
import jspreadsheet from 'jspreadsheet';
import formula from '@jspreadsheet/formula-pro';
import charts from '@jspreadsheet/charts';
import studio from '@lemonadejs/studio';
import chartjs from '@jspreadsheet/formula-charts';
import '@lemonadejs/studio';
import '@lemonadejs/studio/dist/style.css';
import 'jsuites/dist/jsuites.css';
import 'jspreadsheet/dist/jspreadsheet.css';
import '@jspreadsheet/formula-charts';
import '@jspreadsheet/charts/dist/style.css';
jspreadsheet.setLicense('MDBhOTAxYjc3Zjk2NDk2NGNmOWI3ZDI2ZTZmYjlmOWQyZTU5YTc4ZjNhMDg0YmJlNmYwYmNjYTMxMDIyYzBjYjViY2QzYjlkMWE5MmY4ZjEwNmRhYmY2MmZhZGI0NDQ4MjlhMGZlNmUwMmIzMzQyZTcyNjcwNjVjNDQ5NzVlYjIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
jspreadsheet.setExtensions({ formula });
export default {
components: { Spreadsheet, Worksheet },
data() {
return {
"globalStyle": [
"font-size: 29px;font-weight: bold;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"font-size: 16px;font-family: Arial;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;border-bottom: 2px dashed #70AD47;",
"font-size: 29px;font-family: Century Gothic;color: #595959;vertical-align: middle;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #70AD47;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #009844;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #2E75B6;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #806000;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 16px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #595959;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #92D050;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #79AE40;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #5B9BD5;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D6A000;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #E2F0D9;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #D0E08D;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #DEEBF7;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFF2CC;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #00B050;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #009844;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #385724;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #806000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 16px;font-family: Arial;color: #000000;text-align: center;",
"font-size: 16px;font-weight: bold;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;",
"font-size: 16px;font-family: Calibri;color: #000000;text-align: center;",
"",
"background-color:#d7ccc8",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff8a65",
"font-size:16px;font-family:Arial;color:#000000;background-color:#f57c00",
"font-size:16px;font-family:Arial;color:#000000;background-color:#ff9800",
"font-size:16px;font-family:Arial;color:#000000;background-color:#fb8c00"
],
"worksheets": [
{
"data": [
["KPI DASHBOARD DATA", "", "", "", "", "", "", "", "", "", "", ""],
[
"Products",
"",
"Budget",
"",
"",
"Net Expenses",
"",
"Revenue",
"",
"",
"Profit Margins",
""
],
[
"N.º",
"NAME",
"TARGET",
"ACTUAL",
"REMAINING",
"EXTRA",
"TOTAL",
"TARGET",
"ACTUAL",
"REMAINING",
"GROSS",
"NET"
],
[
1,
"PRODUCT 1",
160344,
259757.28000000003,
"=(D4-E4)",
16007,
"=G4+E4",
1100916,
1073357,
"=J4-I4",
"=(J4-E4)/J4",
"=(J4-H4)/J4"
],
[
2,
"PRODUCT 2",
200816,
311264.8,
"=(D5-E5)",
14816,
"=G5+E5",
215534,
878162,
"=J5-I5",
"=(J5-E5)/J5",
"=(J5-H5)/J5"
],
[
3,
"PRODUCT 3",
170989,
237674.71,
"=(D6-E6)",
17057,
"=G6+E6",
820719,
1193784,
"=J6-I6",
"=(J6-E6)/J6",
"=(J6-H6)/J6"
],
[
4,
"PRODUCT 4",
281053,
61831.66,
"=(D7-E7)",
17459,
"=G7+E7",
620242,
420345,
"=J7-I7",
"=(J7-E7)/J7",
"=(J7-H7)/J7"
],
[
5,
"PRODUCT 5",
262319,
459058.25,
"=(D8-E8)",
13985,
"=G8+E8",
821177,
1175811,
"=J8-I8",
"=(J8-E8)/J8",
"=(J8-H8)/J8"
],
[
6,
"PRODUCT 6",
206881,
157229.56,
"=(D9-E9)",
11183,
"=G9+E9",
901263,
1015766,
"=J9-I9",
"=(J9-E9)/J9",
"=(J9-H9)/J9"
],
[
7,
"PRODUCT 7",
130194,
213518.15999999997,
"=(D10-E10)",
17111,
"=G10+E10",
878528,
733751,
"=J10-I10",
"=(J10-E10)/J10",
"=(J10-H10)/J10"
],
[
8,
"PRODUCT 8",
208451,
214704.53,
"=(D11-E11)",
16494,
"=G11+E11",
838380,
955983,
"=J11-I11",
"=(J11-E11)/J11",
"=(J11-H11)/J11"
],
[
9,
"PRODUCT 9",
206422,
177522.91999999998,
"=(D12-E12)",
17311,
"=G12+E12",
1073157,
924095,
"=J12-I12",
"=(J12-E12)/J12",
"=(J12-H12)/J12"
],
[
10,
"PRODUCT 10",
251504,
2515.04,
"=(D13-E13)",
17315,
"=G13+E13",
1141047,
1061074,
"=J13-I13",
"=(J13-E13)/J13",
"=(J13-H13)/J13"
],
[
"",
"",
"=SUM(C4:C13)",
"=SUM(D4:D13)",
"=SUM(E4:E13)",
"=SUM(F4:F13)",
"=SUM(G4:G13)",
"=SUM(H4:H13)",
"=SUM(I4:I13)",
"=SUM(J4:JK13)",
"=SUM(K4:K13)/10",
"=SUM(L4:L13)/10"
],
["", "", "", "", "", "", "", "", "", "", "", ""],
[
"",
"",
"",
"LIABILITIES / EQUITY RATIO",
"",
"",
"",
"",
"",
"",
"",
""
],
[
"",
"",
"",
"CALENDAR",
"LIABILITIES",
"EQUITY",
"",
"",
"",
"",
"",
""
],
["", "", "", 2027, 3613439, 3293202, "", "", "", "", "", ""],
["", "", "", 2028, 3508776, 3441854, "", "", "", "", "", ""],
["", "", "", 2029, 3719457, 3531844, "", "", "", "", "", ""],
["", "", "", 2030, 3310212, 3354051, "", "", "", "", "", ""],
["", "", "", 2031, 3945202, 3476155, "", "", "", "", "", ""],
["", "", "", 2032, 3938152, 3538468, "", "", "", "", "", ""],
["", "", "", 2033, 3733706, 3727037, "", "", "", "", "", ""],
["", "", "", 2034, 3526698, 3425405, "", "", "", "", "", ""],
["", "", "", 2035, 3632971, 3734041, "", "", "", "", "", ""],
["", "", "", 2036, 3206487, 3677074, "", "", "", "", "", ""]
],
"columns": [
{ "width": 44, "type": "text", "align": "left" },
{ "width": 190, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 103, "type": "text", "align": "left" },
{ "width": 101, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 97, "type": "text", "align": "left" },
{ "width": 107, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" },
{ "width": 86, "type": "text", "align": "left" }
],
"rows": [
{ "height": 67 },
{ "height": 53 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 52 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 },
{ "height": 43 }
],
"cells": {
"C4": { "format": "$#,##0" },
"D4": { "format": "$#,##0" },
"E4": { "format": "$#,##0" },
"F4": { "format": "$#,##0" },
"G4": { "format": "$#,##0" },
"H4": { "format": "$#,##0" },
"I4": { "format": "$#,##0" },
"J4": { "format": "$#,##0" },
"K4": { "format": "0%" },
"L4": { "format": "0%" },
"C5": { "format": "$#,##0" },
"D5": { "format": "$#,##0" },
"E5": { "format": "$#,##0" },
"F5": { "format": "$#,##0" },
"G5": { "format": "$#,##0" },
"H5": { "format": "$#,##0" },
"I5": { "format": "$#,##0" },
"J5": { "format": "$#,##0" },
"K5": { "format": "0%" },
"L5": { "format": "0%" },
"C6": { "format": "$#,##0" },
"D6": { "format": "$#,##0" },
"E6": { "format": "$#,##0" },
"F6": { "format": "$#,##0" },
"G6": { "format": "$#,##0" },
"H6": { "format": "$#,##0" },
"I6": { "format": "$#,##0" },
"J6": { "format": "$#,##0" },
"K6": { "format": "0%" },
"L6": { "format": "0%" },
"C7": { "format": "$#,##0" },
"D7": { "format": "$#,##0" },
"E7": { "format": "$#,##0" },
"F7": { "format": "$#,##0" },
"G7": { "format": "$#,##0" },
"H7": { "format": "$#,##0" },
"I7": { "format": "$#,##0" },
"J7": { "format": "$#,##0" },
"K7": { "format": "0%" },
"L7": { "format": "0%" },
"C8": { "format": "$#,##0" },
"D8": { "format": "$#,##0" },
"E8": { "format": "$#,##0" },
"F8": { "format": "$#,##0" },
"G8": { "format": "$#,##0" },
"H8": { "format": "$#,##0" },
"I8": { "format": "$#,##0" },
"J8": { "format": "$#,##0" },
"K8": { "format": "0%" },
"L8": { "format": "0%" },
"C9": { "format": "$#,##0" },
"D9": { "format": "$#,##0" },
"E9": { "format": "$#,##0" },
"F9": { "format": "$#,##0" },
"G9": { "format": "$#,##0" },
"H9": { "format": "$#,##0" },
"I9": { "format": "$#,##0" },
"J9": { "format": "$#,##0" },
"K9": { "format": "0%" },
"L9": { "format": "0%" },
"C10": { "format": "$#,##0" },
"D10": { "format": "$#,##0" },
"E10": { "format": "$#,##0" },
"F10": { "format": "$#,##0" },
"G10": { "format": "$#,##0" },
"H10": { "format": "$#,##0" },
"I10": { "format": "$#,##0" },
"J10": { "format": "$#,##0" },
"K10": { "format": "0%" },
"L10": { "format": "0%" },
"C11": { "format": "$#,##0" },
"D11": { "format": "$#,##0" },
"E11": { "format": "$#,##0" },
"F11": { "format": "$#,##0" },
"G11": { "format": "$#,##0" },
"H11": { "format": "$#,##0" },
"I11": { "format": "$#,##0" },
"J11": { "format": "$#,##0" },
"K11": { "format": "0%" },
"L11": { "format": "0%" },
"C12": { "format": "$#,##0" },
"D12": { "format": "$#,##0" },
"E12": { "format": "$#,##0" },
"F12": { "format": "$#,##0" },
"G12": { "format": "$#,##0" },
"H12": { "format": "$#,##0" },
"I12": { "format": "$#,##0" },
"J12": { "format": "$#,##0" },
"K12": { "format": "0%" },
"L12": { "format": "0%" },
"C13": { "format": "$#,##0" },
"D13": { "format": "$#,##0" },
"E13": { "format": "$#,##0" },
"F13": { "format": "$#,##0" },
"G13": { "format": "$#,##0" },
"H13": { "format": "$#,##0" },
"I13": { "format": "$#,##0" },
"J13": { "format": "$#,##0" },
"K13": { "format": "0%" },
"L13": { "format": "0%" },
"C14": { "format": "$#,##0" },
"D14": { "format": "$#,##0" },
"E14": { "format": "$#,##0" },
"F14": { "format": "$#,##0" },
"G14": { "format": "$#,##0" },
"H14": { "format": "$#,##0" },
"I14": { "format": "$#,##0" },
"J14": { "format": "$#,##0" },
"K14": { "format": "0%" },
"L14": { "format": "0%" },
"D18": { "format": "0" },
"E18": { "format": "0" },
"F18": { "format": "$#,##0" },
"D19": { "format": "0" },
"E19": { "format": "0" },
"F19": { "format": "$#,##0" },
"D20": { "format": "0" },
"E20": { "format": "0" },
"F20": { "format": "$#,##0" },
"D21": { "format": "0" },
"E21": { "format": "0" },
"F21": { "format": "$#,##0" },
"D22": { "format": "0" },
"E22": { "format": "0" },
"F22": { "format": "$#,##0" },
"D23": { "format": "0" },
"E23": { "format": "0" },
"F23": { "format": "$#,##0" },
"D24": { "format": "0" },
"E24": { "format": "0" },
"F24": { "format": "$#,##0" },
"D25": { "format": "0" },
"E25": { "format": "0" },
"F25": { "format": "$#,##0" },
"D26": { "format": "0" },
"E26": { "format": "0" },
"F26": { "format": "$#,##0" },
"D27": { "format": "0" },
"E27": { "format": "0" },
"F27": { "format": "$#,##0" }
},
"style": {
"A1": 3,
"B1": 3,
"C1": 3,
"D1": 3,
"E1": 3,
"F1": 3,
"G1": 3,
"H1": 3,
"I1": 3,
"J1": 3,
"K1": 1,
"L1": 1,
"A2": 4,
"B2": 5,
"C2": 6,
"D2": 6,
"E2": 6,
"F2": 7,
"G2": 7,
"H2": 8,
"I2": 8,
"J2": 8,
"K2": 9,
"L2": 9,
"A3": 10,
"B3": 11,
"C3": 12,
"D3": 12,
"E3": 12,
"F3": 13,
"G3": 13,
"H3": 14,
"I3": 14,
"J3": 14,
"K3": 15,
"L3": 15,
"A4": 16,
"B4": 17,
"C4": 18,
"D4": 18,
"E4": 18,
"F4": 18,
"G4": 18,
"H4": 18,
"I4": 18,
"J4": 18,
"K4": 18,
"L4": 18,
"A5": 16,
"B5": 17,
"C5": 19,
"D5": 19,
"E5": 19,
"F5": 20,
"G5": 20,
"H5": 21,
"I5": 21,
"J5": 21,
"K5": 22,
"L5": 22,
"A6": 16,
"B6": 17,
"C6": 18,
"D6": 18,
"E6": 18,
"F6": 18,
"G6": 18,
"H6": 18,
"I6": 18,
"J6": 18,
"K6": 18,
"L6": 18,
"A7": 16,
"B7": 17,
"C7": 19,
"D7": 19,
"E7": 19,
"F7": 20,
"G7": 20,
"H7": 21,
"I7": 21,
"J7": 21,
"K7": 22,
"L7": 22,
"A8": 16,
"B8": 17,
"C8": 18,
"D8": 18,
"E8": 18,
"F8": 18,
"G8": 18,
"H8": 18,
"I8": 18,
"J8": 18,
"K8": 18,
"L8": 18,
"A9": 16,
"B9": 17,
"C9": 19,
"D9": 19,
"E9": 19,
"F9": 20,
"G9": 20,
"H9": 21,
"I9": 21,
"J9": 21,
"K9": 22,
"L9": 22,
"A10": 16,
"B10": 17,
"C10": 18,
"D10": 18,
"E10": 18,
"F10": 18,
"G10": 18,
"H10": 18,
"I10": 18,
"J10": 18,
"K10": 18,
"L10": 18,
"A11": 16,
"B11": 17,
"C11": 19,
"D11": 19,
"E11": 19,
"F11": 20,
"G11": 20,
"H11": 21,
"I11": 21,
"J11": 21,
"K11": 22,
"L11": 22,
"A12": 16,
"B12": 17,
"C12": 18,
"D12": 18,
"E12": 18,
"F12": 18,
"G12": 18,
"H12": 18,
"I12": 18,
"J12": 18,
"K12": 18,
"L12": 18,
"A13": 16,
"B13": 17,
"C13": 19,
"D13": 19,
"E13": 19,
"F13": 20,
"G13": 20,
"H13": 21,
"I13": 21,
"J13": 21,
"K13": 22,
"L13": 22,
"A14": 23,
"B14": 24,
"C14": 25,
"D14": 25,
"E14": 25,
"F14": 26,
"G14": 26,
"H14": 27,
"I14": 27,
"J14": 27,
"K14": 28,
"L14": 28,
"C15": 1,
"D15": 1,
"E15": 1,
"F15": 1,
"G15": 1,
"H15": 1,
"I15": 1,
"J15": 1,
"K15": 1,
"L15": 1,
"C16": 1,
"D16": 46,
"E16": 46,
"F16": 46,
"G16": 1,
"H16": 1,
"I16": 1,
"J16": 1,
"K16": 1,
"L16": 1,
"C17": 1,
"D17": 32,
"E17": 32,
"F17": 33,
"G17": 1,
"H17": 1,
"I17": 1,
"J17": 1,
"K17": 1,
"L17": 1,
"C18": 1,
"D18": 34,
"E18": 34,
"F18": 18,
"G18": 1,
"H18": 1,
"I18": 1,
"J18": 1,
"K18": 1,
"L18": 1,
"C19": 1,
"D19": 35,
"E19": 35,
"F19": 36,
"G19": 1,
"H19": 37,
"I19": 37,
"J19": 1,
"K19": 1,
"L19": 1,
"C20": 1,
"D20": 34,
"E20": 34,
"F20": 18,
"G20": 1,
"H20": 37,
"I20": 37,
"J20": 38,
"C21": 1,
"D21": 35,
"E21": 35,
"F21": 36,
"G21": 1,
"H21": 37,
"I21": 37,
"J21": 38,
"M21": 39,
"D22": 34,
"E22": 34,
"F22": 18,
"H22": 40,
"I22": 40,
"J22": 38,
"D23": 35,
"E23": 35,
"F23": 36,
"H23": 37,
"I23": 40,
"J23": 38,
"D24": 34,
"E24": 34,
"F24": 18,
"H24": 40,
"I24": 40,
"J24": 38,
"D25": 35,
"E25": 35,
"F25": 36,
"J25": 38,
"D26": 34,
"E26": 34,
"F26": 18,
"J26": 38,
"D27": 35,
"E27": 35,
"F27": 36,
"J27": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Data",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [12, 27],
"mergeCells": {
"A1": [10, 1],
"A2": [2, 1],
"C2": [3, 1],
"F2": [2, 1],
"H2": [3, 1],
"K2": [2, 1],
"D16": [3, 1],
"H16": [5, 6]
},
"worksheetId": "50f4c91c-5e48-493b-8abe-08096772c049",
"meta": {},
"comments": {},
"cache": {}
},
{
"data": [
[
"",
"KPI DASHBOARD",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
[
null,
"=CHART('bar',['Target','Actual'],[{'label':'TOTAL BUDGET','data':('KPI Data'!D14:E14),'backgroundColor':['#00b04f','#92d14f'],'disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL BUDGET','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':FALSE}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
"",
"",
"",
"",
"",
"",
"",
"=CHART('bar',[''],[{'label':'Actual','data':['KPI Data'!I14],'backgroundColor':'#b5c8e8','disableJssSimplification':TRUE},{'label':'Target','data':['KPI Data'!J14],'backgroundColor':'#2d73b5','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL REVENUE','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':TRUE,'labels':{'color':'#000'}}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
[
"",
"=CHART('bar',('KPI Data'!D18:D27),[{'label':'LIABILITIES','data':('KPI Data'!E18:E27),'backgroundColor':'#1a345c','disableJssSimplification':TRUE},{'label':'EQUITY','data':('KPI Data'!F18:F27),'backgroundColor':'#e64300','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'plugins':{'legend':{'display':TRUE,'labels':{'color':'#000'}},'title':{'display':TRUE,'text':'LIABILITIES vs EQUITY per Year','color':'#000','font':{'size':16,'weight':'bold'}}},'scales':{'x':{'stacked':FALSE,'ticks':{'color':'#000'}},'y':{'stacked':FALSE,'ticks':{'color':'#000'},'beginAtZero':TRUE}}})",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "type": "text", "width": 62, "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "width": 62, "type": "text", "align": "left" },
{ "type": "text", "width": 15, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "width": 60, "type": "text", "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 60, "align": "left" },
{ "type": "text", "width": 38, "align": "left" }
],
"rows": [
{ "height": 77 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 118, "id": null },
{ "height": 71, "id": null },
{ "height": 58, "id": null },
{ "height": 51, "id": null },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 36 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 29 },
{ "height": 190 },
{ "height": 147 },
{ "height": 127 },
{ "height": 118 },
{ "height": 30 }
],
"cells": {},
"style": {
"B1": 0,
"C1": 0,
"D1": 0,
"E1": 0,
"F1": 0,
"G1": 0,
"H1": 0,
"I1": 0,
"J1": 0,
"K1": 1,
"L1": 1,
"M1": 1,
"A31": 41,
"B31": 39,
"C31": 39,
"D31": 39,
"E31": 39,
"F31": 39,
"G31": 39,
"H31": 39,
"I31": 39,
"J31": 39,
"K31": 39,
"L31": 39,
"M31": 39,
"N31": 39,
"O31": 39,
"P31": 39,
"Q31": 39
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "KPI Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [17, 42],
"mergeCells": {
"B1": [9, 1],
"B17": [7, 4],
"J17": [7, 4],
"B38": [15, 4]
},
"media": [
{
"id": "19bb08c4-6a32-441b-90e5-9db66be86313",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!C3:E13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "BUDGET",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#92D050", "xAxis": "top" },
{ "color": "#00B050", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"max": 300000,
"forceTheLimits": true
}
}
},
"cellAnchor": "B2",
"left": 0,
"top": 5,
"width": 434,
"height": 408,
"zIndex": 3,
"rotate": 0
},
{
"id": "afed067c-148d-42e1-aff6-49c328d7a22c",
"type": "chart",
"options": {
"type": "bar",
"range": "'KPI Data'!H3:J13",
"labels": 0,
"datasets": [1, 0],
"title": {
"text": "REVENUE",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{ "color": "#B4C7E7", "xAxis": "top" },
{ "color": "#2E75B6", "xAxis": "top" }
],
"axis": {
"base": {
"reverse": false,
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side2": {
"grid": { "width": 1, "color": "#D9D9D9" },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 15, "color": "#000000" },
"min": 0,
"max": 1250000,
"forceTheLimits": true
}
}
},
"cellAnchor": "J2",
"left": 1,
"top": 5,
"width": 421,
"height": 409,
"zIndex": 3,
"rotate": 0
},
{
"id": "df9ad462-1f05-46af-8b3f-d3d2a11e1212",
"type": "chart",
"options": {
"type": "line",
"range": "'KPI Data'!C3:L13",
"labels": 0,
"datasets": [9, 8],
"title": {
"text": "PROFIT MARGINS",
"font": { "size": 40, "color": "#2E75B6" }
},
"legend": {
"position": "bottom",
"display": true,
"labels": { "font": { "color": "#000000", "size": 13 } }
},
"series": [
{
"drawNullValues": false,
"borderColor": "#4472C4",
"line": { "width": 1 },
"color": "#00B0F0",
"point": { "style": "circle", "radius": 11.5 }
},
{
"drawNullValues": false,
"borderColor": "#FFC000",
"line": { "width": 1 },
"color": "#ED7D31",
"point": { "style": "circle", "radius": 11.5 }
}
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "display": false },
"labels": { "color": "#000000", "size": 13 }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "size": 16, "color": "#000000" },
"forceTheLimits": true
}
}
},
"cellAnchor": "A1",
"left": 22,
"top": 862,
"width": 873,
"height": 444,
"zIndex": 3,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "cb45f57c-907c-4070-8cc5-b7b0df77babe",
"meta": {},
"comments": {},
"cache": {}
}
],
"plugins": {},
"validations": [],
"definedNames": {},
"bar": true,
"toolbar": true
};
}
}
</script>
import { Component, ElementRef, ViewChild } from '@angular/core';
import jspreadsheet from 'jspreadsheet';
import formula from '@jspreadsheet/formula-pro';
import charts from '@jspreadsheet/charts';
import '@jspreadsheet/formula-charts';
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('ZmEwYWIwY2Q2ZjJkNGIyOTM4MjkxNzAzYTlhMGY1Yzk3NGJmZjdjYjk4MDAxNWE1NTc2MjJhZmI1ZWM2MWYxNGIyNWI1Zjg4ZTkzNTQwN2E3MTc4NTYzZmIyM2QwOWFlYTJkYjljOWE4Zjk0ZTVjODAzMjgzMGRkYTAzZjUzMmUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVeU56RXhOemczTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
jspreadsheet.setExtensions({ formula, charts });
@Component({
standalone: true,
selector: 'app-root',
template: `<div #spreadsheet></div>`,
})
export class AppComponent {
@ViewChild('spreadsheet', { static: true }) spreadsheet!: ElementRef;
ngAfterViewInit() {
jspreadsheet(this.spreadsheet.nativeElement, {
style: [
'font-size: 29px;font-weight: bold;font-family: Century Gothic;color: #595959;vertical-align: middle;',
'font-size: 16px;font-family: Arial;color: #000000;',
'font-size: 16px;font-family: Calibri;color: #000000;border-bottom: 2px dashed #70AD47;',
'font-size: 29px;font-family: Century Gothic;color: #595959;vertical-align: middle;',
'background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #595959;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #70AD47;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #009844;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #2E75B6;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #806000;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #595959;font-size: 16px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #595959;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #92D050;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #79AE40;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #5B9BD5;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #D6A000;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #F2F2F2;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #E2F0D9;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #D0E08D;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #DEEBF7;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #FFF2CC;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #F2F2F2;font-size: 16px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #00B050;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #009844;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #385724;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #806000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #ED7D31;font-size: 19px;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C55A11;font-size: 13px;font-weight: bold;font-family: Century Gothic;color: #FFFFFF;text-align: center;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #FBE5D6;font-size: 13px;font-family: Century Gothic;color: #000000;text-align: center;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 16px;font-family: Arial;color: #000000;text-align: center;',
'font-size: 16px;font-weight: bold;font-family: Calibri;color: #000000;',
'font-size: 16px;font-family: Calibri;color: #000000;',
'font-size: 16px;font-family: Calibri;color: #000000;text-align: center;',
'',
'background-color:#d7ccc8',
'font-size:16px;font-family:Arial;color:#000000;background-color:#ff8a65',
'font-size:16px;font-family:Arial;color:#000000;background-color:#f57c00',
'font-size:16px;font-family:Arial;color:#000000;background-color:#ff9800',
'font-size:16px;font-family:Arial;color:#000000;background-color:#fb8c00',
],
worksheets: [
{
data: [
['KPI DASHBOARD DATA', '', '', '', '', '', '', '', '', '', '', ''],
[
'Products',
'',
'Budget',
'',
'',
'Net Expenses',
'',
'Revenue',
'',
'',
'Profit Margins',
'',
],
[
'N.º',
'NAME',
'TARGET',
'ACTUAL',
'REMAINING',
'EXTRA',
'TOTAL',
'TARGET',
'ACTUAL',
'REMAINING',
'GROSS',
'NET',
],
[
1,
'PRODUCT 1',
160344,
259757.28000000003,
'=(D4-E4)',
16007,
'=G4+E4',
1100916,
1073357,
'=J4-I4',
'=(J4-E4)/J4',
'=(J4-H4)/J4',
],
[
2,
'PRODUCT 2',
200816,
311264.8,
'=(D5-E5)',
14816,
'=G5+E5',
215534,
878162,
'=J5-I5',
'=(J5-E5)/J5',
'=(J5-H5)/J5',
],
[
3,
'PRODUCT 3',
170989,
237674.71,
'=(D6-E6)',
17057,
'=G6+E6',
820719,
1193784,
'=J6-I6',
'=(J6-E6)/J6',
'=(J6-H6)/J6',
],
[
4,
'PRODUCT 4',
281053,
61831.66,
'=(D7-E7)',
17459,
'=G7+E7',
620242,
420345,
'=J7-I7',
'=(J7-E7)/J7',
'=(J7-H7)/J7',
],
[
5,
'PRODUCT 5',
262319,
459058.25,
'=(D8-E8)',
13985,
'=G8+E8',
821177,
1175811,
'=J8-I8',
'=(J8-E8)/J8',
'=(J8-H8)/J8',
],
[
6,
'PRODUCT 6',
206881,
157229.56,
'=(D9-E9)',
11183,
'=G9+E9',
901263,
1015766,
'=J9-I9',
'=(J9-E9)/J9',
'=(J9-H9)/J9',
],
[
7,
'PRODUCT 7',
130194,
213518.15999999997,
'=(D10-E10)',
17111,
'=G10+E10',
878528,
733751,
'=J10-I10',
'=(J10-E10)/J10',
'=(J10-H10)/J10',
],
[
8,
'PRODUCT 8',
208451,
214704.53,
'=(D11-E11)',
16494,
'=G11+E11',
838380,
955983,
'=J11-I11',
'=(J11-E11)/J11',
'=(J11-H11)/J11',
],
[
9,
'PRODUCT 9',
206422,
177522.91999999998,
'=(D12-E12)',
17311,
'=G12+E12',
1073157,
924095,
'=J12-I12',
'=(J12-E12)/J12',
'=(J12-H12)/J12',
],
[
10,
'PRODUCT 10',
251504,
2515.04,
'=(D13-E13)',
17315,
'=G13+E13',
1141047,
1061074,
'=J13-I13',
'=(J13-E13)/J13',
'=(J13-H13)/J13',
],
[
'',
'',
'=SUM(C4:C13)',
'=SUM(D4:D13)',
'=SUM(E4:E13)',
'=SUM(F4:F13)',
'=SUM(G4:G13)',
'=SUM(H4:H13)',
'=SUM(I4:I13)',
'=SUM(J4:JK13)',
'=SUM(K4:K13)/10',
'=SUM(L4:L13)/10',
],
['', '', '', '', '', '', '', '', '', '', '', ''],
[
'',
'',
'',
'LIABILITIES / EQUITY RATIO',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'CALENDAR',
'LIABILITIES',
'EQUITY',
'',
'',
'',
'',
'',
'',
],
['', '', '', 2027, 3613439, 3293202, '', '', '', '', '', ''],
['', '', '', 2028, 3508776, 3441854, '', '', '', '', '', ''],
['', '', '', 2029, 3719457, 3531844, '', '', '', '', '', ''],
['', '', '', 2030, 3310212, 3354051, '', '', '', '', '', ''],
['', '', '', 2031, 3945202, 3476155, '', '', '', '', '', ''],
['', '', '', 2032, 3938152, 3538468, '', '', '', '', '', ''],
['', '', '', 2033, 3733706, 3727037, '', '', '', '', '', ''],
['', '', '', 2034, 3526698, 3425405, '', '', '', '', '', ''],
['', '', '', 2035, 3632971, 3734041, '', '', '', '', '', ''],
['', '', '', 2036, 3206487, 3677074, '', '', '', '', '', ''],
],
columns: [
{ width: 44, type: 'text', align: 'left' },
{ width: 190, type: 'text', align: 'left' },
{ width: 97, type: 'text', align: 'left' },
{ width: 86, type: 'text', align: 'left' },
{ width: 103, type: 'text', align: 'left' },
{ width: 101, type: 'text', align: 'left' },
{ width: 86, type: 'text', align: 'left' },
{ width: 86, type: 'text', align: 'left' },
{ width: 97, type: 'text', align: 'left' },
{ width: 107, type: 'text', align: 'left' },
{ width: 86, type: 'text', align: 'left' },
{ width: 86, type: 'text', align: 'left' },
],
rows: [
{ height: 67 },
{ height: 53 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 29 },
{ height: 52 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
{ height: 43 },
],
cells: {
C4: { format: '$#,##0' },
D4: { format: '$#,##0' },
E4: { format: '$#,##0' },
F4: { format: '$#,##0' },
G4: { format: '$#,##0' },
H4: { format: '$#,##0' },
I4: { format: '$#,##0' },
J4: { format: '$#,##0' },
K4: { format: '0%' },
L4: { format: '0%' },
C5: { format: '$#,##0' },
D5: { format: '$#,##0' },
E5: { format: '$#,##0' },
F5: { format: '$#,##0' },
G5: { format: '$#,##0' },
H5: { format: '$#,##0' },
I5: { format: '$#,##0' },
J5: { format: '$#,##0' },
K5: { format: '0%' },
L5: { format: '0%' },
C6: { format: '$#,##0' },
D6: { format: '$#,##0' },
E6: { format: '$#,##0' },
F6: { format: '$#,##0' },
G6: { format: '$#,##0' },
H6: { format: '$#,##0' },
I6: { format: '$#,##0' },
J6: { format: '$#,##0' },
K6: { format: '0%' },
L6: { format: '0%' },
C7: { format: '$#,##0' },
D7: { format: '$#,##0' },
E7: { format: '$#,##0' },
F7: { format: '$#,##0' },
G7: { format: '$#,##0' },
H7: { format: '$#,##0' },
I7: { format: '$#,##0' },
J7: { format: '$#,##0' },
K7: { format: '0%' },
L7: { format: '0%' },
C8: { format: '$#,##0' },
D8: { format: '$#,##0' },
E8: { format: '$#,##0' },
F8: { format: '$#,##0' },
G8: { format: '$#,##0' },
H8: { format: '$#,##0' },
I8: { format: '$#,##0' },
J8: { format: '$#,##0' },
K8: { format: '0%' },
L8: { format: '0%' },
C9: { format: '$#,##0' },
D9: { format: '$#,##0' },
E9: { format: '$#,##0' },
F9: { format: '$#,##0' },
G9: { format: '$#,##0' },
H9: { format: '$#,##0' },
I9: { format: '$#,##0' },
J9: { format: '$#,##0' },
K9: { format: '0%' },
L9: { format: '0%' },
C10: { format: '$#,##0' },
D10: { format: '$#,##0' },
E10: { format: '$#,##0' },
F10: { format: '$#,##0' },
G10: { format: '$#,##0' },
H10: { format: '$#,##0' },
I10: { format: '$#,##0' },
J10: { format: '$#,##0' },
K10: { format: '0%' },
L10: { format: '0%' },
C11: { format: '$#,##0' },
D11: { format: '$#,##0' },
E11: { format: '$#,##0' },
F11: { format: '$#,##0' },
G11: { format: '$#,##0' },
H11: { format: '$#,##0' },
I11: { format: '$#,##0' },
J11: { format: '$#,##0' },
K11: { format: '0%' },
L11: { format: '0%' },
C12: { format: '$#,##0' },
D12: { format: '$#,##0' },
E12: { format: '$#,##0' },
F12: { format: '$#,##0' },
G12: { format: '$#,##0' },
H12: { format: '$#,##0' },
I12: { format: '$#,##0' },
J12: { format: '$#,##0' },
K12: { format: '0%' },
L12: { format: '0%' },
C13: { format: '$#,##0' },
D13: { format: '$#,##0' },
E13: { format: '$#,##0' },
F13: { format: '$#,##0' },
G13: { format: '$#,##0' },
H13: { format: '$#,##0' },
I13: { format: '$#,##0' },
J13: { format: '$#,##0' },
K13: { format: '0%' },
L13: { format: '0%' },
C14: { format: '$#,##0' },
D14: { format: '$#,##0' },
E14: { format: '$#,##0' },
F14: { format: '$#,##0' },
G14: { format: '$#,##0' },
H14: { format: '$#,##0' },
I14: { format: '$#,##0' },
J14: { format: '$#,##0' },
K14: { format: '0%' },
L14: { format: '0%' },
D18: { format: '0' },
E18: { format: '0' },
F18: { format: '$#,##0' },
D19: { format: '0' },
E19: { format: '0' },
F19: { format: '$#,##0' },
D20: { format: '0' },
E20: { format: '0' },
F20: { format: '$#,##0' },
D21: { format: '0' },
E21: { format: '0' },
F21: { format: '$#,##0' },
D22: { format: '0' },
E22: { format: '0' },
F22: { format: '$#,##0' },
D23: { format: '0' },
E23: { format: '0' },
F23: { format: '$#,##0' },
D24: { format: '0' },
E24: { format: '0' },
F24: { format: '$#,##0' },
D25: { format: '0' },
E25: { format: '0' },
F25: { format: '$#,##0' },
D26: { format: '0' },
E26: { format: '0' },
F26: { format: '$#,##0' },
D27: { format: '0' },
E27: { format: '0' },
F27: { format: '$#,##0' },
},
style: {
A1: 3,
B1: 3,
C1: 3,
D1: 3,
E1: 3,
F1: 3,
G1: 3,
H1: 3,
I1: 3,
J1: 3,
K1: 1,
L1: 1,
A2: 4,
B2: 5,
C2: 6,
D2: 6,
E2: 6,
F2: 7,
G2: 7,
H2: 8,
I2: 8,
J2: 8,
K2: 9,
L2: 9,
A3: 10,
B3: 11,
C3: 12,
D3: 12,
E3: 12,
F3: 13,
G3: 13,
H3: 14,
I3: 14,
J3: 14,
K3: 15,
L3: 15,
A4: 16,
B4: 17,
C4: 18,
D4: 18,
E4: 18,
F4: 18,
G4: 18,
H4: 18,
I4: 18,
J4: 18,
K4: 18,
L4: 18,
A5: 16,
B5: 17,
C5: 19,
D5: 19,
E5: 19,
F5: 20,
G5: 20,
H5: 21,
I5: 21,
J5: 21,
K5: 22,
L5: 22,
A6: 16,
B6: 17,
C6: 18,
D6: 18,
E6: 18,
F6: 18,
G6: 18,
H6: 18,
I6: 18,
J6: 18,
K6: 18,
L6: 18,
A7: 16,
B7: 17,
C7: 19,
D7: 19,
E7: 19,
F7: 20,
G7: 20,
H7: 21,
I7: 21,
J7: 21,
K7: 22,
L7: 22,
A8: 16,
B8: 17,
C8: 18,
D8: 18,
E8: 18,
F8: 18,
G8: 18,
H8: 18,
I8: 18,
J8: 18,
K8: 18,
L8: 18,
A9: 16,
B9: 17,
C9: 19,
D9: 19,
E9: 19,
F9: 20,
G9: 20,
H9: 21,
I9: 21,
J9: 21,
K9: 22,
L9: 22,
A10: 16,
B10: 17,
C10: 18,
D10: 18,
E10: 18,
F10: 18,
G10: 18,
H10: 18,
I10: 18,
J10: 18,
K10: 18,
L10: 18,
A11: 16,
B11: 17,
C11: 19,
D11: 19,
E11: 19,
F11: 20,
G11: 20,
H11: 21,
I11: 21,
J11: 21,
K11: 22,
L11: 22,
A12: 16,
B12: 17,
C12: 18,
D12: 18,
E12: 18,
F12: 18,
G12: 18,
H12: 18,
I12: 18,
J12: 18,
K12: 18,
L12: 18,
A13: 16,
B13: 17,
C13: 19,
D13: 19,
E13: 19,
F13: 20,
G13: 20,
H13: 21,
I13: 21,
J13: 21,
K13: 22,
L13: 22,
A14: 23,
B14: 24,
C14: 25,
D14: 25,
E14: 25,
F14: 26,
G14: 26,
H14: 27,
I14: 27,
J14: 27,
K14: 28,
L14: 28,
C15: 1,
D15: 1,
E15: 1,
F15: 1,
G15: 1,
H15: 1,
I15: 1,
J15: 1,
K15: 1,
L15: 1,
C16: 1,
D16: 46,
E16: 46,
F16: 46,
G16: 1,
H16: 1,
I16: 1,
J16: 1,
K16: 1,
L16: 1,
C17: 1,
D17: 32,
E17: 32,
F17: 33,
G17: 1,
H17: 1,
I17: 1,
J17: 1,
K17: 1,
L17: 1,
C18: 1,
D18: 34,
E18: 34,
F18: 18,
G18: 1,
H18: 1,
I18: 1,
J18: 1,
K18: 1,
L18: 1,
C19: 1,
D19: 35,
E19: 35,
F19: 36,
G19: 1,
H19: 37,
I19: 37,
J19: 1,
K19: 1,
L19: 1,
C20: 1,
D20: 34,
E20: 34,
F20: 18,
G20: 1,
H20: 37,
I20: 37,
J20: 38,
C21: 1,
D21: 35,
E21: 35,
F21: 36,
G21: 1,
H21: 37,
I21: 37,
J21: 38,
M21: 39,
D22: 34,
E22: 34,
F22: 18,
H22: 40,
I22: 40,
J22: 38,
D23: 35,
E23: 35,
F23: 36,
H23: 37,
I23: 40,
J23: 38,
D24: 34,
E24: 34,
F24: 18,
H24: 40,
I24: 40,
J24: 38,
D25: 35,
E25: 35,
F25: 36,
J25: 38,
D26: 34,
E26: 34,
F26: 18,
J26: 38,
D27: 35,
E27: 35,
F27: 36,
J27: 38,
},
textOverflow: true,
defaultColAlign: 'left',
worksheetName: 'KPI Data',
defaultColWidth: 79,
gridline: false,
tableOverflow: true,
tableWidth: 1300,
tableHeight: 620,
resize: 'both',
minDimensions: [12, 27],
mergeCells: {
A1: [10, 1],
A2: [2, 1],
C2: [3, 1],
F2: [2, 1],
H2: [3, 1],
K2: [2, 1],
D16: [3, 1],
H16: [5, 6],
},
worksheetId: '50f4c91c-5e48-493b-8abe-08096772c049',
meta: {},
comments: {},
cache: {},
},
{
data: [
[
'',
'KPI DASHBOARD',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
null,
"=CHART('bar',['Target','Actual'],[{'label':'TOTAL BUDGET','data':('KPI Data'!D14:E14),'backgroundColor':['#00b04f','#92d14f'],'disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL BUDGET','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':FALSE}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
'',
'',
'',
'',
'',
'',
'',
"=CHART('bar',[''],[{'label':'Actual','data':['KPI Data'!I14],'backgroundColor':'#b5c8e8','disableJssSimplification':TRUE},{'label':'Target','data':['KPI Data'!J14],'backgroundColor':'#2d73b5','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'indexAxis':'y','plugins':{'title':{'display':TRUE,'text':'TOTAL REVENUE','color':'#000','font':{'size':16,'weight':'bold'}},'legend':{'display':TRUE,'labels':{'color':'#000'}}},'scales':{'x':{'ticks':{'color':'#000'}},'y':{'ticks':{'color':'#000'}}}})",
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
"=CHART('bar',('KPI Data'!D18:D27),[{'label':'LIABILITIES','data':('KPI Data'!E18:E27),'backgroundColor':'#1a345c','disableJssSimplification':TRUE},{'label':'EQUITY','data':('KPI Data'!F18:F27),'backgroundColor':'#e64300','disableJssSimplification':TRUE}],{'disableJssSimplification':TRUE,'plugins':{'legend':{'display':TRUE,'labels':{'color':'#000'}},'title':{'display':TRUE,'text':'LIABILITIES vs EQUITY per Year','color':'#000','font':{'size':16,'weight':'bold'}}},'scales':{'x':{'stacked':FALSE,'ticks':{'color':'#000'}},'y':{'stacked':FALSE,'ticks':{'color':'#000'},'beginAtZero':TRUE}}})",
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
[
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
],
],
columns: [
{ width: 24, type: 'text', align: 'left' },
{ type: 'text', width: 62, align: 'left' },
{ type: 'text', width: 62, align: 'left' },
{ width: 62, type: 'text', align: 'left' },
{ width: 62, type: 'text', align: 'left' },
{ width: 62, type: 'text', align: 'left' },
{ width: 62, type: 'text', align: 'left' },
{ width: 62, type: 'text', align: 'left' },
{ type: 'text', width: 15, align: 'left' },
{ type: 'text', width: 60, align: 'left' },
{ width: 60, type: 'text', align: 'left' },
{ width: 60, type: 'text', align: 'left' },
{ type: 'text', width: 60, align: 'left' },
{ type: 'text', width: 60, align: 'left' },
{ type: 'text', width: 60, align: 'left' },
{ type: 'text', width: 60, align: 'left' },
{ type: 'text', width: 38, align: 'left' },
],
rows: [
{ height: 77 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 118 },
{ height: 71 },
{ height: 58 },
{ height: 51 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 36 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 29 },
{ height: 190 },
{ height: 147 },
{ height: 127 },
{ height: 118 },
{ height: 30 },
],
cells: {},
style: {
B1: 0,
C1: 0,
D1: 0,
E1: 0,
F1: 0,
G1: 0,
H1: 0,
I1: 0,
J1: 0,
K1: 1,
L1: 1,
M1: 1,
A31: 41,
B31: 39,
C31: 39,
D31: 39,
E31: 39,
F31: 39,
G31: 39,
H31: 39,
I31: 39,
J31: 39,
K31: 39,
L31: 39,
M31: 39,
N31: 39,
O31: 39,
P31: 39,
Q31: 39,
},
textOverflow: true,
defaultColAlign: 'left',
worksheetName: 'KPI Dashboard',
defaultColWidth: 79,
gridline: false,
tableOverflow: true,
tableWidth: 1300,
tableHeight: 620,
resize: 'both',
minDimensions: [17, 42],
mergeCells: {
B1: [9, 1],
B17: [7, 4],
J17: [7, 4],
B38: [15, 4],
},
media: [
{
id: '19bb08c4-6a32-441b-90e5-9db66be86313',
type: 'chart',
options: {
type: 'bar',
range: "'KPI Data'!C3:E13",
labels: 0,
datasets: [1, 0],
title: {
text: 'BUDGET',
font: { size: 40 },
},
legend: {
position: 'bottom',
display: true,
},
series: [{ color: '#92D050' }, { color: '#00B050' }],
},
cellAnchor: 'B2',
left: 0,
top: 5,
width: 434,
height: 408,
zIndex: 3,
},
{
id: 'afed067c-148d-42e1-aff6-49c328d7a22c',
type: 'chart',
options: {
type: 'bar',
range: "'KPI Data'!H3:J13",
labels: 0,
datasets: [1, 0],
title: {
text: 'REVENUE',
font: { size: 40 },
},
legend: {
position: 'bottom',
display: true,
},
series: [{ color: '#B4C7E7' }, { color: '#2E75B6' }],
},
cellAnchor: 'J2',
left: 1,
top: 5,
width: 421,
height: 409,
zIndex: 3,
},
{
id: 'df9ad462-1f05-46af-8b3f-d3d2a11e1212',
type: 'chart',
options: {
type: 'line',
range: "'KPI Data'!C3:L13",
labels: 0,
datasets: [9, 8],
title: {
text: 'PROFIT MARGINS',
font: { size: 40 },
},
legend: {
position: 'bottom',
display: true,
},
series: [
{
borderColor: '#4472C4',
color: '#00B0F0',
},
{
borderColor: '#FFC000',
color: '#ED7D31',
},
],
},
cellAnchor: 'A1',
left: 22,
top: 862,
width: 873,
height: 444,
zIndex: 3,
},
],
freezeRowControl: true,
freezeColumnControl: true,
freezeRows: [0],
worksheetId: 'cb45f57c-907c-4070-8cc5-b7b0df77babe',
meta: {},
comments: {},
cache: {},
},
],
plugins: {},
validations: [],
definedNames: {},
bar: true,
toolbar: true,
});
}
}