Develop an excel-based Scope 3 (category 6 and category 7 – Business Travel and

Develop an excel-based Scope 3 (category 6 and category 7 – Business Travel and employee commuting) Calculator.
This calculator will specifically focus on Category 6 (Business Travel) and Category 7 (Employee Commuting) emissions to facilitate our reporting obligations.
The scope of the project includes:
1. **Development of an Excel-Based Calculator:**
– The calculator should allow users to input data easily, such as the number of travels, employee cars, estimated commuting distances, etc., to compute Scope 3 emissions.
– Ensure user-friendliness with well-defined parameters, equations, constants, and emissions factors.
2. **Data Sources and References:**
– Clearly define and include sources for emissions factors, constants, and variables used in the calculator.
– List assumptions made and provide references for data sources used in the emissions calculations.
3. **Design and Visual Appeal:**
– Create an appealing design for the Excel sheet, including demonstrative pictures or visuals, to enhance user-friendliness and engagement.
4. **Example Sheet:**
– Include a separate sheet within the Excel file that demonstrates how inputting values generates the resultant CO2 equivalent, showcasing a detailed example with all necessary inputs.
5. **Detailed Requirements:**
– Define and include the equations, assumptions, and detailed parameters needed for accurate emissions calculation in the example sheet.

We aim to ensure that the tool provides a user-friendly interface while being robust in capturing and calculating emissions data accurately. We also prioritize transparency and reliability by including comprehensive sources and references for all input factors.
The final deliverable should be an Excel-based tool that assists us in calculating Scope 3 emissions related to business travel and employee commuting, aligning with our sustainability reporting needs.
* Scope 3 emissions needs to include air, rail, car and hotel stays