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 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