Code Sections

Each Resolver One workbook is actually completely expressed as Python code. Though only the user code is directly editable, Resolver One displays all eight sections that make up each worksheet's program.

This program is executed in the following order.

1. License

The text of the license selected for this spreadsheet.

2. Import statements

  • Loads appropriate background data, libraries and databases.
  • Creates a workbook to hold the results.

This code is not editable.

3. Worksheet creation

  • Creates the worksheets and loads functions that track the headers and bounds of data.
  • Loads any data requested from external sources such as database worksheets.

This code is not editable.

4. Pre-constants user code

This editable code allows you to...

  • Set up your workbook by defining your own variables and functions.
  • Manipulate data from external sources such as databases.
  • Take other actions such as: define functions for later use; change date format; and load selected external data.

5. Constants and formatting

Comprises two lists:

  • Values of workbook cells containing constants.
  • Formatting traits (e.g. boldness, font, borders...) for all cells, regardless of what they contain.

The cells are listed using a numeric index, e.g. cell D1 is written as (4, 1).

This code is not directly editable. However, editing the worksheets changes this code.

6. Pre-formulae user code

This editable code defines functions that are entered in cells, but that depend on constants. These functions allow you to tweak your calculations since the values to be defined by formulae have yet to be calculated.

7. Formula code

Formulae entered into any sheet within the workbook.

This code is not directly editable. However, editing the formulae in the worksheets changes this code.

8. Post-formula user code

This editable code defines functions used to polish the results, e.g. by highlighting, isolating, sorting and/or manipulating outputs for re-use elsewhere.

Previous: The Coding Pane

Next: The Output Pane

Up: Quick-Start Guide

Comments