Products

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,
    });
  }
}