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) |
BN (66) |
BO (67) |
BP (68) |
BQ (69) |
BR (70) |
BS (71) |
BT (72) |
BU (73) |
BV (74) |
BW (75) |
BX (76) |
1 |
v.3.6.2 |
|
|
Nom du mandat : |
FAA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Variables explicatives |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
Conso. Cumul. |
Eco. conso. brute |
Eco. conso. corrélée |
Eco. brute en Fr. |
Eco. corr. totale en Fr. |
Eco. taxes en Fr. |
Eco. en Fr. brut tout compris |
Eco. en Fr. corr. Tout compris |
Total |
Eco. conso. corrélée |
Eco. en Fr. corr. Tout compris |
Total |
Nom du Statmens |
Onglet |
Période début d'optimisation |
Onglet éco. |
Mois |
Année en cours |
Année réf. |
Nb. Relevé |
R |
R² |
Nom Variable |
T |
Nom Variable |
T |
Nom Variable |
T |
Nom Variable |
T |
Nom Variable |
T |
Année réf. Voulue |
Date 1er relevé année de réf. |
1er année du mens. |
Variables explicatives |
|
|
|
|
Année fin statistique |
Date dernier relevé fin statistique |
Date fin stat. actuelle |
Facteur NRJ |
Facteur FR |
réf. |
Conso.TOT |
CoûtTOT |
Conso.TOTréf. |
Conso.TOTcorr. |
Eco.BrutNRJ |
% |
Eco.BrutFR |
%TOT |
Eco.Corr.NRJ |
% |
Eco.Corr.FRv |
Eco.Corr.FRf |
Eco.Corr.FR |
%TOT |
UnitéNRJ |
UnitéFR |
Coeff.UnitéNRJ |
Tarif |
UnitéTarif |
Coefficient |
Tarif affiché |
UnitéTarifAff. |
Mois Mens |
Année en cours |
Année réf. |
3 |
2022.00 |
1.00 |
Chaleur TOT |
634 MWh (301 j) |
+5 MWh ; +0.8% |
+44 MWh ; +7.4% |
+600 Fr. HTVA |
+5'070 Fr. HTVA |
+0 Fr. HTVA |
+600 Fr. HTVA |
+5'070 Fr. HTVA |
5070.00 |
-10 MWh ; -1.8% |
+7'010 Fr. HTVA |
7010.00 |
FAA_01_MensTotal_Chaleur.xls |
Chaleur |
7 |
3DONNEES |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.96 |
0.92 |
Nb. Jours |
3.96 |
NomV3 |
- |
NomV4 |
- |
NomV5 |
- |
geneve.xls |
23.57 |
2017 |
42767.00 |
2016.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020 |
44202.00 |
47848.00 |
1 |
1 |
1 |
633.61 |
73168.54 |
628.40 |
589.74 |
5.21 |
0.01 |
600.00 |
-0.15 |
43.87 |
0.07 |
5070.00 |
0 |
5070.00 |
1.24 |
MWh |
Fr. HTVA |
0.00 |
115.48 |
Fr. HTVA/ MWh |
0.10 |
11.55 |
c./kWh |
10.00 |
2023.00 |
2022.00 |
4 |
2022.00 |
2.00 |
Électricité TOT |
231 MWh (304 j) |
+6 MWh ; +2.5% |
+4 MWh ; +1.8% |
-2'790 Fr. HTVA |
+950 Fr. HTVA |
+0 Fr. HTVA |
-2'790 Fr. HTVA |
+950 Fr. HTVA |
950.00 |
+1 MWh ; +0.5% |
-16'800 Fr. HTVA |
-16800.00 |
FAA_02_MensTotal_Electr.xls |
Elec_TOT |
7 |
ELECTRICITE |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.50 |
0.25 |
Nb Jours |
31.48 |
paramvar1 |
- |
paramvar2 |
- |
paramvar3 |
- |
geneve.xls |
1.90 |
2017.00 |
42766.00 |
2016.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
44196.00 |
69408.00 |
1 |
1 |
2 |
231.21 |
80930.17 |
225.58 |
227.19 |
5.64 |
0.02 |
-2790.00 |
0.71 |
4.03 |
0.02 |
950.00 |
0 |
950.00 |
0.23 |
MWh |
Fr. HTVA |
1.00 |
350.02 |
Fr. HTVA/ MWh |
0.10 |
35.00 |
c./kWh |
10.00 |
2023.00 |
2022.00 |
5 |
2022.00 |
3.00 |
Eau TOT |
4'548 m³ (304 j) |
-524 m³ ; -10.3% |
-575 m³ ; -11.2% |
-1'760 Fr. HTVA |
-1'930 Fr. HTVA |
+0 Fr. HTVA |
-1'760 Fr. HTVA |
-1'930 Fr. HTVA |
-1930.00 |
+41 m³ ; +0.8% |
+160 Fr. HTVA |
160.00 |
FAA_03_MensTotal_Eau.xls |
Eau |
7 |
1DONNEE |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.54 |
0.29 |
Nb Jours |
22.95 |
Var 3 |
- |
Var 4 |
- |
SRE |
- |
Geneve |
-2.17 |
2017.00 |
42766.00 |
2016.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
44196.00 |
47848.00 |
1 |
1 |
3 |
4548.00 |
18088.05 |
5072.00 |
5122.97 |
-524.00 |
-0.10 |
-1760.00 |
0.45 |
-574.97 |
-0.11 |
-1930.00 |
0 |
-1930.00 |
-0.47 |
m³ |
Fr. HTVA |
1.00 |
3.98 |
Fr. HTVA/ m³ |
1 |
3.98 |
Fr./m³ |
10.00 |
2023.00 |
2022.00 |
6 |
2022.00 |
4.00 |
- Chaleur Achetée (gaz+maz.) |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
FAA_11_MensTotalAcheté_Chaleur.xls |
Chal_Achetee |
7 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
2017.00 |
#REF! |
#REF! |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
#REF! |
#REF! |
1 |
1 |
0 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
0.10 |
#REF! |
c./kWh |
#REF! |
#REF! |
#REF! |
7 |
2022.00 |
5.00 |
- Chaleur prod. CCF |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
FAA_12_MensCCF_Chaleur.xls |
Chal_CCF |
7 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
2017.00 |
#REF! |
#REF! |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
#REF! |
#REF! |
1 |
1 |
0 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
0.10 |
#REF! |
c./kWh |
#REF! |
#REF! |
#REF! |
8 |
2022.00 |
6.00 |
- Gaz Buanderie |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
FAA_13_MensBuanderie_Gaz.xls |
Gaz_Bu |
7 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
2017.00 |
#REF! |
#REF! |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
#REF! |
#REF! |
1 |
1 |
0 |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
0.10 |
#REF! |
c./kWh |
#REF! |
#REF! |
#REF! |
9 |
2022.00 |
7.00 |
- Elec. Achetée SI |
142 MWh (304 j) |
-44 MWh ; -23.5% |
-35 MWh ; -19.7% |
-25'100 Fr. HTVA |
-15'300 Fr. HTVA |
-1'080 Fr. HTVA |
-26'180 Fr. HTVA |
-16'380 Fr. HTVA |
-16380.00 |
+10 MWh ; +5.9% |
+5'170 Fr. HTVA |
5170.00 |
FAA_21_MensSI_Electr.xls |
Elec._SI |
7 |
ELECTRICITE |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.42 |
0.17 |
Nb Jours |
9.94 |
Var 3 |
- |
Var 4 |
- |
Var 5 |
- |
geneve.xls |
-0.66 |
2017.00 |
#VALUE! |
2019.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
44196.00 |
47848.00 |
1 |
1 |
0 |
141.56 |
70781.54 |
185.17 |
176.30 |
-43.60 |
-0.24 |
-26180.00 |
6.63 |
-34.74 |
-0.20 |
-15300.00 |
-1080.00 |
-16380.00 |
-4.00 |
MWh |
Fr. HTVA |
0.00 |
500.00 |
Fr. HTVA/ MWh |
0.10 |
50.00 |
c./kWh |
10.00 |
2023.00 |
2022.00 |
10 |
2022.00 |
8.00 |
- Elec. Prod. CCF |
90 MWh (301 j) |
+50 MWh ; +127.0% |
+39 MWh ; +76.7% |
+5'680 Fr. HTVA |
+4'400 Fr. HTVA |
+0 Fr. HTVA |
+5'680 Fr. HTVA |
+4'400 Fr. HTVA |
4400.00 |
-2 MWh ; -3.1% |
#DIV/0! |
#DIV/0! |
FAA_22_MensCCF_Electr.xls |
Elec._CCF |
7 |
ELECTRICITE |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.36 |
0.13 |
Nb Jours |
2.92 |
Var 3 |
- |
Var 4 |
- |
Var 5 |
- |
geneve.xls |
1.14 |
2017.00 |
42767.00 |
2016.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
44202.00 |
47848.00 |
1 |
1 |
0 |
89.65 |
10148.64 |
39.49 |
50.74 |
50.16 |
1.27 |
5680.00 |
-1.44 |
38.91 |
0.77 |
4400.00 |
0 |
4400.00 |
1.08 |
MWh |
Fr. HTVA |
0.00 |
113.20 |
Fr. HTVA/ MWh |
0.10 |
11.32 |
c./kWh |
10.00 |
2023.00 |
2022.00 |
11 |
2022.00 |
9.00 |
- Elec. Buanderie |
5'261 kWh (301 j) |
+1'291 kWh ; +32.5% |
+981 kWh ; +22.9% |
+600 Fr. HTVA |
+460 Fr. HTVA |
+0 Fr. HTVA |
+600 Fr. HTVA |
+460 Fr. HTVA |
460.00 |
+328 kWh ; +7.7% |
+150 Fr. HTVA |
150.00 |
FAA_23_MensBuanderie_Electr.xls |
Elec._Bu |
7 |
ELEC1TARIF |
10.00 |
2023.00 |
2022.00 |
12.00 |
0.39 |
0.15 |
Nb Jours |
9.80 |
NomV3 |
- |
NomV4 |
- |
NomV5 |
- |
geneve.xls |
0.81 |
2017.00 |
42767.00 |
2016.00 |
VRAI |
FAUX |
FAUX |
FAUX |
VRAI |
2020.00 |
44202.00 |
47848.00 |
0.00 |
1 |
0 |
5.26 |
2449.60 |
3.97 |
4.28 |
1.29 |
0.33 |
600.00 |
-0.15 |
0.98 |
0.23 |
460.00 |
0 |
460.00 |
0.11 |
kWh |
Fr. HTVA |
1.00 |
0.47 |
Fr. HTVA/ kWh |
100 |
46.56 |
c./kWh |
10.00 |
2023.00 |
2022.00 |
23 |
4 |
Détail |
- Chaleur Achetée (gaz+maz.) |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
24 |
5 |
|
- Chaleur prod. CCF |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25 |
6 |
|
- Gaz Buanderie |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26 |
7 |
|
- Elec. Achetée SI |
-35 MWh ; -19.7% |
-15'300 Fr. HTVA |
-1'080 Fr. HTVA |
-16'380 Fr. HTVA |
142 MWh |
50.00 c./kWh |
10.2023 / 2022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
27 |
8 |
|
- Elec. Prod. CCF |
+39 MWh ; +76.7% |
+4'400 Fr. HTVA |
+0 Fr. HTVA |
+4'400 Fr. HTVA |
90 MWh |
11.32 c./kWh |
10.2023 / 2022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
28 |
9 |
|
- Elec. Buanderie |
+981 kWh ; +22.9% |
+460 Fr. HTVA |
+0 Fr. HTVA |
+460 Fr. HTVA |
5 kWh |
46.56 c./kWh |
10.2023 / 2022 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|