Gestion d’un ratio en fonction du contexte de filtre
-
Gestion d’un ratio en fonction du contexte de filtre
Bonjour,
Je cherche à construire une formule pour dupliquer les volumes en fonction du niveau de granulométrie de l’analyse dans le but de construire un ratio €/T.
Pour le contexte, voici un aperçu de la table de fait
<table style=”border-collapse: collapse; width: 549px;” border=”0″ width=”594″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”width: 71.8229px;” span=”2″ width=”80″> <col style=”width: 104.333px;” width=”113″> <col style=”width: 147.333px;” width=”161″> <col style=”width: 75.3333px;” span=”2″ width=”80″> </colgroup>
<tbody>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; width: 60pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #4472C4; mso-pattern: #4472C4 none;” width=”80″ height=”19″>date</td>
<td style=”width: 60pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”80″>Site</td>
<td style=”width: 85pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”113″>type matière</td>
<td style=”width: 121pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”161″>catégorie dépense</td>
<td style=”width: 60pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”80″>Qté</td>
<td style=”width: 60pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”80″>valeur €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl64″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S1</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MA</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D1</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right”>500</td>
<td class=”xl69″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 100 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl66″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> </td>
<td class=”xl70″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 20 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl66″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D3</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl70″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 15 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl67″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: .5pt solid windowtext;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none;”>S1</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none;”>MA</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none;”>D4</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none;”> </td>
<td class=”xl71″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid windowtext; border-left: none;”> 60 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl64″ style=”height: 14.5pt; border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl65″ style=”border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S1</td>
<td class=”xl65″ style=”border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MB</td>
<td class=”xl65″ style=”border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D1</td>
<td class=”xl65″ style=”border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right”>450</td>
<td class=”xl69″ style=”border-top: .5pt solid windowtext; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 110 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl66″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MB</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D3</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> </td>
<td class=”xl70″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 30 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl67″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S1</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MB</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D5</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl71″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 25 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl63″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;” align=”right”>400</td>
<td class=”xl72″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 90 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl63″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D6</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl72″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 10 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl63″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D7</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> </td>
<td class=”xl72″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 20 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl64″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S2</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MC</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D1</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right”>300</td>
<td class=”xl69″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid windowtext; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 70 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl66″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid windowtext;” align=”right” height=”19″>01/01/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MC</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> </td>
<td class=”xl70″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 10 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl67″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: .5pt solid windowtext; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/01/2024</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S2</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MC</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D5</td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl71″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid windowtext; border-bottom: .5pt solid windowtext; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 5 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl63″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” align=”right” height=”19″>01/02/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>S1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>D1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;” align=”right”>550</td>
<td class=”xl72″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 120 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl63″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” align=”right” height=”19″>01/02/2024</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>S1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MA</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>D2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl72″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 15 €</td>
</tr>
</tbody>
</table>J’ai également 2 tables de dimensions, une table calendrier et une table “catégorie”:
<table style=”border-collapse: collapse; width: 184pt;” border=”0″ width=”244″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”mso-width-source: userset; mso-width-alt: 4631; width: 100pt;” width=”133″> <col style=”mso-width-source: userset; mso-width-alt: 3886; width: 84pt;” width=”111″> </colgroup>
<tbody>
<tr style=”height: 14.5pt;”>
<td class=”xl65″ style=”height: 14.5pt; width: 100pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #4472C4; mso-pattern: #4472C4 none;” width=”133″ height=”19″>catégorie dépense</td>
<td style=”width: 84pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;” width=”111″>Type dépenses</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″>D1</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>TA</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” height=”19″>D2</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”>TA</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″>D3</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>TA</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” height=”19″>D4</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”>TB</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″>D5</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>TB</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” height=”19″>D6</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”>TB</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″>D7</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>TC</td>
</tr>
</tbody>
</table>L’objectif étant donc de pouvoir calculer un €/T sur les différentes catégories/types de dépenses par site, matière ou les 2,
Pour avoir une idée pour l’attendu:
<table style=”border-collapse: collapse; width: 318pt;” border=”0″ width=”423″ cellspacing=”0″ cellpadding=”0″><colgroup><col style=”width: 60pt;” span=”2″ width=”80″> <col style=”mso-width-source: userset; mso-width-alt: 3607; width: 78pt;” width=”103″> <col style=”width: 60pt;” span=”2″ width=”80″> </colgroup>
<tbody>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; width: 60pt;” width=”80″ height=”19″> </td>
<td style=”width: 60pt;” width=”80″>€/qté</td>
<td style=”width: 78pt;” width=”103″> </td>
<td style=”width: 60pt;” width=”80″>date</td>
<td style=”width: 60pt;” width=”80″> </td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #4472C4; mso-pattern: #4472C4 none;” height=”19″>Site</td>
<td style=”font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;”>matière</td>
<td style=”font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;”>type dépense</td>
<td style=”font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;”>2024.01</td>
<td style=”font-size: 11.0pt; color: white; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #4472C4; mso-pattern: #4472C4 none;”>2024.02</td>
</tr>
<tr style=”height: 14.5pt;”>
<td class=”xl66″ style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″>S1</td>
<td class=”xl66″ style=”font-size: 11.0pt; color: black; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>MA</td>
<td class=”xl66″ style=”font-size: 11.0pt; color: black; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td class=”xl68″ style=”font-size: 11.0pt; color: black; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 0,39 €</td>
<td class=”xl66″ style=”font-size: 11.0pt; color: black; font-weight: bold; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB;” height=”19″> </td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> </td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”>TA</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 0,27 €</td>
<td class=”xl65″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none;”> 0,25 €</td>
</tr>
<tr style=”height: 14.5pt;”>
<td style=”height: 14.5pt; font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: .5pt solid #8EA9DB; background: #D9E1F2; mso-pattern: #D9E1F2 none;” height=”19″> </td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”>TB</td>
<td class=”xl67″ style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: none; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> 0,12 €</td>
<td style=”font-size: 11.0pt; color: black; font-weight: 400; text-decoration: none; text-underline-style: none; text-line-through: none; font-family: Calibri, sans-serif; border-top: .5pt solid #8EA9DB; border-right: .5pt solid #8EA9DB; border-bottom: .5pt solid #8EA9DB; border-left: none; background: #D9E1F2; mso-pattern: #D9E1F2 none;”> </td>
</tr>
</tbody>
</table>Merci pour votre aide,
A disposition
Bonne journée!
Florian
Désolé, aucune réponse n’a été trouvée.
Connectez-vous pour répondre.