skill-076

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.