Required software: Microsoft Excel for the quantitative and Microsoft Power Point for the qualitative questions and overall presentation. Topic: For this exercise, We would like you to study the energy sector of Germany and present your findings on the following tasks: 1. Summarize This task will analyze your ability to gather information on several topics, compress (while keeping the important information intact) and present the information in a palatable form. Create a detailed flow diagram which comprehensively encapsulates the power grid of Germany including Generation, Transmission and Distribution. It should include: a. An overview of generation capacity (GW) Germany is producing split by the generation technology (Conventional, Wind, PV etc.) b. An estimate of transmission and distribution line lengths (km) in the country C. The exact voltage levels operating in transmission (EHV, HV) and distribution (MV and LV) grid of the country d. Number of substations/transformers installed in transmission and distribution network of the country e. Number of grid operators functioning in the transmission and distribution 8:05