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 high-level 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 above-mentioned 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