Z (0) |
A (1) |
B (2) |
C (3) |
D (4) |
E (5) |
F (6) |
G (7) |
H (8) |
I (9) |
J (10) |
K (11) |
L (12) |
M (13) |
N (14) |
O (15) |
P (16) |
Q (17) |
R (18) |
S (19) |
T (20) |
U (21) |
V (22) |
W (23) |
X (24) |
Y (25) |
Z (26) |
AA (27) |
AB (28) |
AC (29) |
AD (30) |
AE (31) |
AF (32) |
AG (33) |
AH (34) |
AI (35) |
AJ (36) |
AK (37) |
AL (38) |
AM (39) |
AN (40) |
AO (41) |
AP (42) |
AQ (43) |
AR (44) |
AS (45) |
AT (46) |
AU (47) |
AV (48) |
AW (49) |
AX (50) |
AY (51) |
AZ (52) |
BA (53) |
BB (54) |
BC (55) |
BD (56) |
BE (57) |
BF (58) |
BG (59) |
BH (60) |
BI (61) |
BJ (62) |
BK (63) |
BL (64) |
BM (65) |
1 |
v.3.6.2 Nom Statmens |
LoterieRomande_03_MensTotal_Eau.xls |
Données de l'année en cours 2023 |
num mois |
Année |
Onglet |
|
QUANTITES |
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
|
COUTS |
|
|
Total part variable avec la conso. |
Total part fixe (Taxes) |
|
|
T4 : Tarif moyen manuel appliquée à l'année en cours |
|
|
|
|
|
T4 : Tarif moyen manuel appliquée à l'année de réf. |
|
|
|
|
|
|
|
T5 sur l'année en cours : Tarif selon marco |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
Onglet éco. |
1DONNEE |
|
|
|
numColonne |
|
3 |
5 |
5 |
|
8 |
7 |
|
11 |
9 |
|
14 |
13 |
|
|
11 |
|
|
|
|
|
|
Coût D1 |
Coût D2 |
Coût D3 |
Coût D4 |
Total T4 |
|
Coût D1 |
Coût D2 |
Coût D3 |
Coût D4 |
Total T4 |
|
|
|
Coût D1 |
Coût D2 |
Coût D3 |
Coût D4 |
Total T5 |
Coût fixe 1 |
Coût fixe 2 |
Coût fixe 3 |
Coût fixe 4 |
Coût fixe tot. (Taxe) |
TOTAL |
|
|
|
|
|
|
|
|
|
|
|
|
3 |
Mois en cours |
10.00 |
|
|
|
44926.00 |
|
|
D1 |
|
|
D2 |
|
|
D3 |
|
|
D4 |
|
|
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
Année en cours |
2023.00 |
|
|
|
numLigne |
nb. jours |
Date |
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
|
Fr. HTVA |
|
|
|
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
|
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
|
|
|
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
Fr. HTVA |
|
|
|
|
|
|
|
|
|
|
|
|
5 |
Année de réf. |
2022.00 |
|
1.00 |
2023.00 |
144.00 |
31.00 |
44957.00 |
232.76 |
740.18 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
232.76 |
1291.30 |
5.55 |
|
740.18 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
6 |
Prem année mens. |
2012.00 |
|
2.00 |
2023.00 |
145.00 |
28.00 |
44985.00 |
237.70 |
755.89 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
237.70 |
1307.01 |
5.50 |
|
755.89 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
44.43 |
0 |
0 |
0 |
44.43 |
0 |
0 |
0 |
0 |
0 |
44.43 |
|
|
|
|
|
|
|
|
|
|
|
|
7 |
Ligne Année en cours |
144.00 |
|
3.00 |
2023.00 |
146.00 |
31.00 |
45016.00 |
279.39 |
888.46 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
279.39 |
1439.59 |
5.15 |
|
888.46 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
8 |
Ligne Année réf. |
132.00 |
|
4.00 |
2023.00 |
147.00 |
30.00 |
45046.00 |
223.74 |
711.49 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
223.74 |
1262.62 |
5.64 |
|
711.49 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
47.59 |
|
|
|
|
|
|
|
|
|
|
|
|
9 |
Prise en compte d'un chang. de la part fixe |
1 |
|
5.00 |
2023.00 |
148.00 |
31.00 |
45077.00 |
274.67 |
873.45 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
274.67 |
1424.58 |
5.19 |
|
873.45 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
11 |
Part fixe corr. Nb jours |
|
|
7.00 |
2023.00 |
150.00 |
31.00 |
45138.00 |
379.41 |
1206.52 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
379.41 |
1757.65 |
4.63 |
|
1206.52 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
12 |
Coefficient |
1.00 |
|
8.00 |
2023.00 |
151.00 |
31.00 |
45169.00 |
456.69 |
1452.27 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
456.69 |
2003.40 |
4.39 |
|
1452.27 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
13 |
Facteur de corr. Mois/Annuel |
304.00 |
|
9.00 |
2023.00 |
152.00 |
30.00 |
45199.00 |
269.56 |
857.20 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
269.56 |
1408.33 |
5.22 |
|
857.20 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
47.59 |
|
|
|
|
|
|
|
|
|
|
|
|
14 |
Nb. de relevé annuel |
12.00 |
|
10.00 |
2023.00 |
153.00 |
31.00 |
45230.00 |
245.46 |
780.56 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
245.46 |
1331.69 |
5.43 |
|
780.56 |
551.13 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
49.18 |
|
|
|
|
|
|
|
|
|
|
|
|
15 |
Chiffre du 1er mois représenté |
1.00 |
|
11.00 |
2023.00 |
154.00 |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
#N/A |
#N/A |
#N/A |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
0 |
0 |
0 |
0 |
0 |
|
#N/A |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
|
|
|
|
|
|
|
|
|
|
|
16 |
Si calcul du coût avec pointe année -1 |
|
|
12.00 |
2023.00 |
155.00 |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
#N/A |
#N/A |
#N/A |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
0 |
0 |
0 |
0 |
0 |
|
#N/A |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
|
|
|
|
|
|
|
|
|
|
|
17 |
Pointe payée 2023 |
|
|
|
|
|
304.00 |
|
2944.22 |
9362.62 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5511.25 |
0 |
2944.22 |
14873.87 |
5.05 |
|
9362.62 |
5511.25 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
482.28 |
0 |
0 |
0 |
482.28 |
0 |
0 |
0 |
0 |
0 |
482.28 |
|
|
|
|
|
|
|
|
|
|
|
|
18 |
Pointe payée 2022 |
|
|
|
|
|
|
corr. 304 j. |
2944.22 |
9362.62 |
|
0 |
0 |
|
0 |
0 |
|
0 |
5511.25 |
|
2944.22 |
14873.87 |
5.05 |
corr. 304 j. |
9362.62 |
5511.25 |
3.18 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
|
0 |
|
482.28 |
0 |
0 |
0 |
482.28 |
0 |
0 |
0 |
0 |
0 |
482.28 |
|
|
|
|
|
|
|
|
|
|
|
|
19 |
Tarif T4 D1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tarif moy. Tout compris |
|
5.05 |
|
|
2944.22 |
m³ |
9362.62 |
Fr. HTVA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
20 |
Tarif T4 D2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Tarif moy. Energie seule |
3.18 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
21 |
Tarif T4 D3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
22 |
Tarif T4 D4 |
|
|
|
|
Depuis début opti. |
123.00 |
|
1351.12 |
4296.56 |
|
0 |
0 |
|
0 |
0 |
|
0 |
2204.50 |
|
|
6501.06 |
|
|
4296.56 |
2204.50 |
4296.56 |
|
|
|
|
|
0 |
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
23 |
Unité de représentation |
m³ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1593.10 |
|
|
|
1351.12 |
m³ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24 |
Coefficient de représent. |
1.00 |
Données de l'année de réf. 2022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25 |
Unité des coûts |
Fr. HTVA |
|
|
|
Onglet |
|
QUANTITES |
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
QUANTITES |
COUTS |
|
|
COUTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26 |
Eco. taxe fixe estimée
(seulement avec T4) |
|
|
|
|
numColonne |
|
3 |
5 |
5 |
|
8 |
7 |
|
11 |
9 |
|
14 |
13 |
|
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T5 : Tarif selon macro |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28 |
Mois début d'opti. |
7.00 |
|
|
|
numLigne |
nb. jours |
Date |
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
m³ |
Fr. HTVA |
|
|
Fr. HTVA |
|
|
Fr. HTVA |
|
|
|
1.00 |
0 |
0 |
0 |
0.44 |
0.56 |
|
|
|
|
|
|
|
(Conso.) |
|
|
|
|
(Taxes) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
29 |
Choix du Tarif |
T2 |
|
1.00 |
2022.00 |
132.00 |
31.00 |
44592.00 |
135.59 |
431.18 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
135.59 |
981.30 |
7.24 |
|
431.18 |
550.13 |
3.18 |
|
431.18 |
0 |
0 |
0 |
431.18 |
550.13 |
981.30 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30 |
Répartition selon réf. |
1 |
|
2.00 |
2022.00 |
133.00 |
28.00 |
44620.00 |
197.74 |
628.81 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
197.74 |
1178.94 |
5.96 |
|
628.81 |
550.13 |
3.18 |
|
628.81 |
0 |
0 |
0 |
628.81 |
550.13 |
1178.94 |
|
|
44.43 |
0 |
0 |
0 |
44.43 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
31 |
NomOnglets |
EauTOT |
|
3.00 |
2022.00 |
134.00 |
31.00 |
44651.00 |
71.01 |
225.81 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
71.01 |
775.94 |
10.93 |
|
225.81 |
550.13 |
3.18 |
|
225.81 |
0 |
0 |
0 |
225.81 |
550.13 |
775.94 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
32 |
Type Tarif pour T5 (conso.) D1 |
SIGeau2015_TOT |
|
4.00 |
2022.00 |
135.00 |
30.00 |
44681.00 |
168.13 |
534.65 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
168.13 |
1084.78 |
6.45 |
|
534.65 |
550.13 |
3.18 |
|
534.65 |
0 |
0 |
0 |
534.65 |
550.13 |
1084.78 |
|
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
33 |
Paramètre (Var1) pour T5 (texte) D1 |
|
|
5.00 |
2022.00 |
136.00 |
31.00 |
44712.00 |
297.92 |
947.39 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
297.92 |
1497.51 |
5.03 |
|
947.39 |
550.13 |
3.18 |
|
947.39 |
0 |
0 |
0 |
947.39 |
550.13 |
1497.51 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
34 |
Type Tarif pour T5 (taxe) D1 |
|
|
6.00 |
2022.00 |
137.00 |
30.00 |
44742.00 |
302.63 |
962.36 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
302.63 |
1512.49 |
5.00 |
|
962.36 |
550.13 |
3.18 |
|
962.36 |
0 |
0 |
0 |
962.36 |
550.13 |
1512.49 |
|
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
35 |
Paramètre (Var1) pour T5 (texte) D1 |
|
|
7.00 |
2022.00 |
138.00 |
31.00 |
44773.00 |
284.07 |
903.34 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
284.07 |
1453.47 |
5.12 |
|
903.34 |
550.13 |
3.18 |
|
903.34 |
0 |
0 |
0 |
903.34 |
550.13 |
1453.47 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
36 |
Type Tarif pour T5 (conso.) D2 |
|
|
8.00 |
2022.00 |
139.00 |
31.00 |
44804.00 |
341.57 |
1086.19 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
550.13 |
0 |
341.57 |
1636.32 |
4.79 |
|
1086.19 |
550.13 |
3.18 |
|
1086.19 |
0 |
0 |
0 |
1086.19 |
550.13 |
1636.32 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
37 |
Paramètre (Var1) pour T5 (texte) D2 |
|
|
9.00 |
2022.00 |
140.00 |
30.00 |
44834.00 |
241.59 |
768.26 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
241.59 |
1319.38 |
5.46 |
|
768.26 |
551.13 |
3.18 |
|
768.26 |
0 |
0 |
0 |
768.26 |
551.13 |
1319.38 |
|
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
38 |
Type Tarif pour T5 (taxe) D2 |
|
|
10.00 |
2022.00 |
141.00 |
31.00 |
44865.00 |
252.25 |
802.16 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
252.25 |
1353.28 |
5.36 |
|
802.16 |
551.13 |
3.18 |
|
802.16 |
0 |
0 |
0 |
802.16 |
551.13 |
1353.28 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
39 |
Paramètre (Var1) pour T5 (texte) D2 |
|
|
11.00 |
2022.00 |
142.00 |
30.00 |
44895.00 |
267.41 |
850.36 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
267.41 |
1401.49 |
5.24 |
|
850.36 |
551.13 |
3.18 |
|
850.36 |
0 |
0 |
0 |
850.36 |
551.13 |
1401.49 |
|
|
47.59 |
0 |
0 |
0 |
47.59 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
40 |
Type Tarif pour T5 (conso.) D3 |
|
|
12.00 |
2022.00 |
143.00 |
31.00 |
44926.00 |
216.64 |
688.92 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
551.13 |
0 |
216.64 |
1240.04 |
5.72 |
|
688.92 |
551.13 |
3.18 |
|
688.92 |
0 |
0 |
0 |
688.92 |
551.13 |
1240.04 |
|
|
49.18 |
0 |
0 |
0 |
49.18 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
41 |
Paramètre (Var1) pour T5 (texte) D3 |
|
|
|
|
|
304.00 |
|
2292.50 |
7290.15 |
3.18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
5503.25 |
0 |
2292.50 |
12793.40 |
5.58 |
|
7290.15 |
5503.25 |
3.18 |
|
7290.15 |
0 |
0 |
0 |
7290.15 |
5503.25 |
12793.40 |
|
|
482.28 |
0 |
0 |
0 |
482.28 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
42 |
Type Tarif pour T5 (taxe) D3 |
|
|
|
|
|
|
corr. 304 j. |
2292.50 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
2292.50 |
12793.40 |
5.58 |
corr. 304 j. |
7290.15 |
5503.25 |
3.18 |
corr. 304 j. |
7290.15 |
0 |
0 |
0 |
7290.15 |
5503.25 |
12793.40 |
|
|
482.28 |
0 |
0 |
0 |
482.28 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
43 |
Paramètre (Var1) pour T5 (texte) D3 |
|
|
|
|
|
|
Eco. Brut |
-651.72 |
|
|
0 |
|
|
0 |
|
|
0 |
|
Tarif moy. Tout compris |
|
5.58 |
|
|
2292.50 |
m³ |
|
Economie financier brut |
-2072.47 |
0 |
0 |
-5511.25 |
-2072.47 |
-8.00 |
-2080.47 |
-0.16 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
44 |
Type Tarif pour T5 (conso.) D4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-2080.47 |
|
ECO BRUT |
-651.72 |
m³ |
|
|
1.00 |
0 |
0 |
|
CUMULECOBRUT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45 |
Paramètre (Var1) pour T5 (texte) D4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-0.28 |
|
|
|
|
|
|
|
3.18 |
Tarif moy. |
3.19 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
46 |
Type Tarif pour T5 (taxe) D4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
47 |
Paramètre (Var1) pour T5 (texte) D4 |
|
|
|
|
Depuis début opti. |
123.00 |
|
1119.48 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
|
|
|
|
3559.95 |
Fr. HTVA |
|
|
|
|
|
|
3559.95 |
2202.50 |
5762.45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
48 |
T5 TVA ? |
|
|
|
|
|
|
|
1119.48 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
|
|
|
|
3559.95 |
Fr. HTVA |
|
|
|
|
|
|
3559.95 |
-8.00 |
5762.45 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
49 |
Appliquer T4 et T5 sur l'année en cours |
|
|
|
|
|
|
|
-231.64 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
|
|
|
|
1119.48 |
m³ |
|
|
|
|
|
|
-736.62 |
-2212.50 |
-738.62 |
-0.13 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
50 |
Considérer le coût de la pointe |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ECO BRUT |
-231.64 |
m³ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|