URL_GGSHEET="https://docs.google.com/spreadsheets/d/1cZ_YiFHMzthglWVBrmHyHApA5mxb_cMQVMzow-62CvU/gviz/tq?gid={gid}&range={range}"

# URL_GGSHEET.format(gid=1234, range="A2:A4")

# gid=982164191&range=A1:F7

GGSHEET_GID = {
    "promo": 982164191,
    "promoind": 1071262669,
    "global": 345687538
}

GGSHEET_PROMO_RANGE = {
    "CDA1": "A1:F7",
    "CDA2": "K1:P7",
    "DWWM1": "A9:F15",
    "DWWM2": "K9:P15"
}

GGSHEET_ALL_RANGE = {
    "materiel":"A1:B2",
    "pedago":"C1:D2",
    "echange":"E1:F2",
    "satisfaction":"G1:H2"
}

GGSHEET_QUART1_RANGE = {
    "CDA1": {
        "1-Méthode pédagogique":"A1:B2",
        "2-Progression":"A3:B4",
        "3-Organisation matérielle":"A5:B6",
        "4-Moyens pédagogiques":"A7:B8",
        "5-Echanges dans le groupe":"A9:B10",
        "6-Satisfaction":"A11:B12"
    },
    "CDA2": {
        "1-Méthode pédagogique":"H1:I2",
        "2-Progression":"H3:I4",
        "3-Organisation matérielle":"H5:I6",
        "4-Moyens pédagogiques":"H7:I8",
        "5-Echanges dans le groupe":"H9:I10",
        "6-Satisfaction":"H11:I12"
    }
}

GGSHEET_QUART3_RANGE = {
    "CDA1": {
        "1-Méthode pédagogique": "C1:D2",
        "2-Progression":"C3:D4",
        "3-Organisation matérielle":"C5:D6",
        "4-Moyens pédagogiques":"C7:D8",
        "5-Echanges dans le groupe":"C9:D10",
        "6-Satisfaction":"C11:D12",
    },
    "CDA2": {
        "1-Méthode pédagogique":"J1:K2",
        "2-Progression":"J3:K4",
        "3-Organisation matérielle":"J5:K6",
        "4-Moyens pédagogiques":"J7:K8",
        "5-Echanges dans le groupe":"L9:M10",
        "6-Satisfaction":"J11:K12"
    }
}
GGSHEET_MOYENNE_RANGE = {
    "CDA1": {
        "1-Méthode pédagogique":"E1:F2",
        "2-Progression":"E3:F4",
        "3-Organisation matérielle":"E5:F6",
        "4-Moyens pédagogiques":"A7:B8",
        "Q4quart3":"E7:F8",
        "5-Echanges dans le groupe":"E9:F10",
        "6-Satisfaction":"E11:F12"
    },
    "CDA2": {
        "1-Méthode pédagogique":"L1:M2",
        "2-Progression":"L3:M4",
        "3-Organisation matérielle":"L5:M6",
        "4-Moyens pédagogiques":"L7:M8",
        "5-Echanges dans le groupe":"L9:M10",
        "6-Satisfaction":"L11:M12"
    }
}

# GGSHEET_CDA1_QUART1_RANGE = {
#     "1-Méthode pédagogique":"A1:B2",
#     "2-Progression":"A3:B4",
#     "3-Organisation matérielle":"A5:B6",
#     "4-Moyens pédagogiques":"A7:B8",
#     "5-Echanges dans le groupe":"A9:B10",
#     "6-Satisfaction":"A11:B12"
# }
# GGSHEET_CDA1_QUART3_RANGE = {
#     "1-Méthode pédagogique": "C1:D2",
#     "2-Progression":"C3:D4",
#     "3-Organisation matérielle":"C5:D6",
#     "4-Moyens pédagogiques":"C7:D8",
#     "5-Echanges dans le groupe":"C9:D10",
#     "6-Satisfaction":"C11:D12",
# }

# GGSHEET_CDA1_MOYENNE_RANGE = {
#     "1-Méthode pédagogique":"E1:F2",
#     "2-Progression":"E3:F4",
#     "3-Organisation matérielle":"E5:F6",
#     "4-Moyens pédagogiques":"A7:B8",
#     "Q4quart3":"E7:F8",
#     "5-Echanges dans le groupe":"E9:F10",
#     "6-Satisfaction":"E11:F12"
# }

# GGSHEET_CDA2_QUART1_RANGE = {
#     "1-Méthode pédagogique":"H1:I2",
#     "2-Progression":"H3:I4",
#     "3-Organisation matérielle":"H5:I6",
#     "4-Moyens pédagogiques":"H7:I8",
#     "5-Echanges dans le groupe":"H9:I10",
#     "6-Satisfaction":"H11:I12"
# }

# GGSHEET_CDA2_QUART3_RANGE = {
#     "1-Méthode pédagogique":"J1:K2",
#     "2-Progression":"J3:K4",
#     "3-Organisation matérielle":"J5:K6",
#     "4-Moyens pédagogiques":"J7:K8",
#     "5-Echanges dans le groupe":"L9:M10",
#     "6-Satisfaction":"J11:K12"
# }

# GGSHEET_CDA2_MOYENNE_RANGE = {
#     "1-Méthode pédagogique":"L1:M2",
#     "2-Progression":"L3:M4",
#     "3-Organisation matérielle":"L5:M6",
#     "4-Moyens pédagogiques":"L7:M8",
#     "5-Echanges dans le groupe":"L9:M10",
#     "6-Satisfaction":"L11:M12"
# }


GGSHEET_CDA3_RANGE = {
    "Q1quart1":"A14:B15",
    "Q1quart3":"C14:D15",
    "Q1Moyenne":"E14:F15",
    "Q2quart1":"A16:B17",
    "Q2quart3":"C16:D17",
    "Q2Moyenne":"E16:F17",
    "Q3quart1":"A18:B19",
    "Q3quart3":"C18:D19",
    "Q3Moyenne":"E18:F19",
    "Q4quart1":"A20:B21",
    "Q4quart3":"C20:D21",
    "Q4Moyenne":"E20:F21",
    "Q5quart1":"A22:B23",
    "Q5quart3":"C22:D23",
    "Q5Moyenne":"E22:F23",
    "Q6quart1":"A24:B25",
    "Q6quart3":"C24:D25",
    "Q6Moyenne":"E24:F25"
}
GGSHEET_CDA4_RANGE = {
    "Q1quart1":"H14:I15",
    "Q1quart3":"J14:K15",
    "Q1Moyenne":"L14:M15",
    "Q2quart1":"H16:I17",
    "Q2quart3":"J16:K17",
    "Q2Moyenne":"L16:M17",
    "Q3quart1":"H18:I19",
    "Q3quart3":"J18:K19",
    "Q3Moyenne":"L18:M19",
    "Q4quart1":"H20:I21",
    "Q4quart3":"J20:K21",
    "Q4Moyenne":"L20:M21",
    "Q5quart1":"H22:I23",
    "Q5quart3":"J22:K23",
    "Q5Moyenne":"L22:M23",
    "Q6quart1":"H24:I25",
    "Q6quart3":"J24:K25",
    "Q6Moyenne":"L24:M25"
}
