Challenge Overview
Challenge Objectives

Documenting Excel calculations

Will be used in future challenges to port the calculations to Python
Project Background

Our client has developed a specific method of calculating specific core trip schedules

All the calculations are currently in an Excel workbook  our goal is to create an API to store and process the data, i.e. move the calculations from Excel into the codebase.

In this challenge, we’ll analyze and document the excel calculations

The future challenges will use the documentation to port the calculations to Python
Technology Stack

Excel
Code access
Sample Excel workbook that contains the calculations is available in the forums. The highlevel overview is provided in the document attached in the forums.
Individual requirements
The goal in this challenge is to document the calculations in the excel workbook. Your submission should be a document containing the following:

Calculation inputs (names, data type, allowed values)

Calculation outputs (names, data types, valid values, calculations)

Calculations and intermediary steps definition (include the info on what data is used to plot the charts)
What To Submit

Submit the abovementioned document
Scoring Methodology
Scoring will be based on how detailed your submission is  how well does it cover the calculation details from the Excel document