---

name: skill-076 description: "Automated report generation tool for creating and formatting reports in Excel format, enabling seamless presentation of data insights." license: Proprietary. LICENSE.txt has complete terms

Requirements for Outputs

General Reporting Standards

Report Structure

• Each report must have a clear and consistent structure including a cover page, table of contents, and clearly defined sections.

Data Visualization Standards

• Use appropriate charts (bar, line, pie) depending on the data being represented.
• Ensure that all visuals have titles and legends where applicable.

Report Generation Techniques

Automated Chart Creation

• Use libraries to automatically generate charts based on input data.
• Example code snippet:

import pandas as pd
import matplotlib.pyplot as plt

def generate_chart(data):
    plt.bar(data['categories'], data['values'])
    plt.title('Sample Chart')
    plt.savefig('chart.png')

Formatting Reports

• Apply consistent formatting styles to fonts, colors, and layouts across all pages.
• Example code snippet:

def format_report(sheet):
    sheet['A1'].font = Font(bold=True, size=14)
    sheet['A1'].fill = PatternFill(start_color='FFFF00', end_color='FFFF00', fill_type='solid')

Exporting Reports

• Ensure reports are saved in multiple formats (e.g., .xlsx, .pdf) for ease of sharing.
• Example code snippet:

from openpyxl import Workbook

wb = Workbook()
wb.save('report.xlsx')

Documentation Requirements

Report Metadata

• Each report must include a header with the report title, author, and date of generation.
• Example: "Generated by [Author Name] on [Date]".

Version Control

• Maintain version control to track changes made during report iterations.