from typing import Dict


def get_column_formats_by_sheet_name() -> Dict[str, Dict[str, Dict[str, str]]]:
    """
    Get the Excel cell formats for each column in each of the sheets in the output XLSX file.
    :return: Nested dictionary of Excel cell formats.
    """
    # Cell formats
    format_str: Dict[str, str] = {}
    format_int: Dict[str, str] = {"num_format": "#0"}
    format_float2: Dict[str, str] = {"num_format": "#,##0.00"}
    format_float4: Dict[str, str] = {"num_format": "#,####0.0000"}

    # Column formats by sheet name
    column_formats_by_sheet_name = {
        "mouse_grouping": {
            "group": format_int,
            "mouse_id": format_int,
            "tumor_size": format_float2,
        },
        "group_statistics": {
            "group": format_int,
            "num_mice_in_group": format_int,
            "mouse_ids_in_group": format_str,
            "tumor_size_mean": format_float2,
            "overall_mean_diff": format_float4,
        },
    }
    return column_formats_by_sheet_name