Challenge Overview
Challenge Objectives
-
Documenting Excel macros
-
Will be used in future challenges to port the calculations to Python
Project Background
-
Our client has developed a specific method of calculating specific oil properties
-
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 with around 12 macros
-
The future challenge will use the documentation to port the calculations to Python
Technology Stack
-
Excel
Code access
Sample Excel workbook that contains the macros is available in the forums.
Individual requirements
The goal in this challenge is to document the excel macros and 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)
-
Macros documentation (what each of them does - inputs, dependent functions, calculation steps, and outputs)
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