Project Management
A project management interface on a JavaScript spreadsheet. This example demonstrates task tracking, progress indicators, and dynamic charts, illustrating how spreadsheet-based grids can facilitate agile workflows and support visual reporting within custom project 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": [
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #44546A;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #808080;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;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: #FFFFFF;font-size: 27px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFFFFF;font-size: 19px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-bottom: 1px solid #000000;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;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: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color:#9e9e9e;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#9e9e9e;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e",
"background-color:#e0e0e0;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#e0e0e0;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"background-color:#fdfffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#b997ff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"background-color:#fdffff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"font-size:13px;font-family: Open sans;color:#212121;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-right:1px solid #000000;border-bottom:1px solid #000000",
"background-color:#FFFFFF;font-size:19px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-bottom:1px solid #000000",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black"
],
"worksheets": [
{
"data": [
["", "PROJECT MANAGEMENT DASHBOARD", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "PROJECT NAME", "Jspreadsheet", "", "Priorities", "", "", ""],
[
"",
"REPORT DATE",
45790,
"",
"High",
"=COUNTIF(D26:D36,\"★★★\")",
"",
""
],
[
"",
"PROJECT STATUS",
"On track",
"",
"Medium",
"=COUNTIF(D26:D36,\"★★\")",
"",
""
],
["", "COMPLETED", 0.27, "", "Lower", "=COUNTIF(D26:D36,\"★\")", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "TASKS", "ASSIGNED TO", "PRIORITY", "STATUS", "", "", ""],
["", "Set Kick-Off Meeting", "Alex B.", "★★★", "=NOTES!E2", "", "", ""],
["", "Agree on Objectives", "Frank C.", "★★★", "=NOTES!E3", "", "", ""],
["", "Detailed Requests", "Jacob S.", "★", "=NOTES!E4", "", "", ""],
["", "Hardware Requests", "Jacob S.", "★", "=NOTES!E5", "", "", ""],
["", "Final Resource Plan", "Jacob S.", "★★", "=NOTES!E6", "", "", ""],
["", "Staffing", "Alex B.", "★★", "=NOTES!E7", "", "", ""],
["", "Technical Requests", "Frank C.", "★", "=NOTES!E8", "", "", ""],
["", "Testing", "Kennedy K.", "★", "=NOTES!E9", "", "", ""],
["", "Dev. Complete", "Jacob S.", "★★★", "=NOTES!E10", "", "", ""],
[
"",
"Hardware Configuration",
"Alex B.",
"★",
"=NOTES!E11",
"",
"",
""
],
["", "System Testing", "Kennedy K.", "★", "=NOTES!E12", "", "", ""],
["", "Launch", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left", "s": 21 },
{ "width": 167, "type": "text", "align": "left", "s": 21 },
{ "width": 205, "type": "text", "align": "left", "s": 21 },
{ "width": 81, "type": "text", "align": "left", "s": 21 },
{ "width": 134, "type": "text", "align": "left", "s": 21 },
{ "width": 102, "type": "text", "align": "left", "s": 21 },
{ "width": 61, "type": "text", "align": "left", "s": 21 },
{ "width": 105, "type": "text", "align": "left", "s": 21 }
],
"rows": [
{ "height": 60 },
{ "height": 29 },
{ "height": 43 },
{ "height": 33 },
{ "height": 33 },
{ "height": 33 },
{ "height": 29 },
{ "height": 47 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 39 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 36 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"G3": { "format": "0.00%" },
"C4": { "format": "m/d/yy" },
"C6": { "format": "0%" },
"E6": { "format": "0.00%" },
"D26": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E26": { "format": "0%" },
"D27": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E27": { "format": "0%" },
"D28": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E28": { "format": "0%" },
"D29": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E29": { "format": "0%" },
"D30": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E30": { "format": "0%" },
"D31": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E31": { "format": "0%" },
"D32": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E32": { "format": "0%" },
"D33": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E33": { "format": "0%" },
"D34": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E34": { "format": "0%" },
"D35": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E35": { "format": "0%" },
"D36": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E36": { "format": "0%" }
},
"style": {
"A1": 21,
"B1": 85,
"C1": 86,
"D1": 86,
"E1": 86,
"F1": 86,
"G1": 1,
"H1": 1,
"A2": 21,
"B2": 1,
"C2": 1,
"D2": 1,
"E2": 1,
"F2": 1,
"G2": 1,
"H2": 1,
"A3": 2,
"B3": 89,
"C3": 87,
"D3": 2,
"E3": 91,
"F3": 91,
"G3": 91,
"H3": 2,
"A4": 2,
"B4": 90,
"C4": 88,
"D4": 2,
"E4": 92,
"F4": 93,
"G4": 93,
"H4": 2,
"A5": 2,
"B5": 90,
"C5": 88,
"D5": 2,
"E5": 92,
"F5": 93,
"G5": 93,
"H5": 2,
"A6": 2,
"B6": 90,
"C6": 88,
"D6": 2,
"E6": 94,
"F6": 95,
"G6": 95,
"H6": 2,
"A7": 2,
"B7": 2,
"C7": 2,
"D7": 2,
"E7": 2,
"F7": 2,
"G7": 2,
"H7": 2,
"A8": 2,
"B8": 2,
"C8": 2,
"D8": 2,
"E8": 2,
"F8": 2,
"G8": 2,
"H8": 2,
"A9": 2,
"B9": 2,
"C9": 2,
"D9": 2,
"E9": 2,
"F9": 2,
"G9": 2,
"H9": 2,
"A10": 2,
"B10": 2,
"C10": 2,
"D10": 2,
"E10": 2,
"F10": 2,
"G10": 2,
"H10": 2,
"A11": 2,
"B11": 2,
"C11": 2,
"D11": 2,
"E11": 2,
"F11": 2,
"G11": 2,
"H11": 2,
"A12": 2,
"B12": 2,
"C12": 2,
"D12": 2,
"E12": 2,
"F12": 2,
"G12": 2,
"H12": 2,
"A13": 2,
"B13": 2,
"C13": 2,
"D13": 2,
"E13": 2,
"F13": 2,
"G13": 2,
"H13": 2,
"A14": 2,
"B14": 2,
"C14": 2,
"D14": 2,
"E14": 2,
"F14": 2,
"G14": 2,
"H14": 2,
"A15": 2,
"B15": 2,
"C15": 2,
"D15": 2,
"E15": 2,
"F15": 2,
"G15": 2,
"H15": 2,
"A16": 2,
"B16": 2,
"C16": 2,
"D16": 2,
"E16": 2,
"F16": 2,
"G16": 2,
"H16": 2,
"A17": 2,
"B17": 2,
"C17": 2,
"D17": 2,
"E17": 2,
"F17": 2,
"G17": 2,
"H17": 2,
"A18": 2,
"B18": 2,
"C18": 2,
"D18": 2,
"E18": 2,
"F18": 2,
"G18": 2,
"H18": 2,
"A19": 2,
"B19": 2,
"C19": 2,
"D19": 2,
"E19": 2,
"F19": 2,
"G19": 2,
"H19": 2,
"A20": 2,
"B20": 2,
"C20": 2,
"D20": 2,
"E20": 2,
"F20": 2,
"G20": 2,
"H20": 2,
"A21": 2,
"B21": 2,
"C21": 2,
"D21": 2,
"E21": 2,
"F21": 2,
"G21": 2,
"H21": 2,
"A22": 2,
"B22": 2,
"C22": 2,
"D22": 2,
"E22": 2,
"F22": 2,
"G22": 2,
"H22": 2,
"A23": 2,
"B23": 9,
"C23": 2,
"D23": 2,
"E23": 2,
"F23": 2,
"G23": 2,
"H23": 2,
"A24": 2,
"B24": 9,
"C24": 2,
"D24": 2,
"E24": 2,
"F24": 2,
"G24": 2,
"H24": 2,
"A25": 2,
"B25": 91,
"C25": 96,
"D25": 96,
"E25": 96,
"F25": 2,
"G25": 2,
"H25": 2,
"A26": 2,
"B26": 97,
"C26": 98,
"D26": 99,
"E26": 98,
"F26": 2,
"G26": 2,
"H26": 2,
"A27": 2,
"B27": 97,
"C27": 98,
"D27": 99,
"E27": 98,
"F27": 2,
"G27": 2,
"H27": 2,
"A28": 2,
"B28": 97,
"C28": 98,
"D28": 99,
"E28": 98,
"F28": 2,
"G28": 2,
"H28": 2,
"A29": 2,
"B29": 97,
"C29": 98,
"D29": 99,
"E29": 98,
"F29": 2,
"G29": 2,
"H29": 2,
"A30": 2,
"B30": 97,
"C30": 98,
"D30": 99,
"E30": 98,
"F30": 2,
"G30": 2,
"H30": 2,
"A31": 2,
"B31": 97,
"C31": 98,
"D31": 99,
"E31": 98,
"F31": 2,
"G31": 2,
"H31": 2,
"A32": 2,
"B32": 97,
"C32": 98,
"D32": 99,
"E32": 98,
"F32": 2,
"G32": 2,
"H32": 2,
"A33": 2,
"B33": 97,
"C33": 98,
"D33": 99,
"E33": 98,
"F33": 58,
"G33": 2,
"H33": 2,
"A34": 2,
"B34": 97,
"C34": 98,
"D34": 99,
"E34": 98,
"F34": 2,
"G34": 2,
"H34": 2,
"A35": 2,
"B35": 97,
"C35": 98,
"D35": 99,
"E35": 98,
"F35": 2,
"G35": 2,
"H35": 2,
"A36": 2,
"B36": 97,
"C36": 98,
"D36": 99,
"E36": 98,
"F36": 2,
"G36": 2,
"H36": 2,
"A37": 2,
"B37": 80,
"C37": 81,
"D37": 81,
"E37": 81,
"F37": 2,
"G37": 2,
"H37": 2,
"A38": 2,
"B38": 2,
"C38": 2,
"D38": 2,
"E38": 2,
"F38": 2,
"G38": 2,
"H38": 2
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "Project Management Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [8, 38],
"media": [
{
"id": "bed231e4-5a3b-4fa1-ad86-72c4a6e4dc2e",
"type": "chart",
"options": {
"orientation": 1,
"range": "Notes!A16:B20",
"headers": true,
"title": { "text": "Overall Task", "font": { "color": "#000000" } },
"labels": 0,
"datasets": null,
"series": [
{
"color": ["#E69F00", "#56B4E9", "#009E73", "#F0E442"],
"borderColor": [
"transparent",
"transparent",
"transparent",
"transparent"
],
"border": { "width": 2 }
}
],
"type": "doughnut",
"legend": {
"display": true,
"position": "right",
"labels": { "font": { "color": "#000000", "size": 13 } }
}
},
"cellAnchor": "D7",
"left": 17,
"top": 16,
"width": 360,
"height": 266,
"zIndex": 3,
"rotate": 0
},
{
"id": "b83e79f9-e076-4f61-8e54-e68a07188036",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A23:B25",
"headers": true,
"title": {
"text": "Budget",
"font": { "color": "#000000" },
"position": "bottom"
},
"labels": 0,
"datasets": [2, 1],
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"reverse": true
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"min": 20000,
"max": 90000,
"forceTheLimits": true,
"spacingBetweenTicks": { "type": "value", "value": 10000 }
}
},
"type": "bar",
"legend": { "display": true, "position": "top" }
},
"cellAnchor": "B16",
"left": 2,
"top": 11,
"width": 748,
"height": 209,
"zIndex": 3,
"rotate": 0
},
{
"id": "a9013968-8bce-4ec4-8e4b-494d06b63dcb",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A28:B31",
"headers": true,
"title": {
"text": "Pending Items",
"font": { "color": "#000000" }
},
"labels": 0,
"datasets": null,
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
}
},
"type": "column",
"legend": { "display": true, "position": "bottom" }
},
"cellAnchor": "B7",
"left": 2,
"top": 16,
"width": 376,
"height": 266,
"zIndex": 3,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "18c0eea5-76b9-4774-93eb-c10413b683e8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": {
"B1": [5, 1],
"E3": [3, 1],
"F4": [2, 1],
"F5": [2, 1],
"F6": [2, 1]
}
},
{
"data": [
["Tasks", "Assigned To", "Start", "End", "Status"],
[
"Set kick-off meeting",
"Alex B.",
"2022-09-02 00:00:00",
"2022-09-03 00:00:00",
"COMPLETE"
],
[
"Agree on objectives",
"Frank C.",
"2022-09-03 00:00:00",
"2022-09-07 00:00:00",
"COMPLETE"
],
[
"Detailed Reqs.",
"Jacob S.",
"2022-09-07 00:00:00",
"2022-09-12 00:00:00",
"COMPLETE"
],
[
"Hardward Reqs.",
"Jacob S.",
"2022-09-09 00:00:00",
"2022-09-11 00:00:00",
"OVERDUE"
],
[
"Final Resource Plan",
"Jacob S.",
"2022-09-11 00:00:00",
"2022-09-15 00:00:00",
"IN PROGRESS"
],
[
"Staffing",
"Alex B.",
"2022-09-16 00:00:00",
"2022-09-17 00:00:00",
"IN PROGRESS"
],
[
"Techincal Reqs.",
"Frank C.",
"2022-09-17 00:00:00",
"2022-09-21 00:00:00",
"COMPLETE"
],
[
"Testing",
"Kennedy K.",
"2022-09-24 00:00:00",
"2022-10-02 00:00:00",
"OVERDUE"
],
[
"Dev. Complete",
"Jacob S.",
"2022-10-02 00:00:00",
"2022-10-05 00:00:00",
"OVERDUE"
],
[
"Hardware Config.",
"Alex B.",
"2022-10-05 00:00:00",
"2022-10-07 00:00:00",
"COMPLETE"
],
[
"System Testing",
"Kennedy K.",
"2022-10-06 00:00:00",
"2022-10-09 00:00:00",
"NOT STARTED"
],
["Launch", "", "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Percentage of Tasks Complete", "", "", "", ""],
[
"Complete",
"=COUNTIF(E2:E12,\"COMPLETE\")/COUNTA(E2:E12)",
"",
"",
""
],
["Overdue", "=COUNTIF(E2:E12,\"OVERDUE\")/COUNTA(E2:E12)", "", "", ""],
[
"In progress",
"=COUNTIF(E2:E12,\"IN PROGRESS\")/COUNTA(E2:E12)",
"",
"",
""
],
[
"Not Started",
"=COUNTIF(E2:E12,\"NOT STARTED\")/COUNTA(E2:E12)",
"",
"",
""
],
["", "", "", "", ""],
["", "", "", "", ""],
["Budget", "", "", "", ""],
["Planned", 80000, "", "", ""],
["Actual", 50000, "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Pending Items", "", "", "", ""],
["Decisions", 5, "", "", ""],
["Actions", 2, "", "", ""],
["Change Requests ", 4, "", "", ""]
],
"columns": [
{ "width": 277, "type": "text", "align": "left", "s": 38 },
{ "width": 125, "type": "text", "align": "left", "s": 38 },
{ "width": 122, "type": "text", "align": "left", "s": 38 },
{ "width": 120, "type": "text", "align": "left", "s": 38 },
{
"width": 163,
"type": "dropdown",
"source": [
{ "id": "COMPLETE", "name": "COMPLETE" },
{ "id": "OVERDUE", "name": "OVERDUE" },
{ "id": "IN PROGRESS", "name": "IN PROGRESS" },
{ "id": "NOT STARTED", "name": "NOT STARTED" }
],
"align": "left",
"s": 38
}
],
"rows": [
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"C2": { "type": "calendar", "format": "DD/MM/YYYY" },
"D2": { "type": "calendar", "format": "DD/MM/YYYY" },
"C3": { "type": "calendar", "format": "DD/MM/YYYY" },
"D3": { "type": "calendar", "format": "DD/MM/YYYY" },
"C4": { "type": "calendar", "format": "DD/MM/YYYY" },
"D4": { "type": "calendar", "format": "DD/MM/YYYY" },
"C5": { "type": "calendar", "format": "DD/MM/YYYY" },
"D5": { "type": "calendar", "format": "DD/MM/YYYY" },
"C6": { "type": "calendar", "format": "DD/MM/YYYY" },
"D6": { "type": "calendar", "format": "DD/MM/YYYY" },
"C7": { "type": "calendar", "format": "DD/MM/YYYY" },
"D7": { "type": "calendar", "format": "DD/MM/YYYY" },
"C8": { "type": "calendar", "format": "DD/MM/YYYY" },
"D8": { "type": "calendar", "format": "DD/MM/YYYY" },
"C9": { "type": "calendar", "format": "DD/MM/YYYY" },
"D9": { "type": "calendar", "format": "DD/MM/YYYY" },
"C10": { "type": "calendar", "format": "DD/MM/YYYY" },
"D10": { "type": "calendar", "format": "DD/MM/YYYY" },
"C11": { "type": "calendar", "format": "DD/MM/YYYY" },
"D11": { "type": "calendar", "format": "DD/MM/YYYY" },
"C12": { "type": "calendar", "format": "DD/MM/YYYY" },
"D12": { "type": "calendar", "format": "DD/MM/YYYY" },
"C13": { "type": "calendar", "format": "DD/MM/YYYY" },
"D13": { "type": "calendar", "format": "DD/MM/YYYY" },
"E13": { "type": "text" },
"E14": { "type": "text" },
"E15": { "type": "text" },
"E16": { "type": "text" },
"B17": { "format": "0.00%" },
"E17": { "type": "text" },
"B18": { "format": "0.00%" },
"E18": { "type": "text" },
"B19": { "format": "0.00%" },
"E19": { "type": "text" },
"B20": { "format": "0.00%" },
"E20": { "type": "text" },
"E21": { "type": "text" },
"E22": { "type": "text" },
"E23": { "type": "text" },
"B24": { "format": "#,##0" },
"E24": { "type": "text" },
"B25": { "format": "#,##0" },
"E25": { "type": "text" },
"E26": { "type": "text" },
"E27": { "type": "text" },
"E28": { "type": "text" },
"E29": { "type": "text" },
"E30": { "type": "text" },
"E31": { "type": "text" }
},
"style": {
"A1": 100,
"B1": 101,
"C1": 101,
"D1": 101,
"E1": 101,
"F1": 38,
"A2": 102,
"B2": 103,
"C2": 103,
"D2": 103,
"E2": 104,
"F2": 38,
"A3": 102,
"B3": 103,
"C3": 103,
"D3": 103,
"E3": 104,
"F3": 38,
"A4": 102,
"B4": 103,
"C4": 103,
"D4": 103,
"E4": 104,
"F4": 38,
"A5": 102,
"B5": 103,
"C5": 103,
"D5": 103,
"E5": 104,
"F5": 38,
"A6": 102,
"B6": 103,
"C6": 103,
"D6": 103,
"E6": 104,
"F6": 38,
"A7": 102,
"B7": 103,
"C7": 103,
"D7": 103,
"E7": 104,
"F7": 38,
"A8": 102,
"B8": 103,
"C8": 103,
"D8": 103,
"E8": 104,
"F8": 38,
"A9": 102,
"B9": 103,
"C9": 103,
"D9": 103,
"E9": 104,
"F9": 38,
"A10": 102,
"B10": 103,
"C10": 103,
"D10": 103,
"E10": 104,
"F10": 38,
"A11": 102,
"B11": 103,
"C11": 103,
"D11": 103,
"E11": 104,
"F11": 38,
"A12": 102,
"B12": 103,
"C12": 103,
"D12": 103,
"E12": 104,
"F12": 38,
"A13": 39,
"B13": 40,
"C13": 40,
"D13": 40,
"E13": 84,
"F13": 38,
"A14": 38,
"B14": 38,
"C14": 38,
"D14": 38,
"E14": 38,
"F14": 38,
"A15": 38,
"B15": 38,
"C15": 38,
"D15": 38,
"E15": 38,
"F15": 38,
"A16": 100,
"B16": 101,
"C16": 38,
"D16": 54,
"E16": 54,
"F16": 38,
"A17": 105,
"B17": 106,
"C17": 38,
"D17": 38,
"E17": 38,
"F17": 38,
"A18": 105,
"B18": 106,
"C18": 38,
"D18": 38,
"E18": 38,
"F18": 38,
"A19": 105,
"B19": 106,
"C19": 38,
"D19": 38,
"E19": 38,
"F19": 38,
"A20": 105,
"B20": 106,
"C20": 38,
"D20": 38,
"E20": 38,
"F20": 38,
"A21": 38,
"B21": 38,
"C21": 38,
"D21": 38,
"E21": 38,
"F21": 38,
"A22": 38,
"B22": 38,
"C22": 38,
"D22": 38,
"E22": 38,
"F22": 38,
"A23": 100,
"B23": 101,
"C23": 38,
"D23": 38,
"E23": 38,
"F23": 38,
"A24": 107,
"B24": 108,
"C24": 38,
"D24": 38,
"E24": 38,
"F24": 38,
"A25": 105,
"B25": 106,
"C25": 38,
"D25": 38,
"E25": 38,
"F25": 38,
"A26": 38,
"B26": 38,
"C26": 38,
"D26": 38,
"E26": 38,
"F26": 38,
"A27": 38,
"B27": 38,
"C27": 38,
"D27": 38,
"E27": 38,
"F27": 38,
"A28": 100,
"B28": 101,
"C28": 38,
"D28": 38,
"E28": 38,
"F28": 38,
"A29": 109,
"B29": 110,
"C29": 38,
"D29": 38,
"E29": 38,
"F29": 38,
"A30": 109,
"B30": 110,
"C30": 38,
"D30": 38,
"E30": 38,
"F30": 38,
"A31": 111,
"B31": 112,
"C31": 38,
"D31": 38,
"E31": 38,
"F31": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"worksheetName": "Notes",
"defaultColWidth": 79,
"gridline": false,
"minDimensions": [5, 31],
"worksheetId": "d537423b-d382-4ff9-aafc-dbfa12a9dcd8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": { "A16": [2, 1], "A23": [2, 1], "A28": [2, 1] }
}
],
"toolbar": true
}
);
</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": [
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #44546A;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #808080;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;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: #FFFFFF;font-size: 27px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFFFFF;font-size: 19px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-bottom: 1px solid #000000;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;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: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color:#9e9e9e;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#9e9e9e;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e",
"background-color:#e0e0e0;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#e0e0e0;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"background-color:#fdfffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#b997ff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"background-color:#fdffff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"font-size:13px;font-family: Open sans;color:#212121;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-right:1px solid #000000;border-bottom:1px solid #000000",
"background-color:#FFFFFF;font-size:19px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-bottom:1px solid #000000",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black"
],
"worksheets": [
{
"data": [
["", "PROJECT MANAGEMENT DASHBOARD", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "PROJECT NAME", "Jspreadsheet", "", "Priorities", "", "", ""],
[
"",
"REPORT DATE",
45790,
"",
"High",
"=COUNTIF(D26:D36,\"★★★\")",
"",
""
],
[
"",
"PROJECT STATUS",
"On track",
"",
"Medium",
"=COUNTIF(D26:D36,\"★★\")",
"",
""
],
["", "COMPLETED", 0.27, "", "Lower", "=COUNTIF(D26:D36,\"★\")", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "TASKS", "ASSIGNED TO", "PRIORITY", "STATUS", "", "", ""],
["", "Set Kick-Off Meeting", "Alex B.", "★★★", "=NOTES!E2", "", "", ""],
["", "Agree on Objectives", "Frank C.", "★★★", "=NOTES!E3", "", "", ""],
["", "Detailed Requests", "Jacob S.", "★", "=NOTES!E4", "", "", ""],
["", "Hardware Requests", "Jacob S.", "★", "=NOTES!E5", "", "", ""],
["", "Final Resource Plan", "Jacob S.", "★★", "=NOTES!E6", "", "", ""],
["", "Staffing", "Alex B.", "★★", "=NOTES!E7", "", "", ""],
["", "Technical Requests", "Frank C.", "★", "=NOTES!E8", "", "", ""],
["", "Testing", "Kennedy K.", "★", "=NOTES!E9", "", "", ""],
["", "Dev. Complete", "Jacob S.", "★★★", "=NOTES!E10", "", "", ""],
[
"",
"Hardware Configuration",
"Alex B.",
"★",
"=NOTES!E11",
"",
"",
""
],
["", "System Testing", "Kennedy K.", "★", "=NOTES!E12", "", "", ""],
["", "Launch", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left", "s": 21 },
{ "width": 167, "type": "text", "align": "left", "s": 21 },
{ "width": 205, "type": "text", "align": "left", "s": 21 },
{ "width": 81, "type": "text", "align": "left", "s": 21 },
{ "width": 134, "type": "text", "align": "left", "s": 21 },
{ "width": 102, "type": "text", "align": "left", "s": 21 },
{ "width": 61, "type": "text", "align": "left", "s": 21 },
{ "width": 105, "type": "text", "align": "left", "s": 21 }
],
"rows": [
{ "height": 60 },
{ "height": 29 },
{ "height": 43 },
{ "height": 33 },
{ "height": 33 },
{ "height": 33 },
{ "height": 29 },
{ "height": 47 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 39 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 36 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"G3": { "format": "0.00%" },
"C4": { "format": "m/d/yy" },
"C6": { "format": "0%" },
"E6": { "format": "0.00%" },
"D26": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E26": { "format": "0%" },
"D27": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E27": { "format": "0%" },
"D28": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E28": { "format": "0%" },
"D29": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E29": { "format": "0%" },
"D30": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E30": { "format": "0%" },
"D31": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E31": { "format": "0%" },
"D32": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E32": { "format": "0%" },
"D33": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E33": { "format": "0%" },
"D34": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E34": { "format": "0%" },
"D35": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E35": { "format": "0%" },
"D36": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E36": { "format": "0%" }
},
"style": {
"A1": 21,
"B1": 85,
"C1": 86,
"D1": 86,
"E1": 86,
"F1": 86,
"G1": 1,
"H1": 1,
"A2": 21,
"B2": 1,
"C2": 1,
"D2": 1,
"E2": 1,
"F2": 1,
"G2": 1,
"H2": 1,
"A3": 2,
"B3": 89,
"C3": 87,
"D3": 2,
"E3": 91,
"F3": 91,
"G3": 91,
"H3": 2,
"A4": 2,
"B4": 90,
"C4": 88,
"D4": 2,
"E4": 92,
"F4": 93,
"G4": 93,
"H4": 2,
"A5": 2,
"B5": 90,
"C5": 88,
"D5": 2,
"E5": 92,
"F5": 93,
"G5": 93,
"H5": 2,
"A6": 2,
"B6": 90,
"C6": 88,
"D6": 2,
"E6": 94,
"F6": 95,
"G6": 95,
"H6": 2,
"A7": 2,
"B7": 2,
"C7": 2,
"D7": 2,
"E7": 2,
"F7": 2,
"G7": 2,
"H7": 2,
"A8": 2,
"B8": 2,
"C8": 2,
"D8": 2,
"E8": 2,
"F8": 2,
"G8": 2,
"H8": 2,
"A9": 2,
"B9": 2,
"C9": 2,
"D9": 2,
"E9": 2,
"F9": 2,
"G9": 2,
"H9": 2,
"A10": 2,
"B10": 2,
"C10": 2,
"D10": 2,
"E10": 2,
"F10": 2,
"G10": 2,
"H10": 2,
"A11": 2,
"B11": 2,
"C11": 2,
"D11": 2,
"E11": 2,
"F11": 2,
"G11": 2,
"H11": 2,
"A12": 2,
"B12": 2,
"C12": 2,
"D12": 2,
"E12": 2,
"F12": 2,
"G12": 2,
"H12": 2,
"A13": 2,
"B13": 2,
"C13": 2,
"D13": 2,
"E13": 2,
"F13": 2,
"G13": 2,
"H13": 2,
"A14": 2,
"B14": 2,
"C14": 2,
"D14": 2,
"E14": 2,
"F14": 2,
"G14": 2,
"H14": 2,
"A15": 2,
"B15": 2,
"C15": 2,
"D15": 2,
"E15": 2,
"F15": 2,
"G15": 2,
"H15": 2,
"A16": 2,
"B16": 2,
"C16": 2,
"D16": 2,
"E16": 2,
"F16": 2,
"G16": 2,
"H16": 2,
"A17": 2,
"B17": 2,
"C17": 2,
"D17": 2,
"E17": 2,
"F17": 2,
"G17": 2,
"H17": 2,
"A18": 2,
"B18": 2,
"C18": 2,
"D18": 2,
"E18": 2,
"F18": 2,
"G18": 2,
"H18": 2,
"A19": 2,
"B19": 2,
"C19": 2,
"D19": 2,
"E19": 2,
"F19": 2,
"G19": 2,
"H19": 2,
"A20": 2,
"B20": 2,
"C20": 2,
"D20": 2,
"E20": 2,
"F20": 2,
"G20": 2,
"H20": 2,
"A21": 2,
"B21": 2,
"C21": 2,
"D21": 2,
"E21": 2,
"F21": 2,
"G21": 2,
"H21": 2,
"A22": 2,
"B22": 2,
"C22": 2,
"D22": 2,
"E22": 2,
"F22": 2,
"G22": 2,
"H22": 2,
"A23": 2,
"B23": 9,
"C23": 2,
"D23": 2,
"E23": 2,
"F23": 2,
"G23": 2,
"H23": 2,
"A24": 2,
"B24": 9,
"C24": 2,
"D24": 2,
"E24": 2,
"F24": 2,
"G24": 2,
"H24": 2,
"A25": 2,
"B25": 91,
"C25": 96,
"D25": 96,
"E25": 96,
"F25": 2,
"G25": 2,
"H25": 2,
"A26": 2,
"B26": 97,
"C26": 98,
"D26": 99,
"E26": 98,
"F26": 2,
"G26": 2,
"H26": 2,
"A27": 2,
"B27": 97,
"C27": 98,
"D27": 99,
"E27": 98,
"F27": 2,
"G27": 2,
"H27": 2,
"A28": 2,
"B28": 97,
"C28": 98,
"D28": 99,
"E28": 98,
"F28": 2,
"G28": 2,
"H28": 2,
"A29": 2,
"B29": 97,
"C29": 98,
"D29": 99,
"E29": 98,
"F29": 2,
"G29": 2,
"H29": 2,
"A30": 2,
"B30": 97,
"C30": 98,
"D30": 99,
"E30": 98,
"F30": 2,
"G30": 2,
"H30": 2,
"A31": 2,
"B31": 97,
"C31": 98,
"D31": 99,
"E31": 98,
"F31": 2,
"G31": 2,
"H31": 2,
"A32": 2,
"B32": 97,
"C32": 98,
"D32": 99,
"E32": 98,
"F32": 2,
"G32": 2,
"H32": 2,
"A33": 2,
"B33": 97,
"C33": 98,
"D33": 99,
"E33": 98,
"F33": 58,
"G33": 2,
"H33": 2,
"A34": 2,
"B34": 97,
"C34": 98,
"D34": 99,
"E34": 98,
"F34": 2,
"G34": 2,
"H34": 2,
"A35": 2,
"B35": 97,
"C35": 98,
"D35": 99,
"E35": 98,
"F35": 2,
"G35": 2,
"H35": 2,
"A36": 2,
"B36": 97,
"C36": 98,
"D36": 99,
"E36": 98,
"F36": 2,
"G36": 2,
"H36": 2,
"A37": 2,
"B37": 80,
"C37": 81,
"D37": 81,
"E37": 81,
"F37": 2,
"G37": 2,
"H37": 2,
"A38": 2,
"B38": 2,
"C38": 2,
"D38": 2,
"E38": 2,
"F38": 2,
"G38": 2,
"H38": 2
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "Project Management Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [8, 38],
"media": [
{
"id": "bed231e4-5a3b-4fa1-ad86-72c4a6e4dc2e",
"type": "chart",
"options": {
"orientation": 1,
"range": "Notes!A16:B20",
"headers": true,
"title": { "text": "Overall Task", "font": { "color": "#000000" } },
"labels": 0,
"datasets": null,
"series": [
{
"color": ["#E69F00", "#56B4E9", "#009E73", "#F0E442"],
"borderColor": [
"transparent",
"transparent",
"transparent",
"transparent"
],
"border": { "width": 2 }
}
],
"type": "doughnut",
"legend": {
"display": true,
"position": "right",
"labels": { "font": { "color": "#000000", "size": 13 } }
}
},
"cellAnchor": "D7",
"left": 17,
"top": 16,
"width": 360,
"height": 266,
"zIndex": 3,
"rotate": 0
},
{
"id": "b83e79f9-e076-4f61-8e54-e68a07188036",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A23:B25",
"headers": true,
"title": {
"text": "Budget",
"font": { "color": "#000000" },
"position": "bottom"
},
"labels": 0,
"datasets": [2, 1],
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"reverse": true
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"min": 20000,
"max": 90000,
"forceTheLimits": true,
"spacingBetweenTicks": { "type": "value", "value": 10000 }
}
},
"type": "bar",
"legend": { "display": true, "position": "top" }
},
"cellAnchor": "B16",
"left": 2,
"top": 11,
"width": 748,
"height": 209,
"zIndex": 3,
"rotate": 0
},
{
"id": "a9013968-8bce-4ec4-8e4b-494d06b63dcb",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A28:B31",
"headers": true,
"title": {
"text": "Pending Items",
"font": { "color": "#000000" }
},
"labels": 0,
"datasets": null,
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
}
},
"type": "column",
"legend": { "display": true, "position": "bottom" }
},
"cellAnchor": "B7",
"left": 2,
"top": 16,
"width": 376,
"height": 266,
"zIndex": 3,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "18c0eea5-76b9-4774-93eb-c10413b683e8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": {
"B1": [5, 1],
"E3": [3, 1],
"F4": [2, 1],
"F5": [2, 1],
"F6": [2, 1]
}
},
{
"data": [
["Tasks", "Assigned To", "Start", "End", "Status"],
[
"Set kick-off meeting",
"Alex B.",
"2022-09-02 00:00:00",
"2022-09-03 00:00:00",
"COMPLETE"
],
[
"Agree on objectives",
"Frank C.",
"2022-09-03 00:00:00",
"2022-09-07 00:00:00",
"COMPLETE"
],
[
"Detailed Reqs.",
"Jacob S.",
"2022-09-07 00:00:00",
"2022-09-12 00:00:00",
"COMPLETE"
],
[
"Hardward Reqs.",
"Jacob S.",
"2022-09-09 00:00:00",
"2022-09-11 00:00:00",
"OVERDUE"
],
[
"Final Resource Plan",
"Jacob S.",
"2022-09-11 00:00:00",
"2022-09-15 00:00:00",
"IN PROGRESS"
],
[
"Staffing",
"Alex B.",
"2022-09-16 00:00:00",
"2022-09-17 00:00:00",
"IN PROGRESS"
],
[
"Techincal Reqs.",
"Frank C.",
"2022-09-17 00:00:00",
"2022-09-21 00:00:00",
"COMPLETE"
],
[
"Testing",
"Kennedy K.",
"2022-09-24 00:00:00",
"2022-10-02 00:00:00",
"OVERDUE"
],
[
"Dev. Complete",
"Jacob S.",
"2022-10-02 00:00:00",
"2022-10-05 00:00:00",
"OVERDUE"
],
[
"Hardware Config.",
"Alex B.",
"2022-10-05 00:00:00",
"2022-10-07 00:00:00",
"COMPLETE"
],
[
"System Testing",
"Kennedy K.",
"2022-10-06 00:00:00",
"2022-10-09 00:00:00",
"NOT STARTED"
],
["Launch", "", "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Percentage of Tasks Complete", "", "", "", ""],
[
"Complete",
"=COUNTIF(E2:E12,\"COMPLETE\")/COUNTA(E2:E12)",
"",
"",
""
],
["Overdue", "=COUNTIF(E2:E12,\"OVERDUE\")/COUNTA(E2:E12)", "", "", ""],
[
"In progress",
"=COUNTIF(E2:E12,\"IN PROGRESS\")/COUNTA(E2:E12)",
"",
"",
""
],
[
"Not Started",
"=COUNTIF(E2:E12,\"NOT STARTED\")/COUNTA(E2:E12)",
"",
"",
""
],
["", "", "", "", ""],
["", "", "", "", ""],
["Budget", "", "", "", ""],
["Planned", 80000, "", "", ""],
["Actual", 50000, "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Pending Items", "", "", "", ""],
["Decisions", 5, "", "", ""],
["Actions", 2, "", "", ""],
["Change Requests ", 4, "", "", ""]
],
"columns": [
{ "width": 277, "type": "text", "align": "left", "s": 38 },
{ "width": 125, "type": "text", "align": "left", "s": 38 },
{ "width": 122, "type": "text", "align": "left", "s": 38 },
{ "width": 120, "type": "text", "align": "left", "s": 38 },
{
"width": 163,
"type": "dropdown",
"source": [
{ "id": "COMPLETE", "name": "COMPLETE" },
{ "id": "OVERDUE", "name": "OVERDUE" },
{ "id": "IN PROGRESS", "name": "IN PROGRESS" },
{ "id": "NOT STARTED", "name": "NOT STARTED" }
],
"align": "left",
"s": 38
}
],
"rows": [
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"C2": { "type": "calendar", "format": "DD/MM/YYYY" },
"D2": { "type": "calendar", "format": "DD/MM/YYYY" },
"C3": { "type": "calendar", "format": "DD/MM/YYYY" },
"D3": { "type": "calendar", "format": "DD/MM/YYYY" },
"C4": { "type": "calendar", "format": "DD/MM/YYYY" },
"D4": { "type": "calendar", "format": "DD/MM/YYYY" },
"C5": { "type": "calendar", "format": "DD/MM/YYYY" },
"D5": { "type": "calendar", "format": "DD/MM/YYYY" },
"C6": { "type": "calendar", "format": "DD/MM/YYYY" },
"D6": { "type": "calendar", "format": "DD/MM/YYYY" },
"C7": { "type": "calendar", "format": "DD/MM/YYYY" },
"D7": { "type": "calendar", "format": "DD/MM/YYYY" },
"C8": { "type": "calendar", "format": "DD/MM/YYYY" },
"D8": { "type": "calendar", "format": "DD/MM/YYYY" },
"C9": { "type": "calendar", "format": "DD/MM/YYYY" },
"D9": { "type": "calendar", "format": "DD/MM/YYYY" },
"C10": { "type": "calendar", "format": "DD/MM/YYYY" },
"D10": { "type": "calendar", "format": "DD/MM/YYYY" },
"C11": { "type": "calendar", "format": "DD/MM/YYYY" },
"D11": { "type": "calendar", "format": "DD/MM/YYYY" },
"C12": { "type": "calendar", "format": "DD/MM/YYYY" },
"D12": { "type": "calendar", "format": "DD/MM/YYYY" },
"C13": { "type": "calendar", "format": "DD/MM/YYYY" },
"D13": { "type": "calendar", "format": "DD/MM/YYYY" },
"E13": { "type": "text" },
"E14": { "type": "text" },
"E15": { "type": "text" },
"E16": { "type": "text" },
"B17": { "format": "0.00%" },
"E17": { "type": "text" },
"B18": { "format": "0.00%" },
"E18": { "type": "text" },
"B19": { "format": "0.00%" },
"E19": { "type": "text" },
"B20": { "format": "0.00%" },
"E20": { "type": "text" },
"E21": { "type": "text" },
"E22": { "type": "text" },
"E23": { "type": "text" },
"B24": { "format": "#,##0" },
"E24": { "type": "text" },
"B25": { "format": "#,##0" },
"E25": { "type": "text" },
"E26": { "type": "text" },
"E27": { "type": "text" },
"E28": { "type": "text" },
"E29": { "type": "text" },
"E30": { "type": "text" },
"E31": { "type": "text" }
},
"style": {
"A1": 100,
"B1": 101,
"C1": 101,
"D1": 101,
"E1": 101,
"F1": 38,
"A2": 102,
"B2": 103,
"C2": 103,
"D2": 103,
"E2": 104,
"F2": 38,
"A3": 102,
"B3": 103,
"C3": 103,
"D3": 103,
"E3": 104,
"F3": 38,
"A4": 102,
"B4": 103,
"C4": 103,
"D4": 103,
"E4": 104,
"F4": 38,
"A5": 102,
"B5": 103,
"C5": 103,
"D5": 103,
"E5": 104,
"F5": 38,
"A6": 102,
"B6": 103,
"C6": 103,
"D6": 103,
"E6": 104,
"F6": 38,
"A7": 102,
"B7": 103,
"C7": 103,
"D7": 103,
"E7": 104,
"F7": 38,
"A8": 102,
"B8": 103,
"C8": 103,
"D8": 103,
"E8": 104,
"F8": 38,
"A9": 102,
"B9": 103,
"C9": 103,
"D9": 103,
"E9": 104,
"F9": 38,
"A10": 102,
"B10": 103,
"C10": 103,
"D10": 103,
"E10": 104,
"F10": 38,
"A11": 102,
"B11": 103,
"C11": 103,
"D11": 103,
"E11": 104,
"F11": 38,
"A12": 102,
"B12": 103,
"C12": 103,
"D12": 103,
"E12": 104,
"F12": 38,
"A13": 39,
"B13": 40,
"C13": 40,
"D13": 40,
"E13": 84,
"F13": 38,
"A14": 38,
"B14": 38,
"C14": 38,
"D14": 38,
"E14": 38,
"F14": 38,
"A15": 38,
"B15": 38,
"C15": 38,
"D15": 38,
"E15": 38,
"F15": 38,
"A16": 100,
"B16": 101,
"C16": 38,
"D16": 54,
"E16": 54,
"F16": 38,
"A17": 105,
"B17": 106,
"C17": 38,
"D17": 38,
"E17": 38,
"F17": 38,
"A18": 105,
"B18": 106,
"C18": 38,
"D18": 38,
"E18": 38,
"F18": 38,
"A19": 105,
"B19": 106,
"C19": 38,
"D19": 38,
"E19": 38,
"F19": 38,
"A20": 105,
"B20": 106,
"C20": 38,
"D20": 38,
"E20": 38,
"F20": 38,
"A21": 38,
"B21": 38,
"C21": 38,
"D21": 38,
"E21": 38,
"F21": 38,
"A22": 38,
"B22": 38,
"C22": 38,
"D22": 38,
"E22": 38,
"F22": 38,
"A23": 100,
"B23": 101,
"C23": 38,
"D23": 38,
"E23": 38,
"F23": 38,
"A24": 107,
"B24": 108,
"C24": 38,
"D24": 38,
"E24": 38,
"F24": 38,
"A25": 105,
"B25": 106,
"C25": 38,
"D25": 38,
"E25": 38,
"F25": 38,
"A26": 38,
"B26": 38,
"C26": 38,
"D26": 38,
"E26": 38,
"F26": 38,
"A27": 38,
"B27": 38,
"C27": 38,
"D27": 38,
"E27": 38,
"F27": 38,
"A28": 100,
"B28": 101,
"C28": 38,
"D28": 38,
"E28": 38,
"F28": 38,
"A29": 109,
"B29": 110,
"C29": 38,
"D29": 38,
"E29": 38,
"F29": 38,
"A30": 109,
"B30": 110,
"C30": 38,
"D30": 38,
"E30": 38,
"F30": 38,
"A31": 111,
"B31": 112,
"C31": 38,
"D31": 38,
"E31": 38,
"F31": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"worksheetName": "Notes",
"defaultColWidth": 79,
"gridline": false,
"minDimensions": [5, 31],
"worksheetId": "d537423b-d382-4ff9-aafc-dbfa12a9dcd8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": { "A16": [2, 1], "A23": [2, 1], "A28": [2, 1] }
}
],
"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, charts });
export default {
components: { Spreadsheet, Worksheet },
data() {
return {
// Set your JSS license key (The following key only works for one day)
license: 'MDBhOTAxYjc3Zjk2NDk2NGNmOWI3ZDI2ZTZmYjlmOWQyZTU5YTc4ZjNhMDg0YmJlNmYwYmNjYTMxMDIyYzBjYjViY2QzYjlkMWE5MmY4ZjEwNmRhYmY2MmZhZGI0NDQ4MjlhMGZlNmUwMmIzMzQyZTcyNjcwNjVjNDQ5NzVlYjIsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVMk56a3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5',
"globalStyle": [
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #44546A;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #808080;vertical-align: middle;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;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: #FFFFFF;font-size: 27px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #FFFFFF;font-size: 19px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-bottom: 1px solid #000000;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;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: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;",
"background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-weight: bold;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"background-color: #C9C9C9;font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;",
"font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;",
"background-color:#9e9e9e;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#9e9e9e;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e",
"background-color:#e0e0e0;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#e0e0e0;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"background-color:#fdfffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#b997ff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"background-color:#fdffff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces",
"font-size:13px;font-family: Open sans;color:#212121;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle",
"background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle",
"background-color:#FFFFFF;font-size:27px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-right:1px solid #000000;border-bottom:1px solid #000000",
"background-color:#FFFFFF;font-size:19px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-bottom:1px solid #000000",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black",
"font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black"
],
"worksheets": [
{
"data": [
["", "PROJECT MANAGEMENT DASHBOARD", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "PROJECT NAME", "Jspreadsheet", "", "Priorities", "", "", ""],
[
"",
"REPORT DATE",
45790,
"",
"High",
"=COUNTIF(D26:D36,\"★★★\")",
"",
""
],
[
"",
"PROJECT STATUS",
"On track",
"",
"Medium",
"=COUNTIF(D26:D36,\"★★\")",
"",
""
],
["", "COMPLETED", 0.27, "", "Lower", "=COUNTIF(D26:D36,\"★\")", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""],
["", "TASKS", "ASSIGNED TO", "PRIORITY", "STATUS", "", "", ""],
["", "Set Kick-Off Meeting", "Alex B.", "★★★", "=NOTES!E2", "", "", ""],
["", "Agree on Objectives", "Frank C.", "★★★", "=NOTES!E3", "", "", ""],
["", "Detailed Requests", "Jacob S.", "★", "=NOTES!E4", "", "", ""],
["", "Hardware Requests", "Jacob S.", "★", "=NOTES!E5", "", "", ""],
["", "Final Resource Plan", "Jacob S.", "★★", "=NOTES!E6", "", "", ""],
["", "Staffing", "Alex B.", "★★", "=NOTES!E7", "", "", ""],
["", "Technical Requests", "Frank C.", "★", "=NOTES!E8", "", "", ""],
["", "Testing", "Kennedy K.", "★", "=NOTES!E9", "", "", ""],
["", "Dev. Complete", "Jacob S.", "★★★", "=NOTES!E10", "", "", ""],
[
"",
"Hardware Configuration",
"Alex B.",
"★",
"=NOTES!E11",
"",
"",
""
],
["", "System Testing", "Kennedy K.", "★", "=NOTES!E12", "", "", ""],
["", "Launch", "", "", "", "", "", ""],
["", "", "", "", "", "", "", ""]
],
"columns": [
{ "width": 24, "type": "text", "align": "left", "s": 21 },
{ "width": 167, "type": "text", "align": "left", "s": 21 },
{ "width": 205, "type": "text", "align": "left", "s": 21 },
{ "width": 81, "type": "text", "align": "left", "s": 21 },
{ "width": 134, "type": "text", "align": "left", "s": 21 },
{ "width": 102, "type": "text", "align": "left", "s": 21 },
{ "width": 61, "type": "text", "align": "left", "s": 21 },
{ "width": 105, "type": "text", "align": "left", "s": 21 }
],
"rows": [
{ "height": 60 },
{ "height": 29 },
{ "height": 43 },
{ "height": 33 },
{ "height": 33 },
{ "height": 33 },
{ "height": 29 },
{ "height": 47 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 30 },
{ "height": 39 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 36 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 43 },
{ "height": 43 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"G3": { "format": "0.00%" },
"C4": { "format": "m/d/yy" },
"C6": { "format": "0%" },
"E6": { "format": "0.00%" },
"D26": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E26": { "format": "0%" },
"D27": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E27": { "format": "0%" },
"D28": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E28": { "format": "0%" },
"D29": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E29": { "format": "0%" },
"D30": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E30": { "format": "0%" },
"D31": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E31": { "format": "0%" },
"D32": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E32": { "format": "0%" },
"D33": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E33": { "format": "0%" },
"D34": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E34": { "format": "0%" },
"D35": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E35": { "format": "0%" },
"D36": {
"type": "dropdown",
"source": [
{ "id": "★", "name": "★" },
{ "id": "★★", "name": "★★" },
{ "id": "★★★", "name": "★★★" }
]
},
"E36": { "format": "0%" }
},
"style": {
"A1": 21,
"B1": 85,
"C1": 86,
"D1": 86,
"E1": 86,
"F1": 86,
"G1": 1,
"H1": 1,
"A2": 21,
"B2": 1,
"C2": 1,
"D2": 1,
"E2": 1,
"F2": 1,
"G2": 1,
"H2": 1,
"A3": 2,
"B3": 89,
"C3": 87,
"D3": 2,
"E3": 91,
"F3": 91,
"G3": 91,
"H3": 2,
"A4": 2,
"B4": 90,
"C4": 88,
"D4": 2,
"E4": 92,
"F4": 93,
"G4": 93,
"H4": 2,
"A5": 2,
"B5": 90,
"C5": 88,
"D5": 2,
"E5": 92,
"F5": 93,
"G5": 93,
"H5": 2,
"A6": 2,
"B6": 90,
"C6": 88,
"D6": 2,
"E6": 94,
"F6": 95,
"G6": 95,
"H6": 2,
"A7": 2,
"B7": 2,
"C7": 2,
"D7": 2,
"E7": 2,
"F7": 2,
"G7": 2,
"H7": 2,
"A8": 2,
"B8": 2,
"C8": 2,
"D8": 2,
"E8": 2,
"F8": 2,
"G8": 2,
"H8": 2,
"A9": 2,
"B9": 2,
"C9": 2,
"D9": 2,
"E9": 2,
"F9": 2,
"G9": 2,
"H9": 2,
"A10": 2,
"B10": 2,
"C10": 2,
"D10": 2,
"E10": 2,
"F10": 2,
"G10": 2,
"H10": 2,
"A11": 2,
"B11": 2,
"C11": 2,
"D11": 2,
"E11": 2,
"F11": 2,
"G11": 2,
"H11": 2,
"A12": 2,
"B12": 2,
"C12": 2,
"D12": 2,
"E12": 2,
"F12": 2,
"G12": 2,
"H12": 2,
"A13": 2,
"B13": 2,
"C13": 2,
"D13": 2,
"E13": 2,
"F13": 2,
"G13": 2,
"H13": 2,
"A14": 2,
"B14": 2,
"C14": 2,
"D14": 2,
"E14": 2,
"F14": 2,
"G14": 2,
"H14": 2,
"A15": 2,
"B15": 2,
"C15": 2,
"D15": 2,
"E15": 2,
"F15": 2,
"G15": 2,
"H15": 2,
"A16": 2,
"B16": 2,
"C16": 2,
"D16": 2,
"E16": 2,
"F16": 2,
"G16": 2,
"H16": 2,
"A17": 2,
"B17": 2,
"C17": 2,
"D17": 2,
"E17": 2,
"F17": 2,
"G17": 2,
"H17": 2,
"A18": 2,
"B18": 2,
"C18": 2,
"D18": 2,
"E18": 2,
"F18": 2,
"G18": 2,
"H18": 2,
"A19": 2,
"B19": 2,
"C19": 2,
"D19": 2,
"E19": 2,
"F19": 2,
"G19": 2,
"H19": 2,
"A20": 2,
"B20": 2,
"C20": 2,
"D20": 2,
"E20": 2,
"F20": 2,
"G20": 2,
"H20": 2,
"A21": 2,
"B21": 2,
"C21": 2,
"D21": 2,
"E21": 2,
"F21": 2,
"G21": 2,
"H21": 2,
"A22": 2,
"B22": 2,
"C22": 2,
"D22": 2,
"E22": 2,
"F22": 2,
"G22": 2,
"H22": 2,
"A23": 2,
"B23": 9,
"C23": 2,
"D23": 2,
"E23": 2,
"F23": 2,
"G23": 2,
"H23": 2,
"A24": 2,
"B24": 9,
"C24": 2,
"D24": 2,
"E24": 2,
"F24": 2,
"G24": 2,
"H24": 2,
"A25": 2,
"B25": 91,
"C25": 96,
"D25": 96,
"E25": 96,
"F25": 2,
"G25": 2,
"H25": 2,
"A26": 2,
"B26": 97,
"C26": 98,
"D26": 99,
"E26": 98,
"F26": 2,
"G26": 2,
"H26": 2,
"A27": 2,
"B27": 97,
"C27": 98,
"D27": 99,
"E27": 98,
"F27": 2,
"G27": 2,
"H27": 2,
"A28": 2,
"B28": 97,
"C28": 98,
"D28": 99,
"E28": 98,
"F28": 2,
"G28": 2,
"H28": 2,
"A29": 2,
"B29": 97,
"C29": 98,
"D29": 99,
"E29": 98,
"F29": 2,
"G29": 2,
"H29": 2,
"A30": 2,
"B30": 97,
"C30": 98,
"D30": 99,
"E30": 98,
"F30": 2,
"G30": 2,
"H30": 2,
"A31": 2,
"B31": 97,
"C31": 98,
"D31": 99,
"E31": 98,
"F31": 2,
"G31": 2,
"H31": 2,
"A32": 2,
"B32": 97,
"C32": 98,
"D32": 99,
"E32": 98,
"F32": 2,
"G32": 2,
"H32": 2,
"A33": 2,
"B33": 97,
"C33": 98,
"D33": 99,
"E33": 98,
"F33": 58,
"G33": 2,
"H33": 2,
"A34": 2,
"B34": 97,
"C34": 98,
"D34": 99,
"E34": 98,
"F34": 2,
"G34": 2,
"H34": 2,
"A35": 2,
"B35": 97,
"C35": 98,
"D35": 99,
"E35": 98,
"F35": 2,
"G35": 2,
"H35": 2,
"A36": 2,
"B36": 97,
"C36": 98,
"D36": 99,
"E36": 98,
"F36": 2,
"G36": 2,
"H36": 2,
"A37": 2,
"B37": 80,
"C37": 81,
"D37": 81,
"E37": 81,
"F37": 2,
"G37": 2,
"H37": 2,
"A38": 2,
"B38": 2,
"C38": 2,
"D38": 2,
"E38": 2,
"F38": 2,
"G38": 2,
"H38": 2
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"worksheetName": "Project Management Dashboard",
"defaultColWidth": 79,
"gridline": false,
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"minDimensions": [8, 38],
"media": [
{
"id": "bed231e4-5a3b-4fa1-ad86-72c4a6e4dc2e",
"type": "chart",
"options": {
"orientation": 1,
"range": "Notes!A16:B20",
"headers": true,
"title": { "text": "Overall Task", "font": { "color": "#000000" } },
"labels": 0,
"datasets": null,
"series": [
{
"color": ["#E69F00", "#56B4E9", "#009E73", "#F0E442"],
"borderColor": [
"transparent",
"transparent",
"transparent",
"transparent"
],
"border": { "width": 2 }
}
],
"type": "doughnut",
"legend": {
"display": true,
"position": "right",
"labels": { "font": { "color": "#000000", "size": 13 } }
}
},
"cellAnchor": "D7",
"left": 17,
"top": 16,
"width": 360,
"height": 266,
"zIndex": 3,
"rotate": 0
},
{
"id": "b83e79f9-e076-4f61-8e54-e68a07188036",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A23:B25",
"headers": true,
"title": {
"text": "Budget",
"font": { "color": "#000000" },
"position": "bottom"
},
"labels": 0,
"datasets": [2, 1],
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"reverse": true
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 },
"min": 20000,
"max": 90000,
"forceTheLimits": true,
"spacingBetweenTicks": { "type": "value", "value": 10000 }
}
},
"type": "bar",
"legend": { "display": true, "position": "top" }
},
"cellAnchor": "B16",
"left": 2,
"top": 11,
"width": 748,
"height": 209,
"zIndex": 3,
"rotate": 0
},
{
"id": "a9013968-8bce-4ec4-8e4b-494d06b63dcb",
"type": "chart",
"options": {
"orientation": 0,
"range": "Notes!A28:B31",
"headers": true,
"title": {
"text": "Pending Items",
"font": { "color": "#000000" }
},
"labels": 0,
"datasets": null,
"series": [
{ "color": "#E69F00" },
{ "color": "#56B4E9" },
{ "color": "#009E73" },
{ "color": "#F0E442" },
{ "color": "#0072B2" }
],
"axis": {
"base": {
"grid": { "display": false },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
},
"side": {
"grid": { "width": 1 },
"ticks": { "width": 1, "length": 8 },
"labels": { "color": "#000000", "size": 13 }
}
},
"type": "column",
"legend": { "display": true, "position": "bottom" }
},
"cellAnchor": "B7",
"left": 2,
"top": 16,
"width": 376,
"height": 266,
"zIndex": 3,
"rotate": 0
}
],
"freezeRowControl": true,
"freezeColumnControl": true,
"freezeRows": [0],
"worksheetId": "18c0eea5-76b9-4774-93eb-c10413b683e8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": {
"B1": [5, 1],
"E3": [3, 1],
"F4": [2, 1],
"F5": [2, 1],
"F6": [2, 1]
}
},
{
"data": [
["Tasks", "Assigned To", "Start", "End", "Status"],
[
"Set kick-off meeting",
"Alex B.",
"2022-09-02 00:00:00",
"2022-09-03 00:00:00",
"COMPLETE"
],
[
"Agree on objectives",
"Frank C.",
"2022-09-03 00:00:00",
"2022-09-07 00:00:00",
"COMPLETE"
],
[
"Detailed Reqs.",
"Jacob S.",
"2022-09-07 00:00:00",
"2022-09-12 00:00:00",
"COMPLETE"
],
[
"Hardward Reqs.",
"Jacob S.",
"2022-09-09 00:00:00",
"2022-09-11 00:00:00",
"OVERDUE"
],
[
"Final Resource Plan",
"Jacob S.",
"2022-09-11 00:00:00",
"2022-09-15 00:00:00",
"IN PROGRESS"
],
[
"Staffing",
"Alex B.",
"2022-09-16 00:00:00",
"2022-09-17 00:00:00",
"IN PROGRESS"
],
[
"Techincal Reqs.",
"Frank C.",
"2022-09-17 00:00:00",
"2022-09-21 00:00:00",
"COMPLETE"
],
[
"Testing",
"Kennedy K.",
"2022-09-24 00:00:00",
"2022-10-02 00:00:00",
"OVERDUE"
],
[
"Dev. Complete",
"Jacob S.",
"2022-10-02 00:00:00",
"2022-10-05 00:00:00",
"OVERDUE"
],
[
"Hardware Config.",
"Alex B.",
"2022-10-05 00:00:00",
"2022-10-07 00:00:00",
"COMPLETE"
],
[
"System Testing",
"Kennedy K.",
"2022-10-06 00:00:00",
"2022-10-09 00:00:00",
"NOT STARTED"
],
["Launch", "", "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Percentage of Tasks Complete", "", "", "", ""],
[
"Complete",
"=COUNTIF(E2:E12,\"COMPLETE\")/COUNTA(E2:E12)",
"",
"",
""
],
["Overdue", "=COUNTIF(E2:E12,\"OVERDUE\")/COUNTA(E2:E12)", "", "", ""],
[
"In progress",
"=COUNTIF(E2:E12,\"IN PROGRESS\")/COUNTA(E2:E12)",
"",
"",
""
],
[
"Not Started",
"=COUNTIF(E2:E12,\"NOT STARTED\")/COUNTA(E2:E12)",
"",
"",
""
],
["", "", "", "", ""],
["", "", "", "", ""],
["Budget", "", "", "", ""],
["Planned", 80000, "", "", ""],
["Actual", 50000, "", "", ""],
["", "", "", "", ""],
["", "", "", "", ""],
["Pending Items", "", "", "", ""],
["Decisions", 5, "", "", ""],
["Actions", 2, "", "", ""],
["Change Requests ", 4, "", "", ""]
],
"columns": [
{ "width": 277, "type": "text", "align": "left", "s": 38 },
{ "width": 125, "type": "text", "align": "left", "s": 38 },
{ "width": 122, "type": "text", "align": "left", "s": 38 },
{ "width": 120, "type": "text", "align": "left", "s": 38 },
{
"width": 163,
"type": "dropdown",
"source": [
{ "id": "COMPLETE", "name": "COMPLETE" },
{ "id": "OVERDUE", "name": "OVERDUE" },
{ "id": "IN PROGRESS", "name": "IN PROGRESS" },
{ "id": "NOT STARTED", "name": "NOT STARTED" }
],
"align": "left",
"s": 38
}
],
"rows": [
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 },
{ "height": 29 }
],
"cells": {
"C2": { "type": "calendar", "format": "DD/MM/YYYY" },
"D2": { "type": "calendar", "format": "DD/MM/YYYY" },
"C3": { "type": "calendar", "format": "DD/MM/YYYY" },
"D3": { "type": "calendar", "format": "DD/MM/YYYY" },
"C4": { "type": "calendar", "format": "DD/MM/YYYY" },
"D4": { "type": "calendar", "format": "DD/MM/YYYY" },
"C5": { "type": "calendar", "format": "DD/MM/YYYY" },
"D5": { "type": "calendar", "format": "DD/MM/YYYY" },
"C6": { "type": "calendar", "format": "DD/MM/YYYY" },
"D6": { "type": "calendar", "format": "DD/MM/YYYY" },
"C7": { "type": "calendar", "format": "DD/MM/YYYY" },
"D7": { "type": "calendar", "format": "DD/MM/YYYY" },
"C8": { "type": "calendar", "format": "DD/MM/YYYY" },
"D8": { "type": "calendar", "format": "DD/MM/YYYY" },
"C9": { "type": "calendar", "format": "DD/MM/YYYY" },
"D9": { "type": "calendar", "format": "DD/MM/YYYY" },
"C10": { "type": "calendar", "format": "DD/MM/YYYY" },
"D10": { "type": "calendar", "format": "DD/MM/YYYY" },
"C11": { "type": "calendar", "format": "DD/MM/YYYY" },
"D11": { "type": "calendar", "format": "DD/MM/YYYY" },
"C12": { "type": "calendar", "format": "DD/MM/YYYY" },
"D12": { "type": "calendar", "format": "DD/MM/YYYY" },
"C13": { "type": "calendar", "format": "DD/MM/YYYY" },
"D13": { "type": "calendar", "format": "DD/MM/YYYY" },
"E13": { "type": "text" },
"E14": { "type": "text" },
"E15": { "type": "text" },
"E16": { "type": "text" },
"B17": { "format": "0.00%" },
"E17": { "type": "text" },
"B18": { "format": "0.00%" },
"E18": { "type": "text" },
"B19": { "format": "0.00%" },
"E19": { "type": "text" },
"B20": { "format": "0.00%" },
"E20": { "type": "text" },
"E21": { "type": "text" },
"E22": { "type": "text" },
"E23": { "type": "text" },
"B24": { "format": "#,##0" },
"E24": { "type": "text" },
"B25": { "format": "#,##0" },
"E25": { "type": "text" },
"E26": { "type": "text" },
"E27": { "type": "text" },
"E28": { "type": "text" },
"E29": { "type": "text" },
"E30": { "type": "text" },
"E31": { "type": "text" }
},
"style": {
"A1": 100,
"B1": 101,
"C1": 101,
"D1": 101,
"E1": 101,
"F1": 38,
"A2": 102,
"B2": 103,
"C2": 103,
"D2": 103,
"E2": 104,
"F2": 38,
"A3": 102,
"B3": 103,
"C3": 103,
"D3": 103,
"E3": 104,
"F3": 38,
"A4": 102,
"B4": 103,
"C4": 103,
"D4": 103,
"E4": 104,
"F4": 38,
"A5": 102,
"B5": 103,
"C5": 103,
"D5": 103,
"E5": 104,
"F5": 38,
"A6": 102,
"B6": 103,
"C6": 103,
"D6": 103,
"E6": 104,
"F6": 38,
"A7": 102,
"B7": 103,
"C7": 103,
"D7": 103,
"E7": 104,
"F7": 38,
"A8": 102,
"B8": 103,
"C8": 103,
"D8": 103,
"E8": 104,
"F8": 38,
"A9": 102,
"B9": 103,
"C9": 103,
"D9": 103,
"E9": 104,
"F9": 38,
"A10": 102,
"B10": 103,
"C10": 103,
"D10": 103,
"E10": 104,
"F10": 38,
"A11": 102,
"B11": 103,
"C11": 103,
"D11": 103,
"E11": 104,
"F11": 38,
"A12": 102,
"B12": 103,
"C12": 103,
"D12": 103,
"E12": 104,
"F12": 38,
"A13": 39,
"B13": 40,
"C13": 40,
"D13": 40,
"E13": 84,
"F13": 38,
"A14": 38,
"B14": 38,
"C14": 38,
"D14": 38,
"E14": 38,
"F14": 38,
"A15": 38,
"B15": 38,
"C15": 38,
"D15": 38,
"E15": 38,
"F15": 38,
"A16": 100,
"B16": 101,
"C16": 38,
"D16": 54,
"E16": 54,
"F16": 38,
"A17": 105,
"B17": 106,
"C17": 38,
"D17": 38,
"E17": 38,
"F17": 38,
"A18": 105,
"B18": 106,
"C18": 38,
"D18": 38,
"E18": 38,
"F18": 38,
"A19": 105,
"B19": 106,
"C19": 38,
"D19": 38,
"E19": 38,
"F19": 38,
"A20": 105,
"B20": 106,
"C20": 38,
"D20": 38,
"E20": 38,
"F20": 38,
"A21": 38,
"B21": 38,
"C21": 38,
"D21": 38,
"E21": 38,
"F21": 38,
"A22": 38,
"B22": 38,
"C22": 38,
"D22": 38,
"E22": 38,
"F22": 38,
"A23": 100,
"B23": 101,
"C23": 38,
"D23": 38,
"E23": 38,
"F23": 38,
"A24": 107,
"B24": 108,
"C24": 38,
"D24": 38,
"E24": 38,
"F24": 38,
"A25": 105,
"B25": 106,
"C25": 38,
"D25": 38,
"E25": 38,
"F25": 38,
"A26": 38,
"B26": 38,
"C26": 38,
"D26": 38,
"E26": 38,
"F26": 38,
"A27": 38,
"B27": 38,
"C27": 38,
"D27": 38,
"E27": 38,
"F27": 38,
"A28": 100,
"B28": 101,
"C28": 38,
"D28": 38,
"E28": 38,
"F28": 38,
"A29": 109,
"B29": 110,
"C29": 38,
"D29": 38,
"E29": 38,
"F29": 38,
"A30": 109,
"B30": 110,
"C30": 38,
"D30": 38,
"E30": 38,
"F30": 38,
"A31": 111,
"B31": 112,
"C31": 38,
"D31": 38,
"E31": 38,
"F31": 38
},
"textOverflow": true,
"stripHTML": false,
"defaultColAlign": "left",
"tableOverflow": true,
"tableWidth": 1300,
"tableHeight": 620,
"resize": "both",
"worksheetName": "Notes",
"defaultColWidth": 79,
"gridline": false,
"minDimensions": [5, 31],
"worksheetId": "d537423b-d382-4ff9-aafc-dbfa12a9dcd8",
"meta": {},
"comments": {},
"cache": {},
"mergeCells": { "A16": [2, 1], "A23": [2, 1], "A28": [2, 1] }
}
],
"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';
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense(
'MTAzNmQ0MDc1NDdjOWQ3MDA0YzJjMDQ0YTgzZDM1N2M4ZTE4NWVlM2FmYTY3YWFhNGM0YmNmNzJjMWViZmExOTJjN2YzMDY2NDRmY2RjZmQyMWJiY2M4NzRhYTNmZTE1ZDVjMjY5ZjYzZGY2MzEyOGFjNjc0NjYzNDUxNjQ0ZTQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVeU56RTBOVFE0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5'
);
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: [
'background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #44546A;vertical-align: middle;',
'background-color: #FFFFFF;font-size: 27px;font-weight: bold;font-family: Open sans;color: #808080;vertical-align: middle;',
'background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;',
'background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;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: #FFFFFF;font-size: 27px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-right: 1px solid #000000;border-bottom: 1px solid #000000;',
'background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #FFFFFF;font-size: 19px;font-family: Open sans;color: #000000;text-align: right;white-space: break-spaces;border-bottom: 1px solid #000000;',
'background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;white-space: break-spaces;',
'background-color: #FFFFFF;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;',
'background-color: #FFFFFF;font-size: 13px;font-family: Open sans;color: #000000;text-align: center;white-space: break-spaces;',
'background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;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;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;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: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;white-space: break-spaces;',
'background-color: #333F50;font-size: 13px;font-weight: bold;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;white-space: break-spaces;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;',
'background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #333F50;font-size: 13px;font-family: Open sans;color: #FFFFFF;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-top: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Open sans;color: #008000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF0000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Open sans;color: #FF6600;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-weight: bold;font-family: Open sans;color: #808080;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C9C9C9;font-size: 13px;font-weight: bold;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #BFBFBF;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'background-color: #C9C9C9;font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #BFBFBF;border-bottom: 1px solid #BFBFBF;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-bottom: 1px solid #000000;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-bottom: 1px solid #000000;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-left: 1px solid #000000;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;border-right: 1px solid #000000;border-top: 1px solid #000000;border-bottom: 1px solid #000000;',
'font-size: 13px;font-family: Open sans;color: #000000;text-align: left;padding-left: 19px;vertical-align: middle;',
'background-color:#9e9e9e;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#9e9e9e;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e',
'background-color:#e0e0e0;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#e0e0e0;font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#e0e0e0;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5',
'background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#f7fffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle',
'background-color:#fdfffe;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#b997ff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces',
'background-color:#fdffff;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces',
'font-size:13px;font-family: Open sans;color:#212121;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#000000;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#90a4ae;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#607d8b;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#37474f;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#efebe9;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#212121;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle',
'background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#212121;vertical-align:middle',
'background-color:#212121;font-size:13px;font-weight:bold;font-family: Open sans;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:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#bdbdbd;font-size:13px;font-weight:bold;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#212121;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#000000;text-align:left;padding-left:19px;vertical-align:middle;background-color:#9e9e9e;border-right:1px solid #b0bec5;border-bottom:1px solid #b0bec5;border-left:1px solid #b0bec5;border-top:1px solid #b0bec5',
'background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle',
'background-color:#FFFFFF;font-size:27px;font-weight:bold;font-family: Open sans;color:#424242;vertical-align:middle',
'background-color:#FFFFFF;font-size:27px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-right:1px solid #000000;border-bottom:1px solid #000000',
'background-color:#FFFFFF;font-size:19px;font-family: Open sans;color:#424242;text-align:right;white-space:break-spaces;border-bottom:1px solid #000000',
'background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;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:#424242;font-size:13px;font-weight:bold;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:medium;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#FFFFFF;font-size:13px;font-family: Open sans;color:#424242;white-space:break-spaces;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'background-color:#424242;font-size:13px;font-weight:bold;font-family: Open sans;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',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#424242;text-align:center;vertical-align:middle;white-space:break-spaces;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'background-color:#424242;font-size:13px;font-family: Open sans;color:#FFFFFF;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-top:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #BFBFBF;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #BFBFBF;border-bottom:1px solid #BFBFBF',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid #b0bec5;border-right:1px solid #b0bec5;border-left:1px solid #b0bec5',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-bottom:1px solid #000000',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-left:1px solid #000000;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-right:1px solid #000000;border-top:1px solid #000000;border-bottom:1px solid #000000',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
'font-size:13px;font-family: Open sans;color:#424242;text-align:left;padding-left:19px;vertical-align:middle;border-top:1px solid black;border-right:1px solid black;border-bottom:1px solid black;border-left:1px solid black',
],
worksheets: [
{
data: [
['', 'PROJECT MANAGEMENT DASHBOARD', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', 'PROJECT NAME', 'Jspreadsheet', '', 'Priorities', '', '', ''],
[
'',
'REPORT DATE',
45790,
'',
'High',
'=COUNTIF(D26:D36,"★★★")',
'',
'',
],
[
'',
'PROJECT STATUS',
'On track',
'',
'Medium',
'=COUNTIF(D26:D36,"★★")',
'',
'',
],
[
'',
'COMPLETED',
0.27,
'',
'Lower',
'=COUNTIF(D26:D36,"★")',
'',
'',
],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
['', 'TASKS', 'ASSIGNED TO', 'PRIORITY', 'STATUS', '', '', ''],
[
'',
'Set Kick-Off Meeting',
'Alex B.',
'★★★',
'=NOTES!E2',
'',
'',
'',
],
[
'',
'Agree on Objectives',
'Frank C.',
'★★★',
'=NOTES!E3',
'',
'',
'',
],
['', 'Detailed Requests', 'Jacob S.', '★', '=NOTES!E4', '', '', ''],
['', 'Hardware Requests', 'Jacob S.', '★', '=NOTES!E5', '', '', ''],
[
'',
'Final Resource Plan',
'Jacob S.',
'★★',
'=NOTES!E6',
'',
'',
'',
],
['', 'Staffing', 'Alex B.', '★★', '=NOTES!E7', '', '', ''],
[
'',
'Technical Requests',
'Frank C.',
'★',
'=NOTES!E8',
'',
'',
'',
],
['', 'Testing', 'Kennedy K.', '★', '=NOTES!E9', '', '', ''],
['', 'Dev. Complete', 'Jacob S.', '★★★', '=NOTES!E10', '', '', ''],
[
'',
'Hardware Configuration',
'Alex B.',
'★',
'=NOTES!E11',
'',
'',
'',
],
['', 'System Testing', 'Kennedy K.', '★', '=NOTES!E12', '', '', ''],
['', 'Launch', '', '', '', '', '', ''],
['', '', '', '', '', '', '', ''],
],
columns: [
{ width: 24, type: 'text', align: 'left', s: 21 },
{ width: 167, type: 'text', align: 'left', s: 21 },
{ width: 205, type: 'text', align: 'left', s: 21 },
{ width: 81, type: 'text', align: 'left', s: 21 },
{ width: 134, type: 'text', align: 'left', s: 21 },
{ width: 102, type: 'text', align: 'left', s: 21 },
{ width: 61, type: 'text', align: 'left', s: 21 },
{ width: 105, type: 'text', align: 'left', s: 21 },
],
rows: [
{ height: 60 },
{ height: 29 },
{ height: 43 },
{ height: 33 },
{ height: 33 },
{ height: 33 },
{ height: 29 },
{ height: 47 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 30 },
{ height: 39 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 36 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 43 },
{ height: 43 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 43 },
{ height: 43 },
{ height: 29 },
{ height: 29 },
],
cells: {
G3: { format: '0.00%' },
C4: { format: 'm/d/yy' },
C6: { format: '0%' },
E6: { format: '0.00%' },
D26: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E26: { format: '0%' },
D27: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E27: { format: '0%' },
D28: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E28: { format: '0%' },
D29: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E29: { format: '0%' },
D30: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E30: { format: '0%' },
D31: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E31: { format: '0%' },
D32: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E32: { format: '0%' },
D33: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E33: { format: '0%' },
D34: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E34: { format: '0%' },
D35: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E35: { format: '0%' },
D36: {
type: 'dropdown',
source: [
{ id: '★', name: '★' },
{ id: '★★', name: '★★' },
{ id: '★★★', name: '★★★' },
],
},
E36: { format: '0%' },
},
style: {
A1: 21,
B1: 85,
C1: 86,
D1: 86,
E1: 86,
F1: 86,
G1: 1,
H1: 1,
A2: 21,
B2: 1,
C2: 1,
D2: 1,
E2: 1,
F2: 1,
G2: 1,
H2: 1,
A3: 2,
B3: 89,
C3: 87,
D3: 2,
E3: 91,
F3: 91,
G3: 91,
H3: 2,
A4: 2,
B4: 90,
C4: 88,
D4: 2,
E4: 92,
F4: 93,
G4: 93,
H4: 2,
A5: 2,
B5: 90,
C5: 88,
D5: 2,
E5: 92,
F5: 93,
G5: 93,
H5: 2,
A6: 2,
B6: 90,
C6: 88,
D6: 2,
E6: 94,
F6: 95,
G6: 95,
H6: 2,
A7: 2,
B7: 2,
C7: 2,
D7: 2,
E7: 2,
F7: 2,
G7: 2,
H7: 2,
A8: 2,
B8: 2,
C8: 2,
D8: 2,
E8: 2,
F8: 2,
G8: 2,
H8: 2,
A9: 2,
B9: 2,
C9: 2,
D9: 2,
E9: 2,
F9: 2,
G9: 2,
H9: 2,
A10: 2,
B10: 2,
C10: 2,
D10: 2,
E10: 2,
F10: 2,
G10: 2,
H10: 2,
A11: 2,
B11: 2,
C11: 2,
D11: 2,
E11: 2,
F11: 2,
G11: 2,
H11: 2,
A12: 2,
B12: 2,
C12: 2,
D12: 2,
E12: 2,
F12: 2,
G12: 2,
H12: 2,
A13: 2,
B13: 2,
C13: 2,
D13: 2,
E13: 2,
F13: 2,
G13: 2,
H13: 2,
A14: 2,
B14: 2,
C14: 2,
D14: 2,
E14: 2,
F14: 2,
G14: 2,
H14: 2,
A15: 2,
B15: 2,
C15: 2,
D15: 2,
E15: 2,
F15: 2,
G15: 2,
H15: 2,
A16: 2,
B16: 2,
C16: 2,
D16: 2,
E16: 2,
F16: 2,
G16: 2,
H16: 2,
A17: 2,
B17: 2,
C17: 2,
D17: 2,
E17: 2,
F17: 2,
G17: 2,
H17: 2,
A18: 2,
B18: 2,
C18: 2,
D18: 2,
E18: 2,
F18: 2,
G18: 2,
H18: 2,
A19: 2,
B19: 2,
C19: 2,
D19: 2,
E19: 2,
F19: 2,
G19: 2,
H19: 2,
A20: 2,
B20: 2,
C20: 2,
D20: 2,
E20: 2,
F20: 2,
G20: 2,
H20: 2,
A21: 2,
B21: 2,
C21: 2,
D21: 2,
E21: 2,
F21: 2,
G21: 2,
H21: 2,
A22: 2,
B22: 2,
C22: 2,
D22: 2,
E22: 2,
F22: 2,
G22: 2,
H22: 2,
A23: 2,
B23: 9,
C23: 2,
D23: 2,
E23: 2,
F23: 2,
G23: 2,
H23: 2,
A24: 2,
B24: 9,
C24: 2,
D24: 2,
E24: 2,
F24: 2,
G24: 2,
H24: 2,
A25: 2,
B25: 91,
C25: 96,
D25: 96,
E25: 96,
F25: 2,
G25: 2,
H25: 2,
A26: 2,
B26: 97,
C26: 98,
D26: 99,
E26: 98,
F26: 2,
G26: 2,
H26: 2,
A27: 2,
B27: 97,
C27: 98,
D27: 99,
E27: 98,
F27: 2,
G27: 2,
H27: 2,
A28: 2,
B28: 97,
C28: 98,
D28: 99,
E28: 98,
F28: 2,
G28: 2,
H28: 2,
A29: 2,
B29: 97,
C29: 98,
D29: 99,
E29: 98,
F29: 2,
G29: 2,
H29: 2,
A30: 2,
B30: 97,
C30: 98,
D30: 99,
E30: 98,
F30: 2,
G30: 2,
H30: 2,
A31: 2,
B31: 97,
C31: 98,
D31: 99,
E31: 98,
F31: 2,
G31: 2,
H31: 2,
A32: 2,
B32: 97,
C32: 98,
D32: 99,
E32: 98,
F32: 2,
G32: 2,
H32: 2,
A33: 2,
B33: 97,
C33: 98,
D33: 99,
E33: 98,
F33: 58,
G33: 2,
H33: 2,
A34: 2,
B34: 97,
C34: 98,
D34: 99,
E34: 98,
F34: 2,
G34: 2,
H34: 2,
A35: 2,
B35: 97,
C35: 98,
D35: 99,
E35: 98,
F35: 2,
G35: 2,
H35: 2,
A36: 2,
B36: 97,
C36: 98,
D36: 99,
E36: 98,
F36: 2,
G36: 2,
H36: 2,
A37: 2,
B37: 80,
C37: 81,
D37: 81,
E37: 81,
F37: 2,
G37: 2,
H37: 2,
A38: 2,
B38: 2,
C38: 2,
D38: 2,
E38: 2,
F38: 2,
G38: 2,
H38: 2,
},
textOverflow: true,
defaultColAlign: 'left',
worksheetName: 'Project Management Dashboard',
defaultColWidth: 79,
gridline: false,
tableOverflow: true,
tableWidth: 1000,
tableHeight: 620,
resize: 'both',
minDimensions: [8, 38],
media: [
{
id: 'bed231e4-5a3b-4fa1-ad86-72c4a6e4dc2e',
type: 'chart',
options: {
orientation: 1,
range: 'Notes!A17:B20',
headers: true,
title: { text: 'Overall Task' },
labels: 0,
series: [
{ color: '#E69F00' },
{ color: '#56B4E9' },
{ color: '#009E73' },
{ color: '#F0E442' },
{ color: '#0072B2' },
],
type: 'doughnut',
legend: {
display: true,
position: 'right',
},
},
cellAnchor: 'D7',
left: 17,
top: 16,
width: 360,
height: 266,
zIndex: 3,
},
{
id: 'b83e79f9-e076-4f61-8e54-e68a07188036',
type: 'chart',
options: {
orientation: 0,
range: 'Notes!A23:B25',
headers: true,
title: {
text: 'Budget',
},
labels: 0,
datasets: [2, 1],
series: [
{ color: '#E69F00' },
{ color: '#56B4E9' },
{ color: '#009E73' },
{ color: '#F0E442' },
{ color: '#0072B2' },
],
type: 'bar',
legend: { display: true, position: 'top' },
},
cellAnchor: 'B16',
left: 2,
top: 11,
width: 748,
height: 209,
zIndex: 3,
},
{
id: 'a9013968-8bce-4ec4-8e4b-494d06b63dcb',
type: 'chart',
options: {
orientation: 0,
range: 'Notes!A28:B31',
headers: true,
title: {
text: 'Pending Items',
},
labels: 0,
series: [
{ color: '#E69F00' },
{ color: '#56B4E9' },
{ color: '#009E73' },
{ color: '#F0E442' },
{ color: '#0072B2' },
],
type: 'column',
legend: { display: true, position: 'bottom' },
},
cellAnchor: 'B7',
left: 2,
top: 16,
width: 376,
height: 266,
zIndex: 3,
},
],
freezeRowControl: true,
freezeColumnControl: true,
freezeRows: [0],
worksheetId: '18c0eea5-76b9-4774-93eb-c10413b683e8',
meta: {},
comments: {},
cache: {},
mergeCells: {
B1: [5, 1],
E3: [3, 1],
F4: [2, 1],
F5: [2, 1],
F6: [2, 1],
},
},
{
data: [
['Tasks', 'Assigned To', 'Start', 'End', 'Status'],
[
'Set kick-off meeting',
'Alex B.',
'2022-09-02 00:00:00',
'2022-09-03 00:00:00',
'COMPLETE',
],
[
'Agree on objectives',
'Frank C.',
'2022-09-03 00:00:00',
'2022-09-07 00:00:00',
'COMPLETE',
],
[
'Detailed Reqs.',
'Jacob S.',
'2022-09-07 00:00:00',
'2022-09-12 00:00:00',
'COMPLETE',
],
[
'Hardward Reqs.',
'Jacob S.',
'2022-09-09 00:00:00',
'2022-09-11 00:00:00',
'OVERDUE',
],
[
'Final Resource Plan',
'Jacob S.',
'2022-09-11 00:00:00',
'2022-09-15 00:00:00',
'IN PROGRESS',
],
[
'Staffing',
'Alex B.',
'2022-09-16 00:00:00',
'2022-09-17 00:00:00',
'IN PROGRESS',
],
[
'Techincal Reqs.',
'Frank C.',
'2022-09-17 00:00:00',
'2022-09-21 00:00:00',
'COMPLETE',
],
[
'Testing',
'Kennedy K.',
'2022-09-24 00:00:00',
'2022-10-02 00:00:00',
'OVERDUE',
],
[
'Dev. Complete',
'Jacob S.',
'2022-10-02 00:00:00',
'2022-10-05 00:00:00',
'OVERDUE',
],
[
'Hardware Config.',
'Alex B.',
'2022-10-05 00:00:00',
'2022-10-07 00:00:00',
'COMPLETE',
],
[
'System Testing',
'Kennedy K.',
'2022-10-06 00:00:00',
'2022-10-09 00:00:00',
'NOT STARTED',
],
['Launch', '', '', '', ''],
['', '', '', '', ''],
['', '', '', '', ''],
['Percentage of Tasks Complete', '', '', '', ''],
[
'Complete',
'=COUNTIF(E2:E12,"COMPLETE")/COUNTA(E2:E12)',
'',
'',
'',
],
[
'Overdue',
'=COUNTIF(E2:E12,"OVERDUE")/COUNTA(E2:E12)',
'',
'',
'',
],
[
'In progress',
'=COUNTIF(E2:E12,"IN PROGRESS")/COUNTA(E2:E12)',
'',
'',
'',
],
[
'Not Started',
'=COUNTIF(E2:E12,"NOT STARTED")/COUNTA(E2:E12)',
'',
'',
'',
],
['', '', '', '', ''],
['', '', '', '', ''],
['Budget', '', '', '', ''],
['Planned', 80000, '', '', ''],
['Actual', 50000, '', '', ''],
['', '', '', '', ''],
['', '', '', '', ''],
['Pending Items', '', '', '', ''],
['Decisions', 5, '', '', ''],
['Actions', 2, '', '', ''],
['Change Requests ', 4, '', '', ''],
],
columns: [
{ width: 277, type: 'text', align: 'left', s: 38 },
{ width: 125, type: 'text', align: 'left', s: 38 },
{ width: 122, type: 'text', align: 'left', s: 38 },
{ width: 120, type: 'text', align: 'left', s: 38 },
{
width: 163,
type: 'dropdown',
source: [
{ id: 'COMPLETE', name: 'COMPLETE' },
{ id: 'OVERDUE', name: 'OVERDUE' },
{ id: 'IN PROGRESS', name: 'IN PROGRESS' },
{ id: 'NOT STARTED', name: 'NOT STARTED' },
],
align: 'left',
s: 38,
},
],
rows: [
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
{ height: 29 },
],
cells: {
C2: { type: 'calendar', format: 'DD/MM/YYYY' },
D2: { type: 'calendar', format: 'DD/MM/YYYY' },
C3: { type: 'calendar', format: 'DD/MM/YYYY' },
D3: { type: 'calendar', format: 'DD/MM/YYYY' },
C4: { type: 'calendar', format: 'DD/MM/YYYY' },
D4: { type: 'calendar', format: 'DD/MM/YYYY' },
C5: { type: 'calendar', format: 'DD/MM/YYYY' },
D5: { type: 'calendar', format: 'DD/MM/YYYY' },
C6: { type: 'calendar', format: 'DD/MM/YYYY' },
D6: { type: 'calendar', format: 'DD/MM/YYYY' },
C7: { type: 'calendar', format: 'DD/MM/YYYY' },
D7: { type: 'calendar', format: 'DD/MM/YYYY' },
C8: { type: 'calendar', format: 'DD/MM/YYYY' },
D8: { type: 'calendar', format: 'DD/MM/YYYY' },
C9: { type: 'calendar', format: 'DD/MM/YYYY' },
D9: { type: 'calendar', format: 'DD/MM/YYYY' },
C10: { type: 'calendar', format: 'DD/MM/YYYY' },
D10: { type: 'calendar', format: 'DD/MM/YYYY' },
C11: { type: 'calendar', format: 'DD/MM/YYYY' },
D11: { type: 'calendar', format: 'DD/MM/YYYY' },
C12: { type: 'calendar', format: 'DD/MM/YYYY' },
D12: { type: 'calendar', format: 'DD/MM/YYYY' },
C13: { type: 'calendar', format: 'DD/MM/YYYY' },
D13: { type: 'calendar', format: 'DD/MM/YYYY' },
E13: { type: 'text' },
E14: { type: 'text' },
E15: { type: 'text' },
E16: { type: 'text' },
B17: { format: '0.00%' },
E17: { type: 'text' },
B18: { format: '0.00%' },
E18: { type: 'text' },
B19: { format: '0.00%' },
E19: { type: 'text' },
B20: { format: '0.00%' },
E20: { type: 'text' },
E21: { type: 'text' },
E22: { type: 'text' },
E23: { type: 'text' },
B24: { format: '#,##0' },
E24: { type: 'text' },
B25: { format: '#,##0' },
E25: { type: 'text' },
E26: { type: 'text' },
E27: { type: 'text' },
E28: { type: 'text' },
E29: { type: 'text' },
E30: { type: 'text' },
E31: { type: 'text' },
},
style: {
A1: 100,
B1: 101,
C1: 101,
D1: 101,
E1: 101,
F1: 38,
A2: 102,
B2: 103,
C2: 103,
D2: 103,
E2: 104,
F2: 38,
A3: 102,
B3: 103,
C3: 103,
D3: 103,
E3: 104,
F3: 38,
A4: 102,
B4: 103,
C4: 103,
D4: 103,
E4: 104,
F4: 38,
A5: 102,
B5: 103,
C5: 103,
D5: 103,
E5: 104,
F5: 38,
A6: 102,
B6: 103,
C6: 103,
D6: 103,
E6: 104,
F6: 38,
A7: 102,
B7: 103,
C7: 103,
D7: 103,
E7: 104,
F7: 38,
A8: 102,
B8: 103,
C8: 103,
D8: 103,
E8: 104,
F8: 38,
A9: 102,
B9: 103,
C9: 103,
D9: 103,
E9: 104,
F9: 38,
A10: 102,
B10: 103,
C10: 103,
D10: 103,
E10: 104,
F10: 38,
A11: 102,
B11: 103,
C11: 103,
D11: 103,
E11: 104,
F11: 38,
A12: 102,
B12: 103,
C12: 103,
D12: 103,
E12: 104,
F12: 38,
A13: 39,
B13: 40,
C13: 40,
D13: 40,
E13: 84,
F13: 38,
A14: 38,
B14: 38,
C14: 38,
D14: 38,
E14: 38,
F14: 38,
A15: 38,
B15: 38,
C15: 38,
D15: 38,
E15: 38,
F15: 38,
A16: 100,
B16: 101,
C16: 38,
D16: 54,
E16: 54,
F16: 38,
A17: 105,
B17: 106,
C17: 38,
D17: 38,
E17: 38,
F17: 38,
A18: 105,
B18: 106,
C18: 38,
D18: 38,
E18: 38,
F18: 38,
A19: 105,
B19: 106,
C19: 38,
D19: 38,
E19: 38,
F19: 38,
A20: 105,
B20: 106,
C20: 38,
D20: 38,
E20: 38,
F20: 38,
A21: 38,
B21: 38,
C21: 38,
D21: 38,
E21: 38,
F21: 38,
A22: 38,
B22: 38,
C22: 38,
D22: 38,
E22: 38,
F22: 38,
A23: 100,
B23: 101,
C23: 38,
D23: 38,
E23: 38,
F23: 38,
A24: 107,
B24: 108,
C24: 38,
D24: 38,
E24: 38,
F24: 38,
A25: 105,
B25: 106,
C25: 38,
D25: 38,
E25: 38,
F25: 38,
A26: 38,
B26: 38,
C26: 38,
D26: 38,
E26: 38,
F26: 38,
A27: 38,
B27: 38,
C27: 38,
D27: 38,
E27: 38,
F27: 38,
A28: 100,
B28: 101,
C28: 38,
D28: 38,
E28: 38,
F28: 38,
A29: 109,
B29: 110,
C29: 38,
D29: 38,
E29: 38,
F29: 38,
A30: 109,
B30: 110,
C30: 38,
D30: 38,
E30: 38,
F30: 38,
A31: 111,
B31: 112,
C31: 38,
D31: 38,
E31: 38,
F31: 38,
},
textOverflow: true,
defaultColAlign: 'left',
tableOverflow: true,
tableWidth: 1000,
tableHeight: 620,
resize: 'both',
worksheetName: 'Notes',
defaultColWidth: 79,
gridline: false,
minDimensions: [5, 31],
worksheetId: 'd537423b-d382-4ff9-aafc-dbfa12a9dcd8',
meta: {},
comments: {},
cache: {},
mergeCells: { A16: [2, 1], A23: [2, 1], A28: [2, 1] },
},
],
toolbar: true,
});
}
}