9.5 Spreadsheets for individual contracts

Each contract has a separate spreadsheet, which can be accessed by clicking on the contract in the overview under Title.

All details of an individual contract are displayed in the spreadsheet.

To return to the overview, click on Menu. Note that the individual contracts tab won’t be displayed or updated until you click on the contract in the menu. The individual contract tab can be removed by pressing Clear lease sheet. You can go directly from the contract file to the individual contract in SharePoint by tapping Open in SharePoint in the upper right corner (Note that the SharePoint add-in will open each time you click on the tab). This functionality makes it easier and faster to review and make changes to an individual contract, since you no longer need to locate the contract in SharePoint.

The data comes from SharePoint for each contract. It’s possible to modify the data directly in Excel, but since there’s no link back to SharePoint, changes made in Excel will not be updated in SharePoint.

Contract periods are at the top of each individual contract’s spreadsheet.

Other data registered in SharePoint will be displayed by pressing the button on the left side of Metadata. You hide it by pressing the button.

Under Calculations, you can access contract payments on a monthly basis, moving forward. For each contract you’ll find data for each period, as illustrated in the overview below:

If any manual adjustments are made to the spreadsheets for individual contracts, the sheet with changes will automatically marked in red. You’ll get a warning if any worksheet in the file has been changed manually.